{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Guide to Ready Reckoners","Guidance","new drop down lookup","Key stage 2 Data Input","Single Measure Ready Reckoner","All Measures Ready Reckoner","Model values","Chart Data","KS2 Fine grades lookup"],"not_rendered":{"charts":2,"images":4,"macros":0,"external_links":3,"defined_names":17,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Guide to Ready Reckoners","index":0,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[[20,2,22,3]]}
[]
[null,"GUIDE TO 2018 KEY STAGE 2 TO 4 READY RECKONERS "]
[]
[null,"There are four key stage 2 to 4 ready reckoners."]
[]
[null,"This ready reckoner is the EBacc subject pupil ready reckoner. The aim is to help the user to understand how we arrive at a value added score for their pupil. "]
[null,"The ready reckoner allows the user to input, for an individual pupil, their key stage 2 prior attainment and key stage 4 attainment in any of the three subject areas in the English Baccalaureate. "]
[]
[null,"The aim of the EBacc subject school ready reckoner is to help the user understand how we arrive at a value added score for their school. "]
[null,"The ready reckoner allows the user to input the value added scores in any of the three subject areas in the English Baccalaureate, for all pupils in their school. "]
[null,"These value added scores can be copied and pasted directly from the pupil level file on the ",null,null,null,null,null,null,null,"Checking site."]
[]
[null,"The aim of the Progress 8 element breakdown pupil ready reckoner is to help the user to understand how we arrive at a value added score for their pupil. "]
[null,"The ready reckoner allows the user to input, for an individual pupil, their key stage 2 prior attainment and key stage 4 outcome in Attainment 8 or any of its elements. "]
[]
[null,"The aim of the Progress 8 element breakdown school ready reckoner is to help the user understand how we arrive at a value added score for their school. "]
[null,"The ready reckoner allows the user to input the value added scores in Progress 8 or any of its elements, for all pupils in their school. "]
[null,"These value added scores can be copied and pasted directly from the pupil level file on the ",null,null,null,null,null,null,null,"Checking site."]
[]
[]
[null,null,"To Guidance  --->"]

