{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Appendix 1- Actuals Bud Share","Appendix 2- Actuals for Grants","Appendix 3- Summary"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":130,"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":"Appendix 1- Actuals Bud Share","index":0,"n_rows":115,"n_cols":14,"rows_kept":115,"cut":false,"hidden":false,"merged":[]}
[null,null,"Actuals for Budget Share as at 09/07/2021"]
["Cfr2","Cfr2 (T)","Account","Account (T)","Costc","Actuals","Original Budget","Virements","Revised Budget","Variance (Actuals-Revised Budget)","% Spent","Forecast","Forecast Variance","Links to reports"]
["E01","Teaching Staff","A10005","Teachers Basic Pay","S31600",134009.25,556588,0,556588,-422578.75,{"$f":"IFERROR(F3/I3,0)*100","v":24.076920451033796},0,-556588]
["E01","Teaching Staff","A12005","Teachers Ers NI","S31600",13835.86,58955,0,58955,-45119.14,{"$f":"IFERROR(F4/I4,0)*100","v":23.468509880417269},0,-58955]
["E01","Teaching Staff","A13005","Teachers Ers Pension Conts","S31600",29971.919999999998,126897,0,126897,-96925.08,23.619092649944442,0,-126897]
["E01","Teaching Staff","A14005","Teachers Allowances","S31600",4066.19,20136,0,20136,-16069.81,20.193633293603497,0,-20136]
["E01","Teaching Staff","","","",{"$f":"SUBTOTAL(9, F3:F6)","v":181883.21999999997},762576,0,762576,-580692.78,23.851159753257374,0,-762576]
["E03","Education Support Staff","A10080","Learning Support Assistants Basic Pay","S31600",42411.11,171841,0,171841,-129429.89,24.680437148294061,0,-171841]
["E03","Education Support Staff","A10115","Support Worker Basic Pay","S31600",0,9436,0,9436,-9436,0,0,-9436]
["E03","Education Support Staff","A12080","Learning Support Assistants Ers NI","S31600",2332.52,8970,0,8970,-6637.48,26.003567447045704,0,-8970]
["E03","Education Support Staff","A12115","Support Worker Ers NI","S31600",0,591,0,591,-591,0,0,-591]
["E03","Education Support Staff","A13080","Learning Support Assistants Ers Pens Conts","S31600",11035.86,46010,0,46010,-34974.14,23.985785698761138,0,-46010]
["E03","Education Support Staff","A13115","Support Worker Ers Pension Conts","S31600",0,2444,0,2444,-2444,0,0,-2444]
["E03","Education Support Staff","A14080","Learning Support Assistants Allowances","S31600",5032.54,5800,0,5800,-767.46,86.767931034482757,0,-5800]
["E03","Education Support Staff","","","",{"$f":"SUBTOTAL(9, F8:F14)","v":60812.03},245092,0,245092,-184279.97,24.811919605699085,0,-245092]
["E04","Premises Staff","A10105","Caretakers & Cleaners Basic Pay","S31600",10023.42,40094,0,40094,-30070.58,24.999800468898091,0,-40094]
["E04","Premises Staff","A12105","Caretakers & Cleaners Ers NI","S31600",685.48,2456,0,2456,-1770.52,27.910423452768729,0,-2456]
["E04","Premises Staff","A13105","Caretakers & Cleaners Ers Pension Conts","S31600",2650.3,10515,0,10515,-7864.7,25.204945316214932,0,-10515]
["E04","Premises Staff","A14105","Caretakers & Cleaners Allowances","S31600",209.4,1400,0,1400,-1190.5999999999999,14.957142857142857,0,-1400]
["E04","Premises Staff","","","",{"$f":"SUBTOTAL(9, F16:F19)","v":13568.6},54465,0,54465,-40896.400000000001,24.912512622785275,0,-54465]
["E05","Administrative & Clerical Staff","A10120","Clerk to Governors Basic Pay","S31600",426.4,1575,0,1575,-1148.5999999999999,27.073015873015869,0,-1575]
["E05","Administrative & Clerical Staff","A10145","Admin & Professional Basic Pay","S31600",16172.18,64689,0,64689,-48516.82,24.999891789948833,0,-64689]
["E05","Administrative & Clerical Staff","A12120","Clerk to Governors Ers NI","S31600",38.25,134,0,134,-95.75,28.544776119402986,0,-134]
["E05","Administrative & Clerical Staff","A12145","Admin & Professional Ers NI","S31600",959.16,4048,0,4048,-3088.84,23.694664031620551,0,-4048]
["E05","Administrative & Clerical Staff","A13120","Clerk to Governors Ers Pension Conts","S31600",110.44,408,0,408,-297.56,27.068627450980394,0,-408]
["E05","Administrative & Clerical Staff","A13145","Admin & Professional Ers Pension Conts","S31600",4188.57,16754,0,16754,-12565.43,25.000417810672076,0,-16754]
["E05","Administrative & Clerical Staff","","","",{"$f":"SUBTOTAL(9, F21:F26)","v":21895},87608,0,87608,-65713,24.992009862113047,0,-87608]
["E07","Cost of Other Staff","A10090","Midday Controllers Basic Pay","S31600",6714.5,30530,0,30530,-23815.5,21.993121519816576,0,-30530]
["E07","Cost of Other Staff","A12090","Midday Controllers Ers NI","S31600",31.86,250,0,250,-218.14,12.744,0,-250]
["E07","Cost of Other Staff","A13090","Midday Controllers Ers Pension Conts","S31600",1817.16,8140,0,8140,-6322.84,22.323832923832924,0,-8140]
["E07","Cost of Other Staff","A14090","Midday Controllers Allowances","S31600",300.88,200,0,200,100.88,150.44,0,-200]
["E07","Cost of Other Staff","R19012","Recharge - Payroll Split Coding","S31600",0,-17600,0,-17600,17600,0,0,17600]
["E07","Cost of Other Staff","R44018","Recharge - Service Provision","S31600",508.8,1050,0,1050,-541.20000000000005,48.457142857142863,0,-1050]
["E07","Cost of Other Staff","","","",{"$f":"SUBTOTAL(9, F28:F33)","v":9373.1999999999989},22570,0,22570,-13196.8,41.529463890119622,0,-22570]
["E08","Indirect Employee Expenses","A17005","Advertising - Staff","S31600",0,140,0,140,-140,0,0,-140]
["E08","Indirect Employee Expenses","A18600","Schools Apprenticeship Levy","S31600",714.32,4464,0,4464,-3749.68,16.001792114695341,0,-4464]
["E08","Indirect Employee Expenses","A34005","Car Allowances - Payroll","S31600",0,100,0,100,-100,0,0,-100]
["E08","Indirect Employee Expenses","","","",{"$f":"SUBTOTAL(9, F35:F37)","v":714.32},4704,0,4704,-3989.68,15.185374149659864,0,-4704]
["E09","Staff Development & Training","A16015","Staff Training Expenses - Non Payroll","S31600",2100,5500,0,5500,-3400,38.181818181818187,0,-5500]
["E09","Staff Development & Training","","","",{"$f":"SUBTOTAL(9, F39:F39)","v":2100},5500,0,5500,-3400,38.181818181818187,0,-5500]
["E10","Supply Teacher Insurance","R19003","Recharge - Teaching Sickness Premium","S31600",0,9897,0,9897,-9897,0,0,-9897]
["E10","Supply Teacher Insurance","","","",{"$f":"SUBTOTAL(9, F41:F41)","v":0},9897,0,9897,-9897,0,0,-9897]
["E11","Staff Related Insurance","R19000","Recharge - Non-teaching Sickness Premium","S31600",0,5342,0,5342,-5342,0,0,-5342]
["E11","Staff Related Insurance","","","",{"$f":"SUBTOTAL(9, F43:F43)","v":0},5342,0,5342,-5342,0,0,-5342]
["E12","Building Maintenance & Improvement","A20005","Property Repairs, Maintenance & Alterations","S31600",7155.57,15000,0,15000,-7844.43,47.703799999999994,0,-15000]
["E12","Building Maintenance & Improvement","","","",{"$f":"SUBTOTAL(9, F45:F45)","v":7155.57},15000,0,15000,-7844.43,47.703799999999994,0,-15000]
["E13","Grounds Maintenance & Improvement","A27505","Upkeep of Grounds","S31600",941.55,3600,0,3600,-2658.45,26.154166666666669,0,-3600]
["E13","Grounds Maintenance & Improvement","","","",{"$f":"SUBTOTAL(9, F47:F47)","v":941.55},3600,0,3600,-2658.45,26.154166666666669,0,-3600]
["E14","Cleaning & Caretaking","A27005","Window Cleaning","S31600",80,400,0,400,-320,20,0,-400]
["E14","Cleaning & Caretaking","","","",{"$f":"SUBTOTAL(9, F49:F49)","v":80},400,0,400,-320,20,0,-400]
["E15","Water & Sewerage","A24005","Property Related Water Services","S31600",1597.71,6581,0,6581,-4983.29,24.277617383376388,0,-6581]
["E15","Water & Sewerage","","","",{"$f":"SUBTOTAL(9, F51:F51)","v":1597.71},6581,0,6581,-4983.29,24.277617383376388,0,-6581]
["E16","Energy","A21005","Electricity","S31600",994.52,9800,0,9800,-8805.48,10.148163265306122,0,-9800]
["E16","Energy","A21010","Gas","S31600",477.68,5000,0,5000,-4522.32,9.5535999999999994,0,-5000]
["E16","Energy","","","",{"$f":"SUBTOTAL(9, F53:F54)","v":1472.2},14800,0,14800,-13327.8,9.9472972972972968,0,-14800]
["E17","Rates","A23005","Rates","S31600",26880,26880,0,26880,0,100,0,-26880]
["E17","Rates","","","",{"$f":"SUBTOTAL(9, F56:F56)","v":26880},26880,0,26880,0,100,0,-26880]
["E18","Other Occupation Costs","A27015","Refuse Collection","S31600",365.22,1542,0,1542,-1176.78,23.684824902723737,0,-1542]
["E18","Other Occupation Costs","A27020","Cleaning Materials","S31600",567.5,3000,0,3000,-2432.5,18.916666666666668,0,-3000]
["E18","Other Occupation Costs","A29015","Other Premises Costs","S31600",1700.92,2200,0,2200,-499.08,77.314545454545453,0,-2200]
["E18","Other Occupation Costs","A40040","First Aid Equipment","S31600",173.66,500,0,500,-326.33999999999997,34.731999999999999,0,-500]
["E18","Other Occupation Costs","A40080","Health & Safety Equipment","S31600",259.19,500,0,500,-240.81,51.837999999999994,0,-500]
["E18","Other Occupation Costs","","","",{"$f":"SUBTOTAL(9, F58:F62)","v":3066.4900000000002},7742,0,7742,-4675.51,39.60849909584087,0,-7742]
["E19","Learning Resources","A40020","Equipment & Materials Child Related","S31600",1308.69,19200,0,19200,-17891.310000000001,6.8160937500000003,0,-19200]
["E19","Learning Resources","A40045","Furniture","S31600",240,2000,0,2000,-1760,12,0,-2000]
["E19","Learning Resources","A40050","Books","S31600",633.96,800,0,800,-166.04,79.245000000000005,0,-800]
["E19","Learning Resources","A40070","Stock Materials","S31600",657.91,4000,0,4000,-3342.09,16.447749999999999,0,-4000]
["E19","Learning Resources","A43005","Photocopying","S31600",1974.7,8500,0,8500,-6525.3,{"$f":"IFERROR(F68/I68,0)*100","v":23.231764705882355},0,-8500]
["E19","Learning Resources","A47010","Subscriptions (non staff)","S31600",239,800,0,800,-561,29.875,0,-800]
["E19","Learning Resources","A49080","Educational Visits & Other Expenditure","S31600",0,7800,0,7800,-7800,0,0,-7800]
["E19","Learning Resources","","","",{"$f":"SUBTOTAL(9, F64:F70)","v":5054.26},43100,0,43100,-38045.740000000005,11.726821345707657,0,-43100]
["E20","ICT Learning Resources","A45005","Computer Hardware","S31600",2066.21,8000,0,8000,-5933.79,25.827624999999998,0,-8000]
["E20","ICT Learning Resources","A45035","Computer Services","S31600",10582.89,13500,0,13500,-2917.11,78.391777777777776,0,-13500]
["E20","ICT Learning Resources","A45040","Computer Software","S31600",9305.48,12737,0,12737,-3431.52,73.058648033288847,0,-12737]
["E20","ICT Learning Resources","","","",{"$f":"SUBTOTAL(9, F72:F74)","v":21954.579999999998},34237,0,34237,-12282.42,64.125303034728503,0,-34237]
["E22","Administrative Supplies","A40015","Equipment & Materials Admin","S31600",72.569999999999993,800,0,800,-727.43,9.0712499999999991,0,-800]
["E22","Administrative Supplies","A45015","Postages","S31600",71.17,200,0,200,-128.83000000000001,35.585000000000001,0,-200]
["E22","Administrative Supplies","A45020","Telephones","S31600",774.46,2200,0,2200,-1425.54,35.202727272727273,0,-2200]
["E22","Administrative Supplies","A49075","Licences - General","S31600",500,460,0,460,40,108.69565217391303,0,-460]
["E22","Administrative Supplies","","","",{"$f":"SUBTOTAL(9, F76:F79)","v":1418.2},3660,0,3660,-2241.8000000000002,38.748633879781423,0,-3660]
["E23","Other Insurance Premiums","A49025","General Insurance","S31600",0,11985,0,11985,-11985,0,0,-11985]
["E23","Other Insurance Premiums","","","",{"$f":"SUBTOTAL(9, F81:F81)","v":0},11985,0,11985,-11985,0,0,-11985]
["E24","Special Facilities","A42005","Clothing & Uniforms","S31600",0,750,0,750,-750,0,0,-750]
["E24","Special Facilities","A60010","Tuition &/or Board Fees","S31600",0,2600,0,2600,-2600,0,0,-2600]
["E24","Special Facilities","R44009","Recharge - Specialist Teaching & Applied Psychology (STAPS) Buy-Back & Assessments","S31600",1035,0,0,0,1035,0,0,0]
["E24","Special Facilities","","","",{"$f":"SUBTOTAL(9, F83:F85)","v":1035},3350,0,3350,-2315,30.895522388059703,0,-3350]
["E25","Catering Supplies","A41010","Free Meals","S31600",12359.49,20000,0,20000,-7640.51,61.797449999999998,0,-20000]
["E25","Catering Supplies","A41020","Paid School Meals","S31600",2658,10000,0,10000,-7342,26.58,0,-10000]
["E25","Catering Supplies","A44030","Provisions","S31600",55.08,0,0,0,55.08,0,0,0]
["E25","Catering Supplies","","","",{"$f":"SUBTOTAL(9, F87:F89)","v":15072.57},30000,0,30000,-14927.43,50.241899999999994,0,-30000]
["E26","Agency Supply Teaching Staff","A11005","Agency Supply Teacher","S31600",2269.75,7500,0,7500,-5230.25,30.263333333333332,0,-7500]
["E26","Agency Supply Teaching Staff","","","",{"$f":"SUBTOTAL(9, F91:F91)","v":2269.75},7500,0,7500,-5230.25,30.263333333333332,0,-7500]
["E27","Bought-In Professional Services - Curriculum","A44060","Consultancy Services - Curriculum","S31600",1200,3255,0,3255,-2055,36.866359447004612,0,-3255]
["E27","Bought-In Professional Services - Curriculum","","","",{"$f":"SUBTOTAL(9, F93:F93)","v":1200},3255,0,3255,-2055,36.866359447004612,0,-3255]
["E28","Bought-In Professional Services - Other","A44150","Schools Buy Back","S31600",1750,1750,0,1750,0,100,0,-1750]
["E28","Bought-In Professional Services - Other","A44910","Bought in Services - Other - Schools","S31600",2880.9,6241,0,6241,-3360.1,46.160871655183463,0,-6241]
["E28","Bought-In Professional Services - Other","R49001","Recharge - Finance Buy-Back","S31600",4374.88,4375,0,4375,-0.12,99.997257142857137,0,-4375]
["E28","Bought-In Professional Services - Other","R49012","Recharge - Schools HR Advisory & Employee Counselling Buy-Back","S31600",0,2675,0,2675,-2675,0,0,-2675]
["E28","Bought-In Professional Services - Other","","","",{"$f":"SUBTOTAL(9, F95:F98)","v":9005.7799999999988},15041,0,15041,-6035.2199999999993,59.874875340735315,0,-15041]
["I03","High Needs Top Up Funding","R93017","Recharge - High Needs Top-Up Funding","S31600",-11443.77,-45775,0,-45775,34331.230000000003,25.000043691971602,0,45775]
["I03","High Needs Top Up Funding","","","",{"$f":"SUBTOTAL(9, F100:F100)","v":-11443.77},-45775,0,-45775,34331.230000000003,25.000043691971602,0,45775]
["I08B","Other Income from Facilities and Services","A91095","Income from External Bodies","S31600",0,-2600,0,-2600,2600,0,0,2600]
["I08B","Other Income from Facilities and Services","A92010","Sale of Products","S31600",-219.05,0,0,0,-219.05,0,0,0]
["I08B","Other Income from Facilities and Services","A92040","Service Charges","S31600",0,-1800,0,-1800,1800,0,0,1800]
["I08B","Other Income from Facilities and Services","","","",{"$f":"SUBTOTAL(9, F102:F104)","v":-219.05},-4400,0,-4400,4180.95,4.978409090909091,0,4400]
["I09","Income from Catering","A92020","Sale of Meals","S31600",-2246.4,-10000,0,-10000,7753.6,22.464000000000002,0,10000]
["I09","Income from Catering","","","",{"$f":"SUBTOTAL(9, F106:F106)","v":-2246.4},-10000,0,-10000,7753.6,22.464000000000002,0,10000]
["I12","Income from Contributions to Visits","A93185","Parental contributions towards visits","S31600",0,-7425,0,-7425,7425,0,0,7425]
["I12","Income from Contributions to Visits","","","",{"$f":"SUBTOTAL(9, F108:F108)","v":0},-7425,0,-7425,7425,0,0,7425]
["I18","Additional Grant for Schools","R93021","Recharge - Additional Grant For Schools","S31600",-13925,-13021,0,-13021,-904,106.94263113432147,0,13021]
["I18","Additional Grant for Schools","","","",{"$f":"SUBTOTAL(9, F110:F110)","v":-13925},-13021,0,-13021,-904,106.94263113432147,0,13021]
["I99","Contingency","A48010","Contingency/ Reserve Transfers (Budget Only)","S31600",0,59184,0,59184,-59184,0,0,-59184]
["I99","Contingency","A48015","Schools Carry Forward (Budget Only)","S31600",0,-71383,8502,-62881,62881,0,0,62881]
["I99","Contingency","","","",{"$f":"SUBTOTAL(9, F112:F113)","v":0},-12199,8502,-3697,3697,0,0,3697]
["","","","","",{"$f":"SUBTOTAL(9, F3:F114)","v":360715.80999999994},1332065,8502,1340567,-979851.19000000018,26.907704724941013,0,-1340567]

