Excel add-in for petroleum engineers
Petroleum engineering calculations, right in Excel
550+ functions and 115 ready-made calculation worksheets for decline curves, PVT, well performance, artificial lift and more — as ordinary Excel formulas you can read, check and share.
For Excel 2016, 2019 and Microsoft 365 on Windows
Functions for every discipline
Each function is documented with its parameters and units, and works like any built-in Excel function.
Decline Curve Analysis
Arps, Duong and other decline models, diagnostics and fits
Material Balance
Gas and oil material balance, drive indices, aquifer models
Pressure Transient Analysis
Transient well pressure and dimensionless solutions
Inflow Performance
Vertical, horizontal and gas well inflow
Vertical Flow Performance
Single-phase and multiphase tubing flow
Artificial Lift
ESP, gas lift and rod pump design
Hydraulic Fracturing
Fracture geometry, leakoff and proppant transport
Surface Facilities
Chokes, and gas and liquid pipelines
Flow Assurance
Hydrates, CO₂ corrosion and erosional velocity
Black-Oil PVT
Oil, gas and water properties
Equation of State
Component data, flash and phase envelopes
Rock Properties
Relative permeability, capillary pressure, compressibility
Plus math and utility functions: splines, interpolation and unit-conversion math.
Built into Excel
Worksheets and tools on the Petroleum Office tab, beside the functions.
Ready-made calculation worksheets
Insert a complete, labelled calculation at the cell you choose
Each blueprint lays out the inputs, formulas and results for one engineering task — a field production profile, a gas lift design, a fracture screening.
Preview the size and the functions it needs before anything is written to the sheet.
What lands in the workbook is ordinary Excel: edit it, copy it, extend it.
Petroleum Office MCP Server
Connect Claude, or another assistant that supports MCP, to the full function catalog and blueprint library. It answers with real Petroleum Office functions instead of guessing at formulas.
Why Petroleum Office?
Formulas that explain themselves
=PO.DCA.Arps.Rate(Qi, Di, b, time) says what it calculates. Named, documented functions replace long nested formulas and VBA that only their author can follow.
The same answer in every workbook
Everyone on the team uses the same correlations and the same units, so results agree from one model and one project to the next.
Nothing new to learn
It is Excel. The functions work like the built-in ones, and the Function Browser shows the syntax, parameters and units before you insert.
Plans
Annual, monthly, or free for students and faculty.
Annual
- ✓ Only $25/month (billed annually)
- ✓ 550+ Excel Functions
- ✓ 115 Excel Blueprints
- ✓ 2500+ Unit Conversions
- ✓ Engineering Tools
- ✓ Free Updates
Monthly
- ✓ 550+ Excel Functions
- ✓ 115 Excel Blueprints
- ✓ 2500+ Unit Conversions
- ✓ Engineering Tools
- ✓ Free Updates
Academic
- ✓ 550+ Excel Functions
- ✓ 115 Excel Blueprints
- ✓ 2500+ Unit Conversions
- ✓ Engineering Tools
- ✓ Free Updates
- ✓ No Credit Card Required
Need licenses for your team? Get a quote for bulk licensing
Trusted by petroleum engineers worldwide
Start calculating in Excel today
Download the add-in, open Excel, and everything is on the Petroleum Office tab.