Information on Merging Hugoton & Panoma Data

Data updated 6/19/2008.

• April 2008
• April 2008 Schedule (Adobe Acrobat)
• April 2008 Schedule with page breaks, by company (Adobe Acrobat)
• Microsoft Excel spreadsheet of the schedule (5.1 MB). This spreadsheet contains slightly more information than the "printed" Adobe Acrobat Schedule, but was created using the same view of the data. Also contains detailed production volume reported.
• March 2008
• March 2008 Schedule (Adobe Acrobat)
• March 2008 Schedule with page breaks, by company (Adobe Acrobat)
• Microsoft Excel spreadsheet of the March 2008 schedule (5.1 MB).
• February 2008
• February 2008 Schedule (Adobe Acrobat)
• February 2008 Schedule with page breaks, by company (Adobe Acrobat)
• Microsoft Excel spreadsheet of the schedule (5.1 MB).
• January 2008
• January 2008 Schedule (Adobe Acrobat)
• January 2008 Schedule with page breaks, by company (Adobe Acrobat)
• Microsoft Excel spreadsheet of January 2008 schedule (5.1 MB).
• December 2007
• December 2007 Schedule (Adobe Acrobat)
• December 2007 Schedule with page breaks, by company (Adobe Acrobat)
• Microsoft Excel spreadsheet of December 2007 schedule (5.4 MB).
• November 2007
• November 2007 Schedule (Adobe Acrobat)
• November 2007 Schedule with page breaks, by company (Adobe Acrobat)
• Microsoft Excel spreadsheet of November 2007 schedule (5.2 MB).
• Hugoton Panoma Production Input Template (Excel spreadheet)
• Hugoton Panoma Well Test Input Template (Excel spreadheet)
• We can create individualized templates for your company to assist in their electronic submissions. Contact .
• Microsoft Word document with explanations of the data and process.
• Questions: please call or email questions to or 785-271-3298.
• Submitting data electronically - Please continue to submit data to Wichita State in the prescribed format. We would like your comments and assistance to create a new, mutually agreed upon format. We will have an ftp site set up of our own.
• Online input form for those who have a small number of wells
• Comments are welcome. Corrections are welcome.
• API Numbers - Eventually, we would like to use API numbers as the well identifier. If you have a data mapping of API to WSU Lease ID, please share it with us.

There are two maps provided in Adobe Acrobat format. The first is a well density map of each section in the field; the second is a map indicating sections that have more than one operator in a section (see Units section below for more information).

• Operators
• The Wichita State system had assigned operator numbers to each operator. Some of these operator numbers were identical to the KCC License Number, some were not. When the new system is in place all references to operator will be the KCC License Number.
• Purchasers
• Each purchaser had a number assigned, luckily they were the same between the two reports (Hugoton & Panoma), therefore, we have kept the same numbers.
• Wells
• Currently, each well has a unique Lease Code that was assigned by Wichita State (WSULeaseID).
• We wanted to be able to quickly identify Hugoton wells from Panoma wells, so we added 100,000 to the WSULeaseID of a Hugoton well and 300,000 to the WSULeaseID of a Panoma well. For example, if a Hugoton well had a WSULeaseID of 45678, it becomes 145678. A Panoma well with a WSULeaseID of 654, becomes 300654. We believe this little trick also allows us to continue to load production reports using the WSU submittal format until we can redefine the production report format.These new numbers are listed under the column KCCLeaseID.
• API Well Number
• Review and correct any of the API numbers listed. Also provide API numbers that are missing in our data. If the well was drilled prior to 1967 and no API Well Number is available, enter the month and year the well was drilled.
• Spot Location
• The spreadsheet has a column for spot location; please provide any details such as quarter calls or footages.
• Acres
• Review and verify the acres associated with the well/unit. Refer to the draft order in section F.4 for further information regarding acreage.
• Units
• The draft order mentions two types of units. "Basic Acreage Unit" and "Alternate Track Unit".
• Currently, all units are defined as "Basic Acreage Unit"
• The draft order describes the number of wells on a unit, therefore we have attempted to assign unit identification numbers (NewUnitID) to the existing wells. The process to assign NewUnitIDs was as follows.
• If a Township/Range/Section had only one operator, the NewUnitID will become the lowest value of the KCCLeaseID on the section.
Of the 9,985 wells, all but 1,346 were assigned a NewUnitID in this manner. (The spreadsheet sorted by township/range/section will show this relationship under the column NewUnitID.)
• If a Township/Range/Section has more than one operator on the section the NewUnitID has been left blank. The KCC will assign these unit identifiers after verifying the wells/operators/acreage.