Totaling/Subtracting Along the Time Axis
The values consecutive along the time axis are added or subtracted forward or backward.
The initial value of the calculation (summand for addition and minuend for subtraction) is the first value of the time series for the forward operation and the last value for the backward operation.
Forward Summation
A simple time series is summed forward along the time axis (see following table and figure).
| Time | Demand | Demand Accumulated Forward |
|---|---|---|
| 00 Tage 00:00:00 | 2 | 2=2 |
| 00 Tage 01:00:00 | 7 | 9=2+7 |
| 00 Tage 02:00:00 | 3 | 12=9+3 |
| 00 Tage 03:00:00 | 4 | 16=12+4 |
| 00 Tage 04:00:00 | 1 | 17=16+1 |
For example, a counter reading can be determined retrospectively.
Subtract Backward
When subtracting backward, the penultimate value (subtrahend) is subtracted from the last value of the time series (minuend). The result (the difference) forms the penultimate value of the result time series. The penultimate value of the original time series is subtracted from this and so on (see following example).
A simple time series is subtracted backward along the time axis. The calculation starts at the last value of the time series, in the following table at the very bottom, and then moves upward in steps (see also the following figure).
| Date | Time | Demand | Demand Depleted Backward |
|---|---|---|---|
| 01.01.2019 | 00:00:00 | 2 | 19=21-2 |
| 01.02.2019 | 00:00:00 | 9 | 21=30-9 |
| 01.03.2019 | 00:00:00 | 20 | 30=50-20 |
| 01.04.2019 | 00:00:00 | 50 | 50 =100-50 |
| 01.05.2019 | 00:00:00 | 100 | 100=100 |
Start Method
To start the method, select Methods → Convert time series → Accumulate/Deplete from the menu bar or the context menu of the time series in the Project Explorer (see the following figure).
In the window that opens (see following figure), use Select time series to select the time series to be processed. A multiple selection is possible.
Decide whether to add or subtract forward or backward along the time axis:
Finally, select whether the respective existing time series should be overwritten with the accumulated/depleted values or whether a new time series should be created in addition.
