Math Functions > Hydrologic Functions


Two Variable Rating Table

The Two Variable Rating Table function computes new time series values from the input of two other independent time series data sets.  The functional relationship is specified by a table of values contained in a paired data set having multiple sets of x-y curves. 

 

As an example, reservoir release is a function of both the gate opening height and reservoir elevation (see below).

 

For each gate opening height, there is a reservoir elevation-reservoir release curve, where reservoir elevation is the independent variable (x-values) and reservoir release is the dependent variable (y-values) of a paired data set.  Each paired data curve has a curve label.  In this case, the curve label is assigned the gate opening height.  Using the paired data set shown in the figure below, you may employ the Two Variable Rating Table function to interpolate time series values of reservoir elevation and gate opening height to develop a time series of reservoir release.

 

Times for the two input time series data sets must match.  Curve labels must be set for curves in the rating table paired data set and must be interpretable as numeric values. 

 

By default, the units and parameter type of the resultant time series data set are duplicated from the y-units and y-parameter type of the rating table paired data set. 

 

The appearance of the Math Functions screen for the Two Variable Rating Table function is shown in the second figure below.

 

Example of two variable rating table paired data, reservoir release as a function of reservoir elevation and gate opening height (curve labels).

 

To derive a new time series data set from the two variable rating table interpolation of two other time series data sets:

  1. Choose the Hydrologic tab of the Math Functions screen and select the Two Variable Rating Table operator.
  2. From the Selected Data Set list, select the paired data set containing the rating table.  If the selected data set is not a paired data set, the remaining input boxes on the screen will be unavailable.
  3. From the two lists shown below the Data Set title, select the two input time series data sets. 
    • Use the top list to select the time series data set matching the x-values parameter of the rating table.  In the figure below, this is a time series data set of reservoir elevation. 
    • Use the bottom list to select the time series data set matching the curve labels parameter.  In the figure below, this is a time series data set of gate opening height.  You may select only one data set from a list.
  4. Once the data sets are selected, click Compute to apply the Two Variable Rating Table function.


    Screen for Two Variable Rating Table Function.