how to import export data reports
DESCRIPTION
Tnav TutorialTRANSCRIPT
Import Export Data
Reports
Training Tutorials 2013
Rock Flow Dynamics
2 Training description
2
In this course there is full description of tNavigator Import-Export and Reports:
1. Save binary files E100,
2. Summary Report for Accumulative or Instantaneous parameters
3. Create screenshot (maps, graphs)
4. Save data for blocks (Block Statistics), graphs, Well profile
5. Load measuring bottom-hole pressure for wells
6. Summation of user Map for grid blocks around the wellbore (Save Side Track Well Report)
7. Export cubes of static and dynamic properties of the model
8. User Maps creation
9. Load properties from files
10. Properties calculator
11. Load boundaries of FIP regions (sectors) from file
3 Open model
3
1. File. Open
2. Open demo-model format E100: file ModelWithHistory/m95.data
4 Run calculations
4
1. Run calculations
2. Wait till the end
3. The calculation can be put on pause (button Stop) and start running later in the same place,
or any previously calculated step
5 Save results in binary format files E100
5
1. Reports. Save Е100 Binaries (can be saved at any time step)
2. Tick parameters to save in the Dialogue. Save
3. Files are saved in the folder RESULTS
4. Tick Save to Current Directory to save files into the folder with model .data-file
6 Save Summary Report
6
1. Reports. Save Summary Report
2. Choose Accumulative or Instantaneous
3. Parameters: Accum. Oil, Accum. Water, Accum. Gas, Accum. Liquid, Accum. Inj. Water, Avg.
Pressure (the selection and arrangement of graphs will be offered in the dialogue later)
7 Parameters. Preview
7
1. Choose Page Format, Image Quality, graphs and its arrangement
2. Show Preview
3. Save
8 Accumulative Report .png file
8
9 Instantaneous Report .png file
9
10 Create screenshot
10
1. For Maps and Graphs press button Create screenshot
2. Set parameters, Show preview
3. Save – to the folder with model .data-file a new .png file with map/graphs will be saved
Create
screenshot
11 Block Statistics
11
1. 2D or 3D map right mouse click on block
2. Block Statistics
3. To select press the upper left corner of the table, Ctrl+C (Copy), Ctrl+V (Paste), to Excel for
example
12 Copy information from the graphs
12
1. tNavigator displays a lot of information in the form of graphs
2. The graphs include the production of regions, groups, wells, connections, changing the
properties of grid cells along an arbitrary profile and along the well bore
3. Nearly all graphs are accompanied by tables on the right. Copy information from graphs to
Excel: Ctrl A (or press left upper corner to select the table), Ctrl C, Ctrl V
4. Also copying to the file is duplicated via the button Export
Button Export
13 Copy to Excel all data for all graphs
13
Press Export All:
1. Enter file name (extension .xls to save to Microsoft Excel file)
2. Default: all historical and calculated values for all groups and all wells for all time steps will
be saved
3. Tick off objects that you don’t want to save data
Press Export All
Extension .xls
14 Well Profile Data
14
1. Open model SectorLowPerm/m100_fracs.data
2. Go to Maps. Calculated Maps. Pressure
3. 3D map
4. Tick Show All Wells
5. We see that the wells have connections at the top and bottom of the reservoir, between the
parts - barrier (inactive blocks)
6. Run calculations
Well Profile Data 15
1. Graphs. Well Profile – properties and rates along well bore (for connections)
2. Choose well (7 on the picture)
3. Tick properties Oil Total, Water total, Watercut, Bulk pressure
4. Right mouse click on profile graph, select Copy All
5. Copy (Ctrl V) to Excel file
16 Load measuring bottom-hole pressure for wells
16
1. Graphs. Pressure
2. Tick parameters: Bottom Hole Pressure, Loaded Pressure
3. Select well 7
4. Press – Load well graphs
5. Choose file: m100_BHP_well7.txt
6. Loaded graphs are shown and data is duplicated in the table
Load well graphs
17 File with measuring bottom-hole pressure
17
1. One should load well graphs only one time because data is copied to the folder RESULTS
2. Data format is below:
*Object Data Bottom Hole Pressure
7 29.04.2009 +2.48168777e+002
7 30.04.2009 +2.48113651e+002
7 01.05.2009 +2.48057152e+002
7 05.05.2009 +1.99594067e+002
7 06.05.2009 +1.97851325e+002
7 07.05.2009 +1.96604516e+002
7 08.05.2009 +1.95625151e+002
7 09.05.2009 +1.94810988e+002
7 13.05.2009 +1.92416138e+002
7 14.05.2009 +1.91943196e+002
7 15.05.2009 +1.91502193e+002
7 16.05.2009 +1.91088000e+002
7 17.05.2009 +1.90696621e+002
7 18.05.2009 +1.90325262e+002
7 19.05.2009 +1.89971077e+002
7 23.05.2009 +1.88740637e+002
7 24.05.2009 +1.88446113e+002
7 25.05.2009 +1.88159326e+002
7 26.05.2009 +1.87881380e+002
7 30.05.2009 +1.86844883e+002
7 31.05.2009 +1.86601997e+002
7 01.06.2009 +1.86364772e+002
7 02.06.2009 +1.67124586e+002
7 03.06.2009 +1.64526533e+002
7 04.06.2009 +1.63039587e+002
7 05.06.2009 +1.62012108e+002
7 06.06.2009 +1.61213644e+002
7 07.06.2009 +1.60548109e+002
7 08.06.2009 +1.59968827e+002
7 09.06.2009 +1.59450128e+002
7 12.06.2009 +1.58126588e+002
7 13.06.2009 +1.57737904e+002
7 24.06.2009 +1.54540006e+002
m100_BHP_well7.txt
18 Loading LAS-files. Well Section
18
tNavigator allows:
1. Load well trajectories, LAS files to the model, GIS curves visualization
2. Full description of LAS-files loading and Graphs. Well Section is in the course Load Las and
Well Section (HowToAddLASUseWellSection)
19 Load well data
19
1. Document. Load Well data
2. Schedule Files Dialogue has the following options: Layers, Trajectories, Groups, Events,
History, Well Logs
3. Full description is in the course HowToBuildModelFromScratch
4. The list and full description of loading formats and files examples (GWTD, LAS, Dip-circle etc.)
are in the tNavUserManual, section Data files. Loadable file formats
Summation of user Map for grid blocks around the wellbore
20
1. Maps. User Maps, Map
2. Enter in Map Arithmetic Command Line - moipm. Apply (Map of Mass Mobile Oil in place), at last
time step (on the picture)
3. Right mouse click on Map, choose Save Side Track Well Report
4. Enter Radius (number of blocks) around the well bore where the map is summed
5. Enter file name. Save
21 Summation of user Map for grid blocks around the wellbore
21
1. File m100_fracs_sum_near_wells.rep in the folder RESULTS
2. Summed values of User Map are stored in the following format (well - sum)
well name | function
'15' | 18525.8343440000
'23' | 31696.1723530000
'12' | 38486.2788600000
'25' | 40154.4517000000
'18' | 42235.6102970000
'8' | 45248.4017270000
'11' | 48486.5487250000
'14' | 53697.4659320001
'0' | 59043.3885060000
'16' | 72898.2104400001
'10' | 74349.6323099999
'4' | 79401.0094369999
'3' | 79548.9225100000
'9' | 81482.3202860000
'17' | 81919.6333060000
'21' | 84152.1919300001
'5' | 94632.0541760001
'2' | 97348.0287400000
'19' | 98052.0752699999
'1' | 98857.5822580000
'20' | 103075.9427190000
'13' | 107063.1676270000
'6' | 117246.0886320001
'24' | 125250.9072691001
'7' | 180141.0768700002
'22' | 232717.8053270000
22 Export of cubes of static and dynamic properties of the model
22
1. Maps. Initial Maps, map Porosity
2. Right mouse click on Map. Export
3. Save 3D. Porosity values will be saved at each grid blocks
4. File name is generated automatically
5. File will be saved to the folder with model data-file. Extension .map
6. Press Export in the dialogue
23 Export: 3D and 2D maps
23
tNavigator provides the following possibilities of Map Export - (Full description in the
tNavUserManual). Section: Data files. Loadable file formats. Maps. Export:
• Aquifer, binary files .grd, active blocks, different types of 2D map export (.grd, .xyz, .cps)
24 Export of cubes of initial dynamic properties of the model
24
2
1. Model ModelWithHistory/m95.data
2. Save map of remaining saturation of water (last time step): Maps, Calculated maps, Saturation
of Water. Export - file m95_Saturation of Water_end.map
3. Move time slider to zero time step!
4. Save map of initial saturation of water: Maps, Calculated maps, Saturation of Water. Export -
file m95_Saturation of Water_initial.map
25 Creation of User maps
25
2
1. Maps. User Maps. Map
2. Right mouse click on Map, choose Duplicate – new user map Map1 is created
3. Create Map2 the same way
26 Load properties from files
26
2
1. Right mouse click on Map, Load
2. Load file m95_ Saturation of Water_initial.map
3. Right mouse click on Map1, Load
4. Load file m95_ Saturation of Water_end.map
27 Properties calculator
27
1. Left mouse click on Map2
2. In Map Arithmetic Command Line: map – map1 (map difference). Apply
3. We obtain the distribution of the extracted water
28 Properties calculator
28
1. In Map Arithmetic Command Line: (map – map1)/map
2. Apply
3. We obtain the relative distribution of the extracted water
29 Load boundaries of FIP regions (sectors) from file
29
1. In many cases, the boundaries of FIP region (sectors) already exist
2. They can be loaded as text file, where the vertices of an arbitrary polygon are given in
meters
3. An example of region boundaries is given in the file: m95_FIPREGIONS.txt
1 REGION1 0 0
1 REGION1 1600 0
1 REGION1 1600 1600
1 REGION1 1000 2000
1 REGION1 0 1600
2 REGION2 1600 0
2 REGION2 3200 0
2 REGION2 2600 2000
2 REGION2 1600 1600
3 REGION3 3200 0
3 REGION3 4000 0
3 REGION3 4000 4000
3 REGION3 2600 4000
4 REGION4 0 1600
4 REGION4 1000 2000
4 REGION4 1000 4000
4 REGION4 0 4600
m95_FIPREGIONS.txt
30 Load boundaries of FIP regions (sectors) from file
30
1. Maps. User Cuts, Cut
2. Right mouse click. Load FIP Boundary.
3. Load file m95_FIPREGIONS.txt
4. This Cut can be used to split model (see the course HowToSplitAndMergeModel), choose
wells for Well Filter etc.
Thank you!
31