{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Lookup","Subject raw marks data","Scaling Calculator"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"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":"Lookup","index":0,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["Subject","Qualification","Component","Scaling",null,null,null,null,null,null,"Subject",null,"English Literature","English Language","English Language and Literature"]
["English Literature","8ET0",1,1,null,null,null,null,null,null,"English Literature",null,"8ET0","9EN0","9EL0"]
["English Literature","8ET0",2,1.091,null,null,null,null,null,null,"English Language",null,"9ET0"]
["English Literature","9ET0",1,1.5,null,null,null,null,null,null,"English Language and Literature"]
["English Literature","9ET0",2,1.5]
["English Literature","9ET0",3,1.5]
["English Literature","9ET0",4,1]
["English Language","9EN0",1,1.458]
["English Language","9EN0",2,1.111]
["English Language","9EN0",3,1.389]
["English Language","9EN0",4,1]
["English Language and Literature","9EL0",1,2.4]
["English Language and Literature","9EL0",2,2.4]
["English Language and Literature","9EL0",3,1]

{"sheet":"Subject raw marks data","index":1,"n_rows":74,"n_cols":13,"rows_kept":74,"cut":false,"hidden":true,"merged":[]}
["8ET0 Comp 1","8ET0 Comp 2","9ET0 Comp 1","9ET0 Comp 2","9ET0 Comp 3","9ET0 Comp 4","9EN0 Comp 1","9EN0 Comp 2","9EN0 Comp 3","9EN0 Comp 4","9EL0 Comp 1","9EL0 Comp 2","9EL0 Comp 3"]
[0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,1,1,1,1,1,1,1,1,1,1,1,1]
[2,2,2,2,2,2,2,2,2,2,2,2,2]
[3,3,3,3,3,3,3,3,3,3,3,3,3]
[4,4,4,4,4,4,4,4,4,4,4,4,4]
[5,5,5,5,5,5,5,5,5,5,5,5,5]
[6,6,6,6,6,6,6,6,6,6,6,6,6]
[7,7,7,7,7,7,7,7,7,7,7,7,7]
[8,8,8,8,8,8,8,8,8,8,8,8,8]
[9,9,9,9,9,9,9,9,9,9,9,9,9]
[10,10,10,10,10,10,10,10,10,10,10,10,10]
[11,11,11,11,11,11,11,11,11,11,11,11,11]
[12,12,12,12,12,12,12,12,12,12,12,12,12]
[13,13,13,13,13,13,13,13,13,13,13,13,13]
[14,14,14,14,14,14,14,14,14,14,14,14,14]
[15,15,15,15,15,15,15,15,15,15,15,15,15]
[16,16,16,16,16,16,16,16,16,16,16,16,16]
[17,17,17,17,17,17,17,17,17,17,17,17,17]
[18,18,18,18,18,18,18,18,18,18,18,18,18]
[19,19,19,19,19,19,19,19,19,19,19,19,19]
[20,20,20,20,20,20,20,20,20,20,20,20,20]
[21,21,21,21,21,21,21,21,21,21,21,21,21]
[22,22,22,22,22,22,22,22,22,22,22,22,22]
[23,23,23,23,23,23,23,23,23,23,23,23,23]
[24,24,24,24,24,24,24,24,24,24,24,24,24]
[25,25,25,25,25,25,25,25,25,25,25,25,25]
[26,26,26,26,26,26,26,26,26,26,26,26,26]
[27,27,27,27,27,27,27,27,27,27,27,27,27]
[28,28,28,28,28,28,28,28,28,28,28,28,28]
[29,29,29,29,29,29,29,29,29,29,29,29,29]
[30,30,30,30,30,30,30,30,30,30,30,30,30]
[31,31,31,31,31,31,31,31,31,31,31,31,31]
[32,32,32,32,32,32,32,32,32,32,32,32,32]
[33,33,33,33,33,33,33,33,33,33,33,33,33]
[34,34,34,34,34,34,34,34,34,34,34,34,34]
[35,35,35,35,35,35,35,35,35,35,35,35,35]
[36,36,36,36,36,36,36,36,36,36,36,36,36]
[37,37,37,37,37,37,37,37,37,37,37,37,37]
[38,38,38,38,38,38,38,38,38,38,38,38,38]
[39,39,39,39,39,39,39,39,39,39,39,39,39]
[40,40,40,40,40,40,40,40,40,40,40,40,40]
[41,41,41,null,41,41,41,41,41,41,41,41,41]
[42,42,42,null,42,42,42,42,42,42,42,42,42]
[43,43,43,null,43,43,43,43,43,43,43,43,43]
[44,44,44,null,44,44,44,44,44,44,44,44,44]
[45,null,45,null,45,45,45,45,45,45,45,45,45]
[46,null,46,null,46,46,46,null,null,46,46,46,46]
[47,null,47,null,47,47,47,null,null,47,47,47,47]
[48,null,48,null,48,48,48,null,null,48,48,48,48]
[49,null,49,null,49,49,49,null,null,49,49,49,49]
[50,null,50,null,50,50,50,null,null,50,50,50,50]
[51,null,51,null,51,51,51,null,null,null,null,null,51]
[52,null,52,null,52,52,52,null,null,null,null,null,52]
[53,null,53,null,53,53,53,null,null,null,null,null,53]
[54,null,54,null,54,54,54,null,null,null,null,null,54]
[55,null,55,null,55,55,55,null,null,null,null,null,55]
[56,null,56,null,56,56,56,null,null,null,null,null,56]
[57,null,57,null,57,57,57,null,null,null,null,null,57]
[58,null,58,null,58,58,58,null,null,null,null,null,58]
[59,null,59,null,59,59,59,null,null,null,null,null,59]
[60,null,60,null,60,60,60,null,null,null,null,null,60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]

{"sheet":"Scaling Calculator","index":2,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,2,1,4]]}
[]
[null,"Subject","English Language and Literature"]
[]
[null,"Qualification ","9EL0"]
[]
[null,"Component","Raw mark","Scaling Factor","Subject mark for component"]
[null,{"$f":"IFERROR(INDEX(Lookup!$A$1:$D$500,SMALL(IF(Lookup!$A$1:$D$500='Scaling Calculator'!$C$4,ROW(Lookup!$A$1:$D$500)),ROW(1:1))*1,3),\"\")","v":1},null,{"$f":"IFERROR(INDEX(Lookup!$A$1:$D$500,SMALL(IF(Lookup!$A$1:$D$500='Scaling Calculator'!$C$4,ROW(Lookup!$A$1:$D$500)),ROW(1:1))*1,4),\"\")","v":2.4},{"$f":"IFERROR(C7*D7,\"\")","v":0}]
[null,{"$f":"IFERROR(INDEX(Lookup!$A$1:$D$500,SMALL(IF(Lookup!$A$1:$D$500='Scaling Calculator'!$C$4,ROW(Lookup!$A$1:$D$500)),ROW(2:2))*1,3),\"\")","v":2},null,{"$f":"IFERROR(INDEX(Lookup!$A$1:$D$500,SMALL(IF(Lookup!$A$1:$D$500='Scaling Calculator'!$C$4,ROW(Lookup!$A$1:$D$500)),ROW(2:2))*1,4),\"\")","v":2.4},{"$f":"IFERROR(C8*D8,\"\")","v":0}]
[null,{"$f":"IFERROR(INDEX(Lookup!$A$1:$D$500,SMALL(IF(Lookup!$A$1:$D$500='Scaling Calculator'!$C$4,ROW(Lookup!$A$1:$D$500)),ROW(3:3))*1,3),\"\")","v":3},null,{"$f":"IFERROR(INDEX(Lookup!$A$1:$D$500,SMALL(IF(Lookup!$A$1:$D$500='Scaling Calculator'!$C$4,ROW(Lookup!$A$1:$D$500)),ROW(3:3))*1,4),\"\")","v":1},{"$f":"IFERROR(C9*D9,\"\")","v":0}]
[null,{"$f":"IFERROR(INDEX(Lookup!$A$1:$D$500,SMALL(IF(Lookup!$A$1:$D$500='Scaling Calculator'!$C$4,ROW(Lookup!$A$1:$D$500)),ROW(4:4))*1,3),\"\")","v":""},null,{"$f":"IFERROR(INDEX(Lookup!$A$1:$D$500,SMALL(IF(Lookup!$A$1:$D$500='Scaling Calculator'!$C$4,ROW(Lookup!$A$1:$D$500)),ROW(4:4))*1,4),\"\")","v":""},{"$f":"IFERROR(C10*D10,\"\")","v":""}]
[null,"Total raw marks",{"$f":"SUM(C7:C10)","v":0},"Total subject marks",{"$f":"SUM(E7:E10)","v":0}]