{"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":"95454/D13/10","v":1.2691427097487881E-2},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":1.2691427097487881E-2},{"$f":"MIN(E27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":2.5382854194975761E-2},{"$f":"MIN(F27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":3.8074281292463638E-2},{"$f":"MIN(G27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":5.0765708389951522E-2},{"$f":"MIN(H27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":6.3457135487439406E-2},{"$f":"MIN(I27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":7.614856258492729E-2},{"$f":"MIN(J27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":8.8839989682415174E-2},{"$f":"MIN(K27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.10153141677990306},{"$f":"MIN(L27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.11422284387739094},{"$f":"MIN(M27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.12691427097487881},{"$f":"MIN(N27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.12691427097487881},{"$f":"MIN(O27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.12691427097487881},{"$f":"MIN(P27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.12691427097487881},{"$f":"MIN(Q27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.12691427097487881},{"$f":"MIN(R27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.12691427097487881},{"$f":"MIN(S27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.12691427097487881},{"$f":"MIN(T27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.12691427097487881},{"$f":"MIN(U27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.12691427097487881},{"$f":"MIN(V27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.12691427097487881},{"$f":"MIN(W27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.12691427097487881}]
[null,"Customers x % with DGPV * typical DGPV gen",null,"Annual Customer PV Gen (MWh)",{"$f":"E4*E27*Inputs!$D$25","v":71998.36615899131},{"$f":"F4*F27*Inputs!$D$25","v":143996.73231798262},{"$f":"G4*G27*Inputs!$D$25","v":215995.09847697394},{"$f":"H4*H27*Inputs!$D$25","v":287993.46463596524},{"$f":"I4*I27*Inputs!$D$25","v":359991.83079495659},{"$f":"J4*J27*Inputs!$D$25","v":431990.19695394795},{"$f":"K4*K27*Inputs!$D$25","v":503988.56311293924},{"$f":"L4*L27*Inputs!$D$25","v":575986.9292719306},{"$f":"M4*M27*Inputs!$D$25","v":647985.29543092195},{"$f":"N4*N27*Inputs!$D$25","v":719983.66158991319},{"$f":"O4*O27*Inputs!$D$25","v":719983.66158991319},{"$f":"P4*P27*Inputs!$D$25","v":719983.66158991319},{"$f":"Q4*Q27*Inputs!$D$25","v":719983.66158991319},{"$f":"R4*R27*Inputs!$D$25","v":719983.66158991319},{"$f":"S4*S27*Inputs!$D$25","v":719983.66158991319},{"$f":"T4*T27*Inputs!$D$25","v":719983.66158991319},{"$f":"U4*U27*Inputs!$D$25","v":719983.66158991319},{"$f":"V4*V27*Inputs!$D$25","v":719983.66158991319},{"$f":"W4*W27*Inputs!$D$25","v":719983.66158991319},{"$f":"X4*X27*Inputs!$D$25","v":719983.66158991319}]
[null,"Net Sales = Demand - customer generation ",null,"Net annual residential sales [after PV] (MWh)",{"$f":"E6-E28","v":6228001.6338410089},6156003.2676820178,6084004.9015230257,6012006.5353640346,5940008.1692050435,5868009.8030460523,5796011.4368870612,5724013.0707280692,5652014.7045690781,5580016.3384100869,5580016.3384100869,5580016.3384100869,5580016.3384100869,5580016.3384100869,5580016.3384100869,5580016.3384100869,5580016.3384100869,5580016.3384100869,5580016.3384100869,5580016.3384100869]
[null,null,null,"Installed DG PV (MW)",{"$f":"E27*E4*Inputs!$D$23","v":40.4915868},{"$f":"F27*F4*Inputs!$D$23","v":80.983173600000001},{"$f":"G27*G4*Inputs!$D$23","v":121.47476039999999},{"$f":"H27*H4*Inputs!$D$23","v":161.9663472},{"$f":"I27*I4*Inputs!$D$23","v":202.45793399999999},{"$f":"J27*J4*Inputs!$D$23","v":242.94952080000002},{"$f":"K27*K4*Inputs!$D$23","v":283.44110760000001},{"$f":"L27*L4*Inputs!$D$23","v":323.93269440000006},{"$f":"M27*M4*Inputs!$D$23","v":364.42428120000005},{"$f":"N27*N4*Inputs!$D$23","v":404.91586799999999},{"$f":"O27*O4*Inputs!$D$23","v":404.91586799999999},{"$f":"P27*P4*Inputs!$D$23","v":404.91586799999999},{"$f":"Q27*Q4*Inputs!$D$23","v":404.91586799999999},{"$f":"R27*R4*Inputs!$D$23","v":404.91586799999999},{"$f":"S27*S4*Inputs!$D$23","v":404.91586799999999},{"$f":"T27*T4*Inputs!$D$23","v":404.91586799999999},{"$f":"U27*U4*Inputs!$D$23","v":404.91586799999999},{"$f":"V27*V4*Inputs!$D$23","v":404.91586799999999},{"$f":"W27*W4*Inputs!$D$23","v":404.91586799999999},{"$f":"X27*X4*Inputs!$D$23","v":404.91586799999999}]
[null,null,"Rates"]
[null,"New variable costs / net sales",null,"Energy Rate - variable portion ($/MWh)",{"$f":"E40/E29","v":39.065825935822474},{"$f":"F40/F29","v":39.046470321006161},39.026656595893975,39.00636830182475,38.985588182160832,38.964298133333671,38.942479152240686,38.920111279672263,38.89717353941468,38.873643872638688,38.873643872638688,38.873643872638688,38.873643872638688,38.873643872638688,38.873643872638688,38.873643872638688,38.873643872638688,38.873643872638688,38.873643872638688,38.873643872638688]
[null,"New fixed costs / net sales",null,"Energy Rate - fixed portion ($/MWh)",{"$f":"E41/E29","v":113.88042989024882},115.06261979754018,116.27278987355012,117.51194536989674,118.78114027649752,120.08148031157614,121.41412613452155,122.78029680122087,124.18127348348739,125.61840347643714,125.61840347643714,125.61840347643714,125.61840347643714,125.61840347643714,125.61840347643714,125.61840347643714,125.61840347643714,125.61840347643714,125.61840347643714,125.61840347643714]
[null,"Sum of above",null,"Total Energy Rate ($/kWh)",{"$f":"E33+E32","v":152.94625582607131},{"$f":"F33+F32","v":154.10909011854633},155.29944646944409,156.5183136717215,157.76672845865835,159.04577844490981,160.35660528676223,161.70040808089314,163.07844702290208,164.49204734907582,164.49204734907582,164.49204734907582,164.49204734907582,164.49204734907582,164.49204734907582,164.49204734907582,164.49204734907582,164.49204734907582,164.49204734907582,164.49204734907582]
[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":2931828.868087973},{"$f":"(Inputs!$D$36)*F$28","v":5863657.736175946},{"$f":"(Inputs!$D$36)*G$28","v":8795486.6042639203},{"$f":"(Inputs!$D$36)*H$28","v":11727315.472351892},{"$f":"(Inputs!$D$36)*I$28","v":14659144.340439867},{"$f":"(Inputs!$D$36)*J$28","v":17590973.208527841},{"$f":"(Inputs!$D$36)*K$28","v":20522802.076615814},{"$f":"(Inputs!$D$36)*L$28","v":23454630.944703788},{"$f":"(Inputs!$D$36)*M$28","v":26386459.812791765},{"$f":"(Inputs!$D$36)*N$28","v":29318288.680879734},{"$f":"(Inputs!$D$36)*O$28","v":29318288.680879734},{"$f":"(Inputs!$D$36)*P$28","v":29318288.680879734},{"$f":"(Inputs!$D$36)*Q$28","v":29318288.680879734},{"$f":"(Inputs!$D$36)*R$28","v":29318288.680879734},{"$f":"(Inputs!$D$36)*S$28","v":29318288.680879734},{"$f":"(Inputs!$D$36)*T$28","v":29318288.680879734},{"$f":"(Inputs!$D$36)*U$28","v":29318288.680879734},{"$f":"(Inputs!$D$36)*V$28","v":29318288.680879734},{"$f":"(Inputs!$D$36)*W$28","v":29318288.680879734},{"$f":"(Inputs!$D$36)*X$28","v":29318288.680879734}]
[null,"Costs avoided",null,"Avoided costs - fixed",{"$f":"(Inputs!$D$37)*E$28","v":921639.95727514802},{"$f":"(Inputs!$D$37)*F$28","v":1843279.914550296},{"$f":"(Inputs!$D$37)*G$28","v":2764919.871825444},{"$f":"(Inputs!$D$37)*H$28","v":3686559.8291005921},{"$f":"(Inputs!$D$37)*I$28","v":4608199.7863757405},{"$f":"(Inputs!$D$37)*J$28","v":5529839.743650889},{"$f":"(Inputs!$D$37)*K$28","v":6451479.7009260366},{"$f":"(Inputs!$D$37)*L$28","v":7373119.6582011851},{"$f":"(Inputs!$D$37)*M$28","v":8294759.6154763335},{"$f":"(Inputs!$D$37)*N$28","v":9216399.5727514811},{"$f":"(Inputs!$D$37)*O$28","v":9216399.5727514811},{"$f":"(Inputs!$D$37)*P$28","v":9216399.5727514811},{"$f":"(Inputs!$D$37)*Q$28","v":9216399.5727514811},{"$f":"(Inputs!$D$37)*R$28","v":9216399.5727514811},{"$f":"(Inputs!$D$37)*S$28","v":9216399.5727514811},{"$f":"(Inputs!$D$37)*T$28","v":9216399.5727514811},{"$f":"(Inputs!$D$37)*U$28","v":9216399.5727514811},{"$f":"(Inputs!$D$37)*V$28","v":9216399.5727514811},{"$f":"(Inputs!$D$37)*W$28","v":9216399.5727514811},{"$f":"(Inputs!$D$37)*X$28","v":9216399.5727514811}]
[null,"No DG PV less avoided fixed costs",null,"Variable Revenues and Costs",{"$f":"E18-E38","v":243302027.75565082},240370198.88756284,237438370.01947486,234506541.15138692,231574712.28329894,228642883.41521096,225711054.54712299,222779225.67903501,219847396.81094703,216915567.94285905,216915567.94285905,216915567.94285905,216915567.94285905,216915567.94285905,216915567.94285905,216915567.94285905,216915567.94285905,216915567.94285905,216915567.94285905,216915567.94285905]
[null,"No DG PV less avoided fixed costs",null,"Fixed Revenues and Costs",{"$f":"E19-E39","v":709247503.41898608},708325863.46171093,707404223.50443578,706482583.54716063,705560943.58988547,704639303.63261032,703717663.67533517,702796023.71806002,701874383.76078486,700952743.80350971,700952743.80350971,700952743.80350971,700952743.80350971,700952743.80350971,700952743.80350971,700952743.80350971,700952743.80350971,700952743.80350971,700952743.80350971,700952743.80350971]
[null,"Sum of fixed and variable",null,"Total Energy Rate Revenues and Costs",{"$f":"E40+E41","v":952549531.17463684},{"$f":"F40+F41","v":948696062.3492738},944842593.52391064,940989124.6985476,937135655.87318444,933282187.04782128,929428718.22245812,925575249.39709496,921721780.57173193,917868311.74636877,917868311.74636877,917868311.74636877,917868311.74636877,917868311.74636877,917868311.74636877,917868311.74636877,917868311.74636877,917868311.74636877,917868311.74636877,917868311.74636877]
[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":1006701739.1746368},{"$f":"F42+F43","v":1002848270.3492738},998994801.52391064,995141332.6985476,991287863.87318444,987434395.04782128,983580926.22245812,979727457.39709496,975873988.57173193,972020519.74636877,972020519.74636877,972020519.74636877,972020519.74636877,972020519.74636877,972020519.74636877,972020519.74636877,972020519.74636877,972020519.74636877,972020519.74636877,972020519.74636877]
[null,null,null,"Percent of total costs that are \"fixed\"",{"$f":"(E41+E43)/E44","v":0.75831766422185143},{"$f":"(F41+F43)/F44","v":0.76031249592339001},0.76232271713799116,0.76434850664330245,0.76639004599684646,0.76844751959026314,0.77052111470482754,0.77261102156827688,0.77471743341298505,0.77684054653552037,0.77684054653552037,0.77684054653552037,0.77684054653552037,0.77684054653552037,0.77684054653552037,0.77684054653552037,0.77684054653552037,0.77684054653552037,0.77684054653552037,0.77684054653552037]
[]
[null,null,"Differences"]
[null,null,"Rates"]
[null,null,null,"Change in Energy Rate - variable portion ($/MWh)",{"$f":"E32-E12","v":-1.8913210802729452E-2},-3.8268825619041991E-2,-5.8082550731228366E-2,-7.8370844800453199E-2,-9.9150964464371327E-2,-0.12044101329153278,-0.14225999438451709,-0.16462786695294085,-0.18756560721052296,-0.21109527398651551,-0.21109527398651551,-0.21109527398651551,-0.21109527398651551,-0.21109527398651551,-0.21109527398651551,-0.21109527398651551,-0.21109527398651551,-0.21109527398651551,-0.21109527398651551,-0.21109527398651551]
[null,null,null,"Change in Energy Rate - fixed portion ($/MWh)",{"$f":"E33-E13","v":1.155169036874014},2.3373589441653735,3.5475290201753182,4.7866845165219303,6.0558794231227182,7.3562194582013376,8.6888652811467466,10.055035947846065,11.456012630112582,12.893142623062332,12.893142623062332,12.893142623062332,12.893142623062332,12.893142623062332,12.893142623062332,12.893142623062332,12.893142623062332,12.893142623062332,12.893142623062332,12.893142623062332]
[null,null,null,"Change in Total Energy Rate ($/MWh)",{"$f":"E34-E14","v":1.1362558260713058},2.2990901185463315,3.4894464694440899,4.7083136717214984,5.9567284586583469,7.2357784449098119,8.5466052867622295,9.8904080808931383,11.26844702290208,12.682047349075816,12.682047349075816,12.682047349075816,12.682047349075816,12.682047349075816,12.682047349075816,12.682047349075816,12.682047349075816,12.682047349075816,12.682047349075816,12.682047349075816,"`"]
[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":-4.8390270002252045E-4},-9.7912449857928685E-4,-1.4860672477136072E-3,-2.0051520494085429E-3,-2.5368204222218083E-3,-3.0815355538053035E-3,-3.6397836467791933E-3,-4.2120753661766264E-3,-4.7989473975219576E-3,-5.4009641255272633E-3,-5.4009641255272633E-3,-5.4009641255272633E-3,-5.4009641255272633E-3,-5.4009641255272633E-3,-5.4009641255272633E-3,-5.4009641255272633E-3,-5.4009641255272633E-3,-5.4009641255272633E-3,-5.4009641255272633E-3,-5.4009641255272633E-3]
[null,null,null,"Change in Energy Rate - fixed portion (%)",{"$f":"E33/E13-1","v":1.0247650155155386E-2},2.0735005858231181E-2,3.1470577165394253E-2,4.2463281790477536E-2,5.3722469810912887E-2,6.5257950192457725E-2,7.708001929087227E-2,8.9199491504614592E-2,0.10162773227035382,0.11437669361291469,0.11437669361291469,0.11437669361291469,0.11437669361291469,0.11437669361291469,0.11437669361291469,0.11437669361291469,0.11437669361291469,0.11437669361291469,0.11437669361291469,0.11437669361291469]
[null,null,null,"Change in Total Energy Rate (%)",{"$f":"E34/E14-1","v":7.4847231807608772E-3},1.5144523539597721E-2,2.2985616688255606E-2,3.101451598525462E-2,3.9238050580715056E-2,4.7663384789604191E-2,5.629803890891405E-2,6.514991160590955E-2,7.4227304017535634E-2,8.3538945715537993E-2,8.3538945715537993E-2,8.3538945715537993E-2,8.3538945715537993E-2,8.3538945715537993E-2,8.3538945715537993E-2,8.3538945715537993E-2,8.3538945715537993E-2,8.3538945715537993E-2,8.3538945715537993E-2,8.3538945715537993E-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":-6.1166171831160909E-2},{"$f":"(F42/F10-F14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.12233234366232182},{"$f":"(G42/G10-G14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.18349851549348273},{"$f":"(H42/H10-H14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.24466468732464081},{"$f":"(I42/I10-I14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.30583085915580172},{"$f":"(J42/J10-J14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.36699703098696262},{"$f":"(K42/K10-K14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.42816320281812636},{"$f":"(L42/L10-L14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.48932937464928727},{"$f":"(M42/M10-M14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.55049554648044541},{"$f":"(N42/N10-N14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.61166171831160632},{"$f":"(O42/O10-O14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.61166171831160632},{"$f":"(P42/P10-P14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.61166171831160632},{"$f":"(Q42/Q10-Q14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.61166171831160632},{"$f":"(R42/R10-R14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.61166171831160632},{"$f":"(S42/S10-S14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.61166171831160632},{"$f":"(T42/T10-T14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.61166171831160632},{"$f":"(U42/U10-U14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.61166171831160632},{"$f":"(V42/V10-V14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.61166171831160632},{"$f":"(W42/W10-W14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.61166171831160632},{"$f":"(X42/X10-X14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.61166171831160632}]
[null,"Recovery of Lost Revenues",null,"Energy rate impact due to lost revenues (¢/kWh)",{"$f":"E61-E59","v":0.17479175443829148},{"$f":"F61-F59","v":0.35224135551695496},{"$f":"G61-G59","v":0.53244316243789169},0.71549605449679066,0.90150370502163635,1.0905748754779439,1.2828237314943494,1.4783701827386011,1.6773402487706535,1.8798664532191878,1.8798664532191878,1.8798664532191878,1.8798664532191878,1.8798664532191878,1.8798664532191878,1.8798664532191878,1.8798664532191878,1.8798664532191878,1.8798664532191878,1.8798664532191878]
[null,"Net Effect",null,"Energy rate impact of both  (¢/kWh)",{"$f":"E51/10","v":0.11362558260713058},{"$f":"F51/10","v":0.22990901185463314},{"$f":"G51/10","v":0.34894464694440896},0.47083136717214985,0.59567284586583469,0.72357784449098117,0.854660528676223,0.98904080808931383,1.1268447022902079,1.2682047349075816,1.2682047349075816,1.2682047349075816,1.2682047349075816,1.2682047349075816,1.2682047349075816,1.2682047349075816,1.2682047349075816,1.2682047349075816,1.2682047349075816,1.2682047349075816]
[]
[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":-0.11187761522438536},{"$f":"AVERAGE(E49:X49)","v":-0.16148644460545042}]
[null,null,null,"Change in Energy Rate - fixed portion ($/MWh)",{"$f":"AVERAGE(E50:N50)","v":6.8331896881228413},{"$f":"AVERAGE(E50:X50)","v":9.8631661555925838},null,null,null,null,null,null,null,null,null,null,null,null,"testimony calc"]
[null,null,null,"Change in Total Energy Rate ($/MWh)",{"$f":"AVERAGE(E51:N51)","v":6.7213120728984652},{"$f":"AVERAGE(E51:X51)","v":9.7016797109871398}]
[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":-2.8624373007756108E-3},{"$f":"AVERAGE(E55:X55)","v":-4.1317007131514375E-3}]
[null,null,null,"Change in Energy Rate - fixed portion (%)",{"$f":"AVERAGE(E56:N56)","v":6.0618087165138432E-2},{"$f":"AVERAGE(E56:X56)","v":8.7497390389026569E-2}]
[null,null,null,"Total Energy Rate (%)"]
[]
[null,null,null,"Energy Rate impact due to AC  (¢/kWh)",{"$f":"AVERAGE(E59:N59)","v":-0.33641394507138356},{"$f":"AVERAGE(E59:X59)","v":-0.47403783169149494}]
[null,null,null,"Energy rate impact due to lost revenues  (¢/kWh)",{"$f":"AVERAGE(E60:N60)","v":1.0085451523612301},{"$f":"AVERAGE(E60:X60)","v":1.4442058027902085}]
[null,null,null,"Energy rate impact of both  (¢/kWh)",{"$f":"AVERAGE(E61:N61)","v":0.67213120728984643},{"$f":"AVERAGE(E61:X61)","v":0.97016797109871378}]
[]
[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":1353.1374495146338},{"$f":"F79+F84","v":1362.877802762403},1372.8486914982275,1383.0583982372959,1393.5156070616258,1404.2294282554665,1415.2094247768318,1426.4656407268405,1438.0086319949944,1449.8494992769417,1449.8494992769417,1449.8494992769417,1449.8494992769417,1449.8494992769417,1449.8494992769417,1449.8494992769417,1449.8494992769417,1449.8494992769417,1449.8494992769417,1449.8494992769417]
[null,null,null,"Annual Impact to Avg non-NM customer"]
[null,null,null,"impact due to AC ",{"$f":"E59*10*$E$5","v":-5.1235169473818294},-10.247033894763659,-15.370550842145489,-20.49406778952708,-25.61758473690891,-30.74110168429074,-35.864618631672805,-40.988135579054635,-46.111652526436238,-51.235169473818068,-51.235169473818068,-51.235169473818068,-51.235169473818068,-51.235169473818068,-51.235169473818068,-51.235169473818068,-51.235169473818068,-51.235169473818068,-51.235169473818068,-51.235169473818068]
[null,null,null,"impact due to lost revenues ",{"$f":"E60*10*$E$5","v":14.641238601611411},29.505108796762411,44.599514479968704,59.932738166418673,75.513463938130513,91.350802079352945,107.45431554810044,123.83404844549081,140.50055666102634,157.46494089035551,157.46494089035551,157.46494089035551,157.46494089035551,157.46494089035551,157.46494089035551,157.46494089035551,157.46494089035551,157.46494089035551,157.46494089035551,157.46494089035551]
[null,null,null,"impact of both ",{"$f":"E61*10*$E$5","v":9.5177216542295806},19.25807490199875,29.228963637823213,39.438670376891594,49.895879201221604,60.609700395062205,71.589696916427627,82.845912866436166,94.388904134590121,106.22977141653745,106.22977141653745,106.22977141653745,106.22977141653745,106.22977141653745,106.22977141653745,106.22977141653745,106.22977141653745,106.22977141653745,106.22977141653745,106.22977141653745]
[]
[null,null,null,"Hayet customer size sens.",8.2065000000000001,8.2065000000000001,8.2065000000000001,8.2065000000000001,8.2065000000000001,8.2065000000000001,8.2065000000000001,8.2065000000000001,8.2065000000000001,8.2065000000000001,8.2065000000000001,8.2065000000000001,8.2065000000000001,8.2065000000000001,8.2065000000000001,8.2065000000000001,8.2065000000000001,8.2065000000000001,8.2065000000000001,8.2065000000000001]
[null,null,null,"impact to non-NM customer",{"$f":"E61*10*$E$86","v":9.3246834366541709},{"$f":"F61*10*$E$86","v":18.867483057850471},28.636142451492923,38.63877614698248,48.883892095979725,59.380415808152371,70.137716285814236,81.16563391584954,92.474510493445919,104.07522157019069,104.07522157019069,104.07522157019069,104.07522157019069,104.07522157019069,104.07522157019069,104.07522157019069,104.07522157019069,104.07522157019069,104.07522157019069,104.07522157019069]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"variable",{"$f":"N49*$E$86","v":-1.7323533659703396},656660.73326827388,{"$f":"N89*O89","v":-1137568.4315778457}]
[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":-13.55450925352228},{"$f":"O89","v":656660.73326827388},-8900713.9855095446]
[null,null,null,null,null,null,null,null,null,null,null,null,"fixed shift",{"$f":"N93-N91","v":119.36208418968332},{"$f":"O91","v":656660.73326827388},78380393.728426889,"testimony calc",{"$f":"ROUND(P92/1000000,1)","v":78.400000000000006}]
[null,null,null,null,null,null,null,null,null,null,null,null,"fixed cost",{"$f":"N50*$E$86","v":105.80757493616103},{"$f":"O91","v":656660.73326827388},69479679.742917344]
[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":104.07522157019069},{"$f":"O93","v":656660.73326827388},68342111.311339498]

{"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.065825935822474},{"$f":"Rate_Impacts_With_v_Without!F32","v":39.046470321006161},{"$f":"Rate_Impacts_With_v_Without!G32","v":39.026656595893975},{"$f":"Rate_Impacts_With_v_Without!H32","v":39.00636830182475},{"$f":"Rate_Impacts_With_v_Without!I32","v":38.985588182160832},{"$f":"Rate_Impacts_With_v_Without!J32","v":38.964298133333671},{"$f":"Rate_Impacts_With_v_Without!K32","v":38.942479152240686},{"$f":"Rate_Impacts_With_v_Without!L32","v":38.920111279672263},{"$f":"Rate_Impacts_With_v_Without!M32","v":38.89717353941468},{"$f":"Rate_Impacts_With_v_Without!N32","v":38.873643872638688},{"$f":"Rate_Impacts_With_v_Without!O32","v":38.873643872638688},{"$f":"Rate_Impacts_With_v_Without!P32","v":38.873643872638688},{"$f":"Rate_Impacts_With_v_Without!Q32","v":38.873643872638688},{"$f":"Rate_Impacts_With_v_Without!R32","v":38.873643872638688},{"$f":"Rate_Impacts_With_v_Without!S32","v":38.873643872638688},{"$f":"Rate_Impacts_With_v_Without!T32","v":38.873643872638688},{"$f":"Rate_Impacts_With_v_Without!U32","v":38.873643872638688},{"$f":"Rate_Impacts_With_v_Without!V32","v":38.873643872638688},{"$f":"Rate_Impacts_With_v_Without!W32","v":38.873643872638688},{"$f":"Rate_Impacts_With_v_Without!X32","v":38.873643872638688}]
[null,"New fixed costs / net sales",null,"Energy Rate - fixed portion ($/MWh)",{"$f":"Rate_Impacts_With_v_Without!E33","v":113.88042989024882},{"$f":"Rate_Impacts_With_v_Without!F33","v":115.06261979754018},{"$f":"Rate_Impacts_With_v_Without!G33","v":116.27278987355012},{"$f":"Rate_Impacts_With_v_Without!H33","v":117.51194536989674},{"$f":"Rate_Impacts_With_v_Without!I33","v":118.78114027649752},{"$f":"Rate_Impacts_With_v_Without!J33","v":120.08148031157614},{"$f":"Rate_Impacts_With_v_Without!K33","v":121.41412613452155},{"$f":"Rate_Impacts_With_v_Without!L33","v":122.78029680122087},{"$f":"Rate_Impacts_With_v_Without!M33","v":124.18127348348739},{"$f":"Rate_Impacts_With_v_Without!N33","v":125.61840347643714},{"$f":"Rate_Impacts_With_v_Without!O33","v":125.61840347643714},{"$f":"Rate_Impacts_With_v_Without!P33","v":125.61840347643714},{"$f":"Rate_Impacts_With_v_Without!Q33","v":125.61840347643714},{"$f":"Rate_Impacts_With_v_Without!R33","v":125.61840347643714},{"$f":"Rate_Impacts_With_v_Without!S33","v":125.61840347643714},{"$f":"Rate_Impacts_With_v_Without!T33","v":125.61840347643714},{"$f":"Rate_Impacts_With_v_Without!U33","v":125.61840347643714},{"$f":"Rate_Impacts_With_v_Without!V33","v":125.61840347643714},{"$f":"Rate_Impacts_With_v_Without!W33","v":125.61840347643714},{"$f":"Rate_Impacts_With_v_Without!X33","v":125.61840347643714}]
[null,"Sum of above",null,"Total Energy Rate ($/MWh)",{"$f":"Rate_Impacts_With_v_Without!E34","v":152.94625582607131},{"$f":"Rate_Impacts_With_v_Without!F34","v":154.10909011854633},{"$f":"Rate_Impacts_With_v_Without!G34","v":155.29944646944409},{"$f":"Rate_Impacts_With_v_Without!H34","v":156.5183136717215},{"$f":"Rate_Impacts_With_v_Without!I34","v":157.76672845865835},{"$f":"Rate_Impacts_With_v_Without!J34","v":159.04577844490981},{"$f":"Rate_Impacts_With_v_Without!K34","v":160.35660528676223},{"$f":"Rate_Impacts_With_v_Without!L34","v":161.70040808089314},{"$f":"Rate_Impacts_With_v_Without!M34","v":163.07844702290208},{"$f":"Rate_Impacts_With_v_Without!N34","v":164.49204734907582},{"$f":"Rate_Impacts_With_v_Without!O34","v":164.49204734907582},{"$f":"Rate_Impacts_With_v_Without!P34","v":164.49204734907582},{"$f":"Rate_Impacts_With_v_Without!Q34","v":164.49204734907582},{"$f":"Rate_Impacts_With_v_Without!R34","v":164.49204734907582},{"$f":"Rate_Impacts_With_v_Without!S34","v":164.49204734907582},{"$f":"Rate_Impacts_With_v_Without!T34","v":164.49204734907582},{"$f":"Rate_Impacts_With_v_Without!U34","v":164.49204734907582},{"$f":"Rate_Impacts_With_v_Without!V34","v":164.49204734907582},{"$f":"Rate_Impacts_With_v_Without!W34","v":164.49204734907582},{"$f":"Rate_Impacts_With_v_Without!X34","v":164.49204734907582}]
[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":-1.9355614816312539E-2},{"$f":"G13-F13","v":-1.9813725112186376E-2},-2.0288294069224833E-2,-2.0780119663918128E-2,{"$f":"J13-I13","v":-2.1290048827161456E-2},-2.1818981092984302E-2,-2.2367872568423763E-2,-2.2937740257582107E-2,-2.3529666775992553E-2,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Energy Rate - fixed portion ($/MWh)","----",{"$f":"F14-E14","v":1.1821899072913595},1.2101700760099448,1.239155496346612,1.2691949066007879,1.3003400350786194,1.332645822945409,1.3661706666993183,1.4009766822665171,1.4371299929497496,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Total Energy Rate ($/MWh)","----",{"$f":"F15-E15","v":1.1628342924750257},{"$f":"G15-F15","v":1.1903563508977584},1.2188672022774085,1.2484147869368485,{"$f":"J15-I15","v":1.279049986251465},1.3108268418524176,1.3438027941309088,1.3780389420089421,1.4136003261737358,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":-4.9546155374036172E-4},{"$f":"G13/F13-1","v":-5.0743959567400854E-4},{"$f":"H13/G13-1","v":-5.1985734466830635E-4},-5.32736590679872E-4,-5.4610049046033282E-4,-5.5997367175253387E-4,-5.7438234687057221E-4,-5.8935443664986931E-4,-6.0491970585341281E-4,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Energy Rate - fixed portion (%)","----",{"$f":"F14/E14-1","v":1.0380975101961676E-2},1.0517491068248841E-2,{"$f":"H14/G14-1","v":1.0657312839007504E-2},1.0800560765168887E-2,1.0947361105068554E-2,1.1097846391363575E-2,1.125215582563821E-2,1.1410435703170574E-2,1.1572839870585216E-2,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Total Energy Rate (%)","----",7.6028947959170257E-3,7.7241151056182122E-3,{"$f":"H15/G15-1","v":7.8484967589194099E-3},7.9761579182053843E-3,8.1072225985001634E-3,8.2418210320902574E-3,8.3800900606982864E-3,8.5221735576546109E-3,8.6682228827896779E-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]