Spreadsheet: danny_mccarty__4627__Exhibit 7 - 2001- MKM
Sheet: All Inclusive

 | NORTHERN NATURAL GAS COMPANY |  |  |  | Privileged and Confidential.  Prepared for
 | System Levelized Account |  |  |  | Settlement purposes only.
 | September 1998 to August 2001
 |  |  |  |  |  |  |  |  |  |  | SLA Account
 |  |  |  |  |  |  |  |  |  |  | Total |  | Cash Portion - |  | Future
 |  | Operational |  |  |  |  |  |  |  |  |  |  | Cash Out/ |  | Liability
 |  | Storage |  | SLA Calculation |  |  |  |  |  |  |  |  | (Cash In)
 |  | [NAME] | Volume | Dollar | Dollar |  |  |  | Net |  | SLA Impact |  | Col (e)*-1 |  | Col (d)*(g)
Line |  | (Over)/Under | Valued | Valued | Amount | Cost |  | Monthly | Cost |  | Increase/
No. | Type of Volume | 14 Bcf | [NAME] | [NAME] | (Cash Out)/ | Per Mcf |  | MIP | Per Mcf |  | (Decrease)
 |  | Col (c)+(d) |  |  | Cash In | Col (e)/(d) |  |  | Col (g)-(f) |  | Col (d)*(h)
 | Column (a) | (b) | (c) | (d) | (e) | (f) |  | (g) | (h) |  | (i) |  | (j) |  | (k)
 | September, 1998
1 | 8/98 Balance Per Books: |  | -5981599 | 7522467 |  |  |  |  |  |  | 11208742
2 | Revalue 8/98 Shortfall @ Current [NAME]: |  |  | 7522467 |  | 1.7024 | 1/ | 1.7767
3 | 9/98 Activity
4 | Dollar Valued Imbalance |  |  | 1243020 | 1947010 |  |  | 1.7767
5 | Imbalance Tiering Gain
6 | Gas Purchases |  |  | -530550 | -1115055 |  |  | 1.7767
7 | Miscellaneous |  |  | 174059 | 304359 |  |  | 1.7767
8 | Net 9/98 Activity |  | -337990
9 | 9/98 Balance Per Books:
 | 1/  Prior Month's MIP
 | October, 1998
1 | 9/98 Balance Per Books:
2 | Revalue 9/98 Shortfall @ Current [NAME]: |  |  | 8408996 |  | 1.7767 | 1/ | 1.7614
3 | 10/98 Activity
4 | Dollar Valued Imbalance |  |  | 503523 | 661339 |  |  | 1.7614
5 | Imbalance Tiering Gain
6 | Gas Purchases |  |  | -1242455 | -2272631 |  |  | 1.7614
7 | Miscellaneous |  |  | 94400 | 173380 |  |  | 1.7614
8 | Net 10/98 Activity |  | -502524
9 | 10/98 Balance Per Books:
 | 1/  Prior Month's MIP
 | November, 1998
1 | 10/98 Balance Per Books:
2 | Revalue 10/98 Shortfall @ Current [NAME]: |  |  | 7764464 |  | 1.7614 | 1/ | 2.0207
3 | 11/98 Activity
4 | Dollar Valued Imbalance |  |  | -1947698 | -4226041 |  |  | 2.0207
5 | Imbalance Tiering Gain
6 | Gas Purchases |  |  | -199670 | -405398 |  |  | 2.0207
7 | Miscellaneous |  |  | 253429 | 457798 |  |  | 2.0207
8 | Net 11/98 Activity |  | 279673
9 | 11/98 Balance Per Books:
 | 1/  Prior Month's MIP
 | December, 1998
1 | 11/98 Balance Per Books:
2 | Revalue 11/98 Shortfall @ Current [NAME]: |  |  | 5870525 |  | 2.0207 | 1/ | 1.6813
3 | 12/98 Activity
4 | Dollar Valued Imbalance |  |  | 544946 | 903461 |  |  | 1.6813
5 | Imbalance Tiering Gain |  |  |  | 177638
6 | Gas Purchases |  |  | -15491 | -90906 |  |  | 1.6813
7 | Miscellaneous |  |  | 207215 | 415788 |  |  | 1.6813
8 | Net 12/98 Activity |  | 270111
9 | 12/98 Balance Per Books:
 | 1/  Prior Month's MIP
 | January, 1999
