{"text_format":"2","workbook":"xls","n_sheets":5,"sheets":["All charter school calculator"," Detail 2020-21 Second FEFP","111-112-113 ADDITIONAL FUND","Transportation Per Student","75% or more ESE Calc"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":3,"defined_names":283,"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":111,"n_cols":8,"rows_kept":111,"cut":false,"hidden":false,"merged":[[104,0,104,7],[82,4,82,5],[7,4,7,5],[27,0,27,6],[49,6,49,7],[52,6,52,7],[29,0,29,1],[34,0,34,1],[30,0,30,1],[40,2,40,3],[31,0,31,1],[38,0,46,1],[41,2,41,3],[39,2,39,3],[33,2,33,6],[42,2,42,3],[32,0,32,1],[33,0,33,1],[45,2,45,3],[32,2,32,6],[56,0,56,2],[85,0,85,1],[86,0,86,1],[29,2,29,6],[59,0,59,2],[57,0,57,2],[37,0,37,1],[47,2,47,3],[58,0,58,2],[36,5,36,6],[34,2,34,6],[36,0,36,3],[35,0,35,3],[54,0,54,2],[35,5,35,6],[47,0,47,1],[47,4,47,6],[111,0,111,7],[89,0,89,6],[101,0,101,7],[109,0,109,7],[99,0,99,7],[107,0,107,7],[105,0,105,7],[108,0,108,7],[92,0,92,7],[91,0,91,5],[102,0,102,7],[110,0,110,7],[90,0,90,5],[85,2,85,3],[97,0,97,7],[95,0,95,7],[106,0,106,7],[103,0,103,7],[94,0,94,7],[87,4,87,6],[88,4,88,6],[65,0,65,2],[84,0,84,1],[79,0,79,1],[83,4,83,5],[84,4,84,5],[85,4,85,5],[84,2,84,3],[78,4,78,7],[66,0,66,2],[93,0,93,7],[79,2,79,4],[80,2,80,4],[82,0,82,1],[82,2,82,3],[81,0,81,2],[81,4,81,7],[88,0,88,2],[83,0,83,1],[83,2,83,3],[87,0,87,2],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[44,2,44,3],[55,0,55,2],[46,2,46,3],[37,2,37,3],[23,2,23,3],[19,2,19,3],[24,2,24,3],[23,4,23,5],[31,2,31,6],[25,2,25,3],[30,2,30,6],[16,4,16,5],[17,4,17,5],[21,4,21,5],[21,2,21,3],[18,2,18,3],[22,2,22,3],[19,4,19,5],[20,4,20,5],[22,4,22,5],[17,2,17,3],[10,2,10,3],[26,0,26,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,2,20,3],[14,2,14,3],[16,0,16,1],[11,2,11,3],[12,2,12,3],[13,2,13,3],[15,0,15,1],[15,2,15,3],[16,2,16,3],[10,4,10,5],[11,4,11,5],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,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],[3,2,3,3],[8,0,8,1],[8,4,8,5],[9,4,9,5],[9,0,9,1],[8,2,8,3],[9,2,9,3],[20,0,20,1],[25,0,25,1],[18,4,18,5],[60,4,60,6],[24,4,24,5],[25,4,25,5],[26,4,26,5],[53,6,53,7],[49,0,49,1],[26,2,26,3],[100,0,100,7],[96,0,96,7],[48,0,48,7],[77,0,77,7],[50,6,50,7],[80,0,80,1],[78,0,78,2],[98,0,98,7],[72,2,72,3],[60,0,60,2],[28,0,28,1],[28,2,28,6],[38,2,38,3],[75,2,75,3],[43,2,43,3],[52,0,52,1],[51,0,51,7],[68,0,68,2],[69,0,69,2],[67,0,67,2],[72,4,72,7],[76,2,76,6],[73,2,73,3],[74,2,74,3],[61,0,61,6],[71,0,71,7],[72,0,72,1],[64,0,64,2],[63,0,63,2],[70,0,70,2]],"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 2020-21 FEFP Second Calculation"]
["School District: ",null,"Alachua"]
["1.   2020-21 FEFP State and Local Funding"]
["Base Student Allocation",null,4319.49,null,"District Cost Differential: ",null,0.9798]
[{"$nulls":7},"2020-21"]
[{"$nulls":4},"Program",null,"Weighted FTE","Base Funding"]
["Program",null,"Number of FTE",null,"Cost Factor",null,"(2) x (3)","(WFTE x BSA x DCD)"]
["(1)",null,"(2)",null,"(3)",null,"(4)","(5)"]
["101 Basic K-3",null,null,null,1.124,null,0,0]
["111 Basic K-3 with ESE Services",null,null,null,1.124,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.012,null,0,0]
["113 Basic 9-12 with ESE Services",null,null,null,1.012,null,0,0]
["254 ESE Level 4 (Grade Level PK-3)",null,null,null,3.644,null,0,0]
["254 ESE Level 4 (Grade Level 4-8)",null,null,null,3.644,null,0,0]
["254 ESE Level 4 (Grade Level 9-12)",null,null,null,3.644,null,0,0]
["255 ESE Level 5 (Grade Level PK-3)",null,null,null,5.462,null,0,0]
["255 ESE Level 5 (Grade Level 4-8)",null,null,null,5.462,null,0,0]
["255 ESE Level 5 (Grade Level 9-12)",null,null,null,5.462,null,0,0]
["130 ESOL (Grade Level PK-3)",null,null,null,1.184,null,0,0]
["130 ESOL (Grade Level 4-8)",null,null,null,1.184,null,0,0]
["130 ESOL (Grade Level 9-12)",null,null,null,1.184,null,0,0]
["300 Career Education (Grades 9-12)",null,null,null,1.012,null,0,0]
["Totals",null,0,null,null,null,0,0]
["Letters in Parentheses Refer to Notes at Bottom of Worksheet:"]
["Additional FTE (a)",null,"Number of FTE\nCharter schools should contact their school district sponsor regarding eligible FTE. Please note that “Number of FTE” is NOT equivalent to number of students enrolled in these courses or programs. Please refer to footnote (a) below.",{"$nulls":4},"2020-21                             Base Funding                          (WFTE x BSA x DCD)"]
["Advanced Placement",{"$nulls":6},0]
["International Baccalaureate",{"$nulls":6},0]
["Advanced International Certificate",{"$nulls":6},0]
["Industry Certified Career Education",{"$nulls":6},0]
["Early High School Graduation",{"$nulls":6},0]
["Small District ESE Supplement",{"$nulls":6},0]
["Total Additional FTE",null,null,null,0,"Additional Base Funds",null,0]
["Total Funded Weighted FTE ",null,null,null,0,"Total Base Funding",null,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 and 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 and 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 ESE Guarantee",null,null,0]
["3A. Divide school's Unweighted FTE (UFTE) total computed in Section 1, cell C27 above by the district's total UFTE to obtain school's"]
[" UFTE share.           Charter School UFTE: ",null,0,"÷",null,"District's Total UFTE:",29537.559999999998]
[{"$nulls":5},"=",0]
["3B. Divide school's Weighted FTE (WFTE) total computed in Section 1, cell E37 above by the district's total WFTE to obtain school's"]
[" WFTE share.          Charter School WFTE: ",null,0,"÷",null,"District's Total WFTE:",32091.34]
[{"$nulls":5},"=",0]
["4.   Supplemental Academic Instruction (UFTE share)",null,null,"(b)",8394585,"x",0,0]
["5.   Discretionary Millage Compression Allocation"]
[".748 Mills (UFTE share)",null,null,"(b)",4180746,"x",0,0]
["6.   Digital Classrooms Allocation (UFTE share)",null,null,"(b)(d)",107250,"x",0,0]
["7.   Safe Schools Allocation (UFTE share)",null,null,"(b)",2261291,"x",0,0]
["8.   Instructional Materials Allocation (UFTE share)",null,null,"(b)",2255776,"x",0,0]
["Dual Enrollment Instructional Materials Allocation",null,null,"(e)"]
["ESE Applications Allocation: "]
["Charter schools should contact their school district sponsor regarding eligibility and distribution of ESE Applications funds."]
["9.  Mental Health Assistance Allocation (UFTE share)",null,null,"(b)",1060085,"x",0,0]
["10.  Total Funds Compression Allocation (UFTE share)",null,null,"(b)",1088162,"x",0,0]
["11.  Sparsity Supplement (WFTE share)",null,null,"(c)",0,"x",0,0]
["12.  Reading Allocation (WFTE share)",null,null,"(c)",1313090,"x",0,0]
["13.  Discretionary Local Effort (WFTE share)",null,null,"(c)",12974099,"x",0,0]
["14.  Proration to Funds Available (WFTE share)\n      (from the 2020-21 FEFP Fourth Calculation)",null,null,"(c)",-523582,"x",0,0]
["15.  Discretionary Lottery (WFTE share)",null,null,"(c)",0,"x",0,0]
["16. Teacher Salary Increase Allocation",null,null,"(f)"]
["17.  Class Size Reduction Funds:"]
["Weighted FTE (not including Add-On)",null,"X          DCD         X",null,"Allocation factors"]
["PK - 3",0,0.9798,null,1301.57,"=",0]
["4-8",0,0.9798,null,887.8,"=",0]
["9-12",0,0.9798,null,889.95,"=",0]
["Total *",0,"Total Class Size Reduction Funds",{"$nulls":4},0]
["(*Total FTE should equal total in Section 1, column (4) and should not include any additional FTE from Section 1.)"]
["18.  Student Transportation",null,null,"(g)"]
["Enter All Adjusted Fundable Riders",{"$nulls":4}," x",404,0]
["Enter All Adjusted ESE Riders",{"$nulls":4}," x",1441,0]
["19.  Federally Connected Student Supplement",null,null,"(h)"]
["Impact Aid Student Type",null,"Number of Students",null,"Exempt Property Allocation",null,"Impact Aid Student Allocation","Total"]
["Military and Indian Lands",null,null,null,0,null,0,0]
["Civilians on Federal Lands",null,null,null,0,null,0,0]
["Students with Disabilities",{"$nulls":5},0,0]
["Total",{"$nulls":6},0]
["20.  Florida Teachers Classroom Supply Assistance Program",null,null,"(i)"]
["21.  Food Service Allocation",null,null,"(j)"]
["Total",{"$nulls":6},0]
["22.  Funding for the purpose of calculating the administrative fee for ESE charter schools.",{"$nulls":5},"(k)"]
["If you have more than a 75% ESE student population, please place a 1 in the following box:",{"$nulls":6},0]
["NOTES:"]
["(a) Additional FTE includes FTE earned through Advanced Placement, International Baccalaureate, Advanced International Certificate of Education, Industry Certified Career Education (CAPE), Early High School Graduation and the small district ESE Supplement, pursuant to s. 1011.62(1)(l-p), F.S. "]
["(b) District allocations multiplied by percentage from item 3A."]
["(c) District allocations multiplied by percentage from item 3B."]
["(d) The Digital Classroom Allocation is provided pursuant to s. 1011.62(12), F.S."]
["(e) School districts are required to pay for instructional materials used for the instruction of public high school students who are earning credit toward high school graduation under the dual enrollment program as provided in s. 1011.62(1)(i), F.S.  "]
["(f) 80 percent of each district’s Teacher Salary Increase Allocation, pursuant to section 1011.62, F.S., is for school districts and charter schools to provide a minimum base salary of $47,500 or the maximum amount achievable for full-time classroom teachers as defined in s. 1012.01(2)(a), F.S., including pre-kindergarten teachers funded through the FEFP but not including substitute teachers. The remaining 20 percent of the allocation, plus any remaining funds from the district's share of the 80 percent allocation, shall be used by the school districts as specified in s. 1011.62, F.S., to provide salary increases to full-time classroom teachers that did not receive an increase, full-time classroom teachers who received an increase of less than 2 percent, or other instructional personnel. \n\nThis allocation was calculated in the 2020-21 FEFP Second Calculation and will not be recalculated throughout the year. Charter schools should contact their sponsoring school district to determine the school's allocation amount. "]
["(g)  Numbers entered here will be multiplied by the district level transportation funding per rider. \"All Adjusted Fundable Riders\" should include both basic and ESE Riders. \"All Adjusted ESE Riders\" should include only ESE Riders."]
["(h) The Federally Connected Student Supplement provides additional funding for students on federal lands that receive Section 8003 impact aide pursuant to s. 1011.62(13), F.S. "]
["(i) Teacher Classroom Supply Assistance Program allocation pursuant to s. 1012.71, F.S., for certified teachers employed by a public school district or public charter school before September 1 of each year whose full-time or job-share responsibility is the classroom instruction of students in prekindergarten through grade 12, including full-time media specialists and certified school counselors serving students in prekindergarten through grade 12, who are funded through the FEFP."]
["(j) Funding based on student eligibility and meals provided, if participating in the National School Lunch Program. "]
["(k) Consistent with s. 1002.33(20)(a), F.S., 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. "]
[]
["Administrative fees:"]
["Administrative fees charged by the school district pursuant to s. 1002.33(20)(a), F.S., shall be calculated based upon 5% of available funds from the FEFP and categorical funding for which charter students may be eligible. 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 charter schools within a charter school system that meets the requirements in s. 1002.33(20)(a)2.a.(II), F.S., do the same calculation based for up to and including 500 students. "]
["For high performing charter schools, administrative fees charged by the school district shall be calculated based upon 2% of available funds from the FEFP and  categorical funding for which charter students may be eligible. 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%.  "]
["Other:"]
["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 2020-21 Second FEFP","index":1,"n_rows":77,"n_cols":44,"rows_kept":77,"cut":false,"hidden":false,"merged":[[2,31,4,31],[0,0,0,34],[2,36,4,36],[2,41,5,41]],"flags":["formulas_cached_only"]}
["Charter School Worksheet DATA"]
[null,"District","District Cost Differential","Unweighted FTE","Weighted FTE Funded","Declining Enrollment Supplement","Sparsity Supplement","Reading Allocation","Teacher Salary Increase","State Funded Discretionary Contribution","Discretionary Tax Compression 0.748 mills","Safe Schools Allocation","Supplemental Academic Instruction","ESE Guaranteed Allocation Dollars","0.748 Basic Discretionary Revenue","Total Disc.","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)","Digital Classrooms Allocation","Mental Health Assistance Allocation","Total Funds Compression and Hold Harmless Allocation","Federally Connected Student Supplement Exempt Property Allocation","Exempt Property Allocation Per Military and Indian Land Student","Federally Connected Military and Indian Land Students","Federally Connected Civilian Students","Federally Connected Students with Disabilities ",null,null,"k-3","4-8","9-12",null,null,"k-3","4-8","9-12",null,null,"All Qualifying Students","Qualifying Students With Disabilities BSA"]
[1,"Alachua",0.9798,29537.559999999998,32091.34,0,0,1313090,4930819,0,4180746,2261291,8394585,12000549,12974099,12974099,-523582,0,2413997,127414,30807,2255776,107250,1060085,1088162,0,0,0,0,0,null,"Prorated Class Size Allocation Factors ",1301.57,887.8,889.95,null,"Class Size Allocation Factors ",1301.57,887.8,889.95,null,"Federally Connected Student Funding",130,454]
[2,"Baker",0.9737,4865.9400000000005,5245.139999999999,0,791924,309602,800896,0,2010996,473970,1780518,1366564,815059,815059,-93635,0,383957,14813,5288,363856,101194,258162,226850,0,0,0,0,0]
[3,"Bay",0.971,24606.299999999996,28189.429999999997,0,0,1157965,4292391,0,776821,1829537,6993398,8370695,13513936,13513936,-440245,0,1957289,80922,34770,1841597,106039,899800,281348,581027,457.14,932,678,128]
[4,"Bradford",0.9689,2934.96,3171.5000000000005,0,1151157,232087,481878,0,902823,416280,927520,1362323,801734,801734,-58896,0,239033,11579,5641,221813,100720,195397,147717,0,0,0,0,0]
[5,"Brevard",0.9877,73689.43,81376.97,0,0,3177604,12604346,0,7794868,4479956,20220317,29848549,35002158,35002158,-1318727,0,6187308,465641,102617,5619050,118087,2495191,829011,2250563,663.3,1396,3994,171,null,"Proration Reduction",0]
[6,"Broward",1.0179,268588.65,296452.56999999995,0,0,11613061,47321019,0,0,16113860,59437327,105876203,162798813,162798813,-4721729,0,21395977,921279,306036,20168662,165924,8830168,1351256,0,0,0,0,0]
[7,"Calhoun",0.9361,2101.5200000000004,2301.56,0,1795749,197094,337861,0,881377,344654,473685,785138,339149,339149,-44140,0,173575,12050,3285,158240,100516,168307,61256,0,0,0,0,0]
[8,"Charlotte",0.9879,15621.029999999999,17149.879999999997,0,0,760563,2656855,0,0,1088351,3465990,6343091,14881557,14881557,-272292,0,1312440,121809,24839,1165792,103834,607744,0,0,0,0,0,0]
[9,"Citrus",0.9478,15419.86,16690.54,0,2159068,717770,2480738,0,557274,1075478,3385780,7371311,8398295,8398295,-271524,0,1252724,53556,16110,1183058,103785,601205,524627,0,0,0,0,0]
[10,"Clay",0.9895,39098.55,42907.869999999995,0,0,1732771,6658042,0,12982674,2111493,10206056,14757713,9725055,9725055,-721905,0,3333972,165384,62739,3105849,109596,1370854,770464,0,0,2869,1729,505]
[11,"Collier",1.05,47797.31,53672.99,0,0,2262382,8837692,0,0,2579664,10947837,23080787,74294482,74294482,-893373,0,4036139,289578,51128,3695433,111731,1653597,0,0,0,0,0,0]
[12,"Columbia",0.9498,10188.640000000001,10890.54,0,1447188,509136,1622091,0,3512941,837628,3872539,4173194,2404419,2404419,-188845,0,839754,38006,12991,788757,102501,431170,226703,0,0,0,0,0]
[13,"Miami-Dade",1.0142,344920.54,380775.26999999996,0,0,14829877,60560032,0,0,23111781,115693446,134948126,253613968,253613968,-6128623,0,26950293,907150,310576,25732567,184659,11311249,13934730,0,0,569,0,113]
[14,"De Soto",0.9761,4875.49,5162.87,0,775554,307022,790277,0,1365674,511921,1913512,2051247,1465894,1465894,-91957,0,399821,25780,5205,368836,101197,258472,0,0,0,0,0,0]
[15,"Dixie",0.9393,2249.6400000000003,2407.7800000000007,0,1150742,201176,354662,0,874075,358965,498294,796644,432470,432470,-43943,0,186587,8583,3810,174194,100552,173122,0,0,0,0,0,0]
[16,"Duval",1.0081,132228.39,144748.01,0,0,5675073,22882843,0,19647816,8994880,33233207,51352129,57147414,57147414,-2381869,0,10880125,398697,167221,10314207,132455,4397933,1129737,406165,138.08,2640,603,408]
[17,"Escambia",0.9759,39828.23,43634.52,0,0,1737556,6677736,0,7497664,2846582,10647293,14927415,15633726,15633726,-719638,0,3156137,89720,47950,3018467,109776,1394571,694248,1222592,473.14,1895,1378,195]
[18,"Flagler",0.9572,12818.349999999999,13782.63,0,1260753,617689,2068848,0,0,873133,2765998,6542818,7899950,7899950,-222666,0,1099241,125482,15510,958249,103146,516646,456329,0,0,0,0,0]
[19,"Franklin",0.9346,1247.82,1358.75,0,60281,163387,199140,0,0,324053,275872,503250,1655296,1655296,-22846,0,99831,3147,1821,94863,100306,140559,104380,0,0,0,0,0]
[20,"Gadsden",0.9541,4754,5200.070000000001,0,833498,304046,778031,0,1545716,523582,1370620,1586336,1215292,1215292,-91126,0,376519,11672,5782,359065,101167,254523,0,0,0,0,0,0]
[21,"Gilchrist",0.9546,2801.41,3151.93,0,2123543,229647,471837,0,955421,376083,624769,1111239,671569,671569,-58402,0,246406,16956,4242,225208,100687,191057,0,0,0,0,0,0]
[22,"Glades",0.9874,1815.97,1932.3699999999997,0,1099208,187702,299211,0,505257,333705,447768,622095,549430,549430,-37238,0,149717,4216,2785,142716,100446,159026,0,228862,1346.25,170,0,69]
[23,"Gulf",0.9434,1856,2059.98,0,1271621,189050,304756,0,0,343415,374230,409798,1455240,1455240,-35239,0,147096,5442,2681,138973,100455,160327,0,0,0,0,0,0]
[24,"Hamilton",0.9247,1554.5500000000002,1677.6499999999999,0,1060934,174111,243274,0,167472,339853,335228,496501,735373,735373,-30824,0,121300,1935,1356,118009,100381,150529,117715,0,0,0,0,0]
[25,"Hardee",0.9621,5031.1900000000005,5353.1900000000005,0,737511,311244,807656,0,1614509,496428,1108556,1796051,1307499,1307499,-91660,0,404542,22014,4913,377615,101235,263533,231284,0,0,0,0,0]
[26,"Hendry",0.9998,8643.97,9303.34,0,1850457,469419,1458632,0,3177783,676429,2228020,2385352,1842471,1842471,-190861,0,718066,50326,7874,659866,102122,380962,447076,0,0,0,0,0]
[27,"Hernando",0.9674,23360.16,25301,0,2297516,1047627,3838288,0,5327752,1444289,5579297,10706177,8239330,8239330,-424890,0,1940903,90620,27690,1822593,105734,859295,608864,0,0,0,0,0]
[28,"Highlands",0.9556,12145.74,12982.779999999999,0,2932535,587725,1945528,0,2918864,970105,2433131,4262965,4135138,4135138,-218396,0,982408,61175,13752,907481,102981,494783,603344,0,0,0,0,0]
[29,"Hillsborough",1.0045,223019.25000000003,245299.42,0,0,9503814,38640276,0,41762585,11052925,52178801,84780033,87761470,87761470,-4025601,0,18281767,503083,250173,17528511,154739,7348987,2984454,330944,55.15,4628,2746,569]
[30,"Holmes",0.9411,3095.0400000000004,3267.88,0,2570526,232183,482276,0,1410657,391385,673259,1057906,386891,386891,-62636,0,252135,16895,3370,231870,100760,200601,0,0,0,0,0,0]
[31,"Indian River",1.0006,17498.87,19125.879999999997,0,0,844199,3001067,0,0,1156354,3865124,6254238,14955759,14955759,-304600,0,1405976,67933,21094,1316949,104295,668781,1018072,0,0,0,0,0]
[32,"Jackson",0.9349,6021.69,6619.139999999999,0,3486840,350793,970422,0,2255063,515124,1210368,2322882,1242187,1242187,-119744,0,491944,26650,7729,457565,101478,295728,596571,0,0,0,0,0]
[33,"Jefferson",0.9519,774.03,849.29,0,605879,145804,126777,0,0,308615,321359,451735,522117,522117,-17587,0,63610,2047,1277,60286,100190,125159,0,0,0,0,0,0]
[34,"Lafayette",0.9259,1185.21,1291.95,0,952421,160580,187587,0,468881,299970,205700,361051,219462,219462,-24485,0,107092,15791,1533,89768,100291,138524,0,0,0,0,0,0]
[35,"Lake",0.9805,45546.729999999996,50075.579999999994,0,0,1985845,7699585,0,6770521,2718487,10562711,16436415,19682028,19682028,-806379,0,3913362,203613,57095,3652654,111179,1580445,1751506,0,0,0,0,0]
[36,"Lee",1.0203,96061.62999999999,104904.76999999999,0,0,4193377,16784827,0,0,4972553,22967228,39236687,69357267,69357267,-1723332,0,7973928,319516,86519,7567893,123578,3222374,0,0,0,375,0,37]
[37,"Leon",0.9742,33925.35,37141.21,0,0,1493696,5674112,0,5206863,2664009,9800029,18240693,14496411,14496411,-613154,0,2647261,66523,40856,2539882,108327,1202705,374659,0,0,0,0,0]
[38,"Levy",0.9538,5456.34,5953.0700000000015,0,3382292,331353,890414,0,1505459,572171,1262777,2081309,1663470,1663470,-107681,0,444955,24190,7438,413327,101339,277352,0,0,0,0,0,0]
[39,"Liberty",0.9361,1277.8,1447.1500000000003,0,1026074,166618,212437,0,529801,306941,265623,507961,212318,212318,-28013,0,103496,5910,2079,95507,100314,141533,0,0,0,0,0,0]
[40,"Madison",0.9298,2463.3500000000004,2607.65,0,1144570,207385,380218,0,845791,371722,665982,1076102,584866,584866,-47573,0,206854,13680,3069,190105,100605,180068,0,0,0,0,0,0]
[41,"Manatee",0.9873,50268.49,54688.89000000001,0,0,2172371,8467243,0,0,2991041,12661608,20648664,31871620,31871620,-868184,0,4176730,174973,61423,3940334,112338,1733920,1219497,0,0,0,0,0]
[42,"Marion",0.9489,43770.280000000006,48743.90000000001,0,0,1877402,7253281,0,9187382,2741647,13253353,15610393,16233545,16233545,-789261,0,3528866,111871,51026,3365969,110743,1522703,2024037,0,0,0,0,0]
[43,"Martin",1.0165,18924.4,21158.29,0,0,934506,3372731,0,0,1196020,4148847,7028999,18193434,18193434,-337050,0,1676037,197286,21737,1457014,104645,715116,0,0,0,0,0,0]
[44,"Monroe",1.0478,8492,9294.179999999998,0,0,486068,1527155,0,0,740798,1859079,3435250,23157857,23157857,-156436,0,687492,18420,11996,657076,102084,376023,0,916174,1768.68,393,250,40]
[45,"Nassau",0.99,12620.130000000003,13675.960000000001,0,2871820,630890,2123180,0,0,854848,2798214,3771699,7914205,7914205,-224115,0,1078520,49549,14994,1013977,103097,510203,0,0,0,0,0,0]
[46,"Okaloosa",0.9933,32692.38,35868.560000000005,0,0,1472559,5587122,0,3757662,1935742,9077565,14112739,15229473,15229473,-597087,0,2762033,115288,41822,2604923,108024,1162629,0,1395860,179.08,5743,4103,804]
[47,"Okeechobee",0.9787,6673.41,7135.57,0,656365,381099,1095146,0,1432247,619504,2136007,3002444,2443542,2443542,-124278,0,555251,23891,11286,520074,101638,316912,22206,0,0,0,0,0]
[48,"Orange",1.0076,209400.11000000002,236680.98,0,0,9201901,37397733,0,1185205,13026368,49268128,58999730,120430544,120430544,-3690813,0,17172479,979745,177426,16015308,151396,6906312,2190562,0,0,0,0,0]
[49,"Osceola",0.989,71315.17,78059.35,0,0,3056613,12106399,0,17047178,3768698,15701357,21512975,24370908,24370908,-1265140,0,6145009,308329,68044,5768636,117504,2418018,3650956,0,0,0,0,0]
[50,"Palm Beach",1.0413,194621.41,219511.35000000003,0,0,8824578,35844836,0,0,11352050,43553924,72991118,159365910,159365910,-3581339,0,15507962,292215,234142,14981605,147769,6425947,9493743,0,0,102,51,17]
[51,"Pasco",0.9833,78126.13,86329.89000000001,0,0,3349532,13311929,0,20265918,4162569,21009029,31295242,25107835,25107835,-1432806,0,6627468,279078,94509,6253881,119176,2639401,1325963,0,0,0,0,0]
[52,"Pinellas",0.9981,98219.01999999999,108933.67999999998,0,0,4257862,17050220,0,0,6577383,23555089,44824404,71377817,71377817,-1751018,0,7882643,424635,108066,7349942,124107,3292497,4711321,0,0,169,0,18]
[53,"Polk",0.9687,109369.52,118751.18,0,0,4498202,18039354,0,31356241,5766120,28102735,42436118,32163344,32163344,-1967498,0,9440151,551157,119840,8769154,126844,3654932,4461107,0,0,0,0,0]
[54,"Putnam",0.9593,10555.710000000001,11307.12,0,3222210,528305,1700984,0,2615599,802545,3103505,3516291,3514985,3514985,-197714,0,843589,36312,16532,790745,102591,443101,601879,0,0,0,0,0]
[55,"St. Johns",1.0079,44624.05999999999,50000.83000000001,0,0,2035255,7902935,0,1419938,2243816,8922832,15025385,24496648,24496648,-795486,0,3875438,118425,56390,3700623,110953,1550454,28338,0,0,0,0,0]
[56,"St. Lucie",1.001,41813.64,45112.75,0,0,1835670,7081531,0,5295279,2336602,10397523,18112577,18989254,18989254,-753856,0,3562119,234040,40935,3287144,110263,1459105,636356,0,0,0,0,0]
[57,"Santa Rosa",0.974,29249.51,32122.000000000004,0,0,1307136,4906313,0,8061457,1547424,8382952,11106831,8926024,8926024,-536376,0,2557627,190102,31822,2335703,107179,1050722,334032,735773,233.02,2468,1379,294]
[58,"Sarasota",1.0068,44148.969999999994,49734.82,0,0,2022955,7852311,0,0,2743212,9028499,23354499,49788094,49788094,-802530,0,3726847,262212,54599,3410036,110836,1535012,0,0,0,0,0,0]
[59,"Seminole",0.9955,67675.62,74112.95000000001,0,0,2926251,11569887,0,9687765,3756086,16231041,20219256,29616907,29616907,-1189442,0,5336153,122029,76257,5137867,116611,2299719,2917335,0,0,0,0,0]
[60,"Sumter",0.9687,8786.52,9445.579999999998,0,0,463644,1434867,0,0,720815,1786579,4119014,11029628,11029628,-148062,0,714176,34506,10625,669045,102157,385596,0,0,0,0,0,0]
[61,"Suwannee",0.9365,5887.3,6285.020000000001,0,2272993,339274,923014,0,1896770,553032,1235236,1487494,1522446,1522446,-107359,0,470620,18438,7263,444919,101445,291360,246743,0,0,0,0,0]
[62,"Taylor",0.9301,2655.34,2946.480000000001,0,1197535,219423,429761,0,376926,418283,582698,1107987,1165230,1165230,-51118,0,214926,10903,3831,200192,100652,186309,0,0,0,0,0,0]
[63,"Union",0.9595,2350.97,2519.75,0,1156621,207123,379137,0,1150894,352160,524520,698556,214501,214501,-47060,0,193229,7532,3189,182508,100577,176416,160037,0,0,0,0,0]
[64,"Volusia",0.9665,62589.26,68623.45999999999,0,0,2642195,10400835,0,4331177,3884130,16959540,22836789,32019210,32019210,-1085560,0,5087465,237076,84258,4766131,115362,2134393,3230081,0,0,0,0,0]
[65,"Wakulla",0.9549,5124.93,5573.98,0,727437,317809,834674,0,1840004,501865,960934,1957186,1136428,1136428,-95836,0,445402,34495,7833,403074,101258,266580,58373,0,0,0,0,0]
[66,"Walton",0.9825,10570.879999999997,11366.019999999999,0,0,540506,1751196,0,0,758825,2158804,3512277,16948137,16948137,-179149,0,987686,99454,10003,878229,102594,443594,0,0,0,0,0,0]
[67,"Washington",0.9412,3472.8,3879.9500000000003,0,2279592,254147,572667,0,1276810,412350,993938,856452,740137,740137,-70240,0,311947,23489,5640,282818,100852,212879,12908,0,0,0,0,0]
[69,"FAMU Lab School",0.9742,593.68,617.62,0,492512,137926,94355,253679,91118,272559,323167,59735,0,null,-13693,0,48031,3237,205,44589,100146,119297,0,0,null,0,0,0]
[70,"FAU Lab School",1.0413,1277.07,1316.46,0,634785,167233,214970,1045729,0,298528,331570,140494,0,0,-27487,0,300842,188570,531,111741,100313,141510,56936,0,0,0,0,0]
[71,"FAU St. Lucie",1.001,1460.7400000000002,1550.2800000000002,0,0,174130,243354,663380,184988,305507,432058,216914,0,0,-27262,0,113083,0,1099,111984,100358,147480,10879,0,0,0,0,0]
[72,"FSU Lab - Broward",1.0179,711.68,770.0799999999999,0,0,144868,122923,431371,0,277043,148321,172642,0,0,-14679,0,53842,4,644,53194,100175,123132,46348,0,0,0,0,0]
[73,"FSU Lab - Leon",0.9742,1803.6100000000001,1910.2099999999998,0,1091877,185908,291825,770683,276818,318536,310775,311580,0,0,-35416,0,159498,16848,733,141917,100443,158624,0,0,0,0,0,0]
[74,"UF Lab School",0.9798,1217.7099999999998,1276.97,0,928412,162674,196206,534867,172355,296272,316347,430027,0,0,-26107,0,119805,7356,721,111728,100299,139580,0,0,0,0,0,0]
[75,"Virtual School",1,38208.329999999994,39310.409999999996,0,0,1612862,6164549,21852872,337762,0,0,841239,0,0,-728283,0,2933830,28287,2634,2902909,0,0,0,0,0,0,0,0]
[null,"Total",null,2890177.27,3186169.9800000004,0,55500000,130000000,500000000,25552581,263201637,180000000,723869528,1092394272,1653000725,1653000725,-51937596,0,236574333,10590529,3193706,222790098,8000000,100000000,68000000,8067960,null,24349,16911,3368]

{"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":77,"n_cols":12,"rows_kept":77,"cut":false,"hidden":false,"merged":[[1,1,1,11],[2,1,2,11],[3,3,3,5],[3,7,3,9],[0,0,0,11]],"flags":["formulas_cached_only"]}
["FLORIDA DEPARTMENT OF EDUCATION"]
[null,"2020-21 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",3297503,8170.09,404,null,552256,383.2,1441,null,1845]
[null,2,"Baker",1242238,2872.9400000000005,432,null,121526,78.71000000000001,1544,null,1976]
[null,3,"Bay",2858066,7243.860000000001,395,null,665739,472.55,1409,null,1804]
[null,4,"Bradford",565558,1329.92,425,null,89849,59.17,1518,null,1943]
[null,5,"Brevard",9849368,24710.52,399,null,1325366,931.23,1423,null,1822]
[null,6,"Broward",30403041,77464.82,392,null,2991614,2134.71,1401,null,1793]
[null,7,"Calhoun",384837,934.0099999999999,412,null,44780,30.44,1471,null,1883]
[null,8,"Charlotte",2428930,6052.620000000001,401,null,871203,607.99,1433,null,1834]
[null,9,"Citrus",3621384,8788.710000000001,412,null,237728,161.58,1471,null,1883]
[null,10,"Clay",5921044,14076.449999999999,421,null,1596868,1063.1899999999998,1502,null,1923]
[null,11,"Collier",6697116,16886.07,397,null,816522,576.57,1416,null,1813]
[null,12,"Columbia",1813733,4145.26,438,null,318719,204,1562,null,2000]
[null,13,"Miami-Dade",15848217,43197.05,367,null,3034060,2316.0299999999997,1310,null,1677]
[null,14,"DeSoto",652192,1529.89,426,null,177522,116.62,1522,null,1948]
[null,15,"Dixie",494884,1157.56,428,null,25986,17.02,1527,null,1955]
[null,16,"Duval",15730752,42166.61,373,null,4313279,3237.9700000000003,1332,null,1705]
[null,17,"Escambia",7134197,17763.59,402,null,1247076,869.61,1434,null,1836]
[null,18,"Flagler",2288595,5746.24,398,null,324560,228.22,1422,null,1820]
[null,19,"Franklin",280997,689.1,408,null,51962,35.69,1456,null,1864]
[null,20,"Gadsden",1190234,2805.36,424,null,258084,170.36,1515,null,1939]
[null,21,"Gilchrist",476224,1093.5700000000002,435,null,15663,10.069999999999999,1555,null,1990]
[null,22,"Glades",270537,642.5,421,null,1500,1,1500,null,1921]
[null,23,"Gulf",284848,684,416,null,35685,24,1487,null,1903]
[null,24,"Hamilton",444812,1061.3600000000001,419,null,18987,12.690000000000001,1496,null,1915]
[null,25,"Hardee",1042931,2350.02,444,null,87981,55.52,1585,null,2029]
[null,26,"Hendry",1354584,3189.39,425,null,183802,121.2,1517,null,1942]
[null,27,"Hernando",5088720,11358.099999999999,448,null,171594,107.25999999999999,1600,null,2048]
[null,28,"Highlands",2139197,5298.159999999999,404,null,493470,342.28,1442,null,1846]
[null,29,"Hillsborough",27669916,66983.09,413,null,5066245,3434.71,1475,null,1888]
[null,30,"Holmes",696822,1657.2,420,null,6007,4,1502,null,1922]
[null,31,"Indian River",2466266,6117.72,403,null,386503,268.5,1439,null,1842]
[null,32,"Jackson",1182502,2849.52,415,null,283762,191.5,1482,null,1897]
[null,33,"Jefferson",245325,535.5,458,null,13085,8,1636,null,2094]
[null,34,"Lafayette",201636,462.12,436,null,0,0,0,null,436]
[null,35,"Lake",7323764,18096.179999999997,405,null,1607944,1112.68,1445,null,1850]
[null,36,"Lee",21327999,53478.280000000006,399,null,3201357,2248.06,1424,null,1823]
[null,37,"Leon",4132055,10339.140000000001,400,null,335040,234.78,1427,null,1827]
[null,38,"Levy",1172647,2631.57,446,null,172655,108.51,1591,null,2037]
[null,39,"Liberty",204258,462.47,442,null,41254,26.16,1577,null,2019]
[null,40,"Madison",492276,1184.48,416,null,38614,26.02,1484,null,1900]
[null,41,"Manatee",6530547,16110.809999999998,405,null,598640,413.59999999999997,1447,null,1852]
[null,42,"Marion",8490372,20237.64,420,null,1987343,1326.64,1498,null,1918]
[null,43,"Martin",2593409,6112.24,424,null,233422,154.07,1515,null,1939]
[null,44,"Monroe",887896,2230.66,398,null,167823,118.08,1421,null,1819]
[null,45,"Nassau",2825112,6303.920000000001,448,null,352764,220.45,1600,null,2048]
[null,46,"Okaloosa",5466612,13503.17,405,null,1255987,868.8599999999999,1446,null,1851]
[null,47,"Okeechobee",1386791,3314.91,418,null,175523,117.5,1494,null,1912]
[null,48,"Orange",27653130,67855.75,408,null,2881910,1980.47,1455,null,1863]
[null,49,"Osceola",10146007,24656.92,411,null,2090137,1422.54,1469,null,1880]
[null,50,"Palm Beach",22927563,56114.41,409,null,5888731,4036.31,1459,null,1868]
[null,51,"Pasco",15092287,36723.83,411,null,2460055,1676.4299999999998,1467,null,1878]
[null,52,"Pinellas",10583299,27405.25,386,null,2701660,1959.2499999999998,1379,null,1765]
[null,53,"Polk",20757719,49556.53,419,null,3500633,2340.53,1496,null,1915]
[null,54,"Putnam",2161585,4940.2300000000005,438,null,337759,216.19,1562,null,2000]
[null,55,"St. Johns",9199608,20543.07,448,null,998631,624.52,1599,null,2047]
[null,56,"St. Lucie",8752801,22147.45,395,null,1591948,1128.11,1411,null,1806]
[null,57,"Santa Rosa",6123897,14713.699999999999,416,null,965542,649.7,1486,null,1902]
[null,58,"Sarasota",6100302,15362.039999999999,397,null,845551,596.33,1418,null,1815]
[null,59,"Seminole",10977880,26787.63,410,null,408594,279.23,1463,null,1873]
[null,60,"Sumter",1050659,2671.6200000000003,393,null,166577,118.61999999999999,1404,null,1797]
[null,61,"Suwannee",1220283,2812.54,434,null,136698,88.24000000000001,1549,null,1983]
[null,62,"Taylor",633557,1498.09,423,null,87946,58.24,1510,null,1933]
[null,63,"Union",465719,1073.9499999999998,434,null,15470,9.99,1549,null,1983]
[null,64,"Volusia",9729391,21779.41,447,null,1105318,692.94,1595,null,2042]
[null,65,"Wakulla",1458517,3178.26,459,null,215479,131.5,1639,null,2098]
[null,66,"Walton",2234553,5076.4400000000005,440,null,304100,193.48000000000002,1572,null,2012]
[null,67,"Washington",819208,1891.43,433,null,77036,49.81,1547,null,1980]
[null,null,"State",387188909,952806.94,406,null,62777124,43503.43000000001,1443,null,1849]

{"sheet":"75% or more ESE Calc","index":4,"n_rows":91,"n_cols":8,"rows_kept":91,"cut":false,"hidden":false,"merged":[[90,0,90,7],[87,0,87,6],[83,0,83,1],[83,2,83,3],[83,4,83,5],[81,0,81,1],[86,3,86,6],[82,0,82,1],[85,3,85,6],[84,0,84,1],[78,0,78,1],[78,2,78,4],[79,0,79,7],[89,0,89,7],[80,0,80,1],[80,2,80,3],[80,4,80,5],[88,0,88,7],[81,2,81,3],[81,4,81,5],[85,0,85,2],[82,2,82,3],[82,4,82,5],[86,0,86,2],[65,0,65,2],[69,0,69,7],[75,0,75,7],[76,0,76,2],[76,3,76,6],[77,0,77,1],[77,2,77,4],[71,2,71,3],[72,2,72,3],[73,2,73,3],[74,2,74,6],[66,0,66,2],[67,0,67,2],[68,0,68,2],[70,0,70,1],[70,2,70,3],[70,4,70,7],[59,0,59,2],[60,0,60,6],[61,0,61,6],[64,0,64,2],[62,0,62,2],[63,0,63,2],[54,0,54,5],[54,6,54,7],[55,0,55,2],[56,0,56,2],[57,0,57,2],[58,0,58,2],[51,0,51,5],[51,6,51,7],[52,0,52,7],[53,0,53,1],[53,3,53,5],[53,6,53,7],[48,0,48,1],[48,2,48,3],[48,4,48,6],[49,0,49,7],[50,0,50,1],[50,3,50,5],[50,6,50,7],[39,0,47,1],[39,2,39,3],[40,2,40,3],[41,2,41,3],[42,2,42,3],[43,2,43,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[47,2,47,3],[36,0,36,3],[36,5,36,6],[37,0,37,3],[37,5,37,6],[38,0,38,1],[38,2,38,3],[33,0,33,1],[33,2,33,6],[34,0,34,1],[34,2,34,6],[35,0,35,1],[35,2,35,6],[30,0,30,1],[30,2,30,6],[31,0,31,1],[31,2,31,6],[32,0,32,1],[32,2,32,6],[26,0,26,1],[26,2,26,3],[26,4,26,5],[27,0,27,6],[29,0,29,1],[29,2,29,6],[24,0,24,1],[24,2,24,3],[24,4,24,5],[25,0,25,1],[25,2,25,3],[25,4,25,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],[20,0,20,1],[20,2,20,3],[20,4,20,5],[21,0,21,1],[21,2,21,3],[21,4,21,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],[16,0,16,1],[16,2,16,3],[16,4,16,5],[17,0,17,1],[17,2,17,3],[17,4,17,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],[12,0,12,1],[12,2,12,3],[12,4,12,5],[13,0,13,1],[13,2,13,3],[13,4,13,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],[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],[5,4,5,5],[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,6,5,7],[5,0,5,1],[5,2,5,3]],"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 2020-21 FEFP Second Calculation"]
["School District: ",null,"Alachua"]
["1.   2020-21 FEFP State and Local Funding"]
["Base Student Allocation",null,4319.49,null,"District Cost Differential: ",null,0.9798]
[{"$nulls":7},"2020-21"]
[{"$nulls":4},"Program",null,"Weighted FTE","Base Funding"]
["Program",null,"Number of FTE",null,"Cost Factor",null,"(2) x (3)","(WFTE x BSA x DCD)"]
["(1)",null,"(2)",null,"(3)",null,"(4)","(5)"]
["101 Basic K-3",null,0,null,1,null,0,0]
["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]
[{"$nulls":7},"2020-21"]
[{"$nulls":7},"Base Funding"]
["Additional FTE (a)",null,"Number of FTE",{"$nulls":4},"(WFTE x BSA x DCD)"]
["Advanced Placement",{"$nulls":6},0]
["International Baccalaureate",{"$nulls":6},0]
["Advanced International Certificate",{"$nulls":6},0]
["Industry Certified Career Education",{"$nulls":6},0]
["Early High School Graduation",{"$nulls":6},0]
["Small District ESE Supplement",{"$nulls":6},0]
["Total Additional FTE",null,null,null,0,"Additional Base Funds",null,0]
["Total Funded Weighted FTE ",null,null,null,0,"Total Base Funding",null,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 ESE Guarantee",null,null,0]
["3A. Divide school's Unweighted FTE (UFTE) total computed "]
["in Section 1, cell C27 above:",null,0,"by district's total UFTE:",null,null,29537.559999999998]
["to obtain school's UFTE share.  ",{"$nulls":5},0]
["3B. Divide school's Weighted FTE (WFTE) total computed "]
["in Section 1, cell E38 above:",null,0,"by district's total WFTE:",null,null,32091.34]
["to obtain school's WFTE share. ",{"$nulls":5},0]
["4.   Supplemental Academic Instruction (UFTE share)",null,null,null,8394585,"x",0,0]
["5.   Discretionary Millage Compression Allocation (UFTE share)",null,null,null,4180746,"x",0,0]
["6.   Digital Classrooms Allocation (UFTE share)",null,null,null,107250,"x",0,0]
["7.   Safe Schools Allocation (UFTE share)",null,null,null,2261291,"x",0,0]
["8.   Instructional Materials Allocation (UFTE share)",null,null,null,2255776,"x",0,0]
["Dual Enrollment Instructional Materials Allocation",{"$nulls":6},0]
["ESE Applications Allocation: ",{"$nulls":6},0]
["9.  Mental Health Assistance Allocation (UFTE share)",null,null,null,1060085,"x",0,0]
["10.  Total Funds Compression Allocation (UFTE share)",null,null,null,1088162,"x",0,0]
["11.  Sparsity Supplement (WFTE share)",null,null,null,0,"x",0,0]
["12.  Reading Allocation (WFTE share)",null,null,null,1313090,"x",0,0]
["13.  Discretionary Local Effort (WFTE share)",null,null,null,12974099,"x",0,0]
["14.  Proration to Funds Available (WFTE share)",null,null,null,-523582,"x",0,0]
["15.  Discretionary Lottery (WFTE share)",null,null,null,0,"x",0,0]
["16.  Class size Reduction Funds:"]
["Weighted FTE (not including Add-On)",null,"X             DCD            X",null,"Allocation factors"]
["PK - 3",0,0.9798,null,1301.57,"=",0]
["4-8",0,0.9798,null,887.8,"=",0]
["9-12",0,0.9798,null,889.95,"=",0]
["Total *",0,"Total Class Size Reduction Funds",{"$nulls":4},0]
["(*Total FTE should equal total in Section 1, column (4) and should not include any additional FTE from Section 1.)"]
["17.  Student Transportation"]
["Enter All Adjusted Fundable Riders",null,0,null,null," x",404,0]
["Enter All Adjusted ESE Riders",{"$nulls":4}," x",1441,0]
["18.  Federally Connected Student Supplement (g)"]
["Impact Aide Student Type",null,"Number of Students",null,"Exempt Property Allocation",null,"Impact Aide Student Allocation","Total"]
["Military and Indian Lands",null,0,null,0,null,0,0]
["Civilians on Federal Lands",null,0,null,0,null,0,0]
["Students with Disabilities",null,0,null,null,null,0,0]
["Total",{"$nulls":6},0]
["19.  Florida Teachers Classroom Supply Assistance Program",{"$nulls":6},0]
["20.  Food Service Allocation",{"$nulls":6},0]
["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 than 75% so that "]
["the proper administrative fee can be estimated. It should not be necessary to enter data on this page."]