4 ms·
It's nowhere as sophisticated as this, but I wrote a little utility for Monte Carlo analysis of spreadsheet models with Python and Xlwing: https://github.com/a
by thanatropism 7y ago
It's nowhere as sophisticated as this, but I wrote a little utility for Monte Carlo analysis of spreadsheet models with Python and Xlwing:
https://github.com/asemic-horizon/stanton https://github.com/asemic-horizon/stanton
As a bonus, since the spreadsheet model is exposed as a Python function, emulating complex spreadsheets with simple ML models (decision trees...) is easy.
- floki999 7y agoNice. The Excel/Python combo is very powerful. Microsoft has kept Excel in the dark ages, and could have implemented such better analytics than it currently offers. If they could integrate Python in lieu of VBA and make it compatible with their Form designer, it would become very popular. The ability to quickly knock-up desktop interfaces, closely integrated with powerful analytics and the user’s data source is priceless in certain environments (e.g. capital markets).