Spreadsheet: 159570d1338752760-help-to-automate-ranking-of-tied-teams-in-sports-scoring-program-9tmx5shts-sample-2
Sheet: Sheet

 |  |  |  |  |  |  |  |  |  |  |  | B9 to B26 will stay 1 to 9 till 72 match = Then it change to Final Rank
 |  |  |  |  |  |  |  |  |  |  |  | Cell L11 Once you put in W It will automatic to Final Rank. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sort if 3 team is tied then LSD.
 |  | RESULTS GRID |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 Team 4 sheet Round Robin |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank highest number to make high point
 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A         B        C         D    Bye |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You see pts add on [NAME] cell
 | Final |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 72 | 71 |  |  |  |  |  |  |  |  | 1 v 2   3 v 4   5 v 6   7 v 8    9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank Vs LSD
 | Rank | Team | SUI | JPN | FIN | LAT | DEN | SVK | CZE | GER | ITA |  | PL | W | L | LSD |  |  |  |  |  | 8 v 4   6 v 9   1 v 7   5 v 3    2 |  |  |  |  |  |  |  |  |  | PL | W | L | Diff | R1 | R2 | T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LSD |  | Total | R | CIF | FINAL
1 | 5 | SUI |  | W | L | L | W | W | W | L | L | 8 | 8 | 4 | 4 | 66.14285714285714 |  |  |  |  |  | 7 v 3   2 v 8   4 v 9   6 v 1    5 |  |  |  |  |  |  |  |  | SUI | 8 | 4 | 4 | 0 | 4000 | 400 | 4400 | 0 | 0 | 0 | SUIDEN | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3.11 | 0 | 0 | 0 | 0 | 4403.11 | 1 |  |  | 0 | 4403.11 | 5 | 1 | 5
 |  | LSD |  | 165.4 | 46.6 | 23.4 | 120 | 49.2 | 33 | 125.1 | 65.7 |  |  |  |  |  |  |  |  |  |  | 9 v 1   5 v 7   3 v 8   2 v 4    6
2 | 9 | JPN | L |  | L | L | W | W | L | L |  | 8 | 7 | 2 | 5 | 64.25714285714285 |  |  |  |  |  | 4 v 5   1 v 3   6 v 2   8 v 9    7 |  |  |  |  |  |  |  |  | JPN | 7 | 2 | 5 | -3 | 1000 | 100 | 1100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1100 | 1 |  |  | 0 | 1100 | 9 | 1 | 9
 |  | LSD | 65.4 |  | 122 | 12.4 | 123 | 67.7 | 185.4 | 12.3 | 47 |  |  |  |  |  |  |  |  |  |  | 3 v 6   9 v 2   7 v 4   1 v 5    8
3 | 3 | FIN | W | W |  | L | L | L | W | W | W | 8 | 8 | 5 | 3 | 86.60000000000001 | X |  |  |  |  | 2 v 7   8 v 5   9 v 3   4 v 6    1 |  |  |  |  |  |  |  |  | FIN | 8 | 5 | 3 | 2 | 6000 | 600 | 6600 | 0 | 0 | 0 | 0 | FINSVK | 0 | FINGER | FINITA | 0 | 0 | 0 | 0 | -3.1 | 0 | 3.11 | 3.11 | 6603.119999999999 | 3 | 1 | 86.60000000000001 | 1 | 6604.119999999999 | 3 | 1 | 3
 |  | LSD | 65.3 | 123 |  | 185.4 | 123 | 123.5 | 12.5 | 145 | 13.9 |  |  |  |  |  |  |  |  |  |  | 5 v 9   7 v 6   8 v 1   3 v 2    4
4 | 8 | LAT | W | W | W |  | L | L | L | L | L | 8 | 8 | 3 | 5 | 73.37142857142858 |  |  |  |  |  | 6 v 8   4 v 1   2 v 5   9 v 7    3 |  |  |  |  |  |  |  |  | LAT | 8 | 3 | 5 | -2 | 2000 | 200 | 2200 | 0 | 0 | 0 | 0 | 0 | LATCZE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -3.1 | 0 | 0 | 2196.9 | 1 |  |  | 0 | 2196.9 | 8 | 1 | 8
 |  | LSD | 65.3 | 65.3 | 123 |  | 123 | 145.6 | 12 | 0 | 125
