Sim Racing Telemetry Docs

Documentation & Knowledge Base

User Tools

Site Tools

Trace:
manual:csv-format

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision 		Previous revision
manual:csv-format [2022/11/16 20:20]
Staff created 		manual:csv-format [2025/04/08 13:24] (current)
Staff Added links on how to customize Microsoft Excel import options.
Line 25: Line 25:
 {{ :manual:srt-csv-import.png |}} {{ :manual:srt-csv-import.png |}}
  
 +To customize the import options in Microsoft Excel, you must import the CSV file using the //Text Import Wizard// (called also //Legacy Data Import Wizards//): [[https://support.microsoft.com/en-us/office/text-import-wizard-c5b02af6-fda1-4440-899f-f78bafe41857|Text Import Wizard]]. See also [[https://support.microsoft.com/en-us/office/import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba|Import data from a CSV, HTML, or text file]].
 ===== Telemetry bins ===== ===== Telemetry bins =====
  
Line 85: Line 86:
 As not all games and tracks have the same number of sectors, exporting each sector as a separated column would produce CVS files harder to parse (the number and names of the columns wouldn't have a fixed layout anymore). As not all games and tracks have the same number of sectors, exporting each sector as a separated column would produce CVS files harder to parse (the number and names of the columns wouldn't have a fixed layout anymore).
 We could add this information in the future (likely "//packing//" the data using a special format). We could add this information in the future (likely "//packing//" the data using a special format).
 +
 +===== Tyre/wheel data =====
 +
 +Data for tyres/wheels are reported with a 0-based index, usually following the front-to-back/left-to-right order.
 +
 +For a 4-wheels vehicle:
 +
 +^ Suffix ^ Description ^
 +| ''_0'' | Front Left (FL) |
 +| ''_1'' | Front Right (FR) |
 +| ''_2'' | Rear Left (RL) |
 +| ''_3'' | Rear Right (RR) |
 +
 +For a 2-wheels vehicle:
 +
 +^ Suffix ^ Description ^
 +| ''_0'' | Front (F) |
 +| ''_1'' | Rear (R) |
  
 ===== Data fields ===== ===== Data fields =====
Line 94: Line 113:
 ==== Unit of Measures ==== ==== Unit of Measures ====
  
-All the exported data use the unit of measures as defined by the standard [[https://en.wikipedia.org/wiki/International_System_of_Units|International System of Units]].+All the exported data use the unit of measures as defined by the standard [[https://en.wikipedia.org/wiki/International_System_of_Units|International System of Units]]. For historical reasons, the only exception is for //temperature// that is measured in [[https://en.wikipedia.org/wiki/Celsius|degree Celsius]].
  
 So - for example - all the velocities are exported in "//metres/second//", while in the application they are converted in more useful units (for example: for the vehicle speed, we convert //m/s// to //kilometres/hour// for the metric system and to //miles/hour// for the imperial system; while we continue using //m/s// for suspension velocities; etc). So - for example - all the velocities are exported in "//metres/second//", while in the application they are converted in more useful units (for example: for the vehicle speed, we convert //m/s// to //kilometres/hour// for the metric system and to //miles/hour// for the imperial system; while we continue using //m/s// for suspension velocities; etc).
manual/csv-format.1668626459.txt.gz ยท Last modified: 2022/11/16 20:20 by Staff

Page Tools