{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ECAA-Ed ($3M Max)","ECAA-Ed ($5M Max)","Example"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"comments":0,"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":"ECAA-Ed ($3M Max)","index":0,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[[13,0,13,10],[14,0,14,10],[16,0,16,10],[15,0,15,4],[0,0,0,10],[1,0,1,10],[2,0,2,10],[3,0,3,7],[3,8,3,10],[15,5,15,10],[3,11,3,12],[10,11,10,12],[11,11,11,12],[10,7,10,8],[11,7,11,8]]}
["ATTACHMENT 2"]
["Summary of Energy Efficiency Measures in Loan Request"]
["For each application, list the project measures for which you are requesting a loan and identify the estimated savings, project cost and payback for each project measure.  Columns, except for Measure Payback, should total at the end of the table. Insert more rows as needed."]
["<-----------------------------------------------Applicant to enter data in these columns------------------------------------------------->",null,null,null,null,null,null,null,"<--Auto filled columns-->",null,null,"<----CEC Staff's Review----->"]
["Project Measure / Location","Measure Installation Cost ($)*","Peak Demand Savings (kW)","Annual Electric Savings (kWh)","Annual Natural Gas Savings (therms)","Annual Other Energy Savings (specify units)","Measure Annual Cost Savings ($)","EUL (years)***\n(EUL Considered for 0% Loans will be lesser of actual EUL or 20 Years)","Measure Cost Savings over EUL ($)","Measure Payback (years)","GhG Emissions Reduction (Metric Tons)","Measure Revised EUL (max. 20 years for 0% Loans)","Measure Cost Savings ($)"]
[null,null,null,null,null,null,null,null,{"$f":"G6*H6","v":0},{"$f":"B6/G6","v":{"$error":"#DIV/0!"}},{"$f":"D6*(0.0001723)","v":0},{"$f":"MIN(H6,20)","v":20},{"$f":"+L6*G6","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"G7*H7","v":0},{"$f":"B7/G7","v":{"$error":"#DIV/0!"}},{"$f":"D7*(0.0001723)","v":0},{"$f":"MIN(H7,20)","v":20},{"$f":"+L7*G7","v":0}]
[null,null,null,null,null,null,null,null,0,{"$error":"#DIV/0!"},0,20,0]
[null,null,null,null,null,null,null,null,0,{"$error":"#DIV/0!"},0,20,0]
["TOTAL",{"$f":"SUM(B6:B9)","v":0},{"$f":"SUM(C6:C9)","v":0},{"$f":"SUM(D6:D9)","v":0},{"$f":"SUM(E6:E9)","v":0},{"$f":"SUM(F6:F6)","v":0},{"$f":"SUM(G6:G9)","v":0},null,{"$f":"SUM(I6:I9)","v":0}," ",{"$f":"SUM(K6:K9)","v":0},null,{"$f":"SUM(M6:M9)","v":0}]
[null,null,null,null,null,null,null,"** Loan Amount:",null,{"$f":"MIN(B10,I10,3000000)","v":0},null,"** Loan Amount:"]
[null,null,null,null,null,null,null,"Payback Period (years):",null,{"$f":"+J11/G10","v":{"$error":"#DIV/0!"}},null,"Payback Period (years):"]
[]
["* Measure Installation Cost shall include all labor, engineering, construction, materials, equipment, inspection,  demolition (if applicable), and removal (if applicable) less equipment salvage"]
["value (if applicable)."]
["** Loan amount will be lesser of  measure installation cost; or total measure cost savings over EUL; or",null,null,null,null,"$3,000,000 max unless project incorporates battery energy storage or EV charging measures"]
["*** If EUL of a measure is less than 20 years, borrower can use EUL up to 20 years provided its operational warranty certificate is provided by the manufacturer / supplier.  "]
[" "]

{"sheet":"ECAA-Ed ($5M Max)","index":1,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[[15,0,15,4],[15,5,15,10],[16,0,16,10],[10,7,10,8],[10,11,10,12],[11,7,11,8],[11,11,11,12],[13,0,13,10],[14,0,14,10],[3,11,3,12],[0,0,0,10],[1,0,1,10],[2,0,2,10],[3,0,3,7],[3,8,3,10]]}
["ATTACHMENT 2"]
["Summary of Energy Efficiency Measures in Loan Request"]
["For each application, list the project measures for which you are requesting a loan and identify the estimated savings, project cost and payback for each project measure.  Columns, except for Measure Payback, should total at the end of the table. Insert more rows as needed."]
["<-----------------------------------------------Applicant to enter data in these columns------------------------------------------------->",null,null,null,null,null,null,null,"<--Auto filled columns-->",null,null,"<----CEC Staff's Review----->"]
["Project Measure / Location","Measure Installation Cost ($)*","Peak Demand Savings (kW)","Annual Electric Savings (kWh)","Annual Natural Gas Savings (therms)","Annual Other Energy Savings (specify units)","Measure Annual Cost Savings ($)","EUL (years)***\n(EUL Considered for 0% Loans will be lesser of actual EUL or 20 Years)","Measure Cost Savings over EUL ($)","Measure Payback (years)","GhG Emissions Reduction (Metric Tons)","Measure Revised EUL (max. 20 years for 0% Loans)","Measure Cost Savings ($)"]
[null,null,null,null,null,null,null,null,{"$f":"G6*H6","v":0},{"$f":"B6/G6","v":{"$error":"#DIV/0!"}},{"$f":"D6*(0.0001723)","v":0},{"$f":"MIN(H6,20)","v":20},{"$f":"+L6*G6","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"G7*H7","v":0},{"$f":"B7/G7","v":{"$error":"#DIV/0!"}},{"$f":"D7*(0.0001723)","v":0},{"$f":"MIN(H7,20)","v":20},{"$f":"+L7*G7","v":0}]
[null,null,null,null,null,null,null,null,0,{"$error":"#DIV/0!"},0,20,0]
[null,null,null,null,null,null,null,null,0,{"$error":"#DIV/0!"},0,20,0]
["TOTAL",{"$f":"SUM(B6:B9)","v":0},{"$f":"SUM(C6:C9)","v":0},{"$f":"SUM(D6:D9)","v":0},{"$f":"SUM(E6:E9)","v":0},{"$f":"SUM(F6:F6)","v":0},{"$f":"SUM(G6:G9)","v":0},null,{"$f":"SUM(I6:I9)","v":0}," ",{"$f":"SUM(K6:K9)","v":0},null,{"$f":"SUM(M6:M9)","v":0}]
[null,null,null,null,null,null,null,"** Loan Amount:",null,{"$f":"MIN(B10,I10,5000000)","v":0},null,"** Loan Amount:"]
[null,null,null,null,null,null,null,"Payback Period (years):",null,{"$f":"+J11/G10","v":{"$error":"#DIV/0!"}},null,"Payback Period (years):"]
[]
["* Measure Installation Cost shall include all labor, engineering, construction, materials, equipment, inspection,  demolition (if applicable), and removal (if applicable) less equipment salvage"]
["value (if applicable)."]
["** Loan amount will be lesser of  measure installation cost; or total measure cost savings over EUL; or",null,null,null,null,"$5,000,000 max if project incorporates battery energy storage or EV charging measures"]
["*** If EUL of a measure is less than 20 years, borrower can use EUL up to 20 years provided its operational warranty certificate is provided by the manufacturer / supplier.  "]
[" "]

{"sheet":"Example","index":2,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[[14,0,14,10],[13,0,13,10],[15,0,15,4],[15,5,15,10],[16,0,16,10],[10,7,10,8],[10,11,10,12],[11,7,11,8],[11,11,11,12],[0,0,0,10],[1,0,1,10],[2,0,2,10],[3,0,3,7],[3,8,3,10],[3,11,3,12]]}
["ATTACHMENT 2"]
["Summary of Energy Efficiency Measures in Loan Request"]
["For each application, list the project measures for which you are requesting a loan and identify the estimated savings, project cost and payback for each project measure.  Columns, except for Measure Payback, should total at the end of the table. Insert more rows as needed."]
["<-----------------------------------------------Applicant to enter data in these columns------------------------------------------------->",null,null,null,null,null,null,null,"<--Auto filled columns-->",null,null,"<----CEC Staff's Review----->"]
["Project Measure / Location","Measure Installation Cost ($)*","Peak Demand Savings (kW)","Annual Electric Savings (kWh)","Annual Natural Gas Savings (therms)","Annual Other Energy Savings (specify units)","Measure Annual Cost Savings ($)","EUL (years)***\n(EUL Considered for 0% Loans will be lesser of actual EUL or 20 Years)","Measure Cost Savings over EUL ($)","Measure Payback (years)","GhG Emissions Reduction (Metric Tons)","Measure Revised EUL (max. 20 years for 0% Loans)","Measure Cost Savings ($)"]
["Middle School: Replace split system with 5 ton condenser and furnace",15688,null,412,450,null,558,15,{"$f":"G6*H6","v":8370},{"$f":"B6/G6","v":28.114695340501793},{"$f":"D6*(0.0001723)","v":7.0987599999999998E-2},{"$f":"MIN(H6,20)","v":15},{"$f":"+L6*G6","v":8370}]
["Maintenance Building: Install 231 LED fixtures",38707,null,22393,0,null,5374,15,{"$f":"G7*H7","v":80610},{"$f":"B7/G7","v":7.2026423520655003},{"$f":"D7*(0.0001723)","v":3.8583138999999997},{"$f":"MIN(H7,20)","v":15},{"$f":"+L7*G7","v":80610}]
["High School: Replace 600,000 BTU boiler system",106618,null,894,3398,null,3681,20,73620,28.964411844607444,0.15403619999999998,20,73620]
["District Office: lnstall 94 kW PV system",378460,null,126422,0,null,30341,20,606820,12.473550641046769,21.782510599999998,20,606820]
["TOTAL",{"$f":"SUM(B6:B9)","v":539473},{"$f":"SUM(C6:C9)","v":0},{"$f":"SUM(D6:D9)","v":150121},{"$f":"SUM(E6:E9)","v":3848},{"$f":"SUM(F6:F6)","v":0},{"$f":"SUM(G6:G9)","v":39954},null,{"$f":"SUM(I6:I9)","v":769420}," ",{"$f":"SUM(K6:K9)","v":25.865848299999996},null,{"$f":"SUM(M6:M9)","v":769420}]
[null,null,null,null,null,null,null,"** Loan Amount:",null,{"$f":"MIN(B10,I10,3000000)","v":539473},null,"** Loan Amount:"]
[null,null,null,null,null,null,null,"Payback Period (years):",null,{"$f":"+J11/G10","v":13.502352705611454},null,"Payback Period (years):"]
[]
["* Measure Installation Cost shall include all labor, engineering, construction, materials, equipment, inspection,  demolition (if applicable), and removal (if applicable) less equipment salvage"]
["value (if applicable)."]
["** Loan amount will be lesser of  measure installation cost; or total measure cost savings over EUL; or",null,null,null,null,"$3,000,000 max unless project incorporates battery energy storage or EV charging measures"]
["*** If EUL of a measure is less than 20 years, borrower can use EUL up to 20 years provided its operational warranty certificate is provided by the manufacturer / supplier.  "]
[" "]