Forum Discussion
create custom formula
I would like to create this custom formula to calculate a points awarding system that automatically calculates. P and A are the variables in the formula. Is this possible? P = event finishing...
If you google "event finishing position" "event attendance" "fleet factor" with quotes, we find the HCA Competitive Ranking formula (click here).
The formula (from page 1) is not proper math. It might be parsed as follows:
The formula f(x) calculates the points assigned to a participant based on the participant's position (P = 1 to A) in a race with "A" participants.
The notation Sigma(f(x), for x=1 to 5) simply means: sum the points from 5 races.
In particular: ``the system includes your best five regatta finishes. If you sail fifteen events, we take your very best results for your ranking``.
The table below (from page 2) shows the expected f(x) before applying fleet factor (phi) for finishing positions (P) in races that have A=1 to 20 participants. It is just an example.
Note: I don't know if it is implicitly suggesting that f(x) should be rounded to 3 decimal places. Further reading might be necessary.
"The remainder of the solution is left as an excercise for the student". (wink)
