{"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,82.88,52.6,20.13,"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,13.15,0,0,2,1,0.5,26.3]
["       Enter LOI information into Upshot/database",0,0.25,0,0.25,13.15,0,0,2,1,0.5,26.3]
["From Company and Institutional Partners"]
["       Review LOI",0,0.25,0,0.25,13.15,0,0,32,1,8,420.8]
["       Enter LOI information into Upshot/database",0,0.25,0,0.25,13.15,0,0,32,1,8,420.8]
["SUBTOTAL",{"$nulls":9},17,894.2]
["CHP Project Information Reporting Forms"]
["Prepare and send information spreadsheet to partners a",0,0.5,0,0.5,26.3,0,0,228,1,114,5996.400000000001]
["Call partners to request reporting information",0,0.5,0,0.5,26.3,0,0,228,1,114,5996.400000000001]
["Review completed information spreadsheet",0,1.25,0,1.25,65.75,0,0,228,1,285,14991]
["Enter information form into database and file copy of the form ",0,1.25,0,1.25,65.75,0,0,228,1,285,14991]
["SUBTOTAL",{"$nulls":9},798,41974.8]
["Initiate Information updates"]
["Call or email partner to request clarification of LOI or project reporting form b",0,0.25,0,0.25,13.15,0,0,66,1,16.5,867.9]
["Review and enter data after receipt of information",0,0.25,0,0.25,13.15,0,0,66,1,16.5,867.9]
["SUBTOTAL",{"$nulls":9},33,1735.8]
["Receive Information updates"]
["Review and enter contact or profile information updates received from partners via CHP Website c",0,0.25,0,0.25,13.15,0,0,38,1,9.5,499.7]
["SUBTOTAL",{"$nulls":9},9.5,499.7]
["Annual management review of CHP program d"]
["Management Review",8,0,0,8,663.04,0,0,1,1,8,663.04]
["SUBTOTAL",{"$nulls":9},8,663.04]
["TOTAL",{"$nulls":7},"234e",null,865.5,45767.54]
[]
["* 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 All exisitng 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 260 partners at the end of 2008, 200 existing company/institutional partners and 28 of the 32 new company/institutional partners that join in 2009 will receive a reporting form.  All new end-users, project developers, consulting engineers, and equipment manufacturers (6 each of end users and equip. man.; and 7 each of project developers and consulting engineers) who join in 2009 will fill out a project form.  Thirty-three percent of the 6 utility partners who join in 2009 (i.e. 2 utilities) will receive a reporting form. State partners do not fill out a reporting form."]
[]
["b Assumed 25% of the 32 new company/institutional partners completing their LOI (i.e. 8 partners), and one of the two new state partners will require follow-up.  Additionally, 25% of the 228 partners completing CHP project forms or spreadsheets (i.e. 57 partners) will require follow-up in order to correctly complete the form."]
[]
["c Assumed 15% of new and existing company/institutional partners in the year 2009 (232 projected total partners) and 15% of new and existing state partners (18 projected total 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 2009 is 232, including 200 existing partners who are expected to complete project reporting spreadsheets, 28 new partners who will fill out both a LOI and project reporting form, and 4 new partners who will fill out only a LOI. The total number of unique state respondents submitting information in 2009 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,82.88,52.6,20.13,"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,13.15,0,0,2,1,0.5,26.3]
["       Enter LOI information into Upshot/database",0,0.25,0,0.25,13.15,0,0,2,1,0.5,26.3]
["From Company and Institutional Partners"]
["       Review LOI",0,0.25,0,0.25,13.15,0,0,32,1,8,420.8]
["       Enter LOI information into Upshot/database",0,0.25,0,0.25,13.15,0,0,32,1,8,420.8]
["SUBTOTAL",{"$nulls":9},17,894.2]
["CHP Project Information Reporting Forms"]
["Prepare and send information spreadsheet to partners a",0,0.5,0,0.5,26.3,0,0,256,1,128,6732.8]
["Call partners to request reporting information",0,0.5,0,0.5,26.3,0,0,256,1,128,6732.8]
["Review completed information spreadsheet",0,1.25,0,1.25,65.75,0,0,256,1,320,16832]
["Enter information form into database and file copy of the form ",0,1.25,0,1.25,65.75,0,0,256,1,320,16832]
["SUBTOTAL",{"$nulls":9},896,47129.6]
["Initiate Information updates"]
["Call or email partner to request clarification of LOI or project reporting form b",0,0.25,0,0.25,13.15,0,0,73,1,18.25,959.95]
["Review and enter data after receipt of information",0,0.25,0,0.25,13.15,0,0,73,1,18.25,959.95]
["SUBTOTAL",{"$nulls":9},36.5,1919.9]
["Receive Information updates"]
["Review and enter contact or profile information updates received from partners via CHP Website c",0,0.25,0,0.25,13.15,0,0,43,1,10.75,565.45]
["SUBTOTAL",{"$nulls":9},10.75,565.45]
["Annual management review of CHP program d"]
["Management Review",8,0,0,8,663.04,0,0,1,1,8,663.04]
["SUBTOTAL",{"$nulls":9},8,663.04]
["TOTAL",{"$nulls":7},"262e",null,968.25,51172.189999999995]
[]
["* 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 All exisitng 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 294 partners at the end of 2009, 228 existing company/institutional partners and 28 of the 32 new company/institutional partners that join in 2010 will receive a reporting form.  All new end-users, project developers, consulting engineers, and equipment manufacturers (6 each of end users and equip. man.; and 7 each of project developers and consulting engineers) who join in 2010 will fill out a project form.  Thirty-three percent of the 6 utility partners who join in 2010 (i.e. 2 utilities) will receive a reporting form. State partners do not fill out a reporting form."]
[]
["b Assumed 25% of the 32 new company/institutional partners completing their LOI (i.e. 8 partners), and one of the two new state partners will require follow-up.  Additionally, 25% of the 256 partners completing CHP project forms or spreadsheets (i.e. 64 partners) will require follow-up in order to correctly complete the form."]
[]
["c Assumed 15% of new and existing company/institutional partners in the year 2010 (264 projected total partners) and 15% of new and existing state partners (20 projected total 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 2010 is 260, including 228 existing partners who are expected to complete project reporting spreadsheets, 28 new partners who will fill out both a LOI and project reporting form, and 4 new partners who will fill out only a LOI. The total number of unique state respondents submitting information in 2010 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,82.88,52.6,20.13,"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,13.15,0,0,2,1,0.5,26.3]
["       Enter LOI information into Upshot/database",0,0.25,0,0.25,13.15,0,0,2,1,0.5,26.3]
["From Company and Institutional Partners"]
["       Review LOI",0,0.25,0,0.25,13.15,0,0,32,1,8,420.8]
["       Enter LOI information into Upshot/database",0,0.25,0,0.25,13.15,0,0,32,1,8,420.8]
["SUBTOTAL",{"$nulls":9},17,894.2]
["CHP Project Information Reporting Forms"]
["Prepare and send information spreadsheet to partners a",0,0.5,0,0.5,26.3,0,0,284,1,142,7469.2]
["Call partners to request reporting information",0,0.5,0,0.5,26.3,0,0,284,1,142,7469.2]
["Review completed information spreadsheet",0,1.25,0,1.25,65.75,0,0,284,1,355,18673]
["Enter information form into database and file copy of the form ",0,1.25,0,1.25,65.75,0,0,284,1,355,18673]
["SUBTOTAL",{"$nulls":9},994,52284.4]
["Initiate Information updates"]
["Call or email partner to request clarification of LOI or project reporting form b",0,0.25,0,0.25,13.15,0,0,80,1,20,1052]
["Review and enter data after receipt of information",0,0.25,0,0.25,13.15,0,0,80,1,20,1052]
["SUBTOTAL",{"$nulls":9},40,2104]
["Receive Information updates"]
["Review and enter contact or profile information updates received from partners via CHP Website c",0,0.25,0,0.25,13.15,0,0,48,1,12,631.2]
["SUBTOTAL",{"$nulls":9},12,631.2]
["Annual management review of CHP program d"]
["Management Review",8,0,0,8,663.04,0,0,1,1,8,663.04]
["SUBTOTAL",{"$nulls":9},8,663.04]
["TOTAL",{"$nulls":7},"290e",null,1071,56576.84]
[]
["* 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 All exisitng 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 328 partners at the end of 2010, 256 existing company/institutional partners and 28 of the 32 new company/institutional partners that join in 2011 will receive a reporting form.  All new end-users, project developers, consulting engineers, and equipment manufacturers (6 each of end users and equip. man.; and 7 each of project developers and consulting engineers) who join in 2011 will fill out a project form.  Thirty-three percent of the 6 utility partners who join in 2011 (i.e. 2 utilities) will receive a reporting form. State partners do not fill out a reporting form."]
[]
["b Assumed 25% of the 32 new company/institutional partners completing their LOI (i.e. 8 partners), and one of the two new state partners will require follow-up.  Additionally, 25% of the 284 partners completing CHP project forms or spreadsheets (i.e. 64 partners) will require follow-up in order to correctly complete the form."]
[]
["c Assumed 15% of new and existing company/institutional partners in the year 2011 (296 projected total partners) and 15% of new and existing state partners (22 projected total 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 2011 is 288, including 256 existing partners who are expected to complete project reporting spreadsheets, 28 new partners who will fill out both a LOI and project reporting form, and 4 new partners who will fill out only a LOI. The total number of unique state respondents submitting information in 2010 is 2, both of which are state/local/tribal government partners who will complete an LOI."]