Spreadsheet: 41788d1240316659-award-points-from-scale-to-test-results-test2
Sheet: Month by Month

Month | Test Marks |  |  |  |  |  |  |  |  |  |  |  | Scoring System
Weeks 1 - 4 | Week 1 |  | Week 2 |  | Week 3 |  | Week 4 |  | Month |  |  |  | Test
Name | Score | Points | Score | Points | Score | Points | Score | Points | Average | Total |  |  | Scale to Points
[NAME] |  | #N/A |  | #N/A |  | #N/A |  | #N/A | #N/A | #N/A |  |  | Between |  | Points
[NAME] |  | #N/A |  | #N/A |  | #N/A |  | #N/A | #N/A | #N/A |  |  | 9 | 10 | 250
Julie |  | #N/A |  | #N/A |  | #N/A |  | #N/A | #N/A | #N/A |  |  | 8.75 | 8.99 | 225
[NAME] |  | #N/A |  | #N/A |  | #N/A |  | #N/A | #N/A | #N/A |  |  | 8.5 | 8.74 | 200
Doug |  | #N/A |  | #N/A |  | #N/A |  | #N/A | #N/A | #N/A |  |  | 8.25 | 8.49 | 175
[NAME] |  | #N/A |  | #N/A |  | #N/A |  | #N/A | #N/A | #N/A |  |  | 8 | 8.24 | 150
[NAME] |  | #N/A |  | #N/A |  | #N/A |  | #N/A | #N/A | #N/A |  |  | 7.75 | 7.99 | 125
[NAME] |  | #N/A |  | #N/A |  | #N/A |  | #N/A | #N/A | #N/A |  |  | 7.4 | 7.74 | 100
[NAME] |  | #N/A |  | #N/A |  | #N/A |  | #N/A | #N/A | #N/A |  |  | 7 | 7.39 | 25
Stuart |  | #N/A |  | #N/A |  | #N/A |  | #N/A | #N/A | #N/A |  |  | 0 | 6.99 | 0
Team | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scoring System |  |  |  | Scoring System |  |  |  | Scoring System
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Technical Enquiries |  |  |  | Conformance |  |  |  | AHT (Seconds)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Between |  | Points |  | Between |  | Points |  | Between |  | Points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.985 | 1.25 | 100 |  | 0.985 | 1.25 | 100 |  | 600 | 1000 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.975 | 0.9849 | 75 |  | 0.975 | 0.9849 | 75 |  | 551 | 559 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.95 | 0.9749 | 50 |  | 0.95 | 0.9749 | 25 |  | 530 | 550 | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.9 | 0.9499 | 25 |  | 0.9 | 0.9499 | 15 |  | 520 | 529 | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.85 | 0.8999 | 5 |  | 0.85 | 0.8999 | 5 |  | 490 | 519 | 75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.8499 | 0 |  | 0 | 0.8499 | 0 |  | 360 | 489 | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scoring System |  |  |  | Scoring System |  |  |  | Scoring System
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ACW (Seconds) |  |  |  | Pack Upgrade |  |  |  | A La Carte Upgrade
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Between |  | Points |  | Between |  | Points |  | Between |  | Points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 1000 | 0 |  | 16 | 100 | 100 |  | 16 | 100 | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 24 | 5 |  | 11 | 15 | 75 |  | 11 | 15 | 75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 19 | 25 |  | 6 | 10 | 50 |  | 6 | 10 | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 13 | 50 |  | 4 | 5 | 25 |  | 4 | 5 | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 9 | 75 |  | 2 | 3 | 10 |  | 2 | 3 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 4 | 100 |  | 0 | 1 | 0 |  | 0 | 1 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scoring System |  |  |  | Scoring System
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Premium Upgrade |  |  |  | Sky Protect
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Between |  | Points |  | Between |  | Points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | 100 | 150 |  | 16 | 100 | 150
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | 15 | 125 |  | 11 | 15 | 125
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 10 | 50 |  | 6 | 10 | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 5 | 25 |  | 4 | 5 | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 15 |  | 2 | 3 | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 0 |  | 0 | 1 | 0