{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Inputs","Cost_Calculations","Rate_Calculations","Year_to_Year_Calcs","Reference","DataTable"],"not_rendered":{"charts":8,"images":1,"macros":1,"external_links":0,"defined_names":16,"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":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":false,"merged":[[24,6,27,11]]}
[]
[null,"High-Level NEM Rate Impact Analysis",null,"Rocky Mtn Power - Utah"]
[null,"Inputs"]
[]
[null,"Model Structure"]
[null,null,"Sector / Rate Class","Residential"]
[null,null,"Base Year",2015]
[null,null,"Real discount rate",5.5E-2]
[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":"D12/D14","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":"Reference!C18/Reference!C71*Reference!C70","v":98.370749999999987},null,"Annual weighted average, RMP Residential rate tariff "]
[null,null,"Customer ($/Month)",{"$f":"Reference!C7","v":6},null,"RMP Residential rate tariff "]
[null,null,"Minimum Bill ($/Month)",{"$f":"Reference!C21","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":"Reference!C57/(8760*Reference!C32)","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*D25*D24","v":7.3912922973599997},null,"Calculation based on CF and Capacity"]
[null,null,"Percent of customers adding DG PV per year",{"$f":"DataTable!C6","v":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)",0,null,"Capital cost of generation to meet peak load. "]
[null,null,"Avoided transmission capital costs ($/MWh)",0,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)",0,null,"Costs to comply with environemetnal regulations and policy objectives. Default from CPR 2014."]
[null,null,"Fuel price guarantee/avoided risk ($/MWh)",0,null,"Cost of eliminating uncertainty in fuel price fluctuations. Default $0.00"]
[]
[null,null,"Variable Avoided Costs ($/MWh)",{"$f":"DataTable!B6","v":60},null,"Includes avoided energy, avoided environmental, and fuel price guarantee"]
[null,null,"Fixed Avoided Costs ($/MWh)",null,null,"Includes avoided capital costs associated with generation and T&D capacity"]
[null,null,"Total Avoided Costs ($/MWh)",{"$f":"SUM(D37:D38)","v":60},null,"Sum of variable and fixed avoided costs"]
[null,"Levelized Utility Cost of Solar Integration"]
[null,null,"Integration Costs ($/MWh)",5,null,"Per MWh of DG solar generation"]

{"sheet":"Cost_Calculations","index":1,"n_rows":64,"n_cols":24,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[null,"Utah NEM Rate Impact Analysis","Cost Calculations"]
[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$14","v":733917},{"$f":"E4*(1+Inputs!$D$16)","v":741256.17},{"$f":"F4*(1+Inputs!$D$16)","v":748668.7317},{"$f":"G4*(1+Inputs!$D$16)","v":756155.41901700001},{"$f":"H4*(1+Inputs!$D$16)","v":763716.97320717003},{"$f":"I4*(1+Inputs!$D$16)","v":771354.14293924172},{"$f":"J4*(1+Inputs!$D$16)","v":779067.68436863413},{"$f":"K4*(1+Inputs!$D$16)","v":786858.36121232051},{"$f":"L4*(1+Inputs!$D$16)","v":794726.94482444366},{"$f":"M4*(1+Inputs!$D$16)","v":802674.21427268814},{"$f":"N4*(1+Inputs!$D$16)","v":810700.95641541504},{"$f":"O4*(1+Inputs!$D$16)","v":818807.96597956924},{"$f":"P4*(1+Inputs!$D$16)","v":826996.04563936498},{"$f":"Q4*(1+Inputs!$D$16)","v":835266.00609575864},{"$f":"R4*(1+Inputs!$D$16)","v":843618.66615671618},{"$f":"S4*(1+Inputs!$D$16)","v":852054.85281828337},{"$f":"T4*(1+Inputs!$D$16)","v":860575.40134646615},{"$f":"U4*(1+Inputs!$D$16)","v":869181.15535993082},{"$f":"V4*(1+Inputs!$D$16)","v":877872.96691353014},{"$f":"W4*(1+Inputs!$D$16)","v":886651.69658266543}]
[null,"Typical annual demand x demand growth rate",null,"Usage per customer (annual MWh / customer)",{"$f":"Inputs!$D$15","v":9.5061948421960523},{"$f":"E5*(1+Inputs!$D$17)","v":9.5061948421960523},{"$f":"F5*(1+Inputs!$D$17)","v":9.5061948421960523},{"$f":"G5*(1+Inputs!$D$17)","v":9.5061948421960523},{"$f":"H5*(1+Inputs!$D$17)","v":9.5061948421960523},{"$f":"I5*(1+Inputs!$D$17)","v":9.5061948421960523},{"$f":"J5*(1+Inputs!$D$17)","v":9.5061948421960523},{"$f":"K5*(1+Inputs!$D$17)","v":9.5061948421960523},{"$f":"L5*(1+Inputs!$D$17)","v":9.5061948421960523},{"$f":"M5*(1+Inputs!$D$17)","v":9.5061948421960523},{"$f":"N5*(1+Inputs!$D$17)","v":9.5061948421960523},{"$f":"O5*(1+Inputs!$D$17)","v":9.5061948421960523},{"$f":"P5*(1+Inputs!$D$17)","v":9.5061948421960523},{"$f":"Q5*(1+Inputs!$D$17)","v":9.5061948421960523},{"$f":"R5*(1+Inputs!$D$17)","v":9.5061948421960523},{"$f":"S5*(1+Inputs!$D$17)","v":9.5061948421960523},{"$f":"T5*(1+Inputs!$D$17)","v":9.5061948421960523},{"$f":"U5*(1+Inputs!$D$17)","v":9.5061948421960523},{"$f":"V5*(1+Inputs!$D$17)","v":9.5061948421960523},{"$f":"W5*(1+Inputs!$D$17)","v":9.5061948421960523}]
[null,null,null,"Total residential electricity usage (MWh)",{"$f":"E5*E4","v":6976758},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,"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},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$19*(1-Inputs!$D$22)","v":32.796808049999996},{"$f":"Inputs!$D$19*(1-Inputs!$D$22)","v":32.796808049999996},{"$f":"Inputs!$D$19*(1-Inputs!$D$22)","v":32.796808049999996},{"$f":"Inputs!$D$19*(1-Inputs!$D$22)","v":32.796808049999996},{"$f":"Inputs!$D$19*(1-Inputs!$D$22)","v":32.796808049999996},{"$f":"Inputs!$D$19*(1-Inputs!$D$22)","v":32.796808049999996},{"$f":"Inputs!$D$19*(1-Inputs!$D$22)","v":32.796808049999996},{"$f":"Inputs!$D$19*(1-Inputs!$D$22)","v":32.796808049999996},{"$f":"Inputs!$D$19*(1-Inputs!$D$22)","v":32.796808049999996},{"$f":"Inputs!$D$19*(1-Inputs!$D$22)","v":32.796808049999996},{"$f":"Inputs!$D$19*(1-Inputs!$D$22)","v":32.796808049999996},{"$f":"Inputs!$D$19*(1-Inputs!$D$22)","v":32.796808049999996},{"$f":"Inputs!$D$19*(1-Inputs!$D$22)","v":32.796808049999996},{"$f":"Inputs!$D$19*(1-Inputs!$D$22)","v":32.796808049999996},{"$f":"Inputs!$D$19*(1-Inputs!$D$22)","v":32.796808049999996},{"$f":"Inputs!$D$19*(1-Inputs!$D$22)","v":32.796808049999996},{"$f":"Inputs!$D$19*(1-Inputs!$D$22)","v":32.796808049999996},{"$f":"Inputs!$D$19*(1-Inputs!$D$22)","v":32.796808049999996},{"$f":"Inputs!$D$19*(1-Inputs!$D$22)","v":32.796808049999996},{"$f":"Inputs!$D$19*(1-Inputs!$D$22)","v":32.796808049999996}]
[null,"Energy rate times fixed portion",null,"Energy Rate - fixed portion ($/MWh)",{"$f":"Inputs!$D$19*(Inputs!$D$22)","v":65.573941949999991},{"$f":"Inputs!$D$19*(Inputs!$D$22)","v":65.573941949999991},{"$f":"Inputs!$D$19*(Inputs!$D$22)","v":65.573941949999991},{"$f":"Inputs!$D$19*(Inputs!$D$22)","v":65.573941949999991},{"$f":"Inputs!$D$19*(Inputs!$D$22)","v":65.573941949999991},{"$f":"Inputs!$D$19*(Inputs!$D$22)","v":65.573941949999991},{"$f":"Inputs!$D$19*(Inputs!$D$22)","v":65.573941949999991},{"$f":"Inputs!$D$19*(Inputs!$D$22)","v":65.573941949999991},{"$f":"Inputs!$D$19*(Inputs!$D$22)","v":65.573941949999991},{"$f":"Inputs!$D$19*(Inputs!$D$22)","v":65.573941949999991},{"$f":"Inputs!$D$19*(Inputs!$D$22)","v":65.573941949999991},{"$f":"Inputs!$D$19*(Inputs!$D$22)","v":65.573941949999991},{"$f":"Inputs!$D$19*(Inputs!$D$22)","v":65.573941949999991},{"$f":"Inputs!$D$19*(Inputs!$D$22)","v":65.573941949999991},{"$f":"Inputs!$D$19*(Inputs!$D$22)","v":65.573941949999991},{"$f":"Inputs!$D$19*(Inputs!$D$22)","v":65.573941949999991},{"$f":"Inputs!$D$19*(Inputs!$D$22)","v":65.573941949999991},{"$f":"Inputs!$D$19*(Inputs!$D$22)","v":65.573941949999991},{"$f":"Inputs!$D$19*(Inputs!$D$22)","v":65.573941949999991},{"$f":"Inputs!$D$19*(Inputs!$D$22)","v":65.573941949999991}]
[null,"Sum of above",null,"Total Energy Rate ($/MWh)",{"$f":"E12+E13","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,98.370749999999987]
[null,"Customer charge",null,"Customer ($/Month)",{"$f":"Reference!$C$7","v":6},{"$f":"Reference!$C$7","v":6},{"$f":"Reference!$C$7","v":6},{"$f":"Reference!$C$7","v":6},{"$f":"Reference!$C$7","v":6},{"$f":"Reference!$C$7","v":6},{"$f":"Reference!$C$7","v":6},{"$f":"Reference!$C$7","v":6},{"$f":"Reference!$C$7","v":6},{"$f":"Reference!$C$7","v":6},{"$f":"Reference!$C$7","v":6},{"$f":"Reference!$C$7","v":6},{"$f":"Reference!$C$7","v":6},{"$f":"Reference!$C$7","v":6},{"$f":"Reference!$C$7","v":6},{"$f":"Reference!$C$7","v":6},{"$f":"Reference!$C$7","v":6},{"$f":"Reference!$C$7","v":6},{"$f":"Reference!$C$7","v":6},{"$f":"Reference!$C$7","v":6}]
[null,"Minimum bill ",null,"Minimum bill ($)",{"$f":"Reference!$C$21","v":8},{"$f":"Reference!$C$21","v":8},{"$f":"Reference!$C$21","v":8},{"$f":"Reference!$C$21","v":8},{"$f":"Reference!$C$21","v":8},{"$f":"Reference!$C$21","v":8},{"$f":"Reference!$C$21","v":8},{"$f":"Reference!$C$21","v":8},{"$f":"Reference!$C$21","v":8},{"$f":"Reference!$C$21","v":8},{"$f":"Reference!$C$21","v":8},{"$f":"Reference!$C$21","v":8},{"$f":"Reference!$C$21","v":8},{"$f":"Reference!$C$21","v":8},{"$f":"Reference!$C$21","v":8},{"$f":"Reference!$C$21","v":8},{"$f":"Reference!$C$21","v":8},{"$f":"Reference!$C$21","v":8},{"$f":"Reference!$C$21","v":8},{"$f":"Reference!$C$21","v":8}]
[null,"Forecasted Revenues","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,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,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},693172006.19878495,700103726.26077282,707104763.52338052,714175811.1586144,721317569.27020037,728530744.96290255,735816052.41253161,743174212.93665683,750605955.06602335,758112014.61668372,765693134.76285052,773350066.11047912,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},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":"E20+E21","v":739150941.02849984},746542450.43878496,754007874.94317281,761547953.69260454,769163433.22953057,776855067.56182575,784623618.23744416,792469854.41981864,800394552.9640168,808398498.49365687,816482483.47859359,824647308.31337953,832893781.39651334,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},0.69043482158202474,0.69043482158202474,0.69043482158202474,0.69043482158202485,0.69043482158202485,0.69043482158202474,0.69043482158202474,0.69043482158202463,0.69043482158202485,0.69043482158202474,0.69043482158202474,0.69043482158202474,0.69043482158202485,0.69043482158202474,0.69043482158202474,0.69043482158202474,0.69043482158202474,0.69043482158202474,0.69043482158202485]
[]
[null,null,"With DG PV"]
[null,"Forecasted sales ","Annual Sales"]
[null,"% of customers with PV +  growth rate",null,"Customers with PV (%)",{"$f":"Inputs!D27","v":5.0000000000000001E-3},{"$f":"MIN(E27+Inputs!$D$27,Inputs!$D$27*Inputs!$D$28)","v":0.01},{"$f":"MIN(F27+Inputs!$D$27,Inputs!$D$27*Inputs!$D$28)","v":1.4999999999999999E-2},{"$f":"MIN(G27+Inputs!$D$27,Inputs!$D$27*Inputs!$D$28)","v":0.02},{"$f":"MIN(H27+Inputs!$D$27,Inputs!$D$27*Inputs!$D$28)","v":2.5000000000000001E-2},{"$f":"MIN(I27+Inputs!$D$27,Inputs!$D$27*Inputs!$D$28)","v":3.0000000000000002E-2},{"$f":"MIN(J27+Inputs!$D$27,Inputs!$D$27*Inputs!$D$28)","v":3.5000000000000003E-2},{"$f":"MIN(K27+Inputs!$D$27,Inputs!$D$27*Inputs!$D$28)","v":0.04},{"$f":"MIN(L27+Inputs!$D$27,Inputs!$D$27*Inputs!$D$28)","v":4.4999999999999998E-2},{"$f":"MIN(M27+Inputs!$D$27,Inputs!$D$27*Inputs!$D$28)","v":4.9999999999999996E-2},{"$f":"MIN(N27+Inputs!$D$27,Inputs!$D$27*Inputs!$D$28)","v":0.05},{"$f":"MIN(O27+Inputs!$D$27,Inputs!$D$27*Inputs!$D$28)","v":0.05},{"$f":"MIN(P27+Inputs!$D$27,Inputs!$D$27*Inputs!$D$28)","v":0.05},{"$f":"MIN(Q27+Inputs!$D$27,Inputs!$D$27*Inputs!$D$28)","v":0.05},{"$f":"MIN(R27+Inputs!$D$27,Inputs!$D$27*Inputs!$D$28)","v":0.05},{"$f":"MIN(S27+Inputs!$D$27,Inputs!$D$27*Inputs!$D$28)","v":0.05},{"$f":"MIN(T27+Inputs!$D$27,Inputs!$D$27*Inputs!$D$28)","v":0.05},{"$f":"MIN(U27+Inputs!$D$27,Inputs!$D$27*Inputs!$D$28)","v":0.05},{"$f":"MIN(V27+Inputs!$D$27,Inputs!$D$27*Inputs!$D$28)","v":0.05},{"$f":"MIN(W27+Inputs!$D$27,Inputs!$D$27*Inputs!$D$28)","v":0.05}]
[null,"Customers x % with DGPV * typical DGPV gen",null,"Annual Customer PV Gen (MWh)",{"$f":"E4*E27*Inputs!$D$26","v":27122.975345007795},{"$f":"F4*F27*Inputs!$D$26","v":54788.410196915749},{"$f":"G4*G27*Inputs!$D$26","v":83004.441448327358},{"$f":"H4*H27*Inputs!$D$26","v":111779.3144837475},{"$f":"I4*I27*Inputs!$D$26","v":141121.38453573122},{"$f":"J4*J27*Inputs!$D$26","v":171039.11805730624},{"$f":"K4*K27*Inputs!$D$26","v":201541.09411085921},{"$f":"L4*L27*Inputs!$D$26","v":232636.00577367749},{"$f":"M4*M27*Inputs!$D$26","v":264332.66156034102},{"$f":"N4*N27*Inputs!$D$26","v":296639.9868621605},{"$f":"O4*O27*Inputs!$D$26","v":299606.38673078211},{"$f":"P4*P27*Inputs!$D$26","v":302602.45059808996},{"$f":"Q4*Q27*Inputs!$D$26","v":305628.47510407085},{"$f":"R4*R27*Inputs!$D$26","v":308684.7598551116},{"$f":"S4*S27*Inputs!$D$26","v":311771.60745366267},{"$f":"T4*T27*Inputs!$D$26","v":314889.32352819934},{"$f":"U4*U27*Inputs!$D$26","v":318038.21676348132},{"$f":"V4*V27*Inputs!$D$26","v":321218.59893111611},{"$f":"W4*W27*Inputs!$D$26","v":324430.78492042731},{"$f":"X4*X27*Inputs!$D$26","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$24","v":18.347925},{"$f":"F27*F4*Inputs!$D$24","v":37.062808500000003},{"$f":"G27*G4*Inputs!$D$24","v":56.1501548775},{"$f":"H27*H4*Inputs!$D$24","v":75.615541901699999},{"$f":"I27*I4*Inputs!$D$24","v":95.464621650896262},{"$f":"J27*J4*Inputs!$D$24","v":115.70312144088626},{"$f":"K27*K4*Inputs!$D$24","v":136.336844764511},{"$f":"L27*L4*Inputs!$D$24","v":157.37167224246411},{"$f":"M27*M4*Inputs!$D$24","v":178.81356258549982},{"$f":"N27*N4*Inputs!$D$24","v":200.66855356817203},{"$f":"O27*O4*Inputs!$D$24","v":202.67523910385378},{"$f":"P27*P4*Inputs!$D$24","v":204.70199149489233},{"$f":"Q27*Q4*Inputs!$D$24","v":206.74901140984127},{"$f":"R27*R4*Inputs!$D$24","v":208.81650152393968},{"$f":"S27*S4*Inputs!$D$24","v":210.90466653917906},{"$f":"T27*T4*Inputs!$D$24","v":213.01371320457085},{"$f":"U27*U4*Inputs!$D$24","v":215.14385033661657},{"$f":"V27*V4*Inputs!$D$24","v":217.29528883998273},{"$f":"W27*W4*Inputs!$D$24","v":219.46824172838257},{"$f":"X27*X4*Inputs!$D$24","v":221.66292414566638}]
[null,null,"Rates"]
[null,"New variable costs / net sales",null,"Energy Rate - variable portion ($/MWh)",{"$f":"E41/E29","v":32.710153624882153},32.622820161340321,32.534799646392663,32.446083940483433,32.35666477497373,32.266533749572567,32.17568232970612,32.084101843823802,31.991783480639118,31.898718286303634,31.898718286303641,31.898718286303641,31.898718286303641,31.898718286303637,31.898718286303641,31.898718286303641,31.898718286303641,31.898718286303644,31.898718286303644,31.898718286303634]
[null,"New fixed costs / net sales",null,"Energy Rate - fixed portion ($/MWh)",{"$f":"E42/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.54001698722611},98.710610378592406,98.882545826309212,99.055839229831008,99.230506740757477,99.406564767851989,99.584029982179999,99.762919322371502,99.94325000001048,100.12503950515529,100.12503950515529,100.12503950515529,100.12503950515529,100.12503950515527,100.12503950515529,100.12503950515529,100.12503950515529,100.1250395051553,100.1250395051553,100.12503950515529]
[null,"Same as No DG PV",null,"Customer ($/Month)",{"$f":"Inputs!$D$20","v":6},{"$f":"Inputs!$D$20","v":6},{"$f":"Inputs!$D$20","v":6},{"$f":"Inputs!$D$20","v":6},{"$f":"Inputs!$D$20","v":6},{"$f":"Inputs!$D$20","v":6},{"$f":"Inputs!$D$20","v":6},{"$f":"Inputs!$D$20","v":6},{"$f":"Inputs!$D$20","v":6},{"$f":"Inputs!$D$20","v":6},{"$f":"Inputs!$D$20","v":6},{"$f":"Inputs!$D$20","v":6},{"$f":"Inputs!$D$20","v":6},{"$f":"Inputs!$D$20","v":6},{"$f":"Inputs!$D$20","v":6},{"$f":"Inputs!$D$20","v":6},{"$f":"Inputs!$D$20","v":6},{"$f":"Inputs!$D$20","v":6},{"$f":"Inputs!$D$20","v":6},{"$f":"Inputs!$D$20","v":6}]
[null,"Same as No DG PV",null,"Minimum bill ($)",{"$f":"Inputs!$D$21","v":8},{"$f":"Inputs!$D$21","v":8},{"$f":"Inputs!$D$21","v":8},{"$f":"Inputs!$D$21","v":8},{"$f":"Inputs!$D$21","v":8},{"$f":"Inputs!$D$21","v":8},{"$f":"Inputs!$D$21","v":8},{"$f":"Inputs!$D$21","v":8},{"$f":"Inputs!$D$21","v":8},{"$f":"Inputs!$D$21","v":8},{"$f":"Inputs!$D$21","v":8},{"$f":"Inputs!$D$21","v":8},{"$f":"Inputs!$D$21","v":8},{"$f":"Inputs!$D$21","v":8},{"$f":"Inputs!$D$21","v":8},{"$f":"Inputs!$D$21","v":8},{"$f":"Inputs!$D$21","v":8},{"$f":"Inputs!$D$21","v":8},{"$f":"Inputs!$D$21","v":8},{"$f":"Inputs!$D$21","v":8}]
[null,"Forecasted Revenues / Costs","Annual Revenues and Costs"]
[null,"Costs avoided",null,"Avoided costs - variable",{"$f":"(Inputs!$D$37)*E$28","v":1627378.5207004678},{"$f":"(Inputs!$D$37)*F$28","v":3287304.611814945},{"$f":"(Inputs!$D$37)*G$28","v":4980266.4868996413},{"$f":"(Inputs!$D$37)*H$28","v":6706758.8690248495},{"$f":"(Inputs!$D$37)*I$28","v":8467283.0721438732},{"$f":"(Inputs!$D$37)*J$28","v":10262347.083438374},{"$f":"(Inputs!$D$37)*K$28","v":12092465.646651553},{"$f":"(Inputs!$D$37)*L$28","v":13958160.346420649},{"$f":"(Inputs!$D$37)*M$28","v":15859959.693620462},{"$f":"(Inputs!$D$37)*N$28","v":17798399.211729631},{"$f":"(Inputs!$D$37)*O$28","v":17976383.203846928},{"$f":"(Inputs!$D$37)*P$28","v":18156147.035885397},{"$f":"(Inputs!$D$37)*Q$28","v":18337708.50624425},{"$f":"(Inputs!$D$37)*R$28","v":18521085.591306694},{"$f":"(Inputs!$D$37)*S$28","v":18706296.447219759},{"$f":"(Inputs!$D$37)*T$28","v":18893359.41169196},{"$f":"(Inputs!$D$37)*U$28","v":19082293.005808879},{"$f":"(Inputs!$D$37)*V$28","v":19273115.935866967},{"$f":"(Inputs!$D$37)*W$28","v":19465847.09522564},{"$f":"(Inputs!$D$37)*X$28","v":19660505.566177893}]
[null,"Costs avoided",null,"Avoided costs - fixed",{"$f":"(Inputs!$D$38)*E$28","v":0},{"$f":"(Inputs!$D$38)*F$28","v":0},{"$f":"(Inputs!$D$38)*G$28","v":0},{"$f":"(Inputs!$D$38)*H$28","v":0},{"$f":"(Inputs!$D$38)*I$28","v":0},{"$f":"(Inputs!$D$38)*J$28","v":0},{"$f":"(Inputs!$D$38)*K$28","v":0},{"$f":"(Inputs!$D$38)*L$28","v":0},{"$f":"(Inputs!$D$38)*M$28","v":0},{"$f":"(Inputs!$D$38)*N$28","v":0},{"$f":"(Inputs!$D$38)*O$28","v":0},{"$f":"(Inputs!$D$38)*P$28","v":0},{"$f":"(Inputs!$D$38)*Q$28","v":0},{"$f":"(Inputs!$D$38)*R$28","v":0},{"$f":"(Inputs!$D$38)*S$28","v":0},{"$f":"(Inputs!$D$38)*T$28","v":0},{"$f":"(Inputs!$D$38)*U$28","v":0},{"$f":"(Inputs!$D$38)*V$28","v":0},{"$f":"(Inputs!$D$38)*W$28","v":0},{"$f":"(Inputs!$D$38)*X$28","v":0}]
[null,null,null,"Utility Solar Integration Costs",{"$f":"Inputs!$D$41*Cost_Calculations!E28","v":135614.87672503898},{"$f":"Inputs!$D$41*Cost_Calculations!F28","v":273942.05098457873},{"$f":"Inputs!$D$41*Cost_Calculations!G28","v":415022.20724163682},{"$f":"Inputs!$D$41*Cost_Calculations!H28","v":558896.57241873746},{"$f":"Inputs!$D$41*Cost_Calculations!I28","v":705606.92267865618},{"$f":"Inputs!$D$41*Cost_Calculations!J28","v":855195.59028653125},{"$f":"Inputs!$D$41*Cost_Calculations!K28","v":1007705.470554296},{"$f":"Inputs!$D$41*Cost_Calculations!L28","v":1163180.0288683875},{"$f":"Inputs!$D$41*Cost_Calculations!M28","v":1321663.3078017051},{"$f":"Inputs!$D$41*Cost_Calculations!N28","v":1483199.9343108025},{"$f":"Inputs!$D$41*Cost_Calculations!O28","v":1498031.9336539106},{"$f":"Inputs!$D$41*Cost_Calculations!P28","v":1513012.2529904498},{"$f":"Inputs!$D$41*Cost_Calculations!Q28","v":1528142.3755203541},{"$f":"Inputs!$D$41*Cost_Calculations!R28","v":1543423.799275558},{"$f":"Inputs!$D$41*Cost_Calculations!S28","v":1558858.0372683133},{"$f":"Inputs!$D$41*Cost_Calculations!T28","v":1574446.6176409968},{"$f":"Inputs!$D$41*Cost_Calculations!U28","v":1590191.0838174066},{"$f":"Inputs!$D$41*Cost_Calculations!V28","v":1606092.9946555805},{"$f":"Inputs!$D$41*Cost_Calculations!W28","v":1622153.9246021365},{"$f":"Inputs!$D$41*Cost_Calculations!X28","v":1638375.4638481578}]
[null,"No DG PV less avoided fixed costs",null,"Variable Revenues and Costs",{"$f":"E18-E38+E40","v":227323629.29332647},{"$f":"F18-F38+F40","v":228090184.30584455},{"$f":"G18-G38+G40","v":228849338.05568364},229600865.86208895,230344539.29081678,231080126.10153297,231807390.19453442,232526091.55678576,233235986.20726261,233936826.14159334,236276194.40300933,238638956.34703943,241025345.91050982,243435599.36961493,245869955.36331108,248328654.91694421,250811941.4661136,253320060.88077477,255853261.48958254,258411794.10447827]
[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":"E41+E42","v":684817153.38452446},690158643.63795459,695538481.98111475,700956901.22677433,706414135.00914907,711910417.77704859,717445984.78680515,723021072.09497929,728635916.55083799,734290755.7886045,741633663.34649062,749049999.97995555,756540499.97975516,764105904.97955275,771746964.02934825,779464433.66964173,787259078.00633812,795131668.78640151,803082985.47426558,811113815.3290081]
[null,"Same as No DG PV",null,"Customer Charge Revenues and Costs",{"$f":"E21","v":52842024},{"$f":"F21","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,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":"E43+E44","v":737659177.38452446},{"$f":"F43+F44","v":743529087.8779546},749442630.66351473,755400091.39599836,761401757.08006525,767447916.06867397,773538858.06134677,779674874.10226631,785856256.57819796,792083299.21623802,800004132.20840049,808004173.53048456,816084215.26578939,824245057.41844738,832487507.99263179,840812383.07255816,849220506.90328372,857712711.9723165,866289839.0920397,874952737.48295999]
[null,null,null,"Percent of total costs that are \"fixed\"",{"$f":"(E42+E44)/E45","v":0.69183108370001623},{"$f":"(F42+F44)/F45","v":0.69323300456634718},0.69464061865139271,{"$f":"(H42+H44)/H45","v":0.69605396070606673},0.69747306576468171,0.69889796914784363,0.70032870646538292,0.70176531361931982,0.70320782680686833,0.70465628252347656,0.70465628252347634,0.70465628252347634,0.70465628252347634,0.70465628252347634,0.70465628252347634,0.70465628252347645,0.70465628252347623,0.70465628252347634,0.70465628252347634,0.70465628252347645]
[]
[null,null,"Compare Without Versus With PV"]
[null,null,null,"Annual Benefits",{"$f":"E39+E38","v":1627378.5207004678},{"$f":"F39+F38","v":3287304.611814945},4980266.4868996413,6706758.8690248495,8467283.0721438732,10262347.083438374,12092465.646651553,13958160.346420649,15859959.693620462,17798399.211729631,17976383.203846928,18156147.035885397,18337708.50624425,18521085.591306694,18706296.447219759,18893359.41169196,19082293.005808879,19273115.935866967,19465847.09522564,19660505.566177893]
[null,null,null,"Annual Costs",{"$f":"E40","v":135614.87672503898},{"$f":"F40","v":273942.05098457873},415022.20724163682,558896.57241873746,705606.92267865618,855195.59028653125,1007705.470554296,1163180.0288683875,1321663.3078017051,1483199.9343108025,1498031.9336539106,1513012.2529904498,1528142.3755203541,1543423.799275558,1558858.0372683133,1574446.6176409968,1590191.0838174066,1606092.9946555805,1622153.9246021365,1638375.4638481578]
[null,null,null,"Annual Net Benefits (Costs)",{"$f":"E49-E50","v":1491763.6439754288},{"$f":"F49-F50","v":3013362.5608303663},4565244.2796580046,6147862.2966061123,7761676.1494652173,9407151.4931518435,11084760.176097257,12794980.317552261,14538296.385818757,16315199.277418828,16478351.270193018,16643134.782894947,16809566.130723894,16977661.792031135,17147438.409951445,17318912.794050962,17492101.921991471,17667022.941211388,17843693.170623504,18022130.102329735]
[]
[null,null,null,"Cumulative PV of Benefits",{"$f":"$E$49","v":1627378.5207004678},{"$f":"$E$49+NPV(Inputs!$D$8,Cost_Calculations!$F49:F$49)","v":4743307.0627051555},{"$f":"$E$49+NPV(Inputs!$D$8,Cost_Calculations!$F49:G$49)","v":9217839.5187592804},{"$f":"$E$49+NPV(Inputs!$D$8,Cost_Calculations!$F49:H$49)","v":14929407.014006881},{"$f":"$E$49+NPV(Inputs!$D$8,Cost_Calculations!$F49:I$49)","v":21764339.680120721},{"$f":"$E$49+NPV(Inputs!$D$8,Cost_Calculations!$F49:J$49)","v":29616413.984698892},{"$f":"$E$49+NPV(Inputs!$D$8,Cost_Calculations!$F49:K$49)","v":38386424.30592601},{"$f":"$E$49+NPV(Inputs!$D$8,Cost_Calculations!$F49:L$49)","v":47981777.507756092},{"$f":"$E$49+NPV(Inputs!$D$8,Cost_Calculations!$F49:M$49)","v":58316109.332949869},{"$f":"$E$49+NPV(Inputs!$D$8,Cost_Calculations!$F49:N$49)","v":69308921.490343973},{"$f":"$E$49+NPV(Inputs!$D$8,Cost_Calculations!$F49:O$49)","v":79832845.92538479},{"$f":"$E$49+NPV(Inputs!$D$8,Cost_Calculations!$F49:P$49)","v":89907882.588314846},{"$f":"$E$49+NPV(Inputs!$D$8,Cost_Calculations!$F49:Q$49)","v":99553178.350930363},{"$f":"$E$49+NPV(Inputs!$D$8,Cost_Calculations!$F49:R$49)","v":108787063.39381346},{"$f":"$E$49+NPV(Inputs!$D$8,Cost_Calculations!$F49:S$49)","v":117627086.04150249},{"$f":"$E$49+NPV(Inputs!$D$8,Cost_Calculations!$F49:T$49)","v":126090046.11180195},{"$f":"$E$49+NPV(Inputs!$D$8,Cost_Calculations!$F49:U$49)","v":134192026.84260996},{"$f":"$E$49+NPV(Inputs!$D$8,Cost_Calculations!$F49:V$49)","v":141948425.456938},{"$f":"$E$49+NPV(Inputs!$D$8,Cost_Calculations!$F49:W$49)","v":149373982.42420939},{"$f":"$E$49+NPV(Inputs!$D$8,Cost_Calculations!$F49:X$49)","v":156482809.4734455}]
[null,null,null,"Cumulative PV of Costs",{"$f":"$E$50","v":135614.87672503898},{"$f":"$E$50+NPV(Inputs!$D$8,Cost_Calculations!$F50:F$50)","v":395275.58855876292},{"$f":"$E$50+NPV(Inputs!$D$8,Cost_Calculations!$F50:G$50)","v":768153.29322994},{"$f":"$E$50+NPV(Inputs!$D$8,Cost_Calculations!$F50:H$50)","v":1244117.2511672401},{"$f":"$E$50+NPV(Inputs!$D$8,Cost_Calculations!$F50:I$50)","v":1813694.9733433935},{"$f":"$E$50+NPV(Inputs!$D$8,Cost_Calculations!$F50:J$50)","v":2468034.4987249081},{"$f":"$E$50+NPV(Inputs!$D$8,Cost_Calculations!$F50:K$50)","v":3198868.6921605016},{"$f":"$E$50+NPV(Inputs!$D$8,Cost_Calculations!$F50:L$50)","v":3998481.4589796746},{"$f":"$E$50+NPV(Inputs!$D$8,Cost_Calculations!$F50:M$50)","v":4859675.7777458224},{"$f":"$E$50+NPV(Inputs!$D$8,Cost_Calculations!$F50:N$50)","v":5775743.4575286657},{"$f":"$E$50+NPV(Inputs!$D$8,Cost_Calculations!$F50:O$50)","v":6652737.1604487337},{"$f":"$E$50+NPV(Inputs!$D$8,Cost_Calculations!$F50:P$50)","v":7492323.5490262397},{"$f":"$E$50+NPV(Inputs!$D$8,Cost_Calculations!$F50:Q$50)","v":8296098.1959108654},{"$f":"$E$50+NPV(Inputs!$D$8,Cost_Calculations!$F50:R$50)","v":9065588.6161511242},{"$f":"$E$50+NPV(Inputs!$D$8,Cost_Calculations!$F50:S$50)","v":9802257.1701252107},{"$f":"$E$50+NPV(Inputs!$D$8,Cost_Calculations!$F50:T$50)","v":10507503.842650166},{"$f":"$E$50+NPV(Inputs!$D$8,Cost_Calculations!$F50:U$50)","v":11182668.903550832},{"$f":"$E$50+NPV(Inputs!$D$8,Cost_Calculations!$F50:V$50)","v":11829035.454744836},{"$f":"$E$50+NPV(Inputs!$D$8,Cost_Calculations!$F50:W$50)","v":12447831.86868412},{"$f":"$E$50+NPV(Inputs!$D$8,Cost_Calculations!$F50:X$50)","v":13040234.122787131}]
[null,null,null,"Cumulative PV of Net Benefits",{"$f":"$E$51","v":1491763.6439754288},{"$f":"$E$51+NPV(Inputs!$D$8,Cost_Calculations!$F$51:F51)","v":4348031.4741463922},{"$f":"$E$51+NPV(Inputs!$D$8,Cost_Calculations!$F$51:G51)","v":8449686.225529341},{"$f":"$E$51+NPV(Inputs!$D$8,Cost_Calculations!$F$51:H51)","v":13685289.762839643},{"$f":"$E$51+NPV(Inputs!$D$8,Cost_Calculations!$F$51:I51)","v":19950644.706777327},{"$f":"$E$51+NPV(Inputs!$D$8,Cost_Calculations!$F$51:J51)","v":27148379.485973988},{"$f":"$E$51+NPV(Inputs!$D$8,Cost_Calculations!$F$51:K51)","v":35187555.613765508},{"$f":"$E$51+NPV(Inputs!$D$8,Cost_Calculations!$F$51:L51)","v":43983296.048776418},{"$f":"$E$51+NPV(Inputs!$D$8,Cost_Calculations!$F$51:M51)","v":53456433.555204049},{"$f":"$E$51+NPV(Inputs!$D$8,Cost_Calculations!$F$51:N51)","v":63533178.032815322},{"$f":"$E$51+NPV(Inputs!$D$8,Cost_Calculations!$F$51:O51)","v":73180108.76493606},{"$f":"$E$51+NPV(Inputs!$D$8,Cost_Calculations!$F$51:P51)","v":82415559.039288625},{"$f":"$E$51+NPV(Inputs!$D$8,Cost_Calculations!$F$51:Q51)","v":91257080.155019507},{"$f":"$E$51+NPV(Inputs!$D$8,Cost_Calculations!$F$51:R51)","v":99721474.777662337},{"$f":"$E$51+NPV(Inputs!$D$8,Cost_Calculations!$F$51:S51)","v":107824828.87137727},{"$f":"$E$51+NPV(Inputs!$D$8,Cost_Calculations!$F$51:T51)","v":115582542.26915178},{"$f":"$E$51+NPV(Inputs!$D$8,Cost_Calculations!$F$51:U51)","v":123009357.93905911},{"$f":"$E$51+NPV(Inputs!$D$8,Cost_Calculations!$F$51:V51)","v":130119390.00219317},{"$f":"$E$51+NPV(Inputs!$D$8,Cost_Calculations!$F$51:W51)","v":136926150.55552527},{"$f":"$E$51+NPV(Inputs!$D$8,Cost_Calculations!$F$51:X51)","v":143442575.35065842}]
[]
[null,null,null,"NPV of Benefits",{"$f":"E49+NPV(Inputs!$D$8,F49:X49)","v":156482809.4734455}]
[null,null,null,"NPV of Costs",{"$f":"E50+NPV(Inputs!$D$8,F50:X50)","v":13040234.122787131}]
[null,null,null,"NPV of Net Benefits (costs)",{"$f":"E51+NPV(Inputs!$D$8,F51:X51)","v":143442575.35065842}]
[null,null,null,"BCR",{"$f":"E57/E58","v":11.999999999999995}]
[null,null,null,"PVRR With PV",{"$f":"E45+NPV(Inputs!$D$8,F45:X45)","v":9938655708.0692348}]
[null,null,null,"PVRR Without PV",{"$f":"E22+NPV(Inputs!$D$8,F22:X22)","v":10082098283.419893}]
[null,null,null,"NPV of Costs",{"$f":"E62-E61","v":143442575.35065842}]
[null,null,null,"Reduction of Total Costs",{"$f":"E63/E62","v":1.4227452591545462E-2}]

{"sheet":"Rate_Calculations","index":2,"n_rows":33,"n_cols":25,"rows_kept":33,"cut":false,"hidden":false,"merged":[[18,4,18,5]]}
[]
[null,null,"Rate Calculations"]
[null,null,"Differences",null,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034]
[null,null,"Rates"]
[null,null,null,"Change in Energy Rate - variable portion ($/MWh)",{"$f":"Cost_Calculations!E32-Cost_Calculations!E12","v":-8.6654425117842493E-2},{"$f":"Cost_Calculations!F32-Cost_Calculations!F12","v":-0.17398788865967418},{"$f":"Cost_Calculations!G32-Cost_Calculations!G12","v":-0.26200840360733224},{"$f":"Cost_Calculations!H32-Cost_Calculations!H12","v":-0.35072410951656252},{"$f":"Cost_Calculations!I32-Cost_Calculations!I12","v":-0.44014327502626571},{"$f":"Cost_Calculations!J32-Cost_Calculations!J12","v":-0.53027430042742907},{"$f":"Cost_Calculations!K32-Cost_Calculations!K12","v":-0.62112572029387536},{"$f":"Cost_Calculations!L32-Cost_Calculations!L12","v":-0.71270620617619329},{"$f":"Cost_Calculations!M32-Cost_Calculations!M12","v":-0.80502456936087796},{"$f":"Cost_Calculations!N32-Cost_Calculations!N12","v":-0.89808976369636184},{"$f":"Cost_Calculations!O32-Cost_Calculations!O12","v":-0.89808976369635474},{"$f":"Cost_Calculations!P32-Cost_Calculations!P12","v":-0.89808976369635474},{"$f":"Cost_Calculations!Q32-Cost_Calculations!Q12","v":-0.89808976369635474},{"$f":"Cost_Calculations!R32-Cost_Calculations!R12","v":-0.89808976369635829},{"$f":"Cost_Calculations!S32-Cost_Calculations!S12","v":-0.89808976369635474},{"$f":"Cost_Calculations!T32-Cost_Calculations!T12","v":-0.89808976369635474},{"$f":"Cost_Calculations!U32-Cost_Calculations!U12","v":-0.89808976369635474},{"$f":"Cost_Calculations!V32-Cost_Calculations!V12","v":-0.89808976369635118},{"$f":"Cost_Calculations!W32-Cost_Calculations!W12","v":-0.89808976369635118},{"$f":"Cost_Calculations!X32-Cost_Calculations!X12","v":-0.89808976369636184}]
[null,null,null,"Change in Energy Rate - fixed portion ($/MWh)",{"$f":"Cost_Calculations!E33-Cost_Calculations!E13","v":0.25592141234396593},{"$f":"Cost_Calculations!F33-Cost_Calculations!F13","v":0.51384826725210075},{"$f":"Cost_Calculations!G33-Cost_Calculations!G13","v":0.77380422991654996},{"$f":"Cost_Calculations!H33-Cost_Calculations!H13","v":1.0358133393475839},{"$f":"Cost_Calculations!I33-Cost_Calculations!I13","v":1.2999000157837628},{"$f":"Cost_Calculations!J33-Cost_Calculations!J13","v":1.5660890682794388},{"$f":"Cost_Calculations!K33-Cost_Calculations!K13","v":1.8344057024738873},{"$f":"Cost_Calculations!L33-Cost_Calculations!L13","v":2.1048755285477085},{"$f":"Cost_Calculations!M33-Cost_Calculations!M13","v":2.3775245693713742},{"$f":"Cost_Calculations!N33-Cost_Calculations!N13","v":2.6523792688516608},{"$f":"Cost_Calculations!O33-Cost_Calculations!O13","v":2.6523792688516608},{"$f":"Cost_Calculations!P33-Cost_Calculations!P13","v":2.6523792688516608},{"$f":"Cost_Calculations!Q33-Cost_Calculations!Q13","v":2.6523792688516608},{"$f":"Cost_Calculations!R33-Cost_Calculations!R13","v":2.6523792688516465},{"$f":"Cost_Calculations!S33-Cost_Calculations!S13","v":2.6523792688516608},{"$f":"Cost_Calculations!T33-Cost_Calculations!T13","v":2.6523792688516608},{"$f":"Cost_Calculations!U33-Cost_Calculations!U13","v":2.6523792688516608},{"$f":"Cost_Calculations!V33-Cost_Calculations!V13","v":2.6523792688516608},{"$f":"Cost_Calculations!W33-Cost_Calculations!W13","v":2.6523792688516608},{"$f":"Cost_Calculations!X33-Cost_Calculations!X13","v":2.6523792688516608}]
[null,null,null,"Change in Total Energy Rate ($/MWh)",{"$f":"Cost_Calculations!E34-Cost_Calculations!E14","v":0.16926698722612343},{"$f":"Cost_Calculations!F34-Cost_Calculations!F14","v":0.33986037859241947},{"$f":"Cost_Calculations!G34-Cost_Calculations!G14","v":0.51179582630922482},{"$f":"Cost_Calculations!H34-Cost_Calculations!H14","v":0.68508922983102138},{"$f":"Cost_Calculations!I34-Cost_Calculations!I14","v":0.85975674075748998},{"$f":"Cost_Calculations!J34-Cost_Calculations!J14","v":1.0358147678520027},{"$f":"Cost_Calculations!K34-Cost_Calculations!K14","v":1.213279982180012},{"$f":"Cost_Calculations!L34-Cost_Calculations!L14","v":1.3921693223715152},{"$f":"Cost_Calculations!M34-Cost_Calculations!M14","v":1.5725000000104927},{"$f":"Cost_Calculations!N34-Cost_Calculations!N14","v":1.7542895051552989},{"$f":"Cost_Calculations!O34-Cost_Calculations!O14","v":1.7542895051552989},{"$f":"Cost_Calculations!P34-Cost_Calculations!P14","v":1.7542895051552989},{"$f":"Cost_Calculations!Q34-Cost_Calculations!Q14","v":1.7542895051552989},{"$f":"Cost_Calculations!R34-Cost_Calculations!R14","v":1.7542895051552847},{"$f":"Cost_Calculations!S34-Cost_Calculations!S14","v":1.7542895051552989},{"$f":"Cost_Calculations!T34-Cost_Calculations!T14","v":1.7542895051552989},{"$f":"Cost_Calculations!U34-Cost_Calculations!U14","v":1.7542895051552989},{"$f":"Cost_Calculations!V34-Cost_Calculations!V14","v":1.7542895051553131},{"$f":"Cost_Calculations!W34-Cost_Calculations!W14","v":1.7542895051553131},{"$f":"Cost_Calculations!X34-Cost_Calculations!X14","v":1.7542895051552989},"`"]
[null,null,null,"Change in Customer ($/Month)",{"$f":"Cost_Calculations!E35-Cost_Calculations!E15","v":0},{"$f":"Cost_Calculations!F35-Cost_Calculations!F15","v":0},{"$f":"Cost_Calculations!G35-Cost_Calculations!G15","v":0},{"$f":"Cost_Calculations!H35-Cost_Calculations!H15","v":0},{"$f":"Cost_Calculations!I35-Cost_Calculations!I15","v":0},{"$f":"Cost_Calculations!J35-Cost_Calculations!J15","v":0},{"$f":"Cost_Calculations!K35-Cost_Calculations!K15","v":0},{"$f":"Cost_Calculations!L35-Cost_Calculations!L15","v":0},{"$f":"Cost_Calculations!M35-Cost_Calculations!M15","v":0},{"$f":"Cost_Calculations!N35-Cost_Calculations!N15","v":0},{"$f":"Cost_Calculations!O35-Cost_Calculations!O15","v":0},{"$f":"Cost_Calculations!P35-Cost_Calculations!P15","v":0},{"$f":"Cost_Calculations!Q35-Cost_Calculations!Q15","v":0},{"$f":"Cost_Calculations!R35-Cost_Calculations!R15","v":0},{"$f":"Cost_Calculations!S35-Cost_Calculations!S15","v":0},{"$f":"Cost_Calculations!T35-Cost_Calculations!T15","v":0},{"$f":"Cost_Calculations!U35-Cost_Calculations!U15","v":0},{"$f":"Cost_Calculations!V35-Cost_Calculations!V15","v":0},{"$f":"Cost_Calculations!W35-Cost_Calculations!W15","v":0},{"$f":"Cost_Calculations!X35-Cost_Calculations!X15","v":0}]
[null,null,null,"Change in Minimum bill ($)",{"$f":"Cost_Calculations!E36-Cost_Calculations!E16","v":0},{"$f":"Cost_Calculations!F36-Cost_Calculations!F16","v":0},{"$f":"Cost_Calculations!G36-Cost_Calculations!G16","v":0},{"$f":"Cost_Calculations!H36-Cost_Calculations!H16","v":0},{"$f":"Cost_Calculations!I36-Cost_Calculations!I16","v":0},{"$f":"Cost_Calculations!J36-Cost_Calculations!J16","v":0},{"$f":"Cost_Calculations!K36-Cost_Calculations!K16","v":0},{"$f":"Cost_Calculations!L36-Cost_Calculations!L16","v":0},{"$f":"Cost_Calculations!M36-Cost_Calculations!M16","v":0},{"$f":"Cost_Calculations!N36-Cost_Calculations!N16","v":0},{"$f":"Cost_Calculations!O36-Cost_Calculations!O16","v":0},{"$f":"Cost_Calculations!P36-Cost_Calculations!P16","v":0},{"$f":"Cost_Calculations!Q36-Cost_Calculations!Q16","v":0},{"$f":"Cost_Calculations!R36-Cost_Calculations!R16","v":0},{"$f":"Cost_Calculations!S36-Cost_Calculations!S16","v":0},{"$f":"Cost_Calculations!T36-Cost_Calculations!T16","v":0},{"$f":"Cost_Calculations!U36-Cost_Calculations!U16","v":0},{"$f":"Cost_Calculations!V36-Cost_Calculations!V16","v":0},{"$f":"Cost_Calculations!W36-Cost_Calculations!W16","v":0},{"$f":"Cost_Calculations!X36-Cost_Calculations!X16","v":0}]
[]
[null,null,null,"Change in Energy Rate - variable portion (%)",{"$f":"Cost_Calculations!E32/Cost_Calculations!E12-1","v":-2.6421603280946115E-3},{"$f":"Cost_Calculations!F32/Cost_Calculations!F12-1","v":-5.305025062025015E-3},{"$f":"Cost_Calculations!G32/Cost_Calculations!G12-1","v":-7.9888385237945059E-3},{"$f":"Cost_Calculations!H32/Cost_Calculations!H12-1","v":-1.069384889474212E-2},{"$f":"Cost_Calculations!I32/Cost_Calculations!I12-1","v":-1.342030829205243E-2},{"$f":"Cost_Calculations!J32/Cost_Calculations!J12-1","v":-1.6168472847083337E-2},{"$f":"Cost_Calculations!K32/Cost_Calculations!K12-1","v":-1.893860278558035E-2},{"$f":"Cost_Calculations!L32/Cost_Calculations!L12-1","v":-2.1730962509816321E-2},{"$f":"Cost_Calculations!M32/Cost_Calculations!M12-1","v":-2.454582068271971E-2},{"$f":"Cost_Calculations!N32/Cost_Calculations!N12-1","v":-2.7383450314042435E-2},{"$f":"Cost_Calculations!O32/Cost_Calculations!O12-1","v":-2.7383450314042213E-2},{"$f":"Cost_Calculations!P32/Cost_Calculations!P12-1","v":-2.7383450314042213E-2},{"$f":"Cost_Calculations!Q32/Cost_Calculations!Q12-1","v":-2.7383450314042213E-2},{"$f":"Cost_Calculations!R32/Cost_Calculations!R12-1","v":-2.7383450314042324E-2},{"$f":"Cost_Calculations!S32/Cost_Calculations!S12-1","v":-2.7383450314042213E-2},{"$f":"Cost_Calculations!T32/Cost_Calculations!T12-1","v":-2.7383450314042213E-2},{"$f":"Cost_Calculations!U32/Cost_Calculations!U12-1","v":-2.7383450314042213E-2},{"$f":"Cost_Calculations!V32/Cost_Calculations!V12-1","v":-2.7383450314042102E-2},{"$f":"Cost_Calculations!W32/Cost_Calculations!W12-1","v":-2.7383450314042102E-2},{"$f":"Cost_Calculations!X32/Cost_Calculations!X12-1","v":-2.7383450314042435E-2}]
[null,null,null,"Change in Energy Rate - fixed portion (%)",{"$f":"Cost_Calculations!E33/Cost_Calculations!E13-1","v":3.902791333470601E-3},{"$f":"Cost_Calculations!F33/Cost_Calculations!F13-1","v":7.8361655860785806E-3},{"$f":"Cost_Calculations!G33/Cost_Calculations!G13-1","v":1.1800483651060345E-2},{"$f":"Cost_Calculations!H33/Cost_Calculations!H13-1","v":1.5796112122363981E-2},{"$f":"Cost_Calculations!I33/Cost_Calculations!I13-1","v":1.9823423407653751E-2},{"$f":"Cost_Calculations!J33/Cost_Calculations!J13-1","v":2.3882795844019533E-2},{"$f":"Cost_Calculations!K33/Cost_Calculations!K13-1","v":2.7974613816454941E-2},{"$f":"Cost_Calculations!L33/Cost_Calculations!L13-1","v":3.209926787919315E-2},{"$f":"Cost_Calculations!M33/Cost_Calculations!M13-1","v":3.6257154879971054E-2},{"$f":"Cost_Calculations!N33/Cost_Calculations!N13-1","v":4.044867808731234E-2},{"$f":"Cost_Calculations!O33/Cost_Calculations!O13-1","v":4.044867808731234E-2},{"$f":"Cost_Calculations!P33/Cost_Calculations!P13-1","v":4.044867808731234E-2},{"$f":"Cost_Calculations!Q33/Cost_Calculations!Q13-1","v":4.044867808731234E-2},{"$f":"Cost_Calculations!R33/Cost_Calculations!R13-1","v":4.0448678087312118E-2},{"$f":"Cost_Calculations!S33/Cost_Calculations!S13-1","v":4.044867808731234E-2},{"$f":"Cost_Calculations!T33/Cost_Calculations!T13-1","v":4.044867808731234E-2},{"$f":"Cost_Calculations!U33/Cost_Calculations!U13-1","v":4.044867808731234E-2},{"$f":"Cost_Calculations!V33/Cost_Calculations!V13-1","v":4.044867808731234E-2},{"$f":"Cost_Calculations!W33/Cost_Calculations!W13-1","v":4.044867808731234E-2},{"$f":"Cost_Calculations!X33/Cost_Calculations!X13-1","v":4.044867808731234E-2}]
[null,null,null,"Change in Total Energy Rate (%)",{"$f":"Cost_Calculations!E34/Cost_Calculations!E14-1","v":1.7207044495048951E-3},{"$f":"Cost_Calculations!F34/Cost_Calculations!F14-1","v":3.4548926240007827E-3},{"$f":"Cost_Calculations!G34/Cost_Calculations!G14-1","v":5.2027236379637021E-3},{"$f":"Cost_Calculations!H34/Cost_Calculations!H14-1","v":6.9643591192607435E-3},{"$f":"Cost_Calculations!I34/Cost_Calculations!I14-1","v":8.7399632589717502E-3},{"$f":"Cost_Calculations!J34/Cost_Calculations!J14-1","v":1.0529702862405843E-2},{"$f":"Cost_Calculations!K34/Cost_Calculations!K14-1","v":1.2333747401336304E-2},{"$f":"Cost_Calculations!L34/Cost_Calculations!L14-1","v":1.4152269067497336E-2},{"$f":"Cost_Calculations!M34/Cost_Calculations!M14-1","v":1.59854428273698E-2},{"$f":"Cost_Calculations!N34/Cost_Calculations!N14-1","v":1.7833446478300763E-2},{"$f":"Cost_Calculations!O34/Cost_Calculations!O14-1","v":1.7833446478300763E-2},{"$f":"Cost_Calculations!P34/Cost_Calculations!P14-1","v":1.7833446478300763E-2},{"$f":"Cost_Calculations!Q34/Cost_Calculations!Q14-1","v":1.7833446478300763E-2},{"$f":"Cost_Calculations!R34/Cost_Calculations!R14-1","v":1.7833446478300541E-2},{"$f":"Cost_Calculations!S34/Cost_Calculations!S14-1","v":1.7833446478300763E-2},{"$f":"Cost_Calculations!T34/Cost_Calculations!T14-1","v":1.7833446478300763E-2},{"$f":"Cost_Calculations!U34/Cost_Calculations!U14-1","v":1.7833446478300763E-2},{"$f":"Cost_Calculations!V34/Cost_Calculations!V14-1","v":1.7833446478300763E-2},{"$f":"Cost_Calculations!W34/Cost_Calculations!W14-1","v":1.7833446478300763E-2},{"$f":"Cost_Calculations!X34/Cost_Calculations!X14-1","v":1.7833446478300763E-2}]
[]
[null,"Avoided Costs",null,"Energy Rate impact due to AC  (¢/kWh)",{"$f":"(Cost_Calculations!E43/Cost_Calculations!E10-Cost_Calculations!E14)*(Reference!$C$71/Reference!$C$70)","v":-2.1381903227479883E-2},{"$f":"(Cost_Calculations!F43/Cost_Calculations!F10-Cost_Calculations!F14)*(Reference!$C$71/Reference!$C$70)","v":-4.2763806454958343E-2},{"$f":"(Cost_Calculations!G43/Cost_Calculations!G10-Cost_Calculations!G14)*(Reference!$C$71/Reference!$C$70)","v":-6.4145709682439642E-2},{"$f":"(Cost_Calculations!H43/Cost_Calculations!H10-Cost_Calculations!H14)*(Reference!$C$71/Reference!$C$70)","v":-8.5527612909918116E-2},{"$f":"(Cost_Calculations!I43/Cost_Calculations!I10-Cost_Calculations!I14)*(Reference!$C$71/Reference!$C$70)","v":-0.10690951613739799},{"$f":"(Cost_Calculations!J43/Cost_Calculations!J10-Cost_Calculations!J14)*(Reference!$C$71/Reference!$C$70)","v":-0.12829141936487645},{"$f":"(Cost_Calculations!K43/Cost_Calculations!K10-Cost_Calculations!K14)*(Reference!$C$71/Reference!$C$70)","v":-0.14967332259235774},{"$f":"(Cost_Calculations!L43/Cost_Calculations!L10-Cost_Calculations!L14)*(Reference!$C$71/Reference!$C$70)","v":-0.17105522581983623},{"$f":"(Cost_Calculations!M43/Cost_Calculations!M10-Cost_Calculations!M14)*(Reference!$C$71/Reference!$C$70)","v":-0.19243712904731611},{"$f":"(Cost_Calculations!N43/Cost_Calculations!N10-Cost_Calculations!N14)*(Reference!$C$71/Reference!$C$70)","v":-0.21381903227479457},{"$f":"(Cost_Calculations!O43/Cost_Calculations!O10-Cost_Calculations!O14)*(Reference!$C$71/Reference!$C$70)","v":-0.21381903227479457},{"$f":"(Cost_Calculations!P43/Cost_Calculations!P10-Cost_Calculations!P14)*(Reference!$C$71/Reference!$C$70)","v":-0.21381903227479457},{"$f":"(Cost_Calculations!Q43/Cost_Calculations!Q10-Cost_Calculations!Q14)*(Reference!$C$71/Reference!$C$70)","v":-0.21381903227479457},{"$f":"(Cost_Calculations!R43/Cost_Calculations!R10-Cost_Calculations!R14)*(Reference!$C$71/Reference!$C$70)","v":-0.21381903227479457},{"$f":"(Cost_Calculations!S43/Cost_Calculations!S10-Cost_Calculations!S14)*(Reference!$C$71/Reference!$C$70)","v":-0.21381903227479457},{"$f":"(Cost_Calculations!T43/Cost_Calculations!T10-Cost_Calculations!T14)*(Reference!$C$71/Reference!$C$70)","v":-0.21381903227479457},{"$f":"(Cost_Calculations!U43/Cost_Calculations!U10-Cost_Calculations!U14)*(Reference!$C$71/Reference!$C$70)","v":-0.21381903227479457},{"$f":"(Cost_Calculations!V43/Cost_Calculations!V10-Cost_Calculations!V14)*(Reference!$C$71/Reference!$C$70)","v":-0.21381903227479315},{"$f":"(Cost_Calculations!W43/Cost_Calculations!W10-Cost_Calculations!W14)*(Reference!$C$71/Reference!$C$70)","v":-0.21381903227479315},{"$f":"(Cost_Calculations!X43/Cost_Calculations!X10-Cost_Calculations!X14)*(Reference!$C$71/Reference!$C$70)","v":-0.21381903227479457}]
[null,"Recovery of Lost Revenues",null,"Energy rate impact due to lost revenues (¢/kWh)",{"$f":"E17-E15","v":3.8308601950092225E-2},{"$f":"F17-F15","v":7.6749844314200288E-2},0.11532529231336212,0.15403653589302024,0.19288519021314698,0.23187289615007672,0.27100132081035894,0.31027215805698777,0.34968712904836541,0.38924798279032446,0.38924798279032446,0.38924798279032446,0.38924798279032446,0.38924798279032302,0.38924798279032446,0.38924798279032446,0.38924798279032446,0.38924798279032446,0.38924798279032446,0.38924798279032446]
[null,"Net Effect",null,"Energy rate impact of both  (¢/kWh)",{"$f":"E7/10","v":1.6926698722612342E-2},3.3986037859241945E-2,5.1179582630922482E-2,6.8508922983102141E-2,8.5975674075748992E-2,0.10358147678520027,0.12132799821800119,0.13921693223715154,0.15725000000104927,0.1754289505155299,0.1754289505155299,0.1754289505155299,0.1754289505155299,0.17542895051552848,0.1754289505155299,0.1754289505155299,0.1754289505155299,0.17542895051553131,0.17542895051553131,0.1754289505155299]
[]
[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(E5:N5)","v":-0.48807386618824145},{"$f":"AVERAGE(E5:X5)","v":-0.69308181494229826}]
[null,null,null,"Change in Energy Rate - fixed portion ($/MWh)",{"$f":"AVERAGE(E6:N6)","v":1.4414561402168033},{"$f":"AVERAGE(E6:X6)","v":2.0469177045342315}]
[null,null,null,"Change in Total Energy Rate ($/MWh)",{"$f":"AVERAGE(E7:N7)","v":0.95338227402856002},{"$f":"AVERAGE(E7:X7)","v":1.3538358895919302}]
[null,null,null,"Customer ($/Month)",{"$f":"AVERAGE(E8:N8)","v":0},{"$f":"AVERAGE(E8:X8)","v":0}]
[null,null,null,"Minimum bill ($)",{"$f":"AVERAGE(E9:N9)","v":0},{"$f":"AVERAGE(E9:X9)","v":0}]
[]
[null,null,null,"Change in Energy Rate - variable portion (%)",{"$f":"AVERAGE(E11:N11)","v":-1.4881749023995083E-2},{"$f":"AVERAGE(E11:X11)","v":-2.1132599669018655E-2}]
[null,null,null,"Change in Energy Rate - fixed portion (%)",{"$f":"AVERAGE(E12:N12)","v":2.1982148660757827E-2},{"$f":"AVERAGE(E12:X12)","v":3.1215413374035071E-2}]
[null,null,null,"Total Energy Rate (%)"]
[]
[null,null,null,"Energy Rate impact due to AC  (¢/kWh)",{"$f":"AVERAGE(E15:N15)","v":-0.1176004677511375},{"$f":"AVERAGE(E15:X15)","v":-0.16570975001296584}]
[null,null,null,"Energy rate impact due to lost revenues  (¢/kWh)",{"$f":"AVERAGE(E16:N16)","v":0.2129386951539935},{"$f":"AVERAGE(E16:X16)","v":0.30109333897215895}]
[null,null,null,"Energy rate impact of both  (¢/kWh)",{"$f":"AVERAGE(E17:N17)","v":9.533822740285601E-2},{"$f":"AVERAGE(E17:X17)","v":0.13538358895919306}]

{"sheet":"Year_to_Year_Calcs","index":3,"n_rows":30,"n_cols":24,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,"Utah NEM Rate Impact Analysis"]
[]
[null,null,"Year-to-Year Calculations",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":"Cost_Calculations!E12","v":32.796808049999996},{"$f":"Cost_Calculations!F12","v":32.796808049999996},{"$f":"Cost_Calculations!G12","v":32.796808049999996},{"$f":"Cost_Calculations!H12","v":32.796808049999996},{"$f":"Cost_Calculations!I12","v":32.796808049999996},{"$f":"Cost_Calculations!J12","v":32.796808049999996},{"$f":"Cost_Calculations!K12","v":32.796808049999996},{"$f":"Cost_Calculations!L12","v":32.796808049999996},{"$f":"Cost_Calculations!M12","v":32.796808049999996},{"$f":"Cost_Calculations!N12","v":32.796808049999996},{"$f":"Cost_Calculations!O12","v":32.796808049999996},{"$f":"Cost_Calculations!P12","v":32.796808049999996},{"$f":"Cost_Calculations!Q12","v":32.796808049999996},{"$f":"Cost_Calculations!R12","v":32.796808049999996},{"$f":"Cost_Calculations!S12","v":32.796808049999996},{"$f":"Cost_Calculations!T12","v":32.796808049999996},{"$f":"Cost_Calculations!U12","v":32.796808049999996},{"$f":"Cost_Calculations!V12","v":32.796808049999996},{"$f":"Cost_Calculations!W12","v":32.796808049999996},{"$f":"Cost_Calculations!X12","v":32.796808049999996}]
[null,"Energy rate times fixed portion",null,"Energy Rate - fixed portion ($/MWh)",{"$f":"Cost_Calculations!E13","v":65.573941949999991},{"$f":"Cost_Calculations!F13","v":65.573941949999991},{"$f":"Cost_Calculations!G13","v":65.573941949999991},{"$f":"Cost_Calculations!H13","v":65.573941949999991},{"$f":"Cost_Calculations!I13","v":65.573941949999991},{"$f":"Cost_Calculations!J13","v":65.573941949999991},{"$f":"Cost_Calculations!K13","v":65.573941949999991},{"$f":"Cost_Calculations!L13","v":65.573941949999991},{"$f":"Cost_Calculations!M13","v":65.573941949999991},{"$f":"Cost_Calculations!N13","v":65.573941949999991},{"$f":"Cost_Calculations!O13","v":65.573941949999991},{"$f":"Cost_Calculations!P13","v":65.573941949999991},{"$f":"Cost_Calculations!Q13","v":65.573941949999991},{"$f":"Cost_Calculations!R13","v":65.573941949999991},{"$f":"Cost_Calculations!S13","v":65.573941949999991},{"$f":"Cost_Calculations!T13","v":65.573941949999991},{"$f":"Cost_Calculations!U13","v":65.573941949999991},{"$f":"Cost_Calculations!V13","v":65.573941949999991},{"$f":"Cost_Calculations!W13","v":65.573941949999991},{"$f":"Cost_Calculations!X13","v":65.573941949999991}]
[null,"Sum of above",null,"Total Energy Rate ($/MWh)",{"$f":"Cost_Calculations!E14","v":98.370749999999987},{"$f":"Cost_Calculations!F14","v":98.370749999999987},{"$f":"Cost_Calculations!G14","v":98.370749999999987},{"$f":"Cost_Calculations!H14","v":98.370749999999987},{"$f":"Cost_Calculations!I14","v":98.370749999999987},{"$f":"Cost_Calculations!J14","v":98.370749999999987},{"$f":"Cost_Calculations!K14","v":98.370749999999987},{"$f":"Cost_Calculations!L14","v":98.370749999999987},{"$f":"Cost_Calculations!M14","v":98.370749999999987},{"$f":"Cost_Calculations!N14","v":98.370749999999987},{"$f":"Cost_Calculations!O14","v":98.370749999999987},{"$f":"Cost_Calculations!P14","v":98.370749999999987},{"$f":"Cost_Calculations!Q14","v":98.370749999999987},{"$f":"Cost_Calculations!R14","v":98.370749999999987},{"$f":"Cost_Calculations!S14","v":98.370749999999987},{"$f":"Cost_Calculations!T14","v":98.370749999999987},{"$f":"Cost_Calculations!U14","v":98.370749999999987},{"$f":"Cost_Calculations!V14","v":98.370749999999987},{"$f":"Cost_Calculations!W14","v":98.370749999999987},{"$f":"Cost_Calculations!X14","v":98.370749999999987}]
[null,"Customer charge",null,"Customer ($/Month)",{"$f":"Cost_Calculations!E15","v":6},{"$f":"Cost_Calculations!F15","v":6},{"$f":"Cost_Calculations!G15","v":6},{"$f":"Cost_Calculations!H15","v":6},{"$f":"Cost_Calculations!I15","v":6},{"$f":"Cost_Calculations!J15","v":6},{"$f":"Cost_Calculations!K15","v":6},{"$f":"Cost_Calculations!L15","v":6},{"$f":"Cost_Calculations!M15","v":6},{"$f":"Cost_Calculations!N15","v":6},{"$f":"Cost_Calculations!O15","v":6},{"$f":"Cost_Calculations!P15","v":6},{"$f":"Cost_Calculations!Q15","v":6},{"$f":"Cost_Calculations!R15","v":6},{"$f":"Cost_Calculations!S15","v":6},{"$f":"Cost_Calculations!T15","v":6},{"$f":"Cost_Calculations!U15","v":6},{"$f":"Cost_Calculations!V15","v":6},{"$f":"Cost_Calculations!W15","v":6},{"$f":"Cost_Calculations!X15","v":6}]
[null,"Minimum bill ",null,"Minimum bill ($)",{"$f":"Cost_Calculations!E16","v":8},{"$f":"Cost_Calculations!F16","v":8},{"$f":"Cost_Calculations!G16","v":8},{"$f":"Cost_Calculations!H16","v":8},{"$f":"Cost_Calculations!I16","v":8},{"$f":"Cost_Calculations!J16","v":8},{"$f":"Cost_Calculations!K16","v":8},{"$f":"Cost_Calculations!L16","v":8},{"$f":"Cost_Calculations!M16","v":8},{"$f":"Cost_Calculations!N16","v":8},{"$f":"Cost_Calculations!O16","v":8},{"$f":"Cost_Calculations!P16","v":8},{"$f":"Cost_Calculations!Q16","v":8},{"$f":"Cost_Calculations!R16","v":8},{"$f":"Cost_Calculations!S16","v":8},{"$f":"Cost_Calculations!T16","v":8},{"$f":"Cost_Calculations!U16","v":8},{"$f":"Cost_Calculations!V16","v":8},{"$f":"Cost_Calculations!W16","v":8},{"$f":"Cost_Calculations!X16","v":8}]
[]
[null,null,"With DG PV"]
[null,null,"Rates"]
[null,"New variable costs / net sales",null,"Energy Rate - variable portion ($/MWh)",{"$f":"Cost_Calculations!E32","v":32.710153624882153},{"$f":"Cost_Calculations!F32","v":32.622820161340321},{"$f":"Cost_Calculations!G32","v":32.534799646392663},{"$f":"Cost_Calculations!H32","v":32.446083940483433},{"$f":"Cost_Calculations!I32","v":32.35666477497373},{"$f":"Cost_Calculations!J32","v":32.266533749572567},{"$f":"Cost_Calculations!K32","v":32.17568232970612},{"$f":"Cost_Calculations!L32","v":32.084101843823802},{"$f":"Cost_Calculations!M32","v":31.991783480639118},{"$f":"Cost_Calculations!N32","v":31.898718286303634},{"$f":"Cost_Calculations!O32","v":31.898718286303641},{"$f":"Cost_Calculations!P32","v":31.898718286303641},{"$f":"Cost_Calculations!Q32","v":31.898718286303641},{"$f":"Cost_Calculations!R32","v":31.898718286303637},{"$f":"Cost_Calculations!S32","v":31.898718286303641},{"$f":"Cost_Calculations!T32","v":31.898718286303641},{"$f":"Cost_Calculations!U32","v":31.898718286303641},{"$f":"Cost_Calculations!V32","v":31.898718286303644},{"$f":"Cost_Calculations!W32","v":31.898718286303644},{"$f":"Cost_Calculations!X32","v":31.898718286303634}]
[null,"New fixed costs / net sales",null,"Energy Rate - fixed portion ($/MWh)",{"$f":"Cost_Calculations!E33","v":65.829863362343957},{"$f":"Cost_Calculations!F33","v":66.087790217252092},{"$f":"Cost_Calculations!G33","v":66.347746179916541},{"$f":"Cost_Calculations!H33","v":66.609755289347575},{"$f":"Cost_Calculations!I33","v":66.873841965783754},{"$f":"Cost_Calculations!J33","v":67.14003101827943},{"$f":"Cost_Calculations!K33","v":67.408347652473878},{"$f":"Cost_Calculations!L33","v":67.6788174785477},{"$f":"Cost_Calculations!M33","v":67.951466519371365},{"$f":"Cost_Calculations!N33","v":68.226321218851652},{"$f":"Cost_Calculations!O33","v":68.226321218851652},{"$f":"Cost_Calculations!P33","v":68.226321218851652},{"$f":"Cost_Calculations!Q33","v":68.226321218851652},{"$f":"Cost_Calculations!R33","v":68.226321218851638},{"$f":"Cost_Calculations!S33","v":68.226321218851652},{"$f":"Cost_Calculations!T33","v":68.226321218851652},{"$f":"Cost_Calculations!U33","v":68.226321218851652},{"$f":"Cost_Calculations!V33","v":68.226321218851652},{"$f":"Cost_Calculations!W33","v":68.226321218851652},{"$f":"Cost_Calculations!X33","v":68.226321218851652}]
[null,"Sum of above",null,"Total Energy Rate ($/MWh)",{"$f":"Cost_Calculations!E34","v":98.54001698722611},{"$f":"Cost_Calculations!F34","v":98.710610378592406},{"$f":"Cost_Calculations!G34","v":98.882545826309212},{"$f":"Cost_Calculations!H34","v":99.055839229831008},{"$f":"Cost_Calculations!I34","v":99.230506740757477},{"$f":"Cost_Calculations!J34","v":99.406564767851989},{"$f":"Cost_Calculations!K34","v":99.584029982179999},{"$f":"Cost_Calculations!L34","v":99.762919322371502},{"$f":"Cost_Calculations!M34","v":99.94325000001048},{"$f":"Cost_Calculations!N34","v":100.12503950515529},{"$f":"Cost_Calculations!O34","v":100.12503950515529},{"$f":"Cost_Calculations!P34","v":100.12503950515529},{"$f":"Cost_Calculations!Q34","v":100.12503950515529},{"$f":"Cost_Calculations!R34","v":100.12503950515527},{"$f":"Cost_Calculations!S34","v":100.12503950515529},{"$f":"Cost_Calculations!T34","v":100.12503950515529},{"$f":"Cost_Calculations!U34","v":100.12503950515529},{"$f":"Cost_Calculations!V34","v":100.1250395051553},{"$f":"Cost_Calculations!W34","v":100.1250395051553},{"$f":"Cost_Calculations!X34","v":100.12503950515529}]
[null,"Same as No DG PV",null,"Customer ($/Month)",{"$f":"Cost_Calculations!E35","v":6},{"$f":"Cost_Calculations!F35","v":6},{"$f":"Cost_Calculations!G35","v":6},{"$f":"Cost_Calculations!H35","v":6},{"$f":"Cost_Calculations!I35","v":6},{"$f":"Cost_Calculations!J35","v":6},{"$f":"Cost_Calculations!K35","v":6},{"$f":"Cost_Calculations!L35","v":6},{"$f":"Cost_Calculations!M35","v":6},{"$f":"Cost_Calculations!N35","v":6},{"$f":"Cost_Calculations!O35","v":6},{"$f":"Cost_Calculations!P35","v":6},{"$f":"Cost_Calculations!Q35","v":6},{"$f":"Cost_Calculations!R35","v":6},{"$f":"Cost_Calculations!S35","v":6},{"$f":"Cost_Calculations!T35","v":6},{"$f":"Cost_Calculations!U35","v":6},{"$f":"Cost_Calculations!V35","v":6},{"$f":"Cost_Calculations!W35","v":6},{"$f":"Cost_Calculations!X35","v":6}]
[null,"Same as No DG PV",null,"Minimum bill ($)",{"$f":"Cost_Calculations!E36","v":8},{"$f":"Cost_Calculations!F36","v":8},{"$f":"Cost_Calculations!G36","v":8},{"$f":"Cost_Calculations!H36","v":8},{"$f":"Cost_Calculations!I36","v":8},{"$f":"Cost_Calculations!J36","v":8},{"$f":"Cost_Calculations!K36","v":8},{"$f":"Cost_Calculations!L36","v":8},{"$f":"Cost_Calculations!M36","v":8},{"$f":"Cost_Calculations!N36","v":8},{"$f":"Cost_Calculations!O36","v":8},{"$f":"Cost_Calculations!P36","v":8},{"$f":"Cost_Calculations!Q36","v":8},{"$f":"Cost_Calculations!R36","v":8},{"$f":"Cost_Calculations!S36","v":8},{"$f":"Cost_Calculations!T36","v":8},{"$f":"Cost_Calculations!U36","v":8},{"$f":"Cost_Calculations!V36","v":8},{"$f":"Cost_Calculations!W36","v":8},{"$f":"Cost_Calculations!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":"F14-E14","v":-8.7333463541831691E-2},{"$f":"G14-F14","v":-8.8020514947658057E-2},-8.871570590923028E-2,-8.9419165509703191E-2,{"$f":"J14-I14","v":-9.0131025401163356E-2},-9.0851419866446292E-2,-9.158048588231793E-2,-9.2318363184684671E-2,-9.3065194335483881E-2,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Energy Rate - fixed portion ($/MWh)","----",{"$f":"F15-E15","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)","----",0.17059339136629603,0.17193544771680536,0.17329340352179656,0.17466751092646859,{"$f":"J16-I16","v":0.17605802709451268},0.17746521432800932,0.17888934019150327,0.18033067763897748,0.18178950514480618,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Customer ($/Month)","----",{"$f":"F17-E17","v":0},{"$f":"G17-F17","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":"F14/E14-1","v":-2.6699190882245594E-3},{"$f":"G14/F14-1","v":-2.6981270936216051E-3},{"$f":"H14/G14-1","v":-2.726794290219825E-3},-2.7559309059831394E-3,-2.7855474607159092E-3,-2.8156547762943074E-3,-2.846263987314579E-3,-2.8773865521953823E-3,-2.9090342647450917E-3,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Energy Rate - fixed portion (%)","----",{"$f":"F15/E15-1","v":3.9180827930394013E-3},3.9334945503533003E-3,{"$f":"H15/G15-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.7312092749934838E-3,1.7418132362607697E-3,{"$f":"H16/G16-1","v":1.7525176164678857E-3},1.7633237200807006E-3,1.7742328733085788E-3,1.7852464245440292E-3,1.7963657448238912E-3,1.8075922282934087E-3,1.8189272926865119E-3,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Reference","index":4,"n_rows":71,"n_cols":7,"rows_kept":71,"cut":false,"hidden":false,"merged":[[8,3,8,4],[60,1,60,16]]}
[]
[null,"Input References"]
[null,"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,"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,"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":"C62*Reference!$C$70","v":43},"$/MWh"]
[null,"Plant O&M Value",1.2999999999999999E-2,"($/kWh)",null,{"$f":"C63*Reference!$C$70","v":13},"$/MWh"]
[null,"Generation Capacity Value",1.4E-2,"($/kWh)",null,{"$f":"C64*Reference!$C$70","v":14},"$/MWh"]
[null,"Avoided T&D Capacity Cost",1.0999999999999999E-2,"($/kWh)",null,{"$f":"C65*Reference!$C$70","v":11},"$/MWh"]
[null,"Avoided Environmental Cost",8.9999999999999993E-3,"($/kWh)",null,{"$f":"C66*Reference!$C$70","v":9},"$/MWh"]
[null,"Fuel Price Guarantee Value",2.5999999999999999E-2,"($/kWh)",null,{"$f":"C67*Reference!$C$70","v":26},"$/MWh"]
[]
[null,"Conversion factors"]
[null,"kWh per MWh",1000]
[null,"cents per dollar",100]

{"sheet":"DataTable","index":5,"n_rows":85,"n_cols":130,"rows_kept":85,"cut":false,"hidden":false,"merged":[[78,2,78,3],[78,4,78,5]]}
[]
[]
[]
[]
[]
[null,{"$f":"VALUE(LEFT($D$6,FIND(\"|\",$D$6)-1))","v":60},{"$f":"VALUE(RIGHT($D$6,LEN($D$6)-FIND(\"|\",$D$6)))","v":5.0000000000000001E-3},"60|0.005"]
[null,null,null,null,{"$f":"Cost_Calculations!E2","v":2015},{"$f":"Cost_Calculations!F2","v":2016},{"$f":"Cost_Calculations!G2","v":2017},{"$f":"Cost_Calculations!H2","v":2018},{"$f":"Cost_Calculations!I2","v":2019},{"$f":"Cost_Calculations!J2","v":2020},{"$f":"Cost_Calculations!K2","v":2021},{"$f":"Cost_Calculations!L2","v":2022},{"$f":"Cost_Calculations!M2","v":2023},{"$f":"Cost_Calculations!N2","v":2024},{"$f":"Cost_Calculations!O2","v":2025},{"$f":"Cost_Calculations!P2","v":2026},{"$f":"Cost_Calculations!Q2","v":2027},{"$f":"Cost_Calculations!R2","v":2028},{"$f":"Cost_Calculations!S2","v":2029},{"$f":"Cost_Calculations!T2","v":2030},{"$f":"Cost_Calculations!U2","v":2031},{"$f":"Cost_Calculations!V2","v":2032},{"$f":"Cost_Calculations!W2","v":2033},{"$f":"Cost_Calculations!X2","v":2034},{"$f":"Cost_Calculations!E2","v":2015},{"$f":"Cost_Calculations!F2","v":2016},{"$f":"Cost_Calculations!G2","v":2017},{"$f":"Cost_Calculations!H2","v":2018},{"$f":"Cost_Calculations!I2","v":2019},{"$f":"Cost_Calculations!J2","v":2020},{"$f":"Cost_Calculations!K2","v":2021},{"$f":"Cost_Calculations!L2","v":2022},{"$f":"Cost_Calculations!M2","v":2023},{"$f":"Cost_Calculations!N2","v":2024},{"$f":"Cost_Calculations!O2","v":2025},{"$f":"Cost_Calculations!P2","v":2026},{"$f":"Cost_Calculations!Q2","v":2027},{"$f":"Cost_Calculations!R2","v":2028},{"$f":"Cost_Calculations!S2","v":2029},{"$f":"Cost_Calculations!T2","v":2030},{"$f":"Cost_Calculations!U2","v":2031},{"$f":"Cost_Calculations!V2","v":2032},{"$f":"Cost_Calculations!W2","v":2033},{"$f":"Cost_Calculations!X2","v":2034},{"$f":"Cost_Calculations!E2","v":2015},{"$f":"Cost_Calculations!F2","v":2016},{"$f":"Cost_Calculations!G2","v":2017},{"$f":"Cost_Calculations!H2","v":2018},{"$f":"Cost_Calculations!I2","v":2019},{"$f":"Cost_Calculations!J2","v":2020},{"$f":"Cost_Calculations!K2","v":2021},{"$f":"Cost_Calculations!L2","v":2022},{"$f":"Cost_Calculations!M2","v":2023},{"$f":"Cost_Calculations!N2","v":2024},{"$f":"Cost_Calculations!O2","v":2025},{"$f":"Cost_Calculations!P2","v":2026},{"$f":"Cost_Calculations!Q2","v":2027},{"$f":"Cost_Calculations!R2","v":2028},{"$f":"Cost_Calculations!S2","v":2029},{"$f":"Cost_Calculations!T2","v":2030},{"$f":"Cost_Calculations!U2","v":2031},{"$f":"Cost_Calculations!V2","v":2032},{"$f":"Cost_Calculations!W2","v":2033},{"$f":"Cost_Calculations!X2","v":2034}]
[null,"Avoided Cost","Annual Pen",null,{"$f":"Cost_Calculations!$D$53&\" \"&Cost_Calculations!E2","v":"Cumulative PV of Benefits 2015"},{"$f":"Cost_Calculations!$D$53&\" \"&Cost_Calculations!F2","v":"Cumulative PV of Benefits 2016"},{"$f":"Cost_Calculations!$D$53&\" \"&Cost_Calculations!G2","v":"Cumulative PV of Benefits 2017"},{"$f":"Cost_Calculations!$D$53&\" \"&Cost_Calculations!H2","v":"Cumulative PV of Benefits 2018"},{"$f":"Cost_Calculations!$D$53&\" \"&Cost_Calculations!I2","v":"Cumulative PV of Benefits 2019"},{"$f":"Cost_Calculations!$D$53&\" \"&Cost_Calculations!J2","v":"Cumulative PV of Benefits 2020"},{"$f":"Cost_Calculations!$D$53&\" \"&Cost_Calculations!K2","v":"Cumulative PV of Benefits 2021"},{"$f":"Cost_Calculations!$D$53&\" \"&Cost_Calculations!L2","v":"Cumulative PV of Benefits 2022"},{"$f":"Cost_Calculations!$D$53&\" \"&Cost_Calculations!M2","v":"Cumulative PV of Benefits 2023"},{"$f":"Cost_Calculations!$D$53&\" \"&Cost_Calculations!N2","v":"Cumulative PV of Benefits 2024"},{"$f":"Cost_Calculations!$D$53&\" \"&Cost_Calculations!O2","v":"Cumulative PV of Benefits 2025"},{"$f":"Cost_Calculations!$D$53&\" \"&Cost_Calculations!P2","v":"Cumulative PV of Benefits 2026"},{"$f":"Cost_Calculations!$D$53&\" \"&Cost_Calculations!Q2","v":"Cumulative PV of Benefits 2027"},{"$f":"Cost_Calculations!$D$53&\" \"&Cost_Calculations!R2","v":"Cumulative PV of Benefits 2028"},{"$f":"Cost_Calculations!$D$53&\" \"&Cost_Calculations!S2","v":"Cumulative PV of Benefits 2029"},{"$f":"Cost_Calculations!$D$53&\" \"&Cost_Calculations!T2","v":"Cumulative PV of Benefits 2030"},{"$f":"Cost_Calculations!$D$53&\" \"&Cost_Calculations!U2","v":"Cumulative PV of Benefits 2031"},{"$f":"Cost_Calculations!$D$53&\" \"&Cost_Calculations!V2","v":"Cumulative PV of Benefits 2032"},{"$f":"Cost_Calculations!$D$53&\" \"&Cost_Calculations!W2","v":"Cumulative PV of Benefits 2033"},{"$f":"Cost_Calculations!$D$53&\" \"&Cost_Calculations!X2","v":"Cumulative PV of Benefits 2034"},{"$f":"Cost_Calculations!$D$54&\" \"&Cost_Calculations!E2","v":"Cumulative PV of Costs 2015"},{"$f":"Cost_Calculations!$D$54&\" \"&Cost_Calculations!F2","v":"Cumulative PV of Costs 2016"},{"$f":"Cost_Calculations!$D$54&\" \"&Cost_Calculations!G2","v":"Cumulative PV of Costs 2017"},{"$f":"Cost_Calculations!$D$54&\" \"&Cost_Calculations!H2","v":"Cumulative PV of Costs 2018"},{"$f":"Cost_Calculations!$D$54&\" \"&Cost_Calculations!I2","v":"Cumulative PV of Costs 2019"},{"$f":"Cost_Calculations!$D$54&\" \"&Cost_Calculations!J2","v":"Cumulative PV of Costs 2020"},{"$f":"Cost_Calculations!$D$54&\" \"&Cost_Calculations!K2","v":"Cumulative PV of Costs 2021"},{"$f":"Cost_Calculations!$D$54&\" \"&Cost_Calculations!L2","v":"Cumulative PV of Costs 2022"},{"$f":"Cost_Calculations!$D$54&\" \"&Cost_Calculations!M2","v":"Cumulative PV of Costs 2023"},{"$f":"Cost_Calculations!$D$54&\" \"&Cost_Calculations!N2","v":"Cumulative PV of Costs 2024"},{"$f":"Cost_Calculations!$D$54&\" \"&Cost_Calculations!O2","v":"Cumulative PV of Costs 2025"},{"$f":"Cost_Calculations!$D$54&\" \"&Cost_Calculations!P2","v":"Cumulative PV of Costs 2026"},{"$f":"Cost_Calculations!$D$54&\" \"&Cost_Calculations!Q2","v":"Cumulative PV of Costs 2027"},{"$f":"Cost_Calculations!$D$54&\" \"&Cost_Calculations!R2","v":"Cumulative PV of Costs 2028"},{"$f":"Cost_Calculations!$D$54&\" \"&Cost_Calculations!S2","v":"Cumulative PV of Costs 2029"},{"$f":"Cost_Calculations!$D$54&\" \"&Cost_Calculations!T2","v":"Cumulative PV of Costs 2030"},{"$f":"Cost_Calculations!$D$54&\" \"&Cost_Calculations!U2","v":"Cumulative PV of Costs 2031"},{"$f":"Cost_Calculations!$D$54&\" \"&Cost_Calculations!V2","v":"Cumulative PV of Costs 2032"},{"$f":"Cost_Calculations!$D$54&\" \"&Cost_Calculations!W2","v":"Cumulative PV of Costs 2033"},{"$f":"Cost_Calculations!$D$54&\" \"&Cost_Calculations!X2","v":"Cumulative PV of Costs 2034"},"Cumulative NPV","Cumulative NPV","Cumulative NPV","Cumulative NPV","Cumulative NPV","Cumulative NPV","Cumulative NPV","Cumulative NPV","Cumulative NPV","Cumulative NPV","Cumulative NPV","Cumulative NPV","Cumulative NPV","Cumulative NPV","Cumulative NPV","Cumulative NPV","Cumulative NPV","Cumulative NPV","Cumulative NPV","Cumulative NPV",{"$f":"Rate_Calculations!$D$15&\" \"&Cost_Calculations!E2","v":"Energy Rate impact due to AC  (¢/kWh) 2015"},{"$f":"Rate_Calculations!$D$15&\" \"&Cost_Calculations!F2","v":"Energy Rate impact due to AC  (¢/kWh) 2016"},{"$f":"Rate_Calculations!$D$15&\" \"&Cost_Calculations!G2","v":"Energy Rate impact due to AC  (¢/kWh) 2017"},{"$f":"Rate_Calculations!$D$15&\" \"&Cost_Calculations!H2","v":"Energy Rate impact due to AC  (¢/kWh) 2018"},{"$f":"Rate_Calculations!$D$15&\" \"&Cost_Calculations!I2","v":"Energy Rate impact due to AC  (¢/kWh) 2019"},{"$f":"Rate_Calculations!$D$15&\" \"&Cost_Calculations!J2","v":"Energy Rate impact due to AC  (¢/kWh) 2020"},{"$f":"Rate_Calculations!$D$15&\" \"&Cost_Calculations!K2","v":"Energy Rate impact due to AC  (¢/kWh) 2021"},{"$f":"Rate_Calculations!$D$15&\" \"&Cost_Calculations!L2","v":"Energy Rate impact due to AC  (¢/kWh) 2022"},{"$f":"Rate_Calculations!$D$15&\" \"&Cost_Calculations!M2","v":"Energy Rate impact due to AC  (¢/kWh) 2023"},{"$f":"Rate_Calculations!$D$15&\" \"&Cost_Calculations!N2","v":"Energy Rate impact due to AC  (¢/kWh) 2024"},{"$f":"Rate_Calculations!$D$15&\" \"&Cost_Calculations!O2","v":"Energy Rate impact due to AC  (¢/kWh) 2025"},{"$f":"Rate_Calculations!$D$15&\" \"&Cost_Calculations!P2","v":"Energy Rate impact due to AC  (¢/kWh) 2026"},{"$f":"Rate_Calculations!$D$15&\" \"&Cost_Calculations!Q2","v":"Energy Rate impact due to AC  (¢/kWh) 2027"},{"$f":"Rate_Calculations!$D$15&\" \"&Cost_Calculations!R2","v":"Energy Rate impact due to AC  (¢/kWh) 2028"},{"$f":"Rate_Calculations!$D$15&\" \"&Cost_Calculations!S2","v":"Energy Rate impact due to AC  (¢/kWh) 2029"},{"$f":"Rate_Calculations!$D$15&\" \"&Cost_Calculations!T2","v":"Energy Rate impact due to AC  (¢/kWh) 2030"},{"$f":"Rate_Calculations!$D$15&\" \"&Cost_Calculations!U2","v":"Energy Rate impact due to AC  (¢/kWh) 2031"},{"$f":"Rate_Calculations!$D$15&\" \"&Cost_Calculations!V2","v":"Energy Rate impact due to AC  (¢/kWh) 2032"},{"$f":"Rate_Calculations!$D$15&\" \"&Cost_Calculations!W2","v":"Energy Rate impact due to AC  (¢/kWh) 2033"},{"$f":"Rate_Calculations!$D$15&\" \"&Cost_Calculations!X2","v":"Energy Rate impact due to AC  (¢/kWh) 2034"},{"$f":"Rate_Calculations!$D$16&\" \"&Cost_Calculations!E2","v":"Energy rate impact due to lost revenues (¢/kWh) 2015"},{"$f":"Rate_Calculations!$D$16&\" \"&Cost_Calculations!F2","v":"Energy rate impact due to lost revenues (¢/kWh) 2016"},{"$f":"Rate_Calculations!$D$16&\" \"&Cost_Calculations!G2","v":"Energy rate impact due to lost revenues (¢/kWh) 2017"},{"$f":"Rate_Calculations!$D$16&\" \"&Cost_Calculations!H2","v":"Energy rate impact due to lost revenues (¢/kWh) 2018"},{"$f":"Rate_Calculations!$D$16&\" \"&Cost_Calculations!I2","v":"Energy rate impact due to lost revenues (¢/kWh) 2019"},{"$f":"Rate_Calculations!$D$16&\" \"&Cost_Calculations!J2","v":"Energy rate impact due to lost revenues (¢/kWh) 2020"},{"$f":"Rate_Calculations!$D$16&\" \"&Cost_Calculations!K2","v":"Energy rate impact due to lost revenues (¢/kWh) 2021"},{"$f":"Rate_Calculations!$D$16&\" \"&Cost_Calculations!L2","v":"Energy rate impact due to lost revenues (¢/kWh) 2022"},{"$f":"Rate_Calculations!$D$16&\" \"&Cost_Calculations!M2","v":"Energy rate impact due to lost revenues (¢/kWh) 2023"},{"$f":"Rate_Calculations!$D$16&\" \"&Cost_Calculations!N2","v":"Energy rate impact due to lost revenues (¢/kWh) 2024"},{"$f":"Rate_Calculations!$D$16&\" \"&Cost_Calculations!O2","v":"Energy rate impact due to lost revenues (¢/kWh) 2025"},{"$f":"Rate_Calculations!$D$16&\" \"&Cost_Calculations!P2","v":"Energy rate impact due to lost revenues (¢/kWh) 2026"},{"$f":"Rate_Calculations!$D$16&\" \"&Cost_Calculations!Q2","v":"Energy rate impact due to lost revenues (¢/kWh) 2027"},{"$f":"Rate_Calculations!$D$16&\" \"&Cost_Calculations!R2","v":"Energy rate impact due to lost revenues (¢/kWh) 2028"},{"$f":"Rate_Calculations!$D$16&\" \"&Cost_Calculations!S2","v":"Energy rate impact due to lost revenues (¢/kWh) 2029"},{"$f":"Rate_Calculations!$D$16&\" \"&Cost_Calculations!T2","v":"Energy rate impact due to lost revenues (¢/kWh) 2030"},{"$f":"Rate_Calculations!$D$16&\" \"&Cost_Calculations!U2","v":"Energy rate impact due to lost revenues (¢/kWh) 2031"},{"$f":"Rate_Calculations!$D$16&\" \"&Cost_Calculations!V2","v":"Energy rate impact due to lost revenues (¢/kWh) 2032"},{"$f":"Rate_Calculations!$D$16&\" \"&Cost_Calculations!W2","v":"Energy rate impact due to lost revenues (¢/kWh) 2033"},{"$f":"Rate_Calculations!$D$16&\" \"&Cost_Calculations!X2","v":"Energy rate impact due to lost revenues (¢/kWh) 2034"},{"$f":"Rate_Calculations!$D$17&\" \"&Cost_Calculations!E2","v":"Energy rate impact of both  (¢/kWh) 2015"},{"$f":"Rate_Calculations!$D$17&\" \"&Cost_Calculations!F2","v":"Energy rate impact of both  (¢/kWh) 2016"},{"$f":"Rate_Calculations!$D$17&\" \"&Cost_Calculations!G2","v":"Energy rate impact of both  (¢/kWh) 2017"},{"$f":"Rate_Calculations!$D$17&\" \"&Cost_Calculations!H2","v":"Energy rate impact of both  (¢/kWh) 2018"},{"$f":"Rate_Calculations!$D$17&\" \"&Cost_Calculations!I2","v":"Energy rate impact of both  (¢/kWh) 2019"},{"$f":"Rate_Calculations!$D$17&\" \"&Cost_Calculations!J2","v":"Energy rate impact of both  (¢/kWh) 2020"},{"$f":"Rate_Calculations!$D$17&\" \"&Cost_Calculations!K2","v":"Energy rate impact of both  (¢/kWh) 2021"},{"$f":"Rate_Calculations!$D$17&\" \"&Cost_Calculations!L2","v":"Energy rate impact of both  (¢/kWh) 2022"},{"$f":"Rate_Calculations!$D$17&\" \"&Cost_Calculations!M2","v":"Energy rate impact of both  (¢/kWh) 2023"},{"$f":"Rate_Calculations!$D$17&\" \"&Cost_Calculations!N2","v":"Energy rate impact of both  (¢/kWh) 2024"},{"$f":"Rate_Calculations!$D$17&\" \"&Cost_Calculations!O2","v":"Energy rate impact of both  (¢/kWh) 2025"},{"$f":"Rate_Calculations!$D$17&\" \"&Cost_Calculations!P2","v":"Energy rate impact of both  (¢/kWh) 2026"},{"$f":"Rate_Calculations!$D$17&\" \"&Cost_Calculations!Q2","v":"Energy rate impact of both  (¢/kWh) 2027"},{"$f":"Rate_Calculations!$D$17&\" \"&Cost_Calculations!R2","v":"Energy rate impact of both  (¢/kWh) 2028"},{"$f":"Rate_Calculations!$D$17&\" \"&Cost_Calculations!S2","v":"Energy rate impact of both  (¢/kWh) 2029"},{"$f":"Rate_Calculations!$D$17&\" \"&Cost_Calculations!T2","v":"Energy rate impact of both  (¢/kWh) 2030"},{"$f":"Rate_Calculations!$D$17&\" \"&Cost_Calculations!U2","v":"Energy rate impact of both  (¢/kWh) 2031"},{"$f":"Rate_Calculations!$D$17&\" \"&Cost_Calculations!V2","v":"Energy rate impact of both  (¢/kWh) 2032"},{"$f":"Rate_Calculations!$D$17&\" \"&Cost_Calculations!W2","v":"Energy rate impact of both  (¢/kWh) 2033"},{"$f":"Rate_Calculations!$D$17&\" \"&Cost_Calculations!X2","v":"Energy rate impact of both  (¢/kWh) 2034"},"PVRR Without PV","PVRR With PV","Net Benefits","BCR"]
[null,null,null,null,{"$f":"Cost_Calculations!E53","v":1627378.5207004678},{"$f":"Cost_Calculations!F53","v":4743307.0627051555},{"$f":"Cost_Calculations!G53","v":9217839.5187592804},{"$f":"Cost_Calculations!H53","v":14929407.014006881},{"$f":"Cost_Calculations!I53","v":21764339.680120721},{"$f":"Cost_Calculations!J53","v":29616413.984698892},{"$f":"Cost_Calculations!K53","v":38386424.30592601},{"$f":"Cost_Calculations!L53","v":47981777.507756092},{"$f":"Cost_Calculations!M53","v":58316109.332949869},{"$f":"Cost_Calculations!N53","v":69308921.490343973},{"$f":"Cost_Calculations!O53","v":79832845.92538479},{"$f":"Cost_Calculations!P53","v":89907882.588314846},{"$f":"Cost_Calculations!Q53","v":99553178.350930363},{"$f":"Cost_Calculations!R53","v":108787063.39381346},{"$f":"Cost_Calculations!S53","v":117627086.04150249},{"$f":"Cost_Calculations!T53","v":126090046.11180195},{"$f":"Cost_Calculations!U53","v":134192026.84260996},{"$f":"Cost_Calculations!V53","v":141948425.456938},{"$f":"Cost_Calculations!W53","v":149373982.42420939},{"$f":"Cost_Calculations!X53","v":156482809.4734455},{"$f":"Cost_Calculations!E$54","v":135614.87672503898},{"$f":"Cost_Calculations!F$54","v":395275.58855876292},{"$f":"Cost_Calculations!G$54","v":768153.29322994},{"$f":"Cost_Calculations!H$54","v":1244117.2511672401},{"$f":"Cost_Calculations!I$54","v":1813694.9733433935},{"$f":"Cost_Calculations!J$54","v":2468034.4987249081},{"$f":"Cost_Calculations!K$54","v":3198868.6921605016},{"$f":"Cost_Calculations!L$54","v":3998481.4589796746},{"$f":"Cost_Calculations!M$54","v":4859675.7777458224},{"$f":"Cost_Calculations!N$54","v":5775743.4575286657},{"$f":"Cost_Calculations!O$54","v":6652737.1604487337},{"$f":"Cost_Calculations!P$54","v":7492323.5490262397},{"$f":"Cost_Calculations!Q$54","v":8296098.1959108654},{"$f":"Cost_Calculations!R$54","v":9065588.6161511242},{"$f":"Cost_Calculations!S$54","v":9802257.1701252107},{"$f":"Cost_Calculations!T$54","v":10507503.842650166},{"$f":"Cost_Calculations!U$54","v":11182668.903550832},{"$f":"Cost_Calculations!V$54","v":11829035.454744836},{"$f":"Cost_Calculations!W$54","v":12447831.86868412},{"$f":"Cost_Calculations!X$54","v":13040234.122787131},{"$f":"Cost_Calculations!E55","v":1491763.6439754288},{"$f":"Cost_Calculations!F55","v":4348031.4741463922},{"$f":"Cost_Calculations!G55","v":8449686.225529341},{"$f":"Cost_Calculations!H55","v":13685289.762839643},{"$f":"Cost_Calculations!I55","v":19950644.706777327},{"$f":"Cost_Calculations!J55","v":27148379.485973988},{"$f":"Cost_Calculations!K55","v":35187555.613765508},{"$f":"Cost_Calculations!L55","v":43983296.048776418},{"$f":"Cost_Calculations!M55","v":53456433.555204049},{"$f":"Cost_Calculations!N55","v":63533178.032815322},{"$f":"Cost_Calculations!O55","v":73180108.76493606},{"$f":"Cost_Calculations!P55","v":82415559.039288625},{"$f":"Cost_Calculations!Q55","v":91257080.155019507},{"$f":"Cost_Calculations!R55","v":99721474.777662337},{"$f":"Cost_Calculations!S55","v":107824828.87137727},{"$f":"Cost_Calculations!T55","v":115582542.26915178},{"$f":"Cost_Calculations!U55","v":123009357.93905911},{"$f":"Cost_Calculations!V55","v":130119390.00219317},{"$f":"Cost_Calculations!W55","v":136926150.55552527},{"$f":"Cost_Calculations!X55","v":143442575.35065842},{"$f":"Rate_Calculations!E15","v":-2.1381903227479883E-2},{"$f":"Rate_Calculations!F15","v":-4.2763806454958343E-2},{"$f":"Rate_Calculations!G15","v":-6.4145709682439642E-2},{"$f":"Rate_Calculations!H15","v":-8.5527612909918116E-2},{"$f":"Rate_Calculations!I15","v":-0.10690951613739799},{"$f":"Rate_Calculations!J15","v":-0.12829141936487645},{"$f":"Rate_Calculations!K15","v":-0.14967332259235774},{"$f":"Rate_Calculations!L15","v":-0.17105522581983623},{"$f":"Rate_Calculations!M15","v":-0.19243712904731611},{"$f":"Rate_Calculations!N15","v":-0.21381903227479457},{"$f":"Rate_Calculations!O15","v":-0.21381903227479457},{"$f":"Rate_Calculations!P15","v":-0.21381903227479457},{"$f":"Rate_Calculations!Q15","v":-0.21381903227479457},{"$f":"Rate_Calculations!R15","v":-0.21381903227479457},{"$f":"Rate_Calculations!S15","v":-0.21381903227479457},{"$f":"Rate_Calculations!T15","v":-0.21381903227479457},{"$f":"Rate_Calculations!U15","v":-0.21381903227479457},{"$f":"Rate_Calculations!V15","v":-0.21381903227479315},{"$f":"Rate_Calculations!W15","v":-0.21381903227479315},{"$f":"Rate_Calculations!X15","v":-0.21381903227479457},{"$f":"Rate_Calculations!E16","v":3.8308601950092225E-2},{"$f":"Rate_Calculations!F16","v":7.6749844314200288E-2},{"$f":"Rate_Calculations!G16","v":0.11532529231336212},{"$f":"Rate_Calculations!H16","v":0.15403653589302024},{"$f":"Rate_Calculations!I16","v":0.19288519021314698},{"$f":"Rate_Calculations!J16","v":0.23187289615007672},{"$f":"Rate_Calculations!K16","v":0.27100132081035894},{"$f":"Rate_Calculations!L16","v":0.31027215805698777},{"$f":"Rate_Calculations!M16","v":0.34968712904836541},{"$f":"Rate_Calculations!N16","v":0.38924798279032446},{"$f":"Rate_Calculations!O16","v":0.38924798279032446},{"$f":"Rate_Calculations!P16","v":0.38924798279032446},{"$f":"Rate_Calculations!Q16","v":0.38924798279032446},{"$f":"Rate_Calculations!R16","v":0.38924798279032302},{"$f":"Rate_Calculations!S16","v":0.38924798279032446},{"$f":"Rate_Calculations!T16","v":0.38924798279032446},{"$f":"Rate_Calculations!U16","v":0.38924798279032446},{"$f":"Rate_Calculations!V16","v":0.38924798279032446},{"$f":"Rate_Calculations!W16","v":0.38924798279032446},{"$f":"Rate_Calculations!X16","v":0.38924798279032446},{"$f":"Rate_Calculations!E$17","v":1.6926698722612342E-2},{"$f":"Rate_Calculations!F$17","v":3.3986037859241945E-2},{"$f":"Rate_Calculations!G$17","v":5.1179582630922482E-2},{"$f":"Rate_Calculations!H$17","v":6.8508922983102141E-2},{"$f":"Rate_Calculations!I$17","v":8.5975674075748992E-2},{"$f":"Rate_Calculations!J$17","v":0.10358147678520027},{"$f":"Rate_Calculations!K$17","v":0.12132799821800119},{"$f":"Rate_Calculations!L$17","v":0.13921693223715154},{"$f":"Rate_Calculations!M$17","v":0.15725000000104927},{"$f":"Rate_Calculations!N$17","v":0.1754289505155299},{"$f":"Rate_Calculations!O$17","v":0.1754289505155299},{"$f":"Rate_Calculations!P$17","v":0.1754289505155299},{"$f":"Rate_Calculations!Q$17","v":0.1754289505155299},{"$f":"Rate_Calculations!R$17","v":0.17542895051552848},{"$f":"Rate_Calculations!S$17","v":0.1754289505155299},{"$f":"Rate_Calculations!T$17","v":0.1754289505155299},{"$f":"Rate_Calculations!U$17","v":0.1754289505155299},{"$f":"Rate_Calculations!V$17","v":0.17542895051553131},{"$f":"Rate_Calculations!W$17","v":0.17542895051553131},{"$f":"Rate_Calculations!X$17","v":0.1754289505155299},{"$f":"Cost_Calculations!E62","v":10082098283.419893},{"$f":"Cost_Calculations!E61","v":9938655708.0692348},{"$f":"Cost_Calculations!E59","v":143442575.35065842},{"$f":"Cost_Calculations!E60","v":11.999999999999995}]
[null,60,5.0000000000000001E-3,{"$f":"B10&\"|\"&C10","v":"60|0.005"},1627378.5207004678,4743307.0627051555,9217839.5187592804,14929407.014006881,21764339.680120721,29616413.984698892,38386424.30592601,47981777.507756092,58316109.332949869,69308921.490343973,79832845.92538479,89907882.588314846,99553178.350930363,108787063.39381346,117627086.04150249,126090046.11180195,134192026.84260996,141948425.456938,149373982.42420939,156482809.4734455,135614.87672503898,395275.58855876292,768153.29322994,1244117.2511672401,1813694.9733433935,2468034.4987249081,3198868.6921605016,3998481.4589796746,4859675.7777458224,5775743.4575286657,6652737.1604487337,7492323.5490262397,8296098.1959108654,9065588.6161511242,9802257.1701252107,10507503.842650166,11182668.903550832,11829035.454744836,12447831.86868412,13040234.122787131,1491763.6439754288,4348031.4741463922,8449686.225529341,13685289.762839643,19950644.706777327,27148379.485973988,35187555.613765508,43983296.048776418,53456433.555204049,63533178.032815322,73180108.76493606,82415559.039288625,91257080.155019507,99721474.777662337,107824828.87137727,115582542.26915178,123009357.93905911,130119390.00219317,136926150.55552527,143442575.35065842,-2.1381903227479883E-2,-4.2763806454958343E-2,-6.4145709682439642E-2,-8.5527612909918116E-2,-0.10690951613739799,-0.12829141936487645,-0.14967332259235774,-0.17105522581983623,-0.19243712904731611,-0.21381903227479457,-0.21381903227479457,-0.21381903227479457,-0.21381903227479457,-0.21381903227479457,-0.21381903227479457,-0.21381903227479457,-0.21381903227479457,-0.21381903227479315,-0.21381903227479315,-0.21381903227479457,3.8308601950092225E-2,7.6749844314200288E-2,0.11532529231336212,0.15403653589302024,0.19288519021314698,0.23187289615007672,0.27100132081035894,0.31027215805698777,0.34968712904836541,0.38924798279032446,0.38924798279032446,0.38924798279032446,0.38924798279032446,0.38924798279032302,0.38924798279032446,0.38924798279032446,0.38924798279032446,0.38924798279032446,0.38924798279032446,0.38924798279032446,1.6926698722612342E-2,3.3986037859241945E-2,5.1179582630922482E-2,6.8508922983102141E-2,8.5975674075748992E-2,0.10358147678520027,0.12132799821800119,0.13921693223715154,0.15725000000104927,0.1754289505155299,0.1754289505155299,0.1754289505155299,0.1754289505155299,0.17542895051552848,0.1754289505155299,0.1754289505155299,0.1754289505155299,0.17542895051553131,0.17542895051553131,0.1754289505155299,10082098283.419893,9938655708.0692348,143442575.35065842,11.999999999999995,60,5.0000000000000001E-3]
[null,60,0.01,{"$f":"B11&\"|\"&C11","v":"60|0.01"},3254757.0414009355,9486614.1254103109,18435679.037518561,29858814.028013762,43528679.360241443,59232827.969397783,76772848.61185202,95963555.015512183,116632218.66589974,138617842.98068795,159665691.85076958,179815765.17662969,199106356.70186073,217574126.78762692,235254172.08300498,252180092.2236039,268384053.68521991,283896850.913876,298747964.84841877,312965618.94689101,271229.75345007796,790551.17711752583,1536306.58645988,2488234.5023344802,3627389.9466867871,4936068.9974498162,6397737.3843210032,7996962.9179593492,9719351.5554916449,11551486.915057331,13305474.320897467,14984647.098052479,16592196.391821731,18131177.232302248,19604514.340250421,21015007.685300332,22365337.807101663,23658070.909489673,24895663.737368241,26080468.245574262,2983527.2879508575,8696062.9482927844,16899372.451058682,27370579.525679287,39901289.413554654,54296758.971947975,70375111.227531016,87966592.097552836,106912867.1104081,127066356.06563064,146360217.52987212,164831118.07857725,182514160.31003901,199442949.55532467,215649657.74275455,231165084.53830355,246018715.87811822,260238780.00438634,273852301.11105055,286885150.70131683,-4.2763806454958343E-2,-8.5527612909916687E-2,-0.12829141936487645,-0.17105522581983479,-0.21381903227479315,-0.25658283872975435,-0.29934664518471127,-0.34211045163966958,-0.38487425809462938,-0.42763806454958769,-0.42763806454958769,-0.42763806454958914,-0.42763806454958914,-0.42763806454958914,-0.42763806454958914,-0.42763806454958914,-0.42763806454958769,-0.42763806454958769,-0.42763806454958914,-0.42763806454958914,7.6749844314197457E-2,0.15403653589301883,0.23187289615007672,0.31027215805698632,0.38924798279032302,0.46881447719322156,0.54898621209843279,0.6297782415629356,0.7112061230673149,0.79328593873696329,0.79328593873696329,0.79328593873696462,0.79328593873696462,0.79328593873696462,0.79328593873696607,0.79328593873696607,0.79328593873696462,0.79328593873696462,0.79328593873696607,0.79328593873696607,3.3986037859239107E-2,6.8508922983102141E-2,0.10358147678520027,0.13921693223715154,0.1754289505155299,0.21223163846346721,0.24963956691372147,0.28766778992326608,0.32633186497268551,0.36564787418737554,0.36564787418737554,0.36564787418737554,0.36564787418737554,0.36564787418737554,0.36564787418737693,0.36564787418737693,0.36564787418737693,0.36564787418737693,0.36564787418737693,0.36564787418737693,10082098283.419893,9795213132.7185764,286885150.70131683,11.999999999999995,60,0.01]
[null,60,0.02,"60|0.02",6509514.082801871,18973228.250820622,36871358.075037122,59717628.056027524,87057358.720482886,118465655.93879557,153545697.22370404,191927110.03102437,233264437.33179948,277235685.96137589,319331383.70153916,359631530.35325938,398212713.40372145,435148253.57525384,470508344.16600996,504360184.44720781,536768107.37043983,567793701.82775199,597495929.69683754,625931237.89378202,542459.50690015592,1581102.3542350517,3072613.17291976,4976469.0046689603,7254779.8933735741,9872137.9948996324,12795474.768642006,15993925.835918698,19438703.11098329,23102973.830114663,26610948.641794935,29969294.196104959,33184392.783643462,36262354.464604497,39209028.680500843,42030015.370600663,44730675.614203326,47316141.818979345,49791327.474736482,52160936.491148524,5967054.5759017151,17392125.896585569,33798744.902117364,54741159.051358573,79802578.827109307,108593517.94389595,140750222.45506203,175933184.19510567,213825734.2208162,254132712.13126129,292720435.05974424,329662236.1571545,365028320.62007803,398885899.11064935,431299315.4855091,462330169.07660711,492037431.75623643,520477560.00877267,547704602.22210109,573770301.40263367,-8.5527612909916687E-2,-0.17105522581983623,-0.2565828387297529,-0.34211045163967102,-0.42763806454958914,-0.51316567745950725,-0.59869329036942387,-0.6842209032793406,-0.76974851618925877,-0.85527612909917683,-0.85527612909917683,-0.85527612909917683,-0.85527612909917683,-0.85527612909917683,-0.85527612909917683,-0.85527612909917683,-0.85527612909917683,-0.85527612909917683,-0.85527612909917683,-0.85527612909917683,0.15403653589301741,0.31027215805698777,0.46881447719322011,0.62977824156293716,0.79328593873696607,0.9594684592679571,1.1284658298489374,1.3004280245966386,1.4755158643476776,1.6539020153121684,1.6539020153121697,1.6539020153121697,1.6539020153121697,1.6539020153121697,1.6539020153121697,1.6539020153121697,1.6539020153121697,1.6539020153121697,1.6539020153121697,1.6539020153121711,6.8508922983100712E-2,0.13921693223715154,0.21223163846346721,0.28766778992326608,0.36564787418737693,0.44630278180844984,0.52977253947951364,0.61620712131729793,0.70576734815841891,0.79862588621299158,0.79862588621299291,0.79862588621299291,0.79862588621299291,0.79862588621299291,0.79862588621299291,0.79862588621299291,0.79862588621299291,0.79862588621299291,0.79862588621299291,0.79862588621299435,10082098283.419893,9508327982.0172596,573770301.40263367,11.999999999999995,60,0.02]
[null,120,5.0000000000000001E-3,"120|0.005",3254757.0414009355,9486614.1254103109,18435679.037518561,29858814.028013762,43528679.360241443,59232827.969397783,76772848.61185202,95963555.015512183,116632218.66589974,138617842.98068795,159665691.85076958,179815765.17662969,199106356.70186073,217574126.78762692,235254172.08300498,252180092.2236039,268384053.68521991,283896850.913876,298747964.84841877,312965618.94689101,135614.87672503898,395275.58855876292,768153.29322994,1244117.2511672401,1813694.9733433935,2468034.4987249081,3198868.6921605016,3998481.4589796746,4859675.7777458224,5775743.4575286657,6652737.1604487337,7492323.5490262397,8296098.1959108654,9065588.6161511242,9802257.1701252107,10507503.842650166,11182668.903550832,11829035.454744836,12447831.86868412,13040234.122787131,3119142.1646758965,9091338.5368515477,17667525.74428862,28614696.776846524,41714984.386898048,56764793.470672876,73573979.919691518,91965073.556532502,111772542.88815391,132842099.5231593,153012954.69032085,172323441.62760347,190810258.50594985,208508538.1714758,225451914.91287977,241672588.38095373,257201384.78166908,272067815.45913112,286300132.97973466,299925384.82410389,-4.4707615839274698E-2,-8.9415231678550811E-2,-0.13412284751782552,-0.17883046335710162,-0.22353807919637492,-0.26824569503565104,-0.31295331087492717,-0.35766092671420185,-0.40236854255347654,-0.44707615839275122,-0.44707615839275122,-0.44707615839275122,-0.44707615839275122,-0.44707615839275122,-0.44707615839275122,-0.44707615839275122,-0.44707615839275122,-0.44707615839275122,-0.44707615839274983,-0.44707615839275122,3.821756656106317E-2,7.638427602132225E-2,0.11449952824238638,0.15256271360602086,0.19057321282620168,0.22853039675673448,0.26643362619419836,0.30428225167619449,0.34207561327470021,0.379813040384407,0.379813040384407,0.379813040384407,0.379813040384407,0.379813040384407,0.379813040384407,0.379813040384407,0.379813040384407,0.379813040384407,0.379813040384407,0.379813040384407,-6.4900492782115297E-3,-1.303095565722856E-2,-1.9623319275439144E-2,-2.626774975108077E-2,-3.2964866370173242E-2,-3.971529827891658E-2,-4.6519684680728798E-2,-5.3378675038007375E-2,-6.0292929278776344E-2,-6.7263118008344239E-2,-6.7263118008344239E-2,-6.7263118008344239E-2,-6.7263118008344239E-2,-6.7263118008344239E-2,-6.7263118008344239E-2,-6.7263118008344239E-2,-6.7263118008344239E-2,-6.7263118008344239E-2,-6.7263118008342809E-2,-6.7263118008344239E-2,10082098283.419893,9782172898.5957909,299925384.82410389,23.999999999999989,120,5.0000000000000001E-3]
[null,120,0.01,"120|0.01",6509514.082801871,18973228.250820622,36871358.075037122,59717628.056027524,87057358.720482886,118465655.93879557,153545697.22370404,191927110.03102437,233264437.33179948,277235685.96137589,319331383.70153916,359631530.35325938,398212713.40372145,435148253.57525384,470508344.16600996,504360184.44720781,536768107.37043983,567793701.82775199,597495929.69683754,625931237.89378202,271229.75345007796,790551.17711752583,1536306.58645988,2488234.5023344802,3627389.9466867871,4936068.9974498162,6397737.3843210032,7996962.9179593492,9719351.5554916449,11551486.915057331,13305474.320897467,14984647.098052479,16592196.391821731,18131177.232302248,19604514.340250421,21015007.685300332,22365337.807101663,23658070.909489673,24895663.737368241,26080468.245574262,6238284.329351793,18182677.073703095,35335051.488577239,57229393.553693049,83429968.773796096,113529586.94134575,147147959.83938304,183930147.113065,223545085.77630782,265684199.04631859,306025909.3806417,344646883.25520694,381620517.01189971,417017076.3429516,450903829.82575953,483345176.76190746,514402769.56333816,544135630.91826224,572600265.95946932,599850769.64820778,-8.9415231678550811E-2,-0.17883046335710021,-0.2682456950356496,-0.35766092671420185,-0.44707615839275122,-0.53649139007130209,-0.6259066217498529,-0.71532185342840227,-0.80473708510695308,-0.89415231678550389,-0.89415231678550244,-0.89415231678550244,-0.89415231678550389,-0.89415231678550244,-0.89415231678550244,-0.894152316785501,-0.89415231678550389,-0.89415231678550244,-0.89415231678550244,-0.89415231678550244,7.6384276021320835E-2,0.15256271360601945,0.22853039675673159,0.30428225167619449,0.379813040384407,0.45511735402353687,0.53018960583244168,0.60502402377174613,0.67961464277895522,0.75395529663181837,0.75395529663181693,0.75395529663181837,0.75395529663181837,0.75395529663181837,0.75395529663181837,0.75395529663181693,0.75395529663181982,0.75395529663181837,0.75395529663181837,0.75395529663181837,-1.3030955657229981E-2,-2.626774975108077E-2,-3.9715298278917996E-2,-5.3378675038007375E-2,-6.7263118008344239E-2,-8.1374036047765233E-2,-9.5717015917411177E-2,-0.11029782965665617,-0.12512244232799788,-0.14019702015368551,-0.14019702015368551,-0.1401970201536841,-0.14019702015368551,-0.1401970201536841,-0.1401970201536841,-0.1401970201536841,-0.1401970201536841,-0.1401970201536841,-0.1401970201536841,-0.1401970201536841,10082098283.419893,9482247513.7716827,599850769.64820778,23.999999999999989,120,0.01]
[null,120,0.02,"120|0.02",13019028.165603742,37946456.501641244,73742716.150074244,119435256.11205505,174114717.44096577,236931311.87759113,307091394.44740808,383854220.06204873,466528874.66359895,554471371.92275178,638662767.40307832,719263060.70651877,796425426.8074429,870296507.15050769,941016688.33201993,1008720368.8944156,1073536214.7408797,1135587403.655504,1194991859.3936751,1251862475.787564,542459.50690015592,1581102.3542350517,3072613.17291976,4976469.0046689603,7254779.8933735741,9872137.9948996324,12795474.768642006,15993925.835918698,19438703.11098329,23102973.830114663,26610948.641794935,29969294.196104959,33184392.783643462,36262354.464604497,39209028.680500843,42030015.370600663,44730675.614203326,47316141.818979345,49791327.474736482,52160936.491148524,12476568.658703586,36365354.147406191,70670102.977154478,114458787.1073861,166859937.54759219,227059173.8826915,294295919.67876607,367860294.22613001,447090171.55261564,531368398.09263718,612051818.7612834,689293766.51041389,763241034.02379942,834034152.68590319,901807659.65151906,966690353.52381492,1028805539.1266763,1088271261.8365245,1145200531.9189386,1199701539.2964156,-0.17883046335710162,-0.35766092671420041,-0.53649139007130209,-0.71532185342840371,-0.89415231678550244,-1.0729827801426042,-1.2518132434997042,-1.4306437068568045,-1.6094741702139048,-1.7883046335710064,-1.7883046335710064,-1.7883046335710064,-1.7883046335710064,-1.7883046335710064,-1.7883046335710064,-1.7883046335710064,-1.7883046335710064,-1.7883046335710049,-1.7883046335710064,-1.7883046335710049,0.15256271360601942,0.30428225167619305,0.45511735402353687,0.60502402377174758,0.75395529663181837,0.90186098643628743,1.0486874040309444,1.194377046211885,1.3388682509166048,1.4820948143193804,1.4820948143193804,1.4820948143193804,1.4820948143193819,1.4820948143193819,1.4820948143193819,1.4820948143193819,1.4820948143193804,1.4820948143193791,1.4820948143193804,1.4820948143193817,-2.6267749751082193E-2,-5.3378675038007375E-2,-8.1374036047765233E-2,-0.11029782965665617,-0.1401970201536841,-0.1711217937063168,-0.20312583946875976,-0.23626666064491958,-0.2706059192973001,-0.30620981925162594,-0.30620981925162594,-0.30620981925162594,-0.30620981925162455,-0.30620981925162455,-0.30620981925162455,-0.30620981925162455,-0.30620981925162594,-0.30620981925162594,-0.30620981925162594,-0.30620981925162311,10082098283.419893,8882396744.123476,1199701539.2964156,23.999999999999989,120,0.02]
[]
[]
[null,"Chart Label","Benefits"]
[null,"Chart Label","Net Benefits"]
[null,"Chart Label","Costs"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Five Percent Penetration",null,"Ten Percent Penetration"]
[null,null,"Lower Avoided Costs","Higher Avoided Costs","Lower Avoided Costs","Higher Avoided Costs"]
[null,"PVRR Without PV ($ Mil)",{"$f":"$DU$10","v":10082098283.419893},{"$f":"DU13","v":10082098283.419893},{"$f":"DU11","v":10082098283.419893},{"$f":"DU13","v":10082098283.419893}]
[null,"PVRR With PV ($ Mil)",{"$f":"$DV$10","v":9938655708.0692348},{"$f":"$DV$14","v":9482247513.7716827},{"$f":"DV11","v":9795213132.7185764},{"$f":"DV14","v":9482247513.7716827}]
[null,"Net Benefits ($ Mil)",{"$f":"C81-C82","v":143442575.35065842},{"$f":"D81-D82","v":599850769.64821053},286885150.70131683,599850769.64821053]
[null,"Benefit-Cost Ratio",{"$f":"$DX$10","v":11.999999999999995},{"$f":"DX13","v":23.999999999999989},{"$f":"DX11","v":11.999999999999995},{"$f":"DX15","v":23.999999999999989}]
[null,"Cumulative Rate Impact by 2024",{"$f":"DT10/Reference!$C$18","v":1.7833446478300707E-2},{"$f":"DT13/Reference!$C$18","v":-6.8377152769846976E-3},{"$f":"DT11/Reference!$C$18","v":3.7170385931527106E-2},{"$f":"DT14/Reference!$C$18","v":-1.42519011142727E-2}]