File Generator is under Toolbox menu button of Petroleum Office ribbon. It's pop up window has 4 range inputs.
Step 1. Right click on any cell in your spreadsheet, and in context menu find "Insert Snippet"
Step 2. From that menu choose any formula - ProdIndexHorWellJoshi for example, by clicking on it.
What you get is the small snippet inserted in spreadsheet, with formula and parameters description.
Note that the last row has formula linked to other cells.
If you do a reservoir simulation in Eclipse, you can import result data vectors directly in Excel with a couple of clicks.
Step 1. Click on Toolbox button and choose Import Eclipse Results...
Step 2. Select the cases (.SMSPEC, .FSMSPEC files) you want to import and click Open.
Each case will be imported in the current workbook as separate sheet with the name as case file, containing all data vector results in columns.
1. Check the Petroleum Office license status under Petroleum Office Tab => Settings button on ribbon => Licensing section. If license is expired of trial expired, functions from add-in would not be loaded.
2. Check if Petroleum Office is active in Excel add-in list. There must be 2 Petroleum Office add-ins - one is Excel add-in, another is COM add-in, both must be active.
If Excel Add-in is not active, try to activate in - Go... button at with Manage Excel Add-ins.
Unit conversion in Petroleum Office is based on UnitConverter() Excel function which is part on add-in function library.
=UnitConverter(Value, UnitFrom, UnitTo)
It has the following parameters:
- Value - value you need to convert
- UnitFrom - source unit abbreviation
- UnitTo - target unit abbreviation
There are 3 types of units you can use with UnitConverter().
1) Registered Units
The easiest way is to use Application.Run(...). The first argument should be the function name (unadorned by any library names), followed by the arguments to the add-in function. The Application.Run() method will convert Excel COM data types (such as Ranges, variants and arrays) to the appropriate data types before calling the add-in function. It will also convert the result into a COM Variant type.