Use EXCEL and show all Equations and formulas used.

Construct IPR of a vertical well in an oil reservoir. Consider (1) transient flow at 1 month, (2) steady-state flow, and (3) pseudo-steady-state flow. The following data are given: Porosity, =0.25 Effective horizontal permeability, k=10md Pay zone thickness, h=50ft Reservoir pressure, pe or pi or p=5,000psia Bubble point pressure, pb=100 psia Fluid formation volume factor, Bo=1.2 Fluid viscosity, o=1.5cp Total compressibility, ct=0.0000125psi1 Drainage area, A=640 acres (re=2,980ft) Wellbore radius, rw=0.328ft Skin factor, S=5