Does anyone know if there is a spread sheet available that we can plug numbers into to get the District Points Earned? How are the Qual Points calculated, the Alliance points, the play off points, the award is straight forward but still would like that number in a drop down.
i don’t know about an Excel sheet but the calculation is pretty straightforward…
the only “difficult” part is the qual points and it is calculated in TBA just fine…
it is in 11.8.1
Where is this information located? Can you give me the link?
Section 11 of the 2022 Game Manual
Okay… 
what is 
? Some kind of multiplier function?
R – the qualification rank of the team at the event at the conclusion of Qualification MATCHES
(as reported by FMS)
• N – the number of FIRST Robotics Competition teams participating in the Qualification rounds at
the event
• Alpha (α) – a static value (1.07) used to standardize the distribution of points at events
Did you Google it? It’s a common function.
Can anyone show me how to use this function for what FIRST is applying it to. I do not see it on my calculator.
https://support.microsoft.com/en-us/office/erf-function-c53c7e7b-5482-4b6c-883e-56df3c9af349
It will be easier to calculate in excel as I don’t think it is a standard calculator function
That is what I was thinking to use Excel… just hoping someone had it already done.
Its been a while since I looked at this, but someone from 4828 developed this. I can’t remember the CD thread it was in. If I recall the position points work correctly.
yes I did find this but the numbers I put in did not match what FIM put in.
I just threw together a version that seems to work. Dropbox - District Points Calc - Simplify your life
Just to make sure I have it right
15/37 and 2nd pick of 7 at Livonia
10/36 captain of 7th with a 5pt award at Lansing that should add up to 52 and that’s what I got in the sheet.
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
