Percentage drop offs

Yes I'm aware of the HTML results format and Excel imports them just fine, but they are still a problem since the event is not replicated on each line (ie, each line is not a complete record of a swim). I could write you a small Python script which would extract the swim info as I suggested and present you with an Excel or CSV file. Would that help?

Hi Chris, Thank you, that's a great little tool much appreciated. In fact the times that it generated were pretty much inline with my current swim times, what did surprise me was the % drop off was about 10%-->12% which I thought was more than expected. I am certainly not fit, but even then as I say the actual times and the projected times do match. I did notice that inputing my PB's , that I am dropping off more as the distances increase to 200 and 400.

You can use the Virginia Ratings Calculator to answer this question: www.vaswim.org/.../rcalc.cgi Pick an event and course (there are no 25s since those aren't official events) then switch from "time" to "rating." A rating of 100 corresponds to a record-caliber swim, so use smaller numbers if you like. Then calculate the time for different ages. The percent increase tends to increase with age. I have also created an Excel file to do these calculations. www.vaswim.org/RatingCalculator.xlsx Use the second worksheet (the tab is labeled "Swim Converter"). The converter is not the usual sort since it can convert between ages, which is exactly what you want. The answers from the Excel file won't be exactly the same as the CGI page since I updated the curve coefficients for the spreadsheet but haven't done so for the website. Hello and thanks for this information. I would like to start using age graded results, but was unable to pull up this second excel file. Maybe because I have a Mac and only have "numbers" not excel.

Hello and thanks for this information. I would like to start using age graded results, but was unable to pull up this second excel file. Maybe because I have a Mac and only have "numbers" not excel. I have a Mac too but yes you'll need Excel to use the file in the 2nd link. The file was tested on Excel for Mac 2011; I don't know if it would work on earlier version. I was a long-time user of Windows Excel and see no reason it wouldn't work on that platform (other than backward file compatibility) but I didn't test it. If you don't have Excel you'll need to use the first link.