{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["TOC","Front Pg","New State Model Fcast","State Model By %","Note Calc","TAX","PASS","STAFF_Plan","Students","Graphs"],"not_rendered":{"charts":12,"images":3,"macros":1,"external_links":0,"defined_names":23,"comments":2,"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":"1904"}

{"sheet":"TOC","index":0,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,0,1,17],[2,0,2,17]]}
[]
[{"$f":"+'Front Pg'!A2:F2","v":"LIBERTY LOCAL SCHOOL DISTRICT - TRUMBULL COUNTY"}]
["Your Five Year Forecast"]
["Table of Contents"]
[null,1," Table of Contents"]
[null,2,"Front Pg ",null,null,"Cover Page with Base Data"]
[null,3,"New State Model Fcast",null,null,"The Actual Five Year Forecast"]
[null,4,"State Model By %",null,null,"Management tool of % Change in lines "]
[null,5,"Note Calc",null,null,"All entries are made except Tax Information"]
[null,6,"Tax",null,null,"The Property & Income Tax Calculations"]
[null,7,"PASS",null,null,"The PASS Model in SF3 Format"]
[null,8,"PASS2",null,null,"The PASS Model in State Original Format"]
[null,9,"STAFF_Plan",null,null,"The Staffing Plan"]
[null,10,"Graphs",null,null,"The Graphs for a presentation and Notes"]
[null,11,"Students",null,null,"Student Count from October "]
[]
[]
[]
[]
[]
["Instructions"]
[null,null,"Your Footnotes"]

