Getting Time Tracking Reports

Getting Time Tracking Reports

Gartle Time Tracker uses Microsoft Excel and the SaveToDB add-in as a reporting tool.

You can 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.

Report Workbook

The workbook contains a set of worksheets to get and customize reports.

Here is a report sample:

Gartle Time Tracker Workbook - Processes

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.

Index Page

The index page allows navigating to any worksheet using the Open URL menu in the context menu.

Gartle Time Tracker Workbook - Index

Also, the Actions menu at the ribbon allows showing and hiding worksheets.

Parsing Titles

Gartle Time Tracker records activities using the data from the active window.

Any window always has the active process and the window title.

Gartle 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 can configure your rules to extract the solution, folder, and filename from the window title.

Gartle 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:

Gartle Time Tracker - Title Patterns

You can create new expressions by example.

Here is Regular Expression Language - Quick Reference.

Also, feel free to contact us at to add the support of your application to Gartle Time Tracker.

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 can 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):

Gartle Time Tracker - Project List

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 can bind items.

Let's bind Visual Studio solutions to the example projects:

  1. Open the solutions worksheet.
  2. Select the For binding view in the Views group at the ribbon to unhide the binding columns.
  3. Click the Reload Data and Configuration or Reload Validation Lists button in the Reload menu at the ribbon to reload validation lists.
  4. Use drop-down validation lists to bind items.

Here is a sample:

Gartle Time Tracker - Binding Example

Please note that the SaveToDB add-in updates bindings immediately after the cell change. You do not need to click the Save button.

You can check and edit bindings at the binding worksheet:

Gartle Time Tracker - Binding Table

You can 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.

BI View

You can use the view_facts view to get final cube data.

Here is a sample of the projects configured above:

Gartle Time Tracker - Facts

Use the Update Facts item of the Actions menu to update the facts table and reload the data.