In this article, I have explained two different ways of importing the X, Y, Z Coordinates (Easting, Northing & Reduced Levels) from an Excel sheet to AutoCAD in the form of points. In the first method, we will use only excel to compile data and then we will simply import the data in AutoCAD. Excel does not really have XYZ scatter charts. See for alternatives. Now let's see how to create a bell curve in Excel. Creating a Bell Curve in Excel. Let's take an example of a class of students that have been scored in an exam. The mean score of the class is 65 and the standard deviation is 10. (You can calculate the mean using the AVERAGE function in Excel and Standard Deviation using the STDEV.P function).
- 4Workflow
Brief
The P/Z plot is a plot of P/z versus Reservoir cumulative gas production, Gp. Qt signals and slots tutorial.
The interpretation technique is fitting the data points with the straight line to estimate GIIP.
The P/Z plot is based on the Gas Material Balance equation.
Math & Physics
Applying Real GasEOS at reservoir conditions:
- (1)
Applying Real GasEOS at standard conditions:
- (2)
Dividing eq. 2 by eq. 1 and rearranging:
- (3)
Applying eq. 3 for initial conditions and for any point in time:
Applying eq. 3 for any point in time:
Therefore at any time:
Or:
(3 Pack) COMPUMATIC Compatible/Replacement Calculator Ink Roller, Black/Red IR-40T, for Casio HR-100TM Casio HR-150TM and More 4.6 out of 5 stars 966 $6.98. Staples.com: Casio HR-8TMPlus Printing Calculator with fast and free shipping on select orders. Casio calculator hr 8tm. High quality genuine casio ink roller for longer life. Compatible with all Casio printing calculator: 140 CR-SB, FR-510, HR-8L, HR-8TE, HR-8TM, HR-8TMGY, HR-150LB. CASIO Handheld Printing Calculator HR-8TM This portable mini-printing calculator is perfect for all your 'on the go' accounting needs. HR-8TM-PLUS cost/sell/margin keys: Yes print technology: Calculator quantity: 1 brand name: Casio dimensions: 1-1/2 in. Manufacturer: CASIO AMERICA, INC.
Thus a plot of P/z vs cumulative produced gas is a straight line intersecting X axis at GIIP.
Applying eq. 3 for any point in time:
Therefore at any time:
Or:
(3 Pack) COMPUMATIC Compatible/Replacement Calculator Ink Roller, Black/Red IR-40T, for Casio HR-100TM Casio HR-150TM and More 4.6 out of 5 stars 966 $6.98. Staples.com: Casio HR-8TMPlus Printing Calculator with fast and free shipping on select orders. Casio calculator hr 8tm. High quality genuine casio ink roller for longer life. Compatible with all Casio printing calculator: 140 CR-SB, FR-510, HR-8L, HR-8TE, HR-8TM, HR-8TMGY, HR-150LB. CASIO Handheld Printing Calculator HR-8TM This portable mini-printing calculator is perfect for all your 'on the go' accounting needs. HR-8TM-PLUS cost/sell/margin keys: Yes print technology: Calculator quantity: 1 brand name: Casio dimensions: 1-1/2 in. Manufacturer: CASIO AMERICA, INC.
Thus a plot of P/z vs cumulative produced gas is a straight line intersecting X axis at GIIP.
Discussion
P/Z plot is a part of the Reservoir Management workflow in the E&P Portal used to estimate Reservoirs GIIP and recovery.
Example 1. Multiple Reservoirs on the same P/Z plot in the E&P Portal
Z Charts In Excel
Gas Flowing Material Balance is the more advanced tool to determine the Reservoirs GIIP and recovery as well as Well's EUR and JD.
Workflow
- Upload the data required
- Go to the Reservoir Management -> Performance Plots
- Select the Reservoirs you want to see and the Data range and click 'Search'
- Scroll down the Performance Plots to see the P/Z plot
Data Required
- Create Fieldhere
- Upload Monthly Measureshere
- Create or Upload Reservoirshere
- Input the Reservoirs GIIP here
- Create or Upload PVT (SG, Pi, Ti) here
Plot Z Score In Excel
In case you need to calculate the Monthly Measures from the Daily Measures:
- Calculate the Monthly Measures using Monthly Measures Calculator
See also
Gas Flowing Material Balance
Gas Material Balance
Nomenclature
- = gas initially in place, scf
- = cumulative gas produced, scf
- = reservoir pressure (changing), psia
- = initial reservoir pressure (constant), psia
- = pressure at standard conditions, psia
- = initial reservoir temperature (constant), °R
- = reservoir temperature (constant), °R
- = temperature at standard conditions (constant), °R
- = volume of gas in reservoir converted to standard conditions (changing), scf
- = reservoir volume (constant), ft3
- = gas compressibility factor (changing), dimensionless
- = initial gas compressibility factor (constant), dimensionless
