{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Introduction","General Info","Facilities Inventory","CMP Overview","Budgets","PM","Health & Safety","Integrated Pest Management","Indoor Environment Quality","Energy","Current Projects","Planned Projects","Facility Report Card","5 Year Cap Plan, Part 1","5 Year Cap Plan, Part 2","App A Equip Inventory","App B PM Checklist & Log","App C Work Order","App D Bid Spec","App E Resources"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":51,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":26,"n_cols":1,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3],[3,0,3,3],[4,0,4,3],[21,0,21,3],[19,0,19,3],[15,0,15,3],[5,0,5,3],[2,0,2,3],[23,0,23,3],[24,0,24,3],[26,0,31,3],[22,0,22,3],[25,0,25,3],[6,0,6,3],[9,0,9,3],[7,0,7,3],[18,0,18,3],[14,0,14,3],[13,0,13,3],[16,0,16,3],[10,0,10,3],[12,0,12,3],[8,0,8,3],[11,0,11,3],[17,0,17,3]]}
["ATTENTION!"]
["IF YOU SEE THIS, YOU HAVE MACROS DISABLED OR RESTRICTED"]
[]
["PLEASE ENABLE MACROS FOR THIS TOOLBOX TO FUNCTION PROPERLY"]
["TO DO THIS, CLICK ON \"TOOLS\" IN THE MENU ABOVE, FIND THE OPTION \"MACRO\", DRAG YOUR CURSOR OVER IT, THEN CLICK \"SECURITY\""]
["UNDER THE SECURITY LEVEL TAB, CLICK THE OPTION FOR \"MEDIUM\" LEVEL SECURITY, THEN CLOSE AND RELOAD THIS FILE"]
["Energy $mart Schools"]
["NYSED Capital & Maintenance Planning Reports Toolbox"]
["(For Producing Comprehensive Maintenance Plans, Five-Year Capital Facilities Plans & Facility Report Cards)"]
["INTRODUCTION"]
["This template was designed by the New York State Energy Research and Development Authority and the New York State Education Department to help New York Schools produce required annual reports easily and effectively.  After you enter your schools' data once, it will print out on three reports.  The Toolbox also acts as a database that can be easily updated each year.  Some of the appendices contained in the Toolbox provide templates for a Preventive Maintenance (PM) program. "]
["In addition to reducing your paperwork, organizing your building data and your requests for expenses between your Five-Year Capital Facilities Plan, your Facility Report Cards and your Comprehensive Maintenance Plan (CMP), this template tries to serve a variety of objectives, including: "]
["     ► Fulfill NYSED Commissioner’s Regulation 155.4(d)(2) to develop and annually update a Comprehensive Maintenance Plan (CMP). "]
["     ► Help ensure that all school buildings in New York State are maintained in a state of good repair, combing data from the CMP and Report Cards."]
["     ► Help Superintendents of Buildings and Grounds (SBGs) manage operating costs (energy, annual maintenance, and repairs) with effective maintenance."]
["     ► Help improve occupant health, safety and comfort"]
["     ► Help justify capital expenses that reduce energy or maintenance costs."]
["     ► Focus preventive maintenance approaches to improve overall maintenance."]
["     ► Document capital expenses above and beyond annual costs (for service contracts, supplies, and reoccurring costs) that will be included in the Five-Year Capital Facilities Plans. By showing the benefits of these capital expenses in reducing maintenance and energy costs, it will help justify each year's capital costs."]
["INSTRUCTIONS"]
[]
["1) Beginning with the yellow General Info tab, fill in all information as prompted.  The information provided on the General Info tab will automatically transfer to the other tabs in the spreadsheet, so the information only needs to be provided once. "]
[" 2) Continue to fill out the other yellow tabs.  Additional instructions highlighted at the top of each page. "]
[" 3) The green tabs are used only to review and print the Five Year Capital Plan and the Facility Report Card. No data needs to be entered on the green tabs, but an idividual school's Capital Plan budget or an individual school's Report Card can be viewed before printing."]
[" 4) The blue Appendix tabs are there as resources, but will not be included in reports unless selected."]
[" 5) When information is entered, use the print button below to generate the reports.  The individual tabs throughout the tool are also print-formatted, so each report can be printed as needed. "]

{"sheet":"General Info","index":1,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,3],[16,0,16,3],[2,0,2,3],[4,0,4,3],[3,0,3,3],[5,0,5,3],[15,0,15,3]]}
["In addition to being an input page, this page also serves as the cover page for the CMP."]
[]
["Energy $mart Schools"]
["Comprehensive Maintenance Plan (CMP)"]
["GENERAL INFORMATION"]
[]
["Date:","2005-02-01","Person Preparing this Plan: ","John Doe"]
["School District:","Sample Town CSD","Title/Position","Superintendent of Buildings and Grounds"]
["BOCES:","Valley View BOCES","Address:","101 Main Street"]
["Plan Year:",2005,"City:","Albany"]
["Number of Schools in District: ",4,"State:","NY"]
["Number of Buildings in District: ",4,"Zip:",12345]
[null,null,"Telephone: ","999-999-9999"]
[null,null,"Fax: ","888-888-8888"]
[null,null,"E-mail: ","test@imagine.com"]
["Please use the following space to list the people who prepared this plan and the resources used:"]
["People and resources here."]

{"sheet":"Facilities Inventory","index":2,"n_rows":60,"n_cols":7,"rows_kept":60,"cut":false,"hidden":false,"merged":[[59,1,59,6],[53,0,53,6],[54,1,54,6],[55,1,55,6],[56,1,56,6],[1,0,1,6],[0,0,0,6],[2,0,2,6],[57,1,57,6],[58,1,58,6]]}
["Energy $mart Schools"]
[{"$f":"CONCATENATE(\"District: \",'General Info'!B8, \"           Prepared by: \",'General Info'!D7, \"           Date: \",TEXT('General Info'!B7,\"mm/dd/yyyy\"))","v":"District: Sample Town CSD           Prepared by: John Doe           Date: 02/01/2005"}]
["FACILITIES INVENTORY"]
["Name of School/Facility","Elementary Elementary School","Good Grades Middle School","Example School 3","Example School 4","Example School 5","Example School 6"]
["BEDS Code",123456789,987654321]
["Street Address","1234 Willow Road","9 Chain Road"]
["City","Sacketts Harbor","Albany"]
["State","NY","NY"]
["ZIP",12345,12345]
["Year Built",1958,1967]
["Square Footage ",95000,100300]
["# of Floors",2,1]
["Basement?","Yes","No"]
["Enrollment",1175,1200]
["Capacity",1200,1500]
["Grades","K-6","6-8"]
["Ownership Type:","Owned","Operated"]
["Primary Heat Source:","Natural Gas","Oil"]
[null,{"$f":"B4","v":"Elementary Elementary School"},"Good Grades Middle School","Example School 3","Example School 4","Example School 5","Example School 6"]
["Certificate of Occupancy Status:","Annual","30 Day Temp"]
["Expiration Date:","2002-07-02","2002-09-05"]
["Location where certificate of occupancy is posted:","File Room","File Room"]
["Can upgrades to school building systems be viewed on Building Condition Survey?","Yes","No"]
["Can the number of different types of program spaces currently in this school building be viewed on the Building Condition Survey?","No","Yes"]
["Date current 5-year building condition survey conducted:","2003-06-05","2003-04-03"]
["Overall school building safety rating from Building Condition Survey as certified by the Board of Education:","Satisfactory","Excellent"]
["Date current year annual visual inspection was conducted:","2003-05-03","2004-06-03"]
["Overall condition: ","Good","Excellent"]
["Can estimated remaining useful life of school building and systems be viewed on the Building Condition Survey?","Yes","No"]
["Probable Useful Life of Building (years):",20,40]
["Estimated Replacement Value:",100000,50000]
["Can the need for routine maintenance, repairs, rehabilitation, reconstruction, and construction be viewed on the Capital Facilities Plan?","Yes","No"]
["Original Construction Square Footage:",80000]
["Addition #1 Construction Year:",1959]
["Addition #1 Square Footage:",1000]
["Addition #2 Construction Year:",1962]
["Addition #2 Square Footage:",2000]
["Addition #3 Construction Year:",1965]
["Addition #3 Square Footage:",3000]
["Addition #4 Construction Year:",1970]
["Addition #4 Square Footage:"]
["Addition #5 Construction Year:"]
["Addition #5 Square Footage:"]
["Addition #6 Construction Year:"]
["Addition #6 Square Footage:"]
["Addition #7 Construction Year:"]
["Addition #7 Square Footage:"]
["Addition #8 Construction Year:"]
["Addition #8 Square Footage:"]
["Addition #9 Construction Year:"]
["Addition #9 Square Footage:"]
["Addition #10 Construction Year:"]
["Addition #10 Square Footage:"]
["For each building, list any current unsatisfactory building systems that have not been corrected since the previous Building Condition Survey:"]
[{"$f":"B4","v":"Elementary Elementary School"},"Building systems listed here."]
[{"$f":"C4","v":"Good Grades Middle School"},"Building systems listed here."]
[{"$f":"D4","v":"Example School 3"},"Building systems listed here."]
[{"$f":"E4","v":"Example School 4"},"Building systems listed here."]
[{"$f":"F4","v":"Example School 5"},"Building systems listed here."]
[{"$f":"G4","v":"Example School 6"},"Building systems listed here."]

{"sheet":"CMP Overview","index":3,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,0,26,5],[25,3,25,5],[20,0,20,1],[19,3,19,5],[22,3,22,5],[21,3,21,5],[25,0,25,1],[24,3,24,5],[23,3,23,5],[19,0,19,1],[17,0,17,6],[5,0,5,6],[13,0,13,6],[11,1,11,6],[14,0,14,4],[15,0,15,2],[0,0,0,6],[16,0,16,6],[6,1,6,6],[12,1,12,6],[7,1,7,6],[8,1,8,6],[9,1,9,6],[10,1,10,6],[2,0,2,6],[3,0,3,6],[4,0,4,6],[24,0,24,1],[20,3,20,5],[23,0,23,1],[22,0,22,1],[21,0,21,1]]}
["Provide a detailed description of the maintained conditions for each school building in the District compared to a year ago.  Use information from the yearly Visual Inspections and the original Building Condition Survey Reports to help track the progress being made.  This is also a good place to highlight items such as: how persistent problems have been solved; energy-efficiency projects being implemented; and new approaches being taken (e.g., trying new computerized maintenance management software)."]
[]
["Energy $mart Schools"]
[{"$f":"CONCATENATE(\"District: \",'General Info'!B8, \"           Prepared by: \",'General Info'!D7, \"           Date: \",TEXT('General Info'!B7,\"mm/dd/yyyy\"))","v":"District: Sample Town CSD           Prepared by: John Doe           Date: 02/01/2005"}]
["OVERVIEW"]
["Summary of Overall Conditions"]
["School Name","General Conditions and Goals"]
[{"$f":"'Facilities Inventory'!B4","v":"Elementary Elementary School"},"Insert assessment here…"]
[{"$f":"'Facilities Inventory'!C4","v":"Good Grades Middle School"},"Insert assessment here…"]
[{"$f":"'Facilities Inventory'!D4","v":"Example School 3"},"Insert assessment here…"]
[{"$f":"'Facilities Inventory'!E4","v":"Example School 4"},"Insert assessment here…"]
[{"$f":"'Facilities Inventory'!F4","v":"Example School 5"},"Insert assessment here…"]
[{"$f":"'Facilities Inventory'!G4","v":"Example School 6"},"Insert assessment here…"]
["Work Order Systems"]
["To help with unplanned maintenance and repairs, do you have a work-order system in place?",null,null,null,null,"Yes/No"]
["If yes, approximately how many work orders were completed last year? "]
["Service Contracts"]
["Indicate all systems that have preventive maintenance (PM) or service and repairs performed under service contracts with outside contractors."]
[null,null,"Yes/No",null,null,null,"Yes/No"]
["Heating ",null,"Yes","Computer/PA",null,null,"Yes"]
["Air Handling",null,"Yes","Roof",null,null,"Yes"]
["Cooling ",null,"Yes","Backup Power",null,null,"No"]
["HVAC Controls",null,"Yes","Electrical Distribution",null,null,"Yes"]
["Fire Protection/Suppression ",null,"Yes","Lighting",null,null,"Yes"]
["Plumbing ",null,"Yes","Landscaping",null,null,"No"]
["Other  ",null,"Yes","Other",null,null,"No"]
["Has the District compared costs of these contracts with in-house costs to ascertain whether the service contracts are cost-effective?",null,null,null,null,null,"Yes"]

