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.