Product Guides

Step-by-step guide to installing Petroleum Office, exploring the ribbon, and using your first Excel function for petroleum engineering calculations.

Guide to understanding the dot-separated naming convention used by Petroleum Office Excel functions, including categories, properties, qualifiers, and author names.

Tutorial on using Petroleum Office functions that return multiple values using Excel's dynamic array (spill range) feature.

Guide to browsing, inserting, and using blueprints — reusable Excel worksheet templates with pre-built petroleum engineering calculations.

Complete guide to using Petroleum Office unit converter for converting between 1500+ petroleum engineering units including pressure, temperature, volume, and flow rates.

Tutorial on importing Eclipse reservoir simulator output files into Excel using Petroleum Office toolbox for analysis and visualization.

Step-by-step guide to using the Petroleum Office Case Generator tool to batch-create simulation input files from Excel templates with token replacement.

Learn how to call Petroleum Office functions from VBA macros in Excel with code examples and best practices for automation.

Tutorial on importing LAS well log files (v2.0 and v3.0) into Excel using Petroleum Office for petrophysical analysis and visualization.

Solutions for common Excel errors when using Petroleum Office functions, including #NAME?, #VALUE!, #NUM!, #N/A, and #SPILL! errors.

Reference for upgrading Excel workbooks from Petroleum Office v1.8 to v2.0. Maps all 213 old UDFs to their new dotted-namespace equivalents and flags parameter reorders and unit changes that silently affect results.