{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Guide for LAs","Input form","Plan output","Do not change - workings"],"not_rendered":{"charts":4,"images":2,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Guide for LAs","index":0,"n_rows":72,"n_cols":3,"rows_kept":72,"cut":false,"hidden":false,"merged":[[64,1,64,2],[65,1,65,2],[1,1,1,2],[56,1,56,2],[61,1,61,2],[3,1,3,2],[4,1,4,2],[8,1,8,2],[9,1,9,2],[12,1,12,2],[28,1,28,2],[31,1,31,2],[36,1,36,2],[37,1,37,2],[39,1,39,2],[58,1,58,2],[38,2,38,3],[14,1,15,2],[29,1,29,2],[6,1,6,2],[30,1,30,2],[32,1,32,2],[10,1,10,2],[17,1,17,2],[20,1,20,2],[24,1,24,2]]}
[]
[null,"How to complete the template (guidance for local authorities)"]
[]
[null,"Which projects do I enter information about?"]
[null,"The template is for local authorities to show local groups how they plan to invest in capital projects to get good outcomes for pupils with education, health and care (EHC) plans for their special educational need or disability."]
[]
[null,"The template should include: "]
[]
[null,"All capital projects at a range of provision including mainstream and special schools designed to create new (additional) places, build new facilities or improve existing facilities to benefit pupils with EHC plans. This includes investment in mainstream and special provision for children and young people aged 0-25. "]
[null,"This must include capital projects funded fully or partially through the special provision fund allocation "]
[null,"This may include expenditure on capital projects funded via other funding (where applicable) up until the financial year 2020/21."]
[]
[null,"The template should not include whole new centrally-funded free schools. Money from the special provision capital fund cannot be spent on revenue (i.e. staffing costs and training) and revenue expenditure should not be included on the form. "]
[]
[null,"The local authority should not enter costings for any project where this constitutes commercially sensitive information, for example, if contracts have not yet been tendered. The local authority may choose to set out indicative costings and mark this in the comments box. Where all costs are not entered when the plan is first published the local authority should republish the plan once costs can be included."]
[]
[]
[null,"There are two forms to complete on the 'input form' tab"]
[null,"1. Project information form","Complete this for each project"]
[null,"2. Consultation form","Complete this for each group you have consulted about any of the projects. This table must include information about how you have consulted parents and carers."]
[null,"If you find that you need to enter more rows of information please press the 'Click here if you would like to add a new row' button."]
[]
[null,"How to enter information:"]
[]
[null,"Click 'Enable content' at the top of the form."]
[]
[null,"Information about overall funding"]
[]
[null,"All information is entered into the 'input form' tab. The information you enter here generates your local authority's plan output."]
[null,"Select your local authority from the drop-down list at cell E3 'Select Local Authority'."]
[null,"The amount your local authority will receive from the special provision fund will be automatically added to the cell E5."]
[null,"In cell E6 [if applicable] enter any other funding that your LA plans to invest in new (additional) places or improvements to facilities for pupils with EHCs plans up until and including for the financial year 2020/21."]
[null,"In cell L3 enter the date of the last update (today's date)."]
[]
[null,"Information about individual projects"]
[]
[null,"Each project should be entered into the input form. This includes both investment in additional places and investment in facilities in all provision types."]
[]
[]
[null,"For all projects enter the following information:"]
[null,"Provision URN (column B)","Please enter the URN of the provision (i.e. school, college or other provision) that the project is based at. If the funding is used towards provision that has not yet been built and therefore does not have a URN please leave this cell blank."]
[null,"Provision name and address (column C)","Enter provision name and address including postcode.\nIf school covers more than one site please enter the address of the site that the project will be located at."]
[null,"Provision category (column D)","Select provision type from drop-down box. (See a full list at the end of this form showing how provision types are categorised).\nSelect 'other' if provision type is not listed and add further information in the comments box at column N 'Optional additional information'."]
[null,"Ofsted judgement (column E)","Select from drop-down list the school's Ofsted grading at its last inspection before this plan is published or updated. The grade for special units should be listed as the Ofsted grading of the school."]
[null,"Age range for project (column F)","Select from drop-down list the age range that the new places or the facilities' improvements are for."]
[]
[null,"For investment in new (additional) places ","Please complete the following column(s) where the project involves creating new school places (adding to the number of places the school can provide)"]
[null,"Special provision fund investment in additional places (column G)","Enter how much the LA plans to invest in new places with funding from the special provision fund"]
[null,"Other investment in additional places (column H)","Where applicable enter how much the LA plans to invest in new places with any other funding."]
[null,"Special provision fund additional places (column I)","Enter the number of places you plan to create from special provision funding for this project. Where additional places have been created using a combination of the special provision fund and other funding please estimate how many places have been created from each."]
[null,"Other investment additional places (column J)","Enter the number of places you plan to create from other funding for this project."]
[null,"Total number of places (column K)","Enter the total number of places that the investment in additional places will create (this should be the same as column I plus column J)."]
[]
[null,"For investment in facilities ","Please complete the following column(s) where the project involves improving facilities at the school"]
[null,"Special provision fund investment in facilities (column L)","Enter how much the LA plans to invest in improvements to facilities with money from the special provision fund. "]
[null,"Other investment in facilities (column M)","Where applicable enter how much the LA plans to invest in improvements to facilities with any other funding."]
[null,"Projects should cover either one or both of the objectives (investment in additional places and/or improvements to facilities). Where projects cover both aims please estimate how much funding will be or is used for additional places and how much goes to improving facilities."]
[]
[null,"Additional information for each project"]
[null,"Type of SEN or disability that the project is designed to meet (column N)","Please enter information about the needs of the pupils that you plan to create additional places and/or improve facilities for. This could be general, or state specific needs depending upon the purpose of the project and the intake of the school."]
[null,"Additional information about each project (column O)","Enter additional information about the aims of the project. This should include a short explanation of how this fits into the wider strategic plan. This might also include, for example, a brief explanation of which facilities the LA plans to improve."]
[null,"Local authorities should create a link to their wider strategic plan. They can include refer to more detailed information about specific projects by linking to documents that they publish on their website. This might include a consultation document or further details about the project.\n"]
[]
[]
[null,"Required information about consultation"]
[null,"Local authorities are required to consult parents and carers about their plans and they should consult other groups. They need to do this before they receive their allocation and list the groups consulted. They can also publish the plan before they have consulted and re-publish afterwards making any changes if required.\nInformation needs to be set out in the consultation table that is below the project table on the input form."]
[null,"Column B (Group)","Enter the type of group consulted and/or the group's name. For example, local parent group, VCS organisation or school."]
[null,"Column D (date and method of discussion)","This should include whether and when meetings took place or if consultation took place via other means i.e. via email."]
[null,"Column F (Topic(s) of discussion)","Include a summary of what the conversation was about."]
[null,"Column N (Outcome including any changes as a result of the conversation)","Explain what points were agreed, what decisions or actions came out of the discussion, and what (if any) changes were, or will be made to plans."]
[null,"Other information"]
[null,"Password: provision1","The purpose of the password is to unlock tabs or sheets that show how the spreadsheet works. You do not need to use the password to complete the spreadsheet."]

