4 ms·
have you tried reverse engineering someone else's non-trivial spreadsheet? a programmer might build a good spreadsheet but the average person builds a nest of l
by jgamman 14y ago
have you tried reverse engineering someone else's non-trivial spreadsheet? a programmer might build a good spreadsheet but the average person builds a nest of lookups and hacked up nested if/then statements. seriously, i think spreadsheets are un-auditable - the only way to double check something is to write your own version and check the output... now you've got 2 problems...
- mbetter 14y agoLookups and if/then statements, wow. God forbid you ever have to audit a program with a loop.
- dragonwriter 14y agoThe problem with auditing excel isn't the kind of individual statements, its the lack of structure. Excel is effectively an easy-to-write self-obfuscating coding environment.