Understanding CSV Export data (speeds)
Posted: Thu Jun 15, 2023 5:14 pm
Hello,
I do struggle with understanding one speed data column, as it is found in the CSV export.
I was running a recoding to compare "car instrument speed" with "real speed" (GPS reading).
For this, I've locked the car into a number of fixed speeds using the limiter, and wanted to measured OBD2 values and GPS values.
Looking at the CSV file, I've assumed column "SPEED_KPH" to correlate to GPS speed, whilst "WHEEL_SPEED_KPH" would correlate to car instrument speed.
Indeed the green column WHEEL_SPEED_KPH" matches my expectation, as I locked the car into different speeds, running "flat" when measuring.
However, the blue column SPEED_KPH consistently shows higher values above the "WHEEL_SPEED_KPH", which is the opposite of what would be expected. Usually the real speed would be lower the car's instrument speed.
In fact the GPX export from the very same recording, exported together with the .csv, shows expected values, e.g. 32.78 m/s = 118km/h where I locked the car into 120km/h. This is consistent with what I observed when comparing values using navigation apps that show GPS speed.
<trkpt lat="47.563188" lon="8.501499">
<ele>404.6</ele>
<time>2023-06-15T15:28:00.000Z</time>
<course>295.7</course>
<speed>32.78</speed>
<fix>3d</fix>
<hdop>0.4</hdop>
</trkpt>
So now my trouble is understanding, what kind of speed blue column "SPEED_KPH" actually represents.
Can somebody shed some light on this for me, please?
I do struggle with understanding one speed data column, as it is found in the CSV export.
I was running a recoding to compare "car instrument speed" with "real speed" (GPS reading).
For this, I've locked the car into a number of fixed speeds using the limiter, and wanted to measured OBD2 values and GPS values.
Looking at the CSV file, I've assumed column "SPEED_KPH" to correlate to GPS speed, whilst "WHEEL_SPEED_KPH" would correlate to car instrument speed.
Indeed the green column WHEEL_SPEED_KPH" matches my expectation, as I locked the car into different speeds, running "flat" when measuring.
However, the blue column SPEED_KPH consistently shows higher values above the "WHEEL_SPEED_KPH", which is the opposite of what would be expected. Usually the real speed would be lower the car's instrument speed.
In fact the GPX export from the very same recording, exported together with the .csv, shows expected values, e.g. 32.78 m/s = 118km/h where I locked the car into 120km/h. This is consistent with what I observed when comparing values using navigation apps that show GPS speed.
<trkpt lat="47.563188" lon="8.501499">
<ele>404.6</ele>
<time>2023-06-15T15:28:00.000Z</time>
<course>295.7</course>
<speed>32.78</speed>
<fix>3d</fix>
<hdop>0.4</hdop>
</trkpt>
So now my trouble is understanding, what kind of speed blue column "SPEED_KPH" actually represents.
Can somebody shed some light on this for me, please?