Spreadsheet: lynn_blair__24402__JKnight Gathering Imb thru 4-01
Sheet: Original OBA's

**DRAFT**
Northern and Oneok OBA Reconcilation
As of 5/31/01 (October 2000 thru April 2001)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Estimate
 |  | 2000-03-01 00:00:00 |  |  |  | 2000-04-01 00:00:00 |  |  |  | 2000-05-01 00:00:00 |  |  |  | 2000-06-01 00:00:00 |  |  |  | 2000-07-01 00:00:00 |  |  |  | 2000-08-01 00:00:00 |  |  |  | 2000-09-01 00:00:00 |  |  |  | 2000-10-01 00:00:00 |  |  |  | 2000-11-01 00:00:00 |  |  |  | 2000-12-01 00:00:00 |  |  |  | 2001-01-01 00:00:00 |  |  |  | 2001-02-01 00:00:00 |  |  |  | 2001-03-01 00:00:00 |  |  |  | 2001-04-01 00:00:00 |  |  |  | Cumulative
 |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME]
Contract 103132
 | 62 - Haskell 1 | 719110 | 686077 |  |  | 695284 | 660296 |  |  | 706908 | 684636 |  |  | 692139 | 615805 |  |  | 671321 | 617190 |  |  | 646857 | 605840 |  |  | 672187 | 581199 |  |  | 672009 | 635232 |  |  | 648891 | 618882 |  |  | 642690 | 650459 |  |  | 661782 | 687603 |  |  | 646770 | 619309 |  |  | 642073 | 637402 |  |  | 682413 | 613025
 | 126 - Stevens 1 | 1178929 | 1169107 |  |  | 1213822 | 1106892 |  |  | 1278364 | 1143734 |  |  | 1179342 | 1134805 |  |  | 1221923 | 1164821 |  |  | 1138404 | 1164301 |  |  | 1080077 | 1071801 |  |  | 1071044 | 1099181 |  |  | 1048256 | 1094582 |  |  | 1065389 | 1078269 |  |  | 1062793 | 1035106 |  |  | 927081 | 882328 |  |  | 958132 | 952621 |  |  | 949410 | 970963
 | 127 - Stevens 2 | 718373 | 731832 |  |  | 679940 | 708062 |  |  | 638866 | 731892 |  |  | 660729 | 718306 |  |  | 651075 | 734236 |  |  | 718226 | 720467 |  |  | 676077 | 702853 |  |  | 739252 | 709297 |  |  | 716879 | 682470 |  |  | 694826 | 658510 |  |  | 695368 | 654732 |  |  | 596250 | 592205 |  |  | 628252 | 641119 |  |  | 629109 | 606607
 | 128 - Stevens 3 | 209715 | 266257 |  |  | 189690 | 264739 |  |  | 219005 | 272027 |  |  | 237532 | 262641 |  |  | 216344 | 259298 |  |  | 215295 | 250007 |  |  | 214641 | 179384 |  |  | 218724 | 243107 |  |  | 234781 | 221197 |  |  | 226199 | 226860 |  |  | 219819 | 229112 |  |  | 197399 | 212798 |  |  | 240505 | 229641 |  |  | 229101 | 205435
 | 129 - Stevens 4 | 620539 | 562090 |  |  | 617442 | 628068 |  |  | 501967 | 633334 |  |  | 636901 | 632790 |  |  | 670362 | 648400 |  |  | 675009 | 622328 |  |  | 616239 | 615646 |  |  | 627715 | 635759 |  |  | 589231 | 596161 |  |  | 607160 | 645189 |  |  | 581295 | 618339 |  |  | 527952 | 515701 |  |  | 577773 | 578813 |  |  | 464857 | 474528
 | 131 - Stevens 6 | 682336 | 626678 |  |  | 652819 | 601669 |  |  | 622403 | 557735 |  |  | 632398 | 594422 |  |  | 631870 | 583098 |  |  | 646663 | 605322 |  |  | 599233 | 575892 |  |  | 597859 | 586020 |  |  | 608757 | 581742 |  |  | 613975 | 586886 |  |  | 621498 | 590547 |  |  | 539046 | 519283 |  |  | 585860 | 584960 |  |  | 564085 | 562733
 | 137 - Texas 1 | 205603 | 202800 |  |  | 197165 | 186761 |  |  | 187575 | 189643 |  |  | 219211 | 204748 |  |  | 180360 | 200759 |  |  | 205450 | 198456 |  |  | 209206 | 186358 |  |  | 205228 | 196711 |  |  | 203039 | 200037 |  |  | 201325 | 200172 |  |  | 206010 | 187677 |  |  | 190085 | 178322 |  |  | 194340 | 187381 |  |  | 188039 | 174792
 | 138 - Texas 2 | 518295 | 493401 |  |  | 505209 | 473580 |  |  | 528296 | 542793 |  |  | 644137 | 593754 |  |  | 488801 | 557088 |  |  | 554368 | 535848 |  |  | 499659 | 509851 |  |  | 516195 | 520150 |  |  | 506472 | 502368 |  |  | 498951 | 488283 |  |  | 503986 | 486654 |  |  | 359653 | 401087 |  |  | 464539 | 451100 |  |  | 477257 | 458145
 | 1713 - Morton 1 | 723767 | 708501 |  |  | 694263 | 639729 |  |  | 584655 | 694997 |  |  | 627627 | 674803 |  |  | 640950 | 669936 |  |  | 631701 | 681051 |  |  | 614186 | 632348 |  |  | 597558 | 629363 |  |  | 583967 | 599293 |  |  | 588683 | 684359 |  |  | 705082 | 717452 |  |  | 536335 | 539919 |  |  | 595674 | 638774 |  |  | 576005 | 584863
 | 1998 - Sublette | 937864 | 862541 |  |  | 889228 | 818606 |  |  | 982873 | 808889 |  |  | 970747 | 749744 |  |  | 901658 | 758582 |  |  | 780537 | 771346 |  |  | 769044 | 780669 |  |  | 842129 | 833457 |  |  | 794911 | 822731 |  |  | 858645 | 817266 |  |  | 769019 | 734849 |  |  | 635578 | 640217 |  |  | 769956 | 789994 |  |  | 786640 | 802900
 | 23269 - Hugoton | 1426421 | 1469237 |  |  | 1332463 | 1357236 |  |  | 1160315 | 1369868 |  |  | 1205747 | 1330948 |  |  | 1249308 | 1348862 |  |  | 1383579 | 1390839 |  |  | 1305414 | 1326078 |  |  | 1380668 | 1368142 |  |  | 1338059 | 1391700 |  |  | 1390992 | 1407700 |  |  | 1391999 | 1404417 |  |  | 1173769 | 1187050 |  |  | 1294891 | 1292573 |  |  | 1252354 | 1272875
 | 61510 - Morton 6 | 205582 | 255313 |  |  | 168558 | 251193 |  |  | 212774 | 178551 |  |  | 227593 | 216968 |  |  | 250259 | 217672 |  |  | 254065 | 204987 |  |  | 234460 | 208098 |  |  | 235266 | 215896 |  |  | 244187 | 244113 |  |  | 247791 | 151283 |  |  | 114721 | 135215 |  |  | 205987 | 230042 |  |  | 243606 | 232967 |  |  | 206304 | 227624
 | Total
 | Cash-in/out Volume |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31332 |  |  |  | -37846 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Oxy Adjust. |  |  | -5605 |  |  |  | 17979 |  |  |  | -44376 |  |  |  | 107297 |  |  |  | -170297 |  |  |  | 4994 |  |  |  | -42229 |  |  |  | -19110 |  |  |  | 8994 |  |  |  | -29760 |  |  |  | 15341 |  |  |  | -81848 |  |  |  | -25007 |  |  |  | -26704
 | Mobil Adjust. |  |  | 151131 |  |  |  | 177391 |  |  |  | 48137 |  |  |  | 129224 |  |  |  | 20493 |  |  |  | 6710 |  |  |  | 111380 |  |  |  | 67319 |  |  |  | -42074 |  |  |  | 9810 |  |  |  | 86517 |  |  |  | 39319 |  |  |  | 38953 |  |  |  | 24406
 | Oxy's Adj.  Cash-in/out Reversal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -64385 |  |  |  | 831 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | [NAME].  Cash-in/out Reversal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -75577 |  |  |  | 41114 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Net Adjust.
 | MIP |  |  | 2.6365 |  |  |  | 2.8424 |  |  |  | 3.2884 |  |  |  | 4.0792 |  |  |  | 3.8249 |  |  |  | 4.2166 |  |  |  | 4.8503 |  |  |  | 4.8727 |  |  |  | 5.209 |  |  |  | 8.7182 |  |  |  | 8 |  |  |  | 5.5555 |  |  |  | 4.9851 |  |  |  | 4.9474
 | Monthly Value
 | Cummulative
 |  | 2000-03-01 00:00:00 |  |  |  | 2000-04-01 00:00:00 |  |  |  | 2000-05-01 00:00:00 |  |  |  | 2000-06-01 00:00:00 |  |  |  | 2000-07-01 00:00:00 |  |  |  | 2000-08-01 00:00:00 |  |  |  | 2000-09-01 00:00:00 |  |  |  | 2000-10-01 00:00:00 |  |  |  | 2000-11-01 00:00:00 |  |  |  | 2000-12-01 00:00:00 |  |  |  | 2001-01-01 00:00:00 |  |  |  | 2001-02-01 00:00:00 |  |  |  | 2001-03-01 00:00:00 |  |  |  | 2001-04-01 00:00:00 |  |  |  | Cumulative
 |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME]