{"sheet":"Budgets","index":4,"n_rows":114,"n_cols":7,"rows_kept":114,"cut":false,"hidden":false,"merged":[[0,0,0,6],[19,0,19,6],[20,1,20,2],[20,3,20,4],[20,5,20,6],[2,0,2,6],[3,0,3,6],[4,0,4,6],[5,5,5,6],[5,1,5,2],[5,3,5,4],[51,0,51,6],[52,1,52,2],[52,3,52,4],[52,5,52,6],[35,0,35,6],[36,1,36,2],[36,3,36,4],[36,5,36,6],[99,0,99,6],[100,1,100,2],[100,3,100,4],[100,5,100,6],[67,0,67,6],[68,1,68,2],[68,3,68,4],[68,5,68,6],[83,0,83,6],[84,1,84,2],[84,3,84,4],[84,5,84,6]]}
["Use these tables to document the estimated budget costs to 1) restore buildings to a state of good repair, 2) keep buildings in a state of good repair, and 3) project O&M costs. This material will become part of the annual Facility Report Card and will help justify annual maintenance expenses. The table at the top is the DISTRICT SUMMARY.  Dollar values entered in the school level tables below the District Summary will automatically total in the District Summary Table."]
[]
["Energy $mart Schools"]
[{"$f":"CONCATENATE(\"District: \",'General Info'!B8, \"           Prepared by: \",'General Info'!D7, \"           Date: \",TEXT('General Info'!B7,\"mm/dd/yyyy\"))","v":"District: Sample Town CSD           Prepared by: John Doe           Date: 02/01/2005"}]
["DISTRICT LEVEL BUDGET SUMMARY"]
[null,"Estimated Costs to Restore Buildings to a State of Good Repair",null,"Estimated Annual Costs to Keep Buildings in a State of Good Repair",null,"Projected Budget for O&M Costs"]
["Element","Cost Estimate","Notes","Cost Estimate","Notes","Cost Estimate","Notes"]
["Site Elements",{"$f":"+B23+B39+B55+B71+B87+B103","v":11000},null,{"$f":"+D23+D39+D55+D71+D87+D103","v":2000},null,{"$f":"+F23+F39+F55+F71+F87+F103","v":3000}]
["Roofing",12000,null,9000,null,6000]
["Envelope Elements",0,null,0,null,0]
["Structural Interior",0,null,0,null,0]
["Elements/Finishes",0,null,0,null,0]
["Electrical",0,null,0,null,0]
["Plumbing",0,null,0,null,0]
["HVAC",0,null,0,null,0]
["Special Construction",0,null,0,null,0]
["Emergency Systems (fire alarm, sprinklers, public address, etc.)",0,null,0,null,0]
["Other",0,null,0,null,0]
["TOTAL Estimated Cost",{"$f":"SUM(B8:B18)","v":23000},null,{"$f":"SUM(D8:D18)","v":11000},null,{"$f":"SUM(F8:F18)","v":9000}]
[{"$f":"'Facilities Inventory'!B4","v":"Elementary Elementary School"}]
[null,"Estimated Costs to Restore Buildings to a State of Good Repair",null,"Estimated Annual Costs to Keep Buildings in a State of Good Repair",null,"Projected Budget for O&M Costs"]
[null,"Cost Estimate","Justification","Cost Estimate","Justification","Cost Estimate","Justification"]
["Site Elements",1000,"Stop erosion at Ballfield 1.",2000,null,3000]
["Roofing",4000,null,5000,null,6000]
["Envelope Elements"]
["Structural Interior"]
["Elements/Finishes"]
["Electrical"]
["Plumbing"]
["HVAC"]
["Special Construction"]
["Emergency Systems (fire alarm, sprinklers, public address, etc.)"]
["Other"]
["TOTAL Estimated Cost",{"$f":"SUM(B23:B33)","v":5000},null,{"$f":"SUM(D23:D33)","v":7000},null,{"$f":"SUM(F23:F33)","v":9000}]
[]
[{"$f":"'Facilities Inventory'!C4","v":"Good Grades Middle School"}]
[null,"Estimated Costs to Restore Buildings to a State of Good Repair",null,"Estimated Annual Costs to Keep Buildings in a State of Good Repair",null,"Projected Budget for O&M Costs"]
[null,"Cost Estimate","Justification","Cost Estimate","Justification","Cost Estimate","Justification"]
["Site Elements",10000]
["Roofing",8000,null,4000]
["Envelope Elements"]
["Structural Interior"]
["Elements/Finishes"]
["Electrical"]
["Plumbing"]
["HVAC"]
["Special Construction"]
["Emergency Systems (fire alarm, sprinklers, public address, etc.)"]
["Other"]
["TOTAL Estimated Cost",{"$f":"SUM(B39:B49)","v":18000},null,{"$f":"SUM(D39:D49)","v":4000},null,{"$f":"SUM(F39:F49)","v":0}]
[]
[{"$f":"'Facilities Inventory'!D4","v":"Example School 3"}]
[null,"Estimated Costs to Restore Buildings to a State of Good Repair",null,"Estimated Annual Costs to Keep Buildings in a State of Good Repair",null,"Projected Budget for O&M Costs"]
[null,"Cost Estimate","Justification","Cost Estimate","Justification","Cost Estimate","Justification"]
["Site Elements"]
["Roofing"]
["Envelope Elements"]
["Structural Interior"]
["Elements/Finishes"]
["Electrical"]
["Plumbing"]
["HVAC"]
["Special Construction"]
["Emergency Systems (fire alarm, sprinklers, public address, etc.)"]
["Other"]
["TOTAL Estimated Cost",{"$f":"SUM(B55:B65)","v":0},null,{"$f":"SUM(D55:D65)","v":0},null,{"$f":"SUM(F55:F65)","v":0}]
[]
[{"$f":"'Facilities Inventory'!E4","v":"Example School 4"}]
[null,"Estimated Costs to Restore Buildings to a State of Good Repair",null,"Estimated Annual Costs to Keep Buildings in a State of Good Repair",null,"Projected Budget for O&M Costs"]
[null,"Cost Estimate","Justification","Cost Estimate","Justification","Cost Estimate","Justification"]
["Site Elements"]
["Roofing"]
["Envelope Elements"]
["Structural Interior"]
["Elements/Finishes"]
["Electrical"]
["Plumbing"]
["HVAC"]
["Special Construction"]
["Emergency Systems (fire alarm, sprinklers, public address, etc.)"]
["Other"]
["TOTAL Estimated Cost",{"$f":"SUM(B71:B81)","v":0},null,{"$f":"SUM(D71:D81)","v":0},null,{"$f":"SUM(F71:F81)","v":0}]
[]
[{"$f":"'Facilities Inventory'!F4","v":"Example School 5"}]
[null,"Estimated Costs to Restore Buildings to a State of Good Repair",null,"Estimated Annual Costs to Keep Buildings in a State of Good Repair",null,"Projected Budget for O&M Costs"]
[null,"Cost Estimate","Justification","Cost Estimate","Justification","Cost Estimate","Justification"]
["Site Elements"]
["Roofing"]
["Envelope Elements"]
["Structural Interior"]
["Elements/Finishes"]
["Electrical"]
["Plumbing"]
["HVAC"]
["Special Construction"]
["Emergency Systems (fire alarm, sprinklers, public address, etc.)"]
["Other"]
["TOTAL Estimated Cost",{"$f":"SUM(B87:B97)","v":0},null,{"$f":"SUM(D87:D97)","v":0},null,{"$f":"SUM(F87:F97)","v":0}]
[]
[{"$f":"'Facilities Inventory'!G4","v":"Example School 6"}]
[null,"Estimated Costs to Restore Buildings to a State of Good Repair",null,"Estimated Annual Costs to Keep Buildings in a State of Good Repair",null,"Projected Budget for O&M Costs"]
[null,"Cost Estimate","Justification","Cost Estimate","Justification","Cost Estimate","Justification"]
["Site Elements"]
["Roofing"]
["Envelope Elements"]
["Structural Interior"]
["Elements/Finishes"]
["Electrical"]
["Plumbing"]
["HVAC"]
["Special Construction"]
["Emergency Systems (fire alarm, sprinklers, public address, etc.)"]
["Other"]
["TOTAL Estimated Cost",{"$f":"SUM(B103:B113)","v":0},null,{"$f":"SUM(D103:D113)","v":0},null,{"$f":"SUM(F103:F113)","v":0}]

{"sheet":"PM","index":5,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":false,"merged":[[18,0,18,3],[17,0,17,3],[1,0,1,3],[0,0,0,3],[20,0,20,3],[2,0,2,3],[13,0,13,3],[16,0,16,3],[19,0,19,3],[14,0,14,3],[15,0,15,3]]}
["Energy $mart Schools"]
[{"$f":"CONCATENATE(\"District: \",'General Info'!B8, \"           Prepared by: \",'General Info'!D7, \"           Date: \",TEXT('General Info'!B7,\"mm/dd/yyyy\"))","v":"District: Sample Town CSD           Prepared by: John Doe           Date: 02/01/2005"}]
["PREVENTIVE MAINTENANCE PLAN"]
[]
["Preventive Maintenance (PM) typically provides significant benefits such as:"]
[]
["·        Lower overall maintenance costs versus correcting problems after they occur;"]
["·        Reduce equipment down time;"]
["·        Lower energy costs by maintaining systems in a more efficient operating condition;"]
["·        Lower replacement costs through longer equipment life;"]
["·        Improve indoor environment; and"]
["·        Improve occupant comfort, health and safety."]
[]
["Approach Used in this District"]
["Does the District perform PM? If so, what types of systems do you use (e.g., informal schedules, formal schedules with charts for maintenance intervals, computerized maintenance management systems (CMMS) with PM assignments automatically generated)?"]
["Example: We use a spreadsheet systems with all our major equipment and the maintenance intervals recommended in the O&M manuals. Our Office Manager …"]
["Lessons Learned"]
["What lessons have been learned in the District about the usefulness of PM? What works best and what doesn’t work well that can be shared with other Districts?"]
[]
["Checklist of Items Being Serviced Through PM"]
["Performing PM is one way of demonstrating that the District takes good care of existing systems and deserves State funding when those systems eventually wear out. The PM Checklist in Appendix A can be used to show which systems are maintained with PM. The list can also serve as a prompt to work with systems that may have needed more regular PM. The list should only be considered a starting point and how it is used will depend on the District's specific needs."]

{"sheet":"Health & Safety","index":6,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,6],[38,1,38,6],[39,1,39,6],[33,1,33,6],[34,1,34,6],[35,1,35,6],[36,1,36,6],[37,1,37,6],[21,0,21,6],[9,0,9,2],[4,1,4,2],[3,1,3,2],[5,1,5,2],[20,1,20,2],[6,1,6,2],[7,1,7,2],[1,0,1,6],[18,1,18,2],[19,1,19,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[16,1,16,2],[10,1,10,2],[15,0,15,2],[2,0,2,6],[8,1,8,2],[14,1,14,2],[17,1,17,2]]}
["Energy $mart Schools"]
[{"$f":"CONCATENATE(\"District: \",'General Info'!B8, \"           Prepared by: \",'General Info'!D7, \"           Date: \",TEXT('General Info'!B7,\"mm/dd/yyyy\"))","v":"District: Sample Town CSD           Prepared by: John Doe           Date: 02/01/2005"}]
["HEALTH & SAFETY"]
["Description of Health and Safety Committee activities:","Yes/No"]
["Does the district have a health and safety committee?","Yes"]
["Does the Health and Safety Committee have a chairperson?","No"]
["  - Name","John Milton"]
["  - Phone Number","212-867-5309"]
["  - Email","milty@school.com"]
["Does the Health and Safety Committee membership include:"]
["  - District Officials","Yes"]
["  - Staff","No"]
["  - Bargaining Units","Yes"]
["  - Parents","No"]
["Did the Health and Safety Committee receive any type of training?","Yes"]
["Health and Safety Committee membership expanded during construction to include district officials, staff, bargaining units, parents and:"]
["  - Project Architect","Yes"]
["  - Project Engineer","Yes"]
["  - Construction Manager","No"]
["  - Contractors","Yes"]
["Frequency of Health and Safety Committee meetings (check one):","3-5 Times / School Year"]
["ENVIRONMENTAL AWARENESS"]
["SCHOOL/FACILITY:",{"$f":"'Facilities Inventory'!B4","v":"Elementary Elementary School"},{"$f":"'Facilities Inventory'!C4","v":"Good Grades Middle School"},{"$f":"'Facilities Inventory'!D4","v":"Example School 3"},{"$f":"'Facilities Inventory'!E4","v":"Example School 4"},{"$f":"'Facilities Inventory'!F4","v":"Example School 5"},{"$f":"'Facilities Inventory'!G4","v":"Example School 6"}]
["Environmental Awareness","Yes/No","Yes/No","Yes/No","Yes/No","Yes/No","Yes/No"]
["Has this building been tested for the presence of lead: paints, plumbing, etc.?","Yes","Yes"]
["Based on the testing results, are there elements in this building that would require construction or maintenance projects to be conducted in accordance with the US Department of Housing and Urban Development Guidelines for the Evaluation and Control of Lead Based Paint Hazards in Housing?","No","Yes"]
["If yes, has this type of work been done in accordance with the Guidelines?","Yes","Yes"]
["Does this building contain known or assumed Asbestos Containing Building Materials? (ACBM)","No","Yes"]
["If yes, has an original Asbestos Hazard Emergency Response Act (AHERA) management plan been developed for this building? (The AHERA Management Plan for this building must be able to be viewed at the main office during normal business hours).","Yes","Yes"]
["When was the AHERA management plan last updated?","2004-04-04","2003-03-03"]
["Has the district reviewed the geological potential for the presence of radon from the New York State Dept. of Health Radon Measurement Database?","Yes","Yes"]
["Did the geological potential indicate testing this facility was necessary?","No","Yes"]
["If yes, did the highest test in this building exceed 4pCi/L?","Yes","Yes"]
["If yes, describe mitigation activities:"]
[{"$f":"'Facilities Inventory'!B4","v":"Elementary Elementary School"},"Mitigation activities described here."]
[{"$f":"'Facilities Inventory'!C4","v":"Good Grades Middle School"},"Mitigation activities described here."]
[{"$f":"'Facilities Inventory'!D4","v":"Example School 3"},"Mitigation activities described here."]
[{"$f":"'Facilities Inventory'!E4","v":"Example School 4"},"Mitigation activities described here."]
[{"$f":"'Facilities Inventory'!F4","v":"Example School 5"},"Mitigation activities described here."]
[{"$f":"'Facilities Inventory'!G4","v":"Example School 6"},"Mitigation activities described here."]

