Well Performance Excel Tool

This simple Excel-based tool is designed to simplify the analysis of well performance by calculating Inflow Performance Relationship (IPR) and Vertical Lift Performance (VLP) curves for oil wells. It provides petroleum engineers and production analysts with a user-friendly, automated environment for evaluating and optimizing well productivity.

Key Features:

• IPR Calculation:
• Supports both Darcy’s Law for undersaturated flow and the Productivity Index (PI) Entry Model for quick assessments.
• Accurately estimates reservoir inflow behavior based on user-defined reservoir and fluid parameters.
• VLP Calculation:
• Utilizes the widely accepted Beggs and Brill correlation to model multiphase flow in vertical.
• Incorporates fluid properties, tubing geometry, and flow rates to compute flowing bottomhole pressure at various production rates.
• Fully Automated Workflow:
• Inputs and calculations are neatly structured.
• Instant generation of IPR and VLP curves.
• Determines the operating point (intersection of IPR and VLP).
• User-Friendly Interface:
• No coding required – built entirely in Excel with intuitive input fields and clear visual outputs.
• Customizable for different well conditions and operating scenarios.

This tool is ideal for field engineers, consultants, and students who want a reliable, quick, and transparent solution for well performance analysis.