1 | 12/98 Balance Per Books:
2 | Revalue 12/98 Shortfall @ Current [NAME]: |  |  | 6607195 |  | 1.6813 | 1/ | 1.8315
3 | 1/99 Activity
4 | Dollar Valued Imbalance |  |  | -1293415 | -2365958 |  |  | 1.8315
5 | Imbalance Tiering Gain |  |  |  | 206648
6 | Gas Purchases |  |  | -23647 | -53442 |  |  | 1.8315
7 | Miscellaneous |  |  | 161704 | 287023 |  |  | 1.8315
8 | Net 1/99 Activity |  | 270947
9 | 1/99 Balance Per Books:
 | 1/  Prior Month's MIP
 | February, 1999
1 | 1/99 Balance Per Books:
2 | Revalue 1/99 Shortfall @ Current [NAME]: |  |  | 5451837 |  | 1.8315 | 1/ | 1.6851
3 | 2/99 Activity
4 | Dollar Valued Imbalance |  |  | -51679 | 83766 |  |  | 1.6851
5 | Imbalance Tiering Gain |  |  |  | -48667
6 | Gas Purchases |  |  | 0 | 0 | 0 |  | 1.6851
7 | Miscellaneous |  |  | 177495 | 316457 |  |  | 1.6851
8 | Net 2/99 Activity |  | -317080
9 | 2/99 Balance Per Books:
 | 1/  Prior Month's MIP
 | March, 1999
1 | 2/99 Balance Per Books:
2 | Revalue 2/99 Shortfall @ Current [NAME]: |  |  | 5577653 |  | 1.6851 | 1/ | 1.6441
3 | 3/99 Activity
4 | Dollar Valued Imbalance |  |  | 653254 | 956084 |  |  | 1.6441
5 | Imbalance Tiering Gain |  |  |  | 46742
6 | Gas Purchases |  |  | 0 | 0 | 0 |  | 1.6441
7 | Miscellaneous |  |  | 382630 | 639765 |  |  | 1.6441
8 | Net 3/99 Activity |  | -212646
9 | 3/99 Balance Per Books:
 | 1/  Prior Month's MIP
 | April, 1999
1 | 3/99 Balance Per Books:
2 | Revalue 3/99 Shortfall @ Current [NAME]: |  |  | 6613537 |  | 1.6441 | 1/ | 1.9838
3 | 4/99 Activity
4 | Dollar Valued Imbalance |  |  | 949234 | 1977836 |  |  | 1.9838
5 | Imbalance Tiering Gain |  |  |  | 18530
6 | Gas Purchases |  |  | 0 | 0 | 0 |  | 1.9838
7 | Miscellaneous |  |  | 963090 | 1836591 |  |  | 1.9838
8 | Net 4/99 Activity |  | -652739
9 | 4/99 Balance Per Books:
 | 1/  Prior Month's MIP
 | May, 1999
1
2 | Revalue 4/99 Shortfall @ Current [NAME]: |  |  | 8525861 |  | 1.9838 | 1/ | 2.1251
3 | 5/99 Activity
4 | Dollar Valued Imbalance |  |  | -290403 | -677014 |  |  | 2.1251
5 | Imbalance Tiering Gain |  |  |  | 47618
6 | Gas Purchases |  |  | 0 | 0 | 0 |  | 2.1251
7 | Miscellaneous |  |  | 78133 | 207484 |  |  | 2.1251
8 | Net 5/99 Activity |  | 215413
9 | 5/99 Balance Per Books:
 | 1/  Prior Month's MIP
 | June, 1999
