{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Sheet1","Drop Down Lists","Sheet 2"],"not_rendered":{"images":1,"macros":1,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":30,"n_cols":5,"rows_kept":30,"merged":[[0,0,0,3],[29,0,29,3]]}
["Expiration Date: Pending Approval"]
["United States"]
["ENVIRONMENTAL PROTECTION AGENCY"]
["Washington, D.C. 20460"]
[]
["ENERGY STAR Home Upgrade Service Provider Partner \nProject Data Collection for Calendar Year XXXX"]
["Office of Atmospheric Programs"]
[]
["This collection of information is approved by OMB under the Paperwork Reduction Act, 44 U.S.C. 3501 et seq. (OMB Control No. 2060-0528). Responses to this collection of information are voluntary (Section103(g) of the Clean Air Act). An agency may not conduct or sponsor, and a person is not required to respond to, a collection of information unless it displays a currently valid OMB control number. The public reporting and recordkeeping burden for this collection of information is estimated to be XX.X hours per response. Send comments on the Agency’s need for this information, the accuracy of the provided burden estimates and any suggested methods for minimizing respondent burden to the Regulatory Support Division Director, U.S. Environmental Protection Agency (XXXXX), 1200 Pennsylvania Ave., NW, Washington, D.C. 20460. Include the OMB control number in any correspondence. Do not send the completed form to this address."]
[]
[]
["PARTNER NAME (Per your Partnership Agreement):",{"$nulls":3},{"$f":"IF(ISBLANK(B12),\"← Partner Name incomplete\",\"\")","v":"← Partner Name incomplete"}]
[]
["SUBMITTED BY (Your name):",{"$nulls":3},{"$f":"IF(ISBLANK(B14),\"← Submitted By incomplete\",\"\")","v":"← Submitted By incomplete"}]
[]
["IMPORTANT: Please read these instructions carefully before completing this form."]
[]
["Beginning in 2025, ENERGY STAR requires project data submissions for projects completed under the ENERGY STAR Home Upgrade Service Provider Partnership. This information is used to measure the impact of the partnership, view trends in the installation of efficient products, and evaluate the overall performance of the program to create the most value for participants. Data shared to ENERGY STAR by partners helps to demonstrate the importance of ENERGY STAR in the market and the benefits created by partners. This requirement is outlined in the partner commitments referenced in the ENERGY STAR partnership agreement.  "]
[]
["Partners are required to submit 2025 calendar year project data for ENERGY STAR certified products by completing the form(s) linked to below and sending it to EPA no later than March 1, 2026. Partners must include all projects completed following the 90-day onboarding period after a partnership agreement is signed by the EPA. \nService Provider Partners are required to submit the following data listed below, whether that is providing the exact fields in the sample collection form or other fields partners already use that capture this information. Please let us know if you do not collect any of the requested information:\n\n• Census Tract Data (State Code, County Code, Tract Code left separate or combined) from output of batch address geographies. This can be found by visiting the United States Census Bureau webpage and uploading the following fields in a batch spreadsheet:   \n• Project ID (can just be 1,2,3, etc. or a company’s own unique identifier) \n• Street Address \n• City \n• State \n• Zip Code (5 digit preferred, but can use 9 digit)  \n• Installation status of the following products:  \n    o ENERGY STAR Certified Heat Pump (e.g., air-source or mini-split)  \n    o Smart Thermostat  \n    o ENERGY STAR Certified Heat Pump Water Heater  \n    o ENERGY STAR Certified Windows  \n    o Attic Sealing and Insulation  \n    o Electrical Upgrades (e.g., wiring, panel upgrades, EV chargers, solar, other smart technology)  \n• Applied rebates  \n    o Utility, state, manufacturer, distributor  \n• Financing used  \n    o Mechanism (e.g., greenbank, traditional bank, etc.)  "]
[]
["Submission Deadline: XXX, XX, XXXX"]
[]
["As stated on the form, partner companies must provide project data for all projects under an ENERGY STAR partnership completed within the United States from January 1, 2025 – December 31, 2025. Note:  \n\n• If an ENERGY STAR partnership was active for only part of the year, only count projects completed during that part of the year, following the 90 day onboarding process after an agreement is executed by the EPA. \n• To ensure no double counting occurs, do not report projects completed under another company’s partnership.  \n• If a company completed no projects within the United States in 2025, it is still required to notify the EPA via email that it has completed zero projects.  "]
[]
["Submission Deadline and Partnership Implications\n\nAs a term of partnership, the EPA collects unit and project data on an annual basis for program evaluation purposes. The EPA will release this information only as aggregated data and otherwise only to the extent required by law.  \nAs stated on the form, partner companies must provide project data for all projects under an ENERGY STAR partnership completed within the United States from January 1, 2025 – December 31, 2025. Note:  \n\n• If an ENERGY STAR partnership was active for only part of the year, only count projects completed during that part of the year, following the 90 day onboarding process after an agreement is executed by the EPA. \n• To ensure no double counting occurs, do not report projects completed under another company’s partnership.  \n• If a company completed no projects within the United States in 2025, it is still required to notify the EPA via email that it has completed zero projects.  "]
[]
["Thank you for supporting the ENERGY STAR program and for your cooperation with this important requirement. "]
[]
["EPA Form No. PFN-3400-2\nOMB Control No. 2060-0528\nAs a term of partnership, the EPA collects unit and project data on an annual basis for program evaluation purposes. The EPA will release this information only as aggregated data and otherwise only to the extent required by law.  "]