{"sheet":"Input form","index":1,"n_rows":22,"n_cols":16,"rows_kept":22,"cut":false,"hidden":false,"merged":[[25,13,25,15],[26,13,26,15],[27,13,27,15],[28,13,28,15],[8,1,8,8],[8,9,8,12],[20,1,20,12],[10,1,10,12],[21,14,21,15],[21,5,21,12],[11,1,11,5],[21,1,21,2],[21,3,21,4],[22,13,22,15],[23,13,23,15],[24,13,24,15],[6,1,6,3],[6,11,6,12],[5,4,5,5],[6,4,6,5],[5,7,5,10],[6,7,6,10],[5,1,5,3],[1,14,1,15],[3,9,3,10],[3,11,3,12],[1,1,1,11],[3,1,3,3],[3,4,3,7],[6,14,6,15],[5,11,5,12],[11,14,11,15],[11,11,11,12],[11,6,11,7],[11,8,11,10],[5,14,5,15],[22,5,22,12],[28,1,28,2],[28,3,28,4],[28,5,28,12],[27,1,27,2],[27,3,27,4],[0,1,0,5],[25,5,25,12],[26,5,26,12],[27,5,27,12],[24,5,24,12],[22,1,22,2],[22,3,22,4],[23,1,23,2],[23,3,23,4],[23,5,23,12],[24,1,24,2],[24,3,24,4],[25,1,25,2],[25,3,25,4],[26,1,26,2],[26,3,26,4]]}
[null,"Special provision plan "]
[null,"Input form for Local Authority to complete"]
[]
[null,"Local authority",null,null,"SELECT LOCAL AUTHORITY",null,null,null,null,"Date of last update"]
[]
[null,"Local authority's special provision fund allocation",null,null,{"$f":"INDEX('Do not change - workings'!Y:Y,MATCH(E4,'Do not change - workings'!R:R, 0))","v":0},null,null,"Total planned expenditure on projects: special provision fund ",null,null,null,{"$f":"SUM(InputForm[Special provision fund investment in additional places],InputForm[Special provision fund investment in facilities])","v":0},null,null,{"$f":"IF(L6>E6,\"Error: Exceeded funding: Special provision spend columns H and M should not exceed total amount in cell F6\",\"\")","v":""}]
[null,"Other investment the local authority plans to make in SEND capital up until 2021",null,null,null,null,null,"Total planned expenditure on projects: other funding up until 2021",null,null,null,{"$f":"SUM(InputForm[Other investment in additional places],InputForm[Other investment in facilities])","v":0},null,null,{"$f":"IF(L7>E7,\"Error: Exceeded funding: Other investment columns H and M should not exceed total amount in cell F7\",\"\")","v":""}]
[]
[null,"The local authority is required to consult parents and carers to receive their allocation. Local authorities should use the box to the right to confirm that they have consulted with parents and carers about their plan and projects and complete the 'Consultation form' below.\n",null,null,null,null,null,null,null,"Confirm either that the LA has or will be consulting parents and carers"]
[]
[null,"Project information form"]
[null,"Provision",null,null,null,null,"Investment in additional places (£)",null,"Number of additional places",null,null,"Investment in facilities (£)",null,"Total (£)","Additional Information about each project"]
[null,"Provision  URN","Provision name and address","Provision category","Ofsted Judgement","Age range for project","Special provision fund investment in additional places","Other investment in additional places","Special provision fund additional planned places","Other investment additional planend places","Total additional planned places","Special provision fund investment in facilities","Other investment in facilities","Total investment in project","Type of SEN or disability that project is designed to meet.  ","LAs should use this section of the table to set out more details about the aims of the project. Beyond this further information can be listed in their strategic plan or directly on their local offer page. "]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(InputForm[[#This Row],[Special provision fund additional planned places]:[Other investment additional planend places]])","v":0},null,null,{"$f":"SUM(G14:H14,L14:M14)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(InputForm[[#This Row],[Special provision fund additional planned places]:[Other investment additional planend places]])","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(InputForm[[#This Row],[Special provision fund additional planned places]:[Other investment additional planend places]])","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(InputForm[[#This Row],[Special provision fund additional planned places]:[Other investment additional planend places]])","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(InputForm[[#This Row],[Special provision fund additional planned places]:[Other investment additional planend places]])","v":0},null,null,{"$f":"SUM(G18:H18,L18:M18)","v":0}]
[]
[]
[null,"Consultation form\nConsultation for all projects: list the groups that the local authority has consulted with and the date of the conversation.\nLocal authorities are required to consult with parents and carers and should consult with other groups about how they plan to use their funding and set out information in the box below before they will receive their allocation."]
[null,"Group",null,"Date and method of discussion i.e. meeting or online consultation",null,"Topic(s) of discussion",null,null,null,null,null,null,null,null,"Outcome including any changes as a result of the consultation"]

{"sheet":"Plan output","index":2,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,9],[29,1,30,9],[8,1,9,1],[5,1,6,1],[11,1,11,9],[5,2,6,5],[8,2,9,5],[2,1,3,4]]}
[null,{"$f":"'Input form'!E4","v":"SELECT LOCAL AUTHORITY"}]
[]
[null,"Special provision fund capital plan",null,null,null,null,"Total planned investment in additional places",{"$f":"H6+H9","v":0},"Total planned investment to improve existing schools' facilities",{"$f":"J6+J9","v":0}]
[null,null,null,null,null,null,"Total planned number of additional places",{"$f":"H7+H10","v":0},"Total planned number of improvement projects",{"$f":"J7+J10","v":0}]
[]
[null,"Special provision fund allocation",{"$f":"'Input form'!E6","v":0},null,null,null,"£s investment for planned additional places",{"$f":"SUM(InputForm[Special provision fund investment in additional places])","v":0},"£s investment in facilities",{"$f":"SUM(InputForm[Special provision fund investment in facilities])","v":0}]
[null,null,null,null,null,null,"No. of additional places planned",{"$f":"SUM(InputForm[Special provision fund additional planned places])","v":0},"No. of facilities improvement projects",{"$f":"COUNTIFS(InputForm[Special provision fund investment in facilities],\">0\")","v":0}]
[]
[null,"Other funding\n other than the SEND capital allocation (where applicable)",{"$f":"'Input form'!E7","v":0},null,null,null,"£s investment for planned additional places",{"$f":"SUM(InputForm[Other investment in additional places])","v":0},"£s investment in facilities ",{"$f":"SUM(InputForm[Other investment in facilities])","v":0}]
[null,null,null,null,null,null,"No. of additional places planned",{"$f":"SUM(InputForm[Other investment additional planend places])","v":0},"No. of facilities improvement projects",{"$f":"COUNTIFS(InputForm[Other investment in facilities],\">0\")","v":0}]
[]
[null,"More information about investment in provision for pupils with education, health and care (EHC) plans up until 2021"]

{"sheet":"Do not change - workings","index":3,"n_rows":159,"n_cols":28,"rows_kept":159,"cut":false,"hidden":false,"merged":[[0,18,0,21],[1,5,1,8],[1,16,1,21],[2,16,2,21],[3,16,3,21],[19,2,19,3],[8,2,8,3],[4,5,4,7],[5,5,5,7],[8,7,8,8],[19,7,19,8],[19,4,19,6],[8,4,8,6]]}
[null,"Spreadsheet workings",null,null,null,null,null,null,null,null,null,"Provision",null,null,null,null,null,"Allocations ","Copied from https://www.gov.uk/government/publications/send-provision-capital-funding-for-pupils-with-ehc-plans at 20 March 2017"]
[null,"Local authority:",null,null,null,{"$f":"'Input form'!E4","v":"SELECT LOCAL AUTHORITY"},null,null,null,null,null,null,null,null,null,null," Special provision fund: Allocation for local authorities from 2018/19 to 2020/21"]
[null,{"$f":"F2","v":"SELECT LOCAL AUTHORITY"},null,null,null,null,null,null,null,null,null,"Spreadsheet workings: Codes",null,null,null,null,"Published March 2017"]
[null,null,null,null,null,null,null,null,null,null,null,"Lists of categories",null,null,null,null,"Published March 2017\nUpdated January 2019",null,null,null,null,null,null,null,null,null,null,"Consultation"]
[null,"Local authority's special provision fund allocation",null,null,null,{"$f":"INDEX(V:V,MATCH(F2,R:R, 0))","v":0},null,null,null,null,null,"Groups to select from","Sub-groups",null,"Ofsted inspection judgment",null,"LA Number","Local Authority name"," 2018/19","2019/20"," 2020/21","LAs total allocation","£50m top-up announced May 2018","£100m top-up announced December 2018","New total allocation",null,null,"The local authority has consulted parents and carers"]
[null,"Other investment the local authority plans to make in SEND capital",null,null,null,{"$f":"SUM('Input form'!H14:H18)+SUM('Input form'!M14:M18)","v":0},null,null,null,null,null,"Provision category","Provision type",null,"Outstanding",null,null,null,null,null,null,null,null,null,null,null,null,"The local authority is or will be consulting parents and carers and will republish this plan before receiving their allocation"]
[null,null,null,null,null,null,null,null,null,null,null,"Alternative provision/PRU","Academy (or free school) Alternative provision",null,"Good",null,null,"Totals",71666666.666666612,71666666.666666612,71666666.666666612,215000000.00000003,{"$f":"V7*(50/215)","v":50000000.000000007},100000000,365000000,null,null,"Confirm either that the LA has or will be consulting parents and carers"]
[null,"Investment by quality",null,null,null,null,null,null,null,null,null,null,"Pupil referral unit (LA maintained)",null,"Requires Improvement",null,null,"SELECT LOCAL AUTHORITY"]
[null,null,"Investment in new places",null,"Investment in facilities improvements",null,null,"No. of places created from:",null,"Places",null,"Independent and non-maintained","Independent school",null,"Inadequate",null,301,"Barking and Dagenham",945715.60472154047,945715.60472154047,945715.60472154047,2837146.8141646213,{"$f":"V9*(50/215)","v":659801.58468944684},{"$f":"V9*(100/215)","v":1319603.1693788937},{"$f":"V9+W9+X9","v":4816551.5682329619},null,null,"Limits set on cells"]
[null,"Quality (Ofsted rating)","Special provision fund","Other investment","Special provision fund","Other investment","Total investment","Special provision fund","Other investment","Total no. new places planned",null,null,"Non-Maintained Special School",null,"Not yet inspected",null,302,"Barnet",1001778.2807387415,1001778.2807387415,1001778.2807387415,3005334.8422162244,{"$f":"V10*(50/215)","v":698915.07958516851},{"$f":"V10*(100/215)","v":1397830.159170337},{"$f":"V10+W10+X10","v":5102080.0809717299},null,null,"Input form, project information form: rows I and J have an entry limit of 200 places "]
[null,"outstanding",{"$f":"SUMIF(InputForm[Ofsted Judgement],$B11,InputForm[Special provision fund investment in additional places])","v":0},{"$f":"SUMIF(InputForm[Ofsted Judgement],$B11,InputForm[Other investment in additional places])","v":0},{"$f":"SUMIF(InputForm[Ofsted Judgement],$B11,InputForm[Special provision fund investment in facilities])","v":0},{"$f":"SUMIF(InputForm[Ofsted Judgement],$B11,InputForm[Other investment in facilities])","v":0},{"$f":"SUM(E11:F11)","v":0},{"$f":"SUMIF(InputForm[Ofsted Judgement],$B11,InputForm[Special provision fund additional planned places])","v":0},{"$f":"SUMIF(InputForm[Ofsted Judgement],$B11,InputForm[Other investment additional planend places])","v":0},{"$f":"SUM(H11:I11)","v":0},null,null,"Other independent special school",null,"Not inspected by Ofsted",null,370,"Barnsley",260425.45359040017,260425.45359040017,260425.45359040017,781276.3607712005,181692.17692353501,363384.35384707002,1326352.8915418056,null,null,"Input form, project information form: row L has an expenditure limit of the selected special provision fund allocation i.e. the LA cannot invest more special provision fund money that it will receive"]
[null,"good",{"$f":"SUMIF(InputForm[Ofsted Judgement],$B12,InputForm[Special provision fund investment in additional places])","v":0},{"$f":"SUMIF(InputForm[Ofsted Judgement],$B12,InputForm[Other investment in additional places])","v":0},{"$f":"SUMIF(InputForm[Ofsted Judgement],$B12,InputForm[Special provision fund investment in facilities])","v":0},{"$f":"SUMIF(InputForm[Ofsted Judgement],$B12,InputForm[Other investment in facilities])","v":0},0,{"$f":"SUMIF(InputForm[Ofsted Judgement],$B12,InputForm[Special provision fund additional planned places])","v":0},{"$f":"SUMIF(InputForm[Ofsted Judgement],$B12,InputForm[Other investment additional planend places])","v":0},{"$f":"SUM(H12:I12)","v":0},null,"Mainstream provision (not unit)","Academy (or free school) 16-19 (mainstream)",null,null,null,800,"Bath and North East Somerset",192331.3817330109,192331.3817330109,192331.3817330109,576994.14519903273,134184.68493000761,268369.36986001523,979548.19998905563,null,null,"Input form, project information form: row J has an expenditure limit of the entered figure for other investment i.e. the LA cannot type that they will invest more in one project than the total sum of their expenditure"]
[null,"requires improvement",{"$f":"SUMIF(InputForm[Ofsted Judgement],$B13,InputForm[Special provision fund investment in additional places])","v":0},{"$f":"SUMIF(InputForm[Ofsted Judgement],$B13,InputForm[Other investment in additional places])","v":0},{"$f":"SUMIF(InputForm[Ofsted Judgement],$B13,InputForm[Special provision fund investment in facilities])","v":0},{"$f":"SUMIF(InputForm[Ofsted Judgement],$B13,InputForm[Other investment in facilities])","v":0},0,{"$f":"SUMIF(InputForm[Ofsted Judgement],$B13,InputForm[Special provision fund additional planned places])","v":0},{"$f":"SUMIF(InputForm[Ofsted Judgement],$B13,InputForm[Other investment additional planend places])","v":0},0,null,null,"Academy or free school (mainstream)",null,null,null,822,"Bedford",309620.24264860078,309620.24264860078,309620.24264860078,928860.72794580227,216014.12277809356,432028.24555618712,1576903.0962800828,null,null,"Input form, L7: Conditional formatting if rows  "]
[null,"inadequate",{"$f":"SUMIF(InputForm[Ofsted Judgement],$B14,InputForm[Special provision fund investment in additional places])","v":0},{"$f":"SUMIF(InputForm[Ofsted Judgement],$B14,InputForm[Other investment in additional places])","v":0},{"$f":"SUMIF(InputForm[Ofsted Judgement],$B14,InputForm[Special provision fund investment in facilities])","v":0},{"$f":"SUMIF(InputForm[Ofsted Judgement],$B14,InputForm[Other investment in facilities])","v":0},0,{"$f":"SUMIF(InputForm[Ofsted Judgement],$B14,InputForm[Special provision fund additional planned places])","v":0},{"$f":"SUMIF(InputForm[Ofsted Judgement],$B14,InputForm[Other investment additional planend places])","v":0},0,null,null,"Maintained school (including community, foundation school)",null,null,null,303,"Bexley",684008.23847433401,684008.23847433401,684008.23847433401,2052024.7154230019,477215.05009837251,954430.10019674501,3483669.8657181198,null,null,"Input form, project information form: Word limits of 200 characters to row O"]
[null,"not yet inspected",{"$f":"SUMIF(InputForm[Ofsted Judgement],$B15,InputForm[Special provision fund investment in additional places])","v":0},{"$f":"SUMIF(InputForm[Ofsted Judgement],$B15,InputForm[Other investment in additional places])","v":0},{"$f":"SUMIF(InputForm[Ofsted Judgement],$B15,InputForm[Special provision fund investment in facilities])","v":0},{"$f":"SUMIF(InputForm[Ofsted Judgement],$B15,InputForm[Other investment in facilities])","v":0},0,{"$f":"SUMIF(InputForm[Ofsted Judgement],$B15,InputForm[Special provision fund additional planned places])","v":0},{"$f":"SUMIF(InputForm[Ofsted Judgement],$B15,InputForm[Other investment additional planend places])","v":0},0,null,null,"LA nursery school",null,null,null,330,"Birmingham",1423958.4906547957,1423958.4906547957,1423958.4906547957,4271875.4719643872,993459.41208474117,1986918.8241694823,7252253.7082186108,null,null,"Input form, project information form: Word limits of 600 characters to row P"]
[null,"not inspected by Ofsted",{"$f":"SUMIF(InputForm[Ofsted Judgement],$B16,InputForm[Special provision fund investment in additional places])","v":0},{"$f":"SUMIF(InputForm[Ofsted Judgement],$B16,InputForm[Other investment in additional places])","v":0},{"$f":"SUMIF(InputForm[Ofsted Judgement],$B16,InputForm[Special provision fund investment in facilities])","v":0},{"$f":"SUMIF(InputForm[Ofsted Judgement],$B16,InputForm[Other investment in facilities])","v":0},0,{"$f":"SUMIF(InputForm[Ofsted Judgement],$B16,InputForm[Special provision fund additional planned places])","v":0},{"$f":"SUMIF(InputForm[Ofsted Judgement],$B16,InputForm[Other investment additional planend places])","v":0},0,null,null,"Studio school",null,null,null,889,"Blackburn with Darwen",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255,null,null,"Input form, consultation form: Word limits of 200 characters to row B"]
[null,"Total",{"$f":"SUM(C11:C16)","v":0},0,0,0,0,0,0,0,null,null,"University technical college",null,null,null,890,"Blackpool",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255,null,null,"Input form, consultation form: Word limits of 200 characters to row D"]
[null,null,null,null,null,null,null,null,null,null,null,"Special provision","Academy (or free school) special",null,null,null,350,"Bolton",275943.48410222004,275943.48410222004,275943.48410222004,827830.45230666013,192518.70983875816,385037.41967751633,1405386.5818229346,null,null,"Input form, consultation form: Word limits of 600 characters to row F"]
[null,"Investment by provision type",null,null,null,null,null,null,null,null,null,null,"Maintained special school (including community and foundations schools)",null,null,null,837,"Bournemouth",317883.4213599193,317883.4213599193,317883.4213599193,953650.26407975785,221779.13118133903,443558.26236267807,1618987.6576237748,null,null,"Input form, consultation form: Word limits of 600 characters to row N"]
[null,null,"Investment in new places",null,"Investment in facilities improvements",null,null,"No. of places created from:",null,"Places",null,"Special unit or resourced provision","Special unit/ resourced provision at academy",null,null,null,867,"Bracknell Forest",250926.93217750743,250926.93217750743,250926.93217750743,752780.7965325223,175065.30151919124,350130.60303838248,1277976.701090096]
[null,"Provision type","Special provision fund","Other investment","Special provision fund","Other investment","Total investment","Special provision fund","Other investment","Total no. new places planned",null,null,"Special unit/ resourced provision at free school",null,null,null,380,"Bradford",219322.25216727532,219322.25216727532,219322.25216727532,657966.75650182599,153015.5247678665,306031.04953573301,1117013.3308054255]
[null,{"$f":"L30","v":"Alternative provision/PRU"},{"$f":"SUMIF(InputForm[Provision category],$B22,InputForm[Special provision fund investment in additional places])","v":0},{"$f":"SUMIF(InputForm[Provision category],$B22,InputForm[Other investment in additional places])","v":0},{"$f":"SUMIF(InputForm[Provision category],$B22,InputForm[Special provision fund investment in facilities])","v":0},{"$f":"SUMIF(InputForm[Provision category],$B22,InputForm[Other investment in facilities])","v":0},{"$f":"SUM(E22:F22)","v":0},{"$f":"SUMIF(InputForm[Provision category],$B22,InputForm[Special provision fund additional planned places])","v":0},{"$f":"SUMIF(InputForm[Provision category],$B22,InputForm[Other investment additional planend places])","v":0},{"$f":"SUM(H22:I22)","v":0},null,null,"Special unit/ resourced provision at other school",null,null,null,304,"Brent",569221.97753068351,569221.97753068351,569221.97753068351,1707665.9325920504,397131.6122307094,794263.22446141881,2899060.7692841785]
[null,"Independent and non-maintained",{"$f":"SUMIF(InputForm[Provision category],$B23,InputForm[Special provision fund investment in additional places])","v":0},{"$f":"SUMIF(InputForm[Provision category],$B23,InputForm[Other investment in additional places])","v":0},{"$f":"SUMIF(InputForm[Provision category],$B23,InputForm[Special provision fund investment in facilities])","v":0},{"$f":"SUMIF(InputForm[Provision category],$B23,InputForm[Other investment in facilities])","v":0},0,{"$f":"SUMIF(InputForm[Provision category],$B23,InputForm[Special provision fund additional planned places])","v":0},{"$f":"SUMIF(InputForm[Provision category],$B23,InputForm[Other investment additional planend places])","v":0},0,null,"Other","Other school",null,null,null,846,"Brighton and Hove",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,"Mainstream provision (not unit)",{"$f":"SUMIF(InputForm[Provision category],$B24,InputForm[Special provision fund investment in additional places])","v":0},{"$f":"SUMIF(InputForm[Provision category],$B24,InputForm[Other investment in additional places])","v":0},{"$f":"SUMIF(InputForm[Provision category],$B24,InputForm[Special provision fund investment in facilities])","v":0},{"$f":"SUMIF(InputForm[Provision category],$B24,InputForm[Other investment in facilities])","v":0},0,{"$f":"SUMIF(InputForm[Provision category],$B24,InputForm[Special provision fund additional planned places])","v":0},{"$f":"SUMIF(InputForm[Provision category],$B24,InputForm[Other investment additional planend places])","v":0},0,null,null,"Other nursery or early years provision",null,null,null,801,"Bristol, City of",840521.73342280777,840521.73342280777,840521.73342280777,2521565.2002684232,586410.51169033092,1172821.0233806618,4280796.7353394162]
[null,"Special provision",{"$f":"SUMIF(InputForm[Provision category],$B25,InputForm[Special provision fund investment in additional places])","v":0},{"$f":"SUMIF(InputForm[Provision category],$B25,InputForm[Other investment in additional places])","v":0},{"$f":"SUMIF(InputForm[Provision category],$B25,InputForm[Special provision fund investment in facilities])","v":0},{"$f":"SUMIF(InputForm[Provision category],$B25,InputForm[Other investment in facilities])","v":0},0,{"$f":"SUMIF(InputForm[Provision category],$B25,InputForm[Special provision fund additional planned places])","v":0},{"$f":"SUMIF(InputForm[Provision category],$B25,InputForm[Other investment additional planend places])","v":0},0,null,null,"Other sixth-form or FE college",null,null,null,305,"Bromley",865509.85486149474,865509.85486149474,865509.85486149474,2596529.5645844843,603844.08478708938,1207688.1695741788,4408061.8189457525]
[null,"Special unit or resourced provision",{"$f":"SUMIF(InputForm[Provision category],$B26,InputForm[Special provision fund investment in additional places])","v":0},{"$f":"SUMIF(InputForm[Provision category],$B26,InputForm[Other investment in additional places])","v":0},{"$f":"SUMIF(InputForm[Provision category],$B26,InputForm[Special provision fund investment in facilities])","v":0},{"$f":"SUMIF(InputForm[Provision category],$B26,InputForm[Other investment in facilities])","v":0},0,{"$f":"SUMIF(InputForm[Provision category],$B26,InputForm[Special provision fund additional planned places])","v":0},{"$f":"SUMIF(InputForm[Provision category],$B26,InputForm[Other investment additional planend places])","v":0},0,null,null,null,null,null,null,825,"Buckinghamshire",824492.3526082515,824492.3526082515,824492.3526082515,2473477.0578247546,575227.22274994291,1150454.4454998858,4199158.7260745838]
[null,"Other",{"$f":"SUMIF(InputForm[Provision category],$B27,InputForm[Special provision fund investment in additional places])","v":0},{"$f":"SUMIF(InputForm[Provision category],$B27,InputForm[Other investment in additional places])","v":0},{"$f":"SUMIF(InputForm[Provision category],$B27,InputForm[Special provision fund investment in facilities])","v":0},{"$f":"SUMIF(InputForm[Provision category],$B27,InputForm[Other investment in facilities])","v":0},0,{"$f":"SUMIF(InputForm[Provision category],$B27,InputForm[Special provision fund additional planned places])","v":0},{"$f":"SUMIF(InputForm[Provision category],$B27,InputForm[Other investment additional planend places])","v":0},0,null,null,null,null,null,null,351,"Bury",194899.46392859714,194899.46392859714,194899.46392859714,584698.39178579138,135976.37018274219,271952.74036548438,992627.50233401789]
[null,"Total",{"$f":"SUM(C22:C27)","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,381,"Calderdale",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,"Provision category",null,null,null,null,873,"Cambridgeshire",832763.4242496182,832763.4242496182,832763.4242496182,2498290.2727488545,580997.7378485708,1161995.4756971416,4241283.4862945676]
[null,null,null,null,null,null,null,null,null,null,null,"Alternative provision/PRU",null,null,null,null,202,"Camden",437500.27595702303,437500.27595702297,437500.27595702297,1312500.8278710688,305232.75066769042,610465.50133538083,2228199.0798741402]
[null,null,null,null,null,null,null,null,null,null,null,"Independent and non-maintained",null,null,null,null,823,"Central Bedfordshire",549726.91843168635,549726.91843168635,549726.91843168635,1649180.7552950589,383530.40820815321,767060.81641630642,2799771.9799195183]
[null,null,null,null,null,null,null,null,null,null,null,"Mainstream provision (not unit)",null,null,null,null,895,"Cheshire East",197896.64242186284,197896.64242186284,197896.64242186284,593689.92726558854,138067.42494548572,276134.84989097144,1007892.2021020456]
[null,null,null,null,null,null,null,null,null,null,null,"Special provision",null,null,null,null,896,"Cheshire West and Chester",180458.82300225794,180458.82300225794,180458.82300225794,541376.46900677378,125901.50442017995,251803.00884035989,919080.98226731364]
[null,null,null,null,null,null,null,null,null,null,null,"Special unit or resourced provision",null,null,null,null,908,"Cornwall",637771.80633185047,637771.80633185047,637771.80633185047,1913315.4189955513,444957.07418501191,889914.14837002382,3248186.641550587]
[null,null,null,null,null,null,null,null,null,null,null,"Other",null,null,null,null,840,"County Durham",430929.70913124701,430929.70913124667,430929.70913124667,1292789.12739374,300648.63427761395,601297.2685552279,2194735.0302265817]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,331,"Coventry",775574.390604952,775574.390604952,775574.390604952,2326723.1718148561,541098.41204996652,1082196.824099933,3950018.4079647558]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,306,"Croydon",968854.59185642342,968854.59185642342,968854.59185642342,2906563.7755692704,675945.0640858768,1351890.1281717536,4934398.967826901]
[null,null,null,null,null,null,null,null,null,null,null,"Age range",null,null,null,null,909,"Cumbria",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,"Under 5s",null,null,null,null,841,"Darlington",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,"Primary",null,null,null,null,831,"Derby",275162.23043247027,275162.23043247027,275162.23043247027,825486.69129741087,191973.64913893276,383947.29827786551,1401407.6387142092]
[null,null,null,null,null,null,null,null,null,null,null,"Secondary",null,null,null,null,830,"Derbyshire",427606.30559044698,427606.30559044698,427606.30559044698,1282818.9167713409,298329.9806444979,596659.96128899581,2177808.8587048342]
[null,null,null,null,null,null,null,null,null,null,null,"Primary and secondary",null,null,null,null,878,"Devon",749284.51391679223,749284.51391679223,749284.51391679223,2247853.5417503766,522756.63761636661,1045513.2752327332,3816123.4545994764]
[null,null,null,null,null,null,null,null,null,null,null,"Post-16",null,null,null,null,371,"Doncaster",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,"Secondary and post-16",null,null,null,null,835,"Dorset",338317.61126210442,338317.61126210442,338317.61126210442,1014952.8337863133,236035.5427410031,472071.08548200619,1723059.4620093226]
[null,null,null,null,null,null,null,null,null,null,null,"Primary, secondary and post-16",null,null,null,null,332,"Dudley",243843.36381614945,243843.36381614945,243843.36381614945,731530.09144844837,170123.2770810345,340246.55416206899,1241899.922691552]
[null,null,null,null,null,null,null,null,null,null,null,"Other category in 0-25 age-range (please specify in project description)",null,null,null,null,307,"Ealing",480478.43837408518,480478.43837408518,480478.43837408518,1441435.3151222556,335217.5151447106,670435.03028942121,2447087.8605563873]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,811,"East Riding of Yorkshire",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,845,"East Sussex",603659.26686731819,603659.26686731819,603659.26686731819,1810977.8006019546,421157.62804696616,842315.25609393232,3074450.684742853]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,308,"Enfield",851655.2218305649,851655.2218305649,851655.2218305649,2554965.6654916946,594178.06174225453,1188356.1234845091,4337499.8507184582]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,881,"Essex",1916012.569778475,1916012.569778475,1916012.569778475,5748037.7093354249,1336752.9556594011,2673505.9113188023,9758296.5763136297]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,390,"Gateshead",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,916,"Gloucestershire",650092.02151397744,650092.02151397744,650092.02151397744,1950276.0645419322,453552.57314928656,907105.14629857312,3310933.7839897918]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,203,"Greenwich",680999.36977144785,680999.36977144785,680999.36977144785,2042998.1093143434,475115.83937542868,950231.67875085736,3468345.6274406295]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,204,"Hackney",662722.26446519722,662722.26446519722,662722.26446519722,1988166.7933955917,462364.37055711431,924728.74111422861,3375259.9050669344]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,876,"Halton",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,205,"Hammersmith and Fulham",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,850,"Hampshire",1262401.2299313999,1262401.2299313999,1262401.2299313999,3787203.6897942,880745.04413818603,1761490.0882763721,6429438.8222087584]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,309,"Haringey",212735.07293834651,212735.07293834651,212735.07293834651,638205.21881503949,148419.81832907896,296839.63665815792,1083464.6738022764]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,310,"Harrow",620575.77854975953,620575.77854975953,620575.77854975953,1861727.3356492787,432959.84549983224,865919.69099966448,3160606.8721487755]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,805,"Hartlepool",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,311,"Havering",857386.04502053966,857386.04502053966,857386.04502053966,2572158.1350616189,598176.3104794462,1196352.6209588924,4366687.0664999578]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,884,"Herefordshire",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,919,"Hertfordshire",2197224.5652328874,2197224.5652328874,2197224.5652328874,6591673.6956986627,1532947.3710927123,3065894.7421854245,11190515.808976799]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,312,"Hillingdon",971963.84662063641,971963.84662063641,971963.84662063641,2915891.5398619091,678114.31159579277,1356228.6231915855,4950234.4746492878]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,313,"Hounslow",721492.93639958545,721492.93639958545,721492.93639958545,2164478.8091987562,503367.16492994328,1006734.3298598866,3674580.3039885862]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,921,"Isle of Wight",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,206,"Islington",442448.54450590885,442448.54450590885,442448.54450590885,1327345.6335177266,308685.0310506341,617370.06210126821,2253400.7266696291]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,207,"Kensington and Chelsea",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,886,"Kent",2192654.5012811548,2192654.5012811548,2192654.5012811548,6577963.5038434649,1529758.9543822012,3059517.9087644024,11167240.366990067]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,810,"Kingston upon Hull, City of",233138.95317370704,233138.95317370704,233138.95317370704,699416.85952112114,162655.08360956307,325310.16721912613,1187382.1103498102]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,314,"Kingston upon Thames",562816.03546884097,562816.03546884097,562816.03546884097,1688448.1064065229,392662.35032709833,785324.70065419667,2866435.1573878177]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,382,"Kirklees",352244.08311450761,352244.08311450761,352244.08311450761,1056732.2493435228,245751.68589384251,491503.37178768503,1793987.3070250503]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,340,"Knowsley",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,208,"Lambeth",393908.82231131243,393908.82231131243,393908.82231131243,1181726.4669339373,{"$f":"V74*(50/215)","v":274820.10858928773},{"$f":"V74*(100/215)","v":549640.21717857546},{"$f":"V74+W74+X74","v":2006186.7927018006}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,888,"Lancashire",683199.66811310896,683199.66811310896,683199.66811310896,2049599.0043393269,476650.93124170392,953301.86248340784,3479551.7980644386]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,383,"Leeds",1079028.7296684366,1079028.7296684366,1079028.7296684366,3237086.1890053097,752810.74162914173,1505621.4832582835,5495518.4138927348]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,856,"Leicester",524722.9814811101,524722.9814811101,524722.9814811101,1574168.9444433302,366085.80103333259,732171.60206666519,2672426.3475433281]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,855,"Leicestershire",709069.46820083179,709069.46820083179,709069.46820083179,2127208.4046024955,494699.62897732452,989399.25795464905,3611307.291534469]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,209,"Lewisham",773332.77437750588,773332.77437750588,773332.77437750588,2319998.3231325177,539534.49375174835,1079068.9875034967,3938601.8043877631]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,925,"Lincolnshire",771411.50473455375,771411.50473455375,771411.50473455375,2314234.5142036611,538194.07307061891,1076388.1461412378,3928816.733415518]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,341,"Liverpool",514481.82597333984,514481.82597333984,514481.82597333984,1543445.4779200195,358940.80881860916,717881.61763721833,2620267.904375847]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,821,"Luton",429455.26939659083,429455.26939659083,429455.26939659083,1288365.8081897725,299619.95539297035,599239.91078594071,2187225.6743686832]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,352,"Manchester",831145.09745642741,831145.09745642741,831145.09745642741,2493435.2923692823,579868.67264401913,1159737.3452880383,4233041.3103013393]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,887,"Medway",459324.74831593951,459324.74831593951,459324.74831593951,1377974.2449478186,320459.12673205085,640918.2534641017,2339351.6251439713]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,315,"Merton",491430.24113176554,491430.24113176554,491430.24113176554,1474290.7233952966,342858.30776634807,685716.61553269613,2502865.6466943407]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,806,"Middlesbrough",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,826,"Milton Keynes",635366.08053993958,635366.08053993958,635366.08053993958,1906098.2416198188,443278.66084181832,886557.32168363663,3235934.2241452737]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,391,"Newcastle upon Tyne",314415.23379459424,314415.23379459424,314415.23379459424,943245.70138378278,219359.46543808901,438718.93087617803,1601324.0976980499]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,316,"Newham",746759.71218340471,746759.71218340471,746759.71218340471,2240279.1365502141,520995.14803493349,1041990.296069867,3803264.5806550146]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,926,"Norfolk",908832.44109883357,908832.44109883357,908832.44109883357,2726497.3232965008,634069.14495267463,1268138.2899053493,4628704.7581545245]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,812,"North East Lincolnshire",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,813,"North Lincolnshire",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,802,"North Somerset",260161.27486787803,260161.27486787803,260161.27486787803,780483.82460363407,181507.86618689165,363015.73237378331,1325007.423164309]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,392,"North Tyneside",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,815,"North Yorkshire",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,928,"Northamptonshire",940580.94886404148,940580.94886404148,940580.94886404148,2821742.8465921246,656219.26664933132,1312438.5332986626,4790400.6465401184]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,929,"Northumberland",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,892,"Nottingham",419658.03051090339,419658.03051090339,419658.03051090339,1258974.0915327102,292784.67244946747,585569.34489893494,2137328.1088811127]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,891,"Nottinghamshire",848600.778359944,848600.778359944,848600.778359944,2545802.335079832,592047.05466972839,1184094.1093394568,4321943.4990890175]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,353,"Oldham",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,931,"Oxfordshire",818155.26565868838,818155.26565868838,818155.26565868838,2454465.7969760653,570805.99929675937,1141611.9985935187,4166883.794866343]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,874,"Peterborough",368245.1242515787,368245.1242515787,368245.1242515787,1104735.3727547361,256915.20296621771,513830.40593243542,1875480.9816533891]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,879,"Plymouth",254566.53105523391,254566.53105523391,254566.53105523391,763699.59316570172,177604.55655016319,355209.11310032639,1296513.2628161912]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,836,"Poole",167549.31228494088,167549.31228494088,167549.31228494088,502647.93685482268,116894.86903600527,233789.73807201054,853332.54396283848]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,851,"Portsmouth",256869.44304729925,256869.44304729925,256869.44304729925,770608.32914189773,179211.23933532505,358422.4786706501,1308242.0471478729]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,870,"Reading",273709.80898896069,273709.80898896069,273709.80898896069,821129.42696688208,190960.33185276328,381920.66370552656,1394010.4225251719]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,317,"Redbridge",984636.00419949042,984636.00419949042,984636.00419949042,2953908.0125984713,686955.35176708631,1373910.7035341726,5014774.0678997301]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,807,"Redcar and Cleveland",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,318,"Richmond upon Thames",531957.0436856189,531957.0436856189,531957.0436856189,1595871.1310568566,371132.82117601315,742265.64235202631,2709269.5945848962]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,354,"Rochdale",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,372,"Rotherham",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,857,"Rutland",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,355,"Salford",421362.9905046674,421362.9905046674,421362.9905046674,1264088.9715140022,293974.17942186096,587948.35884372192,2146011.5097795851]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,333,"Sandwell",521462.0171512512,521462.0171512512,521462.0171512512,1564386.0514537536,363810.70964040782,727621.41928081564,2655818.1803749772]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,343,"Sefton",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,373,"Sheffield",496094.41052959074,496094.41052959074,496094.41052959074,1488283.2315887723,346112.37943924934,692224.75887849869,2526620.3699065205]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,893,"Shropshire",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,871,"Slough",342268.4925494162,342268.4925494162,342268.4925494162,1026805.4776482487,238791.97154610432,477583.94309220865,1743181.3922865617]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,334,"Solihull",278493.56396802835,278493.56396802835,278493.56396802835,835480.69190408499,194297.83532653138,388595.67065306276,1418374.1978836791]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,933,"Somerset",572131.26447645517,572131.26447645517,572131.26447645517,1716393.7934293656,399161.34730915481,798322.69461830962,2913877.8353568297]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,803,"South Gloucestershire",398353.86884842877,398353.86884842877,398353.86884842877,1195061.6065452863,277921.30384774099,555842.60769548197,2028825.5180885091]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,393,"South Tyneside",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,852,"Southampton",408457.43644517241,408457.43644517241,408457.43644517241,1225372.3093355172,284970.3044966319,569940.6089932638,2080283.2228254131]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,882,"Southend-on-Sea",230167.40307436266,230167.40307436266,230167.40307436266,690502.20922308799,160581.90912164838,321163.81824329676,1172247.9365880331]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,210,"Southwark",549624.97194605682,549624.97194605682,549624.97194605682,1648874.9158381703,383459.28275306284,766918.56550612568,2799252.764097359]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,342,"St Helens",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,860,"Staffordshire",311412.45853008016,311412.45853008016,311412.45853008016,934237.37559024047,217264.50595121871,434529.01190243743,1586030.8934438964]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,356,"Stockport",321930.7969139716,321930.7969139716,321930.7969139716,965792.39074191474,224602.88156788715,449205.76313577429,1639601.0354455763]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,808,"Stockton-on-Tees",206434.50770107191,206434.50770107191,206434.50770107191,619303.52310321573,144024.07514028272,288048.15028056543,1051375.748524064]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,861,"Stoke-on-Trent",226043.86695362497,226043.86695362497,226043.86695362497,678131.60086087487,157705.0234560174,315410.0469120348,1151246.6712289271]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,935,"Suffolk",461375.76853694516,461375.76853694516,461375.76853694516,1384127.3056108356,321890.07107228733,643780.14214457467,2349797.5188276977]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,394,"Sunderland",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,936,"Surrey",1976696.4331022769,1976696.4331022769,1976696.4331022769,5930089.2993068304,1379090.5347225186,2758181.0694450373,10067360.903474387]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,319,"Sutton",616523.93484488165,616523.93484488165,616523.93484488165,1849571.8045346451,430132.97779875464,860265.95559750928,3139970.7379309088]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,866,"Swindon",325873.18667615228,325873.18667615228,325873.18667615228,977619.56002845685,227353.38605312951,454706.77210625901,1659679.7181878453]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,357,"Tameside",211253.94117025426,211253.94117025426,211253.94117025426,633761.82351076277,147386.47058389831,294772.94116779661,1075921.2352624577]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,894,"Telford and Wrekin",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,883,"Thurrock",357094.39148735319,357094.39148735319,357094.39148735319,1071283.1744620595,{"$f":"V138*(50/215)","v":249135.6219679208},{"$f":"V138*(100/215)","v":498271.2439358416},{"$f":"V138+W138+X138","v":1818690.0403658219}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,880,"Torbay",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,211,"Tower Hamlets",1181119.8288207885,1181119.8288207885,1181119.8288207885,3543359.4864623658,824037.08987496875,1648074.1797499375,6015470.7560872724]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,358,"Trafford",344138.28857597336,344138.28857597336,344138.28857597336,1032414.8657279201,240096.48040184187,480192.96080368373,1752704.3069334459]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,384,"Wakefield",302487.56725259317,302487.56725259317,302487.56725259317,907462.70175777946,211037.83761808823,422075.67523617647,1540576.2146120442]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,335,"Walsall",319228.59050452575,319228.59050452575,319228.59050452575,957685.7715135772,222717.62128222725,445435.2425644545,1625838.6353602589]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,320,"Waltham Forest",518794.9388209763,518794.9388209763,518794.9388209763,1556384.8164629289,361949.95731696021,723899.91463392042,2642234.6884138095]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,212,"Wandsworth",634235.08797044738,634235.08797044738,634235.08797044738,1902705.2639113422,442489.5962584517,884979.19251690339,3230174.0526866973]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,877,"Warrington",173309.34431984843,173309.34431984843,173309.34431984843,519928.03295954532,120913.49603710356,241826.99207420711,882668.5210708559]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,937,"Warwickshire",424524.18404737831,424524.18404737831,424524.18404737831,1273572.5521421349,296179.66328886856,592359.32657773711,2162111.5420087404]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,869,"West Berkshire",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,938,"West Sussex",1085113.9007548222,1085113.9007548222,1085113.9007548222,3255341.7022644668,757056.20982894581,1514112.4196578916,5526510.3317513037]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,213,"Westminster",479801.35877904645,479801.35877904645,479801.35877904645,1439404.0763371394,334745.13403189287,669490.26806378574,2443639.4784328183]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,359,"Wigan",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,865,"Wiltshire",266977.56404370128,266977.56404370128,266977.56404370128,800932.69213110383,186263.41677467531,372526.83354935062,1359722.9424551297]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,868,"Windsor and Maidenhead",240923.87851533989,240923.87851533989,240923.87851533989,722771.63554601965,168086.42687116735,336172.8537423347,1227030.9161595218]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,344,"Wirral",166666.66666666666,166666.66666666666,166666.66666666666,500000,116279.06976744186,232558.13953488372,848837.2093023255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,872,"Wokingham",265760.37749045511,265760.37749045511,265760.37749045511,797281.13247136527,185414.21685380588,370828.43370761175,1353523.7830327828]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,336,"Wolverhampton",386190.26318667247,386190.26318667247,386190.26318667247,1158570.7895600174,269435.06733953895,538870.13467907789,1966875.9915786341]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,885,"Worcestershire",361888.16876409104,361888.16876409104,361888.16876409104,1085664.5062922731,252480.11774238909,504960.23548477818,1843104.8595194404]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,816,"York",196926.27162761139,196926.27162761139,196926.27162761139,590778.81488283421,137390.4220657754,274780.84413155081,1002950.0810801603]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,900,"Example LA",{"$f":"T159/3","v":36851.851851851854},{"$f":"U159/3","v":110555.55555555556},{"$f":"V159/3","v":331666.66666666669},995000]