{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Introduction and outcomes","Checklist","Dashboard","Optional - input raw data","RAG rating data for your school","RAG rating data for all schools","Calcs"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":4,"defined_names":96,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction and outcomes","index":0,"n_rows":21,"n_cols":15,"rows_kept":21,"cut":false,"hidden":false,"merged":[[18,2,18,10],[18,11,18,13],[20,2,20,10],[20,11,20,13],[22,2,22,9],[12,2,12,19],[14,2,14,10],[14,11,14,13],[14,14,14,18],[16,2,16,10],[16,11,16,13],[11,2,11,19],[2,2,2,19],[4,2,4,19],[5,2,5,19],[6,2,6,19],[9,2,9,19]]}
[]
[]
[null,null,"Introduction to the schools financial value standard (SFVS)"]
[]
[null,null,"The schools financial value standard helps to provide schools with assurance that they are meeting the basic standards necessary to achieve a good level of financial health and resource management. \n\nThe tool can be used to identify possible areas for change to ensure that resources are being used to support high-quality teaching and the best education outcomes for pupils. The tool is in two parts:"]
[null,null,"1. A checklist, which asks a number of questions of governing bodies in six areas of resource management to provide assurance that the school is managing its resources effectively."]
[null,null,"2. A dashboard, which shows how a school's data compares to thresholds on a range of statistics that have been identified as indicators for good resource management and outcomes."]
[]
[]
[null,null,"Outcome of schools financial value standard (SFVS)"]
[]
[null,null,"Summary of agreed action and timetable for reporting back:"]
[null,null,"Aware we have answered NO to question Q21 as we do not look at DfE recommended deals when considering best value for non-staff expenditure. However the SBM will ensure these are checked from now on and use to compare best value against other quotes etc.                                                                                                                                          Areas highlighted red by RAG rating data on the Dashboard:  high expenditure on teaching staff and high expenditure on premises costs - these have already been noted and discussed with governors, and plans are in place for future years. Need to bring costs down in line with two bulge classes leaving over the last two academic years. "]
[]
[null,null,"Signature:",null,null,null,null,null,null,null,null,null,null,null,"Chair of governing body / management committee"]
[]
[null,null,"Full name of signatory:",null,null,null,null,null,null,null,null,"Rev Val Williams"]
[]
[null,null,"Date SFVS agreed by full governing body / managament committee",null,null,null,null,null,null,null,null,"2020-03-09"]
[]
[null,null,"Date SFVS submitted to local authority for review:",null,null,null,null,null,null,null,null,"2020-03-10"]

{"sheet":"Checklist","index":1,"n_rows":62,"n_cols":15,"rows_kept":62,"cut":false,"hidden":false,"merged":[[63,2,63,9],[8,2,9,6],[8,7,9,20],[10,2,10,6],[10,7,10,20],[56,3,56,9],[56,14,56,20],[57,3,57,9],[57,14,57,20],[59,2,59,20],[61,3,61,9],[61,14,61,20],[53,3,53,9],[53,14,53,20],[54,3,54,9],[54,14,54,20],[55,3,55,9],[55,14,55,20],[47,3,47,9],[47,14,47,20],[48,3,48,9],[48,14,48,20],[50,2,50,20],[52,3,52,9],[52,14,52,20],[44,3,44,9],[44,14,44,20],[45,3,45,9],[45,14,45,20],[46,3,46,9],[46,14,46,20],[43,3,43,9],[43,14,43,20],[32,3,32,9],[32,14,32,20],[33,3,33,9],[33,14,33,20],[35,2,35,20],[37,3,37,9],[37,14,37,20],[38,3,38,9],[38,14,38,20],[39,3,39,9],[39,14,39,20],[41,2,41,20],[31,3,31,9],[31,14,31,20],[21,2,21,20],[23,3,23,9],[23,14,23,20],[24,3,24,9],[24,14,24,20],[25,3,25,9],[25,14,25,20],[27,2,27,20],[29,3,29,9],[29,14,29,20],[30,3,30,9],[30,14,30,20],[17,3,17,9],[17,14,17,20],[18,3,18,9],[18,14,18,20],[19,3,19,9],[19,14,19,20],[13,2,13,20],[15,3,15,9],[15,14,15,20],[16,3,16,9],[16,14,16,20],[2,2,2,20],[4,2,4,20],[5,2,5,20],[6,2,6,20],[12,14,12,20]]}
[]
[]
[null,null,"Schools financial value standard - checklist"]
[]
[null,null,"The checklist asks a number of questions of governing bodies in six areas of resource management to help provide assurance that resources are being managed effectively. \n\nThe completion of this assessment forms part of the schools financial value standard. Your return must be submitted to your local authority"]
[null,null,"Guidance on completion of this document can be found here. This guidance also includes examples of good practice and details further support available to assist governing bodies in addressing specific issues. Clicking on the individual questions below will also take you to the relevant section of the guidance."]
[null,null,"Schools should answer each question with 'yes', 'no', or 'in part' from the drop down lists provided. They should provide comments, evidence and proposed actions for questions as appropriate."]
[]
[null,null,"School name:",null,null,null,null,"Furzefield Primary School"]
[]
[null,null,"School LAEstab number:",null,null,null,null,9362954]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Answer",null,"Comments, evidence and proposed actions"]
[null,null,"A. Governance"]
[]
[null,null,1,"In the view of the governing body and senior staff, does the governing body have adequate financial skills among its members to fulfil its role of challenge and support in the field of budget management and value for money?",null,null,null,null,null,null,"Q1 guidance",null,"Yes",null,"We have a range of financial skills & experience amognst the GB, and this is audited regularly by the clerk. Governors have attended finance courses run by Stricty4S/Surrey. Two members of the admin team are trained to operate the finances on FMS: Finance Assistnat and School Business Manager (SBM). The SBM has extensive knowledge & experience in education finance and has the DSBM qualification (Diploma in School Business Management). She attends termly briefings by Surrey/Strictly4S and regular financial training and meetings. The Finance Assistant has the CSBM and has worked previously as a part time SBM in another Surrey school."]
[null,null,2,"Does the governing body have a finance committee (or equivalent) with clear terms of reference and a knowledgeable and experienced chair?",null,null,null,null,null,null,"Q2 guidance",null,"Yes",null,"Clear Terms of Reference in place. Chair of Finance & Staffing Committee has significant experience in this area."]
[null,null,3,"Does the governing body board receive clear and concise monitoring reports of the school's budget position at least six times a year?",null,null,null,null,null,null,"Q3 guidance",null,"Yes",null,"Monthly FMRS are uploaded to Governor hub and quarterly committee meetings review monitoring reports in more detail - every term the Finance & Staffing Committee receive up to date finance reports from the SBM (based on the most current FMR). The financial position is also reproted to the full GB (see minutes)."]
[null,null,4,"Are business interests of governing body members and staff properly registered and taken into account so as to avoid conflicts of interest?",null,null,null,null,null,null,"Q4 guidance",null,"Yes",null,"Governors complete annual Register of Pecuniary & Business Interests form. This item is on the agenda at he start of every meeting."]
[null,null,5,"Does the school have access to an adequate level of financial expertise, including when specialist finance staff are absent, e.g. on sick leave?",null,null,null,null,null,null,"Q5 guidance",null,"Yes",null,"The school has one Finance Assistant and an experienced SBM. They are supported by a Financial Consultant (Strictly4S Education) and other members of the finance helpdesk, plus Surrey County Council's funding team. 'Bursar support' can also be purchased on an ad hoc basis from Strictly 4S if necessary."]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ROUND(SUM(M16:M20),3)=100%,SUM(M16:M20)=0),\"\",\"Section must sum to 100%\")","v":""}]
[null,null,"B. School strategy"]
[]
[null,null,6,"Does the school have a realistic, sustainable and flexible financial strategy in place for at least the next 3 years, based on realistic assumptions about future funding, pupil numbers and pressures?",null,null,null,null,null,null,"Q6 guidance",null,"Yes",null,"Three year plans ar now part of the draft budget process with Surrey and are shared with Governors in the Autumn Term. These draft plans are based on the most current assumptions and known changes in pupil numbers and works needed etc. in future years. Projects and funding allocated link in with the SDP."]
[null,null,7,"Is the financial strategy integrated with the school’s strategy for raising standards and attainment?",null,null,null,null,null,null,"Q7 guidance",null,"Yes",null,"Budget priorities set according to SDP, focussed on raising standards and achievement. Statements are published annually on the school website re Pupil premium and Sports/PE Grant - they clearly show the impact in raising standards at school."]
[null,null,8,"Does the school have an appropriate business continuity or disaster recovery plan, including an up-to-date asset register and adequate insurance?",null,null,null,null,null,null,"Q8 guidance",null,"Yes",null,"The business continuity plan is within the school's Emergency Plan and this is reviewed annually by SEMT.  The Finance Assistant maintains an asset register for single items over £250 and anything 'pinchable', i.e. attractive portable items under £250 each such as cameras. Sweethaven Computers maintain an asset register of all IT equipment (over £100 per item) in school which has been purchased through their company, (i.e. pupil laptops, Smartboards, desktops). Insurance is paid annually through Surrey County Council for property, indemnity, public liability and minibus."]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ROUND(SUM(M21:M25),3)=100%,SUM(M21:M25)=0),\"\",\"Section must sum to 100%\")","v":""}]
[null,null,"C. Setting the annual budget"]
[]
[null,null,9,"Does the school set a well-informed and balanced budget each year (with an agreed and timed plan for eliminating any deficit)?",null,null,null,null,null,null,"Q9 guidance",null,"Yes",null,"The draft budget produced in November highlights any potential difficulties - this is checked by the school's Financial Consultant and shown to Finance & Staffing Committee members for discussion. Actual  funding figures are usually released at the end of February and the new budget plan must be finalised and approved by full GB by 1st May.  The school works towards eliminating in year deficits (excluding planned special projects) within 3 year plans. Detailed notes are available alongside the budget plans."]
[null,null,10,"Does the budget setting process allow sufficient time for the governing body to scrutinise and challenge the information provided?",null,null,null,null,null,null,"Q10 guidance",null,"Yes",null,"Finance & Staffing Committee discuss the draft budget in detail in November. The final budget plan is approved by the full GB in the Spring Term. (See minutes)."]
[null,null,11,"Is the governing body realistic in its pupil number projections and can it move quickly to recast the budget if the projections and the reality are materially different?",null,null,null,null,null,null,"Q11 guidance",null,"Yes",null,"Pupil numbers monitored weekly by Admissions Officer who liaises with the SBM, (for example if the nursery numbers are low). January census data will be checked and if the pupil numbers are vastly different to the draft budget produced the SBM would alert the GB. Governors informed of any changes in year  by the SBM at meetings and through the FMRs (monitoring reprots would show any variances to the original budget due to additonal funding and/or clawbacks)."]
[null,null,12,"Is end year outturn in line with budget projections, or if not, is the governing body alerted to significant variations in a timely manner, and do such variations result from explicitly planned changes or from genuinely unforeseeable circumstances?",null,null,null,null,null,null,"Q12 guidance",null,"Yes",null,"FMRS produced monthly by SBM (with notes), and details reported to Finance and Staffing Committee, where variances can be challenged/questioned. Any changes to the budget and in year forecast are discussed fully with governors - see minutes. Virements and additional expenditure over £10K are agreed at committee level as necessary."]
[null,null,13,"Are balances at a reasonable level and does the school have a clear plan for using the money it plans to hold in balance at the end of each year?",null,null,null,null,null,null,"Q13 guidance",null,"Yes",null,"Agreed as part of the budget setting process and used strategically where viable to improve teaching and learning and the school environment. Any balances to be used for special rpojects are 'earmarked'."]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ROUND(SUM(M28:M34),3)=100%,SUM(M28:M34)=0),\"\",\"Section must sum to 100%\")","v":""}]
[null,null,"D. Staffing"]
[]
[null,null,14,"Does the school review and challenge its staffing structure regularly to ensure it is the best structure to meet the needs of the school whilst maintaining financial integrity? ",null,null,null,null,null,null,"Q14 guidance",null,"Yes",null,"The Headteacher regularly reviews staffing and this is reported to governors. The intial staffing structure for the academic year is presented in the HT's Autumn Term report to the GB. Recent changes were made to the deployment of support staff due to financial restraints and additional hours claims have reduced significantly. As staff leave naturally the leadership team look at how best to replace or cover with existing staff etc. to maintain adequate support for pupils yet taking into account the financial position."]
[null,null,15,"Has the use of professional independent advice informed part of the pay decision process in relation to the head teacher and is it tightly correlated to strong educational outcomes and sound financial management?",null,null,null,null,null,null,"Q15 guidance",null,"Yes",null,"An independent consultant from Surrey forms part of the Headteacher's Pay Appraisal Panel. "]
[null,null,16,"Does the school benchmark the size of its senior leadership team annually against that of similar schools?",null,null,null,null,null,null,"Q16 guidance",null,"Yes",null,"This benchmarking is part of the gov.uk benchmarking on the workforce tab which is looked at regularly. Specific graphs highlight SLT data, showing Furzefield is 'average'."]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ROUND(SUM(M34:M39),3)=100%,SUM(M34:M39)=0),\"\",\"Section must sum to 100%\")","v":""}]
[null,null,"E. Value for money"]
[]
[null,null,17,"Does the school benchmark its income and expenditure annually against that of similar schools and investigate further where any category appears to be out of line?",null,null,null,null,null,null,"Q17 guidance",null,"Yes",null,"Surrey Comparative Expenditure Data Report shared with governors and reviewed. We have looked at areas where we are showing in the high percentile and discussed reasons why and whether we can make savings/changes (i.e. premises, buy backs). The RAG rating data on the new SFVS document should be useful going forward!"]
[null,null,18,"Does the school have procedures for purchasing goods and services that both meet legal requirements and secure value for money?",null,null,null,null,null,null,"Q18 guidance",null,"Yes",null,"See Financial Management and Administration Policy, follwoed by the school."]
[null,null,19,"Is the governing body given the opportunity to challenge the school’s plans for replacing contracts for goods and services that are due to expire shortly? ",null,null,null,null,null,null,"Q19 guidance",null,"Yes",null,"All contracts and buy backs are reviewed annually. However, expensive contarcts such as IT support, photocopiers and minibus would require at least three quotes/tenders. These are then compared, discussed and reviewed with the leadership team and summarised to the Finance Committee for approval."]
[null,null,20,"Does the School consider collaboration with others, e.g. on sharing staff or joint purchasing, where that would improve value for money?",null,null,null,null,null,null,"Q20 guidance",null,"Yes",null,"SBM liaises with other SBMs/Bursars and hs many contacts in Strictly4S and Surrey. Red Oak and school staff 'shared' to support wraparound services. Savings made through bulk school purchasing via Strictly4S (i.e. The Key). Staff encouraged to visit outstanding schools, attend CPD events and share best practice. Opportunties identified in the future to offer/share training on site, and also look at collaborating with other schools re the catering contract."]
[null,null,21,"Do you compare your non-staff expenditure against the DfE recommended national deals to ensure you are achieving best value?",null,null,null,null,null,null,"Q21 guidance",null,"No",null,"We always strive for best value ourselves and look for the best deals, however will have a look at the DfE recommended deals in future."]
[null,null,22,"Does the school maintain its premises and other assets to an adequate standard and make best use of capital monies for this purpose?",null,null,null,null,null,null,"Q22 guidance",null,"Yes",null,"Buildings Maintenance and Property buy back from SCC purchased annually. IT support provided by Sweethaven Computers Ltd, and premises regularly inspected (termly) with the findings fed back to the Health & Safety Committee. Capital monies are used for one-off projects (over £2K) which benefit the whole school - expenditure shown on the FMRs."]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ROUND(SUM(M45:M49),3)=100%,SUM(M45:M49)=0),\"\",\"Section must sum to 100%\")","v":""}]
[null,null,"F. Protecting public money "]
[]
[null,null,23,"Is the governing body sure that there are no outstanding matters from audit reports, internal audit reports or from previous consideration of weaknesses by the governing body?",null,null,null,null,null,null,"Q23 guidance",null,"Yes",null,"All recommendations addressed immediately."]
[null,null,24,"Are there adequate arrangements in place to manage conflicts of interest or any related party transactions?",null,null,null,null,null,null,"Q24 guidance",null,"Yes",null,"All staff and governors annually sign a confilct of interest declaration. If any 'conflicts' were highlighted systems would be put in place to guard against accusations of fraud or mispractice. Advice would eb taken as necessary."]
[null,null,25,"Are there adequate arrangements in place to guard against fraud and theft by staff, contractors and suppliers? (Please note any instance of fraud or theft detected in the last 12 months)",null,null,null,null,null,null,"Q25 guidance",null,"Yes",null,"Segregation of duties avoids any fraudulent activities, use off confidential passwords & various authorised signatories as per policies. Electronic fobs required to enter site and buildings. Visitors required to sign in/out at reception (ID checked), monies stored in safe and collected fortnightly for banking."]
[null,null,26,"Are all staff aware of the school’s whistleblowing arrangements and to whom they should report concerns?",null,null,null,null,null,null,"Q26 guidance",null,"Yes",null,"Copy kept in staffroom highlighting Expolink Europe's Freephone number to report concerns. Staff can access the policy through Staffzone and this information is all writen in the staff handbook (for existing and new staff)."]
[null,null,27,"Does the school have an accounting system that is adequate and properly run and delivers accurate reports, including the annual Consistent Financial Reporting return?",null,null,null,null,null,null,"Q27 guidance",null,"Yes",null,"SIMS, FMS (supported by Capita and Strictly4S). Monthly reports produced and year end reports delivered (including CFR) - signed by SBM and Headteacher."]
[null,null,28,"Does the school have adequate arrangements for audit of voluntary funds?",null,null,null,null,null,null,"Q28 guidance",null,"Yes",null,"School Fund is annually examined by an independent professional - reported back to Finance & Staffing Committee. Agreed accounts and year end report uploaded to the Charity Commission website as required."]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ROUND(SUM(M54:M57),3)=100%,SUM(M54:M57)=0),\"\",\"Section must sum to 100%\")","v":""}]
[null,null,"G. SFVS dashboard"]
[]
[null,null,29,"Have the results of the dashboard been carefully considered and potential follow-up actions identified?",null,null,null,null,null,null,"Q29 guidance",null,"Yes",null,"Finance Committee meeting 09/03/2020 - see minutes"]

