Skip to main content

Workbook & Layout

Workbooks and worksheets allow the user to better organize the data visualization into the software. A layout allows you to save the configuration of the workbooks and worksheets currently on screen so it can be reloaded in the future or shared with other users. Workbooks and layouts are controlled from the Workbook tab of the ribbon bar


After clicking the Add Workbook button a new blank workbook will appear. It can be seen as a new instance of HH Data Management but connected to the same database. It is usually used to organize your layout on multi-monitor.

A workbook can be saved using the Save Current Workbook button which will create a .dmwb file. Workbooks can be loaded into a current layout by using the Load Workbook button.


After clicking the Add Worksheet button a new blank worksheet will appear with a tab at the bottom of the software.

Double click on the name to edit the worksheet name.

Worksheets can be reordered by dragging them left or right.

Worksheets can be duplicated and the background and foreground colours of the tabs can be edited by right clicking on the tab.

A worksheet can be saved using the Save Current Worksheet button which will create a .dmws file. Worksheets can be loaded into a current layout by using the Load Worksheet button.

  • Saving and loading workbooks and worksheets separately from layout can be useful to share between different users. For example, we user could be working on some KPIs visualization page that he could share to his teammates without having to share his entire layout.
  • Using worksheet coloring and icons in the name can help to personalize the layout and help with navigation. Here is an example:


A layout contains all your workbooks and worksheets. It can be saved as a file and loaded so it can be restored at any time.

HH Data Management automatically saves the state of your layout every five minutes to an "Autosaved Layouts" folder that can be restored from should you ever forget to save your layout. This folder can be found by going to the Support tab and clicking "Open client.db location".

To save a new layout, click on Workbook and then Save Layout. The Save Layout As button can be used to save the current layout in a different file. The layout is saved as a .dmlay file.

Layout options


The backstage is accessed by clicking File in the top left of HH Data Management:


A list of recently used layouts can be found on the Home tab of the backstage. Double-clicking on a layout will load it.


The sync tab shows information and allows for changing settings related to the connection to the HH Data Management server:

In general these settings shouldn't need to be changed from their default values.


The options tab allows various options to be changed.

Some of the options are self explanatory, explanations for the options are only provided here if they add extra information.

Global options

The global options represents options that are global to the full account. Changing those options will affect every users from the account. The global options is only available to users with access to the admin node in the client UI rules.

Account ID

The account ID can be copied from here. This may be needed when working with the API or plugins.

Account image

The account image is displayed on reports generated from the software.

Run plan mode

This is the default mode used for the run plan

Fuel count direction

This is the default fuel count direction for new events like described in event data

Default sectors per track configuration

This is the default number of sectors that will be added to each new track configuration that is created (the sectors can be manually modified after creation).

Auto-Populate run air/track temps

If this is enable, the closest weather measurement from the start time of the run will be copied into the runsheet weather values.

Auto-Populate run air/track temps threshold

Maximum delta time between run start time and weather measurement time to take the value into account in the runsheet.

DMI - Copy from previous run

If this is disable, the DMI will not create automatically new runs. The user will have to create the run manually.

RunSheet Setup in tab

If this is enable, the runsheet setup will be displayed in one right panel tab. If not it will be displayed at the right side of the tabs and will be always visible.

Local options

Unit scheme

The unit scheme of the software is used to determine the behaviour of the software when typing information in text boxes with pressure information. If set to metric the software assumes the pressure is in bar and if the user enters a value like 180, then it will auto convert the value to 1.80. Conversely, if it is set to imperial then no manipulation of the entered data will be done.


HH DM currently supports two themes (Colorful and Dark).

Log math channel errors

If this is enabled then all errors generated when creating and processing math expressions will be written to the log file. This can be useful when trying to troubleshoot math parameters that are not working. This is disabled by default as it can write a lot of data to the log file which can slow the software down.

Ask to save layout on close

When this options is enabled and the user closes HH DM, there is a pop up asking if the current layout should be saved before closing HH DM or not.

Load layout on startup

Controls if HH DM should load the last used setup on startup or start with a blank layout.

Autosave layout

If this is enabled then every 5 minutes the current layout will be saved automatically, overwriting the layout file HH Data Management launched with.

Max width

Controls the max width of the run selection panel in the runsheet

Wrap text

Controls if the text in the run selection panel in the runsheet should be wrapped if it exceeds the max width or not.

Max parallel uploads

Limits the number of parallel attached file uploads. When uploading attached files, HH DM cuts the files into chunks of max 5MB and uploads those file parts. This is done to make the uploads more robust (especially when the internet connection is slow/unstable). If for example two files with each 20MB are uploaded at the same time, HH DM will upload 8 (2 x 20MB / 5MB) file parts under the hood. The default setting is 3 and for the most applications there is no need to tweak it.

Max parallel downloads

Limits the number of parallel attached file downloads. Unlike for uploads the downloads are not cut into parts.

Display cache status

Show the status of loaded caches in the status bar

Display uploads/downloads status

Show the status of current uploads/downloads in the status bar. Note that for uploads the status doesn't show the number files currently uploading, but the number of file parts (see Max parallel uploads). If the number of uploads/downloads exceeds the max parallel number, then the number of active transfers is shown next to the number of waiting transfers in brackets. For example 3 (20)/0, would mean that currently 3 file parts are uploading and 20 file parts are in the queue to get uploaded once the active ones complete.

Compute size of event/car attachments

For each event the user is subscribed to, and for each car of that event the user has access to, compute and display the size of all the attached files downloaded locally. If enabled, this information is displayed on the Subscription view.


The support tab has three buttons that will help to carry out certain tasks if needed for support purposes.

Auto update

Please see the auto update section.


The about tab contains some basic information about the current software version and what plugins are installed.

API Integration

The API integration tab allows for the authentication mode of the API to be set. HH Data Management needs to communicate with the API for mileage calculations. If OAuth is selected then a browser window will pop up asking the user to log in using the same username/password as used when accessing the website. If API Key is selected then an API key should be entered.

Cache status

The cache tab contains some information on what caches are loaded in the software, and also shows the time taken to load each cache, and which views requested the cache to be loaded first.


Management caches have the ability to be selectively loaded. This enables users that are a member of several accounts to only load the account they are working on, which saves time when the software is launched. Options changed here are only applied after a restart of HH Data Management.