{"sheet":"Appendix 2- Actuals for Grants","index":1,"n_rows":96,"n_cols":16,"rows_kept":96,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"Actuals for Grants as at 09/07/2021"]
["Cfr2","Cfr2 (T)","Account","Account (T)","Costc","Schdept","Schdept (T)","Actuals","Original Budget","Virements","Revised Budget","Variance (Actuals-Revised Budget)","% Spent","Current Mth Forecast","Forecast Variance","Links to reports"]
["E01","Teaching Staff","A10005","Teachers Basic Pay","S316AA","G013","Pupil Premium",4160.3999999999996,6934,0,6934,-2773.6,{"$f":"IFERROR(H3/K3,0)*100","v":60},0,-6934]
["E01","Teaching Staff","A12005","Teachers Ers NI","S316AA","G013","Pupil Premium",597.37,754,0,754,-156.63,{"$f":"IFERROR(H4/K4,0)*100","v":79.226790450928391},0,-754]
["E01","Teaching Staff","A13005","Teachers Ers Pension Conts","S316AA","G013","Pupil Premium",1548.64,2166,0,2166,-617.36,71.497691597414587,0,-2166]
["E01","Teaching Staff","A14005","Teachers Allowances","S316AA","G013","Pupil Premium",1853.17,4712,0,4712,-2858.83,39.328735144312397,0,-4712]
["E01","Teaching Staff","","","S316AA","","",{"$f":"SUBTOTAL(9, H3:H6)","v":8159.58},14566,0,14566,-6406.42,56.017987093230815,0,-14566]
["E03","Education Support Staff","A10080","Learning Support Assistants Basic Pay","S316AA","G013","Pupil Premium",10575.75,50986,0,50986,-40410.25,20.742458714156829,0,-50986]
["E03","Education Support Staff","A12080","Learning Support Assistants Ers NI","S316AA","G013","Pupil Premium",544.09,3173,0,3173,-2628.91,17.14749448471478,0,-3173]
["E03","Education Support Staff","A13080","Learning Support Assistants Ers Pens Conts","S316AA","G013","Pupil Premium",2739.12,13205,0,13205,-10465.879999999999,20.743051874290042,0,-13205]
["E03","Education Support Staff","","","S316AA","","",{"$f":"SUBTOTAL(9, H8:H10)","v":13858.96},67364,0,67364,-53505.04,20.573243869128909,0,-67364]
["E07","Cost of Other Staff","R19012","Recharge - Payroll Split Coding","S316AA","G013","Pupil Premium",0,16493,0,16493,-16493,0,0,-16493]
["E07","Cost of Other Staff","","","S316AA","","",{"$f":"SUBTOTAL(9, H12:H12)","v":0},16493,0,16493,-16493,0,0,-16493]
["E08","Indirect Employee Expenses","A18600","Schools Apprenticeship Levy","S316AA","G013","Pupil Premium",61.18,458,0,458,-396.82,13.358078602620088,0,-458]
["E08","Indirect Employee Expenses","","","S316AA","","",{"$f":"SUBTOTAL(9, H14:H14)","v":61.18},458,0,458,-396.82,13.358078602620088,0,-458]
["E09","Staff Development & Training","A16015","Staff Training Expenses - Non Payroll","S316AA","G013","Pupil Premium",0,350,0,350,-350,0,0,-350]
["E09","Staff Development & Training","","","S316AA","","",{"$f":"SUBTOTAL(9, H16:H16)","v":0},350,0,350,-350,0,0,-350]
["E19","Learning Resources","A40005","Equipment & Materials Learning","S316AA","G013","Pupil Premium",0,250,0,250,-250,0,0,-250]
["E19","Learning Resources","A49080","Educational Visits & Other Expenditure","S316AA","G013","Pupil Premium",0,200,0,200,-200,0,0,-200]
["E19","Learning Resources","","","S316AA","","",{"$f":"SUBTOTAL(9, H18:H19)","v":0},450,0,450,-450,0,0,-450]
["E24","Special Facilities","R44009","Recharge - Specialist Teaching & Applied Psychology (STAPS) Buy-Back & Assessments","S316AA","G013","Pupil Premium",0,975,0,975,-975,0,0,-975]
["E24","Special Facilities","","","S316AA","","",{"$f":"SUBTOTAL(9, H21:H21)","v":0},975,0,975,-975,0,0,-975]
["E25","Catering Supplies","A44035","Free Milk","S316AA","G013","Pupil Premium",99.44,0,0,0,99.44,0,0,0]
["E25","Catering Supplies","","","S316AA","","",{"$f":"SUBTOTAL(9, H23:H23)","v":99.44},0,0,0,99.44,0,0,0]
["E28","Bought-In Professional Services - Other","A44065","Consultancy Services - Other","S316AA","G013","Pupil Premium",0,600,0,600,-600,0,0,-600]
["E28","Bought-In Professional Services - Other","A44910","Bought in Services - Other - Schools","S316AA","G013","Pupil Premium",0,2000,0,2000,-2000,0,0,-2000]
["E28","Bought-In Professional Services - Other","","","S316AA","","",{"$f":"SUBTOTAL(9, H25:H26)","v":0},2600,0,2600,-2600,0,0,-2600]
["I05","Pupil Premium","R93018","Recharge - Pupil Premium","S316AA","G013","Pupil Premium",0,-104910,0,-104910,104910,0,0,104910]
["I05","Pupil Premium","","","S316AA","","",{"$f":"SUBTOTAL(9, H28:H28)","v":0},-104910,0,-104910,104910,0,0,104910]
["I99","Contingency","A48010","Contingency/ Reserve Transfers (Budget Only)","S316AA","G013","Pupil Premium",0,5889,0,5889,-5889,0,0,-5889]
["I99","Contingency","A48015","Schools Carry Forward (Budget Only)","S316AA","G013","Pupil Premium",0,-4235,4235,0,0,0,0,0]
["I99","Contingency","","","S316AA","","",{"$f":"SUBTOTAL(9, H30:H31)","v":0},1654,4235,5889,-5889,0,0,-5889]
["","","","","S316AA","","",{"$f":"SUBTOTAL(9, H3:H32)","v":22179.16},0,4235,4235,17944.160000000003,523.71097992916168,0,-4235]
["I05","Pupil Premium","R93018","Recharge - Pupil Premium","S316AB","G016","Pupil Premium Service Children",0,-310,0,-310,310,0,0,310]
["I05","Pupil Premium","","","S316AB","","",{"$f":"SUBTOTAL(9, H34:H34)","v":0},-310,0,-310,310,0,0,310]
["I99","Contingency","A48010","Contingency/ Reserve Transfers (Budget Only)","S316AB","G016","Pupil Premium Service Children",0,1039,0,1039,-1039,0,0,-1039]
["I99","Contingency","A48015","Schools Carry Forward (Budget Only)","S316AB","G016","Pupil Premium Service Children",0,-729,729,0,0,0,0,0]
["I99","Contingency","","","S316AB","","",{"$f":"SUBTOTAL(9, H36:H37)","v":0},310,729,1039,-1039,0,0,-1039]
["","","","","S316AB","","",{"$f":"SUBTOTAL(9, H34:H38)","v":0},0,729,729,-729,0,0,-729]
["E19","Learning Resources","A49080","Educational Visits & Other Expenditure","S316AC","G014","Pupil Premium Looked After Children",0,100,0,100,-100,0,0,-100]
["E19","Learning Resources","","","S316AC","","",{"$f":"SUBTOTAL(9, H40:H40)","v":0},100,0,100,-100,0,0,-100]
["E20","ICT Learning Resources","A45005","Computer Hardware","S316AC","G014","Pupil Premium Looked After Children",458,518,0,518,-60,88.416988416988417,0,-518]
["E20","ICT Learning Resources","A45035","Computer Services","S316AC","G014","Pupil Premium Looked After Children",60,0,0,0,60,0,0,0]
["E20","ICT Learning Resources","A45040","Computer Software","S316AC","G014","Pupil Premium Looked After Children",4460,4460,0,4460,0,100,0,-4460]
["E20","ICT Learning Resources","","","S316AC","","",{"$f":"SUBTOTAL(9, H42:H44)","v":4978},4978,0,4978,0,100,0,-4978]
["E28","Bought-In Professional Services - Other","A44910","Bought in Services - Other - Schools","S316AC","G014","Pupil Premium Looked After Children",455,1000,0,1000,-545,45.5,0,-1000]
["E28","Bought-In Professional Services - Other","","","S316AC","","",{"$f":"SUBTOTAL(9, H46:H46)","v":455},1000,0,1000,-545,45.5,0,-1000]
["I05","Pupil Premium","R93018","Recharge - Pupil Premium","S316AC","G014","Pupil Premium Looked After Children",-2000,-5000,0,-5000,3000,40,0,5000]
["I05","Pupil Premium","","","S316AC","","",{"$f":"SUBTOTAL(9, H48:H48)","v":-2000},-5000,0,-5000,3000,40,0,5000]
["I99","Contingency","A48010","Contingency/ Reserve Transfers (Budget Only)","S316AC","G014","Pupil Premium Looked After Children",0,3382,0,3382,-3382,0,0,-3382]
["I99","Contingency","A48015","Schools Carry Forward (Budget Only)","S316AC","G014","Pupil Premium Looked After Children",0,-4460,4460,0,0,0,0,0]
["I99","Contingency","","","S316AC","","",{"$f":"SUBTOTAL(9, H50:H51)","v":0},-1078,4460,3382,-3382,0,0,-3382]
["","","","","S316AC","","",{"$f":"SUBTOTAL(9, H40:H52)","v":3433},0,4460,4460,-1027,76.973094170403584,0,-4460]
["E07","Cost of Other Staff","R19012","Recharge - Payroll Split Coding","S316AF","G015","Pupil Premium Post Looked After Children",0,-16493,0,-16493,16493,0,0,16493]
["E07","Cost of Other Staff","","","S316AF","","",{"$f":"SUBTOTAL(9, H54:H54)","v":0},-16493,0,-16493,16493,0,0,16493]
["E19","Learning Resources","A49080","Educational Visits & Other Expenditure","S316AF","G015","Pupil Premium Post Looked After Children",0,100,0,100,-100,0,0,-100]
["E19","Learning Resources","","","S316AF","","",{"$f":"SUBTOTAL(9, H56:H56)","v":0},100,0,100,-100,0,0,-100]
["I05","Pupil Premium","R93018","Recharge - Pupil Premium","S316AF","G015","Pupil Premium Post Looked After Children",0,-4690,0,-4690,4690,0,0,4690]
["I05","Pupil Premium","","","S316AF","","",{"$f":"SUBTOTAL(9, H58:H58)","v":0},-4690,0,-4690,4690,0,0,4690]
["I99","Contingency","A48010","Contingency/ Reserve Transfers (Budget Only)","S316AF","G015","Pupil Premium Post Looked After Children",0,22959,0,22959,-22959,0,0,-22959]
["I99","Contingency","A48015","Schools Carry Forward (Budget Only)","S316AF","G015","Pupil Premium Post Looked After Children",0,-1876,1876,0,0,0,0,0]
["I99","Contingency","","","S316AF","","",{"$f":"SUBTOTAL(9, H60:H61)","v":0},21083,1876,22959,-22959,0,0,-22959]
["","","","","S316AF","","",{"$f":"SUBTOTAL(9, H54:H62)","v":0},0,1876,1876,-1876,0,0,-1876]
["E03","Education Support Staff","A10080","Learning Support Assistants Basic Pay","S316BA","G011","PE & Sport Grant",1904.04,3173,0,3173,-1268.96,60.007563819728958,0,-3173]
["E03","Education Support Staff","A13080","Learning Support Assistants Ers Pens Conts","S316BA","G011","PE & Sport Grant",539.37,899,0,899,-359.63,59.99666295884316,0,-899]
["E03","Education Support Staff","A14080","Learning Support Assistants Allowances","S316BA","G011","PE & Sport Grant",178.5,298,0,298,-119.5,59.899328859060411,0,-298]
["E03","Education Support Staff","","","S316BA","","",{"$f":"SUBTOTAL(9, H64:H66)","v":2621.91},4370,0,4370,-1748.0900000000001,59.997940503432488,0,-4370]
["E07","Cost of Other Staff","R19012","Recharge - Payroll Split Coding","S316BA","G011","PE & Sport Grant",0,1107,0,1107,-1107,{"$f":"IFERROR(H68/K68,0)*100","v":0},0,-1107]
["E07","Cost of Other Staff","","","S316BA","","",{"$f":"SUBTOTAL(9, H68:H68)","v":0},1107,0,1107,-1107,0,0,-1107]
["E08","Indirect Employee Expenses","A18600","Schools Apprenticeship Levy","S316BA","G011","PE & Sport Grant",6.94,30,0,30,-23.06,23.133333333333333,0,-30]
["E08","Indirect Employee Expenses","","","S316BA","","",{"$f":"SUBTOTAL(9, H70:H70)","v":6.94},30,0,30,-23.06,23.133333333333333,0,-30]
["E09","Staff Development & Training","A16015","Staff Training Expenses - Non Payroll","S316BA","G011","PE & Sport Grant",0,500,0,500,-500,0,0,-500]
["E09","Staff Development & Training","","","S316BA","","",{"$f":"SUBTOTAL(9, H72:H72)","v":0},500,0,500,-500,0,0,-500]
["E18","Other Occupation Costs","A40080","Health & Safety Equipment","S316BA","G011","PE & Sport Grant",0,728,0,728,-728,0,0,-728]
["E18","Other Occupation Costs","","","S316BA","","",{"$f":"SUBTOTAL(9, H74:H74)","v":0},728,0,728,-728,0,0,-728]
["E19","Learning Resources","A40020","Equipment & Materials Child Related","S316BA","G011","PE & Sport Grant",184.73,250,0,250,-65.27,73.891999999999996,0,-250]
["E19","Learning Resources","A49080","Educational Visits & Other Expenditure","S316BA","G011","PE & Sport Grant",0,500,0,500,-500,0,0,-500]
["E19","Learning Resources","","","S316BA","","",{"$f":"SUBTOTAL(9, H76:H77)","v":184.73},750,0,750,-565.27,24.630666666666663,0,-750]
["E27","Bought-In Professional Services - Curriculum","A44928","Bought in Services - Curriculum Schools","S316BA","G011","PE & Sport Grant",2145,13125,0,13125,-10980,16.342857142857142,0,-13125]
["E27","Bought-In Professional Services - Curriculum","A49005","Other Hired & Contracting Services","S316BA","G011","PE & Sport Grant",0,2856,0,2856,-2856,0,0,-2856]
["E27","Bought-In Professional Services - Curriculum","","","S316BA","","",{"$f":"SUBTOTAL(9, H79:H80)","v":2145},15981,0,15981,-13836,13.422188849258495,0,-15981]
["I18","Additional Grant for Schools","R93021","Recharge - Additional Grant For Schools","S316BA","G011","PE & Sport Grant",-7796,-18631,0,-18631,10835,41.844238097793998,0,18631]
["I18","Additional Grant for Schools","","","S316BA","","",{"$f":"SUBTOTAL(9, H82:H82)","v":-7796},-18631,0,-18631,10835,41.844238097793998,0,18631]
["I99","Contingency","A48010","Contingency/ Reserve Transfers (Budget Only)","S316BA","G011","PE & Sport Grant",0,1142,0,1142,-1142,0,0,-1142]
["I99","Contingency","A48015","Schools Carry Forward (Budget Only)","S316BA","G011","PE & Sport Grant",0,-5977,5977,0,0,0,0,0]
["I99","Contingency","","","S316BA","","",{"$f":"SUBTOTAL(9, H84:H85)","v":0},-4835,5977,1142,-1142,0,0,-1142]
["","","","","S316BA","","",{"$f":"SUBTOTAL(9, H64:H86)","v":-2837.42},0,5977,5977,-8814.4199999999983,-47.472310523674082,0,-5977]
["E25","Catering Supplies","A41010","Free Meals","S316EA","G023","Universal Infant Free School Meals",8325.6,38760,0,38760,-30434.400000000001,21.479876160990713,0,-38760]
["E25","Catering Supplies","","","S316EA","","",{"$f":"SUBTOTAL(9, H88:H88)","v":8325.6},38760,0,38760,-30434.400000000001,21.479876160990713,0,-38760]
["I18","Additional Grant for Schools","R93021","Recharge - Additional Grant For Schools","S316EA","G023","Universal Infant Free School Meals",0,-37791,0,-37791,37791,0,0,37791]
["I18","Additional Grant for Schools","","","S316EA","","",{"$f":"SUBTOTAL(9, H90:H90)","v":0},-37791,0,-37791,37791,0,0,37791]
["I99","Contingency","A48010","Contingency/ Reserve Transfers (Budget Only)","S316EA","G023","Universal Infant Free School Meals",0,20895,0,20895,-20895,0,0,-20895]
["I99","Contingency","A48015","Schools Carry Forward (Budget Only)","S316EA","G023","Universal Infant Free School Meals",0,-21864,21864,0,0,0,0,0]
["I99","Contingency","","","S316EA","","",{"$f":"SUBTOTAL(9, H92:H93)","v":0},-969,21864,20895,-20895,0,0,-20895]
["","","","","S316EA","","",{"$f":"SUBTOTAL(9, H88:H94)","v":8325.6},0,21864,21864,-13538.400000000001,38.079034028540065,0,-21864]
["","","","","","","",{"$f":"SUBTOTAL(9, H3:H95)","v":31100.339999999997},0,39141,39141,-8040.6599999999962,79.457193224496052,0,-39141]

