{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Cogen ($875 kW)","Cogen ($799 kW)","Sheet1"],"not_rendered":{"charts":0,"images":10,"macros":0,"external_links":1,"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":"Cogen ($875 kW)","index":0,"n_rows":354,"n_cols":12,"rows_kept":354,"cut":false,"hidden":false,"merged":[]}
[]
[]
["I.","Assumptions",null,null,null,null,null,null,"Variable","Value"]
[]
[null,"A)","Capital Cost per kW of Capacity",null,null,null,null,null,"V",875,"/kW","JRB-Edited"]
[]
[null,"B)","Weighted Cost of Capital (Workpaper S-2)",null,null,null,null,null,"R",{"$f":"'[1]Carrying Charge'!B10/100","v":{"$error":"#REF!"}}]
[]
[null,"C)","Carrying Charge Rate",null,null,null,null,null,"CCR",{"$f":"12.55%","v":0.1255},null,"JRB-Edited, from Exhibit AEV-1, Carrying Charge at 20 year life"]
[]
[null,"D)","Operation & Maintenance Cost per Year (Fixed & Variable)",null,null,null,null,null,"O",{"$f":"H124","v":34.93},"/kW"]
[]
[null,"E)","Line Losses",null,null,null,null,null,"L",{"$f":"+F176","v":{"$error":"#REF!"}}]
[]
[null,"F)","Estimated Unit Life",null,null,null,null,null,"N",20,"years","JRB-Edited"]
[]
[null,"G)","Present Value of Carrying Charge for $1 Investment for N years",null,null,null,null,null,"D",{"$f":"+H33","v":{"$error":"#REF!"}}]
[]
[null,"H)","Fixed Operation and Maintenance Cost Escalation Rate",null,null,null,null,null,"IO",0.02]
[]
[null,"I)","Construction Cost Escalation Rate",null,null,null,null,null,"IP",{"$f":"+J19","v":0.02}]
[]
[]
[]
[]
["II.","Calculation of Present Value of Carrying Charge"]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"(1+J7)^J15-1","v":{"$error":"#REF!"}}]
[null,"D =",null,{"$f":"+J9","v":0.1255},"x","-----------","=",{"$f":"ROUND(D33*F32/F34,4)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"J7*(1+J7)^J15","v":{"$error":"#REF!"}}]
[]
["III.","Calculation of Unadjusted Monthly Avoided Cost of Capacity"]
[]
[]
[]
[]
[]
[]
[null,null,"Where:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Calculation for First Year"]
[]
[null,null,"T =",1]
[null,null,"S1 =",{"$f":"1-(1+J21)/(1+J7)","v":{"$error":"#REF!"}},"S4 =",{"$f":"J11*((1+J19)/(1+J7))","v":{"$error":"#REF!"}}]
[null,null,"S2 =",{"$f":"1-((1+J21)/(1+J7))^J15","v":{"$error":"#REF!"}},"S5 =",{"$f":"(1+J19)^(D69-1)","v":1}]
[null,null,"S3 =",{"$f":"(1+J21)^(D69-1)","v":1},"S6 =",{"$f":"1-J13/2","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"C =",null,{"$f":"(1/12)*(J17*J5*D70/D71*D72+F70*F71)/F72","v":{"$error":"#REF!"}}]
[]
[null,"Calculation for Second Year"]
[]
[null,null,"T =",2]
[null,null,"S1 =",{"$f":"1-(1+J21)/(1+J7)","v":{"$error":"#REF!"}},"S4 =",{"$f":"J11*((1+J19)/(1+J7))","v":{"$error":"#REF!"}}]
[null,null,"S2 =",{"$f":"1-((1+J21)/(1+J7))^J15","v":{"$error":"#REF!"}},"S5 =",{"$f":"(1+J19)^(D85-1)","v":1.02}]
[null,null,"S3 =",{"$f":"(1+J21)^(D85-1)","v":1.02},"S6 =",{"$f":"1-J13/2","v":{"$error":"#REF!"}}]
[]
[null,"C =",null,{"$f":"(1/12)*(J17*J5*D86/D87*D88+F86*F87)/F88","v":{"$error":"#REF!"}}]
[]
[null,"Calculation for Third Year"]
[]
[null,null,"T =",3]
[null,null,"S1 =",{"$f":"1-(1+J21)/(1+J7)","v":{"$error":"#REF!"}},"S4 =",{"$f":"J11*((1+J19)/(1+J7))","v":{"$error":"#REF!"}}]
[null,null,"S2 =",{"$f":"1-((1+J21)/(1+J7))^J15","v":{"$error":"#REF!"}},"S5 =",{"$f":"(1+J19)^(D94-1)","v":1.0404}]
[null,null,"S3 =",{"$f":"(1+J21)^(D94-1)","v":1.0404},"S6 =",{"$f":"1-J13/2","v":{"$error":"#REF!"}}]
[]
[null,"C =",null,{"$f":"(1/12)*(J17*J5*D95/D96*D97+F95*F96)/F97","v":{"$error":"#REF!"}}]
[]
[]
[null,"Three Year Average Avoided Cost of Capacity = ",null,null,null,{"$f":"+(D81+D90+D99)/3","v":{"$error":"#REF!"}},"on peak"]
[null," TOD Measurement"]
[]
[null,"Three Year Average Avoided Cost of Capacity = ",null,null,null,{"$f":"+G154/I156*F102","v":{"$error":"#REF!"}},"average"]
[null,"  Standard Measurement"]
[]
[]
["Cost Calculations (Support Page 1, Assumptions A & D)"]
[]
[]
[]
[]
[]
["I.","Operations & Maintenance Cost per kW (2020 Dollars)"]
[]
[null,null,"Fixed & Variable Operations & Maintenance Cost ",null,null,null,null,17.72,"mills/kWh"]
[null,null,"Hours per Year",null,null,null,"x",8760,"hours"]
[null,null,"Unit Size",null,null,null,"x",490000,"kW"]
[null,null,"Capacity Factor",null,null,null,"x",0.25]
[null,null,"Planned Outage Rate",null,null,null,"x",0.1]
[null,null,"Total Variable O&M Cost",null,null,null,null,{"$f":"H117*(H118*(1-H121))*H119*H120/1000","v":17113798.799999997},"/year"]
[null,null,"Unit Size",null,null,null,"/",{"$f":"+H119","v":490000},"kW"]
[null,null,"Per Unit Variable O&M Cost",null,null,null,null,{"$f":"ROUND(H122/H123,2)","v":34.93},"/kW"]
[]
[]
[]
[]
[]
[]
[]
["I.","Energy Payment Calculation *",null,null,null,null,"On-Peak","Off-Peak","Non-TOD"]
[]
[]
[null,"A","Potential Loss Savings"]
[]
[null,null,"Primary Losses",null,null,null,null,null,{"$f":"+H174","v":{"$error":"#REF!"}}]
[null,null,"Divided by 2",null,null,null,null,"/",2]
[null,null,"Loss Adjustment (Potential Loss Savings)",null,null,null,null,null,{"$f":"+I137/I138","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[null,"B","Time-of-Day Energy Payments"]
[]
[null,null,"Avoided Energy Costs (2020-2022 Average)",null,null,null,3.0419999999999998,2.2650000000000001,null,"¢/kWh"]
[null,null,"Divided by (1 - Loss Savings)",null,null,null,{"$f":"1-I139","v":{"$error":"#REF!"}},{"$f":"G147","v":{"$error":"#REF!"}}]
[null,null,"Time-of-Day Energy Payments",null,null,null,{"$f":"ROUND(G146/G147,2)","v":{"$error":"#REF!"}},{"$f":"ROUND(H146/H147,2)","v":{"$error":"#REF!"}},null,"¢/kWh"]
[]
[]
[null,"C","Non-Time-of-Day Energy Payment"]
[]
[null,null,"Time-of-Day Energy Payments",null,null,null,{"$f":"+G148","v":{"$error":"#REF!"}},{"$f":"+H148","v":{"$error":"#REF!"}},null,"¢/kWh"]
[null,null,"Hours per Year",null,null,"x",3650,5110,null,"hours"]
[null,null,"Weighted Average of Hourly TOD Payments",null,null,null,{"$f":"ROUND(G153*G154,0)","v":{"$error":"#REF!"}},{"$f":"ROUND(H153*H154,0)","v":{"$error":"#REF!"}},{"$f":"+G155+H155","v":{"$error":"#REF!"}}]
[null,null,"Hours Per Year",null,null,null,null,null,{"$f":"+G154+H154","v":8760}]
[null,null,"Non-Time-of-Day Energy Payment",null,null,null,null,null,{"$f":"ROUND(I155/I156,2)","v":{"$error":"#REF!"}},"¢/kWh"]
[]
[]
[null,"* On-Peak Period is 7am - 9pm, Monday through Friday"]
[null,"   Off-Peak Period is all other hours"]
[]
[]
[]
["II.","Demand and Energy Loss Calculations **"]
[]
[null,null,null,"System",null,"Demand",null,"Energy"]
[]
[null,null,"Transmission",null,null,{"$f":"'[1]Demand Basis'!B15-'[1]Demand Basis'!E15","v":{"$error":"#REF!"}},null,{"$f":"'[1]Energy Basis'!B15-'[1]Energy Basis'!E15","v":{"$error":"#REF!"}}]
[]
[null,null,"Subtransmission",null,null,{"$f":"'[1]Demand Basis'!B15-'[1]Demand Basis'!D15","v":{"$error":"#REF!"}},null,{"$f":"'[1]Energy Basis'!B15-'[1]Energy Basis'!D15","v":{"$error":"#REF!"}}]
[]
[]
[null,null,"Primary",null,null,{"$f":"'[1]Demand Basis'!B15-'[1]Demand Basis'!C15","v":{"$error":"#REF!"}},null,{"$f":"'[1]Energy Basis'!B15-'[1]Energy Basis'!C15","v":{"$error":"#REF!"}}]
[]
[null,null,"Compound Loss Factor",null,null,{"$f":"ROUND((1+F169)*(1+F171)*(1+F174)-1,3)","v":{"$error":"#REF!"}},null,{"$f":"ROUND((1+H169)*(1+H171)*(1+H174)-1,3)","v":{"$error":"#REF!"}}]
[]
[]
[null,"** Assuming COGEN/SPP Service at Primary"]
[]
[]
["I.","Annual Carrying Charge Rates",null,null,null,null,"Variable","Value"]
[]
[null,null,"Fixed Costs",null,null,null,null,0.1255,null,"JRB-Edited, from Exhibit AEV-1, Carrying Charge at 20 Year Life"]
[null,null,"O&M",null,null,null,null,{"$f":"+F354","v":4.5969542380200033E-2}]
[null,null,"Carrying Costs",null,null,null,"CC",{"$f":"+H184+H185","v":0.17146954238020004}]
[]
[]
[]
["II.","Charges"]
[]
[null,null,"Contingencies",null,null,null,null,0.05]
[null,null,"Stores Expense",null,null,null,null,0.26]
[null,null,"Total Charges on Material",null,null,null,"MC",{"$f":"+H192+H193","v":0.31}]
[]
[null,null,"Labor",null,null,null,null,{"$f":"46%+10%","v":0.56000000000000005}]
[null,null,"Transportation Expense",null,null,null,null,0.22]
[null,null,"Total Charges on Labor",null,null,null,"LC",{"$f":"+H196+H197","v":0.78}]
[]
[]
[]
["III.","Overheads"]
[]
[null,null,"Company Construction Overheads",null,null,null,"OC",0.23]
[]
[]
[]
["IV.","Monthly Charge on Incremental Material"]
[]
[null,"IM = ",null,"Incremental Material Cost"]
[null,"IL =",null,"Incremental Labor Cost (50% of Material) = 0.5 x IM"]
[]
[]
[]
[null,"OR:"]
[]
[]
[]
[]
[null,"Monthly Charge on IM =",null,null,{"$f":"ROUND((1+H204)*((1+H194)+(1+H198)*0.5)*H186/12,4)","v":3.8699999999999998E-2},"of Incremental Material Cost"]
[]
[]
["V.","Monthly Meter Charges",null,null,null,null,null,"Incremental","Monthly",null,"Average"]
[null,null,null,null,null,null,null,"Material (IM)","Charge",null,"Charge"]
[null,null,null,null,null,null,null,null,{"$f":"+E220","v":3.8699999999999998E-2}]
[null,"Standard Measurement"]
[null,null,"Single Phase"]
[null,null,null,"Option 2 - Primary - Transformer Rated",null,null,null,391,{"$f":"ROUND(H228*I$225,2)","v":15.13}]
[null,null,null,"Option 2 - Secondary - Self-Contained",null,null,null,38,{"$f":"ROUND(H229*I$225,2)","v":1.47}]
[null,null,null,"Option 3 - Primary - Transformer Rated",null,null,null,391,{"$f":"ROUND(H230*I$225,2)","v":15.13}]
[null,null,null,"Option 3 - Secondary - Transformer Rated ",null,null,null,391,{"$f":"ROUND(H231*I$225,2)","v":15.13}]
[null,null,null,"Option 3 - Secondary - Self Contained ",null,null,null,38,{"$f":"ROUND(H232*I$225,2)","v":1.47}]
[null,null,"Total",null,null,null,null,null,{"$f":"SUM(I228:I232)","v":48.330000000000005},"/    5    =",{"$f":"ROUND(I233/5,2)","v":9.67}]
[null,null,null,null,null,null,null,null,null,"Use:",{"$f":"K235","v":9.25}]
[null,null,null,null,null,null,null,null,null,"current",9.25]
[null,null,"Polyphase"]
[null,null,null,"Option 2 - Primary - Transformer Rated",null,null,null,391,{"$f":"ROUND(H237*I$225,2)","v":15.13}]
[null,null,null,"Option 2 - Secondary - Self-Contained",null,null,null,230,{"$f":"ROUND(H238*I$225,2)","v":8.9}]
[null,null,null,"Option 3 - Primary - Transformer Rated (or Sec. >200 Amps)",null,null,null,391,{"$f":"ROUND(H239*I$225,2)","v":15.13}]
[null,null,null,"Option 3 - Secondary - Transformer Rated (Below 200 Amps)",null,null,null,391,{"$f":"ROUND(H240*I$225,2)","v":15.13}]
[null,null,null,"Option 3 - Secondary - Self Contained (Below 200 Amps)",null,null,null,230,{"$f":"ROUND(H241*I$225,2)","v":8.9}]
[null,null,"Total",null,null,null,null,null,{"$f":"SUM(I237:I241)","v":63.190000000000005},"/    5    =",{"$f":"ROUND(I242/5,2)","v":12.64}]
[null,null,null,null,null,null,null,null,null,"Use:",{"$f":"K244","v":12.1}]
[null,null,null,null,null,null,null,null,null,"current",12.1]
[]
[null,"Time-of-Day Measurement"]
[null,null,"Single Phase"]
[null,null,null,"Option 2 - Primary - Transformer Rated",null,null,null,400,{"$f":"ROUND(H248*I$225,2)","v":15.48}]
[null,null,null,"Option 2 - Secondary - Self-Contained",null,null,null,96,{"$f":"ROUND(H249*I$225,2)","v":3.72}]
[null,null,null,"Option 3 - Primary - Transformer Rated",null,null,null,400,{"$f":"ROUND(H250*I$225,2)","v":15.48}]
[null,null,null,"Option 3 - Secondary - Transformer Rated ",null,null,null,400,{"$f":"ROUND(H251*I$225,2)","v":15.48}]
[null,null,null,"Option 3 - Secondary - Self Contained ",null,null,null,38,{"$f":"ROUND(H252*I$225,2)","v":1.47}]
[null,null,"Total",null,null,null,null,null,{"$f":"SUM(I248:I252)","v":51.629999999999995},"/    5    =",{"$f":"ROUND(I253/5,2)","v":10.33}]
[null,null,null,null,null,null,null,null,null,"Use:",{"$f":"K255","v":9.85}]
[null,null,null,null,null,null,null,null,null,"Current",9.85]
[null,null,"Polyphase"]
[null,null,null,"Option 2 - Primary - Transformer Rated",null,null,null,400,{"$f":"ROUND(H257*I$225,2)","v":15.48}]
[null,null,null,"Option 2 - Secondary - Self-Contained",null,null,null,239,{"$f":"ROUND(H258*I$225,2)","v":9.25}]
[null,null,null,"Option 3 - Primary - Transformer Rated",null,null,null,400,{"$f":"ROUND(H259*I$225,2)","v":15.48}]
[null,null,null,"Option 3 - Secondary - Transformer Rated",null,null,null,400,{"$f":"ROUND(H260*I$225,2)","v":15.48}]
[null,null,null,"Option 3 - Secondary - Self Contained",null,null,null,239,{"$f":"ROUND(H261*I$225,2)","v":9.25}]
[null,null,"Total",null,null,null,null,null,{"$f":"SUM(I257:I261)","v":64.94},"/    5    =",{"$f":"ROUND(I262/5,2)","v":12.99}]
[null,null,null,null,null,null,null,null,null,"Use:",{"$f":"K264","v":12.4}]
[null,null,null,null,null,null,null,null,null,"current ",12.4]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["I.","Calculation of Cost Escalation Rates *"]
[null,null,null,null,null,null,null,"Cumulative"]
[null,null,null,null,null,null,null,"Escalation"]
[null,null,null,"Year",null,"Rate",null,"Rates"]
[]
[null,null,null,2017,null,1.9334453880914985E-2,null,{"$f":"(1+F311)","v":1.019334453880915}]
[null,null,null,{"$f":"+D311+1","v":2018},null,2.5507594633270972E-2,null,{"$f":"H311*(1+F312)","v":1.0453352239262361}]
[null,null,null,2019,null,2.793526200943857E-2,null,1.0745369372943108]
[null,null,null,2020,null,2.4713651898512351E-2,null,1.1010926691146958]
[null,null,null,2021,null,1.9044494703772261E-2,null,1.1220624226200131]
[null,null,null,2022,null,1.6562219641083363E-2,null,1.1406462669144517]
[null,null,null,2023,null,1.8651736239009484E-2,null,1.1619213002269508]
[null,null,null,2024,null,1.8861008042374894E-2,null,1.1838363072151381]
[null,null,null,2025,null,1.9497707041035501E-2,null,1.2069184007177602]
[null,null,null,2026,null,2.0046066603851755E-2,null,1.2311123673639628]
[null,null,null,2027,null,2.0091255193746702E-2,null,1.2558469601088498]
[null,null,null,2028,null,2.0322859225751902E-2,null,1.2813693610882304]
[null,null,null,2029,null,2.0491088355354476E-2,null,1.3076260138821334]
[null,null,null,2030,null,2.0215214500519593E-2,null,1.3340599542392202]
[null,null,null,2031,null,{"$f":"+F324","v":2.0215214500519593E-2},null,1.3610282623707195]
[null,null,null,2032,null,2.0215214500519593E-2,null,1.3885417406358131]
[null,null,null,2033,null,2.0215214500519593E-2,null,1.416611409765691]
[null,null,null,2034,null,2.0215214500519593E-2,null,1.445248513277988]
[null,null,null,2035,null,2.0215214500519593E-2,null,1.4744645219804597]
[null,null,null,2036,null,2.0215214500519593E-2,null,1.5042711385657008]
[null,null,null,2037,null,2.0215214500519593E-2,null,1.5346803022987474]
[null,null,null,2038,null,2.0215214500519593E-2,null,1.5657041937994389]
[null,null,null,2039,null,2.0215214500519593E-2,null,1.5973552399214579]
[null,null,null,2040,null,2.0215214500519593E-2,null,1.6296461187299993]
[null,null,null,2041,null,2.0215214500519593E-2,null,1.6625897645800656]
[]
[]
[null,null,null,"Compound Escalation Rate:",null,{"$f":"FIXED(D311,0,1)&\" to \"&FIXED(D335,0,1)&\" =\"","v":"2017 to 2041 ="},{"$f":"+H335","v":1.6625897645800656}]
[]
[null,null,null,"Number of Years",null,null,{"$f":"DATEDIF(DATE(D311,1,1),DATE(D335+1,1,1),\"y\")","v":25}]
[]
[null,null,null,"Average Rate (25th Root)",null,null,{"$f":"ROUND(G338^(1/G340)-1,3)","v":2.1000000000000001E-2}]
[]
[]
[null,"* Based upon Moody's Economy.com, GDP Chain Price Deflator"]
[]
[]
["II.","Calculation of Meter O&M Expense as a % of Original Cost (Per Books Total Company Values)"]
[]
[null,null,null,"Account 586 - Operation",null,1066179]
[null,null,null,"Account 597 - Maintenance",null,77731]
[null,null,null,"Total O&M",null,{"$f":"SUM(F350:F351)","v":1143910}]
[null,null,null,"Account 370 - Meter Plant",null,24884085]
[null,null,null,"O&M Percentage",null,{"$f":"F352/F353","v":4.5969542380200033E-2}]

{"sheet":"Cogen ($799 kW)","index":1,"n_rows":354,"n_cols":12,"rows_kept":354,"cut":false,"hidden":false,"merged":[]}
[]
[]
["I.","Assumptions",null,null,null,null,null,null,"Variable","Value"]
[]
[null,"A)","Capital Cost per kW of Capacity",null,null,null,null,null,"V",799,"/kW","JRB-Edited"]
[]
[null,"B)","Weighted Cost of Capital (Workpaper S-2)",null,null,null,null,null,"R",{"$f":"'[1]Carrying Charge'!B10/100","v":{"$error":"#REF!"}}]
[]
[null,"C)","Carrying Charge Rate",null,null,null,null,null,"CCR",{"$f":"12.55%","v":0.1255},null,"JRB-Edited, from Exhibit AEV-1, Carrying Charge"]
[]
[null,"D)","Operation & Maintenance Cost per Year (Fixed & Variable)",null,null,null,null,null,"O",{"$f":"H124","v":34.93},"/kW"]
[]
[null,"E)","Line Losses",null,null,null,null,null,"L",{"$f":"+F176","v":{"$error":"#REF!"}}]
[]
[null,"F)","Estimated Unit Life",null,null,null,null,null,"N",20,"years","JRB-Edited"]
[]
[null,"G)","Present Value of Carrying Charge for $1 Investment for N years",null,null,null,null,null,"D",{"$f":"+H33","v":{"$error":"#REF!"}}]
[]
[null,"H)","Fixed Operation and Maintenance Cost Escalation Rate",null,null,null,null,null,"IO",0.02]
[]
[null,"I)","Construction Cost Escalation Rate",null,null,null,null,null,"IP",{"$f":"+J19","v":0.02}]
[]
[]
[]
[]
["II.","Calculation of Present Value of Carrying Charge"]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"(1+J7)^J15-1","v":{"$error":"#REF!"}}]
[null,"D =",null,{"$f":"+J9","v":0.1255},"x","-----------","=",{"$f":"ROUND(D33*F32/F34,4)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"J7*(1+J7)^J15","v":{"$error":"#REF!"}}]
[]
["III.","Calculation of Unadjusted Monthly Avoided Cost of Capacity"]
[]
[]
[]
[]
[]
[]
[null,null,"Where:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Calculation for First Year"]
[]
[null,null,"T =",1]
[null,null,"S1 =",{"$f":"1-(1+J21)/(1+J7)","v":{"$error":"#REF!"}},"S4 =",{"$f":"J11*((1+J19)/(1+J7))","v":{"$error":"#REF!"}}]
[null,null,"S2 =",{"$f":"1-((1+J21)/(1+J7))^J15","v":{"$error":"#REF!"}},"S5 =",{"$f":"(1+J19)^(D69-1)","v":1}]
[null,null,"S3 =",{"$f":"(1+J21)^(D69-1)","v":1},"S6 =",{"$f":"1-J13/2","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"C =",null,{"$f":"(1/12)*(J17*J5*D70/D71*D72+F70*F71)/F72","v":{"$error":"#REF!"}}]
[]
[null,"Calculation for Second Year"]
[]
[null,null,"T =",2]
[null,null,"S1 =",{"$f":"1-(1+J21)/(1+J7)","v":{"$error":"#REF!"}},"S4 =",{"$f":"J11*((1+J19)/(1+J7))","v":{"$error":"#REF!"}}]
[null,null,"S2 =",{"$f":"1-((1+J21)/(1+J7))^J15","v":{"$error":"#REF!"}},"S5 =",{"$f":"(1+J19)^(D85-1)","v":1.02}]
[null,null,"S3 =",{"$f":"(1+J21)^(D85-1)","v":1.02},"S6 =",{"$f":"1-J13/2","v":{"$error":"#REF!"}}]
[]
[null,"C =",null,{"$f":"(1/12)*(J17*J5*D86/D87*D88+F86*F87)/F88","v":{"$error":"#REF!"}}]
[]
[null,"Calculation for Third Year"]
[]
[null,null,"T =",3]
[null,null,"S1 =",{"$f":"1-(1+J21)/(1+J7)","v":{"$error":"#REF!"}},"S4 =",{"$f":"J11*((1+J19)/(1+J7))","v":{"$error":"#REF!"}}]
[null,null,"S2 =",{"$f":"1-((1+J21)/(1+J7))^J15","v":{"$error":"#REF!"}},"S5 =",{"$f":"(1+J19)^(D94-1)","v":1.0404}]
[null,null,"S3 =",{"$f":"(1+J21)^(D94-1)","v":1.0404},"S6 =",{"$f":"1-J13/2","v":{"$error":"#REF!"}}]
[]
[null,"C =",null,{"$f":"(1/12)*(J17*J5*D95/D96*D97+F95*F96)/F97","v":{"$error":"#REF!"}}]
[]
[]
[null,"Three Year Average Avoided Cost of Capacity = ",null,null,null,{"$f":"+(D81+D90+D99)/3","v":{"$error":"#REF!"}},"on peak"]
[null," TOD Measurement"]
[]
[null,"Three Year Average Avoided Cost of Capacity = ",null,null,null,{"$f":"+G154/I156*F102","v":{"$error":"#REF!"}},"average"]
[null,"  Standard Measurement"]
[]
[]
["Cost Calculations (Support Page 1, Assumptions A & D)"]
[]
[]
[]
[]
[]
["I.","Operations & Maintenance Cost per kW (2020 Dollars)"]
[]
[null,null,"Fixed & Variable Operations & Maintenance Cost ",null,null,null,null,17.72,"mills/kWh"]
[null,null,"Hours per Year",null,null,null,"x",8760,"hours"]
[null,null,"Unit Size",null,null,null,"x",490000,"kW"]
[null,null,"Capacity Factor",null,null,null,"x",0.25]
[null,null,"Planned Outage Rate",null,null,null,"x",0.1]
[null,null,"Total Variable O&M Cost",null,null,null,null,{"$f":"H117*(H118*(1-H121))*H119*H120/1000","v":17113798.799999997},"/year"]
[null,null,"Unit Size",null,null,null,"/",{"$f":"+H119","v":490000},"kW"]
[null,null,"Per Unit Variable O&M Cost",null,null,null,null,{"$f":"ROUND(H122/H123,2)","v":34.93},"/kW"]
[]
[]
[]
[]
[]
[]
[]
["I.","Energy Payment Calculation *",null,null,null,null,"On-Peak","Off-Peak","Non-TOD"]
[]
[]
[null,"A","Potential Loss Savings"]
[]
[null,null,"Primary Losses",null,null,null,null,null,{"$f":"+H174","v":{"$error":"#REF!"}}]
[null,null,"Divided by 2",null,null,null,null,"/",2]
[null,null,"Loss Adjustment (Potential Loss Savings)",null,null,null,null,null,{"$f":"+I137/I138","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[null,"B","Time-of-Day Energy Payments"]
[]
[null,null,"Avoided Energy Costs (2020-2022 Average)",null,null,null,3.0419999999999998,2.2650000000000001,null,"¢/kWh"]
[null,null,"Divided by (1 - Loss Savings)",null,null,null,{"$f":"1-I139","v":{"$error":"#REF!"}},{"$f":"G147","v":{"$error":"#REF!"}}]
[null,null,"Time-of-Day Energy Payments",null,null,null,{"$f":"ROUND(G146/G147,2)","v":{"$error":"#REF!"}},{"$f":"ROUND(H146/H147,2)","v":{"$error":"#REF!"}},null,"¢/kWh"]
[]
[]
[null,"C","Non-Time-of-Day Energy Payment"]
[]
[null,null,"Time-of-Day Energy Payments",null,null,null,{"$f":"+G148","v":{"$error":"#REF!"}},{"$f":"+H148","v":{"$error":"#REF!"}},null,"¢/kWh"]
[null,null,"Hours per Year",null,null,"x",3650,5110,null,"hours"]
[null,null,"Weighted Average of Hourly TOD Payments",null,null,null,{"$f":"ROUND(G153*G154,0)","v":{"$error":"#REF!"}},{"$f":"ROUND(H153*H154,0)","v":{"$error":"#REF!"}},{"$f":"+G155+H155","v":{"$error":"#REF!"}}]
[null,null,"Hours Per Year",null,null,null,null,null,{"$f":"+G154+H154","v":8760}]
[null,null,"Non-Time-of-Day Energy Payment",null,null,null,null,null,{"$f":"ROUND(I155/I156,2)","v":{"$error":"#REF!"}},"¢/kWh"]
[]
[]
[null,"* On-Peak Period is 7am - 9pm, Monday through Friday"]
[null,"   Off-Peak Period is all other hours"]
[]
[]
[]
["II.","Demand and Energy Loss Calculations **"]
[]
[null,null,null,"System",null,"Demand",null,"Energy"]
[]
[null,null,"Transmission",null,null,{"$f":"'[1]Demand Basis'!B15-'[1]Demand Basis'!E15","v":{"$error":"#REF!"}},null,{"$f":"'[1]Energy Basis'!B15-'[1]Energy Basis'!E15","v":{"$error":"#REF!"}}]
[]
[null,null,"Subtransmission",null,null,{"$f":"'[1]Demand Basis'!B15-'[1]Demand Basis'!D15","v":{"$error":"#REF!"}},null,{"$f":"'[1]Energy Basis'!B15-'[1]Energy Basis'!D15","v":{"$error":"#REF!"}}]
[]
[]
[null,null,"Primary",null,null,{"$f":"'[1]Demand Basis'!B15-'[1]Demand Basis'!C15","v":{"$error":"#REF!"}},null,{"$f":"'[1]Energy Basis'!B15-'[1]Energy Basis'!C15","v":{"$error":"#REF!"}}]
[]
[null,null,"Compound Loss Factor",null,null,{"$f":"ROUND((1+F169)*(1+F171)*(1+F174)-1,3)","v":{"$error":"#REF!"}},null,{"$f":"ROUND((1+H169)*(1+H171)*(1+H174)-1,3)","v":{"$error":"#REF!"}}]
[]
[]
[null,"** Assuming COGEN/SPP Service at Primary"]
[]
[]
["I.","Annual Carrying Charge Rates",null,null,null,null,"Variable","Value"]
[]
[null,null,"Fixed Costs",null,null,null,null,0.1255,null,"JRB-Edited, from Exhibit AEV-1, Carrying Charge at 20 Year Life"]
[null,null,"O&M",null,null,null,null,{"$f":"+F354","v":4.5969542380200033E-2}]
[null,null,"Carrying Costs",null,null,null,"CC",{"$f":"+H184+H185","v":0.17146954238020004}]
[]
[]
[]
["II.","Charges"]
[]
[null,null,"Contingencies",null,null,null,null,0.05]
[null,null,"Stores Expense",null,null,null,null,0.26]
[null,null,"Total Charges on Material",null,null,null,"MC",{"$f":"+H192+H193","v":0.31}]
[]
[null,null,"Labor",null,null,null,null,{"$f":"46%+10%","v":0.56000000000000005}]
[null,null,"Transportation Expense",null,null,null,null,0.22]
[null,null,"Total Charges on Labor",null,null,null,"LC",{"$f":"+H196+H197","v":0.78}]
[]
[]
[]
["III.","Overheads"]
[]
[null,null,"Company Construction Overheads",null,null,null,"OC",0.23]
[]
[]
[]
["IV.","Monthly Charge on Incremental Material"]
[]
[null,"IM = ",null,"Incremental Material Cost"]
[null,"IL =",null,"Incremental Labor Cost (50% of Material) = 0.5 x IM"]
[]
[]
[]
[null,"OR:"]
[]
[]
[]
[]
[null,"Monthly Charge on IM =",null,null,{"$f":"ROUND((1+H204)*((1+H194)+(1+H198)*0.5)*H186/12,4)","v":3.8699999999999998E-2},"of Incremental Material Cost"]
[]
[]
["V.","Monthly Meter Charges",null,null,null,null,null,"Incremental","Monthly",null,"Average"]
[null,null,null,null,null,null,null,"Material (IM)","Charge",null,"Charge"]
[null,null,null,null,null,null,null,null,{"$f":"+E220","v":3.8699999999999998E-2}]
[null,"Standard Measurement"]
[null,null,"Single Phase"]
[null,null,null,"Option 2 - Primary - Transformer Rated",null,null,null,391,{"$f":"ROUND(H228*I$225,2)","v":15.13}]
[null,null,null,"Option 2 - Secondary - Self-Contained",null,null,null,38,{"$f":"ROUND(H229*I$225,2)","v":1.47}]
[null,null,null,"Option 3 - Primary - Transformer Rated",null,null,null,391,{"$f":"ROUND(H230*I$225,2)","v":15.13}]
[null,null,null,"Option 3 - Secondary - Transformer Rated ",null,null,null,391,{"$f":"ROUND(H231*I$225,2)","v":15.13}]
[null,null,null,"Option 3 - Secondary - Self Contained ",null,null,null,38,{"$f":"ROUND(H232*I$225,2)","v":1.47}]
[null,null,"Total",null,null,null,null,null,{"$f":"SUM(I228:I232)","v":48.330000000000005},"/    5    =",{"$f":"ROUND(I233/5,2)","v":9.67}]
[null,null,null,null,null,null,null,null,null,"Use:",{"$f":"K235","v":9.25}]
[null,null,null,null,null,null,null,null,null,"current",9.25]
[null,null,"Polyphase"]
[null,null,null,"Option 2 - Primary - Transformer Rated",null,null,null,391,{"$f":"ROUND(H237*I$225,2)","v":15.13}]
[null,null,null,"Option 2 - Secondary - Self-Contained",null,null,null,230,{"$f":"ROUND(H238*I$225,2)","v":8.9}]
[null,null,null,"Option 3 - Primary - Transformer Rated (or Sec. >200 Amps)",null,null,null,391,{"$f":"ROUND(H239*I$225,2)","v":15.13}]
[null,null,null,"Option 3 - Secondary - Transformer Rated (Below 200 Amps)",null,null,null,391,{"$f":"ROUND(H240*I$225,2)","v":15.13}]
[null,null,null,"Option 3 - Secondary - Self Contained (Below 200 Amps)",null,null,null,230,{"$f":"ROUND(H241*I$225,2)","v":8.9}]
[null,null,"Total",null,null,null,null,null,{"$f":"SUM(I237:I241)","v":63.190000000000005},"/    5    =",{"$f":"ROUND(I242/5,2)","v":12.64}]
[null,null,null,null,null,null,null,null,null,"Use:",{"$f":"K244","v":12.1}]
[null,null,null,null,null,null,null,null,null,"current",12.1]
[]
[null,"Time-of-Day Measurement"]
[null,null,"Single Phase"]
[null,null,null,"Option 2 - Primary - Transformer Rated",null,null,null,400,{"$f":"ROUND(H248*I$225,2)","v":15.48}]
[null,null,null,"Option 2 - Secondary - Self-Contained",null,null,null,96,{"$f":"ROUND(H249*I$225,2)","v":3.72}]
[null,null,null,"Option 3 - Primary - Transformer Rated",null,null,null,400,{"$f":"ROUND(H250*I$225,2)","v":15.48}]
[null,null,null,"Option 3 - Secondary - Transformer Rated ",null,null,null,400,{"$f":"ROUND(H251*I$225,2)","v":15.48}]
[null,null,null,"Option 3 - Secondary - Self Contained ",null,null,null,38,{"$f":"ROUND(H252*I$225,2)","v":1.47}]
[null,null,"Total",null,null,null,null,null,{"$f":"SUM(I248:I252)","v":51.629999999999995},"/    5    =",{"$f":"ROUND(I253/5,2)","v":10.33}]
[null,null,null,null,null,null,null,null,null,"Use:",{"$f":"K255","v":9.85}]
[null,null,null,null,null,null,null,null,null,"Current",9.85]
[null,null,"Polyphase"]
[null,null,null,"Option 2 - Primary - Transformer Rated",null,null,null,400,{"$f":"ROUND(H257*I$225,2)","v":15.48}]
[null,null,null,"Option 2 - Secondary - Self-Contained",null,null,null,239,{"$f":"ROUND(H258*I$225,2)","v":9.25}]
[null,null,null,"Option 3 - Primary - Transformer Rated",null,null,null,400,{"$f":"ROUND(H259*I$225,2)","v":15.48}]
[null,null,null,"Option 3 - Secondary - Transformer Rated",null,null,null,400,{"$f":"ROUND(H260*I$225,2)","v":15.48}]
[null,null,null,"Option 3 - Secondary - Self Contained",null,null,null,239,{"$f":"ROUND(H261*I$225,2)","v":9.25}]
[null,null,"Total",null,null,null,null,null,{"$f":"SUM(I257:I261)","v":64.94},"/    5    =",{"$f":"ROUND(I262/5,2)","v":12.99}]
[null,null,null,null,null,null,null,null,null,"Use:",{"$f":"K264","v":12.4}]
[null,null,null,null,null,null,null,null,null,"current ",12.4]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["I.","Calculation of Cost Escalation Rates *"]
[null,null,null,null,null,null,null,"Cumulative"]
[null,null,null,null,null,null,null,"Escalation"]
[null,null,null,"Year",null,"Rate",null,"Rates"]
[]
[null,null,null,2017,null,1.9334453880914985E-2,null,{"$f":"(1+F311)","v":1.019334453880915}]
[null,null,null,{"$f":"+D311+1","v":2018},null,2.5507594633270972E-2,null,{"$f":"H311*(1+F312)","v":1.0453352239262361}]
[null,null,null,2019,null,2.793526200943857E-2,null,1.0745369372943108]
[null,null,null,2020,null,2.4713651898512351E-2,null,1.1010926691146958]
[null,null,null,2021,null,1.9044494703772261E-2,null,1.1220624226200131]
[null,null,null,2022,null,1.6562219641083363E-2,null,1.1406462669144517]
[null,null,null,2023,null,1.8651736239009484E-2,null,1.1619213002269508]
[null,null,null,2024,null,1.8861008042374894E-2,null,1.1838363072151381]
[null,null,null,2025,null,1.9497707041035501E-2,null,1.2069184007177602]
[null,null,null,2026,null,2.0046066603851755E-2,null,1.2311123673639628]
[null,null,null,2027,null,2.0091255193746702E-2,null,1.2558469601088498]
[null,null,null,2028,null,2.0322859225751902E-2,null,1.2813693610882304]
[null,null,null,2029,null,2.0491088355354476E-2,null,1.3076260138821334]
[null,null,null,2030,null,2.0215214500519593E-2,null,1.3340599542392202]
[null,null,null,2031,null,{"$f":"+F324","v":2.0215214500519593E-2},null,1.3610282623707195]
[null,null,null,2032,null,2.0215214500519593E-2,null,1.3885417406358131]
[null,null,null,2033,null,2.0215214500519593E-2,null,1.416611409765691]
[null,null,null,2034,null,2.0215214500519593E-2,null,1.445248513277988]
[null,null,null,2035,null,2.0215214500519593E-2,null,1.4744645219804597]
[null,null,null,2036,null,2.0215214500519593E-2,null,1.5042711385657008]
[null,null,null,2037,null,2.0215214500519593E-2,null,1.5346803022987474]
[null,null,null,2038,null,2.0215214500519593E-2,null,1.5657041937994389]
[null,null,null,2039,null,2.0215214500519593E-2,null,1.5973552399214579]
[null,null,null,2040,null,2.0215214500519593E-2,null,1.6296461187299993]
[null,null,null,2041,null,2.0215214500519593E-2,null,1.6625897645800656]
[]
[]
[null,null,null,"Compound Escalation Rate:",null,{"$f":"FIXED(D311,0,1)&\" to \"&FIXED(D335,0,1)&\" =\"","v":"2017 to 2041 ="},{"$f":"+H335","v":1.6625897645800656}]
[]
[null,null,null,"Number of Years",null,null,{"$f":"DATEDIF(DATE(D311,1,1),DATE(D335+1,1,1),\"y\")","v":25}]
[]
[null,null,null,"Average Rate (25th Root)",null,null,{"$f":"ROUND(G338^(1/G340)-1,3)","v":2.1000000000000001E-2}]
[]
[]
[null,"* Based upon Moody's Economy.com, GDP Chain Price Deflator"]
[]
[]
["II.","Calculation of Meter O&M Expense as a % of Original Cost (Per Books Total Company Values)"]
[]
[null,null,null,"Account 586 - Operation",null,1066179]
[null,null,null,"Account 597 - Maintenance",null,77731]
[null,null,null,"Total O&M",null,{"$f":"SUM(F350:F351)","v":1143910}]
[null,null,null,"Account 370 - Meter Plant",null,24884085]
[null,null,null,"O&M Percentage",null,{"$f":"F352/F353","v":4.5969542380200033E-2}]

{"sheet":"Sheet1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}