Ditching Excel for Python in a legacy industry
As the author states - this is an issue for some really complex models - where the complexity, reusability and iteration challenges approach code.<p>Most models do NOT take that many tabs, you can build a toy model near instantly - the production line from finished model and output to publishable material is a few shortcuts away.<p>Having an analyst, write that same thing using Jupyter? From an accounts perspective?  Man, I’d want to see it in a spread sheet.  It’s just simpler, or more familiar, to debug accounting information in a spread sheet.<p>The idea that we are going to see all those analysts pick up code - over excel - is <i>possible</i>, but I’d say less likely.<p>I’d suspect that the idea of python inside of excel, is a winner. But given that excel is working with its own data model and data tools with power BI, or with their new Lambda function, I’d say they are also working to keep people happy within the excel ecosystem.<p>Interestingly, this is a version of the Bloomberg terminal debate - the terminal does everything, any upstart can only do a small part of the BB offering, allowing BB to always be relevant if not dominant.