Spreadsheet: darrell_schoolcraft__7786__imbalsumm0107
Sheet: Red C

Red Cedar Gathering
 | 500538 |  | 78121 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500538 |  |  | 1999-12-01 00:00:00 | 500538 |  |  | 2000-01-01 00:00:00 | 500538 |  |  | 2000-02-01 00:00:00 | 500538 |  |  | 2000-03-01 00:00:00 | 500538
 |  |  |  |  | Imbalance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Imbalance |  |  |  | Imbalance |  |  |  | Imbalance |  |  |  | Imbalance |  |  |  | Imbalance
 | Measured | Scheduled | Measured | Scheduled | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Receipts | Deliveries | [NAME] |  | Receipts | Deliveries | [NAME] |  | Receipts | Deliveries | [NAME] |  | Receipts | Deliveries | [NAME] |  | Receipts | Deliveries | [NAME]
1 | 171921 | 173730 | 13339 | 13033 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 90127 | 82104 |  | 1 | 85280 | 90048 |  | 1 | 129902 | 129590 |  | 1 | 172290 | 178308 |  | 1 | 167385 | 169213
2 | 143612 | 143853 | 13690 | 13033 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 82193 | 85058 |  | 2 | 85760 | 85437 |  | 2 | 128605 | 131126 |  | 2 | 175368 | 183908 |  | 2 | 170184 | 169526
3 | 151374 | 153334 | 13778 | 13033 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 77703 | 79135 |  | 3 | 101183 | 103385 |  | 3 | 118612 | 121101 |  | 3 | 173456 | 173309 |  | 3 | 169674 | 169203
4 | 145410 | 145396 | 13396 | 12163 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 83833 | 84350 |  | 4 | 109515 | 109943 |  | 4 | 114483 | 119711 |  | 4 | 171128 | 174677 |  | 4 | 168897 | 175969
5 | 120413 | 119624 | 11767 | 10267 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 87296 | 90518 |  | 5 | 108361 | 108593 |  | 5 | 100931 | 123114 |  | 5 | 169630 | 166360 |  | 5 | 176704 | 173380
6 | 148882 | 150000 | 11932 | 14036 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 105367 | 105940 |  | 6 | 111639 | 115193 |  | 6 | 109406 | 113090 |  | 6 | 167764 | 167719 |  | 6 | 136216 | 176410
7 | 185662 | 189141 | 13425 | 13033 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 101440 | 101940 |  | 7 | 97086 | 98950 |  | 7 | 127221 | 127625 |  | 7 | 167835 | 167817 |  | 7 | 175529 | 171185
8 | 169546 | 169049 | 13039 | 13033 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 98057 | 98304 |  | 8 | 92901 | 108735 |  | 8 | 114657 | 112594 |  | 8 | 178511 | 180748 |  | 8 | 170291 | 172851
9 | 216217 | 204000 | 14418 | 14036 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 87213 | 94093 |  | 9 | 94766 | 105186 |  | 9 | 114565 | 112594 |  | 9 | 174336 |  |  | 9 | 153140
10 | 241083 | 251279 | 13187 | 13953 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 85026 | 96676 |  | 10 | 112558 | 113310 |  | 10 | 114225 | 114599 |  | 10 | 161862 | 158717 |  | 10 | 169575 | 170607
11 | 174465 | 161086 | 14285 | 14036 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 85017 | 82841 |  | 11 | 101279 | 102214 |  | 11 | 115735 | 115494 |  | 11 | 184527 | 185065 |  | 11 | 176731 | 175819
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 82741 | 88828 |  | 12 | 98830 | 100234 |  | 12 | 114055 | 113964 |  | 12 | 182892 | 187831 |  | 12 | 178779 | 174779
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100290 | 103318 |  | 13 | 90169 | 90019 |  | 13 | 117712 | 116959 |  | 13 | 175373 | 175571 |  | 13 | 163585 | 165793
14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 92454 | 90422 |  | 14 | 80341 | 73685 |  | 14 | 99714 | 124528 |  | 14 | 174348 |  |  | 14 | 171172 | 170890
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 92819 | 93953 |  | 15 | 100392 | 101034 |  | 15 | 120773 | 120718 |  | 15 | 171703 |  |  | 15 | 174118 | 173261
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 68795 | 80010 |  | 16 | 97736 | 92818 |  | 16 | 100073 | 121937 |  | 16 | 171702 |  |  | 16 | 180047 | 182323
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 90410 | 89096 |  | 17 | 94766 | 94662 |  | 17 | 125828 | 122594 |  | 17 | 172644 |  |  | 17 | 170607 | 170445
18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 86855 | 87128 |  | 18 | 90438 | 89668 |  | 18 | 119514 | 120375 |  | 18 | 175778 | 172040 |  | 18 | 166103 | 167903
19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 90382 | 91513 |  | 19 | 90454 | 90980 |  | 19 | 112366 | 112335 |  | 19 | 178730 |  |  | 19 | 175589 | 176446
20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 101529 | 104520 |  | 20 | 96601 | 98051 |  | 20 | 131022 | 131761 |  | 20 | 170615 |  |  | 20 | 173880 | 174805
21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 92772 | 101229 |  | 21 | 91965 |  |  | 21 | 126551 | 126375 |  | 21 | 162253 | 161166 |  | 21 | 177344 | 181409
22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 93405 | 100368 |  | 22 | 103207 | 116825 |  | 22 | 131105 | 131629 |  | 22 | 131802 | 131356 |  | 22 | 174250 | 175461
23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 87752 | 85600 |  | 23 | 100407 | 89676 |  | 23 | 122167 | 121764 |  | 23 | 159515 | 160435 |  | 23 | 176744
24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 97761 | 97012 |  | 24 | 94496 | 96183 |  | 24 | 127269 | 126812 |  | 24 | 174216 | 173432 |  | 24 | 181093 | 179131
25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 103695 | 93370 |  | 25 | 94209 | 96204 |  | 25 | 118154 | 117446 |  | 25 | 150579 | 148972 |  | 25 | 163865 | 159045
26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 90853 | 90587 |  | 26 | 96535 | 96204 |  | 26 | 112452 | 112088 |  | 26 | 149071 | 148972 |  | 26 | 169162 | 168888
27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88917 | 89704 |  | 27 | 95775 | 96204 |  | 27 | 114295 | 118780 |  | 27 | 131684 | 148972 |  | 27 | 163558 | 161498
28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 90830 | 89704 |  | 28 | 83640 | 84420 |  | 28 | 117326 | 116198 |  | 28 | 151053 | 148972 |  | 28 | 159141
29 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 98826 | 98044 |  | 29 | 72972 | 84163 |  | 29 | 113125 | 111409 |  | 29 | 149288 | 148880 |  | 29 | 160416 | 159760
30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 82028 | 86837 |  | 30 | 98006 | 99181 |  | 30 | 123719 | 122461 |  | 30 |  |  |  | 30 | 170363 | 171856
31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 | 96276 | 98230 |  | 31 | 113775 | 112657 |  | 31 |  |  |  | 31 | 170527 | 171013
 | 2001-06-30 00:00:00 |  |  |  | 674043.68 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1999-10-31 00:00:00 |  | 44054 |  | 1999-11-30 00:00:00 |  | 80035 |  | 1999-12-31 00:00:00 |  | 144671 |  | 2000-01-31 00:00:00 |  | 218762
 | 2001-07-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Balance at 11/27/99 |  |  |  | Balance at 12/27/99 |  |  |  | Balance at 1/30/00 |  |  |  | Balance at 2/27/00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48.75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 720
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.35
Red Cedar
Imbalance
Contract 24844
 | Monthly | San Juan |  |  |  |  |  | Monthly | San Juan
 | Imbalance | Index |  |  | Amount |  |  | Imbalance | Index | Amount
