{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["10. RTSR - Current Rates","11. RTSR-UTRs & Sub-Tx","12. RTSR-Historic Wholesale","13. RTSR-Current Wholesale","14. RTSR-Forecast Wholesale","15. RTSR-Rates to Forecast"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":6,"defined_names":33,"comments":1,"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":"10. RTSR - Current Rates","index":0,"n_rows":31,"n_cols":53,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,1,8,4],[12,1,12,8]]}
["Back to Index","Back to Index",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"INCENTIVE REGULATION MODEL FOR 2018 FILERS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Columns F and G must match the data from the most recent RRR filing.  \nRates have been imported from Tab 2.  As well, the Loss Factor has been imported from \"Model Specs\" tab. \nIf the data needs to be modified, please make the necessary adjustments and note the changes in your manager's summary.  "]
[]
[null,"Rate Class","Rate Description","Unit","Rate","Non-Loss Adjusted Metered kWh","Non-Loss Adjusted Metered kW","Applicable Loss Factor","Loss Adjusted Billed kWh"]
["R_TN","RESIDENTIAL SERVICE CLASSIFICATION","Retail Transmission Rate – Network Service Rate","$/kWh",7.4000000000000003E-3,{"$f":"+[4]Sheet1!$C$2","v":1647803823.1021173},0,1.0379,{"$f":"F16*H16","v":1710255587.9976876}]
["R_TC","RESIDENTIAL SERVICE CLASSIFICATION","Retail Transmission Rate – Line and Transformation Connection Service Rate","$/kWh",5.8999999999999999E-3,{"$f":"F16","v":1647803823.1021173},0,{"$f":"H16","v":1.0379},{"$f":"F17*H17","v":1710255587.9976876}]
["GSL_TN","GENERAL SERVICE LESS THAN 50 kW SERVICE CLASSIFICATION","Retail Transmission Rate – Network Service Rate","$/kWh",6.4999999999999997E-3,{"$f":"+[4]Sheet1!$C$3","v":595148676.14955509},0,{"$f":"H17","v":1.0379},617704810.97562325]
["GSL_TC","GENERAL SERVICE LESS THAN 50 kW SERVICE CLASSIFICATION","Retail Transmission Rate – Line and Transformation Connection Service Rate","$/kWh",5.3E-3,{"$f":"F18","v":595148676.14955509},0,1.0379,617704810.97562325]
["GS50_499_TN","GENERAL SERVICE GREATER THAN 50 kW SERVICE CLASSIFICATION","Retail Transmission Rate – Network Service Rate","$/kW",2.5720999999999998,{"$f":"+[4]Sheet1!$C$4","v":1811883808.7715611},{"$f":"+[4]Sheet1!$D$4","v":4895437.1512875455}]
["GS50_499_TC","GENERAL SERVICE GREATER THAN 50 kW SERVICE CLASSIFICATION","Retail Transmission Rate – Line and Transformation Connection Service Rate","$/kW",2.1213000000000002,{"$f":"F20","v":1811883808.7715611},{"$f":"G20","v":4895437.1512875455}]
["GS500_TN","LARGE USE 1 SERVICE CLASSIFICATION","Retail Transmission Rate – Network Service Rate","$/kW",2.9382000000000001,{"$f":"+[4]Sheet1!$C$5","v":213955305.99403575},{"$f":"+[4]Sheet1!$D$5","v":512415.67000000004}]
["GS500_TC","LARGE USE 1 SERVICE CLASSIFICATION","Retail Transmission Rate – Line and Transformation Connection Service Rate","$/kW",2.4376000000000002,{"$f":"F22","v":213955305.99403575},{"$f":"G22","v":512415.67000000004}]
["LU_TN","LARGE USE 2 SERVICE CLASSIFICATION","Retail Transmission Rate – Network Service Rate – Interval Metered","$/kW",2.9382000000000001,{"$f":"+[4]Sheet1!$C$6","v":350315952.98508948},{"$f":"+[4]Sheet1!$D$6","v":1901226.94}]
["LU_TC","LARGE USE 2 SERVICE CLASSIFICATION","Retail Transmission Rate – Line and Transformation Connection Service Rate – Interval Metered ","$/kW",2.4376000000000002,{"$f":"F24","v":350315952.98508948},{"$f":"G24","v":1901226.94}]
["USL_TN","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","Retail Transmission Rate – Network Service Rate","$/kWh",6.6E-3,{"$f":"+[4]Sheet1!$C$7","v":11571071.95690605},{"$f":"'[1]4. Billing Det. for Def-Var'!E23","v":0},{"$f":"+H19","v":1.0379},12009615.584072791]
["USL_TC","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","Retail Transmission Rate – Line and Transformation Connection Service Rate","$/kWh",5.4000000000000003E-3,{"$f":"F26","v":11571071.95690605},{"$f":"G26","v":0},1.0379,12009615.584072791]
[null,"SENTINEL LIGHTING","Retail Transmission Rate – Network Service Rate","$/kW",2.1373000000000002,{"$f":"+[4]Sheet1!$C$8","v":438984.64842993952},{"$f":"+[4]Sheet1!$D$8","v":1213.4230761028894}]
[null,"SENTINEL LIGHTING","Retail Transmission Rate – Line and Transformation Connection Service Rate","$/kW",1.7069000000000001,{"$f":"F28","v":438984.64842993952},{"$f":"G28","v":1213.4230761028894}]
["SL_TN","STREET LIGHTING SERVICE CLASSIFICATION","Retail Transmission Rate – Network Service Rate","$/kW",2.0247999999999999,{"$f":"+[4]Sheet1!$C$9","v":31864627.859138645},{"$f":"+[4]Sheet1!$D$9","v":88666.23}]
["SL_TC","STREET LIGHTING SERVICE CLASSIFICATION","Retail Transmission Rate – Line and Transformation Connection Service Rate","$/kW",1.6641999999999999,{"$f":"F30","v":31864627.859138645},{"$f":"G30","v":88666.23}]

{"sheet":"11. RTSR-UTRs & Sub-Tx","index":1,"n_rows":68,"n_cols":9,"rows_kept":68,"cut":false,"hidden":false,"merged":[[1,1,8,6]]}
["Back to Index"]
[null,"INCENTIVE REGULATION MODEL FOR 2018 FILERS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Uniform Transmission Rates","Unit",null,2016,null,2017,null,2018]
[]
[null,"Rate Description",null,null,"Rate",null,"Rate",null,"Rate"]
[]
[null,"Network Service Rate","kW",null,3.66,null,3.66,null,{"$f":"G16","v":3.66}]
[]
[null,"Line Connection Service Rate","kW",null,0.87,null,0.87,null,{"$f":"G18","v":0.87}]
[]
[null,"Transformation Connection Service Rate","kW",null,2.02,null,2.02,null,{"$f":"G20","v":2.02}]
[]
[]
[null,"Hydro One Sub-Transmission Rates","Unit",null,2016,null,2017,null,2018]
[null,null,null,null,"Feb - Dec 2016",null,"Jan - Dec 2017"]
[]
[]
[null,"Rate Description",null,null,"Rate",null,"Rate",null,"Rate"]
[]
[null,"Network Service Rate","kW",null,3.3395999999999999,null,3.1941999999999999,null,{"$f":"G29","v":3.1941999999999999}]
[]
[null,"Line Connection Service Rate","kW",null,0.77910000000000001,null,0.77100000000000002,null,{"$f":"G31","v":0.77100000000000002}]
[]
[null,"Transformation Connection Service Rate","kW",null,1.7713000000000001,null,1.7493000000000001,null,{"$f":"G33","v":1.7493000000000001}]
[]
[null,"Both Line and Transformation Connection Service Rate","kW",null,2.5504000000000002,null,{"$f":"SUM(G33,G31)","v":2.5203000000000002},null,{"$f":"G35","v":2.5203000000000002}]
[]
[]
[null,"If needed, add extra host here. (I)","Unit",null,2016,null,2017,null,2018]
[]
[]
[]
[null,"Rate Description",null,null,"Rate",null,"Rate",null,"Rate"]
[]
[null,"Network Service Rate","kW"]
[]
[null,"Line Connection Service Rate","kW"]
[]
[null,"Transformation Connection Service Rate","kW"]
[]
[null,"Both Line and Transformation Connection Service Rate","kW",null,{"$f":"E48+E46","v":0},null,{"$f":"G48+G46","v":0},null,{"$f":"I48+I46","v":0}]
[]
[]
[null,"If needed, add extra host here. (II)","Unit",null,2016,null,2017,null,2018]
[]
[]
[]
[null,"Rate Description",null,null,"Rate",null,"Rate",null,"Rate"]
[]
[null,"Network Service Rate","kW"]
[]
[null,"Line Connection Service Rate","kW"]
[]
[null,"Transformation Connection Service Rate","kW"]
[]
[null,"Both Line and Transformation Connection Service Rate","kW",null,{"$f":"E63+E61","v":0},null,{"$f":"G63+G61","v":0},null,{"$f":"I63+I61","v":0}]
[]
[null,null,null,null,"Historical 2016",null,"Current 2017",null,"Forecast 2018"]
[null,"Low Voltage Switchgear Credit (if applicable, enter as a negative value)","$"]

{"sheet":"12. RTSR-Historic Wholesale","index":2,"n_rows":112,"n_cols":16,"rows_kept":112,"cut":false,"hidden":false,"merged":[[33,3,33,5],[33,7,33,9],[33,11,33,13],[1,1,8,10],[12,1,12,11],[15,3,15,5],[15,7,15,9],[15,11,15,13],[52,3,52,5],[52,7,52,9],[52,11,52,13],[71,3,71,5],[71,7,71,9],[71,11,71,13],[90,3,90,5],[90,7,90,9],[90,11,90,13],[91,3,91,5],[91,7,91,9],[91,11,91,13]]}
["Back to Index"]
[null,"INCENTIVE REGULATION MODEL FOR 2018 FILERS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"In the green shaded cells, enter billing detail for wholesale transmission for the same reporting period as the billing determinants on Tab 10.   For Hydro One Sub-transmission Rates, if you are charged a combined Line and Transformer connection rate, please ensure that both the Line Connection and Transformation Connection columns are completed. \nIf any of the Hydro One Sub-transmission rates (column E, I and M) are highlighted in orange, please double check the billing data entered in \"Units Billed\" and \"Amount\" columns. The highlighted rates do not match the Hydro One Sub-transmission rates approved for that time period. If data has been entered correctly, please provide explanation for the discrepancy in rates.\n"]
[]
[]
[null,"IESO",null,"Network",null,null,null,"Line Connection",null,null,null,"Transformation Connection",null,null,null,"Total Line"]
[null,"Month",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Amount"]
[]
[null,"January",null,{"$f":"+'[5]UTR and ST Expenses'!C7","v":734503},{"$f":"IF(D19<>0,F19/D19,0)","v":3.66},{"$f":"+'[5]UTR and ST $ Expenses'!C7","v":2688280.98},null,{"$f":"+'[5]UTR and ST Expenses'!F7","v":712029},{"$f":"IF(H19<>0,J19/H19,0)","v":0.87},{"$f":"+'[5]UTR and ST $ Expenses'!F7","v":619465.23},null,{"$f":"+'[5]UTR and ST Expenses'!I7","v":778836},{"$f":"IF(L19<>0,N19/L19,0)","v":2.02},{"$f":"+'[5]UTR and ST $ Expenses'!I7","v":1573248.72},null,{"$f":"J19+N19","v":2192713.9500000002}]
[null,"February",null,{"$f":"+'[5]UTR and ST Expenses'!C8","v":737990},3.6599999999999997,{"$f":"+'[5]UTR and ST $ Expenses'!C8","v":2701043.4},null,{"$f":"+'[5]UTR and ST Expenses'!F8","v":709244},0.87,{"$f":"+'[5]UTR and ST $ Expenses'!F8","v":617042.28},null,{"$f":"+'[5]UTR and ST Expenses'!I8","v":774730},2.02,{"$f":"+'[5]UTR and ST $ Expenses'!I8","v":1564954.6},null,2181996.88]
[null,"March",null,{"$f":"+'[5]UTR and ST Expenses'!C9","v":716928},3.66,{"$f":"+'[5]UTR and ST $ Expenses'!C9","v":2623956.48},null,{"$f":"+'[5]UTR and ST Expenses'!F9","v":693561},0.86999999999999988,{"$f":"+'[5]UTR and ST $ Expenses'!F9","v":603398.06999999995},null,{"$f":"+'[5]UTR and ST Expenses'!I9","v":750140},2.02,{"$f":"+'[5]UTR and ST $ Expenses'!I9","v":1515282.8},null,2118680.87]
[null,"April",null,{"$f":"+'[5]UTR and ST Expenses'!C10","v":651166},3.66,{"$f":"+'[5]UTR and ST $ Expenses'!C10","v":2383267.56},null,{"$f":"+'[5]UTR and ST Expenses'!F10","v":653961},0.86999999999999988,{"$f":"+'[5]UTR and ST $ Expenses'!F10","v":568946.06999999995},null,{"$f":"+'[5]UTR and ST Expenses'!I10","v":706000},2.02,{"$f":"+'[5]UTR and ST $ Expenses'!I10","v":1426120},null,1995066.0699999998]
[null,"May",null,{"$f":"+'[5]UTR and ST Expenses'!C11","v":794359},3.66,{"$f":"+'[5]UTR and ST $ Expenses'!C11","v":2907353.94},null,{"$f":"+'[5]UTR and ST Expenses'!F11","v":811465},0.87000000000000011,{"$f":"+'[5]UTR and ST $ Expenses'!F11","v":705974.55},null,{"$f":"+'[5]UTR and ST Expenses'!I11","v":871725},2.02,{"$f":"+'[5]UTR and ST $ Expenses'!I11","v":1760884.5},null,2466859.0499999998]
[null,"June",null,{"$f":"+'[5]UTR and ST Expenses'!C12","v":917962},3.6599999999999997,{"$f":"+'[5]UTR and ST $ Expenses'!C12","v":3359740.92},null,{"$f":"+'[5]UTR and ST Expenses'!F12","v":896063},0.86999999999999988,{"$f":"+'[5]UTR and ST $ Expenses'!F12","v":779574.80999999994},null,{"$f":"+'[5]UTR and ST Expenses'!I12","v":964306},2.02,{"$f":"+'[5]UTR and ST $ Expenses'!I12","v":1947898.12},null,2727472.93]
[null,"July",null,{"$f":"+'[5]UTR and ST Expenses'!C13","v":929179},3.66,{"$f":"+'[5]UTR and ST $ Expenses'!C13","v":3400795.14},null,{"$f":"+'[5]UTR and ST Expenses'!F13","v":922239},0.87000000000000011,{"$f":"+'[5]UTR and ST $ Expenses'!F13","v":802347.93},null,{"$f":"+'[5]UTR and ST Expenses'!I13","v":992221},2.02,{"$f":"+'[5]UTR and ST $ Expenses'!I13","v":2004286.42},null,2806634.35]
[null,"August",null,{"$f":"+'[5]UTR and ST Expenses'!C14","v":933677},3.66,{"$f":"+'[5]UTR and ST $ Expenses'!C14","v":3417257.8200000003},null,{"$f":"+'[5]UTR and ST Expenses'!F14","v":938903},0.87,{"$f":"+'[5]UTR and ST $ Expenses'!F14","v":816845.61},null,{"$f":"+'[5]UTR and ST Expenses'!I14","v":1006595},2.02,{"$f":"+'[5]UTR and ST $ Expenses'!I14","v":2033321.9},null,2850167.51]
[null,"September",null,{"$f":"+'[5]UTR and ST Expenses'!C15","v":983345},3.66,{"$f":"+'[5]UTR and ST $ Expenses'!C15","v":3599042.7},null,{"$f":"+'[5]UTR and ST Expenses'!F15","v":947450},0.87,{"$f":"+'[5]UTR and ST $ Expenses'!F15","v":824281.5},null,{"$f":"+'[5]UTR and ST Expenses'!I15","v":1013822},2.02,{"$f":"+'[5]UTR and ST $ Expenses'!I15","v":2047920.44},null,2872201.94]
[null,"October",null,{"$f":"+'[5]UTR and ST Expenses'!C16","v":637333},3.6600000000000006,{"$f":"+'[5]UTR and ST $ Expenses'!C16","v":2332638.7800000003},null,{"$f":"+'[5]UTR and ST Expenses'!F16","v":644670},0.87,{"$f":"+'[5]UTR and ST $ Expenses'!F16","v":560862.9},null,{"$f":"+'[5]UTR and ST Expenses'!I16","v":704873},2.02,{"$f":"+'[5]UTR and ST $ Expenses'!I16","v":1423843.46},null,1984706.3599999999]
[null,"November",null,{"$f":"+'[5]UTR and ST Expenses'!C17","v":674104},3.66,{"$f":"+'[5]UTR and ST $ Expenses'!C17","v":2467220.64},null,{"$f":"+'[5]UTR and ST Expenses'!F17","v":660542},0.87000000000000011,{"$f":"+'[5]UTR and ST $ Expenses'!F17","v":574671.54},null,{"$f":"+'[5]UTR and ST Expenses'!I17","v":712676},2.02,{"$f":"+'[5]UTR and ST $ Expenses'!I17","v":1439605.52},null,2014277.06]
[null,"December",null,{"$f":"+'[6]UTR and ST Expenses'!$C$18","v":730627},3.6600000000000006,{"$f":"+'[6]UTR and ST $ Expenses'!$C$18","v":2674094.8200000003},null,{"$f":"+'[6]UTR and ST Expenses'!$F$18","v":701810},0.86999999999999988,{"$f":"+'[6]UTR and ST $ Expenses'!$F$18","v":610574.69999999995},null,{"$f":"+'[6]UTR and ST Expenses'!$I$18","v":759526},2.02,{"$f":"+'[6]UTR and ST $ Expenses'!$I$18","v":1534242.52},null,2144817.2199999997]
[]
[null,"Total",null,{"$f":"SUM(D19:D30)","v":9441173},{"$f":"IF(D32<>0,F32/D32,0)","v":3.66},{"$f":"SUM(F19:F30)","v":34554693.18},null,{"$f":"SUM(H19:H30)","v":9291937},{"$f":"IF(H32<>0,J32/H32,0)","v":0.87000000000000011},{"$f":"SUM(J19:J30)","v":8083985.1900000013},null,{"$f":"SUM(L19:L30)","v":10035450},{"$f":"IF(L32<>0,N32/L32,0)","v":2.02},{"$f":"SUM(N19:N30)","v":20271609},null,{"$f":"SUM(P19:P30)","v":28355594.189999998}]
[]
[null,"Hydro One",null,"Network",null,null,null,"Line Connection",null,null,null,"Transformation Connection",null,null,null,"Total Line"]
[]
[null,"Month",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Amount"]
[]
[null,"January",null,{"$f":"+'[5]UTR and ST Expenses'!C22","v":64506.32},{"$f":"IF(D38<>0,F38/D38,0)","v":3.3395999999999999},{"$f":"+'[5]UTR and ST $ Expenses'!C23","v":215425.30627199999},null,{"$f":"+'[5]UTR and ST Expenses'!F22","v":64965.95},{"$f":"IF(H38<>0,J38/H38,0)","v":0.77910000000000001},{"$f":"+'[5]UTR and ST $ Expenses'!F23","v":50614.971644999998},null,{"$f":"+'[5]UTR and ST Expenses'!I22","v":64965.95},{"$f":"IF(L38<>0,N38/L38,0)","v":1.7713000000000001},{"$f":"+'[5]UTR and ST $ Expenses'!I23","v":115074.187235},null,{"$f":"J38+N38","v":165689.15888}]
[null,"February",null,{"$f":"+'[5]UTR and ST Expenses'!C23","v":66023.570000000007},{"$f":"IF(D39<>0,F39/D39,0)","v":3.3395999999999999},{"$f":"+'[5]UTR and ST $ Expenses'!C24","v":220492.31437200002},null,{"$f":"+'[5]UTR and ST Expenses'!F23","v":67956.23},0.77910000000000001,{"$f":"+'[5]UTR and ST $ Expenses'!F24","v":52944.698792999996},null,{"$f":"+'[5]UTR and ST Expenses'!I23","v":67956.23},1.7713000000000001,{"$f":"+'[5]UTR and ST $ Expenses'!I24","v":120370.870199},null,{"$f":"J39+N39","v":173315.56899199999}]
[null,"March",null,{"$f":"+'[5]UTR and ST Expenses'!C24","v":62632.130000000005},3.3395999999999999,{"$f":"+'[5]UTR and ST $ Expenses'!C25","v":209166.261348},null,{"$f":"+'[5]UTR and ST Expenses'!F24","v":63404.639999999999},0.77910000000000001,{"$f":"+'[5]UTR and ST $ Expenses'!F25","v":49398.555024000001},null,{"$f":"+'[5]UTR and ST Expenses'!I24","v":63404.639999999999},1.7713000000000001,{"$f":"+'[5]UTR and ST $ Expenses'!I25","v":112308.63883200001},null,161707.19385600003]
[null,"April",null,{"$f":"+'[5]UTR and ST Expenses'!C25","v":54954.700000000004},3.3395999999999999,{"$f":"+'[5]UTR and ST $ Expenses'!C26","v":183526.71612},null,{"$f":"+'[5]UTR and ST Expenses'!F25","v":57469.57},0.77910000000000013,{"$f":"+'[5]UTR and ST $ Expenses'!F26","v":44774.541987000004},null,{"$f":"+'[5]UTR and ST Expenses'!I25","v":57469.57},1.7713000000000001,{"$f":"+'[5]UTR and ST $ Expenses'!I26","v":101795.84934100001},null,146570.391328]
[null,"May",null,{"$f":"+'[5]UTR and ST Expenses'!C26","v":70605.16},3.3395999999999999,{"$f":"+'[5]UTR and ST $ Expenses'!C27","v":235792.992336},null,{"$f":"+'[5]UTR and ST Expenses'!F26","v":75469.69},0.77910000000000001,{"$f":"+'[5]UTR and ST $ Expenses'!F27","v":58798.435479},null,{"$f":"+'[5]UTR and ST Expenses'!I26","v":75469.69},1.7712999999999999,{"$f":"+'[5]UTR and ST $ Expenses'!I27","v":133679.461897},null,192477.89737600001]
[null,"June",null,{"$f":"+'[5]UTR and ST Expenses'!C27","v":95410.989999999991},3.3395999999999999,{"$f":"+'[5]UTR and ST $ Expenses'!C28","v":318634.54220399994},null,{"$f":"+'[5]UTR and ST Expenses'!F27","v":96823.84},0.77910000000000001,{"$f":"+'[5]UTR and ST $ Expenses'!F28","v":75435.453743999999},null,{"$f":"+'[5]UTR and ST Expenses'!I27","v":96823.84},1.7713000000000003,{"$f":"+'[5]UTR and ST $ Expenses'!I28","v":171504.06779200002},null,246939.52153600001]
[null,"July",null,{"$f":"+'[5]UTR and ST Expenses'!C28","v":89077.069999999992},3.3395999999999999,{"$f":"+'[5]UTR and ST $ Expenses'!C29","v":297481.78297199996},null,{"$f":"+'[5]UTR and ST Expenses'!F28","v":89743.819999999992},0.77910000000000001,{"$f":"+'[5]UTR and ST $ Expenses'!F29","v":69919.410162},null,{"$f":"+'[5]UTR and ST Expenses'!I28","v":89743.819999999992},1.7713000000000001,{"$f":"+'[5]UTR and ST $ Expenses'!I29","v":158963.228366},null,228882.63852799998]
[null,"August",null,{"$f":"+'[5]UTR and ST Expenses'!C29","v":86613.790000000008},3.3395999999999999,{"$f":"+'[5]UTR and ST $ Expenses'!C30","v":289255.413084},null,{"$f":"+'[5]UTR and ST Expenses'!F29","v":87259.81},0.77910000000000001,{"$f":"+'[5]UTR and ST $ Expenses'!F30","v":67984.117971},null,{"$f":"+'[5]UTR and ST Expenses'!I29","v":87259.81},1.7712999999999999,{"$f":"+'[5]UTR and ST $ Expenses'!I30","v":154563.30145299999},null,222547.41942399999]
[null,"September",null,{"$f":"+'[5]UTR and ST Expenses'!C30","v":88333.25},3.3395999999999999,{"$f":"+'[5]UTR and ST $ Expenses'!C31","v":294997.72169999999},null,{"$f":"+'[5]UTR and ST Expenses'!F30","v":89160.26999999999},0.7790999999999999,{"$f":"+'[5]UTR and ST $ Expenses'!F31","v":69464.766356999986},null,{"$f":"+'[5]UTR and ST Expenses'!I30","v":89160.26999999999},1.7713000000000003,{"$f":"+'[5]UTR and ST $ Expenses'!I31","v":157929.586251},null,227394.35260799999]
[null,"October",null,{"$f":"+'[5]UTR and ST Expenses'!C31","v":53846.8},3.3395999999999999,{"$f":"+'[5]UTR and ST $ Expenses'!C32","v":179826.77327999999},null,{"$f":"+'[5]UTR and ST Expenses'!F31","v":56200.880000000005},0.77910000000000001,{"$f":"+'[5]UTR and ST $ Expenses'!F32","v":43786.105608000005},null,{"$f":"+'[5]UTR and ST Expenses'!I31","v":56200.880000000005},1.7712999999999999,{"$f":"+'[5]UTR and ST $ Expenses'!I32","v":99548.618744000007},null,143334.72435200002]
[null,"November",null,{"$f":"+'[5]UTR and ST Expenses'!C32","v":55834.17},3.3395999999999999,{"$f":"+'[5]UTR and ST $ Expenses'!C33","v":186463.79413199998},null,{"$f":"+'[5]UTR and ST Expenses'!F32","v":57643.19},0.77910000000000001,{"$f":"+'[5]UTR and ST $ Expenses'!F33","v":44909.809329000003},null,{"$f":"+'[5]UTR and ST Expenses'!I32","v":57643.19},1.7713000000000001,{"$f":"+'[5]UTR and ST $ Expenses'!I33","v":102103.38244700001},null,147013.19177600002]
[null,"December",null,{"$f":"+'[6]UTR and ST Expenses'!$C$33","v":71104.25},3.3395999999999999,{"$f":"+'[6]UTR and ST $ Expenses'!$C$34","v":237459.75329999998},null,{"$f":"+'[6]UTR and ST Expenses'!$F$33","v":71833.86},0.77910000000000001,{"$f":"+'[6]UTR and ST $ Expenses'!$F$34","v":55965.760326000003},null,{"$f":"+'[6]UTR and ST Expenses'!$I$33","v":71833.86},1.7713000000000001,{"$f":"+'[6]UTR and ST $ Expenses'!$I$34","v":127239.31621800001},null,183205.07654400001]
[]
[null,"Total",null,{"$f":"SUM(D38:D49)","v":858942.20000000007},{"$f":"IF(D51<>0,F51/D51,0)","v":3.3395999999999995},{"$f":"SUM(F38:F49)","v":2868523.3711199998},null,{"$f":"SUM(H38:H49)","v":877931.75000000012},{"$f":"IF(H51<>0,J51/H51,0)","v":0.77909999999999979},{"$f":"SUM(J38:J49)","v":683996.62642499991},null,{"$f":"SUM(L38:L49)","v":877931.75000000012},{"$f":"IF(L51<>0,N51/L51,0)","v":1.7712999999999997},{"$f":"SUM(N38:N49)","v":1555080.508775},null,{"$f":"SUM(P38:P49)","v":2239077.1351999999}]
[]
[null,"Add Extra Host Here (I)",null,"Network",null,null,null,"Line Connection",null,null,null,"Transformation Connection",null,null,null,"Total Line"]
[null,"(if needed)"]
[null,"Month",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Amount"]
[]
[null,"January",null,null,{"$f":"IF(D57<>0,F57/D57,0)","v":0},null,null,null,{"$f":"IF(H57<>0,J57/H57,0)","v":0},null,null,null,{"$f":"IF(L57<>0,N57/L57,0)","v":0},null,null,{"$f":"J57+N57","v":0}]
[null,"February",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"March",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"April",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"May",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"June",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"July",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"August",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"September",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"October",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"November",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"December",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[]
[null,"Total",null,{"$f":"SUM(D57:D68)","v":0},{"$f":"IF(D70<>0,F70/D70,0)","v":0},{"$f":"SUM(F57:F68)","v":0},null,{"$f":"SUM(H57:H68)","v":0},{"$f":"IF(H70<>0,J70/H70,0)","v":0},{"$f":"SUM(J57:J68)","v":0},null,{"$f":"SUM(L57:L68)","v":0},{"$f":"IF(L70<>0,N70/L70,0)","v":0},{"$f":"SUM(N57:N68)","v":0},null,{"$f":"SUM(P57:P68)","v":0}]
[]
[null,"Add Extra Host Here (II)",null,"Network",null,null,null,"Line Connection",null,null,null,"Transformation Connection",null,null,null,"Total Line"]
[null,"(if needed)"]
[null,"Month",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Amount"]
[]
[null,"January",null,null,{"$f":"IF(D76<>0,F76/D76,0)","v":0},null,null,null,{"$f":"IF(H76<>0,J76/H76,0)","v":0},null,null,null,{"$f":"IF(L76<>0,N76/L76,0)","v":0},null,null,{"$f":"J76+N76","v":0}]
[null,"February",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"March",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"April",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"May",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"June",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"July",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"August",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"September",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"October",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"November",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"December",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[]
[null,"Total",null,{"$f":"SUM(D76:D87)","v":0},{"$f":"IF(D89<>0,F89/D89,0)","v":0},{"$f":"SUM(F76:F87)","v":0},null,{"$f":"SUM(H76:H87)","v":0},{"$f":"IF(H89<>0,J89/H89,0)","v":0},{"$f":"SUM(J76:J87)","v":0},null,{"$f":"SUM(L76:L87)","v":0},{"$f":"IF(L89<>0,N89/L89,0)","v":0},{"$f":"SUM(N76:N87)","v":0},null,{"$f":"SUM(P76:P87)","v":0}]
[]
[null,"Total",null,"Network",null,null,null,"Line Connection",null,null,null,"Transformation Connection",null,null,null,"Total Line"]
[]
[null,"Month",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Amount"]
[]
[null,"January",null,{"$f":"D19+D38+D57+D76","v":799009.32},{"$f":"IF(D95<>0,F95/D95,0)","v":3.6341331866717153},{"$f":"F19+F38+F57+F76","v":2903706.2862720001},null,{"$f":"H19+H38+H57+H76","v":776994.95},{"$f":"IF(H95<>0,J95/H95,0)","v":0.86239968695420743},{"$f":"J19+J38+J57+J76","v":670080.20164500002},null,{"$f":"L19+L38+L57+L76","v":843801.95},{"$f":"IF(L95<>0,N95/L95,0)","v":2.0008521042585885},{"$f":"N19+N38+N57+N76","v":1688322.907235},null,{"$f":"J95+N95","v":2358403.1088800002}]
[null,"February",null,{"$f":"D20+D39+D58+D77","v":804013.57000000007},3.6336895587122982,{"$f":"F20+F39+F58+F77","v":2921535.7143719997},null,{"$f":"H20+H39+H58+H77","v":777200.23},0.86205195640896815,{"$f":"J20+J39+J58+J77","v":669986.97879299999},null,{"$f":"L20+L39+L58+L77","v":842686.23},1.9999442380813557,{"$f":"N20+N39+N58+N77","v":1685325.4701990001},null,2355312.448992]
[null,"March",null,779560.13,3.6342581313746765,2833122.7413479998,null,756965.64,0.86238607213928486,652796.62502399995,null,813544.64,2.0006172480369364,1627591.4388320001,null,2280388.0638560001]
[null,"April",null,706120.7,3.6350644813556667,2566794.2761200001,null,711430.57,0.86265707135272529,613720.61198699998,null,763469.57,2.0012793035628125,1527915.849341,null,2141636.4613279998]
[null,"May",null,864964.16,3.6338464386038836,3143146.9323359998,null,886934.69,0.86226527623922355,764772.98547900002,null,947194.69,2.0001843146914178,1894563.961897,null,2659336.9473759998]
[null,"June",null,1013372.99,3.6298337320042444,3678375.462204,null,992886.84,0.86113565947152637,855010.26374399988,null,1061129.8400000001,1.9973071229360586,2119402.1877920004,null,2974412.4515360002]
[null,"July",null,1018256.07,3.6319713988761202,3698276.9229720002,null,1011982.82,0.86193888169168731,872267.34016200004,null,1081964.82,1.9993715214936469,2163249.648366,null,3035516.9885280002]
[null,"August",null,1020290.79,3.6328008342445197,3706513.2330840002,null,1026162.81,0.8622703135879578,884829.72797100001,null,1093854.81,2.0001605162324969,2187885.2014529998,null,3072714.929424]
[null,"September",null,1071678.25,3.6335909791021703,3894040.4217000003,null,1036610.27,0.86218156642129351,893746.26635699999,null,1102982.27,1.9998961780691178,2205850.0262509999,null,3099596.2926079999]
[null,"October",null,691179.8,3.6350390351106903,2512465.5532800001,null,700870.88,0.86271098266773472,604649.00560799998,null,761073.88,2.0016349513190494,1523392.0787440001,null,2128041.0843520002]
[null,"November",null,729938.17,3.6354920775440469,2653684.434132,null,718185.19,0.86270415758503738,619581.34932899999,null,770319.19,2.0013897128111275,1541708.9024470001,null,2161290.251776]
[null,"December",null,801731.25,3.631584241352698,2911554.5733000003,null,773643.86,0.86155981426130623,666540.460326,null,831359.86,1.9985110132909232,1661481.8362179999,null,2328022.296544]
[]
[null,"Total",null,{"$f":"SUM(D95:D106)","v":10300115.200000001},{"$f":"IF(D108<>0,F108/D108,0)","v":3.6332813589424702},{"$f":"SUM(F95:F106)","v":37423216.551119998},null,{"$f":"SUM(H95:H106)","v":10169868.75},{"$f":"IF(H108<>0,J108/H108,0)","v":0.86215289813105989},{"$f":"SUM(J95:J106)","v":8767981.8164249994},null,{"$f":"SUM(L95:L106)","v":10913381.75},{"$f":"IF(L108<>0,N108/L108,0)","v":1.9999932201377455},{"$f":"SUM(N95:N106)","v":21826689.508775003},null,{"$f":"SUM(P95:P106)","v":30594671.325199999}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Low Voltage Switchgear Credit (if applicable)",null,{"$f":"'11. RTSR-UTRs & Sub-Tx'!E68","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total including deduction for Low Voltage Switchgear Credit",null,{"$f":"P108+P110","v":30594671.325199999}]

{"sheet":"13. RTSR-Current Wholesale","index":3,"n_rows":113,"n_cols":16,"rows_kept":113,"cut":false,"hidden":false,"merged":[[16,3,16,5],[16,7,16,9],[16,11,16,13],[1,1,8,9],[12,1,12,11],[15,3,15,5],[15,7,15,9],[15,11,15,13],[34,3,34,5],[34,7,34,9],[34,11,34,13],[53,3,53,5],[53,7,53,9],[53,11,53,13],[92,3,92,5],[92,7,92,9],[92,11,92,13],[72,3,72,5],[72,7,72,9],[72,11,72,13],[91,3,91,5],[91,7,91,9],[91,11,91,13]]}
["Back to Index"]
[null,"INCENTIVE REGULATION MODEL FOR 2018 FILERS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The purpose of this sheet is to calculate the expected billing when current 2017 Uniform Transmission Rates are applied against historical 2016 transmission units."]
[]
[]
[null,"IESO",null,"Network",null,null,null,"Line Connection",null,null,null,"Transformation Connection",null,null,null,"Total Line"]
[]
[null,"Month",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Amount"]
[]
[null,"January",null,{"$f":"'12. RTSR-Historic Wholesale'!D19","v":734503},{"$f":"'11. RTSR-UTRs & Sub-Tx'!G16","v":3.66},{"$f":"D20*E20","v":2688280.98},null,{"$f":"'12. RTSR-Historic Wholesale'!H19","v":712029},{"$f":"'11. RTSR-UTRs & Sub-Tx'!G18","v":0.87},{"$f":"H20*I20","v":619465.23},null,{"$f":"'12. RTSR-Historic Wholesale'!L19","v":778836},{"$f":"'11. RTSR-UTRs & Sub-Tx'!G20","v":2.02},{"$f":"L20*M20","v":1573248.72},null,{"$f":"J20+N20","v":2192713.9500000002}]
[null,"February",null,{"$f":"'12. RTSR-Historic Wholesale'!D20","v":737990},{"$f":"E20","v":3.66},{"$f":"D21*E21","v":2701043.4},null,{"$f":"'12. RTSR-Historic Wholesale'!H20","v":709244},{"$f":"I20","v":0.87},{"$f":"H21*I21","v":617042.28},null,{"$f":"'12. RTSR-Historic Wholesale'!L20","v":774730},{"$f":"M20","v":2.02},{"$f":"L21*M21","v":1564954.6},null,2181996.88]
[null,"March",null,{"$f":"'12. RTSR-Historic Wholesale'!D21","v":716928},{"$f":"E21","v":3.66},2623956.48,null,{"$f":"'12. RTSR-Historic Wholesale'!H21","v":693561},{"$f":"I21","v":0.87},603398.06999999995,null,{"$f":"'12. RTSR-Historic Wholesale'!L21","v":750140},{"$f":"M21","v":2.02},1515282.8,null,2118680.87]
[null,"April",null,{"$f":"'12. RTSR-Historic Wholesale'!D22","v":651166},3.66,2383267.56,null,{"$f":"'12. RTSR-Historic Wholesale'!H22","v":653961},0.87,568946.06999999995,null,{"$f":"'12. RTSR-Historic Wholesale'!L22","v":706000},2.02,1426120,null,1995066.0699999998]
[null,"May",null,{"$f":"'12. RTSR-Historic Wholesale'!D23","v":794359},3.66,2907353.94,null,{"$f":"'12. RTSR-Historic Wholesale'!H23","v":811465},0.87,705974.55,null,{"$f":"'12. RTSR-Historic Wholesale'!L23","v":871725},2.02,1760884.5,null,2466859.0499999998]
[null,"June",null,{"$f":"'12. RTSR-Historic Wholesale'!D24","v":917962},3.66,3359740.92,null,{"$f":"'12. RTSR-Historic Wholesale'!H24","v":896063},0.87,779574.80999999994,null,{"$f":"'12. RTSR-Historic Wholesale'!L24","v":964306},2.02,1947898.12,null,2727472.93]
[null,"July",null,{"$f":"'12. RTSR-Historic Wholesale'!D25","v":929179},3.66,3400795.14,null,{"$f":"'12. RTSR-Historic Wholesale'!H25","v":922239},0.87,802347.93,null,{"$f":"'12. RTSR-Historic Wholesale'!L25","v":992221},2.02,2004286.42,null,2806634.35]
[null,"August",null,{"$f":"'12. RTSR-Historic Wholesale'!D26","v":933677},3.66,3417257.8200000003,null,{"$f":"'12. RTSR-Historic Wholesale'!H26","v":938903},0.87,816845.61,null,{"$f":"'12. RTSR-Historic Wholesale'!L26","v":1006595},2.02,2033321.9,null,2850167.51]
[null,"September",null,{"$f":"'12. RTSR-Historic Wholesale'!D27","v":983345},3.66,3599042.7,null,{"$f":"'12. RTSR-Historic Wholesale'!H27","v":947450},0.87,824281.5,null,{"$f":"'12. RTSR-Historic Wholesale'!L27","v":1013822},2.02,2047920.44,null,2872201.94]
[null,"October",null,{"$f":"'12. RTSR-Historic Wholesale'!D28","v":637333},3.66,2332638.7800000003,null,{"$f":"'12. RTSR-Historic Wholesale'!H28","v":644670},0.87,560862.9,null,{"$f":"'12. RTSR-Historic Wholesale'!L28","v":704873},2.02,1423843.46,null,1984706.3599999999]
[null,"November",null,{"$f":"'12. RTSR-Historic Wholesale'!D29","v":674104},3.66,2467220.64,null,{"$f":"'12. RTSR-Historic Wholesale'!H29","v":660542},0.87,574671.54,null,{"$f":"'12. RTSR-Historic Wholesale'!L29","v":712676},2.02,1439605.52,null,2014277.06]
[null,"December",null,{"$f":"'12. RTSR-Historic Wholesale'!D30","v":730627},3.66,2674094.8200000003,null,{"$f":"'12. RTSR-Historic Wholesale'!H30","v":701810},0.87,610574.69999999995,null,{"$f":"'12. RTSR-Historic Wholesale'!L30","v":759526},2.02,1534242.52,null,2144817.2199999997]
[]
[null,"Total",null,{"$f":"SUM(D20:D31)","v":9441173},{"$f":"IF(D33<>0,F33/D33,0)","v":3.66},{"$f":"SUM(F20:F31)","v":34554693.18},null,{"$f":"SUM(H20:H31)","v":9291937},{"$f":"IF(H33<>0,J33/H33,0)","v":0.87000000000000011},{"$f":"SUM(J20:J31)","v":8083985.1900000013},null,{"$f":"SUM(L20:L31)","v":10035450},{"$f":"IF(L33<>0,N33/L33,0)","v":2.02},{"$f":"SUM(N20:N31)","v":20271609},null,{"$f":"SUM(P20:P31)","v":28355594.189999998}]
[]
[null,"Hydro One",null,"Network",null,null,null,"Line Connection",null,null,null,"Transformation Connection",null,null,null,"Total Line"]
[]
[null,"Month",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Amount"]
[]
[null,"January",null,{"$f":"'12. RTSR-Historic Wholesale'!D38","v":64506.32},{"$f":"'11. RTSR-UTRs & Sub-Tx'!G29","v":3.1941999999999999},{"$f":"D39*E39","v":206046.087344},null,{"$f":"'12. RTSR-Historic Wholesale'!H38","v":64965.95},{"$f":"'11. RTSR-UTRs & Sub-Tx'!G31","v":0.77100000000000002},{"$f":"H39*I39","v":50088.747450000003},null,{"$f":"'12. RTSR-Historic Wholesale'!L38","v":64965.95},{"$f":"'11. RTSR-UTRs & Sub-Tx'!G33","v":1.7493000000000001},{"$f":"L39*M39","v":113644.93633500001},null,{"$f":"J39+N39","v":163733.683785}]
[null,"February",null,{"$f":"'12. RTSR-Historic Wholesale'!D39","v":66023.570000000007},{"$f":"E39","v":3.1941999999999999},{"$f":"D40*E40","v":210892.48729400002},null,{"$f":"'12. RTSR-Historic Wholesale'!H39","v":67956.23},{"$f":"I39","v":0.77100000000000002},{"$f":"H40*I40","v":52394.25333},null,{"$f":"'12. RTSR-Historic Wholesale'!L39","v":67956.23},{"$f":"M39","v":1.7493000000000001},{"$f":"L40*M40","v":118875.83313899999},null,171270.086469]
[null,"March",null,{"$f":"'12. RTSR-Historic Wholesale'!D40","v":62632.130000000005},{"$f":"E40","v":3.1941999999999999},200059.549646,null,{"$f":"'12. RTSR-Historic Wholesale'!H40","v":63404.639999999999},{"$f":"I40","v":0.77100000000000002},48884.977440000002,null,{"$f":"'12. RTSR-Historic Wholesale'!L40","v":63404.639999999999},{"$f":"M40","v":1.7493000000000001},110913.736752,null,159798.71419199998]
[null,"April",null,{"$f":"'12. RTSR-Historic Wholesale'!D41","v":54954.700000000004},3.1941999999999999,175536.30274000001,null,{"$f":"'12. RTSR-Historic Wholesale'!H41","v":57469.57},0.77100000000000002,44309.03847,null,{"$f":"'12. RTSR-Historic Wholesale'!L41","v":57469.57},{"$f":"M41","v":1.7493000000000001},100531.518801,null,144840.557271]
[null,"May",null,{"$f":"'12. RTSR-Historic Wholesale'!D42","v":70605.16},3.1941999999999999,225527.002072,null,{"$f":"'12. RTSR-Historic Wholesale'!H42","v":75469.69},0.77100000000000002,58187.130990000005,null,{"$f":"'12. RTSR-Historic Wholesale'!L42","v":75469.69},1.7493000000000001,132019.12871700001,null,190206.25970700002]
[null,"June",null,{"$f":"'12. RTSR-Historic Wholesale'!D43","v":95410.989999999991},3.1941999999999999,304761.78425799997,null,{"$f":"'12. RTSR-Historic Wholesale'!H43","v":96823.84},0.77100000000000002,74651.180640000006,null,{"$f":"'12. RTSR-Historic Wholesale'!L43","v":96823.84},1.7493000000000001,169373.94331199999,null,244025.12395199999]
[null,"July",null,{"$f":"'12. RTSR-Historic Wholesale'!D44","v":89077.069999999992},3.1941999999999999,284529.97699399997,null,{"$f":"'12. RTSR-Historic Wholesale'!H44","v":89743.819999999992},0.77100000000000002,69192.485220000002,null,{"$f":"'12. RTSR-Historic Wholesale'!L44","v":89743.819999999992},1.7493000000000001,156988.86432599998,null,226181.34954599998]
[null,"August",null,{"$f":"'12. RTSR-Historic Wholesale'!D45","v":86613.790000000008},3.1941999999999999,276661.768018,null,{"$f":"'12. RTSR-Historic Wholesale'!H45","v":87259.81},0.77100000000000002,67277.313509999993,null,{"$f":"'12. RTSR-Historic Wholesale'!L45","v":87259.81},1.7493000000000001,152643.58563300001,null,219920.89914300002]
[null,"September",null,{"$f":"'12. RTSR-Historic Wholesale'!D46","v":88333.25},3.1941999999999999,282154.06715000002,null,{"$f":"'12. RTSR-Historic Wholesale'!H46","v":89160.26999999999},0.77100000000000002,68742.568169999999,null,{"$f":"'12. RTSR-Historic Wholesale'!L46","v":89160.26999999999},1.7493000000000001,155968.06031099998,null,224710.62848099996]
[null,"October",null,{"$f":"'12. RTSR-Historic Wholesale'!D47","v":53846.8},3.1941999999999999,171997.44856000002,null,{"$f":"'12. RTSR-Historic Wholesale'!H47","v":56200.880000000005},0.77100000000000002,43330.878480000007,null,{"$f":"'12. RTSR-Historic Wholesale'!L47","v":56200.880000000005},1.7493000000000001,98312.199384000007,null,141643.07786400002]
[null,"November",null,{"$f":"'12. RTSR-Historic Wholesale'!D48","v":55834.17},3.1941999999999999,178345.505814,null,{"$f":"'12. RTSR-Historic Wholesale'!H48","v":57643.19},0.77100000000000002,44442.899490000003,null,{"$f":"'12. RTSR-Historic Wholesale'!L48","v":57643.19},1.7493000000000001,100835.23226700001,null,145278.13175700002]
[null,"December",null,{"$f":"'12. RTSR-Historic Wholesale'!D49","v":71104.25},3.1941999999999999,227121.19534999999,null,{"$f":"'12. RTSR-Historic Wholesale'!H49","v":71833.86},0.77100000000000002,55383.906060000001,null,{"$f":"'12. RTSR-Historic Wholesale'!L49","v":71833.86},1.7493000000000001,125658.971298,null,181042.877358]
[]
[null,"Total",null,{"$f":"SUM(D39:D50)","v":858942.20000000007},{"$f":"IF(D52<>0,F52/D52,0)","v":3.1941999999999995},{"$f":"SUM(F39:F50)","v":2743633.1752399998},null,{"$f":"SUM(H39:H50)","v":877931.75000000012},{"$f":"IF(H52<>0,J52/H52,0)","v":0.7709999999999998},{"$f":"SUM(J39:J50)","v":676885.37924999988},null,{"$f":"SUM(L39:L50)","v":877931.75000000012},{"$f":"IF(L52<>0,N52/L52,0)","v":1.7492999999999999},{"$f":"SUM(N39:N50)","v":1535766.010275},null,{"$f":"SUM(P39:P50)","v":2212651.389525}]
[]
[null,{"$f":"'[2]12. RTSR - Historical Wholesale'!B53","v":"Add Extra Host Here (I)"},null,"Network",null,null,null,"Line Connection",null,null,null,"Transformation Connection",null,null,null,"Total Line"]
[]
[null,"Month",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Amount"]
[]
[null,"January",null,{"$f":"'12. RTSR-Historic Wholesale'!D57","v":0},{"$f":"'11. RTSR-UTRs & Sub-Tx'!G44","v":0},{"$f":"D58*E58","v":0},null,{"$f":"'12. RTSR-Historic Wholesale'!H57","v":0},{"$f":"'11. RTSR-UTRs & Sub-Tx'!G46","v":0},{"$f":"H58*I58","v":0},null,{"$f":"'12. RTSR-Historic Wholesale'!L57","v":0},{"$f":"'11. RTSR-UTRs & Sub-Tx'!G48","v":0},{"$f":"L58*M58","v":0},null,{"$f":"J58+N58","v":0}]
[null,"February",null,{"$f":"'12. RTSR-Historic Wholesale'!D58","v":0},{"$f":"E58","v":0},{"$f":"D59*E59","v":0},null,{"$f":"'12. RTSR-Historic Wholesale'!H58","v":0},{"$f":"I58","v":0},{"$f":"H59*I59","v":0},null,{"$f":"'12. RTSR-Historic Wholesale'!L58","v":0},{"$f":"M58","v":0},{"$f":"L59*M59","v":0},null,0]
[null,"March",null,{"$f":"'12. RTSR-Historic Wholesale'!D59","v":0},{"$f":"E59","v":0},0,null,{"$f":"'12. RTSR-Historic Wholesale'!H59","v":0},{"$f":"I59","v":0},0,null,{"$f":"'12. RTSR-Historic Wholesale'!L59","v":0},{"$f":"M59","v":0},0,null,0]
[null,"April",null,{"$f":"'12. RTSR-Historic Wholesale'!D60","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H60","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L60","v":0},0,0,null,0]
[null,"May",null,{"$f":"'12. RTSR-Historic Wholesale'!D61","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H61","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L61","v":0},0,0,null,0]
[null,"June",null,{"$f":"'12. RTSR-Historic Wholesale'!D62","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H62","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L62","v":0},0,0,null,0]
[null,"July",null,{"$f":"'12. RTSR-Historic Wholesale'!D63","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H63","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L63","v":0},0,0,null,0]
[null,"August",null,{"$f":"'12. RTSR-Historic Wholesale'!D64","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H64","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L64","v":0},0,0,null,0]
[null,"September",null,{"$f":"'12. RTSR-Historic Wholesale'!D65","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H65","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L65","v":0},0,0,null,0]
[null,"October",null,{"$f":"'12. RTSR-Historic Wholesale'!D66","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H66","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L66","v":0},0,0,null,0]
[null,"November",null,{"$f":"'12. RTSR-Historic Wholesale'!D67","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H67","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L67","v":0},0,0,null,0]
[null,"December",null,{"$f":"'12. RTSR-Historic Wholesale'!D68","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H68","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L68","v":0},0,0,null,0]
[]
[null,"Total",null,{"$f":"SUM(D58:D69)","v":0},{"$f":"IF(D71<>0,F71/D71,0)","v":0},{"$f":"SUM(F58:F69)","v":0},null,{"$f":"SUM(H58:H69)","v":0},{"$f":"IF(H71<>0,J71/H71,0)","v":0},{"$f":"SUM(J58:J69)","v":0},null,{"$f":"SUM(L58:L69)","v":0},{"$f":"IF(L71<>0,N71/L71,0)","v":0},{"$f":"SUM(N58:N69)","v":0},null,{"$f":"SUM(P58:P69)","v":0}]
[]
[null,{"$f":"'[2]12. RTSR - Historical Wholesale'!B72","v":"Add Extra Host Here (II)"},null,"Network",null,null,null,"Line Connection",null,null,null,"Transformation Connection",null,null,null,"Total Line"]
[]
[null,"Month",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Amount"]
[]
[null,"January",null,{"$f":"'12. RTSR-Historic Wholesale'!D76","v":0},{"$f":"'11. RTSR-UTRs & Sub-Tx'!G59","v":0},{"$f":"D77*E77","v":0},null,{"$f":"'12. RTSR-Historic Wholesale'!H76","v":0},{"$f":"'11. RTSR-UTRs & Sub-Tx'!G61","v":0},{"$f":"H77*I77","v":0},null,{"$f":"'12. RTSR-Historic Wholesale'!L76","v":0},{"$f":"'11. RTSR-UTRs & Sub-Tx'!G63","v":0},{"$f":"L77*M77","v":0},null,{"$f":"J77+N77","v":0}]
[null,"February",null,{"$f":"'12. RTSR-Historic Wholesale'!D77","v":0},{"$f":"E77","v":0},{"$f":"D78*E78","v":0},null,{"$f":"'12. RTSR-Historic Wholesale'!H77","v":0},{"$f":"I77","v":0},{"$f":"H78*I78","v":0},null,{"$f":"'12. RTSR-Historic Wholesale'!L77","v":0},{"$f":"M77","v":0},{"$f":"L78*M78","v":0},null,0]
[null,"March",null,{"$f":"'12. RTSR-Historic Wholesale'!D78","v":0},{"$f":"E78","v":0},0,null,{"$f":"'12. RTSR-Historic Wholesale'!H78","v":0},{"$f":"I78","v":0},0,null,{"$f":"'12. RTSR-Historic Wholesale'!L78","v":0},{"$f":"M78","v":0},0,null,0]
[null,"April",null,{"$f":"'12. RTSR-Historic Wholesale'!D79","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H79","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L79","v":0},{"$f":"M79","v":0},0,null,0]
[null,"May",null,{"$f":"'12. RTSR-Historic Wholesale'!D80","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H80","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L80","v":0},0,0,null,0]
[null,"June",null,{"$f":"'12. RTSR-Historic Wholesale'!D81","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H81","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L81","v":0},0,0,null,0]
[null,"July",null,{"$f":"'12. RTSR-Historic Wholesale'!D82","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H82","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L82","v":0},0,0,null,0]
[null,"August",null,{"$f":"'12. RTSR-Historic Wholesale'!D83","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H83","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L83","v":0},0,0,null,0]
[null,"September",null,{"$f":"'12. RTSR-Historic Wholesale'!D84","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H84","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L84","v":0},0,0,null,0]
[null,"October",null,{"$f":"'12. RTSR-Historic Wholesale'!D85","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H85","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L85","v":0},0,0,null,0]
[null,"November",null,{"$f":"'12. RTSR-Historic Wholesale'!D86","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H86","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L86","v":0},0,0,null,0]
[null,"December",null,{"$f":"'12. RTSR-Historic Wholesale'!D87","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H87","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L87","v":0},0,0,null,0]
[]
[null,"Total",null,{"$f":"SUM(D77:D88)","v":0},{"$f":"IF(D90<>0,F90/D90,0)","v":0},{"$f":"SUM(F77:F88)","v":0},null,{"$f":"SUM(H77:H88)","v":0},{"$f":"IF(H90<>0,J90/H90,0)","v":0},{"$f":"SUM(J77:J88)","v":0},null,{"$f":"SUM(L77:L88)","v":0},{"$f":"IF(L90<>0,N90/L90,0)","v":0},{"$f":"SUM(N77:N88)","v":0},null,{"$f":"SUM(P77:P88)","v":0}]
[]
[null,"Total",null,"Network",null,null,null,"Line Connection",null,null,null,"Transformation Connection",null,null,null,"Total Line"]
[]
[null,"Month",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Amount"]
[]
[null,"January",null,{"$f":"D20+D39+D58+D77","v":799009.32},{"$f":"IF(D96<>0,F96/D96,0)","v":3.622394626565808},{"$f":"F20+F39+F58+F77","v":2894327.0673440001},null,{"$f":"H20+H39+H58+H77","v":776994.95},{"$f":"IF(H96<>0,J96/H96,0)","v":0.86172243133626547},{"$f":"J20+J39+J58+J77","v":669553.97745000001},null,{"$f":"L20+L39+L58+L77","v":843801.95},{"$f":"IF(L96<>0,N96/L96,0)","v":1.9991582815552869},{"$f":"N20+N39+N58+N77","v":1686893.6563349999},null,{"$f":"J96+N96","v":2356447.6337850001}]
[null,"February",null,{"$f":"D21+D40+D59+D78","v":804013.57000000007},3.6217496768045838,{"$f":"F21+F40+F59+F78","v":2911935.887294},null,{"$f":"H21+H40+H59+H78","v":777200.23},0.86134371490085637,{"$f":"J21+J40+J59+J78","v":669436.53333000001},null,{"$f":"L21+L40+L59+L78","v":842686.23},1.9981701055433172,{"$f":"N21+N40+N59+N78","v":1683830.4331390001},null,2353266.9664690001]
[null,"March",null,779560.13,3.6225762721420858,2824016.0296459999,null,756965.64,0.86170760332001328,652283.04743999999,null,813544.64,1.9989026499541562,1626196.536752,null,2278479.5841919999]
[null,"April",null,706120.7,3.6237485499858599,2558803.8627400002,null,711430.57,0.86200275097821566,613255.10846999998,null,763469.57,1.9996232709065276,1526651.518801,null,2139906.6272709998]
[null,"May",null,864964.16,3.6219777500052714,3132880.9420719999,null,886934.69,0.8615760434288573,764161.68099000002,null,947194.69,1.998431419328375,1892903.6287170001,null,2657065.3097069999]
[null,"June",null,1013372.99,3.6161440460910645,3664502.704258,null,992886.84,0.86034576774126648,854225.99063999997,null,1061129.8400000001,1.995299711213474,2117272.0633120001,null,2971498.0539520001]
[null,"July",null,1018256.07,3.6192518027356324,3685325.116994,null,1011982.82,0.86122056421866933,871540.41522000008,null,1081964.82,1.9975467264508655,2161275.2843260001,null,3032815.699546]
[null,"August",null,1020290.79,3.6204576422943111,3693919.5880180001,null,1026162.81,0.86158152965025103,884122.92350999999,null,1093854.81,1.998405515657969,2185965.4856329998,null,3070088.4091429999]
[null,"September",null,1071678.25,3.621606361004341,3881196.7671500002,null,1036610.27,0.86148487432022058,893024.06816999998,null,1102982.27,1.9981177941427832,2203888.5003109998,null,3096912.5684809997]
[null,"October",null,691179.8,3.6237115560379514,2504636.2285600002,null,700870.88,0.86206146627179026,604193.77847999998,null,761073.88,2.0000103792604205,1522155.6593839999,null,2126349.437864]
[null,"November",null,729938.17,3.6243701926342613,2645566.1458140002,null,718185.19,0.86205403301340711,619114.43949000002,null,770319.19,1.99974344695606,1540440.752267,null,2159555.1917570001]
[null,"December",null,801731.25,3.6186889501313568,2901216.0153500005,null,773643.86,0.86080771850241267,665958.6060599999,null,831359.86,1.9966100976994487,1659901.4912980001,null,2325860.097358]
[]
[null,"Total",null,{"$f":"SUM(D96:D107)","v":10300115.200000001},{"$f":"IF(D109<>0,F109/D109,0)","v":3.6211562328196094},{"$f":"SUM(F96:F107)","v":37298326.355240002},null,{"$f":"SUM(H96:H107)","v":10169868.75},{"$f":"IF(H109<>0,J109/H109,0)","v":0.86145365142986718},{"$f":"SUM(J96:J107)","v":8760870.5692499988},null,{"$f":"SUM(L96:L107)","v":10913381.75},{"$f":"IF(L109<>0,N109/L109,0)","v":1.9982234205520208},{"$f":"SUM(N96:N107)","v":21807375.010274999},null,{"$f":"SUM(P96:P107)","v":30568245.579524998}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Low Voltage Switchgear Credit (if applicable)",null,{"$f":"'11. RTSR-UTRs & Sub-Tx'!G68","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total including deduction for Low Voltage Switchgear Credit",null,{"$f":"P109+P111","v":30568245.579524998}]

{"sheet":"14. RTSR-Forecast Wholesale","index":4,"n_rows":113,"n_cols":16,"rows_kept":113,"cut":false,"hidden":false,"merged":[[16,3,16,5],[16,7,16,9],[16,11,16,13],[1,1,8,9],[12,1,12,12],[15,3,15,5],[15,7,15,9],[15,11,15,13],[34,3,34,5],[34,7,34,9],[34,11,34,13],[53,3,53,5],[53,7,53,9],[53,11,53,13],[92,3,92,5],[92,7,92,9],[92,11,92,13],[72,3,72,5],[72,7,72,9],[72,11,72,13],[91,3,91,5],[91,7,91,9],[91,11,91,13]]}
["Back to Index"]
[null,"INCENTIVE REGULATION MODEL FOR 2018 FILERS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The purpose of this sheet is to calculate the expected billing when forecasted 2018 Uniform Transmission Rates are applied against historical 2016 transmission units."]
[]
[]
[null,"IESO",null,"Network",null,null,null,"Line Connection",null,null,null,"Transformation Connection",null,null,null,"Total Line"]
[]
[null,"Month",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Amount"]
[]
[null,"January",null,{"$f":"'12. RTSR-Historic Wholesale'!D19","v":734503},{"$f":"'11. RTSR-UTRs & Sub-Tx'!I16","v":3.66},{"$f":"D20*E20","v":2688280.98},null,{"$f":"'12. RTSR-Historic Wholesale'!H19","v":712029},{"$f":"'11. RTSR-UTRs & Sub-Tx'!I18","v":0.87},{"$f":"H20*I20","v":619465.23},null,{"$f":"'12. RTSR-Historic Wholesale'!L19","v":778836},{"$f":"'11. RTSR-UTRs & Sub-Tx'!I20","v":2.02},{"$f":"L20*M20","v":1573248.72},null,{"$f":"J20+N20","v":2192713.9500000002}]
[null,"February",null,{"$f":"'12. RTSR-Historic Wholesale'!D20","v":737990},{"$f":"E20","v":3.66},2701043.4,null,{"$f":"'12. RTSR-Historic Wholesale'!H20","v":709244},{"$f":"I20","v":0.87},617042.28,null,{"$f":"'12. RTSR-Historic Wholesale'!L20","v":774730},{"$f":"M20","v":2.02},1564954.6,null,2181996.88]
[null,"March",null,{"$f":"'12. RTSR-Historic Wholesale'!D21","v":716928},3.66,2623956.48,null,{"$f":"'12. RTSR-Historic Wholesale'!H21","v":693561},0.87,603398.06999999995,null,{"$f":"'12. RTSR-Historic Wholesale'!L21","v":750140},2.02,1515282.8,null,2118680.87]
[null,"April",null,{"$f":"'12. RTSR-Historic Wholesale'!D22","v":651166},3.66,2383267.56,null,{"$f":"'12. RTSR-Historic Wholesale'!H22","v":653961},0.87,568946.06999999995,null,{"$f":"'12. RTSR-Historic Wholesale'!L22","v":706000},2.02,1426120,null,1995066.0699999998]
[null,"May",null,{"$f":"'12. RTSR-Historic Wholesale'!D23","v":794359},3.66,2907353.94,null,{"$f":"'12. RTSR-Historic Wholesale'!H23","v":811465},0.87,705974.55,null,{"$f":"'12. RTSR-Historic Wholesale'!L23","v":871725},2.02,1760884.5,null,2466859.0499999998]
[null,"June",null,{"$f":"'12. RTSR-Historic Wholesale'!D24","v":917962},3.66,3359740.92,null,{"$f":"'12. RTSR-Historic Wholesale'!H24","v":896063},0.87,779574.80999999994,null,{"$f":"'12. RTSR-Historic Wholesale'!L24","v":964306},2.02,1947898.12,null,2727472.93]
[null,"July",null,{"$f":"'12. RTSR-Historic Wholesale'!D25","v":929179},3.66,3400795.14,null,{"$f":"'12. RTSR-Historic Wholesale'!H25","v":922239},0.87,802347.93,null,{"$f":"'12. RTSR-Historic Wholesale'!L25","v":992221},2.02,2004286.42,null,2806634.35]
[null,"August",null,{"$f":"'12. RTSR-Historic Wholesale'!D26","v":933677},3.66,3417257.8200000003,null,{"$f":"'12. RTSR-Historic Wholesale'!H26","v":938903},0.87,816845.61,null,{"$f":"'12. RTSR-Historic Wholesale'!L26","v":1006595},2.02,2033321.9,null,2850167.51]
[null,"September",null,{"$f":"'12. RTSR-Historic Wholesale'!D27","v":983345},3.66,3599042.7,null,{"$f":"'12. RTSR-Historic Wholesale'!H27","v":947450},0.87,824281.5,null,{"$f":"'12. RTSR-Historic Wholesale'!L27","v":1013822},2.02,2047920.44,null,2872201.94]
[null,"October",null,{"$f":"'12. RTSR-Historic Wholesale'!D28","v":637333},3.66,2332638.7800000003,null,{"$f":"'12. RTSR-Historic Wholesale'!H28","v":644670},0.87,560862.9,null,{"$f":"'12. RTSR-Historic Wholesale'!L28","v":704873},2.02,1423843.46,null,1984706.3599999999]
[null,"November",null,{"$f":"'12. RTSR-Historic Wholesale'!D29","v":674104},3.66,2467220.64,null,{"$f":"'12. RTSR-Historic Wholesale'!H29","v":660542},0.87,574671.54,null,{"$f":"'12. RTSR-Historic Wholesale'!L29","v":712676},2.02,1439605.52,null,2014277.06]
[null,"December",null,{"$f":"'12. RTSR-Historic Wholesale'!D30","v":730627},3.66,2674094.8200000003,null,{"$f":"'12. RTSR-Historic Wholesale'!H30","v":701810},0.87,610574.69999999995,null,{"$f":"'12. RTSR-Historic Wholesale'!L30","v":759526},2.02,1534242.52,null,2144817.2199999997]
[]
[null,"Total",null,{"$f":"SUM(D20:D31)","v":9441173},{"$f":"IF(D33<>0,F33/D33,0)","v":3.66},{"$f":"SUM(F20:F31)","v":34554693.18},null,{"$f":"SUM(H20:H31)","v":9291937},{"$f":"IF(H33<>0,J33/H33,0)","v":0.87000000000000011},{"$f":"SUM(J20:J31)","v":8083985.1900000013},null,{"$f":"SUM(L20:L31)","v":10035450},{"$f":"IF(L33<>0,N33/L33,0)","v":2.02},{"$f":"SUM(N20:N31)","v":20271609},null,{"$f":"SUM(P20:P31)","v":28355594.189999998}]
[]
[null,"Hydro One",null,"Network",null,null,null,"Line Connection",null,null,null,"Transformation Connection",null,null,null,"Total Line"]
[]
[null,"Month",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Amount"]
[]
[null,"January",null,{"$f":"'12. RTSR-Historic Wholesale'!D38","v":64506.32},{"$f":"'11. RTSR-UTRs & Sub-Tx'!I29","v":3.1941999999999999},{"$f":"D39*E39","v":206046.087344},null,{"$f":"'12. RTSR-Historic Wholesale'!H38","v":64965.95},{"$f":"'11. RTSR-UTRs & Sub-Tx'!I31","v":0.77100000000000002},{"$f":"H39*I39","v":50088.747450000003},null,{"$f":"'12. RTSR-Historic Wholesale'!L38","v":64965.95},{"$f":"'11. RTSR-UTRs & Sub-Tx'!I33","v":1.7493000000000001},{"$f":"L39*M39","v":113644.93633500001},null,{"$f":"J39+N39","v":163733.683785}]
[null,"February",null,{"$f":"'12. RTSR-Historic Wholesale'!D39","v":66023.570000000007},{"$f":"E39","v":3.1941999999999999},210892.48729400002,null,{"$f":"'12. RTSR-Historic Wholesale'!H39","v":67956.23},{"$f":"I39","v":0.77100000000000002},52394.25333,null,{"$f":"'12. RTSR-Historic Wholesale'!L39","v":67956.23},{"$f":"M39","v":1.7493000000000001},118875.83313899999,null,171270.086469]
[null,"March",null,{"$f":"'12. RTSR-Historic Wholesale'!D40","v":62632.130000000005},3.1941999999999999,200059.549646,null,{"$f":"'12. RTSR-Historic Wholesale'!H40","v":63404.639999999999},0.77100000000000002,48884.977440000002,null,{"$f":"'12. RTSR-Historic Wholesale'!L40","v":63404.639999999999},1.7493000000000001,110913.736752,null,159798.71419199998]
[null,"April",null,{"$f":"'12. RTSR-Historic Wholesale'!D41","v":54954.700000000004},3.1941999999999999,175536.30274000001,null,{"$f":"'12. RTSR-Historic Wholesale'!H41","v":57469.57},0.77100000000000002,44309.03847,null,{"$f":"'12. RTSR-Historic Wholesale'!L41","v":57469.57},1.7493000000000001,100531.518801,null,144840.557271]
[null,"May",null,{"$f":"'12. RTSR-Historic Wholesale'!D42","v":70605.16},3.1941999999999999,225527.002072,null,{"$f":"'12. RTSR-Historic Wholesale'!H42","v":75469.69},0.77100000000000002,58187.130990000005,null,{"$f":"'12. RTSR-Historic Wholesale'!L42","v":75469.69},1.7493000000000001,132019.12871700001,null,190206.25970700002]
[null,"June",null,{"$f":"'12. RTSR-Historic Wholesale'!D43","v":95410.989999999991},3.1941999999999999,304761.78425799997,null,{"$f":"'12. RTSR-Historic Wholesale'!H43","v":96823.84},0.77100000000000002,74651.180640000006,null,{"$f":"'12. RTSR-Historic Wholesale'!L43","v":96823.84},1.7493000000000001,169373.94331199999,null,244025.12395199999]
[null,"July",null,{"$f":"'12. RTSR-Historic Wholesale'!D44","v":89077.069999999992},3.1941999999999999,284529.97699399997,null,{"$f":"'12. RTSR-Historic Wholesale'!H44","v":89743.819999999992},0.77100000000000002,69192.485220000002,null,{"$f":"'12. RTSR-Historic Wholesale'!L44","v":89743.819999999992},1.7493000000000001,156988.86432599998,null,226181.34954599998]
[null,"August",null,{"$f":"'12. RTSR-Historic Wholesale'!D45","v":86613.790000000008},3.1941999999999999,276661.768018,null,{"$f":"'12. RTSR-Historic Wholesale'!H45","v":87259.81},0.77100000000000002,67277.313509999993,null,{"$f":"'12. RTSR-Historic Wholesale'!L45","v":87259.81},1.7493000000000001,152643.58563300001,null,219920.89914300002]
[null,"September",null,{"$f":"'12. RTSR-Historic Wholesale'!D46","v":88333.25},3.1941999999999999,282154.06715000002,null,{"$f":"'12. RTSR-Historic Wholesale'!H46","v":89160.26999999999},0.77100000000000002,68742.568169999999,null,{"$f":"'12. RTSR-Historic Wholesale'!L46","v":89160.26999999999},1.7493000000000001,155968.06031099998,null,224710.62848099996]
[null,"October",null,{"$f":"'12. RTSR-Historic Wholesale'!D47","v":53846.8},3.1941999999999999,171997.44856000002,null,{"$f":"'12. RTSR-Historic Wholesale'!H47","v":56200.880000000005},0.77100000000000002,43330.878480000007,null,{"$f":"'12. RTSR-Historic Wholesale'!L47","v":56200.880000000005},1.7493000000000001,98312.199384000007,null,141643.07786400002]
[null,"November",null,{"$f":"'12. RTSR-Historic Wholesale'!D48","v":55834.17},3.1941999999999999,178345.505814,null,{"$f":"'12. RTSR-Historic Wholesale'!H48","v":57643.19},0.77100000000000002,44442.899490000003,null,{"$f":"'12. RTSR-Historic Wholesale'!L48","v":57643.19},1.7493000000000001,100835.23226700001,null,145278.13175700002]
[null,"December",null,{"$f":"'12. RTSR-Historic Wholesale'!D49","v":71104.25},3.1941999999999999,227121.19534999999,null,{"$f":"'12. RTSR-Historic Wholesale'!H49","v":71833.86},0.77100000000000002,55383.906060000001,null,{"$f":"'12. RTSR-Historic Wholesale'!L49","v":71833.86},1.7493000000000001,125658.971298,null,181042.877358]
[]
[null,"Total",null,{"$f":"SUM(D39:D50)","v":858942.20000000007},{"$f":"IF(D52<>0,F52/D52,0)","v":3.1941999999999995},{"$f":"SUM(F39:F50)","v":2743633.1752399998},null,{"$f":"SUM(H39:H50)","v":877931.75000000012},{"$f":"IF(H52<>0,J52/H52,0)","v":0.7709999999999998},{"$f":"SUM(J39:J50)","v":676885.37924999988},null,{"$f":"SUM(L39:L50)","v":877931.75000000012},{"$f":"IF(L52<>0,N52/L52,0)","v":1.7492999999999999},{"$f":"SUM(N39:N50)","v":1535766.010275},null,{"$f":"SUM(P39:P50)","v":2212651.389525}]
[]
[null,{"$f":"'[2]12. RTSR - Historical Wholesale'!B53","v":"Add Extra Host Here (I)"},null,"Network",null,null,null,"Line Connection",null,null,null,"Transformation Connection",null,null,null,"Total Line"]
[]
[null,"Month",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Amount"]
[]
[null,"January",null,{"$f":"'12. RTSR-Historic Wholesale'!D57","v":0},{"$f":"'11. RTSR-UTRs & Sub-Tx'!I44","v":0},{"$f":"D58*E58","v":0},null,{"$f":"'12. RTSR-Historic Wholesale'!H57","v":0},{"$f":"'11. RTSR-UTRs & Sub-Tx'!I46","v":0},{"$f":"H58*I58","v":0},null,{"$f":"'12. RTSR-Historic Wholesale'!L57","v":0},{"$f":"'11. RTSR-UTRs & Sub-Tx'!I48","v":0},{"$f":"L58*M58","v":0},null,{"$f":"J58+N58","v":0}]
[null,"February",null,{"$f":"'12. RTSR-Historic Wholesale'!D58","v":0},{"$f":"E58","v":0},0,null,{"$f":"'12. RTSR-Historic Wholesale'!H58","v":0},{"$f":"I58","v":0},0,null,{"$f":"'12. RTSR-Historic Wholesale'!L58","v":0},{"$f":"M58","v":0},0,null,0]
[null,"March",null,{"$f":"'12. RTSR-Historic Wholesale'!D59","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H59","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L59","v":0},0,0,null,0]
[null,"April",null,{"$f":"'12. RTSR-Historic Wholesale'!D60","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H60","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L60","v":0},0,0,null,0]
[null,"May",null,{"$f":"'12. RTSR-Historic Wholesale'!D61","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H61","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L61","v":0},0,0,null,0]
[null,"June",null,{"$f":"'12. RTSR-Historic Wholesale'!D62","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H62","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L62","v":0},0,0,null,0]
[null,"July",null,{"$f":"'12. RTSR-Historic Wholesale'!D63","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H63","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L63","v":0},0,0,null,0]
[null,"August",null,{"$f":"'12. RTSR-Historic Wholesale'!D64","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H64","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L64","v":0},0,0,null,0]
[null,"September",null,{"$f":"'12. RTSR-Historic Wholesale'!D65","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H65","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L65","v":0},0,0,null,0]
[null,"October",null,{"$f":"'12. RTSR-Historic Wholesale'!D66","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H66","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L66","v":0},0,0,null,0]
[null,"November",null,{"$f":"'12. RTSR-Historic Wholesale'!D67","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H67","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L67","v":0},0,0,null,0]
[null,"December",null,{"$f":"'12. RTSR-Historic Wholesale'!D68","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H68","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L68","v":0},0,0,null,0]
[]
[null,"Total",null,{"$f":"SUM(D58:D69)","v":0},{"$f":"IF(D71<>0,F71/D71,0)","v":0},{"$f":"SUM(F58:F69)","v":0},null,{"$f":"SUM(H58:H69)","v":0},{"$f":"IF(H71<>0,J71/H71,0)","v":0},{"$f":"SUM(J58:J69)","v":0},null,{"$f":"SUM(L58:L69)","v":0},{"$f":"IF(L71<>0,N71/L71,0)","v":0},{"$f":"SUM(N58:N69)","v":0},null,{"$f":"SUM(P58:P69)","v":0}]
[]
[null,{"$f":"'[2]12. RTSR - Historical Wholesale'!B72","v":"Add Extra Host Here (II)"},null,"Network",null,null,null,"Line Connection",null,null,null,"Transformation Connection",null,null,null,"Total Line"]
[]
[null,"Month",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Amount"]
[]
[null,"January",null,{"$f":"'12. RTSR-Historic Wholesale'!D76","v":0},{"$f":"'11. RTSR-UTRs & Sub-Tx'!I59","v":0},{"$f":"D77*E77","v":0},null,{"$f":"'12. RTSR-Historic Wholesale'!H76","v":0},{"$f":"'11. RTSR-UTRs & Sub-Tx'!I61","v":0},{"$f":"H77*I77","v":0},null,{"$f":"'12. RTSR-Historic Wholesale'!L76","v":0},{"$f":"'11. RTSR-UTRs & Sub-Tx'!I63","v":0},{"$f":"L77*M77","v":0},null,{"$f":"J77+N77","v":0}]
[null,"February",null,{"$f":"'12. RTSR-Historic Wholesale'!D77","v":0},{"$f":"E77","v":0},0,null,{"$f":"'12. RTSR-Historic Wholesale'!H77","v":0},{"$f":"I77","v":0},0,null,{"$f":"'12. RTSR-Historic Wholesale'!L77","v":0},{"$f":"M77","v":0},0,null,0]
[null,"March",null,{"$f":"'12. RTSR-Historic Wholesale'!D78","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H78","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L78","v":0},0,0,null,0]
[null,"April",null,{"$f":"'12. RTSR-Historic Wholesale'!D79","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H79","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L79","v":0},0,0,null,0]
[null,"May",null,{"$f":"'12. RTSR-Historic Wholesale'!D80","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H80","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L80","v":0},0,0,null,0]
[null,"June",null,{"$f":"'12. RTSR-Historic Wholesale'!D81","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H81","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L81","v":0},0,0,null,0]
[null,"July",null,{"$f":"'12. RTSR-Historic Wholesale'!D82","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H82","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L82","v":0},0,0,null,0]
[null,"August",null,{"$f":"'12. RTSR-Historic Wholesale'!D83","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H83","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L83","v":0},0,0,null,0]
[null,"September",null,{"$f":"'12. RTSR-Historic Wholesale'!D84","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H84","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L84","v":0},0,0,null,0]
[null,"October",null,{"$f":"'12. RTSR-Historic Wholesale'!D85","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H85","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L85","v":0},0,0,null,0]
[null,"November",null,{"$f":"'12. RTSR-Historic Wholesale'!D86","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H86","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L86","v":0},0,0,null,0]
[null,"December",null,{"$f":"'12. RTSR-Historic Wholesale'!D87","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!H87","v":0},0,0,null,{"$f":"'12. RTSR-Historic Wholesale'!L87","v":0},0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'12. RTSR-Historic Wholesale'!L88","v":0}]
[null,"Total",null,{"$f":"SUM(D77:D88)","v":0},{"$f":"IF(D90<>0,F90/D90,0)","v":0},{"$f":"SUM(F77:F88)","v":0},null,{"$f":"SUM(H77:H88)","v":0},{"$f":"IF(H90<>0,J90/H90,0)","v":0},{"$f":"SUM(J77:J88)","v":0},null,{"$f":"SUM(L77:L88)","v":0},{"$f":"IF(L90<>0,N90/L90,0)","v":0},{"$f":"SUM(N77:N88)","v":0},null,{"$f":"SUM(P77:P88)","v":0}]
[]
[null,"Total",null,"Network",null,null,null,"Line Connection",null,null,null,"Transformation Connection",null,null,null,"Total Line"]
[]
[null,"Month",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Amount"]
[]
[null,"January",null,{"$f":"D20+D39+D58+D77","v":799009.32},{"$f":"IF(D96<>0,F96/D96,0)","v":3.622394626565808},{"$f":"F20+F39+F58+F77","v":2894327.0673440001},null,{"$f":"H20+H39+H58+H77","v":776994.95},{"$f":"IF(H96<>0,J96/H96,0)","v":0.86172243133626547},{"$f":"J20+J39+J58+J77","v":669553.97745000001},null,{"$f":"L20+L39+L58+L77","v":843801.95},{"$f":"IF(L96<>0,N96/L96,0)","v":1.9991582815552869},{"$f":"N20+N39+N58+N77","v":1686893.6563349999},null,{"$f":"J96+N96","v":2356447.6337850001}]
[null,"February",null,{"$f":"D21+D40+D59+D78","v":804013.57000000007},3.6217496768045838,{"$f":"F21+F40+F59+F78","v":2911935.887294},null,{"$f":"H21+H40+H59+H78","v":777200.23},0.86134371490085637,{"$f":"J21+J40+J59+J78","v":669436.53333000001},null,{"$f":"L21+L40+L59+L78","v":842686.23},1.9981701055433172,{"$f":"N21+N40+N59+N78","v":1683830.4331390001},null,2353266.9664690001]
[null,"March",null,779560.13,3.6225762721420858,2824016.0296459999,null,756965.64,0.86170760332001328,652283.04743999999,null,813544.64,1.9989026499541562,1626196.536752,null,2278479.5841919999]
[null,"April",null,706120.7,3.6237485499858599,2558803.8627400002,null,711430.57,0.86200275097821566,613255.10846999998,null,763469.57,1.9996232709065276,1526651.518801,null,2139906.6272709998]
[null,"May",null,864964.16,3.6219777500052714,3132880.9420719999,null,886934.69,0.8615760434288573,764161.68099000002,null,947194.69,1.998431419328375,1892903.6287170001,null,2657065.3097069999]
[null,"June",null,1013372.99,3.6161440460910645,3664502.704258,null,992886.84,0.86034576774126648,854225.99063999997,null,1061129.8400000001,1.995299711213474,2117272.0633120001,null,2971498.0539520001]
[null,"July",null,1018256.07,3.6192518027356324,3685325.116994,null,1011982.82,0.86122056421866933,871540.41522000008,null,1081964.82,1.9975467264508655,2161275.2843260001,null,3032815.699546]
[null,"August",null,1020290.79,3.6204576422943111,3693919.5880180001,null,1026162.81,0.86158152965025103,884122.92350999999,null,1093854.81,1.998405515657969,2185965.4856329998,null,3070088.4091429999]
[null,"September",null,1071678.25,3.621606361004341,3881196.7671500002,null,1036610.27,0.86148487432022058,893024.06816999998,null,1102982.27,1.9981177941427832,2203888.5003109998,null,3096912.5684809997]
[null,"October",null,691179.8,3.6237115560379514,2504636.2285600002,null,700870.88,0.86206146627179026,604193.77847999998,null,761073.88,2.0000103792604205,1522155.6593839999,null,2126349.437864]
[null,"November",null,729938.17,3.6243701926342613,2645566.1458140002,null,718185.19,0.86205403301340711,619114.43949000002,null,770319.19,1.99974344695606,1540440.752267,null,2159555.1917570001]
[null,"December",null,801731.25,3.6186889501313568,2901216.0153500005,null,773643.86,0.86080771850241267,665958.6060599999,null,831359.86,1.9966100976994487,1659901.4912980001,null,2325860.097358]
[]
[null,"Total",null,{"$f":"SUM(D96:D107)","v":10300115.200000001},{"$f":"IF(D109<>0,F109/D109,0)","v":3.6211562328196094},{"$f":"SUM(F96:F107)","v":37298326.355240002},null,{"$f":"SUM(H96:H107)","v":10169868.75},{"$f":"IF(H109<>0,J109/H109,0)","v":0.86145365142986718},{"$f":"SUM(J96:J107)","v":8760870.5692499988},null,{"$f":"SUM(L96:L107)","v":10913381.75},{"$f":"IF(L109<>0,N109/L109,0)","v":1.9982234205520208},{"$f":"SUM(N96:N107)","v":21807375.010274999},null,{"$f":"SUM(P96:P107)","v":30568245.579524998}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Low Voltage Switchgear Credit (if applicable)",null,{"$f":"'11. RTSR-UTRs & Sub-Tx'!I68","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total including deduction for Low Voltage Switchgear Credit",null,{"$f":"P109+P111","v":30568245.579524998}]

{"sheet":"15. RTSR-Rates to Forecast","index":5,"n_rows":67,"n_cols":11,"rows_kept":67,"cut":false,"hidden":false,"merged":[[1,1,8,2]]}
["Back to Index","Back to Index"]
[null,"INCENTIVE REGULATION MODEL FOR 2018 FILERS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The purpose of this table is to re-align the current RTS Network Rates to recover current wholesale network costs."]
[]
[null,"Rate Class","Rate Description","Unit","Current RTSR-Network","Loss Adjusted Billed kWh","Billed kW","Billed Amount","Billed Amount %","Current Wholesale Billing","Adjusted RTSR Network"]
[]
[{"$f":"'10. RTSR - Current Rates'!A16","v":"R_TN"},{"$f":"+'10. RTSR - Current Rates'!B16","v":"RESIDENTIAL SERVICE CLASSIFICATION"},{"$f":"VLOOKUP(A17,RTSR,3,FALSE)","v":"Retail Transmission Rate – Network Service Rate"},{"$f":"VLOOKUP(A17,RTSR,4,FALSE)","v":"$/kWh"},{"$f":"+'10. RTSR - Current Rates'!E16","v":7.4000000000000003E-3},{"$f":"VLOOKUP(A17,RTSR,9,FALSE)","v":1710255587.9976876},{"$f":"VLOOKUP(A17,RTSR,7,FALSE)","v":0},{"$f":"IF(ISERROR(E17*F17), 0, ROUND(E17*F17, 2))","v":12655891.35},{"$f":"H17/SUM(H$17:H$27)","v":0.34564130756144401},{"$f":"I17*total_wholesale_TN","v":12891842.291278623},{"$f":"IF(ISERROR(J17/F17), 0, J17/F17)","v":7.5379623851262951E-3}]
[{"$f":"'10. RTSR - Current Rates'!A18","v":"GSL_TN"},{"$f":"+'10. RTSR - Current Rates'!B18","v":"GENERAL SERVICE LESS THAN 50 kW SERVICE CLASSIFICATION"},"Retail Transmission Rate – Network Service Rate","$/kWh",{"$f":"+'10. RTSR - Current Rates'!E18","v":6.4999999999999997E-3},{"$f":"VLOOKUP(A18,RTSR,9,FALSE)","v":617704810.97562325},{"$f":"VLOOKUP(A18,RTSR,7,FALSE)","v":0},{"$f":"IF(ISERROR(E18*F18), 0, ROUND(E18*F18, 2))","v":4015081.27},0.10965469770157779,{"$f":"I18*total_wholesale_TN","v":4089936.7012586342},{"$f":"IF(ISERROR(J18/F18), 0, J18/F18)","v":6.6211831745309766E-3}]
[{"$f":"'10. RTSR - Current Rates'!A20","v":"GS50_499_TN"},{"$f":"+'10. RTSR - Current Rates'!B20","v":"GENERAL SERVICE GREATER THAN 50 kW SERVICE CLASSIFICATION"},"Retail Transmission Rate – Network Service Rate","$/kW",{"$f":"+'10. RTSR - Current Rates'!E20","v":2.5720999999999998},0,4895437.1512875455,{"$f":"IF(ISERROR(E19*G19), 0, ROUND(E19*G19, 2))","v":12591553.9},0.34388420648273027,12826305.361805614,{"$f":"IF(ISERROR(J19/G19), 0, J19/G19)","v":2.6200531158759084}]
[{"$f":"'10. RTSR - Current Rates'!A22","v":"GS500_TN"},{"$f":"+'10. RTSR - Current Rates'!B22","v":"LARGE USE 1 SERVICE CLASSIFICATION"},"Retail Transmission Rate – Network Service Rate","$/kW",{"$f":"+'10. RTSR - Current Rates'!E22","v":2.9382000000000001},0,512415.67000000004,{"$f":"IF(ISERROR(E20*G20), 0, ROUND(E20*G20, 2))","v":1505579.72},4.1118442681541571E-2,1533649.0943553674,{"$f":"IF(ISERROR(J20/G20), 0, J20/G20)","v":2.9929785214323505}]
[{"$f":"'10. RTSR - Current Rates'!A24","v":"LU_TN"},{"$f":"+'10. RTSR - Current Rates'!B24","v":"LARGE USE 2 SERVICE CLASSIFICATION"},"Retail Transmission Rate – Network Service Rate – Interval Metered","$/kW",{"$f":"+'10. RTSR - Current Rates'!E24","v":2.9382000000000001},0,1901226.94,5586185,0.15256264725124438,5690331.4067962719,2.9929785272221485]
[null,{"$f":"+'10. RTSR - Current Rates'!B26","v":"UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION"},"Retail Transmission Rate – Network Service Rate","$/kWh",{"$f":"+'10. RTSR - Current Rates'!E26","v":6.6E-3},{"$f":"+'10. RTSR - Current Rates'!I26","v":12009615.584072791},0,{"$f":"IF(ISERROR(E22*F22), 0, ROUND(E22*F22, 2))","v":79263.460000000006},2.1647409256752362E-3,{"$f":"I22*total_wholesale_TN","v":80741.2135203793},{"$f":"IF(ISERROR(J22/F22), 0, J22/F22)","v":6.7230472911604831E-3}]
[null,{"$f":"'[1]4. Billing Det. for Def-Var'!B22","v":"STANDBY POWER SERVICE CLASSIFICATION "}]
[{"$f":"'10. RTSR - Current Rates'!A26","v":"USL_TN"},{"$f":"+'10. RTSR - Current Rates'!B28","v":"SENTINEL LIGHTING"},"Retail Transmission Rate – Network Service Rate","$/kW",{"$f":"+'10. RTSR - Current Rates'!E28","v":2.1373000000000002},0,{"$f":"+'10. RTSR - Current Rates'!G28","v":1213.4230761028894},{"$f":"IF(ISERROR(E24*G24), 0, ROUND(E24*G24, 2))","v":2593.4499999999998},{"$f":"H24/SUM(H$17:H$27)","v":7.0828946322712148E-5},2641.8011553422939,2.1771476143563042]
["SL_TN",{"$f":"+'10. RTSR - Current Rates'!B30","v":"STREET LIGHTING SERVICE CLASSIFICATION"},"Retail Transmission Rate – Network Service Rate","$/kW",{"$f":"+'10. RTSR - Current Rates'!E30","v":2.0247999999999999},0,88666.23,179531.38,{"$f":"H25/SUM(H$17:H$27)","v":4.9031284494640099E-3},182878.48506977054,2.0625494629665719]
[]
[]
[null,"The purpose of this table is to re-align the current RTS Connection Rates to recover current wholesale connection costs."]
[null,"Rate Class","Rate Description","Unit","Current RTSR-Connection","Loss Adjusted Billed kWh","Billed kW","Billed Amount","Billed Amount %","Current Wholesale Billing","Adjusted RTSR-Connection"]
[]
["R_TC",{"$f":"B17","v":"RESIDENTIAL SERVICE CLASSIFICATION"},{"$f":"VLOOKUP(A31,RTSR,3,FALSE)","v":"Retail Transmission Rate – Line and Transformation Connection Service Rate"},{"$f":"VLOOKUP(A31,RTSR,4,FALSE)","v":"$/kWh"},{"$f":"+'10. RTSR - Current Rates'!E17","v":5.8999999999999999E-3},{"$f":"F17","v":1710255587.9976876},0,{"$f":"IF(ISERROR(E31*F31), 0, ROUND(E31*F31, 2))","v":10090507.970000001},{"$f":"H31/SUM(H$31:H$41)","v":0.33807432096840401},{"$f":"I31*total_wholesale_LinePlus","v":10334338.867493331},{"$f":"IF(ISERROR(J31/F31), 0, J31/F31)","v":6.0425698591591468E-3}]
["GSL_TC","GENERAL SERVICE LESS THAN 50 kW SERVICE CLASSIFICATION","Retail Transmission Rate – Line and Transformation Connection Service Rate","$/kWh",{"$f":"+'10. RTSR - Current Rates'!E19","v":5.3E-3},617704810.97562325,0,{"$f":"IF(ISERROR(E32*F32), 0, ROUND(E32*F32, 2))","v":3273835.5},{"$f":"H32/SUM(H$31:H$41)","v":0.10968721464919029},3352945.7143305205,{"$f":"IF(ISERROR(J32/F32), 0, J32/F32)","v":5.4280712320092959E-3}]
["GS50_499_TC","GENERAL SERVICE GREATER THAN 50 kW SERVICE CLASSIFICATION","Retail Transmission Rate – Line and Transformation Connection Service Rate","$/kW",{"$f":"+'10. RTSR - Current Rates'!E21","v":2.1213000000000002},0,4895437.1512875455,{"$f":"IF(ISERROR(E33*G33), 0, ROUND(E33*G33, 2))","v":10384690.83},0.34793068012601369,10635630.474743145,{"$f":"IF(ISERROR(J33/G33), 0, J33/G33)","v":2.1725599054919691}]
["GS500_TC","LARGE USE 1 SERVICE CLASSIFICATION","Retail Transmission Rate – Line and Transformation Connection Service Rate","$/kW",{"$f":"+'10. RTSR - Current Rates'!E23","v":2.4376000000000002},0,512415.67000000004,{"$f":"IF(ISERROR(E34*G34), 0, ROUND(E34*G34, 2))","v":1249064.44},4.1848895383091382E-2,1279247.3113021872,{"$f":"IF(ISERROR(J34/G34), 0, J34/G34)","v":2.4965031051883857}]
["LU_TC","LARGE USE 2 SERVICE CLASSIFICATION","Retail Transmission Rate – Line and Transformation Connection Service Rate – Interval Metered ","$/kW",{"$f":"+'10. RTSR - Current Rates'!E25","v":2.4376000000000002},0,1901226.94,4634430.79,0.15527286109505092,4746418.9497889895,2.4965031001448934]
[null,"UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION",{"$f":"+C33","v":"Retail Transmission Rate – Line and Transformation Connection Service Rate"},"$/kWh",{"$f":"+'10. RTSR - Current Rates'!E27","v":5.4000000000000003E-3},12009615.584072791,0,{"$f":"IF(ISERROR(E36*F36), 0, ROUND(E36*F36, 2))","v":64851.92},{"$f":"H36/SUM(H$31:H$41)","v":2.1728112085815298E-3},{"$f":"I36*total_wholesale_LinePlus","v":66419.026621864716},{"$f":"IF(ISERROR(J36/F36), 0, J36/F36)","v":5.5304873130119121E-3}]
[null,"STANDBY POWER SERVICE CLASSIFICATION "]
["USL_TC","SENTINEL LIGHTING","Retail Transmission Rate – Line and Transformation Connection Service Rate","$/kW",{"$f":"+'10. RTSR - Current Rates'!E29","v":1.7069000000000001},{"$f":"F24","v":0},{"$f":"G24","v":1213.4230761028894},2071.19,6.9393548365290938E-5,2121.2390280648588,{"$f":"IF(ISERROR(J38/G38), 0, J38/G38)","v":1.7481446247730608}]
["SL_TC","STREET LIGHTING SERVICE CLASSIFICATION","Retail Transmission Rate – Line and Transformation Connection Service Rate","$/kW",{"$f":"+'10. RTSR - Current Rates'!E31","v":1.6641999999999999},{"$f":"F25","v":0},{"$f":"G25","v":88666.23},147558.34,4.9438230213027503E-3,151123.99621689171,1.7044143662913345]
[]
[]
[null,"The purpose of this table is to update the re-aligned RTS Network Rates to recover future wholesale network costs."]
[null,"Rate Class","Rate Description","Unit","Adjusted RTSR-Network","Loss Adjusted Billed kWh","Billed kW","Billed Amount","Billed Amount %","Current Wholesale Billing","Proposed RTSR-Network"]
[]
["R_TN",{"$f":"B17","v":"RESIDENTIAL SERVICE CLASSIFICATION"},{"$f":"VLOOKUP(A45,RTSR,3,FALSE)","v":"Retail Transmission Rate – Network Service Rate"},{"$f":"VLOOKUP(A45,RTSR,4,FALSE)","v":"$/kWh"},{"$f":"K17","v":7.5379623851262951E-3},{"$f":"VLOOKUP(A45,RTSR,9,FALSE)","v":1710255587.9976876},{"$f":"VLOOKUP(A45,RTSR,7,FALSE)","v":0},{"$f":"IF(ISERROR(E45*F45), 0, ROUND(E45*F45, 2))","v":12891842.289999999},{"$f":"H45/SUM(H$45:H$55)","v":0.34564130757572187},{"$f":"I45*forecast_wholesale_TN","v":12891842.291811163},{"$f":"IF(ISERROR(J45/F45), 0, J45/F45)","v":7.5379623854376753E-3}]
["GSL_TN","GENERAL SERVICE LESS THAN 50 kW SERVICE CLASSIFICATION","Retail Transmission Rate – Network Service Rate","$/kWh",6.6211831745309766E-3,617704810.97562325,0,{"$f":"IF(ISERROR(E46*F46), 0, ROUND(E46*F46, 2))","v":4089936.7},0.10965469768323803,4089936.7005745918,{"$f":"IF(ISERROR(J46/F46), 0, J46/F46)","v":6.6211831734235829E-3}]
["GS50_499_TN","GENERAL SERVICE GREATER THAN 50 kW SERVICE CLASSIFICATION","Retail Transmission Rate – Network Service Rate","$/kW",2.6200531158759084,0,4895437.1512875455,{"$f":"IF(ISERROR(E47*G47), 0, ROUND(E47*G47, 2))","v":12826305.359999999},0.34388420648263218,12826305.361801954,{"$f":"IF(ISERROR(J47/G47), 0, J47/G47)","v":2.6200531158751605}]
["GS500_TN","LARGE USE 1 SERVICE CLASSIFICATION","Retail Transmission Rate – Network Service Rate","$/kW",2.9929785214323505,0,512415.67000000004,{"$f":"IF(ISERROR(E48*G48), 0, ROUND(E48*G48, 2))","v":1533649.09},4.1118442570547142E-2,1533649.0902154609,{"$f":"IF(ISERROR(J48/G48), 0, J48/G48)","v":2.9929785133531546}]
["LU_TN","LARGE USE 2 SERVICE CLASSIFICATION","Retail Transmission Rate – Network Service Rate – Interval Metered","$/kW",2.9929785272221485,0,1901226.94,5690331.4100000001,0.15256264735857247,5690331.4107994298,2.992978529327714]
[null,"UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION",{"$f":"+C48","v":"Retail Transmission Rate – Network Service Rate"},"$/kWh",6.7230472911604831E-3,{"$f":"+'10. RTSR - Current Rates'!I26","v":12009615.584072791},0,{"$f":"IF(ISERROR(E50*F50), 0, ROUND(E50*F50, 2))","v":80741.210000000006},2.1647408315949817E-3,{"$f":"I50*forecast_wholesale_TN","v":80741.210011343268},{"$f":"IF(ISERROR(J50/F50), 0, J50/F50)","v":6.7230469989749417E-3}]
[null,"STANDBY POWER SERVICE CLASSIFICATION "]
["USL_TN","SENTINEL LIGHTING","Retail Transmission Rate – Network Service Rate","$/kW",{"$f":"K24","v":2.1771476143563042},0,{"$f":"+'10. RTSR - Current Rates'!G28","v":1213.4230761028894},2641.8,{"$f":"H52/SUM(H$45:H$55)","v":7.0828915356948733E-5},2641.8000003711445,2.1771466625274063]
["SL_TN","STREET LIGHTING SERVICE CLASSIFICATION","Retail Transmission Rate – Network Service Rate","$/kW",{"$f":"K25","v":2.0625494629665719},0,88666.23,182878.49,{"$f":"H53/SUM(H$45:H$55)","v":4.9031285823365103E-3},182878.49002569242,2.062549518860703]
[]
[]
[null,"The purpose of this table is to update the re-aligned RTS Connection Rates to recover future wholesale connection costs."]
[null,"Rate Class","Rate Description","Unit","Adjusted RTSR-Connection","Loss Adjusted Billed kWh","Billed kW","Billed Amount","Billed Amount %","Current Wholesale Billing","Proposed RTSR-Connection"]
[]
["R_TC",{"$f":"B17","v":"RESIDENTIAL SERVICE CLASSIFICATION"},{"$f":"VLOOKUP(A59,RTSR,3,FALSE)","v":"Retail Transmission Rate – Line and Transformation Connection Service Rate"},{"$f":"VLOOKUP(A59,RTSR,4,FALSE)","v":"$/kWh"},{"$f":"K31","v":6.0425698591591468E-3},{"$f":"VLOOKUP(A59,RTSR,9,FALSE)","v":1710255587.9976876},{"$f":"VLOOKUP(A59,RTSR,7,FALSE)","v":0},{"$f":"IF(ISERROR(E59*F59), 0, ROUND(E59*F59, 2))","v":10334338.869999999},{"$f":"H59/SUM(H$59:H$69)","v":0.33807432104515306},{"$f":"I59*forecast_wholesale_LNPlus","v":10334338.869839415},{"$f":"IF(ISERROR(J59/F59), 0, J59/F59)","v":6.0425698605309211E-3}]
["GSL_TC","GENERAL SERVICE LESS THAN 50 kW SERVICE CLASSIFICATION","Retail Transmission Rate – Line and Transformation Connection Service Rate","$/kWh",5.4280712320092959E-3,617704810.97562325,0,{"$f":"IF(ISERROR(E60*F60), 0, ROUND(E60*F60, 2))","v":3352945.71},{"$f":"H60/SUM(H$59:H$69)","v":0.10968721450581857},3352945.709947899,{"$f":"IF(ISERROR(J60/F60), 0, J60/F60)","v":5.4280712249142864E-3}]
["GS50_499_TC","GENERAL SERVICE GREATER THAN 50 kW SERVICE CLASSIFICATION","Retail Transmission Rate – Line and Transformation Connection Service Rate","$/kW",2.1725599054919691,0,4895437.1512875455,{"$f":"IF(ISERROR(E61*G61), 0, ROUND(E61*G61, 2))","v":10635630.470000001},0.34793067996544152,10635630.469834734,{"$f":"IF(ISERROR(J61/G61), 0, J61/G61)","v":2.1725599044893191}]
["GS500_TC","LARGE USE 1 SERVICE CLASSIFICATION","Retail Transmission Rate – Line and Transformation Connection Service Rate","$/kW",2.4965031051883857,0,512415.67000000004,{"$f":"IF(ISERROR(E62*G62), 0, ROUND(E62*G62, 2))","v":1279247.31},4.1848895339841756E-2,1279247.3099801221,{"$f":"IF(ISERROR(J62/G62), 0, J62/G62)","v":2.496503102608322}]
["LU_TC","LARGE USE 2 SERVICE CLASSIFICATION","Retail Transmission Rate – Line and Transformation Connection Service Rate – Interval Metered ","$/kW",2.4965031001448934,0,1901226.94,4746418.95,0.15527286109954111,4746418.9499262469,2.4965031002170877]
[null,"UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION",{"$f":"+C61","v":"Retail Transmission Rate – Line and Transformation Connection Service Rate"},"$/kWh",5.5304873130119121E-3,{"$f":"+'10. RTSR - Current Rates'!I27","v":12009615.584072791},0,{"$f":"IF(ISERROR(E64*F64), 0, ROUND(E64*F64, 2))","v":66419.03},{"$f":"H64/SUM(H$59:H$69)","v":2.172811319059025E-3},{"$f":"I64*forecast_wholesale_LNPlus","v":66419.029998967919},{"$f":"IF(ISERROR(J64/F64), 0, J64/F64)","v":5.5304875942118539E-3}]
[null,"STANDBY POWER SERVICE CLASSIFICATION "]
["USL_TC","SENTINEL LIGHTING","Retail Transmission Rate – Line and Transformation Connection Service Rate","$/kW",{"$f":"K38","v":1.7481446247730608},0,{"$f":"+'10. RTSR - Current Rates'!G29","v":1213.4230761028894},{"$f":"IF(ISERROR(E66*G66), 0, ROUND(E66*G66, 2))","v":2121.2399999999998},{"$f":"H66/SUM(H$59:H$69)","v":6.9393580159794044E-5},{"$f":"I66*forecast_wholesale_LNPlus","v":2121.2399999670379},{"$f":"IF(ISERROR(J66/G66), 0, J66/G66)","v":1.7481454257320983}]
["SL_TC","STREET LIGHTING SERVICE CLASSIFICATION","Retail Transmission Rate – Line and Transformation Connection Service Rate","$/kW",{"$f":"K39","v":1.7044143662913345},0,88666.23,151124,4.9438231449853466E-3,151123.9999976517,1.7044144089316948]