{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Project Information","EPM Information","Y1 1. EPM Assignment","Y1 2. Comprehensive Plan","Y1 3. Six-Month Update","Y1 4. Completion Report","CY 1. Comprehensive Plan","CY 2. Six-Month Update ","CY 3. Completion Report","Utility List","uploaddata","Revision History","uploaddata collection","Protection"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":10,"defined_names":820,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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"}

{"sheet":"Project Information","index":0,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,"Energy Project Manager (EPM) Project Information",null,null,null,null,null,{"$f":"IF(COUNTIF(F3:F21, \"=Required\")=0, \"Section Complete!\", COUNTIF(F3:F21, \"=Required\") & \" Fields still need to be Entered\")","v":"14 Fields still need to be Entered"}]
[null,null,null,"Input or Select Dropdown",null,null,null,"Example Entry and Format"]
[null,"Serving Utility ",null,null,{"$f":"IF(ISBLANK(D3), \"<<<\", \"\")","v":"<<<"},{"$f":"IF(ISBLANK(D3), \"Required\", \"\")","v":"Required"},null,"Power Utility Plus"]
[null,"Proposal Submitter Name",null,null,"<<<",{"$f":"IF(ISBLANK(D4), \"Required\", \"\")","v":"Required"},null,"Jane Doe"]
[null,"Proposal Submitter Email",null,null,"<<<","Required",null,"john.doe@acmeindustrial.com"]
[null,"Proposal Submitter Phone",null,null,"<<<","Required",null,"425-999-0000"]
[null,"Company Name",null,null,"<<<","Required",null,"ACME Manufacturing"]
[null,"Company Mailing Address",null,null,"<<<","Required",null,"P.O. Box 5000 (Corporate HQ)"]
[null,"Company City",null,null,"<<<","Required",null,"Metro City"]
[null,"Company State",null,null,"<<<","Required",null,"OR"]
[null,"Company ZIP",null,null,"<<<","Required",null,94596]
[null,"NAICS Code",null,null,"<<<","Required",null,12345]
[null,"Facility Contact Name (employee at Facility)",null,null,{"$f":"IF(ISBLANK(D13), \"<<<\", \"\")","v":"<<<"},{"$f":"IF(ISBLANK(D13), \"Required\", \"\")","v":"Required"},null,"John Doe"]
[null,"Facility Contact Job Title",null,null,"<<<","Required",null,"Maintenance Manager"]
[null,"Facility Contact Phone Number",null,null,"<<<","Required",null,"360-800-0000"]
[null,"Facility Contact Email",null,null,"<<<","Required",null,"john.doe@acmeindustrial.com"]
[null,"EPM Name (if different than Facility Contact)",null,null,"<<<",{"$f":"IF(ISBLANK(D16), \"Optional\", \"\")","v":"Optional"},null,"John Doe"]
[null,"EPM Job Title",null,null,"<<<","Optional",null,"Maintenance Manager"]
[null,"EPM Phone Number",null,null,"<<<","Optional",null,"360-800-0000"]
[null,"EPM Email",null,null,"<<<","Optional",null,"john.doe@acmeindustrial.com"]
[null,"Energy Smart Industrial Partner (ESIP) Name",null,null,"<<<",{"$f":"IF(ISBLANK(D21), \"Optional\", \"\")","v":"Optional"},null,"John Smith"]
[null,"Energy Smart Industrial (ESI) Project Number",null,null,"<<<",{"$f":"IF(ISBLANK(D22), \"Optional\", \"\")","v":"Optional"},null,"BETTP_000001"]

{"sheet":"EPM Information","index":1,"n_rows":45,"n_cols":10,"rows_kept":45,"cut":false,"hidden":false,"merged":[[40,1,40,3],[41,1,41,3],[42,1,42,3],[45,1,48,4],[19,1,21,1],[34,1,37,4],[29,1,29,3],[30,1,30,3],[31,1,31,3],[8,1,9,1],[10,1,11,1],[13,5,13,6],[7,7,7,8],[15,1,18,1]]}
[null,"Energy Project Manager (EPM) Project Information"]
[null,"Project Sector",null,"Industrial"]
[null,"Busbar Factor",null,1.09056]
[null,"Incentive Rate",null,2.5000000000000001E-2,"per kWh"]
[null,"Minimum Annual Payment",null,25000]
[null,"Maximum Annual Payment",null,250000]
[]
[null,"Year ","Milestone",null,"Base Annual Salary"," Compensation Load Factor (%)","Fully Loaded Salary","Savings (kWh)"]
[null,"First Year","Comprehensive Plan","Initial",{"$f":"'Y1 2. Comprehensive Plan'!E8","v":0},{"$f":"'CY 1. Comprehensive Plan'!E10","v":0},{"$f":"E9*(1+F9)","v":0},"Savings Goal",{"$f":"F17","v":0}]
[null,null,"Completion Report","Final",{"$f":"'Y1 4. Completion Report'!E8","v":0},{"$f":"'Y1 4. Completion Report'!E9","v":0},{"$f":"E10*(1+F10)","v":0},"Acquired Savings",{"$f":"G19","v":0}]
[null,"Continuation Year","Comprehensive Plan","Initial",{"$f":"'CY 1. Comprehensive Plan'!E9","v":0},{"$f":"'CY 1. Comprehensive Plan'!E10","v":0},{"$f":"E11*(1+F11)","v":0},"Savings Goal",{"$f":"'CY 1. Comprehensive Plan'!E8","v":0}]
[null,null,"Completion Report","Final",{"$f":"'CY 3. Completion Report'!E8","v":0},{"$f":"'CY 3. Completion Report'!E9","v":0},{"$f":"E12*(1+F12)","v":0},"Acquired Savings",{"$f":"'CY 3. Completion Report'!E7","v":0}]
[null,"Savings and Payment Summary"]
[null,null,null,null,null,"Savings"]
[null,"Year","Month","Milestone","Date","Projected Busbar Savings (kWh)","Booked Busbar Savings (kWh)","Max Payment","Utility Payment Cap","Payment"]
[null,"First Year","Month 0 ","EPM Assignment",{"$f":"'Y1 1. EPM Assignment'!E9","v":0},null,null,25000,{"$f":"commencement_cap","v":0},{"$f":"IF(ISBLANK(commencement_cap),H16,MIN(H16:I16))","v":25000}]
[null,null,"Month 3","Comprehensive Plan",{"$f":"DATE(YEAR(E16),MONTH(E16)+3,DAY(E16))","v":"1900-03-31"},{"$f":"'Y1 2. Comprehensive Plan'!E7","v":0},null,{"$f":"MAX(MIN(F17*D4,G9)*(100/3)%-J16,0)","v":0},{"$f":"'Y1 2. Comprehensive Plan'!pts_install_cap","v":0},{"$f":"IF(ISBLANK('Y1 2. Comprehensive Plan'!pts_install_cap),H17,MIN(H17:I17))","v":0}]
[null,null,"Month 6","Month 6 Payment",{"$f":"DATE(YEAR(E16),MONTH(E16)+6,DAY(E16))","v":"1900-06-30"},{"$f":"'Y1 3. Six-Month Update'!E8","v":0},{"$f":"'Y1 3. Six-Month Update'!E7","v":0},{"$f":"MAX(((MIN(G9,(F18+G18)*D4)*(200/3)%)-(J16+J17)),0)","v":0},{"$f":"'Y1 3. Six-Month Update'!pts_install_cap","v":0},{"$f":"IF(ISBLANK('Y1 3. Six-Month Update'!pts_install_cap),H18,MIN(H18:I18))","v":0}]
[null,null,"Month 12-18","Completion Report",{"$f":"IF(ISBLANK(E30), DATE(YEAR(E16)+1,MONTH(E16),DAY(E16)),MAX(DATE(YEAR(E16)+1,MONTH(E16),DAY(E16)),E30))","v":"1900-12-31"},null,{"$f":"'Y1 4. Completion Report'!E7","v":0},{"$f":"MAX(MIN(G10,I10*D4)-SUM(J16:J18),0)","v":0},{"$f":"'Y1 4. Completion Report'!pts_install_cap","v":0},{"$f":"IF(ISBLANK('Y1 4. Completion Report'!pts_install_cap),H19,MIN(H19:I19))","v":0}]
[null,"Continuation Year","Month 0","Comprehensive Plan",{"$f":"IF(ISBLANK('CY 1. Comprehensive Plan'!E7), \"-\",'CY 1. Comprehensive Plan'!E7)","v":"-"},{"$f":"'CY 1. Comprehensive Plan'!E8","v":0},null,{"$f":"(100/3)%*MIN(G11,I11*D4)","v":0},{"$f":"'CY 1. Comprehensive Plan'!pts_install_cap","v":0},{"$f":"IF(ISBLANK('CY 1. Comprehensive Plan'!pts_install_cap),H20,MIN(H20:I20))","v":0}]
[null,null,"Month 6","Month 6 Payment",{"$f":"IF(ISBLANK('CY 1. Comprehensive Plan'!E7), \"-\", DATE(YEAR('CY 1. Comprehensive Plan'!E7), MONTH('CY 1. Comprehensive Plan'!E7)+6,DAY('CY 1. Comprehensive Plan'!E7)))","v":"-"},{"$f":"'CY 2. Six-Month Update '!E8","v":0},{"$f":"'CY 2. Six-Month Update '!E7","v":0},{"$f":"(200/3)%*MIN(G11,SUM(F21:G21)*D4)-J20","v":0},{"$f":"'CY 2. Six-Month Update '!pts_install_cap","v":0},{"$f":"IF(ISBLANK('CY 2. Six-Month Update '!pts_install_cap),H21,MIN(H21:I21))","v":0}]
[null,null,"Month 12-18"," Completion Report",{"$f":"IF(ISBLANK('CY 1. Comprehensive Plan'!E7), \"-\", DATE(YEAR('CY 1. Comprehensive Plan'!E7), MONTH('CY 1. Comprehensive Plan'!E7)+6,DAY('CY 1. Comprehensive Plan'!E7)))","v":"-"},null,{"$f":"'CY 3. Completion Report'!E7","v":0},{"$f":"MIN(G12,I12*D4)-SUM(J20:J21)","v":0},{"$f":"'CY 3. Completion Report'!pts_install_cap","v":0},{"$f":"IF(ISBLANK('CY 3. Completion Report'!pts_install_cap),H22,MIN(H22:I22))","v":0}]
[]
[]
[null,"Completion Report Extension"]
[null,"Completed by BPA when EPM Agreement Submitted"]
[]
[null,"With BPA approval, the Utility may extend the EPM completion report deadline from 12 months to a maximum of 18 months after EPM commencement."]
[null,"First Year  ",null,null,"Input or Select Dropdown",null,"Example Entry and Format"]
[null,"First Year EPM Completion Report Extension Date",null,null,null,null,"2012-06-12"]
[null,"Engineering Technical Review: Name",null,null,null,null,"Richard Miller"]
[null,"Engineering Technical Review: Date",null,null,null,null,"2012-06-12"]
[]
[null,"Notes"]
[]
[]
[]
[]
[]
[null,"Continuation Year",null,null,"Input or Select Dropdown",null,"Example Entry and Format"]
[null,"Continuation Year EPM Completion Report Extension Date",null,null,null,null,"2012-06-12"]
[null,"Engineering Technical Review: Name",null,null,null,null,"Richard Miller"]
[null,"Engineering Technical Review: Date",null,null,null,null,"2012-06-12"]
[]
[null,"Notes"]

{"sheet":"Y1 1. EPM Assignment","index":2,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[13,1,16,4],[29,1,29,2],[35,1,38,4],[23,1,23,2]]}
[null,{"$f":"CONCATENATE(\"EPM:\",IF('Project Information'!D17=\"\",\"EPM Name?\",CONCATENATE('Project Information'!D7,\" - \",'Project Information'!D17)))","v":"EPM:EPM Name?"}]
[null,"EPM Submission #1: EPM Assignment"]
[]
[null,"EPM Assignment",null,null,null,null,null,{"$f":"IF(COUNTIF(D7:D11, \"                               Required\")=0, \"All Required Fields Complete!\", \"BPA Use:  \" & COUNTIF(D7:D11, \"                               Required\") & \" Fields still need to be Entered\")","v":"BPA Use:  5 Fields still need to be Entered"}]
[null,"Completed by BPA when EPM Agreement Submitted"]
[null,null,null,null,"Input or Select Dropdown",null,"Validation","Example Entry and Format"]
[null,"EPM Agreement Received -Date",null,{"$f":"IF(ISBLANK(E7), \"                               Required\", \"\")","v":"                               Required"},null,null,"Date","2012-06-12"]
[null,"EPM Agreement File Name",null,{"$f":"IF(ISBLANK(E8), \"                               Required\", \"\")","v":"                               Required"},null,null,null,"ProjectName_PTS_Design.pdf"]
[null,"EPM Commencement Date",null,{"$f":"IF(ISBLANK(E9), \"                               Required\", \"\")","v":"                               Required"},null,null,null,"2012-06-12"]
[null,"Engineering Technical Review: Name",null,{"$f":"IF(ISBLANK(E10), \"                               Required\", \"\")","v":"                               Required"},null,null,null,"Richard Miller"]
[null,"Engineering Technical Review: Date",null,{"$f":"IF(ISBLANK(E11), \"                               Required\", \"\")","v":"                               Required"},null,null,null,"2012-06-12"]
[]
[null,"Notes"]
[]
[]
[]
[]
[]
[null,"EPM Funding Cap",null,null,null,null,null,"Optional "]
[null,"Utility completes"]
[]
[null,null,null,null,"Input or Select Dropdown",null,null,"Example Entry and Format"]
[null,"EPMProject Payments Cap"]
[null,"The customer may cap the cumulative EPM Project Payments to a value less than the maximum allowable.  Each submission will display the cumulative EPM payments in comparison to the cap set by the utility."]
[null,"Maximum cumulative EPM Project Payment (Program Formula)",null,null,{"$f":"MIN('EPM Information'!G9,'EPM Information'!I9*'EPM Information'!D4)","v":0}]
[null,"Utility cumulative EPM Project Payment Cap",null,{"$f":"IF(ISBLANK(A26), \"                               Optional\", \"\")","v":"                               Optional"},null,null,null,25000]
[]
[null,null,null,null,"Input or Select Dropdown",null,null,"Example Entry and Format"]
[null,"EPM Commencement Payment Cap"]
[null,"The customer may cap the EPM Commencement Payment to a value less than the maximum allowable."]
[null,"Maximum allowable EPM Commencement Payment",null,null,{"$f":"'EPM Information'!H16","v":25000}]
[null,"Utility EPM Commencement Payment Cap",null,{"$f":"IF(ISBLANK(A32), \"                               Optional\", \"\")","v":"                               Optional"},null,null,null,25000]
[null,"EPM Commencement Payment",null,null,{"$f":"IF(ISBLANK(pts_install_cap),E31,MIN(E31:E32))","v":25000},null,null,"Lessor of (1) Program Formula and (2) Utility Cap"]
[]
[null,"Notes"]
[]
[]
[]
[]
[]
[null,"Utility Generates Submittal\nUtility reviews EPM Assignment and sets optional payment caps. "]
[null,null,null,null,{"$f":"CONCATENATE(\"Submittal Upload Selected: \",IF(uploaddata!D2=\"\",\"No Upload Selected\",CONCATENATE(\"No. \",uploaddata!D2)))","v":"Submittal Upload Selected: No. 1"}]

