Z Plot In Excel

• X Y Z Scatter Plot In Excel
• Plot Z Score In Excel
• Z Charts In Excel
• Plot Z Scores In Excel
• Plot Z Score In Excel

• 4Workflow

Excel Normal Distribution Graph (Table of Contents) Normal Distribution Graph in Excel; How to Calculate Normal Distribution in Excel? How to Make Normal Distribution Graph in Excel? Normal Distribution Graph in Excel. Normal distribution graph in excel is a continuous probability function. It is a common method to find the distribution of data. Creating Radar Charts in Excel is straightforward. In this article, we’ll show you how to create two types of Radar Chart: a regular chart (like the one above) and a filled chart (like the one below, which fills in the areas instead of just showing the outlines). Dot plot in excel, Nov 01, 2018 This Excel Line Dot Plot Chart is really helpful, Thanks. I wonder if it is possible to build in excel a chart where the radius would become the dependent variable (commonly the y axis) and the circle border would be the independent variable (commonly the x.

Brief

The P/Z plot is a plot of P/z versus Reservoir cumulative gas production, G_p.

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:

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

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

1. Upload the data required
2. Go to the Reservoir Management -> Performance Plots
3. Select the Reservoirs you want to see and the Data range and click 'Search'
4. 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

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

X Y Z Scatter Plot In Excel

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), ft³

= gas compressibility factor (changing), dimensionless

= initial gas compressibility factor (constant), dimensionless

Open the data file for this tutorial in Excel. You can download the file here in CSV format

Head to the Chart Studio Workspace and sign into your free Chart Studio account. Go to 'Import', click 'Upload a file', then choose your Excel file to upload. Your Excel file will now open in Chart Studio's grid. For more about Chart Studio's grid, see this tutorial

Select '3D Line Plot' from the MAKE A PLOT button on menu bar.

Select the columns to be used as x, y and z axes for line plot. Click on '3d line plot' to generate the chart

Plot Z Score In Excel

The chart looks like the one shown below:

Z Charts In Excel

We are going to add some style elements to the chart. Styling options are present on the left side of the plot. To set the background color, (1) Click on the 'Axis' selector on the options menu on the left side of the plot, (2) Click on the 'Lines' tab from the pop-up, (3) Set 'Background' to 'On', and (4) Select background color from the color pallete.

Axes and Grid: Go to 'Lines' tab from 'Axis' Selector. (1) Set Grid Lines to 'On' and select white color from pop-up, (2) Set Zero Lines to 'On' and select white color from pop-up

The final plot will look something like this:

Plot Z Scores In Excel

You can export the finished plot to embed in the excel notebook. We also recommend adding the Chart Studio link to the excel for easy access to the interactive version. To get the link to the chart, click on the 'Share' button. To export the chart, as an image, click on 'EXPORT' button on the toolbar.

Plot Z Score In Excel

To add the Excel file to your workbook, click where you want to insert the picture inside Excel. On the INSERT tab inside Excel, click PICTURE. Locate the Chart Studio graph image that you downloaded and then double-click it: