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 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.
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.
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:
Name of the input features
You will also need to know the Name of the input features, as displayed in the Parameters section.
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.