AI for Excel

Peltarion AI for Excel is an add-in that allows you to get predictions from your own AI models built on the Peltarion Platform.

Try the add-in
Peltarion - Do the tutorial to integrate a sales forecasting model in Microsoft Excel
Peltarion - Watch the video to see how to connect the add-in


How to install Peltarion AI for Excel

You can install the Peltarion AI for Excel add-in directly within an open Excel document:

  1. Click on the menu Insert and select Get add-ins

  2. Search for Peltarion

  3. Click on the Peltarion - AI for Excel result, then click on the Add button

Install the Peltarion AI for Excel add-in

How to use Peltarion AI for Excel

Deploy and enable your model

The model that you want to use in your Excel document must be deployed and enabled on the Peltarion Platform.

To deploy a model:

  1. Go to the Deployment view and click New deployment.

  2. Select the Experiment and Epoch that correspond to the model you want to deploy. If you want, give a custom Name to the deployment.

  3. Click Create.

Change parameter name (optional)
In the Parameters section, you can change the Name of the input and output features before you enable the deployment for the first time.
The Name specified here is what you will need to use inside Excel.

Note
Anyone with the URL and Token information of a deployment can request predictions from the deployed model. Don’t share this information or write it inside a document that others can read if they are not allowed to query your deployment.
A deployment can be prevented from accepting requests by disabling it. If you need to get a new token, you can create a new deployment from the same experiment and epoch. Unused deployments can be deleted after they have been disabled.

Get the API information

To get predictions from the model to the Peltarion AI for Excel add-in you needs:

  • URL

  • token

  • Name of the input features

This information is available in the Deployment view. Select the deployment you want to use from your Excel spreadsheet, and look for the URL and Token values in the API information.

You will also need to know the Name of the input features, as displayed in the Parameters section.

Deployment API information

Request predictions in Excel

In your Excel spreadsheet, click on the Home button then on AI for Excel.

A sidebar will appear on the right side to help you request predictions from your model.

Using the Peltarion AI for Excel sidebar

  1. Enter credentials
    Click on Enter credentials to fill in the URL and Token from the deployment’s API information.

  2. Header range
    Specify the range of cells in the spreadsheet that has the name of the input features expected by your model. The text in the specified cells must match the Name from the deployment’s Parameters.

  3. Data range
    Specify the range of cells in the spreadsheet that contains the value of the input features. The data must be organized with one row corresponding to one example to submit to the model, and different columns corresponding to the various features.

  4. Predict
    Click on Predict to send the specified data to your model and fill the output range of the spreadsheet with the calculated predictions.

    • You can fill in a cell range easily by first selecting it on your spreadsheet, then clicking the Use selection button in the AI for Excel toolbar.

Was this page helpful?
YesNo