Spreadsheet: 329973d1404472373-converting-rankings-to-scores-for-a-sports-spreadsheet-sports-day-results-spreadsheet
Sheet: Sheet1

Boys
100m Heat 1 |  |  |  |  | 100m Heat 2 |  |  |  |  | 100m Final
Name | Form | Position | Points |  | Name | Form | Position | Points |  | Name | Form | Position | Points
 | N | 4 | 5 |  |  | N |  |  |  |  | N
 | P | 5 | 4 |  |  | P |  |  |  |  | P
 | Q | 6 | 3 |  |  | Q |  |  |  |  | Q
 | R | 3 | 6 |  |  | R |  |  |  |  | R
 | S | 2 | 8 |  |  | S |  |  |  |  | S
 | T | 8 | 1 |  |  | T |  |  |  |  | T
 | V | 7 | 2 |  |  | V |  |  |  |  | V
 | X | 1 | 10 |  |  | X |  |  |  |  | X
Girls
100m Heat 1 |  |  |  |  | 100m Heat 2 |  |  |  |  | 100m Final
Name | Form | Position | Points |  | Name | Form | Position | Points |  | Name | Form | Position | Points
 | N |  |  |  |  | N |  |  |  |  | N
 | P |  |  |  |  | P |  |  |  |  | P
 | Q |  |  |  |  | Q |  |  |  |  | Q
 | R |  |  |  |  | R |  |  |  |  | R
 | S |  |  |  |  | S |  |  |  |  | S
 | T |  |  |  |  | T |  |  |  |  | T
 | V |  |  |  |  | V |  |  |  |  | V
 | X |  |  |  |  | X |  |  |  |  | X
Boys
200m Heat 1 |  |  |  |  | 200m Heat 2 |  |  |  |  | 200m Final
Name | Form | Position | Points |  | Name | Form | Position | Points |  | Name | Form | Position | Points
 | N |  |  |  |  | N |  |  |  |  | N
 | P |  |  |  |  | P |  |  |  |  | P
 | Q |  |  |  |  | Q |  |  |  |  | Q
 | R |  |  |  |  | R |  |  |  |  | R
 | S |  |  |  |  | S |  |  |  |  | S
 | T |  |  |  |  | T |  |  |  |  | T
 | V |  |  |  |  | V |  |  |  |  | V
 | X |  |  |  |  | X |  |  |  |  | X
Girls
200m Heat 1 |  |  |  |  | 200m Heat 2 |  |  |  |  | 200m Final
Name | Form | Position | Points |  | Name | Form | Position | Points |  | Name | Form | Position | Points
 | N |  |  |  |  | N |  |  |  |  | N
 | P |  |  |  |  | P |  |  |  |  | P
 | Q |  |  |  |  | Q |  |  |  |  | Q
 | R |  |  |  |  | R |  |  |  |  | R
 | S |  |  |  |  | S |  |  |  |  | S
 | T |  |  |  |  | T |  |  |  |  | T
 | V |  |  |  |  | V |  |  |  |  | V
 | X |  |  |  |  | X |  |  |  |  | X
Girls
300m Heat 1 |  |  |  |  | 300m Heat 2 |  |  |  |  | 300m Final
Name | Form | Position | Points |  | Name | Form | Position | Points |  | Name | Form | Position | Points
 | N |  |  |  |  | N |  |  |  |  | N
 | P |  |  |  |  | P |  |  |  |  | P
 | Q |  |  |  |  | Q |  |  |  |  | Q
 | R |  |  |  |  | R |  |  |  |  | R
 | S |  |  |  |  | S |  |  |  |  | S
 | T |  |  |  |  | T |  |  |  |  | T
 | V |  |  |  |  | V |  |  |  |  | V
 | X |  |  |  |  | X |  |  |  |  | X
Boys
400m Heat 1 |  |  |  |  | 400m [NAME] |  |  |  |  | 400m Final
Name | Form | Position | Points |  | Name | Form | Position | Points |  | Name | Form | Position | Points
 | N |  |  |  |  | N |  |  |  |  | N
 | P |  |  |  |  | P |  |  |  |  | P
 | Q |  |  |  |  | Q |  |  |  |  | Q
 | R |  |  |  |  | R |  |  |  |  | R
 | S |  |  |  |  | S |  |  |  |  | S
 | T |  |  |  |  | T |  |  |  |  | T
 | V |  |  |  |  | V |  |  |  |  | V
 | X |  |  |  |  | X |  |  |  |  | X
