Michigan Oil and Gas Well - Gas Analysis Data                                                                   
Gas analyses                                                                  
                                                                   
Original data downloaded from: Michigan Oil and Gas Well - Gas Analysis Data; Michigan Basin Core Research Laboratory at:http://www.wmich.edu/geology/corelab/corelab.htm                                                          
Listed by Group/Formation (approximate descending stratigraphic order).                                                            
Production depth and formation names were taken from the Michigan Department of Environmental Quality online oil and gas database.  Querys were based on permit numbers.                                                          
API Numbers initially created from permit numbers; verified through Michigan Department of Environmental Quality online Oil and Gas database.                                                           
Duplicate analyses were deleted, obvious data entry errors corrected.                                                            
Gas wetness calculated by; Wetness % = 100 x (1-[mol%C1/Σmol%C1-C5]); gas wetness <50% = gas; gas wetness >50% = gas liquid/condensate.                                                          
NIL = 0.00%; TRACE = 0.005%                                                          
USGS latitude and longitude represents the location of the center of a quarter-mile square cell created to display oil and gas assessment data. The actual well location falls within the area of the cell.*                                                          
                                                                   
PERMIT # API  # OPERATOR WELL NAME WELL # SECTION TOWNSHIP RANGE USGS_LON USGS_LAT COUNTY FIELD FORMATION FM.TOP (FT.) SAMPLE SOURCE OXYGEN NITROGEN HYDROGEN SULFIDE CO2 METHANE ETHANE PROPANE ISO-BUTANE N-BUTANE ISO-PENTANE N-PENTANE HEXANES HEPTANES PLUS WETNESS GAS GRAVITY BTU SAMPLE DATE MISCELLANEOUS  
                                                                   
