{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["READ ME FIRST","Contractor Project Information"],"not_rendered":{"macros":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"READ ME FIRST","index":0,"n_rows":24,"n_cols":5,"rows_kept":24,"merged":[[1,1,1,4],[5,1,5,4],[6,1,6,4],[7,1,7,4],[10,2,10,4],[11,2,11,4],[12,2,12,4],[13,2,13,4],[14,2,14,4],[15,2,15,4],[16,2,16,4],[17,2,17,4],[18,1,18,4],[23,1,26,4]]}
[]
[null,"HPwES Sponsor Reporting Form - READ ME FIRST                                               DOE HQ F 413.30"]
[null,"Reporting Period:","2023 First Half (January - June)",null,"OMB Control #: 1910-5184"]
[null,"Reports Due:","2023-07-29",null,"Exp. Date: 07/31/2023"]
[]
[null,"Contractor and Project Information Tab"]
[null,"A. Please update your program’s participating contractor list by deactivating contractors who are no longer participating and updating company contact information where necessary. You may also update participating contractor status for those who are on or off probationary status."]
[null,"B. Please report activity for this reporting period for each contractor.  Report only completed HPwES projects and field inspections."]
[]
[null,"Glossary"]
[null,"HPwES Contractor Contact Information","Please report only the contact information of the marketing coordinator for each HPwES Contractor. The contractor's marketing coordinator will have access to My Energy Star Account (MESA)."]
[null,"Participating Contractor Status","A drop down menu with only three possibilities: Active, Inactive, or Probation."]
[null,"Active","A fully participating contractor that should have access to MESA, Marketing Toolkit, and logos."]
[null,"Inactive","A contractor no longer participating in a local program and does not have access to MESA, Marketing Toolkit and logos."]
[null,"Probation","A contractor in-between Active and Inactive; may be due to paperwork or disciplinary action; does not have access to MESA and Marketing Toolkit."]
[null,"Completed HPwES Project","A test-in/assessment was performed, work/improvements were performed, and a test-out was performed."]
[null,"Field Inspection","A field visit by an independent inspector to assess compliance with program standards. The visit could be at any stage during the HPwES project."]
[null,"Comments","Please provide any additional comments you would like to share with the HPwES team. "]
[null," \n"]
[null,"Internal DOE Purposes"]
[null,"DOE Review:",null,"Date Reviewed:"]
[null,"Account Manager Reviewer:",null,"Date Reviewed:"]
[]
[null,"This data is being collected to determine program volume impact and calculate energy savings.  The data you supply will be used for determining metrics and potential improvements to the program.\n\nPublic reporting burden for this collection of information is estimated to average 90 minutes per response, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information.  Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden, to Office of the Chief Information Officer, Enterprise Policy Development & Implementation Office, IM-22, Information Collection Management Program 1910-5184, U.S. Department of Energy, 1000 Independence Ave SW, Washington, DC 20585; and to the Office of Management and Budget (OMB), OIRA, Paperwork Reduction Project 1910-5184, Washington, DC 20503.\n\nNotwithstanding any other provision of the law, no person is required to respond to, nor shall any person be subject to a penalty for failure to comply with a collection of information subject to the requirements of the Paperwork Reduction Act unless that collection of information displays a currently valid OMB control number. \n\nSubmission of this data is voluntary"]

{"sheet":"Contractor Project Information","index":1,"n_rows":29,"n_cols":18,"rows_kept":29}
["Relationship ID","Contractor ID","Sponsor ID","Sponsor Name","Contractor Name","Contact First Name","Contact Last Name","Contractor Status","Email","Address 1","Address 2","City","State","ZIP","Phone","Website","2022 H1 Projects","2022 H1 Field Inspections"]
["AR-001-1780",1780,"AR-001","SWEPCO"]
["AR-001-1781",1781,"AR-001","SWEPCO"]
["AR-001-1782",1782,"AR-001","SWEPCO"]
["AR-001-1783",1783,"AR-001","SWEPCO"]
["AR-001-1784",1784,"AR-001","SWEPCO"]
["AR-001-1785",1785,"AR-001","SWEPCO"]
["AR-001-1786",1786,"AR-001","SWEPCO"]
["AR-001-1787",1787,"AR-001","SWEPCO"]
["AR-001-1788",1788,"AR-001","SWEPCO"]
["AR-001-1789",1789,"AR-001","SWEPCO"]
["New Contractor","New Contractor","AR-001","SWEPCO"]
["New Contractor","New Contractor","AR-001","SWEPCO"]
["New Contractor","New Contractor","AR-001","SWEPCO"]
["New Contractor","New Contractor","AR-001","SWEPCO"]
["New Contractor","New Contractor","AR-001","SWEPCO"]
["New Contractor","New Contractor","AR-001","SWEPCO"]
["New Contractor","New Contractor","AR-001","SWEPCO"]
["New Contractor","New Contractor","AR-001","SWEPCO"]
["New Contractor","New Contractor","AR-001","SWEPCO"]
["New Contractor","New Contractor","AR-001","SWEPCO"]
["New Contractor","New Contractor","AR-001","SWEPCO"]
["New Contractor","New Contractor","AR-001","SWEPCO"]
["New Contractor","New Contractor","AR-001","SWEPCO"]
["New Contractor","New Contractor","AR-001","SWEPCO"]
["New Contractor","New Contractor","AR-001","SWEPCO"]
["New Contractor","New Contractor","AR-001","SWEPCO"]
["New Contractor","New Contractor","AR-001","SWEPCO"]
["New Contractor","New Contractor","AR-001","SWEPCO"]