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.
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.
Production engineers optimizing well deliverability and tubing design for flowing wells.
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.
• 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
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
• 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
Built by petroleum engineers for petroleum engineers. All workbooks require only Microsoft Excel (2016+) — no plugins, no subscriptions. www.reservoir-risk-solutions.com
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.
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.