Boys
800m Heat 1 |  |  |  |  | 800m Heat 2 |  |  |  |  | 800m Final
Name | Form | Position | Points |  | Name | Form | Position | Points |  | Name | Form | Position | Points
 | N |  |  |  |  | N |  |  |  |  | N
 | P |  |  |  |  | P |  |  |  |  | P
 | Q |  |  |  |  | Q |  |  |  |  | Q
 | R |  |  |  |  | R |  |  |  |  | R
 | S |  |  |  |  | S |  |  |  |  | S
 | T |  |  |  |  | T |  |  |  |  | T
 | V |  |  |  |  | V |  |  |  |  | V
 | X |  |  |  |  | X |  |  |  |  | X
Girls
800m Heat 1 |  |  |  |  | 800m Heat 2 |  |  |  |  | 800m Final
Name | Form | Position | Points |  | Name | Form | Position | Points |  | Name | Form | Position | Points
 | N |  |  |  |  | N |  |  |  |  | N
 | P |  |  |  |  | P |  |  |  |  | P
 | Q |  |  |  |  | Q |  |  |  |  | Q
 | R |  |  |  |  | R |  |  |  |  | R
 | S |  |  |  |  | S |  |  |  |  | S
 | T |  |  |  |  | T |  |  |  |  | T
 | V |  |  |  |  | V |  |  |  |  | V
 | X |  |  |  |  | X |  |  |  |  | X
Boys
Javelin |  |  |  |  | Discus |  |  |  |  | [NAME]
Name | Form | Position | Points |  | Name | Form | Position | Points |  | Name | Form | Position | Points
 | N |  |  |  |  | N |  |  |  |  | N
 | P |  |  |  |  | P |  |  |  |  | P
 | Q |  |  |  |  | Q |  |  |  |  | Q
 | R |  |  |  |  | R |  |  |  |  | R
 | S |  |  |  |  | S |  |  |  |  | S
 | T |  |  |  |  | T |  |  |  |  | T
 | V |  |  |  |  | V |  |  |  |  | V
 | X |  |  |  |  | X |  |  |  |  | X
Long Jump |  |  |  |  | High Jump |  |  |  |  | 4x100 Relay
Name | Form | Position | Points |  | Name | Form | Position | Points |  | Name | Form | Position | Points
 | N |  |  |  |  | N |  |  |  |  | N
 | P |  |  |  |  | P |  |  |  |  | P
 | Q |  |  |  |  | Q |  |  |  |  | Q
 | R |  |  |  |  | R |  |  |  |  | R
 | S |  |  |  |  | S |  |  |  |  | S
 | T |  |  |  |  | T |  |  |  |  | T
 | V |  |  |  |  | V |  |  |  |  | V
 | X |  |  |  |  | X |  |  |  |  | X
Girls
Javelin |  |  |  |  | Discus |  |  |  |  | [NAME]
Name | Form | Position | Points |  | Name | Form | Position | Points |  | Name | Form | Position | Points
 | N |  |  |  |  | N |  |  |  |  | N
 | P |  |  |  |  | P |  |  |  |  | P
 | Q |  |  |  |  | Q |  |  |  |  | Q
 | R |  |  |  |  | R |  |  |  |  | R
 | S |  |  |  |  | S |  |  |  |  | S
 | T |  |  |  |  | T |  |  |  |  | T
 | V |  |  |  |  | V |  |  |  |  | V
 | X |  |  |  |  | X |  |  |  |  | X
Long Jump |  |  |  |  | High Jump |  |  |  |  | 4x100 Relay
Name | Form | Position | Points |  | Name | Form | Position | Points |  | Name | Form | Position | Points
 | N |  |  |  |  | N |  |  |  |  | N
 | P |  |  |  |  | P |  |  |  |  | P
 | Q |  |  |  |  | Q |  |  |  |  | Q
 | R |  |  |  |  | R |  |  |  |  | R
 | S |  |  |  |  | S |  |  |  |  | S
 | T |  |  |  |  | T |  |  |  |  | T
 | V |  |  |  |  | V |  |  |  |  | V
 | X |  |  |  |  | X |  |  |  |  | X