Excel Blueprints for Petroleum Engineering
Ready-to-use calculation templates you can insert directly into your Excel spreadsheets.
120 blueprints
Decline Curve Analysis
Classic and unconventional decline models, decline diagnostics, rate conversions and field production profiles.
12 blueprintsMaterial Balance
Havlena-Odeh straight lines, p/z gas depletion and water influx from aquifer models.
11 blueprintsPressure Transient Analysis
Transient wellbore pressure solutions, dimensionless variables and well test interpretation.
11 blueprintsInflow Performance
Inflow rates, productivity index and drainage geometry for vertical, horizontal and gas wells.
9 blueprintsVertical Flow Performance
Single-phase and multiphase pressure traverse in tubing — empirical correlations and mechanistic models.
8 blueprintsArtificial Lift
Electric submersible pumps, gas lift and rod pumping.
17 blueprintsDrilling Engineering
Well control, circulating hydraulics, hole cleaning and directional surveys, as self-contained worksheets.
5 blueprintsHydraulic Fracturing
Fracture geometry models, fluid leakoff and proppant transport.
3 blueprintsSurface Facilities
Choke performance and gas and liquid pipeline hydraulics.
4 blueprintsFlow Assurance
Hydrate prevention, corrosion prediction and erosional velocity limits.
4 blueprintsBlack-Oil PVT
Black-oil correlations for oil, gas and water properties.
12 blueprintsEquation of State
Cubic equation-of-state models — component data, flash, volumetric properties and phase behavior.
8 blueprintsRock Properties
Relative permeability, capillary pressure and rock compressibility from special core analysis.
12 blueprintsMath & Utilities
Interpolation, unit conversion and general-purpose numeric helpers.
4 blueprints