{"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":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"]}
["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,91.64538461538461,58.175384615384615,22.26538461538462,"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,14.543846153846154,0,0,82,20.5,1192.5953846153845]
["       Enter PA information into Upshot/database",0,0.25,0,0.25,14.543846153846154,0,0,82,20.5,1192.5953846153845]
["SUBTOTAL",{"$nulls":8},41,2385.190769230769]
["Annual Information Reporting Forms"]
["Prepare and send pre-populated forms to existing partners a",0,0.25,0.25,0.5,20.11019230769231,0,0,1430,715,28757.575]
["Review completed information form ",0,0.25,0,0.25,14.543846153846154,0,0,1430,357.5,20797.7]
["Enter information into database and file copy of the form",0,0.25,0,0.25,14.543846153846154,0,0,1430,357.5,20797.7]
["SUBTOTAL",{"$nulls":8},1430,70352.975]
["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.543846153846154,0,0,613,153.25,8915.377692307693]
["Review and enter data after receipt of information",0,0.25,0,0.25,14.543846153846154,0,0,613,153.25,8915.377692307693]
["Request additional technical information via e-mail or telephone c",0,0.25,0,0.25,14.543846153846154,0,0,100,25,1454.3846153846155]
["Review and enter data after receipt of information",0,0.25,0,0.25,14.543846153846154,0,0,100,25,1454.3846153846155]
["SUBTOTAL",{"$nulls":8},356.5,20739.52461538462]
["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.543846153846154,0,0,378,94.5,5497.573846153846]
["SUBTOTAL",{"$nulls":8},94.5,5497.573846153846]
["Annual management review of GPP program e",16,0,0,16,1466.3261538461538,0,0,null,16,1466.3261538461538]
["TOTAL",{"$nulls":7},1512,1938,100441.5903846154]
[]
["* Agency labor rates were taken from the source table: 2018 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 ($119.14); technical rates assumed a GS level 13 step 1 ($75,628); clerical rates assumed a GS level 5 step 1 ($28,945).  A loaded hourly wage to account for benefits and overhead was calculated from the annual rates .  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 1430 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 1512, including 1430 existing Partners who submit annual forms and 82 new partners who submit Partnership Agreements."]

{"sheet":"C-2","index":1,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[[28,0,30,9],[31,0,32,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,91.64538461538461,58.175384615384615,22.26538461538462,"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,14.543846153846154,0,0,82,20.5,1192.5953846153845]
["       Enter PA information into Upshot/database",0,0.25,0,0.25,14.543846153846154,null,null,82,20.5,1192.5953846153845]
["SUBTOTAL",{"$nulls":8},41,2385.190769230769]
["Annual Information Reporting Forms"]
["Prepare and send pre-populated forms to existing partners a",0,0.25,0.25,0.5,20.11019230769231,0,0,1490,745,29964.18653846154]
["Review completed information form ",0,0.25,0,0.25,14.543846153846154,0,0,1490,372.5,21670.330769230768]
["Enter information into database and file copy of the form",0,0.25,0,0.25,14.543846153846154,0,0,1490,372.5,21670.330769230768]
["SUBTOTAL",{"$nulls":8},1490,73304.84807692308]
["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.543846153846154,0,0,637,159.25,9264.43]
["Review and enter data after receipt of information",0,0.25,0,0.25,14.543846153846154,0,0,637,159.25,9264.43]
["Request additional technical information via e-mail or telephone c",0,0.25,0,0.25,14.543846153846154,0,0,100,25,1454.3846153846155]
["Review and enter data after receipt of information",0,0.25,0,0.25,14.543846153846154,0,0,100,25,1454.3846153846155]
["SUBTOTAL",{"$nulls":8},368.5,21437.629230769235]
["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.543846153846154,0,0,393,98.25,5715.731538461539]
["SUBTOTAL",{"$nulls":8},98.25,5715.731538461539]
["Annual management review of GPP program e",16,0,0,16,1466.3261538461538,0,0,null,16,1466.3261538461538]
["TOTAL",{"$nulls":7},1572,2013.75,104309.72576923078]
[]
["* Agency labor rates were taken from the source table: 2018 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 ($119.14); technical rates assumed a GS level 13 step 1 ($75,628); clerical rates assumed a GS level 5 step 1 ($28,945).  A loaded hourly wage to account for benefits and overhead was calculated from the annual rates .  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 1490 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 1572, including 1490 existing Partners who submit annual forms and 82 new partners who submit Partnership Agreements."]

{"sheet":"C-3","index":2,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[[28,0,30,9],[31,0,32,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,91.64538461538461,58.175384615384615,22.26538461538462,"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,14.543846153846154,0,0,82,20.5,1192.5953846153845]
["       Enter PA information into Upshot/database",0,0.25,0,0.25,14.543846153846154,null,null,82,20.5,1192.5953846153845]
["SUBTOTAL",{"$nulls":8},41,2385.190769230769]
["Annual Information Reporting Forms"]
["Prepare and send pre-populated forms to existing partners a",0,0.25,0.25,0.5,20.11019230769231,0,0,1550,775,31170.798076923078]
["Review completed information form ",0,0.25,0,0.25,14.543846153846154,0,0,1550,387.5,22542.96153846154]
["Enter information into database and file copy of the form",0,0.25,0,0.25,14.543846153846154,0,0,1550,387.5,22542.96153846154]
["SUBTOTAL",{"$nulls":8},1550,76256.72115384616]
["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.543846153846154,0,0,661,165.25,9613.482307692308]
["Review and enter data after receipt of information",0,0.25,0,0.25,14.543846153846154,0,0,661,165.25,9613.482307692308]
["Request additional technical information via e-mail or telephone c",0,0.25,0,0.25,14.543846153846154,0,0,100,25,1454.3846153846155]
["Review and enter data after receipt of information",0,0.25,0,0.25,14.543846153846154,0,0,100,25,1454.3846153846155]
["SUBTOTAL",{"$nulls":8},380.5,22135.73384615385]
["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.543846153846154,0,0,408,102,5933.88923076923]
["SUBTOTAL",{"$nulls":8},102,5933.88923076923]
["Annual management review of GPP program e",16,0,0,16,1466.3261538461538,0,0,null,16,1466.3261538461538]
["TOTAL",{"$nulls":7},1632,2089.5,108177.86115384616]
[]
["* Agency labor rates were taken from the source table: 2018 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 ($119.14); technical rates assumed a GS level 13 step 1 ($75,628); clerical rates assumed a GS level 5 step 1 ($28,945).  A loaded hourly wage to account for benefits and overhead was calculated from the annual rates .  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 1550 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 1632 including 1550 existing Partners who submit annual forms and 82 new partners who submit Partnership Agreements."]