Working with Functions
Find, call and combine Petroleum Office worksheet functions, including from VBA.
5 guides
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 the Function Browser
Guide to finding Petroleum Office functions with the Function Browser — the curated tree, search, inserting a function or a worked snippet, and clearing the calculation cache.
Using Array Functions in Petroleum Office
Tutorial on using Petroleum Office functions that return multiple values using Excel's dynamic array (spill range) feature.
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.
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.
Looking for Theory?
Check out our technical documentation covering petroleum engineering equations and correlations.
View Theory & Background