Excel Workbooks

Multi-sheet PVT workbook demonstrating all major fluid property correlations across oil, gas, and water phases. Uses named input cells so engineers can quickly adapt to their reservoir conditions.

MBE expansion terms (Eo, Eg, Efw) for a black oil reservoir with gas cap. Named input cells for initial conditions. 9 pressure steps with PVT data and computed expansions.

Demonstrates pressure transient analysis with three boundary models: infinite reservoir, single sealing fault, and perpendicular faults (channel). Shows PD vs tD on a table with log-log diagnostic chart showing characteristic boundary signatures.

Side-by-side comparison of Corey and LET relative permeability models. Named input cells for endpoints and model parameters. 23 saturation points from Swi to 1-Sorw.

Demonstrates cubic and linear spline interpolation on a real petroleum engineering problem: interpolating Bo (oil formation volume factor) between lab measurement pressures. Shows where cubic interpolation matters most — at high-curvature regions of the PVT curve.

Complete Arps decline analysis: forecast rate and cumulative production over 20 years, calculate EUR at economic limit, and compare b-exponent sensitivity (b=0, 0.5, 1.0). Named input cells for qi, Di, b, and economic limit rate.

Side-by-side comparison of three decline models with EUR analysis. Named inputs for all model parameters. 21 time steps out to 360 months with model spread analysis.

Three-phase field production profile with formula-derived phase transitions. Named input cells for buildup time, plateau duration, plateau rate, and decline parameters. 25 time steps out to 120 months.

Demonstrates IPR curves using Fetkovich and Vogel models, then overlays a single-phase VFP (tubing performance) curve to find the well operating point. The intersection of IPR and VFP is the most fundamental production engineering calculation.

Sizes an electric submersible pump that runs inverted in a downhole water sink (DWS) or downhole water loop (DWL) completion: water drained below the oil–water contact is pumped down through an isolation packer and re-injected into the base of the same aquifer. Nothing is lifted to surface, so the system curve is drainage drawdown plus injection build-up plus a short friction path — for a hydrostatically connected aquifer, a straight line through the origin.

Single-phase liquid flow in vertical tubing with named inputs and rate sensitivity analysis. Shows friction loss, gravity head, Reynolds number, and required BHP at 14 rate points.

Static loads, stress and stretch for a sucker rod string made of up to four rod sizes. Each taper is one row, top taper first; unused rows are left blank. For each taper it returns the rod area, the weight in air and in the well fluid, the load and stress at the top of the taper and the taper's stretch. For the string it returns the static peak and minimum polished rod loads, the highest rod stress and the total stretch.

Compare three capillary pressure models with named inputs: Brooks-Corey, Van Genuchten, and Leverett J-function. 20 saturation points with J-function scaling chart.

Comprehensive unit conversion reference for petroleum engineers. Live input cells in each category update all conversions automatically. Covers pressure, temperature, volume, rate, GOR, density, viscosity, compressibility, length, area, and permeability.