{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["KTEP Measures Summary","Example"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"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":"KTEP Measures Summary","index":0,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[[15,0,15,10],[16,0,16,10],[14,0,14,12]]}
["ATTACHMENT 2"]
["Summary of Energy 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.  "]
["All columns except for H, J, and L, 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 15 Years)","Measure Cost Savings over EUL ($)","Measure Payback (years)","GHG Emissions Reduction (Metric Tons)","Measure Revised EUL (max. 15 years for 0% Loans)","Measure Cost Savings ($)"]
[null,null,null,null,null,null,null,null,{"$f":"G7*H7","v":0},{"$f":"B7/G7","v":{"$error":"#DIV/0!"}},{"$f":"D7*(0.0002106)","v":0},{"$f":"MIN(H7,15)","v":15},{"$f":"+L7*G7","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"G8*H8","v":0},{"$f":"B8/G8","v":{"$error":"#DIV/0!"}},{"$f":"D8*(0.0002106)","v":0},{"$f":"MIN(H8,15)","v":15},{"$f":"+L8*G8","v":0}]
[null,null,null,null,null,null,null,null,0,{"$error":"#DIV/0!"},0,{"$f":"MIN(H9,15)","v":15},0]
[null,null,null,null,null,null,null,null,0,{"$error":"#DIV/0!"},0,{"$f":"MIN(H10,15)","v":15},0]
["TOTAL",{"$f":"SUM(B7:B10)","v":0},{"$f":"SUM(C7:C10)","v":0},{"$f":"SUM(D7:D10)","v":0},{"$f":"SUM(E7:E10)","v":0},{"$f":"SUM(F7:F7)","v":0},{"$f":"SUM(G7:G10)","v":0},null,{"$f":"SUM(I7:I10)","v":0}," ",{"$f":"SUM(K7:K10)","v":0},null,{"$f":"SUM(M7:M10)","v":0}]
[null,null,null,null,null,null,null,"Loan Amount:",null,{"$f":"MIN(B11,I11,3000000)","v":0},null,"** Loan Amount:"]
[null,null,null,null,null,null,null,"Payback Period (years):",null,{"$f":"+J12/G11","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 $3 million; measure installation cost; or measure cost savings over EUL of individual measures. "]
["** If EUL of a measure is less than 15 years, borrower can use EUL up to 15 years provided its operational warranty certificate is provided by the manufacturer / supplier.  "]
[" "]

{"sheet":"Example","index":1,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[[19,0,19,10],[14,1,14,10],[18,0,18,10],[17,0,17,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.  "]
["All columns except for H, J, and L, 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 15 Years)","Measure Cost Savings over EUL ($)","Measure Payback (years)","GHG Emissions Reduction (Metric Tons)","Measure Revised EUL (max. 15 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":"G7*H7","v":8370},{"$f":"B7/G7","v":28.114695340501793},{"$f":"D7*(0.0002106)","v":8.6767200000000003E-2},{"$f":"MIN(H7,20)","v":15},{"$f":"+L7*G7","v":8370}]
["Maintenance Building: Install 231 LED fixtures",38707,null,22393,0,null,5374,15,{"$f":"G8*H8","v":80610},{"$f":"B8/G8","v":7.2026423520655003},{"$f":"D8*(0.0002106)","v":4.7159658000000002},{"$f":"MIN(H8,20)","v":15},{"$f":"+L8*G8","v":80610}]
["High School: Replace 600,000 BTU boiler system",106618,null,894,3398,null,3681,15,55215,28.964411844607444,0.18827640000000001,15,55215]
["District Office: lnstall 94 kW PV system",378460,null,126422,0,null,30341,15,455115,12.473550641046769,26.624473200000001,15,455115]
["TOTAL",{"$f":"SUM(B7:B10)","v":539473},{"$f":"SUM(C7:C10)","v":0},{"$f":"SUM(D7:D10)","v":150121},{"$f":"SUM(E7:E10)","v":3848},{"$f":"SUM(F7:F7)","v":0},{"$f":"SUM(G7:G10)","v":39954},null,{"$f":"SUM(I7:I10)","v":599310}," ",{"$f":"SUM(K7:K10)","v":31.6154826},null,{"$f":"SUM(M7:M10)","v":599310}]
[null,null,null,null,null,null,null,"Loan Amount:",null,{"$f":"MIN(B11,I11,3000000)","v":539473},null,"** Loan Amount:"]
[null,null,null,null,null,null,null,"Payback Period (years):",null,{"$f":"+J12/G11","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)."]
["** If EUL of a measure is less than 15 years, borrower can use EUL up to 15 years provided its operational warranty certificate is provided by the manufacturer / supplier.  "]
[" "]