{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Special Schools Budgets 2017-18","Payments&Budget adjustments","LA Data view","Payments-budget adjustments sum","VIRE"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Special Schools Budgets 2017-18","index":0,"n_rows":23,"n_cols":38,"rows_kept":23,"cut":false,"hidden":false,"merged":[[11,6,11,8],[1,0,1,3],[3,24,3,27],[3,2,3,5],[3,9,3,13],[3,6,3,8],[3,14,3,16],[3,17,3,20],[3,21,3,23],[3,28,3,31],[3,32,3,34],[3,35,4,35],[3,36,4,36],[3,37,4,37]]}
[]
["Special School Budgets"]
[]
[null,null,"Planned Places FY 2017/18",null,null,null,"Forecast Pupil Numbers 2017/18",null,null,"Indicative Top Up Funding FY 2017/18",null,null,null,null,"Actual Pupil Numbers 2017/18",null,null,"Actual Top Up Funding FY 2017/18",null,null,null,"Top Up Funding Adjustment 2017/18",null,null,"Estimate of additional place Funding 2017/18 to be paid by the LA",null,null,null,"Actual additional place funding based on filled places",null,null,null,"Additional Place Funding Adjustment 2017/18",null,null,"BSF/PFI Funding","Total Indicative School Budget 2017-18","Total Revised School Budget 2017-18"]
["Passcode","School","April-Aug 2017","Sept-Mar 2017/18","Composite Fin Yr Places","Total Funding for EFA published places","Summer Term","Autumn Term","Spring Term","Top Up Funding Per Pupil Per Annum","Summer Term","Autumn Term","Spring Term","Total Top Up Funding","Summer Term","Autumn Term","Spring Term","Summer Term","Autumn Term","Spring Term","Total Actual Top Up Funding","Summer Term","Autumn Term","Spring Term","Summer Term","Autumn Term","Spring Term","Estimated additional place funding","Summer Term","Autumn Term","Spring Term","Total Actual Additional Place funding","Summer Term","Autumn Term","Spring Term"]
[null,{"$f":"IF(ISNA(VLOOKUP(A6,'LA Data view'!A:C,3,0)),\"Please enter your 8 digit passcode in cell A6\",VLOOKUP(A6,'LA Data view'!A:C,3,0))","v":"Please enter your 8 digit passcode in cell A6"},{"$f":"SUMIF('LA Data view'!$A$6:$A$10,$A$6,'LA Data view'!D$6:D$10)","v":0},{"$f":"SUMIF('LA Data view'!$A$6:$A$10,'Special Schools Budgets 2017-18'!$A$6,'LA Data view'!E$6:E$10)","v":0},{"$f":"SUMIF('LA Data view'!$A$6:$A$10,'Special Schools Budgets 2017-18'!$A$6,'LA Data view'!F$6:F$10)","v":0},{"$f":"E6*10000","v":0},{"$f":"SUMIF('LA Data view'!$A$6:$A$10,'Special Schools Budgets 2017-18'!$A$6,'LA Data view'!H$6:H$10)","v":0},{"$f":"SUMIF('LA Data view'!$A$6:$A$10,'Special Schools Budgets 2017-18'!$A$6,'LA Data view'!I$6:I$10)","v":0},{"$f":"SUMIF('LA Data view'!$A$6:$A$10,'Special Schools Budgets 2017-18'!$A$6,'LA Data view'!J$6:J$10)","v":0},{"$f":"SUMIF('LA Data view'!$A$6:$A$10,'Special Schools Budgets 2017-18'!$A$6,'LA Data view'!K$6:K$10)","v":0},{"$f":"G6*J6*66/198","v":0},{"$f":"H6*J6*78/198","v":0},{"$f":"I6*J6*54/198","v":0},{"$f":"SUM(K6:M6)","v":0},{"$f":"SUMIF('LA Data view'!$A$6:$A$10,'Special Schools Budgets 2017-18'!$A$6,'LA Data view'!P$6:P$10)","v":0},{"$f":"SUMIF('LA Data view'!$A$6:$A$10,'Special Schools Budgets 2017-18'!$A$6,'LA Data view'!Q$6:Q$10)","v":0},{"$f":"SUMIF('LA Data view'!$A$6:$A$10,'Special Schools Budgets 2017-18'!$A$6,'LA Data view'!R$6:R$10)","v":0},{"$f":"O6*J6*66/192","v":0},{"$f":"P6*J6*4/12","v":0},{"$f":"Q6*J6*3/12","v":0},{"$f":"SUM(R6:T6)","v":0},{"$f":"SUMIF('LA Data view'!$A$6:$A$10,'Special Schools Budgets 2017-18'!$A$6,'LA Data view'!W$6:W$10)","v":0},{"$f":"SUMIF('LA Data view'!$A$6:$A$10,'Special Schools Budgets 2017-18'!$A$6,'LA Data view'!X$6:X$10)","v":0},{"$f":"SUMIF('LA Data view'!$A$6:$A$10,'Special Schools Budgets 2017-18'!$A$6,'LA Data view'!Y$6:Y$10)","v":0},{"$f":"SUMIF('LA Data view'!$A$6:$A$10,'Special Schools Budgets 2017-18'!$A$6,'LA Data view'!Z$6:Z$10)","v":0},{"$f":"SUMIF('LA Data view'!$A$6:$A$10,'Special Schools Budgets 2017-18'!$A$6,'LA Data view'!AA$6:AA$10)","v":0},{"$f":"SUMIF('LA Data view'!$A$6:$A$10,'Special Schools Budgets 2017-18'!$A$6,'LA Data view'!AB$6:AB$10)","v":0},{"$f":"SUM(Y6:AA6)","v":0},{"$f":"SUMIF('LA Data view'!$A$6:$A$10,'Special Schools Budgets 2017-18'!$A$6,'LA Data view'!AD$6:AD$10)","v":0},{"$f":"SUMIF('LA Data view'!$A$6:$A$10,'Special Schools Budgets 2017-18'!$A$6,'LA Data view'!AE$6:AE$10)","v":0},{"$f":"SUMIF('LA Data view'!$A$6:$A$10,'Special Schools Budgets 2017-18'!$A$6,'LA Data view'!AF$6:AF$10)","v":0},{"$f":"SUMIF('LA Data view'!$A$6:$A$10,'Special Schools Budgets 2017-18'!$A$6,'LA Data view'!AH$6:AH$10)","v":0},{"$f":"SUMIF('LA Data view'!$A$6:$A$10,'Special Schools Budgets 2017-18'!$A$6,'LA Data view'!AH$6:AH$10)","v":0},{"$f":"SUMIF('LA Data view'!$A$6:$A$10,'Special Schools Budgets 2017-18'!$A$6,'LA Data view'!AI$6:AI$10)","v":0},{"$f":"SUMIF('LA Data view'!$A$6:$A$10,'Special Schools Budgets 2017-18'!$A$6,'LA Data view'!AJ$6:AJ$10)","v":0},{"$f":"SUMIF('LA Data view'!$A$6:$A$10,'Special Schools Budgets 2017-18'!$A$6,'LA Data view'!AK$6:AK$10)","v":0},{"$f":"F6+N6+AB6+AJ6","v":0},{"$f":"F6+K6+L6+M6+V6+Y6+Z6+AA6+AG6+AH6+AI6+AJ6","v":0}]
[]
[]
["Notes"]
[]
["1. Insert your passcode in cell A6 - this will populate your schools data."]
["2. Cell F6 shows the total place funding that will be given to your school from the EFA."]
["3. Cells K6 to M6 show the estimated top up funding each term and cells R6 to T6 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 payment for academies or adjusted on maintained schools budget (this will also be reflected on maintained schools budget share letters.)"]
["4. Cell AB6 shows the additional place funding that will be funded by the Local Authority."]
["5. Cell AK6 shows the total estimated funding for the year as at 1st April 2017."]
["6. Cell AL6 shows the revised total estimated funding for the year based on the actual funding to date plus the remaining estimated funding for the year."]
["7. Refer the \"Payments&Budget adjustments\" tab for a breakdown of the payments made to your school during the financial year 2017/18."]
[]
["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 an increase in top up funding in summer compared to the estimate even if the pupil numbers are exactly as forecast."]

