Functions used only in Time series functions
Calcstart
Returns the Start date specified in the project identification.
Syntax Calcstart
Argument Description
Availability External conditions, Time series functions only
Returning unit Real number
Example
If the calculations start-time is 01-01-2012 then Calcstart returns 40909
Intervals
Based on an existing time series, the function generates a new time series with a specified number of intervals omitting a percentage of extreme values.
Syntax Intervals(TSSymbol;NoOfIntervals,EKstremeValuesPct)
Argument Description
TSSymbol Name of time series symbol
NoOfIntervals Number of intervals in prognosis
ExtremeValuesPct Percentage of extreme values (both high and low) to be omitted
Returning value Value in actual time stamp
Returning unit -
Description
Intervals() is made for backward compatibility of the way of generating prognosis for electricity spot prices that were done prior to energyPRO version 4.2. Based on an existing time series, the function generates a new time series with a specified number of intervals omitting a percentage of extreme values. All intervals have the same length. All values from the mother time series are then put in the corresponding interval. The Intervals are created based on monthly values.
Example
Intervals(Spot;5;2), Where a time series with 5 intervals omitting the highest and lowest 2 percent value.
TSMean
Returns a time series mean value for a specified period.
Syntax TSMean(TIMESERIESNAME;Start time;End time)
Argument Description
TIMESERIESNAME The name of the time series
Start time Number, Date or calcstart function
End time Number, Date or calcstart function
Returning unit Real number
Description
TSMean() returns the mean value for a specified period. The period can be specified by a values (<1000) then the argument is interpreted as offset from the actual timestamp otherwise it is interpreted as a data.
Examples
TSMean(T;CalcStart-1;2)
TSMean(T;Floor(CalcStart);2)
TSMean(T;01-01-2012;08-01-2012)
TSMean(T;-1;-0)
TSMin
Returns a time series minimum value for a specified period.
Syntax TSMin(TIMESERIESNAME;Start time;End time)
Argument Description
TIMESERIESNAME The name of the time series
Start time Number, Date or calcstart function
End time Number, Date or calcstart function
Returning unit Real number
Description
TSMin() returns the min value for a specified period. The period can be specified by a values (<1000) then the argument is interpreted as offset from the actual timestamp otherwise it is interpreted as a data.
Examples
TSMin(T; -1; +1)
TSMin(T;Date(CalcStart);Date(CalcStart + 365))
TSMax
Returns a time series maximum value for a specified period.
Syntax TSMax(TIMESERIESNAME;Start time;End time)
Argument Description
TIMESERIESNAME The name of the time series
Start time Number, Date or calcstart function
End time Number, Date or calcstart function
Returning unit Real number
Description
TSMax() returns the max value for a specified period. The period can be specified by a values (<1000) then the argument is interpreted as offset from the actual timestamp otherwise it is interpreted as a data.
Examples
TSMax(T; -1; +1)
TSMax(T;Date(CalcStart);Date(CalcStart + 365))
TSSum
Returns the sum of a time series for a specified period.
Syntax TSSum(TIMESERIESNAME;Start time;End time)
Argument Description
TIMESERIESNAME The name of the time series
Start time Number, Date or calcstart function
End time Number, Date or calcstart function
Returning unit Real number
Description
TSSum() returns the sum value for a specified period. The period can be specified by a values (<1000) then the argument is interpreted as offset from the actual timestamp otherwise it is interpreted as a data.
Examples
TSSum(T; -1; +1) TSSum(T;Date(CalcStart);Date(CalcStart + 365))