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.

A diagram of a surface gathering system, drawn from a table. Wells with wellhead pictures, chokes, a manifold, production and test separators and the outlets they feed (gas to the compressor, oil export, water disposal) are joined by flowline connectors glued to the shapes, so dragging a shape in Excel keeps its lines attached. The Network sheet is the table the drawing was generated from — a row for every piece of equipment and every connector — so the diagram cannot show a link the table does not hold.

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.

A log display for one vertical well. Paste SP, gamma-ray and shallow, medium and deep resistivity onto the Log Data sheet — any sampling interval, depth increasing downward — and the Well Log sheet draws them as tracks against depth: SP as bars either side of a shale baseline, GR as bars coloured by a five-band palette, a lithology column from the same palette, resistivity on a logarithmic scale with decade lines, and a computed shale-volume track from the gamma-ray index. The tracks are charts over a grid of cells that supplies the depth lines and labels, and the sheet prints on one page. No add-in is needed.

A completion schematic for a vertical well that redraws itself. Enter the casing program (OD, top, shoe and top of cement for the conductor, surface casing, intermediate casing and production liner) and the completion (tubing, safety valve, gas-lift mandrels, packer, two perforated intervals, PBTD and TD) on the Inputs sheet; the Schematic sheet paints the wellbore against depth and labels each component. Move a packer, a shoe, a perforation or a liner top and the drawing and its labels move with it.

The economics of a small Texas horizontal program (5–10 wells), modelled month by month, with one scenario per row of an Excel Table. Each row carries its assumptions — prices, D&C, LOE, type-curve factor, well count, working and net revenue interest, discount rate — and, in the same row, its NPV, IRR, payout, PV/I, EUR per well and net cash. Change a row or add one at the bottom and its results fill in. The default assumptions are illustrative, not a price deck.

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.