Background

Optalitix Models allows you to capitalize on investment in Excel, by running them as ‘Models’ on the web. It allows organizations having complex calculations and business logic written as excel-based formula’s, to share with external world or third-party applications.

Benefits

  1. Reduce software development costs

  2. Retaining your intellectual property.

  3. Audit/Control Model versions

  4. Create custom web site portals and platforms for your models.

  5. Convert complex models into easily accessible systems for developers.

  6. Real time model visibility and usage.

What is a model?

A model has a user defined set of inputs, mapped from excel to produce a defined set of outputs. It is made up of one or more calculations that can reproduce the same output values when the same inputs are provided.

Let’s take an example of a Loan calculator…

The following are the required Inputs

  • Loan amount

  • Annual interest rate

  • Loan period

  • Starting date

From these Inputs the model calculates the following Outputs:

  • Monthly payment

  • Number of payments

  • Total interest

  • Total cost of the loan

Follow our Quick-start guide to learn how to create your first model on the web.

Model’s Use Case

Scenario

Problem

Models Solution

A bank’s Finance Manager has a loan calculator that her team uses internally. They wants to simplify customer experience by having the loan calculator logic written in Excel, to be integrated into their website’s online form.

Software Development team with bank, suggests it will take a lot of time and effort to recreate the logic reliably into the website.

It also leads to duplication of business logic (i.e. Loan Calculation & Eligibility) at multiple places.

There could also a possible risk of exposing business logic to external world, also potential loss of control on the model. It also leads to further delays if business logic changes in future.

Within 5 minutes the Finance Manager can upload her model into the Models Platform and create a developer friendly API

The Finance manger shares the developer integration page to their development team which provides all the step required to integrate the API. In a couple hour the API is integrated.

In the future the Finance Manger can use the version control tools to change the version of the model developers being involved.

Additional Features

  • Creating Models - use variety of input sources and create models

  • Monitoring - view API usage and debug individual requests.

  • Version Control - control which version of a model is used.

  • Testing - validate the correctness of your model.

  • Security - determine who has access to your models and data.