{"text_format":"1","workbook":"xlsx","n_sheets":30,"sheets":["Development Tab","Development","Open","Instructions","Menu","Home Data","HVAC Data Collection","DHW Data Collection","Insulation Levels Data Collec","Air Sealing Data Collection","Duct Sealing Data Collection","Thermostats and Controls Data ","Lighting Data Collection","HEA_References","Appliances Data Collection","Window Data Collection","Health&Safety_Data","Other Data Collection","Cover","Executive Summary","Health&Safety","Heating and Cooling","DHW","Insulation Levels","Air_Sealing ","Duct Sealing","Thermostats and Controls","Lighting","Appliances","Windows"],"not_rendered":{"charts":1,"images":33,"macros":1,"external_links":1,"defined_names":310,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Development Tab","index":0,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":true,"merged":[[4,1,4,10],[7,1,7,10],[10,1,10,10]]}
["Program Year",2025]
["Version","1.0_Draft1"]
[]
[]
["Date","Edits",null,null,null,null,null,null,null,null,null,"Version","Initials"]
["10.21.20","Updated all Partner of the year images from 2019 to 2020",null,null,null,null,null,null,null,null,null,"Version1.0_Draft1","ED"]
["10.21.20","Results-Appliances Tab: Removed image of dishwashers and replaced with heat pump water heater",null,null,null,null,null,null,null,null,null,"Version1.0_Draft1","ED"]
["10.21.20","Results-Appliances Tab: Removed dishwasers from appliances paragraph and replaced with heat pump water heater",null,null,null,null,null,null,null,null,null,"Version1.0_Draft1","ED"]
["10.21.20","Results-Appliances Tab: Added \"ENERGY STAR Windows\" to appliances paragraph",null,null,null,null,null,null,null,null,null,"Version1.0_Draft1","ED"]
["10.21.20","HEA References Tab: Under Appliances table added Tankless Water Heater and Heat Pump Water Heater ",null,null,null,null,null,null,null,null,null,"Version1.0_Draft1","ED"]
["10.21.20","Hea References Tab: Updated \"HEA_Appl\" named manager to include new range that accounts for Tankless Water Heater and HPWH",null,null,null,null,null,null,null,null,null,"Version1.0_Draft1","ED"]
["10.21.20","Therms and Controls Tab: Updated website link for marketplace",null,null,null,null,null,null,null,null,null,"Version1.0_Draft1","ED"]

{"sheet":"Development","index":1,"n_rows":271,"n_cols":5,"rows_kept":271,"cut":false,"hidden":true,"merged":[]}
[]
[null,{"$f":"B6&\" Home Energy Assessment\"","v":"2025 Home Energy Assessment"}]
[null,"Home Energy Assessment"]
[null,"1.0","Current Version (Customer Inputs, Eligibility Table)"]
[null,"01.01.2025","Current Effective Date (Eligibility Table)"]
[null,2025,"Program Year"]
[]
[null,"Date","Description","Initials","Version"]
[null,"3.23.18","Updated version number and effective date","km","draft_1.1"]
[null,"3.23.18","Corrected text on Recommendations tab from \"2lp, 1 x 4 Fluorescent, T8 to LED, 2x4 Panel, 30 watts\" to \"2lp, 1 x 4 Fluorescent, T8 to LED, 1x4 Panel, 30 watts\"","km","draft_1.1"]
[null,"3.23.18","Corrected error on Recommendations tab, rebate in column M was multiplying the rebate per unit (which was the total rebate for all units on a line) by the number of units; double counting. Rebate per unit has been changed to rebate per ton, Rebate now sums total rebate per recommendation.","km","draft_1.2"]
[null,"3.26.18","Updated \"Proposed Qty\" to \"Proposed Tons\" for HVAC on the recommendations tab","km","draft_1.3"]
[null,"3.26.18","Updated Lighting rebate amounts to be consistent with current program offering'","km","draft_1.3"]
[null,"4.10.2018","Updated Cover tab to reflect 2018","ed","draft_1.3"]
[null,"4.10.2018","Dragged formula down through Lighting Recommdentations on Recommendation tab to match updated lighting rebate values","ed","draft_1.3"]
[null,"4.11.18","Corrected measure code reference for 2lp 1x4","KM","draft_1.4"]
[null,"4.11.18","Added \"Add VFD\" to 1-4hp motors on recommendations tab","km","draft_1.4"]
[null,"4.11.18","Corrected reference error for PTACs ","km","draft_1.4"]
[null,"4.12.18","Correceted rebate calculation for AC Recommendations","KM","draft_1.5"]
[null,"4.16.18","Added Clear Inputs button to Other Data Collection tab","KM","draft_1.5"]
[null,"4.16.18","Updated Geothermal data collection to use new cataegories and not provide a recommendation","KM","draft_1.6"]
[null,"4.16.18","Corrected error in Operating cost calculation for HVAC on Project summary tab. Calc was referencing savings kWh instead of proposed kWh","KM","draft_1.7"]
[null,null,"Updated Tier 0 logic for AC recommendations to reflect new part load criteria",null,"draft_1.7"]
[null,"4.18.18","Corrected Proposed Tons calculation on recommendations tab to total up the tons/unit multiplied by  qty","KM","draft_1.8"]
[null,"4.19.18","Updated AC rebate amounts, on the AC references tab, for the >20&<63 units to be consistent with current rebate values","ED","draft_1.9"]
[null,"4.23.18","Updated protection on the Other Data Collection tab to allow for the the Clear Inputs button to function properly","KM","draft_1.10"]
[null,"5.8.18","Corrected lookup on AC Calculations tab to correctly populate values for PTAC units","KM","draft_1.1"]
[null,"5.14.18","Additional correction to PTAC and PTHP lookups","KM","draft_1.13"]
[null,"6.6.18","Corrected Existing operating costs on project summary tab for HVAC to include heating usage","KM","draft_1.14"]
[null,"6.07.18","Updated effective date to 6.7.18 and version to 1.0","ED",1]
[null,"8.31.18","Added radio buttons to Lighting Data Collection sheet to allow for Fast Track or Performance Lighting selection","KM","draft_1.15"]
[null,"8.31.18","Updated lighting references tab as well as recommendations tab to adjust rebate type based on program selection","KM","draft_1.15"]
[null,"9.6.18","Updated lighting references tab to account for the stimulus performance based number (.30, .15, .10)","ED","draft_1.16"]
[null,"9.10.18","Changed \"IF\" to \"OF\" on Exec Summary - This end use makes up roughly X% OF the facilities eletric load.","ED","draft_1.17"]
[null,"9.10.18","Exec Summary - Updated PSEG link to reflect site update ","ED","draft_1.17"]
[]
[null,"8.13.2019","Updated to \"PSEGLI Home Energy Audit Tool\" ","ED","Version1.0_Draft1"]
[null,"8.13.2019","Updated all CEP references on delveopment tap to reflect 2020 Home Energy Audit 1.1.2020","ED","Version1.0_Draft1"]
[null,"8.13.2019","Lighting and References Tab: Renamed \"Lighting References\" tab to \"Lighting and Appliances References\"","ED","Version1.0_Draft1"]
[null,"8.13.2019","Lighting and Referencces Tab: Hid all CEP references","ED","Version1.0_Draft1"]
[null,"8.13.2019","Lighting and References Tab: Added tables for Drop Downs that correspond with Appliances and Lighting Tabs - \"Appliances\", \"Appliances Location\", \"Lighting\", \"Lighting Location\" - Also added these four drop downs to the \"Name Manager\"","ED","Version1.0_Draft1"]
[null,"8.13.2019","Menu Tab: Renamed \"Facility Data\" link to \"Home Data\"","ED","Version1.0_Draft1"]
[null,"8.13.2019","Home Data Tab: Renamed \"Facility Data\" to \"Home Data\"","ED","Version1.0_Draft1"]
[null,"8.13.2019","Home Data Tab: Removed all CEP specific inputs and added any Resi Inputs based on Steve Wagner's \"2020 HPwES HEA Draft\" document","ED","Version1.0_Draft1"]
[null,"8.13.2019","Home Data Tab: Removed \"Facility Type\" pop-up","ED","Version1.0_Draft1"]
[null,"8.13.2019","Development Tab: Updated Tool name to \"Home Energy Audit Tool\"","ED","Version1.0_Draft1"]
[null,"8.13.2019","Lighting Data Collection Tab: Removed CEP specific inputs and updated to Resi inputs as per \"2020 HPwES HEA Draft\"","ED","Version1.0_Draft1"]
[null,"8.13.2019","Lighting Data Collection: Added drop downs for Lighting Type, Location, ENERGY STAR, Working fields","ED","Version1.0_Draft1"]
[null,"8.13.2019","Appliances Data Collection: Added this new tab (Copied Lighting Data collection tab)- Removed any CEP specific inputs and updated to Resi inputs as per \"2020 HPwES HEA Draft\"","ED","Version1.0_Draft1"]
[null,"8.13.2019","Appliances Data Collection: Added drop down for \"Appliance Type\", \"Location\", \"Working\" ,and \"ENERGY STAR\"","ED","Version1.0_Draft1"]
[null,"8.14.2019","AC References Tab: Hid all CEP references","ED","Version1.0_Draft2"]
[null,"8.14.2019","AC References Tab: Added drop downs for \"System Type\", \"Heating Source\", \"Age\", and \"Equipment Type\" -Also added these drop downs to \"Name Manager\" - All drop down inputs from \"2020 HPwES HEA\" draft","ED","Version1.0_Draft2"]
[null,"8.14.2019","HVAC Data Collection Tab: Removed CEP Specific Inputs and updated to Resi inputs as per \"2020 HPwES HEA Draft\"","ED","Version1.0_Draft2"]
[null,"8.14.2019","DHW Data Collection Tab: Renamed the \"Motors\" Tab to \"DHW\" Collection Tab","ED","Version1.0_Draft2"]
[null,"8.14.2019","DHW References: Added new tab for \"DHW References\"","ED","Version1.0_Draft2"]
[null,"8.14.2019","DHW References Tab: Added fields for \"Heating Source\", \"System Type\", \"Age\", \"Location\" - Also added these to Name Manager","ED","Version1.0_Draft2"]
[null,"8.14.2019","DHW Data Collection: Removed leftover CEP Inputs and updated to Resi inputs per \"2020 HPwES HEA Draft\"","ED","Version1.0_Draft2"]
[null,"8.14.2019","DHW Data Collection: Added drop downs for \"Heating Source\", \"Age\", \"System Type\", \"Location\"","ED","Version1.0_Draft2"]
[null,"8.14.2019","Thermostats and Controls Data Tab: Added new tab","ED","Version1.0_Draft2"]
[null,"8.14.2019","HEA_References Tab: Added new References Tab for ALL HEA References ","ED","Version1.0_Draft2"]
[null,"8.14.2019","HEA_References Tab: Moved all Lighting, Appliances, DHW, and HVAC References to HEA References Tab","ED","Version1.0_Draft2"]
[null,"8.15.2019","Air Sealing Data Collection Tab: Added new tab","ED","Version1.0_Draft3"]
[null,"8.15.2019","Air Sealing Data Collection Tab: Added Resi inputs per \"2020 HPwES HEA Draft\"","ED","Version1.0_Draft3"]
[null,"8.15.2019","HEA_Ref Tab: Added Location for Air Sealing, includs Drop down data and added to Name Manager","ED","Version1.0_Draft3"]
[null,"8.15.2019","Insulation Levels Data Tab: Added new tab - Added resi inputs per \"2020 HPwES HEA Draft\"","ED","Version1.0_Draft3"]
[null,"8.15.2019","Insulation Levels Tab: Added drop downs for \"Location\", \"Condition\", \"R-Value\"","ED","Version1.0_Draft3"]
[null,"8.15.2019","HEA_Ref Tab: Added Insulation Levels fields - Drop Downs for \"Location\", \"Condition\", \"R-Level\" - Added to Name Manager","ED","Version1.0_Draft3"]
[null,"8.15.2019","HEA_Ref Tab: Added \"Duct Sealing\" section - Includes drop down fields for \"Primary Duct Location\" ","ED","Version1.0_Draft3"]
[null,"8.15.2019","Duct Sealing Data Tab: Added new tab - included Resi inputs as per \"2020 HPwES HEA Draft\" document","ED","Version1.0_Draft3"]
[null,"8.15.2019","HEA Ref Tab: Added \"Windows\" Section - Includes drop down fields for \"Location\", \"Type\", , \"Quantity\",and \"Frame Type\"; also added to Name Manager","ED","Version1.0_Draft3"]
[null,"8.15.2019","Windows Tab: Added New Tab - Includes all resi inputs as per \"2020 HPwES HEA Draft\" Document","ED","Version1.0_Draft3"]
[null,"8.15.19","Menu Tab: Added and updated links for the following Tabs: Lighting, Appliances, HVAC, DHW,  Thermostats, Air Sealing, Insulation Levels, Duct Sealing, Windows","ED","Version1.0_Draft3"]
[null,"8.15.19","Name Manager: Updated the \"Data Entry\" Name's in Name Manager to account for Lighting, Appliances, HVAC, DHW, Thermostats, Air Sealing, Insulation Levels, Duct Sealing, Window - Updated all references for each item","ED","Version1.0_Draft3"]
[null,"8.15.19","VBA- Lighting Data Collection: Updated code to include all 10 of the \"Data_Entry\" Names from the Name Manager ","ED","Version1.0_Draft3"]
[null,"8.15.19","All Data Collection Tab: Updated \"Next\" and \"Back\" button links to reflect updated/new tabs","ED","Version1.0_Draft3"]
[null,"8.15.19","Development Tab: Changed \"Home Energy Audit\" to \"Home Energy Assessment\"","ED","Version1.0_Draft3"]
[null,"8.15.19","Cover Tab: Removed all CEP language and updated with Resi language","ED","Version1.0_Draft3"]
[null,"8.15.19","Exec Summary: Removed all CEP language and updated with Resi language as per the \"2020 HPwES HEA Draft\"","ED","Version1.0_Draft3"]
[null,"8.19.19","End Use Graph: Started formatting tab to reflect a summary page- added in formulas to link cells back to the data collection pages","ED","Version 1.0_Draft4"]
[null,"8.19.19","Billing Data Collection Tab: Hidden as per Steve Wagner","ED","Version 1.0_Draft6"]
[null,"8.19.19","Name Manager: Added \"HEA_Lighting_Clear\" 1-11 to Name Manager ","ED","Version 1.0_Draft6"]
[null,"8.19.19","Lighting Data Collection: Updated code on Clear Inputs button to account for \"HEA_Lighting_Clear\" 1-11 enabling Clear Inputs button to work","ED","Version 1.0_Draft6"]
[null,"8.26.19","Name Manager: Added \"HEA_APL_Clear\" 1-10 to Name Manager ","ED","Version 1.0_Draft7"]
[null,"8.26.19","Appliances Data Collection: Updated code on Clear Inputs button to account for \"HEA_APL_Clear\" 1-10","ED","Version 1.0_Draft7"]
[null,"8.26.19","Name Manager: Added \"HEA_HVAC_Clear\" 1-4 to Name Manager","ED","Version 1.0_Draft8"]
[null,"8.26.19","HVAC Data Collection Tab: Updated code on Clear Inputs buttong to account for \"HEA_HVAC_Clear\" 1-4","ED","Version 1.0_Draft8"]
[null,"8.26.19","Name Manager: Added \"HEA_DHW_Clear\" 1-2 to Name Manager","ED","Version 1.0_Draft8"]
[null,"8.26.19","DHW Data Collection Tab: Updated code on Clear Inputs button to account for \"HEA_DHW_Clear\" 1-2","ED","Version 1.0_Draft8"]
[null,"8.26.19","Name Manager: Added \"HEA_Therms_Clear\" 1-2 to Name Manager","ED","Version 1.0_Draft8"]
[null,"8.26.19","Therms Data Collection Tab: Updated code on Clear Inputs tab to account for \"HEA_Therms_Clear\"1-2","ED","Version 1.0_Draft8"]
[null,"8.26.19","Name Manager: Added \"HEA_AirSealing_Clear\" 1-2 to Name Manager","ED","Version 1.0_Draft8"]
[null,"8.26.19","Air Sealing Data Collection Tab: Update code on Clear inputs button to account for \"HEA_AirSealing_Clear\" 1-2","ED","Version 1.0_Draft8"]
[null,"8.26.19","Name Manager: Added \"HEA_Insulation_Clear\" 1-7","ED","Version 1.0_Draft8"]
[null,"8.26.19","Insulation Data Collection Tab: Updated code on clear inputs buttong to accoutn for \"HEA_Insulation_Clear\" 1-7","ED","Version 1.0_Draft8"]
[null,"8.26.19","Name Manager: Added \"HEA_Duct_Clear\" 1-4 to Name Manager","ED","Version 1.0_Draft8"]
[null,"8.26.19","Duct Collection Tab: Updated code on clear inputs tab to account for \"HEA_Duct_Clear\" 1-4","ED","Version 1.0_Draft8"]
[null,"8.26.19","Name Manager: Added \"HEA_Window_Clear\" 1-5 to Name Manager","ED","Version 1.0_Draft8"]
[null,"8.26.19","Window Data Collection Tab: Updated code on clear inputs to account for \"HEA_Window_Clear\" 1-5","ED","Version 1.0_Draft8"]
[null,"8.27.19","Name Manager: Added \"HEA_Other_Clear\" 1-17 to Name Manager","ED","Version 1.0_Draft9"]
[null,"8.27.19","Other Data Collection Tab: Updated code on clear inputs tab to account for \"HEA_Other_Clear\" 1-17","ED","Version 1.0_Draft9"]
[null,"8.27.19","HEA Ref Tab: Added all EEP appliances to the \"Appliances\" Drop Down","Ed","Version 1.0_Draft9"]
[null,"8.27.19","HEA Ref Tab: Added Fuel Source Drop down items under Appliances","ED","Version 1.0_Draft9"]
[null,"8.27.19","Name Manager: Added HEA_Appl_FuelSource to Name Manager","ED","Version 1.0_Draft9"]
[null,"8.27.19","Appliances Data Collection Tab: Added Fuel Source Field and drop down","ED","Version 1.0_Draft9"]
[null,"8.27.19","Appliances Data Collection Tab: reformatted all Data Collection sections","ED","Version 1.0_Draft9"]
[null,"8.27.19","Name Manager \"HEA_APL_Clear\" - Updated fields in Name Manager to account for new Fuel Source Drop Down","ED","Version 1.0_Draft9"]
[null,"8.27.19","HVAC Data Collection Tab: Changed \"Heating Source\" fields to \"Fuel Source\"","ED","Version 1.0_Draft9"]
[null,"8.27.19","DHW Data Collection Tab: Changed \"Heating Source\" fields to \"Fuel Source\"","ED","Version 1.0_Draft9"]
[null,"8.27.19","Air Sealing Data Collection Tab: Removed \"Location\" fields and drop downs; added \"Square Footage\" field","ED","Version 1.0_Draft9"]
[null,"8.27.19","Menu: Removed Billing Data Collection Link","ED","Version 1.0_Draft9"]
[null,"8.27.19","Next and Back Buttons: Removed Billiong Data Collection links","ED","Version 1.0_Draft9"]
[null,"8.27.19","End Use Graph: Changed name of tab to \"HEA_Summary\"","ED","Version 1.0_Draft9"]
[null,"8.27.19","HEA_Summary Tab: Continued adding summary items and linking back to proper data collection tabs","ED","Version 1.0_Draft9"]
[null,"8.27.19","Exec Summary Tab: Updated link in \"Next\" button to account for \"HEA_Summary\" Tab","ED","Version 1.0_Draft9"]
[null,"8.29.19","HEA_Summary Tab: Continued adding summary items and linking back to proper data collection tabs","ED","Version 1.0_Draft10"]
[null,"9.3.19","HEA_Summary 2 Tab: Added Summary 2 tab to split up Summary","ED","Version 1.0_Draft11"]
[null,"9.3.19","Exec Summary Tab: Formatted to meet HPwES needs - Utilized the 2020 HPwES DRAFT document for language; Added fields from \"Home Data\" tab and linked those fields to proper \"Home Data\" cells","ED","Version 1.0_Draft11"]
[null,"9.3.19","Other Data Collection Tab: Results Button - Updated code to remove \"End use Graph\" tab and include \"HEA_Summary\" and \"HEA_Summary_2\" tabs ","ED","Version 1.0_Draft11"]
[null,"9.3.19","Project Summary Tab: Changed to \"Heating and Cooling\"","ED","Version 1.0_Draft11"]
[null,"9.3.19","Summary: Heating and Cooling Tab: Removed all formatting and calcs"]
[null,"9.3.19","Summary:Heating and Coling Tab: Added photo of ASHP from PSEGLI website","ED","Version 1.0_Draft11"]
[null,"9.3.19","Summary:Heating and Cooling Tab: Added fields from HVAC Data Collection Tab and linked those fields back to HVAC Tab","ED","Version 1.0_Draft11"]
[null,"9.3.19","Summary:Heating and Cooling Tab: Added language from 2020 HPwES Draft","ED","Version 1.0_Draft11"]
[null,"9.3.19","Exec Summary Tab: Removed code that hid row 8","Ed","Version 1.0_Draft11"]
[null,"9.3.19","Summary:Lighting and Appliances Tab: Added this new tab","ED","Version 1.0_Draft11"]
[null,"9.3.19","Summary:Lighting and Appliances Tab: Added 10 sections to capture data from Lighting Data Collection","ED","Version 1.0_Draft11"]
[null,"9.3.19","Summary:Lighting and Appliances Tab: Added code to tab to hide lighting sections 5-10 unless data is populated","ED","Version 1.0_Draft11"]
[null,"9.3.19","Summary: Lighting and Appliances Tab: Added 10 sections to capture data from Appliances Data Collection","ED","Version 1.0_Draft11"]
[null,"9.3.19","Summary:Lighting and Appliances Tab: Added code to tab to hide appliance sections 5-10 unless data is populated","ED","Version 1.0_Draft11"]
[null,"9.4.19","Summary:Lighting and Appliances Tab: Added language and pictures to the tab from the 2020 HPwES Draft","ED","Version 1.0_Draft12"]
[null,"9.6.19","Summary:DHW Tab: Added DWH Tab","ED","Version 1.0_Draft13"]
[null,"9.6.19","Summary:DHW Tab: Added two sections to capute DHW Data from DHA Data Collection Tab","ED","Version 1.0_Draft13"]
[null,"9.6.19","Summary:DHW Tab: Added language and images per the 2020 HPwES draft","ED","Version 1.0_Draft13"]
[null,"9.6.19","Summary:Therm and Controls Tab: Added Therm and Controls Tab","ED","Version 1.0_Draft13"]
[null,"9.6.19","Summary:Therm and Controls Tab: Added two sections to capture Therms and Controls data from Data Collection Tab","ED","Version 1.0_Draft13"]
[null,"9.6.19","Summary:Therm and Controls Tab: Added language and images per the 2020 HPwES draft","ED","Version 1.0_Draft13"]
[null,"9.6.19","Summary:Air Sealing Tab: Added Air Sealing Tab","ED","Version 1.0_Draft13"]
[null,"9.6.19","Summary:Air Sealing Tab: Added two sections to cature Air Sealing Data from Data Collection Tab","ED","Version 1.0_Draft13"]
[null,"9.6.19","Summary:Air Sealing Tab: Added language and images per the 2020 HPwES Draft","ED","Version 1.0_Draft13"]
[null,"9.6.19","Summary:Insulation Levels Tab: Added Insulation Levels Tab ","ED","Version 1.0_Draft13"]
[null,"9.6.19","Summary:Insulation Levels Tab: Added 6 sections to captures Insulation Levels data from Data Collection Tab","ED","Version 1.0_Draft13"]
[null,"9.6.19","Summary:Insulation Levels Tab: Added language and images oer the 2020 HPwES Draft","ED","Version 1.0_Draft13"]
[null,"9.6.19","Summary:Duct Sealing Data Tab: Added new tab - included Resi inputs as per \"2020 HPwES HEA Draft\" document","ED","Version 1.0_Draft13"]
[null,"9.6.19","Summary:Duct Sealing Data Tab: Added 4 sections to capture data from data collection tab","ED","Version 1.0_Draft13"]
[null,"9.9.19","Summary: Windows: Added Windows Tab","ED","Version1.0_draft14"]
[null,"9.9.19","Summay:Windows: Added 5 sections to captures window data from data collection tab","ED","Version1.0_draft14"]
[null,"9.9.19","All Summary Tab: Added Number designation to fields - I.E. \"Window 1\"","ED","Version1.0_draft14"]
[null,"9.9.19","Summary: Windows Tab: Added Language and images per the 2020 HPwES Draft","ED","Version1.0_draft14"]
[null,"9.9.19","Other Data Collection Tab: \"Clear Inputs\" button- Updated code to align with new tabs \"HEA_Summary\" and \"HEA_Summary2\"","ED","Version1.0_draft14"]
[null,"9.9.19","All Summary Tabs: Updated links for all \"Next\" buttons to account for new summary tabs","ED","Version1.0_draft14"]
[null,"9.9.19","Other Data Collection Tab: \"Results\" button - Updated code with all new Summary Tabs to populate when \"Results\" is clicked","ED","Version1.0_draft14"]
[null,"9.11.19","HEA_Summary Tab: Linked all inputs on pageto corresponding data collection ages","ED","Version1.0_draft15"]
[null,"9.11.19","HEA_Summary Tab_2: Linked all inputs on pageto corresponding data collection ages","ED","Version1.0_draft15"]
[null,"9.11.19","Summary:Windows Tab: Linked all fields on page to corresponding data collection pages","ED","Version1.0_draft15"]
[null,"9.11.19","Summary:Duct SealingTab : Linked all fields on page to corresponding data collection pages","ED","Version1.0_draft15"]
[null,"9.11.19","Summary:Insulation Levels Tab: Linked all fields on page to corresponding data collection pages","ED","Version1.0_draft15"]
[null,"9.11.19","Summary:Air Sealing Tab: Linked all fields on page to corresponding data collection pages","ED","Version1.0_draft15"]
[null,"9.12.19","Summary: Smart Therms and Controls: Linked all fields on page to corresponding data collection page","ED","Version1.0_draft16"]
[null,"9.12.19","Summary: DHW: Linked all fields on page to corresponding data collection page","ED","Version1.0_draft16"]
[null,"9.12.19","Summary: Heating and Cooling: Linked all fields on page to corresponding data collection page","ED","Version1.0_draft16"]
[null,"9.12.19","Summary: Lighting & Appliances: Linked all fields on page to corresponding data collection page","ED","Version1.0_draft16"]
[null,"9.30.19","Menu Tab: Fixed formatting for links","ED","Version1.0_draft18"]
[null,"9.30.19","Menu Tab: Updated code for \"Results\" button to account for all new tabs","ED","Version1.0_draft18"]
[null,"9.30.19","HEA Ref Tab: Added Rate code field and drop down values","ES","Version1.0_draft18"]
[null,"9.30.19","HEA Ref Tab: Added Rate Code drop down to name manager","ED","Version1.0_draft18"]
[null,"10.01.19","Appliances Data Collection Tab: Added 10 more sections ","ED","Version1.0_draft19"]
[null,"10.01.19","Lighting Data Collection Tab: Fixed formatting for inputs","ED","Version1.0_draft19"]
[null,"10.01.19","Appliances Data Collection Tab: Fixed formatting for inputs","ED","Version1.0_draft19"]
[null,"10.01.19","HVAC Data Collection TabL Fixed Formatting for inputs","ED","Version1.0_draft19"]
[null,"10.01.19","Insulation Data Collection Tab: Fixed formatting for inputs","ED","Version1.0_draft19"]
[null,"10.18.19","HEA Summary 1 and 2 Tabs: Updated formatting to include orange boxes around inputs, similar to data collection tabs","ED","Version1.0_draft20"]
[null,"10.30.19","Hea Ref - Added two tables to name manager \"Orientation\" and \"Foundation\"","ED","Version1.0_draft23"]
[null,"10.30.19","Home Data - Added drop downs to \"Orientation\" and \"Foundation\" inputs","ED","Version1.0_draft23"]
[null,"10.30.19","Lighting Data Collection Tab: Removed drop down in quantity field; made it a manual input","ED","Version1.0_draft23"]
[null,"10.30.19","Appliances Data Collection Tab: Removed Air Purifiers, APS, Dehumidifier, Exhaust Fan, and HPWH from Appliance Drop Down","ED","Version1.0_draft23"]
[null,"10.30.19","HVAC Tab: Added ASHP to Heating and Cooling system type drop downs","ED","Version1.0_draft23"]
[null,"10.30.19","DHW Tab: Added On Demand and HPWH to system Type drop down","ED","Version1.0_draft23"]
[null,"10.30.19","Insulation Tab: Removed drop down for Recommended R Value - Now a manual Input","ED","Version1.0_draft23"]
[null,"10.30.19","Windows Tab: Removed drop down for quantity - Now a manual input","ED","Version1.0_draft23"]
[null,"10.30.19","HEA Tab: Added table for Window Insulation under Windows section - Added to Name Manager","ED","Version1.0_draft23"]
[null,"10.30.19","Windows Tab: Added a field and drop down for Window Insulation","ED","Version1.0_draft23"]
[null,"10.30.19","Windows Tab: Updated All \"Window Clear\" names in Name Manager to account for addition of new field","ED","Version1.0_draft23"]
[null,"10.30.19","HEA SUmmary 1 and 2 Tabs: Made these tabs \"Very Hidden\" - will not use these tabs unless we find they add value","ED","Version1.0_draft23"]
[null,"11.07.2019","Lighting and Appliances Tab (Summary) - Seperated the two tabs, one lighting and one appliances","ED","Version 1.0_Draft24"]
[null,"11.07.2019","Added H&S Tab from HPDI after Exec Summary","ED","Version 1.0_Draft24"]
[null,"11.13.19","Summary Tabs: Removed LMPI Header and Footer","ED","Version 1.0_Draft25"]
[null,"11.13.19","Summary Tabs: Added ES logo to top left of each page; removed \"Home Energy Assessment\" language","ED","Version 1.0_Draft25"]
[null,"11.13.19","Heating and Cool Tab: Renamed HVAC Tab; Added new photo and added additional contact methods","ED","Version 1.0_Draft25"]
[null,"11.13.19","Domestic Hot Water Tab: Renamed to DHW Tab","ED","Version 1.0_Draft25"]
[null,"11.13.19","Appliances Tab: Added more appliance photos to align with chart","ED","Version 1.0_Draft25"]
[null,"11.14.19","Updated tab order per Steve Wagner","ED","Version 1.0_Draft26"]
[null,"11.14.19","Menu : Updated tab order and links","ED","Version 1.0_Draft26"]
[null,"11.14.19","Summary Pages: Updated Links to reflect new tab order","ED","Version 1.0_Draft26"]
[null,"11.14.19","Data Colelction Pages: Updated Links to reflect new tab order","ED","Version 1.0_Draft26"]
[null,"11.14.19","Menu Page - Updated hovering text on link to reflect link name","ED","Version 1.0_Draft26"]
[null,"11.18.19","H&S Heating&Cooling Tab: Hid Tab","ED","Version 1.0_Draft27"]
[null,"11.18.19","Health &Safety Tab: Added Health&Safety Tab from HPDI workbook","ED","Version 1.0_Draft27"]
[null,"11.18.19","Updated Links and code as needed to accommodate addition of the \"Health&Safety\" Tab ","ED","Version 1.0_Draft27"]
[null,"11.18.19","Removed all LMPI Headers and Footers","ED","Version 1.0_Draft27"]
[null,"12.19.19","Drafts 28-33 were all formatting updates","ED"]
[null,"12.19.19","Instructions Tab: Added Instructions tab for partner to use to complete tool, print tool/PDF for customer, and upload to LP Portal","ED","Version 1.0_Draft 34"]
[]
[null,"1.9.20","Locked and prepped for release","ED","Version 1.0"]
[null,"10.14.21","Dev tab: updated version number, draft number and program year","AW","Version 1.0_draft3"]
[null,"10.14.21","Instructions tab: updated Energy Star logo to most recent approved ","AW","Version 1.0_draft3"]
[null,"10.14.21","Cover: updated Energy Star logo to most recent approved","AW","Version 1.0_draft3"]
[null,"10.14.21","Executive Summary: updated Energy Star logo to most recent approved","AW","Version 1.0_draft3"]
[null,"10.14.21","Health&Safety: updated Energy Star logo to most recent approved","AW","Version 1.0_draft3"]
[null,"10.14.21","Heating and Cooling: updated Energy Star logo to most recent approved","AW","Version 1.0_draft3"]
[null,"10.14.21","DHW: updated Energy Star logo to most recent approved","AW","Version 1.0_draft3"]
[null,"10.14.21","Insulation Levels: updated Energy Star logo to most recent approved","AW","Version 1.0_draft3"]
[null,"10.14.21","Air Sealing: updated Energy Star logo to most recent approved","AW","Version 1.0_draft3"]
[null,"10.14.21","Duct Sealing: updated Energy Star logo to most recent approved","AW","Version 1.0_draft3"]
[null,"10.14.21","Thermostats and Controls: updated Energy Star logo to most recent approved","AW","Version 1.0_draft3"]
[null,"10.14.21","Lighting: updated Energy Star logo to most recent approved","AW","Version 1.0_draft3"]
[null,"10.14.21","Appliances: updated Energy Star logo to most recent approved","AW","Version 1.0_draft3"]
[null,"10.25.21","Heating and Cooling: added language to row 36 from Home Comfort website.","AW","Version 1.0_draft4"]
[null,"11.19.21","PSEG LI Logo updated to most recent approved version throughout entire workbook","AW","Version 1.0_draft5"]
[null,"12.22.21","Centered PSEG Logos","ED","Version1.0 Draft6-8"]
[null,null,"Exec Summary: Added Signature Block for Customer and Auditor"]
[null,null,"Instructions Tab: Added a row informing auditor and customer that Exec Summary must be signed"]
[null,null,"Exec Summary: Added \" I certify that the Home Energy Assessment was conducted at the address listed above.\""]
[null,"1.25.22","Adjust page layout/formatting wherever necessary so that report is printable","AW","Version1.1_draft1"]
[null,"1.26.22","Exec Summary: Adjusted formatting on row 18","AW","Version1.1_draft2"]
[]
[null,"2.25.22","Exec Summary Tab: Added \"Customer Account Number\" ","ED","Version2.0_Draft1"]
[null,"3.1.22","Exec Summary Tab: Added \"Customer Email Address\"","ED","Version2.0_Draft1"]
[]
[]
[null,"10.21.22","Dev Tab: Updated Version, Date, Effective for 2023","ED","V1_D1"]
[null,null,"Results - Appliances: Removed Lawn Equipment information"]
[null,"11.8.22","All Tabs: Updated ES PYOY Logo for 2022","ED","V1_D2"]
[]
[null,"12.29.22","Locked and Final per client approval","ED","v1"]
[]
[null,"9.1.23","Updated all colors to Dark Steel Gray","EM","v1_Draft1"]
[null,null,"Updated headers with new logo"]
[null,null,"Dev Tab: Updated Version, Date, Effective for 2024"]
[null,null,"Reformatted every header"]
[null,null,"Removed old energy star from all pages"]
[null,null,"Removed Home Performance with Energy star, replaced with Home Performance Program"]
[]
[null,"9.5.23","Dev Tab: Updated Version, Date, Effective for 2024","EM","v1_Draft2"]
[null,null,"Open Tab updated logo"]
[null,null,"Updated results area, removed Old Energy Star Logo"]
[null,null,"Results Area: new PSEG logo and updated colors to Dark Steel Gray"]
[null,null,"After using clear input, back and next buttons do not work"]
[null,null,"HVAC Data Collection: Clear Input does not work"]
[]
[null,"9.6.23","Appliances Tab - Removed lawn equipment","EM","v1_Draft3"]
[null,null,"Lighting Tab - Removed lawn equipment"]
[null,null,"Duct Sealing Data Collection Tab: Deleted Existing Wattage and Proposed Device "]
[null,null,"Insulation Levels Data Collection Tab: Deleted Existing Wattage and Proposed Device "]
[]
[null,null,"Executive Summary Tab: Removed all Home Performance with Energy Star to Home Performance Program"]
[]
[null,"10.17.23","Insulation Tab: Added window languages","ED","V1_Draft4"]
[]
[null,"8.29.24","Removed Partial Home from Heating and Cooling tab","EM","V1_Draft2"]
[]
[null,"11.4.24","Instructions Tab: Fixed envelope error","EM","V1_Draft4"]
[null,null,"Instructions Tab: Please upload the entire Home Energy Assessment Tool Excel document changed to PDF Doc"]
[null,null,"Made Lighting Data Collection and Lighting Tab \" Very Hidden\""]
[null,null,"Added \"N/A\" to all dropdowns"]
[null,null,"Changed Ages 2nd option from 10-15 to 5-15"]
[null,null,"Insulation Levels Data Collection: Added in field of \"Specify Location as Needed\""]
[]
[null,"12.4.24","Home Data: Updated E-Mail Formatting","EM","V1_Draft14"]
[null,null,"Window Data Collection: Updated Buttons"]
[null,null,"Insulation Levels: Reformatted Square Foot"]
[null,null,"Reformatted all of Results Tabs"]

{"sheet":"Open","index":2,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[11,4,15,9],[17,4,17,9],[33,0,33,13]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"Development!B3&\" Version \"&Development!B4","v":"Home Energy Assessment Version 1.0"}]

