You have to keep in mind that creating a spreadsheet is much like a creating a software program. You wouldn't trust a program without running test data through it, and you really have to do the same with a spreadsheet.
Thanks for the study, Brent. Was this an Hypothesis-Driven study or a Data-Driven study? I'm a scientist, not an engineer, but I do use spreadsheet calculations to do quick statistics on very small collections of preliminary data. To analyze experimental results I go a bit deeper and use either MathCAD or Mathematica depending on the preference of my collaborators. For measurements and signal processing I use test-driven software development guidelines to produce code in National Instruments LabVIEW. I use a spreadsheet to document quick calculations that I used to perform with a handheld calculator.
I would hypothesize the use of spreadsheets to analyze mission-critical data would be widespread in business and financial applications. Is it that widespread in science and engineering?
Digital healthcare devices and wearable electronic products need to be thoroughly tested, lest they live short, ignominious lives, an expert will tell attendees at UBM’s upcoming Designers of Things conference in San Jose, Calif.
Focus on Fundamentals consists of 45-minute on-line classes that cover a host of technologies. You learn without leaving the comfort of your desk. All classes are taught by subject-matter experts and all are archived. So if you can't attend live, attend at your convenience.