{"text_format":"2","workbook":"xls","n_sheets":5,"sheets":["All charter school calculator"," Detail 2013-14 Final FEFP","111-112-113 ADDITIONAL FUND","Transportation Per Student","75% or more ESE calculation"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":3,"defined_names":271,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"All charter school calculator","index":0,"n_rows":100,"n_cols":8,"rows_kept":100,"cut":false,"hidden":false,"merged":[[95,0,95,7],[72,0,72,6],[94,0,94,7],[90,0,90,7],[99,0,99,7],[80,3,80,6],[82,0,82,5],[100,0,100,7],[81,0,81,6],[89,0,89,7],[98,0,98,7],[87,0,87,7],[88,0,88,7],[97,0,97,7],[84,0,84,7],[83,0,83,5],[93,0,93,7],[71,0,71,6],[63,0,63,1],[68,0,68,2],[69,0,69,2],[70,0,70,2],[80,0,80,2],[64,0,64,1],[79,3,79,6],[77,0,77,2],[78,0,78,2],[25,0,25,1],[85,0,85,7],[86,0,86,7],[75,0,75,1],[76,0,76,1],[74,0,74,2],[74,3,74,6],[67,0,67,2],[58,0,58,7],[79,0,79,2],[59,2,59,7],[60,2,60,7],[61,2,61,7],[63,2,63,7],[64,2,64,7],[65,0,65,2],[44,2,44,3],[45,2,45,3],[46,2,46,3],[47,2,47,3],[62,0,62,7],[60,0,60,1],[61,0,61,1],[55,0,55,5],[59,0,59,1],[56,0,56,7],[35,2,35,3],[37,2,37,3],[55,6,55,7],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[38,2,38,5],[49,0,49,7],[35,0,35,1],[28,2,28,3],[29,2,29,3],[23,2,23,3],[24,2,24,3],[30,2,30,3],[25,2,25,3],[19,2,19,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[21,2,21,3],[17,2,17,3],[16,4,16,5],[17,4,17,5],[36,0,36,7],[44,4,44,7],[48,2,48,6],[18,4,18,5],[35,4,35,6],[37,0,37,1],[16,2,16,3],[18,2,18,3],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[12,2,12,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[13,0,13,1],[24,0,24,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[18,0,18,1],[14,4,14,5],[8,4,8,5],[9,4,9,5],[10,4,10,5],[38,0,38,1],[37,4,37,7],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[11,4,11,5],[12,4,12,5],[13,4,13,5],[0,1,0,7],[4,0,4,7],[5,4,5,5],[5,6,5,7],[5,0,5,1],[3,0,3,1],[2,0,2,7],[5,2,5,3],[1,0,1,7],[6,0,6,1],[6,4,6,5],[7,4,7,5],[7,0,7,1],[6,2,6,3],[7,2,7,3],[3,2,3,3],[15,4,15,5],[19,4,19,5],[91,0,92,7],[96,0,96,7],[20,4,20,5],[21,4,21,5],[22,4,22,5],[23,4,23,5],[24,4,24,5],[26,0,34,1],[22,2,22,3],[43,0,43,7],[20,2,20,3],[50,0,50,7],[40,0,40,7],[41,0,41,7],[42,0,42,6],[26,2,26,3],[39,0,39,7],[27,2,27,3],[57,0,57,2],[54,3,54,4],[54,5,54,7],[51,3,51,4],[52,0,52,5],[53,0,53,7],[54,0,54,1],[51,5,51,7],[51,0,51,1],[52,6,52,7]],"flags":["formulas_cached_only"]}
[1,"(Insert district number in cell A1, enter, then strike F9. Your district data then pulls from Calculation Detail Sheets)"]
[" Revenue Estimate Worksheet for___________Charter School "]
["Based on the Final Calculation of the FEFP 2013-14"]
["School District: ",null,"Alachua"]
["1.  2013-14 FEFP State and Local Funding"]
["Base Student Allocation",null,3752.3,null,"District Cost Differential: ",null,0.9805]
["Program",null,"Number of FTE",null,"Program                              Cost Factor",null,"Weighted FTE           (b) x (c)","2013-14 Base Funding WFTE x BSA x DCD"]
["(a)",null,"(b)",null,"(c)",null,"(d)","(e)"]
["101 Basic K-3",null,null,null,1.125,null,0,0]
["111 Basic K-3 with ESE Services",null,null,null,1.125,null,0,0]
["102 Basic 4-8",null,null,null,1,null,0,0]
["112 Basic 4-8 with ESE Services",null,null,null,1,null,0,0]
["103 Basic 9-12",null,null,null,1.011,null,0,0]
["113 Basic 9-12 with ESE Services",null,null,null,1.011,null,0,0]
["254 ESE Level 4 (Grade Level PK-3)",null,null,null,3.558,null,0,0]
["254 ESE Level 4 (Grade Level 4-8)",null,null,null,3.558,null,0,0]
["254 ESE Level 4 (Grade Level 9-12)",null,null,null,3.558,null,0,0]
["255 ESE Level 5 (Grade Level PK-3)",null,null,null,5.089,null,0,0]
["255 ESE Level 5 (Grade Level 4-8)",null,null,null,5.089,null,0,0]
["255 ESE Level 5 (Grade Level 9-12)",null,null,null,5.089,null,0,0]
["130 ESOL (Grade Level PK-3)",null,null,null,1.145,null,0,0]
["130 ESOL (Grade Level 4-8)",null,null,null,1.145,null,0,0]
["130 ESOL (Grade Level 9-12)",null,null,null,1.145,null,0,0]
["300 Career Education (Grades 9-12)",null,null,null,1.011,null,0,0]
["Totals",null,0,null,null,null,0,0]
["2.  ESE Guaranteed Allocation:",null,"FTE",null,"Grade Level","Matrix Level","Guarantee Per Student"]
["Additional Funding from the ESE Guaranteed Allocation. Enter the FTE from 111,112, & 113 by grade and matrix level.  Students who do not have a matrix level should be considered 251.  This total should equal all FTE from programs 111, 112 & 113 above.",null,null,null,"PK-3",251,975,0]
[{"$nulls":4},"PK-3",252,3147,0]
[{"$nulls":4},"PK-3",253,6422,0]
[{"$nulls":4},"4-8",251,1093,0]
[{"$nulls":4},"4-8",252,3265,0]
[{"$nulls":4},"4-8",253,6540,0]
[{"$nulls":4},"9-12",251,778,0]
[{"$nulls":4},"9-12",252,2950,0]
[{"$nulls":4},"9-12",253,6225,0]
["Total FTE with ESE Services",null,0,null,"Total from ESE Guarantee",null,null,0]
["3.  Supplemental Academic Instruction:"]
["District SAI Allocation ",null,7558718,null,"Per Student"]
["divided by district FTE ",null,27276.030000000002,null,null,null,277,0]
["(with eligible services)"]
["4.  Reading Allocation: "]
["Charter schools should contact their school district sponsor regarding eligibility and distribution of reading allocation funds."]
["Total Base Funding, ESE Guarantee, and SAI",{"$nulls":6},0]
["5.  Class size Reduction Funds:"]
[null,"Weighted FTE (From Section 1)","X             DCD            X",null,"Allocation factors"]
["PK - 3",0,0.9805,null,1316.85,"=",0]
["4-8",0,0.9805,null,898.23,"=",0]
["9-12",0,0.9805,null,900.39,"=",0]
["Total *",0,"Total Class Size Reduction Funds",{"$nulls":4},0]
["(*Total FTE should equal total in Section 1, column (d).)"]
["6A.  Divide school's Weighted FTE (WFTE) total computed "]
["in (d) above:",null,0,"by district's WFTE:",null,29602.719999999998]
["to obtain school's WFTE share. ",{"$nulls":5},0]
["6B.  Divide school's Unweighted FTE (UFTE) total computed "]
["in (b) above:",null,0,"by district's UFTE:",null,27276.030000000002]
["to obtain school's UFTE share.  ",{"$nulls":5},0]
["Letters Refer to Notes At Bottom:"]
["7.  Other FEFP (WFTE share)",null,null,"(a)",812069,"x",0,0]
["Applicable to all Charter Schools:"]
["Declining Enrollment",null,0]
["Sparsity Supplement",null,0]
["Minimum Guarantee",null,0]
["Program Related Requirements:"]
["Safe Schools",null,812069]
["Lab School Discretionary",null,0]
["8.  Discretionary Local Effort (WFTE share)",null,null,"(d)",8917231,"x",0,0]
["9.  Discretionary Millage Compression Allocation"]
[".748 mills (UFTE share)",null,null,"(b)",1491181,"x",0,0]
["10.  Proration to Funds Available (WFTE share)",null,null,"(a)",-362330,"x",0,0]
["11.  Discretionary Lottery (WFTE share)",null,null,"(a)",266713,"x",0,0]
["12.  Instructional Materials Allocation (UFTE share)",null,null,"(b)",2085356,"x",0,0]
["Dual Enrollment Instructional Materials Allocation (See footnote i below) "]
["ESE Applications Allocation: "]
["Charter schools should contact their school district sponsor regarding eligibility and distribution of ESE Application funds."]
["13.  Student Transportation",null,null,"(e)"]
["Enter",null,"All Riders",null,null," x",363,0]
["Enter",null,"ESE Student Riders",null,null," x",1372,0]
["14.  Teacher Salary Allocation (WFTE share)",null,null,"(j)",4737310,"x",0,0]
["15.  Additional Allocation (WFTE share)",null,null,"(k)",96819,"x",0,0]
["16.  Florida Teachers Lead Program Stipend"]
["17.  Food Service Allocation",null,null,"(g)"]
["Total",{"$nulls":6},0]
["18. Funding for the purpose of calculating the administrative fee for ESE Charters.",{"$nulls":5},"(h)"]
["If you have more than a 75% ESE student population please place a 1 in the following box:",{"$nulls":6},0]
["NOTES:"]
["(a) District allocations multiplied by percentage from item 6A."]
["(b) District allocations multiplied by percentage from item 6B."]
["(d) Proceeds of 0.748 millage levy (s. 1011.71(3)(b), Florida Statutes) multiplied by percentage from item 6A. "]
["(e) Consistent with Section 1006.21, Florida Statutes and DOE Student Transportation General Instructions. Numbers entered here will be multiplied by the district level transportation funding per rider. \"All Riders\" should include both basic and ESE Riders. \"ESE Student Riders\" should include only ESE Riders."]
["(f) Teacher Lead Program Allocation per Section 1012.71, Florida Statutes"]
["(g) Funding based on student eligibility and meals provided, if participating in the National School Lunch Program. "]
["(h) Consistent with Section 1002.33(20)(a), Florida Statutes, for charter schools with a population of 75% or more ESE students, the administrative fee shall be calculated based on unweighted full-time equivalent students. "]
[]
["(i) As provided in the 2013 General Appropriations Act, school districts are required to pay for instructional materials used for the instruction of public school high school students who are earning credit toward high school graduation under the dual enrollment program as provided in section 1011.62(l)(i), Florida Statutes.  "]
["(j) The Teacher Salary Allocation is provided pursuant to Specific Appropriation 87, Chapter 2013-40, Laws of Florida, and Section 26 of Chapter 2013-45, Laws of Florida. "]
["(k) An additional allocation of $9,810,000, due to a change in administered funds, is included in the 2013-14 FEFP Calculation."]
["Administrative fees charged by the school district shall be calculated based upon 5 percent of available funds from the FEFP and categorical funding for which charter students may be eligible.  For charter schools with a population of 251 or more students the difference in the fee calculation and the fee withheld may only be used for capital outlay purposes specified in Section 1013.62(2) F.S.  To calculate the administrative fee to be withheld for schools with more than 250 students, divide the school population into 250. Multiply that fraction times the funds available, then times 5%.  "]
["For high performing charter schools, administrative fees charged by the school district shall be calculated based upon 2 percent of available funds from the FEFP and  categorical funding for which charter students may be eligible.  For charter schools with a population of 251 or more students the difference in the fee calculation and the fee withheld may only be used for capital outlay purposes specified in Section 1013.62(2) F.S.  To calculate the administrative fee to be withheld for schools with more than 250 students, divide the school population into 250. Multiply that fraction times the funds available, then times 2 percent.  "]
["FEFP and categorical funding are recalculated during the year to reflect the revised number of full-time equivalent students reported during the survey periods designated by the Commissioner of Education."]
["Revenues flow to districts from state sources and from county tax collectors on various distribution schedules."]

{"sheet":" Detail 2013-14 Final FEFP","index":1,"n_rows":79,"n_cols":35,"rows_kept":79,"cut":false,"hidden":false,"merged":[[2,26,4,26],[0,0,0,29],[2,31,4,31]],"flags":["formulas_cached_only"]}
["Charter School Worksheet DATA"]
[null,"District","District Cost Differential","Unweighted FTE","Weighted FTE Funded","Declining Enrollment Supplement","Sparsity Supplement","State Funded Discretionary Contribution","Discretionary Tax Compression 0.748 mills","Safe Schools Allocation","Supplemental Academic Instruction","Minimum Guarantee Adjustment","ESE Guaranteed Allocation Dollars","0.748 Basic Discretionary Revenue","Total Disc.","Proration to the Appropriation","Proratioin to Veto","Total Proration to Funds Available","Discretionary (Lottery) District Discretionary Funds","Total Instructional Materials Allocation","Dual Enrollment Allocation","ESE Applications","Instructional Materials Allocation (Less dual enrollment and ESE Apps)","Teacher Salary Allocation","Additional Allocation",null,null,"k-3","4-8","9-12",null,null,"k-3","4-8","9-12"]
[1,"Alachua",0.9805,27276.030000000002,29602.719999999998,0,0,0,1491181,812069,7558718,0,10807040,8917231,8917231,-362330,0,-362330,266713,2225855,110162,30337,2085356,4737310,96819,null,"Prorated Class Size Allocation Factors ",1316.85,898.23,900.39,null,"Class Size Allocation Factors ",1320.15,900.48,902.65]
[2,"Baker",0.9772,4822.87,5108.7,0,668346,0,1238899,116982,1840562,0,1057149,601516,601516,-67211,0,-67211,45863,377010,9318,4239,363453,814791,16652]
[3,"Bay",0.9591,26261.89,29415.25,0,0,0,0,691334,7332371,0,7883952,10726586,10726586,-342080,0,-342080,259176,2155596,75342,36833,2043421,4604569,94106]
[4,"Bradford",0.9726,3007.6200000000003,3189.3000000000006,79019,951496,0,505822,124908,987920,0,1220260,641874,641874,-43913,0,-43913,28505,242009,5460,5268,231281,506270,10347]
[5,"Brevard",1.0088,70070.72,76969.87,0,0,0,6111568,1700288,18677119,0,26768095,20627295,20627295,-958840,0,-958840,713384,5709268,340228,95497,5273543,12672970,259004,null,"Proration Reduction",0.0025]
[6,"Broward",1.0235,260740.58999999997,283324.03,0,0,0,0,6143029,53067950,0,85327019,101998178,101998178,-3417158,0,-3417158,2664055,20712570,381384,281448,20049738,47328620,967279]
[7,"Calhoun",0.9256,2144.09,2307.09,31226,1510538,0,507335,84902,492421,0,788848,310847,310847,-32074,0,-32074,19615,173345,6584,3819,162942,348530,7123]
[8,"Charlotte",0.9887,15812.039999999997,16970.08,52837,0,0,0,410528,3565851,0,5975369,9466330,9466330,-206253,0,-206253,154025,1273873,64115,23215,1186543,2738426,55967]
[9,"Citrus",0.9515,14675.03,15813.25,192112,1993118,0,0,357659,3324411,0,6551629,6406098,6406098,-195623,0,-195623,138242,1147702,20143,14605,1112954,2455741,50189]
[10,"Clay",0.9935,35070.04,38226.74,0,0,0,6781494,610210,9553247,0,11174545,6601192,6601192,-477656,0,-477656,348635,2776080,82643,55056,2638381,6198516,126682]
[11,"Collier",1.0221,43818.369999999995,47739.25000000001,0,0,0,0,756602,8576297,0,19581838,45354898,45354898,-592502,0,-592502,448293,3611825,133129,46246,3432450,7963822,162761]
[12,"Columbia",0.964,10052.720000000001,10666.88,0,1247774,0,1997073,282658,3861145,0,3896342,1839062,1839062,-139830,0,-139830,94450,865601,28937,14109,822555,1678290,34300]
[13,"Miami-Dade",1.0123,350795.76999999996,380423.88000000006,0,0,0,0,9853415,117206208,0,126355688,141864182,141864182,-4654537,0,-4654537,3538666,27441420,568499,318221,26554700,62853518,1284569]
[14,"DeSoto",0.9758,4702.07,5007.5199999999995,64312,698159,0,768130,149461,1599500,0,2019998,1026170,1026170,-65993,0,-65993,44898,371412,9252,5405,356755,797510,16299]
[15,"Dixie",0.9386,2039.66,2218.94,0,976716,0,415112,104205,455085,0,535179,363225,363225,-29512,0,-29512,19139,172704,8680,4059,159965,339922,6947]
[16,"Duval",1.0123,127630.45999999999,138372.61000000002,0,0,0,11292743,3326268,29111016,0,44367275,37411224,37411224,-1709799,0,-1709799,1286759,10234563,210101,152303,9872159,22861881,467240]
[17,"Escambia",0.9635,40170.72,43806.4,0,0,0,4462164,1195964,9303778,0,13850153,10866847,10866847,-532230,0,-532230,387838,3107568,46273,50241,3011054,6888773,140789]
[18,"Flagler",0.9604,12508.08,13263.770000000002,64541,1199035,0,0,278885,2767251,0,5412191,5012917,5012917,-165059,0,-165059,116882,967110,13652,12888,940570,2079083,42491]
[19,"Franklin",0.9337,1223.47,1306.7,0,69634,0,0,89993,295654,0,490175,1231574,1231574,-16157,0,-16157,11207,117482,5605,1716,110161,199130,4070]
[20,"Gadsden",0.9486,5515.18,5870.38,38304,1938249,0,1041101,173608,1208999,0,1761099,1063487,1063487,-77330,0,-77330,51150,425052,4078,5378,415596,908870,18575]
[21,"Gilchrist",0.958,2491.68,2734.69,0,1663805,0,490736,96488,566902,0,962826,460096,460096,-38130,0,-38130,24059,215671,17980,3927,193764,427589,8739]
[22,"Glades",0.973,1516.0600000000002,1621.5800000000002,0,882288,0,163598,90068,299595,0,528819,414931,414931,-22157,0,-22157,14496,122426,2042,2031,118353,257516,5263]
[23,"Gulf",0.9365,1795.1699999999998,1974.2600000000002,67773,1024076,0,0,89313,383645,0,207483,1007295,1007295,-24682,0,-24682,16986,146127,3870,2484,139773,301762,6167]
[24,"Hamilton",0.9328,1627.57,1772.1,0,921095,0,50438,95166,347108,0,462758,570645,570645,-22938,0,-22938,15184,134970,2370,1885,130715,269792,5514]
[25,"Hardee",0.9679,5225.13,5557.05,0,578484,0,881741,146909,1156216,0,1811284,1112165,1112165,-70011,0,-70011,49427,430383,8514,5222,416647,877864,17941]
[26,"Hendry",0.9781,6909.040000000001,7325.7300000000005,0,1816118,0,1363844,195421,1522686,0,2314397,1272615,1272615,-95626,0,-95626,65835,542999,2994,7961,532044,1169464,23901]
[27,"Hernando",0.975,21828.480000000003,23417.699999999997,0,0,0,2600427,522049,5177648,0,8720489,5729247,5729247,-289636,0,-289636,209646,1726546,42629,21821,1662096,3726503,76160]
[28,"Highlands",0.9513,12076.45,12848.560000000001,0,2484167,0,1156079,317776,2482653,0,3865670,3452239,3452239,-158296,0,-158296,112294,967442,33123,12588,921731,1994916,40771]
[29,"Hillsborough",1.0122,200718.52000000002,218539.61000000002,0,0,0,26530974,3481303,39111307,0,73653607,50062628,50062628,-2719590,0,-2719590,2032466,15975943,62832,237924,15675187,36103481,737865]
[30,"Holmes",0.9301,3217.09,3394.19,0,2222303,0,893161,103303,698809,0,1034329,334481,334481,-46951,0,-46951,28997,256187,6828,3756,245603,515251,10530]
[31,"Indian River",0.9941,17603.44,19208.660000000003,21906,0,0,0,422502,3553356,0,5011309,9841026,9841026,-228416,0,-228416,175409,1376377,39451,18894,1318032,3116590,63695]
[32,"Jackson",0.9385,6508.009999999999,7068.450000000001,72483,2954715,0,1343514,177705,1383317,0,2275435,1139912,1139912,-93634,0,-93634,60947,519142,18983,7554,492605,1082707,22128]
[33,"Jefferson",0.9334,922.4099999999999,975.25,55584,577929,0,0,85529,297351,0,567104,436014,436014,-14305,0,-14305,8368,75164,289,1201,73674,148572,3036]
[34,"Lafayette",0.9273,1193.3600000000001,1263.8099999999997,0,786186,0,270153,75433,210024,0,263894,185234,185234,-16912,0,-16912,10762,97011,2033,1476,93502,191273,3909]
[35,"Lake",0.9757,40970.77,43988.7,0,0,0,3798810,829902,9554540,0,12387365,11835778,11835778,-529541,0,-529541,394271,3235321,42514,45095,3147712,7005030,143165]
[36,"Lee",1.0198,86158.73000000001,93577.51,0,0,0,0,1726456,18196709,0,37338681,42674565,42674565,-1177394,0,-1177394,876878,7067797,145842,94571,6827384,15575395,318322]
[37,"Leon",0.9529,33334.12,36472.880000000005,0,0,0,2299054,1034330,9182104,0,16410791,10421272,10421272,-443906,0,-443906,319083,2615756,28666,44978,2542112,5672441,115931]
[38,"Levy",0.9534,5406.88,5887.150000000001,143369,2851620,0,832768,181516,1274962,0,1980276,1230499,1230499,-80285,0,-80285,51548,433714,7900,9814,416000,916079,18722]
[39,"Liberty",0.9355,1425.78,1626.0200000000004,19161,918042,0,385203,75532,297684,0,507785,158870,158870,-22858,0,-22858,13966,113710,3283,2282,108145,248269,5074]
[40,"Madison",0.9221,2489.22,2641.04,86799,971374,0,464414,112477,711574,0,1212365,485485,485485,-35999,0,-35999,22339,202714,5105,3998,193611,397471,8123]
[41,"Manatee",1.0143,45890.25000000001,49650.08,0,0,0,0,1178904,9217207,0,18714053,18592735,18592735,-608659,0,-608659,462955,3781288,114842,62443,3604003,8219378,167984]
[42,"Marion",0.967,41406.700000000004,44319.62000000001,0,0,0,4719122,892299,12602317,0,14947445,11081567,11081567,-550868,0,-550868,393754,3241528,73999,51461,3116068,6994797,142956]
[43,"Martin",1.0006,18293.979999999996,20189.990000000005,0,0,0,0,408465,3706983,0,6619601,13080803,13080803,-244645,0,-244645,185614,1561413,148023,23035,1390355,3297230,67387]
[44,"Monroe",1.0271,8011.84,8621.600000000002,0,0,0,0,308469,1776427,0,2963113,14730464,14730464,-107118,0,-107118,81337,638683,4433,10167,624083,1445284,29538]
[45,"Nassau",0.9903,11150.949999999999,11881.409999999998,0,2221228,0,0,230230,2514159,0,2898506,4803156,4803156,-147796,0,-147796,108094,915789,42183,12736,860870,1920381,39248]
[46,"Okaloosa",0.9818,29875.800000000003,32980.990000000005,0,0,0,742414,597778,8432680,0,10848702,10658322,10658322,-400459,0,-400459,297331,2420103,84688,34615,2300800,5284931,108011]
[47,"Okeechobee",0.9692,6420.34,6805.39,88347,615454,0,1321884,193430,1624966,0,2740260,1128106,1128106,-89261,0,-89261,60585,509717,11640,10822,487255,1076512,22001]
[48,"Orange",1.0034,185593.52,205470.74000000002,0,0,0,6607129,4543423,39557734,0,50307896,64216126,64216126,-2444260,0,-2444260,1893902,15237079,243174,181832,14812073,33649349,687709]
[49,"Osceola",0.9858,57239.28,61995.9,0,0,0,8682054,1073836,12453229,0,15168079,13160424,13160424,-750821,0,-750821,561562,4833268,139291,54479,4639498,9974804,203860]
[50,"Palm Beach",1.0326,180172.15000000002,197603.93000000002,0,0,0,0,4123299,34389540,0,64753322,96774526,96774526,-2417636,0,-2417636,1874789,14594240,162371,225694,14206175,33302764,680625]
[51,"Pasco",0.9905,66904.16999999998,73297.09,0,0,0,10172779,1393165,17875626,0,26909547,15357953,15357953,-928163,0,-928163,667011,5465681,90010,81635,5294036,11849330,242171]
[52,"Pinellas",0.9989,102251.2,110549.10999999999,0,0,0,0,2948128,20667930,0,41955889,43742012,43742012,-1331865,0,-1331865,1014510,8051858,276583,110003,7665272,18023115,368347]
[53,"Polk",0.9875,96143.87999999999,103218.96999999999,0,0,0,17652978,1953359,22542064,0,33227557,19035321,19035321,-1290842,0,-1290842,935649,7710272,193868,92735,7423669,16636011,339998]
[54,"Putnam",0.9633,10724.58,11365.73,0,2677852,0,1548844,349872,2785180,0,3328525,2543613,2543613,-146245,0,-146245,100553,843887,13526,14779,815582,1786946,36521]
[55,"St. Johns",0.985,33272.200000000004,36281.56000000001,0,0,0,0,585780,6370592,0,9651968,13572439,13572439,-430866,0,-430866,328359,2830671,57459,39666,2733546,5832769,119207]
[56,"St. Lucie",0.9918,38807.68,41385.66,0,0,0,3007983,844591,9294401,0,15453970,11801116,11801116,-518782,0,-518782,377130,3073205,123543,36164,2913498,6699256,136916]
[57,"Santa Rosa",0.9537,25402.460000000003,27385.200000000004,0,0,0,3758294,389354,7646439,0,8229213,5935168,5935168,-334936,0,-334936,239896,2141048,155754,24545,1960749,4262656,87118]
[58,"Sarasota",1.001,41135.55,45246.48,0,0,0,0,1127795,8348718,0,20968741,31359408,31359408,-557761,0,-557761,416152,3314705,106273,47869,3160563,7392162,151077]
[59,"Seminole",0.9955,64019.14,69202.87,0,0,0,5135615,1174985,15302028,0,18223087,19294311,19294311,-836725,0,-836725,632825,5032897,49986,68425,4914486,11243925,229798]
[60,"Sumter",0.9667,8006.89,8517.72,0,30012,0,0,181001,1576717,0,2824076,6099964,6099964,-99461,0,-99461,75643,684607,19887,8741,655979,1343902,27466]
[61,"Suwannee",0.9433,5863,6206.49,0,1909915,0,1086648,160169,1251570,0,446622,1150685,1150685,-76314,0,-76314,53791,463154,7873,5857,449424,955539,19529]
[62,"Taylor",0.9361,2735.3,2918.56,1174,972558,0,124511,110852,615936,0,934543,919287,919287,-37208,0,-37208,25086,216897,8578,3679,204640,445906,9113]
[63,"Union",0.9639,2274.7400000000002,2432.3900000000003,0,974602,0,688291,90194,496869,0,532382,179739,179739,-32859,0,-32859,21548,195723,4117,2925,188681,382664,7821]
[64,"Volusia",0.9683,60935.240000000005,66368.92,0,0,0,3760923,1593220,16076784,0,22068792,19491860,19491860,-797113,0,-797113,590394,4821667,129964,80918,4610785,10488835,214366]
[65,"Wakulla",0.9457,4988.22,5359.549999999999,0,640630,0,1062890,143335,960936,0,1496384,840601,840601,-67812,0,-67812,46571,391063,7918,8142,375003,827245,16907]
[66,"Walton",0.9773,7845.15,8301.31,0,0,0,0,207442,1331936,0,2116819,8544870,8544870,-97884,0,-97884,74523,657433,18025,6132,633276,1324119,27062]
[67,"Washington",0.9311,3244.5699999999997,3484.539999999999,133506,1815565,0,580681,107313,879520,0,703343,657459,657459,-46451,0,-46451,29813,274479,15983,4642,253854,529535,10822]
[68,"Washington Special",0.9311,114.9,115.95,11690,0,0,0,848,99088,0,452445,0,0,-3082,0,-3082,1003,9963,0,337,9626,17621,360]
[69,"FAMU Lab School",0.9529,466.46,488.50000000000006,6796,329837,145829,32172,66104,302886,0,18449,0,0,-7365,0,-7365,4277,35931,349,141,35441,75974,1553]
[70,"FAU Lab School",1.0326,924.85,956.6800000000001,0,0,511109,0,69488,262131,0,79824,0,0,-13002,0,-13002,9075,162515,73415,495,88605,161232,3295]
[71,"FAU St. Lucie",0.9918,1402.79,1496.79,0,0,426574,108730,73016,415043,0,155576,0,0,-18514,0,-18514,13640,106394,0,1050,105344,242291,4952]
[72,"FSU Lab - Broward",1.0235,685.01,738.5699999999999,1339,0,267969,0,67717,141578,0,156485,0,0,-9652,0,-9652,6946,51914,0,588,51326,123376,2522]
[73,"FSU Lab - Leon",0.9529,1680.6,1771.72,8938,901268,525406,115911,75067,285250,0,279728,0,0,-23204,0,-23204,15513,131780,4494,877,126409,275547,5631]
[74,"UF Lab School",0.9805,1122.1999999999998,1185.9499999999998,1608,760190,366881,61351,70945,298069,0,287373,0,0,-16951,0,-16951,10685,99358,14737,576,84045,189787,3879]
[75,"Virtual School",1,28386.880000000005,29105.180000000004,4193698,0,10696176,136257,0,0,null,184602,0,0,-385306,0,-385306,268270,2413717,2181,1450,2410086,4750320,97085]
[]
[null,"Total",null,2705147.8000000007,2938399.4400000013,5436522,45754378,12939944,151244997,64456019,639296226,0,947987428,1003907765,1003907765,-36087240,0,-36087240,27019242,217277372,5000000,3000000,209277372,480000000,9810000]

{"sheet":"111-112-113 ADDITIONAL FUND","index":2,"n_rows":80,"n_cols":12,"rows_kept":80,"cut":false,"hidden":false,"merged":[[1,0,4,0],[1,1,4,1],[1,2,4,2],[1,3,1,5],[1,6,1,8],[0,0,0,11],[1,9,1,11],[2,3,4,3],[2,4,4,4],[2,5,4,5],[2,6,4,6],[2,7,4,7],[2,8,4,8],[2,9,4,9],[2,10,4,10],[2,11,4,11]],"flags":["formulas_cached_only"]}
["ESE Funding Based on the 2001-02 Matrix Levels"]
[null,"Districts","2000-01 District Cost Differential\n","Program 111- Grades K-3",null,null,"Program 112- Grades 4-8",null,null,"Program 113- Grades 9-12"]
[null,null,null,"ESE LEVEL 1\n","ESE LEVEL 2\n","ESE LEVEL 3","ESE LEVEL 1","ESE LEVEL 2","ESE LEVEL 3","ESE LEVEL 1","ESE LEVEL 2","ESE LEVEL 3"]
[]
[]
[1,"Alachua",0.9604,975,3147,6422,1093,3265,6540,778,2950,6225]
[2,"Baker",0.9334,947,3058,6241,1062,3173,6356,756,2867,6050]
[3,"Bay",0.9592,973,3143,6414,1091,3261,6532,777,2946,6217]
[4,"Bradford",0.9295,943,3046,6215,1058,3160,6329,753,2855,6025]
[5,"Brevard",0.9818,996,3217,6565,1117,3338,6686,795,3016,6364]
[6,"Broward",1.043,1058,3418,6974,1187,3546,7102,845,3204,6760]
[7,"Calhoun",0.9131,927,2992,6105,1039,3104,6218,739,2805,5918]
[8,"Charlotte",0.9695,984,3177,6483,1103,3296,6602,785,2978,6284]
[9,"Citrus",0.9345,948,3062,6249,1063,3177,6364,757,2870,6057]
[10,"Clay",0.9676,982,3170,6470,1101,3290,6589,784,2972,6272]
[11,"Collier",1.0089,1024,3306,6746,1148,3430,6870,817,3099,6539]
[12,"Columbia",0.9336,947,3059,6243,1062,3174,6357,756,2868,6051]
[13,"Miami-Dade",1.0543,1070,3455,7050,1200,3584,7179,854,3238,6833]
[14,"DeSoto",0.9369,951,3070,6265,1066,3185,6380,759,2878,6073]
[15,"Dixie",0.9355,949,3065,6255,1064,3180,6370,758,2874,6063]
[16,"Duval",0.9794,994,3209,6549,1114,3330,6669,793,3008,6348]
[17,"Escambia",0.9516,966,3118,6363,1083,3235,6480,771,2923,6168]
[18,"Flagler",0.9607,975,3148,6424,1093,3266,6542,778,2951,6227]
[19,"Franklin",0.9611,975,3149,6426,1094,3267,6545,778,2952,6229]
[20,"Gadsden",0.9401,954,3080,6286,1070,3196,6402,761,2888,6093]
[21,"Gilchrist",0.9363,950,3068,6261,1065,3183,6376,758,2876,6069]
[22,"Glades",0.9611,975,3149,6426,1094,3267,6545,778,2952,6229]
[23,"Gulf",0.9384,952,3075,6275,1068,3190,6390,760,2882,6082]
[24,"Hamilton",0.9336,947,3059,6243,1062,3174,6357,756,2868,6051]
[25,"Hardee",0.9322,946,3054,6233,1061,3169,6348,755,2863,6042]
[26,"Hendry",0.9536,968,3125,6376,1085,3242,6494,772,2929,6181]
[27,"Hernando",0.9467,961,3102,6330,1077,3218,6447,767,2908,6136]
[28,"Highlands",0.9504,964,3114,6355,1081,3231,6472,770,2919,6160]
[29,"Hillsborough",1.0015,1016,3282,6697,1139,3405,6820,811,3076,6491]
[30,"Holmes",0.9327,946,3056,6237,1061,3171,6351,755,2865,6045]
[31,"Indian River",0.9849,999,3227,6586,1121,3348,6707,798,3025,6384]
[32,"Jackson",0.9203,934,3015,6154,1047,3129,6267,745,2827,5965]
[33,"Jefferson",0.9549,969,3129,6385,1086,3246,6502,773,2933,6189]
[34,"Lafayette",0.9382,952,3074,6273,1067,3190,6389,760,2882,6081]
[35,"Lake",0.9595,974,3144,6416,1092,3262,6534,777,2947,6219]
[36,"Lee",0.9774,992,3203,6535,1112,3323,6656,791,3002,6335]
[37,"Leon",0.9718,986,3184,6498,1106,3304,6618,787,2985,6299]
[38,"Levy",0.9319,946,3054,6231,1060,3168,6346,755,2862,6040]
[39,"Liberty",0.9284,942,3042,6208,1056,3156,6322,752,2852,6017]
[40,"Madison",0.9364,950,3068,6261,1065,3183,6376,758,2876,6069]
[41,"Manatee",0.9967,1011,3266,6664,1134,3388,6787,807,3062,6460]
[42,"Marion",0.9483,962,3107,6341,1079,3224,6457,768,2913,6146]
[43,"Martin",0.9935,1008,3255,6643,1130,3378,6765,805,3052,6439]
[44,"Monroe",1.0818,1098,3545,7233,1231,3678,7367,876,3323,7012]
[45,"Nassau",0.9498,964,3112,6351,1081,3229,6468,769,2917,6156]
[46,"Okaloosa",0.9627,977,3154,6437,1095,3273,6556,780,2957,6240]
[47,"Okeechobee",0.959,973,3142,6412,1091,3260,6530,777,2946,6216]
[48,"Orange",1.0003,1015,3278,6689,1138,3401,6812,810,3073,6483]
[49,"Osceola",0.9676,982,3170,6470,1101,3290,6589,784,2972,6272]
[50,"Palm Beach",1.0314,1047,3380,6896,1173,3506,7023,835,3168,6685]
[51,"Pasco",0.9598,974,3145,6418,1092,3263,6536,777,2948,6221]
[52,"Pinellas",1.024,1039,3355,6847,1165,3481,6973,829,3145,6637]
[53,"Polk",0.9641,978,3159,6446,1097,3278,6565,781,2961,6249]
[54,"Putnam",0.9397,954,3079,6283,1069,3195,6399,761,2886,6091]
[55,"St. Johns",0.9792,994,3208,6547,1114,3329,6668,793,3008,6347]
[56,"St. Lucie",0.9638,978,3158,6444,1097,3277,6563,780,2960,6247]
[57,"Santa Rosa",0.9382,952,3074,6273,1067,3190,6389,760,2882,6081]
[58,"Sarasota",1.0126,1028,3318,6771,1152,3442,6895,820,3110,6563]
[59,"Seminole",0.9943,1009,3258,6648,1131,3380,6771,805,3054,6445]
[60,"Sumter",0.9219,936,3021,6164,1049,3134,6278,747,2832,5975]
[61,"Suwannee",0.9293,943,3045,6214,1057,3159,6328,753,2854,6023]
[62,"Taylor",0.9499,964,3112,6352,1081,3229,6468,769,2918,6157]
[63,"Union",0.9314,945,3052,6228,1060,3166,6342,754,2861,6037]
[64,"Volusia",0.9647,979,3161,6451,1098,3280,6569,781,2963,6253]
[65,"Wakulla",0.943,957,3090,6305,1073,3206,6421,764,2897,6112]
[66,"Walton",0.9372,951,3071,6267,1066,3186,6382,759,2879,6074]
[67,"Washington",0.9097,923,2981,6083,1035,3093,6195,737,2794,5896]
[68,"Washington Special",0.9097,923,2981,6083,1035,3093,6195,737,2794,5896]
[69,"FAMU Lab School",0.9718,986,3184,6498,1106,3304,6618,787,2985,6299]
[70,"FAU Lab School",1.0314,1047,3380,6896,1173,3506,7023,835,3168,6685]
[71,"FAU St. Lucie",0.9638,978,3158,6444,1097,3277,6563,780,2960,6247]
[72,"FSU Lab-Broward",1.043,1058,3418,6974,1187,3546,7102,845,3204,6760]
[73,"FSU Lab-Leon",0.9718,986,3184,6498,1106,3304,6618,787,2985,6299]
[74,"UF Lab School",0.9604,975,3147,6422,1093,3265,6540,778,2950,6225]
[75,"Fl Virtual School",1,1015,3277,6687,1138,3400,6810,810,3072,6482]

{"sheet":"Transportation Per Student","index":3,"n_rows":89,"n_cols":12,"rows_kept":89,"cut":false,"hidden":false,"merged":[[8,1,8,11],[10,1,10,11],[11,1,11,11],[14,3,14,5],[14,7,14,9]],"flags":["formulas_cached_only"]}
{"$rows_empty":8}
[null,"FLORIDA DEPARTMENT OF EDUCATION"]
[]
[null,"2013-14 Transportation Calculation"]
[null,"Funding Per Student"]
[]
[]
[null,null,null,"Base Funding",null,null,null,"ESE Funding"]
[{"$nulls":11},"Total"]
[{"$nulls":4},"Adjusted","Allocation ",null,null,"Adjusted","Allocation ",null,"Allocation "]
[null,null,null,"Base","Base","per Base",null,"ESE","ESE","per ESE",null,"per ESE"]
[null,null,null,"Allocation ","Students","Student",null,"Allocation","Students","Student",null,"Student"]
[null,null,"District","-1-","-2-","-3-",null,"-4- ","-5-","-6-",null,"-7-"]
[null,1,"Alachua",3632796,10003.67,363,null,661656,482.17,1372,null,1735]
[null,2,"Baker",1179088,3036.7300000000005,388,null,69142,47.13,1467,null,1855]
[null,3,"Bay",3935663,10652.600000000002,369,null,502516,359.95,1396,null,1765]
[null,4,"Bradford",667251,1705.66,391,null,88135,59.620000000000005,1478,null,1869]
[null,5,"Brevard",8965261,25260.320000000003,355,null,1292765,963.9399999999999,1341,null,1696]
[null,6,"Broward",26892479,76788.79,350,null,2505248,1893.0900000000001,1323,null,1673]
[null,7,"Calhoun",397540,1069.17,372,null,45748,32.56,1405,null,1777]
[null,8,"Charlotte",2620377,7132.93,367,null,609958,439.40000000000003,1388,null,1755]
[null,9,"Citrus",3331076,9046.02,368,null,211298,151.85,1391,null,1759]
[null,10,"Clay",4947607,13472.99,367,null,1416769,1020.99,1388,null,1755]
[null,11,"Collier",6641737,18233.44,364,null,328455,238.62,1376,null,1740]
[null,12,"Columbia",1682783,4402.67,382,null,312749,216.54,1444,null,1826]
[null,13,"Miami-Dade",19694787,58818.10999999999,335,null,3987880,3151.78,1265,null,1600]
[null,14,"DeSoto",670215,1774.74,378,null,109592,76.80000000000001,1427,null,1805]
[null,15,"Dixie",539461,1383,390,null,25058,17,1474,null,1864]
[null,16,"Duval",15032066,44522.29,338,null,3688109,2890.79,1276,null,1614]
[null,17,"Escambia",8487538,23612.479999999996,359,null,1280405,942.6700000000001,1358,null,1717]
[null,18,"Flagler",3221208,8691.73,371,null,342784,244.77,1400,null,1771]
[null,19,"Franklin",319525,845,378,null,25717,18,1429,null,1807]
[null,20,"Gadsden",1397006,3627.5000000000005,385,null,256651,176.36,1455,null,1840]
[null,21,"Gilchrist",469300,1207.3700000000001,389,null,34328,23.37,1469,null,1858]
[null,22,"Glades",259984,673,386,null,5109,3.5,1460,null,1846]
[null,23,"Gulf",318194,838.99,379,null,30809,21.5,1433,null,1812]
[null,24,"Hamilton",330778,910.14,363,null,13786,10.04,1373,null,1736]
[null,25,"Hardee",1003152,2510.1,400,null,95139,63,1510,null,1910]
[null,26,"Hendry",1250925,3350.68,373,null,109089,77.33,1411,null,1784]
[null,27,"Hernando",4271912,11074.580000000002,386,null,125981,86.42999999999999,1458,null,1844]
[null,28,"Highlands",2020932,5746.24,352,null,412008,310.02,1329,null,1681]
[null,29,"Hillsborough",28283338,77343.82,366,null,5546863,4014.1700000000005,1382,null,1748]
[null,30,"Holmes",614172,1662.5,369,null,12566,9,1396,null,1765]
[null,31,"Indian River",3376666,8777.289999999999,385,null,300768,206.9,1454,null,1839]
[null,32,"Jackson",1432725,3781,379,null,249145,174,1432,null,1811]
[null,33,"Jefferson",237537,614.59,386,null,8891,6.09,1460,null,1846]
[null,34,"Lafayette",191801,487,394,null,0,0,0,null,394]
[null,35,"Lake",7053067,19473.670000000002,362,null,1145072,836.67,1369,null,1731]
[null,36,"Lee",17927347,51193.7,350,null,2457827,1857.4,1323,null,1673]
[null,37,"Leon",3983946,11327.01,352,null,1113381,837.7199999999999,1329,null,1681]
[null,38,"Levy",1344904,3355.37,401,null,189891,125.37,1515,null,1916]
[null,39,"Liberty",269024,670.0500000000001,401,null,60366,39.79,1517,null,1918]
[null,40,"Madison",545969,1462.6,373,null,9633,6.83,1410,null,1783]
[null,41,"Manatee",5859166,15691.41,373,null,843735,597.98,1411,null,1784]
[null,42,"Marion",8470703,22072.11,384,null,1701774,1173.4899999999998,1450,null,1834]
[null,43,"Martin",3461233,8641.939999999999,401,null,288598,190.69,1513,null,1914]
[null,44,"Monroe",1126785,3049.3700000000003,370,null,116349,83.33,1396,null,1766]
[null,45,"Nassau",2337203,5902.58,396,null,277927,185.75000000000003,1496,null,1892]
[null,46,"Okaloosa",4925681,13739.94,358,null,924956,682.8,1355,null,1713]
[null,47,"Okeechobee",1475701,3818.09,387,null,149515,102.37,1461,null,1848]
[null,48,"Orange",25244779,70160.23,360,null,2519413,1852.99,1360,null,1720]
[null,49,"Osceola",8916307,24583.3,363,null,1774451,1294.71,1371,null,1734]
[null,50,"Palm Beach",20088351,55797.799999999996,360,null,4252763,3126.06,1360,null,1720]
[null,51,"Pasco",13310554,35213.49,378,null,1731636,1212.34,1428,null,1806]
[null,52,"Pinellas",9894040,28867.09,343,null,2309837,1783.46,1295,null,1638]
[null,53,"Polk",17534438,47108.53,372,null,2932237,2084.78,1406,null,1778]
[null,54,"Putnam",2304052,6012.83,383,null,172307,119,1448,null,1831]
[null,55,"St. Johns",7292165,18040.06,404,null,702946,460.21,1527,null,1931]
[null,56,"St. Lucie",8335216,23483.420000000002,355,null,1145327,853.9399999999999,1341,null,1696]
[null,57,"Santa Rosa",5280147,14427.32,366,null,567497,410.35,1383,null,1749]
[null,58,"Sarasota",5449500,15458.470000000001,353,null,632881,475.1,1332,null,1685]
[null,59,"Seminole",10021940,27943.11,359,null,842532,621.6700000000001,1355,null,1714]
[null,60,"Sumter",964854,2746.04,351,null,107244,80.77,1328,null,1679]
[null,61,"Suwannee",1272910,3235.97,393,null,101039,67.97,1487,null,1880]
[null,62,"Taylor",584047,1578.4199999999998,370,null,137484,98.33,1398,null,1768]
[null,63,"Union",487803,1256,388,null,33018,22.5,1467,null,1855]
[null,64,"Volusia",9162770,23541.39,389,null,1017648,691.9200000000001,1471,null,1860]
[null,65,"Wakulla",1761431,4240.19,415,null,20386,12.99,1569,null,1984]
[null,66,"Walton",1772759,4765.91,372,null,117379,83.51,1406,null,1778]
[null,67,"Washington",734932,1933.47,380,null,61800,43.03,1436,null,1816]
[]
[null,null,"State",367510604,1013848.0199999998,362,null,55163966,40545.2,1361,null,1723]

{"sheet":"75% or more ESE calculation","index":4,"n_rows":83,"n_cols":9,"rows_kept":83,"cut":false,"hidden":false,"merged":[[75,0,75,2],[75,3,75,4],[76,0,76,6],[77,0,77,6],[73,0,73,1],[74,0,74,2],[74,3,74,4],[0,1,0,7],[1,0,1,7],[2,0,2,7],[3,0,3,1],[3,2,3,3],[4,0,4,7],[5,0,5,1],[5,2,5,3],[5,4,5,5],[5,6,5,7],[6,0,6,1],[6,2,6,3],[6,4,6,5],[7,0,7,1],[7,2,7,3],[7,4,7,5],[8,0,8,1],[8,2,8,3],[8,4,8,5],[9,0,9,1],[9,2,9,3],[9,4,9,5],[10,0,10,1],[10,2,10,3],[10,4,10,5],[11,0,11,1],[11,2,11,3],[11,4,11,5],[12,0,12,1],[12,2,12,3],[12,4,12,5],[13,0,13,1],[13,2,13,3],[13,4,13,5],[14,0,14,1],[14,2,14,3],[14,4,14,5],[15,0,15,1],[15,2,15,3],[15,4,15,5],[16,0,16,1],[16,2,16,3],[16,4,16,5],[17,0,17,1],[17,2,17,3],[17,4,17,5],[18,0,18,1],[18,2,18,3],[18,4,18,5],[19,0,19,1],[19,2,19,3],[19,4,19,5],[20,0,20,1],[20,2,20,3],[20,4,20,5],[21,0,21,1],[21,2,21,3],[21,4,21,5],[22,0,22,1],[22,2,22,3],[22,4,22,5],[23,0,23,1],[23,2,23,3],[23,4,23,5],[24,0,24,1],[24,2,24,3],[24,4,24,5],[25,0,25,1],[25,2,25,3],[26,0,34,1],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[35,0,35,1],[35,2,35,3],[35,4,35,6],[36,0,36,7],[37,0,37,1],[37,2,37,3],[37,4,37,7],[38,0,38,1],[38,2,38,5],[39,0,39,7],[40,0,40,7],[41,0,41,7],[42,0,42,6],[43,0,43,7],[44,2,44,3],[44,4,44,7],[45,2,45,3],[46,2,46,3],[47,2,47,3],[48,2,48,6],[49,0,49,7],[50,0,50,7],[51,0,51,1],[51,3,51,4],[51,5,51,7],[52,0,52,5],[52,6,52,7],[53,0,53,7],[54,0,54,1],[54,3,54,4],[54,5,54,7],[55,0,55,5],[55,6,55,7],[79,0,79,6],[56,0,56,2],[57,0,57,7],[58,0,58,1],[58,2,58,7],[59,0,59,1],[59,2,59,7],[56,3,56,4],[60,0,60,1],[60,2,60,7],[61,0,61,7],[62,0,62,1],[62,2,62,7],[63,0,63,1],[63,2,63,7],[64,0,64,2],[65,0,65,7],[66,0,66,2],[67,0,67,2],[68,0,68,2],[64,3,64,4],[66,3,66,4],[67,3,67,4],[68,3,68,4],[69,0,69,2],[70,0,70,6],[72,0,72,1],[89,0,90,7],[78,0,78,6],[80,0,80,7],[81,0,81,7],[82,0,82,7],[69,3,69,4],[71,0,71,7],[91,0,91,7],[92,0,92,7],[93,0,93,7],[94,0,94,7],[95,0,95,7],[83,0,83,7],[84,0,84,7],[85,0,85,7],[86,0,86,7],[87,0,88,7]],"flags":["formulas_cached_only"]}
[1,"(Insert district number in cell A1, enter, then strike F9. Your district data then pulls from Calculation Detail Sheets)"]
[]
["Based on the Final Calculation of the FEFP 2013-14"]
["School District: ",null,"Alachua"]
["1.  2013-14 FEFP State and Local Funding"]
["Base Student Allocation",null,3752.3,null,"District Cost Differential: ",null,0.9805]
["Program",null,"Number of FTE",null,"Program                              Cost Factor",null,"Weighted FTE           (b) x (c)","2013-14 Base Funding WFTE x BSA x DCD"]
["(a)",null,"(b)",null,"(c)",null,"(d)","(e)"]
["101 Basic K-3",null,0,null,1,null,0,0,1]
["111 Basic K-3 with ESE Services",null,0,null,1,null,0,0]
["102 Basic 4-8",null,0,null,1,null,0,0]
["112 Basic 4-8 with ESE Services",null,0,null,1,null,0,0]
["103 Basic 9-12",null,0,null,1,null,0,0]
["113 Basic 9-12 with ESE Services",null,0,null,1,null,0,0]
["254 ESE Level 4 (Grade Level PK-3)",null,0,null,1,null,0,0]
["254 ESE Level 4 (Grade Level 4-8)",null,0,null,1,null,0,0]
["254 ESE Level 4 (Grade Level 9-12)",null,0,null,1,null,0,0]
["255 ESE Level 5 (Grade Level PK-3)",null,0,null,1,null,0,0]
["255 ESE Level 5 (Grade Level 4-8)",null,0,null,1,null,0,0]
["255 ESE Level 5 (Grade Level 9-12)",null,0,null,1,null,0,0]
["130 ESOL (Grade Level PK-3)",null,0,null,1,null,0,0]
["130 ESOL (Grade Level 4-8)",null,0,null,1,null,0,0]
["130 ESOL (Grade Level 9-12)",null,0,null,1,null,0,0]
["300 Career Education (Grades 9-12)",null,0,null,1,null,0,0]
["Totals",null,0,null,null,null,0,0]
["2.  ESE Guaranteed Allocation:",null,"FTE",null,"Grade Level","Matrix Level","Guarantee Per Student"]
["Additional Funding from the ESE Guaranteed Allocation. Enter the FTE from 111,112, & 113 by grade and matrix level.  Students who do not have a matrix level should be considered 251.  This total should equal all FTE from programs 111, 112 & 113 above.",null,null,null,"PK-3",251,975,0]
[{"$nulls":4},"PK-3",252,3147,0]
[{"$nulls":4},"PK-3",253,6422,0]
[{"$nulls":4},"4-8",251,1093,0]
[{"$nulls":4},"4-8",252,3265,0]
[{"$nulls":4},"4-8",253,6540,0]
[{"$nulls":4},"9-12",251,778,0]
[{"$nulls":4},"9-12",252,2950,0]
[{"$nulls":4},"9-12",253,6225,0]
["Total FTE with ESE Services",null,0,null,"Total from ESE Guarantee",null,null,0]
["3.  Supplemental Academic Instruction:"]
["District SAI Allocation ",null,7558718,null,"Per Student"]
["divided by district FTE ",null,27276.030000000002,null,null,null,277,0]
["(with eligible services)"]
["4.  Reading Allocation: "]
["Charter Schools should contact their school district sponsor regarding eligibility and distribution of reading allocation funds."]
["Total Base Funding, ESE Guarantee, and SAI",{"$nulls":6},0]
["5.  Class size Reduction Funds:"]
[null,"Weighted FTE (From Section 1)","X             DCD            X",null,"Allocation factors"]
["PK - 3",0,0.9805,null,1316.85,"=",0]
["4-8",0,0.9805,null,898.23,"=",0]
["9-12",0,0.9805,null,900.39,"=",0]
["Total *",0,"Total Class Size Reduction Funds",{"$nulls":4},0]
["(*Total FTE should equal total in Section 1, column (d).)"]
["6A.  Divide school's Weighted FTE (WFTE) total computed "]
["in (d) above:",null,0,"by district's WFTE:",null,29602.719999999998]
["to obtain school's WFTE share. ",{"$nulls":5},0]
["6B.  Divide school's Unweighted FTE (UFTE) total computed "]
["in (b) above:",null,0,"by district's UFTE:",null,27276.030000000002]
["to obtain school's UFTE share.  ",{"$nulls":5},0]
["7.  Other FEFP (WFTE share)",null,null,812069,null,"x",0,0]
["Applicable to all Charter Schools:"]
["Declining Enrollment",null,0]
["Sparsity Supplement",null,0]
["Minimum Guarantee",null,0]
["Program Related Requirements:"]
["Safe Schools",null,812069]
["Lab School Discretionary",null,0]
["8.  Discretionary Local Effort (WFTE share)",null,null,8917231,null,"x",0,0]
["9.  Discretionary Millage Compression Allocation"]
[".748 mills (UFTE share)",null,null,1491181,null,"x",0,0]
["10.  Proration to Funds Available (WFTE share)",null,null,-362330,null,"x",0,0]
["11.  Discretionary Lottery (WFTE share)",null,null,266713,null,"x",0,0]
["12.  Instructional Materials Allocation (UFTE share)",null,null,2085356,null,"x",0,0]
["Dual Enrollment Instructional Materials Allocation (See footnote i below) "]
["13.  Student Transportation"]
["Enter",null,"All Riders",null,0," x",363,0]
["Enter",null,"ESE Student Riders",null,null," x",1372,0]
["14.  Teacher Salary Allocation (WFTE share)",null,null,4737310,null," x",0,0]
["15.  Additional Allocation (WFTE share)",null,null,96819,null," x",0,0]
["16.  Florida Teachers Lead Program Stipend"]
["17.  Food Service Allocation"]
["Total Funding for Calculating the Administrative fee of Charters with More Than 75% ESE Students.",{"$nulls":6},0]
[]
["NOTES:"]
["This tab of the worksheet is Set up to show estimated funding based on Unweighted FTE for charter schools with ESE populations of more that 75% so that "]
["the proper administrative fee can be estimated. It should not be necessary to enter data on this page."]