Business Time Tracker uses Microsoft Excel and the SaveToDB add-in as a reporting tool.
You may create and save a new workbook using the Create Report Workbook item in the application menu.
You have to install SaveToDB 8.15 or higher to use the application features and use the add-in for free.
The workbook contains a set of worksheets to get and customize reports.
Here is a report sample:
Here are quick tips to use the application:
- Use the Database tab to work with reports.
- Use the report parameters at the ribbon.
- Use the view list at the ribbon to apply different report layouts.
- Use the save button in the View group to save new report layouts.
- Use the Actions menu at the ribbon to execute related tasks.
- Use the Actions menu in the context menu to drill-down data.
- Use the Open URL menu in the context menu to open URLs or select related worksheets.
The index page allows navigating to any worksheet using the Open URL menu in the context menu.
Also, the Actions menu at the ribbon allows showing and hiding worksheets.
Business Time Tracker records activities using the data from the active window.
Any window always has the active process and the window title.
Business Time Tracker tries to acquire the additional information about the active window: solution, folder, filename, and URL.
For example, the tracker retrieves the active URL from Chrome, Firefox, or Microsoft Edge.
Also, it retrieves the actual filename of the opened document in Microsoft Word, Excel, or Powerpoint.
The tracker retrieves the actual solution and filename from Visual Studio and SQL Server Management Studio. And so on.
You may configure your rules to extract the solution, folder, and filename from the window title.
Business Time Tracker synchronizes these rules across all trackers. So, you specify the rule for a new application once.
The regex expressions must use the named groups like a solution, folder, and filename.
To add a new expression, unhide the patterns worksheet, add the expression, and click the Save button.
Here is a sample:
You may create new expressions by example.
Use the Reparse Titles item of the application menu to reparse titles of the existing data using new rules.
Binding Categories, Projects, and Clients
As described above, the tracker records the process name and window title using data of the active window.
Also, the tracker extracts solutions, folders, filenames, and URLs if it is possible.
However, the most useful data for a company are times and costs by activity categories, projects, and clients.
To get these data, users or analysts have to create binding rules.
The good news is that you may create and change such rules at any time. So, step-by-step, the company get more and more precise data.
To work with the configuration worksheets, click on the Show Lists item in the Actions menu on the index worksheet.
Then add categories, projects, and clients on the category_list, project_list, and client_list worksheets.
Here is a sample of the project_list worksheet that has two projects (SaveToDB and TimeTracker):
Add new items below the table (starting row 7 in the example), specify the sort order, and click the Save button.
In the next step, you may bind items.
Let's bind Visual Studio solutions to the example projects:
- Open the solutions worksheet.
- Select the For binding view in the Views group at the ribbon to unhide the binding columns.
- Click the Reload Data and Configuration or Reload Validation Lists button in the Reload menu at the ribbon to reload validation lists.
- Use drop-down validation lists to bind items.
Here is a sample:
Please note that the SaveToDB add-in updates bindings immediately after the cell change. You do not need to click the Save button.
You may check and edit bindings at the binding worksheet:
You may see that all activity with Visual Studio is bound to the App Development category, and the SaveToDB and TimeTracker solutions are bound to the SaveToDB and TimeTracker projects.
Use the Update Time Categories item in the Actions menu to reapply new bindings.
You may use the view_facts view to get final cube data.
Here is a sample of the projects configured above:
Use the Update Facts item of the Actions menu to update the facts table and reload the data.