5 | 6 | DEN | L | L | W | W |  | L | W | L | W | 8 | 8 | 4 | 4 | 72.52857142857144 |  |  |  |  |  | 1.  Enter data in the white cells in Page 1 only as the workshheet is password protedted |  |  |  |  |  |  |  |  | DEN | 8 | 4 | 4 | 0 | 4000 | 400 | 4400 | DENSUI | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -3.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4396.9 | 1 |  |  | 0 | 4396.9 | 6 | 1 | 6
 |  | LSD | 65.3 | 65.3 | 12 | 122 |  | 185.4 | 185.4 | 12 | 45.7 |  |  |  |  |  |  |  |  |  |  | to avoid accidental delection of the formulas. The password is   curler.
6 | 2 | SVK | L | L | W | W | W |  | W | W | L | 8 | 8 | 5 | 3 | 69.28571428571429 | X |  |  |  |  | 2.  Enter abbreviated team names in Col C of the grid and the ongoing scores "W" for |  |  |  |  |  |  |  |  | SVK | 8 | 5 | 3 | 2 | 6000 | 600 | 6600 | 0 | 0 | [NAME] | 0 | 0 | 0 | SVKGER | SVKITA | 0 | 0 | 3.11 | 0 | 0 | 0 | 3.11 | -3.1 | 6603.119999999999 | 3 | 1 | 69.28571428571429 | 2 | 6605.119999999999 | 2 | 1 | 2
 |  | LSD | 176.6 | 12 | 67.4 | 23 | 136.7 |  | 123 | 99.4 | 23.5 |  |  |  |  |  |  |  |  |  |  | a win "L" for a loss and the LSD in the appropriate box.
7 | 7 | CZE | L | W | L | W | W | L |  | L | L | 8 | 8 | 3 | 5 | 68.87142857142858 |  |  |  |  |  | 3.  Results will appear in Page 2 the chart below and show wins, ranking and the average |  |  |  |  |  |  |  |  | CZE | 8 | 3 | 5 | -2 | 2000 | 200 | 2200 | 0 | 0 | 0 | CZELAT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3.11 | 0 | 0 | 0 | 0 | 2203.11 | 1 |  |  | 0 | 2203.11 | 7 | 1 | 7
 |  | LSD | 123 | 45.6 | 98 | 45.7 | 120 | 23.9 |  | 48.5 | 100.4 |  |  |  |  |  |  |  |  |  |  | LSD with the least favourable distance deducted and will be printed A4 size.
8 | 4 | GER | W | W | L | W | W | L | W |  | L | 8 | 8 | 5 | 3 | 75.44285714285715 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GER | 8 | 5 | 3 | 2 | 6000 | 600 | 6600 | 0 | 0 | GERFIN | 0 | 0 | GERSVK | 0 | [NAME] | 0 | 0 | -3.1 | 0 | 0 | -3.1 | 0 | -3.1 | 6590.699999999999 | 1 |  |  | 0 | 6590.699999999999 | 4 | 1 | 4
 |  | LSD | 185.4 | 160 | 99.7 | 45 | 67.6 | 0 | 56.7 |  | 99.1
9 | 1 | ITA | W | L | L | W | L | W | W | W |  | 8 | 8 | 5 | 3 | 48 | X |  |  |  |  |  |  |  |  |  |  |  |  |  | ITA | 8 | 5 | 3 | 2 | 6000 | 600 | 6600 | 0 | 0 | [NAME] | 0 | 0 | ITASVK | 0 | ITAGER | 0 | 0 | -3.1 | 0 | 0 | 3.11 | 0 | 3.11 | 6603.119999999999 | 3 | 1 | 48 | 3 | 6606.119999999999 | 1 | 1 | 1
 |  | LSD | 24.7 | 105.4 | 46 | 0 | 57.6 | 185.4 | 78.4 | 23.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Page 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GF | P | Diff | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | SUIJPN | SUI | JPN | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 4 | FINLAT | FIN | LAT | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 6 | DENSVK | DEN | SVK | L | W | 0 | -3 | -1 | -3.1
 |  |  |  | Senior Curling Championships 2012 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 8 | CZEGER | CZE | GER | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 4 | GERLAT | GER | LAT | W | L | 1 | 3 | 1 | 3.11
 | Team |  |  | Played |  |  | Won |  |  | Lost |  |  | LSD |  |  | Final Rank |  |  |  | 6 | 9 | SVKITA | SVK | ITA | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 7 | SUICZE | SUI | CZE | W | L | 1 | 3 | 1 | 3.11