{"sheet":"Y1 2. Comprehensive Plan","index":3,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[[13,1,16,4],[23,1,23,2],[31,1,34,4]]}
[null,{"$f":"CONCATENATE(\"EPM:\",IF('Project Information'!D17=\"\",\"EPM Name?\",CONCATENATE('Project Information'!D7,\" - \",'Project Information'!D17)))","v":"EPM:EPM Name?"}]
[null,"EPM Submission #2: Comprehensive Plan"]
[]
[null,"Comprehensive Plan",null,null,null,null,null,{"$f":"IF(COUNTIF(D7:D11, \"                               Required\")=0, \"All Required Fields Complete!\", \"BPA Use:  \" & COUNTIF(D7:D11, \"                               Required\") & \" Fields still need to be Entered\")","v":"BPA Use:  5 Fields still need to be Entered"}]
[null,"Completed by BPA when EPM Agreement Submitted"]
[null,null,null,null,"Input or Select Dropdown",null,"Validation","Example Entry and Format"]
[null,"EPM Energy Savings Goal from Comprehensive Plan",null,{"$f":"IF(ISBLANK(E7), \"                               Required\", \"\")","v":"                               Required"},null,"kWh","Date",5000000]
[null,"INITIAL - EPM Base Annual Salary",null,{"$f":"IF(ISBLANK(E8), \"                               Required\", \"\")","v":"                               Required"},null,null,null,100000]
[null,"INITIAL - EPM Compensation Load Factor (%)",null,{"$f":"IF(ISBLANK(E9), \"                               Required\", \"\")","v":"                               Required"},null,null,null,0.1]
[null,"Engineering Technical Review: Name",null,{"$f":"IF(ISBLANK(E10), \"                               Required\", \"\")","v":"                               Required"},null,null,null,"Richard Miller"]
[null,"Engineering Technical Review: Date",null,{"$f":"IF(ISBLANK(E11), \"                               Required\", \"\")","v":"                               Required"},null,null,null,"2012-06-12"]
[]
[null,"Notes"]
[]
[]
[]
[]
[]
[null,"Comprehensive Plan Funding Cap",null,null,null,null,null,"Optional "]
[null,"Utility completes"]
[]
[null,null,null,null,"Input or Select Dropdown",null,null,"Example Entry and Format"]
[null,"EPM Comprehensive Plan Payment Cap"]
[null,"The customer may cap the EPM Commencement Payment to a value less than the maximum allowable."]
[null,"Year 1 - Cumulative Prior EPM Payments ",null,null,{"$f":"'EPM Information'!J16","v":25000}]
[null,"Year 1 - Utility Cap of Cumulative Prior EPM Payments ",null,null,{"$f":"IF(ISBLANK('Y1 1. EPM Assignment'!E26),\"Not Set\", 'Y1 1. EPM Assignment'!E26)","v":"Not Set"}]
[null,"Maximum allowable Comprehensive Plan Payment",null,null,{"$f":"'EPM Information'!H17","v":0}]
[null,"Utility Comprehensive Plan Payment Cap",null,{"$f":"IF(ISBLANK(A28), \"                               Optional\", \"\")","v":"                               Optional"},null,null,null,25000]
[null,"Comprehensive Plan Payment",null,null,{"$f":"IF(ISBLANK(pts_install_cap),E27,MIN(E27:E28))","v":0},null,null,"Lessor of (1) Program Formula and (2) Utility Cap"]
[]
[null,"Notes"]
[]
[]
[]
[]
[]
[null,"Utility Generates Submittal\nUtility reviews EPM Comprehensive Plan. "]
[null,null,null,null,{"$f":"CONCATENATE(\"Submittal Upload Selected: \",IF(uploaddata!D2=\"\",\"No Upload Selected\",CONCATENATE(\"No. \",uploaddata!D2)))","v":"Submittal Upload Selected: No. 1"}]

