{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Summary","Near-term Impact Summary","Debt Calcs","Residential Bill Calcs","Historical Data","IESO HOEP-GA","IESO Res Bill"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":2,"defined_names":57,"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":"Summary","index":0,"n_rows":18,"n_cols":43,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Global Impacts"]
[null,"nominal $ million",2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050]
[null,"IESO Forecast GA Cost",null,null,null,null,null,null,null,{"$f":"'Debt Calcs'!D15","v":12095.369682235045},{"$f":"'Debt Calcs'!E15","v":11834.680968387356},{"$f":"'Debt Calcs'!F15","v":11552.105152780023},{"$f":"'Debt Calcs'!G15","v":12168.427804857231},{"$f":"'Debt Calcs'!H15","v":10843.555476184305},{"$f":"'Debt Calcs'!I15","v":10633.626262038733},{"$f":"'Debt Calcs'!J15","v":10243.432169611806},{"$f":"'Debt Calcs'!K15","v":11128.119052974123},{"$f":"'Debt Calcs'!L15","v":10527.01808843752},{"$f":"'Debt Calcs'!M15","v":10033.287200750003},{"$f":"'Debt Calcs'!N15","v":11042.844229096907},{"$f":"'Debt Calcs'!O15","v":10819.097642104838},{"$f":"'Debt Calcs'!P15","v":10008.692180866097},{"$f":"'Debt Calcs'!Q15","v":9721.4381123383864},{"$f":"'Debt Calcs'!R15","v":8654.4846953957476},{"$f":"'Debt Calcs'!S15","v":8819.9388296880807},{"$f":"'Debt Calcs'!T15","v":8238.0383223817407},{"$f":"'Debt Calcs'!U15","v":7756.4351319563648},{"$f":"'Debt Calcs'!V15","v":5662.3211916579985}]
[null,"GA Cost Extrapolated",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,{"$f":"'Debt Calcs'!W15","v":5388.8445108572041},{"$f":"'Debt Calcs'!X15","v":5128.5761049688263},{"$f":"'Debt Calcs'!Y15","v":4880.8780456486584},{"$f":"'Debt Calcs'!Z15","v":4645.1432149781613},{"$f":"'Debt Calcs'!AA15","v":4420.7938173939892},{"$f":"'Debt Calcs'!AB15","v":4207.2799634878011},{"$f":"'Debt Calcs'!AC15","v":4004.0783222051691},{"$f":"'Debt Calcs'!AD15","v":3810.6908381400954},{"$f":"'Debt Calcs'!AE15","v":3626.6435107811549},{"$f":"'Debt Calcs'!AF15","v":3451.4852327171438},{"$f":"'Debt Calcs'!AG15","v":3284.7866839546605},{"$f":"'Debt Calcs'!AH15","v":3126.139279637503},{"$f":"'Debt Calcs'!AI15","v":2975.1541685887391},{"$f":"'Debt Calcs'!AJ15","v":2831.4612802208057},{"$f":"'Debt Calcs'!AK15","v":2694.7084174775991}]
[null,"GA Payment",null,null,null,null,null,null,null,{"$f":"'Debt Calcs'!D21","v":9594.7641451283434},{"$f":"'Debt Calcs'!E21","v":9326.7550959255186},{"$f":"'Debt Calcs'!F21","v":9051.1762399074269},{"$f":"'Debt Calcs'!G21","v":9093.8667909781707},{"$f":"'Debt Calcs'!H21","v":8183.7164951497889},{"$f":"'Debt Calcs'!I21","v":8179.5529671335189},{"$f":"'Debt Calcs'!J21","v":8205.709757477116},{"$f":"'Debt Calcs'!K21","v":9742.5172799303891},{"$f":"'Debt Calcs'!L21","v":9315.9585299723167},{"$f":"'Debt Calcs'!M21","v":10236.412086038163},{"$f":"'Debt Calcs'!N21","v":11475.726879482034},{"$f":"'Debt Calcs'!O21","v":13060.648789778163},{"$f":"'Debt Calcs'!P21","v":12250.243328539422},{"$f":"'Debt Calcs'!Q21","v":11962.989260011709},{"$f":"'Debt Calcs'!R21","v":10896.035843069072},{"$f":"'Debt Calcs'!S21","v":11061.489977361405},{"$f":"'Debt Calcs'!T21","v":10479.589470055063},{"$f":"'Debt Calcs'!U21","v":9997.9862796296875},{"$f":"'Debt Calcs'!V21","v":7903.8723393313221},{"$f":"'Debt Calcs'!W21","v":7630.3956585305277},{"$f":"'Debt Calcs'!X21","v":7370.1272526421499},{"$f":"'Debt Calcs'!Y21","v":7122.429193321982},{"$f":"'Debt Calcs'!Z21","v":6886.6943626514849},{"$f":"'Debt Calcs'!AA21","v":6662.3449650673128},{"$f":"'Debt Calcs'!AB21","v":6448.8311111611247},{"$f":"'Debt Calcs'!AC21","v":6245.6294698784932},{"$f":"'Debt Calcs'!AD21","v":6052.241985813419},{"$f":"'Debt Calcs'!AE21","v":5868.1946584544785},{"$f":"'Debt Calcs'!AF21","v":5693.0363803904675},{"$f":"'Debt Calcs'!AG21","v":5526.3378316279841},{"$f":"'Debt Calcs'!AH21","v":5367.6904273108266},{"$f":"'Debt Calcs'!AI21","v":2975.1541685887391},{"$f":"'Debt Calcs'!AJ21","v":2831.4612802208057},{"$f":"'Debt Calcs'!AK21","v":2694.7084174775991}]
[null,"Amount borrowed/paid-back in given year",null,null,null,null,null,null,null,{"$f":"J6-J4","v":-2500.6055371067014},{"$f":"K6-K4","v":-2507.9258724618376},-2500.9289128725959,-3074.5610138790598,-2659.8389810345161,-2454.0732949052144,-2037.7224121346899,-1385.6017730437343,-1211.0595584652037,203.12488528815993,432.88265038512691,2241.5511476733245,2241.5511476733245,2241.5511476733227,2241.5511476733245,2241.5511476733245,2241.5511476733227,2241.5511476733227,2241.5511476733236,{"$f":"AC6-AC5","v":2241.5511476733236},{"$f":"AD6-AD5","v":2241.5511476733236},2241.5511476733236,2241.5511476733236,2241.5511476733236,2241.5511476733236,2241.5511476733241,2241.5511476733236,2241.5511476733236,2241.5511476733236,2241.5511476733236,2241.5511476733236,0,0,0]
[null,"Interest on accumulated debt from previous year",null,null,null,null,null,null,null,null,{"$f":"-J9*'Debt Calcs'!$C$5","v":-127.93097927837883},{"$f":"-K9*'Debt Calcs'!$C$5","v":-262.78141581340827},{"$f":"-L9*'Debt Calcs'!$C$5","v":-404.17283622898429},{"$f":"-M9*'Debt Calcs'!$C$5","v":-582.14486000051193},{"$f":"-N9*'Debt Calcs'!$C$5","v":-748.00475330786401},{"$f":"-O9*'Debt Calcs'!$C$5","v":-911.82306625444517},{"$f":"-P9*'Debt Calcs'!$C$5","v":-1062.7218129288333},{"$f":"-Q9*'Debt Calcs'!$C$5","v":-1187.9780475871898},{"$f":"-R9*'Debt Calcs'!$C$5","v":-1310.7128115128305},{"$f":"-S9*'Debt Calcs'!$C$5","v":-1367.3770098184846},{"$f":"-T9*'Debt Calcs'!$C$5","v":-1415.1857412470954},{"$f":"-U9*'Debt Calcs'!$C$5","v":-1372.9088870543294},{"$f":"-V9*'Debt Calcs'!$C$5","v":-1328.4691490010616},{"$f":"-W9*'Debt Calcs'!$C$5","v":-1281.7558739489889},{"$f":"-X9*'Debt Calcs'!$C$5","v":-1232.6527477452519},{"$f":"-Y9*'Debt Calcs'!$C$5","v":-1181.0375056049318},{"$f":"-Z9*'Debt Calcs'!$C$5","v":-1126.781627676713},{"$f":"-AA9*'Debt Calcs'!$C$5","v":-1069.7500190336866},{"$f":"-AB9*'Debt Calcs'!$C$5","v":-1009.800673292483},{"$f":"-AC9*'Debt Calcs'!$C$5","v":-946.78431902315936},{"$f":"-AD9*'Debt Calcs'!$C$5","v":-880.54404806941716},{"$f":"-AE9*'Debt Calcs'!$C$5","v":-810.91492485368144},{"$f":"-AF9*'Debt Calcs'!$C$5","v":-737.72357569422854},{"$f":"-AG9*'Debt Calcs'!$C$5","v":-660.78775711177809},{"$f":"-AH9*'Debt Calcs'!$C$5","v":-579.91590205064949},{"$f":"-AI9*'Debt Calcs'!$C$5","v":-494.90664288459351},{"$f":"-AJ9*'Debt Calcs'!$C$5","v":-405.54831001960218},{"$f":"-AK9*'Debt Calcs'!$C$5","v":-311.61840484523782},{"$f":"-AL9*'Debt Calcs'!$C$5","v":-212.88304572215299},{"$f":"-AM9*'Debt Calcs'!$C$5","v":-109.09638562633108},{"$f":"-AN9*'Debt Calcs'!$C$5","v":-6.9561974669340996E-12},{"$f":"-AO9*'Debt Calcs'!$C$5","v":-7.3120765293424487E-12},{"$f":"-AP9*'Debt Calcs'!$C$5","v":-7.6861623645836088E-12}]
[null,"Accumulated Debt",null,null,null,null,null,null,null,{"$f":"'Debt Calcs'!D20","v":2500.6055371067014},{"$f":"'Debt Calcs'!E20","v":5136.4623888469177},{"$f":"'Debt Calcs'!F20","v":7900.1727175329224},{"$f":"'Debt Calcs'!G20","v":11378.906567640968},{"$f":"'Debt Calcs'!H20","v":14620.890408675998},{"$f":"'Debt Calcs'!I20","v":17822.968456889077},{"$f":"'Debt Calcs'!J20","v":20772.513935278213},{"$f":"'Debt Calcs'!K20","v":23220.837521250782},{"$f":"'Debt Calcs'!L20","v":25619.875127303178},{"$f":"'Debt Calcs'!M20","v":26727.463053527848},{"$f":"'Debt Calcs'!N20","v":27661.957412961208},{"$f":"'Debt Calcs'!O20","v":26835.592006534978},{"$f":"'Debt Calcs'!P20","v":25966.949745915983},{"$f":"'Debt Calcs'!Q20","v":25053.867747243723},{"$f":"'Debt Calcs'!R20","v":24094.072473519387},{"$f":"'Debt Calcs'!S20","v":23085.174073591319},{"$f":"'Debt Calcs'!T20","v":22024.660431522931},{"$f":"'Debt Calcs'!U20","v":20909.890911526323},{"$f":"'Debt Calcs'!V20","v":19738.089782886691},{"$f":"'Debt Calcs'!W20","v":18506.339308505852},{"$f":"'Debt Calcs'!X20","v":17211.572479855691},{"$f":"'Debt Calcs'!Y20","v":15850.565380251788},{"$f":"'Debt Calcs'!Z20","v":14419.929157432147},{"$f":"'Debt Calcs'!AA20","v":12916.101585453052},{"$f":"'Debt Calcs'!AB20","v":11335.338194891508},{"$f":"'Debt Calcs'!AC20","v":9673.7029492688343},{"$f":"'Debt Calcs'!AD20","v":7927.0584444801052},{"$f":"'Debt Calcs'!AE20","v":6091.0556068263841},{"$f":"'Debt Calcs'!AF20","v":4161.1228639982992},{"$f":"'Debt Calcs'!AG20","v":2132.4547620471285},{"$f":"'Debt Calcs'!AH20","v":1.3596945791505277E-10},{"$f":"'Debt Calcs'!AI20","v":1.4292565538198689E-10},{"$f":"'Debt Calcs'!AJ20","v":1.5023773191132934E-10},{"$f":"'Debt Calcs'!AK20","v":1.5792389427591296E-10}]
[]
[null,"Residential Bills (assuming 750 kWh/month)"]
[null,"nominal $/month"]
[null,null,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050]
[null,"Historical Values",{"$f":"'Historical Data'!C10","v":104},{"$f":"'Historical Data'!D10","v":105},{"$f":"'Historical Data'!E10","v":112},{"$f":"'Historical Data'!F10","v":116.41},{"$f":"'Historical Data'!G10","v":123.51},{"$f":"'Historical Data'!H10","v":135.65},{"$f":"'IESO Res Bill'!C15","v":158.29094390666668}]
[null,"IESO Forecast",null,null,null,null,null,null,null,{"$f":"'Residential Bill Calcs'!C19","v":152.70563809980166},{"$f":"'Residential Bill Calcs'!D19","v":155.25080956850243},{"$f":"'Residential Bill Calcs'!E19","v":157.88132089866929},{"$f":"'Residential Bill Calcs'!F19","v":167.81430136892874},{"$f":"'Residential Bill Calcs'!G19","v":165.86232478214305},{"$f":"'Residential Bill Calcs'!H19","v":169.11791864038065},{"$f":"'Residential Bill Calcs'!I19","v":173.76769698992013},{"$f":"'Residential Bill Calcs'!J19","v":176.42090309889093},{"$f":"'Residential Bill Calcs'!K19","v":184.97374885845929},{"$f":"'Residential Bill Calcs'!L19","v":180.53755462719494},{"$f":"'Residential Bill Calcs'!M19","v":189.90414811188873},{"$f":"'Residential Bill Calcs'!N19","v":190.44776274923035},{"$f":"'Residential Bill Calcs'!O19","v":189.59468749944327},{"$f":"'Residential Bill Calcs'!P19","v":191.74390532438679},{"$f":"'Residential Bill Calcs'!Q19","v":194.307238350587},{"$f":"'Residential Bill Calcs'!R19","v":196.60730980550969},{"$f":"'Residential Bill Calcs'!S19","v":198.65116450848882},{"$f":"'Residential Bill Calcs'!T19","v":200.08829296579},{"$f":"'Residential Bill Calcs'!U19","v":196.98440343263786}]
[null,"IESO Forecast Extrapolated",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,{"$f":"'Residential Bill Calcs'!V20","v":197.94624476425392},{"$f":"'Residential Bill Calcs'!W20","v":198.91278260346695},{"$f":"'Residential Bill Calcs'!X20","v":199.88403988252458},{"$f":"'Residential Bill Calcs'!Y20","v":200.86003964564873},{"$f":"'Residential Bill Calcs'!Z20","v":201.84080504958229},{"$f":"'Residential Bill Calcs'!AA20","v":202.82635936413865},{"$f":"'Residential Bill Calcs'!AB20","v":203.81672597275369},{"$f":"'Residential Bill Calcs'!AC20","v":204.81192837304064},{"$f":"'Residential Bill Calcs'!AD20","v":205.81199017734761},{"$f":"'Residential Bill Calcs'!AE20","v":206.81693511331775},{"$f":"'Residential Bill Calcs'!AF20","v":207.82678702445227},{"$f":"'Residential Bill Calcs'!AG20","v":208.84156987067615},{"$f":"'Residential Bill Calcs'!AH20","v":209.86130772890658},{"$f":"'Residential Bill Calcs'!AI20","v":210.88602479362427},{"$f":"'Residential Bill Calcs'!AJ20","v":211.91574537744745}]
[null,"Adjusted Bill",null,null,null,null,null,null,null,{"$f":"'Residential Bill Calcs'!C28","v":123.25526503769711},{"$f":"'Residential Bill Calcs'!D28","v":125.72037033845108},{"$f":"'Residential Bill Calcs'!E28","v":128.23477774522001},{"$f":"'Residential Bill Calcs'!F28","v":130.79947330012442},{"$f":"'Residential Bill Calcs'!G28","v":133.41546276612686},{"$f":"'Residential Bill Calcs'!H28","v":142.08746784592506},{"$f":"'Residential Bill Calcs'!I28","v":151.32315325591017},{"$f":"'Residential Bill Calcs'!J28","v":161.15915821754433},{"$f":"'Residential Bill Calcs'!K28","v":171.63450350168475},{"$f":"'Residential Bill Calcs'!L28","v":182.79074622929434},{"$f":"'Residential Bill Calcs'!M28","v":194.6721447341985},{"$f":"'Residential Bill Calcs'!N28","v":215.13738311477829},{"$f":"'Residential Bill Calcs'!O28","v":214.28430786499121},{"$f":"'Residential Bill Calcs'!P28","v":216.26087100206377},{"$f":"'Residential Bill Calcs'!Q28","v":218.82420402826401},{"$f":"'Residential Bill Calcs'!R28","v":220.95401877709168},{"$f":"'Residential Bill Calcs'!S28","v":222.82996514233577},{"$f":"'Residential Bill Calcs'!T28","v":224.10148537611741},{"$f":"'Residential Bill Calcs'!U28","v":220.67309324282576},{"$f":"'Residential Bill Calcs'!V28","v":221.53673953655519},{"$f":"'Residential Bill Calcs'!W28","v":222.40548937877506},{"$f":"'Residential Bill Calcs'!X28","v":223.27936401445538},{"$f":"'Residential Bill Calcs'!Y28","v":224.15838480753465},{"$f":"'Residential Bill Calcs'!Z28","v":225.04257324143742},{"$f":"'Residential Bill Calcs'!AA28","v":225.93195091959507},{"$f":"'Residential Bill Calcs'!AB28","v":226.82653956596909},{"$f":"'Residential Bill Calcs'!AC28","v":227.72636102557701},{"$f":"'Residential Bill Calcs'!AD28","v":228.63143726502176},{"$f":"'Residential Bill Calcs'!AE28","v":229.54179037302336},{"$f":"'Residential Bill Calcs'!AF28","v":230.45744256095344},{"$f":"'Residential Bill Calcs'!AG28","v":231.37841616337317},{"$f":"'Residential Bill Calcs'!AH28","v":209.86130772890667},{"$f":"'Residential Bill Calcs'!AI28","v":210.88602479362433},{"$f":"'Residential Bill Calcs'!AJ28","v":211.91574537744754}]
[null,"Fractional change from status quo",null,null,null,null,null,null,null,{"$f":"J17/J15-1","v":-0.19285714285714251},{"$f":"K17/K15-1","v":-0.19021117707615831},-0.18777739497427237,-0.22057016456201572,-0.19562526968456828,-0.15983197411466643,-0.12916407435216171,-8.6507577125323865E-2,-7.2114261829561821E-2,1.2480459296971169E-2,2.5107385329469212E-2,0.12963985509274623,0.13022316548621871,0.12786307672308994,0.1261762859983695,0.1238342002424353,0.12171486985073132,0.1200129805417105,0.1202566771652489,{"$f":"AC17/AC16-1","v":0.1191762682863553},{"$f":"AD17/AD16-1","v":0.11810556600648869},0.11704448311971616,0.11599293320357873,0.11495083061205391,0.11391809046857881,0.11289462865913835,0.11188036182541294,0.11087520735799061,0.10987908338963814,0.1088919087886322,0.10791360315215415,0,0,0]

{"sheet":"Near-term Impact Summary","index":1,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Average Monthly Residential Bill (750 kWh/month)","Actual 2016",2017,2018,2019,2020,2021]
[null,"Total Bill (includes HST)",{"$f":"C4*1.13","v":158.29094390666668},{"$f":"D4*1.13","v":164.34035338359607},167.07944267848356,169.91037391952025,180.60015290179948,178.49945428935391]
[null,"Total Bill (excludes HST)",{"$f":"'IESO Res Bill'!C12","v":140.08048133333335},{"$f":"'IESO Res Bill'!D12","v":145.43394104743015},{"$f":"'IESO Res Bill'!E12","v":147.85791387476422},{"$f":"'IESO Res Bill'!F12","v":150.36316276063741},{"$f":"'IESO Res Bill'!G12","v":159.82314416088451},{"$f":"'IESO Res Bill'!H12","v":157.96411884013622}]
[null,"Impact of GA Financing",null,{"$f":"'Residential Bill Calcs'!C15","v":-26.047974344861473},{"$f":"'Residential Bill Calcs'!D15","v":-26.124227838144144},{"$f":"'Residential Bill Calcs'!E15","v":-26.234803003285002},{"$f":"'Residential Bill Calcs'!F15","v":-32.252217208385083},{"$f":"'Residential Bill Calcs'!G15","v":-27.901773348586836}]
[null,"Impact of Tax-Basing Social Programs",null,-2,-2,-2,-3,-3]
[null,"Subtotal",null,{"$f":"SUM(D4:D6)","v":117.38596670256868},{"$f":"SUM(E4:E6)","v":119.73368603662007},122.1283597573524,124.57092695249943,127.06234549154939]
[null,"8% rebate",null,{"$f":"-D7*0.08","v":-9.3908773362054951},{"$f":"-E7*0.08","v":-9.5786948829296055},-9.7702687805881929,-9.9656741561999542,-10.164987639323952]
[null,"HST",null,{"$f":"D7*0.13","v":15.260175671333929},{"$f":"E7*0.13","v":15.56537918476061},15.876686768455812,16.194220503824926,16.518104913901421]
[null,"Revised Bill (includes HST)",{"$f":"C3","v":158.29094390666668},{"$f":"SUM(D7:D9)","v":123.25526503769711},{"$f":"SUM(E7:E9)","v":125.72037033845108},128.23477774522001,130.79947330012442,133.41546276612686]
[null,"Year-over-Year Change",null,{"$f":"D10/C10-1","v":-0.22133722880335915},{"$f":"E10/D10-1","v":2.000000000000024E-2},{"$f":"F10/E10-1","v":1.9999999999999352E-2},2.0000000000000018E-2,1.9999999999999574E-2]
[null,"Change from Forecast",null,{"$f":"D10/D3-1","v":-0.24999999999999956},{"$f":"E10/E3-1","v":-0.2475413592300586},-0.24527988028582826,-0.27575103786735966,-0.25257215324672255]

{"sheet":"Debt Calcs","index":2,"n_rows":22,"n_cols":37,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Class B share of consumption",0.82]
[null,"Class B share of GA cost",0.88]
[null,"Annual interest on debt",5.1159999999999997E-2,"This is equivalent to 5% compounded monthly"]
[]
[null,"Average Growth Rate 2028-2034",{"$f":"AVERAGE(O11:U11)","v":-7.0826129140114907E-2}]
[]
[null,null,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050]
[null,"IESO Class B GA Rate - Revised Base ($2016/MWh)",{"$f":"'IESO HOEP-GA'!C14","v":90.857322870794135},{"$f":"'IESO HOEP-GA'!D14","v":88.992161882316481},{"$f":"'IESO HOEP-GA'!E14","v":85.366798369420309},{"$f":"'IESO HOEP-GA'!F14","v":82.269923504985755},{"$f":"'IESO HOEP-GA'!G14","v":84.959951950507261},{"$f":"'IESO HOEP-GA'!H14","v":74.22519073286179},{"$f":"'IESO HOEP-GA'!I14","v":71.360985163238198},{"$f":"'IESO HOEP-GA'!J14","v":67.39454863013701},{"$f":"'IESO HOEP-GA'!K14","v":71.779572018465828},{"$f":"'IESO HOEP-GA'!L14","v":66.570880119412607},{"$f":"'IESO HOEP-GA'!M14","v":62.645695257041098},{"$f":"'IESO HOEP-GA'!N14","v":67.12117214647887},{"$f":"'IESO HOEP-GA'!O14","v":64.471749381149991},{"$f":"'IESO HOEP-GA'!P14","v":58.473026782935889},{"$f":"'IESO HOEP-GA'!Q14","v":55.291821001290728},{"$f":"'IESO HOEP-GA'!R14","v":48.258233464459622},{"$f":"'IESO HOEP-GA'!S14","v":47.88165494222288},{"$f":"'IESO HOEP-GA'!T14","v":43.543336678190968},{"$f":"'IESO HOEP-GA'!U14","v":39.918575685580805},{"$f":"'IESO HOEP-GA'!V14","v":28.183721696889208}]
[null,"Relative change in GA",null,{"$f":"D10/C10-1","v":-2.0528460772832324E-2},-4.0738009238278305E-2,-3.6277275516799823E-2,3.2697592642814133E-2,-0.12635083908591327,-3.8588052672467121E-2,-5.5582704246977088E-2,6.5064956698410947E-2,-7.2565101080753869E-2,-5.8962490135786805E-2,7.1441092178392784E-2,-3.9472236264691984E-2,-9.304420394660462E-2,-5.4404670951179956E-2,-0.12720846247163597,-7.8034046255356371E-3,-9.0605019172098511E-2,-8.3244906549057696E-2]
[null,"IESO Class B GA Rate - Revised Base Extrapolated ($2016/MWh)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V10*(1+C7)","v":26.187577784336277},{"$f":"W12*(1+$C$7)","v":24.332813018316074},22.609414061138551,21.008076781062023,19.520156021981077,18.137618930733055,16.853001590050763,15.659368723035266,14.550276251604895,13.51973650678438,12.562185903014544,11.672454901965505,10.845740103696729,10.077578314492181,9.3638224513703356]
[null,"Assumed IESO Class B GA Rate - ($2016/MWh)",{"$f":"C10+C12","v":90.857322870794135},{"$f":"D10+D12","v":88.992161882316481},85.366798369420309,82.269923504985755,84.959951950507261,74.22519073286179,71.360985163238198,67.39454863013701,71.779572018465828,66.570880119412607,62.645695257041098,67.12117214647887,64.471749381149991,58.473026782935889,55.291821001290728,48.258233464459622,47.88165494222288,43.543336678190968,39.918575685580805,28.183721696889208,26.187577784336277,24.332813018316074,22.609414061138551,21.008076781062023,19.520156021981077,18.137618930733055,16.853001590050763,15.659368723035266,14.550276251604895,13.51973650678438,12.562185903014544,11.672454901965505,{"$f":"AI10+AI12","v":10.845740103696729},10.077578314492181,9.3638224513703356]
[null,"Total GA Cost (2016$ million)",null,{"$f":"D13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!C10","v":11858.205570818671},{"$f":"E13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!D10","v":11375.125882725257},{"$f":"F13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!E10","v":10885.806696500615},{"$f":"G13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!F10","v":11241.74636945121},{"$f":"H13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!G10","v":9821.3422828800303},{"$f":"I13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!H10","v":9442.3558095539247},{"$f":"J13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!I10","v":8917.5241391967647},{"$f":"K13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!J10","v":9497.7424611706374},{"$f":"L13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!K10","v":8808.5378194368222},{"$f":"M13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!L10","v":8230.7900972944208},{"$f":"N13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!M10","v":8881.351459927273},{"$f":"O13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!N10","v":8530.7846567512552},{"$f":"P13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!O10","v":7737.0445893239257},{"$f":"Q13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!P10","v":7367.6351484219895},{"$f":"R13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!Q10","v":6430.4096091392439},{"$f":"S13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!R10","v":6424.8475177019063},{"$f":"T13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!S10","v":5883.2985579964843},{"$f":"U13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!T10","v":5430.7407739519704},{"$f":"V13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!U10","v":3886.7914376528115},{"$f":"W13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!V10","v":3626.5378743836122},{"$f":"X13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!W10","v":3383.710488536276},{"$f":"Y13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!X10","v":3157.1424501326692},{"$f":"Z13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!Y10","v":2945.7450583313571},{"$f":"AA13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!Z10","v":2748.5025100210373},{"$f":"AB13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!AA10","v":2564.4670187009065},{"$f":"AC13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!AB10","v":2392.7542601932632},{"$f":"AD13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!AC10","v":2232.5391233041819},{"$f":"AE13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!AD10","v":2083.0517450133925},{"$f":"AF13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!AE10","v":1943.5738111417361},{"$f":"AG13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!AF10","v":1813.4351047202267},{"$f":"AH13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!AG10","v":1692.0102854749985},{"$f":"AI13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!AH10","v":1578.715884952976},{"$f":"AJ13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!AI10","v":1473.0075028493},{"$f":"AK13*('Debt Calcs'!$C$3/'Debt Calcs'!$C$4)*'Residential Bill Calcs'!AJ10","v":1374.3771910643436}]
[null,"Total GA Cost (nominal $ million)",null,{"$f":"D14*1.02^(D9-2016)","v":12095.369682235045},11834.680968387356,11552.105152780023,12168.427804857231,10843.555476184305,10633.626262038733,10243.432169611806,11128.119052974123,10527.01808843752,10033.287200750003,11042.844229096907,10819.097642104838,10008.692180866097,9721.4381123383864,8654.4846953957476,8819.9388296880807,8238.0383223817407,7756.4351319563648,5662.3211916579985,5388.8445108572041,5128.5761049688263,4880.8780456486584,4645.1432149781613,4420.7938173939892,4207.2799634878011,4004.0783222051691,3810.6908381400954,3626.6435107811549,3451.4852327171438,3284.7866839546605,3126.139279637503,2975.1541685887391,2831.4612802208057,2694.7084174775991]
[]
[null,"Proposed GA Paid by Ratepayer (nominal $ million)",null,9594.7641451283434,9326.7550959255186,9051.1762399074269,9093.8667909781707,8183.7164951497889,8179.5529671335189,8205.709757477116,9742.5172799303891,9315.9585299723167,10236.412086038163,11475.726879482034,13060.648789778163,12250.243328539422,11962.989260011709,10896.035843069072,11061.489977361405,10479.589470055063,9997.9862796296875,7903.8723393313221,7630.3956585305277,7370.1272526421499,7122.429193321982,6886.6943626514849,6662.3449650673128,6448.8311111611247,6245.6294698784932,6052.241985813419,5868.1946584544785,5693.0363803904675,5526.3378316279841,5367.6904273108266,2975.1541685887391,2831.4612802208057,2694.7084174775991]
[null,"Difference from forecast",null,{"$f":"D15-D17","v":2500.6055371067014},2507.9258724618376,2500.9289128725959,3074.5610138790598,2659.8389810345161,2454.0732949052144,2037.7224121346899,1385.6017730437343,1211.0595584652037,-203.12488528815993,-432.88265038512691,-2241.5511476733245,-2241.5511476733245,-2241.5511476733227,-2241.5511476733245,-2241.5511476733245,-2241.5511476733227,-2241.5511476733227,-2241.5511476733236,-2241.5511476733236,-2241.5511476733236,-2241.5511476733236,-2241.5511476733236,-2241.5511476733236,-2241.5511476733236,-2241.5511476733241,-2241.5511476733236,-2241.5511476733236,-2241.5511476733236,-2241.5511476733236,-2241.5511476733236,0,0,0]
[]
[null,"Accumulated Debt",null,{"$f":"D18","v":2500.6055371067014},{"$f":"D20*(1+$C$5) + E18","v":5136.4623888469177},7900.1727175329224,11378.906567640968,14620.890408675998,17822.968456889077,20772.513935278213,23220.837521250782,25619.875127303178,26727.463053527848,27661.957412961208,26835.592006534978,25966.949745915983,25053.867747243723,24094.072473519387,23085.174073591319,22024.660431522931,20909.890911526323,19738.089782886691,18506.339308505852,17211.572479855691,15850.565380251788,14419.929157432147,12916.101585453052,11335.338194891508,9673.7029492688343,7927.0584444801052,6091.0556068263841,4161.1228639982992,2132.4547620471285,1.3596945791505277E-10,1.4292565538198689E-10,1.5023773191132934E-10,1.5792389427591296E-10]
[null,"Total Amount paid by ratepayer",null,{"$f":"D17","v":9594.7641451283434},{"$f":"E17","v":9326.7550959255186},9051.1762399074269,9093.8667909781707,8183.7164951497889,8179.5529671335189,8205.709757477116,9742.5172799303891,9315.9585299723167,10236.412086038163,11475.726879482034,13060.648789778163,12250.243328539422,11962.989260011709,10896.035843069072,11061.489977361405,10479.589470055063,9997.9862796296875,7903.8723393313221,7630.3956585305277,7370.1272526421499,7122.429193321982,6886.6943626514849,6662.3449650673128,6448.8311111611247,6245.6294698784932,6052.241985813419,5868.1946584544785,5693.0363803904675,5526.3378316279841,5367.6904273108266,2975.1541685887391,2831.4612802208057,2694.7084174775991]
[null,"Difference in payment",null,{"$f":"D21-D$15","v":-2500.6055371067014},{"$f":"E21-E$15","v":-2507.9258724618376},-2500.9289128725959,-3074.5610138790598,-2659.8389810345161,-2454.0732949052144,-2037.7224121346899,-1385.6017730437343,-1211.0595584652037,203.12488528815993,432.88265038512691,2241.5511476733245,2241.5511476733245,2241.5511476733227,2241.5511476733245,2241.5511476733245,2241.5511476733227,2241.5511476733227,{"$f":"V21-V$15","v":2241.5511476733236},{"$f":"W21-W$15","v":2241.5511476733236},2241.5511476733236,2241.5511476733236,2241.5511476733236,2241.5511476733236,2241.5511476733236,2241.5511476733241,2241.5511476733236,2241.5511476733236,2241.5511476733236,2241.5511476733236,2241.5511476733236,{"$f":"AI21-AI$15","v":0},0,0]

{"sheet":"Residential Bill Calcs","index":3,"n_rows":28,"n_cols":36,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[null,"RPP-eligible share of consumption",{"$f":"C7/C10","v":0.50349650349650354}]
[null,"RPP-eligible share of GA savings",1]
[null,"Average monthly residential consumtion (MW)",0.75]
[null,"Average Demand Growth Rate 2026-2035",{"$f":"AVERAGE(L11:U11)","v":4.1624831880135993E-3}]
[null,"Average Residential Bill Annual Growth Rate 2029-2035",{"$f":"AVERAGE(O18:U18)","v":4.8828298832550255E-3}]
[null,"Assumed RPP Eligible Demand (TWh)",72]
[]
[null,null,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050]
[null,"OPO Demand - Outlook B + Extrapolation",143,143,142,142,142,142,142,142,142,141,142,142,142,143,143,144,145,146,148,{"$f":"U10*(1+$C$5)","v":148.61604751182603},149.23465931106304,149.85584607151426,150.4796185114125,151.10598739360495,151.73496352573903,152.36655776044879,153.00078099554216,153.63764417418906,154.27715828511015,154.91933436276642,155.56418348754968,156.21171678597366,156.86194543086603,157.51488064156112]
[null,"Year-over-year growth",null,{"$f":"D10/C10-1","v":0},{"$f":"E10/D10-1","v":-6.9930069930069783E-3},0,0,0,0,0,0,-7.0422535211267512E-3,7.0921985815601829E-3,0,0,7.0422535211267512E-3,0,6.9930069930070893E-3,6.9444444444444198E-3,6.8965517241379448E-3,1.3698630136986356E-2]
[]
[null,null,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050]
[null,"Change in Ratepayer GA Cost ($ million)",{"$f":"'Debt Calcs'!D22","v":-2500.6055371067014},{"$f":"'Debt Calcs'!E22","v":-2507.9258724618376},{"$f":"'Debt Calcs'!F22","v":-2500.9289128725959},{"$f":"'Debt Calcs'!G22","v":-3074.5610138790598},{"$f":"'Debt Calcs'!H22","v":-2659.8389810345161},{"$f":"'Debt Calcs'!I22","v":-2454.0732949052144},{"$f":"'Debt Calcs'!J22","v":-2037.7224121346899},{"$f":"'Debt Calcs'!K22","v":-1385.6017730437343},{"$f":"'Debt Calcs'!L22","v":-1211.0595584652037},{"$f":"'Debt Calcs'!M22","v":203.12488528815993},{"$f":"'Debt Calcs'!N22","v":432.88265038512691},{"$f":"'Debt Calcs'!O22","v":2241.5511476733245},{"$f":"'Debt Calcs'!P22","v":2241.5511476733245},{"$f":"'Debt Calcs'!Q22","v":2241.5511476733227},{"$f":"'Debt Calcs'!R22","v":2241.5511476733245},{"$f":"'Debt Calcs'!S22","v":2241.5511476733245},{"$f":"'Debt Calcs'!T22","v":2241.5511476733227},{"$f":"'Debt Calcs'!U22","v":2241.5511476733227},{"$f":"'Debt Calcs'!V22","v":2241.5511476733236},{"$f":"'Debt Calcs'!W22","v":2241.5511476733236},{"$f":"'Debt Calcs'!X22","v":2241.5511476733236},{"$f":"'Debt Calcs'!Y22","v":2241.5511476733236},{"$f":"'Debt Calcs'!Z22","v":2241.5511476733236},{"$f":"'Debt Calcs'!AA22","v":2241.5511476733236},{"$f":"'Debt Calcs'!AB22","v":2241.5511476733236},{"$f":"'Debt Calcs'!AC22","v":2241.5511476733241},{"$f":"'Debt Calcs'!AD22","v":2241.5511476733236},{"$f":"'Debt Calcs'!AE22","v":2241.5511476733236},{"$f":"'Debt Calcs'!AF22","v":2241.5511476733236},{"$f":"'Debt Calcs'!AG22","v":2241.5511476733236},{"$f":"'Debt Calcs'!AH22","v":2241.5511476733236},{"$f":"'Debt Calcs'!AI22","v":0},{"$f":"'Debt Calcs'!AJ22","v":0},{"$f":"'Debt Calcs'!AK22","v":0}]
[null,"Change in Average Monthly Residential Bill - pretax(nominal $/month)",{"$f":"$C$4*(C14*$C$3/(C$10*$C$2))","v":-26.047974344861473},-26.124227838144144,-26.234803003285002,-32.252217208385083,-27.901773348586836,-25.743286470910036,-21.375755937152334,-14.534995125091989,-12.704043196928119,2.1458967639041715,4.5409491641045436,23.513924157664714,23.513924157664714,23.349491121597111,23.349491121597129,23.18734187769715,23.027429175092323,22.869707057454704,22.560656962083705,22.46713787838215,22.374006452674386,22.281261078029349,22.188900154177073,22.09692208748109,22.005325290910896,21.914108184014633,21.823269192891718,21.732806750165807,21.642719294957644,21.553005272858208,21.463663135901829,0,0,0]
[]
[null,"$/month",2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050]
[null,"Relative change in Status Quo",null,{"$f":"D19/C19-1","v":1.6667174181462574E-2},{"$f":"E19/D19-1","v":1.6943623917182737E-2},6.2914221984718521E-2,-1.1631765414881978E-2,1.9628290285414574E-2,2.7494297392737899E-2,1.5268695821667677E-2,4.8479775408326375E-2,-2.3982831394409931E-2,5.1881690233566813E-2,2.8625737918126504E-3,-4.4793135790750505E-3,1.1335854676570722E-2,1.3368524135688453E-2,1.1837291675015571E-2,1.0395619089651253E-2,7.2344325836548595E-3,-1.5512599398720628E-2]
[null,"IESO Bill Forecast",{"$f":"'IESO Res Bill'!D15","v":152.70563809980166},{"$f":"'IESO Res Bill'!E15","v":155.25080956850243},{"$f":"'IESO Res Bill'!F15","v":157.88132089866929},{"$f":"'IESO Res Bill'!G15","v":167.81430136892874},{"$f":"'IESO Res Bill'!H15","v":165.86232478214305},{"$f":"'IESO Res Bill'!I15","v":169.11791864038065},{"$f":"'IESO Res Bill'!J15","v":173.76769698992013},{"$f":"'IESO Res Bill'!K15","v":176.42090309889093},{"$f":"'IESO Res Bill'!L15","v":184.97374885845929},{"$f":"'IESO Res Bill'!M15","v":180.53755462719494},{"$f":"'IESO Res Bill'!N15","v":189.90414811188873},{"$f":"'IESO Res Bill'!O15","v":190.44776274923035},{"$f":"'IESO Res Bill'!P15","v":189.59468749944327},{"$f":"'IESO Res Bill'!Q15","v":191.74390532438679},{"$f":"'IESO Res Bill'!R15","v":194.307238350587},{"$f":"'IESO Res Bill'!S15","v":196.60730980550969},{"$f":"'IESO Res Bill'!T15","v":198.65116450848882},{"$f":"'IESO Res Bill'!U15","v":200.08829296579},{"$f":"'IESO Res Bill'!V15","v":196.98440343263786}]
[null,"IESO Bill Forecast Extrapolated",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U19*(1+C6)","v":197.94624476425392},{"$f":"V20*(1+$C$6)","v":198.91278260346695},199.88403988252458,200.86003964564873,201.84080504958229,202.82635936413865,203.81672597275369,204.81192837304064,205.81199017734761,206.81693511331775,207.82678702445227,208.84156987067615,209.86130772890658,210.88602479362427,211.91574537744745]
[null,"Debt Financed GA"]
[null,"Pre-tax Forecast, no rebate",{"$f":"'IESO Res Bill'!D12","v":145.43394104743015},{"$f":"'IESO Res Bill'!E12","v":147.85791387476422},{"$f":"'IESO Res Bill'!F12","v":150.36316276063741},{"$f":"'IESO Res Bill'!G12","v":159.82314416088451},{"$f":"'IESO Res Bill'!H12","v":157.96411884013622},{"$f":"'IESO Res Bill'!I12","v":161.06468441941013},{"$f":"'IESO Res Bill'!J12","v":165.49304475230488},{"$f":"'IESO Res Bill'!K12","v":168.01990771322946},{"$f":"'IESO Res Bill'!L12","v":176.16547510329457},{"$f":"'IESO Res Bill'!M12","v":171.94052821637615},{"$f":"'IESO Res Bill'!N12","v":180.86109343989401},{"$f":"'IESO Res Bill'!O12","v":181.37882166593366},{"$f":"'IESO Res Bill'!P12","v":180.56636904708881},{"$f":"'IESO Res Bill'!Q12","v":182.61324316608267},{"$f":"'IESO Res Bill'!R12","v":185.05451271484475},{"$f":"'IESO Res Bill'!S12","v":187.24505695762826},{"$f":"'IESO Res Bill'!T12","v":189.19158524617981},{"$f":"'IESO Res Bill'!U12","v":190.56027901503808},{"$f":"'IESO Res Bill'!V12","v":187.6041937453694},{"$f":"U22*(1+C6)","v":188.52023310881327},{"$f":"V22*(1+$C$6)","v":189.44074533663519},190.36575226907101,191.29527585299877,192.22933814245931,193.16796129917967,194.11116759309877,195.05897940289589,196.01141921652157,196.96850963173125,197.93027335662129,198.89673321016784,199.86791212276825,200.84383313678509,201.82451940709288]
[null,"Cost Savings due to tax-basing of social programs",{"$f":"'Near-term Impact Summary'!D6","v":-2},{"$f":"'Near-term Impact Summary'!E6","v":-2},{"$f":"'Near-term Impact Summary'!F6","v":-2},{"$f":"'Near-term Impact Summary'!G6","v":-3},{"$f":"'Near-term Impact Summary'!H6","v":-3}]
[null,"Pre-tax Financing Impact",{"$f":"C15","v":-26.047974344861473},-26.124227838144144,-26.234803003285002,-32.252217208385083,-27.901773348586836,-25.743286470910036,-21.375755937152334,-14.534995125091989,-12.704043196928119,2.1458967639041715,4.5409491641045436,23.513924157664714,23.513924157664714,23.349491121597111,23.349491121597129,23.18734187769715,23.027429175092323,22.869707057454704,22.560656962083705,22.46713787838215,22.374006452674386,22.281261078029349,22.188900154177073,22.09692208748109,22.005325290910896,21.914108184014633,21.823269192891718,21.732806750165807,21.642719294957644,21.553005272858208,21.463663135901829,0,0,0]
[null,"Pre-tax sub-total",{"$f":"SUM(C22:C24)","v":117.38596670256868},119.73368603662007,122.1283597573524,124.57092695249943,127.06234549154939,135.32139794850008,144.11728881515256,153.48491258813746,163.46143190636644,174.08642498028033,185.40204260399855,204.89274582359837,204.08029320475353,205.96273428767978,208.40400383644189,210.43239883532542,212.21901442127213,213.4299860724928,210.1648507074531,210.98737098719542,211.81475178930958,212.64701334710037,213.48417600717585,214.3262602299404,215.17328659009056,216.02527577711339,216.88224859578762,217.7442259666874,218.61122892668891,219.48327862947949,220.36039634606968,199.86791212276825,200.84383313678509,201.82451940709288]
[null,"8% Rebate",{"$f":"-C25*0.08","v":-9.3908773362054951},-9.5786948829296055,-9.7702687805881929,-9.9656741561999542,-10.164987639323952,-10.825711835880007,-11.529383105212204,-12.278793007050997,-13.076914552509315,-13.926913998422426,-14.832163408319884,-16.39141966588787,-16.326423456380283,-16.477018743014384,-16.672320306915353,-16.834591906826034,-16.977521153701773,-17.074398885799425,-16.81318805659625,-16.878989678975636,-16.945180143144768,-17.011761067768031,-17.078734080574069,-17.146100818395233,-17.213862927207245,-17.282022062169073,-17.35057988766301,-17.419538077334991,-17.488898314135113,-17.55866229035836,-17.628831707685574,-15.989432969821459,-16.067506650942807,-16.145961552567432]
[null,"HST",{"$f":"C25*0.13","v":15.260175671333929},15.56537918476061,15.876686768455812,16.194220503824926,16.518104913901421,17.591781733305012,18.735247545969834,19.953038636457872,21.249986147827638,22.631235247436443,24.102265538519813,26.63605695706779,26.530438116617958,26.775155457398373,27.092520498737446,27.356211848592306,27.588471874765379,27.745898189424064,27.321430591968905,27.428358228335405,27.535917732610248,27.644111735123047,27.75294288093286,27.862413829892255,27.972527256711775,28.083285851024741,28.19469231745239,28.306749375669362,28.419459760469561,28.532826221832334,28.64685152498906,25.982828575959871,26.109698307782065,26.237187522922074]
[null,"Modified Bill after tax ($/month)",{"$f":"SUM(C25:C27)","v":123.25526503769711},125.72037033845108,128.23477774522001,130.79947330012442,133.41546276612686,142.08746784592506,151.32315325591017,161.15915821754433,171.63450350168475,182.79074622929434,194.6721447341985,215.13738311477829,214.28430786499121,216.26087100206377,218.82420402826401,220.95401877709168,222.82996514233577,224.10148537611741,220.67309324282576,221.53673953655519,222.40548937877506,223.27936401445538,224.15838480753465,225.04257324143742,225.93195091959507,226.82653956596909,227.72636102557701,228.63143726502176,229.54179037302336,230.45744256095344,231.37841616337317,209.86130772890667,210.88602479362433,211.91574537744754]

{"sheet":"Historical Data","index":4,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"750 kWh/month",2010,2011,2012,2013,2014,2015,2016]
[null,"Electricity",null,null,null,null,68.78,75.510000000000005,82.61]
[null,"Distribution",null,null,null,null,32.67,36.03,37.57]
[null,"Transmission",null,null,null,null,10.25,11.92,12.75]
[null,"Regulatory",null,null,null,null,4.5,4.68,4.75]
[null,"DRC",null,null,null,null,5.25,5.25,0]
[null,"Tax",null,null,null,null,15.79,17.34,17.899999999999999]
[null,"OCEB",null,null,null,null,-13.72,-15.07,0]
[null,"Total",104,105,112,116.41,123.51,135.65,155.58000000000001]

{"sheet":"IESO HOEP-GA","index":5,"n_rows":14,"n_cols":22,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"HOEP (2016$/MWh)"]
[null,null,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035]
[null,"Revised Base",18.137578551912288,23.934740867580583,25.744051369863712,27.174449771689495,30.500462204007722,34.237067351597915,36.075020547945378,40.45125913242088,34.824615209471759,44.054005707762848,39.058687214612128,39.894207762556725,39.219793943533737,40.291285388128287,41.660391552510973,47.073474885844611,46.062777777778493,48.012502283104723,49.791178082191173,55.807228310501493]
[]
[]
[null,"Class A GA (2016$/MWh)"]
[null,null,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035]
[null,"Revised Base",40.720502180612648,39.884572948947927,38.259754847688896,36.87179517987407,38.077414118674881,33.266300894558505,31.982619123421138,30.204938663640306,32.170221689868221,29.83578630115268,28.07659404567752,30.082416588950078,28.894996333938145,26.206484402006819,24.780729241328398,21.628410775613105,21.459635534923706,19.515284845855689,17.890736782584202,12.631401240470279]
[]
[]
[null,"Class B GA (2016$/MWh)"]
[null,null,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035]
[null,"Revised Base",90.857322870794135,88.992161882316481,85.366798369420309,82.269923504985755,84.959951950507261,74.22519073286179,71.360985163238198,67.39454863013701,71.779572018465828,66.570880119412607,62.645695257041098,67.12117214647887,64.471749381149991,58.473026782935889,55.291821001290728,48.258233464459622,47.88165494222288,43.543336678190968,39.918575685580805,28.183721696889208]

{"sheet":"IESO Res Bill","index":6,"n_rows":15,"n_cols":22,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Revised Base Case with updated share values (provided by Joyce Poon, IESO Feb 17, 2017)"]
[null,"Residential Monthly Bills - Based on TOU Shares (65% Off-Peak, 17% Mid-Peak, 18% On-peak)"]
[null,"Updated 2016 History with Revised share values on TOU rates","2016 Act",2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035]
[null,"Distribution",39.906489333333347,41.613788851525612,43.256650944325024,44.877078761663142,46.714007434674087,48.165983639649127,49.498850666117647,51.14152503195352,52.588205461981502,54.350464707000761,55.704838245838467,57.371150794344061,58.602906350555081,60.020147319289762,61.468462780924135,62.987242521330899,64.347506943700168,65.557477420662622,66.604720638758337,67.409916019587001]
[null,"Transmission",12.796202000000001,13.097130394679295,13.401445767372994,13.787624922245282,14.669319528450828,14.927394612660752,15.581030906254119,15.858679986575419,16.124081682519904,16.502654437573284,16.897154146322038,17.25978042830468,17.568789251055147,17.922700552625347,18.256276861430713,18.601776948172596,18.922529243142929,20.046942199382389,20.302714867541152,20.540934376986055]
[null,"Regulated Charges (Wholesale Uplift and DRC)",4.8802899999999996,5.7197934015309295,5.890857807562174,5.988401726565173,6.2099401284600679,6.4982016609414597,6.6977031698709482,7.0726113830216883,7.1325520282674848,7.7477683705247982,7.8473584212751524,8.0359435654958773,8.159876520001756,8.3390633220130912,8.4828591233886108,8.7812344340902087,8.8024877471644665,8.9793972692781328,9.0986949792503182,9.3562878207677933]
[null,"DRC",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Commodity",82.497500000000002,85.003228399694308,85.308959355504015,85.710057350163822,92.229877069299533,88.3725389268849,89.287099677167404,91.420228350754243,92.175068540460572,97.564587588195735,91.491177402940522,98.194218651749395,97.047249544321673,94.284457853160632,94.405644400339213,94.684258811251041,95.172533023620687,94.607768356856667,94.554148529488259,90.297055528028537]
[null," Total Bill before Taxes",140.08048133333335,145.43394104743015,147.85791387476422,150.36316276063741,159.82314416088451,157.96411884013622,161.06468441941013,165.49304475230488,168.01990771322946,176.16547510329457,171.94052821637615,180.86109343989401,181.37882166593366,180.56636904708881,182.61324316608267,185.05451271484475,187.24505695762826,189.19158524617981,190.56027901503808,187.6041937453694]
[null,"HST",18.210462573333338,18.906412336165921,19.221528803719348,19.547211158882863,20.777008740914987,20.535335449217708,20.938408974523316,21.514095817799635,21.842588002719829,22.901511763428296,22.3522686681289,23.511942147186222,23.579246816571377,23.473627976121545,23.739721611590749,24.057086652929819,24.341857404491677,24.594906082003376,24.772836271954951,24.388545186898021]
[null,"8% Rebate on Bill before Taxes",0,-11.634715283794412,-11.828633109981139,-12.029053020850993,-12.785851532870762,-12.637129507210899,-12.885174753552811,-13.239443580184391,-13.441592617058356,-14.093238008263565,-13.755242257310092,-14.46888747519152,-14.510305733274693,-14.445309523767106,-14.609059453286614,-14.804361017187579,-14.979604556610262,-15.135326819694384,-15.244822321203046,-15.008335499629553]
[null,"  Total Bill After Rebate",158.29094390666668,152.70563809980166,155.25080956850243,157.88132089866929,167.81430136892874,165.86232478214305,169.11791864038065,173.76769698992013,176.42090309889093,184.97374885845929,180.53755462719494,189.90414811188873,190.44776274923035,189.59468749944327,191.74390532438679,194.307238350587,196.60730980550969,198.65116450848882,200.08829296579,196.98440343263786]