Contract 103133  (Note:  [NAME] was sold to Golden Belt Transport, LLC effective 2/1/01)
 | 17378 - Burdette | 21057 | 13365 |  |  | 16890 | 13233 |  |  | 16086 | 11464 |  |  | 16770 | 12490 |  |  | 17639 | 11965 |  |  | 16469 | 15943 |  |  | 16120 | 18498 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 22450 | 15631 |  |  | 17795 | 14896 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0
 | Total
 | Net Adjust. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | MIP |  |  | 2.6365 |  |  |  | 2.8424 |  |  |  | 3.2884 |  |  |  | 4.0792 |  |  |  | 3.8249 |  |  |  | 4.2166 |  |  |  | 4.8503 |  |  |  | 4.8727 |  |  |  | 5.209 |  |  |  | 8.7182 |  |  |  | 8 |  |  |  | 5.5555 |  |  |  | 4.9851 |  |  |  | 4.9474
 | Monthly Value
 | Cummulative
 |  | 2000-03-01 00:00:00 |  |  |  | 2000-04-01 00:00:00 |  |  |  | 2000-05-01 00:00:00 |  |  |  | 2000-06-01 00:00:00 |  |  |  | 2000-07-01 00:00:00 |  |  |  | 2000-08-01 00:00:00 |  |  |  | 2000-09-01 00:00:00 |  |  |  | 2000-10-01 00:00:00 |  |  |  | 2000-11-01 00:00:00 |  |  |  | 2000-12-01 00:00:00 |  |  |  | 2001-01-01 00:00:00 |  |  |  | 2001-02-01 00:00:00 |  |  |  | 2001-03-01 00:00:00 |  |  |  | 2001-04-01 00:00:00 |  |  |  | Cumulative
 |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME]