{"sheet":"Integrated Pest Management","index":7,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,6],[2,0,2,6],[3,0,3,6],[4,0,4,6]]}
["Indicate below which measures have been taken to achieve acceptable Integrated Pest Management."]
[]
["Energy $mart Schools"]
[{"$f":"CONCATENATE(\"District: \",'General Info'!B8, \"           Prepared by: \",'General Info'!D7, \"           Date: \",TEXT('General Info'!B7,\"mm/dd/yyyy\"))","v":"District: Sample Town CSD           Prepared by: John Doe           Date: 02/01/2005"}]
["INTEGRATED PEST MANAGEMENT"]
["SCHOOL/FACILITY:",{"$f":"'Facilities Inventory'!B4","v":"Elementary Elementary School"},{"$f":"'Facilities Inventory'!C4","v":"Good Grades Middle School"},{"$f":"'Facilities Inventory'!D4","v":"Example School 3"},{"$f":"'Facilities Inventory'!E4","v":"Example School 4"},{"$f":"'Facilities Inventory'!F4","v":"Example School 5"},{"$f":"'Facilities Inventory'!G4","v":"Example School 6"}]
["Status of measures to assure acceptable integrated pest management: ","Yes/No","Yes/No","Yes/No","Yes/No","Yes/No","Yes/No"]
["Does this building have an Integrated Pest Management program? See Appendix B.","Yes","Yes"]
["Does this building have a person designated to oversee the pest management program?","No","Yes"]
["Has this building established a list of persons to notify at least 48 hours prior to the application of pesticides?","Yes","Yes"]
["Have pesticide application summary reports been provided to all parents and staff pursuant to CR 155.24?","No","Yes"]

{"sheet":"Indoor Environment Quality","index":8,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[21,1,21,6],[15,1,15,6],[16,1,16,6],[17,1,17,6],[18,1,18,6],[19,1,19,6],[2,0,2,6],[0,0,0,6],[4,0,4,6],[3,0,3,6],[20,1,20,6]]}
["Use this table to provide information for your District’s School Facility Report Cards and the CMP.  Complete for each building in the District, and both a District-summary table and individual Report Card sections will be produced."]
[]
["Energy $mart Schools"]
[{"$f":"CONCATENATE(\"District: \",'General Info'!B8, \"           Prepared by: \",'General Info'!D7, \"           Date: \",TEXT('General Info'!B7,\"mm/dd/yyyy\"))","v":"District: Sample Town CSD           Prepared by: John Doe           Date: 02/01/2005"}]
["INDOOR ENVIRONMENTAL QUALITY"]
["SCHOOL/FACILITY:",{"$f":"'Facilities Inventory'!B4","v":"Elementary Elementary School"},{"$f":"'Facilities Inventory'!C4","v":"Good Grades Middle School"},{"$f":"'Facilities Inventory'!D4","v":"Example School 3"},{"$f":"'Facilities Inventory'!E4","v":"Example School 4"},{"$f":"'Facilities Inventory'!F4","v":"Example School 5"},{"$f":"'Facilities Inventory'!G4","v":"Example School 6"}]
["Status of actions and policies taken to assure acceptable indoor environmental quality:","Yes/No","Yes/No","Yes/No","Yes/No","Yes/No","Yes/No"]
["Does this building use the US Environmental Protection Agency’s Indoor Air Quality Tools for Schools Action Kit?","Yes","No"]
["Does this building have a procedure in place for reporting indoor environmental quality concerns?","Yes","No"]
["Is ventilation with outdoor air available in all occupied spaces?","Yes","No"]
["1)      Is all ventilation and exhaust equipment operational?","Yes","No"]
["2)      Are all outdoor air intakes unobstructed and clear of foreign objects?","Yes","No"]
["3)      Are all outside air damper controls in place and operational?","Yes","Yes"]
["4)      Have facilities operations been reviewed with respect to impact on outside air intakes (i.e., vehicle emissions, waste storage, mowing, etc.)?","Yes","Yes"]
["Are there any unresolved complaints regarding the indoor environment at this facility?","Yes","Yes"]
["If yes, describe for each building:"]
[{"$f":"'Facilities Inventory'!B4","v":"Elementary Elementary School"},"IEQ description here."]
[{"$f":"'Facilities Inventory'!C4","v":"Good Grades Middle School"},"IEQ description here."]
[{"$f":"'Facilities Inventory'!D4","v":"Example School 3"},"IEQ description here."]
[{"$f":"'Facilities Inventory'!E4","v":"Example School 4"},"IEQ description here."]
[{"$f":"'Facilities Inventory'!F4","v":"Example School 5"},"IEQ description here."]
[{"$f":"'Facilities Inventory'!G4","v":"Example School 6"},"IEQ description here."]
["Are the heating, ventilation, and air conditioning equipment cleaned and maintained in accordance with manufacturer’s instructions (e.g., filter changes, coils cleaned, etc.)?","Yes","Yes"]
["Has the interior of ductwork (air passageways) been inspected for cleanliness within the past year?","No","Yes"]
["Have exterior ductwork and rooftop air handling units been inspected for leaks within the past year?","Yes","No"]
["Does the District have a policy encouraging the use of environmentally friendly products?","No","Yes"]
["Does the District annually review products used in and around the building with the intent of reducing or eliminating hazardous chemicals that occupants and visitors are exposed to, including volatile organic compounds (VOCs), semi-volatile organic compounds, etc. (cleaning supplies, repair and maintenance supplies, materials, etc.)? ","Yes","Yes"]
["Does the District perform an annual review to ensure hazardous chemicals used as part of instructional programs are used and stored properly? ","No","Yes"]
["Is each building inspected for roof leaks, growth of mold and mildew, evidence of rodent infiltration, and other indicators of potential problems to acceptable IEQ?   ","Yes","Yes"]
["What level (dB) of maximum background accoustic settings has been set for classrooms?",35,70]
["Does this facility regularly test and record levels of CO, CO2, total VOCs, Radon, mold spores, etc?","Yes","Yes"]
["Does this facility regularly measure and track relative humidity levels?","Yes","Yes"]
["Does this facility verify lighting levels meet Illuminating Engineering Society guidelines each year?","Yes","Yes"]
["Does this facility follow green cleaning guidelines?","No","No"]
["Is this facility seeking to comply with a whole building sustainable guideline, such as the U.S. Green Building Council's LEED® for Existing Buildings?","Yes","No"]

{"sheet":"Energy","index":9,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,3,22,4],[22,1,22,2],[22,11,22,12],[22,9,22,10],[22,7,22,8],[22,5,22,6],[19,9,19,10],[20,9,20,10],[17,11,17,12],[18,11,18,12],[19,11,19,12],[20,11,20,12],[19,5,19,6],[20,5,20,6],[17,7,17,8],[18,7,18,8],[19,7,19,8],[20,7,20,8],[19,1,19,2],[20,1,20,2],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[17,1,17,2],[18,1,18,2],[17,5,17,6],[18,5,18,6],[17,9,17,10],[18,9,18,10],[14,11,14,12],[14,9,14,10],[16,11,16,12],[16,1,16,2],[15,1,15,2],[15,9,15,10],[16,3,16,4],[16,5,16,6],[16,7,16,8],[16,9,16,10],[15,11,15,12],[15,3,15,4],[15,5,15,6],[15,7,15,8],[13,9,13,10],[13,11,13,12],[10,1,10,2],[10,3,10,4],[10,5,10,6],[12,0,12,12],[13,1,13,2],[13,3,13,4],[13,5,13,6],[13,7,13,8],[0,0,0,12],[5,9,5,10],[11,11,11,12],[10,7,10,8],[8,11,8,12],[9,9,9,10],[9,11,9,12],[10,9,10,10],[9,7,9,8],[10,11,10,12],[2,0,2,12],[3,0,3,12],[5,11,5,12],[4,0,4,12],[5,1,5,2],[5,3,5,4],[11,9,11,10],[5,5,5,6],[5,7,5,8],[11,5,11,6],[11,7,11,8],[8,9,8,10],[8,5,8,6],[8,7,8,8],[9,5,9,6],[14,7,14,8],[8,1,8,2],[8,3,8,4],[9,1,9,2],[9,3,9,4],[14,1,14,2],[14,3,14,4],[14,5,14,6],[11,1,11,2],[11,3,11,4],[21,9,21,10],[21,11,21,12],[21,1,21,2],[21,3,21,4],[21,5,21,6],[21,7,21,8]]}
["Use this table to record your District’s energy benchmarking score compared to other New York schools.  Complete for each building in the District.  See Appendix E, Best Practices for additional information the US EPA Energy Star Portfolio Manager and the New York State Energy Research and Development Authority (NYSERDA) Energy Smart Schools Program free energy benchmarking service. "]
[]
["Energy $mart Schools"]
[{"$f":"CONCATENATE(\"District: \",'General Info'!B8, \"           Prepared by: \",'General Info'!D7, \"           Date: \",TEXT('General Info'!B7,\"mm/dd/yyyy\"))","v":"District: Sample Town CSD           Prepared by: John Doe           Date: 02/01/2005"}]
["ENERGY BENCHMARKING"]
["SCHOOL/FACILITY:",{"$f":"'Facilities Inventory'!B4","v":"Elementary Elementary School"},null,{"$f":"'Facilities Inventory'!C4","v":"Good Grades Middle School"},null,{"$f":"'Facilities Inventory'!D4","v":"Example School 3"},null,{"$f":"'Facilities Inventory'!E4","v":"Example School 4"},null,{"$f":"'Facilities Inventory'!F4","v":"Example School 5"},null,{"$f":"'Facilities Inventory'!G4","v":"Example School 6"}]
["Status of measures taken to optimize energy use: ","Current Year","Last Year","Current Year","Last Year","Current Year","Last Year","Current Year","Last Year","Current Year","Last Year","Current Year","Last Year"]
["What was this building’s score in the U.S. Environmental Protection Agency’s Energy Star® Portfolio Manager?",60,50,60,50]
[null,"Yes/No",null,"Yes/No",null,"Yes/No",null,"Yes/No",null,"Yes/No",null,"Yes/No"]
["Has this building’s energy use been benchmarked using NYSERDA’s Energy Smart Schools Program against other New York schools?","Yes",null,"No"]
["Do you follow the U.S. Environmental Protection Agency’s ENERGY STAR® and U.S. Department of Energy’s FEMP purchasing standards?","No",null,"No"]
["Who manages the energy use for this building (Name and Title)?"]
[]
["Estimated electricity costs for current year (In Dollars):",35000,null,20000]
["Estimated natural gas costs for current year (In Dollars):",40000,null,0]
["Estimated fuel oil costs for current year (In Dollars):",0,null,18000]
["Estimated other energy costs for current year (In Dollars):",3000,null,5000]
["Estimated electricity consumption for next year (In kWh):",250000,null,400000]
["Estimated natural gas consumption for next year (In Therms):",200000,null,0]
["Estimated fuel oil consumption for next year (In Gallons):",0,null,40000]
["Estimated other energy consumption for next year (List Units Here):",0,null,0]
["What is the facility's goal to score in the Portfolio Manager in one year ?",60,null,60]
["What is the facility's goal to score in the Portfolio Manager in three years?",75,null,75]

