The solution used a Python linear programing library as the foundation of the linear programing model, which was written as an Azure Cloud Function and given a Remote State Transfer interface (RST). This cloud based function was integrated directly to the existing spreadsheet model using visual basic for applications and simple commands were presented to allow the user to activate the cloud function. The cloud function would read from the spreadsheet, perform the calculations on highspeed servers, and then download the results directly into the spreadsheet which would auto update the financial forecast.
