Back to Excel templates

Nodal Analysis Workbook: IPR/VLP Intersection, Operating Point & Sensitivity

Screening-grade production nodal analysis: composite PI/Vogel IPR, a no-slip VLP computed down the tubing, a solved operating point, and live WHP and tubing ID sensitivity. Not well test transient analysis.

reservoir engineeringintermediateFeatured

TAGLINE

Screening-grade production nodal analysis: composite PI/Vogel IPR, a no-slip VLP computed down the tubing, a solved operating point, and live WHP and tubing ID sensitivity. Not well test transient analysis.

WHO IT'S FOR

Production engineers optimizing well deliverability and tubing design for flowing wells.

WHAT IT DOES

Builds a composite IPR (straight-line PI above the bubble point, Vogel below) and computes the VLP from a homogeneous no-slip multiphase gradient integrated down the tubing (Standing Rs and Bo, Papay z, Swamee-Jain friction). The operating point is solved from the IPR and VLP curves, not typed. A sensitivity grid solves its own operating point for each of 12 WHP and tubing ID cases. The VLP is screening grade: no-slip, vertical well, acceleration neglected; it is best at high mixture velocity and under-predicts bottom-hole pressure at low rates and in slug flow. These limitations are stated on the Assumptions tab.

TABS INCLUDED (9)

• Instructions & Legend • Assumptions — Pr, PI, bubble point, tubing ID and length, WHP, GOR, water cut, fluid gravities, temperatures, viscosities, roughness; method limitations • IPR Curve — composite PI/Vogel inflow, with an all-Vogel comparison • VLP Curve — required bottom-hole pressure vs rate from the gradient model • Nodal Plot — IPR and VLP with the solved operating point • Nodal Crossplot — rate vs flowing pressure, IPR and VLP • Operating Point — solved rate and flowing pressure • Sensitivity — operating rate for 4 WHPs × 3 tubing IDs, with chart • Summary — operating rate, Pwf, drawdown, oil rate, AOF, GLR

KEY FORMULAS

IPR: q = J(Pr − Pwf) above Pb; Vogel below Pb with qmax = qb + J·Pb/1.8; VLP: dp/dz = [ρns + f·G²/(2gc·D·ρns)]/144 integrated in 20 segments; operating point where IPR = VLP

TECHNICAL SPECS

• Excel 2016+; 22,000+ formulas (most in the live sensitivity grid); all curves computed, no typed curve data • MDT professional color scheme throughout • Yellow cells = inputs; white cells = formulas

ABOUT RESERVOIR RISK SOLUTIONS

Built by petroleum engineers for petroleum engineers. All workbooks require only Microsoft Excel (2016+) — no plugins, no subscriptions. www.reservoir-risk-solutions.com

nodal analysisIPRVLPVogelproduction engineering

What you get

  • Instant workbook access after payment in your Excel Library
  • Formula-driven worksheet designed for petroleum workflows
  • No recurring fees and no plugin requirements

Licence

Single-user licence: the purchaser may use and modify this workbook for their own work, including work for their employer and clients. It may not be resold, shared publicly or redistributed as a template. Results are engineering estimates for screening and must be checked by a qualified professional before they are relied on.

FAQ

Is this a one-time purchase?

Yes. Each workbook is sold as a one-time purchase with no recurring subscription.

How do I access purchased files?

After checkout, your file appears in Excel Library under your account for download.

Do these templates require macros or plugins?

No. Templates are designed for Excel 2016+ and do not require VBA macros or external add-ins.

Nodal Analysis Workbook: IPR/VLP Intersection, Operating Point & Sensitivity
$79 + tax, where applicable · one-timeOpen Excel Library