How to Create 1:1 Stages from Google Earth
|
Johan92 |
Posted on 03-05-2009 19:37
|
Domestique
Posts: 737
Joined: 26-09-2007
PCM$: 200.00
|
Is it possible to change the section lenghts so they dont have the lenght 0.947596, but 0.9 etc?
www.pcmnorge.no
|
|
|
|
impish |
Posted on 07-05-2009 09:47
|
Junior Rider
Posts: 48
Joined: 18-07-2007
PCM$: 200.00
|
yes - change the makro where this value is calculated that the value should by round. |
|
|
|
Johan92 |
Posted on 07-05-2009 13:16
|
Domestique
Posts: 737
Joined: 26-09-2007
PCM$: 200.00
|
I opened the macro CalculateTrack.
Is it here I'm going to change?
Function Distance(lat1, lon1, lat2, lon2, unit)
Dim theta, dist
theta = lon1 - lon2
dist = Sin(deg2rad(lat1)) * Sin(deg2rad(lat2)) + Cos(deg2rad(lat1)) * Cos(deg2rad(lat2)) * Cos(deg2rad(theta))
dist = acos(dist)
dist = rad2deg(dist)
Distance = dist * 60 * 1.1515
Select Case UCase(unit)
Case "K"
Distance = Distance * 1.609344
Case "N"
Distance = Distance * 0.8684
End Select
End Function
And one more question.
You must change your windows rights or change in excel script following line. How do you change the excel script?
Edited by Johan92 on 07-05-2009 13:16
www.pcmnorge.no
|
|
|
|
impish |
Posted on 07-05-2009 20:40
|
Junior Rider
Posts: 48
Joined: 18-07-2007
PCM$: 200.00
|
Okay i create new version 09 (link is on bottom WinRar File)
new settings
Distance Cor -> 0 (Default) -> helps to close distance gaps if you use different round settings (see Round SecLen)
Height Cor -> 0 (Default) -> not active at the moment
Round SecLen -> 2 (Default) -> value for how many decimal you like for section length (creates small total distance diferences -> use Distance Cor to correct it)
imp
impish attached the following file:
Edited by impish on 07-05-2009 20:42
|
|
|
|
ruben |
Posted on 11-05-2009 17:43
|
Grand Tour Champion
Posts: 7721
Joined: 23-10-2006
PCM$: 200.00
|
Hello everyone, I just wanted to say it's easier to create GPS routes at https://www.bikero...aster.com/ then at google maps.
What's more, you can directly export to GPX and load it in the GPS kicker...
I created a tour of 5 stages in 1 hour this way... |
|
|
|
kirosha |
Posted on 11-05-2009 18:05
|
Domestique
Posts: 612
Joined: 30-03-2008
PCM$: 200.00
|
Thanks a lot, Ruben! It's really fast to do stages with this tool. |
|
|
|
Il Grillo |
Posted on 11-05-2009 18:28
|
Domestique
Posts: 568
Joined: 21-06-2007
PCM$: 200.00
|
Bikeroutetoster seems to be a good site. Thx for the tip! I have done all the giro-stages with www.gpsies.com . Pretty handy site. I have also imported the gpx files in Sporttracks to exactly follow the riders during the stages of the giro |
|
|
|
bobcatsman |
Posted on 11-05-2009 18:36
|
Neo-Pro
Posts: 273
Joined: 30-07-2008
PCM$: 200.00
|
You can also use www.openrunner.com |
|
|
|
Johan92 |
Posted on 11-05-2009 18:49
|
Domestique
Posts: 737
Joined: 26-09-2007
PCM$: 200.00
|
Which map site is the most "detailed". I'm making some routes in Norway, long away from everywhere, but no site has data for those areas.
www.pcmnorge.no
|
|
|
|
Ad Bot |
Posted on 24-11-2024 10:35
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
IP: None |
|
|
Bilbo Baggins |
Posted on 11-05-2009 19:03
|
Under 23
Posts: 80
Joined: 24-03-2008
PCM$: 200.00
|
Johan92 wrote:
Which map site is the most "detailed". I'm making some routes in Norway, long away from everywhere, but no site has data for those areas.
As far as I know, they all use the information of Google. That means that they are all the same... So there just isn't information about Norway. |
|
|
|
kirosha |
Posted on 11-05-2009 20:09
|
Domestique
Posts: 612
Joined: 30-03-2008
PCM$: 200.00
|
In gpsies.com you can choose map... |
|
|
|
Halvor |
Posted on 06-06-2009 18:47
|
Sprinter
Posts: 1951
Joined: 18-09-2007
PCM$: 200.00
|
Halvor wrote:
Thanks CrueTrue. I got through everything, then this happened...
Anyone help me? |
|
|
|
impish |
Posted on 06-06-2009 19:09
|
Junior Rider
Posts: 48
Joined: 18-07-2007
PCM$: 200.00
|
Windows Vista? (if yes format your harddisk)
The problem is that you have no admin rights to save a file direct in c:\ root directory.
Two ways to fix it.
1) open visual basic editor in excel search for the save path (C:\test.xml) and cahnage it to a path you like
2) Change the right settings to have access to c:\
imp |
|
|
|
Halvor |
Posted on 06-06-2009 19:38
|
Sprinter
Posts: 1951
Joined: 18-09-2007
PCM$: 200.00
|
Thanks for fast answer!
But I don't know how to do any of the solutions... Can you explain a bit more like I understand exactly what I have to do? |
|
|
|
Halvor |
Posted on 06-06-2009 19:49
|
Sprinter
Posts: 1951
Joined: 18-09-2007
PCM$: 200.00
|
I tried the 2nd solution.. Now a new error came
|
|
|
|
Il Grillo |
Posted on 06-06-2009 19:58
|
Domestique
Posts: 568
Joined: 21-06-2007
PCM$: 200.00
|
Can you try if it works with the sheet i have in my attachement and if you create a folder called c:\pcm before.
|
|
|
|
Il Grillo |
Posted on 06-06-2009 20:06
|
Domestique
Posts: 568
Joined: 21-06-2007
PCM$: 200.00
|
Just to get back to stage making how do you guys make the editing after you have the .xml file?
I do it like this.
I usually directly import it in the rsm_profiler and edit there, as i directly see the changes in the profile:
- Start-Type
- Sprints
- Finish type
- Time checks
- Edit Profile (sometimes bad sections)
So i allready have a good base then i view it in the stage editor:
- add stuff
- edit terrain
- search for bad sections and edit it
Then i load the sta_stage with hannes converter and edit the stage-line i want to replace (most difficult part for newbees). Afterwads i modify the sta_race in case something has changed.
This all is a pretty fast process and easy if you are not a stage building pro. But you have to do most of the things i mentioned after you created the xml-file to get it function correct in game.
Edited by Il Grillo on 06-06-2009 20:09
|
|
|
|
Halvor |
Posted on 06-06-2009 22:29
|
Sprinter
Posts: 1951
Joined: 18-09-2007
PCM$: 200.00
|
Il Grillo wrote:
Can you try if it works with the sheet i have in my attachement and if you create a folder called c:\pcm before.
Thank you, it worked! |
|
|
|
AaB-ern |
Posted on 04-08-2009 17:48
|
Directeur Sportif
Posts: 1489
Joined: 29-11-2006
PCM$: 200.00
|
Hey Impish. I finally got the time (and motivation) to test this tool, and I am absolutely stunned. This is in top 5 of the best PCM utilities and tools ever. Amazing!
I've just got one question, maybe other stagemakers have an idea too. In the Tour of Denmark, stages always end with a criterium in a city. In bikely (similar to biketoaster), I just drawed the route to go at the same point to make it go around, but as I feared, this made the rendered stage look strange (The profile is just perfect though).
Have you got any idea on how to solve this? I guess I just can't copy the sections from the start of the criterium and paste them, as it would screw up the waypoints.
I guess I'm not the only one, who experienced this? |
|
|
|
impish |
Posted on 05-08-2009 14:26
|
Junior Rider
Posts: 48
Joined: 18-07-2007
PCM$: 200.00
|
hmmmm,
the problem is that i have 0% knowlegde in stage building - its not a joke.
you mean with a criterium that the run a circuit course x-times?
|
|
|