VDR for post race analysis of boat performance vs Polar

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
 

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

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

Good, but the CSV export should work, can you please check that it is set correctly in this setting: