{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["Enable Macros","Introduction and outcomes","Checklist","Dashboard","Data_Store","File_Statistics","Optional - input raw data","RAG rating data for your school","RAG rating data for all schools","RAG_Calculation"],"not_rendered":{"images":8,"macros":1,"defined_names":100},"read":"whole","date_system":"1900"}

{"sheet":"Enable Macros","index":0,"n_rows":15,"n_cols":4,"rows_kept":15,"merged":[[2,2,2,19],[4,2,4,19],[5,2,5,19],[6,2,6,19],[7,2,7,19],[10,2,10,19],[13,3,13,18],[14,3,18,18],[22,2,22,9]]}
[]
[]
[null,null,"Introduction to the schools resource management self-assessment tool"]
[]
[null,null,"The school resource management self-assessment tool helps to provide trusts with assurance that they are meeting the basic standards necessary to achieve a good\nlevel 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 trust boards in six areas of resource management to provide assurance that the trust  is managing its resources effectively. This should be completed at trust level."]
[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. This should be completed at school level."]
[null,null,"Completion of the self-assessment tool is compulsory for all academy trusts. This document includes pre-populated dashboard(s) for the school(s) in your trust to support the completion and analysis of the tool."]
[]
[]
[null,null,"To ensure that the workbook functions as anticipated, Macros must be enabled"]
[]
[{"$nulls":3},"Step by step guide to enabling macros:"]
[{"$nulls":3},"\n1) Click the enable content button appearing in the banner below the ribbon\n\n\n\n\n\n2) Macros should now be enabled, the user can click here to access all features of the file.\n\n\n\n\n\nShould this not work, please follow the steps below in order to enable Macros:"]
[{"$nulls":3},"1)  The User will need to add the developer tab to their ribbon:\n\n       a. The user should click the file button\n\n      b. The user should then navigate to the ‘Options’ section\n\n\n\n\n\n\n\n\n\n       c. The user should then click the ‘Customise ribbon’ section\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n       d. The user should select and add the ‘developer’ section to their ribbon\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n2) The user will need to navigate to the developer section of the ribbon\n\n3) The user should then click ‘Macro Security’ \n\n\n\n\n\n\n\n\n\n\n\n4) The user should then click ‘Enable all Macros’\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n5) Macros should now be enabled, the user can click here to access all features of the file.\n\n"]

{"sheet":"Introduction and outcomes","index":1,"n_rows":20,"n_cols":15,"rows_kept":20,"hidden":true,"merged":[[2,2,2,19],[4,2,4,19],[5,2,5,19],[6,2,6,19],[7,2,7,19],[10,2,10,19],[12,2,12,19],[13,2,13,19],[15,2,15,10],[15,11,15,13],[15,14,15,18],[17,2,17,10],[17,11,17,13],[19,2,19,10],[19,11,19,13],[21,2,21,9]]}
[]
[]
[null,null,"Introduction to the schools resource management self-assessment tool"]
[]
[null,null,"The school resource management self-assessment tool helps to provide trusts with assurance that they are meeting the basic standards necessary to achieve a good\nlevel 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 trust boards in six areas of resource management to provide assurance that the trust is managing its resources effectively. This should be completed at trust level."]
[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. This should be completed at school level."]
[null,null,"Completion of the self-assessment tool is compulsory for all academy trusts. This document includes pre-populated dashboard(s) for the school(s) in your trust to support the completion and analysis of the tool."]
[]
[]
[null,null,"Outcome of school resource management self-assessment"]
[]
[null,null,"Summary of agreed action and timetable for reporting back:"]
[null,null,"\n[enter text]"]
[]
[null,null,"Signature:",{"$nulls":11},"Chair of trust board"]
[]
[null,null,"Full name of signatory:"]
[]
[null,null,"Date self-assessment agreed:"]

{"sheet":"Checklist","index":2,"n_rows":84,"n_cols":17,"rows_kept":84,"hidden":true,"merged":[[2,2,2,16],[4,2,4,16],[5,2,5,16],[6,2,6,16],[8,2,9,5],[8,6,9,16],[12,2,12,16],[15,3,15,9],[16,3,16,9],[17,3,17,9],[18,3,18,9],[19,3,19,9],[20,3,20,9],[21,3,21,9],[22,3,22,9],[23,3,23,9],[24,3,24,9],[25,3,25,9],[26,3,26,9],[27,3,27,9],[28,3,28,9],[29,3,29,9],[30,3,30,9],[31,3,31,9],[32,3,32,9],[33,3,33,9],[34,3,34,9],[35,3,35,9],[37,2,37,16],[39,3,39,9],[40,3,40,9],[41,3,41,9],[42,3,42,9],[43,3,43,9],[44,3,44,9],[45,3,45,9],[46,3,46,9],[47,3,47,9],[48,3,48,9],[50,2,50,16],[52,3,52,9],[53,3,53,9],[54,3,54,9],[55,3,55,9],[56,3,56,9],[58,2,58,16],[60,3,60,9],[61,3,61,9],[62,3,62,9],[63,3,63,9],[65,2,65,16],[67,3,67,9],[68,3,68,9],[69,3,69,9],[70,3,70,9],[71,3,71,9],[73,2,73,16],[75,3,75,9],[76,3,76,9],[77,3,77,9],[78,3,78,9],[79,3,79,9],[81,2,81,16],[83,3,83,9],[85,2,85,9]]}
[]
[]
[null,null,"School resource management self-assessment checklist"]
[]
[null,null,"The checklist asks a number of questions of trust boards in six areas of resource management to help provide assurance that resources are being managed effectively. \n\nIn 2021-22 the deadline for submission of the self-assessment checklist is 15th April. This downloaded form can be used to prepare for the return or to assess use of resources at various points throughout the year.\n\nThe checklist should be completed at academy trust level. "]
[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 trusts in addressing specific issues. Clicking on the individual questions below will also take you to the relevant section of the guidance. "]
[null,null,"Trusts should answer each question with 'yes', 'no', or 'in part' from the drop down lists provided, or with a number, as appropriate. If a trust answers 'no' or 'in part' to a question, they must provide a target date and comments. Trusts may also provide comments, evidence and proposed actions for 'yes' answers."]
[]
[null,null,"Trust name:",{"$nulls":3},"Shenfield High School"]
[]
[]
[{"$nulls":12},"Answer\n(yes, in part, no)",null,"Target date",null,"Comments, evidence and proposed actions"]
[null,null,"A. Governance"]
[]
[]
[null,null,1,"Have the Chief Financial Officer, Accounting Officer and chair of trustees read the current edition of the Academies Financial Handbook?",{"$nulls":6},"Q1 guidance",null,"Yes"]
[null,null,"1A","Do they understand their role in complying with the trust’s charitable objects, with company and charity law, and with the funding agreement?",{"$nulls":6},"Q1A guidance",null,"Yes"]
[null,null,2,"Has the board assessed its composition during the year in terms of skills, effectiveness, leadership and impact?",{"$nulls":6},"Q2 guidance",null,"Yes"]
[null,null,3,"Does the board have a plan in place to address any gaps in its capabilities through recruitment, induction, training or other development activity?",{"$nulls":6},"Q3 guidance",null,"Yes"]
[null,null,4,"Has the board appointed the senior executive leader as accounting officer?",{"$nulls":6},"Q4 guidance",null,"Yes"]
[null,null,"4A","Has the board assured itself that the senior leader has appropriate skills to fulfill their role as accounting officer in accordance with the financial responsibilities of the duty to the public purse?",{"$nulls":6},"Q4A guidance",null,"Yes"]
[null,null,5,"Has the board appointed a qualified and/or experienced chief financial officer?",{"$nulls":6},"Q5 guidance",null,"Yes"]
[null,null,6,"Has the board appointed a clerk who is someone other than a trustee, principal or chief executive of the trust?",{"$nulls":6},"Q6 guidance",null,"Yes"]
[null,null,7,"How many times has the board met in the last year?",{"$nulls":6},"Q7 guidance",null,3,{"$nulls":3},"Plus regular Reports through lockdown periods."]
[null,null,"7A","If less than 6 times, has the board explained in the governance statement how it has maintained effective oversight?\n(Not applicable answer available)",{"$nulls":6},"Q7A guidance",null,"Yes"]
[null,null,8,"Has the trust held an Annual General Meeting (AGM) with members in the last 12 months?",{"$nulls":6},"Q8 guidance",null,"Yes"]
[null,null,"8A","(If answering \"no\") Please provide details of any alternative arrangements for communicating with members.",{"$nulls":6},"Q8 guidance"]
[null,null,"8B","(If answering \"yes\") What percentage of members attended the AGM?",{"$nulls":6},"Q8 guidance",null,100]
[null,null,9,"Has the board approved a written scheme of financial delegations?",{"$nulls":6},"Q9 guidance",null,"Yes"]
[null,null,10,"Does the trust have a finance committee (or equivalent) with clear terms of reference and a knowledgeable and experienced chair?",{"$nulls":6},"Q10 guidance",null,"Yes"]
[null,null,11,"Does the trust have an audit and risk committee?",{"$nulls":6},"Q11 guidance",null,"Yes"]
[null,null,"11A","Does the audit and risk committee reflect minimum good practice by precluding employees from its membership?",{"$nulls":6},"Q11 guidance",null,"Yes"]
[null,null,"11B","How many times has the audit and risk committee met in the last 12 months?",{"$nulls":6},"Q11 guidance",null,4]
[null,null,12,"Are trustees assured that regular risk assessment process is in place, and that mitigations planned are appropriate/interrogated?",{"$nulls":6},"Q12 guidance",null,"Yes"]
[null,null,13,"Does the academy trust operate in accordance with all of the requirements in the Academies Financial Handbook to identify and avoid conflicts of interest, and to report and manage and related party transactions?",{"$nulls":6},"Q13 guidance",null,"Yes"]
[null,null,14,"Has the trust published its governance arrangements on its website in accordance with the Academies Financial Handbook?",{"$nulls":6},"Q14 guidance",null,"Yes"]
[{"$nulls":12},""]
[null,null,"B. Trust financial strategy"]
[]
[null,null,15,"Has the board of trustees carried out a going concern assessment of the trust to inform the basis of the preparation for financial statements?",{"$nulls":6},"Q15 guidance",null,"Yes"]
[null,null,"15A","(If \"yes\") Can the board clearly evidence the information and data used to inform this assessment and the assumptions made?",{"$nulls":6},"Q15A guidance",null,"Yes",{"$nulls":3},"MWS Financial Statements and Audit Reports"]
[null,null,16,"Can the trust evidence that its 3-year financial forecast has been reviewed by the trustees before approval?",{"$nulls":6},"Q16 guidance",null,"Yes"]
[null,null,17,"Can the trust evidence that trustees have taken financial performance in previous years into account (for example, adjustments for areas of significant underspend or overspend)?",{"$nulls":6},"Q17 guidance",null,"Yes"]
[null,null,18,"Are the assumptions behind the 3-year forecast, including pupil number projections, documented?",{"$nulls":6},"Q18 guidance",null,"Yes"]
[null,null,19,"If a cumulative deficit has been forecast within the 3-year budget, is there a plan to mitigate it?\n(Not applicable answer available)",{"$nulls":6},"Q19 guidance",null,"Not applicable"]
[null,null,20,"Is the financial strategy integrated with the trust's strategy for raising standards and attainment?",{"$nulls":6},"Q20 guidance",null,"Yes"]
[null,null,21,"Does the trust survey its physical estate and ensure appropriate capital provision in budget setting?",{"$nulls":6},"Q21 guidance",null,"Yes",{"$nulls":3},"Yes but there is greater expenditure needed than funds available. We work hard on Cif and other grants to help with this."]
[null,null,"21A","Are trustees aware of their duties under health and safety legislation?",{"$nulls":6},"Q21A guidance",null,"Yes"]
[null,null,22,"Does the school have an appropriate business continuity or disaster recovery plan, including an up-to-date asset register and adequate insurance?",{"$nulls":6},"Q22 guidance",null,"Yes"]
[{"$nulls":12},""]
[null,null,"C. Setting the annual budget"]
[]
[null,null,23,"Does the trust set a well-informed and balanced budget which is approved, in advance, by the board?",{"$nulls":6},"Q23 guidance",null,"Yes"]
[null,null,24,"Does the budget setting process allow sufficient time for the trust board to scrutinise and challenge the information provided?",{"$nulls":6},"Q24 guidance",null,"Yes"]
[null,null,25,"Do trustees challenge pupil number assumptions and can the trust move quickly to recast the budget if the projections and reality are materially different?",{"$nulls":6},"Q25 guidance",null,"Yes"]
[null,null,26,"Is end year outturn in line with budget projections, or if not, is the trust board alerted to significant variations in a timely manner, and do they result from planned changes or from genuinely unforeseeable circumstances?",{"$nulls":6},"Q26 guidance",null,"Yes",{"$nulls":3},"Virements"]
[null,null,27,"Are balances at a reasonable level and does the trust have a clear plan for using the money it plans to hold in balance at the end of each year?",{"$nulls":6},"Q27 guidance",null,"Yes",{"$nulls":3},"Very tight balance this year due to lost income and cost of responding to Covid. Next year onwards is well planned and shows healthy expected balances."]
[{"$nulls":12},""]
[null,null,"D. Staffing"]
[]
[null,null,28,"Does the trust review and challenge its staffing structure regularly to ensure it is the best structure to meet the needs of the trust whilst maintaining financial integrity? ",{"$nulls":6},"Q28 guidance",null,"Yes"]
[null,null,29,"Is the pay of senior leaders tightly correlated to strong educational outcomes and sound financial management?",{"$nulls":6},"Q29 guidance",null,"Yes"]
[null,null,30,"Does the trust benchmark the size of its senior leadership team annually against that of similar schools?",{"$nulls":6},"Q30 guidance",null,"Yes",{"$nulls":3},"Benchmarking card and SRM Self-Assessment Return"]
[null,null,31,"Has the academy trust published on its website the number of employees whose total benefits exceeded £100k?",{"$nulls":6},"Q31 guidance",null,"Yes"]
[{"$nulls":12},""]
[null,null,"E. Value for money"]
[]
[null,null,32,"Does the trust benchmark its income and expenditure and that of its schools annually against that of similar trusts and schools and investigate further where any category appears to be out of line?",{"$nulls":6},"Q32 guidance",null,"Yes"]
[null,null,33,"Does the trust have procedures for purchasing goods and services that both meet legal requirements and secure value for money?",{"$nulls":6},"Q33 guidance",null,"Yes"]
[null,null,34,"Are the trustees given the opportunity to challenge their staff’s  plans for replacing contracts for goods and services that are due to expire shortly?",{"$nulls":6},"Q34 guidance",null,"In part",{"$nulls":3},"On major contracts going to tender, trustees are involved directly in the process. Other contacts over a set value are recorded and monitored on a contacts tracker which is reviewed annually by Resources Committee. "]
[null,null,35,"Does the trust consider collaboration with others, for example on sharing staff or joint purchasing, where that would improve value for money?",{"$nulls":6},"Q35 guidance",null,"In part",{"$nulls":3},"This is considered and has been useful with purchases and contatracts in the past."]
[null,null,36,"Does the trust compare its non-staff expenditure against the DfE recommended national deals to ensure you are achieving best value for money?",{"$nulls":6},"Q36 guidance",null,"In part",{"$nulls":3},"Consortiums and DFE deals are considered alongside our won robust procurement procedures to achieve best value for money."]
[{"$nulls":12},""]
[null,null,"F. Protecting public money "]
[]
[null,null,37,"Are the trustees sure that there are no outstanding matters from audit reports?",{"$nulls":6},"Q37 guidance",null,"Yes"]
[null,null,38,"Are the internal scrutiny arrangements, as defined in the Academies Financial Handbook, adhered to?",{"$nulls":6},"Q38 guidance",null,"Yes"]
[null,null,39,"Does the trust regularly review its internal control arrangements to safeguard against fraud and theft, by staff, contractors, suppliers and other third parties?",{"$nulls":6},"Q39 guidance",null,"Yes"]
[null,null,40,"Are all staff aware of the trust’s whistleblowing arrangements and to whom they should report concerns?",{"$nulls":6},"Q40 guidance",null,"Yes"]
[null,null,41,"Does the trust have an accounting system that is adequate and properly run and delivers accurate reports, including the required returns to ESFA?",{"$nulls":6},"Q41 guidance",null,"Yes",{"$nulls":3},"FMS is due to be replaced as much better options are now available."]
[{"$nulls":12},""]
[null,null,"G. Self-assessment dashboard"]
[]
[null,null,42,"Have the results of the self-assessment dashboard been carefully considered and potential follow-up actions identified?",{"$nulls":6},"Q42 guidance",null,"Yes"]

{"sheet":"Dashboard","index":3,"n_rows":76,"n_cols":14,"rows_kept":76,"hidden":true,"merged":[[2,2,2,3],[4,2,8,3],[5,5,8,5],[10,2,10,3],[12,2,17,3],[12,5,12,6],[12,11,12,12],[13,5,13,6],[13,11,13,12],[14,5,14,6],[14,11,14,12],[15,5,15,6],[15,11,15,12],[16,5,16,6],[16,11,16,12],[18,2,19,3],[18,5,18,7],[18,11,18,13],[19,5,19,7],[19,11,19,13],[20,2,20,3],[20,5,21,7],[20,11,21,13],[21,2,22,2],[23,2,25,3],[24,5,24,7],[24,11,24,13],[26,5,28,7],[26,11,28,13],[28,2,31,3],[29,5,30,7],[29,11,30,13],[31,5,31,7],[31,11,31,13],[33,5,33,7],[33,11,33,13],[36,5,37,5],[36,7,37,7],[36,11,37,11],[36,13,37,13],[38,2,38,3],[50,2,50,3],[55,2,55,3],[65,2,65,3],[73,2,73,3],[75,2,81,3],[75,5,81,7],[75,11,81,13]]}
[]
[]
[null,null,"School resource management self-assessment dashboard"]
[]
[null,null,"Effective resource management is about how a trust uses its resources to drive outcomes for its pupils. A trust can improve outcomes by using its resources more effectively.\n \nThe dashboard below is designed to help trusts identify areas for improved resource management. It shows how a school compares to thresholds on a range of key indicators. ",null,null,"Please enter your number of schools:"]
[{"$nulls":5},1]
[]
[]
[]
[]
[null,null,"A. Information about your school(s)"]
["*",{"$nulls":4},1,{"$nulls":5},1]
[null,null,"\nUsing the dashboard\n\nThis dashboard has been populated with your 2019/20 accounts return, November 2019 school workforce census, 2019 performance tables, 2020 school census, and latest Ofsted rating. For MATs, any central trust spending recorded in your accounts return is disaggregated to the academies in the trust on a per-pupil basis. \n\n*Updated '% of pupils eligible for FSM' data on 22/02/21 \n\n\n",null,null,"School name:",null,"Shenfield High School",{"$nulls":3},"School name:"]
[{"$nulls":5},"Phase:",null,"Secondary with sixth form",{"$nulls":3},"Phase:"]
[{"$nulls":5},"Region:",null,"East of England",{"$nulls":3},"Region:"]
[{"$nulls":5},"Number of pupils:",null,1343,{"$nulls":3},"Number of pupils:"]
[{"$nulls":5},"% of pupils eligible for FSM:",null,{"v":0.059000000000000004,"d":"5.9%"},{"$nulls":3},"% of pupils eligible for FSM:"]
[]
[null,null,"The dashboard is completed at school level. It is not applicable for sixth form colleges. \n",null,null,"This school is being compared to other:",{"$nulls":5},"This school is being compared to other:"]
[{"$nulls":5},"- a medium secondary with sixth form with low levels of FSM",{"$nulls":5},{"$f":"IF(OR(N$14=\"\",N$15=\"\",N$16=\"\",N$17=\"\"),\"\",\n\"- \"&RAG_Calculation!$H30&\nIF(N14=\"Primary\",\" primary schools with \",IF(N14=\"Secondary with sixth form\",\" secondary schools with a sixth form with \",IF(N14=\"Secondary without sixth form\",\" secondary schools without a sixth form with \",IF(N14=\"Special\",\"special schools\",IF(N14=\"Alternative provision\",\"alternative provision schools\",IF(N14=\"All-through\",\"all-through schools\",IF(N14=\"Nursery\",\"nursery schools\",\"\")))))))&RAG_Calculation!$I30)","v":""}]
[null,null,"To update the number of academies shown in the dashboard, change cell F6. Increasing the number will add additional input columns, decreasing the number will remove input columns. You must enter a number above 0.",null,null,"- a secondary school with a sixth form outside London(for average teacher cost only)",{"$nulls":5},{"$f":"IF(OR(N$14=\"\",N$15=\"\",N$16=\"\",N$17=\"\"),\"\",\nIF(N14=\"Primary\",\"- primary schools \",IF(N14=\"Secondary with sixth form\",\"- secondary schools with a sixth form \",IF(N14=\"Secondary without sixth form\",\"- secondary schools without a sixth form \",IF(N14=\"Special\",\"- special schools \",IF(N14=\"Alternative provision\",\"- alternative provision schools \",IF(N14=\"All-through\",\"- all-through schools \",IF(N14=\"Nursery\",\"- nursery schools \",\"\")))))))&RAG_Calculation!$G30&\" (for average teacher cost only)\")","v":""}]
[null,null,"Complete all highlighted cells."]
[]
[null,null,"Guidance on the calculation of the metrics in the tool can be found here. Clicking on the link next to individual indicators below will also take you to the relevant section of the guidance."]
[{"$nulls":5},"Click here to see the RAG rating data for this school",{"$nulls":5},"Click here to see the RAG rating data for this school"]
[]
[null,null,"Macros must be enabled for this workbook to function as anticipated.",null,null,"Click here to input raw spending and characteristics data for this school",{"$nulls":5},"Click here to input raw spending and characteristics data for this school"]
[]
[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\nwith the results."]
[{"$nulls":5},"Calculated figures entered directly below will not be saved and will be re-calculated using data in the 'input raw data' tab when the workbook opens.",{"$nulls":5},"Calculated figures entered directly below will not be saved and will be re-calculated using data in the 'input raw data' tab when the workbook opens."]
[]
[]
[]
[]
[]
[]
[{"$nulls":5},"The school's\ndata",null,"Rating against\nthresholds",{"$nulls":3},"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","Guidance",null,{"v":0.5941734417344173,"d":"59.4%"},null,"Broadly in line with similar schools"]
[null,null,"Spend on supply staff as a percentage of total expenditure","Guidance",null,{"v":4.7425474254742545E-3,"d":"0.5%"},null,"Broadly in line with similar schools"]
[null,null,"Spend on education support staff as a percentage of total expenditure","Guidance",null,{"v":0.12127371273712736,"d":"12.1%"},null,"Highest 10% of similar schools"]
[null,null,"Spend on administrative and clerical staff as a percentage of total expenditure","Guidance",null,{"v":0.08279132791327913,"d":"8.3%"},null,"Broadly in line with similar schools"]
[null,null,"Spend on other staff costs as a percentage of total expenditure","Guidance",null,{"v":3.2520325203252032E-3,"d":"0.3%"},null,"Broadly in line with similar schools"]
[null,null,"Spend on premises (including staff costs) as a percentage of total expenditure","Guidance",null,{"v":0.06260162601626017,"d":"6.3%"},null,"Broadly in line with similar schools"]
[null,null,"Spend on teaching resources as a percentage of total expenditure","Guidance",null,{"v":0.0470189701897019,"d":"4.7%"},null,"Lowest 10% of similar schools"]
[null,null,"Spend on energy as a percentage of total expenditure","Guidance",null,{"v":0.022764227642276424,"d":"2.3%"},null,"Highest 10% of similar schools"]
[null,null,"Other spending as a percentage of total expenditure (balancing line)","Guidance",null,{"v":0.06138211382113821,"d":"6.1%"},null,"N/A"]
[{"$nulls":5},{"$f":"IF(OR(ROUND(SUM(F41:F49),3)=100%,SUM(F41:F49)=0),\"\",\"Section must sum to 100%\")","v":""},{"$nulls":5},{"$f":"IF(OR(ROUND(SUM(L41:L49),3)=100%,SUM(L41:L49)=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","Guidance",null,{"v":-0.018633540372670808,"d":"-1.9%"},null,"Medium risk"]
[null,null,"Revenue reserve as a percentage of total income","Guidance",null,{"v":0.034782608695652174,"d":"3.5%"},null,"Low risk",{"$nulls":5},{"$f":"IF(OR(N$14=\"\",N$15=\"\",N$16=\"\",N$17=\"\",L54=\"\"),\"\",\nIF(L54<=-0.05,High,\nIF(AND(L54>-0.05,L54<0),Medium,\nIF(L54>=0,Low,\"\"))))","v":""}]
[]
[null,null,"D. School characteristics"]
[]
[null,null,"Average teacher cost (£)","Guidance",null,{"v":62357.79294653016,"d":"£62,358"},null,"Highest 10% of similar schools"]
[null,null,"Senior leaders as a percentage of workforce","Guidance",null,{"v":0.08647526807333103,"d":"8.6%"},null,"Highest 20% of similar schools"]
[null,null,"Pupil to teacher ratio","Guidance",null,{"v":19.09840728100114,"d":"19.1"},null,"Highest 20% of similar schools"]
[null,null,"Pupil to adult ratio","Guidance",null,{"v":11.613628502248357,"d":"11.6"},null,"Broadly in line with similar schools"]
[null,null,"Teacher contact ratio (less than 1.0)","Guidance",{"$nulls":9},{"$f":"IF(OR(N$14=\"\",N$15=\"\",N$16=\"\",N$17=\"\",L62=\"\"),\"\",\nIF(L62<=0.7,MuchLower,\nIF(AND(L62>0.7,L62<=0.74),Lower,\nIF(AND(L62>0.74,L62<=0.8),Inline2,\nIF(AND(L62>0.8,L62<=0.82),Higher,\nIF(L62>0.82,Muchhigher,\"\"))))))","v":""}]
[null,null,"Predicted percentage pupil number change in 3-5 years","Guidance",null,{"v":0.055,"d":"5.5%"},null,"Low risk",{"$nulls":5},{"$f":"IF(OR(N$14=\"\",N$15=\"\",N$16=\"\",N$17=\"\",L63=\"\"),\"\",\nIF(L63<=-0.1,High,\nIF(AND(L63>-0.1,L63<=-0.02),Medium,\nIF(L63>=-0.02,Low,\"\"))))","v":""}]
[null,null,"Average class size","Guidance",null,21.5,null,"Middle 20% of similar schools"]
[]
[null,null,"E. Outcomes"]
[]
[null,null,"Ofsted rating","Guidance",null,"Good",null,{"$f":"IF(OR(H$14=\"\",H$15=\"\",H$16=\"\",H$17=\"\",F68=\"\"),\"\",INDIRECT(F68))","v":"Good"},{"$nulls":5},{"$f":"IF(OR(N$14=\"\",N$15=\"\",N$16=\"\",N$17=\"\",L68=\"\"),\"\",INDIRECT(L68))","v":""}]
[null,null,"Progress 8 score","Guidance",null,{"v":-0.22,"d":"-0.2"},null,{"$f":"IF(OR(H$14=\"\",H$15=\"\",H$16=\"\",H$17=\"\",F69=\"\"),\"\",\nIF(F69>=0.5,Wellabove,\nIF(AND(F69>=0,F69<0.5),Average,\nIF(AND(F69>-0.5,F69<0),Below,\nIF(F69<=-0.5,Wellbelow,\"\")))))","v":"Below average"},{"$nulls":5},{"$f":"IF(OR(N$14=\"\",N$15=\"\",N$16=\"\",N$17=\"\",L69=\"\"),\"\",\nIF(L69>=0.5,Wellabove,\nIF(AND(L69>=0,L69<0.5),Average,\nIF(AND(L69>-0.5,L69<0),Below,\nIF(L69<=-0.5,Wellbelow,\"\")))))","v":""}]
[null,null,"Progress score in reading","Guidance",{"$nulls":3},{"$f":"IF(OR(H$14=\"\",H$15=\"\",H$16=\"\",H$17=\"\",F70=\"\"),\"\",\nIF(F70>=3.2,Wellabove,\nIF(AND(F70>=0,F70<3.2),Average,\nIF(AND(F70>-2.7,F70<0),Below,\nIF(F70<=-2.7,Wellbelow,\"\")))))","v":""},{"$nulls":5},{"$f":"IF(OR(N$14=\"\",N$15=\"\",N$16=\"\",N$17=\"\",L70=\"\"),\"\",\nIF(L70>=3.2,Wellabove,\nIF(AND(L70>=0,L70<3.2),Average,\nIF(AND(L70>-2.7,L70<0),Below,\nIF(L70<=-2.7,Wellbelow,\"\")))))","v":""}]
[null,null,"Progress score in writing","Guidance",{"$nulls":3},{"$f":"IF(OR(H$14=\"\",H$15=\"\",H$16=\"\",H$17=\"\",F71=\"\"),\"\",\nIF(F71>=2.7,Wellabove,\nIF(AND(F71>=0,F71<2.7),Average,\nIF(AND(F71>-2.6,F71<0),Below,\nIF(F71<=-2.6,Wellbelow,\"\")))))","v":""},{"$nulls":5},{"$f":"IF(OR(N$14=\"\",N$15=\"\",N$16=\"\",N$17=\"\",L71=\"\"),\"\",\nIF(L71>=2.7,Wellabove,\nIF(AND(L71>=0,L71<2.7),Average,\nIF(AND(L71>-2.6,L71<0),Below,\nIF(L71<=-2.6,Wellbelow,\"\")))))","v":""}]
[null,null,"Progress score in maths","Guidance",{"$nulls":3},{"$f":"IF(OR(H$14=\"\",H$15=\"\",H$16=\"\",H$17=\"\",F72=\"\"),\"\",\nIF(F72>=3.2,Wellabove,\nIF(AND(F72>=0,F72<3.2),Average,\nIF(AND(F72>-3.1,F72<0),Below,\nIF(F72<=-3.1,Wellbelow,\"\")))))","v":""},{"$nulls":5},{"$f":"IF(OR(N$14=\"\",N$15=\"\",N$16=\"\",N$17=\"\",L72=\"\"),\"\",\nIF(L72>=3.2,Wellabove,\nIF(AND(L72>=0,L72<3.2),Average,\nIF(AND(L72>-3.1,L72<0),Below,\nIF(L72<=-3.1,Wellbelow,\"\")))))","v":""}]
[]
[null,null,"F: Optional commentary"]
[]
[null,null,"Teacher contact ratio (less than 1.0) - the data entererd in this column should be 0.75 which is Green- Broadly in line with recommendataions. Every time I enetr the data, it does not save on shutdown for some reason.",null,null,"Green - Broadly in line with recommendations (ASCL 0.78)",{"$nulls":5},"[enter text]"]

{"sheet":"Data_Store","index":4,"n_rows":42,"n_cols":17,"rows_kept":42,"hidden":true}
["School Name","Shenfield High School","Test1",null,"St Matthew's Church of England Primary and Nursery Academy","All Saints Babbacombe CofE Primary School","St Marychurch Church of England Primary and Nursery School","St Rumon's Church of England (VC) Infants School","St Peter's Church of England (VA) Junior School - Tavistock","St Edward's CofE Primary School - Plymouth","Upton St James CofE Primary School","St Leonard's (CofE) Primary School (VC)","All Saints Church of England Primary School - Axminster","Beer Church of England Primary School","Lady Modiford's Church of England Primary School","Meavy Church of England Primary School","Tidcombe Primary School"]
["Full time equivalent number of teachers (classroom and leadership)"]
["Full time equivalent of teachers in the leadership group"]
["Full time equivalent of total school workforce"]
["Total expenditure"]
["Total income"]
["Revenue balances (committed and uncommitted)"]
["Teaching periods in the timetable cycle"]
["Total lessons taught by all teachers in the timetable cycle"]
["Total number of classes"]
["Teaching staff"]
["Supply teaching staff"]
["Education support staff"]
["Administrative and clerical staff"]
["Premises staff"]
["Catering staff"]
["Cost of other staff"]
["Indirect employee expenses"]
["Staff development and training"]
["Supply teacher insurance"]
["Staff-related insurance"]
["Maintenance of premises"]
["Cleaning and caretaking"]
["Water and sewerage"]
["Energy"]
["Rent and rates"]
["Grounds maintenance"]
["Other occupation costs"]
["Special facilities"]
["Teaching resources"]
["ICT teaching resources"]
["Examination fees"]
["Educational consultancy"]
["Agency supply teaching staff"]
["Catering supplies"]
["Auditor costs"]
["Other insurance premiums"]
["Administrative supplies - non educational"]
["Direct revenue financing (revenue contributions to capital)"]
["Professional services - non-curriculum"]
["Interest charges for loan and bank"]
["PFI charges"]

{"sheet":"File_Statistics","index":5,"n_rows":7,"n_cols":10,"rows_kept":7,"hidden":true,"merged":[[2,2,2,3],[2,5,2,6],[2,8,2,9]]}
[]
[]
[null,null,"File statistics",null,null,"VBA key",null,null,"RAG"]
[]
[null,null,"Number of schools",1,null,"Dashboard Column",6,null,"Characteristics",0]
[null,null,"Pre_Populated","N",null,"Optional Column",6]
[{"$nulls":5},"Dashboard Qual",8]

{"sheet":"Optional - input raw data","index":6,"n_rows":88,"n_cols":10,"rows_kept":88,"hidden":true,"merged":[[2,2,2,3],[4,2,15,3],[8,5,9,5],[8,9,9,9],[18,2,18,3],[19,2,19,3],[20,2,20,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[30,2,30,3],[31,2,31,3]]}
[]
[]
[null,null,"Raw data form"]
[{"$nulls":5},1,{"$nulls":3},1]
[null,null,"\nThis 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. The percentages and ratios can also be inputted directly into the dashboard.\n\nSchools 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."]
[]
[]
[{"$nulls":5},"School name:",{"$nulls":3},"School name:"]
[{"$nulls":5},"Shenfield High School"]
{"$rows_empty":9}
[null,null,"Full time equivalent number of teachers (classroom and leadership)",null,null,{"v":70.32,"d":"70.3"}]
[null,null,"Full time equivalent of teachers in the leadership group",null,null,{"v":10,"d":"10.0"}]
[null,null,"Full time equivalent of total school workforce",null,null,{"v":115.64,"d":"115.6"}]
[]
[null,null,"Total expenditure",null,null,{"v":7380000,"d":"£7,380,000"}]
[null,null,"Total income",null,null,{"v":7245000,"d":"£7,245,000"}]
[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":3},{"$f":"IFERROR(IF((F29/(F28*F19))<0.5,\"Resulting teacher contact ratio is low. Total lessons taught may be incorrectly calculated as too low\",IF((F29/(F28*F19))>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,"E1","Teaching staff",null,{"v":4385000,"d":"£4,385,000"}]
[null,null,"E2","Supply teaching staff",null,{"v":0,"d":"£0"}]
[null,null,"E3","Education support staff",null,{"v":895000,"d":"£895,000"}]
[null,null,"E4","Administrative and clerical staff",null,{"v":611000,"d":"£611,000"}]
[null,null,"E5","Premises staff",null,{"v":169000,"d":"£169,000"}]
[null,null,"E6","Catering staff",null,{"v":0,"d":"£0"}]
[null,null,"E7","Cost of other staff",null,{"v":4000,"d":"£4,000"}]
[null,null,"E8","Indirect employee expenses",null,{"v":0,"d":"£0"}]
[null,null,"E9","Staff development and training",null,{"v":20000,"d":"£20,000"}]
[null,null,"E10","Supply teacher insurance",null,{"v":0,"d":"£0"}]
[null,null,"E11","Staff-related insurance",null,{"v":0,"d":"£0"}]
[null,null,"E13","Maintenance of premises",null,{"v":81000,"d":"£81,000"}]
[null,null,"E14","Cleaning and caretaking",null,{"v":177000,"d":"£177,000"}]
[null,null,"E15","Water and sewerage",null,{"v":26000,"d":"£26,000"}]
[null,null,"E16","Energy",null,{"v":168000,"d":"£168,000"}]
[null,null,"E17","Rent and rates",null,{"v":34000,"d":"£34,000"}]
[null,null,"E18","Grounds maintenance",null,{"v":35000,"d":"£35,000"}]
[null,null,"E19","Other occupation costs",null,{"v":3000,"d":"£3,000"}]
[null,null,"E21","Special facilities",null,{"v":0,"d":"£0"}]
[null,null,"E22","Teaching resources",null,{"v":222000,"d":"£222,000"}]
[null,null,"E23","ICT teaching resources",null,{"v":21000,"d":"£21,000"}]
[null,null,"E24","Examination fees",null,{"v":104000,"d":"£104,000"}]
[null,null,"E25","Educational consultancy",null,{"v":46000,"d":"£46,000"}]
[null,null,"E26","Agency supply teaching staff",null,{"v":35000,"d":"£35,000"}]
[null,null,"E28","Catering supplies",null,{"v":44000,"d":"£44,000"}]
[null,null,"E29","Auditor costs",null,{"v":10000,"d":"£10,000"}]
[null,null,"E30","Other insurance premiums",null,{"v":33000,"d":"£33,000"}]
[null,null,"E31","Administrative supplies - non educational",null,{"v":126000,"d":"£126,000"}]
[null,null,"E32","Direct revenue financing (revenue contributions to capital)",null,{"v":35000,"d":"£35,000"}]
[null,null,"E33","Professional services - non-curriculum",null,{"v":96000,"d":"£96,000"}]
[null,null,"E35","Interest charges for loan and bank",null,{"v":0,"d":"£0"}]
[null,null,"E36","PFI charges",null,{"v":0,"d":"£0"}]
{"$rows_empty":21}
[{"$nulls":5},"N",{"$nulls":3},"N"]
[{"$nulls":5},"N",{"$nulls":3},"N"]

{"sheet":"RAG rating data for your school","index":7,"n_rows":97,"n_cols":20,"rows_kept":97,"hidden":true,"merged":[[1,7,8,19],[16,3,16,4],[16,6,16,9],[16,11,16,14],[16,16,16,19],[18,1,19,1],[21,1,22,1],[24,1,25,1],[27,1,28,1],[30,1,31,1],[33,1,34,1],[36,1,37,1],[39,1,40,1],[45,3,45,4],[45,6,45,9],[45,11,45,14],[45,16,45,19],[47,1,48,1],[50,1,51,1],[56,3,56,4],[56,6,56,9],[56,11,56,14],[56,16,56,19],[58,1,59,1],[61,1,62,1],[64,1,65,1],[67,1,68,1],[70,1,71,1],[73,1,74,1],[76,1,77,1],[82,3,82,4],[82,6,82,9],[82,11,82,14],[82,16,82,19],[84,1,85,1],[87,1,88,1],[90,1,91,1],[93,1,94,1],[96,1,97,1]]}
[]
[null,"Select which school to show the RAG ratings for:",{"$nulls":5},"The RAG ratings have been calculated using maintained school and academy 2018-19 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\nThe exception is teacher costs, which do change year on year. To reflect the September 2019 pay award and September 2020 pension contributions changes, the underlying data has been uplifted by 8.6% so the RAG ratings for spend on teaching staff as a percentage of total expenditure and average teacher cost ensure your 2019/20 data is compared on a like for like basis."]
[]
[]
[]
[null,"Your school has been identified as:"]
[null,{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",\"- \"&IF(LOWER(RAG_Calculation!C30) = \"primary\", \"a primary school\", IF(LOWER(RAG_Calculation!C30) = \"secondary with sixth form\",\"a secondary school with a sixth form\", IF(LOWER(RAG_Calculation!C30)= \"secondary without sixth form\", \"a secondary school without a sixth form\",IF(LOWER(RAG_Calculation!C30)= \"all-through\", \"an all-through school\", IF(LOWER(RAG_Calculation!C30)=\"special\",\"a special school\", IF(LOWER(RAG_Calculation!C30) = \"alternative provision\",\"an alternative provision school\", IF(LOWER(RAG_Calculation!C30)=\"nursery\", \"a nursery school\",\"undefined school phase\"))))))))","v":""}]
[null,{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",\"- \"&RAG_Calculation!G30)","v":""}]
[null,{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",\nIF(RAG_Calculation!Q30=1,\"\",\n\"- a \"&RAG_Calculation!H30&\" school because it has \"&RAG_Calculation!K30))","v":""}]
[null,{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",\nIF(RAG_Calculation!Q30=1,\"\",\n\"- a school with \"&RAG_Calculation!I30&\" because \"&RAG_Calculation!L30&\" are eligible\"))","v":""}]
[]
[]
[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(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!C9)","v":""},null,"Between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!C9)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!D9)","v":""},null,"Between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!D9)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!E9)","v":""},null,"Between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!E9)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!G9)","v":""}]
[{"$nulls":3},"Or more than ",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!I9)","v":""},null,"Or between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!H9)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!I9)","v":""},null,"Or between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!G9)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!H9)","v":""}]
[]
[null,"Spend on supply staff as a percentage of total expenditure",null,"More than",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!I10)","v":""},null,"Between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!H10)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!I10)","v":""},null,"Between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!G10)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!H10)","v":""},null,"Between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!E10)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!G10)","v":""}]
[{"$nulls":11},"Or less than or equal to",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!E10)","v":""}]
[]
[null,"Spend on education support staff as a percentage of total expenditure",null,"More than",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!I11)","v":""},null,"Between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!H11)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!I11)","v":""},null,"Between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!G11)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!H11)","v":""},null,"Between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!E11)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!G11)","v":""}]
[{"$nulls":11},"Or less than or equal to",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!E11)","v":""}]
[]
[null,"Spend on administrative and clerical staff as a percentage of total expenditure",null,"More than",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!I12)","v":""},null,"Between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!H12)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!I12)","v":""},null,"Less than or equal to",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!H12)","v":""}]
[]
[]
[null,"Spend on other staff costs as a percentage of total expenditure",null,"More than",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!I13)","v":""},null,"Between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!H13)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!I13)","v":""},null,"Less than or equal to",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!H13)","v":""}]
[]
[]
[null,"Spend on premises (including staff costs) as a percentage of total expenditure",null,"More than",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!I14)","v":""},null,"Between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!H14)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!I14)","v":""},null,"Less than or equal to",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!H14)","v":""}]
[]
[]
[null,"Spend on teaching resources as a percentage of total expenditure",null,"Less than or equal to",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!C15)","v":""},null,"Between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!C15)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!D15)","v":""},null,"Between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!D15)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!E15)","v":""},null,"Between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!E15)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!G15)","v":""}]
[{"$nulls":11},"Or more than",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!G15)","v":""}]
[]
[null,"Spend on energy as a percentage of total expenditure",null,"More than",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!I16)","v":""},null,"Between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!H16)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!I16)","v":""},null,"Less than or equal to",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!H16)","v":""}]
[]
[]
[]
[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(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",-0.05)","v":""},null,"Between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",-0.05)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",0)","v":""},null,"More than or equal to",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",0)","v":""}]
[]
[]
[null,"Revenue reserve as a percentage of total income",null,"Less than or equal to",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",-0.05)","v":""},null,"Between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",-0.05)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",0)","v":""},null,"More than or equal to",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",0)","v":""}]
[]
[]
[]
[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(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!C21)","v":""},null,"Between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!C21)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!D21)","v":""},null,"Between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!D21)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!E21)","v":""},null,"Between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!E21)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!G21)","v":""}]
[{"$nulls":3},"Or more than ",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!I21)","v":""},null,"Or between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!H21)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!I21)","v":""},null,"Or between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!G21)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!H21)","v":""}]
[]
[null,"Senior leaders as a percentage of workforce",null,"More than",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!I17)","v":""},null,"Between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!H17)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!I17)","v":""},null,"Between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!G17)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!H17)","v":""},null,"Between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!E17)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!G17)","v":""}]
[{"$nulls":11},"Or less than or equal to",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!E17)","v":""}]
[]
[null,"Pupil to teacher ratio",null,"Less than or equal to",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!C18)","v":""},null,"Between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!C18)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!D18)","v":""},null,"Between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!D18)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!E18)","v":""},null,"Between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!E18)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!G18)","v":""}]
[{"$nulls":3},"Or more than ",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!I18)","v":""},null,"Or between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!H18)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!I18)","v":""},null,"Or between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!G18)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!H18)","v":""}]
[]
[null,"Pupil to adult ratio",null,"Less than or equal to",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!C19)","v":""},null,"Between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!C19)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!D19)","v":""},null,"Between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!D19)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!E19)","v":""},null,"Between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!E19)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!G19)","v":""}]
[{"$nulls":3},"Or more than ",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!I19)","v":""},null,"Or between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!H19)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!I19)","v":""},null,"Or between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!G19)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!H19)","v":""}]
[]
[null,{"$f":"IF(OR($B$7=\"- an alternative provision school\",$B$7=\"- a special school\",$B$7=\"- a nursery school\"),\"\",\"Teacher contact ratio (less than 1.0)\")","v":"Teacher contact ratio (less than 1.0)"},null,{"$f":"IF(B71=\"\",\"\",\"Less than or equal to\")","v":"Less than or equal to"},{"$f":"IF(OR($B$7=\"- an alternative provision school\",$B$7=\"- a special school\",$B$7=\"- a nursery school\",$B$3=\"\",File_Statistics!$J$5=1),\"\",0.7)","v":""},null,{"$f":"IF(B71=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(OR($B$7=\"- an alternative provision school\",$B$7=\"- a special school\",$B$7=\"- a nursery school\",$B$3=\"\",File_Statistics!$J$5=1),\"\",0.7)","v":""},{"$f":"IF(B71=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(OR($B$7=\"- an alternative provision school\",$B$7=\"- a special school\",$B$7=\"- a nursery school\",$B$3=\"\",File_Statistics!$J$5=1),\"\",0.74)","v":""},null,{"$f":"IF(B71=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(OR($B$7=\"- an alternative provision school\",$B$7=\"- a special school\",$B$7=\"- a nursery school\",$B$3=\"\",File_Statistics!$J$5=1),\"\",0.74)","v":""},{"$f":"IF(G71=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(OR($B$7=\"- an alternative provision school\",$B$7=\"- a special school\",$B$7=\"- a nursery school\",$B$3=\"\",File_Statistics!$J$5=1),\"\",0.8)","v":""}]
[{"$nulls":3},{"$f":"IF(B71=\"\",\"\",\"Or more than\")","v":"Or more than"},{"$f":"IF(OR($B$7=\"- an alternative provision school\",$B$7=\"- a special school\",$B$7=\"- a nursery school\",$B$3=\"\",File_Statistics!$J$5=1),\"\",0.82)","v":""},null,{"$f":"IF(B71=\"\",\"\",\"Or between\")","v":"Or between"},{"$f":"IF(OR($B$7=\"- an alternative provision school\",$B$7=\"- a special school\",$B$7=\"- a nursery school\",$B$3=\"\",File_Statistics!$J$5=1),\"\",0.8)","v":""},{"$f":"IF(B72=\"\",\"\",\"and\")","v":""},{"$f":"IF(OR($B$7=\"- an alternative provision school\",$B$7=\"- a special school\",$B$7=\"- a nursery school\",$B$3=\"\",File_Statistics!$J$5=1),\"\",0.82)","v":""}]
[]
[null,"Predicted percentage pupil number change in 3-5 years",null,"Less than or equal to",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",-0.1)","v":""},null,"Between",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",-0.1)","v":""},"and",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",-0.02)","v":""},null,"More than",{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",-0.02)","v":""}]
[]
[]
[null,{"$f":"IF(OR($B$7=\"- an alternative provision school\",$B$7=\"- a special school\",$B$7=\"- a nursery school\"),\"\",\"Average class size\")","v":"Average class size"},null,{"$f":"IF(B77=\"\",\"\",\"Less than or equal to\")","v":"Less than or equal to"},{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!C20)","v":""},null,{"$f":"IF(B77=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!C20)","v":""},{"$f":"IF(B77=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!D20)","v":""},null,{"$f":"IF(B77=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!D20)","v":""},{"$f":"IF(B77=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!E20)","v":""},null,{"$f":"IF(B77=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!E20)","v":""},{"$f":"IF(B77=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!G20)","v":""}]
[{"$nulls":3},{"$f":"IF(B77=\"\",\"\",\"Or more than\")","v":"Or more than"},{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!I20)","v":""},null,{"$f":"IF(B77=\"\",\"\",\"Or between\")","v":"Or between"},{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!H20)","v":""},{"$f":"IF(B77=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!I20)","v":""},null,{"$f":"IF(B77=\"\",\"\",\"Or between\")","v":"Or between"},{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!G20)","v":""},{"$f":"IF(B77=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(OR($B$3=\"\",File_Statistics!$J$5=1),\"\",RAG_Calculation!H20)","v":""}]
[]
[]
[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($B$3=\"\",\"\",\"Inadequate\")","v":""},null,null,{"$f":"IF($B$3=\"\",\"\",\"Requires Improvement (RI)\")","v":""},{"$nulls":4},{"$f":"IF($B$3=\"\",\"\",\"Good\")","v":""},{"$nulls":4},{"$f":"IF($B$3=\"\",\"\",\"Outstanding\")","v":""}]
[]
[null,{"$f":"IF(OR($B$7=\"- a primary school\",$B$7=\"- a nursery school\"),\"\",\"Progress 8 score\")","v":"Progress 8 score"},null,{"$f":"IF(B88=\"\",\"\",\"Less than or equal to\")","v":"Less than or equal to"},{"$f":"IF(OR($B$3=\"\",B88=\"\",File_Statistics!$J$5=1),\"\",-0.5)","v":""},null,{"$f":"IF(B88=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(OR($B$3=\"\",B88=\"\",File_Statistics!$J$5=1),\"\",-0.5)","v":""},{"$f":"IF(B88=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(OR($B$3=\"\",B88=\"\",File_Statistics!$J$5=1),\"\",0)","v":""},null,{"$f":"IF(B88=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(OR($B$3=\"\",B88=\"\",File_Statistics!$J$5=1),\"\",0)","v":""},{"$f":"IF(B88=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(OR($B$3=\"\",B88=\"\",File_Statistics!$J$5=1),\"\",0.5)","v":""},null,{"$f":"IF(B88=\"\",\"\",\"More than\")","v":"More than"},{"$f":"IF(OR($B$3=\"\",B88=\"\",File_Statistics!$J$5=1),\"\",0.5)","v":""}]
[]
[]
[null,{"$f":"IF(OR($B$7=\"- a secondary school with a sixth form\", $B$7=\"- a secondary school without a sixth form\",$B$7=\"- a nursery school\"),\"\",\"Progress score in reading\")","v":"Progress score in reading"},null,{"$f":"IF(B91=\"\",\"\",\"Less than or equal to\")","v":"Less than or equal to"},{"$f":"IF(OR($B$3=\"\",B91=\"\",File_Statistics!$J$5=1),\"\",-2.7)","v":""},null,{"$f":"IF(B91=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(OR($B$3=\"\",B91=\"\",File_Statistics!$J$5=1),\"\",-2.7)","v":""},{"$f":"IF(B91=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(OR($B$3=\"\",B91=\"\",File_Statistics!$J$5=1),\"\",0)","v":""},null,{"$f":"IF(B91=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(OR($B$3=\"\",B91=\"\",File_Statistics!$J$5=1),\"\",0)","v":""},{"$f":"IF(B91=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(OR($B$3=\"\",B91=\"\",File_Statistics!$J$5=1),\"\",3.2)","v":""},null,{"$f":"IF(B91=\"\",\"\",\"More than\")","v":"More than"},{"$f":"IF(OR($B$3=\"\",B91=\"\",File_Statistics!$J$5=1),\"\",3.2)","v":""}]
[]
[]
[null,{"$f":"IF(OR($B$7=\"- a secondary school with a sixth form\", $B$7=\"- a secondary school without a sixth form\",$B$7=\"- a nursery school\"),\"\",\"Progress score in writing\")","v":"Progress score in writing"},null,{"$f":"IF(B94=\"\",\"\",\"Less than or equal to\")","v":"Less than or equal to"},{"$f":"IF(OR($B$3=\"\",B94=\"\",File_Statistics!$J$5=1),\"\",-2.6)","v":""},null,{"$f":"IF(B94=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(OR($B$3=\"\",B94=\"\",File_Statistics!$J$5=1),\"\",-2.6)","v":""},{"$f":"IF(B94=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(OR($B$3=\"\",B94=\"\",File_Statistics!$J$5=1),\"\",0)","v":""},null,{"$f":"IF(B94=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(OR($B$3=\"\",B94=\"\",File_Statistics!$J$5=1),\"\",0)","v":""},{"$f":"IF(B94=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(OR($B$3=\"\",B94=\"\",File_Statistics!$J$5=1),\"\",2.7)","v":""},null,{"$f":"IF(B94=\"\",\"\",\"More than\")","v":"More than"},{"$f":"IF(OR($B$3=\"\",B94=\"\",File_Statistics!$J$5=1),\"\",2.7)","v":""}]
[]
[]
[null,{"$f":"IF(OR($B$7=\"- a secondary school with a sixth form\", $B$7=\"- a secondary school without a sixth form\",$B$7=\"- a nursery school\"),\"\",\"Progress score in maths\")","v":"Progress score in maths"},null,{"$f":"IF(B97=\"\",\"\",\"Less than or equal to\")","v":"Less than or equal to"},{"$f":"IF(OR($B$3=\"\",B97=\"\",File_Statistics!$J$5=1),\"\",-3.1)","v":""},null,{"$f":"IF(B97=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(OR($B$3=\"\",B97=\"\",File_Statistics!$J$5=1),\"\",-3.1)","v":""},{"$f":"IF(B97=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(OR($B$3=\"\",B97=\"\",File_Statistics!$J$5=1),\"\",0)","v":""},null,{"$f":"IF(B97=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(OR($B$3=\"\",B97=\"\",File_Statistics!$J$5=1),\"\",0)","v":""},{"$f":"IF(B97=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(OR($B$3=\"\",B97=\"\",File_Statistics!$J$5=1),\"\",3.2)","v":""},null,{"$f":"IF(B97=\"\",\"\",\"More than\")","v":"More than"},{"$f":"IF(OR($B$3=\"\",B97=\"\",File_Statistics!$J$5=1),\"\",3.2)","v":""}]

{"sheet":"RAG rating data for all schools","index":8,"n_rows":559,"n_cols":19,"rows_kept":559,"hidden":true,"merged":[[426,3,426,4],[541,3,541,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",{"v":0.397,"d":"39.7%"},{"v":0.429,"d":"42.9%"},{"v":0.465,"d":"46.5%"},{"v":0.48,"d":"48.0%"},{"v":0.497,"d":"49.7%"},{"v":0.528,"d":"52.8%"},{"v":0.552,"d":"55.2%"}]
[null,"Primary","Very small","Low FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.016,"d":"1.6%"},{"v":0.02,"d":"2.0%"},{"v":0.025,"d":"2.5%"},{"v":0.041,"d":"4.1%"},{"v":0.058,"d":"5.8%"}]
[null,"Primary","Very small","Low FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.124,"d":"12.4%"},{"v":0.136,"d":"13.6%"},{"v":0.145,"d":"14.5%"},{"v":0.171,"d":"17.1%"},{"v":0.193,"d":"19.3%"}]
[null,"Primary","Very small","Low FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.019,"d":"1.9%"},null,{"v":0.04,"d":"4.0%"},{"v":0.07,"d":"7.0%"}]
[null,"Primary","Very small","Low FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.031,"d":"3.1%"},null,{"v":0.051000000000000004,"d":"5.1%"},{"v":0.066,"d":"6.6%"}]
[null,"Primary","Very small","Low FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.085,"d":"8.5%"},null,{"v":0.112,"d":"11.2%"},{"v":0.127,"d":"12.7%"}]
[null,"Primary","Very small","Low FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.033,"d":"3.3%"},{"v":0.041,"d":"4.1%"},{"v":0.053,"d":"5.3%"},{"v":0.06,"d":"6.0%"},{"v":0.067,"d":"6.7%"}]
[null,"Primary","Very small","Low FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.014,"d":"1.4%"},null,{"v":0.019,"d":"1.9%"},{"v":0.023,"d":"2.3%"}]
[null,"Primary","Very small","Low FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.111,"d":"11.1%"},{"v":0.122,"d":"12.2%"},{"v":0.139,"d":"13.9%"},{"v":0.179,"d":"17.9%"},{"v":0.20800000000000002,"d":"20.8%"}]
[null,"Primary","Very small","Low FSM","Pupil to teacher ratio",12.4,{"v":14,"d":"14.0"},16.3,17.1,17.8,{"v":20,"d":"20.0"},{"v":22,"d":"22.0"}]
[null,"Primary","Very small","Low FSM","Pupil to adult ratio",5.7,6.7,7.7,8.1,8.6,{"v":9.600000000000001,"d":"9.6"},10.9]
[null,"Primary","Very small","Low FSM","Average class size",{"v":14,"d":"14.0"},16.8,{"v":20,"d":"20.0"},{"v":21,"d":"21.0"},22.3,{"v":24,"d":"24.0"},{"v":25,"d":"25.0"}]
[]
[698,"Primary","Small","Low FSM","PSL"]
[null,"Primary","Small","Low FSM","Spend on teaching staff as a percentage of total expenditure",{"v":0.41600000000000004,"d":"41.6%"},{"v":0.441,"d":"44.1%"},{"v":0.47300000000000003,"d":"47.3%"},{"v":0.485,"d":"48.5%"},{"v":0.496,"d":"49.6%"},{"v":0.528,"d":"52.8%"},{"v":0.549,"d":"54.9%"}]
[null,"Primary","Small","Low FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.017,"d":"1.7%"},{"v":0.021,"d":"2.1%"},{"v":0.025,"d":"2.5%"},{"v":0.037,"d":"3.7%"},{"v":0.049,"d":"4.9%"}]
[null,"Primary","Small","Low FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.137,"d":"13.7%"},{"v":0.147,"d":"14.7%"},{"v":0.156,"d":"15.6%"},{"v":0.182,"d":"18.2%"},{"v":0.203,"d":"20.3%"}]
[null,"Primary","Small","Low FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.022,"d":"2.2%"},null,{"v":0.047,"d":"4.7%"},{"v":0.069,"d":"6.9%"}]
[null,"Primary","Small","Low FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.033,"d":"3.3%"},null,{"v":0.052000000000000005,"d":"5.2%"},{"v":0.064,"d":"6.4%"}]
[null,"Primary","Small","Low FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.077,"d":"7.7%"},null,{"v":0.099,"d":"9.9%"},{"v":0.111,"d":"11.1%"}]
[null,"Primary","Small","Low FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.03,"d":"3.0%"},{"v":0.038,"d":"3.8%"},{"v":0.051000000000000004,"d":"5.1%"},{"v":0.056,"d":"5.6%"},{"v":0.061,"d":"6.1%"}]
[null,"Primary","Small","Low FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.013000000000000001,"d":"1.3%"},null,{"v":0.017,"d":"1.7%"},{"v":0.019,"d":"1.9%"}]
[null,"Primary","Small","Low FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.097,"d":"9.7%"},{"v":0.11,"d":"11.0%"},{"v":0.125,"d":"12.5%"},{"v":0.153,"d":"15.3%"},{"v":0.177,"d":"17.7%"}]
[null,"Primary","Small","Low FSM","Pupil to teacher ratio",{"v":17,"d":"17.0"},{"v":18,"d":"18.0"},19.6,{"v":20.200000000000003,"d":"20.2"},{"v":20.700000000000003,"d":"20.7"},22.5,{"v":23.900000000000002,"d":"23.9"}]
[null,"Primary","Small","Low FSM","Pupil to adult ratio",7.9,8.5,9.3,{"v":9.600000000000001,"d":"9.6"},{"v":10,"d":"10.0"},{"v":11,"d":"11.0"},11.8]
[null,"Primary","Small","Low FSM","Average class size",{"v":21.700000000000003,"d":"21.7"},{"v":23.400000000000002,"d":"23.4"},25.1,25.8,26.3,{"v":28.200000000000003,"d":"28.2"},{"v":29.200000000000003,"d":"29.2"}]
[]
[{"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",{"v":0.419,"d":"41.9%"},{"v":0.443,"d":"44.3%"},{"v":0.47000000000000003,"d":"47.0%"},{"v":0.481,"d":"48.1%"},{"v":0.493,"d":"49.3%"},{"v":0.52,"d":"52.0%"},{"v":0.54,"d":"54.0%"}]
[null,"Primary","Medium","Low FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.016,"d":"1.6%"},{"v":0.02,"d":"2.0%"},{"v":0.023,"d":"2.3%"},{"v":0.036000000000000004,"d":"3.6%"},{"v":0.048,"d":"4.8%"}]
[null,"Primary","Medium","Low FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.146,"d":"14.6%"},{"v":0.156,"d":"15.6%"},{"v":0.166,"d":"16.6%"},{"v":0.19,"d":"19.0%"},{"v":0.213,"d":"21.3%"}]
[null,"Primary","Medium","Low FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.028,"d":"2.8%"},null,{"v":0.056,"d":"5.6%"},{"v":0.076,"d":"7.6%"}]
[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.053,"d":"5.3%"},{"v":0.066,"d":"6.6%"}]
[null,"Primary","Medium","Low FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.07200000000000001,"d":"7.2%"},null,{"v":0.094,"d":"9.4%"},{"v":0.106,"d":"10.6%"}]
[null,"Primary","Medium","Low FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.03,"d":"3.0%"},{"v":0.038,"d":"3.8%"},{"v":0.048,"d":"4.8%"},{"v":0.053,"d":"5.3%"},{"v":0.059000000000000004,"d":"5.9%"}]
[null,"Primary","Medium","Low FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.012,"d":"1.2%"},null,{"v":0.015,"d":"1.5%"},{"v":0.017,"d":"1.7%"}]
[null,"Primary","Medium","Low FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.088,"d":"8.8%"},{"v":0.094,"d":"9.4%"},{"v":0.101,"d":"10.1%"},{"v":0.11800000000000001,"d":"11.8%"},{"v":0.137,"d":"13.7%"}]
[null,"Primary","Medium","Low FSM","Pupil to teacher ratio",19.1,{"v":20.200000000000003,"d":"20.2"},{"v":21.700000000000003,"d":"21.7"},22.3,{"v":23,"d":"23.0"},24.5,{"v":26,"d":"26.0"}]
[null,"Primary","Medium","Low FSM","Pupil to adult ratio",{"v":8.700000000000001,"d":"8.7"},9.3,{"v":10.100000000000001,"d":"10.1"},10.5,10.9,11.8,12.5]
[null,"Primary","Medium","Low FSM","Average class size",25.6,26.8,{"v":28.400000000000002,"d":"28.4"},{"v":29,"d":"29.0"},29.5,{"v":30,"d":"30.0"},30.6]
[]
[650,"Primary","Large","Low FSM","PLL"]
[null,"Primary","Large","Low FSM","Spend on teaching staff as a percentage of total expenditure",{"v":0.434,"d":"43.4%"},{"v":0.453,"d":"45.3%"},{"v":0.48,"d":"48.0%"},{"v":0.491,"d":"49.1%"},{"v":0.502,"d":"50.2%"},{"v":0.525,"d":"52.5%"},{"v":0.545,"d":"54.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.019,"d":"1.9%"},{"v":0.022,"d":"2.2%"},{"v":0.033,"d":"3.3%"},{"v":0.045,"d":"4.5%"}]
[null,"Primary","Large","Low FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.156,"d":"15.6%"},{"v":0.164,"d":"16.4%"},{"v":0.17400000000000002,"d":"17.4%"},{"v":0.197,"d":"19.7%"},{"v":0.215,"d":"21.5%"}]
[null,"Primary","Large","Low FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.03,"d":"3.0%"},null,{"v":0.058,"d":"5.8%"},{"v":0.077,"d":"7.7%"}]
[null,"Primary","Large","Low FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.034,"d":"3.4%"},null,{"v":0.053,"d":"5.3%"},{"v":0.066,"d":"6.6%"}]
[null,"Primary","Large","Low FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.067,"d":"6.7%"},null,{"v":0.088,"d":"8.8%"},{"v":0.10400000000000001,"d":"10.4%"}]
[null,"Primary","Large","Low FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.032,"d":"3.2%"},{"v":0.038,"d":"3.8%"},{"v":0.048,"d":"4.8%"},{"v":0.052000000000000005,"d":"5.2%"},{"v":0.057,"d":"5.7%"}]
[null,"Primary","Large","Low FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.011,"d":"1.1%"},null,{"v":0.014,"d":"1.4%"},{"v":0.016,"d":"1.6%"}]
[null,"Primary","Large","Low FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.061,"d":"6.1%"},{"v":0.067,"d":"6.7%"},{"v":0.073,"d":"7.3%"},{"v":0.08700000000000001,"d":"8.7%"},{"v":0.10300000000000001,"d":"10.3%"}]
[null,"Primary","Large","Low FSM","Pupil to teacher ratio",20.1,{"v":21.200000000000003,"d":"21.2"},{"v":22.700000000000003,"d":"22.7"},23.3,{"v":23.700000000000003,"d":"23.7"},{"v":25.200000000000003,"d":"25.2"},{"v":26.400000000000002,"d":"26.4"}]
[null,"Primary","Large","Low FSM","Pupil to adult ratio",9.3,9.9,{"v":10.700000000000001,"d":"10.7"},{"v":11,"d":"11.0"},11.4,12.3,13.3]
[null,"Primary","Large","Low FSM","Average class size",27.6,{"v":28.400000000000002,"d":"28.4"},{"v":29.400000000000002,"d":"29.4"},29.6,29.8,30.1,30.6]
[]
[880,"Primary","Very small","Medium FSM","PVSM"]
[null,"Primary","Very small","Medium FSM","Spend on teaching staff as a percentage of total expenditure",{"v":0.394,"d":"39.4%"},{"v":0.422,"d":"42.2%"},{"v":0.457,"d":"45.7%"},{"v":0.47300000000000003,"d":"47.3%"},{"v":0.487,"d":"48.7%"},{"v":0.523,"d":"52.3%"},{"v":0.552,"d":"55.2%"}]
[null,"Primary","Very small","Medium FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.016,"d":"1.6%"},{"v":0.021,"d":"2.1%"},{"v":0.026000000000000002,"d":"2.6%"},{"v":0.041,"d":"4.1%"},{"v":0.058,"d":"5.8%"}]
[null,"Primary","Very small","Medium FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.133,"d":"13.3%"},{"v":0.14300000000000002,"d":"14.3%"},{"v":0.153,"d":"15.3%"},{"v":0.179,"d":"17.9%"},{"v":0.198,"d":"19.8%"}]
[null,"Primary","Very small","Medium FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.024,"d":"2.4%"},null,{"v":0.058,"d":"5.8%"},{"v":0.079,"d":"7.9%"}]
[null,"Primary","Very small","Medium FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.033,"d":"3.3%"},null,{"v":0.051000000000000004,"d":"5.1%"},{"v":0.066,"d":"6.6%"}]
[null,"Primary","Very small","Medium FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.081,"d":"8.1%"},null,{"v":0.108,"d":"10.8%"},{"v":0.121,"d":"12.1%"}]
[null,"Primary","Very small","Medium FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.03,"d":"3.0%"},{"v":0.039,"d":"3.9%"},{"v":0.051000000000000004,"d":"5.1%"},{"v":0.056,"d":"5.6%"},{"v":0.063,"d":"6.3%"}]
[null,"Primary","Very small","Medium FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.014,"d":"1.4%"},null,{"v":0.019,"d":"1.9%"},{"v":0.022,"d":"2.2%"}]
[null,"Primary","Very small","Medium FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.105,"d":"10.5%"},{"v":0.11800000000000001,"d":"11.8%"},{"v":0.13,"d":"13.0%"},{"v":0.171,"d":"17.1%"},{"v":0.20400000000000001,"d":"20.4%"}]
[null,"Primary","Very small","Medium FSM","Pupil to teacher ratio",11.8,{"v":13.700000000000001,"d":"13.7"},{"v":15.700000000000001,"d":"15.7"},16.7,17.6,19.8,21.6]
[null,"Primary","Very small","Medium FSM","Pupil to adult ratio",{"v":5.6000000000000005,"d":"5.6"},{"v":6.300000000000001,"d":"6.3"},{"v":7.300000000000001,"d":"7.3"},{"v":7.800000000000001,"d":"7.8"},{"v":8.200000000000001,"d":"8.2"},{"v":9.200000000000001,"d":"9.2"},{"v":10,"d":"10.0"}]
[null,"Primary","Very small","Medium FSM","Average class size",13.5,16.3,{"v":19.900000000000002,"d":"19.9"},{"v":21,"d":"21.0"},{"v":22,"d":"22.0"},{"v":24,"d":"24.0"},25.3]
[]
[994,"Primary","Small","Medium FSM","PSM"]
[null,"Primary","Small","Medium FSM","Spend on teaching staff as a percentage of total expenditure",{"v":0.4,"d":"40.0%"},{"v":0.427,"d":"42.7%"},{"v":0.457,"d":"45.7%"},{"v":0.468,"d":"46.8%"},{"v":0.482,"d":"48.2%"},{"v":0.511,"d":"51.1%"},{"v":0.536,"d":"53.6%"}]
[null,"Primary","Small","Medium FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.017,"d":"1.7%"},{"v":0.022,"d":"2.2%"},{"v":0.027,"d":"2.7%"},{"v":0.041,"d":"4.1%"},{"v":0.053,"d":"5.3%"}]
[null,"Primary","Small","Medium FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.15,"d":"15.0%"},{"v":0.16,"d":"16.0%"},{"v":0.171,"d":"17.1%"},{"v":0.197,"d":"19.7%"},{"v":0.223,"d":"22.3%"}]
[null,"Primary","Small","Medium FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.028,"d":"2.8%"},null,{"v":0.055,"d":"5.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.052000000000000005,"d":"5.2%"},{"v":0.064,"d":"6.4%"}]
[null,"Primary","Small","Medium FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.073,"d":"7.3%"},null,{"v":0.098,"d":"9.8%"},{"v":0.109,"d":"10.9%"}]
[null,"Primary","Small","Medium FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.031,"d":"3.1%"},{"v":0.037,"d":"3.7%"},{"v":0.048,"d":"4.8%"},{"v":0.052000000000000005,"d":"5.2%"},{"v":0.057,"d":"5.7%"}]
[null,"Primary","Small","Medium FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.013000000000000001,"d":"1.3%"},null,{"v":0.017,"d":"1.7%"},{"v":0.019,"d":"1.9%"}]
[null,"Primary","Small","Medium FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.094,"d":"9.4%"},{"v":0.10400000000000001,"d":"10.4%"},{"v":0.117,"d":"11.7%"},{"v":0.145,"d":"14.5%"},{"v":0.167,"d":"16.7%"}]
[null,"Primary","Small","Medium FSM","Pupil to teacher ratio",16.5,17.6,{"v":19.200000000000003,"d":"19.2"},{"v":20.200000000000003,"d":"20.2"},20.8,{"v":22.400000000000002,"d":"22.4"},{"v":24,"d":"24.0"}]
[null,"Primary","Small","Medium FSM","Pupil to adult ratio",{"v":7.1000000000000005,"d":"7.1"},{"v":7.800000000000001,"d":"7.8"},{"v":8.700000000000001,"d":"8.7"},9.1,9.5,10.3,{"v":11.200000000000001,"d":"11.2"}]
[null,"Primary","Small","Medium FSM","Average class size",21.5,22.8,24.8,25.5,26.3,27.8,{"v":28.700000000000003,"d":"28.7"}]
[]
[{"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",{"v":0.405,"d":"40.5%"},{"v":0.428,"d":"42.8%"},{"v":0.458,"d":"45.8%"},{"v":0.47000000000000003,"d":"47.0%"},{"v":0.482,"d":"48.2%"},{"v":0.509,"d":"50.9%"},{"v":0.529,"d":"52.9%"}]
[null,"Primary","Medium","Medium FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.016,"d":"1.6%"},{"v":0.021,"d":"2.1%"},{"v":0.026000000000000002,"d":"2.6%"},{"v":0.039,"d":"3.9%"},{"v":0.053,"d":"5.3%"}]
[null,"Primary","Medium","Medium FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.164,"d":"16.4%"},{"v":0.17400000000000002,"d":"17.4%"},{"v":0.185,"d":"18.5%"},{"v":0.212,"d":"21.2%"},{"v":0.234,"d":"23.4%"}]
[null,"Primary","Medium","Medium FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.031,"d":"3.1%"},null,{"v":0.058,"d":"5.8%"},{"v":0.075,"d":"7.5%"}]
[null,"Primary","Medium","Medium FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.036000000000000004,"d":"3.6%"},null,{"v":0.052000000000000005,"d":"5.2%"},{"v":0.064,"d":"6.4%"}]
[null,"Primary","Medium","Medium FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.07,"d":"7.0%"},null,{"v":0.091,"d":"9.1%"},{"v":0.10300000000000001,"d":"10.3%"}]
[null,"Primary","Medium","Medium FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.028,"d":"2.8%"},{"v":0.035,"d":"3.5%"},{"v":0.044,"d":"4.4%"},{"v":0.049,"d":"4.9%"},{"v":0.054,"d":"5.4%"}]
[null,"Primary","Medium","Medium FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.012,"d":"1.2%"},null,{"v":0.015,"d":"1.5%"},{"v":0.017,"d":"1.7%"}]
[null,"Primary","Medium","Medium FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.079,"d":"7.9%"},{"v":0.08600000000000001,"d":"8.6%"},{"v":0.093,"d":"9.3%"},{"v":0.112,"d":"11.2%"},{"v":0.13,"d":"13.0%"}]
[null,"Primary","Medium","Medium FSM","Pupil to teacher ratio",18.2,{"v":19.400000000000002,"d":"19.4"},{"v":20.900000000000002,"d":"20.9"},21.6,{"v":22.200000000000003,"d":"22.2"},23.8,25.1]
[null,"Primary","Medium","Medium FSM","Pupil to adult ratio",{"v":7.800000000000001,"d":"7.8"},8.4,9.3,{"v":9.600000000000001,"d":"9.6"},{"v":10,"d":"10.0"},{"v":11,"d":"11.0"},{"v":11.700000000000001,"d":"11.7"}]
[null,"Primary","Medium","Medium FSM","Average class size",{"v":24.400000000000002,"d":"24.4"},25.6,{"v":27.200000000000003,"d":"27.2"},{"v":27.900000000000002,"d":"27.9"},28.5,29.6,{"v":30,"d":"30.0"}]
[]
[{"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",{"v":0.404,"d":"40.4%"},{"v":0.429,"d":"42.9%"},{"v":0.461,"d":"46.1%"},{"v":0.47200000000000003,"d":"47.2%"},{"v":0.484,"d":"48.4%"},{"v":0.511,"d":"51.1%"},{"v":0.532,"d":"53.2%"}]
[null,"Primary","Large","Medium FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.015,"d":"1.5%"},{"v":0.019,"d":"1.9%"},{"v":0.025,"d":"2.5%"},{"v":0.039,"d":"3.9%"},{"v":0.053,"d":"5.3%"}]
[null,"Primary","Large","Medium FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.176,"d":"17.6%"},{"v":0.186,"d":"18.6%"},{"v":0.198,"d":"19.8%"},{"v":0.224,"d":"22.4%"},{"v":0.246,"d":"24.6%"}]
[null,"Primary","Large","Medium FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.032,"d":"3.2%"},null,{"v":0.057,"d":"5.7%"},{"v":0.076,"d":"7.6%"}]
[null,"Primary","Large","Medium FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.034,"d":"3.4%"},null,{"v":0.051000000000000004,"d":"5.1%"},{"v":0.063,"d":"6.3%"}]
[null,"Primary","Large","Medium FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.066,"d":"6.6%"},null,{"v":0.085,"d":"8.5%"},{"v":0.099,"d":"9.9%"}]
[null,"Primary","Large","Medium FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.028,"d":"2.8%"},{"v":0.034,"d":"3.4%"},{"v":0.042,"d":"4.2%"},{"v":0.046,"d":"4.6%"},{"v":0.05,"d":"5.0%"}]
[null,"Primary","Large","Medium FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.011,"d":"1.1%"},null,{"v":0.014,"d":"1.4%"},{"v":0.016,"d":"1.6%"}]
[null,"Primary","Large","Medium FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.063,"d":"6.3%"},{"v":0.069,"d":"6.9%"},{"v":0.075,"d":"7.5%"},{"v":0.093,"d":"9.3%"},{"v":0.105,"d":"10.5%"}]
[null,"Primary","Large","Medium FSM","Pupil to teacher ratio",18.8,19.8,21.3,{"v":21.900000000000002,"d":"21.9"},22.5,{"v":23.900000000000002,"d":"23.9"},{"v":25.200000000000003,"d":"25.2"}]
[null,"Primary","Large","Medium FSM","Pupil to adult ratio",{"v":8,"d":"8.0"},{"v":8.700000000000001,"d":"8.7"},9.4,9.8,{"v":10.200000000000001,"d":"10.2"},{"v":11.100000000000001,"d":"11.1"},11.8]
[null,"Primary","Large","Medium FSM","Average class size",26.1,27.1,28.3,28.8,29.1,29.8,30.1]
[]
[214,"Primary","Very small","High FSM","PVSH"]
[null,"Primary","Very small","High FSM","Spend on teaching staff as a percentage of total expenditure",{"v":0.368,"d":"36.8%"},{"v":0.395,"d":"39.5%"},{"v":0.432,"d":"43.2%"},{"v":0.446,"d":"44.6%"},{"v":0.465,"d":"46.5%"},{"v":0.507,"d":"50.7%"},{"v":0.535,"d":"53.5%"}]
[null,"Primary","Very small","High FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.017,"d":"1.7%"},{"v":0.022,"d":"2.2%"},{"v":0.031,"d":"3.1%"},{"v":0.05,"d":"5.0%"},{"v":0.074,"d":"7.4%"}]
[null,"Primary","Very small","High FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.14100000000000001,"d":"14.1%"},{"v":0.153,"d":"15.3%"},{"v":0.167,"d":"16.7%"},{"v":0.195,"d":"19.5%"},{"v":0.225,"d":"22.5%"}]
[null,"Primary","Very small","High FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.029,"d":"2.9%"},null,{"v":0.06,"d":"6.0%"},{"v":0.075,"d":"7.5%"}]
[null,"Primary","Very small","High FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.036000000000000004,"d":"3.6%"},null,{"v":0.057,"d":"5.7%"},{"v":0.077,"d":"7.7%"}]
[null,"Primary","Very small","High FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.075,"d":"7.5%"},null,{"v":0.105,"d":"10.5%"},{"v":0.124,"d":"12.4%"}]
[null,"Primary","Very small","High FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.028,"d":"2.8%"},{"v":0.036000000000000004,"d":"3.6%"},{"v":0.047,"d":"4.7%"},{"v":0.053,"d":"5.3%"},{"v":0.057,"d":"5.7%"}]
[null,"Primary","Very small","High FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.016,"d":"1.6%"},null,{"v":0.021,"d":"2.1%"},{"v":0.024,"d":"2.4%"}]
[null,"Primary","Very small","High FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.106,"d":"10.6%"},{"v":0.12,"d":"12.0%"},{"v":0.136,"d":"13.6%"},{"v":0.17,"d":"17.0%"},{"v":0.2,"d":"20.0%"}]
[null,"Primary","Very small","High FSM","Pupil to teacher ratio",10.3,12.8,14.8,{"v":15.700000000000001,"d":"15.7"},16.7,19.1,21.5]
[null,"Primary","Very small","High FSM","Pupil to adult ratio",4.7,{"v":5.300000000000001,"d":"5.3"},{"v":6.300000000000001,"d":"6.3"},{"v":6.800000000000001,"d":"6.8"},7.2,8.4,9.4]
[null,"Primary","Very small","High FSM","Average class size",12.3,{"v":15,"d":"15.0"},{"v":18,"d":"18.0"},19.3,{"v":21,"d":"21.0"},{"v":24,"d":"24.0"},{"v":25.900000000000002,"d":"25.9"}]
[]
[370,"Primary","Small","High FSM","PSH"]
[null,"Primary","Small","High FSM","Spend on teaching staff as a percentage of total expenditure",{"v":0.383,"d":"38.3%"},{"v":0.41100000000000003,"d":"41.1%"},{"v":0.441,"d":"44.1%"},{"v":0.456,"d":"45.6%"},{"v":0.47300000000000003,"d":"47.3%"},{"v":0.502,"d":"50.2%"},{"v":0.521,"d":"52.1%"}]
[null,"Primary","Small","High FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.019,"d":"1.9%"},{"v":0.025,"d":"2.5%"},{"v":0.031,"d":"3.1%"},{"v":0.049,"d":"4.9%"},{"v":0.063,"d":"6.3%"}]
[null,"Primary","Small","High FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.162,"d":"16.2%"},{"v":0.17300000000000001,"d":"17.3%"},{"v":0.185,"d":"18.5%"},{"v":0.21,"d":"21.0%"},{"v":0.231,"d":"23.1%"}]
[null,"Primary","Small","High FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.035,"d":"3.5%"},null,{"v":0.062,"d":"6.2%"},{"v":0.081,"d":"8.1%"}]
[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.054,"d":"5.4%"},{"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.069,"d":"6.9%"},null,{"v":0.094,"d":"9.4%"},{"v":0.112,"d":"11.2%"}]
[null,"Primary","Small","High FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.026000000000000002,"d":"2.6%"},{"v":0.034,"d":"3.4%"},{"v":0.044,"d":"4.4%"},{"v":0.047,"d":"4.7%"},{"v":0.053,"d":"5.3%"}]
[null,"Primary","Small","High FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.014,"d":"1.4%"},null,{"v":0.018000000000000002,"d":"1.8%"},{"v":0.022,"d":"2.2%"}]
[null,"Primary","Small","High FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.098,"d":"9.8%"},{"v":0.106,"d":"10.6%"},{"v":0.117,"d":"11.7%"},{"v":0.135,"d":"13.5%"},{"v":0.155,"d":"15.5%"}]
[null,"Primary","Small","High FSM","Pupil to teacher ratio",14.4,15.8,{"v":17.400000000000002,"d":"17.4"},{"v":18,"d":"18.0"},18.8,20.6,{"v":21.900000000000002,"d":"21.9"}]
[null,"Primary","Small","High FSM","Pupil to adult ratio",6.2,{"v":6.800000000000001,"d":"6.8"},7.7,7.9,{"v":8.200000000000001,"d":"8.2"},{"v":9.200000000000001,"d":"9.2"},9.8]
[null,"Primary","Small","High FSM","Average class size",{"v":19,"d":"19.0"},{"v":20.400000000000002,"d":"20.4"},{"v":22,"d":"22.0"},{"v":22.900000000000002,"d":"22.9"},23.6,25.3,26.8]
[]
[{"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",{"v":0.377,"d":"37.7%"},{"v":0.402,"d":"40.2%"},{"v":0.432,"d":"43.2%"},{"v":0.443,"d":"44.3%"},{"v":0.455,"d":"45.5%"},{"v":0.486,"d":"48.6%"},{"v":0.507,"d":"50.7%"}]
[null,"Primary","Medium","High FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.016,"d":"1.6%"},{"v":0.021,"d":"2.1%"},{"v":0.027,"d":"2.7%"},{"v":0.043000000000000003,"d":"4.3%"},{"v":0.061,"d":"6.1%"}]
[null,"Primary","Medium","High FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.184,"d":"18.4%"},{"v":0.194,"d":"19.4%"},{"v":0.20600000000000002,"d":"20.6%"},{"v":0.23500000000000001,"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.033,"d":"3.3%"},null,{"v":0.064,"d":"6.4%"},{"v":0.085,"d":"8.5%"}]
[null,"Primary","Medium","High FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.034,"d":"3.4%"},null,{"v":0.052000000000000005,"d":"5.2%"},{"v":0.066,"d":"6.6%"}]
[null,"Primary","Medium","High FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.068,"d":"6.8%"},null,{"v":0.093,"d":"9.3%"},{"v":0.109,"d":"10.9%"}]
[null,"Primary","Medium","High FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.027,"d":"2.7%"},{"v":0.033,"d":"3.3%"},{"v":0.042,"d":"4.2%"},{"v":0.046,"d":"4.6%"},{"v":0.05,"d":"5.0%"}]
[null,"Primary","Medium","High FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.012,"d":"1.2%"},null,{"v":0.016,"d":"1.6%"},{"v":0.018000000000000002,"d":"1.8%"}]
[null,"Primary","Medium","High FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.076,"d":"7.6%"},{"v":0.083,"d":"8.3%"},{"v":0.09,"d":"9.0%"},{"v":0.111,"d":"11.1%"},{"v":0.126,"d":"12.6%"}]
[null,"Primary","Medium","High FSM","Pupil to teacher ratio",16.2,{"v":17.400000000000002,"d":"17.4"},{"v":19,"d":"19.0"},{"v":19.700000000000003,"d":"19.7"},{"v":20.400000000000002,"d":"20.4"},22.3,{"v":23.900000000000002,"d":"23.9"}]
[null,"Primary","Medium","High FSM","Pupil to adult ratio",{"v":6.800000000000001,"d":"6.8"},{"v":7.300000000000001,"d":"7.3"},8.1,8.4,{"v":8.700000000000001,"d":"8.7"},9.5,{"v":10.200000000000001,"d":"10.2"}]
[null,"Primary","Medium","High FSM","Average class size",22.1,23.6,{"v":25.400000000000002,"d":"25.4"},26.1,26.8,28.5,{"v":29.400000000000002,"d":"29.4"}]
[]
[{"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",{"v":0.38,"d":"38.0%"},{"v":0.402,"d":"40.2%"},{"v":0.431,"d":"43.1%"},{"v":0.444,"d":"44.4%"},{"v":0.454,"d":"45.4%"},{"v":0.483,"d":"48.3%"},{"v":0.507,"d":"50.7%"}]
[null,"Primary","Large","High FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.014,"d":"1.4%"},{"v":0.019,"d":"1.9%"},{"v":0.025,"d":"2.5%"},{"v":0.04,"d":"4.0%"},{"v":0.055,"d":"5.5%"}]
[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.21,"d":"21.0%"},{"v":0.22,"d":"22.0%"},{"v":0.25,"d":"25.0%"},{"v":0.272,"d":"27.2%"}]
[null,"Primary","Large","High FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.033,"d":"3.3%"},null,{"v":0.067,"d":"6.7%"},{"v":0.088,"d":"8.8%"}]
[null,"Primary","Large","High FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.034,"d":"3.4%"},null,{"v":0.05,"d":"5.0%"},{"v":0.062,"d":"6.2%"}]
[null,"Primary","Large","High FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.064,"d":"6.4%"},null,{"v":0.089,"d":"8.9%"},{"v":0.106,"d":"10.6%"}]
[null,"Primary","Large","High FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.027,"d":"2.7%"},{"v":0.033,"d":"3.3%"},{"v":0.041,"d":"4.1%"},{"v":0.045,"d":"4.5%"},{"v":0.049,"d":"4.9%"}]
[null,"Primary","Large","High FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.011,"d":"1.1%"},null,{"v":0.014,"d":"1.4%"},{"v":0.016,"d":"1.6%"}]
[null,"Primary","Large","High FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.063,"d":"6.3%"},{"v":0.07,"d":"7.0%"},{"v":0.077,"d":"7.7%"},{"v":0.093,"d":"9.3%"},{"v":0.106,"d":"10.6%"}]
[null,"Primary","Large","High FSM","Pupil to teacher ratio",{"v":17,"d":"17.0"},18.3,19.8,{"v":20.400000000000002,"d":"20.4"},{"v":21.200000000000003,"d":"21.2"},{"v":22.900000000000002,"d":"22.9"},{"v":24.400000000000002,"d":"24.4"}]
[null,"Primary","Large","High FSM","Pupil to adult ratio",{"v":7.1000000000000005,"d":"7.1"},{"v":7.6000000000000005,"d":"7.6"},8.3,8.6,8.9,{"v":9.600000000000001,"d":"9.6"},10.4]
[null,"Primary","Large","High FSM","Average class size",24.5,25.8,27.1,27.6,28.1,{"v":29.200000000000003,"d":"29.2"},{"v":29.700000000000003,"d":"29.7"}]
[]
[]
["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",{"v":0.40800000000000003,"d":"40.8%"},{"v":0.512,"d":"51.2%"},{"v":0.556,"d":"55.6%"},{"v":0.5720000000000001,"d":"57.2%"},{"v":0.588,"d":"58.8%"},{"v":0.612,"d":"61.2%"},{"v":0.648,"d":"64.8%"}]
[null,"Secondary with sixth form","Small","Low FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.003,"d":"0.3%"},{"v":0.008,"d":"0.8%"},{"v":0.013000000000000001,"d":"1.3%"},{"v":0.025,"d":"2.5%"},{"v":0.031,"d":"3.1%"}]
[null,"Secondary with sixth form","Small","Low FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.052000000000000005,"d":"5.2%"},{"v":0.065,"d":"6.5%"},{"v":0.076,"d":"7.6%"},{"v":0.10400000000000001,"d":"10.4%"},{"v":0.127,"d":"12.7%"}]
[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.082,"d":"8.2%"},{"v":0.114,"d":"11.4%"}]
[null,"Secondary with sixth form","Small","Low FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.014,"d":"1.4%"},null,{"v":0.046,"d":"4.6%"},{"v":0.11,"d":"11.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.049,"d":"4.9%"},null,{"v":0.084,"d":"8.4%"},{"v":0.105,"d":"10.5%"}]
[null,"Secondary with sixth form","Small","Low FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.038,"d":"3.8%"},{"v":0.046,"d":"4.6%"},{"v":0.064,"d":"6.4%"},{"v":0.073,"d":"7.3%"},{"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.017,"d":"1.7%"},null,{"v":0.022,"d":"2.2%"},{"v":0.028,"d":"2.8%"}]
[null,"Secondary with sixth form","Small","Low FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.06,"d":"6.0%"},{"v":0.067,"d":"6.7%"},{"v":0.068,"d":"6.8%"},{"v":0.08700000000000001,"d":"8.7%"},{"v":0.101,"d":"10.1%"}]
[null,"Secondary with sixth form","Small","Low FSM","Pupil to teacher ratio",{"v":11.100000000000001,"d":"11.1"},12.8,15.3,16.1,16.6,17.8,{"v":19,"d":"19.0"}]
[null,"Secondary with sixth form","Small","Low FSM","Pupil to adult ratio",6.4,8.1,9.3,9.9,{"v":10.200000000000001,"d":"10.2"},11.4,12.8]
[null,"Secondary with sixth form","Small","Low FSM","Average class size",{"v":14,"d":"14.0"},16.6,19.1,{"v":20,"d":"20.0"},20.5,{"v":22,"d":"22.0"},{"v":22.900000000000002,"d":"22.9"}]
[]
[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",{"v":0.502,"d":"50.2%"},{"v":0.532,"d":"53.2%"},{"v":0.5660000000000001,"d":"56.6%"},{"v":0.582,"d":"58.2%"},{"v":0.594,"d":"59.4%"},{"v":0.624,"d":"62.4%"},{"v":0.64,"d":"64.0%"}]
[null,"Secondary with sixth form","Medium","Low FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.007,"d":"0.7%"},{"v":0.01,"d":"1.0%"},{"v":0.012,"d":"1.2%"},{"v":0.019,"d":"1.9%"},{"v":0.026000000000000002,"d":"2.6%"}]
[null,"Secondary with sixth form","Medium","Low FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.064,"d":"6.4%"},{"v":0.07,"d":"7.0%"},{"v":0.079,"d":"7.9%"},{"v":0.097,"d":"9.7%"},{"v":0.114,"d":"11.4%"}]
[null,"Secondary with sixth form","Medium","Low FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.069,"d":"6.9%"},null,{"v":0.091,"d":"9.1%"},{"v":0.105,"d":"10.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.034,"d":"3.4%"},{"v":0.057,"d":"5.7%"}]
[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.076,"d":"7.6%"},{"v":0.095,"d":"9.5%"}]
[null,"Secondary with sixth form","Medium","Low FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.048,"d":"4.8%"},{"v":0.058,"d":"5.8%"},{"v":0.079,"d":"7.9%"},{"v":0.08700000000000001,"d":"8.7%"},{"v":0.095,"d":"9.5%"}]
[null,"Secondary with sixth form","Medium","Low FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.015,"d":"1.5%"},null,{"v":0.019,"d":"1.9%"},{"v":0.021,"d":"2.1%"}]
[null,"Secondary with sixth form","Medium","Low FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.056,"d":"5.6%"},{"v":0.059000000000000004,"d":"5.9%"},{"v":0.062,"d":"6.2%"},{"v":0.073,"d":"7.3%"},{"v":0.088,"d":"8.8%"}]
[null,"Secondary with sixth form","Medium","Low FSM","Pupil to teacher ratio",15.5,16.1,{"v":16.900000000000002,"d":"16.9"},17.3,17.6,18.5,19.3]
[null,"Secondary with sixth form","Medium","Low FSM","Pupil to adult ratio",9.3,9.9,10.4,10.8,{"v":11.100000000000001,"d":"11.1"},11.8,12.5]
[null,"Secondary with sixth form","Medium","Low FSM","Average class size",{"v":19.700000000000003,"d":"19.7"},20.3,{"v":21.200000000000003,"d":"21.2"},21.6,{"v":22,"d":"22.0"},{"v":22.900000000000002,"d":"22.9"},{"v":23.700000000000003,"d":"23.7"}]
[]
[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",{"v":0.51,"d":"51.0%"},{"v":0.532,"d":"53.2%"},{"v":0.5660000000000001,"d":"56.6%"},{"v":0.585,"d":"58.5%"},{"v":0.598,"d":"59.8%"},{"v":0.618,"d":"61.8%"},{"v":0.631,"d":"63.1%"}]
[null,"Secondary with sixth form","Large","Low FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.007,"d":"0.7%"},{"v":0.01,"d":"1.0%"},{"v":0.012,"d":"1.2%"},{"v":0.019,"d":"1.9%"},{"v":0.026000000000000002,"d":"2.6%"}]
[null,"Secondary with sixth form","Large","Low FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.07200000000000001,"d":"7.2%"},{"v":0.083,"d":"8.3%"},{"v":0.089,"d":"8.9%"},{"v":0.105,"d":"10.5%"},{"v":0.115,"d":"11.5%"}]
[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.088,"d":"8.8%"},{"v":0.109,"d":"10.9%"}]
[null,"Secondary with sixth form","Large","Low FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.013000000000000001,"d":"1.3%"},null,{"v":0.026000000000000002,"d":"2.6%"},{"v":0.05,"d":"5.0%"}]
[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.075,"d":"7.5%"},{"v":0.093,"d":"9.3%"}]
[null,"Secondary with sixth form","Large","Low FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.049,"d":"4.9%"},{"v":0.059000000000000004,"d":"5.9%"},{"v":0.07100000000000001,"d":"7.1%"},{"v":0.08,"d":"8.0%"},{"v":0.09,"d":"9.0%"}]
[null,"Secondary with sixth form","Large","Low FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.015,"d":"1.5%"},null,{"v":0.018000000000000002,"d":"1.8%"},{"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.052000000000000005,"d":"5.2%"},{"v":0.056,"d":"5.6%"},{"v":0.059000000000000004,"d":"5.9%"},{"v":0.066,"d":"6.6%"},{"v":0.083,"d":"8.3%"}]
[null,"Secondary with sixth form","Large","Low FSM","Pupil to teacher ratio",{"v":15.700000000000001,"d":"15.7"},16.2,{"v":16.900000000000002,"d":"16.9"},17.2,17.5,18.1,{"v":19,"d":"19.0"}]
[null,"Secondary with sixth form","Large","Low FSM","Pupil to adult ratio",9.5,9.9,10.4,10.8,{"v":11,"d":"11.0"},{"v":11.600000000000001,"d":"11.6"},{"v":12.200000000000001,"d":"12.2"}]
[null,"Secondary with sixth form","Large","Low FSM","Average class size",{"v":19.900000000000002,"d":"19.9"},20.6,21.3,21.6,{"v":22,"d":"22.0"},{"v":22.900000000000002,"d":"22.9"},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",{"v":0.485,"d":"48.5%"},{"v":0.537,"d":"53.7%"},{"v":0.5650000000000001,"d":"56.5%"},{"v":0.5690000000000001,"d":"56.9%"},{"v":0.5760000000000001,"d":"57.6%"},{"v":0.602,"d":"60.2%"},{"v":0.654,"d":"65.4%"}]
[null,"Secondary without sixth form","Small","Low FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.011,"d":"1.1%"},{"v":0.014,"d":"1.4%"},{"v":0.021,"d":"2.1%"},{"v":0.027,"d":"2.7%"},{"v":0.035,"d":"3.5%"}]
[null,"Secondary without sixth form","Small","Low FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.085,"d":"8.5%"},{"v":0.091,"d":"9.1%"},{"v":0.10200000000000001,"d":"10.2%"},{"v":0.117,"d":"11.7%"},{"v":0.139,"d":"13.9%"}]
[null,"Secondary without sixth form","Small","Low FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.056,"d":"5.6%"},null,{"v":0.082,"d":"8.2%"},{"v":0.095,"d":"9.5%"}]
[null,"Secondary without sixth form","Small","Low FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.018000000000000002,"d":"1.8%"},null,{"v":0.035,"d":"3.5%"},{"v":0.056,"d":"5.6%"}]
[null,"Secondary without sixth form","Small","Low FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.063,"d":"6.3%"},null,{"v":0.101,"d":"10.1%"},{"v":0.117,"d":"11.7%"}]
[null,"Secondary without sixth form","Small","Low FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.036000000000000004,"d":"3.6%"},{"v":0.043000000000000003,"d":"4.3%"},{"v":0.055,"d":"5.5%"},{"v":0.069,"d":"6.9%"},{"v":0.073,"d":"7.3%"}]
[null,"Secondary without sixth form","Small","Low FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.015,"d":"1.5%"},null,{"v":0.022,"d":"2.2%"},{"v":0.024,"d":"2.4%"}]
[null,"Secondary without sixth form","Small","Low FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.066,"d":"6.6%"},{"v":0.074,"d":"7.4%"},{"v":0.082,"d":"8.2%"},{"v":0.1,"d":"10.0%"},{"v":0.126,"d":"12.6%"}]
[null,"Secondary without sixth form","Small","Low FSM","Pupil to teacher ratio",13.9,{"v":15.700000000000001,"d":"15.7"},17.7,18.2,{"v":18.900000000000002,"d":"18.9"},19.8,{"v":20.400000000000002,"d":"20.4"}]
[null,"Secondary without sixth form","Small","Low FSM","Pupil to adult ratio",{"v":7.800000000000001,"d":"7.8"},8.8,9.8,10.3,10.5,11.4,11.8]
[null,"Secondary without sixth form","Small","Low FSM","Average class size",20.6,21.3,24.1,{"v":24.900000000000002,"d":"24.9"},{"v":25.400000000000002,"d":"25.4"},26.8,{"v":28.400000000000002,"d":"28.4"}]
[]
[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",{"v":0.506,"d":"50.6%"},{"v":0.533,"d":"53.3%"},{"v":0.561,"d":"56.1%"},{"v":0.5700000000000001,"d":"57.0%"},{"v":0.578,"d":"57.8%"},{"v":0.603,"d":"60.3%"},{"v":0.62,"d":"62.0%"}]
[null,"Secondary without sixth form","Medium","Low FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.013000000000000001,"d":"1.3%"},{"v":0.015,"d":"1.5%"},{"v":0.018000000000000002,"d":"1.8%"},{"v":0.027,"d":"2.7%"},{"v":0.038,"d":"3.8%"}]
[null,"Secondary without sixth form","Medium","Low FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.081,"d":"8.1%"},{"v":0.088,"d":"8.8%"},{"v":0.095,"d":"9.5%"},{"v":0.124,"d":"12.4%"},{"v":0.14200000000000002,"d":"14.2%"}]
[null,"Secondary without sixth form","Medium","Low FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.062,"d":"6.2%"},null,{"v":0.08600000000000001,"d":"8.6%"},{"v":0.10200000000000001,"d":"10.2%"}]
[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.035,"d":"3.5%"},{"v":0.047,"d":"4.7%"}]
[null,"Secondary without sixth form","Medium","Low FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.063,"d":"6.3%"},null,{"v":0.097,"d":"9.7%"},{"v":0.121,"d":"12.1%"}]
[null,"Secondary without sixth form","Medium","Low FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.04,"d":"4.0%"},{"v":0.049,"d":"4.9%"},{"v":0.062,"d":"6.2%"},{"v":0.069,"d":"6.9%"},{"v":0.073,"d":"7.3%"}]
[null,"Secondary without sixth form","Medium","Low FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.014,"d":"1.4%"},null,{"v":0.018000000000000002,"d":"1.8%"},{"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.058,"d":"5.8%"},{"v":0.063,"d":"6.3%"},{"v":0.068,"d":"6.8%"},{"v":0.09,"d":"9.0%"},{"v":0.10300000000000001,"d":"10.3%"}]
[null,"Secondary without sixth form","Medium","Low FSM","Pupil to teacher ratio",15.8,16.5,17.2,17.6,{"v":18,"d":"18.0"},19.1,{"v":20,"d":"20.0"}]
[null,"Secondary without sixth form","Medium","Low FSM","Pupil to adult ratio",8.9,9.3,{"v":10.100000000000001,"d":"10.1"},10.4,{"v":10.600000000000001,"d":"10.6"},11.3,{"v":12,"d":"12.0"}]
[null,"Secondary without sixth form","Medium","Low FSM","Average class size",22.3,{"v":22.900000000000002,"d":"22.9"},{"v":23.700000000000003,"d":"23.7"},24.3,{"v":24.700000000000003,"d":"24.7"},{"v":25.700000000000003,"d":"25.7"},{"v":26.700000000000003,"d":"26.7"}]
[]
[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",{"v":0.498,"d":"49.8%"},{"v":0.513,"d":"51.3%"},{"v":0.557,"d":"55.7%"},{"v":0.5660000000000001,"d":"56.6%"},{"v":0.5720000000000001,"d":"57.2%"},{"v":0.601,"d":"60.1%"},{"v":0.618,"d":"61.8%"}]
[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.013000000000000001,"d":"1.3%"},{"v":0.017,"d":"1.7%"},{"v":0.025,"d":"2.5%"},{"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.08700000000000001,"d":"8.7%"},{"v":0.092,"d":"9.2%"},{"v":0.10200000000000001,"d":"10.2%"},{"v":0.113,"d":"11.3%"},{"v":0.128,"d":"12.8%"}]
[null,"Secondary without sixth form","Large","Low FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.051000000000000004,"d":"5.1%"},null,{"v":0.077,"d":"7.7%"},{"v":0.091,"d":"9.1%"}]
[null,"Secondary without sixth form","Large","Low FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.022,"d":"2.2%"},null,{"v":0.04,"d":"4.0%"},{"v":0.062,"d":"6.2%"}]
[null,"Secondary without sixth form","Large","Low FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.076,"d":"7.6%"},null,{"v":0.117,"d":"11.7%"},{"v":0.138,"d":"13.8%"}]
[null,"Secondary without sixth form","Large","Low FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.044,"d":"4.4%"},{"v":0.053,"d":"5.3%"},{"v":0.068,"d":"6.8%"},{"v":0.076,"d":"7.6%"},{"v":0.084,"d":"8.4%"}]
[null,"Secondary without sixth form","Large","Low FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.014,"d":"1.4%"},null,{"v":0.017,"d":"1.7%"},{"v":0.019,"d":"1.9%"}]
[null,"Secondary without sixth form","Large","Low FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.051000000000000004,"d":"5.1%"},{"v":0.056,"d":"5.6%"},{"v":0.061,"d":"6.1%"},{"v":0.08,"d":"8.0%"},{"v":0.08600000000000001,"d":"8.6%"}]
[null,"Secondary without sixth form","Large","Low FSM","Pupil to teacher ratio",15.5,16.1,16.8,{"v":17,"d":"17.0"},{"v":17.400000000000002,"d":"17.4"},18.3,19.3]
[null,"Secondary without sixth form","Large","Low FSM","Pupil to adult ratio",{"v":9,"d":"9.0"},9.3,{"v":10.100000000000001,"d":"10.1"},10.3,10.4,{"v":11,"d":"11.0"},11.5]
[null,"Secondary without sixth form","Large","Low FSM","Average class size",22.6,{"v":23,"d":"23.0"},23.8,{"v":24.200000000000003,"d":"24.2"},{"v":24.400000000000002,"d":"24.4"},25.1,{"v":25.900000000000002,"d":"25.9"}]
[]
[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",{"v":0.458,"d":"45.8%"},{"v":0.496,"d":"49.6%"},{"v":0.538,"d":"53.8%"},{"v":0.553,"d":"55.3%"},{"v":0.5680000000000001,"d":"56.8%"},{"v":0.606,"d":"60.6%"},{"v":0.642,"d":"64.2%"}]
[null,"Secondary with sixth form","Small","Medium FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.013000000000000001,"d":"1.3%"},{"v":0.017,"d":"1.7%"},{"v":0.021,"d":"2.1%"},{"v":0.032,"d":"3.2%"},{"v":0.044,"d":"4.4%"}]
[null,"Secondary with sixth form","Small","Medium FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.068,"d":"6.8%"},{"v":0.078,"d":"7.8%"},{"v":0.089,"d":"8.9%"},{"v":0.114,"d":"11.4%"},{"v":0.132,"d":"13.2%"}]
[null,"Secondary with sixth form","Small","Medium FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.07200000000000001,"d":"7.2%"},null,{"v":0.107,"d":"10.7%"},{"v":0.131,"d":"13.1%"}]
[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.033,"d":"3.3%"},{"v":0.047,"d":"4.7%"}]
[null,"Secondary with sixth form","Small","Medium FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.063,"d":"6.3%"},null,{"v":0.094,"d":"9.4%"},{"v":0.116,"d":"11.6%"}]
[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.048,"d":"4.8%"},{"v":0.06,"d":"6.0%"},{"v":0.063,"d":"6.3%"},{"v":0.069,"d":"6.9%"}]
[null,"Secondary with sixth form","Small","Medium FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.018000000000000002,"d":"1.8%"},null,{"v":0.026000000000000002,"d":"2.6%"},{"v":0.031,"d":"3.1%"}]
[null,"Secondary with sixth form","Small","Medium FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.07200000000000001,"d":"7.2%"},{"v":0.077,"d":"7.7%"},{"v":0.08700000000000001,"d":"8.7%"},{"v":0.11,"d":"11.0%"},{"v":0.15,"d":"15.0%"}]
[null,"Secondary with sixth form","Small","Medium FSM","Pupil to teacher ratio",{"v":12.600000000000001,"d":"12.6"},{"v":13.600000000000001,"d":"13.6"},{"v":15.100000000000001,"d":"15.1"},{"v":15.600000000000001,"d":"15.6"},16.1,{"v":17.400000000000002,"d":"17.4"},18.7]
[null,"Secondary with sixth form","Small","Medium FSM","Pupil to adult ratio",7.4,8.3,{"v":9.200000000000001,"d":"9.2"},9.4,9.8,10.8,{"v":11.700000000000001,"d":"11.7"}]
[null,"Secondary with sixth form","Small","Medium FSM","Average class size",15.9,{"v":18,"d":"18.0"},{"v":19.900000000000002,"d":"19.9"},{"v":20.700000000000003,"d":"20.7"},21.6,23.5,24.8]
[]
[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",{"v":0.504,"d":"50.4%"},{"v":0.534,"d":"53.4%"},{"v":0.5640000000000001,"d":"56.4%"},{"v":0.5740000000000001,"d":"57.4%"},{"v":0.587,"d":"58.7%"},{"v":0.615,"d":"61.5%"},{"v":0.642,"d":"64.2%"}]
[null,"Secondary with sixth form","Medium","Medium FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.013000000000000001,"d":"1.3%"},{"v":0.016,"d":"1.6%"},{"v":0.02,"d":"2.0%"},{"v":0.029,"d":"2.9%"},{"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.08700000000000001,"d":"8.7%"},{"v":0.097,"d":"9.7%"},{"v":0.117,"d":"11.7%"},{"v":0.132,"d":"13.2%"}]
[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.094,"d":"9.4%"},{"v":0.113,"d":"11.3%"}]
[null,"Secondary with sixth form","Medium","Medium FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.017,"d":"1.7%"},null,{"v":0.037,"d":"3.7%"},{"v":0.058,"d":"5.8%"}]
[null,"Secondary with sixth form","Medium","Medium FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.059000000000000004,"d":"5.9%"},null,{"v":0.092,"d":"9.2%"},{"v":0.11,"d":"11.0%"}]
[null,"Secondary with sixth form","Medium","Medium FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.044,"d":"4.4%"},{"v":0.051000000000000004,"d":"5.1%"},{"v":0.061,"d":"6.1%"},{"v":0.067,"d":"6.7%"},{"v":0.07200000000000001,"d":"7.2%"}]
[null,"Secondary with sixth form","Medium","Medium FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.016,"d":"1.6%"},null,{"v":0.021,"d":"2.1%"},{"v":0.023,"d":"2.3%"}]
[null,"Secondary with sixth form","Medium","Medium FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.058,"d":"5.8%"},{"v":0.063,"d":"6.3%"},{"v":0.068,"d":"6.8%"},{"v":0.083,"d":"8.3%"},{"v":0.1,"d":"10.0%"}]
[null,"Secondary with sixth form","Medium","Medium FSM","Pupil to teacher ratio",14.4,{"v":15.100000000000001,"d":"15.1"},15.9,16.2,16.6,17.7,18.5]
[null,"Secondary with sixth form","Medium","Medium FSM","Pupil to adult ratio",8.5,8.9,9.5,9.8,{"v":10.200000000000001,"d":"10.2"},10.8,11.4]
[null,"Secondary with sixth form","Medium","Medium FSM","Average class size",19.1,19.6,{"v":20.700000000000003,"d":"20.7"},21.1,21.5,22.5,23.5]
[]
[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",{"v":0.52,"d":"52.0%"},{"v":0.542,"d":"54.2%"},{"v":0.5740000000000001,"d":"57.4%"},{"v":0.585,"d":"58.5%"},{"v":0.592,"d":"59.2%"},{"v":0.613,"d":"61.3%"},{"v":0.634,"d":"63.4%"}]
[null,"Secondary with sixth form","Large","Medium FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.011,"d":"1.1%"},{"v":0.013000000000000001,"d":"1.3%"},{"v":0.016,"d":"1.6%"},{"v":0.025,"d":"2.5%"},{"v":0.035,"d":"3.5%"}]
[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.092,"d":"9.2%"},{"v":0.099,"d":"9.9%"},{"v":0.114,"d":"11.4%"},{"v":0.132,"d":"13.2%"}]
[null,"Secondary with sixth form","Large","Medium FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.062,"d":"6.2%"},null,{"v":0.081,"d":"8.1%"},{"v":0.10300000000000001,"d":"10.3%"}]
[null,"Secondary with sixth form","Large","Medium FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.014,"d":"1.4%"},null,{"v":0.031,"d":"3.1%"},{"v":0.049,"d":"4.9%"}]
[null,"Secondary with sixth form","Large","Medium FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.058,"d":"5.8%"},null,{"v":0.098,"d":"9.8%"},{"v":0.132,"d":"13.2%"}]
[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.053,"d":"5.3%"},{"v":0.064,"d":"6.4%"},{"v":0.07,"d":"7.0%"},{"v":0.077,"d":"7.7%"}]
[null,"Secondary with sixth form","Large","Medium FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.015,"d":"1.5%"},null,{"v":0.018000000000000002,"d":"1.8%"},{"v":0.021,"d":"2.1%"}]
[null,"Secondary with sixth form","Large","Medium FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.051000000000000004,"d":"5.1%"},{"v":0.055,"d":"5.5%"},{"v":0.059000000000000004,"d":"5.9%"},{"v":0.07200000000000001,"d":"7.2%"},{"v":0.085,"d":"8.5%"}]
[null,"Secondary with sixth form","Large","Medium FSM","Pupil to teacher ratio",14.5,{"v":15.200000000000001,"d":"15.2"},16.2,16.5,{"v":16.900000000000002,"d":"16.9"},17.8,18.7]
[null,"Secondary with sixth form","Large","Medium FSM","Pupil to adult ratio",8.6,{"v":9.200000000000001,"d":"9.2"},{"v":9.700000000000001,"d":"9.7"},{"v":10,"d":"10.0"},10.4,{"v":11.200000000000001,"d":"11.2"},{"v":11.700000000000001,"d":"11.7"}]
[null,"Secondary with sixth form","Large","Medium FSM","Average class size",{"v":19.400000000000002,"d":"19.4"},20.1,{"v":20.900000000000002,"d":"20.9"},21.3,21.6,22.5,23.3]
[]
[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",{"v":0.461,"d":"46.1%"},{"v":0.49,"d":"49.0%"},{"v":0.531,"d":"53.1%"},{"v":0.541,"d":"54.1%"},{"v":0.554,"d":"55.4%"},{"v":0.583,"d":"58.3%"},{"v":0.609,"d":"60.9%"}]
[null,"Secondary without sixth form","Small","Medium FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.014,"d":"1.4%"},{"v":0.017,"d":"1.7%"},{"v":0.02,"d":"2.0%"},{"v":0.037,"d":"3.7%"},{"v":0.054,"d":"5.4%"}]
[null,"Secondary without sixth form","Small","Medium FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.094,"d":"9.4%"},{"v":0.10400000000000001,"d":"10.4%"},{"v":0.111,"d":"11.1%"},{"v":0.126,"d":"12.6%"},{"v":0.146,"d":"14.6%"}]
[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.11800000000000001,"d":"11.8%"}]
[null,"Secondary without sixth form","Small","Medium FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.016,"d":"1.6%"},null,{"v":0.035,"d":"3.5%"},{"v":0.051000000000000004,"d":"5.1%"}]
[null,"Secondary without sixth form","Small","Medium FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.066,"d":"6.6%"},null,{"v":0.10400000000000001,"d":"10.4%"},{"v":0.125,"d":"12.5%"}]
[null,"Secondary without sixth form","Small","Medium FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.037,"d":"3.7%"},{"v":0.044,"d":"4.4%"},{"v":0.055,"d":"5.5%"},{"v":0.059000000000000004,"d":"5.9%"},{"v":0.066,"d":"6.6%"}]
[null,"Secondary without sixth form","Small","Medium FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.018000000000000002,"d":"1.8%"},null,{"v":0.026000000000000002,"d":"2.6%"},{"v":0.031,"d":"3.1%"}]
[null,"Secondary without sixth form","Small","Medium FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.079,"d":"7.9%"},{"v":0.084,"d":"8.4%"},{"v":0.093,"d":"9.3%"},{"v":0.115,"d":"11.5%"},{"v":0.133,"d":"13.3%"}]
[null,"Secondary without sixth form","Small","Medium FSM","Pupil to teacher ratio",{"v":13.700000000000001,"d":"13.7"},{"v":14.700000000000001,"d":"14.7"},{"v":15.600000000000001,"d":"15.6"},16.3,{"v":17,"d":"17.0"},18.8,{"v":20.200000000000003,"d":"20.2"}]
[null,"Secondary without sixth form","Small","Medium FSM","Pupil to adult ratio",{"v":7.1000000000000005,"d":"7.1"},7.9,{"v":8.700000000000001,"d":"8.7"},9.1,{"v":9.700000000000001,"d":"9.7"},10.5,11.4]
[null,"Secondary without sixth form","Small","Medium FSM","Average class size",{"v":19.200000000000003,"d":"19.2"},20.6,{"v":22.200000000000003,"d":"22.2"},{"v":22.900000000000002,"d":"22.9"},{"v":23.400000000000002,"d":"23.4"},{"v":25.400000000000002,"d":"25.4"},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",{"v":0.494,"d":"49.4%"},{"v":0.516,"d":"51.6%"},{"v":0.541,"d":"54.1%"},{"v":0.553,"d":"55.3%"},{"v":0.562,"d":"56.2%"},{"v":0.595,"d":"59.5%"},{"v":0.612,"d":"61.2%"}]
[null,"Secondary without sixth form","Medium","Medium FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.014,"d":"1.4%"},{"v":0.018000000000000002,"d":"1.8%"},{"v":0.022,"d":"2.2%"},{"v":0.033,"d":"3.3%"},{"v":0.044,"d":"4.4%"}]
[null,"Secondary without sixth form","Medium","Medium FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.093,"d":"9.3%"},{"v":0.1,"d":"10.0%"},{"v":0.109,"d":"10.9%"},{"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.06,"d":"6.0%"},null,{"v":0.08600000000000001,"d":"8.6%"},{"v":0.109,"d":"10.9%"}]
[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.033,"d":"3.3%"},{"v":0.045,"d":"4.5%"}]
[null,"Secondary without sixth form","Medium","Medium FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.07,"d":"7.0%"},null,{"v":0.109,"d":"10.9%"},{"v":0.14300000000000002,"d":"14.3%"}]
[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.056,"d":"5.6%"},{"v":0.062,"d":"6.2%"},{"v":0.066,"d":"6.6%"}]
[null,"Secondary without sixth form","Medium","Medium FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.016,"d":"1.6%"},null,{"v":0.021,"d":"2.1%"},{"v":0.024,"d":"2.4%"}]
[null,"Secondary without sixth form","Medium","Medium FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.062,"d":"6.2%"},{"v":0.068,"d":"6.8%"},{"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",14.5,{"v":15.200000000000001,"d":"15.2"},16.1,16.6,17.2,{"v":18,"d":"18.0"},19.3]
[null,"Secondary without sixth form","Medium","Medium FSM","Pupil to adult ratio",8.1,8.6,{"v":9.200000000000001,"d":"9.2"},9.4,{"v":9.700000000000001,"d":"9.7"},10.5,{"v":11.200000000000001,"d":"11.2"}]
[null,"Secondary without sixth form","Medium","Medium FSM","Average class size",{"v":21,"d":"21.0"},21.8,{"v":22.900000000000002,"d":"22.9"},23.3,23.6,{"v":24.400000000000002,"d":"24.4"},25.3]
[]
[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",{"v":0.482,"d":"48.2%"},{"v":0.502,"d":"50.2%"},{"v":0.532,"d":"53.2%"},{"v":0.544,"d":"54.4%"},{"v":0.561,"d":"56.1%"},{"v":0.589,"d":"58.9%"},{"v":0.607,"d":"60.7%"}]
[null,"Secondary without sixth form","Large","Medium FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.016,"d":"1.6%"},{"v":0.019,"d":"1.9%"},{"v":0.022,"d":"2.2%"},{"v":0.032,"d":"3.2%"},{"v":0.044,"d":"4.4%"}]
[null,"Secondary without sixth form","Large","Medium FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.108,"d":"10.8%"},{"v":0.116,"d":"11.6%"},{"v":0.122,"d":"12.2%"},{"v":0.138,"d":"13.8%"},{"v":0.15,"d":"15.0%"}]
[null,"Secondary without sixth form","Large","Medium FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.056,"d":"5.6%"},null,{"v":0.083,"d":"8.3%"},{"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.029,"d":"2.9%"},{"v":0.043000000000000003,"d":"4.3%"}]
[null,"Secondary without sixth form","Large","Medium FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.073,"d":"7.3%"},null,{"v":0.11,"d":"11.0%"},{"v":0.151,"d":"15.1%"}]
[null,"Secondary without sixth form","Large","Medium FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.039,"d":"3.9%"},{"v":0.048,"d":"4.8%"},{"v":0.059000000000000004,"d":"5.9%"},{"v":0.064,"d":"6.4%"},{"v":0.07,"d":"7.0%"}]
[null,"Secondary without sixth form","Large","Medium FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.015,"d":"1.5%"},null,{"v":0.018000000000000002,"d":"1.8%"},{"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.059000000000000004,"d":"5.9%"},{"v":0.064,"d":"6.4%"},{"v":0.067,"d":"6.7%"},{"v":0.078,"d":"7.8%"},{"v":0.095,"d":"9.5%"}]
[null,"Secondary without sixth form","Large","Medium FSM","Pupil to teacher ratio",{"v":14.600000000000001,"d":"14.6"},{"v":15.100000000000001,"d":"15.1"},16.1,16.5,17.2,{"v":18,"d":"18.0"},{"v":18.400000000000002,"d":"18.4"}]
[null,"Secondary without sixth form","Large","Medium FSM","Pupil to adult ratio",8.3,8.6,9.1,9.3,{"v":9.600000000000001,"d":"9.6"},{"v":10.700000000000001,"d":"10.7"},{"v":11.200000000000001,"d":"11.2"}]
[null,"Secondary without sixth form","Large","Medium FSM","Average class size",{"v":21.400000000000002,"d":"21.4"},22.1,{"v":22.900000000000002,"d":"22.9"},23.1,{"v":23.700000000000003,"d":"23.7"},{"v":24.900000000000002,"d":"24.9"},25.6]
[]
[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",{"v":0.437,"d":"43.7%"},{"v":0.463,"d":"46.3%"},{"v":0.504,"d":"50.4%"},{"v":0.528,"d":"52.8%"},{"v":0.537,"d":"53.7%"},{"v":0.5670000000000001,"d":"56.7%"},{"v":0.589,"d":"58.9%"}]
[null,"Secondary with sixth form","Small","High FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.016,"d":"1.6%"},{"v":0.02,"d":"2.0%"},{"v":0.025,"d":"2.5%"},{"v":0.038,"d":"3.8%"},{"v":0.051000000000000004,"d":"5.1%"}]
[null,"Secondary with 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.112,"d":"11.2%"},{"v":0.139,"d":"13.9%"},{"v":0.156,"d":"15.6%"}]
[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.108,"d":"10.8%"},{"v":0.136,"d":"13.6%"}]
[null,"Secondary with sixth form","Small","High FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.017,"d":"1.7%"},null,{"v":0.039,"d":"3.9%"},{"v":0.06,"d":"6.0%"}]
[null,"Secondary with 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.109,"d":"10.9%"},{"v":0.14300000000000002,"d":"14.3%"}]
[null,"Secondary with sixth form","Small","High FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.038,"d":"3.8%"},{"v":0.044,"d":"4.4%"},{"v":0.053,"d":"5.3%"},{"v":0.058,"d":"5.8%"},{"v":0.063,"d":"6.3%"}]
[null,"Secondary with sixth form","Small","High FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.02,"d":"2.0%"},null,{"v":0.027,"d":"2.7%"},{"v":0.034,"d":"3.4%"}]
[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.073,"d":"7.3%"},{"v":0.083,"d":"8.3%"},{"v":0.105,"d":"10.5%"},{"v":0.131,"d":"13.1%"}]
[null,"Secondary with sixth form","Small","High FSM","Pupil to teacher ratio",{"v":12.100000000000001,"d":"12.1"},13.3,{"v":14.700000000000001,"d":"14.7"},15.3,15.8,{"v":17,"d":"17.0"},18.3]
[null,"Secondary with sixth form","Small","High FSM","Pupil to adult ratio",{"v":7,"d":"7.0"},7.4,8.3,{"v":8.700000000000001,"d":"8.7"},{"v":9,"d":"9.0"},9.9,10.9]
[null,"Secondary with sixth form","Small","High FSM","Average class size",16.5,18.2,{"v":19.900000000000002,"d":"19.9"},20.6,{"v":21.400000000000002,"d":"21.4"},{"v":22.700000000000003,"d":"22.7"},24.5]
[]
[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",{"v":0.466,"d":"46.6%"},{"v":0.501,"d":"50.1%"},{"v":0.528,"d":"52.8%"},{"v":0.542,"d":"54.2%"},{"v":0.556,"d":"55.6%"},{"v":0.59,"d":"59.0%"},{"v":0.628,"d":"62.8%"}]
[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.018000000000000002,"d":"1.8%"},{"v":0.023,"d":"2.3%"},{"v":0.036000000000000004,"d":"3.6%"},{"v":0.046,"d":"4.6%"}]
[null,"Secondary with sixth form","Medium","High FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.094,"d":"9.4%"},{"v":0.10200000000000001,"d":"10.2%"},{"v":0.112,"d":"11.2%"},{"v":0.132,"d":"13.2%"},{"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.10200000000000001,"d":"10.2%"},{"v":0.123,"d":"12.3%"}]
[null,"Secondary with sixth form","Medium","High FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.019,"d":"1.9%"},null,{"v":0.03,"d":"3.0%"},{"v":0.051000000000000004,"d":"5.1%"}]
[null,"Secondary with sixth form","Medium","High FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.062,"d":"6.2%"},null,{"v":0.11,"d":"11.0%"},{"v":0.157,"d":"15.7%"}]
[null,"Secondary with sixth form","Medium","High FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.038,"d":"3.8%"},{"v":0.044,"d":"4.4%"},{"v":0.053,"d":"5.3%"},{"v":0.059000000000000004,"d":"5.9%"},{"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.016,"d":"1.6%"},null,{"v":0.022,"d":"2.2%"},{"v":0.025,"d":"2.5%"}]
[null,"Secondary with sixth form","Medium","High FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.063,"d":"6.3%"},{"v":0.069,"d":"6.9%"},{"v":0.076,"d":"7.6%"},{"v":0.089,"d":"8.9%"},{"v":0.10400000000000001,"d":"10.4%"}]
[null,"Secondary with sixth form","Medium","High FSM","Pupil to teacher ratio",{"v":13.200000000000001,"d":"13.2"},{"v":13.600000000000001,"d":"13.6"},{"v":14.700000000000001,"d":"14.7"},{"v":15.200000000000001,"d":"15.2"},{"v":15.600000000000001,"d":"15.6"},16.8,17.7]
[null,"Secondary with sixth form","Medium","High FSM","Pupil to adult ratio",7.5,{"v":8,"d":"8.0"},{"v":8.700000000000001,"d":"8.7"},{"v":9,"d":"9.0"},9.3,{"v":10.100000000000001,"d":"10.1"},{"v":10.700000000000001,"d":"10.7"}]
[null,"Secondary with sixth form","Medium","High FSM","Average class size",18.3,{"v":19.200000000000003,"d":"19.2"},20.3,20.8,{"v":21.200000000000003,"d":"21.2"},{"v":22.400000000000002,"d":"22.4"},23.1]
[]
[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",{"v":0.47500000000000003,"d":"47.5%"},{"v":0.488,"d":"48.8%"},{"v":0.531,"d":"53.1%"},{"v":0.553,"d":"55.3%"},{"v":0.5630000000000001,"d":"56.3%"},{"v":0.593,"d":"59.3%"},{"v":0.617,"d":"61.7%"}]
[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.018000000000000002,"d":"1.8%"},{"v":0.023,"d":"2.3%"},{"v":0.035,"d":"3.5%"},{"v":0.041,"d":"4.1%"}]
[null,"Secondary with sixth form","Large","High FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.10300000000000001,"d":"10.3%"},{"v":0.109,"d":"10.9%"},{"v":0.115,"d":"11.5%"},{"v":0.14100000000000001,"d":"14.1%"},{"v":0.16,"d":"16.0%"}]
[null,"Secondary with sixth form","Large","High FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.046,"d":"4.6%"},null,{"v":0.093,"d":"9.3%"},{"v":0.107,"d":"10.7%"}]
[null,"Secondary with sixth form","Large","High FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.017,"d":"1.7%"},null,{"v":0.03,"d":"3.0%"},{"v":0.047,"d":"4.7%"}]
[null,"Secondary with sixth form","Large","High FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.08,"d":"8.0%"},null,{"v":0.14100000000000001,"d":"14.1%"},{"v":0.179,"d":"17.9%"}]
[null,"Secondary with sixth form","Large","High FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.041,"d":"4.1%"},{"v":0.047,"d":"4.7%"},{"v":0.055,"d":"5.5%"},{"v":0.062,"d":"6.2%"},{"v":0.069,"d":"6.9%"}]
[null,"Secondary with sixth form","Large","High FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.015,"d":"1.5%"},null,{"v":0.019,"d":"1.9%"},{"v":0.022,"d":"2.2%"}]
[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.056,"d":"5.6%"},{"v":0.062,"d":"6.2%"},{"v":0.077,"d":"7.7%"},{"v":0.089,"d":"8.9%"}]
[null,"Secondary with sixth form","Large","High FSM","Pupil to teacher ratio",{"v":13.600000000000001,"d":"13.6"},{"v":14.200000000000001,"d":"14.2"},14.9,15.4,{"v":15.600000000000001,"d":"15.6"},16.5,17.8]
[null,"Secondary with sixth form","Large","High FSM","Pupil to adult ratio",{"v":7.6000000000000005,"d":"7.6"},8.1,{"v":9,"d":"9.0"},9.3,{"v":9.600000000000001,"d":"9.6"},10.3,{"v":10.700000000000001,"d":"10.7"}]
[null,"Secondary with sixth form","Large","High FSM","Average class size",{"v":18.400000000000002,"d":"18.4"},{"v":19.200000000000003,"d":"19.2"},20.5,{"v":20.900000000000002,"d":"20.9"},{"v":21.200000000000003,"d":"21.2"},{"v":22.200000000000003,"d":"22.2"},23.6]
[]
[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",{"v":0.431,"d":"43.1%"},{"v":0.462,"d":"46.2%"},{"v":0.491,"d":"49.1%"},{"v":0.508,"d":"50.8%"},{"v":0.524,"d":"52.4%"},{"v":0.555,"d":"55.5%"},{"v":0.579,"d":"57.9%"}]
[null,"Secondary without sixth form","Small","High FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.016,"d":"1.6%"},{"v":0.02,"d":"2.0%"},{"v":0.029,"d":"2.9%"},{"v":0.041,"d":"4.1%"},{"v":0.056,"d":"5.6%"}]
[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.097,"d":"9.7%"},{"v":0.107,"d":"10.7%"},{"v":0.135,"d":"13.5%"},{"v":0.16,"d":"16.0%"}]
[null,"Secondary without sixth form","Small","High FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.063,"d":"6.3%"},null,{"v":0.10400000000000001,"d":"10.4%"},{"v":0.117,"d":"11.7%"}]
[null,"Secondary without sixth form","Small","High FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.018000000000000002,"d":"1.8%"},null,{"v":0.039,"d":"3.9%"},{"v":0.049,"d":"4.9%"}]
[null,"Secondary without sixth form","Small","High FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.07200000000000001,"d":"7.2%"},null,{"v":0.12,"d":"12.0%"},{"v":0.135,"d":"13.5%"}]
[null,"Secondary without sixth form","Small","High FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.032,"d":"3.2%"},{"v":0.037,"d":"3.7%"},{"v":0.05,"d":"5.0%"},{"v":0.057,"d":"5.7%"},{"v":0.061,"d":"6.1%"}]
[null,"Secondary without sixth form","Small","High FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.02,"d":"2.0%"},null,{"v":0.027,"d":"2.7%"},{"v":0.032,"d":"3.2%"}]
[null,"Secondary without sixth form","Small","High FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.077,"d":"7.7%"},{"v":0.088,"d":"8.8%"},{"v":0.096,"d":"9.6%"},{"v":0.132,"d":"13.2%"},{"v":0.162,"d":"16.2%"}]
[null,"Secondary without sixth form","Small","High FSM","Pupil to teacher ratio",10.4,11.5,{"v":13.100000000000001,"d":"13.1"},13.8,14.4,{"v":15.700000000000001,"d":"15.7"},{"v":18,"d":"18.0"}]
[null,"Secondary without sixth form","Small","High FSM","Pupil to adult ratio",{"v":5.800000000000001,"d":"5.8"},6.4,{"v":7.300000000000001,"d":"7.3"},7.7,{"v":8,"d":"8.0"},{"v":9,"d":"9.0"},9.8]
[null,"Secondary without sixth form","Small","High FSM","Average class size",{"v":17.400000000000002,"d":"17.4"},18.7,20.8,{"v":21.700000000000003,"d":"21.7"},22.1,23.6,24.6]
[]
[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",{"v":0.444,"d":"44.4%"},{"v":0.46900000000000003,"d":"46.9%"},{"v":0.507,"d":"50.7%"},{"v":0.519,"d":"51.9%"},{"v":0.531,"d":"53.1%"},{"v":0.555,"d":"55.5%"},{"v":0.588,"d":"58.8%"}]
[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.019,"d":"1.9%"},{"v":0.022,"d":"2.2%"},{"v":0.034,"d":"3.4%"},{"v":0.041,"d":"4.1%"}]
[null,"Secondary without sixth form","Medium","High FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.10400000000000001,"d":"10.4%"},{"v":0.11,"d":"11.0%"},{"v":0.12,"d":"12.0%"},{"v":0.14,"d":"14.0%"},{"v":0.157,"d":"15.7%"}]
[null,"Secondary without sixth form","Medium","High FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.068,"d":"6.8%"},null,{"v":0.094,"d":"9.4%"},{"v":0.115,"d":"11.5%"}]
[null,"Secondary without sixth form","Medium","High FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.018000000000000002,"d":"1.8%"},null,{"v":0.036000000000000004,"d":"3.6%"},{"v":0.058,"d":"5.8%"}]
[null,"Secondary without sixth form","Medium","High FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.073,"d":"7.3%"},null,{"v":0.123,"d":"12.3%"},{"v":0.185,"d":"18.5%"}]
[null,"Secondary without sixth form","Medium","High FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.039,"d":"3.9%"},{"v":0.045,"d":"4.5%"},{"v":0.059000000000000004,"d":"5.9%"},{"v":0.062,"d":"6.2%"},{"v":0.068,"d":"6.8%"}]
[null,"Secondary without sixth form","Medium","High FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.017,"d":"1.7%"},null,{"v":0.023,"d":"2.3%"},{"v":0.026000000000000002,"d":"2.6%"}]
[null,"Secondary without sixth form","Medium","High FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.063,"d":"6.3%"},{"v":0.068,"d":"6.8%"},{"v":0.074,"d":"7.4%"},{"v":0.091,"d":"9.1%"},{"v":0.106,"d":"10.6%"}]
[null,"Secondary without sixth form","Medium","High FSM","Pupil to teacher ratio",13.4,14.3,{"v":15.200000000000001,"d":"15.2"},15.8,16.3,17.6,18.6]
[null,"Secondary without sixth form","Medium","High FSM","Pupil to adult ratio",{"v":7,"d":"7.0"},{"v":7.6000000000000005,"d":"7.6"},8.5,8.8,9.1,9.8,10.4]
[null,"Secondary without sixth form","Medium","High FSM","Average class size",19.1,20.1,{"v":21.700000000000003,"d":"21.7"},22.1,{"v":22.900000000000002,"d":"22.9"},{"v":24.200000000000003,"d":"24.2"},{"v":25,"d":"25.0"}]
[]
[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",{"v":0.445,"d":"44.5%"},{"v":0.47800000000000004,"d":"47.8%"},{"v":0.506,"d":"50.6%"},{"v":0.51,"d":"51.0%"},{"v":0.516,"d":"51.6%"},{"v":0.549,"d":"54.9%"},{"v":0.604,"d":"60.4%"}]
[null,"Secondary without sixth form","Large","High FSM","Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.016,"d":"1.6%"},{"v":0.021,"d":"2.1%"},{"v":0.028,"d":"2.8%"},{"v":0.042,"d":"4.2%"},{"v":0.048,"d":"4.8%"}]
[null,"Secondary without sixth form","Large","High FSM","Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.09,"d":"9.0%"},{"v":0.099,"d":"9.9%"},{"v":0.107,"d":"10.7%"},{"v":0.131,"d":"13.1%"},{"v":0.149,"d":"14.9%"}]
[null,"Secondary without sixth form","Large","High FSM","Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.062,"d":"6.2%"},null,{"v":0.091,"d":"9.1%"},{"v":0.101,"d":"10.1%"}]
[null,"Secondary without sixth form","Large","High FSM","Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.021,"d":"2.1%"},null,{"v":0.044,"d":"4.4%"},{"v":0.062,"d":"6.2%"}]
[null,"Secondary without sixth form","Large","High FSM","Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.07,"d":"7.0%"},null,{"v":0.167,"d":"16.7%"},{"v":0.186,"d":"18.6%"}]
[null,"Secondary without sixth form","Large","High FSM","Spend on teaching resources as a percentage of total expenditure",{"v":0.036000000000000004,"d":"3.6%"},{"v":0.041,"d":"4.1%"},{"v":0.053,"d":"5.3%"},{"v":0.059000000000000004,"d":"5.9%"},{"v":0.066,"d":"6.6%"}]
[null,"Secondary without sixth form","Large","High FSM","Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.015,"d":"1.5%"},null,{"v":0.019,"d":"1.9%"},{"v":0.022,"d":"2.2%"}]
[null,"Secondary without sixth form","Large","High FSM","Senior leaders as a percentage of workforce",null,null,{"v":0.058,"d":"5.8%"},{"v":0.065,"d":"6.5%"},{"v":0.07100000000000001,"d":"7.1%"},{"v":0.079,"d":"7.9%"},{"v":0.092,"d":"9.2%"}]
[null,"Secondary without sixth form","Large","High FSM","Pupil to teacher ratio",13.9,14.5,15.5,{"v":16,"d":"16.0"},{"v":16.400000000000002,"d":"16.4"},16.8,20.6]
[null,"Secondary without sixth form","Large","High FSM","Pupil to adult ratio",{"v":7.300000000000001,"d":"7.3"},{"v":8,"d":"8.0"},8.8,{"v":9.200000000000001,"d":"9.2"},9.5,{"v":10.200000000000001,"d":"10.2"},10.9]
[null,"Secondary without sixth form","Large","High FSM","Average class size",{"v":20.700000000000003,"d":"20.7"},21.1,{"v":22,"d":"22.0"},22.3,{"v":23,"d":"23.0"},24.3,{"v":25.400000000000002,"d":"25.4"}]
[]
[]
["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",{"v":0.259,"d":"25.9%"},{"v":0.28300000000000003,"d":"28.3%"},{"v":0.33,"d":"33.0%"},{"v":0.34900000000000003,"d":"34.9%"},{"v":0.375,"d":"37.5%"},{"v":0.444,"d":"44.4%"},{"v":0.482,"d":"48.2%"}]
[null,"Special","London",null,"Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.021,"d":"2.1%"},{"v":0.028,"d":"2.8%"},{"v":0.055,"d":"5.5%"},{"v":0.10400000000000001,"d":"10.4%"},{"v":0.145,"d":"14.5%"}]
[null,"Special","London",null,"Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.256,"d":"25.6%"},{"v":0.278,"d":"27.8%"},{"v":0.305,"d":"30.5%"},{"v":0.372,"d":"37.2%"},{"v":0.404,"d":"40.4%"}]
[null,"Special","London",null,"Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.026000000000000002,"d":"2.6%"},null,{"v":0.081,"d":"8.1%"},{"v":0.113,"d":"11.3%"}]
[null,"Special","London",null,"Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.021,"d":"2.1%"},null,{"v":0.04,"d":"4.0%"},{"v":0.055,"d":"5.5%"}]
[null,"Special","London",null,"Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.077,"d":"7.7%"},null,{"v":0.10300000000000001,"d":"10.3%"},{"v":0.115,"d":"11.5%"}]
[null,"Special","London",null,"Spend on teaching resources as a percentage of total expenditure",{"v":0.017,"d":"1.7%"},{"v":0.021,"d":"2.1%"},{"v":0.031,"d":"3.1%"},{"v":0.035,"d":"3.5%"},{"v":0.038,"d":"3.8%"}]
[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.018000000000000002,"d":"1.8%"}]
[null,"Special","London",null,"Senior leaders as a percentage of workforce",null,null,{"v":0.051000000000000004,"d":"5.1%"},{"v":0.059000000000000004,"d":"5.9%"},{"v":0.067,"d":"6.7%"},{"v":0.089,"d":"8.9%"},{"v":0.125,"d":"12.5%"}]
[null,"Special","London",null,"Pupil to teacher ratio",{"v":3.79,"d":"3.8"},4.4,{"v":5.33,"d":"5.3"},{"v":5.68,"d":"5.7"},{"v":6.03,"d":"6.0"},{"v":6.88,"d":"6.9"},{"v":7.3100000000000005,"d":"7.3"}]
[null,"Special","London",null,"Pupil to adult ratio",{"v":1.1400000000000001,"d":"1.1"},{"v":1.31,"d":"1.3"},{"v":1.49,"d":"1.5"},{"v":1.6500000000000001,"d":"1.7"},1.8,{"v":2.35,"d":"2.4"},{"v":2.64,"d":"2.6"}]
[null,"Special","London",null,"Average teacher cost (£)",{"v":51595,"d":"£51,595"},{"v":54591,"d":"£54,591"},{"v":59929,"d":"£59,929"},{"v":62112,"d":"£62,112"},{"v":64488,"d":"£64,488"},{"v":68792,"d":"£68,792"},{"v":72936,"d":"£72,936"}]
[]
[774,"Special","Non-London",null,"SPNL"]
[null,"Special","Non-London",null,"Spend on teaching staff as a percentage of total expenditure",{"v":0.289,"d":"28.9%"},{"v":0.314,"d":"31.4%"},{"v":0.353,"d":"35.3%"},{"v":0.368,"d":"36.8%"},{"v":0.385,"d":"38.5%"},{"v":0.432,"d":"43.2%"},{"v":0.47400000000000003,"d":"47.4%"}]
[null,"Special","Non-London",null,"Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.011,"d":"1.1%"},{"v":0.016,"d":"1.6%"},{"v":0.021,"d":"2.1%"},{"v":0.043000000000000003,"d":"4.3%"},{"v":0.065,"d":"6.5%"}]
[null,"Special","Non-London",null,"Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.299,"d":"29.9%"},{"v":0.326,"d":"32.6%"},{"v":0.352,"d":"35.2%"},{"v":0.394,"d":"39.4%"},{"v":0.422,"d":"42.2%"}]
[null,"Special","Non-London",null,"Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.027,"d":"2.7%"},null,{"v":0.057,"d":"5.7%"},{"v":0.07200000000000001,"d":"7.2%"}]
[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.054,"d":"5.4%"},{"v":0.074,"d":"7.4%"}]
[null,"Special","Non-London",null,"Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.069,"d":"6.9%"},null,{"v":0.095,"d":"9.5%"},{"v":0.113,"d":"11.3%"}]
[null,"Special","Non-London",null,"Spend on teaching resources as a percentage of total expenditure",{"v":0.02,"d":"2.0%"},{"v":0.024,"d":"2.4%"},{"v":0.032,"d":"3.2%"},{"v":0.036000000000000004,"d":"3.6%"},{"v":0.041,"d":"4.1%"}]
[null,"Special","Non-London",null,"Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.011,"d":"1.1%"},null,{"v":0.016,"d":"1.6%"},{"v":0.019,"d":"1.9%"}]
[null,"Special","Non-London",null,"Senior leaders as a percentage of workforce",null,null,{"v":0.05,"d":"5.0%"},{"v":0.056,"d":"5.6%"},{"v":0.061,"d":"6.1%"},{"v":0.083,"d":"8.3%"},{"v":0.10200000000000001,"d":"10.2%"}]
[null,"Special","Non-London",null,"Pupil to teacher ratio",{"v":4.54,"d":"4.5"},{"v":5.38,"d":"5.4"},{"v":6.34,"d":"6.3"},{"v":6.75,"d":"6.8"},{"v":7.07,"d":"7.1"},{"v":7.890000000000001,"d":"7.9"},{"v":8.73,"d":"8.7"}]
[null,"Special","Non-London",null,"Pupil to adult ratio",{"v":1.35,"d":"1.4"},1.5,{"v":1.76,"d":"1.8"},{"v":1.87,"d":"1.9"},{"v":2.0100000000000002,"d":"2.0"},2.4,{"v":2.82,"d":"2.8"}]
[null,"Special","Non-London",null,"Average teacher cost (£)",{"v":47992,"d":"£47,992"},{"v":50811,"d":"£50,811"},{"v":53922,"d":"£53,922"},{"v":55436,"d":"£55,436"},{"v":57128,"d":"£57,128"},{"v":61170,"d":"£61,170"},{"v":65793,"d":"£65,793"}]
[]
[48,"Alternative provision","London",null,"APL"]
[null,"Alternative provision","London",null,"Spend on teaching staff as a percentage of total expenditure",{"v":0.314045806,"d":"31.4%"},{"v":0.339324897,"d":"33.9%"},{"v":0.424024574,"d":"42.4%"},{"v":0.43413503,"d":"43.4%"},{"v":0.467541111,"d":"46.8%"},{"v":0.540910523,"d":"54.1%"},{"v":0.576036983,"d":"57.6%"}]
[null,"Alternative provision","London",null,"Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.038390763,"d":"3.8%"},{"v":0.060562111,"d":"6.1%"},{"v":0.071701689,"d":"7.2%"},{"v":0.118392167,"d":"11.8%"},{"v":0.155331764,"d":"15.5%"}]
[null,"Alternative provision","London",null,"Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.155007004,"d":"15.5%"},{"v":0.177219906,"d":"17.7%"},{"v":0.196805002,"d":"19.7%"},{"v":0.256038279,"d":"25.6%"},{"v":0.276155553,"d":"27.6%"}]
[null,"Alternative provision","London",null,"Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.014357697,"d":"1.4%"},null,{"v":0.050700945,"d":"5.1%"},{"v":0.067317223,"d":"6.7%"}]
[null,"Alternative provision","London",null,"Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.014379802,"d":"1.4%"},null,{"v":0.027609904,"d":"2.8%"},{"v":0.05363178,"d":"5.4%"}]
[null,"Alternative provision","London",null,"Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.080728064,"d":"8.1%"},null,{"v":0.110860792,"d":"11.1%"},{"v":0.119735172,"d":"12.0%"}]
[null,"Alternative provision","London",null,"Spend on teaching resources as a percentage of total expenditure",{"v":0.019511295,"d":"2.0%"},{"v":0.022241159,"d":"2.2%"},{"v":0.030096621,"d":"3.0%"},{"v":0.034260554,"d":"3.4%"},{"v":0.044422701,"d":"4.4%"}]
[null,"Alternative provision","London",null,"Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.006223292,"d":"0.6%"},null,{"v":0.010267931,"d":"1.0%"},{"v":0.014241022,"d":"1.4%"}]
[null,"Alternative provision","London",null,"Senior leaders as a percentage of workforce",null,null,{"v":0.112199363,"d":"11.2%"},{"v":0.131578947,"d":"13.2%"},{"v":0.146979608,"d":"14.7%"},{"v":0.18755961,"d":"18.8%"},{"v":0.217831814,"d":"21.8%"}]
[null,"Alternative provision","London",null,"Pupil to teacher ratio",{"v":2.858850575,"d":"2.9"},{"v":3.615773509,"d":"3.6"},{"v":4.446311858,"d":"4.4"},4.8,{"v":5.245009074,"d":"5.2"},{"v":7.141555977,"d":"7.1"},{"v":8.804577465,"d":"8.8"}]
[null,"Alternative provision","London",null,"Pupil to adult ratio",{"v":1.367000924,"d":"1.4"},{"v":1.745438803,"d":"1.7"},{"v":2.253687996,"d":"2.3"},{"v":2.526315789,"d":"2.5"},{"v":2.603264009,"d":"2.6"},{"v":3.602926254,"d":"3.6"},{"v":4.057364484,"d":"4.1"}]
[null,"Alternative provision","London",null,"Average teacher cost (£)",{"v":33102.16354,"d":"£33,102"},{"v":49025.72283,"d":"£49,026"},{"v":57237.67205,"d":"£57,238"},{"v":59741.34807,"d":"£59,741"},{"v":62497.4729,"d":"£62,497"},{"v":72883.64973,"d":"£72,884"},{"v":88344.1172,"d":"£88,344"}]
[]
[269,"Alternative provision","Non-London",null,"APNL"]
[null,"Alternative provision","Non-London",null,"Spend on teaching staff as a percentage of total expenditure",{"v":0.29994791,"d":"30.0%"},{"v":0.351769235,"d":"35.2%"},{"v":0.402434926,"d":"40.2%"},{"v":0.438558145,"d":"43.9%"},{"v":0.473671327,"d":"47.4%"},{"v":0.535747087,"d":"53.6%"},{"v":0.581160219,"d":"58.1%"}]
[null,"Alternative provision","Non-London",null,"Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.024522892,"d":"2.5%"},{"v":0.037610473,"d":"3.8%"},{"v":0.053855339,"d":"5.4%"},{"v":0.087172218,"d":"8.7%"},{"v":0.117931945,"d":"11.8%"}]
[null,"Alternative provision","Non-London",null,"Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.159431159,"d":"15.9%"},{"v":0.185697508,"d":"18.6%"},{"v":0.200112697,"d":"20.0%"},{"v":0.245577233,"d":"24.6%"},{"v":0.281646661,"d":"28.2%"}]
[null,"Alternative provision","Non-London",null,"Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.017477628,"d":"1.7%"},null,{"v":0.065983452,"d":"6.6%"},{"v":0.087068917,"d":"8.7%"}]
[null,"Alternative provision","Non-London",null,"Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.020118797,"d":"2.0%"},null,{"v":0.03588286,"d":"3.6%"},{"v":0.051859197,"d":"5.2%"}]
[null,"Alternative provision","Non-London",null,"Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.070902818,"d":"7.1%"},null,{"v":0.105225549,"d":"10.5%"},{"v":0.129442351,"d":"12.9%"}]
[null,"Alternative provision","Non-London",null,"Spend on teaching resources as a percentage of total expenditure",{"v":0.020948882,"d":"2.1%"},{"v":0.025837958,"d":"2.6%"},{"v":0.036685795,"d":"3.7%"},{"v":0.043876442,"d":"4.4%"},{"v":0.052631579,"d":"5.3%"},{"$nulls":8},{"v":0.103868061,"d":"0.1039"}]
[null,"Alternative provision","Non-London",null,"Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.008189882,"d":"0.8%"},null,{"v":0.01199681,"d":"1.2%"},{"v":0.015058289,"d":"1.5%"}]
[null,"Alternative provision","Non-London",null,"Senior leaders as a percentage of workforce",null,null,{"v":0.086419753,"d":"8.6%"},{"v":0.099255583,"d":"9.9%"},{"v":0.112149533,"d":"11.2%"},{"v":0.143884892,"d":"14.4%"},{"v":0.186335404,"d":"18.6%"}]
[null,"Alternative provision","Non-London",null,"Pupil to teacher ratio",{"v":3.023255814,"d":"3.0"},{"v":3.695652174,"d":"3.7"},{"v":4.731707317,"d":"4.7"},{"v":5.307692308,"d":"5.3"},{"v":5.75,"d":"5.8"},{"v":7.604166667,"d":"7.6"},{"v":9.293680297,"d":"9.3"}]
[null,"Alternative provision","Non-London",null,"Pupil to adult ratio",{"v":1.299435028,"d":"1.3"},{"v":1.642857143,"d":"1.6"},{"v":2.167487685,"d":"2.2"},{"v":2.394957983,"d":"2.4"},{"v":2.613636364,"d":"2.6"},{"v":3.25,"d":"3.3"},3.8]
[null,"Alternative provision","Non-London",null,"Average teacher cost (£)",{"v":46171.57655,"d":"£46,172"},{"v":50216.40464,"d":"£50,216"},{"v":55488.90349,"d":"£55,489"},{"v":57324.38646,"d":"£57,324"},{"v":59123.83548,"d":"£59,124"},{"v":64941.29,"d":"£64,941"},{"v":77323.57143,"d":"£77,324"}]
[]
[47,"All-through","London",null,"ATL"]
[null,"All-through","London",null,"Spend on teaching staff as a percentage of total expenditure",{"v":0.462,"d":"46.2%"},{"v":0.47200000000000003,"d":"47.2%"},{"v":0.519,"d":"51.9%"},{"v":0.538,"d":"53.8%"},{"v":0.561,"d":"56.1%"},{"v":0.595,"d":"59.5%"},{"v":0.607,"d":"60.7%"}]
[null,"All-through","London",null,"Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.016,"d":"1.6%"},{"v":0.021,"d":"2.1%"},{"v":0.03,"d":"3.0%"},{"v":0.046,"d":"4.6%"},{"v":0.055,"d":"5.5%"}]
[null,"All-through","London",null,"Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.096,"d":"9.6%"},{"v":0.107,"d":"10.7%"},{"v":0.114,"d":"11.4%"},{"v":0.149,"d":"14.9%"},{"v":0.166,"d":"16.6%"}]
[null,"All-through","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.098,"d":"9.8%"},{"v":0.117,"d":"11.7%"}]
[null,"All-through","London",null,"Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.019,"d":"1.9%"},null,{"v":0.033,"d":"3.3%"},{"v":0.041,"d":"4.1%"}]
[null,"All-through","London",null,"Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.048,"d":"4.8%"},null,{"v":0.073,"d":"7.3%"},{"v":0.11,"d":"11.0%"}]
[null,"All-through","London",null,"Spend on teaching resources as a percentage of total expenditure",{"v":0.032,"d":"3.2%"},{"v":0.036000000000000004,"d":"3.6%"},{"v":0.043000000000000003,"d":"4.3%"},{"v":0.05,"d":"5.0%"},{"v":0.058,"d":"5.8%"}]
[null,"All-through","London",null,"Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.015,"d":"1.5%"},null,{"v":0.022,"d":"2.2%"},{"v":0.023,"d":"2.3%"}]
[null,"All-through","London",null,"Senior leaders as a percentage of workforce",null,null,{"v":0.073,"d":"7.3%"},{"v":0.076,"d":"7.6%"},{"v":0.079,"d":"7.9%"},{"v":0.099,"d":"9.9%"},{"v":0.111,"d":"11.1%"}]
[null,"All-through","London",null,"Pupil to teacher ratio",{"v":13.780000000000001,"d":"13.8"},{"v":14.48,"d":"14.5"},15.4,{"v":15.75,"d":"15.8"},16.4,{"v":18.29,"d":"18.3"},{"v":19.37,"d":"19.4"}]
[null,"All-through","London",null,"Pupil to adult ratio",7.9,{"v":8.28,"d":"8.3"},{"v":8.64,"d":"8.6"},{"v":9.13,"d":"9.1"},{"v":9.84,"d":"9.8"},{"v":10.57,"d":"10.6"},{"v":11.07,"d":"11.1"}]
[null,"All-through","London",null,"Average class size",{"v":20.18,"d":"20.2"},{"v":21.66,"d":"21.7"},{"v":22.84,"d":"22.8"},{"v":23.650000000000002,"d":"23.7"},{"v":24.38,"d":"24.4"},25.3,26.5]
[null,"All-through","London",null,"Average teacher cost (£)",{"v":54982,"d":"£54,982"},{"v":58087,"d":"£58,087"},{"v":60865,"d":"£60,865"},{"v":62247,"d":"£62,247"},{"v":63740,"d":"£63,740"},{"v":68741,"d":"£68,741"},{"v":71207,"d":"£71,207"}]
[]
[96,"All-through","Non-London",null,"ATNL"]
[null,"All-through","Non-London",null,"Spend on teaching staff as a percentage of total expenditure",{"v":0.428,"d":"42.8%"},{"v":0.462,"d":"46.2%"},{"v":0.493,"d":"49.3%"},{"v":0.509,"d":"50.9%"},{"v":0.525,"d":"52.5%"},{"v":0.5670000000000001,"d":"56.7%"},{"v":0.597,"d":"59.7%"}]
[null,"All-through","Non-London",null,"Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.013000000000000001,"d":"1.3%"},{"v":0.016,"d":"1.6%"},{"v":0.022,"d":"2.2%"},{"v":0.036000000000000004,"d":"3.6%"},{"v":0.057,"d":"5.7%"}]
[null,"All-through","Non-London",null,"Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.1,"d":"10.0%"},{"v":0.113,"d":"11.3%"},{"v":0.123,"d":"12.3%"},{"v":0.15,"d":"15.0%"},{"v":0.17500000000000002,"d":"17.5%"}]
[null,"All-through","Non-London",null,"Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.069,"d":"6.9%"},null,{"v":0.09,"d":"9.0%"},{"v":0.11900000000000001,"d":"11.9%"}]
[null,"All-through","Non-London",null,"Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.018000000000000002,"d":"1.8%"},null,{"v":0.036000000000000004,"d":"3.6%"},{"v":0.07,"d":"7.0%"}]
[null,"All-through","Non-London",null,"Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.06,"d":"6.0%"},null,{"v":0.08600000000000001,"d":"8.6%"},{"v":0.12,"d":"12.0%"}]
[null,"All-through","Non-London",null,"Spend on teaching resources as a percentage of total expenditure",{"v":0.036000000000000004,"d":"3.6%"},{"v":0.043000000000000003,"d":"4.3%"},{"v":0.059000000000000004,"d":"5.9%"},{"v":0.064,"d":"6.4%"},{"v":0.068,"d":"6.8%"}]
[null,"All-through","Non-London",null,"Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.017,"d":"1.7%"},null,{"v":0.023,"d":"2.3%"},{"v":0.028,"d":"2.8%"}]
[null,"All-through","Non-London",null,"Senior leaders as a percentage of workforce",null,null,{"v":0.062,"d":"6.2%"},{"v":0.069,"d":"6.9%"},{"v":0.075,"d":"7.5%"},{"v":0.098,"d":"9.8%"},{"v":0.11900000000000001,"d":"11.9%"}]
[null,"All-through","Non-London",null,"Pupil to teacher ratio",{"v":13.51,"d":"13.5"},{"v":14.780000000000001,"d":"14.8"},{"v":16.25,"d":"16.3"},{"v":16.63,"d":"16.6"},{"v":17.330000000000002,"d":"17.3"},{"v":18.37,"d":"18.4"},{"v":19.67,"d":"19.7"}]
[null,"All-through","Non-London",null,"Pupil to adult ratio",{"v":6.97,"d":"7.0"},{"v":7.65,"d":"7.7"},{"v":8.69,"d":"8.7"},{"v":9.11,"d":"9.1"},{"v":9.55,"d":"9.6"},{"v":10.39,"d":"10.4"},{"v":11.03,"d":"11.0"}]
[null,"All-through","Non-London",null,"Average class size",{"v":19.93,"d":"19.9"},{"v":21,"d":"21.0"},22.5,23.1,23.6,25.5,{"v":26.07,"d":"26.1"}]
[null,"All-through","Non-London",null,"Average teacher cost (£)",{"v":43165,"d":"£43,165"},{"v":49369,"d":"£49,369"},{"v":54641,"d":"£54,641"},{"v":55560,"d":"£55,560"},{"v":56456,"d":"£56,456"},{"v":59036,"d":"£59,036"},{"v":62649,"d":"£62,649"}]
[]
[78,"Nursery","London",null,"NL"]
[null,"Nursery","London",null,"Spend on teaching staff as a percentage of total expenditure",{"v":0.158,"d":"15.8%"},{"v":0.176,"d":"17.6%"},{"v":0.218,"d":"21.8%"},{"v":0.25,"d":"25.0%"},{"v":0.265,"d":"26.5%"},{"v":0.312,"d":"31.2%"},{"v":0.368,"d":"36.8%"}]
[null,"Nursery","London",null,"Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.007,"d":"0.7%"},{"v":0.011,"d":"1.1%"},{"v":0.015,"d":"1.5%"},{"v":0.031,"d":"3.1%"},{"v":0.044,"d":"4.4%"}]
[null,"Nursery","London",null,"Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.293,"d":"29.3%"},{"v":0.322,"d":"32.2%"},{"v":0.368,"d":"36.8%"},{"v":0.451,"d":"45.1%"},{"v":0.5,"d":"50.0%"}]
[null,"Nursery","London",null,"Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.019,"d":"1.9%"},null,{"v":0.035,"d":"3.5%"},{"v":0.05,"d":"5.0%"}]
[null,"Nursery","London",null,"Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.029,"d":"2.9%"},null,{"v":0.054,"d":"5.4%"},{"v":0.078,"d":"7.8%"}]
[null,"Nursery","London",null,"Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.1,"d":"10.0%"},null,{"v":0.137,"d":"13.7%"},{"v":0.153,"d":"15.3%"}]
[null,"Nursery","London",null,"Spend on teaching resources as a percentage of total expenditure",{"v":0.009000000000000001,"d":"0.9%"},{"v":0.012,"d":"1.2%"},{"v":0.015,"d":"1.5%"},{"v":0.017,"d":"1.7%"},{"v":0.019,"d":"1.9%"}]
[null,"Nursery","London",null,"Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.007,"d":"0.7%"},null,{"v":0.011,"d":"1.1%"},{"v":0.012,"d":"1.2%"}]
[null,"Nursery","London",null,"Senior leaders as a percentage of workforce",null,null,{"v":0.079,"d":"7.9%"},{"v":0.088,"d":"8.8%"},{"v":0.094,"d":"9.4%"},{"v":0.13,"d":"13.0%"},{"v":0.149,"d":"14.9%"}]
[null,"Nursery","London",null,"Pupil to teacher ratio",{"v":13,"d":"13.0"},16.3,{"v":19.200000000000003,"d":"19.2"},20.1,{"v":21.200000000000003,"d":"21.2"},25.1,{"v":32.800000000000004,"d":"32.8"}]
[null,"Nursery","London",null,"Pupil to adult ratio",{"v":2.8000000000000003,"d":"2.8"},{"v":3.4000000000000004,"d":"3.4"},{"v":3.9000000000000004,"d":"3.9"},{"v":4,"d":"4.0"},4.2,5.2,5.7]
[null,"Nursery","London",null,"Average teacher cost (£)",{"v":50239,"d":"£50,239"},{"v":54301,"d":"£54,301"},{"v":62886,"d":"£62,886"},{"v":64882,"d":"£64,882"},{"v":68001,"d":"£68,001"},{"v":75089,"d":"£75,089"},{"v":86095,"d":"£86,095"}]
[]
[315,"Nursery","Non-London",null,"NNL"]
[null,"Nursery","Non-London",null,"Spend on teaching staff as a percentage of total expenditure",{"v":0.17300000000000001,"d":"17.3%"},{"v":0.2,"d":"20.0%"},{"v":0.252,"d":"25.2%"},{"v":0.275,"d":"27.5%"},{"v":0.299,"d":"29.9%"},{"v":0.353,"d":"35.3%"},{"v":0.384,"d":"38.4%"}]
[null,"Nursery","Non-London",null,"Spend on supply staff as a percentage of total expenditure",null,null,{"v":0.006,"d":"0.6%"},{"v":0.009000000000000001,"d":"0.9%"},{"v":0.013000000000000001,"d":"1.3%"},{"v":0.028,"d":"2.8%"},{"v":0.042,"d":"4.2%"}]
[null,"Nursery","Non-London",null,"Spend on education support staff as a percentage of total expenditure",null,null,{"v":0.316,"d":"31.6%"},{"v":0.353,"d":"35.3%"},{"v":0.383,"d":"38.3%"},{"v":0.439,"d":"43.9%"},{"v":0.487,"d":"48.7%"}]
[null,"Nursery","Non-London",null,"Spend on administrative and clerical staff as a percentage of total expenditure",{"$nulls":3},{"v":0.021,"d":"2.1%"},null,{"v":0.037,"d":"3.7%"},{"v":0.047,"d":"4.7%"}]
[null,"Nursery","Non-London",null,"Spend on other staff costs as a percentage of total expenditure",{"$nulls":3},{"v":0.031,"d":"3.1%"},null,{"v":0.058,"d":"5.8%"},{"v":0.089,"d":"8.9%"}]
[null,"Nursery","Non-London",null,"Spend on premises (including staff costs) as a percentage of total expenditure",{"$nulls":3},{"v":0.10300000000000001,"d":"10.3%"},null,{"v":0.139,"d":"13.9%"},{"v":0.166,"d":"16.6%"}]
[null,"Nursery","Non-London",null,"Spend on teaching resources as a percentage of total expenditure",{"v":0.009000000000000001,"d":"0.9%"},{"v":0.013000000000000001,"d":"1.3%"},{"v":0.02,"d":"2.0%"},{"v":0.023,"d":"2.3%"},{"v":0.026000000000000002,"d":"2.6%"}]
[null,"Nursery","Non-London",null,"Spend on energy as a percentage of total expenditure",{"$nulls":3},{"v":0.011,"d":"1.1%"},null,{"v":0.015,"d":"1.5%"},{"v":0.018000000000000002,"d":"1.8%"}]
[null,"Nursery","Non-London",null,"Senior leaders as a percentage of workforce",null,null,{"v":0.083,"d":"8.3%"},{"v":0.096,"d":"9.6%"},{"v":0.108,"d":"10.8%"},{"v":0.139,"d":"13.9%"},{"v":0.169,"d":"16.9%"}]
[null,"Nursery","Non-London",null,"Pupil to teacher ratio",{"v":15.100000000000001,"d":"15.1"},17.3,{"v":20.900000000000002,"d":"20.9"},{"v":22.900000000000002,"d":"22.9"},{"v":25.200000000000003,"d":"25.2"},34.5,43.5]
[null,"Nursery","Non-London",null,"Pupil to adult ratio",3.5,{"v":3.9000000000000004,"d":"3.9"},{"v":4.6000000000000005,"d":"4.6"},4.9,5.2,6.2,7.2]
[null,"Nursery","Non-London",null,"Average teacher cost (£)",{"v":45220,"d":"£45,220"},{"v":49382,"d":"£49,382"},{"v":55633,"d":"£55,633"},{"v":58640,"d":"£58,640"},{"v":60718,"d":"£60,718"},{"v":66276,"d":"£66,276"},{"v":77089,"d":"£77,089"}]
[]
["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 (£)",{"v":47434,"d":"£47,434"},{"v":50498,"d":"£50,498"},{"v":54098,"d":"£54,098"},{"v":55712,"d":"£55,712"},{"v":57270,"d":"£57,270"},{"v":61701,"d":"£61,701"},{"v":66594,"d":"£66,594"}]
[]
[{"v":13651,"d":"13,651"},"Primary","Non-London",null,"PNL"]
[null,"Primary","Non-London",null,"Average teacher cost (£)",{"v":42766,"d":"£42,766"},{"v":45507,"d":"£45,507"},{"v":48721,"d":"£48,721"},{"v":50049,"d":"£50,049"},{"v":51461,"d":"£51,461"},{"v":54822,"d":"£54,822"},{"v":58243,"d":"£58,243"}]
[]
[328,"Secondary with sixth form","London",null,"SSLo"]
[null,"Secondary with sixth form","London",null,"Average teacher cost (£)",{"v":53295,"d":"£53,295"},{"v":56377,"d":"£56,377"},{"v":59804,"d":"£59,804"},{"v":61085,"d":"£61,085"},{"v":63076,"d":"£63,076"},{"v":67341,"d":"£67,341"},{"v":71404,"d":"£71,404"}]
[]
[{"v":1861,"d":"1,861"},"Secondary with sixth form","Non-London",null,"SSNL"]
[null,"Secondary with sixth form","Non-London",null,"Average teacher cost (£)",{"v":49281,"d":"£49,281"},{"v":51735,"d":"£51,735"},{"v":54105,"d":"£54,105"},{"v":55075,"d":"£55,075"},{"v":56178,"d":"£56,178"},{"v":59004,"d":"£59,004"},{"v":61846,"d":"£61,846"}]
[]
[96,"Secondary without sixth form","London",null,"SL"]
[null,"Secondary without sixth form","London",null,"Average teacher cost (£)",{"v":52925,"d":"£52,925"},{"v":56414,"d":"£56,414"},{"v":59986,"d":"£59,986"},{"v":61934,"d":"£61,934"},{"v":63336,"d":"£63,336"},{"v":67179,"d":"£67,179"},{"v":73096,"d":"£73,096"}]
[]
[678,"Secondary without sixth form","Non-London",null,"SNL"]
[null,"Secondary without sixth form","Non-London",null,"Average teacher cost (£)",{"v":49083,"d":"£49,083"},{"v":51180,"d":"£51,180"},{"v":53946,"d":"£53,946"},{"v":55066,"d":"£55,066"},{"v":56013,"d":"£56,013"},{"v":59099,"d":"£59,099"},{"v":62877,"d":"£62,877"}]

{"sheet":"RAG_Calculation","index":9,"n_rows":94,"n_cols":17,"rows_kept":94,"hidden":true,"merged":[[27,2,27,5],[27,6,27,11],[27,13,27,14]]}
[]
["RAG ratings for each school"]
[]
[]
[null,null,{"$f":"IF(C30=\"Primary\",\"P\",IF(C30=\"Secondary with sixth form\",\"SS\",IF(C30=\"Secondary without sixth form\",\"S\",IF(C30=\"Special\",\"SP\",IF(C30=\"Alternative provision\",\"AP\",IF(C30=\"All-through\",\"AT\",IF(C30=\"Nursery\",\"N\")))))))","v":"SS"}]
[null,null,{"$f":"C5&\nIF($H30=\"very small\",\"VS\",IF($H30=\"small\",\"S\",IF($H30=\"medium\",\"M\",IF($H30=\"large\",\"L\"))))&\nIF($I30=\"low levels of FSM\",\"L\",IF($I30=\"medium levels of FSM\",\"M\",IF($I30=\"high levels of FSM\",\"H\")))","v":"SSML"}]
[null,null,{"$f":"C5&\nIF(AND(C5=\"SS\",$G30=\"in London\"),\"Lo\",IF($G30=\"in London\",\"L\",IF($G30=\"outside London\",\"NL\")))","v":"SSNL"}]
[null,null,1,2,3,4,5,6,7]
["Spend on teaching staff as a percentage of total expenditure",1,{"$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.502,"d":"50.2%"}},{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$6),$B9,D$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"AT\",$C$5=\"SP\"),INDEX(INDIRECT($C$7),$B9,D$8)))","v":{"v":0.532,"d":"53.2%"}},{"v":0.5660000000000001,"d":"56.6%"},{"v":0.582,"d":"58.2%"},{"v":0.594,"d":"59.4%"},{"v":0.624,"d":"62.4%"},{"v":0.64,"d":"64.0%"},1]
["Spend on supply staff as a percentage of total expenditure",2,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.007,"d":"0.7%"}},{"v":0.01,"d":"1.0%"},{"v":0.012,"d":"1.2%"},{"v":0.019,"d":"1.9%"},{"v":0.026000000000000002,"d":"2.6%"},2]
["Spend on education support staff as a percentage of total expenditure",3,null,null,{"v":0.064,"d":"6.4%"},{"v":0.07,"d":"7.0%"},{"v":0.079,"d":"7.9%"},{"v":0.097,"d":"9.7%"},{"v":0.114,"d":"11.4%"},3]
["Spend on administrative and clerical staff as a percentage of total expenditure",4,{"$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.069,"d":"6.9%"}},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.091,"d":"9.1%"}},{"$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.105,"d":"10.5%"}},4]
["Spend on other staff costs as a percentage of total expenditure",5,{"$nulls":3},{"v":0.015,"d":"1.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.034,"d":"3.4%"}},{"$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.057,"d":"5.7%"}},5]
["Spend on premises (including staff costs) as a percentage of total expenditure",6,{"$nulls":3},{"v":0.055,"d":"5.5%"},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.076,"d":"7.6%"}},{"v":0.095,"d":"9.5%"},6]
["Spend on teaching resources as a percentage of total expenditure",7,{"$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.048,"d":"4.8%"}},{"$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.058,"d":"5.8%"}},{"$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.079,"d":"7.9%"}},{"$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.08700000000000001,"d":"8.7%"}},{"$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.095,"d":"9.5%"}},null,null,7]
["Spend on energy as a percentage of total expenditure",8,{"$nulls":3},{"v":0.015,"d":"1.5%"},null,{"v":0.019,"d":"1.9%"},{"v":0.021,"d":"2.1%"},8]
["Senior leaders as a percentage of workforce",9,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.056,"d":"5.6%"}},{"v":0.059000000000000004,"d":"5.9%"},{"$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.062,"d":"6.2%"}},{"v":0.073,"d":"7.3%"},{"v":0.088,"d":"8.8%"},9]
["Pupil to teacher ratio",10,{"$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":15.5},{"$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":16.1},{"$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":16.900000000000002,"d":"16.9"}},17.3,{"$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":17.6},18.5,19.3,10]
["Pupil to adult ratio",11,{"$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":9.3},{"$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":9.9},{"$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":10.4},10.8,{"$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":11.100000000000001,"d":"11.1"}},11.8,12.5,11]
["Average class size",12,{"$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":{"v":19.700000000000003,"d":"19.7"}},20.3,{"v":21.200000000000003,"d":"21.2"},21.6,{"v":22,"d":"22.0"},{"v":22.900000000000002,"d":"22.9"},{"v":23.700000000000003,"d":"23.7"},12]
["Average teacher cost",13,{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$7),1,C$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"SP\"),INDEX(INDIRECT($C$7),$B20,C$8),\nIF($C$5=\"AT\",INDEX(INDIRECT($C$7),$B21,C$8))))","v":{"v":49281,"d":"£49,281"}},{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$7),1,D$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"SP\"),INDEX(INDIRECT($C$7),$B20,D$8),\nIF($C$5=\"AT\",INDEX(INDIRECT($C$7),$B21,D$8))))","v":{"v":51735,"d":"£51,735"}},{"v":54105,"d":"£54,105"},{"v":55075,"d":"£55,075"},{"v":56178,"d":"£56,178"},{"v":59004,"d":"£59,004"},{"v":61846,"d":"£61,846"},13]
[]
[]
[]
[]
["Information for the 'RAG rating data for your school' look ups"]
[]
[null,null,"School information from dashboard",{"$nulls":3},"Info for comparison description",{"$nulls":6},"Text for Dashboard"]
[null,null,"Phase","Pupil","Region","FSM",{"$nulls":7},1,2,null,"RAG sheet FLAG"]
[null,null,"Secondary with sixth form",1343,"East of England",0.059000000000000004,{"$f":"IF(E30=\"\",\"\",IF(OR(E30=\"Inner London\",E30=\"Outer London\"),\"in London\",\"outside London\"))","v":"outside London"},{"$f":"IF(AND(C30=\"Primary\",D30<=$C$33),\"very small\",IF(AND(C30=\"Primary\",D30<=$D$33,D30>$C$33),\"small\",IF(AND(C30=\"Primary\",D30>$D$33,D30<=$E$33),\"medium\",IF(AND(C30=\"Primary\",D30>$E$33),\"large\",\nIF(AND(C30=\"Secondary with sixth form\",D30<=$D$34),\"small\",IF(AND(C30=\"Secondary with sixth form\",D30>$D$34,D30<=$E$34),\"medium\",IF(AND(C30=\"Secondary with sixth form\",D30>$E$34),\"large\",\nIF(AND(C30=\"Secondary without sixth form\",D30<=$D$35),\"small\",IF(AND(C30=\"Secondary without sixth form\",D30>$D$35,D30<=$E$35),\"medium\",IF(AND(C30=\"Secondary without sixth form\",D30>$E$35),\"large\",\"\"))))))))))","v":"medium"},{"$f":"IF(AND(C30=\"Primary\",F30<=$C$38),\"low levels of FSM\",IF(AND(C30=\"Primary\",F30>$C$38,F30<=$D$38),\"medium levels of FSM\",IF(AND(C30=\"Primary\",F30>$D$38),\"high levels of FSM\",\nIF(AND(C30=\"Secondary with sixth form\",F30<=$C$39),\"low levels of FSM\",IF(AND(C30=\"Secondary with sixth form\",F30>$C$39,F30<=$D$39),\"medium levels of FSM\",IF(AND(C30=\"Secondary with sixth form\",F30>$D$39),\"high levels of FSM\",\nIF(AND(C30=\"Secondary without sixth form\",F30<=$C$40),\"low levels of FSM\",IF(AND(C30=\"Secondary without sixth form\",F30>$C$40,F30<=$D$40),\"medium levels of FSM\",IF(AND(C30=\"Secondary without sixth form\",F30>$D$40),\"high levels of FSM\",\"\")))))))))","v":"low levels of FSM"},{"$f":"IF(C30=\"Primary\",\"a primary school\",IF(C30=\"Secondary with sixth form\",\"a secondary school with a sixth form\",IF(C30=\"Secondary without sixth form\",\"a secondary school without a sixth form\",IF(C30=\"Special\",\"a special school\",IF(C30=\"Alternative provision\",\"an alternative provision school\",IF(C30=\"All-through\",\"an all-through school\",IF(C30=\"Nursery\",\"a nursery school\",\"\")))))))","v":"a secondary school with a sixth form"},{"$f":"IF(AND(C30=\"Primary\",H30=\"very small\"),$C$33&\" or fewer pupils\",\nIF(AND(C30=\"Primary\",H30=\"small\"),\"between \"&$C$33+1&\" and \"&$D$33&\" pupils\",\nIF(AND(C30=\"Primary\",H30=\"medium\"),\"between \"&$D$33+1&\" and \"&$E$33&\" pupils\",\nIF(AND(C30=\"Primary\",H30=\"large\"),\"more than \"&$E$33&\" pupils\",\n\nIF(AND(C30=\"Secondary with sixth form\",H30=\"small\"),$D$34&\" or fewer pupils\",\nIF(AND(C30=\"Secondary with sixth form\",H30=\"medium\"),\"between \"&$D$34+1&\" and \"&$E$34&\" pupils\",\nIF(AND(C30=\"Secondary with sixth form\",H30=\"large\"),\"more than \"&$E$34&\" pupils\",\n\nIF(AND(C30=\"Secondary without sixth form\",H30=\"small\"),$D$35&\" or fewer pupils\",\nIF(AND(C30=\"Secondary without sixth form\",H30=\"medium\"),\"between \"&$D$35+1&\" and \"&$E$35&\" pupils\",\nIF(AND(C30=\"Secondary without sixth form\",H30=\"large\"),\"more than \"&$E$35&\" pupils\",\"\"))))))))))","v":"between 840 and 1348 pupils"},{"$f":"IF(AND(C30=\"Primary\",I30=\"low levels of FSM\"),\"less than \"&$E$38&\" of pupils\",\nIF(AND(C30=\"Primary\",I30=\"medium levels of FSM\"),\"between \"&$E$38&\" and \"&$F$38&\" of pupils\",\nIF(AND(C30=\"Primary\",I30=\"high levels of FSM\"),\"more than \"&$F$38&\" of pupils\",\n\nIF(AND(C30=\"Secondary with sixth form\",I30=\"low levels of FSM\"),\"less than \"&$E$39&\" of pupils\",\nIF(AND(C30=\"Secondary with sixth form\",I30=\"medium levels of FSM\"),\"between \"&$E$39&\" and \"&$F$39&\" of pupils\",\nIF(AND(C30=\"Secondary with sixth form\",I30=\"high levels of FSM\"),\"more than \"&$F$39&\" of pupils\",\n\nIF(AND(C30=\"Secondary without sixth form\",I30=\"low levels of FSM\"),\"less than \"&$E$40&\" of pupils\",\nIF(AND(C30=\"Secondary without sixth form\",I30=\"medium levels of FSM\"),\"between \"&$E$40&\" and \"&$F$40&\" of pupils\",\nIF(AND(C30=\"Secondary without sixth form\",I30=\"high levels of FSM\"),\"more than \"&$F$40&\" of pupils\",\"\")))))))))","v":"less than 6.3% of pupils"},null,{"$f":"IF(OR(C30=\"Primary\",C30=\"Secondary with sixth form\",C30=\"Secondary without sixth form\"),LOWER(\"- a \"&H30&\" \"&C30&\" with \")&I30,\"- \"&LOWER(C30)&\" schools\")","v":"- a medium secondary with sixth form with low levels of FSM"},{"$f":"LOWER(\"- \"&J30&\" \")&G30&\"(for average teacher cost only)\"","v":"- a secondary school with a sixth form outside London(for average teacher cost only)"},null,{"$f":"IF(OR(C30=\"All-through\",C30=\"Special\",C30=\"Alternative provision\",C30=\"Nursery\"),1,0)","v":0}]
[]
[null,null,"Very small","Small","Medium"]
["Primary",null,100,173,389]
["Secondary with sixth form",null,null,839,1348]
["Secondary without sixth form",null,null,570,980]
[]
[null,null,"Low","Medium","Low","Medium"]
["Primary",null,0.062,0.208,{"$f":"(C38*100)&\"%\"","v":"6.2%"},"20.8%"]
["Secondary with sixth form",null,0.063,0.176,"6.3%","17.6%"]
["Secondary without sixth form",null,0.096,0.233,"9.6%","23.3%"]
[]
[]
[]
[]
["Temporary data"]
[]
[]
["Schools Data",null,"Temp","RAG",null,"Checker"]
["Spend on teaching staff as a percentage of total expenditure",null,0.5941734417344173,{"$f":"IF(F49=\"Not Ready\",\"\",\nIF(C49<=RAG_Calculation!C9,Lowest10,\nIF(AND(C49>RAG_Calculation!C9,C49<=RAG_Calculation!D9),Lowest20,\nIF(AND(C49>RAG_Calculation!D9,C49<=RAG_Calculation!E9),Inline,\nIF(AND(C49>RAG_Calculation!E9,C49<=RAG_Calculation!G9),Middle20,\nIF(AND(C49>RAG_Calculation!G9,C49<=RAG_Calculation!H9),Inline,\nIF(AND(C49>RAG_Calculation!H9,C49<=RAG_Calculation!I9),Highest20,\nIF(C49>RAG_Calculation!I9,Highest10,\"\"))))))))","v":"Broadly in line with similar schools"},null,{"$f":"IF(OR(C30=\"\",D30=\"\",E30=\"\",F30=\"\"),\"Not Ready\",\"Ready\")","v":"Ready"}]
["Spend on supply staff as a percentage of total expenditure",null,4.7425474254742545E-3,{"$f":"IF(F49=\"Not Ready\",\"\",\nIF(C50<=RAG_Calculation!E10,Inline,\nIF(AND(C50>RAG_Calculation!E10,C50<=RAG_Calculation!G10),Middle20,\nIF(AND(C50>RAG_Calculation!G10,C50<=RAG_Calculation!H10),Inline,\nIF(AND(C50>RAG_Calculation!H10,C50<=RAG_Calculation!I10),Highest20,\nIF(C50>RAG_Calculation!I10,Highest10,\"\"))))))","v":"Broadly in line with similar schools"}]
["Spend on education support staff as a percentage of total expenditure",null,0.12127371273712736,{"$f":"IF(F49=\"Not Ready\",\"\",\nIF(C51<=RAG_Calculation!E11,Inline,\nIF(AND(C51>RAG_Calculation!E11,C51<=RAG_Calculation!G11),Middle20,\nIF(AND(C51>RAG_Calculation!G11,C51<=RAG_Calculation!H11),Inline,\nIF(AND(C51>RAG_Calculation!H11,C51<=RAG_Calculation!I11),Highest20,\nIF(C51>RAG_Calculation!I11,Highest10,\"\"))))))","v":"Highest 10% of similar schools"}]
["Spend on administrative and clerical staff as a percentage of total expenditure",null,0.08279132791327913,{"$f":"IF(F49=\"Not Ready\",\"\",\nIF(C52<=RAG_Calculation!H12,Inline,\nIF(AND(C52>RAG_Calculation!H12,C52<=RAG_Calculation!I12),Highest20,\nIF(C52>RAG_Calculation!I12,Highest10,\"\"))))","v":"Broadly in line with similar schools"}]
["Spend on other staff costs as a percentage of total expenditure",null,3.2520325203252032E-3,{"$f":"IF(F49=\"Not Ready\",\"\",\nIF(C53<=RAG_Calculation!H13,Inline,\nIF(AND(C53>RAG_Calculation!H13,C53<=RAG_Calculation!I13),Highest20,\nIF(C53>RAG_Calculation!I13,Highest10,\"\"))))","v":"Broadly in line with similar schools"}]
["Spend on premises (including staff costs) as a percentage of total expenditure",null,0.06260162601626017,{"$f":"IF(F49=\"Not Ready\",\"\",\nIF(C54<=RAG_Calculation!H14,Inline,\nIF(AND(C54>RAG_Calculation!H14,C54<=RAG_Calculation!I14),Highest20,\nIF(C54>RAG_Calculation!I14,Highest10,\"\"))))","v":"Broadly in line with similar schools"}]
["Spend on teaching resources as a percentage of total expenditure",null,0.0470189701897019,{"$f":"IF(F49=\"Not Ready\",\"\",\nIF(C55<=RAG_Calculation!C15,Lowest10,\nIF(AND(C55>RAG_Calculation!C15,C55<=RAG_Calculation!D15),Lowest20,\nIF(AND(C55>RAG_Calculation!D15,C55<=RAG_Calculation!E15),Inline,\nIF(AND(C55>RAG_Calculation!E15,C55<=RAG_Calculation!G15),Middle20,\nIF(C55>RAG_Calculation!G15,Inline,\"\"))))))","v":"Lowest 10% of similar schools"}]
["Spend on energy as a percentage of total expenditure",null,0.022764227642276424,{"$f":"IF(F49=\"Not Ready\",\"\",\nIF(C56<=RAG_Calculation!H16,Inline,\nIF(AND(C56>RAG_Calculation!H16,C56<=RAG_Calculation!I16),Highest20,\nIF(C56>RAG_Calculation!I16,Highest10,\"\"))))","v":"Highest 10% of similar schools"}]
["Other spending as a percentage of total expenditure (balancing line)",null,0.06138211382113821,{"$f":"IF(F49=\"Not Ready\",\"\",\"N/A\")","v":"N/A"}]
[]
["In-year balance as a percentage of total income",null,-0.018633540372670808,{"$f":"IF(F49=\"Not Ready\",\"\",\nIF(C59<=-0.05,High,\nIF(AND(C59>-0.05,C59<0),Medium,\nIF(C59>=0,Low,\"\"))))","v":"Medium risk"}]
["Revenue reserve as a percentage of total income",null,0.034782608695652174,{"$f":"IF(F49=\"Not Ready\",\"\",\nIF(C60<=-0.05,High,\nIF(AND(C60>-0.05,C60<0),Medium,\nIF(C60>=0,Low,\"\"))))","v":"Low risk"}]
[]
["Average teacher cost (£)",null,{"v":62357.79,"d":"£62,357.79"},{"$f":"IF(F49=\"Not Ready\",\"\",\nIF(C62<=RAG_Calculation!C21,Lowest10,\nIF(AND(C62>RAG_Calculation!C21,C62<=RAG_Calculation!D21),Lowest20,\nIF(AND(C62>RAG_Calculation!D21,C62<=RAG_Calculation!E21),Inline,\nIF(AND(C62>RAG_Calculation!E21,C62<=RAG_Calculation!G21),Middle20,\nIF(AND(C62>RAG_Calculation!G21,C62<=RAG_Calculation!H21),Inline,\nIF(AND(C62>RAG_Calculation!H21,C62<=RAG_Calculation!I21),Highest20,\nIF(C62>RAG_Calculation!I21,Highest10,\"\"))))))))","v":"Highest 10% of similar schools"}]
["Senior leaders as a percentage of workforce",null,0.08647526807333103,{"$f":"IF(F49=\"Not Ready\",\"\",\nIF(C63<=RAG_Calculation!E17,Inline,\nIF(AND(C63>RAG_Calculation!E17,C63<=RAG_Calculation!G17),Middle20,\nIF(AND(C63>RAG_Calculation!G17,C63<=RAG_Calculation!H17),Inline,\nIF(AND(C63>RAG_Calculation!H17,C63<=RAG_Calculation!I17),Highest20,\nIF(C63>RAG_Calculation!I17,Highest10,\"\"))))))","v":"Highest 20% of similar schools"}]
["Pupil to teacher ratio",null,19.09840728100114,{"$f":"IF(F49=\"Not Ready\",\"\",\nIF(C64<=RAG_Calculation!C18,Lowest10,\nIF(AND(C64>RAG_Calculation!C18,C64<=RAG_Calculation!D18),Lowest20,\nIF(AND(C64>RAG_Calculation!D18,C64<=RAG_Calculation!E18),Inline,\nIF(AND(C64>RAG_Calculation!E18,C64<=RAG_Calculation!G18),Middle20,\nIF(AND(C64>RAG_Calculation!G18,C64<=RAG_Calculation!H18),Inline,\nIF(AND(C64>RAG_Calculation!H18,C64<=RAG_Calculation!I18),Highest20,\nIF(C64>RAG_Calculation!I18,Highest10,\"\"))))))))","v":"Highest 20% of similar schools"}]
["Pupil to adult ratio",null,11.613628502248357,{"$f":"IF(F49=\"Not Ready\",\"\",\nIF(C65<=RAG_Calculation!C19,Lowest10,\nIF(AND(C65>RAG_Calculation!C19,C65<=RAG_Calculation!D19),Lowest20,\nIF(AND(C65>RAG_Calculation!D19,C65<=RAG_Calculation!E19),Inline,\nIF(AND(C65>RAG_Calculation!E19,C65<=RAG_Calculation!G19),Middle20,\nIF(AND(C65>RAG_Calculation!G19,C65<=RAG_Calculation!H19),Inline,\nIF(AND(C65>RAG_Calculation!H19,C65<=RAG_Calculation!I19),Highest20,\nIF(C65>RAG_Calculation!I19,Highest10,\"\"))))))))","v":"Broadly in line with similar schools"}]
["Teacher contact ratio (less than 1.0)",null,null,{"$f":"IF(F49=\"Not Ready\",\"\",\nIF(C66<=0.7,MuchLower,\nIF(AND(C66>0.7,C66<=0.74),Lower,\nIF(AND(C66>0.74,C66<=0.8),Inline2,\nIF(AND(C66>0.8,C66<=0.82),Higher,\nIF(C66>0.82,Muchhigher,\"\"))))))","v":"Much lower than recommended"}]
["Predicted percentage pupil number change in 3-5 years",null,0.055,{"$f":"IF(F49=\"Not Ready\",\"\",\nIF(C67<=-0.1,High,\nIF(AND(C67>-0.1,C67<=-0.02),Medium,\nIF(C67>=-0.02,Low,\"\"))))","v":"Low risk"}]
["Average class size",null,21.5,{"$f":"IF(F49=\"Not Ready\",\"\",\nIF(C68<=RAG_Calculation!C20,Lowest10,\nIF(AND(C68>RAG_Calculation!C20,C68<=RAG_Calculation!D20),Lowest20,\nIF(AND(C68>RAG_Calculation!D20,C68<=RAG_Calculation!E20),Inline,\nIF(AND(C68>RAG_Calculation!E20,C68<=RAG_Calculation!G20),Middle20,\nIF(AND(C68>RAG_Calculation!G20,C68<=RAG_Calculation!H20),Inline,\nIF(AND(C68>RAG_Calculation!H20,C68<=RAG_Calculation!I20),Highest20,\nIF(C68>RAG_Calculation!I20,Highest10,\"\"))))))))","v":"Middle 20% of similar schools"}]
[]
[]
[]
["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"]