Spreadsheet: phillip_m_love__31095__Consumers Recon
Sheet: 2000

Consumers Gas Reconciliation
2000
 | Consumers' Invoice |  |  |  | Enron's Numbers
 |  |  |  |  | Deal # | Unify |  |  | Paid | Pay Date | Comments
2000-01-01 00:00:00 | 5030-82-24 | 1983 | 0.015 | 29.75 | 145828 | 1984 | 0.015 | 29.74 | 0
Sub-Total
GST |  |  |  | 2.08 |  |  |  | 2.08
Total |  |  |  |  |  |  |  |  | 0
2000-02-01 00:00:00 | 5040-82-20 | 310000 | 0.01 | 3100 | 125167 | 267814 | 0.01 | 3000 | 3000 | 2000-03-28 00:00:00 | sale
 | 5050-82-21 | 176325 | 0.135 | 23803.88 | 129619 |  | 0.135 | 22561.74 | 22561.74 | 2000-03-28 00:00:00
 | 5050-82-21 | 46054 | 0.15 | 6908.1 | 129619 |  | 0.15 | 6547.65 | 6547.65 | 2000-03-28 00:00:00
 | 5050-82-23 |  |  | 23615.5 |  |  |  | 0 | 0
 | 5040-82-27 | 310000 | 0.06 | 18600 | 153141 | 309986 | 0.06 | 18600 | 18600 | 2000-03-28 00:00:00
 | 5040-82-29 | 310000 | 0.06 | 18600 | 155315 | 309986 | 0.06 | 18600 | 18600 | 2000-03-28 00:00:00
 |  |  |  |  | 134493 | 291715 | 0.075 | 23083.28 | 23083.28 | 2000-03-28 00:00:00
 |  |  |  |  | 107423 | 499989 | 0.0275 | 13749.7 | 13749.7 | 2000-03-28 00:00:00 | sale
 |  |  |  |  | 108341 | 500024 | 0.03875 | 19375.93 | 19375.93 | 2000-03-28 00:00:00 | sale
 |  |  |  |  | 158372 | 1000014 | -0.0075 | -7500.11 | 0 |  | sale due ENA
Sub-Total
GST |  |  |  | 6623.92 |  |  |  | 8261.28 | 8786.29
Total |  |  |  |  |  |  |  |  |  | 2000-03-28 00:00:00
2000-03-01 00:00:00 | 5040-82-16 | 150000 | 0.0925 | 13875 | 123817 | 66000 | 0.0925 | 13875 | 13875 | 2000-04-25 00:00:00 | sale
 | 5070-82-18 | 150000 | 0.06 | 9000 | 124145 | 156860 | 0.06 | 9000 | 9000 | 2000-04-25 00:00:00
 | 5040-82-19 | 310000 | 0.1025 | 31775 | 127958 | 121260 | 0.1025 | 30750 | 30750 | 2000-04-25 00:00:00 | sale
 | 5040-82-31 | 310000 | 0.09 | 27900 | 159579 | 310000 | 0.09 | 27901.16 | 27901.16 | 2000-04-25 00:00:00
 | 5040-82-32 | 155000 | 0.1275 | 19762.5 | 161221 | 155000 | 0.1275 | 19761.45 | 19761.45 | 2000-04-25 00:00:00
 | 5050-82-34 | 203203 | 0.015 | 3048.05 | 212301 | 203204 | 0.015 | 3048.06 | 6096.12 | 2000-04-25 00:00:00 | sale
 | 5030-82-36 | 56311 | 0.03 | 1689.33 | 212520 | 56309 | 0.03 | 1782.33 | 1782.33 | 2000-04-25 00:00:00
 | 5050-82-38 | 211689 | 0.02 | 4233.78 | 214640 | 209563 | 0.02 | 4191.26 | 4191.26 | 2000-04-25 00:00:00 | sale
 |  |  |  |  | 158373 | 1008994 | -0.0075 | -7567.56 | 0
Sub-Total
GST |  |  |  | 7789.86 |  |  |  | 7191.92 | 7935.01
Total
2000-04-01 00:00:00 | 5040-82-28 | 250000 | 0.04 | 10000 | 214640 | 227221 | 0.02 | 4544.42 | 4544.42 | 2001-05-30 00:00:00 | sale
 | 5050-82-34 | 203203 | 0.015 | 3048.05 | 212306 | 203203 | 0.015 | 3048.05 | 3048.05 | 2001-05-30 00:00:00
 | 5050-82-38 | 227219 | 0.02 | 4544.38 | 153101 | 249990 | 0.02 | 4999.92 | 4999.92 | 2001-05-30 00:00:00
 | 5050-82-38 | 148496 | 0.02 | 2969.92 | 214714 | 113171 | 0.02 | 2263.42 | 2263.42 | 2001-05-30 00:00:00
 |  |  |  |  | 85840 | 1013280 | -0.1925 | -195058.74 | 0 |  | open
Sub-Total
GST |  |  |  | 1439.36 |  |  |  | -12614.21 | 1039.9
Total |  |  |  |  |  |  |  |  |  | 2001-05-30 00:00:00
2000-04-01 00:00:00 | 5030-82-40 | 201810 | 0.0275 | 5549.78 | 235277 | 191279 | 0.0275 | 3675.31 | 3675.31 | 2001-05-30 00:00:00
Canadian $$ | 5030-82-45 | 2609 | 0.035 | 91.32 |  |  |  | 0
Sub-Total
GST |  |  |  | 394.88 |  |  |  | 260.66 | 260.66
Total |  |  |  |  |  |  |  |  |  | 2001-05-30 00:00:00
2000-05-01 00:00:00 | 5040-82-26 | 44998 | 0.02 | 899.96 |  |  |  | 0 | 0
 | 5040-82-29 | 106544 | 0.02 | 2130.883 |  |  |  | 0 | 0
 | 5050-82-38 | 290412 | 0.02 | 5808.24 | 214714 | 290413 | 0.02 | 5808.24 | 5808.24 | 2001-08-01 00:00:00
 | 5040-82-39 | 838 | 0.1875 | 157.13 |  |  |  | 0 | 0
 | 5040-82-41 | 310000 | 0.02 | 6200 | 238833 | 310000 | 0.01 | 3100 | 0 |  | open
 | 5040-82-42 | 16129 | 0.0175 | 282.26 | 238802 |  | 0.0175 | 282.26 | 0 |  | open
 | 5030-82-44 | 438649 | 0.005 | 2193.25 | 253194 |  | 0.005 | 1030.75 | 0 |  | open
 |  |  |  |  | 253220 |  | 0.05 | 1162.5 | 0 |  | open
 |  |  |  |  | 244658 | 155000 | -0.0495 | -7672.09 | -7672.09 | 2001-09-05 00:00:00
 |  |  |  |  | 139675 | 45000 | 0.05 | 2250 | 0 |  | open sale
Sub-Total
GST |  |  |  | 1237.02 |  |  |  | 417.32 | -130.47
Total
2000-05-01 00:00:00 | 5040-82-07 | 191 | 0.035 | 6.69 |  |  |  | 0 | 0
Canadian $$ | 5030-82-46 | 19293 | 0.035 | 675.26 | 266799 | 22558 | 0.035 | 789.52 | 0 |  | open
 | 5030-82-48 | 15468 | 0.035 | 541.38 |  |  |  | 0 | 0
Sub-Total
GST |  |  |  | 85.63 |  |  |  | 55.26
Total |  |  |  |  |  |  |  |  | 0
2000-08-01 00:00:00 | 5040-82-42 | 93586 | 0.0175 | 1637.76 | 238802 | 60586 | 0.0175 |  | 0 |  | open
 | 5050-82-50 | 310000 | 0.01625 | 5037.5 | 301716 | 310000 | 0.01625 |  | 0 |  | open
 | 5040-82-51 | 172842 | 0.05 | 8942.1 |  | 0 | 0 |  | 0
 | 5040-82-54 | 45866 | 0.02 | 917.32 | 370684 | 45867 | -0.02 |  | 0 |  | open-wrong sign on price?
 | 5030-82-55 | 35093 | 0.05 | 1754.65 |  | 0 | 0 |  | 0
 |  |  |  |  | 371164 | 12966 | 4 |  |  | 2000-10-25 00:00:00
 |  |  |  |  |  |  |  | -21125 | -21125 | 2000-10-25 00:00:00 | PTLO
 |  |  |  |  | 371764 | 7415 | 4 |  | 0
 |  |  |  |  |  |  |  | -11000 | 0 |  | PTLO
 |  |  |  |  | 159583 | 310000 | 0.09 |  | 0 |  | cleared with short pay
 |  |  |  |  | 153102 | 250015 | 0.02 |  | 0 |  | cleared with short pay
 |  |  |  |  | 238837 | 310000 | 0.01 |  | 0 |  | cleared with short pay
Sub-Total
GST |  |  |  | 1280.25 |  |  |  | 6340.58 | 2151.73
Total |  |  |  |  |  |  |  |  |  | 2000-10-25 00:00:00
2000-09-01 00:00:00 | 5040-82-31 | 310000 | 0.09 | 27900 | 159583 | 309991 | 0.09 |  | 27899.19 | 2000-10-25 00:00:00
 | 5040-82-32 | 155000 | 0.1275 | 19762.5 | 161223 | 142780 | 0.1275 |  | 18204.45 | 2000-10-25 00:00:00
 | 5040-82-39 | 123792 | 0.1875 | 23211 | 229625 | 123790 | 0.1875 |  | 23210.63 | 2000-10-25 00:00:00
 | 5040-82-42 | 358027 | 0.0175 | 6265.47 | 238802 | 188320 | 0.0175 |  | 3295.6 | 2000-10-25 00:00:00
 | 5030-82-55 | 33 | 0.05 | 1.65 |  |  |  |  | 0 |  | no deal
 | 5030-82-61 | 135000 | 0.06 | 8100 |  |  |  |  | 0 |  | no deal
 | 5070-82-62 |  |  | 17825 |  |  |  |  | 0 |  | no deal
 | 5040-82-63 | 80000 | 0.02 | 1600 | 417761 | 80000 | 0.02 |  | 1600 | 2000-10-25 00:00:00
