Excel Model Upload

Swallow models created from XLS uploads

You can upload an XLS pricing model directly in to Swallow. We can log each cell and test against expected response at each cell transform and calculation.

We support many different versions of Excel. We support all formulas and syntax of Excel.

To maximise the ability for this to work first time:

Necessary work:

• Add a comment /note to the output cell that contains

output::result

• Make sure the output cell is calculating the correct value. In the above example, we will validate the uploaded model against a response of £187.21.

• For free accounts, we limit the number of rows on any tab to 1000. Amend your model to still price with smaller datasets. You can have unlimited row counts on upgraded accounts.

Optionally:

• You can label multiple input cells with:

input::traveller_age

• You can label multiple additional output cells with:

output::tax

Failed Upload

If the upload fails, it maybe that we can't process the file. You can still provide the excel to help contextualise our AI builder. We will do best guessing at the model. This is less likely to price out exactly the same.

It will provide you will a model that you can collaborate and amend.

Successful Upload

On success, you will able to see your model in cell reference format. You will be able to debug on a cell by cell basis.

You can update labels for input and transform steps to make the model easier to read. We have already made guesses at what each cell is trying to do. It is advised that you clean the input naming so that the Try Form displays in a more user friendly way