1
2 | Revalue 5/99 Shortfall @ Current [NAME]: |  |  | 8313591 |  | 2.1251 | 1/ | 2.1593
3 | 6/99 Activity
4 | Dollar Valued Imbalance |  |  | 357832 | 689902 |  |  | 2.1593
5 | Imbalance Tiering Gain |  |  |  | 21702
6 | Gas Purchases |  |  | 0 | 0 | 0 |  | 2.1593
7 | Miscellaneous |  |  | 249041 | 542192 |  |  | 2.1593
8 | Net 6/99 Activity |  | 26258
9 | 6/99 Balance Per Books:
 | 1/  Prior Month's MIP
 | July, 1999
1
2 | [NAME] [NAME]: |  |  | 8920464 |  | 2.1593 | 1/ | 2.2046
3 | 7/99 Activity
4 | Dollar Valued Imbalance |  |  | 2641498 | 5715313 |  |  | 2.2046
5 | Imbalance Tiering Gain |  |  |  | -73194
6 | Gas Purchases |  |  | 0 | 0 | 0 |  | 2.2046
7 | Miscellaneous |  |  | -11526 | -40771 |  |  | 2.2046
8 | Net 7/99 Activity |  | 487735
9 | 7/99 Balance Per Books:
 | 1/  Prior Month's MIP
 | August, 1999
1
2 | [NAME] @ Current [NAME]: |  |  | 11550436 |  | 2.2046 | 1/ | 2.6523
3 | 8/99 Activity
4 | Dollar Valued Imbalance |  |  | 746951 | 1223615 |  |  | 2.6523
5 | Imbalance Tiering Gain |  |  |  | 19313
6 | Gas Purchases |  |  | -150000 | -443505 |  |  | 2.6523
7 | Miscellaneous |  |  | 110543 | 240573 |  |  | 2.6523
8 | Net 8/99 Activity |  | 1688076
9 | 8/99 Balance Per Books:
 | 1/  Prior Month's MIP
 | September, 1999
1
2 | Revalue 8/99 Shortfall @ Current [NAME]: |  |  | 12257930 |  | 2.6523 | 1/ | 2.4742
3 | 9/99 Activity
4 | Dollar Valued Imbalance |  |  | 1165147 | 3010189 |  |  | 2.4742
5 | Imbalance Tiering Gain |  |  |  | 33057
6 | Gas Purchases |  |  | -900000 | -2505370 |  |  | 2.4742
7 | Miscellaneous |  |  | 106285 | 278710 |  |  | 2.4742
8 | Net 9/99 Activity |  | -653295
9 | 9/99 Balance Per Books:
 | 1/  Prior Month's MIP
 | October, 1999
1
2 | Revalue 9/99 Shortfall @ Current [NAME]: |  |  | 12629362 |  | 2.4742 | 1/ | 2.6734
3 | 10/99 Activity
4 | Dollar Valued Imbalance |  |  | -396685 | -24124 |  |  | 2.6734
5 | Imbalance Tiering Gain |  |  |  | 22428
6 | Gas Purchases |  |  | 1917 | 5344 |  |  | 2.6734
7 | Miscellaneous |  |  | 107907 | 262049 |  |  | 2.6734
8 | Net 10/99 Activity |  | 1733628
9 | 10/99 Balance Per Books:
 | 1/  Prior Month's MIP
 | November, 1999
1
2 | Revalue 10/99 Shortfall @ Current [NAME]: |  |  | 12342501 |  | 2.6734 | 1/ | 2.2852
3 | 11/99 Activity
4 | Dollar Valued Imbalance |  |  | -1568900 | -3459124 |  |  | 2.2852
5 | Imbalance Tiering Gain |  |  |  | 13662
6 | Gas Purchases |  |  | -2970000 | -9126900 |  |  | 2.2852
7 | Miscellaneous |  |  | 322470 | 761583 |  |  | 2.2852
8 | Net 11/99 Activity |  | -120648
9 | 11/99 Balance Per Books:
 | 1/  Prior Month's MIP
 | December, 1999
