Spreadsheet: 865326d1712349234-sum-of-only-top-6-values-in-each-row-test-book
Sheet: Sheet1

TOURNAMENT NAME |  | Total of | AR
 |  | best six | current
 |  | AR points | RANK | Oct |  | April |  | March |  | March |  | April |  | May |  | June |  | Oct |  | May |  | Sept |  | Nov |  | June |  | July |  | June |  |  |  | March |  | Sept |  | April |  | May
 | Weighting                  No of players/teams |  |  | 1 |  | 0.5 | 8 | 0.5 | 16 | 0.5 | 8 | 0.5 |  | 0.5 |  | 0.5 |  | 0.75 |  | 0.75 |  | 0.75 |  | 0.75 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25
Last Name | Full Name |  |  | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place |  | Place |  | Place |  | Place |  | Place |  | Place |  | Place |  | Place |  | Place |  | Place |  | Place |  | Place |  | Place |  | Place |  | Place |  | Place |  | Place
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SmallEvent
LAST N1 | FULL NAME1 |  |  |  |  |  |  | 1 | 500 | 1 | 500 |  |  |  |  |  |  | 1 | 750
LAST N2 | [NAME] | 600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 600
LAST N3 | FULL NAME3 | 500 |  |  |  | 1 | 500
LAST N4 | FULL NAME4 | 450 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 450
LAST N5 | FULL NAME5 | 400 |  |  |  |  |  | 2 | 400
LAST N6 | FULL NAME6 | 400 |  |  |  |  |  |  |  | 2 | 400
LAST N7 | FULL NAME7 | 400 |  |  |  | 2 | 400
LAST N8 | FULL NAME8 | 375 |  |  |  |  |  |  |  | 3 | 300 |  |  |  |  |  |  | 10 | 75
LAST N9 | FULL NAME9 | 200 |  |  |  | 4 | 200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 125
LAST N10 | FULL NAME10 | 300 |  |  |  |  |  | 3 | 300
LAST N11 | FULL NAME11 | 300 |  |  |  | 3 | 300
LAST N12 | FULL NAME12 | 300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 300
LAST N13 | FULL NAME13 | 200 |  |  |  |  |  |  |  | 4 | 200
LAST N14 | FULL NAME14 | 200 |  |  |  |  |  | 4 | 200
LAST N15 | FULL NAME15 | 150 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 150
LAST N16 | FULL NAME16 | 150 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 150
LAST N17 | FULL NAME17 | 150 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 150
LAST N18 | FULL NAME18 | 150 |  |  |  |  |  | 12 | 50 | 8 | 100
LAST N19 | FULL NAME19 | 101 |  |  |  |  |  | 8 | 100 |  |  |  |  |  |  |  |  | 19 | 1
LAST N20 | FULL NAME20 | 100 |  |  |  |  |  |  |  | 6 | 100
LAST N21 | FULL NAME21 | 100 |  |  |  |  |  | 6 | 100
LAST N22 | FULL NAME22 | 100 |  |  |  | 8 | 100
LAST N23 | FULL NAME23 | 100 |  |  |  | 5 | 100
LAST N24 | [NAME] | #[NAME]! |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 100
LAST N25 | FULL NAME25 | 100 |  |  |  | 7 | 100
LAST N26 | FULL NAME26 | 100 |  |  |  | 6 | 100
LAST N27 | FULL NAME27 | 100 |  |  |  |  |  | 5 | 100
LAST N28 | FULL NAME28 | 100 |  |  |  |  |  | 7 | 100
LAST N29 | FULL NAME29 | 100 |  |  |  |  |  |  |  | 7 | 100
LAST N30 | FULL NAME30 | 100 |  |  |  |  |  |  |  | 5 | 100
LAST N31 | FULL NAME31 | 75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | 75
LAST N32 | FULL NAME32 | 75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 75
LAST N33 | FULL NAME33 | 75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 75
LAST N34 | [NAME] | #[NAME]! |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 75
LAST N35 | FULL NAME35 | 50 |  |  |  |  |  | 9 | 50
LAST N36 | FULL NAME36 | 50 |  |  |  |  |  | 11 | 50
LAST N37 | FULL NAME37 | #[NAME]! |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 50
LAST N38 | FULL NAME38 | 50 |  |  |  |  |  | 10 | 50
LAST N39 | FULL NAME39 | 37.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 37.5
LAST N40 | FULL NAME40 | 37.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 37.5
LAST N41 | FULL NAME41 | 37.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 37.5
LAST N42 | FULL NAME42 | 37.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 37.5
LAST N43 | FULL NAME43 | 25 |  |  |  |  |  | 13 | 25
LAST N44 | FULL NAME44 | 25 |  |  |  |  |  | 15 | 25
LAST N45 | FULL NAME45 | 25 |  |  |  |  |  | 14 | 25
LAST N46 | [NAME] | 25 |  |  |  |  |  | 16 | 25
LAST N47 | [NAME] | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 | 1
LAST N48 | FULL NAME48 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 | 1
LAST N49 | FULL NAME49 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | 1
LAST N50 | FULL NAME50 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 1
LAST N51 | FULL NAME51 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 | 1
LAST N52 | FULL NAME52 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | 1
LAST N53 | FULL NAME53 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | 1
LAST N54 | FULL NAME54 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | 1
LAST N55 | [NAME] | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 | 1
LAST N56 | FULL NAME56 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 1