{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Form","Data"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Form","index":0,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":false,"merged":[[32,7,32,8],[21,5,22,9],[32,1,32,2],[33,1,33,2],[32,5,32,6],[33,5,33,6],[17,1,17,2],[9,1,9,3],[14,1,14,3],[0,1,0,5],[4,1,4,2],[5,1,5,2],[2,1,2,2],[7,1,7,2],[3,1,3,2],[8,1,8,2],[16,1,16,2],[15,1,15,2],[20,1,20,2],[21,1,21,2],[18,1,18,2],[19,1,19,2],[22,1,22,2]]}
[null,"Sales Invoice Request Form"]
[]
[null,"Requested By"]
[null,"Job Title",null,null,null,null,null,null,null,"Password = Pete"]
[null,"Location"]
[null,"Today's Date"]
[null,"Contact Details:"]
[null,"Contact Name"]
[null,"Company / Organisation Name"]
[null,"Contact Address:       "]
[null,null,"Address Line 1"]
[null,null,"Address Line 2"]
[null,null,"City"]
[null,null,"Post Code"]
[]
[null,"Contact Telephone Number"]
[null,"Contact Email Address"]
[null,"Invoice Details:"]
[null,"Nominal Code"]
[null,"Account Code"]
[null,"Total Cost",null,0,null,"Comments (For information only)"]
[null,"Reason for Invoice"]
[null,"Authorised by"]
[]
[null,"Item\nNo.","Supplier's Purchase\nOrder Number","Description of Item / Service","Dates / Times\n(If applicable)","Quantity","Unit","Net Cost\n(£)","VAT\n(£)","Total Cost\n(£)"]
[null,1,null,null,null,null,null,0,0,{"$f":"SUM(H26:I26)","v":0}]
[null,2,null,null,null,null,null,0,0,{"$f":"SUM(H27:I27)","v":0}]
[null,3,null,null,null,null,null,0,0,0]
[null,4,null,null,null,null,null,0,0,0]
[null,5,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H26:H30)","v":0},{"$f":"SUM(I26:I30)","v":0},{"$f":"SUM(J26:J30)","v":0},{"$f":"IF(D21-J31=0,\"\",\"Does not Balance\")","v":""}]
[null,"Finance Use Only"]
[null,"Raised By",null,null,"Date",null,null,"Receipts / Contract Attached"]
[null,"Job Title",null,null,"Submitted"]