{"sheet":"Y1 3. Six-Month Update","index":4,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[[12,1,15,4],[22,1,22,2],[30,1,33,4]]}
[null,{"$f":"CONCATENATE(\"EPM:\",IF('Project Information'!D17=\"\",\"EPM Name?\",CONCATENATE('Project Information'!D7,\" - \",'Project Information'!D17)))","v":"EPM:EPM Name?"}]
[null,"EPM Submission  #2: Six Month Update"]
[]
[null,"Six-Month Update",null,null,null,null,null,{"$f":"IF(COUNTIF(D7:D10, \"                               Required\")=0, \"All Required Fields Complete!\", \"BPA Use:  \" & COUNTIF(D7:D10, \"                               Required\") & \" Fields still need to be Entered\")","v":"BPA Use:  4 Fields still need to be Entered"}]
[null,"Completed by BPA when Updated Comprehensive Plan is submitted"]
[null,null,null,null,"Input or Select Dropdown",null,"Validation","Example Entry and Format"]
[null,"Total Busbar Savings from Completed Projects",null,{"$f":"IF(ISBLANK(E7), \"                               Required\", \"\")","v":"                               Required"},null,"kWh",null,1000000]
[null,"Total Savings from Planned Projects",null,{"$f":"IF(ISBLANK(E8), \"                               Required\", \"\")","v":"                               Required"},null,"kWh",null,1000000]
[null,"Engineering Technical Review: Name",null,{"$f":"IF(ISBLANK(E9), \"                               Required\", \"\")","v":"                               Required"},null,null,null,"Richard Miller"]
[null,"Engineering Technical Review: Date",null,{"$f":"IF(ISBLANK(E10), \"                               Required\", \"\")","v":"                               Required"},null,null,null,"2012-06-12"]
[]
[null,"Notes"]
[]
[]
[]
[]
[]
[null,"Six-Month Funding Cap",null,null,null,null,null,"Optional "]
[null,"Utility completes"]
[]
[null,null,null,null,"Input or Select Dropdown",null,null,"Example Entry and Format"]
[null,"EPM Six Month-Update Payment Cap"]
[null,"The customer may cap the EPM Commencement Payment to a value less than the maximum allowable."]
[null,"Year 1 - Cumulative Prior EPM Payments ",null,null,{"$f":"SUM('EPM Information'!J16:J17)","v":25000}]
[null,"Year 1 - Utility Cap of Cumulative Prior EPM Payments ",null,null,{"$f":"IF(ISBLANK('Y1 1. EPM Assignment'!E26),\"Not Set\", 'Y1 1. EPM Assignment'!E26)","v":"Not Set"}]
[null,"Maximum allowable Six-Month Update Payment",null,null,{"$f":"'EPM Information'!H18","v":0}]
[null,"Utility Six-Month Update Payment Cap",null,{"$f":"IF(ISBLANK(A27), \"                               Optional\", \"\")","v":"                               Optional"},null,null,null,25000]
[null,"Six-Month Update Payment",null,null,{"$f":"IF(ISBLANK(pts_install_cap),E26,MIN(E26:E27))","v":0},null,null,"Lessor of (1) Program Formula and (2) Utility Cap"]
[]
[null,"Notes"]
[null,"N/A"]
[]
[]
[]
[]
[null,"Utility Generates Submittal\nUtility reviews EPM Six-Month Update and sets optional payment caps. "]
[null,null,null,null,{"$f":"CONCATENATE(\"Submittal Upload Selected: \",IF(uploaddata!D2=\"\",\"No Upload Selected\",CONCATENATE(\"No. \",uploaddata!D2)))","v":"Submittal Upload Selected: No. 1"}]

