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]