3 ms·
I’ve done this type of numerical work in code and it’s much more difficult than it first appears. It’s not like web development this stuff is much more like rea
by jbjbjbjb 6y ago
I’ve done this type of numerical work in code and it’s much more difficult than it first appears. It’s not like web development this stuff is much more like real computer science.
Tools like Excel and Matlab exist for a reason.
- dotancohen 6y agoMatlab, 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.