1
2 | Revalue 11/99 Shortfall @ Current [NAME]: |  |  | 8126071 |  | 2.2852 | 1/ | 2.2651
3 | 12/99 Activity
4 | Dollar Valued Imbalance |  |  | 1477065 | 3544814 |  |  | 2.2651
5 | Imbalance Tiering Gain |  |  |  | 43596
6 | Gas Purchases |  |  | -1378331 | -2909366 |  |  | 2.2651
7 | Miscellaneous |  |  | 133758 | 302384 |  |  | 2.2651
8 | Net 12/99 Activity |  | -63692
9 | 12/99 Balance Per Books:
 | 1/  Prior Month's MIP
 | January, 2000
1
2 | Revalue 12/99 Shortfall @ Current [NAME]: |  |  | 8358563 |  | 2.2651 | 1/ | 2.3091
3 | 01/00 Activity
4 | Dollar Valued Imbalance |  |  | 31597 | 41095 |  |  | 2.3091
5 | Imbalance Tiering Gain |  |  |  | 28532
6 | Gas Purchases |  |  | -1284837 | -3038550 |  |  | 2.3091
7 | Miscellaneous |  |  | 97390 | 215984 |  |  | 2.3091
8 | Net 01/00 Activity |  | 972509
9 | 01/00 Balance Per Books:
 | 1/  Prior Month's MIP
 | February, 2000
1
2 | Revalue 01/00 Shortfall @ Current [NAME]: |  |  | 7202713 |  | 2.3091 | 1/ | 2.5043
3 | 02/00 Activity
4 | Dollar Valued Imbalance |  |  | 2013067 | 4974967 |  |  | 2.5043
5 | Imbalance Tiering Gain |  |  |  | 295800
6 | Gas Purchases |  |  | -3402806 | -8806039 |  |  | 2.5043
7 | Miscellaneous |  |  | 134379 | 303477 |  |  | 2.5043
8 | Net 02/00 Activity |  | -651905
9 | 02/00 Balance Per Books:
 | 1/  Prior Month's MIP
 | March, 2000
1
2 | Revalue 2/00 Shortfall @ Current [NAME]: |  |  | 5947353 |  | 2.5043 | 1/ | 2.6718
3 | 03/00 Activity
4 | Dollar Valued Imbalance |  |  | 632297 | 1598311 |  |  | 2.6718
5 | Imbalance Tiering Gain |  |  |  | 17028
6 | Gas Purchases |  |  | -464952 | -1175909 |  |  | 2.6718
7 | Miscellaneous |  |  | 137538 | 336776 |  |  | 2.6718
8 | Net 3/00 Activity |  | 818868
9 | 03/00 Balance Per Books:
 | 1/  Prior Month's MIP
 | April, 2000
1 | 03/00 Balance Per Books:
2 | Revalue 3/00 Shortfall @ Current [NAME]: |  |  |  |  | 2.6718 | 1/ | 2.8949
3 | 4/00 Activity
4 | Dollar Valued Imbalance |  |  | 3097221 | 8560585
5 | Imbalance Tiering Gain |  |  |  | 82850
6 | Gas Purchases |  |  | -130963 | -366696
7 | Miscellaneous |  |  | 123914 | 326977
8 | Net 4/00 Activity |  | -253866
9 | 4/00 Balance Per Books:
 | 1/  Prior Month's MIP
 | May, 2000
1
2 | Revalue 4/00 Shortfall @ Current [NAME]: |  |  |  |  | 2.8949 | 1/ | 3.3142
3 | 5/00 Activity
4 | Dollar Valued Imbalance |  |  | 1641940 | 5990827
5 | Imbalance Tiering Gain |  |  |  | 62427
6 | Gas Purchases |  |  | -742979 | -2200719
7 | Miscellaneous |  |  | 134087 | 396645
8 | Net 5/00 Activity |  | 1045273
9 | 5/00 Balance Per Books:
 | 1/  Prior Month's MIP
 | June, 2000
1
2 | Revalue 5/00 Shortfall @ Current [NAME]: |  |  |  |  | 3.3142 | 1/ | 4.1138
3 | 6/00 Activity
4 | Dollar Valued Imbalance |  |  | 2548062 | 11036931
5 | Imbalance Tiering Gain |  |  |  | 177036
6 | Gas Purchases |  |  | -2343470 | -9887943
7 | Miscellaneous |  |  | 137117 | 460885
8 | Net 6/00 Activity |  | 426981
9 | 6/00 Balance Per Books:
 | 1/  Prior Month's MIP
 | July, 2000
