{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["*****","99_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":"99_5YrWkPlan","index":1,"n_rows":266,"n_cols":25,"rows_kept":266,"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 the SMART Schools Clearinghouse, 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, as you received it (not a fax), prior to September 15, 1999, and all data accurate as of July 15, 1999.",{"$nulls":8},"1999-08-05",{"$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: ==>","1999-12-10",null,"For fiscal years","  1999-2000 through 2003-2004"]
[]
["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,"1999-00 ","2000-01 ","2001-02 ","2002-03 ","2003-04 "]
[null,"Project","Location","Actual Budget","Projected Cost","Projected Cost","Projected Cost","Projected Cost","5 YEAR TOTAL"]
[null,"Life Safety Upgrades","Lake Butler Elementary School",10310,10000,10000,10000,10000,50310]
[null,"Life Safety Upgrades","Lake Butler Middle School",10310,10000,10000,10000,10000,50310]
[null,"Life Safety Upgrades","Union County High School",10310,10000,10000,10000,10000,50310]
[null,"Hvac Ugrades","Lake Butler Elementary School",5000,5000,5000,5000,5000,25000]
[null,"Hvac Ugrades","Lake Butler Middle School",5000,5000,5000,5000,5000,25000]
[null,"Hvac Ugrades","Union County High School",5000,5000,5000,5000,5000,25000]
[null,"Reroofing","Lake Butler Middle School",50000,{"$nulls":4},50000]
[null,"Retrofit for Technology","Lake Butler Elementary School",65000,{"$nulls":4},65000]
[null,"Sanitation Facilities","Lake Butler Middle School",55000,{"$nulls":4},55000]
[null,"Fire ,Saftey & Security Upgrades","Lake Butler Elementary School",50000,{"$nulls":4},50000]
[null,"Replace Gym Roof","Union County High School",100000,{"$nulls":4},100000]
[null,"Retrofit for Technology","Lake Butler Middle School",66899,{"$nulls":4},66899]
[null,"Paving","Lake Butler Elementary School",null,20000," "," "," ",20000]
[null,"Paving","Lake Butler Middle School",null,null,20000,null,null,20000]
[null,"Asbestos Removal","Lake Butler Elementary School",null,25000,25000,null,null,50000]
[null,"Asbestos Removal","Lake Butler Middle School",null,null,null,25000,25000,50000]
[null,"Covered Walkways","Lake Butler Elementary School",null,10000,10000,10000,10000,40000]
[null,"Retrofit Chillers","Lake Butler Middle School",null,null,null,45000,45000,90000]
[null,"Remodel Restrooms(ADA)","Lake Butler Middle School",null,30000,30000,null,null,60000]
[null,"Technology Upgrades","Countywide",null,20000,25000,30000,35000,110000]
[null,"Equipment Upgrades","Countywide",180902,50000,50000,50000,50000,380902]
["1.","UNION Total",null,613731,200000,205000,205000,210000,1433731]
[]
["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,"1999-00","2000-01","2001-02","2002-03","2003-04"]
[null,"Project Description",null,"Actual Budget","Projected Cost","Projected Cost","Projected Cost","Projected Cost","5 YEAR TOTAL"]
[null,"NONE",{"$nulls":6},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
["2 .","UNION Total",null,0,0,0,0,0,0]
[]
[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,"1998-99 FISH Satisfactory","Actual 1998-99","Actual 1998-99","Actual 1998-99","New Stu Capacity to","Projected 2003-04","Projected 2003-04"]
[null,"Location","Student Stations","FISH Capacity ","CO-FTE ","Utilization","be added (removed)","CO-FTE ","Utilization"]
[null,"Lake Butler Elementary School",1323,1539,873,0.57,null,820,0.53]
[null,"Lake Butler Middle School",860,928,748,0.81,null,761,0.82]
[null,"Union County High School",882,846,634,0.75,null,696,0.82]
[{"$nulls":5}," ",null,null," "]
[{"$nulls":5}," ",null,null," "]
["2a.","UNION Total",3065,3313,2255,0.68,0,2277,0.69]
[]
["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 1998-99","Owner","Student Stations","as classroom space","in 2003-04","units by 2003-04","Column \"C\""]
[null,"Union County High School",1,"GE Capital",20,null,0,-1,4]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
["2c1.","UNION Total",1,null,20,0,0,-1,"Avg Age 4"]
[]
["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","1999-00","2000-01","2001-02","2002-03","2003-04","5 YEAR TOTAL"]
[null,"None",{"$nulls":6},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
["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 1998-99","Owner","FISH Stu. Sta.","# Years Leased ","# leased 2003-04","FISH Stu. Sta.","# Years Leased "]
[null,"Union County High School",1,"GE Capital",20,4,0," "]
[]
["2c3.","UNION Total",1,null,20,4,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 2003-04"]
[{"$nulls":8},0]
[{"$nulls":8},0]
["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."]
[null,"None"]
[]
[]
["2e.","Average Class Size (5 years out -- 2003-04) that will result if the district facilities work plan is fully implemented."]
[null,"NOTE: The average shall not include 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)","1998-99 CO-FTE","1998-99 Class size","2003-04 CO-FTE","be added (removed)","2003-04 Class size"]
[null,"Lake Butler Elementary School",56,1539,873,15.59,820,0,14.64]
[null,"Lake Butler Middle School",36,928,748,20.78,761,0,21.14]
[null,"Union County High School",34,846,634,18.65,696,0,20.47]
[]
[]
["2e.","UNION Total",126,3313,2255,"District Avg 18",2277,0,"District Avg 18"]
[]
["2f.","The number and percentage of district students (CO-FTE) planned to be educated in relocatable facilities during each year."]
[]
[null,"Site                              ",null,"1999-00","2000-01","2001-02","2002-03","2003-04","5 YEAR AVERAGE"]
[null,"Union County High School",null,20,{"$nulls":4},20,null,0]
[{"$nulls":8},{"$error":"#DIV/0!"}]
[{"$nulls":8},{"$error":"#DIV/0!"}]
[{"$nulls":8},{"$error":"#DIV/0!"}]
[{"$nulls":8},{"$error":"#DIV/0!"}]
[{"$nulls":8},{"$error":"#DIV/0!"}]
["2f.","UNION Total students in relocatables by year",null,20,0,0,0,0,4]
[]
[null,"Percent in relocatables by year",null,0.008869179600886918]
[]
["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",1998,1998,1998,1998,1998,1998]
[{"$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,70,107,174,7485,11173,16419]
[null,"1998 State-wide totals - Gross Sq Ft per student station: Elem low 70, avg 107, high 174; Middle low 88, avg 90, high 180; High School low 117, avg 130, high 143 ",{"$nulls":7},2,88,90,180,7226,13517,18473]
[null,"1998 State-wide totals - Cost per student station: Elem low 7,485, avg 11,173, high 16,419; Middle low 7,226,avg 13,517, high 18,473; High School low 16,957, avg 19,323, high  21,507 ",{"$nulls":7},3,117,130,144,16957,19232,21507]
[]
["3a.","1999-00 Year","Type of School (new schools only)  Others=0","1999-00","1999-00","1999-00","1999-00","1998 State Avg","1998 State Avg","1998 State Avg","1999 Projected","1998 State Avg","1998 State Avg","1998 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":4},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},0,0,0]
[{"$nulls":6},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},0,0,0]
[{"$nulls":6},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},0,0,0]
["3a.","UNION Total 1999-00",null,0,0,0,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"}]
[]
["3b.","2000-2001 Year","Type of School (new schools only)  Others=0","2000-01","2000-01","2000-01","2000-01","1998 State Avg","1998 State Avg","1998 State Avg","2000 Projected","1998 State Avg","1998 State Avg","1998 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":4},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},0,0,0]
[{"$nulls":6},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},0,0,0]
["3b","UNION Total 2000-01",null,0,0,0,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"}]
[]
["3c.","2001-2002 Year","Type of School (new schools only)  Others=0","2001-02","2001-02","2001-02","2001-02","1998 State Avg","1998 State Avg","1998 State Avg","2001 Projected","1998 State Avg","1998 State Avg","1998 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":4},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},0,0,0]
["3c","UNION Total 2001-02",null,0,0,0,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"}]
[]
["3d.","2002-2003 Year","Type of School (new schools only)  Others=0","2002-03","2002-03","2002-03","2002-03","1998 State Avg","1998 State Avg","1998 State Avg","2002 Projected","1998 State Avg","1998 State Avg","1998 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":4},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},0,0,0]
["3d.","UNION Total 2002-03",null,0,0,0,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"}]
[]
["3e.","2003-2004 Year","Type of School (new schools only)  Others=0","2003-04","2003-04","2003-04","2003-04","1998 State Avg","1998 State Avg","1998 State Avg","2003 Projected","1998 State Avg","1998 State Avg","1998 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":4},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},0,0,0]
[{"$nulls":6},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},0,0,0]
["3e","UNION Total 2003-04",null,0,0,0,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"}]
[]
["3f.","UNION 5-Year Total",null,0,0,0]
[]
["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,"1999-00","2000-01","2001-02","2002-03","2003-04"]
[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,264129,270000,275000,280000,285000,1374129]
[null,"Value of the portion of the 2-Mills ACTUALLY levied.",null,264129,270000,275000,280000,285000,1374129,"2 mill Expenditures"]
[null,"  less amount used to purchase school busses",null,63007,65000,70000,75000,80000,353007,0.256895095001998]
[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",null," ",35000,35000,35000,35000,140000,0.1018827198902]
[null,"  less amount used to purchase capital outlay equipment",null,61993,70000,70000,70000,70000,341993,0.248879835881493]
[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,139129,100000,100000,100000,100000,539129,0.39234234922631]
[null,"  less amount to pay debt service for COP's ",{"$nulls":6},0,0]
[null,"  less other (please be specific)",{"$nulls":6},0,0,"ALL Capital Outlay Expenditures"]
[null,"Net available 2-mills to construct new stu stations & core facilities",null,0,0,0,0,0,0,0,0]
[null,"P E C O New Construction",null,132241,140000,150000,160000,170000,752241,null,0.66]
[null,"C O & D S   Bond Proceeds  received on 20 March 1998",{"$nulls":6},0,null,0]
[null,"C O & D S maximum potential bond proceeds",null,390000,{"$nulls":4},390000,null,0.34]
[null,"Proceeds from 1/2 cent sales surtax authorized",{"$nulls":6},0,null,0]
[null,"Proceeds from a s.237 loan",{"$nulls":6},0,null,0]
[null,"Proceeds from local governmental infrastructure sales surtax",{"$nulls":6},0,null,0]
[null,"Voted local bond referendum proceeds per s.9, Art VII State Const.",{"$nulls":6},0,null,0]
[null,"Proceeds from Certificates of Participation (COP's)",{"$nulls":6},0,null,0]
[null,"Classrooms First Bond proceeds amount authorized in FY 1997-98",{"$nulls":6},0,null,0]
[null,"Impact fees received",{"$nulls":6},0,null,0]
[null,"Private donations",{"$nulls":6},0,null,0]
[null,"Grants from local governments or not-for-profit organizations",{"$nulls":6},0,null,0]
["4.","UNION Total",null,522241,140000,150000,160000,170000,1142241,1.0000000000000009,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,"1999-00","2000-01","2001-02","2002-03","2003-04"]
[null,"Project Description",null,"Actual Budget","Projected","Projected","Projected","Projected","5 YEAR TOTAL"]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
["5.","UNION Total",null,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,"1999-00","2000-01","2001-02","2002-03","2003-04"]
[null,null,null,"Actual Budget","Projected","Projected","Projected","Projected","5 YEAR TOTAL"]
[null,"Effort Index Grants","None",0,0,0,0,0,0]
[null,"SIT Program awards","None",0,0,0,0,0,0]
[null,"Other (specify)","None",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,"1999-00","2000-01","2001-02","2002-03","2003-04"]
[null,"Project Description",null,"Actual Budget","Projected","Projected","Projected","Projected","5 YEAR TOTAL"]
[null,"None",{"$nulls":6},0]
[null," ",{"$nulls":6},0]
[null," ",{"$nulls":6},0]
["7.","UNION Total",null,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,"1999-00","2000-01","2001-02","2002-03","2003-04","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 ____________________, 1999."]
[]
[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"]}