Spreadsheet: 456314d1460741986-conditional-formatting-gap-analysis-1-
Sheet: Spring 2 - Point Score

Gap Analysis 2015 - 2016
 |  | Reading |  |  |  |  |  |  |  |  |  |  |  | Writing |  |  |  |  |  |  |  |  |  |  |  | Maths |  |  |  |  |  |  |  |  |  |  |  | SPaG
Year 1 | Pupils | Aut 1 | Gap | Aut 2 | Gap | Spr 1 | Gap | Spr 2 | Gap | Sum 1 | Gap | Sum 2 | Gap | Aut 1 | Gap | Aut 2 | Gap | Spr 1 | Gap | Spr 2 | Gap | Sum 1 | Gap | Sum 2 | Gap | Aut 1 | Gap | Aut 2 | Gap | Spr 1 | Gap | Spr 2 | Gap | Sum 1 | Gap | Sum 2 | Gap | Aut 1 | Gap | Aut 2 | Gap | Spr 1 | Gap | Spr 2 | Gap | Sum 1 | Gap | Sum 2 | Gap
All | 29 | 15.8 |  | 16.1 |  | 16.7 |  | 17.2 |  |  |  |  |  | 15.6 |  | 16.3 |  | 16.9 |  | 17.3 |  |  |  |  |  | 15.9 |  | 16 |  | 16.9 |  | 17.3 |  |  |  |  |  | 15.4 |  | 16.3 |  | 16.8 |  | 17.2
Boys | 16 | 15.4 |  | 15.8 |  | 16.5 |  | 17 |  |  |  |  |  | 15.3 |  | 16.2 |  | 16.7 |  | 17.1 |  |  |  |  |  | 16 |  | 16 |  | 16.9 |  | 17.3 |  |  |  |  |  | 15.3 |  | 16.1 |  | 16.6 |  | 17.1
Girls | 13 | 16.2 |  | 16.4 |  | 17 |  | 17.5 |  |  |  |  |  | 16 |  | 16.5 |  | 17.2 |  | 17.5 |  |  |  |  |  | 15.8 |  | 16.1 |  | 17 |  | 17.3 |  |  |  |  |  | 15.7 |  | 16.5 |  | 17.1 |  | 17.4
PP | 7 | 14.9 |  | 15.4 |  | 16.2 |  | 16.9 |  |  |  |  |  | 14.9 |  | 16.1 |  | 16.5 |  | 16.9 |  |  |  |  |  | 16 |  | 15.9 |  | 16.7 |  | 17.1 |  |  |  |  |  | 14.9 |  | 15.9 |  | 16.4 |  | 16.9
SEN | 7 | 14.1 |  | 15.2 |  | 15.9 |  | 16.6 |  |  |  |  |  | 14.1 |  | 15.9 |  | 16.1 |  | 16.6 |  |  |  |  |  | 15.6 |  | 15.7 |  | 16.5 |  | 16.9 |  |  |  |  |  | 14 |  | 15.7 |  | 16 |  | 16.6
EAL | 2 | 15.5 |  | 15.8 |  | 16.5 |  | 17.3 |  |  |  |  |  | 15.5 |  | 16.3 |  | 16.5 |  | 17 |  |  |  |  |  | 14.5 |  | 15.5 |  | 16.5 |  | 17 |  |  |  |  |  | 15 |  | 16.3 |  | 16.5 |  | 17
AfA | - | - |  | - |  |  |  |  |  |  |  |  |  | - |  | - |  |  |  |  |  |  |  |  |  | - |  | - |  |  |  |  |  |  |  |  |  | - |  | -
 |  | Reading |  |  |  |  |  |  |  |  |  |  |  | Writing |  |  |  |  |  |  |  |  |  |  |  | Maths |  |  |  |  |  |  |  |  |  |  |  | SPaG
