Excel Functions for Petroleum Engineering
Browse and use 615 petroleum engineering functions across 15 categories.
615 functions
Decline Curve Analysis
Classic and unconventional decline models, decline diagnostics, rate conversions and field production profiles.
84 functionsMaterial Balance
Havlena-Odeh straight lines, p/z gas depletion and water influx from aquifer models.
47 functionsPressure Transient Analysis
Transient wellbore pressure solutions, dimensionless variables and well test interpretation.
23 functionsInflow Performance
Inflow rates, productivity index and drainage geometry for vertical, horizontal and gas wells.
30 functionsVertical Flow Performance
Single-phase and multiphase pressure traverse in tubing — empirical correlations and mechanistic models.
38 functionsArtificial Lift
Electric submersible pumps, gas lift and rod pumping.
106 functionsHydraulic Fracturing
Fracture geometry models, fluid leakoff and proppant transport.
37 functionsSurface Facilities
Choke performance and gas and liquid pipeline hydraulics.
45 functionsFlow Assurance
Hydrate prevention, corrosion prediction and erosional velocity limits.
22 functionsBlack-Oil PVT
Black-oil correlations for oil, gas and water properties.
60 functionsEquation of State
Cubic equation-of-state models — component data, flash, volumetric properties and phase behavior.
31 functionsRock Properties
Relative permeability, capillary pressure and rock compressibility from special core analysis.
54 functionsMath & Utilities
Interpolation, unit conversion and general-purpose numeric helpers.
15 functionsReservoir Simulation
Run a reservoir model from the worksheet in OPM Flow: a long-form Deck range goes to the engine on this computer, and its summary series (wide or long), cell properties, end state, initial state, or the deck as Flow reads it spill back. A deck is a Deck range or a .DATA file. Build the Deck range from a few input tables (spec, grid, PVT, SCAL, wells, schedule) with the DECK functions, which run in Excel and start nothing.
16 functionsPipeline and Network Simulation
Run a well, pipe or flowline in Marlim3, Petrobras's open-source multiphase flow simulator, from the worksheet: a long-form Deck range in the network dialect goes to the engine on this computer, and its summary (liquid rate, the pressure at each end, the developed friction gradient), its profiles along the pipe or its trend stations spill back in the deck's units, a row per branch for a network of branches. CHECK binds the deck in Excel and starts nothing, and says which values the binding supplies or replaces. Build the deck from a few input tables (spec, vertices, edges, terminals, properties, schedule) with the NET functions, which run in Excel and start nothing.
7 functions