Product Guides - Petroleum Office Documentation

System Requirements & Prerequisites

What you need to install Petroleum Office — supported Excel versions, the .NET 10 Desktop Runtime, how to check your Excel bitness, and where to download the matching runtime for 32-bit or 64-bit Excel.

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.

Licensing and Your Account

How Petroleum Office licensing works — signing in, checking your licence status in the Settings dialog, and what each status message means when functions stop working.

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.

Using Blueprints in Petroleum Office

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

Using Lambdas in Petroleum Office

Guide to the Petroleum Office LAMBDA catalog — SI-unit wrappers around the add-in functions, browsed in the Lambda Manager and added to your workbook as named formulas.

How To Use Case Generation

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

Import Eclipse Result Files In Excel

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

Import LAS Files In Excel

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

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.

Connect to the Petroleum Office MCP Server

Setup instructions for connecting AI assistants (Claude for Excel, Claude.ai, Grok) to the Petroleum Office MCP server.

Settings and Updates

Guide to the Petroleum Office Settings dialog — the Licensing, Content, Add-in, About and Product Feedback panels, checking your installed version, and refreshing catalog content.

Uninstalling Petroleum Office

How to remove Petroleum Office from Windows, what happens to workbooks that used its functions, and how to reinstall or move to another machine.

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.

Migrating Functions from v1.8 to v2.0

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.

Looking for Theory?

Check out our technical documentation covering petroleum engineering equations and correlations.

View Theory & Background