{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["*****","02_5YrWkPlan","EXPLANATIONS OF WORK PLAN"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":3,"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":"*****","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"02_5YrWkPlan","index":1,"n_rows":277,"n_cols":25,"rows_kept":277,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
["Union  SCHOOL DISTRICT - - FACILITIES FIVE-YEAR WORK PROGRAM"]
["Union   SCHOOL  DISTRICT - -  WORKSHEET "]
["This work program worksheet must be filled out completely and a paper copy signed and submitted to DOE, Office of Educational Facilities , and a copy submitted ",{"$nulls":8},"Last Revised",{"$nulls":14},"The application must be filled out completely and a paper copy signed and submitted to the SMART Schools Clearinghouse, and a copy submitted electronically by September 1, 1998, and all data accurate as of July 15, 1998."]
["electronically in digital format (email: janet.burns@fldoe.org), as you received it (not a fax), prior to October 1, 2002, and all data accurate as of July 15, 2002.",{"$nulls":8},"2002-10-21T08:59:22.750",{"$nulls":14},"The application must be filled out completely and a paper copy signed and submitted to the SMART Schools Clearinghouse, and a copy submitted electronically by September 1, 1998, and all data accurate as of July 15, 1998."]
["District: ====>",null,"Union","Date: ==>","2002-10-01",null,"For fiscal years","  2002-2003 through 2006-2007"]
[]
["Section 235.185 School district facilities work program; definitions; preparation, adoption, and amendment."]
[]
["(1)    DEFINITIONS"]
["(a)"]
["(b)"]
{"$rows_empty":7}
["(2)     PREPARATION OF TENTATIVE DISTRICT FACILITIES WORK PROGRAM"]
["(a)"]
[]
["1 .","A schedule of major repair and renovation projects necessary to maintain the educational plant and ancillary facilities"]
[null,"of the district."]
[null,null,null,"2002-03 ","2003-04 ","2004-05","2005-06","2006-07"]
[null,"Project","Location","Actual Budget","Projected Cost","Projected Cost","Projected Cost","Projected Cost","5 YEAR TOTAL"]
[]
[null,"Life Safety  Upgrades","Lake Butler Elementary",10310,10000,10000,10000,10000,50310]
[null,"Life Safety Upgrades","Lake Butler  Middle",10310,10000,10000,10000,10000,50310]
[null,"Life Safety Upgrades","Union County High",10310,10000,10000,10000,10000,50310]
[null,"HVAC Upgrades","Lake Butler Elementary",5000,5000,5000,5000,5000,25000]
[null,"HVAC Upgrades","Lake Butler Middle",5000,5000,5000,5000,5000,25000]
[null,"HVAC Upgrades","Union County High",5000,5000,5000,5000,5000,25000]
[null,"Covered Walkways","Union County High",25000,5000,5000,5000,5000,45000]
[null,"Replace Chillers","Lake Butler Middle",120000,0,0,0,0,120000]
[null,"Technology","County Wide",20000,20000,20000,20000,20000,100000]
[null,"General Maintenance","County Wide",194951,205000,210000,225000,250000,1084951]
[null,"Networking","County Wide",50000,50000,50000,50000,50000,250000]
[null,"Replace Cabinet tops","Lake Butler Middle",5000,5000,5000,5000,5000,25000]
[null,"Replace Carpet","Lake Butler Middle",20000,20000,20000,20000,20000,100000]
[null,"Paint Roof","Lake Butler Middle",35000]
[]
[]
[]
[]
[]
[]
[null,"Maintenance, Repair, and Renovation Totals",null,515881,350000,355000,370000,395000,1950881]
[null," Less projected PECO Maintenance Funds (235.435(1))",null,515881,500000,490000,475000,465000,2445881]
["1.","Union Total",null,0,-150000,-135000,-105000,-70000,-495000]
[]
["2 .","A schedule of capital outlay projects necessary to ensure the availability of satisfactory student stations for the"]
[null,"  projected student enrollment in K-12 programs."]
[null,null,null,"2002-03 ","2003-04 ","2004-05","2005-06","2006-07"]
[null,"Project Description",null,"Actual Budget","Projected Cost","Projected Cost","Projected Cost","Projected Cost","5 YEAR TOTAL"]
{"$rows_empty":9}
["2 .","Union Total"]
[]
[null,"THIS SCHEDULE SHALL CONSIDER:"]
[]
["2a.","Locations, capacities, and planned utilization rates of current educational facilities of the district. (Include both permanent and relocatable facilities)"]
[null,null,"2001-02 FISH Satisfactory","Actual 2001-02","Actual 2001-02","Actual 2001-02","New Stu Capacity to","Projected 2006-07","Projected 2006-07"]
[null,"Location","Student Stations","FISH Capacity ","CO-FTE ","Utilization","be added (removed)","CO-FTE ","Utilization"]
[null,"Lake Butler Elementary",1323,1539,811,0.53,null,821,0.53]
[null,"Lake Butler Middle ",860,928,686,0.74,null,703,0.76]
[null,"Union County High School",922,886,591,0.67,null,533,0.6]
[]
[]
["2a.","Union Total",3105,3353,2088,0.62,0,2057,0.61]
[]
["2b.","Proposed Location of Planned Facilities"]
[null,"None"]
[{"$nulls":6},"# of Units","Projected "]
["2c1.","Plans for the use and location of relocatable classroom facilities assigned student capacity.",null,null,null,"Number NOT meeting","projected","( increase ) /","Total age of all"]
[{"$nulls":5},"standards to be used","to be in use","decrease in # of","relocatables in"]
[null,"Location","Actual # of Units in 2001-02","Owner","Student Stations","as classroom space","in 2006-07","units by 2006-07","Column \"C\""]
[null,"Union County High School",2,"William Scottsman",20,0,0,0,2]
[]
[]
[]
[]
[]
["2c1.","Union Total",2,null,20,0,0,0,"Avg Age 1"]
[]
["2c2.","Number of relocatable classrooms clearly identified and scheduled for replacement in the school board adopted financially feasible 5-year district work program."]
[null,"Location","Total # Units to be replaced","2002-03 ","2003-04 ","2004-05","2005-06","2006-07","5 YEAR TOTAL"]
[null,"None"]
[]
[]
[]
["2c2.","Union Total",0,0,0,0,0,0,0]
[]
["2c3.","Plans for the use and location of leased facilities, relocatable units or permanent classrooms. (place each location on a separate line)"]
[null,"Location","# of leased classrooms 2001-02","Owner","FISH Stu. Sta.","# Years Leased ","# leased 2006-07","FISH Stu. Sta.","# Years Leased "]
[null,"Union County High School",2,"LEASED",20,3,0,0,0]
[]
["2c3.","Union Total",2,null,20,3,0,0,0]
[]
["2c4.","Plans for the use and location of Charter Schools, list current and PROJECTED.  (place each Charter School/location on a separate line)",{"$nulls":6},"Total charter students "]
[null,"Location-Type","# relocatable units or permanent classrooms ","Owner","Year Started","Student Stations","Students Enrolled","Years in Contract","projected for 2005-06"]
[null,"None"]
[]
["2c4.","Union Total",0,null,null,0,0,0,0]
[]
["2d.","Plans for multitrack scheduling, grade level organization, block scheduling, or other alternatives that reduce the need for permanent student stations."]
[]
[]
[]
[]
["2e.","Average Class Size (5 years out -- 2006-07) that will result if the district facilities work plan is fully implemented."]
[null,"NOTE: You are no longer required to exclude exceptional student education classes or prekindergarten classes.",null,null,null,"Actual Average","Projected","New Rooms to","Projected Average"]
[null,"Location","(ESE & PreK excluded) # CLASSROOMS","Capacity (NOT Stu Sta)","2001-02 CO-FTE","2001-02 Class size","2006-07 CO-FTE","be added (removed)","2006-07 Class size"]
[null,"Lake Butler Elementary",56,1539,855,15.27,821,null,15]
[null,"Lake Butler Middle",36,926,658,18.28,703,null,20]
[null,"Union County High School",34,846,601,17.68,533,null,16]
[]
[]
["2e.","Union Total",126,3311,2114,"District Avg 17",2057,0,"District Avg 16"]
[]
["2f.","The number and percentage of district students (CO-FTE) planned to be educated in relocatable facilities during each year."]
[]
[null,"Site                              ",null,"2002-03 ","2003-04 ","2004-05","2005-06","2006-07","5 YEAR AVERAGE"]
[null,"Union County High School",null,30,0,0,0,0,6]
[]
[]
[]
[]
[]
["2f.","Union Total students in relocatables by year",null,30,0,0,0,0,6]
[null,"Total number of CO-FTE students projected by year",null,2141,2105,2096,2060,2078,2096]
[null,"Percent in relocatables by year",null,0.01,0,0,0,0,0]
[]
["2g.","Plans for the closure of any school, including plans for disposition of the facility or usage of facility space, and anticipated revenues."]
[null,"None"]
[{"$nulls":10},"State Average","State Average","State Average","State Average","State Average","State Average"]
["3 .","The projected cost for each project identified in the tentative district facilities work program.",{"$nulls":7},"Year",2000,2000,2000,2000,2000,2000]
[{"$nulls":9},"Type of School","GSF/Low/StuSta","GSF/Avg/StuSta","GSF/Hi/StuSta","COST/Low/StuSta","COST/Avg/StuSta","COST/Hi/StuSta"]
[{"$nulls":9},1,82,107,146,8756,12965,23176]
[null,"1999 State-wide totals - Gross Sq Ft per student station: Elem low 79, avg 110, high 156; Middle low 86, avg 113, high 165; High School low 68, avg 128, high 222 ",{"$nulls":7},2,84,119,161,9899,13498,17138]
[null,"1999 State-wide totals - Cost per student station: Elem low 9,213, avg 12,712, high 22,844; Middle low 9,863,avg 13,571, high 18,853; High School low 14,900, avg 18,106, high  26,448 ",{"$nulls":7},3,93,112,185,12826,15024,22033]
[]
["3a.","2002-03 Year","Type of School (new schools only)  Others=0","2002-03","2002-03","2002-03","2002-03","2000 State Avg","2000 State Avg","2000 State Avg","2002 Projected","2000 State Avg","2000 State Avg","2000 State Avg"]
[null,"Project Description","Elem=1, Middle=2, High=3, K-8=2, K-12=3, VoTech=3, ESE=3","PLANNED COST","Student Stations","Gross Sq. Ft","GSF/per StuSta","GSF/Low/StuSta","GSF/Avg/StuSta","GSF/High/StuSta","COST/per StuSta","COST/Low/StuSta","COST/Avg/StuSta","COST/High/StuSta"]
[null,"High School addition",null,200000,60,6430,107.17,0,0,0,3333.33,0,0,0]
[{"$nulls":11},0,0,0]
[{"$nulls":11},0,0,0]
["3a.","Union Total 2002-03",null,200000,60,6430,107.17,null,null,null,3333.33]
[]
["3b.","2003-2004 Year","Type of School (new schools only)  Others=0","2003-04","2003-04","2003-04","2003-04","2000 State Avg","2000 State Avg","2000 State Avg","2003 Projected","2000 State Avg","2000 State Avg","2000 State Avg"]
[null,"Project Description","Elem=1, Middle=2, High=3, K-8=2, K-12=3, VoTech=3, ESE=3","PLANNED COST","Student Stations","Gross Sq. Ft","GSF/per StuSta","GSF/Low/StuSta","GSF/Avg/StuSta","GSF/High/StuSta","COST/per StuSta","COST/Low/StuSta","COST/Avg/StuSta","COST/High/StuSta"]
[null,"None",{"$nulls":5},0,0,0,null,0,0,0]
[{"$nulls":7},0,0,0,null,0,0,0]
["3b","Union Total 2003-04",null,0,0,0,{"$error":"#DIV/0!"}]
[]
["3c.","2004-2005 Year","Type of School (new schools only)  Others=0","2004-05","2004-05","2004-05","2004-05","2000 State Avg","2000 State Avg","2000 State Avg","2004 Projected","2000 State Avg","2000 State Avg","2000 State Avg"]
[null,"Project Description","Elem=1, Middle=2, High=3, K-8=2, K-12=3, VoTech=3, ESE=3","PLANNED COST","Student Stations","Gross Sq. Ft","GSF/per StuSta","GSF/Low/StuSta","GSF/Avg/StuSta","GSF/High/StuSta","COST/per StuSta","COST/Low/StuSta","COST/Avg/StuSta","COST/High/StuSta"]
[null,"None",{"$nulls":5},0,0,0,null,0,0,0]
["3c","Union Total 2004-05"]
[]
["3d.","2005-2006 Year","Type of School (new schools only)  Others=0","2005-06","2005-06","2005-06","2005-06","2000 State Avg","2000 State Avg","2000 State Avg","2005 Projected","2000 State Avg","2000 State Avg","2000 State Avg"]
[null,"Project Description","Elem=1, Middle=2, High=3, K-8=2, K-12=3, VoTech=3, ESE=3","PLANNED COST","Student Stations","Gross Sq. Ft","GSF/per StuSta","GSF/Low/StuSta","GSF/Avg/StuSta","GSF/High/StuSta","COST/per StuSta","COST/Low/StuSta","COST/Avg/StuSta","COST/High/StuSta"]
[null,"None",{"$nulls":5},0,0,0,null,0,0,0]
["3d.","Union Total 2005-06"]
[]
["3e.","2006-2007 Year","Type of School (new schools only)  Others=0","2006-07","2006-07","2006-07","2006-07","2000 State Avg","2000 State Avg","2000 State Avg","2006 Projected","2000 State Avg","2000 State Avg","2000 State Avg"]
[null,"Project Description","Elem=1, Middle=2, High=3, K-8=2, K-12=3, VoTech=3, ESE=3","PLANNED COST","Student Stations","Gross Sq. Ft","GSF/per StuSta","GSF/Low/StuSta","GSF/Avg/StuSta","GSF/High/StuSta","COST/per StuSta","COST/Low/StuSta","COST/Avg/StuSta","COST/High/StuSta"]
[null,"None",{"$nulls":5},0,null,0,null,0,0,0]
[{"$nulls":9},0,null,0,0,0]
["3e","Union Total 2006-07",null,0,0,0]
[]
["3f.","Union 5-Year Total",null,200000,60,6430]
[]
["4 .","Schedule of Estimated Capital Outlay Revenue from each currently approved source which is estimated to be available for expenditures on the"]
[null,"projects included in the tentative district facilities work program.   All amounts below are NET after considering carryover balances, interest earned, new COP's, 237 loans etc."]
[]
[null,null,null,"2002-03 ","2003-04 ","2004-05","2005-06","2006-07"]
[null,null,null,"Actual Budget","Projected","Projected","Projected","Projected","5 YEAR TOTAL"]
[null,"The Millege projected for discretionary capital outlay per s.236.25",null,2,2,2,2,2,10]
[null,"Full value of the 2-Mill discretionary capital outlay per s.236.25",null,334247.68,364000,383000,397000,412000,1890247.68]
[null,"Value of the portion of the 2-Mills ACTUALLY levied.",null,334247.68,364000,383000,397000,412000,1890247.68,"2 mill Expenditures"]
[null,"  less amount used to purchase school busses",null,56930,112000,112000,170000,170000,620930,0.328491343525945]
[null,"  less amount used to purchase other vehicles",{"$nulls":6},0,0]
[null,"  less amount transferred to operating budget for maintenance/repair",{"$nulls":6},0,0]
[null,"  less amount used for maintenance/repair",{"$nulls":6},0,0]
[null,"  less amount used to purchase capital outlay equipment",null,80000,88000,94000,103000,112000,477000,0.252347882791741]
[null,"  less amount used to correct environmental problems",{"$nulls":6},0,0]
[null,"  less amount transferred to operating budget for salaries",{"$nulls":6},0,0]
[null,"  less amount used to pay debt service for s.237 loans",null,97318,97318,97318,97318,97318,486590,0.257421292007617]
[null,"  less amount to pay debt service for COP's ",{"$nulls":7},0]
[null,"less amount for fireproof vault",null,100000,{"$nulls":4},100000,0.052903120082126,"ALL Capital Outlay Expenditures"]
[null,"Net available 2-mills to construct new stu stations & core facilities",null,-0.3200000000069849,66682,79682,26682,32682,205727.67999999993,0.108836361592572,0.23]
[null,"P E C O New Construction",null,75546,77500,80000,83250,96782,413078,null,0.45]
[null,"C O & D S   Bond Proceeds  received on 20 March 1998",null,41165.85,55000,62000,64000,72000,294165.85,null,0.32]
[null,"C O & D S maximum potential bond proceeds",{"$nulls":6},0,null,0]
[null,"Proceeds from 1/2 cent sales surtax authorized",null,null,0,0,0,0,0,null,0]
[null,"Proceeds from a s.237 loan",null,null,0,0,0,0,0,null,0]
[null,"Proceeds from local governmental infrastructure sales surtax",null,null,0,0,0,0,0,null,0]
[null,"Voted local bond referendum proceeds per s.9, Art VII State Const.",null,null,0,0,0,null,0,null,0]
[null,"Proceeds from Certificates of Participation (COP's)",null,null,0,0,0,null,0,null,0]
[null,"Classrooms First Bond proceeds amount authorized in FY 1997-98",null,null,0,0,0,0,0,null,0]
[null,"Effort Index Grants",null,null,0,0,0,0,0]
[null,"Impact fees received",null,null,0,0,0,0,0,null,0]
[null,"Private donations",null,null,0,0,0,0,0,null,0]
[null,"Grants from local governments or not-for-profit organizations",null,null,0,0,0,0,0,null,0]
["4.","Union Total",null,116711.53,199182,221682,173932,201464,912971.5299999999,1.000000000000001,1]
[]
["5 .","Schedule indicating which projects included in the tentative district facilities work program will be funded from current revenues projected"]
[null,"in paragraph 4 above."]
[null,null,null,"2002-03 ","2003-04 ","2004-05","2005-06","2006-07"]
[null,"Project Description","Student Stations","Actual Budget","Projected","Projected","Projected","Projected","5 YEAR TOTAL"]
[null,"New Addition High School",200000,{"$nulls":5},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
["5.","Union Total",200000,0,0,0,0,0,0]
[]
["6 .","Schedule of options for generation of additional revenues by the district facilities work program which are not funded under paragraph 5 above."]
[null,"Additional anticipated revenues may include effort index grants and SIT Program awards."]
[null,null,null,"2002-03 ","2003-04 ","2004-05","2005-06","2006-07"]
[null,null,null,"Actual Budget","Projected","Projected","Projected","Projected","5 YEAR TOTAL"]
[null,"SIT Program awards",null,0,0,0,0,0,0]
[null,"Other (specify)",null,0,0,0,0,0,0]
["6.","Union Total",null,0,0,0,0,0,0]
[]
["7 .","Schedule indicating which projects included in the tentative district facilities work program in paragraph (2) 2. above which CANNOT be funded"]
[null,"from current revenues projected over the next 5-years."]
[null,null,null,"2002-03 ","2003-04 ","2004-05","2005-06","2006-07"]
[null,"Project Description","Student Stations","Actual Budget","Projected","Projected","Projected","Projected","5 YEAR TOTAL"]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
["7.","Union Total",0,0,0,0,0,0,0]
[]
[null,"NOTE: If the sum of the totals in paragraphs 5. and 7. above DO NOT equal the total in paragraph 2. above, the message \"Check Totals\" appears.   -- They should balance ! !"]
[null,"Project Description",null,"2002-03 ","2003-04 ","2004-05","2005-06","2006-07","5 YEAR TOTAL"]
[null,"This row is for \"Checking and Balancing\" only",null,"","","","","",""]
[]
["2.(b)","To the extent available, the tentative district facilities work program shall be based on information produced by the demographic and revenue"]
[null,"education estimating conferences."]
[]
["(3)","The adopted district facilities work program shall:"]
["(a)","Be a complete, balanced capital outlay financial plan for the district."]
["(b)","Set forth the proposed commitments and planned expenditures of the district to address the educational facilities needs of its students"]
[null,"and to adequately provide for the maintenance of the educational plant and ancillary facilities."]
[]
["(4)","The first year of the adopted district facilities work program shall constitute the capital outlay budget required in s. 235.18."]
[null,"The adopted district facilities work program shall include the information required in paragraphs (2) (a) 1., 2., and 3., based upon projects actually"]
[null,"funded in the program."]
{"$rows_empty":7}
["Respectfully submitted this ___________ day of ____________________, 2002."]
[]
[null,"SCHOOL BOARD OF ","Union  COUNTY"]
[]
["DISTRICT SUPERINTENDENT:"]
[null,null,"Signature",null,null,"Name Printed",null,null,"Date"]
[]
["CHIEF FINANCIAL OFFICER:  ____________________________________________________________________________________________________________________________________________________________",{"$nulls":8}," "]
[null,null,"Signature",null,null,"Name Printed",null,null,"Date",null," "]
[]
["DISTRICT POINT-OF-CONTACT PERSON:  _________________________________________________________________________________________________________________________________________________",{"$nulls":8}," "]
[null,null,null,"Name Printed","Job Title","Phone number(s)",null,"E-Mail Address",null,null," "]

{"sheet":"EXPLANATIONS OF WORK PLAN","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}