Year 2 | Pupils | Aut 1 | Gap | Aut 2 | Gap | Spr 1 | Gap | Spr 2 | Gap | Sum 1 | Gap | Sum 2 | Gap | Aut 1 | Gap | Aut 2 | Gap | Spr 1 | Gap | Spr 2 | Gap | Sum 1 | Gap | Sum 2 | Gap | Aut 1 | Gap | Aut 2 | Gap | Spr 1 | Gap | Spr 2 | Gap | Sum 1 | Gap | Sum 2 | Gap | Aut 1 | Gap | Aut 2 | Gap | Spr 1 | Gap | Spr 2 | Gap | Sum 1 | Gap | Sum 2 | Gap
All | 30 | 18.8 |  | 19.8 |  | 19.8 |  | 20.2 |  |  |  |  |  | 18.8 |  | 19.6 |  | 19.9 |  | 20.1 |  |  |  |  |  | 18.7 |  | 19.3 |  | 19.5 |  | 20 |  |  |  |  |  | 18.7 |  | 19.4 |  | 19.3 |  | 20.1
Boys | 11 | 18.8 |  | 19.8 |  | 19.8 |  | 20.2 |  |  |  |  |  | 18.8 |  | 19.5 |  | 19.9 |  | 20.1 |  |  |  |  |  | 18.7 |  | 19.2 |  | 19.4 |  | 19.9 |  |  |  |  |  | 18.7 |  | 19.3 |  | 19.3 |  | 20
Girls | 19 | 18.8 |  | 19.8 |  | 19.8 |  | 20.2 |  |  |  |  |  | 18.8 |  | 19.7 |  | 19.9 |  | 20.1 |  |  |  |  |  | 18.7 |  | 19.3 |  | 19.6 |  | 20 |  |  |  |  |  | 18.7 |  | 19.4 |  | 19.3 |  | 20.1
PP | 7 | 18 |  | 19.3 |  | 19.3 |  | 19.9 |  |  |  |  |  | 18 |  | 18.9 |  | 19.2 |  | 19.4 |  |  |  |  |  | 18 |  | 18.8 |  | 19.1 |  | 19.4 |  |  |  |  |  | 18.1 |  | 18.6 |  | 18.6 |  | 19.5
SEN | 5 | 17.6 |  | 18.9 |  | 18.9 |  | 19.5 |  |  |  |  |  | 17.6 |  | 18.6 |  | 18.9 |  | 19.3 |  |  |  |  |  | 17.5 |  | 18.5 |  | 18.5 |  | 19.1 |  |  |  |  |  | 17.8 |  | 18.3 |  | 18.3 |  | 19.1
EAL | 1 | 19 |  | 20.5 |  | 20.5 |  | 20.5 |  |  |  |  |  | 19 |  | 20 |  | 20.5 |  | 20.5 |  |  |  |  |  | 19 |  | 19.5 |  | 20 |  | 20.5 |  |  |  |  |  | 19 |  | 20 |  | 20 |  | 20.5
AfA | 6 | 19 |  | 19.6 |  | 19.6 |  | 20.1 |  |  |  |  |  | 19 |  | 19.4 |  | 19.8 |  | 20 |  |  |  |  |  | 19 |  | 19.2 |  | 19.6 |  | 20 |  |  |  |  |  | 19 |  | 19.2 |  | 19.2 |  | 20.1
 |  | Reading |  |  |  |  |  |  |  |  |  |  |  | Writing |  |  |  |  |  |  |  |  |  |  |  | Maths |  |  |  |  |  |  |  |  |  |  |  | SPaG