{"sheet":"Data","index":1,"n_rows":414,"n_cols":12,"rows_kept":414,"cut":false,"hidden":true,"merged":[[0,3,0,5]]}
["Location Codes",null,null,"Period",null,null,null,"New Nominal","Nominal Title",null,"New Account","Description"]
[null,null,null,"Fin. Period","Calendar Mth"]
["ACS","Alderman Cogan's Church of England Primary Academy",null,9,"01","September",null,"1000 - GAG Funding Pupil Lead","GAG Funding Pupil Lead",null,"ASC001 - After School Club","After School Club"]
["BBS","Brotherton and Byram Primary Academy",null,10,"02","October",null,"1001 - Educational Services Grant","Educational Services Grant",null,"BRE001 - Breakfast Club","Breakfast Club"]
["CAM","Camblesforth Community Primary Academy",null,11,"03","November",null,"1002 - High Needs Funding","High Needs Funding",null,"CAT001 - Catering","Catering"]
["EAS","Easington CE Primary Academy",null,12,"04","December",null,"1004 - Infant Class Size Funding","Infant Class Size Funding",null,"CPD001 - Staff Development","Staff Development"]
["EBO","Ebor Academy Trust",null,1,"05","January",null,"1005 - Free School Meals","Free School Meal Funding",null,"EMS001 - Enhanced Mainstream School","Enhanced Mainstream School"]
["FIS","Filey CoE Nursery and Infants Academy",null,2,"06","February",null,"1006 - RPA Contribution","RPA Contribution",null,"EYR001 - Early Years","Early Years"]
["FLY","Ebor Academy Filey",null,3,"07","March",null,"1007 - Minimum Funding Guarantee","Minimum Funding Guarantee",null,"KS1001 - KS1","KS1"]
["HMO","Hob Moor Oaks Academy",null,4,"08","April",null,"1008 - Lump Sum Funding","Lump Sum Funding",null,"KS2001 - Lower KS2","Lower KS2"]
["HMS","Hob Moor Primary Academy",null,5,"09","May",null,"1051 - PE Grant","PE Grant",null,"KS2002 - Upper KS2","Upper KS2"]
["HRS","Haxby Road Primary Academy",null,6,"10","June",null,"1052 - School Improvement","School Improvement",null,"ICT001 - IT","Information Technology"]
["LAK","Lakeside Primary School",null,7,"11","July",null,"1081 - Pupil Premium","Pupil Premium",null,"NQT001 - Newly Qualified Teachers","Newly Qualified Teachers"]
["MAR","Marfleet Primary School",null,8,"12","August",null,"1083 - Start Up Grant (A)","Start Up Grant (A)",null,"NUR001 - Nursery / Preschool","Nursery / Preschool (3&4 Year Olds)"]
["OSB","Osbaldwick Primary School",null,null,null,null,null,"1084 - Start Up Grant (B)","Start Up Grant (B)",null,"PEG001 - PE Grant","PE Grant"]
["PAT","Patrington CE Primary Academy",null,"Date","Fin. Period","Calendar Mth",null,"1087 - Other ESFA Grants","Other ESFA Grants",null,"PPR001 - Pupil Premium","Pupil Premium"]
["PGS","Park Grove Primary Academy",null,"2017-07-31",{"$f":"VLOOKUP(F17,$D$3:$E$14,2,FALSE)","v":"11"},{"$f":"MONTH(D17)","v":7},null,"1095 - SEN","SEN",null,"PRE001 - Premises","Premises"]
["RWS","Robert Wilkinson Primary Academy",null,"2017-08-01",{"$f":"VLOOKUP(F18,$D$3:$E$14,2,FALSE)","v":"12"},{"$f":"MONTH(D18)","v":8},null,"1097 - Other LA Grants","Other LA Grants",null,"SCH001 - Main School","Main School"]
["SHS","Staynor Hall Community Primary Academy",null,"2017-08-02",{"$f":"VLOOKUP(F19,$D$3:$E$14,2,FALSE)","v":"12"},{"$f":"MONTH(D19)","v":8},null,"1100 - Donations and / or Voluntary Funds","Donations and / or Voluntary Funds",null,"SDW001 - Schools Direct","Schools Direct"]
["SIG","Sigglesthorne CofE Primary Academy",null,"2017-08-03",{"$f":"VLOOKUP(F20,$D$3:$E$14,2,FALSE)","v":"12"},{"$f":"MONTH(D20)","v":8},null,"1101 - Breakfast Club","Breakfast Club",null,"SEN001 - SEN","SEN"]
["SPR","Sproatley Endowed Chuch of England Academy",null,"2017-08-04",{"$f":"VLOOKUP(F21,$D$3:$E$14,2,FALSE)","v":"12"},{"$f":"MONTH(D21)","v":8},null,"1102 - After School Club","After School Club",null,"NLC001 - Yr7 Numeracy and Literacy Catchup","Yr7 Numeracy and Literacy Catchup"]
["TOC","Tockwith Church of England Primary Academy",null,"2017-08-05",{"$f":"VLOOKUP(F22,$D$3:$E$14,2,FALSE)","v":"12"},{"$f":"MONTH(D22)","v":8},null,"1103 - Funds Inherited on Conversion","Funds Inherited on Conversion",null,"SFD001 - School Fund (Legacy)","School Fund (Legacy)"]
[null,null,null,"2017-08-06","12",8,null,"1104 - Nursery / Preschool","Nursery / Preschool",null,"STS001 - School To School Support","School To School Support"]
[null,null,null,"2017-08-07","12",8,null,"1105 - Lettings and Room Hire","Lettings and Room Hire",null,"TNY001 - Tiny Steps","Tiny Steps (2 Year Olds)"]
[null,null,null,"2017-08-08","12",8,null,"1106 - Transport Income","Transport Income",null,"TRP001 - School Trips","School Trips"]
[null,null,null,"2017-08-09","12",8,null,"1108 - Sales of Other Goods and Services","Sales of Other Goods and Services",null,"ART001 - Art","Art"]
[null,null,null,"2017-08-10","12",8,null,"1109 - Music Services","Music Services",null,"ASS001 - Assessment","Assessment"]
[null,null,null,"2017-08-11","12",8,null,"1112 - Catering","Catering Income",null,"DAT001 - Design and Technology","Design and Technology"]
[null,null,null,"2017-08-12","12",8,null,"1114 - Trip Income","Trip Income",null,"DRA001 - Drama","Drama"]
[null,null,null,"2017-08-13","12",8,null,"1115 - Staff Consultancy / Recharges","Staff Consultancy / Recharges",null,"DUK001 - Duke of Edinburgh Award Scheme","Duke of Edinburgh Award Scheme"]
[null,null,null,"2017-08-14","12",8,null,"1116 - Training Course Fees","Training Course Income",null,"ENG001 - English","English"]
[null,null,null,"2017-08-15","12",8,null,"1126 - Yr7 Numeracy & Literacy Catchup","Yr7 Numeracy and Literacy Catchup",null,"FOT001 - Food Technology","Food Technology"]
[null,null,null,"2017-08-16","12",8,null,"1127 - Department / Subject Income","Department / Subject Income",null,"GEO001 - Geography","Geography"]
[null,null,null,"2017-08-17","12",8,null,"1140 - Uniforms Income","School Uniform Income",null,"HIS001 - History","History"]
[null,null,null,"2017-08-18","12",8,null,"1150 - Sponsor Income","Sponsor Income",null,"HUM001 - Humanities","Humanities"]
[null,null,null,"2017-08-19","12",8,null,"1160 - School Direct","School Direct",null,"ITB001 - Information Technology and Business","Information Technology and Business"]
["Credit Card Numbers",null,null,"2017-08-20","12",8,null,"1165 - Other Grants","Other Grants",null,"LIB001 - Library","Library"]
["BBS","4273426200590130",null,"2017-08-21","12",8,null,"1170 - School to School Support","School to School Support",null,"MAT001 - Mathematics","Mathematics"]
["EBO","4273425200141118",null,"2017-08-22","12",8,null,"1200 - Bank Interest","Bank Interest",null,"MFL001 - Modern Foreign Languages","Modern Foreign Languages"]
["FLY","4715320621445741",null,"2017-08-23","12",8,null,"2000 - Teachers - Normal Pay","Teachers - Normal Pay",null,"MUS001 - Music","Music"]
["HRS","4273425200139492",null,"2017-08-24","12",8,null,"2001 - Teachers - Supply Teacher Pay","Teachers - Supply Teacher Pay",null,"PAS001 - Pastoral","Pastoral"]
["RWS","4273425200139450",null,"2017-08-25","12",8,null,"2002 - Teachers - Holiday Pay","Teachers - Holiday Pay",null,"PHY001 - Physical Education","Physical Education"]
[null,null,null,"2017-08-26","12",8,null,"2003 - Teachers - ET Teachers Pension ER","Teachers - ET Teachers Pension ER",null,"REG001 - Religious Education","Religious Education"]
["VAT Receipt?",null,null,"2017-08-27","12",8,null,"2004 - Teachers - Childcare Vouchers","Teachers - Childcare Vouchers",null,"SCI001 - Science","Science"]
[null,null,null,"2017-08-28","12",8,null,"2005 - Teachers - Employers NI","Teachers - Employers NI",null,"SLT001 - Senior Leadership Team","Senior Leadership Team"]
["Yes",null,null,"2017-08-29","12",8,null,"2006 - Teachers - Living Wage","Teachers - Living Wage",null,"WRL001 - Work Related Learning","Work Related Learning"]
["No",null,null,"2017-08-30","12",8,null,"2007 - Teachers - Monetary diff","Teachers - Monetary diff"]
[null,null,null,"2017-08-31","12",8,null,"2008 - Teachers - Additional Hours","Teachers - Additional Hours"]
["Invoice Submitted",null,null,"2017-09-01","01",9,null,"2009 - Teachers - Casual Holiday Pay","Teachers - Casual Holiday Pay"]
[null,null,null,"2017-09-02","01",9,null,"2010 - Teachers - LGPS Main Scheme","Teachers - LGPS Main Scheme"]
["Post",null,null,"2017-09-03","01",9,null,"2011 - Teachers - Cash Safeguard","Teachers - Cash Safeguard"]
["Email",null,null,"2017-09-04","01",9,null,"2012 - Teachers - Pay Protection","Teachers - Pay Protection"]
["Hand Delivered",null,null,"2017-09-05","01",9,null,"2013 - Teachers - Special Needs Resp","Teachers - Special Needs Resp"]
["Other",null,null,"2017-09-06","01",9,null,"2014 - Teachers - TLR2 Payment","Teachers - TLR2 Payment"]
[null,null,null,"2017-09-07","01",9,null,"2015 - Teachers - Overtime","Teachers - Overtime"]
[null,null,null,"2017-09-08","01",9,null,"2048 - Teachers - Occ Sick Half","Teachers - Occ Sick Half"]
[null,null,null,"2017-09-09","01",9,null,"2049 - Teachers - Statutory Charge","Teachers - Statutory Charge"]
[null,null,null,"2017-09-10","01",9,null,"2051 - Teachers - Statutory Pension","Teachers - Statutory Pension"]
[null,null,null,"2017-09-11","01",9,null,"2052 - Teachers - Statutory Recovery","Teachers - Statutory Recovery"]
[null,null,null,"2017-09-12","01",9,null,"2053 - Teachers - PILON","Teachers - PILON"]
[null,null,null,"2017-09-13","01",9,null,"2100 - Technicians - Normal Pay","Technicians - Normal Pay"]
[null,null,null,"2017-09-14","01",9,null,"2101 - Technicians - Supply Teacher Pay","Technicians - Supply Teacher Pay"]
[null,null,null,"2017-09-15","01",9,null,"2102 - Technicians - Holiday Pay","Technicians - Holiday Pay"]
[null,null,null,"2017-09-16","01",9,null,"2104 - Technicians - Childcare Vouchers","Technicians - Childcare Vouchers"]
[null,null,null,"2017-09-17","01",9,null,"2105 - Technicians - Employers NI","Technicians - Employers NI"]
[null,null,null,"2017-09-18","01",9,null,"2106 - Technicians - Living Wage","Technicians - Living Wage"]
[null,null,null,"2017-09-19","01",9,null,"2107 - Technicians - Monetary diff","Technicians - Monetary diff"]
[null,null,null,"2017-09-20","01",9,null,"2108 - Technicians - Additional Hours","Technicians - Additional Hours"]
[null,null,null,"2017-09-21","01",9,null,"2109 - Technicians - Casual Holiday Pay","Technicians - Casual Holiday Pay"]
[null,null,null,"2017-09-22","01",9,null,"2110 - Technicians - LGPS Main Scheme","Technicians - LGPS Main Scheme"]
[null,null,null,"2017-09-23","01",9,null,"2111 - Technicians - Cash Safeguard","Technicians - Cash Safeguard"]
[null,null,null,"2017-09-24","01",9,null,"2112 - Technicians - Pay Protection","Technicians - Pay Protection"]
[null,null,null,"2017-09-25","01",9,null,"2113 - Technicians - Special Needs Resp","Technicians - Special Needs Resp"]
[null,null,null,"2017-09-26","01",9,null,"2115 - Technicians - Overtime","Technicians - Overtime"]
[null,null,null,"2017-09-27","01",9,null,"2148 - Technicians - Occ Sick Half","Technicians - Occ Sick Half"]
[null,null,null,"2017-09-28","01",9,null,"2149 - Technicians - Statutory Charge","Technicians - Statutory Charge"]
[null,null,null,"2017-09-29","01",9,null,"2151 - Technicians - Statutory Pension","Technicians - Statutory Pension"]
[null,null,null,"2017-09-30","01",9,null,"2152 - Technicians - Statutory Recovery","Technicians - Statutory Recovery"]
[null,null,null,"2017-10-01","02",10,null,"2153 - Technicians - PILON","Technicians - PILON"]
[null,null,null,"2017-10-02","02",10,null,"2200 - Teaching Assistants - Normal Pay","Teaching Assistants - Normal Pay"]
[null,null,null,"2017-10-03","02",10,null,"2201 - Teaching Assistants - Supply Teacher Pay","Teaching Assistants - Supply Teacher Pay"]
[null,null,null,"2017-10-04","02",10,null,"2202 - Teaching Assistants - Holiday Pay","Teaching Assistants - Holiday Pay"]
[null,null,null,"2017-10-05","02",10,null,"2203 - Teaching Assistants - ET Teachers Pensio","Teaching Assistants - ET Teachers Pensio"]
[null,null,null,"2017-10-06","02",10,null,"2204 - Teaching Assistants - Childcare Vouchers","Teaching Assistants - Childcare Vouchers"]
[null,null,null,"2017-10-07","02",10,null,"2205 - Teaching Assistants - Employers NI","Teaching Assistants - Employers NI"]
[null,null,null,"2017-10-08",{"$f":"VLOOKUP(F86,$D$3:$E$14,2,FALSE)","v":"02"},{"$f":"MONTH(D86)","v":10},null,"2206 - Teaching Assistants - Living Wage","Teaching Assistants - Living Wage"]
[null,null,null,"2017-10-09","02",10,null,"2207 - Teaching Assistants - Monetary diff","Teaching Assistants - Monetary diff"]
[null,null,null,"2017-10-10","02",10,null,"2208 - Teaching Assistants - Additional Hours","Teaching Assistants - Additional Hours"]
[null,null,null,"2017-10-11","02",10,null,"2209 - Teaching Assistants - Casual Holiday Pay","Teaching Assistants - Casual Holiday Pay"]
[null,null,null,"2017-10-12","02",10,null,"2210 - Teaching Assistants - LGPS Main Scheme","Teaching Assistants - LGPS Main Scheme"]
[null,null,null,"2017-10-13","02",10,null,"2211 - Teaching Assistants - Cash Safeguard","Teaching Assistants - Cash Safeguard"]
[null,null,null,"2017-10-14","02",10,null,"2212 - Teaching Assistants - Pay Protection","Teaching Assistants - Pay Protection"]
[null,null,null,"2017-10-15","02",10,null,"2213 - Teaching Assistants - Special Needs Resp","Teaching Assistants - Special Needs Resp"]
[null,null,null,"2017-10-16","02",10,null,"2215 - Teaching Assistants - Overtime","Teaching Assistants - Overtime"]
[null,null,null,"2017-10-17","02",10,null,"2248 - Teaching Assistants - Occ Sick Half","Teaching Assistants - Occ Sick Half"]
[null,null,null,"2017-10-18","02",10,null,"2249 - Teaching Assistants - Statutory Charge","Teaching Assistants - Statutory Charge"]
[null,null,null,"2017-10-19","02",10,null,"2251 - Teaching Assistants - Statutory Pension","Teaching Assistants - Statutory Pension"]
[null,null,null,"2017-10-20","02",10,null,"2252 - Teaching Assistants - Statutory Recovery","Teaching Assistants - Statutory Recovery"]
[null,null,null,"2017-10-21","02",10,null,"2253 - Teaching Assistants - PILON","Teaching Assistants - PILON"]
[null,null,null,"2017-10-22","02",10,null,"2300 - Premises Staff - Normal Pay","Premises Staff - Normal Pay"]
[null,null,null,"2017-10-23","02",10,null,"2301 - Premises Staff - Supply Teacher Pay","Premises Staff - Supply Teacher Pay"]
[null,null,null,"2017-10-24","02",10,null,"2302 - Premises Staff - Holiday Pay","Premises Staff - Holiday Pay"]
[null,null,null,"2017-10-25","02",10,null,"2304 - Premises Staff - Childcare Vouchers","Premises Staff - Childcare Vouchers"]
[null,null,null,"2017-10-26","02",10,null,"2305 - Premises Staff - Employers NI","Premises Staff - Employers NI"]
[null,null,null,"2017-10-27","02",10,null,"2306 - Premises Staff - Living Wage","Premises Staff - Living Wage"]
[null,null,null,"2017-10-28","02",10,null,"2307 - Premises Staff - Monetary diff","Premises Staff - Monetary diff"]
[null,null,null,"2017-10-29","02",10,null,"2308 - Premises Staff - Additional Hours","Premises Staff - Additional Hours"]
[null,null,null,"2017-10-30","02",10,null,"2309 - Premises Staff - Casual Holiday Pay","Premises Staff - Casual Holiday Pay"]
[null,null,null,"2017-10-31","02",10,null,"2310 - Premises Staff - LGPS Main Scheme","Premises Staff - LGPS Main Scheme"]
[null,null,null,"2017-11-01","03",11,null,"2311 - Premises Staff - Cash Safeguard","Premises Staff - Cash Safeguard"]
[null,null,null,"2017-11-02","03",11,null,"2312 - Premises Staff - Pay Protection","Premises Staff - Pay Protection"]
[null,null,null,"2017-11-03","03",11,null,"2313 - Premises Staff - Special Needs Resp","Premises Staff - Special Needs Resp"]
[null,null,null,"2017-11-04","03",11,null,"2315 - Premises Staff - Overtime","Premises Staff - Overtime"]
[null,null,null,"2017-11-05","03",11,null,"2348 - Premises Staff - Occ Sick Half","Premises Staff - Occ Sick Half"]
[null,null,null,"2017-11-06","03",11,null,"2349 - Premises Staff - Statutory Charge","Premises Staff - Statutory Charge"]
[null,null,null,"2017-11-07","03",11,null,"2351 - Premises Staff - Statutory Pension","Premises Staff - Statutory Pension"]
[null,null,null,"2017-11-08","03",11,null,"2352 - Premises Staff - Statutory Recovery","Premises Staff - Statutory Recovery"]
[null,null,null,"2017-11-09","03",11,null,"2353 - Premises Staff - PILON","Premises Staff - PILON"]
[null,null,null,"2017-11-10","03",11,null,"2400 - Midday Supervisor - Normal Pay","Midday Supervisor - Normal Pay"]
[null,null,null,"2017-11-11","03",11,null,"2401 - Midday Supervisor - Supply Teacher Pay","Midday Supervisor - Supply Teacher Pay"]
[null,null,null,"2017-11-12","03",11,null,"2402 - Midday Supervisor - Holiday Pay","Midday Supervisor - Holiday Pay"]
[null,null,null,"2017-11-13","03",11,null,"2404 - Midday Supervisor - Childcare Vouchers","Midday Supervisor - Childcare Vouchers"]
[null,null,null,"2017-11-14","03",11,null,"2405 - Midday Supervisor - Employers NI","Midday Supervisor - Employers NI"]
[null,null,null,"2017-11-15","03",11,null,"2406 - Midday Supervisor - Living Wage","Midday Supervisor - Living Wage"]
[null,null,null,"2017-11-16","03",11,null,"2407 - Midday Supervisor - Monetary diff","Midday Supervisor - Monetary diff"]
[null,null,null,"2017-11-17","03",11,null,"2408 - Midday Supervisor - Additional Hours","Midday Supervisor - Additional Hours"]
[null,null,null,"2017-11-18","03",11,null,"2409 - Midday Supervisor - Casual Holiday Pay","Midday Supervisor - Casual Holiday Pay"]
[null,null,null,"2017-11-19","03",11,null,"2410 - Midday Supervisor - LGPS Main Scheme","Midday Supervisor - LGPS Main Scheme"]
[null,null,null,"2017-11-20","03",11,null,"2411 - Midday Supervisor - Cash Safeguard","Midday Supervisor - Cash Safeguard"]
[null,null,null,"2017-11-21","03",11,null,"2412 - Midday Supervisor - Pay Protection","Midday Supervisor - Pay Protection"]
[null,null,null,"2017-11-22","03",11,null,"2413 - Midday Supervisor - Special Needs Resp","Midday Supervisor - Special Needs Resp"]
[null,null,null,"2017-11-23","03",11,null,"2415 - Midday Supervisor - Overtime","Midday Supervisor - Overtime"]
[null,null,null,"2017-11-24","03",11,null,"2416 - Midday Supervisor - Occ Sick Half","Midday Supervisor - Occ Sick Half"]
[null,null,null,"2017-11-25","03",11,null,"2449 - Midday Supervisor - Statutory Charge","Midday Supervisor - Statutory Charge"]
[null,null,null,"2017-11-26","03",11,null,"2451 - Midday Supervisor - Statutory Pension","Midday Supervisor - Statutory Pension"]
[null,null,null,"2017-11-27","03",11,null,"2452 - Midday Supervisor - Statutory Recovery","Midday Supervisor - Statutory Recovery"]
[null,null,null,"2017-11-28","03",11,null,"2453 - Midday Supervisor - PILON","Midday Supervisor - PILON"]
[null,null,null,"2017-11-29","03",11,null,"2500 - Other Staff - Normal Pay","Other Staff - Normal Pay"]
[null,null,null,"2017-11-30","03",11,null,"2501 - Other Staff - Supply Teacher Pay","Other Staff - Supply Teacher Pay"]
[null,null,null,"2017-12-01","04",12,null,"2502 - Other Staff - Holiday Pay on Leaving","Other Staff - Holiday Pay"]
[null,null,null,"2017-12-02","04",12,null,"2504 - Other Staff - Childcare Vouchers","Other Staff - Childcare Vouchers"]
[null,null,null,"2017-12-03","04",12,null,"2505 - Other Staff - Employers NI","Other Staff - Employers NI"]
[null,null,null,"2017-12-04","04",12,null,"2506 - Other Staff - Living Wage","Other Staff - Living Wage"]
[null,null,null,"2017-12-05","04",12,null,"2507 - Other Staff - Monetary diff","Other Staff - Monetary diff"]
[null,null,null,"2017-12-06","04",12,null,"2508 - Other Staff - Additional Hours","Other Staff - Additional Hours"]
[null,null,null,"2017-12-07","04",12,null,"2509 - Other Staff - Casual Holiday Pay","Other Staff - Casual Holiday Pay"]
[null,null,null,"2017-12-08","04",12,null,"2510 - Other Staff - LGPS Main Scheme","Other Staff - LGPS Main Scheme"]
[null,null,null,"2017-12-09","04",12,null,"2511 - Other Staff - Cash Safeguard","Other Staff - Cash Safeguard"]
[null,null,null,"2017-12-10","04",12,null,"2512 - Other Staff - Pay Protection","Other Staff - Pay Protection"]
[null,null,null,"2017-12-11",{"$f":"VLOOKUP(F150,$D$3:$E$14,2,FALSE)","v":"04"},{"$f":"MONTH(D150)","v":12},null,"2513 - Other Staff - Special Needs Resp","Other Staff - Special Needs Resp"]
[null,null,null,"2017-12-12","04",12,null,"2515 - Other Staff - Overtime","Other Staff - Overtime"]
[null,null,null,"2017-12-13","04",12,null,"2516 - Other Staff - Occ Sick Half","Other Staff - Occ Sick Half"]
[null,null,null,"2017-12-14","04",12,null,"2549 - Other Staff - Statutory Charge","Other Staff - Statutory Charge"]
[null,null,null,"2017-12-15","04",12,null,"2551 - Other Staff - Statutory Pension","Other Staff - Statutory Pension"]
[null,null,null,"2017-12-16","04",12,null,"2552 - Other Staff - Statutory Recovery","Other Staff - Statutory Recovery"]
[null,null,null,"2017-12-17","04",12,null,"2553 - Other Staff PILON","Other Staff - PILON"]
[null,null,null,"2017-12-18","04",12,null,"2600 - Finance and Admin - Normal Pay","Finance and Admin - Normal Pay"]
[null,null,null,"2017-12-19","04",12,null,"2601 - Finance and Admin - Supply Teacher Pay","Finance and Admin - Supply Teacher Pay"]
[null,null,null,"2017-12-20","04",12,null,"2602 - Finance and Admin - Holiday Pay","Finance and Admin - Holiday Pay"]
[null,null,null,"2017-12-21","04",12,null,"2604 - Finance and Admin - Childcare Vouchers","Finance and Admin - Childcare Vouchers"]
[null,null,null,"2017-12-22","04",12,null,"2605 - Finance and Admin - Employers NI","Finance and Admin - Employers NI"]
[null,null,null,"2017-12-23","04",12,null,"2606 - Finance and Admin - Living Wage","Finance and Admin - Living Wage"]
[null,null,null,"2017-12-24","04",12,null,"2607 - Finance and Admin - Monetary diff","Finance and Admin - Monetary diff"]
[null,null,null,"2017-12-25","04",12,null,"2608 - Finance and Admin - Additional Hours","Finance and Admin - Additional Hours"]
[null,null,null,"2017-12-26","04",12,null,"2609 - Finance and Admin - Casual Holiday Pay","Finance and Admin - Casual Holiday Pay"]
[null,null,null,"2017-12-27","04",12,null,"2610 - Finance and Admin - LGPS Main Scheme","Finance and Admin - LGPS Main Scheme"]
[null,null,null,"2017-12-28","04",12,null,"2611 - Finance and Admin - Cash Safeguard","Finance and Admin - Cash Safeguard"]
[null,null,null,"2017-12-29","04",12,null,"2612 - Finance and Admin - Pay Protection","Finance and Admin - Pay Protection"]
[null,null,null,"2017-12-30","04",12,null,"2613 - Finance and Admin - Special Needs Resp","Finance and Admin - Special Needs Resp"]
[null,null,null,"2017-12-31","04",12,null,"2615 - Finance and Admin - Overtime","Finance and Admin - Overtime"]
[null,null,null,"2018-01-01","05",1,null,"2648 - Finance and Admin - Occ Sick Half","Finance and Admin - Occ Sick Half"]
[null,null,null,"2018-01-02","05",1,null,"2649 - Finance and Admin - Statutory Charge","Finance and Admin - Statutory Charge"]
[null,null,null,"2018-01-03","05",1,null,"2651 - Finance and Admin - Statutory Pension","Finance and Admin - Statutory Pension"]
[null,null,null,"2018-01-04","05",1,null,"2652 - Finance and Admin - Statutory Recovery","Finance and Admin - Statutory Recovery"]
[null,null,null,"2018-01-05","05",1,null,"2653 - Finance and Admin - PILON","Finance and Admin - PILON"]
[null,null,null,"2018-01-06","05",1,null,"2900 - Agency Supply Cover","Agency Supply Cover"]
[null,null,null,"2018-01-07","05",1,null,"2901 - Staff Recharges","Staff Recharges"]
[null,null,null,"2018-01-08","05",1,null,"2902 - Staff Absence Insurance","Staff Absence Insurance"]
[null,null,null,"2018-01-09","05",1,null,"2905 - Apprentice Levy","Apprenticeship Levy"]
[null,null,null,"2018-01-10","05",1,null,"3000 - Repairs & Maintenance (Buildings)","Repairs & Maintenance (Buildings)"]
[null,null,null,"2018-01-11","05",1,null,"3005 - Equipment Repairs and Maintenance","Equipment Repairs and Maintenance"]
[null,null,null,"2018-01-12","05",1,null,"3010 - Grounds Maintenance","Grounds Maintenance"]
[null,null,null,"2018-01-13","05",1,null,"3020 - PFI Charges","PFI Charges"]
[null,null,null,"2018-01-14","05",1,null,"3041 - PAT Testing","PAT Testing"]
[null,null,null,"2018-01-15","05",1,null,"3042 - Protective Clothing","Protective Clothing"]
[null,null,null,"2018-01-16","05",1,null,"3100 - Caretaker Supplies","Caretaker Supplies"]
[null,null,null,"2018-01-17","05",1,null,"3101 - Hygiene Services","Hygiene Services"]
[null,null,null,"2018-01-18","05",1,null,"3102 - Cleaning Equipment","Cleaning Equipment"]
[null,null,null,"2018-01-19","05",1,null,"3103 - Cleaning Materials","Cleaning Materials"]
[null,null,null,"2018-01-20","05",1,null,"3104 - Window Cleaning","Window Cleaning"]
[null,null,null,"2018-01-21","05",1,null,"3105 - Cleaning Contract","Cleaning Contract"]
[null,null,null,"2018-01-22","05",1,null,"3200 - Water","Water"]
[null,null,null,"2018-01-23","05",1,null,"3201 - Sewerage","Sewerage"]
[null,null,null,"2018-01-24","05",1,null,"3205 - Gas","Gas"]
[null,null,null,"2018-01-25","05",1,null,"3210 - Electricity","Electricity"]
[null,null,null,"2018-01-26","05",1,null,"3215 - Oil","Oil"]
[null,null,null,"2018-01-27","05",1,null,"3300 - Fire Alarm and Extinguishers","Fire Alarm and Extinguishers"]
[null,null,null,"2018-01-28","05",1,null,"3301 - Pest Control","Pest Control"]
[null,null,null,"2018-01-29","05",1,null,"3302 - Refuse Collection","Refuse Collection"]
[null,null,null,"2018-01-30","05",1,null,"3400 - Medical Requisites","Medical Requisites"]
[null,null,null,"2018-01-31","05",1,null,"3401 - Business Rates","Business Rates"]
[null,null,null,"2018-02-01","06",2,null,"3402 - Rent","Rent"]
[null,null,null,"2018-02-02","06",2,null,"3403 - Insurance","Insurance"]
[null,null,null,"2018-02-03","06",2,null,"3500 - Security Alarm","Security Alarm"]
[null,null,null,"2018-02-04","06",2,null,"3600 - Security Patrol","Security Patrol"]
[null,null,null,"2018-02-05","06",2,null,"3603 - Health and Safety","Health and Safety"]
[null,null,null,"2018-02-06","06",2,null,"3604 - Swimming Pool","Swimming Pool"]
[null,null,null,"2018-02-07","06",2,null,"4010 - Capitation","Capitation"]
[null,null,null,"2018-02-08","06",2,null,"4025 - Photocopying","Photocopying"]
[null,null,null,"2018-02-09","06",2,null,"4045 - Furniture","Furniture"]
[null,null,null,"2018-02-10","06",2,null,"4050 - Student Rewards","Student Rewards"]
[null,null,null,"2018-02-11","06",2,null,"4051 - School Uniform","School Uniform"]
[null,null,null,"2018-02-12","06",2,null,"4125 - Minibus Costs","Minibus Costs"]
[null,null,null,"2018-02-13",{"$f":"VLOOKUP(F214,$D$3:$E$14,2,FALSE)","v":"06"},{"$f":"MONTH(D214)","v":2},null,"4126 - Vehicle Hire","Vehicle Hire"]
[null,null,null,"2018-02-14","06",2,null,"4127 - Taxis","Taxis"]
[null,null,null,"2018-02-15","06",2,null,"4135 - Professional Services - Educational","Professional Services - Educational (working directly with pupils)"]
[null,null,null,"2018-02-16","06",2,null,"4150 - Examination Fees","Examination Fees"]
[null,null,null,"2018-02-17","06",2,null,"5010 - Catering Equipment","Catering Equipment"]
[null,null,null,"2018-02-18","06",2,null,"5013 - Catering (School Meals)","Catering (School Meals)"]
[null,null,null,"2018-02-19","06",2,null,"5015 - Catering Supplies","Catering Consumables"]
[null,null,null,"2018-02-20","06",2,null,"5100 - Fixed Line Communications","Fixed Line Communications"]
[null,null,null,"2018-02-21","06",2,null,"5105 - Mobile Communications","Mobile Communications"]
[null,null,null,"2018-02-22","06",2,null,"5111 - Subscriptions","Subscriptions"]
[null,null,null,"2018-02-23","06",2,null,"5112 - IT Hardware","IT Hardware"]
[null,null,null,"2018-02-24","06",2,null,"5113 - IT Software and Licences","IT Software and Licences"]
[null,null,null,"2018-02-25","06",2,null,"5114 - IT Consumables","IT Consumables"]
[null,null,null,"2018-02-26","06",2,null,"5117 - IT Service Agreements","IT Service Agreements"]
[null,null,null,"2018-02-27","06",2,null,"5118 - Broadband","Broadband"]
[null,null,null,"2018-02-28","06",2,null,"5140 - Professional Services - Non Educational","Professional Services - Non Educational (not working directly with pupils)"]
[null,null,null,"2018-03-01","07",3,null,"5155 - Bank Charges","Bank Charges"]
[null,null,null,"2018-03-02","07",3,null,"5205 - Postage","Postage"]
[null,null,null,"2018-03-03","07",3,null,"5206 - Stationery","Stationery"]
[null,null,null,"2018-03-04","07",3,null,"5207 - General Office Expenses","General Office Expenses"]
[null,null,null,"2018-03-05","07",3,null,"5315 - Staff Advertising","Staff Advertising"]
[null,null,null,"2018-03-06","07",3,null,"5415 - Governance Service","Governance Service"]
[null,null,null,"2018-03-07","07",3,null,"5416 - Governing Body Clerking Service","Governing Body Clerking Service"]
[null,null,null,"2018-03-08","07",3,null,"5417 - Human Resources","Human Resources"]
[null,null,null,"2018-03-09","07",3,null,"5418 - Legal Services","Legal Services"]
[null,null,null,"2018-03-10","07",3,null,"5424 - Marketing and Communication","Marketing and Communication"]
[null,null,null,"2018-03-11","07",3,null,"5425 - Payroll","Payroll"]
[null,null,null,"2018-03-12","07",3,null,"5427 - Services to Schools","Services to Schools (bought in LA services)"]
[null,null,null,"2018-03-13","07",3,null,"5500 - Top Slice For Ebor Centralised Services","Top Slice For Ebor Centralised Services"]
[null,null,null,"2018-03-14","07",3,null,"5700 - Training Course Fees","Training Course Fees"]
[null,null,null,"2018-03-15","07",3,null,"5701 - Training Course Hospitality","Training Course Hospitality"]
[null,null,null,"2018-03-16","07",3,null,"5900 - External Audit","External Audit"]
[null,null,null,"2018-03-17","07",3,null,"6100 - Staff Travel","Staff Travel"]
[null,null,null,"2018-03-18","07",3,null,"6101 - Staff Accommodation","Staff Accommodation"]
[null,null,null,"2018-03-19","07",3,null,"6102 - Staff Subsistence","Staff Subsistence"]
[null,null,null,"2018-03-20","07",3,null,"6500 - Trips Travel Costs","Trips Travel Costs"]
[null,null,null,"2018-03-21","07",3,null,"6520 - Trips Accommodation and / or Entrance","Trips Accommodation and / or Entrance"]
[null,null,null,"2018-03-22","07",3]
[null,null,null,"2018-03-23","07",3]
[null,null,null,"2018-03-24","07",3]
[null,null,null,"2018-03-25","07",3]
[null,null,null,"2018-03-26","07",3]
[null,null,null,"2018-03-27","07",3]
[null,null,null,"2018-03-28","07",3]
[null,null,null,"2018-03-29","07",3]
[null,null,null,"2018-03-30","07",3]
[null,null,null,"2018-03-31","07",3]
[null,null,null,"2018-04-01","08",4]
[null,null,null,"2018-04-02","08",4]
[null,null,null,"2018-04-03","08",4]
[null,null,null,"2018-04-04","08",4]
[null,null,null,"2018-04-05","08",4]
[null,null,null,"2018-04-06","08",4]
[null,null,null,"2018-04-07","08",4]
[null,null,null,"2018-04-08","08",4]
[null,null,null,"2018-04-09","08",4]
[null,null,null,"2018-04-10","08",4]
[null,null,null,"2018-04-11","08",4]
[null,null,null,"2018-04-12","08",4]
[null,null,null,"2018-04-13","08",4]
[null,null,null,"2018-04-14","08",4]
[null,null,null,"2018-04-15","08",4]
[null,null,null,"2018-04-16","08",4]
[null,null,null,"2018-04-17","08",4]
[null,null,null,"2018-04-18",{"$f":"VLOOKUP(F278,$D$3:$E$14,2,FALSE)","v":"08"},{"$f":"MONTH(D278)","v":4}]
[null,null,null,"2018-04-19","08",4]
[null,null,null,"2018-04-20","08",4]
[null,null,null,"2018-04-21","08",4]
[null,null,null,"2018-04-22","08",4]
[null,null,null,"2018-04-23","08",4]
[null,null,null,"2018-04-24","08",4]
[null,null,null,"2018-04-25","08",4]
[null,null,null,"2018-04-26","08",4]
[null,null,null,"2018-04-27","08",4]
[null,null,null,"2018-04-28","08",4]
[null,null,null,"2018-04-29","08",4]
[null,null,null,"2018-04-30","08",4]
[null,null,null,"2018-05-01","09",5]
[null,null,null,"2018-05-02","09",5]
[null,null,null,"2018-05-03","09",5]
[null,null,null,"2018-05-04","09",5]
[null,null,null,"2018-05-05","09",5]
[null,null,null,"2018-05-06","09",5]
[null,null,null,"2018-05-07","09",5]
[null,null,null,"2018-05-08","09",5]
[null,null,null,"2018-05-09","09",5]
[null,null,null,"2018-05-10","09",5]
[null,null,null,"2018-05-11","09",5]
[null,null,null,"2018-05-12","09",5]
[null,null,null,"2018-05-13","09",5]
[null,null,null,"2018-05-14","09",5]
[null,null,null,"2018-05-15","09",5]
[null,null,null,"2018-05-16","09",5]
[null,null,null,"2018-05-17","09",5]
[null,null,null,"2018-05-18","09",5]
[null,null,null,"2018-05-19","09",5]
[null,null,null,"2018-05-20","09",5]
[null,null,null,"2018-05-21","09",5]
[null,null,null,"2018-05-22","09",5]
[null,null,null,"2018-05-23","09",5]
[null,null,null,"2018-05-24","09",5]
[null,null,null,"2018-05-25","09",5]
[null,null,null,"2018-05-26","09",5]
[null,null,null,"2018-05-27","09",5]
[null,null,null,"2018-05-28","09",5]
[null,null,null,"2018-05-29","09",5]
[null,null,null,"2018-05-30","09",5]
[null,null,null,"2018-05-31","09",5]
[null,null,null,"2018-06-01","10",6]
[null,null,null,"2018-06-02","10",6]
[null,null,null,"2018-06-03","10",6]
[null,null,null,"2018-06-04","10",6]
[null,null,null,"2018-06-05","10",6]
[null,null,null,"2018-06-06","10",6]
[null,null,null,"2018-06-07","10",6]
[null,null,null,"2018-06-08","10",6]
[null,null,null,"2018-06-09","10",6]
[null,null,null,"2018-06-10","10",6]
[null,null,null,"2018-06-11","10",6]
[null,null,null,"2018-06-12","10",6]
[null,null,null,"2018-06-13","10",6]
[null,null,null,"2018-06-14","10",6]
[null,null,null,"2018-06-15","10",6]
[null,null,null,"2018-06-16","10",6]
[null,null,null,"2018-06-17","10",6]
[null,null,null,"2018-06-18","10",6]
[null,null,null,"2018-06-19","10",6]
[null,null,null,"2018-06-20","10",6]
[null,null,null,"2018-06-21",{"$f":"VLOOKUP(F342,$D$3:$E$14,2,FALSE)","v":"10"},{"$f":"MONTH(D342)","v":6}]
[null,null,null,"2018-06-22","10",6]
[null,null,null,"2018-06-23","10",6]
[null,null,null,"2018-06-24","10",6]
[null,null,null,"2018-06-25","10",6]
[null,null,null,"2018-06-26","10",6]
[null,null,null,"2018-06-27","10",6]
[null,null,null,"2018-06-28","10",6]
[null,null,null,"2018-06-29","10",6]
[null,null,null,"2018-06-30","10",6]
[null,null,null,"2018-07-01","11",7]
[null,null,null,"2018-07-02","11",7]
[null,null,null,"2018-07-03","11",7]
[null,null,null,"2018-07-04","11",7]
[null,null,null,"2018-07-05","11",7]
[null,null,null,"2018-07-06","11",7]
[null,null,null,"2018-07-07","11",7]
[null,null,null,"2018-07-08","11",7]
[null,null,null,"2018-07-09","11",7]
[null,null,null,"2018-07-10","11",7]
[null,null,null,"2018-07-11","11",7]
[null,null,null,"2018-07-12","11",7]
[null,null,null,"2018-07-13","11",7]
[null,null,null,"2018-07-14","11",7]
[null,null,null,"2018-07-15","11",7]
[null,null,null,"2018-07-16","11",7]
[null,null,null,"2018-07-17","11",7]
[null,null,null,"2018-07-18","11",7]
[null,null,null,"2018-07-19","11",7]
[null,null,null,"2018-07-20","11",7]
[null,null,null,"2018-07-21","11",7]
[null,null,null,"2018-07-22","11",7]
[null,null,null,"2018-07-23","11",7]
[null,null,null,"2018-07-24","11",7]
[null,null,null,"2018-07-25","11",7]
[null,null,null,"2018-07-26","11",7]
[null,null,null,"2018-07-27","11",7]
[null,null,null,"2018-07-28","11",7]
[null,null,null,"2018-07-29","11",7]
[null,null,null,"2018-07-30","11",7]
[null,null,null,"2018-07-31","11",7]
[null,null,null,"2018-08-01","12",8]
[null,null,null,"2018-08-02","12",8]
[null,null,null,"2018-08-03","12",8]
[null,null,null,"2018-08-04","12",8]
[null,null,null,"2018-08-05","12",8]
[null,null,null,"2018-08-06","12",8]
[null,null,null,"2018-08-07","12",8]
[null,null,null,"2018-08-08","12",8]
[null,null,null,"2018-08-09","12",8]
[null,null,null,"2018-08-10","12",8]
[null,null,null,"2018-08-11","12",8]
[null,null,null,"2018-08-12","12",8]
[null,null,null,"2018-08-13","12",8]
[null,null,null,"2018-08-14","12",8]
[null,null,null,"2018-08-15","12",8]
[null,null,null,"2018-08-16","12",8]
[null,null,null,"2018-08-17","12",8]
[null,null,null,"2018-08-18","12",8]
[null,null,null,"2018-08-19","12",8]
[null,null,null,"2018-08-20","12",8]
[null,null,null,"2018-08-21","12",8]
[null,null,null,"2018-08-22","12",8]
[null,null,null,"2018-08-23","12",8]
[null,null,null,"2018-08-24",{"$f":"VLOOKUP(F406,$D$3:$E$14,2,FALSE)","v":"12"},{"$f":"MONTH(D406)","v":8}]
[null,null,null,"2018-08-25","12",8]
[null,null,null,"2018-08-26","12",8]
[null,null,null,"2018-08-27","12",8]
[null,null,null,"2018-08-28","12",8]
[null,null,null,"2018-08-29","12",8]
[null,null,null,"2018-08-30","12",8]
[null,null,null,"2018-08-31","12",8]
[null,null,null,"2018-09-01","01",9]