{"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":1,"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",0.01,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)",{"$f":"[1]Ref_Sheet!F63+[1]Ref_Sheet!F64","v":56},null,"Avoided fuel, variable O&M, and line losses. "]
[null,null,"Avoided generation capacity capital costs ($/MWh)",{"$f":"[1]Ref_Sheet!F65","v":14},null,"Capital cost of generation to meet peak load. "]
[null,null,"Avoided transmission capital costs ($/MWh)",{"$f":"[1]Ref_Sheet!F66","v":11},null,"Cost of money savings resulting from defferring T&D capacity additions. "]
[null,null,"Avoided distribution capital costs ($/MWh)",0,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,"Hayet Revised - Costs to comply with environemetnal regulations and policy objectives. Default from CPR 2014."]
[null,null,"Fuel price guarantee/avoided risk ($/MWh)",null,null,"Hayet Revised - Cost of eliminating uncertainty in fuel price fluctuations. Default $0.00"]
[]
[null,null,"Variable Avoided Costs ($/MWh)",{"$f":"SUM(D29+D33+D34)","v":56},null,"Includes avoided energy, avoided environmental, and fuel price guarantee"]
[null,null,"Fixed Avoided Costs ($/MWh)",{"$f":"SUM(D30:D32)","v":25},null,"Includes avoided capital costs associated with generation and T&D capacity"]
[null,null,"Total Avoided Costs ($/MWh)",{"$f":"SUM(D36:D37)","v":81},null,"Sum of variable and fixed avoided costs"]

