{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Introduction and outcomes","Checklist","Dashboard","Optional - input raw data","RAG rating data for your school","RAG rating data for all schools","Calcs"],"not_rendered":{"macros":1,"external_links":4,"defined_names":97},"read":"whole","date_system":"1900"}

{"sheet":"Introduction and outcomes","index":0,"n_rows":21,"n_cols":15,"rows_kept":21,"merged":[[2,2,2,19],[4,2,4,19],[5,2,5,19],[6,2,6,19],[9,2,9,19],[11,2,11,19],[12,2,12,19],[14,2,14,10],[14,11,14,13],[14,14,14,18],[16,2,16,10],[16,11,16,13],[18,2,18,10],[18,11,18,13],[20,2,20,10],[20,11,20,13],[22,2,22,9]]}
[]
[]
[null,null,"Introduction to the schools financial value standard (SFVS)"]
[]
[null,null,"The schools financial value standard helps to provide schools with assurance that they are meeting the basic standards necessary to achieve a good level of financial health and resource management. \n\nThe tool can be used to identify possible areas for change to ensure that resources are being used to support high-quality teaching and the best education outcomes for pupils. The tool is in two parts:"]
[null,null,"1. A checklist, which asks a number of questions of governing bodies in six areas of resource management to provide assurance that the school is managing its resources effectively."]
[null,null,"2. A dashboard, which shows how a school's data compares to thresholds on a range of statistics that have been identified as indicators for good resource management and outcomes."]
[]
[]
[null,null,"Outcome of schools financial value standard (SFVS)"]
[]
[null,null,"Summary of agreed action and timetable for reporting back:"]
[]
[]
[null,null,"Signature:",{"$nulls":11},"Chair of governing body / management committee"]
[]
[null,null,"Full name of signatory:"]
[]
[null,null,"Date SFVS agreed by full governing body / managament committee"]
[]
[null,null,"Date SFVS submitted to local authority for review:"]

{"sheet":"Checklist","index":1,"n_rows":62,"n_cols":15,"rows_kept":62,"merged":[[2,2,2,20],[4,2,4,20],[5,2,5,20],[6,2,6,20],[8,2,9,6],[8,7,9,20],[10,2,10,6],[10,7,10,20],[12,14,12,20],[13,2,13,20],[15,3,15,9],[15,14,15,20],[16,3,16,9],[16,14,16,20],[17,3,17,9],[17,14,17,20],[18,3,18,9],[18,14,18,20],[19,3,19,9],[19,14,19,20],[21,2,21,20],[23,3,23,9],[23,14,23,20],[24,3,24,9],[24,14,24,20],[25,3,25,9],[25,14,25,20],[27,2,27,20],[29,3,29,9],[29,14,29,20],[30,3,30,9],[30,14,30,20],[31,3,31,9],[31,14,31,20],[32,3,32,9],[32,14,32,20],[33,3,33,9],[33,14,33,20],[35,2,35,20],[37,3,37,9],[37,14,37,20],[38,3,38,9],[38,14,38,20],[39,3,39,9],[39,14,39,20],[41,2,41,20],[43,3,43,9],[43,14,43,20],[44,3,44,9],[44,14,44,20],[45,3,45,9],[45,14,45,20],[46,3,46,9],[46,14,46,20],[47,3,47,9],[47,14,47,20],[48,3,48,9],[48,14,48,20],[50,2,50,20],[52,3,52,9],[52,14,52,20],[53,3,53,9],[53,14,53,20],[54,3,54,9],[54,14,54,20],[55,3,55,9],[55,14,55,20],[56,3,56,9],[56,14,56,20],[57,3,57,9],[57,14,57,20],[59,2,59,20],[61,3,61,9],[61,14,61,20],[63,2,63,9]]}
[]
[]
[null,null,"Schools financial value standard"]
[]
[null,null,"The checklist asks a number of questions of governing bodies in six areas of resource management to help provide assurance that resources are being managed effectively. \n\nThe completion of this assessment forms part of the schools financial value standard. Your return must be submitted to your local authority."]
[null,null,"Guidance on completion of this document can be found here. This guidance also includes examples of good practice and details further support available to assist governing bodies in addressing specific issues. Clicking on the individual questions below will also take you to the relevant section of the guidance."]
[null,null,"Schools should answer each question with 'yes', 'no', or 'in part' from the drop down lists provided. They should provide comments, evidence and proposed actions for questions as appropriate."]
[]
[null,null,"School name:",{"$nulls":4},"The Richmond School, Skegness"]
[]
[null,null,"School LAEstab number:",{"$nulls":4},"925/2219"]
[]
[{"$nulls":12},"Answer",null,"Comments, evidence and proposed actions"]
[null,null,"A. Governance"]
[]
[null,null,1,"In the view of the governing body and senior staff, does the governing body have adequate financial skills among its members to fulfil its role of challenge and support in the field of budget management and value for money?",{"$nulls":6},"Q1 guidance",null,"Yes",null,"The governing body has members experienced in budget management and is made up of skilled professionals. The governing body needs to ensure that any new governor has financial experience or is provided with the relevant training."]
[null,null,2,"Does the governing body have a finance committee (or equivalent) with clear terms of reference and a knowledgeable and experienced chair?",{"$nulls":6},"Q2 guidance",null,"Yes",null,"The governing body has an experienced Finance Committee with clear terms of reference. The chair is experienced."]
[null,null,3,"Does the governing body board receive clear and concise monitoring reports of the school's budget position at least six times a year?",{"$nulls":6},"Q3 guidance",null,"Yes",null,"Finance meetings are held six times per year with a  financial overview presented at the meetings of the full Governing Body."]
[null,null,4,"Are business interests of governing body members and staff properly registered and taken into account so as to avoid conflicts of interest?",{"$nulls":6},"Q4 guidance",null,"Yes",null,"All governors and staff complete a register of business interests. This is published on the school's website. It is an agenda item at every Full Governors' Meeting"]
[null,null,5,"Does the school have access to an adequate level of financial expertise, including when specialist finance staff are absent, e.g. on sick leave?",{"$nulls":6},"Q5 guidance",null,"Yes",null,"The School Bursar, School Administrator and Head Teacher have all received relevant training. Support is accessed regularly from the Helpdesk and from the school's involvement in the Gold Finance package."]
[]
[null,null,"B. School strategy"]
[]
[null,null,6,"Does the school have a realistic, sustainable and flexible financial strategy in place for at least the next 3 years, based on realistic assumptions about future funding, pupil numbers and pressures?",{"$nulls":6},"Q6 guidance",null,"Yes",null,"The financial strategy for the next three years is detailed as part of the five-year finance plan. This is worked on alongside LCC as part of the Gold Finance Package. Pupil numbers are now stable. Pressures of the Covid-19 pandemic have put a strain on some budget areas."]
[null,null,7,"Is the financial strategy integrated with the school’s strategy for raising standards and attainment?",{"$nulls":6},"Q7 guidance",null,"Yes",null,"The school is clear about its areas for development and the need for high quality teaching in order to raise standards and attainment. The SLT is currently working on detailed plans linked to the Catch-Up Funding."]
[null,null,8,"Does the school have an appropriate business continuity or disaster recovery plan, including an up-to-date asset register and adequate insurance?",{"$nulls":6},"Q8 guidance",null,"In part",null,"An up-to-date asset register is maintained through the use of Parago. Insurance is purchased in line with LCC guidance and through their relevant channels. The Disaster Recovery Plan is currently being update and will be ready to be agreed by the governing body at thier November meeting."]
[{"$nulls":12},{"$f":"IF(OR(ROUND(SUM(M21:M25),3)=100%,SUM(M21:M25)=0),\"\",\"Section must sum to 100%\")","v":""}]
[null,null,"C. Setting the annual budget"]
[]
[null,null,9,"Does the school set a well-informed and balanced budget each year (with an agreed and timed plan for eliminating any deficit)?",{"$nulls":6},"Q9 guidance",null,"Yes",null,"Through robust and rigorous budget monitoring, the budget deficit was eliminated during 2019-20 and £47,844 was carried forward into this financial year."]
[null,null,10,"Does the budget setting process allow sufficient time for the governing body to scrutinise and challenge the information provided?",{"$nulls":6},"Q10 guidance",null,"Yes",null,"Governors are provided with a detailed budget proposal and budget summary prior to the meeting at which the budget is to be ratified."]
[null,null,11,"Is the school realistic in its pupil number projections and can it move quickly to recast the budget if the projections and the reality are materially different?",{"$nulls":6},"Q11 guidance",null,"Yes",null,"Following the expected drop in pupil numbers at the end of the academic year 2019-20, pupil number projections are realistic. The school is oversubscribed for Foundation Stage pupils every year and has a waiting list for some other year groups."]
[null,null,12,"Is end year outturn in line with budget projections, or if not, is the governing body alerted to significant variations in a timely manner, and do such variations result from explicitly planned changes or from genuinely unforeseeable circumstances?",{"$nulls":6},"Q12 guidance",null,"Yes",null,"The budget outturn for 2019-20 was in line with budget projections. This was achieved through robust and rigourous monitoring and regular budget forecasting."]
[null,null,13,"Are balances at a reasonable level and does the school have a clear plan for using the money it plans to hold in balance at the end of each year?",{"$nulls":6},"Q13 guidance",null,"Yes",null,"Balances were at a reasonable level at the end of last financial year. There are plans in place to use the money, predominantly on staffing costs, due to increasing numbers of pupils with EHCPs"]
[{"$nulls":12},{"$f":"IF(OR(ROUND(SUM(M28:M34),3)=100%,SUM(M28:M34)=0),\"\",\"Section must sum to 100%\")","v":""}]
[null,null,"D. Staffing"]
[]
[null,null,14,"Does the school review and challenge its staffing structure regularly to ensure it is the best structure to meet the needs of the school whilst maintaining financial integrity? ",{"$nulls":6},"Q14 guidance",null,"Yes",null,"Whilst the main staffing structure remains stable, a reduction has taken place in the number of Teaching Assistants claiming extra hours for covering indivdual pupils at lunchtimes and for the delivery of imterventions. Non-teaching staff are only expected to work their contracted hours. The only exception to this is where staff claim for covering Breakfast Club and After-School Club, which are self-funding. The long-term plan is to give these staff contracted hours as Breakfast Club/After-School Club helpers."]
[null,null,15,"Has the use of professional independent advice informed part of the pay decision process in relation to the head teacher and is it tightly correlated to strong educational outcomes and sound financial management?",{"$nulls":6},"Q15 guidance",null,"Yes",null,"An independent Education Advisor is employed by the school to support governors with the Head teacher's Performnace Management."]
[null,null,16,"Does the school benchmark the size of its senior leadership team annually against that of similar schools?",{"$nulls":6},"Q16 guidance",null,"Yes",null,"As part of the staffing restructure, the governing body benchmarked the size of its senior leadership against similar schools."]
[{"$nulls":12},{"$f":"IF(OR(ROUND(SUM(M34:M39),3)=100%,SUM(M34:M39)=0),\"\",\"Section must sum to 100%\")","v":""}]
[null,null,"E. Value for money"]
[]
[null,null,17,"Does the school benchmark its income and expenditure annually against that of similar schools and investigate further where any category appears to be out of line?",{"$nulls":6},"Q17 guidance",null,"Yes",null,"Benchmarking takes place annually at a meeting of the Finance Committee"]
[null,null,18,"Does the school have procedures for purchasing goods and services that both meet legal requirements and secure value for money?",{"$nulls":6},"Q18 guidance",null,"Yes",null,"The school purchases goods and services from reputable companies. Three quotes are obtained for amounts over £10,000. Recently "]
[null,null,19,"Is the governing body given the opportunity to challenge the school’s plans for replacing contracts for goods and services that are due to expire shortly? ",{"$nulls":6},"Q19 guidance",null,"Yes",null,"Contracts which are due for expiry are always discussed at governors' Finance Meetings. Where the service provided is deemed to be insufficient further quotes are obtained and discussed."]
[null,null,20,"Does the School consider collaboration with others, e.g. on sharing staff or joint purchasing, where that would improve value for money?",{"$nulls":6},"Q20 guidance",null,"In part",null,"There have been no recent collaborations with schools re staffing or purchasing. The school and governing body continue to be open to any opportunities that arise in this regard."]
[null,null,21,"Do you compare your non-staff expenditure against the DfE recommended national deals to ensure you are achieving best value?",{"$nulls":6},"Q21 guidance",null,"In part",null,"Comparisons are made for some areas of expenditure but not all."]
[null,null,22,"Does the school maintain its premises and other assets to an adequate standard and make best use of capital monies for this purpose?",{"$nulls":6},"Q22 guidance",null,"Yes",null,"There is a rolling programme of maintenance and refurbishment which uses funds from Devolved Capital."]
[{"$nulls":12},{"$f":"IF(OR(ROUND(SUM(M45:M49),3)=100%,SUM(M45:M49)=0),\"\",\"Section must sum to 100%\")","v":""}]
[null,null,"F. Protecting public money "]
[]
[null,null,23,"Is the governing body sure that there are no outstanding matters from audit reports, internal audit reports or from previous consideration of weaknesses by the governing body?",{"$nulls":6},"Q23 guidance",null,"Yes",null,"The issues identified in the previous audit have all been addressed."]
[null,null,24,"Are there adequate arrangements in place to manage conflicts of interest or any related party transactions?",{"$nulls":6},"Q24 guidance",null,"Yes",null,"All parties are required to declare interests prior to all governors' meetings. Senior staff are also required to declare any conflicts of interest."]
[null,null,25,"Are there adequate arrangements in place to guard against fraud and theft by staff, contractors and suppliers? (Please note any instance of fraud or theft detected in the last 12 months)",{"$nulls":6},"Q25 guidance",null,"Yes",null,"The Bursar has put in place strict arrangements to guard against fraud and theft.  There have been no instances of fraud or theft detected in the last twelve months or previously."]
[null,null,26,"Are all staff aware of the school’s whistleblowing arrangements and to whom they should report concerns?",{"$nulls":6},"Q26 guidance",null,"Yes",null,"All staff have read the Whistleblowing Policy. A copy is available on the staff noticeboard, along with the flowchart about which pathway to follow. The LA policy was ratified at the September meeting of the full governing body."]
[null,null,27,"Does the school have an accounting system that is adequate and properly run and delivers accurate reports, including the annual Consistent Financial Reporting return?",{"$nulls":6},"Q27 guidance",null,"Yes",null,"The school uses BusinessWorldOn which is supported by SERCO and LCC. As detailed at A3 above the Governing Body has expressed frustration towards this package but consider the alternative of sourcing an unsupported accounting system to be too high risk at this time."]
[null,null,28,"Does the school have adequate arrangements for audit of voluntary funds?",{"$nulls":6},"Q28 guidance",null,"Yes",null,"The School Fund is audited annually."]
[{"$nulls":12},{"$f":"IF(OR(ROUND(SUM(M54:M57),3)=100%,SUM(M54:M57)=0),\"\",\"Section must sum to 100%\")","v":""}]
[null,null,"G. SFVS dashboard"]
[]
[null,null,29,"Have the results of the dashboard been carefully considered and potential follow-up actions identified?",{"$nulls":6},"Q29 guidance",null,"Yes",null,"The SLT and Governing Body have considered the dashboard results and, in particular, those areas not rag-rated green. Potential follow-up actions to be considered by the Governing Body and School going forward are recorded in Section F of the Dashboard."]

{"sheet":"Dashboard","index":2,"n_rows":65,"n_cols":9,"rows_kept":65,"merged":[[2,2,2,8],[4,2,4,8],[6,2,6,8],[7,2,7,8],[8,2,8,8],[10,2,10,8],[12,2,12,4],[14,5,14,8],[16,5,18,8],[22,2,22,4],[23,2,23,3],[24,2,24,3],[25,6,26,6],[25,8,26,8],[27,2,27,4],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[36,2,36,3],[37,2,37,3],[39,2,39,4],[41,2,41,3],[42,2,42,3],[44,2,44,4],[46,2,46,3],[47,2,47,3],[48,2,48,3],[49,2,49,3],[50,2,50,3],[51,2,51,3],[52,2,52,3],[54,2,54,4],[56,2,56,3],[57,2,57,3],[58,2,58,3],[59,2,59,3],[60,2,60,3],[62,2,62,4],[64,2,70,8]]}
[]
[]
[null,null,"Schools financial value standard - dashboard"]
[]
[null,null,"Effective resource management is about how a school uses its resources to drive outcomes for its pupils. A school can improve outcomes by using its resources more effectively.\n \nThe dashboard below is designed to help schools identify areas for improved resource management. It shows how a school compares to thresholds on a range of key indicators. \n\nThe completion of this assessment forms part of the annual schools financial value standard."]
[]
[null,null,"\nUsing the dashboard\n\nSchools should use the most up to date data available to them, and not rely on lagged published data.\n \nComplete all highlighted cells."]
[null,null,"Guidance on calculating or collecting the data for the school so that metrics are compared to thresholds consistently can be found here. Clicking on the link next to individual indicators below will also take you to the relevant section of the guidance."]
[null,null,"Either input the school's percentages and ratios directly, or complete the Optional - input raw data form with spending information and school characteristics. The percentages and ratios in the dashboard will then auto-calculate."]
[]
[null,null,"Using the results from the dashboard\n\nClick here for explanations of what the red, amber and green (RAG) ratings mean and what do with the results."]
[]
[null,null,"A. Information about your school"]
["*",{"$nulls":5},1]
[null,null,"School name:","The Richmond School, Skegness",null,"Click here to see the RAG rating data for this school"]
[null,null,"School LAEstab number:",9252219]
[null,null,"Phase:","Primary",null,"Input the school's percentages and ratios directly below, or\nclick here to input raw spending and characteristics data for your school"]
[null,null,"Region:","East Midlands"]
[null,null,"Number of pupils:",420]
[null,null,"% of pupils eligible for FSM:",{"v":0.33,"d":"33.0%"}]
[null,null,"I'm entering data for the year:","2019-20 (financial year)"]
[]
[null,null,"This school is being compared to other:"]
[null,null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\"),\"\",\n\"- \"&Calcs!$J29&\nIF(D17=\"Primary\",\" primary schools with \",IF(D17=\"Secondary with sixth form\",\" secondary schools with a sixth form with \",IF(D17=\"Secondary without sixth form\",\" secondary schools without a sixth form with \",IF(D17=\"Special\",\"special schools\",IF(D17=\"Alternative provision\",\"alternative provision schools\",IF(D17=\"All-through\",\"all-through schools\",IF(D17=\"Nursery\",\"nursery schools\",\"\")))))))&Calcs!$K29)","v":"- large primary schools with high levels of FSM"}]
[null,null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\"),\"\",\nIF(D17=\"Primary\",\"- primary schools \",IF(D17=\"Secondary with sixth form\",\"- secondary schools with a sixth form \",IF(D17=\"Secondary without sixth form\",\"- secondary schools without a sixth form \",IF(D17=\"Special\",\"- special schools \",IF(D17=\"Alternative provision\",\"- alternative provision schools \",IF(D17=\"All-through\",\"- all-through schools \",IF(D17=\"Nursery\",\"- nursery schools \",\"\")))))))&Calcs!$I29&\" (for average teacher cost only)\")","v":"- primary schools outside London (for average teacher cost only)"}]
[{"$nulls":6},"The school's\ndata",null,"Rating against\nthresholds"]
[]
[null,null,"B. Spending as a percentage of total expenditure"]
[]
[null,null,"Spend on teaching staff as a percentage of total expenditure",null,"Guidance",null,{"$f":"IFERROR('Optional - input raw data'!F24/'Optional - input raw data'!F13,Calcs!$A$66)","v":{"v":0.492849373187077,"d":"49.3%"}},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",D$21=\"\",G30=\"\"),\"\",\nIF(G30<=Calcs!C9,Lowest10,\nIF(AND(G30>Calcs!C9,G30<=Calcs!D9),Lowest20,\nIF(AND(G30>Calcs!D9,G30<=Calcs!E9),Inline,\nIF(AND(G30>Calcs!E9,G30<=Calcs!G9),Middle20,\nIF(AND(G30>Calcs!G9,G30<=Calcs!H9),Inline,\nIF(AND(G30>Calcs!H9,G30<=Calcs!I9),Highest20,\nIF(G30>Calcs!I9,Highest10,\"\"))))))))","v":"Highest 20% of similar schools"}]
[null,null,"Spend on supply staff as a percentage of total expenditure",null,"Guidance",null,{"$f":"IFERROR(('Optional - input raw data'!F25+'Optional - input raw data'!F33+'Optional - input raw data'!F49)/'Optional - input raw data'!F13,Calcs!$A$66)","v":{"v":0.014817519921314973,"d":"1.5%"}},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G31=\"\"),\"\",\nIF(G31<=Calcs!E10,Inline,\nIF(AND(G31>Calcs!E10,G31<=Calcs!G10),Middle20,\nIF(AND(G31>Calcs!G10,G31<=Calcs!H10),Inline,\nIF(AND(G31>Calcs!H10,G31<=Calcs!I10),Highest20,\nIF(G31>Calcs!I10,Highest10,\"\"))))))","v":"Broadly in line with similar schools"}]
[null,null,"Spend on education support staff as a percentage of total expenditure",null,"Guidance",null,{"$f":"IFERROR('Optional - input raw data'!F26/'Optional - input raw data'!F13,Calcs!$A$66)","v":{"v":0.2165380255392925,"d":"21.7%"}},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G32=\"\"),\"\",\nIF(G32<=Calcs!E11,Inline,\nIF(AND(G32>Calcs!E11,G32<=Calcs!G11),Middle20,\nIF(AND(G32>Calcs!G11,G32<=Calcs!H11),Inline,\nIF(AND(G32>Calcs!H11,G32<=Calcs!I11),Highest20,\nIF(G32>Calcs!I11,Highest10,\"\"))))))","v":"Middle 20% of similar schools"}]
[null,null,"Spend on administrative and clerical staff as a percentage of total expenditure",null,"Guidance",null,{"$f":"IFERROR('Optional - input raw data'!F28/'Optional - input raw data'!F13,Calcs!$A$66)","v":{"v":0.0421561906111426,"d":"4.2%"}},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G33=\"\"),\"\",\nIF(G33<=Calcs!H12,Inline,\nIF(AND(G33>Calcs!H12,G33<=Calcs!I12),Highest20,\nIF(G33>Calcs!I12,Highest10,\"\"))))","v":"Broadly in line with similar schools"}]
[null,null,"Spend on other staff costs as a percentage of total expenditure",null,"Guidance",null,{"$f":"IFERROR(SUM('Optional - input raw data'!F30,'Optional - input raw data'!F31,'Optional - input raw data'!F32,'Optional - input raw data'!F34)/'Optional - input raw data'!F13,Calcs!$A$66)","v":{"v":0.04339918897742807,"d":"4.3%"}},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G34=\"\"),\"\",\nIF(G34<=Calcs!H13,Inline,\nIF(AND(G34>Calcs!H13,G34<=Calcs!I13),Highest20,\nIF(G34>Calcs!I13,Highest10,\"\"))))","v":"Broadly in line with similar schools"}]
[null,null,"Spend on premises (including staff costs) as a percentage of total expenditure",null,"Guidance",null,{"$f":"IFERROR(SUM('Optional - input raw data'!F27,'Optional - input raw data'!F35,'Optional - input raw data'!F36,'Optional - input raw data'!F37)/'Optional - input raw data'!F13,Calcs!$A$66)","v":{"v":0.04392431150601807,"d":"4.4%"}},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G35=\"\"),\"\",\nIF(G35<=Calcs!H14,Inline,\nIF(AND(G35>Calcs!H14,G35<=Calcs!I14),Highest20,\nIF(G35>Calcs!I14,Highest10,\"\"))))","v":"Broadly in line with similar schools"}]
[null,null,"Spend on teaching resources as a percentage of total expenditure",null,"Guidance",null,{"$f":"IFERROR(SUM('Optional - input raw data'!F42,'Optional - input raw data'!F43,'Optional - input raw data'!F44)/'Optional - input raw data'!F13,Calcs!$A$66)","v":{"v":0.05185793351782082,"d":"5.2%"}},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G36=\"\"),\"\",\nIF(G36<=Calcs!C15,Lowest10,\nIF(AND(G36>Calcs!C15,G36<=Calcs!D15),Lowest20,\nIF(AND(G36>Calcs!D15,G36<=Calcs!E15),Inline,\nIF(AND(G36>Calcs!E15,G36<=Calcs!G15),Middle20,\nIF(G36>Calcs!G15,Inline,\"\"))))))","v":"Broadly in line with similar schools"}]
[null,null,"Spend on energy as a percentage of total expenditure",null,"Guidance",null,{"$f":"IFERROR('Optional - input raw data'!F39/'Optional - input raw data'!F13,Calcs!$A$66)","v":{"v":0.008152423065381923,"d":"0.8%"}},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G37=\"\"),\"\",\nIF(G37<=Calcs!H16,Inline,\nIF(AND(G37>Calcs!H16,G37<=Calcs!I16),Highest20,\nIF(G37>Calcs!I16,Highest10,\"\"))))","v":"Broadly in line with similar schools"}]
[null,null,"Other spending as a percentage of total expenditure (balancing line)",null,"Guidance",null,{"$f":"IFERROR(SUM('Optional - input raw data'!F29,'Optional - input raw data'!F38,'Optional - input raw data'!F40,'Optional - input raw data'!F41,'Optional - input raw data'!F45,'Optional - input raw data'!F46,'Optional - input raw data'!F47,'Optional - input raw data'!F48,'Optional - input raw data'!F50,'Optional - input raw data'!F51,'Optional - input raw data'!F52,'Optional - input raw data'!F53,'Optional - input raw data'!F54,'Optional - input raw data'!F55)/'Optional - input raw data'!F13,Calcs!$A$66)","v":{"v":0.08630503367452405,"d":"8.6%"}},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G38=\"\"),\"\",\"N/A\")","v":"N/A"}]
[{"$nulls":6},{"$f":"IF(OR(ROUND(SUM(G30:G38),3)=100%,SUM(G30:G38)=0),\"\",\"Section must sum to 100%\")","v":""}]
[null,null,"C. Reserves / balances as a percentage of total income"]
[]
[null,null,"In-year balance as a percentage of total income",null,"Guidance",null,{"$f":"IFERROR(('Optional - input raw data'!F14-'Optional - input raw data'!F13)/'Optional - input raw data'!F14,Calcs!$A$66)","v":{"v":0.024318439195769433,"d":"2.4%"}},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G42=\"\"),\"\",\nIF(G42<=-0.05,High,\nIF(AND(G42>-0.05,G42<0),Medium,\nIF(G42>=0,Low,\"\"))))","v":"Low risk"}]
[null,null,"Revenue reserve as a percentage of total income",null,"Guidance",null,{"$f":"IFERROR('Optional - input raw data'!F15/'Optional - input raw data'!F14,Calcs!$A$66)","v":{"v":0,"d":"0.0%"}},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G43=\"\"),\"\",\nIF(G43<=-0.05,High,\nIF(AND(G43>-0.05,G43<0),Medium,\nIF(G43>=0,Low,\"\"))))","v":"Low risk"}]
[]
[null,null,"D. School characteristics"]
[]
[null,null,"Average teacher cost (£)",null,"Guidance",null,{"$f":"IFERROR('Optional - input raw data'!F24/'Optional - input raw data'!F9,Calcs!$A$66)","v":{"v":56649.700598802396,"d":"£56,650"}},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",D$21=\"\",G47=\"\"),\"\",\nIF(G47<=Calcs!C21,Lowest10,\nIF(AND(G47>Calcs!C21,G47<=Calcs!D21),Lowest20,\nIF(AND(G47>Calcs!D21,G47<=Calcs!E21),Inline,\nIF(AND(G47>Calcs!E21,G47<=Calcs!G21),Middle20,\nIF(AND(G47>Calcs!G21,G47<=Calcs!H21),Inline,\nIF(AND(G47>Calcs!H21,G47<=Calcs!I21),Highest20,\nIF(G47>Calcs!I21,Highest10,\"\"))))))))","v":"Highest 20% of similar schools"}]
[null,null,"Senior leaders as a percentage of workforce",null,"Guidance",null,{"$f":"IFERROR('Optional - input raw data'!F10/'Optional - input raw data'!F11,Calcs!$A$66)","v":{"v":0.08928571428571429,"d":"8.9%"}},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G48=\"\"),\"\",\nIF(G48<=Calcs!E17,Inline,\nIF(AND(G48>Calcs!E17,G48<=Calcs!G17),Middle20,\nIF(AND(G48>Calcs!G17,G48<=Calcs!H17),Inline,\nIF(AND(G48>Calcs!H17,G48<=Calcs!I17),Highest20,\nIF(G48>Calcs!I17,Highest10,\"\"))))))","v":"Broadly in line with similar schools"}]
[null,null,"Pupil to teacher ratio",null,"Guidance",null,{"$f":"IFERROR(F11/'Optional - input raw data'!F12,Calcs!$A$66)","v":""},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G49=\"\"),\"\",\nIF(G49<=Calcs!C18,Lowest10,\nIF(AND(G49>Calcs!C18,G49<=Calcs!D18),Lowest20,\nIF(AND(G49>Calcs!D18,G49<=Calcs!E18),Inline,\nIF(AND(G49>Calcs!E18,G49<=Calcs!G18),Middle20,\nIF(AND(G49>Calcs!G18,G49<=Calcs!H18),Inline,\nIF(AND(G49>Calcs!H18,G49<=Calcs!I18),Highest20,\nIF(G49>Calcs!I18,Highest10,\"\"))))))))","v":""}]
[null,null,"Pupil to adult ratio",null,"Guidance",null,{"$f":"IFERROR(D19/'Optional - input raw data'!F11,Calcs!$A$66)","v":{"v":8.333333333333334,"d":"8.3"}},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G50=\"\"),\"\",\nIF(G50<=Calcs!C19,Lowest10,\nIF(AND(G50>Calcs!C19,G50<=Calcs!D19),Lowest20,\nIF(AND(G50>Calcs!D19,G50<=Calcs!E19),Inline,\nIF(AND(G50>Calcs!E19,G50<=Calcs!G19),Middle20,\nIF(AND(G50>Calcs!G19,G50<=Calcs!H19),Inline,\nIF(AND(G50>Calcs!H19,G50<=Calcs!I19),Highest20,\nIF(G50>Calcs!I19,Highest10,\"\"))))))))","v":"Middle 20% of similar schools"}]
[null,null,"Teacher contact ratio (less than 1.0)",null,"Guidance",null,{"$f":"IFERROR(IF(D17=Calcs!$A$62,('Optional - input raw data'!F22/'Optional - input raw data'!F9),IF(OR(D17=Calcs!$A$63,D17=Calcs!$A$64,D17=Calcs!$A$65),('Optional - input raw data'!F19/('Optional - input raw data'!F18*'Optional - input raw data'!F9)),Calcs!$A$66)),Calcs!$A$66)","v":{"v":0.8383233532934132,"d":"0.838"}},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G51=\"\"),\"\",\nIF(G51<=0.7,Muchlower,\nIF(AND(G51>0.7,G51<=0.74),Lower,\nIF(AND(G51>0.74,G51<=0.8),Inline2,\nIF(AND(G51>0.8,G51<=0.82),Higher,\nIF(G51>0.82,Muchhigher,\"\"))))))","v":"Much higher than recommended"}]
[null,null,"Predicted percentage pupil number change in 3-5 years",null,"Guidance",{"$nulls":3},{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G52=\"\"),\"\",\nIF(G52<=-0.1,High,\nIF(AND(G52>-0.1,G52<=-0.02),Medium,\nIF(G52>=-0.02,Low,\"\"))))","v":""}]
[null,null,"Average class size",null,"Guidance",null,{"v":30,"d":"30.0"},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G53=\"\"),\"\",\nIF(G53<=Calcs!C20,Lowest10,\nIF(AND(G53>Calcs!C20,G53<=Calcs!D20),Lowest20,\nIF(AND(G53>Calcs!D20,G53<=Calcs!E20),Inline,\nIF(AND(G53>Calcs!E20,G53<=Calcs!G20),Middle20,\nIF(AND(G53>Calcs!G20,G53<=Calcs!H20),Inline,\nIF(AND(G53>Calcs!H20,G53<=Calcs!I20),Highest20,\nIF(G53>Calcs!I20,Highest10,\"\"))))))))","v":"Highest 10% of similar schools"}]
[]
[null,null,"E. Outcomes"]
[]
[null,null,"Ofsted rating",null,"Guidance",null,"RI",null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G57=\"\"),\"\",INDIRECT(G57))","v":"Requires Improvement"}]
[null,null,"Progress 8 score",null,"Guidance",{"$nulls":3},{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G58=\"\"),\"\",\nIF(G58>=0.5,Wellabove,\nIF(AND(G58>=0,G58<0.5),Average,\nIF(AND(G58>=-0.5,G58<0),Below,\nIF(G58<-0.5,Wellbelow,\"\")))))","v":""}]
[null,null,"Progress score in reading",null,"Guidance",{"$nulls":3},{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G59=\"\"),\"\",\nIF(G59>=3.2,Wellabove,\nIF(AND(G59>=0,G59<3.2),Average,\nIF(AND(G59>=-2.7,G59<0),Below,\nIF(G59<-2.7,Wellbelow,\"\")))))","v":""}]
[null,null,"Progress score in writing",null,"Guidance",{"$nulls":3},{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G60=\"\"),\"\",\nIF(G60>=2.7,Wellabove,\nIF(AND(G60>=0,G60<2.7),Average,\nIF(AND(G60>=-2.6,G60<0),Below,\nIF(G60<-2.6,Wellbelow,\"\")))))","v":""}]
[null,null,"Progress score in maths",null,"Guidance",{"$nulls":3},{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G61=\"\"),\"\",\nIF(G61>=3.2,Wellabove,\nIF(AND(G61>=0,G61<3.2),Average,\nIF(AND(G61>=-3.1,G61<0),Below,\nIF(G61<-3.1,Wellbelow,\"\")))))","v":""}]
[]
[null,null,"F: Optional commentary"]
[]
[null,null,"B) Although teaching staff spending is higher than other schools, all other spending is rag-rated green. In future, any changes in teaching staff need to be considered in the context of the higher than average teaching staff costs. Recent appointments to class teacher positions have been NQTs. E) The school has a Rapid Improvement Plan which is currently being implemented with a view to improving the school's offering and, consequently OFSTED rating and attainment. Action plans are in place to improve outcomes across the curriculum. Internal data was indicating that results across each Key Stage were on track to be at or above age-related expectations at the end of 2019-20.   C)   As a result of our Ofsted rating, the emphasis is on Quality First Teaching wherever possible so the teacher contact ratio is therefore higher. Additional staff are employed who do not have a class teaching commitment: SENCO (0.5), floating teacher to cover PPA and Intervention (0.6) and the DHT who does not have a class commitment but does cover SLT release and some PPA. All teaching staff receive their time allocation for PPA. Teachers workload has been decreased through changes to the Marking Policy; the purchase of Maths No Problem, meaning that Maths planning is minimal and an emphasis on peer and self-assessment.                      "]