{"sheet":"Instructions","index":3,"n_rows":47,"n_cols":4,"rows_kept":47,"cut":false,"hidden":false,"merged":[[41,1,42,15],[9,1,11,15],[12,1,12,13],[20,1,20,11],[14,1,14,15],[16,1,16,15],[18,1,18,15]]}
[{"$f":"Development!B3","v":"Home Energy Assessment"}]
[null,"Instructions"]
[]
[]
[]
[]
[]
[]
[]
[null,"The PSEG Long Island Home Energy Assessment Tool gathers a customer's energy usage data (including their existing appliances, heating and cooling equipment, lighting, and building envelope) in order to supply them with a comprehensive report on their home and how to make it more energy efficient."]
[]
[]
[null,"Cells requiring input are shaded with a gray background.  Cells with white background are locked and will auto populate."]
[]
[null,"1. Navigate to \"Home Data\" tab and complete all customer inputs"]
[]
[null,"2. Click the \"Next\" arrow, or tab name, to move to the next tab(s) and complete the applicable tabs during the Home Energy Assessment  "]
[]
[null,"3. Conduct the Health & Safety checks by using the \"Health&Safety_Data\" tab, after the data collection tabs are complete"]
[]
[null,"4. Input any other appliances/equipment not captured on the data collection tabs on the \"Other Data Collection\" tab"]
[]
[null,"5. Upon finishing the data collection tabs, click the \"Results\" button on the \"Other Data Collection\" tab to generate the Report for the customer"]
[]
[null,"6. On the \"Executive Summary\" tab of the \"Results\", Customer and Auditor must sign the signature block on document, certifying assessment was conducted at listed address"]
[]
[null,"7. After the Home Energy Assessment is completed, provide the customer with a copy of the HEA Report"]
[null,null,"- The HEA Report can be printed and given to the customer or e-mailed to the customer as a PDF"]
[]
[null,"8. To print the report, click on the \"Cover\" tab of the HEA Report and click the \"CTRL\" key on the keyboard"]
[null,null,"- Continue to hold the \"CTRL\" key and click on the remaining, purple tabs of the HEA Report; this will \"Group\" the sheets for print"]
[null,null,null,"- To \"ungroup\" the sheets, right click on any of the selected tabs and click \"Ungroup Sheets\""]
[null,null,"- After all HEA Report tabs have been clicked, navigate to the \"File\" button on the top left of the Excel screen and click \"Print\""]
[null,null,"- Under \"Printer\" select the \"Print to PDF\" option and save the document to a folder"]
[]
[null,"9. Send the HEA Report PDF to the customer or print a copy to give to the customer"]
[null,null,"- The customer should receive the HEA Report (from the purple tabs) only and not the entire Home Energy Assessment excel document"]
[null,null,"- Enure the copy of the HEA Report the customer receives is a PDF version only"]
[]
[null,"10. Once the customer receives the HEA Report, navigate to the Lead Partner Portal and click the \"Online Application\" link and then the \"Approved\" link"]
[]
[null,"11. Select the Home Energy Assessment Online Application ID that is associated with the completed Home Energy Assessment and click the \"Document Upload\" button"]
[]
[null,null,"- Please upload the entire Home Energy Assessment Tool PDF document"]
[null,null,"- If unable to access the Lead Partner Portal, the Home Energy Assessment Tool may be e-mailed to HomePerformanceLI@pseg.com"]
[]
[null,"***Under no circumstances should the homeowner be emailed the excel version of the modeling tool."]