{"sheet":"Y1 4. Completion Report","index":5,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[[13,1,16,4],[23,1,23,2],[31,1,34,4]]}
[null,{"$f":"CONCATENATE(\"EPM:\",IF('Project Information'!D17=\"\",\"EPM Name?\",CONCATENATE('Project Information'!D7,\" - \",'Project Information'!D17)))","v":"EPM:EPM Name?"}]
[null,"EPM Submission #5: Year 1 Completion Report"]
[]
[null," Year 1 Completion Report",null,null,null,null,null,{"$f":"IF(COUNTIF(D7:D11, \"                               Required\")=0, \"All Required Fields Complete!\", \"BPA Use:  \" & COUNTIF(D7:D11, \"                               Required\") & \" Fields still need to be Entered\")","v":"BPA Use:  5 Fields still need to be Entered"}]
[null,"Completed by BPA when the Year 1 Completion Report is submitted"]
[null,null,null,null,"Input or Select Dropdown",null,"Validation","Example Entry and Format"]
[null,"Total Busbar Savings from Completed Projects",null,{"$f":"IF(ISBLANK(E7), \"                               Required\", \"\")","v":"                               Required"},null,"kWh","Date",5000000]
[null,"FINAL - EPM Base Annual Salary",null,{"$f":"IF(ISBLANK(E8), \"                               Required\", \"\")","v":"                               Required"},null,null,null,100000]
[null,"FINAL - EPM Compensation Load Factor (%)",null,{"$f":"IF(ISBLANK(E9), \"                               Required\", \"\")","v":"                               Required"},null,null,null,0.1]
[null,"Engineering Technical Review: Name",null,{"$f":"IF(ISBLANK(E10), \"                               Required\", \"\")","v":"                               Required"},null,null,null,"Richard Miller"]
[null,"Engineering Technical Review: Date",null,{"$f":"IF(ISBLANK(E11), \"                               Required\", \"\")","v":"                               Required"},null,null,null,"2012-06-12"]
[]
[null,"Notes"]
[]
[]
[]
[]
[]
[null,"Comprehensive Plan Funding Cap",null,null,null,null,null,"Optional "]
[null,"Utility completes"]
[]
[null,null,null,null,"Input or Select Dropdown",null,null,"Example Entry and Format"]
[null,"EPM Completion Report Payment Cap"]
[null,"The customer may cap the EPM Completion Report Payment to a value less than the maximum allowable."]
[null,"Year 1 - Cumulative Prior EPM Payments ",null,null,{"$f":"SUM('EPM Information'!J16:J18)","v":25000}]
[null,"Year 1 - Utility Cap of Cumulative Prior EPM Payments ",null,null,{"$f":"IF(ISBLANK('Y1 1. EPM Assignment'!E26),\"Not Set\", 'Y1 1. EPM Assignment'!E26)","v":"Not Set"}]
[null,"Maximum allowable Completion Report Payment",null,null,{"$f":"'EPM Information'!H19","v":0}]
[null,"Utility Completion Report Payment Cap",null,{"$f":"IF(ISBLANK(A28), \"                               Optional\", \"\")","v":"                               Optional"},null,null,null,25000]
[null,"Completion Report Payment",null,null,{"$f":"IF(ISBLANK(pts_install_cap),E27,MIN(E27:E28))","v":0},null,null,"Lessor of (1) Program Formula and (2) Utility Cap"]
[]
[null,"Notes"]
[]
[]
[]
[]
[]
[null,"Utility Generates Submittal\nUtility reviews EPM Completion Report and sets optional payment caps. "]
[null,null,null,null,{"$f":"CONCATENATE(\"Submittal Upload Selected: \",IF(uploaddata!D2=\"\",\"No Upload Selected\",CONCATENATE(\"No. \",uploaddata!D2)))","v":"Submittal Upload Selected: No. 1"}]

{"sheet":"CY 1. Comprehensive Plan","index":6,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[14,1,17,4],[29,1,29,2],[35,1,38,4],[23,1,23,2]]}
[null,{"$f":"CONCATENATE(\"EPM:\",IF('Project Information'!D17=\"\",\"EPM Name?\",CONCATENATE('Project Information'!D7,\" - \",'Project Information'!D17)))","v":"EPM:EPM Name?"}]
[null,"EPM Submission Continuation Year #1: Comprehensive Plan"]
[]
[null,"Comprehensive Plan",null,null,null,null,null,{"$f":"IF(COUNTIF(D8:D12, \"                               Required\")=0, \"All Required Fields Complete!\", \"BPA Use:  \" & COUNTIF(D8:D12, \"                               Required\") & \" Fields still need to be Entered\")","v":"BPA Use:  5 Fields still need to be Entered"}]
[null,"Completed by BPA when EPM Agreement Submitted"]
[null,null,null,null,"Input or Select Dropdown",null,"Validation","Example Entry and Format"]
[null,"Continuation Year Commencement Date",null,{"$f":"IF(ISBLANK(E7), \"                               Required\", \"\")","v":"                               Required"},null,null,null,"2012-06-12"]
[null,"EPM Energy Savings Goal from Comprehensive Plan",null,"                               Required",null,"kWh","Date",5000000]
[null,"INITIAL - EPM Base Annual Salary",null,"                               Required",null,null,null,100000]
[null,"INITIAL - EPM Compensation Load Factor (%)",null,"                               Required",null,null,null,0.1]
[null,"Engineering Technical Review: Name",null,"                               Required",null,null,null,"Richard Miller"]
[null,"Engineering Technical Review: Date",null,"                               Required",null,null,null,"2012-06-12"]
[]
[null,"Notes"]
[]
[]
[]
[]
[]
[null,"Comprehensive Plan Funding Cap",null,null,null,null,null,"Optional "]
[null,"Utility completes"]
[]
[null,"EPM Project Payments Cap"]
[null,"The customer may cap the cumulative EPM Project Payments to a value less than the maximum allowable.  Each submission will display the cumulative EPM payments in comparison to the cap set by the utility."]
[null,"Maximum cumulative EPM Project Payment (Program Formula)",null,null,{"$f":"MIN('EPM Information'!G11,'EPM Information'!I11*'EPM Information'!D4)","v":0}]
[null,"Utility cumulative EPM Project Payment Cap",null,{"$f":"IF(ISBLANK(A26), \"                               Optional\", \"\")","v":"                               Optional"},null,null,null,25000]
[]
[null,null,null,null,"Input or Select Dropdown",null,null,"Example Entry and Format"]
[null,"EPM Comprehensive Plan Payment Cap"]
[null,"The customer may cap the EPM Commencement Payment to a value less than the maximum allowable."]
[null,"Maximum allowable Comprehensive Plan Payment",null,null,{"$f":"'EPM Information'!H20","v":0}]
[null,"Utility Comprehensive Plan Payment Cap",null,{"$f":"IF(ISBLANK(A32), \"                               Optional\", \"\")","v":"                               Optional"},null,null,null,25000]
[null,"Comprehensive Plan Payment",null,null,{"$f":"IF(ISBLANK(pts_install_cap),E31,MIN(E31:E32))","v":0},null,null,"Lessor of (1) Program Formula and (2) Utility Cap"]
[]
[null,"Notes"]
[]
[]
[]
[]
[]
[null,"Utility Generates Submittal\nUtility reviews EPM Comprehensive Plan. "]
[null,null,null,null,{"$f":"CONCATENATE(\"Submittal Upload Selected: \",IF(uploaddata!D2=\"\",\"No Upload Selected\",CONCATENATE(\"No. \",uploaddata!D2)))","v":"Submittal Upload Selected: No. 1"}]

{"sheet":"CY 2. Six-Month Update ","index":7,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[[12,1,15,4],[22,1,22,2],[30,1,33,4]]}
[null,{"$f":"CONCATENATE(\"EPM:\",IF('Project Information'!D17=\"\",\"EPM Name?\",CONCATENATE('Project Information'!D7,\" - \",'Project Information'!D17)))","v":"EPM:EPM Name?"}]
[null,"EPM Submission Continuation Year #2: Six Month Update"]
[]
[null,"Six-Month Update",null,null,null,null,null,{"$f":"IF(COUNTIF(D7:D10, \"                               Required\")=0, \"All Required Fields Complete!\", \"BPA Use:  \" & COUNTIF(D7:D10, \"                               Required\") & \" Fields still need to be Entered\")","v":"BPA Use:  4 Fields still need to be Entered"}]
[null,"Completed by BPA when Updated Comprehensive Plan is submitted"]
[null,null,null,null,"Input or Select Dropdown",null,"Validation","Example Entry and Format"]
[null,"Total Busbar Savings from Completed Projects",null,{"$f":"IF(ISBLANK(E7), \"                               Required\", \"\")","v":"                               Required"},null,"kWh",null,1000000]
[null,"Total Savings from Planned Projects",null,{"$f":"IF(ISBLANK(E8), \"                               Required\", \"\")","v":"                               Required"},null,"kWh",null,1000000]
[null,"Engineering Technical Review: Name",null,{"$f":"IF(ISBLANK(E9), \"                               Required\", \"\")","v":"                               Required"},null,null,null,"Richard Miller"]
[null,"Engineering Technical Review: Date",null,{"$f":"IF(ISBLANK(E10), \"                               Required\", \"\")","v":"                               Required"},null,null,null,"2012-06-12"]
[]
[null,"Notes"]
[]
[]
[]
[]
[]
[null,"Six-Month Funding Cap",null,null,null,null,null,"Optional "]
[null,"Utility completes"]
[]
[null,null,null,null,"Input or Select Dropdown",null,null,"Example Entry and Format"]
[null,"EPM Commencement Payment Cap"]
[null,"The customer may cap the EPM Commencement Payment to a value less than the maximum allowable."]
[null,"Continuation Year - Cumulative Prior EPM Payments ",null,null,{"$f":"'EPM Information'!J20","v":0}]
[null,"Continuation Year - Utility Cap of Cumulative Prior EPM Payments ",null,null,{"$f":"IF(ISBLANK('CY 1. Comprehensive Plan'!E26),\"Not Set\",'CY 1. Comprehensive Plan'!E26)","v":"Not Set"}]
[null,"Maximum allowable Comprehensive Payment",null,null,{"$f":"'EPM Information'!H21","v":0}]
[null,"Utility Comprehensive Payment Cap",null,{"$f":"IF(ISBLANK(A27), \"                               Optional\", \"\")","v":"                               Optional"},null,null,null,25000]
[null,"Comprehensive Plan Payment",null,null,{"$f":"IF(ISBLANK(pts_install_cap),E26,MIN(E26:E27))","v":0},null,null,"Lessor of (1) Program Formula and (2) Utility Cap"]
[]
[null,"Notes"]
[]
[]
[]
[]
[]
[null,"Utility Generates Submittal\nUtility reviews EPM Six-Month Update and sets optional payment caps. "]
[null,null,null,null,{"$f":"CONCATENATE(\"Submittal Upload Selected: \",IF(uploaddata!D2=\"\",\"No Upload Selected\",CONCATENATE(\"No. \",uploaddata!D2)))","v":"Submittal Upload Selected: No. 1"}]

