This sheet can be used to perform a complete well model (IPR) for hydraulically fractured oil reservoirs. It can be used to predict the production rate increase after a hydraulic fracture treatment. The sheet also provides:

1.      Productivity index (PI) calculations before frac.
2.      PI calculation post-fracturing.
3.      Dimensionless fracture conductivity (CFD).
4.      Negative skin due to Frac.
5.      The fold of increase (FOI) in the production rate after stimulation.
6.      IPR construction before & after Frac.

Also, it allows for sensitivity analysis on hydraulic fracture half-length, fracture width, proppant, and reservoir permeability which can be helpful to choose the optimum treatment volume and the economic job size.