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?
What should be the perception of a productís real-world performance with regard to the published spec sheet? While it is easy to assume that the product will operate according to spec, what variables should be considered, and is that a designer obligation or a customer responsibility? Or both?
Biomimicry has already found its way into the development of robots and new materials, with researchers studying animals and nature to come up with new innovations. Now thanks to researchers in Boston, biomimicry could even inform the future of electrical networks for next-generation displays.
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.