Petroleum Office
Your Engineering Calculations, Simplified and Standardized, Right in Excel.
213 Excel Functions for Petroleum Engineering
Build powerful, readable spreadsheets with comprehensive Excel functions for oil and gas.
Decline Curves
Arps and modern decline models.
- Classic Arps decline models
- Modified hyperbolic decline
- Power‑law exponential (PLE) decline model
- Stretched exponential decline model
- Duong decline model
Well Productivity
IPR/PI across well types and flow regimes.
- Vertical wells
- Horizontal wells
- Steady/pseudo‑steady/transient flow
- Drainage geometry
- Equivalent parameters
Pipe Flow Performance
Single‑ and multi‑phase flow correlations.
- Pipe pressure drop for liquid phase
- Pipe pressure drop for gas phase
- Beggs & Brill correlation
- Hagedorn & Brown correlation
- Gray correlation
PVT Modeling
PVT property correlations for oil, gas, and water.
- Bubble point pressure
- Formation volume factor
- Solution gas‑oil ratio
- Viscosity and compressibility
- Gas Z factor
Reservoir Rock Properties
Relative permeability models and curves.
- Corey relative permeability curves
- LET relative permeability model
- Honarpour correlations
- Ibrahim–Koederitz correlations
- Rock compressibility correlations
Pressure Transient Analysis
Analytical well test models.
- Line-source solution
- Constant‑pressure and sealing‑fault boundaries
- Type curves in real space
- Type curves in dimensionless spaces
- Convert real to dimensionless variables
Productivity Tools
Beyond our Excel functions, streamline your everyday engineering workflows with powerful tools.
Unit Converter
1,500+ petroleum engineering units
- Quick conversions from the ribbon
- Custom unit expressions (e.g., bbl*psi/day)
- Scaled units (e.g., 640 acre)
- Search and copy unit abbreviations
Snippets
Ready-to-use calculation templates
- Right-click context menu access
- Pre-filled parameter cells
- Formula linked to inputs automatically
- Quick start for any function
File Generator
Batch-create input files from Excel
- Define tokens in template files
- Map cases and parameters in Excel
- Generate hundreds of scenario files
- Ideal for sensitivity analysis
Eclipse Results Import
Load simulator output directly
- Import .SMSPEC/.FSMSPEC files
- Each case becomes a worksheet
- All data vectors in columns
- Ready for analysis immediately
Who Uses Petroleum Office?
Trusted by petroleum engineers at every level - from the field to the boardroom
Engineering Managers & VPs
Former petroleum engineers now making strategic decisions in Excel
- Speed: Validate assumptions in minutes, not hours
- Transparency: Quick sanity checks for stakeholder discussions
- Risk Mitigation: Eliminate calculation drift across teams
- Standardization: Consistent methodology across all projects
Senior Engineers
Hands-on professionals building models and running daily analyses
- Productivity: 200+ functions eliminate custom VBA maintenance
- Accuracy: 1500+ unit conversions prevent costly errors
- Consistency: Industry-verified correlations and formulas
- Time Savings: Snippets and samples accelerate workflows
Consultants & Independents
Professionals delivering client-ready screening calculations and technical analyses
- Affordable: Pennies compared to traditional oil & gas software
- Professional: Commercially validated functions for client trust
- Efficiency: Standardized calculations across multiple projects
- ROI: Save 10-15 hours per client engagement
Why Petroleum Office?
Instead of creating a stand-alone petroleum engineering application, we decided to build upon the strengths of Excel and make it a better tool for petroleum engineering calculation. Here's how and why.
Ease of Use
Many say that Excel is a #1 tool for engineers. Everybody knows how to use it, hence the learning curve for the add-in is very shallow.
Simplicity
We are fans of simple calculations that allow the engineer to get a 90% answer quickly rather than a laborious effort to get a supposed 100% outcome.
Readability
You only create spreadsheet once. You read and edit it many times. Meaningful function names instead of complex formulas will keep your spreadsheets concise.
Consistency
Consistent result across all spreadsheet models. Reduce errors and eliminate typos.
Productivity
Keep all related inputs and calculations in one place. Less copying and pasting between applications.
Save time
Unit converter, file generator, snippets will save you a lot of time. Not to mention that coding VBA functions could be hard and time consuming.
How Does Petroleum Office Work?
Petroleum Office integrates seamlessly into Excel, adding a ribbon tab with 200+ petroleum engineering functions and powerful tools.
1. Download & Install
Download and start your 7-day free trial. Install in minutes.
2. Open Excel
Find the Petroleum Office ribbon tab with all functions organized by category.
3. Start Calculating
Insert functions directly into your spreadsheets or use built-in tools and samples.
Choose Your Plan
Start with a 7-day free trial
Pro
- Function Library
- 200+ Excel Functions
- Unit Converter (1500+ units)
- Engineering Tools
- 7-Day Free Trial
- Free Updates
Need licenses for your team? Check our bulk pricing options