Spreadsheet: 219928d1363015223-if-or-hlookup-formula-sample
Sheet: LoadSum

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-02-20 00:00:00 |  | 14:31:12
[NAME] by Contract for |  |  |  | ONEOK GAS TRANSPORTATION, L.L.C.
Pipeline: | ONEOK GAS TRANSPORTATION, L.L.C. |  |  |  |  |  |  |  |  | From: | 2013-02-01 00:00:00 |  | To: | 2013-02-20 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2/1/2013 |  | 2/2/2013 |  | 2/3/2013 |  | 2/4/2013 |  | 2/5/2013 |  | 2/6/2013 |  | 2/7/2013 |  | 2/8/2013 |  | 2/9/2013 |  | 2/10/2013 |  | 2/11/2013 |  | 2/12/2013 |  | 2/13/2013 |  | 2/14/2013 |  | 2/15/2013 |  | 2/16/2013 |  | 2/17/2013 |  | 2/18/2013 |  | 2/19/2013 |  | 2/20/2013 |  | Total
METER |  |  |  | SHIPPER AND CONTRACT
SCISSORTAIL CREEK PLANT    195089   SCISSORTAIL ENERGY, |  |  |  |  |  |  |  | PUBLIC SERVICE COMPANY OF OKLAHOMA                1-IT-0301 |  |  |  |  |  |  |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 80000
 |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 4000 |  | 80000
PSO-RIVERSIDE POWER STATI  197079   PUBLIC SERVICE COMPANY OF OKLAHOMA |  |  |  |  |  |  |  | ONEOK ENERGY SERVICES COMPANY, L.P.               1-IT-0050 |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  | PUBLIC SERVICE COMPANY OF OKLAHOMA                NEXT-IT-0500 |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
PSO SOUTHWEST              197087   PUBLIC SERVICE COMPANY OF OKLAHOMA |  |  |  |  |  |  |  | ONEOK ENERGY SERVICES COMPANY, L.P.               1-IT-0050 |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  | PUBLIC SERVICE COMPANY OF OKLAHOMA                NEXT-IT-0500 |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
PSO TULSA WEST             198018   PUBLIC SERVICE COMPANY OF |  |  |  |  |  |  |  | PUBLIC SERVICE COMPANY OF OKLAHOMA                NEXT-IT-0500 |  |  |  |  |  |  |  | -6000 |  | -6000 |  | -6000 |  | -6000 |  | -6000 |  | -6000 |  | -6000 |  | -6000 |  | -6000 |  | -6000 |  | -6000 |  | -6000 |  | -6000 |  | -8000 |  | -8000 |  | -8000 |  | -8000 |  | -8000 |  | -8000 |  | -8000 |  | -134000
 |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  | -6000 |  | -6000 |  | -6000 |  | -6000 |  | -6000 |  | -6000 |  | -6000 |  | -6000 |  | -6000 |  | -6000 |  | -6000 |  | -6000 |  | -6000 |  | -8000 |  | -8000 |  | -8000 |  | -8000 |  | -8000 |  | -8000 |  | -8000 |  | -134000
PSO NE POWER STATION/OOLO  198032   PUBLIC SERVICE COMPANY OF OKLAHOMA |  |  |  |  |  |  |  | ONEOK ENERGY SERVICES COMPANY, L.P.               1-IT-0050 |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  | PUBLIC SERVICE COMPANY OF OKLAHOMA                NEXT-IT-0500 |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
IMBALANCE RECEIPT          IMB-R O  ONEOK GAS TRANSPORTATION, L.L.C. |  |  |  |  |  |  |  | EDF TRADING NORTH AMERICA, LLC                    1-IT-0461 |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  | ENOGEX ENERGY RESOURCES LLC                       1-IT-0088 |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  | EXELON GENERATION COMPANY, LLC                    1-FT-0528 |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 18800 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 18800
 |  |  |  |  |  |  |  | FRONTIER ENERGY SERVICES,  L.L.C.                 1-IT-0441 |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  | MACQUARIE ENERGY, LLC                             1-IT-0320 |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  | ONEOK ENERGY SERVICES COMPANY, L.P.               1-IT-0050 |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 700 |  | 700 |  | 700 |  | 700 |  | 700 |  | 700 |  | 700 |  | 700 |  | 700 |  | 700 |  | 700 |  | 700 |  | 8400
 |  |  |  |  |  |  |  | ONEOK FIELD SERVICES COMPANY, L.L.C.              1-IT-0401 |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2/1/2013 |  | 2/2/2013 |  | 2/3/2013 |  | 2/4/2013 |  | 2/5/2013 |  | 2/6/2013 |  | 2/7/2013 |  | 2/8/2013 |  | 2/9/2013 |  | 2/10/2013 |  | 2/11/2013 |  | 2/12/2013 |  | 2/13/2013 |  | 2/14/2013 |  | 2/15/2013 |  | 2/16/2013 |  | 2/17/2013 |  | 2/18/2013 |  | 2/19/2013 |  | 2/20/2013 |  | Total
IMBALANCE RECEIPT          IMB-R O  ONEOK GAS TRANSPORTATION, L.L.C. |  |  |  |  |  |  |  | PUBLIC SERVICE COMPANY OF OKLAHOMA                1-IT-0301 |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  | SEMINOLE ENERGY SERVICES L.L.C.                   1-IT-0414 |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  | SEQUENT ENERGY MANAGEMENT, L.P.                   1-IT-0454 |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 209 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 209
 |  |  |  |  |  |  |  | SHELL ENERGY NORTH AMERICA (US), L.P.             1-IT-0282 |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 209 |  | 0 |  | 0 |  | 0 |  | 700 |  | 700 |  | 19500 |  | 700 |  | 700 |  | 700 |  | 700 |  | 700 |  | 700 |  | 700 |  | 700 |  | 700 |  | 27409
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-02-20 00:00:00 |  | 14:31:12 |  | Page 2 of 2