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.2020 | 00:00:00 | 15 | 2 | 00 days 01:00:00 |
| 02.01.2020 | 00:00:00 | 20 | 3 | 00 days 02:00:00 |
| 03.01.2020 | 00:00:00 | 14 | 1 | 00 days 00:00:00 |
| 04.01.2020 | 00:00:00 | 27 | 5 | 00 days 04:00:00 |
| 05.01.2020 | 00:00:00 | 21 | 4 | 00 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:
Click Select Time Series and select the time series to be sorted from the open ones. A multiple selection is possible.
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.








