Spreadsheet: 791480d1660384979-sorting-formulated-values-for-ranking-score-chart-ans-hd
Sheet: 2021 (with table)

Insert shifts in the box to the right |  | BMS 1 | BMS 2 | BMS 3 | BMS 4 | BMS 5 | BMS 6 | BMS 7 | BMS 8 | BMS 9 | BMS 10 | BMS 11 | BMS 12 | BMS 13 | BMS 14 | BMS 15 |  | Date | LD | N | SB
Friday | 2021-12-17 00:00:00 |  | LD |  | LD |  | N |  | LD | LD | LD |  | N | LD |  | LD |  |  | 1 | 1 | 0.5 |  | BMS | Score | Rank |  |  |  |  | BMS | Score | Rank
Saturday | 2021-12-18 00:00:00 |  | LD |  |  | LD |  |  |  |  | N |  | N | N | LD | LD |  |  | 1 | 1 | 0.5 |  |  |  |  |  |  |  |  | BMS 2 | 22.5 | 1
Sunday | 2021-12-19 00:00:00 |  |  |  |  | N |  |  |  |  |  |  | N | N | LD | LD |  |  | 1 | 1 | 0.5 |  | BMS 8 | 21.5 |  |  |  |  |  | BMS 8 | 21.5 | 2
Monday | 2021-12-20 00:00:00 |  |  | N |  |  |  | LD |  | N | LD | SB |  |  | LD |  |  |  | 1 | 1 | 0.5 |  | BMS 10 | 21.5 |  |  |  |  |  | BMS 10 | 21.5 | 2
Tuesday | 2021-12-21 00:00:00 |  |  | N |  | LD |  |  | LD |  | LD | N |  |  | LD |  |  |  | 1 | 1 | 0.5 |  | BMS 12 | 19 |  |  |  |  |  | BMS 12 | 19 | 4
Wednesday | 2021-12-22 00:00:00 | N | LD |  |  | LD |  | LD |  | SB |  |  | LD |  | N |  |  |  | 1 | 1 | 0.5 |  | BMS 7 | 18.5 |  |  |  |  |  | BMS 7 | 18.5 | 5
Thursday | 2021-12-23 00:00:00 | N | LD |  |  | LD |  | LD | SB |  |  |  | LD |  | N |  |  |  | 1 | 1 | 0.5 |  | BMS 5 | 17.5 |  |  |  |  |  | BMS 5 | 17.5 | 6
Friday | 2021-12-24 00:00:00 |  | N |  |  | LD |  |  | LD |  | SB | LD | N | SB |  |  |  |  | 3.5 | 4 | 2 |  | BMS 11 | 17 |  |  |  |  |  | BMS 11 | 17 | 7
Saturday | 2021-12-25 00:00:00 |  | N |  |  |  |  |  | LD |  | LD | SB | N | SB |  |  |  |  | 4 | 5 | 2 |  | BMS 13 | 13.5 |  |  |  |  |  | BMS 13 | 13.5 | 8
Sunday | 2021-12-26 00:00:00 |  | N |  |  |  |  | N | LD |  | LD |  | N | SB |  |  |  |  | 4 | 5 | 0.5 |  | BMS 1 | 11 |  |  |  |  |  | BMS 1 | 11 | 9
Monday | 2021-12-27 00:00:00 |  |  | N |  | LD |  | N | LD |  |  |  |  |  |  |  |  |  | 1.5 | 2.5 | 0.5 |  | BMS 4 | 9.5 |  |  |  |  |  | BMS 4 | 9.5 | 10
Tuesday | 2021-12-28 00:00:00 | LD |  |  |  |  | LD | N |  |  |  | N |  |  |  |  |  |  | 2 | 3 | 0.5 |  | BMS 14 | 9 |  |  |  |  |  | BMS 14 | 9 | 11
Wednesday | 2021-12-29 00:00:00 | N |  |  |  |  |  |  | SB |  | LD | N |  | LD | LD |  |  |  | 2 | 3 | 0.5 |  | BMS 6 | 5 |  |  |  |  |  | BMS 6 | 5 | 12
Thursday | 2021-12-30 00:00:00 | N |  |  | LD |  |  |  | LD |  | SB | N |  | LD | SB |  |  |  | 1 | 2 | 0.5 |  | BMS 3 | 4.5 |  |  |  |  |  | BMS 3 | 4.5 | 13
Friday | 2021-12-31 00:00:00 |  | LD |  | N | N | SB | SB | LD |  | LD |  |  |  |  |  |  |  | 2.5 | 3.5 | 1 |  | BMS 15 | 3 |  |  |  |  |  | BMS 15 | 3 | 14
Saturday | 2022-01-01 00:00:00 |  |  |  | N | N |  | LD |  |  | SB |  |  | LD |  |  |  |  | 1 | 2 | 1.5 |  | BMS 9 | 2.5 |  |  |  |  |  | BMS 9 | 2.5 | 15
Sunday | 2022-01-02 00:00:00 |  |  |  | N |  | LD | LD |  |  |  |  |  | N | SB |  |  |  | 1 | 1 | 0.5
Monday | 2022-01-03 00:00:00 | LD | N |  |  | LD |  | LD | N |  |  | LD |  |  |  |  |  |  | 1 | 1 | 0.5
Tuesday | 2022-01-04 00:00:00 | LD | N |  | LD | LD |  | LD | N |  | LD | LD |  | LD |  |  |  |  | 1 | 1 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | BMS 2
Scoring chart |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21.5 | 2 | 2 | 3 | BMS 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21.5 | 2 | 2 | 3 | BMS 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19 | 4 | 4 | 4 | BMS 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18.5 | 5 | 5 | 5 | BMS 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17.5 | 6 | 6 | 6 | BMS 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 | 7 | 7 | 7 | BMS 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13.5 | 8 | 8 | 8 | BMS 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | 9 | 9 | 9 | BMS 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.5 | 10 | 10 | 10 | BMS 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 11 | 11 | 11 | BMS 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 12 | 12 | 12 | BMS 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.5 | 13 | 13 | 13 | BMS 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 14 | 14 | 14 | BMS 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.5 | 15 | 15 | 15 | BMS 9
Score
Rank