Excel Blueprints for Petroleum Engineering
Ready-to-use calculation templates you can insert directly into your Excel spreadsheets.
90 blueprints
Arps Decline Forecast
Decline curve analysis using the Arps hyperbolic decline equation. Calculates rate and cumulative production over time for production forecasting.
Binary Interaction Parameters
Estimates binary interaction parameters using available correlations:
Boundary Effects Analysis
Analysis of boundary effects on wellbore pressure. Compares infinite acting reservoir with single linear fault and perpendicular sealing faults.
Bubble & Dew Point
Calculates bubble point and dew point (pressure and temperature) for a ternary hydrocarbon mixture using Peng-Robinson EoS.
Bubble Point Correlation Comparison
Compare bubble point pressure correlations from different sources and regions. Each correlation was developed for specific oil types and geographic regions, showing significant variation in predictions.
Bubble Point Estimation
Estimate bubble point pressure using different correlations. Compare Standing and Vasquez-Beggs methods side by side.
Capillary Pressure Models Comparison
Compare capillary pressure curves using Brooks-Corey and Van Genuchten models. Includes Leverett J-function for scaling between different rock types.
Choke Sizing Comparison
Compare choke diameter sizing using different critical flow correlations (Gilbert, Ros, Baxendell, Achong, Pilehvari).
CO2 Corrosion Analysis
CO2 corrosion analysis using the de Waard-Milliams correlation. Calculates corrosion rate, severity classification, inhibited rate, and required corrosion allowance for carbon steel pipelines.
Complete Oil PVT Table
Complete oil PVT property table from undersaturated through saturated conditions. Includes bubble point, solution GOR, oil FVF, oil compressibility, and oil viscosity across the full pressure range.
Component Database
Browse all available components and their thermodynamic properties.
Constant Pressure Boundary
Analysis of constant pressure boundary effects. Compares sealing boundaries with constant pressure boundaries (aquifer support).
Corey Relative Permeability Curves
Generate oil-water relative permeability curves using the Corey power-law model. This simple model requires only endpoint values and exponents, making it ideal for screening studies.
Decline Diagnostics Analysis
Diagnostic analysis for decline curve interpretation using derivative-based methods. These tools help identify flow regimes and validate decline model selection.
Decline Model Comparison
Compare multiple decline curve models for the same well. Different models may be more appropriate depending on reservoir type and flow regime. Arps is standard for conventional, Duong for unconventional transient, and PLE for tight/shale.
Decline Rate Conversions
Convert between different decline rate representations. Understanding the difference between nominal and effective decline rates, and between different time bases, is essential for consistent decline analysis.
Deviated Well VLP Analysis
Analyze vertical lift performance in deviated and inclined wells using correlations that properly account for inclination angle. Four correlations support non-vertical wells:
Dimensionless Variables Conversion
Conversion between real and dimensionless variables for pressure transient analysis. Essential for type curve matching and analytical solutions.
Duong Decline Forecast
Decline curve forecast using the Duong model, specifically designed for unconventional reservoirs exhibiting transient linear flow. The Duong model captures the power-law behavior common in tight oil and shale gas wells.
Effective Compressibility Calculations
Calculate effective compressibility for different reservoir types. Effective compressibility is critical for material balance and pressure buildup analysis.
EoS Tuning Setup
Framework for EoS tuning by comparing calculated vs. observed bubble point pressures. The property table uses editable cells for Tc, Pc, omega, and Mw, enabling manual adjustment or Solver-based regression.
Erosion Velocity Analysis
Erosion velocity analysis using API RP 14E methodology. Calculates erosional velocity limit, actual mixture velocity, erosion ratio, and risk classification for multiphase pipelines.
ESP Cable Voltage Drop Analysis
Analyze ESP cable voltage drop, power loss, and sizing requirements. Critical for ensuring adequate voltage at the downhole motor.
ESP Gas Handling Analysis
Analyze gas handling requirements for ESP systems. Calculate void fraction and evaluate need for gas separators.
ESP Motor Selection and Sizing
Select and size ESP motors based on pump requirements. Includes load factor analysis and temperature rise calculations.
ESP Pump Sizing and Selection
Calculate ESP pump sizing requirements including hydraulic horsepower, brake horsepower, number of stages, and discharge pressure.
ESP System Design - TDH Calculation
Complete ESP system design calculating Total Dynamic Head (TDH) and all head components.
EUR Calculator
Calculate Estimated Ultimate Recovery (EUR) for different economic limits and decline parameters. Essential for reserves estimation and economic analysis.
EUR Sensitivity Analysis
Sensitivity analysis of Estimated Ultimate Recovery (EUR) to Arps decline parameters. Understanding parameter uncertainty impact on EUR is critical for reserves estimation and economic analysis.
Exponential Integral Functions
Demonstrate the exponential integral (Ei) function used in pressure transient analysis and well test interpretation.
Fetkovich Aquifer Model
Calculate water influx using the Fetkovich pseudo-steady state aquifer model. This simplified approach treats the aquifer as a tank with a productivity index.
Fetkovich IPR Curve
Construct an IPR curve using the Fetkovich backpressure equation. This empirical method works for both single-phase and two-phase flow by fitting well test data to Qo = C(Pr² - Pwf²)ⁿ.
Field Production Profile
Field-level production forecasting using buildup-plateau-decline model. Models the complete production lifecycle: ramp-up to plateau, sustained plateau production, and Arps decline phase.
Flow Regime Comparison
Compare well productivity under different flow regimes: pseudosteady state (bounded reservoir), steady state (constant pressure boundary), and transient (infinite-acting). Understanding flow regime impacts is essential for accurate production forecasting.
Fluid Model Setup
Build a fluid property table combining database components, SCN (Single Carbon Number) pseudo-components, and mixture molecular weight. This is the foundational step for all EoS calculations.
Gas Lift Injection Design
Gas lift injection design calculations. Determines required gas injection rate to achieve target GLR and calculates total GLR from formation and injected gas contributions.
Gas Lift Valve Setting
Gas lift valve setting calculations. Determines dome pressure at depth, test rack opening pressure (Ptro), closing pressure, and valve spread for IPO (injection pressure operated) valves.
Gas Pipeline Flow Analysis
Calculate gas pipeline flow rates and outlet pressures using Weymouth, Panhandle A, and Panhandle B equations.
Gas PVT Properties
Complete gas PVT property table including Z-factor, gas formation volume factor (Bg), gas compressibility (Cg), gas viscosity, and gas density across pressure range.
Gas Reservoir p/z Analysis
Perform p/z analysis for gas reservoirs to estimate OGIP (Original Gas in Place). The p/z vs Gp plot is linear for volumetric depletion, with x-intercept = OGIP.
Gas Reservoir Production Forecast
Forecast gas reservoir pressure and production using material balance equations. Given OGIP, predict pressure at future production levels or vice versa.
Gas Well Deliverability
Gas well deliverability analysis comparing Darcy flow (low rate) with non-Darcy flow that includes turbulence effects at high rates. The non-Darcy coefficient D accounts for inertial resistance near the wellbore.
Gas Z-Factor Comparison
Compare gas compressibility factor (Z) calculations using different correlations. Shows DAK (Dranchuk-Abou-Kassem) and Brill-Beggs methods side by side.
Honarpour Gas-Oil Relative Permeability
Generate gas-oil relative permeability curves using Honarpour et al. (1982) empirical correlations. Separate equations for sandstone (Eq A-4, A-5) and carbonate (Eq A-9, A-10) rock types.
Horizontal Well PI Comparison
Compare horizontal well productivity index calculations using different correlations. Useful for understanding the sensitivity of PI estimates to the chosen method.
Hydrate Inhibitor Dosing
Hydrate inhibitor dosing calculations using the Hammerschmidt equation. Compares methanol and MEG for temperature depression and calculates required injection rates.
Injection Pressure Profile
Injection gas pressure profile calculations. Determines gas gradient in the annulus and calculates injection pressure at various depths for gas lift system design.
Integrated Flow Assurance Assessment
Integrated flow assurance assessment combining hydrate, corrosion, and erosion risk evaluation. Provides a comprehensive view of flow assurance challenges for production systems.
Klins-Clark Modified Vogel IPR
Construct an IPR curve using the Klins-Clark (1993) modified Vogel equation. This correlation improves on the original Vogel method by introducing a pressure-dependent exponent d that accounts for the ratio of reservoir pressure to bubble point pressure.
LET Relative Permeability Curves
Generate oil-water relative permeability curves using the LET (Lomeland-Ebeltoft-Thomas) correlation. This model offers more flexibility than Corey for matching laboratory data.
Liquid Pipeline Sizing
Design a liquid pipeline using Darcy-Weisbach pressure drop calculations. Determine required pressures, flow capacity, and verify velocity limits.
Material Balance Expansion Terms
Calculate material balance expansion terms for oil reservoir analysis. These terms quantify fluid and rock expansion as pressure drops during production.
Modified Hyperbolic Decline
Modified Hyperbolic decline model that transitions from hyperbolic to exponential decline at a specified terminal decline rate. This addresses the unrealistic EUR predictions from pure hyperbolic decline with high b-factors.
Multi-Well Schedule Aggregation
Aggregated field production from a multi-well drilling schedule. Uses convolution of a typical well decline profile with a well drilling schedule to forecast total field production over time.
Multiphase Correlation Comparison
Compare pressure drop predictions from all ten industry-standard multiphase flow correlations. Understanding correlation differences helps engineers select the most appropriate method for specific well conditions.
Oil PVT Table - Standing
Complete PVT properties table using the Standing correlation. Calculates oil formation volume factor (Bo) and solution gas-oil ratio (Rs) for a range of pressures.
Oil Viscosity Correlation Comparison
Compare oil viscosity calculations showing the progression from dead oil through saturated conditions. Dead oil viscosity depends only on temperature and API gravity, while saturated oil viscosity also depends on solution GOR.
Oil Viscosity Table
Calculate oil viscosity using Egbogah (dead oil) and Beggs-Robinson (saturated) correlations.
Phase Envelope
Generates a phase envelope (P-T diagram boundaries) for a natural gas mixture using Peng-Robinson EoS. Returns:
Pipe Schedule 40
Standard pipe dimensions for Schedule 40 carbon steel pipe per ASME B36.10M. Commonly used for oilfield piping and process equipment.
PKN Fracture Geometry Analysis
Calculate PKN (Perkins-Kern-Nordgren) fracture geometry for vertically confined fractures.
Polished Rod Load Analysis
Polished rod load analysis using simplified static method. Calculates fluid load, peak and minimum polished rod loads for rod pump design.
Productivity Index Calculation
Calculate well productivity index (PI) and understand the impact of skin damage. Also shows drainage radius and effective wellbore radius calculations.
Proppant Settling Analysis
Analyze proppant settling behavior for hydraulic fracturing treatment design.
PT Flash Calculation
Performs rigorous PT flash calculation for a ternary mixture (ethane, propane, n-pentane) using the property-array workflow:
Pumping Unit Torque Analysis
Pumping unit torque analysis. Calculates counterbalance requirements, peak torque, and polished rod horsepower for rod pump systems.
PVT Metric Suite
Oil and gas PVT calculation functions with metric/SI unit inputs. These lambdas wrap Petroleum Office PVT functions with metric unit conversions built-in.
Radial Flow Analysis
Infinite acting radial flow analysis using line source solution and vertical well models. Calculates dimensionless pressure for pressure transient interpretation.
Relative Permeability Model Comparison
Compare relative permeability predictions from Corey, LET, and Honarpour correlations. Model selection affects waterflood performance predictions.
Reservoir Drive Mechanism Indices
Calculate drive mechanism indices to identify the dominant energy source driving oil production. Drive indices sum to 1.0 and indicate relative contribution of each mechanism.
Reservoir Fluid Library
Common reservoir fluid property ranges for quick reference and estimation. Useful for initial fluid characterization and sanity checks.
Rock Compressibility Estimation
Estimate rock (formation) compressibility using Newman's correlations. Rock compressibility is critical for material balance calculations and pressure transient analysis.
Rod Pump Sizing
Rod pump sizing calculations. Determines theoretical and effective pump displacement, fillage, and volumetric efficiency for sucker rod pump systems.
Rod Pump System Design
Integrated rod pump system design. Combines pump sizing, rod string analysis, load calculations, and power requirements for complete system evaluation.
Rod String Stress Analysis
Rod string stress analysis for sucker rod pumping systems. Calculates rod weight, stretch, and stress levels for fatigue assessment.
Separator Test
Demonstrates array composability by chaining Flash calculations in a two-stage separator:
Single-Phase Gas Well Pressure
Calculate pressure drop in single-phase gas wells using the compressible flow equations. Suitable for dry gas wells with no liquid loading.
Single-Phase Liquid Pipe Flow
Calculate pressure drop for single-phase liquid flow in pipes using the Fanning equation. Applicable to water injection, water disposal, and single-phase oil lines.
Skin Factor Effect
Demonstrates the effect of skin factor on wellbore pressure. Positive skin indicates damage, negative skin indicates stimulation.
Spline Interpolation and Analysis
Demonstrate spline interpolation functions for data analysis. Compare cubic and linear spline methods for interpolation, differentiation, and integration.
Stone Three-Phase Relative Permeability
Calculate three-phase oil relative permeability using Stone I and Stone II models. These models combine two-phase water-oil and gas-oil data to predict oil mobility when all three phases are present.
Tubing Size Selection Analysis
Compare pressure drops across different tubing sizes to optimize well production. Smaller tubing increases friction but maintains velocity for liquid lift; larger tubing reduces friction but may cause liquid loading in gas wells.
Underground Withdrawal Calculation
Calculate underground withdrawal (F term) for material balance analysis. F represents total reservoir voidage from oil, gas, and water production.
Unit Conversion Examples
Demonstrate unit conversion for common petroleum engineering quantities. Includes pressure, temperature, volume, and flow rate conversions.
Valve Throughput Analysis
Gas lift valve throughput calculations using the Thornhill-Craver equation. Determines gas flow rate through an orifice valve based on port size and pressure differential.
Van Everdingen-Hurst Aquifer Model
Calculate water influx using the Van Everdingen-Hurst (VEH) transient aquifer model. This rigorous method handles both infinite and finite aquifers with time-dependent pressure response.
Vertical Lift Performance - Beggs & Brill
Calculate vertical lift performance (VLP) for a producing oil well using the Beggs & Brill (1973) correlation. This correlation handles multiphase (gas-liquid) flow and is applicable for any wellbore inclination.
Vogel IPR Curve
Construct an IPR curve using the Vogel correlation for solution-gas-drive reservoirs producing below bubble point. Shows the characteristic concave-downward shape of two-phase flow.
Water/Brine PVT Properties
Water/brine PVT property table using McCain correlations. Includes water FVF, gas solubility in water, water compressibility, and water viscosity.
Wettability Effect on Relative Permeability
Compare relative permeability curves for different wettability conditions using Ibrahim-Koederitz correlations. Wettability significantly impacts waterflood efficiency.