CreateForecastSheetCommand Constructor
In This Topic
Initializes a new instance of the
CreateForecastSheetCommand class.
Syntax
'Declaration
Public Function New( _
ByVal As IWorkbook, _
ByVal As Date, _
ByVal As Date, _
ByVal As WorksheetReference, _
ByVal As WorksheetReference, _
ByVal As Integer, _
ByVal As Boolean, _
ByVal As AggregateFunction, _
ByVal As Double, _
ByVal As Boolean, _
ByVal As Boolean _
)
'Usage
Dim workbook As IWorkbook
Dim forecastStart As Date
Dim forecastEnd As Date
Dim values As WorksheetReference
Dim timelines As WorksheetReference
Dim seasonality As Integer
Dim applyInterpolation As Boolean
Dim aggregateDuplicateOption As AggregateFunction
Dim confidenceInterval As Double
Dim includeStatistic As Boolean
Dim isLineChart As Boolean
Dim instance As New CreateForecastSheetCommand(workbook, forecastStart, forecastEnd, values, timelines, seasonality, applyInterpolation, aggregateDuplicateOption, confidenceInterval, includeStatistic, isLineChart)
public CreateForecastSheetCommand(
IWorkbook ,
DateTime ,
DateTime ,
WorksheetReference ,
WorksheetReference ,
int ,
bool ,
AggregateFunction ,
double ,
bool ,
bool
)
Parameters
- workbook
- The workbook where the forecast sheet is placed to.
- forecastStart
- The start point to create forecast sheet.
- forecastEnd
- The end point to create forecast sheet.
- values
- The historical values used to calculate the forecast sheet.
- timelines
- The historical timeline used to calculate the forecast sheet.
- seasonality
- Indicates the number of points in a recurring seasonal pattern.
- applyInterpolation
true
to indicate interpolation will be applied to fill missing point, false
for otherwise.- aggregateDuplicateOption
- GrapeCity.CalcEngine.AggregateFunction will be used while historical have duplicate data, valid value AVERAGE, COUNT, COUNTA, MAX, MEDIAN, MIN and SUM.
- confidenceInterval
- Percentages used for calculating the confidence interval.
- includeStatistic
true
to include a table of forecast accuracy metric and smoothing factor; otherwise, false
.- isLineChart
true
to create the line chart; otherwise, create the column chart.
See Also