4 ms·
Matlab, yes. Matlab code can be versioned, and opened in VIM for independent review. It can have unit and integration tests. It can also often be run in alterna
by dotancohen 6y ago
Matlab, yes. Matlab code can be versioned, and opened in VIM for independent review. It can have unit and integration tests. It can also often be run in alternative implementations with few changes, such as Octave.
Excel? You'd be lucky if Excel N-2 can properly handle the file, much less an "alternative implementation" such as LibreOffice Calc.
- jbjbjbjb 6y agoYou can have manual tests (automated through VBA if you wanted) and reviews. The review tools are lesser known features built into Excel. I know from my experience accounting firms will take your spreadsheets and code too and audit it. I’ve worked with bankers who would effectively run a suite of tests before using their updated spreadsheets. These concepts aren’t unique to programming.