!target_date,values,timeline,confidence_level,seasonality,data_completion,aggregation!!Returns a confidence interval for the forecast value at the specified target date.!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 a number between 0 and 1 that shows the confidence level for the calculated confidence interval. The default value is .95.!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 date that is the indicated number of months before or after the start ...
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 ...