{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Calculations"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"Calculations","index":0,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[17,0,17,9],[18,0,18,9],[0,0,0,12],[15,10,15,11],[16,10,16,11],[15,0,15,9],[16,0,16,9],[1,0,1,12],[2,0,2,12],[3,0,3,7],[3,8,3,9],[3,10,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,"<--------------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 1% Loans will be lesser of actual EUL or 17 Years)","Measure Cost Savings over EUL ($)","Measure Payback (years)","Measure Revised EUL (if applicable; max. 17 years for 1% Loans)","Measure Revised Cost Savings ($)","Eligible Loan Amount \n(Lesser of measure cost or measure cost savings over its EUL)"]
["Measure 1 (Example)",76985,14.7,37733,0,0,6246,17,{"$f":"G6*H6","v":106182},{"$f":"B6/G6","v":12.325488312520013},{"$f":"MIN(H6,17)","v":17},{"$f":"G6*K6","v":106182},{"$f":"MIN(B6,I6,L6)","v":76985}]
["Measure 2 (Example)",49904,7.5,26955,0,0,4612,15,69180,{"$f":"B7/G7","v":10.820468343451864},15,{"$f":"G7*K7","v":69180},{"$f":"MIN(B7,I7,L7)","v":49904}]
["Measure 3 (Example)",24463,4.5,8023,0,0,1827,5,9135,{"$f":"B8/G8","v":13.389709906951285},{"$f":"MIN(H8,17)","v":5},9135,9135]
["Measure 4 (Example)",24830,4.8,13585,0,0,3016,7,21112,{"$f":"B9/G9","v":8.2327586206896548},{"$f":"MIN(H9,17)","v":7},21112,21112]
["Measure 5 (Example)",44871,0.8,11394,0,0,2640,17,44880,{"$f":"B10/G10","v":16.996590909090909},15,39600,39600]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"SUM(B6:B14)","v":221053},{"$f":"SUM(C6:C14)","v":32.299999999999997},{"$f":"SUM(D6:D14)","v":97690},{"$f":"SUM(E6:E6)","v":0},{"$f":"SUM(F6:F6)","v":0},{"$f":"SUM(G6:G12)","v":18341},null,{"$f":"SUM(I6:I14)","v":250489},{"$f":"B15/G15","v":12.052396270650455},null,null,{"$f":"SUM(M6:M14)","v":196736}]
["* Measure Installation Cost shall include all labor, engineering, construction, materials, equipment, inspection,  demolition (if applicable), ",null,null,null,null,null,null,null,null,null,"** Loan Amount:",null,{"$f":"MIN(B15,M15)","v":196736}]
["and removal (if applicable) less equipment salvage value (if applicable).",null,null,null,null,null,null,null,null,null,"Payback Period (years):",null,{"$f":"M16/G15","v":10.726568889373535}]
["** Loan amount will be lesser of $3 million;  project cost; or total energy cost savings calculated using EUL of individual measures (as calculated in column M or titled \"Eligible Loan Amount (Lesser of measure cost or measure cost savings over its EUL)\"))."]
["*** If EUL of a measure is less than 17 years, borrower can use EUL up to 17 years provided its operational warranty certificate is provided by the manufacturer / supplier.  "]