{"sheet":"Guidance","index":1,"n_rows":49,"n_cols":18,"rows_kept":49,"cut":false,"hidden":false,"merged":[[39,17,41,18]]}
[]
[null,"2018 KEY STAGE 2 TO 4 INDIVIDUAL PUPIL READY RECKONER GUIDANCE"]
[]
[null,"This ready reckoner allows the user to calculate a value added score for an individual pupil for the following measures:"]
[]
[null,"1) English Baccalaureate - science subject area"]
[null,"2) English Baccalaureate - humanities subject area"]
[null,"3) English Baccalaureate - language subject area"]
[]
[null,"Please note that all attainment estimates and calculations relate to 2018 only."]
[null,"Calculations are completed based on attainment estimates to 2 decimal places."]
[]
[null,"HOW TO USE THE READY RECKONER"]
[]
[null,"The following steps explain how to use the ready reckoner…"]
[]
[null,"Step 1)    ","Go to sheet 'Key stage 2 data input' and enter the pupil's key stage 2 prior attainment in key stage 2 reading and mathematics. If a pupil is missing a valid key stage 2 test outcome, then their "]
[null,null,"key stage 2 teacher assessment outcome can be used instead."]
[null,null,"Note: it is not possible to access key stage 2 test marks on the Checking website but these are given along with their corresponding fine point score in the drop down box"]
[null,null,"The fine point score can be found in the pupil level data file under the Guidance/Documents tab. "]
[]
[null,"Step 2)","Once the key stage 2 prior attainment data is complete, go to the 'Single Measure Ready Reckoner' sheet."]
[]
[null,"Step 3)","In the 'Single Measure Ready Reckoner' sheet, select the progress measure you wish to use. See screenshot below showing the drop down box to use."]
[]
[null,"Step 4)","Then enter the pupils actual key stage 4 attainment for the progress measure in question (see screenshot below). Further information on the subjects which count in the EBacc can be accessed"]
[null,null,"from the link 'Qualifications which count towards the EBacc'."]
[null,null,"Note: key stage 4 attainment can be found on the Checking website in the pupil level data file under the Guidance/Documents tab."]
[]
[]
[]
[]
[]
[]
[]
[null,"Step 5)","The pupil's progress score will then be shown in the dark blue box at the bottom of the 'Single Measure Ready Reckoner' sheet. There is also a chart comparing the pupil's actual"]
[null,null,"key stage 4 attainment against their estimated key stage 4 attainment in 2018."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To Key stage 2 Data Input Sheet  --->"]
[]
[]
[]
[null,"Step 6)","It is also possible to calculate progress scores for all three measures at the same time. To do this, go to the 'All Measures Ready Reckoner' sheet."]
[]
[]
[null,"Note:","The ready reckoner only provides correct calculations for pupils reaching the end of key stage 4 in 2018 who took their key stage 2 tests in 2013. "]
[null,null,"There were significant changes to KS2 assessments in 2012 where schools were no longer required to administer a writing test and submit this for external marking. "]
[null,null,"The 2011 English (combined reading and writing) test results (marked out of 100) and level thresholds cannot be applied to 2012 reading test (marked out of 50).  "]

{"sheet":"new drop down lookup","index":2,"n_rows":95,"n_cols":21,"rows_kept":95,"cut":false,"hidden":true,"merged":[[52,0,56,5]]}
["Reading fine grade lookup",null,null,null,null,null,null,"Maths fine grade lookup"]
["Mark","Level","Bottom","Top","Drop down list?","Fine grade","Level","Mark","Level","Bottom","Top","Drop down list?","Fine grade","Level"]
["A - Absent","-",null,null,"A - Absent","-","-","A - Absent","-",null,null,"A - Absent","-","-"]
["M - Missing","-",null,null,"M - Missing","-","-","M - Missing","-",null,null,"M - Missing","-","-"]
["Q - Disregard","-",null,null,"Q - Disregard","-","-","Q - Disregard","-",null,null,"Q - Disregard","-","-"]
["T - No access to test","-",null,null,"T - No access to test","-","-","T - No access to test","-",null,null,"T - No access to test","-","-"]
["X - Lost","-",null,null,"X - Lost","-","-","X - Lost","-",null,null,"X - Lost","-","-"]
["B - Working below level of test","-",null,null,"B - Working below level of test","-","-","B - Working below level of test","-",null,null,"B - Working below level of test","-","-"]
["N - Not awarded test level","-",null,null,"N - Not awarded test level","-","-","N - Not awarded test level","-",null,null,"N - Not awarded test level","-","-",null,"checking"]
[11,3,11,18,{"$f":"CONCATENATE(A10,\" - Fine grade = \",ROUND(F10,4))","v":"11 - Fine grade = 3"},{"$f":"B10+((A10-C10)/(D10-C10+1))","v":3},{"$f":"B10","v":3},15,2,15,17,{"$f":"CONCATENATE(H10,\" - Fine grade = \",ROUND(M10,4))","v":"15 - Fine grade = 2.8889"},{"$f":"3-((J13-H10)/(K13-J13+1))","v":2.8888888888888888},{"$f":"I10","v":2},null,{"$f":"VLOOKUP(A10,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":11},{"$f":"IF(VLOOKUP(A10,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F10,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A10,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G10,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H10,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":15},{"$f":"IF(VLOOKUP(H10,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M10,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H10,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N10,\"OK\",\"not OK\")","v":"OK"}]
[12,3,11,18,{"$f":"CONCATENATE(A11,\" - Fine grade = \",ROUND(F11,4))","v":"12 - Fine grade = 3.125"},{"$f":"B11+((A11-C11)/(D11-C11+1))","v":3.125},{"$f":"B11","v":3},{"$f":"H10+1","v":16},2,15,17,{"$f":"CONCATENATE(H11,\" - Fine grade = \",ROUND(M11,4))","v":"16 - Fine grade = 2.9259"},{"$f":"3-((J14-H11)/(K14-J14+1))","v":2.925925925925926},{"$f":"I11","v":2},null,{"$f":"VLOOKUP(A11,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":12},{"$f":"IF(VLOOKUP(A11,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F11,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A11,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G11,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H11,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":16},{"$f":"IF(VLOOKUP(H11,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M11,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H11,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N11,\"OK\",\"not OK\")","v":"OK"}]
[13,3,11,18,"13 - Fine grade = 3.25",3.25,3,{"$f":"H11+1","v":17},2,15,17,"17 - Fine grade = 2.963",2.9629629629629628,2,null,{"$f":"VLOOKUP(A12,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":13},{"$f":"IF(VLOOKUP(A12,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F12,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A12,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G12,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H12,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":17},{"$f":"IF(VLOOKUP(H12,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M12,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H12,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N12,\"OK\",\"not OK\")","v":"OK"}]
[14,3,11,18,"14 - Fine grade = 3.375",3.375,3,18,3,18,44,"18 - Fine grade = 3",{"$f":"I13+((H13-J13)/(K13-J13+1))","v":3},3,null,{"$f":"VLOOKUP(A13,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":14},{"$f":"IF(VLOOKUP(A13,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F13,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A13,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G13,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H13,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":18},{"$f":"IF(VLOOKUP(H13,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M13,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H13,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N13,\"OK\",\"not OK\")","v":"OK"}]
[15,3,11,18,"15 - Fine grade = 3.5",3.5,3,19,3,18,44,"19 - Fine grade = 3.037",3.0370370370370372,3,null,{"$f":"VLOOKUP(A14,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":15},{"$f":"IF(VLOOKUP(A14,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F14,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A14,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G14,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H14,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":19},{"$f":"IF(VLOOKUP(H14,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M14,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H14,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N14,\"OK\",\"not OK\")","v":"OK"}]
[16,3,11,18,"16 - Fine grade = 3.625",3.625,3,20,3,18,44,"20 - Fine grade = 3.0741",3.074074074074074,3,null,{"$f":"VLOOKUP(A15,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":16},{"$f":"IF(VLOOKUP(A15,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F15,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A15,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G15,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H15,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":20},{"$f":"IF(VLOOKUP(H15,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M15,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H15,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N15,\"OK\",\"not OK\")","v":"OK"}]
[17,3,11,18,"17 - Fine grade = 3.75",3.75,3,21,3,18,44,"21 - Fine grade = 3.1111",3.1111111111111112,3,null,{"$f":"VLOOKUP(A16,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":17},{"$f":"IF(VLOOKUP(A16,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F16,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A16,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G16,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H16,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":21},{"$f":"IF(VLOOKUP(H16,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M16,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H16,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N16,\"OK\",\"not OK\")","v":"OK"}]
[{"$f":"A16+1","v":18},3,11,18,"18 - Fine grade = 3.875",3.875,3,22,3,18,44,"22 - Fine grade = 3.1481",3.1481481481481479,3,null,{"$f":"VLOOKUP(A17,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":18},{"$f":"IF(VLOOKUP(A17,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F17,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A17,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G17,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H17,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":22},{"$f":"IF(VLOOKUP(H17,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M17,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H17,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N17,\"OK\",\"not OK\")","v":"OK"}]
[{"$f":"A17+1","v":19},4,19,35,"19 - Fine grade = 4",4,4,23,3,18,44,"23 - Fine grade = 3.1852",3.1851851851851851,3,null,{"$f":"VLOOKUP(A18,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":19},{"$f":"IF(VLOOKUP(A18,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F18,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A18,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G18,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H18,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":23},{"$f":"IF(VLOOKUP(H18,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M18,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H18,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N18,\"OK\",\"not OK\")","v":"OK"}]
[20,4,19,35,"20 - Fine grade = 4.0588",4.0588235294117645,4,24,3,18,44,"24 - Fine grade = 3.2222",3.2222222222222223,3,null,{"$f":"VLOOKUP(A19,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":20},{"$f":"IF(VLOOKUP(A19,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F19,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A19,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G19,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H19,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":24},{"$f":"IF(VLOOKUP(H19,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M19,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H19,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N19,\"OK\",\"not OK\")","v":"OK"}]
[21,4,19,35,"21 - Fine grade = 4.1176",4.117647058823529,4,25,3,18,44,"25 - Fine grade = 3.2593",3.2592592592592591,3,null,{"$f":"VLOOKUP(A20,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":21},{"$f":"IF(VLOOKUP(A20,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F20,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A20,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G20,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H20,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":25},{"$f":"IF(VLOOKUP(H20,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M20,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H20,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N20,\"OK\",\"not OK\")","v":"OK"}]
[22,4,19,35,"22 - Fine grade = 4.1765",4.1764705882352944,4,26,3,18,44,"26 - Fine grade = 3.2963",3.2962962962962963,3,null,{"$f":"VLOOKUP(A21,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":22},{"$f":"IF(VLOOKUP(A21,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F21,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A21,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G21,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H21,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":26},{"$f":"IF(VLOOKUP(H21,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M21,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H21,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N21,\"OK\",\"not OK\")","v":"OK"}]
[23,4,19,35,"23 - Fine grade = 4.2353",4.2352941176470589,4,27,3,18,44,"27 - Fine grade = 3.3333",3.3333333333333335,3,null,{"$f":"VLOOKUP(A22,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":23},{"$f":"IF(VLOOKUP(A22,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F22,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A22,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G22,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H22,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":27},{"$f":"IF(VLOOKUP(H22,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M22,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H22,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N22,\"OK\",\"not OK\")","v":"OK"}]
[24,4,19,35,"24 - Fine grade = 4.2941",4.2941176470588234,4,28,3,18,44,"28 - Fine grade = 3.3704",3.3703703703703702,3,null,{"$f":"VLOOKUP(A23,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":24},{"$f":"IF(VLOOKUP(A23,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F23,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A23,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G23,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H23,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":28},{"$f":"IF(VLOOKUP(H23,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M23,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H23,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N23,\"OK\",\"not OK\")","v":"OK"}]
[25,4,19,35,"25 - Fine grade = 4.3529",4.3529411764705879,4,29,3,18,44,"29 - Fine grade = 3.4074",3.4074074074074074,3,null,{"$f":"VLOOKUP(A24,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":25},{"$f":"IF(VLOOKUP(A24,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F24,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A24,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G24,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H24,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":29},{"$f":"IF(VLOOKUP(H24,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M24,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H24,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N24,\"OK\",\"not OK\")","v":"OK"}]
[26,4,19,35,"26 - Fine grade = 4.4118",4.4117647058823533,4,30,3,18,44,"30 - Fine grade = 3.4444",3.4444444444444446,3,null,{"$f":"VLOOKUP(A25,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":26},{"$f":"IF(VLOOKUP(A25,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F25,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A25,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G25,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H25,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":30},{"$f":"IF(VLOOKUP(H25,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M25,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H25,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N25,\"OK\",\"not OK\")","v":"OK"}]
[27,4,19,35,"27 - Fine grade = 4.4706",4.4705882352941178,4,31,3,18,44,"31 - Fine grade = 3.4815",3.4814814814814814,3,null,{"$f":"VLOOKUP(A26,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":27},{"$f":"IF(VLOOKUP(A26,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F26,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A26,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G26,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H26,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":31},{"$f":"IF(VLOOKUP(H26,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M26,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H26,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N26,\"OK\",\"not OK\")","v":"OK"}]
[28,4,19,35,"28 - Fine grade = 4.5294",4.5294117647058822,4,32,3,18,44,"32 - Fine grade = 3.5185",3.5185185185185186,3,null,{"$f":"VLOOKUP(A27,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":28},{"$f":"IF(VLOOKUP(A27,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F27,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A27,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G27,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H27,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":32},{"$f":"IF(VLOOKUP(H27,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M27,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H27,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N27,\"OK\",\"not OK\")","v":"OK"}]
[29,4,19,35,"29 - Fine grade = 4.5882",4.5882352941176467,4,33,3,18,44,"33 - Fine grade = 3.5556",3.5555555555555554,3,null,{"$f":"VLOOKUP(A28,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":29},{"$f":"IF(VLOOKUP(A28,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F28,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A28,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G28,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H28,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":33},{"$f":"IF(VLOOKUP(H28,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M28,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H28,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N28,\"OK\",\"not OK\")","v":"OK"}]
[30,4,19,35,"30 - Fine grade = 4.6471",4.6470588235294121,4,34,3,18,44,"34 - Fine grade = 3.5926",3.5925925925925926,3,null,{"$f":"VLOOKUP(A29,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":30},{"$f":"IF(VLOOKUP(A29,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F29,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A29,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G29,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H29,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":34},{"$f":"IF(VLOOKUP(H29,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M29,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H29,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N29,\"OK\",\"not OK\")","v":"OK"}]
[31,4,19,35,"31 - Fine grade = 4.7059",4.7058823529411766,4,35,3,18,44,"35 - Fine grade = 3.6296",3.6296296296296298,3,null,{"$f":"VLOOKUP(A30,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":31},{"$f":"IF(VLOOKUP(A30,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F30,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A30,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G30,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H30,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":35},{"$f":"IF(VLOOKUP(H30,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M30,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H30,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N30,\"OK\",\"not OK\")","v":"OK"}]
[32,4,19,35,"32 - Fine grade = 4.7647",4.7647058823529411,4,36,3,18,44,"36 - Fine grade = 3.6667",3.6666666666666665,3,null,{"$f":"VLOOKUP(A31,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":32},{"$f":"IF(VLOOKUP(A31,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F31,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A31,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G31,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H31,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":36},{"$f":"IF(VLOOKUP(H31,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M31,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H31,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N31,\"OK\",\"not OK\")","v":"OK"}]
[33,4,19,35,"33 - Fine grade = 4.8235",4.8235294117647056,4,37,3,18,44,"37 - Fine grade = 3.7037",3.7037037037037037,3,null,{"$f":"VLOOKUP(A32,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":33},{"$f":"IF(VLOOKUP(A32,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F32,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A32,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G32,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H32,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":37},{"$f":"IF(VLOOKUP(H32,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M32,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H32,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N32,\"OK\",\"not OK\")","v":"OK"}]
[34,4,19,35,"34 - Fine grade = 4.8824",4.882352941176471,4,38,3,18,44,"38 - Fine grade = 3.7407",3.7407407407407405,3,null,{"$f":"VLOOKUP(A33,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":34},{"$f":"IF(VLOOKUP(A33,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F33,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A33,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G33,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H33,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":38},{"$f":"IF(VLOOKUP(H33,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M33,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H33,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N33,\"OK\",\"not OK\")","v":"OK"}]
[35,4,19,35,"35 - Fine grade = 4.9412",4.9411764705882355,4,39,3,18,44,"39 - Fine grade = 3.7778",3.7777777777777777,3,null,{"$f":"VLOOKUP(A34,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":35},{"$f":"IF(VLOOKUP(A34,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F34,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A34,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G34,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H34,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":39},{"$f":"IF(VLOOKUP(H34,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M34,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H34,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N34,\"OK\",\"not OK\")","v":"OK"}]
[36,5,36,50,"36 - Fine grade = 5",5,5,40,3,18,44,"40 - Fine grade = 3.8148",3.8148148148148149,3,null,{"$f":"VLOOKUP(A35,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":36},{"$f":"IF(VLOOKUP(A35,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F35,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A35,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G35,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H35,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":40},{"$f":"IF(VLOOKUP(H35,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M35,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H35,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N35,\"OK\",\"not OK\")","v":"OK"}]
[37,5,36,50,"37 - Fine grade = 5.0667",5.0666666666666664,5,41,3,18,44,"41 - Fine grade = 3.8519",3.8518518518518521,3,null,{"$f":"VLOOKUP(A36,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":37},{"$f":"IF(VLOOKUP(A36,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F36,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A36,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G36,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H36,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":41},{"$f":"IF(VLOOKUP(H36,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M36,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H36,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N36,\"OK\",\"not OK\")","v":"OK"}]
[38,5,36,50,"38 - Fine grade = 5.1333",5.1333333333333337,5,42,3,18,44,"42 - Fine grade = 3.8889",3.8888888888888888,3,null,{"$f":"VLOOKUP(A37,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":38},{"$f":"IF(VLOOKUP(A37,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F37,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A37,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G37,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H37,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":42},{"$f":"IF(VLOOKUP(H37,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M37,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H37,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N37,\"OK\",\"not OK\")","v":"OK"}]
[39,5,36,50,"39 - Fine grade = 5.2",5.2,5,43,3,18,44,"43 - Fine grade = 3.9259",3.925925925925926,3,null,{"$f":"VLOOKUP(A38,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":39},{"$f":"IF(VLOOKUP(A38,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F38,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A38,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G38,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H38,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":43},{"$f":"IF(VLOOKUP(H38,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M38,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H38,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N38,\"OK\",\"not OK\")","v":"OK"}]
[40,5,36,50,"40 - Fine grade = 5.2667",5.2666666666666666,5,44,3,18,44,"44 - Fine grade = 3.963",3.9629629629629628,3,null,{"$f":"VLOOKUP(A39,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":40},{"$f":"IF(VLOOKUP(A39,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F39,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A39,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G39,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H39,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":44},{"$f":"IF(VLOOKUP(H39,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M39,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H39,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N39,\"OK\",\"not OK\")","v":"OK"}]
[41,5,36,50,"41 - Fine grade = 5.3333",5.333333333333333,5,45,4,45,78,"45 - Fine grade = 4",4,4,null,{"$f":"VLOOKUP(A40,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":41},{"$f":"IF(VLOOKUP(A40,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F40,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A40,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G40,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H40,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":45},{"$f":"IF(VLOOKUP(H40,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M40,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H40,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N40,\"OK\",\"not OK\")","v":"OK"}]
[42,5,36,50,"42 - Fine grade = 5.4",5.4,5,46,4,45,78,"46 - Fine grade = 4.0294",4.0294117647058822,4,null,{"$f":"VLOOKUP(A41,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":42},{"$f":"IF(VLOOKUP(A41,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F41,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A41,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G41,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H41,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":46},{"$f":"IF(VLOOKUP(H41,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M41,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H41,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N41,\"OK\",\"not OK\")","v":"OK"}]
[43,5,36,50,"43 - Fine grade = 5.4667",5.4666666666666668,5,47,4,45,78,"47 - Fine grade = 4.0588",4.0588235294117645,4,null,{"$f":"VLOOKUP(A42,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":43},{"$f":"IF(VLOOKUP(A42,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F42,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A42,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G42,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H42,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":47},{"$f":"IF(VLOOKUP(H42,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M42,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H42,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N42,\"OK\",\"not OK\")","v":"OK"}]
[44,5,36,50,"44 - Fine grade = 5.5333",5.5333333333333332,5,48,4,45,78,"48 - Fine grade = 4.0882",4.0882352941176467,4,null,{"$f":"VLOOKUP(A43,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":44},{"$f":"IF(VLOOKUP(A43,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F43,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A43,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G43,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H43,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":48},{"$f":"IF(VLOOKUP(H43,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M43,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H43,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N43,\"OK\",\"not OK\")","v":"OK"}]
[45,5,36,50,"45 - Fine grade = 5.6",5.6,5,49,4,45,78,"49 - Fine grade = 4.1176",4.117647058823529,4,null,{"$f":"VLOOKUP(A44,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":45},{"$f":"IF(VLOOKUP(A44,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F44,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A44,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G44,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H44,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":49},{"$f":"IF(VLOOKUP(H44,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M44,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H44,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N44,\"OK\",\"not OK\")","v":"OK"}]
[46,5,36,50,"46 - Fine grade = 5.6667",5.666666666666667,5,50,4,45,78,"50 - Fine grade = 4.1471",4.1470588235294121,4,null,{"$f":"VLOOKUP(A45,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":46},{"$f":"IF(VLOOKUP(A45,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F45,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A45,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G45,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H45,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":50},{"$f":"IF(VLOOKUP(H45,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M45,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H45,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N45,\"OK\",\"not OK\")","v":"OK"}]
[47,5,36,50,"47 - Fine grade = 5.7333",5.7333333333333334,5,51,4,45,78,"51 - Fine grade = 4.1765",4.1764705882352944,4,null,{"$f":"VLOOKUP(A46,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":47},{"$f":"IF(VLOOKUP(A46,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F46,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A46,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G46,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H46,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":51},{"$f":"IF(VLOOKUP(H46,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M46,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H46,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N46,\"OK\",\"not OK\")","v":"OK"}]
[48,5,36,50,"48 - Fine grade = 5.8",5.8,5,52,4,45,78,"52 - Fine grade = 4.2059",4.2058823529411766,4,null,{"$f":"VLOOKUP(A47,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":48},{"$f":"IF(VLOOKUP(A47,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F47,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A47,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G47,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H47,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":52},{"$f":"IF(VLOOKUP(H47,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M47,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H47,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N47,\"OK\",\"not OK\")","v":"OK"}]
[49,5,36,50,"49 - Fine grade = 5.8667",5.8666666666666671,5,53,4,45,78,"53 - Fine grade = 4.2353",4.2352941176470589,4,null,{"$f":"VLOOKUP(A48,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":49},{"$f":"IF(VLOOKUP(A48,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F48,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A48,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G48,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H48,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":53},{"$f":"IF(VLOOKUP(H48,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M48,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H48,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N48,\"OK\",\"not OK\")","v":"OK"}]
[50,5,36,50,"50 - Fine grade = 5.9333",5.9333333333333336,5,54,4,45,78,"54 - Fine grade = 4.2647",4.2647058823529411,4,null,{"$f":"VLOOKUP(A49,'KS2 Fine grades lookup'!$A$10:$C$49,1,FALSE)","v":50},{"$f":"IF(VLOOKUP(A49,'KS2 Fine grades lookup'!$A$10:$C$49,3,FALSE)=F49,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(A49,'KS2 Fine grades lookup'!$A$10:$C$49,2,FALSE)=G49,\"OK\",\"not OK\")","v":"OK"},{"$f":"VLOOKUP(H49,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":54},{"$f":"IF(VLOOKUP(H49,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M49,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H49,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N49,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,55,4,45,78,"55 - Fine grade = 4.2941",4.2941176470588234,4,null,null,null,null,{"$f":"VLOOKUP(H50,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":55},{"$f":"IF(VLOOKUP(H50,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M50,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H50,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N50,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,56,4,45,78,"56 - Fine grade = 4.3235",4.3235294117647056,4,null,null,null,null,{"$f":"VLOOKUP(H51,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":56},{"$f":"IF(VLOOKUP(H51,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M51,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H51,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N51,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,57,4,45,78,"57 - Fine grade = 4.3529",4.3529411764705879,4,null,null,null,null,{"$f":"VLOOKUP(H52,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":57},{"$f":"IF(VLOOKUP(H52,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M52,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H52,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N52,\"OK\",\"not OK\")","v":"OK"}]
["The thresholds for Reading have changed slightly in 2013 with L4 beginning at 19 marks rather than 18 last year. Level 5 now begins at 36 points which is 3 marks higher than last year. In maths Level 4 now begins at 45 marks which is 1 mark lower than last year. A number of schools’ results will be affected by these shifts.",null,null,null,null,null,null,58,4,45,78,"58 - Fine grade = 4.3824",4.382352941176471,4,null,null,null,null,{"$f":"VLOOKUP(H53,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":58},{"$f":"IF(VLOOKUP(H53,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M53,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H53,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N53,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,59,4,45,78,"59 - Fine grade = 4.4118",4.4117647058823533,4,null,null,null,null,{"$f":"VLOOKUP(H54,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":59},{"$f":"IF(VLOOKUP(H54,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M54,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H54,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N54,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,60,4,45,78,"60 - Fine grade = 4.4412",4.4411764705882355,4,null,null,null,null,{"$f":"VLOOKUP(H55,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":60},{"$f":"IF(VLOOKUP(H55,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M55,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H55,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N55,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,61,4,45,78,"61 - Fine grade = 4.4706",4.4705882352941178,4,null,null,null,null,{"$f":"VLOOKUP(H56,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":61},{"$f":"IF(VLOOKUP(H56,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M56,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H56,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N56,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,62,4,45,78,"62 - Fine grade = 4.5",4.5,4,null,null,null,null,{"$f":"VLOOKUP(H57,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":62},{"$f":"IF(VLOOKUP(H57,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M57,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H57,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N57,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,63,4,45,78,"63 - Fine grade = 4.5294",4.5294117647058822,4,null,null,null,null,{"$f":"VLOOKUP(H58,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":63},{"$f":"IF(VLOOKUP(H58,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M58,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H58,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N58,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,64,4,45,78,"64 - Fine grade = 4.5588",4.5588235294117645,4,null,null,null,null,{"$f":"VLOOKUP(H59,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":64},{"$f":"IF(VLOOKUP(H59,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M59,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H59,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N59,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,65,4,45,78,"65 - Fine grade = 4.5882",4.5882352941176467,4,null,null,null,null,{"$f":"VLOOKUP(H60,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":65},{"$f":"IF(VLOOKUP(H60,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M60,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H60,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N60,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,66,4,45,78,"66 - Fine grade = 4.6176",4.617647058823529,4,null,null,null,null,{"$f":"VLOOKUP(H61,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":66},{"$f":"IF(VLOOKUP(H61,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M61,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H61,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N61,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,67,4,45,78,"67 - Fine grade = 4.6471",4.6470588235294121,4,null,null,null,null,{"$f":"VLOOKUP(H62,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":67},{"$f":"IF(VLOOKUP(H62,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M62,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H62,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N62,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,68,4,45,78,"68 - Fine grade = 4.6765",4.6764705882352944,4,null,null,null,null,{"$f":"VLOOKUP(H63,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":68},{"$f":"IF(VLOOKUP(H63,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M63,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H63,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N63,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,69,4,45,78,"69 - Fine grade = 4.7059",4.7058823529411766,4,null,null,null,null,{"$f":"VLOOKUP(H64,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":69},{"$f":"IF(VLOOKUP(H64,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M64,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H64,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N64,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,70,4,45,78,"70 - Fine grade = 4.7353",4.7352941176470589,4,null,null,null,null,{"$f":"VLOOKUP(H65,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":70},{"$f":"IF(VLOOKUP(H65,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M65,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H65,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N65,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,71,4,45,78,"71 - Fine grade = 4.7647",4.7647058823529411,4,null,null,null,null,{"$f":"VLOOKUP(H66,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":71},{"$f":"IF(VLOOKUP(H66,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M66,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H66,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N66,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,72,4,45,78,"72 - Fine grade = 4.7941",4.7941176470588234,4,null,null,null,null,{"$f":"VLOOKUP(H67,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":72},{"$f":"IF(VLOOKUP(H67,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M67,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H67,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N67,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,73,4,45,78,"73 - Fine grade = 4.8235",4.8235294117647056,4,null,null,null,null,{"$f":"VLOOKUP(H68,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":73},{"$f":"IF(VLOOKUP(H68,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M68,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H68,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N68,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,74,4,45,78,"74 - Fine grade = 4.8529",4.8529411764705879,4,null,null,null,null,{"$f":"VLOOKUP(H69,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":74},{"$f":"IF(VLOOKUP(H69,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M69,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H69,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N69,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,75,4,45,78,"75 - Fine grade = 4.8824",4.882352941176471,4,null,null,null,null,{"$f":"VLOOKUP(H70,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":75},{"$f":"IF(VLOOKUP(H70,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M70,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H70,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N70,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,76,4,45,78,"76 - Fine grade = 4.9118",4.9117647058823533,4,null,null,null,null,{"$f":"VLOOKUP(H71,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":76},{"$f":"IF(VLOOKUP(H71,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M71,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H71,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N71,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,77,4,45,78,"77 - Fine grade = 4.9412",4.9411764705882355,4,null,null,null,null,{"$f":"VLOOKUP(H72,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":77},{"$f":"IF(VLOOKUP(H72,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M72,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H72,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N72,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,78,4,45,78,"78 - Fine grade = 4.9706",4.9705882352941178,4,null,null,null,null,{"$f":"VLOOKUP(H73,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":78},{"$f":"IF(VLOOKUP(H73,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M73,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H73,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N73,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,79,5,79,100,"79 - Fine grade = 5",5,5,null,null,null,null,{"$f":"VLOOKUP(H74,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":79},{"$f":"IF(VLOOKUP(H74,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M74,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H74,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N74,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,80,5,79,100,{"$f":"CONCATENATE(H75,\" - Fine grade = \",ROUND(M75,4))","v":"80 - Fine grade = 5.0455"},5.0454545454545459,{"$f":"I75","v":5},null,null,null,null,{"$f":"VLOOKUP(H75,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":80},{"$f":"IF(VLOOKUP(H75,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M75,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H75,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N75,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,{"$f":"H75+1","v":81},5,79,100,"81 - Fine grade = 5.0909",5.0909090909090908,5,null,null,null,null,{"$f":"VLOOKUP(H76,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":81},{"$f":"IF(VLOOKUP(H76,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M76,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H76,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N76,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,82,5,79,100,"82 - Fine grade = 5.1364",{"$f":"I77+((H77-J77)/(K77-J77+1))","v":5.1363636363636367},5,null,null,null,null,{"$f":"VLOOKUP(H77,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":82},{"$f":"IF(VLOOKUP(H77,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M77,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H77,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N77,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,83,5,79,100,"83 - Fine grade = 5.1818",5.1818181818181817,5,null,null,null,null,{"$f":"VLOOKUP(H78,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":83},{"$f":"IF(VLOOKUP(H78,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M78,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H78,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N78,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,84,5,79,100,"84 - Fine grade = 5.2273",5.2272727272727275,5,null,null,null,null,{"$f":"VLOOKUP(H79,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":84},{"$f":"IF(VLOOKUP(H79,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M79,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H79,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N79,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,85,5,79,100,"85 - Fine grade = 5.2727",5.2727272727272725,5,null,null,null,null,{"$f":"VLOOKUP(H80,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":85},{"$f":"IF(VLOOKUP(H80,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M80,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H80,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N80,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,86,5,79,100,"86 - Fine grade = 5.3182",5.3181818181818183,5,null,null,null,null,{"$f":"VLOOKUP(H81,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":86},{"$f":"IF(VLOOKUP(H81,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M81,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H81,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N81,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,87,5,79,100,"87 - Fine grade = 5.3636",5.3636363636363633,5,null,null,null,null,{"$f":"VLOOKUP(H82,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":87},{"$f":"IF(VLOOKUP(H82,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M82,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H82,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N82,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,88,5,79,100,"88 - Fine grade = 5.4091",5.4090909090909092,5,null,null,null,null,{"$f":"VLOOKUP(H83,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":88},{"$f":"IF(VLOOKUP(H83,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M83,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H83,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N83,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,89,5,79,100,"89 - Fine grade = 5.4545",5.4545454545454541,5,null,null,null,null,{"$f":"VLOOKUP(H84,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":89},{"$f":"IF(VLOOKUP(H84,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M84,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H84,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N84,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,90,5,79,100,"90 - Fine grade = 5.5",5.5,5,null,null,null,null,{"$f":"VLOOKUP(H85,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":90},{"$f":"IF(VLOOKUP(H85,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M85,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H85,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N85,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,91,5,79,100,"91 - Fine grade = 5.5455",5.545454545454545,5,null,null,null,null,{"$f":"VLOOKUP(H86,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":91},{"$f":"IF(VLOOKUP(H86,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M86,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H86,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N86,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,92,5,79,100,"92 - Fine grade = 5.5909",5.5909090909090908,5,null,null,null,null,{"$f":"VLOOKUP(H87,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":92},{"$f":"IF(VLOOKUP(H87,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M87,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H87,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N87,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,93,5,79,100,"93 - Fine grade = 5.6364",5.6363636363636367,5,null,null,null,null,{"$f":"VLOOKUP(H88,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":93},{"$f":"IF(VLOOKUP(H88,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M88,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H88,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N88,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,94,5,79,100,"94 - Fine grade = 5.6818",5.6818181818181817,5,null,null,null,null,{"$f":"VLOOKUP(H89,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":94},{"$f":"IF(VLOOKUP(H89,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M89,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H89,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N89,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,95,5,79,100,"95 - Fine grade = 5.7273",5.7272727272727275,5,null,null,null,null,{"$f":"VLOOKUP(H90,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":95},{"$f":"IF(VLOOKUP(H90,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M90,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H90,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N90,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,96,5,79,100,"96 - Fine grade = 5.7727",5.7727272727272725,5,null,null,null,null,{"$f":"VLOOKUP(H91,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":96},{"$f":"IF(VLOOKUP(H91,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M91,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H91,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N91,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,97,5,79,100,"97 - Fine grade = 5.8182",5.8181818181818183,5,null,null,null,null,{"$f":"VLOOKUP(H92,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":97},{"$f":"IF(VLOOKUP(H92,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M92,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H92,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N92,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,98,5,79,100,"98 - Fine grade = 5.8636",5.8636363636363633,5,null,null,null,null,{"$f":"VLOOKUP(H93,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":98},{"$f":"IF(VLOOKUP(H93,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M93,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H93,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N93,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,99,5,79,100,"99 - Fine grade = 5.9091",5.9090909090909092,5,null,null,null,null,{"$f":"VLOOKUP(H94,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":99},{"$f":"IF(VLOOKUP(H94,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M94,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H94,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N94,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,null,null,null,100,5,79,100,"100 - Fine grade = 5.9545",5.954545454545455,5,null,null,null,null,{"$f":"VLOOKUP(H95,'KS2 Fine grades lookup'!$E$10:$G$95,1,FALSE)","v":100},{"$f":"IF(VLOOKUP(H95,'KS2 Fine grades lookup'!$E$10:$G$95,3,FALSE)=M95,\"OK\",\"not OK\")","v":"OK"},{"$f":"IF(VLOOKUP(H95,'KS2 Fine grades lookup'!$E$10:$G$95,2,FALSE)=N95,\"OK\",\"not OK\")","v":"OK"}]

{"sheet":"Key stage 2 Data Input","index":3,"n_rows":96,"n_cols":17,"rows_kept":96,"cut":false,"hidden":false,"merged":[[34,1,34,2],[19,1,19,2],[25,1,25,2],[29,7,31,7],[31,1,31,2],[33,7,35,7],[6,1,6,2],[6,4,6,6],[10,1,10,2],[12,1,12,2],[17,1,17,2]]}
[]
[null,"INDIVIDUAL PUPIL KS2 DATA INPUT SHEET",null,null,null,null,"CELL COLOUR GUIDE:"]
[null,null,null,null,null,null,"DATA INPUT CELL",null,null,"--Select--","--Select--"]
[null,"This sheet is the data input sheet. Its purpose is to calculate a pupil's key stage 2 fine level",null,null,null,null,"CALCULATION CELL",null,null,"A - Absent","A - Absent"]
[null,"using their key stage 2 test and teacher assessment outcomes in reading and mathematics.",null,null,null,null,"NOT APPLICABLE",null,null,"M - Missing","M - Missing"]
[null,null,null,null,null,null,null,null,null,"Q - Disregard","Q - Disregard"]
[null,"INPUT SHEET GUIDANCE",null,null,"KS2 SUBJECTS",null,null,null,null,"T - No access to test","T - No access to test"]
[null,null,null,null,null,null,null,null,null,"X - Lost","X - Lost"]
[null,null,null,null,"KS2 READING TEST OUTCOME",null,"KS2 MATHEMATICS TEST OUTCOME",null,null,"B - Working below level of test","B - Working below level of test"]
[null,null,null,null,null,null,null,null,null,"N - Not awarded test level","N - Not awarded test level"]
[null,"Please enter the pupil's key stage 2 test mark for each subject. This is the number on the left in the options in the drop down menu - if you don't know the test mark, but do know the fine grade, then select from the drop down menu based on the fine grade.",null,null,"--Select--",null,"--Select--",null,null,{"$f":"'new drop down lookup'!E10","v":"11 - Fine grade = 3"},{"$f":"'new drop down lookup'!L10","v":"15 - Fine grade = 2.8889"},null,null,"--Select--","A,M,Q,S,T,X","B,N",2]
[null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!E11","v":"12 - Fine grade = 3.125"},{"$f":"'new drop down lookup'!L11","v":"16 - Fine grade = 2.9259"},null,null,"OTHER (e.g. A, D, F etc)","-","-","-"]
[null,"These cells convert the key stage 2 test mark entered above to ",null,null,{"$f":"IF(E11=J3,\"-\",IF(ISNUMBER((VLOOKUP($E$11,'new drop down lookup'!$E$3:$F$49,2,FALSE))),(VLOOKUP($E$11,'new drop down lookup'!$E$3:$F$49,2,FALSE)),VLOOKUP($E$11,'new drop down lookup'!$E$3:$F$49,2,FALSE)))","v":"-"},null,{"$f":"IF(G11=K3,\"-\",IF(ISNUMBER((VLOOKUP($G$11,'new drop down lookup'!$L$3:$M$95,2,FALSE))),(VLOOKUP($G$11,'new drop down lookup'!$L$3:$M$95,2,FALSE)),VLOOKUP($G$11,'new drop down lookup'!$L$3:$M$95,2,FALSE)))","v":"-"},null,null,{"$f":"'new drop down lookup'!E12","v":"13 - Fine grade = 3.25"},{"$f":"'new drop down lookup'!L12","v":"17 - Fine grade = 2.963"},null,null,"W - Working towards Level 1",0.5,0.5,0.5]
[null,"fine grades for each subject.",null,null,{"$f":"IF(E11=J3,\"-\",IF(VLOOKUP($E$11,'new drop down lookup'!$E$3:$G$49,3,FALSE)=\"-\",\"-\",\" TEST LEVEL \"&VLOOKUP($E$11,'new drop down lookup'!$E$3:$G$49,3,FALSE)))","v":"-"},null,{"$f":"IF(G11=K3,\"-\",IF(VLOOKUP($G$11,'new drop down lookup'!$L$3:$N$95,3,FALSE)=\"-\",\"-\",\" TEST LEVEL \"&VLOOKUP($G$11,'new drop down lookup'!$L$3:$N$95,3,FALSE)))","v":"-"},null,null,{"$f":"'new drop down lookup'!E13","v":"14 - Fine grade = 3.375"},{"$f":"'new drop down lookup'!L13","v":"18 - Fine grade = 3"},null,null,"LEVEL 1",1.5,1.5,1.5]
[null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!E14","v":"15 - Fine grade = 3.5"},{"$f":"'new drop down lookup'!L14","v":"19 - Fine grade = 3.037"},null,null,"LEVEL 2",2.5,2.5,2.5]
[null,null,null,null,"KS2 READING TEACHER ASSESSMENT DATA",null,"KS2 MATHEMATICS TEACHER ASSESSMENT DATA",null,null,{"$f":"'new drop down lookup'!E15","v":"16 - Fine grade = 3.625"},{"$f":"'new drop down lookup'!L15","v":"20 - Fine grade = 3.0741"},null,null,"LEVEL 3",3.5,2.5,"USE FINE POINT SCORE"]
[null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!E16","v":"17 - Fine grade = 3.75"},{"$f":"'new drop down lookup'!L16","v":"21 - Fine grade = 3.1111"},null,null,"LEVEL 4",4.5,2.5,"USE FINE POINT SCORE"]
[null,"Please enter key stage 2 teacher assessment levels if a pupil does not have an outcome in one or both of their key stage 2 tests or they have scored a ",null,null,"--Select--",null,"--Select--",null,null,{"$f":"'new drop down lookup'!E17","v":"18 - Fine grade = 3.875"},{"$f":"'new drop down lookup'!L17","v":"22 - Fine grade = 3.1481"},null,null,"LEVEL 5",5.5,2.5,"USE FINE POINT SCORE"]
[null,"level 2 in one or both of their key stage 2 tests.",null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!E18","v":"19 - Fine grade = 4"},{"$f":"'new drop down lookup'!L18","v":"23 - Fine grade = 3.1852"},null,null,"LEVEL 6",5.5,2.5,"USE FINE POINT SCORE"]
[null,"These cells convert the key stage 2 asessment outcomes entered above to key stage 2 grades.",null,null,{"$f":"IF(E18=N11,\"-\",IF(OR($E$11=\"B - Working below level of test\",$E$11=\"N - Not awarded test level\"),VLOOKUP($E$18,$N$12:$P$19,3,FALSE),IF(VLOOKUP($E$11,'new drop down lookup'!$E$3:$G$49,3,FALSE)=2,VLOOKUP($E$18,$N$12:$Q$19,4,FALSE),VLOOKUP($E$18,$N$12:$O$19,2,FALSE))))","v":"-"},null,{"$f":"IF(G18=N11,\"-\",IF(OR($G$11=\"B - Working below level of test\",$G$11=\"N - Not awarded test level\"),VLOOKUP($G$18,$N$12:$P$19,3,FALSE),IF(VLOOKUP($G$11,'new drop down lookup'!$L$3:$N$95,3,FALSE)=2,VLOOKUP($G$18,$N$12:$Q$19,4,FALSE),VLOOKUP($G$18,$N$12:$O$19,2,FALSE))))","v":"-"},null,null,{"$f":"'new drop down lookup'!E19","v":"20 - Fine grade = 4.0588"},{"$f":"'new drop down lookup'!L19","v":"24 - Fine grade = 3.2222"}]
[null,null,null,null,{"$f":"IF(AND(OR(E11=\"B - Working below level of test\",E11=\"N - Not awarded test level\"),OR(E18=\"LEVEL 3\",E18=\"LEVEL 4\",E18=\"LEVEL 5\",E18=\"LEVEL 6\")),\"CAPPED TO 2.5 POINTS\",\"\")","v":""},null,{"$f":"IF(AND(OR(G11=\"B - Working below level of test\",G11=\"N - Not awarded test level\"),OR(G18=\"LEVEL 3\",G18=\"LEVEL 4\",G18=\"LEVEL 5\",G18=\"LEVEL 6\")),\"CAPPED TO 2.5 POINTS\",\"\")","v":""},null,null,{"$f":"'new drop down lookup'!E20","v":"21 - Fine grade = 4.1176"},{"$f":"'new drop down lookup'!L20","v":"25 - Fine grade = 3.2593"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!E21","v":"22 - Fine grade = 4.1765"},{"$f":"'new drop down lookup'!L21","v":"26 - Fine grade = 3.2963"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!E22","v":"23 - Fine grade = 4.2353"},{"$f":"'new drop down lookup'!L22","v":"27 - Fine grade = 3.3333"}]
[null,null,null,null,"KS2 READING POINT SCORE USED TO CALCULATE KS2 APS",null,"KS2 MATHEMATICS POINT SCORE USED TO CALCULATE KS2 APS",null,null,{"$f":"'new drop down lookup'!E23","v":"24 - Fine grade = 4.2941"},{"$f":"'new drop down lookup'!L23","v":"28 - Fine grade = 3.3704"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!E24","v":"25 - Fine grade = 4.3529"},{"$f":"'new drop down lookup'!L24","v":"29 - Fine grade = 3.4074"}]
[null,"The appropriate test or teacher assessment score is selected for each subject.",null,null,{"$f":"IF(ISNUMBER(IF(OR(AND(ISNUMBER($E$13),VLOOKUP($E$11,'new drop down lookup'!$E$3:$G$49,3,FALSE)<>2),$E$20=$Q$16),$E$13,$E$20)),IF(OR(AND(ISNUMBER($E$13),VLOOKUP($E$11,'new drop down lookup'!$E$3:$G$49,3,FALSE)<>2),$E$20=$Q$16),$E$13,$E$20),\"-\")","v":"-"},null,{"$f":"IF(ISNUMBER(IF(OR(AND(ISNUMBER($G$13),VLOOKUP($G$11,'new drop down lookup'!$L$3:$N$95,3,FALSE)<>2),$G$20=$Q$16),$G$13,$G$20)),IF(OR(AND(ISNUMBER($G$13),VLOOKUP($G$11,'new drop down lookup'!$L$3:$N$95,3,FALSE)<>2),$G$20=$Q$16),$G$13,$G$20),\"-\")","v":"-"},null,null,{"$f":"'new drop down lookup'!E25","v":"26 - Fine grade = 4.4118"},{"$f":"'new drop down lookup'!L25","v":"30 - Fine grade = 3.4444"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!E26","v":"27 - Fine grade = 4.4706"},{"$f":"'new drop down lookup'!L26","v":"31 - Fine grade = 3.4815"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!E27","v":"28 - Fine grade = 4.5294"},{"$f":"'new drop down lookup'!L27","v":"32 - Fine grade = 3.5185"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!E28","v":"29 - Fine grade = 4.5882"},{"$f":"'new drop down lookup'!L28","v":"33 - Fine grade = 3.5556"}]
[null,null,null,null,null,null,null,"To Single Measure Ready Reckoner  --->",null,{"$f":"'new drop down lookup'!E29","v":"30 - Fine grade = 4.6471"},{"$f":"'new drop down lookup'!L29","v":"34 - Fine grade = 3.5926"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!E30","v":"31 - Fine grade = 4.7059"},{"$f":"'new drop down lookup'!L30","v":"35 - Fine grade = 3.6296"}]
[null,"This cell calculates the key stage 2 average point score based on key stage 2 reading and mathematics.",null,null,{"$f":"IF(F32=\"-\", \"Pupil\",\"\")","v":"Pupil"},{"$f":"IF(ISNUMBER(AVERAGE(E26,G26)),AVERAGE(E26,G26),\"-\")","v":"-"},{"$f":"IF(F32=\"-\", \"Excluded\",\"\")","v":"Excluded"},null,null,{"$f":"'new drop down lookup'!E31","v":"32 - Fine grade = 4.7647"},{"$f":"'new drop down lookup'!L31","v":"36 - Fine grade = 3.6667"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!E32","v":"33 - Fine grade = 4.8235"},{"$f":"'new drop down lookup'!L32","v":"37 - Fine grade = 3.7037"}]
[null,null,null,null,null,null,null,"To All Measures Ready Reckoner --->",null,{"$f":"'new drop down lookup'!E33","v":"34 - Fine grade = 4.8824"},{"$f":"'new drop down lookup'!L33","v":"38 - Fine grade = 3.7407"}]
[null,"This cell calculates the banded KS2 fine level based on the key stage 2 fine grade.",null,null,null,{"$f":"IF(ISNUMBER(IF(ROUND((F32),1)<=1.5,1.5,IF(AND(1.5<ROUND((F32),1),ROUND((F32),1)<=2),2,IF(AND(2<ROUND((F32),1),ROUND((F32),1)<=2.5),2.5,IF(AND(2.5<ROUND((F32),1),ROUND((F32),1)<=2.8),2.8,IF(ROUND((F32),1)>=5.8,5.8,ROUND((F32),1))))))),IF(ROUND((F32),1)<=1.5,1.5,IF(AND(1.5<ROUND((F32),1),ROUND((F32),1)<=2),2,IF(AND(2<ROUND((F32),1),ROUND((F32),1)<=2.5),2.5,IF(AND(2.5<ROUND((F32),1),ROUND((F32),1)<=2.8),2.8,IF(ROUND((F32),1)>=5.8,5.8,ROUND((F32),1)))))),\"-\")","v":"-"},null,null,null,{"$f":"'new drop down lookup'!E34","v":"35 - Fine grade = 4.9412"},{"$f":"'new drop down lookup'!L34","v":"39 - Fine grade = 3.7778"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!E35","v":"36 - Fine grade = 5"},{"$f":"'new drop down lookup'!L35","v":"40 - Fine grade = 3.8148"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!E36","v":"37 - Fine grade = 5.0667"},{"$f":"'new drop down lookup'!L36","v":"41 - Fine grade = 3.8519"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!E37","v":"38 - Fine grade = 5.1333"},{"$f":"'new drop down lookup'!L37","v":"42 - Fine grade = 3.8889"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!E38","v":"39 - Fine grade = 5.2"},{"$f":"'new drop down lookup'!L38","v":"43 - Fine grade = 3.9259"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!E39","v":"40 - Fine grade = 5.2667"},{"$f":"'new drop down lookup'!L39","v":"44 - Fine grade = 3.963"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!E40","v":"41 - Fine grade = 5.3333"},{"$f":"'new drop down lookup'!L40","v":"45 - Fine grade = 4"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!E41","v":"42 - Fine grade = 5.4"},{"$f":"'new drop down lookup'!L41","v":"46 - Fine grade = 4.0294"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!E42","v":"43 - Fine grade = 5.4667"},{"$f":"'new drop down lookup'!L42","v":"47 - Fine grade = 4.0588"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!E43","v":"44 - Fine grade = 5.5333"},{"$f":"'new drop down lookup'!L43","v":"48 - Fine grade = 4.0882"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!E44","v":"45 - Fine grade = 5.6"},{"$f":"'new drop down lookup'!L44","v":"49 - Fine grade = 4.1176"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!E45","v":"46 - Fine grade = 5.6667"},{"$f":"'new drop down lookup'!L45","v":"50 - Fine grade = 4.1471"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!E46","v":"47 - Fine grade = 5.7333"},{"$f":"'new drop down lookup'!L46","v":"51 - Fine grade = 4.1765"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!E47","v":"48 - Fine grade = 5.8"},{"$f":"'new drop down lookup'!L47","v":"52 - Fine grade = 4.2059"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!E48","v":"49 - Fine grade = 5.8667"},{"$f":"'new drop down lookup'!L48","v":"53 - Fine grade = 4.2353"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!E49","v":"50 - Fine grade = 5.9333"},{"$f":"'new drop down lookup'!L49","v":"54 - Fine grade = 4.2647"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L50","v":"55 - Fine grade = 4.2941"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L51","v":"56 - Fine grade = 4.3235"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L52","v":"57 - Fine grade = 4.3529"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L53","v":"58 - Fine grade = 4.3824"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L54","v":"59 - Fine grade = 4.4118"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L55","v":"60 - Fine grade = 4.4412"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L56","v":"61 - Fine grade = 4.4706"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L57","v":"62 - Fine grade = 4.5"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L58","v":"63 - Fine grade = 4.5294"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L59","v":"64 - Fine grade = 4.5588"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L60","v":"65 - Fine grade = 4.5882"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L61","v":"66 - Fine grade = 4.6176"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L62","v":"67 - Fine grade = 4.6471"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L63","v":"68 - Fine grade = 4.6765"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L64","v":"69 - Fine grade = 4.7059"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L65","v":"70 - Fine grade = 4.7353"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L66","v":"71 - Fine grade = 4.7647"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L67","v":"72 - Fine grade = 4.7941"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L68","v":"73 - Fine grade = 4.8235"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L69","v":"74 - Fine grade = 4.8529"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L70","v":"75 - Fine grade = 4.8824"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L71","v":"76 - Fine grade = 4.9118"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L72","v":"77 - Fine grade = 4.9412"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L73","v":"78 - Fine grade = 4.9706"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L74","v":"79 - Fine grade = 5"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L75","v":"80 - Fine grade = 5.0455"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L76","v":"81 - Fine grade = 5.0909"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L77","v":"82 - Fine grade = 5.1364"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L78","v":"83 - Fine grade = 5.1818"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L79","v":"84 - Fine grade = 5.2273"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L80","v":"85 - Fine grade = 5.2727"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L81","v":"86 - Fine grade = 5.3182"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L82","v":"87 - Fine grade = 5.3636"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L83","v":"88 - Fine grade = 5.4091"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L84","v":"89 - Fine grade = 5.4545"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L85","v":"90 - Fine grade = 5.5"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L86","v":"91 - Fine grade = 5.5455"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L87","v":"92 - Fine grade = 5.5909"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L88","v":"93 - Fine grade = 5.6364"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L89","v":"94 - Fine grade = 5.6818"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L90","v":"95 - Fine grade = 5.7273"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L91","v":"96 - Fine grade = 5.7727"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L92","v":"97 - Fine grade = 5.8182"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L93","v":"98 - Fine grade = 5.8636"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L94","v":"99 - Fine grade = 5.9091"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'new drop down lookup'!L95","v":"100 - Fine grade = 5.9545"}]

{"sheet":"Single Measure Ready Reckoner","index":4,"n_rows":35,"n_cols":24,"rows_kept":35,"cut":false,"hidden":false,"merged":[[5,13,5,14],[8,13,9,14],[34,6,35,7],[34,2,35,2],[1,13,1,14],[21,6,22,8],[24,6,25,8],[8,1,8,3],[31,6,31,8],[8,6,8,8],[21,3,22,3],[24,3,25,3],[24,1,25,2],[2,13,2,14],[3,13,3,14],[4,13,4,14],[12,6,13,8]]}
[]
[null,"INDIVIDUAL PUPIL KEY STAGE 2 TO 4 EBACC PROGRESS MEASURE READY RECKONER",null,null,null,null,null,null,null,null,null,null,null,"CELL COLOUR GUIDE:",null,null,null,null,null,null,null,null,null,"--Select--"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"DATA INPUT CELL",null,null,null,null,null,null,null,null,null,"English Baccalaureate - science subject area"]
[null,"This sheet is the ready reckoner for the key stage 2 to 4 EBacc progress measures. To calculate a pupil's value added score, you need to first choose the ",null,null,null,null,null,null,null,null,null,null,null,"FROM 'KS2 DATA INPUT' SHEET",null,null,null,null,null,null,null,null,null,"English Baccalaureate - humanities subject area"]
[null,"measure you would like to use and then enter the pupil's actual key stage 4 attainment for the measure you have chosen.",null,null,null,null,null,null,null,null,null,null,null,"CALCULATION CELL",null,null,null,null,null,null,null,null,null,"English Baccalaureate - languages subject area"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VALUE ADDED SCORE"]
[null,"1) WHICH PROGRESS MEASURE?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($G$9=$X$2,\"Maths\",IF($G$9=$X$3,\"Science\",IF($G$9=$X$4,\"Humanities\",\"Language\")))","v":"Maths"}]
[null,"Using the drop down box, please select the key stage 2 to 4 English Baccalaureate progress measure you wish to view",null,null,null,null,"--Select--",null,null,{"$f":"VLOOKUP($G$9,$X$1:$AA$6,4,FALSE)","v":0},null,null,null,"Qualifications which count towards the EBacc"]
[]
[null,"2) ACTUAL KEY STAGE 4 ATTAINMENT"]
[]
[null,"Please enter the pupil's score",null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(G13),ROUND(G13,2),\"\")","v":""}]
[null,"in your chosen EBacc progress measure"]
[null,{"$f":"IF($G$9=$X$6,\"Their English and Maths bonus\",\"\")","v":""}]
[]
[]
[null,"3) ESTIMATED KEY STAGE 4 ATTAINMENT"]
[]
[null,"This section estimates the pupil's key stage 4 outcome based on their key stage 2 prior attainment."]
[]
[null,null,null,"KS2 information",null,null,"Estimated KS4 outcome",null,null,null,{"$f":"IF(ISNUMBER($J$13), $J$13,\"\")","v":""}]
[]
[]
[null,"Key stage 2 reading and maths score in fine level",null,{"$f":"IF('Key stage 2 Data Input'!E32=\"Pupil\",\"-\",ROUND('Key stage 2 Data Input'!F35,1))","v":"-"},null,null,{"$f":"IF(D25=\"-\",\"-\",IF(G9=X2,\"Please select the progress measure you wish to use\",IF(G9=X3,VLOOKUP(D25,'Model values'!B9:E42,2,FALSE),IF(G9=X4,VLOOKUP(D25,'Model values'!B9:E42,3,FALSE),IF(G9=X5,VLOOKUP(D25,'Model values'!B9:E42,4,FALSE),\"-\")))))","v":"-"}]
[]
[null,null,null,null,null,null,null,{"$f":"VALUE(LEFT(G25,5))","v":{"$error":"#VALUE!"}}]
[]
[null,"4) PUPIL VALUE ADDED SCORE"]
[]
[]
[null,"VA SCORE (ACTUAL - ESTIMATED)",null,null,null,"=",{"$f":"IF(ISBLANK(G13),\"-\",IF(ISERROR(G13-H27),\"-\",ROUND(G13-H27,2)))","v":"-"}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(H25+#REF!+#REF!+#REF!+#REF!+H27,6)),\"\",ROUND(H25+#REF!+#REF!+#REF!+#REF!+H27,6))","v":""}]
[]
[null,null,"Back to Key stage 2 Data Input\n<---",null,null,null,"To All Measures Ready Reckoner  --->"]

{"sheet":"All Measures Ready Reckoner","index":5,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[7,3,7,7],[1,12,1,13],[18,11,19,13],[2,12,2,13],[3,12,3,13],[4,12,4,13]]}
[]
[null,"INDIVIDUAL PUPIL KEY STAGE 2 - 4 EBACC SUBJECTS READY RECKONER - ALL MEASURES",null,null,null,null,null,null,null,null,null,null,"CELL COLOUR GUIDE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"DATA INPUT CELL"]
[null,"The purpose of this sheet is to allow the user to calculate the value added scores for all three key stage 2  to 4 EBacc progress measures at the same time.",null,null,null,null,null,null,null,null,null,null,"CALCULATION CELL"]
[null,"To complete this sheet, you need to enter the pupil's actual key stage 4 attainment for the various measures",null,null,null,null,null,null,null,null,null,null,"VALUE ADDED SCORE"]
[null,"The input for this sheet is still the 'Key stage 2 Data Input' sheet."]
[]
[null,null,null,"Key stage 2 to 4 progress measures"]
[]
[null,null,null,"English Baccalaureate - science subject area",null,"English Baccalaureate - humanities subject area",null,"English Baccalaureate - languages subject area"]
[]
[null,"Please enter the pupil's actual key stage 4 attainment",null,9.5,null,9.5,null,9.5]
[]
[null,"Pupil's estimated key stage 4 attainment (calculated)",null,{"$f":"IF(ISERROR(VLOOKUP('Single Measure Ready Reckoner'!$D25,'Model values'!$B$9:$E$42,2,FALSE)),\"-\",VLOOKUP('Single Measure Ready Reckoner'!$D25,'Model values'!$B$9:$E$42,2,FALSE))","v":"-"},null,{"$f":"IF(ISERROR(VLOOKUP('Single Measure Ready Reckoner'!$D25,'Model values'!$B$9:$E$42,3,FALSE)),\"-\",VLOOKUP('Single Measure Ready Reckoner'!$D25,'Model values'!$B$9:$E$42,3,FALSE))","v":"-"},null,{"$f":"IF(ISERROR(VLOOKUP('Single Measure Ready Reckoner'!$D25,'Model values'!$B$9:$E$42,4,FALSE)),\"-\",VLOOKUP('Single Measure Ready Reckoner'!$D25,'Model values'!$B$9:$E$42,4,FALSE))","v":"-"}]
[null,null,null,{"$f":"IF(ISERROR(ROUND(U2+($R3*U3)+($R4*U4)+($R5*U5)+($R6*U6)+($R7*U7),6)),\"-\",ROUND(U2+($R3*U3)+($R4*U4)+($R5*U5)+($R6*U6)+($R7*U7),6))","v":0},null,{"$f":"IF(ISERROR(ROUND(V2+($R3*V3)+($R4*V4)+($R5*V5)+($R6*V6)+($R7*V7),6)),\"-\",ROUND(V2+($R3*V3)+($R4*V4)+($R5*V5)+($R6*V6)+($R7*V7),6))","v":0},null,{"$f":"IF(ISERROR(ROUND(W2+($R3*W3)+($R4*W4)+($R5*W5)+($R6*W6)+($R7*W7),6)),\"-\",ROUND(W2+($R3*W3)+($R4*W4)+($R5*W5)+($R6*W6)+($R7*W7),6))","v":0}]
[null,"Pupil value added score (calculated)      ",null,{"$f":"IF(ISBLANK(D12),\"-\",IF(ISERROR(D12-D14),\"Pupil Excluded\",ROUND(D12-D14,2)))","v":"Pupil Excluded"},null,{"$f":"IF(ISBLANK(F12),\"-\",IF(ISERROR(F12-F14),\"Pupil Excluded\",ROUND(F12-F14,2)))","v":"Pupil Excluded"},null,{"$f":"IF(ISBLANK(H12),\"-\",IF(ISERROR(H12-H14),\"Pupil Excluded\",ROUND(H12-H14,2)))","v":"Pupil Excluded"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Back to Single Measure Ready Reckoner  <---"]

{"sheet":"Model values","index":6,"n_rows":51,"n_cols":8,"rows_kept":51,"cut":false,"hidden":false,"merged":[[26,7,27,9],[6,1,7,1],[5,6,5,7],[20,7,21,9],[23,7,24,9],[6,2,6,4],[12,6,14,7]]}
[]
[null,"Model Values - 2018 Predicted Scores by Prior Attainment"]
[null,"This sheet shows the 2018 predicted point score in each subject area for pupils with the same prior attainment"]
[null,"Where few pupils achieved a certain prior attainment score, banding had been applied to produce more accurate predicted values"]
[null,"The groupings used for this banding can be seen in table 1"]
[null,null,null,null,null,null,"Table 1 "]
[null,"Prior Attainment Band","Predicted Values 2018",null,null,null,"Prior attainment shown in table","Band includes pupils with prior attainment scores"]
[null,null,"Science","Humanities","Languages",null,1.5,"Less than or equal to 1.5"]
[null,1.5,1.84,1.75,4.82,null,2,"Between 1.6 and 2.0"]
[null,2,1.89,1.67,5.19,null,2.5,"Between 2.1 and 2.5"]
[null,2.5,1.95,1.69,4.29,null,2.8,"Between 2.6 and 2.8"]
[null,2.8,1.94,1.48,3.44,null,5.8,"Greater than or equal to 5.8"]
[null,2.9,2.08,1.64,3.38,null,"All other prior attainment scores in the table have not been banded"]
[null,3,2.21,1.65,3.6]
[null,3.1,2.2999999999999998,1.83,3.26]
[null,3.2,2.31,1.81,3.29]
[null,3.3,2.42,1.92,3.3]
[null,3.4,2.5,1.98,3.48]
[null,3.5,2.58,2.08,3.36]
[null,3.6,2.67,2.17,3.3]
[null,3.7,2.73,2.25,3.3,null,null,"Back to Single Measure Ready Reckoner  <---"]
[null,3.8,2.8,2.3199999999999998,3.26]
[null,3.9,2.92,2.44,3.29]
[null,4,3.06,2.6,3.31,null,null,"Back to All Measures Ready Reckoner <---"]
[null,4.0999999999999996,3.14,2.68,3.43]
[null,4.2,3.25,2.8,3.4]
[null,4.3,3.42,2.96,3.49,null,null,"Back to Ready Reckoner Guidance <---"]
[null,4.4000000000000004,3.57,3.15,3.56]
[null,4.5,3.74,3.36,3.72]
[null,4.5999999999999996,3.96,3.59,3.78]
[null,4.7,4.1500000000000004,3.84,3.89]
[null,4.8,4.37,4.09,4.0199999999999996]
[null,4.9000000000000004,4.6100000000000003,4.37,4.21]
[null,5,4.87,4.6399999999999997,4.37]
[null,5.0999999999999996,5.14,4.97,4.54]
[null,5.2,5.44,5.28,4.78]
[null,5.3,5.73,5.57,5]
[null,5.4,6.06,5.92,5.26]
[null,5.5,6.43,6.26,5.57]
[null,5.6,6.84,6.66,5.92]
[null,5.7,7.33,7.12,6.35]
[null,5.8,7.88,7.64,6.97]
[]
[]
[]
[null,"KS2 Prior band","Best 8 including English & mathematics",2]
[null,null,"English Baccalaureate - English subject area",3]
[null,null,"English Baccalaureate - mathematics subject area",4]
[null,null,"English Baccalaureate - science subject area",5]
[null,null,"English Baccalaureate - humanities subject area",6]
[null,null,"English Baccalaureate - languages subject area",7]

{"sheet":"Chart Data","index":7,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,0,0]
[null,null,600,600]
[null,null,0,0]
[null,null,15,15]

{"sheet":"KS2 Fine grades lookup","index":8,"n_rows":113,"n_cols":8,"rows_kept":113,"cut":false,"hidden":true,"merged":[[100,1,100,2],[101,5,101,6],[112,0,116,5]]}
["Reading",null,null,null,"Maths"]
["tot_2r","K2LEV_r","Fine Grade",null,"tot_2M","K2LEV_M","Fine Grade"]
["A - Absent","-","-",null,"A - Absent","-","-"]
["M - Missing","-","-",null,"M - Missing","-","-"]
["Q - Disregard","-","-",null,"Q - Disregard","-","-"]
["T - No access to test","-","-",null,"T - No access to test","-","-"]
["X - Lost","-","-",null,"X - Lost","-","-"]
["B - Working below level of test","-","-",null,"B - Working below level of test","-","-"]
["N - Not awarded test level","-","-","check","N - Not awarded test level","-","-","check"]
[11,3,{"$f":"B10+((A10-VLOOKUP(B10,$A$103:$E$107,2,FALSE))/(VLOOKUP(B10,$A$103:$E$107,3,FALSE)-VLOOKUP(B10,$A$103:$E$107,2,FALSE)+1))","v":3},{"$f":"IF(VLOOKUP(A10,[3]Sheet1!$A$6:$F$45,6,FALSE)=C10,\"OK\",\"not OK\")","v":"OK"},15,2,{"$f":"3-((VLOOKUP(3,$A$103:$E$107,4,FALSE)-E10)/(VLOOKUP(3,$A$103:$E$107,5,FALSE)-VLOOKUP(3,$A$103:$E$107,4,FALSE)+1))","v":2.8888888888888888},{"$f":"IF(VLOOKUP(E10,[3]Sheet1!$H$6:$M$91,6,FALSE)=G10,\"OK\",\"not OK\")","v":"OK"}]
[12,3,{"$f":"B11+((A11-VLOOKUP(B11,$A$103:$E$107,2,FALSE))/(VLOOKUP(B11,$A$103:$E$107,3,FALSE)-VLOOKUP(B11,$A$103:$E$107,2,FALSE)+1))","v":3.125},{"$f":"IF(VLOOKUP(A11,[3]Sheet1!$A$6:$F$45,6,FALSE)=C11,\"OK\",\"not OK\")","v":"OK"},16,2,{"$f":"3-((VLOOKUP(3,$A$103:$E$107,4,FALSE)-E11)/(VLOOKUP(3,$A$103:$E$107,5,FALSE)-VLOOKUP(3,$A$103:$E$107,4,FALSE)+1))","v":2.925925925925926},{"$f":"IF(VLOOKUP(E11,[3]Sheet1!$H$6:$M$91,6,FALSE)=G11,\"OK\",\"not OK\")","v":"OK"}]
[13,3,3.25,{"$f":"IF(VLOOKUP(A12,[3]Sheet1!$A$6:$F$45,6,FALSE)=C12,\"OK\",\"not OK\")","v":"OK"},17,2,2.9629629629629628,{"$f":"IF(VLOOKUP(E12,[3]Sheet1!$H$6:$M$91,6,FALSE)=G12,\"OK\",\"not OK\")","v":"OK"}]
[14,3,3.375,{"$f":"IF(VLOOKUP(A13,[3]Sheet1!$A$6:$F$45,6,FALSE)=C13,\"OK\",\"not OK\")","v":"OK"},18,3,{"$f":"F13+((E13-VLOOKUP(F13,$A$103:$E$107,4,FALSE))/(VLOOKUP(F13,$A$103:$E$107,5,FALSE)-VLOOKUP(F13,$A$103:$E$107,4,FALSE)+1))","v":3},{"$f":"IF(VLOOKUP(E13,[3]Sheet1!$H$6:$M$91,6,FALSE)=G13,\"OK\",\"not OK\")","v":"OK"}]
[15,3,3.5,{"$f":"IF(VLOOKUP(A14,[3]Sheet1!$A$6:$F$45,6,FALSE)=C14,\"OK\",\"not OK\")","v":"OK"},19,3,{"$f":"F14+((E14-VLOOKUP(F14,$A$103:$E$107,4,FALSE))/(VLOOKUP(F14,$A$103:$E$107,5,FALSE)-VLOOKUP(F14,$A$103:$E$107,4,FALSE)+1))","v":3.0370370370370372},{"$f":"IF(VLOOKUP(E14,[3]Sheet1!$H$6:$M$91,6,FALSE)=G14,\"OK\",\"not OK\")","v":"OK"}]
[16,3,3.625,{"$f":"IF(VLOOKUP(A15,[3]Sheet1!$A$6:$F$45,6,FALSE)=C15,\"OK\",\"not OK\")","v":"OK"},20,3,3.074074074074074,{"$f":"IF(VLOOKUP(E15,[3]Sheet1!$H$6:$M$91,6,FALSE)=G15,\"OK\",\"not OK\")","v":"OK"}]
[17,3,3.75,{"$f":"IF(VLOOKUP(A16,[3]Sheet1!$A$6:$F$45,6,FALSE)=C16,\"OK\",\"not OK\")","v":"OK"},21,3,3.1111111111111112,{"$f":"IF(VLOOKUP(E16,[3]Sheet1!$H$6:$M$91,6,FALSE)=G16,\"OK\",\"not OK\")","v":"OK"}]
[18,3,3.875,{"$f":"IF(VLOOKUP(A17,[3]Sheet1!$A$6:$F$45,6,FALSE)=C17,\"OK\",\"not OK\")","v":"OK"},22,3,3.1481481481481479,{"$f":"IF(VLOOKUP(E17,[3]Sheet1!$H$6:$M$91,6,FALSE)=G17,\"OK\",\"not OK\")","v":"OK"}]
[19,4,4,{"$f":"IF(VLOOKUP(A18,[3]Sheet1!$A$6:$F$45,6,FALSE)=C18,\"OK\",\"not OK\")","v":"OK"},23,3,3.1851851851851851,{"$f":"IF(VLOOKUP(E18,[3]Sheet1!$H$6:$M$91,6,FALSE)=G18,\"OK\",\"not OK\")","v":"OK"}]
[20,4,4.0588235294117645,{"$f":"IF(VLOOKUP(A19,[3]Sheet1!$A$6:$F$45,6,FALSE)=C19,\"OK\",\"not OK\")","v":"OK"},24,3,3.2222222222222223,{"$f":"IF(VLOOKUP(E19,[3]Sheet1!$H$6:$M$91,6,FALSE)=G19,\"OK\",\"not OK\")","v":"OK"}]
[21,4,4.117647058823529,{"$f":"IF(VLOOKUP(A20,[3]Sheet1!$A$6:$F$45,6,FALSE)=C20,\"OK\",\"not OK\")","v":"OK"},25,3,3.2592592592592591,{"$f":"IF(VLOOKUP(E20,[3]Sheet1!$H$6:$M$91,6,FALSE)=G20,\"OK\",\"not OK\")","v":"OK"}]
[22,4,4.1764705882352944,{"$f":"IF(VLOOKUP(A21,[3]Sheet1!$A$6:$F$45,6,FALSE)=C21,\"OK\",\"not OK\")","v":"OK"},26,3,3.2962962962962963,{"$f":"IF(VLOOKUP(E21,[3]Sheet1!$H$6:$M$91,6,FALSE)=G21,\"OK\",\"not OK\")","v":"OK"}]
[23,4,4.2352941176470589,{"$f":"IF(VLOOKUP(A22,[3]Sheet1!$A$6:$F$45,6,FALSE)=C22,\"OK\",\"not OK\")","v":"OK"},27,3,3.3333333333333335,{"$f":"IF(VLOOKUP(E22,[3]Sheet1!$H$6:$M$91,6,FALSE)=G22,\"OK\",\"not OK\")","v":"OK"}]
[24,4,4.2941176470588234,{"$f":"IF(VLOOKUP(A23,[3]Sheet1!$A$6:$F$45,6,FALSE)=C23,\"OK\",\"not OK\")","v":"OK"},28,3,3.3703703703703702,{"$f":"IF(VLOOKUP(E23,[3]Sheet1!$H$6:$M$91,6,FALSE)=G23,\"OK\",\"not OK\")","v":"OK"}]
[25,4,4.3529411764705879,{"$f":"IF(VLOOKUP(A24,[3]Sheet1!$A$6:$F$45,6,FALSE)=C24,\"OK\",\"not OK\")","v":"OK"},29,3,3.4074074074074074,{"$f":"IF(VLOOKUP(E24,[3]Sheet1!$H$6:$M$91,6,FALSE)=G24,\"OK\",\"not OK\")","v":"OK"}]
[26,4,4.4117647058823533,{"$f":"IF(VLOOKUP(A25,[3]Sheet1!$A$6:$F$45,6,FALSE)=C25,\"OK\",\"not OK\")","v":"OK"},30,3,3.4444444444444446,{"$f":"IF(VLOOKUP(E25,[3]Sheet1!$H$6:$M$91,6,FALSE)=G25,\"OK\",\"not OK\")","v":"OK"}]
[27,4,4.4705882352941178,{"$f":"IF(VLOOKUP(A26,[3]Sheet1!$A$6:$F$45,6,FALSE)=C26,\"OK\",\"not OK\")","v":"OK"},31,3,3.4814814814814814,{"$f":"IF(VLOOKUP(E26,[3]Sheet1!$H$6:$M$91,6,FALSE)=G26,\"OK\",\"not OK\")","v":"OK"}]
[28,4,4.5294117647058822,{"$f":"IF(VLOOKUP(A27,[3]Sheet1!$A$6:$F$45,6,FALSE)=C27,\"OK\",\"not OK\")","v":"OK"},32,3,3.5185185185185186,{"$f":"IF(VLOOKUP(E27,[3]Sheet1!$H$6:$M$91,6,FALSE)=G27,\"OK\",\"not OK\")","v":"OK"}]
[29,4,4.5882352941176467,{"$f":"IF(VLOOKUP(A28,[3]Sheet1!$A$6:$F$45,6,FALSE)=C28,\"OK\",\"not OK\")","v":"OK"},33,3,3.5555555555555554,{"$f":"IF(VLOOKUP(E28,[3]Sheet1!$H$6:$M$91,6,FALSE)=G28,\"OK\",\"not OK\")","v":"OK"}]
[30,4,4.6470588235294121,{"$f":"IF(VLOOKUP(A29,[3]Sheet1!$A$6:$F$45,6,FALSE)=C29,\"OK\",\"not OK\")","v":"OK"},34,3,3.5925925925925926,{"$f":"IF(VLOOKUP(E29,[3]Sheet1!$H$6:$M$91,6,FALSE)=G29,\"OK\",\"not OK\")","v":"OK"}]
[31,4,4.7058823529411766,{"$f":"IF(VLOOKUP(A30,[3]Sheet1!$A$6:$F$45,6,FALSE)=C30,\"OK\",\"not OK\")","v":"OK"},35,3,3.6296296296296298,{"$f":"IF(VLOOKUP(E30,[3]Sheet1!$H$6:$M$91,6,FALSE)=G30,\"OK\",\"not OK\")","v":"OK"}]
[32,4,4.7647058823529411,{"$f":"IF(VLOOKUP(A31,[3]Sheet1!$A$6:$F$45,6,FALSE)=C31,\"OK\",\"not OK\")","v":"OK"},36,3,3.6666666666666665,{"$f":"IF(VLOOKUP(E31,[3]Sheet1!$H$6:$M$91,6,FALSE)=G31,\"OK\",\"not OK\")","v":"OK"}]
[33,4,4.8235294117647056,{"$f":"IF(VLOOKUP(A32,[3]Sheet1!$A$6:$F$45,6,FALSE)=C32,\"OK\",\"not OK\")","v":"OK"},37,3,3.7037037037037037,{"$f":"IF(VLOOKUP(E32,[3]Sheet1!$H$6:$M$91,6,FALSE)=G32,\"OK\",\"not OK\")","v":"OK"}]
[34,4,4.882352941176471,{"$f":"IF(VLOOKUP(A33,[3]Sheet1!$A$6:$F$45,6,FALSE)=C33,\"OK\",\"not OK\")","v":"OK"},38,3,3.7407407407407405,{"$f":"IF(VLOOKUP(E33,[3]Sheet1!$H$6:$M$91,6,FALSE)=G33,\"OK\",\"not OK\")","v":"OK"}]
[35,4,4.9411764705882355,{"$f":"IF(VLOOKUP(A34,[3]Sheet1!$A$6:$F$45,6,FALSE)=C34,\"OK\",\"not OK\")","v":"OK"},39,3,3.7777777777777777,{"$f":"IF(VLOOKUP(E34,[3]Sheet1!$H$6:$M$91,6,FALSE)=G34,\"OK\",\"not OK\")","v":"OK"}]
[36,5,5,{"$f":"IF(VLOOKUP(A35,[3]Sheet1!$A$6:$F$45,6,FALSE)=C35,\"OK\",\"not OK\")","v":"OK"},40,3,3.8148148148148149,{"$f":"IF(VLOOKUP(E35,[3]Sheet1!$H$6:$M$91,6,FALSE)=G35,\"OK\",\"not OK\")","v":"OK"}]
[37,5,5.0666666666666664,{"$f":"IF(VLOOKUP(A36,[3]Sheet1!$A$6:$F$45,6,FALSE)=C36,\"OK\",\"not OK\")","v":"OK"},41,3,3.8518518518518521,{"$f":"IF(VLOOKUP(E36,[3]Sheet1!$H$6:$M$91,6,FALSE)=G36,\"OK\",\"not OK\")","v":"OK"}]
[38,5,5.1333333333333337,{"$f":"IF(VLOOKUP(A37,[3]Sheet1!$A$6:$F$45,6,FALSE)=C37,\"OK\",\"not OK\")","v":"OK"},42,3,3.8888888888888888,{"$f":"IF(VLOOKUP(E37,[3]Sheet1!$H$6:$M$91,6,FALSE)=G37,\"OK\",\"not OK\")","v":"OK"}]
[39,5,5.2,{"$f":"IF(VLOOKUP(A38,[3]Sheet1!$A$6:$F$45,6,FALSE)=C38,\"OK\",\"not OK\")","v":"OK"},43,3,3.925925925925926,{"$f":"IF(VLOOKUP(E38,[3]Sheet1!$H$6:$M$91,6,FALSE)=G38,\"OK\",\"not OK\")","v":"OK"}]
[40,5,5.2666666666666666,{"$f":"IF(VLOOKUP(A39,[3]Sheet1!$A$6:$F$45,6,FALSE)=C39,\"OK\",\"not OK\")","v":"OK"},44,3,3.9629629629629628,{"$f":"IF(VLOOKUP(E39,[3]Sheet1!$H$6:$M$91,6,FALSE)=G39,\"OK\",\"not OK\")","v":"OK"}]
[41,5,5.333333333333333,{"$f":"IF(VLOOKUP(A40,[3]Sheet1!$A$6:$F$45,6,FALSE)=C40,\"OK\",\"not OK\")","v":"OK"},45,4,4,{"$f":"IF(VLOOKUP(E40,[3]Sheet1!$H$6:$M$91,6,FALSE)=G40,\"OK\",\"not OK\")","v":"OK"}]
[42,5,5.4,{"$f":"IF(VLOOKUP(A41,[3]Sheet1!$A$6:$F$45,6,FALSE)=C41,\"OK\",\"not OK\")","v":"OK"},46,4,4.0294117647058822,{"$f":"IF(VLOOKUP(E41,[3]Sheet1!$H$6:$M$91,6,FALSE)=G41,\"OK\",\"not OK\")","v":"OK"}]
[43,5,5.4666666666666668,{"$f":"IF(VLOOKUP(A42,[3]Sheet1!$A$6:$F$45,6,FALSE)=C42,\"OK\",\"not OK\")","v":"OK"},47,4,4.0588235294117645,{"$f":"IF(VLOOKUP(E42,[3]Sheet1!$H$6:$M$91,6,FALSE)=G42,\"OK\",\"not OK\")","v":"OK"}]
[44,5,5.5333333333333332,{"$f":"IF(VLOOKUP(A43,[3]Sheet1!$A$6:$F$45,6,FALSE)=C43,\"OK\",\"not OK\")","v":"OK"},48,4,4.0882352941176467,{"$f":"IF(VLOOKUP(E43,[3]Sheet1!$H$6:$M$91,6,FALSE)=G43,\"OK\",\"not OK\")","v":"OK"}]
[45,5,5.6,{"$f":"IF(VLOOKUP(A44,[3]Sheet1!$A$6:$F$45,6,FALSE)=C44,\"OK\",\"not OK\")","v":"OK"},49,4,4.117647058823529,{"$f":"IF(VLOOKUP(E44,[3]Sheet1!$H$6:$M$91,6,FALSE)=G44,\"OK\",\"not OK\")","v":"OK"}]
[46,5,5.666666666666667,{"$f":"IF(VLOOKUP(A45,[3]Sheet1!$A$6:$F$45,6,FALSE)=C45,\"OK\",\"not OK\")","v":"OK"},50,4,4.1470588235294121,{"$f":"IF(VLOOKUP(E45,[3]Sheet1!$H$6:$M$91,6,FALSE)=G45,\"OK\",\"not OK\")","v":"OK"}]
[47,5,5.7333333333333334,{"$f":"IF(VLOOKUP(A46,[3]Sheet1!$A$6:$F$45,6,FALSE)=C46,\"OK\",\"not OK\")","v":"OK"},51,4,4.1764705882352944,{"$f":"IF(VLOOKUP(E46,[3]Sheet1!$H$6:$M$91,6,FALSE)=G46,\"OK\",\"not OK\")","v":"OK"}]
[48,5,5.8,{"$f":"IF(VLOOKUP(A47,[3]Sheet1!$A$6:$F$45,6,FALSE)=C47,\"OK\",\"not OK\")","v":"OK"},52,4,4.2058823529411766,{"$f":"IF(VLOOKUP(E47,[3]Sheet1!$H$6:$M$91,6,FALSE)=G47,\"OK\",\"not OK\")","v":"OK"}]
[49,5,5.8666666666666671,{"$f":"IF(VLOOKUP(A48,[3]Sheet1!$A$6:$F$45,6,FALSE)=C48,\"OK\",\"not OK\")","v":"OK"},53,4,4.2352941176470589,{"$f":"IF(VLOOKUP(E48,[3]Sheet1!$H$6:$M$91,6,FALSE)=G48,\"OK\",\"not OK\")","v":"OK"}]
[50,5,{"$f":"B49+((A49-VLOOKUP(B49,$A$103:$E$107,2,FALSE))/(VLOOKUP(B49,$A$103:$E$107,3,FALSE)-VLOOKUP(B49,$A$103:$E$107,2,FALSE)+1))","v":5.9333333333333336},{"$f":"IF(VLOOKUP(A49,[3]Sheet1!$A$6:$F$45,6,FALSE)=C49,\"OK\",\"not OK\")","v":"OK"},54,4,4.2647058823529411,{"$f":"IF(VLOOKUP(E49,[3]Sheet1!$H$6:$M$91,6,FALSE)=G49,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,55,4,4.2941176470588234,{"$f":"IF(VLOOKUP(E50,[3]Sheet1!$H$6:$M$91,6,FALSE)=G50,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,56,4,4.3235294117647056,{"$f":"IF(VLOOKUP(E51,[3]Sheet1!$H$6:$M$91,6,FALSE)=G51,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,57,4,4.3529411764705879,{"$f":"IF(VLOOKUP(E52,[3]Sheet1!$H$6:$M$91,6,FALSE)=G52,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,58,4,4.382352941176471,{"$f":"IF(VLOOKUP(E53,[3]Sheet1!$H$6:$M$91,6,FALSE)=G53,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,59,4,4.4117647058823533,{"$f":"IF(VLOOKUP(E54,[3]Sheet1!$H$6:$M$91,6,FALSE)=G54,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,60,4,4.4411764705882355,{"$f":"IF(VLOOKUP(E55,[3]Sheet1!$H$6:$M$91,6,FALSE)=G55,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,61,4,4.4705882352941178,{"$f":"IF(VLOOKUP(E56,[3]Sheet1!$H$6:$M$91,6,FALSE)=G56,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,62,4,4.5,{"$f":"IF(VLOOKUP(E57,[3]Sheet1!$H$6:$M$91,6,FALSE)=G57,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,63,4,4.5294117647058822,{"$f":"IF(VLOOKUP(E58,[3]Sheet1!$H$6:$M$91,6,FALSE)=G58,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,64,4,4.5588235294117645,{"$f":"IF(VLOOKUP(E59,[3]Sheet1!$H$6:$M$91,6,FALSE)=G59,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,65,4,4.5882352941176467,{"$f":"IF(VLOOKUP(E60,[3]Sheet1!$H$6:$M$91,6,FALSE)=G60,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,66,4,4.617647058823529,{"$f":"IF(VLOOKUP(E61,[3]Sheet1!$H$6:$M$91,6,FALSE)=G61,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,67,4,4.6470588235294121,{"$f":"IF(VLOOKUP(E62,[3]Sheet1!$H$6:$M$91,6,FALSE)=G62,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,68,4,4.6764705882352944,{"$f":"IF(VLOOKUP(E63,[3]Sheet1!$H$6:$M$91,6,FALSE)=G63,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,69,4,4.7058823529411766,{"$f":"IF(VLOOKUP(E64,[3]Sheet1!$H$6:$M$91,6,FALSE)=G64,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,70,4,4.7352941176470589,{"$f":"IF(VLOOKUP(E65,[3]Sheet1!$H$6:$M$91,6,FALSE)=G65,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,71,4,4.7647058823529411,{"$f":"IF(VLOOKUP(E66,[3]Sheet1!$H$6:$M$91,6,FALSE)=G66,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,72,4,4.7941176470588234,{"$f":"IF(VLOOKUP(E67,[3]Sheet1!$H$6:$M$91,6,FALSE)=G67,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,73,4,4.8235294117647056,{"$f":"IF(VLOOKUP(E68,[3]Sheet1!$H$6:$M$91,6,FALSE)=G68,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,74,4,4.8529411764705879,{"$f":"IF(VLOOKUP(E69,[3]Sheet1!$H$6:$M$91,6,FALSE)=G69,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,75,4,4.882352941176471,{"$f":"IF(VLOOKUP(E70,[3]Sheet1!$H$6:$M$91,6,FALSE)=G70,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,76,4,4.9117647058823533,{"$f":"IF(VLOOKUP(E71,[3]Sheet1!$H$6:$M$91,6,FALSE)=G71,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,77,4,4.9411764705882355,{"$f":"IF(VLOOKUP(E72,[3]Sheet1!$H$6:$M$91,6,FALSE)=G72,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,78,4,4.9705882352941178,{"$f":"IF(VLOOKUP(E73,[3]Sheet1!$H$6:$M$91,6,FALSE)=G73,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,79,5,5,{"$f":"IF(VLOOKUP(E74,[3]Sheet1!$H$6:$M$91,6,FALSE)=G74,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,80,5,5.0454545454545459,{"$f":"IF(VLOOKUP(E75,[3]Sheet1!$H$6:$M$91,6,FALSE)=G75,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,81,5,5.0909090909090908,{"$f":"IF(VLOOKUP(E76,[3]Sheet1!$H$6:$M$91,6,FALSE)=G76,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,82,5,5.1363636363636367,{"$f":"IF(VLOOKUP(E77,[3]Sheet1!$H$6:$M$91,6,FALSE)=G77,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,83,5,{"$f":"F78+((E78-VLOOKUP(F78,$A$103:$E$107,4,FALSE))/(VLOOKUP(F78,$A$103:$E$107,5,FALSE)-VLOOKUP(F78,$A$103:$E$107,4,FALSE)+1))","v":5.1818181818181817},{"$f":"IF(VLOOKUP(E78,[3]Sheet1!$H$6:$M$91,6,FALSE)=G78,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,84,5,5.2272727272727275,{"$f":"IF(VLOOKUP(E79,[3]Sheet1!$H$6:$M$91,6,FALSE)=G79,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,85,5,5.2727272727272725,{"$f":"IF(VLOOKUP(E80,[3]Sheet1!$H$6:$M$91,6,FALSE)=G80,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,86,5,5.3181818181818183,{"$f":"IF(VLOOKUP(E81,[3]Sheet1!$H$6:$M$91,6,FALSE)=G81,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,87,5,5.3636363636363633,{"$f":"IF(VLOOKUP(E82,[3]Sheet1!$H$6:$M$91,6,FALSE)=G82,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,88,5,5.4090909090909092,{"$f":"IF(VLOOKUP(E83,[3]Sheet1!$H$6:$M$91,6,FALSE)=G83,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,89,5,5.4545454545454541,{"$f":"IF(VLOOKUP(E84,[3]Sheet1!$H$6:$M$91,6,FALSE)=G84,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,90,5,5.5,{"$f":"IF(VLOOKUP(E85,[3]Sheet1!$H$6:$M$91,6,FALSE)=G85,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,91,5,5.545454545454545,{"$f":"IF(VLOOKUP(E86,[3]Sheet1!$H$6:$M$91,6,FALSE)=G86,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,92,5,5.5909090909090908,{"$f":"IF(VLOOKUP(E87,[3]Sheet1!$H$6:$M$91,6,FALSE)=G87,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,93,5,5.6363636363636367,{"$f":"IF(VLOOKUP(E88,[3]Sheet1!$H$6:$M$91,6,FALSE)=G88,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,94,5,5.6818181818181817,{"$f":"IF(VLOOKUP(E89,[3]Sheet1!$H$6:$M$91,6,FALSE)=G89,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,95,5,5.7272727272727275,{"$f":"IF(VLOOKUP(E90,[3]Sheet1!$H$6:$M$91,6,FALSE)=G90,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,96,5,5.7727272727272725,{"$f":"IF(VLOOKUP(E91,[3]Sheet1!$H$6:$M$91,6,FALSE)=G91,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,97,5,5.8181818181818183,{"$f":"IF(VLOOKUP(E92,[3]Sheet1!$H$6:$M$91,6,FALSE)=G92,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,98,5,5.8636363636363633,{"$f":"IF(VLOOKUP(E93,[3]Sheet1!$H$6:$M$91,6,FALSE)=G93,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,99,5,5.9090909090909092,{"$f":"IF(VLOOKUP(E94,[3]Sheet1!$H$6:$M$91,6,FALSE)=G94,\"OK\",\"not OK\")","v":"OK"}]
[null,null,null,null,100,5,5.954545454545455,{"$f":"IF(VLOOKUP(E95,[3]Sheet1!$H$6:$M$91,6,FALSE)=G95,\"OK\",\"not OK\")","v":"OK"}]
[]
[]
[]
["2013 Key Stage 2 Thresholds"]
[]
[null,"reading",null,"Mathematics"]
[null,"lower","upper","lower","upper"]
["N",0,10,0,14]
[2,null,null,15,17]
[3,11,18,18,44]
[4,19,35,45,78]
[5,36,50,79,100]
[]
[]
[]
[]
[]
["The thresholds for Reading have changed slightly in 2013 with L4 beginning at 19 marks rather than 18 last year. Level 5 now begins at 36 points which is 3 marks higher than last year. In maths Level 4 now begins at 45 marks which is 1 mark lower than last year. A number of schools’ results will be affected by these shifts."]