SpecSheet

Introduction

Especially in motorsports, SpecSheets are used to store Meta-data containing various information about vehicle setup, weather, or drivers’ parameters during a race weekend or testing.

For each measurement there is an individual SpecSheet, which makes it possible to, for example, document vehicle setup changes from measurement to measurement in the SpecSheets.

See chapter SpecView.

Important

SpecSheets are always stored in respective measurement folder as .HED file.

Beside racing parameters, 2D also stores download information as well as other measurement related information inside SpecSheets.

See chapter Default Entries.

SpecSheets are generated at every data download (=reading the data from the data logger or USB stick) in measurement folder and users can create predefined SpecSheets.

At download the software automatically checks if a predefined SpecSheet (also called permanent SpecSheet) is available. If so, all entries of the predefined SpecSheet are used for the creation of individual measurement related SpecSheet in measurement folder.

See chapter Permanent SpecSheet.

Therefore, for multiple vehicles with different setup parameters, different predefined SpecSheets can be prepared.

Also, a User-interface can be shown at download that the user is forced to enter values, setup parameters or comments at every data download.

See chapter User Interaction.

The user of the software – the engineer, the data recording man, or the mechanic – is in charge of the maintenance and integrity of the data.

Mostly this SpecSheet is only used for documentation, but it can also be used in connection with the CalcTool because the CalcTool can read from information as constant from the SpecSheet and write information back into it.

E.g., the input values of a mass calculation of vehicle can be completely managed by SpecSheet entries.

See chapter CalcTool.

Via SpecSheet is also possible to document for which distance several parts of a vehicle were used.

See chapter Mileage.

Finally, SpecSheet entries can be used for exports

See chapter Export.

SpecView

The SpecSheet of one or multiple measurements can be opened in SpecView by either clicking on SpecView toolbar icon or using short-cut [Alt]+[i] in Analyzer or WinARace.

_images/SpecSheet_ToolbarIcon.png

Toolbar Icon

For every opened (Analyzer) or selected measurement (WinARace) the SpecSheet is opened in SpecView. Basically, a SpecSheet is a text-based HED-file, which can be also opened and edited by an Editor.

_images/SpecSheet_SpecView.png

Clicking on a group, the submenu is opened where the different groups can be selected.

When loading SpecSheets from multiple measurements, the differences to SpecSheet in first column are highlighted in red:

_images/SpecSheet_HighlightDiffs.png

Differences in SpecSheets are highlighted in red

By double-clicking in one field, also the entries can be changed. When one entry needs to be applied to each SpecSheet with holding key [Shift] + [tab] the selected entry is duplicated to the fields on the right.

General

Creating new groups

The values of the different entries can be edited via SpecView but when creating completely new entries or new groups, a SpecSheet must be opened in text editor.

Display all entries of a group

Sometimes in SpecView not all entries of a group are shown, it can be either scrolled down in group or [Shift]+[+] can be used to show more entries.

2D SpecSheet entries

Comment group

At SpecSheets also one group can be used to add comments to the respective measurement related SpecSheet which really helps later on to quickly distinguish different measurements.

Open comment window automatically at every download
_images/SpecSheet_Comment.png

Quickinfo / [Comment] group

The 2D software can be set, that at every download of a measurement the comment window is opened automatically.

Important

Comment interface can be closed with OK without any entry.

Activate displaying of comment window after download:

WinARace –> Settings –> System –> check box Open quick info for each new measurement

Open comment window manually

To open to comment window manually, the respective measurement has to be selected in WinARace and [ALT]+[Q] hast to be pressed.

2D Default entries

[DOWNLOAD]

LapMeter [m]=4450

Lapmeter of this MES

Date=22.0907

Download-Date

Time=085509

Download-time

Run total [s]=0

Download information

Run recording [s]=0

Start of download=07.09.2022 08:55:09

End of download=07.09.2022 08:55:09

Number of errors=0

Time to decompress=0.0 sec

Loggername=FS20

Logger name

Logger serial=2765125A

Serial number of logger

Mileage calculated=(44 km)

Calculated mileage value of this MES

MainSamplingRate=1000

Logger main sampling rate

DL folder=C:\TMP\OneFileRec0003.DL

Raw measurement data directory

[INFO_2D]

Computer=FLORIAN-NOTEBOO

Computer used for data download

Computer user=fs

Computer user at download

Licence name=Flo

2D-Licencse name

Licence level=Team licence

Licences level

CRC=00AA36F9

[Laptimes]

Fastest lap=2:07.515

Fastest lap from all laptimes of this MES

0=2:52.329

Laptimes of this MES

1=2:08.719

2=2:09.009

3=2:08.041

4=2:07.515

5=2:08.585

6=2:08.355

7=2:12.685

8=2:08.477

9=2:54.885

[CalcTool]