Contract 103134
 | 51 - Finney 1 | 376754 | 395549 |  |  | 251309 | 307239 |  |  | 337515 | 369019 |  |  | 307363 | 341134 |  |  | 324960 | 307239 |  |  | 296200 | 320098 |  |  | 275306 | 315394 |  |  | 306944 | 318315 |  |  | 265784 | 315249 |  |  | 306967 | 308199 |  |  | 288755 | 332697 |  |  | 293390 | 296660 |  |  | 357883 | 355387 |  |  | 324399 | 349281
 | 52 - Finney 2 | 624226 | 531936 |  |  | 571307 | 554172 |  |  | 633422 | 518548 |  |  | 551445 | 477123 |  |  | 488496 | 477194 |  |  | 475421 | 480062 |  |  | 510485 | 495307 |  |  | 511619 | 476959 |  |  | 536639 | 507502 |  |  | 528984 | 519748 |  |  | 525247 | 512858 |  |  | 482703 | 451613 |  |  | 503243 | 486775 |  |  | 485060 | 459098
 | 53 - Finney 3 | 105108 | 102914 |  |  | 109542 | 112173 |  |  | 102407 | 88991 |  |  | 97278 | 71050 |  |  | 116686 | 90976 |  |  | 96301 | 91334 |  |  | 89278 | 94534 |  |  | 98751 | 99757 |  |  | 97159 | 100116 |  |  | 99484 | 106720 |  |  | 99465 | 115871 |  |  | 98373 | 101336 |  |  | 110891 | 112514 |  |  | 97452 | 99397
 | 54 - Finney 4 | 331747 | 317583 |  |  | 308642 | 292248 |  |  | 332687 | 281007 |  |  | 271609 | 243029 |  |  | 257603 | 236848 |  |  | 240237 | 225933 |  |  | 253430 | 249040 |  |  | 281197 | 266988 |  |  | 260943 | 268810 |  |  | 290097 | 283194 |  |  | 280648 | 280026 |  |  | 253790 | 244937 |  |  | 264049 | 269977 |  |  | 270109 | 255459
 | 135 - Tate | 553765 | 514941 |  |  | 527065 | 513166 |  |  | 544922 | 510739 |  |  | 527238 | 494601 |  |  | 520716 | 500408 |  |  | 510675 | 502712 |  |  | 493671 | 448341 |  |  | 478626 | 502704 |  |  | 527542 | 521492 |  |  | 551243 | 522375 |  |  | 545031 | 510031 |  |  | 449389 | 441352 |  |  | 481429 | 481724 |  |  | 457595 | 458108
 | 1660 - Holcomb | 202688 | 212165 |  |  | 219159 | 144597 |  |  | 215435 | 175936 |  |  | 216396 | 190480 |  |  | 198891 | 199156 |  |  | 214482 | 187818 |  |  | 213990 | 182140 |  |  | 215533 | 193142 |  |  | 191270 | 182960 |  |  | 190871 | 188545 |  |  | 180194 | 190337 |  |  | 163113 | 166151 |  |  | 180048 | 180851 |  |  | 160260 | 166207
 | Total
 | Cash-in/out Volume |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34805 |  |  |  | -16792 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Oxy Adjust. |  |  | -5605 |  |  |  | 17979 |  |  |  | -44376 |  |  |  | 107297 |  |  |  | -170297 |  |  |  | 4994 |  |  |  | -42229 |  |  |  | 25360 |  |  |  | -11297 |  |  |  | 25357 |  |  |  | -9376 |  |  |  | 59594 |  |  |  | -7065 |  |  |  | 6630
 | Mobil Adjust. |  |  | 151131 |  |  |  | 177391 |  |  |  | 48137 |  |  |  | 129224 |  |  |  | 20493 |  |  |  | 6710 |  |  |  | 111380 |  |  |  | -91059 |  |  |  | -16365 |  |  |  | -50606 |  |  |  | -21320 |  |  |  | -35649 |  |  |  | -38391 |  |  |  | -59635
 | Oxy's Adj.  Cash-in/out Reversal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -10490 |  |  |  | 7768 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | [NAME].  Cash-in/out Reversal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88046 |  |  |  | 6496 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Net Adjust.
 | MIP |  |  | 2.6365 |  |  |  | 2.8424 |  |  |  | 3.2884 |  |  |  | 4.0792 |  |  |  | 3.8249 |  |  |  | 4.2166 |  |  |  | 4.8503 |  |  |  | 4.8727 |  |  |  | 5.209 |  |  |  | 8.7182 |  |  |  | 8 |  |  |  | 5.5555 |  |  |  | 4.9851 |  |  |  | 4.9474
 | Monthly Value
 | Cummulative
 |  | 2000-03-01 00:00:00 |  |  |  | 2000-04-01 00:00:00 |  |  |  | 2000-05-01 00:00:00 |  |  |  | 2000-06-01 00:00:00 |  |  |  | 2000-07-01 00:00:00 |  |  |  | 2000-08-01 00:00:00 |  |  |  | 2000-09-01 00:00:00 |  |  |  | 2000-10-01 00:00:00 |  |  |  | 2000-11-01 00:00:00 |  |  |  | 2000-12-01 00:00:00 |  |  |  | 2001-01-01 00:00:00 |  |  |  | 2001-02-01 00:00:00 |  |  |  | 2001-03-01 00:00:00 |  |  |  | 2001-04-01 00:00:00 |  |  |  | Cumulative
 |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME]
