Spreadsheet: 555699d1515700189-stats-points-tracking-for-a-disc-golf-league-golf-disc-tournament-2018-3-
Sheet: Info

 |  |  |  | ENTER MEMBER names and tournament data into the SETUP tab 1st
 |  |  |  | This workbook has been set up to for 50 Team Members in 8 Tournaments.
 |  |  |  | [NAME] for each tournament will assign 50 points to the LOW scoring player(s) and assign points in DESCENDING order to the remaining scores.
 |  |  |  | If team members 'do not play' in a tournament enter DNP into the score column next to that players name.
 |  |  |  | Adjustments have been made to the POINTS & RANKING formulas to maintain consistent point values for each tournament
 |  |  |  | To create a New Tournament Tab
 |  |  |  | Right click on the previous tab (8) name and select 'Move or [NAME]' then select '[NAME]' then check create a Copy
 |  |  |  | a new sheet will then be created at the end of the tournament tabs. Change the data from the 'setup tab' to reflect the New Tournament
 |  | To rename a [NAME]
 |  |  |  | Right click on the previous tab name and select '[NAME]'. Change 'Tournament 8 (2) to Tournament 9
 |  | [NAME]
 |  |  |  | In Order to keep the POINT values the same whether there are more or less players in each Tournament
 |  |  |  | the RANK formula counts the number of players that actually played and then adjusts the rankings to
 |  |  |  | maintain the correct POINTS that should be assigned to the LOW Scoring members the formula
 |  |  |  | then assigns ZERO Points to those that did not play.
 |  |  |  | To sort by Points select (Highlight) Range D6 to F56 then on the
 |  |  |  | Home Ribbon select '[NAME], 'Custom, Check the 'My Data has Headers box,
 |  |  |  | then select ' Sort by Points, 'Largest to Smallest.
 |  |  |  | To clear the Player Scores select the Range E7 to [NAME] then on the
 |  |  |  | Home Ribbon select 'Clear, 'Contents
 |  |  |  | To clear the Player Names AND Scores (not recommended) select the Range D7 to [NAME] then on the
 |  |  |  | Home Ribbon select 'Clear, 'Contents
 |  |  |  | To show the Column and Row headers select view on the ribbon tab and check the HEADINGS box.
 |  |  |  | The [NAME]  that goes in F7 is =IFERROR(RANK(E7,$E$7:$E$56,0),0)+($J$4)+($J$4-1)
 |  |  |  | then filled down to F56
 |  |  |  | The [NAME]  that goes in G7 and H7 is =IF(E7="dnp",0,E7) =[NAME])
 |  |  |  | The [NAME]  that goes in I6 is =MAX(F7:F56)
 |  |  |  | The [NAME]  that goes in J6 is =MIN(F7:F56)
 |  |  |  | The [NAME]  that goes in K, L, & M3 is =COUNTIF($E$7:$E$56,$K$1), =COUNTIF($E$7:$E$56,$L$1), =COUNTIF($E$7:$E$56,$M$1)
 |  |  |  | This is the formula for the League Table sheet =IFERROR(INDEX('Tournament 1'!$G$7:$G$56,MATCH($C7,'Tournament 1'!$D$7:$D$56,0)),0)
 |  |  |  | For each tournament 'Tournament 1'! becomes 'Tournament 2'! Etc.
 |  |  |  | To add tournaments, insert 2 columns after Tournament 8 by clicking on the column letters.
 |  |  |  | Copy the formulas from the top 2 cells from the previous tourny and paste into the new top 2 cells.
 |  |  |  | Change Tournament 8 to Tournament 9 in both new columns and fill down to cover all players.
 |  |  |  | To REMOVE 'Data Validation' which prevents over writing of formula cells.
 |  |  |  | Go to the 'Data tab, select 'Data Validation, 'Clear All