{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Data","LA Payments","SRU Calc of funding","Academy SRU Budgets 18-19","Payments Details"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":"Data","index":0,"n_rows":13,"n_cols":24,"rows_kept":13,"cut":false,"hidden":true,"merged":[[2,1,5,1],[2,2,5,2],[2,3,5,3],[2,4,2,6],[2,7,2,10],[3,18,5,18],[2,19,2,22],[2,23,5,23],[3,4,5,4],[3,5,5,5],[3,6,5,6],[3,8,5,8],[3,9,5,9],[3,15,5,15],[3,16,5,16],[3,17,5,17],[2,11,2,14],[2,15,2,18]]}
[null,"M:\\Finance7\\PLANNING & PROJECTS\\School Budgets\\2018-19\\High Needs\\Special Resource Units Funding 2018-19.xlsx"]
[]
[null,"School Name","Pre/Post 16","School Type","Planned Places FY 2018/19",null,null,"Place Funding",null,null,null,"Additional Places to be funded by LA",null,null,null,"Estimated Pupils eligible for Top Up Funding FY 2018/19",null,null,null,"Estimated Top up Funding 2018/19",null,null,null,"Forecast 2018/19 Budget"]
[null,null,null,null,"April-August","Sept-March","Pro-rata Places","Element 2 Place funding given out by the EFA","Occupied pre-16 places as at October 2017","Unoccupied pre-16 places as at October 2017","Element 1 Place funding  received through schools/post 16 formula","April-August","Sept-March","Pro-rata Places","Additional Place funding given out by the LA","Top-Up value per pupil","Estimated Pupils Summer Term","Estimated Pupils Autumn Term","Estimated Pupils Spring Term","Estimated Top up funding Summer Term","Estimated Top up funding Autumn Term","Estimated Top up funding Spring Term","Forecast Top-Up funding"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Days:","Days:","Days:","Days:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,68,70,55,193]
[null,"Bluecoat Primary Academy","Pre 16","Academy",2,3,2.5833333333333335,21833.333333333336,1,1,4000,0,0,0,0,17059.875,2,3,3,12021.466321243523,18562.558290155441,14584.867227979277,45168.891839378237,71002.225172711565]
[null,"Bluecoat Academy","Pre 16","Academy",6,6,6,36000,6,0,24000,0,0,0,0,17059.875,6,6,6,36064.398963730564,37125.116580310882,29169.734455958554,102359.25,162359.25]
[null,"Bluecoat Academy","Post 16","Academy",11,11,11,66000,0,0,44000,0,0,0,0,0,null,null,null,0,0,0,0,110000]
[null,"The Bulwell Academy","Pre 16","Academy",6,6,6,36000,6,0,24000,0,0,0,0,17059.875,6,6,6,36064.398963730564,37125.116580310882,29169.734455958554,102359.25,162359.25]
[null,"The Bulwell Academy","Post 16","Academy",10,10,10,60000,0,0,40000,0,0,0,0,0,null,null,null,0,0,0,0,100000]
[null,"Firbeck Academy","Pre 16","Academy",12,12,12,72000,13,0,48000,0,0,0,0,12730.000000000033,12,12,12,53822.176165803241,55405.181347150399,43532.642487046745,152760.00000000038,272760.00000000035]
[null,"Nottingham University Samworth Academy","Pre 16","Academy",12,12,12,76000,11,1,44000,0,0,0,0,15049.874999999998,12,12,12,63630.559585492214,65502.046632124344,51465.893782383413,180598.49999999997,300598.5]

