{"text_format":"1","workbook":"xlsx","n_sheets":36,"sheets":["Welcome","Tabs","DataValidationLists","MeasureClassification v7&8","Data Import","Instructions for Provider","Site Inspection Request (50%)","Site Inspection Request (100%)","Inspection Memo (50%)","Inspection Memo (100%)","Project Workscope (50%)","Project Workscope (100%)","Air Sealing","Appliances","Cooling","DHW","Duct Improvements","Elevators","EMS & Temp Controls","Envelope Insulation","Exterior Doors","Heat & Energy Rec.","Heating","Heating Dist. Imp.","Lighting - Apt.","Lighting - CA","Low-Flow Devices","Motors","Other","Pipe Improvements","Renewables","Ventilation Imp.","VFD Upgrades","Windows","Inspection QC Report (50%)","Inspection QC Report (100%)"],"not_rendered":{"charts":0,"images":87,"macros":1,"external_links":1,"defined_names":93,"comments":5,"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":"Welcome","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Tabs","index":1,"n_rows":37,"n_cols":3,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
["Tab Name","Hidden","SuperHidden"]
["Welcome","No","No"]
["Tabs","Yes","Yes"]
["DataValidationLists","Yes","Yes"]
["MeasureClassification v7&8","Yes","Yes"]
["Data Import","Yes","Yes"]
["Instructions for Provider","No","No"]
["Site Inspection Request (50%)","No","No"]
["Site Inspection Request (100%)","No","No"]
["Inspection Memo (50%)","No","No"]
["Inspection Memo (100%)","No","No"]
["Project Workscope (50%)","No","No"]
["Project Workscope (100%)","No","No"]
["Air Sealing","Yes","No"]
["Appliances","Yes","No"]
["Cooling","Yes","No"]
["DHW","Yes","No"]
["Duct Improvements","Yes","No"]
["Elevators","Yes","No"]
["EMS & Temp Controls","Yes","No"]
["Envelope Insulation","Yes","No"]
["Exterior Doors","Yes","No"]
["Heat & Energy Rec.","Yes","No"]
["Heating","Yes","No"]
["Heating Dist. Imp.","Yes","No"]
["Lighting - Apt.","Yes","No"]
["Lighting - CA","Yes","No"]
["Low-Flow Devices","Yes","No"]
["Motors","Yes","No"]
["Other","Yes","No"]
["Pipe Improvements","Yes","No"]
["Renewables","Yes","No"]
["Ventilation Imp.","Yes","No"]
["VFD Upgrades","Yes","No"]
["Windows","Yes","No"]
["Inspection QC Report (50%)","No","No"]
["Inspection QC Report (100%)","No","No"]

{"sheet":"DataValidationLists","index":2,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["<Select Measure Type>","Yes","<Select One>","Yes","New","HRV","Dual-Fuel","Yes"]
["MULTIPLE MEASURES","No","Requirement Met","No","Repaired","HRV w/ Furnace","Natural Gas","No"]
["Air Sealing",null,"Requirement Not Met","N/A","Existing, functional","HRV w/ Furnace+AC","#2 Oil","Unknown"]
["Appliances",null,"N/A - Statement of Substantial Completion",null,"Existing, non-functional","ERV","#4 Oil"]
["Cooling",null,null,null,null,"ERV w/ Furnace","#6 Oil"]
["DHW",null,null,null,null,"ERV w/ Furnace+AC","Electricity"]
["Duct Improvements"]
["Elevators"]
["EMS & Temp Controls"]
["Envelope Insulation"]
["Exterior Doors"]
["Heat & Energy Recovery"]
["Heating"]
["Heating Distribution Imp."]
["Lighting - Apt."]
["Lighting - Common Area"]
["Low-Flow Devices"]
["Motors"]
["Other"]
["Pipe Improvements"]
["Renewables"]
["Ventilation Improvements"]
["VFD Upgrades"]
["Windows"]

{"sheet":"MeasureClassification v7&8","index":3,"n_rows":91,"n_cols":12,"rows_kept":91,"cut":false,"hidden":true,"merged":[[0,1,0,11]]}
["Workbook Measures","Comparisons"]
["Air Sealing","Air Sealing","Smoke-Driven Louver, Install","Vertical Shafts, Seal"]
["Appliances","Dishwasher, Install Energy Star","Gas-fired Dryers, Replace Electric","Other Appliances, Install Energy Star","Refrigerators, install Energy Star","Washing Machines, Install Energy Star"]
["Cooling","Chiller, Replace","Economizer, Install","Other Cooling Measure","Window Air Conditioners, Install"]
["DHW","Controls","Other DHW Measure","Replace DHW Heater (Central)","Replace DHW Heater (In-Unit)","Replace DHW Indirect-fired Heater"]
["Duct Improvements","Duct Sealing"]
["Elevators","Elevator Motors and Controls, Upgrade"]
["EMS & Temp Controls","Energy Management System (EMS), Install","Programmable Thermostats, Common Area"]
["Envelope Insulation","Insulation, Above Grade Walls","Insulation, Below Grade Walls","Insulation, Other Shell","Insulation, Roof Deck or Attic","Insulation, Slab"]
["Exterior Doors","Exterior Doors, Replace"]
["Heat & Energy Rec.","Heat/Energy Recovery"]
["Heating","Boiler, Replace (Central)","Boiler, Replace (In-Unit)","Boiler/Burner Clean and Tune","Burner, Replace","Central AC/HP","Furnace, Replace","Geothermal Heat Pump","Other Heating Measure","Outdoor Reset Control, Install","Split System AC/HP","Water Source AC/HP"]
["Heating Dist. Imp.","Distribution System, Upgrade","Steam Traps, Replace","Thermostatic Radiator Valves, install"]
["Lighting - Apt.","High Efficiency Fluorescent, Apt, Install"]
["Lighting - CA","Exterior Lighting, Upgrade","High Efficiency Fluorescent, CA, Install","LED Exit Signs","LED Fixtures & Screw-Ins","Other Lighting Measure","Timers/Sensors, Install"]
["Low-Flow Devices","Low-flow Devices"]
["Motors","Exhaust Fans, Replace","Motors, Install NEMA Premium Efficiency","Other Motor Measure","Pumps, Upgrade"]
["Pipe Improvements","Piping, DHW, Insulate","Piping, Heating, Insulate"]
["Renewables","CHP","Photovoltaic System","Solar Hot Water","Wind Turbine"]
["Ventilation Imp.","Constant Air Regulators, Install","Exhaust Fan Demand Control","Fan/Air Handlers, Upgrade","Other Ventilation Measure","Ventilation Central Controls"]
["VFD Upgrades","Var. Speed Drive"]
["Windows","Windows, Replace","Windows, Weatherstrip or Airseal"]
["Other","Other","Submetering"]
[]
[]
["SAV-IT TABLES MEASURE CATEGORY","SAV-IT TABLES MEASURE CLASSIFICATION"]
["Envelope","Air Sealing","x"]
["Heating_Cooling","Boiler, Replace (Central)","x"]
["Heating_Cooling","Boiler, Replace (In-Unit)","x"]
["Heating_Cooling","Boiler/Burner Clean and Tune","x"]
["Heating_Cooling","Burner, Replace","x"]
["Heating_Cooling","Central AC/HP","x"]
["Heating_Cooling","Chiller, Replace","x"]
["Ventilation","Constant Air Regulators, Install","x"]
["DHW","Controls","x"]
["Appliance","Dishwasher, Install Energy Star","x"]
["Heating_Cooling","Distribution System, Upgrade","x"]
["Ventilation","Duct Sealing","x"]
["Heating_Cooling","Economizer, Install","x"]
["Motors","Elevator Motors and Controls, Upgrade","x"]
["Heating_Cooling","Energy Management System (EMS), Install","x"]
["Ventilation","Exhaust Fan Demand Control","x"]
["Motors","Exhaust Fans, Replace","x"]
["Envelope","Exterior Doors, Replace","x"]
["Lighting","Exterior Lighting, Upgrade","x"]
["Ventilation","Fan/Air Handlers, Upgrade","x"]
["Heating_Cooling","Furnace, Replace","x"]
["Appliance","Gas-fired Dryers, Replace Electric","x"]
["Heating_Cooling","Geothermal Heat Pump","x"]
["Ventilation","Heat/Energy Recovery","x"]
["Lighting","High Efficiency Fluorescent, Apt, Install","x"]
["Lighting","High Efficiency Fluorescent, CA, Install","x"]
["Envelope","Insulation, Above Grade Walls","x"]
["Envelope","Insulation, Below Grade Walls","x"]
["Envelope","Insulation, Other Shell","x"]
["Envelope","Insulation, Roof Deck or Attic","x"]
["Envelope","Insulation, Slab","x"]
["Lighting","LED Exit Signs","x"]
["Lighting","LED Fixtures & Screw-Ins","x"]
["DHW","Low-flow Devices","x"]
["Motors","Motors, Install NEMA Premium Efficiency","x"]
["Other","Other"]
["Appliance","Other Appliances, Install Energy Star","x"]
["Heating_Cooling","Other Cooling Measure","x"]
["DHW","Other DHW Measure","x"]
["Heating_Cooling","Other Heating Measure","x"]
["Lighting","Other Lighting Measure","x"]
["Motors","Other Motor Measure","x"]
["Ventilation","Other Ventilation Measure","x"]
["Heating_Cooling","Outdoor Reset Control, Install","x"]
["DHW","Piping, DHW, Insulate","x"]
["Heating_Cooling","Piping, Heating, Insulate","x"]
["Heating_Cooling","Programmable Thermostats, Common Area","x"]
["Motors","Pumps, Upgrade","x"]
["Appliance","Refrigerators, install Energy Star","x"]
["DHW","Replace DHW Heater (Central)","x"]
["DHW","Replace DHW Heater (In-Unit)","x"]
["DHW","Replace DHW Indirect-fired Heater","x"]
["Envelope","Smoke-Driven Louver, Install","x"]
["Heating_Cooling","Split System AC/HP","x"]
["Heating_Cooling","Steam Traps, Replace","x"]
["Heating_Cooling","Thermostatic Radiator Valves, install","x"]
["Lighting","Timers/Sensors, Install","x"]
["Motors","Var. Speed Drive","x"]
["Ventilation","Ventilation Central Controls","x"]
["Envelope","Vertical Shafts, Seal","x"]
["Appliance","Washing Machines, Install Energy Star","x"]
["Heating_Cooling","Water Source AC/HP","x"]
["Heating_Cooling","Window Air Conditioners, Install","x"]
["Envelope","Windows, Replace","x"]
["Envelope","Windows, Weatherstrip or Airseal","x"]

{"sheet":"Data Import","index":4,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":true,"merged":[[0,0,0,2]]}
["V7/V8 Import"]
["Inspection Request Reference","SAV-IT Reference","Compiled References"]
["='Inspection Memo (50%)'!DT_InspectionMemo50_ProjectName","='General Project Info'!DT_GeneralProjectInfo_ProjectInfo_Name"]
["='Inspection Memo (50%)'!DT_InspectionMemo50_PartnerName","='General Project Info'!C8"]
["='Inspection Memo (100%)'!DT_InspectionMemo100_ProjectName","='General Project Info'!DT_GeneralProjectInfo_ProjectInfo_Name"]
["='Inspection Memo (100%)'!DT_InspectionMemo100_PartnerName","='General Project Info'!C8"]
["='Data Import'!DT_SiteInspectionRequest_StreetAddress","='General Project Info'!DT_GeneralProjectInfo_ProjectInfo_StreetAddress"]
["='Data Import'!DT_SiteInspectionRequest_City","='General Project Info'!DT_GeneralProjectInfo_ProjectInfo_City"]
["='Data Import'!DT_SiteInspectionRequest_Zip","='General Project Info'!DT_GeneralProjectInfo_ProjectInfo_Zip"]
[null,null,{"$f":"DT_SiteInspectionRequest_StreetAddress&\" \"&DT_SiteInspectionRequest_City&\", NY \"&DT_SiteInspectionRequest_Zip","v":" , NY "}]
["='Site Inspection Request (50%)'!DT_SiteInspectionRequest50_ProjectName","='General Project Info'!DT_GeneralProjectInfo_ProjectInfo_Name"]
["='Site Inspection Request (50%)'!DT_SiteInspectionRequest50_Units","='General Project Info'!C40"]
["='Site Inspection Request (50%)'!DT_SiteInspectionRequest50_Buildings","='General Project Info'!DT_GeneralProjectInfo_BuildingInfo_NumBuildings1"]
["='Site Inspection Request (50%)'!DT_SiteInspectionRequest50_Stories","='General Project Info'!DT_GeneralProjectInfo_BuildingInfo_NumStories1"]
["='Site Inspection Request (100%)'!DT_SiteInspectionRequest100_ProjectName","='General Project Info'!DT_GeneralProjectInfo_ProjectInfo_Name"]
["='Site Inspection Request (100%)'!DT_SiteInspectionRequest100_Units","='General Project Info'!C40"]
["='Site Inspection Request (100%)'!DT_SiteInspectionRequest100_Buildings","='General Project Info'!DT_GeneralProjectInfo_BuildingInfo_NumBuildings1"]
["='Site Inspection Request (100%)'!DT_SiteInspectionRequest100_Stories","='General Project Info'!DT_GeneralProjectInfo_BuildingInfo_NumStories1"]

{"sheet":"Instructions for Provider","index":5,"n_rows":69,"n_cols":8,"rows_kept":69,"cut":false,"hidden":false,"merged":[[68,1,68,18],[59,1,59,18],[61,1,61,6],[62,1,62,18],[64,1,64,6],[65,1,65,18],[67,1,67,6],[58,1,58,6],[41,1,41,18],[43,1,43,6],[44,1,44,18],[46,1,46,6],[47,1,47,18],[49,1,49,6],[50,1,50,18],[52,1,52,6],[53,1,53,18],[55,1,55,6],[56,1,56,18],[40,1,40,18],[25,2,25,18],[26,1,26,18],[27,1,27,18],[33,1,33,18],[35,1,35,6],[36,1,36,18],[38,1,38,6],[39,1,39,18],[30,1,30,18],[7,1,7,18],[0,1,0,17],[2,1,2,10],[3,1,3,18],[5,1,5,4],[6,1,6,18],[24,2,24,18],[8,1,8,18],[9,1,9,18],[11,1,11,4],[12,1,12,18],[17,1,17,4],[18,2,18,6],[18,7,18,11],[19,1,19,18],[20,1,20,18],[21,1,21,18],[22,1,22,18],[23,1,23,18],[14,1,14,4],[15,1,15,18]]}
[null,"NYSERDA Multifamily Performance Program - Existing Buildings Component"]
[]
[null,"Site Inspection Workbook"]
["*\n*\n*\n*\n*\n*","This tool simplifies and centralizes the reporting and data collection required for existing building construction inspections. It includes relevant information from the Site Inspection Protocols, but the Provider should also consult the Site Inspection Protocols for all applicable measures. For measures not covered by the Site Inspection Protocols, the information required in this workbook should be sufficient for measure documentation. This tool will also be used by Program staff to verify the documentation of completed measures and to document findings from programmatic inspections.\n\nAll scope changes should be reflected in this workbook. "]
[]
[null,"Provider Requirements"]
[null,"1) The Provider is required to follow the Measure Implementation guidelines and Site Inspection Protocols as detailed in the Program Guidelines."]
[null,"2) The Provider is responsible for confirming that work was installed according to the scope of work included in the approved SAV-IT."]
[null,"3) When submitting a signed Statement of Substantial Completion, the Provider is still responsible for performing the necessary due diligence to ensure that the Statement of Substantial Completion is accurate and complete."]
[null,"4) The Provider is required to compare the quantities and specifications of the installed equipment to the assumptions made in the SAV-IT and to note conformance/deviation. This should be noted in the “As-Built” description section for each measure. "]
[]
[null,"Photo Documentation"]
["*\n*","In addition to this inspection workbook, the Provider must submit a separate photo documentation file containing photo documentation of completed measures. See instructions in photo documentation template titled: \"Project Name - 100% Complete Photo Documentation.docx\" Reference photos as necessary in each measure's \"As-Built Description.\""]
[]
[null,"Cut Sheets"]
["*\n*","In addition to this inspection workbook, the Provider must submit cut sheets for all measures. Please refer to the Program Guidelines for more information. "]
[]
[null,"How to Use this Tool"]
[null,"1) ","Provider fills out all Blue cells. ",null,null,null,null,"Program Inspector fills out all Orange cells."]
[null,"2) Click the \"Import from V7/V8 SAV-IT\" button on the Welcome tab to automatically input data from the respective SAV-IT tool for this project. Note: Make sure macros are enabled in order for this function to work.\n"]
["*\n*","3) On each measure worksheet, fill in information from SAV-IT and Site Inspection. This should be done for all recommended measures regardless of whether you are requesting an inspection of the measure. Unhide necessary or additional worksheets by right clicking on the tabs below."]
["*\n*","4) Print out measure worksheets as necessary and complete during your inspection. Doing so will help ensure you gather all necessary information required for your submittal. Page breaks on individual worksheets can be adjusted by going to View and selecting Page Break Preview (drag page breaks as necessary). Note: hide all unused worksheets before printing."]
[null,"5) Enter information collected during your site inspection and from Statements of Substantial Completion."]
[null,"6) Fill in the required information on the following sheets (see details below):"]
[null,null,"Site Inspection Request - 100%"]
[null,null,"Project Workscope"]
[null,"7) Submit the completed workbook, the photo documentation file, and any required supporting documentation to multifamilyprograms@nyserda.ny.gov and your Project Manager as part of the 100% milestone submittal."]
[null,"8) The Project Manager will review the submittal and schedule a Programmatic site inspection once all required data is verified."]
[]
[null,"Scope Changes - Instructions"]
[null,"Scope Changes must be recorded in this document as they occur. All Scope Changes reflected in this document must first be approved by NYSERDA Project Managers and comply with the Program Rules as listed in the Program Guidelines. \n1) If a scope change is identified before any inspections occur, upload the scope of work from the SAV-IT that reflects that scope change. \n2) If a scope change is identified during the 50% or 100% inspection process, use the \"Import V7/V8 Scope Change @ [50% or 100%] Completion\" button on the Welcome tab. If preferred, manual changes may be made in lieu of using the button on the Welcome tab.  Please note that using the Scope Change macro will not erase previously entered data."]
[]
[null,"Site Inspection Request - Instructions"]
[null,"Fill in all the BLUE cells on this sheet. Include a list of, and summarize, any additional documentation included with the submittal. If you indicate that additional documentation is included, be sure to attach it to the submission."]
[]
[null,"Project Workscope - Instructions"]
[null,"Review imported data. Fill in all BLUE cells."]
[]
[null,"Measure Worksheets"]
["*\n*\n*","1) One worksheet must be completed for each measure. Unhide additional measure tabs that are not automatically populated from the SAV-IT. If an inspection is not yet being requested for a specific measure, the SAV-IT description for that measure should still be filled in. If a measure contains multiple sub-measures, a worksheet must be filled in for each sub-measure. For example, a heating system upgrade measure that involves energy savings associated with replacement motors and pipe insulation would require both the heating, motor, and pipe insulation worksheets to be completed. "]
[null,"2) To create additional worksheets of the same measure type: right click the respective measure tab, select \"move or copy\", and highlight the \"create a copy\" checkbox."]
["*\n*","3) Each measure worksheet's tab title should be labeled with the measure # before the measure type. For example, a boiler replacement measure may have three associated measure worksheets  whose tabs would be labeled as follows: \"1 – Heating\", \"1 – Heating Dist. Imp.\", \"1 – Motors\". In addition, there may be a fan motor replacement measure for the same project and therefore the Motors tab would need to be copied and then be labeled \"2 – Motors\". "]
[]
[null,"Measure Title and General Info"]
["*\n*","This information should be populated from the SAV-IT. If not, enter the Measure #(s), Name(s), and Reported % Complete at the current phase. For multiple unit measures such as windows, light fixtures, or low-flow fixtures, determine % complete based on number of units installed. If the measure is a unitary measure, such as a boiler system, determine % complete based on cost paid."]
[]
[null,"SAV-IT Measure Description"]
["*\n*","This information should be populated from the SAV-IT. If not, copy and paste the full description of the measure from the approved SAV-IT. Include key quantities and energy specifications that were used in the energy model and/or in other relevant calculations as a basis for the projected energy savings. For example, the number and wattages of light fixtures or the efficiency of a new boiler."]
[]
[null,"As-Built Description"]
["*\n*\n*","Describe the as-built conditions observed as the result of your inspection and/or Statement(s) of Substantial Completion. The measure recommendation from the SAV-IT should not be copied verbatim. Compare the installed quantities and specifications to the original assumptions to confirm that the estimated savings will be achieved. Note any deviation from the scope of work in the approved SAV-IT. Describe any completed work that is not easily reflected in the installation table. If work is ongoing, clearly describe the current status of construction with a projected date of completion."]
[]
[null,"Provider Inspection"]
["*\n*","Read the requirements for Provider site inspections, copied from the Site Inspection Protocols, and then indicate whether the requirements were met.  From the drop-down menu, please select the appropriate response.  If you met the requirement, select Requirement Met.  If you did not, select Requirement Not Met and provide explanation in the cell provided. If the requirement is not applicable because a Statement of Substantial Completion was submitted, select N/A - Statement of Substantial Completion."]
[]
[null,"Documentation"]
["*\n*","Documentation is required for all measures, regardless of the method of inspection (Provider Inspection or Statement of Substantial Completion).  A site inspection is typically required to verify a Statement of Substantial Completion.  Refer to the Site Inspection Protocols for additional information."]
[]
[null,"Installation Table"]
["*\n*\n*\n*","Insert all information about the measures inspected by you (the Provider) or the individual who verified the Statement of Substantial Completion. All work inspected should be documented in this table, even if it was not yet completed. For example, if an apartment was inspected and low-flow fixtures were not yet installed, the inspection results should still be included in the inspection summary table. The purpose of this table is not to copy the recommendation in the SAV-IT verbatim, but to accurately reflect the installed conditions. This table must be completed, regardless of the type of documentation used (statement or Provider inspection). Information that does not fit easily into these tables should be described in the “As-Built Description” sections. Delete and/or insert rows as needed. To delete, highlight the rows on the left side of the spreadsheet, right click and select Delete. To insert, highlight the a row within the table along the left side of the spreadsheet, right click and select Copy, then right click and select Paste Insert Row. Copy and inserting rows will preserve formatting."]
[]
[null,"Inspection Results"]
[null,"Action Items will be detailed in the \"Inspection Findings\" section for each respective measure. A summary will be provided in the Inspection Memo worksheet as well."]
[]
[null,"Photographs"]
["*\n*","Photographic documentation must be supplied in a separate photo documentation template titled: \"Project Name - 100% Complete Photo Documentation.docx\".  Instructions for each measure are provided in that document. Reference photos as necessary in each measure's \"As-Built Description.\""]
[]
[null,"Inspection Memo"]
[null,"This will be completed by the Program inspector. It will contain general findings from the inspection, including any Action Items. The Inspection memo tab will be sent to the Provider and building owner upon completion of the inspection. All action items listed on the Inspection Memo must be addressed, and a response submitted clarifying action taken, prior to subsequent inspection submittals."]

{"sheet":"Site Inspection Request (50%)","index":6,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[7,2,7,8],[1,2,1,8],[3,2,3,8],[4,0,4,1],[4,3,4,4],[4,5,4,6],[26,0,26,1],[26,2,33,8],[8,2,8,8],[9,2,9,8],[10,2,10,8],[11,2,11,8],[14,2,14,8],[15,2,15,8],[16,2,16,8],[17,2,17,8],[18,2,18,8],[21,1,21,7],[24,2,24,8]]}
[]
["Project Name:"]
[]
["Project Address:",null,{"$f":"'Data Import'!C10","v":" , NY "}]
["# of Units:",null,null,"# of Buildings:",null,null,null,"# of Stories:"]
[]
["Provider Contact for Site Inspection"]
["Name:"]
["Company:"]
["Email:"]
["Phone:"]
["Cell Phone:"]
[]
["Owner Contact for Site Inspection"]
["Name:"]
["Company:"]
["Email:"]
["Phone:"]
["Cell Phone:"]
[]
["The following documents are attached to this Site Inspection Request:"]
[null,"Photo Documentation (see template)"]
[null,"Cut Sheets (see Program Guidelines)"]
[null,"Scope Change Request (with associated files)"]
[null,"Other (explain):"]
[]
["Comments:"]

{"sheet":"Site Inspection Request (100%)","index":7,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[21,1,21,7],[24,2,24,8],[17,2,17,8],[18,2,18,8],[26,0,26,1],[26,2,33,8],[1,2,1,8],[3,2,3,8],[4,0,4,1],[4,3,4,4],[14,2,14,8],[15,2,15,8],[16,2,16,8],[4,5,4,6],[7,2,7,8],[8,2,8,8],[9,2,9,8],[10,2,10,8],[11,2,11,8]]}
[]
["Project Name:"]
[]
["Project Address:",null,{"$f":"'Data Import'!C10","v":" , NY "}]
["# of Units:",null,null,"# of Buildings:",null,null,null,"# of Stories:"]
[]
["Provider Contact for Site Inspection"]
["Name:"]
["Company:"]
["Email:"]
["Phone:"]
["Cell Phone:"]
[]
["Owner Contact for Site Inspection"]
["Name:"]
["Company:"]
["Email:"]
["Phone:"]
["Cell Phone:"]
[]
["The following documents are attached to this Site Inspection Request:"]
[null,"Photo Documentation (see template)"]
[null,"Cut Sheets (see Program Guidelines)"]
[null,"Scope Change Request (with associated files)"]
[null,"Other (explain):"]
[]
["Comments:"]

{"sheet":"Inspection Memo (50%)","index":8,"n_rows":129,"n_cols":9,"rows_kept":129,"cut":false,"hidden":false,"merged":[[7,0,7,1],[7,2,7,7],[8,0,8,1],[8,2,8,7],[9,0,9,1],[9,2,9,7],[1,2,1,7],[3,0,4,1],[3,3,3,7],[4,3,4,7],[5,0,6,1],[5,3,5,7],[6,3,6,4],[6,6,6,7],[25,8,30,8],[28,0,30,2],[28,3,30,3],[28,7,30,7],[32,1,32,7],[33,1,33,7],[11,0,12,1],[11,2,16,7],[19,0,23,7],[25,0,27,2],[25,3,27,3],[25,4,27,6],[25,7,27,7],[34,1,34,7],[36,0,38,2],[36,3,38,3],[36,4,38,6],[36,7,38,7],[36,8,41,8],[39,0,41,2],[39,3,41,3],[39,7,41,7],[47,8,52,8],[50,0,52,2],[50,3,52,3],[50,7,52,7],[54,1,54,7],[55,1,55,7],[43,1,43,7],[44,1,44,7],[45,1,45,7],[47,0,49,2],[47,3,49,3],[47,4,49,6],[47,7,49,7],[56,1,56,7],[58,0,60,2],[58,3,60,3],[58,4,60,6],[58,7,60,7],[58,8,63,8],[61,0,63,2],[61,3,63,3],[61,7,63,7],[69,8,74,8],[72,0,74,2],[72,3,74,3],[72,7,74,7],[76,1,76,7],[77,1,77,7],[65,1,65,7],[66,1,66,7],[67,1,67,7],[69,0,71,2],[69,3,71,3],[69,4,71,6],[69,7,71,7],[78,1,78,7],[80,0,82,2],[80,3,82,3],[80,4,82,6],[80,7,82,7],[80,8,85,8],[83,0,85,2],[83,3,85,3],[83,7,85,7],[91,8,96,8],[94,0,96,2],[94,3,96,3],[94,7,96,7],[98,1,98,7],[99,1,99,7],[87,1,87,7],[88,1,88,7],[89,1,89,7],[91,0,93,2],[91,3,93,3],[91,4,93,6],[91,7,93,7],[110,2,110,7],[111,2,111,7],[112,2,112,7],[113,2,113,7],[114,2,114,7],[117,2,117,7],[100,1,100,7],[103,2,103,7],[104,2,104,7],[105,2,105,7],[106,2,106,7],[107,2,107,7],[126,2,126,7],[127,2,127,7],[128,2,128,7],[118,2,118,7],[119,2,119,7],[120,2,120,7],[121,2,121,7],[124,2,124,7],[125,2,125,7]]}
[]
["Project Name:"]
[]
["Inspection Type:",null,null,"50% Completion"]
[null,null,null,"Re-Inspection"]
["Approval Status:",null,null,"APPROVED Incentive #3"]
[null,null,null,"Action Items Included",null,null,"NOT APPROVED"]
["MPP Provider:"]
["NYSERDA Project Manager:"]
["Inspection Date:"]
[]
["Inspection Summary:"]
[]
[]
[]
[]
[]
[]
["Action Items"]
["Action items are listed below for each recommended measure. Included are issues that were found during the programmatic inspection and/or requests for additional documentation for complete work. This list is not meant to be a comprehensive list of all work that must be completed before construction approval. The participant is still required to complete the recommended scope of work from the approved SAV-IT. In addition, all documentation requirements for subsequent programmatic inspections still remain. Action items must be addressed prior to subsequent inspections (re-inspections or Substantial Completion inspections), unless otherwise noted.\n"]
[]
[]
[]
[]
[]
["Measure Number",null,null,"Measure Name","Action Type",null,null,"Required Date of Completion","Provider's Response to Action Items"]
[]
[]
[null,null,null,null,null,"Documentation"]
[null,null,null,null,null,"Construction"]
[null,null,null,null,null,"Model"]
[]
[1]
[2]
[3]
[]
["Measure Number",null,null,"Measure Name","Action Type",null,null,"Required Date of Completion","Provider's Response to Action Items"]
[]
[]
[null,null,null,null,null,"Documentation"]
[null,null,null,null,null,"Construction"]
[null,null,null,null,null,"Model"]
[]
[1]
[2]
[3]
[]
["Measure Number",null,null,"Measure Name","Action Type",null,null,"Required Date of Completion","Provider's Response to Action Items"]
[]
[]
[null,null,null,null,null,"Documentation"]
[null,null,null,null,null,"Construction"]
[null,null,null,null,null,"Model"]
[]
[1]
[2]
[3]
[]
["Measure Number",null,null,"Measure Name","Action Type",null,null,"Required Date of Completion","Provider's Response to Action Items"]
[]
[]
[null,null,null,null,null,"Documentation"]
[null,null,null,null,null,"Construction"]
[null,null,null,null,null,"Model"]
[]
[1]
[2]
[3]
[]
["Measure Number",null,null,"Measure Name","Action Type",null,null,"Required Date of Completion","Provider's Response to Action Items"]
[]
[]
[null,null,null,null,null,"Documentation"]
[null,null,null,null,null,"Construction"]
[null,null,null,null,null,"Model"]
[]
[1]
[2]
[3]
[]
["Measure Number",null,null,"Measure Name","Action Type",null,null,"Required Date of Completion","Provider's Response to Action Items"]
[]
[]
[null,null,null,null,null,"Documentation"]
[null,null,null,null,null,"Construction"]
[null,null,null,null,null,"Model"]
[]
[1]
[2]
[3]
[]
["Measure Number",null,null,"Measure Name","Action Type",null,null,"Required Date of Completion","Provider's Response to Action Items"]
[]
[]
[null,null,null,null,null,"Documentation"]
[null,null,null,null,null,"Construction"]
[null,null,null,null,null,"Model"]
[]
[1]
[2]
[3]
[]
["Inspector(s):"]
["Name:"]
["Company:"]
["Email:"]
["Phone:"]
["Cell Phone:"]
[]
["Provider Representative:"]
["Name:"]
["Company:"]
["Email:"]
["Phone:"]
["Cell Phone:"]
[]
["Owner Representative:"]
["Name:"]
["Company:"]
["Email:"]
["Phone:"]
["Cell Phone:"]
[]
["Additional On-Site Personnel:"]
["Name:"]
["Company:"]
["Email:"]
["Phone:"]
["Cell Phone:"]

{"sheet":"Inspection Memo (100%)","index":9,"n_rows":129,"n_cols":9,"rows_kept":129,"cut":false,"hidden":false,"merged":[[98,1,98,7],[99,1,99,7],[100,1,100,7],[89,1,89,7],[91,0,93,2],[91,3,93,3],[91,4,93,6],[91,7,93,7],[76,1,76,7],[77,1,77,7],[78,1,78,7],[80,0,82,2],[80,3,82,3],[80,4,82,6],[80,7,82,7],[91,8,96,8],[94,0,96,2],[94,3,96,3],[94,7,96,7],[80,8,85,8],[83,0,85,2],[83,3,85,3],[83,7,85,7],[87,1,87,7],[88,1,88,7],[54,1,54,7],[55,1,55,7],[56,1,56,7],[58,0,60,2],[58,3,60,3],[58,4,60,6],[58,7,60,7],[69,8,74,8],[72,0,74,2],[72,3,74,3],[72,7,74,7],[58,8,63,8],[61,0,63,2],[61,3,63,3],[61,7,63,7],[65,1,65,7],[66,1,66,7],[67,1,67,7],[69,0,71,2],[69,3,71,3],[69,4,71,6],[69,7,71,7],[32,1,32,7],[33,1,33,7],[34,1,34,7],[36,0,38,2],[36,3,38,3],[36,4,38,6],[36,7,38,7],[47,8,52,8],[50,0,52,2],[50,3,52,3],[50,7,52,7],[36,8,41,8],[39,0,41,2],[39,3,41,3],[39,7,41,7],[43,1,43,7],[44,1,44,7],[45,1,45,7],[47,0,49,2],[47,3,49,3],[47,4,49,6],[47,7,49,7],[1,2,1,7],[4,3,4,7],[7,0,7,1],[8,0,8,1],[9,0,9,1],[7,2,7,7],[8,2,8,7],[9,2,9,7],[3,0,4,1],[5,0,6,1],[6,3,6,4],[6,6,6,7],[5,3,5,7],[3,3,3,7],[25,8,30,8],[28,0,30,2],[28,3,30,3],[28,7,30,7],[11,0,12,1],[11,2,16,7],[19,0,23,7],[25,0,27,2],[25,3,27,3],[25,4,27,6],[25,7,27,7],[110,2,110,7],[111,2,111,7],[112,2,112,7],[113,2,113,7],[114,2,114,7],[103,2,103,7],[104,2,104,7],[105,2,105,7],[106,2,106,7],[107,2,107,7],[124,2,124,7],[125,2,125,7],[126,2,126,7],[127,2,127,7],[128,2,128,7],[117,2,117,7],[118,2,118,7],[119,2,119,7],[120,2,120,7],[121,2,121,7]]}
[]
["Project Name:"]
[]
["Inspection Type:",null,null,"Substantial Completion"]
[null,null,null,"Re-Inspection"]
["Approval Status:",null,null,"APPROVED Incentive #3"]
[null,null,null,"Action Items Included",null,null,"NOT APPROVED"]
["MPP Provider:"]
["NYSERDA Project Manager:"]
["Inspection Date:"]
[]
["Inspection Summary:"]
[]
[]
[]
[]
[]
[]
["Action Items"]
["Action items are listed below for each recommended measure. Included are issues that were found during the programmatic inspection and/or requests for additional documentation for complete work. This list is not meant to be a comprehensive list of all work that must be completed before construction approval. The participant is still required to complete the recommended scope of work from the approved SAV-IT. In addition, all documentation requirements for subsequent programmatic inspections still remain. Action items must be addressed prior to subsequent inspections (re-inspections or Substantial Completion inspections), unless otherwise noted.\n"]
[]
[]
[]
[]
[]
["Measure Number",null,null,"Measure Name","Action Type",null,null,"Required Date of Completion","Provider's Response to Action Items"]
[]
[]
[null,null,null,null,null,"Documentation"]
[null,null,null,null,null,"Construction"]
[null,null,null,null,null,"Model"]
[]
[1]
[2]
[3]
[]
["Measure Number",null,null,"Measure Name","Action Type",null,null,"Required Date of Completion","Provider's Response to Action Items"]
[]
[]
[null,null,null,null,null,"Documentation"]
[null,null,null,null,null,"Construction"]
[null,null,null,null,null,"Model"]
[]
[1]
[2]
[3]
[]
["Measure Number",null,null,"Measure Name","Action Type",null,null,"Required Date of Completion","Provider's Response to Action Items"]
[]
[]
[null,null,null,null,null,"Documentation"]
[null,null,null,null,null,"Construction"]
[null,null,null,null,null,"Model"]
[]
[1]
[2]
[3]
[]
["Measure Number",null,null,"Measure Name","Action Type",null,null,"Required Date of Completion","Provider's Response to Action Items"]
[]
[]
[null,null,null,null,null,"Documentation"]
[null,null,null,null,null,"Construction"]
[null,null,null,null,null,"Model"]
[]
[1]
[2]
[3]
[]
["Measure Number",null,null,"Measure Name","Action Type",null,null,"Required Date of Completion","Provider's Response to Action Items"]
[]
[]
[null,null,null,null,null,"Documentation"]
[null,null,null,null,null,"Construction"]
[null,null,null,null,null,"Model"]
[]
[1]
[2]
[3]
[]
["Measure Number",null,null,"Measure Name","Action Type",null,null,"Required Date of Completion","Provider's Response to Action Items"]
[]
[]
[null,null,null,null,null,"Documentation"]
[null,null,null,null,null,"Construction"]
[null,null,null,null,null,"Model"]
[]
[1]
[2]
[3]
[]
["Measure Number",null,null,"Measure Name","Action Type",null,null,"Required Date of Completion","Provider's Response to Action Items"]
[]
[]
[null,null,null,null,null,"Documentation"]
[null,null,null,null,null,"Construction"]
[null,null,null,null,null,"Model"]
[]
[1]
[2]
[3]
[]
["Inspector(s):"]
["Name:"]
["Company:"]
["Email:"]
["Phone:"]
["Cell Phone:"]
[]
["Provider Representative:"]
["Name:"]
["Company:"]
["Email:"]
["Phone:"]
["Cell Phone:"]
[]
["Owner Representative:"]
["Name:"]
["Company:"]
["Email:"]
["Phone:"]
["Cell Phone:"]
[]
["Additional On-Site Personnel:"]
["Name:"]
["Company:"]
["Email:"]
["Phone:"]
["Cell Phone:"]

{"sheet":"Project Workscope (50%)","index":10,"n_rows":112,"n_cols":21,"rows_kept":112,"cut":false,"hidden":false,"merged":[[103,0,106,0],[103,1,106,1],[103,2,106,2],[103,3,106,3],[103,4,106,4],[103,5,106,5],[111,0,111,2],[111,9,111,14],[107,0,110,0],[107,1,110,1],[107,2,110,2],[107,3,110,3],[107,4,110,4],[107,5,110,5],[107,6,110,6],[107,7,110,7],[107,8,110,8],[107,15,110,15],[107,16,110,16],[99,5,102,5],[99,6,102,6],[99,7,102,7],[99,8,102,8],[99,15,102,15],[99,16,102,16],[95,6,98,6],[95,7,98,7],[95,8,98,8],[95,15,98,15],[95,16,98,16],[95,5,98,5],[103,6,106,6],[103,7,106,7],[103,8,106,8],[103,15,106,15],[103,16,106,16],[99,0,102,0],[99,1,102,1],[99,2,102,2],[99,3,102,3],[99,4,102,4],[95,0,98,0],[95,1,98,1],[95,2,98,2],[95,3,98,3],[95,4,98,4],[91,5,94,5],[91,6,94,6],[91,7,94,7],[91,8,94,8],[91,15,94,15],[91,16,94,16],[87,6,90,6],[87,7,90,7],[87,8,90,8],[87,15,90,15],[87,16,90,16],[87,5,90,5],[91,0,94,0],[91,1,94,1],[91,2,94,2],[91,3,94,3],[91,4,94,4],[87,0,90,0],[87,1,90,1],[87,2,90,2],[87,3,90,3],[87,4,90,4],[83,5,86,5],[83,6,86,6],[83,7,86,7],[83,8,86,8],[83,15,86,15],[83,16,86,16],[79,6,82,6],[79,7,82,7],[79,8,82,8],[79,15,82,15],[79,16,82,16],[79,5,82,5],[83,0,86,0],[83,1,86,1],[83,2,86,2],[83,3,86,3],[83,4,86,4],[79,0,82,0],[79,1,82,1],[79,2,82,2],[79,3,82,3],[79,4,82,4],[75,5,78,5],[75,6,78,6],[75,7,78,7],[75,8,78,8],[75,15,78,15],[75,16,78,16],[71,6,74,6],[71,7,74,7],[71,8,74,8],[71,15,74,15],[71,16,74,16],[71,5,74,5],[75,0,78,0],[75,1,78,1],[75,2,78,2],[75,3,78,3],[75,4,78,4],[71,0,74,0],[71,1,74,1],[71,2,74,2],[71,3,74,3],[71,4,74,4],[67,5,70,5],[67,6,70,6],[67,7,70,7],[67,8,70,8],[67,15,70,15],[67,16,70,16],[63,6,66,6],[63,7,66,7],[63,8,66,8],[63,15,66,15],[63,16,66,16],[63,5,66,5],[67,0,70,0],[67,1,70,1],[67,2,70,2],[67,3,70,3],[67,4,70,4],[63,0,66,0],[63,1,66,1],[63,2,66,2],[63,3,66,3],[63,4,66,4],[59,5,62,5],[59,6,62,6],[59,7,62,7],[59,8,62,8],[59,15,62,15],[59,16,62,16],[55,6,58,6],[55,7,58,7],[55,8,58,8],[55,15,58,15],[55,16,58,16],[55,5,58,5],[59,0,62,0],[59,1,62,1],[59,2,62,2],[59,3,62,3],[59,4,62,4],[55,0,58,0],[55,1,58,1],[55,2,58,2],[55,3,58,3],[55,4,58,4],[51,5,54,5],[51,6,54,6],[51,7,54,7],[51,8,54,8],[51,15,54,15],[51,16,54,16],[47,6,50,6],[47,7,50,7],[47,8,50,8],[47,15,50,15],[47,16,50,16],[47,5,50,5],[51,0,54,0],[51,1,54,1],[51,2,54,2],[51,3,54,3],[51,4,54,4],[47,0,50,0],[47,1,50,1],[47,2,50,2],[47,3,50,3],[47,4,50,4],[43,5,46,5],[43,6,46,6],[43,7,46,7],[43,8,46,8],[43,15,46,15],[43,16,46,16],[39,6,42,6],[39,7,42,7],[39,8,42,8],[39,15,42,15],[39,16,42,16],[39,5,42,5],[43,0,46,0],[43,1,46,1],[43,2,46,2],[43,3,46,3],[43,4,46,4],[39,0,42,0],[39,1,42,1],[39,2,42,2],[39,3,42,3],[39,4,42,4],[35,5,38,5],[35,6,38,6],[35,7,38,7],[35,8,38,8],[35,15,38,15],[35,16,38,16],[31,6,34,6],[31,7,34,7],[31,8,34,8],[31,15,34,15],[31,16,34,16],[31,5,34,5],[35,0,38,0],[35,1,38,1],[35,2,38,2],[35,3,38,3],[35,4,38,4],[31,0,34,0],[31,1,34,1],[31,2,34,2],[31,3,34,3],[31,4,34,4],[15,15,18,15],[15,16,18,16],[27,0,30,0],[27,1,30,1],[27,2,30,2],[27,3,30,3],[27,4,30,4],[23,0,26,0],[23,1,26,1],[23,2,26,2],[23,3,26,3],[23,4,26,4],[27,5,30,5],[27,6,30,6],[27,7,30,7],[27,8,30,8],[27,15,30,15],[27,16,30,16],[23,6,26,6],[23,7,26,7],[23,8,26,8],[23,15,26,15],[23,16,26,16],[23,5,26,5],[19,0,22,0],[19,1,22,1],[19,2,22,2],[19,3,22,3],[19,4,22,4],[11,7,14,7],[11,8,14,8],[11,15,14,15],[11,16,14,16],[15,0,18,0],[15,1,18,1],[15,2,18,2],[15,3,18,3],[15,4,18,4],[15,5,18,5],[19,5,22,5],[19,6,22,6],[19,7,22,7],[19,8,22,8],[19,15,22,15],[19,16,22,16],[15,6,18,6],[15,7,18,7],[15,8,18,8],[11,0,14,0],[11,1,14,1],[11,2,14,2],[11,3,14,3],[11,4,14,4],[11,5,14,5],[11,6,14,6],[8,6,10,6],[8,7,10,7],[8,0,10,0],[8,1,10,1],[8,2,10,2],[8,3,9,3],[8,4,10,4],[8,5,10,5],[3,2,3,3],[3,17,3,21],[4,2,4,3],[4,17,4,21],[5,10,5,11],[7,0,7,14],[8,17,8,22],[9,9,10,14],[9,17,10,22],[8,8,9,8],[8,9,8,14],[8,15,10,15],[8,16,9,16]]}
["Project Workscope and Completion Status"]
[]
[]
["Date of Inspection:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date of Inspection:"]
["Provider Field Inspector Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QC Field Inspector Name:"]
[]
[]
["Provider Progress To Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Program Progress To Date"]
["Measure Number","Measure Name","Measure Classification","Projected Source Energy Savings","Projected % Source Energy Savings","% Complete To Date ","Previously Installed (Yes/No)","% of Total Projected Energy Savings","Est. Energy Savings To Date","Summary of Progress ",null,null,null,null,null,"% Complete as per 50% Site Inspection","Est. Energy Savings To Date","Summary of Progress "]
[null,null,null,null,null,null,null,null,null,"(indicate measure status as a result of the Provider Site Inspection &/or documented Statement of Substantial Completion)",null,null,null,null,null,null,null,"(indicate measure status as a result of the Programmatic Site Inspection &/or measure documentation)"]
[null,null,null,"(MMBtu)",null,null,null,null,"(MMBtu)",null,null,null,null,null,null,null,"(MMBtu)"]
[1,null,null,null,null,null,null,{"$f":"IF(D12=0,\"\",D12/$D$112)","v":""},{"$f":"IF(D12=0,\"\",F12*D12)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P12*D12","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Inspected During:",null,"50% Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[2,null,null,null,null,null,null,{"$f":"IF(D16=0,\"\",D16/$D$112)","v":""},{"$f":"IF(D16=0,\"\",F16*D16)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P16*D16","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Inspected During:",null,"50% Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[3,null,null,null,null,null,null,{"$f":"IF(D20=0,\"\",D20/$D$112)","v":""},{"$f":"IF(D20=0,\"\",F20*D20)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P20*D20","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Inspected During:",null,"50% Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[4,null,null,null,null,null,null,{"$f":"IF(D24=0,\"\",D24/$D$112)","v":""},{"$f":"IF(D24=0,\"\",F24*D24)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P24*D24","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Inspected During:",null,"50% Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[5,null,null,null,null,null,null,{"$f":"IF(D28=0,\"\",D28/$D$112)","v":""},{"$f":"IF(D28=0,\"\",F28*D28)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P28*D28","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Inspected During:",null,"50% Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[6,null,null,null,null,null,null,{"$f":"IF(D32=0,\"\",D32/$D$112)","v":""},{"$f":"IF(D32=0,\"\",F32*D32)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P32*D32","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Inspected During:",null,"50% Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[7,null,null,null,null,null,null,{"$f":"IF(D36=0,\"\",D36/$D$112)","v":""},{"$f":"IF(D36=0,\"\",F36*D36)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P36*D36","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Inspected During:",null,"50% Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[8,null,null,null,null,null,null,{"$f":"IF(D40=0,\"\",D40/$D$112)","v":""},{"$f":"IF(D40=0,\"\",F40*D40)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P40*D40","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Inspected During:",null,"50% Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[9,null,null,null,null,null,null,{"$f":"IF(D44=0,\"\",D44/$D$112)","v":""},{"$f":"IF(D44=0,\"\",F44*D44)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P44*D44","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Inspected During:",null,"50% Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[10,null,null,null,null,null,null,{"$f":"IF(D48=0,\"\",D48/$D$112)","v":""},{"$f":"IF(D48=0,\"\",F48*D48)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P48*D48","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Inspected During:",null,"50% Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[11,null,null,null,null,null,null,{"$f":"IF(D52=0,\"\",D52/$D$112)","v":""},{"$f":"IF(D52=0,\"\",F52*D52)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P52*D52","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Inspected During:",null,"50% Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[12,null,null,null,null,null,null,{"$f":"IF(D56=0,\"\",D56/$D$112)","v":""},{"$f":"IF(D56=0,\"\",F56*D56)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P56*D56","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Inspected During:",null,"50% Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[13,null,null,null,null,null,null,{"$f":"IF(D60=0,\"\",D60/$D$112)","v":""},{"$f":"IF(D60=0,\"\",F60*D60)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P60*D60","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Inspected During:",null,"50% Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[14,null,null,null,null,null,null,{"$f":"IF(D64=0,\"\",D64/$D$112)","v":""},{"$f":"IF(D64=0,\"\",F64*D64)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P64*D64","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Inspected During:",null,"50% Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[15,null,null,null,null,null,null,{"$f":"IF(D68=0,\"\",D68/$D$112)","v":""},{"$f":"IF(D68=0,\"\",F68*D68)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P68*D68","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Inspected During:",null,"50% Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[16,null,null,null,null,null,null,{"$f":"IF(D72=0,\"\",D72/$D$112)","v":""},{"$f":"IF(D72=0,\"\",F72*D72)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P72*D72","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Inspected During:",null,"50% Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[17,null,null,null,null,null,null,{"$f":"IF(D76=0,\"\",D76/$D$112)","v":""},{"$f":"IF(D76=0,\"\",F76*D76)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P76*D76","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Inspected During:",null,"50% Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[18,null,null,null,null,null,null,{"$f":"IF(D80=0,\"\",D80/$D$112)","v":""},{"$f":"IF(D80=0,\"\",F80*D80)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P80*D80","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Inspected During:",null,"50% Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[19,null,null,null,null,null,null,{"$f":"IF(D84=0,\"\",D84/$D$112)","v":""},{"$f":"IF(D84=0,\"\",F84*D84)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P84*D84","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Inspected During:",null,"50% Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[20,null,null,null,null,null,null,{"$f":"IF(D88=0,\"\",D88/$D$112)","v":""},{"$f":"IF(D88=0,\"\",F88*D88)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P88*D88","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Inspected During:",null,"50% Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[21,null,null,null,null,null,null,{"$f":"IF(D92=0,\"\",D92/$D$112)","v":""},{"$f":"IF(D92=0,\"\",F92*D92)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P92*D92","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Inspected During:",null,"50% Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[22,null,null,null,null,null,null,{"$f":"IF(D96=0,\"\",D96/$D$112)","v":""},{"$f":"IF(D96=0,\"\",F96*D96)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P96*D96","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Inspected During:",null,"50% Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[23,null,null,null,null,null,null,{"$f":"IF(D100=0,\"\",D100/$D$112)","v":""},{"$f":"IF(D100=0,\"\",F100*D100)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P100*D100","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Inspected During:",null,"50% Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[24,null,null,null,null,null,null,{"$f":"IF(D104=0,\"\",D104/$D$112)","v":""},{"$f":"IF(D104=0,\"\",F104*D104)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P104*D104","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Inspected During:",null,"50% Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[25,null,null,null,null,null,null,{"$f":"IF(D108=0,\"\",D108/$D$112)","v":""},{"$f":"IF(D108=0,\"\",F108*D108)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P108*D108","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,"Inspected During:",null,"50% Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
["Provider Progress To Date:",null,null,{"$f":"SUM(D12:D111)","v":0},{"$f":"SUM(E12:E111)","v":0},{"$f":"SUMIF(G12:G111,\"<>Yes\",I12:I111)/SUMIF(G12:G111,\"<>Yes\",D12:D111)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(H12:H111)","v":0},{"$f":"SUM(I12:I111)","v":0},"Actual Progress To Date:",null,null,null,null,null,{"$f":"SUMIF(G12:G111,\"<>Yes\",Q12:Q111)/SUMIF(G12:G111,\"<>Yes\",D12:D111)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(Q12:Q111)","v":0}]

{"sheet":"Project Workscope (100%)","index":11,"n_rows":112,"n_cols":24,"rows_kept":112,"cut":false,"hidden":false,"merged":[[107,16,110,16],[107,17,110,17],[91,15,94,15],[95,15,98,15],[99,15,102,15],[103,15,106,15],[107,0,110,0],[107,1,110,1],[107,2,110,2],[107,3,110,3],[107,4,110,4],[107,5,110,5],[107,6,110,6],[107,7,110,7],[107,8,110,8],[107,15,110,15],[91,0,94,0],[91,1,94,1],[91,2,94,2],[91,3,94,3],[91,4,94,4],[91,5,94,5],[91,6,94,6],[91,8,94,8],[55,15,58,15],[59,15,62,15],[63,15,66,15],[67,15,70,15],[71,15,74,15],[75,15,78,15],[79,15,82,15],[83,15,86,15],[87,15,90,15],[19,15,22,15],[23,15,26,15],[27,15,30,15],[31,15,34,15],[35,15,38,15],[39,15,42,15],[43,15,46,15],[47,15,50,15],[51,15,54,15],[3,2,3,3],[4,2,4,3],[5,10,5,11],[7,0,7,14],[9,9,10,14],[9,18,10,23],[11,0,14,0],[11,1,14,1],[11,2,14,2],[11,3,14,3],[11,4,14,4],[11,5,14,5],[11,6,14,6],[8,6,10,6],[8,7,10,7],[8,8,9,8],[8,9,8,14],[8,17,9,17],[8,0,10,0],[8,1,10,1],[8,2,10,2],[3,18,3,22],[4,18,4,22],[23,17,26,17],[8,3,9,3],[8,4,10,4],[8,5,10,5],[15,0,18,0],[15,1,18,1],[15,2,18,2],[15,3,18,3],[15,4,18,4],[15,5,18,5],[19,17,22,17],[11,7,14,7],[11,8,14,8],[15,6,18,6],[15,7,18,7],[15,8,18,8],[19,0,22,0],[19,1,22,1],[19,2,22,2],[19,3,22,3],[19,4,22,4],[8,15,10,15],[11,15,14,15],[15,15,18,15],[27,0,30,0],[27,1,30,1],[27,2,30,2],[27,3,30,3],[27,4,30,4],[27,5,30,5],[19,8,22,8],[23,6,26,6],[23,7,26,7],[23,8,26,8],[27,6,30,6],[27,7,30,7],[27,8,30,8],[19,5,22,5],[23,0,26,0],[23,1,26,1],[23,2,26,2],[23,3,26,3],[23,4,26,4],[23,5,26,5],[19,6,22,6],[19,7,22,7],[35,6,38,6],[35,7,38,7],[35,8,38,8],[39,6,42,6],[39,7,42,7],[39,8,42,8],[35,17,38,17],[31,0,34,0],[31,1,34,1],[31,2,34,2],[31,3,34,3],[31,4,34,4],[31,5,34,5],[35,0,38,0],[35,1,38,1],[35,2,38,2],[35,3,38,3],[35,4,38,4],[35,5,38,5],[31,6,34,6],[31,7,34,7],[31,8,34,8],[31,17,34,17],[39,0,42,0],[39,1,42,1],[39,2,42,2],[39,3,42,3],[39,4,42,4],[39,5,42,5],[43,0,46,0],[43,1,46,1],[43,2,46,2],[43,3,46,3],[43,4,46,4],[43,5,46,5],[47,0,50,0],[47,1,50,1],[47,2,50,2],[47,3,50,3],[47,4,50,4],[47,5,50,5],[43,6,46,6],[43,7,46,7],[43,8,46,8],[47,6,50,6],[47,7,50,7],[47,8,50,8],[55,0,58,0],[55,1,58,1],[55,2,58,2],[55,3,58,3],[55,4,58,4],[55,5,58,5],[51,6,54,6],[51,7,54,7],[51,8,54,8],[55,6,58,6],[55,7,58,7],[55,8,58,8],[51,0,54,0],[51,1,54,1],[51,2,54,2],[51,3,54,3],[51,4,54,4],[51,5,54,5],[59,0,62,0],[59,1,62,1],[59,2,62,2],[59,3,62,3],[59,4,62,4],[59,5,62,5],[63,0,66,0],[63,1,66,1],[63,2,66,2],[63,3,66,3],[63,4,66,4],[63,5,66,5],[59,6,62,6],[59,7,62,7],[59,8,62,8],[63,6,66,6],[63,7,66,7],[63,8,66,8],[63,17,66,17],[63,16,66,16],[59,17,62,17],[59,16,62,16],[71,0,74,0],[71,1,74,1],[71,2,74,2],[71,3,74,3],[71,4,74,4],[71,5,74,5],[67,6,70,6],[67,7,70,7],[67,8,70,8],[71,6,74,6],[71,7,74,7],[71,8,74,8],[67,0,70,0],[67,1,70,1],[67,2,70,2],[67,3,70,3],[67,4,70,4],[67,5,70,5],[75,3,78,3],[75,4,78,4],[75,5,78,5],[83,16,86,16],[83,0,86,0],[83,1,86,1],[83,2,86,2],[83,3,86,3],[83,4,86,4],[83,5,86,5],[75,8,78,8],[75,16,78,16],[79,0,82,0],[79,1,82,1],[79,2,82,2],[79,3,82,3],[79,4,82,4],[79,5,82,5],[87,0,90,0],[87,1,90,1],[87,2,90,2],[87,3,90,3],[87,4,90,4],[87,5,90,5],[87,6,90,6],[87,7,90,7],[87,8,90,8],[111,0,111,2],[111,9,111,14],[8,16,10,16],[11,16,14,16],[15,16,18,16],[19,16,22,16],[23,16,26,16],[27,16,30,16],[31,16,34,16],[35,16,38,16],[83,6,86,6],[83,7,86,7],[83,8,86,8],[79,6,82,6],[79,7,82,7],[79,8,82,8],[75,6,78,6],[75,7,78,7],[75,0,78,0],[75,1,78,1],[75,2,78,2],[99,7,102,7],[99,8,102,8],[91,7,94,7],[95,0,98,0],[95,1,98,1],[95,2,98,2],[95,3,98,3],[95,4,98,4],[95,5,98,5],[95,6,98,6],[95,7,98,7],[95,8,98,8],[91,16,94,16],[91,17,94,17],[95,16,98,16],[95,17,98,17],[99,16,102,16],[99,17,102,17],[103,16,106,16],[103,17,106,17],[103,0,106,0],[103,1,106,1],[103,2,106,2],[103,3,106,3],[103,4,106,4],[103,5,106,5],[103,6,106,6],[103,7,106,7],[103,8,106,8],[99,0,102,0],[99,1,102,1],[99,2,102,2],[99,3,102,3],[99,4,102,4],[99,5,102,5],[99,6,102,6],[83,17,86,17],[79,17,82,17],[15,17,18,17],[11,17,14,17],[8,18,8,23],[87,16,90,16],[87,17,90,17],[79,16,82,16],[71,17,74,17],[71,16,74,16],[75,17,78,17],[67,17,70,17],[67,16,70,16],[55,17,58,17],[55,16,58,16],[51,17,54,17],[51,16,54,16],[47,17,50,17],[47,16,50,16],[39,17,42,17],[39,16,42,16],[43,17,46,17],[43,16,46,16],[27,17,30,17]]}
["Project Workscope and Completion Status"]
[]
[]
["Date of Inspection:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date of Inspection:"]
["Provider Field Inspector Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QC Field Inspector Name:"]
[]
[]
["Provider Progress To Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Program Progress To Date"]
["Measure Number","Measure Name","Measure Classification","Projected Source Energy Savings","Projected % Source Energy Savings","% Complete To Date ","Previously Installed (Yes/No)","% of Total Projected Energy Savings","Est. Energy Savings To Date","Summary of Progress ",null,null,null,null,null,"% Complete as per 50% Site Inspection","% Complete as per 100% Site Inspection","Est. Energy Savings To Date","Summary of Progress "]
[null,null,null,null,null,null,null,null,null,"(indicate measure status as a result of the Provider Site Inspection &/or documented Statement of Substantial Completion)",null,null,null,null,null,null,null,null,"(indicate measure status as a result of the Programmatic Site Inspection &/or measure documentation)"]
[null,null,null,"(MMBtu)",null,null,null,null,"(MMBtu)",null,null,null,null,null,null,null,null,"(MMBtu)"]
[1,null,null,null,null,null,null,{"$f":"IF(D12=0,\"\",D12/$D$112)","v":""},{"$f":"IF(D12=0,\"\",F12*D12)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope (50%)'!P12:P15","v":0},null,{"$f":"Q12*D12","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Inspected During:",null,"50% Completion",null,"Substantial Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[2,null,null,null,null,null,null,{"$f":"IF(D16=0,\"\",D16/$D$112)","v":""},{"$f":"IF(D16=0,\"\",F16*D16)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope (50%)'!P16:P19","v":0},null,{"$f":"Q16*D16","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Inspected During:",null,"50% Completion",null,"Substantial Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[3,null,null,null,null,null,null,{"$f":"IF(D20=0,\"\",D20/$D$112)","v":""},{"$f":"IF(D20=0,\"\",F20*D20)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope (50%)'!P20:P23","v":0},null,{"$f":"Q20*D20","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Inspected During:",null,"50% Completion",null,"Substantial Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[4,null,null,null,null,null,null,{"$f":"IF(D24=0,\"\",D24/$D$112)","v":""},{"$f":"IF(D24=0,\"\",F24*D24)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope (50%)'!P24:P27","v":0},null,{"$f":"Q24*D24","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Inspected During:",null,"50% Completion",null,"Substantial Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[5,null,null,null,null,null,null,{"$f":"IF(D28=0,\"\",D28/$D$112)","v":""},{"$f":"IF(D28=0,\"\",F28*D28)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope (50%)'!P28:P31","v":0},null,{"$f":"Q28*D28","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Inspected During:",null,"50% Completion",null,"Substantial Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[6,null,null,null,null,null,null,{"$f":"IF(D32=0,\"\",D32/$D$112)","v":""},{"$f":"IF(D32=0,\"\",F32*D32)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope (50%)'!P32:P35","v":0},null,{"$f":"Q32*D32","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Inspected During:",null,"50% Completion",null,"Substantial Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[7,null,null,null,null,null,null,{"$f":"IF(D36=0,\"\",D36/$D$112)","v":""},{"$f":"IF(D36=0,\"\",F36*D36)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope (50%)'!P36:P39","v":0},null,{"$f":"Q36*D36","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Inspected During:",null,"50% Completion",null,"Substantial Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[8,null,null,null,null,null,null,{"$f":"IF(D40=0,\"\",D40/$D$112)","v":""},{"$f":"IF(D40=0,\"\",F40*D40)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope (50%)'!P40:P43","v":0},null,{"$f":"Q40*D40","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Inspected During:",null,"50% Completion",null,"Substantial Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[9,null,null,null,null,null,null,{"$f":"IF(D44=0,\"\",D44/$D$112)","v":""},{"$f":"IF(D44=0,\"\",F44*D44)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope (50%)'!P44:P47","v":0},null,{"$f":"Q44*D44","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Inspected During:",null,"50% Completion",null,"Substantial Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[10,null,null,null,null,null,null,{"$f":"IF(D48=0,\"\",D48/$D$112)","v":""},{"$f":"IF(D48=0,\"\",F48*D48)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope (50%)'!P48:P51","v":0},null,{"$f":"Q48*D48","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Inspected During:",null,"50% Completion",null,"Substantial Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[11,null,null,null,null,null,null,{"$f":"IF(D52=0,\"\",D52/$D$112)","v":""},{"$f":"IF(D52=0,\"\",F52*D52)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope (50%)'!P52:P55","v":0},null,{"$f":"Q52*D52","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Inspected During:",null,"50% Completion",null,"Substantial Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[12,null,null,null,null,null,null,{"$f":"IF(D56=0,\"\",D56/$D$112)","v":""},{"$f":"IF(D56=0,\"\",F56*D56)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope (50%)'!P56:P59","v":0},null,{"$f":"Q56*D56","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Inspected During:",null,"50% Completion",null,"Substantial Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[13,null,null,null,null,null,null,{"$f":"IF(D60=0,\"\",D60/$D$112)","v":""},{"$f":"IF(D60=0,\"\",F60*D60)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope (50%)'!P60:P63","v":0},null,{"$f":"Q60*D60","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Inspected During:",null,"50% Completion",null,"Substantial Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[14,null,null,null,null,null,null,{"$f":"IF(D64=0,\"\",D64/$D$112)","v":""},{"$f":"IF(D64=0,\"\",F64*D64)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope (50%)'!P64:P67","v":0},null,{"$f":"Q64*D64","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Inspected During:",null,"50% Completion",null,"Substantial Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[15,null,null,null,null,null,null,{"$f":"IF(D68=0,\"\",D68/$D$112)","v":""},{"$f":"IF(D68=0,\"\",F68*D68)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope (50%)'!P68:P71","v":0},null,{"$f":"Q68*D68","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Inspected During:",null,"50% Completion",null,"Substantial Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[16,null,null,null,null,null,null,{"$f":"IF(D72=0,\"\",D72/$D$112)","v":""},{"$f":"IF(D72=0,\"\",F72*D72)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope (50%)'!P72:P75","v":0},null,{"$f":"Q72*D72","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Inspected During:",null,"50% Completion",null,"Substantial Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[17,null,null,null,null,null,null,{"$f":"IF(D76=0,\"\",D76/$D$112)","v":""},{"$f":"IF(D76=0,\"\",F76*D76)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope (50%)'!P76:P79","v":0},null,{"$f":"Q76*D76","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Inspected During:",null,"50% Completion",null,"Substantial Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[18,null,null,null,null,null,null,{"$f":"IF(D80=0,\"\",D80/$D$112)","v":""},{"$f":"IF(D80=0,\"\",F80*D80)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope (50%)'!P80:P83","v":0},null,{"$f":"Q80*D80","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Inspected During:",null,"50% Completion",null,"Substantial Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[19,null,null,null,null,null,null,{"$f":"IF(D84=0,\"\",D84/$D$112)","v":""},{"$f":"IF(D84=0,\"\",F84*D84)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope (50%)'!P84:P87","v":0},null,{"$f":"Q84*D84","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Inspected During:",null,"50% Completion",null,"Substantial Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[20,null,null,null,null,null,null,{"$f":"IF(D88=0,\"\",D88/$D$112)","v":""},{"$f":"IF(D88=0,\"\",F88*D88)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope (50%)'!P88:P91","v":0},null,{"$f":"Q88*D88","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Inspected During:",null,"50% Completion",null,"Substantial Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[21,null,null,null,null,null,null,{"$f":"IF(D92=0,\"\",D92/$D$112)","v":""},{"$f":"IF(D92=0,\"\",F92*D92)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope (50%)'!P92:P95","v":0},null,{"$f":"Q92*D92","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Inspected During:",null,"50% Completion",null,"Substantial Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[22,null,null,null,null,null,null,{"$f":"IF(D96=0,\"\",D96/$D$112)","v":""},{"$f":"IF(D96=0,\"\",F96*D96)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope (50%)'!P96:P99","v":0},null,{"$f":"Q96*D96","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Inspected During:",null,"50% Completion",null,"Substantial Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[23,null,null,null,null,null,null,{"$f":"IF(D100=0,\"\",D100/$D$112)","v":""},{"$f":"IF(D100=0,\"\",F100*D100)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope (50%)'!P100:P103","v":0},null,{"$f":"Q100*D100","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Inspected During:",null,"50% Completion",null,"Substantial Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[24,null,null,null,null,null,null,{"$f":"IF(D104=0,\"\",D104/$D$112)","v":""},{"$f":"IF(D104=0,\"\",F104*D104)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope (50%)'!P104:P107","v":0},null,{"$f":"Q104*D104","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Inspected During:",null,"50% Completion",null,"Substantial Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
[25,null,null,null,null,null,null,{"$f":"IF(D108=0,\"\",D108/$D$112)","v":""},{"$f":"IF(D108=0,\"\",F108*D108)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope (50%)'!P108:P111","v":0},null,{"$f":"Q108*D108","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Incomplete",null,"Action Items Required (See Inspection Memo)"]
[null,null,null,null,null,null,null,null,null,null,"Complete, via:",null,"Provider Sampling or",null,"Statement of Completion",null,null,null,null,"Inspected During:",null,"50% Completion",null,"Substantial Completion"]
[null,null,null,null,null,null,null,null,null,null,"Scope Change Request",null,"Measure Removed from Work Scope"]
["Provider Progress To Date:",null,null,{"$f":"SUM(D12:D111)","v":0},{"$f":"SUM(E12:E111)","v":0},{"$f":"SUMIF(G12:G111,\"<>Yes\",I12:I111)/SUMIF(G12:G111,\"<>Yes\",D12:D111)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(H12:H111)","v":0},{"$f":"SUM(I12:I111)","v":0},"Actual Progress To Date:",null,null,null,null,null,null,{"$f":"SUMIF(G12:G111,\"<>Yes\",R12:R111)/SUMIF(G12:G111,\"<>Yes\",D12:D111)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(R12:R111)","v":0}]

{"sheet":"Air Sealing","index":12,"n_rows":62,"n_cols":7,"rows_kept":62,"cut":false,"hidden":true,"merged":[[9,3,9,5],[6,0,6,6],[25,0,25,6],[30,0,30,6],[32,0,32,6],[17,0,17,6],[18,0,22,6],[10,0,10,6],[11,0,11,6],[13,0,13,6],[15,0,15,6],[14,0,14,6],[12,0,12,6],[27,0,27,1],[66,3,66,4],[33,3,36,3],[52,0,56,6],[37,0,37,6],[33,0,36,0],[59,1,59,6],[60,1,60,6],[61,1,61,6],[51,0,51,6],[58,0,58,6],[83,3,83,4],[77,3,77,4],[78,3,78,4],[79,3,79,4],[80,3,80,4],[81,3,81,4],[82,3,82,4],[75,3,75,4],[76,3,76,4],[74,3,74,4],[67,3,67,4],[71,3,71,4],[72,3,72,4],[73,3,73,4],[69,3,69,4],[70,3,70,4],[2,5,2,6],[3,5,3,6],[2,1,2,4],[3,1,3,4],[68,3,68,4],[5,0,5,6],[26,0,26,6],[27,4,27,6],[27,2,27,3],[33,2,36,2],[33,5,36,5],[43,0,43,6],[65,3,65,4],[33,4,36,4],[33,6,36,6],[34,1,36,1]]}
["Air Sealing"]
[]
["Measure #","Measure Name",null,null,null,"Reported % Complete"]
[]
[]
["Minimum Performance Standards"]
["Projects with air sealing shall consider and evaluate infiltration reduction via stack effect, wind effect, and bypasses when applying product."]
[]
["Measure Description"]
["Measure Description from SAV-IT",null,null,"Description matches SAV-IT (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
[]
["As-Built Description - 100% Inspection"]
["Describe the as-built conditions, including quantity and energy specifications, as inspected."]
[]
[]
[]
[]
[]
["Provider Inspection"]
["Inspection Requirement"]
["For elements that provide central services to the building (e.g. entry doors, central duct chases, utility service penetrations, etc.) a minimum 50% sample shall be inspected.\n\nFor elements that are repeated throughout the building or occur in every living unit (e.g. windows, wall/floor connections, air  conditioner sleeves, etc.) a minimum 10% sample shall be inspected. A minimum of five (5) apartments must be visited. Problems found during random inspections will require an expanded sample to determine extent of problem.\n\nWhere general in‐unit air sealing was specified in the SAV-IT, the sample set shall be representative of the variety of apartment types in the building, including end/corner units and inside units; top‐floor, middle‐floor, bottom‐floor units; and at least one unit of each size/type (studios, 1‐bed, 2‐bed, etc.)."]
["<Select One>",null,"If requirement is not met, please explain:"]
[]
["Documentation "]
["Representative Photo(s): In a separate Photo Documentation file, include one representative photo of type of air sealing work completed. \nCut Sheet(s): Submit cut sheet(s) showing the manufacturer, model number, and relevant energy rating information must be provided for each installed product. The model number that was installed must be clearly marked on the cut sheet."]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Provider Inspection)"]
["Bldg. #","Location ","Location of Leakage","Type of Sealing Performed","Air Sealing Complete","Quantity\n (SF, LF, # of units, etc. --- list for each line item)","Notes"]
[null," (Apt #, Room, Floor, Space)"]
[]
[]
[" Provider Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Appliances","index":13,"n_rows":62,"n_cols":9,"rows_kept":62,"cut":false,"hidden":true,"merged":[[58,0,58,8],[14,0,14,8],[15,0,15,8],[10,0,10,8],[11,0,11,8],[12,0,12,8],[13,0,13,8],[25,0,25,8],[17,0,17,8],[52,0,56,8],[61,1,61,8],[27,2,27,3],[33,0,36,0],[34,1,36,1],[33,2,36,2],[33,7,36,7],[33,4,36,4],[33,3,36,3],[33,6,36,6],[33,8,36,8],[33,5,36,5],[43,0,43,8],[27,0,27,1],[59,1,59,8],[60,1,60,8],[51,0,51,8],[2,7,2,8],[3,7,3,8],[37,0,37,8],[30,0,30,8],[26,0,26,8],[27,4,27,8],[2,1,2,6],[3,1,3,6],[5,0,5,8],[6,0,6,8],[9,3,9,7],[18,0,22,8],[32,0,32,8]]}
["Appliances"]
[]
["Measure #","Measure Name",null,null,null,null,null,"Reported % Complete"]
[]
[]
["Minimum Performance Standards"]
["Appliances shall be ENERGY STAR labeled when available.  Refrigerators and air conditioning units must be removed and decommissioned in compliance with EPA Clean Air Act and other relevant NY State regulations."]
[]
["Measure Description"]
["Measure Description from SAV-IT",null,null,"Description matches SAV-IT (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
[]
["As-Built Description - 100% Inspection"]
["Describe the as-built conditions, including quantity and energy specifications, as inspected."]
[]
[]
[]
[]
[]
["Provider Inspection"]
["Inspection Requirement"]
["Inspect 10% of appliances of each type and size, but no fewer than 5 appliances of each type. Sample must be random and statistically representative.  Note: Problems with installations found during random inspections will require an expanded sample to determine extent of problem."]
["<Select One>",null,"If requirement is not met, please explain:"]
[]
["Documentation "]
["Representative Photo(s): In a separate Photo Documentation file, include one representative photo of each appliance type/size inspected (with ENERGY STAR® label affixed, if visible). \nCut Sheet(s): Submit cut sheet(s) showing the manufacturer, model number, and relevant energy rating information must be provided for each installed product. The model number that was installed must be clearly marked on the cut sheet."]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Provider Inspection)"]
["Bldg. #","Location ","Equipment Type","Manufacturer","Model #","New?","Energy Star Labeled","kWh/yr.","Quantity"]
[null," (Apt #, Room, Floor, Space)"]
[]
[]
["Provider Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Cooling","index":14,"n_rows":66,"n_cols":10,"rows_kept":66,"cut":false,"hidden":true,"merged":[[27,0,27,9],[37,3,40,3],[36,0,36,9],[37,9,40,9],[37,2,40,2],[37,5,40,5],[37,8,40,8],[37,0,40,0],[28,0,28,9],[29,0,29,1],[29,2,29,3],[37,6,40,6],[38,1,40,1],[29,4,29,9],[32,0,32,9],[37,4,40,4],[7,2,7,9],[20,0,24,9],[8,0,8,1],[8,2,8,9],[19,0,19,9],[7,0,7,1],[65,1,65,9],[41,0,41,9],[47,0,47,9],[62,0,62,9],[63,1,63,9],[55,0,55,9],[64,1,64,9],[56,0,60,9],[2,1,2,7],[3,1,3,7],[37,7,40,7],[34,0,34,3],[2,8,2,9],[3,8,3,9],[11,4,11,8],[12,0,12,9],[13,0,13,9],[14,0,14,9],[15,0,15,9],[16,0,16,9],[17,0,17,9],[5,0,5,9],[6,0,6,1],[6,2,6,9]]}
["Cooling"]
[]
["Measure #","Measure Name",null,null,null,null,null,null,"Reported % Complete"]
[]
[]
["Minimum Performance Standards"]
["Cooling - Room Air Conditioners",null,"Room air conditioners shall be ENERGY STAR labeled (for all model sizes covered by the ENERGY STAR label). Air conditioning units must be removed and decommissioned in compliance with EPA Clean Air Act and other relevant NY State regulations (ECCC NYS 403.2.1 Table 1)."]
["Packaged Terminal Air Conditioners",null,"Equipment shall be ENERGY STAR labeled where appropriate of size of equipment. Where sizing does not allow ENERGY STAR labeling, equipment shall comply with ECCC NYS 403.2.3 Table 3 minimum efficiencies."]
["Cooling - Chillers",null,"Equipment shall meet the requirements of ECCC NYS 403.2.3 Table 7."]
[]
["Measure Description"]
["Measure Description from SAV-IT",null,null,null,"Description matches SAV-IT (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
[]
["As-Built Description - 100% Inspection"]
["Describe the as-built conditions, including quantity and energy specifications, as inspected."]
[]
[]
[]
[]
[]
["Provider Inspection"]
["Inspection Requirement"]
["All primary equipment (chillers, air handling units, etc.) should be inspected. A representative sample of 10% of in-unit terminal devices (fan coils, PTACs, room air conditioners, etc.) should be included in the process. A minimum of 5 apartments must be visited.  Air conditioner testing mu be performed on 100% of the installed equipment.  Note: Problems with installations found during random inspections will require an expanded sample to determine extent of problem."]
["<Select One>",null,"If requirement is not met, please explain:"]
[]
["Documentation"]
["Representative Photo(s): In a separate Photo Documentation file, include one representative photo of each system inspected. \nCut Sheet(s): Submit cut sheet(s) showing the manufacturer, model number, and relevant energy rating information must be provided for each installed product. The model number that was installed must be clearly marked on the cut sheet."]
[]
["Operation Manuals & training provided to building operators?"]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Provider Inspection)"]
["Bldg. #","Location ","Equipment Type","Spaces Served","Manufacturer","Model #","Output Capacity (Btu/h)","Rated Efficiency","Rated Efficiency Units","Controls"]
[null," (Apt #, Room, Floor, Space)"]
[]
[]
[" Provider Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"DHW","index":15,"n_rows":64,"n_cols":11,"rows_kept":64,"cut":false,"hidden":true,"merged":[[11,4,11,9],[5,0,5,10],[2,9,2,10],[2,1,2,8],[3,1,3,8],[3,9,3,10],[35,0,38,0],[35,7,38,7],[35,5,38,5],[12,0,12,10],[13,0,13,10],[14,0,14,10],[15,0,15,10],[16,0,16,10],[17,0,17,10],[19,0,19,10],[32,0,32,10],[20,0,24,10],[27,0,27,10],[28,0,28,10],[29,4,29,10],[35,8,38,8],[35,6,38,6],[37,10,38,10],[62,1,62,10],[35,2,38,2],[35,3,38,3],[35,4,38,4],[63,1,63,10],[6,0,6,10],[7,0,7,10],[8,0,8,10],[35,9,36,10],[37,9,38,9],[53,0,53,10],[54,0,58,10],[36,1,38,1],[39,0,39,10],[60,0,60,10],[61,1,61,10],[45,0,45,10],[29,0,29,1],[29,2,29,3],[34,0,34,10]]}
["Domestic Hot Water"]
[]
["Measure #","Measure Name",null,null,null,null,null,null,null,"Reported % Complete"]
[]
[]
["Minimum Performance Standards"]
["All hot water piping in mechanical room and accessible piping in unconditioned spaces shall be insulated to ECCC NYS 404.5."]
["Replacement domestic hot water heating plant(s) shall be ENERGY STAR labeled, where applicable. For all other systems where the ENERGY STAR label is not available, the specified heating plant(s) shall have a minimum rated efficiency no less than that required by the ECCC NYS 404.3. "]
["The temperature of the stored DHW shall be just sufficient to deliver DHW to the apartments when measured at the tap to within a temperature range of 110°F - 125°F and as required by ECCC NYS 404.3."]
[]
["Measure Description"]
["Measure Description from SAV-IT",null,null,null,"Description matches SAV-IT (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
[]
["As-Built Description - 100% Inspection"]
["Describe the as-built conditions, including quantity and energy specifications, as inspected."]
[]
[]
[]
[]
[]
["Provider Inspection"]
["Inspection Requirement"]
["All primary equipment (boilers, hot water heaters, etc.) should be inspected. A minimum of two faucets should be tested for water temperature."]
["<Select One>",null,"If requirement is not met, please explain:"]
[]
["Documentation"]
["Representative Photo(s): In a separate Photo Documentation file, include one representative photo of each system inspected. \nCut Sheet(s): Submit cut sheet(s) showing the manufacturer, model number, and relevant energy rating information must be provided for each installed product. The model number that was installed must be clearly marked on the cut sheet."]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Provider Inspection)"]
["Bldg. #","Location ","Equipment Description","Manufacturer","Model #","Rated Efficiency","Rated Efficiency Units","Input\n(MBH)","Recirculation Pump Controls\n(Type and Settings)","Water Temperature Readings"]
[null," (Apt #, Room, Floor, Space)"]
[null,null,null,null,null,null,null,null,null,"Faucet Near Heater","Faucet Far from Heater"]
[]
["Provider Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Duct Improvements","index":16,"n_rows":59,"n_cols":12,"rows_kept":59,"cut":false,"hidden":true,"merged":[[2,1,2,9],[2,10,2,11],[3,1,3,9],[3,10,3,11],[6,4,6,10],[12,0,12,11],[14,0,14,11],[31,10,33,10],[15,0,19,11],[22,0,22,11],[23,0,23,11],[24,0,24,1],[24,2,24,3],[24,4,24,11],[27,0,27,11],[29,0,29,11],[30,0,33,0],[30,11,33,11],[31,4,33,4],[31,5,33,5],[31,1,33,1],[7,0,7,11],[8,0,8,11],[9,0,9,11],[10,0,10,11],[11,0,11,11],[30,2,30,3],[30,4,30,7],[30,8,30,10],[31,6,33,6],[31,9,33,9],[34,0,34,11],[58,1,58,11],[31,2,33,2],[31,3,33,3],[55,0,55,11],[56,1,56,11],[57,1,57,11],[40,0,40,11],[48,0,48,11],[49,0,53,11],[31,7,33,7],[31,8,33,8]]}
["Duct Improvements"]
[]
["Measure #","Measure Name",null,null,null,null,null,null,null,null,"Reported % Complete"]
[]
[]
["Measure Description"]
["Measure Description from SAV-IT",null,null,null,"Description matches SAV-IT (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
[]
["As-Built Description - 100% Inspection"]
["Describe the as-built conditions, including quantity and energy specifications, as inspected."]
[]
[]
[]
[]
[]
["Provider Inspection"]
["Inspection Requirement"]
["Each unique device assembly shall be inspected. Sampling may be used to inspect device assemblies that are consistent throughout large sections of the building. At each stage of the inspection process, a minimum of 20% of total insulated area must be inspected for each unique device type. An interim inspection (prior to area being enclosed) is required when insulated area will be inaccessible after completion."]
["<Select One>",null,"If requirement is not met, please explain:"]
[]
["Documentation"]
["Representative Photo(s): In a separate Photo Documentation file, include one representative photo of each area of insulation that will not be visible during the program inspection. \nCut Sheet(s): Submit cut sheet(s) showing the manufacturer, model number, and relevant energy rating information must be provided for each installed product. The model number that was installed must be clearly marked on the cut sheet."]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Provider Inspection)"]
["Bldg. #","Location ","Ductwork",null,"Insulation",null,null,null,"Sealing",null,null,"Notes"]
[null," (Apt #, Room, Floor, Space)","System","Linear Feet (insulated/ replaced)","Material Type","Thickness (inches)","R-Value","Meets Code?","Sealant Used","Pre Duct Leakage (CFM25)","Post Duct Leakage (CFM25)"]
[]
[]
["Provider Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Elevators","index":17,"n_rows":68,"n_cols":9,"rows_kept":68,"cut":false,"hidden":true,"merged":[[6,0,6,8],[9,3,9,7],[2,1,2,6],[2,7,2,8],[3,1,3,6],[3,7,3,8],[5,0,5,8],[10,0,10,8],[11,0,11,8],[12,0,12,8],[13,0,13,8],[14,0,14,8],[15,0,15,8],[17,0,17,8],[18,0,22,8],[23,0,23,8],[24,0,28,8],[31,0,31,8],[32,0,32,8],[33,0,33,1],[33,2,33,3],[33,4,33,8],[36,0,36,8],[38,0,38,8],[39,0,42,0],[39,8,42,8],[40,1,42,1],[41,7,42,7],[39,2,42,2],[39,3,42,3],[39,4,42,4],[39,5,40,7],[41,5,42,5],[41,6,42,6],[43,0,43,8],[49,0,49,8],[67,1,67,8],[57,0,57,8],[58,0,62,8],[64,0,64,8],[65,1,65,8],[66,1,66,8]]}
["Elevators"]
[]
["Measure #","Measure Name",null,null,null,null,null,"Reported % Complete"]
[]
[]
["Minimum Performance Standards"]
["All replaced or newly installed three motors 1 HP or larger shall be NEMA Premium efficiency or greater.  Motors that are packaged as an integral component of mechanical equipment are exempt from this requirement."]
[]
["Measure Description"]
["Measure Description from SAV-IT",null,null,"Description matches SAV-IT (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
[]
["As-Built Description - 50% Inspection"]
["Describe the as-built conditions, including quantity and energy specifications, as inspected."]
[]
[]
[]
[]
["As-Built Description - 100% Inspection"]
["Describe the as-built conditions, including quantity and energy specifications, as inspected."]
[]
[]
[]
[]
[]
["Provider Inspection"]
["Inspection Requirement"]
["All primary equipment should be inspected. "]
["<Select One>",null,"If requirement is not met, please explain:"]
[]
["Documentation"]
["Representative Photo(s): In a separate Photo Documentation file, include one representative photo of each installation and nameplate inspected. \nCut Sheet(s): Submit cut sheet(s) showing the manufacturer, model number, and relevant energy rating information must be provided for each installed product. The model number that was installed must be clearly marked on the cut sheet."]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Provider Inspection)"]
["Bldg. #","Location ","Motor HP","Type of Motor\n(AC/DC/Motor Generator)","Motor Efficiency\n(If New)","New\nControl/Drive",null,null,"Notes"]
[null," (Apt #, Room, Floor, Space)"]
[null,null,null,null,null,"Type","Manufacturer","Model #"]
[]
[" Provider Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"EMS & Temp Controls","index":18,"n_rows":72,"n_cols":11,"rows_kept":72,"cut":false,"hidden":true,"merged":[[5,0,5,10],[6,0,6,10],[2,9,2,10],[3,9,3,10],[2,1,2,8],[3,1,3,8],[19,0,19,10],[7,0,7,10],[8,0,8,10],[12,0,12,10],[11,4,11,9],[13,0,13,10],[14,0,14,10],[15,0,15,10],[16,0,16,10],[17,0,17,10],[43,0,46,0],[43,2,46,2],[43,3,46,3],[20,0,24,10],[25,0,25,10],[26,0,30,10],[33,0,33,10],[34,0,34,10],[35,0,35,1],[35,2,35,3],[35,4,35,10],[38,0,38,10],[42,0,42,10],[43,4,46,4],[43,9,46,9],[44,1,46,1],[71,1,71,10],[68,0,68,10],[69,1,69,10],[70,1,70,10],[47,0,47,10],[53,0,53,10],[61,0,61,10],[62,0,66,10],[43,5,44,7],[43,8,46,8],[43,10,46,10],[45,5,46,5],[45,6,46,6],[45,7,46,7]]}
["Energy Management Systems and Temperature Controls"]
[]
["Measure #","Measure Name",null,null,null,null,null,null,null,"Reported % Complete"]
[]
[]
["Minimum Performance Standards"]
["All hot water piping in mechanical room and accessible piping in unconditioned spaces shall be insulated to ECCC NYS 404.5."]
["Replacement domestic hot water heating plant(s) shall be ENERGY STAR labeled, where applicable. For all other systems where the ENERGY STAR label is not available, the specified heating plant(s) shall have a minimum rated efficiency no less than that required by the ECCC NYS 404.3. "]
["The temperature of the stored DHW shall be just sufficient to deliver DHW to the apartments when measured at the tap to within a temperature range of 110°F - 125°F and as required by ECCC NYS 404.3."]
[]
["Measure Description"]
["Measure Description from SAV-IT",null,null,null,"Description matches SAV-IT (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
[]
["As-Built Description - 50% Inspection"]
["Describe the as-built conditions, including quantity and energy specifications, as inspected."]
[]
[]
[]
[]
["As-Built Description - 100% Inspection"]
["Describe the as-built conditions, including quantity and energy specifications, as inspected."]
[]
[]
[]
[]
[]
["Provider Inspection"]
["Inspection Requirement"]
["All primary equipment (boilers, hot water heaters, etc.) should be inspected. A minimum of two faucets should be tested for water temperature."]
["<Select One>",null,"If requirement is not met, please explain:"]
[]
["Documentation"]
["Representative Photo(s): In a separate Photo Documentation file, include one representative photo of each piece of equipment inspected.  \nCut Sheet(s): Submit cut sheet(s) showing the manufacturer, model number, and relevant energy rating information must be provided for each installed product. The model number that was installed must be clearly marked on the cut sheet."]
[]
["Did you include a Communication & Functionality Test print-out in your submittal?"]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Provider Inspection)"]
["Bldg. #","Location ","Manufacturer","Model #","Type of Control/\nMonitoring Device","Settings",null,null,"Location of Sensor","Measured Temperature","Monitor Functioning Properly?"]
[null," (Apt #, Room, Floor, Space)"]
[null,null,null,null,null,"Day (temp)","Night (temp)","Night (hours)"]
[]
[" Provider Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Envelope Insulation","index":19,"n_rows":59,"n_cols":12,"rows_kept":59,"cut":false,"hidden":true,"merged":[[2,1,2,9],[2,10,2,11],[3,1,3,9],[3,10,3,11],[6,4,6,10],[7,0,7,11],[8,0,8,11],[9,0,9,11],[10,0,10,11],[11,0,11,11],[12,0,12,11],[14,0,14,11],[15,0,19,11],[22,0,22,11],[23,0,23,11],[24,0,24,1],[24,2,24,3],[24,4,24,11],[27,0,27,11],[29,0,29,11],[30,0,33,0],[30,11,33,11],[31,1,33,1],[30,4,33,4],[30,5,31,7],[32,5,33,5],[58,1,58,11],[30,2,33,2],[30,3,33,3],[30,8,31,9],[30,10,33,10],[48,0,48,11],[49,0,53,11],[34,0,34,11],[40,0,40,11],[55,0,55,11],[56,1,56,11],[57,1,57,11],[32,6,33,6],[32,7,33,7],[32,8,33,8],[32,9,33,9]]}
["Envelope Insulation"]
[]
["Measure #","Measure Name",null,null,null,null,null,null,null,null,"Reported % Complete"]
[]
[]
["Measure Description"]
["Measure Description from SAV-IT",null,null,null,"Description matches SAV-IT (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
[]
["As-Built Description - 100% Inspection"]
["Describe the as-built conditions, including quantity and energy specifications, as inspected."]
[]
[]
[]
[]
[]
["Provider Inspection"]
["Inspection Requirement"]
["Each unique envelope assembly shall be inspected. For example, if unique sections of the building are constructed differently, all distinct areas must be inspected. If insulation  specifications are different for different areas, each different specification shall be inspected.  \n\nSampling may be used to inspect roof or cavity assemblies that are consistent throughout large sections of the building. At each stage of the inspection process, a minimum of 20% of total roof and cavity area must be inspected for each unique roof and cavity type. Note:  Problems with installations found during random inspections will require an expanded sample.  \n\nAn interim inspection (prior to area being enclosed) is required when insulated area will be inaccessible after completion."]
["<Select One>",null,"If requirement is not met, please explain:"]
[]
["Documentation"]
["Representative Photo(s): In a separate Photo Documentation file, include one representative photo of each roof or cavity assembly inspected (showing the depth of blown insulation using tape measure or other depth measurement), minimum one photograph per attic.  Provided photos of roof deck & cavity insulation before it is covered.  \nCut Sheet(s): Submit cut sheet(s) showing the manufacturer, model number, and relevant energy rating information must be provided for each installed product. The model number that was installed must be clearly marked on the cut sheet."]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Provider Inspection)"]
["Bldg. #","Location ","Envelope Component","Type of Insulation Installed","SqFt Insulated","Thickness\n(inches)",null,null,"R-Value",null,"Infrared Scanner Used?","Notes"]
[null," (Apt #, Room, Floor, Space)"]
[null,null,null,null,null,"Existing","Added","Total","Added","Total"]
[]
[" Provider Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Exterior Doors","index":20,"n_rows":62,"n_cols":10,"rows_kept":62,"cut":false,"hidden":true,"merged":[[6,0,6,9],[2,1,2,7],[2,8,2,9],[3,1,3,7],[3,8,3,9],[5,0,5,9],[9,4,9,8],[10,0,10,9],[11,0,11,9],[12,0,12,9],[13,0,13,9],[14,0,14,9],[15,0,15,9],[17,0,17,9],[18,0,22,9],[25,0,25,9],[26,0,26,9],[27,0,27,1],[27,2,27,3],[27,4,27,9],[37,0,37,9],[30,0,30,9],[32,0,32,9],[33,0,36,0],[33,2,36,2],[33,3,36,3],[33,4,36,4],[33,8,36,8],[33,9,36,9],[34,1,36,1],[61,1,61,9],[33,6,36,6],[33,7,36,7],[33,5,36,5],[58,0,58,9],[59,1,59,9],[60,1,60,9],[43,0,43,9],[51,0,51,9],[52,0,56,9]]}
["Exterior Doors"]
[]
["Measure #","Measure Name",null,null,null,null,null,null,"Reported % Complete"]
[]
[]
["Minimum Performance Standards"]
["Specified windows & doors shall be ENERGY STAR rated where available, and comply with ECCC NYS 402.3. "]
[]
["Measure Description"]
["Measure Description from SAV-IT",null,null,null,"Description matches SAV-IT (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
[]
["As-Built Description - 100% Inspection"]
["Describe the as-built conditions, including quantity and energy specifications, as inspected."]
[]
[]
[]
[]
[]
["Provider Inspection"]
["Inspection Requirement"]
["Verify proper installation of 50% of all new common area exterior doors. Inspect 10% of new apartment exterior doors (minimum of 5) where garden style apartments exist or patio doors are being replaced. Note: Problems with installations found during random inspections will require an expanded sample to determine extent of problem."]
["<Select One>",null,"If requirement is not met, please explain:"]
[]
["Documentation"]
["Representative Photo(s):In a separate Photo Documentation file, include one representative photo of each type of door inspected. \nCut Sheet(s): Submit cut sheet(s) showing the manufacturer, model number, and relevant energy rating information must be provided for each installed product. The model number that was installed must be clearly marked on the cut sheet."]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Provider Inspection)"]
["Bldg. #","Location ","Door Type\n(Slider, Patio, Garage, etc.)","Manufacturer","Model #","U-Value","% Glazing","Low-E?","Energy Star?","Properly Air Sealed?"]
[null," (Apt #, Room, Floor, Space)"]
[]
[]
[" Provider Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Heat & Energy Rec.","index":21,"n_rows":59,"n_cols":13,"rows_kept":59,"cut":false,"hidden":true,"merged":[[2,1,2,10],[2,11,2,12],[3,1,3,10],[3,11,3,12],[6,4,6,11],[7,0,7,12],[8,0,8,12],[9,0,9,12],[10,0,10,12],[11,0,11,12],[12,0,12,12],[14,0,14,12],[15,0,19,12],[22,0,22,12],[23,0,23,12],[24,0,24,1],[24,2,24,3],[24,4,24,12],[27,0,27,12],[29,0,29,12],[30,0,33,0],[30,12,33,12],[31,1,33,1],[30,2,33,2],[31,6,33,6],[31,7,33,7],[31,8,33,8],[31,9,33,9],[31,10,33,10],[30,3,33,3],[30,4,33,4],[30,5,33,5],[30,11,33,11],[30,6,30,8],[30,9,30,10],[58,1,58,12],[34,0,34,12],[40,0,40,12],[48,0,48,12],[49,0,53,12],[55,0,55,12],[56,1,56,12],[57,1,57,12]]}
["Heat and Energy Recovery"]
[]
["Measure #","Measure Name",null,null,null,null,null,null,null,null,null,"Reported % Complete"]
[]
[]
["Measure Description"]
["Measure Description from SAV-IT",null,null,null,"Description matches SAV-IT (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
[]
["As-Built Description - 100% Inspection"]
["Describe the as-built conditions, including quantity and energy specifications, as inspected."]
[]
[]
[]
[]
[]
["Provider Inspection"]
["Inspection Requirement"]
["All primary equipment (ERV's, HRV's, etc.) should be inspected. A representative sample of 10% of spaces served should be included in the process.  Note:  Problems with installations found during random inspections will require an expanded sample to determine extent of problem."]
["<Select One>",null,"If requirement is not met, please explain:"]
[]
["Documentation"]
["Representative Photo(s): In a separate Photo Documentation file, include one representative photo of each type of equipment inspected.\nCut Sheet(s): Submit cut sheet(s) showing the manufacturer, model number, and relevant energy rating information must be provided for each installed product. The model number that was installed must be clearly marked on the cut sheet."]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Provider Inspection)"]
["Bldg. #","Location ","Type of System","Manufacturer","Model #","Rated Heat Exchange Efficiency","Supply",null,null,"Exhaust",null,"Calculated Efficiency*","Supply Air Temp"]
[null," (Apt #, Room, Floor, Space)",null,null,null,null,"Outside Air Temp","Temp After Heat Exchange","Design/Rated Air Flow (CFM)","Inside Air Temp","Leaving Air Temp"]
[]
[null,null,null,null,null,null,null,"Temp After Heat Exchange","Design/Rated Air Flow (CFM)","Inside Air Temp","Leaving Air Temp"]
[" Provider Documentation - 100% Inspection"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G36=0,\"\",(H36-G36)/(J36-G36))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[" Program Documentation - 100% Inspection"]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[]
["Program Use"]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Heating","index":22,"n_rows":76,"n_cols":16,"rows_kept":76,"cut":false,"hidden":true,"merged":[[24,0,24,15],[2,1,2,13],[2,14,2,15],[3,1,3,13],[3,14,3,15],[18,4,18,14],[10,0,10,1],[10,2,10,15],[11,0,11,1],[19,0,19,15],[20,0,20,15],[21,0,21,15],[22,0,22,15],[23,0,23,15],[14,0,14,1],[14,2,14,15],[36,2,36,3],[36,4,36,15],[26,0,26,15],[27,0,31,15],[34,0,34,15],[35,0,35,15],[36,0,36,1],[75,1,75,15],[47,6,50,6],[47,8,50,8],[47,11,48,12],[47,13,48,14],[47,15,48,15],[65,0,65,15],[66,0,70,15],[49,14,50,14],[49,15,50,15],[51,0,51,15],[57,0,57,15],[72,0,72,15],[73,1,73,15],[74,1,74,15],[5,0,5,15],[6,0,7,1],[6,2,6,15],[7,2,7,15],[8,0,8,1],[8,2,8,15],[9,0,9,1],[9,2,9,15],[48,1,50,1],[49,11,50,11],[49,12,50,12],[49,13,50,13],[11,2,11,15],[12,0,12,1],[12,2,12,15],[13,0,13,1],[13,2,13,15],[15,0,15,1],[15,2,15,15],[47,9,48,10],[49,9,50,9],[49,10,50,10],[39,0,39,15],[46,0,46,15],[47,0,50,0],[47,2,50,2],[47,3,50,3],[47,4,50,4],[47,5,50,5],[47,7,50,7],[41,0,41,4],[42,0,42,4],[43,0,43,4],[44,0,44,4]]}
["Heating"]
[]
["Measure #","Measure Name",null,null,null,null,null,null,null,null,null,null,null,null,"Reported % Complete"]
[]
[]
["Minimum Performance Standards"]
["Boiler & Furnace Systems",null,"Atmospherically vented gas furnaces and boilers shall not be specified."]
[null,null,"Steam piping, cooling system piping, and all hot water piping in mechanical room and accessible piping in unconditioned spaces shall be insulated to ECCC NYS 403.2.8."]
["Heating System Efficiency",null,"Replacement heating plants(s) shall be ENERGY STAR labeled, where applicable. Boiler systems (hot water and steam) larger than 300,000 Btuh input shall have a thermal efficiency of ≥ 80%. Exception: steam systems with input capacities between 300,000 Btuh and 2.5 MBtuh shall have a thermal efficiency of ≥ 79%. For all other systems where the ENERGY STAR label is not available, the specified heating plant(s) shall have a minimum rated efficiency no less than that required by the ECCC NYS 403.2.3 Tables 1-7."]
["Steady State Efficiency Testing ",null,"Replacement condensing boilers shall provide at a minimum steady state efficiency testing for high and low fire. For replacement condensing boiler(s), provide system in optimal performance (per the design) or operating conditions to minimize return water temperature."]
["Condensing Boilers & Furnaces",null,"Condensing boilers shall be designed, installed and operated in a manner to minimize return water temperature.\nCondensing furnaces shall be installed with electronically commutated motors (ECMs)."]
["Owners Manual",null,"When replacing HVAC systems & equipment provide an Owner’s Manual that contains (at a minimum) the following:\n     Equipment start-up reports and/or checklists; condensing boilers shall provide a minimum of efficiency testing for high and low fire\n     As-built equipment and controls cut sheets;\n     Statement of the system's Sequence of Operations. "]
["Heat Pumps",null,"Equipment shall be ENERGY STAR labeled where appropriate for size of equipment.  Where sizing does not allow ENERGY STAR labeling, equipment shall comply with ECCC NYS minimum efficiencies. "]
["Heating System Intake Air Supply",null,"When replacing heating appliance/plant, provide a motorized damper to the outside \"free air\" louver that is wired to the burner ignition OR ensure mechanical room (unconditioned space) is compartmentalized from rest of building/conditioned spaces."]
["Distribution System Replacements",null,"When replacing existing distribution systems or installing new systems, terminal heating & cooling distribution equipment serving an apartment shall be controlled by a thermostat(s) located within the same apartment as per ECCC NYS 403.2.4. Such terminal heating & cooling distribution equipment must be separated from the riser or distribution loop by a control valve, or terminal distribution pump, so that heated or cooled fluid is not delivered to the apartment distribution equipment when there is no call from the apartment thermostats."]
["Motors",null,"All replaced or newly installed three motors 1 HP or larger shall be NEMA Premium efficiency or greater.  Motors that are packaged as an integral component of mechanical equipment are exempt from this requirement."]
[]
["Measure Description"]
["Measure Description from SAV-IT",null,null,null,"Description matches SAV-IT (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
[]
["As-Built Description - 100% Inspection"]
["Describe the as-built conditions, including quantity and energy specifications, as inspected."]
[]
[]
[]
[]
[]
["Provider Inspection"]
["Inspection Requirement"]
["All primary equipment (boilers, pumps, etc.) should be inspected.  A representative sample of 10% of in-unit terminal devices (radiators, unit heaters, etc.) should be included in the process. A minimum of 5 apartments must be visited."]
["<Select One>",null,"If requirement is not met, please explain:"]
[]
["Documentation"]
["Representative Photo(s): In a separate Photo Documentation file, include one representative photo of each type of equipment inspected.\nCut Sheet(s): Submit cut sheet(s) showing the manufacturer, model number, and relevant energy rating information must be provided for each installed product. The model number that was installed must be clearly marked on the cut sheet."]
[]
["Outdoor reset curve submitted?"]
["Did you include Steady State Efficiency Testing in your submittal?"]
["Operating Manuals and training provided to staff?"]
["Indicate current fuel source:"]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Provider Inspection)"]
["Bldg. #","Location ","Type of Equipment","Manufacturer","Model #","Rated Efficiency","Rated Efficiency Units","Input Capacity (MBH)","Warm Weather Shutdown Temp","Outdoor Air Temp ",null,"Hot Water Systems",null,"Steam Systems",null,"Forced\nAir Furnace"]
[null," (Apt #, Room, Floor, Space)"]
[null,null,null,null,null,null,null,null,null,"Sensor Reading","Measured Temp","Supply Water Temp","Return Water Temp","Cut In Pressure","Cut Out Pressure","Ductwork Sealed"]
[]
[" Provider Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Heating Dist. Imp.","index":23,"n_rows":62,"n_cols":6,"rows_kept":62,"cut":false,"hidden":true,"merged":[[5,0,5,5],[6,0,6,5],[9,3,9,4],[10,0,10,5],[11,0,11,5],[32,0,32,5],[25,0,25,5],[12,0,12,5],[13,0,13,5],[14,0,14,5],[15,0,15,5],[17,0,17,5],[18,0,22,5],[26,0,26,5],[27,0,27,1],[27,2,27,3],[27,4,27,5],[30,0,30,5],[60,1,60,5],[61,1,61,5],[51,0,51,5],[52,0,56,5],[2,1,2,4],[3,1,3,4],[58,0,58,5],[59,1,59,5],[37,0,37,5],[43,0,43,5],[33,0,36,0],[33,2,36,2],[33,3,36,3],[33,4,36,4],[33,5,36,5],[34,1,36,1]]}
["Heating Distribution Improvements"]
[]
["Measure #","Measure Name",null,null,null,"Reported % Complete"]
[]
[]
["Minimum Performance Standards"]
["When replacing existing distribution systems or installing new systems, terminal heating & cooling distribution equipment serving an apartment shall be controlled by a thermostat(s) located within the same apartment as per ECCC NYS 403.2.4. Such terminal heating & cooling distribution equipment must be separated from the riser or distribution loop by a control valve, or terminal distribution pump, so that heated or cooled fluid is not delivered to the apartment distribution equipment when there is no call from the apartment thermostats."]
[]
["Measure Description"]
["Measure Description from SAV-IT",null,null,"Description matches SAV-IT (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
[]
["As-Built Description - 100% Inspection"]
["Describe the as-built conditions, including quantity and energy specifications, as inspected."]
[]
[]
[]
[]
[]
["Provider Inspection"]
["Inspection Requirement"]
["All primary equipment (zone valves, F&T traps, air vents, etc.) should be inspected. A representative sample of 10% of all installed devices is required (steam traps, air vents, TRV's, thermostats, etc.). A minimum of 5 apartments must be visited. Sample must be random and statistically representative.  Note: Problems with installations found during random inspections will require an expanded sample to determine extent of problem."]
["<Select One>",null,"If requirement is not met, please explain:"]
[]
["Documentation "]
["Representative Photo(s): In a separate Photo Documentation file, include one representative photo of type of equipment that was installed.\nCut Sheet(s): Submit cut sheet(s) showing the manufacturer, model number, and relevant energy rating information must be provided for each installed product. The model number that was installed must be clearly marked on the cut sheet."]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Provider Inspection)"]
["Bldg. #","Location ","Type of Equipment","Condition","Settings / Specifications","Notes"]
[null," (Apt #, Room, Floor, Space)"]
[]
[]
["Provider Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Lighting - Apt.","index":24,"n_rows":50,"n_cols":6,"rows_kept":50,"cut":false,"hidden":true,"merged":[[2,1,2,4],[3,1,3,4],[12,3,12,4],[9,0,9,1],[9,2,9,5],[5,0,5,5],[6,0,6,5],[7,0,7,1],[7,2,7,5],[8,0,8,1],[8,2,8,5],[13,0,13,5],[14,0,14,5],[15,0,15,5],[16,0,16,5],[17,0,17,5],[18,0,18,5],[20,0,20,5],[33,0,33,5],[34,0,34,2],[21,0,25,5],[28,0,28,5],[29,0,29,5],[30,0,30,1],[30,2,30,3],[30,4,30,5],[36,0,36,5],[46,0,46,5],[47,1,47,5],[48,1,48,5],[49,1,49,5],[39,0,39,5],[40,0,44,5]]}
["Apartment Lighting"]
[]
["Measure #","Measure Name",null,null,null,"Reported % Complete"]
[]
[]
["Minimum Performance Standards"]
["Removed fluorescent lamps and ballasts must be disposed of in an environmentally sensitive manner, adhering to all relevant Local, State, and National codes."]
["Linear Fluorescent Lighting",null,"Linear fluorescent systems shall have the following minimum efficacies:\n2-foot - 75 lumens per watt\n4-foot (including U-lamps) - 79 lumens per watt"]
["Compact Fluorescent Lighting",null,"Compact fluorescent fixtures shall be ENERGY STAR qualified.  Screw-in compact fluorescent lamps are not eligible."]
["LED Lighting \n(general illumination)",null,"Solid State Lighting products must be listed by either ENERGY STAR® or DesignLights™ Consortium’s Qualified Products List (DLC QPL).  If neither  ENERGY STAR® nor DesignLights™ certifies the type of solid state lighting in question installed, the following must be submitted:  LM-79 test data (for the entire luminaire);  LM-80 test data (for the LED device or module package); and an unconditional 3-year manufacturer’s warranty. "]
[]
["Measure Description"]
["Measure Description from SAV-IT",null,null,"Description matches SAV-IT (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
[]
["As-Built Description - 100% Inspection"]
["Describe the as-built conditions, including quantity and energy specifications, as inspected."]
[]
[]
[]
[]
[]
["Provider Inspection"]
["Inspection Requirement"]
["Inspect 10% of apartments to include, at a minimum, one representative apartment from each line. A minimum of 5 apartments must be visited. Note: Problems with installations found during random inspections will require an expanded sample to determine extent of the problem."]
["<Select One>",null,"If requirement is not met, please explain:"]
[]
["Documentation "]
["Representative Photo(s): In a separate Photo Documentation file, include one representative photo of each fixture type inspected (with ENERGY STAR® label affixed, if visible). \nCut Sheet(s): Submit cut sheet(s) showing the manufacturer, model number, and relevant energy rating information must be provided for each installed product. The model number that was installed must be clearly marked on the cut sheet."]
["Did you include an apartment distribution list in your submittal?"]
[]
["Documentation of the installed fixtures should be recorded on the Lighting Schedule worksheet by the Provider and Program Inspectors. The Lighting Schedule worksheet must be completed regardless of the type of documentation used (Statement of Substantial Completion or Provider Inspection). However, if a Statement of Substantial Completion and/or if additional documentation on the fixtures installed is included with this submittal, then the percentage of fixtures inspected can be reduced."]
[]
["Program Use"]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Lighting - CA","index":25,"n_rows":52,"n_cols":6,"rows_kept":52,"cut":false,"hidden":true,"merged":[[16,0,16,5],[17,0,17,5],[18,0,18,5],[19,0,19,5],[20,0,20,5],[15,3,15,4],[2,1,2,4],[3,1,3,4],[9,0,9,1],[9,2,9,5],[10,0,10,1],[10,2,10,5],[11,0,11,1],[11,2,11,5],[12,0,12,1],[12,2,12,5],[24,0,28,5],[31,0,31,5],[32,0,32,5],[33,0,33,1],[33,2,33,3],[33,4,33,5],[50,1,50,5],[51,1,51,5],[5,0,5,5],[6,0,6,5],[7,0,7,1],[7,2,7,5],[8,0,8,1],[8,2,8,5],[41,0,41,5],[42,0,46,5],[48,0,48,5],[23,0,23,5],[21,0,21,5],[49,1,49,5],[36,0,36,5],[38,0,38,5]]}
["Common Area Lighting"]
[]
["Measure #","Measure Name",null,null,null,"Reported % Complete"]
[]
[]
["Minimum Performance Standards"]
["Removed fluorescent lamps and ballasts must be disposed of in an environmentally sensitive manner, adhering to all relevant Local, State, and National codes."]
["Lighting Controls",null,"When replacing or upgrading lighting in frequently unoccupied areas, i.e. storage closets, compactor rooms, etc., provide occupancy controls where cost-effective."]
["Linear Fluorescent Lighting",null,"Linear fluorescent systems shall have the following minimum efficacies:\n2-foot - 75 lumens per watt\n4-foot (including U-lamps) - 79 lumens per watt"]
["Compact Fluorescent Lighting",null,"Compact fluorescent fixtures shall be ENERGY STAR qualified.  Screw-in compact fluorescent lamps are not eligible."]
["LED Lighting \n(general illumination)",null,"Solid State Lighting products must be listed by either ENERGY STAR® or DesignLights™ Consortium’s Qualified Products List (DLC QPL).  If neither  ENERGY STAR® nor DesignLights™ certifies the type of solid state lighting in question installed, the following must be submitted:  LM-79 test data (for the entire luminaire);  LM-80 test data (for the LED device or module package); and an unconditional 3-year manufacturer’s warranty. "]
["Emergency Lighting",null,"All exit signs shall be specified as LED (not to exceed 5W per face) or photo-luminescent and shall conform to local building code; fixtures located above stairwell doors and other forms of egress shall contain a battery back-up feature."]
["Outdoor, Security & Decorative lighting",null,"Exterior lighting shall have an efficacy of greater than or equal to 60 lumens/watt per ECCC NYS 405.6.1.  Fixtures must include automatic switching on timers or photocell controls except fixtures intended for 24-hour operation, required for security, or located on apartment balconies."]
[]
["Measure Description"]
["Measure Description from SAV-IT",null,null,"Description matches SAV-IT (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
[]
["As-Built Description - 100% Inspection"]
["Describe the as-built conditions, including quantity and energy specifications, as inspected."]
[]
[]
[]
[]
[]
["Provider Inspection"]
["Inspection Requirement"]
["Inspect all unique common areas (basements, lobbies) and a representative 20% sample (minimum 5) of similar, or repetitive, areas (stairwells and stairwell landings, corridors, trash chute rooms, etc.).\n\nDue diligence should include confirming that each control type is operable. For occupancy sensors, step in and out of the zone and confirm that lights switch off within a time period equivalent to the specified ON time. For timers, set timer to correct time and confirm control of fixture. For photocells, cover or blackout photocell and confirm control of fixture. For switches and dimmers, operate control to confirm control of fixture. For day lighting controls, dim or blackout location to observe change in fixture light level."]
["<Select One>",null,"If requirement is not met, please explain:"]
[]
["Documentation "]
["Representative Photo(s): In a separate Photo Documentation file, include one representative photo of each fixture type inspected (with ENERGY STAR® label affixed, if visible). \nCut Sheet(s): Submit cut sheet(s) showing the manufacturer, model number, and relevant energy rating information must be provided for each installed product. The model number that was installed must be clearly marked on the cut sheet."]
[]
["Documentation of the installed fixtures should be recorded on the Lighting Schedule worksheet by the Provider and Program Inspectors. The Lighting Schedule worksheet must be completed regardless of the type of documentation used (Statement of Substantial Completion or Provider Inspection). However, if a Statement of Substantial Completion and/or if additional documentation on the fixtures installed is included with this submittal, then the percentage of fixtures inspected can be reduced."]
[]
["Program Use"]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Low-Flow Devices","index":26,"n_rows":63,"n_cols":11,"rows_kept":63,"cut":false,"hidden":true,"merged":[[2,1,2,8],[2,9,2,10],[3,1,3,8],[3,9,3,10],[9,4,9,9],[10,0,10,10],[11,0,11,10],[12,0,12,10],[13,0,13,10],[14,0,14,10],[15,0,15,10],[17,0,17,10],[18,0,22,10],[25,0,25,10],[26,0,26,10],[27,4,27,10],[33,8,34,10],[30,0,30,10],[32,0,32,10],[33,0,35,0],[34,1,35,1],[61,1,61,10],[62,1,62,10],[5,0,5,10],[6,0,6,10],[33,2,34,4],[33,5,34,7],[53,0,57,10],[59,0,59,10],[36,0,36,10],[43,0,43,10],[42,0,42,1],[49,0,49,1],[60,1,60,10],[52,0,52,10],[27,0,27,1],[27,2,27,3]]}
["Low-Flow Devices"]
[]
["Measure #","Measure Name",null,null,null,null,null,null,null,"Reported % Complete"]
[]
[]
["Minimum Performance Standards"]
["Common area and in‐unit faucets and showerheads must not exceed 2.0 gallons per minute (GPM)."]
[]
["Measure Description"]
["Measure Description from SAV-IT",null,null,null,"Description matches SAV-IT (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
[]
["As-Built Description - 100% Inspection"]
["Describe the as-built conditions, including quantity and energy specifications, as inspected."]
[]
[]
[]
[]
[]
["Provider Inspection"]
["Inspection Requirement"]
["A representative sample of 10% of all installed aerators and low flow devices is required. A minimum of 5 apartments must be visited. Sample must be random and statistically representative. Note: Problems with installations found during random inspections will require an expanded sample to determine extent of problem."]
["<Select One>",null,"If requirement is not met, please explain:"]
[]
["Documentation"]
["Representative Photo(s): In a separate Photo Documentation file, include one representative photo of each device type inspected. \nCut Sheet(s): Submit cut sheet(s) showing the manufacturer, model number, and relevant energy rating information must be provided for each installed product. The model number that was installed must be clearly marked on the cut sheet."]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Provider Inspection)"]
["Bldg. #","Location ","Kitchen Aerator GPM",null,null,"Bathroom Aerator GPM",null,null,"Showerhead GPM"]
[null," (Apt #, Room, Floor, Space)"]
[null,null,"Rated","Measured*","New?","Rated","Measured*","New?","Rated","Measured*","New?"]
[" Provider Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
["Average",null,{"$f":"AVERAGE(C38:C42)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D38:D42)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(F38:F42)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G38:G42)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(I38:I42)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(J38:J42)","v":{"$error":"#DIV/0!"}}]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
["Average",null,{"$f":"AVERAGE(C45:C49)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D45:D49)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(F45:F49)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G45:G49)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(I45:I49)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(J45:J49)","v":{"$error":"#DIV/0!"}}]
[]
["Program Use"]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Motors","index":27,"n_rows":62,"n_cols":12,"rows_kept":62,"cut":false,"hidden":true,"merged":[[2,1,2,9],[2,10,2,11],[3,1,3,9],[3,10,3,11],[9,4,9,10],[10,0,10,11],[11,0,11,11],[12,0,12,11],[13,0,13,11],[14,0,14,11],[37,0,37,11],[43,0,43,11],[15,0,15,11],[17,0,17,11],[18,0,22,11],[25,0,25,11],[26,0,26,11],[33,6,36,6],[30,0,30,11],[32,0,32,11],[33,0,36,0],[33,2,36,2],[33,3,36,3],[33,10,36,10],[33,11,36,11],[34,1,36,1],[59,1,59,11],[60,1,60,11],[61,1,61,11],[5,0,5,11],[6,0,6,11],[33,4,36,4],[33,5,36,5],[33,7,36,7],[33,8,36,8],[33,9,36,9],[52,0,56,11],[58,0,58,11],[27,0,27,1],[27,2,27,3],[27,4,27,11],[51,0,51,11]]}
["Motors"]
[]
["Measure #","Measure Name",null,null,null,null,null,null,null,null,"Reported % Complete"]
[]
[]
["Minimum Performance Standards"]
["All replaced or newly installed three motors 1 HP or larger shall be NEMA Premium efficiency or greater. Motors that are packaged as an integral component of mechanical equipment are exempt from this requirement."]
[]
["Measure Description"]
["Measure Description from SAV-IT",null,null,null,"Description matches SAV-IT (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
[]
["As-Built Description - 100% Inspection"]
["Describe the as-built conditions, including quantity and energy specifications, as inspected."]
[]
[]
[]
[]
[]
["Provider Inspection"]
["Inspection Requirement"]
["All primary equipment should be inspected. "]
["<Select One>",null,"If requirement is not met, please explain:"]
[]
["Documentation"]
["Representative Photo(s): In a separate Photo Documentation file, include one representative photo of each installation and nameplate inspected. \nCut Sheet(s): Submit cut sheet(s) showing the manufacturer, model number, and relevant energy rating information must be provided for each installed product. The model number that was installed must be clearly marked on the cut sheet."]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Provider Inspection)"]
["Bldg. #","Location ","System Served","Manufacturer","Model #","Motor HP","Phase","RPMs","Enclosure Type","Motor Efficiency","NEMA Premium Efficiency?","Yearly Hours of Operation"]
[null," (Apt #, Room, Floor, Space)"]
[]
[]
[" Provider Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Other","index":28,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":true,"merged":[[11,0,11,11],[2,1,2,9],[2,10,2,11],[3,1,3,9],[3,10,3,11],[6,4,6,10],[7,0,7,11],[8,0,8,11],[9,0,9,11],[10,0,10,11],[12,0,12,11],[14,0,14,11],[15,0,19,11],[22,0,22,11],[23,0,23,11],[24,0,24,1],[24,2,24,3],[24,4,24,11],[27,0,27,11],[37,0,37,11],[38,1,38,11],[39,1,39,11],[40,1,40,11],[30,0,30,11],[31,0,35,11]]}
["Other"]
[]
["Measure #","Measure Name",null,null,null,null,null,null,null,null,"Reported % Complete"]
[]
[]
["Measure Description"]
["Measure Description from SAV-IT",null,null,null,"Description matches SAV-IT (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
[]
["As-Built Description - 100% Inspection"]
["Describe the as-built conditions, including quantity and energy specifications, as inspected."]
[]
[]
[]
[]
[]
["Provider Inspection"]
["Inspection Requirement"]
["All primary equipment should be inspected. "]
["<Select One>",null,"If requirement is not met, please explain:"]
[]
["Documentation"]
["Representative Photo(s): In a separate Photo Documentation file, include one representative photo of each installation and nameplate inspected. \nCut Sheet(s): Submit cut sheet(s) showing the manufacturer, model number, and relevant energy rating information must be provided for each installed product. The model number that was installed must be clearly marked on the cut sheet."]
[]
["Program Use"]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Pipe Improvements","index":29,"n_rows":62,"n_cols":9,"rows_kept":62,"cut":false,"hidden":true,"merged":[[9,4,9,7],[2,1,2,6],[2,7,2,8],[3,1,3,6],[3,7,3,8],[5,0,5,8],[6,0,6,8],[10,0,10,8],[11,0,11,8],[12,0,12,8],[13,0,13,8],[14,0,14,8],[15,0,15,8],[17,0,17,8],[30,0,30,8],[32,0,32,8],[33,0,36,0],[18,0,22,8],[25,0,25,8],[26,0,26,8],[27,0,27,1],[27,2,27,3],[27,4,27,8],[33,2,33,4],[33,5,33,8],[34,6,36,6],[34,7,36,7],[34,8,36,8],[58,0,58,8],[59,1,59,8],[60,1,60,8],[61,1,61,8],[34,1,36,1],[37,0,37,8],[43,0,43,8],[51,0,51,8],[52,0,56,8],[34,2,36,2],[34,3,36,3],[34,4,36,4],[34,5,36,5]]}
["Pipe Improvements"]
[]
["Measure #","Measure Name",null,null,null,null,null,"Reported % Complete"]
[]
[]
["Minimum Performance Standards"]
["All hot water piping in mechanical room and accessible piping in unconditioned spaces shall be insulated to ECCC NYS 404.5."]
[]
["Measure Description"]
["Measure Description from SAV-IT",null,null,null,"Description matches SAV-IT (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
[]
["As-Built Description - 100% Inspection"]
["Describe the as-built conditions, including quantity and energy specifications, as inspected."]
[]
[]
[]
[]
[]
["Provider Inspection"]
["Inspection Requirement"]
["Each unique device assembly shall be inspected. For example: DHW pipes, heating pipes, and ductwork should all be inspected independently.   Sampling may be used to inspect device assemblies that are consistent throughout large sections of the building. At each stage of the inspection process, a minimum of 20% of total insulated area must be inspected for each unique device type. An interim inspection (prior to area being enclosed) is required when insulated area will be inaccessible after completion."]
["<Select One>",null,"If requirement is not met, please explain:"]
[]
["Documentation"]
["Representative Photo(s): In a separate Photo Documentation file, include one representative photo of each area of insulation, especially those that will not be visible during the program inspection.   \nCut Sheet(s): Submit cut sheet(s) showing the manufacturer, model number, and relevant energy rating information must be provided for each installed product. The model number that was installed must be clearly marked on the cut sheet."]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Provider Inspection)"]
["Bldg. #","Location ","Piping",null,null,"Insulation"]
[null," (Apt #, Room, Floor, Space)","Fluid","Linear Feet (insulated/ replaced)","Outside Diameter (inches)","Material Type","Thickness (inches)","Thermal Conductivity","Meets Code?"]
[null,null,null,"Linear Feet (insulated/ replaced)","Outside Diameter (inches)","Material Type","Thickness (inches)","Thermal Conductivity","Meets Code?"]
[]
[" Provider Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Renewables","index":30,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":true,"merged":[[40,1,40,11],[27,0,27,11],[30,0,30,11],[31,0,35,11],[37,0,37,11],[38,1,38,11],[39,1,39,11],[15,0,19,11],[22,0,22,11],[23,0,23,11],[24,0,24,1],[24,2,24,3],[24,4,24,11],[14,0,14,11],[2,1,2,9],[2,10,2,11],[3,1,3,9],[3,10,3,11],[6,4,6,10],[7,0,7,11],[8,0,8,11],[9,0,9,11],[10,0,10,11],[11,0,11,11],[12,0,12,11]]}
["Renewables"]
[]
["Measure #","Measure Name",null,null,null,null,null,null,null,null,"Reported % Complete"]
[]
[]
["Measure Description"]
["Measure Description from SAV-IT",null,null,null,"Description matches SAV-IT (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
[]
["As-Built Description - 100% Inspection"]
["Describe the as-built conditions, including quantity and energy specifications, as inspected."]
[]
[]
[]
[]
[]
["Provider Inspection"]
["Inspection Requirement"]
["All primary equipment should be inspected. "]
["<Select One>",null,"If requirement is not met, please explain:"]
[]
["Documentation"]
["Representative Photo(s): In a separate Photo Documentation file, include one representative photo of each installation and nameplate inspected. \nCut Sheet(s): Submit cut sheet(s) showing the manufacturer, model number, and relevant energy rating information must be provided for each installed product. The model number that was installed must be clearly marked on the cut sheet."]
[]
["Program Use"]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Ventilation Imp.","index":31,"n_rows":59,"n_cols":13,"rows_kept":59,"cut":false,"hidden":true,"merged":[[2,1,2,10],[2,11,2,12],[3,1,3,10],[3,11,3,12],[6,4,6,11],[7,0,7,12],[8,0,8,12],[9,0,9,12],[10,0,10,12],[11,0,11,12],[12,0,12,12],[14,0,14,12],[15,0,19,12],[22,0,22,12],[23,0,23,12],[24,0,24,1],[24,2,24,3],[24,4,24,12],[30,12,33,12],[31,1,33,1],[27,0,27,12],[29,0,29,12],[30,0,33,0],[30,2,33,2],[30,3,33,3],[30,4,33,4],[30,5,33,5],[30,11,33,11],[58,1,58,12],[30,6,33,6],[30,7,33,7],[30,8,33,8],[30,9,33,9],[30,10,33,10],[48,0,48,12],[49,0,53,12],[34,0,34,12],[40,0,40,12],[55,0,55,12],[56,1,56,12],[57,1,57,12]]}
["Ventilation Improvements"]
[]
["Measure #","Measure Name",null,null,null,null,null,null,null,null,null,"Reported % Complete"]
[]
[]
["Measure Description"]
["Measure Description from SAV-IT",null,null,null,"Description matches SAV-IT (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
[]
["As-Built Description - 100% Inspection"]
["Describe the as-built conditions, including quantity and energy specifications, as inspected."]
[]
[]
[]
[]
[]
["Provider Inspection"]
["Inspection Requirement"]
["All primary equipment (central fans, air handling units, roof fans, etc.) should be inspected. A representative sample of 10% of in-unit terminal devices (individual room fans, grilles, CAR's, etc.) should be included in the process. A minimum of 5 apartments must be visited. Note: Problems with installations found during random inspections will require an expanded sample to determine extent of problem"]
["<Select One>",null,"If requirement is not met, please explain:"]
[]
["Documentation"]
["Representative Photo(s): In a separate Photo Documentation file, include one representative photo of each type of equipment inspected.\nCut Sheet(s): Submit cut sheet(s) showing the manufacturer, model number, and relevant energy rating information must be provided for each installed product. The model number that was installed must be clearly marked on the cut sheet."]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Provider Inspection)"]
["Bldg. #","Location ","Type of Upgrade","Type of Equipment","Manufacturer","Model #","Spaces Served","Control Type","Daily Hours of Operation","Rated\nEfficiency","Motor HP","Pre-retrofit\nFlow Rate\n(CFM)","Post-retrofit\nFlow Rate\n(CFM)"]
[null," (Apt #, Room, Floor, Space)"]
[]
[]
[" Provider Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"VFD Upgrades","index":32,"n_rows":62,"n_cols":7,"rows_kept":62,"cut":false,"hidden":true,"merged":[[6,0,6,6],[9,3,9,5],[2,1,2,4],[3,1,3,4],[2,5,2,6],[3,5,3,6],[5,0,5,6],[10,0,10,6],[11,0,11,6],[12,0,12,6],[13,0,13,6],[14,0,14,6],[15,0,15,6],[17,0,17,6],[34,1,36,1],[35,4,36,4],[35,5,36,5],[18,0,22,6],[25,0,25,6],[26,0,26,6],[27,0,27,1],[27,2,27,3],[27,4,27,6],[33,4,34,5],[30,0,30,6],[32,0,32,6],[33,0,36,0],[33,2,36,2],[33,3,36,3],[33,6,36,6],[37,0,37,6],[43,0,43,6],[58,0,58,6],[59,1,59,6],[60,1,60,6],[61,1,61,6],[52,0,56,6],[51,0,51,6]]}
["VFD Upgrades"]
[]
["Measure #","Measure Name",null,null,null,"Reported % Complete"]
[]
[]
["Minimum Performance Standards"]
["All replaced or newly installed three motors 1 HP or larger shall be NEMA Premium efficiency or greater.  Motors that are packaged as an integral component of mechanical equipment are exempt from this requirement."]
[]
["Measure Description"]
["Measure Description from SAV-IT",null,null,"Description matches SAV-IT (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
[]
["As-Built Description - 100% Inspection"]
["Describe the as-built conditions, including quantity and energy specifications, as inspected."]
[]
[]
[]
[]
[]
["Provider Inspection"]
["Inspection Requirement"]
["All primary equipment should be inspected. "]
["<Select One>",null,"If requirement is not met, please explain:"]
[]
["Documentation "]
["Representative Photo(s): In a separate Photo Documentation file, include one representative photo of each installation and nameplate inspected.\nCut Sheet(s): Submit cut sheet(s) showing the manufacturer, model number, and relevant energy rating information must be provided for each installed product. The model number that was installed must be clearly marked on the cut sheet."]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Provider Inspection)"]
["Bldg. #","Location ","Motor Serving","Motor HP","VFD",null,"Operating Properly?"]
[null," (Apt #, Room, Floor, Space)"]
[null,null,null,null,"Manufacturer","Model #"]
[]
["Provider Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Windows","index":33,"n_rows":70,"n_cols":14,"rows_kept":70,"cut":false,"hidden":true,"merged":[[2,1,2,11],[2,12,2,13],[3,1,3,11],[3,12,3,13],[9,4,9,12],[5,0,5,13],[6,0,6,13],[10,0,10,13],[11,0,11,13],[12,0,12,13],[13,0,13,13],[14,0,14,13],[15,0,15,13],[17,0,17,13],[18,0,22,13],[25,0,25,13],[26,0,26,13],[35,3,38,3],[35,4,38,4],[35,5,38,5],[36,1,38,1],[27,0,27,1],[27,2,27,3],[27,4,27,13],[30,0,30,13],[34,0,34,13],[35,6,38,6],[31,0,31,3],[35,9,38,9],[35,10,38,10],[35,12,38,12],[35,11,38,11],[69,1,69,13],[32,0,32,3],[59,0,59,13],[60,0,64,13],[39,0,39,13],[45,0,45,13],[53,0,53,13],[54,0,58,13],[66,0,66,13],[67,1,67,13],[68,1,68,13],[35,13,38,13],[35,0,38,0],[35,2,38,2],[35,7,38,7],[35,8,38,8]]}
["Windows"]
[]
["Measure #","Measure Name",null,null,null,null,null,null,null,null,null,null,"Reported % Complete"]
[]
[]
["Minimum Performance Standards"]
["Specified windows & doors shall be ENERGY STAR rated where available, and comply with ECCC NYS 402.3."]
[]
["Measure Description"]
["Measure Description from SAV-IT",null,null,null,"Description matches SAV-IT (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved SAV-IT or most recently approved scope change."]
[]
["As-Built Description - 100% Inspection"]
["Describe the as-built conditions, including quantity and energy specifications, as inspected."]
[]
[]
[]
[]
[]
["Provider Inspection"]
["Inspection Requirement"]
["At least 10% of new windows (minimum 10) shall be inspected and shall include, at a minimum, one of each different type of window installation based on different window types (fixed, double hung, etc.) and different energy performance specifications (e.g. if low-e glass is specified on part of the building but not all).\nThe sample set shall include, at a minimum, the inspection of new windows in one representative apartment from each line.\nProblems with installations found during random inspections will require an expanded sample to determine extent of problem."]
["<Select One>",null,"If requirement is not met, please explain:"]
[]
["Documentation"]
["Representative Photo(s): In a separate Photo Documentation file, include one representative photo of each window type inspected. \nCut Sheet(s): Submit cut sheet(s) showing the manufacturer, model number, and relevant energy rating information must be provided for each installed product. The model number that was installed must be clearly marked on the cut sheet."]
["Did you submit documentation of U-Value and SHGC?"]
["Did you submit cut sheets documenting Low-E glass?"]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Provider Inspection)"]
["Bldg. #","Location ","Window Type","Manufacture","Model #","# of \nPanes","Frame Material","U-Value","SHGC","Gas Fill","Low-E?","Energy Star?","Properly Air Sealed?","Quantity Inspected"]
[null," (Apt #, Room, Floor, Space)"]
[]
[]
[" Provider Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 50% Inspection"]
[]
[]
[]
[]
[]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Inspection QC Report (50%)","index":34,"n_rows":70,"n_cols":54,"rows_kept":70,"cut":false,"hidden":false,"merged":[[51,2,52,15],[56,2,56,4],[56,6,56,10],[56,13,56,15],[56,18,82,24],[58,2,59,15],[64,2,64,4],[64,6,64,10],[64,13,64,15],[66,2,67,15],[69,1,70,15],[27,5,27,15],[29,2,30,15],[46,3,46,4],[46,5,46,15],[47,3,47,4],[47,5,47,15],[44,3,44,4],[44,5,44,15],[45,3,45,4],[45,5,45,15],[43,3,43,4],[43,5,43,15],[10,18,11,25],[33,1,34,15],[38,2,39,15],[42,5,42,15],[7,1,8,15],[10,1,11,10],[10,13,11,14],[10,15,11,15],[14,3,14,6],[14,13,14,15],[15,3,15,6],[15,13,15,15],[16,3,16,6],[16,13,16,15],[20,1,20,10],[21,1,22,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Case Managers",null,null,null,null,null,null,"kbahny@trcsolutions.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Location:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Albanese, Jacqueleen",null,null,null,null,null,null,"Please Report Site Inspection QC Score",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\\\\ntapa-carlst\\energyservices-dc1\\Projects\\MPP\\NC\\QC Materials"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Butler,Lee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Katz, Menachem"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lang, Karin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Morrison,Edward"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reuss, Caroline"]
[null,"• Inspector shall complete the following form and click one of the macro buttons on the right when the form is ready to be reported.\n• If the form is completed by the NYSERDA PM click  \"Notify QC Custodian…\" \n• If the form is completed by a TRC employee click \"Report Site Inspection QC Score\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Robbins,Lindsay"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wojcik, Kate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zias, Dean"]
[null,"MPP Provider Inspection Performance Report",null,null,null,null,null,null,null,null,null,null,null,"Total Score:",null,{"$f":"SUM(R24,R37,R44,R57,R65,)","v":0},null,null,"**Site Inspection QC Scores shall only be reported after the site inspection milestone has been completed and approved for payment by NYSERDA.**"]
[]
[null,"General Information:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1. Completeness of Inspection Submittal:"]
[null,"Project Name:",null,{"$f":"IF('Inspection Memo (50%)'!C2=\"\",\"\",'Inspection Memo (50%)'!C2)","v":""},null,null,null,null,null,null,"Inspection Date:",null,null,{"$f":"IF('Inspection Memo (50%)'!C10=\"\",\"\",'Inspection Memo (50%)'!C10)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The scoring criteria for this category is:"]
[null,"Project Address:",null,{"$f":"IF('Site Inspection Request (50%)'!C4=\"\",\"\",'Site Inspection Request (50%)'!C4)","v":" , NY "},null,null,null,null,null,null,"Provider Company:",null,null,{"$f":"IF('Inspection Memo (50%)'!C8=\"\",\"\",'Inspection Memo (50%)'!C8)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null," 1 point for a complete submittal"]
[null,"Project Manager:",null,{"$f":"IF('Inspection Memo (50%)'!C9=\"\",\"\",'Inspection Memo (50%)'!C9)","v":""},null,null,null,null,null,null,"Site Inspector:",null,null,{"$f":"IF('Inspection Memo (50%)'!C104=\"\",\"\",'Inspection Memo (50%)'!C104)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null," 0 points for an incomplete submittal  "]
[]
[null,"Inspection Type:",null,false,null,"50% Complete",null,null,null,null,true,null,"Substantial Completion",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2. Timing of Inspection Request: "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The scoring criteria for this category is:"]
[null,"1. Completeness of Inspection Submittal: Inspection Type & Documentation:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 1 point for an appropriately timed inspection"]
[null,"Was the site inspection request and submittal complete? (No missing information/documents which caused programmatic delays) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 0 points for an inopportune scheduling of a site inspection "]
[]
[null,null,null,false,null,"YES",null,null,null,null,false,null,"NO",null,null,null,null,{"$f":"(IF(ChkCompletenessYES=TRUE,1,0)+(IF(ChkCompletenessNO=TRUE,0,0)))","v":0},null,null,null,null,null,null,null,null,null,null,"The scoring criteria for this category is:"]
[null,"Documentation Included:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 4 Points for an \"Approved\" site inspection;"]
[null,null,false,"Photo Documentation (see template)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 3 Points for an \"Approved w/ Action Items\" site inspection;"]
[null,null,false,"Benchmarking Tool, with updated “50% complete” and/or “Substantial Completion” tab",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 2 Points for a \"Not Approved w/ Action Items - Minor\" site inspection;"]
[null,null,false,"Other (explain):",null,{"$f":"IF('[1]Site Inspection Request'!C32=\"\",\"\",'[1]Site Inspection Request'!C32)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 1 Point for a \"Not Approved w/ Action Items - Medium\" site inspection; and"]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 0 points for a \"Not Approved w/ Action Items - Major\" site inspection."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The scoring criteria for this category is:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 2 Points for a \"Good\" Designation for measure installations"]
[null,"2. Preparedness of the Provider:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 1 Point for a \"Fair\" Designation for measure installations"]
[null,"Was the Provider properly prepared for the inspection? (Construction status was appropriate for inspection type, Provider had already completed their own inspections, Provider was knowledgeable, organized, etc.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 0 Points for a \"Poor\" Designation for measure installations"]
[]
[]
[null,null,null,false,null,"YES",null,null,null,null,false,null,"NO",null,null,null,null,{"$f":"(IF(ChkInspectionRequestTimingYES=TRUE,1,0)+(IF(ChkInspectionRequestTimingNO=TRUE,0,0)))","v":0},null,null,null,null,null,null,null,null,null,null,"The scoring criteria for this category is:"]
[null,"If \"NO\", Note why:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 2 Points for a \"Good\" Designation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 1 Point for a \"Fair\" Designation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 0 Points for a \"Poor\" Designation"]
[]
[null,"3. Inspection Approval Status:"]
[null,null,null,null,null,"Definitions of Approval Status"]
[null,null,false,"APPROVED",null,"APPROVED = This site inspection meets all applicable Program requirements, and/or minimum performance standards.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"(((IF(ChkStatusApproved=TRUE,4,0))+(IF(ChkStatusApprovedWithAI=TRUE,3,0))+(IF(ChkStatusNotApprovedMINOR=TRUE,2,0))+(IF(ChkStatusNotApprovedMEDIUM=TRUE,1,0))+(IF(ChkStatusNotApprovedMAJOR=TRUE,0,0))))","v":0}]
[null,null,false,"APPROVED w/Action Items",null,"APPROVED w/ Action Items = This site inspection achieved incentive approval but additional items must be addressed by the Provider to achieve the final incentive."]
[null,null,false,"NOT APPROVED w/ Action Items - Minor",null,"NOT APPROVED w/ Action Items - Minor = This site inspection does not meet requirements for incentive approval. The remaining actions required to achieve approval are minor (submit minor documentation, etc.)."]
[null,null,false,"NOT APPROVED w/ Action Items - Medium",null,"NOT APPROVED w/ Action Items - Medium = This site inspection does not meet requirements for incentive approval. The remaining actions required to achieve approval are medium (some work was not installed as reported, some documentation was missing, etc.)."]
[null,null,false,"NOT APPROVED w/ Action Items - Major",null,"NOT APPROVED w/ Action Items - Major = This site inspection does not meet requirements for incentive approval. The remaining actions required to achieve approval are major (significant parts of work that the Provider said were installed were not actually installed, installed equipment does not meet any MPS, etc.)."]
[]
[null,"Additional Details:"]
[null,"(Inform why the project's approval status is as marked above.)"]
[]
[]
[]
[null,"4. Project Installations meet intent of SAV-IT and Industry Best Practices:"]
[]
[null,false,"Good, T&V/Install/Measures meet MPP MPS rqmts",null,null,false,"Fair, minor issues with T&V/Install/Measures",null,null,null,null,null,false,"Poor, Major issues with T&V/Install/Measures",null,null,null,{"$f":"(((IF(ChkInstallationGood=TRUE,2,0))+(IF(ChkInstallationFair=TRUE,1,0))+(IF(ChkInstallationPoor=TRUE,0,0))))","v":0}]
[null,"Additional Details:"]
[]
[]
[]
[null,"5. Inspector Follow-Up Work"]
[null,"**All \"APPROVED\" projects should have the \"Good\" designation checked for this section**"]
[]
[null,false,"Good, Meets Program Expectations",null,null,false,"Fair, Primary data included; needs follow-up",null,null,null,null,null,false,"Poor, Significant delays / Critical data missing",null,null,null,{"$f":"(((IF(ChkAddressingAIGood=TRUE,2,0))+(IF(ChkAddressingAIFair=TRUE,1,0))+(IF(ChkAddressingAIPoor=TRUE,0,0))))","v":0}]
[null,"Additional Details:"]
[]
[]
[]
[null,"*Reminder: Once performance report is complete be sure to Report the QC Scores by Clicking the Appropriate Macro Button*"]

{"sheet":"Inspection QC Report (100%)","index":35,"n_rows":70,"n_cols":54,"rows_kept":70,"cut":false,"hidden":false,"merged":[[14,3,14,6],[14,13,14,15],[10,18,11,25],[7,1,8,15],[10,1,11,10],[10,13,11,14],[10,15,11,15],[43,3,43,4],[43,5,43,15],[15,3,15,6],[15,13,15,15],[16,3,16,6],[16,13,16,15],[20,1,20,10],[21,1,22,15],[27,5,27,15],[29,2,30,15],[33,1,34,15],[38,2,39,15],[42,5,42,15],[44,3,44,4],[44,5,44,15],[45,3,45,4],[45,5,45,15],[46,3,46,4],[46,5,46,15],[47,3,47,4],[47,5,47,15],[51,2,52,15],[56,2,56,4],[56,6,56,10],[56,13,56,15],[56,18,82,24],[58,2,59,15],[64,2,64,4],[64,6,64,10],[64,13,64,15],[66,2,67,15],[69,1,70,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Case Managers",null,null,null,null,null,null,"kbahny@trcsolutions.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Location:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Albanese, Jacqueleen",null,null,null,null,null,null,"Please Report Site Inspection QC Score",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\\\\ntapa-carlst\\energyservices-dc1\\Projects\\MPP\\NC\\QC Materials"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Butler,Lee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Katz, Menachem"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lang, Karin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Morrison,Edward"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reuss, Caroline"]
[null,"• Inspector shall complete the following form and click one of the macro buttons on the right when the form is ready to be reported.\n• If the form is completed by the NYSERDA PM click  \"Notify QC Custodian…\" \n• If the form is completed by a TRC employee click \"Report Site Inspection QC Score\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Robbins,Lindsay"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wojcik, Kate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zias, Dean"]
[null,"MPP Provider Inspection Performance Report",null,null,null,null,null,null,null,null,null,null,null,"Total Score:",null,{"$f":"SUM(R24,R37,R44,R57,R65,)","v":0},null,null,"**Site Inspection QC Scores shall only be reported after the site inspection milestone has been completed and approved for payment by NYSERDA.**"]
[]
[null,"General Information:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1. Completeness of Inspection Submittal:"]
[null,"Project Name:",null,{"$f":"IF('Inspection Memo (100%)'!C2=\"\",\"\",'Inspection Memo (100%)'!C2)","v":""},null,null,null,null,null,null,"Inspection Date:",null,null,{"$f":"IF('Inspection Memo (100%)'!C10=\"\",\"\",'Inspection Memo (100%)'!C10)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The scoring criteria for this category is:"]
[null,"Project Address:",null,{"$f":"IF('Site Inspection Request (100%)'!C4=\"\",\"\",'Site Inspection Request (100%)'!C4)","v":" , NY "},null,null,null,null,null,null,"Provider Company:",null,null,{"$f":"IF('Inspection Memo (100%)'!C8=\"\",\"\",'Inspection Memo (100%)'!C8)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null," 1 point for a complete submittal"]
[null,"Project Manager:",null,{"$f":"IF('Inspection Memo (100%)'!C9=\"\",\"\",'Inspection Memo (100%)'!C9)","v":""},null,null,null,null,null,null,"Site Inspector:",null,null,{"$f":"IF('Inspection Memo (100%)'!C104=\"\",\"\",'Inspection Memo (100%)'!C104)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null," 0 points for an incomplete submittal  "]
[]
[null,"Inspection Type:",null,false,null,"50% Complete",null,null,null,null,true,null,"Substantial Completion",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2. Timing of Inspection Request: "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The scoring criteria for this category is:"]
[null,"1. Completeness of Inspection Submittal: Inspection Type & Documentation:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 1 point for an appropriately timed inspection"]
[null,"Was the site inspection request and submittal complete? (No missing information/documents which caused programmatic delays) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 0 points for an inopportune scheduling of a site inspection "]
[]
[null,null,null,false,null,"YES",null,null,null,null,false,null,"NO",null,null,null,null,{"$f":"(IF(ChkCompletenessYES=TRUE,1,0)+(IF(ChkCompletenessNO=TRUE,0,0)))","v":0},null,null,null,null,null,null,null,null,null,null,"The scoring criteria for this category is:"]
[null,"Documentation Included:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 4 Points for an \"Approved\" site inspection;"]
[null,null,false,"Photo Documentation (see template)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 3 Points for an \"Approved w/ Action Items\" site inspection;"]
[null,null,false,"Benchmarking Tool, with updated “50% complete” and/or “Substantial Completion” tab",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 2 Points for a \"Not Approved w/ Action Items - Minor\" site inspection;"]
[null,null,false,"Other (explain):",null,{"$f":"IF('[1]Site Inspection Request'!C32=\"\",\"\",'[1]Site Inspection Request'!C32)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 1 Point for a \"Not Approved w/ Action Items - Medium\" site inspection; and"]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 0 points for a \"Not Approved w/ Action Items - Major\" site inspection."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The scoring criteria for this category is:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 2 Points for a \"Good\" Designation for measure installations"]
[null,"2. Preparedness of the Provider:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 1 Point for a \"Fair\" Designation for measure installations"]
[null,"Was the Provider properly prepared for the inspection? (Construction status was appropriate for inspection type, Provider had already completed their own inspections, Provider was knowledgeable, organized, etc.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 0 Points for a \"Poor\" Designation for measure installations"]
[]
[]
[null,null,null,false,null,"YES",null,null,null,null,false,null,"NO",null,null,null,null,{"$f":"(IF(ChkInspectionRequestTimingYES=TRUE,1,0)+(IF(ChkInspectionRequestTimingNO=TRUE,0,0)))","v":0},null,null,null,null,null,null,null,null,null,null,"The scoring criteria for this category is:"]
[null,"If \"NO\", Note why:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 2 Points for a \"Good\" Designation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 1 Point for a \"Fair\" Designation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 0 Points for a \"Poor\" Designation"]
[]
[null,"3. Inspection Approval Status:"]
[null,null,null,null,null,"Definitions of Approval Status"]
[null,null,false,"APPROVED",null,"APPROVED = This site inspection meets all applicable Program requirements, and/or minimum performance standards.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"(((IF(ChkStatusApproved=TRUE,4,0))+(IF(ChkStatusApprovedWithAI=TRUE,3,0))+(IF(ChkStatusNotApprovedMINOR=TRUE,2,0))+(IF(ChkStatusNotApprovedMEDIUM=TRUE,1,0))+(IF(ChkStatusNotApprovedMAJOR=TRUE,0,0))))","v":0}]
[null,null,false,"APPROVED w/Action Items",null,"APPROVED w/ Action Items = This site inspection achieved incentive approval but additional items must be addressed by the Provider to achieve the final incentive."]
[null,null,false,"NOT APPROVED w/ Action Items - Minor",null,"NOT APPROVED w/ Action Items - Minor = This site inspection does not meet requirements for incentive approval. The remaining actions required to achieve approval are minor (submit minor documentation, etc.)."]
[null,null,false,"NOT APPROVED w/ Action Items - Medium",null,"NOT APPROVED w/ Action Items - Medium = This site inspection does not meet requirements for incentive approval. The remaining actions required to achieve approval are medium (some work was not installed as reported, some documentation was missing, etc.)."]
[null,null,false,"NOT APPROVED w/ Action Items - Major",null,"NOT APPROVED w/ Action Items - Major = This site inspection does not meet requirements for incentive approval. The remaining actions required to achieve approval are major (significant parts of work that the Provider said were installed were not actually installed, installed equipment does not meet any MPS, etc.)."]
[]
[null,"Additional Details:"]
[null,"(Inform why the project's approval status is as marked above.)"]
[]
[]
[]
[null,"4. Project Installations meet intent of SAV-IT and Industry Best Practices:"]
[]
[null,false,"Good, T&V/Install/Measures meet MPP MPS rqmts",null,null,false,"Fair, minor issues with T&V/Install/Measures",null,null,null,null,null,false,"Poor, Major issues with T&V/Install/Measures",null,null,null,{"$f":"(((IF(ChkInstallationGood=TRUE,2,0))+(IF(ChkInstallationFair=TRUE,1,0))+(IF(ChkInstallationPoor=TRUE,0,0))))","v":0}]
[null,"Additional Details:"]
[]
[]
[]
[null,"5. Inspector Follow-Up Work"]
[null,"**All \"APPROVED\" projects should have the \"Good\" designation checked for this section**"]
[]
[null,false,"Good, Meets Program Expectations",null,null,false,"Fair, Primary data included; needs follow-up",null,null,null,null,null,false,"Poor, Significant delays / Critical data missing",null,null,null,{"$f":"(((IF(ChkAddressingAIGood=TRUE,2,0))+(IF(ChkAddressingAIFair=TRUE,1,0))+(IF(ChkAddressingAIPoor=TRUE,0,0))))","v":0}]
[null,"Additional Details:"]
[]
[]
[]
[null,"*Reminder: Once performance report is complete be sure to Report the QC Scores by Clicking the Appropriate Macro Button*"]