{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Guidance","BCM Criteria","Form","Lookup"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":5,"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":"Guidance","index":0,"n_rows":45,"n_cols":2,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Guidance for the Nine Months Monitoring Budget Control Mechanism (BCM) form"]
[]
[null,"ONLY USE THIS FORM FOR THE SUBMISSION OF YOUR NINE MONTH BCM FORM TO SCHOOLS FINANCIAL SERVICES"]
[]
[null,"Instructions for completion."]
[]
[null,"Enter the last four digits of you DfE number in cell E1 (the green box), your school name will be displayed."]
[]
[null,"Section 1"]
[]
[null,"From your Nine Months Monitoring Report, enter the final Year End forecast figures for the CFR codes listed."]
[null,"Only enter a figure against E17 Rates if you have not completed your I01 / E17 adjustment journal."]
[null,"For I18, only enter the figures for I18 specifically. DO NOT include I18a, I18b or I18c."]
[null,"All figures must be entered as positive figures."]
[]
[null,"The total of these five figures will be displayed in A (cell E11).  The figure in B (cell E12) is your Budget Control Mechanism limit."]
[null,"The BCM figure is generated by multiplying the figure in A by the threshold figure allocated to your school type."]
[]
[null,"Section 2"]
[]
[null,"Enter your forecast Revenue Year End Rollover figure into C (cell E14). Note: D (cell C15) is populated from B (cell E11) above."]
[null,"If there is a figure in E (cell E17), this indicates you will exceed your BCM limit."]
[]
[null,"Section 2.1 and Section 4 - Only applicable if you exceed your BCM limit"]
[]
[null,"J (cell E23) displays the balance of the amount over the BCM limit that has not been allocated across F to I."]
[null,"A prompt box will appear to the right. An amber box indicates you have not allocated enough across F to I, a red box indicates you have allocated too much."]
[null,"When F to I equal the amount over BCM, there will be no amber or red box and J (cell E23) will be zero. This section is now balanced."]
[null,"D (cell E24) and C (cell E25) are populated from Section 2 above."]
[null,"Whichever rows you have used from (F to I), a prompt will appear to the right indicating which sections of Section 4 below need to be completed."]
[null,"Once the figures entered into Sections 4.1 to 4.4 equal the corresponding figures in F to I, the prompts will disappear."]
[]
[null,"Section 3"]
[]
[null,"The B01 to B06 references are for DfE purposes only"]
[null,"K (cell E27) is populated from section 2.1, if you have not exceeded your BCM limit, this cell will be zero."]
[null,"L (cell E28) is for your Community Focussed balance only."]
[null,"This is calculated by the following formula (Previous years B06 rollover + I16 + I17 - E31 - E32 from Monitoring Report), there is a prompt on the form."]
[null,"The Previous years B06 rollover figure can be obtained for the previous years closedown outturn report."]
[]
[null,"The remaining revenue rollover from C (cell E15) now needs to be split between Committed M (Cell E29) and Non Committed N (cell E30)"]
[null,"O (cell E31) is the total of K to N, this must equal C (cell E15). A prompt will appear to the right of O indicating if you need to allocate more or less to equal C."]
[]
[null,"When there are no prompts visible and \"CORRECT\" appears to the right of O, the form is complete."]

{"sheet":"BCM Criteria","index":1,"n_rows":71,"n_cols":17,"rows_kept":71,"cut":false,"hidden":false,"merged":[[68,2,68,14],[70,2,70,14],[56,1,56,14],[58,2,58,14],[60,2,60,14],[62,2,62,14],[64,2,64,14],[66,2,66,14],[52,2,52,14],[1,1,1,14],[2,1,2,14],[6,1,6,14],[8,1,8,14],[12,1,12,14],[38,2,38,14],[40,2,40,14],[42,2,42,14],[44,2,44,14],[48,3,48,14],[50,3,50,14]]}
[]
[null,"Schools Financial Services Guidance"]
[null,"Balance Control Mechanism (BCM) Criteria - Which category to use? "]
[]
[null,"Introduction"]
[]
[null,"The Schools’ Funding Forum fundamental principle underpinning the BCM is that the funding received for the period (financial year April to March), which is predicated on the cohort of pupils at the school during that period, should be spent on those pupils during that period.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DD"]
[]
[null,"The allowable BCM Thresholds (12% - Primary, Special and PRU and 7.5% - Secondary) have been set to recognise the need of a financial tolerance, to enable an appropriate resource to ensure a smooth transition, when circumstances within the school change, for example a falling roll.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DD"]
[]
[null,"BCM Allowable Criteria"]
[]
[null,"There are four accepted criteria that allow schools to carry forward funding in excess of their Balance Control Mechanism (BCM) into the next financial year: Capital Projects, Holding Funds on Behalf of Other Schools, Late Allocations and Other Grants & Payments.  Outlined below are details of each of the criteria to assist schools who are over their BCM limit in completing the 9 month and Year end returns. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DDD"]
[]
[null,"Capital Project. "]
[]
[null,"·","Schools can be over the BCM if they plan to make a revenue to capital contribution for a future capital project that is planned for the following year."]
[]
[null,"·","The returns information must include details of the capital project as well as the expected completion date"]
[]
[null,"·","The full cost of the project is required, as well as details of how much of the excess BCM will be used to fund the project"]
[]
[null,"·","Copy invoices will be required on completion of the project"]
[]
[null,"·","Examples: Extension to the school building"]
[]
[null,"Funds Held on Behalf of Other Schools. "]
[]
[null,"·","Schools can be over the BCM if they are holding funds on behalf of other schools "]
[]
[null,"·","The returns information must include details of what the funds are being used for"]
[]
[null,"·","The returns information must include the current balance of the held funds and the date by which they need to be spent"]
[]
[null,"·","Examples: Collaborative Funding with Partnership School"]
[]
[null,"Late Allocation."]
[]
[null,"·","A Late Allocation is funding that has been received in the latter part of the year that was not included within the original budget or included as additional income to the yearend forecast within the budget monitoring.",null,null,null,null,null,null,null,null,null,null,null,null,null,"DD"]
[]
[null,"·","To be allowable, the Late Allocation must be unexpected new funding that the school has not had reasonable time in which to spend before the end of the financial year, and it has therefore been decided that only funding received between 1st December and 31st March will be considered e.g., an unexpected donation to the school.",null,null,null,null,null,null,null,null,null,null,null,null,null,"DDD"]
[null,null," "]
[null,"·","Any unexpected funding that is received prior to 1st December will not be allowable as a Late Allocation.",null,null,null,null,null,null,null,null,null,null,null,null,null,"D"]
[]
[null,"·","Funding that the school know they are due to receive will not be allowable as a Late Allocation even if this funding is not paid till a later date e.g., The 2nd instalment of Covid catch up paid in March was not counted as a Late Allocation because schools had been advised of the grant and it should have been included in the monitoring year end forecast.",null,null,null,null,null,null,null,null,null,null,null,null,null,"DDD"]
[]
[null,"·","High Needs Funding (HNF) and whether it can be included within the Late Allocation criteria:"]
[]
[null,null,null,"If HNF has been applied for in November for example, and confirmation that the school will receive funding has been given by 1st December, but the funding is not received into the school bank account until February/March Advance, then this will not be counted as a Late Allocation - as the advised expected income should have been included in the monitoring year end forecast.",null,null,null,null,null,null,null,null,null,null,null,null,"DDD"]
[]
[null,null,null,"However, if the school has a newly assessed pupil with unconfirmed funding or an annual pupil renewal with unconfirmed backpay, it is reasonable to not have included any additional funding into the monitoring year-end forecasts as the funding claimed cannot be assured.  Therefore, in these types of circumstances, the funding will be allowable under Late Allocations if it is paid after December 1st.",null,null,null,null,null,null,null,null,null,null,null,null,"DDD"]
[]
[null,"·","Each year there may be new funding streams.  Depending on the timing of the Government announcement, a decision will be made if the funding will be considered a Late Allocation or not.  Past examples have been Additional FSM Supplementary grant & Classcare Scheme Refund",null,null,null,null,null,null,null,null,null,null,null,null,null,"DD"]
[]
[null,"Other Grants and Payments.  "]
[]
[null,"In general, schools are expected to spend funding received in each financial year on the pupils attending in that period.  Please see below for details of common grants to ascertain whether they are eligible to meet the criteria for allowable excess BCM.  For some grants that are paid on an academic year, part (or in some cases all) of the funding would be allowable under the excess BCM criteria.  Schools should read the Government Conditions of Grant for each grant to ensure the funding is spent as appropriate and in a timely fashion.  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DDDD"]
[]
[null,"·","UIFSM is paid on an academic year.  The funding is unique due to an adjustment being made each July to ensure payments made up to the preceding March are correct, with schools using a Yearend adjustment at Closedown to balance the funds received to date. Therefore, any excess UIFSM funding is not allowable under the excess BCM criteria as the funding is a reimbursement for costs based across 2 census data. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"DDD"]
[]
[null,"·","HNF E3 is paid monthly.  Any unspent HNF is not allowable under the excess BCM criteria as it should be spent on each eligible pupil in that financial year to meet their agreed needs. Please refer to paragraph on HNF in Late Allocation section of this document for further clarity.",null,null,null,null,null,null,null,null,null,null,null,null,null,"DD"]
[]
[null,"·","Pupil Premium is paid to schools in 12 equal instalments.  The 2023-24 Conditions of Grant state that the grant does not have to be completely spent by schools in the financial year beginning 1 April 2023; some or all of it may be carried forward to future financial years. Any funding that is carried forward must be spent according to the conditions in this document.",null,null,null,null,null,null,null,null,null,null,null,null,null,"DDD"]
[]
[null,"·","Academic Grants e.g., PE and Sports Grant.  When grants are paid on an academic year (September - August), the school usually receives 2 instalments – one to cover the 7-month period September to March and a second to cover the 5-month period April to August, so crossing over the school financial year in April. This means that the April to August (5/12ths) payment is the second instalment of the previous academic year, and the September to March payment (7/12ths) is the first instalment of the current academic year.",null,null,null,null,null,null,null,null,null,null,null,null,null,"DDDD"]
[]
[null,null,"Schools should be spending the April to August payment by the August of that year because this is the final instalment for the current academic year’s funding – this portion of the funding will not be allowable under the ‘Other Grants & Payment’ criteria as a reason to be over BCM.  Note: If the 5/12ths second instalment has not been spent, then it will form part of the allowable BCM threshold. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"DDD"]
[]
[null,null,"For the September to March payment (7/12th), schools have until the August of the following year to spend it.  This portion of the funding can be rolled forward into the next financial year and is allowable under the criteria for excess BCM.",null,null,null,null,null,null,null,null,null,null,null,null,null,"DD"]
[]
[null,"·","We are aware that some Academic grants need the second instalment set aside for specific expenditure e.g., Teaching School funding, where funding is received in advance to pay for April to August salaries for the next financial year and this will be allowable as excess BCM. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"DD"]

{"sheet":"Form","index":2,"n_rows":57,"n_cols":12,"rows_kept":57,"cut":false,"hidden":false,"merged":[[14,0,14,2],[13,0,13,2],[15,0,15,2],[16,0,16,2],[8,1,8,3],[9,1,9,3],[11,0,11,2],[26,0,26,1],[25,0,25,4],[27,0,27,1],[24,0,24,2],[17,0,17,4],[18,0,18,2],[19,0,19,2],[20,0,20,2],[21,0,21,2],[23,0,23,2],[22,0,22,2],[30,7,30,9],[19,5,19,6],[18,5,18,6],[20,5,20,6],[30,5,30,6],[18,7,21,9],[21,5,21,6],[24,5,24,8],[0,2,0,3],[1,1,1,3],[6,1,6,3],[7,1,7,3],[4,1,4,3],[3,1,3,3],[2,1,2,4],[5,1,5,3],[47,5,50,6],[52,0,52,1],[52,2,52,3],[32,0,32,4],[35,5,38,6],[33,0,33,4],[41,5,44,6],[36,2,36,3],[34,2,34,3],[38,2,38,3],[35,2,35,3],[37,2,37,3],[40,0,40,1],[40,2,40,3],[51,0,51,4],[50,2,50,3],[53,2,53,3],[53,5,56,6],[54,2,54,3],[55,2,55,3],[56,2,56,3],[45,0,45,4],[28,0,28,1],[49,2,49,3],[46,0,46,1],[46,2,46,3],[39,0,39,4],[42,2,42,3],[34,0,34,1],[48,2,48,3],[43,2,43,3],[47,2,47,3],[30,0,30,2],[29,0,29,1],[44,2,44,3],[41,2,41,3]]}
["Version 12-01-24",{"$f":"IF(Lookup!P7<>\"\",\"Links have not been removed\",\"\")","v":""},"DfE No:",null,null,{"$f":"VLOOKUP(E1,Lookup!A:D,4,0)","v":{"$error":"#N/A"}},null,{"$f":"IF(E1=0,0,1)","v":0},null,null,null,"DD"]
["School Name:",{"$f":"IFERROR(VLOOKUP(E1,Lookup!A:L,2,FALSE),\"\")","v":""}]
["Section 1","Nine Months Monitoring Balance Control Mechanism (BCM) form"]
["Ledger Code","Enter your Nine Month monitoring Year End forecast figures.\nEnter all figures as positive",null,null,"Amount £",null,null,null,null,null,null,"DD"]
[{"$f":"IF(AND(E1>1100,E1<2000),\"All Income\",\"I01\")","v":"I01"},{"$f":"IF(AND(E1>1100,E1<2000),\"The School's Funding Forum has agreed that all Pru income can be taken into account for BCM purposes.\"& CHAR(10)&\"Please enter your total Revenue Income into cell E5\",\"Funds Delegated by LA\")","v":"Funds Delegated by LA"},null,null,null,null,null,null,null,null,null,"DD"]
["E17","Non-domestic rates expenditure (NNDR) (if not already included in I01 figure, otherwise please leave blank)",null,null,null,null,null,null,null,null,null,"DD"]
["I02","Funding for 6th Form Students if applicable",null,null,null,null,null,null,null,null,null,"DD"]
["I03","SEN Funding",null,null,null,null,null,null,null,null,null,"DD"]
["I05","Pupil Premium",null,null,null,null,null,null,null,null,null,"DD"]
["I18\nDo not inc 18A,B or C","Additional Grant for Schools (Sports Funding & UFSM)",null,null,null,null,null,null,{"$f":"VLOOKUP(E1,Lookup!A:O,15,FALSE)","v":{"$error":"#N/A"}},null,null,"DD"]
["Balance liable to BCM - This is calculated from the figures entered above",null,null,"A",{"$f":"SUM(E5:E10)","v":0},null,null,null,null,null,null,"DD"]
[{"$f":"\"Budget Control Mechanism figure      \"&IF(E1=\"\",\"\",\"(\"&TEXT(F1,\"##.##%\")&\" of the income figures that make up the total in A)\")","v":"Budget Control Mechanism figure      "},null,null,"B",{"$f":"IF(E1=\"\",\"\",E11*F1)","v":""},null,null,null,null,null,null,"DD"]
[null,null,null,null,null,null,null,null,null,null,null,"DD"]
["Section 2 - Budget Control Mechanism - Detailed breakdown of Revenue Rollover",null,null,"Row","Amount £",null,null,null,null,null,null,"DD"]
["Total Revenue Rollover (Year End forecast figure from the Nine Month Monitoring Report).",null,null,"C",null,null,null,null,null,null,null,"DD"]
["Allowable Balance Control Mechanism (BCM) (populated from B above).",null,null,"D",{"$f":"E12","v":""},null,null,null,null,null,null,"DD"]
[{"$f":"IF(E17>0,\"You have exceeded your allowable Balance Control Mechanism figure (BCM)\",\"You are within your allowable Balance Control Mechanism figure (BCM)\")","v":"You are within your allowable Balance Control Mechanism figure (BCM)"},null,null,"E",{"$f":"IF(E1=\"\",0,IF(E15=\"\",\"\",IF(E15-E16<0,0,E15-E16)))","v":0},null,null,null,null,null,null,"DD"]
[{"$f":"IF(OR(E1=\"\",E15=\"\"),\"Section 2.1  BCM breakdown, refer to the BCM Criteria tab for details\",IF(E17=0,\"Section 2.1 - This section is not applicable as you are not over your BCM allowable.\",\"Section 2.1  BCM breakdown - complete rows F to I (total must equal the A20amount you are over your BCM by (\"&TEXT(ROUND(E17,2),\"£#,###.00\")&\"))\"))","v":"Section 2.1  BCM breakdown, refer to the BCM Criteria tab for details"},null,null,null,null,null,null,null,null,null,null,"DD"]
["Revenue contribution to Capital project (planned for NEW year)\nProvide detail below in section 4.1",null,null,"F",null,{"$f":"IF(AND(E19<>0,SUM(C36:C39)=0),\"Details are required in Section 4.1 below\",\"\")","v":""},null,{"$f":"IFERROR(IF(ROUND(E17-SUM(E19:E22),2)=0,\"\",IF(ROUND(E17-SUM(E19:E22),2)<0,\"The current total of Rows F to I is more than the amount over your BCM by \"&TEXT(ROUND((E17-SUM(E19:E22))*-1,2),\"£#,###.00\")&CHAR(10)&CHAR(10)&\"You need to ensure that this total is equal to the amount over BCM (Row E).\",\"The current total of Rows F to I is less than the amount over your BCM by \"&TEXT(ROUND((SUM(E19:E22)-E17)*-1,2),\"£#,###.00\")&CHAR(10)&CHAR(10)&\"This amount may be subject to clawback (Row J).\")),\"\")","v":""},null,null,null,"DD"]
["Funding held on behalf of other schools\nProvide detail below in section 4.2",null,null,"G",null,{"$f":"IF(AND(E20<>0,SUM(C42:C45)=0),\"Details are required in Section 4.2 below\",\"\")","v":""},null,null,null,null,null,"DD"]
["Late allocations\nProvide detail below in section 4.3",null,null,"H",null,{"$f":"IF(AND(E21<>0,SUM(C48:C51)=0),\"Details are required in Section 4.3 below\",\"\")","v":""},null,null,null,null,null,"DD"]
["Other grant income and funding sources\nProvide detail below in section 4.4",null,null,"I",null,{"$f":"IF(AND(E22<>0,SUM(C53:C56)=0),\"Details are required in Section 4.4 below\",\"\")","v":""},null,null,null,null,null,"DD"]
["This amount over your BCM may be subject to Clawback.",null,null,"J",{"$f":"IFERROR(IF(E17-SUM(E19:E22)<0,0,E17-SUM(E19:E22)),\"\")","v":0}]
["Allowable Balance Control Mechanism (BCM) from Row D above",null,null,"D",{"$f":"E16","v":""},null,null,null,null,null,null,"DD"]
[{"$f":"\"Total Revenue Funds rollover c/f from Row C above  (\"&TEXT(ROUND(E15,2),\"£#,###.00\")&\")\"","v":"Total Revenue Funds rollover c/f from Row C above  (£.00)"},null,null,"C",{"$f":"SUM(E19:E24)","v":0},{"$f":"IF(E1=\"\",\"\",IF(E17=0,\"\",IF(ROUND(SUM(E19:E22)+E24-E15,2)<0,\"\",IF(ROUND(SUM(E19:E22)+E24-E15,2)>0,\"You have allocated \"&TEXT(ROUND((SUM(E19:E24)-E15),2),\"£#,###.00\")&\" too much\",\"\"))))","v":""},null,null,null,null,null,"DD"]
["Section 3 Total Revenue Rollover breakdown",null,null,null,null,null,null,null,null,null,null,"DD"]
["Total of breakdown of amount over BCM from above (Rows F to I above) (pre-populated)",null,"B01","K",{"$f":"SUM(E19:E22)","v":0},null,null,null,null,null,null,"DD"]
["Community Focussed School Balance c/f figure - if applicable \n(Previous years B06 rollover + I16 + I17 - E31 - E32 from Monitoring Report)",null,"B06 c/f","L",null,null,null,null,null,null,null,"DD"]
["The remaining Committed element from Row B above.",null,"B01","M",null,null,null,null,null,null,null,"DD"]
["The Uncommitted element from Row B above.\nIf the figure in row C is a deficit, enter the whole amount here with a leading minus",null,"B02","N",null,null,null,null,null,null,null,"DD"]
["Total of rows K to N - must match row C above",null,null,"O",{"$f":"SUM(E27:E30)","v":0},{"$f":"IF(H1=0,\"\",IF(E31=E15,\"CORRECT\",\"This amount must match Row C\"))","v":""},null,{"$f":"IF(E15-E31>0,\"You still have \"&TEXT(ROUND((E15-E31),2),\"£#,###.00\")&\" to allocate\",IF(E15-E31<0,\"You have allocated \"&TEXT(ROUND(-(E15-E31),2),\"£#,###.00\")&\" too much\",\"\"))","v":""},null,null,null,"DD"]
[]
[{"$f":"IF(E17=0,\"\",\"Section 4  BCM breakdown - The section below relates to Section 2.1 above\")","v":""}]
["Section 4.1                              Analysis of row F - brief description of Revenue contribution to Capital project (planned for NEW year)"]
["Evidence should be retained in the school",null,"Amount £/pp",null,"Date to be spent by"]
[1,null,null,null,null,{"$f":"IF(E19=SUM(C36:D39),\"\",\"The total in this section must equal the total of row F\")","v":""}]
[2]
[3]
[4]
["Section 4.2                              Analysis of row G - Funding held on behalf of other schools"]
["Evidence should be retained in the school",null,"Amount £/pp",null,"Date to be spent by"]
[1,null,null,null,null,{"$f":"IF(E20=SUM(C42:D45),\"\",\"The total in this section must equal the total of row G\")","v":""}]
[2]
[3]
[4]
["Section 4.3                              Analysis of row H - brief description of Late allocations"]
["Evidence should be retained in the school",null,"Amount £/pp",null,"Date to be spent by"]
[1,null,null,null,null,{"$f":"IF(E21=SUM(C48:D51),\"\",\"The total in this section must equal the total of row H\")","v":""}]
[2]
[3]
[4]
["Section 4.4                             Analysis of row I - brief description of other grant income and funding sources"]
["Evidence should be retained in the school",null,"Amount £/pp",null,"Date to be spent by"]
[1,null,null,null,null,{"$f":"IF(E22=SUM(C54:D57),\"\",\"The total in this section must equal the total of row I\")","v":""}]
[2]
[3]
[4]

{"sheet":"Lookup","index":3,"n_rows":314,"n_cols":7,"rows_kept":314,"cut":false,"hidden":true,"merged":[]}
["DfE No.","School Name","Phase",null,"% rates"]
[1001,"Northfleet Nursery",1,{"$f":"VLOOKUP(C2,E:F,2,FALSE)","v":0.12},1,0.12,"Primary"]
[1123,"The Rosewood School",1,{"$f":"VLOOKUP(C3,E:F,2,FALSE)","v":0.12},2,7.4999999999999997E-2,"Secondary"]
[1124,"Birchwood PRU",1,0.12,3,0.12,"Special"]
[1127,"The Cedars",1,0.12,4,8.5000000000000006E-2,"All Through"]
[1128,"Enterprise Learning Alliance PRU",1,0.12]
[1129,"Two Bridges",1,0.12]
[2000,"St John's CE School",1,0.12]
[2002,"Repton Manor Primary",1,0.12]
[2065,"The Discovery School",1,0.12]
[2066,"Maypole Primary School",1,0.12]
[2079,"Woodlands Primary School ",1,0.12]
[2088,"Crockenhill Primary School",1,0.12]
[2089,"The Anthony Roper Primary School",1,0.12]
[2094,"Cobham Primary School",1,0.12]
[2095,"Cecil Road Primary School",1,0.12]
[2109,"Higham Primary School",1,0.12]
[2116,"Lawn Primary School",1,0.12]
[2119,"Shears Green Infant School",1,0.12]
[2120,"Bean Primary School",1,0.12]
[2128,"Capel Primary School",1,0.12]
[2130,"Dunton Green Primary School",1,0.12]
[2132,"Hadlow School",1,0.12]
[2133,"Halstead Community Primary School",1,0.12]
[2134,"Four Elms Primary School",1,0.12]
[2136,"Kemsing Primary School",1,0.12]
[2137,"Leigh Primary School",1,0.12]
[2138,"Otford Primary School",1,0.12]
[2139,"Pembury School",1,0.12]
[2142,"Sandhurst Primary School",1,0.12]
[2147,"Weald Community Primary School",1,0.12]
[2148,"Shoreham Village School",1,0.12]
[2155,"Slade Primary School",1,0.12]
[2156,"Sussex Road Community Primary School",1,0.12]
[2161,"Boughton Monchelsea Primary School",1,0.12]
[2163,"East Farleigh Primary School",1,0.12]
[2164,"East Peckham Primary School",1,0.12]
[2165,"Headcorn Primary School",1,0.12]
[2166,"Hollingbourne Primary School",1,0.12]
[2167,"Ightham Primary School",1,0.12]
[2168,"Lenham Primary School",1,0.12]
[2169,"Platts Heath Primary School",1,0.12]
[2171,"Brunswick House Primary School",1,0.12]
[2175,"North Borough Junior School",1,0.12]
[2176,"Park Way Primary School",1,0.12]
[2185,"Mereworth Community Primary School",1,0.12]
[2187,"Offham Primary School",1,0.12]
[2188,"Plaxtol Primary School",1,0.12]
[2189,"Ryarsh Primary School",1,0.12]
[2190,"Shipbourne School",1,0.12]
[2192,"Staplehurst School",1,0.12]
[2193,"Sutton Valence Primary School",1,0.12]
[2226,"Eastling Primary School",1,0.12]
[2227,"Ethelbert Road Primary School",1,0.12]
[2228,"Davington Primary School",1,0.12]
[2231,"Lower Halstow School",1,0.12]
[2239,"Rodmersham School",1,0.12]
[2245,"Rose Street Primary School",1,0.12]
[2254,"Canterbury Road Primary School",1,0.12]
[2258,"Blean Primary School",1,0.12]
[2263,"Herne Bay Infant School",1,0.12]
[2265,"Hoath Primary School",1,0.12]
[2268,"Westmeads Community Infant School",1,0.12]
[2269,"Whitstable Junior School",1,0.12]
[2270,"Aldington Primary School",1,0.12]
[2272,"East Stour Primary School",1,0.12]
[2275,"Victoria Road Primary School",1,{"$f":"VLOOKUP(C67,E:F,2,FALSE)","v":0.12}]
[2276,"Willesborough Infant School",1,0.12]
[2278,"Bethersden School",1,0.12]
[2279,"Brook Community Primary School",1,0.12]
[2280,"Challock Primary School",1,0.12]
[2282,"Great Chart Primary School",1,0.12]
[2285,"Mersham Primary School",1,0.12]
[2289,"Smeeth Community Primary School",1,0.12]
[2298,"Hawkinge Primary School",1,0.12]
[2300,"Sellindge Primary School",1,0.12]
[2312,"River Primary School",1,0.12]
[2318,"Langdon Primary School",1,0.12]
[2320,"Eythorne Elvington Community Primary School",1,0.12]
[2321,"Lydden Primary School",1,0.12]
[2322,"Preston Primary School",1,0.12]
[2326,"Wingham Primary School",1,0.12]
[2328,"St Mildred's Primary Infant School",1,0.12]
[2329,"Callis Grange Nursery and Infant School",1,0.12]
[2337,"St Crispin's Community Primary Infant School",1,0.12]
[2340,"Ellington Infant School",1,0.12]
[2345,"Priory Infant School",1,0.12]
[2431,"Shears Green Junior School",1,0.12]
[2434,"West Minster Primary School",1,0.12]
[2454,"Aycliffe Community Primary School",1,0.12]
[2459,"Riverhead Infant School",1,0.12]
[2465,"Claremont Primary School",1,0.12]
[2471,"Whitfield Aspen School",1,0.12]
[2474,"St Paul's Infant School",1,0.12]
[2482,"Langton Green Primary School",1,0.12]
[2490,"Bishops Down Primary School",1,0.12]
[2509,"Singlewell Primary School",1,0.12]
[2510,"Cheriton Primary School",1,0.12]
[2514,"Brookfield Infant School",1,0.12]
[2519,"Vigo Village School",1,0.12]
[2520,"Madginford Primary School",1,0.12]
[2524,"Palmarsh Primary School",1,0.12]
[2525,"Painters Ash Primary School",1,0.12]
[2530,"Tunbury Primary School",1,0.12]
[2532,"St Margaret's-at-Cliffe Primary School",1,0.12]
[2539,"Stocks Green Primary School",1,0.12]
[2545,"Sandgate Primary School",1,0.12]
[2552,"Sandling Primary School",1,0.12]
[2559,"Capel-le-Ferne Primary School",1,0.12]
[2562,"Lunsford Primary School",1,0.12]
[2574,"Downs View Infant School",1,0.12]
[2578,"Kingswood Primary School",1,0.12]
[2586,"Senacre Wood Primary School",1,0.12]
[2603,"Bromstone Primary School, Broadstairs",1,0.12]
[2607,"Parkside Community Primary School",1,0.12]
[2615,"High Firs Primary School",1,0.12]
[2627,"Sandwich Junior School",1,0.12]
[2632,"Sevenoaks Primary School",1,0.12]
[2643,"Swalecliffe Community Primary School",1,0.12]
[2648,"Aylesham Primary School",1,0.12]
[2651,"Broadwater Down Primary School",1,0.12]
[2653,"West Borough Primary School",1,0.12]
[2662,"Long Mead Community Primary School",1,0.12]
[2672,"Palm Bay Primary School",1,0.12]
[2674,"Kings Farm Primary School",1,0.12]
[2680,"Kings Hill School",1,0.12]
[2682,"New Ash Green Primary School",1,0.12]
[2689,"The Craylands School",1,0.12]
[2692,"Churchill Primary (Hawkinge)",1,0.12]
[3010,"St Paul’s CofE (Vol. Con.) Primary School",1,0.12]
[3015,"Fawkham CofE (Vol. Con.) Primary School",1,{"$f":"VLOOKUP(C131,E:F,2,FALSE)","v":0.12}]
[3020,"Sedley's CofE (Vol. Con.) Primary School",1,0.12]
[3022,"Benenden CofE Primary School",1,0.12]
[3023,"Bidborough CofE (Vol. Con.) Primary School",1,0.12]
[3027,"Cranbrook CofE Primary School",1,0.12]
[3029,"Goudhurst & Kilndown CofE Primary School",1,0.12]
[3032,"Hawkhurst CofE Primary School",1,0.12]
[3033,"Hildenborough CofE Primary School",1,0.12]
[3034,"Lamberhurst St Mary's CofE (Vol. Con.) Primary School",1,0.12]
[3035,"Seal CofE (Vol. Con.) Primary School",1,0.12]
[3037,"St John's CofE Primary School, Sevenoaks",1,0.12]
[3042,"Speldhurst CofE (Vol. Aid.) Primary School",1,0.12]
[3043,"Sundridge and Brasted CofE ( Vol. Con.) Primary School",1,0.12]
[3050,"St John's CofE Primary School",1,0.12]
[3052,"St Mark's CofE Primary School",1,0.12]
[3053,"St Peter's CofE Primary School - Tunbridge Wells",1,0.12]
[3054,"Crockham Hill CofE (Vol. Con.) Primary School",1,0.12]
[3055,"Churchill CofE (Vol. Con.) Primary School",1,0.12]
[3057,"St Peter's CofE Primary School - Aylesford",1,0.12]
[3061,"Bredhurst CofE (Vol. Con.) Primary School",1,0.12]
[3062,"Burham CofE Primary School",1,0.12]
[3067,"Harrietsham CofE Primary School",1,0.12]
[3069,"Leeds and Broomfield CofE Primary School",1,0.12]
[3072,"St Michael's CEJ School, Maidstone",1,0.12]
[3073,"St Michael's CEI School, Maidstone",1,0.12]
[3081,"Thurnham CofE Infant School",1,0.12]
[3082,"Trottiscliffe CofE Primary School",1,0.12]
[3083,"Ulcombe CofE Primary School",1,0.12]
[3084,"Wateringbury CofE Primary School",1,0.12]
[3088,"Wouldham, All Saints CofE (Vol. Con.) School",1,0.12]
[3089,"St George's CofE ( Vol. Con.) Primary School",1,0.12]
[3090,"St Margaret's CofE (Vol. Con.) School, Collier Street",1,0.12]
[3091,"Laddingford St. Mary's CofE (Vol. Con.) Primary School",1,0.12]
[3092,"Yalding, St Peter and St Paul CofE (Vol. Con.) Primary School",1,0.12]
[3108,"Ospringe CofE Primary School",1,0.12]
[3109,"Hernhill CofE Primary School",1,0.12]
[3111,"Newington CofE Primary School",1,0.12]
[3117,"Teynham Parochial CofE Primary School",1,0.12]
[3120,"Barham CofE Primary School",1,0.12]
[3122,"Bridge and Patrixbourne CofE Primary School",1,0.12]
[3123,"Chislet CofE Primary School",1,0.12]
[3126,"Littlebourne CofE Primary School",1,0.12]
[3129,"St Alphege CofE Infant School",1,0.12]
[3130,"Wickhambreaux CofE Primary School",1,0.12]
[3134,"John Mayne CofE Primary School, Biddenden",1,0.12]
[3136,"Brabourne CofE Primary School",1,0.12]
[3137,"Brookland CofE Primary School",1,0.12]
[3138,"Chilham, St Mary's CofE Primary School",1,0.12]
[3139,"High Halden CofE Primary School",1,0.12]
[3145,"Woodchurch CofE Primary School",1,0.12]
[3146,"Bodsham CofE Primary School",1,0.12]
[3149,"Folkestone, St Martin's CofE Primary School",1,0.12]
[3150,"Folkestone, St Peter's CofE Primary School",1,0.12]
[3153,"Seabrook CofE Primary School",1,0.12]
[3154,"Lyminge CofE Primary School",1,0.12]
[3155,"Lympne CofE Primary School",1,0.12]
[3158,"Stelling Minnis CofE Primary School",1,0.12]
[3159,"Stowting CofE Primary School",1,0.12]
[3160,"Selsted CofE Primary School",1,0.12]
[3167,"Eastry CofE Primary School",1,0.12]
[3168,"Goodnestone CofE Primary School",1,0.12]
[3169,"Guston CofE Primary School",1,0.12]
[3171,"Nonington CofE Primary School",1,0.12]
[3175,"Sibertswold CofE Primary School",1,0.12]
[3178,"Birchington CofE Primary School",1,{"$f":"VLOOKUP(C195,E:F,2,FALSE)","v":0.12}]
[3179,"Margate, Holy Trinity & St. John's CofE Primary School ",1,0.12]
[3181,"Westgate on Sea,  St Saviours CofE Junior School",1,0.12]
[3182,"Minster CofE Primary School",1,0.12]
[3183,"Monkton CofE Primary School",1,0.12]
[3186,"St Nicholas at Wade CofE Primary School",1,0.12]
[3198,"Frittenden CofE Primary School",1,0.12]
[3199,"Egerton CofE Primary School",1,0.12]
[3201,"St Lawrence CofE Primary School",1,0.12]
[3282,"Boughton-under-Blean and Dunkirk (Vol. Con.) Primary School",1,0.12]
[3284,"Lady Joanna Thornhill (Endowed) Primary School",1,0.12]
[3289,"St Peter's Methodist (Vol. Con.) Primary School",1,0.12]
[3294,"St Matthew's High Brooms CofE (Vol. Con.) Primary School",1,0.12]
[3295,"Herne CE Infant School and Nursery",1,0.12]
[3296,"Langafel CofE (Vol. Con.) Primary School",1,0.12]
[3297,"Southborough CofE Primary School",1,0.12]
[3298,"West Kingsdown, St Edmund's CofE (Vol. Con.) Primary School",1,0.12]
[3299,"John Wesley School",1,0.12]
[3303,"St Katharine's Knockholt CofE (Vol. Aid.) Primary School",1,0.12]
[3307,"Chevening, (St Botolph's) CofE (Vol. Aid.) Primary School",1,0.12]
[3308,"Colliers Green CofE Primary School",1,0.12]
[3309,"Sissinghurst CofE Primary School",1,0.12]
[3312,"Hever CofE (Vol. Aid.) Primary School",1,0.12]
[3314,"Penshurst CofE (Vol. Aid.) Primary School",1,0.12]
[3317,"Lady Boswell's CofE (Vol. Aid.) Primary School, Sevenoaks",1,0.12]
[3318,"Ide Hill CofE Primary School",1,0.12]
[3320,"St Barnabas CofE (Vol. Aid.) Primary School",1,0.12]
[3322,"St James Primary School",1,0.12]
[3323,"Hunton CofE Primary School",1,0.12]
[3325,"Platt CofE (Vol. Aid.) Primary School",1,0.12]
[3328,"Bapchild and Tonge CofE Primary School",1,0.12]
[3332,"Hartlip Endowed CofE Primary School",1,0.12]
[3337,"Tunstall CofE Primary School",1,0.12]
[3338,"Herne CofE Junior School",1,0.12]
[3339,"Whitstable & Seasalter Endowed CofE Junior School",1,0.12]
[3340,"Ashford, St Mary's CofE Primary School",1,0.12]
[3346,"Wittersham CofE Primary School",1,0.12]
[3347,"Elham CofE Primary School",1,0.12]
[3350,"Saltwood CofE Primary School",1,0.12]
[3351,"Cartwright and Kelsey CofE Primary School",1,0.12]
[3356,"Dover, St Mary's CofE Primary School",1,0.12]
[3360,"St Peter-in-Thanet CofE Junior School",1,0.12]
[3364,"Ramsgate, Holy Trinity CofE Primary School",1,0.12]
[3373,"St Mary's CofE (Vol. Aid.) Primary School",1,0.12]
[3718,"St Augustine's Catholic Primary School, Hythe (Academy 01-02-17)",1,0.12]
[3722,"St Ethelbert's Catholic Primary School, Ramsgate",1,0.12]
[3728,"St Anselm's Catholic Primary School Dartford",1,0.12]
[3733,"Our Lady's Catholic Primary School, Dartford",1,0.12]
[3749,"St Thomas' Catholic Primary School, Canterbury",1,0.12]
[3893,"Phoenix Community Primary School",1,0.12]
[3896,"Downsview Primary School",1,0.12]
[3898,"Greenfields Primary School",1,0.12]
[3902,"Hythe Bay CofE Primary School",1,0.12]
[3904,"Castle Hill Community Primary School ",1,0.12]
[3906,"Palace Wood Primary School ",1,0.12]
[3907,"Hextable Primary School",1,0.12]
[3909,"Ashford Oaks Primary School",1,0.12]
[3910,"Joy Lane Primary School",1,0.12]
[3913,"Rusthall, St Paul's C of E VA Primary School",1,0.12]
[3916,"Green Park Community Primary School",1,0.12]
[3917,"Garlinge Primary School",1,0.12]
[3918,"Newington Community Primary School and Nursery",1,0.12]
[3920,"Goatlees Primary School",1,0.12]
[4026,"Dartford Science & Technology College",2,7.4999999999999997E-2]
[4040,"Northfleet School for Girls ",2,{"$f":"VLOOKUP(C259,E:F,2,FALSE)","v":7.4999999999999997E-2}]
[4043,"Tunbridge Wells Girls' Grammar School",2,7.4999999999999997E-2]
[4045,"Tunbridge Wells Grammar School for Boys",2,7.4999999999999997E-2]
[4065,"Holmesdale Technology College",2,7.4999999999999997E-2]
[4109,"Dover Grammar School for Girls",2,7.4999999999999997E-2]
[4246,"The North School",2,7.4999999999999997E-2]
[4522,"Maidstone Grammar School ",2,7.4999999999999997E-2]
[4523,"Maidstone Grammar School for Girls",2,7.4999999999999997E-2]
[4534,"Simon Langton Girls' Grammar School",2,7.4999999999999997E-2]
[4622,"The Judd School",2,7.4999999999999997E-2]
[5200,"Snodland CofE (Vol. Aid.) Primary School",1,0.12]
[5201,"Borough Green Primary School",1,0.12]
[5203,"Roseacre Junior School",1,0.12]
[5206,"Herne Bay Junior School",1,0.12]
[5207,"St Francis' Catholic School, Maidstone",1,0.12]
[5208,"Ditton CofE Junior School",1,0.12]
[5212,"Ditton Infant School",1,0.12]
[5213,"Holy Trinity CofE Primary School, Dartford",1,0.12]
[5214,"St Bartholomew's Catholic Primary School, Swanley",1,0.12]
[5218,"Greatstone Primary School",1,0.12]
[5221,"Wincheap Foundation Primary School",1,0.12]
[5223,"Brookfield Junior School (Larkfield)",1,0.12]
[5225,"Harcourt Primary School",1,0.12]
[5226,"Willesborough Junior School",1,0.12]
[5407,"Thamesview School",2,7.4999999999999997E-2]
[5410,"Aylesford School",2,7.4999999999999997E-2]
[5412,"Simon Langton Grammar School for Boys",2,7.4999999999999997E-2]
[5425,"The Malling School",2,7.4999999999999997E-2]
[5426,"The Archbishop’s School",2,7.4999999999999997E-2]
[5431,"Hugh Christie Technology College",2,7.4999999999999997E-2]
[5447,"St George's CofE Foundation School",4,8.5000000000000006E-2]
[5456,"Northfleet Technology College",2,7.4999999999999997E-2]
[5459,"Dover Grammar School for Boys",2,7.4999999999999997E-2]
[5461,"St John's Roman Catholic Comprehensive School",2,7.4999999999999997E-2]
[5468,"The Ellington & Hereson School",2,7.4999999999999997E-2]
[7002,"Broomhill Bank School",3,0.12]
[7021,"Valence School",3,0.12]
[7032,"Bower Grove School",3,0.12]
[7033,"St Anthony's School",3,0.12]
[7039,"The Ifield School",3,0.12]
[7040,"The Foreland School",3,0.12]
[7041,"Goldwyn School",3,0.12]
[7043,"The Beacon School",3,0.12]
[7044,"Rowhill School",3,0.12]
[7045,"Elms School (formerly Harbour School)",3,0.12]
[7051,"Nexus School",3,0.12]
[7052,"Grange Park",3,0.12]
[7056,"Five Acre Wood School",3,0.12]
[7058,"Stone Bay School",3,0.12]
[7062,"The Orchard School",3,0.12]
[7063,"St Nicholas' School",3,0.12]
[7067,"Portal House School",3,0.12]
[7069,"The Wyvern School",3,0.12]
[7070,"Oakley School",3,0.12]
[7072,"Meadowfield",3,0.12]
[7073,"Laleham Gap Specialist School",3,0.12]