Have you ever wanted to pull your time and expense data into Excel for analysis? Now you can, with the XLST Excel Add-in. (scroll down for a video)
XLST is a new Excel add-in that pulls timesheet and project management data from your Standard Time® timesheet, and puts the results into Excel spreadsheets. It uses Excel formulas to extract timesheet data, and places the results into a single cell. In fact, the XLST functions act exactly like any other Excel function. They take “parameters” from other cells and use that data to get results.
What kinds of results can you get?
You can query the Standard Time database for all the actual work entered by employees. Or, you could query for all the expenses. Or all time off taken by employees. Or the hours available for time off.
Here is a partial list, which might spark your imagination:
- XLSTActualWork
- XLSTActualSalaryCost
- XLSTActualClientCost
- XLSTExpenseTotal
- XLSTTimeOffHours
- XLSTTimeOffAvailable
- XLSTScheduledHours
- XLSTExceedDailySchedule
- XLSTExceedWeeklySchedule
- XLSTProjectTaskScheduledHours
- XLSTProjectTaskDuration
- XLSTProjectTaskActualWork
- XLSTProjectTaskPercentComplete
- XLSTProjectTaskModified
- XLSTPayPeriodStart
- XLSTPayPeriodEnd
- XLSTEmployeeTimesheetApproved
- XLSTEmployeeTimesheetSubmitted
- XLSTEmployeeExpensesApproved
- XLSTProjectClientRate
- XLSTProjectSalaryRate
- XLSTEmployeeClientRate
- XLSTEmployeeSalaryRate
- XLSTCategoryClientRate
- XLSTCategorySalaryRate
- XLSTProjectManager
Just click in an empty cell and then click the function icon near the formula line. Then choose XLST as the category. You’ll see all the functions listed above. Each one takes different parameters. Many parameters are optional, so you can quickly get results right away.
You must start by downloading Standard Time from the stdtime.com website, and then connecting it to SQL Server. XLST requires SQL Server or SQL Express. Once ST is connected to SQL, then you can download and install XLST.
Watch the video to get started.