30952 21025309520000 GAB MATTHEW B WOODS 1-26 26 1S 5W -84.84559243 42.34569108 CALHOUN CAL-LEE MARSHALL SANDSTONE 124 NATURAL GAS NIL 15.23 NIL 0.16 64.02 12.57 5.44 0.67 1.12 0.22 0.32 0.16 0.09 24.11 0.775 1101 7/15/1983    
15014 21113150140000 LEASE MANAGEMENT MERRILL-PALMER SCHL 1 35 22N 6W -85.0083984 44.2529501 MISSAUKEE PROSPER MICHIGAN FORMATION 1258 NATURAL GAS NIL 4.22 1.27 0.47 77.46 11.81 4.20 0.26 0.18 0.05 0.02 0.03 0.03 17.58 0.691 1151 6/12/1979    
31089 21133310890000 PPG OIL & GAS COMPANY D THOMPSON ET AL 2-36       -85.34183816 43.81552271 OSCEOLA HERSEY 36-17N-9W MICHIGAN FORMATION 1609 NATURAL GAS NIL 0.50 NIL 0.11 96.77 2.43 0.16 0.01 0.02 TRACE NIL NIL NIL 2.64 0.571 1028 1/20/1983    
1436 21073014360000 H.E. TOPE H MCGUIRE 1 35 16N 4W -84.7495977 43.72994416 ISABELLA VERNON MICHIGAN FORMATION?   NATURAL GAS NIL 1.12 5.61 0.46 56.03 19.18 11.23 1.49 2.93 0.58 0.81 0.43 0.13 39.26 0.905 1454 10/22/1982    
1436 21073014360000 H.E. TOPE H MCGUIRE 1 35 16N 4W -84.7495977 43.72994416 ISABELLA VERNON MICHIGAN FORMATION?   NATURAL GAS NIL 1.35 1.99 0.74 60.14 17.78 10.70 1.62 3.46 0.64 0.91 0.46 0.21 36.86 0.890 1469 10/15/1982    
2087 21073020870000 H.E. TOPE MICHAEL MCGUIRE 2 36 16N 4W -84.7495977 43.72994416 ISABELLA VERNON MICHIGAN FORMATION? 1292 NATURAL GAS NIL 1.34 4.72 0.66 52.76 17.78 11.98 2.01 5.05 0.96 1.58 0.81 0.35 42.73 0.979 1573 10/15/1982    
39786 21049397860000 RAY JONES OIL SMITH 2-5 5 9N 8E -83.56030857 43.21566808 GENESSE OTISVILLE BEREA SANDSTONE 1448 NATURAL GAS NIL 19.64 NIL 0.43 70.77 6.17 2.30 0.16 0.37 0.06 0.06 0.02 0.01 11.42 0.702 907 8/5/1986    
30455 21087304550000 MID STATE OIL & GAS A E RANDALL CONSOL 1 27 10N 10E -83.29059163 43.26236954 LAPEER RICH BEREA SANDSTONE 1397 GAS NIL 19.17 NIL NIL 72.60 5.75 1.91 0.15 0.31 0.06 0.04 0.01 TRACE 10.17 0.688 923 6/10/1976    
33202 21049332020000 CRYSTAL EXPLORATION MULLINS L ET AL 1-5 5 9N 8E -83.56030857 43.21566808 GENESSE OTISVILLE BEREA SANDSTONE   GAS NIL 20.87 NIL NIL 70.80 5.56 2.09 0.16 0.35 0.06 0.06 0.04 0.01 10.47 0.698 910 3/6/1980    
20408 21087204080000 ONYX-FRITZ OIL AND GAS ASSOCIATION R K NEWCOMBE K-1 16 9N 9E -83.42350931 43.19529024 LAPEER MARATHON SEC 16 BEREA SANDSTONE 1447 NATURAL GAS NIL 1.68 0.03 0.57 74.24 16.92 5.30 0.46 0.58 0.09 0.08 0.03 0.02 23.99 0.719 1253 3/5/1980    
12251 21129122510000 MARATHON OIL COMPANY ADAMS-WALKER 1 12 22N 3E -84.01937498 44.31987955 OGEMAW LOGAN BEREA SANDSTONE 1424 NATURAL GAS NIL 4.21 NIL 0.17 79.15 10.86 3.82 0.43 0.94 0.08 0.10 0.20 0.04 17.02 0.692 1154 5/13/1986    
43121 21039431210000 MICHIGAN OIL COMPANY STATE MAPLE FOREST A1-3 3 28N 3W -84.66299326 44.85665465 CRAWFORD CRWFRD CTY-ANTRIM ANTRIM SHALE 1790 NATURAL GAS NIL 0.57 0.79 1.87 73.60 12.15 6.81 1.97 1.45 0.49 0.19 0.10 0.01 23.86 0.770 1307 10/15/1980    
36018 21137360180000 ANTRIM SHALE EXPLORATION 3 STATE CHESTER 5-25 25 30N 2W -84.50161798 44.95934187 OTSEGO CHESTER SEC 25 ANTRIM SHALE 1426 ANTRIM GAS NIL 1.17 NIL 5.17 93.59 0.05 0.02 TRACE NIL NIL NIL NIL NIL 0.07 0.609 949 10/27/1982    
39320 21137393200000 TERRA ENERGY LTD. STEVENS 2-13 13 30N 3W -84.60946593 44.99042574 OTSEGO BAGLEY SEC 14 ANTRIM SHALE 1400 ANNULUS GAS 0.02 1.32 NIL NIL 98.62 0.03 0.01 TRACE NIL NIL NIL NIL NIL 0.04 0.560 999 11/13/1985    
39965 21137399650000 TERRA ENERGY LTD. MILLER 1-13 13 30N 3W -84.62853102 44.99933096 OTSEGO BAGLEY SEC 14 ANTRIM SHALE 982 WELLHEAD GAS NIL 25.09 NIL 4.77 70.10 0.02 0.02 NIL NIL NIL NIL NIL NIL 0.06 0.704