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

{"sheet":"READ ME FIRST","index":0,"n_rows":46,"n_cols":4,"rows_kept":46,"merged":[[0,1,0,4],[1,1,1,4],[4,2,4,4],[5,1,5,4],[7,2,7,4],[8,1,8,4],[9,1,9,4],[17,2,17,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[22,2,22,4],[23,2,23,4],[24,2,24,4],[25,2,25,4],[26,2,26,4],[27,2,27,4],[28,2,28,4],[30,1,32,4],[35,1,36,4],[38,2,38,4],[39,1,39,4],[41,1,42,3]]}
[null,"DOE HQ F 413.30\n(05/2015)"]
[null,"HPwES Sponsor Quarterly Reporting Form - READ ME FIRST"]
[null,"Reporting Period:","2014 Q1"]
[null,"Reports Due:","2013-03-30"]
[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,"Q1","Jan.-March","April 30th "]
[null,"Q2","April-June","July 30th "]
[null,"Q3","July-Sept.","October 30th "]
[null,"Q4","Oct.-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,"Shared Projects","Reporting shared projects between participating contractors is no longer permitted. Each project completed should only have one primary contractor and should be reported as such. The primary contractor usually takes greater responsibility on the HPwES project by performing the pre-assessment and/ or the post assessment."]
[null,"Retroactive Adjustments","Retroactive projects completed and field inspections adjustments will only be allowed for the two preceding quarters.  "]
[null,null,"Indicates locked cells that are currently not editable and are only shown for reference purposes."]
[null,"Updating Locked Cells","Please contact your Account Manager with your needs to update any of the locked cells."]
[null,"Sorting Functionality"]
[null,"The Contractor and Project Information sheet can be sorted by: HPwES Organization Name, Contact First Name, Contact Last Name, Status, and City. Clicking the \"SORT\" button in columns C,D,E,F, or K at the Contractor and Project Information sheet will trigger the appropriate sorting function."]
[]
[]
[]
[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 quarterly 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:"]

{"sheet":"Sponsor Information","index":1,"n_rows":33,"n_cols":2,"rows_kept":33}
["SponsorID"]
["Sponsor Name"]
["Website"]
["Program Name"]
["Status"]
["Primary Contact First Name"]
["Primary Contact Last Name"]
["Primary Email"]
["Primary Phone Number"]
["Reporting Contact First Name"]
["Reporting Contact Last Name"]
["Reporting Contact Email"]
["Reporting Contact Phone Number"]
["Year Joining the Program "]
["Total Active Participating Contractors",{"$f":"COUNTIF('Contractor Project Information'!F:F,\"Active\")","v":0}]
["Total 12Q2 Projects",{"$f":"SUM('Contractor Project Information'!S:S)","v":0}]
["Total 12Q2 Field Inspections",{"$f":"SUM('Contractor Project Information'!T:T)","v":0}]
["Total 12Q3 Projects",{"$f":"SUM('Contractor Project Information'!U:U)","v":0}]
["Total 12Q3 Field Inspections",{"$f":"SUM('Contractor Project Information'!V:V)","v":0}]
["Total 12Q4 Projects",{"$f":"SUM('Contractor Project Information'!W:W)","v":0}]
["Total 12Q4 Field Inspections",{"$f":"SUM('Contractor Project Information'!X:X)","v":0}]
["Total CY12 Projects",{"$f":"SUM('Contractor Project Information'!Y:Y)","v":0}]
["Total CY12 Field Inspections",{"$f":"SUM('Contractor Project Information'!Z:Z)","v":0}]
["Total 13Q1 Projects",{"$f":"SUM('Contractor Project Information'!AA:AA)","v":0}]
["Total 13Q1 Field Inspections",{"$f":"SUM('Contractor Project Information'!AB:AB)","v":0}]
["Total 13Q2 Projects",{"$f":"SUM('Contractor Project Information'!AC:AC)","v":0}]
["Total 13Q2 Field Inspections",{"$f":"SUM('Contractor Project Information'!AD:AD)","v":0}]
["Total 13Q3 Projects",{"$f":"SUM('Contractor Project Information'!AE:AE)","v":0}]
["Total 13Q3 Field Inspections",{"$f":"SUM('Contractor Project Information'!AF:AF)","v":0}]
["Total 13Q4 Projects",{"$f":"SUM('Contractor Project Information'!AG:AG)","v":0}]
["Total 13Q4 Field Inspections",{"$f":"SUM('Contractor Project Information'!AH:AH)","v":0}]
["Total CY13 Projects",{"$f":"SUM('Contractor Project Information'!AI:AI)","v":0}]
["Total CY13 Field Inspections",{"$f":"SUM('Contractor Project Information'!AJ:AJ)","v":0}]

{"sheet":"Contractor Project Information","index":2,"n_rows":7,"n_cols":38,"rows_kept":7}
["Sponsor ID","Contractor ID","HPwES                                          Contractor","Contact First                                       Name","Contact Last                             Name","Status","Email","Contact Phone","Address 1","Address 2","City","State","Zip","Organization Phone","Organization Fax","Website","12Q1 Projects","12Q1 Field Inspections","12Q2 Projects","12Q2 Field Inspections","12Q3 Projects","12Q3 Field Inspections","12Q4 Projects","12Q4 Field Inspections","CY12 Project","CY12 Field Inspections","13Q1 Projects","13Q1 Field Inspections","13Q2 Projects","13Q2 Field Inspections","13Q3 Projects","13Q3 Field Inspections","13Q4 Projects","13Q4 Field Inspections","CY13 Projects","CY13 Field Inspections","14Q1 Projects","14Q1 Field Inspections"]
[{"$f":"A$3","v":0},{"$nulls":23},{"$f":"SUM(Q2,S2,U2,W2)","v":0},{"$f":"SUM(R2,T2,V2,X2)","v":0},{"$nulls":8},{"$f":"SUM(AA2,AC2,AE2,AG2)","v":0},{"$f":"SUM(AB2,AD2,AF2,AH2)","v":0}]
[{"$nulls":24},{"$f":"SUM(Q3,S3,U3,W3)","v":0},{"$f":"SUM(R3,T3,V3,X3)","v":0},{"$nulls":8},{"$f":"SUM(AA3,AC3,AE3,AG3)","v":0},{"$f":"SUM(AB3,AD3,AF3,AH3)","v":0}]
[{"$nulls":24},0,0,{"$nulls":8},{"$f":"SUM(AA4,AC4,AE4,AG4)","v":0},{"$f":"SUM(AB4,AD4,AF4,AH4)","v":0}]
[{"$nulls":24},0,0,{"$nulls":8},0,0]
[{"$nulls":24},0,0,{"$nulls":8},0,0]
[{"$nulls":24},0,0,{"$nulls":8},0,0]