1 | ITA |  |  |  | 8 |  |  | 5 |  |  | 3 |  | 48 |  |  |  |  |  |  | 5 | 3 | DENFIN | DEN | FIN | W | L | 1 | 3 | 1 | 3.11
2 | SVK |  |  |  | 8 |  |  | 5 |  |  | 3 |  | 69.28571428571429 |  |  |  |  |  |  | 7 | 3 | CZEFIN | CZE | FIN | L | W | 0 | -3 | -1 | -3.1
3 | FIN |  |  |  | 8 |  |  | 5 |  |  | 3 |  | 86.60000000000001 |  |  |  |  |  |  | 2 | 8 | JPNGER | JPN | GER | L | W | 0 | -3 | -1 | -3.1
4 | GER |  |  |  | 8 |  |  | 5 |  |  | 3 |  | 75.44285714285715 |  |  |  |  |  |  | 4 | 9 | LATITA | LAT | ITA | L | W | 0 | -3 | -1 | -3.1
5 | SUI |  |  |  | 8 |  |  | 4 |  |  | 4 |  | 66.14285714285714 |  |  |  |  |  |  | 6 | 1 | SVKSUI | SVK | SUI | L | W | 0 | -3 | -1 | -3.1
6 | DEN |  |  |  | 8 |  |  | 4 |  |  | 4 |  | 72.52857142857144 |  |  |  |  |  |  | 9 | 1 | ITASUI | ITA | SUI | W | L | 1 | 3 | 1 | 3.11
7 | CZE |  |  |  | 8 |  |  | 3 |  |  | 5 |  | 68.87142857142858 |  |  |  |  |  |  | 5 | 7 | DENCZE | DEN | CZE | W | W | 1 | 3 | 1 | 3.11
8 | LAT |  |  |  | 8 |  |  | 3 |  |  | 5 |  | 73.37142857142858 |  |  |  |  |  |  | 3 | 8 | FINGER | FIN | GER | W | L | 1 | 3 | 1 | 3.11
9 | JPN |  |  |  | 7 |  |  | 2 |  |  | 5 |  | 64.25714285714285 |  |  |  |  |  |  | 2 | 4 | JPNLAT | JPN | LAT | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PAGE 2 |  | 4 | 5 | LATDEN | LAT | DEN | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 3 | SUIFIN | SUI | FIN | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 2 | [NAME] | SVK | JPN | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 9 | [NAME] | GER | ITA | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 6 | FINSVK | FIN | SVK | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 2 | ITAJPN | ITA | JPN | L | 0 | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 4 | CZELAT | CZE | LAT | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 5 | SUIDEN | SUI | DEN | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 7 | JPNCZE | JPN | CZE | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 5 | GERDEN | GER | DEN | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 3 | [NAME] | ITA | FIN | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 6 | LATSVK | LAT | SVK | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 9 | DENITA | DEN | ITA | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 6 | CZESVK | CZE | SVK | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 1 | GERSUI | GER | SUI | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 2 | FINJPN | FIN | JPN | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 8 | SVKGER | SVK | GER | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 1 | LATSUI | LAT | SUI | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 5 | [NAME] | JPN | DEN | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 7 | ITACZE | ITA | CZE | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 1 | JPNSUI | JPN | SUI | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 3 | LATFIN | LAT | FIN | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 5 | SVKDEN | SVK | DEN | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 7 | GERCZE | GER | CZE | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 8 | LATGER | LAT | GER | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 6 | ITASVK | ITA | SVK | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 1 | CZESUI | CZE | SUI | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 5 | FINDEN | FIN | DEN | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 7 | FINCZE | FIN | CZE | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 2 | GERJPN | GER | JPN | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 4 | ITALAT | ITA | LAT | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 6 | SUISVK | SUI | SVK | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 9 | SUIITA | SUI | ITA | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 5 | CZEDEN | CZE | DEN | W | W | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 3 | GERFIN | GER | FIN | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 2 | LATJPN | LAT | JPN | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 4 | DENLAT | DEN | LAT | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 1 | FINSUI | FIN | SUI | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 6 | JPNSVK | JPN | SVK | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 8 | ITAGER | ITA | GER | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 3 | [NAME] | SVK | FIN | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 9 | JPNITA | JPN | ITA | 0 | L | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 7 | LATCZE | LAT | CZE | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 1 | DENSUI | DEN | SUI | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 2 | CZEJPN | CZE | JPN | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 8 | DENGER | DEN | GER | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 9 | FINITA | FIN | ITA | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 4 | SVKLAT | SVK | LAT | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 5 | ITADEN | ITA | DEN | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 7 | SVKCZE | SVK | CZE | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 8 | SUIGER | SUI | GER | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | JPNFIN | JPN | FIN | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 6 | GERSVK | GER | SVK | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 4 | SUILAT | SUI | LAT | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 2 | DENJPN | DEN | JPN | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 9 | CZEITA | CZE | ITA | L | W | 0 | -3 | -1 | -3.1