{"sheet":"Dashboard","index":2,"n_rows":65,"n_cols":9,"rows_kept":65,"cut":false,"hidden":false,"merged":[[30,2,30,3],[56,2,56,3],[57,2,57,3],[58,2,58,3],[59,2,59,3],[35,2,35,3],[64,2,70,8],[14,5,14,8],[16,5,18,8],[22,2,22,3],[23,2,23,3],[41,2,41,3],[42,2,42,3],[46,2,46,3],[47,2,47,3],[48,2,48,3],[49,2,49,3],[50,2,50,3],[51,2,51,3],[52,2,52,3],[29,2,29,3],[54,2,54,4],[62,2,62,4],[25,6,26,6],[25,8,26,8],[4,2,4,8],[12,2,12,4],[21,2,21,4],[36,2,36,3],[37,2,37,3],[27,2,27,4],[39,2,39,4],[44,2,44,4],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[60,2,60,3],[2,2,2,8],[6,2,6,8],[7,2,7,8],[8,2,8,8],[10,2,10,8]]}
[]
[]
[null,null,"Schools financial value standard - dashboard"]
[]
[null,null,"Effective resource management is about how a school uses its resources to drive outcomes for its pupils. A school can improve outcomes by using its resources more effectively.\n \nThe dashboard below is designed to help schools identify areas for improved resource management. It shows how a school compares to thresholds on a range of key indicators. \n\nThe completion of this assessment forms part of the annual schools financial value standard."]
[]
[null,null,"\nUsing the dashboard\n\nSchools should use the most up to date data available to them, and not rely on lagged published data.\n \nComplete all highlighted cells."]
[null,null,"Guidance on calculating or collecting the data for the school so that metrics are compared to thresholds consistently can be found here. Clicking on the link next to individual indicators below will also take you to the relevant section of the guidance."]
[null,null,"Either input the school's percentages and ratios directly, or complete the Optional - input raw data form with spending information and school characteristics. The percentages and ratios in the dashboard will then auto-calculate."]
[]
[null,null,"Using the results from the dashboard\n\nClick here for explanations of what the red, amber and green (RAG) ratings mean and what do with the results."]
[]
[null,null,"A. Information about your school"]
["*",null,null,null,null,null,1]
[null,null,"School name:","Furzefield Primary School",null,"Click here to see the RAG rating data for this school"]
[null,null,"School LAEstab number:",9362954]
[null,null,"Phase:","Primary",null,"Input the school's percentages and ratios directly below, or\nclick here to input raw spending and characteristics data for your school"]
[null,null,"Region:","South East"]
[null,null,"Number of pupils:",459]
[null,null,"% of pupils eligible for FSM:",0.1983]
[]
[null,null,"This school is being compared to other:"]
[null,null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\"),\"\",\n\"- \"&Calcs!$J29&\nIF(D17=\"Primary\",\" primary schools with \",IF(D17=\"Secondary with sixth form\",\" secondary schools with a sixth form with \",IF(D17=\"Secondary without sixth form\",\" secondary schools without a sixth form with \",IF(D17=\"Special\",\"special schools\",IF(D17=\"Alternative provision\",\"alternative provision schools\",IF(D17=\"All-through\",\"all-through schools\",IF(D17=\"Nursery\",\"nursery schools\",\"\")))))))&Calcs!$K29)","v":"- large primary schools with high levels of FSM"}]
[null,null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\"),\"\",\nIF(D17=\"Primary\",\"- primary schools \",IF(D17=\"Secondary with sixth form\",\"- secondary schools with a sixth form \",IF(D17=\"Secondary without sixth form\",\"- secondary schools without a sixth form \",IF(D17=\"Special\",\"- special schools \",IF(D17=\"Alternative provision\",\"- alternative provision schools \",IF(D17=\"All-through\",\"- all-through schools \",IF(D17=\"Nursery\",\"- nursery schools \",\"\")))))))&Calcs!$I29&\" (for average teacher cost only)\")","v":"- primary schools outside London (for average teacher cost only)"}]
[]
[null,null,null,null,null,null,"The school's\ndata",null,"Rating against\nthresholds"]
[]
[null,null,"B. Spending as a percentage of total expenditure"]
[]
[null,null,"Spend on teaching staff as a percentage of total expenditure",null,"Guidance",null,{"$f":"IFERROR('Optional - input raw data'!F24/'Optional - input raw data'!F13,Calcs!$A$66)","v":0.49383983128439302},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G30=\"\"),\"\",\nIF(G30<=Calcs!C9,Lowest10,\nIF(AND(G30>Calcs!C9,G30<=Calcs!D9),Lowest20,\nIF(AND(G30>Calcs!D9,G30<=Calcs!E9),Inline,\nIF(AND(G30>Calcs!E9,G30<=Calcs!G9),Middle20,\nIF(AND(G30>Calcs!G9,G30<=Calcs!H9),Inline,\nIF(AND(G30>Calcs!H9,G30<=Calcs!I9),Highest20,\nIF(G30>Calcs!I9,Highest10,\"\"))))))))","v":"Highest 10% of similar schools"}]
[null,null,"Spend on supply staff as a percentage of total expenditure",null,"Guidance",null,{"$f":"IFERROR(('Optional - input raw data'!F25+'Optional - input raw data'!F33+'Optional - input raw data'!F49)/'Optional - input raw data'!F13,Calcs!$A$66)","v":6.7034583669131551E-3},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G31=\"\"),\"\",\nIF(G31<=Calcs!E10,Inline,\nIF(AND(G31>Calcs!E10,G31<=Calcs!G10),Middle20,\nIF(AND(G31>Calcs!G10,G31<=Calcs!H10),Inline,\nIF(AND(G31>Calcs!H10,G31<=Calcs!I10),Highest20,\nIF(G31>Calcs!I10,Highest10,\"\"))))))","v":"Broadly in line with similar schools"}]
[null,null,"Spend on education support staff as a percentage of total expenditure",null,"Guidance",null,{"$f":"IFERROR('Optional - input raw data'!F26/'Optional - input raw data'!F13,Calcs!$A$66)","v":0.23134759643030561},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G32=\"\"),\"\",\nIF(G32<=Calcs!E11,Inline,\nIF(AND(G32>Calcs!E11,G32<=Calcs!G11),Middle20,\nIF(AND(G32>Calcs!G11,G32<=Calcs!H11),Inline,\nIF(AND(G32>Calcs!H11,G32<=Calcs!I11),Highest20,\nIF(G32>Calcs!I11,Highest10,\"\"))))))","v":"Broadly in line with similar schools"}]
[null,null,"Spend on administrative and clerical staff as a percentage of total expenditure",null,"Guidance",null,{"$f":"IFERROR('Optional - input raw data'!F28/'Optional - input raw data'!F13,Calcs!$A$66)","v":5.6749237554662657E-2},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G33=\"\"),\"\",\nIF(G33<=Calcs!H12,Inline,\nIF(AND(G33>Calcs!H12,G33<=Calcs!I12),Highest20,\nIF(G33>Calcs!I12,Highest10,\"\"))))","v":"Broadly in line with similar schools"}]
[null,null,"Spend on other staff costs as a percentage of total expenditure",null,"Guidance",null,{"$f":"IFERROR(SUM('Optional - input raw data'!F30,'Optional - input raw data'!F31,'Optional - input raw data'!F32,'Optional - input raw data'!F34)/'Optional - input raw data'!F13,Calcs!$A$66)","v":1.8311675099801514E-2},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G34=\"\"),\"\",\nIF(G34<=Calcs!H13,Inline,\nIF(AND(G34>Calcs!H13,G34<=Calcs!I13),Highest20,\nIF(G34>Calcs!I13,Highest10,\"\"))))","v":"Broadly in line with similar schools"}]
[null,null,"Spend on premises (including staff costs) as a percentage of total expenditure",null,"Guidance",null,{"$f":"IFERROR(SUM('Optional - input raw data'!F27,'Optional - input raw data'!F35,'Optional - input raw data'!F36,'Optional - input raw data'!F37)/'Optional - input raw data'!F13,Calcs!$A$66)","v":6.496459959264099E-2},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G35=\"\"),\"\",\nIF(G35<=Calcs!H14,Inline,\nIF(AND(G35>Calcs!H14,G35<=Calcs!I14),Highest20,\nIF(G35>Calcs!I14,Highest10,\"\"))))","v":"Broadly in line with similar schools"}]
[null,null,"Spend on teaching resources as a percentage of total expenditure",null,"Guidance",null,{"$f":"IFERROR(SUM('Optional - input raw data'!F42,'Optional - input raw data'!F43,'Optional - input raw data'!F44)/'Optional - input raw data'!F13,Calcs!$A$66)","v":3.3494925328336707E-2},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G36=\"\"),\"\",\nIF(G36<=Calcs!C15,Lowest10,\nIF(AND(G36>Calcs!C15,G36<=Calcs!D15),Lowest20,\nIF(AND(G36>Calcs!D15,G36<=Calcs!E15),Inline,\nIF(AND(G36>Calcs!E15,G36<=Calcs!G15),Middle20,\nIF(G36>Calcs!G15,Inline,\"\"))))))","v":"Broadly in line with similar schools"}]
[null,null,"Spend on energy as a percentage of total expenditure",null,"Guidance",null,{"$f":"IFERROR('Optional - input raw data'!F39/'Optional - input raw data'!F13,Calcs!$A$66)","v":1.0101002813129284E-2},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G37=\"\"),\"\",\nIF(G37<=Calcs!H16,Inline,\nIF(AND(G37>Calcs!H16,G37<=Calcs!I16),Highest20,\nIF(G37>Calcs!I16,Highest10,\"\"))))","v":"Broadly in line with similar schools"}]
[null,null,"Other spending as a percentage of total expenditure (balancing line)",null,"Guidance",null,{"$f":"IFERROR(SUM('Optional - input raw data'!F29,'Optional - input raw data'!F38,'Optional - input raw data'!F40,'Optional - input raw data'!F41,'Optional - input raw data'!F45,'Optional - input raw data'!F46,'Optional - input raw data'!F47,'Optional - input raw data'!F48,'Optional - input raw data'!F50,'Optional - input raw data'!F51,'Optional - input raw data'!F52,'Optional - input raw data'!F53,'Optional - input raw data'!F54,'Optional - input raw data'!F55)/'Optional - input raw data'!F13,Calcs!$A$66)","v":8.4487673529817078E-2},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G38=\"\"),\"\",\"N/A\")","v":"N/A"}]
[null,null,null,null,null,null,{"$f":"IF(OR(ROUND(SUM(G30:G38),3)=100%,SUM(G30:G38)=0),\"\",\"Section must sum to 100%\")","v":""}]
[null,null,"C. Reserves / balances as a percentage of total income"]
[]
[null,null,"In-year balance as a percentage of total income",null,"Guidance",null,{"$f":"IFERROR(('Optional - input raw data'!F14-'Optional - input raw data'!F13)/'Optional - input raw data'!F14,Calcs!$A$66)","v":-8.100723907752555E-2},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G42=\"\"),\"\",\nIF(G42<=-0.05,High,\nIF(AND(G42>-0.05,G42<0),Medium,\nIF(G42>=0,Low,\"\"))))","v":"High risk"}]
[null,null,"Revenue reserve as a percentage of total income",null,"Guidance",null,{"$f":"IFERROR('Optional - input raw data'!F15/'Optional - input raw data'!F14,Calcs!$A$66)","v":5.6737630139021646E-2},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G43=\"\"),\"\",\nIF(G43<=-0.05,High,\nIF(AND(G43>-0.05,G43<0),Medium,\nIF(G43>=0,Low,\"\"))))","v":"Low risk"}]
[]
[null,null,"D. School characteristics"]
[]
[null,null,"Average teacher cost (£)",null,"Guidance",null,{"$f":"IFERROR('Optional - input raw data'!F24/'Optional - input raw data'!F9,Calcs!$A$66)","v":54387.167262614217},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G47=\"\"),\"\",\nIF(G47<=Calcs!C21,Lowest10,\nIF(AND(G47>Calcs!C21,G47<=Calcs!D21),Lowest20,\nIF(AND(G47>Calcs!D21,G47<=Calcs!E21),Inline,\nIF(AND(G47>Calcs!E21,G47<=Calcs!G21),Middle20,\nIF(AND(G47>Calcs!G21,G47<=Calcs!H21),Inline,\nIF(AND(G47>Calcs!H21,G47<=Calcs!I21),Highest20,\nIF(G47>Calcs!I21,Highest10,\"\"))))))))","v":"Broadly in line with similar schools"}]
[null,null,"Senior leaders as a percentage of workforce",null,"Guidance",null,{"$f":"IFERROR('Optional - input raw data'!F10/'Optional - input raw data'!F11,Calcs!$A$66)","v":4.6482801363495502E-2},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G48=\"\"),\"\",\nIF(G48<=Calcs!E17,Inline,\nIF(AND(G48>Calcs!E17,G48<=Calcs!G17),Middle20,\nIF(AND(G48>Calcs!G17,G48<=Calcs!H17),Inline,\nIF(AND(G48>Calcs!H17,G48<=Calcs!I17),Highest20,\nIF(G48>Calcs!I17,Highest10,\"\"))))))","v":"Broadly in line with similar schools"}]
[null,null,"Pupil to teacher ratio",null,"Guidance",null,{"$f":"IFERROR(D19/'Optional - input raw data'!F9,Calcs!$A$66)","v":18.235995232419548},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G49=\"\"),\"\",\nIF(G49<=Calcs!C18,Lowest10,\nIF(AND(G49>Calcs!C18,G49<=Calcs!D18),Lowest20,\nIF(AND(G49>Calcs!D18,G49<=Calcs!E18),Inline,\nIF(AND(G49>Calcs!E18,G49<=Calcs!G18),Middle20,\nIF(AND(G49>Calcs!G18,G49<=Calcs!H18),Inline,\nIF(AND(G49>Calcs!H18,G49<=Calcs!I18),Highest20,\nIF(G49>Calcs!I18,Highest10,\"\"))))))))","v":"Broadly in line with similar schools"}]
[null,null,"Pupil to adult ratio",null,"Guidance",null,{"$f":"IFERROR(D19/'Optional - input raw data'!F11,Calcs!$A$66)","v":7.1118686086148122},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G50=\"\"),\"\",\nIF(G50<=Calcs!C19,Lowest10,\nIF(AND(G50>Calcs!C19,G50<=Calcs!D19),Lowest20,\nIF(AND(G50>Calcs!D19,G50<=Calcs!E19),Inline,\nIF(AND(G50>Calcs!E19,G50<=Calcs!G19),Middle20,\nIF(AND(G50>Calcs!G19,G50<=Calcs!H19),Inline,\nIF(AND(G50>Calcs!H19,G50<=Calcs!I19),Highest20,\nIF(G50>Calcs!I19,Highest10,\"\"))))))))","v":"Lowest 20% of similar schools"}]
[null,null,"Teacher contact ratio (less than 1.0)",null,"Guidance",null,{"$f":"IFERROR(IF(D17=Calcs!$A$62,('Optional - input raw data'!F22/'Optional - input raw data'!F9),IF(OR(D17=Calcs!$A$63,D17=Calcs!$A$64,D17=Calcs!$A$65),('Optional - input raw data'!F19/('Optional - input raw data'!F18*'Optional - input raw data'!F9)),Calcs!$A$66)),Calcs!$A$66)","v":0.71513706793802145},null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G51=\"\"),\"\",\nIF(G51<=0.7,Muchlower,\nIF(AND(G51>0.7,G51<=0.74),Lower,\nIF(AND(G51>0.74,G51<=0.8),Inline2,\nIF(AND(G51>0.8,G51<=0.82),Higher,\nIF(G51>0.82,Muchhigher,\"\"))))))","v":"Lower than recommended"}]
[null,null,"Predicted percentage pupil number change in 3-5 years",null,"Guidance",null,-0.05,null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G52=\"\"),\"\",\nIF(G52<=-0.1,High,\nIF(AND(G52>-0.1,G52<=-0.02),Medium,\nIF(G52>=-0.02,Low,\"\"))))","v":"Medium risk"}]
[null,null,"Average class size",null,"Guidance",null,29.47,null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G53=\"\"),\"\",\nIF(G53<=Calcs!C20,Lowest10,\nIF(AND(G53>Calcs!C20,G53<=Calcs!D20),Lowest20,\nIF(AND(G53>Calcs!D20,G53<=Calcs!E20),Inline,\nIF(AND(G53>Calcs!E20,G53<=Calcs!G20),Middle20,\nIF(AND(G53>Calcs!G20,G53<=Calcs!H20),Inline,\nIF(AND(G53>Calcs!H20,G53<=Calcs!I20),Highest20,\nIF(G53>Calcs!I20,Highest10,\"\"))))))))","v":"Highest 20% of similar schools"}]
[]
[null,null,"E. Outcomes"]
[]
[null,null,"Ofsted rating",null,"Guidance",null,"Good",null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G57=\"\"),\"\",INDIRECT(G57))","v":"Good"}]
[null,null,"Progress 8 score",null,"Guidance",null,null,null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G58=\"\"),\"\",\nIF(G58>=0.5,Wellabove,\nIF(AND(G58>=0,G58<0.5),Average,\nIF(AND(G58>=-0.5,G58<0),Below,\nIF(G58<-0.5,Wellbelow,\"\")))))","v":""}]
[null,null,"Progress score in reading",null,"Guidance",null,0.6,null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G59=\"\"),\"\",\nIF(G59>=3.1,Wellabove,\nIF(AND(G59>=0,G59<3.1),Average,\nIF(AND(G59>=-2.8,G59<0),Below,\nIF(G59<-2.8,Wellbelow,\"\")))))","v":"Average or above average"}]
[null,null,"Progress score in writing",null,"Guidance",null,-0.2,null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G60=\"\"),\"\",\nIF(G60>=2.7,Wellabove,\nIF(AND(G60>=0,G60<2.7),Average,\nIF(AND(G60>=-2.6,G60<0),Below,\nIF(G60<-2.6,Wellbelow,\"\")))))","v":"Below average"}]
[null,null,"Progress score in maths",null,"Guidance",null,1.6,null,{"$f":"IF(OR(D$17=\"\",D$18=\"\",D$19=\"\",D$20=\"\",G61=\"\"),\"\",\nIF(G61>=3.2,Wellabove,\nIF(AND(G61>=0,G61<3.2),Average,\nIF(AND(G61>=-3.2,G61<0),Below,\nIF(G61<-3.2,Wellbelow,\"\")))))","v":"Average or above average"}]
[]
[null,null,"F: Optional commentary"]
[]
[null,null,"Used Period 8 November FMR outturn figures. Used today's (15/1/20) pupil numbers - total 459 - and staff FTEs as per budget planning. (See totals added to the optional input raw data sheet). Please note teaching staff also includes the leadership staff plus Ocean SRC and Nursery teachers. We have stated 17 classes: 15 R-Y6 plus 1 for Ocean and 1 for Nursery."]