{"sheet":"Current Projects","index":10,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[21,1,21,2],[5,1,5,2],[6,1,6,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[4,0,4,5],[2,0,2,5],[3,0,3,5],[0,0,0,5]]}
["Use this table to demonstrate the benefits of the major projects implementing in the District. Explain how major repairs, replacements, and energy-efficiency upgrades: reduce energy costs; reduce unnecessary repair/replacement costs by keeping equipment operating properly (life extension); improve occupant comfort, health, and indoor environmental quality; and reduce maintenance costs by replacing/upgrading equipment that requires frequent attention."]
[]
["Energy $mart Schools"]
[{"$f":"CONCATENATE(\"District: \",'General Info'!B8, \"           Prepared by: \",'General Info'!D7, \"           Date: \",TEXT('General Info'!B7,\"mm/dd/yyyy\"))","v":"District: Sample Town CSD           Prepared by: John Doe           Date: 02/01/2005"}]
["MAJOR PROJECTS DURING LAST YEAR"]
["SED # (if applicable)","Brief Project Description",null,"Project Dates","Costs","Project Benefits"]
["SED #00-00-00-00-0-000","Example: New Boiler Controls",null,"5/5/03 to 9/5/03",120000,"Reduce energy costs $150/year, eliminate frequent repairs."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["TOTAL",null,null,null,{"$f":"SUM(E7:E22)","v":120000}]

{"sheet":"Planned Projects","index":11,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,10],[2,0,2,10],[3,0,3,10],[4,0,4,10]]}
["In the table below, list all capital projects anticipated over the next five years. In the last column, indicate the benefits of the capital projects for the CMP by describing how they will lower energy costs, decrease annual service-and-repair costs, or improve life/health/safety conditions."]
[]
["Energy $mart Schools"]
[{"$f":"CONCATENATE(\"District: \",'General Info'!B8, \"           Prepared by: \",'General Info'!D7, \"           Date: \",TEXT('General Info'!B7,\"mm/dd/yyyy\"))","v":"District: Sample Town CSD           Prepared by: John Doe           Date: 02/01/2005"}]
["PLANNED CAPITAL PROJECTS"]
[" Facility Name","SED Number","Project Description","Year","Priority","Construction Type","Project Type","Funding Source","Cost","Annual Benefits","Notes"]
["Elementary Elementary School",43305439053,"New RTUs",2,1,"New Construction","Major System","Capital",30000]
["Elementary Elementary School",121212121234124,"New Windows",5,3,"Addition","Health/Safety","Capital",20000]
["Elementary Elementary School",34059384535,"Treat pest problems in 36 classrooms",2,3,"Alteration","Health/Safety","Bond",10000]
["Good Grades Middle School",121212121234124,"Example",1,2,"Alteration","Energy","Bond",15600,12000,"Lower energy costs, reduced service contract, and defer planned replacement (est repl cost $250K) by 5-8 years."]
["Good Grades Middle School",10294958771729,"Remove remaining asbestos",4,2,"Addition","Health/Safety","Capital",60000]
["Elementary Elementary School",3242309482,"Example",2,2,"Alteration","Major Repair","Bond",20000,4000]

