The export file can be thought of as being divided into two sections. The first section contains the header data line, and is only a single record. The second section is the data section and contains all the well information for each well in the well list.
All data is exported in metric units.
The lone line in the header section looks exactly like this:
0000,MerakImport Format From AccuMap
1000,"Well List Name"
The data section occurs once for each well. Each section is composed of five subsections:
This section provides general well information. It contains five records:
0001,"UWI"
0002,"Well Name","Field","Pool Name"
0003,"Fluid","Fluid code","Mode as a string",,,,,,
0004,,,"Operator Name",”Licensee Name”,"Unit Code",
0005,,,"Battery code",,,"On Prod date",,
0006,"Zone","Producing Formation Name"
On Prod date format depends on the date format set in AccuMap: original data format (dd/mm/yy), Year 2000 compliant date format (dd/mm/yyyy).
This section is only included if you are licensed for production data. Often, this section comprises the majority of the data for each well. There are two record types in this section:
1. 0150 records (Cum Prior Production records). Alberta wells only. Absent if there is no production prior to 1962. If there was, there is a single record detailing the cumulative amounts.
2. 0250 records (Current Production records). These contain the current production data values. There is one record for each month of production.
0150,Cum Prior Oil,Cum Prior Gas,Cum Prior Water,Cum Prior Condensate
0250,Month,Year,Oil Vol,Gas Vol,Water Vol,Condensate Vol,# of Hours,# of Wells
Month is a two-digit month. Year is a four-digit year. Volumes and hours are formatted to a single decimal place. # of Wells is always 1, since this export is done on a well-by-well basis. Oil (m3), Gas (E3m3), Water (m3), Condensate (m3).
There are two record types in this section:
1. 0160 records (Cum Prior Injection records). Alberta wells only. Absent if there is no injection data prior to 1962. If there is injection prior to 1962, there is a single record detailing the cumulative amounts.
2. 0260 records (Current Injection records). These contain the current injector data values. There is one record for each month of production.
0160,Inj Prior Water,Inj Prior Gas,Inj Prior Solvent
0260,Month,Year,Inj Water Vol,Inj Gas Vol,Inj Solvent Vol,# of Hours,# of Wells
Month is a two-digit month. Year is a four-digit year. Volumes and hours are formatted to a single decimal place. # of Wells will always be 1, since this export is done on a well-by-well basis. Inj Water (m3). Inj Gas (E3m3). Inj Solvent (E3m3).
This section is only present if you are licensed for pressure data.
For each gas analysis, there are two adjacent records:
1. 0550 (Gas Analysis).
2. 0551 (Gas Composition).
0550,Test Day,Test Month,Test Year,Tc,Pc Dens (calculated),,,
0551,Test Day,Test Month,Test Year,N2,CO2,H2S,H2,HE,C1,C2,C3,IC4,NC4,IC5+NC5,C6,C7P
If pool gas analysis exists for the well, it is exported; otherwise, well gas analysis is exported. The Test Day and Test Month fields are all two-digits long, the Test Year is four-digits. If there is no date for the test, then the date fields are left blank.
The Tc (K) and Pc (kPaa) fields are integer values (no decimal places). This means that these fields are rounded and won’t be identical to the value on the Gas Analysis card. The Dens field has two decimal places. The density is the calculated value (as opposed to file source). The mole percentage values (the last 13 fields of the Gas Composition record) have four decimal places.
This section appears if you are: licensed for pressure data, have chosen not to export pressure data or the KB, have chosen pressure data and not KB data but there is no pressure data, and have requested pressures not KB but there is no pressures information.
If you attempted to export KB data and either there is no pressure data or it wasn’t selected for export, there is only a single record in this section. It only contains the KB requested:
0552,KB Elevation,
If there is pressure data to be exported, for every pressure interval, there is this set of records:
1. 0552 (Pressure Interval).
2. 0553 (Pressure Test).
3. 0554 (Pressure Deliverability).
0552,KB,,Top of Interval,Base of Interval,Pool Datum,Well Datum,Initial Pressure,
0553,Day,Month,Year,TestCode1,TestCode2,Shut-In Time, Wellhead Pressure,Run Depth,Run DP Pressure,Run DP Gradient,Frun DP Temperature,Datum Pressure,,,1,1
0554,Day,Month,Year,TestCode1,TestCode2,Flow Hours,Flow Rate,Flow Pressure,Reservoir Pressure,Line Exponent,Reported AOF,,,,,1,1
Where:
For 0552, Interval depths, Top and Base, datums, Pool and Well are expressed to one decimal place, IP (Initial Pressure) contains no decimal places. KB (m). Top/Base of Interval (m KB). Pool Datum (m elevation, not m SS as on the Gas/Pressure card in AccuMap). Well Datum (m CF). Initial Pressure (kPaa).
For 0553, Day, Month and Year of the test are 2, 2, and 4 digits long respectively. Shut-In Time (hrs) has one decimal place. Wellhead Pressure (kPaa) has no decimal places. Run Depth (m CF) has one decimal place. Run DP Pressure (kPaa) has one decimal place. Run DP Gradient (kPaa/m) has two decimal places. Run DP Temperature (C) has no decimal places. Datum Pressure (kPaa) has no decimal places.
| Type | TestCode1 |
|---|---|
| 1 (Undef) | 0 |
| 2 (TH Undef) 3 (TH Build-Up) |
2 |
| Remaining types | 1 |
| Type | TestCode2 |
| 1 (Undef) | 0 |
| 3 (TH Build-Up) 5 (BH Build-Up) |
2 |
| 4 (BH Static Grad) | 1 |
| Remaining types | 0 |
For 0554, Day, Month, and Year of the deliverable are 2, 2, and 4 digits long respectively. Flow Hours (hrs) has one decimal place. Flow Rate (E3m3/d) has two decimal places. Flow Pressure (kPaa) has no decimal places. Reservoir Pressure/MPP (kPaa) has no decimal places. Line Exponent has two decimal places. Reported AOF (E3m3/d) has two decimal places.
| Type | TestCode1 |
|---|---|
| All | 0 |
| Type | TestCode2 |
| 1 (Single Pt) | 1 |
| 2 (Multi Pt) | 2 |
| 3 (Theoretical) | 3 |
| 4 (Incomplete) | 4 |
| Remaining Types | 0 |