“You can’t use a timesheet and a spreadsheet together!” That used to be the old saying…
Not anymore. (see video below)
Timesheets and spreadsheets have finally made up. They’re friends again with the new Excel® Add-on named XLST. XLST pulls timesheet data directly from your Standard Time timesheet and puts it into your Excel spreadsheet. This video shows how. Essentially, you’re using Excel formulas to query the ST database, and putting the results into cells. Each cell uses one formula. The results of that formula come from the ST database. You supply parameters for each cell formula, which results in different data for each cell.
For example: Cell A1 might use employee ‘Buzz’ while A2 might use ‘Fred’. Since you’re supplying different data to the same formula, the results will change. That means you can build tables of data in a spreadsheet. Use those cells for pivot tables in Excel.
The data is always hot. You simply open the Excel spreadsheet and the Add-on pulls data in from the Standard Time database.
Go ahead and take a look at the video. It’s pretty nice.