Spreadsheet: 213473d1360533530-formula-to-return-an-offset-value-depending-on-a-condition-report
Sheet: DATA ENTRY

 |  |  |  |  |  |  |  |  |  | 1
 | Big Write Progress |  |  | - BIG WRITE |  |  |  |  |  |  |  | Date of graph report
 |  |  |  |  |  |  | SELECT -Term Start & Finish |  |  | T1 Start |  |  |  | T1 End |  |  |  |  | [NAME]
 |  |  |  |  | Big Write Type |  | SELECT - Big Write Type |  |  | Narrative | Narrative | Narrative | Narrative | Narrative | Narrative | Narrative | Narrative | Narrative | Other
 | First Name | Full Name | Start | Current | Movement | Current |  |  | Date | 2013-07-10 00:00:00 | 2013-09-19 00:00:00 | 2013-10-03 00:00:00 | 2013-10-16 00:00:00 | 2013-11-07 00:00:00 | 2012-11-28 00:00:00 | 2012-12-11 00:00:00 | 2013-01-09 00:00:00 | 2013-01-23 00:00:00 | 2013-02-06 00:00:00
 |  |  | Level | Level | Levels | Score
1 |  |  |  |  |  |  | Writes |  | Score | 9 | 8 | 9 | 14 | 14 | 14 | 15 | 15 | 16 | 8
 | Graph Notes                              Target Progress | Average |  |  |  |  | Absent |  | Level | 3c | 3c | 3c | 3b | 3b | 3b | 3a | 3a | 3a | 4c
 | Don't forget to use what we have talked about in class. |  |  |  |  |  | % Comp |  | Target | 3c | 3c | 3c | 3b | 3b | 3a | 3a | 3a | 4c | 4c
 |  |  |  |  |  |  | Writes |  | Score | 10 | 9 | 11 | 14 | 11 | 11 | 11 | 11 | 13 | 14
 | Graph Notes                              Target Progress | Excellent |  |  |  |  | Absent |  | Level | 3c | 3c | 3b | 3b | 3b | 3b | 3b | 3b | 3b | 3b
 | Well done.  Keep up the hard work. |  |  |  |  |  | % Comp |  | Target | 3c | 3c | 3b | 3b | 3b | 3a | 3a | 3a | 3a | 3a
 |  |  |  |  |  |  | Writes |  | Score | 8 | 6 | 6 | 9 | 11 | 6 | 10 | 10 | 12 | 13
 | Graph Notes                              Target Progress | Excellent |  |  |  |  | Absent |  | Level | 4c | 4c | 4c | 4c | 3b | 4c | 4b | 4b | 4b | 4b
 | Well done.  Keep up the hard work. |  |  |  |  |  | % Comp |  | Target | 4c | 4c | 4c | 4c | 4b | 4b | 4b | 4b | 4b | 4a
 |  |  |  |  |  |  | Writes |  | Score | 8 | 9 | 13 | 16 | 14 | 14 | 11 | 15 | 16 | 6
 | Graph Notes                              Target Progress | Excellent |  |  |  |  | Absent |  | Level | 3c | 3c | 3b | 3a | 3b | 3b | 3b | 3a | 3a | 4c
 | Well done.  Keep up the hard work. |  |  |  |  |  | % Comp |  | Target | 3c | 3c | 3b | 3b | 3a | 3a | 3a | 3a | 4c | 4c
 |  |  |  |  |  |  | Writes |  | Score | 10 | 10 | 10 | 10 | 10 | 12 | 11 | 11 | 12 | 16
 | Graph Notes                              Target Progress | Good |  |  |  |  | Absent |  | Level | 4b | 4b | 4b | 4b | 4b | 4b | 4b | 4b | 4b | 4a
 | Well done.  Keep up the hard work. |  |  |  |  |  | % Comp |  | Target | 4b | 4b | 4b | 4b | 4b | 4b | 4b | 4b | 4b | 4a
 |  |  |  |  |  |  | Writes |  | Score | 12 | 11 | 14 | A | 13 | 10 | 13 | 13 | A | 8
 | Graph Notes                              Target Progress | Good |  |  |  |  | Absent |  | Level | 3b | 3b | 3b | A | 3b | 3b | 3b | 3b | A | 4c
 | Well done.  Keep up the hard work. |  |  |  |  |  | % Comp |  | Target | 3b | 3b | 3b | 3b | 3a | 3a | 3a | 3a | 3a | 4c
 |  |  |  |  |  |  | Writes |  | Score | 8 | 13 | 11 | 9 | 8 | 12 | 14 | 11 | A | 16
 | Graph Notes                              Target Progress | Good |  |  |  |  | Absent |  | Level | 4c | 3b | 3b | 4c | 4c | 3b | 3b | 4b | A | 4a
 | Well done.  Keep up the hard work. |  |  |  |  |  | % Comp |  | Target | 4c | 4c | 4c | 4c | 4c | 4b | 4b | 4b | 4b | 4a
 |  |  |  |  |  |  | Writes |  | Score | 12 | 11 | 14 | 14 | 12 | 10 | 11 | A | 13 | 15
 | Graph Notes                              Target Progress | Good |  |  |  |  | Absent |  | Level | 3b | 3b | 3b | 3b | 3b | 3b | 3b | A | 3b | 3b
 | Well done.  Keep up the hard work. |  |  |  |  |  | % Comp |  | Target | 3b | 3b | 3b | 3b | 3b | 3a | 3a | 3a | 3a | 3a
 |  |  |  |  |  |  | Writes |  | Score | 14 | 12 | 12 | 12 | 13 | 14 | 14 | 18 | 18 | 9
 | Graph Notes                              Target Progress | Good |  |  |  |  | Absent |  | Level | 2b | 2c | 2c | 2c | 2b | 2b | 2b | 2a | 2a | 3c
 | Well done.  Keep up the hard work. |  |  |  |  |  | % Comp |  | Target | 2b | 2b | 2b | 2b | 2b | 2b | 2b | 2a | 2a | 3c
 |  |  |  |  |  |  | Writes |  | Score | 8 | 7 | 6 | 11 | 11 | 11 | 12 | 11 | 12 | 14
 | Graph Notes                              Target Progress | Good |  |  |  |  | Absent |  | Level | 4c | 4c | 4c | 4b | 4b | 4b | 4b | 4b | 4b | 4a
 | Well done.  Keep up the hard work. |  |  |  |  |  | % Comp |  | Target | 4c | 4c | 4c | 4b | 4b | 4b | 4b | 4b | 4b
 |  |  |  |  |  |  | Writes |  | Score | 11 | 10 | 11 | 13 | 13 | 11 | 12 | A | 11 | 15
 | Graph Notes                              Target Progress | Good |  |  |  |  | Absent |  | Level | 3b | 3c | 3b | 3b | 3b | 3b | 3b | A | 3b | 3b
 | You are doing well, keep listening in class. |  |  |  |  |  | % Comp |  | Target | 3b | 3b | 3b | 3b | 3b | 3a | 3a | 3a | 3a | 3a
 |  |  |  |  |  |  | Writes |  | Score | A | 7 | 10 | 10 | 10 | 10 | 11 | 12 | 16 | 17
 | Graph Notes                              Target Progress | Good |  |  |  |  | Absent |  | Level | A | 3c | 3c | 3c | 3c | 3b | 3b | 3b | 3a | 3a
 | Well done.  Keep up the hard work. |  |  |  |  |  | % Comp |  | Target | 3c | 3c | 3c | 3c | 3c | 3b | 3b | 3b | 3a | 4c
 |  |  |  |  |  |  | Writes |  | Score | 8 | 7 | 10 | 11 | 9 | 8 | 8 | 14 | 14 | 16
 | Graph Notes                              Target Progress | Excellent |  |  |  |  | Absent |  | Level | 3c | 3c | 3c | 3b | 3c | 3c | 3c | 3b | 3b | 3a
 | Well done.  Keep up the hard work. |  |  |  |  |  | % Comp |  | Target | 3c | 3c | 3c | 3b | 3b | 3b | 3b | 3b | 3a | 3a
 |  |  |  |  |  |  | Writes |  | Score | 8 | 8 | 11 | 11 | 11 | 9 | 11 | 10 | 12 | 13
 | Graph Notes                              Target Progress | Good |  |  |  |  | Absent |  | Level | 4c | 4c | 4b | 4b | 4b | 4c | 4b | 4b | 4b | 4b
 | Well done.  Keep up the hard work. |  |  |  |  |  | % Comp |  | Target | 4c | 4c | 4b | 4b | 4b | 4b | 4b | 4b | 4b | 4a
 |  |  |  |  |  |  | Writes |  | Score | A | A | A | A | A | A | A | A | A
 | Graph Notes                              Target Progress | Good |  |  |  |  | Absent |  | Level | A | A | A | A | A | A | A | A | A
 | Well done.  Keep up the hard work. |  |  |  |  |  | % Comp |  | Target
 |  |  |  |  |  |  | Writes |  | Score | A | 7 | 10 | 13 | 15 | 11 | 13 | 13 | 14 | 16
 | Graph Notes                              Target Progress | Good |  |  |  |  | Absent |  | Level | A | 3c | 3c | 3b | 3b | 3b | 3b | 3b | 3b | 3a
 | Well done.  Keep up the hard work. |  |  |  |  |  | % Comp |  | Target | 3c | 3c | 3c | 3b | 3b | 3a | 3a | 3a | 3a | 4c
 |  |  |  |  |  |  | Writes |  | Score | 7 | 12 | 14 | 7 | 6 | 6 | 9 | 10 | 12 | 17
 | Graph Notes                              Target Progress | Good |  |  |  |  | Absent |  | Level | 3c | 3b | 3b | 4c | 4c | 4c | 4b | 4b | 4b | 4a
 | Well done.  Keep up the hard work. |  |  |  |  |  | % Comp |  | Target | 3c | 3c | 3b | 3b | 4c | 4c | 4b | 4b | 4b | 4a
 |  |  |  |  |  |  | Writes |  | Score | 10 | 9 | 12 | 14 | 10 | 12 | 15 | 14 | 15 | 16
 | Graph Notes                              Target Progress | Excellent |  |  |  |  | Absent |  | Level | 4b | 4c | 4b | 4a | 4b | 4b | 4a | 4a | 4a | 4a
 | Well done.  Keep up the hard work. |  |  |  |  |  | % Comp |  | Target | 4b | 4b | 4b | 4b | 4b | 4b | 4a | 4a | 4a | 4a
 |  |  |  |  |  |  | Writes |  | Score | 10 | 9 | 11 | 12 | 15 | 13 | 14 | 16 | 16 | 7
 | Graph Notes                              Target Progress | Average |  |  |  |  | Absent |  | Level | 3c | 3c | 3b | 3b | 3b | 3b | 3b | 3a | 3a | 4c
 | Don't forget to use what we have talked about in class. |  |  |  |  |  | % Comp |  | Target | 3c | 3c | 3b | 3b | 3b | 3b | 3a | 3a | 3a | 4c
 |  |  |  |  |  |  | Writes |  | Score | A | A | A | A | A | A | A | A | A
 | Graph Notes                              Target Progress | Good |  |  |  |  | Absent |  | Level | A | A | A | A | A | A | A | A | A
 | You are doing well, keep listening in class. |  |  |  |  |  | % Comp |  | Target
 |  |  |  |  |  |  | Writes |  | Score | 8 | 9 | 13 | 13 | 11 | 10 | 13 | 13 | 14 | 16
 | Graph Notes                              Target Progress | Excellent |  |  |  |  | Absent |  | Level | 3c | 3c | 3b | 3b | 3b | 3b | 3b | 3b | 3b | 3a
 | Well done.  Keep up the hard work. |  |  |  |  |  | % Comp |  | Target | 3c | 3c | 3b | 3b | 3b | 3b | 3a | 3a | 3a | 3a
 |  |  |  |  |  |  | Writes |  | Score | 12 | 10 | 15 | 14 | 14 | A | 14 | 14 | 15 | 17
 | Graph Notes                              Target Progress | Good |  |  |  |  | Absent |  | Level | 3b | 3c | 3b | 3b | 3b | A | 3b | 3b | 3a | 3a
 | Well done.  Keep up the hard work. |  |  |  |  |  | % Comp |  | Target | 3b | 3b | 3b | 3b | 3a | 3a | 3a | 3a | 3a | 4c
 |  |  |  |  |  |  | Writes |  | Score | 8 | 9 | 9 | 9 | A | 8 | 13 | 12 | 14 | 17
 | Graph Notes                              Target Progress | Good |  |  |  |  | Absent |  | Level | 3c | 3c | 3c | 3c | A | 3c | 3b | 3b | 3b | 3a
 | You are doing well, keep listening in class. |  |  |  |  |  | % Comp |  | Target | 3c | 3c | 3c | 3c | 3b | 3b | 3a | 3b | 3a | 3a
 |  |  |  |  |  |  | Writes |  | Score | 4 | 4 | 4 | 4 | 4 | A | A | A | 5
 | Graph Notes                              Target Progress |  |  |  |  |  | Absent |  | Level | 1c | 1c | 1c | 1c | 1c | A | A | A | 1c
 | You are doing well, keep listening in class. |  |  |  |  |  | % Comp |  | Target | 1c | 1c | 1c | 1c | 1c | 1c | 1c | 1c | 1c
 |  |  |  |  |  |  | Writes |  | Score | 6 | 6 | 7 | 10 | 8 | 7 | 11 | 12 | 14 | 16
 | Graph Notes                              Target Progress |  |  |  |  |  | Absent |  | Level | 4c | 4c | 4c | 4b | 4c | 4c | 4b | 4b | 4a | 4a
 |  |  |  |  |  |  | % Comp |  | Target | 4c | 4c | 4c | 4b | 4b | 4b | 4b | 4b | 4a | 4a
 |  |  |  |  |  |  | Writes |  | Score | 10 | 10 | 11 | 11 | 11 | 10 | 12 | 12 | 13 | 17
 | Graph Notes                              Target Progress |  |  |  |  |  | Absent |  | Level | 3c | 3c | 3b | 3b | 3b | 3b | 3b | 3b | 3b | 3a
 |  |  |  |  |  |  | % Comp |  | Target | 3c | 3c | 3b | 3b | 3b | 3b | 3b | 3b | 3a | 4c
 |  |  |  |  |  |  | Writes |  | Score | A | A | A | A | A | A | A | A | 9
 | Graph Notes                              Target Progress |  |  |  |  |  | Absent |  | Level | A | A | A | A | A | A | A | A | 2c
 |  |  |  |  |  |  | % Comp |  | Target |  |  |  |  |  |  |  |  | 2c
 |  |  |  |  |  |  | Writes |  | Score | 9 | 7 | 9 | 7 | 15 | 11 | 14 | 14 | 15 | 16
 | Graph Notes                              Target Progress |  |  |  |  |  | Absent |  | Level | 3c | 3c | 3c | 3c | 3b | 3b | 3b | 3b | 3a | 3a
 |  |  |  |  |  |  | % Comp |  | Target | 3c | 3c | 3c | 3c | 3b | 3b | 3a | 3a | 3a | 4c
 |  |  |  |  |  |  | Writes |  | Score | 6 | 10 | 15 | 15 | 15 | 11 | 14 | 15 | 15 | 14
 | Graph Notes                              Target Progress |  |  |  |  |  | Absent |  | Level | 4c | 3c | 3b | 3b | 2b | 3b | 3b | 3a | 3a | 3b
 |  |  |  |  |  |  | % Comp |  | Target | 3a | 3a | 3a | 3a | 3a | 3a | 3a | 3a | 3a | 3a
 |  |  |  |  |  |  | Writes |  | Score | 10 | A | 10 | 12 | 10 | 9 | 11 | 11 | 12 | 15
 | Graph Notes                              Target Progress |  |  |  |  |  | Absent |  | Level | 4b | A | 4b | 4b | 4b | 4c | 4b | 4b | 4b | 4a
 |  |  |  |  |  |  | % Comp |  | Target | 4b | 4b | 4b | 4b | 4b | 4b | 4b | 4b | 4b | 4a
 |  |  |  |  |  |  | Writes |  | Score | A | 7 | 10 | 11 | 11 | 10 | 7 | 12 | 13 | A
 | Graph Notes                              Target Progress |  |  |  |  |  | Absent |  | Level | A | 3c | 3c | 3b | 3b | 3b | 3c | 3b | 3b | A
 |  |  |  |  |  |  | % Comp |  | Target | 3c | 3c | 3c | 3b | 3b | 3b | 3b | 3b | 3a | 3a
 |  |  |  |  |  |  | Writes |  | Score | 8 | 7 | 9 | 12 | 11 | 9 | 10 | 13 | 13 | 17
 | Graph Notes                              Target Progress |  |  |  |  |  | Absent |  | Level | 3c | 3c | 3c | 3b | 3b | 3c | 3b | 3b | 3b | 3a
 |  |  |  |  |  |  | % Comp |  | Target | 3c | 3c | 3c | 3b | 3b | 3b | 3b | 3a | 3a | 4c
 |  |  |  |  |  |  | Writes |  | Score
 | Graph Notes                              Target Progress |  |  |  |  |  | Absent |  | Level
 |  |  |  |  |  |  | % Comp |  | Target
 | Pupil Statements
 |  |  |  |  |  |  |  |  |  |  |  |  | 1a | 2c
 | Well done.  Keep up the hard work. |  |  |  |  |  |  |  |  |  |  | LOOKUP | 1b | 1a
 | Fantastic you have reached your target. |  |  |  |  |  |  |  |  |  |  |  | 1c | 1b
 | You are doing well, keep listening in class. |  |  |  |  |  |  |  |  |  |  |  | 2a | 3c
 | Don't forget to use what we have talked about in class. |  |  |  |  |  |  |  |  |  |  |  | 2b | 2a
 | Keep going like this and you will soon reach your target. |  |  |  |  |  |  |  |  |  |  |  | 2c | 2b
 | Comment |  |  |  |  |  |  |  |  |  |  |  | 3a | 4c
 | Comment |  |  |  |  |  |  |  |  |  |  |  | 3b | 3a
 | Comment |  |  |  |  |  |  |  |  |  |  |  | 3c | 3b
 | Comment |  |  |  |  |  |  |  |  |  |  |  | 4a | 5c
 | Comment |  |  |  |  |  |  |  |  |  |  |  | 4b | 4a
 | Comment |  |  |  |  |  |  |  |  |  |  |  | 4c | 4b
 |  |  |  |  |  |  |  |  |  |  |  |  | 5a | 5a
 |  |  |  |  |  |  |  |  |  |  |  |  | 5b | 5a
 |  |  |  |  |  |  |  |  |  |  |  |  | 5c | 5b
 |  |  |  |  |  |  |  |  |  |  |  | Spare
 |  |  |  |  |  |  |  |  |  |  |  | Spare
 | Pupil Progress |  |  | Term List |  |  |  |  |  |  |  | Spare
 |  |  |  |  |  |  |  |  |  |  |  | Spare
 |  | No Improvement |  | T1 Start
 |  | Average |  | T1 End
 |  | Good |  | [NAME] |  |  |  |  |  |  |  | Big Write Type
 |  | Very Good |  | T3 End
 |  | Excellent
 |  | Outstanding