Hi all, this is my first post so please go easy
I have a Speedway grand prix sheet i have put together with basic formulas. Not happy with that i have tried to go a bit further and have now gotten out of my comfort zone.
As u can see from the sheet the AC column totals up the riders score from the races of which there are 20.
As an example in race 1 Red won so scores 3, white 2nd scores 2, yellow 3rd scores 1 and blue last scores 0.
After 20 races the top 8 go into 2 semi finals. Column AD ranks these scores in AC and in this sheet riders 5 (Hancock) and 7 (Penhall) both have 10 points and are both ranked 3rd.
Now the tricky bit. (deep breath)
Column A3 totals race wins 3pts (criteria 1), AF 2nd places 2 points (criteria 2) and AG 3rd places 1 point (criteria 3).
In a tie like this most race wins (3 points) comes needs to be higher in the rank then 2nd places is used then 3rd...In the example they both have 1 1st place, 3 second places and 1 3rd place..so are equally ranked
So now it needs to go down to the race (they only race eachother once) were they met which was race 2 and Penhall outscores Hancock.
So Penhall needs to outrank Hancock...
so in short the criteria is
most race wins (3 points)
most 2nd places (2 points)
most 3 rd places ( 1 point)
the race in which they face each other, race 2 in this example.
Got a headache now, so over to you brainy lot..
Thnaks for any assistance you can offer.
screenshot link below
https://www.dropbox.com/s/ozqedn0t7f5j9ot/Screenshot 2017-11-03 12.36.51.png?dl=0
If anyone would like the document to play with just email me evans8773@gmail.com
Cheers
I have a Speedway grand prix sheet i have put together with basic formulas. Not happy with that i have tried to go a bit further and have now gotten out of my comfort zone.
As u can see from the sheet the AC column totals up the riders score from the races of which there are 20.
As an example in race 1 Red won so scores 3, white 2nd scores 2, yellow 3rd scores 1 and blue last scores 0.
After 20 races the top 8 go into 2 semi finals. Column AD ranks these scores in AC and in this sheet riders 5 (Hancock) and 7 (Penhall) both have 10 points and are both ranked 3rd.
Now the tricky bit. (deep breath)
Column A3 totals race wins 3pts (criteria 1), AF 2nd places 2 points (criteria 2) and AG 3rd places 1 point (criteria 3).
In a tie like this most race wins (3 points) comes needs to be higher in the rank then 2nd places is used then 3rd...In the example they both have 1 1st place, 3 second places and 1 3rd place..so are equally ranked
So now it needs to go down to the race (they only race eachother once) were they met which was race 2 and Penhall outscores Hancock.
So Penhall needs to outrank Hancock...
so in short the criteria is
most race wins (3 points)
most 2nd places (2 points)
most 3 rd places ( 1 point)
the race in which they face each other, race 2 in this example.
Got a headache now, so over to you brainy lot..
Thnaks for any assistance you can offer.
screenshot link below
https://www.dropbox.com/s/ozqedn0t7f5j9ot/Screenshot 2017-11-03 12.36.51.png?dl=0
If anyone would like the document to play with just email me evans8773@gmail.com
Cheers