{"text_format":"1","workbook":"xlsx","n_sheets":38,"sheets":["Welcome","Tabs","DataValidationLists","MeasureClassification v4.2","MeasureClassification v5.1","MeasureClassification v5.2&6.1","Data Import","Instructions for Partner","Site Inspection Request - 50%","Site Inspection Request - 100%","Inspection Memo - 50%","Inspection Memo - 100%","Project Workscope - 50%","Project Workscope - 100%","Lighting Schedule","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","Other","Motors","Pipe Improvements","Ventilation Imp.","VFD Upgrades","Windows","Inspection QC Report - 50%","Inspection QC Report - 100%"],"not_rendered":{"charts":0,"images":88,"macros":1,"external_links":2,"defined_names":97,"comments":6,"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"]
["Tabs","Yes","Yes"]
["Welcome","No","No"]
["DataValidationLists","Yes","Yes"]
["MeasureClassification v4.2","Yes","Yes"]
["MeasureClassification v5.1","Yes","Yes"]
["MeasureClassification v5.2&6.1","Yes","Yes"]
["Instructions for Partner","No","No"]
["Inspection Memo - 50%","No","No"]
["Inspection Memo - 100%","No","No"]
["Data Import","Yes","Yes"]
["Site Inspection Request - 50%","No","No"]
["Site Inspection Request - 100%","No","No"]
["Project Workscope - 50%","No","No"]
["Project Workscope - 100%","No","No"]
["Lighting Schedule","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"]
["Other","Yes","No"]
["Motors","Yes","No"]
["Pipe Improvements","Yes","No"]
["Ventilation Imp.","Yes","No"]
["VFD Upgrades","Yes","No"]
["Windows","Yes","No"]

{"sheet":"DataValidationLists","index":2,"n_rows":22,"n_cols":8,"rows_kept":22,"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"]
["Pipe Improvements"]
["Ventilation Improvements"]
["VFD Upgrades"]
["Windows"]

{"sheet":"MeasureClassification v4.2","index":3,"n_rows":69,"n_cols":7,"rows_kept":69,"cut":false,"hidden":true,"merged":[[1,1,1,7]]}
["SHOULD BE THE SAME AS V5.1"]
["Workbook Measures","Comparisons"]
[]
["Air Sealing","Envelope - Air Sealing"]
["Appliances","Appliance - Clothes Washer","Appliance - Dishwasher","Appliance - Refrigerator","HVAC - Window AC","Other - Vending Miser","Other - Submetering"]
["Cooling","HVAC - Chiller","HVAC - Window AC","HVAC - Economizer (dry bulb)"]
["DHW",{"$f":"A30","v":"DHW - Controls"},"DHW - Electric (Central)","DHW - Electric (In-Unit)","DHW - Gas (Central)","DHW - Gas (In-Unit)","DHW - Indirect"]
["Duct Improvements","HVAC - Duct Sealing"]
["Elevators"]
["EMS & Temp Controls","HVAC - EMS","HVAC - Programmable Thermostat"]
["Envelope Insulation","Envelope - Roof Insulation","Envelope - Wall Insulation"]
["Exterior Doors","Envelope - Storm Windows/Doors"]
["Heat & Energy Recovery","HVAC - HRV"]
["Heating","HVAC - Boiler (Central)","HVAC - Central AC/HP","HVAC - Furnace","HVAC - Split System AC/HP","HVAC - Water Source AC/HP","HVAC - Boiler (In-Unit)"]
["Heating Distribution Imp.","HVAC - TRVs","HVAC - Economizer (dry bulb)"]
["Lighting - Apt.","Lighting - In-Unit CFL ","Lighting - In-Unit Fixture"]
["Lighting - Common Area","Lighting - Common CFLs","Lighting - Common Fixtures, Exit","Lighting - Common Timers/Sensors","Lighting - Exterior"]
["Low-Flow Devices","DHW - Low-flow Devices"]
["Motors","Other - Motors/Pumps/Fans/Elevators"]
["Pipe Improvements","Other - Pipe Insulation"]
["Ventilation Improvements","HVAC - Ventilation CARs","HVAC - Ventilation Central Controls"]
["VFD Upgrades","Other - Var. Speed Drive"]
["Windows","Envelope - Windows"]
[]
[]
["ERP TABLES MEASURE CLASSIFICATION"]
["Appliance - Clothes Washer","x"]
["Appliance - Dishwasher","x"]
["Appliance - Refrigerator","x"]
["DHW - Controls","x"]
["DHW - Electric (Central)","x"]
["DHW - Electric (In-Unit)","x"]
["DHW - Gas (Central)","x"]
["DHW - Gas (In-Unit)","x"]
["DHW - Indirect","x"]
["DHW - Low-flow Devices","x"]
["Envelope - Air Sealing","x"]
["Envelope - Roof Insulation","x"]
["Envelope - Storm Windows/Doors","x"]
["Envelope - Wall Insulation","x"]
["Envelope - Windows","x"]
["HVAC - Boiler (Central)","x"]
["HVAC - Boiler (In-Unit)","x"]
["HVAC - Central AC/HP","x"]
["HVAC - Chiller","x"]
["HVAC - Duct Sealing","x"]
["HVAC - Economizer (dry bulb)","x"]
["HVAC - EMS","x"]
["HVAC - Furnace","x"]
["HVAC - HRV","x"]
["HVAC - Programmable Thermostat","x"]
["HVAC - Split System AC/HP","x"]
["HVAC - TRVs","x"]
["HVAC - Ventilation CARs","x"]
["HVAC - Ventilation Central Controls","x"]
["HVAC - Water Source AC/HP","x"]
["HVAC - Window AC","x"]
["Lighting - Common CFLs","x"]
["Lighting - Common Fixtures, Exit","x"]
["Lighting - Common Timers/Sensors","x"]
["Lighting - Exterior","x"]
["Lighting - In-Unit CFL ","x"]
["Lighting - In-Unit Fixture","x"]
["Other - Motors/Pumps/Fans","x"]
["Other - Pipe Insulation","x"]
["Other - Submetering","x"]
["Other - Var. Speed Drive","x"]
["Other - Vending Miser","x"]
["Other","x"]

{"sheet":"MeasureClassification v5.1","index":4,"n_rows":68,"n_cols":7,"rows_kept":68,"cut":false,"hidden":true,"merged":[[0,1,0,7]]}
["Workbook Measures","Comparisons"]
["Air Sealing","Envelope - Air Sealing"]
["Appliances","Appliance - Clothes Washer","Appliance - Dishwasher","Appliance - Refrigerator","Other - Vending Miser","Other - Submetering"]
["Cooling","HVAC - Chiller","HVAC - Window AC","HVAC - Economizer (dry bulb)"]
["DHW",{"$f":"A29","v":"DHW - Controls"},"DHW - Electric (Central)","DHW - Electric (In-Unit)","DHW - Gas (Central)","DHW - Gas (In-Unit)","DHW - Indirect"]
["Duct Improvements","HVAC - Duct Sealing"]
["Elevators"]
["EMS & Temp Controls","HVAC - EMS","HVAC - Programmable Thermostat"]
["Envelope Insulation","Envelope - Roof Insulation","Envelope - Wall Insulation"]
["Exterior Doors","Envelope - Storm Windows/Doors"]
["Heat & Energy Rec.","HVAC - HRV"]
["Heating","HVAC - Boiler (Central)","HVAC - Central AC/HP","HVAC - Furnace","HVAC - Split System AC/HP","HVAC - Water Source AC/HP","HVAC - Boiler (In-Unit)"]
["Heating Dist. Imp.","HVAC - TRVs"]
["Lighting - Apt.","Lighting - In-Unit CFL ","Lighting - In-Unit Fixture"]
["Lighting - CA","Lighting - Common CFLs","Lighting - Common Fixtures, Exit","Lighting - Common Timers/Sensors","Lighting - Exterior"]
["Low-Flow Devices","DHW - Low-flow Devices"]
["Motors","Other - Motors/Pumps/Fans/Elevators","Other - Motors/Pumps/Fans"]
["Pipe Improvements","Other - Pipe Insulation"]
["Ventilation Imp.","HVAC - Ventilation CARs","HVAC - Ventilation Central Controls"]
["VFD Upgrades","Other - Var. Speed Drive"]
["Windows","Envelope - Windows"]
["Other","Other"]
[]
[]
["ERP TABLES MEASURE CLASSIFICATION"]
["Appliance - Clothes Washer","x"]
["Appliance - Dishwasher","x"]
["Appliance - Refrigerator","x"]
["DHW - Controls","x"]
["DHW - Electric (Central)","x"]
["DHW - Electric (In-Unit)","x"]
["DHW - Gas (Central)","x"]
["DHW - Gas (In-Unit)","x"]
["DHW - Indirect","x"]
["DHW - Low-flow Devices","x"]
["Envelope - Air Sealing","x"]
["Envelope - Roof Insulation","x"]
["Envelope - Storm Windows/Doors","x"]
["Envelope - Wall Insulation","x"]
["Envelope - Windows","x"]
["HVAC - Boiler (Central)","x"]
["HVAC - Boiler (In-Unit)","x"]
["HVAC - Central AC/HP","x"]
["HVAC - Chiller","x"]
["HVAC - Duct Sealing","x"]
["HVAC - Economizer (dry bulb)","x"]
["HVAC - EMS","x"]
["HVAC - Furnace","x"]
["HVAC - HRV","x"]
["HVAC - Programmable Thermostat","x"]
["HVAC - Split System AC/HP","x"]
["HVAC - TRVs","x"]
["HVAC - Ventilation CARs","x"]
["HVAC - Ventilation Central Controls","x"]
["HVAC - Water Source AC/HP","x"]
["HVAC - Window AC","x"]
["Lighting - Common CFLs","x"]
["Lighting - Common Fixtures, Exit","x"]
["Lighting - Common Timers/Sensors","x"]
["Lighting - Exterior","x"]
["Lighting - In-Unit CFL ","x"]
["Lighting - In-Unit Fixture","x"]
["Other - Motors/Pumps/Fans","x"]
["Other - Pipe Insulation","x"]
["Other - Submetering","x"]
["Other - Var. Speed Drive","x"]
["Other - Vending Miser","x"]
["Other","x"]

{"sheet":"MeasureClassification v5.2&6.1","index":5,"n_rows":89,"n_cols":11,"rows_kept":89,"cut":false,"hidden":true,"merged":[[0,1,0,10]]}
["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","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"]
["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"]
[]
[]
["ERP TABLES MEASURE CATEGORY","ERP 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"]
["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":6,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":true,"merged":[[0,0,0,2],[0,3,0,5],[0,6,0,8]]}
["Version 5.2/6.1 Import",null,null,"Version 5.1 Fast Track Import",null,null,"Version 5.1 Standard Import"]
["Inspection Request Reference","ERP Tool Reference","Compiled References","Inspection Request Reference","ERP Tool Reference","Compiled References","Inspection Request Reference","ERP Tool Reference","Compiled References"]
["='Inspection Memo - 50%'!DT_InspectionMemo50_ProjectName","='General Project Info'!DT_GeneralProjectInfo_ProjectInfo_Name",null,"='Inspection Memo - 50%'!DT_InspectionMemo50_ProjectName","='Project Info'!E17",null,"='Inspection Memo - 50%'!DT_InspectionMemo50_ProjectName","='General Project Info'!C3"]
["='Inspection Memo - 50%'!DT_InspectionMemo50_PartnerName","='General Project Info'!DT_GeneralProjectInfo_PartnerInfo_Name",null,"='Inspection Memo - 50%'!DT_InspectionMemo50_PartnerName","='Existing Conditions'!C20",null,"='Inspection Memo - 50%'!DT_InspectionMemo50_PartnerName","='General Project Info'!C78"]
["='Inspection Memo - 100%'!DT_InspectionMemo100_ProjectName","='General Project Info'!DT_GeneralProjectInfo_ProjectInfo_Name",null,"='Inspection Memo - 100%'!DT_InspectionMemo100_ProjectName","='Project Info'!E17",null,"='Inspection Memo - 100%'!DT_InspectionMemo100_ProjectName","='General Project Info'!C3"]
["='Inspection Memo - 100%'!DT_InspectionMemo100_PartnerName","='General Project Info'!DT_GeneralProjectInfo_PartnerInfo_Name",null,"='Inspection Memo - 100%'!DT_InspectionMemo100_PartnerName","='Existing Conditions'!C20",null,"='Inspection Memo - 100%'!DT_InspectionMemo100_PartnerName","='General Project Info'!C78"]
["='Site Inspection Request - 50%'!DT_SiteInspectionRequest50_ProjectName","='General Project Info'!DT_GeneralProjectInfo_ProjectInfo_Name",null,"='Site Inspection Request - 50%'!DT_SiteInspectionRequest50_ProjectName","='Project Info'!E17",null,"='Site Inspection Request - 50%'!DT_SiteInspectionRequest50_ProjectName","='General Project Info'!C3"]
["='Data Import'!DT_SiteInspectionRequest_StreetAddress","='General Project Info'!DT_GeneralProjectInfo_ProjectInfo_StreetAddress",null,"='Data Import'!DT_SiteInspectionRequest_StreetAddress","='Project Info'!E18",null,"='Data Import'!DT_SiteInspectionRequest_StreetAddress","='General Project Info'!C4"]
["='Data Import'!DT_SiteInspectionRequest_City","='General Project Info'!DT_GeneralProjectInfo_ProjectInfo_City",null,"='Data Import'!DT_SiteInspectionRequest_City","='Project Info'!E19",null,"='Data Import'!DT_SiteInspectionRequest_City","='General Project Info'!D4"]
["='Data Import'!DT_SiteInspectionRequest_Zip","='General Project Info'!DT_GeneralProjectInfo_ProjectInfo_Zip",null,"='Data Import'!DT_SiteInspectionRequest_Zip","='Project Info'!G20",null,"='Data Import'!DT_SiteInspectionRequest_Zip","='General Project Info'!C5"]
[null,null,{"$f":"DT_SiteInspectionRequest_StreetAddress&\" \"&DT_SiteInspectionRequest_City&\", NY \"&DT_SiteInspectionRequest_Zip","v":" , NY "},null,null,{"$f":"DT_SiteInspectionRequest_StreetAddress&\" \"&DT_SiteInspectionRequest_City&\", NY \"&DT_SiteInspectionRequest_Zip","v":" , NY "},null,null,{"$f":"DT_SiteInspectionRequest_StreetAddress&\" \"&DT_SiteInspectionRequest_City&\", NY \"&DT_SiteInspectionRequest_Zip","v":" , NY "}]
["='Site Inspection Request - 50%'!DT_SiteInspectionRequest50_Units","='General Project Info'!C25",null,"='Site Inspection Request - 50%'!DT_SiteInspectionRequest50_Units","='Project Info'!K28",null,"='Site Inspection Request - 50%'!DT_SiteInspectionRequest50_Units","='General Project Info'!C7"]
["='Site Inspection Request - 50%'!DT_SiteInspectionRequest50_Buildings","='General Project Info'!C24",null,"='Site Inspection Request - 50%'!DT_SiteInspectionRequest50_Buildings",null,null,"='Site Inspection Request - 50%'!DT_SiteInspectionRequest50_Buildings","='General Project Info'!C6"]
["='Site Inspection Request - 50%'!DT_SiteInspectionRequest50_Stories","='General Project Info'!DT_GeneralProjectInfo_BuildingInfo_NumStories1",null,"='Site Inspection Request - 50%'!DT_SiteInspectionRequest50_Stories","='Project Info'!E44",null,"='Site Inspection Request - 50%'!DT_SiteInspectionRequest50_Stories","='General Project Info'!C13"]
["='Site Inspection Request - 100%'!DT_SiteInspectionRequest100_ProjectName","='General Project Info'!DT_GeneralProjectInfo_ProjectInfo_Name",null,"='Site Inspection Request - 100%'!DT_SiteInspectionRequest100_ProjectName","='Project Info'!E17",null,"='Site Inspection Request - 100%'!DT_SiteInspectionRequest100_ProjectName","='General Project Info'!C3"]
["='Site Inspection Request - 100%'!DT_SiteInspectionRequest100_Units","='General Project Info'!C25",null,"='Site Inspection Request - 100%'!DT_SiteInspectionRequest100_Units","='Project Info'!K28",null,"='Site Inspection Request - 100%'!DT_SiteInspectionRequest100_Units","='General Project Info'!C7"]
["='Site Inspection Request - 100%'!DT_SiteInspectionRequest100_Buildings","='General Project Info'!C24",null,"='Site Inspection Request - 100%'!DT_SiteInspectionRequest100_Buildings",null,null,"='Site Inspection Request - 100%'!DT_SiteInspectionRequest100_Buildings","='General Project Info'!C6"]
["='Site Inspection Request - 100%'!DT_SiteInspectionRequest100_Stories","='General Project Info'!DT_GeneralProjectInfo_BuildingInfo_NumStories1",null,"='Site Inspection Request - 100%'!DT_SiteInspectionRequest100_Stories","='Project Info'!E44",null,"='Site Inspection Request - 100%'!DT_SiteInspectionRequest100_Stories","='General Project Info'!C13"]

{"sheet":"Instructions for Partner","index":7,"n_rows":69,"n_cols":8,"rows_kept":69,"cut":false,"hidden":false,"merged":[[21,2,21,18],[8,1,8,18],[9,1,9,18],[11,1,11,4],[12,1,12,18],[14,1,14,4],[15,2,15,6],[15,7,15,11],[16,1,16,18],[17,1,17,18],[18,1,18,18],[19,1,19,18],[20,1,20,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],[40,1,40,18],[22,2,22,18],[23,1,23,18],[24,1,24,18],[30,1,30,18],[32,1,32,6],[33,1,33,18],[38,1,38,6],[39,1,39,18],[35,1,35,6],[36,1,36,18],[27,1,27,18],[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],[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]]}
[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 Partner 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\nThe same version of this workbook should be used and updated throughout the inspection process. For example, if there are separate inspections for 50% and 100%, use the tool that was already filled out for the 50% inspection and update it to also include the 100% inspection. Please update the file name as appropriate for the 50% and 100% inspections. Also reflect all scope changes in the same workbook. "]
[]
[null,"Partner Requirements"]
[null,"1) The Partner is required to follow the Measure Implementation guidelines and Site Inspection Protocols as detailed in the Program Guidelines."]
[null,"2) The Partner is responsible for confirming that work was installed according to the scope of work included in the approved Energy Reduction Plan."]
[null,"3) When submitting a signed Statement of Substantial Completion, the Partner is still responsible for performing the necessary due diligence to ensure that the Statement of Substantial Completion is accurate and complete."]
[null,"4) The Partner is required to compare the quantities and specifications of the installed equipment to the assumptions made in the ERP 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 Partner must submit a separate photo documentation file containing photo documentation of completed measures. See instructions in photo documentation template titled: \"Project Name - 50% or 100% Complete Photo Documentation.docx\" Reference photos as necessary in each measure's \"As-Built Description.\""]
[]
[null,"How to Use this Tool"]
[null,"1) ","Partner fills out all Blue cells. ",null,null,null,null,"Program Inspector fills out all Orange cells."]
[null,"2) Click the \"Import from V5.1 ERP\" or \"Import from V5.2 ERP\" button on the Welcome tab to automatically input data from the respective ERP 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 ERP 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 50% and/or 100%"]
[null,null,"Project Workscope 50% and/or 100%"]
[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 50% or 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 ERP Tool that reflects that scope change. \n2) If a scope change is identified during the 50% inspection, use the \"Import V5.X Scope Change @ 50% 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.\n3) If a scope change is identified after the 50% inspection is approved and/or during the 100% inspection process, use the \"Import V5.X Scope Change @ 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,"Lighting Schedule"]
["*\n*","This tab will be populated by the \"Import from V5.1 ERP\" or \"Import from V5.2 ERP\" button, provided the Lighting tab has been filled out in the associated ERP Tool. Only lighting line items that include a recommended upgrade or replacement will be imported. Once populated, the imported data should be reviewed for accuracy. A sample of the installed lighting must be verified through inspections and/or Statements of Substantial Completion. Information on the light fixtures installed should be recorded in the blue cells under the \"Partner Verified\" section on the Lighting Schedule worksheet. It is not necessary to inspect every single light fixture, but the information included must be accurate and should be based on actual installed conditions confirmed by the Partner. It is not appropriate to copy and paste the proposed fixture information to installed fixtures 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 ERP tool. If an inspection is not yet being requested for a specific measure, the ERP 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 ERP tool. 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,"ERP Measure Description"]
["*\n*","This information should be populated from the ERP tool. If not, copy and paste the full description of the measure from the approved ERP. 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 ERP 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 ERP. 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,"Partner Inspection"]
["*\n*","Read the requirements for Partner 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 (Partner 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 Partner) 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 ERP verbatim, but to accurately reflect the installed conditions. This table must be completed, regardless of the type of documentation used (statement or Partner 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 - 50% or 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 Partner 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":8,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[[21,2,21,8],[1,2,1,8],[3,2,3,8],[17,2,17,8],[18,2,18,8],[4,5,4,6],[10,6,10,8],[8,5,8,8],[6,5,6,8],[7,5,7,8],[9,6,9,8],[0,0,0,8],[32,0,32,1],[32,2,39,8],[22,2,22,8],[23,2,23,8],[24,2,24,8],[25,2,25,8],[28,1,28,7],[30,2,30,8],[4,0,4,1],[6,0,7,3],[14,2,14,8],[15,2,15,8],[16,2,16,8],[8,0,11,3],[11,5,11,8]]}
["Leave this tab blank if submitting for a 50% and 100% complete inspection at the same time."]
["Project Name:"]
[]
["Project Address:",null,{"$f":"'Data Import'!C11","v":" , NY "}]
["# of Units:",null,null,"# of Buildings:",null,null,null,"# of Stories:"]
[]
["Type of site inspection being requested?",null,null,null,null," 50% Completion"," 50% Completion"]
[null,null,null,null,null," Re-inspection"," Re-inspection"]
["Firm Gas Conversion Project?",null,null,null,null,"Yes","Yes"]
[null,null,null,null,null,null,"Complete (boiler operating on firm gas)"]
[null,null,null,null,null,null,"Incomplete"]
[null,null,null,null,null,"No"]
[]
["Partner 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,"Scope Change Request (with associated files)"]
[null,"Other (explain):"]
[]
["Comments:"]

{"sheet":"Site Inspection Request - 100%","index":9,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[[8,0,11,3],[4,5,4,6],[6,5,6,8],[7,5,7,8],[8,5,8,8],[11,5,11,8],[34,0,34,1],[34,2,41,8],[1,2,1,8],[3,2,3,8],[4,0,4,1],[4,3,4,4],[6,0,7,3],[16,2,16,8],[17,2,17,8],[18,2,18,8],[19,2,19,8],[20,2,20,8],[23,2,23,8],[24,2,24,8],[25,2,25,8],[12,0,13,3],[30,1,30,7],[32,2,32,8],[26,2,26,8],[27,2,27,8],[12,5,12,8],[13,5,13,8]]}
[]
["Project Name:"]
[]
["Project Address:",null,{"$f":"'Data Import'!C11","v":" , NY "}]
["# of Units:",null,null,"# of Buildings:",null,null,null,"# of Stories:"]
[]
["Type of site inspection being requested?",null,null,null,null," Substantial Completion"]
[null,null,null,null,null," Re-inspection"," Re-inspection"]
["Firm Gas Conversion Project?",null,null,null,null,"Yes","Yes"]
[null,null,null,null,null,null,"Complete (boiler operating on firm gas)"]
[null,null,null,null,null,null,"Incomplete"]
[null,null,null,null,null,"No","No"]
["If applicable, have action items been addressed from previous inspections?",null,null,null,null,"Yes (please describe action taken on Inspection Memo worksheet)","Yes (please describe action taken on Inspection Memo worksheet)"]
[null,null,null,null,null,"N/A (there are no action items from previous inspections)","N/A (there are no action items from previous inspections)"]
[]
["Partner 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,"Scope Change Request (with associated files)"]
[null,"Other (explain):"]
[]
["Comments:"]

{"sheet":"Inspection Memo - 50%","index":10,"n_rows":129,"n_cols":9,"rows_kept":129,"cut":false,"hidden":false,"merged":[[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],[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],[69,8,74,8],[80,8,85,8],[91,8,96,8],[25,8,30,8],[36,8,41,8],[47,8,52,8],[58,8,63,8],[98,1,98,7],[99,1,99,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],[83,0,85,2],[83,3,85,3],[83,7,85,7],[87,1,87,7],[88,1,88,7],[69,0,71,2],[69,3,71,3],[69,4,71,6],[100,1,100,7],[91,0,93,2],[91,3,93,3],[91,4,93,6],[91,7,93,7],[94,0,96,2],[94,3,96,3],[94,7,96,7],[89,1,89,7],[69,7,71,7],[72,0,74,2],[72,3,74,3],[72,7,74,7],[67,1,67,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],[61,0,63,2],[61,3,63,3],[61,7,63,7],[65,1,65,7],[66,1,66,7],[47,0,49,2],[47,3,49,3],[47,4,49,6],[47,7,49,7],[50,0,52,2],[50,3,52,3],[50,7,52,7],[45,1,45,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],[39,0,41,2],[39,3,41,3],[39,7,41,7],[43,1,43,7],[44,1,44,7],[28,0,30,2],[28,3,30,3],[28,7,30,7],[19,0,23,7],[25,0,27,2],[25,3,27,3],[25,4,27,6],[25,7,27,7],[1,2,1,7],[7,0,7,1],[8,0,8,1],[9,0,9,1],[11,0,12,1],[11,2,16,7],[4,3,4,7],[7,2,7,7],[8,2,8,7],[9,2,9,7],[3,0,4,1],[5,0,6,1]]}
[]
["Project Name:"]
[]
["Inspection Type:",null,null,"50% Completion",null,null,"Substantial Completion"]
[null,null,null,"Re-Inspection"]
["Approval Status:",null,null,"APPROVED Incentive #2",null,null,"APPROVED Incentive #3"]
[null,null,null,"Action Items Included",null,null,"NOT APPROVED"]
["MPP Partner:"]
["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 ERP and Exhibit C. 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","Partner'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","Partner'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","Partner'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","Partner'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","Partner'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","Partner'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","Partner'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:"]
[]
["Partner 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":11,"n_rows":129,"n_cols":9,"rows_kept":129,"cut":false,"hidden":false,"merged":[[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],[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],[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],[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],[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],[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],[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],[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]]}
[]
["Project Name:"]
[]
["Inspection Type:",null,null,"50% Completion",null,null,"Substantial Completion"]
[null,null,null,"Re-Inspection"]
["Approval Status:",null,null,"APPROVED Incentive #2",null,null,"APPROVED Incentive #3"]
[null,null,null,"Action Items Included",null,null,"NOT APPROVED"]
["MPP Partner:"]
["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 ERP and Exhibit C. 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","Partner'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","Partner'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","Partner'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","Partner'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","Partner'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","Partner'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","Partner'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:"]
[]
["Partner 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":12,"n_rows":114,"n_cols":23,"rows_kept":114,"cut":false,"hidden":false,"merged":[[3,17,3,20],[4,17,4,20],[89,15,92,15],[89,16,92,16],[93,15,96,15],[93,16,96,16],[97,15,100,15],[97,16,100,16],[101,15,104,15],[101,16,104,16],[85,15,88,15],[85,16,88,16],[81,15,84,15],[81,16,84,16],[61,15,64,15],[61,16,64,16],[37,15,40,15],[37,16,40,16],[77,15,80,15],[77,16,80,16],[17,16,20,16],[21,15,24,15],[21,16,24,16],[25,16,28,16],[105,15,108,15],[105,16,108,16],[105,0,108,0],[105,1,108,1],[105,2,108,2],[105,3,108,3],[105,4,108,4],[105,5,108,5],[105,6,108,6],[105,7,108,7],[105,8,108,8],[101,0,104,0],[101,1,104,1],[101,2,104,2],[101,3,104,3],[101,4,104,4],[101,5,104,5],[101,6,104,6],[101,7,104,7],[101,8,104,8],[93,2,96,2],[93,3,96,3],[93,4,96,4],[93,5,96,5],[93,6,96,6],[93,7,96,7],[93,8,96,8],[97,0,100,0],[97,1,100,1],[97,2,100,2],[97,3,100,3],[97,4,100,4],[97,5,100,5],[97,6,100,6],[97,7,100,7],[97,8,100,8],[93,0,96,0],[93,1,96,1],[49,0,52,0],[49,1,52,1],[49,2,52,2],[45,0,48,0],[45,1,48,1],[45,2,48,2],[45,3,48,3],[45,4,48,4],[45,5,48,5],[49,3,52,3],[49,4,52,4],[49,5,52,5],[57,6,60,6],[57,7,60,7],[57,8,60,8],[57,15,60,15],[57,16,60,16],[53,15,56,15],[53,16,56,16],[45,15,48,15],[45,16,48,16],[45,6,48,6],[45,7,48,7],[45,8,48,8],[49,6,52,6],[49,7,52,7],[49,8,52,8],[49,15,52,15],[49,16,52,16],[53,0,56,0],[53,1,56,1],[53,2,56,2],[53,3,56,3],[53,4,56,4],[53,5,56,5],[53,6,56,6],[53,7,56,7],[53,8,56,8],[57,0,60,0],[57,1,60,1],[57,2,60,2],[57,3,60,3],[57,4,60,4],[57,5,60,5],[61,0,64,0],[61,1,64,1],[61,2,64,2],[61,3,64,3],[61,4,64,4],[61,5,64,5],[61,6,64,6],[61,7,64,7],[61,8,64,8],[65,3,68,3],[65,4,68,4],[65,5,68,5],[65,6,68,6],[65,7,68,7],[65,8,68,8],[69,6,72,6],[69,7,72,7],[69,8,72,8],[73,15,76,15],[73,16,76,16],[69,15,72,15],[69,16,72,16],[65,15,68,15],[65,16,68,16],[73,6,76,6],[73,7,76,7],[73,8,76,8],[65,0,68,0],[65,1,68,1],[65,2,68,2],[73,0,76,0],[73,1,76,1],[73,2,76,2],[73,3,76,3],[73,4,76,4],[73,5,76,5],[69,0,72,0],[69,1,72,1],[69,2,72,2],[69,3,72,3],[69,4,72,4],[69,5,72,5],[77,3,80,3],[77,4,80,4],[77,5,80,5],[77,6,80,6],[77,7,80,7],[77,8,80,8],[81,0,84,0],[81,1,84,1],[81,2,84,2],[81,3,84,3],[81,4,84,4],[81,5,84,5],[81,6,84,6],[81,7,84,7],[81,8,84,8],[41,0,44,0],[41,1,44,1],[41,2,44,2],[37,0,40,0],[37,1,40,1],[37,2,40,2],[37,3,40,3],[37,4,40,4],[37,5,40,5],[37,8,40,8],[5,10,5,11],[10,8,11,8],[10,9,10,14],[10,15,12,15],[10,16,11,16],[10,17,10,22],[11,9,12,14],[11,17,12,22],[9,0,9,14],[10,0,12,0],[10,1,12,1],[10,2,12,2],[10,3,11,3],[10,4,12,4],[10,5,12,5],[10,6,12,6],[10,7,12,7],[7,15,7,16],[13,16,16,16],[33,15,36,15],[33,16,36,16],[13,0,16,0],[13,1,16,1],[13,2,16,2],[13,3,16,3],[13,4,16,4],[13,5,16,5],[17,4,20,4],[17,5,20,5],[13,6,16,6],[17,0,20,0],[17,1,20,1],[17,2,20,2],[17,3,20,3],[13,7,16,7],[13,8,16,8],[17,6,20,6],[17,7,20,7],[17,8,20,8],[13,15,16,15],[17,15,20,15],[21,8,24,8],[25,6,28,6],[25,7,28,7],[25,8,28,8],[25,15,28,15],[21,6,24,6],[21,7,24,7],[21,0,24,0],[21,1,24,1],[21,2,24,2],[21,3,24,3],[21,4,24,4],[21,5,24,5],[25,0,28,0],[25,1,28,1],[25,2,28,2],[25,3,28,3],[25,4,28,4],[25,5,28,5],[29,16,32,16],[41,8,44,8],[33,0,36,0],[33,1,36,1],[33,2,36,2],[29,0,32,0],[29,1,32,1],[29,2,32,2],[29,3,32,3],[29,4,32,4],[29,5,32,5],[33,3,36,3],[33,4,36,4],[33,5,36,5],[33,6,36,6],[33,7,36,7],[33,8,36,8],[41,15,44,15],[41,16,44,16],[29,6,32,6],[29,7,32,7],[29,8,32,8],[37,6,40,6],[37,7,40,7],[89,0,92,0],[89,1,92,1],[89,2,92,2],[89,3,92,3],[89,4,92,4],[89,5,92,5],[89,6,92,6],[89,7,92,7],[89,8,92,8],[85,0,88,0],[85,1,88,1],[85,2,88,2],[85,3,88,3],[85,4,88,4],[85,5,88,5],[85,6,88,6],[85,7,88,7],[85,8,88,8],[113,0,113,2],[113,9,113,14],[3,2,3,3],[4,2,4,3],[109,6,112,6],[109,7,112,7],[109,8,112,8],[109,15,112,15],[109,16,112,16],[77,0,80,0],[77,1,80,1],[77,2,80,2],[109,0,112,0],[109,1,112,1],[109,2,112,2],[109,3,112,3],[109,4,112,4],[109,5,112,5],[41,3,44,3],[41,4,44,4],[41,5,44,5],[41,6,44,6],[41,7,44,7],[29,15,32,15]]}
["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:"]
["Partner Field Inspector Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QC Field Inspector Name:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Firm Gas Conversion:",null,null,"Complete",null,"Incomplete",null,"N/A"]
[]
["Partner 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 Partner 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(D14=0,\"\",D14/$D$114)","v":""},{"$f":"IF(D14=0,\"\",F14*D14)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P14*D14","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner Sampling or",null,"Statement of Completion",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(D18=0,\"\",D18/$D$114)","v":""},{"$f":"IF(D18=0,\"\",F18*D18)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P18*D18","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner Sampling or",null,"Statement of Completion",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(D22=0,\"\",D22/$D$114)","v":""},{"$f":"IF(D22=0,\"\",F22*D22)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P22*D22","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner Sampling or",null,"Statement of Completion",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(D26=0,\"\",D26/$D$114)","v":""},{"$f":"IF(D26=0,\"\",F26*D26)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P26*D26","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner Sampling or",null,"Statement of Completion",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(D30=0,\"\",D30/$D$114)","v":""},{"$f":"IF(D30=0,\"\",F30*D30)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P30*D30","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner Sampling or",null,"Statement of Completion",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(D34=0,\"\",D34/$D$114)","v":""},{"$f":"IF(D34=0,\"\",F34*D34)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P34*D34","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner Sampling or",null,"Statement of Completion",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(D38=0,\"\",D38/$D$114)","v":""},{"$f":"IF(D38=0,\"\",F38*D38)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P38*D38","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner Sampling or",null,"Statement of Completion",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(D42=0,\"\",D42/$D$114)","v":""},{"$f":"IF(D42=0,\"\",F42*D42)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P42*D42","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner Sampling or",null,"Statement of Completion",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(D46=0,\"\",D46/$D$114)","v":""},{"$f":"IF(D46=0,\"\",F46*D46)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P46*D46","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner Sampling or",null,"Statement of Completion",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(D50=0,\"\",D50/$D$114)","v":""},{"$f":"IF(D50=0,\"\",F50*D50)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P50*D50","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner Sampling or",null,"Statement of Completion",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(D54=0,\"\",D54/$D$114)","v":""},{"$f":"IF(D54=0,\"\",F54*D54)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P54*D54","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner Sampling or",null,"Statement of Completion",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(D58=0,\"\",D58/$D$114)","v":""},{"$f":"IF(D58=0,\"\",F58*D58)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P58*D58","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner Sampling or",null,"Statement of Completion",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(D62=0,\"\",D62/$D$114)","v":""},{"$f":"IF(D62=0,\"\",F62*D62)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P62*D62","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner Sampling or",null,"Statement of Completion",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(D66=0,\"\",D66/$D$114)","v":""},{"$f":"IF(D66=0,\"\",F66*D66)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P66*D66","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner Sampling or",null,"Statement of Completion",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(D70=0,\"\",D70/$D$114)","v":""},{"$f":"IF(D70=0,\"\",F70*D70)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P70*D70","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner Sampling or",null,"Statement of Completion",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(D74=0,\"\",D74/$D$114)","v":""},{"$f":"IF(D74=0,\"\",F74*D74)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P74*D74","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner Sampling or",null,"Statement of Completion",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(D78=0,\"\",D78/$D$114)","v":""},{"$f":"IF(D78=0,\"\",F78*D78)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P78*D78","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner Sampling or",null,"Statement of Completion",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(D82=0,\"\",D82/$D$114)","v":""},{"$f":"IF(D82=0,\"\",F82*D82)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P82*D82","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner Sampling or",null,"Statement of Completion",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(D86=0,\"\",D86/$D$114)","v":""},{"$f":"IF(D86=0,\"\",F86*D86)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P86*D86","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner Sampling or",null,"Statement of Completion",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(D90=0,\"\",D90/$D$114)","v":""},{"$f":"IF(D90=0,\"\",F90*D90)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P90*D90","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner Sampling or",null,"Statement of Completion",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(D94=0,\"\",D94/$D$114)","v":""},{"$f":"IF(D94=0,\"\",F94*D94)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P94*D94","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner Sampling or",null,"Statement of Completion",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(D98=0,\"\",D98/$D$114)","v":""},{"$f":"IF(D98=0,\"\",F98*D98)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P98*D98","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner Sampling or",null,"Statement of Completion",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(D102=0,\"\",D102/$D$114)","v":""},{"$f":"IF(D102=0,\"\",F102*D102)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P102*D102","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner Sampling or",null,"Statement of Completion",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(D106=0,\"\",D106/$D$114)","v":""},{"$f":"IF(D106=0,\"\",F106*D106)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P106*D106","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner Sampling or",null,"Statement of Completion",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(D110=0,\"\",D110/$D$114)","v":""},{"$f":"IF(D110=0,\"\",F110*D110)","v":""},null,"Installation has not begun",null,null,null,null,null,{"$f":"P110*D110","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner Sampling or",null,"Statement of Completion",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"]
["Partner Progress To Date:",null,null,{"$f":"SUM(D14:D113)","v":0},{"$f":"SUM(E14:E113)","v":0},{"$f":"SUMIF(G14:G113,\"<>Yes\",I14:I113)/SUMIF(G14:G113,\"<>Yes\",D14:D113)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(H14:H113)","v":0},{"$f":"SUM(I14:I113)","v":0},"Actual Progress To Date:",null,null,null,null,null,{"$f":"SUMIF(G14:G113,\"<>Yes\",Q14:Q113)/SUMIF(G14:G113,\"<>Yes\",D14:D113)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(Q14:Q113)","v":0}]

{"sheet":"Project Workscope - 100%","index":13,"n_rows":114,"n_cols":24,"rows_kept":114,"cut":false,"hidden":false,"merged":[[3,17,3,21],[4,17,4,21],[85,17,88,17],[81,17,84,17],[17,17,20,17],[13,17,16,17],[10,18,10,23],[89,15,92,15],[89,16,92,16],[89,17,92,17],[81,16,84,16],[73,15,76,15],[73,17,76,17],[73,16,76,16],[77,17,80,17],[69,15,72,15],[69,17,72,17],[69,16,72,16],[57,15,60,15],[57,17,60,17],[57,16,60,16],[53,15,56,15],[53,17,56,17],[53,16,56,16],[93,15,96,15],[93,16,96,16],[93,17,96,17],[97,15,100,15],[97,16,100,16],[97,17,100,17],[101,15,104,15],[101,16,104,16],[101,17,104,17],[105,15,108,15],[105,16,108,16],[105,17,108,17],[105,0,108,0],[105,1,108,1],[105,2,108,2],[105,3,108,3],[105,4,108,4],[105,5,108,5],[105,6,108,6],[105,7,108,7],[105,8,108,8],[101,0,104,0],[101,1,104,1],[101,2,104,2],[101,3,104,3],[101,4,104,4],[101,5,104,5],[101,6,104,6],[101,7,104,7],[101,8,104,8],[93,7,96,7],[93,8,96,8],[97,0,100,0],[97,1,100,1],[97,2,100,2],[97,3,100,3],[97,4,100,4],[97,5,100,5],[97,6,100,6],[97,7,100,7],[97,8,100,8],[113,0,113,2],[113,9,113,14],[10,16,12,16],[13,16,16,16],[17,16,20,16],[21,16,24,16],[25,16,28,16],[29,16,32,16],[33,16,36,16],[37,16,40,16],[109,6,112,6],[109,7,112,7],[109,8,112,8],[109,15,112,15],[85,6,88,6],[85,7,88,7],[85,8,88,8],[85,15,88,15],[81,6,84,6],[81,7,84,7],[81,8,84,8],[81,15,84,15],[77,6,80,6],[77,7,80,7],[109,17,112,17],[109,16,112,16],[109,0,112,0],[109,1,112,1],[109,2,112,2],[109,3,112,3],[109,4,112,4],[109,5,112,5],[89,0,92,0],[89,1,92,1],[89,2,92,2],[89,3,92,3],[89,4,92,4],[89,5,92,5],[89,6,92,6],[89,7,92,7],[89,8,92,8],[93,0,96,0],[93,1,96,1],[93,2,96,2],[93,3,96,3],[93,4,96,4],[93,5,96,5],[93,6,96,6],[77,0,80,0],[77,1,80,1],[77,2,80,2],[77,3,80,3],[77,4,80,4],[77,5,80,5],[85,16,88,16],[85,0,88,0],[85,1,88,1],[85,2,88,2],[85,3,88,3],[85,4,88,4],[85,5,88,5],[77,8,80,8],[77,15,80,15],[77,16,80,16],[81,0,84,0],[81,1,84,1],[81,2,84,2],[81,3,84,3],[81,4,84,4],[81,5,84,5],[73,0,76,0],[73,1,76,1],[73,2,76,2],[73,3,76,3],[73,4,76,4],[73,5,76,5],[69,6,72,6],[69,7,72,7],[69,8,72,8],[73,6,76,6],[73,7,76,7],[73,8,76,8],[69,0,72,0],[69,1,72,1],[69,2,72,2],[69,3,72,3],[69,4,72,4],[69,5,72,5],[61,6,64,6],[61,7,64,7],[61,8,64,8],[65,6,68,6],[65,7,68,7],[65,8,68,8],[65,15,68,15],[65,17,68,17],[65,16,68,16],[61,15,64,15],[61,17,64,17],[61,16,64,16],[61,0,64,0],[61,1,64,1],[61,2,64,2],[61,3,64,3],[61,4,64,4],[61,5,64,5],[65,0,68,0],[65,1,68,1],[65,2,68,2],[65,3,68,3],[65,4,68,4],[65,5,68,5],[49,15,52,15],[49,17,52,17],[49,16,52,16],[57,0,60,0],[57,1,60,1],[57,2,60,2],[57,3,60,3],[57,4,60,4],[57,5,60,5],[53,6,56,6],[53,7,56,7],[53,8,56,8],[57,6,60,6],[57,7,60,7],[57,8,60,8],[53,0,56,0],[53,1,56,1],[53,2,56,2],[53,3,56,3],[53,4,56,4],[53,5,56,5],[49,0,52,0],[49,1,52,1],[49,2,52,2],[49,3,52,3],[49,4,52,4],[49,5,52,5],[45,6,48,6],[45,7,48,7],[45,8,48,8],[49,6,52,6],[49,7,52,7],[49,8,52,8],[41,17,44,17],[41,16,44,16],[45,15,48,15],[45,17,48,17],[45,16,48,16],[41,0,44,0],[41,1,44,1],[41,2,44,2],[41,3,44,3],[41,4,44,4],[41,5,44,5],[45,0,48,0],[45,1,48,1],[45,2,48,2],[45,3,48,3],[45,4,48,4],[45,5,48,5],[37,6,40,6],[37,7,40,7],[37,8,40,8],[41,6,44,6],[41,7,44,7],[41,8,44,8],[37,15,40,15],[37,17,40,17],[33,0,36,0],[33,1,36,1],[33,2,36,2],[33,3,36,3],[33,4,36,4],[33,5,36,5],[37,0,40,0],[37,1,40,1],[37,2,40,2],[37,3,40,3],[37,4,40,4],[37,5,40,5],[33,6,36,6],[33,7,36,7],[33,8,36,8],[41,15,44,15],[29,17,32,17],[33,15,36,15],[33,17,36,17],[29,0,32,0],[29,1,32,1],[29,2,32,2],[29,3,32,3],[29,4,32,4],[29,5,32,5],[21,8,24,8],[25,6,28,6],[25,7,28,7],[25,8,28,8],[29,6,32,6],[29,7,32,7],[29,8,32,8],[29,15,32,15],[25,15,28,15],[21,5,24,5],[25,0,28,0],[25,1,28,1],[25,2,28,2],[25,3,28,3],[25,4,28,4],[25,5,28,5],[21,6,24,6],[21,7,24,7],[25,17,28,17],[10,3,11,3],[10,4,12,4],[10,5,12,5],[17,0,20,0],[17,1,20,1],[17,2,20,2],[17,3,20,3],[17,4,20,4],[17,5,20,5],[21,15,24,15],[21,17,24,17],[13,7,16,7],[13,8,16,8],[13,15,16,15],[17,6,20,6],[17,7,20,7],[17,8,20,8],[17,15,20,15],[21,0,24,0],[21,1,24,1],[21,2,24,2],[21,3,24,3],[21,4,24,4],[3,2,3,3],[4,2,4,3],[5,10,5,11],[9,0,9,14],[9,15,9,23],[7,16,7,17],[11,9,12,14],[11,18,12,23],[13,0,16,0],[13,1,16,1],[13,2,16,2],[13,3,16,3],[13,4,16,4],[13,5,16,5],[13,6,16,6],[10,6,12,6],[10,7,12,7],[10,8,11,8],[10,9,10,14],[10,15,12,15],[10,17,11,17],[10,0,12,0],[10,1,12,1],[10,2,12,2]]}
["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:"]
["Partner Field Inspector Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QC Field Inspector Name:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Firm Gas Conversion:",null,null,"Complete",null,"Incomplete",null,"N/A"]
[]
["Partner 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 Partner 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(D14=0,\"\",D14/$D$114)","v":""},{"$f":"IF(D14=0,\"\",F14*D14)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope - 50%'!P14","v":0},null,{"$f":"Q14*D14","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner 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(D18=0,\"\",D18/$D$114)","v":""},{"$f":"IF(D18=0,\"\",F18*D18)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope - 50%'!P18","v":0},null,{"$f":"Q18*D18","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner 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(D22=0,\"\",D22/$D$114)","v":""},{"$f":"IF(D22=0,\"\",F22*D22)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope - 50%'!P22","v":0},null,{"$f":"Q22*D22","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner 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(D26=0,\"\",D26/$D$114)","v":""},{"$f":"IF(D26=0,\"\",F26*D26)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope - 50%'!P26","v":0},null,{"$f":"Q26*D26","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner 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(D30=0,\"\",D30/$D$114)","v":""},{"$f":"IF(D30=0,\"\",F30*D30)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope - 50%'!P30","v":0},null,{"$f":"Q30*D30","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner 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(D34=0,\"\",D34/$D$114)","v":""},{"$f":"IF(D34=0,\"\",F34*D34)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope - 50%'!P34","v":0},null,{"$f":"Q34*D34","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner 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(D38=0,\"\",D38/$D$114)","v":""},{"$f":"IF(D38=0,\"\",F38*D38)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope - 50%'!P38","v":0},null,{"$f":"Q38*D38","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner 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(D42=0,\"\",D42/$D$114)","v":""},{"$f":"IF(D42=0,\"\",F42*D42)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope - 50%'!P42","v":0},null,{"$f":"Q42*D42","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner 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(D46=0,\"\",D46/$D$114)","v":""},{"$f":"IF(D46=0,\"\",F46*D46)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope - 50%'!P46","v":0},null,{"$f":"Q46*D46","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner 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(D50=0,\"\",D50/$D$114)","v":""},{"$f":"IF(D50=0,\"\",F50*D50)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope - 50%'!P50","v":0},null,{"$f":"Q50*D50","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner 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(D54=0,\"\",D54/$D$114)","v":""},{"$f":"IF(D54=0,\"\",F54*D54)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope - 50%'!P54","v":0},null,{"$f":"Q54*D54","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner 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(D58=0,\"\",D58/$D$114)","v":""},{"$f":"IF(D58=0,\"\",F58*D58)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope - 50%'!P58","v":0},null,{"$f":"Q58*D58","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner 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(D62=0,\"\",D62/$D$114)","v":""},{"$f":"IF(D62=0,\"\",F62*D62)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope - 50%'!P62","v":0},null,{"$f":"Q62*D62","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner 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(D66=0,\"\",D66/$D$114)","v":""},{"$f":"IF(D66=0,\"\",F66*D66)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope - 50%'!P66","v":0},null,{"$f":"Q66*D66","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner 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(D70=0,\"\",D70/$D$114)","v":""},{"$f":"IF(D70=0,\"\",F70*D70)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope - 50%'!P70","v":0},null,{"$f":"Q70*D70","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner 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(D74=0,\"\",D74/$D$114)","v":""},{"$f":"IF(D74=0,\"\",F74*D74)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope - 50%'!P74","v":0},null,{"$f":"Q74*D74","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner 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(D78=0,\"\",D78/$D$114)","v":""},{"$f":"IF(D78=0,\"\",F78*D78)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope - 50%'!P78","v":0},null,{"$f":"Q78*D78","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner 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(D82=0,\"\",D82/$D$114)","v":""},{"$f":"IF(D82=0,\"\",F82*D82)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope - 50%'!P82","v":0},null,{"$f":"Q82*D82","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner 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(D86=0,\"\",D86/$D$114)","v":""},{"$f":"IF(D86=0,\"\",F86*D86)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope - 50%'!P86","v":0},null,{"$f":"Q86*D86","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner 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(D90=0,\"\",D90/$D$114)","v":""},{"$f":"IF(D90=0,\"\",F90*D90)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope - 50%'!P90","v":0},null,{"$f":"Q90*D90","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner 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(D94=0,\"\",D94/$D$114)","v":""},{"$f":"IF(D94=0,\"\",F94*D94)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope - 50%'!P94","v":0},null,{"$f":"Q94*D94","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner 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(D98=0,\"\",D98/$D$114)","v":""},{"$f":"IF(D98=0,\"\",F98*D98)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope - 50%'!P98","v":0},null,{"$f":"Q98*D98","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner 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(D102=0,\"\",D102/$D$114)","v":""},{"$f":"IF(D102=0,\"\",F102*D102)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope - 50%'!P102","v":0},null,{"$f":"Q102*D102","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner 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(D106=0,\"\",D106/$D$114)","v":""},{"$f":"IF(D106=0,\"\",F106*D106)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope - 50%'!P106","v":0},null,{"$f":"Q106*D106","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner 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(D110=0,\"\",D110/$D$114)","v":""},{"$f":"IF(D110=0,\"\",F110*D110)","v":""},null,"Installation has not begun",null,null,null,null,{"$f":"'Project Workscope - 50%'!P110","v":0},null,{"$f":"Q110*D110","v":0},null,"Complete and Consistent with Description"]
[null,null,null,null,null,null,null,null,null,null,"Partially Complete, via:",null,"Partner 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,"Partner 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"]
["Partner Progress To Date:",null,null,{"$f":"SUM(D14:D113)","v":0},{"$f":"SUM(E14:E113)","v":0},{"$f":"SUMIF(G14:G113,\"<>Yes\",I14:I113)/SUMIF(G14:G113,\"<>Yes\",D14:D113)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(H14:H113)","v":0},{"$f":"SUM(I14:I113)","v":0},"Actual Progress To Date:",null,null,null,null,null,{"$f":"'Project Workscope - 50%'!P114","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(G14:G113,\"<>Yes\",R14:R113)/SUMIF(G14:G113,\"<>Yes\",D14:D113)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(R14:R113)","v":0}]

{"sheet":"Lighting Schedule","index":14,"n_rows":135,"n_cols":26,"rows_kept":135,"cut":false,"hidden":false,"merged":[[8,16,8,20],[8,21,8,25],[2,1,6,20],[8,1,8,3],[8,4,8,8],[8,9,8,14]]}
[null,"Lighting Schedule"]
[null,"Instructions"]
[null,"1) This tab will be populated automatically if using the \"Import from V5.1 ERP\" or \"Import from V5.2 ERP\" button. Only the parts of the lighting schedule that result in energy savings will be reflected here. After import, please review for accuracy.\n2) If not using the import function, fill this table in manually based on the approved ERP.\n3) A sample of the installed lighting must be verified through inspections and/or Statements of Substantial Completion. Information on the light fixtures installed should be recorded in the blue cells under the \"Partner Verified\" section in the table below. It is not necessary to inspect every single light fixture, but the information included must be accurate and should be based on actual installed conditions confirmed by the Partner. It is not appropriate to copy and paste the proposed fixture information to installed fixtures cells."]
[]
[]
[]
[]
[]
[null,"Location",null,null,"Existing Fixture",null,null,null,null,"Proposed Fixture",null,null,null,null,null,"Impact","Partner Verified",null,null,null,null,"Program Verified"]
[null,"Building Type","Building Area","Location","Qty","Fixture Description","Watts/\nFixture","Default Hours/ Day","Actual Hours/ Day","Qty","LED?","Fixture Description","Watts/\nFixture","Add Controls","% Hours Reduced","Annual kWh Savings","Inspected At\n50% or 100%","Qty","Fixture Description","Watts/\nFixture","Controls","Inspected At\n50% or 100%","Qty","Fixture Description","Watts/\nFixture","Controls"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]
["*\n*"]

{"sheet":"Air Sealing","index":15,"n_rows":92,"n_cols":7,"rows_kept":92,"cut":false,"hidden":true,"merged":[[97,3,97,4],[71,0,75,6],[101,3,101,4],[2,5,2,6],[3,5,3,6],[2,1,2,4],[3,1,3,4],[98,3,98,4],[5,0,5,6],[85,1,85,6],[33,0,33,6],[34,4,34,6],[34,2,34,3],[40,2,43,2],[40,5,43,5],[44,0,44,6],[96,3,96,4],[40,3,43,3],[77,0,81,6],[50,0,50,6],[56,0,56,6],[62,0,62,6],[95,3,95,4],[40,4,43,4],[40,0,43,0],[89,1,89,6],[90,1,90,6],[91,1,91,6],[113,3,113,4],[107,3,107,4],[108,3,108,4],[109,3,109,4],[110,3,110,4],[111,3,111,4],[112,3,112,4],[105,3,105,4],[106,3,106,4],[84,1,84,6],[34,0,34,1],[19,0,23,6],[103,3,103,4],[99,3,99,4],[100,3,100,4],[76,0,76,6],[83,0,83,6],[88,0,88,6],[86,1,86,6],[40,6,43,6],[41,1,43,1],[102,3,102,4],[104,3,104,4],[10,3,10,5],[6,0,6,6],[7,0,7,6],[32,0,32,6],[70,0,70,6],[37,0,37,6],[39,0,39,6],[24,0,24,6],[18,0,18,6],[25,0,29,6],[11,0,11,6],[12,0,12,6],[14,0,14,6],[16,0,16,6],[15,0,15,6],[13,0,13,6]]}
["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."]
["Fast Track Projects (required): Fast Track Projects up to and including 3 stories shall provide blower door test results for pre-installation and post-installation conditions in all buildings. "]
[]
["Measure Description"]
["Measure Description from ERP",null,null,"Description matches ERP (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved Energy Reduction Plan 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."]
[]
[]
[]
[]
[]
["Partner 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 ERP, 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. "]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Partner 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)"]
[]
[]
[" Partner Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
[" Partner Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 50% Inspection"]
[]
[]
[]
[]
[]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 50% Inspection"]
[1]
[2]
[3]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Appliances","index":16,"n_rows":91,"n_cols":9,"rows_kept":91,"cut":false,"hidden":true,"merged":[[24,0,28,8],[38,0,38,8],[31,0,31,8],[18,0,22,8],[23,0,23,8],[75,0,75,8],[76,0,80,8],[70,0,74,8],[69,0,69,8],[2,7,2,8],[3,7,3,8],[49,0,49,8],[43,0,43,8],[36,0,36,8],[32,0,32,8],[33,4,33,8],[2,1,2,6],[3,1,3,6],[5,0,5,8],[6,0,6,8],[9,3,9,7],[87,0,87,8],[83,1,83,8],[84,1,84,8],[85,1,85,8],[82,0,82,8],[90,1,90,8],[33,2,33,3],[39,0,42,0],[40,1,42,1],[39,2,42,2],[39,7,42,7],[39,4,42,4],[39,3,42,3],[39,6,42,6],[39,8,42,8],[39,5,42,5],[61,0,61,8],[55,0,55,8],[33,0,33,1],[88,1,88,8],[89,1,89,8],[14,0,14,8],[15,0,15,8],[17,0,17,8],[10,0,10,8],[11,0,11,8],[12,0,12,8],[13,0,13,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 ERP",null,null,"Description matches ERP (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved Energy Reduction Plan 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."]
[]
[]
[]
[]
[]
["Partner 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). "]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Partner Inspection)"]
["Bldg. #","Location ","Equipment Type","Manufacturer","Model #","New?","Energy Star Labeled","kWh/yr.","Quantity"]
[null," (Apt #, Room, Floor, Space)"]
[]
[]
[" Partner Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
[" Partner Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 50% Inspection"]
[]
[]
[]
[]
[]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 50% Inspection"]
[1]
[2]
[3]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Cooling","index":17,"n_rows":95,"n_cols":10,"rows_kept":95,"cut":false,"hidden":true,"merged":[[2,1,2,7],[3,1,3,7],[43,7,46,7],[40,0,40,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],[94,1,94,9],[47,0,47,9],[53,0,53,9],[59,0,59,9],[65,0,65,9],[87,1,87,9],[88,1,88,9],[89,1,89,9],[91,0,91,9],[92,1,92,9],[73,0,73,9],[74,0,78,9],[79,0,79,9],[93,1,93,9],[80,0,84,9],[86,0,86,9],[7,2,7,9],[26,0,30,9],[8,0,8,1],[8,2,8,9],[19,0,19,9],[20,0,24,9],[25,0,25,9],[7,0,7,1],[33,0,33,9],[43,3,46,3],[42,0,42,9],[43,9,46,9],[43,2,46,2],[43,5,46,5],[43,8,46,8],[43,0,46,0],[34,0,34,9],[35,0,35,1],[35,2,35,3],[43,6,46,6],[44,1,46,1],[35,4,35,9],[38,0,38,9],[43,4,46,4]]}
["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."]
["Packaged Terminal Air Conditioners",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. "]
["Cooling - Chillers",null,"Equipment shall meet the requirements of ECCC NYS."]
[]
["Measure Description"]
["Measure Description from ERP",null,null,null,"Description matches ERP (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved Energy Reduction Plan 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."]
[]
[]
[]
[]
[]
["Partner 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. "]
[]
["Operation Manuals & training provided to building operators?"]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Partner Inspection)"]
["Bldg. #","Location ","Equpiment Type","Spaces Served","Manufacturer","Model #","Output Capacity (Btu/h)","Rated Efficiency","Rated Efficiency Units","Controls"]
[null," (Apt #, Room, Floor, Space)"]
[]
[]
[" Partner Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
[" Partner Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 50% Inspection"]
[]
[]
[]
[]
[]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 50% Inspection"]
[1]
[2]
[3]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"DHW","index":18,"n_rows":93,"n_cols":11,"rows_kept":93,"cut":false,"hidden":true,"merged":[[87,1,87,10],[89,0,89,10],[90,1,90,10],[57,0,57,10],[63,0,63,10],[71,0,71,10],[91,1,91,10],[92,1,92,10],[6,0,6,10],[7,0,7,10],[8,0,8,10],[41,9,42,10],[43,9,44,9],[72,0,76,10],[77,0,77,10],[78,0,82,10],[84,0,84,10],[85,1,85,10],[86,1,86,10],[42,1,44,1],[45,0,45,10],[51,0,51,10],[40,0,40,10],[41,0,44,0],[41,2,44,2],[41,3,44,3],[41,4,44,4],[41,5,44,5],[41,7,44,7],[41,8,44,8],[41,6,44,6],[43,10,44,10],[17,0,17,10],[19,0,19,10],[20,0,24,10],[25,0,25,10],[38,0,38,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],[12,0,12,10],[13,0,13,10],[14,0,14,10],[15,0,15,10],[16,0,16,10],[11,4,11,9],[5,0,5,10],[2,9,2,10],[2,1,2,8],[3,1,3,8],[3,9,3,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-10 503.2.8."]
["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-10 504.2. "]
["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 120°F - 125°F."]
[]
["Measure Description"]
["Measure Description from ERP",null,null,null,"Description matches ERP (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved Energy Reduction Plan 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."]
[]
[]
[]
[]
[]
["Partner 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. "]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Partner 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"]
[]
[" Partner Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
[" Partner Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 50% Inspection"]
[]
[]
[]
[]
[]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 50% Inspection"]
[1]
[2]
[3]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Duct Improvements","index":19,"n_rows":88,"n_cols":12,"rows_kept":88,"cut":false,"hidden":true,"merged":[[46,0,46,11],[52,0,52,11],[87,1,87,11],[37,2,39,2],[37,3,39,3],[80,1,80,11],[81,1,81,11],[82,1,82,11],[84,0,84,11],[85,1,85,11],[86,1,86,11],[58,0,58,11],[66,0,66,11],[67,0,71,11],[72,0,72,11],[73,0,77,11],[79,0,79,11],[40,0,40,11],[33,0,33,11],[35,0,35,11],[36,0,39,0],[36,11,39,11],[37,4,39,4],[37,5,39,5],[37,6,39,6],[37,7,39,7],[36,4,36,7],[36,8,36,10],[37,8,39,8],[37,9,39,9],[37,1,39,1],[36,2,36,3],[15,0,19,11],[20,0,20,11],[37,10,39,10],[21,0,25,11],[28,0,28,11],[29,0,29,11],[30,0,30,1],[30,2,30,3],[30,4,30,11],[2,1,2,9],[2,10,2,11],[3,1,3,9],[3,10,3,11],[14,0,14,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]]}
["Duct Improvements"]
[]
["Measure #","Measure Name",null,null,null,null,null,null,null,null,"Reported % Complete"]
[]
[]
["Measure Description"]
["Measure Description from ERP",null,null,null,"Description matches ERP (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved Energy Reduction Plan 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."]
[]
[]
[]
[]
[]
["Partner 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. "]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Partner 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)"]
[]
[]
[" Partner Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
[" Partner Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 50% Inspection"]
[]
[]
[]
[]
[]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 50% Inspection"]
[1]
[2]
[3]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Elevators","index":20,"n_rows":91,"n_cols":9,"rows_kept":91,"cut":false,"hidden":true,"merged":[[43,0,43,8],[49,0,49,8],[55,0,55,8],[61,0,61,8],[69,0,69,8],[90,1,90,8],[70,0,74,8],[75,0,75,8],[76,0,80,8],[82,0,82,8],[83,1,83,8],[84,1,84,8],[85,1,85,8],[87,0,87,8],[88,1,88,8],[89,1,89,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],[31,0,31,8],[32,0,32,8],[33,0,33,1],[33,2,33,3],[33,4,33,8],[15,0,15,8],[17,0,17,8],[18,0,22,8],[23,0,23,8],[24,0,28,8],[10,0,10,8],[11,0,11,8],[12,0,12,8],[13,0,13,8],[14,0,14,8],[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]]}
["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 ERP",null,null,"Description matches ERP (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved Energy Reduction Plan 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."]
[]
[]
[]
[]
[]
["Partner 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. "]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Partner 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 #"]
[]
[" Partner Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
[" Partner Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 50% Inspection"]
[]
[]
[]
[]
[]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 50% Inspection"]
[1]
[2]
[3]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"EMS & Temp Controls","index":21,"n_rows":95,"n_cols":11,"rows_kept":95,"cut":false,"hidden":true,"merged":[[94,1,94,10],[87,1,87,10],[88,1,88,10],[89,1,89,10],[91,0,91,10],[92,1,92,10],[93,1,93,10],[86,0,86,10],[44,1,46,1],[47,0,47,10],[53,0,53,10],[59,0,59,10],[65,0,65,10],[73,0,73,10],[74,0,78,10],[79,0,79,10],[80,0,84,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],[43,0,46,0],[43,2,46,2],[43,3,46,3],[43,4,46,4],[43,9,46,9],[35,0,35,1],[35,2,35,3],[35,4,35,10],[38,0,38,10],[42,0,42,10],[20,0,24,10],[25,0,25,10],[26,0,30,10],[33,0,33,10],[34,0,34,10],[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],[5,0,5,10],[6,0,6,10],[2,9,2,10],[3,9,3,10],[2,1,2,8],[3,1,3,8]]}
["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-10 503.2.8."]
["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-10 504.2. "]
["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 120°F - 125°F."]
[]
["Measure Description"]
["Measure Description from ERP",null,null,null,"Description matches ERP (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved Energy Reduction Plan 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."]
[]
[]
[]
[]
[]
["Partner 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.  "]
[]
["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 Partner 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)"]
[]
[" Partner Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
[" Partner Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 50% Inspection"]
[]
[]
[]
[]
[]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 50% Inspection"]
[1]
[2]
[3]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Envelope Insulation","index":22,"n_rows":88,"n_cols":12,"rows_kept":88,"cut":false,"hidden":true,"merged":[[82,1,82,11],[84,0,84,11],[85,1,85,11],[86,1,86,11],[38,6,39,6],[38,7,39,7],[38,8,39,8],[38,9,39,9],[38,5,39,5],[87,1,87,11],[36,2,39,2],[36,3,39,3],[36,8,37,9],[36,10,39,10],[67,0,71,11],[72,0,72,11],[73,0,77,11],[79,0,79,11],[80,1,80,11],[81,1,81,11],[40,0,40,11],[46,0,46,11],[52,0,52,11],[58,0,58,11],[66,0,66,11],[33,0,33,11],[35,0,35,11],[36,0,39,0],[36,11,39,11],[37,1,39,1],[36,4,39,4],[36,5,37,7],[28,0,28,11],[29,0,29,11],[30,0,30,1],[30,2,30,3],[30,4,30,11],[12,0,12,11],[14,0,14,11],[15,0,19,11],[20,0,20,11],[21,0,25,11],[7,0,7,11],[8,0,8,11],[9,0,9,11],[10,0,10,11],[11,0,11,11],[2,1,2,9],[2,10,2,11],[3,1,3,9],[3,10,3,11],[6,4,6,10]]}
["Envelope Insulation"]
[]
["Measure #","Measure Name",null,null,null,null,null,null,null,null,"Reported % Complete"]
[]
[]
["Measure Description"]
["Measure Description from ERP",null,null,null,"Description matches ERP (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved Energy Reduction Plan 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."]
[]
[]
[]
[]
[]
["Partner 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.  "]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Partner 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"]
[]
[" Partner Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
[" Partner Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 50% Inspection"]
[]
[]
[]
[]
[]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 50% Inspection"]
[1]
[2]
[3]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Exterior Doors","index":23,"n_rows":91,"n_cols":10,"rows_kept":91,"cut":false,"hidden":true,"merged":[[90,1,90,9],[39,6,42,6],[39,7,42,7],[39,5,42,5],[83,1,83,9],[84,1,84,9],[85,1,85,9],[87,0,87,9],[88,1,88,9],[89,1,89,9],[61,0,61,9],[69,0,69,9],[70,0,74,9],[75,0,75,9],[76,0,80,9],[82,0,82,9],[55,0,55,9],[36,0,36,9],[38,0,38,9],[39,0,42,0],[39,2,42,2],[39,3,42,3],[39,4,42,4],[39,8,42,8],[39,9,42,9],[40,1,42,1],[33,0,33,1],[33,2,33,3],[33,4,33,9],[43,0,43,9],[49,0,49,9],[18,0,22,9],[23,0,23,9],[24,0,28,9],[31,0,31,9],[32,0,32,9],[17,0,17,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],[6,0,6,9],[2,1,2,7],[2,8,2,9],[3,1,3,7],[3,8,3,9],[5,0,5,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-10 502.3. "]
[]
["Measure Description"]
["Measure Description from ERP",null,null,null,"Description matches ERP (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved Energy Reduction Plan 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."]
[]
[]
[]
[]
[]
["Partner 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. "]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Partner 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)"]
[]
[]
[" Partner Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
[" Partner Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 50% Inspection"]
[]
[]
[]
[]
[]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 50% Inspection"]
[1]
[2]
[3]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Heat & Energy Rec.","index":24,"n_rows":88,"n_cols":13,"rows_kept":88,"cut":false,"hidden":true,"merged":[[36,9,36,10],[82,1,82,12],[84,0,84,12],[85,1,85,12],[86,1,86,12],[87,1,87,12],[80,1,80,12],[81,1,81,12],[40,0,40,12],[46,0,46,12],[52,0,52,12],[58,0,58,12],[66,0,66,12],[67,0,71,12],[72,0,72,12],[73,0,77,12],[79,0,79,12],[33,0,33,12],[35,0,35,12],[36,0,39,0],[36,12,39,12],[37,1,39,1],[36,2,39,2],[37,6,39,6],[37,7,39,7],[37,8,39,8],[37,9,39,9],[37,10,39,10],[36,3,39,3],[36,4,39,4],[36,5,39,5],[36,11,39,11],[36,6,36,8],[28,0,28,12],[29,0,29,12],[30,0,30,1],[30,2,30,3],[30,4,30,12],[12,0,12,12],[14,0,14,12],[15,0,19,12],[20,0,20,12],[21,0,25,12],[7,0,7,12],[8,0,8,12],[9,0,9,12],[10,0,10,12],[11,0,11,12],[2,1,2,10],[2,11,2,12],[3,1,3,10],[3,11,3,12],[6,4,6,11]]}
["Heat and Energy Recovery"]
[]
["Measure #","Measure Name",null,null,null,null,null,null,null,null,null,"Reported % Complete"]
[]
[]
["Measure Description"]
["Measure Description from ERP",null,null,null,"Description matches ERP (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved Energy Reduction Plan 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."]
[]
[]
[]
[]
[]
["Partner 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."]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Partner 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"]
[" Partner Documentation - 50% Inspection"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G42=0,\"\",(H42-G42)/(J42-G42))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G43=0,\"\",(H43-G43)/(J43-G43))","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,""]
[" Partner 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 Documentation - 50% 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 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 - 50% Inspection"]
[]
[]
[]
[]
[]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 50% Inspection"]
[1]
[2]
[3]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Heating","index":25,"n_rows":106,"n_cols":16,"rows_kept":106,"cut":false,"hidden":true,"merged":[[54,9,55,10],[56,9,57,9],[56,10,57,10],[45,0,45,15],[53,0,53,15],[54,0,57,0],[54,2,57,2],[54,3,57,3],[54,4,57,4],[54,5,57,5],[54,7,57,7],[47,0,47,4],[48,0,48,4],[49,0,49,4],[50,0,50,4],[51,0,51,4],[12,2,12,15],[13,0,13,1],[13,2,13,15],[15,0,15,1],[15,2,15,15],[56,14,57,14],[56,15,57,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],[55,1,57,1],[56,11,57,11],[56,12,57,12],[56,13,57,13],[11,2,11,15],[12,0,12,1],[102,0,102,15],[103,1,103,15],[104,1,104,15],[105,1,105,15],[54,6,57,6],[54,8,57,8],[54,11,55,12],[54,13,55,14],[54,15,55,15],[90,0,90,15],[91,0,95,15],[97,0,97,15],[98,1,98,15],[99,1,99,15],[100,1,100,15],[58,0,58,15],[64,0,64,15],[70,0,70,15],[76,0,76,15],[84,0,84,15],[85,0,89,15],[42,2,42,3],[42,4,42,15],[26,0,26,15],[27,0,31,15],[32,0,32,15],[33,0,37,15],[40,0,40,15],[41,0,41,15],[42,0,42,1],[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]]}
["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,"All hot water piping in mechanical room and accessible piping in unconditioned spaces shall be insulated to ECCC NYS-10 503.2.8."]
["Heating System Efficiency",null,"Replacement heating plant(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-10 503.2.3. "]
["Start-up Testing",null,"Provide System Functional Performance Testing checklist verification and start-up reports/checklists in typical replacement HVAC systems & equipment. Replacement condensing boilers shall provide at a minimum in the Start-up report 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",null,"Condensing boilers shall be designed, installed and operated in a manner to minmize return water temperature."]
["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 systems, provide motorized damper control of outside air damper."]
["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 503.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 ERP",null,null,null,"Description matches ERP (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved Energy Reduction Plan 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."]
[]
[]
[]
[]
[]
["Partner 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."]
[]
["Outdoor reset curve submitted?"]
["Did you include Contractor Start-up Report in your submittal?"]
["Did you include Testing & Balancing Report 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 Partner 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"]
[]
[" Partner Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
[" Partner Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 50% Inspection"]
[]
[]
[]
[]
[]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 50% Inspection"]
[1]
[2]
[3]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Heating Dist. Imp.","index":26,"n_rows":92,"n_cols":6,"rows_kept":92,"cut":false,"hidden":true,"merged":[[2,1,2,4],[3,1,3,4],[37,0,37,2],[88,0,88,5],[89,1,89,5],[44,0,44,5],[50,0,50,5],[56,0,56,5],[62,0,62,5],[70,0,70,5],[71,0,75,5],[40,0,43,0],[40,2,43,2],[40,3,43,3],[40,4,43,4],[40,5,43,5],[90,1,90,5],[91,1,91,5],[76,0,76,5],[77,0,81,5],[83,0,83,5],[84,1,84,5],[85,1,85,5],[86,1,86,5],[41,1,43,1],[32,0,32,5],[33,0,33,1],[33,2,33,3],[33,4,33,5],[36,0,36,5],[39,0,39,5],[31,0,31,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],[23,0,23,5],[24,0,28,5],[5,0,5,5],[6,0,6,5],[9,3,9,4],[10,0,10,5],[11,0,11,5]]}
["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 503.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 ERP",null,null,"Description matches ERP (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved Energy Reduction Plan 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."]
[]
[]
[]
[]
[]
["Partner 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 equpiment that was installed."]
["Did you include a work schedule in your submittal?"]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Partner Inspection)"]
["Bldg. #","Location ","Type of Equipment","Condition","Settings / Specifications","Notes"]
[null," (Apt #, Room, Floor, Space)"]
[]
[]
[" Partner Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
["Partner Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 50% Inspection"]
[]
[]
[]
[]
[]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 50% Inspection"]
[1]
[2]
[3]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Lighting - Apt.","index":27,"n_rows":67,"n_cols":6,"rows_kept":67,"cut":false,"hidden":true,"merged":[[42,0,42,5],[63,0,63,5],[64,1,64,5],[65,1,65,5],[66,1,66,5],[51,0,51,5],[52,0,56,5],[58,0,58,5],[59,1,59,5],[60,1,60,5],[61,1,61,5],[45,0,45,5],[46,0,50,5],[40,0,40,2],[27,0,31,5],[34,0,34,5],[35,0,35,5],[36,0,36,1],[36,2,36,3],[36,4,36,5],[18,0,18,5],[20,0,20,5],[21,0,25,5],[26,0,26,5],[39,0,39,5],[13,0,13,5],[14,0,14,5],[15,0,15,5],[16,0,16,5],[17,0,17,5],[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]]}
["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 flourescent 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 ERP",null,null,"Description matches ERP (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved Energy Reduction Plan 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."]
[]
[]
[]
[]
[]
["Partner 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). "]
["Did you include an apartment distribution list in your submittal?"]
[]
["Documenation of the installed fixtures should be recorded on the Lighting Schedule worksheet by the Partner and Program Inspectors. The Lighting Schedule worksheet must be completed regardless of the type of documentation used (Statement of Substantial Completion or Partner Inspection). However, if a Statement of Substantial Completion and/or if additonal documentation on the fixutres installed is included with this submittal, then the percentage of fixtures inspected can be reduced."]
[]
["Program Use"]
[" Inspection Findings - 50% Inspection"]
[]
[]
[]
[]
[]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 50% Inspection"]
[1]
[2]
[3]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Lighting - CA","index":28,"n_rows":69,"n_cols":6,"rows_kept":69,"cut":false,"hidden":true,"merged":[[67,1,67,5],[68,1,68,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],[53,0,53,5],[54,0,58,5],[60,0,60,5],[61,1,61,5],[62,1,62,5],[63,1,63,5],[47,0,47,5],[65,0,65,5],[24,0,28,5],[29,0,29,5],[21,0,21,5],[23,0,23,5],[66,1,66,5],[48,0,52,5],[42,0,42,5],[44,0,44,5],[30,0,34,5],[37,0,37,5],[38,0,38,5],[39,0,39,1],[39,2,39,3],[39,4,39,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],[16,0,16,5],[17,0,17,5],[18,0,18,5],[19,0,19,5],[20,0,20,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 flourescent 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 505.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 ERP",null,null,"Description matches ERP (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved Energy Reduction Plan 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."]
[]
[]
[]
[]
[]
["Partner 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). "]
[]
["Documenation of the installed fixtures should be recorded on the Lighting Schedule worksheet by the Partner and Program Inspectors. The Lighting Schedule worksheet must be completed regardless of the type of documentation used (Statement of Substantial Completion or Partner Inspection). However, if a Statement of Substantial Completion and/or if additonal documentation on the fixutres installed is included with this submittal, then the percentage of fixtures inspected can be reduced."]
[]
["Program Use"]
[" Inspection Findings - 50% Inspection"]
[]
[]
[]
[]
[]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 50% Inspection"]
[1]
[2]
[3]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Low-Flow Devices","index":29,"n_rows":94,"n_cols":11,"rows_kept":94,"cut":false,"hidden":true,"merged":[[48,0,48,1],[55,0,55,1],[62,0,62,1],[69,0,69,1],[91,1,91,10],[73,0,77,10],[78,0,78,10],[92,1,92,10],[93,1,93,10],[5,0,5,10],[6,0,6,10],[39,2,40,4],[39,5,40,7],[79,0,83,10],[85,0,85,10],[86,1,86,10],[87,1,87,10],[88,1,88,10],[90,0,90,10],[49,0,49,10],[56,0,56,10],[63,0,63,10],[72,0,72,10],[42,0,42,10],[39,8,40,10],[36,0,36,10],[38,0,38,10],[39,0,41,0],[40,1,41,1],[31,0,31,10],[32,0,32,10],[33,0,33,1],[33,2,33,3],[33,4,33,10],[15,0,15,10],[17,0,17,10],[18,0,22,10],[23,0,23,10],[24,0,28,10],[10,0,10,10],[11,0,11,10],[12,0,12,10],[13,0,13,10],[14,0,14,10],[2,1,2,8],[2,9,2,10],[3,1,3,8],[3,9,3,10],[9,4,9,9]]}
["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 ERP",null,null,null,"Description matches ERP (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved Energy Reduction Plan 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."]
[]
[]
[]
[]
[]
["Partner 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. "]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Partner 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?"]
[" Partner Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
["Average",null,{"$f":"AVERAGE(C44:C48)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D44:D48)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(F44:F48)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G44:G48)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(I44:I48)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(J44:J48)","v":{"$error":"#DIV/0!"}}]
[" Partner Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
["Average",null,{"$f":"AVERAGE(C51:C55)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D51:D55)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(F51:F55)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G51:G55)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(I51:I55)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(J51:J55)","v":{"$error":"#DIV/0!"}}]
[" Program Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
["Average",null,{"$f":"AVERAGE(C58:C62)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D58:D62)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(F58:F62)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G58:G62)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(I58:I62)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(J58:J62)","v":{"$error":"#DIV/0!"}}]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
["Average",null,{"$f":"AVERAGE(C65:C69)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D65:D69)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(F65:F69)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G65:G69)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(I65:I69)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(J65:J69)","v":{"$error":"#DIV/0!"}}]
[]
["Program Use"]
[" Inspection Findings - 50% Inspection"]
[]
[]
[]
[]
[]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 50% Inspection"]
[1]
[2]
[3]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Other","index":30,"n_rows":88,"n_cols":12,"rows_kept":88,"cut":false,"hidden":true,"merged":[[87,1,87,11],[72,0,72,11],[73,0,77,11],[79,0,79,11],[80,1,80,11],[81,1,81,11],[82,1,82,11],[58,0,58,11],[66,0,66,11],[84,0,84,11],[85,1,85,11],[86,1,86,11],[67,0,71,11],[36,5,39,5],[36,6,39,6],[40,0,40,11],[46,0,46,11],[52,0,52,11],[37,1,39,1],[36,0,39,0],[36,2,39,2],[36,3,39,3],[36,4,39,4],[36,7,39,7],[36,8,39,8],[36,9,39,9],[36,10,39,10],[36,11,39,11],[35,0,35,11],[12,0,12,11],[14,0,14,11],[15,0,19,11],[20,0,20,11],[21,0,25,11],[28,0,28,11],[29,0,29,11],[30,0,30,1],[30,2,30,3],[30,4,30,11],[33,0,33,11],[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]]}
["Other"]
[]
["Measure #","Measure Name",null,null,null,null,null,null,null,null,"Reported % Complete"]
[]
[]
["Measure Description"]
["Measure Description from ERP",null,null,null,"Description matches ERP (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved Energy Reduction Plan 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."]
[]
[]
[]
[]
[]
["Partner 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. "]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Partner 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)"]
[]
[]
[" Partner Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
[" Partner Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 50% Inspection"]
[]
[]
[]
[]
[]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 50% Inspection"]
[1]
[2]
[3]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Motors","index":31,"n_rows":91,"n_cols":12,"rows_kept":91,"cut":false,"hidden":true,"merged":[[88,1,88,11],[89,1,89,11],[90,1,90,11],[5,0,5,11],[6,0,6,11],[39,4,42,4],[39,5,42,5],[39,7,42,7],[39,8,42,8],[39,9,42,9],[76,0,80,11],[82,0,82,11],[83,1,83,11],[84,1,84,11],[85,1,85,11],[87,0,87,11],[75,0,75,11],[43,0,43,11],[39,6,42,6],[36,0,36,11],[38,0,38,11],[39,0,42,0],[39,2,42,2],[39,3,42,3],[39,10,42,10],[39,11,42,11],[40,1,42,1],[49,0,49,11],[55,0,55,11],[61,0,61,11],[69,0,69,11],[70,0,74,11],[31,0,31,11],[32,0,32,11],[33,0,33,1],[33,2,33,3],[33,4,33,11],[15,0,15,11],[17,0,17,11],[18,0,22,11],[23,0,23,11],[24,0,28,11],[10,0,10,11],[11,0,11,11],[12,0,12,11],[13,0,13,11],[14,0,14,11],[2,1,2,9],[2,10,2,11],[3,1,3,9],[3,10,3,11],[9,4,9,10]]}
["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 ERP",null,null,null,"Description matches ERP (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved Energy Reduction Plan 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."]
[]
[]
[]
[]
[]
["Partner 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. "]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Partner 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)"]
[]
[]
[" Partner Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
[" Partner Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 50% Inspection"]
[]
[]
[]
[]
[]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 50% Inspection"]
[1]
[2]
[3]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Pipe Improvements","index":32,"n_rows":88,"n_cols":9,"rows_kept":88,"cut":false,"hidden":true,"merged":[[82,1,82,8],[84,0,84,8],[85,1,85,8],[86,1,86,8],[87,1,87,8],[81,1,81,8],[37,1,39,1],[40,0,40,8],[46,0,46,8],[52,0,52,8],[58,0,58,8],[66,0,66,8],[67,0,71,8],[72,0,72,8],[73,0,77,8],[79,0,79,8],[80,1,80,8],[37,2,39,2],[37,3,39,3],[37,4,39,4],[37,5,39,5],[35,0,35,8],[36,0,39,0],[21,0,25,8],[28,0,28,8],[29,0,29,8],[30,0,30,1],[30,2,30,3],[30,4,30,8],[36,2,36,4],[36,5,36,8],[37,6,39,6],[37,7,39,7],[37,8,39,8],[12,0,12,8],[14,0,14,8],[15,0,19,8],[20,0,20,8],[33,0,33,8],[7,0,7,8],[8,0,8,8],[9,0,9,8],[10,0,10,8],[11,0,11,8],[6,4,6,7],[2,1,2,6],[2,7,2,8],[3,1,3,6],[3,7,3,8]]}
["Pipe Improvements"]
[]
["Measure #","Measure Name",null,null,null,null,null,"Reported % Complete"]
[]
[]
["Measure Description"]
["Measure Description from ERP",null,null,null,"Description matches ERP (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved Energy Reduction Plan 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."]
[]
[]
[]
[]
[]
["Partner 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.   "]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Partner 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?"]
[]
[" Partner Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
[" Partner Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 50% Inspection"]
[]
[]
[]
[]
[]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 50% Inspection"]
[1]
[2]
[3]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Ventilation Imp.","index":33,"n_rows":90,"n_cols":13,"rows_kept":90,"cut":false,"hidden":true,"merged":[[86,0,86,12],[87,1,87,12],[88,1,88,12],[89,1,89,12],[38,6,41,6],[38,7,41,7],[38,8,41,8],[38,9,41,9],[38,10,41,10],[74,0,74,12],[75,0,79,12],[81,0,81,12],[82,1,82,12],[83,1,83,12],[84,1,84,12],[42,0,42,12],[48,0,48,12],[54,0,54,12],[60,0,60,12],[68,0,68,12],[69,0,73,12],[38,12,41,12],[39,1,41,1],[33,0,33,12],[37,0,37,12],[38,0,41,0],[38,2,41,2],[38,3,41,3],[38,4,41,4],[38,5,41,5],[38,11,41,11],[28,0,28,12],[29,0,29,12],[30,0,30,1],[30,2,30,3],[30,4,30,12],[12,0,12,12],[14,0,14,12],[15,0,19,12],[20,0,20,12],[21,0,25,12],[7,0,7,12],[8,0,8,12],[9,0,9,12],[10,0,10,12],[11,0,11,12],[2,1,2,10],[2,11,2,12],[3,1,3,10],[3,11,3,12],[6,4,6,11]]}
["Ventilation Improvements"]
[]
["Measure #","Measure Name",null,null,null,null,null,null,null,null,null,"Reported % Complete"]
[]
[]
["Measure Description"]
["Measure Description from ERP",null,null,null,"Description matches ERP (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved Energy Reduction Plan 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."]
[]
[]
[]
[]
[]
["Partner 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."]
["Did you include Contractor Start-up Report in your submittal?"]
["Did you include Testing & Balancing Report in your submittal?"]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Partner 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)"]
[]
[]
[" Partner Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
[" Partner Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 50% Inspection"]
[]
[]
[]
[]
[]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 50% Inspection"]
[1]
[2]
[3]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"VFD Upgrades","index":34,"n_rows":91,"n_cols":7,"rows_kept":91,"cut":false,"hidden":true,"merged":[[88,1,88,6],[89,1,89,6],[70,0,74,6],[90,1,90,6],[76,0,80,6],[82,0,82,6],[83,1,83,6],[84,1,84,6],[85,1,85,6],[75,0,75,6],[49,0,49,6],[55,0,55,6],[61,0,61,6],[69,0,69,6],[87,0,87,6],[39,0,42,0],[39,2,42,2],[39,3,42,3],[39,6,42,6],[43,0,43,6],[15,0,15,6],[17,0,17,6],[18,0,22,6],[23,0,23,6],[40,1,42,1],[41,4,42,4],[41,5,42,5],[24,0,28,6],[31,0,31,6],[32,0,32,6],[33,0,33,1],[33,2,33,3],[33,4,33,6],[39,4,40,5],[36,0,36,6],[38,0,38,6],[10,0,10,6],[11,0,11,6],[12,0,12,6],[13,0,13,6],[14,0,14,6],[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]]}
["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 ERP",null,null,"Description matches ERP (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved Energy Reduction Plan 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."]
[]
[]
[]
[]
[]
["Partner 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."]
[]
["This table must be completed regardless of the type of documentation used (Statement of Substantial Completion or Partner Inspection)"]
["Bldg. #","Location ","Motor Serving","Motor HP","VFD",null,"Operating Properly?"]
[null," (Apt #, Room, Floor, Space)"]
[null,null,null,null,"Manufacturer","Model #"]
[]
[" Partner Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
["Partner Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 50% Inspection"]
[]
[]
[]
[]
[]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 50% Inspection"]
[1]
[2]
[3]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Windows","index":35,"n_rows":93,"n_cols":14,"rows_kept":93,"cut":false,"hidden":true,"merged":[[89,0,89,13],[90,1,90,13],[91,1,91,13],[41,13,44,13],[42,1,44,1],[41,7,44,7],[41,8,44,8],[41,9,44,9],[41,10,44,10],[92,1,92,13],[5,0,5,13],[6,0,6,13],[38,0,38,3],[77,0,77,13],[78,0,82,13],[84,0,84,13],[85,1,85,13],[86,1,86,13],[87,1,87,13],[45,0,45,13],[51,0,51,13],[57,0,57,13],[63,0,63,13],[71,0,71,13],[72,0,76,13],[36,0,36,13],[40,0,40,13],[41,0,44,0],[41,2,44,2],[41,3,44,3],[41,4,44,4],[41,5,44,5],[41,12,44,12],[41,11,44,11],[41,6,44,6],[37,0,37,3],[31,0,31,13],[32,0,32,13],[33,0,33,1],[33,2,33,3],[33,4,33,13],[15,0,15,13],[17,0,17,13],[18,0,22,13],[23,0,23,13],[24,0,28,13],[10,0,10,13],[11,0,11,13],[12,0,12,13],[13,0,13,13],[14,0,14,13],[2,1,2,11],[2,12,2,13],[3,1,3,11],[3,12,3,13],[9,4,9,12]]}
["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-10 502.3."]
[]
["Measure Description"]
["Measure Description from ERP",null,null,null,"Description matches ERP (most recently approved scope)"]
["Existing Conditions:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Measure Description:"]
["Copy the description from the approved Energy Reduction Plan or most recently approved scope change."]
["Important Assumptions:"]
["Copy the description from the approved Energy Reduction Plan 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."]
[]
[]
[]
[]
[]
["Partner Inspection"]
["Inspection Requirement"]
["At least 10% of new windows (minimum of 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). The sample set shall include, at a minimum, the inspection of new windows in one representative apartment from each line. 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 window type inspected. "]
["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 Partner 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)"]
[]
[]
[" Partner Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
[" Partner Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 50% Inspection"]
[]
[]
[]
[]
[]
[" Program Documentation - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Program Use"]
[" Inspection Findings - 50% Inspection"]
[]
[]
[]
[]
[]
[" Inspection Findings - 100% Inspection"]
[]
[]
[]
[]
[]
[]
["Action Items 50% Inspection"]
[1]
[2]
[3]
[]
["Action Items 100% Inspection"]
[1]
[2]
[3]

{"sheet":"Inspection QC Report - 50%","index":36,"n_rows":70,"n_cols":54,"rows_kept":70,"cut":false,"hidden":false,"merged":[[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],[47,3,47,4],[47,5,47,15],[51,2,52,15],[56,2,56,4],[56,6,56,10],[56,13,56,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],[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],[14,3,14,6],[14,13,14,15],[5,18,6,25],[7,1,8,15],[10,1,11,10],[10,13,11,14],[10,15,11,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,"mvadney@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,"**Site Inspection QC Scores shall only be reported after the site inspection milestone has been completed and approved for payment by NYSERDA.**",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 Partner 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,"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,"Partner 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,true,null,"50% Complete",null,null,null,null,false,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 programatic 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('[2]Site Inspection Request'!C32=\"\",\"\",'[2]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 Partner:",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 partner properly prepared for the inspection? (Construction status was appropriate for inspection type, partner had already completed their own inspections, partner 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 partner 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 ws 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 Partner 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 Energy Reduction Plan 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":37,"n_rows":70,"n_cols":54,"rows_kept":70,"cut":false,"hidden":false,"merged":[[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],[47,3,47,4],[47,5,47,15],[51,2,52,15],[56,2,56,4],[56,6,56,10],[56,13,56,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],[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],[14,3,14,6],[14,13,14,15],[5,18,6,25],[7,1,8,15],[10,1,11,10],[10,13,11,14],[10,15,11,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,"mvadney@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,"**Site Inspection QC Scores shall only be reported after the site inspection milestone has been completed and approved for payment by NYSERDA.**",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 Partner 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,"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,"Partner 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 programatic 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('[2]Site Inspection Request'!C32=\"\",\"\",'[2]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 Partner:",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 partner properly prepared for the inspection? (Construction status was appropriate for inspection type, partner had already completed their own inspections, partner 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 partner 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 ws 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 Partner 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 Energy Reduction Plan 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*"]