3 ms·
In engineering companies, Excel + VBA will never go away. Most engineers who are not CompE or CS folks really do not want to program. Excel is powerful for nonp
by BeetleB 9y ago
In engineering companies, Excel + VBA will never go away. Most engineers who are not CompE or CS folks really do not want to program. Excel is powerful for nonprogrammers, and the allure of automating some of it with VBA is almost impossible to resist. Excel gives you a platform where you can feed in numbers, do some calculations with a click of a button, and produce charts - all in one file. And it's trivial to tweak if you need to change something. An engineer with little programming knowledge can be "operational" quickly, and the "tool" is safe to pass around to customers.
I had to live with this for a few years and hated it. Fortunately, the Ipython notebook (now Jupyter) and Pandas came along, and to some extent I managed to stop using Excel.