1
2 | Revalue 6/00 Shortfall @ Current [NAME]: |  |  |  |  | 4.1138 | 1/ | 3.8751
3 | 7/00 Activity
4 | Dollar Valued Imbalance |  |  | -198604 | -1067785
5 | Imbalance Tiering Gain |  |  |  | 79699
6 | Gas Purchases |  |  | -3823940 | -16062423
7 | Miscellaneous |  |  | 119454 | 430230
8 | Net 7/00 Activity |  | -522763
9 | 7/00 Balance Per Books:
 | 1/  Prior Month's MIP
 | August, 2000
1
2 | Revalue 7/00 Shortfall @ Current [NAME]: |  |  |  |  | 3.8751 | 1/ | 4.2493
3 | 8/00 Activity
4 | Dollar Valued Imbalance |  |  | 3068287 | 12839906
5 | Imbalance Tiering Gain |  |  |  | 10368
6 | Gas Purchases |  |  | -32258 | -145806
7 | Miscellaneous |  |  | 106638 | 410126
8 | Net 8/00 Activity |  | -1238067
9 | 8/00 Balance Per Books:
 | 1/  Prior Month's MIP
 | September, 2000
1
2 | Revalue 8/00 Shortfall @ Current [NAME]: |  |  |  |  | 4.2493 | 1/ | 4.9334
3 | 9/00 Activity
4 | Dollar Valued Imbalance |  |  | 1617346 | 7852654
5 | Imbalance Tiering Gain |  |  |  | 54130
6 | Gas Purchases |  |  | 0 | 0
7 | Miscellaneous |  |  | 89434 | 377242
8 | Net 9/00 Activity |  | -104226
9 | 9/00 Balance Per Books:
 | 1/  Prior Month's MIP
 | October, 2000
1
2 | Revalue 9/00 Shortfall @ Current [NAME]: |  |  |  |  | 4.9334 | 1/ | 4.9727
3 | 10/00 Activity
4 | Dollar Valued Imbalance |  |  | -1066256 | -5358478
5 | Imbalance Tiering Gain |  |  |  | 36251
6 | Gas Purchases |  |  | -2960184 | -15600170
7 | Miscellaneous |  |  | 152215 | 724743
8 | Net 10/00 Activity |  | -16254
9 | 10/00 Balance Per Books:
 | 1/  Prior Month's MIP
 | November, 2000
1
2 | Revalue 10/00 Shortfall @ Current [NAME]: |  |  |  |  | 4.9727 | 1/ | 5.3079
3 | 11/00 Activity
4 | Dollar Valued Imbalance |  |  | 3314260 | 17637437
5 | Imbalance Tiering Gain |  |  |  | 158469
6 | Gas Purchases |  |  | -1643283 | -7460068
7 | Miscellaneous |  |  | 120584 | 591586
8 | Net 11/00 Activity |  | 415050
9 | 11/00 Balance Per Books:
 | 1/  Prior Month's MIP
 | December, 2000
1
2 | Revalue 11/00 Shortfall @ Current [NAME]: |  |  |  |  | 5.3079 | 1/ | 8.985
3 | 12/00 Activity
4 | Dollar Valued Imbalance |  |  | 885462 | 12898836
5 | Imbalance Tiering Gain |  |  |  | 193120
6 | Gas Purchases |  |  | -3095551 | -18632704
7 | Miscellaneous |  |  | 102122 | 533572
8 | Net 12/00 Activity |  | 135126
9 | 12/00 Balance Per Books:
 | 1/  Prior Month's MIP
 | January, 2001
1 |  |  |  |  | 87992 |  |  | 8.985 |  |  |  |  | -87992
2 | Revalue 12/00 Shortfall @ Current [NAME]: |  |  |  |  | 8.985 | 1/ | 8.24
3 | 01/01 Activity
4 | Dollar Valued Imbalance |  |  | -1720377 | -14150414
5 | Imbalance Tiering Gain |  |  |  | 389236
6 | Gas Purchases |  |  | -3741357 | -39738750
7 | Miscellaneous |  |  | 119143 | 1041221
8 | Net 01/01 Activity |  | 201065
9 | 01/01 Balance Per Books: |  |  |  |  |  |  | 8.24
 | 1/  Prior Month's MIP
 | February, 2001
