Tweet
Hey all, I tried searching through to see if these questions had been answered, but found nothing, so I apologize if these are repeat questions!
My brother-in-law and I are looking to start a league with buddies on the sim this winter. I am in need of assistance with the spreadsheet I'm building to keep track of scores and leaderboards and such. I'd also love your take on how we plan to run the league. Any advice would be great!
League:
Spreadsheet:
Link to Google Sheets: https://docs.google.com/spreadsheets...it?usp=sharing
Here is the sheet I have built so far.. Here is what I'm trying to accomplish;
Id like to enter the score for the round which will then automatically rank them from 1st to 10th for the week only. Then based off place, they will be awarded their points listed above. A place tie would result in adding the points and divide by 2, for example, a tie for first would award each player 87.5 points.
I then would like the spreadsheet to tally the points in the leaderboard and sort them from first to last as points are earned...
I really don't know how to accomplish this, and as you can see, I attempted one formula already.. Any assistance or advice would be greatly appreciated!
My brother-in-law and I are looking to start a league with buddies on the sim this winter. I am in need of assistance with the spreadsheet I'm building to keep track of scores and leaderboards and such. I'd also love your take on how we plan to run the league. Any advice would be great!
League:
- 10 Players (5 each night)
- 2 nights- one hosted by my brother-in-law and one by me
- 10 weeks
- $250 buy-in
- $20 a night to the sim, leftover money to the prize pot (our standard rate we charge people to use it)
- Prize Money 1st, 2nd, 3rd
- $250
- $175
- $75
- Points based on weekly standing - this is to make it easier to establish a winner and allows people to miss nights at their own risk for other obligations.
- 1st 100 points
- 2nd 75 points
- 3rd 50 points
- 4th 25 points
- 5th 10 points
- 6th-10th 5 points
Spreadsheet:
Link to Google Sheets: https://docs.google.com/spreadsheets...it?usp=sharing
Here is the sheet I have built so far.. Here is what I'm trying to accomplish;
Id like to enter the score for the round which will then automatically rank them from 1st to 10th for the week only. Then based off place, they will be awarded their points listed above. A place tie would result in adding the points and divide by 2, for example, a tie for first would award each player 87.5 points.
I then would like the spreadsheet to tally the points in the leaderboard and sort them from first to last as points are earned...
I really don't know how to accomplish this, and as you can see, I attempted one formula already.. Any assistance or advice would be greatly appreciated!
Comment