This Excel-based tool streamlines the evaluation of oil well performance by automatically generating Inflow Performance Relationship (IPR) and Vertical Lift Performance (VLP) curves.
It offers petroleum engineers, production analysts, and students a fast, transparent, and user-friendly way to analyze and optimize well productivity.
🔑 Key Features
1. IPR Calculation
- Supports both Darcy’s Law for undersaturated reservoirs and the Productivity Index (PI) Model for quick assessments.
- Provides reliable estimates of reservoir inflow behavior using user-defined reservoir and fluid parameters.
2. VLP Calculation
- Employs the Beggs & Brill correlation for multiphase vertical flow.
- Incorporates fluid properties, tubing geometry, and flow rates to calculate flowing bottomhole pressure at different production rates.
3. Monte Carlo Simulation for PI & IPR
- Integrates Monte Carlo simulation to quantify uncertainty in well performance.
- Generates probabilistic IPR curves for P10 (optimistic), P50 (most likely), and P90 (conservative) cases.
- Runs hundreds or thousands of randomized simulations over user-defined input ranges.
- Automatically extracts key outcomes to support risk-based production forecasting.
4. Fully Automated Workflow
- Organized input fields and structured calculations.
- Instant generation of IPR and VLP curves.
- Automatically determines the operating point (intersection of IPR and VLP).
5. User-Friendly Interface
- 100% Excel-based — no coding required.
- Simple, intuitive inputs and clear graphical outputs.
- Easily customizable for various well conditions and operating scenarios.