Cal Files which were applied to measurement data

Toolchain entries

2D GPS Post-processing

Documentation reference

For more information about 2D GPS Postprocessing please see the respective manual at download area on 2D website:

http://2d-datarecording.com/downloads/manuals/

[GPS]

Rate=10

Detected GPS/GNSS sampling rate in [Hz]

Version=21.0607

Version of GPS Postprocessing toolchain (7:sup:th June 2021)

MaxDropOutTime=30

GPS dropouts not longer then 30 seconds are interpolated

ChannelRate_Hi=100

High rate of GPS postprocessing toolchain

ChannelRate_Lo=10

Low rate of GPS postprocessing toolchain (= Rate)

ShiftTime=-0.21

Shift time GPS/GNSS channels were shifted by GPS post-processing toolchain

AverageMulti=4

Dynamical filtering value

[MES]

Entries are required for GoPro AutoSync

Date_Mes=22.0907

GPS/GNSS date of measurement (7:sup:th Sepemper 2022)

SOD_Mes_FV=23385.6

First UTC-Second of Day (SOD) value of measurement

SOD_Mes_LV=24627.6

Last UTC-Second of Day (SOD) value of measurement

[Time]

[MES] group values converted to HHMM values with CAL-files SOD_Reverse.CAL

Date=22.0907

GPS/GNSS date of measurement (7:sup:th September 2022)

HHMM_FV=6.29

First UTC-HHMM value of measurement (6:29 am)

HHMM_LV=6.5

First UTC-HHMM value of measurement (6:50 am)

Permanent SpecSheet

Pre-Download

Predefined, so-called permanent SpecSheets, are stored in the data directory (RaceData / one directory above the event folders) and start with P_.

These permanent SpecSheets can be assigned to different loggers by naming them (P_Loggername) and store them in data directory.

When downloading measurement data, the software checks whether there is a SpecSheet matching the logger name in the data directory. If a predefined, permanent SpecSheet is found, it is copied, filled with 2D default information, renamed to establish the link to measurement and stored in the respective measurement folder as measurement SpecSheet.

_images/SpecSheet_PermanentSpecSheet.png

Permanent SpecSheet

Important

Measurement related SpecSheets are generally called SpecSheet!

Important

If no matching permanent SpecSheet is found during download only a SpecSheet with 2D default information is created in measurement folder

When using more than one vehicle at a team it is very helpful to use permanent SpecSheets for documenting the individual vehicles parameters (suspension settings, engine settings, …).

Important

If a suspension setting change (or any other parameter, which is documented via permanent SpecSheet) was made, the user of course must also adapt the changes in the respective permanent SpecSheets that the file is prepared for next data download.

For open all permanent SpecSheets from the currently used WinARace-installation the following toolbar button can be used:

_images/SpecSheet_PermanentSpecSheet_Icon.png

Toolbar Icon Permanent SpecSheet

Important

The toolbar can also be modified to only open one respective permanent SpecSheet via a button.

Example

