impish wrote:
Here the first release.

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

its very easy - with nice and realistic results

enjoy it!!!