Creating Stacked Production Reports

You can generate production data in AccuX then paste this information into Microsoft Excel to create a stacked production chart.

Rows in the spreadsheet correspond to the chart's x axis. Columns in the spreadsheet correspond to the chart's series.

For example, in the adjacent  graphic in row 1996, the value 560.3 in column 1982 corresponds to wells that began producing in 1982, were still in production in 1996, and generated a total of 560.3 barrels of oil in 1996.

You can create stacked production reports either from the map or explorer view from the left pane.

To create stacked production reports

1. You can create a stacked production report for one of the following:

From Map View

From Explorer View

To generate a production report from the map for the entire area, right-click the map and from the shortcut menu, select merged data for entire map > stacked daily oil or stacked daily gas.
Or

To generate a production report from the map for a specific area, draw a polygon around the wells for which you want to generate a stacked production report, then right-click the polygon and select either stacked daily oil for polygon or stacked daily gas for polygon.
 

To generate a production report from the explorer view, click United Data > UniPools > stacked daily oil or stacked daily gas.

 

The Search Criteria for Stacked Daily Report dialog box appears.

2. Configure your settings and click OK
OR

Click use pool list to select pools from the Pool selection dialog box.

The Pool Selection dialog box appears.

 Select one or several pool(s) to work with then click OK.

After you click OK in the Search Criteria for Daily Report dialog box, the production report appears in the right pane in tabular format.

3. In the right pane, right-click and from the shortcut menu, choose Select all and then click Copy.  

4. Launch Microsoft Excel and from the Excel Edit menu, select Paste.

The production report appears in Excel.

5. In Excel, drag to select all of the production report except the final column (Prod Wells), then click the chart button ().

6. In the Chart type area of the Chart Wizard dialog box, select Area and then click Next.

7. In the Chart Wizard dialog box, select Columns then click Finish.

Related Topics

 Drawing Polygons

 Adding Production Data from Local Files