1998-11-01 00:00:00 | 11369 | 2.02 |  |  |  |  | 1997-11-01 00:00:00 | 19437 | 2.7
1998-12-01 00:00:00 | 88047 | 1.79 |  |  |  |  | 1997-12-01 00:00:00 | 11409 | 2.16
1999-01-01 00:00:00 | 22026 | 1.7 |  |  |  |  | 1998-01-01 00:00:00 | 13417 | 1.96
1999-02-01 00:00:00 | 12888 | 1.61 |  |  |  |  | 1998-02-01 00:00:00 | 21244 | 2.03
1999-03-01 00:00:00 | 29 | 1.56 |  |  |  |  | 1998-03-01 00:00:00 | 19170 | 2.1
1999-04-01 00:00:00 | 31188 | 1.9 |  |  |  |  | 1998-04-01 00:00:00 | 26776 | 2.2
1999-05-01 00:00:00 |  | 2.02 |  |  |  |  | 1998-05-01 00:00:00 | 30102 | 1.88
1999-06-01 00:00:00 | 48333 | 1.96 |  |  |  |  | 1998-06-01 00:00:00 | 17068 | 1.64
1999-07-01 00:00:00 | -72504 | 2.01 |  |  |  |  | 1998-07-01 00:00:00 | 24452 | 1.87
1999-08-01 00:00:00 | -6559 | 2.35 |  |  |  |  | 1998-08-01 00:00:00 | 26181 | 1.71
1999-09-01 00:00:00 | -73056 | 2.29 |  |  |  |  | 1998-09-01 00:00:00 | 14386 | 1.65
1999-10-01 00:00:00 | -4807 | 2.59 |  |  |  |  | 1998-10-01 00:00:00 | 18644 | 1.73
1999-11-01 00:00:00 | 35981 | 2.14 |  |  |  |  | 1998-11-01 00:00:00 | 21859 | 2.02
1999-12-01 00:00:00 | 64636 | 2.21 |  |  |  |  | 1998-12-01 00:00:00 | 20077 | 1.79
5/99 cash out | -110000 |  |  |  | -222200 |  | 1999-01-01 00:00:00 | 3591 | 1.7
12/99 Balance |  |  |  |  |  |  | 1999-02-01 00:00:00 | 6701 | 1.61
1/1-1/27 |  | 2.2 |  |  |  |  | 1999-03-01 00:00:00 | 5383 | 1.56
Total as of 1/27/00 |  |  |  |  |  |  | 1999-04-01 00:00:00 | 17558 | 1.9
 |  |  |  |  |  |  | 1999-05-01 00:00:00 | 16888 | 2
Imbal per books |  | 2.2 |  |  |  |  | 1999-06-01 00:00:00 | 24801 | 1.96
 |  |  |  |  |  |  | 1999-07-01 00:00:00 | 23747 | 2.01
 |  |  |  |  |  |  | 1999-08-01 00:00:00 | 21597 | 2.35
 | 100000 | 2 |  |  |  |  | 1999-09-01 00:00:00 | 16984 | 2.29
 |  |  |  |  |  |  | 1999-10-01 00:00:00 | 11019 | 2.59
 |  |  |  |  |  |  | 1999-11-01 00:00:00 | 14611 | 2.14
 |  |  |  |  |  |  | 1999-12-01 00:00:00 | 31761 | 2.21
 |  |  |  |  |  |  | 2000-01-01 00:00:00 | 28865 | 2.23
 |  |  |  |  |  |  | 2000-02-01 00:00:00 |  | 2.4
Red Cedar
Imbalance
Contract 24844
 | Monthly | San Juan
 | Imbalance | Index |  |  | Amount
1998-11-01 00:00:00 | 11369 | 2.02
1998-12-01 00:00:00 | 88047 | 1.79
1999-01-01 00:00:00 | 22026 | 1.7
1999-02-01 00:00:00 | 12888 | 1.61
1999-03-01 00:00:00 | 29 | 1.56
1999-04-01 00:00:00 | 31188 | 1.9
1999-05-01 00:00:00 |  | 2.02
 | 110000
1996-09-01 00:00:00 | 49118 | 77606.44
1996-10-01 00:00:00 | 214553 | 454852.36
1996-11-01 00:00:00 | 43514 | 119663.5
1996-12-01 00:00:00 | -216419 | -555955.78
1996-12-01 00:00:00 | 28947 | 45736.26
1997-01-01 00:00:00 | 1433 | 4585.6
1997-02-01 00:00:00 | -39680 | -80550.4
1997-03-01 00:00:00 | 11061 | 18914.31
1997-04-01 00:00:00 | 5079 | 9294.57
1997-05-01 00:00:00 | -27163 | -53239.48
1997-06-01 00:00:00 | 696 | 1392
1997-07-01 00:00:00 | 54951 | 111550.53
1997-08-01 00:00:00 | 80810 | 180206.3
1997-09-01 00:00:00 | 79912 | 215762.4
1997-10-01 00:00:00 | -197519 | -557003.58
1997-11-01 00:00:00 | -60757 | -163436.33
1997-12-01 00:00:00 | 91837 | 198367.92
1998-01-01 00:00:00 | 12478 | 24831.22
1998-02-01 00:00:00 | 41686 | 85456.3
1998-03-01 00:00:00 | 10912 | 23242.56
1998-04-01 00:00:00 | -14809 | -33468.34
1998-05-01 00:00:00 | -68266 | -131753.38
1998-06-01 00:00:00 | -120267 | -221291.28
1998-07-01 00:00:00 | 67572 | 136495.44
1998-08-01 00:00:00 | 76339 | 133593.25
1998-09-01 00:00:00 | 4528 | 7969.28
1998-10-01 00:00:00 | 26871 | 47561.67
1998-11-01 00:00:00 | 153952 | 288096.78
 |  |  |  |  | ending at 11/98
 | -300000 | -450000 |  |  | cash out
 |  |  |  |  | balance after cash out
1998-12-01 00:00:00 | 88047 | 153201.78
1999-01-01 00:00:00 | 22026 | 38104.98
1999-02-01 00:00:00 | 12888 | 21007.44
1999-03-01 00:00:00 | 29 | 46.11
1999-04-01 00:00:00 | 31188 | 60504.72
Est 5/99 | 98603 |  |  |  | 2.02
7/98 - 11/98
12/98 - 5/99