Contract 103138
 | 3451 - Hockett Dehy | 8437 | 7220 |  |  | 8280 | 4320 |  |  | 8556 | 8830 |  |  | 7590 | 5055 |  |  | 7081 | 4925 |  |  | 5952 | 4887 |  |  | 7320 | 6530 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 7564 | 7708 |  |  | 7155 | 10396 |  |  | 6552 | 7656 |  |  | 7254 | 8149 |  |  | 8796 | 7513
 | 8081 - Meade Co. | 2880 | 4290 |  |  | 3600 | 3750 |  |  | 3479 | 3651 |  |  | 4050 | 3455 |  |  | 4005 | 3083 |  |  | 3441 | 3446 |  |  | 3375 | 2970 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 2085 | 2740 |  |  | 3255 | 3627 |  |  | 2314 | 2737 |  |  | 3441 | 3646 |  |  | 2641 | 3516
 | 25781 - Pleasant Valley | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 54 |  |  | 0 | 0
 | 59932 - Hagar 1 | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 123 |  |  | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Total
 | Net Adjust. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | MIP |  |  | 2.6365 |  |  |  | 2.8424 |  |  |  | 3.2884 |  |  |  | 4.0792 |  |  |  | 3.8249 |  |  |  | 4.2166 |  |  |  | 4.8503 |  |  |  | 4.8727 |  |  |  | 5.209 |  |  |  | 8.7182 |  |  |  | 8 |  |  |  | 5.5555 |  |  |  | 4.9851 |  |  |  | 4.9474
 | Monthly Value
 | Cummulative
 | Cummulative Total for all Contracts:
 | Note:  (*) Northern has not received the Mobil/Oxy actual volumes from [NAME].
 | Highlighted items adjustments have been made.
0 | Amount due [NAME]
(-) | Amount due Northern