{"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":60,"n_cols":10,"rows_kept":60,"cut":false,"hidden":false,"merged":[[3,8,3,9]]}
[null,"Table 2.1"]
[null,"Summary of Customers, Energy Sales and Revenues"]
[]
[null,null,null,null,null,null,null,null,"GRA Forecast"]
[null,"Line No.",null,"Description","2021 Approved 2",null,"2021\n Actual","2022 Actual","2023 Forecast","2024 Forecast"]
[null,1,null,"Residential"]
[null,2,null,"Customers",1779.7967268777782,null,1812.6666666666667,1821.8333333333333,1858.0820814393944,1898.2087205643945]
[null,3,null,"Sales in MWh",16209.745867303323,null,17421.153990000003,17333.62861,17692.784046871151,18090.339959899033]
[null,4,null,"MWh sales per customer",{"$f":"E8/E7","v":9.1076388794912511},null,{"$f":"G8/G7","v":9.6107874163295346},{"$f":"H8/H7","v":9.5143876735888764},{"$f":"I8/I7","v":9.5220680634114618},{"$f":"J8/J7","v":9.5302164424364406}]
[null,5,null,"Revenue ($000s)",2384.1188693170443,null,2513.3242800000003,2472.1443200000003,2531.7944661363281,2610.7132577603902]
[null,6,null,"Cents per KWh",{"$f":"SUM(E10/E8)*100","v":14.707934898140817},null,{"$f":"SUM(G10/G8)*100","v":14.426853016985472},{"$f":"SUM(H10/H8)*100","v":14.262128118827858},{"$f":"SUM(I10/I8)*100","v":14.309757353219144},{"$f":"SUM(J10/J8)*100","v":14.43153231806353}]
[null,7,null,"General Service"]
[null,8,null,"Customers",513.53938439814817,null,527.86083333333329,519.25,528.82104861111111,536.12350198263891]
[null,9,null,"Sales in MWh",32322.926762187584,null,29584.264009999999,30661.738590000004,38568.709158506084,44698.259126585959]
[null,10,null,"MWh sales per customer",{"$f":"E14/E13","v":62.941475852079051},null,{"$f":"G14/G13","v":56.045575162645463},{"$f":"H14/H13","v":59.050050245546473},{"$f":"I14/I13","v":72.93338504547512},{"$f":"J14/J13","v":83.373064156462604}]
[null,11,null,"Revenue ($000s)",5388.0779262706401,null,4911.4838699999991,5004.8550100000011,6271.980312051458,7175.0888690444954]
[null,12,null,"Cents per KWh",{"$f":"SUM(E16/E14)*100","v":16.669523666321545},null,{"$f":"SUM(G16/G14)*100","v":16.601676716851337},{"$f":"SUM(H16/H14)*100","v":16.322802424622722},{"$f":"SUM(I16/I14)*100","v":16.261836210995444},{"$f":"SUM(J16/J14)*100","v":16.052278118314554}]
[null,13,null,"Industrial"]
[null,14,null,"Sales in MWh",102903.86099999998,null,91143.140000000014,95169.2,75045.114138777761,69367.817880341725]
[null,15,null,"Revenue ($000s)",11480.771413245669,null,11128.833615399997,12206.045143999998,9717.7062437509594,8771.3687614176233]
[null,16,null,"Cents per KWh",{"$f":"IF(E19=0,0,SUM(E20/E19)*100)","v":11.156793634055843},null,{"$f":"SUM(G20/G19)*100","v":12.210281119785861},{"$f":"SUM(H20/H19)*100","v":12.825625458656789},{"$f":"IF(I19=0,0,SUM(I20/I19)*100)","v":12.949152460186037},{"$f":"IF(J19=0,0,SUM(J20/J19)*100)","v":12.6447234891374}]
[null,17,null,"Street lights"]
[null,18,null,"Sales in MWh",167.64,null,167.64,167.685,168.18,168.18]
[null,19,null,"Revenue ($000s)",81.841440000000006,null,81.841949999999997,82.014960000000002,82.172530000000009,82.172530000000009]
[null,20,null,"Cents per KWh",{"$f":"SUM(E24/E23)*100","v":48.819756621331436},null,{"$f":"SUM(G24/G23)*100","v":48.820060844667147},48.910135074693621,{"$f":"SUM(I24/I23)*100","v":48.859870376977049},48.859870376977049]
[null,21,null,"Space lights"]
[null,22,null,"Sales in MWh",9.8040000000000003,null,8.9826700000000006,8.8439999999999994,8.8439999999999994,8.8439999999999994]
[null,23,null,"Revenue ($000s)",2.6050800000000001,null,2.4418699999999998,2.41432,2.4143700000000003,2.4143700000000003]
[null,24,null,"Cents per KWh",{"$f":"SUM(E28/E27)*100","v":26.57160342717258},null,{"$f":"SUM(G28/G27)*100","v":27.184233640999832},{"$f":"SUM(H28/H27)*100","v":27.298959746720939},{"$f":"SUM(I28/I27)*100","v":27.299525101763916},{"$f":"SUM(J28/J27)*100","v":27.299525101763916}]
[null,25,null,"Total Company - Firm Retail & Ind."]
[null,26,null,"Customers",{"$f":"E7+E13","v":2293.3361112759262},null,{"$f":"G7+G13","v":2340.5275000000001},2341.083333333333,{"$f":"I7+I13","v":2386.9031300505058},2434.3322225470333]
[null,27,null,"Sales in MWh",{"$f":"E8+E14+E19+E23+E27","v":151613.9776294909},null,{"$f":"G8+G14+G19+G23+G27","v":138325.18067000003},143341.0962,{"$f":"I8+I14+I19+I23+I27","v":131483.631344155},132333.44096682672]
[null,28,null,"Revenue ($000s)",{"$f":"E10+E16+E20+E24+E28","v":19337.414728833355},null,{"$f":"G10+G16+G20+G24+G28","v":18637.925585399997},{"$f":"H10+H16+H20+H24+H28","v":19767.473753999999},{"$f":"I10+I16+I20+I24+I28","v":18606.067921938742},18641.757788222505]
[null,29,null,"Cents per KWh",{"$f":"SUM(E33/E32)*100","v":12.754374650132505},null,{"$f":"SUM(G33/G32)*100","v":13.473993307020629},{"$f":"SUM(H33/H32)*100","v":13.790513870787603},{"$f":"SUM(I33/I32)*100","v":14.150862530741822},{"$f":"SUM(J33/J32)*100","v":14.086959163176004}]
[null,30,null,"Wholesale sales"]
[null,31,null,"Sales in MWh",343537,null,348983.05019999994,346338.67705500015,351291.2260568515,355856.9285554901]
[null,32,null,"Revenue ($000s)",28506.700260000001,null,28958.613505595986,29169.999422023902,29150.145938197533,29529.007931534565]
[null,33,null,"Cents per KWh",{"$f":"SUM(E37/E36)*100","v":8.298},null,{"$f":"SUM(G37/G36)*100","v":8.2979999999999965},{"$f":"SUM(H37/H36)*100","v":8.4223915359564572},{"$f":"SUM(I37/I36)*100","v":8.2979999999999983},{"$f":"SUM(J37/J36)*100","v":8.2979999999999983}]
[null,34,null,"Total Company - Firm"]
[null,35,null,"Sales in MWh",{"$f":"E32+E36","v":495150.9776294909},null,{"$f":"G32+G36","v":487308.23086999997},{"$f":"H32+H36","v":489679.77325500012},{"$f":"I32+I36","v":482774.85740100651},488190.36952231685]
[null,36,null,"Revenue ($000s)",{"$f":"E33+E37","v":47844.11498883336},null,{"$f":"G33+G37","v":47596.539090995982},48937.473176023901,{"$f":"I33+I37","v":47756.213860136275},48170.765719757066]
[null,37,null,"Cents per KWh",{"$f":"SUM(E41/E40)*100","v":9.6625306523445698},null,{"$f":"SUM(G41/G40)*100","v":9.7672347963466652},{"$f":"SUM(H41/H40)*100","v":9.993770592304978},{"$f":"SUM(I41/I40)*100","v":9.8920258849496392},{"$f":"SUM(J41/J40)*100","v":9.8672093361634854}]
[null,38,null,"Secondary"]
[null,39,null,"Sales in MWh",0,null,4738.7049999999999,3448.11,2931.1849999999999,2931.11]
[null,40,null,"Revenue ($000s)",0,null,330.18346517999998,364.67514256000004,357.60426999999999,357.59541999999999]
[null,41,null,"Cents per KWh",{"$f":"IFERROR(SUM(E45/E44)*100,0)","v":0},null,{"$f":"IFERROR(SUM(G45/G44)*100,0)","v":6.9677995397476735},10.576087844065301,{"$f":"IFERROR(SUM(I45/I44)*100,0)","v":12.199989765231468},12.2]
[null,42,null,"Total Company "]
[null,43,null,"Sales in MWh",{"$f":"E40+E44","v":495150.9776294909},null,{"$f":"G40+G44","v":492046.93586999999},{"$f":"H40+H44","v":493127.88325500011},{"$f":"I40+I44","v":485706.0424010065},491121.47952231683]
[null,44,null,"Revenue ($000s)",{"$f":"E41+E45","v":47844.11498883336},null,47926.722556175984,49302.148318583902,{"$f":"I41+I45","v":48113.818130136278},48528.361139757064]
[null,45,null,"Cents per KWh",{"$f":"IFERROR(SUM(E49/E48)*100,0)","v":9.6625306523445698},null,{"$f":"IFERROR(SUM(G49/G48)*100,0)","v":9.7402745677982114},9.9978423432790127,{"$f":"IFERROR(SUM(I49/I48)*100,0)","v":9.9059542047889035},9.8811318916365796]
[]
[null,46,null,"Rider J ($000s) before 2023/24 GRA",25036.060556705295,null,19429.999700050001,26347.724681863656,26264.758716410597,26182.505417564575]
[]
[null,47,null,"Total Sales Revenues1",{"$f":"E49+E52","v":72880.175545538659},null,{"$f":"G49+G52","v":67356.722256225985},{"$f":"H49+H52","v":75649.873000447551},{"$f":"I49+I52","v":74378.576846546872},{"$f":"J49+J52","v":74710.866557321642}]
[]
[null,48,null,"Total Sales Revenues excluding secondary sales",{"$f":"E54-E45","v":72880.175545538659},null,{"$f":"G54-G45","v":67026.538791045983},{"$f":"H54-H45","v":75285.197857887557},{"$f":"I54-I45","v":74020.972576546876},{"$f":"J54-J45","v":74353.271137321644}]
[]
[null,null,null,"Note:"]
[null,null,null,"1. Excludes revenues from other revenues."]
[null,null,null,"2. Reflects 2021 GRA Compliance Filing for YUB Order 2022-07 with revised Rider J as per YUB Order 2023-01."]