{"sheet":"Facility Report Card","index":12,"n_rows":117,"n_cols":7,"rows_kept":117,"cut":false,"hidden":false,"merged":[[115,1,115,4],[38,5,38,6],[40,5,40,6],[41,1,41,2],[113,2,113,4],[97,0,97,4],[95,1,95,4],[96,1,96,4],[108,1,108,4],[109,1,109,4],[69,1,69,3],[38,1,38,2],[38,3,38,4],[59,0,59,6],[39,1,39,2],[39,3,39,4],[102,2,102,4],[93,1,93,4],[87,1,87,4],[88,1,88,4],[80,1,80,4],[98,1,98,4],[99,1,99,4],[100,1,100,4],[101,2,101,4],[79,1,79,4],[103,2,103,4],[114,2,114,4],[106,2,107,6],[105,1,105,4],[112,2,112,4],[111,1,111,4],[104,2,104,4],[110,1,110,4],[94,1,94,4],[0,0,0,6],[4,4,4,5],[92,0,92,4],[6,4,6,6],[14,1,14,2],[89,1,89,2],[90,2,91,6],[78,1,78,4],[37,1,37,2],[37,3,37,4],[37,5,37,6],[39,5,39,6],[82,1,82,4],[83,1,83,4],[86,1,86,4],[2,0,2,6],[7,2,7,4],[4,1,4,2],[5,1,5,6],[7,0,7,1],[6,1,6,2],[9,0,9,6],[36,3,36,6],[12,1,12,2],[44,1,44,2],[44,3,44,4],[44,5,44,6],[43,1,43,2],[42,3,42,4],[42,5,42,6],[42,1,42,2],[27,0,27,6],[35,3,35,6],[49,1,49,2],[13,1,13,2],[21,0,21,6],[29,1,30,6],[34,3,34,6],[41,5,41,6],[40,1,40,2],[40,3,40,4],[47,3,47,4],[47,5,47,6],[48,1,48,2],[48,3,48,4],[48,5,48,6],[116,1,116,4],[41,3,41,4],[49,3,49,4],[49,5,49,6],[43,3,43,4],[43,5,43,6],[45,1,45,2],[45,3,45,4],[45,5,45,6],[46,1,46,2],[46,3,46,4],[46,5,46,6],[50,1,50,2],[50,3,50,4],[50,5,50,6],[47,1,47,2]]}
["Instructions: Click on the yellow highlighted area, then use the drop-down menu to select the building name.  The form will fill itself out automatically. "]
[]
["School Facility Report Card"]
[]
["School District/BOCES:",{"$f":"'General Info'!B8","v":"Sample Town CSD"},null,"Building Name:","Example School 6",null,"<< Select to change school"]
["School Building Address:",{"$f":"CONCATENATE(HLOOKUP($E$5,'Facilities Inventory'!$A$4:$G$16,3,FALSE)&\" -- \"& HLOOKUP($E$5,'Facilities Inventory'!$A$4:$G$16,4,FALSE)&\", \"&HLOOKUP($E$5,'Facilities Inventory'!$A$4:$G$16,5,FALSE)&\" \"&HLOOKUP($E$5,'Facilities Inventory'!$A$4:$G$16,6,FALSE))","v":" -- ,  "}]
["Certificate of Occupancy Status:",{"$f":"HLOOKUP($E$5,'Facilities Inventory'!$A$19:$G$28,2,FALSE)","v":0},null,"Expiration Date:",{"$f":"HLOOKUP($E$5,'Facilities Inventory'!$A$19:$G$28,3,FALSE)","v":"00:00:00"}]
["Location where certificate of occupancy is posted:",null,{"$f":"HLOOKUP($E$5,'Facilities Inventory'!$A$19:$G$28,4,FALSE)","v":0}]
[]
["Section I: School Building General Information"]
["1. Person completing this School Facility Report Card:",null,{"$f":"'General Info'!D7","v":"John Doe"},"Date:",{"$f":"'General Info'!B7","v":"2005-02-01"}]
["2. Right-to-Know designee concerning this school building and School Facility Report Card:"]
["Name:",{"$f":"'General Info'!D7","v":"John Doe"},null,"Telephone:",{"$f":"'General Info'!D13","v":"999-999-9999"}]
["Position:",{"$f":"'General Info'!D8","v":"Superintendent of Buildings and Grounds"},null,"Fax:",{"$f":"'General Info'!D14","v":"888-888-8888"},"E-mail:",{"$f":"'General Info'!D15","v":"test@imagine.com"}]
["Address:",{"$f":"'General Info'!D9","v":"101 Main Street"},null,"City:",{"$f":"'General Info'!D10","v":"Albany"},"Zip:",{"$f":"'General Info'!D12","v":12345}]
["3.a. Original Construction Date (year):",{"$f":"HLOOKUP($E$5,'Facilities Inventory'!$A$4:$G$16,7,FALSE)","v":0}]
["3.b. Present size of school building (SF):",{"$f":"HLOOKUP($E$5,'Facilities Inventory'!$A$4:$G$16,8,FALSE)","v":0},"Number of floors:",{"$f":"HLOOKUP($E$5,'Facilities Inventory'!$A$4:$G$16,9,FALSE)","v":0},"Basement? (Yes/No):",{"$f":"HLOOKUP($E$5,'Facilities Inventory'!$A$4:$G$16,10,FALSE)","v":0}]
["4. Grade levels currently housed in this building: ",{"$f":"HLOOKUP($E$5,'Facilities Inventory'!$A$4:$G$16,13,FALSE)","v":0},null,null,"Current enrollment:",{"$f":"HLOOKUP($E$5,'Facilities Inventory'!$A$4:$G$16,11,FALSE)","v":0}]
["5. Upgrades to school building systems can be viewed on the Building Condition Survey?",null,null,null,{"$f":"HLOOKUP($E$5,'Facilities Inventory'!$A$19:$G$28,5,FALSE)","v":0}]
["6. Number of different types of program spaces currently in this school building can be viewed on the Building Condition Survey?",null,null,null,{"$f":"HLOOKUP($E$5,'Facilities Inventory'!$A$19:$G$28,6,FALSE)","v":0}]
[]
["Section II: School Building Ratings"]
["7. Date current 5-year building condition survey conducted:",null,null,null,{"$f":"HLOOKUP($E$5,'Facilities Inventory'!$A$19:$G$28,7,FALSE)","v":"00:00:00"}]
["          Overall school building safety rating from Building Condition Survey as certified by the Board of Education:",null,null,null,{"$f":"HLOOKUP($E$5,'Facilities Inventory'!$A$19:$G$28,8,FALSE)","v":0}]
["8. Date current year annual visual inspection conducted:",null,null,null,{"$f":"HLOOKUP($E$5,'Facilities Inventory'!$A$19:$G$28,9,FALSE)","v":"00:00:00"}]
["          Overall condition: ",null,null,null,{"$f":"HLOOKUP($E$5,'Facilities Inventory'!$A$19:$G$28,10,FALSE)","v":0}]
[]
["Section III: Building Capital, Maintenance, and Operations Information"]
["9. List any current unsatisfactory building systems that have not been corrected since the previous Building Condition Survey. (Add additional sheets as necessary)"]
[null,{"$f":"VLOOKUP($E$5,'Facilities Inventory'!A55:G60,2,FALSE)","v":"Building systems listed here."}]
[]
["10. Estimated remaining useful life of school building and systems can be viewed on the Building Condition Survey? (Yes/No)",null,null,null,null,{"$f":"HLOOKUP(E5,'Facilities Inventory'!A4:G32,26,FALSE)","v":0}]
["11. The need for routine maintenance, repairs, rehabilitation, reconstruction, and construction can be viewed on the Capital Facilities Plan? (Yes/No)",null,null,null,null,{"$f":"HLOOKUP(E5,'Facilities Inventory'!A4:G32,29,FALSE)","v":0}]
[null,"List prioritized health and safety improvements for this facility as indicated in the five year plan:"]
[null,"Year","Priority","Description"]
[]
[]
[null,"Estimated Costs to Restore Buildings to a State of Good Repair",null,"Estimated Annual Costs to Keep Buildings in a State of Good Repair",null,"Projected Budget for O&M Costs"]
[null,"Cost Estimate",null,"Cost Estimate",null,"Cost Estimate"]
["Site Elements",{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),1,1,MATCH($E$5,SchoolNames,0))","v":0},null,{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),1,3,MATCH($E$5,SchoolNames,0))","v":0},null,{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),1,5,MATCH($E$5,SchoolNames,0))","v":0}]
["Roofing",{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),2,1,MATCH($E$5,SchoolNames,0))","v":0},null,{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),2,3,MATCH($E$5,SchoolNames,0))","v":0},null,{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),2,5,MATCH($E$5,SchoolNames,0))","v":0}]
["Envelope Elements",{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),3,1,MATCH($E$5,SchoolNames,0))","v":0},null,{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),3,3,MATCH($E$5,SchoolNames,0))","v":0},null,{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),3,5,MATCH($E$5,SchoolNames,0))","v":0}]
["Structural Interior",{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),4,1,MATCH($E$5,SchoolNames,0))","v":0},null,{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),4,3,MATCH($E$5,SchoolNames,0))","v":0},null,{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),4,5,MATCH($E$5,SchoolNames,0))","v":0}]
["Elements/Finishes",{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),5,1,MATCH($E$5,SchoolNames,0))","v":0},null,{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),5,3,MATCH($E$5,SchoolNames,0))","v":0},null,{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),5,5,MATCH($E$5,SchoolNames,0))","v":0}]
["Electrical",{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),6,1,MATCH($E$5,SchoolNames,0))","v":0},null,{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),6,3,MATCH($E$5,SchoolNames,0))","v":0},null,{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),6,5,MATCH($E$5,SchoolNames,0))","v":0}]
["Plumbing",{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),7,1,MATCH($E$5,SchoolNames,0))","v":0},null,{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),7,3,MATCH($E$5,SchoolNames,0))","v":0},null,{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),7,5,MATCH($E$5,SchoolNames,0))","v":0}]
["HVAC",{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),8,1,MATCH($E$5,SchoolNames,0))","v":0},null,{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),8,3,MATCH($E$5,SchoolNames,0))","v":0},null,{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),8,5,MATCH($E$5,SchoolNames,0))","v":0}]
["Special Construction",{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),9,1,MATCH($E$5,SchoolNames,0))","v":0},null,{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),9,3,MATCH($E$5,SchoolNames,0))","v":0},null,{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),9,5,MATCH($E$5,SchoolNames,0))","v":0}]
["Emergency Systems (fire alarm, sprinklers, public address, etc.)",{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),10,1,MATCH($E$5,SchoolNames,0))","v":0},null,{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),10,3,MATCH($E$5,SchoolNames,0))","v":0},null,{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),10,5,MATCH($E$5,SchoolNames,0))","v":0}]
["Other",{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),11,1,MATCH($E$5,SchoolNames,0))","v":0},null,{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),11,3,MATCH($E$5,SchoolNames,0))","v":0},null,{"$f":"INDEX((Budgets!$B$23:$G$33,Budgets!$B$39:$G$49,Budgets!$B$55:$G$65,Budgets!$B$71:$G$81,Budgets!$B$87:$G$97,Budgets!$B$103:$G$113),11,5,MATCH($E$5,SchoolNames,0))","v":0}]
["TOTAL Estimated Cost",{"$f":"SUM(B40:B50)","v":0},null,{"$f":"SUM(D40:D50)","v":0},null,{"$f":"SUM(F40:F50)","v":0}]
[]
["12. Estimated energy costs for current school year by type:"]
[]
["Electricity:",{"$f":"HLOOKUP($E$5,Energy!$A$6:$M$17,9,FALSE)","v":0},"Gas:",{"$f":"HLOOKUP($E$5,Energy!$A$6:$M$17,11,FALSE)","v":0}]
["Fuel Oil:",{"$f":"HLOOKUP($E$5,Energy!$A$6:$M$17,10,FALSE)","v":0},"Other:",{"$f":"HLOOKUP($E$5,Energy!$A$6:$M$17,12,FALSE)","v":0}]
[]
["Total estimated energy costs:",{"$f":"SUM(B55:B56)+SUM(D55:D56)","v":0}]
[]
["Section IV: Health and Safety"]
["13. Description of Health and Safety Committee activities:",null,null,null,"Yes/No"]
[null,"a. Does the district have a health and safety committee?",null,null,{"$f":"'Health & Safety'!B5","v":"Yes"}]
[null,"b. Does the Health and Safety Committee have a chairperson?",null,null,{"$f":"'Health & Safety'!B6","v":"No"},"Name: ",{"$f":"'Health & Safety'!B7","v":"John Milton"}]
[null,"c. Phone number of Health and Safety Committee Chairperson:",null,null,{"$f":"'Health & Safety'!B8","v":"212-867-5309"},"Email:",{"$f":"'Health & Safety'!B9","v":"milty@school.com"}]
[null,"d. Basic Health and Safety Committee membership:"]
[null,"  - District Officials",null,null,{"$f":"'Health & Safety'!B11","v":"Yes"}]
[null,"  - Staff",null,null,{"$f":"'Health & Safety'!B12","v":"No"}]
[null,"  - Bargaining Units",null,null,{"$f":"'Health & Safety'!B13","v":"Yes"}]
[null,"  - Parents",null,null,{"$f":"'Health & Safety'!B14","v":"No"}]
[null,"e. Health and Safety Committee membership expanded during construction to include district officials, staff, bargaining units, parents and:"]
[null,"  - Project Architect",null,null,{"$f":"'Health & Safety'!B17","v":"Yes"}]
[null,"  - Project Engineer",null,null,{"$f":"'Health & Safety'!B18","v":"Yes"}]
[null,"  - Construction Manager",null,null,{"$f":"'Health & Safety'!B19","v":"No"}]
[null,"  - Contractors",null,null,{"$f":"'Health & Safety'!B20","v":"Yes"}]
[null,"f. Frequency of Health and Safety Committee meetings (check one):",null,null,{"$f":"'Health & Safety'!B21","v":"3-5 Times / School Year"}]
[]
["Section V: Environmental Awareness"]
["14. Lead testing:",null,null,null,null,null,"Yes/No"]
[null,"a. Has this building been tested for the presence of lead: paints, plumbing, etc.?",null,null,null,null,{"$f":"HLOOKUP($E$5,'Health & Safety'!$A$23:$G$33,3,FALSE)","v":0}]
[null,"b. Based on the testing results, are there elements in this building that would require construction or maintenance projects to be conducted in accordance with the US Department of Housing and Urban Development Guidelines for the Evaluation and Control of Lead Based Paint Hazards in Housing?",null,null,null,null,{"$f":"HLOOKUP($E$5,'Health & Safety'!$A$23:$G$33,4,FALSE)","v":0}]
[null,"c. If yes, has this type of work been done in accordance with the Guidelines?",null,null,null,null,{"$f":"HLOOKUP($E$5,'Health & Safety'!$A$23:$G$33,5,FALSE)","v":0}]
["15. Federal Asbestos Hazard Emergency Response Act (AHERA) Plan:"]
[null,"a. Does this building contain known or assumed asbestos containing building materials? (ACBM)",null,null,null,null,{"$f":"HLOOKUP($E$5,'Health & Safety'!$A$23:$G$33,6,FALSE)","v":0}]
[null,"b. If yes, has an original AHERA management plan been developed for this building? (The AHERA Management Plan for this building may be viewed at the main office during normal business hours).",null,null,null,null,{"$f":"HLOOKUP($E$5,'Health & Safety'!$A$23:$G$33,7,FALSE)","v":0}]
[null,"c. When was the AHERA management plan last updated?",null,null,null,null,{"$f":"HLOOKUP($E$5,'Health & Safety'!$A$23:$G$33,8,FALSE)","v":"00:00:00"}]
["16.  Radon testing:"]
[null,"a.       Has the district reviewed the geological potential for the presence of radon from the NYSDOH Radon Measurement Database?",null,null,null,null,{"$f":"HLOOKUP($E$5,'Health & Safety'!$A$23:$G$33,9,FALSE)","v":0}]
[null,"b.      Did the geological potential indicate testing this facility was necessary?",null,null,null,null,{"$f":"HLOOKUP($E$5,'Health & Safety'!$A$23:$G$33,10,FALSE)","v":0}]
[null,"c.       If yes, did the highest test in this building exceed 4pCi/L?",null,null,null,null,{"$f":"HLOOKUP($E$5,'Health & Safety'!$A$23:$G$33,11,FALSE)","v":0}]
[null,"d.      If yes, describe mitigation activities:"]
[null,null,{"$f":"VLOOKUP($E$5,'Health & Safety'!$A$35:$G$40,2,FALSE)","v":"Mitigation activities described here."}]
[]
["17.  Integrated Pest Management Program:"]
[null,"a.      Does this school have an integrated pest management program?",null,null,null,null,{"$f":"HLOOKUP($E$5,'Integrated Pest Management'!$B$6:$G$11,3,FALSE)","v":0}]
[null,"b.      Does this school have a person designated to oversee the pest management program?",null,null,null,null,{"$f":"HLOOKUP($E$5,'Integrated Pest Management'!$B$6:$G$11,4,FALSE)","v":0}]
[null,"c.       Has this school established a list of persons to notify at least 48 hours prior to the application of pesticides?",null,null,null,null,{"$f":"HLOOKUP($E$5,'Integrated Pest Management'!$B$6:$G$11,5,FALSE)","v":0}]
[null,"d.      Have pesticide application summary reports been provided to all parents and staff pursuant to CR 155.24?",null,null,null,null,{"$f":"HLOOKUP($E$5,'Integrated Pest Management'!$B$6:$G$11,6,FALSE)","v":0}]
["18.  Status of measures taken to assure acceptable indoor air quality:"]
[null,"a.       Does this school utilize the EPA Indoor Air Quality Tools for Schools Action Kit?",null,null,null,null,{"$f":"HLOOKUP($E$5,'Indoor Environment Quality'!$B$6:$G$29,3,FALSE)","v":0}]
[null,"b.      Does this school have a procedure in place for reporting indoor air quality concerns?",null,null,null,null,{"$f":"HLOOKUP($E$5,'Indoor Environment Quality'!$B$6:$G$29,4,FALSE)","v":0}]
[null,"c.       Is ventilation with outdoor air available in all occupied spaces?",null,null,null,null,{"$f":"HLOOKUP($E$5,'Indoor Environment Quality'!$B$6:$G$29,5,FALSE)","v":0}]
[null,null,"1.      Is all ventilation and exhaust equipment operational?",null,null,null,{"$f":"HLOOKUP($E$5,'Indoor Environment Quality'!$B$6:$G$29,6,FALSE)","v":0}]
[null,null,"2.      Are all outdoor air intakes unobstructed and clear of foreign objects?",null,null,null,{"$f":"HLOOKUP($E$5,'Indoor Environment Quality'!$B$6:$G$29,7,FALSE)","v":0}]
[null,null,"3.      Are all outside air damper controls in place and operational?",null,null,null,{"$f":"HLOOKUP($E$5,'Indoor Environment Quality'!$B$6:$G$29,8,FALSE)","v":0}]
[null,null,"4.      Have facilities operations been reviewed with respect to impact on outside air intakes (i.e., vehicle emissions, waste storage, mowing, etc.)?",null,null,null,{"$f":"HLOOKUP($E$5,'Indoor Environment Quality'!$B$6:$G$29,9,FALSE)","v":0}]
[null,"d.      Are there any unresolved complaints regarding indoor air at this facility?",null,null,null,null,{"$f":"HLOOKUP($E$5,'Indoor Environment Quality'!$B$6:$G$29,10,FALSE)","v":0}]
[null,"If yes, describe:",{"$f":"VLOOKUP($E$5,'Indoor Environment Quality'!$A$17:$G$22,2,FALSE)","v":"IEQ description here."}]
[]
[null,"e.       Maintenance:  Heating, ventilation, and air conditioning equipment are cleaned and maintained in accordance with manufacturer’s instructions (i.e., filter changes, coils cleaned, etc.)",null,null,null,null,{"$f":"HLOOKUP($E$5,'Indoor Environment Quality'!$B$6:$G$29,18,FALSE)","v":0}]
[null,"f.        Has the interior of ductwork (air passageways) been inspected for cleanliness?",null,null,null,null,{"$f":"HLOOKUP($E$5,'Indoor Environment Quality'!$B$6:$G$29,19,FALSE)","v":0}]
[null,"g.       Have exterior ductwork and rooftop air handling units been inspected for leaks?",null,null,null,null,{"$f":"HLOOKUP($E$5,'Indoor Environment Quality'!$B$6:$G$29,20,FALSE)","v":0}]
[null,"h.       Operations and maintenance program:"]
[null,null,"1.      Does the District have a policy encouraging the use of environmentally friendly products?",null,null,null,{"$f":"HLOOKUP($E$5,'Indoor Environment Quality'!$B$6:$G$29,21,FALSE)","v":0}]
[null,null,"2.      Products entering a school building are reviewed with the intent of reducing or eliminating hazardous chemicals, including volatile organic compounds (VOCs), semi-volatile organic compounds, etc. (cleaning supplies, repair and maintenance supplies, materials, etc.).",null,null,null,{"$f":"HLOOKUP($E$5,'Indoor Environment Quality'!$B$6:$G$29,22,FALSE)","v":0}]
[null,null,"3.      Review performed to ensure hazardous chemicals used as part of instructional program are used and stored properly.",null,null,null,{"$f":"HLOOKUP($E$5,'Indoor Environment Quality'!$B$6:$G$29,23,FALSE)","v":0}]
[null,"i.   Buildings are inspected for roof leaks, growth of mold, evidence of rodent infiltration, and other potential problems to acceptable IAQ.",null,null,null,null,{"$f":"HLOOKUP($E$5,'Indoor Environment Quality'!$B$6:$G$29,24,FALSE)","v":0}]
[null,"j.  Is this facility seeking to comply with a whole building sustainable guideline, such as the U.S. Green Building Council's LEED® for Existing Buildings?",null,null,null,null,{"$f":"HLOOKUP($E$5,'Indoor Environment Quality'!$B$6:$G$36,30,FALSE)","v":0}]

