ࡱ> VU g2ɀ\p Martyn Scotton Ba==HN88X@"1Calibri1Calibri1Calibri1Calibri1Arial1Arial1Arial1Arial1Arial1Arial1Calibri1 Calibri1Calibri14Calibri1 Calibri1Calibri1Calibri1,8Calibri18Calibri18Calibri1>141<Calibri1?Calibri1h8Cambria1Calibri1 Calibri1Arial1Arial1Calibri1Arial1Tahoma""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.005*0_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=,8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-.)_-* #,##0_-;\-* #,##0_-;_-* "-"??_-;_-@_- ""#,##0.00 ""#,##0""#,##0.0000000000""#,##0.00000000000[$-809]dd\ mmmm\ yyyy                                                                        ff  +  ) +  ,  *     P  P        `               a>  x  x "x  x "|   x   x  "x  "| 8 8  8 8 x@ @ "|@ @  x@ @ "x@ @ "|@ @ "|@ @ "|@ @ "|a@ 8 "x@ @ !x@ @ "x ||\D&}-}  "-"??_-}-}  "-"??_-}-}  "-"??_-}-}  "-"??_-}-}  "-"??_-}-}  "-"??_-}-}  "-"??_-}-}  "-"??_-}-}  "-"??_-}-}   "-"??_-}-}   "-"??_-}-}   "-"??_-}-}   "-"??_-}-}   "-"??_-}-}  "-"??_-}-}  "-"??_-}A}  "-"??_-ef-@_- }A}  "-"??_-ef-@_- }A}  "-"??_-ef-@_- }A}  "-"??_-ef-@_- }A}  "-"??_-ef-@_- }A}  "-"??_-ef -@_- }A}  "-"??_-L-@_- }A}  "-"??_-L-@_- }A}  "-"??_-L-@_- }A}  "-"??_-L-@_- }A}  "-"??_-L-@_- }A}  "-"??_-L -@_- }A}  "-"??_-23-@_- }A}  "-"??_-23-@_- }A}  "-"??_-23-@_- }A}   "-"??_-23-@_- }A}!  "-"??_-23-@_- }A}"  "-"??_-23 -@_- }A}#  "-"??_--@_- }A}$  "-"??_--@_- }A}%  "-"??_--@_- }A}&  "-"??_--@_- }A}'  "-"??_--@_- }A}(  "-"??_- -@_- }A})  "-"??_--@_- }}* } "-"??_--@_-    }}+  "-"??_--@_- ??? ??? ??? ???}-},  "-"??_-}-}-  "-"??_-}-}/  "-"??_-}-}0  "-"??_-}-}1  "-"??_-}A}2 a "-"??_--@_- }A}3  "-"??_--@_- }A}4  "-"??_-?-@_- }A}5  "-"??_-23-@_- }-}6  "-"??_-}}7 ??v "-"??_-̙-@_-    }A}8 } "-"??_--@_- }A}9 e "-"??_--@_- }}<  "-"??_--@_-    }}= ??? "-"??_--@_- ??? ??? ??? ???}-}>  "-"??_-}-}@  "-"??_-}U}A  "-"??_--@_-  }-}B  "-"??_-}(}L  "-"??_-}(}M  "-"??_-}-}N  "-"??_-}(}O  "-"??_-}(}X  "-"??_-% 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L渷 % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ږ % 60% - Accent3M( 60% - Accent3 23כ % 60% - Accent4M, 60% - Accent4 23 %! 60% - Accent5M0 60% - Accent5 23 %" 60% - Accent6M4 60% - Accent6  23 % #Accent1AAccent1 O % $Accent2A!Accent2 PM % %Accent3A%Accent3 Y % &Accent4A)Accent4 d % 'Accent5A-Accent5 K % (Accent6A1Accent6  F %)Bad9Bad  %* Calculation Calculation  }% + Check Cell Check Cell  %????????? ???, Comma-( Comma [0] .Comma 2/&Currency0. Currency [0]1Explanatory TextG5Explanatory Text % 2Good;Good  a%3 Heading 1G Heading 1 I}%O4 Heading 2G Heading 2 I}%?5 Heading 3G Heading 3 I}%236 Heading 49 Heading 4 I}% 7InputuInput ̙ ??v% 8 Linked CellK Linked Cell }% 9NeutralANeutral  e%3Normal % :Normal 2&Normal 2 ;Normal 3 <Noteb Note   =OutputwOutput  ???%????????? ???>$Percent? Percent 2 2 @Title1Title I}% ATotalMTotal %OOB Warning Text? Warning Text %XTableStyleMedium2PivotStyleLight16`TFunding, @XFair Funding TeamA1Formula12_13 ActualMainPUPILS11ACT.XLSCheckRawDataRawS'sRawPTJanbodyJanS'sJanPTJanDSG Jan Unadj Jan SEN >40 Jan SEN <40 Jan SEN 0Jan Adj ComparisonJan FSMScenario PivotTablenurseyDSG CalcYYYYYYYYYY Y Y Y Y YYYY|]XSpecial Schools Formula07_08 ActualMainTablesDfESSpecial_S52Table4_Print_07_08act.xlsSpecial_Table4_07_08ActY FChttp://鶹.bgfl.org/uploaded_documents/BAPP September 2013.xls School ListStart AllocationDATAFundingData1PP201213SURPLUS RBSummary EYSFF DATADFESSheet1YYYYYYYYYY Y Y Y  mXFair Funding TeamS52Bud Stat1011FFTWorking PapersFY 2010-11 workbook for guidance FP 3 14-12-09.xls SBS Table Table 1 10-11 CEL 10-11Table 2Table 3aTable 3bTable 3c Table 4 NO EYSFFTable4 EYSFF Pilot-Pathfinders 2 - UsersData ValidationYYYYYYYYYCTechnical OfficeFair Funding & School SupportFair FundingA1 Formula18_19 ActualFormulaCENSUSdata330_201819_P2_APT_330_鶹_20180117_12_38.xlsx Front SheetCoverSchools Block Data17-18 submitted baselines17-18 HN placesProposed Free SchoolsInputs & Adjustments Local FactorsAdjusted Factors17-18 final baselines CommentaryProformaProformaAggregation De DelegationEducation FunctionsNew ISBSchool level SB RecoupmentValidation sheetYYYYYYYZ+``#School closed prior to 1 April 2018Z0``(New School opening prior to 1 April 2018Z-``%New School opening after 1 April 2018Z/``'Amalgamation of schools by 1 April 2018Z'`` Change in pupil numbers/factorsZ<`` 4Conversion to academy status prior to 8 January 2018Z`` New Academy/Free SchoolZ `` OtherYYY Y Y Y Y YYYYYW@Edunt5mec01basscom$A1STEVEA1Formula03_04WorkingsAllocationsBudgetIncrease.xlsBudgetBudget (02_03_Adj)revisedCUserseducsehsAppDataLocalMicrosoftWindowsTemporary Internet FilesContent.OutlookI619VQY4PupilNumberVariationEstimate.xlsSheet1 Sheet1 (2)oct13oct12Sheet2%AXFair Funding TeamA1Formula12_13 ActualMainNONAWPU11ACT.XLSData ImportDataR&MC&COthPremRatesRentsWaterSpSiteAENFixLumpPayPersonStepEdITSchLib SmallPrimPupMobCurricSalSafeSPUnitsSchMealsHousingInsur.WardDep Pers'nPrim Pers'nSecThreshFoundPPP4%Post16ExclgrantsNCMinGuar BudAssessYYYYYYYYYY Y Y Y Y YYYYYYYYYYYYYYYYYYY Y!Y"Y#Y$8 \<SS\<SS\a<SS\a<SS\b<SS\b<SS\c<SS\c<SS\p<SS\p<SS_10*_11*_12*_13*_14*_15*_6*_8*_9*!  ; _Order1_Order2_R11VUR:g1_R16VUR:h1 _xlfn.AGGREGATE _xlfn.IFERROR. Age_weighted_funding;:D AV9_15*BUDGET*CAREA*CEBUDGET*CF*CL*CTACC*D11VUR:b1D16VUR:c1DPVUR:a1DSM*FMP* fsm=pp fsm=pp fsm3=pp fsm3=ppH1Tot<H1Tot<H2Tot<H2Tot<HVUR:o1JTOT*LETTER*MACRO<SSMACRO<SSp*PCAP*PCODE*POINT*PREMIUM*PRIM2<SSPRIM2<SSPRIM3<SSPRIM3<SS  ;!# Print_Area_MI<SS# Print_Area_MI<SSPRYBASE*& Reasons_list; ``REP*RMP*RMV*RPVUR:f1# Schd3Cont;/$ Sched3Mail;S# schedule4;SCODE*SEC2<SSSEC2<SSSEC3<SSSEC3<SSSECBASE*! SENMail; # T_Finance; TOT* TOTA=   TOTA=  U11VUR:l1U16VUR:m1UPVUR:k1WMACRO*WMEALS*Z*8jb(73 A@@  GDFE School NamePhaseType Funding YearYear Group of GrowthPermanent or Bulge Expansion2018/19 PermanentBulgePrimary Secondary7 & 8#Holy Family Catholic Primary SchoolKS1Yenton Primary School KS3 & KS4Growth Fund Places Business CaseFalling Pupils Fund PlacesRouteSetup Funding for New PhaseCriteria Criteria CodeIn-year growthTotal GF + FP AllocationGrowth Fund (GF) Allocation"Falling Pupil Fund (FP) Allocation DescriptionCommissioned Places All Through鶹 SchoolVoluntary Aided School Free SchoolsFoundation SchoolStarbank SchoolSt Benedict's Primary School.Eden Boys' Leadership Academy, 鶹 EastSelly Park Girls' School%Colmers School and Sixth Form CollegeTurves Green Girls' SchoolBasic Need RequirementA - Where there is a planned net increase to meet Basic Need agreed with the Local Authority, the full net increase will be funded at the full per pupil rate. B - The LA will identify those schools most likely to take in more than 30 pupils in a key stage as a result of net migration into the City and commission a number of places up to their Planned Admissions Number. These will also be funded at the full per pupil rate.C - Where there is an unfunded net increase of more than 30 in a key stage and this relates to Basic Need, schools will need to submit a Business Case for any funding from the Growth fund. In exceptional circumstances, a business case for growth of less than 30 may be considered.1A1B1CA - Full school closureB - School Phase closure Growth related to school closureNew School or New School PhasesA - Capacity building costsB - Set-up costs (Diseconomies of Scale) for new schools or new school phases to recognise that the school will not have a full complement of pupils from the beginning.3BWashwood Heath AcademyAcademy Converter KS1 & KS2Erdington Hall PrimaryAcademy Sponsor LedThe Shirestone AcademyYardleys SchoolGreat Barr AcademyHeartlands AcademyHarborne AcademyHarborne PrimaryThornton Primary ReimbursementImplicit growthGrowth Fund Allocations 2018/19 Appendix1JxK K~`LLM7NQ'RS,ccB g2ɀ "h}}  dMbP?_*+%h&ffffff?'ffffff?(?)?M\\SVWVPS013\Equitrac_Print653- h dXX10DRl[S xVr0 sɵ^{$$'N^lI\bX &u}0.Uq9us[ZaEEBA<yh0VS2a[@.):^O;P9,Zc.W*|N)meZ5:u\Zc!)r"ڤ h@:"P+ ̰(ߑE8΂$ Q1gd)GFS= 9bXW:T5l إ \cV%͇/ =¬]4I9 ":u\q?h{Y˹uͻ/`k#˾ibdw}O}'n1T8ȶnA8ZU7N=BtWPFꩋL$5 Qw%^jФr|RW:,Wu+6ImŶK%09,{lfɯr%qۧa̷g\Y*  lY 㹦R 2>8Dtō\#[D^v) v+[H Ձ;{vD{;>` =FNs4e7/8soI8Z7MN ?,9>Krkub@ c/ uKΑKGlzTQqP3B~ w`w&| icj -%,"D,.?Ԧ\0Ө`L>T':EqY pE+Z~,@d#3?ݣޔg޶oX ٖT˛_e)~#I鐚&l(cx} 0EEvb7RA/Nk0IJ[7VZ-Z{tα61JS6|! O؅rFS[kYO z1>7IqU|@Kne`ߙe I2$O <Z*Q{0i!/9tY}>x򻂰&'ﾳkXߍ.?"?333333?333333?&<3U}  D} 8D}  D} D}  E} E} E} E} UE} qE} E}  DPhaseDFEt>t&%$#"! "h@Ch@h@h@h@h@h@ h@ h@ h@ h@ h@h@h@h@h@h@h@@ @hIhIhIhIh@h@h@h@h@h@ FE [F P P P P P P P P P  P  P  P  P  P~ Q@ R# R R S S S SS  S  S6~  T>@ S# T>@ % ~ S@ R$ R R S S SSW@S>@  S  S/ TN8A~  TX@ TNA    -FFFFF~ Qj@ R R R S~ S@ S~ S@S  S  S. TY@ S TY@  ~ S@ R R R S~ S@ U ~ V$@V  V  V. TY@ V TY@  ~ S@ R% R R! S S S~ Sf@S  S  S-~  T  S Tj0A  ~ SQ@ R& R R S~ S@ S~ S4@S  S  S-~  T. S T +@  ~ S[@ R( R R" S~ S@ S ~ SB@ S S S/ TGz[@ S TGz[@  ~ S(@ R' R R" S~ S@ S~ S.@ S S S- T3333G @ S T3333G @  ~ S@ R7 R R8 S S9 S ~ S@@ S S S/ T:mӆ@ S T:mӆ@  ~ YП@ R: R R; S S9 S ~ S,@ S S S/ T_,}@ S T_,}@  ~ S@ R< R R; S~ S@ S~ S8@ S S V.~ Th S TQ%@  ~ S@ R= R R8 S~ S@ S~ S>@S  S  S-~  T& S T3333G @  ~ S@ R> R R8 S~ S@ S ~ SJ@S  S  S/~  Tv S THz&k@  ~ S@ Z? R R; S~ S@ S ~ S>@S  S  S-~  T& S T3333G @  ~ S@ R@ R R; S~ S@ S ~ SG@S  S  S/ TGe@ S TGe@  ~ SZ@ RA R R SSSSS  SD  SC~  T  S T   ~ S @ RB R R SSSSS  SD  SC~  T S T  # WR)2A % # WX@ % # WR2A %   GGG "DDDDEEEEEEEGGG H HJJJJJJJJJK ~ L? X)NNNNNNNN  JJJ O M*NNNNNNNN  JJJ O M+NNNNNNNNIJJJ M,~ L@ X2O M0L M1~ L@ X3BXu&:FB: h@!h@ O M4!L !M5X46(  R  C ]F! d ZR  C ]F! d ZR  C ]F! d ZR  C ]F! d ZR  C ]F! d ZR  C ]F! d ZR  C ]F! d ZR  C ]F! d ZR   C  ]F ! d ZR   C   ]F ! d ZR   C   ]F ! d ZR   C   ]F ! d ZR   C   ]F ! d ZR  C  ]F! d >@Z A     b(b(2PggD Oh+'0HPh Lucy DumbletonMartyn ScottMicrosoft Excel@w!n@c@Mbn՜.+,0 PXt | Service 鶹 FundingFunding!Print_Area  Worksheets Named Ranges  !"#$%&'()*+,-./0123456789:;<=>?@ABCDFGHIJKLNOPQRSTRoot Entry FZoWorkbookSummaryInformation(EDocumentSummaryInformation8M