Schedule section - using Well_scheduler_light.xlsm
Well_scheduler_light.xlsm is my own developed programm using VBA in excell
It is quite simple and allows user easily build schedule section( for history section) using minimum data comparing to Schedule eclipse
the supported keywords in light version are
GRUPTREE
DATES
WELSPECS
COMPDAT
WPIMULT
WCONHIST
WEFAC
Known limitations
1. Metric system only
Before you can use the programme
DO NOT CHANGE NAME OF FILE Or Sheets NAMES OTHERWISE IT WILL NOT WORK !!!!!!!!!!!!!!!!!
1. you should set you system environment to following
go to control pannel on you windows system and choose regional and language options
double click and choose exactly the same as shown in pictures below
Now go to Excell and enable all macros
It is in Russian but you can google the web and find "How enable macros in worksheet"
So now you ready to Schedule
Open program you will find following sheets
Description of each sheet below
Sheet MACRO
Here you will find all main input for building you section
All not needed cells are protected in order macro work correctly
1.Settings
Null - null value which used by Petrel when uploading trj sect
THP - value for calculating maximum delta P
Pressure a and Pressure b are pressure gradient coefficient
Well max connections - maximum connections per well
Simulation start and stop dates
Grupe tree up to 20 supported
Order in which you will upload properties in trj file
Path to trj file
name of history section
Comments in sch file
So lets open test project G_model
Sort properties in the way as shown in sheet
Now lets export trj file with the properties shown above
Press ok
now lets return to Spreadsheet Sheet EV
Amust data to fill
In evtype only perforation and plug supported
No once we finish all to go to MACRO sheet and put path to exported trj file
And press
After macro will finish it run you will be return to DEBUG sheet were you can find all uniqe well with perforation available
Go to CMD sheet
Here you can find detail report on each connection of you well
If you will press You get well potential ( the things we discuss in Chapter 7)
On sheet NGC (No grid connections) detail result on all cells which penetrated by well trace bud has no connection to well
Now let go to vol section
this a amust input data there
Once you fill all data press
Macro will create schedule section in the directory where excel file located
Analyze use enjoy
link to chapter [link Point to another website Only the registered members can access]
Link to file [link Point to another website Only the registered members can access]
Bookmarks