Skip to content

Sorting, Creating Duration Curve

Sorting, Creating Duration Curve

The method comprises three selectable procedures of sorting time series according to the values of the data points.

The data points of a time series are sorted in ascending or descending order according to their value, taking into account certain rules (see the following schematic diagram).

The result time series is always an abstract time series starting at the time 00 days 00:00:00.

The three different sorting methods are presented below.

Indepently

The data points of each time series are sorted by their value in ascending or descending order independently of the other time series (see the following examples).

Sum

Time series are sorted according to their sums, for example, if several demands form a total demand for which a year duration curve is to be created.

Sums are calculated for each data point from the values of the time series to be sorted. Then the data points are sorted according to these sums and provided with abstract time points. The values from the original time series are assigned to the abstract data points according to their allocation to the original data points. The values of the result time series have the same combination for the individual data points as in the original time series (see the following examples for an ascending sorting of the time series by sums).

For the data points of the original time series in the value table above, the values of the time series result in the following sums, according to which the data points are sorted in the second step:

Original Time Series
Date
Original Time Series
Time
Sum
Sorting Order
Sorted Time Series
Time
01.01.202000:00:0015200 days 01:00:00
02.01.202000:00:0020300 days 02:00:00
03.01.202000:00:0014100 days 00:00:00
04.01.202000:00:0027500 days 04:00:00
05.01.202000:00:0021400 days 03:00:00

Reference Time Series

First the Reference Time Series is sorted in ascending or descending order. Then the remaining time series are sorted according to the sorted data points of the Reference Time Series (see the following examples, sorted descendingly according to the Reference Time Series Demand 1).

Applying the Method

To start the method, select Methods → Convert Time Series → Sort/Create a Duration Curve from the menu bar or the context menu of the time series in the Project Explorer, use the key combination <Ctrl>+<Shift>+<O>, or the icon in the lower toolbar (see the following figure).

The dialog box of the method opens (see following figure).

Select one of the sorting methods from the drop-down list:

  • Sort indepently,
  • Sort by sum of all time series (load duration curve of multiple supplierss), or
  • Sort by reference time series.

Click Select Time Series and select the time series to be sorted from the open ones. A multiple selection is possible.

If time series are sorted by a reference time series or by their sums they must consist of the same points in time.

Finally, you have to decide whether the existing time series should be overwritten by the sorted one or whether a new time series should be created.

Back To Top