This project takes the official results for various IM (and HIM) races and then "enhances" them by calculating additional details/statistics.
A new feature is the second worksheet. Try this:
Select your entire row from Sheet1 and Copy, then select the entire Row 2 of the 2nd Worksheet and Paste. This will show you where you fall percentile wise in each age group for each category.
Let me know if you do something cool with this data (not required, I just like to see what creative people do!).As usual, please contact craigdharris@slowtwitch.com if you:
-have questions or comments
-notice any problems
-have suggestions for improvements (especially if you can code them!)
-would like a particular race enhanced
-are independently wealthy and love this so much that you'd really like to write him a cheque for his troubles.
2005
2006
2007
2008 (Apr)
2008
2009
2010
2011
IM Canada
1999
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
IM Coeur d'Alene
2003
2004
2005
2006
2007
2008
2009
2010
2011
IM Florida
1999
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
IM Kona
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
IM Lake Placid
1999
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011 (combined)
2011 (no wetsuits only)
2011 (wetsuits only)
IM Wisconsin
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
IM Challenge Roth
2005
2006
2007
2008
2009
2010
2011
IM Regensburg
2011
IM France
2011
IM Germany
2011
IM Switzerland
2011
HIM Vegas
2011
HIM Texas
2012
Thanks to the following people (if you've helped and I missed you, my apologies for the oversight - and please let me know):
-Thorsten Radde for his help with Roth and IMNZ and doing some very cool stuff with this data ( http://www.trirating.com/ )
-Mark Rios for most of the cool percentile stuff
-Michael Khazalpour for some cool ideas
-Timothy Andrus for catching a bug
-Fred Williams for some cool graphs that I keep meaning to incorporate
-Matt Samojeden for some handy VB code
-The folks who kindly offered to beta test these
-Suzy for the M/F suggestion
-A too-long-to-mention-everybody list of people for the kind words that keep me doing this
-Rappstar and Slowman for hosting this
-Kanye for lettin me finish
