TimeGPT Excel Add-in

📘

Access token required

The TimeGPT Excel Add-in requires an access token. Get your token on the Nixtla Dashboard.

Support

If you have questions or need support, please email [email protected].

How-to

Settings

If it is your first time using the add-in, a welcome screen will guide you to a settings screen to configure your access token.

To access the setting later, click the three dots in the top right and click Settings.

Data Requirements

• All data inputs must exist in the same worksheet. The add-in does not support forecasting using multiple worksheets.

• Time series and exogenous variables (optional) must exist in their own columns. Values that you want predicted can be left blank.

• Headers are optional.

Example:

Forecasting

Once you've configured your token and formatted your input data then you're all ready to forecast!

With the add-in open, configure the forecasting settings by selecting the column for each input.

• Timestamps - The column of the timeseries timestamps

• Values - The column of the timeseries values for each point in time

• Exogenous Variable(s) - The exogenous variables for each point in time. This should also include forecasting horizon (fh) additional timestamps to calculate the future values.

• Frequency - The frequency of the data

• Frequency Horizon - The forecasting horizon. This represents the number of time steps into the future that the forecast should predict. This is usually the number of empty cells in the value column.

• Finetune Steps (advanced) - The number of tuning steps used to train the large time model on the data. Set this value to 0 for zero-shot inference, i.e., to make predictions without any further model tuning.

When you're ready, click Run Forecast to generate the predicted values. The add-in will generate a new worksheet with the prediced values and a chart depicting the forecast.