{"sheet":"Optional - input raw data","index":3,"n_rows":55,"n_cols":6,"rows_kept":55,"merged":[[2,2,2,3],[4,2,4,5],[5,2,5,5],[8,2,8,3],[9,2,9,3],[10,2,10,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[20,2,20,3],[21,2,21,3]]}
[]
[]
[null,null,"Raw data form"]
[{"$nulls":5},1]
[null,null,"This form can be used to input raw spend and characteristics information. If used, the information in this table will be used to calculate the percentages and ratios required in the dashboard. Alternatively, \nclick here to input the percentages and ratios directly into the dashboard."]
[null,null,"Schools should use the most up to date information available to them, and not rely on lagged published data.\n\nAll of the data should refer to the same financial year."]
[]
[]
[null,null,"Full time equivalent number of teachers (classroom and leadership)",null,null,16.7]
[null,null,"Full time equivalent of teachers in the leadership group",null,null,4.5]
[null,null,"Full time equivalent of total school workforce",null,null,50.4]
[]
[null,null,"Total expenditure",null,null,{"v":1919552,"d":"£1,919,552"}]
[null,null,"Total income",null,null,{"v":1967396,"d":"£1,967,396"}]
[null,null,"Revenue balances (committed and uncommitted)"]
[]
[null,null,"For secondary and all-through schools:"]
[null,null,"Teaching periods in the timetable cycle"]
[null,null,"Total lessons taught by all teachers in the timetable cycle"]
[{"$nulls":5},{"$f":"IFERROR(IF((F19/(F18*F9))<0.5,\"Resulting teacher contact ratio is low. Total lessons taught may be incorrectly calculated as too low\",IF((F19/(F18*F9))>1,\"Resulting teacher contact ratio is greater than 1. Total lessons taught is too high\",\"\")),\"\")","v":""}]
[null,null,"For primary schools:"]
[null,null,"Total number of classes",null,null,14]
[{"$nulls":5},{"$f":"IF(F22=\"\",\"\",IFERROR(IF((F22/F9)<0.5,\"Resulting teacher contact ratio is low. Total number of classes may be too low\",IF((F22/F9)>1,\"Resulting teacher contact ratio is greater than 1. Total number of classes is too high\",\"\")),\"\"))","v":""}]
[null,null,"E01","Teaching staff",null,{"v":946050,"d":"£946,050"}]
[null,null,"E02","Supply teaching staff",null,{"v":0,"d":"£0"}]
[null,null,"E03","Education support staff",null,{"v":415656,"d":"£415,656"}]
[null,null,"E04","Premises staff",null,{"v":63202,"d":"£63,202"}]
[null,null,"E05","Administrative and clerical staff",null,{"v":80921,"d":"£80,921"}]
[null,null,"E06","Catering staff",null,{"v":0,"d":"£0"}]
[null,null,"E07","Cost of other staff",null,{"v":67855,"d":"£67,855"}]
[null,null,"E08","Indirect employee expenses",null,{"v":6934,"d":"£6,934"}]
[null,null,"E09","Staff development and training",null,{"v":3197,"d":"£3,197"}]
[null,null,"E10","Supply teacher insurance",null,{"v":17171,"d":"£17,171"}]
[null,null,"E11","Staff-related insurance",null,{"v":5321,"d":"£5,321"}]
[null,null,"E12","Building maintenance and improvement",null,{"v":11723,"d":"£11,723"}]
[null,null,"E13","Grounds maintenance and improvement",null,{"v":3027,"d":"£3,027"}]
[null,null,"E14","Cleaning and caretaking",null,{"v":6363,"d":"£6,363"}]
[null,null,"E15","Water and sewerage",null,{"v":4532,"d":"£4,532"}]
[null,null,"E16","Energy",null,{"v":15649,"d":"£15,649"}]
[null,null,"E17","Rates",null,{"v":36289,"d":"£36,289"}]
[null,null,"E18","Other occupation costs",null,{"v":4150,"d":"£4,150"}]
[null,null,"E19","Teaching resources",null,{"v":85030,"d":"£85,030"}]
[null,null,"E20","ICT teaching resources",null,{"v":14514,"d":"£14,514"}]
[null,null,"E21","Examination fees",null,{"v":0,"d":"£0"}]
[null,null,"E22","Administrative supplies",null,{"v":2946,"d":"£2,946"}]
[null,null,"E23","Other insurance premiums",null,{"v":12966,"d":"£12,966"}]
[null,null,"E24","Special facilities",null,{"v":16670,"d":"£16,670"}]
[null,null,"E25","Catering supplies",null,{"v":74076,"d":"£74,076"}]
[null,null,"E26","Agency supply teaching staff",null,{"v":11272,"d":"£11,272"}]
[null,null,"E27","Bought-in professional services - curriculum",null,{"v":1348,"d":"£1,348"}]
[null,null,"E28","Bought-in professional services - other",null,{"v":12690,"d":"£12,690"}]
[null,null,"E29","Loan interest",null,{"v":0,"d":"£0"}]
[null,null,"E30","Direct revenue financing",null,{"v":0,"d":"£0"}]
[null,null,"E31","Community-focused school staff",null,{"v":0,"d":"£0"}]
[null,null,"E32","Community-focused school costs",null,{"v":0,"d":"£0"}]

{"sheet":"RAG rating data for your school","index":4,"n_rows":99,"n_cols":20,"rows_kept":99,"merged":[[1,7,14,19],[18,3,18,4],[18,6,18,9],[18,11,18,14],[18,16,18,19],[20,1,21,1],[23,1,24,1],[26,1,27,1],[29,1,30,1],[32,1,33,1],[35,1,36,1],[38,1,39,1],[41,1,42,1],[47,3,47,4],[47,6,47,9],[47,11,47,14],[47,16,47,19],[49,1,50,1],[52,1,53,1],[58,3,58,4],[58,6,58,9],[58,11,58,14],[58,16,58,19],[60,1,61,1],[63,1,64,1],[66,1,67,1],[69,1,70,1],[72,1,73,1],[75,1,76,1],[78,1,79,1],[84,3,84,4],[84,6,84,9],[84,11,84,14],[84,16,84,19],[86,1,87,1],[89,1,90,1],[92,1,93,1],[95,1,96,1],[98,1,99,1]]}
[]
[null,"Your school has been identified as:",{"$nulls":5},"The RAG ratings have been calculated using maintained school and academy 2017 to 18 data.\n\nThe majority of metrics in the dashboard are percentages and ratios which at a national level don't change significantly year on year, so they still provide a fair and useful comparison with your up to date data.\n\nHowever, to reflect pay awards and pension contributions changes, the underlying data on teaching staff spending and average teacher costs have been adjusted. The RAG ratings for spend on teaching staff as a percentage of total expenditure and average teacher costs include uplifts relating to the year you have selected. \n\n2017-18 : no uplift\n2018-19 : 1.4% uplift to reflect the September 2018 pay award\n2019-20 : 7.5% to also reflect the September 2019 pay award and September 2019 pensions contributions changes\n2019/20 : 11.2% to reflect the September 2019 pay award and September 2019 pensions contributions changes"]
[null,{"$f":"IF(Dashboard!D15=\"\",\"\",\"- \"&\nINDEX(Calcs!L:L,MATCH(Dashboard!D15,Calcs!A:A,0)))","v":"- a primary school"}]
[null,{"$f":"IF(Dashboard!D15=\"\",\"\",\"- \"&\nINDEX(Calcs!I:I,MATCH(Dashboard!D15,Calcs!A:A,0)))","v":"- outside London"}]
[null,{"$f":"IF(Dashboard!D15=\"\",\"\",\nIF(OR($B$3=\"- an alternative provision school\",$B$3=\"- a special school\",$B$3=\"- an all-through school\",$B$3=\"- a nursery school\"),\"\",\n\"- a \"&INDEX(Calcs!J:J,MATCH(Dashboard!D15,Calcs!A:A,0))&\" school because it has \"&INDEX(Calcs!M:M,MATCH(Dashboard!D15,Calcs!A:A,0))))","v":"- a large school because it has more than 385 pupils"}]
[null,{"$f":"IF(Dashboard!D15=\"\",\"\",\nIF(OR($B$3=\"- an alternative provision school\",$B$3=\"- a special school\",$B$3=\"- an all-through school\",$B$3=\"- a nursery school\"),\"\",\n\"- a school with \"&INDEX(Calcs!K:K,MATCH(Dashboard!D15,Calcs!A:A,0))&\" because \"&INDEX(Calcs!N:N,MATCH(Dashboard!D15,Calcs!A:A,0))&\" are eligible\"))","v":"- a school with high levels of FSM because more than 18% of pupils are eligible"}]
[]
[null,{"$f":"IF(Dashboard!D21=\"\",\"\",\"You have identified your data as \"&INDEX(Calcs!O:O,MATCH(Dashboard!D15,Calcs!A:A,0)))","v":"You have identified your data as 2019-20 (financial year)"}]
[]
[]
[]
[]
[]
[]
[null,"The thresholds for the RAG ratings are based on these characteristics and are:"]
[]
[null,"B. Your spending as a percentage of expenditure"]
[]
[{"$nulls":3},"Red rating",null,null,"Amber rating",{"$nulls":4},"Light green rating",{"$nulls":4},"Dark green rating"]
[]
[null,"Spend on teaching staff as a percentage of total expenditure",null,"Less than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),1,1))","v":{"v":0.37,"d":"37.0%"}},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),1,1))","v":{"v":0.37,"d":"37.0%"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),1,2))","v":{"v":0.395,"d":"39.5%"}},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),1,2))","v":{"v":0.395,"d":"39.5%"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),1,3))","v":{"v":0.43,"d":"43.0%"}},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),1,3))","v":{"v":0.43,"d":"43.0%"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),1,5))","v":{"v":0.455,"d":"45.5%"}}]
[{"$nulls":3},"Or more than ",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),1,7))","v":{"v":0.51,"d":"51.0%"}},null,"Or between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),1,6))","v":{"v":0.485,"d":"48.5%"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),1,7))","v":{"v":0.51,"d":"51.0%"}},null,"Or between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),1,5))","v":{"v":0.455,"d":"45.5%"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),1,6))","v":{"v":0.485,"d":"48.5%"}}]
[]
[null,"Spend on supply staff as a percentage of total expenditure",null,"More than",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),2,7))","v":{"v":0.06,"d":"6.0%"}},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),2,6))","v":{"v":0.045,"d":"4.5%"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),2,7))","v":{"v":0.06,"d":"6.0%"}},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),2,5))","v":{"v":0.03,"d":"3.0%"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),2,6))","v":{"v":0.045,"d":"4.5%"}},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),2,3))","v":{"v":0.02,"d":"2.0%"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),2,5))","v":{"v":0.03,"d":"3.0%"}}]
[{"$nulls":11},"Or less than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),2,3))","v":{"v":0.02,"d":"2.0%"}}]
[]
[null,"Spend on education support staff as a percentage of total expenditure",null,"More than",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),3,7))","v":{"v":0.265,"d":"26.5%"}},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),3,6))","v":{"v":0.25,"d":"25.0%"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),3,7))","v":{"v":0.265,"d":"26.5%"}},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),3,5))","v":{"v":0.22,"d":"22.0%"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),3,6))","v":{"v":0.25,"d":"25.0%"}},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),3,3))","v":{"v":0.195,"d":"19.5%"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),3,5))","v":{"v":0.22,"d":"22.0%"}}]
[{"$nulls":11},"Or less than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),3,3))","v":{"v":0.195,"d":"19.5%"}}]
[]
[null,"Spend on administrative and clerical staff as a percentage of total expenditure",null,"More than",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),4,7))","v":{"v":0.075,"d":"7.5%"}},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),4,6))","v":{"v":0.06,"d":"6.0%"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),4,7))","v":{"v":0.075,"d":"7.5%"}},null,"Less than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),4,6))","v":{"v":0.06,"d":"6.0%"}}]
[]
[]
[null,"Spend on other staff costs as a percentage of total expenditure",null,"More than",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),5,7))","v":{"v":0.06,"d":"6.0%"}},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),5,6))","v":{"v":0.045,"d":"4.5%"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),5,7))","v":{"v":0.06,"d":"6.0%"}},null,"Less than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),5,6))","v":{"v":0.045,"d":"4.5%"}}]
[]
[]
[null,"Spend on premises (including staff costs) as a percentage of total expenditure",null,"More than",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),6,7))","v":{"v":0.08,"d":"8.0%"}},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),6,6))","v":{"v":0.07,"d":"7.0%"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),6,7))","v":{"v":0.08,"d":"8.0%"}},null,"Less than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),6,6))","v":{"v":0.07,"d":"7.0%"}}]
[]
[]
[null,"Spend on teaching resources as a percentage of total expenditure",null,"Less than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),7,1))","v":{"v":0.025,"d":"2.5%"}},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),7,1))","v":{"v":0.025,"d":"2.5%"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),7,2))","v":{"v":0.03,"d":"3.0%"}},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),7,2))","v":{"v":0.03,"d":"3.0%"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),7,3))","v":{"v":0.04,"d":"4.0%"}},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),7,3))","v":{"v":0.04,"d":"4.0%"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),7,5))","v":{"v":0.05,"d":"5.0%"}}]
[{"$nulls":11},"Or more than",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),7,5))","v":{"v":0.05,"d":"5.0%"}}]
[]
[null,"Spend on energy as a percentage of total expenditure",null,"More than",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),8,7))","v":{"v":0.02,"d":"2.0%"}},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),8,6))","v":{"v":0.015,"d":"1.5%"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),8,7))","v":{"v":0.02,"d":"2.0%"}},null,"Less than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),8,6))","v":{"v":0.015,"d":"1.5%"}}]
[]
[]
[]
[null,"C. Reserves / balances as a percentage of total income"]
[]
[{"$nulls":3},"Red rating",null,null,"Amber rating",{"$nulls":4},"Light green rating",{"$nulls":4},"Dark green rating"]
[]
[null,"In-year balance as a percentage of total income",null,"Less than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",-0.05)","v":{"v":-0.05,"d":"-5.0%"}},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",-0.05)","v":{"v":-0.05,"d":"-5.0%"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",0)","v":{"v":0,"d":"0.0%"}},null,"More than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",0)","v":{"v":0,"d":"0.0%"}}]
[]
[]
[null,"Revenue reserve as a percentage of total income",null,"Less than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",-0.05)","v":{"v":-0.05,"d":"-5.0%"}},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",-0.05)","v":{"v":-0.05,"d":"-5.0%"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",0)","v":{"v":0,"d":"0.0%"}},null,"More than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",0)","v":{"v":0,"d":"0.0%"}}]
[]
[]
[]
[null,"D. School characteristics"]
[]
[{"$nulls":3},"Red rating",null,null,"Amber rating",{"$nulls":4},"Light green rating",{"$nulls":4},"Dark green rating"]
[]
[null,"Average teacher cost (£)",null,"Less than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),13,1))","v":{"v":42500,"d":"£42,500"}},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),13,1))","v":{"v":42500,"d":"£42,500"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),13,2))","v":{"v":45500,"d":"£45,500"}},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),13,2))","v":{"v":45500,"d":"£45,500"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),13,3))","v":{"v":48500,"d":"£48,500"}},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),13,3))","v":{"v":48500,"d":"£48,500"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),13,5))","v":{"v":51500,"d":"£51,500"}}]
[{"$nulls":3},"Or more than ",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),13,7))","v":{"v":58000,"d":"£58,000"}},null,"Or between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),13,6))","v":{"v":55000,"d":"£55,000"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),13,7))","v":{"v":58000,"d":"£58,000"}},null,"Or between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),13,5))","v":{"v":51500,"d":"£51,500"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),13,6))","v":{"v":55000,"d":"£55,000"}}]
[]
[null,"Senior leaders as a percentage of workforce",null,"More than",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),9,7))","v":{"v":0.105,"d":"10.5%"}},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),9,6))","v":{"v":0.09,"d":"9.0%"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),9,7))","v":{"v":0.105,"d":"10.5%"}},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),9,5))","v":{"v":0.075,"d":"7.5%"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),9,6))","v":{"v":0.09,"d":"9.0%"}},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),9,3))","v":{"v":0.065,"d":"6.5%"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),9,5))","v":{"v":0.075,"d":"7.5%"}}]
[{"$nulls":11},"Or less than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),9,3))","v":{"v":0.065,"d":"6.5%"}}]
[]
[null,"Pupil to teacher ratio",null,"Less than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),10,1))","v":{"v":17,"d":"17.0"}},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),10,1))","v":{"v":17,"d":"17.0"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),10,2))","v":{"v":18,"d":"18.0"}},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),10,2))","v":{"v":18,"d":"18.0"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),10,3))","v":{"v":20,"d":"20.0"}},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),10,3))","v":{"v":20,"d":"20.0"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),10,5))","v":{"v":21,"d":"21.0"}}]
[{"$nulls":3},"Or more than ",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),10,7))","v":24.5},null,"Or between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),10,6))","v":{"v":23,"d":"23.0"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),10,7))","v":24.5},null,"Or between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),10,5))","v":{"v":21,"d":"21.0"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),10,6))","v":{"v":23,"d":"23.0"}}]
[]
[null,"Pupil to adult ratio",null,"Less than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),11,1))","v":{"v":7,"d":"7.0"}},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),11,1))","v":{"v":7,"d":"7.0"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),11,2))","v":7.5},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),11,2))","v":7.5},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),11,3))","v":{"v":8,"d":"8.0"}},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),11,3))","v":{"v":8,"d":"8.0"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),11,5))","v":{"v":9,"d":"9.0"}}]
[{"$nulls":3},"Or more than ",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),11,7))","v":10.5},null,"Or between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),11,6))","v":9.5},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),11,7))","v":10.5},null,"Or between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),11,5))","v":{"v":9,"d":"9.0"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),11,6))","v":9.5}]
[]
[null,{"$f":"IF(OR($B$3=\"- an alternative provision school\",$B$3=\"- a special school\",$B$3=\"- a nursery school\"),\"\",\"Teacher contact ratio (less than 1.0)\")","v":"Teacher contact ratio (less than 1.0)"},null,{"$f":"IF(B73=\"\",\"\",\"Less than or equal to\")","v":"Less than or equal to"},{"$f":"IF(OR($B$3=\"- an alternative provision school\",$B$3=\"- a special school\",$B$3=\"- a nursery school\",Dashboard!D15=\"\"),\"\",0.7)","v":{"v":0.7,"d":"0.70"}},null,{"$f":"IF(B73=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(OR($B$3=\"- an alternative provision school\",$B$3=\"- a special school\",$B$3=\"- a nursery school\",Dashboard!D15=\"\"),\"\",0.7)","v":{"v":0.7,"d":"0.70"}},{"$f":"IF(B73=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(OR($B$3=\"- an alternative provision school\",$B$3=\"- a special school\",$B$3=\"- a nursery school\",Dashboard!D15=\"\"),\"\",0.74)","v":0.74},null,{"$f":"IF(B73=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(OR($B$3=\"- an alternative provision school\",$B$3=\"- a special school\",$B$3=\"- a nursery school\",Dashboard!D15=\"\"),\"\",0.74)","v":0.74},{"$f":"IF(G73=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(OR($B$3=\"- an alternative provision school\",$B$3=\"- a special school\",$B$3=\"- a nursery school\",Dashboard!D15=\"\"),\"\",0.8)","v":{"v":0.8,"d":"0.80"}}]
[{"$nulls":3},{"$f":"IF(B73=\"\",\"\",\"Or more than\")","v":"Or more than"},{"$f":"IF(OR($B$3=\"- an alternative provision school\",$B$3=\"- a special school\",$B$3=\"- a nursery school\",Dashboard!D15=\"\"),\"\",0.82)","v":0.82},null,{"$f":"IF(B73=\"\",\"\",\"Or between\")","v":"Or between"},{"$f":"IF(OR($B$3=\"- an alternative provision school\",$B$3=\"- a special school\",$B$3=\"- a nursery school\",Dashboard!D15=\"\"),\"\",0.8)","v":{"v":0.8,"d":"0.80"}},{"$f":"IF(B74=\"\",\"\",\"and\")","v":""},{"$f":"IF(OR($B$3=\"- an alternative provision school\",$B$3=\"- a special school\",$B$3=\"- a nursery school\",Dashboard!D15=\"\"),\"\",0.82)","v":0.82}]
[]
[null,"Predicted percentage pupil number change in 3-5 years",null,"Less than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",-0.1)","v":{"v":-0.1,"d":"-10.0%"}},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",-0.1)","v":{"v":-0.1,"d":"-10.0%"}},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",-0.02)","v":{"v":-0.02,"d":"-2.0%"}},null,"More than",{"$f":"IF(Dashboard!D15=\"\",\"\",-0.02)","v":{"v":-0.02,"d":"-2.0%"}}]
[]
[]
[null,{"$f":"IF(OR($B$3=\"- an alternative provision school\",$B$3=\"- a special school\",$B$3=\"- a nursery school\"),\"\",\"Average class size\")","v":"Average class size"},null,{"$f":"IF(B79=\"\",\"\",\"Less than or equal to\")","v":"Less than or equal to"},{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),12,1))","v":24.5},null,{"$f":"IF(B79=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),12,1))","v":24.5},{"$f":"IF(B79=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),12,2))","v":25.5},null,{"$f":"IF(B79=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),12,2))","v":25.5},{"$f":"IF(B79=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),12,3))","v":{"v":27,"d":"27.0"}},null,{"$f":"IF(B79=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),12,3))","v":{"v":27,"d":"27.0"}},{"$f":"IF(B79=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),12,5))","v":{"v":28,"d":"28.0"}}]
[{"$nulls":3},{"$f":"IF(B79=\"\",\"\",\"Or more than\")","v":"Or more than"},{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),12,7))","v":29.5},null,{"$f":"IF(B79=\"\",\"\",\"Or between\")","v":"Or between"},{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),12,6))","v":{"v":29,"d":"29.0"}},{"$f":"IF(B79=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),12,7))","v":29.5},null,{"$f":"IF(B79=\"\",\"\",\"Or between\")","v":"Or between"},{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),12,5))","v":{"v":28,"d":"28.0"}},{"$f":"IF(B79=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),12,6))","v":{"v":29,"d":"29.0"}}]
[]
[]
[null,"E. Outcomes"]
[]
[{"$nulls":3},"Red rating",null,null,"Amber rating",{"$nulls":4},"Light green rating",{"$nulls":4},"Dark green rating"]
[]
[null,"Ofsted rating",null,"School is rated",null,null,"School is rated",{"$nulls":4},"School is rated",{"$nulls":4},"School is rated"]
[{"$nulls":3},{"$f":"IF(Dashboard!D15=\"\",\"\",\"Inadequate\")","v":"Inadequate"},null,null,{"$f":"IF(Dashboard!D15=\"\",\"\",\"Requires Improvement (RI)\")","v":"Requires Improvement (RI)"},{"$nulls":4},{"$f":"IF(Dashboard!D15=\"\",\"\",\"Good\")","v":"Good"},{"$nulls":4},{"$f":"IF(Dashboard!D15=\"\",\"\",\"Outstanding\")","v":"Outstanding"}]
[]
[null,{"$f":"IF(OR($B$3=\"- a primary school\",$B$3=\"- a nursery school\"),\"\",\"Progress 8 score\")","v":""},null,{"$f":"IF(B90=\"\",\"\",\"Less than or equal to\")","v":""},{"$f":"IF(OR(Dashboard!D15=\"\",B90=\"\"),\"\",-0.5)","v":""},null,{"$f":"IF(B90=\"\",\"\",\"Between\")","v":""},{"$f":"IF(OR(Dashboard!D15=\"\",B90=\"\"),\"\",-0.5)","v":""},{"$f":"IF(B90=\"\",\"\",\"and\")","v":""},{"$f":"IF(OR(Dashboard!D15=\"\",B90=\"\"),\"\",0)","v":""},null,{"$f":"IF(B90=\"\",\"\",\"Between\")","v":""},{"$f":"IF(OR(Dashboard!D15=\"\",B90=\"\"),\"\",0)","v":""},{"$f":"IF(B90=\"\",\"\",\"and\")","v":""},{"$f":"IF(OR(Dashboard!D15=\"\",B90=\"\"),\"\",0.5)","v":""},null,{"$f":"IF(B90=\"\",\"\",\"More than\")","v":""},{"$f":"IF(OR(Dashboard!D15=\"\",B90=\"\"),\"\",0.5)","v":""}]
[]
[]
[null,{"$f":"IF(OR($B$3=\"- a secondary school with a sixth form\", $B$3=\"- a secondary school without a sixth form\",$B$3=\"- a nursery school\"),\"\",\"Progress score in reading\")","v":"Progress score in reading"},null,{"$f":"IF(B93=\"\",\"\",\"Less than or equal to\")","v":"Less than or equal to"},{"$f":"IF(OR(Dashboard!D15=\"\",B93=\"\"),\"\",-2.7)","v":-2.7},null,{"$f":"IF(B93=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(OR(Dashboard!D15=\"\",B93=\"\"),\"\",-2.7)","v":-2.7},{"$f":"IF(B93=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(OR(Dashboard!D15=\"\",B93=\"\"),\"\",0)","v":0},null,{"$f":"IF(B93=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(OR(Dashboard!D15=\"\",B93=\"\"),\"\",0)","v":0},{"$f":"IF(B93=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(OR(Dashboard!D15=\"\",B93=\"\"),\"\",3.2)","v":3.2},null,{"$f":"IF(B93=\"\",\"\",\"More than\")","v":"More than"},{"$f":"IF(OR(Dashboard!D15=\"\",B93=\"\"),\"\",3.2)","v":3.2}]
[]
[]
[null,{"$f":"IF(OR($B$3=\"- a secondary school with a sixth form\", $B$3=\"- a secondary school without a sixth form\",$B$3=\"- a nursery school\"),\"\",\"Progress score in writing\")","v":"Progress score in writing"},null,{"$f":"IF(B96=\"\",\"\",\"Less than or equal to\")","v":"Less than or equal to"},{"$f":"IF(OR(Dashboard!D15=\"\",B96=\"\"),\"\",-2.6)","v":-2.6},null,{"$f":"IF(B96=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(OR(Dashboard!D15=\"\",B96=\"\"),\"\",-2.6)","v":-2.6},{"$f":"IF(B96=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(OR(Dashboard!D15=\"\",B96=\"\"),\"\",0)","v":0},null,{"$f":"IF(B96=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(OR(Dashboard!D15=\"\",B96=\"\"),\"\",0)","v":0},{"$f":"IF(B96=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(OR(Dashboard!D15=\"\",B96=\"\"),\"\",2.7)","v":2.7},null,{"$f":"IF(B96=\"\",\"\",\"More than\")","v":"More than"},{"$f":"IF(OR(Dashboard!D15=\"\",B96=\"\"),\"\",2.7)","v":2.7}]
[]
[]
[null,{"$f":"IF(OR($B$3=\"- a secondary school with a sixth form\", $B$3=\"- a secondary school without a sixth form\",$B$3=\"- a nursery school\"),\"\",\"Progress score in maths\")","v":"Progress score in maths"},null,{"$f":"IF(B99=\"\",\"\",\"Less than or equal to\")","v":"Less than or equal to"},{"$f":"IF(OR(Dashboard!D15=\"\",B99=\"\"),\"\",-3.1)","v":-3.1},null,{"$f":"IF(B99=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(OR(Dashboard!D15=\"\",B99=\"\"),\"\",-3.1)","v":-3.1},{"$f":"IF(B99=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(OR(Dashboard!D15=\"\",B99=\"\"),\"\",0)","v":0},null,{"$f":"IF(B99=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(OR(Dashboard!D15=\"\",B99=\"\"),\"\",0)","v":0},{"$f":"IF(B99=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(OR(Dashboard!D15=\"\",B99=\"\"),\"\",3.2)","v":3.2},null,{"$f":"IF(B99=\"\",\"\",\"More than\")","v":"More than"},{"$f":"IF(OR(Dashboard!D15=\"\",B99=\"\"),\"\",3.2)","v":3.2}]

