{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["READ ME FIRST","Contractor Project Information"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"READ ME FIRST","index":0,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":false,"merged":[[29,1,29,4],[7,2,7,4],[22,2,22,4],[16,2,16,4],[37,1,43,4],[4,2,4,4],[1,1,1,4],[28,2,28,4],[19,2,19,4],[25,1,26,4],[23,2,23,4],[5,1,5,4],[8,1,8,4],[9,1,9,4],[15,2,15,4],[21,2,21,4],[18,2,18,4],[20,2,20,4],[31,1,32,3],[17,2,17,4]]}
[]
[null,"HPwES Sponsor Biannual Reporting Form - READ ME FIRST                       DOE HQ F 413.30"]
[null,"Reporting Period:","2019 P2",null,"OMB Control #:  1910-5184"]
[null,"Reports Due:","2019-01-30",null,"Exp. Date:  10/31/2019"]
[null,"Section 1:","Sponsor Information"]
[null,"Please verify or update the information shown in the \"Sponsor Information\" tab if necessary. "]
[]
[null,"Section 2: ","Contractor and Project Information"]
[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. HPwES project and field inspection counts may only be retroactively adjusted for the two preceding quarters listed."]
[]
[null,"Reporting Schedule:","Covers","Report Due"]
[null,"P1","Jan.-June","July 30th "]
[null,"P2","July-Dec.","January 30th "]
[null,"Glossary"]
[null,"Program Name","A public name associated with HPwES program; note this is how your program is listed on the energystar.gov Sponsor map."]
[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,"Retroactive Adjustments","Retroactive projects completed and field inspections adjustments will only be allowed for the two preceding quarters.  "]
[null,"Inserting New HPwES Organization"]
[null,"By clicking the \"Add A New HPwES Contractor\" Button in the Contractor and Project Information sheet, a new row is added to collect the new HPwES contractor's project information."]
[]
[]
[null,"Comments","Please provide any additional comments you would like to share with the HPwES team. "]
[]
[null,"Upon Completion"]
[null,"Please click the send button. An e-mail with the biannual reporting template attached will be sent to your Account Manager. The button was tested with Outlook Express, Windows Mail, Windows Live Mail and Outlook and it may or may not work with other email clients. Alternatively you can save the quarterly form on your hard-drive and send it as an attachment to your Account Manager. "]
[]
[null,"Internal DOE Purposes"]
[null,"DOE Review:",null,"Date Reviewed:"]
[null,"Account Manager Reviewer:",null,"Date Reviewed:"]
[]
[null,"Public 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, Records Management Division, IM-23, Paperwork Reduction Project (1910-004), U.S. Department of Energy, 1000 Independence Ave SW, Washington, DC, 20585-1290; and to the Office of Management and Budget (OMB), OIRA, Paperwork Reduction Project (1910-004), Washington, DC  20503."]

{"sheet":"Contractor Project Information","index":1,"n_rows":1,"n_cols":81,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Contractor ID","Sponsor ID","iSTAR ID","Sponsor Name","Sponsor Status","Contractor","Contact First Name","Contact Last Name","Status","Email","Contact Phone","Address 1","Address 2","City","State","Zip","Org Phone","Org Fax","Website","12Q1 P","12Q1 FI","12Q2 P","12Q2 FI","12Q3 P","12Q3 FI","12Q4 P","12Q4 FI","13Q1 P","13Q1 FI","13Q2 P","13Q2 FI","13Q3 P","13Q3 FI","13Q4 P","13Q4 FI","14Q1 P","14Q1 FI","14Q2 P","14Q2 FI","14Q3 P","14Q3 FI","14Q4 P","14Q4 FI","15Q1 P","15Q1 FI","15Q2 P","15Q2 FI","15Q3 P","15Q3 FI","15Q4 P","15Q4 FI","16Q1 P","16Q1 FI","16Q2 P","16Q2 FI","16Q3 P","16Q3 FI","16Q4 P","16Q4 FI","17Q1 P","17Q1 FI","17Q2 P","17Q2 FI","17Q3 P","17Q3 FI","17Q4 P","17Q4 FI","18Q1 P","18Q1 FI","18Q2 P","18Q2 FI","18Q3 P","18Q3 FI","18Q4 P","18Q4 FI","19P1 P","19P2 FI","20P1 P","20P1 FI","20P2 P","20P2 FI"]