Hi sejtam,

I get race progress information from

http://www.letour.fr/2005/TDF/LIVE/fr/1300/dprofil.html

for today.

Tomorrow it will be 1400 instead of 1300

There we have a line saying
"Dj parcouru : 44.5 km | Reste parcourir : 129.0 km"
and that is all the info you need from the web.

On the other side you need the track coordinates with distance information.

Well the coordinates are already there in Nagoyan track. (just save the track as KML file and look at it with an editor)

I the compute the distance from the start for each point. (That's a bit complicate, look for great circle distance calculation)

The i have a lookup table where I can find the relevant coordinates corresponding to the distance information I got from the web.


These coordinates are then written into a small KML file.

GE is reading this file at regular intervals and so updating the position.

I use Excel for some good reasons:

1) I am quite familiar with it
2) It is verry easy to link web pages as an external data source and update it.
3) it easy to process the data with it.

BUT its uggly to write data to a file.

and it worse if you try to write to the internet!!

And that is why it not working!!


If you want to see more, download my excel file, disable macro execution and look at it. No hidden feature.

regards,