Spreadsheet: 865320d1712346573-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] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 600
LAST N3 | FULL NAME3 |  |  |  |  | 1 | 500
LAST N4 | FULL NAME4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 450
LAST N5 | FULL NAME5 |  |  |  |  |  |  | 2 | 400
LAST N6 | FULL NAME6 |  |  |  |  |  |  |  |  | 2 | 400
LAST N7 | FULL NAME7 |  |  |  |  | 2 | 400
LAST N8 | FULL NAME8 |  |  |  |  |  |  |  |  | 3 | 300 |  |  |  |  |  |  | 10 | 75
LAST N9 | FULL NAME9 |  |  |  |  | 4 | 200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 125
LAST N10 | FULL NAME10 |  |  |  |  |  |  | 3 | 300
LAST N11 | FULL NAME11 |  |  |  |  | 3 | 300
LAST N12 | FULL NAME12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 300
LAST N13 | FULL NAME13 |  |  |  |  |  |  |  |  | 4 | 200
LAST N14 | FULL NAME14 |  |  |  |  |  |  | 4 | 200
LAST N15 | FULL NAME15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 150
LAST N16 | FULL NAME16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 150
LAST N17 | FULL NAME17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 150
LAST N18 | FULL NAME18 |  |  |  |  |  |  | 12 | 50 | 8 | 100
LAST N19 | FULL NAME19 |  |  |  |  |  |  | 8 | 100 |  |  |  |  |  |  |  |  | 19 | 1
LAST N20 | FULL NAME20 |  |  |  |  |  |  |  |  | 6 | 100
LAST N21 | FULL NAME21 |  |  |  |  |  |  | 6 | 100
LAST N22 | FULL NAME22 |  |  |  |  | 8 | 100
LAST N23 | FULL NAME23 |  |  |  |  | 5 | 100
LAST N24 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 100
LAST N25 | FULL NAME25 |  |  |  |  | 7 | 100
LAST N26 | FULL NAME26 |  |  |  |  | 6 | 100
LAST N27 | FULL NAME27 |  |  |  |  |  |  | 5 | 100
LAST N28 | FULL NAME28 |  |  |  |  |  |  | 7 | 100
LAST N29 | FULL NAME29 |  |  |  |  |  |  |  |  | 7 | 100
LAST N30 | FULL NAME30 |  |  |  |  |  |  |  |  | 5 | 100
LAST N31 | FULL NAME31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | 75
LAST N32 | FULL NAME32 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 75
LAST N33 | FULL NAME33 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 75
LAST N34 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 75
LAST N35 | FULL NAME35 |  |  |  |  |  |  | 9 | 50
LAST N36 | FULL NAME36 |  |  |  |  |  |  | 11 | 50
LAST N37 | FULL NAME37 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 50
LAST N38 | FULL NAME38 |  |  |  |  |  |  | 10 | 50
LAST N39 | FULL NAME39 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 37.5
LAST N40 | FULL NAME40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 37.5
LAST N41 | FULL NAME41 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 37.5
LAST N42 | FULL NAME42 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 37.5
LAST N43 | FULL NAME43 |  |  |  |  |  |  | 13 | 25
LAST N44 | FULL NAME44 |  |  |  |  |  |  | 15 | 25
LAST N45 | FULL NAME45 |  |  |  |  |  |  | 14 | 25
LAST N46 | [NAME] |  |  |  |  |  |  | 16 | 25
LAST N47 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 | 1
LAST N48 | FULL NAME48 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 | 1
LAST N49 | FULL NAME49 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | 1
LAST N50 | FULL NAME50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 1
LAST N51 | FULL NAME51 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 | 1
LAST N52 | FULL NAME52 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | 1
LAST N53 | FULL NAME53 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | 1
LAST N54 | FULL NAME54 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | 1
LAST N55 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 | 1
LAST N56 | FULL NAME56 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 1