https://sites.google.com/site/francopetroleumworkbooks/
Estimating OGIP and Reserves with Crystal Ball [optimizing extraction of results with VBA]
Content
Introduction Sheets description
Web: https://sites.google.com/site/francopetroleumworkbooks
Introduction This workbook can be used to estimate OGIP and Reserves applying the volumetric method. The workbook can estimate OGIP and Reserves using Crystal Ball Code in the workbook can: Initialize CB runs Extract percentiles [P90 P50 and P10] Extract CB charts
The workbook contains a section [sheets] to estimate Bg from gas composition.
Web: https://sites.google.com/site/francopetroleumworkbooks
Sheets Description The workbook contains the following sheets: Input Data (Volumetric) Volumetric_OGIP_Reserves Sensitivity-Scatter OGIP Assumptions Fluid_Data Calc Solution_Tables Plots Properties Web: https://sites.google.com/site/francopetroleumworkbooks
Sheets Description Sheet name: Input Data (Volumetric)
Show sheets to estimate Bg
Hide sheets to estimate Bg
Input data for volumetric estimation. Green cells will be used by Crystal Ball [Assumptions]. If you want to add a variable to CB runs just set the cell as Assumption with CB tools.
Web: https://sites.google.com/site/francopetroleumworkbooks
Sheets Description Sheet name: Input Data (Volumetric)
Define Assumption on CB
Web: https://sites.google.com/site/francopetroleumworkbooks
Sheets Description Sheet name: Volumetric_OGIP_Reserves
Summary of Assumption Percentiles Cells are linked to sheet “Input Data (Volumetric)�
Web: https://sites.google.com/site/francopetroleumworkbooks
Sheets Description Sheet name: Volumetric_OGIP_Reserves
Number of CB runs. When button [VBA] is used to Start CB runs, CB will calculate this number of trials.
Web: https://sites.google.com/site/francopetroleumworkbooks
Sheets Description Sheet name: Volumetric_OGIP_Reserves
Button to start CB runs. After CB finished results will be extracted from CB to MS Excel. If CB runs are started from normal CB button, Results will be not extracted,
Web: https://sites.google.com/site/francopetroleumworkbooks
Sheets Description Sheet name: Volumetric_OGIP_Reserves
Cells with equations to calculate OGIP and Reserves using the volumetric method. Cells are linked to CB Assumptions, thereby, cells will change for each CB trial.
Web: https://sites.google.com/site/francopetroleumworkbooks
Sheets Description Sheet name: Volumetric_OGIP_Reserves
CB trials output
Web: https://sites.google.com/site/francopetroleumworkbooks
Sheets Description Sheet name: Volumetric_OGIP_Reserves
Percentiles results. Percentiles are extracted from CB after trials are finished.
Web: https://sites.google.com/site/francopetroleumworkbooks
Sheets Description Sheet name: Volumetric_OGIP_Reserves
Just an exercise of how much should be the “Merma� to have the gas reserve calculated by CB.
Web: https://sites.google.com/site/francopetroleumworkbooks
Sheets Description Sheet name: Volumetric_OGIP_Reserves
CB charts CB charts are updated after trials are finished. Charts are updated only when CB run starts using the button.
Web: https://sites.google.com/site/francopetroleumworkbooks
Sheets Description Sheet name: Sensitivity-Scatter
In this sheet the sensitivity and Correlation charts are extracted from CB.
Web: https://sites.google.com/site/francopetroleumworkbooks
Sheets Description Sheet name: OGIP Assumptions
In this sheet the Assumption charts are extracted from CB.
Web: https://sites.google.com/site/francopetroleumworkbooks
Sheets Description Sheet name: Fluid_Data
Input Data: Gas composition
Web: https://sites.google.com/site/francopetroleumworkbooks
Sheets Description Sheet name: Fluid_Data
Input Data: Pressure and temperature at reservoir conditions.
Web: https://sites.google.com/site/francopetroleumworkbooks
Sheets Description Sheet name: Fluid_Data
Results at reservoir conditions
Web: https://sites.google.com/site/francopetroleumworkbooks
Sheets Description Sheet name: Fluid_Data
Input data: ranges of pressure and temperature to generate curves. There can be a range of pressures and No of steps can be changes for pressure ONLY.
Web: https://sites.google.com/site/francopetroleumworkbooks
Sheets Description Sheet name: Calc
This sheet is used to calculate gas properties. 1.- Pseudo-pressure and pseudo-temperature are calculated 2.- Adjusted pseudo properties are calculated using Wichert & Aziz Correlation Adjustment for Nonhydrocarbon components. 3.- pseudo-reduced properties are calculated. 4.- Factor-z, viscosity, gas density and Bg are calculated.
Web: https://sites.google.com/site/francopetroleumworkbooks
Sheets Description Sheet name: Solution_Tables
This sheet has the results for every step in table generated in sheet “Fluid_Data�. Also, there are charts for the gas properties.
Web: https://sites.google.com/site/francopetroleumworkbooks
Sheets Description Sheet name: Plots
This sheet has the charts for the gas properties.
Web: https://sites.google.com/site/francopetroleumworkbooks
Sheets Description Sheet name: Properties
This sheet has the properties for gas components.
Web: https://sites.google.com/site/francopetroleumworkbooks