{"sheet":"CY 3. Completion Report","index":8,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[[13,1,16,4],[23,1,23,2],[31,1,34,4]]}
[null,{"$f":"CONCATENATE(\"EPM:\",IF('Project Information'!D17=\"\",\"EPM Name?\",CONCATENATE('Project Information'!D7,\" - \",'Project Information'!D17)))","v":"EPM:EPM Name?"}]
[null,"EPM Submission Continuation Year #3: Completion Report"]
[]
[null," Year 1 Completion Report",null,null,null,null,null,{"$f":"IF(COUNTIF(D7:D11, \"                               Required\")=0, \"All Required Fields Complete!\", \"BPA Use:  \" & COUNTIF(D7:D11, \"                               Required\") & \" Fields still need to be Entered\")","v":"BPA Use:  5 Fields still need to be Entered"}]
[null,"Completed by BPA when the Year 1 Completion Report is submitted"]
[null,null,null,null,"Input or Select Dropdown",null,"Validation","Example Entry and Format"]
[null,"Total Busbar Savings from Completed Projects",null,{"$f":"IF(ISBLANK(E7), \"                               Required\", \"\")","v":"                               Required"},null,"kWh","Date",5000000]
[null,"FINAL - EPM Base Annual Salary",null,{"$f":"IF(ISBLANK(E8), \"                               Required\", \"\")","v":"                               Required"},null,null,null,100000]
[null,"FINAL - EPM Compensation Load Factor (%)",null,{"$f":"IF(ISBLANK(E9), \"                               Required\", \"\")","v":"                               Required"},null,null,null,0.1]
[null,"Engineering Technical Review: Name",null,{"$f":"IF(ISBLANK(E10), \"                               Required\", \"\")","v":"                               Required"},null,null,null,"Richard Miller"]
[null,"Engineering Technical Review: Date",null,{"$f":"IF(ISBLANK(E11), \"                               Required\", \"\")","v":"                               Required"},null,null,null,"2012-06-12"]
[]
[null,"Notes"]
[]
[]
[]
[]
[]
[null,"Comprehensive Plan Funding Cap",null,null,null,null,null,"Optional "]
[null,"Utility completes"]
[]
[null,null,null,null,"Input or Select Dropdown",null,null,"Example Entry and Format"]
[null,"EPM Completion Report Payment Cap"]
[null,"The customer may cap the EPM Completion Report Payment to a value less than the maximum allowable."]
[null,"Continuation Year - Cumulative Prior EPM Payments ",null,null,{"$f":"SUM('EPM Information'!J20:J21)","v":0}]
[null,"Continuation Year - Utility Cap of Cumulative Prior EPM Payments ",null,null,{"$f":"IF(ISBLANK('CY 1. Comprehensive Plan'!E26),\"Not Set\",'CY 1. Comprehensive Plan'!E26)","v":"Not Set"}]
[null,"Maximum allowable Completion Report Payment",null,null,{"$f":"'EPM Information'!H22","v":0}]
[null,"Utility Completion Report Payment Cap",null,{"$f":"IF(ISBLANK(A28), \"                               Optional\", \"\")","v":"                               Optional"},null,null,null,25000]
[null,"Completion Report Payment",null,null,{"$f":"IF(ISBLANK(pts_install_cap),E27,MIN(E27:E28))","v":0},null,null,"Lessor of (1) Program Formula and (2) Utility Cap"]
[]
[null,"Notes"]
[]
[]
[]
[]
[]
[null,"Utility Generates Submittal\nUtility reviews Completion Report and sets optional payment caps. "]
[null,null,null,null,{"$f":"CONCATENATE(\"Submittal Upload Selected: \",IF(uploaddata!D2=\"\",\"No Upload Selected\",CONCATENATE(\"No. \",uploaddata!D2)))","v":"Submittal Upload Selected: No. 1"}]