{"sheet":"Sheet1","index":1,"n_rows":2,"n_cols":28,"rows_kept":2,"merged":[[0,1,0,4],[0,5,0,7],[0,8,0,13],[0,17,0,24],[0,25,0,27]]}
[null,"Do Not Send -  Use to Find Census Tract before Sending   (Columns F-H)",{"$nulls":3},"Census Tract",null,null,"ENERGY STAR Certified Upgrades Made",{"$nulls":8},"Electrical Upgrades",{"$nulls":7},"Other Upgrades Made"]
["Project Number","Street Address","City","State","Zip Code","State Code","County Code","Tract Code","Heat Pump (Air-source or Mini-split)","Cold-Climate","Dual-fuel","Smart Thermostat","Heat Pump Water Heater","Windows","# of windows","Attic Sealing","Attic Insulation","Electrical Upgrades","New Wiring Only","Panel Upsize","Service Upgrade Needed","Same Size Panel Replacement","Other smart techonology","EV Charger Added","Solar Added","Rebates applied for","Financing","Financing Mechanism"]

{"sheet":"Drop Down Lists","index":2,"n_rows":10,"n_cols":7,"rows_kept":10}
["Drop downs"]
[{"$nulls":3},"Can choose more than One"]
["General","Windows","Panels","other tech","EV Charger","Solar","Rebates"]
["Yes","Windows","Traditional Panel","Smart Circuit","With new wiring","With Battery","Utility"]
["No","Storm Windows","Smart Panel ","Load splitter","Without new wiring ","Without Battery","State"]
["Unsure","No","No","Appliance with battery","No  ","No","Manufacturer"]
[null,"Unsure","Unsure","Meter socket adaptor","Unsure","Unsure","Distributor"]
[{"$nulls":3},"Other",null,null,"Other"]
[{"$nulls":3},"No",null,null,"No"]
[{"$nulls":3},"Unsure",null,null,"Unsure"]

{"sheet":"Sheet 2","index":3,"n_rows":9,"n_cols":2,"rows_kept":9}
[]
["By Project"]
[]
[]
[]
["Other Upgrades","Up to Standard/Code for the location"]
[]
[]
["Made in house, subcontracted, or refered (as long as project confirmed)"]