Spreadsheet: jane_tholt__13174__Attachment 13 filed 11-13 
Sheet: Sheet1

Row | Peak Season (FR Only) | TNMA Area | EPNG Area | Shipper | FR Converting Shipper Max NCP Qtys Last 5 Years | Winter Primary Daily Delivery Capacity (Avg of Study 6a and 6b CD & 5Yr NCP/ 2000 NCP both [NAME]) | Winter East-West using %  sharing of Short fall in Winter | Qty not Assng Wntr w/ Sharing of % deficiency | Qty not Assng Smmr w/ Sharing of % deficiency | Summer East-West using %  sharing of Short fall in Summer | Summer Primary Daily Delivery Capacity (Avg of Study 6a and 6b CD & 5Yr NCP/ 2000 NCP both Smmr) | CD & FR Pct [NAME] against CD & Avg 5 Yr NCP/2000 NCP | CD & FR Pct Smmr Shortfall against CD & Avg 5 Yr NCP/2000 NCP | On Pk Pct Below High day of last 5 Yrs (Red)
1 | Summer | East End | FR | Navajo Tribal Utility Authority | 21073 | 14675.2 |  |  |  |  | 12509.2
 | Summer | East End | FT2 | North Bailey Cooperative Society | 109 | 21.5 |  |  |  |  | 78.5
 | Summer | West End | FR | Arizona Electric Power Cooperative, Inc. | 46590 | 32487 |  |  |  |  | 35504
 | Summer | West End | FR | Arizona Public Service Company | 241097 | 160033 |  |  |  |  | 206773
 | Summer | West End | FR | BHP Copper Inc. | 20026 | 7693.5 |  |  |  |  | 6723
 | Summer | West End | FR | El Paso Electric Company | 123069 | 99176 |  |  |  |  | 121123
 | Summer | West End | FR | MGI Supply, Ltd. (Naco) 1/ | 43000 | 39217 |  |  |  |  | 41794.5
 | Summer | West End | FR | Salt River Project | 262891 | 167348.5 |  |  |  |  | 212947.5
 | Summer | West End | FT2 | Apache Nitrogen Products, Inc. | 2050 | 1810.5 |  |  |  |  | 1881.5
 | Summer | West End | FT2 | Rio Grande Natural Gas Association | 25059 | 7580.5 |  |  |  |  | 4392.5
 | Winter | East End | FR | PNM Gas Services, A Division of Public | 84448 | 88776.93 |  |  |  |  | 53850.72
 | Winter | East End | FR | Southern Union Gas Company 1/ | 25000 | 22904.25 |  |  |  |  | 9963.675
 | Winter | East End | FT2 | City of Big Lake, Texas | 1081 | 811.5 |  |  |  |  | 389.5
 | Winter | East End | FT2 | City of Denver City, Texas | 1774 | 1434.5 |  |  |  |  | 754
 | Winter | East End | FT2 | City of Goldsmith, Texas | 108 | 98 |  |  |  |  | 44.5
 | Winter | East End | FT2 | City of Morton, Texas | 956 | 811 |  |  |  |  | 462.5
 | Winter | East End | FT2 | City of Plains, Texas | 685 | 541.5 |  |  |  |  | 290.5
 | Winter | East End | FT2 | City of Spur, Texas | 384 | 379 |  |  |  |  | 175.5
 | Winter | East End | FT2 | City of Whiteface, Texas | 181 | 165.5 |  |  |  |  | 50
 | Winter | East End | FT2 | Dumas, Texas, City of | 5590 | 5261.5 |  |  |  |  | 2664.5
 | Winter | East End | FT2 | McLean, Texas, City of | 740 | 544.5 |  |  |  |  | 245.5
 | Winter | East End | FT2 | Natural Gas Processing Co. 1/ | 6647 | 8525.5 |  |  |  |  | 6605.5
 | Winter | East End | FT2 | Sterling Natural Gas, Inc. | 1956 | 255 |  |  |  |  | 182.5
 | Winter | East End | FT2 | Zia Natural Gas Company | 583 | 561.5 |  |  |  |  | 346.5
 | Winter | West End | FR | ASARCO Incorporated | 12002 | 10385 |  |  |  |  | 10158.5
 | Winter | West End | FR | Chemical Lime Company of Arizona | 4250 | 1791.5 |  |  |  |  | 2812.5
 | Winter | West End | FR | Citizens Utilities 1/ | 100000 | 93606 |  |  |  |  | 66582.5
 | Winter | West End | FR | City of Las Cruces, New Mexico | 24921 | 24224.5 |  |  |  |  | 12067.5
 | Winter | West End | FR | City of Lordsburg, New Mexico | 1027 | 749 |  |  |  |  | 391.5
 | Winter | West End | FR | City of Mesa, Arizona | 23004 | 21955.5 |  |  |  |  | 15103
 | Winter | West End | FR | Navajo Tribal Utility Authority | 5327 | 3668.8 |  |  |  |  | 3127.3
 | Winter | West End | FR | Phelps Dodge Corporation | 47487 | 45982 |  |  |  |  | 45229
 | Winter | West End | FR | PNM Gas Services, A Division of Public 1/ | 48000 | 45733.57 |  |  |  |  | 27741.28
 | Winter | West End | FR | Southdown, Inc. | 3 | 0 |  |  |  |  | 0 | 0 | 0
 | Winter | West End | FR | Southern Union Gas Company 1/ | 140000 | 129790.75 |  |  |  |  | 56460.825
 | Winter | West End | FR | Southwest Gas Corporation 1/ | 585000 | 534907 |  |  |  |  | 259454.5
 | Winter | West End | FT2 | Black Mountain Gas Company | 2287 | 2219.5 |  |  |  |  | 1657.5
 | Winter | West End | FT2 | City of Benson, Arizona | 1148 | 961.5 |  |  |  |  | 596
 | Winter | West End | FT2 | City of Deming, Texas | 4182 | 3479.5 |  |  |  |  | 2264
 | Winter | West End | FT2 | City of Safford, Arizona | 2146 | 2013 |  |  |  |  | 934
 | Winter | West End | FT2 | City of Socorro, New Mexico | 2813 | 2445 |  |  |  |  | 1214.5
 | Winter | West End | FT2 | City of Willcox, Arizona | 1441 | 1083.5 |  |  |  |  | 582.5
 | Winter | West End | FT2 | Corona, New Mexico, Village of | 72 | 69 |  |  |  |  | 53.5
 | Winter | West End | FT2 | Duncan Rural Services Corporation | 519 | 465 |  |  |  |  | 333.5
 | Winter | West End | FT2 | Graham County Utilities, Inc. | 3833 | 2480 |  |  |  |  | 1201.5
 | Winter | West End | FT2 | Town of Mountainair, New Mexico | 538 | 218 |  |  |  |  | 141
 |  |  |  | West FR Winter Pkr NCP Total
 |  |  |  | West FR Smmr Pkr NCP Total
 |  |  |  | West FR Total
 |  |  |  | Winter West FR Winter Pkr NCP Total
 |  |  |  | Winter West FR Smmr Pkr NCP Total
 |  |  |  | Winter West FR Total
 |  |  |  | Summer West FR Winter Pkr NCP Total
 |  |  |  | Summer West FR Smmr Pkr NCP Total
 |  |  |  | Summer West FR Total
 |  |  |  |  | Winter Capacity From 6a |  | 4486912
 |  |  |  |  | Summer Capacity from 6b |  | 4431717
 |  |  |  |  | [NAME] | 0
 |  |  |  |  | Winter Capacity From Study |  | 4600699
 |  |  |  |  | Summer Capacity from Study |  | 4369571
 |  |  |  |  | Winter Capacity Used Appendix A
 |  |  |  |  | Summer Capacity Used Appendix A
 |  |  |  |  | Pct [NAME] to both [NAME] and CD Winter |  | 0.931
 |  |  |  |  | Pct [NAME] to both [NAME] and CD Summer |  | 0.942
 |  |  | 1/ | [NAME] based upon Consultant Estimate as most recent data not available from  EPNG at level of detail necessary to permit greater precision