{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Inputs","Rate_Impacts_With_v_Without","year_to_year_calcs","Ref_Sheet"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":15,"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":"Inputs","index":0,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[[23,6,26,11]]}
[]
[null,"High-Level NEM Rate Impact Analysis"]
[null,"Rocky Mtn Power - Utah"]
[]
[null,"Model Structure"]
[null,null,"Sector / Rate Class","Residential"]
[null,null,"Base Year",2015]
[null,null,"Study Period (Years)",20]
[]
[null,"System Parameters"]
[null,null,"Residential Sales (MWh)",6300000,null,"Hayet"]
[null,null,"Residential Revenues ($)",747113309,null,"Hayet"]
[null,null,"Number of Residential Customers (count)",752114,null,"Hayet"]
[null,null,"Sales per customer (MWh)",{"$f":"D11/D13","v":8.3763897494262842},null,"Residential Sales / # of Customers"]
[null,null,"Customer growth rate",0,null,"Hayet"]
[null,null,"Electricity usage per customer growth rate",0,null,"User input"]
[null,"Rate Structure Parameters"]
[null,null,"Energy Rate ($/MWh)",151.81,null,"Hayet"]
[null,null,"Customer ($/Month)",6,null,"RMP Residential rate tariff "]
[null,null,"Minimum Bill ($/Month)",8,null,"RMP Residential rate tariff "]
[null,null,"Fixed Portion of Energy Rate (%)",0.74254173541515578,null,"Hayet"]
[null,"PV NEM System Parameters"]
[null,null,"Average PV installed capacity (MW, DC)",4.2420000000000001E-3,null,"Hayet"]
[null,null,"Unit capacity factor (%)",0.20298022923273307,null,"Hayet","Warning: You have entered a capacity and/or capacity factor that results in the annual generation being greater than annual consumption, which would trigger RMP's minimm bill. This version of the model doesn't account for minimum bills. "]
[null,null,"Unit generation (MWh)",{"$f":"8760*D24*D23","v":7.5427290798700231},null,"Calculation based on CF and Capacity"]
[null,null,"Percent of customers adding DG PV per year",{"$f":"20433/D13/10","v":2.7167424087305913E-3},null,"Hayet"]
[null,null,"Number of years with additional DG PV",10,null,"User input"]
[null,"Levelized Avoided Cost Inputs"]
[null,null,"Avoided energy ($/MWh)",40.720769435430306,null,"Avoided fuel, variable O&M, and line losses. "]
[null,null,"Avoided generation capacity capital costs ($/MWh)",12.800845441963569,null,"Capital cost of generation to meet peak load. "]
[null,null,"Avoided transmission capital costs ($/MWh)",null,null,"Cost of money savings resulting from defferring T&D capacity additions. "]
[null,null,"Avoided distribution capital costs ($/MWh)",null,null,"Cost of money savings resulting from defferring T&D capacity additions. Default from CPR 2014 (assumes zero avoided distribution)"]
[null,null,"Avoided environmental Costs ($/MWh)",null,null,"Costs to comply with environemetnal regulations and policy objectives. Default from CPR 2014."]
[null,null,"Fuel price guarantee/avoided risk ($/MWh)",null,null,"Cost of eliminating uncertainty in fuel price fluctuations. Default $0.00"]
[]
[null,null,"Variable Avoided Costs ($/MWh)",{"$f":"SUM(D29+D33+D34)","v":40.720769435430306},null,"Includes avoided energy, avoided environmental, and fuel price guarantee"]
[null,null,"Fixed Avoided Costs ($/MWh)",{"$f":"SUM(D30:D32)","v":12.800845441963569},null,"Includes avoided capital costs associated with generation and T&D capacity"]
[null,null,"Total Avoided Costs ($/MWh)",{"$f":"SUM(D36:D37)","v":53.521614877393873},null,"Sum of variable and fixed avoided costs"]

