Quick and easy estimate: IM site usually displays 21 or 22 competitors per page. Sort by time and then figure out which page you're on and...

(page# -1)x22 + Place on page - DNFs = relative estimate


For example, if you're the 16th person on page 4 and there are 12 DNFs, then

(4-1)x22 + 16- 12 = 70

Not exact, but probably close enough for your purposes, I suspect? (You just want to know your relative standing in each sport?)



EDIT: Actually, use sportstats - they always have 40 per page, and they number everything. (same principle though)

http://www.sportstats.ca/...html?racecode=110194

If you can view all the finishers on one page (even if it is so long you have to scroll) you can use the "import data -> from web" function in excel to load up the website and select the field containing the results. Usually using spaces as delimiters works. Alternately you could just use the good 'ol Ctrl A + Ctrl C + Ctrl V + fingers crossed method...

---

__________________________

I tweet!

As timbasile said, sportstats.ca is always the place to go in order to get the WTC data in a better format.
It's pretty poor how they list your bike & run rank as your overall rank, most timing companies don't do that.
Saving as text in this case produces a difficult-to-import mess, but you can save any such file as html which can be imported into your spreadsheet tool (I used Libre Office).
Here's my .xlsx sheet, just click the download button at the top:
https://docs.google.com/...lYQmF3Ulk/edit?pli=1
and here it is as a google sheet (since google-drive has download quotas):
https://docs.google.com/...yJg/edit?usp=sharing
I reformatted the timing a little and added overall sport-specific Rankings plus a column "Time into T2" which makes it easier to identify who came off the bike in a group. Maybe someone with some time will add in the offsets for the wave starts, so that column becomes more valuable to anyone evaluating draft packs?
Doug
www.triathlonlog.com