{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["1. Introduction","2. Key Results","3. Questionnaire","4. Input table","5. Staffing costs profile","6. Revenue costs profile","7. Capital Costs Profile","8. Summary Demand and Supply","9. Capital Projects ","Analysis "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":3,"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":"1. Introduction","index":0,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,0,27,2]]}
["ELC Expansion Plan - Finance Template"]
["Introduction"]
[]
["Local authority name","City of Edinburgh Council"]
[]
["ELC Expansion Plan - Lead contact"]
["Name"]
["Contact email / phone number"]
[]
["Finance Template - Lead contact"]
["Name"]
["Contact email / phone number"]
[]
["Comments "]
["Rows 25-38 of worksheet 6 contain marginal costs associated with Buildings and Facilities Management."]

{"sheet":"2. Key Results","index":1,"n_rows":44,"n_cols":15,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,4,0,5]]}
["Uptake Population",null,"2016/17","2021/22","Movement "]
[null,"2's",{"$f":"'4. Input table'!C17","v":432.83519999999999},{"$f":"'4. Input table'!H17","v":1153.32},{"$f":"D2-C2","v":720.48479999999995},{"$f":"E2/C2","v":1.6645707188324794}]
[null,"3&4's",{"$f":"'4. Input table'!J17+'4. Input table'!Q17","v":10152.799999999999},{"$f":"'4. Input table'!O17+'4. Input table'!V17","v":9844.48},{"$f":"D3-C3","v":-308.31999999999971},{"$f":"E3/C3","v":-3.0367977306752791E-2}]
[null,"5's",{"$f":"'4. Input table'!X17","v":466.31000000000006},{"$f":"'4. Input table'!AC17","v":441.745},{"$f":"D4-C4","v":-24.565000000000055},{"$f":"E4/C4","v":-5.2679547940211555E-2}]
[null,null,{"$f":"SUM(C2:C4)","v":11051.945199999998},{"$f":"SUM(D2:D4)","v":11439.545},{"$f":"SUM(E2:E4)","v":387.59980000000019},{"$f":"E5/C5","v":3.5070731259145248E-2}]
[]
["Type of Provision",null,"LA","PP","CM"]
[null,"2016/17"]
[null,"2's",{"$f":"'4. Input table'!C30","v":0.8},{"$f":"'4. Input table'!C31","v":0.2},{"$f":"'4. Input table'!C32","v":0}]
[null,"3&4's",{"$f":"'4. Input table'!J30","v":0.65},{"$f":"'4. Input table'!J31","v":0.35},{"$f":"'4. Input table'!J32","v":0}]
[null,"5's",{"$f":"'4. Input table'!X30","v":0.6},{"$f":"'4. Input table'!X31","v":0.4},{"$f":"'4. Input table'!X32","v":0}]
[null,"2021/22",null,null,null,null,null,null,null,null,"dropdown menu options to be made blank in final"]
[null,"2's",{"$f":"'4. Input table'!H30","v":0.8},{"$f":"'4. Input table'!H31","v":0.19},{"$f":"'4. Input table'!H32","v":0.01},null,null,null,null,null,"Excluded","Included",null,"Same","Different"]
[null,"3&4's",{"$f":"'4. Input table'!O30","v":0.64},{"$f":"'4. Input table'!O31","v":0.35},{"$f":"'4. Input table'!O32","v":0.01}]
[null,"5's",{"$f":"'4. Input table'!AC30","v":0.6},{"$f":"'4. Input table'!AC31","v":0.39},{"$f":"'4. Input table'!AC32","v":0.01}]
[null,"Movement "]
[null,"2's",{"$f":"C13-C9","v":0},{"$f":"D13-D9","v":-1.0000000000000009E-2},0.01]
[null,"3&4's",{"$f":"C14-C10","v":-1.0000000000000009E-2},{"$f":"D14-D10","v":0},0.01]
[null,"5's",{"$f":"C15-C11","v":0},{"$f":"D15-D11","v":-1.0000000000000009E-2},0.01]
[]
[null,"Cost of 1 Hour of ELC in LA Settings","2016-17","2021-22","Movement"]
[null,null,{"$f":"(('6. Revenue costs profile'!J12+'6. Revenue costs profile'!J44)*1000000)/('4. Input table'!C36+'4. Input table'!J36+'4. Input table'!X36)","v":5.4601270249557841},{"$f":"(('6. Revenue costs profile'!O12+'6. Revenue costs profile'!O44)*1000000)/('4. Input table'!H36+'4. Input table'!O36+'4. Input table'!AC36)","v":6.3204647649519075},{"$f":"(D22-C22)/C22","v":0.15756734890303956}]
[]
["Partner Rates",null,"2016/17","2021/22","Movement ","LW","CM"]
[null,"2's",{"$f":"'4. Input table'!C41","v":3.6},{"$f":"'4. Input table'!H41","v":5.31},{"$f":"D25-C25","v":1.7099999999999995},"Included","Same"]
[null,"3&4's",{"$f":"'4. Input table'!J41","v":3.6},{"$f":"'4. Input table'!O41","v":5.31},{"$f":"D26-C26","v":1.7099999999999995}]
[null,"5's",{"$f":"'4. Input table'!X41","v":3.6},{"$f":"'4. Input table'!AC41","v":5.31},{"$f":"D27-C27","v":1.7099999999999995}]
[]
["Estimated Revenue","Now ","2016/17",{"$f":"'6. Revenue costs profile'!J46","v":29.95399164581567},"m","Lunches","Interim Years"]
[null,"In ","2021/22",{"$f":"'6. Revenue costs profile'!O46","v":76.313616409911177},"m","Excluded","Excluded"]
[null,null,"Increase",{"$f":"D30-D29","v":46.359624764095507},"m"]
["Estimated Capital",null,"Total",{"$f":"'7. Capital Costs Profile'!G14","v":39.386635098591547},"m","2017/18 ","Breakdown"]
[null,null,null,null,null,"Included","Excluded"]
["Ratio-Committed Staff Productivity",null,"2016/17","2021/22","Movement"]
[null,"Hours delivered per FTE Ratio-Committed Staff (Indicative)",{"$f":"('4. Input table'!C36+'4. Input table'!J36+'4. Input table'!X36)/(SUMIF('5. Staffing costs profile'!$C$7:$C$33,\"Ratio\",'5. Staffing costs profile'!I7:I33))","v":7597.2014152002994},{"$f":"('4. Input table'!H36+'4. Input table'!O36+'4. Input table'!AC36)/(SUMIF('5. Staffing costs profile'!C7:C33,\"Ratio\",'5. Staffing costs profile'!N7:N33))","v":8539.2217533028142},{"$f":"(D35-C35)/C35","v":0.12399570402566175}]
[]
["Proposed LA Capacity to Child Ratio",null,"Current ","Proposed",null,"Minimum Hours Required"]
[null,"Total Physical LA Capacity",{"$f":"'8. Summary Demand and Supply'!C29","v":4096},{"$f":"'8. Summary Demand and Supply'!J29","v":6413},null,"LA",{"$f":"'4. Input table'!H36+'4. Input table'!O36+'4. Input table'!AC36","v":7765968.8760000002}]
[null,"Children in LA Prov",{"$f":"'8. Summary Demand and Supply'!D29","v":6750},{"$f":"'8. Summary Demand and Supply'!K29","v":8635},null,"PP",{"$f":"'4. Input table'!H37+'4. Input table'!O37+'4. Input table'!AC37","v":3952764.5790000004}]
[null,"Ratio : 1",{"$f":"C39/C38","v":1.64794921875},{"$f":"D39/D38","v":1.3464837049742711},null,"CM",{"$f":"'4. Input table'!H38+'4. Input table'!O38+'4. Input table'!AC38","v":118371.045}]
[null,null,null,null,null,null,{"$f":"SUM(G38:G40)","v":11837104.5}]
[]
[null,null,null,null,null,"If LA capacity open 1140 hours - total hours available",{"$f":"D38*1140","v":7310820}]
[null,null,null,null,null,"If LA capacity open 2500 hours - total hours available",{"$f":"D38*2500","v":16032500}]

