{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["D-1","D-2","D-3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":26,"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":"D-1","index":0,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":false,"merged":[[39,0,39,9],[30,0,32,10],[0,1,0,7],[0,8,0,11],[33,0,34,9],[35,0,36,9],[37,0,37,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 ",null,"Number of","Total"]
[null,91.65,58.18,22.27,"Hours/","Cost/","Startup","O & M","of","Responses/","Total","Cost/"]
["INFORMATION COLLECTION ACTIVITY","Hour","Hour","Hour","Year","Year","Cost","Cost","Respondents","Year","Hours/Year","Year"]
["Letter of Intent"]
["From State/Local/Tribal Partners"]
["       Review LOI",0,0.25,0,0.25,14.545,0,0,1,1,0.25,14.545]
["       Enter LOI information into Upshot/database",0,0.25,0,0.25,14.545,0,0,1,1,0.25,14.545]
["From Company and Institutional Partners"]
["       Review LOI",0,0.25,0,0.25,14.545,0,0,9,1,2.25,130.905]
["       Enter LOI information into Upshot/database",0,0.25,0,0.25,14.545,0,0,9,1,2.25,130.905]
["SUBTOTAL",{"$nulls":9},5,290.9]
["CHP Project Information Reporting Forms"]
["Prepare and send information spreadsheet to partners a",0,0.5,0,0.5,29.09,0,0,413,1,206.5,12014.17]
["Call partners to request reporting information b",0,0.5,0,0.5,29.09,0,0,103,1,51.5,2996.27]
["Review completed information spreadsheet",0,1.25,0,1.25,72.725,0,0,413,1,516.25,30035.425]
["Enter information form into database and file copy of the form ",0,1.25,0,1.25,72.725,0,0,413,1,516.25,30035.425]
["SUBTOTAL",{"$nulls":9},1290.5,75081.29]
["Initiate Information updates"]
["Call or email partner to request clarification of LOI or project reporting form b",0,0.25,0,0.25,14.545,0,0,103,1,25.75,1498.135]
["Review and enter data after receipt of information",0,0.25,0,0.25,14.545,0,0,103,1,25.75,1498.135]
["SUBTOTAL",{"$nulls":9},51.5,2996.27]
["Receive Information updates"]
["Review and enter contact or profile information updates received from partners via CHP Website c",0,0.25,0,0.25,14.545,0,0,61.949999999999996,1,15.487499999999999,901.0627499999999]
["SUBTOTAL",{"$nulls":9},15.487499999999999,901.0627499999999]
["Annual management review of CHP program d"]
["Management Review",8,0,0,8,733.2,0,0,1,1,8,733.2]
["SUBTOTAL",{"$nulls":9},8,733.2]
["TOTAL  e",{"$nulls":7},423,null,1370.4875,80002.72274999999]
[]
["* 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; 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.  GS Hourly wage = [GS annual salary($)/2080 (hours/year)]*1.6 "]
[]
[]
["a All exisiting project developers, ESCOs, consulting engineers, and equipment manufacturers, and 33% of utilities review their project information and provide updates once per year. New partners receive a project form during the same year they join the CHP partnership. Of the estimated 423 partners at the end of 2018, 413 existing company/institutional partners and 10 new company/institutional partners that join in 2019 will receive a reporting form.  State partners do not fill out a reporting form."]
[]
["b Assumed 25% of the 10 new company/institutional partners completing their LOI, and one of the two new state partners will require follow-up.  Additionally, 25% of the 413 partners completing CHP project forms or spreadsheets will require follow-up in order to correctly complete the form."]
[]
["c Assumed 15% of new and existing company/institutional partners in the year 2019 and 15% of new and existing state partners, will update their information over the CHP website sometime during the calendar year."]
["d Assumed an annual EPA management review of CHP Partnership program information collection activities and success."]
["e The total number of unique company/institutional respondents submitting information in 2019 is 423, including 413 existing partners who are expected to complete project reporting spreadsheets, 10 new partners who will fill out both a LOI and project reporting form. The total number of unique state respondents submitting information in 2019 is 2, both of which are state/local/tribal government partners who will complete an LOI."]

{"sheet":"D-2","index":1,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":false,"merged":[[35,0,36,9],[37,0,37,9],[39,0,39,9],[0,1,0,7],[0,8,0,11],[30,0,32,10],[33,0,34,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 ",null,"Number of","Total"]
[null,91.65,58.18,22.27,"Hours/","Cost/","Startup","O & M","of","Responses/","Total","Cost/"]
["INFORMATION COLLECTION ACTIVITY","Hour","Hour","Hour","Year","Year","Cost","Cost","Respondents","Year","Hours/Year","Year"]
["Letter of Intent"]
["From State/Local/Tribal Partners"]
["       Review LOI",0,0.25,0,0.25,14.545,0,0,1,1,0.25,14.545]
["       Enter LOI information into Upshot/database",0,0.25,0,0.25,14.545,0,0,1,1,0.25,14.545]
["From Company and Institutional Partners"]
["       Review LOI",0,0.25,0,0.25,14.545,0,0,9,1,2.25,130.905]
["       Enter LOI information into Upshot/database",0,0.25,0,0.25,14.545,0,0,9,1,2.25,130.905]
["SUBTOTAL",{"$nulls":9},5,290.9]
["CHP Project Information Reporting Forms"]
["Prepare and send information spreadsheet to partners a",0,0.5,0,0.5,29.09,0,0,423,1,211.5,12305.07]
["Call partners to request reporting information",0,0.5,0,0.5,29.09,0,0,100,1,50,2909]
["Review completed information spreadsheet",0,1.25,0,1.25,72.725,0,0,423,1,528.75,30762.675]
["Enter information form into database and file copy of the form ",0,1.25,0,1.25,72.725,0,0,423,1,528.75,30762.675]
["SUBTOTAL",{"$nulls":9},1319,76739.42]
["Initiate Information updates"]
["Call or email partner to request clarification of LOI or project reporting form b",0,0.25,0,0.25,14.545,0,0,106,1,26.5,1541.77]
["Review and enter data after receipt of information",0,0.25,0,0.25,14.545,0,0,106,1,26.5,1541.77]
["SUBTOTAL",{"$nulls":9},53,3083.54]
["Receive Information updates"]
["Review and enter contact or profile information updates received from partners via CHP Website c",0,0.25,0,0.25,14.545,0,0,63,1,15.75,916.335]
["SUBTOTAL",{"$nulls":9},15.75,916.335]
["Annual management review of CHP program d"]
["Management Review",8,0,0,8,733.2,0,0,1,1,8,733.2]
["SUBTOTAL",{"$nulls":9},8,733.2]
["TOTAL e",{"$nulls":7},433,null,1400.75,81763.39499999999]
[]
["* 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; 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.  GS Hourly wage = [GS annual salary($)/2080 (hours/year)]*1.6 "]
[]
[]
["a All exisiting project developers, ESCOs, consulting engineers, and equipment manufacturers, and 33% of utilities review their project information and provide updates once per year. New partners receive a project form during the same year they join the CHP partnership. Of the estimated 423 partners at the end of 2018, 413 existing company/institutional partners and 10 new company/institutional partners that join in 2019 will receive a reporting form.  State partners do not fill out a reporting form."]
[]
["b Assumed 25% of the 10 new company/institutional partners completing their LOI, and one of the two new state partners will require follow-up.  Additionally, 25% of the 418 partners completing CHP project forms or spreadsheets will require follow-up in order to correctly complete the form."]
[]
["c Assumed 15% of new and existing company/institutional partners in the year 2019 and 15% of new and existing state partners, will update their information over the CHP website sometime during the calendar year."]
["d Assumed an annual EPA management review of CHP Partnership program information collection activities and success."]
["e The total number of unique company/institutional respondents submitting information in 2019 is 433, including 423 existing partners who are expected to complete project reporting spreadsheets, 10 new partners who will fill out both a LOI and project reporting form. The total number of unique state respondents submitting information in 2019 is 2, both of which are state/local/tribal government partners who will complete an LOI."]

{"sheet":"D-3","index":2,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":false,"merged":[[35,0,36,9],[37,0,37,9],[39,0,39,9],[0,1,0,7],[0,8,0,11],[30,0,32,10],[33,0,34,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 ",null,"Number of","Total"]
[null,91.65,58.18,22.27,"Hours/","Cost/","Startup","O & M","of","Responses/","Total","Cost/"]
["INFORMATION COLLECTION ACTIVITY","Hour","Hour","Hour","Year","Year","Cost","Cost","Respondents","Year","Hours/Year","Year"]
["Letter of Intent"]
["From State/Local/Tribal Partners"]
["       Review LOI",0,0.25,0,0.25,14.545,0,0,1,1,0.25,14.545]
["       Enter LOI information into Upshot/database",0,0.25,0,0.25,14.545,0,0,1,1,0.25,14.545]
["From Company and Institutional Partners"]
["       Review LOI",0,0.25,0,0.25,14.545,0,0,9,1,2.25,130.905]
["       Enter LOI information into Upshot/database",0,0.25,0,0.25,14.545,0,0,9,1,2.25,130.905]
["SUBTOTAL",{"$nulls":9},5,290.9]
["CHP Project Information Reporting Forms"]
["Prepare and send information spreadsheet to partners a",0,0.5,0,0.5,29.09,0,0,433,1,216.5,12595.97]
["Call partners to request reporting information",0,0.5,0,0.5,29.09,0,0,100,1,50,2909]
["Review completed information spreadsheet",0,1.25,0,1.25,72.725,0,0,433,1,541.25,31489.925]
["Enter information form into database and file copy of the form ",0,1.25,0,1.25,72.725,0,0,433,1,541.25,31489.925]
["SUBTOTAL",{"$nulls":9},1349,78484.81999999999]
["Initiate Information updates"]
["Call or email partner to request clarification of LOI or project reporting form b",0,0.25,0,0.25,14.545,0,0,108,1,27,1570.86]
["Review and enter data after receipt of information",0,0.25,0,0.25,14.545,0,0,108,1,27,1570.86]
["SUBTOTAL",{"$nulls":9},54,3141.72]
["Receive Information updates"]
["Review and enter contact or profile information updates received from partners via CHP Website c",0,0.25,0,0.25,14.545,0,0,64,1,16,930.88]
["SUBTOTAL",{"$nulls":9},16,930.88]
["Annual management review of CHP program d"]
["Management Review",8,0,0,8,733.2,0,0,1,1,8,733.2]
["SUBTOTAL",{"$nulls":9},8,733.2]
["TOTAL e ",{"$nulls":7},443,null,1432,83581.51999999999]
[]
["* 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; 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.  GS Hourly wage = [GS annual salary($)/2080 (hours/year)]*1.6 "]
[]
[]
["a All exisiting project developers, ESCOs, consulting engineers, and equipment manufacturers, and 33% of utilities review their project information and provide updates once per year. New partners receive a project form during the same year they join the CHP partnership. Of the estimated 423 partners at the end of 2018, 413 existing company/institutional partners and 10 new company/institutional partners that join in 2019 will receive a reporting form.  State partners do not fill out a reporting form."]
[]
["b Assumed 25% of the 10 new company/institutional partners completing their LOI, and one of the two new state partners will require follow-up.  Additionally, 25% of the 418 partners completing CHP project forms or spreadsheets will require follow-up in order to correctly complete the form."]
[]
["c Assumed 15% of new and existing company/institutional partners in the year 2019 and 15% of new and existing state partners, will update their information over the CHP website sometime during the calendar year."]
["d Assumed an annual EPA management review of CHP Partnership program information collection activities and success."]
["e The total number of unique company/institutional respondents submitting information in 2019 is 443, including 433 existing partners who are expected to complete project reporting spreadsheets, 10 new partners who will fill out both a LOI and project reporting form. The total number of unique state respondents submitting information in 2019 is 2, both of which are state/local/tribal government partners who will complete an LOI."]