Pretty much all data heavy organisations use excel VERY heavily. And when nobody understands the model within them any more, they need retiring and are usually replaced with… Excel! This time with even more tabs and columns. To replace these things with computer models risks repeating the same problem the original sheet has: bus factors and complexities are hard, more so even in python/r than excel sadly. Maybe one day something will trump it, but that day is not today
I do this for a living. I’ve spent basically my whole career (15 years full time professional at this stage) basically trying to kill excel. You can’t, or at least I can’t. You can add processes to it, you can programmatically read/write from it, but when it comes down to ditching it: every stakeholder is invested in excel. No other piece of office has the staying power that excel has, it will outlast us all
Pretty much all data heavy organisations use excel VERY heavily. And when nobody understands the model within them any more, they need retiring and are usually replaced with… Excel! This time with even more tabs and columns. To replace these things with computer models risks repeating the same problem the original sheet has: bus factors and complexities are hard, more so even in python/r than excel sadly. Maybe one day something will trump it, but that day is not today
SQL would like a little chat with you.
I do this for a living. I’ve spent basically my whole career (15 years full time professional at this stage) basically trying to kill excel. You can’t, or at least I can’t. You can add processes to it, you can programmatically read/write from it, but when it comes down to ditching it: every stakeholder is invested in excel. No other piece of office has the staying power that excel has, it will outlast us all