Spreadsheet: cooper_richey__4340__MarketShareAnalysis
Sheet: pivot

 | counterparty | jan | feb | [NAME] | apr | may | jun | jul | aug | sep | oct | nov | dec
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | pool demand | 4604769 | 4228041 | 4537860 | 4280238 | 4462249 | 4290261 | 4602629 | 4617582 | 4407394 | 4650640 | 4755769 | 1677491
 | Sum of demand | monthn
 | desig | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Grand Total
 | AQUILA | 9554.41000127792 | 9052.1799993515 | 9330.84000205993 | 12279.7100152969 | 14739.5200014114 | 14628.420006752 | 14372.8399705886 | 14576.3599529266 | 15234.1399984359 | 13966.2499837875 | 13101.949991703 | 383.569999694824 | 141220.1899232861
 | ATCO | 237922.699630737 | 224274.099990844 | 217697.830032348 | 192248.809997558 | 188114.829956054 | 179165.840072631 | 178700.879989624 | 176926.489990234 | 174927.54989624 | 193572.690109252 | 162624.379928588 | 6594.07006835937 | 2132770.16966247
 | BP | 180288.329772949 | 160662.610107421 | 158843.909866333 | 154352.420074462 | 185706.340103149 | 185276.780014038 | 208715.729843139 | 190936.16998291 | 185772.419784545 | 189016.449920654 | 145035.440041542 | 675.789999961853 | 1945282.389511104
 | CORAL | 92533.9799575805 | 84842.4099349975 | 106945.070106506 | 103279.3097229 | 108314.150138854 | 107410.769859313 | 111888.560142517 | 129895.049972534 | 112260.480026245 | 129470.059997558 | 113282.550154685 | 1804.7300081253 | 1201927.120021815
 | DUKE | 0 |  |  |  |  |  |  |  |  | 1010.21000182628 | 2381.42997288703 | 85.9700005054473 | 3477.609975218757
 | DYNEGY | 51204.4100074768 | 55456.3599281311 | 71349.7000198364 | 69484.4299926757 | 83780.7998886108 | 73986.1100616455 | 85253.4200439453 | 92963.7601547241 | 93548.7099075317 | 99496.8200149536 | 85603.3199148178 | 1263.91999149322 | 863391.759925842
 | ENCORE | 24097.9899997711 | 29486.7800064086 | 33775.6099967956 | 38654.0199546813 | 47826.3499259948 | 92184.3599243164 | 137758.719924926 | 139225.829696655 | 132643.109970092 | 130080.999984741 | 116793.519912719 | 1748.77998268604 | 924276.0692797868
 | ENMAX | 820244.09979248 | 759838.139770507 | 819452.401367187 | 773633.20928955 | 791910.179748535 | 755014.770751953 | 811696.15045166 | 814198.140075683 | 764306.349731445 | 807402.009521484 | 791803.569561004 | 2031.99000930786 | 8711531.010070797
 | ENRON | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | EPCOR | 1380817.368103026 | 1176064.601196288 | 1204367.630310058 | 1026298.151809691 | 996757.720581054 | 796708.1208953849 | 982556.9409484849 | 1001674.282104491 | 903006.8599853499 | 915002.689437865 | 677231.798469543 | 7620.679967880245 | 11068106.84380911
 | IQ2 | 5032.03000307083 | 7131.36000156402 | 9939.70000362396 | 4761.63000965118 | 5124.49001669883 | 11734.6299967765 | 10541.2700123786 | 14707.5299911499 | 13696.0000066757 | 18189.21999573702 | 17026.09997934094 | 85.7699996829032 | 117969.7300163504
 | MISC | 924554.3202988864 | 878529.0399230943 | 1031281.420326916 | 1070915.500409852 | 1199016.860772594 | 1094500.779879602 | 1181668.6206356 | 1157800.429924727 | 1097440.40959003 | 1163998.499364644 | 967869.7999356019 | 12103.16999689113 | 11779678.85105844
 | NEXEN | 20828.4699959754 | 23106.5699677467 | 33427.9499282836 | 32392.9100842475 | 35398.8399672508 | 37898.5400657653 | 27924.7600293159 | 38963.6801261901 | 36260.2600741386 | 38379.9999513626 | 31836.8300361037 | 68.9900012016296 | 356487.8002275818
 | PANCAN | 40875.360092163 | 42428.5799407958 | 47798.9701042175 | 43852.549999237 | 46611.7499580383 | 43843.4700355529 | 50150.9099426269 | 50304.989906311 | 63970.5200576782 | 54419.140007019 | 42827.2200303077 | 194.499999523162 | 527277.9600734704
 | REA | 26593.32002973554 | 27609.8999880552 | 29054.24998939035 | 26763.75002712011 | 21786.4800173342 | 16387.55000104007 | 21024.24999755617 | 14889.7199889924 | 13661.10001840628 | 20764.34000325199 | 13512.76001061497 | 34.4999996423721 | 232081.9200711397
 | UNKNOWN | 365732.8701157003 | 336485.0900227193 | 332656.1600075501 | 297205.0095519554 | 298158.0098498047 | 286814.9703001482 | 298926.339838487 | 306072.9101001616 | 280976.9299653502 | 298974.390059608 | 288698.299906291 | 10673.3299279958 | 3401374.309645772
 | DIRECT ENERGY | 669.579999506473 | 1266.4299981594 | 1350.58000135421 | 691.739997327327 | 2532.02000474929 | 2424.58000522851 | 2507.78000307083 | 2318.8699991703 | 2821.32000064849 | 2651.50000667572 | 1975.10000371932 | 0 | 21209.50001960987
 | ENRON DIRECT |  |  |  | 2094.01999235153 | 12338.1399917602 | 12802.1399621963 | 15850.030011177 | 18149.5599994659 | 17685.10997390743 | 18219.8800201416 | 16995.3700215816 | 152.029999017715 | 114286.2799715993
 | TRANSCANADA | 30049.049993515 | 41605.2101669311 | 49072.5907058715 | 48821.1198348999 | 53383.7693271636 | 50721.7491054534 | 48726.5699920654 | 52568.7998542785 | 49290.1701049804 | 46504.440003395 | 71304.6901037693 | 959.520000457763 | 543007.679192781
 | Grand Total | 4210998.287793851 | 3857839.360943015 | 4156344.612768332 | 3897728.290763456 | 4091500.250249058 | 3761503.580937797 | 4188263.771777163 | 4216172.571820605 | 3957501.4390917 | 4141119.588383956 | 3559904.127974819 | 46481.30995242664 | 44085357.19245618