Spreadsheet: 55541d1255640956-amend-ranking-formula-for-sports-results-sample
Sheet: Game9

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10TmRRx5Sh_ELS
 |  | COMPETITION: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Draw for a ten team round robin played on five sheets.
 |  | Venue/Date:
 |  |  |  | Date: |  |  |  |  |  | Time: |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 2 |  | 3 |  | 4 |  | 5
 |  | Draw 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 v 2 |  | 3 v 4 |  | 5 v 6 |  | 7 v 8 |  | 9 v 10
 |  |  |  |  |  | H | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | EE | Score | LSD |  |  |  |  | 9 v 3 |  | 6 v 10 |  | 1 v 7 |  | 5 v 2 |  | 4 v 8
 | 1 | A1 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 1 | 12.4 |  |  |  |  | 8 v 10 |  | 2 v 7 |  | 4 v 9 |  | 6 v 1 |  | 5 v 3
 |  | B2 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0 | 13 |  |  |  |  | 2 v 4 |  | 5 v 1 |  | 3 v 10 |  | 8 v 9 |  | 7 v 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 v 9 |  | 4 v 6 |  | 2 v 8 |  | 3 v 7 |  | 10 v 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 v 7 |  | 1 v 8 |  | 6 v 3 |  | 4 v 5 |  | 2 v 9
 |  |  |  |  |  | H | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | EE | Score |  |  |  |  |  | 3 v 1 |  | 10 v 2 |  | 7 v 4 |  | 9 v 6 |  | 8 v 5
 | 2 | [NAME] |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 1 | 10 |  |  |  |  | 6 v 8 |  | 7 v 9 |  | 10 v 5 |  | 2 v 3 |  | 1 v 4
 |  | D4 |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  | 2 | 14.6 |  |  |  |  | 7 v 5 |  | 8 v 3 |  | 9 v 1 |  | 10 v 4 |  | 6 v 2
 |  |  |  |  |  | H | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | EE | Score
 | 3 | E5 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 1 | 11
 |  | G6 |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  | 2 | 143
 |  |  |  |  |  | H | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | EE | Score
 | 4 | H7 |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  | 2 | 0
 |  | J8 |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 1 | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Results Grid
 |  |  |  |  |  | H | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | EE | Score |  |  |  |  |  |  |  |  | Where individual teams require ranking delete the "x"
 | 5 | K9 |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  | 3 | 1 |  |  |  |  |  |  |  | of the team(s) not involved, in the box below.
 |  | L10 |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  | 2 | 66
 |  | Draw 9
 |  |  |  |  |  | Score |  |  |  |  |  | Score |  |  |  |  |  | Score
 | 1 | A1 |  |  |  | 1 | 2 | [NAME] |  |  |  | 1 | 3 | E5 |  |  |  | 1
 |  | B2 |  |  |  | 0 |  | D4 |  |  |  | 2 |  | G6 |  |  |  | 2
 |  |  |  |  |  | Score |  |  |  |  |  | Score
 | 4 | H7 |  |  |  | 2 | 5 | K9 |  |  |  | 3
 |  | J8 |  |  |  | 1 |  | L10 |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x |  |  |  |  | Final
 |  |  |  |  |  |  | STANDINGS - DRAW 9 |  |  |  |  | P | W | L | LSD |  |  |  |  |  |  |  |  |  |  | Team | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Wins | Rank | LSD |  | Rank
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A1 | 1 |  | 1 |  |  | 1 | 0 | 1 |  | 1 |  | 4 | 1st | 37.81428571428571
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B2 | 2 | 0 |  |  |  | 1 | 0 | 0 |  |  |  | 1 | 9th | 35.44285714285714
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 3 |  |  |  | 1 | 0 |  |  | 1 | 1 |  | 3 | 2nd | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D4 | 4 |  |  | 0 |  |  |  |  | 1 | 1 | 0 | 2 | 4th | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E5 | 5 | 0 | 0 | 1 |  |  | 1 | 0 |  |  |  | 2 | 4th | 33.69999999999999
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G6 | 6 | 1 | 1 |  |  | 0 |  |  |  |  | 1 | 3 | 2nd | 11.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H7 | 7 | 0 | 1 |  |  | 1 |  |  | 0 |  |  | 2 | 4th | 11.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J8 | 8 |  |  | 0 | 0 |  |  | 1 |  |  | 1 | 2 | 4th | 10.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K9 | 9 | 0 |  | 0 | 0 |  |  |  |  |  | 0 | 0 | 10th | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L10 | 10 |  |  |  | 1 |  | 0 |  | 0 | 1 |  | 2 | 4th | 0.8999999999999999
 |  |  |  |  |  | Teams |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | W |  |  |  |  |  |  |  | NB: X = Not Played
 |  |  |  | A Smith |  |  |  | 1 | x | 1-0 | - | - | 1-0 | 0-2 | 2-1 | - | 2-1 | - | 3
 |  |  |  | A Murray |  |  |  | 2 | 0-1 | x | - | - | 2-1 | 2-3 | 0-2 | - | - | - | 1
 |  |  |  | C [NAME] |  |  |  | 3 | - | - | x | 2-1 | 0-1 | - | - | 2-1 | 4-1 | - | 2
 |  |  |  | D Murdoch |  |  |  | 4 | - | - | 1-2 | x | - | - | - | 2-1 | 1-0 | 1-2 | 2
 |  |  |  | A Jones |  |  |  | 5 | 0-1 | 1-2 | 1-0 | - | x | 3-0 | 0-1 | - | - | - | 2
 |  |  |  | [NAME] |  |  |  | 6 | 2-0 | 3-2 | - | - | 0-3 | x | - | - | - | 3-1 | 2
 |  |  |  | F Chalmers |  |  |  | 7 | 1-2 | 2-0 | - | - | 1-0 | - | x | 2-4 | - | - | 1
 |  |  |  | L Gray |  |  |  | 8 | - | - | 1-2 | 1-2 | - | - | 4-2 | x | - | 1-0 | 2
 |  |  |  | T Brewster |  |  |  | 9 | 1-2 | - | 1-4 | 0-1 | - | - | - | - | x | 1-5 | 0
 |  |  |  | H Gordon |  |  |  | 10 | - | - | - | 2-1 | - | 1-3 | - | 0-1 | 5-1 | x | 1
 |  |  |  |  |  |  | [NAME] 9
 |  |  |  |  |  |  | Team |  |  |  |  | P | W | L | LSD
 |  |  |  |  |  |  | A Smith |  |  |  |  | 1 | 1 | 0 | 143
 |  |  |  |  |  |  | A Murray |  |  |  |  | 1 | 0 | 1 | 66
 |  |  |  |  |  |  | C [NAME] |  |  |  |  | 1 | 1 | 0 | 14.6
 |  |  |  |  |  |  | D Murdoch |  |  |  |  | 1 | 0 | 1 | 12
 |  |  |  |  |  |  | A Jones |  |  |  |  | 1 | 0 | 1 | 13
 |  |  |  |  |  |  | [NAME] |  |  |  |  | 1 | 1 | 0 | 1
 |  |  |  |  |  |  | F Chalmers |  |  |  |  | 1 | 1 | 0 | 12.4
 |  |  |  |  |  |  | L Gray |  |  |  |  | 1 | 0 | 1 | 10
 |  |  |  |  |  |  | T Brewster |  |  |  |  | 1 | 0 | 1 | 11
 |  |  |  |  |  |  | H Gordon |  |  |  |  | 1 | 1 | 0 | 0
 |  | Comb Names |  |  |  | [NAME] |  |  |  |  |  | Running Totals after Game 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Original Grid
 |  |  |  |  | Team |  | P | W |  | LSD |  | Team |  | P | W | L | LSD |  |  |  |  |  |  |  |  | Team | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  | 0 0 |  |  | 0 | 0 |  |  |  |  |  | A | Smith | 4 | 3 | 1 | 37.81428571428571 |  |  |  |  |  |  |  | A Smith | 1 |  | 1 |  |  | 1 | 0 | 1 |  | 1
 |  | 0 0 |  |  | 0 | 0 |  |  |  |  |  | A | [NAME] | 3 | 1 | 2 | 35.44285714285714 |  |  |  |  |  |  |  | A Murray | 2 | 0 |  |  |  | 1 | 0 | 0
 |  | 0 0 |  |  | 0 | 0 |  |  |  |  |  | C | [NAME] | 3 | 2 | 1 | 13 |  |  |  |  |  |  |  | C [NAME] | 3 |  |  |  | 1 | 0 |  |  | 1 | 1
 |  | 0 0 |  |  | 0 | 0 |  |  |  |  |  | D | Murdoch | 3 | 2 | 1 | 15 |  |  |  |  |  |  |  | D Murdoch | 4 |  |  | 0 |  |  |  |  | 1 | 1 | 0
 |  | 0 0 |  |  | 0 | 0 |  |  |  |  |  | A | Jones | 4 | 2 | 2 | 33.7 |  |  |  |  |  |  |  | A Jones | 5 | 0 | 0 | 1 |  |  | 1 | 0
 |  | 0 0 |  |  | 0 | 0 |  |  |  |  |  | S | [NAME] | 3 | 2 | 1 | 11.3 |  |  |  |  |  |  |  | [NAME] | 6 | 1 | 1 |  |  | 0 |  |  |  |  | 1
 |  | 0 0 |  |  | 0 | 0 |  |  |  |  |  | F | Chalmers | 3 | 1 | 2 | 11.2 |  |  |  |  |  |  |  | F Chalmers | 7 | 0 | 1 |  |  | 1 |  |  | 0
 |  | 0 0 |  |  | 0 | 0 |  |  |  |  |  | L | Gray | 3 | 2 | 1 | 10.1 |  |  |  |  |  |  |  | L Gray | 8 |  |  | 0 | 0 |  |  | 1 |  |  | 1
 |  | 0 0 |  |  | 0 | 0 |  |  |  |  |  | T | Brewster | 3 | 0 | 3 | 1 |  |  |  |  |  |  |  | T Brewster | 9 | 0 |  | 0 | 0 |  |  |  |  |  | 0
 |  | 0 0 |  |  | 0 | 0 |  |  |  |  |  | H | [NAME] | 3 | 1 | 2 | 0.9 |  |  |  |  |  |  |  | H Gordon | 10 |  |  |  | 1 |  | 0 |  | 0 | 1