chris_w_65 Posted September 25, 2011 Share Someone please give me the formula for working out seeding index Thanks Link to comment Share on other sites More sharing options...
chris_w_65 Posted September 25, 2011 Share Someone please give me the formula for working out seeding index Thanks OK, worked it out D2D 38.17Race for Victory 37.66 (Your time in minutes divided by winning time in minutes) -1 then x 100 Link to comment Share on other sites More sharing options...
chris_w_65 Posted September 25, 2011 Share OK, worked it out D2D 38.17Race for Victory 37.66 (Your time in minutes divided by winning time in minutes) -1 then x 100 Hopefully I will be starting the 94.7 before 10am Link to comment Share on other sites More sharing options...
Minion Posted September 25, 2011 Share Hopefully I will be starting the 94.7 before 10am I think these two races are too late to form part of the official 94.7 seeding for this year. You might need to ask them for a reseeding. Link to comment Share on other sites More sharing options...
chris_w_65 Posted September 25, 2011 Share I think these two races are too late to form part of the official 94.7 seeding for this year. You might need to ask them for a reseeding. I think I have done about 8 races this year and I still have no seeding First one was Wilro in the middle of April. Link to comment Share on other sites More sharing options...
chris_w_65 Posted September 25, 2011 Share I think these two races are too late to form part of the official 94.7 seeding for this year. You might need to ask them for a reseeding. You are right, just checked their website. A bit stupid, we are in September and the results for both races were up same day as the races. Link to comment Share on other sites More sharing options...
chris_w_65 Posted September 25, 2011 Share I think these two races are too late to form part of the official 94.7 seeding for this year. You might need to ask them for a reseeding. Just emailed them and said reseed me or I don't enter There are only 4 races in Gauteng that are seeding races for 94.7 2011, this Racetec monopoly sucks Link to comment Share on other sites More sharing options...
Guest agteros Posted September 25, 2011 Share Someone please give me the formula for working out seeding index ThanksTry the attached spreadsheet, or type it out manually in Excel as follows : =ROUND((1-Winner_Time_Without_Seconds/Personal_Time)*100,4)Where the definition for Winner_Time_Without_Seconds is =TIME(HOUR(Winner_Time),MINUTE(Winner_Time),0)Names can just as well refer to the normal A1 / A2 / B1 / etc formatEnter both Winner_Time and Personal_Time as HH:MM:SS Link to comment Share on other sites More sharing options...
Buffwhack Posted September 25, 2011 Share Great Race - first time I did this one and I am wondering why I avoided it in the past. It's local for me - rolled out of bed around 6h10 and still got the the race early. High five for this race will attempt the 101 next year. Thanks to the BM/AM group that stayed together from start to finish - good pace, a bunch of sane cyclists for a change. Link to comment Share on other sites More sharing options...
chris_w_65 Posted September 25, 2011 Share Try the attached spreadsheet, or type it out manually in Excel as follows : =ROUND((1-Winner_Time_Without_Seconds/Personal_Time)*100,4)Where the definition for Winner_Time_Without_Seconds is =TIME(HOUR(Winner_Time),MINUTE(Winner_Time),0)Names can just as well refer to the normal A1 / A2 / B1 / etc formatEnter both Winner_Time and Personal_Time as HH:MM:SS This gives me much better results than I had caculated :thumbup: D2D - 27.62Race for Victory - 27.36 I had the 2 times the wrong way around Link to comment Share on other sites More sharing options...
chris_w_65 Posted September 25, 2011 Share Try the attached spreadsheet, or type it out manually in Excel as follows : =ROUND((1-Winner_Time_Without_Seconds/Personal_Time)*100,4)Where the definition for Winner_Time_Without_Seconds is =TIME(HOUR(Winner_Time),MINUTE(Winner_Time),0)Names can just as well refer to the normal A1 / A2 / B1 / etc formatEnter both Winner_Time and Personal_Time as HH:MM:SS Why multiply by 100,4? Why the ,4? Link to comment Share on other sites More sharing options...
Minion Posted September 25, 2011 Share Why multiply by 100,4? Why the ,4?That's the Excel ROUND function syntax. It means multiply by 100 and round to 4 digits. The actual formula is:(1-Winner_Time_Without_Seconds/Personal_Time)*100 Edited September 25, 2011 by Edman Link to comment Share on other sites More sharing options...
chris_w_65 Posted September 25, 2011 Share That's the Excel ROUND function syntax. It means multiply by 100 and round to 4 digits. The actual formula is:(1-Winner_Time_Without_Seconds/Personal_Time)*100 Sweet, thanks for the explanation Link to comment Share on other sites More sharing options...
dracs Posted September 26, 2011 Share Eish! That was tough. I was in survival mode for last 30km! can't say I wasn't warned... Edited September 26, 2011 by dracs Link to comment Share on other sites More sharing options...
Cheese Posted September 26, 2011 Share Had nice race, Wind not quite as strong as last year but blew nevertheless.Reminder to myself - Put a 25 on the back if attempting this race agin next year. Link to comment Share on other sites More sharing options...
Audible Anarchy Posted September 26, 2011 Share Wind not quite as strong as last year but blew nevertheless. i was nearly blown off my freakin bike on that descent and last year was worse ? Jeepers.... Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now