{"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,88.3,56.4,21.46,"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.1,0,0,2,1,0.5,28.2]
["       Enter LOI information into Upshot/database",0,0.25,0,0.25,14.1,0,0,2,1,0.5,28.2]
["From Company and Institutional Partners"]
["       Review LOI",0,0.25,0,0.25,14.1,0,0,30,1,7.5,423]
["       Enter LOI information into Upshot/database",0,0.25,0,0.25,14.1,0,0,30,1,7.5,423]
["SUBTOTAL",null,null,null,1,56.4,{"$nulls":4},16,902.4]
["CHP Project Information Reporting Forms"]
["Prepare and send information spreadsheet to partners a",0,0.5,0,0.5,28.2,0,0,415,1,207.5,11703]
["Call partners to request reporting information",0,0.5,0,0.5,28.2,0,0,415,1,207.5,11703]
["Review completed information spreadsheet",0,1.25,0,1.25,70.5,0,0,415,1,518.75,29257.5]
["Enter information form into database and file copy of the form ",0,1.25,0,1.25,70.5,0,0,415,1,518.75,29257.5]
["SUBTOTAL",null,null,null,3.5,197.4,{"$nulls":4},1452.5,81921]
["Initiate Information updates"]
["Call or email partner to request clarification of LOI or project reporting form b",0,0.25,0,0.25,14.1,0,0,126,1,31.5,1776.6]
["Review and enter data after receipt of information",0,0.25,0,0.25,14.1,0,0,126,1,31.5,1776.6]
["SUBTOTAL",null,null,null,0.5,28.2,{"$nulls":4},63,3553.2]
["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.1,0,0,77,1,19.25,1085.7]
["SUBTOTAL",{"$nulls":9},19.25,1085.7]
["Annual management review of CHP program d"]
["Management Review",8,0,0,8,706.4,0,0,1,1,8,706.4]
["SUBTOTAL",{"$nulls":9},8,706.4]
["TOTAL",null,null,null,13.25,1002.5,null,null,"505 e",null,1558.75,88168.69999999998]
[]
["*  Labor rates for the respondent tables are derived from national average hourly labor rate from Bureau of Labor Statistics and consultations with three current  partners.  Each partner offered a base hourly wage rate for legal, managerial, technical and clerical occupations.  These consultations did not include benefits or overhead.  A loaded labor rate to reflect benefits and overhead for the respondent organizations was calculated by applying a 60% factor to the average of the base rates received from the consultations.  "]
[]
[]
["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 503 partners at the end of Year 1, 387 existing company/institutional partners and 28 of the 30 new company/institutional partners that join in Year 1 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 Year 1 will fill out a project form.  Thirty-three percent of the 6 utility partners who join in Year 1 (i.e. 2 utilities) will receive a reporting form. State partners do not fill out a reporting form."]
[]
["b Assumed 25% of the 30 new company/institutional partners completing their LOI (i.e. 7 partners), and one of the two new state partners will require follow-up.  Additionally, 25% of the 473 partners completing CHP project forms or spreadsheets (i.e. 118 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 1 (503 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 Year 1 is 505, including 415 existing partners who are expected to complete project reporting spreadsheets, 26 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 Year 1 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,88.3,56.4,21.46,"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.1,0,0,2,1,0.5,28.2]
["       Enter LOI information into Upshot/database",0,0.25,0,0.25,14.1,0,0,2,1,0.5,28.2]
["From Company and Institutional Partners"]
["       Review LOI",0,0.25,0,0.25,14.1,0,0,30,1,7.5,423]
["       Enter LOI information into Upshot/database",0,0.25,0,0.25,14.1,0,0,30,1,7.5,423]
["SUBTOTAL",null,null,null,1,56.4,{"$nulls":4},16,902.4]
["CHP Project Information Reporting Forms"]
["Prepare and send information spreadsheet to partners a",0,0.5,0,0.5,28.2,0,0,438,1,219,12351.6]
["Call partners to request reporting information",0,0.5,0,0.5,28.2,0,0,438,1,219,12351.6]
["Review completed information spreadsheet",0,1.25,0,1.25,70.5,0,0,438,1,547.5,30879]
["Enter information form into database and file copy of the form ",0,1.25,0,1.25,70.5,0,0,438,1,547.5,30879]
["SUBTOTAL",null,null,null,3.5,197.4,{"$nulls":4},1533,86461.2]
["Initiate Information updates"]
["Call or email partner to request clarification of LOI or project reporting form b",0,0.25,0,0.25,14.1,0,0,133,1,33.25,1875.3]
["Review and enter data after receipt of information",0,0.25,0,0.25,14.1,0,0,133,1,33.25,1875.3]
["SUBTOTAL",null,null,null,0.5,28.2,{"$nulls":4},66.5,3750.6]
["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.1,0,0,82,1,20.5,1156.2]
["SUBTOTAL",{"$nulls":9},20.5,1156.2]
["Annual management review of CHP program d"]
["Management Review",8,0,0,8,706.4,0,0,1,1,8,706.4]
["SUBTOTAL",{"$nulls":9},8,706.4]
["TOTAL",null,null,null,13.25,1002.5,null,null,"535 e",null,1644,92976.79999999999]
[]
["*  Labor rates for the respondent tables are derived from national average hourly labor rate from Bureau of Labor Statistics and consultations with three current  partners.  Each partner offered a base hourly wage rate for legal, managerial, technical and clerical occupations.  These consultations did not include benefits or overhead.  A loaded labor rate to reflect benefits and overhead for the respondent organizations was calculated by applying a 60% factor to the average of the base rates received from the consultations.  "]
[]
[]
["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 533 partners at the end of Year 2, 410 existing company/institutional partners and 28 of the 30 new company/institutional partners that join in Year 2 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 Year 1 will fill out a project form.  Thirty-three percent of the 6 utility partners who join in Year 1 (i.e. 2 utilities) will receive a reporting form. State partners do not fill out a reporting form."]
[]
["b Assumed 25% of the 30 new company/institutional partners completing their LOI (i.e. 7 partners), and one of the two new state partners will require follow-up.  Additionally, 25% of the 503 partners completing CHP project forms or spreadsheets (i.e. 125 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 1 (533 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 Year 2 is 535, including 438 existing partners who are expected to complete project reporting spreadsheets, 26 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 Year 1 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,88.3,56.4,21.46,"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.1,0,0,2,1,0.5,28.2]
["       Enter LOI information into Upshot/database",0,0.25,0,0.25,14.1,0,0,2,1,0.5,28.2]
["From Company and Institutional Partners"]
["       Review LOI",0,0.25,0,0.25,14.1,0,0,30,1,7.5,423]
["       Enter LOI information into Upshot/database",0,0.25,0,0.25,14.1,0,0,30,1,7.5,423]
["SUBTOTAL",null,null,null,1,56.4,{"$nulls":4},16,902.4]
["CHP Project Information Reporting Forms"]
["Prepare and send information spreadsheet to partners a",0,0.5,0,0.5,28.2,0,0,558,1,279,15735.6]
["Call partners to request reporting information",0,0.5,0,0.5,28.2,0,0,558,1,279,15735.6]
["Review completed information spreadsheet",0,1.25,0,1.25,70.5,0,0,558,1,697.5,39339]
["Enter information form into database and file copy of the form ",0,1.25,0,1.25,70.5,0,0,558,1,697.5,39339]
["SUBTOTAL",null,null,null,3.5,197.4,{"$nulls":4},1953,110149.2]
["Initiate Information updates"]
["Call or email partner to request clarification of LOI or project reporting form b",0,0.25,0,0.25,14.1,0,0,141,1,35.25,1988.1]
["Review and enter data after receipt of information",0,0.25,0,0.25,14.1,0,0,141,1,35.25,1988.1]
["SUBTOTAL",null,null,null,0.5,28.2,{"$nulls":4},70.5,3976.2]
["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.1,0,0,80,1,20,1128]
["SUBTOTAL",{"$nulls":9},20,1128]
["Annual management review of CHP program d"]
["Management Review",8,0,0,8,706.4,0,0,1,1,8,706.4]
["SUBTOTAL",{"$nulls":9},8,706.4]
["TOTAL",null,null,null,13.25,1002.5,null,null,"563 e",null,2067.5,116862.19999999998]
[]
["*  Labor rates for the respondent tables are derived from national average hourly labor rate from Bureau of Labor Statistics and consultations with three current  partners.  Each partner offered a base hourly wage rate for legal, managerial, technical and clerical occupations.  These consultations did not include benefits or overhead.  A loaded labor rate to reflect benefits and overhead for the respondent organizations was calculated by applying a 60% factor to the average of the base rates received from the consultations.  "]
[]
[]
["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 563 partners at the end of Year 3, 433 existing company/institutional partners and 28 of the 30 new company/institutional partners that join in Year 3 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 Year 1 will fill out a project form.  Thirty-three percent of the 6 utility partners who join in Year 3 (i.e. 2 utilities) will receive a reporting form. State partners do not fill out a reporting form."]
[]
["b Assumed 25% of the 30 new company/institutional partners completing their LOI (i.e. 7 partners), and one of the two new state partners will require follow-up.  Additionally, 25% of the 533 partners completing CHP project forms or spreadsheets (i.e. 133 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 3 (533 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 Year 3 is 563, including 558 existing partners who are expected to complete project reporting spreadsheets, 286 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 Year 3 is 2, both of which are state/local/tribal government partners who will complete an LOI."]