In WinDarab vehicle setupsheets can be created and maintained to correlate data with car changes. Setupsheet values can be used in data analysis for viewing and calculations.

• Setupsheets
  • What are setupsheets?
  • Folder Layout Options
  • Setupsheet Creation
    • Manual Creation
    • Programmatic Creation
      • Notes
      • Example XML Format
  • Using Setupsheet Channels For Data Analysis
    • Using Values in Plots and Math
    • Changing existing Setupsheets
  • Example: Setupsheets & Telemetry

If a file is opened, WinDarab looks for the file “Setupsheet.xml” starting in the folder of the file and all folders up to the root. If a setupsheet is found, the setupsheet is applied to the file.

A setupsheet contains sections with CAR elements. A CAR element contains a file name pattern attribute which is used by WinDarab to determine which CAR element is used for a certain file.

A CAR element contains CHANNEL elements which are used to define virtual channels.

Each CHANNEL element contains one or more OUTING elements, which define the channels value for the given outing.

WinDarab is now creating/updating a virtual channel and puts the found outing value into this channel (at least at each beginning of a lap or file)

Example Folder Layout:

C:
└── Data
    └── 20190325 - Sebring
        ├── Chassis 1
        │   ├── Setupsheet.xml
        │   ├── Chassis 1 Outing 1.bmsbin
        │   └── Chassis 1 Outing 2.bmsbin
        └── Chassis 2
            ├── Setupsheet.xml
            ├── Chassis 2 Outing 1.bmsbin
            └── Chassis 2 Outing 2.bmsbin

Alternate Folder Layout:

C:
└── Data
    └── 20190325 - Sebring
        └── Setupsheet.xml
            ├── Chassis 1 Outing 1.bmsbin
            ├── Chassis 1 Outing 2.bmsbin
            ├── Chassis 2 Outing 1.bmsbin
            └── Chassis 2 Outing 2.bmsbin

There are two main ways to create setupsheets.

1. Manually via the WinDarab Gui
2. Programmatically from an existing Excel sheet or other source (XML File).

To create a setupsheet:

• Click on the Setupsheet icon in the ribbon under Tools → Mathematics
• Right Click on the <filename> in the File Explorer

	Or

This will open the setupsheet creation and editing interface. Rename your setupsheet as desired then click to add channels.

Add and configure properties for all channels to be used. Channels can be added or edited later from the same window.

To finish inserting initial values add an outing, add setupsheet values, and Save & Close.

• The hierarchical order of CHANNEL and OUTING elements can be switched.

• Currently there’s no UI to edit the “Setupsheet.xml” this will come in the future.

• If a persistent virtual channel is defined by the setup sheet, WinDarab checks and (if necessary) updates the saved channel data.

• Changes to the setupsheet.xml are automatically detected and used to update the virtual channels immediately!

The following attributes are supported:

Note:

• To match all files use the Filename pattern: '*'

<!-- One way -->
<SETUPSHEET>
  <CAR Filename="Chassis 3*">
    <CHANNEL Name="packer_fl" Unit="mm" Format="5.2" Min="18" Max="20" Persistent="True">
      <OUTING Value="108">18.5</OUTING>
      <OUTING Value="109">19.3</OUTING>
      <OUTING Value="106">19.2</OUTING>
    </CHANNEL>
    <CHANNEL Name="packer_fr" Unit="mm" Format="5.2" Persistent="True">
      <OUTING Value="107">18.5</OUTING>
      <OUTING Value="108">19.5</OUTING>
    </CHANNEL>
    <CHANNEL Name="packer_rl" Unit="mm" Format="5.1" Persistent="True">
      <OUTING Value="108">19.5</OUTING>
      <OUTING Value="109">19.2</OUTING>
    </CHANNEL>
    <CHANNEL Name="packer_rr" Unit="mm" Format="6.3" Persistent="True">
      <OUTING Value="107">18.5</OUTING>
      <OUTING Value="108">19.5</OUTING>
      <OUTING Value="109">19.2</OUTING>
    </CHANNEL>
  </CAR>
</SETUPSHEET>

<!-- Other way -->
<SETUPSHEET>
  <CAR Filename="Chassis 3*">
    <OUTING Value="107" >
      <CHANNEL Name="packer_fl2" Unit="mm" Persistent="True">18.5</CHANNEL>
      <CHANNEL Name="packer_fr2" Unit="mm" Persistent="True">18.5</CHANNEL>
      <CHANNEL Name="packer_rl2" Unit="mm" Persistent="True">18.5</CHANNEL>
      <CHANNEL Name="packer_rr2" Unit="mm" Persistent="True">18.5</CHANNEL>
    </OUTING>
    <OUTING Value="108" Persistent="True">
      <CHANNEL Name="packer_fl2">18.0</CHANNEL>
      <CHANNEL Name="packer_fr2">18.0</CHANNEL>
    </OUTING>
  <CAR>
</SETUPSHEET>

For the Setupsheet values to be used in data analysis two conditions must be met:

1. The setupsheet CAR attribute Filename must match the BMSBIN file name. Wildcards can be insterted with asterisks (*). Screenshots in the Manual Creation section show the Filename as "*Data 1", this allows files whose name ends with "Data 1" to match with the setupsheet

2. The setupsheet file must contain the outing number to match the dataset outing number. Outing numbers can be manually edited in the Setupsheet GUI by clicking on an outing number. An outing number value of '0' can be used as a 'global' or 'default' value for the setupsheet

Setupsheet channels shown as "Virtual Channels", persistence can be set with the channel properties. These Virtual Channels can be used the same as all other virtual channels in functions, conditions, and plots.

Setupsheets can be updated by opening the Setupsheet GUI and clicking on values to be changed. Channels and outings can be edited, added, or deleted at any time.

As of WinDarab 7.7.003, Setupsheets can be used with Telemetry

Prerequisites:

1. Setupsheet file must exist in the %WinDarab Install Directory% / Config / WDServer directory
   • The easiest way to do this is to use File Explorer → Setupsheet
   • 
2. WinDarab needs to know what Outing and Lap Special Channels your telemetry stream is using.
   • These are probably laptrigger_outcnt_dls and laptrigger_lapcurr_dls
   • 
   • 

Verify your special channels settings are correct with your telemetry stream connected if your File Explorer looks similar to this: