Spreadsheet: diana_scholtes__8584__PORTLANDGE August variances worksheet
Sheet: Pivot P & S

 |  | Data
Act Date | Deal Type | Sum of Gross MW | Average of Price | Sum of Total Amt | PGE MW | PGE $
2001-08-01 00:00:00 | P | -3717 | 47.03454545454544 | -174441.93
 | S | 3706 | 39.713125 | 168099.38
8/1/2001 Total |  | -11 | 43.95184210526318 | -6342.55
2001-08-02 00:00:00 | P | -3302 | 43.81 | -163622.42
 | S | 3305 | 39.956 | 158185.02
8/2/2001 Total |  | 3 | 41.81655172413792 | -5437.40000000001
2001-08-03 00:00:00 | P | -3252 | 43.3025 | -156546.24
 | S | 3255 | 39.92 | 151113.84
8/3/2001 Total |  | 3 | 41.56 | -5432.400000000029 | 2652 | 123611.84
2001-08-04 00:00:00 | P | -3402 | 43.86 | -164463.24
 | S | 3408 | 40.62888888888888 | 159015.84
8/4/2001 Total |  | 6 | 42.19828571428573 | -5447.400000000058
2001-08-05 00:00:00 | P | -2952 | 43.32 | -129888.24
 | S | 2952 | 42.17 | 124485.84
8/5/2001 Total |  | 0 | 42.745 | -5402.4
2001-08-06 00:00:00 | P | -3252 | 55.6825 | -199682.16
 | S | 3255 | 51.57176470588234 | 194249.76
8/6/2001 Total |  | 3 | 53.56484848484846 | -5432.400000000027
2001-08-07 00:00:00 | P | -4365 | 48.29526315789476 | -223832.55
 | S | 4368 | 45.15550000000002 | 218288.85
8/7/2001 Total |  | 3 | 46.68512820512824 | -5543.700000000009
2001-08-08 00:00:00 | P | -4765 | 49.30526315789474 | -241144.42
 | S | 4768 | 49.572 | 239695.92
8/8/2001 Total |  | 3 | 49.44205128205126 | -1448.499999999977
2001-08-09 00:00:00 | P | -7581 | 51.67333333333334 | -433054.06
 | S | 7584 | 48.41909090909092 | 423151.16
8/9/2001 Total |  | 3 | 50.00837209302327 | -9902.900000000063
2001-08-10 00:00:00 | P | -6165 | 41.96263157894737 | -291201.63
 | S | 6168 | 39.13849999999999 | 285437.93
8/10/2001 Total |  | 3 | 40.51435897435897 | -5763.700000000008
2001-08-11 00:00:00 | P | -6162 | 42.97857142857143 | -291043.74
 | S | 6168 | 38.60130434782608 | 285280.34
8/11/2001 Total |  | 6 | 40.69045454545454 | -5763.40000000002
2001-08-12 00:00:00 | P | -4752 | 34.41 | -164631.84
 | S | 4752 | 33.47 | 159049.44
8/12/2001 Total |  | 0 | 33.94 | -5582.4
2001-08-13 00:00:00 | P | -3965 | 39.48555555555556 | -166459.58
 | S | 3968 | 36.64947368421053 | 160955.88
8/13/2001 Total |  | 3 | 38.0291891891892 | -5503.700000000015
2001-08-14 00:00:00 | P | -3563 | 40.03777777777778 | -150897.44
 | S | 3579 | 32.10363636363635 | 145433.94
8/14/2001 Total |  | 16 | 35.674 | -5463.499999999986
2001-08-15 00:00:00 | P | -3102 | 38.19846153846154 | -132782.76
 | S | 3137 | 30.1675 | 127365.36
8/15/2001 Total |  | 35 | 33.76758620689655 | -5417.40000000003
2001-08-16 00:00:00 | P | -4702 | 36.9923076923077 | -197192.12
 | S | 4761 | 24.57894736842106 | 191614.72
8/16/2001 Total |  | 59 | 29.621875 | -5577.399999999983
2001-08-17 00:00:00 | P | -7150 | 35.61652173913043 | -269516.56
 | S | 7163 | 29.83839999999999 | 259688.16
8/17/2001 Total |  | 13 | 32.60708333333335 | -9828.399999999958
2001-08-18 00:00:00 | P | -7144 | 34.905 | -267475.56
 | S | 7163 | 29.8276 | 259547.16
8/18/2001 Total |  | 19 | 32.20425531914896 | -7928.40000000006
2001-08-19 00:00:00 | P | -2952 | 37.07 | -111438.24
 | S | 3000 | 28.736 | 106035.84
8/19/2001 Total |  | 48 | 32.44 | -5402.399999999992
2001-08-20 00:00:00 | P | -3494 | 41.1823076923077 | -150098.26
 | S | 3513 | 31.498125 | 141141.66
8/20/2001 Total |  | 19 | 35.83931034482759 | -8956.600000000006
2001-08-21 00:00:00 | P | -3902 | 32.17352941176471 | -139247.62
 | S | 3906 | 29.28055555555555 | 133190.22
8/21/2001 Total |  | 4 | 30.68571428571427 | -6057.399999999985
2001-08-22 00:00:00 | P | -3702 | 30.41375 | -122832.72
 | S | 3738 | 22.49619047619048 | 117355.32
8/22/2001 Total |  | 36 | 25.92 | -5477.399999999992
2001-08-23 00:00:00 | P | -3542 | 29.54545454545455 | -108247.04
 | S | 3609 | 19.4375 | 102749.64
8/23/2001 Total |  | 67 | 23.55555555555556 | -5497.399999999978
2001-08-24 00:00:00 | P | -3942 | 24.78538461538462 | -102061.86
 | S | 3985 | 17.11166666666666 | 96524.46
8/24/2001 Total |  | 43 | 20.32967741935484 | -5537.399999999989
2001-08-25 00:00:00 | P | -4215 | 25.07071428571429 | -109926
 | S | 4255 | 19.79647058823529 | 104320.35
8/25/2001 Total |  | 40 | 22.17838709677419 | -5605.65
2001-08-26 00:00:00 | P | -6192 | 30.08 | -183258.48
 | S | 6192 | 28.905 | 177496.08
8/26/2001 Total |  | 0 | 29.4925 | -5762.39999999998
2001-08-27 00:00:00 | P | -4342 | 35.10076923076922 | -159072.86
 | S | 4368 | 27.631875 | 153495.46
8/27/2001 Total |  | 26 | 30.98 | -5577.4
2001-08-28 00:00:00 | P | -3942 | 34.006 | -139663.8
 | S | 3963 | 23.29714285714286 | 134126.4
8/28/2001 Total |  | 21 | 27.75916666666667 | -5537.39999999998
2001-08-29 00:00:00 | P | -4142 | 29.55 | -128056.26
 | S | 4166 | 16.80227272727273 | 122468.86
8/29/2001 Total |  | 24 | 21.53714285714287 | -5587.399999999985
2001-08-30 00:00:00 | P | -3142 | 25.55399999999999 | -90479.58
 | S | 3167 | 18.58769230769231 | 85022.18
8/30/2001 Total |  | 25 | 21.61652173913044 | -5457.399999999986
2001-08-31 00:00:00 | P | -3142 | 25.55399999999999 | -90479.58
 | S | 3162 | 18.58769230769231 | 85022.18
8/31/2001 Total |  | 20 | 21.61652173913044 | -5457.399999999986
Grand Total |  | 540 | 35.43236514522808 | -183131.6