{"sheet":"Optional - input raw data","index":3,"n_rows":55,"n_cols":6,"rows_kept":55,"cut":false,"hidden":false,"merged":[[2,2,2,3],[4,2,4,5],[5,2,5,5],[21,2,21,3],[18,2,18,3],[17,2,17,3],[14,2,14,3],[13,2,13,3],[20,2,20,3],[16,2,16,3],[12,2,12,3],[10,2,10,3],[8,2,8,3],[9,2,9,3]]}
[]
[]
[null,null,"Raw data form"]
[null,null,null,null,null,1]
[null,null,"This form can be used to input raw spend and characteristics information. If used, the information in this table will be used to calculate the percentages and ratios required in the dashboard. Alternatively, \nclick here to input the percentages and ratios directly into the dashboard."]
[null,null,"Schools should use the most up to date information available to them, and not rely on lagged published data.\n\nAll of the data should refer to the same financial year."]
[]
[]
[null,null,"Full time equivalent number of teachers (classroom and leadership)",null,null,25.17]
[null,null,"Full time equivalent of teachers in the leadership group",null,null,3]
[null,null,"Full time equivalent of total school workforce",null,null,64.540000000000006]
[]
[null,null,"Total expenditure",null,null,2772002]
[null,null,"Total income",null,null,2564277]
[null,null,"Revenue balances (committed and uncommitted)",null,null,145491]
[]
[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"]
[null,null,null,{"$f":"IFERROR(IF((F19/(F18*F9))<0.5,\"Resulting teacher contact ratio is low. Total lessons taught may be incorrectly calculated as too low\",IF((F19/(F18*F9))>1,\"Resulting teacher contact ratio is greater than 1. Total lessons taught is too high\",\"\")),\"\")","v":""}]
[null,null,"For primary schools:"]
[null,null,"Total number of classes",null,null,18]
[]
[null,null,"E01","Teaching staff",null,1368925]
[null,null,"E02","Supply teaching staff"]
[null,null,"E03","Education support staff",null,641296]
[null,null,"E04","Premises staff",null,80032]
[null,null,"E05","Administrative and clerical staff",null,157309]
[null,null,"E06","Catering staff"]
[null,null,"E07","Cost of other staff",null,21021]
[null,null,"E08","Indirect employee expenses",null,14000]
[null,null,"E09","Staff development and training",null,9000]
[null,null,"E10","Supply teacher insurance",null,18582]
[null,null,"E11","Staff-related insurance",null,6739]
[null,null,"E12","Building maintenance and improvement",null,42000]
[null,null,"E13","Grounds maintenance and improvement",null,11300]
[null,null,"E14","Cleaning and caretaking",null,46750]
[null,null,"E15","Water and sewerage",null,9000]
[null,null,"E16","Energy",null,28000]
[null,null,"E17","Rates",null,46073]
[null,null,"E18","Other occupation costs",null,867]
[null,null,"E19","Teaching resources",null,73848]
[null,null,"E20","ICT teaching resources",null,19000]
[null,null,"E21","Examination fees"]
[null,null,"E22","Administrative supplies",null,42003]
[null,null,"E23","Other insurance premiums",null,11642]
[null,null,"E24","Special facilities",null,9900]
[null,null,"E25","Catering supplies",null,76760]
[null,null,"E26","Agency supply teaching staff"]
[null,null,"E27","Bought-in professional services - curriculum",null,3867]
[null,null,"E28","Bought-in professional services - other",null,34088]
[null,null,"E29","Loan interest"]
[null,null,"E30","Direct revenue financing"]
[null,null,"E31","Community-focused school staff"]
[null,null,"E32","Community-focused school costs"]

{"sheet":"RAG rating data for your school","index":4,"n_rows":94,"n_cols":20,"rows_kept":94,"cut":false,"hidden":false,"merged":[[1,7,9,19],[84,1,85,1],[87,1,88,1],[90,1,91,1],[93,1,94,1],[70,1,71,1],[73,1,74,1],[81,1,82,1],[79,3,79,4],[79,6,79,9],[79,11,79,14],[79,16,79,19],[55,1,56,1],[58,1,59,1],[61,1,62,1],[67,1,68,1],[64,1,65,1],[42,16,42,19],[44,1,45,1],[47,1,48,1],[53,3,53,4],[53,6,53,9],[53,11,53,14],[53,16,53,19],[33,1,34,1],[36,1,37,1],[42,3,42,4],[42,6,42,9],[42,11,42,14],[24,1,25,1],[27,1,28,1],[15,1,16,1],[13,3,13,4],[30,1,31,1],[13,6,13,9],[13,11,13,14],[13,16,13,19],[18,1,19,1],[21,1,22,1]]}
[]
[null,"Your school has been identified as:",null,null,null,null,null,"The RAG ratings have been calculated using maintained school and academy 2017 to 18 data.\n\nThe majority of metrics in the dashboard are percentages and ratios which at a national level don't change significantly year on year, so they still provide a fair and useful comparison with your up to date data.\n\nThe exception is average teacher cost, which does change year on year. To reflect the latest pay awards (from September 2018 and September 2019) and pensions contribution changes we have uplifted the underlying data by 11.2%. The thresholds therefore reflect average teacher costs for the academic year 2019/20."]
[null,{"$f":"IF(Dashboard!D15=\"\",\"\",\"- \"&\nINDEX(Calcs!L:L,MATCH(Dashboard!D15,Calcs!A:A,0)))","v":"- a primary school"}]
[null,{"$f":"IF(Dashboard!D15=\"\",\"\",\"- \"&\nINDEX(Calcs!I:I,MATCH(Dashboard!D15,Calcs!A:A,0)))","v":"- outside London"}]
[null,{"$f":"IF(Dashboard!D15=\"\",\"\",\nIF(OR($B$3=\"- an alternative provision school\",$B$3=\"- a special school\",$B$3=\"- an all-through school\",$B$3=\"- a nursery school\"),\"\",\n\"- a \"&INDEX(Calcs!J:J,MATCH(Dashboard!D15,Calcs!A:A,0))&\" school because it has \"&INDEX(Calcs!M:M,MATCH(Dashboard!D15,Calcs!A:A,0))))","v":"- a large school because it has more than 385 pupils"}]
[null,{"$f":"IF(Dashboard!D15=\"\",\"\",\nIF(OR($B$3=\"- an alternative provision school\",$B$3=\"- a special school\",$B$3=\"- an all-through school\",$B$3=\"- a nursery school\"),\"\",\n\"- a school with \"&INDEX(Calcs!K:K,MATCH(Dashboard!D15,Calcs!A:A,0))&\" because \"&INDEX(Calcs!N:N,MATCH(Dashboard!D15,Calcs!A:A,0))&\" are eligible\"))","v":"- a school with high levels of FSM because more than 18% of pupils are eligible"}]
[]
[]
[]
[null,"The thresholds for the RAG ratings are based on these characteristics and are:"]
[]
[null,"B. Your spending as a percentage of expenditure"]
[]
[null,null,null,"Red rating",null,null,"Amber rating",null,null,null,null,"Light green rating",null,null,null,null,"Dark green rating"]
[]
[null,"Spend on teaching staff as a percentage of total expenditure",null,"Less than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),1,1))","v":0.35499999999999998},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),1,1))","v":0.35499999999999998},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),1,2))","v":0.38},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),1,2))","v":0.38},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),1,3))","v":0.41},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),1,3))","v":0.41},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),1,5))","v":0.435}]
[null,null,null,"Or more than ",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),1,7))","v":0.49},null,"Or between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),1,6))","v":0.46500000000000002},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),1,7))","v":0.49},null,"Or between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),1,5))","v":0.435},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),1,6))","v":0.46500000000000002}]
[]
[null,"Spend on supply staff as a percentage of total expenditure",null,"More than",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),2,7))","v":0.06},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),2,6))","v":4.4999999999999998E-2},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),2,7))","v":0.06},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),2,5))","v":0.03},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),2,6))","v":4.4999999999999998E-2},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),2,3))","v":0.02},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),2,5))","v":0.03}]
[null,null,null,null,null,null,null,null,null,null,null,"Or less than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),2,3))","v":0.02}]
[]
[null,"Spend on education support staff as a percentage of total expenditure",null,"More than",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),3,7))","v":0.26500000000000001},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),3,6))","v":0.25},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),3,7))","v":0.26500000000000001},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),3,5))","v":0.22},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),3,6))","v":0.25},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),3,3))","v":0.19500000000000001},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),3,5))","v":0.22}]
[null,null,null,null,null,null,null,null,null,null,null,"Or less than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),3,3))","v":0.19500000000000001}]
[]
[null,"Spend on administrative and clerical staff as a percentage of total expenditure",null,"More than",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),4,7))","v":7.4999999999999997E-2},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),4,6))","v":0.06},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),4,7))","v":7.4999999999999997E-2},null,"Less than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),4,6))","v":0.06}]
[]
[]
[null,"Spend on other staff costs as a percentage of total expenditure",null,"More than",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),5,7))","v":0.06},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),5,6))","v":4.4999999999999998E-2},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),5,7))","v":0.06},null,"Less than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),5,6))","v":4.4999999999999998E-2}]
[]
[]
[null,"Spend on premises (including staff costs) as a percentage of total expenditure",null,"More than",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),6,7))","v":0.08},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),6,6))","v":7.0000000000000007E-2},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),6,7))","v":0.08},null,"Less than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),6,6))","v":7.0000000000000007E-2}]
[]
[]
[null,"Spend on teaching resources as a percentage of total expenditure",null,"Less than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),7,1))","v":2.5000000000000001E-2},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),7,1))","v":2.5000000000000001E-2},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),7,2))","v":0.03},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),7,2))","v":0.03},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),7,3))","v":0.04},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),7,3))","v":0.04},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),7,5))","v":0.05}]
[null,null,null,null,null,null,null,null,null,null,null,"Or more than",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),7,5))","v":0.05}]
[]
[null,"Spend on energy as a percentage of total expenditure",null,"More than",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),8,7))","v":0.02},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),8,6))","v":1.4999999999999999E-2},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),8,7))","v":0.02},null,"Less than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),8,6))","v":1.4999999999999999E-2}]
[]
[]
[]
[null,"C. Reserves / balances as a percentage of total income"]
[]
[null,null,null,"Red rating",null,null,"Amber rating",null,null,null,null,"Light green rating",null,null,null,null,"Dark green rating"]
[]
[null,"In-year balance as a percentage of total income",null,"Less than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",-0.05)","v":-0.05},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",-0.05)","v":-0.05},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",0)","v":0},null,"More than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",0)","v":0}]
[]
[]
[null,"Revenue reserve as a percentage of total income",null,"Less than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",-0.05)","v":-0.05},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",-0.05)","v":-0.05},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",0)","v":0},null,"More than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",0)","v":0}]
[]
[]
[]
[null,"D. School characteristics"]
[]
[null,null,null,"Red rating",null,null,"Amber rating",null,null,null,null,"Light green rating",null,null,null,null,"Dark green rating"]
[]
[null,"Average teacher cost (£)",null,"Less than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),13,1))","v":44000},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),13,1))","v":44000},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),13,2))","v":47000},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),13,2))","v":47000},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),13,3))","v":50000},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),13,3))","v":50000},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),13,5))","v":53000}]
[null,null,null,"Or more than ",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),13,7))","v":60000},null,"Or between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),13,6))","v":56500},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),13,7))","v":60000},null,"Or between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),13,5))","v":53000},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),13,6))","v":56500}]
[]
[null,"Senior leaders as a percentage of workforce",null,"More than",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),9,7))","v":0.105},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),9,6))","v":0.09},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),9,7))","v":0.105},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),9,5))","v":7.4999999999999997E-2},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),9,6))","v":0.09},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),9,3))","v":6.5000000000000002E-2},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),9,5))","v":7.4999999999999997E-2}]
[null,null,null,null,null,null,null,null,null,null,null,"Or less than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),9,3))","v":6.5000000000000002E-2}]
[]
[null,"Pupil to teacher ratio",null,"Less than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),10,1))","v":17},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),10,1))","v":17},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),10,2))","v":18},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),10,2))","v":18},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),10,3))","v":20},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),10,3))","v":20},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),10,5))","v":21}]
[null,null,null,"Or more than ",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),10,7))","v":24.5},null,"Or between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),10,6))","v":23},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),10,7))","v":24.5},null,"Or between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),10,5))","v":21},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),10,6))","v":23}]
[]
[null,"Pupil to adult ratio",null,"Less than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),11,1))","v":7},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),11,1))","v":7},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),11,2))","v":7.5},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),11,2))","v":7.5},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),11,3))","v":8},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),11,3))","v":8},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),11,5))","v":9}]
[null,null,null,"Or more than ",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),11,7))","v":10.5},null,"Or between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),11,6))","v":9.5},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),11,7))","v":10.5},null,"Or between",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),11,5))","v":9},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),11,6))","v":9.5}]
[]
[null,{"$f":"IF(OR($B$3=\"- an alternative provision school\",$B$3=\"- a special school\",$B$3=\"- a nursery school\"),\"\",\"Teacher contact ratio (less than 1.0)\")","v":"Teacher contact ratio (less than 1.0)"},null,{"$f":"IF(B68=\"\",\"\",\"Less than or equal to\")","v":"Less than or equal to"},{"$f":"IF(OR($B$3=\"- an alternative provision school\",$B$3=\"- a special school\",$B$3=\"- a nursery school\",Dashboard!D15=\"\"),\"\",0.7)","v":0.7},null,{"$f":"IF(B68=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(OR($B$3=\"- an alternative provision school\",$B$3=\"- a special school\",$B$3=\"- a nursery school\",Dashboard!D15=\"\"),\"\",0.7)","v":0.7},{"$f":"IF(B68=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(OR($B$3=\"- an alternative provision school\",$B$3=\"- a special school\",$B$3=\"- a nursery school\",Dashboard!D15=\"\"),\"\",0.74)","v":0.74},null,{"$f":"IF(B68=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(OR($B$3=\"- an alternative provision school\",$B$3=\"- a special school\",$B$3=\"- a nursery school\",Dashboard!D15=\"\"),\"\",0.4)","v":0.4},{"$f":"IF(G68=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(OR($B$3=\"- an alternative provision school\",$B$3=\"- a special school\",$B$3=\"- a nursery school\",Dashboard!D15=\"\"),\"\",0.8)","v":0.8}]
[null,null,null,{"$f":"IF(B68=\"\",\"\",\"Or more than\")","v":"Or more than"},{"$f":"IF(OR($B$3=\"- an alternative provision school\",$B$3=\"- a special school\",$B$3=\"- a nursery school\",Dashboard!D15=\"\"),\"\",0.82)","v":0.82},null,{"$f":"IF(B68=\"\",\"\",\"Or between\")","v":"Or between"},{"$f":"IF(OR($B$3=\"- an alternative provision school\",$B$3=\"- a special school\",$B$3=\"- a nursery school\",Dashboard!D15=\"\"),\"\",0.8)","v":0.8},{"$f":"IF(B69=\"\",\"\",\"and\")","v":""},{"$f":"IF(OR($B$3=\"- an alternative provision school\",$B$3=\"- a special school\",$B$3=\"- a nursery school\",Dashboard!D15=\"\"),\"\",0.82)","v":0.82}]
[]
[null,"Predicted percentage pupil number change in 3-5 years",null,"Less than or equal to",{"$f":"IF(Dashboard!D15=\"\",\"\",-0.1)","v":-0.1},null,"Between",{"$f":"IF(Dashboard!D15=\"\",\"\",-0.1)","v":-0.1},"and",{"$f":"IF(Dashboard!D15=\"\",\"\",-0.02)","v":-0.02},null,"More than",{"$f":"IF(Dashboard!D15=\"\",\"\",-0.02)","v":-0.02}]
[]
[]
[null,{"$f":"IF(OR($B$3=\"- an alternative provision school\",$B$3=\"- a special school\",$B$3=\"- a nursery school\"),\"\",\"Average class size\")","v":"Average class size"},null,{"$f":"IF(B74=\"\",\"\",\"Less than or equal to\")","v":"Less than or equal to"},{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),12,1))","v":24.5},null,{"$f":"IF(B74=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),12,1))","v":24.5},{"$f":"IF(B74=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),12,2))","v":25.5},null,{"$f":"IF(B74=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),12,2))","v":25.5},{"$f":"IF(B74=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),12,3))","v":27},null,{"$f":"IF(B74=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),12,3))","v":27},{"$f":"IF(B74=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),12,5))","v":28}]
[null,null,null,{"$f":"IF(B74=\"\",\"\",\"Or more than\")","v":"Or more than"},{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),12,7))","v":29.5},null,{"$f":"IF(B74=\"\",\"\",\"Or between\")","v":"Or between"},{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),12,6))","v":29},{"$f":"IF(B74=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),12,7))","v":29.5},null,{"$f":"IF(B74=\"\",\"\",\"Or between\")","v":"Or between"},{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),12,5))","v":28},{"$f":"IF(B74=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(Dashboard!D15=\"\",\"\",INDEX(INDIRECT(INDEX(Calcs!$D:$D,MATCH(Dashboard!D15,Calcs!$A:$A,0))),12,6))","v":29}]
[]
[]
[null,"E. Outcomes"]
[]
[null,null,null,"Red rating",null,null,"Amber rating",null,null,null,null,"Light green rating",null,null,null,null,"Dark green rating"]
[]
[null,"Ofsted rating",null,"School is rated",null,null,"School is rated",null,null,null,null,"School is rated",null,null,null,null,"School is rated"]
[null,null,null,{"$f":"IF(Dashboard!D15=\"\",\"\",\"Inadequate\")","v":"Inadequate"},null,null,{"$f":"IF(Dashboard!D15=\"\",\"\",\"Requires Improvement (RI)\")","v":"Requires Improvement (RI)"},null,null,null,null,{"$f":"IF(Dashboard!D15=\"\",\"\",\"Good\")","v":"Good"},null,null,null,null,{"$f":"IF(Dashboard!D15=\"\",\"\",\"Outstanding\")","v":"Outstanding"}]
[]
[null,{"$f":"IF(OR($B$3=\"- a primary school\",$B$3=\"- a nursery school\"),\"\",\"Progress 8 score\")","v":""},null,{"$f":"IF(B85=\"\",\"\",\"Less than or equal to\")","v":""},{"$f":"IF(OR(Dashboard!D15=\"\",B85=\"\"),\"\",-0.5)","v":""},null,{"$f":"IF(B85=\"\",\"\",\"Between\")","v":""},{"$f":"IF(OR(Dashboard!D15=\"\",B85=\"\"),\"\",-0.5)","v":""},{"$f":"IF(B85=\"\",\"\",\"and\")","v":""},{"$f":"IF(OR(Dashboard!D15=\"\",B85=\"\"),\"\",0)","v":""},null,{"$f":"IF(B85=\"\",\"\",\"Between\")","v":""},{"$f":"IF(OR(Dashboard!D15=\"\",B85=\"\"),\"\",0)","v":""},{"$f":"IF(B85=\"\",\"\",\"and\")","v":""},{"$f":"IF(OR(Dashboard!D15=\"\",B85=\"\"),\"\",0.5)","v":""},null,{"$f":"IF(B85=\"\",\"\",\"More than\")","v":""},{"$f":"IF(OR(Dashboard!D15=\"\",B85=\"\"),\"\",0.5)","v":""}]
[]
[]
[null,{"$f":"IF(OR($B$3=\"- a secondary school with a sixth form\", $B$3=\"- a secondary school without a sixth form\",$B$3=\"- a nursery school\"),\"\",\"Progress score in reading\")","v":"Progress score in reading"},null,{"$f":"IF(B88=\"\",\"\",\"Less than or equal to\")","v":"Less than or equal to"},{"$f":"IF(OR(Dashboard!D15=\"\",B88=\"\"),\"\",-2.7)","v":-2.7},null,{"$f":"IF(B88=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(OR(Dashboard!D15=\"\",B88=\"\"),\"\",-2.7)","v":-2.7},{"$f":"IF(B88=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(OR(Dashboard!D15=\"\",B88=\"\"),\"\",0)","v":0},null,{"$f":"IF(B88=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(OR(Dashboard!D15=\"\",B88=\"\"),\"\",0)","v":0},{"$f":"IF(B88=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(OR(Dashboard!D15=\"\",B88=\"\"),\"\",3.2)","v":3.2},null,{"$f":"IF(B88=\"\",\"\",\"More than\")","v":"More than"},{"$f":"IF(OR(Dashboard!D15=\"\",B88=\"\"),\"\",3.2)","v":3.2}]
[]
[]
[null,{"$f":"IF(OR($B$3=\"- a secondary school with a sixth form\", $B$3=\"- a secondary school without a sixth form\",$B$3=\"- a nursery school\"),\"\",\"Progress score in writing\")","v":"Progress score in writing"},null,{"$f":"IF(B91=\"\",\"\",\"Less than or equal to\")","v":"Less than or equal to"},{"$f":"IF(OR(Dashboard!D15=\"\",B91=\"\"),\"\",-2.6)","v":-2.6},null,{"$f":"IF(B91=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(OR(Dashboard!D15=\"\",B91=\"\"),\"\",-2.6)","v":-2.6},{"$f":"IF(B91=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(OR(Dashboard!D15=\"\",B91=\"\"),\"\",0)","v":0},null,{"$f":"IF(B91=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(OR(Dashboard!D15=\"\",B91=\"\"),\"\",0)","v":0},{"$f":"IF(B91=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(OR(Dashboard!D15=\"\",B91=\"\"),\"\",2.7)","v":2.7},null,{"$f":"IF(B91=\"\",\"\",\"More than\")","v":"More than"},{"$f":"IF(OR(Dashboard!D15=\"\",B91=\"\"),\"\",2.7)","v":2.7}]
[]
[]
[null,{"$f":"IF(OR($B$3=\"- a secondary school with a sixth form\", $B$3=\"- a secondary school without a sixth form\",$B$3=\"- a nursery school\"),\"\",\"Progress score in maths\")","v":"Progress score in maths"},null,{"$f":"IF(B94=\"\",\"\",\"Less than or equal to\")","v":"Less than or equal to"},{"$f":"IF(OR(Dashboard!D15=\"\",B94=\"\"),\"\",-3.1)","v":-3.1},null,{"$f":"IF(B94=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(OR(Dashboard!D15=\"\",B94=\"\"),\"\",-3.1)","v":-3.1},{"$f":"IF(B94=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(OR(Dashboard!D15=\"\",B94=\"\"),\"\",0)","v":0},null,{"$f":"IF(B94=\"\",\"\",\"Between\")","v":"Between"},{"$f":"IF(OR(Dashboard!D15=\"\",B94=\"\"),\"\",0)","v":0},{"$f":"IF(B94=\"\",\"\",\"and\")","v":"and"},{"$f":"IF(OR(Dashboard!D15=\"\",B94=\"\"),\"\",3.2)","v":3.2},null,{"$f":"IF(B94=\"\",\"\",\"More than\")","v":"More than"},{"$f":"IF(OR(Dashboard!D15=\"\",B94=\"\"),\"\",3.2)","v":3.2}]