{"sheet":"Rate_Impacts_With_v_Without","index":1,"n_rows":83,"n_cols":25,"rows_kept":83,"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":0.01},{"$f":"MIN(E27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.02},{"$f":"MIN(F27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.03},{"$f":"MIN(G27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.04},{"$f":"MIN(H27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.05},{"$f":"MIN(I27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":6.0000000000000005E-2},{"$f":"MIN(J27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":7.0000000000000007E-2},{"$f":"MIN(K27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.08},{"$f":"MIN(L27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.09},{"$f":"MIN(M27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":9.9999999999999992E-2},{"$f":"MIN(N27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.1},{"$f":"MIN(O27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.1},{"$f":"MIN(P27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.1},{"$f":"MIN(Q27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.1},{"$f":"MIN(R27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.1},{"$f":"MIN(S27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.1},{"$f":"MIN(T27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.1},{"$f":"MIN(U27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.1},{"$f":"MIN(V27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.1},{"$f":"MIN(W27+Inputs!$D$26,Inputs!$D$26*Inputs!$D$27)","v":0.1}]
[null,"Customers x % with DGPV * typical DGPV gen",null,"Annual Customer PV Gen (MWh)",{"$f":"E4*E27*Inputs!$D$25","v":54245.95069001559},{"$f":"F4*F27*Inputs!$D$25","v":109576.8203938315},{"$f":"G4*G27*Inputs!$D$25","v":166008.88289665472},{"$f":"H4*H27*Inputs!$D$25","v":223558.62896749499},{"$f":"I4*I27*Inputs!$D$25","v":282242.76907146245},{"$f":"J4*J27*Inputs!$D$25","v":342078.23611461249},{"$f":"K4*K27*Inputs!$D$25","v":403082.18822171842},{"$f":"L4*L27*Inputs!$D$25","v":465272.01154735498},{"$f":"M4*M27*Inputs!$D$25","v":528665.32312068203},{"$f":"N4*N27*Inputs!$D$25","v":593279.973724321},{"$f":"O4*O27*Inputs!$D$25","v":599212.77346156421},{"$f":"P4*P27*Inputs!$D$25","v":605204.90119617991},{"$f":"Q4*Q27*Inputs!$D$25","v":611256.9502081417},{"$f":"R4*R27*Inputs!$D$25","v":617369.51971022319},{"$f":"S4*S27*Inputs!$D$25","v":623543.21490732534},{"$f":"T4*T27*Inputs!$D$25","v":629778.64705639868},{"$f":"U4*U27*Inputs!$D$25","v":636076.43352696265},{"$f":"V4*V27*Inputs!$D$25","v":642437.19786223222},{"$f":"W4*W27*Inputs!$D$25","v":648861.56984085462},{"$f":"X4*X27*Inputs!$D$25","v":655350.18553926307}]
[null,"Net Sales = Demand - customer generation ",null,"Net annual residential sales [after PV] (MWh)",{"$f":"E6-E28","v":6922512.0493099848},6936948.7596061686,6950981.9529033462,6964602.1151905051,6977799.582528118,6990564.5390009629,7002887.014645014,7014756.8833480449,7026163.8607236706,7037097.5019584764,7107468.4769780608,7178543.1617478421,7250328.5933653209,7322831.8792989738,7396060.1980919633,7470020.8000728833,7544721.0080736112,7620168.2181543475,7696369.9003358912,7773333.5993392495]
[null,null,null,"Installed DG PV (MW)",{"$f":"E27*E4*Inputs!$D$23","v":36.69585},{"$f":"F27*F4*Inputs!$D$23","v":74.125617000000005},{"$f":"G27*G4*Inputs!$D$23","v":112.300309755},{"$f":"H27*H4*Inputs!$D$23","v":151.2310838034},{"$f":"I27*I4*Inputs!$D$23","v":190.92924330179252},{"$f":"J27*J4*Inputs!$D$23","v":231.40624288177253},{"$f":"K27*K4*Inputs!$D$23","v":272.673689529022},{"$f":"L27*L4*Inputs!$D$23","v":314.74334448492823},{"$f":"M27*M4*Inputs!$D$23","v":357.62712517099965},{"$f":"N27*N4*Inputs!$D$23","v":401.33710713634406},{"$f":"O27*O4*Inputs!$D$23","v":405.35047820770757},{"$f":"P27*P4*Inputs!$D$23","v":409.40398298978465},{"$f":"Q27*Q4*Inputs!$D$23","v":413.49802281968255},{"$f":"R27*R4*Inputs!$D$23","v":417.63300304787936},{"$f":"S27*S4*Inputs!$D$23","v":421.80933307835812},{"$f":"T27*T4*Inputs!$D$23","v":426.0274264091417},{"$f":"U27*U4*Inputs!$D$23","v":430.28770067323313},{"$f":"V27*V4*Inputs!$D$23","v":434.59057767996546},{"$f":"W27*W4*Inputs!$D$23","v":438.93648345676513},{"$f":"X27*X4*Inputs!$D$23","v":443.32584829133276}]
[null,null,"Rates"]
[null,"New variable costs / net sales",null,"Energy Rate - variable portion ($/MWh)",{"$f":"E40/E29","v":32.614983995754237},{"$f":"F40/F29","v":32.430287828361067},32.24265095372855,32.052002575944606,31.858269608216329,31.661376579451105,31.461245536228855,31.257795939897729,31.050944558507997,30.840605353279475,30.840605353279479,30.840605353279482,30.840605353279475,30.840605353279482,30.840605353279482,30.840605353279482,30.840605353279482,30.840605353279479,30.840605353279482,30.840605353279479]
[null,"New fixed costs / net sales",null,"Energy Rate - fixed portion ($/MWh)",{"$f":"E41/E29","v":65.891886077600105},66.214852486288478,66.542961122178937,66.876335781567875,67.215104266668845,67.559398548968218,67.9093549406401,68.265114274488582,68.626822092915887,68.994628846449672,68.994628846449672,68.994628846449672,68.994628846449672,68.994628846449672,68.994628846449672,68.994628846449672,68.994628846449672,68.994628846449672,68.994628846449672,68.994628846449686]
[null,"Sum of above",null,"Total Energy Rate ($/kWh)",{"$f":"E33+E32","v":98.506870073354349},{"$f":"F33+F32","v":98.645140314649552},98.785612075907494,98.928338357512473,99.073373874885178,99.220775128419319,99.370600476868958,99.522910214386314,99.67776665142388,99.835234199729143,99.835234199729143,99.835234199729157,99.835234199729143,99.835234199729157,99.835234199729157,99.835234199729157,99.835234199729157,99.835234199729143,99.835234199729157,99.835234199729172]
[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":3037773.2386408732},{"$f":"(Inputs!$D$36)*F$28","v":6136301.9420545641},{"$f":"(Inputs!$D$36)*G$28","v":9296497.4422126636},{"$f":"(Inputs!$D$36)*H$28","v":12519283.22217972},{"$f":"(Inputs!$D$36)*I$28","v":15805595.068001896},{"$f":"(Inputs!$D$36)*J$28","v":19156381.222418301},{"$f":"(Inputs!$D$36)*K$28","v":22572602.540416233},{"$f":"(Inputs!$D$36)*L$28","v":26055232.646651879},{"$f":"(Inputs!$D$36)*M$28","v":29605258.094758194},{"$f":"(Inputs!$D$36)*N$28","v":33223678.528561976},{"$f":"(Inputs!$D$36)*O$28","v":33555915.313847594},{"$f":"(Inputs!$D$36)*P$28","v":33891474.466986075},{"$f":"(Inputs!$D$36)*Q$28","v":34230389.211655937},{"$f":"(Inputs!$D$36)*R$28","v":34572693.103772499},{"$f":"(Inputs!$D$36)*S$28","v":34918420.034810215},{"$f":"(Inputs!$D$36)*T$28","v":35267604.235158324},{"$f":"(Inputs!$D$36)*U$28","v":35620280.277509905},{"$f":"(Inputs!$D$36)*V$28","v":35976483.080285005},{"$f":"(Inputs!$D$36)*W$28","v":36336247.911087856},{"$f":"(Inputs!$D$36)*X$28","v":36699610.39019873}]
[null,"Costs avoided",null,"Avoided costs - fixed",{"$f":"(Inputs!$D$37)*E$28","v":1356148.7672503898},{"$f":"(Inputs!$D$37)*F$28","v":2739420.5098457877},{"$f":"(Inputs!$D$37)*G$28","v":4150222.0724163679},{"$f":"(Inputs!$D$37)*H$28","v":5588965.724187375},{"$f":"(Inputs!$D$37)*I$28","v":7056069.2267865613},{"$f":"(Inputs!$D$37)*J$28","v":8551955.902865313},{"$f":"(Inputs!$D$37)*K$28","v":10077054.705542961},{"$f":"(Inputs!$D$37)*L$28","v":11631800.288683875},{"$f":"(Inputs!$D$37)*M$28","v":13216633.07801705},{"$f":"(Inputs!$D$37)*N$28","v":14831999.343108024},{"$f":"(Inputs!$D$37)*O$28","v":14980319.336539105},{"$f":"(Inputs!$D$37)*P$28","v":15130122.529904498},{"$f":"(Inputs!$D$37)*Q$28","v":15281423.755203543},{"$f":"(Inputs!$D$37)*R$28","v":15434237.992755581},{"$f":"(Inputs!$D$37)*S$28","v":15588580.372683134},{"$f":"(Inputs!$D$37)*T$28","v":15744466.176409967},{"$f":"(Inputs!$D$37)*U$28","v":15901910.838174066},{"$f":"(Inputs!$D$37)*V$28","v":16060929.946555806},{"$f":"(Inputs!$D$37)*W$28","v":16221539.246021366},{"$f":"(Inputs!$D$37)*X$28","v":16383754.638481576}]
[null,"No DG PV less avoided fixed costs",null,"Variable Revenues and Costs",{"$f":"E18-E38","v":225777619.698661},224967244.92462033,224118084.89312899,223229444.93651533,222300620.37228012,221330896.3722665,220319547.83021545,219265839.22768617,218169024.4983232,217028346.89045021,219198630.35935473,221390616.66294831,223604522.82957777,225840568.05787358,228098973.73845232,230379963.47583684,232683763.1105952,235010600.74170113,237360706.74911815,239734313.81660929]
[null,"No DG PV less avoided fixed costs",null,"Fixed Revenues and Costs",{"$f":"E19-E39","v":456137375.32394761},459329038.82226425,462538921.85301477,465767069.64049804,469013526.4915458,472278335.7726503,475561539.88672781,478863180.24950963,482183297.26555836,485521930.30390322,490377149.60694224,495280921.10301167,500233730.31404179,505236067.6171822,510288428.29335409,515391312.57628763,520545225.70205045,525750677.95907098,531008184.73866165,536318266.58604831]
[null,"Sum of fixed and variable",null,"Total Energy Rate Revenues and Costs",{"$f":"E40+E41","v":681914995.02260864},{"$f":"F40+F41","v":684296283.74688458},686657006.74614382,688996514.57701337,691314146.86382592,693609232.14491677,695881087.71694326,698129019.47719574,700352321.76388156,702550277.19435346,709575779.96629691,716671537.76595998,723838253.14361954,731076635.67505574,738387402.03180647,745771276.0521245,753228988.81264567,760761278.70077205,768368891.48777986,776052580.40265763]
[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":734757019.02260864},{"$f":"F42+F43","v":737666727.98688459},740561155.42854381,743439704.7462374,746301768.93474221,749146730.43654215,751973960.99148488,754782821.48448277,757572661.79124153,760342820.62198699,767946248.82820678,775625711.31648898,783381968.42965376,791215788.11395037,799127945.99509001,807119225.45504093,815190417.70959127,823342321.88668704,831575745.10555398,839891502.55660951]
[null,null,null,"Percent of total costs that are \"fixed\"",{"$f":"(E41+E43)/E44","v":0.69271798179077515},{"$f":"(F41+F43)/F44","v":0.69502861334336863},0.69736721505000132,0.69973429787058317,0.70213038528692207,0.7045560136886766,0.70701173277366947,0.70949810596319485,0.7120157108329731,0.71456513956045054,0.71456513956045065,0.71456513956045042,0.71456513956045065,0.71456513956045054,0.71456513956045054,0.71456513956045054,0.71456513956045054,0.71456513956045065,0.71456513956045042,0.71456513956045065]
[]
[null,null,"Differences"]
[null,null,"Rates"]
[null,null,null,"Change in Energy Rate - variable portion ($/MWh)",{"$f":"E32-E12","v":-0.18182405424575876},-0.36652022163892894,-0.55415709627144594,-0.74480547405538999,-0.93853844178366685,-1.135431470548891,-1.3355625137711407,-1.5390121101022665,-1.745863491491999,-1.9562026967205206,-1.9562026967205171,-1.9562026967205135,-1.9562026967205206,-1.9562026967205135,-1.9562026967205135,-1.9562026967205135,-1.9562026967205135,-1.9562026967205171,-1.9562026967205135,-1.9562026967205171]
[null,null,null,"Change in Energy Rate - fixed portion ($/MWh)",{"$f":"E33-E13","v":0.31794412760011426},0.64091053628848726,0.96901917217894606,1.3023938315678834,1.6411623166688543,1.9854565989682271,2.3354129906401084,2.6911723244885906,3.052880142915896,3.4206868964496806,3.4206868964496806,3.4206868964496806,3.4206868964496806,3.4206868964496806,3.4206868964496806,3.4206868964496806,3.4206868964496806,3.4206868964496806,3.4206868964496806,3.4206868964496948]
[null,null,null,"Change in Total Energy Rate ($/MWh)",{"$f":"E34-E14","v":0.1361200733543626},0.27439031464956543,0.41486207590750723,0.55758835751248625,0.70262387488519096,0.85002512841933253,0.99985047686897133,1.1521602143863277,1.3070166514238934,1.4644841997291564,1.4644841997291564,1.4644841997291707,1.4644841997291564,1.4644841997291707,1.4644841997291707,1.4644841997291707,1.4644841997291707,1.4644841997291564,1.4644841997291707,1.4644841997291849,"`"]
[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":-5.5439558010816903E-3},-1.1175484549598713E-2,-1.689667773237602E-2,-2.2709693971434852E-2,-2.8616761739521435E-2,-3.4620182208521033E-2,-4.0722332238400272E-2,-4.6925667514838176E-2,-5.3232725844245654E-2,-5.9646130615461534E-2,-5.9646130615461423E-2,-5.9646130615461312E-2,-5.9646130615461534E-2,-5.9646130615461312E-2,-5.9646130615461312E-2,-5.9646130615461312E-2,-5.9646130615461312E-2,-5.9646130615461423E-2,-5.9646130615461312E-2,-5.9646130615461423E-2]
[null,null,null,"Change in Energy Rate - fixed portion (%)",{"$f":"E33/E13-1","v":4.8486352679932843E-3},9.7738601223209542E-3,1.4777503736435715E-2,1.9861453998921696E-2,2.5027659888439135E-2,3.0278133964893206E-2,3.56149549835032E-2,4.1040270638916354E-2,4.6556300446962684E-2,5.2165338772190095E-2,5.2165338772190095E-2,5.2165338772190095E-2,5.2165338772190095E-2,5.2165338772190095E-2,5.2165338772190095E-2,5.2165338772190095E-2,5.2165338772190095E-2,5.2165338772190095E-2,5.2165338772190095E-2,5.2165338772190317E-2]
[null,null,null,"Change in Total Energy Rate (%)",{"$f":"E34/E14-1","v":1.3837454055638521E-3},2.7893486087029462E-3,4.2173316347340339E-3,5.6682332656048384E-3,7.1426097176772174E-3,8.6410353526769068E-3,1.0164103423720761E-2,1.171242685845475E-2,1.3286639081473872E-2,1.4887394878347004E-2,1.4887394878347004E-2,1.4887394878347227E-2,1.4887394878347004E-2,1.4887394878347227E-2,1.4887394878347227E-2,1.4887394878347227E-2,1.4887394878347227E-2,1.4887394878347004E-2,1.4887394878347227E-2,1.4887394878347227E-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.2979424051849267E-2},{"$f":"(F42/F10-F14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.12595884810369712},{"$f":"(G42/G10-G14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.18893827215554496},{"$f":"(H42/H10-H14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.25191769620739424},{"$f":"(I42/I10-I14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.3148971202592421},{"$f":"(J42/J10-J14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.37787654431109136},{"$f":"(K42/K10-K14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.44085596836293917},{"$f":"(L42/L10-L14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.50383539241478847},{"$f":"(M42/M10-M14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.56681481646663634},{"$f":"(N42/N10-N14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.62979424051848421},{"$f":"(O42/O10-O14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.62979424051848554},{"$f":"(P42/P10-P14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.62979424051848421},{"$f":"(Q42/Q10-Q14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.62979424051848554},{"$f":"(R42/R10-R14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.62979424051848554},{"$f":"(S42/S10-S14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.62979424051848276},{"$f":"(T42/T10-T14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.62979424051848421},{"$f":"(U42/U10-U14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.62979424051848421},{"$f":"(V42/V10-V14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.62979424051848421},{"$f":"(W42/W10-W14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.62979424051848421},{"$f":"(X42/X10-X14)*(Ref_Sheet!$C$72/Ref_Sheet!$C$71)","v":-0.62979424051848421}]
[null,"Recovery of Lost Revenues",null,"Energy rate impact due to lost revenues (¢/kWh)",{"$f":"E61-E59","v":7.6591431387285525E-2},{"$f":"F61-F59","v":0.15339787956865367},{"$f":"G61-G59","v":0.23042447974629568},0.30767653195864286,0.3851595077477612,0.46287905715302458,0.54084101604983625,0.61905141385342122,0.69751648160902568,0.77624266049139989,0.77624266049140123,0.77624266049140123,0.77624266049140123,0.77624266049140256,0.77624266049139989,0.77624266049140123,0.77624266049140123,0.77624266049139989,0.77624266049140123,0.77624266049140267]
[null,"Net Effect",null,"Energy rate impact of both  (¢/kWh)",{"$f":"E51/10","v":1.3612007335436261E-2},{"$f":"F51/10","v":2.7439031464956541E-2},{"$f":"G51/10","v":4.1486207590750723E-2},5.5758835751248625E-2,7.0262387488519096E-2,8.5002512841933248E-2,9.998504768689713E-2,0.11521602143863277,0.13070166514238934,0.14644841997291563,0.14644841997291563,0.14644841997291708,0.14644841997291563,0.14644841997291708,0.14644841997291708,0.14644841997291708,0.14644841997291708,0.14644841997291563,0.14644841997291708,0.14644841997291849]
[]
[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":-1.0497917570630009},{"$f":"AVERAGE(E49:X49)","v":-1.502997226891758}]
[null,null,null,"Change in Energy Rate - fixed portion ($/MWh)",{"$f":"AVERAGE(E50:N50)","v":1.8357038937766788},{"$f":"AVERAGE(E50:X50)","v":2.6281953951131802},null,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":0.78591213671367943},{"$f":"AVERAGE(E51:X51)","v":1.1251981682214236}]
[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":-3.2008961221547935E-2},{"$f":"AVERAGE(E55:X55)","v":-4.5827545918504652E-2}]
[null,null,null,"Change in Energy Rate - fixed portion (%)",{"$f":"AVERAGE(E56:N56)","v":2.7994411182057633E-2},{"$f":"AVERAGE(E56:X56)","v":4.0079874977123876E-2}]
[null,null,null,"Total Energy Rate (%)"]
[]
[null,null,null,"Energy Rate impact due to AC  (¢/kWh)",{"$f":"AVERAGE(E59:N59)","v":-0.34638683228516676},{"$f":"AVERAGE(E59:X59)","v":-0.48809053640182548}]
[null,null,null,"Energy rate impact due to lost revenues  (¢/kWh)",{"$f":"AVERAGE(E60:N60)","v":0.4249780459565346},{"$f":"AVERAGE(E60:X60)","v":0.60061035322396794}]
[null,null,null,"Energy rate impact of both  (¢/kWh)",{"$f":"AVERAGE(E61:N61)","v":7.859121367136794E-2},{"$f":"AVERAGE(E61:X61)","v":0.11251981682214236}]
[]
[]
[null,null,null,"Annual Impact to Avg non-NM customer"]
[null,null,null,"impact due to AC ",{"$f":"E59*10*$E$5","v":-5.9869467608616747},{"$f":"F59*10*$E$5","v":-11.973893521723214},-17.960840282584755,-23.947787043446429,-29.934733804307974,-35.921680565169645,-41.90862732603118,-47.895574086892857,-53.882520847754407,-59.869467608615949,-59.86946760861607,-59.869467608615949,-59.86946760861607,-59.86946760861607,-59.869467608615807,-59.869467608615949,-59.869467608615949,-59.869467608615949,-59.869467608615949,-59.869467608615949]
[null,null,null,"impact due to lost revenues ",{"$f":"E60*10*$E$5","v":7.2809307001022647},14.582301315593467,21.904600008799445,29.248330611700194,36.614013259745377,44.002185056686542,51.41340077221026,58.84823357427566,66.307275798184577,73.79113975455887,73.791139754558998,73.791139754558998,73.791139754558998,73.791139754559126,73.79113975455887,73.791139754558998,73.791139754558998,73.79113975455887,73.791139754558998,73.79113975455914]
[null,null,null,"impact of both ",1.2939839392405901,2.6084077938702506,3.9437597262146924,5.3005435682537652,6.6792794554374062,8.080504491516896,9.5047734461790778,10.952659487382805,12.424754950430172,13.921672145942921,13.921672145942921,13.921672145943056,13.921672145942921,13.921672145943056,13.921672145943056,13.921672145943056,13.921672145943056,13.921672145942921,13.921672145943056,13.921672145943191]

{"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.614983995754237},{"$f":"Rate_Impacts_With_v_Without!F32","v":32.430287828361067},{"$f":"Rate_Impacts_With_v_Without!G32","v":32.24265095372855},{"$f":"Rate_Impacts_With_v_Without!H32","v":32.052002575944606},{"$f":"Rate_Impacts_With_v_Without!I32","v":31.858269608216329},{"$f":"Rate_Impacts_With_v_Without!J32","v":31.661376579451105},{"$f":"Rate_Impacts_With_v_Without!K32","v":31.461245536228855},{"$f":"Rate_Impacts_With_v_Without!L32","v":31.257795939897729},{"$f":"Rate_Impacts_With_v_Without!M32","v":31.050944558507997},{"$f":"Rate_Impacts_With_v_Without!N32","v":30.840605353279475},{"$f":"Rate_Impacts_With_v_Without!O32","v":30.840605353279479},{"$f":"Rate_Impacts_With_v_Without!P32","v":30.840605353279482},{"$f":"Rate_Impacts_With_v_Without!Q32","v":30.840605353279475},{"$f":"Rate_Impacts_With_v_Without!R32","v":30.840605353279482},{"$f":"Rate_Impacts_With_v_Without!S32","v":30.840605353279482},{"$f":"Rate_Impacts_With_v_Without!T32","v":30.840605353279482},{"$f":"Rate_Impacts_With_v_Without!U32","v":30.840605353279482},{"$f":"Rate_Impacts_With_v_Without!V32","v":30.840605353279479},{"$f":"Rate_Impacts_With_v_Without!W32","v":30.840605353279482},{"$f":"Rate_Impacts_With_v_Without!X32","v":30.840605353279479}]
[null,"New fixed costs / net sales",null,"Energy Rate - fixed portion ($/MWh)",{"$f":"Rate_Impacts_With_v_Without!E33","v":65.891886077600105},{"$f":"Rate_Impacts_With_v_Without!F33","v":66.214852486288478},{"$f":"Rate_Impacts_With_v_Without!G33","v":66.542961122178937},{"$f":"Rate_Impacts_With_v_Without!H33","v":66.876335781567875},{"$f":"Rate_Impacts_With_v_Without!I33","v":67.215104266668845},{"$f":"Rate_Impacts_With_v_Without!J33","v":67.559398548968218},{"$f":"Rate_Impacts_With_v_Without!K33","v":67.9093549406401},{"$f":"Rate_Impacts_With_v_Without!L33","v":68.265114274488582},{"$f":"Rate_Impacts_With_v_Without!M33","v":68.626822092915887},{"$f":"Rate_Impacts_With_v_Without!N33","v":68.994628846449672},{"$f":"Rate_Impacts_With_v_Without!O33","v":68.994628846449672},{"$f":"Rate_Impacts_With_v_Without!P33","v":68.994628846449672},{"$f":"Rate_Impacts_With_v_Without!Q33","v":68.994628846449672},{"$f":"Rate_Impacts_With_v_Without!R33","v":68.994628846449672},{"$f":"Rate_Impacts_With_v_Without!S33","v":68.994628846449672},{"$f":"Rate_Impacts_With_v_Without!T33","v":68.994628846449672},{"$f":"Rate_Impacts_With_v_Without!U33","v":68.994628846449672},{"$f":"Rate_Impacts_With_v_Without!V33","v":68.994628846449672},{"$f":"Rate_Impacts_With_v_Without!W33","v":68.994628846449672},{"$f":"Rate_Impacts_With_v_Without!X33","v":68.994628846449686}]
[null,"Sum of above",null,"Total Energy Rate ($/MWh)",{"$f":"Rate_Impacts_With_v_Without!E34","v":98.506870073354349},{"$f":"Rate_Impacts_With_v_Without!F34","v":98.645140314649552},{"$f":"Rate_Impacts_With_v_Without!G34","v":98.785612075907494},{"$f":"Rate_Impacts_With_v_Without!H34","v":98.928338357512473},{"$f":"Rate_Impacts_With_v_Without!I34","v":99.073373874885178},{"$f":"Rate_Impacts_With_v_Without!J34","v":99.220775128419319},{"$f":"Rate_Impacts_With_v_Without!K34","v":99.370600476868958},{"$f":"Rate_Impacts_With_v_Without!L34","v":99.522910214386314},{"$f":"Rate_Impacts_With_v_Without!M34","v":99.67776665142388},{"$f":"Rate_Impacts_With_v_Without!N34","v":99.835234199729143},{"$f":"Rate_Impacts_With_v_Without!O34","v":99.835234199729143},{"$f":"Rate_Impacts_With_v_Without!P34","v":99.835234199729157},{"$f":"Rate_Impacts_With_v_Without!Q34","v":99.835234199729143},{"$f":"Rate_Impacts_With_v_Without!R34","v":99.835234199729157},{"$f":"Rate_Impacts_With_v_Without!S34","v":99.835234199729157},{"$f":"Rate_Impacts_With_v_Without!T34","v":99.835234199729157},{"$f":"Rate_Impacts_With_v_Without!U34","v":99.835234199729157},{"$f":"Rate_Impacts_With_v_Without!V34","v":99.835234199729143},{"$f":"Rate_Impacts_With_v_Without!W34","v":99.835234199729157},{"$f":"Rate_Impacts_With_v_Without!X34","v":99.835234199729172}]
[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.18469616739317019},{"$f":"G13-F13","v":-0.18763687463251699},-0.19064837778394406,-0.19373296772827686,{"$f":"J13-I13","v":-0.19689302876522419},-0.20013104322224962,-0.2034495963311258,-0.20685138138973258,-0.21033920522852156,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Energy Rate - fixed portion ($/MWh)","----",{"$f":"F14-E14","v":0.32296640868837301},0.3281086358904588,0.33337465938893729,0.33876848510097091,0.34429428229937287,0.34995639167188131,0.35575933384848213,0.36170781842730548,0.36780675353378456,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Total Energy Rate ($/MWh)","----",{"$f":"F15-E15","v":0.13827024129520282},{"$f":"G15-F15","v":0.14047176125794181},0.14272628160497902,0.1450355173727047,{"$f":"J15-I15","v":0.14740125353414157},0.1498253484496388,0.15230973751735633,0.1548564370375658,0.15746754830526299,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":-5.6629237474780103E-3},{"$f":"G13/F13-1","v":-5.7858528923824259E-3},{"$f":"H13/G13-1","v":-5.9129250277076828E-3},-6.0443327142896131E-3,-6.1802800712831285E-3,-6.3209836350621718E-3,-6.4666732948269745E-3,-6.6175933129598574E-3,-6.7740034391606807E-3,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Energy Rate - fixed portion (%)","----",{"$f":"F14/E14-1","v":4.901459465100455E-3},4.955212064519765E-3,{"$f":"H14/G14-1","v":5.0099162070174064E-3},5.0655957917231653E-3,5.1222755072046766E-3,5.1799808640722311E-3,5.2387382292093942E-3,5.2985748617209172E-3,5.3595189507069652E-3,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Total Energy Rate (%)","----",1.403660893826375E-3,1.4240109630325737E-3,{"$f":"H15/G15-1","v":1.4448083947216084E-3},1.4660664454766437E-3,1.4877988683446031E-3,1.5100199353987875E-3,1.5327444615051977E-3,1.5559878293749385E-3,1.5797660159855287E-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]