Product Guides
How-to guides for using Petroleum Office features and tools
9 guides
Getting Started with Petroleum Office
Step-by-step guide to installing Petroleum Office, exploring the ribbon, and using your first Excel function for petroleum engineering calculations.
Function Naming Conventions in Petroleum Office
Guide to understanding the dot-separated naming convention used by Petroleum Office Excel functions, including categories, properties, qualifiers, and author names.
Using Array Functions in Petroleum Office
Tutorial on using Petroleum Office functions that return multiple values using Excel's dynamic array (spill range) feature.
Using Blueprints in Petroleum Office
Guide to browsing, inserting, and using blueprints — reusable Excel worksheet templates with pre-built petroleum engineering calculations.
Unit Conversion in Petroleum Office
Complete guide to using Petroleum Office unit converter for converting between 1500+ petroleum engineering units including pressure, temperature, volume, and flow rates.
Import Eclipse Result Files In Excel
Tutorial on importing Eclipse reservoir simulator output files into Excel using Petroleum Office toolbox for analysis and visualization.
How To Use File Generator
Step-by-step guide to using Petroleum Office File Generator tool for batch creating files from Excel templates with token replacement.
How To Use Petroleum Office Addin Functions From VBA
Learn how to call Petroleum Office functions from VBA macros in Excel with code examples and best practices for automation.
Troubleshooting Common Errors in Petroleum Office
Solutions for common Excel errors when using Petroleum Office functions, including #NAME?, #VALUE!, #NUM!, #N/A, and #SPILL! errors.
Looking for Theory?
Check out our technical documentation covering petroleum engineering equations and correlations.
View Theory & Background