target_date,values,timeline,seasonality,data_completion,aggregation!Returns the forecasted value for a specific future target ...

Excel 2016

!target_date,values,timeline,seasonality,data_completion,aggregation!!Returns the forecasted value for a specific future target date using exponential smoothing method.!is the data point for which (!idspnExcel_NV) predicts a value. It should carry on the pattern of values in the timeline.!is the array or range of numeric data you're predicting.!is the independent array or range of numeric data. The dates in the timeline must have a consistent step between them and can't be zero.!is an optional numeric value that indicates the length of the seasonal pattern. The default value of 1 indicates seasonality is detected automatically.!is an optional value for handling missing values. The default value of 1 replaces missing values by interpolation, and 0 replaces them with zeros.!is an optional numeric value for aggregating multiple values with the same time stamp. If blank, (!idspnExcel_NV) averages the values.!

start_date,months!Returns the serial number of the last day of the month before or after a specified number of months!is ... sum_range,criteria_range,criteria,.!Adds the cells specified by a given set of conditions or criteria!are the actual cells ... Tables are storage units within the database. If you specify a default table, the Query Wizard initially displays all fields ... target_date,values,timeline,confidence_level,seasonality,data_completion,aggregation!Returns a confidence interval for the ... target_date,values,timeline,seasonality,data_completion,aggregation!Returns the forecasted value for a specific future target ... Text values in formulas are limited to 255 characters. To create longer text values in a formula, use the CONCATENATE function ... text!Changes full-width (double-byte) characters to half-width (single-byte) characters. Use with double-byte character sets ... text!Changes half-width (single-byte) characters within a character string to full-width (double-byte) characters. Use with ... text!Converts a text string that represents a number to a number!is the text enclosed in quotation marks or a reference to ...