Year 3 | Pupils | Aut 1 | Gap | Aut 2 | Gap | Spr 1 | Gap | Spr 2 | Gap | Sum 1 | Gap | Sum 2 | Gap | Aut 1 | Gap | Aut 2 | Gap | Spr 1 | Gap | Spr 2 | Gap | Sum 1 | Gap | Sum 2 | Gap | Aut 1 | Gap | Aut 2 | Gap | Spr 1 | Gap | Spr 2 | Gap | Sum 1 | Gap | Sum 2 | Gap | Aut 1 | Gap | Aut 2 | Gap | Spr 1 | Gap | Spr 2 | Gap | Sum 1 | Gap | Sum 2 | Gap
All | 30 | 21.3 |  | 21.922 |  | 22.6 |  | 23.1 |  |  |  |  |  | 20.9 |  | 21.6 |  | 22.3 |  | 22.9 |  |  |  |  |  | 20.9 |  | 21.6 |  | 22.1 |  | 22.9 |  |  |  |  |  | 20.8 |  | 21.5 |  | 22.3 |  | 22.9
Boys | 12 | 21.4 |  | 22 |  | 22.6 |  | 23.1 |  |  |  |  |  | 20.9 |  | 21.6 |  | 22.3 |  | 23 |  |  |  |  |  | 21 |  | 21.7 |  | 22.3 |  | 23.1 |  |  |  |  |  | 20.8 |  | 21.5 |  | 22.3 |  | 23
Girls | 18 | 21.2 |  | 21.9 |  | 22.5 |  | 23.1 |  |  |  |  |  | 21 |  | 21.6 |  | 22.3 |  | 22.9 |  |  |  |  |  | 20.9 |  | 21.5 |  | 22 |  | 22.7 |  |  |  |  |  | 20.8 |  | 21.5 |  | 22.3 |  | 22.8
PP | 6 | 21.6 |  | 22.1 |  | 22.7 |  | 23.2 |  |  |  |  |  | 20.8 |  | 21.3 |  | 22.3 |  | 23 |  |  |  |  |  | 20.9 |  | 21.7 |  | 22.2 |  | 22.8 |  |  |  |  |  | 21 |  | 21.5 |  | 22.3 |  | 23
SEN | 8 | 20.5 |  | 21.3 |  | 22 |  | 22.7 |  |  |  |  |  | 20.1 |  | 20.9 |  | 21.8 |  | 22.5 |  |  |  |  |  | 20.1 |  | 20.9 |  | 21.6 |  | 22.2 |  |  |  |  |  | 19.9 |  | 20.6 |  | 21.7 |  | 22.4
EAL | 5 | 21.6 |  | 22.1 |  | 22.7 |  | 23.2 |  |  |  |  |  | 21.6 |  | 22.1 |  | 22.6 |  | 23.1 |  |  |  |  |  | 21.5 |  | 22 |  | 22.5 |  | 23.3 |  |  |  |  |  | 21.1 |  | 21.8 |  | 22.7 |  | 23.2
AfA | 6 | 20.7 |  | 21.6 |  | 22.3 |  | 22.9 |  |  |  |  |  | 20.3 |  | 21.2 |  | 21.9 |  | 22.6 |  |  |  |  |  | 20.3 |  | 21.2 |  | 21.9 |  | 22.6 |  |  |  |  |  | 20.3 |  | 21 |  | 22 |  | 22.6
 |  | Reading |  |  |  |  |  |  |  |  |  |  |  | Writing |  |  |  |  |  |  |  |  |  |  |  | Maths |  |  |  |  |  |  |  |  |  |  |  | SPaG
Year 4 | Pupils | Aut 1 | Gap | Aut 2 | Gap | Spr 1 | Gap | Spr 2 | Gap | Sum 1 | Gap | Sum 2 | Gap | Aut 1 | Gap | Aut 2 | Gap | Spr 1 | Gap | Spr 2 | Gap | Sum 1 | Gap | Sum 2 | Gap | Aut 1 | Gap | Aut 2 | Gap | Spr 1 | Gap | Spr 2 | Gap | Sum 1 | Gap | Sum 2 | Gap | Aut 1 | Gap | Aut 2 | Gap | Spr 1 | Gap | Spr 2 | Gap | Sum 1 | Gap | Sum 2 | Gap
All | 30 | 23.9 |  | 24.8 |  | 25.3 |  | 25.8 |  |  |  |  |  | 23.8 |  | 24.6 |  | 25.1 |  | 25.6 |  |  |  |  |  | 24.1 |  | 24.7 |  | 25 |  | 25.6 |  |  |  |  |  | 23.9 |  | 24.5 |  | 25 |  | 25.4
Boys | 15 | 23.3 |  | 24.4 |  | 25 |  | 25.5 |  |  |  |  |  | 23.2 |  | 24.2 |  | 24.7 |  | 25.3 |  |  |  |  |  | 24 |  | 24.7 |  | 25.1 |  | 25.6 |  |  |  |  |  | 23.4 |  | 24 |  | 24.5 |  | 25
Girls | 15 | 24.6 |  | 25.1 |  | 25.6 |  | 26.1 |  |  |  |  |  | 24.4 |  | 24.9 |  | 25.4 |  | 25.9 |  |  |  |  |  | 24.2 |  | 24.8 |  | 25 |  | 25.6 |  |  |  |  |  | 24.4 |  | 24.9 |  | 25.5 |  | 25.8
PP | 7 | 24 |  | 24.6 |  | 25.1 |  | 25.5 |  |  |  |  |  | 23.9 |  | 24.4 |  | 24.9 |  | 25.4 |  |  |  |  |  | 23.9 |  | 24.4 |  | 24.7 |  | 25.1 |  |  |  |  |  | 24 |  | 24.6 |  | 25.2 |  | 25.6
SEN | 9 | 23.2 |  | 24.3 |  | 24.8 |  | 25 |  |  |  |  |  | 22.9 |  | 24.1 |  | 24.4 |  | 24.9 |  |  |  |  |  | 23.1 |  | 23.8 |  | 24.1 |  | 24.5 |  |  |  |  |  | 22.9 |  | 23.8 |  | 24.3 |  | 24.7
EAL | 2 | 17.8 |  | 19.8 |  | 21.3 |  | 21.8 |  |  |  |  |  | 19 |  | 19.8 |  | 20.8 |  | 21.3 |  |  |  |  |  | 23.5 |  | 24.3 |  | 25 |  | 26 |  |  |  |  |  | 18.8 |  | 19.5 |  | 20.5 |  | 21.3
AfA | 5 | 24.1 |  | 25 |  | 25.5 |  | 26 |  |  |  |  |  | 23.9 |  | 24.7 |  | 25.1 |  | 25.7 |  |  |  |  |  | 24 |  | 24.5 |  | 24.8 |  | 25.2 |  |  |  |  |  | 23.6 |  | 24.6 |  | 25.2 |  | 25.6
 |  | Reading |  |  |  |  |  |  |  |  |  |  |  | Writing |  |  |  |  |  |  |  |  |  |  |  | Maths |  |  |  |  |  |  |  |  |  |  |  | SPaG