{"sheet":"2.2","index":1,"n_rows":67,"n_cols":10,"rows_kept":67,"cut":false,"hidden":false,"merged":[[66,3,66,9],[65,3,65,9],[4,8,4,9]]}
[null,"Table 2.2"]
[null,"Summary of Energy Balance, Losses, Peak and Load Factor"]
[]
[]
[null,null,null,null,null,null,null,null,"GRA Forecast"]
[null,"Line No.",null,"Description","2021 Approved",null,"2021\n Actual","2022 Actual","2023 Forecast","2024 Forecast"]
[null,null,null,"Sales and Losses"]
[null,1,null,"Total Energy Sales",{"$f":"'2.1'!E48","v":495150.9776294909},null,{"$f":"'2.1'!G48","v":492046.93586999999},{"$f":"'2.1'!H48","v":493127.88325500011},{"$f":"'2.1'!I48","v":485706.0424010065},{"$f":"'2.1'!J48","v":491121.47952231683}]
[null,2,null,"Losses - MWh",{"$f":"E11-E8","v":43575.106031395146},null,{"$f":"G11-G8","v":41325.560560000071},{"$f":"H11-H8","v":44361.547539999941},{"$f":"I11-I8","v":42937.907915368502},{"$f":"J11-J8","v":43218.690197963966}]
[null,3,null,"Losses - %",{"$f":"E9/E8","v":8.8003675646584928E-2},null,{"$f":"G9/G8","v":8.3987029584751613E-2},{"$f":"H9/H8","v":8.9959519723731077E-2},{"$f":"I9/I8","v":8.8403075455088312E-2},{"$f":"J9/J8","v":8.8000000000000175E-2}]
[null,4,null,"Total Generation",538726.08366088604,null,{"$f":"G25+G27+G37+G39","v":533372.49643000006},{"$f":"H25+H27+H37+H39+H28","v":537489.43079500005},{"$f":"I25+I27+I37+I39+I28","v":528643.95031637501},{"$f":"J25+J27+J37+J39+J28","v":534340.1697202808}]
[]
[null,5,null,"Secondary Sales Related Generation",{"$f":"'2.1'!E44*(1+E10)","v":0},null,5106.2134392481148,3745.2999609001286,{"$f":"'2.1'!I44*(1+I10)","v":3190.3107687278234},{"$f":"'2.1'!J44*(1+J10)","v":3189.0476800000006}]
[]
[null,6,null,"Firm Load Generation",{"$f":"E11-E13","v":538726.08366088604},null,{"$f":"G11-G13","v":528266.2829907519},{"$f":"H11-H13","v":533744.13083409995},{"$f":"I11-I13","v":525453.63954764721},{"$f":"J11-J13","v":531151.12204028084}]
[]
[null,null,null,"Actual Generation - MWh"]
[]
[null,null,null,"Hydro Generation"]
[]
[null,7,null,"Whitehorse",259116.24127290875,null,226420.30650000001,219079.12,280501.58617235208,261359.0095026003]
[null,8,null,"Aishihik",{"$f":"E25-E21-E23","v":178145.60922112866},null,192320.48699999999,192145.95699999999,130160.72835632059,125639.31143828013]
[null,9,null,"Mayo",71201.355183848616,null,74497.902589999998,80914.057499999995,71594.543749999997,73894.86]
[]
[null,10,null,"Total Hydro",{"$f":"E11-E27-E28-E37-E39","v":508463.20567788603},null,{"$f":"G21+G22+G23","v":493238.69609000004},{"$f":"H21+H22+H23","v":492139.13449999999},{"$f":"I21+I22+I23","v":482256.85827867268},{"$f":"J21+J22+J23","v":460893.18094088044}]
[]
[null,11,null,"Wind Turbine",0,null,0,0,0,0]
[null,12,null,"IPPs",{"$f":"G28","v":2.4559830000000002},null,2.4559830000000002,1952.1673950000002,6102.4087850000005,16810.506519999999]
[]
[null,null,null,"Diesel Generation1"]
[]
[null,{"$f":"B28+1","v":13},null,"Whitehorse",1869.796516005079,null,14505.01,8405.3410000000003,5404.76771662597,7922.7327772558274]
[null,{"$f":"B32+1","v":14},null,"Faro",237.13903676240238,null,2207.8673399999998,6318.7039000000004,1779.9703618777853,2029.1753476332674]
[null,{"$f":"B33+1","v":15},null,"Dawson",822.96844453012625,null,1798.201,2937.8240000000001,987.26292132554363,1668.7634675342035]
[null,{"$f":"B34+1","v":16},null,"Mayo",21.112093717572019,null,77.322000000000003,183.96,95.256635153044655,183.04386697700463]
[]
[null,{"$f":"B35+1","v":17},null,"Total Diesel",{"$f":"SUM(E32:E36)","v":2951.0160910151799},null,{"$f":"SUM(G32:G35)","v":18588.40034},{"$f":"SUM(H32:H35)","v":17845.8289},{"$f":"SUM(I32:I35)","v":8267.257634982343},{"$f":"SUM(J32:J35)","v":11803.715459400302}]
[]
[null,{"$f":"B37+1","v":18},null,"LNG Generation1",27309.405908984812,null,21545.4,25552.3,32017.425617719986,44832.76679999999]
[]
[null,{"$f":"B39+1","v":19},null,"Total Thermal1",{"$f":"E37+E39","v":30260.421999999991},null,{"$f":"G37+G39","v":40133.800340000002},{"$f":"H37+H39","v":43398.128899999996},{"$f":"I37+I39","v":40284.683252702329},{"$f":"J37+J39","v":56636.482259400291}]
[]
[null,null,null,"Source - %"]
[]
[null,{"$f":"B41+1","v":20},null,"Hydro Generation",{"$f":"E25/E11","v":0.94382511094070265},null,{"$f":"G25/G11","v":0.92475464968923982},{"$f":"H25/H11","v":0.91562569662454107},{"$f":"I25/I11","v":0.91225267590796932},{"$f":"J25/J11","v":0.86254638348105328}]
[]
[null,{"$f":"B45+1","v":21},null,"LNG Generation",{"$f":"E39/E11","v":5.0692562950368239E-2},null,{"$f":"G39/G11","v":4.0394658787637032E-2},{"$f":"H39/H11","v":4.7540097601929808E-2},{"$f":"I39/I11","v":6.0565198180284996E-2},{"$f":"J39/J11","v":8.3903044054257206E-2}]
[]
[null,{"$f":"B47+1","v":22},null,"Diesel Generation",{"$f":"E37/E11","v":5.4777672374088484E-3},null,{"$f":"G37/G11","v":3.4850691523123083E-2},{"$f":"H37/H11","v":3.320219501545222E-2},{"$f":"I37/I11","v":1.563861201860851E-2},{"$f":"J37/J11","v":2.2090264083232548E-2}]
[]
[null,{"$f":"B49+1","v":23},null,"IPP Generation",{"$f":"E27/E11","v":0},null,{"$f":"G27/G11","v":0},{"$f":"H28/H11","v":3.6320107580767708E-3},{"$f":"I28/I11","v":1.1543513893137189E-2},{"$f":"J28/J11","v":3.1460308381456803E-2}]
[]
[null,null,null,"LTA Generation - MWh"]
[]
[null,{"$f":"B51+1","v":24},null,"LTA Hydro Generation",{"$f":"E15-E56-E58","v":452796.19917622954},null,{"$f":"G15-G56-G58","v":449960.2829907519},{"$f":"H15-H56-H58-H57","v":453157.45893427683},{"$f":"I15-I56-I58-I57","v":444871.23076264723},{"$f":"J15-J56-J58-J57","v":446245.61552028084}]
[null,{"$f":"B55+1","v":25},null,"LTA Wind Generation",0,null,0,0,0,0]
[null,{"$f":"B56+1","v":26},null,"IPP Generation",{"$f":"E28","v":2.4559830000000002},null,{"$f":"G28","v":2.4559830000000002},{"$f":"H28","v":1952.1673950000002},{"$f":"I28","v":6102.4087850000005},{"$f":"J28","v":16810.506519999999}]
[null,{"$f":"B57+1","v":27},null,"LTA Thermal Generation",85929.884484656504,null,78306,78634.504504823155,74480,68095]
[null,28,null,"Total LTA Generation",{"$f":"SUM(E55:E58)","v":538728.53964388603},null,{"$f":"SUM(G55:G58)","v":528268.7389737519},{"$f":"SUM(H55:H58)","v":533744.13083409995},{"$f":"SUM(I55:I58)","v":525453.63954764721},531151.12204028084]
[]
[null,null,null,"Peak - MW2"]
[]
[null,{"$f":"B59+1","v":29},null,"Integrated System",112.68899999999999,null,104.42,114.21,119.47,123.22199999999999]
[]
[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 and capital requirements reflecting short-term hydro generation forecasts."]
[null,null,2,"Peak load is a one-hour maximum load on the grid forecast to occur in December (forecasts assume weather normalized temperature) and includes industrial peak. "]