#
Ratio trend

The ratio trend is used to create linear forecasts of fluid ratios vs time or cumulative production. These can be linked to decline analyses to create Ratio Forecasts in place of analyzing secondary fluids independently. The ratio trend is not based on a model or equation, and you should consider the fluid properties of a reservoir in order to constrain forecasts.

The supported ratios include gas-oil ratio (GOR), water-oil ratio (WOR), condensate-gas ratio (CGR), and water-gas ratio (WGR). These ratio trends can be created on a Decline worksheet by clicking the + icon in the Analysis Manager. If the worksheet is plotting a production rate or ratio against time or normalized time, a new ratio-time trend will be created. If the worksheet is plotting a production rate or ratio against cumulative oil or gas production, a new ratio-cumulative production trend will be created.

This analysis works with your Harmony Forecast™ license.

## Analysis Parameters pane

After you add your ratio trend, the selected analysis (highlighted in gray) has its detailed parameters displayed in the Analysis Parameters pane located below the Analysis Manager pane. (This is the default setting.)

Harmony Enterprise initially best fits your ratio trend based on all the production history of the ratio.

In this pane, you can view the following setting:

**Ratio Axis Type** —displays Log or Coordinate, depending on the axis type you set for the ratio on the worksheet when you created the ratio trend. The ratio trend can be displayed and manipulated on the other axis type, but it cannot be changed to the other axis type. It does not appear as a straight line when the axis display is switched, as it is linear only on the axis type it is created on.

### Multiple segments

You can add multiple segments (see Analysis Parameters toolbar) to your ratio trend, and under each segment, you can change parameters and the manipulation method for that segment.

Under each segment's tab, you can specify / view the following parameters:

**Manipulation Method**— select Variable Ratio for linearly increasing or decreasing ratios, and select Constant Ratio for a fixed value. The default settings is Variable Ratio.**Start Date**or**Np/Gp Initial**— the start of the ratio trend is indicated by a left square on the analysis line.**End Date**or**Np/Gp Initial**— the end of the ratio trend is indicated by a right square on the analysis line.**Δt**— the duration of the ratio trend from the start date to the end date.**Initial Ratio**— the initial ratio value at the start of the ratio trend. This is displayed as a ratio acronym (such as GOR) with the subscript ‘i’ and is only applicable to the Variable Ratio.**Final Ratio**— the final ratio value at the end of the ratio trend. This is displayed as a ratio acronym (such as GOR) with the subscript ‘f’ and is only applicable to the Variable Ratio.**Ratio**— a Constant Ratio trend shows the ratio value used over its duration with a ratio acronym (such as GOR).**Lock To Previous Segment**— on secondary segments, when this option is on the initial ratio, it is locked to the final ratio of the previous segment, and both remain synchronized through any analysis modifications.

## Analysis Parameters toolbar

The Analysis Parameters toolbar has the following key icons:

/ **Add Segment** / **Remove Segment** — adds a new segment to the end of the existing ratio trend, or removes the last segment. When you add a new segment, it initializes as a Variable Ratio with the same starting value and slope of the previous segment. The duration of new segments is 60 months (5 years).

## Line manipulation

Line manipulations are initiated by clicking the line itself, or one of the manipulation points for a given segment (start date or end date). Specific line manipulations are described below.

**Start Date** (indicated by a left square)

**Click, grab-and-drag**— moves the line vertically and horizontally (4-direction pan) to change the start date and the initial ratio. The slope is changed, but the end-date point stays fixed.

- On a Constant Ratio segment, this only moves horizontally and changes the start date.

**End Date** (indicated by a right square)

**Click, grab-and-drag**— moves the line vertically and horizontally (4-direction pan) to change the end date and the final ratio. The slope is changed, but the start-date point stays fixed.

- On a Constant Ratio segment, this only moves horizontally and changes the end date.

**Any point on the line** (activated when the segment turns orange)

**Click, grab-and-drag**— rotates the line about the pivot point. Both initial and final ratios are changed, but the start and end dates are fixed. This is not available for Constant Ratio segments.

**Pivot point** (indicated by a circle)

**Click, grab-and-drag**— moves the line vertically while the slope is maintained. The pivot point can also move along the line to change its position.

## Linking to a Decline analysis

After you have created a Ratio Trend, you can link a Decline Analysis to it, to calculate a Ratio Forecast. For example, linking an oil decline to a GOR trend calculates a gas Ratio Forecast (a fluid rate forecast based on the Decline and Ratio Trend). Likewise, you can link ratio trends after creation to a decline analysis. For example, adding GOR and WOR ratio trends to an oil decline generates both gas and water ratio forecasts.

This can be done by clicking the **…** button next to the analysis in the Analysis Manager. For more information, see Analysis type menu.

For each ratio, either fluid can be linked to calculate the other, but only traditional and multi-segment declines are used. Duong, Stretched Exponential, and other forecast types do not generate a Ratio Forecast with a ratio trend. The Ratio Forecast is calculated from the decline’s Forecast Start Date to End date. If the Ratio Trend does not extend over the same duration, the final ratio trend value is extrapolated to fill the gap.

The calculated rate appears as an item in the Analysis Manager (selected below) that can be displayed on a worksheet with its rate, or on the Forecast worksheet.

Ratio-Cumulative trends behave somewhat differently: these ratio trends can only be linked to declines of the same primary fluid (e.g. GOR-Np can link to Oil declines, not Gas declines). This is due to the use of the linked decline in translating the ratio-cumulative trend to a time forecast.

If the decline or ratio trend is removed from the parent analysis or deleted, the Ratio Forecast is deleted. Another analysis that generates a Ratio Forecast of the same fluid type cannot be linked to the analysis after the Ratio Forecast is created.

The Ratio Forecast can be exported. For more information, see export forecasts. When the ratio trend is linked to an appropriate decline, it can also be exported to ARIES. For more information, see export decline parameters.

An ARIES export supports the following combinations (multiple ratio trends may be linked to a single decline):

- GOR + oil decline
- GOR + gas decline (exported as OGR)
- WOR + oil decline
- CGR + gas decline
- WGR + gas decline

## Analysis-line customization

You can customize the width and color of your decline line / curve by right-clicking it.

After you customize your decline line / curve, the modifications are saved and applied to every worksheet that displays this decline.