AI for Excel
How to install Peltarion AI for Excel
You can install the Peltarion AI for Excel add-in directly within an open Excel document:
Click on the menu Insert and select Get add-ins
Search for Peltarion
Click on the Peltarion - AI for Excel result, then click on the Add button
How to use Peltarion AI for Excel
Deploy and enable your model
To deploy a model, go to the Deployment view and click on New deployment. Select the Experiment and Epoch that correspond to the model you want to deploy. If you want, give a custom Name to the deployment, then click on Create.
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.
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
The Peltarion AI for Excel add-in needs the
token of the model you want to get predictions from.
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 of the Deployment view.
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
Click on Enter credentials to fill in the
Tokenfrom the deployment’s API information.
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.
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.
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.