{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["C-1","C-2","C-3"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[[28,0,30,9],[31,0,32,9],[2,8,2,10],[2,1,2,7]],"flags":["formulas_cached_only"]}
[]
[]
[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,82.88,52.6,20.13,"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"]
["Letter of Intent"]
["From Partners"]
["       Review PA",0,0.25,0,0.25,13.15,0,0,250,62.5,3287.5]
["       Enter PA information into Upshot/database",0,0.25,0,0.25,13.15,0,0,250,62.5,3287.5]
["SUBTOTAL",{"$nulls":8},125,6575]
["Annual Information Reporting Forms"]
["Prepare and send pre-populated forms to existing partners a",0,0.25,0.25,0.5,18.1825,0,0,1058,529,19237.085000000003]
["Review completed information form ",0,0.25,0,0.25,13.15,0,0,1058,264.5,13912.7]
["Enter information into database and file copy of the form",0,0.25,0,0.25,13.15,0,0,1058,264.5,13912.7]
["SUBTOTAL",{"$nulls":8},1058,47062.485]
["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,13.15,0,0,548.2,137.05,7208.830000000001]
["Review and enter data after receipt of information",0,0.25,0,0.25,13.15,0,0,548.2,137.05,7208.830000000001]
["Request additional technical information via e-mail or telephone c",0,0.25,0,0.25,13.15,0,0,100,25,1315]
["Review and enter data after receipt of information",0,0.25,0,0.25,13.15,0,0,100,25,1315]
["SUBTOTAL",{"$nulls":8},324.1,17047.660000000003]
["Receive Information updates"]
["Review and enter contact or profile information updates received from partners via GPP Website d",0,0.25,0,0.25,13.15,0,0,327,81.75,4300.05]
["SUBTOTAL",{"$nulls":8},81.75,4300.05]
["Annual management review of GPP program e",16,0,0,16,1326.08,0,0,null,16,1326.08]
["TOTAL",{"$nulls":7},1308,1604.85,76311.27500000001]
[]
["* Agency labor rates were taken from the source table: 2008 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 1058 partners previously completed the form and will update it in 2009."]
[]
["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 2009."]
["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 2009 is 1308, including 1058 existing Partners who submit annual forms and 250 new partners who submit Partnership Agreements."]

{"sheet":"C-2","index":1,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":false,"merged":[[28,0,28,9]],"flags":["formulas_cached_only"]}
[]
[]
[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,82.88,52.6,20.13,"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"]
["Letter of Intent"]
["From Partners"]
["       Review PA",0,0.25,0,0.25,13.15,0,0,250,62.5,3287.5]
["       Enter PA information into Upshot/database",0,0.25,0,0.25,13.15,null,null,250,62.5,3287.5]
["SUBTOTAL",{"$nulls":8},125,6575]
["Annual Information Reporting Forms"]
["Prepare and send pre-populated forms to existing partners a",0,0.25,0.25,0.5,18.1825,0,0,1308,654,23782.710000000003]
["Review completed information form ",0,0.25,0,0.25,13.15,0,0,1308,327,17200.2]
["Enter information into database and file copy of the form",0,0.25,0,0.25,13.15,0,0,1308,327,17200.2]
["SUBTOTAL",{"$nulls":8},1308,58183.11]
["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,13.15,0,0,648.2,162.05,8523.83]
["Review and enter data after receipt of information",0,0.25,0,0.25,13.15,0,0,648.2,162.05,8523.83]
["Request additional technical information via e-mail or telephone c",0,0.25,0,0.25,13.15,0,0,100,25,1315]
["Review and enter data after receipt of information",0,0.25,0,0.25,13.15,0,0,100,25,1315]
["SUBTOTAL",{"$nulls":8},374.1,19677.66]
["Receive Information updates"]
["Review and enter contact or profile information updates received from partners via GPP Website d",0,0.25,0,0.25,13.15,0,0,389.5,97.375,5121.925]
["SUBTOTAL",{"$nulls":8},97.375,5121.925]
["Annual management review of GPP program e",16,0,0,16,1326.08,0,0,null,16,1326.08]
["TOTAL",{"$nulls":7},1558,1920.475,90883.77500000001]
[]
["* Agency labor rates were taken from the source table: 2008 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 1308 partners previously completed the form and will update it in 2010."]
["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 2010."]
["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 2010 is 1558, including 1308 existing Partners who submit annual forms and 250 new partners who submit Partnership Agreements."]

{"sheet":"C-3","index":2,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":false,"merged":[[28,0,28,10]],"flags":["formulas_cached_only"]}
[]
[]
[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,82.88,52.6,20.13,"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"]
["Letter of Intent"]
["From Partners"]
["       Review PA",0,0.25,0,0.25,13.15,0,0,250,62.5,3287.5]
["       Enter PA information into Upshot/database",0,0.25,0,0.25,13.15,null,null,250,62.5,3287.5]
["SUBTOTAL",{"$nulls":8},125,6575]
["Annual Information Reporting Forms"]
["Prepare and send pre-populated forms to existing partners a",0,0.25,0.25,0.5,18.1825,0,0,1558,779,28328.335000000003]
["Review completed information form ",0,0.25,0,0.25,13.15,0,0,1558,389.5,20487.7]
["Enter information into database and file copy of the form",0,0.25,0,0.25,13.15,0,0,1558,389.5,20487.7]
["SUBTOTAL",{"$nulls":8},1558,69303.735]
["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,13.15,0,0,748.2,187.05,9838.830000000002]
["Review and enter data after receipt of information",0,0.25,0,0.25,13.15,0,0,748.2,187.05,9838.830000000002]
["Request additional technical information via e-mail or telephone c",0,0.25,0,0.25,13.15,0,0,100,25,1315]
["Review and enter data after receipt of information",0,0.25,0,0.25,13.15,0,0,100,25,1315]
["SUBTOTAL",{"$nulls":8},424.1,22307.660000000003]
["Receive Information updates"]
["Review and enter contact or profile information updates received from partners via GPP Website d",0,0.25,0,0.25,13.15,0,0,452,113,5943.8]
["SUBTOTAL",{"$nulls":8},113,5943.8]
["Annual management review of GPP program e",16,0,0,16,1326.08,0,0,null,16,1326.08]
["TOTAL",{"$nulls":7},1808,2236.1,105456.27500000001]
[]
["* Agency labor rates were taken from the source table: 2008 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 1558 partners previously completed the form and will update it in 2011."]
["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 2011."]
["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 2010 is 1808, including 1558 existing Partners who submit annual forms and 250 new partners who submit Partnership Agreements."]