- Posts: 2
VDR for post race analysis of boat performance vs Polar
- johnp
- Topic Author
- Offline
- New Member
Less
More
1 year 5 months ago #1953
by johnp
VDR for post race analysis of boat performance vs Polar was created by johnp
Has anyone used the Voyage Data Recorder info to do post race analysis of a real boats performance vs the boats polar?
I've recently completed a 58 hour race where I used the VDR to record GPS and instrument data from the boat. I want to analyze how the boat performed compare to the Polars.
I've exported the VDR data to a .csv file and opened with Excel. I've found that the Lat and Lon data has been separated into 4 fields. The decimal portion of the Lat and Lon in separate fields. Similarly each of the instrument data loggings has been separated in to two fields each, one field for the whole number, as second field for the decimal portion.
Has anybody come up with any sort of tool that can use this data, join the whole number part with the decimal part and do some useful analysis? Here's a screen shot of the first few records of the exported file.
Is there a way that qtVlm can display histograms and statistics from this data as it does in the Routes:Edit Route:Histogram and Routes:Edit Route:Statistics?
Thanks,
John Purdy
I've recently completed a 58 hour race where I used the VDR to record GPS and instrument data from the boat. I want to analyze how the boat performed compare to the Polars.
I've exported the VDR data to a .csv file and opened with Excel. I've found that the Lat and Lon data has been separated into 4 fields. The decimal portion of the Lat and Lon in separate fields. Similarly each of the instrument data loggings has been separated in to two fields each, one field for the whole number, as second field for the decimal portion.
Has anybody come up with any sort of tool that can use this data, join the whole number part with the decimal part and do some useful analysis? Here's a screen shot of the first few records of the exported file.
Is there a way that qtVlm can display histograms and statistics from this data as it does in the Routes:Edit Route:Histogram and Routes:Edit Route:Statistics?
Thanks,
John Purdy
Please Log in or Create an account to join the conversation.
- maitai
- Offline
- Administrator
Less
More
- Posts: 853
1 year 5 months ago #1954
by maitai
Replied by maitai on topic VDR for post race analysis of boat performance vs Polar
Hi,
Either we have a bug in the export, either you didn't specify correctly in the general settings csv separator and decimal point for your localization. Excel is a bit dumb on that. You can also rename the file with a txt extension, open it in excel and it will ask you all about separator and decimal point.
There is no function for displaying graphs from the VDR, but once all data in a spreadsheet you can easily do it, or even write a macro for that.
--Philippe
Either we have a bug in the export, either you didn't specify correctly in the general settings csv separator and decimal point for your localization. Excel is a bit dumb on that. You can also rename the file with a txt extension, open it in excel and it will ask you all about separator and decimal point.
There is no function for displaying graphs from the VDR, but once all data in a spreadsheet you can easily do it, or even write a macro for that.
--Philippe
Please Log in or Create an account to join the conversation.
- johnp
- Topic Author
- Offline
- New Member
Less
More
- Posts: 2
1 year 5 months ago #1955
by johnp
Replied by johnp on topic VDR for post race analysis of boat performance vs Polar
I just found an online .db to .xlsx converter
www.rebasedata.com/convert-sqlite-to-xlsx-online
I've got the data in excel now as numbers I can graph. Still trying to figure out the best method to show boat performance vs polar
I've got the data in excel now as numbers I can graph. Still trying to figure out the best method to show boat performance vs polar
Please Log in or Create an account to join the conversation.
- maitai
- Offline
- Administrator
Less
More
- Posts: 853
1 year 5 months ago - 1 year 5 months ago #1956
by maitai
Replied by maitai on topic VDR for post race analysis of boat performance vs Polar
Last edit: 1 year 5 months ago by maitai.
Please Log in or Create an account to join the conversation.
Time to create page: 0.179 seconds