Sorry if the title is misleading. What i am looking for help accomplishing is I want to make an excel sheet, I can put team scores in each week and have a rolling standings list that each have there own ways to score a win.
First one would be standard H2H Win. You get a win if you score higher than you opponent that week.
Second one is non matchup Win. The top 6 scores get a win, the lowest 6 scores get a loss.
Final one is Mario Kart Standings. Essentially your scoring placement gives you a certain amount of points. 1st=15, 2nd=12, 3rd=10, 4th=8, 5th=7, 6th=6, 7th=5, 8th=4, 9th=3, 10th=2, 11th=1, 12=0
If anyone can point me in the direction of what kind of formulas i would need to accomplish this it would be appreciated. (Mainly, how to attribute top 6 scores get a win, and keep that standing rolling. and 2 how to assign point value to your finish spot each week, with a rolling total
Attached is how I imagine my excel sheet would visually look, just without any formulas filling out the standings
First one would be standard H2H Win. You get a win if you score higher than you opponent that week.
Second one is non matchup Win. The top 6 scores get a win, the lowest 6 scores get a loss.
Final one is Mario Kart Standings. Essentially your scoring placement gives you a certain amount of points. 1st=15, 2nd=12, 3rd=10, 4th=8, 5th=7, 6th=6, 7th=5, 8th=4, 9th=3, 10th=2, 11th=1, 12=0
If anyone can point me in the direction of what kind of formulas i would need to accomplish this it would be appreciated. (Mainly, how to attribute top 6 scores get a win, and keep that standing rolling. and 2 how to assign point value to your finish spot each week, with a rolling total
Attached is how I imagine my excel sheet would visually look, just without any formulas filling out the standings