{"sheet":"Appendix 3- Summary","index":2,"n_rows":226,"n_cols":14,"rows_kept":226,"cut":false,"hidden":false,"merged":[]}
["FINANCIAL PLAN - SUMMARY"]
[null,null,null,null,null,null,null,null,null,"Variance from previous year to current year"]
["SUMMARY",{"$f":"PYEAR","v":"2020/21"},{"$f":"YEAR1","v":"2021/22"},{"$f":"YEAR2","v":"2022/23"},{"$f":"YEAR3","v":"2023/24"},{"$f":"YEAR4","v":"2024/25"},{"$f":"YEAR5","v":"2025/26"},null,null,"Percentage","If Red enter reason"]
[null,"Actual","Budget","Estimate","Estimate","Estimate","Estimate",null,null,"Difference","for variance"]
["Number of pupils on roll (Primary)",308,{"$f":"SUM('[2]2 - Pupil No.'!B7:B13)","v":308},{"$f":"SUM('[2]2 - Pupil No.'!C7:C13)","v":314},{"$f":"SUM('[2]2 - Pupil No.'!D7:D13)","v":315},{"$f":"SUM('[2]2 - Pupil No.'!E7:E13)","v":315},{"$f":"SUM('[2]2 - Pupil No.'!F7:F13)","v":315},"Enter NoR for Previous year"]
[]
["Number of pupils on roll (Secondary)",0,{"$f":"SUM('[2]2 - Pupil No.'!B14:B18)","v":0},{"$f":"SUM('[2]2 - Pupil No.'!C14:C18)","v":0},{"$f":"SUM('[2]2 - Pupil No.'!D14:D18)","v":0},{"$f":"SUM('[2]2 - Pupil No.'!E14:E18)","v":0},{"$f":"SUM('[2]2 - Pupil No.'!F14:F18)","v":0},"Enter NoR for Previous year"]
[]
[null,"£","£","£","£","£","£","Validation Correct/Incorrect"]
[null,null,null,null,null,null,null,{"$f":"IF(OR([2]Validation!F8=\"INCORRECT\",[2]Validation!D12=\"NOT ENTERED\",[2]Validation!E17=\"NOT ENTERED\",[2]Validation!F9=\"INCORRECT\",[2]Validation!K21=\"NOT ENTERED\",[2]Validation!L10=\"NOT ENTERED\",[2]Validation!L11=\"NOT ENTERED\",[2]Validation!L12=\"NOT ENTERED\",[2]Validation!L13=\"NOT ENTERED\",[2]Validation!L14=\"NOT ENTERED\",[2]Validation!L15=\"NOT ENTERED\",[2]Validation!L16=\"NOT ENTERED\",[2]Validation!L17=\"NOT ENTERED\", [2]Validation!L18=\"NOT ENTERED\",[2]Validation!L19=\"NOT ENTERED\",[2]Validation!E29=\"NOT ENTERED\",[2]Validation!F29=\"NOT ENTERED\",[2]Validation!G29=\"NOT ENTERED\",[2]Validation!H29=\"NOT ENTERED\",[2]Validation!I29=\"NOT ENTERED\", [2]Validation!D24=\"NOT ENTERED\",[2]Validation!E24=\"NOT ENTERED\",[2]Validation!F24=\"NOT ENTERED\",[2]Validation!G24=\"NOT ENTERED\",[2]Validation!H24=\"NOT ENTERED\",[2]Validation!I24=\"NOT ENTERED\", [2]Validation!D25=\"NOT ENTERED\",[2]Validation!E25=\"NOT ENTERED\",[2]Validation!F25=\"NOT ENTERED\",[2]Validation!G25=\"NOT ENTERED\",[2]Validation!H25=\"NOT ENTERED\",[2]Validation!I25=\"NOT ENTERED\",[2]Validation!D26=\"NOT ENTERED\",[2]Validation!E26=\"NOT ENTERED\",[2]Validation!F26=\"NOT ENTERED\",[2]Validation!G26=\"NOT ENTERED\",[2]Validation!H26=\"NOT ENTERED\",[2]Validation!I26=\"NOT ENTERED\", [2]Validation!D27=\"NOT ENTERED\",[2]Validation!E27=\"NOT ENTERED\",[2]Validation!F27=\"NOT ENTERED\",[2]Validation!G27=\"NOT ENTERED\",[2]Validation!H27=\"NOT ENTERED\",[2]Validation!I27=\"NOT ENTERED\",[2]Validation!D28=\"NOT ENTERED\",[2]Validation!E28=\"NOT ENTERED\",[2]Validation!F28=\"NOT ENTERED\",[2]Validation!G28=\"NOT ENTERED\",[2]Validation!H28=\"NOT ENTERED\",[2]Validation!I28=\"NOT ENTERED\",[2]Validation!D29=\"NOT ENTERED\",[2]Validation!E29=\"NOT ENTERED\",[2]Validation!F29=\"NOT ENTERED\",[2]Validation!G29=\"NOT ENTERED\",[2]Validation!H29=\"NOT ENTERED\",[2]Validation!I29=\"NOT ENTERED\",[2]Validation!D30=\"NOT ENTERED\",[2]Validation!E30=\"NOT ENTERED\",[2]Validation!F30=\"NOT ENTERED\",[2]Validation!G30=\"NOT ENTERED\",[2]Validation!H30=\"NOT ENTERED\",[2]Validation!I30=\"NOT ENTERED\", [2]Validation!D31=\"NOT ENTERED\",[2]Validation!E31=\"NOT ENTERED\",[2]Validation!F31=\"NOT ENTERED\",[2]Validation!G31=\"NOT ENTERED\",[2]Validation!H31=\"NOT ENTERED\",[2]Validation!I31=\"NOT ENTERED\", [2]Validation!D32=\"NOT ENTERED\",[2]Validation!E32=\"NOT ENTERED\",[2]Validation!F32=\"NOT ENTERED\",[2]Validation!G32=\"NOT ENTERED\",[2]Validation!H32=\"NOT ENTERED\",[2]Validation!I32=\"NOT ENTERED\", [2]Validation!D33=\"NOT ENTERED\",[2]Validation!E33=\"NOT ENTERED\",[2]Validation!F33=\"NOT ENTERED\",[2]Validation!G33=\"NOT ENTERED\",[2]Validation!H33=\"NOT ENTERED\",[2]Validation!I33=\"NOT ENTERED\",[2]Validation!D36=\"Incorrect account codes used\",[2]Validation!K19=\"NOT ENTERED\",[2]Validation!D42=\"NOT ENTERED\",[2]Validation!E42=\"NOT ENTERED\",[2]Validation!F42=\"NOT ENTERED\",[2]Validation!G42=\"NOT ENTERED\",[2]Validation!H42=\"NOT ENTERED\",[2]Validation!D43=\"NOT ENTERED\",[2]Validation!E43=\"NOT ENTERED\",[2]Validation!F43=\"NOT ENTERED\",[2]Validation!G43=\"NOT ENTERED\",[2]Validation!H43=\"NOT ENTERED\",[2]Validation!F55=\"incorrect\",[2]Validation!F56=\"incorrect\",[2]Validation!D49=\"NOT ENTERED\",[2]Validation!E49=\"NOT ENTERED\",[2]Validation!F49=\"NOT ENTERED\",[2]Validation!G49=\"NOT ENTERED\",[2]Validation!D64=\"INCORRECT\",[2]Validation!D71=\"INCORRECT\",[2]Validation!D72=\"INCORRECT\"),\"INCORRECT\",\"CORRECT\")","v":"CORRECT"}]
["Under / Overspend B/F",-38211,{"$f":"B74","v":-71288.889999999898},{"$f":"C74","v":-56854.340000000084},{"$f":"D74","v":-33648.357039388502},{"$f":"E74","v":6268.2926407353953},{"$f":"F74","v":72098.221552763367},"Note: A negative figure demonstrates a surplus"]
[]
["Income - (I01)"]
[]
["Total Original Budget Share",1229172,{"$f":"'[2]3b - Schools Block'!C28","v":1332064},{"$f":"'[2]3b - Schools Block'!D28","v":1361519.4352922079},{"$f":"'[2]3b - Schools Block'!E28","v":1372933.0501676139},{"$f":"'[2]3b - Schools Block'!F28","v":1380534.130418452},{"$f":"'[2]3b - Schools Block'!G28","v":1388236.7200705442}]
[]
["Total Budget including carry forward",{"$f":"(-B11)+B15","v":1267383},1403352.89,1418373.775292208,1406581.4072070024,1374265.8377777166,1316138.4985177808]
[]
["Income:"]
[null,null,null,null,null,null,null,null,null,null,"Reason"]
["(I01) - Funds Delegated by the Local Authority",{"$f":"'[2]6 - Income & Expenditure'!F366","v":-83790},{"$f":"'[2]6 - Income & Expenditure'!G366","v":0},{"$f":"'[2]6 - Income & Expenditure'!H366","v":0},{"$f":"'[2]6 - Income & Expenditure'!I366","v":0},{"$f":"'[2]6 - Income & Expenditure'!J366","v":0},{"$f":"'[2]6 - Income & Expenditure'!K366","v":0},null,null,{"$f":"IFERROR((C21-B21)/B21,0)","v":-1},"Teachers' Pay & Pension Grants now in B/share",{"$f":"IF(OR(K21<>\"\",AND(ABS(J21)<0.2499)),0,1)","v":0},{"$f":"B21-C21","v":-83790},{"$f":"IF(AND(AND(J21=0,M21<>0,K21=\"\")),1,0)","v":0}]
["(I02) - Funding for 6th Form",{"$f":"'[2]6 - Income & Expenditure'!F371","v":0},{"$f":"'[2]6 - Income & Expenditure'!G371","v":0},{"$f":"'[2]6 - Income & Expenditure'!H371","v":0},{"$f":"'[2]6 - Income & Expenditure'!I371","v":0},{"$f":"'[2]6 - Income & Expenditure'!J371","v":0},{"$f":"'[2]6 - Income & Expenditure'!K371","v":0},null,null,0,null,{"$f":"IF(OR(K22<>\"\",AND(ABS(J22)<0.25)),0,1)","v":0},0,0]
["(I03) - High Needs Top-Up Income",{"$f":"'[2]6 - Income & Expenditure'!F377","v":-46504.53},{"$f":"'[2]6 - Income & Expenditure'!G377","v":-45775.069999999985},{"$f":"'[2]6 - Income & Expenditure'!H377","v":-45775.07},{"$f":"'[2]6 - Income & Expenditure'!I377","v":-45775.07},{"$f":"'[2]6 - Income & Expenditure'!J377","v":-28706.160000000003},{"$f":"'[2]6 - Income & Expenditure'!K377","v":-11383.8},null,null,-1.5685783729026261E-2,null,0,-729.46000000001368,0]
["(I07) - Other Grants and Payments Received",{"$f":"'[2]6 - Income & Expenditure'!F384","v":-1814},{"$f":"'[2]6 - Income & Expenditure'!G384","v":0},{"$f":"'[2]6 - Income & Expenditure'!H384","v":0},{"$f":"'[2]6 - Income & Expenditure'!I384","v":0},{"$f":"'[2]6 - Income & Expenditure'!J384","v":0},{"$f":"'[2]6 - Income & Expenditure'!K384","v":0},null,null,-1,"£464 Credit for BT Broadband 20/21 and £1K for Sports Apprentice Incentive",0,-1814,0]
["(I08A) - Income From Lettings",{"$f":"'[2]6 - Income & Expenditure'!F389","v":-6350},{"$f":"'[2]6 - Income & Expenditure'!G389","v":0},{"$f":"'[2]6 - Income & Expenditure'!H389","v":0},{"$f":"'[2]6 - Income & Expenditure'!I389","v":0},{"$f":"'[2]6 - Income & Expenditure'!J389","v":0},{"$f":"'[2]6 - Income & Expenditure'!K389","v":0},null,null,-1,"LCC taken over as landlords for onsite nursery",0,-6350,0]
["(I08B) - Income From Facilities and Services",{"$f":"'[2]6 - Income & Expenditure'!F405","v":-1408.07},{"$f":"'[2]6 - Income & Expenditure'!G405","v":-7400},{"$f":"'[2]6 - Income & Expenditure'!H405","v":-5944},{"$f":"'[2]6 - Income & Expenditure'!I405","v":-6099.52},{"$f":"'[2]6 - Income & Expenditure'!J405","v":-6267.481600000001},{"$f":"'[2]6 - Income & Expenditure'!K405","v":-6448.8801280000007},null,null,4.2554205401720093,"No swimming income for 20/21 / now included Limes Utilities income",0,5991.93,0]
["(I09) - Income From Catering",{"$f":"'[2]6 - Income & Expenditure'!F410","v":-1362.45},{"$f":"'[2]6 - Income & Expenditure'!G410","v":-10000},{"$f":"'[2]6 - Income & Expenditure'!H410","v":-10200},{"$f":"'[2]6 - Income & Expenditure'!I410","v":-10404},{"$f":"'[2]6 - Income & Expenditure'!J410","v":-10612.08},{"$f":"'[2]6 - Income & Expenditure'!K410","v":-10824.321599999999},null,null,6.3397188887665594,"COVID 19 lockdown - low income for 2020/21",0,8637.5499999999993,0]
["(I10) - Receipts From Supply Teacher Insurance Claims",{"$f":"'[2]6 - Income & Expenditure'!F415","v":0},{"$f":"'[2]6 - Income & Expenditure'!G415","v":0},{"$f":"'[2]6 - Income & Expenditure'!H415","v":0},{"$f":"'[2]6 - Income & Expenditure'!I415","v":0},{"$f":"'[2]6 - Income & Expenditure'!J415","v":0},{"$f":"'[2]6 - Income & Expenditure'!K415","v":0},null,null,0,null,0,0,0]
["(I11) - Receipts From Other Insurance Claims",{"$f":"'[2]6 - Income & Expenditure'!F422","v":0},{"$f":"'[2]6 - Income & Expenditure'!G422","v":0},{"$f":"'[2]6 - Income & Expenditure'!H422","v":0},{"$f":"'[2]6 - Income & Expenditure'!I422","v":0},{"$f":"'[2]6 - Income & Expenditure'!J422","v":0},{"$f":"'[2]6 - Income & Expenditure'!K422","v":0},null,null,0,null,0,0,0]
["(I12) - Income from Contributions to Visits",{"$f":"'[2]6 - Income & Expenditure'!F427","v":0},{"$f":"'[2]6 - Income & Expenditure'!G427","v":-7425},{"$f":"'[2]6 - Income & Expenditure'!H427","v":-11500},{"$f":"'[2]6 - Income & Expenditure'!I427","v":-12500},{"$f":"'[2]6 - Income & Expenditure'!J427","v":-12500},{"$f":"'[2]6 - Income & Expenditure'!K427","v":-12500},null,null,0,"No ed visits 20/21 due to Pandemic",0,7425,0]
["(I13) - Donations and/or Voluntary Funds",{"$f":"'[2]6 - Income & Expenditure'!F432","v":0},{"$f":"'[2]6 - Income & Expenditure'!G432","v":0},{"$f":"'[2]6 - Income & Expenditure'!H432","v":0},{"$f":"'[2]6 - Income & Expenditure'!I432","v":0},{"$f":"'[2]6 - Income & Expenditure'!J432","v":0},{"$f":"'[2]6 - Income & Expenditure'!K432","v":0},null,null,0,null,0,0,0]
["(I18) - Additional Grant For Schools",{"$f":"'[2]6 - Income & Expenditure'!F441","v":-26156},{"$f":"'[2]6 - Income & Expenditure'!G441","v":-14131},{"$f":"'[2]6 - Income & Expenditure'!H441","v":0},{"$f":"'[2]6 - Income & Expenditure'!I441","v":0},{"$f":"'[2]6 - Income & Expenditure'!J441","v":0},{"$f":"'[2]6 - Income & Expenditure'!K441","v":0},null,null,-0.45974155069582506,"COVID-19 Grants (Catch-up/Winter Grant/Additional Costs)",0,-12025,0]
["Total Income:",{"$f":"SUM(B21:B32)","v":-167385.05000000002},-84731.069999999978,-73419.070000000007,-74778.59,-58085.721600000004,-41157.001728000003]
[]
["Expenditure:"]
[]
["(E01) - Teaching Staff ",{"$f":"'[2]6 - Income & Expenditure'!F15","v":704843.8},{"$f":"'[2]6 - Income & Expenditure'!G15","v":747241.64},{"$f":"'[2]6 - Income & Expenditure'!H15","v":764009.14484854578},{"$f":"'[2]6 - Income & Expenditure'!I15","v":779506.38622341293},{"$f":"'[2]6 - Income & Expenditure'!J15","v":793408.16312923061},{"$f":"'[2]6 - Income & Expenditure'!K15","v":804187.4000248377},null,null,{"$f":"IFERROR((C37-B37)/B37,0)","v":6.0152107459837151E-2},null,{"$f":"IF(OR(K37<>\"\",AND(ABS(J37)<0.25)),0,1)","v":0},{"$f":"B37-C37","v":-42397.839999999967},{"$f":"IF(AND(AND(J37=0,M37<>0,K37=\"\")),1,0)","v":0}]
["(E02) - Supply Teaching Staff ",{"$f":"'[2]6 - Income & Expenditure'!F27","v":34},{"$f":"'[2]6 - Income & Expenditure'!G27","v":0},{"$f":"'[2]6 - Income & Expenditure'!H27","v":0},{"$f":"'[2]6 - Income & Expenditure'!I27","v":0},{"$f":"'[2]6 - Income & Expenditure'!J27","v":0},{"$f":"'[2]6 - Income & Expenditure'!K27","v":0},null,null,-1,"Overtime allowances miscoded in 2020/21 (MSA acting as TA)",0,34,0]
["(E03) - Education Support Staff ",{"$f":"'[2]6 - Income & Expenditure'!F51","v":240114.84000000005},{"$f":"'[2]6 - Income & Expenditure'!G51","v":255672.59999999998},{"$f":"'[2]6 - Income & Expenditure'!H51","v":279274.46010369447},{"$f":"'[2]6 - Income & Expenditure'!I51","v":285143.71142404602},{"$f":"'[2]6 - Income & Expenditure'!J51","v":284000.16279565793},{"$f":"'[2]6 - Income & Expenditure'!K51","v":253883.05115915692},null,null,6.4792996551149937E-2,null,0,-15557.759999999922,0]
["(E04) - Premises Staff ",{"$f":"'[2]6 - Income & Expenditure'!F63","v":54977.25},{"$f":"'[2]6 - Income & Expenditure'!G63","v":55264.5},{"$f":"'[2]6 - Income & Expenditure'!H63","v":54516.890976987052},{"$f":"'[2]6 - Income & Expenditure'!I63","v":54473.321623032112},{"$f":"'[2]6 - Income & Expenditure'!J63","v":54935.287559417397},{"$f":"'[2]6 - Income & Expenditure'!K63","v":55502.844998669432},null,null,5.2248884765971381E-3,null,0,-287.25,0]
["(E05) - Administrative and Clerical Staff ",{"$f":"'[2]6 - Income & Expenditure'!F75","v":85952.359999999986},{"$f":"'[2]6 - Income & Expenditure'!G75","v":87608},{"$f":"'[2]6 - Income & Expenditure'!H75","v":89402.540384315638},{"$f":"'[2]6 - Income & Expenditure'!I75","v":90346.087905337321},{"$f":"'[2]6 - Income & Expenditure'!J75","v":91299.064352591929},{"$f":"'[2]6 - Income & Expenditure'!K75","v":92261.564205998613},null,null,1.9262298324327735E-2,null,0,-1655.640000000014,0]
["(E06) - Catering Staff ",{"$f":"'[2]6 - Income & Expenditure'!F83","v":0},{"$f":"'[2]6 - Income & Expenditure'!G83","v":0},{"$f":"'[2]6 - Income & Expenditure'!H83","v":0},{"$f":"'[2]6 - Income & Expenditure'!I83","v":0},{"$f":"'[2]6 - Income & Expenditure'!J83","v":0},{"$f":"'[2]6 - Income & Expenditure'!K83","v":0},null,null,0,null,0,0,0]
["(E07) - Cost of Other Staff ",{"$f":"'[2]6 - Income & Expenditure'!F106","v":39238.009999999995},{"$f":"'[2]6 - Income & Expenditure'!G106","v":15248.850000000006},{"$f":"'[2]6 - Income & Expenditure'!H106","v":17031.957539276795},{"$f":"'[2]6 - Income & Expenditure'!I106","v":16624.815863909567},{"$f":"'[2]6 - Income & Expenditure'!J106","v":16194.31607002188},{"$f":"'[2]6 - Income & Expenditure'!K106","v":16339.576405813528},null,null,-0.61137555141048161,"SENCO salary 70% charged to Budget Share instead of Pupil Premium",0,23989.159999999989,0]
["(E08) - Indirect Employee Expenses ",{"$f":"'[2]6 - Income & Expenditure'!F131","v":5145.38},{"$f":"'[2]6 - Income & Expenditure'!G131","v":4673.91},{"$f":"'[2]6 - Income & Expenditure'!H131","v":4578.2491},{"$f":"'[2]6 - Income & Expenditure'!I131","v":4623.0315909999999},{"$f":"'[2]6 - Income & Expenditure'!J131","v":4668.2619069100001},{"$f":"'[2]6 - Income & Expenditure'!K131","v":4713.9445259791},null,null,-9.1629772728156186E-2,null,0,471.47000000000025,0]
["(E09) - Staff Development and Training ",{"$f":"'[2]6 - Income & Expenditure'!F138","v":7888.4},{"$f":"'[2]6 - Income & Expenditure'!G138","v":5500},{"$f":"'[2]6 - Income & Expenditure'!H138","v":3500},{"$f":"'[2]6 - Income & Expenditure'!I138","v":5000},{"$f":"'[2]6 - Income & Expenditure'!J138","v":3500},{"$f":"'[2]6 - Income & Expenditure'!K138","v":3500},null,null,-0.30277369301759544,"First Aid training took place in 2020/21 hence higher expenditure",0,2388.3999999999996,0]
["(E10) - Supply Teacher Insurance ",{"$f":"'[2]6 - Income & Expenditure'!F144","v":9897.01},{"$f":"'[2]6 - Income & Expenditure'!G144","v":9897.01},{"$f":"'[2]6 - Income & Expenditure'!H144","v":9995.9801000000007},{"$f":"'[2]6 - Income & Expenditure'!I144","v":10095.939901000002},{"$f":"'[2]6 - Income & Expenditure'!J144","v":10196.899300010002},{"$f":"'[2]6 - Income & Expenditure'!K144","v":10298.868293010102},null,null,0,null,0,0,0]
["(E11) - Staff-Related Insurance ",{"$f":"'[2]6 - Income & Expenditure'!F151","v":998.24},{"$f":"'[2]6 - Income & Expenditure'!G151","v":5342.43},{"$f":"'[2]6 - Income & Expenditure'!H151","v":5395.8543},{"$f":"'[2]6 - Income & Expenditure'!I151","v":5449.8128429999997},{"$f":"'[2]6 - Income & Expenditure'!J151","v":5504.3109714299999},{"$f":"'[2]6 - Income & Expenditure'!K151","v":5559.3540811442999},null,null,4.3518492546882515,"LSA's not insured 2020/21",0,-4344.1900000000005,0]
["(E12) - Building Maintenance and Improvement ",{"$f":"'[2]6 - Income & Expenditure'!F158","v":18980.330000000002},{"$f":"'[2]6 - Income & Expenditure'!G158","v":18000},{"$f":"'[2]6 - Income & Expenditure'!H158","v":12000},{"$f":"'[2]6 - Income & Expenditure'!I158","v":12000},{"$f":"'[2]6 - Income & Expenditure'!J158","v":12000},{"$f":"'[2]6 - Income & Expenditure'!K158","v":12000},null,null,-5.1649786910975819E-2,null,0,980.33000000000175,0]
["(E13) - Grounds Maintenance and Improvement ",{"$f":"'[2]6 - Income & Expenditure'!F163","v":3996.2},{"$f":"'[2]6 - Income & Expenditure'!G163","v":3600},{"$f":"'[2]6 - Income & Expenditure'!H163","v":3200},{"$f":"'[2]6 - Income & Expenditure'!I163","v":3264},{"$f":"'[2]6 - Income & Expenditure'!J163","v":3329.28},{"$f":"'[2]6 - Income & Expenditure'!K163","v":3395.8656000000001},null,null,-9.9144186977628709E-2,null,0,396.19999999999982,0]
["(E14) - Cleaning and Caretaking ",{"$f":"'[2]6 - Income & Expenditure'!F169","v":0},{"$f":"'[2]6 - Income & Expenditure'!G169","v":400},{"$f":"'[2]6 - Income & Expenditure'!H169","v":320},{"$f":"'[2]6 - Income & Expenditure'!I169","v":326.39999999999998},{"$f":"'[2]6 - Income & Expenditure'!J169","v":332.928},{"$f":"'[2]6 - Income & Expenditure'!K169","v":339.58656000000002},null,null,0,"Window cleaning not charged for 20/21 so doubled for 21/22",0,-400,0]
["(E15) - Water and Sewerage ",{"$f":"'[2]6 - Income & Expenditure'!F174","v":1921.49},{"$f":"'[2]6 - Income & Expenditure'!G174","v":6580.92},{"$f":"'[2]6 - Income & Expenditure'!H174","v":6909.9660000000003},{"$f":"'[2]6 - Income & Expenditure'!I174","v":7255.4643000000005},{"$f":"'[2]6 - Income & Expenditure'!J174","v":7618.2375150000007},{"$f":"'[2]6 - Income & Expenditure'!K174","v":7999.1493907500007},null,null,2.4249046313017502,"Water ",0,-4659.43,0]
["(E16) - Energy",{"$f":"'[2]6 - Income & Expenditure'!F181","v":13146.84},{"$f":"'[2]6 - Income & Expenditure'!G181","v":14800},{"$f":"'[2]6 - Income & Expenditure'!H181","v":15790},{"$f":"'[2]6 - Income & Expenditure'!I181","v":16854.5},{"$f":"'[2]6 - Income & Expenditure'!J181","v":17999.725000000002},{"$f":"'[2]6 - Income & Expenditure'!K181","v":19232.461250000004},null,null,0.1257458065968704,null,0,-1653.1599999999999,0]
["(E17) - Rates",{"$f":"'[2]6 - Income & Expenditure'!F186","v":26880},{"$f":"'[2]6 - Income & Expenditure'!G186","v":26880},{"$f":"'[2]6 - Income & Expenditure'!H186","v":28224},{"$f":"'[2]6 - Income & Expenditure'!I186","v":29635.200000000001},{"$f":"'[2]6 - Income & Expenditure'!J186","v":31116.960000000003},{"$f":"'[2]6 - Income & Expenditure'!K186","v":32672.808000000005},null,null,0,null,0,0,0]
["(E18) - Other Occupation Costs",{"$f":"'[2]6 - Income & Expenditure'!F208","v":13486.36},{"$f":"'[2]6 - Income & Expenditure'!G208","v":8404.2000000000007},{"$f":"'[2]6 - Income & Expenditure'!H208","v":8181.3},{"$f":"'[2]6 - Income & Expenditure'!I208","v":8262.255000000001},{"$f":"'[2]6 - Income & Expenditure'!J208","v":7847.2577499999998},{"$f":"'[2]6 - Income & Expenditure'!K208","v":7936.5106375000005},null,null,-0.37683704127726086,"Biffa refuse costs reduced by £5K (revised contract and reduced weeks 38 instead of 52!) cleaning costs hopefully lower for 21/22",0,5082.16,0]
["(E19) - Learning Resources",{"$f":"'[2]6 - Income & Expenditure'!F240","v":39256.490000000013},{"$f":"'[2]6 - Income & Expenditure'!G240","v":49500},{"$f":"'[2]6 - Income & Expenditure'!H240","v":46885},{"$f":"'[2]6 - Income & Expenditure'!I240","v":47970.85},{"$f":"'[2]6 - Income & Expenditure'!J240","v":47757.558499999999},{"$f":"'[2]6 - Income & Expenditure'!K240","v":54701.134084999998},null,null,0.26093800031536146,"LEAD EQUATE books additional cost (income will allow for this)",0,-10243.509999999987,0]
["(E20) - ICT Learning Resources",{"$f":"'[2]6 - Income & Expenditure'!F248","v":35222.93},{"$f":"'[2]6 - Income & Expenditure'!G248","v":34237},{"$f":"'[2]6 - Income & Expenditure'!H248","v":30675},{"$f":"'[2]6 - Income & Expenditure'!I248","v":31383.75},{"$f":"'[2]6 - Income & Expenditure'!J248","v":32127.9375},{"$f":"'[2]6 - Income & Expenditure'!K248","v":32909.334375000006},null,null,-2.7991140998207709E-2,null,0,985.93000000000029,0]
["(E21) - Examination Fees",{"$f":"'[2]6 - Income & Expenditure'!F254","v":0},{"$f":"'[2]6 - Income & Expenditure'!G254","v":0},{"$f":"'[2]6 - Income & Expenditure'!H254","v":0},{"$f":"'[2]6 - Income & Expenditure'!I254","v":0},{"$f":"'[2]6 - Income & Expenditure'!J254","v":0},{"$f":"'[2]6 - Income & Expenditure'!K254","v":0},null,null,0,null,0,0,0]
["(E22) - Administrative Supplies",{"$f":"'[2]6 - Income & Expenditure'!F274","v":3865.82},{"$f":"'[2]6 - Income & Expenditure'!G274","v":3660},{"$f":"'[2]6 - Income & Expenditure'!H274","v":3713.2},{"$f":"'[2]6 - Income & Expenditure'!I274","v":3767.4639999999999},{"$f":"'[2]6 - Income & Expenditure'!J274","v":3822.8132799999998},{"$f":"'[2]6 - Income & Expenditure'!K274","v":3879.2695455999997},null,null,-5.3240968280985707E-2,null,0,205.82000000000016,0]
["(E23) - Other Insurance Premiums",{"$f":"'[2]6 - Income & Expenditure'!F282","v":10820},{"$f":"'[2]6 - Income & Expenditure'!G282","v":11985.25},{"$f":"'[2]6 - Income & Expenditure'!H282","v":12584.512500000001},{"$f":"'[2]6 - Income & Expenditure'!I282","v":13213.738125000002},{"$f":"'[2]6 - Income & Expenditure'!J282","v":13874.425031250003},{"$f":"'[2]6 - Income & Expenditure'!K282","v":14568.146282812504},null,null,0.10769408502772643,null,0,-1165.25,0]
["(E24) - Special Facilities",{"$f":"'[2]6 - Income & Expenditure'!F295","v":0},{"$f":"'[2]6 - Income & Expenditure'!G295","v":3350},{"$f":"'[2]6 - Income & Expenditure'!H295","v":4050},{"$f":"'[2]6 - Income & Expenditure'!I295","v":4050},{"$f":"'[2]6 - Income & Expenditure'!J295","v":4050},{"$f":"'[2]6 - Income & Expenditure'!K295","v":4050},null,null,0,"Replace staff sports uniform for 21/22",0,-3350,0]
["(E25) - Catering Supplies",{"$f":"'[2]6 - Income & Expenditure'!F311","v":20686.349999999999},{"$f":"'[2]6 - Income & Expenditure'!G311","v":37437.69},{"$f":"'[2]6 - Income & Expenditure'!H311","v":35200},{"$f":"'[2]6 - Income & Expenditure'!I311","v":35404},{"$f":"'[2]6 - Income & Expenditure'!J311","v":35612.080000000002},{"$f":"'[2]6 - Income & Expenditure'!K311","v":35824.321599999996},null,null,0.8097774619495467,"Meals low for 2020/21 due to pandemic",0,-16751.340000000004,0]
["(E26) - Agency Supply Teaching Staff",{"$f":"'[2]6 - Income & Expenditure'!F316","v":9167.36},{"$f":"'[2]6 - Income & Expenditure'!G316","v":7500},{"$f":"'[2]6 - Income & Expenditure'!H316","v":5000},{"$f":"'[2]6 - Income & Expenditure'!I316","v":5000},{"$f":"'[2]6 - Income & Expenditure'!J316","v":5000},{"$f":"'[2]6 - Income & Expenditure'!K316","v":5000},null,null,-0.18188006143535332,null,0,1667.3600000000006,0]
["(E27) - Bought-In Professional Services - Curriculum",{"$f":"'[2]6 - Income & Expenditure'!F326","v":1535},{"$f":"'[2]6 - Income & Expenditure'!G326","v":3255},{"$f":"'[2]6 - Income & Expenditure'!H326","v":2250},{"$f":"'[2]6 - Income & Expenditure'!I326","v":2250},{"$f":"'[2]6 - Income & Expenditure'!J326","v":2250},{"$f":"'[2]6 - Income & Expenditure'!K326","v":2250},null,null,1.1205211726384365,"Extra £1755 for SLE Leadership Work",0,-1720,0]
["(E28A) - Bought-In Professional Services - Other (except PFI)",{"$f":"'[2]6 - Income & Expenditure'!F342","v":15424.7},{"$f":"'[2]6 - Income & Expenditure'!G342","v":15190.62},{"$f":"'[2]6 - Income & Expenditure'!H342","v":15456.4324},{"$f":"'[2]6 - Income & Expenditure'!I342","v":15727.561048},{"$f":"'[2]6 - Income & Expenditure'!J342","v":16004.112268959998},{"$f":"'[2]6 - Income & Expenditure'!K342","v":16286.194514339199},null,null,-1.51756598183433E-2,null,0,234.07999999999993,0]
["(E28B) - Bought-In Professional Services - Other (PFI)",{"$f":"'[2]6 - Income & Expenditure'!F348","v":0},{"$f":"'[2]6 - Income & Expenditure'!G348","v":0},{"$f":"'[2]6 - Income & Expenditure'!H348","v":0},{"$f":"'[2]6 - Income & Expenditure'!I348","v":0},{"$f":"'[2]6 - Income & Expenditure'!J348","v":0},{"$f":"'[2]6 - Income & Expenditure'!K348","v":0},null,null,0,null,0,0,0]
["(E29) - Loan Interest",{"$f":"'[2]6 - Income & Expenditure'!F353","v":0},{"$f":"'[2]6 - Income & Expenditure'!G353","v":0},{"$f":"'[2]6 - Income & Expenditure'!H353","v":0},{"$f":"'[2]6 - Income & Expenditure'!I353","v":0},{"$f":"'[2]6 - Income & Expenditure'!J353","v":0},{"$f":"'[2]6 - Income & Expenditure'!K353","v":0},null,null,0,null,0,0,0]
["(E30) - Direct Revenue Financing (Revenue Cont to Capital)",{"$f":"'[2]6 - Income & Expenditure'!F359","v":0},{"$f":"'[2]6 - Income & Expenditure'!G359","v":0},{"$f":"'[2]6 - Income & Expenditure'!H359","v":0},{"$f":"'[2]6 - Income & Expenditure'!I359","v":0},{"$f":"'[2]6 - Income & Expenditure'!J359","v":0},{"$f":"'[2]6 - Income & Expenditure'!K359","v":0},null,null,0,null,0,0,0]
["Total Expenditure:",{"$f":"SUM(B37:B67)","v":1363479.1600000001},1431229.6199999999,1458144.4882528195,1487628.2898477379,1504449.78093048,1499291.3855356111]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L21:L32,L37:L67)","v":0},null,{"$f":"SUM(N21:N32,N37:N67)","v":0}]
["Total of Income and Expenditure",{"$f":"B68+B33","v":1196094.1100000001},1346498.5499999998,1384725.4182528195,1412849.6998477378,1446364.0593304799,1458134.3838076112]
[]
["Under / Overspend - In Year Position",{"$f":"-(B15-B70)","v":-33077.889999999898},14434.549999999814,23205.982960611582,39916.649680123897,65829.928912027972,69897.663737067021,"Note: A negative figure demonstrates a surplus"]
[]
["Under / Overspend C/F",{"$f":"-(B17-B70)","v":-71288.889999999898},-56854.340000000084,-33648.357039388502,6268.2926407353953,72098.221552763367,141995.88528983039,"Note: A negative figure demonstrates a surplus"]
["An 8% Carry Forward would Equal (Primary)",null,{"$f":"-SUM('[2]3b - Schools Block'!C28-'[2]6 - Income & Expenditure'!G366-'[2]6 - Income & Expenditure'!G377)*8%","v":-110227.12560000001},{"$f":"-SUM('[2]3b - Schools Block'!D28-'[2]6 - Income & Expenditure'!H366-'[2]6 - Income & Expenditure'!H377)*8%","v":-112583.56042337664},{"$f":"-SUM('[2]3b - Schools Block'!E28-'[2]6 - Income & Expenditure'!I366-'[2]6 - Income & Expenditure'!I377)*8%","v":-113496.64961340911},{"$f":"-SUM('[2]3b - Schools Block'!F28-'[2]6 - Income & Expenditure'!J366-'[2]6 - Income & Expenditure'!J377)*8%","v":-112739.22323347615},{"$f":"-SUM('[2]3b - Schools Block'!G28-'[2]6 - Income & Expenditure'!K366-'[2]6 - Income & Expenditure'!K377)*8%","v":-111969.64160564354}]
["A 5% Carry Forward would Equal (Secondary)",null,{"$f":"-SUM('[2]3b - Schools Block'!C28-'[2]6 - Income & Expenditure'!G366-'[2]6 - Income & Expenditure'!G371-'[2]6 - Income & Expenditure'!G377)*5%","v":-68891.953500000003},{"$f":"-SUM('[2]3b - Schools Block'!D28-'[2]6 - Income & Expenditure'!H366-'[2]6 - Income & Expenditure'!H371-'[2]6 - Income & Expenditure'!H377)*5%","v":-70364.725264610403},{"$f":"-SUM('[2]3b - Schools Block'!E28-'[2]6 - Income & Expenditure'!I366-'[2]6 - Income & Expenditure'!I371-'[2]6 - Income & Expenditure'!I377)*5%","v":-70935.406008380698},{"$f":"-SUM('[2]3b - Schools Block'!F28-'[2]6 - Income & Expenditure'!J366-'[2]6 - Income & Expenditure'!J371-'[2]6 - Income & Expenditure'!J377)*5%","v":-70462.014520922603},{"$f":"-SUM('[2]3b - Schools Block'!G28-'[2]6 - Income & Expenditure'!K366-'[2]6 - Income & Expenditure'!K371-'[2]6 - Income & Expenditure'!K377)*5%","v":-69981.026003527208}]
[]
["Pupil Premium FSM - (I05)","£","£","£","£","£","£"]
[]
["Income:"]
["B/F Total",{"$f":"'[2]7 - Pupil Premium FSM'!J13","v":-3183},{"$f":"B89","v":-4235.160000000018},{"$f":"C89","v":-2841.1000000000204},{"$f":"D89","v":-13786.396432055379},{"$f":"E89","v":-21809.297989815619},{"$f":"F89","v":-26869.30811233136}]
["Pupil Premium - Eligible for Free School Meals",{"$f":"'[2]7 - Pupil Premium FSM'!J14","v":-106255},{"$f":"'[2]7 - Pupil Premium FSM'!K14","v":-104910},{"$f":"'[2]7 - Pupil Premium FSM'!L14","v":-104910},{"$f":"'[2]7 - Pupil Premium FSM'!M14","v":-104910},{"$f":"'[2]7 - Pupil Premium FSM'!N14","v":-104910},{"$f":"'[2]7 - Pupil Premium FSM'!O14","v":-104910}]
["Total Pupil Premium Income",{"$f":"SUM(B81:B82)","v":-109438},-109145.16000000002,-107751.10000000002,-118696.39643205538,-126719.29798981562,-131779.30811233138]
[]
["Expenditure:"]
["Pupil Premium - Eligible for Free School Meals",{"$f":"'[2]7 - Pupil Premium FSM'!J201","v":105202.83999999998},{"$f":"'[2]7 - Pupil Premium FSM'!K201","v":106304.06},{"$f":"'[2]7 - Pupil Premium FSM'!L201","v":93964.703567944642},{"$f":"'[2]7 - Pupil Premium FSM'!M201","v":96887.09844223976},{"$f":"'[2]7 - Pupil Premium FSM'!N201","v":99849.989877484259},{"$f":"'[2]7 - Pupil Premium FSM'!O201","v":100873.5481790591}]
["Overspend charged back to Budget Share",{"$f":"'[2]7 - Pupil Premium FSM'!J204","v":0},{"$f":"'[2]7 - Pupil Premium FSM'!K204","v":0},{"$f":"'[2]7 - Pupil Premium FSM'!L204","v":0},{"$f":"'[2]7 - Pupil Premium FSM'!M204","v":0},{"$f":"'[2]7 - Pupil Premium FSM'!N204","v":0},{"$f":"'[2]7 - Pupil Premium FSM'!O204","v":0}]
[]
["C/F Total",{"$f":"'[2]7 - Pupil Premium FSM'!J205","v":-4235.160000000018},{"$f":"'[2]7 - Pupil Premium FSM'!K205","v":-2841.1000000000204},{"$f":"'[2]7 - Pupil Premium FSM'!L205","v":-13786.396432055379},{"$f":"'[2]7 - Pupil Premium FSM'!M205","v":-21809.297989815619},{"$f":"'[2]7 - Pupil Premium FSM'!N205","v":-26869.30811233136},{"$f":"'[2]7 - Pupil Premium FSM'!O205","v":-30905.759933272275},"Note: A negative figure demonstrates a surplus"]
[]
["Pupil Premium Service Children - (I05)","£","£","£","£","£","£"]
[]
["Income:"]
["B/F Total",{"$f":"'[2]7a - Pupil Premium Service'!J11","v":-419},{"$f":"B102","v":-729},{"$f":"C102","v":-1039},{"$f":"D102","v":-1349},{"$f":"E102","v":-1659},{"$f":"F102","v":-1659}]
["Pupil Premium Service Children",{"$f":"'[2]7a - Pupil Premium Service'!J12","v":-310},{"$f":"'[2]7a - Pupil Premium Service'!K12","v":-310},{"$f":"'[2]7a - Pupil Premium Service'!L12","v":-310},{"$f":"'[2]7a - Pupil Premium Service'!M12","v":-310},{"$f":"'[2]7a - Pupil Premium Service'!N12","v":0},{"$f":"'[2]7a - Pupil Premium Service'!O12","v":0}]
["Total Pupil Premium Service Children Income",{"$f":"SUM(B94:B95)","v":-729},-1039,-1349,-1659,-1659,-1659]
[]
["Expenditure:"]
["Pupil Premium Service Children",{"$f":"'[2]7a - Pupil Premium Service'!J197","v":0},{"$f":"'[2]7a - Pupil Premium Service'!K197","v":0},{"$f":"'[2]7a - Pupil Premium Service'!L197","v":0},{"$f":"'[2]7a - Pupil Premium Service'!M197","v":0},{"$f":"'[2]7a - Pupil Premium Service'!N197","v":0},{"$f":"'[2]7a - Pupil Premium Service'!O197","v":0}]
["Overspend charged back to Budget Share",{"$f":"'[2]7a - Pupil Premium Service'!J200","v":0},{"$f":"'[2]7a - Pupil Premium Service'!K200","v":0},{"$f":"'[2]7a - Pupil Premium Service'!L200","v":0},{"$f":"'[2]7a - Pupil Premium Service'!M200","v":0},{"$f":"'[2]7a - Pupil Premium Service'!N200","v":0},{"$f":"'[2]7a - Pupil Premium Service'!O200","v":0}]
[]
["C/F Total",{"$f":"'[2]7a - Pupil Premium Service'!J201","v":-729},{"$f":"'[2]7a - Pupil Premium Service'!K201","v":-1039},{"$f":"'[2]7a - Pupil Premium Service'!L201","v":-1349},{"$f":"'[2]7a - Pupil Premium Service'!M201","v":-1659},{"$f":"'[2]7a - Pupil Premium Service'!N201","v":-1659},{"$f":"'[2]7a - Pupil Premium Service'!O201","v":-1659},"Note: A negative figure demonstrates a surplus"]
[]
["Pupil Premium Looked After Children - (I05)","£","£","£","£","£","£"]
[]
["Income:"]
["B/F Total",{"$f":"'[2]7b - Pupil Premium LAC'!J11","v":0},{"$f":"B117","v":-4459.71},{"$f":"C117","v":-3081.7099999999991},{"$f":"D117","v":-7181.7099999999991},{"$f":"E117","v":-11781.71},{"$f":"F117","v":-16381.71}]
["Pupil Premium Looked After Children",{"$f":"'[2]7b - Pupil Premium LAC'!J12","v":-2000},{"$f":"'[2]7b - Pupil Premium LAC'!K12","v":-5000},{"$f":"'[2]7b - Pupil Premium LAC'!L12","v":-5000},{"$f":"'[2]7b - Pupil Premium LAC'!M12","v":-5000},{"$f":"'[2]7b - Pupil Premium LAC'!N12","v":-5000},{"$f":"'[2]7b - Pupil Premium LAC'!O12","v":-4000}]
["Pupil Premium Looked After Children Virtual Head Funding",{"$f":"'[2]7b - Pupil Premium LAC'!J13","v":-3294},{"$f":"'[2]7b - Pupil Premium LAC'!K13","v":0},{"$f":"'[2]7b - Pupil Premium LAC'!L13","v":0},{"$f":"'[2]7b - Pupil Premium LAC'!M13","v":0},{"$f":"'[2]7b - Pupil Premium LAC'!N13","v":0},{"$f":"'[2]7b - Pupil Premium LAC'!O13","v":0}]
["Pupil Premium Looked After Children Out of County Funding",{"$f":"'[2]7b - Pupil Premium LAC'!J18","v":0},{"$f":"'[2]7b - Pupil Premium LAC'!K18","v":0},{"$f":"'[2]7b - Pupil Premium LAC'!L18","v":0},{"$f":"'[2]7b - Pupil Premium LAC'!M18","v":0},{"$f":"'[2]7b - Pupil Premium LAC'!N18","v":0},{"$f":"'[2]7b - Pupil Premium LAC'!O18","v":0}]
["Total Pupil Premium Looked After Children Income",{"$f":"SUM(B107:B110)","v":-5294},-9459.7099999999991,-8081.7099999999991,-12181.71,-16781.71,-20381.71]
[]
["Expenditure:"]
["Pupil Premium Looked After Children",{"$f":"'[2]7b - Pupil Premium LAC'!J204","v":834.29},{"$f":"'[2]7b - Pupil Premium LAC'!K204","v":6378},{"$f":"'[2]7b - Pupil Premium LAC'!L204","v":900},{"$f":"'[2]7b - Pupil Premium LAC'!M204","v":400},{"$f":"'[2]7b - Pupil Premium LAC'!N204","v":400},{"$f":"'[2]7b - Pupil Premium LAC'!O204","v":400}]
["Overspend charged back to Budget Share",{"$f":"'[2]7b - Pupil Premium LAC'!J207","v":0},{"$f":"'[2]7b - Pupil Premium LAC'!K207","v":0},{"$f":"'[2]7b - Pupil Premium LAC'!L207","v":0},{"$f":"'[2]7b - Pupil Premium LAC'!M207","v":0},{"$f":"'[2]7b - Pupil Premium LAC'!N207","v":0},{"$f":"'[2]7b - Pupil Premium LAC'!O207","v":0}]
[]
["C/F Total",{"$f":"'[2]7b - Pupil Premium LAC'!J208","v":-4459.71},{"$f":"'[2]7b - Pupil Premium LAC'!K208","v":-3081.7099999999991},{"$f":"'[2]7b - Pupil Premium LAC'!L208","v":-7181.7099999999991},{"$f":"'[2]7b - Pupil Premium LAC'!M208","v":-11781.71},{"$f":"'[2]7b - Pupil Premium LAC'!N208","v":-16381.71},{"$f":"'[2]7b - Pupil Premium LAC'!O208","v":-19981.71},"Note: A negative figure demonstrates a surplus"]
[]
["Pupil Premium Post Looked After Children - (I05)","£","£","£","£","£","£"]
[]
["Income:"]
["B/F Total",{"$f":"'[2]7c - Pupil Premium Post LAC'!J11","v":-1252},{"$f":"B130","v":-1875.8100000000004},{"$f":"C130","v":-6465.81},{"$f":"D130","v":-8810.8100000000013},{"$f":"E130","v":-8810.8100000000013},{"$f":"F130","v":-8810.8100000000013}]
["Pupil Premium Post Looked After Children",{"$f":"'[2]7c - Pupil Premium Post LAC'!J12","v":-7035},{"$f":"'[2]7c - Pupil Premium Post LAC'!K12","v":-4690},{"$f":"'[2]7c - Pupil Premium Post LAC'!L12","v":-2345},{"$f":"'[2]7c - Pupil Premium Post LAC'!M12","v":0},{"$f":"'[2]7c - Pupil Premium Post LAC'!N12","v":0},{"$f":"'[2]7c - Pupil Premium Post LAC'!O12","v":0}]
["Total Pupil Premium Post Looked After Children Income",{"$f":"SUM(B122:B123)","v":-8287},-6565.81,-8810.8100000000013,-8810.8100000000013,-8810.8100000000013,-8810.8100000000013]
[]
["Expenditure:"]
["Pupil Premium Post Looked After Children",{"$f":"'[2]7c - Pupil Premium Post LAC'!J198","v":6411.19},{"$f":"'[2]7c - Pupil Premium Post LAC'!K198","v":100},{"$f":"'[2]7c - Pupil Premium Post LAC'!L198","v":0},{"$f":"'[2]7c - Pupil Premium Post LAC'!M198","v":0},{"$f":"'[2]7c - Pupil Premium Post LAC'!N198","v":0},{"$f":"'[2]7c - Pupil Premium Post LAC'!O198","v":0}]
["Overspend charged back to Budget Share",{"$f":"'[2]7c - Pupil Premium Post LAC'!J201","v":0},{"$f":"'[2]7c - Pupil Premium Post LAC'!K201","v":0},{"$f":"'[2]7c - Pupil Premium Post LAC'!L201","v":0},{"$f":"'[2]7c - Pupil Premium Post LAC'!M201","v":0},{"$f":"'[2]7c - Pupil Premium Post LAC'!N201","v":0},{"$f":"'[2]7c - Pupil Premium Post LAC'!O201","v":0}]
[]
["C/F Total",{"$f":"'[2]7c - Pupil Premium Post LAC'!J202","v":-1875.8100000000004},{"$f":"'[2]7c - Pupil Premium Post LAC'!K202","v":-6465.81},{"$f":"'[2]7c - Pupil Premium Post LAC'!L202","v":-8810.8100000000013},{"$f":"'[2]7c - Pupil Premium Post LAC'!M202","v":-8810.8100000000013},{"$f":"'[2]7c - Pupil Premium Post LAC'!N202","v":-8810.8100000000013},{"$f":"'[2]7c - Pupil Premium Post LAC'!O202","v":-8810.8100000000013},"Note: A negative figure demonstrates a surplus"]
[]
["Pupil Premium Early Years Funding - (I01)","£","£","£","£","£","£"]
[]
["Income:"]
["B/F Total",{"$f":"'[2]7d - Pupil Premium EY'!J9","v":0},{"$f":"B143","v":0},{"$f":"C143","v":0},{"$f":"D143","v":0},{"$f":"E143","v":0},{"$f":"F143","v":0}]
["Pupil Premium Early Years Funding",{"$f":"SUM('[2]7d - Pupil Premium EY'!J10:J21)","v":0},{"$f":"SUM('[2]7d - Pupil Premium EY'!K10:K21)","v":0},{"$f":"SUM('[2]7d - Pupil Premium EY'!L10:L21)","v":0},{"$f":"SUM('[2]7d - Pupil Premium EY'!M10:M21)","v":0},{"$f":"SUM('[2]7d - Pupil Premium EY'!N10:N21)","v":0},{"$f":"SUM('[2]7d - Pupil Premium EY'!O10:O21)","v":0}]
["Total Pupuil Premium Early Years Income",{"$f":"SUM(B135:B136)","v":0},0,0,0,0,0]
[]
["Expenditure:"]
["Pupil Premium Early Years Funding",{"$f":"'[2]7d - Pupil Premium EY'!J206","v":0},{"$f":"'[2]7d - Pupil Premium EY'!K206","v":0},{"$f":"'[2]7d - Pupil Premium EY'!L206","v":0},{"$f":"'[2]7d - Pupil Premium EY'!M206","v":0},{"$f":"'[2]7d - Pupil Premium EY'!N206","v":0},{"$f":"'[2]7d - Pupil Premium EY'!O206","v":0}]
["Overspend charged back to Budget Share",{"$f":"'[2]7d - Pupil Premium EY'!J209","v":0},{"$f":"'[2]7d - Pupil Premium EY'!K209","v":0},{"$f":"'[2]7d - Pupil Premium EY'!L209","v":0},{"$f":"'[2]7d - Pupil Premium EY'!M209","v":0},{"$f":"'[2]7d - Pupil Premium EY'!N209","v":0},{"$f":"'[2]7d - Pupil Premium EY'!O209","v":0}]
[]
["C/F Total",{"$f":"'[2]7d - Pupil Premium EY'!J210","v":0},{"$f":"'[2]7d - Pupil Premium EY'!K210","v":0},{"$f":"'[2]7d - Pupil Premium EY'!L210","v":0},{"$f":"'[2]7d - Pupil Premium EY'!M210","v":0},{"$f":"'[2]7d - Pupil Premium EY'!N210","v":0},{"$f":"'[2]7d - Pupil Premium EY'!O210","v":0},"Note: A negative figure demonstrates a surplus"]
[]
["PE and Sport Income - (I18)","£","£","£","£","£","£"]
[]
["Income:"]
["B/F Total",{"$f":"'[2]8 - PE and Sport'!J10","v":-2512},{"$f":"B155","v":-5976.82},{"$f":"C155","v":-1141.619999999999},{"$f":"D155","v":-916.65333333333183},{"$f":"E155","v":-662.85333333332892},{"$f":"F155","v":-349.05333333332601}]
["April to August",{"$f":"'[2]8 - PE and Sport'!J11","v":-7800},{"$f":"'[2]8 - PE and Sport'!K11","v":-7763},{"$f":"'[2]8 - PE and Sport'!L11","v":-7762.5},{"$f":"'[2]8 - PE and Sport'!M11","v":-7791.6666666666661},{"$f":"'[2]8 - PE and Sport'!N11","v":-7791.6666666666661},{"$f":"'[2]8 - PE and Sport'!O11","v":-7791.6666666666661}]
["September to March",{"$f":"'[2]8 - PE and Sport'!J12","v":-10914},{"$f":"'[2]8 - PE and Sport'!K12","v":-10867.5},{"$f":"'[2]8 - PE and Sport'!L12","v":-10908.333333333332},{"$f":"'[2]8 - PE and Sport'!M12","v":-10908.333333333332},{"$f":"'[2]8 - PE and Sport'!N12","v":-10908.333333333332},{"$f":"'[2]8 - PE and Sport'!O12","v":-10908.333333333332}]
["Total Income",{"$f":"'[2]8 - PE and Sport'!J13","v":-21226},{"$f":"'[2]8 - PE and Sport'!K13","v":-24607.32},{"$f":"'[2]8 - PE and Sport'!L13","v":-19812.453333333331},{"$f":"'[2]8 - PE and Sport'!M13","v":-19616.653333333328},{"$f":"'[2]8 - PE and Sport'!N13","v":-19362.853333333325},{"$f":"'[2]8 - PE and Sport'!O13","v":-19049.053333333322}]
[]
["Expenditure",{"$f":"'[2]8 - PE and Sport'!J199","v":15249.18},{"$f":"'[2]8 - PE and Sport'!K199","v":23465.7},{"$f":"'[2]8 - PE and Sport'!L199","v":18895.8},{"$f":"'[2]8 - PE and Sport'!M199","v":18953.8},{"$f":"'[2]8 - PE and Sport'!N199","v":19013.8},{"$f":"'[2]8 - PE and Sport'!O199","v":19082.8}]
[]
["C/F Total",{"$f":"'[2]8 - PE and Sport'!J201","v":-5976.82},{"$f":"'[2]8 - PE and Sport'!K201","v":-1141.619999999999},{"$f":"'[2]8 - PE and Sport'!L201","v":-916.65333333333183},{"$f":"'[2]8 - PE and Sport'!M201","v":-662.85333333332892},{"$f":"'[2]8 - PE and Sport'!N201","v":-349.05333333332601},{"$f":"'[2]8 - PE and Sport'!O201","v":33.746666666676902},"Note: A negative figure demonstrates a surplus"]
[]
["Universal Infant Free School Meals - (I18)","£","£","£","£","£","£"]
[]
["Income "]
["B/F Total",{"$f":"'[2]8a - UIFSM'!I8","v":3511},{"$f":"B167","v":-21863.61},{"$f":"C167","v":-16247.61},{"$f":"D167","v":-10548.174861282227},{"$f":"E167","v":-4801.435371177271},{"$f":"F167","v":993.08151382872893}]
["April to August",{"$f":"'[2]8a - UIFSM'!I9","v":-15349},{"$f":"'[2]8a - UIFSM'!J9","v":-15746},{"$f":"'[2]8a - UIFSM'!K9","v":-15746},{"$f":"'[2]8a - UIFSM'!L9","v":-15746},{"$f":"'[2]8a - UIFSM'!M9","v":-15746},{"$f":"'[2]8a - UIFSM'!N9","v":-15746}]
["September to March",{"$f":"'[2]8a - UIFSM'!I10","v":-22045},{"$f":"'[2]8a - UIFSM'!J10","v":-22045},{"$f":"'[2]8a - UIFSM'!K10","v":-22045},{"$f":"'[2]8a - UIFSM'!L10","v":-22045},{"$f":"'[2]8a - UIFSM'!M10","v":-22045},{"$f":"'[2]8a - UIFSM'!N10","v":-22045}]
["Total Income",{"$f":"SUM(B160:B162)","v":-33883},-59654.61,-54038.61,-48339.174861282227,-42592.435371177271,-36797.918486171271]
[]
["Expenditure",{"$f":"'[2]8a - UIFSM'!I200","v":12019.39},{"$f":"'[2]8a - UIFSM'!J200","v":43407},{"$f":"'[2]8a - UIFSM'!K200","v":43490.435138717774},{"$f":"'[2]8a - UIFSM'!L200","v":43537.739490104956},{"$f":"'[2]8a - UIFSM'!M200","v":43585.516885006},{"$f":"'[2]8a - UIFSM'!N200","v":36797.772053856061}]
[]
["C/F Total",{"$f":"'[2]8a - UIFSM'!I202","v":-21863.61},{"$f":"'[2]8a - UIFSM'!J202","v":-16247.61},{"$f":"'[2]8a - UIFSM'!K202","v":-10548.174861282227},{"$f":"'[2]8a - UIFSM'!L202","v":-4801.435371177271},{"$f":"'[2]8a - UIFSM'!M202","v":993.08151382872893},{"$f":"'[2]8a - UIFSM'!N202","v":-0.14643231521040434},"Note: A negative figure demonstrates a surplus"]
[]
["Vulnerable Bursary - (I02)","£","£","£","£","£","£"]
[]
["Income:"]
["B/F Total",{"$f":"'[2]8b - Vulnerable Bursary'!J8","v":0},{"$f":"'[2]8b - Vulnerable Bursary'!K8","v":0},{"$f":"'[2]8b - Vulnerable Bursary'!L8","v":0},{"$f":"'[2]8b - Vulnerable Bursary'!M8","v":0},{"$f":"'[2]8b - Vulnerable Bursary'!N8","v":0},{"$f":"'[2]8b - Vulnerable Bursary'!O8","v":0}]
["Vulnerable Bursary",{"$f":"'[2]8b - Vulnerable Bursary'!J9","v":0},{"$f":"'[2]8b - Vulnerable Bursary'!K9","v":0},{"$f":"'[2]8b - Vulnerable Bursary'!L9","v":0},{"$f":"'[2]8b - Vulnerable Bursary'!M9","v":0},{"$f":"'[2]8b - Vulnerable Bursary'!N9","v":0},{"$f":"'[2]8b - Vulnerable Bursary'!O9","v":0}]
["Total Vulnerable Bursary Income",{"$f":"SUM(B172:B173)","v":0},0,0,0,0,0]
[]
["Expenditure:"]
["Vulnerable Bursary",{"$f":"'[2]8b - Vulnerable Bursary'!J194","v":0},{"$f":"'[2]8b - Vulnerable Bursary'!K194","v":0},{"$f":"'[2]8b - Vulnerable Bursary'!L194","v":0},{"$f":"'[2]8b - Vulnerable Bursary'!M194","v":0},{"$f":"'[2]8b - Vulnerable Bursary'!N194","v":0},{"$f":"'[2]8b - Vulnerable Bursary'!O194","v":0}]
[]
["C/F Total",{"$f":"'[2]8b - Vulnerable Bursary'!J196","v":0},{"$f":"'[2]8b - Vulnerable Bursary'!K196","v":0},{"$f":"'[2]8b - Vulnerable Bursary'!L196","v":0},{"$f":"'[2]8b - Vulnerable Bursary'!M196","v":0},{"$f":"'[2]8b - Vulnerable Bursary'!N196","v":0},{"$f":"'[2]8b - Vulnerable Bursary'!O196","v":0},"Note: A negative figure demonstrates a surplus"]
[]
["16-19 Bursary - (I02)","£","£","£","£","£","£"]
[]
["Income:"]
["B/F Total",{"$f":"'[2]8c - 16-19 Bursary'!J8","v":0},{"$f":"'[2]8c - 16-19 Bursary'!K8","v":0},{"$f":"'[2]8c - 16-19 Bursary'!L8","v":0},{"$f":"'[2]8c - 16-19 Bursary'!M8","v":0},{"$f":"'[2]8c - 16-19 Bursary'!N8","v":0},{"$f":"'[2]8c - 16-19 Bursary'!O8","v":0}]
["16-19 Bursary",{"$f":"'[2]8c - 16-19 Bursary'!J9","v":0},{"$f":"'[2]8c - 16-19 Bursary'!K9","v":0},{"$f":"'[2]8c - 16-19 Bursary'!L9","v":0},{"$f":"'[2]8c - 16-19 Bursary'!M9","v":0},{"$f":"'[2]8c - 16-19 Bursary'!N9","v":0},{"$f":"'[2]8c - 16-19 Bursary'!O9","v":0}]
["Total 16-19 Bursary Income",{"$f":"SUM(B184:B185)","v":0},0,0,0,0,0]
[]
["Expenditure:"]
["16-19 Bursary",{"$f":"'[2]8c - 16-19 Bursary'!J194","v":0},{"$f":"'[2]8c - 16-19 Bursary'!K194","v":0},{"$f":"'[2]8c - 16-19 Bursary'!L194","v":0},{"$f":"'[2]8c - 16-19 Bursary'!M194","v":0},{"$f":"'[2]8c - 16-19 Bursary'!N194","v":0},{"$f":"'[2]8c - 16-19 Bursary'!O194","v":0}]
[]
["C/F Total",{"$f":"'[2]8c - 16-19 Bursary'!J196","v":0},{"$f":"'[2]8c - 16-19 Bursary'!K196","v":0},{"$f":"'[2]8c - 16-19 Bursary'!L196","v":0},{"$f":"'[2]8c - 16-19 Bursary'!M196","v":0},{"$f":"'[2]8c - 16-19 Bursary'!N196","v":0},{"$f":"'[2]8c - 16-19 Bursary'!O196","v":0},"Note: A negative figure demonstrates a surplus"]
[]
["Other Grants","£","£","£","£","£","£"]
[]
[{"$f":"IF(ISBLANK('[2]8d - Other Grants'!C7),\"\",'[2]8d - Other Grants'!C7)","v":""}]
["B/F Total",{"$f":"'[2]8d - Other Grants'!E10","v":0},{"$f":"'[2]8d - Other Grants'!F10","v":0},{"$f":"'[2]8d - Other Grants'!G10","v":0},{"$f":"'[2]8d - Other Grants'!H10","v":0},{"$f":"'[2]8d - Other Grants'!I10","v":0},{"$f":"'[2]8d - Other Grants'!J10","v":0}]
["Income",{"$f":"SUM('[2]8d - Other Grants'!E15+'[2]8d - Other Grants'!E20)","v":0},{"$f":"SUM('[2]8d - Other Grants'!F15+'[2]8d - Other Grants'!F20)","v":0},{"$f":"SUM('[2]8d - Other Grants'!G15+'[2]8d - Other Grants'!G20)","v":0},{"$f":"SUM('[2]8d - Other Grants'!H15+'[2]8d - Other Grants'!H20)","v":0},{"$f":"SUM('[2]8d - Other Grants'!I15+'[2]8d - Other Grants'!I20)","v":0},{"$f":"SUM('[2]8d - Other Grants'!J15+'[2]8d - Other Grants'!J20)","v":0}]
["Total Income",{"$f":"SUM(B196:B197)","v":0},{"$f":"'[2]8d - Other Grants'!F22","v":0},{"$f":"'[2]8d - Other Grants'!G22","v":0},{"$f":"'[2]8d - Other Grants'!H22","v":0},{"$f":"'[2]8d - Other Grants'!I22","v":0},{"$f":"'[2]8d - Other Grants'!J22","v":0}]
[]
["Expenditure",{"$f":"'[2]8d - Other Grants'!E300","v":0},{"$f":"'[2]8d - Other Grants'!F300","v":0},{"$f":"'[2]8d - Other Grants'!G300","v":0},{"$f":"'[2]8d - Other Grants'!H300","v":0},{"$f":"'[2]8d - Other Grants'!I300","v":0},{"$f":"'[2]8d - Other Grants'!J300","v":0}]
[]
["C/F Total",{"$f":"'[2]8d - Other Grants'!E302","v":0},{"$f":"'[2]8d - Other Grants'!F302","v":0},{"$f":"'[2]8d - Other Grants'!G302","v":0},{"$f":"'[2]8d - Other Grants'!H302","v":0},{"$f":"'[2]8d - Other Grants'!I302","v":0},{"$f":"'[2]8d - Other Grants'!J302","v":0},"Note: A negative figure demonstrates a surplus"]
[]
[{"$f":"IF(ISBLANK('[2]8d - Other Grants'!C304),\"\",'[2]8d - Other Grants'!C304)","v":""}]
["B/F Total",{"$f":"'[2]8d - Other Grants'!E307","v":0},{"$f":"'[2]8d - Other Grants'!F307","v":0},{"$f":"'[2]8d - Other Grants'!G307","v":0},{"$f":"'[2]8d - Other Grants'!H307","v":0},{"$f":"'[2]8d - Other Grants'!I307","v":0},{"$f":"'[2]8d - Other Grants'!J307","v":0}]
["Income",{"$f":"SUM('[2]8d - Other Grants'!E312+'[2]8d - Other Grants'!E317)","v":0},{"$f":"SUM('[2]8d - Other Grants'!F312+'[2]8d - Other Grants'!F317)","v":0},{"$f":"SUM('[2]8d - Other Grants'!G312+'[2]8d - Other Grants'!G317)","v":0},{"$f":"SUM('[2]8d - Other Grants'!H312+'[2]8d - Other Grants'!H317)","v":0},{"$f":"SUM('[2]8d - Other Grants'!I312+'[2]8d - Other Grants'!I317)","v":0},{"$f":"SUM('[2]8d - Other Grants'!J312+'[2]8d - Other Grants'!J317)","v":0}]
["Total Income",{"$f":"SUM(B205:B206)","v":0},{"$f":"'[2]8d - Other Grants'!F319","v":0},{"$f":"'[2]8d - Other Grants'!G319","v":0},{"$f":"'[2]8d - Other Grants'!H319","v":0},{"$f":"'[2]8d - Other Grants'!I319","v":0},{"$f":"'[2]8d - Other Grants'!J319","v":0}]
[]
["Expenditure",{"$f":"'[2]8d - Other Grants'!E598","v":0},{"$f":"'[2]8d - Other Grants'!F598","v":0},{"$f":"'[2]8d - Other Grants'!G598","v":0},{"$f":"'[2]8d - Other Grants'!H598","v":0},{"$f":"'[2]8d - Other Grants'!I598","v":0},{"$f":"'[2]8d - Other Grants'!J598","v":0}]
[]
["C/F Total",{"$f":"'[2]8d - Other Grants'!E600","v":0},{"$f":"'[2]8d - Other Grants'!F600","v":0},{"$f":"'[2]8d - Other Grants'!G600","v":0},{"$f":"'[2]8d - Other Grants'!H600","v":0},{"$f":"'[2]8d - Other Grants'!I600","v":0},{"$f":"'[2]8d - Other Grants'!J600","v":0},"Note: A negative figure demonstrates a surplus"]
[]
[{"$f":"IF(ISBLANK('[2]8d - Other Grants'!C602),\"\",'[2]8d - Other Grants'!C602)","v":""}]
["B/F Total",{"$f":"'[2]8d - Other Grants'!E605","v":0},{"$f":"'[2]8d - Other Grants'!F605","v":0},{"$f":"'[2]8d - Other Grants'!G605","v":0},{"$f":"'[2]8d - Other Grants'!H605","v":0},{"$f":"'[2]8d - Other Grants'!I605","v":0},{"$f":"'[2]8d - Other Grants'!J605","v":0}]
["Income",{"$f":"SUM('[2]8d - Other Grants'!E610+'[2]8d - Other Grants'!E615)","v":0},{"$f":"SUM('[2]8d - Other Grants'!F610+'[2]8d - Other Grants'!F615)","v":0},{"$f":"SUM('[2]8d - Other Grants'!G610+'[2]8d - Other Grants'!G615)","v":0},{"$f":"SUM('[2]8d - Other Grants'!H610+'[2]8d - Other Grants'!H615)","v":0},{"$f":"SUM('[2]8d - Other Grants'!I610+'[2]8d - Other Grants'!I615)","v":0},{"$f":"SUM('[2]8d - Other Grants'!J610+'[2]8d - Other Grants'!J615)","v":0}]
["Total Income",{"$f":"SUM(B214:B215)","v":0},{"$f":"'[2]8d - Other Grants'!F617","v":0},{"$f":"'[2]8d - Other Grants'!G617","v":0},{"$f":"'[2]8d - Other Grants'!H617","v":0},{"$f":"'[2]8d - Other Grants'!I617","v":0},{"$f":"'[2]8d - Other Grants'!J617","v":0}]
[]
["Expenditure",{"$f":"'[2]8d - Other Grants'!E896","v":0},{"$f":"'[2]8d - Other Grants'!F896","v":0},{"$f":"'[2]8d - Other Grants'!G896","v":0},{"$f":"'[2]8d - Other Grants'!H896","v":0},{"$f":"'[2]8d - Other Grants'!I896","v":0},{"$f":"'[2]8d - Other Grants'!J896","v":0}]
[]
["C/F Total",{"$f":"'[2]8d - Other Grants'!E898","v":0},{"$f":"'[2]8d - Other Grants'!F898","v":0},{"$f":"'[2]8d - Other Grants'!G898","v":0},{"$f":"'[2]8d - Other Grants'!H898","v":0},{"$f":"'[2]8d - Other Grants'!I898","v":0},{"$f":"'[2]8d - Other Grants'!J898","v":0},"Note: A negative figure demonstrates a surplus"]
[]
["Devolved Capital:","£","£","£","£","£","£"]
["B/F Total",0,{"$f":"B226","v":0},{"$f":"C226","v":0},{"$f":"D226","v":0},{"$f":"E226","v":0},{"$f":"F226","v":0}]
["Budget",0,0,0,0,0,0]
["Expenditure",0,0,0,0,0,0]
["C/F Total",{"$f":"SUM(B223:B225)","v":0},0,0,0,0,0]