The reports provided on the MPSC web site are part of an ongoing project to eventually provide the public with interactive access (see e-file production) to a production database (in Microsoft Access) that is kept for each production type (see production types below). Due to the differences in numbers of wells reported, some formations will have different file types available. Look for Antrim data to be updated about every month and other production types to be updated about every quarter. We welcome your comments or suggestions on how you use this data, and how we can help you better.

Antrim Production- what is reported

In the past, Antrim monthly production volumes reported to the MPSC have been either produced gas or sales gas. Produced gas volumes include carbon dioxide gas. Currently, a few Antrim projects produce gas with as much as 30% carbon dioxide. Sales gas volumes do not include the carbon dioxide gas. MPSC staff have been working with producers to standardize Antrim gas production reporting so that all producers report sales gas volumes. Prior to June 1998, about one-half of the Antrim production reporters were reporting produced gas volumes with the other half reporting sales volumes. Since June 1998, the producers that were previously reporting produced gas volumes have switched or are working on making the change to reporting a sales gas volume. Specifically, the MPSC is requiring a "delivered volume", which is the volume of the gas at the delivery point where the gas leaves Michigan Consolidated Gas Company's (or a Michigan Consolidated Gas Company affiliate) pipeline system. All producers should be reporting delivered volumes by January 2000.

Antrim Production- how to use

Antrim Production data is available in 4 reports (month summary, month detail, year-to-date summary, and year-to-date detail), each in PDF format. Antrim production is also available in Comma Separated Values, or CSV (for data starting with July, 1990). See Using CSV files below. The reports in PDF format include production starting with 1999. For reports including production data from earlier dates, contact MPSC production staff.

To view and print these reports through your web browser PDF stands for Portable Document Format. To view these reports, you will need Adobe Acrobat Reader available free from Adobe. If it is installed on your computer, click on the PDF version, then view and/or print the report pages that you are interested in. You can use Find to locate specific information.     CSV formatted files are text files with data values separated by commas. See Using CSV files below. The same file is also available in a compressed format. See Using Compressed Files below.

To download these reports for viewing and printing in other programs Download the report. Either ... For non-PDF files, click on the report that you want. If you are presented an option to open the file or save it to disk, choose save it. Where the report displays your web browser, select File, Save As from the command line. Note your options on type of file to save as and where you want to save it (so you can find it later). If you only want part of the report, select the text that you want, then use copy and paste to copy the selected text to another program. Or ... Right Click on the report that you want. If your web browser supports right mouse clicks (or the reverse for left handers), then select Save Link As, or Save Target As, to get a Save As dialog box. Note your options on where you want to save it (so you can find it later). This is the best way to save PDF format files, as the Adobe Acrobat Reader normally does not offer a Save option (except when using Acrobat 4 "in-line" in your web browser). Or ... Click on compressed file (for PC, not Mac). In the Save As dialog box, , note your options on where you want to save it (so you can find it later). Where Microsoft browsers allow selection to "Run this file" select run. See Using Compressed Files below. Find the reports and open them in the software that you want to use. The PDF version uses Adobe Acrobat Reader. For Comma Separated Values, or CSV format, see Using CSV files below. Return to Production Reports Page

Casinghead Gas Production- what is reported

Prior to January 1999, Casinghead (gas produced from oil wells) monthly production volumes were reported to the MPSC as sales gas volumes or more accurately classified as final allocated volumes if transported on any MichCon pipeline. Effective January 1999, the production volumes are sales volumes or more accurately called delivered volumes. The difference between final allocated volumes and delivered volumes is the BTU adjustment (liquids) and fuel. The production volumes will appear higher prior to January 1999 for high BTU gas, (for example: PdC and Niagaran gas may have a lot of hydrocarbons in it and thus a high BTU measurement ), since the final allocated volumes took into account these BTUs. However, if the sales contract delivery point is still at the wellhead then the delivered volume will be the final allocated volume since the title is transferred there.

Casinghead Gas Production- how to use

Casinghead Gas Production is available, starting with January, 1998 (with some data for later 1997), in one report format: Comma Separated Values, or CSV. See Using CSV files below. The same file is available in a compressed format. See Using Compressed Files below.

For reports including production data from earlier dates, contact MPSC production staff.

Return to Production Reports Page 

Dry Gas Production- what is reported

Prior to January 1999, Dry Gas (non-Antrim and non-PdC) monthly production volumes were reported to the MPSC as sales gas volumes or more accurately classified as final allocated volumes if transported on any MichCon pipeline. Effective January 1999, the production volumes are sales volumes or more accurately called delivered volumes. The difference between final allocated volumes and delivered volumes is the BTU adjustment (liquids) and fuel. The production volumes will appear higher prior to January 1999 for high BTU gas, (for example: PdC and Niagaran gas may have a lot of hydrocarbons in it and thus a high BTU measurement ), since the final allocated volumes took into account these BTUs. However, if the sales contract delivery point is still at the wellhead then the delivered volume will be the final allocated volume since the title is transferred there.

Dry Gas Production- how to use

Dry Gas Production is available, starting with January, 1996, in one report format: Comma Separated Values, or CSV. See Using CSV files below. The same file is available in a compressed format. See Using Compressed Files below.

For reports including production data from earlier dates, contact MPSC production staff.

Return to Production Reports Page 

