Would be interesting to compare your list with the race day results just to see how everyone did. It is this kind of data I have been looking for as someone who is pursuing Kona. Always wonder about the competition. At any rate, what are the odds of you doing one for IMAZ this year?

Here you go: Ironman Arizona

I can’t see how I can donate? This is great stuff.

---

I'm closer to the feathered end of the spear than the point.

Thanks! There's a link at the top of each sheet: "Useful? Consider a $5 donation to support this project."

Oh, boy! Someone is sicker than me! I complied a list of results for the guys in my AG to see how I stack up against them. Now, you did this for all these races and for all AGs! Nice job!

While the start lists haven't changed, the race results have changed since you ran the numbers... I was looking at IMWI and a gal that raced IM Santa Rosa is entered but her IMSR results are not populated...


Cool tool... thanks!

Right - these are all using results/data from 2017. I will have to make some updates to get the latest 2018 data incorporated.

Per a request, I added a psych sheet for Ironman Cozumel. That start list was in a slightly different format, and it took some more manual effort to parse out the names and countries...hopefully most of the data is there.

Got it... still super helpful!

I can't believe I missed that. I was on my iPad, that's my story. Money sent.

---

I'm closer to the feathered end of the spear than the point.

Could you update IMMD with bib list? Donation sent!

Sorry, I'm not able to parse the bib lists right now because they are formatted slightly differently than the participant lists and are missing the exact age. I can look at doing that in the future, though. If there is a specific person or persons you want added, just message me their name/age/country, and I can update it.

Very cool. Shooting you a donation.

Can you go back and run this for prior races? I'd be interested to see how your projection compares to actual results and use that to improve the algorithm. I'd particularly be interested to see Lake Placid since I competed there.

Thanks for doing this.

If you have a participant list pdf (not the bib list), I can do that. Otherwise, I color coded first/second/third for Ironman Santa Rosa which I competed at. I improved the algorithm after that to better include HIM results. If people aren't on the start lists, I can't rank them. I haven't had a chance to try and programmatically update the sheets with the final results, but it is something I want to do...also want to try and parse the bib lists since they tend to have several people not on the last participant list posted.

Thank so much for doing this. I just donated.

---

leslie myers
http://www.foodsensenow.com

so cool! thank you

---

website/blog | Instagram

I just sent you the IMLP participant list via DM.

Thank you for doing this - money sent!

Would love to see these with the 2018 results included (and once an updated bib list is posted for IMAZ, ha!) I've tried to figure out how to make one of these and your Excel brain is definitely smarter than mine.

Cool stuff but does a half have anything to do with a full? Also, I don't know if it takes into account athletes that aged up this year....

Is it possible to update Chattanooga and Maryland? Thanks!

21. RODNEY SCOTT


2017:(100.850)(41m26s, 2h44m30s, 1h49m16s, 5h22m25s, 58)
2016:(101.291)
2015:(100.182)
2014:(99.394)
2013:(100.876)


This guy WON Ironman Boulder 2017 M40-44 AG with a time of 9h44. He's one of the favourites in this year's IMLOU M40-44.


Any chance to update the pysch sheet with 2018 race results as well?

I updated this one to include 2018 results. There is a Rodney Scott from USA and Canada...the one listed on the start list is from Canada and the one from Boulder is USA. I'm looking at name/country/age to keep track of people, so if these are the same people, that is why the result doesn't appear.

Sorry, I'm not set up to process the bib lists right now...they are formatted a little differently than the participant lists.

Yes, the first one I did was for Ironman Santa and didn't factor in 70.3 results. Rosa https://docs.google.com/.../edit#gid=1765503760 Some of the outliers in top performers were people with good 70.3 results but no full results, so I updated the algorithm to factor them in (although full still takes precedence).

anyway to update the IMFL list, i think it is updated once after your last post.