Live excel export
Be careful to don't sync your runsheet on onedrive or similar services.
There is a conflict in Excel in some culture like German, Spanish or Italian. That leads to some wrong values for your lap times and sector times. To avoid that, we recommend to switch th english culture in windows parameters or to remove the dot as thousand separator in additional culture parameters
The live Excel data export allows you to export timing data to Excel in real-time while connected to the timing and scoring feed. This is useful for populating a custom run sheet and can be used for custom fuel/strategy calculations. Data available for export include raw data from the timing feed as well data post-processed by HH Timing, in a range of formats where appropriate.
To set up an Excel export you must first either create a new Excel export profile or import an existing one. Once the profile has been added to the project it will automatically open. The Excel Workbook parameter should be the path to an Excel workbook that will be used for the export.
The video tutorial below explains how to create, configure and make the live Excel export:
Parameter export frequency
The following parameters are exported at the end of each lap:
- Lap number
- Elapsed time
- Lap time
- Driver
- Position
- Position in Class
- Track status
- Driving time (current driver)
- Stint lap number
- Moving Average
- Leader Lap Time
- Class Leader Lap Time
- Estimated Total # of Laps In Race
The following parameters are exported at the end of a sector or upon a speed trap crossing:
- Lap Number
- Sector times
- Non Track Sector times
- Speed traps
- Gap to Car Ahead
- Gap to Car Behind
The following parameters are exported at the end of a lap when applicable:
- Pit stop time [Lap]
- Time of pit in [Lap]
- Time of pit out [Lap]
The following parameters are exported after a pit stop:
- Pit stop time
- Time of pit in
- Time of pit out
- In driver
- Out driver
- Pit stop lap number
- Fuel Only/Fuel & Tyres
- Pit Bit
The following parameters are exported at the end of a stint (at pit-in):
- Stint length (# of laps)
Additional sectors
If you added sectors in your championship configuration, or if Non-Track Sectors are being sent in the feed (like Porsche, Ford, T6, T7 sectors in Le Mans), you can export them by using NTSx parameters. You need to enter the number of Non Track Sector in the Backstage options.
Macro
The Excel export is capable of calling VBA macros that perform functions within the Excel sheet being exported to. These macros can be called either when a new worksheet is created (when Auto Worksheet mode is enabled) or each time a new value is written to Excel.
In the case that a user wanted a macro to write the string " Written" to cell A1 in Sheet1 every time a value was exported from HH Timing to the Excel sheet. The VBA code to achieve this is shown below:
In HH Timing, the VBA function should be referenced like this in order to be called:
Run sheet example
HH Development developed a simple excel spreadsheet to use in conjunction with the excel export function of HH Timing.
The excel run sheet can be downloaded here.
The template to load in HH Timing can be downloaded here.
Steps to get started:
- Download the template for HH Timing
- Import the Profile in HH Timing
- The template will be available on the tree. Double click to open it.
- Once the template is open you will have the change path of the excel to the path where you downloaded the excel run sheet.
