Part 9 – Verification
Part of the verification process in development of a spreadsheet or software tool involves what I like to term the process of idiot proofing. Some end users are considered as potential idiots, asking yourself to think like this idiot can be a challenge, as it doesn’t come naturally to some. Luckily as engineers we are good at solving problems, identifying risk and considering all eventualities, and are able to either test for these eventualities or provide suitable error handling to avoid giving back an incorrect, but potentially believable result to the end user.
You’ll essentially need to consider things no sane person would do, and then do these things to ensure your code, calculations, etc, all work as intended. You know that guy who uses a spreadsheet to design outside of any fundamental assumptions it might be based on, or intentionally decides some course of action is conservative when it really isn’t. Think like this guy, what will go wrong will go wrong, and you’re trying to head this eventuality off at the pass so to speak.Read More