{"sheet":"RAG rating data for all schools","index":5,"n_rows":559,"n_cols":14,"rows_kept":559,"cut":false,"hidden":false,"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",0.39500000000000002,0.42,0.45500000000000002,0.47,0.48499999999999999,0.51500000000000001,0.54]
[null,"Primary","Very small","Low FSM","Spend on supply staff as a percentage of total expenditure",null,null,0.02,0.02,2.5000000000000001E-2,0.04,5.5E-2]
[null,"Primary","Very small","Low FSM","Spend on education support staff as a percentage of total expenditure",null,null,0.125,0.13,0.14499999999999999,0.17,0.19]
[null,"Primary","Very small","Low FSM","Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,5.5E-2,null,7.4999999999999997E-2,8.5000000000000006E-2]
[null,"Primary","Very small","Low FSM","Spend on other staff costs as a percentage of total expenditure",null,null,null,0.03,null,0.05,0.06]
[null,"Primary","Very small","Low FSM","Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,0.05,null,6.5000000000000002E-2,0.08]
[null,"Primary","Very small","Low FSM","Spend on teaching resources as a percentage of total expenditure",0.03,0.04,0.05,5.5E-2,6.5000000000000002E-2]
[null,"Primary","Very small","Low FSM","Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Primary","Very small","Low FSM","Senior leaders as a percentage of workforce",null,null,0.115,0.125,0.14000000000000001,0.17499999999999999,0.21]
[null,"Primary","Very small","Low FSM","Pupil to teacher ratio",12,14,16,17,18,20,22.5]
[null,"Primary","Very small","Low FSM","Pupil to adult ratio",6,7,8,8.5,9,10,11]
[null,"Primary","Very small","Low FSM","Average class size",14.5,17,20.5,21,22.5,24.5,26]
[]
[698,"Primary","Small","Low FSM","PSL"]
[null,"Primary","Small","Low FSM","Spend on teaching staff as a percentage of total expenditure",0.40500000000000003,0.43,0.46,0.47,0.48,0.51500000000000001,0.53500000000000003]
[null,"Primary","Small","Low FSM","Spend on supply staff as a percentage of total expenditure",null,null,0.02,0.02,2.5000000000000001E-2,0.04,5.5E-2]
[null,"Primary","Small","Low FSM","Spend on education support staff as a percentage of total expenditure",null,null,0.13500000000000001,0.14499999999999999,0.155,0.17499999999999999,0.19500000000000001]
[null,"Primary","Small","Low FSM","Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,0.05,null,6.5000000000000002E-2,7.4999999999999997E-2]
[null,"Primary","Small","Low FSM","Spend on other staff costs as a percentage of total expenditure",null,null,null,0.03,null,0.05,6.5000000000000002E-2]
[null,"Primary","Small","Low FSM","Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,0.05,null,0.06,7.0000000000000007E-2]
[null,"Primary","Small","Low FSM","Spend on teaching resources as a percentage of total expenditure",0.03,0.04,0.05,5.5E-2,0.06]
[null,"Primary","Small","Low FSM","Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Primary","Small","Low FSM","Senior leaders as a percentage of workforce",null,null,0.1,0.115,0.125,0.155,0.18]
[null,"Primary","Small","Low FSM","Pupil to teacher ratio",17,18.5,19.5,20.5,21,22.5,24]
[null,"Primary","Small","Low FSM","Pupil to adult ratio",8,8.5,9,9.5,10,11,12]
[null,"Primary","Small","Low FSM","Average class size",21.5,23,25,26,26.5,28,29]
[]
[1757,"Primary","Medium","Low FSM","PML"]
[null,"Primary","Medium","Low FSM","Spend on teaching staff as a percentage of total expenditure",0.40500000000000003,0.42499999999999999,0.45500000000000002,0.46500000000000002,0.48,0.505,0.52500000000000002]
[null,"Primary","Medium","Low FSM","Spend on supply staff as a percentage of total expenditure",null,null,0.02,0.02,2.5000000000000001E-2,0.04,0.05]
[null,"Primary","Medium","Low FSM","Spend on education support staff as a percentage of total expenditure",null,null,0.14499999999999999,0.155,0.16500000000000001,0.19,0.21]
[null,"Primary","Medium","Low FSM","Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,0.05,null,0.06,7.0000000000000007E-2]
[null,"Primary","Medium","Low FSM","Spend on other staff costs as a percentage of total expenditure",null,null,null,3.5000000000000003E-2,null,0.05,6.5000000000000002E-2]
[null,"Primary","Medium","Low FSM","Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,0.05,null,6.5000000000000002E-2,7.4999999999999997E-2]
[null,"Primary","Medium","Low FSM","Spend on teaching resources as a percentage of total expenditure",0.03,0.04,0.05,5.5E-2,0.06]
[null,"Primary","Medium","Low FSM","Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Primary","Medium","Low FSM","Senior leaders as a percentage of workforce",null,null,0.09,9.5000000000000001E-2,0.1,0.115,0.13500000000000001]
[null,"Primary","Medium","Low FSM","Pupil to teacher ratio",19.5,20.5,22,22.5,23,24.5,26]
[null,"Primary","Medium","Low FSM","Pupil to adult ratio",8.5,9.5,10,10.5,11,12,12.5]
[null,"Primary","Medium","Low FSM","Average class size",26,27,28.5,29,29.5,30,30.5]
[]
[650,"Primary","Large","Low FSM","PLL"]
[null,"Primary","Large","Low FSM","Spend on teaching staff as a percentage of total expenditure",0.42,0.44500000000000001,0.47,0.48,0.49,0.51,0.53]
[null,"Primary","Large","Low FSM","Spend on supply staff as a percentage of total expenditure",null,null,1.4999999999999999E-2,0.02,2.5000000000000001E-2,3.5000000000000003E-2,0.05]
[null,"Primary","Large","Low FSM","Spend on education support staff as a percentage of total expenditure",null,null,0.155,0.16,0.17,0.19500000000000001,0.21]
[null,"Primary","Large","Low FSM","Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,4.4999999999999998E-2,null,0.06,7.0000000000000007E-2]
[null,"Primary","Large","Low FSM","Spend on other staff costs as a percentage of total expenditure",null,null,null,3.5000000000000003E-2,null,0.05,0.06]
[null,"Primary","Large","Low FSM","Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,0.05,null,0.06,7.0000000000000007E-2]
[null,"Primary","Large","Low FSM","Spend on teaching resources as a percentage of total expenditure",0.03,0.04,4.4999999999999998E-2,0.05,5.5E-2]
[null,"Primary","Large","Low FSM","Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Primary","Large","Low FSM","Senior leaders as a percentage of workforce",null,null,0.06,7.0000000000000007E-2,7.4999999999999997E-2,0.09,0.1]
[null,"Primary","Large","Low FSM","Pupil to teacher ratio",20.5,21.5,22.5,23,24,25,26.5]
[null,"Primary","Large","Low FSM","Pupil to adult ratio",9.5,10,11,11,11.5,12.5,13]
[null,"Primary","Large","Low FSM","Average class size",28,28.5,29,29.5,29.5,30,30.5]
[]
[880,"Primary","Very small","Medium FSM","PVSM"]
[null,"Primary","Very small","Medium FSM","Spend on teaching staff as a percentage of total expenditure",0.38,0.41499999999999998,0.44500000000000001,0.45500000000000002,0.47499999999999998,0.51,0.53500000000000003]
[null,"Primary","Very small","Medium FSM","Spend on supply staff as a percentage of total expenditure",null,null,0.02,2.5000000000000001E-2,0.03,4.4999999999999998E-2,6.5000000000000002E-2]
[null,"Primary","Very small","Medium FSM","Spend on education support staff as a percentage of total expenditure",null,null,0.13,0.14499999999999999,0.155,0.18,0.2]
[null,"Primary","Very small","Medium FSM","Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,5.5E-2,null,7.0000000000000007E-2,8.5000000000000006E-2]
[null,"Primary","Very small","Medium FSM","Spend on other staff costs as a percentage of total expenditure",null,null,null,3.5000000000000003E-2,null,0.05,6.5000000000000002E-2]
[null,"Primary","Very small","Medium FSM","Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,0.05,null,6.5000000000000002E-2,7.4999999999999997E-2]
[null,"Primary","Very small","Medium FSM","Spend on teaching resources as a percentage of total expenditure",0.03,0.04,0.05,5.5E-2,0.06]
[null,"Primary","Very small","Medium FSM","Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Primary","Very small","Medium FSM","Senior leaders as a percentage of workforce",null,null,0.105,0.12,0.13500000000000001,0.17499999999999999,0.20499999999999999]
[null,"Primary","Very small","Medium FSM","Pupil to teacher ratio",12,14,16,17,17.5,20,21.5]
[null,"Primary","Very small","Medium FSM","Pupil to adult ratio",5.5,6.5,7.5,8,8.5,9.5,10.5]
[null,"Primary","Very small","Medium FSM","Average class size",14.5,17,20,21.5,22.5,24.5,26]
[]
[994,"Primary","Small","Medium FSM","PSM"]
[null,"Primary","Small","Medium FSM","Spend on teaching staff as a percentage of total expenditure",0.38500000000000001,0.41,0.44500000000000001,0.45500000000000002,0.47,0.495,0.52500000000000002]
[null,"Primary","Small","Medium FSM","Spend on supply staff as a percentage of total expenditure",null,null,0.02,2.5000000000000001E-2,0.03,0.04,5.5E-2]
[null,"Primary","Small","Medium FSM","Spend on education support staff as a percentage of total expenditure",null,null,0.15,0.16,0.17,0.19500000000000001,0.22]
[null,"Primary","Small","Medium FSM","Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,0.05,null,6.5000000000000002E-2,7.4999999999999997E-2]
[null,"Primary","Small","Medium FSM","Spend on other staff costs as a percentage of total expenditure",null,null,null,3.5000000000000003E-2,null,0.05,6.5000000000000002E-2]
[null,"Primary","Small","Medium FSM","Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,0.05,null,6.5000000000000002E-2,7.4999999999999997E-2]
[null,"Primary","Small","Medium FSM","Spend on teaching resources as a percentage of total expenditure",0.03,3.5000000000000003E-2,4.4999999999999998E-2,0.05,5.5E-2]
[null,"Primary","Small","Medium FSM","Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Primary","Small","Medium FSM","Senior leaders as a percentage of workforce",null,null,9.5000000000000001E-2,0.11,0.12,0.14000000000000001,0.16500000000000001]
[null,"Primary","Small","Medium FSM","Pupil to teacher ratio",16.5,17.5,19,20,20.5,22.5,24]
[null,"Primary","Small","Medium FSM","Pupil to adult ratio",7,8,8.5,9,9.5,10.5,11.5]
[null,"Primary","Small","Medium FSM","Average class size",21.5,23,24.5,25.5,26.5,28,29]
[]
[3735,"Primary","Medium","Medium FSM","PMM"]
[null,"Primary","Medium","Medium FSM","Spend on teaching staff as a percentage of total expenditure",0.39,0.41499999999999998,0.44,0.45500000000000002,0.46500000000000002,0.495,0.51500000000000001]
[null,"Primary","Medium","Medium FSM","Spend on supply staff as a percentage of total expenditure",null,null,0.02,2.5000000000000001E-2,0.03,0.04,5.5E-2]
[null,"Primary","Medium","Medium FSM","Spend on education support staff as a percentage of total expenditure",null,null,0.16500000000000001,0.17499999999999999,0.185,0.21,0.23499999999999999]
[null,"Primary","Medium","Medium FSM","Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,4.4999999999999998E-2,null,0.06,7.0000000000000007E-2]
[null,"Primary","Medium","Medium FSM","Spend on other staff costs as a percentage of total expenditure",null,null,null,3.5000000000000003E-2,null,0.05,0.06]
[null,"Primary","Medium","Medium FSM","Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,0.05,null,6.5000000000000002E-2,7.4999999999999997E-2]
[null,"Primary","Medium","Medium FSM","Spend on teaching resources as a percentage of total expenditure",0.03,3.5000000000000003E-2,4.4999999999999998E-2,0.05,5.5E-2]
[null,"Primary","Medium","Medium FSM","Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Primary","Medium","Medium FSM","Senior leaders as a percentage of workforce",null,null,0.08,8.5000000000000006E-2,9.5000000000000001E-2,0.11,0.13]
[null,"Primary","Medium","Medium FSM","Pupil to teacher ratio",18,19.5,21,21.5,22.5,24,25.5]
[null,"Primary","Medium","Medium FSM","Pupil to adult ratio",8,8.5,9.5,9.5,10,11,11.5]
[null,"Primary","Medium","Medium FSM","Average class size",24.5,26,27.5,28,28.5,29.5,30]
[]
[2027,"Primary","Large","Medium FSM","PLM"]
[null,"Primary","Large","Medium FSM","Spend on teaching staff as a percentage of total expenditure",0.38500000000000001,0.41,0.44500000000000001,0.45500000000000002,0.47,0.495,0.52]
[null,"Primary","Large","Medium FSM","Spend on supply staff as a percentage of total expenditure",null,null,0.02,0.02,0.03,0.04,5.5E-2]
[null,"Primary","Large","Medium FSM","Spend on education support staff as a percentage of total expenditure",null,null,0.17499999999999999,0.185,0.19500000000000001,0.22,0.245]
[null,"Primary","Large","Medium FSM","Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,4.4999999999999998E-2,null,0.06,6.5000000000000002E-2]
[null,"Primary","Large","Medium FSM","Spend on other staff costs as a percentage of total expenditure",null,null,null,3.5000000000000003E-2,null,0.05,0.06]
[null,"Primary","Large","Medium FSM","Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,0.05,null,6.5000000000000002E-2,7.4999999999999997E-2]
[null,"Primary","Large","Medium FSM","Spend on teaching resources as a percentage of total expenditure",0.03,3.5000000000000003E-2,4.4999999999999998E-2,4.4999999999999998E-2,0.05]
[null,"Primary","Large","Medium FSM","Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Primary","Large","Medium FSM","Senior leaders as a percentage of workforce",null,null,0.06,6.5000000000000002E-2,7.4999999999999997E-2,0.09,0.105]
[null,"Primary","Large","Medium FSM","Pupil to teacher ratio",18.5,20,21.5,22,22.5,24,25]
[null,"Primary","Large","Medium FSM","Pupil to adult ratio",8,8.5,9.5,10,10,11,12]
[null,"Primary","Large","Medium FSM","Average class size",26,27,28.5,29,29,29.5,30]
[]
[214,"Primary","Very small","High FSM","PVSH"]
[null,"Primary","Very small","High FSM","Spend on teaching staff as a percentage of total expenditure",0.36,0.39500000000000002,0.42499999999999999,0.44,0.45500000000000002,0.49,0.52]
[null,"Primary","Very small","High FSM","Spend on supply staff as a percentage of total expenditure",null,null,0.02,2.5000000000000001E-2,0.03,5.5E-2,0.08]
[null,"Primary","Very small","High FSM","Spend on education support staff as a percentage of total expenditure",null,null,0.14000000000000001,0.15,0.17,0.2,0.23499999999999999]
[null,"Primary","Very small","High FSM","Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,0.05,null,7.0000000000000007E-2,8.5000000000000006E-2]
[null,"Primary","Very small","High FSM","Spend on other staff costs as a percentage of total expenditure",null,null,null,3.5000000000000003E-2,null,0.05,6.5000000000000002E-2]
[null,"Primary","Very small","High FSM","Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,5.5E-2,null,7.0000000000000007E-2,8.5000000000000006E-2]
[null,"Primary","Very small","High FSM","Spend on teaching resources as a percentage of total expenditure",0.03,0.04,4.4999999999999998E-2,5.5E-2,0.06]
[null,"Primary","Very small","High FSM","Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Primary","Very small","High FSM","Senior leaders as a percentage of workforce",null,null,0.105,0.12,0.13500000000000001,0.17,0.2]
[null,"Primary","Very small","High FSM","Pupil to teacher ratio",11,13,15.5,16,17,19,20]
[null,"Primary","Very small","High FSM","Pupil to adult ratio",5,5.5,6.5,7,7.5,8.5,9]
[null,"Primary","Very small","High FSM","Average class size",13,16.5,19.5,21,22.5,24,25.5]
[]
[370,"Primary","Small","High FSM","PSH"]
[null,"Primary","Small","High FSM","Spend on teaching staff as a percentage of total expenditure",0.36499999999999999,0.39,0.42,0.435,0.45,0.48,0.51500000000000001]
[null,"Primary","Small","High FSM","Spend on supply staff as a percentage of total expenditure",null,null,0.02,2.5000000000000001E-2,3.5000000000000003E-2,5.5E-2,7.4999999999999997E-2]
[null,"Primary","Small","High FSM","Spend on education support staff as a percentage of total expenditure",null,null,0.16500000000000001,0.17499999999999999,0.185,0.215,0.23]
[null,"Primary","Small","High FSM","Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,4.4999999999999998E-2,null,6.5000000000000002E-2,7.4999999999999997E-2]
[null,"Primary","Small","High FSM","Spend on other staff costs as a percentage of total expenditure",null,null,null,3.5000000000000003E-2,null,0.05,6.5000000000000002E-2]
[null,"Primary","Small","High FSM","Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,5.5E-2,null,7.0000000000000007E-2,0.08]
[null,"Primary","Small","High FSM","Spend on teaching resources as a percentage of total expenditure",2.5000000000000001E-2,3.5000000000000003E-2,4.4999999999999998E-2,0.05,5.5E-2]
[null,"Primary","Small","High FSM","Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Primary","Small","High FSM","Senior leaders as a percentage of workforce",null,null,9.5000000000000001E-2,0.105,0.115,0.13500000000000001,0.155]
[null,"Primary","Small","High FSM","Pupil to teacher ratio",15,16,17.5,18,19,21,22.5]
[null,"Primary","Small","High FSM","Pupil to adult ratio",6.5,7,7.5,8,8.5,9,10]
[null,"Primary","Small","High FSM","Average class size",19,20.5,22.5,23,24,26.5,28]
[]
[2197,"Primary","Medium","High FSM","PMH"]
[null,"Primary","Medium","High FSM","Spend on teaching staff as a percentage of total expenditure",0.36,0.38500000000000001,0.41,0.42499999999999999,0.435,0.46500000000000002,0.49]
[null,"Primary","Medium","High FSM","Spend on supply staff as a percentage of total expenditure",null,null,0.02,2.5000000000000001E-2,0.03,4.4999999999999998E-2,6.5000000000000002E-2]
[null,"Primary","Medium","High FSM","Spend on education support staff as a percentage of total expenditure",null,null,0.185,0.2,0.21,0.23499999999999999,0.26]
[null,"Primary","Medium","High FSM","Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,4.4999999999999998E-2,null,0.06,7.4999999999999997E-2]
[null,"Primary","Medium","High FSM","Spend on other staff costs as a percentage of total expenditure",null,null,null,3.5000000000000003E-2,null,0.05,0.06]
[null,"Primary","Medium","High FSM","Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,5.5E-2,null,7.0000000000000007E-2,0.08]
[null,"Primary","Medium","High FSM","Spend on teaching resources as a percentage of total expenditure",2.5000000000000001E-2,3.5000000000000003E-2,0.04,4.4999999999999998E-2,0.05]
[null,"Primary","Medium","High FSM","Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Primary","Medium","High FSM","Senior leaders as a percentage of workforce",null,null,7.4999999999999997E-2,0.08,0.09,0.11,0.13]
[null,"Primary","Medium","High FSM","Pupil to teacher ratio",16,17.5,19,19.5,20.5,22.5,24]
[null,"Primary","Medium","High FSM","Pupil to adult ratio",6.5,7.5,8,8.5,8.5,9.5,10]
[null,"Primary","Medium","High FSM","Average class size",22.5,23.5,25.5,26.5,27,28.5,29.5]
[]
[1120,"Primary","Large","High FSM","PLH"]
[null,"Primary","Large","High FSM","Spend on teaching staff as a percentage of total expenditure",0.35499999999999998,0.38,0.41,0.42499999999999999,0.435,0.46500000000000002,0.49]
[null,"Primary","Large","High FSM","Spend on supply staff as a percentage of total expenditure",null,null,0.02,2.5000000000000001E-2,0.03,4.4999999999999998E-2,0.06]
[null,"Primary","Large","High FSM","Spend on education support staff as a percentage of total expenditure",null,null,0.19500000000000001,0.20499999999999999,0.22,0.25,0.26500000000000001]
[null,"Primary","Large","High FSM","Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,4.4999999999999998E-2,null,0.06,7.4999999999999997E-2]
[null,"Primary","Large","High FSM","Spend on other staff costs as a percentage of total expenditure",null,null,null,3.5000000000000003E-2,null,4.4999999999999998E-2,0.06]
[null,"Primary","Large","High FSM","Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,0.05,null,7.0000000000000007E-2,0.08]
[null,"Primary","Large","High FSM","Spend on teaching resources as a percentage of total expenditure",2.5000000000000001E-2,0.03,0.04,4.4999999999999998E-2,0.05]
[null,"Primary","Large","High FSM","Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Primary","Large","High FSM","Senior leaders as a percentage of workforce",null,null,6.5000000000000002E-2,7.0000000000000007E-2,7.4999999999999997E-2,0.09,0.105]
[null,"Primary","Large","High FSM","Pupil to teacher ratio",17,18,20,20.5,21,23,24.5]
[null,"Primary","Large","High FSM","Pupil to adult ratio",7,7.5,8,8.5,9,9.5,10.5]
[null,"Primary","Large","High FSM","Average class size",24.5,25.5,27,27.5,28,29,29.5]
[]
[]
["Sample size","Phase","Size","FSM",null,"Red if less than:","Amber if less than:","Dark green if between:","(Median)","and:","Amber if more than:","Red if more than:",null,"Light green for everything else"]
[59,"Secondary with sixth form","Small","Low FSM","SSSL"]
[null,"Secondary with sixth form","Small","Low FSM","Spend on teaching staff as a percentage of total expenditure",0.45500000000000002,0.49,0.54,0.56000000000000005,0.56999999999999995,0.61,0.625]
[null,"Secondary with sixth form","Small","Low FSM","Spend on supply staff as a percentage of total expenditure",null,null,0.01,1.4999999999999999E-2,0.02,0.03,0.04]
[null,"Secondary with sixth form","Small","Low FSM","Spend on education support staff as a percentage of total expenditure",null,null,0.05,0.06,7.0000000000000007E-2,0.09,0.11]
[null,"Secondary with sixth form","Small","Low FSM","Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,6.5000000000000002E-2,null,0.09,0.1]
[null,"Secondary with sixth form","Small","Low FSM","Spend on other staff costs as a percentage of total expenditure",null,null,null,0.01,null,4.4999999999999998E-2,7.0000000000000007E-2]
[null,"Secondary with sixth form","Small","Low FSM","Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,0.05,null,7.4999999999999997E-2,8.5000000000000006E-2]
[null,"Secondary with sixth form","Small","Low FSM","Spend on teaching resources as a percentage of total expenditure",0.05,0.06,7.0000000000000007E-2,7.4999999999999997E-2,8.5000000000000006E-2]
[null,"Secondary with sixth form","Small","Low FSM","Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Secondary with sixth form","Small","Low FSM","Senior leaders as a percentage of workforce",null,null,0.06,6.5000000000000002E-2,7.0000000000000007E-2,0.09,0.14000000000000001]
[null,"Secondary with sixth form","Small","Low FSM","Pupil to teacher ratio",12,13.5,15.5,16,17,18,18.5]
[null,"Secondary with sixth form","Small","Low FSM","Pupil to adult ratio",7.5,8.5,10,10,10.5,11.5,12]
[null,"Secondary with sixth form","Small","Low FSM","Average class size",14,18,19.5,19.5,20.5,22,23]
[]
[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",0.495,0.52500000000000002,0.55500000000000005,0.56000000000000005,0.57499999999999996,0.61,0.63]
[null,"Secondary with sixth form","Medium","Low FSM","Spend on supply staff as a percentage of total expenditure",null,null,0.01,0.01,1.4999999999999999E-2,0.02,2.5000000000000001E-2]
[null,"Secondary with sixth form","Medium","Low FSM","Spend on education support staff as a percentage of total expenditure",null,null,7.0000000000000007E-2,7.4999999999999997E-2,0.08,0.1,0.11]
[null,"Secondary with sixth form","Medium","Low FSM","Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,6.5000000000000002E-2,null,8.5000000000000006E-2,0.1]
[null,"Secondary with sixth form","Medium","Low FSM","Spend on other staff costs as a percentage of total expenditure",null,null,null,1.4999999999999999E-2,null,0.03,5.5E-2]
[null,"Secondary with sixth form","Medium","Low FSM","Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,5.5E-2,null,7.0000000000000007E-2,0.08]
[null,"Secondary with sixth form","Medium","Low FSM","Spend on teaching resources as a percentage of total expenditure",0.05,0.06,7.4999999999999997E-2,8.5000000000000006E-2,0.09]
[null,"Secondary with sixth form","Medium","Low FSM","Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Secondary with sixth form","Medium","Low FSM","Senior leaders as a percentage of workforce",null,null,5.5E-2,0.06,6.5000000000000002E-2,7.4999999999999997E-2,8.5000000000000006E-2]
[null,"Secondary with sixth form","Medium","Low FSM","Pupil to teacher ratio",15,15.5,16.5,17,17.5,18.5,19]
[null,"Secondary with sixth form","Medium","Low FSM","Pupil to adult ratio",9,9.5,10.5,10.5,11,11.5,12.5]
[null,"Secondary with sixth form","Medium","Low FSM","Average class size",19.5,20,21,21.5,21.5,22.5,23.5]
[]
[206,"Secondary with sixth form","Large","Low FSM","SSLL"]
[null,"Secondary with sixth form","Large","Low FSM","Spend on teaching staff as a percentage of total expenditure",0.505,0.53,0.56000000000000005,0.57499999999999996,0.59,0.61,0.625]
[null,"Secondary with sixth form","Large","Low FSM","Spend on supply staff as a percentage of total expenditure",null,null,0.01,0.01,1.4999999999999999E-2,0.02,0.03]
[null,"Secondary with sixth form","Large","Low FSM","Spend on education support staff as a percentage of total expenditure",null,null,7.4999999999999997E-2,0.08,0.09,0.11,0.12]
[null,"Secondary with sixth form","Large","Low FSM","Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,0.06,null,0.08,9.5000000000000001E-2]
[null,"Secondary with sixth form","Large","Low FSM","Spend on other staff costs as a percentage of total expenditure",null,null,null,1.4999999999999999E-2,null,3.5000000000000003E-2,5.5E-2]
[null,"Secondary with sixth form","Large","Low FSM","Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,5.5E-2,null,6.5000000000000002E-2,0.08]
[null,"Secondary with sixth form","Large","Low FSM","Spend on teaching resources as a percentage of total expenditure",0.05,5.5E-2,7.0000000000000007E-2,7.4999999999999997E-2,8.5000000000000006E-2]
[null,"Secondary with sixth form","Large","Low FSM","Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Secondary with sixth form","Large","Low FSM","Senior leaders as a percentage of workforce",null,null,0.05,5.5E-2,5.5E-2,6.5000000000000002E-2,7.4999999999999997E-2]
[null,"Secondary with sixth form","Large","Low FSM","Pupil to teacher ratio",15.5,16,16.5,17,17,18,18.5]
[null,"Secondary with sixth form","Large","Low FSM","Pupil to adult ratio",9,9.5,10,10.5,10.5,11,12]
[null,"Secondary with sixth form","Large","Low FSM","Average class size",19.5,20,20.5,21,21.5,22.5,23.5]
[]
[36,"Secondary without sixth form","Small","Low FSM","SSL"]
[null,"Secondary without sixth form","Small","Low FSM","Spend on teaching staff as a percentage of total expenditure",0.44500000000000001,0.495,0.52500000000000002,0.54500000000000004,0.55000000000000004,0.57999999999999996,0.6]
[null,"Secondary without sixth form","Small","Low FSM","Spend on supply staff as a percentage of total expenditure",null,null,0.01,1.4999999999999999E-2,2.5000000000000001E-2,0.04,0.05]
[null,"Secondary without sixth form","Small","Low FSM","Spend on education support staff as a percentage of total expenditure",null,null,0.09,9.5000000000000001E-2,0.1,0.125,0.14499999999999999]
[null,"Secondary without sixth form","Small","Low FSM","Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,6.5000000000000002E-2,null,8.5000000000000006E-2,0.09]
[null,"Secondary without sixth form","Small","Low FSM","Spend on other staff costs as a percentage of total expenditure",null,null,null,0.02,null,0.04,6.5000000000000002E-2]
[null,"Secondary without sixth form","Small","Low FSM","Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,5.5E-2,null,0.08,0.1]
[null,"Secondary without sixth form","Small","Low FSM","Spend on teaching resources as a percentage of total expenditure",3.5000000000000003E-2,4.4999999999999998E-2,0.05,0.06,7.0000000000000007E-2]
[null,"Secondary without sixth form","Small","Low FSM","Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Secondary without sixth form","Small","Low FSM","Senior leaders as a percentage of workforce",null,null,7.0000000000000007E-2,8.5000000000000006E-2,0.09,0.11,0.125]
[null,"Secondary without sixth form","Small","Low FSM","Pupil to teacher ratio",13,15,17,17.5,18,19.5,20.5]
[null,"Secondary without sixth form","Small","Low FSM","Pupil to adult ratio",7,8,9.5,10,10.5,11,11.5]
[null,"Secondary without sixth form","Small","Low FSM","Average class size",19.5,21.5,23,24,25.5,27,27.5]
[]
[95,"Secondary without sixth form","Medium","Low FSM","SML"]
[null,"Secondary without sixth form","Medium","Low FSM","Spend on teaching staff as a percentage of total expenditure",0.49,0.505,0.54500000000000004,0.55000000000000004,0.56999999999999995,0.59499999999999997,0.62]
[null,"Secondary without sixth form","Medium","Low FSM","Spend on supply staff as a percentage of total expenditure",null,null,1.4999999999999999E-2,1.4999999999999999E-2,0.02,2.5000000000000001E-2,3.5000000000000003E-2]
[null,"Secondary without sixth form","Medium","Low FSM","Spend on education support staff as a percentage of total expenditure",null,null,0.09,0.09,0.1,0.125,0.14000000000000001]
[null,"Secondary without sixth form","Medium","Low FSM","Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,6.5000000000000002E-2,null,0.08,0.1]
[null,"Secondary without sixth form","Medium","Low FSM","Spend on other staff costs as a percentage of total expenditure",null,null,null,1.4999999999999999E-2,null,0.03,0.04]
[null,"Secondary without sixth form","Medium","Low FSM","Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,5.5E-2,null,7.0000000000000007E-2,0.09]
[null,"Secondary without sixth form","Medium","Low FSM","Spend on teaching resources as a percentage of total expenditure",0.04,0.05,0.06,6.5000000000000002E-2,7.0000000000000007E-2]
[null,"Secondary without sixth form","Medium","Low FSM","Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Secondary without sixth form","Medium","Low FSM","Senior leaders as a percentage of workforce",null,null,0.06,0.06,7.0000000000000007E-2,8.5000000000000006E-2,0.105]
[null,"Secondary without sixth form","Medium","Low FSM","Pupil to teacher ratio",16,16.5,17,17,17.5,18.5,20]
[null,"Secondary without sixth form","Medium","Low FSM","Pupil to adult ratio",8.5,9,9.5,10,10,11,12]
[null,"Secondary without sixth form","Medium","Low FSM","Average class size",22,22.5,23.5,24,24.5,25.5,26.5]
[]
[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",0.48499999999999999,0.51500000000000001,0.55000000000000004,0.56000000000000005,0.57499999999999996,0.59499999999999997,0.61]
[null,"Secondary without sixth form","Large","Low FSM","Spend on supply staff as a percentage of total expenditure",null,null,0.01,1.4999999999999999E-2,1.4999999999999999E-2,2.5000000000000001E-2,3.5000000000000003E-2]
[null,"Secondary without sixth form","Large","Low FSM","Spend on education support staff as a percentage of total expenditure",null,null,0.08,8.5000000000000006E-2,9.5000000000000001E-2,0.11,0.125]
[null,"Secondary without sixth form","Large","Low FSM","Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,6.5000000000000002E-2,null,8.5000000000000006E-2,0.1]
[null,"Secondary without sixth form","Large","Low FSM","Spend on other staff costs as a percentage of total expenditure",null,null,null,1.4999999999999999E-2,null,3.5000000000000003E-2,5.5E-2]
[null,"Secondary without sixth form","Large","Low FSM","Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,5.5E-2,null,7.0000000000000007E-2,8.5000000000000006E-2]
[null,"Secondary without sixth form","Large","Low FSM","Spend on teaching resources as a percentage of total expenditure",4.4999999999999998E-2,0.05,6.5000000000000002E-2,7.0000000000000007E-2,0.08]
[null,"Secondary without sixth form","Large","Low FSM","Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Secondary without sixth form","Large","Low FSM","Senior leaders as a percentage of workforce",null,null,0.05,5.5E-2,0.06,7.4999999999999997E-2,0.09]
[null,"Secondary without sixth form","Large","Low FSM","Pupil to teacher ratio",15,16,16.5,17,17.5,18,18.5]
[null,"Secondary without sixth form","Large","Low FSM","Pupil to adult ratio",8.5,9,10,10,10.5,11,11.5]
[null,"Secondary without sixth form","Large","Low FSM","Average class size",22,23,23.5,23.5,24,25,25.5]
[]
[278,"Secondary with sixth form","Small","Medium FSM","SSSM"]
[null,"Secondary with sixth form","Small","Medium FSM","Spend on teaching staff as a percentage of total expenditure",0.45500000000000002,0.48,0.52,0.53500000000000003,0.55000000000000004,0.58499999999999996,0.61499999999999999]
[null,"Secondary with sixth form","Small","Medium FSM","Spend on supply staff as a percentage of total expenditure",null,null,1.4999999999999999E-2,1.4999999999999999E-2,0.02,3.5000000000000003E-2,0.05]
[null,"Secondary with sixth form","Small","Medium FSM","Spend on education support staff as a percentage of total expenditure",null,null,7.0000000000000007E-2,0.08,9.5000000000000001E-2,0.115,0.13]
[null,"Secondary with sixth form","Small","Medium FSM","Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,6.5000000000000002E-2,null,0.09,0.115]
[null,"Secondary with sixth form","Small","Medium FSM","Spend on other staff costs as a percentage of total expenditure",null,null,null,1.4999999999999999E-2,null,0.03,4.4999999999999998E-2]
[null,"Secondary with sixth form","Small","Medium FSM","Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,5.5E-2,null,7.0000000000000007E-2,9.5000000000000001E-2]
[null,"Secondary with sixth form","Small","Medium FSM","Spend on teaching resources as a percentage of total expenditure",0.04,0.05,0.06,6.5000000000000002E-2,7.0000000000000007E-2]
[null,"Secondary with sixth form","Small","Medium FSM","Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Secondary with sixth form","Small","Medium FSM","Senior leaders as a percentage of workforce",null,null,6.5000000000000002E-2,7.0000000000000007E-2,0.08,0.105,0.14000000000000001]
[null,"Secondary with sixth form","Small","Medium FSM","Pupil to teacher ratio",12,13.5,14.5,15,16,17,18]
[null,"Secondary with sixth form","Small","Medium FSM","Pupil to adult ratio",7,8,8.5,9,9.5,10,11.5]
[null,"Secondary with sixth form","Small","Medium FSM","Average class size",15,16.5,18.5,19,19.5,21.5,23]
[]
[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",0.49,0.52,0.55500000000000005,0.56499999999999995,0.57499999999999996,0.60499999999999998,0.625]
[null,"Secondary with sixth form","Medium","Medium FSM","Spend on supply staff as a percentage of total expenditure",null,null,1.4999999999999999E-2,1.4999999999999999E-2,0.02,0.03,0.04]
[null,"Secondary with sixth form","Medium","Medium FSM","Spend on education support staff as a percentage of total expenditure",null,null,0.08,0.09,0.1,0.12,0.13500000000000001]
[null,"Secondary with sixth form","Medium","Medium FSM","Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,6.5000000000000002E-2,null,8.5000000000000006E-2,0.1]
[null,"Secondary with sixth form","Medium","Medium FSM","Spend on other staff costs as a percentage of total expenditure",null,null,null,1.4999999999999999E-2,null,3.5000000000000003E-2,0.05]
[null,"Secondary with sixth form","Medium","Medium FSM","Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,5.5E-2,null,7.0000000000000007E-2,0.08]
[null,"Secondary with sixth form","Medium","Medium FSM","Spend on teaching resources as a percentage of total expenditure",4.4999999999999998E-2,0.05,0.06,6.5000000000000002E-2,7.0000000000000007E-2]
[null,"Secondary with sixth form","Medium","Medium FSM","Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Secondary with sixth form","Medium","Medium FSM","Senior leaders as a percentage of workforce",null,null,5.5E-2,0.06,6.5000000000000002E-2,0.08,9.5000000000000001E-2]
[null,"Secondary with sixth form","Medium","Medium FSM","Pupil to teacher ratio",14,15,15.5,16,16.5,17,18]
[null,"Secondary with sixth form","Medium","Medium FSM","Pupil to adult ratio",8,8.5,9.5,9.5,10,10.5,11]
[null,"Secondary with sixth form","Medium","Medium FSM","Average class size",18.5,19.5,20,20.5,21,22,22.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",0.5,0.53,0.55500000000000005,0.56499999999999995,0.57499999999999996,0.61,0.63500000000000001]
[null,"Secondary with sixth form","Large","Medium FSM","Spend on supply staff as a percentage of total expenditure",null,null,0.01,1.4999999999999999E-2,0.02,0.03,0.04]
[null,"Secondary with sixth form","Large","Medium FSM","Spend on education support staff as a percentage of total expenditure",null,null,8.5000000000000006E-2,0.09,0.1,0.115,0.13]
[null,"Secondary with sixth form","Large","Medium FSM","Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,0.06,null,0.08,0.1]
[null,"Secondary with sixth form","Large","Medium FSM","Spend on other staff costs as a percentage of total expenditure",null,null,null,1.4999999999999999E-2,null,0.03,0.05]
[null,"Secondary with sixth form","Large","Medium FSM","Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,0.05,null,6.5000000000000002E-2,8.5000000000000006E-2]
[null,"Secondary with sixth form","Large","Medium FSM","Spend on teaching resources as a percentage of total expenditure",4.4999999999999998E-2,5.5E-2,6.5000000000000002E-2,7.0000000000000007E-2,7.4999999999999997E-2]
[null,"Secondary with sixth form","Large","Medium FSM","Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Secondary with sixth form","Large","Medium FSM","Senior leaders as a percentage of workforce",null,null,0.05,5.5E-2,0.06,7.0000000000000007E-2,0.08]
[null,"Secondary with sixth form","Large","Medium FSM","Pupil to teacher ratio",14,15,16,16,16.5,17.5,18.5]
[null,"Secondary with sixth form","Large","Medium FSM","Pupil to adult ratio",8.5,9,9.5,10,10,11,11.5]
[null,"Secondary with sixth form","Large","Medium FSM","Average class size",19,19.5,20.5,21,21.5,22,23]
[]
[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",0.42499999999999999,0.46,0.49,0.51,0.54,0.56999999999999995,0.59499999999999997]
[null,"Secondary without sixth form","Small","Medium FSM","Spend on supply staff as a percentage of total expenditure",null,null,1.4999999999999999E-2,1.4999999999999999E-2,2.5000000000000001E-2,3.5000000000000003E-2,4.4999999999999998E-2]
[null,"Secondary without sixth form","Small","Medium FSM","Spend on education support staff as a percentage of total expenditure",null,null,8.5000000000000006E-2,0.09,0.1,0.13,0.15]
[null,"Secondary without sixth form","Small","Medium FSM","Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,7.0000000000000007E-2,null,9.5000000000000001E-2,0.115]
[null,"Secondary without sixth form","Small","Medium FSM","Spend on other staff costs as a percentage of total expenditure",null,null,null,1.4999999999999999E-2,null,0.04,6.5000000000000002E-2]
[null,"Secondary without sixth form","Small","Medium FSM","Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,5.5E-2,null,7.4999999999999997E-2,8.5000000000000006E-2]
[null,"Secondary without sixth form","Small","Medium FSM","Spend on teaching resources as a percentage of total expenditure",3.5000000000000003E-2,0.04,5.5E-2,0.06,7.0000000000000007E-2]
[null,"Secondary without sixth form","Small","Medium FSM","Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Secondary without sixth form","Small","Medium FSM","Senior leaders as a percentage of workforce",null,null,0.08,0.09,9.5000000000000001E-2,0.115,0.155]
[null,"Secondary without sixth form","Small","Medium FSM","Pupil to teacher ratio",12.5,13.5,15,15.5,16.5,17.5,19]
[null,"Secondary without sixth form","Small","Medium FSM","Pupil to adult ratio",6.5,7.5,8.5,9,9,10,11.5]
[null,"Secondary without sixth form","Small","Medium FSM","Average class size",18.5,20,22,23,23.5,25,27]
[]
[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",0.46500000000000002,0.495,0.52500000000000002,0.53500000000000003,0.54500000000000004,0.56999999999999995,0.59499999999999997]
[null,"Secondary without sixth form","Medium","Medium FSM","Spend on supply staff as a percentage of total expenditure",null,null,1.4999999999999999E-2,0.02,2.5000000000000001E-2,3.5000000000000003E-2,4.4999999999999998E-2]
[null,"Secondary without sixth form","Medium","Medium FSM","Spend on education support staff as a percentage of total expenditure",null,null,9.5000000000000001E-2,0.11,0.115,0.13500000000000001,0.15]
[null,"Secondary without sixth form","Medium","Medium FSM","Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,6.5000000000000002E-2,null,8.5000000000000006E-2,0.1]
[null,"Secondary without sixth form","Medium","Medium FSM","Spend on other staff costs as a percentage of total expenditure",null,null,null,1.4999999999999999E-2,null,3.5000000000000003E-2,0.05]
[null,"Secondary without sixth form","Medium","Medium FSM","Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,0.06,null,8.5000000000000006E-2,0.105]
[null,"Secondary without sixth form","Medium","Medium FSM","Spend on teaching resources as a percentage of total expenditure",0.04,4.4999999999999998E-2,5.5E-2,0.06,6.5000000000000002E-2]
[null,"Secondary without sixth form","Medium","Medium FSM","Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Secondary without sixth form","Medium","Medium FSM","Senior leaders as a percentage of workforce",null,null,0.06,7.0000000000000007E-2,7.4999999999999997E-2,0.09,0.105]
[null,"Secondary without sixth form","Medium","Medium FSM","Pupil to teacher ratio",14,14.5,15.5,16,16.5,17.5,18.5]
[null,"Secondary without sixth form","Medium","Medium FSM","Pupil to adult ratio",7.5,8,8.5,9,9,10,11]
[null,"Secondary without sixth form","Medium","Medium FSM","Average class size",20.5,21.5,22.5,22.5,23,24,25]
[]
[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",0.46,0.48,0.51,0.52500000000000002,0.54,0.56999999999999995,0.59]
[null,"Secondary without sixth form","Large","Medium FSM","Spend on supply staff as a percentage of total expenditure",null,null,1.4999999999999999E-2,0.02,2.5000000000000001E-2,3.5000000000000003E-2,4.4999999999999998E-2]
[null,"Secondary without sixth form","Large","Medium FSM","Spend on education support staff as a percentage of total expenditure",null,null,0.105,0.11,0.12,0.14000000000000001,0.15]
[null,"Secondary without sixth form","Large","Medium FSM","Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,0.06,null,0.08,0.1]
[null,"Secondary without sixth form","Large","Medium FSM","Spend on other staff costs as a percentage of total expenditure",null,null,null,1.4999999999999999E-2,null,0.03,5.5E-2]
[null,"Secondary without sixth form","Large","Medium FSM","Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,5.5E-2,null,7.0000000000000007E-2,0.09]
[null,"Secondary without sixth form","Large","Medium FSM","Spend on teaching resources as a percentage of total expenditure",3.5000000000000003E-2,0.04,5.5E-2,0.06,6.5000000000000002E-2]
[null,"Secondary without sixth form","Large","Medium FSM","Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Secondary without sixth form","Large","Medium FSM","Senior leaders as a percentage of workforce",null,null,5.5E-2,0.06,6.5000000000000002E-2,7.4999999999999997E-2,9.5000000000000001E-2]
[null,"Secondary without sixth form","Large","Medium FSM","Pupil to teacher ratio",14,15,16,16.5,16.5,17.5,18]
[null,"Secondary without sixth form","Large","Medium FSM","Pupil to adult ratio",8,8.5,9,9,9.5,10,10.5]
[null,"Secondary without sixth form","Large","Medium FSM","Average class size",21,22,22.5,23,23.5,24.5,25.5]
[]
[203,"Secondary with sixth form","Small","High FSM","SSSH"]
[null,"Secondary with sixth form","Small","High FSM","Spend on teaching staff as a percentage of total expenditure",0.44,0.47,0.505,0.52,0.53,0.56000000000000005,0.59499999999999997]
[null,"Secondary with sixth form","Small","High FSM","Spend on supply staff as a percentage of total expenditure",null,null,1.4999999999999999E-2,0.02,2.5000000000000001E-2,0.04,5.5E-2]
[null,"Secondary with sixth form","Small","High FSM","Spend on education support staff as a percentage of total expenditure",null,null,0.09,0.1,0.105,0.13,0.15]
[null,"Secondary with sixth form","Small","High FSM","Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,7.0000000000000007E-2,null,0.105,0.12]
[null,"Secondary with sixth form","Small","High FSM","Spend on other staff costs as a percentage of total expenditure",null,null,null,0.02,null,3.5000000000000003E-2,0.05]
[null,"Secondary with sixth form","Small","High FSM","Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,5.5E-2,null,7.4999999999999997E-2,8.5000000000000006E-2]
[null,"Secondary with sixth form","Small","High FSM","Spend on teaching resources as a percentage of total expenditure",3.5000000000000003E-2,4.4999999999999998E-2,5.5E-2,0.06,6.5000000000000002E-2]
[null,"Secondary with sixth form","Small","High FSM","Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Secondary with sixth form","Small","High FSM","Senior leaders as a percentage of workforce",null,null,7.0000000000000007E-2,7.4999999999999997E-2,0.08,0.1,0.115]
[null,"Secondary with sixth form","Small","High FSM","Pupil to teacher ratio",12,12.5,14,14.5,15,16.5,17.5]
[null,"Secondary with sixth form","Small","High FSM","Pupil to adult ratio",6.5,7,8,8,8.5,9.5,10]
[null,"Secondary with sixth form","Small","High FSM","Average class size",16,17.5,19,19.5,20,21.5,22.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",0.46500000000000002,0.495,0.51500000000000001,0.53500000000000003,0.54500000000000004,0.57999999999999996,0.61]
[null,"Secondary with sixth form","Medium","High FSM","Spend on supply staff as a percentage of total expenditure",null,null,1.4999999999999999E-2,0.02,2.5000000000000001E-2,3.5000000000000003E-2,4.4999999999999998E-2]
[null,"Secondary with sixth form","Medium","High FSM","Spend on education support staff as a percentage of total expenditure",null,null,9.5000000000000001E-2,0.105,0.115,0.13500000000000001,0.15]
[null,"Secondary with sixth form","Medium","High FSM","Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,0.06,null,8.5000000000000006E-2,0.105]
[null,"Secondary with sixth form","Medium","High FSM","Spend on other staff costs as a percentage of total expenditure",null,null,null,0.02,null,0.03,0.04]
[null,"Secondary with sixth form","Medium","High FSM","Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,5.5E-2,null,7.4999999999999997E-2,9.5000000000000001E-2]
[null,"Secondary with sixth form","Medium","High FSM","Spend on teaching resources as a percentage of total expenditure",0.04,4.4999999999999998E-2,5.5E-2,0.06,6.5000000000000002E-2]
[null,"Secondary with sixth form","Medium","High FSM","Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Secondary with sixth form","Medium","High FSM","Senior leaders as a percentage of workforce",null,null,0.06,6.5000000000000002E-2,7.0000000000000007E-2,0.09,0.1]
[null,"Secondary with sixth form","Medium","High FSM","Pupil to teacher ratio",12.5,13,14,14.5,15,16.5,17]
[null,"Secondary with sixth form","Medium","High FSM","Pupil to adult ratio",7,8,8.5,9,9,9.5,10.5]
[null,"Secondary with sixth form","Medium","High FSM","Average class size",18,18.5,19.5,20,20.5,21.5,22.5]
[]
[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",0.47499999999999998,0.5,0.52500000000000002,0.53,0.55500000000000005,0.57999999999999996,0.61]
[null,"Secondary with sixth form","Large","High FSM","Spend on supply staff as a percentage of total expenditure",null,null,1.4999999999999999E-2,0.02,2.5000000000000001E-2,3.5000000000000003E-2,4.4999999999999998E-2]
[null,"Secondary with sixth form","Large","High FSM","Spend on education support staff as a percentage of total expenditure",null,null,0.1,0.105,0.115,0.13500000000000001,0.14000000000000001]
[null,"Secondary with sixth form","Large","High FSM","Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,0.06,null,0.08,0.09]
[null,"Secondary with sixth form","Large","High FSM","Spend on other staff costs as a percentage of total expenditure",null,null,null,1.4999999999999999E-2,null,0.03,0.05]
[null,"Secondary with sixth form","Large","High FSM","Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,0.05,null,7.4999999999999997E-2,0.11]
[null,"Secondary with sixth form","Large","High FSM","Spend on teaching resources as a percentage of total expenditure",0.04,0.05,5.5E-2,0.06,0.06]
[null,"Secondary with sixth form","Large","High FSM","Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Secondary with sixth form","Large","High FSM","Senior leaders as a percentage of workforce",null,null,0.05,5.5E-2,0.06,7.4999999999999997E-2,0.09]
[null,"Secondary with sixth form","Large","High FSM","Pupil to teacher ratio",13.5,14,15,15,15.5,16.5,17]
[null,"Secondary with sixth form","Large","High FSM","Pupil to adult ratio",7.5,8.5,9,9.5,9.5,10,10.5]
[null,"Secondary with sixth form","Large","High FSM","Average class size",18.5,19,20,20.5,20.5,22,22.5]
[]
[51,"Secondary without sixth form","Small","High FSM","SSH"]
[null,"Secondary without sixth form","Small","High FSM","Spend on teaching staff as a percentage of total expenditure",0.4,0.42499999999999999,0.46500000000000002,0.48499999999999999,0.5,0.53,0.57499999999999996]
[null,"Secondary without sixth form","Small","High FSM","Spend on supply staff as a percentage of total expenditure",null,null,1.4999999999999999E-2,2.5000000000000001E-2,0.03,4.4999999999999998E-2,6.5000000000000002E-2]
[null,"Secondary without sixth form","Small","High FSM","Spend on education support staff as a percentage of total expenditure",null,null,0.09,0.1,0.115,0.14000000000000001,0.16500000000000001]
[null,"Secondary without sixth form","Small","High FSM","Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,7.4999999999999997E-2,null,0.105,0.115]
[null,"Secondary without sixth form","Small","High FSM","Spend on other staff costs as a percentage of total expenditure",null,null,null,1.4999999999999999E-2,null,3.5000000000000003E-2,0.05]
[null,"Secondary without sixth form","Small","High FSM","Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,6.5000000000000002E-2,null,8.5000000000000006E-2,9.5000000000000001E-2]
[null,"Secondary without sixth form","Small","High FSM","Spend on teaching resources as a percentage of total expenditure",2.5000000000000001E-2,0.04,0.05,5.5E-2,0.06]
[null,"Secondary without sixth form","Small","High FSM","Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Secondary without sixth form","Small","High FSM","Senior leaders as a percentage of workforce",null,null,0.08,8.5000000000000006E-2,9.5000000000000001E-2,0.125,0.14000000000000001]
[null,"Secondary without sixth form","Small","High FSM","Pupil to teacher ratio",10.5,12,13,13.5,14,16,17]
[null,"Secondary without sixth form","Small","High FSM","Pupil to adult ratio",5.5,6.5,7,7.5,8,9,10]
[null,"Secondary without sixth form","Small","High FSM","Average class size",17.5,18,20.5,21,21.5,23.5,24.5]
[]
[114,"Secondary without sixth form","Medium","High FSM","SMH"]
[null,"Secondary without sixth form","Medium","High FSM","Spend on teaching staff as a percentage of total expenditure",0.44,0.46500000000000002,0.49,0.505,0.51500000000000001,0.55000000000000004,0.57999999999999996]
[null,"Secondary without sixth form","Medium","High FSM","Spend on supply staff as a percentage of total expenditure",null,null,1.4999999999999999E-2,0.02,2.5000000000000001E-2,0.04,4.4999999999999998E-2]
[null,"Secondary without sixth form","Medium","High FSM","Spend on education support staff as a percentage of total expenditure",null,null,0.105,0.11,0.12,0.14000000000000001,0.16]
[null,"Secondary without sixth form","Medium","High FSM","Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,6.5000000000000002E-2,null,8.5000000000000006E-2,0.105]
[null,"Secondary without sixth form","Medium","High FSM","Spend on other staff costs as a percentage of total expenditure",null,null,null,1.4999999999999999E-2,null,0.03,4.4999999999999998E-2]
[null,"Secondary without sixth form","Medium","High FSM","Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,0.06,null,0.09,0.14499999999999999]
[null,"Secondary without sixth form","Medium","High FSM","Spend on teaching resources as a percentage of total expenditure",3.5000000000000003E-2,0.04,0.05,0.06,6.5000000000000002E-2]
[null,"Secondary without sixth form","Medium","High FSM","Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Secondary without sixth form","Medium","High FSM","Senior leaders as a percentage of workforce",null,null,6.5000000000000002E-2,7.0000000000000007E-2,7.4999999999999997E-2,9.5000000000000001E-2,0.105]
[null,"Secondary without sixth form","Medium","High FSM","Pupil to teacher ratio",13,14,15,15,15.5,17,18]
[null,"Secondary without sixth form","Medium","High FSM","Pupil to adult ratio",7,7.5,8,8.5,9,9.5,10]
[null,"Secondary without sixth form","Medium","High FSM","Average class size",19.5,20.5,21.5,22,22.5,23.5,24]
[]
[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",0.435,0.46500000000000002,0.48499999999999999,0.495,0.51,0.54500000000000004,0.56000000000000005]
[null,"Secondary without sixth form","Large","High FSM","Spend on supply staff as a percentage of total expenditure",null,null,0.02,0.02,0.03,4.4999999999999998E-2,0.06]
[null,"Secondary without sixth form","Large","High FSM","Spend on education support staff as a percentage of total expenditure",null,null,9.5000000000000001E-2,0.105,0.125,0.14499999999999999,0.16]
[null,"Secondary without sixth form","Large","High FSM","Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,0.06,null,0.08,0.1]
[null,"Secondary without sixth form","Large","High FSM","Spend on other staff costs as a percentage of total expenditure",null,null,null,0.02,null,0.04,7.0000000000000007E-2]
[null,"Secondary without sixth form","Large","High FSM","Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,0.06,null,8.5000000000000006E-2,0.125]
[null,"Secondary without sixth form","Large","High FSM","Spend on teaching resources as a percentage of total expenditure",0.04,0.05,5.5E-2,0.06,0.06]
[null,"Secondary without sixth form","Large","High FSM","Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Secondary without sixth form","Large","High FSM","Senior leaders as a percentage of workforce",null,null,5.5E-2,0.06,7.0000000000000007E-2,0.08,0.1]
[null,"Secondary without sixth form","Large","High FSM","Pupil to teacher ratio",13.5,14.5,15.5,15.5,16,17.5,19.5]
[null,"Secondary without sixth form","Large","High FSM","Pupil to adult ratio",7,7.5,8.5,9,9,10,11]
[null,"Secondary without sixth form","Large","High FSM","Average class size",20,21.5,22,23,23,24,25]
[]
[]
["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",0.27,0.3,0.34499999999999997,0.36,0.38,0.43,0.47]
[null,"Special","London",null,"Spend on supply staff as a percentage of total expenditure",null,null,1.4999999999999999E-2,0.02,2.5000000000000001E-2,4.4999999999999998E-2,7.0000000000000007E-2]
[null,"Special","London",null,"Spend on education support staff as a percentage of total expenditure",null,null,0.28999999999999998,0.32,0.34,0.39,0.41499999999999998]
[null,"Special","London",null,"Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,4.4999999999999998E-2,null,6.5000000000000002E-2,0.08]
[null,"Special","London",null,"Spend on other staff costs as a percentage of total expenditure",null,null,null,0.03,null,0.05,7.0000000000000007E-2]
[null,"Special","London",null,"Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,0.05,null,6.5000000000000002E-2,0.08]
[null,"Special","London",null,"Spend on teaching resources as a percentage of total expenditure",0.02,2.5000000000000001E-2,3.5000000000000003E-2,3.5000000000000003E-2,0.04]
[null,"Special","London",null,"Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Special","London",null,"Senior leaders as a percentage of workforce",null,null,0.05,5.5E-2,6.5000000000000002E-2,8.5000000000000006E-2,0.105]
[null,"Special","London",null,"Pupil to teacher ratio",4,5,6,6.5,7,7.5,8.5]
[null,"Special","London",null,"Pupil to adult ratio",1.3,1.5,1.7,2,2,2.5,2.7]
[null,"Special","London",null,"Average teacher cost (£)",52000,57000,62500,65000,67500,73000,78500]
[]
[774,"Special","Non-London",null,"SPNL"]
[null,"Special","Non-London",null,"Spend on teaching staff as a percentage of total expenditure",0.27,0.3,0.34499999999999997,0.36,0.38,0.43,0.47]
[null,"Special","Non-London",null,"Spend on supply staff as a percentage of total expenditure",null,null,1.4999999999999999E-2,0.02,2.5000000000000001E-2,4.4999999999999998E-2,7.0000000000000007E-2]
[null,"Special","Non-London",null,"Spend on education support staff as a percentage of total expenditure",null,null,0.28999999999999998,0.32,0.34,0.39,0.41499999999999998]
[null,"Special","Non-London",null,"Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,4.4999999999999998E-2,null,6.5000000000000002E-2,0.08]
[null,"Special","Non-London",null,"Spend on other staff costs as a percentage of total expenditure",null,null,null,0.03,null,0.05,7.0000000000000007E-2]
[null,"Special","Non-London",null,"Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,0.05,null,6.5000000000000002E-2,0.08]
[null,"Special","Non-London",null,"Spend on teaching resources as a percentage of total expenditure",0.02,2.5000000000000001E-2,3.5000000000000003E-2,3.5000000000000003E-2,0.04]
[null,"Special","Non-London",null,"Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Special","Non-London",null,"Senior leaders as a percentage of workforce",null,null,0.05,5.5E-2,6.5000000000000002E-2,8.5000000000000006E-2,0.105]
[null,"Special","Non-London",null,"Pupil to teacher ratio",4,5,6,6.5,7,7.5,8.5]
[null,"Special","Non-London",null,"Pupil to adult ratio",1.3,1.5,1.7,2,2,2.5,2.7]
[null,"Special","Non-London",null,"Average teacher cost (£)",49500,53000,56000,58000,59500,63500,67000]
[]
[48,"Alternative provision","London",null,"APL"]
[null,"Alternative provision","London",null,"Spend on teaching staff as a percentage of total expenditure",0.28499999999999998,0.34,0.40500000000000003,0.44,0.47,0.54500000000000004,0.60499999999999998]
[null,"Alternative provision","London",null,"Spend on supply staff as a percentage of total expenditure",null,null,2.5000000000000001E-2,0.04,5.5E-2,9.5000000000000001E-2,0.13]
[null,"Alternative provision","London",null,"Spend on education support staff as a percentage of total expenditure",null,null,0.15,0.17,0.19500000000000001,0.23499999999999999,0.28000000000000003]
[null,"Alternative provision","London",null,"Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,0.06,null,0.09,0.105]
[null,"Alternative provision","London",null,"Spend on other staff costs as a percentage of total expenditure",null,null,null,0.02,null,3.5000000000000003E-2,0.06]
[null,"Alternative provision","London",null,"Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,0.04,null,5.5E-2,6.5000000000000002E-2]
[null,"Alternative provision","London",null,"Spend on teaching resources as a percentage of total expenditure",0.02,2.5000000000000001E-2,3.5000000000000003E-2,4.4999999999999998E-2,5.5E-2]
[null,"Alternative provision","London",null,"Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Alternative provision","London",null,"Senior leaders as a percentage of workforce",null,null,0.09,0.1,0.115,0.155,0.19]
[null,"Alternative provision","London",null,"Pupil to teacher ratio",3,3.5,4.5,5,6,8,10]
[null,"Alternative provision","London",null,"Pupil to adult ratio",1.3,1.5,2,2.5,2.5,3.5,4]
[null,"Alternative provision","London",null,"Average teacher cost (£)",43500,52500,61000,65500,67000,79000,87000]
[]
[269,"Alternative provision","Non-London",null,"APNL"]
[null,"Alternative provision","Non-London",null,"Spend on teaching staff as a percentage of total expenditure",0.28499999999999998,0.34,0.40500000000000003,0.44,0.47,0.54500000000000004,0.60499999999999998]
[null,"Alternative provision","Non-London",null,"Spend on supply staff as a percentage of total expenditure",null,null,2.5000000000000001E-2,0.04,5.5E-2,9.5000000000000001E-2,0.13]
[null,"Alternative provision","Non-London",null,"Spend on education support staff as a percentage of total expenditure",null,null,0.15,0.17,0.19500000000000001,0.23499999999999999,0.28000000000000003]
[null,"Alternative provision","Non-London",null,"Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,0.06,null,0.09,0.105]
[null,"Alternative provision","Non-London",null,"Spend on other staff costs as a percentage of total expenditure",null,null,null,0.02,null,3.5000000000000003E-2,0.06]
[null,"Alternative provision","Non-London",null,"Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,0.04,null,5.5E-2,6.5000000000000002E-2]
[null,"Alternative provision","Non-London",null,"Spend on teaching resources as a percentage of total expenditure",0.02,2.5000000000000001E-2,3.5000000000000003E-2,4.4999999999999998E-2,5.5E-2]
[null,"Alternative provision","Non-London",null,"Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Alternative provision","Non-London",null,"Senior leaders as a percentage of workforce",null,null,0.09,0.1,0.115,0.155,0.19]
[null,"Alternative provision","Non-London",null,"Pupil to teacher ratio",3,3.5,4.5,5,6,8,10]
[null,"Alternative provision","Non-London",null,"Pupil to adult ratio",1.3,1.5,2,2.5,2.5,3.5,4]
[null,"Alternative provision","Non-London",null,"Average teacher cost (£)",45000,52000,56500,59000,61000,67000,77000]
[]
[47,"All-through","London",null,"ATL"]
[null,"All-through","London",null,"Spend on teaching staff as a percentage of total expenditure",0.40500000000000003,0.45,0.5,0.52,0.53500000000000003,0.59,0.61]
[null,"All-through","London",null,"Spend on supply staff as a percentage of total expenditure",null,null,0.02,2.5000000000000001E-2,0.03,4.4999999999999998E-2,0.06]
[null,"All-through","London",null,"Spend on education support staff as a percentage of total expenditure",null,null,0.105,0.115,0.125,0.155,0.18]
[null,"All-through","London",null,"Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,0.06,null,8.5000000000000006E-2,0.105]
[null,"All-through","London",null,"Spend on other staff costs as a percentage of total expenditure",null,null,null,0.02,null,3.5000000000000003E-2,5.5E-2]
[null,"All-through","London",null,"Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,0.05,null,7.0000000000000007E-2,0.09]
[null,"All-through","London",null,"Spend on teaching resources as a percentage of total expenditure",3.5000000000000003E-2,0.04,0.05,5.5E-2,0.06]
[null,"All-through","London",null,"Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"All-through","London",null,"Senior leaders as a percentage of workforce",null,null,6.5000000000000002E-2,7.0000000000000007E-2,7.4999999999999997E-2,0.1,0.11]
[null,"All-through","London",null,"Pupil to teacher ratio",13.5,14.5,16,16.5,17,18,19]
[null,"All-through","London",null,"Pupil to adult ratio",7,7.5,8.5,9,9,10,10.5]
[null,"All-through","London",null,"Average class size",19,20.5,22.5,23,23.5,25,26]
[null,"All-through","London",null,"Average teacher cost (£)",53500,57000,62500,64000,66000,72000,76000]
[]
[96,"All-through","Non-London",null,"ATNL"]
[null,"All-through","Non-London",null,"Spend on teaching staff as a percentage of total expenditure",0.40500000000000003,0.45,0.5,0.52,0.53500000000000003,0.59,0.61]
[null,"All-through","Non-London",null,"Spend on supply staff as a percentage of total expenditure",null,null,0.02,2.5000000000000001E-2,0.03,4.4999999999999998E-2,0.06]
[null,"All-through","Non-London",null,"Spend on education support staff as a percentage of total expenditure",null,null,0.105,0.115,0.125,0.155,0.18]
[null,"All-through","Non-London",null,"Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,0.06,null,8.5000000000000006E-2,0.105]
[null,"All-through","Non-London",null,"Spend on other staff costs as a percentage of total expenditure",null,null,null,0.02,null,3.5000000000000003E-2,5.5E-2]
[null,"All-through","Non-London",null,"Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,0.05,null,7.0000000000000007E-2,0.09]
[null,"All-through","Non-London",null,"Spend on teaching resources as a percentage of total expenditure",3.5000000000000003E-2,0.04,0.05,5.5E-2,0.06]
[null,"All-through","Non-London",null,"Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"All-through","Non-London",null,"Senior leaders as a percentage of workforce",null,null,6.5000000000000002E-2,7.0000000000000007E-2,7.4999999999999997E-2,0.1,0.11]
[null,"All-through","Non-London",null,"Pupil to teacher ratio",13.5,14.5,16,16.5,17,18,19]
[null,"All-through","Non-London",null,"Pupil to adult ratio",7,7.5,8.5,9,9,10,10.5]
[null,"All-through","Non-London",null,"Average class size",19,20.5,22.5,23,23.5,25,26]
[null,"All-through","Non-London",null,"Average teacher cost (£)",43500,48500,52500,54000,56000,59500,63500]
[]
[78,"Nursery","London",null,"NL"]
[null,"Nursery","London",null,"Spend on teaching staff as a percentage of total expenditure",0.16,0.19500000000000001,0.245,0.26,0.28999999999999998,0.34,0.38]
[null,"Nursery","London",null,"Spend on supply staff as a percentage of total expenditure",null,null,5.0000000000000001E-3,0.01,1.4999999999999999E-2,0.03,0.05]
[null,"Nursery","London",null,"Spend on education support staff as a percentage of total expenditure",null,null,0.29499999999999998,0.33500000000000002,0.36,0.43,0.47499999999999998]
[null,"Nursery","London",null,"Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,6.5000000000000002E-2,null,9.5000000000000001E-2,0.115]
[null,"Nursery","London",null,"Spend on other staff costs as a percentage of total expenditure",null,null,null,0.03,null,5.5E-2,0.08]
[null,"Nursery","London",null,"Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,0.05,null,7.0000000000000007E-2,0.09]
[null,"Nursery","London",null,"Spend on teaching resources as a percentage of total expenditure",0.01,1.4999999999999999E-2,0.02,0.02,2.5000000000000001E-2]
[null,"Nursery","London",null,"Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Nursery","London",null,"Senior leaders as a percentage of workforce",null,null,8.5000000000000006E-2,9.5000000000000001E-2,0.105,0.14000000000000001,0.17499999999999999]
[null,"Nursery","London",null,"Pupil to teacher ratio",13.5,16,20,21.5,23,29,34]
[null,"Nursery","London",null,"Pupil to adult ratio",3,3.5,4.5,4.5,5,6,7]
[null,"Nursery","London",null,"Average teacher cost (£)",45500,55500,62500,66000,69000,77500,83000]
[]
[315,"Nursery","Non-London",null,"NNL"]
[null,"Nursery","Non-London",null,"Spend on teaching staff as a percentage of total expenditure",0.16,0.19500000000000001,0.245,0.26,0.28999999999999998,0.34,0.38]
[null,"Nursery","Non-London",null,"Spend on supply staff as a percentage of total expenditure",null,null,5.0000000000000001E-3,0.01,1.4999999999999999E-2,0.03,0.05]
[null,"Nursery","Non-London",null,"Spend on education support staff as a percentage of total expenditure",null,null,0.29499999999999998,0.33500000000000002,0.36,0.43,0.47499999999999998]
[null,"Nursery","Non-London",null,"Spend on administrative and clerical staff as a percentage of total expenditure",null,null,null,6.5000000000000002E-2,null,9.5000000000000001E-2,0.115]
[null,"Nursery","Non-London",null,"Spend on other staff costs as a percentage of total expenditure",null,null,null,0.03,null,5.5E-2,0.08]
[null,"Nursery","Non-London",null,"Spend on premises (including staff costs) as a percentage of total expenditure",null,null,null,0.05,null,7.0000000000000007E-2,0.09]
[null,"Nursery","Non-London",null,"Spend on teaching resources as a percentage of total expenditure",0.01,1.4999999999999999E-2,0.02,0.02,2.5000000000000001E-2]
[null,"Nursery","Non-London",null,"Spend on energy as a percentage of total expenditure",null,null,null,0.01,null,1.4999999999999999E-2,0.02]
[null,"Nursery","Non-London",null,"Senior leaders as a percentage of workforce",null,null,8.5000000000000006E-2,9.5000000000000001E-2,0.105,0.14000000000000001,0.17499999999999999]
[null,"Nursery","Non-London",null,"Pupil to teacher ratio",13.5,16,20,21.5,23,29,34]
[null,"Nursery","Non-London",null,"Pupil to adult ratio",3,3.5,4.5,4.5,5,6,7]
[null,"Nursery","Non-London",null,"Average teacher cost (£)",44000,52500,56500,60000,62000,68000,72500]
[]
["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"]
[1721,"Primary","London",null,"PL"]
[null,"Primary","London",null,"Average teacher cost (£)",49000,52000,56000,57500,59000,64000,68500]
[]
[13651,"Primary","Non-London",null,"PNL"]
[null,"Primary","Non-London",null,"Average teacher cost (£)",44000,47000,50000,51500,53000,56500,60000]
[]
[328,"Secondary with sixth form","London",null,"SSLo"]
[null,"Secondary with sixth form","London",null,"Average teacher cost (£)",56000,59000,61500,63000,64500,68500,73000]
[]
[1861,"Secondary with sixth form","Non-London",null,"SSNL"]
[null,"Secondary with sixth form","Non-London",null,"Average teacher cost (£)",51000,53500,56000,57000,58000,60500,62500]
[]
[96,"Secondary without sixth form","London",null,"SL"]
[null,"Secondary without sixth form","London",null,"Average teacher cost (£)",53500,58000,62500,64500,66500,71500,80000]
[]
[678,"Secondary without sixth form","Non-London",null,"SNL"]
[null,"Secondary without sixth form","Non-London",null,"Average teacher cost (£)",50000,52500,55500,56500,57500,60500,65000]

{"sheet":"Calcs","index":6,"n_rows":66,"n_cols":27,"rows_kept":66,"cut":false,"hidden":true,"merged":[]}
[]
["RAG ratings for each school"]
[]
[null,null,1]
[null,null,{"$f":"IF(Dashboard!D17=\"Primary\",\"P\",IF(Dashboard!D17=\"Secondary with sixth form\",\"SS\",IF(Dashboard!D17=\"Secondary without sixth form\",\"S\",IF(Dashboard!D17=\"Special\",\"SP\",IF(Dashboard!D17=\"Alternative provision\",\"AP\",IF(Dashboard!D17=\"All-through\",\"AT\",IF(Dashboard!D17=\"Nursery\",\"N\")))))))","v":"P"}]
[null,null,{"$f":"C5&\nIF($J29=\"very small\",\"VS\",IF($J29=\"small\",\"S\",IF($J29=\"medium\",\"M\",IF($J29=\"large\",\"L\"))))&\nIF($K29=\"low levels of FSM\",\"L\",IF($K29=\"medium levels of FSM\",\"M\",IF($K29=\"high levels of FSM\",\"H\")))","v":"PLH"}]
[null,null,{"$f":"C5&\nIF(AND(C5=\"SS\",$I29=\"in London\"),\"Lo\",IF($I29=\"in London\",\"L\",IF($I29=\"outside London\",\"NL\")))","v":"PNL"}]
[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":0.35499999999999998},0.38,0.41,0.42499999999999999,0.435,0.46500000000000002,0.49]
["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":0.02},2.5000000000000001E-2,0.03,4.4999999999999998E-2,0.06]
["Spend on education support staff as a percentage of total expenditure",3,null,null,0.19500000000000001,0.20499999999999999,0.22,0.25,0.26500000000000001]
["Spend on administrative and clerical staff as a percentage of total expenditure",4,null,null,null,{"$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":4.4999999999999998E-2},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":0.06},{"$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":7.4999999999999997E-2}]
["Spend on other staff costs as a percentage of total expenditure",5,null,null,null,3.5000000000000003E-2,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":4.4999999999999998E-2},{"$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":0.06}]
["Spend on premises (including staff costs) as a percentage of total expenditure",6,null,null,null,0.05,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":7.0000000000000007E-2},0.08]
["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":2.5000000000000001E-2},{"$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":0.03},{"$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":0.04},{"$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":4.4999999999999998E-2},{"$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":0.05}]
["Spend on energy as a percentage of total expenditure",8,null,null,null,0.01,null,1.4999999999999999E-2,0.02]
["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":6.5000000000000002E-2},7.0000000000000007E-2,{"$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":7.4999999999999997E-2},0.09,0.105]
["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":17},{"$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":18},{"$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":20},20.5,{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$6),$B18,G$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"AT\",$C$5=\"SP\"),INDEX(INDIRECT($C$7),$B18,G$8)))","v":21},23,24.5]
["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":7},{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$6),$B19,D$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"AT\",$C$5=\"SP\"),INDEX(INDIRECT($C$7),$B19,D$8)))","v":7.5},{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$6),$B19,E$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"AT\",$C$5=\"SP\"),INDEX(INDIRECT($C$7),$B19,E$8)))","v":8},8.5,{"$f":"IF(OR($C$5=\"P\",$C$5=\"SS\",$C$5=\"S\"),INDEX(INDIRECT($C$6),$B19,G$8),\nIF(OR($C$5=\"N\",$C$5=\"AP\",$C$5=\"AT\",$C$5=\"SP\"),INDEX(INDIRECT($C$7),$B19,G$8)))","v":9},9.5,10.5]
["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":24.5},25.5,27,27.5,28,29,29.5]
["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":44000},{"$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":47000},50000,51500,53000,56500,60000]
[]
[]
[]
[]
["Information for the 'RAG rating data for your school' look ups"]
[]
["School name from dashboard",null,null,"Named ranges for RAG ratings above","School information from dashboard",null,null,null,"Info for comparison description"]
[{"$f":"IF(Dashboard!D$15=0,\"\",Dashboard!D$15)","v":"Furzefield Primary School"},1,"H","A",{"$f":"IF(Dashboard!D$17=0,\"\",Dashboard!D$17)","v":"Primary"},{"$f":"IF(Dashboard!D$18=0,\"\",Dashboard!D$18)","v":"South East"},{"$f":"IF(Dashboard!D$19=0,\"\",Dashboard!D$19)","v":459},{"$f":"IF(Dashboard!D$20=0,\"\",Dashboard!D$20)","v":0.1983},{"$f":"IF(F29=\"\",\"\",IF(OR(F29=\"Inner London\",F29=\"Outer London\"),\"in London\",\"outside London\"))","v":"outside London"},{"$f":"IF(AND(E29=\"Primary\",G29<=$X$30),\"very small\",IF(AND(E29=\"Primary\",G29<=$Y$30,G29>$X$30),\"small\",IF(AND(E29=\"Primary\",G29>$Y$30,G29<=$Z$30),\"medium\",IF(AND(E29=\"Primary\",G29>$Z$30),\"large\",\nIF(AND(E29=\"Secondary with sixth form\",G29<=$Y$31),\"small\",IF(AND(E29=\"Secondary with sixth form\",G29>$Y$31,G29<=$Z$31),\"medium\",IF(AND(E29=\"Secondary with sixth form\",G29>$Z$31),\"large\",\nIF(AND(E29=\"Secondary without sixth form\",G29<=$Y$32),\"small\",IF(AND(E29=\"Secondary without sixth form\",G29>$Y$32,G29<=$Z$32),\"medium\",IF(AND(E29=\"Secondary without sixth form\",G29>$Z$32),\"large\",\"\"))))))))))","v":"large"},{"$f":"IF(AND(E29=\"Primary\",H29<=$X$35),\"low levels of FSM\",IF(AND(E29=\"Primary\",H29>$X$35,H29<=$Y$35),\"medium levels of FSM\",IF(AND(E29=\"Primary\",H29>$Y$35),\"high levels of FSM\",\nIF(AND(E29=\"Secondary with sixth form\",H29<=$X$36),\"low levels of FSM\",IF(AND(E29=\"Secondary with sixth form\",H29>$X$36,H29<=$Y$36),\"medium levels of FSM\",IF(AND(E29=\"Secondary with sixth form\",H29>$Y$36),\"high levels of FSM\",\nIF(AND(E29=\"Secondary without sixth form\",H29<=$X$37),\"low levels of FSM\",IF(AND(E29=\"Secondary without sixth form\",H29>$X$37,H29<=$Y$37),\"medium levels of FSM\",IF(AND(E29=\"Secondary without sixth form\",H29>$Y$37),\"high levels of FSM\",\"\")))))))))","v":"high levels of FSM"},{"$f":"IF(E29=\"Primary\",\"a primary school\",IF(E29=\"Secondary with sixth form\",\"a secondary school with a sixth form\",IF(E29=\"Secondary without sixth form\",\"a secondary school without a sixth form\",IF(E29=\"Special\",\"a special school\",IF(E29=\"Alternative provision\",\"an alternative provision school\",IF(E29=\"All-through\",\"an all-through school\",IF(E29=\"Nursery\",\"a nursery school\",\"\")))))))","v":"a primary school"},{"$f":"IF(AND(E29=\"Primary\",J29=\"very small\"),$X$30&\" or fewer pupils\",\nIF(AND(E29=\"Primary\",J29=\"small\"),\"between \"&$X$30+1&\" and \"&$Y$30&\" pupils\",\nIF(AND(E29=\"Primary\",J29=\"medium\"),\"between \"&$Y$30+1&\" and \"&$Z$30&\" pupils\",\nIF(AND(E29=\"Primary\",J29=\"large\"),\"more than \"&$Z$30&\" pupils\",\n\nIF(AND(E29=\"Secondary with sixth form\",J29=\"small\"),$Y$31&\" or fewer pupils\",\nIF(AND(E29=\"Secondary with sixth form\",J29=\"medium\"),\"between \"&$Y$31+1&\" and \"&$Z$31&\" pupils\",\nIF(AND(E29=\"Secondary with sixth form\",J29=\"large\"),\"more than \"&$Z$31&\" pupils\",\n\nIF(AND(E29=\"Secondary without sixth form\",J29=\"small\"),$Y$32&\" or fewer pupils\",\nIF(AND(E29=\"Secondary without sixth form\",J29=\"medium\"),\"between \"&$Y$32+1&\" and \"&$Z$32&\" pupils\",\nIF(AND(E29=\"Secondary without sixth form\",J29=\"large\"),\"more than \"&$Z$32&\" pupils\",\"\"))))))))))","v":"more than 385 pupils"},{"$f":"IF(AND(E29=\"Primary\",K29=\"low levels of FSM\"),\"less than \"&$Z$35&\" of pupils\",\nIF(AND(E29=\"Primary\",K29=\"medium levels of FSM\"),\"between \"&$Z$35&\" and \"&$AA$35&\" of pupils\",\nIF(AND(E29=\"Primary\",K29=\"high levels of FSM\"),\"more than \"&$AA$35&\" of pupils\",\n\nIF(AND(E29=\"Secondary with sixth form\",K29=\"low levels of FSM\"),\"less than \"&$Z$36&\" of pupils\",\nIF(AND(E29=\"Secondary with sixth form\",K29=\"medium levels of FSM\"),\"between \"&$Z$36&\" and \"&$AA$36&\" of pupils\",\nIF(AND(E29=\"Secondary with sixth form\",K29=\"high levels of FSM\"),\"more than \"&$AA$36&\" of pupils\",\n\nIF(AND(E29=\"Secondary without sixth form\",K29=\"low levels of FSM\"),\"less than \"&$Z$37&\" of pupils\",\nIF(AND(E29=\"Secondary without sixth form\",K29=\"medium levels of FSM\"),\"between \"&$Z$37&\" and \"&$AA$37&\" of pupils\",\nIF(AND(E29=\"Secondary without sixth form\",K29=\"high levels of FSM\"),\"more than \"&$AA$37&\" of pupils\",\"\")))))))))","v":"more than 18% of pupils"},null,null,null,null,null,null,null,null,null,"Very small","Small","Medium"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Primary",100,175,385]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Secondary with sixth form",null,770,1300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Secondary without sixth form",null,485,935]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Low","Medium"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Primary",0.05,0.18,{"$f":"(X35*100)&\"%\"","v":"5%"},"18%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Secondary with sixth form",0.06,0.16500000000000001,"6%","16.5%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Secondary without sixth form",0.08,0.215,"8%","21.5%"]
[]
[]
[]
[]
[]
["RAG rating text for dashboard"]
[]
["Lowest 10% of similar schools","Much lower than recommended"]
["Lowest 20% of similar schools","Lower than recommended"]
["Broadly in line with similar schools","Broadly in line with recommendations"]
["Middle 20% of similar schools","Higher than recommended"]
["Highest 20% of similar schools","Much higher than recommended"]
["Highest 10% of similar schools"]
[null,"Inadequate"]
[null,"Requires Improvement"]
["High risk","Good"]
["Medium risk","Outstanding"]
["Low risk"]
[null,"Well below average"]
[null,"Below average"]
[null,"Average or above average"]
[null,"Well above average"]
[]
[]
["Primary"]
["Secondary with sixth form"]
["Secondary without sixth form"]
["All-through"]
[{"$f":"\"\"","v":""}]