{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Credit Card Summary","Data"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":5,"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":"Credit Card Summary","index":0,"n_rows":59,"n_cols":22,"rows_kept":59,"cut":false,"hidden":false,"merged":[[7,0,7,8],[1,16,1,18],[1,14,1,15],[2,14,2,15],[3,14,3,15],[4,14,4,15],[5,14,5,15]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Location / Academy Name:",null,null,{"$f":"IF(ISNA(VLOOKUP(O2,Data!A2:B35,2,FALSE))=TRUE,\"\",VLOOKUP(O2,Data!A2:B35,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Document Period:",1,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Statement Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Document Year:","2018/19"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Statement Amount:"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note: please use positive figures for expenditure"]
["DOC TYPE","ROW NUMBER","DOC DATE","DOCUMENT YEAR","DOCUMENT PERIOD","NOMINAL","ACCOUNT","VALUE","DESCRIPTION"]
[]
[]
[]
["EBGJ",3,{"$f":"IF($O$4=\"\",\"\",$O$4)","v":""},{"$f":"IF($O$5=\"\",\"\",$O$5)","v":"2018/19"},{"$f":"$O$3","v":1},{"$f":"O2&\"4010\"","v":"4010"},{"$f":"LEFT(Data!$AC$45,6)","v":"SLT001"},{"$f":"-$O$6","v":0},{"$f":"IF(H15=\"\",\"\",$O$2&\" Credit Card expense \"&Q15)","v":" Credit Card expense "},null,"Expenditure - Credit Card"]
["EBGJ",4,"","2018/19",1,{"$f":"IF(H15=\"\",\"\",\"EBO\"&\"9521\")","v":"EBO9521"},{"$f":"IF(F16=\"\",\"\",LEFT($O$5,4)&RIGHT($O$5,2)&\"M\"&$O$3)","v":"201819M1"},{"$f":"IF(G16=\"\",\"\",SUM(R57))","v":0},{"$f":"IF(H16=\"\",\"\",$O$2&\" Credit Card expense \"&Q15)","v":" Credit Card expense "},null,null,null,"Nominal Code",null,"Account Code",null,"Net","VAT","Gross","Description","Receipt Attached","Comments"]
["EBGJ",5,"","2018/19",{"$f":"$O$3","v":1},{"$f":"IF(M17=\"\",\"\",$O$2&M17)","v":""},{"$f":"IF(O17=\"\",\"\",O17)","v":""},{"$f":"IF(Q17=\"\",\"\",SUM(Q17))","v":""},{"$f":"IF(T17=\"\",\"\",T17)","v":""},null,null,1,null,{"$f":"IF(M17=\"\",\"\",IF(ISNA(VLOOKUP(M17,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M17,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O17=\"\",\"\",IF(ISNA(VLOOKUP(O17,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O17,Data!U:V,2,FALSE)))","v":""},null,null,{"$f":"IF(Q17=\"\",\"\",SUM(Q17:R17))","v":""}]
["EBGJ",6,"","2018/19",1,{"$f":"IF(M18=\"\",\"\",$O$2&M18)","v":""},{"$f":"IF(O18=\"\",\"\",O18)","v":""},{"$f":"IF(Q18=\"\",\"\",SUM(Q18))","v":""},{"$f":"IF(T18=\"\",\"\",T18)","v":""},null,null,2,null,{"$f":"IF(M18=\"\",\"\",IF(ISNA(VLOOKUP(M18,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M18,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O18=\"\",\"\",IF(ISNA(VLOOKUP(O18,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O18,Data!U:V,2,FALSE)))","v":""},null,null,{"$f":"IF(Q18=\"\",\"\",SUM(Q18:R18))","v":""}]
["EBGJ",7,"","2018/19",1,{"$f":"IF(M19=\"\",\"\",$O$2&M19)","v":""},{"$f":"IF(O19=\"\",\"\",O19)","v":""},{"$f":"IF(Q19=\"\",\"\",SUM(Q19))","v":""},{"$f":"IF(T19=\"\",\"\",T19)","v":""},null,null,3,null,{"$f":"IF(M19=\"\",\"\",IF(ISNA(VLOOKUP(M19,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M19,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O19=\"\",\"\",IF(ISNA(VLOOKUP(O19,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O19,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",8,"","2018/19",1,"","","","",null,null,4,null,{"$f":"IF(M20=\"\",\"\",IF(ISNA(VLOOKUP(M20,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M20,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O20=\"\",\"\",IF(ISNA(VLOOKUP(O20,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O20,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",9,"","2018/19",1,"","","","",null,null,5,null,{"$f":"IF(M21=\"\",\"\",IF(ISNA(VLOOKUP(M21,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M21,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O21=\"\",\"\",IF(ISNA(VLOOKUP(O21,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O21,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",10,"","2018/19",1,"","","","",null,null,6,null,{"$f":"IF(M22=\"\",\"\",IF(ISNA(VLOOKUP(M22,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M22,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O22=\"\",\"\",IF(ISNA(VLOOKUP(O22,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O22,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",11,"","2018/19",1,"","","","",null,null,7,null,{"$f":"IF(M23=\"\",\"\",IF(ISNA(VLOOKUP(M23,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M23,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O23=\"\",\"\",IF(ISNA(VLOOKUP(O23,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O23,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",12,"","2018/19",1,"","","","",null,null,8,null,{"$f":"IF(M24=\"\",\"\",IF(ISNA(VLOOKUP(M24,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M24,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O24=\"\",\"\",IF(ISNA(VLOOKUP(O24,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O24,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",13,"","2018/19",1,"","","","",null,null,9,null,{"$f":"IF(M25=\"\",\"\",IF(ISNA(VLOOKUP(M25,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M25,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O25=\"\",\"\",IF(ISNA(VLOOKUP(O25,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O25,Data!U:V,2,FALSE)))","v":""},null,null,{"$f":"IF(Q25=\"\",\"\",SUM(Q25:R25))","v":""}]
["EBGJ",14,"","2018/19",1,"","","","",null,null,10,null,{"$f":"IF(M26=\"\",\"\",IF(ISNA(VLOOKUP(M26,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M26,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O26=\"\",\"\",IF(ISNA(VLOOKUP(O26,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O26,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",15,"",{"$f":"IF($O$5=\"\",\"\",$O$5)","v":"2018/19"},1,"","","","",null,null,11,null,{"$f":"IF(M27=\"\",\"\",IF(ISNA(VLOOKUP(M27,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M27,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O27=\"\",\"\",IF(ISNA(VLOOKUP(O27,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O27,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",16,"","2018/19",1,"","","","",null,null,12,null,{"$f":"IF(M28=\"\",\"\",IF(ISNA(VLOOKUP(M28,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M28,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O28=\"\",\"\",IF(ISNA(VLOOKUP(O28,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O28,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",17,"","2018/19",1,"","","","",null,null,13,null,{"$f":"IF(M29=\"\",\"\",IF(ISNA(VLOOKUP(M29,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M29,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O29=\"\",\"\",IF(ISNA(VLOOKUP(O29,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O29,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",18,"","2018/19",1,"","","","",null,null,14,null,{"$f":"IF(M30=\"\",\"\",IF(ISNA(VLOOKUP(M30,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M30,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O30=\"\",\"\",IF(ISNA(VLOOKUP(O30,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O30,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",19,"","2018/19",1,"","","","",null,null,15,null,{"$f":"IF(M31=\"\",\"\",IF(ISNA(VLOOKUP(M31,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M31,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O31=\"\",\"\",IF(ISNA(VLOOKUP(O31,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O31,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",20,"","2018/19",1,"","","","",null,null,16,null,{"$f":"IF(M32=\"\",\"\",IF(ISNA(VLOOKUP(M32,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M32,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O32=\"\",\"\",IF(ISNA(VLOOKUP(O32,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O32,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",21,"","2018/19",1,"","","","",null,null,17,null,{"$f":"IF(M33=\"\",\"\",IF(ISNA(VLOOKUP(M33,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M33,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O33=\"\",\"\",IF(ISNA(VLOOKUP(O33,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O33,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",22,"","2018/19",1,"","","","",null,null,18,null,{"$f":"IF(M34=\"\",\"\",IF(ISNA(VLOOKUP(M34,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M34,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O34=\"\",\"\",IF(ISNA(VLOOKUP(O34,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O34,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",23,"","2018/19",1,"","","","",null,null,19,null,{"$f":"IF(M35=\"\",\"\",IF(ISNA(VLOOKUP(M35,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M35,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O35=\"\",\"\",IF(ISNA(VLOOKUP(O35,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O35,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",24,"","2018/19",1,"","","","",null,null,20,null,{"$f":"IF(M36=\"\",\"\",IF(ISNA(VLOOKUP(M36,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M36,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O36=\"\",\"\",IF(ISNA(VLOOKUP(O36,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O36,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",25,"","2018/19",1,"","","","",null,null,21,null,{"$f":"IF(M37=\"\",\"\",IF(ISNA(VLOOKUP(M37,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M37,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O37=\"\",\"\",IF(ISNA(VLOOKUP(O37,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O37,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",26,"","2018/19",1,"","","","",null,null,22,null,{"$f":"IF(M38=\"\",\"\",IF(ISNA(VLOOKUP(M38,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M38,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O38=\"\",\"\",IF(ISNA(VLOOKUP(O38,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O38,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",27,"","2018/19",1,"","","","",null,null,23,null,{"$f":"IF(M39=\"\",\"\",IF(ISNA(VLOOKUP(M39,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M39,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O39=\"\",\"\",IF(ISNA(VLOOKUP(O39,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O39,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",28,"","2018/19",1,"","","","",null,null,24,null,{"$f":"IF(M40=\"\",\"\",IF(ISNA(VLOOKUP(M40,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M40,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O40=\"\",\"\",IF(ISNA(VLOOKUP(O40,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O40,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",29,"","2018/19",1,"","","","",null,null,25,null,{"$f":"IF(M41=\"\",\"\",IF(ISNA(VLOOKUP(M41,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M41,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O41=\"\",\"\",IF(ISNA(VLOOKUP(O41,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O41,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",30,"","2018/19",1,"","","","",null,null,26,null,{"$f":"IF(M42=\"\",\"\",IF(ISNA(VLOOKUP(M42,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M42,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O42=\"\",\"\",IF(ISNA(VLOOKUP(O42,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O42,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",31,"","2018/19",1,"","","","",null,null,27,null,{"$f":"IF(M43=\"\",\"\",IF(ISNA(VLOOKUP(M43,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M43,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O43=\"\",\"\",IF(ISNA(VLOOKUP(O43,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O43,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",32,"","2018/19",1,"","","","",null,null,28,null,{"$f":"IF(M44=\"\",\"\",IF(ISNA(VLOOKUP(M44,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M44,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O44=\"\",\"\",IF(ISNA(VLOOKUP(O44,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O44,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",33,"","2018/19",1,"","","","",null,null,29,null,{"$f":"IF(M45=\"\",\"\",IF(ISNA(VLOOKUP(M45,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M45,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O45=\"\",\"\",IF(ISNA(VLOOKUP(O45,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O45,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",34,"","2018/19",1,"","","","",null,null,30,null,{"$f":"IF(M46=\"\",\"\",IF(ISNA(VLOOKUP(M46,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M46,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O46=\"\",\"\",IF(ISNA(VLOOKUP(O46,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O46,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",35,"","2018/19",1,"","","","",null,null,31,null,{"$f":"IF(M47=\"\",\"\",IF(ISNA(VLOOKUP(M47,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M47,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O47=\"\",\"\",IF(ISNA(VLOOKUP(O47,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O47,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",36,"","2018/19",1,"","","","",null,null,32,null,{"$f":"IF(M48=\"\",\"\",IF(ISNA(VLOOKUP(M48,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M48,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O48=\"\",\"\",IF(ISNA(VLOOKUP(O48,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O48,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",37,"","2018/19",1,"","","","",null,null,33,null,{"$f":"IF(M49=\"\",\"\",IF(ISNA(VLOOKUP(M49,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M49,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O49=\"\",\"\",IF(ISNA(VLOOKUP(O49,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O49,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",38,"","2018/19",1,"","","","",null,null,34,null,{"$f":"IF(M50=\"\",\"\",IF(ISNA(VLOOKUP(M50,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M50,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O50=\"\",\"\",IF(ISNA(VLOOKUP(O50,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O50,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",39,"","2018/19",1,"","","","",null,null,35,null,{"$f":"IF(M51=\"\",\"\",IF(ISNA(VLOOKUP(M51,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M51,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O51=\"\",\"\",IF(ISNA(VLOOKUP(O51,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O51,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",40,"","2018/19",1,"","","","",null,null,36,null,{"$f":"IF(M52=\"\",\"\",IF(ISNA(VLOOKUP(M52,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M52,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O52=\"\",\"\",IF(ISNA(VLOOKUP(O52,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O52,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",41,"","2018/19",1,"","","","",null,null,37,null,{"$f":"IF(M53=\"\",\"\",IF(ISNA(VLOOKUP(M53,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M53,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O53=\"\",\"\",IF(ISNA(VLOOKUP(O53,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O53,Data!U:V,2,FALSE)))","v":""},null,null,{"$f":"IF(Q53=\"\",\"\",SUM(Q53:R53))","v":""}]
["EBGJ",42,"","2018/19",1,"","","","",null,null,38,null,{"$f":"IF(M54=\"\",\"\",IF(ISNA(VLOOKUP(M54,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M54,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O54=\"\",\"\",IF(ISNA(VLOOKUP(O54,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O54,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",43,"","2018/19",1,"","","","",null,null,39,null,{"$f":"IF(M55=\"\",\"\",IF(ISNA(VLOOKUP(M55,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M55,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O55=\"\",\"\",IF(ISNA(VLOOKUP(O55,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O55,Data!U:V,2,FALSE)))","v":""},null,null,""]
["EBGJ",44,"","2018/19",1,"","","","",null,null,40,null,{"$f":"IF(M56=\"\",\"\",IF(ISNA(VLOOKUP(M56,Data!R:S,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(M56,Data!R:S,2,FALSE)))","v":""},null,{"$f":"IF(O56=\"\",\"\",IF(ISNA(VLOOKUP(O56,Data!U:V,2,FALSE))=TRUE,\"Does not exist, please check and re-enter\",VLOOKUP(O56,Data!U:V,2,FALSE)))","v":""},null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q17:Q56)","v":0},{"$f":"SUM(R17:R56)","v":0},{"$f":"SUM(S17:S56)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check:",{"$f":"O6-S57","v":0}]

{"sheet":"Data","index":1,"n_rows":414,"n_cols":32,"rows_kept":414,"cut":false,"hidden":true,"merged":[[0,0,0,1],[0,3,0,5],[0,17,0,18],[0,20,0,21]]}
["Location Codes",null,null,"Period",null,null,null,"Group","Code","Description","Count","Secruity","Approver 1\n£0.00\nto\n£1000.00","Approver 2\n£1000.01\nto\n£10000.00","Approver 3\n£10000.01\nto\n£50,000","Approver 4\n£50000.01\nto\ninfinity",null,"New Nominal",null,null,"New Account",null,null,"New Nominal",null,null,null,null,"New Account"]
[null,null,null,"Fin. Period","Calendar Mth"]
["ACS","Alderman Cogan's Church of England Primary Academy",null,9,"01","September",null,"ADMIN","ADM001","Administration",{"$f":"COUNTIF(I:I,I3)","v":1},"A_ADMIN","Headteacher","Executive Headteacher","FD","CEO",null,1000,"GAG Funding Pupil Lead",null,"ASC001","After School Club",null,"1000 - GAG Funding Pupil Lead",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X3,1),\"\"))","v":0},{"$f":"IF(Y3=1,COUNTIF(Y$3:$Y3,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z3),$Z$3:$Z$274,0)),\"\")","v":"1081 - Pupil Premium"},null,{"$f":"$I5&\" - \"&$J5","v":"ASC001 - After School Club"},1,{"$f":"IF(AD3=1,COUNTIF($AD$3:AD3,1),\"\")","v":1},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE3),$AE$3:$AE$55,0)),\"\")","v":"ASC001 - After School Club"}]
["BBS","Brotherton and Byram Primary Academy",null,10,"02","October",null,"CURR","ART001","Art",{"$f":"COUNTIF(I:I,I4)","v":1},{"$f":"\"A_\"&MID(I4,1,3)","v":"A_ART"},"Headteacher","Executive Headteacher","FD","CEO",null,1001,"Educational Services Grant",null,"BRE001","Breakfast Club",null,"1001 - Educational Services Grant",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X4,1),\"\"))","v":0},{"$f":"IF(Y4=1,COUNTIF(Y$3:$Y4,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z4),$Z$3:$Z$274,0)),\"\")","v":"1083 - Start Up Grant (A)"},null,{"$f":"$I8&\" - \"&$J8","v":"BRE001 - Breakfast Club"},1,{"$f":"IF(AD4=1,COUNTIF($AD$3:AD4,1),\"\")","v":2},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE4),$AE$3:$AE$55,0)),\"\")","v":"BRE001 - Breakfast Club"}]
["CAM","Camblesforth Community Primary Academy",null,11,"03","November",null,"WAC","ASC001","After School Club",{"$f":"COUNTIF(I:I,I5)","v":1},"A_WAC","Headteacher","Executive Headteacher","FD","CEO",null,1002,"High Needs Funding",null,"CAT001","Catering",null,"1002 - High Needs Funding",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X5,1),\"\"))","v":0},{"$f":"IF(Y5=1,COUNTIF(Y$3:$Y5,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z5),$Z$3:$Z$274,0)),\"\")","v":"1101 - Breakfast Club"},null,{"$f":"$I11&\" - \"&$J11","v":"CAT001 - Catering"},{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,AC3,1),\"\"))","v":0},{"$f":"IF(AD5=1,COUNTIF($AD$3:AD5,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE5),$AE$3:$AE$55,0)),\"\")","v":"CPD001 - Staff Development"}]
["EAS","Easington CE Primary Academy",null,12,"04","December",null,"CURR","ASS001","Assessment",{"$f":"COUNTIF(I:I,I6)","v":1},"A_WAC","Headteacher","Executive Headteacher","FD","CEO",null,1004,"Infant Class Size Funding",null,"CPD001","Staff Development",null,"1004 - Infant Class Size Funding",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X6,1),\"\"))","v":0},{"$f":"IF(Y6=1,COUNTIF(Y$3:$Y6,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z6),$Z$3:$Z$274,0)),\"\")","v":"1115 - Staff Consultancy / Recharges"},null,"CPD001 - Staff Development",1,{"$f":"IF(AD6=1,COUNTIF($AD$3:AD6,1),\"\")","v":3},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE6),$AE$3:$AE$55,0)),\"\")","v":"EMS001 - Enhanced Mainstream School"}]
["EBO","Ebor Academy Trust",null,1,"05","January",null,"CURR","BEH001","Behaviour Support",{"$f":"COUNTIF(I:I,I7)","v":1},"A_WAC","Headteacher","Executive Headteacher","FD","CEO",null,1005,"Free School Meal Funding",null,"EMS001","Enhanced Mainstream School",null,"1005 - Free School Meals",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X7,1),\"\"))","v":0},{"$f":"IF(Y7=1,COUNTIF(Y$3:$Y7,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z7),$Z$3:$Z$274,0)),\"\")","v":"1140 - Uniforms Income"},null,{"$f":"$I16&\" - \"&$J16","v":"EMS001 - Enhanced Mainstream School"},1,{"$f":"IF(AD7=1,COUNTIF($AD$3:AD7,1),\"\")","v":4},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE7),$AE$3:$AE$55,0)),\"\")","v":"KS1001 - KS1"}]
["FIS","Filey CoE Nursery and Infants Academy",null,2,"06","February",null,"WAC","BRE001","Breakfast Club",1,"A_WAC","Headteacher","Executive Headteacher","FD","CEO",null,1006,"RPA Contribution",null,"EYR001","Early Years",null,"1006 - RPA Contribution",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X8,1),\"\"))","v":0},{"$f":"IF(Y8=1,COUNTIF(Y$3:$Y8,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z8),$Z$3:$Z$274,0)),\"\")","v":"1150 - Sponsor Income"},null,{"$f":"$I19&\" - \"&$J19","v":"EYR001 - Early Years"},{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,AC4,1),\"\"))","v":0},{"$f":"IF(AD8=1,COUNTIF($AD$3:AD8,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE8),$AE$3:$AE$55,0)),\"\")","v":"KS2001 - Lower KS2"}]
["FLY","Ebor Academy Filey",null,3,"07","March",null,"CURR","BUS001","Business Studies",1,{"$f":"\"A_\"&MID(I9,1,3)","v":"A_BUS"},"Headteacher","Executive Headteacher","FD","CEO",null,1007,"Minimum Funding Guarantee",null,"KS1001","KS1",null,"1007 - Minimum Funding Guarantee",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X9,1),\"\"))","v":0},{"$f":"IF(Y9=1,COUNTIF(Y$3:$Y9,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z9),$Z$3:$Z$274,0)),\"\")","v":"1160 - School Direct"},null,{"$f":"$I26&\" - \"&$J26","v":"KS1001 - KS1"},1,{"$f":"IF(AD9=1,COUNTIF($AD$3:AD9,1),\"\")","v":5},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE9),$AE$3:$AE$55,0)),\"\")","v":"ICT001 - IT"}]
["HMO","Hob Moor Oaks Academy",null,4,"08","April",null,"CAP","CAP001","Capital",1,"A_CAP","Headteacher","Executive Headteacher","FD","CEO",null,1008,"Lump Sum Funding",null,"KS2001","Lower KS2",null,"1008 - Lump Sum Funding",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X10,1),\"\"))","v":0},{"$f":"IF(Y10=1,COUNTIF(Y$3:$Y10,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z10),$Z$3:$Z$274,0)),\"\")","v":"3401 - Business Rates"},null,{"$f":"$I27&\" - \"&$J27","v":"KS2001 - Lower KS2"},1,{"$f":"IF(AD10=1,COUNTIF($AD$3:AD10,1),\"\")","v":6},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE10),$AE$3:$AE$55,0)),\"\")","v":"NUR001 - Nursery / Preschool"}]
["HMS","Hob Moor Primary Academy",null,5,"09","May",null,"CAT","CAT001","Catering",1,"A_CAT","Headteacher","Executive Headteacher","FD","CEO",null,1051,"PE Grant",null,"KS2002","Upper KS2",null,"1051 - PE Grant",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X11,1),\"\"))","v":0},{"$f":"IF(Y11=1,COUNTIF(Y$3:$Y11,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z11),$Z$3:$Z$274,0)),\"\")","v":"3402 - Rent"},null,{"$f":"$I28&\" - \"&$J28","v":"KS2002 - Upper KS2"},{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,AC5,1),\"\"))","v":0},{"$f":"IF(AD11=1,COUNTIF($AD$3:AD11,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE11),$AE$3:$AE$55,0)),\"\")","v":"PPR001 - Pupil Premium"}]
["HRS","Haxby Road Primary Academy",null,6,"10","June",null,"CURR","COO001","Cook School",1,{"$f":"\"A_\"&MID(I12,1,3)","v":"A_COO"},"Headteacher","Executive Headteacher","FD","CEO",null,1052,"School Improvement",null,"ICT001","Information Technology",null,"1052 - School Improvement",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X12,1),\"\"))","v":0},{"$f":"IF(Y12=1,COUNTIF(Y$3:$Y12,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z12),$Z$3:$Z$274,0)),\"\")","v":"3600 - Security Patrol"},null,{"$f":"$I25&\" - \"&$J25","v":"ICT001 - IT"},1,{"$f":"IF(AD12=1,COUNTIF($AD$3:AD12,1),\"\")","v":7},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE12),$AE$3:$AE$55,0)),\"\")","v":"SCH001 - Main School"}]
["LAK","Lakeside Primary School",null,7,"11","July",null,"CURR","DAT001","Design and Technology",1,"A_DAT","Headteacher","Executive Headteacher","FD","CEO",null,1081,"Pupil Premium",null,"NQT001","Newly Qualified Teachers",null,"1081 - Pupil Premium",1,{"$f":"IF(Y13=1,COUNTIF(Y$3:$Y13,1),\"\")","v":1},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z13),$Z$3:$Z$274,0)),\"\")","v":"4010 - Capitation"},null,{"$f":"$I35&\" - \"&$J35","v":"NQT001 - Newly Qualified Teachers"},{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,AC6,1),\"\"))","v":0},{"$f":"IF(AD13=1,COUNTIF($AD$3:AD13,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE13),$AE$3:$AE$55,0)),\"\")","v":"SDW001 - Schools Direct"}]
["MAR","Marfleet Primary School",null,8,"12","August",null,"CURR","DRA001","Drama",1,"A_DRA","Headteacher","Executive Headteacher","FD","CEO",null,1083,"Start Up Grant (A)",null,"NUR001","Nursery / Preschool (3&4 Year Olds)",null,"1083 - Start Up Grant (A)",1,{"$f":"IF(Y14=1,COUNTIF(Y$3:$Y14,1),\"\")","v":2},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z14),$Z$3:$Z$274,0)),\"\")","v":"4150 - Examination Fees"},null,{"$f":"$I38&\" - \"&$J38","v":"NUR001 - Nursery / Preschool"},1,{"$f":"IF(AD14=1,COUNTIF($AD$3:AD14,1),\"\")","v":8},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE14),$AE$3:$AE$55,0)),\"\")","v":"TRP001 - School Trips"}]
["OSB","Osbaldwick Primary School",null,null,null,null,null,"CURR","DUK001","Duke of Edinburgh Award Scheme",1,"A_DUK","Headteacher","Executive Headteacher","FD","CEO",null,1084,"Start Up Grant (B)",null,"PEG001","PE Grant",null,"1084 - Start Up Grant (B)",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X13,1),\"\"))","v":0},{"$f":"IF(Y15=1,COUNTIF(Y$3:$Y15,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z15),$Z$3:$Z$274,0)),\"\")","v":"5013 - Catering (School Meals)"},null,"PEG001 - PE Grant",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,AC15,1),\"\"))","v":0},{"$f":"IF(AD15=1,COUNTIF($AD$3:AD15,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE15),$AE$3:$AE$55,0)),\"\")","v":"ENG001 - English"}]
["PAT","Patrington CE Primary Academy",null,"Date","Fin. Period","Calendar Mth",null,"CURR","EMS001","Enhanced Mainstream School",1,"A_EMS","Headteacher","Executive Headteacher","FD","CEO",null,1087,"Other ESFA Grants",null,"PPR001","Pupil Premium",null,"1087 - Other ESFA Grants",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X16,1),\"\"))","v":0},{"$f":"IF(Y16=1,COUNTIF(Y$3:$Y16,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z16),$Z$3:$Z$274,0)),\"\")","v":"5015 - Catering Supplies"},null,{"$f":"$I42&\" - \"&$J42","v":"PPR001 - Pupil Premium"},1,{"$f":"IF(AD16=1,COUNTIF($AD$3:AD16,1),\"\")","v":9},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE16),$AE$3:$AE$55,0)),\"\")","v":"HIS001 - History"}]
["PGS","Park Grove Primary Academy",null,"2018-07-31",{"$f":"VLOOKUP(F17,$D$3:$E$14,2,FALSE)","v":"11"},{"$f":"MONTH(D17)","v":7},null,"CURR","ENG001","English",1,"A_ENG","Headteacher","Executive Headteacher","FD","CEO",null,1095,"SEN",null,"PRE001","Premises",null,"1095 - SEN",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X14,1),\"\"))","v":0},{"$f":"IF(Y17=1,COUNTIF(Y$3:$Y17,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z17),$Z$3:$Z$274,0)),\"\")","v":"5105 - Mobile Communications"},null,{"$f":"$I41&\" - \"&$J41","v":"PRE001 - Premises"},{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,AC7,1),\"\"))","v":0},{"$f":"IF(AD17=1,COUNTIF($AD$3:AD17,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE17),$AE$3:$AE$55,0)),\"\")","v":"MAT001 - Mathematics"}]
["RWS","Robert Wilkinson Primary Academy",null,"2018-08-01",{"$f":"VLOOKUP(F18,$D$3:$E$14,2,FALSE)","v":"12"},{"$f":"MONTH(D18)","v":8},null,"CURR","ERP001","ERP",1,"A_ERP","Headteacher","Executive Headteacher","FD","CEO",null,1097,"Other LA Grants",null,"SCH001","Main School",null,"1097 - Other LA Grants",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X15,1),\"\"))","v":0},{"$f":"IF(Y18=1,COUNTIF(Y$3:$Y18,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z18),$Z$3:$Z$274,0)),\"\")","v":"5112 - IT Hardware"},null,{"$f":"$I44&\" - \"&$J44","v":"SCH001 - Main School"},1,{"$f":"IF(AD18=1,COUNTIF($AD$3:AD18,1),\"\")","v":10},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE18),$AE$3:$AE$55,0)),\"\")","v":""}]
["SHS","Staynor Hall Community Primary Academy",null,"2018-08-02",{"$f":"VLOOKUP(F19,$D$3:$E$14,2,FALSE)","v":"12"},{"$f":"MONTH(D19)","v":8},null,"CURR","EYR001","Early Years",1,"A_EYR","Headteacher","Executive Headteacher","FD","CEO",null,1100,"Donations and / or Voluntary Funds",null,"SDW001","Schools Direct",null,"1100 - Donations and / or Voluntary Funds",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X17,1),\"\"))","v":0},{"$f":"IF(Y19=1,COUNTIF(Y$3:$Y19,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z19),$Z$3:$Z$274,0)),\"\")","v":"5113 - IT Software and Licences"},null,{"$f":"$I47&\" - \"&$J47","v":"SDW001 - Schools Direct"},1,{"$f":"IF(AD19=1,COUNTIF($AD$3:AD19,1),\"\")","v":11},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE19),$AE$3:$AE$55,0)),\"\")","v":""}]
["SIG","Sigglesthorne CofE Primary Academy",null,"2018-08-03",{"$f":"VLOOKUP(F20,$D$3:$E$14,2,FALSE)","v":"12"},{"$f":"MONTH(D20)","v":8},null,"CURR","FOT001","Food Technology",1,"A_FOT","Headteacher","Executive Headteacher","FD","CEO",null,1101,"Breakfast Club",null,"SEN001","SEN",null,"1101 - Breakfast Club",1,{"$f":"IF(Y20=1,COUNTIF(Y$3:$Y20,1),\"\")","v":3},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z20),$Z$3:$Z$274,0)),\"\")","v":"5206 - Stationery"},null,{"$f":"$I48&\" - \"&$J48","v":"SEN001 - SEN"},{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,AC8,1),\"\"))","v":0},{"$f":"IF(AD20=1,COUNTIF($AD$3:AD20,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE20),$AE$3:$AE$55,0)),\"\")","v":""}]
["SPR","Sproatley Endowed Chuch of England Academy",null,"2018-08-04",{"$f":"VLOOKUP(F21,$D$3:$E$14,2,FALSE)","v":"12"},{"$f":"MONTH(D21)","v":8},null,"CURR","GEO001","Geography",1,"A_GEO","Headteacher","Executive Headteacher","FD","CEO",null,1102,"After School Club",null,"NLC001","Yr7 Numeracy and Literacy Catchup",null,"1102 - After School Club",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X19,1),\"\"))","v":0},{"$f":"IF(Y21=1,COUNTIF(Y$3:$Y21,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z21),$Z$3:$Z$274,0)),\"\")","v":"5425 - Payroll"},null,{"$f":"$I36&\" - \"&$J36","v":"NLC001 - Yr7 Numeracy and Literacy Catchup"},{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,AC32,1),\"\"))","v":0},{"$f":"IF(AD21=1,COUNTIF($AD$3:AD21,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE21),$AE$3:$AE$55,0)),\"\")","v":""}]
["TOC","Tockwith Church of England Primary Academy",null,"2018-08-05",{"$f":"VLOOKUP(F22,$D$3:$E$14,2,FALSE)","v":"12"},{"$f":"MONTH(D22)","v":8},null,"CURR","HIS001","History",1,"A_HIS","Headteacher","Executive Headteacher","FD","CEO",null,1103,"Funds Inherited on Conversion",null,"SFD001","School Fund (Legacy)",null,"1103 - Funds Inherited on Conversion",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X20,1),\"\"))","v":0},{"$f":"IF(Y22=1,COUNTIF(Y$3:$Y22,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z22),$Z$3:$Z$274,0)),\"\")","v":"5427 - Services to Schools"},null,{"$f":"$I49&\" - \"&$J49","v":"SFD001 - School Fund (Legacy)"},{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,AC33,1),\"\"))","v":0},{"$f":"IF(AD22=1,COUNTIF($AD$3:AD22,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE22),$AE$3:$AE$55,0)),\"\")","v":""}]
["TAD","Tadcaster Primary Academy",null,"2018-08-06","12",8,null,"CURR","HUM001","Humanities",1,"A_HUM","Headteacher","Executive Headteacher","FD","CEO",null,1104,"Nursery / Preschool",null,"STS001","School To School Support",null,"1104 - Nursery / Preschool",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X21,1),\"\"))","v":0},{"$f":"IF(Y23=1,COUNTIF(Y$3:$Y23,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z23),$Z$3:$Z$274,0)),\"\")","v":"5500 - Top Slice For Ebor Centralised Services"},null,{"$f":"$I52&\" - \"&$J52","v":"STS001 - School To School Support"},{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,AC34,1),\"\"))","v":0},{"$f":"IF(AD23=1,COUNTIF($AD$3:AD23,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE23),$AE$3:$AE$55,0)),\"\")","v":""}]
["RIS","Riston Primary Academy",null,"2018-08-07","12",8,null,"CURR","HSC001","Health & Social Care",1,"A_HSC","Headteacher","Executive Headteacher","FD","CEO",null,1105,"Lettings and Room Hire",null,"TNY001","Tiny Steps (2 Year Olds)",null,"1105 - Lettings and Room Hire",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X23,1),\"\"))","v":0},{"$f":"IF(Y24=1,COUNTIF(Y$3:$Y24,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z24),$Z$3:$Z$274,0)),\"\")","v":"5700 - Training Course Fees"},null,{"$f":"$I53&\" - \"&$J53","v":"TNY001 - Tiny Steps"},{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,AC35,1),\"\"))","v":0},{"$f":"IF(AD24=1,COUNTIF($AD$3:AD24,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE24),$AE$3:$AE$55,0)),\"\")","v":""}]
["BRA","Braeburn Primary Academy",null,"2018-08-08","12",8,null,"IT","ICT001","IT",1,"A_ICT","Headteacher","Executive Headteacher","FD","CEO",null,1106,"Transport Income",null,"TRP001","School Trips",null,"1106 - Transport Income",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X24,1),\"\"))","v":0},{"$f":"IF(Y25=1,COUNTIF(Y$3:$Y25,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z25),$Z$3:$Z$274,0)),\"\")","v":"5701 - Training Course Hospitality"},null,{"$f":"$I55&\" - \"&$J55","v":"TRP001 - School Trips"},1,{"$f":"IF(AD25=1,COUNTIF($AD$3:AD25,1),\"\")","v":12},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE25),$AE$3:$AE$55,0)),\"\")","v":""}]
[null,null,null,"2018-08-09","12",8,null,"CURR","KS1001","KS1",1,{"$f":"\"A_\"&MID(I26,1,3)","v":"A_KS1"},"Headteacher","Executive Headteacher","FD","CEO",null,1108,"Sales of Other Goods and Services",null,"ART001","Art",null,"1108 - Sales of Other Goods and Services",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X25,1),\"\"))","v":0},{"$f":"IF(Y26=1,COUNTIF(Y$3:$Y26,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z26),$Z$3:$Z$274,0)),\"\")","v":"5900 - External Audit"},null,"ART001 - Art",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,AC12,1),\"\"))","v":0},{"$f":"IF(AD26=1,COUNTIF($AD$3:AD26,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE26),$AE$3:$AE$55,0)),\"\")","v":""}]
[null,null,null,"2018-08-10","12",8,null,"CURR","KS2001","Lower KS2",1,"A_KS2","Headteacher","Executive Headteacher","FD","CEO",null,1109,"Music Services",null,"ASS001","Assessment",null,"1109 - Music Services",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X26,1),\"\"))","v":0},{"$f":"IF(Y27=1,COUNTIF(Y$3:$Y27,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z27),$Z$3:$Z$274,0)),\"\")","v":"6100 - Staff Travel"},null,"ASS001 - Assessment",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,AC9,1),\"\"))","v":0},{"$f":"IF(AD27=1,COUNTIF($AD$3:AD27,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE27),$AE$3:$AE$55,0)),\"\")","v":""}]
[null,null,null,"2018-08-11","12",8,null,"CURR","KS2002","Upper KS2",1,"A_KS2","Headteacher","Executive Headteacher","FD","CEO",null,1112,"Catering Income",null,"DAT001","Design and Technology",null,"1112 - Catering",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X27,1),\"\"))","v":0},{"$f":"IF(Y28=1,COUNTIF(Y$3:$Y28,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z28),$Z$3:$Z$274,0)),\"\")","v":"6101 - Staff Accommodation"},null,"DAT001 - Design and Technology",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,AC10,1),\"\"))","v":0},{"$f":"IF(AD28=1,COUNTIF($AD$3:AD28,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE28),$AE$3:$AE$55,0)),\"\")","v":""}]
[null,null,null,"2018-08-12","12",8,null,"CURR","LIB001","Library",1,"A_LIB","Headteacher","Executive Headteacher","FD","CEO",null,1114,"Trip Income",null,"DRA001","Drama",null,"1114 - Trip Income",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X28,1),\"\"))","v":0},{"$f":"IF(Y29=1,COUNTIF(Y$3:$Y29,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z29),$Z$3:$Z$274,0)),\"\")","v":"6102 - Staff Subsistence"},null,"DRA001 - Drama",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,AC11,1),\"\"))","v":0},{"$f":"IF(AD29=1,COUNTIF($AD$3:AD29,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE29),$AE$3:$AE$55,0)),\"\")","v":""}]
[null,null,null,"2018-08-13","12",8,null,"CURR","LIT001","Literacy",1,"A_LIT","Headteacher","Executive Headteacher","FD","CEO",null,1115,"Staff Consultancy / Recharges",null,"DUK001","Duke of Edinburgh Award Scheme",null,"1115 - Staff Consultancy / Recharges",1,{"$f":"IF(Y30=1,COUNTIF(Y$3:$Y30,1),\"\")","v":4},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z30),$Z$3:$Z$274,0)),\"\")","v":"6500 - Trips Travel Costs"},null,"DUK001 - Duke of Edinburgh Award Scheme",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,AC37,1),\"\"))","v":0},{"$f":"IF(AD30=1,COUNTIF($AD$3:AD30,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE30),$AE$3:$AE$55,0)),\"\")","v":""}]
[null,null,null,"2018-08-14","12",8,null,"CURR","MAT001","Mathematics",1,"A_MAT","Headteacher","Executive Headteacher","FD","CEO",null,1116,"Training Course Income",null,"ENG001","English",null,"1116 - Training Course Fees",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X29,1),\"\"))","v":0},{"$f":"IF(Y31=1,COUNTIF(Y$3:$Y31,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z31),$Z$3:$Z$274,0)),\"\")","v":"6520 - Trips Accommodation and / or Entrance"},null,"ENG001 - English",1,{"$f":"IF(AD31=1,COUNTIF($AD$3:AD31,1),\"\")","v":13},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE31),$AE$3:$AE$55,0)),\"\")","v":""}]
[null,null,null,"2018-08-15","12",8,null,"CURR","MFL001","Modern Foreign Languages",1,"A_MFL","Headteacher","Executive Headteacher","FD","CEO",null,1126,"Yr7 Numeracy and Literacy Catchup",null,"FOT001","Food Technology",null,"1126 - Yr7 Numeracy & Literacy Catchup",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X30,1),\"\"))","v":0},{"$f":"IF(Y32=1,COUNTIF(Y$3:$Y32,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z32),$Z$3:$Z$274,0)),\"\")","v":""},null,{"$f":"$I20&\" - \"&$J20","v":"FOT001 - Food Technology"},{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,AC38,1),\"\"))","v":0},{"$f":"IF(AD32=1,COUNTIF($AD$3:AD32,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE32),$AE$3:$AE$55,0)),\"\")","v":""}]
[null,null,null,"2018-08-16","12",8,null,"MISC","MSC001","Miscellaneous",1,"A_MISC","Headteacher","Executive Headteacher","FD","CEO",null,1127,"Department / Subject Income",null,"GEO001","Geography",null,"1127 - Department / Subject Income",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X31,1),\"\"))","v":0},{"$f":"IF(Y33=1,COUNTIF(Y$3:$Y33,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z33),$Z$3:$Z$274,0)),\"\")","v":""},null,{"$f":"$I21&\" - \"&$J21","v":"GEO001 - Geography"},{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,AC39,1),\"\"))","v":0},{"$f":"IF(AD33=1,COUNTIF($AD$3:AD33,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE33),$AE$3:$AE$55,0)),\"\")","v":""}]
[null,null,null,"2018-08-17","12",8,null,"CURR","MUS001","Music",1,{"$f":"\"A_\"&MID(I34,1,3)","v":"A_MUS"},"Headteacher","Executive Headteacher","FD","CEO",null,1140,"School Uniform Income",null,"HIS001","History",null,"1140 - Uniforms Income",1,{"$f":"IF(Y34=1,COUNTIF(Y$3:$Y34,1),\"\")","v":5},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z34),$Z$3:$Z$274,0)),\"\")","v":""},null,{"$f":"$I22&\" - \"&$J22","v":"HIS001 - History"},1,{"$f":"IF(AD34=1,COUNTIF($AD$3:AD34,1),\"\")","v":14},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE34),$AE$3:$AE$55,0)),\"\")","v":""}]
[null,null,null,"2018-08-18","12",8,null,"CPD","NQT001","Newly Qualified Teachers",1,"A_CPD","Headteacher","Executive Headteacher","FD","CEO",null,1150,"Sponsor Income",null,"HUM001","Humanities",null,"1150 - Sponsor Income",1,{"$f":"IF(Y35=1,COUNTIF(Y$3:$Y35,1),\"\")","v":6},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z35),$Z$3:$Z$274,0)),\"\")","v":""},null,{"$f":"$I23&\" - \"&$J23","v":"HUM001 - Humanities"},{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,AC40,1),\"\"))","v":0},{"$f":"IF(AD35=1,COUNTIF($AD$3:AD35,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE35),$AE$3:$AE$55,0)),\"\")","v":""}]
[null,null,null,"2018-08-19","12",8,null,"CURR","NLC001","Yr7 Numeracy and Literacy Catchup",1,"A_CPD","Headteacher","Executive Headteacher","FD","CEO",null,1160,"School Direct",null,"ITB001","Information Technology and Business",null,"1160 - School Direct",1,{"$f":"IF(Y36=1,COUNTIF(Y$3:$Y36,1),\"\")","v":7},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z36),$Z$3:$Z$274,0)),\"\")","v":""},null,"ITB001 - Information Technology and Business",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,AC13,1),\"\"))","v":0},{"$f":"IF(AD36=1,COUNTIF($AD$3:AD36,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE36),$AE$3:$AE$55,0)),\"\")","v":""}]
["Credit Card Numbers",null,null,"2018-08-20","12",8,null,"CURR","NUM001","Numeracy",1,{"$f":"\"A_\"&MID(I37,1,3)","v":"A_NUM"},"Headteacher","Executive Headteacher","FD","CEO",null,1165,"Other Grants",null,"LIB001","Library",null,"1165 - Other Grants",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X32,1),\"\"))","v":0},{"$f":"IF(Y37=1,COUNTIF(Y$3:$Y37,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z37),$Z$3:$Z$274,0)),\"\")","v":""},null,{"$f":"$I29&\" - \"&$J29","v":"LIB001 - Library"},{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,AC21,1),\"\"))","v":0},{"$f":"IF(AD37=1,COUNTIF($AD$3:AD37,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE37),$AE$3:$AE$55,0)),\"\")","v":""}]
["ACS","ACS001",null,"2018-08-21","12",8,null,"CURR","NUR001","Nursery / Preschool",1,{"$f":"\"A_\"&MID(I38,1,3)","v":"A_NUR"},"Headteacher","Executive Headteacher","FD","CEO",null,1170,"School to School Support",null,"MAT001","Mathematics",null,"1170 - School to School Support",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X33,1),\"\"))","v":0},{"$f":"IF(Y38=1,COUNTIF(Y$3:$Y38,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z38),$Z$3:$Z$274,0)),\"\")","v":""},null,{"$f":"$I31&\" - \"&$J31","v":"MAT001 - Mathematics"},1,{"$f":"IF(AD38=1,COUNTIF($AD$3:AD38,1),\"\")","v":15},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE38),$AE$3:$AE$55,0)),\"\")","v":""}]
["BBS","BBS001",null,"2018-08-22","12",8,null,"CURR","PAS001","Pastoral",{"$f":"COUNTIF(I:I,I39)","v":1},{"$f":"\"A_\"&MID(I39,1,3)","v":"A_PAS"},"Headteacher","Executive Headteacher","FD","CEO",null,1200,"Bank Interest",null,"MFL001","Modern Foreign Languages",null,"1200 - Bank Interest",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X34,1),\"\"))","v":0},{"$f":"IF(Y39=1,COUNTIF(Y$3:$Y39,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z39),$Z$3:$Z$274,0)),\"\")","v":""},null,{"$f":"$I32&\" - \"&$J32","v":"MFL001 - Modern Foreign Languages"},{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,AC14,1),\"\"))","v":0},{"$f":"IF(AD39=1,COUNTIF($AD$3:AD39,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE39),$AE$3:$AE$55,0)),\"\")","v":""}]
["CAM","CAM001",null,"2018-08-23","12",8,null,"CURR","PHY001","Physical Education",1,{"$f":"\"A_\"&MID(I40,1,3)","v":"A_PHY"},"Premises Manager","FD","FD","CEO",null,2000,"Teachers - Normal Pay",null,"MUS001","Music",null,"2000 - Teachers - Normal Pay",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X35,1),\"\"))","v":0},{"$f":"IF(Y40=1,COUNTIF(Y$3:$Y40,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z40),$Z$3:$Z$274,0)),\"\")","v":""},null,{"$f":"$I34&\" - \"&$J34","v":"MUS001 - Music"},{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,AC41,1),\"\"))","v":0},{"$f":"IF(AD40=1,COUNTIF($AD$3:AD40,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE40),$AE$3:$AE$55,0)),\"\")","v":""}]
["EAS","EAS001",null,"2018-08-24","12",8,null,"PREM","PRE001","Premises",1,"A_PREM","Headteacher","Executive Headteacher","FD","CEO",null,2001,"Teachers - Supply Teacher Pay",null,"PAS001","Pastoral",null,"2001 - Teachers - Supply Teacher Pay",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X36,1),\"\"))","v":0},{"$f":"IF(Y41=1,COUNTIF(Y$3:$Y41,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z41),$Z$3:$Z$274,0)),\"\")","v":""},null,{"$f":"$I39&\" - \"&$J39","v":"PAS001 - Pastoral"},{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,AC42,1),\"\"))","v":0},{"$f":"IF(AD41=1,COUNTIF($AD$3:AD41,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE41),$AE$3:$AE$55,0)),\"\")","v":""}]
["EBO","EBO001",null,"2018-08-25","12",8,null,"CURR","PPR001","Pupil Premium",1,{"$f":"\"A_\"&MID(I42,1,3)","v":"A_PPR"},"Headteacher","Executive Headteacher","FD","CEO",null,2002,"Teachers - Holiday Pay",null,"PHY001","Physical Education",null,"2002 - Teachers - Holiday Pay",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X38,1),\"\"))","v":0},{"$f":"IF(Y42=1,COUNTIF(Y$3:$Y42,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z42),$Z$3:$Z$274,0)),\"\")","v":""},null,{"$f":"$I40&\" - \"&$J40","v":"PHY001 - Physical Education"},{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,AC17,1),\"\"))","v":0},{"$f":"IF(AD42=1,COUNTIF($AD$3:AD42,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE42),$AE$3:$AE$55,0)),\"\")","v":""}]
["FIS","FIS001",null,"2018-08-26","12",8,null,"CURR","REG001","Religious Education",1,{"$f":"\"A_\"&MID(I43,1,3)","v":"A_REG"},"Headteacher","Executive Headteacher","FD","CEO",null,2003,"Teachers - ET Teachers Pension ER",null,"REG001","Religious Education",null,"2003 - Teachers - ET Teachers Pension ER",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X39,1),\"\"))","v":0},{"$f":"IF(Y43=1,COUNTIF(Y$3:$Y43,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z43),$Z$3:$Z$274,0)),\"\")","v":""},null,{"$f":"$I43&\" - \"&$J43","v":"REG001 - Religious Education"},{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,AC16,1),\"\"))","v":0},{"$f":"IF(AD43=1,COUNTIF($AD$3:AD43,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE43),$AE$3:$AE$55,0)),\"\")","v":""}]
["FLY","FLY001",null,"2018-08-27","12",8,null,"MISC","SCH001","Main School",1,"A_MISC","Headteacher","Executive Headteacher","FD","CEO",null,2004,"Teachers - Childcare Vouchers",null,"SCI001","Science",null,"2004 - Teachers - Childcare Vouchers",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X40,1),\"\"))","v":0},{"$f":"IF(Y44=1,COUNTIF(Y$3:$Y44,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z44),$Z$3:$Z$274,0)),\"\")","v":""},null,{"$f":"$I45&\" - \"&$J45","v":"SCI001 - Science"},{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,AC43,1),\"\"))","v":0},{"$f":"IF(AD44=1,COUNTIF($AD$3:AD44,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE44),$AE$3:$AE$55,0)),\"\")","v":""}]
["HMO","HMO001",null,"2018-08-28","12",8,null,"CURR","SCI001","Science",1,{"$f":"\"A_\"&MID(I45,1,3)","v":"A_SCI"},"Headteacher","Executive Headteacher","FD","CEO",null,2005,"Teachers - Employers NI",null,"SLT001","Senior Leadership Team",null,"2005 - Teachers - Employers NI",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X41,1),\"\"))","v":0},{"$f":"IF(Y45=1,COUNTIF(Y$3:$Y45,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z45),$Z$3:$Z$274,0)),\"\")","v":""},null,{"$f":"$I50&\" - \"&$J50","v":"SLT001 - Senior Leadership Team"},{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,AC18,1),\"\"))","v":0},{"$f":"IF(AD45=1,COUNTIF($AD$3:AD45,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE45),$AE$3:$AE$55,0)),\"\")","v":""}]
["HMS","HMS001",null,"2018-08-29","12",8,null,"CAT","SCM001","School Meals",1,{"$f":"\"A_\"&MID(I46,1,3)","v":"A_SCM"},"Headteacher","Executive Headteacher","FD","CEO",null,2006,"Teachers - Living Wage",null,"WRL001","Work Related Learning",null,"2006 - Teachers - Living Wage",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X42,1),\"\"))","v":0},{"$f":"IF(Y46=1,COUNTIF(Y$3:$Y46,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z46),$Z$3:$Z$274,0)),\"\")","v":""},null,{"$f":"$I54&\" - \"&$J54","v":"WRL001 - Work Related Learning"},{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,AC44,1),\"\"))","v":0},{"$f":"IF(AD46=1,COUNTIF($AD$3:AD46,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE46),$AE$3:$AE$55,0)),\"\")","v":""}]
["HRS","HRS001",null,"2018-08-30","12",8,null,"CPD","SDW001","Schools Direct",1,"A_CPD","Headteacher","Executive Headteacher","FD","CEO",null,2007,"Teachers - Monetary diff",null,null,null,null,"2007 - Teachers - Monetary diff",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X43,1),\"\"))","v":0},{"$f":"IF(Y47=1,COUNTIF(Y$3:$Y47,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z47),$Z$3:$Z$274,0)),\"\")","v":""},null,null,0,{"$f":"IF(AD47=1,COUNTIF($AD$3:AD47,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE47),$AE$3:$AE$55,0)),\"\")","v":""}]
["LAK","LAK001",null,"2018-08-31","12",8,null,"CURR","SEN001","SEN",1,{"$f":"\"A_\"&MID(I48,1,3)","v":"A_SEN"},"Headteacher","Executive Headteacher","FD","CEO",null,2008,"Teachers - Additional Hours",null,null,null,null,"2008 - Teachers - Additional Hours",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X44,1),\"\"))","v":0},{"$f":"IF(Y48=1,COUNTIF(Y$3:$Y48,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z48),$Z$3:$Z$274,0)),\"\")","v":""},null,null,0,{"$f":"IF(AD48=1,COUNTIF($AD$3:AD48,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE48),$AE$3:$AE$55,0)),\"\")","v":""}]
["MAR","MAR001",null,"2018-09-01",{"$f":"VLOOKUP(F49,$D$3:$E$14,2,FALSE)","v":"01"},{"$f":"MONTH(D49)","v":9},null,"OTHER","SFD001","School Fund (Legacy)",1,{"$f":"\"A_\"&MID(I49,1,3)","v":"A_SFD"},"Headteacher","Executive Headteacher","FD","CEO",null,2009,"Teachers - Casual Holiday Pay",null,null,null,null,"2009 - Teachers - Casual Holiday Pay",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X45,1),\"\"))","v":0},{"$f":"IF(Y49=1,COUNTIF(Y$3:$Y49,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z49),$Z$3:$Z$274,0)),\"\")","v":""},null,null,0,{"$f":"IF(AD49=1,COUNTIF($AD$3:AD49,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE49),$AE$3:$AE$55,0)),\"\")","v":""}]
["OSB","OSB001",null,"2018-09-02","01",9,null,"CURR","SLT001","Senior Leadership Team",1,{"$f":"\"A_\"&MID(I50,1,3)","v":"A_SLT"},"Headteacher","Executive Headteacher","FD","CEO",null,2010,"Teachers - LGPS Main Scheme",null,null,null,null,"2010 - Teachers - LGPS Main Scheme",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X46,1),\"\"))","v":0},{"$f":"IF(Y50=1,COUNTIF(Y$3:$Y50,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z50),$Z$3:$Z$274,0)),\"\")","v":""},null,null,0,{"$f":"IF(AD50=1,COUNTIF($AD$3:AD50,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE50),$AE$3:$AE$55,0)),\"\")","v":""}]
["PAT","PAT001",null,"2018-09-03","01",9,null,"CURR","SUM001","Summer School",1,{"$f":"\"A_\"&MID(I51,1,3)","v":"A_SUM"},"Headteacher","Executive Headteacher","FD","CEO",null,2011,"Teachers - Cash Safeguard",null,null,null,null,"2011 - Teachers - Cash Safeguard",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X47,1),\"\"))","v":0},{"$f":"IF(Y51=1,COUNTIF(Y$3:$Y51,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z51),$Z$3:$Z$274,0)),\"\")","v":""},null,null,{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,AC51,1),\"\"))","v":0},{"$f":"IF(AD51=1,COUNTIF($AD$3:AD51,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE51),$AE$3:$AE$55,0)),\"\")","v":""}]
["PGS","PGS001",null,"2018-09-04","01",9,null,"CPD","STS001","School To School Support",1,"A_CPD","Headteacher","Executive Headteacher","FD","CEO",null,2012,"Teachers - Pay Protection",null,null,null,null,"2012 - Teachers - Pay Protection",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X48,1),\"\"))","v":0},{"$f":"IF(Y52=1,COUNTIF(Y$3:$Y52,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z52),$Z$3:$Z$274,0)),\"\")","v":""},null,null,0,{"$f":"IF(AD52=1,COUNTIF($AD$3:AD52,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE52),$AE$3:$AE$55,0)),\"\")","v":""}]
["RWS","RWS001",null,"2018-09-05","01",9,null,"CURR","TNY001","Tiny Steps",1,"A_CPD","Headteacher","Executive Headteacher","FD","CEO",null,2013,"Teachers - Special Needs Resp",null,null,null,null,"2013 - Teachers - Special Needs Resp",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X49,1),\"\"))","v":0},{"$f":"IF(Y53=1,COUNTIF(Y$3:$Y53,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z53),$Z$3:$Z$274,0)),\"\")","v":""},null,null,0,{"$f":"IF(AD53=1,COUNTIF($AD$3:AD53,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE53),$AE$3:$AE$55,0)),\"\")","v":""}]
["SHS","SHS001",null,"2018-09-06","01",9,null,"CURR","WRL001","Work Related Learning",1,{"$f":"\"A_\"&MID(I54,1,3)","v":"A_WRL"},"Headteacher","Executive Headteacher","FD","CEO",null,2014,"Teachers - TLR2 Payment",null,null,null,null,"2014 - Teachers - TLR2 Payment",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X50,1),\"\"))","v":0},{"$f":"IF(Y54=1,COUNTIF(Y$3:$Y54,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z54),$Z$3:$Z$274,0)),\"\")","v":""},null,null,0,{"$f":"IF(AD54=1,COUNTIF($AD$3:AD54,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE54),$AE$3:$AE$55,0)),\"\")","v":""}]
["SIG","SIG001",null,"2018-09-07","01",9,null,"TRIPS","TRP001","School Trips",1,"A_TRIPS","Headteacher","Executive Headteacher","FD","CEO",null,2015,"Teachers - Overtime",null,null,null,null,"2015 - Teachers - Overtime",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X51,1),\"\"))","v":0},{"$f":"IF(Y55=1,COUNTIF(Y$3:$Y55,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z55),$Z$3:$Z$274,0)),\"\")","v":""},null,null,0,{"$f":"IF(AD55=1,COUNTIF($AD$3:AD55,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AC$3:$AC$53,MATCH(ROWS($AE$3:AE55),$AE$3:$AE$55,0)),\"\")","v":""}]
["SPR","SPR001",null,"2018-09-08","01",9,null,null,null,null,null,null,null,null,null,null,null,2048,"Teachers - Occ Sick Half",null,null,null,null,"2048 - Teachers - Occ Sick Half",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X52,1),\"\"))","v":0},{"$f":"IF(Y56=1,COUNTIF(Y$3:$Y56,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z56),$Z$3:$Z$274,0)),\"\")","v":""}]
["TOC","TOC001",null,"2018-09-09","01",9,null,null,null,null,null,null,null,null,null,null,null,2049,"Teachers - Statutory Charge",null,null,null,null,"2049 - Teachers - Statutory Charge",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X53,1),\"\"))","v":0},{"$f":"IF(Y57=1,COUNTIF(Y$3:$Y57,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z57),$Z$3:$Z$274,0)),\"\")","v":""}]
["RIS","RIS001",null,"2018-09-10","01",9,null,null,null,null,null,null,null,null,null,null,null,2051,"Teachers - Statutory Pension",null,null,null,null,"2051 - Teachers - Statutory Pension",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X54,1),\"\"))","v":0},{"$f":"IF(Y58=1,COUNTIF(Y$3:$Y58,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z58),$Z$3:$Z$274,0)),\"\")","v":""}]
["TAD","TAD001",null,"2018-09-11","01",9,null,null,null,null,null,null,null,null,null,null,null,2052,"Teachers - Statutory Recovery",null,null,null,null,"2052 - Teachers - Statutory Recovery",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X55,1),\"\"))","v":0},{"$f":"IF(Y59=1,COUNTIF(Y$3:$Y59,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z59),$Z$3:$Z$274,0)),\"\")","v":""}]
["BRA","BRA001",null,"2018-09-12","01",9,null,null,null,null,null,null,null,null,null,null,null,2053,"Teachers - PILON",null,null,null,null,"2053 - Teachers - PILON",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X56,1),\"\"))","v":0},{"$f":"IF(Y60=1,COUNTIF(Y$3:$Y60,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z60),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-09-13","01",9,null,null,null,null,null,null,null,null,null,null,null,2100,"Technicians - Normal Pay",null,null,null,null,"2100 - Technicians - Normal Pay",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X57,1),\"\"))","v":0},{"$f":"IF(Y61=1,COUNTIF(Y$3:$Y61,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z61),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-09-14","01",9,null,null,null,null,null,null,null,null,null,null,null,2101,"Technicians - Supply Teacher Pay",null,null,null,null,"2101 - Technicians - Supply Teacher Pay",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X58,1),\"\"))","v":0},{"$f":"IF(Y62=1,COUNTIF(Y$3:$Y62,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z62),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-09-15","01",9,null,null,null,null,null,null,null,null,null,null,null,2102,"Technicians - Holiday Pay",null,null,null,null,"2102 - Technicians - Holiday Pay",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X59,1),\"\"))","v":0},{"$f":"IF(Y63=1,COUNTIF(Y$3:$Y63,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z63),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-09-16","01",9,null,null,null,null,null,null,null,null,null,null,null,2104,"Technicians - Childcare Vouchers",null,null,null,null,"2104 - Technicians - Childcare Vouchers",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X61,1),\"\"))","v":0},{"$f":"IF(Y64=1,COUNTIF(Y$3:$Y64,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z64),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-09-17","01",9,null,null,null,null,null,null,null,null,null,null,null,2105,"Technicians - Employers NI",null,null,null,null,"2105 - Technicians - Employers NI",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X62,1),\"\"))","v":0},{"$f":"IF(Y65=1,COUNTIF(Y$3:$Y65,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z65),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-09-18","01",9,null,null,null,null,null,null,null,null,null,null,null,2106,"Technicians - Living Wage",null,null,null,null,"2106 - Technicians - Living Wage",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X63,1),\"\"))","v":0},{"$f":"IF(Y66=1,COUNTIF(Y$3:$Y66,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z66),$Z$3:$Z$274,0)),\"\")","v":""}]
["001",null,null,"2018-09-19","01",9,null,null,null,null,null,null,null,null,null,null,null,2107,"Technicians - Monetary diff",null,null,null,null,"2107 - Technicians - Monetary diff",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X64,1),\"\"))","v":0},{"$f":"IF(Y67=1,COUNTIF(Y$3:$Y67,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z67),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-09-20","01",9,null,null,null,null,null,null,null,null,null,null,null,2108,"Technicians - Additional Hours",null,null,null,null,"2108 - Technicians - Additional Hours",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X65,1),\"\"))","v":0},{"$f":"IF(Y68=1,COUNTIF(Y$3:$Y68,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z68),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-09-21","01",9,null,null,null,null,null,null,null,null,null,null,null,2109,"Technicians - Casual Holiday Pay",null,null,null,null,"2109 - Technicians - Casual Holiday Pay",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X66,1),\"\"))","v":0},{"$f":"IF(Y69=1,COUNTIF(Y$3:$Y69,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z69),$Z$3:$Z$274,0)),\"\")","v":""}]
["Credit Card - Receipt Attached",null,null,"2018-09-22","01",9,null,null,null,null,null,null,null,null,null,null,null,2110,"Technicians - LGPS Main Scheme",null,null,null,null,"2110 - Technicians - LGPS Main Scheme",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X67,1),\"\"))","v":0},{"$f":"IF(Y70=1,COUNTIF(Y$3:$Y70,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z70),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-09-23","01",9,null,null,null,null,null,null,null,null,null,null,null,2111,"Technicians - Cash Safeguard",null,null,null,null,"2111 - Technicians - Cash Safeguard",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X68,1),\"\"))","v":0},{"$f":"IF(Y71=1,COUNTIF(Y$3:$Y71,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z71),$Z$3:$Z$274,0)),\"\")","v":""}]
["Y",null,null,"2018-09-24","01",9,null,null,null,null,null,null,null,null,null,null,null,2112,"Technicians - Pay Protection",null,null,null,null,"2112 - Technicians - Pay Protection",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X69,1),\"\"))","v":0},{"$f":"IF(Y72=1,COUNTIF(Y$3:$Y72,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z72),$Z$3:$Z$274,0)),\"\")","v":""}]
["N",null,null,"2018-09-25","01",9,null,null,null,null,null,null,null,null,null,null,null,2113,"Technicians - Special Needs Resp",null,null,null,null,"2113 - Technicians - Special Needs Resp",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X70,1),\"\"))","v":0},{"$f":"IF(Y73=1,COUNTIF(Y$3:$Y73,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z73),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-09-26","01",9,null,null,null,null,null,null,null,null,null,null,null,2115,"Technicians - Overtime",null,null,null,null,"2115 - Technicians - Overtime",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X71,1),\"\"))","v":0},{"$f":"IF(Y74=1,COUNTIF(Y$3:$Y74,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z74),$Z$3:$Z$274,0)),\"\")","v":""}]
["Years",null,null,"2018-09-27","01",9,null,null,null,null,null,null,null,null,null,null,null,2148,"Technicians - Occ Sick Half",null,null,null,null,"2148 - Technicians - Occ Sick Half",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X72,1),\"\"))","v":0},{"$f":"IF(Y75=1,COUNTIF(Y$3:$Y75,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z75),$Z$3:$Z$274,0)),\"\")","v":""}]
["2015/16",null,null,"2018-09-28","01",9,null,null,null,null,null,null,null,null,null,null,null,2149,"Technicians - Statutory Charge",null,null,null,null,"2149 - Technicians - Statutory Charge",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X73,1),\"\"))","v":0},{"$f":"IF(Y76=1,COUNTIF(Y$3:$Y76,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z76),$Z$3:$Z$274,0)),\"\")","v":""}]
["2016/17",null,null,"2018-09-29","01",9,null,null,null,null,null,null,null,null,null,null,null,2151,"Technicians - Statutory Pension",null,null,null,null,"2151 - Technicians - Statutory Pension",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X74,1),\"\"))","v":0},{"$f":"IF(Y77=1,COUNTIF(Y$3:$Y77,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z77),$Z$3:$Z$274,0)),\"\")","v":""}]
["2017/18",null,null,"2018-09-30","01",9,null,null,null,null,null,null,null,null,null,null,null,2152,"Technicians - Statutory Recovery",null,null,null,null,"2152 - Technicians - Statutory Recovery",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X75,1),\"\"))","v":0},{"$f":"IF(Y78=1,COUNTIF(Y$3:$Y78,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z78),$Z$3:$Z$274,0)),\"\")","v":""}]
["2018/19",null,null,"2018-10-01","02",10,null,null,null,null,null,null,null,null,null,null,null,2153,"Technicians - PILON",null,null,null,null,"2153 - Technicians - PILON",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X76,1),\"\"))","v":0},{"$f":"IF(Y79=1,COUNTIF(Y$3:$Y79,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z79),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-10-02","02",10,null,null,null,null,null,null,null,null,null,null,null,2200,"Teaching Assistants - Normal Pay",null,null,null,null,"2200 - Teaching Assistants - Normal Pay",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X77,1),\"\"))","v":0},{"$f":"IF(Y80=1,COUNTIF(Y$3:$Y80,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z80),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-10-03","02",10,null,null,null,null,null,null,null,null,null,null,null,2201,"Teaching Assistants - Supply Teacher Pay",null,null,null,null,"2201 - Teaching Assistants - Supply Teacher Pay",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X78,1),\"\"))","v":0},{"$f":"IF(Y81=1,COUNTIF(Y$3:$Y81,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z81),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-10-04","02",10,null,null,null,null,null,null,null,null,null,null,null,2202,"Teaching Assistants - Holiday Pay",null,null,null,null,"2202 - Teaching Assistants - Holiday Pay",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X80,1),\"\"))","v":0},{"$f":"IF(Y82=1,COUNTIF(Y$3:$Y82,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z82),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-10-05","02",10,null,null,null,null,null,null,null,null,null,null,null,2203,"Teaching Assistants - ET Teachers Pensio",null,null,null,null,"2203 - Teaching Assistants - ET Teachers Pensio",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X81,1),\"\"))","v":0},{"$f":"IF(Y83=1,COUNTIF(Y$3:$Y83,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z83),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-10-06","02",10,null,null,null,null,null,null,null,null,null,null,null,2204,"Teaching Assistants - Childcare Vouchers",null,null,null,null,"2204 - Teaching Assistants - Childcare Vouchers",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X82,1),\"\"))","v":0},{"$f":"IF(Y84=1,COUNTIF(Y$3:$Y84,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z84),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-10-07","02",10,null,null,null,null,null,null,null,null,null,null,null,2205,"Teaching Assistants - Employers NI",null,null,null,null,"2205 - Teaching Assistants - Employers NI",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X83,1),\"\"))","v":0},{"$f":"IF(Y85=1,COUNTIF(Y$3:$Y85,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z85),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-10-08","02",10,null,null,null,null,null,null,null,null,null,null,null,2206,"Teaching Assistants - Living Wage",null,null,null,null,"2206 - Teaching Assistants - Living Wage",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X84,1),\"\"))","v":0},{"$f":"IF(Y86=1,COUNTIF(Y$3:$Y86,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z86),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-10-09","02",10,null,null,null,null,null,null,null,null,null,null,null,2207,"Teaching Assistants - Monetary diff",null,null,null,null,"2207 - Teaching Assistants - Monetary diff",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X85,1),\"\"))","v":0},{"$f":"IF(Y87=1,COUNTIF(Y$3:$Y87,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z87),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-10-10","02",10,null,null,null,null,null,null,null,null,null,null,null,2208,"Teaching Assistants - Additional Hours",null,null,null,null,"2208 - Teaching Assistants - Additional Hours",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X86,1),\"\"))","v":0},{"$f":"IF(Y88=1,COUNTIF(Y$3:$Y88,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z88),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-10-11","02",10,null,null,null,null,null,null,null,null,null,null,null,2209,"Teaching Assistants - Casual Holiday Pay",null,null,null,null,"2209 - Teaching Assistants - Casual Holiday Pay",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X87,1),\"\"))","v":0},{"$f":"IF(Y89=1,COUNTIF(Y$3:$Y89,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z89),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-10-12","02",10,null,null,null,null,null,null,null,null,null,null,null,2210,"Teaching Assistants - LGPS Main Scheme",null,null,null,null,"2210 - Teaching Assistants - LGPS Main Scheme",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X88,1),\"\"))","v":0},{"$f":"IF(Y90=1,COUNTIF(Y$3:$Y90,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z90),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-10-13","02",10,null,null,null,null,null,null,null,null,null,null,null,2211,"Teaching Assistants - Cash Safeguard",null,null,null,null,"2211 - Teaching Assistants - Cash Safeguard",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X89,1),\"\"))","v":0},{"$f":"IF(Y91=1,COUNTIF(Y$3:$Y91,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z91),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-10-14","02",10,null,null,null,null,null,null,null,null,null,null,null,2212,"Teaching Assistants - Pay Protection",null,null,null,null,"2212 - Teaching Assistants - Pay Protection",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X90,1),\"\"))","v":0},{"$f":"IF(Y92=1,COUNTIF(Y$3:$Y92,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z92),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-10-15","02",10,null,null,null,null,null,null,null,null,null,null,null,2213,"Teaching Assistants - Special Needs Resp",null,null,null,null,"2213 - Teaching Assistants - Special Needs Resp",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X91,1),\"\"))","v":0},{"$f":"IF(Y93=1,COUNTIF(Y$3:$Y93,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z93),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-10-16","02",10,null,null,null,null,null,null,null,null,null,null,null,2215,"Teaching Assistants - Overtime",null,null,null,null,"2215 - Teaching Assistants - Overtime",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X92,1),\"\"))","v":0},{"$f":"IF(Y94=1,COUNTIF(Y$3:$Y94,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z94),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-10-17","02",10,null,null,null,null,null,null,null,null,null,null,null,2248,"Teaching Assistants - Occ Sick Half",null,null,null,null,"2248 - Teaching Assistants - Occ Sick Half",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X93,1),\"\"))","v":0},{"$f":"IF(Y95=1,COUNTIF(Y$3:$Y95,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z95),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-10-18","02",10,null,null,null,null,null,null,null,null,null,null,null,2249,"Teaching Assistants - Statutory Charge",null,null,null,null,"2249 - Teaching Assistants - Statutory Charge",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X94,1),\"\"))","v":0},{"$f":"IF(Y96=1,COUNTIF(Y$3:$Y96,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z96),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-10-19","02",10,null,null,null,null,null,null,null,null,null,null,null,2251,"Teaching Assistants - Statutory Pension",null,null,null,null,"2251 - Teaching Assistants - Statutory Pension",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X95,1),\"\"))","v":0},{"$f":"IF(Y97=1,COUNTIF(Y$3:$Y97,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z97),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-10-20","02",10,null,null,null,null,null,null,null,null,null,null,null,2252,"Teaching Assistants - Statutory Recovery",null,null,null,null,"2252 - Teaching Assistants - Statutory Recovery",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X96,1),\"\"))","v":0},{"$f":"IF(Y98=1,COUNTIF(Y$3:$Y98,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z98),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-10-21","02",10,null,null,null,null,null,null,null,null,null,null,null,2253,"Teaching Assistants - PILON",null,null,null,null,"2253 - Teaching Assistants - PILON",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X97,1),\"\"))","v":0},{"$f":"IF(Y99=1,COUNTIF(Y$3:$Y99,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z99),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-10-22","02",10,null,null,null,null,null,null,null,null,null,null,null,2300,"Premises Staff - Normal Pay",null,null,null,null,"2300 - Premises Staff - Normal Pay",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X98,1),\"\"))","v":0},{"$f":"IF(Y100=1,COUNTIF(Y$3:$Y100,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z100),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-10-23","02",10,null,null,null,null,null,null,null,null,null,null,null,2301,"Premises Staff - Supply Teacher Pay",null,null,null,null,"2301 - Premises Staff - Supply Teacher Pay",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X100,1),\"\"))","v":0},{"$f":"IF(Y101=1,COUNTIF(Y$3:$Y101,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z101),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-10-24","02",10,null,null,null,null,null,null,null,null,null,null,null,2302,"Premises Staff - Holiday Pay",null,null,null,null,"2302 - Premises Staff - Holiday Pay",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X101,1),\"\"))","v":0},{"$f":"IF(Y102=1,COUNTIF(Y$3:$Y102,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z102),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-10-25","02",10,null,null,null,null,null,null,null,null,null,null,null,2304,"Premises Staff - Childcare Vouchers",null,null,null,null,"2304 - Premises Staff - Childcare Vouchers",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X102,1),\"\"))","v":0},{"$f":"IF(Y103=1,COUNTIF(Y$3:$Y103,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z103),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-10-26","02",10,null,null,null,null,null,null,null,null,null,null,null,2305,"Premises Staff - Employers NI",null,null,null,null,"2305 - Premises Staff - Employers NI",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X103,1),\"\"))","v":0},{"$f":"IF(Y104=1,COUNTIF(Y$3:$Y104,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z104),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-10-27","02",10,null,null,null,null,null,null,null,null,null,null,null,2306,"Premises Staff - Living Wage",null,null,null,null,"2306 - Premises Staff - Living Wage",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X104,1),\"\"))","v":0},{"$f":"IF(Y105=1,COUNTIF(Y$3:$Y105,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z105),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-10-28","02",10,null,null,null,null,null,null,null,null,null,null,null,2307,"Premises Staff - Monetary diff",null,null,null,null,"2307 - Premises Staff - Monetary diff",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X105,1),\"\"))","v":0},{"$f":"IF(Y106=1,COUNTIF(Y$3:$Y106,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z106),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-10-29","02",10,null,null,null,null,null,null,null,null,null,null,null,2308,"Premises Staff - Additional Hours",null,null,null,null,"2308 - Premises Staff - Additional Hours",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X106,1),\"\"))","v":0},{"$f":"IF(Y107=1,COUNTIF(Y$3:$Y107,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z107),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-10-30","02",10,null,null,null,null,null,null,null,null,null,null,null,2309,"Premises Staff - Casual Holiday Pay",null,null,null,null,"2309 - Premises Staff - Casual Holiday Pay",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X107,1),\"\"))","v":0},{"$f":"IF(Y108=1,COUNTIF(Y$3:$Y108,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z108),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-10-31","02",10,null,null,null,null,null,null,null,null,null,null,null,2310,"Premises Staff - LGPS Main Scheme",null,null,null,null,"2310 - Premises Staff - LGPS Main Scheme",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X108,1),\"\"))","v":0},{"$f":"IF(Y109=1,COUNTIF(Y$3:$Y109,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z109),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-11-01","03",11,null,null,null,null,null,null,null,null,null,null,null,2311,"Premises Staff - Cash Safeguard",null,null,null,null,"2311 - Premises Staff - Cash Safeguard",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X109,1),\"\"))","v":0},{"$f":"IF(Y110=1,COUNTIF(Y$3:$Y110,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z110),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-11-02","03",11,null,null,null,null,null,null,null,null,null,null,null,2312,"Premises Staff - Pay Protection",null,null,null,null,"2312 - Premises Staff - Pay Protection",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X110,1),\"\"))","v":0},{"$f":"IF(Y111=1,COUNTIF(Y$3:$Y111,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z111),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-11-03","03",11,null,null,null,null,null,null,null,null,null,null,null,2313,"Premises Staff - Special Needs Resp",null,null,null,null,"2313 - Premises Staff - Special Needs Resp",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X111,1),\"\"))","v":0},{"$f":"IF(Y112=1,COUNTIF(Y$3:$Y112,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z112),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-11-04",{"$f":"VLOOKUP(F113,$D$3:$E$14,2,FALSE)","v":"03"},{"$f":"MONTH(D113)","v":11},null,null,null,null,null,null,null,null,null,null,null,2315,"Premises Staff - Overtime",null,null,null,null,"2315 - Premises Staff - Overtime",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X112,1),\"\"))","v":0},{"$f":"IF(Y113=1,COUNTIF(Y$3:$Y113,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z113),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-11-05","03",11,null,null,null,null,null,null,null,null,null,null,null,2348,"Premises Staff - Occ Sick Half",null,null,null,null,"2348 - Premises Staff - Occ Sick Half",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X113,1),\"\"))","v":0},{"$f":"IF(Y114=1,COUNTIF(Y$3:$Y114,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z114),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-11-06","03",11,null,null,null,null,null,null,null,null,null,null,null,2349,"Premises Staff - Statutory Charge",null,null,null,null,"2349 - Premises Staff - Statutory Charge",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X114,1),\"\"))","v":0},{"$f":"IF(Y115=1,COUNTIF(Y$3:$Y115,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z115),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-11-07","03",11,null,null,null,null,null,null,null,null,null,null,null,2351,"Premises Staff - Statutory Pension",null,null,null,null,"2351 - Premises Staff - Statutory Pension",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X115,1),\"\"))","v":0},{"$f":"IF(Y116=1,COUNTIF(Y$3:$Y116,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z116),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-11-08","03",11,null,null,null,null,null,null,null,null,null,null,null,2352,"Premises Staff - Statutory Recovery",null,null,null,null,"2352 - Premises Staff - Statutory Recovery",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X116,1),\"\"))","v":0},{"$f":"IF(Y117=1,COUNTIF(Y$3:$Y117,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z117),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-11-09","03",11,null,null,null,null,null,null,null,null,null,null,null,2353,"Premises Staff - PILON",null,null,null,null,"2353 - Premises Staff - PILON",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X117,1),\"\"))","v":0},{"$f":"IF(Y118=1,COUNTIF(Y$3:$Y118,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z118),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-11-10","03",11,null,null,null,null,null,null,null,null,null,null,null,2400,"Midday Supervisor - Normal Pay",null,null,null,null,"2400 - Midday Supervisor - Normal Pay",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X119,1),\"\"))","v":0},{"$f":"IF(Y119=1,COUNTIF(Y$3:$Y119,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z119),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-11-11","03",11,null,null,null,null,null,null,null,null,null,null,null,2401,"Midday Supervisor - Supply Teacher Pay",null,null,null,null,"2401 - Midday Supervisor - Supply Teacher Pay",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X120,1),\"\"))","v":0},{"$f":"IF(Y120=1,COUNTIF(Y$3:$Y120,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z120),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-11-12","03",11,null,null,null,null,null,null,null,null,null,null,null,2402,"Midday Supervisor - Holiday Pay",null,null,null,null,"2402 - Midday Supervisor - Holiday Pay",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X121,1),\"\"))","v":0},{"$f":"IF(Y121=1,COUNTIF(Y$3:$Y121,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z121),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-11-13","03",11,null,null,null,null,null,null,null,null,null,null,null,2404,"Midday Supervisor - Childcare Vouchers",null,null,null,null,"2404 - Midday Supervisor - Childcare Vouchers",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X122,1),\"\"))","v":0},{"$f":"IF(Y122=1,COUNTIF(Y$3:$Y122,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z122),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-11-14","03",11,null,null,null,null,null,null,null,null,null,null,null,2405,"Midday Supervisor - Employers NI",null,null,null,null,"2405 - Midday Supervisor - Employers NI",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X123,1),\"\"))","v":0},{"$f":"IF(Y123=1,COUNTIF(Y$3:$Y123,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z123),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-11-15","03",11,null,null,null,null,null,null,null,null,null,null,null,2406,"Midday Supervisor - Living Wage",null,null,null,null,"2406 - Midday Supervisor - Living Wage",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X124,1),\"\"))","v":0},{"$f":"IF(Y124=1,COUNTIF(Y$3:$Y124,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z124),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-11-16","03",11,null,null,null,null,null,null,null,null,null,null,null,2407,"Midday Supervisor - Monetary diff",null,null,null,null,"2407 - Midday Supervisor - Monetary diff",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X125,1),\"\"))","v":0},{"$f":"IF(Y125=1,COUNTIF(Y$3:$Y125,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z125),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-11-17","03",11,null,null,null,null,null,null,null,null,null,null,null,2408,"Midday Supervisor - Additional Hours",null,null,null,null,"2408 - Midday Supervisor - Additional Hours",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X126,1),\"\"))","v":0},{"$f":"IF(Y126=1,COUNTIF(Y$3:$Y126,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z126),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-11-18","03",11,null,null,null,null,null,null,null,null,null,null,null,2409,"Midday Supervisor - Casual Holiday Pay",null,null,null,null,"2409 - Midday Supervisor - Casual Holiday Pay",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X127,1),\"\"))","v":0},{"$f":"IF(Y127=1,COUNTIF(Y$3:$Y127,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z127),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-11-19","03",11,null,null,null,null,null,null,null,null,null,null,null,2410,"Midday Supervisor - LGPS Main Scheme",null,null,null,null,"2410 - Midday Supervisor - LGPS Main Scheme",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X128,1),\"\"))","v":0},{"$f":"IF(Y128=1,COUNTIF(Y$3:$Y128,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z128),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-11-20","03",11,null,null,null,null,null,null,null,null,null,null,null,2411,"Midday Supervisor - Cash Safeguard",null,null,null,null,"2411 - Midday Supervisor - Cash Safeguard",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X129,1),\"\"))","v":0},{"$f":"IF(Y129=1,COUNTIF(Y$3:$Y129,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z129),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-11-21","03",11,null,null,null,null,null,null,null,null,null,null,null,2412,"Midday Supervisor - Pay Protection",null,null,null,null,"2412 - Midday Supervisor - Pay Protection",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X130,1),\"\"))","v":0},{"$f":"IF(Y130=1,COUNTIF(Y$3:$Y130,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z130),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-11-22","03",11,null,null,null,null,null,null,null,null,null,null,null,2413,"Midday Supervisor - Special Needs Resp",null,null,null,null,"2413 - Midday Supervisor - Special Needs Resp",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X131,1),\"\"))","v":0},{"$f":"IF(Y131=1,COUNTIF(Y$3:$Y131,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z131),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-11-23","03",11,null,null,null,null,null,null,null,null,null,null,null,2415,"Midday Supervisor - Overtime",null,null,null,null,"2415 - Midday Supervisor - Overtime",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X132,1),\"\"))","v":0},{"$f":"IF(Y132=1,COUNTIF(Y$3:$Y132,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z132),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-11-24","03",11,null,null,null,null,null,null,null,null,null,null,null,2416,"Midday Supervisor - Occ Sick Half",null,null,null,null,"2416 - Midday Supervisor - Occ Sick Half",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X133,1),\"\"))","v":0},{"$f":"IF(Y133=1,COUNTIF(Y$3:$Y133,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z133),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-11-25","03",11,null,null,null,null,null,null,null,null,null,null,null,2449,"Midday Supervisor - Statutory Charge",null,null,null,null,"2449 - Midday Supervisor - Statutory Charge",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X134,1),\"\"))","v":0},{"$f":"IF(Y134=1,COUNTIF(Y$3:$Y134,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z134),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-11-26","03",11,null,null,null,null,null,null,null,null,null,null,null,2451,"Midday Supervisor - Statutory Pension",null,null,null,null,"2451 - Midday Supervisor - Statutory Pension",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X135,1),\"\"))","v":0},{"$f":"IF(Y135=1,COUNTIF(Y$3:$Y135,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z135),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-11-27","03",11,null,null,null,null,null,null,null,null,null,null,null,2452,"Midday Supervisor - Statutory Recovery",null,null,null,null,"2452 - Midday Supervisor - Statutory Recovery",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X136,1),\"\"))","v":0},{"$f":"IF(Y136=1,COUNTIF(Y$3:$Y136,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z136),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-11-28","03",11,null,null,null,null,null,null,null,null,null,null,null,2453,"Midday Supervisor - PILON",null,null,null,null,"2453 - Midday Supervisor - PILON",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X138,1),\"\"))","v":0},{"$f":"IF(Y137=1,COUNTIF(Y$3:$Y137,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z137),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-11-29","03",11,null,null,null,null,null,null,null,null,null,null,null,2500,"Other Staff - Normal Pay",null,null,null,null,"2500 - Other Staff - Normal Pay",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X139,1),\"\"))","v":0},{"$f":"IF(Y138=1,COUNTIF(Y$3:$Y138,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z138),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-11-30","03",11,null,null,null,null,null,null,null,null,null,null,null,2501,"Other Staff - Supply Teacher Pay",null,null,null,null,"2501 - Other Staff - Supply Teacher Pay",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X140,1),\"\"))","v":0},{"$f":"IF(Y139=1,COUNTIF(Y$3:$Y139,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z139),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-12-01","04",12,null,null,null,null,null,null,null,null,null,null,null,2502,"Other Staff - Holiday Pay",null,null,null,null,"2502 - Other Staff - Holiday Pay on Leaving",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X141,1),\"\"))","v":0},{"$f":"IF(Y140=1,COUNTIF(Y$3:$Y140,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z140),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-12-02","04",12,null,null,null,null,null,null,null,null,null,null,null,2504,"Other Staff - Childcare Vouchers",null,null,null,null,"2504 - Other Staff - Childcare Vouchers",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X142,1),\"\"))","v":0},{"$f":"IF(Y141=1,COUNTIF(Y$3:$Y141,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z141),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-12-03","04",12,null,null,null,null,null,null,null,null,null,null,null,2505,"Other Staff - Employers NI",null,null,null,null,"2505 - Other Staff - Employers NI",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X143,1),\"\"))","v":0},{"$f":"IF(Y142=1,COUNTIF(Y$3:$Y142,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z142),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-12-04","04",12,null,null,null,null,null,null,null,null,null,null,null,2506,"Other Staff - Living Wage",null,null,null,null,"2506 - Other Staff - Living Wage",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X144,1),\"\"))","v":0},{"$f":"IF(Y143=1,COUNTIF(Y$3:$Y143,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z143),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-12-05","04",12,null,null,null,null,null,null,null,null,null,null,null,2507,"Other Staff - Monetary diff",null,null,null,null,"2507 - Other Staff - Monetary diff",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X145,1),\"\"))","v":0},{"$f":"IF(Y144=1,COUNTIF(Y$3:$Y144,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z144),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-12-06","04",12,null,null,null,null,null,null,null,null,null,null,null,2508,"Other Staff - Additional Hours",null,null,null,null,"2508 - Other Staff - Additional Hours",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X146,1),\"\"))","v":0},{"$f":"IF(Y145=1,COUNTIF(Y$3:$Y145,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z145),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-12-07","04",12,null,null,null,null,null,null,null,null,null,null,null,2509,"Other Staff - Casual Holiday Pay",null,null,null,null,"2509 - Other Staff - Casual Holiday Pay",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X147,1),\"\"))","v":0},{"$f":"IF(Y146=1,COUNTIF(Y$3:$Y146,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z146),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-12-08","04",12,null,null,null,null,null,null,null,null,null,null,null,2510,"Other Staff - LGPS Main Scheme",null,null,null,null,"2510 - Other Staff - LGPS Main Scheme",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X148,1),\"\"))","v":0},{"$f":"IF(Y147=1,COUNTIF(Y$3:$Y147,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z147),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-12-09","04",12,null,null,null,null,null,null,null,null,null,null,null,2511,"Other Staff - Cash Safeguard",null,null,null,null,"2511 - Other Staff - Cash Safeguard",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X149,1),\"\"))","v":0},{"$f":"IF(Y148=1,COUNTIF(Y$3:$Y148,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z148),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-12-10","04",12,null,null,null,null,null,null,null,null,null,null,null,2512,"Other Staff - Pay Protection",null,null,null,null,"2512 - Other Staff - Pay Protection",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X150,1),\"\"))","v":0},{"$f":"IF(Y149=1,COUNTIF(Y$3:$Y149,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z149),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-12-11","04",12,null,null,null,null,null,null,null,null,null,null,null,2513,"Other Staff - Special Needs Resp",null,null,null,null,"2513 - Other Staff - Special Needs Resp",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X151,1),\"\"))","v":0},{"$f":"IF(Y150=1,COUNTIF(Y$3:$Y150,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z150),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-12-12","04",12,null,null,null,null,null,null,null,null,null,null,null,2515,"Other Staff - Overtime",null,null,null,null,"2515 - Other Staff - Overtime",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X152,1),\"\"))","v":0},{"$f":"IF(Y151=1,COUNTIF(Y$3:$Y151,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z151),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-12-13","04",12,null,null,null,null,null,null,null,null,null,null,null,2516,"Other Staff - Occ Sick Half",null,null,null,null,"2516 - Other Staff - Occ Sick Half",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X153,1),\"\"))","v":0},{"$f":"IF(Y152=1,COUNTIF(Y$3:$Y152,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z152),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-12-14","04",12,null,null,null,null,null,null,null,null,null,null,null,2549,"Other Staff - Statutory Charge",null,null,null,null,"2549 - Other Staff - Statutory Charge",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X154,1),\"\"))","v":0},{"$f":"IF(Y153=1,COUNTIF(Y$3:$Y153,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z153),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-12-15","04",12,null,null,null,null,null,null,null,null,null,null,null,2551,"Other Staff - Statutory Pension",null,null,null,null,"2551 - Other Staff - Statutory Pension",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X155,1),\"\"))","v":0},{"$f":"IF(Y154=1,COUNTIF(Y$3:$Y154,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z154),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-12-16","04",12,null,null,null,null,null,null,null,null,null,null,null,2552,"Other Staff - Statutory Recovery",null,null,null,null,"2552 - Other Staff - Statutory Recovery",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X157,1),\"\"))","v":0},{"$f":"IF(Y155=1,COUNTIF(Y$3:$Y155,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z155),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-12-17","04",12,null,null,null,null,null,null,null,null,null,null,null,2553,"Other Staff - PILON",null,null,null,null,"2553 - Other Staff PILON",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X158,1),\"\"))","v":0},{"$f":"IF(Y156=1,COUNTIF(Y$3:$Y156,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z156),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-12-18","04",12,null,null,null,null,null,null,null,null,null,null,null,2600,"Finance and Admin - Normal Pay",null,null,null,null,"2600 - Finance and Admin - Normal Pay",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X159,1),\"\"))","v":0},{"$f":"IF(Y157=1,COUNTIF(Y$3:$Y157,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z157),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-12-19","04",12,null,null,null,null,null,null,null,null,null,null,null,2601,"Finance and Admin - Supply Teacher Pay",null,null,null,null,"2601 - Finance and Admin - Supply Teacher Pay",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X160,1),\"\"))","v":0},{"$f":"IF(Y158=1,COUNTIF(Y$3:$Y158,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z158),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-12-20","04",12,null,null,null,null,null,null,null,null,null,null,null,2602,"Finance and Admin - Holiday Pay",null,null,null,null,"2602 - Finance and Admin - Holiday Pay",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X161,1),\"\"))","v":0},{"$f":"IF(Y159=1,COUNTIF(Y$3:$Y159,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z159),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-12-21","04",12,null,null,null,null,null,null,null,null,null,null,null,2604,"Finance and Admin - Childcare Vouchers",null,null,null,null,"2604 - Finance and Admin - Childcare Vouchers",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X162,1),\"\"))","v":0},{"$f":"IF(Y160=1,COUNTIF(Y$3:$Y160,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z160),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-12-22","04",12,null,null,null,null,null,null,null,null,null,null,null,2605,"Finance and Admin - Employers NI",null,null,null,null,"2605 - Finance and Admin - Employers NI",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X163,1),\"\"))","v":0},{"$f":"IF(Y161=1,COUNTIF(Y$3:$Y161,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z161),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-12-23","04",12,null,null,null,null,null,null,null,null,null,null,null,2606,"Finance and Admin - Living Wage",null,null,null,null,"2606 - Finance and Admin - Living Wage",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X164,1),\"\"))","v":0},{"$f":"IF(Y162=1,COUNTIF(Y$3:$Y162,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z162),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-12-24","04",12,null,null,null,null,null,null,null,null,null,null,null,2607,"Finance and Admin - Monetary diff",null,null,null,null,"2607 - Finance and Admin - Monetary diff",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X165,1),\"\"))","v":0},{"$f":"IF(Y163=1,COUNTIF(Y$3:$Y163,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z163),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-12-25","04",12,null,null,null,null,null,null,null,null,null,null,null,2608,"Finance and Admin - Additional Hours",null,null,null,null,"2608 - Finance and Admin - Additional Hours",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X166,1),\"\"))","v":0},{"$f":"IF(Y164=1,COUNTIF(Y$3:$Y164,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z164),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-12-26","04",12,null,null,null,null,null,null,null,null,null,null,null,2609,"Finance and Admin - Casual Holiday Pay",null,null,null,null,"2609 - Finance and Admin - Casual Holiday Pay",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X167,1),\"\"))","v":0},{"$f":"IF(Y165=1,COUNTIF(Y$3:$Y165,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z165),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-12-27","04",12,null,null,null,null,null,null,null,null,null,null,null,2610,"Finance and Admin - LGPS Main Scheme",null,null,null,null,"2610 - Finance and Admin - LGPS Main Scheme",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X168,1),\"\"))","v":0},{"$f":"IF(Y166=1,COUNTIF(Y$3:$Y166,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z166),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-12-28","04",12,null,null,null,null,null,null,null,null,null,null,null,2611,"Finance and Admin - Cash Safeguard",null,null,"",null,"2611 - Finance and Admin - Cash Safeguard",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X169,1),\"\"))","v":0},{"$f":"IF(Y167=1,COUNTIF(Y$3:$Y167,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z167),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-12-29","04",12,null,null,null,null,null,null,null,null,null,null,null,2612,"Finance and Admin - Pay Protection",null,null,"",null,"2612 - Finance and Admin - Pay Protection",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X170,1),\"\"))","v":0},{"$f":"IF(Y168=1,COUNTIF(Y$3:$Y168,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z168),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-12-30","04",12,null,null,null,null,null,null,null,null,null,null,null,2613,"Finance and Admin - Special Needs Resp",null,null,"",null,"2613 - Finance and Admin - Special Needs Resp",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X171,1),\"\"))","v":0},{"$f":"IF(Y169=1,COUNTIF(Y$3:$Y169,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z169),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2018-12-31","04",12,null,null,null,null,null,null,null,null,null,null,null,2615,"Finance and Admin - Overtime",null,null,"",null,"2615 - Finance and Admin - Overtime",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X172,1),\"\"))","v":0},{"$f":"IF(Y170=1,COUNTIF(Y$3:$Y170,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z170),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-01-01","05",1,null,null,null,null,null,null,null,null,null,null,null,2648,"Finance and Admin - Occ Sick Half",null,null,"",null,"2648 - Finance and Admin - Occ Sick Half",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X173,1),\"\"))","v":0},{"$f":"IF(Y171=1,COUNTIF(Y$3:$Y171,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z171),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-01-02","05",1,null,null,null,null,null,null,null,null,null,null,null,2649,"Finance and Admin - Statutory Charge",null,null,"",null,"2649 - Finance and Admin - Statutory Charge",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X174,1),\"\"))","v":0},{"$f":"IF(Y172=1,COUNTIF(Y$3:$Y172,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z172),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-01-03","05",1,null,null,null,null,null,null,null,null,null,null,null,2651,"Finance and Admin - Statutory Pension",null,null,"",null,"2651 - Finance and Admin - Statutory Pension",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X176,1),\"\"))","v":0},{"$f":"IF(Y173=1,COUNTIF(Y$3:$Y173,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z173),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-01-04","05",1,null,null,null,null,null,null,null,null,null,null,null,2652,"Finance and Admin - Statutory Recovery",null,null,null,null,"2652 - Finance and Admin - Statutory Recovery",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X179,1),\"\"))","v":0},{"$f":"IF(Y174=1,COUNTIF(Y$3:$Y174,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z174),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-01-05","05",1,null,null,null,null,null,null,null,null,null,null,null,2653,"Finance and Admin - PILON",null,null,"",null,"2653 - Finance and Admin - PILON",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X180,1),\"\"))","v":0},{"$f":"IF(Y175=1,COUNTIF(Y$3:$Y175,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z175),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-01-06","05",1,null,null,null,null,null,null,null,null,null,null,null,2900,"Agency Supply Cover",null,null,"",null,"2900 - Agency Supply Cover",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X181,1),\"\"))","v":0},{"$f":"IF(Y176=1,COUNTIF(Y$3:$Y176,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z176),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-01-07",{"$f":"VLOOKUP(F177,$D$3:$E$14,2,FALSE)","v":"05"},{"$f":"MONTH(D177)","v":1},null,null,null,null,null,null,null,null,null,null,null,2901,"Staff Recharges",null,null,"",null,"2901 - Staff Recharges",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X182,1),\"\"))","v":0},{"$f":"IF(Y177=1,COUNTIF(Y$3:$Y177,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z177),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-01-08","05",1,null,null,null,null,null,null,null,null,null,null,null,2902,"Staff Absence Insurance",null,null,"",null,"2902 - Staff Absence Insurance",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X183,1),\"\"))","v":0},{"$f":"IF(Y178=1,COUNTIF(Y$3:$Y178,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z178),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-01-09","05",1,null,null,null,null,null,null,null,null,null,null,null,2905,"Apprenticeship Levy",null,null,"",null,"2905 - Apprentice Levy",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X184,1),\"\"))","v":0},{"$f":"IF(Y179=1,COUNTIF(Y$3:$Y179,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z179),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-01-10","05",1,null,null,null,null,null,null,null,null,null,null,null,3000,"Repairs & Maintenance (Buildings)",null,null,"",null,"3000 - Repairs & Maintenance (Buildings)",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X185,1),\"\"))","v":0},{"$f":"IF(Y180=1,COUNTIF(Y$3:$Y180,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z180),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-01-11","05",1,null,null,null,null,null,null,null,null,null,null,null,3005,"Equipment Repairs and Maintenance",null,null,"",null,"3005 - Equipment Repairs and Maintenance",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X186,1),\"\"))","v":0},{"$f":"IF(Y181=1,COUNTIF(Y$3:$Y181,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z181),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-01-12","05",1,null,null,null,null,null,null,null,null,null,null,null,3010,"Grounds Maintenance",null,null,null,null,"3010 - Grounds Maintenance",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X187,1),\"\"))","v":0},{"$f":"IF(Y182=1,COUNTIF(Y$3:$Y182,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z182),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-01-13","05",1,null,null,null,null,null,null,null,null,null,null,null,3020,"PFI Charges",null,null,"",null,"3020 - PFI Charges",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X188,1),\"\"))","v":0},{"$f":"IF(Y183=1,COUNTIF(Y$3:$Y183,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z183),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-01-14","05",1,null,null,null,null,null,null,null,null,null,null,null,3041,"PAT Testing",null,null,"",null,"3041 - PAT Testing",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X189,1),\"\"))","v":0},{"$f":"IF(Y184=1,COUNTIF(Y$3:$Y184,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z184),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-01-15","05",1,null,null,null,null,null,null,null,null,null,null,null,3042,"Protective Clothing",null,null,"",null,"3042 - Protective Clothing",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X190,1),\"\"))","v":0},{"$f":"IF(Y185=1,COUNTIF(Y$3:$Y185,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z185),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-01-16","05",1,null,null,null,null,null,null,null,null,null,null,null,3100,"Caretaker Supplies",null,null,"",null,"3100 - Caretaker Supplies",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X191,1),\"\"))","v":0},{"$f":"IF(Y186=1,COUNTIF(Y$3:$Y186,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z186),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-01-17","05",1,null,null,null,null,null,null,null,null,null,null,null,3101,"Hygiene Services",null,null,"",null,"3101 - Hygiene Services",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X192,1),\"\"))","v":0},{"$f":"IF(Y187=1,COUNTIF(Y$3:$Y187,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z187),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-01-18","05",1,null,null,null,null,null,null,null,null,null,null,null,3102,"Cleaning Equipment",null,null,"",null,"3102 - Cleaning Equipment",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X193,1),\"\"))","v":0},{"$f":"IF(Y188=1,COUNTIF(Y$3:$Y188,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z188),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-01-19","05",1,null,null,null,null,null,null,null,null,null,null,null,3103,"Cleaning Materials",null,null,"",null,"3103 - Cleaning Materials",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X194,1),\"\"))","v":0},{"$f":"IF(Y189=1,COUNTIF(Y$3:$Y189,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z189),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-01-20","05",1,null,null,null,null,null,null,null,null,null,null,null,3104,"Window Cleaning",null,null,"",null,"3104 - Window Cleaning",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X195,1),\"\"))","v":0},{"$f":"IF(Y190=1,COUNTIF(Y$3:$Y190,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z190),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-01-21","05",1,null,null,null,null,null,null,null,null,null,null,null,3105,"Cleaning Contract",null,null,"",null,"3105 - Cleaning Contract",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X196,1),\"\"))","v":0},{"$f":"IF(Y191=1,COUNTIF(Y$3:$Y191,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z191),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-01-22","05",1,null,null,null,null,null,null,null,null,null,null,null,3200,"Water",null,null,"",null,"3200 - Water",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X197,1),\"\"))","v":0},{"$f":"IF(Y192=1,COUNTIF(Y$3:$Y192,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z192),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-01-23","05",1,null,null,null,null,null,null,null,null,null,null,null,3201,"Sewerage",null,null,"",null,"3201 - Sewerage",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X198,1),\"\"))","v":0},{"$f":"IF(Y193=1,COUNTIF(Y$3:$Y193,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z193),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-01-24","05",1,null,null,null,null,null,null,null,null,null,null,null,3205,"Gas",null,null,"",null,"3205 - Gas",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X199,1),\"\"))","v":0},{"$f":"IF(Y194=1,COUNTIF(Y$3:$Y194,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z194),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-01-25","05",1,null,null,null,null,null,null,null,null,null,null,null,3210,"Electricity",null,null,"",null,"3210 - Electricity",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X200,1),\"\"))","v":0},{"$f":"IF(Y195=1,COUNTIF(Y$3:$Y195,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z195),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-01-26","05",1,null,null,null,null,null,null,null,null,null,null,null,3215,"Oil",null,null,"",null,"3215 - Oil",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X201,1),\"\"))","v":0},{"$f":"IF(Y196=1,COUNTIF(Y$3:$Y196,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z196),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-01-27","05",1,null,null,null,null,null,null,null,null,null,null,null,3300,"Fire Alarm and Extinguishers",null,null,"",null,"3300 - Fire Alarm and Extinguishers",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X202,1),\"\"))","v":0},{"$f":"IF(Y197=1,COUNTIF(Y$3:$Y197,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z197),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-01-28","05",1,null,null,null,null,null,null,null,null,null,null,null,3301,"Pest Control",null,null,"",null,"3301 - Pest Control",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X203,1),\"\"))","v":0},{"$f":"IF(Y198=1,COUNTIF(Y$3:$Y198,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z198),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-01-29","05",1,null,null,null,null,null,null,null,null,null,null,null,3302,"Refuse Collection",null,null,"",null,"3302 - Refuse Collection",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X204,1),\"\"))","v":0},{"$f":"IF(Y199=1,COUNTIF(Y$3:$Y199,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z199),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-01-30","05",1,null,null,null,null,null,null,null,null,null,null,null,3400,"Medical Requisites",null,null,"",null,"3400 - Medical Requisites",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X205,1),\"\"))","v":0},{"$f":"IF(Y200=1,COUNTIF(Y$3:$Y200,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z200),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-01-31","05",1,null,null,null,null,null,null,null,null,null,null,null,3401,"Business Rates",null,null,"",null,"3401 - Business Rates",1,{"$f":"IF(Y201=1,COUNTIF(Y$3:$Y201,1),\"\")","v":8},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z201),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-02-01","06",2,null,null,null,null,null,null,null,null,null,null,null,3402,"Rent",null,null,"",null,"3402 - Rent",1,{"$f":"IF(Y202=1,COUNTIF(Y$3:$Y202,1),\"\")","v":9},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z202),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-02-02","06",2,null,null,null,null,null,null,null,null,null,null,null,3403,"Insurance",null,null,"",null,"3403 - Insurance",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X206,1),\"\"))","v":0},{"$f":"IF(Y203=1,COUNTIF(Y$3:$Y203,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z203),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-02-03","06",2,null,null,null,null,null,null,null,null,null,null,null,3500,"Security Alarm",null,null,"",null,"3500 - Security Alarm",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X207,1),\"\"))","v":0},{"$f":"IF(Y204=1,COUNTIF(Y$3:$Y204,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z204),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-02-04","06",2,null,null,null,null,null,null,null,null,null,null,null,3600,"Security Patrol",null,null,"",null,"3600 - Security Patrol",1,{"$f":"IF(Y205=1,COUNTIF(Y$3:$Y205,1),\"\")","v":10},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z205),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-02-05","06",2,null,null,null,null,null,null,null,null,null,null,null,3603,"Health and Safety",null,null,"",null,"3603 - Health and Safety",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X208,1),\"\"))","v":0},{"$f":"IF(Y206=1,COUNTIF(Y$3:$Y206,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z206),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-02-06","06",2,null,null,null,null,null,null,null,null,null,null,null,3604,"Swimming Pool",null,null,"",null,"3604 - Swimming Pool",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X209,1),\"\"))","v":0},{"$f":"IF(Y207=1,COUNTIF(Y$3:$Y207,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z207),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-02-07","06",2,null,null,null,null,null,null,null,null,null,null,null,4010,"Capitation",null,null,"",null,"4010 - Capitation",1,{"$f":"IF(Y208=1,COUNTIF(Y$3:$Y208,1),\"\")","v":11},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z208),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-02-08","06",2,null,null,null,null,null,null,null,null,null,null,null,4025,"Photocopying",null,null,null,null,"4025 - Photocopying",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X210,1),\"\"))","v":0},{"$f":"IF(Y209=1,COUNTIF(Y$3:$Y209,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z209),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-02-09","06",2,null,null,null,null,null,null,null,null,null,null,null,4045,"Furniture",null,null,"",null,"4045 - Furniture",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X211,1),\"\"))","v":0},{"$f":"IF(Y210=1,COUNTIF(Y$3:$Y210,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z210),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-02-10","06",2,null,null,null,null,null,null,null,null,null,null,null,4050,"Student Rewards",null,null,"",null,"4050 - Student Rewards",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X212,1),\"\"))","v":0},{"$f":"IF(Y211=1,COUNTIF(Y$3:$Y211,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z211),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-02-11","06",2,null,null,null,null,null,null,null,null,null,null,null,4051,"School Uniform",null,null,"",null,"4051 - School Uniform",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X213,1),\"\"))","v":0},{"$f":"IF(Y212=1,COUNTIF(Y$3:$Y212,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z212),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-02-12","06",2,null,null,null,null,null,null,null,null,null,null,null,4125,"Minibus Costs",null,null,"",null,"4125 - Minibus Costs",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X214,1),\"\"))","v":0},{"$f":"IF(Y213=1,COUNTIF(Y$3:$Y213,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z213),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-02-13","06",2,null,null,null,null,null,null,null,null,null,null,null,4126,"Vehicle Hire",null,null,"",null,"4126 - Vehicle Hire",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X215,1),\"\"))","v":0},{"$f":"IF(Y214=1,COUNTIF(Y$3:$Y214,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z214),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-02-14","06",2,null,null,null,null,null,null,null,null,null,null,null,4127,"Taxis",null,null,"",null,"4127 - Taxis",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X216,1),\"\"))","v":0},{"$f":"IF(Y215=1,COUNTIF(Y$3:$Y215,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z215),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-02-15","06",2,null,null,null,null,null,null,null,null,null,null,null,4135,"Professional Services - Educational (working directly with pupils)",null,null,null,null,"4135 - Professional Services - Educational",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X217,1),\"\"))","v":0},{"$f":"IF(Y216=1,COUNTIF(Y$3:$Y216,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z216),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-02-16","06",2,null,null,null,null,null,null,null,null,null,null,null,4150,"Examination Fees",null,null,"",null,"4150 - Examination Fees",1,{"$f":"IF(Y217=1,COUNTIF(Y$3:$Y217,1),\"\")","v":12},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z217),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-02-17","06",2,null,null,null,null,null,null,null,null,null,null,null,5010,"Catering Equipment",null,null,"",null,"5010 - Catering Equipment",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X218,1),\"\"))","v":0},{"$f":"IF(Y218=1,COUNTIF(Y$3:$Y218,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z218),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-02-18","06",2,null,null,null,null,null,null,null,null,null,null,null,5013,"Catering (School Meals)",null,null,"",null,"5013 - Catering (School Meals)",1,{"$f":"IF(Y219=1,COUNTIF(Y$3:$Y219,1),\"\")","v":13},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z219),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-02-19","06",2,null,null,null,null,null,null,null,null,null,null,null,5015,"Catering Consumables",null,null,"",null,"5015 - Catering Supplies",1,{"$f":"IF(Y220=1,COUNTIF(Y$3:$Y220,1),\"\")","v":14},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z220),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-02-20","06",2,null,null,null,null,null,null,null,null,null,null,null,5100,"Fixed Line Communications",null,null,"",null,"5100 - Fixed Line Communications",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X219,1),\"\"))","v":0},{"$f":"IF(Y221=1,COUNTIF(Y$3:$Y221,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z221),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-02-21","06",2,null,null,null,null,null,null,null,null,null,null,null,5105,"Mobile Communications",null,null,"",null,"5105 - Mobile Communications",1,{"$f":"IF(Y222=1,COUNTIF(Y$3:$Y222,1),\"\")","v":15},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z222),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-02-22","06",2,null,null,null,null,null,null,null,null,null,null,null,5111,"Subscriptions",null,null,"",null,"5111 - Subscriptions",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X220,1),\"\"))","v":0},{"$f":"IF(Y223=1,COUNTIF(Y$3:$Y223,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z223),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-02-23","06",2,null,null,null,null,null,null,null,null,null,null,null,5112,"IT Hardware",null,null,"",null,"5112 - IT Hardware",1,{"$f":"IF(Y224=1,COUNTIF(Y$3:$Y224,1),\"\")","v":16},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z224),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-02-24","06",2,null,null,null,null,null,null,null,null,null,null,null,5113,"IT Software and Licences",null,null,"",null,"5113 - IT Software and Licences",1,{"$f":"IF(Y225=1,COUNTIF(Y$3:$Y225,1),\"\")","v":17},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z225),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-02-25","06",2,null,null,null,null,null,null,null,null,null,null,null,5114,"IT Consumables",null,null,"",null,"5114 - IT Consumables",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X221,1),\"\"))","v":0},{"$f":"IF(Y226=1,COUNTIF(Y$3:$Y226,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z226),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-02-26","06",2,null,null,null,null,null,null,null,null,null,null,null,5117,"IT Service Agreements",null,null,"",null,"5117 - IT Service Agreements",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X222,1),\"\"))","v":0},{"$f":"IF(Y227=1,COUNTIF(Y$3:$Y227,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z227),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-02-27","06",2,null,null,null,null,null,null,null,null,null,null,null,5118,"Broadband",null,null,"",null,"5118 - Broadband",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X223,1),\"\"))","v":0},{"$f":"IF(Y228=1,COUNTIF(Y$3:$Y228,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z228),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-02-28","06",2,null,null,null,null,null,null,null,null,null,null,null,5140,"Professional Services - Non Educational (not working directly with pupils)",null,null,"",null,"5140 - Professional Services - Non Educational",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X224,1),\"\"))","v":0},{"$f":"IF(Y229=1,COUNTIF(Y$3:$Y229,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z229),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-03-01","07",3,null,null,null,null,null,null,null,null,null,null,null,5155,"Bank Charges",null,null,"",null,"5155 - Bank Charges",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X225,1),\"\"))","v":0},{"$f":"IF(Y230=1,COUNTIF(Y$3:$Y230,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z230),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-03-02","07",3,null,null,null,null,null,null,null,null,null,null,null,5205,"Postage",null,null,"",null,"5205 - Postage",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X226,1),\"\"))","v":0},{"$f":"IF(Y231=1,COUNTIF(Y$3:$Y231,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z231),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-03-03","07",3,null,null,null,null,null,null,null,null,null,null,null,5206,"Stationery",null,null,"",null,"5206 - Stationery",1,{"$f":"IF(Y232=1,COUNTIF(Y$3:$Y232,1),\"\")","v":18},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z232),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-03-04","07",3,null,null,null,null,null,null,null,null,null,null,null,5207,"General Office Expenses",null,null,"",null,"5207 - General Office Expenses",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X227,1),\"\"))","v":0},{"$f":"IF(Y233=1,COUNTIF(Y$3:$Y233,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z233),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-03-05","07",3,null,null,null,null,null,null,null,null,null,null,null,5315,"Staff Advertising",null,null,"",null,"5315 - Staff Advertising",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X228,1),\"\"))","v":0},{"$f":"IF(Y234=1,COUNTIF(Y$3:$Y234,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z234),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-03-06","07",3,null,null,null,null,null,null,null,null,null,null,null,5415,"Governance Service",null,null,"",null,"5415 - Governance Service",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X229,1),\"\"))","v":0},{"$f":"IF(Y235=1,COUNTIF(Y$3:$Y235,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z235),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-03-07","07",3,null,null,null,null,null,null,null,null,null,null,null,5416,"Governing Body Clerking Service",null,null,null,null,"5416 - Governing Body Clerking Service",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X230,1),\"\"))","v":0},{"$f":"IF(Y236=1,COUNTIF(Y$3:$Y236,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z236),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-03-08","07",3,null,null,null,null,null,null,null,null,null,null,null,5417,"Human Resources",null,null,"",null,"5417 - Human Resources",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X231,1),\"\"))","v":0},{"$f":"IF(Y237=1,COUNTIF(Y$3:$Y237,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z237),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-03-09","07",3,null,null,null,null,null,null,null,null,null,null,null,5418,"Legal Services",null,null,"",null,"5418 - Legal Services",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X232,1),\"\"))","v":0},{"$f":"IF(Y238=1,COUNTIF(Y$3:$Y238,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z238),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-03-10","07",3,null,null,null,null,null,null,null,null,null,null,null,5424,"Marketing and Communication",null,null,"",null,"5424 - Marketing and Communication",{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X233,1),\"\"))","v":0},{"$f":"IF(Y239=1,COUNTIF(Y$3:$Y239,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z239),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-03-11","07",3,null,null,null,null,null,null,null,null,null,null,null,5425,"Payroll",null,null,"",null,"5425 - Payroll",1,{"$f":"IF(Y240=1,COUNTIF(Y$3:$Y240,1),\"\")","v":19},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z240),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-03-12",{"$f":"VLOOKUP(F241,$D$3:$E$14,2,FALSE)","v":"07"},{"$f":"MONTH(D241)","v":3},null,null,null,null,null,null,null,null,null,null,null,5427,"Services to Schools (bought in LA services)",null,null,"",null,"5427 - Services to Schools",1,{"$f":"IF(Y241=1,COUNTIF(Y$3:$Y241,1),\"\")","v":20},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z241),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-03-13","07",3,null,null,null,null,null,null,null,null,null,null,null,5500,"Top Slice For Ebor Centralised Services",null,null,"",null,"5500 - Top Slice For Ebor Centralised Services",1,{"$f":"IF(Y242=1,COUNTIF(Y$3:$Y242,1),\"\")","v":21},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z242),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-03-14","07",3,null,null,null,null,null,null,null,null,null,null,null,5700,"Training Course Fees",null,null,"",null,"5700 - Training Course Fees",1,{"$f":"IF(Y243=1,COUNTIF(Y$3:$Y243,1),\"\")","v":22},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z243),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-03-15","07",3,null,null,null,null,null,null,null,null,null,null,null,5701,"Training Course Hospitality",null,null,"",null,"5701 - Training Course Hospitality",1,{"$f":"IF(Y244=1,COUNTIF(Y$3:$Y244,1),\"\")","v":23},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z244),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-03-16","07",3,null,null,null,null,null,null,null,null,null,null,null,5900,"External Audit",null,null,"",null,"5900 - External Audit",1,{"$f":"IF(Y245=1,COUNTIF(Y$3:$Y245,1),\"\")","v":24},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z245),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-03-17","07",3,null,null,null,null,null,null,null,null,null,null,null,6100,"Staff Travel",null,null,"",null,"6100 - Staff Travel",1,{"$f":"IF(Y246=1,COUNTIF(Y$3:$Y246,1),\"\")","v":25},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z246),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-03-18","07",3,null,null,null,null,null,null,null,null,null,null,null,6101,"Staff Accommodation",null,null,"",null,"6101 - Staff Accommodation",1,{"$f":"IF(Y247=1,COUNTIF(Y$3:$Y247,1),\"\")","v":26},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z247),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-03-19","07",3,null,null,null,null,null,null,null,null,null,null,null,6102,"Staff Subsistence",null,null,"",null,"6102 - Staff Subsistence",1,{"$f":"IF(Y248=1,COUNTIF(Y$3:$Y248,1),\"\")","v":27},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z248),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-03-20","07",3,null,null,null,null,null,null,null,null,null,null,null,6500,"Trips Travel Costs",null,null,"",null,"6500 - Trips Travel Costs",1,{"$f":"IF(Y249=1,COUNTIF(Y$3:$Y249,1),\"\")","v":28},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z249),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-03-21","07",3,null,null,null,null,null,null,null,null,null,null,null,6520,"Trips Accommodation and / or Entrance",null,null,"",null,"6520 - Trips Accommodation and / or Entrance",1,{"$f":"IF(Y250=1,COUNTIF(Y$3:$Y250,1),\"\")","v":29},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z250),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-03-22","07",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X251,1),\"\"))","v":0},{"$f":"IF(Y251=1,COUNTIF(Y$3:$Y251,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z251),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-03-23","07",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X252,1),\"\"))","v":0},{"$f":"IF(Y252=1,COUNTIF(Y$3:$Y252,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z252),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-03-24","07",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X253,1),\"\"))","v":0},{"$f":"IF(Y253=1,COUNTIF(Y$3:$Y253,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z253),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-03-25","07",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X254,1),\"\"))","v":0},{"$f":"IF(Y254=1,COUNTIF(Y$3:$Y254,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z254),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-03-26","07",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,{"$f":"IF(Y255=1,COUNTIF(Y$3:$Y255,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z255),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-03-27","07",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,{"$f":"IF(Y256=1,COUNTIF(Y$3:$Y256,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z256),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-03-28","07",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X257,1),\"\"))","v":0},{"$f":"IF(Y257=1,COUNTIF(Y$3:$Y257,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z257),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-03-29","07",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,{"$f":"IF(Y258=1,COUNTIF(Y$3:$Y258,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z258),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-03-30","07",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,{"$f":"IF(Y259=1,COUNTIF(Y$3:$Y259,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z259),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-03-31","07",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,{"$f":"IF(Y260=1,COUNTIF(Y$3:$Y260,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z260),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-04-01","08",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,{"$f":"IF(Y261=1,COUNTIF(Y$3:$Y261,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z261),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-04-02","08",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X262,1),\"\"))","v":0},{"$f":"IF(Y262=1,COUNTIF(Y$3:$Y262,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z262),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-04-03","08",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Y263=1,COUNTIF(Y$3:$Y263,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z263),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-04-04","08",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X264,1),\"\"))","v":0},{"$f":"IF(Y264=1,COUNTIF(Y$3:$Y264,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z264),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-04-05","08",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Y265=1,COUNTIF(Y$3:$Y265,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z265),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-04-06","08",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Y266=1,COUNTIF(Y$3:$Y266,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z266),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-04-07","08",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Y267=1,COUNTIF(Y$3:$Y267,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z267),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-04-08","08",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X268,1),\"\"))","v":0},{"$f":"IF(Y268=1,COUNTIF(Y$3:$Y268,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z268),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-04-09","08",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Y269=1,COUNTIF(Y$3:$Y269,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z269),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-04-10","08",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X270,1),\"\"))","v":0},{"$f":"IF(Y270=1,COUNTIF(Y$3:$Y270,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z270),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-04-11","08",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X271,1),\"\"))","v":0},{"$f":"IF(Y271=1,COUNTIF(Y$3:$Y271,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z271),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-04-12","08",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X272,1),\"\"))","v":0},{"$f":"IF(Y272=1,COUNTIF(Y$3:$Y272,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z272),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-04-13","08",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X273,1),\"\"))","v":0},{"$f":"IF(Y273=1,COUNTIF(Y$3:$Y273,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z273),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-04-14","08",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"--ISNUMBER(IFERROR(SEARCH(#REF!,X274,1),\"\"))","v":0},{"$f":"IF(Y274=1,COUNTIF(Y$3:$Y274,1),\"\")","v":""},{"$f":"IFERROR(INDEX($X$3:$X$274,MATCH(ROWS(Z$3:$Z274),$Z$3:$Z$274,0)),\"\")","v":""}]
[null,null,null,"2019-04-15","08",4]
[null,null,null,"2019-04-16","08",4]
[null,null,null,"2019-04-17","08",4]
[null,null,null,"2019-04-18","08",4]
[null,null,null,"2019-04-19","08",4]
[null,null,null,"2019-04-20","08",4]
[null,null,null,"2019-04-21","08",4]
[null,null,null,"2019-04-22","08",4]
[null,null,null,"2019-04-23","08",4]
[null,null,null,"2019-04-24","08",4]
[null,null,null,"2019-04-25","08",4]
[null,null,null,"2019-04-26","08",4]
[null,null,null,"2019-04-27","08",4]
[null,null,null,"2019-04-28","08",4]
[null,null,null,"2019-04-29","08",4]
[null,null,null,"2019-04-30","08",4]
[null,null,null,"2019-05-01","09",5]
[null,null,null,"2019-05-02","09",5]
[null,null,null,"2019-05-03","09",5]
[null,null,null,"2019-05-04","09",5]
[null,null,null,"2019-05-05","09",5]
[null,null,null,"2019-05-06","09",5]
[null,null,null,"2019-05-07","09",5]
[null,null,null,"2019-05-08","09",5]
[null,null,null,"2019-05-09","09",5]
[null,null,null,"2019-05-10","09",5]
[null,null,null,"2019-05-11","09",5]
[null,null,null,"2019-05-12","09",5]
[null,null,null,"2019-05-13","09",5]
[null,null,null,"2019-05-14","09",5]
[null,null,null,"2019-05-15",{"$f":"VLOOKUP(F305,$D$3:$E$14,2,FALSE)","v":"09"},{"$f":"MONTH(D305)","v":5}]
[null,null,null,"2019-05-16","09",5]
[null,null,null,"2019-05-17","09",5]
[null,null,null,"2019-05-18","09",5]
[null,null,null,"2019-05-19","09",5]
[null,null,null,"2019-05-20","09",5]
[null,null,null,"2019-05-21","09",5]
[null,null,null,"2019-05-22","09",5]
[null,null,null,"2019-05-23","09",5]
[null,null,null,"2019-05-24","09",5]
[null,null,null,"2019-05-25","09",5]
[null,null,null,"2019-05-26","09",5]
[null,null,null,"2019-05-27","09",5]
[null,null,null,"2019-05-28","09",5]
[null,null,null,"2019-05-29","09",5]
[null,null,null,"2019-05-30","09",5]
[null,null,null,"2019-05-31","09",5]
[null,null,null,"2019-06-01","10",6]
[null,null,null,"2019-06-02","10",6]
[null,null,null,"2019-06-03","10",6]
[null,null,null,"2019-06-04","10",6]
[null,null,null,"2019-06-05","10",6]
[null,null,null,"2019-06-06","10",6]
[null,null,null,"2019-06-07","10",6]
[null,null,null,"2019-06-08","10",6]
[null,null,null,"2019-06-09","10",6]
[null,null,null,"2019-06-10","10",6]
[null,null,null,"2019-06-11","10",6]
[null,null,null,"2019-06-12","10",6]
[null,null,null,"2019-06-13","10",6]
[null,null,null,"2019-06-14","10",6]
[null,null,null,"2019-06-15","10",6]
[null,null,null,"2019-06-16","10",6]
[null,null,null,"2019-06-17","10",6]
[null,null,null,"2019-06-18","10",6]
[null,null,null,"2019-06-19","10",6]
[null,null,null,"2019-06-20","10",6]
[null,null,null,"2019-06-21","10",6]
[null,null,null,"2019-06-22","10",6]
[null,null,null,"2019-06-23","10",6]
[null,null,null,"2019-06-24","10",6]
[null,null,null,"2019-06-25","10",6]
[null,null,null,"2019-06-26","10",6]
[null,null,null,"2019-06-27","10",6]
[null,null,null,"2019-06-28","10",6]
[null,null,null,"2019-06-29","10",6]
[null,null,null,"2019-06-30","10",6]
[null,null,null,"2019-07-01","11",7]
[null,null,null,"2019-07-02","11",7]
[null,null,null,"2019-07-03","11",7]
[null,null,null,"2019-07-04","11",7]
[null,null,null,"2019-07-05","11",7]
[null,null,null,"2019-07-06","11",7]
[null,null,null,"2019-07-07","11",7]
[null,null,null,"2019-07-08","11",7]
[null,null,null,"2019-07-09","11",7]
[null,null,null,"2019-07-10","11",7]
[null,null,null,"2019-07-11","11",7]
[null,null,null,"2019-07-12","11",7]
[null,null,null,"2019-07-13","11",7]
[null,null,null,"2019-07-14","11",7]
[null,null,null,"2019-07-15","11",7]
[null,null,null,"2019-07-16","11",7]
[null,null,null,"2019-07-17","11",7]
[null,null,null,"2019-07-18",{"$f":"VLOOKUP(F369,$D$3:$E$14,2,FALSE)","v":"11"},{"$f":"MONTH(D369)","v":7}]
[null,null,null,"2019-07-19","11",7]
[null,null,null,"2019-07-20","11",7]
[null,null,null,"2019-07-21","11",7]
[null,null,null,"2019-07-22","11",7]
[null,null,null,"2019-07-23","11",7]
[null,null,null,"2019-07-24","11",7]
[null,null,null,"2019-07-25","11",7]
[null,null,null,"2019-07-26","11",7]
[null,null,null,"2019-07-27","11",7]
[null,null,null,"2019-07-28","11",7]
[null,null,null,"2019-07-29","11",7]
[null,null,null,"2019-07-30","11",7]
[null,null,null,"2019-07-31","11",7]
[null,null,null,"2019-08-01","12",8]
[null,null,null,"2019-08-02","12",8]
[null,null,null,"2019-08-03","12",8]
[null,null,null,"2019-08-04","12",8]
[null,null,null,"2019-08-05","12",8]
[null,null,null,"2019-08-06","12",8]
[null,null,null,"2019-08-07","12",8]
[null,null,null,"2019-08-08","12",8]
[null,null,null,"2019-08-09","12",8]
[null,null,null,"2019-08-10","12",8]
[null,null,null,"2019-08-11","12",8]
[null,null,null,"2019-08-12","12",8]
[null,null,null,"2019-08-13","12",8]
[null,null,null,"2019-08-14","12",8]
[null,null,null,"2019-08-15","12",8]
[null,null,null,"2019-08-16","12",8]
[null,null,null,"2019-08-17","12",8]
[null,null,null,"2019-08-18","12",8]
[null,null,null,"2019-08-19","12",8]
[null,null,null,"2019-08-20","12",8]
[null,null,null,"2019-08-21","12",8]
[null,null,null,"2019-08-22","12",8]
[null,null,null,"2019-08-23","12",8]
[null,null,null,"2019-08-24","12",8]
[null,null,null,"2019-08-25","12",8]
[null,null,null,"2019-08-26","12",8]
[null,null,null,"2019-08-27","12",8]
[null,null,null,"2019-08-28","12",8]
[null,null,null,"2019-08-29","12",8]
[null,null,null,"2019-08-30","12",8]
[null,null,null,"2019-08-31","12",8]
[null,null,null,"2019-09-01","01",9]