{"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)",6976758,null,"EIA 861, 2013"]
[null,null,"Residential Revenues ($)",758356800,null,"EIA 861, 2013"]
[null,null,"Number of Residential Customers (count)",733917,null,"EIA 861, 2013"]
[null,null,"Sales per customer (MWh)",{"$f":"D11/D13","v":9.5061948421960523},null,"Residential Sales / # of Customers"]
[null,null,"Customer growth rate",0.01,null,"User input"]
[null,null,"Electricity usage per customer growth rate",0,null,"User input"]
[null,"Rate Structure Parameters"]
[null,null,"Energy Rate ($/MWh)",{"$f":"Ref_Sheet!C18/Ref_Sheet!C72*Ref_Sheet!C71","v":98.370749999999987},null,"Annual weighted average, RMP Residential rate tariff "]
[null,null,"Customer ($/Month)",{"$f":"Ref_Sheet!C6","v":6},null,"RMP Residential rate tariff "]
[null,null,"Minimum Bill ($/Month)",{"$f":"Ref_Sheet!C22","v":8},null,"RMP Residential rate tariff "]
[null,null,"Fixed Portion of Energy Rate (%)",0.66659999999999997,null,"RMP Presentation See: MW"]
[null,"PV NEM System Parameters"]
[null,null,"Average PV installed capacity (MW, DC)",5.0000000000000001E-3,null,"User input"]
[null,null,"Unit capacity factor (%)",{"$f":"Ref_Sheet!C58/(8760*Ref_Sheet!C33)","v":0.16875096569315068},null,"NREL PV Watts (SLC, UT)","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.3912922973599997},null,"Calculation based on CF and Capacity"]
[null,null,"Percent of customers adding DG PV per year",5.0000000000000001E-3,null,"User input"]
[null,null,"Number of years with additional DG PV",10,null,"User input"]
[null,"Levelized Avoided Cost Inputs"]
[null,null,"Avoided energy ($/MWh)",60,null,"Avoided fuel, variable O&M, and line losses. "]
[null,null,"Avoided generation capacity capital costs ($/MWh)",null,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":60},null,"Includes avoided energy, avoided environmental, and fuel price guarantee"]
[null,null,"Fixed Avoided Costs ($/MWh)",{"$f":"SUM(D30:D32)","v":0},null,"Includes avoided capital costs associated with generation and T&D capacity"]
[null,null,"Total Avoided Costs ($/MWh)",{"$f":"SUM(D36:D37)","v":60},null,"Sum of variable and fixed avoided costs"]

{"sheet":"Rate_Impacts_With_v_Without","index":1,"n_rows":77,"n_cols":25,"rows_kept":77,"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":733917},{"$f":"E4*(1+Inputs!$D$15)","v":741256.17},{"$f":"F4*(1+Inputs!$D$15)","v":748668.7317},{"$f":"G4*(1+Inputs!$D$15)","v":756155.41901700001},{"$f":"H4*(1+Inputs!$D$15)","v":763716.97320717003},{"$f":"I4*(1+Inputs!$D$15)","v":771354.14293924172},{"$f":"J4*(1+Inputs!$D$15)","v":779067.68436863413},{"$f":"K4*(1+Inputs!$D$15)","v":786858.36121232051},{"$f":"L4*(1+Inputs!$D$15)","v":794726.94482444366},{"$f":"M4*(1+Inputs!$D$15)","v":802674.21427268814},{"$f":"N4*(1+Inputs!$D$15)","v":810700.95641541504},{"$f":"O4*(1+Inputs!$D$15)","v":818807.96597956924},{"$f":"P4*(1+Inputs!$D$15)","v":826996.04563936498},{"$f":"Q4*(1+Inputs!$D$15)","v":835266.00609575864},{"$f":"R4*(1+Inputs!$D$15)","v":843618.66615671618},{"$f":"S4*(1+Inputs!$D$15)","v":852054.85281828337},{"$f":"T4*(1+Inputs!$D$15)","v":860575.40134646615},{"$f":"U4*(1+Inputs!$D$15)","v":869181.15535993082},{"$f":"V4*(1+Inputs!$D$15)","v":877872.96691353014},{"$f":"W4*(1+Inputs!$D$15)","v":886651.69658266543}]
[null,"Typical annual demand x demand grwoth rate",null,"Usage per customer (annual MWh / customer)",{"$f":"Inputs!$D$14","v":9.5061948421960523},{"$f":"E5*(1+Inputs!$D$16)","v":9.5061948421960523},{"$f":"F5*(1+Inputs!$D$16)","v":9.5061948421960523},{"$f":"G5*(1+Inputs!$D$16)","v":9.5061948421960523},{"$f":"H5*(1+Inputs!$D$16)","v":9.5061948421960523},{"$f":"I5*(1+Inputs!$D$16)","v":9.5061948421960523},{"$f":"J5*(1+Inputs!$D$16)","v":9.5061948421960523},{"$f":"K5*(1+Inputs!$D$16)","v":9.5061948421960523},{"$f":"L5*(1+Inputs!$D$16)","v":9.5061948421960523},{"$f":"M5*(1+Inputs!$D$16)","v":9.5061948421960523},{"$f":"N5*(1+Inputs!$D$16)","v":9.5061948421960523},{"$f":"O5*(1+Inputs!$D$16)","v":9.5061948421960523},{"$f":"P5*(1+Inputs!$D$16)","v":9.5061948421960523},{"$f":"Q5*(1+Inputs!$D$16)","v":9.5061948421960523},{"$f":"R5*(1+Inputs!$D$16)","v":9.5061948421960523},{"$f":"S5*(1+Inputs!$D$16)","v":9.5061948421960523},{"$f":"T5*(1+Inputs!$D$16)","v":9.5061948421960523},{"$f":"U5*(1+Inputs!$D$16)","v":9.5061948421960523},{"$f":"V5*(1+Inputs!$D$16)","v":9.5061948421960523},{"$f":"W5*(1+Inputs!$D$16)","v":9.5061948421960523}]
[null,null,null,"Total residential electricity usage (MWh)",{"$f":"E5*E4","v":6976758},{"$f":"F5*F4","v":7046525.5800000001},{"$f":"G5*G4","v":7116990.8358000005},7188160.7441579998,7260042.3515995806,7332642.7751155756,7405969.2028667321,7480028.8948953999,7554829.1838443531,7630377.4756827969,7706681.2504396252,7783748.062944022,7861585.5435734624,7940201.399009197,8019603.4129992891,8099799.4471292822,8180797.4416005742,8262605.4160165796,8345231.4701767461,8428683.7848785128]
[]
[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":6976758},{"$f":"F6","v":7046525.5800000001},7116990.8358000005,7188160.7441579998,7260042.3515995806,7332642.7751155756,7405969.2028667321,7480028.8948953999,7554829.1838443531,7630377.4756827969,7706681.2504396252,7783748.062944022,7861585.5435734624,7940201.399009197,8019603.4129992891,8099799.4471292822,8180797.4416005742,8262605.4160165796,8345231.4701767461,8428683.7848785128]
[null,null,"Rates"]
[null,"Fuel and Purchased Power Charge",null,"Energy Rate - variable portion ($/MWh)",{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":32.796808049999996},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":32.796808049999996},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":32.796808049999996},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":32.796808049999996},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":32.796808049999996},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":32.796808049999996},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":32.796808049999996},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":32.796808049999996},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":32.796808049999996},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":32.796808049999996},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":32.796808049999996},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":32.796808049999996},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":32.796808049999996},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":32.796808049999996},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":32.796808049999996},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":32.796808049999996},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":32.796808049999996},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":32.796808049999996},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":32.796808049999996},{"$f":"Inputs!$D$18*(1-Inputs!$D$21)","v":32.796808049999996}]
[null,"Energy rate times fixed portion",null,"Energy Rate - fixed portion ($/MWh)",{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":65.573941949999991},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":65.573941949999991},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":65.573941949999991},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":65.573941949999991},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":65.573941949999991},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":65.573941949999991},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":65.573941949999991},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":65.573941949999991},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":65.573941949999991},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":65.573941949999991},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":65.573941949999991},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":65.573941949999991},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":65.573941949999991},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":65.573941949999991},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":65.573941949999991},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":65.573941949999991},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":65.573941949999991},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":65.573941949999991},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":65.573941949999991},{"$f":"Inputs!$D$18*(Inputs!$D$21)","v":65.573941949999991}]
[null,"Sum of above",null,"Total Energy Rate ($/MWh)",{"$f":"E12+E13","v":98.370749999999987},{"$f":"F12+F13","v":98.370749999999987},98.370749999999987,98.370749999999987,98.370749999999987,98.370749999999987,98.370749999999987,98.370749999999987,98.370749999999987,98.370749999999987,98.370749999999987,98.370749999999987,98.370749999999987,98.370749999999987,98.370749999999987,98.370749999999987,98.370749999999987,98.370749999999987,98.370749999999987,98.370749999999987]
[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":228815392.93730187},231103546.8666749,233414582.33534166,235748728.15869504,238106215.44028202,240487277.59468481,242892150.37063169,245321071.87433803,247774282.59308138,250252025.41901219,252754545.67320234,255282091.12993437,257834912.04123372,{"$f":"(R12)*R10","v":260413261.16164607},263017393.77326253,265647567.71099517,268304043.38810509,270987083.82198614,273696954.66020602,276433924.20680803]
[null,"Energy sales x energy rate x fixed %",null,"Fixed Revenues and Costs",{"$f":"(E13)*E10","v":457493524.09119803},462068459.33211005,466689143.92543113,471356035.36468542,476069595.71833235,480830291.67551559,485638594.59227079,490494980.53819352,495399930.34357542,500353929.64701122,505357468.94348133,510411043.63291615,515515154.06924534,{"$f":"(R13)*R10","v":520670305.60993779},525877008.6660372,531135778.75269759,536447136.54022449,541811607.90562677,547229723.98468304,552702021.22452986]
[null,"Sum of fixed and variable",null,"Total Energy Rate Revenues and Costs",{"$f":"E18+E19","v":686308917.02849984},{"$f":"F18+F19","v":693172006.19878495},{"$f":"G18+G19","v":700103726.26077282},707104763.52338052,714175811.1586144,721317569.27020037,728530744.96290255,735816052.41253161,743174212.93665683,750605955.06602335,758112014.61668372,765693134.76285052,773350066.11047912,{"$f":"R18+R19","v":781083566.7715838},788894402.4392997,796783346.46369278,804751179.92832959,812798691.72761297,820926678.64488912,829135945.43133783]
[null,"Customers x customer charge",null,"Customer Charge Revenues and Costs",{"$f":"E15*E4*12","v":52842024},{"$f":"F15*F4*12","v":53370444.24000001},53904148.682400003,54443190.169223994,54987622.070916235,55537498.29162541,56092873.274541661,56653802.00728707,57220340.027359948,57792543.427633546,58370468.861909889,58954173.550528988,59543715.286034279,{"$f":"R15*R4*12","v":60139152.438894622},60740543.963283569,61347949.402916402,61961428.896945566,62581043.185915023,63206853.617774174,63838922.153951906]
[null,"Sum of Energy Rate and Customer Charge",null,"Total Revenues and Costs",{"$f":"E20+E21","v":739150941.02849984},{"$f":"F20+F21","v":746542450.43878496},754007874.94317281,761547953.69260454,769163433.22953057,776855067.56182575,784623618.23744416,792469854.41981864,800394552.9640168,808398498.49365687,816482483.47859359,824647308.31337953,832893781.39651334,{"$f":"R20+R21","v":841222719.21047843},849634946.40258324,858131295.86660922,866712608.82527518,875379734.91352797,884133532.26266325,892974867.58528972]
[null,null,null,"Percent of total costs that are \"fixed\"",{"$f":"(E19+E21)/E22","v":0.69043482158202485},{"$f":"(F19+F21)/F22","v":0.69043482158202474},{"$f":"(G19+G21)/G22","v":0.69043482158202474},{"$f":"(H19+H21)/H22","v":0.69043482158202474},{"$f":"(I19+I21)/I22","v":0.69043482158202485},{"$f":"(J19+J21)/J22","v":0.69043482158202485},{"$f":"(K19+K21)/K22","v":0.69043482158202474},{"$f":"(L19+L21)/L22","v":0.69043482158202474},{"$f":"(M19+M21)/M22","v":0.69043482158202463},{"$f":"(N19+N21)/N22","v":0.69043482158202485},{"$f":"(O19+O21)/O22","v":0.69043482158202474},{"$f":"(P19+P21)/P22","v":0.69043482158202474},{"$f":"(Q19+Q21)/Q22","v":0.69043482158202474},{"$f":"(R19+R21)/R22","v":0.69043482158202485},{"$f":"(S19+S21)/S22","v":0.69043482158202474},{"$f":"(T19+T21)/T22","v":0.69043482158202474},{"$f":"(U19+U21)/U22","v":0.69043482158202474},{"$f":"(V19+V21)/V22","v":0.69043482158202474},{"$f":"(W19+W21)/W22","v":0.69043482158202474},{"$f":"(X19+X21)/X22","v":0.69043482158202485}]
[]
[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":5.0000000000000001E-3},{"$f":"MIN(E27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.01},{"$f":"MIN(F27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":1.4999999999999999E-2},{"$f":"MIN(G27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.02},{"$f":"MIN(H27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":2.5000000000000001E-2},{"$f":"MIN(I27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":3.0000000000000002E-2},{"$f":"MIN(J27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":3.5000000000000003E-2},{"$f":"MIN(K27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.04},{"$f":"MIN(L27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":4.4999999999999998E-2},{"$f":"MIN(M27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":4.9999999999999996E-2},{"$f":"MIN(N27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.05},{"$f":"MIN(O27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.05},{"$f":"MIN(P27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.05},{"$f":"MIN(Q27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.05},{"$f":"MIN(R27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.05},{"$f":"MIN(S27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.05},{"$f":"MIN(T27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.05},{"$f":"MIN(U27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.05},{"$f":"MIN(V27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.05},{"$f":"MIN(W27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.05}]
[null,"Customers x % with DGPV * typical DGPV gen",null,"Annual Customer PV Gen (MWh)",{"$f":"E4*E27*Inputs!$D$25","v":27122.975345007795},{"$f":"F4*F27*Inputs!$D$25","v":54788.410196915749},{"$f":"G4*G27*Inputs!$D$25","v":83004.441448327358},{"$f":"H4*H27*Inputs!$D$25","v":111779.3144837475},{"$f":"I4*I27*Inputs!$D$25","v":141121.38453573122},{"$f":"J4*J27*Inputs!$D$25","v":171039.11805730624},{"$f":"K4*K27*Inputs!$D$25","v":201541.09411085921},{"$f":"L4*L27*Inputs!$D$25","v":232636.00577367749},{"$f":"M4*M27*Inputs!$D$25","v":264332.66156034102},{"$f":"N4*N27*Inputs!$D$25","v":296639.9868621605},{"$f":"O4*O27*Inputs!$D$25","v":299606.38673078211},{"$f":"P4*P27*Inputs!$D$25","v":302602.45059808996},{"$f":"Q4*Q27*Inputs!$D$25","v":305628.47510407085},{"$f":"R4*R27*Inputs!$D$25","v":308684.7598551116},{"$f":"S4*S27*Inputs!$D$25","v":311771.60745366267},{"$f":"T4*T27*Inputs!$D$25","v":314889.32352819934},{"$f":"U4*U27*Inputs!$D$25","v":318038.21676348132},{"$f":"V4*V27*Inputs!$D$25","v":321218.59893111611},{"$f":"W4*W27*Inputs!$D$25","v":324430.78492042731},{"$f":"X4*X27*Inputs!$D$25","v":327675.09276963153}]
[null,"Net Sales = Demand - customer generation ",null,"Net annual residential sales [after PV] (MWh)",{"$f":"E6-E28","v":6949635.0246549919},6991737.1698030839,7033986.3943516733,7076381.4296742519,7118920.9670638498,7161603.6570582697,7204428.1087558726,7247392.8891217224,7290496.5222840123,7333737.4888206366,7407074.8637088435,7481145.6123459321,7555957.0684693912,7631516.6391540859,7707831.8055456262,7784910.1236010827,7862759.2248370927,7941386.8170854636,8020800.6852563191,8101008.6921088817]
[null,null,null,"Installed DG PV (MW)",{"$f":"E27*E4*Inputs!$D$23","v":18.347925},{"$f":"F27*F4*Inputs!$D$23","v":37.062808500000003},{"$f":"G27*G4*Inputs!$D$23","v":56.1501548775},{"$f":"H27*H4*Inputs!$D$23","v":75.615541901699999},{"$f":"I27*I4*Inputs!$D$23","v":95.464621650896262},{"$f":"J27*J4*Inputs!$D$23","v":115.70312144088626},{"$f":"K27*K4*Inputs!$D$23","v":136.336844764511},{"$f":"L27*L4*Inputs!$D$23","v":157.37167224246411},{"$f":"M27*M4*Inputs!$D$23","v":178.81356258549982},{"$f":"N27*N4*Inputs!$D$23","v":200.66855356817203},{"$f":"O27*O4*Inputs!$D$23","v":202.67523910385378},{"$f":"P27*P4*Inputs!$D$23","v":204.70199149489233},{"$f":"Q27*Q4*Inputs!$D$23","v":206.74901140984127},{"$f":"R27*R4*Inputs!$D$23","v":208.81650152393968},{"$f":"S27*S4*Inputs!$D$23","v":210.90466653917906},{"$f":"T27*T4*Inputs!$D$23","v":213.01371320457085},{"$f":"U27*U4*Inputs!$D$23","v":215.14385033661657},{"$f":"V27*V4*Inputs!$D$23","v":217.29528883998273},{"$f":"W27*W4*Inputs!$D$23","v":219.46824172838257},{"$f":"X27*X4*Inputs!$D$23","v":221.66292414566638}]
[null,null,"Rates"]
[null,"New variable costs / net sales",null,"Energy Rate - variable portion ($/MWh)",{"$f":"E40/E29","v":32.6906396682148},{"$f":"F40/F29","v":32.583639333409927},32.475797228137367,32.367103379871615,32.257547657935461,32.147119770352468,32.03580926062385,31.923605504427837,31.810497706239264,31.696474895867073,31.696474895867077,31.696474895867077,31.69647489586708,31.696474895867077,31.69647489586708,31.69647489586708,31.69647489586708,31.69647489586708,31.69647489586708,31.696474895867073]
[null,"New fixed costs / net sales",null,"Energy Rate - fixed portion ($/MWh)",{"$f":"E41/E29","v":65.829863362343957},66.087790217252092,66.347746179916541,66.609755289347575,66.873841965783754,67.14003101827943,67.408347652473878,67.6788174785477,67.951466519371365,68.226321218851652,68.226321218851652,68.226321218851652,68.226321218851652,68.226321218851638,68.226321218851652,68.226321218851652,68.226321218851652,68.226321218851652,68.226321218851652,68.226321218851652]
[null,"Sum of above",null,"Total Energy Rate ($/kWh)",{"$f":"E33+E32","v":98.520503030558757},{"$f":"F33+F32","v":98.671429550662026},98.823543408053908,98.976858669219183,99.131389623719215,99.287150788631891,99.444156913097729,99.60242298297554,99.761964225610626,99.922796114718722,99.922796114718722,99.922796114718722,99.922796114718736,99.922796114718722,99.922796114718736,99.922796114718736,99.922796114718736,99.922796114718736,99.922796114718736,99.922796114718722]
[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":1627378.5207004678},{"$f":"(Inputs!$D$36)*F$28","v":3287304.611814945},{"$f":"(Inputs!$D$36)*G$28","v":4980266.4868996413},{"$f":"(Inputs!$D$36)*H$28","v":6706758.8690248495},{"$f":"(Inputs!$D$36)*I$28","v":8467283.0721438732},{"$f":"(Inputs!$D$36)*J$28","v":10262347.083438374},{"$f":"(Inputs!$D$36)*K$28","v":12092465.646651553},{"$f":"(Inputs!$D$36)*L$28","v":13958160.346420649},{"$f":"(Inputs!$D$36)*M$28","v":15859959.693620462},{"$f":"(Inputs!$D$36)*N$28","v":17798399.211729631},{"$f":"(Inputs!$D$36)*O$28","v":17976383.203846928},{"$f":"(Inputs!$D$36)*P$28","v":18156147.035885397},{"$f":"(Inputs!$D$36)*Q$28","v":18337708.50624425},{"$f":"(Inputs!$D$36)*R$28","v":18521085.591306694},{"$f":"(Inputs!$D$36)*S$28","v":18706296.447219759},{"$f":"(Inputs!$D$36)*T$28","v":18893359.41169196},{"$f":"(Inputs!$D$36)*U$28","v":19082293.005808879},{"$f":"(Inputs!$D$36)*V$28","v":19273115.935866967},{"$f":"(Inputs!$D$36)*W$28","v":19465847.09522564},{"$f":"(Inputs!$D$36)*X$28","v":19660505.566177893}]
[null,"Costs avoided",null,"Avoided costs - fixed",{"$f":"(Inputs!$D$37)*E$28","v":0},{"$f":"(Inputs!$D$37)*F$28","v":0},{"$f":"(Inputs!$D$37)*G$28","v":0},{"$f":"(Inputs!$D$37)*H$28","v":0},{"$f":"(Inputs!$D$37)*I$28","v":0},{"$f":"(Inputs!$D$37)*J$28","v":0},{"$f":"(Inputs!$D$37)*K$28","v":0},{"$f":"(Inputs!$D$37)*L$28","v":0},{"$f":"(Inputs!$D$37)*M$28","v":0},{"$f":"(Inputs!$D$37)*N$28","v":0},{"$f":"(Inputs!$D$37)*O$28","v":0},{"$f":"(Inputs!$D$37)*P$28","v":0},{"$f":"(Inputs!$D$37)*Q$28","v":0},{"$f":"(Inputs!$D$37)*R$28","v":0},{"$f":"(Inputs!$D$37)*S$28","v":0},{"$f":"(Inputs!$D$37)*T$28","v":0},{"$f":"(Inputs!$D$37)*U$28","v":0},{"$f":"(Inputs!$D$37)*V$28","v":0},{"$f":"(Inputs!$D$37)*W$28","v":0},{"$f":"(Inputs!$D$37)*X$28","v":0}]
[null,"No DG PV less avoided fixed costs",null,"Variable Revenues and Costs",{"$f":"E18-E38","v":227188014.41660142},227816242.25485995,228434315.84844202,229041969.2896702,229638932.36813813,230224930.51124644,230799684.72398013,231362911.52791739,231914322.89946091,232453626.20728254,234778162.4693554,237125944.09404898,239497203.53498948,241892175.57033938,244311097.32604277,246754208.2993032,249221750.3822962,251713967.88611919,254231107.56498039,256773418.64063013]
[null,"No DG PV less avoided fixed costs",null,"Fixed Revenues and Costs",{"$f":"E19-E39","v":457493524.09119803},462068459.33211005,466689143.92543113,471356035.36468542,476069595.71833235,480830291.67551559,485638594.59227079,490494980.53819352,495399930.34357542,500353929.64701122,505357468.94348133,510411043.63291615,515515154.06924534,520670305.60993779,525877008.6660372,531135778.75269759,536447136.54022449,541811607.90562677,547229723.98468304,552702021.22452986]
[null,"Sum of fixed and variable",null,"Total Energy Rate Revenues and Costs",{"$f":"E40+E41","v":684681538.50779939},{"$f":"F40+F41","v":689884701.58696997},695123459.77387309,700398004.65435565,705708528.08647048,711055222.18676209,716438279.31625092,721857892.06611085,727314253.24303627,732807555.85429382,740135631.41283679,747536987.72696519,755012357.60423481,762562481.18027711,770188105.99207997,777889987.05200076,785668886.92252064,793525575.7917459,801460831.54966342,809475439.86515999]
[null,"Same as No DG PV",null,"Customer Charge Revenues and Costs",{"$f":"E21","v":52842024},53370444.24000001,53904148.682400003,54443190.169223994,54987622.070916235,55537498.29162541,56092873.274541661,56653802.00728707,57220340.027359948,57792543.427633546,58370468.861909889,58954173.550528988,59543715.286034279,60139152.438894622,60740543.963283569,61347949.402916402,61961428.896945566,62581043.185915023,63206853.617774174,63838922.153951906]
[null,"Sum of Energy Rate and Customer Charge",null,"Total Revenues and Costs",{"$f":"E42+E43","v":737523562.50779939},{"$f":"F42+F43","v":743255145.82696998},749027608.45627308,754841194.82357967,760696150.15738678,766592720.47838748,772531152.59079254,778511694.07339787,784534593.27039623,790600099.28192735,798506100.27474666,806491161.27749419,814556072.89026904,822701633.61917174,830928649.95536351,839237936.45491719,847630315.81946623,856106618.97766089,864667685.16743755,873314362.01911187]
[null,null,null,"Percent of total costs that are \"fixed\"",{"$f":"(E41+E43)/E44","v":0.69195829670296283},{"$f":"(F41+F43)/F44","v":0.69348850992294964},0.69502550604344304,0.69656933026396162,0.69812002818651542,0.69967764582009595,0.70124222958522686,0.70281382631857492,0.70439248327762427,0.70597824814541321,0.7059782481454131,0.70597824814541299,0.7059782481454131,0.70597824814541321,0.7059782481454131,0.70597824814541321,0.7059782481454131,0.70597824814541321,0.7059782481454131,0.70597824814541321]
[]
[null,null,"Differences"]
[null,null,"Rates"]
[null,null,null,"Change in Energy Rate - variable portion ($/MWh)",{"$f":"E32-E12","v":-0.10616838178519572},-0.21316871659006864,-0.32101082186262886,-0.42970467012838043,-0.53926039206453424,-0.64968827964752762,-0.76099878937614562,-0.87320254557215904,-0.98631034376073146,-1.1003331541329224,-1.1003331541329189,-1.1003331541329189,-1.1003331541329153,-1.1003331541329189,-1.1003331541329153,-1.1003331541329153,-1.1003331541329153,-1.1003331541329153,-1.1003331541329153,-1.1003331541329224]
[null,null,null,"Change in Energy Rate - fixed portion ($/MWh)",{"$f":"E33-E13","v":0.25592141234396593},0.51384826725210075,0.77380422991654996,1.0358133393475839,1.2999000157837628,1.5660890682794388,1.8344057024738873,2.1048755285477085,2.3775245693713742,2.6523792688516608,2.6523792688516608,2.6523792688516608,2.6523792688516608,2.6523792688516465,2.6523792688516608,2.6523792688516608,2.6523792688516608,2.6523792688516608,2.6523792688516608,2.6523792688516608]
[null,null,null,"Change in Total Energy Rate ($/MWh)",{"$f":"E34-E14","v":0.14975303055877021},0.30067955066203922,0.4527934080539211,0.60610866921919637,0.76063962371922855,0.91640078863190411,1.0734069130977417,1.2316729829755531,1.3912142256106392,1.5520461147187348,1.5520461147187348,1.5520461147187348,1.552046114718749,1.5520461147187348,1.552046114718749,1.552046114718749,1.552046114718749,1.552046114718749,1.552046114718749,1.5520461147187348,"`"]
[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":-3.2371559336914491E-3},-6.4996787573072812E-3,-9.7878678124174723E-3,-1.3102027169024422E-2,-1.6442465719298416E-2,-1.9809497273547305E-2,-2.3203440658492558E-2,-2.6624619817908091E-2,-3.0073363915691487E-2,-3.3550007441438323E-2,-3.3550007441438212E-2,-3.3550007441438212E-2,-3.3550007441438101E-2,-3.3550007441438212E-2,-3.3550007441438101E-2,-3.3550007441438101E-2,-3.3550007441438101E-2,-3.3550007441438101E-2,-3.3550007441438101E-2,-3.3550007441438323E-2]
[null,null,null,"Change in Energy Rate - fixed portion (%)",{"$f":"E33/E13-1","v":3.902791333470601E-3},7.8361655860785806E-3,1.1800483651060345E-2,1.5796112122363981E-2,1.9823423407653751E-2,2.3882795844019533E-2,2.7974613816454941E-2,3.209926787919315E-2,3.6257154879971054E-2,4.044867808731234E-2,4.044867808731234E-2,4.044867808731234E-2,4.044867808731234E-2,4.0448678087312118E-2,4.044867808731234E-2,4.044867808731234E-2,4.044867808731234E-2,4.044867808731234E-2,4.044867808731234E-2,4.044867808731234E-2]
[null,null,null,"Change in Total Energy Rate (%)",{"$f":"E34/E14-1","v":1.5223329145988007E-3},3.0565950819938514E-3,4.6029272731367143E-3,6.1614724826148937E-3,7.7323759727279118E-3,9.3157853186227602E-3,1.0911850454507377E-2,1.2520723720979676E-2,1.4142559913496999E-2,1.5777516332026842E-2,1.5777516332026842E-2,1.5777516332026842E-2,1.5777516332027064E-2,1.5777516332026842E-2,1.5777516332027064E-2,1.5777516332027064E-2,1.5777516332027064E-2,1.5777516332027064E-2,1.5777516332027064E-2,1.5777516332026842E-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":-2.3325712611796237E-2},{"$f":"(F42/F10-F14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-4.6651425223591052E-2},{"$f":"(G42/G10-G14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-6.9977137835388711E-2},{"$f":"(H42/H10-H14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-9.3302850447182104E-2},{"$f":"(I42/I10-I14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.11662856305897834},{"$f":"(J42/J10-J14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.13995427567077315},{"$f":"(K42/K10-K14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.16327998828257081},{"$f":"(L42/L10-L14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.18660570089436704},{"$f":"(M42/M10-M14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.20993141350616185},{"$f":"(N42/N10-N14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.23325712611795668},{"$f":"(O42/O10-O14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.23325712611795668},{"$f":"(P42/P10-P14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.23325712611795668},{"$f":"(Q42/Q10-Q14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.2332571261179581},{"$f":"(R42/R10-R14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.2332571261179581},{"$f":"(S42/S10-S14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.23325712611795668},{"$f":"(T42/T10-T14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.2332571261179581},{"$f":"(U42/U10-U14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.2332571261179581},{"$f":"(V42/V10-V14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.23325712611795668},{"$f":"(W42/W10-W14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.23325712611795668},{"$f":"(X42/X10-X14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.23325712611795668}]
[null,"Recovery of Lost Revenues",null,"Energy rate impact due to lost revenues (¢/kWh)",{"$f":"E61-E59","v":3.8301015667673258E-2},{"$f":"F61-F59","v":7.6719380289794969E-2},{"$f":"G61-G59","v":0.11525647864078081},0.15391371736910175,0.19269252543090121,0.23159435453396354,0.27062067959234498,0.30977299919192236,0.34905283606722576,0.38846173758983016,0.38846173758983016,0.38846173758983016,0.38846173758983299,0.3884617375898316,0.3884617375898316,0.38846173758983299,0.38846173758983299,0.3884617375898316,0.3884617375898316,0.38846173758983016]
[null,"Net Effect",null,"Energy rate impact of both  (¢/kWh)",{"$f":"E51/10","v":1.4975303055877021E-2},{"$f":"F51/10","v":3.0067955066203921E-2},{"$f":"G51/10","v":4.5279340805392108E-2},6.0610866921919637E-2,7.6063962371922852E-2,9.1640078863190408E-2,0.10734069130977417,0.12316729829755531,0.13912142256106391,0.15520461147187348,0.15520461147187348,0.15520461147187348,0.15520461147187489,0.15520461147187348,0.15520461147187489,0.15520461147187489,0.15520461147187489,0.15520461147187489,0.15520461147187489,0.15520461147187348]
[]
[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.59798460949202936},{"$f":"AVERAGE(E49:X49)","v":-0.84915888181247323}]
[null,null,null,"Change in Energy Rate - fixed portion ($/MWh)",{"$f":"AVERAGE(E50:N50)","v":1.4414561402168033},{"$f":"AVERAGE(E50:X50)","v":2.0469177045342315}]
[null,null,null,"Change in Total Energy Rate ($/MWh)",{"$f":"AVERAGE(E51:N51)","v":0.84347153072477288},{"$f":"AVERAGE(E51:X51)","v":1.1977588227217582}]
[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":-1.823301244988168E-2},{"$f":"AVERAGE(E55:X55)","v":-2.5891509945659918E-2}]
[null,null,null,"Change in Energy Rate - fixed portion (%)",{"$f":"AVERAGE(E56:N56)","v":2.1982148660757827E-2},{"$f":"AVERAGE(E56:X56)","v":3.1215413374035071E-2}]
[null,null,null,"Total Energy Rate (%)"]
[]
[null,null,null,"Energy Rate impact due to AC  (¢/kWh)",{"$f":"AVERAGE(E59:N59)","v":-0.12829141936487659},{"$f":"AVERAGE(E59:X59)","v":-0.18077427274141686}]
[null,null,null,"Energy rate impact due to lost revenues  (¢/kWh)",{"$f":"AVERAGE(E60:N60)","v":0.2126385724373539},{"$f":"AVERAGE(E60:X60)","v":0.30055015501359272}]
[null,null,null,"Energy rate impact of both  (¢/kWh)",{"$f":"AVERAGE(E61:N61)","v":8.4347153072477282E-2},{"$f":"AVERAGE(E61:X61)","v":0.1197758822721758}]

{"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":32.796808049999996},{"$f":"Rate_Impacts_With_v_Without!F12","v":32.796808049999996},{"$f":"Rate_Impacts_With_v_Without!G12","v":32.796808049999996},{"$f":"Rate_Impacts_With_v_Without!H12","v":32.796808049999996},{"$f":"Rate_Impacts_With_v_Without!I12","v":32.796808049999996},{"$f":"Rate_Impacts_With_v_Without!J12","v":32.796808049999996},{"$f":"Rate_Impacts_With_v_Without!K12","v":32.796808049999996},{"$f":"Rate_Impacts_With_v_Without!L12","v":32.796808049999996},{"$f":"Rate_Impacts_With_v_Without!M12","v":32.796808049999996},{"$f":"Rate_Impacts_With_v_Without!N12","v":32.796808049999996},{"$f":"Rate_Impacts_With_v_Without!O12","v":32.796808049999996},{"$f":"Rate_Impacts_With_v_Without!P12","v":32.796808049999996},{"$f":"Rate_Impacts_With_v_Without!Q12","v":32.796808049999996},{"$f":"Rate_Impacts_With_v_Without!R12","v":32.796808049999996},{"$f":"Rate_Impacts_With_v_Without!S12","v":32.796808049999996},{"$f":"Rate_Impacts_With_v_Without!T12","v":32.796808049999996},{"$f":"Rate_Impacts_With_v_Without!U12","v":32.796808049999996},{"$f":"Rate_Impacts_With_v_Without!V12","v":32.796808049999996},{"$f":"Rate_Impacts_With_v_Without!W12","v":32.796808049999996},{"$f":"Rate_Impacts_With_v_Without!X12","v":32.796808049999996}]
[null,"Energy rate times fixed portion",null,"Energy Rate - fixed portion ($/MWh)",{"$f":"Rate_Impacts_With_v_Without!E13","v":65.573941949999991},{"$f":"Rate_Impacts_With_v_Without!F13","v":65.573941949999991},{"$f":"Rate_Impacts_With_v_Without!G13","v":65.573941949999991},{"$f":"Rate_Impacts_With_v_Without!H13","v":65.573941949999991},{"$f":"Rate_Impacts_With_v_Without!I13","v":65.573941949999991},{"$f":"Rate_Impacts_With_v_Without!J13","v":65.573941949999991},{"$f":"Rate_Impacts_With_v_Without!K13","v":65.573941949999991},{"$f":"Rate_Impacts_With_v_Without!L13","v":65.573941949999991},{"$f":"Rate_Impacts_With_v_Without!M13","v":65.573941949999991},{"$f":"Rate_Impacts_With_v_Without!N13","v":65.573941949999991},{"$f":"Rate_Impacts_With_v_Without!O13","v":65.573941949999991},{"$f":"Rate_Impacts_With_v_Without!P13","v":65.573941949999991},{"$f":"Rate_Impacts_With_v_Without!Q13","v":65.573941949999991},{"$f":"Rate_Impacts_With_v_Without!R13","v":65.573941949999991},{"$f":"Rate_Impacts_With_v_Without!S13","v":65.573941949999991},{"$f":"Rate_Impacts_With_v_Without!T13","v":65.573941949999991},{"$f":"Rate_Impacts_With_v_Without!U13","v":65.573941949999991},{"$f":"Rate_Impacts_With_v_Without!V13","v":65.573941949999991},{"$f":"Rate_Impacts_With_v_Without!W13","v":65.573941949999991},{"$f":"Rate_Impacts_With_v_Without!X13","v":65.573941949999991}]
[null,"Sum of above",null,"Total Energy Rate ($/MWh)",{"$f":"Rate_Impacts_With_v_Without!E14","v":98.370749999999987},{"$f":"Rate_Impacts_With_v_Without!F14","v":98.370749999999987},{"$f":"Rate_Impacts_With_v_Without!G14","v":98.370749999999987},{"$f":"Rate_Impacts_With_v_Without!H14","v":98.370749999999987},{"$f":"Rate_Impacts_With_v_Without!I14","v":98.370749999999987},{"$f":"Rate_Impacts_With_v_Without!J14","v":98.370749999999987},{"$f":"Rate_Impacts_With_v_Without!K14","v":98.370749999999987},{"$f":"Rate_Impacts_With_v_Without!L14","v":98.370749999999987},{"$f":"Rate_Impacts_With_v_Without!M14","v":98.370749999999987},{"$f":"Rate_Impacts_With_v_Without!N14","v":98.370749999999987},{"$f":"Rate_Impacts_With_v_Without!O14","v":98.370749999999987},{"$f":"Rate_Impacts_With_v_Without!P14","v":98.370749999999987},{"$f":"Rate_Impacts_With_v_Without!Q14","v":98.370749999999987},{"$f":"Rate_Impacts_With_v_Without!R14","v":98.370749999999987},{"$f":"Rate_Impacts_With_v_Without!S14","v":98.370749999999987},{"$f":"Rate_Impacts_With_v_Without!T14","v":98.370749999999987},{"$f":"Rate_Impacts_With_v_Without!U14","v":98.370749999999987},{"$f":"Rate_Impacts_With_v_Without!V14","v":98.370749999999987},{"$f":"Rate_Impacts_With_v_Without!W14","v":98.370749999999987},{"$f":"Rate_Impacts_With_v_Without!X14","v":98.370749999999987}]
[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":32.6906396682148},{"$f":"Rate_Impacts_With_v_Without!F32","v":32.583639333409927},{"$f":"Rate_Impacts_With_v_Without!G32","v":32.475797228137367},{"$f":"Rate_Impacts_With_v_Without!H32","v":32.367103379871615},{"$f":"Rate_Impacts_With_v_Without!I32","v":32.257547657935461},{"$f":"Rate_Impacts_With_v_Without!J32","v":32.147119770352468},{"$f":"Rate_Impacts_With_v_Without!K32","v":32.03580926062385},{"$f":"Rate_Impacts_With_v_Without!L32","v":31.923605504427837},{"$f":"Rate_Impacts_With_v_Without!M32","v":31.810497706239264},{"$f":"Rate_Impacts_With_v_Without!N32","v":31.696474895867073},{"$f":"Rate_Impacts_With_v_Without!O32","v":31.696474895867077},{"$f":"Rate_Impacts_With_v_Without!P32","v":31.696474895867077},{"$f":"Rate_Impacts_With_v_Without!Q32","v":31.69647489586708},{"$f":"Rate_Impacts_With_v_Without!R32","v":31.696474895867077},{"$f":"Rate_Impacts_With_v_Without!S32","v":31.69647489586708},{"$f":"Rate_Impacts_With_v_Without!T32","v":31.69647489586708},{"$f":"Rate_Impacts_With_v_Without!U32","v":31.69647489586708},{"$f":"Rate_Impacts_With_v_Without!V32","v":31.69647489586708},{"$f":"Rate_Impacts_With_v_Without!W32","v":31.69647489586708},{"$f":"Rate_Impacts_With_v_Without!X32","v":31.696474895867073}]
[null,"New fixed costs / net sales",null,"Energy Rate - fixed portion ($/MWh)",{"$f":"Rate_Impacts_With_v_Without!E33","v":65.829863362343957},{"$f":"Rate_Impacts_With_v_Without!F33","v":66.087790217252092},{"$f":"Rate_Impacts_With_v_Without!G33","v":66.347746179916541},{"$f":"Rate_Impacts_With_v_Without!H33","v":66.609755289347575},{"$f":"Rate_Impacts_With_v_Without!I33","v":66.873841965783754},{"$f":"Rate_Impacts_With_v_Without!J33","v":67.14003101827943},{"$f":"Rate_Impacts_With_v_Without!K33","v":67.408347652473878},{"$f":"Rate_Impacts_With_v_Without!L33","v":67.6788174785477},{"$f":"Rate_Impacts_With_v_Without!M33","v":67.951466519371365},{"$f":"Rate_Impacts_With_v_Without!N33","v":68.226321218851652},{"$f":"Rate_Impacts_With_v_Without!O33","v":68.226321218851652},{"$f":"Rate_Impacts_With_v_Without!P33","v":68.226321218851652},{"$f":"Rate_Impacts_With_v_Without!Q33","v":68.226321218851652},{"$f":"Rate_Impacts_With_v_Without!R33","v":68.226321218851638},{"$f":"Rate_Impacts_With_v_Without!S33","v":68.226321218851652},{"$f":"Rate_Impacts_With_v_Without!T33","v":68.226321218851652},{"$f":"Rate_Impacts_With_v_Without!U33","v":68.226321218851652},{"$f":"Rate_Impacts_With_v_Without!V33","v":68.226321218851652},{"$f":"Rate_Impacts_With_v_Without!W33","v":68.226321218851652},{"$f":"Rate_Impacts_With_v_Without!X33","v":68.226321218851652}]
[null,"Sum of above",null,"Total Energy Rate ($/MWh)",{"$f":"Rate_Impacts_With_v_Without!E34","v":98.520503030558757},{"$f":"Rate_Impacts_With_v_Without!F34","v":98.671429550662026},{"$f":"Rate_Impacts_With_v_Without!G34","v":98.823543408053908},{"$f":"Rate_Impacts_With_v_Without!H34","v":98.976858669219183},{"$f":"Rate_Impacts_With_v_Without!I34","v":99.131389623719215},{"$f":"Rate_Impacts_With_v_Without!J34","v":99.287150788631891},{"$f":"Rate_Impacts_With_v_Without!K34","v":99.444156913097729},{"$f":"Rate_Impacts_With_v_Without!L34","v":99.60242298297554},{"$f":"Rate_Impacts_With_v_Without!M34","v":99.761964225610626},{"$f":"Rate_Impacts_With_v_Without!N34","v":99.922796114718722},{"$f":"Rate_Impacts_With_v_Without!O34","v":99.922796114718722},{"$f":"Rate_Impacts_With_v_Without!P34","v":99.922796114718722},{"$f":"Rate_Impacts_With_v_Without!Q34","v":99.922796114718736},{"$f":"Rate_Impacts_With_v_Without!R34","v":99.922796114718722},{"$f":"Rate_Impacts_With_v_Without!S34","v":99.922796114718736},{"$f":"Rate_Impacts_With_v_Without!T34","v":99.922796114718736},{"$f":"Rate_Impacts_With_v_Without!U34","v":99.922796114718736},{"$f":"Rate_Impacts_With_v_Without!V34","v":99.922796114718736},{"$f":"Rate_Impacts_With_v_Without!W34","v":99.922796114718736},{"$f":"Rate_Impacts_With_v_Without!X34","v":99.922796114718722}]
[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":-0.10700033480487292},{"$f":"G13-F13","v":-0.10784210527256022},-0.10869384826575157,-0.10955572193615382,{"$f":"J13-I13","v":-0.11042788758299338},-0.111310509728618,-0.11220375619601342,-0.11310779818857242,-0.11402281037219097,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Energy Rate - fixed portion ($/MWh)","----",{"$f":"F14-E14","v":0.25792685490813483},0.2599559626644492,0.26200910943103395,0.26408667643617889,0.26618905249567604,0.26831663419444851,0.2704698260738212,0.2726490408236657,0.27485469948028651,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Total Energy Rate ($/MWh)","----",{"$f":"F15-E15","v":0.15092652010326901},{"$f":"G15-F15","v":0.15211385739188188},0.15331526116527527,0.15453095450003218,{"$f":"J15-I15","v":0.15576116491267555},0.15700612446583762,0.15826606987781133,0.15954124263508618,0.16083188910809554,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":-3.2731184183254491E-3},{"$f":"G13/F13-1","v":-3.3097010487095346E-3},{"$f":"H13/G13-1","v":-3.3469185529825252E-3},-3.3847861098464938E-3,-3.4233193655633931E-3,-3.4625344517262846E-3,-3.5024480038319261E-3,-3.5430771807051231E-3,-3.5844396848222493E-3,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Energy Rate - fixed portion (%)","----",{"$f":"F14/E14-1","v":3.9180827930394013E-3},3.9334945503533003E-3,{"$f":"H14/G14-1","v":3.9490280305911618E-3},3.9646846815306613E-3,3.9804659740032555E-3,3.9963734023507058E-3,4.0124084848991437E-3,4.0285727644411296E-3,4.0448678087312562E-3,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Total Energy Rate (%)","----",1.5319300598419794E-3,1.5416200827795823E-3,{"$f":"H15/G15-1","v":1.5514042087341195E-3},1.5612836836584876E-3,1.5712597745669576E-3,1.5813337699666086E-3,1.5915069803056348E-3,1.6017807384300919E-3,1.6121564000521893E-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]