{"sheet":"Front Pg","index":1,"n_rows":64,"n_cols":8,"rows_kept":64,"cut":false,"hidden":false,"merged":[[41,0,41,5],[1,0,1,5],[2,0,2,5],[3,0,3,5],[4,0,4,5],[42,0,42,5],[5,0,5,5],[6,0,6,5],[38,0,38,5],[39,0,39,5],[40,0,40,5]]}
[]
[{"$f":"UPPER(+D58)&\" - \"&UPPER(D59)&\" COUNTY\"","v":"LIBERTY LOCAL SCHOOL DISTRICT - TRUMBULL COUNTY"},null,null,null,null,null,null," "]
["SCHEDULE OF REVENUE, EXPENDITURES, AND CHANGES",null,null,null,null,null,null," "]
["IN FUND BALANCES FOR THE FISCAL YEARS ENDED",null,null,null,null,null,null," "]
[{"$f":"\"ACTUAL JUNE 30, \"&A51&\", \"&A50&\", \"&A49","v":"ACTUAL JUNE 30, 2008, 2009, 2010"},null,null,null,null,null,null," "]
["FORECASTED FISCAL YEARS ENDING ",null,null,null,null,null,null," "]
[{"$f":"\"JUNE 30, \"&A47&\" THROUGH \"&E47","v":"JUNE 30, 2011 THROUGH 2015"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[" Forecast Provided By "]
[{"$f":"UPPER(+D62)","v":"TRACY OBERMIYER, CFO"}]
["Treasurer's Office"]
[]
["330-759-0799"]
[]
[]
[]
[{"$f":"+D64","v":2011},{"$f":"+A47+1","v":2012},{"$f":"+B47+1","v":2013},{"$f":"+C47+1","v":2014},{"$f":"+D47+1","v":2015}]
[]
[{"$f":"+A47-1","v":2010}]
[{"$f":"+A49-1","v":2009}]
[{"$f":"+A50-1","v":2008}]
[]
["For the Fiscal Years Ended June 30, 2007, 2008, 2009 Actual;"]
["Forecasted Fiscal Year Ending June 30, 2010 through 2014"]
[]
[]
[]
["Enter School District Name",null,null,"Liberty Local School District"]
["Enter County",null,null,"Trumbull"]
["IRN #",null,null,"050195"]
[]
["Treasurer Name, Title",null,null,"Tracy Obermiyer, CFO"]
[]
["Enter the 1st Fiscal Year of Forecast",null,null,2011]

{"sheet":"New State Model Fcast","index":2,"n_rows":105,"n_cols":14,"rows_kept":105,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'Front Pg'!D58","v":"Liberty Local School District"}]
[{"$f":"+'Front Pg'!D59&\" County\"","v":"Trumbull County"}]
["Schedule of Revenues, Expenditures and Changes in Fund Balances"]
[{"$f":"\"For the Fiscal Years Ended June 30, \"&'Front Pg'!A51&\", \"&'Front Pg'!A50&\" and \"&'Front Pg'!A49&\" Actual;\"","v":"For the Fiscal Years Ended June 30, 2008, 2009 and 2010 Actual;"}]
[{"$f":"\"Forecasted Fiscal Years Ending June 30, \"&'Front Pg'!A47&\" Through \"&'Front Pg'!E47","v":"Forecasted Fiscal Years Ending June 30, 2011 Through 2015"}]
[]
[null,null,null,null,null,"Actual",null,null,null,"Forecasted"]
[" ",null,"Fiscal Year ","Fiscal Year","Fiscal Year ","Fiscal Year ","Fiscal Year","Fiscal Year","Average","Fiscal Year","Fiscal Year","Fiscal Year","Fiscal Year","Fiscal Year"]
[" ",null,2005,2006,2007,2008,2009,2010,"Change",{"$f":"+'Front Pg'!A47","v":2011},{"$f":"+'Front Pg'!B47","v":2012},{"$f":"+'Front Pg'!C47","v":2013},{"$f":"+'Front Pg'!D47","v":2014},{"$f":"+'Front Pg'!E47","v":2015}]
[]
[null,"Revenues"]
[1.01,"General Property Tax (Real Estate)",14595320,15132533,8325229,7453348,7928867,8770342,{"$f":"IF(OR(G12=0,F12 = 0),0,AVERAGE((G12-F12)/F12,(H12-G12)/G12))","v":8.4963704055681724E-2},{"$f":"+'Note Calc'!D27","v":7847606},{"$f":"+'Note Calc'!E27","v":7599224.0622279029},{"$f":"+'Note Calc'!F27","v":7396527.5937365498},{"$f":"+'Note Calc'!G27","v":7087560.3954898324},{"$f":"+'Note Calc'!H27","v":6714468.3152141031}]
[1.02,"Tangible Personal Property",3703883,2777841,368999,323846,172823,48780,-0.59204396432114736,{"$f":"+'Note Calc'!E72","v":13980.544280000002},{"$f":"+'Note Calc'!F72","v":0},{"$f":"+'Note Calc'!G72","v":0},{"$f":"+'Note Calc'!H72","v":0},{"$f":"+'Note Calc'!I72","v":0}]
[1.03,"Income Tax",0,0,0,0,0,null,0,{"$f":"'Note Calc'!E80","v":0},{"$f":"'Note Calc'!F80","v":0},{"$f":"'Note Calc'!G80","v":0},{"$f":"'Note Calc'!H80","v":0},{"$f":"'Note Calc'!I80","v":0}]
[1.0349999999999999,"Unrestricted State Grants-in-Aid",45013795,44510117,5438676,5338782,5297121,5105746,-2.196579045794601E-2,{"$f":"'Note Calc'!E166","v":4913821.6399999997},{"$f":"'Note Calc'!F166","v":4807519.5497639999},{"$f":"'Note Calc'!G166","v":4894315.6831790702},{"$f":"'Note Calc'!H166","v":5289025.5938342363},{"$f":"'Note Calc'!I166","v":5683735.5044894014}]
[1.04,"Restricted State Grants-in-Aid",5380199,5819049,122172,133242,161585,8505,-0.36732347593522546,{"$f":"'Note Calc'!E167","v":8569},{"$f":"'Note Calc'!F167","v":8569},{"$f":"'Note Calc'!G167","v":8569},{"$f":"'Note Calc'!H167","v":8569},{"$f":"'Note Calc'!I167","v":8569}]
[1.0449999999999999,"Restricted Federal Grants-in-Aid - SFSF/Ed Jobs",0,0,null,null,null,310815,0,{"$f":"'Note Calc'!E168","v":428035},{"$f":"'Note Calc'!F168","v":219093},{"$f":"'Note Calc'!G168","v":0},{"$f":"'Note Calc'!H168","v":0},{"$f":"'Note Calc'!I168","v":0}]
[1.05,"Property Tax Allocation",2107194,2202346,838584,1300318,1554296,1676450,0.13695556095204725,{"$f":"+'Note Calc'!E135","v":1661392.3296479448},{"$f":"+'Note Calc'!F135","v":1612262.5193571697},{"$f":"+'Note Calc'!G135","v":1565994.6397629448},{"$f":"+'Note Calc'!H135","v":1258605.0828170574},{"$f":"+'Note Calc'!I135","v":1147454.4076110474}]
[1.06,"All Other Revenues",2595250,3219668,775039,998728,958082,894303,-5.3633613062213127E-2,{"$f":"+'Note Calc'!E96","v":1041500.227},{"$f":"+'Note Calc'!F96","v":1048769.72927},{"$f":"+'Note Calc'!G96","v":1056111.9265627},{"$f":"+'Note Calc'!H96","v":1063527.5458283271},{"$f":"+'Note Calc'!I96","v":1071017.3212866103}]
[1.07,"Total Revenues",73395641,73661554,{"$f":"SUM(E12:E19)","v":15868699},{"$f":"SUM(F12:F19)","v":15548264},{"$f":"SUM(G12:G19)","v":16072774},{"$f":"SUM(H12:H19)","v":16814941},3.9954863558828893E-2,{"$f":"SUM(J12:J19)","v":15914904.740927946},{"$f":"SUM(K12:K19)","v":15295437.860619072},{"$f":"SUM(L12:L19)","v":14921518.843241267},{"$f":"SUM(M12:M19)","v":14707287.617969453},{"$f":"SUM(N12:N19)","v":14625244.548601162}]
[]
[null,"Other Financing Sources"]
[2.0099999999999998,"Proceeds from Sale of Notes",3700000,6462000,null,null,563382,1776000,{"$f":"IF(OR(G23=0,F23 = 0),0,AVERAGE((G23-F23)/F23,(H23-G23)/G23))","v":0},{"$f":"'Note Calc'!E182","v":0},{"$f":"'Note Calc'!F182","v":0},{"$f":"'Note Calc'!G182","v":0},{"$f":"'Note Calc'!H182","v":0},{"$f":"'Note Calc'!I182","v":0}]
[2.02,"State Emergency Loans and Advancements (Approved)",7554000,0,null,null,null,null,0,{"$f":"'Note Calc'!E185","v":0},{"$f":"'Note Calc'!F185","v":0},{"$f":"'Note Calc'!G185","v":0},{"$f":"'Note Calc'!H185","v":0},{"$f":"'Note Calc'!I185","v":0}]
[2.04,"Operating Transfers-In",0,0,null,null,87352,null,0,{"$f":"'Note Calc'!E188","v":0},{"$f":"'Note Calc'!F188","v":0},{"$f":"'Note Calc'!G188","v":0},{"$f":"'Note Calc'!H188","v":0},{"$f":"'Note Calc'!I188","v":0}]
[2.0499999999999998,"Advances-In",0,0,3397021,54866,null,null,0,{"$f":"'Note Calc'!E189","v":0},{"$f":"'Note Calc'!F189","v":0},{"$f":"'Note Calc'!G189","v":0},{"$f":"'Note Calc'!H189","v":0},{"$f":"'Note Calc'!I189","v":0}]
[2.06,"All Other Financing Sources",0,0,null,null,224234,302796,0,{"$f":"'Note Calc'!E195","v":0},{"$f":"'Note Calc'!F195","v":0},{"$f":"'Note Calc'!G195","v":0},{"$f":"'Note Calc'!H195","v":0},{"$f":"'Note Calc'!I195","v":0}]
[2.0699999999999998,"Total Other Financing Sources",11254000,6462000,{"$f":"SUM(E23:E27)","v":3397021},{"$f":"SUM(F23:F27)","v":54866},{"$f":"SUM(G23:G27)","v":874968},{"$f":"SUM(H23:H27)","v":2078796},8.1616082054556944,{"$f":"SUM(J23:J27)","v":0},{"$f":"SUM(K23:K27)","v":0},{"$f":"SUM(L23:L27)","v":0},{"$f":"SUM(M23:M27)","v":0},{"$f":"SUM(N23:N27)","v":0}]
[2.08,"Total Revenues and Other Financing Sources",84649641,80123554,{"$f":"+E20+E28","v":19265720},{"$f":"+F20+F28","v":15603130},{"$f":"+G20+G28","v":16947742},{"$f":"+H20+H28","v":18893737},0.10049952367314761,{"$f":"+J28+J20","v":15914904.740927946},{"$f":"+K28+K20","v":15295437.860619072},{"$f":"+L28+L20","v":14921518.843241267},{"$f":"+M28+M20","v":14707287.617969453},{"$f":"+N28+N20","v":14625244.548601162}]
[]
[null,"Expenditures"]
[3.01,"Personal Services",46550034,40364344,7670134,8155009,7933566,7516913,{"$f":"IF(OR(G32=0,F32 = 0),0,AVERAGE((G32-F32)/F32,(H32-G32)/G32))","v":-3.9835988354770188E-2},7253818,7313914,7438251,7564701,7693301]
[3.02,"Employees' Retirement/Insurance Benefits",17158645,17041621,3418890,3115650,3919536,3740930,0.10622367675010067,3473269,3670487,3902413,4148589,4411123]
[3.03,"Purchased Services",11081278,13057650,2158261,2776176,3262870,3405437,0.10950233665391115,{"$f":"+'Note Calc'!E305","v":4217896.9799999995},{"$f":"+'Note Calc'!F305","v":4349836.8306},{"$f":"+'Note Calc'!G305","v":4462603.3651860002},{"$f":"+'Note Calc'!H305","v":4578531.9983069403},{"$f":"+'Note Calc'!I305","v":4697714.5117078554}]
[3.04,"Supplies and Materials",607190,746621,603721,502654,456696,318878,-0.19660127145467457,{"$f":"+'Note Calc'!E317","v":322067},{"$f":"+'Note Calc'!F317","v":325288},{"$f":"+'Note Calc'!G317","v":328541},{"$f":"+'Note Calc'!H317","v":331826},{"$f":"+'Note Calc'!I317","v":335144}]
[3.05,"Capital Outlay",42843,1408,232560,88983,29404,33960,-0.25730497666910623,{"$f":"+'Note Calc'!E330","v":36337.200000000004},{"$f":"+'Note Calc'!F330","v":38880.804000000004},{"$f":"+'Note Calc'!G330","v":41602.460280000007},{"$f":"+'Note Calc'!H330","v":44514.632499600011},{"$f":"+'Note Calc'!I330","v":47630.656774572017}]
[3.06,"Intergovernmental",0,0,0,0,0,null,0,0,0,0,0,0]
[null,"Debt Service:",0,0]
[4.01,"  Principal-All (Historical Only)",0,0,null,null,null,null,{"$f":"IF(OR(G39=0,F39 = 0),0,AVERAGE((G39-F39)/F39,(H39-G39)/G39))","v":0},0,0,0,0,0]
[4.0199999999999996,"  Principal-Notes",3700000,0,410767,376187,355200,355200,-2.7894371682168708E-2,523000,523000,523000,523000,{"$f":"'Note Calc'!I338","v":355200}]
[4.03,"  Principal-State Loans",0,3777000,0,0,0,0,0,{"$f":"'Note Calc'!E339","v":0},{"$f":"'Note Calc'!F339","v":0},{"$f":"'Note Calc'!G339","v":0},{"$f":"'Note Calc'!H339","v":0},{"$f":"'Note Calc'!I339","v":0}]
[4.04,"  Principal-State Advancements",0,0,0,0,0,0,0,{"$f":"'Note Calc'!E340","v":0},{"$f":"'Note Calc'!F340","v":0},{"$f":"'Note Calc'!G340","v":0},{"$f":"'Note Calc'!H340","v":0},{"$f":"'Note Calc'!I340","v":0}]
[4.05,"  Principal-HB 264 Loans",0,0,0,0,0,0,0,{"$f":"'Note Calc'!E348","v":0},{"$f":"'Note Calc'!F348","v":0},{"$f":"'Note Calc'!G348","v":0},{"$f":"'Note Calc'!H348","v":0},{"$f":"'Note Calc'!I348","v":0}]
[4.0549999999999997,"  Principal-",68706,0,0,0,0,0,0,{"$f":"'Note Calc'!E341","v":0},{"$f":"'Note Calc'!F341","v":0},{"$f":"'Note Calc'!G341","v":0},{"$f":"'Note Calc'!H341","v":0},{"$f":"'Note Calc'!I341","v":0}]
[4.0599999999999996,"  Interest and Fiscal Charges",0,0,0,0,30813,79379,0,{"$f":"'Note Calc'!E352","v":61850},{"$f":"'Note Calc'!F352","v":54346},{"$f":"'Note Calc'!G352","v":42268},{"$f":"'Note Calc'!H352","v":30192},{"$f":"'Note Calc'!I352","v":18115}]
[4.3,"Other Objects",1022488,615430,1094438,948169,1432740,2401551,0.59362715075120986,{"$f":"'Note Calc'!E369","v":1502000},{"$f":"'Note Calc'!F369","v":1400933},{"$f":"'Note Calc'!G369","v":1407841.4},{"$f":"'Note Calc'!H369","v":1414818.8840000001},{"$f":"'Note Calc'!I369","v":1421866.1428400001}]
[4.5,"Total Expenditures",80231184,75604074,{"$f":"SUM(E32:E46)","v":15588771},{"$f":"SUM(F32:F46)","v":15962828},{"$f":"SUM(G32:G46)","v":17420825},{"$f":"SUM(H32:H46)","v":17852248},5.8050898517579871E-2,{"$f":"SUM(J32:J46)","v":17390238.18},{"$f":"SUM(K32:K46)","v":17676685.634599999},{"$f":"SUM(L32:L46)","v":18146520.225465998},{"$f":"SUM(M32:M46)","v":18636173.514806543},{"$f":"SUM(N32:N46)","v":18980094.311322432}]
[]
[null,"Other Financing Uses"]
[5.01,"Operating Transfers-Out",null,0,3591057,24104,148167,424370,{"$f":"IF(OR(G50=0,F50 = 0),0,AVERAGE((G50-F50)/F50,(H50-G50)/G50))","v":3.5055605454232088},{"$f":"+'Note Calc'!E376","v":60000},{"$f":"+'Note Calc'!F376","v":65000},{"$f":"+'Note Calc'!G376","v":70000},{"$f":"+'Note Calc'!H376","v":75000},{"$f":"+'Note Calc'!I376","v":75000}]
[5.0199999999999996,"Advances-Out",0,30800,0,0,0,0,0,{"$f":"+'Note Calc'!E377","v":0},{"$f":"+'Note Calc'!F377","v":0},{"$f":"+'Note Calc'!G377","v":0},{"$f":"+'Note Calc'!H377","v":0},{"$f":"+'Note Calc'!I377","v":0}]
[5.03,"All Other Financing Uses",0,0,0,0,0,0,0,{"$f":"'Note Calc'!E381","v":0},{"$f":"'Note Calc'!F381","v":0},{"$f":"'Note Calc'!G381","v":0},{"$f":"'Note Calc'!H381","v":0},{"$f":"'Note Calc'!I381","v":0}]
[5.04,"Total Other Financing Uses",0,30800,{"$f":"SUM(E50:E52)","v":3591057},{"$f":"SUM(F50:F52)","v":24104},{"$f":"SUM(G50:G52)","v":148167},{"$f":"SUM(H50:H52)","v":424370},3.5055605454232088,{"$f":"SUM(J50:J52)","v":60000},{"$f":"SUM(K50:K52)","v":65000},{"$f":"SUM(L50:L52)","v":70000},{"$f":"SUM(M50:M52)","v":75000},{"$f":"SUM(N50:N52)","v":75000}]
[5.05,"Total Expenditures and Other Financing Uses",80231184,75634874,{"$f":"+E47+E53","v":19179828},{"$f":"+F47+F53","v":15986932},{"$f":"+G47+G53","v":17568992},{"$f":"+H47+H53","v":18276618},6.9618279341046807E-2,{"$f":"+J53+J47","v":17450238.18},{"$f":"+K53+K47","v":17741685.634599999},{"$f":"+L53+L47","v":18216520.225465998},{"$f":"+M53+M47","v":18711173.514806543},{"$f":"+N53+N47","v":19055094.311322432}]
[6.01,"Excess of Revenues and Other Financing Sources over (under) Expenditures and Other Financing Uses",4418457,4488680,{"$f":"+E29-E54","v":85892},{"$f":"+F29-F54","v":-383802},{"$f":"+G29-G54","v":-621250},{"$f":"+H29-H54","v":617119},-0.68733866649907527,{"$f":"+J29-J54","v":-1535333.4390720539},{"$f":"+K29-K54","v":-2446247.7739809267},{"$f":"+L29-L54","v":-3295001.3822247311},{"$f":"+M29-M54","v":-4003885.8968370892},{"$f":"+N29-N54","v":-4429849.7627212703}]
[null,null,null,null," "," "," "," "]
[7.01,"Cash Balance July 1 - Excluding Proposed Renewal/Replacement and New Levies",1743325,2675132,1544279,{"$f":"+E59","v":1630171},{"$f":"+F59","v":1246369},{"$f":"+G59","v":625119},{"$f":"IF(OR(G57=0,F57 = 0),0,AVERAGE((G57-F57)/F57,(H57-G57)/G57))","v":-0.36694227097296889},{"$f":"+H59","v":1242238},{"$f":"+J59","v":-293095.43907205388},{"$f":"+K59","v":-2739343.2130529806},{"$f":"+L59","v":-6034344.5952777117},{"$f":"+M59","v":-10038230.492114801}]
[null,null,null,null," "," "," "," "]
[7.02,"Cash Balance June 30",2675132,7163812,{"$f":"+E55+E57","v":1630171},{"$f":"+F55+F57","v":1246369},{"$f":"+G55+G57","v":625119},{"$f":"+H55+H57","v":1242238},{"$f":"IF(OR(G59=0,F59 = 0),0,AVERAGE((G59-F59)/F59,(H59-G59)/G59))","v":0.24437727261051009},{"$f":"+J55+J57","v":-293095.43907205388},{"$f":"+K55+K57","v":-2739343.2130529806},{"$f":"+L55+L57","v":-6034344.5952777117},{"$f":"+M55+M57","v":-10038230.492114801},{"$f":"+N55+N57","v":-14468080.254836071}]
[null,null,null,null," "," "," "]
[8.01,"Estimated Encumbrances June 30",248305,250000,223812,422023,421480,210661,{"$f":"IF(OR(G61=0,F61 = 0),0,AVERAGE((G61-F61)/F61,(H61-G61)/G61))","v":-0.25073704724277024},0,{"$f":"'Note Calc'!F390","v":210661},{"$f":"'Note Calc'!G390","v":210661},{"$f":"'Note Calc'!H390","v":210661},{"$f":"'Note Calc'!I390","v":210661}]
[null,null,null,null," "," "," "]
[null,"Reservation of Fund Balance  "]
[9.01,"     Textbooks and Instructional Materials",862717,475156,null,0,0,0,{"$f":"IF(OR(G64=0,F64 = 0),0,AVERAGE((G64-F64)/F64,(H64-G64)/G64))","v":0},{"$f":"+'Note Calc'!E394","v":0},{"$f":"+'Note Calc'!F394","v":0},{"$f":"+'Note Calc'!G394","v":0},{"$f":"+'Note Calc'!H394","v":0},{"$f":"+'Note Calc'!I394","v":0}]
[9.02,"     Capital Improvements",0,0,0,0,0,0,0,{"$f":"+'Note Calc'!E395","v":0},{"$f":"+'Note Calc'!F395","v":0},{"$f":"+'Note Calc'!G395","v":0},{"$f":"+'Note Calc'!H395","v":0},{"$f":"+'Note Calc'!I395","v":0}]
[9.0299999999999994,"     Budget Reserve",0,0,0,0,0,0,0,{"$f":"+'Note Calc'!E396","v":0},{"$f":"+'Note Calc'!F396","v":0},{"$f":"+'Note Calc'!G396","v":0},{"$f":"+'Note Calc'!H396","v":0},{"$f":"+'Note Calc'!I396","v":0}]
[9.0399999999999991,"     DPIA",0,0,0,0,0,0,0,{"$f":"+'Note Calc'!E397","v":0},{"$f":"+'Note Calc'!F397","v":0},{"$f":"+'Note Calc'!G397","v":0},{"$f":"+'Note Calc'!H397","v":0},{"$f":"+'Note Calc'!I397","v":0}]
[9.0449999999999999,"     Fiscal Stabilization",null,null,0,0,0,0,0,{"$f":"+'Note Calc'!E398","v":0},{"$f":"+'Note Calc'!F398","v":0},{"$f":"+'Note Calc'!G398","v":0},{"$f":"+'Note Calc'!H398","v":0},{"$f":"+'Note Calc'!I398","v":0}]
[9.0500000000000007,"     Debt Service",0,0,null,0,0,0,0,{"$f":"+'Note Calc'!E399","v":0},{"$f":"+'Note Calc'!F399","v":0},{"$f":"+'Note Calc'!G399","v":0},{"$f":"+'Note Calc'!H399","v":0},{"$f":"+'Note Calc'!I399","v":0}]
[9.06,"     Property Tax Advances",0,0,0,0,0,0,0,{"$f":"+'Note Calc'!E400","v":0},{"$f":"+'Note Calc'!F400","v":0},{"$f":"+'Note Calc'!G400","v":0},{"$f":"+'Note Calc'!H400","v":0},{"$f":"+'Note Calc'!I400","v":0}]
[9.07,"     Bus Purchases",21732,45696,0,0,0,0,0,{"$f":"+'Note Calc'!E401","v":0},{"$f":"+'Note Calc'!F401","v":0},{"$f":"+'Note Calc'!G401","v":0},{"$f":"+'Note Calc'!H401","v":0},{"$f":"+'Note Calc'!I401","v":0}]
[9.08,"  Subtotal",884449,520852,0,0,0,0,0,{"$f":"SUM(J64:J71)","v":0},{"$f":"SUM(K64:K71)","v":0},{"$f":"SUM(L64:L71)","v":0},{"$f":"SUM(M64:M71)","v":0},{"$f":"SUM(N64:N71)","v":0}]
[10.01,"Fund Balance June 30 for Certification of Appropriations",1542378,6392960,{"$f":"+E59-E61","v":1406359},{"$f":"+F59-F61","v":824346},{"$f":"+G59-G61","v":203639},{"$f":"+H59-H61","v":1031577},{"$f":"IF(OR(G73=0,F73 = 0),0,AVERAGE((G73-F73)/F73,(H73-G73)/G73))","v":1.6563726537577765},{"$f":"+J59-J61-J72","v":-293095.43907205388},{"$f":"+K59-K61-K72","v":-2950004.2130529806},{"$f":"+L59-L61-L72","v":-6245005.5952777117},{"$f":"+M59-M61-M72","v":-10248891.492114801},{"$f":"+N59-N61-N72","v":-14678741.254836071}]
[]
[null,"Revenue from Replacement/Renewal Levies",null,null," "," "," "]
[11.01,"  Income Tax  -  Renewal",0,0,0,0,0,0,{"$f":"IF(OR(G76=0,F76 = 0),0,AVERAGE((G76-F76)/F76,(H76-G76)/G76))","v":0}]
[11.02,"  Property Tax - Renewal or Replacement",0,0,null,0,0,0,{"$f":"IF(OR(G77=0,F77 = 0),0,AVERAGE((G77-F77)/F77,(H77-G77)/G77))","v":0},{"$f":"+'Note Calc'!E50","v":0},{"$f":"+'Note Calc'!F50","v":385153.60000000003},{"$f":"+'Note Calc'!G50","v":740680},{"$f":"+'Note Calc'!H50","v":1177236.1200000001},{"$f":"+'Note Calc'!I50","v":1177236.1200000001}]
[null,null,null,null,0]
[11.3,"Cumulative Balance of Replacement/Renewal Levies",0,0,0,0,0,{"$f":"+H76+H77","v":0},{"$f":"IF(OR(G79=0,F79 = 0),0,AVERAGE((G79-F79)/F79,(H79-G79)/G79))","v":0},{"$f":"+J76+J77","v":0},{"$f":"SUM(K76:K77)+J79","v":385153.60000000003},{"$f":"SUM(L76:L77)+K79","v":1125833.6000000001},{"$f":"SUM(M76:M77)+L79","v":2303069.7200000002},{"$f":"SUM(N76:N77)+M79","v":3480305.8400000003}]
[12.01," Fund Balance June 30 for Certification of Contracts, Salary Schedules and Other Obligations",1542378,6392960,{"$f":"+E73+E79","v":1406359},{"$f":"+F73+F79","v":824346},{"$f":"+G73+G79","v":203639},{"$f":"+H73+H79","v":1031577},{"$f":"IF(OR(G80=0,F80 = 0),0,AVERAGE((G80-F80)/F80,(H80-G80)/G80))","v":1.6563726537577765},{"$f":"+J73+J79","v":-293095.43907205388},{"$f":"+K73+K79","v":-2564850.6130529805},{"$f":"+L73+L79","v":-5119171.9952777121},{"$f":"+M73+M79","v":-7945821.7721148003},{"$f":"+N73+N79","v":-11198435.414836071}]
[null,null,null,null,0,0,0,0]
[null,"Revenue from New Levies"]
[13.01,"  Income Tax  -  New",null,null,0,0,0,0,{"$f":"IF(OR(G83=0,F83 = 0),0,AVERAGE((G83-F83)/F83,(H83-G83)/G83))","v":0},{"$f":"'Note Calc'!E58","v":0},{"$f":"'Note Calc'!F58","v":0},{"$f":"'Note Calc'!G58","v":0},{"$f":"'Note Calc'!H58","v":0},{"$f":"'Note Calc'!I58","v":0}]
[13.02,"  Property Tax  -  New",0,0,null,null,null,null,{"$f":"IF(OR(G84=0,F84 = 0),0,AVERAGE((G84-F84)/F84,(H84-G84)/G84))","v":0},{"$f":"'Note Calc'!E59","v":0},{"$f":"'Note Calc'!F59","v":0},{"$f":"'Note Calc'!G59","v":0},{"$f":"'Note Calc'!H59","v":0},{"$f":"'Note Calc'!I59","v":0}]
[]
[13.03,"Cumulative Balance of New Levies",0,0,null,null,null,null,{"$f":"IF(OR(G86=0,F86 = 0),0,AVERAGE((G86-F86)/F86,(H86-G86)/G86))","v":0},{"$f":"SUM(J83:J84)","v":0},{"$f":"SUM(K83:K84)","v":0},{"$f":"SUM(L83:L84)","v":0},{"$f":"SUM(M83:M84)","v":0},{"$f":"SUM(N83:N84)","v":0}]
[null,null,null,null,0,0,0,0]
[14.01,"Revenue from Future State Advancements",null,0,null,null,null,null,{"$f":"IF(OR(G88=0,F88 = 0),0,AVERAGE((G88-F88)/F88,(H88-G88)/G88))","v":0},{"$f":"'Note Calc'!E198","v":0},{"$f":"'Note Calc'!F198","v":0},{"$f":"'Note Calc'!G198","v":0},{"$f":"'Note Calc'!H198","v":0},{"$f":"'Note Calc'!I198","v":0}]
[null,null,null,null,0,0,0,0]
[15.01,"Unreserved Fund Balance June 30",1542378,6392960,{"$f":"+E80+E86","v":1406359},{"$f":"+F80+F86","v":824346},{"$f":"+G80+G86","v":203639},{"$f":"+H80+H86","v":1031577},{"$f":"IF(OR(G90=0,F90 = 0),0,AVERAGE((G90-F90)/F90,(H90-G90)/G90))","v":1.6563726537577765},{"$f":"+J80+J86+J88","v":-293095.43907205388},{"$f":"+K80+K86+K88","v":-2564850.6130529805},{"$f":"+L80+L86+L88","v":-5119171.9952777121},{"$f":"+M80+M86+M88","v":-7945821.7721148003},{"$f":"+N80+N86+N88","v":-11198435.414836071}]
[null,null,null,null," "," ",0]
[null,"ADM Forecasts"]
[20.010000000000002,"  Kindergarten - October Count",null,null,0,0,0,0,{"$f":"IF(OR(G93=0,F93 = 0),0,AVERAGE((G93-F93)/F93,(H93-G93)/G93))","v":0},101,{"$f":"+J93*1","v":101},101,101,101]
[20.015000000000001,"  Grades 1-12 - October Count",null,null,null,0,0,0,{"$f":"IF(OR(G94=0,F94 = 0),0,AVERAGE((G94-F94)/F94,(H94-G94)/G94))","v":0},1561,1561,1561,1561,1561]
[null,"State Fiscal Stabilization Funds- Information Only"]
[21.01,"  Personal Services SFSF",null,null,null,0,0,279666,{"$f":"IF(OR(G96=0,F96 = 0),0,AVERAGE((G96-F96)/F96,(H96-G96)/G96))","v":0},{"$f":"+'Note Calc'!E418","v":385139},{"$f":"+'Note Calc'!F418","v":0},{"$f":"+'Note Calc'!G418","v":0},{"$f":"+'Note Calc'!H418","v":0},{"$f":"+'Note Calc'!I418","v":0}]
[21.02,"  Employees Retirement/Insurance Benefits SFSF",null,null,null,0,0,31148,0,{"$f":"+'Note Calc'!E419","v":42896},{"$f":"+'Note Calc'!F419","v":0},{"$f":"+'Note Calc'!G419","v":0},{"$f":"+'Note Calc'!H419","v":0},{"$f":"+'Note Calc'!I419","v":0}]
[21.03,"  Purchased Services SFSF",null,null,null,0,0,0,0,{"$f":"+'Note Calc'!E420","v":0},{"$f":"+'Note Calc'!F420","v":0},{"$f":"+'Note Calc'!G420","v":0},{"$f":"+'Note Calc'!H420","v":0},{"$f":"+'Note Calc'!I420","v":0}]
[21.04,"  Supplies and Materials SFSF",null,null,0,0,0,0,0,{"$f":"+'Note Calc'!E421","v":0},{"$f":"+'Note Calc'!F421","v":0},{"$f":"+'Note Calc'!G421","v":0},{"$f":"+'Note Calc'!H421","v":0},{"$f":"+'Note Calc'!I421","v":0}]
[21.05,"  Capital Outlay SFSF",null,null,0,0,0,0,0,{"$f":"+'Note Calc'!E422","v":0},{"$f":"+'Note Calc'!F422","v":0},{"$f":"+'Note Calc'!G422","v":0},{"$f":"+'Note Calc'!H422","v":0},{"$f":"+'Note Calc'!I422","v":0}]
[21.06,"Total Expenditures - SFSF",null,null,0,0,0,{"$f":"SUM(H96:H100)","v":310814},0,{"$f":"SUM(J96:J100)","v":428035},{"$f":"SUM(K96:K100)","v":0},{"$f":"SUM(L96:L100)","v":0},{"$f":"SUM(M96:M100)","v":0},{"$f":"SUM(N96:N100)","v":0}]
[]
[null,"See accompanying summary of significant forecast assumptions and accounting policies"]
[null,"Includes:  General fund, Emergency Levy fund, PBA fund (FY07-FY09), Textbook fund and any portion of Debt Service fund related to General fund debt"]
[null,"Fund 532 SFSF and Ed Jobs Funds Fund 504."]

{"sheet":"State Model By %","index":3,"n_rows":104,"n_cols":13,"rows_kept":104,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'New State Model Fcast'!A1","v":"Liberty Local School District"}]
[{"$f":"+'New State Model Fcast'!A2","v":"Trumbull County"}]
[null,"Schedule of Percentage Changes of Revenues, Expenditures and Changes in Fund Balances"]
[{"$f":"+'New State Model Fcast'!A5","v":"Forecasted Fiscal Years Ending June 30, 2011 Through 2015"}]
[]
[]
[null,null,null,"Forecasted"]
[" ",null,"Historical Annual","Fiscal Year","% ","Fiscal Year","% ","Fiscal Year","% ","Fiscal Year","% ","Fiscal Year","% "]
[" ",null,"Average Change",{"$f":"+'Front Pg'!A47","v":2011},"change",{"$f":"+D9+1","v":2012},"change",{"$f":"+F9+1","v":2013},"change",{"$f":"+H9+1","v":2014},"change",{"$f":"+J9+1","v":2015},"change"]
[]
[null,"Revenues"]
[1.01,"General Property Tax (Real Estate)",{"$f":"+'New State Model Fcast'!I12","v":8.4963704055681724E-2},{"$f":"+'New State Model Fcast'!J12","v":7847606},{"$f":"IF('New State Model Fcast'!F12=0,0,('State Model By %'!D12-'New State Model Fcast'!F12)/'State Model By %'!D12)","v":5.0239270422087957E-2},{"$f":"+'New State Model Fcast'!K12","v":7599224.0622279029},{"$f":"IF(D12=0,0,(+F12-D12)/D12)","v":-3.1650663625581749E-2},{"$f":"+'New State Model Fcast'!L12","v":7396527.5937365498},{"$f":"IF(F12=0,0,(+H12-F12)/F12)","v":-2.6673311226452709E-2},{"$f":"+'New State Model Fcast'!M12","v":7087560.3954898324},{"$f":"IF(H12=0,0,(+J12-H12)/H12)","v":-4.1771925316462531E-2},{"$f":"+'New State Model Fcast'!N12","v":6714468.3152141031},{"$f":"IF(J12=0,0,(+L12-J12)/J12)","v":-5.2640409316744075E-2}]
[1.02,"Tangible Personal Property Tax",{"$f":"+'New State Model Fcast'!I13","v":-0.59204396432114736},{"$f":"+'New State Model Fcast'!J13","v":13980.544280000002},{"$f":"IF('New State Model Fcast'!F13=0,0,('State Model By %'!D13-'New State Model Fcast'!F13)/'State Model By %'!D13)","v":-22.164048088119209},{"$f":"+'New State Model Fcast'!K13","v":0},-1,{"$f":"+'New State Model Fcast'!L13","v":0},0,{"$f":"+'New State Model Fcast'!M13","v":0},0,{"$f":"+'New State Model Fcast'!N13","v":0},0]
[1.03,"Income Tax",{"$f":"+'New State Model Fcast'!I14","v":0},{"$f":"+'New State Model Fcast'!J14","v":0},{"$f":"IF('New State Model Fcast'!F14=0,0,('State Model By %'!D14-'New State Model Fcast'!F14)/'State Model By %'!D14)","v":0},{"$f":"+'New State Model Fcast'!K14","v":0},0,{"$f":"+'New State Model Fcast'!L14","v":0},0,{"$f":"+'New State Model Fcast'!M14","v":0},0,{"$f":"+'New State Model Fcast'!N14","v":0},0]
[1.0349999999999999,"Unrestricted State Grants-in-Aid",{"$f":"+'New State Model Fcast'!I15","v":-2.196579045794601E-2},{"$f":"+'New State Model Fcast'!J15","v":4913821.6399999997},{"$f":"IF('New State Model Fcast'!F15=0,0,('State Model By %'!D15-'New State Model Fcast'!F15)/'State Model By %'!D15)","v":-8.6482658739725923E-2},{"$f":"+'New State Model Fcast'!K15","v":4807519.5497639999},-2.1633282203543675E-2,{"$f":"+'New State Model Fcast'!L15","v":4894315.6831790702},1.8054244505221237E-2,{"$f":"+'New State Model Fcast'!M15","v":5289025.5938342363},8.0646598259224836E-2,{"$f":"+'New State Model Fcast'!N15","v":5683735.5044894014},7.4628096168659938E-2]
[1.04,"Restricted State Grants-in-Aid",{"$f":"+'New State Model Fcast'!I16","v":-0.36732347593522546},{"$f":"+'New State Model Fcast'!J16","v":8569},{"$f":"IF('New State Model Fcast'!F16=0,0,('State Model By %'!D16-'New State Model Fcast'!F16)/'State Model By %'!D16)","v":-14.549305636597035},{"$f":"+'New State Model Fcast'!K16","v":8569},0,{"$f":"+'New State Model Fcast'!L16","v":8569},0,{"$f":"+'New State Model Fcast'!M16","v":8569},0,{"$f":"+'New State Model Fcast'!N16","v":8569},0]
[1.0449999999999999,"Restricted Federal Grants-in-Aid - SFSF",{"$f":"+'New State Model Fcast'!I17","v":0},{"$f":"+'New State Model Fcast'!J17","v":428035},{"$f":"IF('New State Model Fcast'!F17=0,0,('State Model By %'!D17-'New State Model Fcast'!F17)/'State Model By %'!D17)","v":0},{"$f":"+'New State Model Fcast'!K17","v":219093},-0.48814232480988706,{"$f":"+'New State Model Fcast'!L17","v":0},-1,{"$f":"+'New State Model Fcast'!M17","v":0},0,{"$f":"+'New State Model Fcast'!N17","v":0},0]
[1.05,"Property Tax Allocation",{"$f":"+'New State Model Fcast'!I18","v":0.13695556095204725},{"$f":"+'New State Model Fcast'!J18","v":1661392.3296479448},{"$f":"IF('New State Model Fcast'!F18=0,0,('State Model By %'!D18-'New State Model Fcast'!F18)/'State Model By %'!D18)","v":0.21733236828200464},{"$f":"+'New State Model Fcast'!K18","v":1612262.5193571697},-2.9571468107828461E-2,{"$f":"+'New State Model Fcast'!L18","v":1565994.6397629448},-2.86974850799562E-2,{"$f":"+'New State Model Fcast'!M18","v":1258605.0828170574},-0.19629029955838101,{"$f":"+'New State Model Fcast'!N18","v":1147454.4076110474},-8.8312590441179825E-2]
[1.06,"All Other Revenues",{"$f":"+'New State Model Fcast'!I19","v":-5.3633613062213127E-2},{"$f":"+'New State Model Fcast'!J19","v":1041500.227},{"$f":"IF('New State Model Fcast'!F19=0,0,('State Model By %'!D19-'New State Model Fcast'!F19)/'State Model By %'!D19)","v":4.1067899834456738E-2},{"$f":"+'New State Model Fcast'!K19","v":1048769.72927},6.9798374321430228E-3,{"$f":"+'New State Model Fcast'!L19","v":1056111.9265627},7.0007715590823805E-3,{"$f":"+'New State Model Fcast'!M19","v":1063527.5458283271},7.0216224995796979E-3,{"$f":"+'New State Model Fcast'!N19","v":1071017.3212866103},7.0423897224494124E-3]
[1.07,"Total Revenues",{"$f":"SUM(C12:C19)","v":-0.81304757876880307},{"$f":"SUM(D12:D19)","v":15914904.740927946},{"$f":"IF('New State Model Fcast'!F20=0,0,('State Model By %'!D20-'New State Model Fcast'!F20)/'State Model By %'!D20)","v":2.3037570560197285E-2},{"$f":"SUM(F12:F19)","v":15295437.860619072},-3.8923693882741701E-2,{"$f":"SUM(H12:H19)","v":14921518.843241267},-2.4446440878984479E-2,{"$f":"SUM(J12:J19)","v":14707287.617969453},-1.4357199660599567E-2,{"$f":"SUM(L12:L19)","v":14625244.548601162},-5.5783956565893852E-3]
[]
[null,"Other Financing Sources"]
[2.0099999999999998,"Proceeds from Sale of Notes",{"$f":"+'New State Model Fcast'!I23","v":0},{"$f":"+'New State Model Fcast'!J23","v":0},{"$f":"IF('New State Model Fcast'!F23=0,0,('State Model By %'!D23-'New State Model Fcast'!F23)/'State Model By %'!D23)","v":0},{"$f":"+'New State Model Fcast'!K23","v":0},{"$f":"IF(D23=0,0,(+F23-D23)/D23)","v":0},{"$f":"+'New State Model Fcast'!L23","v":0},0,{"$f":"+'New State Model Fcast'!M23","v":0},0,{"$f":"+'New State Model Fcast'!N23","v":0},0]
[2.02,"State Emergency Loans and Advancements (Approved)",{"$f":"+'New State Model Fcast'!I24","v":0},{"$f":"+'New State Model Fcast'!J24","v":0},{"$f":"IF('New State Model Fcast'!F24=0,0,('State Model By %'!D24-'New State Model Fcast'!F24)/'State Model By %'!D24)","v":0},{"$f":"+'New State Model Fcast'!K24","v":0},0,{"$f":"+'New State Model Fcast'!L24","v":0},0,{"$f":"+'New State Model Fcast'!M24","v":0},0,{"$f":"+'New State Model Fcast'!N24","v":0},0]
[2.04,"Operating Transfers-In",{"$f":"+'New State Model Fcast'!I25","v":0},{"$f":"+'New State Model Fcast'!J25","v":0},{"$f":"IF('New State Model Fcast'!F25=0,0,('State Model By %'!D25-'New State Model Fcast'!F25)/'State Model By %'!D25)","v":0},{"$f":"+'New State Model Fcast'!K25","v":0},0,{"$f":"+'New State Model Fcast'!L25","v":0},0,{"$f":"+'New State Model Fcast'!M25","v":0},0,{"$f":"+'New State Model Fcast'!N25","v":0},0]
[2.0499999999999998,"Advances-In",{"$f":"+'New State Model Fcast'!I26","v":0},{"$f":"+'New State Model Fcast'!J26","v":0},0,{"$f":"+'New State Model Fcast'!K26","v":0},0,{"$f":"+'New State Model Fcast'!L26","v":0},0,{"$f":"+'New State Model Fcast'!M26","v":0},0,{"$f":"+'New State Model Fcast'!N26","v":0},0]
[2.06,"All Other Financing Sources",{"$f":"+'New State Model Fcast'!I27","v":0},{"$f":"+'New State Model Fcast'!J27","v":0},{"$f":"IF('New State Model Fcast'!F27=0,0,('State Model By %'!D27-'New State Model Fcast'!F27)/'State Model By %'!D27)","v":0},{"$f":"+'New State Model Fcast'!K27","v":0},0,{"$f":"+'New State Model Fcast'!L27","v":0},0,{"$f":"+'New State Model Fcast'!M27","v":0},0,{"$f":"+'New State Model Fcast'!N27","v":0},0]
[2.0699999999999998,"Total Other Financing Sources",{"$f":"SUM(C23:C27)","v":0},{"$f":"SUM(D23:D27)","v":0},{"$f":"IF('New State Model Fcast'!F28=0,0,('State Model By %'!D28-'New State Model Fcast'!F28)/'State Model By %'!D28)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F23:F27)","v":0},0,0,0,0,0,0,0]
[2.08,"Total Revenues and Other Financing Sources",{"$f":"+C28+C20","v":-0.81304757876880307},{"$f":"+D28+D20","v":15914904.740927946},{"$f":"IF('New State Model Fcast'!F29=0,0,('State Model By %'!D29-'New State Model Fcast'!F29)/'State Model By %'!D29)","v":1.9590110402996182E-2},{"$f":"+F28+F20","v":15295437.860619072},-3.8923693882741701E-2,14921518.843241267,-2.4446440878984479E-2,14707287.617969453,-1.4357199660599567E-2,14625244.548601162,-5.5783956565893852E-3]
[]
[null,"Expenditures"]
[3.01,"Personal Services",{"$f":"+'New State Model Fcast'!I32","v":-3.9835988354770188E-2},{"$f":"+'New State Model Fcast'!J32","v":7253818},{"$f":"IF('New State Model Fcast'!F32=0,0,('State Model By %'!D32-'New State Model Fcast'!F32)/'State Model By %'!D32)","v":-0.12423678123713608},{"$f":"+'New State Model Fcast'!K32","v":7313914},{"$f":"IF(D32=0,0,(+F32-D32)/D32)","v":8.2847405325030214E-3},{"$f":"+'New State Model Fcast'!L32","v":7438251},{"$f":"IF(F32=0,0,(+H32-F32)/F32)","v":1.7000063167272681E-2},{"$f":"+'New State Model Fcast'!M32","v":7564701},{"$f":"IF(H32=0,0,(+J32-H32)/H32)","v":1.6999964104464881E-2},{"$f":"+'New State Model Fcast'!N32","v":7693301},{"$f":"IF(J32=0,0,(+L32-J32)/J32)","v":1.7000010972013303E-2}]
[3.02,"Employees' Retirement/Insurance Benefits",{"$f":"+'New State Model Fcast'!I33","v":0.10622367675010067},{"$f":"+'New State Model Fcast'!J33","v":3473269},{"$f":"IF('New State Model Fcast'!F33=0,0,('State Model By %'!D33-'New State Model Fcast'!F33)/'State Model By %'!D33)","v":0.10296323146868268},{"$f":"+'New State Model Fcast'!K33","v":3670487},5.6781665917612488E-2,{"$f":"+'New State Model Fcast'!L33","v":3902413},6.3186710646298438E-2,{"$f":"+'New State Model Fcast'!M33","v":4148589},6.3083020684894187E-2,{"$f":"+'New State Model Fcast'!N33","v":4411123},6.3282720944398199E-2]
[3.03,"Purchased Services",{"$f":"+'New State Model Fcast'!I34","v":0.10950233665391115},{"$f":"+'New State Model Fcast'!J34","v":4217896.9799999995},{"$f":"IF('New State Model Fcast'!F34=0,0,('State Model By %'!D34-'New State Model Fcast'!F34)/'State Model By %'!D34)","v":0.34181038248117662},{"$f":"+'New State Model Fcast'!K34","v":4349836.8306},3.1280956179257011E-2,{"$f":"+'New State Model Fcast'!L34","v":4462603.3651860002},2.5924313710508923E-2,{"$f":"+'New State Model Fcast'!M34","v":4578531.9983069403},2.5977803455563924E-2,{"$f":"+'New State Model Fcast'!N34","v":4697714.5117078554},2.603072632122843E-2]
[3.04,"Supplies and Materials",{"$f":"+'New State Model Fcast'!I35","v":-0.19660127145467457},{"$f":"+'New State Model Fcast'!J35","v":322067},{"$f":"IF('New State Model Fcast'!F35=0,0,('State Model By %'!D35-'New State Model Fcast'!F35)/'State Model By %'!D35)","v":-0.56071252254965587},{"$f":"+'New State Model Fcast'!K35","v":325288},1.000102463152077E-2,{"$f":"+'New State Model Fcast'!L35","v":328541},1.0000368903863653E-2,{"$f":"+'New State Model Fcast'!M35","v":331826},9.9987520583427938E-3,{"$f":"+'New State Model Fcast'!N35","v":335144},9.9992164568177295E-3]
[3.05,"Capital Outlay",{"$f":"+'New State Model Fcast'!I36","v":-0.25730497666910623},{"$f":"+'New State Model Fcast'!J36","v":36337.200000000004},{"$f":"IF('New State Model Fcast'!F36=0,0,('State Model By %'!D36-'New State Model Fcast'!F36)/'State Model By %'!D36)","v":-1.4488127868960732},{"$f":"+'New State Model Fcast'!K36","v":38880.804000000004},6.9999999999999979E-2,{"$f":"+'New State Model Fcast'!L36","v":41602.460280000007},7.0000000000000062E-2,{"$f":"+'New State Model Fcast'!M36","v":44514.632499600011},7.0000000000000104E-2,{"$f":"+'New State Model Fcast'!N36","v":47630.656774572017},7.0000000000000104E-2]
[3.06,"Intergovernmental",{"$f":"+'New State Model Fcast'!I37","v":0},{"$f":"+'New State Model Fcast'!J37","v":0},{"$f":"IF('New State Model Fcast'!F37=0,0,('State Model By %'!D37-'New State Model Fcast'!F37)/'State Model By %'!D37)","v":0},{"$f":"+'New State Model Fcast'!K37","v":0},0,{"$f":"+'New State Model Fcast'!L37","v":0},0,{"$f":"+'New State Model Fcast'!M37","v":0},0,{"$f":"+'New State Model Fcast'!N37","v":0},0]
[null,"Debt Service:"]
[4.01,"  Principal-All (Historical Only)",{"$f":"+'New State Model Fcast'!I39","v":0},{"$f":"+'New State Model Fcast'!J39","v":0},{"$f":"IF('New State Model Fcast'!F39=0,0,('State Model By %'!D39-'New State Model Fcast'!F39)/'State Model By %'!D39)","v":0},{"$f":"+'New State Model Fcast'!K39","v":0},{"$f":"IF(D39=0,0,(+F39-D39)/D39)","v":0},{"$f":"+'New State Model Fcast'!L39","v":0},{"$f":"IF(F39=0,0,(+H39-F39)/F39)","v":0},{"$f":"+'New State Model Fcast'!M39","v":0},{"$f":"IF(H39=0,0,(+J39-H39)/H39)","v":0},{"$f":"+'New State Model Fcast'!N39","v":0},{"$f":"IF(J39=0,0,(+L39-J39)/J39)","v":0}]
[4.0199999999999996,"  Principal-Notes",{"$f":"+'New State Model Fcast'!I40","v":-2.7894371682168708E-2},{"$f":"+'New State Model Fcast'!J40","v":523000},{"$f":"IF('New State Model Fcast'!F40=0,0,('State Model By %'!D40-'New State Model Fcast'!F40)/'State Model By %'!D40)","v":0.28071319311663478},{"$f":"+'New State Model Fcast'!K40","v":523000},0,{"$f":"+'New State Model Fcast'!L40","v":523000},0,{"$f":"+'New State Model Fcast'!M40","v":523000},0,{"$f":"+'New State Model Fcast'!N40","v":355200},-0.3208413001912046]
[4.03,"  Principal-State Loans",{"$f":"+'New State Model Fcast'!I41","v":0},{"$f":"+'New State Model Fcast'!J41","v":0},{"$f":"IF('New State Model Fcast'!F41=0,0,('State Model By %'!D41-'New State Model Fcast'!F41)/'State Model By %'!D41)","v":0},{"$f":"+'New State Model Fcast'!K41","v":0},0,{"$f":"+'New State Model Fcast'!L41","v":0},0,{"$f":"+'New State Model Fcast'!M41","v":0},0,{"$f":"+'New State Model Fcast'!N41","v":0},0]
[4.04,"  Principal-State Advancements",{"$f":"+'New State Model Fcast'!I42","v":0},{"$f":"+'New State Model Fcast'!J42","v":0},{"$f":"IF('New State Model Fcast'!F42=0,0,('State Model By %'!D42-'New State Model Fcast'!F42)/'State Model By %'!D42)","v":0},{"$f":"+'New State Model Fcast'!K42","v":0},0,{"$f":"+'New State Model Fcast'!L42","v":0},0,{"$f":"+'New State Model Fcast'!M42","v":0},0,{"$f":"+'New State Model Fcast'!N42","v":0},0]
[4.05,"  Principal-HB 264 Loans",{"$f":"+'New State Model Fcast'!I43","v":0},{"$f":"+'New State Model Fcast'!J43","v":0},{"$f":"IF('New State Model Fcast'!F43=0,0,('State Model By %'!D43-'New State Model Fcast'!F43)/'State Model By %'!D43)","v":0},{"$f":"+'New State Model Fcast'!K43","v":0},0,{"$f":"+'New State Model Fcast'!L43","v":0},0,{"$f":"+'New State Model Fcast'!M43","v":0},0,{"$f":"+'New State Model Fcast'!N43","v":0},0]
[4.0549999999999997,"  Principal-Other",{"$f":"+'New State Model Fcast'!I44","v":0},{"$f":"+'New State Model Fcast'!J44","v":0},{"$f":"IF('New State Model Fcast'!F44=0,0,('State Model By %'!D44-'New State Model Fcast'!F44)/'State Model By %'!D44)","v":0},{"$f":"+'New State Model Fcast'!K44","v":0},0,{"$f":"+'New State Model Fcast'!L44","v":0},0,{"$f":"+'New State Model Fcast'!M44","v":0},0,{"$f":"+'New State Model Fcast'!N44","v":0},0]
[4.0599999999999996,"  Interest and Fiscal Charges",{"$f":"+'New State Model Fcast'!I45","v":0},{"$f":"+'New State Model Fcast'!J45","v":61850},{"$f":"IF('New State Model Fcast'!F45=0,0,('State Model By %'!D45-'New State Model Fcast'!F45)/'State Model By %'!D45)","v":0},{"$f":"+'New State Model Fcast'!K45","v":54346},-0.12132578819725141,{"$f":"+'New State Model Fcast'!L45","v":42268},-0.22224266735362308,{"$f":"+'New State Model Fcast'!M45","v":30192},-0.28570076653733323,{"$f":"+'New State Model Fcast'!N45","v":18115},-0.40000662427133016]
[4.3,"Other Objects",{"$f":"+'New State Model Fcast'!I46","v":0.59362715075120986},{"$f":"+'New State Model Fcast'!J46","v":1502000},{"$f":"IF('New State Model Fcast'!F46=0,0,('State Model By %'!D46-'New State Model Fcast'!F46)/'State Model By %'!D46)","v":0.36872902796271639},{"$f":"+'New State Model Fcast'!K46","v":1400933},-6.7288282290279625E-2,{"$f":"+'New State Model Fcast'!L46","v":1407841.4},4.9312850793006568E-3,{"$f":"+'New State Model Fcast'!M46","v":1414818.8840000001},4.9561577035596282E-3,{"$f":"+'New State Model Fcast'!N46","v":1421866.1428400001},4.9810324980084329E-3]
[4.5,"Total Expenditures",{"$f":"SUM(C32:C46)","v":0.28771655599450197},{"$f":"SUM(D32:D46)","v":17390238.18},{"$f":"IF('New State Model Fcast'!F47=0,0,('State Model By %'!D47-'New State Model Fcast'!F47)/'State Model By %'!D47)","v":8.2081117304167922E-2},{"$f":"SUM(F32:F46)","v":17676685.634599999},1.6471738433659504E-2,{"$f":"SUM(H32:H46)","v":18146520.225465998},2.6579337358715847E-2,{"$f":"SUM(J32:J46)","v":18636173.514806543},2.6983315988780451E-2,{"$f":"SUM(L32:L46)","v":18980094.311322432},1.8454474908308968E-2]
[]
[null,"Other Financing Uses"]
[5.01,"Operating Transfers-Out",{"$f":"+'New State Model Fcast'!I50","v":3.5055605454232088},{"$f":"+'New State Model Fcast'!J50","v":60000},{"$f":"IF('New State Model Fcast'!F50=0,0,('State Model By %'!D50-'New State Model Fcast'!F50)/'State Model By %'!D50)","v":0.59826666666666661},{"$f":"+'New State Model Fcast'!K50","v":65000},{"$f":"IF(D50=0,0,(+F50-D50)/D50)","v":8.3333333333333329E-2},{"$f":"+'New State Model Fcast'!L50","v":70000},{"$f":"IF(F50=0,0,(+H50-F50)/F50)","v":7.6923076923076927E-2},{"$f":"+'New State Model Fcast'!M50","v":75000},{"$f":"IF(H50=0,0,(+J50-H50)/H50)","v":7.1428571428571425E-2},{"$f":"+'New State Model Fcast'!N50","v":75000},{"$f":"IF(J50=0,0,(+L50-J50)/J50)","v":0}]
[5.0199999999999996,"Advances-Out",{"$f":"+'New State Model Fcast'!I51","v":0},{"$f":"+'New State Model Fcast'!J51","v":0},{"$f":"IF('New State Model Fcast'!F51=0,0,('State Model By %'!D51-'New State Model Fcast'!F51)/'State Model By %'!D51)","v":0},{"$f":"+'New State Model Fcast'!K51","v":0},0,{"$f":"+'New State Model Fcast'!L51","v":0},0,{"$f":"+'New State Model Fcast'!M51","v":0},0,{"$f":"+'New State Model Fcast'!N51","v":0},0]
[5.03,"All Other Financing Uses",{"$f":"+'New State Model Fcast'!I52","v":0},{"$f":"+'New State Model Fcast'!J52","v":0},{"$f":"IF('New State Model Fcast'!F52=0,0,('State Model By %'!D52-'New State Model Fcast'!F52)/'State Model By %'!D52)","v":0},{"$f":"+'New State Model Fcast'!K52","v":0},0,{"$f":"+'New State Model Fcast'!L52","v":0},0,{"$f":"+'New State Model Fcast'!M52","v":0},0,{"$f":"+'New State Model Fcast'!N52","v":0},0]
[5.04,"Total Other Financing Uses",{"$f":"SUM(C50:C52)","v":3.5055605454232088},{"$f":"SUM(D50:D52)","v":60000},{"$f":"IF('New State Model Fcast'!F53=0,0,('State Model By %'!D53-'New State Model Fcast'!F53)/'State Model By %'!D53)","v":0.59826666666666661},{"$f":"SUM(F50:F52)","v":65000},8.3333333333333329E-2,{"$f":"SUM(H50:H52)","v":70000},7.6923076923076927E-2,{"$f":"SUM(J50:J52)","v":75000},7.1428571428571425E-2,{"$f":"SUM(L50:L52)","v":75000},0]
[5.05,"Total Expenditures and Other Financing Uses",{"$f":"+C53+C47","v":3.7932771014177109},{"$f":"+D53+D47","v":17450238.18},{"$f":"IF('New State Model Fcast'!F54=0,0,('State Model By %'!D54-'New State Model Fcast'!F54)/'State Model By %'!D54)","v":8.3855943105528422E-2},{"$f":"+F53+F47","v":17741685.634599999},1.6701631897152645E-2,{"$f":"+H53+H47","v":18216520.225465998},2.6763781111078459E-2,{"$f":"+J53+J47","v":18711173.514806543},2.7154104253623485E-2,{"$f":"+L53+L47","v":19055094.311322432},1.8380503833377301E-2]
[6.01,"Excess of Revenues and Other Financing Sources over (under) Expenditures and Other Financing Uses",{"$f":"+C29-C54","v":-4.6063246801865141},{"$f":"+D29-D54","v":-1535333.4390720539},{"$f":"IF('New State Model Fcast'!F55=0,0,('State Model By %'!D55-'New State Model Fcast'!F55)/'State Model By %'!D55)","v":0.75002042537940972},{"$f":"+F29-F54","v":-2446247.7739809267},0.59330065491143336,{"$f":"+H29-H54","v":-3295001.3822247311},0.34696142282536507,{"$f":"+J29-J54","v":-4003885.8968370892},0.21513936790330898,{"$f":"+L29-L54","v":-4429849.7627212703},0.10638761364820003]
[]
[7.01,"Cash Balance July 1 - Excluding Proposed Renewal/Replacement and New Levies",{"$f":"+'New State Model Fcast'!I57","v":-0.36694227097296889},{"$f":"+'New State Model Fcast'!J57","v":1242238},{"$f":"IF('New State Model Fcast'!F57=0,0,('State Model By %'!D57-'New State Model Fcast'!F57)/'State Model By %'!D57)","v":-0.31228556846594613},{"$f":"+D59","v":-293095.43907205388},{"$f":"IF(D57=0,0,(+F57-D57)/D57)","v":-1.2359414533060926},{"$f":"+F59","v":-2739343.2130529806},{"$f":"IF(F57=0,0,(+H57-F57)/F57)","v":8.3462498827201035},{"$f":"+H59","v":-6034344.5952777117},{"$f":"IF(H57=0,0,(+J57-H57)/H57)","v":1.2028435745196284},{"$f":"+J59","v":-10038230.492114801},{"$f":"IF(J57=0,0,(+L57-J57)/J57)","v":0.66351628310560928}]
[]
[7.02,"Cash Balance June 30",{"$f":"+C55+C57","v":-4.9732669511594834},{"$f":"+D55+D57","v":-293095.43907205388},{"$f":"IF('New State Model Fcast'!F59=0,0,('State Model By %'!D59-'New State Model Fcast'!F59)/'State Model By %'!D59)","v":5.2524339646704483},{"$f":"+F55+F57","v":-2739343.2130529806},{"$f":"IF(D59=0,0,(+F59-D59)/D59)","v":8.3462498827201035},{"$f":"+H55+H57","v":-6034344.5952777117},{"$f":"IF(F59=0,0,(+H59-F59)/F59)","v":1.2028435745196284},{"$f":"+J55+J57","v":-10038230.492114801},{"$f":"IF(H59=0,0,(+J59-H59)/H59)","v":0.66351628310560928},{"$f":"+L55+L57","v":-14468080.254836071},{"$f":"IF(J59=0,0,(+L59-J59)/J59)","v":0.44129787278753879}]
[]
[8.01,"Estimated Encumbrances June 30",{"$f":"+'New State Model Fcast'!I61","v":-0.25073704724277024},{"$f":"+'New State Model Fcast'!J61","v":0},{"$f":"IF('New State Model Fcast'!F61=0,0,('State Model By %'!D61-'New State Model Fcast'!F61)/'State Model By %'!D61)","v":{"$error":"#DIV/0!"}},{"$f":"+'New State Model Fcast'!K61","v":210661},{"$f":"IF(D61=0,0,(+F61-D61)/D61)","v":0},{"$f":"+'New State Model Fcast'!L61","v":210661},{"$f":"IF(F61=0,0,(+H61-F61)/F61)","v":0},{"$f":"+'New State Model Fcast'!M61","v":210661},{"$f":"IF(H61=0,0,(+J61-H61)/H61)","v":0},{"$f":"+'New State Model Fcast'!N61","v":210661},{"$f":"IF(J61=0,0,(+L61-J61)/J61)","v":0}]
[]
[null,"Reservation of Fund Balance  "]
[9.01,"     Textbooks and Instructional Materials",{"$f":"+'New State Model Fcast'!I64","v":0},{"$f":"+'New State Model Fcast'!J64","v":0},{"$f":"IF('New State Model Fcast'!F64=0,0,('State Model By %'!D64-'New State Model Fcast'!F64)/'State Model By %'!D64)","v":0},{"$f":"+'New State Model Fcast'!J64","v":0},{"$f":"IF(D64=0,0,(+F64-D64)/D64)","v":0},{"$f":"+'New State Model Fcast'!K64","v":0},{"$f":"IF(F64=0,0,(+H64-F64)/F64)","v":0},{"$f":"+'New State Model Fcast'!L64","v":0},{"$f":"IF(H64=0,0,(+J64-H64)/H64)","v":0},{"$f":"+'New State Model Fcast'!M64","v":0},{"$f":"IF(J64=0,0,(+L64-J64)/J64)","v":0}]
[9.02,"     Capital Improvements",{"$f":"+'New State Model Fcast'!I65","v":0},{"$f":"+'New State Model Fcast'!J65","v":0},{"$f":"IF('New State Model Fcast'!F65=0,0,('State Model By %'!D65-'New State Model Fcast'!F65)/'State Model By %'!D65)","v":0},{"$f":"+'New State Model Fcast'!J65","v":0},0,{"$f":"+'New State Model Fcast'!K65","v":0},0,{"$f":"+'New State Model Fcast'!L65","v":0},0,{"$f":"+'New State Model Fcast'!M65","v":0},0]
[9.0299999999999994,"     Budget Reserve",{"$f":"+'New State Model Fcast'!I66","v":0},{"$f":"+'New State Model Fcast'!J66","v":0},{"$f":"IF('New State Model Fcast'!F66=0,0,('State Model By %'!D66-'New State Model Fcast'!F66)/'State Model By %'!D66)","v":0},{"$f":"+'New State Model Fcast'!J66","v":0},0,{"$f":"+'New State Model Fcast'!K66","v":0},0,{"$f":"+'New State Model Fcast'!L66","v":0},0,{"$f":"+'New State Model Fcast'!M66","v":0},0]
[9.0399999999999991,"     DPIA",{"$f":"+'New State Model Fcast'!I67","v":0},{"$f":"+'New State Model Fcast'!J67","v":0},{"$f":"IF('New State Model Fcast'!F67=0,0,('State Model By %'!D67-'New State Model Fcast'!F67)/'State Model By %'!D67)","v":0},{"$f":"+'New State Model Fcast'!J67","v":0},0,{"$f":"+'New State Model Fcast'!K67","v":0},0,{"$f":"+'New State Model Fcast'!L67","v":0},0,{"$f":"+'New State Model Fcast'!M67","v":0},0]
[9.0449999999999999,"     Fiscal Stabilization",{"$f":"+'New State Model Fcast'!I68","v":0},{"$f":"+'New State Model Fcast'!J68","v":0},{"$f":"IF('New State Model Fcast'!F68=0,0,('State Model By %'!D68-'New State Model Fcast'!F68)/'State Model By %'!D68)","v":0},{"$f":"+'New State Model Fcast'!J68","v":0},0,{"$f":"+'New State Model Fcast'!K68","v":0},0,{"$f":"+'New State Model Fcast'!L68","v":0},0,{"$f":"+'New State Model Fcast'!M68","v":0},0]
[9.0500000000000007,"     Debt Service",{"$f":"+'New State Model Fcast'!I69","v":0},{"$f":"+'New State Model Fcast'!J69","v":0},{"$f":"IF('New State Model Fcast'!F69=0,0,('State Model By %'!D69-'New State Model Fcast'!F69)/'State Model By %'!D69)","v":0},{"$f":"+'New State Model Fcast'!J69","v":0},0,{"$f":"+'New State Model Fcast'!K69","v":0},0,{"$f":"+'New State Model Fcast'!L69","v":0},0,{"$f":"+'New State Model Fcast'!M69","v":0},0]
[9.06,"     Property Tax Advances",{"$f":"+'New State Model Fcast'!I70","v":0},{"$f":"+'New State Model Fcast'!J70","v":0},{"$f":"IF('New State Model Fcast'!F70=0,0,('State Model By %'!D70-'New State Model Fcast'!F70)/'State Model By %'!D70)","v":0},{"$f":"+'New State Model Fcast'!J70","v":0},0,{"$f":"+'New State Model Fcast'!K70","v":0},0,{"$f":"+'New State Model Fcast'!L70","v":0},0,{"$f":"+'New State Model Fcast'!M70","v":0},0]
[9.07,"     Bus Purchases",{"$f":"+'New State Model Fcast'!I71","v":0},{"$f":"+'New State Model Fcast'!J71","v":0},{"$f":"IF('New State Model Fcast'!F71=0,0,('State Model By %'!D71-'New State Model Fcast'!F71)/'State Model By %'!D71)","v":0},{"$f":"+'New State Model Fcast'!J71","v":0},0,{"$f":"+'New State Model Fcast'!K71","v":0},0,{"$f":"+'New State Model Fcast'!L71","v":0},0,{"$f":"+'New State Model Fcast'!M71","v":0},0]
[9.08,"  Subtotal",{"$f":"SUM(C64:C71)","v":0},{"$f":"SUM(D64:D71)","v":0},{"$f":"IF('New State Model Fcast'!F72=0,0,('State Model By %'!D72-'New State Model Fcast'!F72)/'State Model By %'!D72)","v":0},0,0,0,0,0,0,0,0]
[10.01,"Fund Balance June 30 for Certification of Appropriations",{"$f":"+C59+C61+C72","v":-5.2240039984022539},{"$f":"+D59+D61+D72","v":-293095.43907205388},{"$f":"IF('New State Model Fcast'!F73=0,0,('State Model By %'!D73-'New State Model Fcast'!F73)/'State Model By %'!D73)","v":3.8125514426628273},{"$f":"+F59+F61+F72","v":-2528682.2130529806},{"$f":"IF(D73=0,0,(+F73-D73)/D73)","v":7.6275044779230949},-5823683.5952777117,{"$f":"IF(F73=0,0,(+H73-F73)/F73)","v":1.3030508006170307},-9827569.492114801,{"$f":"IF(H73=0,0,(+J73-H73)/H73)","v":0.68751775939265425},-14257419.254836071,{"$f":"IF(J73=0,0,(+L73-J73)/J73)","v":0.45075740917177765}]
[]
[null,"Revenue from Replacement/Renewal Levies"]
[11.01,"  Income Tax  -  Renewal",{"$f":"+'New State Model Fcast'!G76","v":0},{"$f":"+'New State Model Fcast'!H76","v":0},{"$f":"IF('New State Model Fcast'!F76=0,0,('State Model By %'!D76-'New State Model Fcast'!F76)/'State Model By %'!D76)","v":0},{"$f":"+'New State Model Fcast'!J76","v":0},{"$f":"IF(D76=0,0,(+F76-D76)/D76)","v":0},{"$f":"+'New State Model Fcast'!K76","v":0},{"$f":"IF(F76=0,0,(+H76-F76)/F76)","v":0},{"$f":"+'New State Model Fcast'!L76","v":0},{"$f":"IF(H76=0,0,(+J76-H76)/H76)","v":0},{"$f":"+'New State Model Fcast'!M76","v":0},{"$f":"IF(J76=0,0,(+L76-J76)/J76)","v":0}]
[11.02,"  Property Tax - Renewal or Replacement",{"$f":"+'New State Model Fcast'!G77","v":0},{"$f":"+'New State Model Fcast'!H77","v":0},{"$f":"IF('New State Model Fcast'!F77=0,0,('State Model By %'!D77-'New State Model Fcast'!F77)/'State Model By %'!D77)","v":0},{"$f":"+'New State Model Fcast'!J77","v":0},{"$f":"IF(D77=0,0,(+F77-D77)/D77)","v":0},{"$f":"+'New State Model Fcast'!K77","v":385153.60000000003},{"$f":"IF(F77=0,0,(+H77-F77)/F77)","v":0},{"$f":"+'New State Model Fcast'!L77","v":740680},{"$f":"IF(H77=0,0,(+J77-H77)/H77)","v":0.92307692307692291},{"$f":"+'New State Model Fcast'!M77","v":1177236.1200000001},{"$f":"IF(J77=0,0,(+L77-J77)/J77)","v":0.58939909272560365}]
[11.3,"Cumulative Balance of Replacement/Renewal Levies",{"$f":"+'New State Model Fcast'!G79","v":0},{"$f":"+'New State Model Fcast'!H79","v":0},{"$f":"IF('New State Model Fcast'!F79=0,0,('State Model By %'!D78-'New State Model Fcast'!F79)/'State Model By %'!D78)","v":0},{"$f":"+'New State Model Fcast'!J79","v":0},{"$f":"IF(D78=0,0,(+F78-D78)/D78)","v":0},{"$f":"+'New State Model Fcast'!K79","v":385153.60000000003},{"$f":"IF(F78=0,0,(+H78-F78)/F78)","v":0},{"$f":"+'New State Model Fcast'!L79","v":1125833.6000000001},{"$f":"IF(H78=0,0,(+J78-H78)/H78)","v":1.9230769230769229},{"$f":"+'New State Model Fcast'!M79","v":2303069.7200000002},{"$f":"IF(J78=0,0,(+L78-J78)/J78)","v":1.0456572978457919}]
[]
[12.01," Fund Balance June 30 for Certification of Contracts, Salary Schedules and Other Obligations",{"$f":"+C73+C78","v":-5.2240039984022539},{"$f":"+D73+D78","v":-293095.43907205388},{"$f":"IF('New State Model Fcast'!F80=0,0,('State Model By %'!D80-'New State Model Fcast'!F80)/'State Model By %'!D80)","v":3.8125514426628273},{"$f":"+F73+F78","v":-2528682.2130529806},{"$f":"IF(D80=0,0,(+F80-D80)/D80)","v":7.6275044779230949},{"$f":"+H73+H78","v":-5438529.9952777121},{"$f":"IF(F80=0,0,(+H80-F80)/F80)","v":1.1507368411911096},{"$f":"+J73+J78","v":-8701735.8921148013},{"$f":"IF(H80=0,0,(+J80-H80)/H80)","v":0.60001616239508437},{"$f":"+L73+L78","v":-11954349.534836071},{"$f":"IF(J80=0,0,(+L80-J80)/J80)","v":0.37378905577548843}]
[]
[null,"Revenue from New Levies"]
[13.01,"  Income Tax  -  New",{"$f":"+'New State Model Fcast'!G83","v":0},{"$f":"+'New State Model Fcast'!H83","v":0},{"$f":"IF('New State Model Fcast'!F83=0,0,('State Model By %'!D83-'New State Model Fcast'!F83)/'State Model By %'!D83)","v":0},{"$f":"+'New State Model Fcast'!J83","v":0},{"$f":"IF(D83=0,0,(+F83-D83)/D83)","v":0},{"$f":"+'New State Model Fcast'!K83","v":0},{"$f":"IF(F83=0,0,(+H83-F83)/F83)","v":0},{"$f":"+'New State Model Fcast'!L83","v":0},{"$f":"IF(H83=0,0,(+J83-H83)/H83)","v":0},{"$f":"+'New State Model Fcast'!M83","v":0},{"$f":"IF(J83=0,0,(+L83-J83)/J83)","v":0}]
[13.02,"  Property Tax  -  New",{"$f":"+'New State Model Fcast'!G84","v":0},{"$f":"+'New State Model Fcast'!H84","v":0},{"$f":"IF('New State Model Fcast'!F84=0,0,('State Model By %'!D84-'New State Model Fcast'!F84)/'State Model By %'!D84)","v":0},{"$f":"+'New State Model Fcast'!J84","v":0},{"$f":"IF(D84=0,0,(+F84-D84)/D84)","v":0},{"$f":"+'New State Model Fcast'!K84","v":0},{"$f":"IF(F84=0,0,(+H84-F84)/F84)","v":0},{"$f":"+'New State Model Fcast'!L84","v":0},{"$f":"IF(H84=0,0,(+J84-H84)/H84)","v":0},{"$f":"+'New State Model Fcast'!M84","v":0},{"$f":"IF(J84=0,0,(+L84-J84)/J84)","v":0}]
[null,null,null,null,{"$f":"IF('New State Model Fcast'!F85=0,0,('State Model By %'!D85-'New State Model Fcast'!F85)/'State Model By %'!D85)","v":0}]
[13.03,"Cumulative Balance of New Levies",{"$f":"+'New State Model Fcast'!G86","v":0},{"$f":"+'New State Model Fcast'!H86","v":0},{"$f":"IF('New State Model Fcast'!F86=0,0,('State Model By %'!D86-'New State Model Fcast'!F86)/'State Model By %'!D86)","v":0},{"$f":"+'New State Model Fcast'!J86","v":0},{"$f":"IF(D86=0,0,(+F86-D86)/D86)","v":0},{"$f":"+'New State Model Fcast'!K86","v":0},{"$f":"IF(F86=0,0,(+H86-F86)/F86)","v":0},{"$f":"+'New State Model Fcast'!L86","v":0},{"$f":"IF(H86=0,0,(+J86-H86)/H86)","v":0},{"$f":"+'New State Model Fcast'!M86","v":0},{"$f":"IF(J86=0,0,(+L86-J86)/J86)","v":0}]
[]
[14.01,"Revenue from Future State Advancements",{"$f":"+'New State Model Fcast'!G88","v":0},{"$f":"+'New State Model Fcast'!H88","v":0},{"$f":"IF('New State Model Fcast'!F88=0,0,('State Model By %'!D88-'New State Model Fcast'!F88)/'State Model By %'!D88)","v":0},{"$f":"+'New State Model Fcast'!J88","v":0},{"$f":"IF(D88=0,0,(+F88-D88)/D88)","v":0},{"$f":"+'New State Model Fcast'!K88","v":0},{"$f":"IF(F88=0,0,(+H88-F88)/F88)","v":0},{"$f":"+'New State Model Fcast'!L88","v":0},{"$f":"IF(H88=0,0,(+J88-H88)/H88)","v":0},{"$f":"+'New State Model Fcast'!M88","v":0},{"$f":"IF(J88=0,0,(+L88-J88)/J88)","v":0}]
[]
[15.01,"Unreserved Fund Balance June 30",{"$f":"+'New State Model Fcast'!G90","v":203639},{"$f":"+'New State Model Fcast'!H90","v":1031577},{"$f":"IF('New State Model Fcast'!F90=0,0,('State Model By %'!D90-'New State Model Fcast'!F90)/'State Model By %'!D90)","v":0.20088757310409208},{"$f":"+'New State Model Fcast'!J90","v":-293095.43907205388},{"$f":"IF(D90=0,0,(+F90-D90)/D90)","v":-1.2841236660686055},{"$f":"+'New State Model Fcast'!K90","v":-2564850.6130529805},{"$f":"IF(F90=0,0,(+H90-F90)/F90)","v":7.750905920519779},{"$f":"+'New State Model Fcast'!L90","v":-5119171.9952777121},{"$f":"IF(H90=0,0,(+J90-H90)/H90)","v":0.99589479762499078},{"$f":"+'New State Model Fcast'!M90","v":-7945821.7721148003},{"$f":"IF(J90=0,0,(+L90-J90)/J90)","v":0.55216933118179867}]
[]
[null,"ADM Forecasts"]
[20.010000000000002,"  Kindergarten - October Count",{"$f":"+'New State Model Fcast'!G93","v":0},{"$f":"+'New State Model Fcast'!H93","v":0},{"$f":"IF('New State Model Fcast'!F93=0,0,('State Model By %'!D93-'New State Model Fcast'!F93)/'State Model By %'!D93)","v":0},{"$f":"+'New State Model Fcast'!J93","v":101},{"$f":"IF(D93=0,0,(+F93-D93)/D93)","v":0},{"$f":"+'New State Model Fcast'!K93","v":101},0,{"$f":"+'New State Model Fcast'!L93","v":101},0,{"$f":"+'New State Model Fcast'!M93","v":101},0]
[20.015000000000001,"  Grades 1-12 - October Count",{"$f":"+'New State Model Fcast'!G94","v":0},{"$f":"+'New State Model Fcast'!H94","v":0},{"$f":"IF('New State Model Fcast'!F94=0,0,('State Model By %'!D94-'New State Model Fcast'!F94)/'State Model By %'!D94)","v":0},{"$f":"+'New State Model Fcast'!J94","v":1561},0,{"$f":"+'New State Model Fcast'!K94","v":1561},0,{"$f":"+'New State Model Fcast'!L94","v":1561},0,{"$f":"+'New State Model Fcast'!M94","v":1561},0]
[null,"State Fiscal Stabilization Funds"]
[21.01,"  Personal Services SFSF",{"$f":"+'New State Model Fcast'!G96","v":0},{"$f":"+'New State Model Fcast'!H96","v":279666},{"$f":"IF('New State Model Fcast'!F96=0,0,('State Model By %'!D96-'New State Model Fcast'!F96)/'State Model By %'!D96)","v":0},{"$f":"+'New State Model Fcast'!J96","v":385139},0.37713915885377558,{"$f":"+'New State Model Fcast'!K96","v":0},-1,{"$f":"+'New State Model Fcast'!L96","v":0},0,{"$f":"+'New State Model Fcast'!M96","v":0},0]
[21.02,"  Employees Retirement/Insurance Benefits SFSF",{"$f":"+'New State Model Fcast'!G97","v":0},{"$f":"+'New State Model Fcast'!H97","v":31148},{"$f":"IF('New State Model Fcast'!F97=0,0,('State Model By %'!D97-'New State Model Fcast'!F97)/'State Model By %'!D97)","v":0},{"$f":"+'New State Model Fcast'!J97","v":42896},0.37716707332734045,{"$f":"+'New State Model Fcast'!K97","v":0},-1,{"$f":"+'New State Model Fcast'!L97","v":0},0,{"$f":"+'New State Model Fcast'!M97","v":0},0]
[21.03,"  Purchased Services SFSF",{"$f":"+'New State Model Fcast'!G98","v":0},{"$f":"+'New State Model Fcast'!H98","v":0},{"$f":"IF('New State Model Fcast'!F98=0,0,('State Model By %'!D98-'New State Model Fcast'!F98)/'State Model By %'!D98)","v":0},{"$f":"+'New State Model Fcast'!J98","v":0},0,{"$f":"+'New State Model Fcast'!K98","v":0},0,{"$f":"+'New State Model Fcast'!L98","v":0},0,{"$f":"+'New State Model Fcast'!M98","v":0},0]
[21.04,"  Supplies and Materials SFSF",{"$f":"+'New State Model Fcast'!G99","v":0},{"$f":"+'New State Model Fcast'!H99","v":0},{"$f":"IF('New State Model Fcast'!F99=0,0,('State Model By %'!D99-'New State Model Fcast'!F99)/'State Model By %'!D99)","v":0},{"$f":"+'New State Model Fcast'!J99","v":0},0,{"$f":"+'New State Model Fcast'!K99","v":0},0,{"$f":"+'New State Model Fcast'!L99","v":0},0,{"$f":"+'New State Model Fcast'!M99","v":0},0]
[21.05,"  Capital Outlay SFSF",{"$f":"+'New State Model Fcast'!G100","v":0},{"$f":"+'New State Model Fcast'!H100","v":0},{"$f":"IF('New State Model Fcast'!F100=0,0,('State Model By %'!D100-'New State Model Fcast'!F100)/'State Model By %'!D100)","v":0},{"$f":"+'New State Model Fcast'!J100","v":0},0,{"$f":"+'New State Model Fcast'!K100","v":0},0,{"$f":"+'New State Model Fcast'!L100","v":0},0,{"$f":"+'New State Model Fcast'!M100","v":0},0]
[21.06,"Total Expenditures - SFSF",{"$f":"SUM(C96:C100)","v":0},{"$f":"SUM(D96:D100)","v":310814},{"$f":"IF('New State Model Fcast'!F101=0,0,('State Model By %'!D101-'New State Model Fcast'!F101)/'State Model By %'!D101)","v":0},{"$f":"SUM(F96:F100)","v":428035},0.37714195628253555,{"$f":"SUM(H96:H100)","v":0},-1,{"$f":"SUM(J96:J100)","v":0},0,{"$f":"SUM(L96:L100)","v":0},0]
[]
[null,"See accompanying summary of significant forecast assumptions and accounting policies"]
[null,"Includes:  General fund, Emergency Levy fund, DPIA fund, Textbook fund and any portion of Debt Service fund related to General fund debt"]

{"sheet":"Note Calc","index":4,"n_rows":425,"n_cols":12,"rows_kept":425,"cut":false,"hidden":false,"merged":[[8,0,8,7],[9,0,9,7],[39,0,39,7],[62,0,62,7],[202,0,202,7],[84,0,84,7],[293,0,293,7],[307,0,307,7],[220,0,220,7],[74,0,74,7],[170,0,170,7],[102,0,102,7],[138,0,138,7],[412,0,412,7],[384,0,384,7],[331,0,331,7],[319,0,319,7],[355,0,355,7],[370,0,370,7]]}
[{"$f":"+'State Model By %'!A1","v":"Liberty Local School District"}]
["Instructions and Note Calculation Sheet"]
[{"$f":"NOW()","v":"2011-07-14T08:00:11.220"}]
[]
["INTRODUCTION"]
["These are the instructions for you to update you five year forecast. Use this tab a research and documentation, these"]
[]
[]
["REVENUE ASSUMPTIONS"]
["Section 1       REAL ESTATE VALUE ASSUMPTIONS - Line#1.010"]
["Location of Data : Classification is ok the New Base section needs worked on the TAX Tab"]
[]
["ESTIMATED ASSESSED VALUE (AV) BY COLLECTION YEARS "]
[]
[null,null,"Actual","Actual","Estimated","Estimated","Estimated","Estimated","Estimated"]
[null,null,"TAX YEAR 2008","TAX YEAR 2009","TAX YEAR 2010","TAX YEAR 2011","TAX YEAR 2012","TAX YEAR 2013","TAX YEAR 2014"]
["Classification",null,"COLLECT 2009","COLLECT 2010","COLLECT 2011","COLLECT 2012","COLLECT 2013","COLLECT 2014","COLLECT 2015"]
["Res./Ag.",null,{"$f":"+TAX!E7","v":172637070},{"$f":"+TAX!F7","v":173371540},{"$f":"+TAX!G7","v":173371540},{"$f":"+TAX!H7","v":173371540},{"$f":"+TAX!I7","v":173371540},{"$f":"+TAX!J7","v":173371540},{"$f":"+TAX!K7","v":173371540}]
["Comm./Ind.",null,{"$f":"+TAX!E8","v":53432710},{"$f":"+TAX!F8","v":54568870},{"$f":"+TAX!G8","v":54568870},{"$f":"+TAX!H8","v":54568870},{"$f":"+TAX!I8","v":54568870},{"$f":"+TAX!J8","v":54568870},{"$f":"+TAX!K8","v":54568870},null," Data automatically comes"]
["Public Utility Personal Property (PUPP)",null,{"$f":"+TAX!E9","v":4778850},{"$f":"+TAX!F9","v":4947040},{"$f":"+TAX!G9","v":4947040},{"$f":"+TAX!H9","v":4947040},{"$f":"+TAX!I9","v":4947040},{"$f":"+TAX!J9","v":4947040},{"$f":"+TAX!K9","v":4947040},null,"from the Tax Sheet summary"]
["Tangible Personal Property (TPP)",null,{"$f":"+TAX!E10","v":1180240},{"$f":"+TAX!F10","v":397310},{"$f":"+TAX!G10","v":0},{"$f":"+TAX!H10","v":0},{"$f":"+TAX!I10","v":0},{"$f":"+TAX!J10","v":0},{"$f":"+TAX!K10","v":0},null,"at bottom of page….NO ENTRY NEEDED HERE"]
["Total Assessed Valuation",null,{"$f":"SUM(C17:C21)","v":232028870},233284760,232887450,232887450,232887450,232887450,{"$f":"SUM(I17:I21)","v":232887450}]
[]
[]
["ESTIMATED REAL ESTATE TAX - Line #1.010"]
["Source",null,"FY09","FY10","FY11","FY12","FY13","FY14","FY15"]
["Est. Gen. Prop. Taxes Excluding TPP to Line #1.010",null,{"$f":"+TAX!E28","v":7928866},{"$f":"+TAX!F28","v":7847606},{"$f":"+TAX!G28","v":7599224.0622279029},{"$f":"+TAX!H28","v":7396527.5937365498},{"$f":"+TAX!I28","v":7087560.3954898324},{"$f":"+TAX!J28","v":6714468.3152141031},{"$f":"+TAX!K28","v":6392350.7493563928}]
[]
[]
["Delinquency Issues: (Due to the economic down turn may wan to note any information helpful to explain lower collections)"]
["As a result of the very difficult economic times, our district has experienced an increase in delinquencies as noted below:"]
[]
["Close of Settlement By Year",null,"Real Est. Del.","Amt.","% +/(-)"]
[2005,null,0]
[2006,null,0,{"$f":"C35-C34","v":0},{"$f":"D35/C34","v":{"$error":"#DIV/0!"}}]
[2007,null,0,{"$f":"C36-C35","v":0},{"$f":"D36/C35","v":{"$error":"#DIV/0!"}}]
[2008,null,0,{"$f":"C37-C36","v":0},{"$f":"D37/C36","v":{"$error":"#DIV/0!"}}]
[]
[]
["Section 2      RENEWAL/ REPLACEMENT/NEW LEVIES - Line#11.02"]
["Location of Data : From the "]
["RENEWAL AND REPLACEMENT LEVIES - Line # 11.020"]
["Emergency levies are shown at gross and A&T , DRETAC fees are left in the expense area under other so showing gross on renewal and replacement levies keeps"]
["at the actual net amount ot be collected.  Delinquencies are not calculated as eventually all taxes should be collected."]
[]
["Source",null,"FY09","FY10","FY11","FY12","FY13","FY14","FY15"]
["Renew 7.45 Mill  Emergency levy 2016 ",null,0,{"$f":"TAX!F159","v":0},{"$f":"TAX!G159","v":0},{"$f":"TAX!H159","v":0},{"$f":"TAX!I159","v":0},{"$f":"TAX!J159","v":0},{"$f":"TAX!K159","v":0}]
["Renew  3.1 Mill Emergency Levy 2012",null,0,{"$f":"TAX!F160","v":0},{"$f":"TAX!G160","v":0},{"$f":"TAX!H160","v":385153.60000000003},{"$f":"TAX!I160","v":740680},{"$f":"TAX!J160","v":740680},{"$f":"TAX!K160","v":740680}]
["Renew  3.55 Mill Emergency Levy 2014",null,0,{"$f":"TAX!F161","v":0},{"$f":"TAX!G161","v":0},{"$f":"TAX!H161","v":0},{"$f":"TAX!I161","v":0},{"$f":"TAX!J161","v":436556.12},{"$f":"TAX!K161","v":436556.12}]
["Total Line # 11.020",null,{"$f":"SUM(C46:C48)","v":0},{"$f":"SUM(D46:D48)","v":0},{"$f":"SUM(E46:E48)","v":0},{"$f":"SUM(F46:F48)","v":385153.60000000003},{"$f":"SUM(G46:G48)","v":740680},{"$f":"SUM(H47:H49)","v":1177236.1200000001},{"$f":"SUM(I47:I49)","v":1177236.1200000001}]
[]
["Accumulative Total",null,null,{"$f":"D50","v":0},{"$f":"E50+D52","v":0},{"$f":"F50+E52","v":385153.60000000003},{"$f":"G50+F52","v":1125833.6000000001},{"$f":"H50+G52","v":2303069.7200000002},{"$f":"I50+H52","v":3480305.8400000003}]
[]
["NEW TAX LEVIES - Line #13.10 and Line # 13.20"]
[]
[]
["Source and Type of New Revenue",null,"FY09","FY10","FY11","FY12","FY13","FY14","FY15"]
["New SDIT Line # 13.10",null,0,{"$f":"+TAX!F165","v":0},{"$f":"+TAX!G165","v":0},{"$f":"+TAX!H165","v":0},{"$f":"+TAX!I165","v":0},{"$f":"+TAX!J165","v":0},{"$f":"+TAX!K165","v":0}]
["New Levy Modeled Line # 13.20",null,0,{"$f":"+TAX!F166","v":0},{"$f":"+TAX!G166","v":0},{"$f":"+TAX!H166","v":0},{"$f":"+TAX!I166","v":0},{"$f":"+TAX!J166","v":0},{"$f":"+TAX!K166","v":0}]
["Total Line # 13.30",null,{"$f":"C58+C59","v":0},0,0,0,0,0,{"$f":"I58+I59","v":0}]
[" "]
[]
["Section 3    TANGIBLE PERSONAL TAX AND PUBLIC UTILITY - Line #1.020"]
["ESTIMATED TANGIBLE PERSONAL TAX  - Line #1.020"]
[]
[]
["TPP will be completely phased out as a result of HB66 at the end of Calendar year end 2010 as result of Hb 66."]
[" "]
[]
["Source",null,{"$f":"C26","v":"FY09"},"FY10","FY11","FY12","FY13","FY14",{"$f":"I26","v":"FY15"}]
["Tangible Personal Property  Taxes (TPP)",null,172823,48780,{"$f":"+TAX!G29","v":13980.544280000002},{"$f":"+TAX!H29","v":0},{"$f":"+TAX!I29","v":0},{"$f":"+TAX!J29","v":0},{"$f":"+TAX!K29","v":0},null," "]
["Total Line # 1.020",null,{"$f":"SUM(C71:C71)","v":172823},48780,13980.544280000002,0,0,0,{"$f":"SUM(I71:I71)","v":0},null," "]
[null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null," "]
["Section 4    SCHOOL DISTRICT INCOME TAX COLLECTIONS - Line #1.030"]
[" SDIT REVENUES - Line # 1.030"]
["Source","FY08",{"$f":"C26","v":"FY09"},"FY10","FY11","FY12","FY13","FY14",{"$f":"I26","v":"FY15"},null,null,"Collection in FY10 are estimated to be down by 12%"]
["SDIT Collection",0,{"$f":"B80","v":0},0,0,0,0,0,0]
["Adjustments ",0,0,{"$f":"-D78*0.1","v":0},0,0,0,0,0]
["Total  to Line #1.030",{"$f":"SUM(B78:B79)","v":0},{"$f":"SUM(C78:C79)","v":0},0,0,0,0,0,{"$f":"SUM(I78:I79)","v":0}]
[]
[]
[]
[]
["Section 5 OTHER LOCAL REVENUES - LINE #1.060"]
["LEARN Community school will return $110,000 plus $30,000 =$140,000 in FY11 and LEAD will return $110,000 in FY11"]
["OTHER LOCAL REVENUES - Line # 1.060"]
[]
[]
["Source",null,{"$f":"C26","v":"FY09"},"FY10","FY11","FY12","FY13","FY14",{"$f":"I26","v":"FY15"}]
["Open Enrollment Gross",null,{"$f":"884141-179254","v":704887},668277.69999999995,{"$f":"+D91*1.01","v":674960.47699999996},{"$f":"+E91*1.01","v":681710.08176999993},{"$f":"+F91*1.01","v":688527.18258769996},{"$f":"+G91*1.01","v":695412.45441357698},{"$f":"+H91*1.01","v":702366.57895771274},null,"Input %  +/-  Adjustment"]
["Interest ",null,36686,9642,{"$f":"+D92*1","v":9642},{"$f":"+E92*1","v":9642},{"$f":"+F92*1","v":9642},{"$f":"+G92*1","v":9642},{"$f":"+H92*1","v":9642},null,"Input % of GF revenue"]
["Community Schools LEARN & LEAD",null,null,110000,250000,250000,250000,250000,250000]
["Tuition SF-14 & SF-14H",null,77030,51475,{"$f":"+D94*1.01","v":51989.75},{"$f":"+E94*1.01","v":52509.647499999999},{"$f":"+F94*1.01","v":53034.743974999998},{"$f":"+G94*1.01","v":53565.091414750001},{"$f":"+H94*1.01","v":54100.742328897504}]
["Other Income and rentals",null,139479,54908,{"$f":"+D95*1","v":54908},{"$f":"+E95*1","v":54908},{"$f":"+F95*1","v":54908},{"$f":"+G95*1","v":54908},{"$f":"+H95*1","v":54908}]
["Total Line # 1.060",null,{"$f":"SUM(C91:C95)","v":958082},894303,{"$f":"SUM(E91:E95)","v":1041500.227},{"$f":"SUM(F91:F95)","v":1048769.72927},{"$f":"SUM(G91:G95)","v":1056111.9265627},{"$f":"SUM(H91:H95)","v":1063527.5458283271},{"$f":"SUM(I91:I95)","v":1071017.3212866103}]
[]
["Interest as % of Operating Revenus"]
[]
[]
[]
[]
[" Section 6    STATE TAXES REIMBURSEMENT/PROPERTY TAX ALLOCATION - Line # 1.050"]
[]
["a) ROLLBACK & HOMESTEAD REIMBURSEMENT"]
[" "]
["Source",null,{"$f":"C26","v":"FY09"},"FY10","FY11","FY12","FY13","FY14",{"$f":"I26","v":"FY15"}]
["Base R & H",null,1116207,{"$f":"+TAX!F30","v":1118809},{"$f":"+TAX!G30","v":1127745.3296479448},{"$f":"+TAX!H30","v":1078615.5193571697},{"$f":"+TAX!I30","v":1032347.6397629448},{"$f":"+TAX!J30","v":976086.0828170575},{"$f":"+TAX!K30","v":927717.40761104738}]
["New Levy- (Gross receipts not net of R&H)",null,0,0,0,0,0,0,0]
["Total Rollback & Homestead",null,{"$f":"SUM(C108:C109)","v":1116207},1118809,1127745.3296479448,1078615.5193571697,1032347.6397629448,976086.0828170575,{"$f":"SUM(I108:I109)","v":927717.40761104738}]
[]
["b) TANGIBLE PERSONAL PROPERTY REIMBURSEMENTS - Fixed Rate"]
[]
["These amounts reflect the state's reimbursement of tangible personal property tax  that is being phased out in HB66.  The numbers"]
["noted are from Ohio Department of taxation reports estimating payments to the district for both fixed Rate and Sum Levies."]
[]
["Source",null,{"$f":"C26","v":"FY09"},"FY10","FY11","FY12","FY13","FY14",{"$f":"I26","v":"FY15"}]
["TPP Reimbursement - Fixed Rate",null,319220,{"$f":"+TAX!F153","v":406784},{"$f":"+TAX!G153","v":414779},{"$f":"+TAX!H153","v":414779},{"$f":"+TAX!I153","v":414779},{"$f":"+TAX!J153","v":219588.88235294117},{"$f":"+TAX!K153","v":170791.35294117648},null," "]
["Total TPP Fixed Rate",null,{"$f":"C118","v":319220},406784,414779,414779,414779,219588.88235294117,{"$f":"I118","v":170791.35294117648}]
[]
["c) TANGIBLE PERSONAL PROPERTY REIMBURSEMENTS - Fixed Sum"]
[]
["These amounts reflect the state's reimbursement of tangible personal property tax  that is being phased out in HB66. "]
[]
["Source",null,{"$f":"C117","v":"FY09"},"FY10","FY11","FY12","FY13","FY14",{"$f":"I117","v":"FY15"}]
["TPP Reimbursement - Fixed Sum",null,118868,{"$f":"+TAX!F152","v":150857},{"$f":"+TAX!G152","v":118868},{"$f":"+TAX!H152","v":118868},{"$f":"+TAX!I152","v":118868},{"$f":"+TAX!J152","v":62930.117647058825},{"$f":"+TAX!K152","v":48945.647058823524},null,"  "]
["Total TPP Fixed Sum",null,{"$f":"C126","v":118868},150857,118868,118868,118868,62930.117647058825,{"$f":"I126","v":48945.647058823524}]
[]
["SUMMARY OF STATE TAX REIMBURSEMENT"]
[]
["Source",null,{"$f":"C125","v":"FY09"},"FY10","FY11","FY12","FY13","FY14",{"$f":"I125","v":"FY15"}]
["Rollback and Homestead",null,{"$f":"C110","v":1116207},1118809,1127745.3296479448,1078615.5193571697,1032347.6397629448,976086.0828170575,{"$f":"I110","v":927717.40761104738}]
["TPP Reimbursement - Fixed Rate",null,{"$f":"C119","v":319220},406784,414779,414779,414779,219588.88235294117,{"$f":"I119","v":170791.35294117648}]
["TPP Reimbursement - Fixed Sum",null,{"$f":"C127","v":118868},150857,118868,118868,118868,62930.117647058825,{"$f":"I127","v":48945.647058823524}]
["Total Tax Reimb./Prop Allocations Line #1.050",null,{"$f":"SUM(C132:C134)","v":1554295},1676450,1661392.3296479448,1612262.5193571697,1565994.6397629448,1258605.0828170574,{"$f":"SUM(I132:I134)","v":1147454.4076110474}]
[]
[]
[]
["Section 7    STATE FOUNDATION REVENUE ESTIMATES"]
[]
[]
["A) UNRESTRICTED STATE FOUNDATION REVENUE SF-3 FORM - Line #1.035"]
["FY12 &13 the distrcit has anticiapted state budget reductions of 10% then backing off to 5% in FY14.  FY15 restored funding."]
["Source",null,{"$f":"C26","v":"FY09"},"FY10","FY11","FY12","FY13","FY14",{"$f":"I26","v":"FY15"}]
["State Basic Aid",null,5297119,5105746,{"$f":"PASS!C128-(E154+E161)","v":4913821.6399999997},{"$f":"PASS!D128-F154","v":5342402.6018000003},{"$f":"PASS!E128-G154","v":5430970.0848766025},{"$f":"PASS!F128-H154","v":5557352.7946830019},{"$f":"PASS!G128-I154","v":5683735.5044894014},null,"Includes PBA which was eliminated in HB 1"]
["Other State Funding Adjustments",null,0,0,0,0,{"$f":"F146","v":0},0,0]
["State Budget Reductions 10% FY12&13; 5% FY14",null,0,0,0,{"$f":"-(E161+(0.02*F145))","v":-534883.05203599995},{"$f":"-(E161+(0.02*G145))","v":-536654.40169753204},{"$f":"0.5*G147","v":-268327.20084876602},0,null,"enter +/- % state budget"]
["Total Unrest. State Aid Line # 1.035",null,{"$f":"C145+C147","v":5297119},{"$f":"D145+D147","v":5105746},{"$f":"E145+E147","v":4913821.6399999997},{"$f":"SUM(F145:F147)","v":4807519.5497639999},{"$f":"SUM(G145:G147)","v":4894315.6831790702},{"$f":"SUM(H145:H147)","v":5289025.5938342363},{"$f":"SUM(I145:I147)","v":5683735.5044894014},null,"reduction estimate"]
[]
["B) RESTRICTED STATE REVENUES - Line #1.040"]
[]
["Source",null,{"$f":"C26","v":"FY09"},"FY10","FY11","FY12","FY13","FY14",{"$f":"I26","v":"FY15"}]
["Bus Allowance",null,37985,0,{"$f":"D153","v":0},{"$f":"E153","v":0},{"$f":"F153","v":0},{"$f":"G153","v":0},{"$f":"H153","v":0},null,"Eliminated in HB 1 2009"]
["Career Tech & Other  - Restricted",null,123600,8505,{"$f":"PASS!C120","v":8569},{"$f":"PASS!D120","v":8569},{"$f":"PASS!E120","v":8569},{"$f":"PASS!F120","v":8569},{"$f":"PASS!G120","v":8569}]
["Total Restricted State Revenues  Line #1.040",null,{"$f":"SUM(C153:C154)","v":161585},8505,8569,8569,8569,8569,{"$f":"SUM(I153:I154)","v":8569}]
[]
["C) RESTRICTED FEDERAL GRANTS IN AID - SFSF (Fund 532) & Ed Jobs Bill (Fund 504) - Line #1.045"]
["Estiamted SFSF in FY11 at 8% of state aid"]
[]
["Source",null,{"$f":"+C152","v":"FY09"},{"$f":"D26","v":"FY10"},"FY11","FY12","FY13","FY14","FY15"]
["Restricted Federal Grants in Aid Line # 1.045",null,0,310815,428035,219093,0,0,0,null,"The SFSF was used to balance FY10 and FY11 state Budgets.  It is assumed the state will put this money in PASS)"]
[null,null,null,"{SFSF}","{SFSF}","{Ed Jobs}"]
[]
["SUMMARY OF STATE FOUNDATION REVENUES"]
["Source",null,{"$f":"C26","v":"FY09"},"FY10","FY11","FY12","FY13","FY14",{"$f":"I26","v":"FY15"}]
["Unrestricted Line # 1.035",null,{"$f":"C148","v":5297119},5105746,4913821.6399999997,4807519.5497639999,4894315.6831790702,5289025.5938342363,{"$f":"I148","v":5683735.5044894014}]
["Restricted Line # 1.040",null,{"$f":"C155","v":161585},8505,8569,8569,8569,8569,{"$f":"I155","v":8569}]
["Rest. Fed. Grants in Aid- SFSF Line #1.045",null,0,{"$f":"D161","v":310815},428035,219093,0,0,0]
["Total State Foundation Revenue ",null,{"$f":"SUM(C166:C167)","v":5458704},{"$f":"SUM(D166:D168)","v":5425066},5350425.6399999997,5035181.5497639999,4902884.6831790702,5297594.5938342363,5692304.5044894014]
[]
["Section 8    SHORT TERM BORROWING & TRANSFERS IN/RETURN OF ADVANCES "]
["SHORT TERM MORROWING & TRANSFERS IN/RETURN OF ADVANCES "]
[]
["These are non-operating revenues which are the repayment of short term loans to other funds over the previous fiscal year and"]
["reimbursements for expenses received for a previous fiscal year in the current fiscal year.  All advances over year end are"]
["planned to be returned in the succeeding fiscal year."]
[" "]
["SHORT TERM BORROWING"]
["There is no planned short term borrowings at this time."]
[]
["Source",null,{"$f":"C26","v":"FY09"},"FY10","FY11","FY12","FY13","FY14",{"$f":"I26","v":"FY15"}]
["Tax Anticipation Notes (TANS) Line 2.010",null,563382,{"$f":"514105+1261895","v":1776000},0,0,0,0,0]
[]
["Source",null,{"$f":"C26","v":"FY09"},"FY10","FY11","FY12","FY13","FY14",{"$f":"I26","v":"FY15"}]
["State Emergency Loan - Line 2.020",null,0,0,0,0,0,0,0]
[]
["Source",null,{"$f":"C26","v":"FY09"},"FY10","FY11","FY12","FY13","FY14",{"$f":"I26","v":"FY15"}]
["Transfers In - Line 2.040",null,87352,0,0,0,0,0,0]
["Advance Returns - Line 2.050",null,0,0,0,0,0,0,0]
["Total Transfer & Advances In",null,{"$f":"SUM(C188:C189)","v":87352},0,0,0,0,0,{"$f":"SUM(I188:I189)","v":0}]
[]
[]
["ALL OTHER FINANCIAL SOURCES - LINE #2.060"]
[null,null,{"$f":"C26","v":"FY09"},"FY10","FY11","FY12","FY13","FY14",{"$f":"I26","v":"FY15"}]
["Refund of prior years expenditures ",null,224234,302796,0,{"$f":"E195","v":0},{"$f":"F195","v":0},{"$f":"G195","v":0},{"$f":"H195","v":0}]
[]
[null,null,{"$f":"C26","v":"FY09"},"FY10","FY11","FY12","FY13","FY14",{"$f":"I26","v":"FY15"}]
["Rev. From State Advances Line 14.010",null,0,{"$f":"C198","v":0},0,0,0,0,0]
[]
[]
[null,null,"EXPENSE ASSUMPTIONS"]
[]
["Section 9   WAGES - Line #3.010"]
["WAGES - Line #3.010"]
["Amounts noted for staff reductions are for staff reductions and wages differences between retirees and lower paid new staff."]
[]
["Source",null,{"$f":"+C187","v":"FY09"},"FY10","FY11","FY12","FY13","FY14",{"$f":"+I187","v":"FY15"}]
["Base Wages",null,7933566,7933566,{"$f":"+D216-(+D213+D214)","v":7516912.6220000004},{"$f":"+E216-E213","v":7569818.1365740001},{"$f":"+F216-F213","v":7698505.0448957579},{"$f":"+G216","v":7829379.630658986},{"$f":"+H216","v":7962479.084380189}]
["Increases",null,0,{"$f":"D217*D208","v":0},0,0,0,0,0,null,"Input negotiated % raises"]
["Steps & Training",null,0,{"$f":"0.017*D208","v":134870.622},127787.51457400002,128686.908321758,130874.58576322789,133099.45372120276,135362.14443446323,null,"Input Avg Step %"]
["Growth",null,null,{"$f":"STAFF_Plan!G16","v":0},{"$f":"STAFF_Plan!I16","v":0},{"$f":"STAFF_Plan!K16","v":0},{"$f":"STAFF_Plan!M16","v":0},{"$f":"STAFF_Plan!O16","v":0},{"$f":"STAFF_Plan!Q16","v":0}]
["Unfunded Recapture",null,null,{"$f":"STAFF_Plan!G23+STAFF_Plan!G29","v":0},{"$f":"STAFF_Plan!I23+STAFF_Plan!I29","v":0},{"$f":"STAFF_Plan!K23+STAFF_Plan!K29","v":0},{"$f":"STAFF_Plan!M23+STAFF_Plan!M29","v":0},{"$f":"STAFF_Plan!O23+STAFF_Plan!O29","v":0},{"$f":"STAFF_Plan!Q23+STAFF_Plan!Q29","v":0}]
["Retirement Incentive",null,0,0,0,0,0,0,0,null,"Input # of Staff taking incentive ($27,000 over three years)"]
["Severance - Extraordinary**",null,0,0,0,0,0,0,0,null,"Input # of Additional Retirees ($15K avg. severance)"]
["Staff Reductions",null,0,-551524,-74882,{"$f":"-STAFF_Plan!K35","v":0},{"$f":"-STAFF_Plan!M35","v":0},{"$f":"-STAFF_Plan!O35","v":0},{"$f":"-STAFF_Plan!Q35","v":0},null,"Input additional cost factors outside of staffing plan"]
["Total Wages Line 3.010",null,{"$f":"SUM(C208:C215)","v":7933566},7516912.6220000004,7569818.1365740001,7698505.0448957579,7829379.630658986,7962479.084380189,{"$f":"SUM(I208:I215)","v":8097841.2288146522},null,"new teacher if replaced, etc.)"]
["Rate Increase",null,null,0,0,0,0,0,0]
["** - This would be severance for more than the normal number of retirees due to factors like retirement incentives."]
[" "]
[]
[" Section 10    FRINGES BENEFITS - Line #3.020"]
[]
["This area of the forecast captures all costs associated with benefits and retirement costs. The district pays 14% of each dollar"]
["paid in wages to either the State Teachers Retirement System or the School Employees Retirement System as required by Ohio"]
["law. While this amount is high by private employer standards, there have been two attempts in the past couple years to raise"]
["this amount by an additional .5% a year for 5 years to 16.5%.  This would increase our district's cost by roughly $320,000 a year when"]
["fully phased in.  We have not made adjustments in the forecast for any change of this nature with STRS or SERS."]
["SERS 1/6 of a year catchup went into effect in FY11 and will end after FY16."]
["A) STRS/SERS will increase as Wages increase"]
[]
["Source",null,{"$f":"+C207","v":"FY09"},"FY10","FY11","FY12","FY13","FY14",{"$f":"+I207","v":"FY15"}]
["Base Wages",null,1174485,1174485,{"$f":"D239","v":1116153.5270799999},{"$f":"E239","v":1148560.2991203598},{"$f":"F239","v":1191576.4662854059},{"$f":"G239","v":1234898.9082922579},{"$f":"H239","v":1278532.8318132262}]
["Increases",null,{"$f":"0.14*C209","v":0},{"$f":"0.14*D209","v":0},0,0,0,{"$f":"0.14*H209","v":0},0]
["Steps & Training",null,0,{"$f":"0.14*D210","v":18881.88708},17890.252040360003,18016.167165046121,18322.442006851907,18633.92352096839,18950.700220824856]
["Growth",null,0,0,0,0,0,0,0]
["Unfunded Recapture",null,0,0,0,0,0,0,0]
["Staff Reductions",null,{"$f":"0.14*C215","v":0},{"$f":"0.14*D215","v":-77213.36},-10483.480000000001,0,0,0,{"$f":"0.14*I215","v":0}]
["Other - SERS 1/6 Pmt. Ends FY16",null,{"$f":"1.05*B238","v":0},{"$f":"0.14*C238","v":0},25000,{"$f":"E238","v":25000},{"$f":"F238","v":25000},{"$f":"G238","v":25000},{"$f":"H238","v":25000},null,"Input extraordinary cost factors"]
["Total Retirement System Estimates",null,{"$f":"SUM(C232:C238)","v":1174485},1116153.5270799999,1148560.2991203598,1191576.4662854059,1234898.9082922579,1278532.8318132262,{"$f":"SUM(I232:I238)","v":1322483.5320340511}]
[]
["B) INSURANCES"]
[]
["Estimated increases are 5% for FY10 & 11, 10% for 2012-2014, for medical, dental and vision insurances.  The trend for insurances is coming down "]
["so inflation has been adjusted down from 15% to reflect this new information which is the best data available at this time.  FY 10& 11"]
["reflects savings odue to plan changes effective Jan 1, 2009.  Both adjustments are "]
[" needed to reflect the full 12 month savings of these changes, which affect two fiscal years."]
[]
["Also noted below are adjustments for premium holidays which are one time waivers of monthly funding of our health care plan"]
["care plan.  The holidays taken in one year must be readjusted to the base of the following year so annual costs at existing funding"]
["rates are known for future forecasting. "]
[]
["Source",null,{"$f":"+C231","v":"FY09"},"FY10","FY11","FY12","FY13","FY14",{"$f":"+I231","v":"FY15"}]
["Base Costs",null,2591278,{"$f":"2567859-65176","v":2502683},{"$f":"D260","v":2370317.2400000002},{"$f":"E260","v":2541970.9391999999},{"$f":"F260","v":2745328.6143359998},{"$f":"G260","v":2964954.90348288},{"$f":"H260","v":3202151.2957615103}]
["Base  Adjustment  for Premium Holiday",null,0,0,0,0,0,0,0,null,"Adjust when premium holidays"]
["Premium Holiday",null,0,0,0,0,0,0,0,null,"are taken so base annual amount is accurate"]
["Growth",null,0,{"$f":"0.08*D211","v":0},0,0,0,{"$f":"0.08*H211","v":0},{"$f":"0.08*I211","v":0}]
["Unfunded Recapture",null,0,0,0,0,0,{"$f":"0.08*H212","v":0},{"$f":"0.08*I212","v":0}]
["Staff Reductions",null,{"$f":"0.24*C215","v":0},-132365.76000000001,-17971.68,0,0,0,{"$f":"0.24*I215","v":0}]
["Insurance Trend Adjustment",null,0,0,{"$f":"E253*E261","v":189625.37920000002},{"$f":"F261*E260","v":203357.67513600001},{"$f":"G261*F260","v":219626.28914687998},{"$f":"H261*G260","v":237196.3922786304},{"$f":"I261*H260","v":256172.10366092084},null,"Input %  +/-  Adjustment"]
["Total Insurance Estimates",null,{"$f":"SUM(C253:C259)","v":2591278},2370317.2400000002,2541970.9391999999,2745328.6143359998,2964954.90348288,3202151.2957615103,{"$f":"SUM(I253:I259)","v":3458323.3994224309}]
[null,"Percent Increase",null,null,0.08,0.08,0.08,0.08,0.08]
[]
["C) WORKERS COMPENSATION/UNEMPLOYMENT"]
["Workers compensation is expected to bre 1.58% of wages due to high claim experience and Unemployment Comp has been negligible."]
[]
[]
["Source",null,{"$f":"+C252","v":"FY09"},"FY10","FY11","FY12","FY13","FY14",{"$f":"+I252","v":"FY15"}]
["Workers Comp Base Cost Estimates",null,53948,{"$f":"53950+65176","v":119126},{"$f":"E216*0.0158","v":119603.12655786921},{"$f":"F216*0.0158","v":121636.37970935299},{"$f":"G216*0.0158","v":123704.198164412},{"$f":"H216*0.0158","v":125807.16953320699},{"$f":"I216*0.0158","v":127945.89141527152},null,"Input %  +/-  Adjustment"]
["Unemployment Compensation",null,2655,18317,3000,3000,3000,3000,3000]
["Toal BWC & UC Cost Estimates",null,{"$f":"SUM(C268:C269)","v":56603},137443,122603.12655786921,124636.37970935299,126704.198164412,128807.16953320699,{"$f":"SUM(I268:I269)","v":130945.89141527152}]
[" "]
["D) MEDICARE"]
[]
["Medicare will continue to increase at the rate of increase in wages.  Contributions are 1.45% for all new employees to the district "]
["on or after April 1, 1986.  These amounts are growing at the general growth rate of wages which will be estimated at 4%."]
[" "]
["Source",null,{"$f":"+C267","v":"FY09"},"FY10","FY11","FY12","FY13","FY14",{"$f":"+I267","v":"FY15"}]
["Base Costs",null,98026,{"$f":"0.0145*D216","v":108995.23301900001},{"$f":"E216*0.012","v":90837.817638888009},{"$f":"F216*0.012","v":92382.060538749094},{"$f":"G216*0.012","v":93952.555567907839},{"$f":"H216*0.012","v":95549.749012562272},{"$f":"I216*0.012","v":97174.09474577583},null,"% Increase is same as step inc. % and "]
["Growth",null,{"$f":"0.0145*C211","v":0},0,0,0,0,{"$f":"0.0145*H211","v":0},{"$f":"0.0145*I211","v":0},null,"base wage % adjust if those are changed."]
["Unfunded Recapture",null,0,0,0,0,0,{"$f":"0.0145*H212","v":0},{"$f":"0.0145*I212","v":0}]
["Staff Reductions",null,{"$f":"0.0145*C215","v":0},-7997.098,-1085.789,0,0,0,{"$f":"0.0145*I215","v":0}]
["Total Medicare Estimate",null,{"$f":"SUM(C278:C281)","v":98026},100998.13501900001,89752.028638888005,92382.060538749094,93952.555567907839,95549.749012562272,{"$f":"SUM(I278:I281)","v":97174.09474577583}]
[]
["SUMMARY OF FRINGE BENEFITS -Line #3.020"]
["Source",null,{"$f":"+C277","v":"FY09"},{"$f":"+D277","v":"FY10"},"FY11","FY12","FY13","FY14",{"$f":"+I277","v":"FY15"}]
["STRS/SERS",null,{"$f":"C239","v":1174485},1116153.5270799999,1148560.2991203598,1191576.4662854059,1234898.9082922579,1278532.8318132262,{"$f":"I239","v":1322483.5320340511}]
["Insurance's",null,{"$f":"C260","v":2591278},2370317.2400000002,2541970.9391999999,2745328.6143359998,2964954.90348288,3202151.2957615103,{"$f":"I260","v":3458323.3994224309}]
["Workers & UC Comp ",null,{"$f":"C268","v":53948},{"$f":"+D270","v":137443},119603.12655786921,121636.37970935299,123704.198164412,125807.16953320699,{"$f":"I268","v":127945.89141527152}]
["Medicare",null,{"$f":"C282","v":98026},100998.13501900001,89752.028638888005,92382.060538749094,93952.555567907839,95549.749012562272,{"$f":"I282","v":97174.09474577583}]
["Other/Tuition",null,0,16018,{"$f":"D290","v":16018},{"$f":"E290","v":16018},{"$f":"F290","v":16018},{"$f":"G290","v":16018},{"$f":"H290","v":16018},null,"Adjust based on % deemed appropriate for these costs."]
["Total Line 3.020",null,{"$f":"SUM(C286:C290)","v":3917737},3740929.9020990003,3915904.3935171175,4166941.5208695079,4433528.5655074576,4718059.0461205058,{"$f":"SUM(I286:I290)","v":5021944.9176175296}]
[]
[]
["Section 11   PURCHASED SERVICES - Line #3.020"]
["Instructions: "]
["Additional 101 students in LEAD Conversion school in FY11 estimted to be $580,000 additional. LEARn will increase by 67 or $181,000 in FY11."]
["Source",null,{"$f":"+C285","v":"FY09"},"FY10","FY11","FY12","FY13","FY14",{"$f":"+I285","v":"FY15"}]
["Bldg. Repairs, Ins., Contract Transportation, and other",null,784780,{"$f":"+D305-SUM(D299:D304)","v":795747},{"$f":"1.03*D298","v":819619.41},{"$f":"1.03*E298","v":844207.99230000004},{"$f":"1.03*F298","v":869534.23206900002},{"$f":"1.03*G298","v":895620.25903107005},{"$f":"1.03*H298","v":922488.86680200219},null,"Input %  +/-  Adjustment"]
["Ed Choice Vouchers",null,665506,655200,{"$f":"D299*1.01","v":661752},{"$f":"E299*1.01","v":668369.52},{"$f":"F299*1.01","v":675053.21519999998},{"$f":"G299*1.01","v":681803.74735199998},{"$f":"H299*1.01","v":688621.78482552001}]
["Open Enrollment Deduction",null,540770,609426,{"$f":"D300+580000+181000","v":1370426},{"$f":"E300*1.03","v":1411538.78},1453884.9434,1497501.4917019999,1542426.5364530599]
["Community School Deductions",null,348643,756226,{"$f":"D301*1.01","v":763788.26},{"$f":"E301*1.06","v":809615.55560000008},833904.02226800006,858921.14293604007,884688.77722412127]
["Other Tuition Including PASS Ded.",null,411858,169655,{"$f":"D302*1.03","v":174744.65},{"$f":"E302*1.03","v":179986.9895},{"$f":"F302*1.03","v":185386.599185},{"$f":"G302*1.03","v":190948.19716055001},{"$f":"H302*1.03","v":196676.64307536653}]
["Utilities",null,511313,419183,{"$f":"D303*1.02","v":427566.66000000003},{"$f":"E303*1.02","v":436117.99320000003},{"$f":"F303*1.02","v":444840.35306400002},{"$f":"G303*1.02","v":453737.16012528003},{"$f":"H303*1.02","v":462811.90332778567}]
["Budget Reductions",null,0,0,0,0,0,0,0,null,"Input BOE approved reductions"]
["Total Line 3.030",null,{"$f":"SUM(C298:C304)","v":3262870},3405437,4217896.9799999995,4349836.8306,4462603.3651860002,4578531.9983069403,{"$f":"SUM(I298:I304)","v":4697714.5117078554}]
[]
[]
["Section 12   MATERIALS AND SUPPLIES - Line #3.040"]
["MATERIALS AND SUPPLIES -  Line #3.040"]
[]
["Inflation Rate 1%"]
[]
[]
["Source",null,{"$f":"+C297","v":"FY09"},"FY10","FY11","FY12","FY13","FY14",{"$f":"+I297","v":"FY15"}]
["Supplies",null,456698,318878,{"$f":"ROUND(D317*1.01,0)","v":322067},{"$f":"ROUND(E317*1.01,0)","v":325288},{"$f":"ROUND(F317*1.01,0)","v":328541},{"$f":"ROUND(G317*1.01,0)","v":331826},{"$f":"ROUND(H317*1.01,0)","v":335144},null,"Input %  +/-  Adjustment"]
["Budget Reductions ",null,0,null,0,0,0,0,0,null,"Input BOE approved reductions"]
["Total Line 3.040",null,{"$f":"SUM(C315:C316)","v":456698},318878,322067,325288,328541,331826,{"$f":"SUM(I315:I316)","v":335144}]
[]
[]
["Section 13   EQUIPMENT - Line #3.050"]
["An overall inflation rate of 7% is being estimated for this category of expense.  Reductions made in FY09 are maintained throughout"]
[" the forecast.  The reductions were due to decrease of $55,000 for the purchase of only one new bus, and decrease of $60,000"]
["for emergency stadium repairs.  These reductions bring the district to a bare bones level in this area.  Our ability to react to unexpected"]
["events that may occur will be lessened."]
[]
["Source",null,{"$f":"+C314","v":"FY09"},"FY10","FY11","FY12","FY13","FY14",{"$f":"+I314","v":"FY15"}]
["Capital Outlay",null,29404,33960,{"$f":"D330*1.07","v":36337.200000000004},{"$f":"E330*1.07","v":38880.804000000004},{"$f":"F330*1.07","v":41602.460280000007},{"$f":"G330*1.07","v":44514.632499600011},{"$f":"H330*1.07","v":47630.656774572017},null,"Input %  +/-  Adjustment"]
["Additional Bus Purchases",null,0,{"$f":"ROUND(C328*1.07,0)","v":0},0,0,0,0,0,null,"change if more than one bus is purchased"]
["Budget Reductions",null,0,0,0,0,0,0,0,null,"Input BOE approved reductions"]
["Total Line 3.050",null,{"$f":"SUM(C327:C329)","v":29404},33960,36337.200000000004,38880.804000000004,41602.460280000007,44514.632499600011,{"$f":"SUM(I327:I329)","v":47630.656774572017}]
[]
["Section 14  TAX ANTICIPATION NOTE & OTHER DEBT REPAYMENT -  Lines #4.020; 4.050; 4.060"]
["TAX ANTICIPATION NOTE REPAYMENT -  Line #4.020"]
["In May 2010 borrowed $1,776,000 5 year TAN on renewed Emergency Levy.  Principal amount paid in final Dec 1, 2015."]
["Assumes 5 year even payback on principal with final maturities of December 2008 and December 2010"]
[]
["Source",null,{"$f":"C26","v":"FY09"},"FY10","FY11","FY12","FY13","FY14",{"$f":"I26","v":"FY15"}]
["TAN Principal Line 4.020",null,355200,355200,355200,355200,355200,355200,355200]
["Principal State Loans Line 4.030",null,0,0,0,0,0,0,0]
["Principal State Advances Line 4.040",null,0,0,0,0,0,0,0]
["TAN Principal from Emergency Levy 4.055",null,0,0,0,0,0,0,0]
["Total Principal Payments",null,{"$f":"SUM(C338:C341)","v":355200},355200,355200,355200,355200,355200,{"$f":"SUM(I338:I341)","v":355200}]
[]
["HB 264 NOTE REPAYMENT -  Line #4.050"]
["Energy conservation project debt service with a final maturity in school year 2020."]
[]
["Source",null,{"$f":"+C337","v":"FY09"},"FY10","FY11","FY12","FY13","FY14",{"$f":"+I337","v":"FY15"}]
["HB 264 Principal       Total Line 4.050",null,0,0,0,0,0,0,0]
[]
["INTEREST AND FISCAL CHARGES -  Line #4.060"]
["Source",null,{"$f":"C347","v":"FY09"},{"$f":"D347","v":"FY10"},{"$f":"+E347","v":"FY11"},{"$f":"+F347","v":"FY12"},{"$f":"+G347","v":"FY13"},{"$f":"+H347","v":"FY14"},{"$f":"+I347","v":"FY15"}]
["Interest on TANS,Loans  & HB 264    Line 4.060",null,30813,79379,61850,54346,42268,30192,18115]
[]
[]
[]
["Section 15   OTHER EXPENSES - Line #4.300"]
[]
["The category of Other Expenses consists primarily of County ESC deductions for specialized services provided to"]
["the District and Auditor and Treasurer fees. Auditor and treasurer fees will increase sharply anytime a new operating levy"]
[" is collected. Also new construction will cause A & T fees to increase as more tax dollars are collected.  A & T Fees will decline"]
["with Emergency levies expiring, however it is anticipated that they will be replaced so the A&T fees noted below are maintained at"]
["current levels.  Currently, we are estimating annual increase of 1% for this forecast."]
[]
["Source",null,{"$f":"+C326","v":"FY09"},"FY10","FY11","FY12","FY13","FY14",{"$f":"+I326","v":"FY15"}]
["A&T Fees; Liability Ins. ",null,1432740,1691458,684000,{"$f":" E365*1.01","v":690840},{"$f":" F365*1.01","v":697748.4},{"$f":" G365*1.01","v":704725.88400000008},{"$f":" H365*1.01","v":711773.1428400001}]
["County ESC Charges",null,null,710093,818000,710093,710093,710093,710093]
["Budget Reductions",null,0,0,0,0,0,0,0,null,"Input BOE approved reductions"]
["Increased A&T  Fees for New Levies",null,{"$f":"B368*1.03","v":0},0,0,0,0,0,0,null,"Input %  +/-  Adjustment"]
["Total Line 4.300",null,{"$f":"SUM(C365:C368)","v":1432740},2401551,1502000,1400933,1407841.4,1414818.8840000001,{"$f":"SUM(I365:I368)","v":1421866.1428400001}]
[]
["Section 16  TRANSFERS OUT/ADVANCES OUT - LINE# 5.010"]
["This account group covers fund to fund transfers and end of year short term loans from the General Fund to other funds until they "]
["have received reimbursements and can repay the General Fund. "]
[]
["Source",null,{"$f":"+C364","v":"FY09"},"FY10","FY11","FY12","FY13","FY14",{"$f":"+I364","v":"FY15"}]
["Transfer Line 5.010",null,148167,424370,60000,65000,70000,75000,75000]
["Advances Line 5.020",null,0,0,0,0,0,0,0]
["Total Transfers & Advances ",null,{"$f":"SUM(C376:C377)","v":148167},424370,60000,65000,70000,75000,{"$f":"SUM(I376:I377)","v":75000}]
[]
["Source",null,{"$f":"C26","v":"FY09"},"FY10","FY11","FY12","FY13","FY14",{"$f":"I26","v":"FY15"}]
["All Other Financing Uses - Line 5.030",null,0,0,0,0,0,0,0]
[]
[]
[]
["Section 17  ENCUMBRANCES, RESERVATION OF FUND BALANCE & ENDING BALANCE"]
["ENCUMBRANCES - LINE #8.010"]
["These are outstanding purchase orders that have not been approved for payment as goods were not received in the fiscal year",null,null,null,null,null,null,null,null,null,"Put in the % you choose here"]
["in which they were ordered.  This is estimated to run at 0.02% for the forecast.",null,null,null,null,null,null,null,null,null,"and in the 5Year forecast sheet itself"]
[null,null,null,{"$f":"+D26","v":"FY10"},"FY11","FY12","FY13","FY14","FY15"]
["Estimated Encumbrances",null,null,210661,{"$f":"D390*1","v":210661},{"$f":"E390*1","v":210661},{"$f":"F390*1","v":210661},{"$f":"G390*1","v":210661},{"$f":"H390*1","v":210661}]
[null,null,null,null,null,null,null,null,null,null,"on row 49."]
["RESERVATIONS OF FUND BALANCE- LINE #9.080"]
["Source",null,null,{"$f":"D26","v":"FY10"},"FY11","FY12","FY13","FY14","FY15"]
["Textbooks & Instructional Materials- Line 9.010",null,null,0,0,0,0,0,0]
["Capital Improvements- Line 9.020",null,null,0,0,0,0,0,0]
["Budget Reserve - Line 9.030",null,null,0,0,0,0,0,0]
["DPIA - Line 9.040",null,null,0,0,0,0,0,0]
["Fiscal Stabilization - Line 9.045",null,null,0,0,0,0,0,0]
["Debt Service - Line 9.05",null,null,0,0,0,0,0,0]
["Property Tax Advances for Future Year- Line 9.060",null,null,0,0,0,0,0,0]
["State Bus Purchases- Line 9.070",null,null,0,0,0,0,0,0]
["Total Reservations of Balance- Line#9.080",null,null,{"$f":"SUM(D394:D401)","v":0},0,0,0,0,0]
[]
["ENDING UNENCUMBERED CASH BALANCE - Line # 15.010"]
[null,null,null,{"$f":"+D26","v":"FY10"},"FY11","FY12","FY13","FY14","FY15"]
["Ending Cash Balance",null,null,{"$f":"'New State Model Fcast'!H90","v":1031577},{"$f":"'New State Model Fcast'!J90","v":-293095.43907205388},{"$f":"'New State Model Fcast'!K90","v":-2564850.6130529805},{"$f":"'New State Model Fcast'!L90","v":-5119171.9952777121},{"$f":"'New State Model Fcast'!M90","v":-7945821.7721148003},{"$f":"'New State Model Fcast'!N90","v":-11198435.414836071}]
[]
["This amount must not go below $-0- or the district General Fund will violate all Ohio Budgetary Laws.  Any multi-year"]
["contract which is knowingly signed which will cause a negative unencumbered cash balance is a violation of 5705.412, ORC,"]
["punishable by personal liability of $10,000."]
[]
[]
["Section 18   SFSF Funding"]
["SFSF Funding"]
[]
[]
["Allocation",null,null,{"$f":"+D405","v":"FY10"},"FY11","FY12","FY13","FY14","FY15"]
["  Personal Services SFSF",null,null,279666,385139,0,0,0,0]
["  Employees Retirement/Insurance Benefits SFSF",null,null,31148,42896,0,0,0,0]
["  Purchased Services SFSF",null,null,0,{"$f":"D420","v":0},0,0,0,0]
["  Supplies and Materials SFSF",null,null,0,{"$f":"D421","v":0},0,0,0,0]
["  Capital Outlay SFSF",null,null,0,{"$f":"D422","v":0},0,0,0,0]
["Total SFSF Funding",null,null,{"$f":"SUM(D418:D422)","v":310814},428035,0,0,0,0]
[]
["End","End","End","End","End","End","End","End","End","End"]

{"sheet":"TAX","index":5,"n_rows":168,"n_cols":13,"rows_kept":168,"cut":false,"hidden":false,"merged":[[128,0,128,9],[155,0,155,9],[1,0,1,6],[31,0,31,9],[66,0,66,9]]}
["SUMMARY OF ASSESSED VALUATION INCLUDING PUPP AND TPP; PROPERTY TAX RATES; AND, PROPERTY TAX ESTIMATES"]
[{"$f":"\" IRN: \"&+'Front Pg'!D60&\"        \"&+'Front Pg'!A2:F2","v":" IRN: 050195        LIBERTY LOCAL SCHOOL DISTRICT - TRUMBULL COUNTY"}]
["Updated October 15, 2010"]
[null,null,null,null,"Actual","Actual","Estimated","Estimated","Estimated","Estimated","Estimated"]
["PROPERTY TAX VALUE CATEGORIES:",null,null,null,"TAX YEAR 2008","TAX YEAR 2009","TAX YEAR 2010","TAX YEAR 2011","TAX YEAR 2012","TAX YEAR 2013","TAX YEAR2014"]
[null,null,null,null,"COLLECT 2009","COLLECT 2010","COLLECT 2011","COLLECT 2012","COLLECT 2013","COLLECT 2014","COLLECT2015"]
["Res/Ag",null,null,null,{"$f":"E81","v":172637070},173371540,173371540,173371540,173371540,173371540,{"$f":"K81","v":173371540}]
["Comm/Ind",null,null,null,{"$f":"E95","v":53432710},54568870,54568870,54568870,54568870,54568870,{"$f":"K95","v":54568870}]
["PUPP",null,null,null,{"$f":"E100+SUM(E101:E102)","v":4778850},4947040,4947040,4947040,4947040,4947040,{"$f":"K100+SUM(K101:K102)","v":4947040}]
["TPP",null,null,null,{"$f":"E103","v":1180240},397310,0,0,0,0,{"$f":"K103","v":0}]
["Total All Property Value To SF-3 Valuation Info",null,null,null,{"$f":"SUM(E7:E10)","v":232028870},233284760,232887450,232887450,232887450,232887450,{"$f":"SUM(K7:K10)","v":232887450}]
[]
[]
["PROPERTY VALUE GROWTH RATES:"]
[]
["Res/Ag",null,null,null,null,{"$f":"1-(E7/F7)","v":4.2363931242693775E-3},0,0,0,0,0]
["Comm/Ind",null,null,null,null,{"$f":"1-(E8/F8)","v":2.0820662036798665E-2},0,0,0,0,0]
["PUPP",null,null,null,null,3.3998107959507085E-2,0,0,0,0,0]
["TPP",null,null,null,null,0.5,1,0,0,0,0]
[null,null,null,null,null," "," "," "," "," "," "]
["Total % Change in AV's",null,null,null,null,{"$f":"1-(E11/F11)","v":5.3835064065050897E-3},-1.7060172199059309E-3,0,0,0,0]
[]
[]
["ESTIMATED REAL ESTATE TAX SUMMARY",null,null,null,"Actual","Estimated","Estimated","Estimated","Estimated","Estimated","Estimated"]
[null,"Line ",null,null,"FY09","FY 10","FY 11","FY 12","FY 13","FY 14","FY 15"]
["Res Ag./Comm/PUPP collection Est. "," ",null,null,{"$f":"E136","v":7928866},7318469,7182174.0622279029,6986981.5937365498,6690092.3954898324,6329076.3152141031,{"$f":"K136","v":6019035.7493563928}]
["HB 264 Taxes & BAN Ded. From Auditor"," ",null,null,null,529137,417050,409546,397468,385392,373315]
[" Total Line 1.01 to Note Calc",1.01,null,null,{"$f":"E26+E27","v":7928866},7847606,7599224.0622279029,7396527.5937365498,7087560.3954898324,6714468.3152141031,{"$f":"K26+K27","v":6392350.7493563928},null,367276]
["TPP Tax Estimate",1.02,null,null,{"$f":"E147","v":172823},48780,13980.544280000002,0,0,0,{"$f":"K147","v":0}]
["Est. Rollback, & Homstead ",1.05,null,null,{"$f":"E142","v":1119661.0266347677},1118809,1127745.3296479448,1078615.5193571697,1032347.6397629448,976086.0828170575,{"$f":"K142","v":927717.40761104738}]
[]
["Property Tax Levy Rates  (1)"]
[null,"First","Last"]
["General Fund Levies (Gross Tax Rates)","Year","Year","Collect 2008","COLLECT 2009","COLLECT 2010","COLLECT 2011","COLLECT 2012","COLLECT 2013","COLLECT 2014","COLLECT2015"]
["Inside Millage","n/a","n/a",5.7,{"$f":"D35","v":5.7},5.7,5.7,5.7,5.7,5.7,5.7]
["Current Expense 1976","n/a","n/a",26.5,26.5,26.5,{"$f":"F36","v":26.5},{"$f":"G36","v":26.5},26.5,26.5,26.5]
["Current Expense ","n/a","n/a",0,0,0,{"$f":"F37","v":0},0,0,0,0]
["Current Expense ","n/a","n/a",0,0,0,{"$f":"F38","v":0},0,0,0,0]
["Current Expense ","n/a","n/a",0,0,0,{"$f":"F39","v":0},0,0,0,0,null,"If levies expire add them back below as renewal or replacement…1 to 10 years."]
["Emergency Levy 2005 & 10 ($1,776,316))",2011,2015,7.45,7.45,7.45,7.45,7.45,7.45,7.45,7.45]
["Emergency Levy 2006 ($740,680)",2007,2011,3.15,3.15,3.1,3.1,0,0,0,0]
["Emergency Levy 2009 ($839,531)",2009,2013,3.55,3.55,3.55,3.55,3.55,3.55,0,0]
["Total",null,null,{"$f":"SUM(D35:D42)","v":46.35},{"$f":"SUM(E35:E42)","v":46.35},46.300000000000004,46.300000000000004,43.2,43.2,39.650000000000006,{"$f":"SUM(K35:K42)","v":39.650000000000006}]
[]
["General Fund Levies (Effective Tax Rates - Res/Ag)"]
["Inside Millage","n/a","n/a",{"$f":"D35","v":5.7},{"$f":"D46","v":5.7},5.7,5.7,5.7,5.7,5.7,5.7]
["Current Expense 1976","n/a","n/a",16.8109,16.8019,16.846699999999998,{"$f":"F47","v":16.846699999999998},16.846699999999998,16.846699999999998,16.846699999999998,16.846699999999998]
[{"$f":"A37","v":"Current Expense "},"n/a","n/a",0,{"$f":"D48","v":0},0,0,0,0,0,0]
["Current Expense ",{"$f":"+B38","v":"n/a"},{"$f":"+C38","v":"n/a"},0,0,0,0,0,0,0,0]
["Current Expense ","n/a",{"$f":"+C39","v":"n/a"},0,0,0,0,0,0,0,0]
["Emergency Levy 2005 & 10 ($1,776,316))",{"$f":"B40","v":2011},2015,{"$f":"D40","v":7.45},7.45,7.45,7.45,7.45,7.45,7.45,{"$f":"K40","v":7.45}]
["Emergency Levy 2006 ($740,680)",2007,2011,{"$f":"D41","v":3.15},3.15,3.1,{"$f":"G41","v":3.1},0,0,0,{"$f":"K41","v":0}]
["Emergency Levy 2009 ($839,531)",2009,2013,3.55,3.55,3.55,3.55,3.55,3.55,0,{"$f":"K42","v":0}]
["Total",null,null,{"$f":"SUM(D46:D53)","v":36.660899999999998},{"$f":"SUM(E46:E53)","v":36.651899999999998},36.646699999999996,36.646699999999996,33.546699999999994,33.546699999999994,29.996699999999997,{"$f":"SUM(K46:K53)","v":29.996699999999997}]
[]
["General Fund Levies (Effective Tax Rates - Comm/Ind)"]
["Inside Millage","n/a","n/a",{"$f":"D35","v":5.7},{"$f":"E35","v":5.7},5.7,5.7,5.7,5.7,5.7,{"$f":"K35","v":5.7}]
["Current Expense 1976","n/a","n/a",17.261600000000001,17.261600000000001,17.205400000000001,{"$f":"F58","v":17.205400000000001},{"$f":"G58","v":17.205400000000001},17.205400000000001,17.205400000000001,17.205400000000001]
[{"$f":"A37","v":"Current Expense "},"n/a","n/a",0,{"$f":"D59","v":0},0,0,0,0,0,0]
[{"$f":"A38","v":"Current Expense "},{"$f":"+B38","v":"n/a"},"n/a",0,{"$f":"D60","v":0},0,0,0,0,0,0]
[{"$f":"A39","v":"Current Expense "},"n/a","n/a",0,{"$f":"D61","v":0},0,0,0,0,0,0]
[{"$f":"A51","v":"Emergency Levy 2005 & 10 ($1,776,316))"},2011,2015,{"$f":"D40","v":7.45},{"$f":"E40","v":7.45},7.45,7.45,7.45,7.45,7.45,{"$f":"K40","v":7.45}]
[{"$f":"A41","v":"Emergency Levy 2006 ($740,680)"},2007,2011,{"$f":"D41","v":3.15},3.15,3.1,3.1,0,0,0,{"$f":"K41","v":0}]
[{"$f":"A42","v":"Emergency Levy 2009 ($839,531)"},2009,2013,3.55,3.55,3.55,3.55,3.55,3.55,0,{"$f":"K42","v":0}]
["Total",null,null,{"$f":"SUM(D57:D64)","v":37.111599999999996},{"$f":"SUM(E57:E64)","v":37.111599999999996},37.005399999999995,37.005399999999995,33.9054,33.9054,30.355399999999999,{"$f":"SUM(K57:K64)","v":30.355399999999999}]
[]
["Assessed Valuations for General Property Taxes  (2)"]
[null,null,null,"Actual","Actual","Estimated","Estimated","Estimated","Estimated","Estimated","Estimated"]
["Res/Ag -Class 1 Real Property",null,null,"COLLECT 2008","COLLECT 2009","COLLECT 2010","COLLECT 2011","COLLECT 2012","COLLECT 2013","COLLECT 2014","COLLECT2015"]
["  Res/Ag - Carryover Value (Prior Tax Year Value)",null,null,172637070,{"$f":"D81","v":172637070},172637070,173371540,173371540,173371540,173371540,173371540]
[null,null,null," ","Reappraisal "," "," ","Update"," "," "," "]
["Increases/(Decreases) To AV Due To :",null,null,"(Note: insert changes in AV below or % change in value due to reappraisal or update below…County Auditor Abstract a Good Source)"]
["  Net Demolition  & New Construction",null,null,0,0,734470,0,0,0,0,0,null,"Will increase decrease tax collections"]
["  Changes in Exempt Property",null,null,0,0,0,0,0,0,0,0,null,"Will increase decrease tax collections"]
["  Changes by  BOR & BTA",null,null,0,0,0,0,0,0,0,0,null,"Will increase decrease tax collections first year then adjust effective millage"]
["  Estimated % Increase on Reappraisal",null,null,0,0,0,0,0,0,0,0]
["  Reappraisal/Updates",null,null,{"$f":"D70*D76","v":0},0,0,0,0,0,0,{"$f":"K70*K76","v":0},null,"Will increase decrease tax collections based only on inside millage"]
["  Miscellaneous",null,null,0,0,0,0,0,0,0,0,null,"Will increase decrease tax collections"]
["Subtotal Chages in Res/Ag Value",null,null,{"$f":"SUM(D73:D75)+SUM(D77:D78)","v":0},{"$f":"SUM(E73:E75)+SUM(E77:E78)","v":0},734470,0,0,0,0,{"$f":"SUM(K73:K75)+SUM(K77:K78)","v":0}]
[]
["Total Res/Ag Class 1 Valuation",null,null,{"$f":"D70+D79","v":172637070},172637070,173371540,173371540,173371540,173371540,173371540,{"$f":"K70+K79","v":173371540}]
[]
["Comm/Ind -Class 2 Real Property"]
["  Comm/Ind/Mineral/RR-  Carryover Value",null,null,53432710,{"$f":"D95","v":53432710},53432710,54568870,54568870,54568870,54568870,54568870]
[]
["Increases/(Decreases) To AV Due To :",null,null,"(Note: insert changes in AV below or % change in value due to reappraisal or update below…County Auditor Abstract a Good Source)"]
["  Net Demolition  & New Construction",null,null,0,0,1136160,0,0,0,0,0,null,"Will increase decrease tax collections"]
["  Changes in Exempt Property",null,null,0,0,0,0,0,0,0,0,null,"Will increase decrease tax collections"]
["  Changes by  BOR & BTA",null,null,0,0,0,0,0,0,0,0,null,"Will increase decrease tax collections first year then adjust effective millage"]
["  Estimated % Increase on Reappraisal",null,null,0,0,0,0,0,0,0,0]
["  Reappraisal/Updates",null,null,{"$f":"D84*D90","v":0},0,0,0,0,0,0,{"$f":"K84*K90","v":0},null,"Will increase decrease tax collections based only on inside millage"]
["  Miscellaneous",null,null,0,0,0,0,0,0,0,0,null,"Will increase decrease tax collections"]
["Subtotal Chages in Comm/Ind Value",null,null,{"$f":"SUM(D87:D89)+SUM(D91:D92)","v":0},{"$f":"SUM(E87:E89)+SUM(E91:E92)","v":0},1136160,0,0,0,0,{"$f":"SUM(K87:K89)+SUM(K91:K92)","v":0}]
[]
["Total Comm/Ind Class 2 Valuation",null,null,{"$f":"D84+D93","v":53432710},53432710,54568870,54568870,54568870,54568870,54568870,{"$f":"K84+K93","v":54568870}]
["Total Res/Ag & Comm/Ind Valuation",null,null,{"$f":"D81+D95","v":226069780},226069780,227940410,227940410,227940410,227940410,227940410,{"$f":"K81+K95","v":227940410}]
[]
[null,null,null,"(Reasearch Note Clik Below to go to website for values)"]
["  Public Utility Tangible (PUPP) & TPP Valuation",null,null,"http://tax.ohio.gov/divisions/personal_property/documents/School_PUPP_2009_with_names_and_counties_for_web_proper_home_counties.xls"]
["  Carryover PUPP Value",null,null,4590060,{"$f":"D100+D101+D102","v":4590060},4778850,4947040,4947040,4947040,4947040,4947040]
["  Telephone/Railroad Phase out",null,null,0,0,0,0,0,0,0,0,null,"Will increase decrease tax collections on gross millage amounts"]
["  Adjustments in PUPP values +/(-)",null,null,0,188790,168190,0,0,0,0,0,null,"Will increase decrease tax collections on gross millage amounts"]
["  Tangible Personal Property (TPP)",null,null,2663059,1180240,397310,0,0,0,0,0,null,"HB66 phases out TPP in 2010.  FY11 collection is last TPP."]
["Total PUPP & TPP",null,null,{"$f":"D100+D101++D102+D103","v":7253119},{"$f":"E100+E101++E102+E103","v":5959090},5344350,4947040,4947040,4947040,4947040,{"$f":"K100+K101++K102+K103","v":4947040}]
["Total All Real, PUPP and TPP  Valuation",null,null,{"$f":"D96+D104","v":233322899},232028870,233284760,232887450,232887450,232887450,232887450,{"$f":"K96+K104","v":232887450},null,"Use to determine millages unadjustemd amount for PASS charge off."]
[]
[null,"(Note: The amounts in gray are calculated based on data input above do not over ride)  (3)"]
["Est. Tax Dollars -Cal. Year Basis",null,null,"COLLECT 2008","COLLECT 2009","COLLECT 2010","COLLECT 2011","COLLECT 2012","COLLECT 2013","COLLECT 2014","COLLECT2015"]
["Tax Revenue Est. from Res/Ag Cal Year ",null,null,{"$f":"D81*(D54/1000)","v":6329030.3595629996},6327476.6259329999,6353494.8149179993,6353494.8149179993,5816043.0409179982,5816043.0409179982,5200574.0739179999,{"$f":"K81*(K54/1000)","v":5200574.0739179999}]
["Tax Revenue Est. from Comm/Ind Cal Year ",null,null,{"$f":"D95*(D65/1000)","v":1982973.3604359997},1982973.3604359997,2019342.8618979997,2019342.8618979997,1850179.3648980001,1850179.3648980001,1656459.8763980002,{"$f":"K95*(K65/1000)","v":1656459.8763980002}]
["Tax Revenue from PUPP ",null,null,{"$f":"(SUM(D100:D102)*(D43/1000))","v":212749.28100000002},221499.69750000001,229047.95199999999,229047.95199999999,213712.128,213712.128,196150.13600000003,{"$f":"(SUM(K100:K102)*(K43/1000))","v":196150.13600000003}]
["Tax Revenue from TPP",null,null,{"$f":"D103*(D43/1000)","v":123432.78465},54704.124000000003,18395.453000000001,0,0,0,0,{"$f":"K103*(K43/1000)","v":0}]
["Total Property Tax Estimate Calendar Year Basis",null,null,{"$f":"SUM(D109:D112)","v":8648185.7856489997},{"$f":"SUM(E109:E112)","v":8586653.8078690004},8620281.081815999,8601885.6288159993,7879934.5338159977,7879934.5338159977,7053184.0863159997,{"$f":"SUM(K109:K112)","v":7053184.0863159997}]
[]
[" ","Adjust for Rollback & Homestead and $10,000K  State Property Tax Credits To Reimburse District"]
["Est. State Property Tax Credits","Input %",null,"COLLECT 2008","COLLECT 2009","COLLECT 2010","COLLECT 2011","COLLECT 2012","COLLECT 2013","COLLECT 2014","COLLECT2015"]
["  10% Rollback",0.1,null,{"$f":"$B117*D$109","v":632903.03595629998},699570,{"$f":"$B117*F$109","v":635349.48149179993},635349.48149179993,581604.30409179989,581604.30409179989,520057.40739180002,520057.40739180002]
["  2.5% Rollback at estimated % collection",1.7500000000000002E-2,null,{"$f":"$B118*D$109","v":110758.03129235251},416637,111186.159261065,111186.159261065,101780.75321606497,101780.75321606497,91010.046293564999,91010.046293564999]
["  Homestead at est. % collection",0.06,null,{"$f":"$B119*D$109","v":379741.82157377998},0,381209.68889507995,381209.68889507995,348962.58245507989,348962.58245507989,312034.44443507999,312034.44443507999]
["  TPP $10,000 Exemption",0.05,null,{"$f":"$B120*D112","v":6171.6392325000006},0,919.77265000000011,0,0,0,0,{"$f":"$B120*K112","v":0}]
["Total State Property Tax Credits",null,null,{"$f":"SUM(D117:D120)","v":1129574.5280549324},{"$f":"SUM(E117:E120)","v":1116207},1128665.1022979447,1127745.3296479448,1032347.6397629448,1032347.6397629448,923101.89812044497,{"$f":"SUM(K117:K120)","v":923101.89812044497}]
[]
["Total All Prop. Tax Rev. Est. (Net R&H)",null,null,{"$f":"D113-D121","v":7518611.2575940676},7470446.8078690004,7491615.9795180541,7474140.299168054,6847586.8940530531,6847586.8940530531,6130082.1881955545,{"$f":"K113-K121","v":6130082.1881955545}]
["Est. Collection Rate - (input rate)",0.97699999999999998,null,{"$f":"D123*$B$124","v":7345683.1986694038},7298626.5312880129,7319308.8119891388,7302235.0722871888,6690092.3954898324,6690092.3954898324,5989090.2978670569,{"$f":"K123*$B$124","v":5989090.2978670569}]
["NOTE: The Estimated collection amount noted  on Line 122  is what should be collected from the county treasurer after fees and R&H has been taken out."]
["Average Percentage of Revenue in February Settlement",null,null,0.52,0.52,0.52,0.51500000000000001,0.51500000000000001,0.51500000000000001,0.51500000000000001,0.52,null,"Fine tune adjust percentage collection from 1st to 2nd half"]
["Average Percentage of Revenue in August Settlement",null,null,0.48,0.48,0.48499999999999999,0.48499999999999999,0.48499999999999999,0.48499999999999999,0.48499999999999999,0.48]
[]
["Fiscal Year Estimated Tax Revenues (4)"]
[null,null,null,null,"Actual","Actual @4/7/10","Actual @ 10/14/10","Estimated","Estimated","Estimated","Estimated"]
[null,null,null,null,"Fiscal Year","Fiscal Year","Fiscal Year","Fiscal Year","Fiscal Year","Fiscal Year","Fiscal Year"]
[null,null,null,null,2009,2010,2011,2012,2013,2014,2015]
["General Property Tax Revenue Est. Including PUPP  (after State Credits)"]
["  August Settlement",null,null,null,3805856,3542158,3421523,{"$f":"G127*G124","v":3541584.0100592864},{"$f":"H127*H124","v":3244694.8118125685},{"$f":"I127*I124","v":3244694.8118125685},{"$f":"J127*J124","v":2904708.7944655227}]
["  February Settlement",null,null,null,4123010,3776311,{"$f":"G126*G124","v":3760651.0622279025},{"$f":"H126*H124","v":3445397.5836772639},{"$f":"I126*I124","v":3445397.5836772639},{"$f":"J126*J124","v":3084381.5034015342},{"$f":"K126*K124","v":3114326.9548908696}]
["Total General Property Tax Revenues Line 1.01 Forecast",null,null,null,{"$f":"SUM(E134:E135)","v":7928866},7318469,7182174.0622279029,6986981.5937365498,6690092.3954898324,6329076.3152141031,{"$f":"SUM(K134:K135)","v":6019035.7493563928}]
[]
["Estimated Property Tax Allocations"]
["   Rollback @ 10% of Res/Ag",null,null,null,{"$f":"(D117*D127)+(E117*E126)","v":667569.85725902393},689468,635349.48149179993,607670.71513079992,581604.30409179989,549907.65229130001,522657.69442875904]
["   2.5% Rollback  @ 2.25% Res/Ag",null,null,null,{"$f":"(D118*D127)+(E118*E126)","v":269815.09502032923},0,111186.159261065,106342.37514788998,101780.75321606497,96233.839150977496,91465.09652503283]
["  Homestead @ 5.75% of Res/Ag",null,null,null,{"$f":"(D119*D127)+(E119*E126)","v":182276.07435541437},429341,381209.68889507995,364602.42907847988,348962.58245507989,329944.59137477993,313594.61665725539]
["Total State Property Tax Credits Line 1.050",null,null,null,{"$f":"SUM(E139:E141)","v":1119661.0266347677},1118809,1127745.3296479448,1078615.5193571697,1032347.6397629448,976086.0828170575,{"$f":"SUM(K139:K141)","v":927717.40761104738}]
[]
["Estimated TPP Tax Revenue  ","Input %",null,"(Note:  Below TPP is net of estimated  5% for $10,000 Exemption)"]
["  October Settlement",0.8,null,null,138258,45744,{"$f":"((F112*$B145)*0.95)","v":13980.544280000002},{"$f":"G112*$B145","v":0},{"$f":"H112*$B145","v":0},{"$f":"I112*$B145","v":0},{"$f":"J112*$B145","v":0}]
["  June Settlement",0.2,null,null,34565,3036,{"$f":"$B146*G112","v":0},{"$f":"$B146*H112","v":0},{"$f":"$B146*I112","v":0},{"$f":"$B146*J112","v":0},{"$f":"$B146*K112","v":0}]
["Total TPP  Tax Est. Line 1.02",null,null,null,{"$f":"SUM(E145:E146)","v":172823},48780,13980.544280000002,0,0,0,{"$f":"SUM(K145:K146)","v":0}]
[]
[null,null,null,"(Reasearch Note Click Below to go to website for values)"]
[null,null,null,"http://tax.ohio.gov/divisions/personal_property/documents/TY_2009_TPP_fixed_sum_for_web.xls"]
["TPP State Reimbursements"," ",null," http://tax.ohio.gov/divisions/personal_property/documents/FY10_TPP_Direct_Payment_Allocation.xls"]
["  Fixed Sum",null,null,null,0,150857,118868,118868,118868,{"$f":"((I152/17)*9)","v":62930.117647058825},{"$f":"((I152/17)*7)","v":48945.647058823524}]
["  Fixed Rate",null,null,null,0,406784,414779,414779,414779,{"$f":"((I153/17)*9)","v":219588.88235294117},{"$f":"((I153/17)*7)","v":170791.35294117648}]
["Total State TPP Payments  Line 1.050",null,null,null,{"$f":"SUM(E152:E153)","v":0},557641,533647,533647,533647,282519,{"$f":"SUM(K152:K153)","v":219737}]
[]
["Renewal/Replacement & New Levies (5)"]
["Est. Revenue from Replacement /Renewal Levies ",null,null,"(Note: new tax levies minus 5% fees for delinquency and A&T Fees but include R&H totals)"]
["  Income tax",null,null,null,0,0,0,0,0,0,0]
["  Property tax- Renewal #1 7.45 Mill Em Levy",2016,2020,null,{"$f":"IF(SUM(E38:E42)>0,0)","v":0},0,0,0,0,0,0]
["  Property Tax Renewal #2 3.10 Mill Em Levy",2012,2016,null,{"$f":"IF(SUM(E39:E43)>0,0)","v":0},0,0,{"$f":"(740680*0.52)","v":385153.60000000003},{"$f":"(740680)","v":740680},{"$f":"(740680)","v":740680},{"$f":"(740680)","v":740680}]
["  Property Tax Renewal #3 3.55 Mill Em Levy",2014,2018,null,{"$f":"IF(SUM(E40:E44)>0,0)","v":0},0,0,0,0,{"$f":"(839531*0.52)","v":436556.12},{"$f":"(839531*0.52)","v":436556.12}]
["Cummulative Balance Renew/Repl. Line 11.30",null,null,null,{"$f":"SUM(E158:E161)","v":0},{"$f":"SUM(F158:F161)+E162","v":0},0,385153.60000000003,1125833.6000000001,2303069.7200000002,3480305.8400000003]
[]
["Est. Revenue from NEW Levies ",null,null," "]
["  Income tax - new Line 13.10",null,null,null,0,0,0,0,0,0,0]
["  Property tax- new Line 13.20",null,null,null,0,0,0,0,0,0,0]
["Cummulative Balance New Levies 13.30",null,null,null,{"$f":"SUM(E165:E166)","v":0},{"$f":"SUM(F165:F166)+E167","v":0},0,0,0,0,0]
[null,null,null,"end","end","end","end","end","end","end","end","end"]

{"sheet":"PASS","index":6,"n_rows":128,"n_cols":7,"rows_kept":128,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,1]]}
["                         Ohio Department of Education                         10/11/2010"]
[{"$f":"\"IRN: \"&'Front Pg'!D60&\"     \"&UPPER('Front Pg'!D58)&\",     \"&UPPER('Front Pg'!D59)&\" COUNTY\"","v":"IRN: 050195     LIBERTY LOCAL SCHOOL DISTRICT,     TRUMBULL COUNTY"}]
[]
["                                                                                                                                    "]
[null,"FY 2010","FY 2011","FY 2012","FY 2013","FY 2014",2015]
["  1A Special Ed. Cat. 1 ",50,47,47,47,47,47]
["  1B Special Ed. Cat. 2 ",74.86,84.99,84.99,84.99,84.99,84.99]
["  1C Special Ed. Cat. 3 ",9,9.26,9.26,9.26,9.26,9.26]
["  1D Special Ed. Cat. 4 ",2,2,2,2,2,2]
["  1E Special Ed. Cat. 5 ",13.6,12.6,12.6,12.6,12.6,12.6]
["  1F Special Ed. Cat. 6",18,17,17,17,17,17]
["  1G JVSD Spec Ed  ",14.43,18.059999999999999,18.059999999999999,18.059999999999999,18.059999999999999,18.059999999999999]
["  1H Non - Jnt OE JVES ",0,0,0,0,0,0]
["  1I All Other Students",1354.83,1329.57,1329.57,1329.57,1329.57,1329.57]
["  1J BDD (formerly MRDD)",5,5,5,5,5,5]
["  1K Ed. Choice ",134.03,126,126,126,126,126]
["  2  Total ADM   ",{"$f":"SUM(B6:B16)","v":1675.75},1651.48,1651.48,1651.48,1651.48,1651.48]
[" ",{"$f":"(B17-1)-(0.8*B12)","v":1663.2059999999999},1636.0319999999999,1636.0319999999999,1636.0319999999999,1636.0319999999999,1636.0319999999999]
["3 PK",0,0,0,0,0,0]
[" 3  KDG",101.55,97.22,97.22,97.22,97.22,97.22]
["3  Grade 1-3",311.2,365.08,365.08,365.08,365.08,365.08]
["3 Gade 4-5",218.01,225.85,225.85,225.85,225.85,225.85]
["3 Gade 6-8",414.07,386.01,386.01,386.01,386.01,386.01]
["3 Gade 9-12",618.38,562.87,562.87,562.87,562.87,562.87]
["Line 3 Formula ADM  Less Pre-K",{"$f":"SUM(B19:B24)","v":1663.21},1637.0299999999997,1637.0299999999997,1637.0299999999997,1637.0299999999997,1637.0299999999997]
["  4A Elementary Organizational Units              (Line 3 KDG + 1-3 + 4-5) / 418",{"$f":"ROUND((+B20+B21+B22)/418,2)","v":1.51},1.65,1.65,1.65,1.65,1.65]
["  4B Middle School Organizational Units           Line 3 6-8 / 557",{"$f":"ROUND(+B23/557,2)","v":0.74},0.69,0.69,0.69,0.69,0.69]
["  4C High School Organizational Units             Line 3  9-12 / 733                                                      ",{"$f":"ROUND(+B24/733,2)","v":0.84},0.77,0.77,0.77,0.77,0.77]
["  4D Total Organizational Units                   if (4A+4B+4C)<1 then 1 else (4A+4B+4C); if Small district then 1",{"$f":"SUM(B26:B28)","v":3.09},3.11,3.11,3.11,3.11,3.11]
["  4E Total Buildings Issued Report Cards",3,3,3,3,3,3]
["  5A Educational Challenge Factor    ",1.1432,1.1432,1.1432,1.1432,1.1432,1.1432]
["  5B Targeted Poverty Indicator ",0.52080000000000004,0.52080000000000004,0.52080000000000004,0.52080000000000004,0.52080000000000004,0.52080000000000004]
["  5C Base Teacher Salary",56902,57812,57812,57812,57812,57812]
["  5D LEP Percentage(data not displayed if percentage is <5% or > 95%)                                ",0,0,0,0,0,0]
["  5E School District Typology    0 - 7 Major Urban-Very High Poverty     ",4,4,4,4,4,4]
["Resources for Teachers and Instructional Services                                                                                   "]
["                              Number of Teachers                                                                                    "]
["  6A Core teachers: K-3((Line 3 K-3 + Line 1F PK) / 19) x 5A x 5C",{"$f":"ROUND((B20+B21+1)/19,2)","v":21.78},{"$f":"ROUND((C20+C21)/19,2)","v":24.33},24.38,24.38,24.38,24.38]
["Cost ",{"$f":"+B38*B33*B31","v":1416796.980192},1607986.2054719999,1611290.739392,1611290.739392,1611290.739392,1611290.739392]
["  6B Core teachers: 4-5 (Line 3 4-5 / 25) x 5A x 5C  ",{"$f":"ROUND(+B22/25,2)","v":8.7200000000000006},9.0299999999999994,9.0299999999999994,9.0299999999999994,9.0299999999999994,9.0299999999999994]
["Cost",{"$f":"+B40*B33*B31","v":567239.19500800001},596798.82595199998,596798.82595199998,596798.82595199998,596798.82595199998,596798.82595199998]
["  6C Core teachers: 6-8  (Line 3 6-8 / 25) x 5A x 5C ",{"$f":"ROUND(+B23/25,2)","v":16.559999999999999},15.44,15.44,15.44,15.44,15.44]
["Cost",{"$f":"+B42*B31*B33","v":1077234.0675839998},1020440.0744960001,1020440.0744960001,1020440.0744960001,1020440.0744960001,1020440.0744960001]
["  6D Core teachers: 9-12  (Line 3 9-12 / 25) x 5A x 5C",{"$f":"ROUND(+B24/25,2)","v":24.74},{"$f":"+C24/25","v":22.514800000000001},{"$f":"+D24/25","v":22.514800000000001},{"$f":"+E24/25","v":22.514800000000001},{"$f":"+F24/25","v":22.514800000000001},{"$f":"+G24/25","v":22.514800000000001}]
["Cost",{"$f":"+B44*B31*B33","v":1609346.0647359998},1488018.4060403199,1488018.4060403199,1488018.4060403199,1488018.4060403199,1488018.4060403199]
["  7  Specialist teachers  (# Teachers from((6A +6B +6C) x .20) + (6D x .25)) x 5A x 5C",{"$f":"ROUND(((B38+B40+B42)*0.2)+(B44*0.25),2)","v":15.6},15.39,15.4,15.4,15.4,15.4]
["Cost",{"$f":"+B46*B31*B33","v":1014785.71584},1017135.5405760001,1017796.44736,1017796.44736,1017796.44736,1017796.44736]
["  8  Lead teachers (Instructional Facilitators)   4D x 5A x 5C",{"$f":"+B29","v":3.09},3.11,3.11,3.11,3.11,3.11]
["Cost",{"$f":"+B48*B31*B33","v":201005.63217599998},205542.00982399998,205542.00982399998,205542.00982399998,205542.00982399998,205542.00982399998]
["  9  Special Education Teacher Factor (((Pre-K-12 Special Ed ADM x weight) x .90) /20) x 5A x 5C",{"$f":"(ROUND((+B6*0.2906),2)+ROUND((B7*0.7374),2)+ROUND((B8*1.7716),2)+ROUND((B9*2.3643),2)+ROUND((B10*3.2022),2)+ROUND((B11*4.7205),2))*0.9/20","v":9.8513999999999999},10.51,9.8131500000000003,9.8131500000000003,9.8131500000000003,9.8131500000000003]
["Cost",{"$f":"+B50*B31*B33","v":640837.17955295998},694613.02998400002,648557.74074096,648557.74074096,648557.74074096,648557.74074096]
[" 10  Special Education Teacher's Aide Factor ((((Pre-K-12 Special Ed ADM x weight) x .90) /20) /2)x.50x5Ax5C",{"$f":"+B50*0.5/2","v":2.46285},2.6274999999999999,2.4532875000000001,2.4532875000000001,2.4532875000000001,2.4532875000000001]
["Cost",{"$f":"+B52*B31*B33","v":160209.29488823999},173653.25749600001,162139.43518524,162139.43518524,162139.43518524,162139.43518524]
[" 11  Teachers for LEP students  ((Line 3 + Line 1F PK) x 5D) / 100) x 5A x 5C",{"$f":"(+B25+B19)*B34/100","v":0},0,0,0,0,0]
["Cost",{"$f":"+B31*B33*B54","v":0},0,0,0,0,0]
[" 12  Supplemental Teacher Factor (((Line 3 + Line 1F PK) x 5B) / 100) x 5A x 5C ",{"$f":"((+B25*B32)/100)","v":8.6619976800000007},8.5256522399999994,8.5256522399999994,8.5256522399999994,8.5256522399999994,8.5256522399999994]
["Cost",{"$f":"+B56*B31*B33","v":563466.12283995003},563466.14034407958,563466.14034407958,563466.14034407958,563466.14034407958,563466.14034407958]
[" 13  Total Instructional Services Support         Sum (6A through 12) ",{"$f":"+B38+B40+B42+B44+B46+B48+B50+B52+B56+B54","v":111.46624768},{"$f":"+C38+C40+C42+C44+C46+C48+C50+C52+C56+C54","v":111.47795223999999},{"$f":"+D38+D40+D42+D44+D46+D48+D50+D52+D56+D54","v":110.66688974},110.66688974,110.66688974,110.66688974]
["                                                                                                                                    ",{"$f":"+B39+B41+B43+B45+B47+B49+B51+B53+B57+B55","v":7250920.2528171502},{"$f":"+C39+C41+C43+C45+C47+C49+C51+C53+C57+C55","v":7367653.4901844002},7314049.8193345992,7314049.8193345992,7314049.8193345992,7314049.8193345992]
["Resources for Additional Student Services                                                                                           "]
[" 14  Family and Community Liaison Factor ((Line 3 x 5B) / 75) x 39,381* 5A ",{"$f":"ROUND(+B18*B32/75,2)","v":11.55},11.36,11.36,11.36,11.36,11.36]
["Base Salary ",38633,39381,39381,39381,39381,39381]
["Cost",{"$f":"+B61*B62*B31","v":510108.58668000001},511431.28051199997,511431.28051199997,511431.28051199997,511431.28051199997,511431.28051199997]
[]
[" 15  Counselors Factor ((Total Formula ADM 6-8 + Total 9-12) / 250) ",{"$f":"ROUND((B23+B24)/250,2)","v":4.13},3.8,3.8,3.8,3.8,3.8]
["Base Salary  Not Funded  ",0,0,0,0,0,0]
["Cost",{"$f":"+B65*B66","v":0},0,0,0,0,0]
[]
[" 16  Summer Remediation Program Factor (((Line 3 x 5B) x 0.50) / 30) x 3,000 x 5A",{"$f":"ROUND(((+B18*B32*0.5)/30),2)*3000*B31","v":49523.423999999999},48700.32,48700.32,48700.32,48700.32,48700.32]
[" 17  School Nurse Wellness Coordinator Factor (4A+4B+4C)",{"$f":"+B26+B27+B28","v":3.09},3.11,3.11,3.11,3.11,3.11]
["Base Salary  Not Funded  ",0,0,0,0,0,0]
["Cost",{"$f":"+B70*B71","v":0},0,0,0,0,0]
[" 18  District Health Professional Factor "]
["Base Salary  Not Funded  ",0,0,0,0,0,0]
["Cost",0,0,0,0,0,0]
["Resources for Administrators                                                                                                        "]
[" 19  Administration Factor ",187176,190801,190801,190801,190801,190801]
[" 20  Principal Factor (If 5E = 1 or 2 then (Max(4D, 4E) x 91,297) else 4D",{"$f":"+B29","v":3.09},3.11,3.11,3.11,3.11,3.11]
["Base Salary ",89563,91297,91297,91297,91297,91297]
["Cost",{"$f":"+B78*B79","v":276749.67},283933.67,283933.67,283933.67,283933.67,283933.67]
["Resources for Administrative Support Personnel                                                                                      "]
[" 21A Building Manager 4D",{"$f":"+B29","v":3.09},3.11,3.11,3.11,3.11,3.11]
["Base Salary ",33624,34275,34275,34275,34275,34275]
["Cost",{"$f":"+B82*B83","v":103898.15999999999},106595.25,106595.25,106595.25,106595.25,106595.25]
[" 21B Secretaries  Max(1,((4A +4B) + (3 x 4C))) x 34,275",{"$f":"+B26+B27+(B28*3)","v":4.7699999999999996},4.6500000000000004,4.6500000000000004,4.6500000000000004,4.6500000000000004,4.6500000000000004]
["Base Salary ",33624,{"$f":"+C83","v":34275},{"$f":"+D83","v":34275},{"$f":"+E83","v":34275},{"$f":"+F83","v":34275},{"$f":"+G83","v":34275}]
["Cost",{"$f":"+B85*B86","v":160386.47999999998},159378.75,159378.75,159378.75,159378.75,159378.75]
[" 21C Non-instructional aide  Max(1,(((2 x(4A+4B))+(3 x 4C)))",{"$f":"+((2*(B26+B27))+(B28*3))","v":7.02},6.99,6.99,6.99,6.99,6.99]
["Base Salary  Not Funded  ",0,0,0,0,0,0]
["Cost",0,0,0,0,0,0]
["Resources for Operations and Maintenance                                                                                            "]
[" 22  Operations & Maintenance                     Line 3 x 884 x 0.45",{"$f":"+B18*884*0.45","v":661623.34679999994},650813.52960000001,650813.52960000001,650813.52960000001,650813.52960000001,650813.52960000001]
["Resources for Gifted Education                                                                                                      "]
[" 23  Gifted Identification Factor                 Line 3 x $5",{"$f":"+B18*5","v":8316.0299999999988},8180.16,8180.16,8180.16,8180.16,8180.16]
[" 24  Gifted Coordinator Factor                    (Line 3 / 2,500) x 67,660",{"$f":"+B18/2500","v":0.66528239999999994},0.65441280000000002,0.65441280000000002,0.65441280000000002,0.65441280000000002,0.65441280000000002]
["Base Salary ",66375,67660,67660,67660,67660,67660]
["Cost",{"$f":"+B95*B96","v":44158.119299999998},44277.570048000001,44277.570048000001,44277.570048000001,44277.570048000001,44277.570048000001]
[" 25  Gifted Intervention Specialist Factor        Line 4D x line 5A x line 5C x Funding Factor",{"$f":"+B29*B31*B127","v":0.70649760000000006},1.0666055999999999,1.4221408,1.7776759999999998,2.1332111999999999,2.4887463999999997]
["Base Salary ",{"$f":"+B33","v":56902},57812,57812,57812,57812,57812]
["Cost",{"$f":"+B98*B99","v":40201.1264352},61662.602947199994,82216.803929600006,102771.00491199999,123325.20589439999,143879.40687679997]
[" 26  Gifted Intervention Specialist PD Factor     Line 4D x 1,833 x Funding Factor",{"$f":"+B29*1833*B127","v":1132.7939999999999},1710.1890000000001,2280.252,2850.3150000000001,3420.3780000000002,3990.4409999999998]
["Resources for Enrichment for All Students                                                                                           "]
[" 27  Enrichment Support Component                 Line 3 x 100 x 5A x Funding Factor",{"$f":"+B18*100*B31*B127","v":38027.541983999996},56109.353471999995,74812.471295999989,93515.58911999999,112218.70694399999,130921.82476799998]
["Resources for Technology                                                                                                            "]
[" 28  Licensed Librarian & Media Specialist Factor Line 4D x 60,000 x Funding Factor",{"$f":"+B29*60000*B127","v":37080},55980,74640,93300,111960,130619.99999999999]
[" 29  Technical Equipment Factor  Line 3 x 250 x Funding Factor",{"$f":"+B18*250*B127","v":83160.3},122702.39999999999,163603.20000000001,204504,245404.79999999999,286305.59999999998]
[" 30  Professional Development Factor  Teachers for Lines 6 - 9 x 1,833",{"$f":"(+B38+B40+B42+B44+B46+B48+B50)*1833","v":183925.78619999997},183895.3584,182728.01235,182728.01235,182728.01235,182728.01235]
[" 31  Instructional Materials Factor   Line 3 x 165 x Funding Factor",{"$f":"+B18*165*B127","v":54885.798000000003},80983.583999999988,107978.11199999999,134972.63999999998,161967.16799999998,188961.69599999997]
[" 32  Total Funding for the EBM  Sum of Lines 13 through 31  ",{"$f":"+B59+B63+B69+B67+B72+B75+B77+B80+B84+B87+B90+B92+B97+B100+B101+B103+B105+B106+B107+B108+B94","v":9691273.4162163492},9934808.5081636012,10006420.201070201,10132802.910876602,10259185.620683001,10385568.330489401]
["Local Share                                                                                                                         "]
[" 33A Adjusted Assessed Valuation  Reduced by tax exempt value if Tax exempt value > 0.25                            ",235346140,233682070,233682070,233682070,233682070,233682070]
[" 33B Adjusted Recognized Valuation     Reduced by tax exempt value if Tax exempt value > 0.25                            ",235271167,233644583,233644583,233644583,233644583,233644583]
[" 33C Property Exemption Value (TIF)  Certified to ODE by Tax Department"]
[" 33D Class I Effective Millage Rate    Provided to ODE by Tax Department ",22.559000000000001,22.547000000000001,22.547000000000001,22.547000000000001,22.547000000000001,22.547000000000001]
[" 33E Charge Off Amount:  If 33D >= 20.1 then ((33B+33C) * 0.022) else ((33A+33C) * 0.022)",{"$f":"(+B111+B113)*0.022","v":5177615.08},{"$f":"(+C112+C113)*0.022","v":5140180.8259999994},{"$f":"(+D112+D113)*0.022","v":5140180.8259999994},{"$f":"(+E112+E113)*0.022","v":5140180.8259999994},{"$f":"(+F112+F113)*0.022","v":5140180.8259999994},{"$f":"(+G112+G113)*0.022","v":5140180.8259999994}]
[" 34A State Portion of EBM Funding  (Line 32 - Line 33E)",{"$f":"+B109-B115","v":4513658.3362163492},4794627.6821636017,4866239.3750702012,4992622.0848766025,5119004.7946830019,5245387.5044894014]
[" 34B State Share Percentage (Line 34A / Line 32)",{"$f":"+B116/B109","v":0.46574460778948534},0.48260896807661413,0.48631171560732078,0.49271875993142006,0.49896794774458969,0.50506504194770652]
[" 35A Pro-rated Transportation ",436087.97,438348,438348,438348,438348,438348]
[" 35B Supplemental Transportation",0,0,0,0,0,0]
[" 36  Career Technical Ed. (CTE)                   FY10 CTE Cat 1,2 and Assoc. Services x 1.0075",9210,8569,8569,8569,8569,8569]
["Transitional Aid                                                                                                                    "]
[" 37A Transitional Aid Base  FY2010 PASS  Summary State Sources - Supp. Resources Transp, services line",5418975.3899999997,5459618,{"$f":"+C122*0.99","v":5405021.8200000003},{"$f":"+D122*0.99","v":5350971.6018000003},{"$f":"+E122*0.99","v":5297461.8857820006},{"$f":"+F122*0.99","v":5244487.2669241801}]
[" 37B Transitional Aid     0.98 x Line 37A - (Line 34A + 35A + 36) must be positive                      0.00",344113,{"$f":"IF((0.98*C122)-(C116+C118+C120)<0,0,((0.98*C122)-(C116+C118+C120)))","v":108880.95783639792},{"$f":"IF((0.99*D122)-(D116+D118+D120)<0,0,((0.99*D122)-(D116+D118+D120)))","v":37815.226729799062},{"$f":"IF((0.99*E122)-(E116+E118+E120)<0,0,((0.99*E122)-(E116+E118+E120)))","v":0},{"$f":"IF((0.99*F122)-(F116+F118+F120)<0,0,((0.99*F122)-(F116+F118+F120)))","v":0},{"$f":"IF((0.99*G122)-(G116+G118+G120)<0,0,((0.99*G122)-(G116+G118+G120)))","v":0}]
["Gain Cap                                                                                                                            "]
[" 38  FY11 Cap Level                               1.0075 x ((FY10 PASS (Line 37A-36)                                   ",{"$f":"+B122*1.0075","v":5459617.7054249998},{"$f":"(+C122-C120)*1.0075","v":5491931.8675000006},{"$f":"(+D122-D120)*1.0075","v":5436926.2161500007},{"$f":"(+E122-E120)*1.0075","v":5382470.6213135002},{"$f":"(+F122-F120)*1.0075","v":5328559.5824253662},{"$f":"(+G122-G120)*1.0075","v":5275187.6539261118}]
["39 Additional Transitional Aid Must Be Positive"]
["Funding Factor",0.2,0.3,0.4,0.5,0.6,0.7]
[{"$f":"+'State Model By %'!A1&\" Funding Level\"","v":"Liberty Local School District Funding Level"},{"$f":"+B116+B118+B119+B123","v":5293859.3062163489},{"$f":"+C116+C118+C119+C120+C123","v":5350425.6399999997},{"$f":"+D116+D118+D119+D120+D123","v":5350971.6018000003},{"$f":"+E116+E118+E119+E120+E123","v":5439539.0848766025},{"$f":"+F116+F118+F119+F120+F123","v":5565921.7946830019},{"$f":"+G116+G118+G119+G120+G123","v":5692304.5044894014}]

{"sheet":"STAFF_Plan","index":7,"n_rows":56,"n_cols":17,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[null,"DISTRICT STAFFING PLAN AND COST ESTIMATES  FY 09 THROUGH FY 13",null,"      DISTRICT STAFFING PLAN AND COST ESTIMATES  FY 09 THROUGH FY 15"]
[null,null,null," "]
[]
[null,null,"FY 07-08",null,"FY 08-09",null,"FY 09-10",null,"FY 10-11",null,"FY 11-12",null,"FY 12-13",null,"FY 13-14",null,"FY 14-15"]
[]
["PROJECTED ENROLLMENT",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[" (includes Kindergarten)"]
[]
["ENROLLMENT GROWTH",null,"N/A",null,{"$f":"E6-C6","v":0},null,{"$f":"G6-E6","v":0},null,{"$f":"I6-G6","v":0},null,{"$f":"K6-I6","v":0},null,{"$f":"M6-K6","v":0},null,{"$f":"O6-M6","v":0},null,{"$f":"Q6-O6","v":0}]
[]
[]
["GROWTH - Regular","FTE",null,"FTE",null,"FTE",null,"FTE",null,"FTE",null,"FTE",null,"FTE",null,"FTE"]
["  Administrative",0,{"$f":"((B13*$C$40)*11/12)","v":0},0,{"$f":"((B13*C40)*1/12)+((D13*E40)*11/12)","v":0},0,{"$f":"((D13*E40)*1/12)+((F13*G40)*11/12)","v":0},0,{"$f":"((F13*G40)*1/12)+((H13*I40)*11/12)","v":0},0,{"$f":"((H13*I40)*1/12)+((J13*K40)*11/12)","v":0},0,{"$f":"((J13*K40)*1/12)+((L13*M40)*11/12)","v":0},0,{"$f":"((L13*M40)*1/12)+((N13*O40)*11/12)","v":0},0,{"$f":"((N13*O40)*1/12)+((P13*Q40)*11/12)","v":0}]
["  Certified",0,{"$f":"((B14*$C$41)*10/12)","v":0},0,{"$f":"((B14*C41)*2/12)+((D14*E41)*10/12)","v":0},0,{"$f":"((D14*E41)*2/12)+((F14*G41)*10/12)","v":0},0,{"$f":"((F14*G41)*2/12)+((H14*I41)*10/12)","v":0},0,{"$f":"((H14*I41)*2/12)+((J14*K41)*10/12)","v":0},0,{"$f":"((J14*K41)*2/12)+((L14*M41)*10/12)","v":0},0,{"$f":"((L14*M41)*2/12)+((N14*O41)*10/12)","v":0},0,{"$f":"((N14*O41)*2/12)+((P14*Q41)*10/12)","v":0}]
["  Classified",0,{"$f":"((B15*$C$42)*11/12)","v":0},0,{"$f":"((B15*C42)*1/12)+((D15*E42)*11/12)","v":0},0,{"$f":"((D15*E42)*1/12)+((F15*G42)*11/12)","v":0},0,{"$f":"((F15*G42)*1/12)+((H15*I42)*11/12)","v":0},0,{"$f":"((H15*I42)*1/12)+((J15*K42)*11/12)","v":0},0,{"$f":"((J15*K42)*1/12)+((L15*M42)*11/12)","v":0},0,{"$f":"((L15*M42)*1/12)+((N15*O42)*11/12)","v":0},0,{"$f":"((N15*O42)*1/12)+((P15*Q42)*11/12)","v":0}]
["TOTAL",null,{"$f":"SUM(C13:C15)","v":0},null,{"$f":"SUM(E13:E15)","v":0},null,{"$f":"SUM(G13:G15)","v":0},null,{"$f":"SUM(I13:I15)","v":0},null,{"$f":"SUM(K13:K15)","v":0},null,{"$f":"SUM(M13:M15)","v":0},null,{"$f":"SUM(O13:O15)","v":0},null,{"$f":"SUM(Q13:Q15)","v":0}]
["UNFUNDED RECAPTURE"]
[]
["   ARRA"]
["  Administrative",0,{"$f":"((B20*$C$40)*11/12)","v":0},0,{"$f":"((B20*C40)*1/12)+((D20*E40)*11/12)","v":0},0,{"$f":"((D20*E40)*1/12)+((F20*G40)*11/12)","v":0},0,{"$f":"((F20*G40)*1/12)+((H20*I40)*11/12)","v":0},0,{"$f":"((H20*I40)*1/12)+((J20*K40)*11/12)","v":0},0,{"$f":"((J20*K40)*1/12)+((L20*M40)*11/12)","v":0},0,{"$f":"((L20*M40)*1/12)+((N20*O40)*11/12)","v":0},0,{"$f":"((N20*O40)*1/12)+((P20*Q40)*11/12)","v":0}]
["  Certified",0,{"$f":"((B21*$C$41)*10/12)","v":0},0,{"$f":"((B21*C41)*2/12)+((D21*E41)*10/12)","v":0},0,{"$f":"((D21*E41)*2/12)+((F21*G41)*10/12)","v":0},0,{"$f":"((F21*G41)*2/12)+((H21*I41)*10/12)","v":0},0,{"$f":"((H21*I41)*2/12)+((J21*K41)*10/12)","v":0},0,{"$f":"((J21*K41)*2/12)+((L21*M41)*10/12)","v":0},0,{"$f":"((L21*M41)*2/12)+((N21*O41)*10/12)","v":0},0,{"$f":"((N21*O41)*2/12)+((P21*Q41)*10/12)","v":0}]
["  Classified",0,{"$f":"((B22*$C$42)*11/12)","v":0},0,{"$f":"((B22*C42)*1/12)+((D22*E42)*11/12)","v":0},0,{"$f":"((D22*E42)*1/12)+((F22*G42)*11/12)","v":0},0,{"$f":"((F22*G42)*1/12)+((H22*I42)*11/12)","v":0},0,{"$f":"((H22*I42)*1/12)+((J22*K42)*11/12)","v":0},0,{"$f":"((J22*K42)*1/12)+((L22*M42)*11/12)","v":0},0,{"$f":"((L22*M42)*1/12)+((N22*O42)*11/12)","v":0},0,{"$f":"((N22*O42)*1/12)+((P22*Q42)*11/12)","v":0}]
["TOTAL"," ",{"$f":"SUM(C20:C22)","v":0}," ",{"$f":"SUM(E20:E22)","v":0}," ",{"$f":"SUM(G20:G22)","v":0}," ",{"$f":"SUM(I20:I22)","v":0}," ",{"$f":"SUM(K20:K22)","v":0}," ",{"$f":"SUM(M20:M22)","v":0}," ",{"$f":"SUM(O20:O22)","v":0}," ",{"$f":"SUM(Q20:Q22)","v":0}]
[]
["   SPECIAL EDUCATION"]
["  Administrative",0,{"$f":"((B26*$C$40)*11/12)","v":0},0,{"$f":"((B26*C40)*1/12)+((D26*E40)*11/12)","v":0},0,{"$f":"((D26*E40)*1/12)+((F26*G40)*11/12)","v":0},0,{"$f":"((F26*G40)*1/12)+((H26*I40)*11/12)","v":0},0,{"$f":"((H26*I40)*1/12)+((J26*K40)*11/12)","v":0},0,{"$f":"((J26*K40)*1/12)+((L26*M40)*11/12)","v":0},0,{"$f":"((L26*M40)*1/12)+((N26*O40)*11/12)","v":0},0,{"$f":"((N26*O40)*1/12)+((P26*Q40)*11/12)","v":0}]
["  Certified",0,{"$f":"((B27*$C$41)*10/12)","v":0},0,{"$f":"((B27*C41)*2/12)+((D27*E41)*10/12)","v":0},0,{"$f":"((D27*E41)*2/12)+((F27*G41)*10/12)","v":0},0,{"$f":"((F27*G41)*2/12)+((H27*I41)*10/12)","v":0},0,{"$f":"((H27*I41)*2/12)+((J27*K41)*10/12)","v":0},0,{"$f":"((J27*K41)*2/12)+((L27*M41)*10/12)","v":0},0,{"$f":"((L27*M41)*2/12)+((N27*O41)*10/12)","v":0},0,{"$f":"((N27*O41)*2/12)+((P27*Q41)*10/12)","v":0}]
["  Classified",0,{"$f":"((B28*$C$42)*11/12)","v":0},0,{"$f":"((B28*C42)*1/12)+((D28*E42)*11/12)","v":0},0,{"$f":"((D28*E42)*1/12)+((F28*G42)*11/12)","v":0},0,{"$f":"((F28*G42)*1/12)+((H28*I42)*11/12)","v":0},0,{"$f":"((H28*I42)*1/12)+((J28*K42)*11/12)","v":0},0,{"$f":"((J28*K42)*1/12)+((L28*M42)*11/12)","v":0},0,{"$f":"((L28*M42)*1/12)+((N28*O42)*11/12)","v":0},0,{"$f":"((N28*O42)*1/12)+((P28*Q42)*11/12)","v":0}]
["TOTAL",null,{"$f":"SUM(C26:C28)","v":0},null,{"$f":"SUM(E26:E28)","v":0},null,{"$f":"SUM(G26:G28)","v":0},null,{"$f":"SUM(I26:I28)","v":0},null,{"$f":"SUM(K26:K28)","v":0},null,{"$f":"SUM(M26:M28)","v":0},null,{"$f":"SUM(O26:O28)","v":0},null,{"$f":"SUM(Q26:Q28)","v":0}]
[]
["STAFF REDUCTIONS  (A)"]
["  Administrative",0,{"$f":"((B32*$C$40)*11/12)","v":0},0,{"$f":"((B32*C40)*1/12)+((D32*E40)*11/12)","v":0},0,{"$f":"((D32*E40)*1/12)+((F32*G40)*11/12)","v":0},0,{"$f":"((F32*G40)*1/12)+((H32*I40)*11/12)","v":0},0,{"$f":"((H32*I40)*1/12)+((J32*K40)*11/12)","v":0},0,{"$f":"((J32*K40)*1/12)+((L32*M40)*11/12)","v":0},0,{"$f":"((L32*M40)*1/12)+((N32*O40)*11/12)","v":0},0,{"$f":"((N32*O40)*1/12)+((P32*Q40)*11/12)","v":0}]
["  Certified",0,{"$f":"((B33*$C$41)*10/12)","v":0},0,{"$f":"((B33*C41)*2/12)+((D33*E41)*10/12)","v":0},0,{"$f":"((D33*E41)*2/12)+((F33*G41)*10/12)","v":0},0,{"$f":"((F33*G41)*2/12)+((H33*I41)*10/12)","v":0},0,{"$f":"((H33*I41)*2/12)+((J33*K41)*10/12)","v":0},0,{"$f":"((J33*K41)*2/12)+((L33*M41)*10/12)","v":0},0,{"$f":"((L33*M41)*2/12)+((N33*O41)*10/12)","v":0},0,{"$f":"((N33*O41)*2/12)+((P33*Q41)*10/12)","v":0}]
["  Classified",0,{"$f":"((B34*$C$42)*11/12)","v":0},0,{"$f":"((B34*C42)*1/12)+((D34*E42)*11/12)","v":0},0,{"$f":"((D34*E42)*1/12)+((F34*G42)*11/12)","v":0},0,{"$f":"((F34*G42)*1/12)+((H34*I42)*11/12)","v":0},0,{"$f":"((H34*I42)*1/12)+((J34*K42)*11/12)","v":0},0,{"$f":"((J34*K42)*1/12)+((L34*M42)*11/12)","v":0},0,{"$f":"((L34*M42)*1/12)+((N34*O42)*11/12)","v":0},0,{"$f":"((N34*O42)*1/12)+((P34*Q42)*11/12)","v":0}]
["TOTAL",null,{"$f":"SUM(C32:C34)","v":0},null,{"$f":"SUM(E32:E34)","v":0},null,{"$f":"SUM(G32:G34)","v":0},null,{"$f":"SUM(I32:I34)","v":0},null,{"$f":"SUM(K32:K34)","v":0},null,{"$f":"SUM(M32:M34)","v":0},null,{"$f":"SUM(O32:O34)","v":0},null,{"$f":"SUM(Q32:Q34)","v":0}]
[]
["GRAND TOTAL",null,{"$f":"C16+C23+C29+C35","v":0},null,{"$f":"E16+E23+E29+E35","v":0},null,{"$f":"G16+G23+G29+G35","v":0},null,{"$f":"I16+I23+I29+I35","v":0},null,{"$f":"K16+K23+K29+K35","v":0},null,{"$f":"M16+M23+M29+M35","v":0},null,{"$f":"O16+O23+O29+O35","v":0},null,{"$f":"Q16+Q23+Q29+Q35","v":0}]
[]
["INPUT TABLE",null,"AVG. COST",null,"AVG. COST",null,"AVG. COST",null,"AVG. COST",null,"AVG. COST",null,"AVG. COST",null,"AVG. COST",null,"AVG. COST"]
["  Administrative",null,66899,null,{"$f":"ROUND(C40*($E$44+1),0)","v":66899},null,{"$f":"ROUND(E40*($G$44+1),0)","v":67568},null,{"$f":"ROUND(G40*($I$44+1),0)","v":68244},null,{"$f":"ROUND(I40*($K$44+1),0)","v":68926},null,{"$f":"ROUND(K40*($M$44+1),0)","v":69615},null,{"$f":"ROUND(M40*($M$44+1),0)","v":70311},null,{"$f":"ROUND(O40*($M$44+1),0)","v":71014}]
["  Certified",null,46480,null,{"$f":"ROUND(C41*($E$44+1),0)","v":46480},null,{"$f":"ROUND(E41*($G$44+1),0)","v":46945},null,{"$f":"ROUND(G41*($I$44+1),0)","v":47414},null,{"$f":"ROUND(I41*($K$44+1),0)","v":47888},null,{"$f":"ROUND(K41*($M$44+1),0)","v":48367},null,{"$f":"ROUND(M41*($M$44+1),0)","v":48851},null,{"$f":"ROUND(O41*($M$44+1),0)","v":49340}]
["  Classified",null,{"$f":"ROUND(C41/2,0)","v":23240},null,{"$f":"ROUND(C42*($E$44+1),0)","v":23240},null,{"$f":"ROUND(E42*($G$44+1),0)","v":23472},null,{"$f":"ROUND(G42*($I$44+1),0)","v":23707},null,{"$f":"ROUND(I42*($K$44+1),0)","v":23944},null,{"$f":"ROUND(K42*($M$44+1),0)","v":24183},null,{"$f":"ROUND(M42*($M$44+1),0)","v":24425},null,{"$f":"ROUND(O42*($M$44+1),0)","v":24669}]
[" "]
["Base increases each year ",null,"**",null,0,null,0.01,null,0.01,null,0.01,null,0.01,null,0.01,null,0.01]
[]
[]
[]
[]
["This sheets takes costs to the Notes Sheet under Wages automatically.  Just drop in the FTE and it does the rest.  "]
["Remember put a negative sign  \"-\" in front of the FTE (ie. -1)  for a reduction."]
["The wages used in the Input Table are averages from the FY2007 Cupp report then adjusted for the wage increases planned. "]
["This also means if we use averages if you cut staff at the average and don't hire back …the savings maybe different based on the staff member."]
["Classified staff estimates above are made by dividing certificated by 2…or 50% of certificated staff.  It is typically accurate."]
[]
[]
[" "]

{"sheet":"Students","index":8,"n_rows":37,"n_cols":18,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,17],[1,0,1,17],[2,0,2,17],[5,8,5,11]]}
[{"$f":"+'Front Pg'!D58","v":"Liberty Local School District"}]
["Enrollment from the Final October Count"]
[{"$f":"\"Fiscal Year 2005 through \"&+'Front Pg'!E47","v":"Fiscal Year 2005 through 2015"}]
[]
[]
["NEED NUMBERS",null,"By Grade Level",null,null,null,null,null,"Projects of All Students"]
[null,null,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020]
[null,"PS",null,null,50,51,34,1,29,29,29,29,29,29,29,29,29]
[null,"K",null,null,83,96,119,101,93,93,93,93,93,93,93,93,93]
[null,1,null,null,99,100,109,119,93,{"$f":"I9","v":93},93,93,93,93,93,93,93]
[null,2,null,null,111,102,94,103,119,93,93,93,93,93,93,93,93]
[null,3,null,null,86,105,95,88,103,119,119,119,119,119,119,119,119]
[null,4,null,null,81,86,101,89,88,103,103,103,103,103,103,103,103]
[null,5,null,null,80,82,88,107,90,88,88,88,88,88,88,88,88]
[null,6,null,null,104,92,80,92,107,90,90,90,90,90,90,90,90]
[null,7,null,null,96,106,87,87,92,107,107,107,107,107,107,107,107]
[null,8,null,null,86,96,105,88,87,92,92,92,92,92,92,92,92]
[null,9,null,null,96,89,101,102,88,87,87,87,87,87,87,87,87]
[null,10,null,null,126,96,86,97,102,88,88,88,88,88,88,88,88]
[null,11,null,null,113,135,104,92,97,102,102,102,102,102,102,102,102]
[null,12,null,null,106,121,129,98,92,97,97,97,97,97,97,97,97]
[null,"Total",{"$f":"SUM(C8:C21)","v":0},{"$f":"SUM(D8:D21)","v":0},1317,1357,1332,1264,1280,1281,1281,1281,1281,1281,1281,1281,1281,0]
[]
[null,"JVs",0,0,0,0,0,0]
[null,"Open",0,0,0,0,0,0]
[null,"Community",0,0,0,0,0,0]
[]
[]
[null,null,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020]
[null,"Pre",{"$f":"C8","v":0},0,50,51,34,1,{"$f":"I8","v":29},29,29,29,29,29,29,29,29,0]
[null,"KG",0,0,83,96,119,101,{"$f":"I9","v":93},93,93,93,93,93,93,93,93,0]
[null,"1-3",{"$f":"SUM(C10:C12)","v":0},0,296,307,298,310,{"$f":"SUM(I10:I12)","v":315},305,305,305,305,305,305,305,305,0]
[null,"4-5",{"$f":"SUM(C13:C14)","v":0},0,161,168,189,196,{"$f":"SUM(I13:I14)","v":178},191,191,191,191,191,191,191,191,0]
[null,"6-8",{"$f":"SUM(C15:C17)","v":0},0,286,294,272,267,{"$f":"SUM(I15:I17)","v":286},289,289,289,289,289,289,289,289,0]
[null,"9-12",{"$f":"SUM(C18:C21)","v":0},0,441,441,420,389,{"$f":"SUM(I18:I21)","v":379},374,374,374,374,374,374,374,374,0]
[]
[null,null,{"$f":"SUM(C30:C35)","v":0},0,1317,1357,1332,1264,{"$f":"SUM(I30:I35)","v":1280},1281,1281,1281,1281,1281,1281,1281,1281,0]

{"sheet":"Graphs","index":9,"n_rows":427,"n_cols":13,"rows_kept":427,"cut":false,"hidden":false,"merged":[]}
[null,"General Fund Revenues Versus Expenditures - All Sources and Uses "]
[]
[null,null,"A07","A08","A09","A10",{"$f":"\"E\"&RIGHT('Front Pg'!A47,2)","v":"E11"},{"$f":"\"E\"&RIGHT('Front Pg'!B47,2)","v":"E12"},{"$f":"\"E\"&RIGHT('Front Pg'!C47,2)","v":"E13"},{"$f":"\"E\"&RIGHT('Front Pg'!D47,2)","v":"E14"},{"$f":"\"E\"&RIGHT('Front Pg'!E47,2)","v":"E15"}]
[null,"Revenue",{"$f":"+'New State Model Fcast'!E29","v":19265720},{"$f":"+'New State Model Fcast'!F29","v":15603130},{"$f":"+'New State Model Fcast'!G29","v":16947742},{"$f":"+'New State Model Fcast'!H29","v":18893737},{"$f":"+'New State Model Fcast'!J29","v":15914904.740927946},{"$f":"+'New State Model Fcast'!K29","v":15295437.860619072},{"$f":"+'New State Model Fcast'!L29","v":14921518.843241267},{"$f":"+'New State Model Fcast'!M29","v":14707287.617969453},{"$f":"+'New State Model Fcast'!N29","v":14625244.548601162}]
[null,"Expenditures",{"$f":"+'New State Model Fcast'!E54","v":19179828},{"$f":"+'New State Model Fcast'!F54","v":15986932},{"$f":"+'New State Model Fcast'!G54","v":17568992},{"$f":"+'New State Model Fcast'!H54","v":18276618},{"$f":"+'New State Model Fcast'!J54","v":17450238.18},{"$f":"+'New State Model Fcast'!K54","v":17741685.634599999},{"$f":"+'New State Model Fcast'!L54","v":18216520.225465998},{"$f":"+'New State Model Fcast'!M54","v":18711173.514806543},{"$f":"+'New State Model Fcast'!N54","v":19055094.311322432}]
[null,"Ending Bal.",{"$f":"+'New State Model Fcast'!E59","v":1630171},{"$f":"+'New State Model Fcast'!F59","v":1246369},{"$f":"+'New State Model Fcast'!G59","v":625119},{"$f":"+'New State Model Fcast'!H59","v":1242238},{"$f":"+'New State Model Fcast'!J59","v":-293095.43907205388},{"$f":"+'New State Model Fcast'!K59","v":-2739343.2130529806},{"$f":"+'New State Model Fcast'!L59","v":-6034344.5952777117},{"$f":"+'New State Model Fcast'!M59","v":-10038230.492114801},{"$f":"+'New State Model Fcast'!N59","v":-14468080.254836071}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"General Fund Ending Cash Balances"]
[]
[null,null,"A07","A08","A09","A10",{"$f":"+G3","v":"E11"},{"$f":"+H3","v":"E12"},{"$f":"+I3","v":"E13"},{"$f":"+J3","v":"E14"},{"$f":"+K3","v":"E15"}]
[null,"30 Day Cash Ratio",{"$f":"+'New State Model Fcast'!E47/12","v":1299064.25},{"$f":"+'New State Model Fcast'!F47/12","v":1330235.6666666667},{"$f":"+'New State Model Fcast'!G47/12","v":1451735.4166666667},{"$f":"+'New State Model Fcast'!H47/12","v":1487687.3333333333},{"$f":"+'New State Model Fcast'!J47/12","v":1449186.5149999999},{"$f":"+'New State Model Fcast'!K47/12","v":1473057.1362166665},{"$f":"+'New State Model Fcast'!L47/12","v":1512210.0187888332},{"$f":"+'New State Model Fcast'!M47/12","v":1553014.4595672118},{"$f":"+'New State Model Fcast'!N47/12","v":1581674.5259435361}]
[null,"Ending Cash Bal.",{"$f":"+C6","v":1630171},1246369,625119,{"$f":"+F6","v":1242238},-293095.43907205388,-2739343.2130529806,-6034344.5952777117,-10038230.492114801,-14468080.254836071]
[null,"Unencumbered Bal.",{"$f":"+'New State Model Fcast'!E73","v":1406359},{"$f":"+'New State Model Fcast'!F73","v":824346},{"$f":"+'New State Model Fcast'!G73","v":203639},{"$f":"+'New State Model Fcast'!H73","v":1031577},{"$f":"+'New State Model Fcast'!J73","v":-293095.43907205388},{"$f":"+'New State Model Fcast'!K73","v":-2950004.2130529806},{"$f":"+'New State Model Fcast'!L73","v":-6245005.5952777117},{"$f":"+'New State Model Fcast'!M73","v":-10248891.492114801},{"$f":"+'New State Model Fcast'!N73","v":-14678741.254836071}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"General Fund Local Vs. State Revenues - Revenue Receipts Only Excludes Other Financing Sources"]
[]
[null,null,"A07","A08","A09","A10",{"$f":"+G3","v":"E11"},{"$f":"+H3","v":"E12"},{"$f":"+I3","v":"E13"},{"$f":"+J3","v":"E14"},{"$f":"+K3","v":"E15"}]
[null,"Local Revenue",{"$f":"+'New State Model Fcast'!E12+'New State Model Fcast'!E13+'New State Model Fcast'!E14+'New State Model Fcast'!E19","v":9469267},{"$f":"+'New State Model Fcast'!F12+'New State Model Fcast'!F13+'New State Model Fcast'!F14+'New State Model Fcast'!F19","v":8775922},{"$f":"+'New State Model Fcast'!G12+'New State Model Fcast'!G13+'New State Model Fcast'!G14+'New State Model Fcast'!G19","v":9059772},{"$f":"+'New State Model Fcast'!H12+'New State Model Fcast'!H13+'New State Model Fcast'!H14+'New State Model Fcast'!H19","v":9713425},{"$f":"+'New State Model Fcast'!J12+'New State Model Fcast'!J13+'New State Model Fcast'!J14+'New State Model Fcast'!J19","v":8903086.77128},{"$f":"+'New State Model Fcast'!K12+'New State Model Fcast'!K13+'New State Model Fcast'!K14+'New State Model Fcast'!K19","v":8647993.7914979029},{"$f":"+'New State Model Fcast'!L12+'New State Model Fcast'!L13+'New State Model Fcast'!L14+'New State Model Fcast'!L19","v":8452639.5202992503},{"$f":"+'New State Model Fcast'!M12+'New State Model Fcast'!M13+'New State Model Fcast'!M14+'New State Model Fcast'!M19","v":8151087.9413181599},{"$f":"+'New State Model Fcast'!N12+'New State Model Fcast'!N13+'New State Model Fcast'!N14+'New State Model Fcast'!N19","v":7785485.6365007134}]
[null,"State Revenue",{"$f":"+'New State Model Fcast'!E15+'New State Model Fcast'!E16+'New State Model Fcast'!E17+'New State Model Fcast'!E18","v":6399432},{"$f":"+'New State Model Fcast'!F15+'New State Model Fcast'!F16+'New State Model Fcast'!F17+'New State Model Fcast'!F18","v":6772342},{"$f":"+'New State Model Fcast'!G15+'New State Model Fcast'!G16+'New State Model Fcast'!G17+'New State Model Fcast'!G18","v":7013002},{"$f":"+'New State Model Fcast'!H15+'New State Model Fcast'!H16+'New State Model Fcast'!H17+'New State Model Fcast'!H18","v":7101516},{"$f":"+'New State Model Fcast'!J15+'New State Model Fcast'!J16+'New State Model Fcast'!J17+'New State Model Fcast'!J18","v":7011817.969647944},{"$f":"+'New State Model Fcast'!K15+'New State Model Fcast'!K16+'New State Model Fcast'!K17+'New State Model Fcast'!K18","v":6647444.0691211699},{"$f":"+'New State Model Fcast'!L15+'New State Model Fcast'!L16+'New State Model Fcast'!L17+'New State Model Fcast'!L18","v":6468879.3229420148},{"$f":"+'New State Model Fcast'!M15+'New State Model Fcast'!M16+'New State Model Fcast'!M17+'New State Model Fcast'!M18","v":6556199.6766512934},{"$f":"+'New State Model Fcast'!N15+'New State Model Fcast'!N16+'New State Model Fcast'!N17+'New State Model Fcast'!N18","v":6839758.9121004492}]
[null,"Total",{"$f":"+C73+C74","v":15868699},15548264,16072774,{"$f":"+F73+F74","v":16814941},15914904.740927944,15295437.860619072,14921518.843241265,14707287.617969453,14625244.548601162]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"General Fund Revenue By Source - Revenue Receipts Only Excludes Other Financing Sources"]
[null,null,null,null,"A09","A10",{"$f":"+G3","v":"E11"},{"$f":"+H3","v":"E12"},{"$f":"+I3","v":"E13"},{"$f":"+J3","v":"E14"},{"$f":"+K3","v":"E15"}]
[null,"Real Estate Taxes",null,null,{"$f":"+'New State Model Fcast'!G12","v":7928867},{"$f":"+'New State Model Fcast'!H12","v":8770342},{"$f":"+'New State Model Fcast'!J12","v":7847606}]
[null,"Tangible Property Tax",null,null,{"$f":"+'New State Model Fcast'!G13","v":172823},{"$f":"+'New State Model Fcast'!H13","v":48780},{"$f":"+'New State Model Fcast'!J13","v":13980.544280000002}]
[null,"Other Local",{"$f":"(+E107+E106+E105)/E111","v":0.56367195855550511},null,{"$f":"+'New State Model Fcast'!G19","v":958082},{"$f":"+'New State Model Fcast'!H19","v":894303},{"$f":"+'New State Model Fcast'!J19","v":1041500.227}]
[null,"State Foundation",null,null,{"$f":"+'New State Model Fcast'!G15","v":5297121},{"$f":"'New State Model Fcast'!H15+'New State Model Fcast'!H16+'New State Model Fcast'!H17","v":5425066},{"$f":"'New State Model Fcast'!J15+'New State Model Fcast'!J16+'New State Model Fcast'!J17","v":5350425.6399999997}]
[null,"Other State",{"$f":"(E109+E108)/E111","v":0.43632804144449489},null,{"$f":"+'New State Model Fcast'!G16+'New State Model Fcast'!G18","v":1715881},{"$f":"'New State Model Fcast'!H18","v":1676450},{"$f":"+'New State Model Fcast'!J18","v":1661392.3296479448}]
[]
[null,"Total",null,null,{"$f":"SUM(E105:E109)","v":16072774},{"$f":"SUM(F105:F109)","v":16814941},{"$f":"SUM(G105:G109)","v":15914904.740927944}]
[null,{"$f":"\"General Fund Revenues Actual \"&+'New State Model Fcast'!H9&\" - \"&DOLLAR(+F111,0)","v":"General Fund Revenues Actual 2010 - $16,814,941"}]
[null,{"$f":"\"General Fund Revenues Estimated \"&+'New State Model Fcast'!H9+1&\" - \"&DOLLAR(+G111,0)","v":"General Fund Revenues Estimated 2011 - $15,914,905"}]
[]
[null,null,null,null,null,null,null,null,{"$f":"+E111","v":16072774}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"General Fund Expenditures By Source - Operating Expenses Only Excludes Other Financing Uses"]
[null,null,null,null,"A09","A10",{"$f":"+G3","v":"E11"},{"$f":"+H3","v":"E12"},{"$f":"+I3","v":"E13"},{"$f":"+J3","v":"E14"},{"$f":"+K3","v":"E15"}]
[null,"Wages",null,null,{"$f":"+'New State Model Fcast'!G32","v":7933566},{"$f":"+'New State Model Fcast'!H32","v":7516913},{"$f":"+'New State Model Fcast'!J32","v":7253818}]
[null,"Benefits",null,null,{"$f":"+'New State Model Fcast'!G33","v":3919536},{"$f":"+'New State Model Fcast'!H33","v":3740930},{"$f":"+'New State Model Fcast'!J33","v":3473269}]
[null,"Services",null,null,{"$f":"+'New State Model Fcast'!G34","v":3262870},{"$f":"+'New State Model Fcast'!H34","v":3405437},{"$f":"+'New State Model Fcast'!J34","v":4217896.9799999995}]
[null,"Materials",null,null,{"$f":"+'New State Model Fcast'!G35","v":456696},{"$f":"+'New State Model Fcast'!H35","v":318878},{"$f":"+'New State Model Fcast'!J35","v":322067}]
[null,"Capital",null,null,{"$f":"+'New State Model Fcast'!G36","v":29404},{"$f":"+'New State Model Fcast'!H36","v":33960},{"$f":"+'New State Model Fcast'!J36","v":36337.200000000004}]
[null,"Other",null,null,{"$f":"+'New State Model Fcast'!G46","v":1432740},{"$f":"+'New State Model Fcast'!H46","v":2401551},{"$f":"+'New State Model Fcast'!J46","v":1502000}]
[null,"Total",null,null,{"$f":"SUM(E161:E166)","v":17034812},{"$f":"SUM(F161:F166)","v":17417669},{"$f":"SUM(G161:G166)","v":16805388.18}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"General Fund Expenditures Actual FY07 Through Est. FY14"]
[]
[null,null,"A07","A08","A09","A10",{"$f":"+G3","v":"E11"},{"$f":"+H3","v":"E12"},{"$f":"+I3","v":"E13"},{"$f":"+J3","v":"E14"},{"$f":"+K3","v":"E15"}]
[null,"Wages",{"$f":"+'New State Model Fcast'!E32","v":7670134},{"$f":"+'New State Model Fcast'!F32","v":8155009},{"$f":"+'New State Model Fcast'!G32","v":7933566},{"$f":"+'New State Model Fcast'!H32","v":7516913},{"$f":"+'New State Model Fcast'!J32","v":7253818},{"$f":"+'New State Model Fcast'!K32","v":7313914},{"$f":"+'New State Model Fcast'!L32","v":7438251},{"$f":"+'New State Model Fcast'!M32","v":7564701},{"$f":"+'New State Model Fcast'!N32","v":7693301}]
[null,"Benefits",{"$f":"+'New State Model Fcast'!E33","v":3418890},{"$f":"+'New State Model Fcast'!F33","v":3115650},{"$f":"+'New State Model Fcast'!G33","v":3919536},{"$f":"+'New State Model Fcast'!H33","v":3740930},{"$f":"+'New State Model Fcast'!J33","v":3473269},{"$f":"+'New State Model Fcast'!K33","v":3670487},{"$f":"+'New State Model Fcast'!L33","v":3902413},{"$f":"+'New State Model Fcast'!M33","v":4148589},{"$f":"+'New State Model Fcast'!N33","v":4411123}]
[null,"Services",{"$f":"+'New State Model Fcast'!E34","v":2158261},{"$f":"+'New State Model Fcast'!F34","v":2776176},{"$f":"+'New State Model Fcast'!G34","v":3262870},{"$f":"+'New State Model Fcast'!H34","v":3405437},{"$f":"+'New State Model Fcast'!J34","v":4217896.9799999995},{"$f":"+'New State Model Fcast'!K34","v":4349836.8306},{"$f":"+'New State Model Fcast'!L34","v":4462603.3651860002},{"$f":"+'New State Model Fcast'!M34","v":4578531.9983069403},{"$f":"+'New State Model Fcast'!N34","v":4697714.5117078554}]
[null,"Material",{"$f":"+'New State Model Fcast'!E35","v":603721},{"$f":"+'New State Model Fcast'!F35","v":502654},{"$f":"+'New State Model Fcast'!G35","v":456696},{"$f":"+'New State Model Fcast'!H35","v":318878},{"$f":"+'New State Model Fcast'!J35","v":322067},{"$f":"+'New State Model Fcast'!K35","v":325288},{"$f":"+'New State Model Fcast'!L35","v":328541},{"$f":"+'New State Model Fcast'!M35","v":331826},{"$f":"+'New State Model Fcast'!N35","v":335144}]
[null,"Capital",{"$f":"+'New State Model Fcast'!E36","v":232560},{"$f":"+'New State Model Fcast'!F36","v":88983},{"$f":"+'New State Model Fcast'!G36","v":29404},{"$f":"+'New State Model Fcast'!H36","v":33960},{"$f":"+'New State Model Fcast'!J36","v":36337.200000000004},{"$f":"+'New State Model Fcast'!K36","v":38880.804000000004},{"$f":"+'New State Model Fcast'!L36","v":41602.460280000007},{"$f":"+'New State Model Fcast'!M36","v":44514.632499600011},{"$f":"+'New State Model Fcast'!N36","v":47630.656774572017}]
[null,"Other Expenses",{"$f":"+'New State Model Fcast'!E46","v":1094438},{"$f":"+'New State Model Fcast'!F46","v":948169},{"$f":"+'New State Model Fcast'!G46","v":1432740},{"$f":"+'New State Model Fcast'!H46","v":2401551},{"$f":"+'New State Model Fcast'!J46","v":1502000},{"$f":"+'New State Model Fcast'!K46","v":1400933},{"$f":"+'New State Model Fcast'!L46","v":1407841.4},{"$f":"+'New State Model Fcast'!M46","v":1414818.8840000001},{"$f":"+'New State Model Fcast'!N46","v":1421866.1428400001}]
[null,null," ",{"$f":"+D226/C226-1","v":2.6922973534596606E-2},9.2911038369331678E-2,2.2474976536283497E-2,{"$f":"+G226/E226-1","v":-1.3467939652048955E-2},1.7491500431381146E-2,2.8183111229094671E-2,2.8537744803740495E-2,2.8966340317662764E-2]
[null,"total",{"$f":"SUM(C219:C224)","v":15178004},15586641,17034812,{"$f":"SUM(F219:F224)","v":17417669},16805388.18,17099339.634599999,17581252.225465998,18082981.514806543,{"$f":"SUM(K219:K224)","v":18606779.311322432}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"General Fund Revenues With Replacement Levies Vs. Expenditures FY07 through FY14"]
[null,null,null,null," "," "]
[null,null,"A07","A08","A09","A10",{"$f":"+G3","v":"E11"},{"$f":"+H3","v":"E12"},{"$f":"+I3","v":"E13"},{"$f":"+J3","v":"E14"},{"$f":"+K3","v":"E15"}]
[null,"Revenue W/Renewals",{"$f":"+'New State Model Fcast'!E29+'New State Model Fcast'!E77","v":19265720},{"$f":"+'New State Model Fcast'!F29+'New State Model Fcast'!F77","v":15603130},{"$f":"+'New State Model Fcast'!G29+'New State Model Fcast'!G77","v":16947742},{"$f":"+'New State Model Fcast'!H29+'New State Model Fcast'!H77","v":18893737},{"$f":"+'New State Model Fcast'!J29+'New State Model Fcast'!J77","v":15914904.740927946},{"$f":"+'New State Model Fcast'!K29+'New State Model Fcast'!K77","v":15680591.460619071},{"$f":"+'New State Model Fcast'!L29+'New State Model Fcast'!L77","v":15662198.843241267},{"$f":"+'New State Model Fcast'!M29+'New State Model Fcast'!M77","v":15884523.737969454},{"$f":"+'New State Model Fcast'!N29+'New State Model Fcast'!N77","v":15802480.668601163}]
[null,"Expenditures",{"$f":"+'New State Model Fcast'!E47","v":15588771},{"$f":"+'New State Model Fcast'!F47","v":15962828},{"$f":"+'New State Model Fcast'!G47","v":17420825},{"$f":"+'New State Model Fcast'!H47","v":17852248},{"$f":"+'New State Model Fcast'!J47","v":17390238.18},{"$f":"+'New State Model Fcast'!K47","v":17676685.634599999},{"$f":"+'New State Model Fcast'!L47","v":18146520.225465998},{"$f":"+'New State Model Fcast'!M47","v":18636173.514806543},{"$f":"+'New State Model Fcast'!N47","v":18980094.311322432}]
[null,{"$f":"B38","v":"30 Day Cash Ratio"},{"$f":"C38","v":1299064.25},1330235.6666666667,1451735.4166666667,{"$f":"F38","v":1487687.3333333333},1449186.5149999999,1473057.1362166665,1512210.0187888332,1553014.4595672118,1581674.5259435361]
[null,"Ending Cash Balances",{"$f":"+'New State Model Fcast'!E59","v":1630171},{"$f":"+'New State Model Fcast'!F59","v":1246369},{"$f":"+'New State Model Fcast'!G59","v":625119},{"$f":"+'New State Model Fcast'!H59","v":1242238},{"$f":"+'New State Model Fcast'!J59","v":-293095.43907205388},{"$f":"+'New State Model Fcast'!K59","v":-2739343.2130529806},{"$f":"+'New State Model Fcast'!L59","v":-6034344.5952777117},{"$f":"+'New State Model Fcast'!M59","v":-10038230.492114801},{"$f":"+'New State Model Fcast'!N59","v":-14468080.254836071}]
[null," ",null,null,null,null,null," "," "," "," ",null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Fringe Benefit Growth FY06 Through FY14"]
[]
[null,null,"A07","A08","A09","A10","E10","E11","E12","E13","E14"]
[null,"Fringe Benefit Costs",{"$f":"+'New State Model Fcast'!E33","v":3418890},{"$f":"+'New State Model Fcast'!F33","v":3115650},{"$f":"+'New State Model Fcast'!G33","v":3919536},{"$f":"+'New State Model Fcast'!H33","v":3740930},{"$f":"+'New State Model Fcast'!J33","v":3473269},{"$f":"+'New State Model Fcast'!K33","v":3670487},{"$f":"+'New State Model Fcast'!L33","v":3902413},{"$f":"+'New State Model Fcast'!M33","v":4148589},{"$f":"+'New State Model Fcast'!N33","v":4411123}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Cost Per Pupil Comparison Trumbull County FY08"]
[null,"Lord."]
[null,"Bloom"]
[null,"War"]
[null,"LLSD"]
[null,"How"]
[null,"St. Avg."]
[null,"Math"]
[null,"Weath"]
[null,"Champ"]
[null,"LaBrae"]
[null,"Niles"]
[null,"Hub"]
[null,"Newt"]
[null,"Girard"]
[null,"Maple"]
[null,"Lakev"]
[null,"Brook"]
[null,"J Badger"]
[null,"McDon"]
[null,"Brist"]
[null,"Southgtn"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"A06","A07","A08","A09","A10",{"$f":"+G3","v":"E11"},{"$f":"+H3","v":"E12"},{"$f":"+I3","v":"E13"},{"$f":"+J3","v":"E14"},{"$f":"+K3","v":"E15"}]
[null,1813,1766,1733,1675,1675,1770,{"$f":"+G392*1.01","v":1787.7},{"$f":"+H392*1","v":1787.7},{"$f":"+I392*1","v":1787.7},{"$f":"+J392*1","v":1787.7}]
[]
[]
[null,"Enrollment History - Formual ADM per SF3"]
[]
[null,"Year"]
[null,"FY05"]
[null,"FY06"]
[null,"FY07"]
[null,"FY08"]
[null,"FY09"]
[null,"FY10"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["End","End","End","End","End","End","End","End","End","End","End","End"]