HOME  |  NEWS  |  BLOGS  |  MESSAGES  |  FEATURES  |  VIDEOS  |  WEBINARS  |  INDUSTRIES  |  FOCUS ON FUNDAMENTALS
  |  REGISTER  |  LOGIN  |  HELP
Blogs
Guest Blogs

Donít Risk Your Most Important Calculations to Spreadsheets

NO RATINGS
View Comments: Newest First|Oldest First|Threaded View
<<  <  Page 3/3
tekochip
User Rank
Platinum
Test Data
tekochip   3/15/2013 9:31:25 AM
NO RATINGS
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.


williamlweaver
User Rank
Platinum
Conclusion Obvious?
williamlweaver   3/15/2013 8:08:00 AM
NO RATINGS
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?

<<  <  Page 3/3
Partner Zone
More Blogs from Guest Blogs
Igus retrofitted a car with 56 of its plastic iglide bearings to celebrate the brand's 30th anniversary. The car is currently being driven across the US and Canada.
The first and most obvious lesson of the following story is to remember to consider creep, along with all other potential failure modes.
Medical devices will look and feel different in the next 20 years, because, as design and product development people, our criteria are changing.
The properties of stainless steel make it well suited for a wide range of applications, but many of the things engineers think they know about stainless steel arenít true.
It seems that gears have been around forever -- what could be new?
Design News Webinar Series
7/23/2014 11:00 a.m. California / 2:00 p.m. New York
7/17/2014 11:00 a.m. California / 2:00 p.m. New York
6/25/2014 11:00 a.m. California / 2:00 p.m. New York
5/13/2014 10:00 a.m. California / 1:00 p.m. New York / 6:00 p.m. London
Quick Poll
The Continuing Education Center offers engineers an entirely new way to get the education they need to formulate next-generation solutions.
Aug 18 - 22, Embedded Software Development With Python & the Raspberry Pi
SEMESTERS: 1  |  2  |  3  |  4  |  5  |  6


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.
Last Archived Class
Sponsored by igus
Learn More   |   Login   |   Archived Classes
Twitter Feed
Design News Twitter Feed
Like Us on Facebook

Sponsored Content

Technology Marketplace

Copyright © 2014 UBM Canon, A UBM company, All rights reserved. Privacy Policy | Terms of Service