Spread Windows Forms 17
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet.Commands Namespace / CreateForecastSheetCommand Class / CreateForecastSheetCommand Constructor
The workbook where the forecast sheet is placed to.
The start point to create forecast sheet.
The end point to create forecast sheet.
The historical values used to calculate the forecast sheet.
The historical timeline used to calculate the forecast sheet.
Indicates the number of points in a recurring seasonal pattern.
true to indicate interpolation will be applied to fill missing point, false for otherwise.
GrapeCity.CalcEngine.AggregateFunction will be used while historical have duplicate data, valid value AVERAGE, COUNT, COUNTA, MAX, MEDIAN, MIN and SUM.
Percentages used for calculating the confidence interval.
true to include a table of forecast accuracy metric and smoothing factor; otherwise, false.
true to create the line chart; otherwise, create the column chart.


In This Topic
    CreateForecastSheetCommand Constructor
    In This Topic
    Initializes a new instance of the CreateForecastSheetCommand class.
    Syntax
    'Declaration
     
    
    Public Function New( _
       ByVal workbook As IWorkbook, _
       ByVal forecastStart As Date, _
       ByVal forecastEnd As Date, _
       ByVal values As WorksheetReference, _
       ByVal timelines As WorksheetReference, _
       ByVal seasonality As Integer, _
       ByVal applyInterpolation As Boolean, _
       ByVal aggregateDuplicateOption As AggregateFunction, _
       ByVal confidenceInterval As Double, _
       ByVal includeStatistic As Boolean, _
       ByVal isLineChart 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)

    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