{"sheet":"RAG rating data for all schools","index":5,"n_rows":715,"n_cols":14,"rows_kept":715,"merged":[[516,3,516,4],[679,3,679,4]]}
[null,"Expand the groups to see the thresholds"]
[]
["Sample size","Phase","Size","FSM",null,"Red if less than:","Amber if less than:","Dark green if between:","(Median)","and:","Amber if more than:","Red if more than:",null,"Light green for everything else"]
[726,"Primary","Very small","Low FSM","PVSL"]
[null,"Primary","Very small","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.395,"d":"39.5%"},{"v":0.42,"d":"42.0%"},{"v":0.455,"d":"45.5%"},{"v":0.47,"d":"47.0%"},{"v":0.485,"d":"48.5%"},{"v":0.515,"d":"51.5%"},{"v":0.54,"d":"54.0%"}]
[null,"Primary","Very small","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.4,"d":"40.0%"},{"v":0.425,"d":"42.5%"},{"v":0.46,"d":"46.0%"},{"v":0.475,"d":"47.5%"},{"v":0.485,"d":"48.5%"},{"v":0.52,"d":"52.0%"},{"v":0.54,"d":"54.0%"}]
[null,"Primary","Very small","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.415,"d":"41.5%"},{"v":0.44,"d":"44.0%"},{"v":0.475,"d":"47.5%"},{"v":0.49,"d":"49.0%"},{"v":0.5,"d":"50.0%"},{"v":0.535,"d":"53.5%"},{"v":0.555,"d":"55.5%"}]
[null,"Primary","Very small","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.42,"d":"42.0%"},{"v":0.45,"d":"45.0%"},{"v":0.48,"d":"48.0%"},{"v":0.495,"d":"49.5%"},{"v":0.51,"d":"51.0%"},{"v":0.545,"d":"54.5%"},{"v":0.565,"d":"56.5%"}]
[null,"Primary","Very small","Low FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.02,"d":"2.0%"},{"v":0.02,"d":"2.0%"},{"v":0.025,"d":"2.5%"},{"v":0.04,"d":"4.0%"},{"v":0.055,"d":"5.5%"}]
[null,"Primary","Very small","Low FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.125,"d":"12.5%"},{"v":0.13,"d":"13.0%"},{"v":0.145,"d":"14.5%"},{"v":0.17,"d":"17.0%"},{"v":0.19,"d":"19.0%"}]
[null,"Primary","Very small","Low FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.055,"d":"5.5%"},null,{"v":0.075,"d":"7.5%"},{"v":0.085,"d":"8.5%"}]
[null,"Primary","Very small","Low FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.03,"d":"3.0%"},null,{"v":0.05,"d":"5.0%"},{"v":0.065,"d":"6.5%"}]
[null,"Primary","Very small","Low FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.05,"d":"5.0%"},null,{"v":0.065,"d":"6.5%"},{"v":0.08,"d":"8.0%"}]
[null,"Primary","Very small","Low FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.03,"d":"3.0%"},{"v":0.04,"d":"4.0%"},{"v":0.05,"d":"5.0%"},{"v":0.055,"d":"5.5%"},{"v":0.065,"d":"6.5%"}]
[null,"Primary","Very small","Low FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Primary","Very small","Low FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.115,"d":"11.5%"},{"v":0.125,"d":"12.5%"},{"v":0.14,"d":"14.0%"},{"v":0.175,"d":"17.5%"},{"v":0.215,"d":"21.5%"}]
[null,"Primary","Very small","Low FSM","Pupil to teacher ratio",{"v":12,"d":"12.0"},{"v":14,"d":"14.0"},{"v":16,"d":"16.0"},{"v":17,"d":"17.0"},{"v":18,"d":"18.0"},{"v":20,"d":"20.0"},22.5]
[null,"Primary","Very small","Low FSM","Pupil to adult ratio",{"v":6,"d":"6.0"},{"v":7,"d":"7.0"},{"v":8,"d":"8.0"},8.5,{"v":9,"d":"9.0"},{"v":10,"d":"10.0"},{"v":11,"d":"11.0"}]
[null,"Primary","Very small","Low FSM","Average class size",{"v":14,"d":"14.0"},{"v":17,"d":"17.0"},20.5,{"v":21,"d":"21.0"},22.5,24.5,{"v":26,"d":"26.0"}]
[]
[698,"Primary","Small","Low FSM","PSL"]
[null,"Primary","Small","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.405,"d":"40.5%"},{"v":0.43,"d":"43.0%"},{"v":0.46,"d":"46.0%"},{"v":0.47,"d":"47.0%"},{"v":0.48,"d":"48.0%"},{"v":0.515,"d":"51.5%"},{"v":0.535,"d":"53.5%"}]
[null,"Primary","Small","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.41,"d":"41.0%"},{"v":0.435,"d":"43.5%"},{"v":0.465,"d":"46.5%"},{"v":0.475,"d":"47.5%"},{"v":0.485,"d":"48.5%"},{"v":0.52,"d":"52.0%"},{"v":0.535,"d":"53.5%"}]
[null,"Primary","Small","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.425,"d":"42.5%"},{"v":0.45,"d":"45.0%"},{"v":0.48,"d":"48.0%"},{"v":0.49,"d":"49.0%"},{"v":0.5,"d":"50.0%"},{"v":0.535,"d":"53.5%"},{"v":0.55,"d":"55.0%"}]
[null,"Primary","Small","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.43,"d":"43.0%"},{"v":0.455,"d":"45.5%"},{"v":0.485,"d":"48.5%"},{"v":0.495,"d":"49.5%"},{"v":0.51,"d":"51.0%"},{"v":0.54,"d":"54.0%"},{"v":0.56,"d":"56.0%"}]
[null,"Primary","Small","Low FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.02,"d":"2.0%"},{"v":0.02,"d":"2.0%"},{"v":0.025,"d":"2.5%"},{"v":0.04,"d":"4.0%"},{"v":0.055,"d":"5.5%"}]
[null,"Primary","Small","Low FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.135,"d":"13.5%"},{"v":0.145,"d":"14.5%"},{"v":0.155,"d":"15.5%"},{"v":0.175,"d":"17.5%"},{"v":0.195,"d":"19.5%"}]
[null,"Primary","Small","Low FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.05,"d":"5.0%"},null,{"v":0.065,"d":"6.5%"},{"v":0.075,"d":"7.5%"}]
[null,"Primary","Small","Low FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.035,"d":"3.5%"},null,{"v":0.05,"d":"5.0%"},{"v":0.065,"d":"6.5%"}]
[null,"Primary","Small","Low FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.05,"d":"5.0%"},null,{"v":0.06,"d":"6.0%"},{"v":0.07,"d":"7.0%"}]
[null,"Primary","Small","Low FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.03,"d":"3.0%"},{"v":0.04,"d":"4.0%"},{"v":0.05,"d":"5.0%"},{"v":0.055,"d":"5.5%"},{"v":0.06,"d":"6.0%"}]
[null,"Primary","Small","Low FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Primary","Small","Low FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.1,"d":"10.0%"},{"v":0.115,"d":"11.5%"},{"v":0.125,"d":"12.5%"},{"v":0.155,"d":"15.5%"},{"v":0.18,"d":"18.0%"}]
[null,"Primary","Small","Low FSM","Pupil to teacher ratio",{"v":17,"d":"17.0"},18.5,19.5,20.5,{"v":21,"d":"21.0"},22.5,{"v":24,"d":"24.0"}]
[null,"Primary","Small","Low FSM","Pupil to adult ratio",{"v":8,"d":"8.0"},8.5,{"v":9,"d":"9.0"},9.5,{"v":10,"d":"10.0"},{"v":11,"d":"11.0"},{"v":12,"d":"12.0"}]
[null,"Primary","Small","Low FSM","Average class size",21.5,{"v":23,"d":"23.0"},{"v":25,"d":"25.0"},{"v":26,"d":"26.0"},26.5,{"v":28,"d":"28.0"},{"v":29,"d":"29.0"}]
[]
[{"v":1757,"d":"1,757"},"Primary","Medium","Low FSM","PML"]
[null,"Primary","Medium","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.405,"d":"40.5%"},{"v":0.425,"d":"42.5%"},{"v":0.455,"d":"45.5%"},{"v":0.465,"d":"46.5%"},{"v":0.48,"d":"48.0%"},{"v":0.505,"d":"50.5%"},{"v":0.525,"d":"52.5%"}]
[null,"Primary","Medium","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.405,"d":"40.5%"},{"v":0.43,"d":"43.0%"},{"v":0.46,"d":"46.0%"},{"v":0.47,"d":"47.0%"},{"v":0.485,"d":"48.5%"},{"v":0.51,"d":"51.0%"},{"v":0.53,"d":"53.0%"}]
[null,"Primary","Medium","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.42,"d":"42.0%"},{"v":0.445,"d":"44.5%"},{"v":0.47,"d":"47.0%"},{"v":0.485,"d":"48.5%"},{"v":0.5,"d":"50.0%"},{"v":0.52,"d":"52.0%"},{"v":0.545,"d":"54.5%"}]
[null,"Primary","Medium","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.43,"d":"43.0%"},{"v":0.45,"d":"45.0%"},{"v":0.48,"d":"48.0%"},{"v":0.495,"d":"49.5%"},{"v":0.505,"d":"50.5%"},{"v":0.53,"d":"53.0%"},{"v":0.55,"d":"55.0%"}]
[null,"Primary","Medium","Low FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.02,"d":"2.0%"},{"v":0.02,"d":"2.0%"},{"v":0.025,"d":"2.5%"},{"v":0.04,"d":"4.0%"},{"v":0.05,"d":"5.0%"}]
[null,"Primary","Medium","Low FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.145,"d":"14.5%"},{"v":0.155,"d":"15.5%"},{"v":0.165,"d":"16.5%"},{"v":0.19,"d":"19.0%"},{"v":0.21,"d":"21.0%"}]
[null,"Primary","Medium","Low FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.05,"d":"5.0%"},null,{"v":0.06,"d":"6.0%"},{"v":0.07,"d":"7.0%"}]
[null,"Primary","Medium","Low FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.035,"d":"3.5%"},null,{"v":0.05,"d":"5.0%"},{"v":0.065,"d":"6.5%"}]
[null,"Primary","Medium","Low FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.05,"d":"5.0%"},null,{"v":0.065,"d":"6.5%"},{"v":0.075,"d":"7.5%"}]
[null,"Primary","Medium","Low FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.03,"d":"3.0%"},{"v":0.04,"d":"4.0%"},{"v":0.05,"d":"5.0%"},{"v":0.055,"d":"5.5%"},{"v":0.06,"d":"6.0%"}]
[null,"Primary","Medium","Low FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Primary","Medium","Low FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.09,"d":"9.0%"},{"v":0.095,"d":"9.5%"},{"v":0.1,"d":"10.0%"},{"v":0.115,"d":"11.5%"},{"v":0.135,"d":"13.5%"}]
[null,"Primary","Medium","Low FSM","Pupil to teacher ratio",19.5,20.5,{"v":22,"d":"22.0"},22.5,{"v":23,"d":"23.0"},24.5,{"v":26,"d":"26.0"}]
[null,"Primary","Medium","Low FSM","Pupil to adult ratio",8.5,9.5,{"v":10,"d":"10.0"},10.5,{"v":11,"d":"11.0"},{"v":12,"d":"12.0"},12.5]
[null,"Primary","Medium","Low FSM","Average class size",{"v":26,"d":"26.0"},{"v":27,"d":"27.0"},28.5,{"v":29,"d":"29.0"},29.5,{"v":30,"d":"30.0"},30.5]
[]
[650,"Primary","Large","Low FSM","PLL"]
[null,"Primary","Large","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.42,"d":"42.0%"},{"v":0.445,"d":"44.5%"},{"v":0.47,"d":"47.0%"},{"v":0.48,"d":"48.0%"},{"v":0.49,"d":"49.0%"},{"v":0.51,"d":"51.0%"},{"v":0.53,"d":"53.0%"}]
[null,"Primary","Large","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.425,"d":"42.5%"},{"v":0.445,"d":"44.5%"},{"v":0.47,"d":"47.0%"},{"v":0.48,"d":"48.0%"},{"v":0.495,"d":"49.5%"},{"v":0.515,"d":"51.5%"},{"v":0.535,"d":"53.5%"}]
[null,"Primary","Large","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.44,"d":"44.0%"},{"v":0.46,"d":"46.0%"},{"v":0.485,"d":"48.5%"},{"v":0.495,"d":"49.5%"},{"v":0.51,"d":"51.0%"},{"v":0.53,"d":"53.0%"},{"v":0.55,"d":"55.0%"}]
[null,"Primary","Large","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.445,"d":"44.5%"},{"v":0.47,"d":"47.0%"},{"v":0.495,"d":"49.5%"},{"v":0.505,"d":"50.5%"},{"v":0.515,"d":"51.5%"},{"v":0.54,"d":"54.0%"},{"v":0.555,"d":"55.5%"}]
[null,"Primary","Large","Low FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"},{"v":0.025,"d":"2.5%"},{"v":0.035,"d":"3.5%"},{"v":0.05,"d":"5.0%"}]
[null,"Primary","Large","Low FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.155,"d":"15.5%"},{"v":0.16,"d":"16.0%"},{"v":0.17,"d":"17.0%"},{"v":0.195,"d":"19.5%"},{"v":0.21,"d":"21.0%"}]
[null,"Primary","Large","Low FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.045,"d":"4.5%"},null,{"v":0.06,"d":"6.0%"},{"v":0.07,"d":"7.0%"}]
[null,"Primary","Large","Low FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.035,"d":"3.5%"},null,{"v":0.05,"d":"5.0%"},{"v":0.06,"d":"6.0%"}]
[null,"Primary","Large","Low FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.05,"d":"5.0%"},null,{"v":0.06,"d":"6.0%"},{"v":0.07,"d":"7.0%"}]
[null,"Primary","Large","Low FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.03,"d":"3.0%"},{"v":0.04,"d":"4.0%"},{"v":0.045,"d":"4.5%"},{"v":0.05,"d":"5.0%"},{"v":0.055,"d":"5.5%"}]
[null,"Primary","Large","Low FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Primary","Large","Low FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.06,"d":"6.0%"},{"v":0.07,"d":"7.0%"},{"v":0.075,"d":"7.5%"},{"v":0.09,"d":"9.0%"},{"v":0.1,"d":"10.0%"}]
[null,"Primary","Large","Low FSM","Pupil to teacher ratio",20.5,21.5,22.5,{"v":23,"d":"23.0"},{"v":24,"d":"24.0"},{"v":25,"d":"25.0"},26.5]
[null,"Primary","Large","Low FSM","Pupil to adult ratio",9.5,{"v":10,"d":"10.0"},{"v":11,"d":"11.0"},{"v":11,"d":"11.0"},11.5,12.5,{"v":13,"d":"13.0"}]
[null,"Primary","Large","Low FSM","Average class size",{"v":28,"d":"28.0"},28.5,{"v":29,"d":"29.0"},29.5,29.5,{"v":30,"d":"30.0"},30.5]
[]
[880,"Primary","Very small","Medium FSM","PVSM"]
[null,"Primary","Very small","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.38,"d":"38.0%"},{"v":0.415,"d":"41.5%"},{"v":0.445,"d":"44.5%"},{"v":0.455,"d":"45.5%"},{"v":0.475,"d":"47.5%"},{"v":0.51,"d":"51.0%"},{"v":0.535,"d":"53.5%"}]
[null,"Primary","Very small","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.385,"d":"38.5%"},{"v":0.42,"d":"42.0%"},{"v":0.45,"d":"45.0%"},{"v":0.46,"d":"46.0%"},{"v":0.48,"d":"48.0%"},{"v":0.515,"d":"51.5%"},{"v":0.54,"d":"54.0%"}]
[null,"Primary","Very small","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.4,"d":"40.0%"},{"v":0.43,"d":"43.0%"},{"v":0.46,"d":"46.0%"},{"v":0.475,"d":"47.5%"},{"v":0.495,"d":"49.5%"},{"v":0.53,"d":"53.0%"},{"v":0.555,"d":"55.5%"}]
[null,"Primary","Very small","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.41,"d":"41.0%"},{"v":0.44,"d":"44.0%"},{"v":0.47,"d":"47.0%"},{"v":0.485,"d":"48.5%"},{"v":0.5,"d":"50.0%"},{"v":0.535,"d":"53.5%"},{"v":0.565,"d":"56.5%"}]
[null,"Primary","Very small","Medium FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.02,"d":"2.0%"},{"v":0.025,"d":"2.5%"},{"v":0.03,"d":"3.0%"},{"v":0.05,"d":"5.0%"},{"v":0.065,"d":"6.5%"}]
[null,"Primary","Very small","Medium FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.13,"d":"13.0%"},{"v":0.145,"d":"14.5%"},{"v":0.155,"d":"15.5%"},{"v":0.18,"d":"18.0%"},{"v":0.2,"d":"20.0%"}]
[null,"Primary","Very small","Medium FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.055,"d":"5.5%"},null,{"v":0.075,"d":"7.5%"},{"v":0.085,"d":"8.5%"}]
[null,"Primary","Very small","Medium FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.035,"d":"3.5%"},null,{"v":0.05,"d":"5.0%"},{"v":0.065,"d":"6.5%"}]
[null,"Primary","Very small","Medium FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.05,"d":"5.0%"},null,{"v":0.065,"d":"6.5%"},{"v":0.08,"d":"8.0%"}]
[null,"Primary","Very small","Medium FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.03,"d":"3.0%"},{"v":0.04,"d":"4.0%"},{"v":0.05,"d":"5.0%"},{"v":0.055,"d":"5.5%"},{"v":0.06,"d":"6.0%"}]
[null,"Primary","Very small","Medium FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Primary","Very small","Medium FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.105,"d":"10.5%"},{"v":0.12,"d":"12.0%"},{"v":0.135,"d":"13.5%"},{"v":0.175,"d":"17.5%"},{"v":0.205,"d":"20.5%"}]
[null,"Primary","Very small","Medium FSM","Pupil to teacher ratio",{"v":12,"d":"12.0"},{"v":14,"d":"14.0"},{"v":16,"d":"16.0"},{"v":17,"d":"17.0"},{"v":18,"d":"18.0"},{"v":20,"d":"20.0"},{"v":22,"d":"22.0"}]
[null,"Primary","Very small","Medium FSM","Pupil to adult ratio",5.5,6.5,7.5,{"v":8,"d":"8.0"},8.5,9.5,10.5]
[null,"Primary","Very small","Medium FSM","Average class size",14.5,{"v":17,"d":"17.0"},{"v":20,"d":"20.0"},21.5,22.5,24.5,{"v":26,"d":"26.0"}]
[]
[994,"Primary","Small","Medium FSM","PSM"]
[null,"Primary","Small","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.405,"d":"40.5%"},{"v":0.43,"d":"43.0%"},{"v":0.46,"d":"46.0%"},{"v":0.47,"d":"47.0%"},{"v":0.48,"d":"48.0%"},{"v":0.515,"d":"51.5%"},{"v":0.535,"d":"53.5%"}]
[null,"Primary","Small","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.41,"d":"41.0%"},{"v":0.435,"d":"43.5%"},{"v":0.465,"d":"46.5%"},{"v":0.475,"d":"47.5%"},{"v":0.485,"d":"48.5%"},{"v":0.52,"d":"52.0%"},{"v":0.535,"d":"53.5%"}]
[null,"Primary","Small","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.425,"d":"42.5%"},{"v":0.45,"d":"45.0%"},{"v":0.48,"d":"48.0%"},{"v":0.49,"d":"49.0%"},{"v":0.5,"d":"50.0%"},{"v":0.535,"d":"53.5%"},{"v":0.55,"d":"55.0%"}]
[null,"Primary","Small","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.43,"d":"43.0%"},{"v":0.455,"d":"45.5%"},{"v":0.485,"d":"48.5%"},{"v":0.495,"d":"49.5%"},{"v":0.51,"d":"51.0%"},{"v":0.54,"d":"54.0%"},{"v":0.56,"d":"56.0%"}]
[null,"Primary","Small","Medium FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.02,"d":"2.0%"},{"v":0.02,"d":"2.0%"},{"v":0.025,"d":"2.5%"},{"v":0.04,"d":"4.0%"},{"v":0.055,"d":"5.5%"}]
[null,"Primary","Small","Medium FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.135,"d":"13.5%"},{"v":0.145,"d":"14.5%"},{"v":0.155,"d":"15.5%"},{"v":0.175,"d":"17.5%"},{"v":0.195,"d":"19.5%"}]
[null,"Primary","Small","Medium FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.05,"d":"5.0%"},null,{"v":0.065,"d":"6.5%"},{"v":0.075,"d":"7.5%"}]
[null,"Primary","Small","Medium FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.035,"d":"3.5%"},null,{"v":0.05,"d":"5.0%"},{"v":0.065,"d":"6.5%"}]
[null,"Primary","Small","Medium FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.05,"d":"5.0%"},null,{"v":0.06,"d":"6.0%"},{"v":0.07,"d":"7.0%"}]
[null,"Primary","Small","Medium FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.03,"d":"3.0%"},{"v":0.04,"d":"4.0%"},{"v":0.05,"d":"5.0%"},{"v":0.055,"d":"5.5%"},{"v":0.06,"d":"6.0%"}]
[null,"Primary","Small","Medium FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Primary","Small","Medium FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.1,"d":"10.0%"},{"v":0.115,"d":"11.5%"},{"v":0.125,"d":"12.5%"},{"v":0.155,"d":"15.5%"},{"v":0.18,"d":"18.0%"}]
[null,"Primary","Small","Medium FSM","Pupil to teacher ratio",{"v":17,"d":"17.0"},18.5,19.5,20.5,{"v":21,"d":"21.0"},22.5,{"v":24,"d":"24.0"}]
[null,"Primary","Small","Medium FSM","Pupil to adult ratio",{"v":8,"d":"8.0"},8.5,{"v":9,"d":"9.0"},9.5,{"v":10,"d":"10.0"},{"v":11,"d":"11.0"},{"v":12,"d":"12.0"}]
[null,"Primary","Small","Medium FSM","Average class size",21.5,{"v":23,"d":"23.0"},{"v":25,"d":"25.0"},{"v":26,"d":"26.0"},26.5,{"v":28,"d":"28.0"},{"v":29,"d":"29.0"}]
[]
[{"v":3735,"d":"3,735"},"Primary","Medium","Medium FSM","PMM"]
[null,"Primary","Medium","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.405,"d":"40.5%"},{"v":0.425,"d":"42.5%"},{"v":0.455,"d":"45.5%"},{"v":0.465,"d":"46.5%"},{"v":0.48,"d":"48.0%"},{"v":0.505,"d":"50.5%"},{"v":0.525,"d":"52.5%"}]
[null,"Primary","Medium","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.405,"d":"40.5%"},{"v":0.43,"d":"43.0%"},{"v":0.46,"d":"46.0%"},{"v":0.47,"d":"47.0%"},{"v":0.485,"d":"48.5%"},{"v":0.51,"d":"51.0%"},{"v":0.53,"d":"53.0%"}]
[null,"Primary","Medium","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.42,"d":"42.0%"},{"v":0.445,"d":"44.5%"},{"v":0.47,"d":"47.0%"},{"v":0.485,"d":"48.5%"},{"v":0.5,"d":"50.0%"},{"v":0.52,"d":"52.0%"},{"v":0.545,"d":"54.5%"}]
[null,"Primary","Medium","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.43,"d":"43.0%"},{"v":0.45,"d":"45.0%"},{"v":0.48,"d":"48.0%"},{"v":0.495,"d":"49.5%"},{"v":0.505,"d":"50.5%"},{"v":0.53,"d":"53.0%"},{"v":0.55,"d":"55.0%"}]
[null,"Primary","Medium","Medium FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.02,"d":"2.0%"},{"v":0.02,"d":"2.0%"},{"v":0.025,"d":"2.5%"},{"v":0.04,"d":"4.0%"},{"v":0.05,"d":"5.0%"}]
[null,"Primary","Medium","Medium FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.145,"d":"14.5%"},{"v":0.155,"d":"15.5%"},{"v":0.165,"d":"16.5%"},{"v":0.19,"d":"19.0%"},{"v":0.21,"d":"21.0%"}]
[null,"Primary","Medium","Medium FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.05,"d":"5.0%"},null,{"v":0.06,"d":"6.0%"},{"v":0.07,"d":"7.0%"}]
[null,"Primary","Medium","Medium FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.035,"d":"3.5%"},null,{"v":0.05,"d":"5.0%"},{"v":0.065,"d":"6.5%"}]
[null,"Primary","Medium","Medium FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.05,"d":"5.0%"},null,{"v":0.065,"d":"6.5%"},{"v":0.075,"d":"7.5%"}]
[null,"Primary","Medium","Medium FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.03,"d":"3.0%"},{"v":0.04,"d":"4.0%"},{"v":0.05,"d":"5.0%"},{"v":0.055,"d":"5.5%"},{"v":0.06,"d":"6.0%"}]
[null,"Primary","Medium","Medium FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Primary","Medium","Medium FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.09,"d":"9.0%"},{"v":0.095,"d":"9.5%"},{"v":0.1,"d":"10.0%"},{"v":0.115,"d":"11.5%"},{"v":0.135,"d":"13.5%"}]
[null,"Primary","Medium","Medium FSM","Pupil to teacher ratio",19.5,20.5,{"v":22,"d":"22.0"},22.5,{"v":23,"d":"23.0"},24.5,{"v":26,"d":"26.0"}]
[null,"Primary","Medium","Medium FSM","Pupil to adult ratio",8.5,9.5,{"v":10,"d":"10.0"},10.5,{"v":11,"d":"11.0"},{"v":12,"d":"12.0"},12.5]
[null,"Primary","Medium","Medium FSM","Average class size",{"v":26,"d":"26.0"},{"v":27,"d":"27.0"},28.5,{"v":29,"d":"29.0"},29.5,{"v":30,"d":"30.0"},30.5]
[]
[{"v":2027,"d":"2,027"},"Primary","Large","Medium FSM","PLM"]
[null,"Primary","Large","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.385,"d":"38.5%"},{"v":0.41,"d":"41.0%"},{"v":0.445,"d":"44.5%"},{"v":0.455,"d":"45.5%"},{"v":0.47,"d":"47.0%"},{"v":0.495,"d":"49.5%"},{"v":0.52,"d":"52.0%"}]
[null,"Primary","Large","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.385,"d":"38.5%"},{"v":0.415,"d":"41.5%"},{"v":0.445,"d":"44.5%"},{"v":0.46,"d":"46.0%"},{"v":0.47,"d":"47.0%"},{"v":0.5,"d":"50.0%"},{"v":0.52,"d":"52.0%"}]
[null,"Primary","Large","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.4,"d":"40.0%"},{"v":0.43,"d":"43.0%"},{"v":0.46,"d":"46.0%"},{"v":0.475,"d":"47.5%"},{"v":0.485,"d":"48.5%"},{"v":0.515,"d":"51.5%"},{"v":0.535,"d":"53.5%"}]
[null,"Primary","Large","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.41,"d":"41.0%"},{"v":0.435,"d":"43.5%"},{"v":0.47,"d":"47.0%"},{"v":0.48,"d":"48.0%"},{"v":0.495,"d":"49.5%"},{"v":0.52,"d":"52.0%"},{"v":0.545,"d":"54.5%"}]
[null,"Primary","Large","Medium FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.02,"d":"2.0%"},{"v":0.02,"d":"2.0%"},{"v":0.03,"d":"3.0%"},{"v":0.04,"d":"4.0%"},{"v":0.055,"d":"5.5%"}]
[null,"Primary","Large","Medium FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.175,"d":"17.5%"},{"v":0.185,"d":"18.5%"},{"v":0.195,"d":"19.5%"},{"v":0.22,"d":"22.0%"},{"v":0.245,"d":"24.5%"}]
[null,"Primary","Large","Medium FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.045,"d":"4.5%"},null,{"v":0.06,"d":"6.0%"},{"v":0.065,"d":"6.5%"}]
[null,"Primary","Large","Medium FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.035,"d":"3.5%"},null,{"v":0.05,"d":"5.0%"},{"v":0.06,"d":"6.0%"}]
[null,"Primary","Large","Medium FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.05,"d":"5.0%"},null,{"v":0.065,"d":"6.5%"},{"v":0.075,"d":"7.5%"}]
[null,"Primary","Large","Medium FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.03,"d":"3.0%"},{"v":0.035,"d":"3.5%"},{"v":0.045,"d":"4.5%"},{"v":0.045,"d":"4.5%"},{"v":0.05,"d":"5.0%"}]
[null,"Primary","Large","Medium FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Primary","Large","Medium FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.06,"d":"6.0%"},{"v":0.065,"d":"6.5%"},{"v":0.075,"d":"7.5%"},{"v":0.09,"d":"9.0%"},{"v":0.105,"d":"10.5%"}]
[null,"Primary","Large","Medium FSM","Pupil to teacher ratio",18.5,{"v":20,"d":"20.0"},21.5,{"v":22,"d":"22.0"},22.5,{"v":24,"d":"24.0"},{"v":25,"d":"25.0"}]
[null,"Primary","Large","Medium FSM","Pupil to adult ratio",{"v":8,"d":"8.0"},8.5,9.5,{"v":10,"d":"10.0"},{"v":10,"d":"10.0"},{"v":11,"d":"11.0"},{"v":12,"d":"12.0"}]
[null,"Primary","Large","Medium FSM","Average class size",{"v":26,"d":"26.0"},{"v":27,"d":"27.0"},28.5,{"v":29,"d":"29.0"},{"v":29,"d":"29.0"},29.5,{"v":30,"d":"30.0"}]
[]
[214,"Primary","Very small","High FSM","PVSH"]
[null,"Primary","Very small","High FSM","Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.36,"d":"36.0%"},{"v":0.395,"d":"39.5%"},{"v":0.425,"d":"42.5%"},{"v":0.44,"d":"44.0%"},{"v":0.455,"d":"45.5%"},{"v":0.49,"d":"49.0%"},{"v":0.52,"d":"52.0%"}]
[null,"Primary","Very small","High FSM","Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.365,"d":"36.5%"},{"v":0.395,"d":"39.5%"},{"v":0.43,"d":"43.0%"},{"v":0.44,"d":"44.0%"},{"v":0.46,"d":"46.0%"},{"v":0.495,"d":"49.5%"},{"v":0.525,"d":"52.5%"}]
[null,"Primary","Very small","High FSM","Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.375,"d":"37.5%"},{"v":0.41,"d":"41.0%"},{"v":0.445,"d":"44.5%"},{"v":0.455,"d":"45.5%"},{"v":0.475,"d":"47.5%"},{"v":0.51,"d":"51.0%"},{"v":0.54,"d":"54.0%"}]
[null,"Primary","Very small","High FSM","Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.385,"d":"38.5%"},{"v":0.42,"d":"42.0%"},{"v":0.455,"d":"45.5%"},{"v":0.465,"d":"46.5%"},{"v":0.485,"d":"48.5%"},{"v":0.515,"d":"51.5%"},{"v":0.55,"d":"55.0%"}]
[null,"Primary","Very small","High FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.02,"d":"2.0%"},{"v":0.025,"d":"2.5%"},{"v":0.03,"d":"3.0%"},{"v":0.055,"d":"5.5%"},{"v":0.08,"d":"8.0%"}]
[null,"Primary","Very small","High FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.14,"d":"14.0%"},{"v":0.15,"d":"15.0%"},{"v":0.17,"d":"17.0%"},{"v":0.2,"d":"20.0%"},{"v":0.235,"d":"23.5%"}]
[null,"Primary","Very small","High FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.055,"d":"5.5%"},null,{"v":0.075,"d":"7.5%"},{"v":0.085,"d":"8.5%"}]
[null,"Primary","Very small","High FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.035,"d":"3.5%"},null,{"v":0.05,"d":"5.0%"},{"v":0.065,"d":"6.5%"}]
[null,"Primary","Very small","High FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.055,"d":"5.5%"},null,{"v":0.07,"d":"7.0%"},{"v":0.085,"d":"8.5%"}]
[null,"Primary","Very small","High FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.03,"d":"3.0%"},{"v":0.04,"d":"4.0%"},{"v":0.05,"d":"5.0%"},{"v":0.055,"d":"5.5%"},{"v":0.06,"d":"6.0%"}]
[null,"Primary","Very small","High FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Primary","Very small","High FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.105,"d":"10.5%"},{"v":0.12,"d":"12.0%"},{"v":0.135,"d":"13.5%"},{"v":0.17,"d":"17.0%"},{"v":0.2,"d":"20.0%"}]
[null,"Primary","Very small","High FSM","Pupil to teacher ratio",{"v":11,"d":"11.0"},{"v":13,"d":"13.0"},15.5,{"v":16,"d":"16.0"},{"v":17,"d":"17.0"},{"v":19,"d":"19.0"},20.5]
[null,"Primary","Very small","High FSM","Pupil to adult ratio",{"v":5,"d":"5.0"},5.5,6.5,{"v":7,"d":"7.0"},7.5,8.5,9.5]
[null,"Primary","Very small","High FSM","Average class size",{"v":13,"d":"13.0"},16.5,19.5,20.5,22.5,{"v":24,"d":"24.0"},25.5]
[]
[370,"Primary","Small","High FSM","PSH"]
[null,"Primary","Small","High FSM","Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.365,"d":"36.5%"},{"v":0.39,"d":"39.0%"},{"v":0.42,"d":"42.0%"},{"v":0.435,"d":"43.5%"},{"v":0.45,"d":"45.0%"},{"v":0.48,"d":"48.0%"},{"v":0.515,"d":"51.5%"}]
[null,"Primary","Small","High FSM","Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.365,"d":"36.5%"},{"v":0.39,"d":"39.0%"},{"v":0.425,"d":"42.5%"},{"v":0.44,"d":"44.0%"},{"v":0.45,"d":"45.0%"},{"v":0.485,"d":"48.5%"},{"v":0.52,"d":"52.0%"}]
[null,"Primary","Small","High FSM","Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.38,"d":"38.0%"},{"v":0.405,"d":"40.5%"},{"v":0.44,"d":"44.0%"},{"v":0.455,"d":"45.5%"},{"v":0.465,"d":"46.5%"},{"v":0.5,"d":"50.0%"},{"v":0.535,"d":"53.5%"}]
[null,"Primary","Small","High FSM","Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.39,"d":"39.0%"},{"v":0.415,"d":"41.5%"},{"v":0.445,"d":"44.5%"},{"v":0.46,"d":"46.0%"},{"v":0.475,"d":"47.5%"},{"v":0.51,"d":"51.0%"},{"v":0.54,"d":"54.0%"}]
[null,"Primary","Small","High FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.02,"d":"2.0%"},{"v":0.025,"d":"2.5%"},{"v":0.035,"d":"3.5%"},{"v":0.055,"d":"5.5%"},{"v":0.075,"d":"7.5%"}]
[null,"Primary","Small","High FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.165,"d":"16.5%"},{"v":0.175,"d":"17.5%"},{"v":0.185,"d":"18.5%"},{"v":0.215,"d":"21.5%"},{"v":0.23,"d":"23.0%"}]
[null,"Primary","Small","High FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.045,"d":"4.5%"},null,{"v":0.065,"d":"6.5%"},{"v":0.075,"d":"7.5%"}]
[null,"Primary","Small","High FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.035,"d":"3.5%"},null,{"v":0.05,"d":"5.0%"},{"v":0.065,"d":"6.5%"}]
[null,"Primary","Small","High FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.055,"d":"5.5%"},null,{"v":0.07,"d":"7.0%"},{"v":0.08,"d":"8.0%"}]
[null,"Primary","Small","High FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.025,"d":"2.5%"},{"v":0.035,"d":"3.5%"},{"v":0.045,"d":"4.5%"},{"v":0.05,"d":"5.0%"},{"v":0.055,"d":"5.5%"}]
[null,"Primary","Small","High FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Primary","Small","High FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.095,"d":"9.5%"},{"v":0.105,"d":"10.5%"},{"v":0.115,"d":"11.5%"},{"v":0.135,"d":"13.5%"},{"v":0.155,"d":"15.5%"}]
[null,"Primary","Small","High FSM","Pupil to teacher ratio",{"v":15,"d":"15.0"},{"v":16,"d":"16.0"},17.5,{"v":18,"d":"18.0"},{"v":19,"d":"19.0"},{"v":21,"d":"21.0"},22.5]
[null,"Primary","Small","High FSM","Pupil to adult ratio",6.5,{"v":7,"d":"7.0"},7.5,{"v":8,"d":"8.0"},8.5,{"v":9,"d":"9.0"},{"v":10,"d":"10.0"}]
[null,"Primary","Small","High FSM","Average class size",{"v":19,"d":"19.0"},20.5,22.5,{"v":23,"d":"23.0"},{"v":24,"d":"24.0"},26.5,{"v":28,"d":"28.0"}]
[]
[{"v":2197,"d":"2,197"},"Primary","Medium","High FSM","PMH"]
[null,"Primary","Medium","High FSM","Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.36,"d":"36.0%"},{"v":0.385,"d":"38.5%"},{"v":0.41,"d":"41.0%"},{"v":0.425,"d":"42.5%"},{"v":0.435,"d":"43.5%"},{"v":0.465,"d":"46.5%"},{"v":0.49,"d":"49.0%"}]
[null,"Primary","Medium","High FSM","Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.36,"d":"36.0%"},{"v":0.385,"d":"38.5%"},{"v":0.415,"d":"41.5%"},{"v":0.43,"d":"43.0%"},{"v":0.44,"d":"44.0%"},{"v":0.47,"d":"47.0%"},{"v":0.495,"d":"49.5%"}]
[null,"Primary","Medium","High FSM","Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.375,"d":"37.5%"},{"v":0.4,"d":"40.0%"},{"v":0.43,"d":"43.0%"},{"v":0.44,"d":"44.0%"},{"v":0.455,"d":"45.5%"},{"v":0.485,"d":"48.5%"},{"v":0.51,"d":"51.0%"}]
[null,"Primary","Medium","High FSM","Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.385,"d":"38.5%"},{"v":0.41,"d":"41.0%"},{"v":0.435,"d":"43.5%"},{"v":0.45,"d":"45.0%"},{"v":0.465,"d":"46.5%"},{"v":0.49,"d":"49.0%"},{"v":0.52,"d":"52.0%"}]
[null,"Primary","Medium","High FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.02,"d":"2.0%"},{"v":0.025,"d":"2.5%"},{"v":0.03,"d":"3.0%"},{"v":0.045,"d":"4.5%"},{"v":0.065,"d":"6.5%"}]
[null,"Primary","Medium","High FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.185,"d":"18.5%"},{"v":0.2,"d":"20.0%"},{"v":0.21,"d":"21.0%"},{"v":0.235,"d":"23.5%"},{"v":0.26,"d":"26.0%"}]
[null,"Primary","Medium","High FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.045,"d":"4.5%"},null,{"v":0.06,"d":"6.0%"},{"v":0.075,"d":"7.5%"}]
[null,"Primary","Medium","High FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.035,"d":"3.5%"},null,{"v":0.05,"d":"5.0%"},{"v":0.06,"d":"6.0%"}]
[null,"Primary","Medium","High FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.055,"d":"5.5%"},null,{"v":0.07,"d":"7.0%"},{"v":0.08,"d":"8.0%"}]
[null,"Primary","Medium","High FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.025,"d":"2.5%"},{"v":0.035,"d":"3.5%"},{"v":0.04,"d":"4.0%"},{"v":0.045,"d":"4.5%"},{"v":0.05,"d":"5.0%"}]
[null,"Primary","Medium","High FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Primary","Medium","High FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.075,"d":"7.5%"},{"v":0.08,"d":"8.0%"},{"v":0.09,"d":"9.0%"},{"v":0.11,"d":"11.0%"},{"v":0.13,"d":"13.0%"}]
[null,"Primary","Medium","High FSM","Pupil to teacher ratio",{"v":16,"d":"16.0"},17.5,{"v":19,"d":"19.0"},19.5,20.5,22.5,{"v":24,"d":"24.0"}]
[null,"Primary","Medium","High FSM","Pupil to adult ratio",6.5,7.5,{"v":8,"d":"8.0"},8.5,8.5,9.5,{"v":10,"d":"10.0"}]
[null,"Primary","Medium","High FSM","Average class size",22.5,23.5,25.5,26.5,{"v":27,"d":"27.0"},28.5,29.5]
[]
[{"v":1120,"d":"1,120"},"Primary","Large","High FSM","PLH"]
[null,"Primary","Large","High FSM","Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.355,"d":"35.5%"},{"v":0.38,"d":"38.0%"},{"v":0.41,"d":"41.0%"},{"v":0.425,"d":"42.5%"},{"v":0.435,"d":"43.5%"},{"v":0.465,"d":"46.5%"},{"v":0.49,"d":"49.0%"}]
[null,"Primary","Large","High FSM","Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.36,"d":"36.0%"},{"v":0.385,"d":"38.5%"},{"v":0.415,"d":"41.5%"},{"v":0.425,"d":"42.5%"},{"v":0.44,"d":"44.0%"},{"v":0.47,"d":"47.0%"},{"v":0.495,"d":"49.5%"}]
[null,"Primary","Large","High FSM","Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.37,"d":"37.0%"},{"v":0.395,"d":"39.5%"},{"v":0.43,"d":"43.0%"},{"v":0.44,"d":"44.0%"},{"v":0.455,"d":"45.5%"},{"v":0.485,"d":"48.5%"},{"v":0.51,"d":"51.0%"}]
[null,"Primary","Large","High FSM","Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.38,"d":"38.0%"},{"v":0.405,"d":"40.5%"},{"v":0.435,"d":"43.5%"},{"v":0.45,"d":"45.0%"},{"v":0.465,"d":"46.5%"},{"v":0.49,"d":"49.0%"},{"v":0.515,"d":"51.5%"}]
[null,"Primary","Large","High FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.02,"d":"2.0%"},{"v":0.025,"d":"2.5%"},{"v":0.03,"d":"3.0%"},{"v":0.045,"d":"4.5%"},{"v":0.06,"d":"6.0%"}]
[null,"Primary","Large","High FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.195,"d":"19.5%"},{"v":0.205,"d":"20.5%"},{"v":0.22,"d":"22.0%"},{"v":0.25,"d":"25.0%"},{"v":0.265,"d":"26.5%"}]
[null,"Primary","Large","High FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.045,"d":"4.5%"},null,{"v":0.06,"d":"6.0%"},{"v":0.075,"d":"7.5%"}]
[null,"Primary","Large","High FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.035,"d":"3.5%"},null,{"v":0.045,"d":"4.5%"},{"v":0.06,"d":"6.0%"}]
[null,"Primary","Large","High FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.05,"d":"5.0%"},null,{"v":0.07,"d":"7.0%"},{"v":0.08,"d":"8.0%"}]
[null,"Primary","Large","High FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.025,"d":"2.5%"},{"v":0.03,"d":"3.0%"},{"v":0.04,"d":"4.0%"},{"v":0.045,"d":"4.5%"},{"v":0.05,"d":"5.0%"}]
[null,"Primary","Large","High FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Primary","Large","High FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.065,"d":"6.5%"},{"v":0.07,"d":"7.0%"},{"v":0.075,"d":"7.5%"},{"v":0.09,"d":"9.0%"},{"v":0.105,"d":"10.5%"}]
[null,"Primary","Large","High FSM","Pupil to teacher ratio",{"v":17,"d":"17.0"},{"v":18,"d":"18.0"},{"v":20,"d":"20.0"},20.5,{"v":21,"d":"21.0"},{"v":23,"d":"23.0"},24.5]
[null,"Primary","Large","High FSM","Pupil to adult ratio",{"v":7,"d":"7.0"},7.5,{"v":8,"d":"8.0"},8.5,{"v":9,"d":"9.0"},9.5,10.5]
[null,"Primary","Large","High FSM","Average class size",24.5,25.5,{"v":27,"d":"27.0"},27.5,{"v":28,"d":"28.0"},{"v":29,"d":"29.0"},29.5]
[]
[]
["Sample size","Phase","Size","FSM",null,"Red if less than:","Amber if less than:","Dark green if between:","(Median)","and:","Amber if more than:","Red if more than:",null,"Light green for everything else"]
[59,"Secondary with sixth form","Small","Low FSM","SSSL"]
[null,"Secondary with sixth form","Small","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.445,"d":"44.5%"},{"v":0.48,"d":"48.0%"},{"v":0.525,"d":"52.5%"},{"v":0.54,"d":"54.0%"},{"v":0.56,"d":"56.0%"},{"v":0.6,"d":"60.0%"},{"v":0.625,"d":"62.5%"}]
[null,"Secondary with sixth form","Small","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.45,"d":"45.0%"},{"v":0.485,"d":"48.5%"},{"v":0.53,"d":"53.0%"},{"v":0.545,"d":"54.5%"},{"v":0.56,"d":"56.0%"},{"v":0.6,"d":"60.0%"},{"v":0.63,"d":"63.0%"}]
[null,"Secondary with sixth form","Small","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.465,"d":"46.5%"},{"v":0.5,"d":"50.0%"},{"v":0.545,"d":"54.5%"},{"v":0.56,"d":"56.0%"},{"v":0.575,"d":"57.5%"},{"v":0.615,"d":"61.5%"},{"v":0.64,"d":"64.0%"}]
[null,"Secondary with sixth form","Small","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.47,"d":"47.0%"},{"v":0.505,"d":"50.5%"},{"v":0.555,"d":"55.5%"},{"v":0.57,"d":"57.0%"},{"v":0.585,"d":"58.5%"},{"v":0.625,"d":"62.5%"},{"v":0.65,"d":"65.0%"}]
[null,"Secondary with sixth form","Small","Low FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.01,"d":"1.0%"},{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"},{"v":0.035,"d":"3.5%"},{"v":0.045,"d":"4.5%"}]
[null,"Secondary with sixth form","Small","Low FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.05,"d":"5.0%"},{"v":0.055,"d":"5.5%"},{"v":0.065,"d":"6.5%"},{"v":0.085,"d":"8.5%"},{"v":0.095,"d":"9.5%"}]
[null,"Secondary with sixth form","Small","Low FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.065,"d":"6.5%"},null,{"v":0.09,"d":"9.0%"},{"v":0.125,"d":"12.5%"}]
[null,"Secondary with sixth form","Small","Low FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.015,"d":"1.5%"},null,{"v":0.05,"d":"5.0%"},{"v":0.08,"d":"8.0%"}]
[null,"Secondary with sixth form","Small","Low FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.05,"d":"5.0%"},null,{"v":0.08,"d":"8.0%"},{"v":0.09,"d":"9.0%"}]
[null,"Secondary with sixth form","Small","Low FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.045,"d":"4.5%"},{"v":0.055,"d":"5.5%"},{"v":0.065,"d":"6.5%"},{"v":0.075,"d":"7.5%"},{"v":0.08,"d":"8.0%"}]
[null,"Secondary with sixth form","Small","Low FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Secondary with sixth form","Small","Low FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.065,"d":"6.5%"},{"v":0.07,"d":"7.0%"},{"v":0.08,"d":"8.0%"},{"v":0.125,"d":"12.5%"},{"v":0.16,"d":"16.0%"}]
[null,"Secondary with sixth form","Small","Low FSM","Pupil to teacher ratio",{"v":11,"d":"11.0"},{"v":13,"d":"13.0"},{"v":15,"d":"15.0"},{"v":16,"d":"16.0"},{"v":17,"d":"17.0"},{"v":18,"d":"18.0"},18.5]
[null,"Secondary with sixth form","Small","Low FSM","Pupil to adult ratio",{"v":7,"d":"7.0"},8.5,9.5,{"v":10,"d":"10.0"},10.5,11.5,{"v":12,"d":"12.0"}]
[null,"Secondary with sixth form","Small","Low FSM","Average class size",{"v":14,"d":"14.0"},{"v":17,"d":"17.0"},{"v":19,"d":"19.0"},{"v":20,"d":"20.0"},20.5,22.5,{"v":24,"d":"24.0"}]
[]
[304,"Secondary with sixth form","Medium","Low FSM","SSML"]
[null,"Secondary with sixth form","Medium","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.495,"d":"49.5%"},{"v":0.525,"d":"52.5%"},{"v":0.555,"d":"55.5%"},{"v":0.565,"d":"56.5%"},{"v":0.575,"d":"57.5%"},{"v":0.61,"d":"61.0%"},{"v":0.625,"d":"62.5%"}]
[null,"Secondary with sixth form","Medium","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.5,"d":"50.0%"},{"v":0.53,"d":"53.0%"},{"v":0.56,"d":"56.0%"},{"v":0.565,"d":"56.5%"},{"v":0.58,"d":"58.0%"},{"v":0.615,"d":"61.5%"},{"v":0.63,"d":"63.0%"}]
[null,"Secondary with sixth form","Medium","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.515,"d":"51.5%"},{"v":0.545,"d":"54.5%"},{"v":0.57,"d":"57.0%"},{"v":0.58,"d":"58.0%"},{"v":0.595,"d":"59.5%"},{"v":0.625,"d":"62.5%"},{"v":0.645,"d":"64.5%"}]
[null,"Secondary with sixth form","Medium","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.525,"d":"52.5%"},{"v":0.55,"d":"55.0%"},{"v":0.58,"d":"58.0%"},{"v":0.59,"d":"59.0%"},{"v":0.6,"d":"60.0%"},{"v":0.635,"d":"63.5%"},{"v":0.65,"d":"65.0%"}]
[null,"Secondary with sixth form","Medium","Low FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.01,"d":"1.0%"},{"v":0.01,"d":"1.0%"},{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"},{"v":0.025,"d":"2.5%"}]
[null,"Secondary with sixth form","Medium","Low FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.07,"d":"7.0%"},{"v":0.075,"d":"7.5%"},{"v":0.08,"d":"8.0%"},{"v":0.1,"d":"10.0%"},{"v":0.11,"d":"11.0%"}]
[null,"Secondary with sixth form","Medium","Low FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.065,"d":"6.5%"},null,{"v":0.085,"d":"8.5%"},{"v":0.095,"d":"9.5%"}]
[null,"Secondary with sixth form","Medium","Low FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.015,"d":"1.5%"},null,{"v":0.03,"d":"3.0%"},{"v":0.055,"d":"5.5%"}]
[null,"Secondary with sixth form","Medium","Low FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.055,"d":"5.5%"},null,{"v":0.07,"d":"7.0%"},{"v":0.08,"d":"8.0%"}]
[null,"Secondary with sixth form","Medium","Low FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.05,"d":"5.0%"},{"v":0.06,"d":"6.0%"},{"v":0.075,"d":"7.5%"},{"v":0.085,"d":"8.5%"},{"v":0.09,"d":"9.0%"}]
[null,"Secondary with sixth form","Medium","Low FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Secondary with sixth form","Medium","Low FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.055,"d":"5.5%"},{"v":0.06,"d":"6.0%"},{"v":0.065,"d":"6.5%"},{"v":0.075,"d":"7.5%"},{"v":0.085,"d":"8.5%"}]
[null,"Secondary with sixth form","Medium","Low FSM","Pupil to teacher ratio",{"v":15,"d":"15.0"},15.5,16.5,{"v":17,"d":"17.0"},17.5,18.5,{"v":19,"d":"19.0"}]
[null,"Secondary with sixth form","Medium","Low FSM","Pupil to adult ratio",{"v":9,"d":"9.0"},9.5,{"v":10,"d":"10.0"},10.5,{"v":11,"d":"11.0"},11.5,12.5]
[null,"Secondary with sixth form","Medium","Low FSM","Average class size",19.5,{"v":20,"d":"20.0"},{"v":21,"d":"21.0"},21.5,21.5,22.5,23.5]
[]
[206,"Secondary with sixth form","Large","Low FSM","SSLL"]
[null,"Secondary with sixth form","Large","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.5,"d":"50.0%"},{"v":0.53,"d":"53.0%"},{"v":0.555,"d":"55.5%"},{"v":0.575,"d":"57.5%"},{"v":0.59,"d":"59.0%"},{"v":0.61,"d":"61.0%"},{"v":0.63,"d":"63.0%"}]
[null,"Secondary with sixth form","Large","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.505,"d":"50.5%"},{"v":0.535,"d":"53.5%"},{"v":0.56,"d":"56.0%"},{"v":0.58,"d":"58.0%"},{"v":0.59,"d":"59.0%"},{"v":0.615,"d":"61.5%"},{"v":0.63,"d":"63.0%"}]
[null,"Secondary with sixth form","Large","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.52,"d":"52.0%"},{"v":0.55,"d":"55.0%"},{"v":0.575,"d":"57.5%"},{"v":0.595,"d":"59.5%"},{"v":0.605,"d":"60.5%"},{"v":0.63,"d":"63.0%"},{"v":0.645,"d":"64.5%"}]
[null,"Secondary with sixth form","Large","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.525,"d":"52.5%"},{"v":0.555,"d":"55.5%"},{"v":0.585,"d":"58.5%"},{"v":0.6,"d":"60.0%"},{"v":0.615,"d":"61.5%"},{"v":0.635,"d":"63.5%"},{"v":0.655,"d":"65.5%"}]
[null,"Secondary with sixth form","Large","Low FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.01,"d":"1.0%"},{"v":0.01,"d":"1.0%"},{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"},{"v":0.03,"d":"3.0%"}]
[null,"Secondary with sixth form","Large","Low FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.075,"d":"7.5%"},{"v":0.08,"d":"8.0%"},{"v":0.09,"d":"9.0%"},{"v":0.11,"d":"11.0%"},{"v":0.12,"d":"12.0%"}]
[null,"Secondary with sixth form","Large","Low FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.065,"d":"6.5%"},null,{"v":0.08,"d":"8.0%"},{"v":0.095,"d":"9.5%"}]
[null,"Secondary with sixth form","Large","Low FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.015,"d":"1.5%"},null,{"v":0.035,"d":"3.5%"},{"v":0.055,"d":"5.5%"}]
[null,"Secondary with sixth form","Large","Low FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.055,"d":"5.5%"},null,{"v":0.065,"d":"6.5%"},{"v":0.085,"d":"8.5%"}]
[null,"Secondary with sixth form","Large","Low FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.05,"d":"5.0%"},{"v":0.055,"d":"5.5%"},{"v":0.07,"d":"7.0%"},{"v":0.08,"d":"8.0%"},{"v":0.085,"d":"8.5%"}]
[null,"Secondary with sixth form","Large","Low FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Secondary with sixth form","Large","Low FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.05,"d":"5.0%"},{"v":0.055,"d":"5.5%"},{"v":0.055,"d":"5.5%"},{"v":0.065,"d":"6.5%"},{"v":0.075,"d":"7.5%"}]
[null,"Secondary with sixth form","Large","Low FSM","Pupil to teacher ratio",15.5,{"v":16,"d":"16.0"},16.5,{"v":17,"d":"17.0"},{"v":17,"d":"17.0"},{"v":18,"d":"18.0"},18.5]
[null,"Secondary with sixth form","Large","Low FSM","Pupil to adult ratio",{"v":9,"d":"9.0"},9.5,{"v":10,"d":"10.0"},10.5,10.5,11.5,{"v":12,"d":"12.0"}]
[null,"Secondary with sixth form","Large","Low FSM","Average class size",19.5,{"v":20,"d":"20.0"},20.5,{"v":21,"d":"21.0"},21.5,22.5,23.5]
[]
[36,"Secondary without sixth form","Small","Low FSM","SSL"]
[null,"Secondary without sixth form","Small","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.46,"d":"46.0%"},{"v":0.505,"d":"50.5%"},{"v":0.54,"d":"54.0%"},{"v":0.545,"d":"54.5%"},{"v":0.56,"d":"56.0%"},{"v":0.585,"d":"58.5%"},{"v":0.6,"d":"60.0%"}]
[null,"Secondary without sixth form","Small","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.465,"d":"46.5%"},{"v":0.51,"d":"51.0%"},{"v":0.54,"d":"54.0%"},{"v":0.55,"d":"55.0%"},{"v":0.565,"d":"56.5%"},{"v":0.585,"d":"58.5%"},{"v":0.605,"d":"60.5%"}]
[null,"Secondary without sixth form","Small","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.48,"d":"48.0%"},{"v":0.525,"d":"52.5%"},{"v":0.555,"d":"55.5%"},{"v":0.565,"d":"56.5%"},{"v":0.58,"d":"58.0%"},{"v":0.6,"d":"60.0%"},{"v":0.62,"d":"62.0%"}]
[null,"Secondary without sixth form","Small","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.49,"d":"49.0%"},{"v":0.53,"d":"53.0%"},{"v":0.565,"d":"56.5%"},{"v":0.575,"d":"57.5%"},{"v":0.585,"d":"58.5%"},{"v":0.61,"d":"61.0%"},{"v":0.625,"d":"62.5%"}]
[null,"Secondary without sixth form","Small","Low FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.01,"d":"1.0%"},{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"},{"v":0.035,"d":"3.5%"},{"v":0.05,"d":"5.0%"}]
[null,"Secondary without sixth form","Small","Low FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.095,"d":"9.5%"},{"v":0.1,"d":"10.0%"},{"v":0.105,"d":"10.5%"},{"v":0.125,"d":"12.5%"},{"v":0.15,"d":"15.0%"}]
[null,"Secondary without sixth form","Small","Low FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.065,"d":"6.5%"},null,{"v":0.085,"d":"8.5%"},{"v":0.09,"d":"9.0%"}]
[null,"Secondary without sixth form","Small","Low FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.02,"d":"2.0%"},null,{"v":0.04,"d":"4.0%"},{"v":0.065,"d":"6.5%"}]
[null,"Secondary without sixth form","Small","Low FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.055,"d":"5.5%"},null,{"v":0.08,"d":"8.0%"},{"v":0.09,"d":"9.0%"}]
[null,"Secondary without sixth form","Small","Low FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.035,"d":"3.5%"},{"v":0.04,"d":"4.0%"},{"v":0.055,"d":"5.5%"},{"v":0.06,"d":"6.0%"},{"v":0.065,"d":"6.5%"}]
[null,"Secondary without sixth form","Small","Low FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Secondary without sixth form","Small","Low FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.07,"d":"7.0%"},{"v":0.085,"d":"8.5%"},{"v":0.09,"d":"9.0%"},{"v":0.105,"d":"10.5%"},{"v":0.12,"d":"12.0%"}]
[null,"Secondary without sixth form","Small","Low FSM","Pupil to teacher ratio",13.5,15.5,{"v":17,"d":"17.0"},17.5,18.5,{"v":20,"d":"20.0"},20.5]
[null,"Secondary without sixth form","Small","Low FSM","Pupil to adult ratio",7.5,8.5,9.5,9.5,10.5,{"v":11,"d":"11.0"},11.5]
[null,"Secondary without sixth form","Small","Low FSM","Average class size",19.5,{"v":22,"d":"22.0"},23.5,24.5,25.5,{"v":27,"d":"27.0"},27.5]
[]
[95,"Secondary without sixth form","Medium","Low FSM","SML"]
[null,"Secondary without sixth form","Medium","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.495,"d":"49.5%"},{"v":0.515,"d":"51.5%"},{"v":0.55,"d":"55.0%"},{"v":0.56,"d":"56.0%"},{"v":0.57,"d":"57.0%"},{"v":0.595,"d":"59.5%"},{"v":0.62,"d":"62.0%"}]
[null,"Secondary without sixth form","Medium","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.495,"d":"49.5%"},{"v":0.52,"d":"52.0%"},{"v":0.55,"d":"55.0%"},{"v":0.565,"d":"56.5%"},{"v":0.575,"d":"57.5%"},{"v":0.6,"d":"60.0%"},{"v":0.62,"d":"62.0%"}]
[null,"Secondary without sixth form","Medium","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.51,"d":"51.0%"},{"v":0.53,"d":"53.0%"},{"v":0.565,"d":"56.5%"},{"v":0.58,"d":"58.0%"},{"v":0.59,"d":"59.0%"},{"v":0.615,"d":"61.5%"},{"v":0.635,"d":"63.5%"}]
[null,"Secondary without sixth form","Medium","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.52,"d":"52.0%"},{"v":0.54,"d":"54.0%"},{"v":0.575,"d":"57.5%"},{"v":0.585,"d":"58.5%"},{"v":0.595,"d":"59.5%"},{"v":0.62,"d":"62.0%"},{"v":0.645,"d":"64.5%"}]
[null,"Secondary without sixth form","Medium","Low FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.015,"d":"1.5%"},{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"},{"v":0.025,"d":"2.5%"},{"v":0.035,"d":"3.5%"}]
[null,"Secondary without sixth form","Medium","Low FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.085,"d":"8.5%"},{"v":0.09,"d":"9.0%"},{"v":0.1,"d":"10.0%"},{"v":0.12,"d":"12.0%"},{"v":0.14,"d":"14.0%"}]
[null,"Secondary without sixth form","Medium","Low FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.065,"d":"6.5%"},null,{"v":0.08,"d":"8.0%"},{"v":0.09,"d":"9.0%"}]
[null,"Secondary without sixth form","Medium","Low FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.015,"d":"1.5%"},null,{"v":0.03,"d":"3.0%"},{"v":0.04,"d":"4.0%"}]
[null,"Secondary without sixth form","Medium","Low FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.055,"d":"5.5%"},null,{"v":0.07,"d":"7.0%"},{"v":0.09,"d":"9.0%"}]
[null,"Secondary without sixth form","Medium","Low FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.045,"d":"4.5%"},{"v":0.05,"d":"5.0%"},{"v":0.06,"d":"6.0%"},{"v":0.065,"d":"6.5%"},{"v":0.07,"d":"7.0%"}]
[null,"Secondary without sixth form","Medium","Low FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Secondary without sixth form","Medium","Low FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.06,"d":"6.0%"},{"v":0.06,"d":"6.0%"},{"v":0.07,"d":"7.0%"},{"v":0.085,"d":"8.5%"},{"v":0.1,"d":"10.0%"}]
[null,"Secondary without sixth form","Medium","Low FSM","Pupil to teacher ratio",15.5,{"v":16,"d":"16.0"},{"v":17,"d":"17.0"},{"v":17,"d":"17.0"},17.5,18.5,{"v":20,"d":"20.0"}]
[null,"Secondary without sixth form","Medium","Low FSM","Pupil to adult ratio",{"v":9,"d":"9.0"},9.5,{"v":10,"d":"10.0"},{"v":10,"d":"10.0"},10.5,{"v":11,"d":"11.0"},{"v":12,"d":"12.0"}]
[null,"Secondary without sixth form","Medium","Low FSM","Average class size",{"v":22,"d":"22.0"},22.5,23.5,{"v":24,"d":"24.0"},{"v":24,"d":"24.0"},25.5,{"v":26,"d":"26.0"}]
[]
[65,"Secondary without sixth form","Large","Low FSM","SLL"]
[null,"Secondary without sixth form","Large","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.485,"d":"48.5%"},{"v":0.51,"d":"51.0%"},{"v":0.545,"d":"54.5%"},{"v":0.56,"d":"56.0%"},{"v":0.575,"d":"57.5%"},{"v":0.595,"d":"59.5%"},{"v":0.605,"d":"60.5%"}]
[null,"Secondary without sixth form","Large","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.49,"d":"49.0%"},{"v":0.515,"d":"51.5%"},{"v":0.55,"d":"55.0%"},{"v":0.565,"d":"56.5%"},{"v":0.575,"d":"57.5%"},{"v":0.6,"d":"60.0%"},{"v":0.61,"d":"61.0%"}]
[null,"Secondary without sixth form","Large","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.505,"d":"50.5%"},{"v":0.53,"d":"53.0%"},{"v":0.565,"d":"56.5%"},{"v":0.58,"d":"58.0%"},{"v":0.59,"d":"59.0%"},{"v":0.61,"d":"61.0%"},{"v":0.625,"d":"62.5%"}]
[null,"Secondary without sixth form","Large","Low FSM","Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.51,"d":"51.0%"},{"v":0.535,"d":"53.5%"},{"v":0.575,"d":"57.5%"},{"v":0.585,"d":"58.5%"},{"v":0.6,"d":"60.0%"},{"v":0.62,"d":"62.0%"},{"v":0.63,"d":"63.0%"}]
[null,"Secondary without sixth form","Large","Low FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.01,"d":"1.0%"},{"v":0.015,"d":"1.5%"},{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"},{"v":0.03,"d":"3.0%"}]
[null,"Secondary without sixth form","Large","Low FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.08,"d":"8.0%"},{"v":0.085,"d":"8.5%"},{"v":0.095,"d":"9.5%"},{"v":0.11,"d":"11.0%"},{"v":0.125,"d":"12.5%"}]
[null,"Secondary without sixth form","Large","Low FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.065,"d":"6.5%"},null,{"v":0.08,"d":"8.0%"},{"v":0.1,"d":"10.0%"}]
[null,"Secondary without sixth form","Large","Low FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.02,"d":"2.0%"},null,{"v":0.04,"d":"4.0%"},{"v":0.055,"d":"5.5%"}]
[null,"Secondary without sixth form","Large","Low FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.055,"d":"5.5%"},null,{"v":0.07,"d":"7.0%"},{"v":0.08,"d":"8.0%"}]
[null,"Secondary without sixth form","Large","Low FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.045,"d":"4.5%"},{"v":0.05,"d":"5.0%"},{"v":0.065,"d":"6.5%"},{"v":0.07,"d":"7.0%"},{"v":0.08,"d":"8.0%"}]
[null,"Secondary without sixth form","Large","Low FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Secondary without sixth form","Large","Low FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.05,"d":"5.0%"},{"v":0.055,"d":"5.5%"},{"v":0.06,"d":"6.0%"},{"v":0.075,"d":"7.5%"},{"v":0.09,"d":"9.0%"}]
[null,"Secondary without sixth form","Large","Low FSM","Pupil to teacher ratio",15.5,{"v":16,"d":"16.0"},16.5,{"v":17,"d":"17.0"},17.5,{"v":18,"d":"18.0"},18.5]
[null,"Secondary without sixth form","Large","Low FSM","Pupil to adult ratio",{"v":9,"d":"9.0"},9.5,{"v":10,"d":"10.0"},{"v":10,"d":"10.0"},10.5,{"v":11,"d":"11.0"},11.5]
[null,"Secondary without sixth form","Large","Low FSM","Average class size",22.5,{"v":23,"d":"23.0"},23.5,23.5,{"v":24,"d":"24.0"},{"v":25,"d":"25.0"},25.5]
[]
[278,"Secondary with sixth form","Small","Medium FSM","SSSM"]
[null,"Secondary with sixth form","Small","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.42,"d":"42.0%"},{"v":0.47,"d":"47.0%"},{"v":0.505,"d":"50.5%"},{"v":0.53,"d":"53.0%"},{"v":0.54,"d":"54.0%"},{"v":0.58,"d":"58.0%"},{"v":0.62,"d":"62.0%"}]
[null,"Secondary with sixth form","Small","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.42,"d":"42.0%"},{"v":0.47,"d":"47.0%"},{"v":0.51,"d":"51.0%"},{"v":0.53,"d":"53.0%"},{"v":0.545,"d":"54.5%"},{"v":0.585,"d":"58.5%"},{"v":0.62,"d":"62.0%"}]
[null,"Secondary with sixth form","Small","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.435,"d":"43.5%"},{"v":0.485,"d":"48.5%"},{"v":0.525,"d":"52.5%"},{"v":0.545,"d":"54.5%"},{"v":0.56,"d":"56.0%"},{"v":0.6,"d":"60.0%"},{"v":0.635,"d":"63.5%"}]
[null,"Secondary with sixth form","Small","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.445,"d":"44.5%"},{"v":0.495,"d":"49.5%"},{"v":0.535,"d":"53.5%"},{"v":0.555,"d":"55.5%"},{"v":0.57,"d":"57.0%"},{"v":0.605,"d":"60.5%"},{"v":0.645,"d":"64.5%"}]
[null,"Secondary with sixth form","Small","Medium FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.015,"d":"1.5%"},{"v":0.015,"d":"1.5%"},{"v":0.025,"d":"2.5%"},{"v":0.035,"d":"3.5%"},{"v":0.05,"d":"5.0%"}]
[null,"Secondary with sixth form","Small","Medium FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.07,"d":"7.0%"},{"v":0.08,"d":"8.0%"},{"v":0.095,"d":"9.5%"},{"v":0.12,"d":"12.0%"},{"v":0.14,"d":"14.0%"}]
[null,"Secondary with sixth form","Small","Medium FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.07,"d":"7.0%"},null,{"v":0.095,"d":"9.5%"},{"v":0.115,"d":"11.5%"}]
[null,"Secondary with sixth form","Small","Medium FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.015,"d":"1.5%"},null,{"v":0.03,"d":"3.0%"},{"v":0.05,"d":"5.0%"}]
[null,"Secondary with sixth form","Small","Medium FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.055,"d":"5.5%"},null,{"v":0.07,"d":"7.0%"},{"v":0.09,"d":"9.0%"}]
[null,"Secondary with sixth form","Small","Medium FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.04,"d":"4.0%"},{"v":0.045,"d":"4.5%"},{"v":0.06,"d":"6.0%"},{"v":0.065,"d":"6.5%"},{"v":0.07,"d":"7.0%"}]
[null,"Secondary with sixth form","Small","Medium FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Secondary with sixth form","Small","Medium FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.07,"d":"7.0%"},{"v":0.075,"d":"7.5%"},{"v":0.09,"d":"9.0%"},{"v":0.115,"d":"11.5%"},{"v":0.165,"d":"16.5%"}]
[null,"Secondary with sixth form","Small","Medium FSM","Pupil to teacher ratio",{"v":12,"d":"12.0"},{"v":13,"d":"13.0"},{"v":15,"d":"15.0"},{"v":15,"d":"15.0"},{"v":16,"d":"16.0"},{"v":17,"d":"17.0"},{"v":18,"d":"18.0"}]
[null,"Secondary with sixth form","Small","Medium FSM","Pupil to adult ratio",{"v":7,"d":"7.0"},{"v":8,"d":"8.0"},8.5,{"v":9,"d":"9.0"},9.5,{"v":10,"d":"10.0"},{"v":11,"d":"11.0"}]
[null,"Secondary with sixth form","Small","Medium FSM","Average class size",{"v":15,"d":"15.0"},{"v":17,"d":"17.0"},{"v":19,"d":"19.0"},19.5,20.5,{"v":23,"d":"23.0"},24.5]
[]
[522,"Secondary with sixth form","Medium","Medium FSM","SSMM"]
[null,"Secondary with sixth form","Medium","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.485,"d":"48.5%"},{"v":0.515,"d":"51.5%"},{"v":0.55,"d":"55.0%"},{"v":0.56,"d":"56.0%"},{"v":0.575,"d":"57.5%"},{"v":0.6,"d":"60.0%"},{"v":0.62,"d":"62.0%"}]
[null,"Secondary with sixth form","Medium","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.49,"d":"49.0%"},{"v":0.52,"d":"52.0%"},{"v":0.555,"d":"55.5%"},{"v":0.565,"d":"56.5%"},{"v":0.58,"d":"58.0%"},{"v":0.605,"d":"60.5%"},{"v":0.625,"d":"62.5%"}]
[null,"Secondary with sixth form","Medium","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.505,"d":"50.5%"},{"v":0.535,"d":"53.5%"},{"v":0.57,"d":"57.0%"},{"v":0.58,"d":"58.0%"},{"v":0.595,"d":"59.5%"},{"v":0.62,"d":"62.0%"},{"v":0.635,"d":"63.5%"}]
[null,"Secondary with sixth form","Medium","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.515,"d":"51.5%"},{"v":0.54,"d":"54.0%"},{"v":0.575,"d":"57.5%"},{"v":0.59,"d":"59.0%"},{"v":0.6,"d":"60.0%"},{"v":0.625,"d":"62.5%"},{"v":0.645,"d":"64.5%"}]
[null,"Secondary with sixth form","Medium","Medium FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.015,"d":"1.5%"},{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"},{"v":0.03,"d":"3.0%"},{"v":0.04,"d":"4.0%"}]
[null,"Secondary with sixth form","Medium","Medium FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.08,"d":"8.0%"},{"v":0.09,"d":"9.0%"},{"v":0.1,"d":"10.0%"},{"v":0.12,"d":"12.0%"},{"v":0.135,"d":"13.5%"}]
[null,"Secondary with sixth form","Medium","Medium FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.065,"d":"6.5%"},null,{"v":0.08,"d":"8.0%"},{"v":0.1,"d":"10.0%"}]
[null,"Secondary with sixth form","Medium","Medium FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.015,"d":"1.5%"},null,{"v":0.03,"d":"3.0%"},{"v":0.05,"d":"5.0%"}]
[null,"Secondary with sixth form","Medium","Medium FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.055,"d":"5.5%"},null,{"v":0.07,"d":"7.0%"},{"v":0.08,"d":"8.0%"}]
[null,"Secondary with sixth form","Medium","Medium FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.045,"d":"4.5%"},{"v":0.05,"d":"5.0%"},{"v":0.06,"d":"6.0%"},{"v":0.065,"d":"6.5%"},{"v":0.07,"d":"7.0%"}]
[null,"Secondary with sixth form","Medium","Medium FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Secondary with sixth form","Medium","Medium FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.055,"d":"5.5%"},{"v":0.065,"d":"6.5%"},{"v":0.07,"d":"7.0%"},{"v":0.08,"d":"8.0%"},{"v":0.095,"d":"9.5%"}]
[null,"Secondary with sixth form","Medium","Medium FSM","Pupil to teacher ratio",{"v":14,"d":"14.0"},14.5,15.5,{"v":16,"d":"16.0"},16.5,{"v":17,"d":"17.0"},{"v":18,"d":"18.0"}]
[null,"Secondary with sixth form","Medium","Medium FSM","Pupil to adult ratio",{"v":8,"d":"8.0"},8.5,{"v":9,"d":"9.0"},9.5,{"v":10,"d":"10.0"},10.5,{"v":11,"d":"11.0"}]
[null,"Secondary with sixth form","Medium","Medium FSM","Average class size",18.5,19.5,{"v":20,"d":"20.0"},20.5,{"v":21,"d":"21.0"},{"v":22,"d":"22.0"},{"v":23,"d":"23.0"}]
[]
[276,"Secondary with sixth form","Large","Medium FSM","SSLM"]
[null,"Secondary with sixth form","Large","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.5,"d":"50.0%"},{"v":0.525,"d":"52.5%"},{"v":0.555,"d":"55.5%"},{"v":0.565,"d":"56.5%"},{"v":0.58,"d":"58.0%"},{"v":0.61,"d":"61.0%"},{"v":0.635,"d":"63.5%"}]
[null,"Secondary with sixth form","Large","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.505,"d":"50.5%"},{"v":0.53,"d":"53.0%"},{"v":0.56,"d":"56.0%"},{"v":0.57,"d":"57.0%"},{"v":0.585,"d":"58.5%"},{"v":0.615,"d":"61.5%"},{"v":0.64,"d":"64.0%"}]
[null,"Secondary with sixth form","Large","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.52,"d":"52.0%"},{"v":0.545,"d":"54.5%"},{"v":0.575,"d":"57.5%"},{"v":0.585,"d":"58.5%"},{"v":0.595,"d":"59.5%"},{"v":0.63,"d":"63.0%"},{"v":0.65,"d":"65.0%"}]
[null,"Secondary with sixth form","Large","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.525,"d":"52.5%"},{"v":0.555,"d":"55.5%"},{"v":0.58,"d":"58.0%"},{"v":0.59,"d":"59.0%"},{"v":0.605,"d":"60.5%"},{"v":0.635,"d":"63.5%"},{"v":0.66,"d":"66.0%"}]
[null,"Secondary with sixth form","Large","Medium FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.01,"d":"1.0%"},{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"},{"v":0.03,"d":"3.0%"},{"v":0.04,"d":"4.0%"}]
[null,"Secondary with sixth form","Large","Medium FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.085,"d":"8.5%"},{"v":0.09,"d":"9.0%"},{"v":0.1,"d":"10.0%"},{"v":0.115,"d":"11.5%"},{"v":0.13,"d":"13.0%"}]
[null,"Secondary with sixth form","Large","Medium FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.06,"d":"6.0%"},null,{"v":0.08,"d":"8.0%"},{"v":0.1,"d":"10.0%"}]
[null,"Secondary with sixth form","Large","Medium FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.015,"d":"1.5%"},null,{"v":0.03,"d":"3.0%"},{"v":0.05,"d":"5.0%"}]
[null,"Secondary with sixth form","Large","Medium FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.05,"d":"5.0%"},null,{"v":0.065,"d":"6.5%"},{"v":0.085,"d":"8.5%"}]
[null,"Secondary with sixth form","Large","Medium FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.045,"d":"4.5%"},{"v":0.05,"d":"5.0%"},{"v":0.065,"d":"6.5%"},{"v":0.065,"d":"6.5%"},{"v":0.075,"d":"7.5%"}]
[null,"Secondary with sixth form","Large","Medium FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Secondary with sixth form","Large","Medium FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.05,"d":"5.0%"},{"v":0.055,"d":"5.5%"},{"v":0.06,"d":"6.0%"},{"v":0.07,"d":"7.0%"},{"v":0.08,"d":"8.0%"}]
[null,"Secondary with sixth form","Large","Medium FSM","Pupil to teacher ratio",{"v":14,"d":"14.0"},{"v":15,"d":"15.0"},{"v":16,"d":"16.0"},{"v":16,"d":"16.0"},16.5,17.5,{"v":18,"d":"18.0"}]
[null,"Secondary with sixth form","Large","Medium FSM","Pupil to adult ratio",8.5,{"v":9,"d":"9.0"},9.5,{"v":10,"d":"10.0"},{"v":10,"d":"10.0"},{"v":11,"d":"11.0"},11.5]
[null,"Secondary with sixth form","Large","Medium FSM","Average class size",{"v":19,"d":"19.0"},19.5,20.5,{"v":21,"d":"21.0"},{"v":21,"d":"21.0"},{"v":22,"d":"22.0"},{"v":23,"d":"23.0"}]
[]
[113,"Secondary without sixth form","Small","Medium FSM","SSM"]
[null,"Secondary without sixth form","Small","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.445,"d":"44.5%"},{"v":0.47,"d":"47.0%"},{"v":0.505,"d":"50.5%"},{"v":0.525,"d":"52.5%"},{"v":0.545,"d":"54.5%"},{"v":0.57,"d":"57.0%"},{"v":0.59,"d":"59.0%"}]
[null,"Secondary without sixth form","Small","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.45,"d":"45.0%"},{"v":0.47,"d":"47.0%"},{"v":0.51,"d":"51.0%"},{"v":0.53,"d":"53.0%"},{"v":0.55,"d":"55.0%"},{"v":0.575,"d":"57.5%"},{"v":0.59,"d":"59.0%"}]
[null,"Secondary without sixth form","Small","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.465,"d":"46.5%"},{"v":0.485,"d":"48.5%"},{"v":0.525,"d":"52.5%"},{"v":0.545,"d":"54.5%"},{"v":0.565,"d":"56.5%"},{"v":0.59,"d":"59.0%"},{"v":0.605,"d":"60.5%"}]
[null,"Secondary without sixth form","Small","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.47,"d":"47.0%"},{"v":0.495,"d":"49.5%"},{"v":0.535,"d":"53.5%"},{"v":0.55,"d":"55.0%"},{"v":0.57,"d":"57.0%"},{"v":0.595,"d":"59.5%"},{"v":0.615,"d":"61.5%"}]
[null,"Secondary without sixth form","Small","Medium FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"},{"v":0.025,"d":"2.5%"},{"v":0.035,"d":"3.5%"},{"v":0.05,"d":"5.0%"}]
[null,"Secondary without sixth form","Small","Medium FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.09,"d":"9.0%"},{"v":0.095,"d":"9.5%"},{"v":0.11,"d":"11.0%"},{"v":0.13,"d":"13.0%"},{"v":0.145,"d":"14.5%"}]
[null,"Secondary without sixth form","Small","Medium FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.065,"d":"6.5%"},null,{"v":0.09,"d":"9.0%"},{"v":0.1,"d":"10.0%"}]
[null,"Secondary without sixth form","Small","Medium FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.015,"d":"1.5%"},null,{"v":0.04,"d":"4.0%"},{"v":0.06,"d":"6.0%"}]
[null,"Secondary without sixth form","Small","Medium FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.055,"d":"5.5%"},null,{"v":0.075,"d":"7.5%"},{"v":0.085,"d":"8.5%"}]
[null,"Secondary without sixth form","Small","Medium FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.035,"d":"3.5%"},{"v":0.045,"d":"4.5%"},{"v":0.055,"d":"5.5%"},{"v":0.06,"d":"6.0%"},{"v":0.07,"d":"7.0%"}]
[null,"Secondary without sixth form","Small","Medium FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Secondary without sixth form","Small","Medium FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.07,"d":"7.0%"},{"v":0.08,"d":"8.0%"},{"v":0.09,"d":"9.0%"},{"v":0.11,"d":"11.0%"},{"v":0.135,"d":"13.5%"}]
[null,"Secondary without sixth form","Small","Medium FSM","Pupil to teacher ratio",{"v":13,"d":"13.0"},{"v":14,"d":"14.0"},{"v":15,"d":"15.0"},16.5,{"v":17,"d":"17.0"},{"v":18,"d":"18.0"},{"v":20,"d":"20.0"}]
[null,"Secondary without sixth form","Small","Medium FSM","Pupil to adult ratio",{"v":7,"d":"7.0"},7.5,8.5,8.5,{"v":9,"d":"9.0"},{"v":10,"d":"10.0"},{"v":11,"d":"11.0"}]
[null,"Secondary without sixth form","Small","Medium FSM","Average class size",{"v":19,"d":"19.0"},{"v":20,"d":"20.0"},{"v":22,"d":"22.0"},22.5,23.5,24.5,26.5]
[]
[180,"Secondary without sixth form","Medium","Medium FSM","SMM"]
[null,"Secondary without sixth form","Medium","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.47,"d":"47.0%"},{"v":0.495,"d":"49.5%"},{"v":0.525,"d":"52.5%"},{"v":0.535,"d":"53.5%"},{"v":0.545,"d":"54.5%"},{"v":0.57,"d":"57.0%"},{"v":0.595,"d":"59.5%"}]
[null,"Secondary without sixth form","Medium","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.475,"d":"47.5%"},{"v":0.5,"d":"50.0%"},{"v":0.53,"d":"53.0%"},{"v":0.54,"d":"54.0%"},{"v":0.55,"d":"55.0%"},{"v":0.575,"d":"57.5%"},{"v":0.6,"d":"60.0%"}]
[null,"Secondary without sixth form","Medium","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.49,"d":"49.0%"},{"v":0.51,"d":"51.0%"},{"v":0.545,"d":"54.5%"},{"v":0.555,"d":"55.5%"},{"v":0.565,"d":"56.5%"},{"v":0.59,"d":"59.0%"},{"v":0.615,"d":"61.5%"}]
[null,"Secondary without sixth form","Medium","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.5,"d":"50.0%"},{"v":0.52,"d":"52.0%"},{"v":0.55,"d":"55.0%"},{"v":0.565,"d":"56.5%"},{"v":0.57,"d":"57.0%"},{"v":0.595,"d":"59.5%"},{"v":0.62,"d":"62.0%"}]
[null,"Secondary without sixth form","Medium","Medium FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"},{"v":0.025,"d":"2.5%"},{"v":0.035,"d":"3.5%"},{"v":0.045,"d":"4.5%"}]
[null,"Secondary without sixth form","Medium","Medium FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.095,"d":"9.5%"},{"v":0.105,"d":"10.5%"},{"v":0.11,"d":"11.0%"},{"v":0.13,"d":"13.0%"},{"v":0.145,"d":"14.5%"}]
[null,"Secondary without sixth form","Medium","Medium FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.07,"d":"7.0%"},null,{"v":0.09,"d":"9.0%"},{"v":0.105,"d":"10.5%"}]
[null,"Secondary without sixth form","Medium","Medium FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.015,"d":"1.5%"},null,{"v":0.035,"d":"3.5%"},{"v":0.05,"d":"5.0%"}]
[null,"Secondary without sixth form","Medium","Medium FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.06,"d":"6.0%"},null,{"v":0.08,"d":"8.0%"},{"v":0.1,"d":"10.0%"}]
[null,"Secondary without sixth form","Medium","Medium FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.04,"d":"4.0%"},{"v":0.045,"d":"4.5%"},{"v":0.055,"d":"5.5%"},{"v":0.06,"d":"6.0%"},{"v":0.065,"d":"6.5%"}]
[null,"Secondary without sixth form","Medium","Medium FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Secondary without sixth form","Medium","Medium FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.06,"d":"6.0%"},{"v":0.065,"d":"6.5%"},{"v":0.075,"d":"7.5%"},{"v":0.09,"d":"9.0%"},{"v":0.1,"d":"10.0%"}]
[null,"Secondary without sixth form","Medium","Medium FSM","Pupil to teacher ratio",{"v":14,"d":"14.0"},14.5,15.5,{"v":16,"d":"16.0"},16.5,17.5,18.5]
[null,"Secondary without sixth form","Medium","Medium FSM","Pupil to adult ratio",{"v":8,"d":"8.0"},8.5,{"v":9,"d":"9.0"},{"v":9,"d":"9.0"},9.5,10.5,{"v":11,"d":"11.0"}]
[null,"Secondary without sixth form","Medium","Medium FSM","Average class size",20.5,21.5,22.5,{"v":23,"d":"23.0"},{"v":23,"d":"23.0"},{"v":24,"d":"24.0"},{"v":25,"d":"25.0"}]
[]
[101,"Secondary without sixth form","Large","Medium FSM","SLM"]
[null,"Secondary without sixth form","Large","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.455,"d":"45.5%"},{"v":0.48,"d":"48.0%"},{"v":0.51,"d":"51.0%"},{"v":0.53,"d":"53.0%"},{"v":0.545,"d":"54.5%"},{"v":0.575,"d":"57.5%"},{"v":0.59,"d":"59.0%"}]
[null,"Secondary without sixth form","Large","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.455,"d":"45.5%"},{"v":0.485,"d":"48.5%"},{"v":0.515,"d":"51.5%"},{"v":0.535,"d":"53.5%"},{"v":0.545,"d":"54.5%"},{"v":0.575,"d":"57.5%"},{"v":0.595,"d":"59.5%"}]
[null,"Secondary without sixth form","Large","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.47,"d":"47.0%"},{"v":0.5,"d":"50.0%"},{"v":0.53,"d":"53.0%"},{"v":0.55,"d":"55.0%"},{"v":0.56,"d":"56.0%"},{"v":0.59,"d":"59.0%"},{"v":0.605,"d":"60.5%"}]
[null,"Secondary without sixth form","Large","Medium FSM","Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.48,"d":"48.0%"},{"v":0.505,"d":"50.5%"},{"v":0.535,"d":"53.5%"},{"v":0.56,"d":"56.0%"},{"v":0.57,"d":"57.0%"},{"v":0.6,"d":"60.0%"},{"v":0.615,"d":"61.5%"}]
[null,"Secondary without sixth form","Large","Medium FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"},{"v":0.025,"d":"2.5%"},{"v":0.035,"d":"3.5%"},{"v":0.045,"d":"4.5%"}]
[null,"Secondary without sixth form","Large","Medium FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.105,"d":"10.5%"},{"v":0.11,"d":"11.0%"},{"v":0.12,"d":"12.0%"},{"v":0.14,"d":"14.0%"},{"v":0.155,"d":"15.5%"}]
[null,"Secondary without sixth form","Large","Medium FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.06,"d":"6.0%"},null,{"v":0.08,"d":"8.0%"},{"v":0.1,"d":"10.0%"}]
[null,"Secondary without sixth form","Large","Medium FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.015,"d":"1.5%"},null,{"v":0.03,"d":"3.0%"},{"v":0.06,"d":"6.0%"}]
[null,"Secondary without sixth form","Large","Medium FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.055,"d":"5.5%"},null,{"v":0.07,"d":"7.0%"},{"v":0.09,"d":"9.0%"}]
[null,"Secondary without sixth form","Large","Medium FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.035,"d":"3.5%"},{"v":0.04,"d":"4.0%"},{"v":0.055,"d":"5.5%"},{"v":0.06,"d":"6.0%"},{"v":0.065,"d":"6.5%"}]
[null,"Secondary without sixth form","Large","Medium FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Secondary without sixth form","Large","Medium FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.055,"d":"5.5%"},{"v":0.06,"d":"6.0%"},{"v":0.065,"d":"6.5%"},{"v":0.075,"d":"7.5%"},{"v":0.09,"d":"9.0%"}]
[null,"Secondary without sixth form","Large","Medium FSM","Pupil to teacher ratio",{"v":14,"d":"14.0"},{"v":15,"d":"15.0"},{"v":16,"d":"16.0"},16.5,16.5,17.5,18.5]
[null,"Secondary without sixth form","Large","Medium FSM","Pupil to adult ratio",{"v":8,"d":"8.0"},8.5,{"v":9,"d":"9.0"},{"v":9,"d":"9.0"},9.5,{"v":10,"d":"10.0"},10.5]
[null,"Secondary without sixth form","Large","Medium FSM","Average class size",21.5,{"v":22,"d":"22.0"},{"v":23,"d":"23.0"},23.5,23.5,24.5,25.5]
[]
[203,"Secondary with sixth form","Small","High FSM","SSSH"]
[null,"Secondary with sixth form","Small","High FSM","Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.425,"d":"42.5%"},{"v":0.455,"d":"45.5%"},{"v":0.49,"d":"49.0%"},{"v":0.515,"d":"51.5%"},{"v":0.525,"d":"52.5%"},{"v":0.56,"d":"56.0%"},{"v":0.605,"d":"60.5%"}]
[null,"Secondary with sixth form","Small","High FSM","Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.43,"d":"43.0%"},{"v":0.46,"d":"46.0%"},{"v":0.495,"d":"49.5%"},{"v":0.515,"d":"51.5%"},{"v":0.525,"d":"52.5%"},{"v":0.56,"d":"56.0%"},{"v":0.61,"d":"61.0%"}]
[null,"Secondary with sixth form","Small","High FSM","Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.44,"d":"44.0%"},{"v":0.47,"d":"47.0%"},{"v":0.51,"d":"51.0%"},{"v":0.53,"d":"53.0%"},{"v":0.54,"d":"54.0%"},{"v":0.575,"d":"57.5%"},{"v":0.62,"d":"62.0%"}]
[null,"Secondary with sixth form","Small","High FSM","Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.45,"d":"45.0%"},{"v":0.48,"d":"48.0%"},{"v":0.52,"d":"52.0%"},{"v":0.54,"d":"54.0%"},{"v":0.55,"d":"55.0%"},{"v":0.585,"d":"58.5%"},{"v":0.63,"d":"63.0%"}]
[null,"Secondary with sixth form","Small","High FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"},{"v":0.03,"d":"3.0%"},{"v":0.045,"d":"4.5%"},{"v":0.06,"d":"6.0%"}]
[null,"Secondary with sixth form","Small","High FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.085,"d":"8.5%"},{"v":0.095,"d":"9.5%"},{"v":0.105,"d":"10.5%"},{"v":0.13,"d":"13.0%"},{"v":0.15,"d":"15.0%"}]
[null,"Secondary with sixth form","Small","High FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.07,"d":"7.0%"},null,{"v":0.105,"d":"10.5%"},{"v":0.13,"d":"13.0%"}]
[null,"Secondary with sixth form","Small","High FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.015,"d":"1.5%"},null,{"v":0.035,"d":"3.5%"},{"v":0.045,"d":"4.5%"}]
[null,"Secondary with sixth form","Small","High FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.06,"d":"6.0%"},null,{"v":0.085,"d":"8.5%"},{"v":0.1,"d":"10.0%"}]
[null,"Secondary with sixth form","Small","High FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.035,"d":"3.5%"},{"v":0.04,"d":"4.0%"},{"v":0.055,"d":"5.5%"},{"v":0.06,"d":"6.0%"},{"v":0.065,"d":"6.5%"}]
[null,"Secondary with sixth form","Small","High FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Secondary with sixth form","Small","High FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.07,"d":"7.0%"},{"v":0.075,"d":"7.5%"},{"v":0.08,"d":"8.0%"},{"v":0.105,"d":"10.5%"},{"v":0.125,"d":"12.5%"}]
[null,"Secondary with sixth form","Small","High FSM","Pupil to teacher ratio",11.5,12.5,13.5,14.5,{"v":15,"d":"15.0"},16.5,17.5]
[null,"Secondary with sixth form","Small","High FSM","Pupil to adult ratio",6.5,{"v":7,"d":"7.0"},{"v":8,"d":"8.0"},{"v":8,"d":"8.0"},8.5,9.5,10.5]
[null,"Secondary with sixth form","Small","High FSM","Average class size",{"v":16,"d":"16.0"},17.5,19.5,{"v":20,"d":"20.0"},{"v":21,"d":"21.0"},{"v":23,"d":"23.0"},{"v":24,"d":"24.0"}]
[]
[269,"Secondary with sixth form","Medium","High FSM","SSMH"]
[null,"Secondary with sixth form","Medium","High FSM","Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.45,"d":"45.0%"},{"v":0.485,"d":"48.5%"},{"v":0.515,"d":"51.5%"},{"v":0.53,"d":"53.0%"},{"v":0.54,"d":"54.0%"},{"v":0.575,"d":"57.5%"},{"v":0.61,"d":"61.0%"}]
[null,"Secondary with sixth form","Medium","High FSM","Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.455,"d":"45.5%"},{"v":0.49,"d":"49.0%"},{"v":0.52,"d":"52.0%"},{"v":0.535,"d":"53.5%"},{"v":0.545,"d":"54.5%"},{"v":0.58,"d":"58.0%"},{"v":0.61,"d":"61.0%"}]
[null,"Secondary with sixth form","Medium","High FSM","Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.47,"d":"47.0%"},{"v":0.505,"d":"50.5%"},{"v":0.535,"d":"53.5%"},{"v":0.55,"d":"55.0%"},{"v":0.56,"d":"56.0%"},{"v":0.595,"d":"59.5%"},{"v":0.625,"d":"62.5%"}]
[null,"Secondary with sixth form","Medium","High FSM","Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.475,"d":"47.5%"},{"v":0.51,"d":"51.0%"},{"v":0.545,"d":"54.5%"},{"v":0.56,"d":"56.0%"},{"v":0.565,"d":"56.5%"},{"v":0.6,"d":"60.0%"},{"v":0.635,"d":"63.5%"}]
[null,"Secondary with sixth form","Medium","High FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"},{"v":0.025,"d":"2.5%"},{"v":0.035,"d":"3.5%"},{"v":0.045,"d":"4.5%"}]
[null,"Secondary with sixth form","Medium","High FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.095,"d":"9.5%"},{"v":0.105,"d":"10.5%"},{"v":0.115,"d":"11.5%"},{"v":0.135,"d":"13.5%"},{"v":0.15,"d":"15.0%"}]
[null,"Secondary with sixth form","Medium","High FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.065,"d":"6.5%"},null,{"v":0.085,"d":"8.5%"},{"v":0.105,"d":"10.5%"}]
[null,"Secondary with sixth form","Medium","High FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.02,"d":"2.0%"},null,{"v":0.03,"d":"3.0%"},{"v":0.05,"d":"5.0%"}]
[null,"Secondary with sixth form","Medium","High FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.055,"d":"5.5%"},null,{"v":0.075,"d":"7.5%"},{"v":0.1,"d":"10.0%"}]
[null,"Secondary with sixth form","Medium","High FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.04,"d":"4.0%"},{"v":0.045,"d":"4.5%"},{"v":0.055,"d":"5.5%"},{"v":0.06,"d":"6.0%"},{"v":0.065,"d":"6.5%"}]
[null,"Secondary with sixth form","Medium","High FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Secondary with sixth form","Medium","High FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.065,"d":"6.5%"},{"v":0.07,"d":"7.0%"},{"v":0.075,"d":"7.5%"},{"v":0.09,"d":"9.0%"},{"v":0.105,"d":"10.5%"}]
[null,"Secondary with sixth form","Medium","High FSM","Pupil to teacher ratio",12.5,{"v":13,"d":"13.0"},{"v":14,"d":"14.0"},14.5,{"v":15,"d":"15.0"},16.5,17.5]
[null,"Secondary with sixth form","Medium","High FSM","Pupil to adult ratio",{"v":7,"d":"7.0"},{"v":8,"d":"8.0"},8.5,8.5,{"v":9,"d":"9.0"},{"v":10,"d":"10.0"},10.5]
[null,"Secondary with sixth form","Medium","High FSM","Average class size",{"v":18,"d":"18.0"},18.5,{"v":20,"d":"20.0"},{"v":20,"d":"20.0"},20.5,21.5,{"v":23,"d":"23.0"}]
[]
[64,"Secondary with sixth form","Large","High FSM","SSLH"]
[null,"Secondary with sixth form","Large","High FSM","Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.47,"d":"47.0%"},{"v":0.5,"d":"50.0%"},{"v":0.52,"d":"52.0%"},{"v":0.53,"d":"53.0%"},{"v":0.55,"d":"55.0%"},{"v":0.57,"d":"57.0%"},{"v":0.59,"d":"59.0%"}]
[null,"Secondary with sixth form","Large","High FSM","Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.475,"d":"47.5%"},{"v":0.5,"d":"50.0%"},{"v":0.525,"d":"52.5%"},{"v":0.53,"d":"53.0%"},{"v":0.55,"d":"55.0%"},{"v":0.575,"d":"57.5%"},{"v":0.59,"d":"59.0%"}]
[null,"Secondary with sixth form","Large","High FSM","Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.49,"d":"49.0%"},{"v":0.515,"d":"51.5%"},{"v":0.54,"d":"54.0%"},{"v":0.545,"d":"54.5%"},{"v":0.565,"d":"56.5%"},{"v":0.59,"d":"59.0%"},{"v":0.605,"d":"60.5%"}]
[null,"Secondary with sixth form","Large","High FSM","Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.495,"d":"49.5%"},{"v":0.525,"d":"52.5%"},{"v":0.545,"d":"54.5%"},{"v":0.555,"d":"55.5%"},{"v":0.575,"d":"57.5%"},{"v":0.595,"d":"59.5%"},{"v":0.615,"d":"61.5%"}]
[null,"Secondary with sixth form","Large","High FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"},{"v":0.025,"d":"2.5%"},{"v":0.035,"d":"3.5%"},{"v":0.045,"d":"4.5%"}]
[null,"Secondary with sixth form","Large","High FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.1,"d":"10.0%"},{"v":0.11,"d":"11.0%"},{"v":0.12,"d":"12.0%"},{"v":0.14,"d":"14.0%"},{"v":0.145,"d":"14.5%"}]
[null,"Secondary with sixth form","Large","High FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.055,"d":"5.5%"},null,{"v":0.075,"d":"7.5%"},{"v":0.085,"d":"8.5%"}]
[null,"Secondary with sixth form","Large","High FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.02,"d":"2.0%"},null,{"v":0.035,"d":"3.5%"},{"v":0.055,"d":"5.5%"}]
[null,"Secondary with sixth form","Large","High FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.055,"d":"5.5%"},null,{"v":0.075,"d":"7.5%"},{"v":0.1,"d":"10.0%"}]
[null,"Secondary with sixth form","Large","High FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.04,"d":"4.0%"},{"v":0.05,"d":"5.0%"},{"v":0.055,"d":"5.5%"},{"v":0.06,"d":"6.0%"},{"v":0.065,"d":"6.5%"}]
[null,"Secondary with sixth form","Large","High FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Secondary with sixth form","Large","High FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.05,"d":"5.0%"},{"v":0.055,"d":"5.5%"},{"v":0.06,"d":"6.0%"},{"v":0.08,"d":"8.0%"},{"v":0.09,"d":"9.0%"}]
[null,"Secondary with sixth form","Large","High FSM","Pupil to teacher ratio",{"v":13,"d":"13.0"},{"v":14,"d":"14.0"},14.5,{"v":15,"d":"15.0"},{"v":15,"d":"15.0"},{"v":16,"d":"16.0"},{"v":17,"d":"17.0"}]
[null,"Secondary with sixth form","Large","High FSM","Pupil to adult ratio",7.5,{"v":8,"d":"8.0"},8.5,{"v":9,"d":"9.0"},9.5,{"v":10,"d":"10.0"},10.5]
[null,"Secondary with sixth form","Large","High FSM","Average class size",18.5,{"v":19,"d":"19.0"},{"v":20,"d":"20.0"},20.5,{"v":21,"d":"21.0"},{"v":22,"d":"22.0"},22.5]
[]
[51,"Secondary without sixth form","Small","High FSM","SSH"]
[null,"Secondary without sixth form","Small","High FSM","Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.42,"d":"42.0%"},{"v":0.45,"d":"45.0%"},{"v":0.475,"d":"47.5%"},{"v":0.485,"d":"48.5%"},{"v":0.495,"d":"49.5%"},{"v":0.53,"d":"53.0%"},{"v":0.57,"d":"57.0%"}]
[null,"Secondary without sixth form","Small","High FSM","Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.425,"d":"42.5%"},{"v":0.455,"d":"45.5%"},{"v":0.48,"d":"48.0%"},{"v":0.49,"d":"49.0%"},{"v":0.5,"d":"50.0%"},{"v":0.53,"d":"53.0%"},{"v":0.575,"d":"57.5%"}]
[null,"Secondary without sixth form","Small","High FSM","Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.44,"d":"44.0%"},{"v":0.47,"d":"47.0%"},{"v":0.495,"d":"49.5%"},{"v":0.505,"d":"50.5%"},{"v":0.51,"d":"51.0%"},{"v":0.545,"d":"54.5%"},{"v":0.59,"d":"59.0%"}]
[null,"Secondary without sixth form","Small","High FSM","Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.45,"d":"45.0%"},{"v":0.475,"d":"47.5%"},{"v":0.5,"d":"50.0%"},{"v":0.515,"d":"51.5%"},{"v":0.52,"d":"52.0%"},{"v":0.555,"d":"55.5%"},{"v":0.595,"d":"59.5%"}]
[null,"Secondary without sixth form","Small","High FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.015,"d":"1.5%"},{"v":0.025,"d":"2.5%"},{"v":0.03,"d":"3.0%"},{"v":0.045,"d":"4.5%"},{"v":0.065,"d":"6.5%"}]
[null,"Secondary without sixth form","Small","High FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.09,"d":"9.0%"},{"v":0.1,"d":"10.0%"},{"v":0.115,"d":"11.5%"},{"v":0.14,"d":"14.0%"},{"v":0.165,"d":"16.5%"}]
[null,"Secondary without sixth form","Small","High FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.075,"d":"7.5%"},null,{"v":0.105,"d":"10.5%"},{"v":0.115,"d":"11.5%"}]
[null,"Secondary without sixth form","Small","High FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.015,"d":"1.5%"},null,{"v":0.035,"d":"3.5%"},{"v":0.05,"d":"5.0%"}]
[null,"Secondary without sixth form","Small","High FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.065,"d":"6.5%"},null,{"v":0.085,"d":"8.5%"},{"v":0.095,"d":"9.5%"}]
[null,"Secondary without sixth form","Small","High FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.025,"d":"2.5%"},{"v":0.04,"d":"4.0%"},{"v":0.05,"d":"5.0%"},{"v":0.055,"d":"5.5%"},{"v":0.06,"d":"6.0%"}]
[null,"Secondary without sixth form","Small","High FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Secondary without sixth form","Small","High FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.08,"d":"8.0%"},{"v":0.085,"d":"8.5%"},{"v":0.095,"d":"9.5%"},{"v":0.125,"d":"12.5%"},{"v":0.14,"d":"14.0%"}]
[null,"Secondary without sixth form","Small","High FSM","Pupil to teacher ratio",10.5,{"v":12,"d":"12.0"},{"v":13,"d":"13.0"},13.5,{"v":14,"d":"14.0"},{"v":16,"d":"16.0"},{"v":17,"d":"17.0"}]
[null,"Secondary without sixth form","Small","High FSM","Pupil to adult ratio",5.5,6.5,{"v":7,"d":"7.0"},7.5,{"v":8,"d":"8.0"},{"v":9,"d":"9.0"},{"v":10,"d":"10.0"}]
[null,"Secondary without sixth form","Small","High FSM","Average class size",17.5,{"v":18,"d":"18.0"},20.5,{"v":21,"d":"21.0"},21.5,23.5,24.5]
[]
[114,"Secondary without sixth form","Medium","High FSM","SMH"]
[null,"Secondary without sixth form","Medium","High FSM","Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.44,"d":"44.0%"},{"v":0.465,"d":"46.5%"},{"v":0.485,"d":"48.5%"},{"v":0.5,"d":"50.0%"},{"v":0.515,"d":"51.5%"},{"v":0.545,"d":"54.5%"},{"v":0.565,"d":"56.5%"}]
[null,"Secondary without sixth form","Medium","High FSM","Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.44,"d":"44.0%"},{"v":0.465,"d":"46.5%"},{"v":0.49,"d":"49.0%"},{"v":0.505,"d":"50.5%"},{"v":0.52,"d":"52.0%"},{"v":0.545,"d":"54.5%"},{"v":0.57,"d":"57.0%"}]
[null,"Secondary without sixth form","Medium","High FSM","Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.455,"d":"45.5%"},{"v":0.48,"d":"48.0%"},{"v":0.505,"d":"50.5%"},{"v":0.52,"d":"52.0%"},{"v":0.53,"d":"53.0%"},{"v":0.56,"d":"56.0%"},{"v":0.585,"d":"58.5%"}]
[null,"Secondary without sixth form","Medium","High FSM","Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.465,"d":"46.5%"},{"v":0.49,"d":"49.0%"},{"v":0.515,"d":"51.5%"},{"v":0.53,"d":"53.0%"},{"v":0.54,"d":"54.0%"},{"v":0.57,"d":"57.0%"},{"v":0.595,"d":"59.5%"}]
[null,"Secondary without sixth form","Medium","High FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"},{"v":0.025,"d":"2.5%"},{"v":0.035,"d":"3.5%"},{"v":0.045,"d":"4.5%"}]
[null,"Secondary without sixth form","Medium","High FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.105,"d":"10.5%"},{"v":0.115,"d":"11.5%"},{"v":0.125,"d":"12.5%"},{"v":0.15,"d":"15.0%"},{"v":0.16,"d":"16.0%"}]
[null,"Secondary without sixth form","Medium","High FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.065,"d":"6.5%"},null,{"v":0.085,"d":"8.5%"},{"v":0.1,"d":"10.0%"}]
[null,"Secondary without sixth form","Medium","High FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.015,"d":"1.5%"},null,{"v":0.03,"d":"3.0%"},{"v":0.05,"d":"5.0%"}]
[null,"Secondary without sixth form","Medium","High FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.06,"d":"6.0%"},null,{"v":0.09,"d":"9.0%"},{"v":0.14,"d":"14.0%"}]
[null,"Secondary without sixth form","Medium","High FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.035,"d":"3.5%"},{"v":0.04,"d":"4.0%"},{"v":0.05,"d":"5.0%"},{"v":0.06,"d":"6.0%"},{"v":0.065,"d":"6.5%"}]
[null,"Secondary without sixth form","Medium","High FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Secondary without sixth form","Medium","High FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.065,"d":"6.5%"},{"v":0.07,"d":"7.0%"},{"v":0.075,"d":"7.5%"},{"v":0.095,"d":"9.5%"},{"v":0.11,"d":"11.0%"}]
[null,"Secondary without sixth form","Medium","High FSM","Pupil to teacher ratio",{"v":13,"d":"13.0"},{"v":14,"d":"14.0"},{"v":15,"d":"15.0"},{"v":15,"d":"15.0"},15.5,{"v":17,"d":"17.0"},{"v":18,"d":"18.0"}]
[null,"Secondary without sixth form","Medium","High FSM","Pupil to adult ratio",{"v":7,"d":"7.0"},7.5,{"v":8,"d":"8.0"},8.5,8.5,{"v":9,"d":"9.0"},9.5]
[null,"Secondary without sixth form","Medium","High FSM","Average class size",19.5,{"v":20,"d":"20.0"},21.5,{"v":22,"d":"22.0"},22.5,23.5,24.5]
[]
[31,"Secondary without sixth form","Large","High FSM","SLH"]
[null,"Secondary without sixth form","Large","High FSM","Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.44,"d":"44.0%"},{"v":0.465,"d":"46.5%"},{"v":0.485,"d":"48.5%"},{"v":0.495,"d":"49.5%"},{"v":0.52,"d":"52.0%"},{"v":0.545,"d":"54.5%"},{"v":0.575,"d":"57.5%"}]
[null,"Secondary without sixth form","Large","High FSM","Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.44,"d":"44.0%"},{"v":0.465,"d":"46.5%"},{"v":0.485,"d":"48.5%"},{"v":0.5,"d":"50.0%"},{"v":0.52,"d":"52.0%"},{"v":0.55,"d":"55.0%"},{"v":0.58,"d":"58.0%"}]
[null,"Secondary without sixth form","Large","High FSM","Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.455,"d":"45.5%"},{"v":0.48,"d":"48.0%"},{"v":0.5,"d":"50.0%"},{"v":0.515,"d":"51.5%"},{"v":0.535,"d":"53.5%"},{"v":0.565,"d":"56.5%"},{"v":0.59,"d":"59.0%"}]
[null,"Secondary without sixth form","Large","High FSM","Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.465,"d":"46.5%"},{"v":0.49,"d":"49.0%"},{"v":0.51,"d":"51.0%"},{"v":0.525,"d":"52.5%"},{"v":0.545,"d":"54.5%"},{"v":0.575,"d":"57.5%"},{"v":0.6,"d":"60.0%"}]
[null,"Secondary without sixth form","Large","High FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"},{"v":0.025,"d":"2.5%"},{"v":0.035,"d":"3.5%"},{"v":0.045,"d":"4.5%"}]
[null,"Secondary without sixth form","Large","High FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.1,"d":"10.0%"},{"v":0.11,"d":"11.0%"},{"v":0.125,"d":"12.5%"},{"v":0.145,"d":"14.5%"},{"v":0.155,"d":"15.5%"}]
[null,"Secondary without sixth form","Large","High FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.06,"d":"6.0%"},null,{"v":0.085,"d":"8.5%"},{"v":0.105,"d":"10.5%"}]
[null,"Secondary without sixth form","Large","High FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.02,"d":"2.0%"},null,{"v":0.03,"d":"3.0%"},{"v":0.065,"d":"6.5%"}]
[null,"Secondary without sixth form","Large","High FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.055,"d":"5.5%"},null,{"v":0.075,"d":"7.5%"},{"v":0.105,"d":"10.5%"}]
[null,"Secondary without sixth form","Large","High FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.04,"d":"4.0%"},{"v":0.05,"d":"5.0%"},{"v":0.055,"d":"5.5%"},{"v":0.06,"d":"6.0%"},{"v":0.06,"d":"6.0%"}]
[null,"Secondary without sixth form","Large","High FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Secondary without sixth form","Large","High FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.055,"d":"5.5%"},{"v":0.06,"d":"6.0%"},{"v":0.07,"d":"7.0%"},{"v":0.09,"d":"9.0%"},{"v":0.12,"d":"12.0%"}]
[null,"Secondary without sixth form","Large","High FSM","Pupil to teacher ratio",13.5,14.5,{"v":15,"d":"15.0"},15.5,{"v":16,"d":"16.0"},{"v":17,"d":"17.0"},{"v":20,"d":"20.0"}]
[null,"Secondary without sixth form","Large","High FSM","Pupil to adult ratio",{"v":7,"d":"7.0"},7.5,8.5,8.5,{"v":9,"d":"9.0"},{"v":10,"d":"10.0"},10.5]
[null,"Secondary without sixth form","Large","High FSM","Average class size",{"v":20,"d":"20.0"},{"v":21,"d":"21.0"},21.5,22.5,{"v":23,"d":"23.0"},{"v":24,"d":"24.0"},{"v":25,"d":"25.0"}]
[]
[]
["Sample size","Phase","London?","Note: all but average teacher cost are the same for type of school, despite the location",null,"Red if less than:","Amber if less than:","Dark green if between:","(Median)","and:","Amber if more than:","Red if more than:",null,"Light green for everything else"]
[127,"Special","London",null,"SPL"]
[null,"Special","London",null,"Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.27,"d":"27.0%"},{"v":0.3,"d":"30.0%"},{"v":0.345,"d":"34.5%"},{"v":0.36,"d":"36.0%"},{"v":0.38,"d":"38.0%"},{"v":0.43,"d":"43.0%"},{"v":0.47,"d":"47.0%"}]
[null,"Special","London",null,"Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.275,"d":"27.5%"},{"v":0.305,"d":"30.5%"},{"v":0.345,"d":"34.5%"},{"v":0.365,"d":"36.5%"},{"v":0.38,"d":"38.0%"},{"v":0.435,"d":"43.5%"},{"v":0.475,"d":"47.5%"}]
[null,"Special","London",null,"Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.285,"d":"28.5%"},{"v":0.315,"d":"31.5%"},{"v":0.36,"d":"36.0%"},{"v":0.38,"d":"38.0%"},{"v":0.395,"d":"39.5%"},{"v":0.445,"d":"44.5%"},{"v":0.49,"d":"49.0%"}]
[null,"Special","London",null,"Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.295,"d":"29.5%"},{"v":0.325,"d":"32.5%"},{"v":0.37,"d":"37.0%"},{"v":0.385,"d":"38.5%"},{"v":0.405,"d":"40.5%"},{"v":0.455,"d":"45.5%"},{"v":0.495,"d":"49.5%"}]
[null,"Special","London",null,"Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"},{"v":0.025,"d":"2.5%"},{"v":0.045,"d":"4.5%"},{"v":0.07,"d":"7.0%"}]
[null,"Special","London",null,"Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.29,"d":"29.0%"},{"v":0.32,"d":"32.0%"},{"v":0.34,"d":"34.0%"},{"v":0.39,"d":"39.0%"},{"v":0.415,"d":"41.5%"}]
[null,"Special","London",null,"Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.045,"d":"4.5%"},null,{"v":0.065,"d":"6.5%"},{"v":0.08,"d":"8.0%"}]
[null,"Special","London",null,"Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.03,"d":"3.0%"},null,{"v":0.05,"d":"5.0%"},{"v":0.07,"d":"7.0%"}]
[null,"Special","London",null,"Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.05,"d":"5.0%"},null,{"v":0.065,"d":"6.5%"},{"v":0.08,"d":"8.0%"}]
[null,"Special","London",null,"Spend on teaching resources as a percentage of total expenditure",{"v":0.02,"d":"2.0%"},{"v":0.025,"d":"2.5%"},{"v":0.035,"d":"3.5%"},{"v":0.035,"d":"3.5%"},{"v":0.04,"d":"4.0%"}]
[null,"Special","London",null,"Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Special","London",null,"Senior leaders as a percentage of workforce",null,null,{"v":0.05,"d":"5.0%"},{"v":0.055,"d":"5.5%"},{"v":0.065,"d":"6.5%"},{"v":0.085,"d":"8.5%"},{"v":0.105,"d":"10.5%"}]
[null,"Special","London",null,"Pupil to teacher ratio",{"v":4,"d":"4.0"},{"v":5,"d":"5.0"},{"v":6,"d":"6.0"},6.5,{"v":7,"d":"7.0"},7.5,8.5]
[null,"Special","London",null,"Pupil to adult ratio",1.3,1.5,1.7,{"v":2,"d":"2.0"},{"v":2,"d":"2.0"},2.5,2.7]
[null,"Special","London",null,"Average teacher cost (£) - 2017-18",{"v":47000,"d":"£47,000"},{"v":51000,"d":"£51,000"},{"v":56500,"d":"£56,500"},{"v":58000,"d":"£58,000"},{"v":60500,"d":"£60,500"},{"v":66000,"d":"£66,000"},{"v":70500,"d":"£70,500"}]
[null,"Special","London",null,"Average teacher cost (£) - 2018-19",{"v":47500,"d":"£47,500"},{"v":52000,"d":"£52,000"},{"v":57000,"d":"£57,000"},{"v":59000,"d":"£59,000"},{"v":61500,"d":"£61,500"},{"v":66500,"d":"£66,500"},{"v":71500,"d":"£71,500"}]
[null,"Special","London",null,"Average teacher cost (£) - 2019-20",{"v":50500,"d":"£50,500"},{"v":55000,"d":"£55,000"},{"v":60500,"d":"£60,500"},{"v":62500,"d":"£62,500"},{"v":65000,"d":"£65,000"},{"v":70500,"d":"£70,500"},{"v":75500,"d":"£75,500"}]
[null,"Special","London",null,"Average teacher cost (£) - 2019/20",{"v":52000,"d":"£52,000"},{"v":57000,"d":"£57,000"},{"v":62500,"d":"£62,500"},{"v":65000,"d":"£65,000"},{"v":67500,"d":"£67,500"},{"v":73000,"d":"£73,000"},{"v":78500,"d":"£78,500"}]
[]
[774,"Special","Non-London",null,"SPNL"]
[null,"Special","Non-London",null,"Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.27,"d":"27.0%"},{"v":0.3,"d":"30.0%"},{"v":0.345,"d":"34.5%"},{"v":0.36,"d":"36.0%"},{"v":0.38,"d":"38.0%"},{"v":0.43,"d":"43.0%"},{"v":0.47,"d":"47.0%"}]
[null,"Special","Non-London",null,"Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.275,"d":"27.5%"},{"v":0.305,"d":"30.5%"},{"v":0.345,"d":"34.5%"},{"v":0.365,"d":"36.5%"},{"v":0.38,"d":"38.0%"},{"v":0.435,"d":"43.5%"},{"v":0.475,"d":"47.5%"}]
[null,"Special","Non-London",null,"Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.285,"d":"28.5%"},{"v":0.315,"d":"31.5%"},{"v":0.36,"d":"36.0%"},{"v":0.38,"d":"38.0%"},{"v":0.395,"d":"39.5%"},{"v":0.445,"d":"44.5%"},{"v":0.49,"d":"49.0%"}]
[null,"Special","Non-London",null,"Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.295,"d":"29.5%"},{"v":0.325,"d":"32.5%"},{"v":0.37,"d":"37.0%"},{"v":0.385,"d":"38.5%"},{"v":0.405,"d":"40.5%"},{"v":0.455,"d":"45.5%"},{"v":0.495,"d":"49.5%"}]
[null,"Special","Non-London",null,"Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"},{"v":0.025,"d":"2.5%"},{"v":0.045,"d":"4.5%"},{"v":0.07,"d":"7.0%"}]
[null,"Special","Non-London",null,"Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.29,"d":"29.0%"},{"v":0.32,"d":"32.0%"},{"v":0.34,"d":"34.0%"},{"v":0.39,"d":"39.0%"},{"v":0.415,"d":"41.5%"}]
[null,"Special","Non-London",null,"Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.045,"d":"4.5%"},null,{"v":0.065,"d":"6.5%"},{"v":0.08,"d":"8.0%"}]
[null,"Special","Non-London",null,"Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.03,"d":"3.0%"},null,{"v":0.05,"d":"5.0%"},{"v":0.07,"d":"7.0%"}]
[null,"Special","Non-London",null,"Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.05,"d":"5.0%"},null,{"v":0.065,"d":"6.5%"},{"v":0.08,"d":"8.0%"}]
[null,"Special","Non-London",null,"Spend on teaching resources as a percentage of total expenditure",{"v":0.02,"d":"2.0%"},{"v":0.025,"d":"2.5%"},{"v":0.035,"d":"3.5%"},{"v":0.035,"d":"3.5%"},{"v":0.04,"d":"4.0%"}]
[null,"Special","Non-London",null,"Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Special","Non-London",null,"Senior leaders as a percentage of workforce",null,null,{"v":0.05,"d":"5.0%"},{"v":0.055,"d":"5.5%"},{"v":0.065,"d":"6.5%"},{"v":0.085,"d":"8.5%"},{"v":0.105,"d":"10.5%"}]
[null,"Special","Non-London",null,"Pupil to teacher ratio",{"v":4,"d":"4.0"},{"v":5,"d":"5.0"},{"v":6,"d":"6.0"},6.5,{"v":7,"d":"7.0"},7.5,8.5]
[null,"Special","Non-London",null,"Pupil to adult ratio",1.3,1.5,1.7,{"v":2,"d":"2.0"},{"v":2,"d":"2.0"},2.5,2.7]
[null,"Special","Non-London",null,"Average teacher cost (£) - 2017-18",{"v":44500,"d":"£44,500"},{"v":47500,"d":"£47,500"},{"v":50500,"d":"£50,500"},{"v":52000,"d":"£52,000"},{"v":53500,"d":"£53,500"},{"v":57000,"d":"£57,000"},{"v":60500,"d":"£60,500"}]
[null,"Special","Non-London",null,"Average teacher cost (£) - 2018-19",{"v":45000,"d":"£45,000"},{"v":48500,"d":"£48,500"},{"v":51000,"d":"£51,000"},{"v":53000,"d":"£53,000"},{"v":54500,"d":"£54,500"},{"v":58000,"d":"£58,000"},{"v":61000,"d":"£61,000"}]
[null,"Special","Non-London",null,"Average teacher cost (£) - 2019-20",{"v":48000,"d":"£48,000"},{"v":51000,"d":"£51,000"},{"v":54000,"d":"£54,000"},{"v":56000,"d":"£56,000"},{"v":57500,"d":"£57,500"},{"v":61500,"d":"£61,500"},{"v":65000,"d":"£65,000"}]
[null,"Special","Non-London",null,"Average teacher cost (£) - 2019/20",{"v":49500,"d":"£49,500"},{"v":53000,"d":"£53,000"},{"v":56000,"d":"£56,000"},{"v":58000,"d":"£58,000"},{"v":59500,"d":"£59,500"},{"v":63500,"d":"£63,500"},{"v":67000,"d":"£67,000"}]
[]
[48,"Alternative provision","London",null,"APL"]
[null,"Alternative provision","London",null,"Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.285,"d":"28.5%"},{"v":0.34,"d":"34.0%"},{"v":0.405,"d":"40.5%"},{"v":0.44,"d":"44.0%"},{"v":0.47,"d":"47.0%"},{"v":0.545,"d":"54.5%"},{"v":0.605,"d":"60.5%"}]
[null,"Alternative provision","London",null,"Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.285,"d":"28.5%"},{"v":0.34,"d":"34.0%"},{"v":0.405,"d":"40.5%"},{"v":0.445,"d":"44.5%"},{"v":0.47,"d":"47.0%"},{"v":0.55,"d":"55.0%"},{"v":0.605,"d":"60.5%"}]
[null,"Alternative provision","London",null,"Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.3,"d":"30.0%"},{"v":0.355,"d":"35.5%"},{"v":0.42,"d":"42.0%"},{"v":0.46,"d":"46.0%"},{"v":0.485,"d":"48.5%"},{"v":0.56,"d":"56.0%"},{"v":0.62,"d":"62.0%"}]
[null,"Alternative provision","London",null,"Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.305,"d":"30.5%"},{"v":0.365,"d":"36.5%"},{"v":0.43,"d":"43.0%"},{"v":0.465,"d":"46.5%"},{"v":0.495,"d":"49.5%"},{"v":0.57,"d":"57.0%"},{"v":0.63,"d":"63.0%"}]
[null,"Alternative provision","London",null,"Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.025,"d":"2.5%"},{"v":0.04,"d":"4.0%"},{"v":0.055,"d":"5.5%"},{"v":0.095,"d":"9.5%"},{"v":0.125,"d":"12.5%"}]
[null,"Alternative provision","London",null,"Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.15,"d":"15.0%"},{"v":0.17,"d":"17.0%"},{"v":0.195,"d":"19.5%"},{"v":0.235,"d":"23.5%"},{"v":0.28,"d":"28.0%"}]
[null,"Alternative provision","London",null,"Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.06,"d":"6.0%"},null,{"v":0.09,"d":"9.0%"},{"v":0.105,"d":"10.5%"}]
[null,"Alternative provision","London",null,"Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.02,"d":"2.0%"},null,{"v":0.035,"d":"3.5%"},{"v":0.06,"d":"6.0%"}]
[null,"Alternative provision","London",null,"Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.04,"d":"4.0%"},null,{"v":0.055,"d":"5.5%"},{"v":0.065,"d":"6.5%"}]
[null,"Alternative provision","London",null,"Spend on teaching resources as a percentage of total expenditure",{"v":0.02,"d":"2.0%"},{"v":0.025,"d":"2.5%"},{"v":0.035,"d":"3.5%"},{"v":0.045,"d":"4.5%"},{"v":0.055,"d":"5.5%"}]
[null,"Alternative provision","London",null,"Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Alternative provision","London",null,"Senior leaders as a percentage of workforce",null,null,{"v":0.09,"d":"9.0%"},{"v":0.1,"d":"10.0%"},{"v":0.115,"d":"11.5%"},{"v":0.16,"d":"16.0%"},{"v":0.195,"d":"19.5%"}]
[null,"Alternative provision","London",null,"Pupil to teacher ratio",{"v":3,"d":"3.0"},3.5,4.5,{"v":5,"d":"5.0"},{"v":6,"d":"6.0"},{"v":8,"d":"8.0"},{"v":10,"d":"10.0"}]
[null,"Alternative provision","London",null,"Pupil to adult ratio",1.3,1.5,{"v":2,"d":"2.0"},2.5,2.5,3.5,{"v":4,"d":"4.0"}]
[null,"Alternative provision","London",null,"Average teacher cost (£) - 2017-18",{"v":39000,"d":"£39,000"},{"v":47500,"d":"£47,500"},{"v":54500,"d":"£54,500"},{"v":59000,"d":"£59,000"},{"v":60500,"d":"£60,500"},{"v":71000,"d":"£71,000"},{"v":78000,"d":"£78,000"}]
[null,"Alternative provision","London",null,"Average teacher cost (£) - 2018-19",{"v":39500,"d":"£39,500"},{"v":48000,"d":"£48,000"},{"v":55500,"d":"£55,500"},{"v":60000,"d":"£60,000"},{"v":61500,"d":"£61,500"},{"v":72000,"d":"£72,000"},{"v":79500,"d":"£79,500"}]
[null,"Alternative provision","London",null,"Average teacher cost (£) - 2019-20",{"v":42000,"d":"£42,000"},{"v":51000,"d":"£51,000"},{"v":59000,"d":"£59,000"},{"v":63500,"d":"£63,500"},{"v":65000,"d":"£65,000"},{"v":76500,"d":"£76,500"},{"v":84000,"d":"£84,000"}]
[null,"Alternative provision","London",null,"Average teacher cost (£) - 2019/20",{"v":43500,"d":"£43,500"},{"v":52500,"d":"£52,500"},{"v":61000,"d":"£61,000"},{"v":65500,"d":"£65,500"},{"v":67000,"d":"£67,000"},{"v":79000,"d":"£79,000"},{"v":87000,"d":"£87,000"}]
[]
[269,"Alternative provision","Non-London",null,"APNL"]
[null,"Alternative provision","Non-London",null,"Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.285,"d":"28.5%"},{"v":0.34,"d":"34.0%"},{"v":0.405,"d":"40.5%"},{"v":0.44,"d":"44.0%"},{"v":0.47,"d":"47.0%"},{"v":0.545,"d":"54.5%"},{"v":0.605,"d":"60.5%"}]
[null,"Alternative provision","Non-London",null,"Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.285,"d":"28.5%"},{"v":0.34,"d":"34.0%"},{"v":0.405,"d":"40.5%"},{"v":0.445,"d":"44.5%"},{"v":0.47,"d":"47.0%"},{"v":0.55,"d":"55.0%"},{"v":0.605,"d":"60.5%"}]
[null,"Alternative provision","Non-London",null,"Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.3,"d":"30.0%"},{"v":0.355,"d":"35.5%"},{"v":0.42,"d":"42.0%"},{"v":0.46,"d":"46.0%"},{"v":0.485,"d":"48.5%"},{"v":0.56,"d":"56.0%"},{"v":0.62,"d":"62.0%"}]
[null,"Alternative provision","Non-London",null,"Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.305,"d":"30.5%"},{"v":0.365,"d":"36.5%"},{"v":0.43,"d":"43.0%"},{"v":0.465,"d":"46.5%"},{"v":0.495,"d":"49.5%"},{"v":0.57,"d":"57.0%"},{"v":0.63,"d":"63.0%"}]
[null,"Alternative provision","Non-London",null,"Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.025,"d":"2.5%"},{"v":0.04,"d":"4.0%"},{"v":0.055,"d":"5.5%"},{"v":0.095,"d":"9.5%"},{"v":0.125,"d":"12.5%"}]
[null,"Alternative provision","Non-London",null,"Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.15,"d":"15.0%"},{"v":0.17,"d":"17.0%"},{"v":0.195,"d":"19.5%"},{"v":0.235,"d":"23.5%"},{"v":0.28,"d":"28.0%"}]
[null,"Alternative provision","Non-London",null,"Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.06,"d":"6.0%"},null,{"v":0.09,"d":"9.0%"},{"v":0.105,"d":"10.5%"}]
[null,"Alternative provision","Non-London",null,"Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.02,"d":"2.0%"},null,{"v":0.035,"d":"3.5%"},{"v":0.06,"d":"6.0%"}]
[null,"Alternative provision","Non-London",null,"Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.04,"d":"4.0%"},null,{"v":0.055,"d":"5.5%"},{"v":0.065,"d":"6.5%"}]
[null,"Alternative provision","Non-London",null,"Spend on teaching resources as a percentage of total expenditure",{"v":0.02,"d":"2.0%"},{"v":0.025,"d":"2.5%"},{"v":0.035,"d":"3.5%"},{"v":0.045,"d":"4.5%"},{"v":0.055,"d":"5.5%"}]
[null,"Alternative provision","Non-London",null,"Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Alternative provision","Non-London",null,"Senior leaders as a percentage of workforce",null,null,{"v":0.09,"d":"9.0%"},{"v":0.1,"d":"10.0%"},{"v":0.115,"d":"11.5%"},{"v":0.16,"d":"16.0%"},{"v":0.195,"d":"19.5%"}]
[null,"Alternative provision","Non-London",null,"Pupil to teacher ratio",{"v":3,"d":"3.0"},3.5,4.5,{"v":5,"d":"5.0"},{"v":6,"d":"6.0"},{"v":8,"d":"8.0"},{"v":10,"d":"10.0"}]
[null,"Alternative provision","Non-London",null,"Pupil to adult ratio",1.3,1.5,{"v":2,"d":"2.0"},2.5,2.5,3.5,{"v":4,"d":"4.0"}]
[null,"Alternative provision","Non-London",null,"Average teacher cost (£) - 2017-18",{"v":40500,"d":"£40,500"},{"v":47000,"d":"£47,000"},{"v":50500,"d":"£50,500"},{"v":53000,"d":"£53,000"},{"v":54500,"d":"£54,500"},{"v":60000,"d":"£60,000"},{"v":69500,"d":"£69,500"}]
[null,"Alternative provision","Non-London",null,"Average teacher cost (£) - 2018-19",{"v":41000,"d":"£41,000"},{"v":47500,"d":"£47,500"},{"v":51500,"d":"£51,500"},{"v":53500,"d":"£53,500"},{"v":55500,"d":"£55,500"},{"v":61000,"d":"£61,000"},{"v":70500,"d":"£70,500"}]
[null,"Alternative provision","Non-London",null,"Average teacher cost (£) - 2019-20",{"v":43500,"d":"£43,500"},{"v":50500,"d":"£50,500"},{"v":54500,"d":"£54,500"},{"v":57000,"d":"£57,000"},{"v":59000,"d":"£59,000"},{"v":65000,"d":"£65,000"},{"v":74500,"d":"£74,500"}]
[null,"Alternative provision","Non-London",null,"Average teacher cost (£) - 2019/20",{"v":45000,"d":"£45,000"},{"v":52000,"d":"£52,000"},{"v":56500,"d":"£56,500"},{"v":59000,"d":"£59,000"},{"v":61000,"d":"£61,000"},{"v":67000,"d":"£67,000"},{"v":77000,"d":"£77,000"}]
[]
[47,"All-through","London",null,"ATL"]
[null,"All-through","London",null,"Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.405,"d":"40.5%"},{"v":0.45,"d":"45.0%"},{"v":0.5,"d":"50.0%"},{"v":0.52,"d":"52.0%"},{"v":0.535,"d":"53.5%"},{"v":0.59,"d":"59.0%"},{"v":0.61,"d":"61.0%"}]
[null,"All-through","London",null,"Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.41,"d":"41.0%"},{"v":0.455,"d":"45.5%"},{"v":0.5,"d":"50.0%"},{"v":0.525,"d":"52.5%"},{"v":0.54,"d":"54.0%"},{"v":0.595,"d":"59.5%"},{"v":0.61,"d":"61.0%"}]
[null,"All-through","London",null,"Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.425,"d":"42.5%"},{"v":0.47,"d":"47.0%"},{"v":0.515,"d":"51.5%"},{"v":0.54,"d":"54.0%"},{"v":0.55,"d":"55.0%"},{"v":0.61,"d":"61.0%"},{"v":0.625,"d":"62.5%"}]
[null,"All-through","London",null,"Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.435,"d":"43.5%"},{"v":0.475,"d":"47.5%"},{"v":0.525,"d":"52.5%"},{"v":0.545,"d":"54.5%"},{"v":0.56,"d":"56.0%"},{"v":0.615,"d":"61.5%"},{"v":0.635,"d":"63.5%"}]
[null,"All-through","London",null,"Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.02,"d":"2.0%"},{"v":0.025,"d":"2.5%"},{"v":0.03,"d":"3.0%"},{"v":0.045,"d":"4.5%"},{"v":0.06,"d":"6.0%"}]
[null,"All-through","London",null,"Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.105,"d":"10.5%"},{"v":0.115,"d":"11.5%"},{"v":0.125,"d":"12.5%"},{"v":0.155,"d":"15.5%"},{"v":0.18,"d":"18.0%"}]
[null,"All-through","London",null,"Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.06,"d":"6.0%"},null,{"v":0.085,"d":"8.5%"},{"v":0.105,"d":"10.5%"}]
[null,"All-through","London",null,"Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.02,"d":"2.0%"},null,{"v":0.035,"d":"3.5%"},{"v":0.055,"d":"5.5%"}]
[null,"All-through","London",null,"Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.05,"d":"5.0%"},null,{"v":0.07,"d":"7.0%"},{"v":0.09,"d":"9.0%"}]
[null,"All-through","London",null,"Spend on teaching resources as a percentage of total expenditure",{"v":0.035,"d":"3.5%"},{"v":0.04,"d":"4.0%"},{"v":0.05,"d":"5.0%"},{"v":0.055,"d":"5.5%"},{"v":0.06,"d":"6.0%"}]
[null,"All-through","London",null,"Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"All-through","London",null,"Senior leaders as a percentage of workforce",null,null,{"v":0.065,"d":"6.5%"},{"v":0.07,"d":"7.0%"},{"v":0.075,"d":"7.5%"},{"v":0.1,"d":"10.0%"},{"v":0.11,"d":"11.0%"}]
[null,"All-through","London",null,"Pupil to teacher ratio",13.5,14.5,{"v":16,"d":"16.0"},16.5,{"v":17,"d":"17.0"},{"v":18,"d":"18.0"},{"v":19,"d":"19.0"}]
[null,"All-through","London",null,"Pupil to adult ratio",{"v":7,"d":"7.0"},7.5,8.5,{"v":9,"d":"9.0"},{"v":9,"d":"9.0"},{"v":10,"d":"10.0"},10.5]
[null,"All-through","London",null,"Average class size",{"v":19,"d":"19.0"},20.5,22.5,{"v":23,"d":"23.0"},23.5,{"v":25,"d":"25.0"},{"v":26,"d":"26.0"}]
[null,"All-through","London",null,"Average teacher cost (£) - 2017-18",{"v":48000,"d":"£48,000"},{"v":51000,"d":"£51,000"},{"v":56000,"d":"£56,000"},{"v":57500,"d":"£57,500"},{"v":59500,"d":"£59,500"},{"v":65000,"d":"£65,000"},{"v":68000,"d":"£68,000"}]
[null,"All-through","London",null,"Average teacher cost (£) - 2018-19",{"v":48500,"d":"£48,500"},{"v":52000,"d":"£52,000"},{"v":57000,"d":"£57,000"},{"v":58500,"d":"£58,500"},{"v":60000,"d":"£60,000"},{"v":65500,"d":"£65,500"},{"v":69000,"d":"£69,000"}]
[null,"All-through","London",null,"Average teacher cost (£) - 2019-20",{"v":51500,"d":"£51,500"},{"v":55000,"d":"£55,000"},{"v":60500,"d":"£60,500"},{"v":62000,"d":"£62,000"},{"v":64000,"d":"£64,000"},{"v":69500,"d":"£69,500"},{"v":73500,"d":"£73,500"}]
[null,"All-through","London",null,"Average teacher cost (£) - 2019/20",{"v":53500,"d":"£53,500"},{"v":57000,"d":"£57,000"},{"v":62500,"d":"£62,500"},{"v":64000,"d":"£64,000"},{"v":66000,"d":"£66,000"},{"v":72000,"d":"£72,000"},{"v":76000,"d":"£76,000"}]
[]
[96,"All-through","Non-London",null,"ATNL"]
[null,"All-through","Non-London",null,"Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.405,"d":"40.5%"},{"v":0.45,"d":"45.0%"},{"v":0.5,"d":"50.0%"},{"v":0.52,"d":"52.0%"},{"v":0.535,"d":"53.5%"},{"v":0.59,"d":"59.0%"},{"v":0.61,"d":"61.0%"}]
[null,"All-through","Non-London",null,"Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.41,"d":"41.0%"},{"v":0.455,"d":"45.5%"},{"v":0.5,"d":"50.0%"},{"v":0.525,"d":"52.5%"},{"v":0.54,"d":"54.0%"},{"v":0.595,"d":"59.5%"},{"v":0.61,"d":"61.0%"}]
[null,"All-through","Non-London",null,"Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.425,"d":"42.5%"},{"v":0.47,"d":"47.0%"},{"v":0.515,"d":"51.5%"},{"v":0.54,"d":"54.0%"},{"v":0.55,"d":"55.0%"},{"v":0.61,"d":"61.0%"},{"v":0.625,"d":"62.5%"}]
[null,"All-through","Non-London",null,"Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.435,"d":"43.5%"},{"v":0.475,"d":"47.5%"},{"v":0.525,"d":"52.5%"},{"v":0.545,"d":"54.5%"},{"v":0.56,"d":"56.0%"},{"v":0.615,"d":"61.5%"},{"v":0.635,"d":"63.5%"}]
[null,"All-through","Non-London",null,"Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.02,"d":"2.0%"},{"v":0.025,"d":"2.5%"},{"v":0.03,"d":"3.0%"},{"v":0.045,"d":"4.5%"},{"v":0.06,"d":"6.0%"}]
[null,"All-through","Non-London",null,"Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.105,"d":"10.5%"},{"v":0.115,"d":"11.5%"},{"v":0.125,"d":"12.5%"},{"v":0.155,"d":"15.5%"},{"v":0.18,"d":"18.0%"}]
[null,"All-through","Non-London",null,"Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.06,"d":"6.0%"},null,{"v":0.085,"d":"8.5%"},{"v":0.105,"d":"10.5%"}]
[null,"All-through","Non-London",null,"Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.02,"d":"2.0%"},null,{"v":0.035,"d":"3.5%"},{"v":0.055,"d":"5.5%"}]
[null,"All-through","Non-London",null,"Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.05,"d":"5.0%"},null,{"v":0.07,"d":"7.0%"},{"v":0.09,"d":"9.0%"}]
[null,"All-through","Non-London",null,"Spend on teaching resources as a percentage of total expenditure",{"v":0.035,"d":"3.5%"},{"v":0.04,"d":"4.0%"},{"v":0.05,"d":"5.0%"},{"v":0.055,"d":"5.5%"},{"v":0.06,"d":"6.0%"}]
[null,"All-through","Non-London",null,"Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"All-through","Non-London",null,"Senior leaders as a percentage of workforce",null,null,{"v":0.065,"d":"6.5%"},{"v":0.07,"d":"7.0%"},{"v":0.075,"d":"7.5%"},{"v":0.1,"d":"10.0%"},{"v":0.11,"d":"11.0%"}]
[null,"All-through","Non-London",null,"Pupil to teacher ratio",13.5,14.5,{"v":16,"d":"16.0"},16.5,{"v":17,"d":"17.0"},{"v":18,"d":"18.0"},{"v":19,"d":"19.0"}]
[null,"All-through","Non-London",null,"Pupil to adult ratio",{"v":7,"d":"7.0"},7.5,8.5,{"v":9,"d":"9.0"},{"v":9,"d":"9.0"},{"v":10,"d":"10.0"},10.5]
[null,"All-through","Non-London",null,"Average class size",{"v":19,"d":"19.0"},20.5,22.5,{"v":23,"d":"23.0"},23.5,{"v":25,"d":"25.0"},{"v":26,"d":"26.0"}]
[null,"All-through","Non-London",null,"Average teacher cost (£) - 2017-18",{"v":39000,"d":"£39,000"},{"v":44000,"d":"£44,000"},{"v":47500,"d":"£47,500"},{"v":48500,"d":"£48,500"},{"v":50000,"d":"£50,000"},{"v":53500,"d":"£53,500"},{"v":57000,"d":"£57,000"}]
[null,"All-through","Non-London",null,"Average teacher cost (£) - 2018-19",{"v":40000,"d":"£40,000"},{"v":44500,"d":"£44,500"},{"v":48000,"d":"£48,000"},{"v":49500,"d":"£49,500"},{"v":51000,"d":"£51,000"},{"v":54000,"d":"£54,000"},{"v":58000,"d":"£58,000"}]
[null,"All-through","Non-London",null,"Average teacher cost (£) - 2019-20",{"v":42000,"d":"£42,000"},{"v":47000,"d":"£47,000"},{"v":51000,"d":"£51,000"},{"v":52500,"d":"£52,500"},{"v":54000,"d":"£54,000"},{"v":57500,"d":"£57,500"},{"v":61500,"d":"£61,500"}]
[null,"All-through","Non-London",null,"Average teacher cost (£) - 2019/20",{"v":43500,"d":"£43,500"},{"v":48500,"d":"£48,500"},{"v":52500,"d":"£52,500"},{"v":54000,"d":"£54,000"},{"v":56000,"d":"£56,000"},{"v":59500,"d":"£59,500"},{"v":63500,"d":"£63,500"}]
[]
[78,"Nursery","London",null,"NL"]
[null,"Nursery","London",null,"Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.16,"d":"16.0%"},{"v":0.195,"d":"19.5%"},{"v":0.245,"d":"24.5%"},{"v":0.26,"d":"26.0%"},{"v":0.29,"d":"29.0%"},{"v":0.34,"d":"34.0%"},{"v":0.38,"d":"38.0%"}]
[null,"Nursery","London",null,"Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.16,"d":"16.0%"},{"v":0.195,"d":"19.5%"},{"v":0.245,"d":"24.5%"},{"v":0.265,"d":"26.5%"},{"v":0.29,"d":"29.0%"},{"v":0.345,"d":"34.5%"},{"v":0.385,"d":"38.5%"}]
[null,"Nursery","London",null,"Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.17,"d":"17.0%"},{"v":0.205,"d":"20.5%"},{"v":0.26,"d":"26.0%"},{"v":0.275,"d":"27.5%"},{"v":0.305,"d":"30.5%"},{"v":0.355,"d":"35.5%"},{"v":0.4,"d":"40.0%"}]
[null,"Nursery","London",null,"Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.175,"d":"17.5%"},{"v":0.21,"d":"21.0%"},{"v":0.265,"d":"26.5%"},{"v":0.285,"d":"28.5%"},{"v":0.31,"d":"31.0%"},{"v":0.365,"d":"36.5%"},{"v":0.405,"d":"40.5%"}]
[null,"Nursery","London",null,"Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.005,"d":"0.5%"},{"v":0.01,"d":"1.0%"},{"v":0.015,"d":"1.5%"},{"v":0.03,"d":"3.0%"},{"v":0.05,"d":"5.0%"}]
[null,"Nursery","London",null,"Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.295,"d":"29.5%"},{"v":0.335,"d":"33.5%"},{"v":0.36,"d":"36.0%"},{"v":0.43,"d":"43.0%"},{"v":0.475,"d":"47.5%"}]
[null,"Nursery","London",null,"Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.07,"d":"7.0%"},null,{"v":0.1,"d":"10.0%"},{"v":0.125,"d":"12.5%"}]
[null,"Nursery","London",null,"Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.03,"d":"3.0%"},null,{"v":0.06,"d":"6.0%"},{"v":0.095,"d":"9.5%"}]
[null,"Nursery","London",null,"Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.055,"d":"5.5%"},null,{"v":0.075,"d":"7.5%"},{"v":0.1,"d":"10.0%"}]
[null,"Nursery","London",null,"Spend on teaching resources as a percentage of total expenditure",{"v":0.01,"d":"1.0%"},{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"},{"v":0.02,"d":"2.0%"},{"v":0.025,"d":"2.5%"}]
[null,"Nursery","London",null,"Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Nursery","London",null,"Senior leaders as a percentage of workforce",null,null,{"v":0.085,"d":"8.5%"},{"v":0.095,"d":"9.5%"},{"v":0.105,"d":"10.5%"},{"v":0.14,"d":"14.0%"},{"v":0.17,"d":"17.0%"}]
[null,"Nursery","London",null,"Pupil to teacher ratio",{"v":14,"d":"14.0"},16.5,{"v":20,"d":"20.0"},21.5,{"v":24,"d":"24.0"},{"v":30,"d":"30.0"},38.5]
[null,"Nursery","London",null,"Pupil to adult ratio",{"v":3,"d":"3.0"},3.5,4.5,4.5,{"v":5,"d":"5.0"},{"v":6,"d":"6.0"},{"v":7,"d":"7.0"}]
[null,"Nursery","London",null,"Average teacher cost (£) - 2017-18",{"v":41000,"d":"£41,000"},{"v":50000,"d":"£50,000"},{"v":56000,"d":"£56,000"},{"v":59500,"d":"£59,500"},{"v":62000,"d":"£62,000"},{"v":69500,"d":"£69,500"},{"v":74500,"d":"£74,500"}]
[null,"Nursery","London",null,"Average teacher cost (£) - 2018-19",{"v":41500,"d":"£41,500"},{"v":51000,"d":"£51,000"},{"v":57000,"d":"£57,000"},{"v":60000,"d":"£60,000"},{"v":63000,"d":"£63,000"},{"v":70500,"d":"£70,500"},{"v":75500,"d":"£75,500"}]
[null,"Nursery","London",null,"Average teacher cost (£) - 2019-20",{"v":44000,"d":"£44,000"},{"v":54000,"d":"£54,000"},{"v":60500,"d":"£60,500"},{"v":63500,"d":"£63,500"},{"v":66500,"d":"£66,500"},{"v":75000,"d":"£75,000"},{"v":80000,"d":"£80,000"}]
[null,"Nursery","London",null,"Average teacher cost (£) - 2019/20",{"v":45500,"d":"£45,500"},{"v":55500,"d":"£55,500"},{"v":62500,"d":"£62,500"},{"v":66000,"d":"£66,000"},{"v":69000,"d":"£69,000"},{"v":77500,"d":"£77,500"},{"v":83000,"d":"£83,000"}]
[]
[315,"Nursery","Non-London",null,"NNL"]
[null,"Nursery","Non-London",null,"Spend on teaching staff as a percentage of total expenditure - 2017-18",{"v":0.16,"d":"16.0%"},{"v":0.195,"d":"19.5%"},{"v":0.245,"d":"24.5%"},{"v":0.26,"d":"26.0%"},{"v":0.29,"d":"29.0%"},{"v":0.34,"d":"34.0%"},{"v":0.38,"d":"38.0%"}]
[null,"Nursery","Non-London",null,"Spend on teaching staff as a percentage of total expenditure - 2018-19",{"v":0.16,"d":"16.0%"},{"v":0.195,"d":"19.5%"},{"v":0.245,"d":"24.5%"},{"v":0.265,"d":"26.5%"},{"v":0.29,"d":"29.0%"},{"v":0.345,"d":"34.5%"},{"v":0.385,"d":"38.5%"}]
[null,"Nursery","Non-London",null,"Spend on teaching staff as a percentage of total expenditure - 2019-20",{"v":0.17,"d":"17.0%"},{"v":0.205,"d":"20.5%"},{"v":0.26,"d":"26.0%"},{"v":0.275,"d":"27.5%"},{"v":0.305,"d":"30.5%"},{"v":0.355,"d":"35.5%"},{"v":0.4,"d":"40.0%"}]
[null,"Nursery","Non-London",null,"Spend on teaching staff as a percentage of total expenditure - 2019/20",{"v":0.175,"d":"17.5%"},{"v":0.21,"d":"21.0%"},{"v":0.265,"d":"26.5%"},{"v":0.285,"d":"28.5%"},{"v":0.31,"d":"31.0%"},{"v":0.365,"d":"36.5%"},{"v":0.405,"d":"40.5%"}]
[null,"Nursery","Non-London",null,"Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.005,"d":"0.5%"},{"v":0.01,"d":"1.0%"},{"v":0.015,"d":"1.5%"},{"v":0.03,"d":"3.0%"},{"v":0.05,"d":"5.0%"}]
[null,"Nursery","Non-London",null,"Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.295,"d":"29.5%"},{"v":0.335,"d":"33.5%"},{"v":0.36,"d":"36.0%"},{"v":0.43,"d":"43.0%"},{"v":0.475,"d":"47.5%"}]
[null,"Nursery","Non-London",null,"Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.07,"d":"7.0%"},null,{"v":0.1,"d":"10.0%"},{"v":0.125,"d":"12.5%"}]
[null,"Nursery","Non-London",null,"Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.03,"d":"3.0%"},null,{"v":0.06,"d":"6.0%"},{"v":0.095,"d":"9.5%"}]
[null,"Nursery","Non-London",null,"Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.055,"d":"5.5%"},null,{"v":0.075,"d":"7.5%"},{"v":0.1,"d":"10.0%"}]
[null,"Nursery","Non-London",null,"Spend on teaching resources as a percentage of total expenditure",{"v":0.01,"d":"1.0%"},{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"},{"v":0.02,"d":"2.0%"},{"v":0.025,"d":"2.5%"}]
[null,"Nursery","Non-London",null,"Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
[null,"Nursery","Non-London",null,"Senior leaders as a percentage of workforce",null,null,{"v":0.085,"d":"8.5%"},{"v":0.095,"d":"9.5%"},{"v":0.105,"d":"10.5%"},{"v":0.14,"d":"14.0%"},{"v":0.17,"d":"17.0%"}]
[null,"Nursery","Non-London",null,"Pupil to teacher ratio",{"v":14,"d":"14.0"},16.5,{"v":20,"d":"20.0"},21.5,{"v":24,"d":"24.0"},{"v":30,"d":"30.0"},38.5]
[null,"Nursery","Non-London",null,"Pupil to adult ratio",{"v":3,"d":"3.0"},3.5,4.5,4.5,{"v":5,"d":"5.0"},{"v":6,"d":"6.0"},{"v":7,"d":"7.0"}]
[null,"Nursery","Non-London",null,"Average teacher cost (£) - 2017-18",{"v":39500,"d":"£39,500"},{"v":47000,"d":"£47,000"},{"v":51000,"d":"£51,000"},{"v":54000,"d":"£54,000"},{"v":56000,"d":"£56,000"},{"v":61500,"d":"£61,500"},{"v":65000,"d":"£65,000"}]
[null,"Nursery","Non-London",null,"Average teacher cost (£) - 2018-19",{"v":40000,"d":"£40,000"},{"v":47500,"d":"£47,500"},{"v":51500,"d":"£51,500"},{"v":54500,"d":"£54,500"},{"v":56500,"d":"£56,500"},{"v":62000,"d":"£62,000"},{"v":66000,"d":"£66,000"}]
[null,"Nursery","Non-London",null,"Average teacher cost (£) - 2019-20",{"v":42500,"d":"£42,500"},{"v":50500,"d":"£50,500"},{"v":55000,"d":"£55,000"},{"v":58000,"d":"£58,000"},{"v":60000,"d":"£60,000"},{"v":66000,"d":"£66,000"},{"v":70000,"d":"£70,000"}]
[null,"Nursery","Non-London",null,"Average teacher cost (£) - 2019/20",{"v":44000,"d":"£44,000"},{"v":52500,"d":"£52,500"},{"v":56500,"d":"£56,500"},{"v":60000,"d":"£60,000"},{"v":62000,"d":"£62,000"},{"v":68000,"d":"£68,000"},{"v":72500,"d":"£72,500"}]
[]
["Sample size","Phase","London?","This shows the average teacher cost for primary and secondary schools. All others are above",null,"Red if less than:","Amber if less than:","Dark green if between:","(Median)","and:","Amber if more than:","Red if more than:",null,"Light green for everything else"]
[{"v":1721,"d":"1,721"},"Primary","London",null,"PL"]
[null,"Primary","London",null,"Average teacher cost (£) - 2017-18",{"v":44000,"d":"£44,000"},{"v":47000,"d":"£47,000"},{"v":50500,"d":"£50,500"},{"v":51500,"d":"£51,500"},{"v":53500,"d":"£53,500"},{"v":57500,"d":"£57,500"},{"v":61500,"d":"£61,500"}]
[null,"Primary","London",null,"Average teacher cost (£) - 2018-19",{"v":44500,"d":"£44,500"},{"v":47500,"d":"£47,500"},{"v":51000,"d":"£51,000"},{"v":52500,"d":"£52,500"},{"v":54000,"d":"£54,000"},{"v":58000,"d":"£58,000"},{"v":62500,"d":"£62,500"}]
[null,"Primary","London",null,"Average teacher cost (£) - 2019-20",{"v":47500,"d":"£47,500"},{"v":50500,"d":"£50,500"},{"v":54000,"d":"£54,000"},{"v":55500,"d":"£55,500"},{"v":57500,"d":"£57,500"},{"v":62000,"d":"£62,000"},{"v":66000,"d":"£66,000"}]
[null,"Primary","London",null,"Average teacher cost (£) - 2019/20",{"v":49000,"d":"£49,000"},{"v":52000,"d":"£52,000"},{"v":56000,"d":"£56,000"},{"v":57500,"d":"£57,500"},{"v":59000,"d":"£59,000"},{"v":64000,"d":"£64,000"},{"v":68500,"d":"£68,500"}]
[]
[{"v":13651,"d":"13,651"},"Primary","Non-London",null,"PNL"]
[null,"Primary","Non-London",null,"Average teacher cost (£) - 2017-18",{"v":40000,"d":"£40,000"},{"v":42000,"d":"£42,000"},{"v":45000,"d":"£45,000"},{"v":46500,"d":"£46,500"},{"v":47500,"d":"£47,500"},{"v":51000,"d":"£51,000"},{"v":54000,"d":"£54,000"}]
[null,"Primary","Non-London",null,"Average teacher cost (£) - 2018-19",{"v":40500,"d":"£40,500"},{"v":42500,"d":"£42,500"},{"v":46000,"d":"£46,000"},{"v":47000,"d":"£47,000"},{"v":48500,"d":"£48,500"},{"v":51500,"d":"£51,500"},{"v":55000,"d":"£55,000"}]
[null,"Primary","Non-London",null,"Average teacher cost (£) - 2019-20",{"v":42500,"d":"£42,500"},{"v":45500,"d":"£45,500"},{"v":48500,"d":"£48,500"},{"v":50000,"d":"£50,000"},{"v":51500,"d":"£51,500"},{"v":55000,"d":"£55,000"},{"v":58000,"d":"£58,000"}]
[null,"Primary","Non-London",null,"Average teacher cost (£) - 2019/20",{"v":44000,"d":"£44,000"},{"v":47000,"d":"£47,000"},{"v":50000,"d":"£50,000"},{"v":51500,"d":"£51,500"},{"v":53000,"d":"£53,000"},{"v":56500,"d":"£56,500"},{"v":60000,"d":"£60,000"}]
[]
[328,"Secondary with sixth form","London",null,"SSLo"]
[null,"Secondary with sixth form","London",null,"Average teacher cost (£) - 2017-18",{"v":50500,"d":"£50,500"},{"v":53000,"d":"£53,000"},{"v":55000,"d":"£55,000"},{"v":57000,"d":"£57,000"},{"v":58500,"d":"£58,500"},{"v":62000,"d":"£62,000"},{"v":65500,"d":"£65,500"}]
[null,"Secondary with sixth form","London",null,"Average teacher cost (£) - 2018-19",{"v":51000,"d":"£51,000"},{"v":53500,"d":"£53,500"},{"v":56000,"d":"£56,000"},{"v":57500,"d":"£57,500"},{"v":59000,"d":"£59,000"},{"v":62500,"d":"£62,500"},{"v":66500,"d":"£66,500"}]
[null,"Secondary with sixth form","London",null,"Average teacher cost (£) - 2019-20",{"v":54000,"d":"£54,000"},{"v":57000,"d":"£57,000"},{"v":59500,"d":"£59,500"},{"v":61000,"d":"£61,000"},{"v":62500,"d":"£62,500"},{"v":66500,"d":"£66,500"},{"v":70500,"d":"£70,500"}]
[null,"Secondary with sixth form","London",null,"Average teacher cost (£) - 2019/20",{"v":56000,"d":"£56,000"},{"v":58500,"d":"£58,500"},{"v":61500,"d":"£61,500"},{"v":63000,"d":"£63,000"},{"v":65000,"d":"£65,000"},{"v":68500,"d":"£68,500"},{"v":73000,"d":"£73,000"}]
[]
[{"v":1861,"d":"1,861"},"Secondary with sixth form","Non-London",null,"SSNL"]
[null,"Secondary with sixth form","Non-London",null,"Average teacher cost (£) - 2017-18",{"v":45500,"d":"£45,500"},{"v":47500,"d":"£47,500"},{"v":50000,"d":"£50,000"},{"v":51000,"d":"£51,000"},{"v":52000,"d":"£52,000"},{"v":54500,"d":"£54,500"},{"v":56500,"d":"£56,500"}]
[null,"Secondary with sixth form","Non-London",null,"Average teacher cost (£) - 2018-19",{"v":46000,"d":"£46,000"},{"v":48500,"d":"£48,500"},{"v":51000,"d":"£51,000"},{"v":51500,"d":"£51,500"},{"v":52500,"d":"£52,500"},{"v":55000,"d":"£55,000"},{"v":57500,"d":"£57,500"}]
[null,"Secondary with sixth form","Non-London",null,"Average teacher cost (£) - 2019-20",{"v":49000,"d":"£49,000"},{"v":51500,"d":"£51,500"},{"v":54000,"d":"£54,000"},{"v":55000,"d":"£55,000"},{"v":56000,"d":"£56,000"},{"v":58500,"d":"£58,500"},{"v":61000,"d":"£61,000"}]
[null,"Secondary with sixth form","Non-London",null,"Average teacher cost (£) - 2019/20",{"v":50500,"d":"£50,500"},{"v":53000,"d":"£53,000"},{"v":55500,"d":"£55,500"},{"v":56500,"d":"£56,500"},{"v":58000,"d":"£58,000"},{"v":60500,"d":"£60,500"},{"v":63000,"d":"£63,000"}]
[]
[96,"Secondary without sixth form","London",null,"SL"]
[null,"Secondary without sixth form","London",null,"Average teacher cost (£) - 2017-18",{"v":47500,"d":"£47,500"},{"v":52000,"d":"£52,000"},{"v":55500,"d":"£55,500"},{"v":58000,"d":"£58,000"},{"v":60000,"d":"£60,000"},{"v":63500,"d":"£63,500"},{"v":66500,"d":"£66,500"}]
[null,"Secondary without sixth form","London",null,"Average teacher cost (£) - 2018-19",{"v":48500,"d":"£48,500"},{"v":53000,"d":"£53,000"},{"v":56500,"d":"£56,500"},{"v":58500,"d":"£58,500"},{"v":61000,"d":"£61,000"},{"v":64500,"d":"£64,500"},{"v":67500,"d":"£67,500"}]
[null,"Secondary without sixth form","London",null,"Average teacher cost (£) - 2019-20",{"v":51000,"d":"£51,000"},{"v":56000,"d":"£56,000"},{"v":60000,"d":"£60,000"},{"v":62500,"d":"£62,500"},{"v":64500,"d":"£64,500"},{"v":68500,"d":"£68,500"},{"v":71500,"d":"£71,500"}]
[null,"Secondary without sixth form","London",null,"Average teacher cost (£) - 2019/20",{"v":53000,"d":"£53,000"},{"v":58000,"d":"£58,000"},{"v":62000,"d":"£62,000"},{"v":64500,"d":"£64,500"},{"v":67000,"d":"£67,000"},{"v":71000,"d":"£71,000"},{"v":74000,"d":"£74,000"}]
[]
[678,"Secondary without sixth form","Non-London",null,"SNL"]
[null,"Secondary without sixth form","Non-London",null,"Average teacher cost (£) - 2017-18",{"v":45500,"d":"£45,500"},{"v":47500,"d":"£47,500"},{"v":50000,"d":"£50,000"},{"v":51000,"d":"£51,000"},{"v":51500,"d":"£51,500"},{"v":54500,"d":"£54,500"},{"v":57000,"d":"£57,000"}]
[null,"Secondary without sixth form","Non-London",null,"Average teacher cost (£) - 2018-19",{"v":46000,"d":"£46,000"},{"v":48000,"d":"£48,000"},{"v":50500,"d":"£50,500"},{"v":51500,"d":"£51,500"},{"v":52500,"d":"£52,500"},{"v":55500,"d":"£55,500"},{"v":58000,"d":"£58,000"}]
[null,"Secondary without sixth form","Non-London",null,"Average teacher cost (£) - 2019-20",{"v":48500,"d":"£48,500"},{"v":51000,"d":"£51,000"},{"v":53500,"d":"£53,500"},{"v":54500,"d":"£54,500"},{"v":55500,"d":"£55,500"},{"v":58500,"d":"£58,500"},{"v":61500,"d":"£61,500"}]
[null,"Secondary without sixth form","Non-London",null,"Average teacher cost (£) - 2019/20",{"v":50500,"d":"£50,500"},{"v":53000,"d":"£53,000"},{"v":55500,"d":"£55,500"},{"v":56500,"d":"£56,500"},{"v":57500,"d":"£57,500"},{"v":60500,"d":"£60,500"},{"v":63500,"d":"£63,500"}]

{"sheet":"Calcs","index":6,"n_rows":66,"n_cols":27,"rows_kept":66,"hidden":true}
[]
["RAG ratings for each school"]
[]
[null,null,1,{"$nulls":11},"2017-18 (financial year)"]
[null,null,{"$f":"IF(Dashboard!D17=\"Primary\",\"P\",IF(Dashboard!D17=\"Secondary with sixth form\",\"SS\",IF(Dashboard!D17=\"Secondary without sixth form\",\"S\",IF(Dashboard!D17=\"Special\",\"SP\",IF(Dashboard!D17=\"Alternative provision\",\"AP\",IF(Dashboard!D17=\"All-through\",\"AT\",IF(Dashboard!D17=\"Nursery\",\"N\")))))))","v":"P"},{"$nulls":11},"2018-19 (financial year)"]
[null,null,{"$f":"C5&\nIF($J29=\"very small\",\"VS\",IF($J29=\"small\",\"S\",IF($J29=\"medium\",\"M\",IF($J29=\"large\",\"L\"))))&\nIF($K29=\"low levels of FSM\",\"L\",IF($K29=\"medium levels of FSM\",\"M\",IF($K29=\"high levels of FSM\",\"H\")))","v":"PLH"},{"$nulls":11},"2019-20 (financial year)"]
[null,null,{"$f":"C5&\nIF(AND(C5=\"SS\",$I29=\"in London\"),\"Lo\",IF($I29=\"in London\",\"L\",IF($I29=\"outside London\",\"NL\")))","v":"PNL"},{"$nulls":11},"2019/20 (academic year) or later"]
[null,null,1,2,3,4,5,6,7]
["Spend on teaching staff as a percentage of total expenditure",{"$f":"IF(Dashboard!D21=O4,1,IF(Dashboard!D21=O5,2,IF(Dashboard!D21=O6,3,IF(Dashboard!D21=O7,4))))","v":3},{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$6),$B9,C$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"AT\",$C$5=\"SP\"),INDEX(INDIRECT($C$7),$B9,C$8)))","v":{"v":0.37,"d":"37.0%"}},{"v":0.395,"d":"39.5%"},{"v":0.43,"d":"43.0%"},{"v":0.44,"d":"44.0%"},{"v":0.455,"d":"45.5%"},{"v":0.485,"d":"48.5%"},{"v":0.51,"d":"51.0%"}]
["Spend on supply staff as a percentage of total expenditure",5,null,null,{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$6),$B10,E$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"AT\",$C$5=\"SP\"),INDEX(INDIRECT($C$7),$B10,E$8)))","v":{"v":0.02,"d":"2.0%"}},{"v":0.025,"d":"2.5%"},{"v":0.03,"d":"3.0%"},{"v":0.045,"d":"4.5%"},{"v":0.06,"d":"6.0%"}]
["Spend on education support staff as a percentage of total expenditure",6,null,null,{"v":0.195,"d":"19.5%"},{"v":0.205,"d":"20.5%"},{"v":0.22,"d":"22.0%"},{"v":0.25,"d":"25.0%"},{"v":0.265,"d":"26.5%"}]
["Spend on administrative and clerical staff as a percentage of total expenditure",7,{"$nulls":3},{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$6),$B12,F$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"AT\",$C$5=\"SP\"),INDEX(INDIRECT($C$7),$B12,F$8)))","v":{"v":0.045,"d":"4.5%"}},null,{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$6),$B12,H$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"AT\",$C$5=\"SP\"),INDEX(INDIRECT($C$7),$B12,H$8)))","v":{"v":0.06,"d":"6.0%"}},{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$6),$B12,I$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"AT\",$C$5=\"SP\"),INDEX(INDIRECT($C$7),$B12,I$8)))","v":{"v":0.075,"d":"7.5%"}}]
["Spend on other staff costs as a percentage of total expenditure",8,{"$nulls":3},{"v":0.035,"d":"3.5%"},null,{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$6),$B13,H$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"AT\",$C$5=\"SP\"),INDEX(INDIRECT($C$7),$B13,H$8)))","v":{"v":0.045,"d":"4.5%"}},{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$6),$B13,I$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"AT\",$C$5=\"SP\"),INDEX(INDIRECT($C$7),$B13,I$8)))","v":{"v":0.06,"d":"6.0%"}}]
["Spend on premises (including staff costs) as a percentage of total expenditure",9,{"$nulls":3},{"v":0.05,"d":"5.0%"},null,{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$6),$B14,H$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"AT\",$C$5=\"SP\"),INDEX(INDIRECT($C$7),$B14,H$8)))","v":{"v":0.07,"d":"7.0%"}},{"v":0.08,"d":"8.0%"}]
["Spend on teaching resources as a percentage of total expenditure",10,{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$6),$B15,C$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"AT\",$C$5=\"SP\"),INDEX(INDIRECT($C$7),$B15,C$8)))","v":{"v":0.025,"d":"2.5%"}},{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$6),$B15,D$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"AT\",$C$5=\"SP\"),INDEX(INDIRECT($C$7),$B15,D$8)))","v":{"v":0.03,"d":"3.0%"}},{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$6),$B15,E$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"AT\",$C$5=\"SP\"),INDEX(INDIRECT($C$7),$B15,E$8)))","v":{"v":0.04,"d":"4.0%"}},{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$6),$B15,F$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"AT\",$C$5=\"SP\"),INDEX(INDIRECT($C$7),$B15,F$8)))","v":{"v":0.045,"d":"4.5%"}},{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$6),$B15,G$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"AT\",$C$5=\"SP\"),INDEX(INDIRECT($C$7),$B15,G$8)))","v":{"v":0.05,"d":"5.0%"}}]
["Spend on energy as a percentage of total expenditure",11,{"$nulls":3},{"v":0.01,"d":"1.0%"},null,{"v":0.015,"d":"1.5%"},{"v":0.02,"d":"2.0%"}]
["Senior leaders as a percentage of workforce",12,null,null,{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$6),$B17,E$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"AT\",$C$5=\"SP\"),INDEX(INDIRECT($C$7),$B17,E$8)))","v":{"v":0.065,"d":"6.5%"}},{"v":0.07,"d":"7.0%"},{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$6),$B17,G$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"AT\",$C$5=\"SP\"),INDEX(INDIRECT($C$7),$B17,G$8)))","v":{"v":0.075,"d":"7.5%"}},{"v":0.09,"d":"9.0%"},{"v":0.105,"d":"10.5%"}]
["Pupil to teacher ratio",13,{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$6),$B18,C$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"AT\",$C$5=\"SP\"),INDEX(INDIRECT($C$7),$B18,C$8)))","v":{"v":17,"d":"17.0"}},{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$6),$B18,D$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"AT\",$C$5=\"SP\"),INDEX(INDIRECT($C$7),$B18,D$8)))","v":{"v":18,"d":"18.0"}},{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$6),$B18,E$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"AT\",$C$5=\"SP\"),INDEX(INDIRECT($C$7),$B18,E$8)))","v":{"v":20,"d":"20.0"}},20.5,{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$6),$B18,G$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"AT\",$C$5=\"SP\"),INDEX(INDIRECT($C$7),$B18,G$8)))","v":{"v":21,"d":"21.0"}},{"v":23,"d":"23.0"},24.5]
["Pupil to adult ratio",14,{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$6),$B19,C$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"AT\",$C$5=\"SP\"),INDEX(INDIRECT($C$7),$B19,C$8)))","v":{"v":7,"d":"7.0"}},{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$6),$B19,D$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"AT\",$C$5=\"SP\"),INDEX(INDIRECT($C$7),$B19,D$8)))","v":7.5},{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$6),$B19,E$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"AT\",$C$5=\"SP\"),INDEX(INDIRECT($C$7),$B19,E$8)))","v":{"v":8,"d":"8.0"}},8.5,{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$6),$B19,G$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"AT\",$C$5=\"SP\"),INDEX(INDIRECT($C$7),$B19,G$8)))","v":{"v":9,"d":"9.0"}},9.5,10.5]
["Average class size",15,{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$6),$B20,C$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"SP\"),\"\",IF($C$5=\"AT\",INDEX(INDIRECT($C$7),$B20,C$8))))","v":24.5},25.5,{"v":27,"d":"27.0"},27.5,{"v":28,"d":"28.0"},{"v":29,"d":"29.0"},29.5]
["Average teacher cost",{"$f":"IF(Dashboard!D21=O4,16,IF(Dashboard!D21=O5,17,IF(Dashboard!D21=O6,18,IF(Dashboard!D21=O7,19))))-IF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"SP\"),1,0)","v":18},{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$7),$B$9,C$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"SP\",$C$5=\"AT\"),INDEX(INDIRECT($C$7),$B21,C$8)))","v":{"v":42500,"d":"£42,500"}},{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$7),$B$9,D$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"SP\",$C$5=\"AT\"),INDEX(INDIRECT($C$7),$B21,D$8)))","v":{"v":45500,"d":"£45,500"}},{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$7),$B$9,E$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"SP\",$C$5=\"AT\"),INDEX(INDIRECT($C$7),$B21,E$8)))","v":{"v":48500,"d":"£48,500"}},{"v":50000,"d":"£50,000"},{"v":51500,"d":"£51,500"},{"v":55000,"d":"£55,000"},{"v":58000,"d":"£58,000"}]
[]
[]
[]
[]
["Information for the 'RAG rating data for your school' look ups"]
[]
["School name from dashboard",null,null,"Named ranges for RAG ratings above","School information from dashboard",{"$nulls":3},"Info for comparison description"]
[{"$f":"IF(Dashboard!D$15=0,\"\",Dashboard!D$15)","v":"The Richmond School, Skegness"},1,"H","A",{"$f":"IF(Dashboard!D$17=0,\"\",Dashboard!D$17)","v":"Primary"},{"$f":"IF(Dashboard!D$18=0,\"\",Dashboard!D$18)","v":"East Midlands"},{"$f":"IF(Dashboard!D$19=0,\"\",Dashboard!D$19)","v":420},{"$f":"Dashboard!D$20","v":0.33},{"$f":"IF(F29=\"\",\"\",IF(OR(F29=\"Inner London\",F29=\"Outer London\"),\"in London\",\"outside London\"))","v":"outside London"},{"$f":"IF(AND(E29=\"Primary\",G29<=$X$30),\"very small\",IF(AND(E29=\"Primary\",G29<=$Y$30,G29>$X$30),\"small\",IF(AND(E29=\"Primary\",G29>$Y$30,G29<=$Z$30),\"medium\",IF(AND(E29=\"Primary\",G29>$Z$30),\"large\",\nIF(AND(E29=\"Secondary with sixth form\",G29<=$Y$31),\"small\",IF(AND(E29=\"Secondary with sixth form\",G29>$Y$31,G29<=$Z$31),\"medium\",IF(AND(E29=\"Secondary with sixth form\",G29>$Z$31),\"large\",\nIF(AND(E29=\"Secondary without sixth form\",G29<=$Y$32),\"small\",IF(AND(E29=\"Secondary without sixth form\",G29>$Y$32,G29<=$Z$32),\"medium\",IF(AND(E29=\"Secondary without sixth form\",G29>$Z$32),\"large\",\"\"))))))))))","v":"large"},{"$f":"IF(AND(E29=\"Primary\",H29<=$X$35),\"low levels of FSM\",IF(AND(E29=\"Primary\",H29>$X$35,H29<=$Y$35),\"medium levels of FSM\",IF(AND(E29=\"Primary\",H29>$Y$35),\"high levels of FSM\",\nIF(AND(E29=\"Secondary with sixth form\",H29<=$X$36),\"low levels of FSM\",IF(AND(E29=\"Secondary with sixth form\",H29>$X$36,H29<=$Y$36),\"medium levels of FSM\",IF(AND(E29=\"Secondary with sixth form\",H29>$Y$36),\"high levels of FSM\",\nIF(AND(E29=\"Secondary without sixth form\",H29<=$X$37),\"low levels of FSM\",IF(AND(E29=\"Secondary without sixth form\",H29>$X$37,H29<=$Y$37),\"medium levels of FSM\",IF(AND(E29=\"Secondary without sixth form\",H29>$Y$37),\"high levels of FSM\",\"\")))))))))","v":"high levels of FSM"},{"$f":"IF(E29=\"Primary\",\"a primary school\",IF(E29=\"Secondary with sixth form\",\"a secondary school with a sixth form\",IF(E29=\"Secondary without sixth form\",\"a secondary school without a sixth form\",IF(E29=\"Special\",\"a special school\",IF(E29=\"Alternative provision\",\"an alternative provision school\",IF(E29=\"All-through\",\"an all-through school\",IF(E29=\"Nursery\",\"a nursery school\",\"\")))))))","v":"a primary school"},{"$f":"IF(AND(E29=\"Primary\",J29=\"very small\"),$X$30&\" or fewer pupils\",\nIF(AND(E29=\"Primary\",J29=\"small\"),\"between \"&$X$30+1&\" and \"&$Y$30&\" pupils\",\nIF(AND(E29=\"Primary\",J29=\"medium\"),\"between \"&$Y$30+1&\" and \"&$Z$30&\" pupils\",\nIF(AND(E29=\"Primary\",J29=\"large\"),\"more than \"&$Z$30&\" pupils\",\n\nIF(AND(E29=\"Secondary with sixth form\",J29=\"small\"),$Y$31&\" or fewer pupils\",\nIF(AND(E29=\"Secondary with sixth form\",J29=\"medium\"),\"between \"&$Y$31+1&\" and \"&$Z$31&\" pupils\",\nIF(AND(E29=\"Secondary with sixth form\",J29=\"large\"),\"more than \"&$Z$31&\" pupils\",\n\nIF(AND(E29=\"Secondary without sixth form\",J29=\"small\"),$Y$32&\" or fewer pupils\",\nIF(AND(E29=\"Secondary without sixth form\",J29=\"medium\"),\"between \"&$Y$32+1&\" and \"&$Z$32&\" pupils\",\nIF(AND(E29=\"Secondary without sixth form\",J29=\"large\"),\"more than \"&$Z$32&\" pupils\",\"\"))))))))))","v":"more than 385 pupils"},{"$f":"IF(AND(E29=\"Primary\",K29=\"low levels of FSM\"),\"less than \"&$Z$35&\" of pupils\",\nIF(AND(E29=\"Primary\",K29=\"medium levels of FSM\"),\"between \"&$Z$35&\" and \"&$AA$35&\" of pupils\",\nIF(AND(E29=\"Primary\",K29=\"high levels of FSM\"),\"more than \"&$AA$35&\" of pupils\",\n\nIF(AND(E29=\"Secondary with sixth form\",K29=\"low levels of FSM\"),\"less than \"&$Z$36&\" of pupils\",\nIF(AND(E29=\"Secondary with sixth form\",K29=\"medium levels of FSM\"),\"between \"&$Z$36&\" and \"&$AA$36&\" of pupils\",\nIF(AND(E29=\"Secondary with sixth form\",K29=\"high levels of FSM\"),\"more than \"&$AA$36&\" of pupils\",\n\nIF(AND(E29=\"Secondary without sixth form\",K29=\"low levels of FSM\"),\"less than \"&$Z$37&\" of pupils\",\nIF(AND(E29=\"Secondary without sixth form\",K29=\"medium levels of FSM\"),\"between \"&$Z$37&\" and \"&$AA$37&\" of pupils\",\nIF(AND(E29=\"Secondary without sixth form\",K29=\"high levels of FSM\"),\"more than \"&$AA$37&\" of pupils\",\"\")))))))))","v":"more than 18% of pupils"},{"$f":"IF(Dashboard!D$21=0,\"\",Dashboard!D$21)","v":"2019-20 (financial year)"},{"$nulls":8},"Very small","Small","Medium"]
[{"$nulls":22},"Primary",100,175,385]
[{"$nulls":22},"Secondary with sixth form",null,770,{"v":1300,"d":"1,300"}]
[{"$nulls":22},"Secondary without sixth form",null,485,935]
[]
[{"$nulls":23},"Low","Medium"]
[{"$nulls":22},"Primary",0.05,0.18,{"$f":"(X35*100)&\"%\"","v":"5%"},"18%"]
[{"$nulls":22},"Secondary with sixth form",0.06,0.165,"6%","16.5%"]
[{"$nulls":22},"Secondary without sixth form",0.08,0.215,"8%","21.5%"]
[]
[]
[]
[]
[]
["RAG rating text for dashboard"]
[]
["Lowest 10% of similar schools","Much lower than recommended"]
["Lowest 20% of similar schools","Lower than recommended"]
["Broadly in line with similar schools","Broadly in line with recommendations"]
["Middle 20% of similar schools","Higher than recommended"]
["Highest 20% of similar schools","Much higher than recommended"]
["Highest 10% of similar schools"]
[null,"Inadequate"]
[null,"Requires Improvement"]
["High risk","Good"]
["Medium risk","Outstanding"]
["Low risk"]
[null,"Well below average"]
[null,"Below average"]
[null,"Average or above average"]
[null,"Well above average"]
[]
[]
["Primary"]
["Secondary with sixth form"]
["Secondary without sixth form"]
["All-through"]
[{"$f":"\"\"","v":""}]