Is Python a solution

[trentban]

Hi All

Before going down a long path would Python be a possible solution for this...

I have an excel model that needs to forecast future data after i tweak assumptions, i know there are python packages to interact with excel and forecast. However many people need to be able to do this tweaking of the assumptions. Do they all require Python to be installed or can it be "compiled" so the excel model can be distributed and used without the user having any knowledge python is doing the work?

cheers
T

[buran]

you may look at xlwings. compile the python backend as an exe and interact with it via excel.
Another option is to provide own GUI to tweak model params and provide option to load/export into csv, excel, etc.