{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["C-1","C-2","C-3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":31,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"C-1","index":0,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[[33,0,35,9],[36,0,37,9],[2,8,2,10],[2,1,2,7]],"flags":["formulas_cached_only"]}
["GPP Agency Burden - Year 1"]
[]
[null,"Hours and Costs Per Respondent Per Activity",{"$nulls":6},"Total Hours and Costs"]
[null,"Mgr.*","Tech.*","Cler.*","Agency","Labor","Capital/",null,"Number f","Number of","Total"]
[null,88.3,56.4,21.46,"Hours/","Cost/","Startup","O & M","of","Total","Cost/"]
["INFORMATION COLLECTION ACTIVITY","Per Hour","Per Hour","Per Hour","Year","Year","Cost","Cost","Respondents","Hours/Year","Year"]
["Partnership Agreement"]
["From Partners"]
["       Review PA",0,0.25,0,0.25,14.1,0,0,250,62.5,3525]
["       Enter PA information into Upshot/database",0,0.25,0,0.25,14.1,0,0,250,62.5,3525]
["SUBTOTAL",null,null,null,0.5,28.2,null,null,null,125,7050]
["Annual Information Reporting Forms"]
["Prepare and send pre-populated forms to existing partners a",0,0.25,0.25,0.5,19.465,0,0,1568,784,30521.12]
["Review completed information form ",0,0.25,0,0.25,14.1,0,0,1568,392,22108.8]
["Enter information into database and file copy of the form",0,0.25,0,0.25,14.1,0,0,1568,392,22108.8]
["SUBTOTAL",null,null,null,1,47.665,null,null,null,1568,74738.72]
["Initiate Information Follow-ups"]
["Call or email partner to request clarification of Partnership Agreement or annual reporting form b",0,0.25,0,0.25,14.1,0,0,752.2,188.05,10606.02]
["Review and enter data after receipt of information",0,0.25,0,0.25,14.1,0,0,752.2,188.05,10606.02]
["Request additional technical information via e-mail or telephone c",0,0.25,0,0.25,14.1,0,0,100,25,1410]
["Review and enter data after receipt of information",0,0.25,0,0.25,14.1,0,0,100,25,1410]
["SUBTOTAL",null,null,null,1,56.4,null,null,null,426.1,24032.04]
["Green Power Partnership Awards"]
["Update application and outreach efforts",0,3,0,3,169.2,0,0,1,3,169.2]
["Review and rank applications",0.25,1,0,1.25,78.475,0,0,62.72,78.4,4921.951999999999]
["Notify applicants",0,0.25,0,0.25,14.1,0,0,62.72,15.68,884.352]
["SUBTOTAL",0.25,4.25,0,4.5,261.775,0,0,126.44,97.08000000000001,5975.503999999999]
["Receive Information updates"]
["Review and enter contact or profile information updates received from partners via GPP Website d",0,0.25,0,0.25,14.1,0,0,454.5,113.625,6408.45]
["Annual management review of GPP program e",16,0,0,16,1412.8,0,0,null,16,1412.8]
["SUBTOTAL",16,0.25,0,16.25,1426.8999999999999,0,0,null,null,7821.25]
["TOTAL",null,null,null,23.25,1820.9399999999998,null,null,1818,2345.805,119617.51400000001]
[]
["* Agency labor rates were taken from the source table: 2015 GS Salary Table of Annual Rates by Grade and Step from the Office of Personnel Management.  Manager rates assumed a GS level 15 step 5; technical rates assumed a GS level 13 step 1; clerical rates assumed a GS level 5 step 1.  A loaded hourly wage to account for benefits and overhead was calculated from the annual rates given in the table according to the instructions in the ICR Handbook, p A-42.  GS Hourly wage = [GS annual salary($)/2080 (hours/year)]*1.6 "]
[]
[]
["a Partners receive a pre-populated form with their data and simply review and update their information.  Assumes 1568 partners previously completed the form and will update it in Year 1."]
[]
["b On average, the Agency must contact 50% of new partners regarding the Partnership Agreement and 40% of existing partners regarding the yearly report form.  Each follow-up call is estimated to take 15 minutes."]
["c The Agency expects to request 100 GPP partners to provide additional technical information in Year 1"]
["d An estimated 25% of all GPP partners are likely to make web updates because there is a promotional GPP Partner Profile on each individual partner page.  All updates must be reviewed by Agency staff."]
["e Assumed an annual EPA management review of Green Power Partnership program information collection activities and success."]
["f The total number of unique respondents submitting information in Year 1 is 1818, including 1568 existing Partners who submit annual forms and 250 new partners who submit Partnership Agreements."]

{"sheet":"C-2","index":1,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[[33,0,35,9],[36,0,37,9]],"flags":["formulas_cached_only"]}
["GPP Agency Burden - Year 2"]
[]
[null,"Hours and Costs Per Respondent Per Activity",{"$nulls":6},"Total Hours and Costs"]
[null,"Mgr.*","Tech.*","Cler.*","Agency","Labor","Capital/",null,"Number f","Number of","Total"]
[null,88.3,56.4,21.46,"Hours/","Cost/","Startup","O & M","of","Total","Cost/"]
["INFORMATION COLLECTION ACTIVITY","Per Hour","Per Hour","Per Hour","Year","Year","Cost","Cost","Respondents","Hours/Year","Year"]
["Partnership Agreement"]
["From Partners"]
["       Review PA",0,0.25,0,0.25,14.1,0,0,250,62.5,3525]
["       Enter PA information into Upshot/database",0,0.25,0,0.25,14.1,null,null,250,62.5,3525]
["SUBTOTAL",null,0.5,null,0.5,28.2,null,null,null,125,7050]
["Annual Information Reporting Forms"]
["Prepare and send pre-populated forms to existing partners a",0,0.25,0.25,0.5,19.465,0,0,1818,909,35387.37]
["Review completed information form ",0,0.25,0,0.25,14.1,0,0,1818,454.5,25633.8]
["Enter information into database and file copy of the form",0,0.25,0,0.25,14.1,0,0,1818,454.5,25633.8]
["SUBTOTAL",null,0.75,0.25,1,47.665,null,null,null,1818,86654.97]
["Initiate Information Follow-ups"]
["Call or email partner to request clarification of Partnership Agreement or annual reporting form b",0,0.25,0,0.25,14.1,0,0,852.2,213.05,12016.02]
["Review and enter data after receipt of information",0,0.25,0,0.25,14.1,0,0,852.2,213.05,12016.02]
["Request additional technical information via e-mail or telephone c",0,0.25,0,0.25,14.1,0,0,100,25,1410]
["Review and enter data after receipt of information",0,0.25,0,0.25,14.1,0,0,100,25,1410]
["SUBTOTAL",null,1,null,1,56.4,null,null,null,476.1,26852.04]
["Green Power Partnership Awards"]
["Update application and outreach efforts",0,3,0,3,169.2,0,0,1,3,169.2]
["Review and rank applications",0.25,1,0,1.25,78.475,0,0,72.72,90.9,5706.701999999999]
["Notify applicants",0,0.25,0,0.25,14.1,0,0,72.72,18.18,1025.3519999999999]
["SUBTOTAL",0.25,4.25,0,4.5,261.775,0,0,146.44,112.08000000000001,6901.253999999999]
["Receive Information updates"]
["Review and enter contact or profile information updates received from partners via GPP Website d",0,0.25,0,0.25,14.1,0,0,517,129.25,7289.7]
["SUBTOTAL",{"$nulls":8},129.25,7289.7]
["Annual management review of GPP program e",16,0,0,16,1412.8,0,0,null,16,1412.8]
["TOTAL",null,null,null,22.25,1820.94,null,null,2068,2676.43,136160.764]
[]
["* Agency labor rates were taken from the source table: 2015 GS Salary Table of Annual Rates by Grade and Step from the Office of Personnel Management.  Manager rates assumed a GS level 15 step 5; technical rates assumed a GS level 13 step 1; clerical rates assumed a GS level 5 step 1.  A loaded hourly wage to account for benefits and overhead was calculated from the annual rates given in the table according to the instructions in the ICR Handbook, p A-42.  GS Hourly wage = [GS annual salary($)/2080 (hours/year)]*1.6 "]
[]
[]
["a Partners receive a pre-populated form with their data and simply review and update their information.  Assumes 1818 partners previously completed the form and will update it in Year 2."]
[]
["b On average, the Agency must contact 50% of new partners regarding the Partnership Agreement and 40% of existing partners regarding the yearly report form.  Each follow-up call is estimated to take 15 minutes."]
["c The Agency expects to request 100 GPP partners to provide additional technical information in Year 2"]
["d An estimated 25% of all GPP partners are likely to make web updates because there is a promotional GPP Partner Profile on each individual partner page.  All updates must be reviewed by Agency staff."]
["e Assumed an annual EPA management review of Green Power Partnership program information collection activities and success."]
["f The total number of unique respondents submitting information in Year 1 is 2068, including 1818 existing Partners who submit annual forms and 250 new partners who submit Partnership Agreements."]

{"sheet":"C-3","index":2,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[[33,0,35,9],[36,0,37,9]],"flags":["formulas_cached_only"]}
["GPP Agency Burden - Year 3"]
[]
[null,"Hours and Costs Per Respondent Per Activity",{"$nulls":6},"Total Hours and Costs"]
[null,"Mgr.*","Tech.*","Cler.*","Agency","Labor","Capital/",null,"Number f","Number of","Total"]
[null,88.3,56.4,21.46,"Hours/","Cost/","Startup","O & M","of","Total","Cost/"]
["INFORMATION COLLECTION ACTIVITY","Per Hour","Per Hour","Per Hour","Year","Year","Cost","Cost","Respondents","Hours/Year","Year"]
["Partnership Agreement"]
["From Partners"]
["       Review PA",0,0.25,0,0.25,14.1,0,0,250,62.5,3525]
["       Enter PA information into Upshot/database",0,0.25,0,0.25,14.1,null,null,250,62.5,3525]
["SUBTOTAL",null,0.5,null,0.5,28.2,null,null,null,125,7050]
["Annual Information Reporting Forms"]
["Prepare and send pre-populated forms to existing partners a",0,0.25,0.25,0.5,19.465,0,0,2068,1034,40253.62]
["Review completed information form ",0,0.25,0,0.25,14.1,0,0,2068,517,29158.8]
["Enter information into database and file copy of the form",0,0.25,0,0.25,14.1,0,0,2068,517,29158.8]
["SUBTOTAL",null,0.75,0.25,1,47.665,null,null,null,2068,98571.22]
["Initiate Information Follow-ups"]
["Call or email partner to request clarification of Partnership Agreement or annual reporting form b",0,0.25,0,0.25,14.1,0,0,952.2,238.05,13426.02]
["Review and enter data after receipt of information",0,0.25,0,0.25,14.1,0,0,952.2,238.05,13426.02]
["Request additional technical information via e-mail or telephone c",0,0.25,0,0.25,14.1,0,0,100,25,1410]
["Review and enter data after receipt of information",0,0.25,0,0.25,14.1,0,0,100,25,1410]
["SUBTOTAL",null,1,null,1,56.4,null,null,null,526.1,29672.04]
["Green Power Partnership Awards"]
["Update application and outreach efforts",0,3,0,3,169.2,0,0,1,3,169.2]
["Review and rank applications",0.25,1,0,1.25,78.475,0,0,82.72,103.4,6491.451999999999]
["Notify applicants",0,0.25,0,0.25,14.1,0,0,82.72,20.68,1166.3519999999999]
["SUBTOTAL",0.25,4.25,null,4.5,261.775,0,0,166.44,127.08000000000001,7827.003999999999]
["Receive Information updates"]
["Review and enter contact or profile information updates received from partners via GPP Website d",0,0.25,0,0.25,14.1,0,0,579.5,144.875,8170.95]
["SUBTOTAL",{"$nulls":8},144.875,8170.95]
["Annual management review of GPP program e",16,0,0,16,1412.8,0,0,null,16,1412.8]
["TOTAL",null,null,null,23.25,1820.94,null,null,2318,3007.055,152704.014]
[]
["* Agency labor rates were taken from the source table: 2015 GS Salary Table of Annual Rates by Grade and Step from the Office of Personnel Management.  Manager rates assumed a GS level 15 step 5; technical rates assumed a GS level 13 step 1; clerical rates assumed a GS level 5 step 1.  A loaded hourly wage to account for benefits and overhead was calculated from the annual rates given in the table according to the instructions in the ICR Handbook, p A-42.  GS Hourly wage = [GS annual salary($)/2080 (hours/year)]*1.6 "]
[]
[]
["a Partners receive a pre-populated form with their data and simply review and update their information.  Assumes 1818 partners previously completed the form and will update it in Year 3."]
[]
["b On average, the Agency must contact 50% of new partners regarding the Partnership Agreement and 40% of existing partners regarding the yearly report form.  Each follow-up call is estimated to take 15 minutes."]
["c The Agency expects to request 100 GPP partners to provide additional technical information in Year 3"]
["d An estimated 25% of all GPP partners are likely to make web updates because there is a promotional GPP Partner Profile on each individual partner page.  All updates must be reviewed by Agency staff."]
["e Assumed an annual EPA management review of Green Power Partnership program information collection activities and success."]
["f The total number of unique respondents submitting information in Year 1 is 2318 including 2068 existing Partners who submit annual forms and 250 new partners who submit Partnership Agreements."]