I'm looking for a way to calculate all of the future positions of a race championship based on all of the finishing combinations of the next race. E.g. The current standings could be: Rider1 90 points Rider2 80 points Rider3 70 points Rider4 60 points Rider5 50 points Based on all possible next race results (30 combinations for this example I think) how can I create something that will show all of the theoretical new championship standings? I want to be able to see, for instance, where rider2 needs to finish the next race in order to lead the championship, etc.
It's going to take quite a bit of work, you've got 120 possible combinations there! I guess you could use pivot tables and select a value for a number of riders and see what that does to the others.
120? Each rider could finish the next race in any one of the 5 places plus DNF. Isn't it then 5 riders multiplied by the number of possible race positions (6)? Actually isn't it a hell of a lot more than that? You could well be right there. But how to do this in Excel?
Even with just five riders and five possible placings, there are 5! (ie, 5x4x3x2x1) combinations or 120 possible outcomes, not including DNFs. I wouldn't like to programme a sheet to display that.
Pivot tables may be a good start. Or google 'excel race potion prediction formula' and keep googling til you get a template of what you need