{"sheet":"Menu","index":4,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[7,7,7,10],[11,7,11,10],[9,2,9,5],[11,2,11,5],[13,2,13,5],[7,2,7,5],[13,7,13,10],[9,7,9,10],[8,2,8,5],[14,7,14,10],[27,0,27,12],[21,2,21,6],[15,2,15,5],[17,7,17,10],[17,2,17,6],[15,7,15,12]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Click to Enter Home Data",null,null,null,null,"Click to Enter Thermostat Data"]
[]
[null,null,"Click to Enter HVAC Data",null,null,null,null,"Click to Enter Lighting Data"]
[]
[null,null,"Click to Enter DHW Data",null,null,null,null,"Click to Enter Appliances Data"]
[]
[null,null,"Click to Enter Insulation Data",null,null,null,null,"Click to Enter Windows Data "]
[]
[null,null,"Click to Enter Air Sealing Data",null,null,null,null,"Click to Enter Health & Safety Data "]
[]
[null,null,"Click to Enter Duct Sealing Data",null,null,null,null,"Click to Enter Other Data "]

{"sheet":"Home Data","index":5,"n_rows":41,"n_cols":41,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,5,40,6]]}
[{"$f":"Development!B3","v":"Home Energy Assessment"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"College – Cafeteria"]
[null,"Home Data"]
[]
[]
[null,"Customer Information"]
[]
[null,"Account Name : ",null,null,null,null,"Application ID : "]
[]
[null,"Home Address : ",null,null,null,null,"Account # : "]
[]
[null,"City, State, Zip : ",null,null,null,null,"Rate Code:"]
[]
[null,"Alternate Contact Name : ",null,null,null,null,"Phone : "]
[]
[null,"E-mail : ",null,null,null,null,"Fax  : "]
[]
[]
[null,"Home Performance with ENERGY STAR Partner Information"]
[]
[null,"Home Energy Audit Date:",null,null,null,null,"Phone:"]
[]
[null,"HPwES Partner:",null,null,null,null,"Email: "]
[]
[null,"Property Details"]
[]
[null,"Home Orientation:",null,null,null,null,"Foundation Type:"]
[]
[null,"Year Built:",null,null,null,null,"Condtioned Area:"]
[]
[]
[]
[null,"Number of Occupants",null,null,null,null,"Heating Fuel Type:"]
[]
[null,"Floors Above Grade:",null,null,null,null,"Building Square Footage:"]
[]
[]
[null,"Electrical System"]
[]
[null,"Panel Type:",null,null,null,null,"Main Breaker Size:"]
[]
[null,"Does the Home Have Solar:",null,null,null,"Does the Home Have Battery Storage:"]

{"sheet":"HVAC Data Collection","index":6,"n_rows":74,"n_cols":11,"rows_kept":74,"cut":false,"hidden":false,"merged":[[7,2,7,5],[73,11,73,14],[75,11,75,14],[18,11,18,14],[20,11,20,14],[37,11,37,14],[39,11,39,14],[55,11,55,14],[57,11,57,14],[48,2,48,5],[50,2,50,5],[53,2,53,5],[64,2,64,5],[79,2,79,4],[66,2,66,5],[68,2,68,5],[71,2,71,5],[9,2,9,5],[11,2,11,5],[13,2,13,5],[16,2,16,5],[18,2,18,5],[26,2,26,5],[28,2,28,5],[30,2,30,5],[32,2,32,5],[35,2,35,5],[37,2,37,5],[46,2,46,5],[81,2,81,8],[92,2,92,4],[83,2,83,4],[85,2,85,8],[87,2,87,6]]}
[{"$f":"Development!B3","v":"Home Energy Assessment"}]
[null,"Heating and Cooling "]
[]
[]
[null,{"$f":"B4+1","v":1},"Heating System"]
[]
[]
[null,"Location:",null,null,null,null,null,null,null,"Qty:"]
[]
[null,"Equipment Type:",null,null,null,null,null,null,null,"Working:"]
[]
[null,"Age:",null,null,null,null,null,null,null,"% of Heating Load:"]
[]
[null,"Fuel Source:",null,null,null,null,null,null,null,"HSPF (if Applicable):"]
[]
[]
[null,"Heating Capacity:",null,null,null,null,"btu (Ex. 80,000)"]
[]
[null,"Efficiency:",null,null,null,null,"AFUE (Ex. 80.5%)",null,null,null,"Notes:"]
[]
[]
[]
[]
[]
[null,{"$f":"B5+1","v":2},"Heating System"]
[]
[null,"Location:",null,null,null,null,null,null,null,"Qty:"]
[]
[null,"Equipment Type:",null,null,null,null,null,null,null,"Working:"]
[]
[null,"Age:",null,null,null,null,null,null,null,"% of Heating Load:"]
[]
[null,"Fuel Source:",null,null,null,null,null,null,null,"HSPF (if Applicable):"]
[]
[]
[null,"Heating Capacity:",null,null,null,null,"btu (Ex. 80,000)"]
[]
[null,"Efficiency:",null,null,null,null,"AFUE (Ex. 80.5%)",null,null,null,"Notes:"]
[]
[]
[]
[]
[]
[null,{"$f":"B25+1","v":3},"Cooling System"]
[]
[]
[null,"Location:",null,null,null,null,null,null,null,"Qty:"]
[]
[null,"Equipment Type:",null,null,null,null,null,null,null,"Working:"]
[]
[null,"Age:",null,null,null,null,null,null,null,"% of Cooling Load:"]
[]
[]
[null,"Cooling Capacity: ",null,null,null,null,"btu (Ex. 36,000)"]
[]
[null,"Efficiency:","SEER",null,"EER",null,null,null,null,null,"Notes:"]
[]
[]
[]
[]
[]
[null,{"$f":"B44+1","v":4},"Cooling System"]
[]
[]
[null,"Location:",null,null,null,null,null,null,null,"Qty:"]
[]
[null,"Equipment Type:",null,null,null,null,null,null,null,"Working:"]
[]
[null,"Age:",null,null,null,null,null,null,null,"% of Cooling Load:"]
[]
[]
[null,"Cooling Capacity:",null,null,null,null,"btu (Ex. 36,000)"]
[]
[null,"Efficiency:","SEER",null,"EER",null,null,null,null,null,"Notes:"]

{"sheet":"DHW Data Collection","index":7,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":false,"merged":[[35,2,35,13],[36,2,36,13],[37,2,37,13],[27,9,27,10],[25,9,25,10],[25,2,25,4],[27,2,27,4],[23,9,23,10],[17,2,17,13],[18,2,18,13],[19,2,19,13],[23,2,23,4],[5,2,5,4],[7,2,7,4],[9,2,9,4],[9,9,9,10],[7,9,7,10],[5,9,5,10]]}
[{"$f":"Development!B3","v":"Home Energy Assessment"}]
[null,"Domestic Hot Water"]
[]
[]
[null,{"$f":"B4+1","v":1}]
[null,"Location:",null,null,null,null,null,null,"Fuel Source:"]
[]
[null,"System Type:",null,null,null,null,null,null,"Energy Factor (EF):",null,null,"(Ex. .80)"]
[]
[null,"Age:",null,null,null,null,null,null,"Temperature Setting:"]
[]
[]
[]
[]
[]
[null,"Motor Type",{"$f":"#REF!&\" \"&#REF!","v":{"$error":"#REF!"}}]
[null,"Annual Operating Hrs.",{"$f":"IF(OR(C16=\"Cooling Fan\",C16=\"Heating Fan\"),VLOOKUP('Home Data'!$C$26,Motor_Hours,4,FALSE),IF(C16=\"Cooling Pump\",VLOOKUP('Home Data'!$C$26,Motor_Hours,2,FALSE),VLOOKUP('Home Data'!$C$26,Motor_Hours,3,FALSE)))","v":{"$error":"#REF!"}}]
[null,"Notes:"]
[]
[]
[]
[]
[null,{"$f":"B5+1","v":2}]
[null,"Location:",null,null,null,null,null,null,"Fuel Source:"]
[]
[null,"System Type:",null,null,null,null,null,null,"Energy Factor (EF):",null,null,"(Ex. .80)"]
[]
[null,"Age: ",null,null,null,null,null,null,"Temperature Setting:"]
[]
[]
[]
[]
[]
[null,"Motor Type",{"$f":"#REF!&\" \"&#REF!","v":{"$error":"#REF!"}}]
[null,"Annual Operating Hrs.",{"$f":"IF(OR(C34=\"Cooling Fan\",C34=\"Heating Fan\"),VLOOKUP('Home Data'!$C$26,Motor_Hours,4,FALSE),IF(C34=\"Cooling Pump\",VLOOKUP('Home Data'!$C$26,Motor_Hours,2,FALSE),VLOOKUP('Home Data'!$C$26,Motor_Hours,3,FALSE)))","v":{"$error":"#REF!"}}]
[null,"Notes:"]

{"sheet":"Insulation Levels Data Collec","index":8,"n_rows":92,"n_cols":11,"rows_kept":92,"cut":false,"hidden":false,"merged":[[91,3,91,14],[92,3,92,14],[61,3,61,14],[62,3,62,14],[76,3,76,14],[77,3,77,14],[6,3,6,5],[8,3,8,5],[10,3,10,5],[31,3,31,14],[32,3,32,14],[21,3,21,5],[23,3,23,5],[25,3,25,5],[16,3,16,14],[17,3,17,14],[36,3,36,5],[38,3,38,5],[40,3,40,5],[85,3,85,5],[83,3,83,5],[81,3,81,5],[66,3,66,5],[68,3,68,5],[70,3,70,5],[46,3,46,14],[47,3,47,14],[51,3,51,5],[53,3,53,5],[55,3,55,5]]}
[null,{"$f":"Development!B3","v":"Home Energy Assessment"}]
[null,null,"Insulation Levels"]
[]
[]
[]
[null,{"$f":"B3+1","v":1}]
[null,null,"Location:",null,null,null,null,null,null,null,"Condition:"]
[]
[null,null,"Specify Location as Needed:",null,null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Insulation Levels Data Collec'!K11,#REF!,0))","v":{"$error":"#REF!"}},null,"Existing R Value:"]
[]
[null,null,"Area (Sq Ft):",null,null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Insulation Levels Data Collec'!#REF!,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"Recommended R Value :"]
[]
[null,null,null,null,null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Insulation Levels Data Collec'!K11,#REF!,0))/12","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(#REF!=\"Not Listed\",LEFT(D15,6)=\"Custom\"),\"Custom\",IF(D15=\"\",\"\",D15))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,true]
[null,null,"Notes:"]
[]
[]
[]
[null,{"$f":"B6+1","v":2}]
[null,null,"Location:",null,null,null,null,null,null,null,"Condition:"]
[]
[null,null,"Specify Location as Needed:",null,null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Insulation Levels Data Collec'!K26,#REF!,0))","v":{"$error":"#REF!"}},null,"Existing R Value:"]
[]
[null,null,"Area (Sq Ft):",null,null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Insulation Levels Data Collec'!#REF!,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"Recommended R Value :"]
[]
[null,null,null,null,null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Insulation Levels Data Collec'!K24,#REF!,0))/12","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(D26=\"Not Listed\",LEFT(D30,6)=\"Custom\"),\"Custom\",IF(D30=\"\",\"\",D30))","v":""}]
[null,null,null,null,null,null,null,null,false]
[null,null,"Notes:"]
[]
[]
[]
[null,{"$f":"B21+1","v":3}]
[null,null,"Location:",null,null,null,null,null,null,null,"Condition:"]
[]
[null,null,"Specify Location as Needed:",null,null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Insulation Levels Data Collec'!K41,#REF!,0))","v":{"$error":"#REF!"}},null,"Existing R Value:"]
[]
[null,null,"Area (Sq Ft):",null,null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Insulation Levels Data Collec'!#REF!,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"Recommended R Value :"]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(D41=\"Not Listed\",LEFT(D45,6)=\"Custom\"),\"Custom\",IF(D45=\"\",\"\",D45))","v":""}]
[null,null,null,null,null,null,null,null,false]
[null,null,"Notes:"]
[]
[]
[]
[null,{"$f":"B36+1","v":4}]
[null,null,"Location:",null,null,null,null,null,null,null,"Condition:"]
[]
[null,null,"Specify Location as Needed:",null,null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Insulation Levels Data Collec'!K56,#REF!,0))","v":{"$error":"#REF!"}},null,"Existing R Value:"]
[]
[null,null,"Area (Sq Ft):",null,null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Insulation Levels Data Collec'!#REF!,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"Recommended R Value :"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,false]
[null,null,"Notes:"]
[]
[]
[]
[null,{"$f":"B51+1","v":5}]
[null,null,"Location:",null,null,null,null,null,null,null,"Condition:"]
[]
[null,null,"Specify Location as Needed:",null,null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Insulation Levels Data Collec'!K71,#REF!,0))","v":{"$error":"#REF!"}},null,"Existing R Value:"]
[]
[null,null,"Area (Sq Ft):",null,null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Insulation Levels Data Collec'!#REF!,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"Recommended R Value :"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,false]
[null,null,"Notes:"]
[]
[]
[]
[null,{"$f":"B66+1","v":6}]
[null,null,"Location:",null,null,null,null,null,null,null,"Condition:"]
[]
[null,null,"Specify Location as Needed:",null,null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Insulation Levels Data Collec'!K86,#REF!,0))","v":{"$error":"#REF!"}},null,"Existing R Value:"]
[]
[null,null,"Area (Sq Ft):",null,null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Insulation Levels Data Collec'!#REF!,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"Recommended R Value :"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,false]
[null,null,"Notes:"]

{"sheet":"Air Sealing Data Collection","index":9,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[[5,2,5,4],[5,9,5,10],[7,2,7,4],[9,2,9,4],[37,2,37,13],[23,2,23,4],[23,9,23,10],[25,2,25,4],[27,2,27,4],[17,2,17,13],[18,2,18,13],[19,2,19,13],[35,2,35,13],[36,2,36,13]]}
[{"$f":"Development!B3","v":"Home Energy Assessment"}]
[null,"Air Sealing (Air Leakage)"]
[]
[]
[null,{"$f":"B4+1","v":1}]
[null,"Square Footage:",null,null,null,null,null,null,"Blower Door Reading - CFM50 Pre:"]
[]
[null,"Conditioned Air Volume:"]
[]
[null,"Calculated  BAS - CFM50*:"]
[]
[null,"*Building Airflow Standard"]
[]
[]
[]
[null,"Motor Type",{"$f":"#REF!&\" \"&#REF!","v":{"$error":"#REF!"}}]
[null,"Annual Operating Hrs.",{"$f":"IF(OR(C16=\"Cooling Fan\",C16=\"Heating Fan\"),VLOOKUP('Home Data'!$C$26,Motor_Hours,4,FALSE),IF(C16=\"Cooling Pump\",VLOOKUP('Home Data'!$C$26,Motor_Hours,2,FALSE),VLOOKUP('Home Data'!$C$26,Motor_Hours,3,FALSE)))","v":{"$error":"#REF!"}}]
[null,"Notes:"]
[]
[]
[]
[]
[null,{"$f":"B5+1","v":2}]
[null,"Square Footage:",null,null,null,null,null,null,"Blower Door Reading - CFM50 Pre:"]
[]
[null,"Condtioned Air Volume:"]
[]
[null,"Calculated BAS - CFM50*: "]
[]
[null,"*Building Airflow Standard"]
[]
[]
[]
[null,"Motor Type",{"$f":"#REF!&\" \"&#REF!","v":{"$error":"#REF!"}}]
[null,"Annual Operating Hrs.",{"$f":"IF(OR(C34=\"Cooling Fan\",C34=\"Heating Fan\"),VLOOKUP('Home Data'!$C$26,Motor_Hours,4,FALSE),IF(C34=\"Cooling Pump\",VLOOKUP('Home Data'!$C$26,Motor_Hours,2,FALSE),VLOOKUP('Home Data'!$C$26,Motor_Hours,3,FALSE)))","v":{"$error":"#REF!"}}]
[null,"Notes:"]

{"sheet":"Duct Sealing Data Collection","index":10,"n_rows":65,"n_cols":11,"rows_kept":65,"cut":false,"hidden":false,"merged":[[54,2,54,3],[58,2,58,3],[64,2,64,12],[65,2,65,12],[32,2,32,12],[33,2,33,12],[38,2,38,3],[42,2,42,3],[48,2,48,12],[49,2,49,12],[40,2,40,3],[56,2,56,3],[26,2,26,3],[6,2,6,3],[10,2,10,3],[16,2,16,12],[17,2,17,12],[22,2,22,3],[8,2,8,3],[24,2,24,3]]}
[{"$f":"Development!B3","v":"Home Energy Assessment"}]
[null,"Duct Sealing"]
[]
[]
[null,{"$f":"B4+1","v":1},"Heating System "]
[]
[null,"Primary Duct Location:",null,null,null,null,null,null,"Total Ductwork Square Footage:",null,"(Feet)"]
[]
[null,"Existing Ductwork Insulation:",null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Duct Sealing Data Collection'!I9,#REF!,0))","v":{"$error":"#REF!"}},null,"Square Footage of Ductwork:",null,"(Unconditioned Space)"]
[]
[null,"Existing Ductwork Sealed?:",null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Duct Sealing Data Collection'!C11,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"Ductwork R-Value:"]
[]
[null,null,null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Duct Sealing Data Collection'!I9,#REF!,0))/12","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,{"$f":"IF(OR(C11=\"Not Listed\",LEFT(C15,6)=\"Custom\"),\"Custom\",IF(C15=\"\",\"\",C15))","v":""}]
[null,null,null,null,null,null,true]
[null,"Notes:"]
[]
[]
[]
[null,{"$f":"B5+1","v":2},"Heating System"]
[]
[null,"Primary Duct Location:",null,null,null,null,null,null,"Total Ductwork Square Footage:",null,"(Feet)"]
[]
[null,"Existing Ductwork Insulation:",null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Duct Sealing Data Collection'!I25,#REF!,0))","v":{"$error":"#REF!"}},null,"Square Footage of Ductwork:",null,"(Unconditioned Space)"]
[]
[null,"Existing Ductwork Sealed?:",null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Duct Sealing Data Collection'!C27,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"Ductwork R-Value:"]
[]
[]
[]
[]
[null,null,null,null,null,null,false]
[null,"Notes:"]
[]
[]
[]
[{"$f":"B21+1","v":3},null,"Cooling System"]
[]
[null,"Primary Duct Location:",null,null,null,null,null,null,"Total Square Footage of Ductwork:",null,"(Feet)"]
[]
[null,"Existing Ductwork Insulation:",null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Duct Sealing Data Collection'!I41,#REF!,0))","v":{"$error":"#REF!"}},null,"Square Footage of Ductwork:",null,"(Unconditioned Space)"]
[]
[null,"Existing Ductwork Sealed?:",null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Duct Sealing Data Collection'!C43,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"Ductwork R-Value:"]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"IF(OR(C43=\"Not Listed\",LEFT(C47,6)=\"Custom\"),\"Custom\",IF(C47=\"\",\"\",C47))","v":""}]
[null,null,null,null,null,null,false]
[null,"Notes:"]
[]
[]
[]
[{"$f":"A37+1","v":4},null,"Cooling System"]
[]
[null,"Primary Duct Location:",null,null,null,null,null,null,"Total Square Footage of Ductwork:",null,"(Feet)"]
[]
[null,"Existing Ductwork Insulation:",null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Duct Sealing Data Collection'!I57,#REF!,0))","v":{"$error":"#REF!"}},null,"Square Footage of Ductwork:",null,"(Unconditioned Space)"]
[]
[null,"Existing Ductwork Sealed?:",null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Duct Sealing Data Collection'!C59,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"Ductwork R-Value:"]
[]
[]
[]
[]
[null,null,null,null,null,null,false]
[null,"Notes:"]

{"sheet":"Thermostats and Controls Data ","index":11,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[[36,2,36,13],[37,2,37,13],[25,2,25,4],[27,2,27,4],[25,9,25,10],[27,9,27,10],[23,9,23,10],[17,2,17,13],[35,2,35,13],[5,2,5,4],[7,2,7,4],[9,2,9,4],[23,2,23,4],[5,9,5,10],[18,2,18,13],[19,2,19,13],[9,9,9,10],[7,9,7,10]]}
[{"$f":"Development!B3","v":"Home Energy Assessment"}]
[null,"Thermostats and Controls"]
[]
[]
[null,{"$f":"B4+1","v":1}]
[null,"Location:",null,null,null,null,null,null,"Thermostat Type:"]
[]
[null,"Heating Set Point - High:",null,null,null,null,null,null,"Cooling Set Point - High:"]
[]
[null,"Heating Set Point - Low:",null,null,null,null,null,null,"Cooling Set Point - Low:"]
[]
[]
[]
[]
[]
[null,"Motor Type",{"$f":"#REF!&\" \"&#REF!","v":{"$error":"#REF!"}}]
[null,"Annual Operating Hrs.",{"$f":"IF(OR(C16=\"Cooling Fan\",C16=\"Heating Fan\"),VLOOKUP('Home Data'!$C$26,Motor_Hours,4,FALSE),IF(C16=\"Cooling Pump\",VLOOKUP('Home Data'!$C$26,Motor_Hours,2,FALSE),VLOOKUP('Home Data'!$C$26,Motor_Hours,3,FALSE)))","v":{"$error":"#REF!"}}]
[null,"Notes:"]
[]
[]
[]
[]
[null,{"$f":"B5+1","v":2}]
[null,"Location:",null,null,null,null,null,null,"Thermostat Type:"]
[]
[null,"Heating Set Point - High:",null,null,null,null,null,null,"Cooling Set Point - High:"]
[]
[null,"Heating Set Point - Low:",null,null,null,null,null,null,"Cooling Set Point - Low:"]
[]
[]
[]
[]
[]
[null,"Motor Type",{"$f":"#REF!&\" \"&#REF!","v":{"$error":"#REF!"}}]
[null,"Annual Operating Hrs.",{"$f":"IF(OR(C34=\"Cooling Fan\",C34=\"Heating Fan\"),VLOOKUP('Home Data'!$C$26,Motor_Hours,4,FALSE),IF(C34=\"Cooling Pump\",VLOOKUP('Home Data'!$C$26,Motor_Hours,2,FALSE),VLOOKUP('Home Data'!$C$26,Motor_Hours,3,FALSE)))","v":{"$error":"#REF!"}}]
[null,"Notes:"]

{"sheet":"Lighting Data Collection","index":12,"n_rows":154,"n_cols":10,"rows_kept":154,"cut":false,"hidden":false,"merged":[[134,9,134,10],[149,9,149,10],[115,9,115,10],[128,9,128,10],[130,9,130,10],[147,9,147,10],[4,3,4,7],[4,8,4,9],[153,2,153,12],[154,2,154,12],[143,2,143,3],[143,9,143,10],[145,9,145,10],[145,2,145,3],[147,2,147,3],[128,2,128,3],[138,2,138,12],[139,2,139,12],[113,2,113,3],[123,2,123,12],[124,2,124,12],[113,9,113,10],[115,2,115,3],[117,2,117,3],[130,2,130,3],[132,2,132,3],[98,2,98,3],[108,2,108,12],[109,2,109,12],[98,9,98,10],[100,9,100,10],[100,2,100,3],[102,2,102,3],[102,9,102,10],[117,9,117,10],[132,9,132,10],[104,9,104,10],[119,9,119,10],[83,2,83,3],[93,2,93,12],[94,2,94,12],[83,9,83,10],[85,9,85,10],[85,2,85,3],[87,2,87,3],[87,9,87,10],[89,9,89,10],[78,2,78,12],[79,2,79,12],[53,2,53,3],[63,2,63,12],[64,2,64,12],[53,9,53,10],[55,9,55,10],[68,9,68,10],[70,9,70,10],[55,2,55,3],[57,2,57,3],[70,2,70,3],[72,2,72,3],[72,9,72,10],[59,9,59,10],[74,9,74,10],[49,2,49,12],[23,2,23,3],[33,2,33,12],[34,2,34,12],[68,2,68,3],[23,9,23,10],[25,9,25,10],[38,9,38,10],[40,9,40,10],[25,2,25,3],[27,2,27,3],[40,2,40,3],[42,2,42,3],[57,9,57,10],[29,9,29,10],[44,9,44,10],[8,2,8,3],[38,2,38,3],[48,2,48,12],[18,2,18,12],[19,2,19,12],[8,9,8,10],[10,2,10,3],[12,2,12,3],[27,9,27,10],[42,9,42,10],[10,9,10,10],[12,9,12,10],[14,9,14,10]]}
[{"$f":"Development!B3","v":"Home Energy Assessment"}]
[null,"Lighting"]
[]
[]
[null,null,null,"% of Home LED Lighting:"]
[]
[]
[{"$f":"A3+1","v":1}]
[null,"Lighting Type:",null,null,null,null,null,null,"Existing Incandescent % of Lighting:"]
[]
[null,"Location:",null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Lighting Data Collection'!B11,#REF!,0))","v":{"$error":"#REF!"}},null,"Existing CFL % of Lighting:"]
[]
[null,"Working:",null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Lighting Data Collection'!#REF!,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"Existing LED % of Lighting:"]
[]
[null,null,null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Lighting Data Collection'!B11,#REF!,0))/12","v":{"$error":"#REF!"}},null,null,"All Lighting must add to 100%"]
[]
[null,null,null,null,null,null,{"$f":"IF(OR(#REF!=\"Not Listed\",LEFT(C17,6)=\"Custom\"),\"Custom\",IF(C17=\"\",\"\",C17))","v":{"$error":"#REF!"}}]
[]
[null,"Notes:"]
[]
[]
[]
[{"$f":"A8+1","v":2}]
[null,"Lighting Type:",null,null,null,null,null,null,"Existing Incandescent % of Lighting"]
[]
[null,"Location:",null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Lighting Data Collection'!B26,#REF!,0))","v":{"$error":"#REF!"}},null,"Existing CFL % of Lighting"]
[]
[null,"Working:",null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Lighting Data Collection'!#REF!,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"Existing LED % of Lighting"]
[]
[null,null,null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Lighting Data Collection'!B26,#REF!,0))/12","v":{"$error":"#REF!"}},null,null,"All Lighting must add to 100%"]
[]
[null,null,null,null,null,null,{"$f":"IF(OR(C28=\"Not Listed\",LEFT(C32,6)=\"Custom\"),\"Custom\",IF(C32=\"\",\"\",C32))","v":""}]
[null,null,null,null,null,null,false]
[null,"Notes:"]
[]
[]
[]
[{"$f":"A23+1","v":3}]
[null,"Lighting Type:",null,null,null,null,null,null,"Existing Incandescent % of Lighting"]
[]
[null,"Location:",null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Lighting Data Collection'!B41,#REF!,0))","v":{"$error":"#REF!"}},null,"Existing CFL % of Lighting"]
[]
[null,"Working:",null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Lighting Data Collection'!#REF!,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"Existing LED % of Lighting"]
[]
[null,null,null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Lighting Data Collection'!B41,#REF!,0))/12","v":{"$error":"#REF!"}},null,null,"All Lighting must add to 100%"]
[]
[null,null,null,null,null,null,{"$f":"IF(OR(C43=\"Not Listed\",LEFT(C47,6)=\"Custom\"),\"Custom\",IF(C47=\"\",\"\",C47))","v":""}]
[null,null,null,null,null,null,false]
[null,"Notes:"]
[]
[]
[]
[{"$f":"A38+1","v":4}]
[null,"Lighting Type:",null,null,null,null,null,null,"Existing Incandescent % of Lighting"]
[]
[null,"Location:",null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Lighting Data Collection'!B56,#REF!,0))","v":{"$error":"#REF!"}},null,"Existing CFL % of Lighting"]
[]
[null,"Working:",null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Lighting Data Collection'!#REF!,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"Existing LED % of Lighting"]
[]
[null,null,null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Lighting Data Collection'!B56,#REF!,0))/12","v":{"$error":"#REF!"}},null,null,"All Lighting must add to 100%"]
[]
[]
[]
[null,"Notes:"]
[]
[]
[]
[{"$f":"A53+1","v":5}]
[null,"Lighting Type:",null,null,null,null,null,null,"Existing Incandescent % of Lighting"]
[]
[null,"Location:",null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Lighting Data Collection'!B71,#REF!,0))","v":{"$error":"#REF!"}},null,"Existing CFL % of Lighting"]
[]
[null,"Working:",null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Lighting Data Collection'!#REF!,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"Existing LED % of Lighting"]
[]
[null,null,null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Lighting Data Collection'!B71,#REF!,0))/12","v":{"$error":"#REF!"}},null,null,"All Lighting must add to 100%"]
[]
[null,null,null,null,null,null,{"$f":"IF(OR(C73=\"Not Listed\",LEFT(C77,6)=\"Custom\"),\"Custom\",IF(C77=\"\",\"\",C77))","v":""}]
[null,null,null,null,null,null,false]
[null,"Notes:"]
[]
[]
[]
[{"$f":"A68+1","v":6}]
[null,"Lighting Type:",null,null,null,null,null,null,"Existing Incandescent % of Lighting"]
[]
[null,"Location:",null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Lighting Data Collection'!B86,#REF!,0))","v":{"$error":"#REF!"}},null,"Existing CFL % of Lighting"]
[]
[null,"Working:",null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Lighting Data Collection'!#REF!,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"Existing LED % of Lighting"]
[]
[null,null,null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Lighting Data Collection'!B86,#REF!,0))/12","v":{"$error":"#REF!"}},null,null,"All Lighting must add to 100%"]
[]
[]
[]
[null,"Notes:"]
[]
[]
[]
[{"$f":"A83+1","v":7}]
[null,"Lighting Type:",null,null,null,null,null,null,"Existing Incandescent % of Lighting"]
[]
[null,"Location:",null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Lighting Data Collection'!B101,#REF!,0))","v":{"$error":"#REF!"}},null,"Existing CFL % of Lighting"]
[]
[null,"Working:",null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Lighting Data Collection'!#REF!,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"Existing LED % of Lighting"]
[]
[null,null,null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Lighting Data Collection'!B101,#REF!,0))/12","v":{"$error":"#REF!"}},null,null,"All Lighting must add to 100%"]
[]
[null,null,null,null,null,null,{"$f":"IF(OR(C103=\"Not Listed\",LEFT(C107,6)=\"Custom\"),\"Custom\",IF(C107=\"\",\"\",C107))","v":""}]
[null,null,null,null,null,null,false]
[null,"Notes:"]
[]
[]
[]
[{"$f":"A98+1","v":8}]
[null,"Lighting Type:",null,null,null,null,null,null,"Existing Incandescent % of Lighting"]
[]
[null,"Location:",null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Lighting Data Collection'!B116,#REF!,0))","v":{"$error":"#REF!"}},null,"Existing CFL % of Lighting"]
[]
[null,"Working:",null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Lighting Data Collection'!#REF!,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"Existing LED % of Lighting"]
[]
[null,null,null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Lighting Data Collection'!B116,#REF!,0))/12","v":{"$error":"#REF!"}},null,null,"All Lighting must add to 100%"]
[]
[null,null,null,null,null,null,{"$f":"IF(OR(C118=\"Not Listed\",LEFT(C122,6)=\"Custom\"),\"Custom\",IF(C122=\"\",\"\",C122))","v":""}]
[null,null,null,null,null,null,true]
[null,"Notes:"]
[]
[]
[]
[{"$f":"A113+1","v":9}]
[null,"Lighting Type:",null,null,null,null,null,null,"Existing Incandescent % of Lighting"]
[]
[null,"Location:",null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Lighting Data Collection'!B131,#REF!,0))","v":{"$error":"#REF!"}},null,"Existing CFL % of Lighting"]
[]
[null,"Working:",null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Lighting Data Collection'!#REF!,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"Existing LED % of Lighting"]
[]
[null,null,null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Lighting Data Collection'!B131,#REF!,0))/12","v":{"$error":"#REF!"}},null,null,"All Lighting must add to 100%"]
[]
[null,null,null,null,null,null,{"$f":"IF(OR(C133=\"Not Listed\",LEFT(C137,6)=\"Custom\"),\"Custom\",IF(C137=\"\",\"\",C137))","v":""}]
[null,null,null,null,null,null,false]
[null,"Notes:"]
[]
[]
[]
[{"$f":"A128+1","v":10}]
[null,"Lighting Type:",null,null,null,null,null,null,"Existing Incandescent % of Lighting"]
[]
[null,"Location:",null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Lighting Data Collection'!B146,#REF!,0))","v":{"$error":"#REF!"}},null,"Existing CFL % of Lighting"]
[]
[null,"Working:",null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Lighting Data Collection'!#REF!,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"Existing LED % of Lighting"]
[]
[null,null,null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Lighting Data Collection'!B146,#REF!,0))/12","v":{"$error":"#REF!"}},null,null,"All Lighting must add to 100%"]
[]
[]
[null,null,null,null,null,null,false]
[null,"Notes:"]

{"sheet":"HEA_References","index":13,"n_rows":240,"n_cols":11,"rows_kept":240,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,null,null,"Home Data "]
[null,"Domestic Hot Water",null,null,null,null,null,"Rate Code"]
[null,null,null,null,null,null,null,180]
[null,"Heating Source",null,"Heating Source",null,null,null,380]
[null,"Gas",null,"Yes",null,null,null,580]
[null,"Oil",null,"No",null,null,null,880]
[null,"Electric",null,"N/A",null,null,null,"N/A"]
[null,"Propane"]
[null,"Wood",null,null,null,null,null,"Orientation",null,null,"Existing Electrical Panel - Main Breaker Sizes"]
[null,"Other",null,null,null,null,null,"North",null,null,"Less than 60 amps"]
[null,"N/A",null,null,null,null,null,"Northeast",null,null,60]
[null,null,null,null,null,null,null,"Northwest",null,null,100]
[null,"System Type",null,null,null,null,null,"South",null,null,125]
[null,"Standard",null,null,null,null,null,"Southeast",null,null,150]
[null,"Indirect",null,null,null,null,null,"Southwest",null,null,200]
[null,"Coil",null,null,null,null,null,"East"]
[null,"On Demand",null,null,null,null,null,"West"]
[null,"Heat Pump DHW",null,null,null,null,null,"N/A"]
[null,"N/A"]
[null,null,null,null,null,null,null,"Foundation Type"]
[null,"Location",null,null,null,null,null,"Basement"]
[null,"Conditioned Space",null,null,null,null,null,"Crawl Space"]
[null,"Unconditioned Space",null,null,null,null,null,"Slab"]
[null,"N/A",null,null,null,null,null,"Combination"]
[null,null,null,null,null,null,null,"N/A"]
[]
[null,"Age"]
[null,"< 5"]
[null,"5-15"]
[null,"> 15"]
[null,"N/A"]
[]
[]
[]
[]
[]
[]
[null,"HVAC "]
[]
[null,"System Type",null,"Location"]
[null,"Heating",null,"Dining Room"]
[null,"Cooling",null,"Family Room"]
[null,null,null,"Living Room"]
[null,null,null,"Bedroom"]
[null,"Age",null,"Bathroom"]
[null,"< 5",null,"Hallway"]
[null,"5-15",null,"Kitchen"]
[null,"> 15",null,"Basement"]
[null,"N/A",null,"Attic"]
[null,null,null,"Garage"]
[null,"Heating Source",null,"Office"]
[null,"Gas",null,"Other"]
[null,"Oil",null,"N/A"]
[null,"Electric"]
[null,"Propane"]
[null,"Wood"]
[null,"Other"]
[null,"N/A"]
[]
[]
[]
[null,"Heating Equipment Type"]
[null,"Boiler"]
[null,"Steam"]
[null,"FHA"]
[null,"Geothermal"]
[null,"Electric Resistance Baseboard"]
[null,"Air Source Heat Pump"]
[null,"N/A"]
[]
[]
[null,"Cooling Equipment Type "]
[null,"Central AC"]
[null,"Mini-Split"]
[null,"Window AC"]
[null,"Through the Wall AC"]
[null,"Air Source Heat Pump"]
[null,"N/A"]
[]
[]
[]
[]
[]
[null,"Lighting and Appliances"]
[]
[null,"Appliances",null,"Appliance_Location",null,"Age",null,"Lighting Quantity"]
[null,"Clothes Dryer (Heat Pump)",null,"Kitchen",null,"< 5",null,1]
[null,"Clothes Dryer (Electric)",null,"Basement",null,"5-15",null,2]
[null,"Clothes Washer",null,"Laundry Room",null,"> 15",null,3]
[null,"Dishwasher",null,"Attic",null,"N/A",null,4]
[null,"Electric Freezer",null,"Garage",null,null,null,5]
[null,"Heat Pump Water Heater",null,"Outdoor Pool",null,null,null,6]
[null,"Tankless Water Heater",null,"Indoor Pool",null,null,null,7]
[null,"Pool Pump",null,"Other",null,null,null,8]
[null,"Pool Heater",null,"N/A",null,null,null,9]
[null,"Pool Cover",null,null,null,null,null,10]
[null,"Oven",null,null,null,null,null,"N/A"]
[null,"Range"]
[null,"Refrigerator"]
[null,"Refrigerator 2",null,"% of Home LED Lighting",null,"Lighting_Location",null,"Fuel Source"]
[null,"N/A",null,"Under 20",null,"Dining Room",null,"Gas"]
[null,null,null,"20-30",null,"Family Room",null,"Oil"]
[null,null,null,"30-40",null,"Living Room",null,"Electric"]
[null,null,null,"40-50",null,"Bedroom",null,"Propane"]
[null,"Lighting",null,"50-60",null,"Bathroom",null,"Other"]
[null,"Incandescent",null,"60-70",null,"Hallway",null,"N/A"]
[null,"Halogen",null,"70-80",null,"Kitchen"]
[null,"CFL",null,"80-90",null,"Basement"]
[null,"Flourescent",null,100,null,"Attic"]
[null,"LED",null,"N/A",null,"Garage"]
[null,"N/A",null,null,null,"Office"]
[null,null,null,null,null,"Other"]
[null,null,null,null,null,"N/A"]
[]
[]
[]
[null,"Thermostats and Controls"]
[]
[null,"Cooling Thermostat Type",null,"Location"]
[null,"Programmable",null,"Dining Room"]
[null,"Learning",null,"Family Room"]
[null,"Smart Wi-Fi",null,"Living Room"]
[null,"Not Applicable ",null,"Bedroom"]
[null,"N/A",null,"Bathroom"]
[null,null,null,"Hallway"]
[null,null,null,"Kitchen"]
[null,null,null,"Basement"]
[null,null,null,"Attic"]
[null,null,null,"Garage"]
[null,null,null,"Office"]
[null,null,null,"Other"]
[null,null,null,"N/A"]
[]
[]
[]
[]
[null,"Air Sealing "]
[]
[]
[null,"Location"]
[null,"Dining Room"]
[null,"Family Room"]
[null,"Living Room"]
[null,"Bedroom"]
[null,"Bathroom"]
[null,"Hallway"]
[null,"Kitchen"]
[null,"Basement"]
[null,"Attic"]
[null,"Garage"]
[null,"Office"]
[null,"Other"]
[]
[]
[]
[null,"Insulation Levels"]
[]
[null,"Location",null,"Condition",null,"R Value "]
[null,"Exterior Walls",null,"Good",null,"R19"]
[null,"Rim Joist",null,"Fair",null,"R20"]
[null,"Foundation Walls",null,"Poor",null,"R21"]
[null,"Garage Ceiling/Overhang",null,"N/A",null,"R22"]
[null,"Attic ",null,null,null,"R23"]
[null,"Attic 2",null,null,null,"R24"]
[null,"Attic 3",null,null,null,"R25"]
[null,"Other",null,null,null,"R26"]
[null,"N/A",null,null,null,"R27"]
[null,null,null,null,null,"R28"]
[null,null,null,null,null,"R29"]
[null,null,null,null,null,"R30"]
[null,null,null,null,null,"R31"]
[null,null,null,null,null,"R32"]
[null,null,null,null,null,"R33"]
[null,null,null,null,null,"R34"]
[null,null,null,null,null,"R35"]
[null,null,null,null,null,"R36"]
[null,null,null,null,null,"R37"]
[null,null,null,null,null,"R38"]
[null,null,null,null,null,"R39"]
[null,null,null,null,null,"R40"]
[null,null,null,null,null,"R41"]
[null,null,null,null,null,"R42"]
[null,null,null,null,null,"R43"]
[null,null,null,null,null,"R44"]
[null,null,null,null,null,"R45"]
[null,null,null,null,null,"R46"]
[null,null,null,null,null,"R47"]
[null,null,null,null,null,"R48"]
[null,null,null,null,null,"R49"]
[null,null,null,null,null,"N/A"]
[]
[]
[]
[null,"Duct Sealing"]
[null,null,null,"Cooling - Primary Duct Location"]
[null,"Heating - Primary Duct Location",null,"Unconditioned Attic"]
[null,"Unconditioned Attic",null,"Unconditioned Basement"]
[null,"Unconditioned Basement",null,"Conditioned Space"]
[null,"Conditioned Space",null,"N/A"]
[null,"N/A"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Windows"]
[]
[null,null,null,"Type",null,"Frame Type",null,"Quantity",null,null,"Column1"]
[null,"Location",null,"Single Pane",null,"Vinyl",null,1,null,null,"1a: Single, Metal"]
[null,"Dining Room",null,"Double Pane",null,"Wood",null,2,null,null,"1b: Single, Metal with Thermal Break"]
[null,"Family Room",null,"Triple Pane",null,"Metal",null,3,null,null,"1c: Single, Wood"]
[null,"Living Room",null,null,null,null,null,4,null,null,"1d: Single with Storm, Metal"]
[null,"Bedroom",null,null,null,null,null,5,null,null,"1e: Single with Storm, Metal with Thermal Break"]
[null,"Bathroom",null,null,null,null,null,6,null,null,"1f: Single with Storm, Wood"]
[null,"Hallway",null,null,null,null,null,7,null,null,"2a: Double, Metal"]
[null,"Kitchen",null,null,null,null,null,8,null,null,"2b: Double, Metal with Thermal Break"]
[null,"Basement",null,null,null,null,null,9,null,null,"2c: Double, Vinyl"]
[null,"Attic",null,null,null,null,null,10,null,null,"2d: Double, Wood"]
[null,"Garage",null,null,null,null,null,null,null,null,"2e: Double Low-e, Metal with Thermal Break"]
[null,"Office",null,null,null,null,null,null,null,null,"2f: Double Low-e, Vinyl"]
[null,"Other",null,null,null,null,null,null,null,null,"2g: Double Low-e, Wood"]
[null,null,null,null,null,null,null,null,null,null,"2h: Double with Storm, Metal with Thermal Break"]
[null,null,null,null,null,null,null,null,null,null,"2i: Double with Storm, Vinyl"]
[null,null,null,null,null,null,null,null,null,null,"2j: Double with Storm, Wood"]
[null,null,null,null,null,null,null,null,null,null,"3a: Triple, Metal with Thermal Break"]
[null,"Window Insulation ",null,null,null,null,null,null,null,null,"3b: Triple, Vinyl"]
[null,"Clear",null,null,null,null,null,null,null,null,"3c: Triple, Wood"]
[null,"Low-E Argon",null,null,null,null,null,null,null,null,"3d: Triple Low-e, Metal with Thermal Break"]
[null,"Tinted",null,null,null,null,null,null,null,null,"3e: Triple Low-e, Vinyl"]
[null,null,null,null,null,null,null,null,null,null,"3f: Triple Low-e, Wood"]

{"sheet":"Appliances Data Collection","index":14,"n_rows":152,"n_cols":9,"rows_kept":152,"cut":false,"hidden":false,"merged":[[66,9,66,10],[76,2,76,12],[85,2,85,5],[83,2,83,5],[100,2,100,5],[98,2,98,5],[96,2,96,5],[6,9,6,10],[8,9,8,10],[10,9,10,10],[21,9,21,10],[23,9,23,10],[16,2,16,12],[17,2,17,12],[115,2,115,5],[6,2,6,5],[8,2,8,5],[10,2,10,5],[25,2,26,5],[31,2,31,12],[32,2,32,12],[61,2,61,12],[62,2,62,12],[47,2,47,12],[106,2,106,12],[107,2,107,12],[70,2,70,5],[81,2,81,5],[77,2,77,12],[81,9,81,10],[113,9,113,10],[91,2,91,12],[92,2,92,12],[83,9,83,10],[85,9,85,10],[96,9,96,10],[53,9,53,10],[55,9,55,10],[23,2,23,5],[21,2,21,5],[46,2,46,12],[40,9,40,10],[51,9,51,10],[55,2,55,5],[53,2,53,5],[51,2,51,5],[38,2,38,5],[36,2,36,5],[40,2,40,5],[38,9,38,10],[25,9,25,10],[36,9,36,10],[128,2,128,5],[126,2,126,5],[68,2,68,5],[66,2,66,5],[121,2,121,12],[122,2,122,12],[113,2,113,5],[111,2,111,5],[68,9,68,10],[70,9,70,10],[98,9,98,10],[100,9,100,10],[111,9,111,10],[115,9,115,10],[126,9,126,10],[128,9,128,10],[152,2,152,12],[130,2,130,5],[143,9,143,10],[141,9,141,10],[137,2,137,12],[145,9,145,10],[151,2,151,12],[145,2,145,5],[143,2,143,5],[141,2,141,5],[136,2,136,12],[130,9,130,10]]}
[{"$f":"Development!B3","v":"Home Energy Assessment"}]
[null,"Appliances"]
[]
[]
[]
[{"$f":"A3+1","v":1}]
[null,"Appliance:",null,null,null,null,null,null,"Age:"]
[]
[null,"ENERGY STAR®:",null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Appliances Data Collection'!I9,#REF!,0))","v":{"$error":"#REF!"}},null,"Working:"]
[]
[null,"Location:",null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Appliances Data Collection'!C11,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"Fuel Source:"]
[]
[null,null,null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Appliances Data Collection'!I9,#REF!,0))/12","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,{"$f":"IF(OR(C11=\"Not Listed\",LEFT(C15,6)=\"Custom\"),\"Custom\",IF(C15=\"\",\"\",C15))","v":""}]
[null,null,null,null,null,null,true]
[null,"Notes:"]
[]
[]
[]
[{"$f":"A6+1","v":2}]
[null,"Appliance:",null,null,null,null,null,null,"Age:"]
[]
[null,"ENERGY STAR®:",null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Appliances Data Collection'!I24,#REF!,0))","v":{"$error":"#REF!"}},null,"Working:"]
[]
[null,"Location:",null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Appliances Data Collection'!C26,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"Fuel Source:"]
[]
[null,null,null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Appliances Data Collection'!I24,#REF!,0))/12","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,{"$f":"IF(OR(C26=\"Not Listed\",LEFT(C30,6)=\"Custom\"),\"Custom\",IF(C30=\"\",\"\",C30))","v":""}]
[null,null,null,null,null,null,false]
[null,"Notes:"]
[]
[]
[]
[{"$f":"A21+1","v":3}]
[null,"Appliance:",null,null,null,null,null,null,"Age:"]
[]
[null,"ENERGY STAR®:",null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Appliances Data Collection'!I39,#REF!,0))","v":{"$error":"#REF!"}},null,"Working:"]
[]
[null,"Location:",null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Appliances Data Collection'!C41,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"Fuel Source:"]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"IF(OR(C41=\"Not Listed\",LEFT(C45,6)=\"Custom\"),\"Custom\",IF(C45=\"\",\"\",C45))","v":""}]
[null,null,null,null,null,null,false]
[null,"Notes:"]
[]
[]
[]
[{"$f":"A36+1","v":4}]
[null,"Appliance:",null,null,null,null,null,null,"Age:"]
[]
[null,"ENERGY STAR®:",null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Appliances Data Collection'!I54,#REF!,0))","v":{"$error":"#REF!"}},null,"Working:"]
[]
[null,"Location:",null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Appliances Data Collection'!C56,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"Fuel Source:"]
[]
[null,null,null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Appliances Data Collection'!I54,#REF!,0))/12","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,{"$f":"IF(OR(C56=\"Not Listed\",LEFT(C60,6)=\"Custom\"),\"Custom\",IF(C60=\"\",\"\",C60))","v":""}]
[null,null,null,null,null,null,false]
[null,"Notes:"]
[]
[]
[]
[{"$f":"A51+1","v":5}]
[null,"Appliance:",null,null,null,null,null,null,"Age:"]
[]
[null,"ENERGY STAR®:",null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Appliances Data Collection'!I69,#REF!,0))","v":{"$error":"#REF!"}},null,"Working:"]
[]
[null,"Location:",null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Appliances Data Collection'!C71,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"Fuel Source:"]
[]
[null,null,null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Appliances Data Collection'!I69,#REF!,0))/12","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,{"$f":"IF(OR(C71=\"Not Listed\",LEFT(C75,6)=\"Custom\"),\"Custom\",IF(C75=\"\",\"\",C75))","v":""}]
[null,null,null,null,null,null,false]
[null,"Notes:"]
[]
[]
[]
[{"$f":"A66+1","v":6}]
[null,"Appliance:",null,null,null,null,null,null,"Age:"]
[]
[null,"ENERGY STAR®:",null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Appliances Data Collection'!I84,#REF!,0))","v":{"$error":"#REF!"}},null,"Working:"]
[]
[null,"Location:",null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Appliances Data Collection'!C86,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"Fuel Source:"]
[]
[null,null,null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Appliances Data Collection'!I84,#REF!,0))/12","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,{"$f":"IF(OR(C86=\"Not Listed\",LEFT(C90,6)=\"Custom\"),\"Custom\",IF(C90=\"\",\"\",C90))","v":""}]
[null,null,null,null,null,null,false]
[null,"Notes:"]
[]
[]
[]
[{"$f":"A81+1","v":7}]
[null,"Appliance:",null,null,null,null,null,null,"Age:"]
[]
[null,"ENERGY STAR®:",null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Appliances Data Collection'!I99,#REF!,0))","v":{"$error":"#REF!"}},null,"Working:"]
[]
[null,"Location:",null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Appliances Data Collection'!C101,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"Fuel Source:"]
[]
[null,null,null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Appliances Data Collection'!I99,#REF!,0))/12","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,{"$f":"IF(OR(C101=\"Not Listed\",LEFT(C105,6)=\"Custom\"),\"Custom\",IF(C105=\"\",\"\",C105))","v":""}]
[null,null,null,null,null,null,false]
[null,"Notes:"]
[]
[]
[]
[{"$f":"A96+1","v":8}]
[null,"Appliance:",null,null,null,null,null,null,"Age:"]
[]
[null,"ENERGY STAR®:",null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Appliances Data Collection'!I114,#REF!,0))","v":{"$error":"#REF!"}},null,"Working:"]
[]
[null,"Location:",null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Appliances Data Collection'!C116,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"Fuel Source:"]
[]
[null,null,null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Appliances Data Collection'!I114,#REF!,0))/12","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,{"$f":"IF(OR(C116=\"Not Listed\",LEFT(C120,6)=\"Custom\"),\"Custom\",IF(C120=\"\",\"\",C120))","v":""}]
[null,null,null,null,null,null,true]
[null,"Notes:"]
[]
[]
[]
[{"$f":"A111+1","v":9}]
[null,"Appliance:",null,null,null,null,null,null,"Age:"]
[]
[null,"ENERGY STAR®:",null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Appliances Data Collection'!I129,#REF!,0))","v":{"$error":"#REF!"}},null,"Working:"]
[]
[null,"Location:",null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Appliances Data Collection'!C131,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"Fuel Source:"]
[]
[null,null,null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Appliances Data Collection'!I129,#REF!,0))/12","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,{"$f":"IF(OR(C131=\"Not Listed\",LEFT(C135,6)=\"Custom\"),\"Custom\",IF(C135=\"\",\"\",C135))","v":""}]
[null,null,null,null,null,null,false]
[null,"Notes:"]
[]
[]
[]
[{"$f":"A126+1","v":10}]
[null,"Appliance:",null,null,null,null,null,null,"Age:"]
[]
[null,"ENERGY STAR®:",null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Appliances Data Collection'!I144,#REF!,0))","v":{"$error":"#REF!"}},null,"Working:"]
[]
[null,"Location:",null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Appliances Data Collection'!C146,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"Fuel Source:"]
[]
[null,null,null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Appliances Data Collection'!I144,#REF!,0))/12","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,{"$f":"IF(OR(C146=\"Not Listed\",LEFT(C150,6)=\"Custom\"),\"Custom\",IF(C150=\"\",\"\",C150))","v":""}]
[null,null,null,null,null,null,false]
[null,"Notes:"]

{"sheet":"Window Data Collection","index":15,"n_rows":66,"n_cols":9,"rows_kept":66,"cut":false,"hidden":false,"merged":[[7,2,7,9],[59,2,59,3],[9,2,9,3],[11,2,11,3],[17,2,17,12],[18,2,18,12],[23,2,23,9],[25,2,25,3],[65,2,65,12],[66,2,66,12],[27,2,27,3],[43,2,43,3],[33,2,33,12],[50,2,50,12],[49,2,49,12],[34,2,34,12],[39,2,39,9],[41,2,41,3],[55,2,55,9],[57,2,57,3]]}
[{"$f":"Development!B3","v":"Home Energy Assessment"}]
[null,"Windows"]
[]
[]
[]
[null,"North Wall Windows"]
[]
[null,"Predominant Frame Type:"]
[]
[null,"Sq Ft of Windows:",null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Window Data Collection'!I10,#REF!,0))","v":{"$error":"#REF!"}},null,"ENERGY STAR®:"]
[]
[null,"Quantity:",null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Window Data Collection'!#REF!,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"U-Value:"]
[]
[null,null,null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Window Data Collection'!I10,#REF!,0))/12","v":{"$error":"#REF!"}},null,"Existing Wattage"]
[]
[null,null,null,null,null,null,{"$f":"IF(OR(#REF!=\"Not Listed\",LEFT(C16,6)=\"Custom\"),\"Custom\",IF(C16=\"\",\"\",C16))","v":{"$error":"#REF!"}},null,"Proposed Device"]
[null,null,null,null,null,null,true]
[null,"Notes:"]
[]
[]
[]
[null,"East Wall Windows"]
[]
[null,"Predominant Frame Type:"]
[]
[null,"Sq Ft of Windows:",null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Window Data Collection'!I26,#REF!,0))","v":{"$error":"#REF!"}},null,"ENERGY STAR®:"]
[]
[null,"Quantity:",null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Window Data Collection'!#REF!,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"U-Value:"]
[]
[null,null,null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Window Data Collection'!I26,#REF!,0))/12","v":{"$error":"#REF!"}},null,"Existing Wattage"]
[]
[]
[null,null,null,null,null,null,false]
[null,"Notes:"]
[]
[]
[]
[null,"South Wall Windows"]
[]
[null,"Predominant Frame Type:"]
[]
[null,"Sq Ft of Windows:",null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Window Data Collection'!I42,#REF!,0))","v":{"$error":"#REF!"}},null,"ENERGY STAR®:"]
[]
[null,"Quantity:",null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Window Data Collection'!#REF!,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"U-Value:"]
[]
[null,null,null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Window Data Collection'!I42,#REF!,0))/12","v":{"$error":"#REF!"}},null,"Existing Wattage"]
[]
[null,null,null,null,null,null,{"$f":"IF(OR(#REF!=\"Not Listed\",LEFT(C48,6)=\"Custom\"),\"Custom\",IF(C48=\"\",\"\",C48))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,false]
[null,"Notes:"]
[]
[]
[]
[null,"West Wall Windows"]
[]
[null,"Predominant Frame Type:"]
[]
[null,"Sq Ft of Windows:",null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Window Data Collection'!I58,#REF!,0))","v":{"$error":"#REF!"}},null,"ENERGY STAR®:"]
[]
[null,"Quantity:",null,null,null,null,{"$f":"_xlfn.IFNA(INDEX(#REF!,MATCH('Window Data Collection'!#REF!,#REF!,0)),\"\")","v":{"$error":"#REF!"}},null,"U-Value:"]
[]
[null,null,null,null,null,null,{"$f":"INDEX(#REF!,MATCH('Window Data Collection'!I58,#REF!,0))/12","v":{"$error":"#REF!"}},null,"Existing Wattage"]
[]
[]
[null,null,null,null,null,null,false]
[null,"Notes:"]

{"sheet":"Health&Safety_Data","index":16,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":false,"merged":[[35,2,35,12],[41,2,41,12],[19,3,19,12],[4,1,5,12],[8,5,8,7],[8,10,8,12],[9,5,9,7],[10,5,10,7],[10,11,10,12],[11,11,11,12],[12,10,12,12],[26,9,26,12],[28,2,28,12],[29,2,29,12]]}
[{"$f":"Development!B3","v":"Home Energy Assessment"}]
[null,"Health & Safety"]
[]
["Health & Safety Conditions Acknowledgement"]
[null,"The conditions indicated below were observed during the inspection process. No guarantees are made or implied that all such \nconditions have been found."]
[]
[null,"Health and Safety Conditions Found:"]
[null,null,"Furnace/Boiler not drafting",null,null,"Gas Leak, location:",null,null,null,null,"Water flooding in basement"]
[null,null,"Water Heater not drafting"]
[null,null,"High CO level in Furnace/Boiler vent",null,null,"Notified Utility Company (Provide date/time and reference numbers)"]
[null,null,"High CO level in DHW vent",null,null,null,null,null,null,null,"Infestation:"]
[null,null,"High CO level in oven/stove",null,null,"Unvented space heater",null,null,null,null,"Other:"]
[null,null,"High Ambient CO level",null,null,"Unvented dryer"]
[]
[]
[null,null,"Flue gas spilling into conditioned space might result in elevated CO levels, which could cause illness or death"]
[null,null,"Prolonged elevated CO levels could cause illness or death"]
[null,null,"Potential explosive condition may develop"]
[null,null,"Molds/mildew may develop and cause illness"]
[null,null,"Other:"]
[]
[null,"Required Actions:"]
[null,null,"Clean/Repair Furnace/Boiler vent and/or chimney",null,null,null,null,null,"Clean oven/stove"]
[null,null,"Clean/Repair Water heater vent and/or chimney",null,null,null,null,null,"Remove unvented Heater"]
[null,null,"Have Furnace/boiler serviced to reduce CO levels",null,null,null,null,null,"Have flooding in basement corrected"]
[null,null,"Have Hot Water Heater serviced to reduce CO levels",null,null,null,null,null,"Get landlord to correct condition"]
[null,null,null,null,null,null,null,null,"Other: "]
[]
[null,"Notes:"]
[]
[]
[null,"Moisture Conditions Observed (check all that apply)"]
[null,null,"Inadequate Ventilation",null,null,"Mold/Mildew",null,null,"Standing Water"]
[null,null,"Incorrect Venting",null,null,"Condensation",null,null,"Rot"]
[]
[null,"Description:"]
[]
[null,"Other H&S Conditions Observed (check all that apply)"]
[null,null,"IAQ",null,null,"Sewer",null,null,"Asbestos"]
[null,null,"Structural",null,null,"Electrical",null,null,"Vermiculite"]
[]
[null,"Description:"]

{"sheet":"Other Data Collection","index":17,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Development!B3","v":"Home Energy Assessment"}]
[null,"Other Equipment"]
[]
[]
[]
[null,"Item #","Location","Equipment Type","Description","Qty","Approx. Age (years)","Additional Information"]

{"sheet":"Cover","index":18,"n_rows":44,"n_cols":4,"rows_kept":44,"cut":false,"hidden":true,"merged":[[42,3,42,4],[43,2,43,5],[8,0,11,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
["Home Performance with ENERGY STAR\n Home Energy Assessment"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Conducted for:"]
[{"$f":"'Home Data'!C7","v":0}]
[{"$f":"'Home Data'!C9","v":0}]
[{"$f":"'Home Data'!C11","v":0}]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"'Home Data'!C20","v":"00:00:00"}]
[null,null,{"$f":"\"Assessment by:\"&\" \"&'Home Data'!C22","v":"Assessment by: "}]

{"sheet":"Executive Summary","index":19,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":true,"merged":[[5,1,5,8],[7,2,7,4],[9,2,9,4],[35,1,36,8],[16,2,16,4],[10,2,10,4],[11,2,11,4],[13,2,13,4],[14,2,14,4],[15,2,15,4],[22,0,22,1],[23,0,23,1],[24,0,24,1],[28,0,28,1],[30,0,30,1],[20,0,20,1],[20,2,20,4],[30,10,30,11],[22,2,22,4],[24,2,24,4],[28,2,28,4],[29,0,29,1],[30,2,30,4],[22,6,22,7],[24,10,24,11],[27,1,27,2],[27,3,27,5],[27,6,27,8],[27,9,27,10],[26,0,26,1],[26,2,26,4]]}
[{"$f":"Development!B3","v":"Home Energy Assessment"}]
[null,"Summary"]
[]
[]
[]
[null,"Thank you for the opportunity to visit your home! Our Home Performance with ENERGY STAR Program has performed a thorough inspection of your home to test for the overall energy performance and address any concerns you may have. This Home Energy Assessment will provide information to help you understand your energy usage as well as tips and recommendations to help you save more on your energy bill.  Be sure to take note of all the PSEG Long Island Energy Efficiency Rebates that are available to you."]
[]
[null,"Home Owner:",{"$f":"IF('Home Data'!C7=\"\",\"\",'Home Data'!C7)","v":""}]
[null,"Address:",{"$f":"IF('Home Data'!C9=\"\",\"\",'Home Data'!C9&\", \"&'Home Data'!C11)","v":""}]
[null,"E-mail:",{"$f":"IF('Home Data'!C15=\"\",\"\",'Home Data'!C15)","v":""}]
[null,"HPwES Partner:",{"$f":"IF('Home Data'!C22=\"\",\"\",'Home Data'!C22)","v":""}]
[null,"Date of Assessment:",{"$f":"IF('Home Data'!C20=\"\",\"\",'Home Data'!C20)","v":""}]
[]
[null,"Year Home Built:",{"$f":"IF('Home Data'!C28=\"\",\"\",'Home Data'!C28)","v":""}]
[null,"Number of \nOccupants:",{"$f":"IF('Home Data'!C32=\"\",\"\",'Home Data'!C32)","v":""}]
[null,"Orientation:",{"$f":"IF('Home Data'!C26=\"\",\"\",'Home Data'!C26)","v":""}]
[null,"Foundation Type:",{"$f":"IF('Home Data'!H26=\"\",\"\",'Home Data'!H26)","v":""}]
[]
[null,"I certify that the Home Energy Assessment was conducted at the address listed above. "]
[]
["Customer Account Number:\n(Print)"]
[]
["Customer Name:\n(Print)"]
[]
["Customer Email:\n(Print)",null,null,null,null,null,null,null,null,"Date:"]
[]
["Customer Signature",null,null,null,null,null,"Date:"]
[]
["Auditor Name*:\n(Print)"]
["*Auditor's Name, not Company Name"]
["Auditor Signature",null,null,null,null,null,"Date:",null,null,"Date:"]
[]
[]
[null,"PSEG Long Island website:"]
[null,"https://www.psegliny.com/en/saveenergyandmoney/homeefficiency/homeenergyassessment"]
[null,"*The U.S. Department of Energy (DOE) administers the Home Performance with ENERGY STAR and works in conjunction with the U.S. Environmental Protection Agency (EPA) to support local program sponsors. PSEG Long Island administers the HPwES Program on behalf of its sponsor, the Long Island Power Authority (LIPA)."]

{"sheet":"Health&Safety","index":20,"n_rows":42,"n_cols":17,"rows_kept":42,"cut":false,"hidden":true,"merged":[[35,4,35,17],[41,4,41,17],[4,2,5,17],[11,16,11,17],[12,15,12,17],[26,13,26,17],[28,4,28,17],[29,4,29,17],[8,8,8,10],[8,15,8,17],[9,8,9,10],[10,8,10,10],[10,16,10,17],[19,5,19,17]]}
[{"$f":"Development!B3","v":"Home Energy Assessment"}]
[null,"Health and Safety"]
[]
[null,"Health & Safety Conditions Acknowledgement"]
[null,null,"The conditions indicated below were observed during a limited inspection process. No guarantees are made or implied that all such conditions have been found."]
[]
[null,null,"Health and Safety Conditions Found:"]
[null,null,{"$f":"'Health&Safety_Data'!B8","v":0},null,"Furnace/Boiler not drafting",null,{"$f":"'Health&Safety_Data'!E8","v":0},null,"Gas Leak, location:",null,null,null,null,{"$f":"'Health&Safety_Data'!J8","v":0},null,"Water flooding in basement"]
[null,null,{"$f":"'Health&Safety_Data'!B9","v":0},null,"Water Heater not drafting",null,null,null,{"$f":"'Health&Safety_Data'!F9","v":0},null,null,null,null,null,null,{"$f":"'Health&Safety_Data'!K9","v":0}]
[null,null,{"$f":"'Health&Safety_Data'!B10","v":0},null,"High CO level in Furnace/Boiler vent",null,{"$f":"'Health&Safety_Data'!E10","v":0},null,"Notified Utility Company (Provide date/time and reference numbers)"]
[null,null,{"$f":"'Health&Safety_Data'!B11","v":0},null,"High CO level in DHW vent",null,null,null,{"$f":"'Health&Safety_Data'!F11","v":0},null,null,null,null,{"$f":"'Health&Safety_Data'!J11","v":0},null,"Infestation:",{"$f":"'Health&Safety_Data'!L11","v":0}]
[null,null,{"$f":"'Health&Safety_Data'!B12","v":0},null,"High CO level in oven/stove",null,{"$f":"'Health&Safety_Data'!E12","v":0},null,"Unvented space heater",null,null,null,null,null,null,"Other:",{"$f":"'Health&Safety_Data'!L12","v":0}]
[null,null,{"$f":"'Health&Safety_Data'!B13","v":0},null,"High Ambient CO level",null,{"$f":"'Health&Safety_Data'!E13","v":0},null,"Unvented dryer",null,null,null,null,null,null,{"$f":"'Health&Safety_Data'!K13","v":0}]
[]
[]
[null,null,{"$f":"'Health&Safety_Data'!B16","v":0},null,"Flue gas spilling into conditioned space might result in elevated CO levels, which could cause illness or death"]
[null,null,{"$f":"'Health&Safety_Data'!B17","v":0},null,"Prolonged elevated CO levels could cause illness or death"]
[null,null,{"$f":"'Health&Safety_Data'!B18","v":0},null,"Potential explosive condition may develop"]
[null,null,{"$f":"'Health&Safety_Data'!B19","v":0},null,"Molds/mildew may develop and cause illness"]
[null,null,null,null,"Other:",{"$f":"'Health&Safety_Data'!D20","v":0}]
[]
[null,null,"Required Actions:"]
[null,null,{"$f":"'Health&Safety_Data'!B23","v":0},null,"Clean/Repair Furnace/Boiler vent and/or chimney",null,null,null,null,null,{"$f":"'Health&Safety_Data'!H23","v":0},null,"Clean oven/stove"]
[null,null,{"$f":"'Health&Safety_Data'!B24","v":0},null,"Clean/Repair Water heater vent and/or chimney",null,null,null,null,null,{"$f":"'Health&Safety_Data'!H24","v":0},null,"Remove unvented Heater"]
[null,null,{"$f":"'Health&Safety_Data'!B25","v":0},null,"Have Furnace/boiler serviced to reduce CO levels",null,null,null,null,null,{"$f":"'Health&Safety_Data'!H25","v":0},null,"Have flooding in basement corrected"]
[null,null,{"$f":"'Health&Safety_Data'!B26","v":0},null,"Have Hot Water Heater serviced to reduce CO levels",null,null,null,null,null,{"$f":"'Health&Safety_Data'!H26","v":0},null,"Get landlord to correct condition"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Other: ",{"$f":"'Health&Safety_Data'!J27","v":0}]
[]
[null,null,"Notes:",null,{"$f":"'Health&Safety_Data'!C29","v":0}]
[null,null,null,null,{"$f":"'Health&Safety_Data'!C30","v":0}]
[]
[null,null,"Moisture Conditions Observed (check all that apply)"]
[null,null,{"$f":"'Health&Safety_Data'!B33","v":0},null,"Inadequate Ventilation",null,{"$f":"'Health&Safety_Data'!E33","v":0},null,"Mold/Mildew",null,{"$f":"'Health&Safety_Data'!H33","v":0},null,"Standing Water"]
[null,null,{"$f":"'Health&Safety_Data'!B34","v":0},null,"Incorrect Venting",null,{"$f":"'Health&Safety_Data'!E34","v":0},null,"Condensation",null,{"$f":"'Health&Safety_Data'!H34","v":0},null,"Rot"]
[]
[null,null,"Description:",null,{"$f":"'Health&Safety_Data'!C36","v":0}]
[]
[null,null,"Other H&S Conditions Observed (check all that apply)"]
[null,null,{"$f":"'Health&Safety_Data'!B39","v":0},null,"IAQ",null,{"$f":"'Health&Safety_Data'!E39","v":0},null,"Sewer",null,{"$f":"'Health&Safety_Data'!H39","v":0},null,"Asbestos"]
[null,null,{"$f":"'Health&Safety_Data'!B40","v":0},null,"Structural",null,{"$f":"'Health&Safety_Data'!E40","v":0},null,"Electrical",null,{"$f":"'Health&Safety_Data'!H40","v":0},null,"Vermiculite"]
[]
[null,null,"Description:",null,{"$f":"'Health&Safety_Data'!C42","v":0}]

{"sheet":"Heating and Cooling","index":21,"n_rows":42,"n_cols":14,"rows_kept":42,"cut":false,"hidden":true,"merged":[[28,2,31,13],[32,2,35,13],[37,2,38,13],[8,10,8,11],[10,8,10,13],[19,8,19,13],[10,2,10,5],[19,2,19,5],[4,3,4,7],[5,3,5,7],[6,3,6,7],[4,12,4,13],[5,12,5,13]]}
[{"$f":"Development!B3","v":"Home Energy Assessment"}]
[null,"Heating and Cooling Assessment Results"]
[]
[null,null,"Assessment Results"]
[null,null,"Customer Name:",{"$f":"IF('Home Data'!C7=\"\",\"\",'Home Data'!C7)","v":""},null,null,null,null,null,null,null,"Assessor Name:",{"$f":"IF('Home Data'!$C$22=\"\",\"\",'Home Data'!$C$22)","v":""}]
[null,null,"Customer Address:",{"$f":"IF('Home Data'!C9=\"\",\"\",'Home Data'!C9&\", \"&'Home Data'!C11)","v":""},null,null,null,null,null,null,null,"Date of Assessment:",{"$f":"IF('Home Data'!$C$20=\"\",\"\",'Home Data'!$C$20)","v":""}]
[null,null,"Customer E-mail:",{"$f":"IF('Home Data'!C15=\"\",\"\",'Home Data'!C15)","v":""}]
[]
[null,null,"Heating and Cooling Equipment"]
[]
[null,null,"Heating System 1",null,null,null,null,null,"Heating System 2"]
[null,null,"Equipment Type:",{"$f":"IF('HVAC Data Collection'!C10=\"\",\"\",'HVAC Data Collection'!C10)","v":""},"Quantity:",{"$f":"IF('HVAC Data Collection'!K8=\"\",\"\",'HVAC Data Collection'!K8)","v":""},null,null,null,null,"Equipment Type:",{"$f":"IF('HVAC Data Collection'!C29=\"\",\"\",'HVAC Data Collection'!C29)","v":""},"Quantity:",{"$f":"IF('HVAC Data Collection'!K27=\"\",\"\",'HVAC Data Collection'!K27)","v":""}]
[null,null,"Age:",{"$f":"IF('HVAC Data Collection'!C12=\"\",\"\",'HVAC Data Collection'!C12)","v":""},"Working:",{"$f":"IF('HVAC Data Collection'!K10=\"\",\"\",'HVAC Data Collection'!K10)","v":""},null,null,null,null,"Age:",{"$f":"IF('HVAC Data Collection'!C31=\"\",\"\",'HVAC Data Collection'!C31)","v":""},"Working:",{"$f":"IF('HVAC Data Collection'!K29=\"\",\"\",'HVAC Data Collection'!K29)","v":""}]
[null,null,"Fuel Source:",{"$f":"IF('HVAC Data Collection'!C14=\"\",\"\",'HVAC Data Collection'!C14)","v":""},"% of Heating Load:",{"$f":"IF('HVAC Data Collection'!K12=\"\",\"\",'HVAC Data Collection'!K12)","v":""},null,null,null,null,"Fuel Source:",{"$f":"IF('HVAC Data Collection'!C33=\"\",\"\",'HVAC Data Collection'!C33)","v":""},"% of Heating Load:",{"$f":"IF('HVAC Data Collection'!K31=\"\",\"\",'HVAC Data Collection'!K31)","v":""}]
[null,null,"Heating Capacity:",{"$f":"IF('HVAC Data Collection'!C17=\"\",\"\",'HVAC Data Collection'!C17)","v":""},"HSPF:",{"$f":"IF('HVAC Data Collection'!K14=\"\",\"\",'HVAC Data Collection'!K14)","v":""},null,null,null,null,"Heating Capacity:",{"$f":"IF('HVAC Data Collection'!C36=\"\",\"\",'HVAC Data Collection'!C36)","v":""},"HSPF:",{"$f":"IF('HVAC Data Collection'!K33=\"\",\"\",'HVAC Data Collection'!K33)","v":""}]
[null,null,"Efficiency:",{"$f":"IF('HVAC Data Collection'!C19=\"\",\"\",'HVAC Data Collection'!C19)","v":""},null,null,null,null,null,null,"Efficiency:",{"$f":"IF('HVAC Data Collection'!C38=\"\",\"\",'HVAC Data Collection'!C38)","v":""}]
[]
[]
[]
[null,null,"Cooling System 1",null,null,null,null,null,"Cooling System 2"]
[null,null,"Equipment Type:",{"$f":"IF('HVAC Data Collection'!C49=\"\",\"\",'HVAC Data Collection'!C49)","v":""},"Quantity:",{"$f":"IF('HVAC Data Collection'!K47=\"\",\"\",'HVAC Data Collection'!K47)","v":""},null,null,null,null,"Equipment Type:",{"$f":"IF('HVAC Data Collection'!C67=\"\",\"\",'HVAC Data Collection'!C67)","v":""},"Quantity:",{"$f":"IF('HVAC Data Collection'!K65=\"\",\"\",'HVAC Data Collection'!K65)","v":""}]
[null,null,"Age:",{"$f":"IF('HVAC Data Collection'!C51=\"\",\"\",'HVAC Data Collection'!C51)","v":""},"Working:",{"$f":"IF('HVAC Data Collection'!K49=\"\",\"\",'HVAC Data Collection'!K49)","v":""},null,null,null,null,"Age:",{"$f":"IF('HVAC Data Collection'!C69=\"\",\"\",'HVAC Data Collection'!C69)","v":""},"Working:",{"$f":"IF('HVAC Data Collection'!K67=\"\",\"\",'HVAC Data Collection'!K67)","v":""}]
[null,null,"Cooling Capacity:",{"$f":"IF('HVAC Data Collection'!C54=\"\",\"\",'HVAC Data Collection'!C54)","v":""},"% of Cooling Load ",{"$f":"IF('HVAC Data Collection'!K51=\"\",\"\",'HVAC Data Collection'!K51)","v":""},null,null,null,null,"Cooling Capacity:",{"$f":"IF('HVAC Data Collection'!C72=\"\",\"\",'HVAC Data Collection'!C72)","v":""},"% of Cooling Load ",{"$f":"IF('HVAC Data Collection'!K69=\"\",\"\",'HVAC Data Collection'!K69)","v":""}]
[null,null,"SEER:",{"$f":"IF('HVAC Data Collection'!C58=\"\",\"\",'HVAC Data Collection'!C58)","v":""},null,null,null,null,null,null,"SEER:",{"$f":"IF('HVAC Data Collection'!C76=\"\",\"\",'HVAC Data Collection'!C76)","v":""}]
[null,null,"EER:",{"$f":"IF('HVAC Data Collection'!E58=\"\",\"\",'HVAC Data Collection'!E58)","v":""},null,null,null,null,null,null,"EER:",{"$f":"IF('HVAC Data Collection'!E76=\"\",\"\",'HVAC Data Collection'!E76)","v":""}]
[]
[]
[null,null,"Did you know?"]
[null,null,"An evaluation of your home's heating and cooling systems is an important component of a home energy assessment. Properly sized heating and cooling equipment is designed to provide heating and cooling, comfortably and efficiently, to a home. HVAC systems that are not selected properly are often oversized. Resultantly, oversized equipment means energy waste, short cycling, reduced equipment life, maintenance issues, air quality issues, and home discomfort. If you are interested in replacing your HVAC system(s), be sure to choose an ENERGY STAR model and have the system sized and installed by a professional. A list of participating contractors can be found on the PSEG Long Island website (see link below)."]
[]
[]
[]
[null,null,"Heat pumps are like air conditioning systems that work in reverse. During the warmer months, the heat pump is used in cooling mode and moves heat from inside the home to outside. During the cooler months, the heat pump is used in heating mode and moves heat from the outside air to inside the home. Yes. You read that correctly; Even the cold winter air contains a certain amount of heat that can be used to warm your home. Unlike typical air conditioning systems and heating systems, a heat pump can provide both heating and cooling from one single unit. From systems that require no duct work to renewable geothermal energy, you can choose the system that's right for you. Heat pumps come in a wide variety of sizes to cover the needs of most any home. There are whole-home solutions for residents, and each earns different rebates. You can choose a ducted system that utilizes your existing ductwork or a ductless system if you have baseboard heating. Heat pumps are sized and configured to specific spaces, capacity needs and comfort preferences."]
[]
[]
[]
[]
[null,null,"PSEG Long Island offers robust rebates on a variety of compact systems to fit any space. Count on PSEG Long Island to help make your energy efficiency upgrade a fast, easy, and affordable experience. For more information on Heat Pump technology and available rebates, please visit our website or contact us:"]
[]
[null,null,"Website:","https://www.psegliny.com/saveenergyandmoney/homeefficiency/homecomfort/plus"]
[null,null,"Phone:","1-800-692-2626"]
[null,null,"Email:","HomecomfortLI@pseg.com"]

{"sheet":"DHW","index":22,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":true,"merged":[[27,1,27,13],[20,1,23,12],[24,1,24,12],[4,2,4,5],[5,2,5,5],[6,2,6,5],[8,8,8,9],[10,1,10,4],[19,1,19,2],[10,7,10,12],[5,11,5,13],[4,11,4,13]]}
[{"$f":"Development!B3","v":"Home Energy Assessment"}]
[null,"Domestic Hot Water Assessment Results"]
[]
[null,"Assessment Results"]
[null,"Customer Name:",{"$f":"IF('Home Data'!C7=\"\",\"\",'Home Data'!C7)","v":""},null,null,null,null,null,null,"Assessor Name:",null,{"$f":"IF('Home Data'!$C$22=\"\",\"\",'Home Data'!$C$22)","v":""}]
[null,"Customer Address:",{"$f":"IF('Home Data'!C9=\"\",\"\",'Home Data'!C9&\", \"&'Home Data'!C11)","v":""},null,null,null,null,null,null,"Date of Assessment:",null,{"$f":"IF('Home Data'!$C$20=\"\",\"\",'Home Data'!$C$20)","v":""}]
[null,"Customer E-mail:",{"$f":"IF('Home Data'!C15=\"\",\"\",'Home Data'!C15)","v":""}]
[]
[null,"Domestic Hot Water"]
[]
[null,"Domestic Hot Water 1",null,null,null,null,null,"Domestic Hot Water 2"]
[null,"Location:",{"$f":"IF('DHW Data Collection'!C6=\"\",\"\",'DHW Data Collection'!C6)","v":""},"Fuel Source:",{"$f":"IF('DHW Data Collection'!J6=\"\",\"\",'DHW Data Collection'!J6)","v":""},null,null,null,"Location:",{"$f":"IF('DHW Data Collection'!C24=\"\",\"\",'DHW Data Collection'!C24)","v":""},null,"Fuel Source:",{"$f":"IF('DHW Data Collection'!J24=\"\",\"\",'DHW Data Collection'!J24)","v":""}]
[null,"System Type:",{"$f":"IF('DHW Data Collection'!C8=\"\",\"\",'DHW Data Collection'!C8)","v":""},"Energy Factor (EF):",{"$f":"IF('DHW Data Collection'!J8=\"\",\"\",'DHW Data Collection'!J8)","v":""},null,null,null,"System Type:",{"$f":"IF('DHW Data Collection'!C26=\"\",\"\",'DHW Data Collection'!C26)","v":""},null,"Energy Factor (EF):",{"$f":"IF('DHW Data Collection'!J26=\"\",\"\",'DHW Data Collection'!J26)","v":""}]
[null,"Age:",{"$f":"IF('DHW Data Collection'!C10=\"\",\"\",'DHW Data Collection'!C10)","v":""},"Temperature Setting:",{"$f":"IF('DHW Data Collection'!J10=\"\",\"\",'DHW Data Collection'!J10)","v":""},null,null,null,"Age:",{"$f":"IF('DHW Data Collection'!C28=\"\",\"\",'DHW Data Collection'!C28)","v":""},null,"Temperature Setting:",{"$f":"IF('DHW Data Collection'!J28=\"\",\"\",'DHW Data Collection'!J28)","v":""}]
[]
[]
[]
[]
[]
[null,"Did you know?"]
[null,"Heating water typically accounts for about 15% of a home’s energy use and high efficiency units can use 10 to 25% less energy than standard models, though your energy savings from installing high efficient ENERGY STAR systems will depend on several factors including family size, system location, and appliances. You can make some simple changes to reduce the energy consumed by your water heater by reducing the thermostat setting to 120-125°F. You can also save water and energy by installing low-flow high efficiency showerheads and faucet aerators. "]
[]
[]
[]
[null,"For more information about other Energy Conservation Measures and Water Conversation Measures, please visit our online marketplace found here:"]
[null,"www.energyfederation.org/psegliny/water-conservation-1.html"]
[]
[null,"For more information about ENERGY STAR Heat Pump Water Heaters and other available rebates, please visit our Energy Efficient Products website found here:"]
[null,"www.psegliny.com/saveenergyandmoney/energystarrebates"]

{"sheet":"Insulation Levels","index":23,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":true,"merged":[[4,9,4,12],[5,9,5,12],[36,1,36,10],[30,1,30,2],[31,1,33,10],[34,1,34,10],[4,2,4,4],[5,2,5,4],[6,2,6,4],[8,7,8,8],[24,1,24,4],[10,7,10,12],[17,7,17,12],[24,7,24,12],[10,1,10,5],[17,1,17,5]]}
[{"$f":"Development!B3","v":"Home Energy Assessment"}]
[null,"Insulation Assessment Results"]
[]
[null,"Assessment Results"]
[null,"Customer Name:",{"$f":"IF('Home Data'!C7=\"\",\"\",'Home Data'!C7)","v":""},null,null,null,null,null,"Assessor Name:",{"$f":"IF('Home Data'!$C$22=\"\",\"\",'Home Data'!$C$22)","v":""}]
[null,"Customer Address:",{"$f":"IF('Home Data'!C9=\"\",\"\",'Home Data'!C9&\", \"&'Home Data'!C11)","v":""},null,null,null,null,null,"Date of Assessment:",{"$f":"IF('Home Data'!$C$20=\"\",\"\",'Home Data'!$C$20)","v":""}]
[null,"Customer E-mail:",{"$f":"IF('Home Data'!C15=\"\",\"\",'Home Data'!C15)","v":""}]
[]
[null,"Insulation Levels"]
[]
[null,"Insulation 1",null,null,null,null,null,"Insulation 2"]
[null,"Location: ",{"$f":"IF('Insulation Levels Data Collec'!D7=\"\",\"\",'Insulation Levels Data Collec'!D7)","v":""},null,null,null,null,"Location: ",{"$f":"IF('Insulation Levels Data Collec'!D22=\"\",\"\",'Insulation Levels Data Collec'!D22)","v":""}]
[null,"Area (Sq. Ft): ",{"$f":"IF('Insulation Levels Data Collec'!D11=\"\",\"\",'Insulation Levels Data Collec'!D11)","v":""},"Existing \nR Value: ",{"$f":"IF('Insulation Levels Data Collec'!L9=\"\",\"\",'Insulation Levels Data Collec'!L9)","v":""},null,null,"Area (Sq. Ft): ",{"$f":"IF('Insulation Levels Data Collec'!D26=\"\",\"\",'Insulation Levels Data Collec'!D26)","v":""},"Existing \nR Value: ",{"$f":"IF('Insulation Levels Data Collec'!L22=\"\",\"\",'Insulation Levels Data Collec'!L22)","v":""}]
[null,"Condition: ",{"$f":"IF('Insulation Levels Data Collec'!L7=\"\",\"\",'Insulation Levels Data Collec'!L7)","v":""},"Recommended\nR Value: ",{"$f":"IF('Insulation Levels Data Collec'!L11=\"\",\"\",'Insulation Levels Data Collec'!L11)","v":""},null,null,"Condition: ",{"$f":"IF('Insulation Levels Data Collec'!L22=\"\",\"\",'Insulation Levels Data Collec'!L22)","v":""},"Recommended\nR Value: ",{"$f":"IF('Insulation Levels Data Collec'!L24=\"\",\"\",'Insulation Levels Data Collec'!L24)","v":""}]
[]
[]
[]
[null,"Insulation 3",null,null,null,null,null,"Insulation 4"]
[null,"Location: ",{"$f":"IF('Insulation Levels Data Collec'!D37=\"\",\"\",'Insulation Levels Data Collec'!D37)","v":""},null,null,null,null,"Location: ",{"$f":"IF('Insulation Levels Data Collec'!D52=\"\",\"\",'Insulation Levels Data Collec'!D52)","v":""}]
[null,"Area (Sq. Ft): ",{"$f":"IF('Insulation Levels Data Collec'!D41=\"\",\"\",'Insulation Levels Data Collec'!D41)","v":""},"Existing\nR Value: ",{"$f":"IF('Insulation Levels Data Collec'!L37=\"\",\"\",'Insulation Levels Data Collec'!L37)","v":""},null,null,"Area (Sq. Ft): ",{"$f":"IF('Insulation Levels Data Collec'!D56=\"\",\"\",'Insulation Levels Data Collec'!D56)","v":""},"Existing \nR Value: ",{"$f":"IF('Insulation Levels Data Collec'!L52=\"\",\"\",'Insulation Levels Data Collec'!L52)","v":""}]
[null,"Condition: ",{"$f":"IF('Insulation Levels Data Collec'!L37=\"\",\"\",'Insulation Levels Data Collec'!L37)","v":""},"Recommended R Value: ",{"$f":"IF('Insulation Levels Data Collec'!L39=\"\",\"\",'Insulation Levels Data Collec'!L39)","v":""},null,null,"Condition: ",{"$f":"IF('Insulation Levels Data Collec'!L52=\"\",\"\",'Insulation Levels Data Collec'!L52)","v":""},"Recommended R Value: ",{"$f":"IF('Insulation Levels Data Collec'!L54=\"\",\"\",'Insulation Levels Data Collec'!L54)","v":""}]
[]
[]
[]
[null,"Insulation 5",null,null,null,null,null,"Insulation 6"]
[null,"Location: ",{"$f":"IF('Insulation Levels Data Collec'!D67=\"\",\"\",'Insulation Levels Data Collec'!D67)","v":""},null,null,null,null,"Location: ",{"$f":"IF('Insulation Levels Data Collec'!D82=\"\",\"\",'Insulation Levels Data Collec'!D82)","v":""}]
[null,"Area (Sq. Ft): ",{"$f":"IF('Insulation Levels Data Collec'!D71=\"\",\"\",'Insulation Levels Data Collec'!D71)","v":""},"Existing\nR Value: ",{"$f":"IF('Insulation Levels Data Collec'!L67=\"\",\"\",'Insulation Levels Data Collec'!L67)","v":""},null,null,"Area (Sq. Ft): ",{"$f":"IF('Insulation Levels Data Collec'!D86=\"\",\"\",'Insulation Levels Data Collec'!D86)","v":""},"Existing \nR Value: ",{"$f":"IF('Insulation Levels Data Collec'!L82=\"\",\"\",'Insulation Levels Data Collec'!L82)","v":""}]
[null,"Condition: ",{"$f":"IF('Insulation Levels Data Collec'!L67=\"\",\"\",'Insulation Levels Data Collec'!L67)","v":""},"Recommended R Value: ",{"$f":"IF('Insulation Levels Data Collec'!L69=\"\",\"\",'Insulation Levels Data Collec'!L69)","v":""},null,null,"Condition: ",{"$f":"IF('Insulation Levels Data Collec'!L82=\"\",\"\",'Insulation Levels Data Collec'!L82)","v":""},"Recommended R Value: ",{"$f":"IF('Insulation Levels Data Collec'!L84=\"\",\"\",'Insulation Levels Data Collec'!L84)","v":""}]
[]
[]
[null,"Did you know?"]
[null,"Insulation is your primary defense against losing heating or cooling through your home’s thermal envelope (i.e. walls and roofs). It is almost always the first priority in terms of practical cost-effective improvements to a home. The effectiveness of insulation is based on its “R-Value”, the standard measure of thermal resistance. A higher R-Value results in slower heat loss/gain, lower energy bills, and a more comfortable home.  Installing the correct amount of insulation is key to reducing heating and cooling costs. "]
[]
[]
[null,"Think of insulation as a sweater for your home, and air sealing as a wind breaker. Installing these two measures together is required to receive PSEG Long Island rebates and ensures your home is operating efficiently and comfortably."]
[]
[null,"Talk to your Home Performance with ENERGY STAR Partner today to find out more about the rebates available for insulation!"]

{"sheet":"Air_Sealing ","index":24,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":true,"merged":[[4,10,4,13],[5,10,5,13],[25,1,25,12],[4,2,4,5],[5,2,5,5],[6,2,6,5],[8,8,8,9],[16,1,16,2],[12,4,12,5],[13,4,13,5],[12,11,12,12],[13,11,13,12],[11,1,11,5],[11,8,11,12],[17,1,21,12],[22,1,22,12]]}
[{"$f":"Development!B3","v":"Home Energy Assessment"}]
[null,"Air Sealing Assessment Results"]
[]
[null,"Assessment Results"]
[null,"Customer Name:",{"$f":"IF('Home Data'!C7=\"\",\"\",'Home Data'!C7)","v":""},null,null,null,null,null,null,"Assessor Name:",{"$f":"IF('Home Data'!$C$22=\"\",\"\",'Home Data'!$C$22)","v":""}]
[null,"Customer Address:",{"$f":"IF('Home Data'!C9=\"\",\"\",'Home Data'!C9&\", \"&'Home Data'!C11)","v":""},null,null,null,null,null,null,"Date of Assessment:",{"$f":"IF('Home Data'!$C$20=\"\",\"\",'Home Data'!$C$20)","v":""}]
[null,"Customer E-mail:",{"$f":"IF('Home Data'!C15=\"\",\"\",'Home Data'!C15)","v":""}]
[]
[null,"Air Sealing"]
[]
[]
[null,"Air Sealing 1",null,null,null,null,null,null,"Air Sealing 2"]
[null,"Square Footage:",{"$f":"IF('Air Sealing Data Collection'!C6=\"\",\"\",'Air Sealing Data Collection'!C6)","v":""},"Calculated BAS - CFM50: ",{"$f":"IF('Air Sealing Data Collection'!C10=\"\",\"\",'Air Sealing Data Collection'!C10)","v":""},null,null,null,"Square Footage:",{"$f":"IF('Air Sealing Data Collection'!C24=\"\",\"\",'Air Sealing Data Collection'!C24)","v":""},"Calculated BAS - CFM50: ",{"$f":"IF('Air Sealing Data Collection'!C28=\"\",\"\",'Air Sealing Data Collection'!C28)","v":""}]
[null,"Conditioned Air Volume",{"$f":"IF('Air Sealing Data Collection'!C8=\"\",\"\",'Air Sealing Data Collection'!C8)","v":""},"Blower Door Reading - CFM50 Pre:",{"$f":"IF('Air Sealing Data Collection'!J6=\"\",\"\",'Air Sealing Data Collection'!J6)","v":""},null,null,null,"Conditioned Air Volume",{"$f":"IF('Air Sealing Data Collection'!C26=\"\",\"\",'Air Sealing Data Collection'!C26)","v":""},"Blower Door Reading - CFM50 Pre:",{"$f":"IF('Air Sealing Data Collection'!J24=\"\",\"\",'Air Sealing Data Collection'!J24)","v":""}]
[]
[]
[null,"Did you know?"]
[null,"Air sealing is the next defense against heat loss/gain through the leaks in the envelope of the home. A home that is both tight and well ventilated provides the best comfort and energy efficiency. Air sealing improvements can greatly benefit a home, and a ventilation strategy will keep both the building and its occupants healthy and safe. Our partner measured your current building leakage and the minimum airflow standard to be sure that you get enough fresh air if you decide to follow through with implementing weatherization improvements."]
[]
[]
[]
[]
[null,"For more information about measures to help your home with ventilation and sealing improvements, please visit our Energy Efficient Products website to discover available appliance rebates:"]
[null,"www.psegliny.com/saveenergyandmoney/energystarrebates"]
[]
[null,"Talk to your Home Performance with ENERGY STAR Partner today to find out more about the rebates available for Air Sealing! PSEG Long Island also offers rebates for Windows. Please ask your Home Performance Partner for more information."]

{"sheet":"Duct Sealing","index":25,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":true,"merged":[[24,1,25,11],[17,1,17,4],[8,8,8,9],[23,1,23,2],[4,2,4,5],[5,2,5,5],[6,2,6,5],[10,1,10,5],[10,8,10,12],[17,8,17,12],[5,10,5,12],[4,10,4,12]]}
[{"$f":"Development!B3","v":"Home Energy Assessment"}]
[null,"Duct Sealing Assessment Results"]
[]
[null,"Assessment Results"]
[null,"Customer Name:",{"$f":"IF('Home Data'!C7=\"\",\"\",'Home Data'!C7)","v":""},null,null,null,null,null,null,"Assessor Name:",{"$f":"IF('Home Data'!$C$22=\"\",\"\",'Home Data'!$C$22)","v":""}]
[null,"Customer Address:",{"$f":"IF('Home Data'!C9=\"\",\"\",'Home Data'!C9&\", \"&'Home Data'!C11)","v":""},null,null,null,null,null,null,"Date of Assessment:",{"$f":"IF('Home Data'!$C$20=\"\",\"\",'Home Data'!$C$20)","v":""}]
[null,"Customer E-mail:",{"$f":"IF('Home Data'!C15=\"\",\"\",'Home Data'!C15)","v":""}]
[]
[null,"Duct Sealing"]
[]
[null,"Heating System 1",null,null,null,null,null,null,"Heating System 2"]
[null,"Primary Duct\nLocation: ",{"$f":"IF('Duct Sealing Data Collection'!C7=\"\",\"\",'Duct Sealing Data Collection'!C7)","v":""},null,null,null,null,null,"Primary Duct \nLocation: ",{"$f":"IF('Duct Sealing Data Collection'!C23=\"\",\"\",'Duct Sealing Data Collection'!C23)","v":""}]
[null,"Existing Ductwork Insulation: ",{"$f":"IF('Duct Sealing Data Collection'!C9=\"\",\"\",'Duct Sealing Data Collection'!C9)","v":""},"Total Ductwork Length(ft):",{"$f":"IF('Duct Sealing Data Collection'!J7=\"\",\"\",'Duct Sealing Data Collection'!J7)","v":""},null,null,null,"Existing Ductwork\n Insulation: ",{"$f":"IF('Duct Sealing Data Collection'!C25=\"\",\"\",'Duct Sealing Data Collection'!C25)","v":""},"Total Ductwork Length(ft):",{"$f":"IF('Duct Sealing Data Collection'!J23=\"\",\"\",'Duct Sealing Data Collection'!J23)","v":""}]
[null,"Existing Ductwork Sealed: ",{"$f":"IF('Duct Sealing Data Collection'!C11=\"\",\"\",'Duct Sealing Data Collection'!C11)","v":""},"Length of Ductwork(ft):",{"$f":"IF('Duct Sealing Data Collection'!J9=\"\",\"\",'Duct Sealing Data Collection'!J9)","v":""},null,null,null,"Existing Ductwork Sealed: ",{"$f":"IF('Duct Sealing Data Collection'!C27=\"\",\"\",'Duct Sealing Data Collection'!C27)","v":""},"Length of Ductwork(ft):",{"$f":"IF('Duct Sealing Data Collection'!J25=\"\",\"\",'Duct Sealing Data Collection'!J25)","v":""}]
[]
[]
[]
[null,"Cooling System 1",null,null,null,null,null,null,"Cooling  System  2"]
[null,"Primary Duct\nLocation: ",{"$f":"IF('Duct Sealing Data Collection'!C39=\"\",\"\",'Duct Sealing Data Collection'!C39)","v":""},null,null,null,null,null,"Primary Duct \nLocation: ",{"$f":"IF('Duct Sealing Data Collection'!C55=\"\",\"\",'Duct Sealing Data Collection'!C55)","v":""}]
[null,"Existing Ductwork Insulation: ",{"$f":"IF('Duct Sealing Data Collection'!C41=\"\",\"\",'Duct Sealing Data Collection'!C41)","v":""},"Total Ductwork Length(ft): ",{"$f":"IF('Duct Sealing Data Collection'!J39=\"\",\"\",'Duct Sealing Data Collection'!J39)","v":""},null,null,null,"Existing Ductwork Insulation: ",{"$f":"IF('Duct Sealing Data Collection'!C57=\"\",\"\",'Duct Sealing Data Collection'!C57)","v":""},"Total Ductwork Length(ft): ",{"$f":"IF('Duct Sealing Data Collection'!J55=\"\",\"\",'Duct Sealing Data Collection'!J55)","v":""}]
[null,"Existing Ductwork Sealed: ",{"$f":"IF('Duct Sealing Data Collection'!C43=\"\",\"\",'Duct Sealing Data Collection'!C43)","v":""},"Length of Ductwork(ft): ",{"$f":"IF('Duct Sealing Data Collection'!J41=\"\",\"\",'Duct Sealing Data Collection'!J41)","v":""},null,null,null,"Existing Ductwork Sealed: ",{"$f":"IF('Duct Sealing Data Collection'!C59=\"\",\"\",'Duct Sealing Data Collection'!C59)","v":""},"Length of Ductwork(ft): ",{"$f":"IF('Duct Sealing Data Collection'!J57=\"\",\"\",'Duct Sealing Data Collection'!J57)","v":""}]
[]
[]
[null,"Did you know?"]
[null,"In homes with forced hot air heating or cooling systems, ductwork is used to distribute air throughout the home. In a typical home, about 20% of air that moves through the ductwork is lost due to leaks and poorly sealed connections.  The result is higher utility bills and difficulty keeping your house comfortable. Exposed ductwork in unconditioned areas like attics, basements, crawlspaces and garages should be repaired with duct sealant. In addition, insulating these ducts that run through unconditioned spaces that get hot in the summer and cold in the winter can save significant energy as well."]
[]
[null,"Talk to your Home Performance with ENERGY STAR Partner today to find out more about the rebates available for Duct Sealing!"]

{"sheet":"Thermostats and Controls","index":26,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":true,"merged":[[29,1,29,3],[27,1,27,9],[28,1,28,10],[18,1,19,10],[22,1,23,10],[24,1,26,10],[20,2,21,10],[8,7,8,8],[10,1,10,4],[17,1,17,2],[4,2,4,4],[5,2,5,4],[6,2,6,4],[10,7,10,11],[4,9,4,11],[5,9,5,11]]}
[{"$f":"Development!B3","v":"Home Energy Assessment"}]
[null,"Thermostats and Controls Assessment Results"]
[]
[null,"Assessment Results"]
[null,"Customer Name:",{"$f":"IF('Home Data'!C7=\"\",\"\",'Home Data'!C7)","v":""},null,null,null,null,null,"Assessor Name:",{"$f":"IF('Home Data'!$C$22=\"\",\"\",'Home Data'!$C$22)","v":""}]
[null,"Customer Address:",{"$f":"IF('Home Data'!C9=\"\",\"\",'Home Data'!C9&\", \"&'Home Data'!C11)","v":""},null,null,null,null,null,"Date of Assessment:",{"$f":"IF('Home Data'!$C$20=\"\",\"\",'Home Data'!$C$20)","v":""}]
[null,"Customer E-mail:",{"$f":"IF('Home Data'!C15=\"\",\"\",'Home Data'!C15)","v":""}]
[]
[null,"Thermostats and Controls"]
[]
[null,"Thermostats and Controls 1",null,null,null,null,null,"Thermostats and Controls 2"]
[null,"Location:",{"$f":"IF('Thermostats and Controls Data '!C6=\"\",\"\",'Thermostats and Controls Data '!C6)","v":""},"\nThermostat Type: ",{"$f":"IF('Thermostats and Controls Data '!J6=\"\",\"\",'Thermostats and Controls Data '!J6)","v":""},null,null,"Location: ",{"$f":"IF('Thermostats and Controls Data '!C24=\"\",\"\",'Thermostats and Controls Data '!C24)","v":""},"\nThermostat Type: ",{"$f":"IF('Thermostats and Controls Data '!J24=\"\",\"\",'Thermostats and Controls Data '!J24)","v":""}]
[null,"Heating Set \nPoint - High: ",{"$f":"IF('Thermostats and Controls Data '!C8=\"\",\"\",'Thermostats and Controls Data '!C8)","v":""},"Cooling Set \nPoint - High: ",{"$f":"IF('Thermostats and Controls Data '!J8=\"\",\"\",'Thermostats and Controls Data '!J8)","v":""},null,null,"Heating Set \nPoint - High: ",{"$f":"IF('Thermostats and Controls Data '!C26=\"\",\"\",'Thermostats and Controls Data '!C26)","v":""},"Cooling Set \nPoint - High: ",{"$f":"IF('Thermostats and Controls Data '!J26=\"\",\"\",'Thermostats and Controls Data '!J26)","v":""}]
[null,"Heating Set \nPoint - Low: ",{"$f":"IF('Thermostats and Controls Data '!C10=\"\",\"\",'Thermostats and Controls Data '!C10)","v":""},"Cooling Set \nPoint - Low: ",{"$f":"IF('Thermostats and Controls Data '!J10=\"\",\"\",'Thermostats and Controls Data '!J10)","v":""},null,null,"Heating Set \nPoint - Low: ",{"$f":"IF('Thermostats and Controls Data '!C28=\"\",\"\",'Thermostats and Controls Data '!C28)","v":""},"Cooling Set \nPoint - Low: ",{"$f":"IF('Thermostats and Controls Data '!J28=\"\",\"\",'Thermostats and Controls Data '!J28)","v":""}]
[]
[]
[]
[null,"Did you know?"]
[null,"A smart thermostat is a Wi-Fi enabled device that automatically adjusts heating and cooling temperatures in your home for optimal performance. While system designs may vary, common smart thermostat features include:"]
[]
[null,null,"•\t    Ability to learn your temperature preferences and establish a schedule that automatically adjusts to energy-saving temperatures                                                                                                 \n\n•\t    Learning Thermostats learn when you will be home or awake and make sure the house is a comfortable temperature\n\n•\t    Wi-Fi enabled thermostats allow you to control your home’s heating and cooling remotely through your smartphone\n\n•\t    ENERGY STAR certified smart thermostats quickly enter a low-power standby mode when inactive\n\n•\t    Smart thermostats provide equipment use and temperature data you can track and manage"]
[]
[null,"Choose an ENERGY STAR certified smart thermostat for your home to reduce your energy bills, enhance your comfort and control temperatures based on your preferences and lifestyle. You can receive an additional rebate if you have a central air conditioning system or air source heat pump and install a qualifying smart thermostat that allows PSEG Long Island to make minor, short-term adjustments to your system that reduce power use during periods of high demand for electricity. This can reduce strain on the electric system and save you money. In most cases, you won’t even notice adjustments to the central air conditioning system and you’ll always have ultimate control. "]
[]
[null,"Already have a smart thermostat? Join PSEG Long Island's Smart Savers Program and save money while reducing the strain on the electric system. For more information please visit:"]
[]
[]
[null,"https://www.psegliny.com/saveenergyandmoney/GreenEnergy/PeakLoad/SmartSavers"]
[null,"For more information about Smart Thermostats and available rebates, please visit our online marketplace found here:"]
[null,"http://www.energyfederation.org/psegliny/"]

{"sheet":"Lighting","index":27,"n_rows":55,"n_cols":11,"rows_kept":55,"cut":false,"hidden":true,"merged":[[54,1,55,11],[50,1,51,11],[52,1,52,11],[8,7,8,8],[4,2,4,5],[5,2,5,5],[6,2,6,5],[4,9,4,11],[5,9,5,11]]}
[{"$f":"Development!B3","v":"Home Energy Assessment"}]
[null,"Lighting Assessment Results"]
[]
[null,"Assessment Results"]
[null,"Customer Name:",{"$f":"IF('Home Data'!C7=\"\",\"\",'Home Data'!C7)","v":""},null,null,null,null,null,"Assessor Name:",{"$f":"IF('Home Data'!$C$22=\"\",\"\",'Home Data'!$C$22)","v":""}]
[null,"Customer Address:",{"$f":"IF('Home Data'!C9=\"\",\"\",'Home Data'!C9&\", \"&'Home Data'!C11)","v":""},null,null,null,null,null,"Date of Assessment:",{"$f":"IF('Home Data'!$C$20=\"\",\"\",'Home Data'!$C$20)","v":""}]
[null,"Customer E-mail:",{"$f":"IF('Home Data'!C15=\"\",\"\",'Home Data'!C15)","v":""}]
[]
[null,"Lighting "]
[]
[null,"Lighting Type:",{"$f":"IF('Lighting Data Collection'!C9=\"\",\"\",'Lighting Data Collection'!C9)","v":""},"Existing Incandescent % of Lighting:",{"$f":"IF('Lighting Data Collection'!J9=\"\",\"\",'Lighting Data Collection'!J9)","v":""},null,null,"Lighting Type:",{"$f":"IF('Lighting Data Collection'!C24=\"\",\"\",'Lighting Data Collection'!C24)","v":""},"Existing Incandescent % of Lighting:",{"$f":"IF('Lighting Data Collection'!J24=\"\",\"\",'Lighting Data Collection'!J24)","v":""}]
[null,"Location:",{"$f":"IF('Lighting Data Collection'!C11=\"\",\"\",'Lighting Data Collection'!C11)","v":""},"Existing CFL % of Lighting:",{"$f":"IF('Lighting Data Collection'!J11=\"\",\"\",'Lighting Data Collection'!J11)","v":""},null,null,"Location:",{"$f":"IF('Lighting Data Collection'!C26=\"\",\"\",'Lighting Data Collection'!C26)","v":""},"Existing CFL % of Lighting:",{"$f":"IF('Lighting Data Collection'!J26=\"\",\"\",'Lighting Data Collection'!J26)","v":""}]
[null,"Working:",{"$f":"IF('Lighting Data Collection'!C13=\"\",\"\",'Lighting Data Collection'!C13)","v":""},"Existing LED % of Lighting:",{"$f":"IF('Lighting Data Collection'!J13=\"\",\"\",'Lighting Data Collection'!J13)","v":""},null,null,"Working:",{"$f":"IF('Lighting Data Collection'!C28=\"\",\"\",'Lighting Data Collection'!C28)","v":""},"Existing LED % of Lighting:",{"$f":"IF('Lighting Data Collection'!J28=\"\",\"\",'Lighting Data Collection'!J28)","v":""}]
[]
[]
[null,"Lighting Type:",{"$f":"IF('Lighting Data Collection'!C39=\"\",\"\",'Lighting Data Collection'!C39)","v":""},"Existing Incandescent % of Lighting:",{"$f":"IF('Lighting Data Collection'!J39=\"\",\"\",'Lighting Data Collection'!J39)","v":""},null,null,"Lighting Type:",{"$f":"IF('Lighting Data Collection'!C54=\"\",\"\",'Lighting Data Collection'!C54)","v":""},"Existing Incandescent % of Lighting:",{"$f":"IF('Lighting Data Collection'!J54=\"\",\"\",'Lighting Data Collection'!J54)","v":""}]
[null,"Location:",{"$f":"IF('Lighting Data Collection'!C41=\"\",\"\",'Lighting Data Collection'!C41)","v":""},"Existing CFL % of Lighting:",{"$f":"IF('Lighting Data Collection'!J41=\"\",\"\",'Lighting Data Collection'!J41)","v":""},null,null,"Location:",{"$f":"IF('Lighting Data Collection'!C56=\"\",\"\",'Lighting Data Collection'!C56)","v":""},"Existing CFL % of Lighting:",{"$f":"IF('Lighting Data Collection'!J56=\"\",\"\",'Lighting Data Collection'!J56)","v":""}]
[null,"Working:",{"$f":"IF('Lighting Data Collection'!C43=\"\",\"\",'Lighting Data Collection'!C43)","v":""},"Existing LED % of Lighting:",{"$f":"IF('Lighting Data Collection'!J43=\"\",\"\",'Lighting Data Collection'!J43)","v":""},null,null,"Working:",{"$f":"IF('Lighting Data Collection'!C58=\"\",\"\",'Lighting Data Collection'!C58)","v":""},"Existing LED % of Lighting:",{"$f":"IF('Lighting Data Collection'!J58=\"\",\"\",'Lighting Data Collection'!J58)","v":""}]
[]
[]
[null,"Lighting Type:",{"$f":"IF('Lighting Data Collection'!C69=\"\",\"\",'Lighting Data Collection'!C69)","v":""},"Existing Incandescent % of Lighting:",{"$f":"IF('Lighting Data Collection'!J69=\"\",\"\",'Lighting Data Collection'!J69)","v":""},null,null,"Lighting Type:",{"$f":"IF('Lighting Data Collection'!C84=\"\",\"\",'Lighting Data Collection'!C84)","v":""},"Existing Incandescent % of Lighting:",{"$f":"IF('Lighting Data Collection'!J84=\"\",\"\",'Lighting Data Collection'!J84)","v":""}]
[null,"Location:",{"$f":"IF('Lighting Data Collection'!C71=\"\",\"\",'Lighting Data Collection'!C71)","v":""},"Existing CFL % of Lighting:",{"$f":"IF('Lighting Data Collection'!J71=\"\",\"\",'Lighting Data Collection'!J71)","v":""},null,null,"Location:",{"$f":"IF('Lighting Data Collection'!C86=\"\",\"\",'Lighting Data Collection'!C86)","v":""},"Existing CFL % of Lighting:",{"$f":"IF('Lighting Data Collection'!J86=\"\",\"\",'Lighting Data Collection'!J86)","v":""}]
[null,"Working:",{"$f":"IF('Lighting Data Collection'!C73=\"\",\"\",'Lighting Data Collection'!C73)","v":""},"Existing LED % of Lighting:",{"$f":"IF('Lighting Data Collection'!J73=\"\",\"\",'Lighting Data Collection'!J73)","v":""},null,null,"Working:",{"$f":"IF('Lighting Data Collection'!C88=\"\",\"\",'Lighting Data Collection'!C88)","v":""},"Existing LED % of Lighting:",{"$f":"IF('Lighting Data Collection'!J88=\"\",\"\",'Lighting Data Collection'!J88)","v":""}]
[]
[]
[null,"Lighting Type:",{"$f":"IF('Lighting Data Collection'!C99=\"\",\"\",'Lighting Data Collection'!C99)","v":""},"Existing Incandescent % of Lighting:",{"$f":"IF('Lighting Data Collection'!J99=\"\",\"\",'Lighting Data Collection'!J99)","v":""},null,null,"Lighting Type:",{"$f":"IF('Lighting Data Collection'!C114=\"\",\"\",'Lighting Data Collection'!C114)","v":""},"Existing Incandescent % of Lighting:",{"$f":"IF('Lighting Data Collection'!J114=\"\",\"\",'Lighting Data Collection'!J114)","v":""}]
[null,"Location:",{"$f":"IF('Lighting Data Collection'!C101=\"\",\"\",'Lighting Data Collection'!C101)","v":""},"Existing CFL % of Lighting:",{"$f":"IF('Lighting Data Collection'!J101=\"\",\"\",'Lighting Data Collection'!J101)","v":""},null,null,"Location:",{"$f":"IF('Lighting Data Collection'!C116=\"\",\"\",'Lighting Data Collection'!C116)","v":""},"Existing CFL % of Lighting:",{"$f":"IF('Lighting Data Collection'!J116=\"\",\"\",'Lighting Data Collection'!J116)","v":""}]
[null,"Working:",{"$f":"IF('Lighting Data Collection'!C103=\"\",\"\",'Lighting Data Collection'!C103)","v":""},"Existing LED % of Lighting:",{"$f":"IF('Lighting Data Collection'!J103=\"\",\"\",'Lighting Data Collection'!J103)","v":""},null,null,"Working:",{"$f":"IF('Lighting Data Collection'!C118=\"\",\"\",'Lighting Data Collection'!C118)","v":""},"Existing LED % of Lighting:",{"$f":"IF('Lighting Data Collection'!J118=\"\",\"\",'Lighting Data Collection'!J118)","v":""}]
[]
[]
[null,"Lighting Type:",{"$f":"IF('Lighting Data Collection'!C129=\"\",\"\",'Lighting Data Collection'!C129)","v":""},"Existing Incandescent % of Lighting:",{"$f":"IF('Lighting Data Collection'!J129=\"\",\"\",'Lighting Data Collection'!J129)","v":""},null,null,"Lighting Type:",{"$f":"IF('Lighting Data Collection'!C144=\"\",\"\",'Lighting Data Collection'!C144)","v":""},"Existing Incandescent % of Lighting:",{"$f":"IF('Lighting Data Collection'!J144=\"\",\"\",'Lighting Data Collection'!J144)","v":""}]
[null,"Location:",{"$f":"IF('Lighting Data Collection'!C131=\"\",\"\",'Lighting Data Collection'!C131)","v":""},"Existing CFL % of Lighting:",{"$f":"IF('Lighting Data Collection'!J131=\"\",\"\",'Lighting Data Collection'!J131)","v":""},null,null,"Location:",{"$f":"IF('Lighting Data Collection'!C146=\"\",\"\",'Lighting Data Collection'!C146)","v":""},"Existing CFL % of Lighting:",{"$f":"IF('Lighting Data Collection'!J146=\"\",\"\",'Lighting Data Collection'!J146)","v":""}]
[null,"Working:",{"$f":"IF('Lighting Data Collection'!C133=\"\",\"\",'Lighting Data Collection'!C133)","v":""},"Existing LED % of Lighting:",{"$f":"IF('Lighting Data Collection'!J133=\"\",\"\",'Lighting Data Collection'!J133)","v":""},null,null,"Working:",{"$f":"IF('Lighting Data Collection'!C148=\"\",\"\",'Lighting Data Collection'!C148)","v":""},"Existing LED % of Lighting:",{"$f":"IF('Lighting Data Collection'!J148=\"\",\"\",'Lighting Data Collection'!J148)","v":""}]
[]
[]
[null,"Appliance Type:",{"$f":"IF('Appliances Data Collection'!C67=\"\",\"\",'Appliances Data Collection'!C67)","v":""},"Age:",{"$f":"IF('Appliances Data Collection'!J67=\"\",\"\",'Appliances Data Collection'!J67)","v":""},null,null,"Appliance Type:",{"$f":"IF('Appliances Data Collection'!C82=\"\",\"\",'Appliances Data Collection'!C82)","v":""},"Age:",{"$f":"IF('Appliances Data Collection'!J82=\"\",\"\",'Appliances Data Collection'!J82)","v":""}]
[null,"ENERGY STAR®:",{"$f":"IF('Appliances Data Collection'!C69=\"\",\"\",'Appliances Data Collection'!C69)","v":""},"Working:",{"$f":"IF('Appliances Data Collection'!J69=\"\",\"\",'Appliances Data Collection'!J69)","v":""},null,null,"ENERGY STAR®:",{"$f":"IF('Appliances Data Collection'!C84=\"\",\"\",'Appliances Data Collection'!C84)","v":""},"Working:",{"$f":"IF('Appliances Data Collection'!J84=\"\",\"\",'Appliances Data Collection'!J84)","v":""}]
[null,"Location:",{"$f":"IF('Appliances Data Collection'!C71=\"\",\"\",'Appliances Data Collection'!C71)","v":""},"Fuel Source:",{"$f":"IF('Appliances Data Collection'!J71=\"\",\"\",'Appliances Data Collection'!J71)","v":""},null,null,"Location:",{"$f":"IF('Appliances Data Collection'!C86=\"\",\"\",'Appliances Data Collection'!C86)","v":""},"Fuel Source:",{"$f":"IF('Appliances Data Collection'!J86=\"\",\"\",'Appliances Data Collection'!J86)","v":""}]
[]
[null,"Appliance Type:",{"$f":"IF('Appliances Data Collection'!C97=\"\",\"\",'Appliances Data Collection'!C97)","v":""},"Age:",{"$f":"IF('Appliances Data Collection'!J97=\"\",\"\",'Appliances Data Collection'!J97)","v":""},null,null,"Appliance Type:",{"$f":"IF('Appliances Data Collection'!C112=\"\",\"\",'Appliances Data Collection'!C112)","v":""},"Age:",{"$f":"IF('Appliances Data Collection'!J112=\"\",\"\",'Appliances Data Collection'!J112)","v":""}]
[null,"ENERGY STAR®:",{"$f":"IF('Appliances Data Collection'!C99=\"\",\"\",'Appliances Data Collection'!C99)","v":""},"Working:",{"$f":"IF('Appliances Data Collection'!J99=\"\",\"\",'Appliances Data Collection'!J99)","v":""},null,null,"ENERGY STAR®:",{"$f":"IF('Appliances Data Collection'!C114=\"\",\"\",'Appliances Data Collection'!C114)","v":""},"Working:",{"$f":"IF('Appliances Data Collection'!J114=\"\",\"\",'Appliances Data Collection'!J114)","v":""}]
[null,"Location:",{"$f":"IF('Appliances Data Collection'!C101=\"\",\"\",'Appliances Data Collection'!C101)","v":""},"Fuel Source:",{"$f":"IF('Appliances Data Collection'!J101=\"\",\"\",'Appliances Data Collection'!J101)","v":""},null,null,"Location:",{"$f":"IF('Appliances Data Collection'!C116=\"\",\"\",'Appliances Data Collection'!C116)","v":""},"Fuel Source:",{"$f":"IF('Appliances Data Collection'!J116=\"\",\"\",'Appliances Data Collection'!J116)","v":""}]
[]
[]
[null,"Appliance Type:",{"$f":"IF('Appliances Data Collection'!C127=\"\",\"\",'Appliances Data Collection'!C127)","v":""},"Age:",{"$f":"IF('Appliances Data Collection'!J127=\"\",\"\",'Appliances Data Collection'!J127)","v":""},null,null,"Appliance Type:",{"$f":"IF('Appliances Data Collection'!C142=\"\",\"\",'Appliances Data Collection'!C142)","v":""},"Age:",{"$f":"IF('Appliances Data Collection'!J142=\"\",\"\",'Appliances Data Collection'!J142)","v":""}]
[null,"ENERGY STAR®:",{"$f":"IF('Appliances Data Collection'!C129=\"\",\"\",'Appliances Data Collection'!C129)","v":""},"Working:",{"$f":"IF('Appliances Data Collection'!J129=\"\",\"\",'Appliances Data Collection'!J129)","v":""},null,null,"ENERGY STAR®:",{"$f":"IF('Appliances Data Collection'!C144=\"\",\"\",'Appliances Data Collection'!C144)","v":""},"Working:",{"$f":"IF('Appliances Data Collection'!J144=\"\",\"\",'Appliances Data Collection'!J144)","v":""}]
[null,"Location:",{"$f":"IF('Appliances Data Collection'!C131=\"\",\"\",'Appliances Data Collection'!C131)","v":""},"Fuel Source:",{"$f":"IF('Appliances Data Collection'!J131=\"\",\"\",'Appliances Data Collection'!J131)","v":""},null,null,"Location:",{"$f":"IF('Appliances Data Collection'!C146=\"\",\"\",'Appliances Data Collection'!C146)","v":""},"Fuel Source:",{"$f":"IF('Appliances Data Collection'!J146=\"\",\"\",'Appliances Data Collection'!J146)","v":""}]
[]
[]
[null,"Did you know?"]
[null,"PSEG Long Island offers rebates for a variety of ENERGY STAR household appliances and pool equipment. The full list of available rebates and appliances/equipment can be found on our website:"]
[]
[null,"www.psegliny.com/saveenergyandmoney/energystarrebates"]
[]
[null,"ENERGY STAR LED Lighting - ENERGY STAR certified bulbs use 75% less energy than incandescent bulbs and last 10 to 25 times longer. Switching to more efficient bulbs and fixtures, like ENERGY STAR certified LEDs, is one of the easiest ways to save energy and money."]

{"sheet":"Appliances","index":28,"n_rows":45,"n_cols":11,"rows_kept":45,"cut":false,"hidden":true,"merged":[[36,1,37,10],[38,1,38,11],[40,1,41,11],[42,1,43,11],[44,1,44,11],[8,7,8,8],[4,2,4,6],[5,2,5,6],[6,2,6,6],[4,9,4,11],[5,9,5,11]]}
[{"$f":"Development!B3","v":"Home Energy Assessment"}]
[null,"Thermostats and Controls Assessment Results"]
[]
[null,"Assessment Results"]
[null,"Customer Name:",{"$f":"IF('Home Data'!C7=\"\",\"\",'Home Data'!C7)","v":""},null,null,null,null,null,"Assessor Name:",{"$f":"IF('Home Data'!$C$22=\"\",\"\",'Home Data'!$C$22)","v":""}]
[null,"Customer Address:",{"$f":"IF('Home Data'!C9=\"\",\"\",'Home Data'!C9&\", \"&'Home Data'!C11)","v":""},null,null,null,null,null,"Date of Assessment:",{"$f":"IF('Home Data'!$C$20=\"\",\"\",'Home Data'!$C$20)","v":""}]
[null,"Customer E-mail:",{"$f":"IF('Home Data'!C15=\"\",\"\",'Home Data'!C15)","v":""}]
[]
[null,"Appliances"]
[]
[null,"Appliance Type:",{"$f":"IF('Appliances Data Collection'!C7=\"\",\"\",'Appliances Data Collection'!C7)","v":""},"Age:",{"$f":"IF('Appliances Data Collection'!J7=\"\",\"\",'Appliances Data Collection'!J7)","v":""},null,null,"Appliance Type:",{"$f":"IF('Appliances Data Collection'!C22=\"\",\"\",'Appliances Data Collection'!C22)","v":""},"Age:",{"$f":"IF('Appliances Data Collection'!J22=\"\",\"\",'Appliances Data Collection'!J22)","v":""}]
[null,"ENERGY STAR:",{"$f":"IF('Appliances Data Collection'!C9=\"\",\"\",'Appliances Data Collection'!C9)","v":""},"Working:",{"$f":"IF('Appliances Data Collection'!J9=\"\",\"\",'Appliances Data Collection'!J9)","v":""},null,null,"ENERGY STAR:",{"$f":"IF('Appliances Data Collection'!C24=\"\",\"\",'Appliances Data Collection'!C24)","v":""},"Working:",{"$f":"IF('Appliances Data Collection'!J24=\"\",\"\",'Appliances Data Collection'!J24)","v":""}]
[null,"Location:",{"$f":"IF('Appliances Data Collection'!C11=\"\",\"\",'Appliances Data Collection'!C11)","v":""},"Fuel Source:",{"$f":"IF('Appliances Data Collection'!J11=\"\",\"\",'Appliances Data Collection'!J11)","v":""},null,null,"Location:",{"$f":"IF('Appliances Data Collection'!C26=\"\",\"\",'Appliances Data Collection'!C26)","v":""},"Fuel Source:",{"$f":"IF('Appliances Data Collection'!J26=\"\",\"\",'Appliances Data Collection'!J26)","v":""}]
[]
[]
[null,"Appliance Type:",{"$f":"IF('Appliances Data Collection'!C37=\"\",\"\",'Appliances Data Collection'!C37)","v":""},"Age:",{"$f":"IF('Appliances Data Collection'!J37=\"\",\"\",'Appliances Data Collection'!J37)","v":""},null,null,"Appliance Type:",{"$f":"IF('Appliances Data Collection'!C52=\"\",\"\",'Appliances Data Collection'!C52)","v":""},"Age:",{"$f":"IF('Appliances Data Collection'!J52=\"\",\"\",'Appliances Data Collection'!J52)","v":""}]
[null,"ENERGY STAR:",{"$f":"IF('Appliances Data Collection'!C39=\"\",\"\",'Appliances Data Collection'!C39)","v":""},"Working:",{"$f":"IF('Appliances Data Collection'!J39=\"\",\"\",'Appliances Data Collection'!J39)","v":""},null,null,"ENERGY STAR:",{"$f":"IF('Appliances Data Collection'!C54=\"\",\"\",'Appliances Data Collection'!C54)","v":""},"Working:",{"$f":"IF('Appliances Data Collection'!J54=\"\",\"\",'Appliances Data Collection'!J54)","v":""}]
[null,"Location:",{"$f":"IF('Appliances Data Collection'!C41=\"\",\"\",'Appliances Data Collection'!C41)","v":""},"Fuel Source:",{"$f":"IF('Appliances Data Collection'!J41=\"\",\"\",'Appliances Data Collection'!J41)","v":""},null,null,"Location:",{"$f":"IF('Appliances Data Collection'!C56=\"\",\"\",'Appliances Data Collection'!C56)","v":""},"Fuel Source:",{"$f":"IF('Appliances Data Collection'!J56=\"\",\"\",'Appliances Data Collection'!J56)","v":""}]
[]
[]
[null,"Appliance Type:",{"$f":"IF('Appliances Data Collection'!C67=\"\",\"\",'Appliances Data Collection'!C67)","v":""},"Age:",{"$f":"IF('Appliances Data Collection'!J67=\"\",\"\",'Appliances Data Collection'!J67)","v":""},null,null,"Appliance Type:",{"$f":"IF('Appliances Data Collection'!C82=\"\",\"\",'Appliances Data Collection'!C82)","v":""},"Age:",{"$f":"IF('Appliances Data Collection'!J82=\"\",\"\",'Appliances Data Collection'!J82)","v":""}]
[null,"ENERGY STAR:",{"$f":"IF('Appliances Data Collection'!C69=\"\",\"\",'Appliances Data Collection'!C69)","v":""},"Working:",{"$f":"IF('Appliances Data Collection'!J69=\"\",\"\",'Appliances Data Collection'!J69)","v":""},null,null,"ENERGY STAR:",{"$f":"IF('Appliances Data Collection'!C84=\"\",\"\",'Appliances Data Collection'!C84)","v":""},"Working:",{"$f":"IF('Appliances Data Collection'!J84=\"\",\"\",'Appliances Data Collection'!J84)","v":""}]
[null,"Location:",{"$f":"IF('Appliances Data Collection'!C71=\"\",\"\",'Appliances Data Collection'!C71)","v":""},"Fuel Source:",{"$f":"IF('Appliances Data Collection'!J71=\"\",\"\",'Appliances Data Collection'!J71)","v":""},null,null,"Location:",{"$f":"IF('Appliances Data Collection'!C86=\"\",\"\",'Appliances Data Collection'!C86)","v":""},"Fuel Source:",{"$f":"IF('Appliances Data Collection'!J86=\"\",\"\",'Appliances Data Collection'!J86)","v":""}]
[]
[]
[null,"Appliance Type:",{"$f":"IF('Appliances Data Collection'!C97=\"\",\"\",'Appliances Data Collection'!C97)","v":""},"Age:",{"$f":"IF('Appliances Data Collection'!J97=\"\",\"\",'Appliances Data Collection'!J97)","v":""},null,null,"Appliance Type:",{"$f":"IF('Appliances Data Collection'!C112=\"\",\"\",'Appliances Data Collection'!C112)","v":""},"Age:",{"$f":"IF('Appliances Data Collection'!J112=\"\",\"\",'Appliances Data Collection'!J112)","v":""}]
[null,"ENERGY STAR:",{"$f":"IF('Appliances Data Collection'!C99=\"\",\"\",'Appliances Data Collection'!C99)","v":""},"Working:",{"$f":"IF('Appliances Data Collection'!J99=\"\",\"\",'Appliances Data Collection'!J99)","v":""},null,null,"ENERGY STAR:",{"$f":"IF('Appliances Data Collection'!C114=\"\",\"\",'Appliances Data Collection'!C114)","v":""},"Working:",{"$f":"IF('Appliances Data Collection'!J114=\"\",\"\",'Appliances Data Collection'!J114)","v":""}]
[null,"Location:",{"$f":"IF('Appliances Data Collection'!C101=\"\",\"\",'Appliances Data Collection'!C101)","v":""},"Fuel Source:",{"$f":"IF('Appliances Data Collection'!J101=\"\",\"\",'Appliances Data Collection'!J101)","v":""},null,null,"Location:",{"$f":"IF('Appliances Data Collection'!C116=\"\",\"\",'Appliances Data Collection'!C116)","v":""},"Fuel Source:",{"$f":"IF('Appliances Data Collection'!J116=\"\",\"\",'Appliances Data Collection'!J116)","v":""}]
[]
[]
[null,"Appliance Type:",{"$f":"IF('Appliances Data Collection'!C127=\"\",\"\",'Appliances Data Collection'!C127)","v":""},"Age:",{"$f":"IF('Appliances Data Collection'!J127=\"\",\"\",'Appliances Data Collection'!J127)","v":""},null,null,"Appliance Type:",{"$f":"IF('Appliances Data Collection'!C142=\"\",\"\",'Appliances Data Collection'!C142)","v":""},"Age:",{"$f":"IF('Appliances Data Collection'!J142=\"\",\"\",'Appliances Data Collection'!J142)","v":""}]
[null,"ENERGY STAR:",{"$f":"IF('Appliances Data Collection'!C129=\"\",\"\",'Appliances Data Collection'!C129)","v":""},"Working:",{"$f":"IF('Appliances Data Collection'!J129=\"\",\"\",'Appliances Data Collection'!J129)","v":""},null,null,"ENERGY STAR:",{"$f":"IF('Appliances Data Collection'!C144=\"\",\"\",'Appliances Data Collection'!C144)","v":""},"Working:",{"$f":"IF('Appliances Data Collection'!J144=\"\",\"\",'Appliances Data Collection'!J144)","v":""}]
[null,"Location:",{"$f":"IF('Appliances Data Collection'!C131=\"\",\"\",'Appliances Data Collection'!C131)","v":""},"Fuel Source:",{"$f":"IF('Appliances Data Collection'!J131=\"\",\"\",'Appliances Data Collection'!J131)","v":""},null,null,"Location:",{"$f":"IF('Appliances Data Collection'!C146=\"\",\"\",'Appliances Data Collection'!C146)","v":""},"Fuel Source:",{"$f":"IF('Appliances Data Collection'!J146=\"\",\"\",'Appliances Data Collection'!J146)","v":""}]
[]
[]
[null,"Did you know?"]
[null,"PSEG Long Island offers rebates for a variety of ENERGY STAR household appliances and pool equipment. The full list of available rebates and appliances/equipment can be found on our website:"]
[]
[null,"https://www.psegliny.com/saveenergyandmoney/energystarrebates"]
[]
[null,"ENERGY STAR Appliances –  Every appliance comes with two price tags: the purchase price and the cost of operating the product. ENERGY STAR certified appliances, such as heat pump water heaters, clothes washers, and clothes dryers to help consumers save money on operating costs by reducing energy use without sacrificing performance."]
[]
[null,"Heat Pump Pool Heaters – An energy efficient heat pump pool heater can maximize your energy savings and typically last longer than gas pool heaters. Heat pump pool heaters normally have much lower operating costs because of their higher efficiencies."]
[]
[null,"Smart Strips – Eliminate phantom energy users with this savvy strip. Now you can control the power to devices automatically when the primary device (like a TV set) is off."]

{"sheet":"Windows","index":29,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":true,"merged":[[4,6,4,7],[5,6,5,7],[8,4,8,5],[31,1,31,2],[32,1,34,6],[10,1,10,3],[18,1,18,3],[10,5,10,7],[18,5,18,7]]}
[{"$f":"Development!B3","v":"Home Energy Assessment"}]
[null,"Window Assessment Results"]
[]
[null,"Assessment Results"]
[null,"Customer Name:",{"$f":"IF('Home Data'!C7=\"\",\"\",'Home Data'!C7)","v":""},null,null,"Assessor Name:",{"$f":"IF('Home Data'!$C$22=\"\",\"\",'Home Data'!$C$22)","v":""}]
[null,"Customer Address:",{"$f":"IF('Home Data'!C9=\"\",\"\",'Home Data'!C9&\", \"&'Home Data'!C11)","v":""},null,null,"Date of Assessment:",{"$f":"IF('Home Data'!$C$20=\"\",\"\",'Home Data'!$C$20)","v":""}]
[null,"Customer E-mail:",{"$f":"IF('Home Data'!C15=\"\",\"\",'Home Data'!C15)","v":""}]
[]
[null,"Windows"]
[]
[null,"North Wall Windows",null,null,null,"East Wall Windows"]
[null,"Frame Type:",{"$f":"IF('Window Data Collection'!C8=\"\",\"\",'Window Data Collection'!C8)","v":""},null,null,"Frame Type:",{"$f":"IF('Window Data Collection'!C24=\"\",\"\",'Window Data Collection'!C24)","v":""}]
[null,"Quantity:",{"$f":"IF('Window Data Collection'!C12=\"\",\"\",'Window Data Collection'!C12)","v":""},null,null,"Quantity:",{"$f":"IF('Window Data Collection'!C28=\"\",\"\",'Window Data Collection'!C28)","v":""}]
[null,"Sqft of Windows:",{"$f":"IF('Window Data Collection'!C10=\"\",\"\",'Window Data Collection'!C10)","v":""},null,null,"Sqft of Windows:",{"$f":"IF('Window Data Collection'!C26=\"\",\"\",'Window Data Collection'!C26)","v":""}]
[null,"U-Value:",{"$f":"IF('Window Data Collection'!J12=\"\",\"\",'Window Data Collection'!J12)","v":""},null,null,"U-Value:",{"$f":"IF('Window Data Collection'!J28=\"\",\"\",'Window Data Collection'!J28)","v":""}]
[null,"ENERGY STAR®:",{"$f":"IF('Window Data Collection'!J10=\"\",\"\",'Window Data Collection'!J10)","v":""},null,null,"ENERGY STAR®:",{"$f":"IF('Window Data Collection'!J26=\"\",\"\",'Window Data Collection'!J26)","v":""}]
[]
[]
[null,"South Wall Windows",null,null,null,"West Wall Windows"]
[null,"Frame Type:",{"$f":"IF('Window Data Collection'!C40=\"\",\"\",'Window Data Collection'!C40)","v":""},null,null,"Frame Type:",{"$f":"IF('Window Data Collection'!C56=\"\",\"\",'Window Data Collection'!C56)","v":""}]
[null,"Quantity:",{"$f":"IF('Window Data Collection'!C44=\"\",\"\",'Window Data Collection'!C44)","v":""},null,null,"Quantity:",{"$f":"IF('Window Data Collection'!C60=\"\",\"\",'Window Data Collection'!C60)","v":""}]
[null,"Sqft of Windows:",{"$f":"IF('Window Data Collection'!C42=\"\",\"\",'Window Data Collection'!C42)","v":""},null,null,"Sqft of Windows:",{"$f":"IF('Window Data Collection'!C58=\"\",\"\",'Window Data Collection'!C58)","v":""}]
[null,"U-Value:",{"$f":"IF('Window Data Collection'!J44=\"\",\"\",'Window Data Collection'!J44)","v":""},null,null,"U-Value:",{"$f":"IF('Window Data Collection'!J60=\"\",\"\",'Window Data Collection'!J60)","v":""}]
[null,"ENERGY STAR®:",{"$f":"IF('Window Data Collection'!J42=\"\",\"\",'Window Data Collection'!J42)","v":""},null,null,"ENERGY STAR®:",{"$f":"IF('Window Data Collection'!J58=\"\",\"\",'Window Data Collection'!J58)","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,"Did you know?"]
[null,"Windows can present weak points in the thermal boundary of your home.  If you have single pane windows you may want to consider installing storm windows or insulated double pane glass.  ENERGY STAR qualified windows demonstrate  energy performance and can save on utility bills.  Consumers should use the National Fenestration Ratings Council sticker as a resource to compare window performance with the information listed below:"]
[]
[]
[]
[null,"·       U-Factor measures the rate of heat transfer and tells you how well the window insulates"]
[]
[]
[null,"·       Solar Heat Gain Coefficient (SHGC) measures the fraction of solar energy transmitted and tells you how well the product blocks heat caused by sunlight"]
[]
[]
[null,"·       Air Leakage (AL) measures the rate at which air passes through joints in the window"]
[]
[]
[null,"·       Visible Transmittance (VT) measures the amount of light the window lets through"]