Excel
ONE TIMING can transfer real-time, detailed data for individual cars directly into an Excel sheet while the session is ongoing. The Excel cells will automatically fill with the specific values as ONE TIMING captures them.
Live Export
ONE TIMING has the capability to export real-time specific data for each car directly into an Excel sheet during a session. The cells in the Excel sheets will be populated as ONE TIMING scans for the designated values.
You can download the latest Excel Export Template by clicking here.
If you have prepared your Excel Sheet, simply drag and drop the file into the Excel Plugin during a live session. Follow the instructions in ONE TIMING to choose the tabs of the Excel which will be used for the export. By default, ONE TIMING will generate a copy of the Excel that will be automatically filled during the session.
ONE TIMING can not update the Excel sheet while you are manually editing a cell.
The system will store the update in memory and refresh the Excel sheet once you exit the edit mode in Excel.
Session Parameters
| Session | Description | Example |
| {Session.Name} | Session's name if available. | Race 2 |
| {Session.Type} | Session's type if available. | Race |
| {Session.Series} | Session's series if available. | FIAFormulaE |
| {Session.EventName} | Session's event name if available. | Round 11 - Berlin III ePrix |
| {Session.Season} | Session's season if available. | Season 6 |
| {TimeRemaining} | Remaining time in session if available. (HH:mm:ss) | 00:10:03 |
| {TimeAtTrack} | Current time at track if available. (HH:mm:ss) | 14:02:55 |
Car Parameters
For each 'Car' cell, the user can define in the cell's comment an horizontal (H) or vertical (V) offset as well as the background color (one line per option)
| Car ( x=car's number or "Leader") | Description | Example |
| {Car[x].Name} | Car's name if available. | VAN |
| {Car[x].Number} | Car's number if available. | 5 |
| {Car[x].Lap.LapNumber} | Last lap number if available. | 12 |
| {Car[x].Lap.StintNumber} | Last lap stint number if available. | 2 |
| {Car[x].Lap.StintLapNumber} | Last lap number in stint if available. | 4 |
| {Car[x].Lap.Time} | Last lap time if available. (ss.000) | 82.632 |
| {Car[x].Lap.Timestamp} | Last lap timestamp if available. (hh:mm:ss) | 14:03:44 |
| {Car[x].Lap.PowerMode} | Last lap FE power mode if available. | 235 |
| {Car[x].Lap.TrackState} | Last lap track state. Independent from the Timekeeper. | Partial Yellow |
| {Car[x].Lap.TrackStateMessage} | Last lap track state Race Control Message. | YELLOW FLAG IN TURN 8 |
| {Car[x].Lap.Driver} | Last lap driver's name if available. | |
| {Car[x].Lap.Tyre} | Last lap tyre name if available. | |
| {Car[x].Lap.Infos} | Last lap info (IN, OUT) if available. | OUT |
| {Car[x].Lap.ElapsedTime} | Last lap elapsed time if available. (HH:mm:ss) | 00:07:57 |
| {Car[x].Lap.StartOfRace} | Start of Race if available. (HH:mm:ss) | 14:00:00 |
| {Car[x].Lap.Sector[y]} | Last lap time for sector 'y' if available. (s.fff) | 26.429 |
| {Car[x].Lap.Speed[y]} | Last lap speed for sector 'y' if available. | 121 |
| {Car[x].Lap.pitexit} | Time of day car crossed pit exit line | 12:31:56.958 |
| {Car[x].Lap.pitentry} | Time of day car crossed pit entry line | 12:31:56.958 |
| {Car[x].Lap.speedtrap} | Speed trap value | 222.1 |
| {Car[x].Lap.Position} | Overall car position | 5 |
| {Car[x].Lap.GapBehindOnTrack[y]} | Gap to car behind on Sector Y | 22.1 |
| {Car[x].Lap.GapAheadOnTrack[y]} | Gap to car ahead on Sector Y | 22.1 |
Offsets
Basic equations can be used like 'V{StintNumber}*14+{StintLapNumber}'
| Extra attributes | Description |
| V{LapNumber} | Define a vertical offset based on the lap number |
| V{StintNumber} | Define a vertical offset based on the stint number |
| V{StintLapNumber} | Define a vertical offset based on the lap in stint number |
Coloring
| Extra attributes | Description |
| B{TrackState} | Color the cell based on the track state. |
| B{Car} | Color the cell based on the driver. |