{"sheet":"LA Payments","index":1,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
["DFE number","Academy","Approximate date paid","Place Funding","Estimated Top Up Funding Summer Term","Adjustment to Summer Term Top Up Funding","Estimated Top Up Funding Autumn Term","Adjustment to Top Up Funding Autumn Term","Estimated Top Up Funding Spring Term","Adjustment to Spring Term Top Up Funding","Total paid to Academy"]
["2019N2K2","Bluecoat Primary Academy","2018-06-01",{"$f":"'SRU Calc of funding'!O9","v":0},{"$f":"'SRU Calc of funding'!U9","v":12021.466321243523},null,null,null,null,null,{"$f":"SUM(D6:J6)","v":12021.466321243523}]
["2019N2K2","Bluecoat Primary Academy","2018-08-01",null,null,{"$f":"'SRU Calc of funding'!AF9","v":-1149.1107512953367},{"$f":"'SRU Calc of funding'!V9","v":18562.558290155441},null,null,null,{"$f":"SUM(D7:J7)","v":17413.447538860106}]
["2019N2K2","Bluecoat Primary Academy","2019-03-01",null,null,null,null,{"$f":"'SRU Calc of funding'!AG9","v":0},{"$f":"'SRU Calc of funding'!W9","v":14584.867227979277},null,14584.867227979277]
["2019N2K2","Bluecoat Primary Academy","2019-04-01",null,null,null,null,null,null,{"$f":"'SRU Calc of funding'!AD9","v":0},0]
["4615SrWz","Bluecoat Aspley Academy","2018-06-01",{"$f":"'SRU Calc of funding'!O10+'SRU Calc of funding'!O11","v":0},{"$f":"'SRU Calc of funding'!U10","v":36064.398963730564},null,null,null,null,null,{"$f":"SUM(D10:J10)","v":36064.398963730564}]
["4615SrWz","Bluecoat Aspley Academy","2018-08-01",null,null,{"$f":"'SRU Calc of funding'!AF10","v":-6010.7331606217558},{"$f":"'SRU Calc of funding'!V10","v":37125.116580310882},null,null,null,{"$f":"SUM(D11:J11)","v":31114.383419689126}]
["4615SrWz","Bluecoat Aspley Academy","2019-03-01",null,null,null,null,{"$f":"'SRU Calc of funding'!AG11","v":0},{"$f":"'SRU Calc of funding'!W10","v":29169.734455958554},null,29169.734455958554]
["4615SrWz","Bluecoat Aspley Academy","2019-04-01",null,null,null,null,null,null,{"$f":"+'SRU Calc of funding'!AH9","v":0},0]
["69198zks","Bulwell Academy","2018-06-01",{"$f":"'SRU Calc of funding'!O12+'SRU Calc of funding'!O13","v":0},{"$f":"'SRU Calc of funding'!U12","v":36064.398963730564},null,null,null,null,null,36064.398963730564]
["69198zks","Bulwell Academy","2018-08-01",null,null,{"$f":"'SRU Calc of funding'!AF12","v":-6010.7331606217558},{"$f":"'SRU Calc of funding'!V12","v":37125.116580310882},null,null,null,31114.383419689126]
["69198zks","Bulwell Academy","2019-03-01",null,null,null,null,{"$f":"'SRU Calc of funding'!AG13","v":0},{"$f":"'SRU Calc of funding'!W12","v":29169.734455958554},null,29169.734455958554]
["69198zks","Bulwell Academy","2019-04-01",null,null,null,null,null,null,{"$f":"+'SRU Calc of funding'!AH11","v":0},0]
["2005Vb2Z","Firbeck Primary","2018-06-01",null,{"$f":"'SRU Calc of funding'!U14","v":53822.176165803241},null,null,null,null,null,53822.176165803241]
["2005Vb2Z","Firbeck Primary","2018-08-01",null,null,{"$f":"'SRU Calc of funding'!AF14","v":4485.1813471502828},{"$f":"'SRU Calc of funding'!V14","v":55405.181347150399},null,null,null,59890.362694300682]
["2005Vb2Z","Firbeck Primary","2019-03-01",null,null,null,null,{"$f":"'SRU Calc of funding'!AG14","v":0},{"$f":"'SRU Calc of funding'!W14","v":43532.642487046745},null,43532.642487046745]
["2005Vb2Z","Firbeck Primary","2019-04-01",null,null,null,null,null,null,{"$f":"+'SRU Calc of funding'!AH13","v":0},0]
["6906XfsR","NUSA","2018-06-01",null,{"$f":"'SRU Calc of funding'!U15","v":63630.559585492214},null,null,null,null,null,63630.559585492214]
["6906XfsR","NUSA","2018-08-01",null,null,{"$f":"'SRU Calc of funding'!AF15","v":-5302.5466321243439},{"$f":"'SRU Calc of funding'!V15","v":65502.046632124344},null,null,null,60199.5]
["6906XfsR","NUSA","2019-03-01",null,null,null,null,{"$f":"'SRU Calc of funding'!AG14","v":0},{"$f":"'SRU Calc of funding'!W15","v":51465.893782383413},null,51465.893782383413]
["6906XfsR","NUSA","2019-04-01",null,null,null,null,null,null,{"$f":"+'SRU Calc of funding'!AH14","v":0},0]

{"sheet":"SRU Calc of funding","index":2,"n_rows":15,"n_cols":36,"rows_kept":15,"cut":false,"hidden":true,"merged":[[0,0,0,4],[4,3,4,7],[4,15,4,19],[4,24,4,26],[5,15,7,15],[5,14,7,14],[5,13,7,13],[5,12,7,12],[5,4,7,4],[5,3,7,3],[5,17,7,17],[5,16,7,16],[5,26,7,26],[5,25,7,25],[5,24,7,24],[4,2,7,2],[5,31,7,31],[4,27,4,30],[4,31,4,33],[5,19,7,19],[5,18,7,18],[4,20,4,23],[4,37,4,41],[4,35,7,35],[4,34,7,34],[5,33,7,33],[5,32,7,32],[4,1,7,1],[4,0,7,0],[5,11,7,11],[5,7,7,7],[5,6,7,6],[5,5,7,5],[4,11,4,14],[4,8,4,10],[5,8,7,8],[5,9,7,9]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M:\\Finance7\\PLANNING & PROJECTS\\School Budgets\\2017-18\\Budget\\Online Budget Spreadsheets Backup\\Special Resource Units Funding 2017-18 (Back Up).xls"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note Number of days corrected for Top up funding"]
["2018/19 Special Resource Units",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Needs amending each term"]
[]
["DfE","Passcode","School","Planned Places FY 2018/19",null,null,null,null,"Place Funding",null,null,"Additional Places to be funded by LA",null,null,null,"Estimated Pupils eligible for Top Up Funding FY 2018/19",null,null,null,null,"Estimated Top up funding 2018/19",null,null,null,"Actual pupils eligible for top Up funding 2018/19",null,null,"Actual Top up funding 2018/19",null,null,null,"Termly Adjustments 2018/19",null,null,"Forecast 2018/19 Budget","Revised Forecast 2018/19 Budget"]
[null,null,null,"School Status","April-August","Sept-March","Pro-rata Places","Element 2 Place funding given out by the EFA","Occupied pre-16 places as at October 2017","Unoccupied pre-16 places as at October 2017","Element 1 Place funding  received through schools/post 16 formula","April-August","Sept-March","Pro-rata Places","Place funding given out by the LA","Top-Up value per pupil","Estimated Pupils Summer Term","Estimated Pupils Autumn Term","Estimated Pupils Spring Term","Pro-rata Estimated Actual Pupils","Estimated Top up funding Summer Term","Estimated Top up funding AutumnTerm","Estimated Top up funding SpringTerm","Total Forecast Top-Up funding","Actual pupils (Pro Rata) Summer Term","Actual pupils (Pro Rata) Autumn Term","Actual pupils (Pro Rata) Spring Term","Actual Top up funding Summer Term","Actual Top up funding Autumn Term","Actual Top up funding Spring Term","Total Actual Top-Up funding","Adjustment to Summer Term Top up funding","Adjustment to Autumn Term Top up funding","Adjustment to Spring Term Top up funding"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Days:","Days:","Days:","Days:",null,null,null,"Days:","Days:","Days:","Days:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,68,70,55,193,null,null,null,68,70,55,193]
[2019,"2019N2K2","Bluecoat Primary","Academy",2,3,2.5833333333333335,21833.333333333336,1,1,4000,0,0,0,0,17059.875,2,3,3,2.6666666666666665,12021.466321243523,18562.558290155441,14584.867227979277,45168.891839378237,1.8088235294117647,null,null,10872.355569948186,0,0,10872.355569948186,-1149.1107512953367,0,0,71002.225172711565,69853.114421416234]
["4615a","4615SrWz-a","Bluecoat Academy (Pre 16)","Academy",6,6,6,36000,6,0,24000,0,0,0,0,17059.875,6,6,6,6,36064.398963730564,37125.116580310882,29169.734455958554,102359.25,5,null,null,30053.665803108808,0,0,30053.665803108808,-6010.7331606217558,0,0,162359.25,156348.51683937825]
["4615b","4615SrWz-b","Bluecoat Academy (Post 16)","Academy",11,11,11,66000,null,null,44000,0,0,0,0,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,0,0,0,110000,110000]
["6919a","69198zks","Bulwell Academy (pre 16)","Academy",6,6,6,36000,6,0,24000,0,0,0,0,17059.875,6,6,6,6,36064.398963730564,37125.116580310882,29169.734455958554,102359.25,5,null,null,30053.665803108808,0,0,30053.665803108808,-6010.7331606217558,0,0,162359.25,156348.51683937825]
["6919b","69198zks","Bulwell Academy (post 16)","Academy",10,10,10,60000,null,null,40000,0,0,0,0,null,null,null,null,0,0,0,0,null,null,null,null,0,0,0,0,0,0,0,100000,100000]
[2005,"2005Vb2Z","Firbeck Primary","Academy",12,12,12,72000,13,0,48000,0,0,0,0,12730.000000000033,12,12,12,12,53822.176165803241,55405.181347150399,43532.642487046745,152760.00000000038,13,null,null,58307.357512953524,0,0,58307.357512953524,4485.1813471502828,0,0,272760.00000000035,277245.18134715065]
[6906,"6906XfsR","NUSA","Academy",12,12,12,76000,11,1,44000,0,0,0,0,15049.874999999998,12,12,12,12,63630.559585492214,65502.046632124344,51465.893782383413,180598.49999999997,11,null,null,58328.01295336787,0,0,58328.01295336787,-5302.5466321243439,0,0,300598.5,295295.95336787566]

{"sheet":"Academy SRU Budgets 18-19","index":3,"n_rows":24,"n_cols":35,"rows_kept":24,"cut":false,"hidden":false,"merged":[[5,14,5,18],[0,0,0,3],[5,0,6,0],[5,1,6,1],[5,2,5,6],[5,10,5,13],[5,7,5,9],[5,19,5,22],[5,23,5,25],[5,26,5,28],[5,33,6,33],[5,34,6,34],[5,30,5,32]]}
[]
[]
["2018/19 Special Resource Units"]
[]
[]
["Passcode","School","Planned Places FY 2018/19",null,null,null,null,"Place Funding",null,null,"Additional Places to be funded by LA",null,null,null,"Estimated Pupils eligible for Top Up Funding FY 2018/19",null,null,null,null,"Estimated Top up funding 2018/19",null,null,null,"Actual pupils eligible for Top up funding 2018/19",null,null,"Actual Top up funding 2018/19",null,null,null,"Termly Adjustments 2018/19",null,null,"Original Forecast 2018/19 Budget","Revised Forecast 2018/19 Budget"]
[null,null,"School Status","April-August","Sept-March","Pro-rata Places","Element 2 Place funding given out by the EFA","Occupied pre-16 places as at October 2017","Unoccupied pre-16 places as at October 2017","Element 1 Place funding  received through schools/post 16 formula","April-August","Sept-March","Pro-rata Places","Place funding given out by the LA","Top-Up value per pupil","Estimated Pupils Summer Term","Estimated Pupils Autumn Term","Estimated Pupils Spring Term","Pro-rata Estimated Actual Pupils","Estimated Top up funding Summer Term","Estimated Top up funding AutumnTerm","Estimated Top up funding SpringTerm","Total Forecast Top-Up funding","Actual pupils Summer Term","Actual pupils Autumn Term","Actual pupils Spring Term","Actual Top up funding Summer Term","Actual Top up funding Autumn\nTerm","Actual Top up funding SpringTerm","Total Actual Top-Up funding","Adjustment to Summer Term Top up funding","Adjustment to Autumn Term Top up funding","Adjustment to Spring Term Top up funding"]
[null,{"$f":"IF(ISNA(VLOOKUP(A8,'SRU Calc of funding'!B9:C15,2,FALSE)),\"Please enter your 8 digit passcode in the blue cell\",VLOOKUP(A8,'SRU Calc of funding'!B9:C15,2,FALSE))","v":"Please enter your 8 digit passcode in the blue cell"},{"$f":"IF(ISNA(VLOOKUP(A8,'SRU Calc of funding'!B9:D15,3,FALSE)),\"\",VLOOKUP(A8,'SRU Calc of funding'!B9:D15,3,FALSE))","v":""},{"$f":"SUMIF('SRU Calc of funding'!$B$9:$B$15,$A$8,'SRU Calc of funding'!E9:E15)","v":0},{"$f":"SUMIF('SRU Calc of funding'!$B$9:$B$15,$A$8,'SRU Calc of funding'!F9:F15)","v":0},{"$f":"SUMIF('SRU Calc of funding'!$B$9:$B$15,$A$8,'SRU Calc of funding'!G9:G15)","v":0},{"$f":"SUMIF('SRU Calc of funding'!$B$9:$B$15,$A$8,'SRU Calc of funding'!H9:H15)","v":0},{"$f":"SUMIF('SRU Calc of funding'!$B$9:$B$15,$A$8,'SRU Calc of funding'!I9:I15)","v":0},{"$f":"SUMIF('SRU Calc of funding'!$B$9:$B$15,$A$8,'SRU Calc of funding'!J9:J15)","v":0},{"$f":"SUMIF('SRU Calc of funding'!$B$9:$B$15,$A$8,'SRU Calc of funding'!K9:K15)","v":0},{"$f":"SUMIF('SRU Calc of funding'!$B$9:$B$15,$A$8,'SRU Calc of funding'!L9:L15)","v":0},{"$f":"SUMIF('SRU Calc of funding'!$B$9:$B$15,$A$8,'SRU Calc of funding'!M9:M15)","v":0},{"$f":"SUMIF('SRU Calc of funding'!$B$9:$B$15,$A$8,'SRU Calc of funding'!N9:N15)","v":0},{"$f":"SUMIF('SRU Calc of funding'!$B$9:$B$15,$A$8,'SRU Calc of funding'!O9:O15)","v":0},{"$f":"SUMIF('SRU Calc of funding'!$B$9:$B$15,$A$8,'SRU Calc of funding'!P9:P15)","v":0},{"$f":"SUMIF('SRU Calc of funding'!$B$9:$B$15,$A$8,'SRU Calc of funding'!Q9:Q15)","v":0},{"$f":"SUMIF('SRU Calc of funding'!$B$9:$B$15,$A$8,'SRU Calc of funding'!R9:R15)","v":0},{"$f":"SUMIF('SRU Calc of funding'!$B$9:$B$15,$A$8,'SRU Calc of funding'!S9:S15)","v":0},{"$f":"SUMIF('SRU Calc of funding'!$B$9:$B$15,$A$8,'SRU Calc of funding'!T9:T15)","v":0},{"$f":"SUMIF('SRU Calc of funding'!$B$9:$B$15,$A$8,'SRU Calc of funding'!U9:U15)","v":0},{"$f":"SUMIF('SRU Calc of funding'!$B$9:$B$15,$A$8,'SRU Calc of funding'!V9:V15)","v":0},{"$f":"SUMIF('SRU Calc of funding'!$B$9:$B$15,$A$8,'SRU Calc of funding'!W9:W15)","v":0},{"$f":"SUMIF('SRU Calc of funding'!$B$9:$B$15,$A$8,'SRU Calc of funding'!X9:X15)","v":0},{"$f":"SUMIF('SRU Calc of funding'!$B$9:$B$15,$A$8,'SRU Calc of funding'!Y9:Y15)","v":0},{"$f":"SUMIF('SRU Calc of funding'!$B$9:$B$15,$A$8,'SRU Calc of funding'!Z9:Z15)","v":0},{"$f":"SUMIF('SRU Calc of funding'!$B$9:$B$15,$A$8,'SRU Calc of funding'!AA9:AA15)","v":0},{"$f":"SUMIF('SRU Calc of funding'!$B$9:$B$15,$A$8,'SRU Calc of funding'!AB9:AB15)","v":0},{"$f":"SUMIF('SRU Calc of funding'!$B$9:$B$15,$A$8,'SRU Calc of funding'!AC9:AC15)","v":0},{"$f":"SUMIF('SRU Calc of funding'!$B$9:$B$15,$A$8,'SRU Calc of funding'!AD9:AD15)","v":0},{"$f":"SUMIF('SRU Calc of funding'!$B$9:$B$15,$A$8,'SRU Calc of funding'!AE9:AE15)","v":0},{"$f":"SUMIF('SRU Calc of funding'!$B$9:$B$15,$A$8,'SRU Calc of funding'!AF9:AF15)","v":0},{"$f":"SUMIF('SRU Calc of funding'!$B$9:$B$15,$A$8,'SRU Calc of funding'!AG9:AG15)","v":0},{"$f":"SUMIF('SRU Calc of funding'!$B$9:$B$15,$A$8,'SRU Calc of funding'!AH9:AH15)","v":0},{"$f":"SUMIF('SRU Calc of funding'!$B$9:$B$15,$A$8,'SRU Calc of funding'!AI9:AI15)","v":0},{"$f":"SUMIF('SRU Calc of funding'!$B$9:$B$15,$A$8,'SRU Calc of funding'!AJ9:AJ15)","v":0}]
[]
[]
[]
["Notes"]
[]
["1. Insert your passcode in cell A8 - this will populate your schools data.  Please note this is case sensitive."]
["2. Cell G8 shows the total place funding that will be given to your school from the EFA."]
["3. Cell K8 shows the additional place funding that has been approved to be funded by the Local Authority."]
["4. Cells Q8 to S8 show the estimated top up funding each term and cells X8 to Z8 show the actual top up funding for the term.  The difference between the estimated and actual top up funding will be added or deducted from the following terms estimated top up funding. "]
["5. Refer the \"Payments Details\" tab for a breakdown of the payments made to your school during the financial year 2018/19."]
[]
["For your information"]
[]
["Each time a payment is sent to your school a revised version of the file will be uploaded and we will notify you via Scene when this has occurred."]
[]
["Please note - we have had to make a correction to the number of school days per term compared to those used in the indicative budgets which has affected the apportionment of the annual top-up value by term slightly.  This means you will see a minor adjustment in top up funding in summer compared to the estimate even if the pupil numbers are exactly as forecast."]

{"sheet":"Payments Details","index":4,"n_rows":5,"n_cols":11,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
["2018/19 Payments Details"]
[]
["Passcode","Academy","Approximate date paid","Place Funding","Estimated Top Up Funding Summer Term","Adjustment to Summer Term Top Up Funding","Estimated Top Up Funding Autumn Term","Adjustment to Top Up Funding Autumn Term","Estimated Top Up Funding Spring Term","Adjustment to Spring Term Top Up Funding","Total paid to Academy"]