Year 5 | Pupils | Aut 1 | Gap | Aut 2 | Gap | Spr 1 | Gap | Spr 2 | Gap | Sum 1 | Gap | Sum 2 | Gap | Aut 1 | Gap | Aut 2 | Gap | Spr 1 | Gap | Spr 2 | Gap | Sum 1 | Gap | Sum 2 | Gap | Aut 1 | Gap | Aut 2 | Gap | Spr 1 | Gap | Spr 2 | Gap | Sum 1 | Gap | Sum 2 | Gap | Aut 1 | Gap | Aut 2 | Gap | Spr 1 | Gap | Spr 2 | Gap | Sum 1 | Gap | Sum 2 | Gap
All | 31 | 27 |  | 27.5 |  | 28 |  | 28.5 |  |  |  |  |  | 26.8 |  | 27.4 |  | 28.1 |  | 28.6 |  |  |  |  |  | 26.7 |  | 27.2 |  | 27.9 |  | 28.2 |  |  |  |  |  | 26.3 |  | 27.2 |  | 27.7 |  | 28.7
Boys | 15 | 26.9 |  | 27.4 |  | 28 |  | 28.5 |  |  |  |  |  | 26.7 |  | 27.3 |  | 28 |  | 28.5 |  |  |  |  |  | 26.7 |  | 27.2 |  | 27.9 |  | 28.3 |  |  |  |  |  | 26.4 |  | 27.1 |  | 27.8 |  | 28.6
Girls | 16 | 27.2 |  | 27.6 |  | 28.1 |  | 28.6 |  |  |  |  |  | 26.8 |  | 27.5 |  | 28.2 |  | 28.7 |  |  |  |  |  | 26.7 |  | 27.2 |  | 27.9 |  | 28.2 |  |  |  |  |  | 26.3 |  | 27.3 |  | 27.7 |  | 28.8
PP | 7 | 27.1 |  | 27.6 |  | 28.1 |  | 28.5 |  |  |  |  |  | 26.8 |  | 27.4 |  | 28.1 |  | 28.5 |  |  |  |  |  | 26.5 |  | 27 |  | 27.8 |  | 28.1 |  |  |  |  |  | 26.4 |  | 26.8 |  | 27.7 |  | 28.6
SEN | 9 | 25.7 |  | 26.2 |  | 26.7 |  | 27.2 |  |  |  |  |  | 25.5 |  | 26.3 |  | 27.1 |  | 27.6 |  |  |  |  |  | 26.1 |  | 26.5 |  | 27.3 |  | 27.6 |  |  |  |  |  | 24.8 |  | 25.9 |  | 26.4 |  | 27.7
EAL | - | - |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | -
AfA | 4 | 26.1 |  | 26.6 |  | 27.1 |  | 27.4 |  |  |  |  |  | 25.1 |  | 26.1 |  | 27.3 |  | 27.8 |  |  |  |  |  | 25.9 |  | 26.4 |  | 27.5 |  | 27.6 |  |  |  |  |  | 24.8 |  | 25.9 |  | 26.5 |  | 28
 |  | Reading |  |  |  |  |  |  |  |  |  |  |  | Writing |  |  |  |  |  |  |  |  |  |  |  | Maths |  |  |  |  |  |  |  |  |  |  |  | SPaG
