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
“How can European standards affect me, especially since I only use machines built in the US?” This is a common question, and one way to answer this is to look at how machine safety is enforced, where the information comes from, and how well you can prove you followed the regulations.
In order to keep in line with safety protocols, industrial networks need to be filtered in a semantic way so that only information related to diagnostics is flowing back to the vendor and that any communications that could be used for remote machine operations are suppressed.
While people may talk about the procurement process, the procurement discipline actually encompasses a number of different processes. They include spend analysis, supplier relationship management, and contract management, just to name a few.
As the Industrial Internet of Things and machine-to-machine communications movements gain speed, some companies are asking themselves, “Wait. How much information do we really want to flow in and out of our premises? Aren’t we supposed to be doubling down on cyber security?”
To carry out the program, Boeing built five custom carriages using a custom, upgraded pneumatic rod lock system developed by Advanced Machine & Engineering Co.
Design News Webinar Series
5/21/2015 11:00 a.m. California / 2:00 p.m. New York
5/7/2015 11:00 a.m. California / 2:00 p.m. New York
6/3/2015 8:00 a.m. California / 11:00 a.m. New York
6/11/2015 11:00 a.m. California / 2:00 p.m. New York
Quick Poll
The Continuing Education Center offers engineers an entirely new way to get the education they need to formulate next-generation solutions.
Jun 8 - 12, Everything You Ever Wanted to Know about Filters
SEMESTERS: 1  |  2  |  3  |  4  |  5  |  6 |  7


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.
Next Course June 2nd-4th:
Sponsored by Proto Labs
Learn More   |   Login   |   Archived Classes
Twitter Feed
Design News Twitter Feed
Like Us on Facebook

Sponsored Content

Technology Marketplace

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