I'd like to figure out how exactly the Kona slot calculation works -- I've read what it says on the Kona FAQ. 1 slot per age group starting, then remaining slots allocated proportional to the number of racers. But, how exactly do they assign the slots proportionally.
Method #1
I estimated them this way for CDA first:
Which gave me these results:
But then, Dave Latourette pointed out that he has a spreadsheet used to do the actual calculations for an awards ceremony, and :
M60-64 gets 2
M35-39 gets 4
So by his spreadsheet 30-34 loses one, and 60-64 gains one.
After looking around a bit, and also mentioned by Dave later in reply (reply is here), they mentioned using a ratio of age group count to kona slots allocated to determine which age group gets the next slot.
Method #2
So, I made a little thing that would:
Now, this makes more sense to me, but the results end up being :
Which ends up giving:
-1 M18-24
+1 M30-34 (which makes is two higher than Dave's spreadsheet)
+1 M40-44
+1 M45-49
+0 M60-64 (which would still be one lower than Dave's spreadsheet)
-1 F30-34
-1 F50-54
This method agrees even less with Dave's version (though it actually seems more equitable in terms of odds).
So, now I'm wondering how exactly this calculation is done?
blog: transitionfour.com
twitter: @tritweeter
Method #1
I estimated them this way for CDA first:
- Allocate 1 slot for every age group where there is a starter.
- Take the remaining 29 spots and figure what each age group's share of spots would be if you could sub-divide them exactly on proportion of total racers.
That gives :
M35-39 has 3.605 additional kona spots
M60-64 has 0.522 spots
- So, I allocate the whole number portion as additional spots -- so here 35-39 gets another three along with their original 1, so they are up to 4. In total that used up another 20 of the 29 remaining spots, so 9 left.
- After subtracting the whole number spots, we're left with all the fractional spots for each age group -- I then allocated them, highest portion first. Meaning, M35-39's 0.60 beat out M60-64's 0.52.
Which gave me these results:
But then, Dave Latourette pointed out that he has a spreadsheet used to do the actual calculations for an awards ceremony, and :
Quote:
Occasionally i have had to do rolldown / allocation at awards per my announcing duties and I have the spreadsheet that gets used in the process ... using the numbers you have for starters, all of those slot numbers are correct except: M60-64 gets 2
M35-39 gets 4
So by his spreadsheet 30-34 loses one, and 60-64 gains one.
After looking around a bit, and also mentioned by Dave later in reply (reply is here), they mentioned using a ratio of age group count to kona slots allocated to determine which age group gets the next slot.
Method #2
So, I made a little thing that would:
- Assign 1 to each group with a starter.
- Calculate the ratio of racers to currently allocated kona slots for each group.
- Assign the next spot to the age group with the highest number of racers to slot.
- Re-calculate the ratios with the new allocation, and assign the next slot to the one that then has the highest ratio
- Repeat #4 until all remaining slots are allocated.
Now, this makes more sense to me, but the results end up being :
Which ends up giving:
-1 M18-24
+1 M30-34 (which makes is two higher than Dave's spreadsheet)
+1 M40-44
+1 M45-49
+0 M60-64 (which would still be one lower than Dave's spreadsheet)
-1 F30-34
-1 F50-54
This method agrees even less with Dave's version (though it actually seems more equitable in terms of odds).
So, now I'm wondering how exactly this calculation is done?
blog: transitionfour.com
twitter: @tritweeter