Year 6 | Pupils | Aut 1 | Gap | Aut 2 | Gap | Spr 1 | Gap | Spr 2 | Gap | Sum 1 | Gap | Sum 2 | Gap | Aut 1 | Gap | Aut 2 | Gap | Spr 1 | Gap | Spr 2 | Gap | Sum 1 | Gap | Sum 2 | Gap | Aut 1 | Gap | Aut 2 | Gap | Spr 1 | Gap | Spr 2 | Gap | Sum 1 | Gap | Sum 2 | Gap | Aut 1 | Gap | Aut 2 | Gap | Spr 1 | Gap | Spr 2 | Gap | Sum 1 | Gap | Sum 2 | Gap
All | 30 | 29.3 |  | 30.4 |  | 31.1 |  | 31.7 |  |  |  |  |  | 29.5 |  | 30.5 |  | 30.9 |  | 31.4 |  |  |  |  |  | 29.2 |  | 29.8 |  | 30.6 |  | 31 |  |  |  |  |  | 28.3 |  | 30.1 |  | 30.6 |  | 31.3
Boys | 14 | 29.7 |  | 30.7 |  | 31.4 |  | 32.1 |  |  |  |  |  | 29.9 |  | 30.8 |  | 31.1 |  | 31.7 |  |  |  |  |  | 29.9 |  | 30.4 |  | 31.3 |  | 31.9 |  |  |  |  |  | 29 |  | 30.4 |  | 30.9 |  | 31.6
Girls | 16 | 28.9 |  | 30.2 |  | 30.8 |  | 31.3 |  |  |  |  |  | 29.2 |  | 30.3 |  | 30.8 |  | 31.2 |  |  |  |  |  | 28.5 |  | 29.3 |  | 29.9 |  | 30.2 |  |  |  |  |  | 27.7 |  | 29.8 |  | 30.4 |  | 31.1
PP | 11 | 28.8 |  | 29.9 |  | 30.5 |  | 31.1 |  |  |  |  |  | 29.1 |  | 30 |  | 30.5 |  | 31 |  |  |  |  |  | 28.9 |  | 29.7 |  | 30.2 |  | 30.6 |  |  |  |  |  | 27.6 |  | 29.7 |  | 30.2 |  | 30.9
SEN | 11 | 28 |  | 29.3 |  | 29.9 |  | 30.6 |  |  |  |  |  | 28.5 |  | 29.5 |  | 30 |  | 30.5 |  |  |  |  |  | 27.4 |  | 27.8 |  | 28.9 |  | 29.3 |  |  |  |  |  | 27 |  | 28.8 |  | 29.5 |  | 30.3
EAL | 2 | 26.5 |  | 30 |  | 31 |  | 32 |  |  |  |  |  | 26.5 |  | 29.5 |  | 31 |  | 31.5 |  |  |  |  |  | 29.5 |  | 31 |  | 31.5 |  | 32 |  |  |  |  |  | 23.8 |  | 29.8 |  | 30.8 |  | 31.5
AfA | 4 | 29.9 |  | 31 |  | 31.5 |  | 32.3 |  |  |  |  |  | 30 |  | 31.1 |  | 31.5 |  | 32 |  |  |  |  |  | 29.3 |  | 29.5 |  | 31 |  | 31.4 |  |  |  |  |  | 29.4 |  | 30.9 |  | 31.3 |  | 32
 | not in use |  |  |  |  | Y1 | Y2 | Y3 | Y4 | Y5 | Y6
 | Aut 1 | Target Point Score |  |  |  | 15.5
 | Aut 2 | Target Point Score
 | Spr 1 | Target Point Score
 | Spr 2 | Target Point Score
 | Sum 1 | Target Point Score
 | Sum 2 | Target Point Score
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | not needed
Below |  | In Line |  |  |  |  |  |  |  |  |  |  |  |  |  | =NÃO(É.NÚM(C6))
- < | 0.5 | +/- | 0.4 |  |  |  |  |  |  |  |  |  |  |  |  | =C6>=$G$65+$D$82
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =E(C6>=$G$65+$B$82;C6<=$G$65+$D$82)
Above |  | Sig Above |  |  |  |  |  |  |  |  |  |  |  |  |  | =E(C6>=$G$65-$D$79;C6<=$G$65+$D$79)
+ > | 0.5 | + | 1 |  |  |  |  |  |  |  |  |  |  |  |  | =[NAME]
 | in use
 |  | Aut 1 |  | Aut 2 |  | Spr 1 |  | Spr 2 |  | Sum 1 |  | Sum 2 |  |  |  | =(RESTO(COL(C6);2)=1)
 | Y1 | 15.5 |  | 16 |  | 16.5 |  | 17 |  | 17.5 |  | 18 |  |  |  | =(RESTO(COL(C6);2)=1)*(C6>=DESLOCAMENTO(C$85;(LIN(C6)-6)/10;-12*QUOCIENTE(COL(C$1)-2;13))+$D$82)
 | Y2 | 18.5 |  | 19 |  | 19.5 |  | 20 |  | 20.5 |  | 21 |  |  |  | =C6>=DESLOCAMENTO(C$85;(LIN(C6)-6)/10;-12*QUOCIENTE(COL(C$1)-2;13))+$B$82
 | Y3 | 20.5 |  | 21 |  | 21.5 |  | 22 |  | 22.5 |  | 23 |  |  |  | =(RESTO(COL(C6);2)=1)*(C6>=DESLOCAMENTO(C$85;(LIN(C6)-6)/10;-12*QUOCIENTE(COL(C$1)-2;13))-$D$79)
 | Y4 | 23.5 |  | 24 |  | 24.5 |  | 25 |  | 25.5 |  | 26
 | Y5 | 26.5 |  | 27 |  | 27.5 |  | 28 |  | 28.5 |  | 29
 | Y6 | 29.5 |  | 30 |  | 30.5 |  | 31 |  | 31.5 |  | 32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =NOT(ISNUMBER(C6))
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =(MOD(COLUMN(C6),2)=1)*(C6>=OFFSET(C$85,(ROW(C6)-6)/10,-12*QUOTIENT(COLUMN(C$1)-2,13))+$D$82)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =(MOD(COLUMN(C6),2)=1)*(C6>=OFFSET(C$85,(ROW(C6)-6)/10,-12*QUOTIENT(COLUMN(C$1)-2,13))+$B$82)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =(MOD(COLUMN(C6),2)=1)*(C6>=OFFSET(C$85,(ROW(C6)-6)/10,-12*QUOTIENT(COLUMN(C$1)-2,13))-$D$79)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =(MOD(COLUMN(C6),2)=1)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =NÃO(É.NÚM(C6))
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =(RESTO(COL(C6);2)=1)*(C6>=DESLOCAMENTO(C$85;(LIN(C6)-6)/10;-12*QUOCIENTE(COL(C$1)-2;13))+$D$82)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =(RESTO(COL(C6);2)=1)*(C6>=DESLOCAMENTO(C$85;(LIN(C6)-6)/10;-12*QUOCIENTE(COL(C$1)-2;13))+$B$82)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =(RESTO(COL(C6);2)=1)*(C6>=DESLOCAMENTO(C$85;(LIN(C6)-6)/10;-12*QUOCIENTE(COL(C$1)-2;13))-$D$79)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =(RESTO(COL(C6);2)=1)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =(MOD(COLUMN(C6),2)=0)*(C6>=$D$82)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =(MOD(COLUMN(C6),2)=0)*(C6>=$B$82)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =(MOD(COLUMN(C6),2)=0)*(C6>=-$D$79)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =(MOD(COLUMN(C6),2)=0)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =(RESTO(COL(C6);2)=0)*(C6>=$D$82)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =(RESTO(COL(C6);2)=0)*(C6>=$B$82)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =(RESTO(COL(C6);2)=0)*(C6>=-$D$79)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =(RESTO(COL(C6);2)=0)