Spreadsheet: 795026d1662470719-updating-multiple-formula-to-read-the-same-cell-but-on-a-different-worksheet-assessment-example-sheet
Sheet: Baseline Calcs

 |  | Grade 1 |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | Grade 5
 |  | Actual Score | Marks Available | Actual [NAME] as a %age |  | Actual Score | Marks Available | Actual [NAME] as a %age |  | Actual Score | Marks Available | Actual [NAME] as a %age |  | Actual Score | Marks Available | Actual [NAME] as a %age |  | Actual Score | Marks Available | Actual [NAME] as a %age
NBT
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
 |  |  | 11 |  |  |  | 35 |  |  |  | 25 |  |  |  | 18 |  |  |  | 10
OA
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
 |  |  | 44 |  |  |  | 11 |  |  |  | 18 |  |  |  | 9 |  |  |  | 2
NF
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
 |  |  | 2 |  |  | 0 | 0 | 0 |  |  | 4 |  |  |  | 17 |  |  |  | 10
MD
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  |  | 4 |  |  |  | 3 |  |  |  | 9 |  |  |  | 12 |  |  |  | 4
 |  | [NAME]
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15
 |  |  | 4 |  |  |  | 2 |  |  |  | 5 |  |  |  | 6 |  |  |  | 15