Sub-Total
GST |  |  |  | 7326.59 |  |  |  | 5194.69 | 5194.69
Total |  |  |  |  |  |  |  |  |  | 2000-10-25 00:00:00
2000-10-01 00:00:00 | 5040-82-39 | 2115 | 0.1875 | 396.48 | 229625 | 2115 | 0.1875 |  | 0 |  | open
 | 5070-82-62 |  |  | 17850 |  |  |  |  | 0 |  | no deal
 | 5030-82-64 | 56391 | 0.01 | 563.91 | 425155 | 42818 | 0.01 |  | 0 |  | open
 |  |  |  |  | 425231 | 13571 | 0.01 |  | 0 |  | open
 |  |  |  |  | 167537 | 309994 | -0.0775 |  | 0 |  | open
 |  |  |  |  | 210481 | 310008 | -0.01 |  | 0 |  | open
 |  |  |  |  | 409984 | 310002 | 0.115 |  | 35650.23 | 2001-01-26 00:00:00 | sale
Sub-Total
GST |  |  |  | 1314.98 |  |  |  | 661.13 | 2495.52
Total |  |  |  |  |  |  |  |  |  | 2001-01-26 00:00:00
2000-11-01 00:00:00 | 5040-82-52 | 150000 | 0.035 | 5250 | 352017 | 150007 | 0.035 |  | 5250.25 | 2001-01-26 00:00:00
 | 5040-82-56 | 300000 | 0.025 | 7500 | 461415 | 299994 | 0.025 |  | 7499.85 | 2001-01-26 00:00:00
 | 5030-82-59 | 300000 | 0.085 | 25500 | 399851 | 300000 | 0.085 |  | 25500 | 2001-01-26 00:00:00 | booked as Con. Energy
 | 5070-82-62 |  |  | 17825 |  |  |  |  | 0 |  | no deal
 | 5040-82-65 | 150000 | 0.23 | 34500 | 425434 | 150007 | 0.23 |  | 34501.61 | 2001-01-26 00:00:00
 | 5050-82-68 | 100000 | 0.06 | 6000 |  |  |  |  | 0 |  | no deal
 | 5050-82-69 | 500002 | 0.055 | 27500.1 |  |  |  |  | 0 |  | no deal
 | 5030-82-67 | 406170 | 0.01 | 4061.7 | 461188 | 384960 | 0.01 |  | 0 |  | open
 |  |  |  |  | 486619 | 100000 | 0.12 |  | 12000 | 2001-01-26 00:00:00 | sale
 |  |  |  |  | 499578 | 500000 | 0.11 |  | 29425 | 2001-01-26 00:00:00 | sale-second half open
Sub-Total
GST |  |  |  | 8969.58 |  |  |  | 10052.07 | 5932.78
Total |  |  |  |  |  |  |  |  |  | 2001-01-26 00:00:00
2000-12-01 00:00:00 | 5040-82-47 | 310000 | 0.15375 | 47662.5 | 266975 | 309988 | 0.15375 |  | 47660.66 | 2001-01-26 00:00:00
 | 5040-82-53 | 155000 | 0.07 | 10850 | 352032 | 155008 | 0.07 |  | 10850.56 | 2001-01-26 00:00:00
 | 5070-82-62 |  |  | 17825 |  |  |  |  | 0 |  | no deal
 | 5030-82-66 | 59064 | 0.21 | 12403.47 | 435102 | 59053 | 0.21 | 12251.82 | 12251.82 | 2001-01-26 00:00:00 | fixed demand vol
 | 5050-82-68 | 100000 | 0.06 | 6000 |  |  |  |  | 0 |  | no deal
 |  |  |  |  | 409974 | 309987 | 0.115 |  | 0 |  | open
Sub-Total
GST |  |  |  | 6631.87 |  |  |  | 7448.92 | 4953.42
Total |  |  |  |  |  |  |  |  |  | 2001-01-26 00:00:00
2000-12-01 00:00:00 | 5030-82-67 | 498139 | 0.01 | 4981.39 | 511706 | 472130 | 0.01 |  | 0 |  | open
Canadian $$ | 5030-82-70 | 17240 | 0.01 | 172.4 | 530568 | 16341 | 0.01 | 111.87 | 0 |  | open
Sub-Total |  |  |  |  |  |  |  |  | 0
GST |  |  |  | 360.77 |  |  |  | 337.34 | 0
Total |  |  |  |  |  |  |  |  | 0