{"sheet":"Rate_Impacts_With_v_Without","index":1,"n_rows":96,"n_cols":25,"rows_kept":96,"cut":false,"hidden":false,"merged":[[62,4,62,5]]}
[null,"Utah NEM Rate Impact Analysis"]
[null,null,null,null,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034]
[null,null,"Universal"]
[null,"Customers x customer growth rate",null,"Customers (# of customers)",{"$f":"Inputs!$D$13","v":752114},{"$f":"E4*(1+Inputs!$D$15)","v":752114},{"$f":"F4*(1+Inputs!$D$15)","v":752114},{"$f":"G4*(1+Inputs!$D$15)","v":752114},{"$f":"H4*(1+Inputs!$D$15)","v":752114},{"$f":"I4*(1+Inputs!$D$15)","v":752114},{"$f":"J4*(1+Inputs!$D$15)","v":752114},{"$f":"K4*(1+Inputs!$D$15)","v":752114},{"$f":"L4*(1+Inputs!$D$15)","v":752114},{"$f":"M4*(1+Inputs!$D$15)","v":752114},{"$f":"N4*(1+Inputs!$D$15)","v":752114},{"$f":"O4*(1+Inputs!$D$15)","v":752114},{"$f":"P4*(1+Inputs!$D$15)","v":752114},{"$f":"Q4*(1+Inputs!$D$15)","v":752114},{"$f":"R4*(1+Inputs!$D$15)","v":752114},{"$f":"S4*(1+Inputs!$D$15)","v":752114},{"$f":"T4*(1+Inputs!$D$15)","v":752114},{"$f":"U4*(1+Inputs!$D$15)","v":752114},{"$f":"V4*(1+Inputs!$D$15)","v":752114},{"$f":"W4*(1+Inputs!$D$15)","v":752114}]
[null,"Typical annual demand x demand grwoth rate",null,"Usage per customer (annual MWh / customer)",{"$f":"Inputs!$D$14","v":8.3763897494262842},{"$f":"E5*(1+Inputs!$D$16)","v":8.3763897494262842},{"$f":"F5*(1+Inputs!$D$16)","v":8.3763897494262842},{"$f":"G5*(1+Inputs!$D$16)","v":8.3763897494262842},{"$f":"H5*(1+Inputs!$D$16)","v":8.3763897494262842},{"$f":"I5*(1+Inputs!$D$16)","v":8.3763897494262842},{"$f":"J5*(1+Inputs!$D$16)","v":8.3763897494262842},{"$f":"K5*(1+Inputs!$D$16)","v":8.3763897494262842},{"$f":"L5*(1+Inputs!$D$16)","v":8.3763897494262842},{"$f":"M5*(1+Inputs!$D$16)","v":8.3763897494262842},{"$f":"N5*(1+Inputs!$D$16)","v":8.3763897494262842},{"$f":"O5*(1+Inputs!$D$16)","v":8.3763897494262842},{"$f":"P5*(1+Inputs!$D$16)","v":8.3763897494262842},{"$f":"Q5*(1+Inputs!$D$16)","v":8.3763897494262842},{"$f":"R5*(1+Inputs!$D$16)","v":8.3763897494262842},{"$f":"S5*(1+Inputs!$D$16)","v":8.3763897494262842},{"$f":"T5*(1+Inputs!$D$16)","v":8.3763897494262842},{"$f":"U5*(1+Inputs!$D$16)","v":8.3763897494262842},{"$f":"V5*(1+Inputs!$D$16)","v":8.3763897494262842},{"$f":"W5*(1+Inputs!$D$16)","v":8.3763897494262842}]
[null,null,null,"Total residential electricity usage (MWh)",{"$f":"E5*E4","v":6300000},{"$f":"F5*F4","v":6300000},{"$f":"G5*G4","v":6300000},6300000,6300000,6300000,6300000,6300000,6300000,6300000,6300000,6300000,6300000,6300000,6300000,6300000,6300000,6300000,6300000,6300000]
[]
[null,"Scenario calculations for no DGPV case","No DG PV Case"]
[null,"Forecasted sales ","Annual Sales"]
[null,"Sales = Demand - customer generation ",null,"Annual residential sales (MWh)",{"$f":"E6","v":6300000},{"$f":"F6","v":6300000},6300000,6300000,6300000,6300000,6300000,6300000,6300000,6300000,6300000,6300000,6300000,6300000,6300000,6300000,6300000,6300000,6300000,6300000]
[null,null,"Rates"]
[null,"Fuel and Purchased Power Charge",null,"Energy Rate - variable portion ($/MWh)",{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":39.084739146625203},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":39.084739146625203},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":39.084739146625203},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":39.084739146625203},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":39.084739146625203},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":39.084739146625203},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":39.084739146625203},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":39.084739146625203},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":39.084739146625203},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":39.084739146625203},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":39.084739146625203},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":39.084739146625203},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":39.084739146625203},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":39.084739146625203},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":39.084739146625203},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":39.084739146625203},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":39.084739146625203},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":39.084739146625203},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":39.084739146625203},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":39.084739146625203}]
[null,"Energy rate times fixed portion",null,"Energy Rate - fixed portion ($/MWh)",{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":112.72526085337481},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":112.72526085337481},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":112.72526085337481},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":112.72526085337481},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":112.72526085337481},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":112.72526085337481},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":112.72526085337481},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":112.72526085337481},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":112.72526085337481},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":112.72526085337481},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":112.72526085337481},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":112.72526085337481},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":112.72526085337481},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":112.72526085337481},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":112.72526085337481},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":112.72526085337481},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":112.72526085337481},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":112.72526085337481},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":112.72526085337481},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":112.72526085337481}]
[null,"Sum of above",null,"Total Energy Rate ($/MWh)",{"$f":"E12+E13","v":151.81},{"$f":"F12+F13","v":151.81},151.81,151.81,151.81,151.81,151.81,151.81,151.81,151.81,151.81,151.81,151.81,151.81,151.81,151.81,151.81,151.81,151.81,151.81]
[null,"Customer charge",null,"Customer ($/Month)",{"$f":"Ref_Sheet!$C$6","v":6},{"$f":"Ref_Sheet!$C$6","v":6},{"$f":"Ref_Sheet!$C$6","v":6},{"$f":"Ref_Sheet!$C$6","v":6},{"$f":"Ref_Sheet!$C$6","v":6},{"$f":"Ref_Sheet!$C$6","v":6},{"$f":"Ref_Sheet!$C$6","v":6},{"$f":"Ref_Sheet!$C$6","v":6},{"$f":"Ref_Sheet!$C$6","v":6},{"$f":"Ref_Sheet!$C$6","v":6},{"$f":"Ref_Sheet!$C$6","v":6},{"$f":"Ref_Sheet!$C$6","v":6},{"$f":"Ref_Sheet!$C$6","v":6},{"$f":"Ref_Sheet!$C$6","v":6},{"$f":"Ref_Sheet!$C$6","v":6},{"$f":"Ref_Sheet!$C$6","v":6},{"$f":"Ref_Sheet!$C$6","v":6},{"$f":"Ref_Sheet!$C$6","v":6},{"$f":"Ref_Sheet!$C$6","v":6},{"$f":"Ref_Sheet!$C$6","v":6}]
[null,"Minimum bill ",null,"Minimum bill ($)",{"$f":"Ref_Sheet!$C$22","v":8},{"$f":"Ref_Sheet!$C$22","v":8},{"$f":"Ref_Sheet!$C$22","v":8},{"$f":"Ref_Sheet!$C$22","v":8},{"$f":"Ref_Sheet!$C$22","v":8},{"$f":"Ref_Sheet!$C$22","v":8},{"$f":"Ref_Sheet!$C$22","v":8},{"$f":"Ref_Sheet!$C$22","v":8},{"$f":"Ref_Sheet!$C$22","v":8},{"$f":"Ref_Sheet!$C$22","v":8},{"$f":"Ref_Sheet!$C$22","v":8},{"$f":"Ref_Sheet!$C$22","v":8},{"$f":"Ref_Sheet!$C$22","v":8},{"$f":"Ref_Sheet!$C$22","v":8},{"$f":"Ref_Sheet!$C$22","v":8},{"$f":"Ref_Sheet!$C$22","v":8},{"$f":"Ref_Sheet!$C$22","v":8},{"$f":"Ref_Sheet!$C$22","v":8},{"$f":"Ref_Sheet!$C$22","v":8},{"$f":"Ref_Sheet!$C$22","v":8}]
[null,"Forecasted Revnues","Annual Revenues and Costs"]
[null,"Energy sales x energy rate x var %",null,"Variable Revenues and Costs",{"$f":"(E12)*E10","v":246233856.6237388},246233856.6237388,246233856.6237388,246233856.6237388,246233856.6237388,246233856.6237388,246233856.6237388,246233856.6237388,246233856.6237388,246233856.6237388,246233856.6237388,246233856.6237388,246233856.6237388,{"$f":"(R12)*R10","v":246233856.6237388},246233856.6237388,246233856.6237388,246233856.6237388,246233856.6237388,246233856.6237388,246233856.6237388]
[null,"Energy sales x energy rate x fixed %",null,"Fixed Revenues and Costs",{"$f":"(E13)*E10","v":710169143.37626123},710169143.37626123,710169143.37626123,710169143.37626123,710169143.37626123,710169143.37626123,710169143.37626123,710169143.37626123,710169143.37626123,710169143.37626123,710169143.37626123,710169143.37626123,710169143.37626123,{"$f":"(R13)*R10","v":710169143.37626123},710169143.37626123,710169143.37626123,710169143.37626123,710169143.37626123,710169143.37626123,710169143.37626123]
[null,"Sum of fixed and variable",null,"Total Energy Rate Revenues and Costs",{"$f":"E18+E19","v":956403000},{"$f":"F18+F19","v":956403000},{"$f":"G18+G19","v":956403000},956403000,956403000,956403000,956403000,956403000,956403000,956403000,956403000,956403000,956403000,{"$f":"R18+R19","v":956403000},956403000,956403000,956403000,956403000,956403000,956403000]
[null,"Customers x customer charge",null,"Customer Charge Revenues and Costs",{"$f":"E15*E4*12","v":54152208},{"$f":"F15*F4*12","v":54152208},54152208,54152208,54152208,54152208,54152208,54152208,54152208,54152208,54152208,54152208,54152208,{"$f":"R15*R4*12","v":54152208},54152208,54152208,54152208,54152208,54152208,54152208]
[null,"Sum of Energy Rate and Customer Charge",null,"Total Revenues and Costs",{"$f":"E20+E21","v":1010555208},{"$f":"F20+F21","v":1010555208},1010555208,1010555208,1010555208,1010555208,1010555208,1010555208,1010555208,1010555208,1010555208,1010555208,1010555208,{"$f":"R20+R21","v":1010555208},1010555208,1010555208,1010555208,1010555208,1010555208,1010555208]
[null,null,null,"Percent of total costs that are \"fixed\"",{"$f":"(E19+E21)/E22","v":0.75633804598260135},{"$f":"(F19+F21)/F22","v":0.75633804598260135},{"$f":"(G19+G21)/G22","v":0.75633804598260135},{"$f":"(H19+H21)/H22","v":0.75633804598260135},{"$f":"(I19+I21)/I22","v":0.75633804598260135},{"$f":"(J19+J21)/J22","v":0.75633804598260135},{"$f":"(K19+K21)/K22","v":0.75633804598260135},{"$f":"(L19+L21)/L22","v":0.75633804598260135},{"$f":"(M19+M21)/M22","v":0.75633804598260135},{"$f":"(N19+N21)/N22","v":0.75633804598260135},{"$f":"(O19+O21)/O22","v":0.75633804598260135},{"$f":"(P19+P21)/P22","v":0.75633804598260135},{"$f":"(Q19+Q21)/Q22","v":0.75633804598260135},{"$f":"(R19+R21)/R22","v":0.75633804598260135},{"$f":"(S19+S21)/S22","v":0.75633804598260135},{"$f":"(T19+T21)/T22","v":0.75633804598260135},{"$f":"(U19+U21)/U22","v":0.75633804598260135},{"$f":"(V19+V21)/V22","v":0.75633804598260135},{"$f":"(W19+W21)/W22","v":0.75633804598260135},{"$f":"(X19+X21)/X22","v":0.75633804598260135}]
[]
[null,null,"With DG PV"]
[null,"Forecasted sales ","Annual Sales"]
[null,"% of customers with PV +  grwoth rate",null,"Customers with PV (%)",{"$f":"Inputs!D26","v":2.7167424087305913E-3},{"$f":"MIN(E27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":5.4334848174611827E-3},{"$f":"MIN(F27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":8.1502272261917731E-3},{"$f":"MIN(G27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":1.0866969634922365E-2},{"$f":"MIN(H27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":1.3583712043652958E-2},{"$f":"MIN(I27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":1.630045445238355E-2},{"$f":"MIN(J27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":1.9017196861114142E-2},{"$f":"MIN(K27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":2.1733939269844734E-2},{"$f":"MIN(L27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":2.4450681678575326E-2},{"$f":"MIN(M27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":2.7167424087305915E-2},{"$f":"MIN(N27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":2.7167424087305915E-2},{"$f":"MIN(O27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":2.7167424087305915E-2},{"$f":"MIN(P27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":2.7167424087305915E-2},{"$f":"MIN(Q27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":2.7167424087305915E-2},{"$f":"MIN(R27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":2.7167424087305915E-2},{"$f":"MIN(S27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":2.7167424087305915E-2},{"$f":"MIN(T27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":2.7167424087305915E-2},{"$f":"MIN(U27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":2.7167424087305915E-2},{"$f":"MIN(V27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":2.7167424087305915E-2},{"$f":"MIN(W27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":2.7167424087305915E-2}]
[null,"Customers x % with DGPV * typical DGPV gen",null,"Annual Customer PV Gen (MWh)",{"$f":"E4*E27*Inputs!$D$25","v":15412.058328898418},{"$f":"F4*F27*Inputs!$D$25","v":30824.116657796836},{"$f":"G4*G27*Inputs!$D$25","v":46236.174986695252},{"$f":"H4*H27*Inputs!$D$25","v":61648.233315593672},{"$f":"I4*I27*Inputs!$D$25","v":77060.291644492085},{"$f":"J4*J27*Inputs!$D$25","v":92472.349973390519},{"$f":"K4*K27*Inputs!$D$25","v":107884.40830228894},{"$f":"L4*L27*Inputs!$D$25","v":123296.46663118736},{"$f":"M4*M27*Inputs!$D$25","v":138708.52496008581},{"$f":"N4*N27*Inputs!$D$25","v":154120.58328898417},{"$f":"O4*O27*Inputs!$D$25","v":154120.58328898417},{"$f":"P4*P27*Inputs!$D$25","v":154120.58328898417},{"$f":"Q4*Q27*Inputs!$D$25","v":154120.58328898417},{"$f":"R4*R27*Inputs!$D$25","v":154120.58328898417},{"$f":"S4*S27*Inputs!$D$25","v":154120.58328898417},{"$f":"T4*T27*Inputs!$D$25","v":154120.58328898417},{"$f":"U4*U27*Inputs!$D$25","v":154120.58328898417},{"$f":"V4*V27*Inputs!$D$25","v":154120.58328898417},{"$f":"W4*W27*Inputs!$D$25","v":154120.58328898417},{"$f":"X4*X27*Inputs!$D$25","v":154120.58328898417}]
[null,"Net Sales = Demand - customer generation ",null,"Net annual residential sales [after PV] (MWh)",{"$f":"E6-E28","v":6284587.9416711014},6269175.8833422028,6253763.8250133051,6238351.7666844064,6222939.7083555078,6207527.6500266092,6192115.5916977115,6176703.5333688129,6161291.4750399143,6145879.4167110156,6145879.4167110156,6145879.4167110156,6145879.4167110156,6145879.4167110156,6145879.4167110156,6145879.4167110156,6145879.4167110156,6145879.4167110156,6145879.4167110156,6145879.4167110156]
[null,null,null,"Installed DG PV (MW)",{"$f":"E27*E4*Inputs!$D$23","v":8.6676786000000003},{"$f":"F27*F4*Inputs!$D$23","v":17.335357200000001},{"$f":"G27*G4*Inputs!$D$23","v":26.003035799999999},{"$f":"H27*H4*Inputs!$D$23","v":34.670714400000001},{"$f":"I27*I4*Inputs!$D$23","v":43.338393000000003},{"$f":"J27*J4*Inputs!$D$23","v":52.006071600000006},{"$f":"K27*K4*Inputs!$D$23","v":60.673750200000008},{"$f":"L27*L4*Inputs!$D$23","v":69.341428800000003},{"$f":"M27*M4*Inputs!$D$23","v":78.009107400000019},{"$f":"N27*N4*Inputs!$D$23","v":86.676786000000007},{"$f":"O27*O4*Inputs!$D$23","v":86.676786000000007},{"$f":"P27*P4*Inputs!$D$23","v":86.676786000000007},{"$f":"Q27*Q4*Inputs!$D$23","v":86.676786000000007},{"$f":"R27*R4*Inputs!$D$23","v":86.676786000000007},{"$f":"S27*S4*Inputs!$D$23","v":86.676786000000007},{"$f":"T27*T4*Inputs!$D$23","v":86.676786000000007},{"$f":"U27*U4*Inputs!$D$23","v":86.676786000000007},{"$f":"V27*V4*Inputs!$D$23","v":86.676786000000007},{"$f":"W27*W4*Inputs!$D$23","v":86.676786000000007},{"$f":"X27*X4*Inputs!$D$23","v":86.676786000000007}]
[null,null,"Rates"]
[null,"New variable costs / net sales",null,"Energy Rate - variable portion ($/MWh)",{"$f":"E40/E29","v":39.080727014967103},{"$f":"F40/F29","v":39.076695156567155},39.072643425578917,39.068571674714711,39.064479755227715,39.060367516893876,39.056234807993505,39.052081475292667,39.047907364024184,39.043712317868447,39.043712317868447,39.043712317868447,39.043712317868447,39.043712317868447,39.043712317868447,39.043712317868447,39.043712317868447,39.043712317868447,39.043712317868447,39.043712317868447]
[null,"New fixed costs / net sales",null,"Energy Rate - fixed portion ($/MWh)",{"$f":"E41/E29","v":112.97031127403807},113.2165665520692,113.46403559538312,113.71272739992401,113.96265105075526,114.21381572316598,114.4662306837937,114.71990529176415,114.97484899984792,115.23107135563471,115.23107135563471,115.23107135563471,115.23107135563471,115.23107135563471,115.23107135563471,115.23107135563471,115.23107135563471,115.23107135563471,115.23107135563471,115.23107135563471]
[null,"Sum of above",null,"Total Energy Rate ($/kWh)",{"$f":"E33+E32","v":152.05103828900516},{"$f":"F33+F32","v":152.29326170863635},152.53667902096203,152.78129907463872,153.02713080598298,153.27418324005987,153.52246549178722,153.77198676705683,154.02275636387211,154.27478367350315,154.27478367350315,154.27478367350315,154.27478367350315,154.27478367350315,154.27478367350315,154.27478367350315,154.27478367350315,154.27478367350315,154.27478367350315,154.27478367350315]
[null,"Same as No DG PV",null,"Customer ($/Month)",{"$f":"Inputs!$D$19","v":6},{"$f":"Inputs!$D$19","v":6},{"$f":"Inputs!$D$19","v":6},{"$f":"Inputs!$D$19","v":6},{"$f":"Inputs!$D$19","v":6},{"$f":"Inputs!$D$19","v":6},{"$f":"Inputs!$D$19","v":6},{"$f":"Inputs!$D$19","v":6},{"$f":"Inputs!$D$19","v":6},{"$f":"Inputs!$D$19","v":6},{"$f":"Inputs!$D$19","v":6},{"$f":"Inputs!$D$19","v":6},{"$f":"Inputs!$D$19","v":6},{"$f":"Inputs!$D$19","v":6},{"$f":"Inputs!$D$19","v":6},{"$f":"Inputs!$D$19","v":6},{"$f":"Inputs!$D$19","v":6},{"$f":"Inputs!$D$19","v":6},{"$f":"Inputs!$D$19","v":6},{"$f":"Inputs!$D$19","v":6}]
[null,"Same as No DG PV",null,"Minimum bill ($)",{"$f":"Inputs!$D$20","v":8},{"$f":"Inputs!$D$20","v":8},{"$f":"Inputs!$D$20","v":8},{"$f":"Inputs!$D$20","v":8},{"$f":"Inputs!$D$20","v":8},{"$f":"Inputs!$D$20","v":8},{"$f":"Inputs!$D$20","v":8},{"$f":"Inputs!$D$20","v":8},{"$f":"Inputs!$D$20","v":8},{"$f":"Inputs!$D$20","v":8},{"$f":"Inputs!$D$20","v":8},{"$f":"Inputs!$D$20","v":8},{"$f":"Inputs!$D$20","v":8},{"$f":"Inputs!$D$20","v":8},{"$f":"Inputs!$D$20","v":8},{"$f":"Inputs!$D$20","v":8},{"$f":"Inputs!$D$20","v":8},{"$f":"Inputs!$D$20","v":8},{"$f":"Inputs!$D$20","v":8},{"$f":"Inputs!$D$20","v":8}]
[null,"Forecasted Revnues / Costs","Annual Revenues and Costs"]
[null,"Costs avoided",null,"Avoided costs - variable",{"$f":"(Inputs!$D$36)*E$28","v":627590.87373647583},{"$f":"(Inputs!$D$36)*F$28","v":1255181.7474729517},{"$f":"(Inputs!$D$36)*G$28","v":1882772.6212094272},{"$f":"(Inputs!$D$36)*H$28","v":2510363.4949459033},{"$f":"(Inputs!$D$36)*I$28","v":3137954.3686823784},{"$f":"(Inputs!$D$36)*J$28","v":3765545.242418855},{"$f":"(Inputs!$D$36)*K$28","v":4393136.116155331},{"$f":"(Inputs!$D$36)*L$28","v":5020726.9898918066},{"$f":"(Inputs!$D$36)*M$28","v":5648317.8636282841},{"$f":"(Inputs!$D$36)*N$28","v":6275908.7373647569},{"$f":"(Inputs!$D$36)*O$28","v":6275908.7373647569},{"$f":"(Inputs!$D$36)*P$28","v":6275908.7373647569},{"$f":"(Inputs!$D$36)*Q$28","v":6275908.7373647569},{"$f":"(Inputs!$D$36)*R$28","v":6275908.7373647569},{"$f":"(Inputs!$D$36)*S$28","v":6275908.7373647569},{"$f":"(Inputs!$D$36)*T$28","v":6275908.7373647569},{"$f":"(Inputs!$D$36)*U$28","v":6275908.7373647569},{"$f":"(Inputs!$D$36)*V$28","v":6275908.7373647569},{"$f":"(Inputs!$D$36)*W$28","v":6275908.7373647569},{"$f":"(Inputs!$D$36)*X$28","v":6275908.7373647569}]
[null,"Costs avoided",null,"Avoided costs - fixed",{"$f":"(Inputs!$D$37)*E$28","v":197287.37661075598},{"$f":"(Inputs!$D$37)*F$28","v":394574.75322151196},{"$f":"(Inputs!$D$37)*G$28","v":591862.12983226788},{"$f":"(Inputs!$D$37)*H$28","v":789149.50644302391},{"$f":"(Inputs!$D$37)*I$28","v":986436.88305377983},{"$f":"(Inputs!$D$37)*J$28","v":1183724.259664536},{"$f":"(Inputs!$D$37)*K$28","v":1381011.6362752919},{"$f":"(Inputs!$D$37)*L$28","v":1578299.0128860478},{"$f":"(Inputs!$D$37)*M$28","v":1775586.3894968042},{"$f":"(Inputs!$D$37)*N$28","v":1972873.7661075597},{"$f":"(Inputs!$D$37)*O$28","v":1972873.7661075597},{"$f":"(Inputs!$D$37)*P$28","v":1972873.7661075597},{"$f":"(Inputs!$D$37)*Q$28","v":1972873.7661075597},{"$f":"(Inputs!$D$37)*R$28","v":1972873.7661075597},{"$f":"(Inputs!$D$37)*S$28","v":1972873.7661075597},{"$f":"(Inputs!$D$37)*T$28","v":1972873.7661075597},{"$f":"(Inputs!$D$37)*U$28","v":1972873.7661075597},{"$f":"(Inputs!$D$37)*V$28","v":1972873.7661075597},{"$f":"(Inputs!$D$37)*W$28","v":1972873.7661075597},{"$f":"(Inputs!$D$37)*X$28","v":1972873.7661075597}]
[null,"No DG PV less avoided fixed costs",null,"Variable Revenues and Costs",{"$f":"E18-E38","v":245606265.75000232},244978674.87626585,244351084.00252938,243723493.12879288,243095902.25505641,242468311.38131994,241840720.50758347,241213129.633847,240585538.7601105,239957947.88637403,239957947.88637403,239957947.88637403,239957947.88637403,239957947.88637403,239957947.88637403,239957947.88637403,239957947.88637403,239957947.88637403,239957947.88637403,239957947.88637403]
[null,"No DG PV less avoided fixed costs",null,"Fixed Revenues and Costs",{"$f":"E19-E39","v":709971855.99965048},709774568.62303972,709577281.24642897,709379993.86981821,709182706.49320745,708985419.1165967,708788131.73998594,708590844.36337519,708393556.98676443,708196269.61015368,708196269.61015368,708196269.61015368,708196269.61015368,708196269.61015368,708196269.61015368,708196269.61015368,708196269.61015368,708196269.61015368,708196269.61015368,708196269.61015368]
[null,"Sum of fixed and variable",null,"Total Energy Rate Revenues and Costs",{"$f":"E40+E41","v":955578121.74965286},{"$f":"F40+F41","v":954753243.49930561},953928365.24895835,953103486.99861109,952278608.74826384,951453730.4979167,950628852.24756944,949803973.99722219,948979095.74687493,948154217.49652767,948154217.49652767,948154217.49652767,948154217.49652767,948154217.49652767,948154217.49652767,948154217.49652767,948154217.49652767,948154217.49652767,948154217.49652767,948154217.49652767]
[null,"Same as No DG PV",null,"Customer Charge Revenues and Costs",{"$f":"E21","v":54152208},54152208,54152208,54152208,54152208,54152208,54152208,54152208,54152208,54152208,54152208,54152208,54152208,54152208,54152208,54152208,54152208,54152208,54152208,54152208]
[null,"Sum of Energy Rate and Customer Charge",null,"Total Revenues and Costs",{"$f":"E42+E43","v":1009730329.7496529},{"$f":"F42+F43","v":1008905451.4993056},1008080573.2489583,1007255694.9986111,1006430816.7482638,1005605938.4979167,1004781060.2475694,1003956181.9972222,1003131303.7468749,1002306425.4965277,1002306425.4965277,1002306425.4965277,1002306425.4965277,1002306425.4965277,1002306425.4965277,1002306425.4965277,1002306425.4965277,1002306425.4965277,1002306425.4965277,1002306425.4965277]
[null,null,null,"Percent of total costs that are \"fixed\"",{"$f":"(E41+E43)/E44","v":0.75676053445785207},{"$f":"(F41+F43)/F44","v":0.75718371378387339},0.75760758565656461,0.7580321517773807,0.75845741385335441,0.75888337359711966,0.75931003272693454,0.75973739296670384,0.76016545604600272,0.7605942237001001,0.7605942237001001,0.7605942237001001,0.7605942237001001,0.7605942237001001,0.7605942237001001,0.7605942237001001,0.7605942237001001,0.7605942237001001,0.7605942237001001,0.7605942237001001]
[]
[null,null,"Differences"]
[null,null,"Rates"]
[null,null,null,"Change in Energy Rate - variable portion ($/MWh)",{"$f":"E32-E12","v":-4.0121316581007704E-3},-8.0439900580486778E-3,-1.2095721046286201E-2,-1.6167471910492281E-2,-2.0259391397488002E-2,-2.4371629731327005E-2,-2.8504338631698545E-2,-3.2657671332536609E-2,-3.6831782601019825E-2,-4.1026828756756117E-2,-4.1026828756756117E-2,-4.1026828756756117E-2,-4.1026828756756117E-2,-4.1026828756756117E-2,-4.1026828756756117E-2,-4.1026828756756117E-2,-4.1026828756756117E-2,-4.1026828756756117E-2,-4.1026828756756117E-2,-4.1026828756756117E-2]
[null,null,null,"Change in Energy Rate - fixed portion ($/MWh)",{"$f":"E33-E13","v":0.24505042066326155},0.49130569869439,0.73877474200831728,0.98746654654920007,1.2373901973804493,1.488554869791173,1.7409698304188908,1.9946444383893436,2.2495881464731156,2.5058105022599051,2.5058105022599051,2.5058105022599051,2.5058105022599051,2.5058105022599051,2.5058105022599051,2.5058105022599051,2.5058105022599051,2.5058105022599051,2.5058105022599051,2.5058105022599051]
[null,null,null,"Change in Total Energy Rate ($/MWh)",{"$f":"E34-E14","v":0.24103828900516078},0.48326170863634843,0.72667902096202397,0.971299074638722,1.2171308059829755,1.4641832400598673,1.7124654917872135,1.9619867670568283,2.2127563638721028,2.464783673503149,2.464783673503149,2.464783673503149,2.464783673503149,2.464783673503149,2.464783673503149,2.464783673503149,2.464783673503149,2.464783673503149,2.464783673503149,2.464783673503149,"`"]
[null,null,null,"Change in Customer ($/Month)",{"$f":"E35-E15","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Change in Minimum bill ($)",{"$f":"E36-E16","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Change in Energy Rate - variable portion (%)",{"$f":"E32/E12-1","v":-1.0265212831661596E-4},-2.0580897387778574E-4,-3.0947426822802715E-4,-4.136517797864725E-4,-5.1834531430505759E-4,-6.2355871533126273E-4,-7.2929586467918028E-4,-8.3556068290546737E-4,-9.4235712979551245E-4,-1.049689204854265E-3,-1.049689204854265E-3,-1.049689204854265E-3,-1.049689204854265E-3,-1.049689204854265E-3,-1.049689204854265E-3,-1.049689204854265E-3,-1.049689204854265E-3,-1.049689204854265E-3,-1.049689204854265E-3,-1.049689204854265E-3]
[null,null,null,"Change in Energy Rate - fixed portion (%)",{"$f":"E33/E13-1","v":2.1738731745495343E-3},4.3584347907026366E-3,6.5537638716957058E-3,8.7599402216831379E-3,1.0977044435408034E-2,1.3205157908016574E-2,1.5444362845018489E-2,1.7694742272398312E-2,1.9956380046875388E-2,2.2229360866321546E-2,2.2229360866321546E-2,2.2229360866321546E-2,2.2229360866321546E-2,2.2229360866321546E-2,2.2229360866321546E-2,2.2229360866321546E-2,2.2229360866321546E-2,2.2229360866321546E-2,2.2229360866321546E-2,2.2229360866321546E-2]
[null,null,null,"Change in Total Energy Rate (%)",{"$f":"E34/E14-1","v":1.5877629207901034E-3},3.1833325119317024E-3,4.7867664907583762E-3,6.3981231449754539E-3,8.0174613397205885E-3,9.6448405247340219E-3,1.1280320741632321E-2,1.2923962631294472E-2,1.4575827441354994E-2,1.6235977033812965E-2,1.6235977033812965E-2,1.6235977033812965E-2,1.6235977033812965E-2,1.6235977033812965E-2,1.6235977033812965E-2,1.6235977033812965E-2,1.6235977033812965E-2,1.6235977033812965E-2,1.6235977033812965E-2,1.6235977033812965E-2]
[]
[null,"Avoided Costs",null,"Energy Rate impact due to AC  (¢/kWh)",{"$f":"(E42/E10-E14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-1.3093305561065451E-2},{"$f":"(F42/F10-F14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-2.6186611122133743E-2},{"$f":"(G42/G10-G14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-3.9279916683202035E-2},{"$f":"(H42/H10-H14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-5.2373222244267485E-2},{"$f":"(I42/I10-I14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-6.5466527805335781E-2},{"$f":"(J42/J10-J14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-7.8559833366401224E-2},{"$f":"(K42/K10-K14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-9.1653138927469513E-2},{"$f":"(L42/L10-L14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.10474644448853782},{"$f":"(M42/M10-M14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.11783975004960326},{"$f":"(N42/N10-N14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.13093305561067156},{"$f":"(O42/O10-O14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.13093305561067156},{"$f":"(P42/P10-P14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.13093305561067156},{"$f":"(Q42/Q10-Q14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.13093305561067156},{"$f":"(R42/R10-R14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.13093305561067156},{"$f":"(S42/S10-S14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.13093305561067156},{"$f":"(T42/T10-T14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.13093305561067156},{"$f":"(U42/U10-U14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.13093305561067156},{"$f":"(V42/V10-V14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.13093305561067156},{"$f":"(W42/W10-W14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.13093305561067156},{"$f":"(X42/X10-X14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.13093305561067156}]
[null,"Recovery of Lost Revenues",null,"Energy rate impact due to lost revenues (¢/kWh)",{"$f":"E61-E59","v":3.719713446158153E-2},{"$f":"F61-F59","v":7.4512781985768592E-2},{"$f":"G61-G59","v":0.11194781877940443},0.1495031297081397,0.18717960840363335,0.22497815737238797,0.26289968810619085,0.30094512119422068,0.33911538643681355,0.37741142296098645,0.37741142296098645,0.37741142296098645,0.37741142296098645,0.37741142296098645,0.37741142296098645,0.37741142296098645,0.37741142296098645,0.37741142296098645,0.37741142296098645,0.37741142296098645]
[null,"Net Effect",null,"Energy rate impact of both  (¢/kWh)",{"$f":"E51/10","v":2.4103828900516079E-2},{"$f":"F51/10","v":4.8326170863634846E-2},{"$f":"G51/10","v":7.26679020962024E-2},9.7129907463872206E-2,0.12171308059829755,0.14641832400598673,0.17124654917872134,0.19619867670568283,0.22127563638721029,0.24647836735031489,0.24647836735031489,0.24647836735031489,0.24647836735031489,0.24647836735031489,0.24647836735031489,0.24647836735031489,0.24647836735031489,0.24647836735031489,0.24647836735031489,0.24647836735031489]
[]
[null,null,null,null,"Averages"]
[null,null,null,null,"10 yrs","20 yrs"]
[null,null,null,"Change in Energy Rate - variable portion ($/MWh)",{"$f":"AVERAGE(E49:N49)","v":-2.2397095712375404E-2},{"$f":"AVERAGE(E49:X49)","v":-3.1711962234565759E-2}]
[null,null,null,"Change in Energy Rate - fixed portion ($/MWh)",{"$f":"AVERAGE(E50:N50)","v":1.3679555392628047},{"$f":"AVERAGE(E50:X50)","v":1.9368830207613548}]
[null,null,null,"Change in Total Energy Rate ($/MWh)",{"$f":"AVERAGE(E51:N51)","v":1.3455584435504391},{"$f":"AVERAGE(E51:X51)","v":1.905171058526794}]
[null,null,null,"Customer ($/Month)",{"$f":"AVERAGE(E52:N52)","v":0},{"$f":"AVERAGE(E52:X52)","v":0}]
[null,null,null,"Minimum bill ($)",{"$f":"AVERAGE(E53:N53)","v":0},{"$f":"AVERAGE(E53:X53)","v":0}]
[]
[null,null,null,"Change in Energy Rate - variable portion (%)",{"$f":"AVERAGE(E55:N55)","v":-5.7303940620796463E-4},{"$f":"AVERAGE(E55:X55)","v":-8.113643055311148E-4}]
[null,null,null,"Change in Energy Rate - fixed portion (%)",{"$f":"AVERAGE(E56:N56)","v":1.2135306043266935E-2},{"$f":"AVERAGE(E56:X56)","v":1.7182333454794241E-2}]
[null,null,null,"Total Energy Rate (%)"]
[]
[null,null,null,"Energy Rate impact due to AC  (¢/kWh)",{"$f":"AVERAGE(E59:N59)","v":-7.201318058586878E-2},{"$f":"AVERAGE(E59:X59)","v":-0.10147311809827017}]
[null,null,null,"Energy rate impact due to lost revenues  (¢/kWh)",{"$f":"AVERAGE(E60:N60)","v":0.20656902494091273},{"$f":"AVERAGE(E60:X60)","v":0.29199022395094965}]
[null,null,null,"Energy rate impact of both  (¢/kWh)",{"$f":"AVERAGE(E61:N61)","v":0.13455584435504392},{"$f":"AVERAGE(E61:X61)","v":0.19051710585267936}]
[]
[null,null,null,"annual bill w/o DG",{"$f":"E5*E14+E15*12","v":1343.6197278604043},{"$f":"F5*F14+F15*12","v":1343.6197278604043},1343.6197278604043,1343.6197278604043,1343.6197278604043,1343.6197278604043,1343.6197278604043,1343.6197278604043,1343.6197278604043,1343.6197278604043,1343.6197278604043,1343.6197278604043,1343.6197278604043,1343.6197278604043,1343.6197278604043,1343.6197278604043,1343.6197278604043,1343.6197278604043,1343.6197278604043,1343.6197278604043]
[null,null,null,"annual bill w/ DG",{"$f":"E79+E84","v":1345.6387585136463},{"$f":"F79+F84","v":1347.667716282916},1349.7066745627137,1351.7557074728354,1353.814889867351,1355.8842973437236,1357.9640062520568,1360.0540937044891,1362.1546375847204,1364.2657165576893,1364.2657165576893,1364.2657165576893,1364.2657165576893,1364.2657165576893,1364.2657165576893,1364.2657165576893,1364.2657165576893,1364.2657165576893,1364.2657165576893,1364.2657165576893]
[null,null,null,"Annual Impact to Avg non-NM customer"]
[null,null,null,"impact due to AC ",{"$f":"E59*10*$E$5","v":-1.0967463048781478},-2.1934926097565337,-3.2902389146349198,-4.3869852195130674,-5.4837315243914544,-6.5804778292696016,-7.6772241341479877,-8.7739704390263729,-9.8707167439045218,-10.967463048782909,-10.967463048782909,-10.967463048782909,-10.967463048782909,-10.967463048782909,-10.967463048782909,-10.967463048782909,-10.967463048782909,-10.967463048782909,-10.967463048782909,-10.967463048782909]
[null,null,null,"impact due to lost revenues ",{"$f":"E60*10*$E$5","v":3.115776958120227},6.2414810322682754,9.3771856169443453,12.522964831944096,15.678893531338204,18.845047312588839,22.021502525800642,25.208336283111208,28.405626468220582,31.613451746067945,31.613451746067945,31.613451746067945,31.613451746067945,31.613451746067945,31.613451746067945,31.613451746067945,31.613451746067945,31.613451746067945,31.613451746067945,31.613451746067945]
[null,null,null,"impact of both ",{"$f":"E61*10*$E$5","v":2.019030653242079},4.0479884225117404,6.0869467023094259,8.1359796124310257,10.195162006946747,12.264569483319237,14.344278391652656,16.43436584408483,18.534909724316059,20.645988697285038,20.645988697285038,20.645988697285038,20.645988697285038,20.645988697285038,20.645988697285038,20.645988697285038,20.645988697285038,20.645988697285038,20.645988697285038,20.645988697285038]
[]
[null,null,null,"Hayet customer size sens.",8.3437000000000001,{"$f":"E86","v":8.3437000000000001},{"$f":"F86","v":8.3437000000000001},8.3437000000000001,8.3437000000000001,8.3437000000000001,8.3437000000000001,8.3437000000000001,8.3437000000000001,8.3437000000000001,8.3437000000000001,8.3437000000000001,8.3437000000000001,8.3437000000000001,8.3437000000000001,8.3437000000000001,8.3437000000000001,8.3437000000000001,8.3437000000000001,8.3437000000000001]
[null,null,null,"impact to non-NM customer",{"$f":"E61*10*$E$86","v":2.0111511719723598},{"$f":"F61*10*$E$86","v":4.0321907183491001},6.0631917472008396,8.1042280890631044,10.155374305880153,12.216705700087514,14.288298323824973,16.370228988292059,18.462575273239665,20.565415536608224,20.565415536608224,20.565415536608224,20.565415536608224,20.565415536608224,20.565415536608224,20.565415536608224,20.565415536608224,20.565415536608224,20.565415536608224,20.565415536608224]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"variable",{"$f":"N49*$E$86","v":-0.34231555109774603},731681,{"$f":"N89*O89","v":-250465.78474274991}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N90*O90","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"avoided capacity",{"$f":"((-Inputs!D37*N28)/N29)*$E$86","v":-2.6783907926200143},{"$f":"O89","v":731681},-1959727.6535350047]
[null,null,null,null,null,null,null,null,null,null,null,null,"fixed shift",{"$f":"N93-N91","v":23.586121880325983},{"$f":"O91","v":731681},17257517.243518796,"testimony calc",{"$f":"ROUND(P92/1000000,1)","v":17.3}]
[null,null,null,null,null,null,null,null,null,null,null,null,"fixed cost",{"$f":"N50*$E$86","v":20.907731087705969},{"$f":"O91","v":731681},15297789.589983791]
[null,null,null,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,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"variable + fixed",{"$f":"N51*$E$86","v":20.565415536608224},{"$f":"O93","v":731681},15047323.805241043]

{"sheet":"year_to_year_calcs","index":2,"n_rows":29,"n_cols":24,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,"Utah NEM Rate Impact Analysis"]
[null,null,null,null,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034]
[null,"Scenario calculations for no DGPV case","No DG PV Case"]
[null,null,"Rates"]
[null,"Fuel and Purchased Power Charge",null,"Energy Rate - variable portion ($/MWh)",{"$f":"Rate_Impacts_With_v_Without!E12","v":39.084739146625203},{"$f":"Rate_Impacts_With_v_Without!F12","v":39.084739146625203},{"$f":"Rate_Impacts_With_v_Without!G12","v":39.084739146625203},{"$f":"Rate_Impacts_With_v_Without!H12","v":39.084739146625203},{"$f":"Rate_Impacts_With_v_Without!I12","v":39.084739146625203},{"$f":"Rate_Impacts_With_v_Without!J12","v":39.084739146625203},{"$f":"Rate_Impacts_With_v_Without!K12","v":39.084739146625203},{"$f":"Rate_Impacts_With_v_Without!L12","v":39.084739146625203},{"$f":"Rate_Impacts_With_v_Without!M12","v":39.084739146625203},{"$f":"Rate_Impacts_With_v_Without!N12","v":39.084739146625203},{"$f":"Rate_Impacts_With_v_Without!O12","v":39.084739146625203},{"$f":"Rate_Impacts_With_v_Without!P12","v":39.084739146625203},{"$f":"Rate_Impacts_With_v_Without!Q12","v":39.084739146625203},{"$f":"Rate_Impacts_With_v_Without!R12","v":39.084739146625203},{"$f":"Rate_Impacts_With_v_Without!S12","v":39.084739146625203},{"$f":"Rate_Impacts_With_v_Without!T12","v":39.084739146625203},{"$f":"Rate_Impacts_With_v_Without!U12","v":39.084739146625203},{"$f":"Rate_Impacts_With_v_Without!V12","v":39.084739146625203},{"$f":"Rate_Impacts_With_v_Without!W12","v":39.084739146625203},{"$f":"Rate_Impacts_With_v_Without!X12","v":39.084739146625203}]
[null,"Energy rate times fixed portion",null,"Energy Rate - fixed portion ($/MWh)",{"$f":"Rate_Impacts_With_v_Without!E13","v":112.72526085337481},{"$f":"Rate_Impacts_With_v_Without!F13","v":112.72526085337481},{"$f":"Rate_Impacts_With_v_Without!G13","v":112.72526085337481},{"$f":"Rate_Impacts_With_v_Without!H13","v":112.72526085337481},{"$f":"Rate_Impacts_With_v_Without!I13","v":112.72526085337481},{"$f":"Rate_Impacts_With_v_Without!J13","v":112.72526085337481},{"$f":"Rate_Impacts_With_v_Without!K13","v":112.72526085337481},{"$f":"Rate_Impacts_With_v_Without!L13","v":112.72526085337481},{"$f":"Rate_Impacts_With_v_Without!M13","v":112.72526085337481},{"$f":"Rate_Impacts_With_v_Without!N13","v":112.72526085337481},{"$f":"Rate_Impacts_With_v_Without!O13","v":112.72526085337481},{"$f":"Rate_Impacts_With_v_Without!P13","v":112.72526085337481},{"$f":"Rate_Impacts_With_v_Without!Q13","v":112.72526085337481},{"$f":"Rate_Impacts_With_v_Without!R13","v":112.72526085337481},{"$f":"Rate_Impacts_With_v_Without!S13","v":112.72526085337481},{"$f":"Rate_Impacts_With_v_Without!T13","v":112.72526085337481},{"$f":"Rate_Impacts_With_v_Without!U13","v":112.72526085337481},{"$f":"Rate_Impacts_With_v_Without!V13","v":112.72526085337481},{"$f":"Rate_Impacts_With_v_Without!W13","v":112.72526085337481},{"$f":"Rate_Impacts_With_v_Without!X13","v":112.72526085337481}]
[null,"Sum of above",null,"Total Energy Rate ($/MWh)",{"$f":"Rate_Impacts_With_v_Without!E14","v":151.81},{"$f":"Rate_Impacts_With_v_Without!F14","v":151.81},{"$f":"Rate_Impacts_With_v_Without!G14","v":151.81},{"$f":"Rate_Impacts_With_v_Without!H14","v":151.81},{"$f":"Rate_Impacts_With_v_Without!I14","v":151.81},{"$f":"Rate_Impacts_With_v_Without!J14","v":151.81},{"$f":"Rate_Impacts_With_v_Without!K14","v":151.81},{"$f":"Rate_Impacts_With_v_Without!L14","v":151.81},{"$f":"Rate_Impacts_With_v_Without!M14","v":151.81},{"$f":"Rate_Impacts_With_v_Without!N14","v":151.81},{"$f":"Rate_Impacts_With_v_Without!O14","v":151.81},{"$f":"Rate_Impacts_With_v_Without!P14","v":151.81},{"$f":"Rate_Impacts_With_v_Without!Q14","v":151.81},{"$f":"Rate_Impacts_With_v_Without!R14","v":151.81},{"$f":"Rate_Impacts_With_v_Without!S14","v":151.81},{"$f":"Rate_Impacts_With_v_Without!T14","v":151.81},{"$f":"Rate_Impacts_With_v_Without!U14","v":151.81},{"$f":"Rate_Impacts_With_v_Without!V14","v":151.81},{"$f":"Rate_Impacts_With_v_Without!W14","v":151.81},{"$f":"Rate_Impacts_With_v_Without!X14","v":151.81}]
[null,"Customer charge",null,"Customer ($/Month)",{"$f":"Rate_Impacts_With_v_Without!E15","v":6},{"$f":"Rate_Impacts_With_v_Without!F15","v":6},{"$f":"Rate_Impacts_With_v_Without!G15","v":6},{"$f":"Rate_Impacts_With_v_Without!H15","v":6},{"$f":"Rate_Impacts_With_v_Without!I15","v":6},{"$f":"Rate_Impacts_With_v_Without!J15","v":6},{"$f":"Rate_Impacts_With_v_Without!K15","v":6},{"$f":"Rate_Impacts_With_v_Without!L15","v":6},{"$f":"Rate_Impacts_With_v_Without!M15","v":6},{"$f":"Rate_Impacts_With_v_Without!N15","v":6},{"$f":"Rate_Impacts_With_v_Without!O15","v":6},{"$f":"Rate_Impacts_With_v_Without!P15","v":6},{"$f":"Rate_Impacts_With_v_Without!Q15","v":6},{"$f":"Rate_Impacts_With_v_Without!R15","v":6},{"$f":"Rate_Impacts_With_v_Without!S15","v":6},{"$f":"Rate_Impacts_With_v_Without!T15","v":6},{"$f":"Rate_Impacts_With_v_Without!U15","v":6},{"$f":"Rate_Impacts_With_v_Without!V15","v":6},{"$f":"Rate_Impacts_With_v_Without!W15","v":6},{"$f":"Rate_Impacts_With_v_Without!X15","v":6}]
[null,"Minimum bill ",null,"Minimum bill ($)",{"$f":"Rate_Impacts_With_v_Without!E16","v":8},{"$f":"Rate_Impacts_With_v_Without!F16","v":8},{"$f":"Rate_Impacts_With_v_Without!G16","v":8},{"$f":"Rate_Impacts_With_v_Without!H16","v":8},{"$f":"Rate_Impacts_With_v_Without!I16","v":8},{"$f":"Rate_Impacts_With_v_Without!J16","v":8},{"$f":"Rate_Impacts_With_v_Without!K16","v":8},{"$f":"Rate_Impacts_With_v_Without!L16","v":8},{"$f":"Rate_Impacts_With_v_Without!M16","v":8},{"$f":"Rate_Impacts_With_v_Without!N16","v":8},{"$f":"Rate_Impacts_With_v_Without!O16","v":8},{"$f":"Rate_Impacts_With_v_Without!P16","v":8},{"$f":"Rate_Impacts_With_v_Without!Q16","v":8},{"$f":"Rate_Impacts_With_v_Without!R16","v":8},{"$f":"Rate_Impacts_With_v_Without!S16","v":8},{"$f":"Rate_Impacts_With_v_Without!T16","v":8},{"$f":"Rate_Impacts_With_v_Without!U16","v":8},{"$f":"Rate_Impacts_With_v_Without!V16","v":8},{"$f":"Rate_Impacts_With_v_Without!W16","v":8},{"$f":"Rate_Impacts_With_v_Without!X16","v":8}]
[]
[null,null,"With DG PV"]
[null,null,"Rates"]
[null,"New variable costs / net sales",null,"Energy Rate - variable portion ($/MWh)",{"$f":"Rate_Impacts_With_v_Without!E32","v":39.080727014967103},{"$f":"Rate_Impacts_With_v_Without!F32","v":39.076695156567155},{"$f":"Rate_Impacts_With_v_Without!G32","v":39.072643425578917},{"$f":"Rate_Impacts_With_v_Without!H32","v":39.068571674714711},{"$f":"Rate_Impacts_With_v_Without!I32","v":39.064479755227715},{"$f":"Rate_Impacts_With_v_Without!J32","v":39.060367516893876},{"$f":"Rate_Impacts_With_v_Without!K32","v":39.056234807993505},{"$f":"Rate_Impacts_With_v_Without!L32","v":39.052081475292667},{"$f":"Rate_Impacts_With_v_Without!M32","v":39.047907364024184},{"$f":"Rate_Impacts_With_v_Without!N32","v":39.043712317868447},{"$f":"Rate_Impacts_With_v_Without!O32","v":39.043712317868447},{"$f":"Rate_Impacts_With_v_Without!P32","v":39.043712317868447},{"$f":"Rate_Impacts_With_v_Without!Q32","v":39.043712317868447},{"$f":"Rate_Impacts_With_v_Without!R32","v":39.043712317868447},{"$f":"Rate_Impacts_With_v_Without!S32","v":39.043712317868447},{"$f":"Rate_Impacts_With_v_Without!T32","v":39.043712317868447},{"$f":"Rate_Impacts_With_v_Without!U32","v":39.043712317868447},{"$f":"Rate_Impacts_With_v_Without!V32","v":39.043712317868447},{"$f":"Rate_Impacts_With_v_Without!W32","v":39.043712317868447},{"$f":"Rate_Impacts_With_v_Without!X32","v":39.043712317868447}]
[null,"New fixed costs / net sales",null,"Energy Rate - fixed portion ($/MWh)",{"$f":"Rate_Impacts_With_v_Without!E33","v":112.97031127403807},{"$f":"Rate_Impacts_With_v_Without!F33","v":113.2165665520692},{"$f":"Rate_Impacts_With_v_Without!G33","v":113.46403559538312},{"$f":"Rate_Impacts_With_v_Without!H33","v":113.71272739992401},{"$f":"Rate_Impacts_With_v_Without!I33","v":113.96265105075526},{"$f":"Rate_Impacts_With_v_Without!J33","v":114.21381572316598},{"$f":"Rate_Impacts_With_v_Without!K33","v":114.4662306837937},{"$f":"Rate_Impacts_With_v_Without!L33","v":114.71990529176415},{"$f":"Rate_Impacts_With_v_Without!M33","v":114.97484899984792},{"$f":"Rate_Impacts_With_v_Without!N33","v":115.23107135563471},{"$f":"Rate_Impacts_With_v_Without!O33","v":115.23107135563471},{"$f":"Rate_Impacts_With_v_Without!P33","v":115.23107135563471},{"$f":"Rate_Impacts_With_v_Without!Q33","v":115.23107135563471},{"$f":"Rate_Impacts_With_v_Without!R33","v":115.23107135563471},{"$f":"Rate_Impacts_With_v_Without!S33","v":115.23107135563471},{"$f":"Rate_Impacts_With_v_Without!T33","v":115.23107135563471},{"$f":"Rate_Impacts_With_v_Without!U33","v":115.23107135563471},{"$f":"Rate_Impacts_With_v_Without!V33","v":115.23107135563471},{"$f":"Rate_Impacts_With_v_Without!W33","v":115.23107135563471},{"$f":"Rate_Impacts_With_v_Without!X33","v":115.23107135563471}]
[null,"Sum of above",null,"Total Energy Rate ($/MWh)",{"$f":"Rate_Impacts_With_v_Without!E34","v":152.05103828900516},{"$f":"Rate_Impacts_With_v_Without!F34","v":152.29326170863635},{"$f":"Rate_Impacts_With_v_Without!G34","v":152.53667902096203},{"$f":"Rate_Impacts_With_v_Without!H34","v":152.78129907463872},{"$f":"Rate_Impacts_With_v_Without!I34","v":153.02713080598298},{"$f":"Rate_Impacts_With_v_Without!J34","v":153.27418324005987},{"$f":"Rate_Impacts_With_v_Without!K34","v":153.52246549178722},{"$f":"Rate_Impacts_With_v_Without!L34","v":153.77198676705683},{"$f":"Rate_Impacts_With_v_Without!M34","v":154.02275636387211},{"$f":"Rate_Impacts_With_v_Without!N34","v":154.27478367350315},{"$f":"Rate_Impacts_With_v_Without!O34","v":154.27478367350315},{"$f":"Rate_Impacts_With_v_Without!P34","v":154.27478367350315},{"$f":"Rate_Impacts_With_v_Without!Q34","v":154.27478367350315},{"$f":"Rate_Impacts_With_v_Without!R34","v":154.27478367350315},{"$f":"Rate_Impacts_With_v_Without!S34","v":154.27478367350315},{"$f":"Rate_Impacts_With_v_Without!T34","v":154.27478367350315},{"$f":"Rate_Impacts_With_v_Without!U34","v":154.27478367350315},{"$f":"Rate_Impacts_With_v_Without!V34","v":154.27478367350315},{"$f":"Rate_Impacts_With_v_Without!W34","v":154.27478367350315},{"$f":"Rate_Impacts_With_v_Without!X34","v":154.27478367350315}]
[null,"Same as No DG PV",null,"Customer ($/Month)",{"$f":"Rate_Impacts_With_v_Without!E35","v":6},{"$f":"Rate_Impacts_With_v_Without!F35","v":6},{"$f":"Rate_Impacts_With_v_Without!G35","v":6},{"$f":"Rate_Impacts_With_v_Without!H35","v":6},{"$f":"Rate_Impacts_With_v_Without!I35","v":6},{"$f":"Rate_Impacts_With_v_Without!J35","v":6},{"$f":"Rate_Impacts_With_v_Without!K35","v":6},{"$f":"Rate_Impacts_With_v_Without!L35","v":6},{"$f":"Rate_Impacts_With_v_Without!M35","v":6},{"$f":"Rate_Impacts_With_v_Without!N35","v":6},{"$f":"Rate_Impacts_With_v_Without!O35","v":6},{"$f":"Rate_Impacts_With_v_Without!P35","v":6},{"$f":"Rate_Impacts_With_v_Without!Q35","v":6},{"$f":"Rate_Impacts_With_v_Without!R35","v":6},{"$f":"Rate_Impacts_With_v_Without!S35","v":6},{"$f":"Rate_Impacts_With_v_Without!T35","v":6},{"$f":"Rate_Impacts_With_v_Without!U35","v":6},{"$f":"Rate_Impacts_With_v_Without!V35","v":6},{"$f":"Rate_Impacts_With_v_Without!W35","v":6},{"$f":"Rate_Impacts_With_v_Without!X35","v":6}]
[null,"Same as No DG PV",null,"Minimum bill ($)",{"$f":"Rate_Impacts_With_v_Without!E36","v":8},{"$f":"Rate_Impacts_With_v_Without!F36","v":8},{"$f":"Rate_Impacts_With_v_Without!G36","v":8},{"$f":"Rate_Impacts_With_v_Without!H36","v":8},{"$f":"Rate_Impacts_With_v_Without!I36","v":8},{"$f":"Rate_Impacts_With_v_Without!J36","v":8},{"$f":"Rate_Impacts_With_v_Without!K36","v":8},{"$f":"Rate_Impacts_With_v_Without!L36","v":8},{"$f":"Rate_Impacts_With_v_Without!M36","v":8},{"$f":"Rate_Impacts_With_v_Without!N36","v":8},{"$f":"Rate_Impacts_With_v_Without!O36","v":8},{"$f":"Rate_Impacts_With_v_Without!P36","v":8},{"$f":"Rate_Impacts_With_v_Without!Q36","v":8},{"$f":"Rate_Impacts_With_v_Without!R36","v":8},{"$f":"Rate_Impacts_With_v_Without!S36","v":8},{"$f":"Rate_Impacts_With_v_Without!T36","v":8},{"$f":"Rate_Impacts_With_v_Without!U36","v":8},{"$f":"Rate_Impacts_With_v_Without!V36","v":8},{"$f":"Rate_Impacts_With_v_Without!W36","v":8},{"$f":"Rate_Impacts_With_v_Without!X36","v":8}]
[]
[null,null,"Year-to-Year Impacts"]
[null,null,"Rates - Change from Previous Year"]
[null,null,null,"Energy Rate - variable portion ($/MWh)","----",{"$f":"F13-E13","v":-4.0318583999479074E-3},{"$f":"G13-F13","v":-4.051730988237523E-3},-4.0717508642060807E-3,-4.0919194869957209E-3,{"$f":"J13-I13","v":-4.1122383338390023E-3},-4.13270890037154E-3,-4.1533327008380638E-3,-4.174111268483216E-3,-4.1950461557362928E-3,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Energy Rate - fixed portion ($/MWh)","----",{"$f":"F14-E14","v":0.24625527803112846},0.24746904331392727,0.2486918045408828,0.24992365083124923,0.25116467241072371,0.25241496062771773,0.25367460797045283,0.25494370808377198,0.25622235578678954,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Total Energy Rate ($/MWh)","----",{"$f":"F15-E15","v":0.24222341963118765},{"$f":"G15-F15","v":0.24341731232567554},0.24462005367669803,0.24583173134425351,{"$f":"J15-I15","v":0.24705243407689181},0.24828225172734619,0.24952127526961476,0.25076959681527455,0.25202730963104614,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Customer ($/Month)","----",{"$f":"F16-E16","v":0},{"$f":"G16-F16","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Minimum bill ($)","----",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Energy Rate - variable portion (%)","----",{"$f":"F13/E13-1","v":-1.0316743591809452E-4},{"$f":"G13/F13-1","v":-1.0368663398996336E-4},{"$f":"H13/G13-1","v":-1.0420976179825736E-4},-1.0473685910672437E-4,-1.0526796618326451E-4,-1.0580312380792378E-4,-1.0634237327933338E-4,-1.0688575642570086E-4,-1.0743331560969516E-4,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Energy Rate - fixed portion (%)","----",{"$f":"F14/E14-1","v":2.1798229575005212E-3},2.1858024037508805E-3,{"$f":"H14/G14-1","v":2.1918117334354115E-3},2.1978511688693914E-3,2.2039209345776634E-3,2.2100212573190614E-3,2.2161523661174964E-3,2.2223144922877136E-3,2.2285078694657123E-3,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Total Energy Rate (%)","----",1.593040220947417E-3,1.5983459123185551E-3,{"$f":"H15/G15-1","v":1.6036802115186877E-3},1.6090433373272539E-3,1.6144355107208241E-3,1.6198569548955266E-3,1.6253078952992439E-3,1.6307885596558158E-3,1.6362991779970137E-3,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Ref_Sheet","index":3,"n_rows":72,"n_cols":7,"rows_kept":72,"cut":false,"hidden":false,"merged":[[8,3,8,4],[61,1,61,16]]}
[]
[null,"Table 1: RMP Residential Tariff"]
[null,"https://www.rockymountainpower.net/content/dam/rocky_mountain_power/doc/About_Us/Rates_and_Regulation/Utah/Approved_Tariffs/Rate_Schedules/Residential_Service.pdf"]
[]
[null,"Customer Charge"]
[null,"Single Phase",6,"per customer month"]
[null,"Three phase",12,"per customer month"]
[]
[null,"Energy Charge","cents per kwh","usage block"]
[null,"Summer Block 1",8.8498000000000001,400,"kWh",5,"moths of the year"]
[null,"Summer Block 2",11.542899999999999,600,"kWh",5,"moths of the year"]
[null,"Summer Block 3",14.450799999999999,null,"all remaining kWh",5,"moths of the year"]
[null,"Winter Block 1",8.8498000000000001,400,null,7,"months of the year"]
[null,"Winter Block 2",10.3111,600,"all remaining kWh",7,"months of the year"]
[]
[null,"Summer Average",{"$f":"AVERAGE(C10:C11)","v":10.196349999999999},"Synapse Calculation"]
[null,"Winter Average",{"$f":"AVERAGE(C13:C14)","v":9.580449999999999},"Synapse Calculation"]
[null,"Annual Weighted Average",{"$f":"((F10/12)*C16)+((F13/12)*C17)","v":9.8370749999999987},"Synapse Calculation"]
[]
[]
[null,"Minimum Bill"]
[null,"Single Phase",8,"per customer month"]
[null,"Three phase",16,"per customer month"]
[]
[null,"Table 2: Utah Solar Generation Profile"]
[null,"Available online at: www.pvwatts.nrel.gov"]
[null,"PVWatts: Monthly PV Performance Data"]
[null,"Requested Location:","Salt Lake City Utah"]
[null,"Location:","SALT LAKE CITY, UT"]
[null,"Lat (deg N):",40.770000000000003]
[null,"Long (deg W):",111.97]
[null,"Elev (m):",1288]
[null,"DC System Size (kW):",5]
[null,"Module Type:","Standard"]
[null,"Array Type:","Fixed (roof mount)"]
[null,"Array Tilt (deg):",20]
[null,"Array Azimuth (deg):",180]
[null,"System Losses:",14]
[null,"Invert Efficiency:",96]
[null,"DC to AC Size Ratio:",1.1000000000000001]
[null,"Average Cost of Electricity Purchased from Utility ($/kWh):",0.1]
[null,"Initial Cost",3.3]
[null,"Cost of Electricity Generated by System ($/kWh):",0.18]
[]
[null,"Month","AC System Output(kWh)","Solar Radiation (kWh/m^2/day)","Plane of Array Irradiance (W/m^2)","DC array Output (kWh)","Value ($)"]
[null,1,362.88900756999999,2.7561247299999998,85.43986511,381.10253906000003,37.409999999999997]
[null,2,455.84741210999999,3.8986763999999998,109.16294098,477.06222534,47]
[null,3,608.90191649999997,4.8356285100000003,149.90447997999999,636.76892090000001,62.78]
[null,4,678.09814453000001,5.71737099,171.52113342000001,708.86291503999996,69.91]
[null,5,836.84759521000001,7.0186486199999996,217.57810974,873.92333984000004,86.28]
[null,6,802.84851074000005,7.2568922000000002,217.70677185,838.45196533000001,82.77]
[null,7,840.49237060999997,7.5519909900000002,234.11172485,877.55590819999998,86.65]
[null,8,812.57263183999999,7.2176737800000001,223.74789429,848.54351807,83.78]
[null,9,698.03472899999997,6.16007996,184.80239868000001,728.77423095999995,71.97]
[null,10,594.20837401999995,4.9351658799999996,152.99014281999999,620.87731933999999,61.26]
[null,11,401.70367432,3.3142130399999998,99.426391600000002,421.01046753000003,41.42]
[null,12,298.84793091,2.268929,70.336799619999994,314.51629638999998,30.81]
[null,"Total",7391.2922973599998,62.931394099999999,1916.7286529400001,7727.449646,762.04]
[]
[null,"Table 3: Avoided Costs in Utah"]
[null,"Value of Solar in Utah Clean Power Research 2014. "]
[null,"Available online: http://www.psc.utah.gov/utilities/electric/13docs/13035184/255147Exhibit%20A%20to%20Wright%20Testimony%20-%20UCE%202_1%20DT%20-%20Value%20of%20Solar%20in%20Utah%205-22-2014.pdf"]
[null,"Fuel Value",4.2999999999999997E-2,"($/kWh)",null,{"$f":"C63*Ref_Sheet!$C$71","v":43},"$/MWh"]
[null,"Plant O&M Value",1.2999999999999999E-2,"($/kWh)",null,{"$f":"C64*Ref_Sheet!$C$71","v":13},"$/MWh"]
[null,"Generation Capacity Value",1.4E-2,"($/kWh)",null,{"$f":"C65*Ref_Sheet!$C$71","v":14},"$/MWh"]
[null,"Avoided T&D Capacity Cost",1.0999999999999999E-2,"($/kWh)",null,{"$f":"C66*Ref_Sheet!$C$71","v":11},"$/MWh"]
[null,"Avoided Environmental Cost",8.9999999999999993E-3,"($/kWh)",null,{"$f":"C67*Ref_Sheet!$C$71","v":9},"$/MWh"]
[null,"Fuel Price Guarantee Value",2.5999999999999999E-2,"($/kWh)",null,{"$f":"C68*Ref_Sheet!$C$71","v":26},"$/MWh"]
[]
[null,"Table 4: Conversion factors"]
[null,"kWh per MWh",1000]
[null,"cents per dollar",100]