{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["2.1","2.2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":4,"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":"2.1","index":0,"n_rows":59,"n_cols":11,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[null,"Table 2.1"]
[null,"Summary of Customers, Energy Sales and Revenues"]
[]
[null,null,null,null,null,null,null,null,null,null,"Forecast"]
[null,"Line No.",null,"Description","2018 Approved",null,"2018\n Actual","2019 Actual","2020 Forecast",null,2021]
[null,1,null,"Residential"]
[null,2,null,"Customers",1635.4831134093349,null,1689.1354166666667,1730.3204444444445,1755.8856150000001,null,1779.7967268777782]
[null,3,null,"Sales in MWh",13718.756359540899,null,15625.65309,15384.37,16729.719988945362,null,16209.745867303323]
[null,4,null,"MWh sales per customer",{"$f":"E8/E7","v":8.3881981092074511},null,{"$f":"G8/G7","v":9.2506811092953125},{"$f":"H8/H7","v":8.8910525500607331},{"$f":"I8/I7","v":9.5277960284134799},null,{"$f":"K8/K7","v":9.1076388794912511}]
[null,5,null,"Revenue ($000s)",2016.4486459742025,null,2261.9300099999996,2262.4463700000006,2413.2055025728914,null,2384.1188693170443]
[null,6,null,"Cents per KWh",{"$f":"SUM(E10/E8)*100","v":14.698479899541589},null,{"$f":"SUM(G10/G8)*100","v":14.475747010200646},{"$f":"SUM(H10/H8)*100","v":14.706135967868692},{"$f":"SUM(I10/I8)*100","v":14.424661645069287},null,{"$f":"SUM(K10/K8)*100","v":14.707934898140817}]
[null,7,null,"General Service"]
[null,8,null,"Customers",489.12268518518516,null,506,517.13888888888891,516.37734736111111,null,513.53938439814817]
[null,9,null,"Sales in MWh",25436.270312173448,null,27170.822899999999,29148.333999999999,32249.774759311502,null,32322.926762187584]
[null,10,null,"MWh sales per customer",{"$f":"E14/E13","v":52.00386545666575},null,{"$f":"G14/G13","v":53.697278458498019},{"$f":"H14/H13","v":56.364614277273454},{"$f":"I14/I13","v":62.453891372501879},null,{"$f":"K14/K13","v":62.941475852079051}]
[null,11,null,"Revenue ($000s)",4054.4476339490839,null,4490.1586199999992,4833.266340000001,5350.8017566907201,null,5388.0779262706401]
[null,12,null,"Cents per KWh",{"$f":"SUM(E16/E14)*100","v":15.939631023690925},null,{"$f":"SUM(G16/G14)*100","v":16.525662975043716},{"$f":"SUM(H16/H14)*100","v":16.581621234338819},{"$f":"SUM(I16/I14)*100","v":16.591749234297456},null,{"$f":"SUM(K16/K14)*100","v":16.669523666321545}]
[null,13,null,"Industrial"]
[null,14,null,"Sales in MWh",32192.510670058487,null,36909.889659999993,27286.06719999999,64856.373884166685,null,102903.86099999998]
[null,15,null,"Revenue ($000s)",3951.5815796545494,null,4377.7479400000002,3672.8377635519992,7259.6428043321366,null,11535.495389324258]
[null,16,null,"Cents per KWh",{"$f":"SUM(E20/E19)*100","v":12.274847464226593},null,{"$f":"SUM(G20/G19)*100","v":11.860636757048493},{"$f":"SUM(H20/H19)*100","v":13.460487862288929},{"$f":"IF(I19=0,0,SUM(I20/I19)*100)","v":11.19341457062931},null,{"$f":"IF(K19=0,0,SUM(K20/K19)*100)","v":11.2099733452414}]
[null,17,null,"Street lights"]
[null,18,null,"Sales in MWh",213.636,null,223.86439000000001,167.79,167.64,null,167.64]
[null,19,null,"Revenue ($000s)",55.56324295455358,null,87.487780000000015,81.862750000000005,81.852720000000005,null,81.841440000000006]
[null,20,null,"Cents per KWh",{"$f":"SUM(E24/E23)*100","v":26.008370758932752},null,39.080704170949211,48.788813397699506,{"$f":"SUM(I24/I23)*100","v":48.826485325697931},null,48.819756621331436]
[null,21,null,"Space lights"]
[null,22,null,"Sales in MWh",11.724,null,11.24933,10.071999999999999,9.5640000000000001,null,9.8040000000000003]
[null,23,null,"Revenue ($000s)",2.632959421354049,null,3.2859400000000005,2.6859899999999999,2.6885400000000002,null,2.6050800000000001]
[null,24,null,"Cents per KWh",{"$f":"SUM(E28/E27)*100","v":22.457859274599532},null,{"$f":"SUM(G28/G27)*100","v":29.210095179001776},{"$f":"SUM(H28/H27)*100","v":26.667891183478954},{"$f":"SUM(I28/I27)*100","v":28.111041405269766},null,{"$f":"SUM(K28/K27)*100","v":26.57160342717258}]
[null,25,null,"Total Company - Firm Retail & Ind."]
[null,26,null,"Customers",{"$f":"E7+E13","v":2124.6057985945199},null,{"$f":"G7+G13","v":2195.135416666667},2247.4593333333332,{"$f":"I7+I13","v":2272.262962361111},null,2293.3361112759262]
[null,27,null,"Sales in MWh",{"$f":"E8+E14+E19+E23+E27","v":71572.897341772841},null,{"$f":"G8+G14+G19+G23+G27","v":79941.479370000001},71996.633199999982,{"$f":"I8+I14+I19+I23+I27","v":114013.07263242354},null,151613.9776294909]
[null,28,null,"Revenue ($000s)",{"$f":"E10+E16+E20+E24+E28","v":10080.674061953745},null,{"$f":"G10+G16+G20+G24+G28","v":11220.610289999999},{"$f":"H10+H16+H20+H24+H28","v":10853.099213552001},{"$f":"I10+I16+I20+I24+I28","v":15108.191323595749},null,19392.138704911944]
[null,29,null,"Cents per KWh",{"$f":"SUM(E33/E32)*100","v":14.084485100298233},null,{"$f":"SUM(G33/G32)*100","v":14.036030329219562},{"$f":"SUM(H33/H32)*100","v":15.074453805920474},{"$f":"SUM(I33/I32)*100","v":13.251279853060652},null,{"$f":"SUM(K33/K32)*100","v":12.79046893176419}]
[null,30,null,"Wholesale sales"]
[null,31,null,"Sales in MWh",314700,null,332270.26475999999,331494.72499999998,351774.54976409348,null,343537]
[null,32,null,"Revenue ($000s)",26113.806,null,27571.786660000009,27507.078784739999,29190.252139424469,null,28506.700260000001]
[null,33,null,"Cents per KWh",{"$f":"SUM(E37/E36)*100","v":8.298},null,{"$f":"SUM(G37/G36)*100","v":8.2980000271511543},{"$f":"SUM(H37/H36)*100","v":8.2978933630814176},{"$f":"SUM(I37/I36)*100","v":8.2979999999999965},null,{"$f":"SUM(K37/K36)*100","v":8.298}]
[null,34,null,"Total Company - Firm"]
[null,35,null,"Sales in MWh",{"$f":"E32+E36","v":386272.89734177286},null,{"$f":"G32+G36","v":412211.74413000001},{"$f":"H32+H36","v":403491.35819999996},{"$f":"I32+I36","v":465787.62239651702},null,495150.9776294909]
[null,36,null,"Revenue ($000s)",{"$f":"E33+E37","v":36194.480061953742},null,{"$f":"G33+G37","v":38792.396950000009},38360.177998291998,{"$f":"I33+I37","v":44298.443463020216},null,47898.838964911949]
[null,37,null,"Cents per KWh",{"$f":"SUM(E41/E40)*100","v":9.3701836994090204},null,{"$f":"SUM(G41/G40)*100","v":9.4107937249274443},{"$f":"SUM(H41/H40)*100","v":9.5070630928551072},{"$f":"SUM(I41/I40)*100","v":9.5104380908837705},null,{"$f":"SUM(K41/K40)*100","v":9.67358263013538}]
[null,38,null,"Secondary"]
[null,39,null,"Sales in MWh",2059.48,null,257.95499999999998,0.48,0,null,0]
[null,40,null,"Revenue ($000s)",115.33088000000001,null,19.622690000000002,3.6480000000000005E-2,0,null,0]
[null,41,null,"Cents per KWh",{"$f":"IFERROR(SUM(E45/E44)*100,0)","v":5.6000000000000005},null,{"$f":"IFERROR(SUM(G45/G44)*100,0)","v":7.6070206043689801},0,{"$f":"IFERROR(SUM(I45/I44)*100,0)","v":0},null,0]
[null,42,null,"Total Company "]
[null,43,null,"Sales in MWh",{"$f":"E40+E44","v":388332.37734177284},null,{"$f":"G40+G44","v":412469.69913000002},{"$f":"H40+H44","v":403491.83819999994},{"$f":"I40+I44","v":465787.62239651702},null,495150.9776294909]
[null,44,null,"Revenue ($000s)",{"$f":"E41+E45","v":36309.810941953743},null,38812.019640000006,38360.214478292,{"$f":"I41+I45","v":44298.443463020216},null,47898.838964911949]
[null,45,null,"Cents per KWh",{"$f":"IFERROR(SUM(E49/E48)*100,0)","v":9.3501889259152193},null,{"$f":"IFERROR(SUM(G49/G48)*100,0)","v":9.4096656607416485},9.5070608241839789,{"$f":"IFERROR(SUM(I49/I48)*100,0)","v":9.5104380908837705},null,9.67358263013538]
[]
[null,46,null,"Rider J ($000s)",13230.791882056994,null,13328.94691037172,13842.354589999999,15289.315925823339,null,15896.893167655031]
[]
[null,47,null,"Total Sales Revenues1",{"$f":"E49+E52","v":49540.602824010741},null,{"$f":"G49+G52","v":52140.966550371726},{"$f":"H49+H52","v":52202.569068291996},{"$f":"I49+I52","v":59587.759388843551},null,{"$f":"K49+K52","v":63795.732132566976}]
[]
[null,48,null,"Total Sales Revenues excluding secondary sales",{"$f":"E54-E45","v":49425.271944010739},null,{"$f":"G54-G45","v":52121.34386037173},{"$f":"H54-H45","v":52202.532588291993},{"$f":"I54-I45","v":59587.759388843551},null,{"$f":"K54-K45","v":63795.732132566976}]
[]
[null,null,null,"Note:"]
[null,null,null,"1. Excludes revenues from other revenues."]

{"sheet":"2.2","index":1,"n_rows":67,"n_cols":11,"rows_kept":67,"cut":false,"hidden":false,"merged":[[66,3,66,10],[65,3,65,10]]}
[null,"Table 2.2"]
[null,"Summary of Energy Balance, Losses, Peak and Load Factor"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Forecast"]
[null,"Line No.",null,"Description","2018 Approved",null,"2018 Actual","2019 Actual","2020 Forecast",null,2021]
[null,null,null,"Sales and Losses"]
[null,1,null,"Total Energy Sales",{"$f":"'2.1'!E48","v":388332.37734177284},null,{"$f":"'2.1'!G48","v":412469.69913000002},{"$f":"'2.1'!H48","v":403491.83819999994},{"$f":"'2.1'!I48","v":465787.62239651702},null,{"$f":"'2.1'!K48","v":495150.9776294909}]
[null,2,null,"Losses - MWh",{"$f":"E11-E8","v":34173.24920607591},null,{"$f":"G11-G8","v":37898.229050000024},{"$f":"H11-H8","v":37184.604750000115},{"$f":"I11-I8","v":42192.791058191797},null,{"$f":"K11-K8","v":43575.106031395146}]
[null,3,null,"Losses - %",{"$f":"E9/E8","v":8.7999999999999745E-2},null,{"$f":"G9/G8","v":9.1881243955463168E-2},{"$f":"H9/H8","v":9.2157018382039033E-2},{"$f":"I9/I8","v":9.0583753258848501E-2},null,{"$f":"K9/K8","v":8.8003675646584928E-2}]
[null,4,null,"Total Generation",{"$f":"E25+E27+E37+E39","v":422505.62654784875},null,{"$f":"G25+G27+G37+G39","v":450367.92818000005},{"$f":"H25+H27+H37+H39+H28","v":440676.44295000006},{"$f":"I25+I27+I37+I39+I28","v":507980.41345470882},null,{"$f":"K25+K27+K37+K39+K28","v":538726.08366088604}]
[]
[null,5,null,"Secondary Sales Related Generation",{"$f":"'2.1'!E44*(1+E10)","v":2240.7142399999993},null,{"$f":"'2.1'!G44*(1+G10)","v":281.6562262845315},0,{"$f":"'2.1'!I44*(1+I10)","v":0},null,{"$f":"'2.1'!K44*(1+K10)","v":0}]
[]
[null,6,null,"Firm Load Generation",{"$f":"E11-E13","v":420264.91230784875},null,{"$f":"G11-G13","v":450086.27195371554},{"$f":"H11-H13","v":440676.44295000006},{"$f":"I11-I13","v":507980.41345470882},null,{"$f":"K11-K13","v":538726.08366088604}]
[]
[null,null,null,"Actual Generation - MWh"]
[]
[null,null,null,"Hydro Generation"]
[]
[null,7,null,"Whitehorse",218265.58171178418,null,228694.73130000001,233672.68900000001,263230.87360499182,null,259116.24127290875]
[null,8,null,"Aishihik",116502.92592163374,null,126747.5006,97293.46,118791.94929199557,null,176164.99520412867]
[null,9,null,"Mayo",76628.203591388548,null,57609.951230000006,39852.662120000008,54702.540499999996,null,71201.355183848616]
[]
[null,10,null,"Total Hydro",{"$f":"E21+E22+E23","v":411396.71122480644},null,{"$f":"G21+G22+G23","v":413052.18313000002},{"$f":"H21+H22+H23","v":370818.81112000003},{"$f":"I21+I22+I23","v":436725.36339698738},null,{"$f":"K21+K22+K23","v":506482.59166088607}]
[]
[null,11,null,"Wind Turbine",0,null,0,0,0,null,0]
[null,12,null,"IPPs",0,null,0,0,55.72,null,1983.07]
[]
[null,null,null,"Diesel Generation1"]
[]
[null,{"$f":"B28+1","v":13},null,"Whitehorse",999.75923095576582,null,5518.0387999999984,2187.61265,13847.71603299661,null,1869.796516005079]
[null,{"$f":"B32+1","v":14},null,"Faro",233.97453971847176,null,301.79725000000002,801.6931800000001,889.23551066404866,null,237.13903676240238]
[null,{"$f":"B33+1","v":15},null,"Dawson",520.73656748725443,null,1279.3889999999999,720.03599999999994,2936.2198577466579,null,822.96844453012625]
[null,{"$f":"B34+1","v":16},null,"Mayo",17.776984880805536,null,86.52,83.79,748.42528199922162,null,21.112093717572019]
[]
[null,{"$f":"B35+1","v":17},null,"Total Diesel",{"$f":"SUM(E32:E35)","v":1772.2473230422975},null,{"$f":"SUM(G32:G35)","v":7185.7450499999986},{"$f":"SUM(H32:H36)","v":3793.1318300000003},{"$f":"SUM(I32:I36)","v":18421.596683406537},null,{"$f":"SUM(K32:K36)","v":2951.0160910151799}]
[]
[null,{"$f":"B37+1","v":18},null,"LNG Generation1",9336.6679999999997,null,30130,66064.5,52777.733374314885,null,27309.405908984812]
[]
[null,{"$f":"B39+1","v":19},null,"Total Thermal1",{"$f":"E37+E39","v":11108.915323042296},null,{"$f":"G37+G39","v":37315.745049999998},{"$f":"H37+H39","v":69857.631829999998},{"$f":"I37+I39","v":71199.330057721425},null,{"$f":"K37+K39","v":30260.421999999991}]
[]
[null,null,null,"Source - %"]
[]
[null,{"$f":"B41+1","v":20},null,"Hydro Generation",{"$f":"E25/E11","v":0.97370705944484215},null,{"$f":"G25/G11","v":0.91714386679176252},{"$f":"H25/H11","v":0.84147636446741902},{"$f":"I25/I11","v":0.85972874510431396},null,{"$f":"K25/K11","v":0.94014863401287174}]
[]
[null,{"$f":"B45+1","v":21},null,"LNG Generation",{"$f":"E39/E11","v":2.2098328195737347E-2},null,{"$f":"G39/G11","v":6.6900856199418005E-2},{"$f":"H39/H11","v":0.14991611432130897},{"$f":"I39/I11","v":0.10389718181333091},null,{"$f":"K39/K11","v":5.0692562950368239E-2}]
[]
[null,{"$f":"B47+1","v":22},null,"Diesel Generation",{"$f":"E37/E11","v":4.1946123594204738E-3},null,{"$f":"G37/G11","v":1.5955277008819439E-2},{"$f":"H37/H11","v":8.607521211271953E-3},{"$f":"I37/I11","v":3.6264383813784572E-2},null,{"$f":"K37/K11","v":5.4777672374088484E-3}]
[]
[null,{"$f":"B49+1","v":23},null,"IPP Generation",{"$f":"E27/E11","v":0},null,{"$f":"G27/G11","v":0},{"$f":"H28/H11","v":0},{"$f":"I28/I11","v":1.0968926857052522E-4},null,{"$f":"K28/K11","v":3.6810357993512163E-3}]
[]
[null,null,null,"LTA Generation - MWh"]
[]
[null,{"$f":"B51+1","v":24},null,"LTA Hydro Generation",{"$f":"E15-E56-E58","v":403909.91230784875},null,{"$f":"G15-G56-G58","v":418694.98011070536},{"$f":"H15-H56-H58-H57","v":415376.59204565629},{"$f":"I15-I56-I58-I57","v":438905.34032728348},null,{"$f":"K15-K56-K58-K57","v":452437.23225850571}]
[null,{"$f":"B55+1","v":25},null,"LTA Wind Generation",0,null,0,0,0,null,0]
[null,{"$f":"B56+1","v":26},null,"IPP Generation",{"$f":"E28","v":0},null,{"$f":"G28","v":0},{"$f":"H28","v":0},{"$f":"I28","v":55.72},null,{"$f":"K28","v":1983.07}]
[null,{"$f":"B57+1","v":27},null,"LTA Thermal Generation",16355,null,31391.291843010142,25299.850904343759,69019.353127425376,null,84305.781402380308]
[null,28,null,"Total LTA Generation",{"$f":"SUM(E55:E58)","v":420264.91230784875},null,{"$f":"SUM(G55:G58)","v":450086.27195371548},{"$f":"SUM(H55:H58)","v":440676.44295000006},{"$f":"SUM(I55:I58)","v":507980.41345470882},null,538726.08366088604]
[]
[null,null,null,"Peak - MW2"]
[]
[null,{"$f":"B59+1","v":29},null,"Integrated System",92.926039814756223,null,92.99,90,103.8,null,112.68899999999999]
[]
[null,null,"Notes:"]
[null,null,1,"Actual thermal generation reflects actual generation required for maintenance, capital, RFID and all other generation, e.g., peaking. Forecast Actual Generation includes peaking, maintenance (diesel of 0.198 GW.h in 2021, and LNG of 0 MW.h) and capital (0.234 GW.h diesel) requirements reflecting short-term hydro generation forecasts."]
[null,null,2,"Peak load is one-hour maximum load on the grid (forecasts assume weather normalized temperature). "]