Snippet is a block of cells with function name, its arguments, cells for input values, formula with referenced inputs and descriptions. It’s quick and easy way to start using any function!
Right click on any cell in your spreadsheet and in context menu find “Insert Snippet”, choose required function, click on the name and you’ve inserted a snippet.
Unit conversion in Petroleum Office is based on UnitConverter() Excel function which is part on add-in function library. Popular categories of units can be found on ribbon, select cell, choose units and you have your answer. All units button will show the full list of 1500+ registered units. Search and copy required abbreviation.
If you work with text input files for popular simulators, you can save a lot of time, when creating different scenarios for sensitivity or history matching projects.
Create a template input file with tokens, fill the table with case names and its parameters. Then use File Generator tool within Toolbox button on the ribbon and it will create case files where each token is substituted by appropriate value from the table. Chances are that you keep the summary of your simulation runs in Excel anyway.
This tool allows you to read and load output files from ECLIPSE reservoir simulator directly to Excel.
Click on Toolbox button and choose Import Eclipse Results…. 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 and contain all data vector results in columns.
Instead of creating a stand-alone petroleum engineering application, we decided to build upon the
strengths of Excel and make it better tool for petroleum engineering calculation. Here’s how and why.