A team has two riders (FS #20 & JR #91) with each one bike.

The loggers of the two measurement systems are called FS20 and JR91.

On the computer which is used for downloading, two permanent SpecSheets p_FS20.HED and p_JR91.HED are located.

_images/SpecSheet_PermanentSpecSheet_FS20.png

Permanent SpecSheet Logger FS20

_images/SpecSheet_PermanentSpecSheet_JR91.png

Permanent SpecSheet Logger JR91

Beside the different information from the RIDER group, also various other parameters, like SHOCK and FORK parameters, can be documented in the respective permanent SpecSheets.

Click here to open 2D example permanent SpecSheet for racing use

Important

The permanent SpecSheets must always be stored inside the directory right before the .MES directories!

User Interaction

Pre-Download

This functionality can be used to open individually definable dialog at every download that the user is forced to enter values to a predefined set of SpecSheet groups from permanent SpecSheet.

Attention

Groups to be accessed in User interface must be available in permanent SpecSheet!

SpecSheet information are always very helpful for documenting measurement related information (Comment or Vehicle).

SpecSheet information are not only used for documentation but also via CalcTool it is possible to access SpecSheet values for calculations (Rider.Mass, e.g., for summing vehicle mass + rider mass) or defining names of exports (ProBike_Street600_KA-DD-123.txt)

The default entries of this dialog can be predefined in permanent SpecSheets, so that when downloading data, always the logger name related permanent SpecSheet is taken.

The information with which logger the data is recorded is stored inside raw measurement data

When closing the dialog all entries are written to the measurement related SpecSheet!

_images/SpecSheet_UserInteraction1.png

User Interaction - Shown window

_images/SpecSheet_UserInteraction2.png

User Interaction - SpecSheet opened in Editor

Important

It is possible to display the user interface parameters either predefined or completely empty.

Important

The user interface can only be closed if a value has been entered in each entry shown.

Setup AutoFillSpecSheetAtDownload:

  1. Open WinARace and open Folders - Protocols folder via WinARace-Tab Settings and open Application data directory by clicking on the button with respective path

Important

Instead of opening Folders – Protocols also shortcut [CTRL]+[ALT]+[D] can be used with WinARace opened!

  1. It must be distinguished between downloading from internal logger memory and downloading data from USB Stick now:

    Downloading data from internal logger memory: Open WinIt.ini

    Downloading data from USB Stick: Open Decompress.ini

Important

.ini-files can be opened and edited with any text-editor!

  1. Navigate to group [Special] and set entry FillSpecGroupAtDownload to 1 to activate AutoFillSpecSheetAtDownload.

    [Special]

    FillSpecGroupAtDownload = 1

  1. Navigate to group [SpecGroupsToEnterAfterDL] and set which predefined SpecSheet groups should be opened automatically at downloading data:

    [SpecGroupsToEnterAfterDL]

    1=Comment

    2=Rider

    3=Vehicle

Attention

Only the defined groups, which are existing in defined permanent SpecSheet, are shown after download in an stay-on-top dialog with all in permanent SpecSheet defined entries!

Attention

Every box of the dialog has to contain a value!

  1. Save ini-file

  2. Execute a test download if user dialog is shown correctly

  3. After confirming the dialog with OK, all entered information are written in the measurement related SpecSheet!

Mileage

Post-Download

The 2D software system provides a possibility to document via SpecSheet, for which distance several parts of a vehicle were used.

Addtional manual

For more information about Mileage function see manual Mileage!

CalcTool

Post-Download

Within CalcTool the channels recorded by a 2D data acquisition system can be further processed with the help of text-based calculation files to e.g., visualize data for development purposes in various plots provided by the 2D software or for further calculations.

Further processing includes among others:

  • Mathematical calculations

  • Trigonometrical calculations

  • Filtering

  • Bit manipulation operations

  • Signal analysis (Min, Max, Average, …)

Addtional manual

For more information about using SpecSheet entries for post-processing calculations see here!

Read access

CalcTool is able to read values from SpecSheet entries as calculation variables (constant values) to use them for calculations.

Important

SpecSheet-read-values are then available as constant values in measurement.

This is very helpful for gear calculations (gearbox settings are done via (permanent) SpecSheet), mass calculations (adding vehicle mass, fuel mass, …) together for further calculations.

Write access

Calculational results can then also be written (new entries can be created or already existing entries can be overwritten) to measurement related SpecSheet (not to permanent SpecSheet), what is important when using the SpecSheet print and export functions.

Important

When writing values to SpecSheet only one value type of a channel (Last value, first value, minimal value, maximal value or average value) can be written!

Print

Post-Download

The report function provides an easy way to define and print SpecSheet groups as targeted report for specific users.

For example a race mechanic might be only interested in the groups he is working on (take the groups BIKE, FORKSET, SHOCKSET, ENGINE or SETTING)

Export

Post-Download

Naming exports

SpecSheet entries can also be used for naming exported files of various 2D tools (MinMax-Export, XY-Plot-Export, …).

Filling defined excel sheet

Also, the SpecSheet entries can be used as placeholders, that a customer can create a excel file where different values or gauges can be filled with.

2D uses this tool for internal analogue channel testing of loggers, where first the calculational results from CalcTool are written into SpecSheet and then the entries are used for creating an predefined Analog-Test-ExcelSheet as documentation about any tested logger.

These created ExcelSheets can also be printed automatically via 2D software.

_images/SpecSheet_NamingExport.png

Excel Export sheet filled by SpecSheet values

Important

For more information please contact 2D via contact form on website!

For racing this feature would be interesting to define a racing-based ExcelSheet where Laptimes, Sectimes, calculated values like information about throttle grip actuation, mappings used and further more can be displayed.

With 2D software automation, this defined ExcelSheet can be created and printed by the software automatically after data download.

Appendix

Permanent SpecSheet example

Click here to open 2D example permanent SpecSheet for racing use

2D_3ax_FilterAndRotate

Default entries for 2D_3ax_FilterAndRotate toolchain

https://2d-datarecording.com/Downloads/Manuals/AC-DOC_2D_FilterAndRotate.pdf

[Sensor_1]

Name=Debug

Rot_x=0

Rot_y=0

Rot_z=0

Cor_x=0

Cor_y=0

Cor_z=0

[Sensor_GPS]

Name=GPS/GNSS2CAN

Rot_x=0

Rot_y=0

Rot_z=0

Cor_x=0

Cor_y=0

Cor_z=0

[Sensor_ROT]

Name=Helmet

Rot_x=0

Rot_y=0

Rot_z=0

Cor_x=0

Cor_y=0

Cor_z=0