1 |  |  |  |  |  |  |  | 8.24
2 | Revalue 01/01 Shortfall @ Current [NAME]: |  |  |  |  | 8.24 | 1/ | 5.6802
3 | 02/01 Activity
4 | Dollar Valued Imbalance |  |  | -1505362
5 | Imbalance Tiering Gain |  |  |  | 181380
6 | Gas Purchases |  |  | 0 | 0
7 | Miscellaneous
8 | Net 02/01 Activity |  | -832458
9 | 02/01 Balance Per Books: |  |  |  |  |  |  | 5.6802
 | 1/  Prior Month's MIP
 | March, 2001
1
2 | Revalue 02/01 Shortfall @ Current [NAME]: |  |  |  |  |  | 1/ | 5.1093
3 | 03/01 Activity
4 | Dollar Valued Imbalance |  |  | 207686
5 | Imbalance Tiering Gain |  |  |  | 119303
6 | Gas Purchases |  |  | 0 | 0
7 | Miscellaneous
8 | Net 03/01 Activity |  | -330253
9 | 03/01 Balance Per Books:
 | 1/  Prior Month's MIP
 | April, 2001
1
2 | Revalue 03/01 Shortfall @ Current [NAME]: |  |  |  |  |  | 1/ | 5.0522
3 | 04/01 Activity
4 | Dollar Valued Imbalance |  |  | -722337
5 | Imbalance Tiering Gain |  |  |  | 38261
6 | Gas Purchases |  |  | 0 | 0
7 | Miscellaneous
8 | Net 04/01 Activity |  | -8339
9 | 04/01 Balance Per Books:
 | 1/  Prior Month's MIP
 | May, 2001
1
2 | Revalue 04/01 Shortfall @ Current [NAME]: |  |  |  |  |  | 1/ | 4.0551
3 | 05/01 Activity
4 | Dollar Valued Imbalance |  |  | -1810647
5 | Imbalance Tiering Gain |  |  |  | 131974
6 | Gas Purchases |  |  | 0 | 0
7 | Miscellaneous
8 | Net 05/01 Activity |  | 723801
9 | 05/01 Balance Per Books:
 | 1/  Prior Month's MIP
 | June, 2001
1
2 | Revalue 05/01 Shortfall @ Current [NAME]: |  |  |  |  |  | 1/ | 3.4999
3 | 06/01 Activity
4 | Dollar Valued Imbalance |  |  | -232665
5 | Imbalance Tiering Gain |  |  |  | 106036
6 | Gas Purchases |  |  | 0 | 0
7 | Miscellaneous
8 | Net 06/01 Activity |  | -293941
9 | 06/01 Balance Per Books:
 | 1/  Prior Month's MIP
 | July, 2001
1
2 | Revalue 06/01 Shortfall @ Current [NAME]: |  |  |  |  |  | 1/ | 2.9322
3 | 07/01 Activity
4 | Dollar Valued Imbalance |  |  | -144676
5 | Imbalance Tiering Gain |  |  |  | 143902
6 | Gas Purchases |  |  | 0 | 0
7 | Miscellaneous
8 | Net 07/01 Activity |  | 1217796
9 | 07/01 Balance Per Books:
 | 1/  Prior Month's MIP
 | August, 2001
1
2 | Revalue 07/01 Shortfall @ Current [NAME]: |  |  |  |  |  | 1/ | 2.8522
3 | 08/01 Activity
4 | Dollar Valued Imbalance |  |  | -6496
5 | Imbalance Tiering Gain |  |  |  | 72564
6 | Gas Purchases |  |  | 0 | 0
7 | Miscellaneous
8 | Net 08/01 Activity |  | 671833
9 | 08/01 Balance Per Books:
 | 1/  Prior Month's MIP