28.11.2011, 13:37
LengthCalculations.zip (Size: 4.4 KB / Downloads: 745)
Quote:And then you're satisified with RouteConverter's results if put into the clipboardNope, since I can't copy/paste distances and elevation. I must read elevations from saved 'gpx' and calculate the distances myself.
Quote:I don't know but I'm glad to see that RouteConverter calculates distances in the middle between EasyGPS and your program. The error is below 0,035% and so far that accuracy was enough for the users.I use the formulas from http://mathforum.org/library/drmath/view/51879.html
I put them on excel to be reviewed by someone with more knowledge.
In the same EXCEL I have also the distances calculated by RouteConverter, using the Radius=6371000
Since Romania is at 45deg lat and R=6378137..6356752m I should use the average.
In the attached rep I have used 6378137m and you can see I am far below RouteConverter but in line with EXCEL.
I attach a zip with EXCEL, the gpx and my rep.
I should/must get results as close as possible as Route converter calculates them since some time ago I have made some reports by hand copy the lenghts. Overtime the reports number has grown and I don't want to go in some inconsistency.
Please, can you help me to fix my issue?
Other formulas I should use, whatever modifications in EXCEL, allow copy dist+elev from RouteConverter...you name it.
Thank you!