{"sheet":"Payments&Budget adjustments","index":1,"n_rows":2,"n_cols":11,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
["DFE number","Academy","Approximate date paid/Virement processed for maintained schools","Place Funding","Estimated Top Up Funding ","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/Budget Share Letter"]

{"sheet":"LA Data view","index":2,"n_rows":18,"n_cols":41,"rows_kept":18,"cut":false,"hidden":true,"merged":[[3,3,3,6],[3,7,3,9],[3,10,3,14],[3,15,3,17],[3,18,3,21],[3,38,4,38],[3,22,3,24],[3,25,3,28],[3,29,3,32],[3,33,3,35],[3,36,4,36],[3,37,4,37]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Days in term"]
["2017-2018 (For Indicicatives)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66,72,54]
[]
[null,null,null,"Planned Places FY 2017/18",null,null,null,"Forecast Pupil Numbers 2017/18",null,null,"Estimated Top Up Funding 2017/18",null,null,null,null,"Actual Pupil Numbers 2017/18",null,null,"Actual Top Up Funding 2017/18",null,null,null,"Top Up Funding Adjustment 2017/18",null,null,"Estimate of additional place Funding 2017/18 to be paid by the LA",null,null,null,"Actual additional place funding based on filled places",null,null,null,"Additional Place Funding Adjustment 2017/18",null,null,"BSF/PFI Funding","Total Indicative School Budget 2017-18","Total Adjusted School Budget 2017-18"]
["Passcode","DfE","School","April-Aug (5/12)","Sept-Mar (7/12)","Composite Fin Yr Places","Total Place Funding Given out by the EFA","Summer Term","Autumn Term","Spring Term","Top Up Funding Per Pupil Per Annum","Summer Term","Autumn Term","Spring Term","Total Top Up Funding","Summer Term","Autumn Term","Spring Term","Summer Term","Autumn Term","Spring Term","Total Actual Top Up Funding","Summer Term","Autumn Term","Spring Term","Summer Term","Autumn Term","Spring Term","Estimated additional place funding","Summer Term","Autumn Term","Spring Term","Total Actual Additional Place funding","Summer Term","Autumn Term","Spring Term"]
["7040gxws",7040,"WESTBURY SPECIAL SCHOOL",67,76,72.25,722500,64,72.2,72.2,14627.585109132178,312055.14899481979,416043.98131610488,288030.44860345725,1016129.578914382,70.924242424242422,null,null,356623.57237420691,0,0,356623.57237420691,44568.423379387124,0,0,null,null,null,0,null,null,null,0,0,null,null,null,1738629.578914382,1783198.0022937693]
["7026waXR",7026,"NETHERGATE SCHOOL",105,112,109.08333333333333,1090833.3333333333,107,106.39999999999999,106.39999999999999,6662,237611.33333333334,279238.73939393938,193319.12727272726,710169.2,106.40909090909091,null,null,243683.46875,0,0,243683.46875,6072.135416666657,0,0,29166.666666666668,null,null,29166.666666666668,29166.666666666668,null,null,29166.666666666668,0,null,null,null,1830169.2,1836241.3354166665]
["7035tAdH",7035,"ROSEHILL SPECIAL  SCHOOL",110,110,110,1100000,99,104.5,104.5,11209.286160188762,369906.44328622916,461448.94692777074,319464.65556537977,1150820.0457793796,104.65151515151516,null,null,403242.39327304048,0,0,403242.39327304048,33335.94998681132,0,0,null,null,null,0,null,null,null,0,0,null,null,123402,2374222.0457793796,2407557.9957661908,null,"sent on bs"]
["7033Jgem",7033,"WOODLANDS SPECIAL SCHOOL",65,68,66.75,667500,65,64.599999999999994,64.599999999999994,9951.5726318367633,215617.40702312987,253252.44533989436,175328.61600454224,644198.46836756647,66,null,null,225776.30408479657,0,0,225776.30408479657,10158.897061666707,0,0,null,null,null,0,null,null,null,0,0,null,null,null,1311698.4683675664,1321857.3654292331]
["7042NwsN",7042,"OAK FIELD SPECIAL SCHOOL",160,160,160,1600000,155,152,152,9501.9481426190287,490933.9873686498,568965.13726712728,393898.94118493429,1453798.0658207112,153.14242424242423,null,null,500208.28467035183,0,0,500208.28467035183,9274.2973017020267,0,0,null,null,null,0,null,null,null,0,0,null,null,671839,3725637.0658207112,3734911.3631224134,null,"sent on bs"]
[null,null,null,null,null,null,5180833.333333333,null,null,null,null,null,null,null,4975115.3588820398,501.12727272727273,0,0,1729534.0231523959,0,0,1729534.0231523959,103409.70314623383,0,0,29166.666666666668,0,0,29166.666666666668,29166.666666666668,null,null,29166.666666666668,0,0,0,795241,10980356.358882038,11083766.062028272]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check value if 198 days"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P6*$K6*S$2/198","v":345816.79745377635}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P7*$K7*S$2/198","v":236299.12121212122}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,391022.92681022111]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,218934.59790040879]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,485050.45786215935]

{"sheet":"Payments-budget adjustments sum","index":3,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[]
["DFE number","Academy","Approximate date paid/Virement processed for maintained schools","Place Funding + BSI/PFI 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/Budget Share Letter"]
[7040,"WESTBURY SPECIAL SCHOOL","2017-06-01",null,{"$f":"'LA Data view'!L6","v":312055.14899481979},null,null,null,null,null,{"$f":"SUM(D3:J3)","v":312055.14899481979}]
[7040,"WESTBURY SPECIAL SCHOOL","2017-09-01",null,null,{"$f":"'LA Data view'!W6","v":44568.423379387124},{"$f":"'LA Data view'!M6","v":416043.98131610488},null,null,null,{"$f":"SUM(D4:J4)","v":460612.404695492}]
[7040,"WESTBURY SPECIAL SCHOOL","2018-01-01",null,null,null,null,{"$f":"+'LA Data view'!X6","v":0},null,null,{"$f":"SUM(D5:J5)","v":0}]
[7040,"WESTBURY SPECIAL SCHOOL","2018-04-01",null,null,null,null,null,null,{"$f":"+'LA Data view'!Y6","v":0},{"$f":"SUM(D6:J6)","v":0}]
[7026,"NETHERGATE SCHOOL","2017-06-01",{"$f":"'LA Data view'!Z7","v":29166.666666666668},{"$f":"'LA Data view'!L7","v":237611.33333333334},null,null,null,null,null,{"$f":"SUM(D7:J7)","v":266778}]
[7026,"NETHERGATE SCHOOL","2017-09-01",null,null,{"$f":"'LA Data view'!W7","v":6072.135416666657},{"$f":"'LA Data view'!M7","v":279238.73939393938},null,null,null,{"$f":"SUM(D8:J8)","v":285310.87481060601}]
[7026,"NETHERGATE SCHOOL","2018-01-01",null,null,null,null,{"$f":"+'LA Data view'!X7","v":0},0,null,0]
[7026,"NETHERGATE SCHOOL","2018-04-01",null,null,null,null,null,null,{"$f":"+'LA Data view'!Y7","v":0},0]
[7035,"ROSEHILL SPECIAL  SCHOOL","2017-06-01",{"$f":"'LA Data view'!G8+'LA Data view'!AK8","v":1223402},{"$f":"'LA Data view'!O8","v":1150820.0457793796},null,null,null,null,null,{"$f":"SUM(D11:J11)","v":2374222.0457793796}]
[7035,"ROSEHILL SPECIAL  SCHOOL","2017-09-01",null,null,{"$f":"'LA Data view'!W8","v":33335.94998681132},null,null,null,null,33335.94998681132]
[7035,"ROSEHILL SPECIAL  SCHOOL","2018-01-01",null,null,null,null,{"$f":"+'LA Data view'!X8","v":0},null,null,0]
[7035,"ROSEHILL SPECIAL  SCHOOL","2018-04-01",null,null,null,null,null,null,{"$f":"+'LA Data view'!Y8","v":0},0]
[7033,"WOODLANDS SPECIAL SCHOOL","2017-06-01",null,{"$f":"'LA Data view'!L9","v":215617.40702312987},null,null,null,null,null,215617.40702312987]
[7033,"WOODLANDS SPECIAL SCHOOL","2017-09-01",null,null,{"$f":"'LA Data view'!W9","v":10158.897061666707},{"$f":"'LA Data view'!M9","v":253252.44533989436},null,null,null,263411.34240156109]
[7033,"WOODLANDS SPECIAL SCHOOL","2018-01-01",null,null,null,null,{"$f":"+'LA Data view'!X9","v":0},null,null,0]
[7033,"WOODLANDS SPECIAL SCHOOL","2018-04-01",null,null,null,null,null,null,{"$f":"+'LA Data view'!Y9","v":0},0]
[7042,"OAK FIELD SPECIAL SCHOOL","2017-06-01",{"$f":"'LA Data view'!G10+'LA Data view'!AK10","v":2271839},{"$f":"'LA Data view'!O10","v":1453798.0658207112},null,null,null,null,null,3725637.0658207112]
[7042,"OAK FIELD SPECIAL SCHOOL","2017-09-01",null,null,{"$f":"'LA Data view'!W10","v":9274.2973017020267},null,null,null,null,9274.2973017020267]
[7042,"OAK FIELD SPECIAL SCHOOL","2018-01-01",null,null,null,null,{"$f":"+'LA Data view'!X10","v":0},null,null,0]
[7042,"OAK FIELD SPECIAL SCHOOL","2018-04-01",null,null,null,null,null,null,{"$f":"+'LA Data view'!Y10","v":0},0]

{"sheet":"VIRE","index":4,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":true,"merged":[[8,1,8,3],[9,1,9,3],[0,1,0,8],[2,1,2,8],[3,1,3,3],[4,1,4,3],[6,1,6,3],[7,1,7,3]]}
["Reason for virement","Special Schools Summer Term Top-Up Funding "]
["User's Initials","CJW","Max 4 characters"]
["Oracle Batch Name",{"$f":"LEFT(B9,2)&\" \"&MID(B1,1,21)&\" \"&TEXT(TODAY(),\"ddmmm\")","v":"03 Special Schools Summe 05Oct"}]
["Header","Header Value"]
["  Set of Books","NCC Primary Ledger",null,null,null,null,null,null,{"$f":"\"20\"&MID(B7,8,2) & \"/20\" &RIGHT(B7,2)","v":"2016/2017"}]
["  Financial Year",{"$f":"\"20\"&RIGHT(B7,2)","v":"2017"},"Start Period","12 - 2016",null,null,null,null,"Balance £50,000"]
["  Budget Version","NCC_BL_16/17",null,null,null,null,null,null,"Balance £500"]
["  Budget Organisation","NCC Budget Org",null,null,null,null,null,null,"Internal Balance"]
["  Reason Code","03-Temporary/OneOff Virement",null,null,null,null,null,null,"Fund Type Balance"]
["  Reason Type","Schools",null,null,null,null,null,"Total Amount:",{"$f":"SUM(I13:I65525)","v":0}]
[]
["Budget Upload Type\n(P = Profile)","Org.","Dept.","Cost Centre","Analysis","Corporate Subjective","Detailed Subjective","Profile Code","Annual \nAmount","ACCOUNT TYPE","Fund Type Check","Allow Budget?","Is Cost Centre Text Format?"]
["P","N","E","0345","054","499","0","MONTHLY",-33336,null,null,null,"Rosehill"]
["P","N","E","0054","000","091","3","MONTHLY",33336,null,null,null,"Rosehill"]
["P","N","E","0345","051","091","3","MONTHLY",-9274,null,null,null,"Oak Field School"]
["P","N","E","0051","000","091","3","MONTHLY",9274,null,null,null,"Oak Field School"]