PDC Production- what is reported

Production from the Prairie du Chein (PdC) formation is reported as monthly sales volumes for condensate and dry gas. Prior to June 1998, a condensate to dry gas (barrels to Mcf) conversion was determined by the operators and a condensed gas equivalent volume was provided. (For proration purposes however, the MPSC only regulates the dry gas production.) Beginning in June 1998, when the new joint MPSC/DEQ production reporting form came into use (EQP-7101) , the conversion was not required and so the condensed gas equivalent volume is no longer provided.

PDC Production- how to use

PdC production is available, starting with March, 1994, in one report format: Comma Separated Values, or CSV. See Using CSV files below. The same file is available in a compressed format. See Using Compressed Files below.

For reports including production data from earlier dates, contact MPSC production staff.

Return to Production Reports Page 

Using CSV Files

Monthly data for each production type is available in Comma Separated Values, or CSV format. CSV format is a text file with each piece of information separated by a comma. This is also known as comma delimited. You must either set up your computer to open the file with your web browser, or download the file to your computer, then open it into a database, spreadsheet, or word processing program.

	To set up your computer to open CSV files If you know what program (application) you want to use to view the CSV file, you will want to set up your computer to open CSV files using that program instead of having to download the file, then find it and open it. If you do not know, then try the steps below to download and open, then try this step later. Click on the file that you want. If Netscape or Microsoft Internet Explorer offers a choice to open the file or save it to disk, select open the file. Netscape If Netscape does not know what a CSV file is, it will offer a choice to pick an application or save. Select pick application, then browse to the application that you want to use. You will have to know where the application is and its name (such as c:\lotus\123\123w.exe), however. After setting this up, each time that you click on a CSV file, Netscape will get it and open it in the application. Microsoft Internet Explorer If Microsoft Internet Explorer does not know what a CSV file is, you must make Windows associate it with an application. In Windows, Internet Explorer will offer Open With to create an association (you can also use right-click on a file, then click Open With to create an association by checking the box to always use this program). In Windows, you can use the Windows File Manager (to find File Manager, click Start, Run, then type in winfile, then click OK) to associate CSV files with a particular application (use the command File, Associate). Once Windows knows what application to use, then Internet Explorer will use it.
	To download CSV files Download the report. Either ... Click on the file that you want. If you are presented an option to open the file or save it to disk, choose save it. In the Save As dialog box, note your options on where you want to save it (so you can find it later). Or ... Right Click on the report that you want. If your web browser supports right mouse clicks (or the reverse for left handers), then select Save Link As, or Save Target As, to get a Save As dialog box. Note your options on where you want to save it (so you can find it later). Or ... Click on compressed file (for PC, not Mac). In the Save As dialog box, , note your options on where you want to save it (so you can find it later). Where Microsoft browsers allow selection to "Run this file" select run. See Using Compressed Files below.
	To open CSV files for viewing and printing Data Base CSV files can be imported directly into many data base programs such as Microsoft Access or Microsoft Works. You can then generate a report, selecting only the information that you want to see. To import a file into Access, open a new or existing database file, then select file, get external data, import, find CSV in file types, then select the CSV file. Spreadsheet Spreadsheets differ on how much information they can load. Many have page limits, and will not carry over to a second or third page. The PdC file is significantly larger than some of the page limits. Spreadsheets are best for sorting the file on various columns, then selecting the part that you are interested in. You can also use find or search from the command line to locate specific information. Spreadsheet Rating Comments Excel 2002 excellent has 65,536 row limit Excel 2000 excellent has 65,536 row limit Excel 97 excellent no apparent row limit My Lotus 1-2-3, v 9.5 excellent has 65,536 rows, but carries data over to extra pages Lotus 2000 excellent has 65,536 row limit Lotus 97 good has 8,192 row limit, but carries data over to extra pages MS Works 4, MS Works 2000 good for small files (such as Dry Gas) unusable for large files (such as PdC) has 16,384 row limit, will not load remaining data Corel Quatro Pro 8 unusable has 8,192 row limit, loads only a small portion of large files Word Processing Some word processing programs, such as WordPerfect, will accept a CSV file directly into a table. Others, like Word, may let you create a table after opening a CSV file (select all of the text, then create a table from it using table, convert, text to table). A table better aligns the data values, making them easier to read. Be aware that the document may be several times larger than the CSV file, and prohibitively long for large CSV files (such as PdC). When imported into any word processing program as plain text, the data values do not line up, but you can use find or search from the command line to locate specific information.

Return to Production Reports Page  

Using Compressed Files

To save you time downloading reports, some of the reports have been compressed into a self-extracting compressed file that will run on your computer as an application (or program) in Windows. This file, when opened (or run), will create the original data reports. First, download the file that you want by clicking on it. If your web browser asks if you want to open this application, or save it to disk, choose open. In the save as dialog box, decide where you want the file to be so that you can find it. After downloading, find the file, then open it. Each application is checked for viruses (using McAfee) prior to posting on our site. When you open the file, you will see this dialog box.

Note where, or type in where you want the files to be created on your computer (the default is a folder created on your C drive called gasprod), then select Start. Floppy disks not recommended as they are slow and too small for some of the files. Note that you can choose to automatically overwrite existing files of the same name.

Find the files and open them in the software that you want to use.

Return to Production Reports Page