Please be patience about 2 small limitations in this version.
*) Collision query isnt included (that means that its possible you have bad sections during close streets - but can be corrected manualy)
*) Created File will be saved direct at c:\Test.xml (Everyone can set it in Excel Script to there own path)
ATTENTION!!
It was a very funny small project - you can do what you like with this excel sheet. Also manipulate the code behind.
MANUAL
======
Start the excel sheet (if excel ask to run makro 'say' yes otherwise we cant calculate)
All orange fields can be filled in with your personal settings
Slope Meter (700) = in this case the default value is 700 METER, if you press the small button, all orange fields under 'H' get this value, but its possible to edit all this cells to get more control over the calculate routine. The value calculates the distance for slope to slope
Lat Faktor (100) = With this value we can resize the Latitude faktor
Lon Faktor (100) = With this value we can resize the Longtitude faktor
With booth you can manipulate the 1:1 scale in the GPS File. Example Lat Faktor 400 - Lon Faktor (100) = 4:1 scale (it could help to fix grafic bugs during close streets)
Buttons:
Reset = think its clear
Import = import a gps file
Calc = Calculate the XML File
ToXML = Saves the PCM XML File
What GPS-files works? I have a Garmin Edge 705, but the program doesn't find any files. The files are .TCX. What do they have to be, and how do I fix it?
This is a really cool tool if I get it to work. Thanks!