3 ms·
But professional programmers (emphasis on professional) are well aware of how codebases can grow out of hand and employ entire categories of theories, strategie
by davedx 7y ago
But professional programmers (emphasis on professional) are well aware of how codebases can grow out of hand and employ entire categories of theories, strategies and tools to keep their software maintainable, even when under delivery/time pressure. Excel doesn't really have much in this category of theories and tools.
- fzumstein 7y agoYou can actually unit test your Spreadsheets surprisingly easily with Python: https://www.slideshare.net/xlwings/automated-testing-of-excel-workbooks https://www.slideshare.net/xlwings/automated-testing-of-exce...
- giardini 7y agoYou really should look at some of the links I provide above to Jocelyn Ireson-Paine's work.