There will be times when you might wish to display values on a report or plot, or in the headers and footers of other modules.
Numeric variables can be displayed in their original format but they do not display well because all you get is the unlabeled number.
You might wish to create calculated variables to convert the outputs to text and display them better with attributes such as names, units, and multipliers. Now you will create two text display calculated variables, the first of which uses the @FmtName() system function.
1. On the Setup tab, in the Variable Managers group, click Calculated Variable Editor.
The Variable Editor window displays.
2. Click Add Calculated Variable.
3. In the text field at the top of the dialog, enter this expression.
@FmtName(CumOil, @Last(CumOil))
This system function returns a text string comprised of four parts.
• The last (current) value of cumulative oil production (based on monthly records)
• Three attributes for the CumOil variable: plot name, unit, and multiplier. These are the attributes you provided when you created the CumOil calculated variable.
4. Click OK to close the Edit Calculated Variable window.
You are returned to the Variable Editor window.
5. Name this new variable HdrCumOil.
Because this variable is used for retrieving the last value of CumOil, it will use the variable attributes of CumOil for display. Do not worry about assigning attributes for it (not even the field Width).
You will create the second text variable. This will be a slightly more expanded description of the name of the operator of
Project Variables Schlumberger
7. In the text field at the top of the dialog, enter this expression:
”Operator: “ + Sc.Operator
NOTE: Be sure to include the quotes and the space character after the colon (:); otherwise, the appended string will not be aligned properly.
This variable returns a text string comprised of the phrase Operator: together with the (dynamic) name of the operator associated with this completion, taken from the Sc table.
8. Click OK to close the Edit Calculated Variable window.
You are returned to the Variable Editor window.
9. Name this new variable HdrOperator and click OK.
Exercise 8 Displaying Text Display Variables on a Plot Header
The two new header variables are now available to use as headers on the PD Rates plot.
1. Select the PD Rates plot.
2. Select the completion HOGL1232.
3. Double-click the header at the top of the plot that displays the completion name.
The Header dialog displays.
4. Click Add.
5. Click Assist.
6. Enter HdrCumOil or select it from the list of project variables and click OK.
Schlumberger Project Variables
7. Repeat Step 4 through Step 6 and enter or select HdrOperator and click OK.
TIP: Include only one text variable per header line.
8. Click OK. Move the headers to your preferred locations.
9. Choose a completion.
Project Variables Schlumberger
10. Group all the completions.
11. Save the workspace.
TIP: When a text header shows a result of <Ambiguous>, it means that the completions included in the group do not all have the same value for that text variable.
Therefore, no single result can be displayed.
Exercise 9 Loading Additional Project Calculated Variables
You created many Calculated Variables in this training. Clearly, a working OFM project will require many more, depending on the needs of the project.
Similar to how you might work with in your own projects, the Provo East project contains many prebuilt Calculated Variables. View them through the Calculated Variable Editor as you did before and observe the flexibility with which Calculated Variables can be constructed.
Note how one Calculated Variable can include reference to another.It is important to remember that OFM does not store the results of Calculated Variables. They are evaluated in memory on-the-fly.
As a result, your project data stores do not need to absorb the results. The idea is to keep only the raw data (for example, oil, gas, and water volumes) in your databases and let OFM do all the
Schlumberger Project Variables
Calculated Variables are all fully defined in the workspace (.ofm) file. However, it is possible to reload them via text files. The full set of project Calculated Variables is available in the file
…\OFM 2012 Oil Fundamentals\E Project Variables\
Provo East.par.
1. On the Setup tab, in the Import/Export group, click Import >
Data Loader.
2. Click Clear All to clear any existing selections.
3. Navigate to the folder …\OFM 2012 Oil Fundamentals\
E Project Variables.
4. Double-click Provo East.par to enter it into the Files to Load area.
5. Click Load.
Feel free to explore the various definitions using the Calculated Variable Editor (Figure 8), with the goal of identifying where they might be relevant to your projects.
Schlumberger Project Variables
Review Questions
• What is the difference between a calculated variable and an Excel spreadsheet-style formula for calendar day rates?
• How do conditional system functions, such as @if(), improve the handling of calculated variables?
• How do text display variables improve your presentations?
Summary
In this module, you learned about:
• creating and editing calculated variables
This is what you learned about the Provo East oil field:
• Based on the comparison of the calendar day and producing day rates for the field, there is not a great deal of downtime.
However, there is a spike in the data during 2004 that might be explainable because of significantly reduced production time.
• The total oil rate of the field has declined, then increased again multiple times. What you do not know yet is how many completions contributed to the total rate throughout the field history.
• The total oil production rate for the field is approximately 300 b/d
• Peak calendar day production rate for the field occurred in 1992.
Schlumberger Project Variables
NOTES
Plots Schlumberger
NOTES
Schlumberger Plots
Module 4 Plots
Plotting is one of the most commonly used processes in OFM because it is easy to use, effective, and capable of providing many solutions for analysis of production data.
Learning Objectives
After completing this module, you will know how to:
• create a graph with one or two Y-axes
• create a plot with multiple graphs
• create a plot using the OFM catalog
• use the Graph Blow Up option
• create multiple completion plots and multiple group plots
• use sum/average/% contribution plot types
• add a new table for well events
• use plot annotations
• use plot-related tools/utilities
• use a water production diagnostic plot.