{"sheet":"Utility List","index":9,"n_rows":137,"n_cols":12,"rows_kept":137,"cut":false,"hidden":true,"merged":[]}
["BES_Number","Account_Name","BES_Number","Description","SRR Designation","Performance Payment","Budget Cap","Cooling Zone","Heating Zone","Option 2","PNGC Member","IDEA Member"]
["10055","Albion","10055","City of Albion","SRR",0.08,0.3,2,2,"No",null,"IDEA"]
["10005","Alder","10005","Alder Mutual Light Company","SRR",0.08,0.3,1,1,"No",null,""]
["10057","Ashland","10057","City of Ashland","Non-SRR",0.04,0.2,3,1,"No",null,""]
["10015","Asotin PUD","10015","Public Utility District No. 1 of Asotin County","SRR",0.08,0.3,3,1,"No",null,""]
["10059","Bandon","10059","City of Bandon","SRR",0.08,0.3,1,1,"No",null,""]
["10024","Benton PUD","10024","Public Utility District No. 1 of Benton County","Non-SRR",0.04,0.2,3,1,"No",null,""]
["10025","Benton REA","10025","Benton Rural Electric Association","SRR",0.08,0.3,3,1,"No",null,""]
["10027","Big Bend","10027","Big Bend Electric Cooperative","SRR",0.08,0.3,2,2,"No",null,""]
["10029","Blachly-Lane","10029","Blachly-Lane Electric Cooperative","SRR",0.08,0.3,1,1,"No","PNGC",""]
["10061","Blaine","10061","City of Blaine","SRR",0.08,0.3,1,1,"No"]
["10062","Bonners Ferry","10062","City of Bonners Ferry","SRR",0.08,0.3,1,2,"No",null,""]
["10064","Burley","10064","City of Burley","Non-SRR",0.04,0.2,2,2,"No",null,""]
["10044","Canby","10044","Canby Utility Board","Non-SRR",0.04,0.2,2,1,"No",null,""]
["10065","Cascade Locks","10065","City of Cascade Locks","SRR",0.08,0.3,1,1,"No",null,"IDEA"]
["10046","CEC","10046","Central Electric Cooperative, Inc.","SRR",0.08,0.3,2,2,"No","PNGC",""]
["10047","Central Lincoln","10047","Central Lincoln People's Utility District","Non-SRR",0.04,0.2,1,1,"No",null,""]
["10066","Centralia","10066","City of Centralia","Non-SRR",0.04,0.2,1,1,"No"]
["10067","Cheney","10067","City of Cheney","Non-SRR",0.04,0.2,3,2,"No",null,""]
["10068","Chewelah","10068","City of Chewelah","SRR",0.08,0.3,1,2,"No",null,""]
["10101","Clallam","10101","Public Utility District No. 1 of Clallam County","SRR",0.08,0.3,1,1,"No",null,""]
["10103","Clark","10103","Clark Public Utilities","Non-SRR",0.04,0.2,1,1,"No",null,""]
["10105","Clatskanie","10105","Clatskanie People's Utility District","Non-SRR",0.04,0.2,1,1,"No",null,""]
["10106","Clearwater","10106","Clearwater Power Company","SRR",0.08,0.3,2,2,"No","PNGC",""]
["10109","Columbia Basin","10109","Columbia Basin Electric Cooperative, Inc.","SRR",0.08,0.3,2,1,"No",null,""]
["10111","Columbia Power","10111","Columbia Power Cooperative Association","SRR",0.08,0.3,2,2,"No",null,""]
["10113","Columbia REA","10113","Columbia Rural Electric Association","SRR",0.08,0.3,3,1,"No"]
["10112","Columbia River","10112","Columbia River People's Utility District","Non-SRR",0.04,0.2,1,1,"No",null,""]
["10116","Consolidated","10116","Consolidated Irrigation District No. 19","SRR",0.08,0.3,2,2,"No",null,""]
["10118","Consumers","10118","Consumers Power, Inc.","SRR",0.08,0.3,1,1,"No","PNGC",""]
["10121","Coos-Curry","10121","Coos-Curry Electric Cooperative, Inc.","SRR",0.08,0.3,2,1,"No","PNGC",""]
["10378","Coulee Dam","10378","Town of Coulee Dam","SRR",0.08,0.3,3,2,"No",null,""]
["10123","Cowlitz","10123","Public Utility District No. 1 of Cowlitz County","Non-SRR",0.04,0.2,1,1,"No"]
["10070","Declo","10070","City of Declo","SRR",0.08,0.3,2,2,"No"]
["10426","DOE-RL","10426","US Department of Energy - Richland Operations Office","Non-SRR",0.04,0.2,3,1,"No",null,""]
["10136","Douglas Elec","10136","Douglas Electric Cooperative, Inc.","SRR",0.08,0.3,2,1,"No","PNGC",""]
["10071","Drain","10071","City of Drain","SRR",0.08,0.3,2,1,"No",null,"IDEA"]
["10142","East End","10142","East End Mutual Electric Company, LTD","SRR",0.08,0.3,2,2,"No",null,""]
["10144","Eatonville","10144","Town of Eatonville","SRR",0.08,0.3,1,1,"No"]
["10072","Ellensburg","10072","City of Ellensburg","Non-SRR",0.04,0.2,2,2,"No",null,""]
["10156","Elmhurst","10156","Elmhurst Mutual Power & Light Company","SRR",0.08,0.3,1,1,"No",null,"IDEA"]
["10157","Emerald","10157","Emerald People's Utility District","Non-SRR",0.04,0.2,2,1,"No",null,""]
["10158","Energy Northwest","10158","Energy Northwest","SRR",0.08,0.3,3,1,"No",null,""]
["10170","EWEB","10170","Eugene Water & Electric Board","Non-SRR",0.04,0.2,2,1,"Yes",null,""]
["10172","Fairchild","10172","Fairchild Air Force Base","SRR",0.08,0.3,2,2,"No",null,""]
["10173","Fall River","10173","Fall River Rural Electric Cooperative, Inc.","SRR",0.08,0.3,1,3,"No","PNGC",""]
["10174","Farmers","10174","Farmers Electric Company, LTD","SRR",0.08,0.3,2,2,"No",null,""]
["10177","Ferry","10177","Public Utility District No. 1 of Ferry County","SRR",0.08,0.3,1,3,"No",null,""]
["10179","Flathead","10179","Flathead Electric Cooperative, Inc.","Non-SRR",0.04,0.2,1,3,"No",null,""]
["10074","Forest Grove","10074","City of Forest Grove","Non-SRR",0.04,0.2,1,1,"No"]
["10183","Franklin County","10183","Public Utility District No. 1 of Franklin County","Non-SRR",0.04,0.2,3,1,"No",null,"IDEA"]
["10186","Glacier","10186","Glacier Electric Cooperative, Inc.","SRR",0.08,0.3,1,3,"No",null,""]
["10190","Grant","10190","Public Utility District No. 2 of Grant County, Washington","SRR",0.08,0.3,3,2,"No",null,""]
["10191","Grays Harbor","10191","Public Utility District No. 1 of Grays Harbor County Washington","Non-SRR",0.04,0.2,1,1,"No",null,""]
["10197","Harney","10197","Harney Electric Cooperative, Inc.","SRR",0.08,0.3,3,3,"No",null,""]
["10597","Hermiston","10597","City of Hermiston","Non-SRR",0.04,0.2,3,1,"No",null,""]
["10076","Heyburn","10076","City of Heyburn","SRR",0.08,0.3,2,2,"No",null,""]
["10202","Hood River","10202","Hood River Electric Cooperative","Non-SRR",0.04,0.2,1,1,"No",null,""]
["10203","Idaho County","10203","Idaho County Light & Power Cooperative Association, Inc.","SRR",0.08,0.3,1,2,"No",null,""]
["10204","Idaho Falls Power","10204","City of Idaho Falls","Non-SRR",0.04,0.2,2,3,"No",null,""]
["10209","Inland","10209","Inland Power & Light Company","SRR",0.08,0.3,2,2,"No",null,""]
["12026","Jefferson","12026","Public Utility District No.1 of Jefferson County","Non-SRR",0.04,0.2,1,1,"No",null,"IDEA"]
["10230","Kittitas","10230","Public Utility District No. 1 of Kittitas County","SRR",0.08,0.3,3,2,"No",null,""]
["10231","Klickitat","10231","Public Utility District No. 1 of Klickitat County","SRR",0.08,0.3,2,2,"No",null,""]
["10234","Kootenai","10234","Kootenai Electric Cooperative, Inc.","SRR",0.08,0.3,2,2,"No",null,"IDEA"]
["13927","KTU","13927","Kalispel Indian Community of the Kalispel Reservation","Non-SRR",0.04,0.2,2,2,"No",null,""]
["10235","Lakeview","10235","Lakeview Light & Power Company","Non-SRR",0.04,0.2,1,1,"No",null,""]
["10236","Lane Electric","10236","Lane Electric Cooperative, Inc.","SRR",0.08,0.3,2,1,"No","PNGC",""]
["10237","Lewis","10237","Public Utility District No. 1 of Lewis County","SRR",0.08,0.3,1,1,"No",null,""]
["10239","Lincoln","10239","Lincoln Electric Cooperative, Inc.","SRR",0.08,0.3,1,3,"No","PNGC",""]
["10242","Lost River","10242","Lost River Electric Cooperative, Inc.","SRR",0.08,0.3,2,3,"No",null,""]
["10244","Lower Valley","10244","Lower Valley Energy, Inc.","SRR",0.08,0.3,1,3,"No"]
["10246","Mason Co 1","10246","Public Utility District No. 1 of Mason County","SRR",0.08,0.3,1,1,"No",null,""]
["10247","Mason Co 3","10247","Public Utility District No. 3 of Mason County","Non-SRR",0.04,0.2,1,1,"No"]
["10078","McCleary","10078","City of McCleary","SRR",0.08,0.3,1,1,"No",null,""]
["10079","McMinnville","10079","The City of McMinnville","Non-SRR",0.04,0.2,1,1,"No",null,""]
["10256","Midstate","10256","Midstate Electric Cooperative, Inc.","SRR",0.08,0.3,2,2,"No",null,""]
["10080","Milton","10080","City of Milton","SRR",0.08,0.3,1,1,"No",null,""]
["10081","Milton-Freewater","10081","City of Milton-Freewater","SRR",0.08,0.3,3,1,"No",null,""]
["10082","Minidoka","10082","City of Minidoka","SRR",0.08,0.3,2,2,"No",null,""]
["10258","Mission Valley","10258","Mission Valley Power","SRR",0.08,0.3,1,2,"No",null,""]
["10259","Missoula","10259","Missoula Electric Cooperative, Inc.","SRR",0.08,0.3,2,3,"No",null,""]
["10260","Modern","10260","Modern Electric Water Company","Non-SRR",0.04,0.2,3,2,"No",null,""]
["10083","Monmouth","10083","City of Monmouth","SRR",0.08,0.3,2,1,"No",null,"IDEA"]
["10273","Nespelem","10273","Nespelem Valley Electric Cooperative, Inc.","SRR",0.08,0.3,2,2,"No",null,""]
["10406","NETL","10406","US DOE Natl Energy Technology Lab","SRR",0.08,0.3,2,1,"No",null,""]
["10278","Northern Lights","10278","Northern Lights, Inc.","SRR",0.08,0.3,1,2,"No","PNGC",""]
["10279","Northern Wasco","10279","Northern Wasco County People's Utility District","Non-SRR",0.04,0.2,3,1,"No",null,""]
["10284","Ohop","10284","Ohop Mutual Light Company","SRR",0.08,0.3,1,1,"No",null,""]
["10285","Okanogan Coop","10285","Okanogan County Electric Cooperative, Inc.","SRR",0.08,0.3,2,2,"No","PNGC"]
["10286","Okanogan PUD","10286","Okanogan County Public Utility District No. 1","Non-SRR",0.04,0.2,2,2,"No",null,""]
["10288","OPALCO","10288","Orcas Power & Light Cooperative","SRR",0.08,0.3,1,1,"No","PNGC",""]
["10291","Oregon Trail","10291","Oregon Trail Electric Consumers Cooperative, Inc.","Non-SRR",0.04,0.2,2,2,"No"]
["10294","Pacific","10294","Public Utility District No. 2 of Pacific County","Non-SRR",0.04,0.2,1,1,"No",null,""]
["10304","Parkland","10304","Parkland Light & Water Company","Non-SRR",0.04,0.2,1,1,"No",null,""]
["10306","Pend Oreille","10306","Pend Oreille County PUD No. 1","SRR",0.08,0.3,1,2,"No",null,""]
["10307","Peninsula","10307","Peninsula Light Company","SRR",0.08,0.3,1,1,"No",null,""]
["10086","Plummer","10086","City of Plummer","SRR",0.08,0.3,2,2,"No",null,""]
["10298","PNGC","10298","Pacific Northwest Generating Cooperative","SRR",0.08,0.3,"All Cooling Zones","All Heating Zones","No",null,""]
["10706","Port","10706","Port of Seattle - Seattle-Tacoma International Airport","Non-SRR",0.04,0.2,1,1,"No",null,""]
["10087","Port Angeles","10087","City of Port Angeles","Non-SRR",0.04,0.2,1,1,"No",null,""]
["10331","Raft River","10331","Raft River Rural Electric Cooperative, Inc.","SRR",0.08,0.3,2,2,"No","PNGC"]
["10333","Ravalli County","10333","Ravalli County Electric Cooperative, Inc.","SRR",0.08,0.3,1,3,"No",null,""]
["10089","Richland","10089","City of Richland, Washington","Non-SRR",0.04,0.2,3,1,"No",null,""]
["10338","Riverside Electric","10338","Riverside Electric Company, LTD","SRR",0.08,0.3,2,2,"No"]
["10091","Rupert","10091","City of Rupert","SRR",0.08,0.3,2,2,"No",null,""]
["10342","Salem","10342","Salem Electric","Non-SRR",0.04,0.2,2,1,"No",null,""]
["10343","Salmon River","10343","Salmon River Electric Cooperative, Inc.","SRR",0.08,0.3,1,3,"No","PNGC","IDEA"]
["10349","Seattle","10349","City of Seattle, City Light Dept","Non-SRR",0.04,0.2,1,1,"Yes",null,"IDEA"]
["10352","Skamania","10352","Public Utility District #1 of Skamania County","Non-SRR",0.04,0.2,1,1,"No",null,""]
["10354","Snohomish PUD","10354","Public Utility District No. 1 Of Snohomish County","Non-SRR",0.04,0.2,1,1,"Yes",null,""]
["10094","Soda Springs","10094","City of Soda Springs","SRR",0.08,0.3,1,3,"No",null,""]
["10360","South Side","10360","South Side Electric, Inc.","SRR",0.08,0.3,2,2,"No",null,""]
["10363","Springfield","10363","Springfield Utility Board","Non-SRR",0.04,0.2,2,1,"No",null,""]
["10379","Steilacoom","10379","Town of Steilacoom","SRR",0.08,0.3,1,1,"No",null,"IDEA"]
["10095","Sumas","10095","City of Sumas","SRR",0.08,0.3,1,1,"No",null,""]
["10369","Surprise Valley","10369","Surprise Valley Electrification Corporation","SRR",0.08,0.3,1,2,"No",null,""]
["10370","Tacoma Power","10370","Tacoma Power","Non-SRR",0.04,0.2,1,1,"Yes",null,""]
["10371","Tanner","10371","Tanner Electric Cooperative","Non-SRR",0.04,0.2,1,1,"No",null,""]
["10376","Tillamook","10376","Tillamook People's Utility District","Non-SRR",0.04,0.2,1,1,"No",null,""]
["10097","Troy","10097","City of Troy","SRR",0.08,0.3,1,2,"No",null,""]
["10482","UIUC","10482","Umpqua Indian Utility Cooperative","SRR",0.08,0.3,2,1,"No",null,""]
["10388","Umatilla","10388","Umatilla Electric Cooperative","SRR",0.08,0.3,3,1,"No","PNGC",""]
["10391","United Electric","10391","United Electric Co-op, Inc.","Non-SRR",0.04,0.2,2,2,"No",null,""]
["10400","USBR General","10400","USBR General","Non-SRR",0,0,"All Cooling Zones","All Heating Zones","No"]
["10409","USN Bangor","10409","USN Bangor","Non-SRR",0.04,0.2,1,1,"No",null,""]
["10326","USN Bremerton","10326","USN Bremerton","Non-SRR",0.04,0.2,1,1,"No",null,"IDEA"]
["10408","USN Everett","10408","USN Everett-Jim Creek","SRR",0.08,0.3,1,1,"No",null,""]
["10434","Vera","10434","Vera Water & Power","Non-SRR",0.04,0.2,3,2,"No",null,""]
["10436","Vigilante","10436","Vigilante Electric Cooperative, Inc.","SRR",0.08,0.3,1,3,"No",null,""]
["10440","Wahkiakum","10440","Public Utility District No. 1 of Wahkiakum County","SRR",0.08,0.3,1,1,"No",null,""]
["10442","Wasco","10442","Wasco Electric Cooperative, Inc.","SRR",0.08,0.3,3,2,"No",null,""]
["11680","Weiser","11680","City of Weiser","SRR",0.08,0.3,3,2,"No",null,""]
["10448","West Oregon","10448","West Oregon Electric Cooperative, Inc.","SRR",0.08,0.3,1,1,"No","PNGC",""]
["10451","Whatcom Co 1","10451","Public Utility District No 1 of Whatcom County","Non-SRR",0.04,0.2,1,1,"No",null,"IDEA"]
["10446","WREC","10446","Wells Rural Electric Company","SRR",0.08,0.3,3,2,"No",null,""]
["10502","Yakama","10502","Yakama Power","SRR",0.08,0.3,3,1,"No"]

{"sheet":"uploaddata","index":10,"n_rows":2,"n_cols":31,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Version","ProjectType","ProjectNo","SubmittalNo","ML","projcost","busbr sav","wattred","totcred","bc ratio","bldgtype","bldg","acctno","zip","facility","state","projname","street","city","ContactName","ContactTitle","ContactPhone","ContactEmail","Sector","NAICS","SubmittalName","EMapproval","EPMname","EPMstart","BESnum","SubCompDate"]
[{"$f":"up_version","v":6.1},{"$f":"up_projecttype","v":"EPM"},{"$f":"up_projectno","v":0},1,null,null,null,null,25000,null,null,null,null,{"$f":"up_zip","v":0},{"$f":"up_facility","v":0},{"$f":"up_state","v":0},{"$f":"up_projname","v":" EPM  - 0"},{"$f":"up_street","v":0},{"$f":"up_city","v":0},{"$f":"up_cont_name","v":0},{"$f":"up_cont_title","v":0},{"$f":"up_cont_phone","v":0},{"$f":"up_cont_email","v":0},{"$f":"up_sector","v":"Industrial"},{"$f":"up_NAICS","v":0},"YEAR 1 EPM ASSIGNMENT",{"$f":"up_emapproval","v":"Yes"},{"$f":"'uploaddata collection'!E30","v":0},0,{"$f":"up_BES","v":""},"2017-10-02"]

{"sheet":"Revision History","index":11,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"Revision History"]
["Current Version:",null,6.1]
["Revision Number","Date","Description"]
[2,null,"Removed \"epm busbr sav\" AF from the uploaddata tab.  Commented out commands to populate the field in the uploaddata for uploads 3,4,6,and 7 that refer to \"epm busbr sav\".  Column AG becomes AF, and AH becomes AG.  Upload macros updated. Revised payment nomenclature to match TrakSmart and IM\nFixed Year 2, Payment 2 funding formula to address cell I100 instead of I48 Fixed I130 to include $250,000 cap nomenclature to be consistent with TrakSmart and IM. Revised incentive payment calculations to be based on busbar savings Fixed formula in cell I53 -- was not capping. Fixed formula in cell I90 -- was double counting the same year period Correctly assigned Measure Life to the appropriate years and eliminated it from Yr 0 Corrected error in the booking of savings whereby only 75% of year 1 savings is booked in year 1, and then 25% of  year 1 is booked in year 2. Various changes in labeling. Completion report savings is not assigned to any \"busbr sav\" field."]
[2.1,null,"Removed all fields from the PTR Upload EPM and uploaddata tabs that have a kWh unit value. Updated busbar factor from 1.07625 to 1.09056."]
[2.2000000000000002,null,"Linked the \"Comprehensive EPM Plan Approved\" from Upload 2 to populate the Emapproval field on the uploaddata tab "]
[2.2999999999999998,null,"Fixed logic to prevent negative payments associated with under-performing EPMs."]
[3,null,"Eliminated Carry Over Provision. Added a field for EPM Commencement Date to Milestone #1. Relocated Base Annual salary to Milestone #2. Added a field for EPM Commencement Date to Submittal #5"]
[3.1,"2012-07-06","Changed Cell I80 from \n=IF($I$61=\"Yes\",IF($I$77-$I$64-$I$32-$I$50<0,0,$I$77-$I$64-$I$32-$I$50),0)\nto\n=IF($I$77-$I$64-$I$32-$I$50<0,0,$I$77-$I$64-$I$32-$I$50)\nadded cents to all financial figures\nfixed formula in cell I65\n"]
[4,"2012-07-18","Added BES Number under serving utility field.  Changed utility name and BES reference to 'utility list' sheet.  Changed macro code to stop creation of new upload file eliminated 'terminate EPM' function at 6-mo milestone eliminated 'payment suspend' function at 6-mo milestone"]
[4,"2012-08-01","Added BES Number to upload data tab. Added Submittal Completion Date to upload data tab.  Added protection to formula fields in EPM Input Worksheet."]
[4,"2012-08-22","Sorted 'utility list' sheet by Column B to prevent vlookup error.  Protected sheet to prevent resorting."]
[4.0999999999999996,null,"Added two fields for utility-specific EPM funding caps (for Year 1 and 2).  This functionality will be required with the release of the October 2013 IM, which includes an optional capping provision for the EPM component."]
[5,"2014-10-01","Updated to match Custom Project Calculator."]
[6,"2014-12-22","Updated permissions to allow upload data tab to change with submission."]
[6.1,"2015-07-22","Updated to correct CY3. Complete Report Tab - Previously, the Continuation Year Maximum Payment was calculated using Y1 data."]
[6.1,"2017-10-02","Updated Utility List tab with the current information from IS2.0 Accounts."]

{"sheet":"uploaddata collection","index":12,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[[30,8,30,10],[11,4,11,10],[2,4,2,10],[3,4,3,10],[4,4,4,10],[7,4,7,10],[9,4,9,10],[13,4,13,10],[14,4,14,10],[15,4,15,10],[16,4,16,10],[17,4,17,10],[31,4,31,10],[6,4,6,10],[8,4,8,10],[24,4,24,10],[25,4,25,10],[26,4,26,10],[28,4,28,10],[29,4,29,10],[18,4,18,10],[19,4,19,10],[20,4,20,10],[21,4,21,10],[22,4,22,10],[23,4,23,10],[12,4,12,10],[30,4,30,7]]}
[]
[null,"Excel Labels","Data Type","uploaddata cell",1,2,3,4,5,6,7]
[null,"Version","text","A2",{"$f":"'Revision History'!C2","v":6.1}]
[null,"ProjectType","text","B2","EPM"]
[null,"projectno","numeric, integer","C2",{"$f":"'Project Information'!D22","v":0}]
[null,"SubmittalNo","numeric, integer","D2",1,2,3,4,5,6,7]
[null,"ML","numeric, integer","E2"]
[null,"projcost","numeric, currency","F2"]
[null,"booked sav",null,"G2"]
[null,"wattred",null,"H2"]
[null,"totcred",null,"I2",{"$f":"'EPM Information'!J16","v":25000},{"$f":"'EPM Information'!J17","v":0},{"$f":"'EPM Information'!J18","v":0},{"$f":"'EPM Information'!J19","v":0},{"$f":"'EPM Information'!J20","v":0},{"$f":"'EPM Information'!J21","v":0},{"$f":"'EPM Information'!J22","v":0}]
[null,"bc ratio",null,"J2"]
[null,"bldgtype",null,"K2"]
[null,"bldg",null,"L2"]
[null,"acctno",null,"M2"]
[null,"zip","text","N2",{"$f":"'Project Information'!D11","v":0}]
[null,"facility","text","O2",{"$f":"'Project Information'!D7","v":0}]
[null,"state","text","P2",{"$f":"'Project Information'!D10","v":0}]
[null,"projname","text","Q2",{"$f":"CONCATENATE('Project Information'!D7, \" EPM  - \", E30)","v":" EPM  - 0"}]
[null,"street","text","R2",{"$f":"'Project Information'!D8","v":0}]
[null,"city","text","S2",{"$f":"'Project Information'!D9","v":0}]
[null,"ContactName","text","T2",{"$f":"'Project Information'!D13","v":0}]
[null,"ContactTitle","text","U2",{"$f":"'Project Information'!D14","v":0}]
[null,"ContactPhone","text","V2",{"$f":"'Project Information'!D15","v":0}]
[null,"ContactEmail","text","W2",{"$f":"'Project Information'!D16","v":0}]
[null,"Sector","text","X2","Industrial"]
[null,"NAICS","numeric, integer","Y2",{"$f":"'Project Information'!D12","v":0}]
[null,"SubmittalName","text","Z2","YEAR 1 EPM ASSIGNMENT","YEAR 1 COMPREHENSIVE PLAN","YEAR 1 SIX-MONTH UPDATE","YEAR 1 COMPLETION REPORT","CONT. YEAR COMPREHENSIVE PLAN","CONT. YEAR SIX-MONTH UPDATE","CONT. YEAR COMPLETION REPORT"]
[null,"Emapproval","text","AB2","Yes"]
[null,"EMPname","text","AB2",{"$f":"IF(ISBLANK('Project Information'!D17),'Project Information'!D13,'Project Information'!D17)","v":0}]
[null,"EMPstart","text","AC2",{"$f":"'Y1 1. EPM Assignment'!E9","v":0},null,null,null,{"$f":"'CY 1. Comprehensive Plan'!E7","v":0}]
[null,"BESnum","numeric  ","AD2",{"$f":"IF(ISBLANK('Project Information'!D3),\"\",VLOOKUP('Project Information'!D3,'Utility List'!B1:C137,2))","v":""}]
[null,"SubCompDate","numeric, date","AE2","2017-10-02","2016-02-13","2016-02-13","2016-02-13","2017-10-02","2017-10-02","2014-10-24"]

{"sheet":"Protection","index":13,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,0,0,1]]}
["Protection"]
["use","password"]
["worksheet protection","epm"]
["workbook protection","epm"]
["ECTOR Review Ranges","ecotr"]