3 ms·
> I discovered looking at these that there was an error in the spreadsheet double-counting all inputs (rows and columns were added and the row-totals included i
by flukus 9y ago
> I discovered looking at these that there was an error in the spreadsheet double-counting all inputs (rows and columns were added and the row-totals included in the grand total). Best I can tell, finding that bug was not in fact part of the course goal....
Multiple times I've come across issues like this when developing the replacement for an old access system. The numbers between the new an old system don't match, so you have to dig through both to find the error. If the error is in the new version that's great, but when you tell the boss that the error is in the old one and they've been off by a few million dollars over the years...
- beobab 9y agoBeen there: "No. The old is correct. Make the new way match."
- johnbellone 9y agoA mistake plus keleven gets you home by seven.
- GFischer 9y agoYep, Excel is an easy way to lose a few million dollars. However, development costs are so expensive they might have broken even when factoring the cost of creating a system.