{"sheet":"5 Year Cap Plan, Part 1","index":13,"n_rows":158,"n_cols":8,"rows_kept":158,"cut":false,"hidden":false,"merged":[[134,0,134,7],[92,0,92,7],[113,3,113,4],[114,1,114,2],[115,1,115,2],[123,1,123,2],[98,1,98,6],[117,1,117,2],[118,1,118,2],[119,1,119,2],[85,0,85,1],[88,0,88,1],[85,2,87,7],[82,0,82,1],[19,0,19,7],[40,0,40,7],[43,0,43,7],[67,0,67,7],[69,0,69,7],[70,0,70,7],[73,0,73,1],[76,0,76,1],[79,0,79,1],[120,1,120,2],[116,1,116,2],[116,3,116,4],[114,3,114,4],[115,3,115,4],[117,3,117,4],[118,3,118,4],[119,3,119,4],[120,3,120,4],[121,3,121,4],[122,3,122,4],[123,3,123,4],[124,3,124,4],[122,1,122,2],[121,1,121,2],[124,1,124,2],[0,0,0,7],[8,0,8,7],[9,0,9,7],[39,0,39,7],[113,1,113,2],[88,2,90,7],[72,0,72,1],[71,0,71,7],[2,0,2,7],[73,2,75,7],[76,2,78,7],[79,2,81,7],[96,0,96,1],[96,2,96,5],[82,2,84,7],[94,2,94,5]]}
["This tab is used to print parts of the 5-Year Capital Facilities Plan. You do not need to enter any data here. You can preview or print this tab, however, if you want to see how this material will look in the final Capital Plan Report."]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"'General Info'!B8","v":"Sample Town CSD"}]
[{"$f":"'General Info'!B9","v":"Valley View BOCES"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Five-Year Capital Facilities Plan"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Submitted/Revised"]
[{"$f":"'General Info'!B7","v":"2005-02-01"}]
[]
[]
["Table of Contents"]
["Item",null,null,null,null,null,null,"Page"]
[]
["Executive Summary",null,null,null,null,null,null,1]
[]
["Building Inventories"]
[null,{"$f":"'Facilities Inventory'!$B$4","v":"Elementary Elementary School"},null,null,null,null,null,{"$f":"H47+1","v":2}]
[null,{"$f":"IF('Facilities Inventory'!$C$4<>\"\",'Facilities Inventory'!$C$4,\"\")","v":"Good Grades Middle School"},null,null,null,null,null,{"$f":"IF(B51<>\"\",H50+1,\"\")","v":3}]
[null,{"$f":"IF('Facilities Inventory'!$D$4<>\"\",'Facilities Inventory'!$D$4,\"\")","v":"Example School 3"},null,null,null,null,null,{"$f":"IF(B52<>\"\",H51+1,\"\")","v":4}]
[null,{"$f":"IF('Facilities Inventory'!$E$4<>\"\",'Facilities Inventory'!$E$4,\"\")","v":"Example School 4"},null,null,null,null,null,{"$f":"IF(B53<>\"\",H52+1,\"\")","v":5}]
[null,{"$f":"IF('Facilities Inventory'!$F$4<>\"\",'Facilities Inventory'!$F$4,\"\")","v":"Example School 5"},null,null,null,null,null,{"$f":"IF(B54<>\"\",H53+1,\"\")","v":6}]
[null,{"$f":"IF('Facilities Inventory'!$G$4<>\"\",'Facilities Inventory'!$G$4,\"\")","v":"Example School 6"},null,null,null,null,null,{"$f":"IF(B55<>\"\",H54+1,\"\")","v":7}]
[]
["District Analysis and Prioritization",null,null,null,null,null,null,{"$f":"IF(H55=\"\",IF(H54=\"\",IF(H53=\"\",IF(H52=\"\",IF(H51=\"\",H50+1,H51+1),H52+1),H53+1),H54+1),H55+1)","v":8}]
[]
["Estimated Expenses"]
[null,{"$f":"'Facilities Inventory'!$B$4","v":"Elementary Elementary School"},null,null,null,null,null,{"$f":"H57+1","v":9}]
[null,{"$f":"IF('Facilities Inventory'!$C$4<>\"\",'Facilities Inventory'!$C$4,\"\")","v":"Good Grades Middle School"},null,null,null,null,null,{"$f":"IF(B61<>\"\",H60+1,\"\")","v":10}]
[null,{"$f":"IF('Facilities Inventory'!$D$4<>\"\",'Facilities Inventory'!$D$4,\"\")","v":"Example School 3"},null,null,null,null,null,{"$f":"IF(B62<>\"\",H61+1,\"\")","v":11}]
[null,{"$f":"IF('Facilities Inventory'!$E$4<>\"\",'Facilities Inventory'!$E$4,\"\")","v":"Example School 4"},null,null,null,null,null,{"$f":"IF(B63<>\"\",H62+1,\"\")","v":12}]
[null,{"$f":"IF('Facilities Inventory'!$F$4<>\"\",'Facilities Inventory'!$F$4,\"\")","v":"Example School 5"},null,null,null,null,null,{"$f":"IF(B64<>\"\",H63+1,\"\")","v":13}]
[null,{"$f":"IF('Facilities Inventory'!$G$4<>\"\",'Facilities Inventory'!$G$4,\"\")","v":"Example School 6"},null,null,null,null,null,{"$f":"IF(B65<>\"\",H64+1,\"\")","v":14}]
[]
[]
["Executive Summary"]
[]
["Following are the people who prepared this plan and the resources used:"]
[{"$f":"'General Info'!$A$17","v":"People and resources here."}]
["Following is a narrative of the general conditions of each facility:"]
["Facility Name",null,"Narrative"]
[{"$f":"'Facilities Inventory'!B4","v":"Elementary Elementary School"},null,{"$f":"'CMP Overview'!B8","v":"Insert assessment here…"}]
[]
[]
[{"$f":"'Facilities Inventory'!C4","v":"Good Grades Middle School"},null,{"$f":"'CMP Overview'!B9","v":"Insert assessment here…"}]
[]
[]
[{"$f":"'Facilities Inventory'!D4","v":"Example School 3"},null,{"$f":"'CMP Overview'!B10","v":"Insert assessment here…"}]
[]
[]
[{"$f":"'Facilities Inventory'!E4","v":"Example School 4"},null,{"$f":"'CMP Overview'!B11","v":"Insert assessment here…"}]
[]
[]
[{"$f":"'Facilities Inventory'!F4","v":"Example School 5"},null,{"$f":"'CMP Overview'!B12","v":"Insert assessment here…"}]
[]
[]
[{"$f":"'Facilities Inventory'!G4","v":"Example School 6"},null,{"$f":"'CMP Overview'!B13","v":"Insert assessment here…"}]
[]
[]
[]
["Building Inventory Form"]
[]
["Building Name:",null,"Example School 6"]
[]
["Bed Codes Number:",null,{"$f":"HLOOKUP(C95,'Facilities Inventory'!B4:G5,2,FALSE)","v":0}]
[]
["Address: ",{"$f":"CONCATENATE(HLOOKUP($C$95,'Facilities Inventory'!$A$4:$G$16,3,FALSE)&\" -- \"& HLOOKUP($C$95,'Facilities Inventory'!$A$4:$G$16,4,FALSE)&\", \"&HLOOKUP($C$95,'Facilities Inventory'!$A$4:$G$16,5,FALSE)&\" \"&HLOOKUP($C$95,'Facilities Inventory'!$A$4:$G$16,6,FALSE))","v":" -- ,  "}]
[]
["Use:",null,{"$f":"HLOOKUP($C$95,'Facilities Inventory'!$A$4:$G$60,13,FALSE)","v":0},null,"Current enrollment:",null,null,{"$f":"HLOOKUP($C$95,'Facilities Inventory'!$A$4:$G$60,11,FALSE)","v":0}]
[]
["Total square footage:",null,{"$f":"HLOOKUP($C$95,'Facilities Inventory'!$A$4:$G$60,8,FALSE)","v":0},null,"Rated Capacity:",null,null,{"$f":"HLOOKUP($C$95,'Facilities Inventory'!$A$4:$G$60,12,FALSE)","v":0}]
[]
[]
["Ownership:",null,null,{"$f":"HLOOKUP($C$95,'Facilities Inventory'!$A$4:$G$60,14,FALSE)","v":0}]
[]
[]
["Building Condition Survey Rating:",null,null,{"$f":"HLOOKUP($C$95,'Facilities Inventory'!$A$4:$G$60,23,FALSE)","v":0}]
[]
[]
["Building Age:"]
[]
[null,"Construction Year",null,"Square Footage"]
["Original",{"$f":"HLOOKUP($C$95,'Facilities Inventory'!$B$4:$G$53,7,FALSE)","v":0},null,{"$f":"HLOOKUP($C$95,'Facilities Inventory'!$B$4:$G$53,30,FALSE)","v":0}]
["Addition #1",{"$f":"HLOOKUP($C$95,'Facilities Inventory'!$B$4:$G$53,31,FALSE)","v":0},null,{"$f":"HLOOKUP($C$95,'Facilities Inventory'!$B$4:$G$53,32,FALSE)","v":0}]
["Addition #2",{"$f":"HLOOKUP($C$95,'Facilities Inventory'!$B$4:$G$53,33,FALSE)","v":0},null,{"$f":"HLOOKUP($C$95,'Facilities Inventory'!$B$4:$G$53,34,FALSE)","v":0}]
["Addition #3",{"$f":"HLOOKUP($C$95,'Facilities Inventory'!$B$4:$G$53,35,FALSE)","v":0},null,{"$f":"HLOOKUP($C$95,'Facilities Inventory'!$B$4:$G$53,36,FALSE)","v":0}]
["Addition #4",{"$f":"HLOOKUP($C$95,'Facilities Inventory'!$B$4:$G$53,37,FALSE)","v":0},null,{"$f":"HLOOKUP($C$95,'Facilities Inventory'!$B$4:$G$53,38,FALSE)","v":0}]
["Addition #5",{"$f":"HLOOKUP($C$95,'Facilities Inventory'!$B$4:$G$53,39,FALSE)","v":0},null,{"$f":"HLOOKUP($C$95,'Facilities Inventory'!$B$4:$G$53,40,FALSE)","v":0}]
["Addition #6",{"$f":"HLOOKUP($C$95,'Facilities Inventory'!$B$4:$G$53,41,FALSE)","v":0},null,{"$f":"HLOOKUP($C$95,'Facilities Inventory'!$B$4:$G$53,42,FALSE)","v":0}]
["Addition #7",{"$f":"HLOOKUP($C$95,'Facilities Inventory'!$B$4:$G$53,43,FALSE)","v":0},null,{"$f":"HLOOKUP($C$95,'Facilities Inventory'!$B$4:$G$53,44,FALSE)","v":0}]
["Addition #8",{"$f":"HLOOKUP($C$95,'Facilities Inventory'!$B$4:$G$53,45,FALSE)","v":0},null,{"$f":"HLOOKUP($C$95,'Facilities Inventory'!$B$4:$G$53,46,FALSE)","v":0}]
["Addition #9",{"$f":"HLOOKUP($C$95,'Facilities Inventory'!$B$4:$G$53,47,FALSE)","v":0},null,{"$f":"HLOOKUP($C$95,'Facilities Inventory'!$B$4:$G$53,48,FALSE)","v":0}]
["Addition #10",{"$f":"HLOOKUP($C$95,'Facilities Inventory'!$B$4:$G$53,49,FALSE)","v":0},null,{"$f":"HLOOKUP($C$95,'Facilities Inventory'!$B$4:$G$53,50,FALSE)","v":0}]
[]
[]
["Heating System Energy Source:  ",null,null,{"$f":"HLOOKUP($C$95,'Facilities Inventory'!$A$4:$G$60,15,FALSE)","v":0}]
[]
["Energy Consumption:",null,{"$f":"HLOOKUP($C$95,Energy!$A$6:$M$21,13,FALSE)","v":0},"kWh (electricity)",null,{"$f":"HLOOKUP($C$95,Energy!$A$6:$M$21,14,FALSE)","v":0},"therms (natural gas)"]
["(per year)",null,{"$f":"HLOOKUP($C$95,Energy!$A$6:$M$21,15,FALSE)","v":0},"gallons (fuel oil)",null,{"$f":"HLOOKUP($C$95,Energy!$A$6:$M$21,16,FALSE)","v":0},"units (other)"]
[]
["Probable Useful Life of Building:",null,{"$f":"HLOOKUP($C$95,'Facilities Inventory'!$A$4:$G$60,27,FALSE)","v":0},{"$f":"\" years\"","v":" years"},"Estimated Replacement Value:",null,null,{"$f":"HLOOKUP($C$95,'Facilities Inventory'!$A$4:$G$60,28,FALSE)","v":0}]
[]
["District-Wide Analysis and Prioritization"]
["District:",{"$f":"'General Info'!B8","v":"Sample Town CSD"}]
["Year 1","SED Number","Priority",null,"Facility Name",null,null,"Costs"]
[null,121212121234124,2,null,"Good Grades Middle School",null,null,15600]
[]
[null,null,null,null,null,null,"Year Total",{"$f":"SUM(H137:H139)","v":15600}]
["Year 2","SED Number","Priority",null,"Facility Name",null,null,"Costs"]
[null,3242309482,2,null,"Elementary Elementary School",null,null,20000]
[null,34059384535,3,null,"Elementary Elementary School",null,null,10000]
[null,43305439053,1,null,"Elementary Elementary School",null,null,30000]
[]
[null,null,null,null,null,null,"Year Total",{"$f":"SUM(H141:H145)","v":60000}]
["Year 3","SED Number","Priority",null,"Facility Name",null,null,"Costs"]
[]
[null,null,null,null,null,null,"Year Total",{"$f":"SUM(H147:H148)","v":0}]
["Year 4","SED Number","Priority",null,"Facility Name",null,null,"Costs"]
[null,10294958771729,2,null,"Good Grades Middle School",null,null,60000]
[]
[null,null,null,null,null,null,"Year Total",{"$f":"SUM(H150:H152)","v":60000}]
["Year 5","SED Number","Priority",null,"Facility Name",null,null,"Costs"]
[null,121212121234124,3,null,"Elementary Elementary School",null,null,20000]
[]
[null,null,null,null,null,null,"Year Total",{"$f":"SUM(H154:H156)","v":20000}]
[null,null,null,null,null,null,"District Total",{"$f":"H157+H153+H149+H146+H140","v":155600}]

{"sheet":"5 Year Cap Plan, Part 2","index":14,"n_rows":22,"n_cols":13,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,0,1,12],[0,0,0,12],[2,0,2,12]]}
["Instructions: If you want to view or print capital data for a single school, click the dropdown button to fill in data for one school. You do not need to enter any data on this form because it is brought in from other tabs."]
["Facility Estimated Expenses"]
[]
["District:",null,{"$f":"'General Info'!B8","v":"Sample Town CSD"}]
["Facility Name:",null,"Example School 6","<< select to change school"]
[null,null,null,null,"New Construction","Addition","Alterations","Major System","Major Repair","Energy","Bond","Capital"]
["Year 1","Priority","SED #","Item Description",null,null,null,null,null,null,null,null,"Cost"]
[]
[null,null,null,null,null,null,null,null,null,null,"Year Total",null,{"$f":"SUM(M7:M8)","v":0}]
["Year 2","Priority","SED #","Item Description",null,null,null,null,null,null,null,null,"Cost"]
[]
[null,null,null,null,null,null,null,null,null,null,"Year Total",null,{"$f":"SUM(M10:M11)","v":0}]
["Year 3","Priority","SED #","Item Description",null,null,null,null,null,null,null,null,"Cost"]
[]
[null,null,null,null,null,null,null,null,null,null,"Year Total",null,{"$f":"SUM(M13:M14)","v":0}]
["Year 4","Priority","SED #","Item Description",null,null,null,null,null,null,null,null,"Cost"]
[]
[null,null,null,null,null,null,null,null,null,null,"Year Total",null,{"$f":"SUM(M16:M17)","v":0}]
["Year 5","Priority","SED #","Item Description",null,null,null,null,null,null,null,null,"Cost"]
[]
[null,null,null,null,null,null,null,null,null,null,"Year Total",null,{"$f":"SUM(M19:M20)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Facility Total",null,{"$f":"M9+M12+M15+M18+M21","v":0}]

{"sheet":"App A Equip Inventory","index":15,"n_rows":204,"n_cols":16,"rows_kept":204,"cut":false,"hidden":false,"merged":[[0,0,0,12],[4,0,4,15],[1,0,1,15],[2,0,2,15],[3,0,3,15]]}
["You can use the following Equipment Inventory to help start your PM system. This page helps you keep track of all your equipment and matches the equipment on the following PM Log page. You can expand the table as needed by adding rows.  BE SURE TO COPY THE TAB AS NEEDED FOR EACH SCHOOL. "]
["Energy $mart Schools"]
["Comprehensive Maintenance Plan (CMP)"]
[{"$f":"CONCATENATE(\"District: \",'General Info'!B8, \"           Prepared by: \",'General Info'!D7, \"           Date: \",TEXT('General Info'!B7,\"mm/dd/yyyy\"))","v":"District: Sample Town CSD           Prepared by: John Doe           Date: 02/01/2005"}]
["Equipment Inventory"]
["School: ________________________________",null,null,"Date Updated: ____________________________"]
[]
["Heating Systems","P.M. Ref #","Manufacturer","Model #","Serial #","Size","Fuel Type","Efficiency Rating","Number in Building","Installation Date","Expected Service Life (yrs)","Location","Suggested Maint Interval (# per year)","Special Tools Required","Annual Maintenance Cost ($)","Notes"]
["Boilers","HS 2004-01","IBR","K500-B","123-456-78","500,000 Btu","Gas",0.75,2,"1977, 1992",35,"Boiler room next to loading dock",4,"No. 14 3-headed left-handed propane-powered pneumatic sprocket ",1200]
["Furnaces"]
["Condenser pumps"]
["Deaerator tank"]
["Steam traps"]
["Steam valves"]
["Fuel tanks & distribution"]
["Heat exchangers"]
["Terminal/package units"]
["Fin tubes/radiators"]
["Dampers/draft control"]
["Ductwork"]
["Stacks"]
["Insulation"]
["Piping"]
["Valves"]
[" Control sensors"]
[]
["Air Handling Systems","P.M. Ref #","Manufacturer","Model #","Serial #","Size","Fuel Type","Efficiency Rating","Number in Building","Installation Date","Expected Service Life (yrs)","Location","Suggested Maint Interval (# per year)","Special Tools Required","Annual Maintenance Cost ($)","Notes"]
["Air handling units"]
["Unit ventilators"]
["Fans"]
["Fire dampers"]
["Filters"]
["Humidifiers"]
[]
["Cooling Systems","P.M. Ref #","Manufacturer","Model #","Serial #","Size","Fuel Type","Efficiency Rating","Number in Building","Installation Date","Expected Service Life (yrs)","Location","Suggested Maint Interval (# per year)","Special Tools Required","Annual Maintenance Cost ($)","Notes"]
["Condensing units"]
["Air compressors"]
["Heat exchangers"]
["Packaged A/C units"]
["Chillers"]
["CHW Pumps"]
[" Heat pumps"]
[]
["Fire Protection/ Suppression Systems","P.M. Ref #","Manufacturer","Model #","Serial #","Size","Fuel Type","Efficiency Rating","Number in Building","Installation Date","Expected Service Life (yrs)","Location","Suggested Maint Interval (# per year)","Special Tools Required","Annual Maintenance Cost ($)","Notes"]
["Sprinkler piping"]
["Backflow preventers"]
["Sprinkler heads"]
["Fire extinguishers"]
["Fire hose system"]
["Standpipe connection"]
["Fire pumps"]
["Grease hood extinguisher"]
["Alarms and detectors"]
[]
["Mechanical Controls","P.M. Ref #","Manufacturer","Model #","Serial #","Size","Fuel Type","Efficiency Rating","Number in Building","Installation Date","Expected Service Life (yrs)","Location","Suggested Maint Interval (# per year)","Special Tools Required","Annual Maintenance Cost ($)","Notes"]
["Compressors"]
["Pneumatic valves/levers"]
["Pneumatic tubing"]
["Electronic controls"]
[]
["Plumbing Systems","P.M. Ref #","Manufacturer","Model #","Serial #","Size","Fuel Type","Efficiency Rating","Number in Building","Installation Date","Expected Service Life (yrs)","Location","Suggested Maint Interval (# per year)","Special Tools Required","Annual Maintenance Cost ($)","Notes"]
["Cold water piping"]
["Water heaters"]
["Hot water piping"]
["Circulation pumps"]
["Sump pumps"]
["Valves and traps"]
["Septic tanks"]
[]
["Lighting Systems","P.M. Ref #","Manufacturer","Model #","Serial #","Size","Fuel Type","Efficiency Rating","Number in Building","Installation Date","Expected Service Life (yrs)","Location","Suggested Maint Interval (# per year)","Special Tools Required","Annual Maintenance Cost ($)","Notes"]
["Fluorescent fixtures"]
["Incandescent fixtures"]
["HID fixtures"]
["Lighting panels"]
["Emergency lighting"]
["Exterior lighting"]
["Occupancy controls"]
["Daylight controls"]
["Other controls"]
[]
["Signal Systems","P.M. Ref #","Manufacturer","Model #","Serial #","Size","Fuel Type","Efficiency Rating","Number in Building","Installation Date","Expected Service Life (yrs)","Location","Suggested Maint Interval (# per year)","Special Tools Required","Annual Maintenance Cost ($)","Notes"]
["Computer data"]
["Public address"]
["Television"]
["Telephone"]
["Clock system"]
["Fire alarms"]
["Security alarm/devices"]
[]
["Foundation and Substructure","P.M. Ref #","Manufacturer","Model #","Serial #","Size","Fuel Type","Efficiency Rating","Number in Building","Installation Date","Expected Service Life (yrs)","Location","Suggested Maint Interval (# per year)","Special Tools Required","Annual Maintenance Cost ($)","Notes"]
["Footings"]
["Foundation walls"]
["Slab/beams on grade"]
["Piling/Posts How?"]
["Waterproofing  How?"]
["Insulation"]
["Underdrains  How?"]
[]
["Superstructure","P.M. Ref #","Manufacturer","Model #","Serial #","Size","Fuel Type","Efficiency Rating","Number in Building","Installation Date","Expected Service Life (yrs)","Location","Suggested Maint Interval (# per year)","Special Tools Required","Annual Maintenance Cost ($)","Notes"]
["Columns"]
["Beams"]
["Floor structure"]
["Roof structure"]
["Monolithic bearing walls"]
["Stairs and railings"]
["Structural bracing"]
["Welds/connectors"]
[]
[]
["Roof Systems","P.M. Ref #","Manufacturer","Model #","Serial #","Size","Fuel Type","Efficiency Rating","Number in Building","Installation Date","Expected Service Life (yrs)","Location","Suggested Maint Interval (# per year)","Special Tools Required","Annual Maintenance Cost ($)","Notes"]
["Roofing"]
["Insulation"]
["Paving and ballast  Paving?  On a roof?"]
["Curbs/supports"]
["Expansion/seismic joints"]
["Drains, gutters, etc."]
["Drywells"]
["Flashing and trim"]
["Fasteners"]
["Snow stops"]
["Roof openings"]
["Parapet caps"]
[]
["Exterior Wall Systems","P.M. Ref #","Manufacturer","Model #","Serial #","Size","Fuel Type","Efficiency Rating","Number in Building","Installation Date","Expected Service Life (yrs)","Location","Suggested Maint Interval (# per year)","Special Tools Required","Annual Maintenance Cost ($)","Notes"]
["Facade integrity"]
["Cladding/sheathing"]
["Doors"]
["Window systems"]
["Balcony walls/railings"]
["Louvers and screens"]
["Expansion/seismic joints"]
["Insulation"]
["Protective coating"]
["Sealants"]
[]
["Interior Construction","P.M. Ref #","Manufacturer","Model #","Serial #","Size","Fuel Type","Efficiency Rating","Number in Building","Installation Date","Expected Service Life (yrs)","Location","Suggested Maint Interval (# per year)","Special Tools Required","Annual Maintenance Cost ($)","Notes"]
["Fixed partitions"]
["Demountable partitions"]
["Retractable partitions"]
["Doors"]
["Carpet"]
["Resilient tile/sheet"]
["Ceramic/clay tile"]
["Terrazzo"]
["Paint"]
["Vinyl/fabric wall cover"]
["Ceiling system"]
[]
["Power Generation ","P.M. Ref #","Manufacturer","Model #","Serial #","Size","Fuel Type","Efficiency Rating","Number in Building","Installation Date","Expected Service Life (yrs)","Location","Suggested Maint Interval (# per year)","Special Tools Required","Annual Maintenance Cost ($)","Notes"]
["Generators"]
["Transfer switches"]
["Transformers"]
["Service wiring"]
["Substation"]
["Switchgear"]
["Overcurrent protection"]
[]
["Power Distribution Systems","P.M. Ref #","Manufacturer","Model #","Serial #","Size","Fuel Type","Efficiency Rating","Number in Building","Installation Date","Expected Service Life (yrs)","Location","Suggested Maint Interval (# per year)","Special Tools Required","Annual Maintenance Cost ($)","Notes"]
["Main distribution panel"]
["Wiring, conduits, & distribution panels"]
["Electrical receptacles"]
["Circuit breakers"]
["Electric baseboard heaters"]
["Heat trace"]
[]
["Landscaping Systems","P.M. Ref #","Manufacturer","Model #","Serial #","Size","Fuel Type","Efficiency Rating","Number in Building","Installation Date","Expected Service Life (yrs)","Location","Suggested Maint Interval (# per year)","Special Tools Required","Annual Maintenance Cost ($)","Notes"]
["Irrigation"]
["Tree/shrub/flower bed plantings"]
["Turf/lawn"]
["Walks/plazas"]
[]
["Playfields and Playground Systems","P.M. Ref #","Manufacturer","Model #","Serial #","Size","Fuel Type","Efficiency Rating","Number in Building","Installation Date","Expected Service Life (yrs)","Location","Suggested Maint Interval (# per year)","Special Tools Required","Annual Maintenance Cost ($)","Notes"]
["Athletic fields"]
["Hard surface courts"]
["Swings"]
["Safety mats"]
["Gravel and containment"]
["Markings/painting"]
[]
["Vehicular Systems","P.M. Ref #","Manufacturer","Model #","Serial #","Size","Fuel Type","Efficiency Rating","Number in Building","Installation Date","Expected Service Life (yrs)","Location","Suggested Maint Interval (# per year)","Special Tools Required","Annual Maintenance Cost ($)","Notes"]
["Parking lots"]
["Roads/drives"]
["Curbs"]
["Fire lanes"]
[]
["Site Utilities","P.M. Ref #","Manufacturer","Model #","Serial #","Size","Fuel Type","Efficiency Rating","Number in Building","Installation Date","Expected Service Life (yrs)","Location","Suggested Maint Interval (# per year)","Special Tools Required","Annual Maintenance Cost ($)","Notes"]
["Fuel tanks"]
["Fuel distribution piping"]
["Storm drainage"]
["Fire hydrant systems"]
[]
["Specialties","P.M. Ref #","Manufacturer","Model #","Serial #","Size","Fuel Type","Efficiency Rating","Number in Building","Installation Date","Expected Service Life (yrs)","Location","Suggested Maint Interval (# per year)","Special Tools Required","Annual Maintenance Cost ($)","Notes"]
["Toilet partitions"]
["Display boards"]
["Projection screens"]
["Display cases"]
["Lockers"]
["Elevators"]
["Waste handling equipment"]
["Food service equipment"]
["Woodworking shop equipment"]
["Auto/engine shop equipment"]
["Vaults"]
["Swimming pools"]

{"sheet":"App B PM Checklist & Log","index":16,"n_rows":207,"n_cols":16,"rows_kept":207,"cut":false,"hidden":false,"merged":[[0,0,0,15],[4,0,4,15],[1,0,1,15],[2,0,2,15],[3,0,3,15]]}
["Use the following checklist and log to help keep track of your PM activities and to demonstrate the proper maintenance you perform in each building in your District. This will also help justify your expenses for PM and your capital expenses for equipment that has had proper maintenance over the years.  Check the appropriate box to indicate the month that each PM action was accomplished.  The table will expand as needed.  BE SURE TO COPY THE TAB AS NEEDED FOR EACH SCHOOL."]
["Energy $mart Schools"]
["Comprehensive Maintenance Plan (CMP)"]
[{"$f":"CONCATENATE(\"District: \",'General Info'!B8, \"           Prepared by: \",'General Info'!D7, \"           Date: \",TEXT('General Info'!B7,\"mm/dd/yyyy\"))","v":"District: Sample Town CSD           Prepared by: John Doe           Date: 02/01/2005"}]
["PM Checklist and Log"]
["School: ____________________________________",null,"Year: ________________",null,"Implementor Key: M = Maintenance Mechanic   C = Custodian/on-site staff    G = Grounds crew    CC = Contracted to others"]
[]
["Heating Systems","P.M. Ref #","Implementor","Frequency/Year","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
["Boilers","HS 2004-01","M",4,null,"x",null,null,null,null,null,"x",null,"x",null,"x"]
["Boiler water treatment",null,null,10]
["Furnaces",null,null,4]
["Condenser pumps",null,null,4]
["Deaerator tank",null,null,2]
["Steam traps",null,null,4]
["Steam valves",null,null," 1-4"]
["Fuel tanks & distribution",null,null,1]
["Heat exchangers",null,null,2]
["Terminal/package units",null,null,4]
["Fin tubes/radiators",null,null,4]
["Dampers/draft control",null,null,4]
["Ductwork",null,null,2]
["Stacks",null,null,4]
["Insulation",null,null,2]
["Piping",null,null,4]
["Valves",null,null,1]
[" Control sensors",null,null,2]
[]
["Air Handling Systems","P.M. Ref #","Implementor","Frequency/Year","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
["Air handling units",null,null,4]
["Unit ventilators",null,null,4]
["Fans",null,null,2]
["Fire dampers",null,null,1]
["Filters",null,null," 2-4"]
["Humidifiers",null,null,2]
[]
["Cooling Systems","P.M. Ref #","Implementor","Frequency/Year","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
["Condensing units",null,null,4]
["Air compressors",null,null,12]
["Heat exchangers",null,null,2]
["Packaged A/C units",null,null,4]
["Chillers: oil levels and operation",null,null,52]
["Chillers: other",null,null,12]
["CHW Pumps",null,null," 2-4"]
[" Heat pumps",null,null,4]
[]
["Fire Protection/Suppression Systems"]
["Sprinkler piping"]
["Backflow preventers"]
["Sprinkler heads"]
["Fire extinguishers"]
["Fire hose system"]
["Standpipe connection"]
["Fire pumps"]
["Grease hood extinguisher"]
["Alarms and detectors"]
[]
["Mechanical Controls"]
["Compressors"]
["Pneumatic valves/levers"]
["Pneumatic tubing"]
["Electronic controls"]
[]
["Plumbing Systems"]
["Cold water piping"]
["Water heaters"]
["Hot water piping"]
["Circulation pumps"]
["Sump pumps"]
["Valves and traps"]
["Septic tanks"]
[]
["Lighting Systems"]
["Fluorescent fixtures"]
["Incandescent fixtures"]
["HID fixtures"]
["Lighting panels"]
["Emergency lighting"]
["Exterior lighting"]
["Occupancy controls"]
["Daylight controls"]
["Other controls"]
[]
["Signal Systems"]
["Computer data"]
["Public address"]
["Television"]
["Telephone"]
["Clock system"]
["Fire alarms"]
["Security alarm/devices"]
[]
["Foundation and Substructure"]
["Footings  How?"]
["Foundation walls"]
["Slab/beams on grade"]
["Piling/Posts How?"]
["Waterproofing  How?"]
["Insulation"]
["Underdrains  How?"]
[]
["Superstructure"]
["Columns"]
["Beams"]
["Floor structure"]
["Roof structure"]
["Monolithic bearing walls"]
["Stairs and railings"]
["Structural bracing"]
["Welds/connectors"]
[]
[]
["Roof Systems"]
["Roofing"]
["Insulation"]
["Paving and ballast  Paving?  On a roof?"]
["Curbs/supports"]
["Expansion/seismic joints"]
["Drains, gutters, etc."]
["Drywells"]
["Flashing and trim"]
["Fasteners"]
["Snow stops"]
["Roof openings"]
["Parapet caps"]
[]
["Exterior Wall Systems"]
["Facade integrity"]
["Cladding/sheathing"]
["Doors"]
["Window systems"]
["Balcony walls/railings"]
["Louvers and screens"]
["Expansion/seismic joints"]
["Insulation"]
["Protective coating"]
["Sealants"]
[]
["Interior Construction"]
["Fixed partitions"]
["Demountable partitions"]
["Retractable partitions"]
["Doors"]
["Carpet"]
["Resilient tile/sheet"]
["Ceramic/clay tile"]
["Terrazzo"]
["Paint"]
["Vinyl/fabric wall cover"]
["Ceiling system"]
[]
["Power Generation "]
["Generators"]
["Transfer switches"]
["Transformers"]
["Service wiring"]
["Substation"]
["Switchgear"]
["Overcurrent protection"]
[]
["Power Distribution Systems"]
["Main distribution panel"]
["Wiring, conduits, & distribution panels"]
["Electrical receptacles"]
["Circuit breakers"]
["Electric baseboard heaters"]
["Heat trace"]
[]
["Landscaping Systems"]
["Irrigation"]
["Tree/shrub/flower bed plantings"]
["Turf/lawn"]
["Walks/plazas"]
[]
["Playfields and Playground Systems"]
["Athletic fields"]
["Hard surface courts"]
["Swings"]
["Safety mats"]
["Gravel and containment"]
["Markings/painting"]
[]
["Vehicular Systems"]
["Parking lots"]
["Roads/drives"]
["Curbs"]
["Fire lanes"]
[]
["Site Utilities"]
["Fuel tanks"]
["Fuel distribution piping"]
["Storm drainage"]
["Fire hydrant systems"]
[]
["Specialties"]
["Toilet partitions"]
["Display boards"]
["Projection screens"]
["Display cases"]
["Lockers"]
["Elevators"]
["Waste handling equipment"]
["Food service equipment"]
["Woodworking shop equipment"]
["Auto/engine shop equipment"]
["Vaults"]
["Swimming pools"]
["Raised computer flooring"]

{"sheet":"App C Work Order","index":17,"n_rows":59,"n_cols":13,"rows_kept":59,"cut":false,"hidden":false,"merged":[[1,0,1,17],[0,0,0,16],[2,0,2,16]]}
["This template can be used to help you customize a different PM work order for each PM activity listed on the PM Checklist and Log. Under the \"Description of Work to be Performed,\" you can list the PM steps necessary for the specific PM interval for that specific equipment.  You can save a copy of this form and edit as needed for each piece of equipment for which you perform PM services."]
["Preventive Maintenance Work Order Sheet"]
[]
["Equipment to be Worked on:"]
[]
["School District:",null,null,null,null,null,null,null,"Date Issued:"]
[]
["School:",null,null,null,null,null,null,null,"Date Completed:"]
[]
["Performed By:",null,null,null,null,null,null,null,"PM Code #:"]
[]
["Type of PM to be Performed:",null,null,null,"Monthly",null,"Quarterly",null,"Semi-Annual",null,"Annual",null,"Other"]
[]
["Time to Allow for Perform PM Work:",null,null,null,null,null,null,null,"Hour (s)"]
[]
["Tools Required:"]
[]
[]
[]
["Description of Work to be Performed:",null,null,null,null,null,null,null,null,null,null,null,"Remarks:"]
[]
["1."]
[]
[]
["2."]
[]
[]
["3."]
[]
[]
["4."]
[]
[]
["5."]
[]
[]
["6."]
[]
[]
["7."]
[]
[]
["8."]
[]
[]
["9."]
[]
[]
["10."]
[]
[]
["11."]
[]
[]
["12."]
[]
[]
[]
["Additional Follow-up Activities Needed:"]

{"sheet":"App D Bid Spec","index":18,"n_rows":39,"n_cols":2,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,12],[3,1,3,12],[18,1,18,12],[1,0,1,12],[2,0,2,12]]}
["This sample language can be used as part of a bid specification to help guide contractors in providing adequate documentation and training that will lead to better O&M in your schools."]
["O&M Specification Language "]
[]
["A.","Operation and Maintenance Instructions:  Arrange for each Installer of equipment that requires regular maintenance to meet with the Owner's personnel to provide instruction in proper operation and maintenance of the installed equipment.  Provide instruction by manufacturer's representatives if installers are not experienced in operation and maintenance procedures.  Include a detailed review of the following items:"]
[]
[1,"Maintenance manuals."]
[2,"Record documents."]
[3,"Spare parts and materials."]
[4,"Tools."]
[5,"Lubricants."]
[6,"Fuels."]
[7,"Identification systems."]
[8,"Control sequences."]
[9,"Hazards."]
[10,"Cleaning."]
[11,"Warranties and bonds."]
[12,"Maintenance agreements and similar continuing commitments."]
[]
["B.","Maintenance Manuals:  Organize operation and maintenance data into suitable sets of manageable size.  Bind properly indexed data in individual, heavy-duty, 3-ring, vinyl-covered binders, with pocket folders for folded sheet information.  Mark appropriate identification on front and spine of each binder.  Include the following types of information:"]
[]
[1,"PM intervals"]
[2,"Emergency instructions."]
[3,"Spare parts list."]
[4,"Copies of warranties."]
[5,"Wiring diagrams."]
[6,"Inspection procedures."]
[7,"Shop Drawings and Product Data."]
[8,"Replacement schedules for filters, seals, lubricants, etc."]
[]
["C.","Training: As part of instruction for operating equipment, demonstrate the following procedures:"]
[]
[1,"Startup."]
[2,"Shutdown."]
[3,"Emergency operations."]
[4,"Noise and vibration adjustments."]
[5,"Safety procedures."]
[6,"Economy and efficiency adjustments."]
[7,"Effective energy utilization."]
[8,"Periodic PM procedures."]

{"sheet":"App E Resources","index":19,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,11],[3,0,3,10],[1,0,1,11],[11,0,11,10],[9,0,9,10],[7,0,7,10],[5,0,5,10],[2,0,2,11]]}
["Following are available resources for applying recognized best practices in your schools:"]
["Best Practices Guides and Resources"]
[]
["US Environmental Protection Agency (EPA) Indoor Air Quality Tools for Schools Action Kit is available by calling 1-800-438-4318 or online at www.epa.gov/iaq/schools/toolkit.html ."]
[]
["US EPA Integrated Pest Management (IPM) in Schools resources are available online at www.epa.gov/pesticides/ipm/index.htm . The popular EPA booklet, \"Pest Control in the School Environment: Adopting IPM\" is designed to encourage and assist school officials in examining and improving their pest management practices. It identifies ways to reduce the use of pesticides in school buildings and landscapes, as well as alternative methods of managing pests commonly found in schools. A copy of the booklet may be obtained on-line by contacting the National Service Center for Environmental Publications , or by phone at 1-800-490-9198. The EPA publication number is EPA 735-F-93-012."]
[]
["US EPA Energy Star Portfolio Manager and the New York State Energy Research and Development Authority (NYSERDA) Energy Smart Schools Program free energy benchmarking service is available by calling 1-866-NYSERDA."]
[]
["US Department of Energy, Energy Smart Schools Program has numerous resources available at www.rebuild.org/sectors/ess/index.asp"]
[]
["School Operations and Maintenance: BEST PRACTICES FOR CONTROLLING ENERGY COSTS, A Guidebook for K-12 School System Business Officers and Facilities Managers. U.S. Department of Energy Office of Energy Efficiency and Renewable Energy Weatherization and Intergovenmental Program, Rebuild America EnergySmart Schools Program, August 2004."]
[]
[]
["ADDITIONAL REFS TO BE ADDED"]