{"sheet":"3. Questionnaire","index":2,"n_rows":74,"n_cols":2,"rows_kept":74,"cut":false,"hidden":false,"merged":[[73,0,73,1],[49,0,55,0],[49,1,55,1],[2,0,2,1],[33,0,38,0],[33,1,38,1],[40,0,47,0],[40,1,47,1],[6,0,16,0],[6,1,16,1],[21,0,31,0],[21,1,31,1]]}
[]
["ELC 1140 hours expansion planning – Finance Templates V2 supporting questionnaire"]
["The finance template is, by necessity, relatively simple and will inevitably only partially capture the complexity of the expansion planning process and the information which local authorities wish to provide. This short questionnaire focuses on some of the key assumptions which will contribute to the cost of the expansion and allows you to explain the quantitative results which you have provided in the spreadsheet template. Please answer as fully as possible. You can also add any other supporting information which you think might be helpful. \n\nIf you prefer, you can enter this information in a word document and attach to your submission. "]
["Flexibility"]
[]
[1,"How is the requirement to provide a flexible ELC offer captured in your finance template? For example, how does it affect your anticipated workforce  and capital requirements and how does it affect your costs?"]
[null,"The number of local authority settings open all year round will increase from 17 to 43 and all of these will be open between 8.00am and 6.00pm.  20 all year round settings will be dependent on capital funding.  119 FTE Early Years Assistants will be recruited to support holiday cover in all year round settings."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Workforce"]
[]
[2,"How have you calculated your anticipated requirement for ratio-committed staff? Can you detail what assumptions you make about the time available to ratio-committed staff to actually spend delivering ELC to children. In particular how much time (days or %) would you expect staff on average to spend on:\n- holidays\n- sickness\n- training\n- other non-contact time \n- contact time (%) (in the national funding model we assume around 80%)\n"]
[null,"Structures have been created to ensure holiday cover can be managed within each establishments core allocation. Holiday entitlement varies from 4.4 weeks to 13 weeks dependant on post and length of service.\nThe budget for sickness cover has been increased on a pro-rata phased basis in line wih the increases in total FTE employed.\nAn additional Early Years Practitioner allocation of 0.22 FTE to cover non-contact time  has been allocated for each additional Teaching FTE.\nA Peripateic EYP team will be created to supplement core staffing as and where required."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[3,"On average, due to staggered starts after the child’s birthday, three year olds will receive around 75% of the full entitlement. How is this accounted for in your workforce estimates (in the national funding model we assume that this allows for a reduced staff component)?"]
[null,"Since the increase from 475 to 600 hours, Edinburgh early years settings have been staffed according to intake and child:staff ratio requirements.  This is allocated on a termly basis August, January and March/April. Attendance figures indicate a full year average uptake of 78%."]
[]
[]
[]
[]
[]
[4,"How have you calculated your anticipated requirement for non-ratio committed staff , for example managers and specialists (in the national funding model we work on a ratio of 0.8 FTE per setting)?"]
[null,"Managers (settings) are out of ratio.  Senior Early Years Officers are in ratio 0.5.  All year round provision requires two Senior Early Years Officers."]
[]
[]
[]
[]
[]
[]
[]
[5,"How have you calculated your anticipated requirement for central staff (ie staff contributing to the provision of the funded entitlement but not involved in direct delivery within settings)?"]
[null,"The expansion will require a significant increase in input from the central early years team working closely with all other relevant council departments to support delivery.  Due to the scale of the expansion this will be the key remit of a Senior Officer along with the allocation of staff to support the day to day administration of the programme e.g. clerical and systems support.\nA pro-rata increase based on current provision has been applied to admin staff allocations for establishments moving to year round provision. \nAdditional staff for Quality Assurance, Admin support (e.g. payments to Partner Providers) and  Central Management have also been driven by a pro-rata comparison of current demand  to expected future demand."]
[]
[]
[]
[]
[]
[]
[]
[]
["Population and uptake"]
[6,"How have you calculated population estimates?"]
[null,"We have used actual birth figures in primary catchment areas and a proportion of pupil generation in primary catchment areas from known housing development forecast to be delivered in the Plan period and identified in the Council’s Housing Land Audit 2017. "]
[7,"How have you estimated future uptake by 2 year olds (in the national funding model we assume an uptake of 50% nationally. Further info on local authority estimates of eligibility and uptake is provided at annex C of the Guidance Note)?"]
[null,"Using our experience of the uptake of 4 years olds then 3 year old places when these were introduced, we predict that whilst uptake will be slow initially, this will increase to almost all once the provision is more widely publicised and there is an increased awareness of this entitlement amongst parents."]
[]
[]
["Lunches and other costs"]
[8,"How have you calculated lunch unit cost (in the national funding model wwe use a figure of £3.00 based on the cost of lunches in P1-P3)?"]
[null,"We have calculated lunch unit costs at £3.00 in line with the national funding model ."]
[9,"How have you estimated running costs? For example, have you assumed an increase that is more or less than proportional to the scale of the expansion? How does it link to you infrastructure plans/"]
[null,"Each category of Premises and running cost calculations have considered whether the costs are fixed or whether they will vary either with an increase in number of children (e.g. educational supplies), increases in floor area (e.g. cleaning) or an increase in opening hours (e.g. utilities)."]
[]
[]
[]
["Please use this space below to add further information and clarification which can help us to interpret the financial information that you have provided"]

{"sheet":"4. Input table","index":3,"n_rows":52,"n_cols":29,"rows_kept":52,"cut":false,"hidden":false,"merged":[[39,2,39,7],[39,9,39,14],[39,23,39,28],[28,2,28,7],[28,9,28,14],[28,23,28,28],[21,16,21,21],[5,2,5,7],[21,23,21,28],[21,9,21,14],[21,2,21,7],[9,2,9,7],[9,9,9,14],[9,23,9,28],[9,16,9,21]]}
["ELC Expansion Plan - Finance Template"]
["Input sheet "]
[{"$f":"'1. Introduction'!B4","v":"City of Edinburgh Council"}]
[null,null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22"]
[]
["Lunches",null,"All"]
["Uptake",null,0,190000,427500,950000,2067770,1870451.2]
["Unit cost (£)",null,3,3,3,3,3,3,null,null,null,null,null,null,null,null,null," "]
[]
["Uptake",null,"2 year olds",null,null,null,null,null,null,"3 year olds",null,null,null,null,null,null,"4 year olds",null,null,null,null,null,null,"5 year olds (deferrals)"]
["Total population",null,5424,5311,5247,5352,5416,5492,null,5510,5469,5316,5256,5358,5416,null,5593,5555,5474,5325,5263,5358,null,5486,5593,5510,5424,5266,5197]
["Estimated eligible cohort (% of population)",null,0.21,0.21,0.21,0.21,0.21,0.21,null,1,1,1,1,1,1,null,1,1,1,1,1,1,null,0.17,0.17,0.17,0.17,0.17,0.17]
["Estimated uptake - registrations (% of the eligible population)",null,0.38,0.42,0.5,0.75,1,1,null,0.78,0.78,0.78,0.78,0.78,0.78,null,1,1,1,1,1,1,null,0.5,0.5,0.5,0.5,0.5,0.5]
["Estimated cross boundary - Gross in",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,262,262,262,262,262,262]
["Estimated cross boundary - Gross out"]
["Estimated net cross boundary",null,{"$f":"C14-C15","v":0},{"$f":"D14-D15","v":0},0,0,0,0,null,{"$f":"J14-J15","v":0},{"$f":"K14-K15","v":0},{"$f":"L14-L15","v":0},{"$f":"M14-M15","v":0},{"$f":"N14-N15","v":0},{"$f":"O14-O15","v":0},null,{"$f":"Q14-Q15","v":262},{"$f":"R14-R15","v":262},{"$f":"S14-S15","v":262},{"$f":"T14-T15","v":262},{"$f":"U14-U15","v":262},{"$f":"V14-V15","v":262},null,{"$f":"X14-X15","v":0},{"$f":"Y14-Y15","v":0},{"$f":"Z14-Z15","v":0},{"$f":"AA14-AA15","v":0},{"$f":"AB14-AB15","v":0},{"$f":"AC14-AC15","v":0}]
["Uptake (number of children)",null,{"$f":"(C11*C12*C13)+C16","v":432.83519999999999},{"$f":"(D11*D12*D13)+D16","v":468.43019999999996},550.93499999999995,842.93999999999983,1137.3599999999999,1153.32,null,{"$f":"(J11*J12*J13)+J16","v":4297.8},{"$f":"(K11*K12*K13)+K16","v":4265.82},4146.4800000000005,4099.68,4179.24,{"$f":"(O11*O12*O13)+O16","v":4224.4800000000005},null,{"$f":"(Q11*Q12*Q13)+Q16","v":5855},{"$f":"(R11*R12*R13)+R16","v":5817},{"$f":"(S11*S12*S13)+S16","v":5736},{"$f":"(T11*T12*T13)+T16","v":5587},{"$f":"(U11*U12*U13)+U16","v":5525},{"$f":"(V11*V12*V13)+V16","v":5620},null,{"$f":"(X11*X12*X13)+X16","v":466.31000000000006},{"$f":"(Y11*Y12*Y13)+Y16","v":475.40500000000003},468.35,461.04,447.61,{"$f":"(AC11*AC12*AC13)+AC16","v":441.745}]
["Estimated uptake of hours (%)",null,1,1,1,1,1,1,null,1,1,1,1,1,1,null,1,1,1,1,1,1,null,1,1,1,1,1,1]
["Statutory provision (hours)",null,600,600,600,600,970,1140,null,{"$f":"Q19*0.75","v":450},{"$f":"R19*0.75","v":450},450,{"$f":"T19*0.75","v":450},727.5,855,null,600,600,600,600,970,1140,null,600,600,600,600,970,1140]
["Total statutory hours",null,{"$f":"C17*(C19*C18)","v":259701.12},{"$f":"D17*(D19*D18)","v":281058.12},330560.99999999994,505763.99999999988,1103239.2,1314784.7999999998,null,{"$f":"J17*J19*J18","v":1934010},{"$f":"K17*K19*K18","v":1919618.9999999998},1865916.0000000002,1844856.0000000002,3040397.0999999996,3611930.4000000004,null,{"$f":"Q17*Q19*Q18","v":3513000},{"$f":"R17*R19*R18","v":3490200},3441600,3352200,5359250,6406800,null,{"$f":"X17*X19*X18","v":279786.00000000006},{"$f":"Y17*Y19*Y18","v":285243},{"$f":"Z17*Z19*Z18","v":281010},{"$f":"AA17*AA19*AA18","v":276624},{"$f":"AB17*AB19*AB18","v":434181.7},{"$f":"AC17*AC19*AC18","v":503589.3}]
[]
["Phasing - Non-statutory hours",null,"2 year olds",null,null,null,null,null,null,"3 year olds",null,null,null,null,null,null,"4 year olds",null,null,null,null,null,null,"5 year olds (deferrals)"]
["Estimated number of children receiving funded non-statutory phased hours pre-2020",null,0,130,360,632,1137,null,null,0,500,1125,2500,5358,null,null,0,500,1125,2500,5525,null,null,439,447,441,434,421]
["Funded Non-statutory phased hours per child pre-2020 (hours)",null,null,600,600,600,970,null,null,0,405,405,405,127.5," ",null,540,540,540,540,170,null,null,540,540,540,540,170]
["Total funded non-statutory phased hours",null,{"$f":"C23*C24","v":0},{"$f":"D23*D24","v":78000},216000,379200,{"$f":"G23*G24","v":1102890},null,null,{"$f":"J23*J24","v":0},{"$f":"K23*K24","v":202500},{"$f":"L23*L24","v":455625},{"$f":"M23*M24","v":1012500},683145,null,null,{"$f":"Q23*Q24","v":0},{"$f":"R23*R24","v":270000},607500,1350000,939250,null,null,{"$f":"X23*X24","v":237060},{"$f":"Y23*Y24","v":241380},{"$f":"Z23*Z24","v":238140},{"$f":"AA23*AA24","v":234360},71570]
[]
["Total hours",null,{"$f":"C20+C25","v":259701.12},{"$f":"D20+D25","v":359058.12},546561,884963.99999999988,{"$f":"G20+G25","v":2206129.2000000002},{"$f":"H20","v":1314784.7999999998},null,{"$f":"J20+J25","v":1934010},{"$f":"K20+K25","v":2122119},2321541,2857356,3723542.0999999996,{"$f":"O20","v":3611930.4000000004},null,{"$f":"Q20+Q25","v":3513000},{"$f":"R20+R25","v":3760200},{"$f":"S20+S25","v":4049100},4702200,6298500,{"$f":"V20","v":6406800},null,{"$f":"X20+X25","v":516846.00000000006},{"$f":"Y20+Y25","v":526623},519150,510984,505751.7,{"$f":"AC20","v":503589.3}]
[]
["Provision by type",null,"2 year olds",null,null,null,null,null,null,"3&4 year olds",null,null,null,null,null,null,null,null,null,null,null,null,null,"5 year olds (deferrals)"]
["Local authority provision (% of hours)",null,0.8,0.8,0.8,0.8,0.8,0.8,null,0.65,0.64,0.64,0.64,0.64,0.64,null,null,null,null,null,null,null,null,0.6,0.6,0.6,0.6,0.6,0.6]
["Partner nursery provision (% of hours)",null,0.2,0.19,0.19,0.19,0.19,0.19,null,0.35,0.35,0.35,0.35,0.35,0.35,null,null,null,null,null,null,null,null,0.4,0.39,0.39,0.39,0.39,0.39]
["Childminder provision (% of hours)",null,0,0.01,0.01,0.01,0.01,0.01,null,0,0.01,0.01,0.01,0.01,0.01,null,null,null,null,null,null,null,null,0,0.01,0.01,0.01,0.01,0.01]
["Total",null,{"$f":"SUM(C30:C32)","v":1},1,1,1,1,1,null,{"$f":"SUM(J30:J32)","v":1},1,1,1,1,1,null,null,null,null,null,null,null,null,{"$f":"SUM(X30:X32)","v":1},1,1,1,1,1]
[]
["Hours Delivered in Settings"]
["Local authority provision (hours)",null,{"$f":"C30*C$27","v":207760.89600000001},287246.49599999998,437248.80000000005,707971.2,1764903.3600000003,{"$f":"H30*H$27","v":1051827.8399999999},null,{"$f":"J30*(J$27+Q$27)","v":3540556.5},3764684.16,4077210.24,4838115.84,6414106.9440000001,6411987.4560000002,null,null,null,null,null,null,null,null,{"$f":"X30*$X$27","v":310107.60000000003},{"$f":"Y30*Y$27","v":315973.8},311490,306590.39999999997,303451.02,302153.57999999996]
["Partner nursery provision (hours)",null,51940.224000000002,68221.042799999996,103846.59,168143.15999999997,419164.54800000007,249809.11199999996,null,1906453.4999999998,2058811.65,2229724.3499999996,2645844.5999999996,3507714.7349999999,3506555.64,null,null,null,null,null,null,null,null,{"$f":"X31*$X$27","v":206738.40000000002},205382.97,202468.5,199283.76,197243.163,196399.82699999999]
["Childminder provision (hours)",null,0,3590.5812000000001,5465.61,8849.64,22061.292000000001,13147.847999999998,null,{"$f":"J32*(J$27+Q$27)","v":0},{"$f":"K32*(K$27+R$27)","v":58823.19},{"$f":"L32*(L$27+S$27)","v":63706.41},{"$f":"M32*(M$27+T$27)","v":75595.56},{"$f":"N32*(N$27+U$27)","v":100220.421},{"$f":"O32*(O$27+V$27)","v":100187.304},null,null,null,null,null,null,null,null,{"$f":"X32*$X$27","v":0},5266.2300000000005,5191.5,5109.84,5057.5169999999998,5035.893]
[]
["Funded (partner) provision - hourly rate",null,"2 year olds",null,null,null,null,null,null,"3&4 year olds",null,null,null,null,null,null,null,null,null,null,null,null,null,"5 year olds (deferrals)"]
["Nurseries",null,3.6,3.67,3.77,4.13,4.97,5.31,null,3.6,3.67,3.77,4.13,4.97,5.31,null,null,null,null,null,null,null,null,3.6,3.67,3.77,4.13,4.97,5.31]
["Childminders",null,0,4.7,4.7,5.1100000000000003,5.31,5.31,null,0,4.7,4.7,5.1100000000000003,5.31,5.31,null,null,null,null,null,null,null,null,0,4.7,4.7,5.1100000000000003,5.31,5.31]
[]
[]
["Additional Support Needs (ASN)"]
[null,null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22"]
["Estimated proportion of eligible 2 year olds with ASN (%)",null,0.18,0.18,0.18,0.18,0.18,0.18]
["Estimated number of 2 year olds in local authority settings with ASN",null,{"$f":"C47*'4. Input table'!C17","v":77.910336000000001},{"$f":"D47*'4. Input table'!D17","v":84.317435999999987},{"$f":"E47*'4. Input table'!E17","v":99.168299999999988},{"$f":"F47*'4. Input table'!F17","v":151.72919999999996},{"$f":"G47*'4. Input table'!G17","v":204.72479999999999},{"$f":"H47*'4. Input table'!H17","v":207.59759999999997}]
["Estimated proportion of 3&4 year olds with ASN (%)",null,0.18,0.18,0.18,0.18,0.18,0.18]
["Estimated number of 3&4 year olds in local authority settings with ASN",null,{"$f":"C49*(J17+Q17)","v":1827.5039999999999},1814.9075999999998,1778.8463999999999,1743.6024,1746.7631999999999,1772.0063999999998]
["Estimated proportion of 5 year olds (deferrals) with ASN (%)",null,0.18,0.18,0.18,0.18,0.18,0.18]
["Estimated number of 5 year olds (deferrals) in local authority settings with ASN",null,{"$f":"X17*C51","v":83.935800000000015},85.572900000000004,84.302999999999997,82.987200000000001,80.569800000000001,79.514099999999999]

{"sheet":"5. Staffing costs profile","index":4,"n_rows":61,"n_cols":28,"rows_kept":61,"cut":false,"hidden":false,"merged":[[3,8,3,13],[3,22,3,27],[3,15,3,20],[3,4,3,6]]}
["ELC Expansion Plan - Finance Template",null,null,null,"Practitioner ","Manager","Specialist","Aux","Ratio"]
["Staffing costs profile",null,null,null,null,null,null,null,"Non-Ratio"]
[{"$f":"'1. Introduction'!B4","v":"City of Edinburgh Council"}]
[null,null,null,null,"Defining FTE",null,null,null,"Number of FTE",null,null,null,null,null,null,"Unit cost per FTE",null,null,null,null,null,null,"Costs (£m)"]
[null,null,"Staff Type",null,"Number of Weeks per Year","Number of Hours per Week","Total Hours Per Year",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22"]
["Staff in post - LA settings"]
["Managers (settings)",null,"Non-Ratio","m",52,36,{"$f":"E7*F7","v":1872},null,14.3,15.625,15.6875,15.5,13.625,12.5,null,51760,51760,51760,51760,51760,51760,null,{"$f":"I7*P7/1000000","v":0.74016800000000005},{"$f":"J7*Q7/1000000","v":0.80874999999999997},{"$f":"K7*R7/1000000","v":0.81198499999999996},0.80227999999999999,0.70523000000000002,0.64700000000000002]
["Teachers",null,"Ratio","s",39,35,{"$f":"E8*F8","v":1365},null,77.5,81.75,88.174999999999997,93.9375,103.5,108,null,43148,43148,43148,43148,43148,43148,null,{"$f":"I8*P8/1000000","v":3.3439700000000001},3.5273490000000001,3.8045749,4.05321525,4.4658179999999996,4.6599839999999997]
["Senior practitioners / graduates",null,"Ratio","p",52,36,1872,null,17.899999999999999,21.519705825986968,23.538137217324646,24.575364124185512,36.512864124185512,43.450364124185512,null,42602,42602,42602,42602,42602,42602,null,0.76257579999999991,0.91678250759869684,1.0027717217324645,1.0469596624185511,1.5555210374185513,1.8510724124185514]
["Additional graduates",null,"Non-Ratio","s",52,36,1872,null,0,0,20,20,20,20,null,34436,34436,34436,34436,34436,34436,null,0,0,0.68872,0.68872,0.68872,0.68872]
["Practitioners",null,"Ratio","p",52,36,1872,null,299.8,338.56187592504114,375.16262491300182,394.13526289690373,504.05250635751582,566.87773093139162,null,27963,27963,27963,27963,27963,27963,null,8.3833073999999996,9.4672057364919269,10.490672480442271,11.02120435638612,14.094820235275215,15.851601990034505]
["Apprentices",null,"Non-Ratio","p",52,36,1872,null,12.159831353008816,13.934936757378306,42.725601284016868,60,60,60,null,19960,19960,19960,19960,19960,19960,null,0.24271023380605597,{"$f":"J12*Q12/1000000","v":0.27814133767727101},0.85280300162897671,1.1976,1.1976,{"$f":"N12*U12/1000000","v":1.1976}]
["C2 care workers / support staff (SSSC registered)",null,"Non-Ratio","p",52,36,1872,null,27.6,69.103614556041535,119.31805912226906,145.18048533921043,239.19781285933314,292.59697201993106,null,19493,19493,19493,19493,19493,19493,null,0.53800680000000001,1.3470367585409178,2.3258669264703911,2.8300032007172291,4.6626829660669804,5.7035927755845162]
["Admin / auxiliary staff (non-SSSC registered)",null,"Non-Ratio","a",52,36,1872,null,42.541013698630138,42.541013698630138,45.9,49,71.2,71.900000000000006,null,23528.89,23528.89,23528.89,23528.89,23528.89,23528.89,null,1.0009428318035616,1.0009428318035616,1.079976051,1.15291561,1.675256968,1.691727191]
["Others (please specify)"]
["Nursery School Head Teachers",null,"Non-Ratio",null,39,35,{"$f":"E16*F16","v":1365},null,7,7,7,7,7,7,null,75152,75152,75152,75152,75152,75152,null,{"$f":"I16*P16/1000000","v":0.52606399999999998},{"$f":"J16*Q16/1000000","v":0.52606399999999998},{"$f":"K16*R16/1000000","v":0.52606399999999998},{"$f":"L16*S16/1000000","v":0.52606399999999998},{"$f":"M16*T16/1000000","v":0.52606399999999998},{"$f":"N16*U16/1000000","v":0.52606399999999998}]
["Early Years Officers",null,"Ratio",null,52,36,{"$f":"E17*F17","v":1872},null,136,140.08891241855122,142.83223840551938,147.98533346109625,175.90021703717906,191.11881947106178,null,34436,34436,34436,34436,34436,34436,null,{"$f":"I17*P17/1000000","v":4.6832960000000003},{"$f":"J17*Q17/1000000","v":4.8241017880452297},{"$f":"K17*R17/1000000","v":4.9185709617324651},{"$f":"L17*S17/1000000","v":5.09602294306631},{"$f":"M17*T17/1000000","v":6.0572998738922976},{"$f":"N17*U17/1000000","v":6.5813676673054831}]
["Principal Teachers",null,"Ratio",null,39,35,1365,null,3,3,2.375,1.375,0.375,0,null,45405,45405,45405,45405,45405,45405,null,0.136215,0.136215,0.107836875,6.2431874999999998E-2,1.7026875E-2,0]
["Catering Assistants",null,"Non-Ratio",null,52,36,{"$f":"E19*F19","v":1872},null,0,4.8999760444614777,12.976378880797242,17.900544269835194,37.829596588731356,49.123794557301707,null,17941,17941,17941,17941,17941,17941,null,0,8.7910470213683367E-2,0.23280921350038331,0.32115366474511325,0.67870079239842929,0.88132999815254998]
["Trainee Early Years Practitioners",null,"Non-Ratio",null,52,36,1872,null,12.159831353008816,13.934936757378306,23.962499999999999,30,30,30,null,19960,19960,19960,19960,19960,19960,null,{"$f":"I20*P20/1000000","v":0.24271023380605597},{"$f":"J20*Q20/1000000","v":0.27814133767727101},{"$f":"K20*R20/1000000","v":0.47829149999999998},{"$f":"L20*S20/1000000","v":0.5988},{"$f":"M20*T20/1000000","v":0.5988},{"$f":"N20*U20/1000000","v":0.5988}]
["Senior practitioners / graduates",null,"Non-Ratio",null,52,36,1872,null,17.899999999999999,21.519705825986968,23.538137217324646,24.575364124185512,36.512864124185512,43.450364124185512,null,42602,42602,42602,42602,42602,42602,null,0.76257579999999991,0.91678250759869684,1.0027717217324645,1.0469596624185511,1.5555210374185513,1.8510724124185514]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"J28*Q28/1000000","v":0},{"$f":"K28*R28/1000000","v":0},{"$f":"L28*S28/1000000","v":0},{"$f":"M28*T28/1000000","v":0},{"$f":"N28*U28/1000000","v":0}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I29*P29/1000000","v":0},0,0,0,0,{"$f":"N29*U29/1000000","v":0}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
["Sub total",null,null,null,null,null,null,null,{"$f":"SUM(I7:I14,I16:I33)","v":667.86067640464785},{"$f":"SUM(J7:J14,J16:J33)","v":773.47967780945601},943.19117704025359,{"$f":"SUM(L7:L14,L16:L33)","v":1031.1648542154167},1335.7058610911304,1496.018045228057,null,{"$f":"SUM(P7:P14,P16:P33)","v":498386.89},{"$f":"SUM(Q7:Q14,Q16:Q33)","v":498386.89},{"$f":"SUM(R7:R14,R16:R33)","v":498386.89},{"$f":"SUM(S7:S14,S16:S33)","v":498386.89},{"$f":"SUM(T7:T14,T16:T33)","v":498386.89},{"$f":"SUM(U7:U14,U16:U33)","v":498386.89},null,{"$f":"SUM(W7:W33)","v":21.362542099415673},24.11542327564726,28.323714353239421,30.44433022475188,38.47906178547003,42.729932446914155]
[]
[]
["Staff in post - Central costs"]
["Managers (central)",null,null,null,null,null,null,null,null,null,0.625,1,1,1,null,51760,51760,51760,51760,51760,51760,null,{"$f":"I38*P38/1000000","v":0},{"$f":"J38*Q38/1000000","v":0},{"$f":"K38*R38/1000000","v":3.2349999999999997E-2},{"$f":"L38*S38/1000000","v":5.176E-2},{"$f":"M38*T38/1000000","v":5.176E-2},{"$f":"N38*U38/1000000","v":5.176E-2}]
["Quality assurance - teachers",null,null,null,null,null,null,null,4,4,4,4,4,4,null,72065,72065,72065,72065,72065,72065,null,{"$f":"I39*P39/1000000","v":0.28826000000000002},0.28826000000000002,0.28826000000000002,0.28826000000000002,0.28826000000000002,0.28826000000000002]
["Quality assurance - other",null,null,null,null,null,null,null,1,1,1,1,1,1,null,76222,76222,76222,76222,76222,76222,null,7.6221999999999998E-2,7.6221999999999998E-2,7.6221999999999998E-2,7.6221999999999998E-2,7.6221999999999998E-2,7.6221999999999998E-2]
["Improvement support - teachers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I41*P41/1000000","v":0},{"$f":"J41*Q41/1000000","v":0},0,0,0,0]
["Improvement support - others",null,null,null,null,null,null,null,6.94,6.94,10.102499999999999,12,12,12,null,44009,44009,44009,44009,44009,44009,null,{"$f":"I42*P42/1000000","v":0.30542246000000001},0.30542246000000001,{"$f":"K42*R42/1000000","v":0.4446009225},0.52810800000000002,0.52810800000000002,{"$f":"N42*U42/1000000","v":0.52810800000000002}]
["Early Years Management Team",null,null,null,null,null,null,null,2,2,2,2,2,2,null,76222,76222,76222,76222,76222,76222,null,{"$f":"I43*P43/1000000","v":0.152444},0.152444,0.152444,0.152444,0.152444,0.152444]
["Central Admin",null,null,null,null,null,null,null,0.9,0.9,2.15,2.9,2.9,2.9,null,28649,28649,28649,28649,28649,28649,null,2.5784100000000001E-2,2.5784100000000001E-2,6.159535E-2,8.3082099999999992E-2,8.3082099999999992E-2,8.3082099999999992E-2]
["Others (please specify)"]
["Project Admin Officer",null,null,null,null,null,null,null,null,null,2,2,2,2,null,34436,34436,34436,34436,34436,34436,null,{"$f":"I46*P46/1000000","v":0},{"$f":"J46*Q46/1000000","v":0},{"$f":"K46*R46/1000000","v":6.8872000000000003E-2},{"$f":"L46*S46/1000000","v":6.8872000000000003E-2},{"$f":"M46*T46/1000000","v":6.8872000000000003E-2},{"$f":"N46*U46/1000000","v":6.8872000000000003E-2}]
["Early Years Practitioner (Peripatetic)",null,null,null,null,null,null,null,null,null,4,8,8,8,null,27963,27963,27963,27963,27963,27963,null,0,0,0.11185199999999999,0.22370399999999999,0.22370399999999999,0.22370399999999999]
["Peripatetic Teachers",null,null,null,null,null,null,null,3.1,3.1,6,6,6,6,null,43148,43148,43148,43148,43148,43148,null,0.13375880000000001,0.13375880000000001,0.25888800000000001,0.25888800000000001,0.25888800000000001,0.25888800000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
["Sub total",null,null,null,null,null,null,null,{"$f":"SUM(I38:I44,I46:I52)","v":17.940000000000001},{"$f":"SUM(J38:J44,J46:J52)","v":17.940000000000001},31.877499999999998,38.9,38.9,38.9,null,{"$f":"SUM(P38:P44,P46:P52)","v":454474},{"$f":"SUM(Q38:Q44,Q46:Q52)","v":454474},{"$f":"SUM(R38:R44,R46:R52)","v":454474},{"$f":"SUM(S38:S44,S46:S52)","v":454474},{"$f":"SUM(T38:T44,T46:T52)","v":454474},{"$f":"SUM(U38:U44,U46:U52)","v":454474},null,{"$f":"SUM(W38:W52)","v":0.9818913600000001},{"$f":"SUM(X38:X52)","v":0.9818913600000001},1.4950842725000002,1.7313400999999999,1.7313400999999999,1.7313400999999999]
[]
["Other staff costs"]
["Training and professional development",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.7682199999999993E-2,9.4817979411764702E-2,0.16700000000000001,0.26181797941176471,0.26181797941176471,0.26181797941176471]
["Absence Cover",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.21915998000000006,0.23582913455020668,0.28336497250744913,0.33859122033732397,0.44836313195802496,0.49764023059182177]
[]
["Sub total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W56:W58)","v":0.29684218000000007},{"$f":"SUM(X56:X58)","v":0.33064711396197138},0.45036497250744911,0.60040919974908868,0.71018111136978967,0.75945821000358649]
[]
["TOTAL STAFF COSTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W34+W59+W53","v":22.641275639415671},{"$f":"X34+X59+X53","v":25.427961749609231},30.26916359824687,32.776079524500965,40.920582996839819,45.220730756917739]

{"sheet":"6. Revenue costs profile","index":5,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[4,2,4,7],[4,9,4,14],[7,2,7,7],[13,2,13,7]]}
["ELC Expansion Plan - Finance Template"]
["Revenue costs profile"]
[{"$f":"'1. Introduction'!B4","v":"City of Edinburgh Council"}]
[]
[null,null,null,null,null,null,null,null,null,"Costs (£m)"]
[null,null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22"]
[]
["Local authority staff costs",null,"FTEs"]
[{"$f":"'5. Staffing costs profile'!A6","v":"Staff in post - LA settings"},null,{"$f":"'5. Staffing costs profile'!I34","v":667.86067640464785},{"$f":"'5. Staffing costs profile'!J34","v":773.47967780945601},{"$f":"'5. Staffing costs profile'!K34","v":943.19117704025359},{"$f":"'5. Staffing costs profile'!L34","v":1031.1648542154167},{"$f":"'5. Staffing costs profile'!M34","v":1335.7058610911304},{"$f":"'5. Staffing costs profile'!N34","v":1496.018045228057},null,{"$f":"'5. Staffing costs profile'!W34","v":21.362542099415673},{"$f":"'5. Staffing costs profile'!X34","v":24.11542327564726},{"$f":"'5. Staffing costs profile'!Y34","v":28.323714353239421},{"$f":"'5. Staffing costs profile'!Z34","v":30.44433022475188},{"$f":"'5. Staffing costs profile'!AA34","v":38.47906178547003},{"$f":"'5. Staffing costs profile'!AB34","v":42.729932446914155}]
[{"$f":"'5. Staffing costs profile'!A37","v":"Staff in post - Central costs"},null,{"$f":"'5. Staffing costs profile'!I53","v":17.940000000000001},{"$f":"'5. Staffing costs profile'!J53","v":17.940000000000001},{"$f":"'5. Staffing costs profile'!K53","v":31.877499999999998},{"$f":"'5. Staffing costs profile'!L53","v":38.9},{"$f":"'5. Staffing costs profile'!M53","v":38.9},{"$f":"'5. Staffing costs profile'!N53","v":38.9},null,{"$f":"'5. Staffing costs profile'!W53","v":0.9818913600000001},{"$f":"'5. Staffing costs profile'!X53","v":0.9818913600000001},{"$f":"'5. Staffing costs profile'!Y53","v":1.4950842725000002},{"$f":"'5. Staffing costs profile'!Z53","v":1.7313400999999999},{"$f":"'5. Staffing costs profile'!AA53","v":1.7313400999999999},{"$f":"'5. Staffing costs profile'!AB53","v":1.7313400999999999}]
["Other staff costs",null,null,null,null,null,null,null,null,{"$f":"'5. Staffing costs profile'!W59","v":0.29684218000000007},{"$f":"'5. Staffing costs profile'!X59","v":0.33064711396197138},{"$f":"'5. Staffing costs profile'!Y59","v":0.45036497250744911},{"$f":"'5. Staffing costs profile'!Z59","v":0.60040919974908868},{"$f":"'5. Staffing costs profile'!AA59","v":0.71018111136978967},{"$f":"'5. Staffing costs profile'!AB59","v":0.75945821000358649}]
["Sub total",null,{"$f":"SUM(C9:C10)","v":685.8006764046479},{"$f":"SUM(D9:D10)","v":791.41967780945606},975.06867704025353,1070.0648542154167,1374.6058610911305,1534.9180452280571,null,{"$f":"SUM(J9:J11)","v":22.641275639415671},{"$f":"SUM(K9:K11)","v":25.427961749609231},30.26916359824687,32.776079524500965,40.920582996839819,{"$f":"SUM(O9:O11)","v":45.220730756917739}]
[]
["Funded (partner) provision",null,"Hours"]
["Nurseries",null,{"$f":"'4. Input table'!C37+'4. Input table'!J37+'4. Input table'!X37","v":2165132.1239999998},{"$f":"'4. Input table'!D37+'4. Input table'!K37+'4. Input table'!Y37","v":2332415.6628},{"$f":"'4. Input table'!E37+'4. Input table'!L37+'4. Input table'!Z37","v":2536039.4399999995},{"$f":"'4. Input table'!F37+'4. Input table'!M37+'4. Input table'!AA37","v":3013271.5199999996},{"$f":"'4. Input table'!G37+'4. Input table'!N37+'4. Input table'!AB37","v":4124122.446},{"$f":"'4. Input table'!H37+'4. Input table'!O37+'4. Input table'!AC37","v":3952764.5790000004},null,{"$f":"(('4. Input table'!C41*'4. Input table'!C37)+('4. Input table'!J41*'4. Input table'!J37)+('4. Input table'!X41*'4. Input table'!X37))/1000000","v":7.7944756463999996},{"$f":"(('4. Input table'!D41*'4. Input table'!D37)+('4. Input table'!K41*'4. Input table'!K37)+('4. Input table'!Y41*'4. Input table'!Y37))/1000000","v":8.5599654824760005},{"$f":"(('4. Input table'!E41*'4. Input table'!E37)+('4. Input table'!L41*'4. Input table'!L37)+('4. Input table'!Z41*'4. Input table'!Z37))/1000000","v":9.5608686887999976},{"$f":"(('4. Input table'!F41*'4. Input table'!F37)+('4. Input table'!M41*'4. Input table'!M37)+('4. Input table'!AA41*'4. Input table'!AA37))/1000000","v":12.444811377599999},{"$f":"(('4. Input table'!G41*'4. Input table'!G37)+('4. Input table'!N41*'4. Input table'!N37)+('4. Input table'!AB41*'4. Input table'!AB37))/1000000","v":20.496888556619997},{"$f":"(('4. Input table'!H41*'4. Input table'!H37)+('4. Input table'!O41*'4. Input table'!O37)+('4. Input table'!AC41*'4. Input table'!AC37))/1000000","v":20.989179914489998}]
["Childminders",null,{"$f":"'4. Input table'!C38+'4. Input table'!J38+'4. Input table'!X38","v":0},{"$f":"'4. Input table'!D38+'4. Input table'!K38+'4. Input table'!Y38","v":67680.001199999999},{"$f":"'4. Input table'!E38+'4. Input table'!L38+'4. Input table'!Z38","v":74363.520000000004},{"$f":"'4. Input table'!F38+'4. Input table'!M38+'4. Input table'!AA38","v":89555.04},{"$f":"'4. Input table'!G38+'4. Input table'!N38+'4. Input table'!AB38","v":127339.23000000001},{"$f":"'4. Input table'!H38+'4. Input table'!O38+'4. Input table'!AC38","v":118371.045},null,{"$f":"(('4. Input table'!C42*'4. Input table'!C38)+('4. Input table'!J42*'4. Input table'!J38)+('4. Input table'!X42*'4. Input table'!X38))/1000000","v":0},{"$f":"(('4. Input table'!D42*'4. Input table'!D38)+('4. Input table'!K42*'4. Input table'!K38)+('4. Input table'!Y42*'4. Input table'!Y38))/1000000","v":0.31809600564000007},{"$f":"(('4. Input table'!E42*'4. Input table'!E38)+('4. Input table'!L42*'4. Input table'!L38)+('4. Input table'!Z42*'4. Input table'!Z38))/1000000","v":0.34950854400000003},{"$f":"(('4. Input table'!F42*'4. Input table'!F38)+('4. Input table'!M42*'4. Input table'!M38)+('4. Input table'!AA42*'4. Input table'!AA38))/1000000","v":0.45762625440000004},{"$f":"(('4. Input table'!G42*'4. Input table'!G38)+('4. Input table'!N42*'4. Input table'!N38)+('4. Input table'!AB42*'4. Input table'!AB38))/1000000","v":0.67617131129999997},{"$f":"(('4. Input table'!H42*'4. Input table'!H38)+('4. Input table'!O42*'4. Input table'!O38)+('4. Input table'!AC42*'4. Input table'!AC38))/1000000","v":0.62855024895}]
["Sub total",null,{"$f":"SUM(C15:C16)","v":2165132.1239999998},{"$f":"SUM(D15:D16)","v":2400095.6639999999},2610402.9599999995,3102826.5599999996,4251461.676,4071135.6240000003,null,{"$f":"SUM(J15:J16)","v":7.7944756463999996},{"$f":"SUM(K15:K16)","v":8.8780614881159998},9.9103772327999984,12.902437631999998,21.173059867919996,21.617730163439997]
[]
["Lunches"]
["Cost of provision",null,null,null,null,null,null,null,null,{"$f":"'4. Input table'!C7*'4. Input table'!C8/1000000","v":0},{"$f":"'4. Input table'!D7*'4. Input table'!D8/1000000","v":0.56999999999999995},{"$f":"'4. Input table'!E7*'4. Input table'!E8/1000000","v":1.2825},{"$f":"'4. Input table'!F7*'4. Input table'!F8/1000000","v":2.85},{"$f":"'4. Input table'!G7*'4. Input table'!G8/1000000","v":6.2033100000000001},{"$f":"'4. Input table'!H7*'4. Input table'!H8/1000000","v":5.6113535999999993}]
[]
["Running costs"]
["Educational resources and supplies",null,null,null,null,null,null,null,null,0.54362484999999983,0.58579007223478774,0.70422709640680059,0.85107036290660909,1.119149758284544,1.2372320769127505]
["Administrative resources and supplies",null,null,null,null,null,null,null,null,2.0495509999999998E-2,2.2085205051588088E-2,2.6550466735795003E-2,3.2086688336002374E-2,4.2193702260701398E-2,4.6645590989238352E-2]
["Buildings - rent and rates",null,null,null,null,null,null,null,null,0,0,4.7300000000000002E-2,0.1459,0.27360000000000001,0.32500000000000001]
["Buildings - energy / utilities costs",null,null,null,null,null,null,null,null,0,0,4.5999999999999999E-3,4.1200000000000001E-2,0.1231,0.16]
["Buildings - maintenance and lifecycle replacement",null,null,null,null,null,null,null,null,0,0,6.3E-2,0.19450000000000001,0.36480000000000001,0.43330000000000002]
["Buildings - facilities management",null,null,null,null,null,null,null,null,"Refer to separate breakdown in rows 36-38 under 'Others'"]
["Buildings - other"]
["Information systems"]
["Others (please specify)"]
["Central Support Transactional Costs",null,null,null,null,null,null,null,null,0,3.5148182144682023E-2,0.13538111752775084,0.25182986794549367,0.48329230549104463,0.58719682165144493]
["Central Support Employee Costs",null,null,null,null,null,null,null,null,0,0,0.14453854999999999,0.26044460000000003,0.45362134999999998,0.56952740000000002]
[]
[]
["Cleaning",null,null,null,null,null,null,null,null,0,0,4.5400000000000003E-2,0.16190000000000002,0.29530000000000001,0.34320000000000001]
["Security",null,null,null,null,null,null,null,null,0,0,4.7300000000000002E-2,0.13439999999999999,0.2712,0.33210000000000001]
["Janitorial Support",null,null,null,null,null,null,null,null,0,0,0,7.8E-2,0.2029,0.24979999999999999]
[]
[]
[]
[]
["Wraparound hours",null,null,null,null,null,null,null,null,-1.0458800000000001,-0.91960000000000008,-0.59840000000000004,-0.45100000000000007,-0.43208000000000008,-0.42020000000000007]
["Sub total",null,null,null,null,null,null,null,null,{"$f":"SUM(J23:J30,J32:J43)","v":-0.48175964000000027},{"$f":"SUM(K23:K30,K32:K43)","v":-0.27657654056894221},0.61989723067034652,1.7003315191881048,3.1970771160362901,{"$f":"SUM(O23:O30,O32:O43)","v":3.8638018895534336}]
[]
["TOTAL",null,null,null,null,null,null,null,null,{"$f":"SUM(J44,J20,J12,J17)","v":29.95399164581567},{"$f":"SUM(K44,K20,K12,K17)","v":34.599446697156289},42.08193806171721,50.228848675689065,71.494029980796114,{"$f":"SUM(O44,O20,O12,O17)","v":76.313616409911177}]

{"sheet":"7. Capital Costs Profile","index":6,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[6,1,6,6]]}
["ELC Expansion Plan - Finance Template"]
["Capital costs profile"]
["City of Edinburgh Council"]
[]
["Anticipated Total Capital Cost for All Projects (£m)",39.38663509859154]
[]
["Annual Profile","Costs (£m)"]
[null,"2017-18","2018-19","2019-20","2020-21","2021-22","Total"]
["Refurbishment projects",null,0.94895200000000002,0.72499999999999998,0,0,1.6739519999999999]
["Extension projects",null,0,10.044823943661971,13.759077464788732,0,23.803901408450702]
["New build projects",null,0,0,12.948781690140846,0,12.948781690140846]
["Outdoor spaces",null,0.15,0.2,null,null,0.35]
["Other",null,null,0.20333333333333334,0.20333333333333334,0.20333333333333334,0.61]
["Total",0,1.0989519999999999,11.173157276995303,26.911192488262913,0.20333333333333334,39.386635098591547,"OK"]

{"sheet":"8. Summary Demand and Supply","index":7,"n_rows":29,"n_cols":15,"rows_kept":29,"cut":false,"hidden":false,"merged":[[4,5,4,7],[4,2,4,4],[3,2,3,7],[3,9,3,14],[4,9,4,11],[4,12,4,14]]}
["ELC Expansion Plan - Finance Template"]
["Summary Demand and Supply Analysis"]
[]
[null,null,"At April 2017",null,null,null,null,null,null,"At April 2021"]
[null,null,"Local Authority Settings ",null,null,"Partner Settings",null,null,null,"Local Authority Settings ",null,null,"Partner Settings"]
["Locality Indicator","Locality","Total Physical Capacity","Number of Children Using the Facility","Children / Capacity Ratio","Total Physical Capacity","Number of Children Using the Facility","Children / Capacity Ratio",null,"Total Physical Capacity","Number of Children Using the Facility","Children / Capacity Ratio","Total Physical Capacity","Number of Children Using the Facility","Children / Capacity Ratio"]
["Example","abc",260,480,1.8461538461538463,200,100,0.5,null,300,420,1.4,200,160,0.8]
["Example","xyz",380,720,1.8947368421052631,100,80,0.8,null,500,820,1.64,100,80,0.8]
["A","Balerno",90,139,1.5444444444444445,36,17,0.47222222222222221,null,198,246,1.2424242424242424,36,17,0.47222222222222221]
["B","Boroughmuir",132,152,1.1515151515151516,591,488,0.82571912013536375,null,190,300,1.5789473684210527,591,488,0.82571912013536375]
["C","Broughton",215,396,1.8418604651162791,493,297,0.60243407707910746,null,366,552,1.5081967213114753,493,297,0.60243407707910746]
["D","Castlebrae",288,408,1.4166666666666667,0,0,0,null,302,445,1.4735099337748345,0,0,0]
["E","Craigmount",225,367,1.6311111111111112,450,304,0.67555555555555558,null,321,449,1.3987538940809969,450,304,0.67555555555555558]
["F","Craigroyston",180,344,1.9111111111111112,193,127,0.65803108808290156,null,349,427,1.2234957020057307,193,127,0.65803108808290156]
["G","Currie",110,215,1.9545454545454546,220,139,0.63181818181818183,null,202,252,1.2475247524752475,220,139,0.63181818181818183]
["H","Drummond",190,319,1.6789473684210525,329,270,0.82066869300911849,null,282,448,1.5886524822695036,329,270,0.82066869300911849]
["F","Firrhill",238,386,1.6218487394957983,332,219,0.65963855421686746,null,339,442,1.303834808259587,332,219,0.65963855421686746]
["I","Forrester",293,512,1.7474402730375427,48,30,0.625,null,398,508,1.2763819095477387,48,30,0.625]
["J","Gracemount",70,130,1.8571428571428572,86,36,0.41860465116279072,null,258,358,1.3875968992248062,86,36,0.41860465116279072]
["K","James Gillespies",322,404,1.2546583850931676,598,448,0.74916387959866215,null,388,470,1.2113402061855669,598,448,0.74916387959866215]
["L","Leith",270,496,1.837037037037037,114,82,0.7192982456140351,null,571,747,1.3082311733800349,114,82,0.7192982456140351]
["M","Liberton",315,563,1.7873015873015874,382,246,0.64397905759162299,null,446,620,1.3901345291479821,382,246,0.64397905759162299]
["N","Portobello",240,384,1.6,297,287,0.96632996632996637,null,412,467,1.133495145631068,297,287,0.96632996632996637]
["O","Queemsferry",200,394,1.97,244,161,0.6598360655737705,null,318,444,1.3962264150943395,244,161,0.6598360655737705]
["P","The Royal High",130,247,1.9,511,431,0.84344422700587085,null,197,237,1.2030456852791878,511,431,0.84344422700587085]
["Q","Trinity",170,281,1.6529411764705881,313,264,0.8434504792332268,null,253,363,1.4347826086956521,313,264,0.8434504792332268]
["R","Tynecastle",250,348,1.3919999999999999,284,181,0.63732394366197187,null,307,432,1.4071661237785016,284,181,0.63732394366197187]
["S","WHEC",168,265,1.5773809523809523,47,37,0.78723404255319152,null,316,428,1.3544303797468353,47,37,0.78723404255319152]
[null,"Totals ",4096,6750,1.64794921875,5568,4064,0.72988505747126442,null,6413,8635,1.3464837049742711,5568,4064,0.72988505747126442]

{"sheet":"9. Capital Projects ","index":8,"n_rows":163,"n_cols":27,"rows_kept":163,"cut":false,"hidden":false,"merged":[[7,18,7,25],[7,2,7,6],[58,7,58,15],[156,7,156,15],[7,7,7,17],[147,7,147,15],[148,7,148,15],[155,7,155,15],[154,7,154,15],[149,7,149,15],[150,7,150,15],[151,7,151,15],[57,7,57,15],[59,7,59,15],[60,7,60,15],[61,7,61,15],[62,7,62,15],[63,7,63,15],[64,7,64,15],[65,7,65,15],[66,7,66,15]]}
["ELC Expansion Plan - Finance Template"]
["Capital Projects"]
["City of Edinburgh Council"]
[]
[]
[]
[]
[null,null,"Prior to Works Commencing",null,null,null,null,"Outline of Proposed Works",null,null,null,null,null,null,null,null,null,null,"Post Works Completing"]
["Refurbishment Projects","Locality Indiactor (As Per Summary Demand and Supply Sheet)","Physical Capacity Prior to Works","Number of Children Using the Facility in April 2017","Children / Physical Capacity Ratio","Maximum Deliverable Hours Per Annum Per Child","Total Maximum Deliverable Hours Per Annum Per Setting","Description ","Total Area (Sqm)","Cost per square metre (£)","Base Date ","Base Date Indice","Expected Tender Date","Tender Date Indice","Location Adjustment (%)","Land Costs (£)","Total Cost (£)","Construction Period ","Physical Indoor Capacity Post Works","Proposed Registered Outdoor Capacity Post Works (with ref to Space to Grow)","Total Proposed Capacity","Increased Capacity","Forecast Number of Children Using the Facility in April 2021","Children / Capacity Ratio","Maximum Deliverable Hours Per Annum Per Child","Total Maximum Deliverable Hours Per Annum Per Setting"]
["Example A","A",40,70,1.75,1200.8,48032,"Minor refurbishment",58,1500,"2Q 2018",284,"4Q 2018",286,0,0,87612.676056338023,"6 months",48,0,48,8,48,1,1140,54720]
["Example B","B",40,65,1.625,2500,100000,"Major refurbishment",80,2100,"2Q 2018",284,"4Q 2018",286,0.15,0,194560.5633802817,"6 months ",68,12,80,40,120,1.5,2500,200000]
["Dean Park","Balerno",60,87,1.45,1200.8,72048,"Refurbishment",225,null,"2Q 2018",284,2018,284,0,0,215000,"4 months",88,0,88,28,88,1,1140,100320]
["Moffat EYC","Castlebrae",100,110,1.1000000000000001,1580,158000,"Refurbishment",128,null,"2Q 2018",284,2018,284,0,0,65352,"3 months",110,0,110,10,165,1.5,1710,188100]
["Forthview PS","Craigroyston",50,98,1.96,1200.8,60040,"Refurbishment",150,null,"2Q 2018",284,2018,290,0,0,94000,"4 months",64,0,64,14,64,1,1140,72960]
["Abbeyhill PS","Drummond",40,54,1.35,1200.8,48032,"Refurbishment",null,null,"2Q 2018",284,2018,290,0,0,44600,"2 months",48,0,48,8,48,1,1140,54720]
["Hope Cottage NS","James Gillespies",40,51,1.2749999999999999,1200.8,48032,"Refurbishment",168,null,"2Q 2018",284,2019,290,0,0,95000,"4 months",48,0,48,8,48,1,1140,54720]
["St Leonards NS","James Gillespies",40,54,1.35,1200.8,48032,"Refurbishment",160,null,"2Q 2018",284,2019,290,0,0,100000,"4 months",56,0,56,16,56,1,1140,63840]
["St Peters PS","James Gillespies",30,56,1.8666666666666667,1200.8,36024,"Refurbishment",100,null,"2Q 2018",284,2019,290,0,0,90000,"4 months",40,0,40,10,40,1,1140,45600]
["Stanwell NS","Leith",60,118,1.9666666666666666,1200.8,72048,"Refurbishment",314,null,"2Q 2018",284,2019,290,0,0,175000,"4 months",72,0,72,12,112,1.5555555555555556,1779,128088]
["Prestonfield PS","Liberton",30,40,1.3333333333333333,1200.8,36024,"Refurbishment",245,null,"2Q 2018",284,2018,284,0,0,150000,"4 months",48,0,48,18,48,1,1140,54720]
["Brunstane PS","Portobello",40,52,1.3,1200.8,48032,"Refurbishment",508,null,"2Q 2018",284,2018,284,0,0,325000,"4 months",96,0,96,56,96,1,1140,109440]
["Dalmeny PS","Queensferry",20,23,1.1499999999999999,1200.8,24016,"Refurbishment",82,null,"2Q 2018",284,2018,290,0,0,55000,"4 months",30,0,30,10,30,1,1140,34200]
["Canal View PS","WHEC",40,79,1.9750000000000001,1200.8,48032,"Refurbishment",225,null,"2Q 2018",284,2019,290,0,0,145000,"4 months",64,0,64,24,64,1,1140,72960]
["Clovenstone PS","WHEC",30,58,1.9333333333333333,1200.8,36024,"Refurbishment",215,null,"2Q 2018",284,2019,290,0,0,120000,"4 months",42,0,42,12,42,1,1140,47880]
[null,null,null,null,{"$error":"#DIV/0!"},null,0,null,null,null,"2Q 2018",284,null,null,0,null,0,null,null,null,0,0,null,{"$error":"#DIV/0!"},null,0]
[]
["Extension Projects"]
["Example C","A",40,75,1.875,1200.8,48032,"Extension",120,3300,"2Q 2018",284,"2Q 2018",287,0,0,400183.09859154932,"6 months",60,12,72,32,68,0.94444444444444442,1140,82080]
["Example D","D",40,80,2,2500,100000,"Extension",348,3300,"2Q 2018",284,"1Q 2019",287,0.15,0,1334610.6338028167,"6 months ",100,0,100,60,180,1.8,2500,250000]
["Ratho PS","Balerno",30,52,1.7333333333333334,1200.8,36024,"Replacement new build",424,3000,"2Q 2018",284,2020,302,0,0,1352619.7183098593,"8 months",73,7,80,50,128,1.6,1824,145920]
["Granton PS","Broughton",60,111,1.85,1200.8,72048,"Replacement new build",720,3000,"2Q 2018",284,2020,302,0,0,2296901.4084507041,"8 months",124,12,136,76,204,1.5,1710,232560]
["Broughton PS","Drummond",50,82,1.64,1200.8,60040,"Replacement new build",720,3000,"2Q 2018",284,2020,302,0,0,2296901.4084507041,"8 months",124,12,136,86,204,1.5,1710,232560]
["St Marks PS","Firrhill",30,33,1.1000000000000001,1200.8,36024,"Replacement new build",557,3000,"2Q 2018",284,2020,302,0,0,1776908.4507042253,"8 months",96,10,106,76,154,1.4528301886792452,1653,175218]
["Carrick Knowe PS","Forrester",60,94,1.5666666666666667,1200.8,72048,"Replacement new build",505,3000,"2Q 2018",284,2020,302,0,0,1611021.1267605633,"8 months",87,9,96,36,144,1.5,1710,164160]
["Calderglen NS","Forrester",60,100,1.6666666666666667,1200.8,72048,"Replacement new build",667,3000,"2Q 2018",284,2020,302,0,0,2127823.9436619719,"8 months",115,11,126,66,189,1.5,1710,215460]
["Craigentinny PS","Leith",40,79,1.9750000000000001,1200.8,48032,"Replacement new build",720,3000,"2Q 2018",284,2019,290,0,0,2205633.8028169014,"8 months",124,12,136,96,204,1.5,1710,232560]
["St John Vianny PS","Liberton",30,44,1.4666666666666666,1200.8,36024,"Replacement new build",667,3000,"2Q 2018",284,2019,290,0,0,2043274.647887324,"8 months",115,12,127,97,189,1.4881889763779528,1710,217170]
["Gilmerton EYC","Liberton",50,68,1.36,1200.8,60040,"Replacement new build",331,3000,"2Q 2018",284,2019,290,0,0,1013978.8732394367,"8 months",57,6,63,13,126,2,2280,143640]
["Royal High PS","Portobello",30,53,1.7666666666666666,1200.8,36024,"Replacement new build",499,3000,"2Q 2018",284,2019,290,0,0,1528626.7605633803,"8 months",86,9,95,65,150,1.5789473684210527,1801,171095]
["Kirkliston NS","Queensferry",70,186,2.657142857142857,1200.8,84056,"Replacement new build",557,3000,"2Q 2018",284,2019,290,0,0,1706302.8169014086,"8 months",96,10,106,36,154,1.4528301886792452,1653,175218]
["Echline PS","Queensferry",30,59,1.9666666666666666,1200.8,36024,"Replacement new build",505,3000,"2Q 2018",284,2019,290,0,0,1547007.042253521,"8 months",87,9,96,66,144,1.5,1710,164160]
["Sighthill PS","WHEC",30,49,1.6333333333333333,1200.8,36024,"Replacement new build",720,3000,"2Q 2018",284,2020,302,0,0,2296901.4084507041,"8 months",124,12,136,106,204,1.5,1710,232560]
[null,null,null,null,{"$error":"#DIV/0!"},null,0,null,null,null,"2Q 2018",284,null,null,null,null,0,null,null,null,0,0,null,{"$error":"#DIV/0!"},null,0]
[]
["New Build Projects "]
["Example E","D",40,75,1.875,1200.8,48032,"New build",580,3000,"2Q 2018",284,"2Q 2019",290,0,0,1776760.5633802817,"12 months",100,20,120,80,115,0.95833333333333337,1140,136800]
["Example F","D",40,80,2,2500,100000,"New build",580,3000,"2Q 2018",284,"1Q 2020",302,0.15,0,2127823.9436619715,"12 months",100,20,120,80,210,1.75,2500,300000]
["Boroughmuir ELCC","Boroughmuir",0,0,{"$error":"#DIV/0!"},0,0,"New build",424,3000,"2Q 2018",284,2020,302,0,0,1352619.7183098593,"8 months",73,7,80,80,120,1.5,1710,136800]
["Craigmount ELCC","Craigmount",0,0,{"$error":"#DIV/0!"},0,0,"New build",424,3000,"2Q 2018",284,2020,302,0,0,1352619.7183098593,"8 months",73,7,80,80,120,1.5,1710,136800]
["Craigroyston ELCC","Craigroyston",0,0,{"$error":"#DIV/0!"},0,0,"New build",795,3000,"2Q 2018",284,2020,302,0,0,2536161.971830986,"8 months",137,14,151,151,229,1.5165562913907285,1733,261683]
["Currie ELCC","Currie",0,0,{"$error":"#DIV/0!"},0,0,"New build",476,3000,"2Q 2018",284,2020,302,0,0,1518507.042253521,"8 months",82,8,90,90,140,1.5555555555555556,1779,160110]
["Broomhills ELCC","Gracemount",0,0,{"$error":"#DIV/0!"},0,0,"New build",401,3000,"2Q 2018",284,2020,302,0,0,1279246.4788732394,"8 months",69,7,76,76,126,1.6578947368421053,2007,152532]
["Gracemount ELCC","Gracemount",0,0,{"$error":"#DIV/0!"},0,0,"New build",401,3000,"2Q 2018",284,2020,302,0,0,1279246.4788732394,"8 months",69,7,76,76,126,1.6578947368421053,2007,152532]
["North Leith ELCC","Leith",0,0,{"$error":"#DIV/0!"},0,0,"New build",720,3000,"2Q 2018",284,2020,302,0,0,2296901.4084507041,"8 months",124,12,136,136,204,1.5,1710,232560]
["Trinity ELCC","Trinity",0,0,{"$error":"#DIV/0!"},0,0,"New build",418,3000,"2Q 2018",284,2020,302,0,0,1333478.8732394367,"8 months",72,7,79,79,119,1.5063291139240507,1722,136038]
[]
["Outdoor Projects (Standalone eg Forrest Kindergarten) "]
["Example G","A",48,75,1.5625,1200.8,57638.399999999994,"Provision of geodome and associated works",null,null,null,null,null,null,null,null,500000,"3 months",100,48,148,100,115,0.77702702702702697,1140,168720]
["Example H","A",24,80,3.3333333333333335,2500,60000,"Provision of yurt and associate works",null,null,null,null,null,null,null,null,250000,"3 months",100,24,124,100,210,1.6935483870967742,2500,310000]
["Clifton Hall FK","Balerno",0,0,{"$error":"#DIV/0!"},0,0,"Yurt",null,null,null,null,null,null,null,null,50000,"3 months",null,30,30,30,30,1,1140,34200]
["Mortonhall FK","Gracemount",0,0,{"$error":"#DIV/0!"},0,0,"Yurt",null,null,null,null,null,null,null,null,50000,"3 months",null,30,30,30,30,1,1140,34200]
["Hermitage FK","James Gillespies",0,0,{"$error":"#DIV/0!"},0,0,"Yurt",null,null,null,null,null,null,null,null,50000,"3 months",null,30,30,30,30,1,1140,34200]
["Meadows Yard FK","Leith",0,0,{"$error":"#DIV/0!"},0,0,"Yurt",null,null,null,null,null,null,null,null,50000,"3 months",null,30,30,30,30,1,1140,34200]
["Meadow Field FK","Portobello",0,0,{"$error":"#DIV/0!"},0,0,"Yurt",null,null,null,null,null,null,null,null,50000,"3 months",null,30,30,30,30,1,1140,34200]
["Laurison Castle FK","Royal High",0,0,{"$error":"#DIV/0!"},0,0,"Yurt",null,null,null,null,null,null,null,null,50000,"3 months",null,30,30,30,30,1,1140,34200]
["Craiglockhart FK","Tynecastle",0,0,{"$error":"#DIV/0!"},0,0,"Yurt",null,null,null,null,null,null,null,null,50000,"3 months",null,30,30,30,30,1,1140,34200]
[null,null,null,null,{"$error":"#DIV/0!"},null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,{"$error":"#DIV/0!"},null,0]
[null,null,null,null,{"$error":"#DIV/0!"},null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,{"$error":"#DIV/0!"},null,0]
["Other LA Settings Where No Capital Works Are Envisaged At Present (Please list all other settings)",null,null,null,{"$error":"#DIV/0!"},null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,{"$error":"#DIV/0!"},null,0]
["Example I","B",40,80,2,1200.8,48032,null,null,null,null,null,null,null,null,null,null,null,48,0,48,8,80,1.6666666666666667,2500,120000]
["Example J","C",100,160,1.6,2500,250000,null,null,null,null,null,null,null,null,null,null,null,100,12,112,12,180,1.6071428571428572,2500,280000]
["Buckstone PS","Boroughmuir",40,75,1.875,1200.8,48032,null,null,null,null,null,null,null,null,null,null,null,40,0,40,0,40,1,1140,45600]
["South Morningside PS","Boroughmuir",30,41,1.3666666666666667,1200.8,36024,null,null,null,null,null,null,null,null,null,null,null,0,0,0,-30,0,{"$error":"#DIV/0!"},0,0]
["Viewforth","Boroughmuir",62,36,0.58064516129032262,1580,97960,null,null,null,null,null,null,null,null,null,null,null,70,0,70,8,140,2,2280,159600]
["Ferryhill PS","Broughton",40,78,1.95,1200.8,48032,null,null,null,null,null,null,null,null,null,null,null,79,0,79,39,142,1.7974683544303798,2104,166216]
["Flora Stevenson PS","Broughton",60,117,1.95,1200.8,72048,null,null,null,null,null,null,null,null,null,null,null,56,0,56,-4,56,1,1140,63840]
["Granton EYC","Broughton",15,21,1.4,1580,23700,null,null,null,null,null,null,null,null,null,null,null,55,0,55,40,110,2,2280,125400]
["Stockbridge PS","Broughton",40,69,1.7250000000000001,1200.8,48032,null,null,null,null,null,null,null,null,null,null,null,40,0,40,0,40,1,1140,45600]
["Castleview PS","Castlebrae",30,59,1.9666666666666666,1200.8,36024,null,null,null,null,null,null,null,null,null,null,null,32,0,32,2,32,1,1140,36480]
["Craigmillar EYC","Castlebrae",36,44,1.2222222222222223,1580,56880,null,null,null,null,null,null,null,null,null,null,null,44,0,44,8,88,2,2280,100320]
["Greendykes EYC","Castlebrae",44,100,2.2727272727272729,1580,69520,null,null,null,null,null,null,null,null,null,null,null,44,0,44,0,88,2,2280,100320]
["Greengables NS","Castlebrae",50,53,1.06,1200.8,60040,null,null,null,null,null,null,null,null,null,null,null,48,0,48,-2,48,1,1140,54720]
["Newcraighall PS","Castlebrae",20,34,1.7,1200.8,24016,null,null,null,null,null,null,null,null,null,null,null,16,0,16,-4,16,1,1140,18240]
["Oaklands","Castlebrae",8,8,1,1200.8,9606.4,null,null,null,null,null,null,null,null,null,null,null,8,0,8,0,8,1,1140,9120]
["Corstorphine PS","Craigmount",50,97,1.94,1200.8,60040,null,null,null,null,null,null,null,null,null,null,null,48,0,48,-2,96,2,2280,109440]
["East Craigs PS","Craigmount",40,78,1.95,1200.8,48032,null,null,null,null,null,null,null,null,null,null,null,40,0,40,0,40,1,1140,45600]
["Fox Covert EYC","Craigmount",85,141,1.6588235294117648,1580,134300,null,null,null,null,null,null,null,null,null,null,null,87,0,87,2,127,1.4597701149425288,1665,144855]
["Hillwood PS","Craigmount",20,13,0.65,1200.8,24016,null,null,null,null,null,null,null,null,null,null,null,34,0,34,14,34,1,1140,38760]
["Roseburn PS","Craigmount",30,38,1.2666666666666666,1200.8,36024,null,null,null,null,null,null,null,null,null,null,null,32,0,32,2,32,1,1140,36480]
["Craigroyston PS","Craigroyston",40,99,2.4750000000000001,1200.8,48032,null,null,null,null,null,null,null,null,null,null,null,40,0,40,0,40,1,1140,45600]
["Craigroyston EYC","Craigroyston",30,32,1.0666666666666667,1580,47400,null,null,null,null,null,null,null,null,null,null,null,30,0,30,0,30,1,1140,34200]
["Pirniehall PS","Craigroyston",30,56,1.8666666666666667,1200.8,36024,null,null,null,null,null,null,null,null,null,null,null,32,0,32,2,32,1,1140,36480]
["St David's RC PS","Craigroyston",30,59,1.9666666666666666,1200.8,36024,null,null,null,null,null,null,null,null,null,null,null,32,0,32,2,32,1,1140,36480]
["Currie PS","Currie",60,117,1.95,1200.8,72048,null,null,null,null,null,null,null,null,null,null,null,64,0,64,4,64,1,1140,72960]
["Juniper Green PS","Currie",50,98,1.96,1200.8,60040,null,null,null,null,null,null,null,null,null,null,null,48,0,48,-2,48,1,1140,54720]
["Bun-sgoil Taobh na Pairce","Drummond",40,79,1.9750000000000001,1200.8,48032,null,null,null,null,null,null,null,null,null,null,null,40,0,40,0,80,2,2280,91200]
["Leith Walk PS","Drummond",60,104,1.7333333333333334,1200.8,72048,null,null,null,null,null,null,null,null,null,null,null,58,0,58,-2,116,2,2280,132240]
["Bonaly PS","Firrhill",50,94,1.88,1200.8,60040,null,null,null,null,null,null,null,null,null,null,null,48,0,48,-2,48,1,1140,54720]
["Colinton PS","Firrhill",20,41,2.0499999999999998,1200.8,24016,null,null,null,null,null,null,null,null,null,null,null,24,0,24,4,24,1,1140,27360]
["Longstone PS","Firrhill",30,46,1.5333333333333334,1200.8,36024,null,null,null,null,null,null,null,null,null,null,null,55,0,55,25,110,2,2280,125400]
["Oxgangs PS","Firrhill",50,87,1.74,1200.8,60040,null,null,null,null,null,null,null,null,null,null,null,50,0,50,0,50,1,1140,57000]
["Pentland PS","Firrhill",50,77,1.54,1200.8,60040,null,null,null,null,null,null,null,null,null,null,null,48,0,48,-2,48,1,1140,54720]
["Braidburn","Firrhill",8,8,1,1200.8,9606.4,null,null,null,null,null,null,null,null,null,null,null,8,0,8,0,8,1,1140,9120]
["Broomhouse PS","Forrester",30,59,1.9666666666666666,1200.8,36024,null,null,null,null,null,null,null,null,null,null,null,32,0,32,2,32,1,1140,36480]
["Murrayburn PS","Forrester",30,54,1.8,1200.8,36024,null,null,null,null,null,null,null,null,null,null,null,32,0,32,2,32,1,1140,36480]
["Gylemuir PS","Forrester",75,130,1.7333333333333334,1200.8,90060,null,null,null,null,null,null,null,null,null,null,null,71,0,71,-4,71,1,1140,80940]
["St Joseph's RC PS","Forrester",38,75,1.9736842105263157,1200.8,45630.400000000001,null,null,null,null,null,null,null,null,null,null,null,40,0,40,2,40,1,1140,45600]
["Gracemount PS","Gracemount",50,91,1.82,1200.8,60040,null,null,null,null,null,null,null,null,null,null,null,52,0,52,2,52,1,1140,59280]
["St Catherine's RC PS","Gracemount",20,39,1.95,1200.8,24016,null,null,null,null,null,null,null,null,null,null,null,24,0,24,4,24,1,1140,27360]
["Cowgate Under 5's","James Gillespie's",42,53,1.2619047619047619,1852.5,77805,null,null,null,null,null,null,null,null,null,null,null,42,0,42,0,84,2,2280,95760]
["James Gillespie's PS","James Gillespie's",40,76,1.9,1200.8,48032,null,null,null,null,null,null,null,null,null,null,null,40,0,40,0,40,1,1140,45600]
["Royal Mile PS","James Gillespie's",60,42,0.7,1200.8,72048,null,null,null,null,null,null,null,null,null,null,null,60,0,60,0,60,1,1140,68400]
["Tollcross EYC","James Gillespie's",70,72,1.0285714285714285,1580,110600,null,null,null,null,null,null,null,null,null,null,null,72,0,72,2,112,1.5555555555555556,1779,128088]
["Craigentinny EYC","Leith",30,34,1.1333333333333333,1580,47400,null,null,null,null,null,null,null,null,null,null,null,30,0,30,0,30,1,1140,34200]
["Hermitage Park PS","Leith",30,57,1.9,1200.8,36024,null,null,null,null,null,null,null,null,null,null,null,24,0,24,-6,24,1,1140,27360]
["Leith PS","Leith",30,57,1.9,1200.8,36024,null,null,null,null,null,null,null,null,null,null,null,55,0,55,25,55,1,1140,62700]
["Lorne PS","Leith",20,38,1.9,1200.8,24016,null,null,null,null,null,null,null,null,null,null,null,24,0,24,4,24,1,1140,27360]
["St Mary's RC PS","Leith",30,55,1.8333333333333333,1200.8,36024,null,null,null,null,null,null,null,null,null,null,null,32,0,32,2,32,1,1140,36480]
["St Ninian's RC PS","Leith",30,58,1.9333333333333333,1200.8,36024,null,null,null,null,null,null,null,null,null,null,null,32,0,32,2,32,1,1140,36480]
["Cameron House NS","Liberton",20,44,2.2000000000000002,1200.8,24016,null,null,null,null,null,null,null,null,null,null,null,25,0,25,5,25,1,1140,28500]
["Craigour Park PS","Liberton",50,94,1.88,1200.8,60040,null,null,null,null,null,null,null,null,null,null,null,48,0,48,-2,48,1,1140,54720]
["Liberton PS","Liberton",25,43,1.72,1200.8,30020,null,null,null,null,null,null,null,null,null,null,null,24,0,24,-1,24,1,1140,27360]
["Liberton NS","Liberton",50,99,1.98,1200.8,60040,null,null,null,null,null,null,null,null,null,null,null,48,0,48,-2,96,2,2280,109440]
["Spinney Lane","Liberton",60,131,2.1833333333333331,null,0,null,null,null,null,null,null,null,null,null,null,null,64,0,64,4,64,1,1140,72960]
["Duddingston PS","Portobello",60,97,1.6166666666666667,1200.8,72048,null,null,null,null,null,null,null,null,null,null,null,64,0,64,4,64,1,1140,72960]
["Parsons Green PS","Portobello",30,45,1.5,1200.8,36024,null,null,null,null,null,null,null,null,null,null,null,32,0,32,2,32,1,1140,36480]
["St John's RC PS","Portobello",40,64,1.6,1200.8,48032,null,null,null,null,null,null,null,null,null,null,null,55,0,55,15,55,1,1140,62700]
["Towerbank PS","Portobello",40,73,1.825,1200.8,48032,null,null,null,null,null,null,null,null,null,null,null,40,0,40,0,40,1,1140,45600]
["Queensferry PS","Queensferry",50,98,1.96,1200.8,60040,null,null,null,null,null,null,null,null,null,null,null,56,0,56,6,56,1,1140,63840]
["Queensferry EYC","Queensferry",30,28,0.93333333333333335,1580,47400,null,null,null,null,null,null,null,null,null,null,null,30,0,30,0,60,2,2280,68400]
["Clermiston PS","The Royal High",40,73,1.825,1200.8,48032,null,null,null,null,null,null,null,null,null,null,null,40,0,40,0,40,1,1140,45600]
["Cramond PS","The Royal High",50,95,1.9,1200.8,60040,null,null,null,null,null,null,null,null,null,null,null,48,0,48,-2,48,1,1140,54720]
["Davidson's Mains PS","The Royal High",40,79,1.9750000000000001,1200.8,48032,null,null,null,null,null,null,null,null,null,null,null,79,0,79,39,119,1.5063291139240507,1849,146071]
["Holy Cross RC PS","Trinity",40,78,1.95,1200.8,48032,null,null,null,null,null,null,null,null,null,null,null,40,0,40,0,40,1,1140,45600]
["Fort EYC","Trinity",90,139,1.5444444444444445,1200.8,108072,null,null,null,null,null,null,null,null,null,null,null,94,0,94,4,164,1.7446808510638299,1983,186402]
["Wardie PS","Trinity",40,64,1.6,1200.8,48032,null,null,null,null,null,null,null,null,null,null,null,40,0,40,0,40,1,1400,56000]
["Balgreen NS","Tynecastle",60,67,1.1166666666666667,1200.8,72048,null,null,null,null,null,null,null,null,null,null,null,64,0,64,4,104,1.625,1858,118912]
["Craiglockhart PS","Tynecastle",20,38,1.9,1200.8,24016,null,null,null,null,null,null,null,null,null,null,null,24,0,24,4,24,1,1140,27360]
["Dalry PS","Tynecastle",60,74,1.2333333333333334,1200.8,72048,null,null,null,null,null,null,null,null,null,null,null,64,0,64,4,64,1,1140,72960]
["Stenhouse PS","Tynecastle",40,79,1.9750000000000001,1200.8,48032,null,null,null,null,null,null,null,null,null,null,null,40,0,40,0,40,1,1140,45600]
["Stenhouse EYC","Tynecastle",30,18,0.6,1580,47400,null,null,null,null,null,null,null,null,null,null,null,30,0,30,0,60,2,2280,68400]
["Tynecastle NS","Tynecastle",40,72,1.8,1200.8,48032,null,null,null,null,null,null,null,null,null,null,null,55,0,55,15,110,2,2280,125400]
["Hailesland EYC","WHEC",38,52,1.368421052631579,1580,60040,null,null,null,null,null,null,null,null,null,null,null,44,0,44,6,88,2,2280,100320]
["Sighthill EYC","WHEC",30,27,0.9,1580,47400,null,null,null,null,null,null,null,null,null,null,null,30,0,30,0,30,1,1140,34200]
[null,null,null,null,{"$error":"#DIV/0!"},null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,{"$error":"#DIV/0!"},null,0]
[]
["Other Non Settings Related Capital Works"]
["Example K",null,null,null,null,null,null,"Catering provision to accommodate universal free lunch commitment",null,null,null,null,null,null,null,null,500000]
["Example L",null,null,null,null,null,null,"Systems costs (Capital in nature)",null,null,null,null,null,null,null,null,100000]
[null,null,null,null,null,null,null,"Catering equipment",null,null,null,null,null,null,null,null,90000]
[null,null,null,null,null,null,null,"Refurbishment / reinstatement of production kitchens",null,null,null,null,null,null,null,null,520000]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anticipated Total Capital Cost for All Projects",39386635.098591544]
[null,"Totals",4096,6750,1.64794921875,null,5101320.1999999993,null,null,null,null,null,null,null,null,null,null,"Totals",6003,410,6413,2317,8635,1.3464837049742711,null,9890148,"NB: Please ensure totals exclude examples"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Increase from Pre Works",1885,null,null,4788827.8000000007]
[null,null,"Cross check to Input Table",11051.9452,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cross check to Input Table",11439.545]
[null,null,null,"Check",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check"]

{"sheet":"Analysis ","index":9,"n_rows":100,"n_cols":12,"rows_kept":100,"cut":false,"hidden":true,"merged":[[7,25,7,30]]}
[]
[null,null,null,null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22",null,"% Change "]
[null,null,"Input"]
[null,null,null,"No. Of Lunches:",0,190000,427500,950000,2067770,1870451.2]
[null,null,null,"Total Population:",22013,21928,21547,21357,21303,21463,null,-2.4985235996910916E-2]
[null,null,null,"Total Uptake:",11051.9452,11026.655199999999,10901.765000000001,10990.66,11289.21,11439.545,null,3.507073125914522E-2]
[null,null,null,"No. Students in LA:",7225.3741599999994,7112.9919600000003,7046.5451999999996,7150.4512000000004,7389.1675999999998,7488.1701999999996,null,3.6371270771671731E-2]
[]
[null,null,null,"LA Provision 2YO",0.8,0.8,0.8,0.8,0.8,0.8]
[null,null,null,"PP Provision 2YO",0.2,0.19,0.19,0.19,0.19,0.19]
[null,null,null,"CM Provision 2YO",0,0.01,0.01,0.01,0.01,0.01]
[]
[null,null,null,"LA Provision 34YO",0.65,0.64,0.64,0.64,0.64,0.64]
[null,null,null,"PP Provision 34YO",0.35,0.35,0.35,0.35,0.35,0.35]
[null,null,null,"CM Provision 34YO",0,0.01,0.01,0.01,0.01,0.01]
[]
[null,null,null,"LA Provision 5YO",0.6,0.6,0.6,0.6,0.6,0.6]
[null,null,null,"PP Provision 5YO",0.4,0.39,0.39,0.39,0.39,0.39]
[null,null,null,"CM Provision 5YO",0,0.01,0.01,0.01,0.01,0.01]
[]
[null,null,null,"Total Statutory Hours (All Settings) ",5986497.1200000001,5976120.1199999992,5919087,5979444,9937068,11837104.5,null,0.97730062551170149]
[null,null,null,"Total Phased Hours (All Settings) ",237060,791880,1517265,2976060,2796855,0]
[null,null,null,"% of total hours phased",25.253088332067833,7.5467496590392473,3.9011556979169755,2.0091812665067237,3.5529435741216475,{"$error":"#DIV/0!"}]
[null,null,null,"Total Hours (LA Settings)",4058424.9960000003,4367904.4560000002,4825949.04,5852677.4400000004,8482461.324000001,7765968.8760000002,null,0.91354254018595138]
[null,null,null,"Total Hours (PP)",2165132.1239999998,2332415.6628,2536039.4399999995,3013271.5199999996,4124122.446,3952764.5790000004,null,0.82564589716465764]
[null,null,null,"Stat Hours (LA Settings)",3916188.9959999998,3858276.4559999998,3829865.04,3896701.44,6518874.5239999993,7765968.8760000002,null,0.98304241289993155]
[null,null,null,"2YO Hours in LA Settings ",207760.89600000001,287246.49599999998,437248.80000000005,707971.2,1764903.3600000003,1051827.8399999999,null,4.0626843657817107]
[null,null,null,"2YO ASN Hours",37396.961280000003,51704.369279999992,78704.784,127434.81599999999,317682.60480000003,189329.01119999998,null,{"$error":"#DIV/0!"}]
[null,null,null,"2YO Non-ASN Hours",170363.93472000002,235542.12672,358544.01600000006,580536.38399999996,1447220.7552000005,862498.8287999999,null,4.0626843657817098]
[null,null,null,"3,4 Hours",3540556.5,4080657.96,4388700.24,5144706.24,6717557.9639999997,6714141.0360000003,null,0.89635189722293662]
[null,null,null,"3,4 ASN Hours ",637300.16999999993,734518.43279999995,789966.04319999996,926047.12320000003,1209160.43352,1208545.3864800001,null,{"$error":"#DIV/0!"}]
[null,null,null,"3,4 Non-ASN Hours",2903256.33,3346139.5272000004,3598734.1968000005,4218659.1168000009,5508397.5304800002,5505595.6495200004,null,0.89635189722293662]
[null,null,null,"5 Hours",310107.60000000003,315973.8,311490,306590.39999999997,303451.02,302153.57999999996,null,{"$error":"#DIV/0!"}]
[null,null,null,"5 ASN Hours",55819.368000000002,56875.283999999992,56068.2,55186.27199999999,54621.183600000004,54387.64439999999,null,{"$error":"#DIV/0!"}]
[null,null,null,"5 Non-ASN Hours ",254288.23200000005,259098.516,255421.80000000002,251404.128,248829.83640000003,247765.9356,null,{"$error":"#DIV/0!"}]
[]
[null,null,null,"Percentage of Children Receiving Phased Entitlement",3.9721514362919569E-2,0.14301707738172498,0.27986293962491393,0.5519231784078481,1.1020257396221702,0]
[null,null,null,"Percentage of Total Population With ASN",0.17999999999999997,0.18,0.18,0.18,0.18,0.17999999999999997,null,{"$error":"#DIV/0!"}]
[]
[null,null,null,"Nursery Rate 2YO",3.6,3.67,3.77,4.13,4.97,5.31,null,0.47499999999999987]
[null,null,null,"Nursery Rate 3YO",3.6,3.67,3.77,4.13,4.97,5.31,null,0.47499999999999987]
[]
[]
[null,null,"Staffing"]
[null,null,null,"No FTE Staff:",667.86067640464785,773.47967780945601,943.19117704025359,1031.1648542154167,1335.7058610911304,1496.018045228057,null,1.2400151679564371]
[null,null,null,"Minimum Required Hours",579855.41855399997,673276.71386400005,748920.07944,913590.13344000001,1367748.0969240002,1207366.2404759999,null,1.08218497550103]
[null,null,null,"Total Proposed Ratio Committed Staff Hours",959208.89999999991,1052002.9150854526,1137350.5270031034,1190956.4005226514,1483012.9548353441,1647728.623993868,null,0.71779955752481883]
[null,null,null,"Implied Staff hours:Child Hours ratio",4.2310126563671382,4.151988928324597,4.2431501330696015,4.9142667501778838,5.7197486349280009,4.7131358664974563,null,0.1139498387944512]
[null,null,null,"Total FTE (52/35) Ratio Committed Staff",527.03785714285709,578.02357971728168,624.91787197972712,654.37164863881947,814.84228287656265,905.34539779882857]
[null,null,"Staff Hours"]
[null,null,null,"p",669164.8042928325,829520.88909664657,1049713.5589885386,1167924.1623384811,1572036.6792144165,1802595.7255653511,null,1.6937993660176411]
[null,null,null,"m",26769.600000000002,29250,29367,29016,25506,23400,null,-0.12587412587412594]
[null,null,null,"s",105787.5,111588.75,157798.875,165664.6875,178717.5,184860,null,0.74746543778801844]
[null,null,null,"a",79636.777643835623,79636.777643835623,85924.800000000003,91728,133286.39999999999,134596.80000000002,null,0.6901336792149656]
[]
[]
[null,null,null,"Ratio Committed staff Output",7597.2014152002994,7467.5182345955955,7634.9926131676075,8840.7894904199547,10340.170233018946,8539.2217533028142,null,0.12399570402566175]
[null,null,null,"Child: staff Ratio",13.525597454137024,12.160613332754608,11.148132751594837,10.801147759942287,9.007438754613533,8.233762829243906,null,-0.39124590561243744]
[]
[]
[null,null,"Revenue"]
[null,null,null,"Total Revenue",29953991.649999999,34599446.700000003,42081938.060000002,50228848.68,71494029.980000004,76313616.409999996,null,1.5476943875024416]
[null,null,null,"Staff Expenditure",22641275.640000001,25427961.75,30269163.600000001,32776079.52,40920583,45220730.759999998,null,0.99726956550580637]
[null,null,null,"Staff Expenditure (% OF total)",0.75586839659147742,0.73492394171725284,0.71929110196499346,0.65253495513725956,0.57236363667633883,0.59256437956037367]
[null,null,null,"Ratio Committed Staff Expenditure",17309364.199999999,18871654.030000001,20324426.940000001,21279834.09,26190486.02,28944026.07,null,0.67215997858546428]
[null,null,null,"Ratio Committed Staff Expenditure (of Total Staff Expenditure)",0.7645048130335822,0.74216149196464798,0.67145650962090009,0.64924891572266974,0.64003208409811752,0.64006099820930895]
[null,null,null,"PP Cost",7794475.6500000004,8878061.4900000002,9910377.2300000004,12902437.630000001,21173059.870000001,21617730.16,null,1.7734681755019659]
[null,null,null,"PP Cost (% Of total)",0.26021492364273929,0.25659547584614983,0.2355019204645443,0.25687305142507599,0.29615143916104641,0.28327487513967758]
[null,null,null,"Lunch",0,570000,1282500,2850000,6203310,5611353.5999999996,null,{"$error":"#DIV/0!"}]
[null,null,null,"lunch Cost (% of total) ",0,1.6474251884496173E-2,3.0476257965387062E-2,5.6740301139627872E-2,8.6766825170372069E-2,7.3530175399533257E-2]
[null,null,null,"Running",-481759.64,-276576.53999999998,619897.23,1700331.52,3197077.12,3863801.89,null,{"$error":"#DIV/0!"}]
[null,null,null,"Running Costs (% of Total)",-1.6083320234216599E-2,-7.9936694478990027E-3,1.4730719605075146E-2,3.385169209894779E-2,4.4718099132114414E-2,5.0630569900415499E-2]
[]
[]
[null,null,null,"Cost Per child (all settings)",2710.29,3137.8,3860.1,4570.1400000000003,6332.95,6671.04,null,1.4613749820129949]
[null,null,null,"Cost per Child (LA Settings)",3066.9,3535.98,4383.58,4821.57,5970.59,6554.94,null,1.1373178127751147]
[null,null,null,"Staff Cost per Child (LA Settings)",2956.6,3390.33,4019.52,4257.68,5207.5,5706.33,null,0.93003111682337825]
[null,null,null,"Unit Cost (LA Settings)",5.46,5.76,6.4,5.89,5.2,6.32,null,0.15750915750915756]
[null,null,null,"staff Unit Cost  (LA Settings)",5.58,5.82,6.27,5.6,4.82,5.82,null,4.3010752688172081E-2]
[null,null,null,"Average Unit Cost of Ratio Committed Staff ",32402.400000000001,32263.62,32154.68,32144.35,31926.36,31825.97,null,-1.7789731624817923E-2]
[null,null,null,"Average Unit Cost of Central Staff",54731.96,54731.96,46900.93,44507.46,44507.46,44507.46,null,-0.18681041205175186]
[]
[null,null,"Average Unit Cost of Ratio Committed Staff "]
[null,null,null,"p",27769.83,27769.83,27769.83,27769.83,27769.83,27769.83,null,0]
[null,null,null,"m",51760,51760,51760,51760,51760,51760,null,0]
[null,null,null,"s",43148,43148,43148,43148,43148,43148,null,0]
[null,null,null,"a",23528.89,23528.89,23528.89,23528.89,23528.89,23528.89,null,0]
[]
[]
[null,null,"Capital"]
[null,null,null,"Additional Capacity Proposed:",1907]
[null,null,null,"Additional Capacity Proposed (% Increase)"]
[]
[null,null,null,"AC of 1 Capacity Place",20653.715311269818]
[]
[null,null,null,null,"Current","Proposed"]
[null,null,null,"Max Deliverable Hours",5101320.1999999993,9890148]
[null,null,null,"Actual ELC Hours Delivered ",4058424.9960000003,7765968.8760000002]
[]
[null,null,null,"Utilisation",0.79556366526453304,0.78522271618180028]