Can spreadsheets work for engineering?

Outside of engineering, the spreadsheet has evolved nicely in its 25 years from an accounting tool to an application for anyone working with data, including business managers, bookkeepers, and statisticians. But spreadsheets do little to capture the wealth of engineering data critical to an organization's success.

09/01/2005


Outside of engineering, the spreadsheet has evolved nicely in its 25 years from an accounting tool to an application for anyone working with data, including business managers, bookkeepers, and statisticians. But spreadsheets do little to capture the wealth of engineering data critical to an organization's success. For any engineering project, the history of all calculations performed is among the most important records of the endeavor.

If a bridge girder needs to have specific strength as defined by a certain number, we need to know how that figure was calculated. What were the assumptions, methods, and values that went into the result? Too many companies fail to preserve this record, and they lose invaluable intellectual property with every new project, resignation, or retirement. They have great difficulty reporting their work to clients and regulators. And they have no way of reusing engineering information in other areas of the enterprise, such as sales, marketing, and customer service.

Spreadsheets don't help in this important area. They show answers, but omit context. Instead of seeing calculations laid out in conventional math notation, the user will see machine-readable text buried in formulas using cryptic hidden macros and convoluted cell structure.

Moreover, spreadsheets are inherently error prone. Rick Butler, an auditor who writes and speaks widely on spreadsheets, asserts that controlled experiments show that 40% to 80% of spreadsheets contain errors at their inception. Spreadsheet developers miss more than 80% of their own errors, and outside testers miss more than 50% of design logic and 34% of application errors.

A veteran engineer at Rolls-Royce also is sounding the alarm. Dr. Alan Stevens, who possesses a Ph.D. in theoretical physics, has documented several instances where Microsoft Excel provides incorrect results. For example, in resolving the implicit ambiguity in:

-x2

(-x)2Positive

-(x2) Negative

Excel chooses the positive interpretation, unlike in all properly constituted calculation software tools, which choose the negative. The positive interpretation has the unfortunate consequence that -x2+ 1 is different from 1 - x2.

"Talented engineers are using Excel and getting serious errors of which they're simply not aware," Stevens claims. "And errors build up more rapidly than you might expect."

An electronic calculation "worksheet" is a better solution for effectively documenting design and engineering processes and ensuring accuracy. Unlike spreadsheets, worksheets employ real mathematical notation and capture, in human -readable text, illustrations and graphs—assumptions, sources, methods, and critical data behind every calculation.

Organizations can build on the value of these worksheets by organizing, tracking, controlling, and sharing them in a searchable Web-based repository.

With a solution incorporating these capabilities, organizations can obtain concrete and immediate answers to commonly asked questions, such as:

  • Did we use the current requirement for cargo weight or the old requirement in this analysis?

  • Does the delivered document match the analysis that was actually performed?

  • Which design decisions depend on the yield strength of ASTM 316L steel, and where did we get that number?

  • Has anyone done this calculation before?

  • Did we get the units right?

Ability to answer questions like these separates great engineering organizations from average ones and makes the difference between efficient product development and failure. It can also save engineers' reputations.


Author Information
Chris Randles is CEO and president of Mathsoft Engineering & Education Inc.;




The Engineers' Choice Awards highlight some of the best new control, instrumentation and automation products as chosen by Control Engineering subscribers. Vote now (if qualified)!
The System Integrator Giants program lists the top 100 system integrators among companies listed in CFE Media's Global System Integrator Database.
Each year, a panel of Control Engineering and Plant Engineering editors and industry expert judges select the System Integrator of the Year Award winners in three categories.
This eGuide illustrates solutions, applications and benefits of machine vision systems.
Learn how to increase device reliability in harsh environments and decrease unplanned system downtime.
This eGuide contains a series of articles and videos that considers theoretical and practical; immediate needs and a look into the future.
Maximize ROI with integrated control system approach; Microcontrollers vs. PLCs; Power quality; Accelerate and rewire IIoT; Traits for excellent engineers
HMI effectiveness; Distributed I/O; Engineers' Choice Award finalists; System Integrator advice; Inside Machines
Women in engineering; Engineering Leaders Under 40; PID benefits and drawbacks; Ladder logic; Cloud computing
Programmable logic controllers (PLCs) represent the logic (decision) part of the control loop of sense, decide, and actuate. As we know, PLCs aren’t the only option for making decisions in a control loop, but they are likely why you’re here.
This digital report explains how plant engineers and subject matter experts (SME) need support for time series data and its many challenges.
This article collection contains several articles on how advancements in vision system designs, computing power, algorithms, optics, and communications are making machine vision more cost effective than ever before.

Find and connect with the most suitable service provider for your unique application. Start searching the Global System Integrator Database Now!

Control room technology innovation; Practical approaches to corrosion protection; Pipeline regulator revises quality programs
Cloud, mobility, and remote operations; SCADA and contextual mobility; Custom UPS empowering a secure pipeline
Infrastructure for natural gas expansion; Artificial lift methods; Disruptive technology and fugitive gas emissions
Automation Engineer; Wood Group
System Integrator; Cross Integrated Systems Group
Jose S. Vasquez, Jr.
Fire & Life Safety Engineer; Technip USA Inc.
This course focuses on climate analysis, appropriateness of cooling system selection, and combining cooling systems.
This course will help identify and reveal electrical hazards and identify the solutions to implementing and maintaining a safe work environment.
This course explains how maintaining power and communication systems through emergency power-generation systems is critical.
The Engineers' Choice Awards highlight some of the best new control, instrumentation and automation products as chosen by Control Engineering subscribers. Vote now (if qualified)!
The System Integrator Giants program lists the top 100 system integrators among companies listed in CFE Media's Global System Integrator Database.
Each year, a panel of Control Engineering and Plant Engineering editors and industry expert judges select the System Integrator of the Year Award winners in three categories.
This eGuide illustrates solutions, applications and benefits of machine vision systems.
Learn how to increase device reliability in harsh environments and decrease unplanned system downtime.
This eGuide contains a series of articles and videos that considers theoretical and practical; immediate needs and a look into the future.
Maximize ROI with integrated control system approach; Microcontrollers vs. PLCs; Power quality; Accelerate and rewire IIoT; Traits for excellent engineers
HMI effectiveness; Distributed I/O; Engineers' Choice Award finalists; System Integrator advice; Inside Machines
Women in engineering; Engineering Leaders Under 40; PID benefits and drawbacks; Ladder logic; Cloud computing
Programmable logic controllers (PLCs) represent the logic (decision) part of the control loop of sense, decide, and actuate. As we know, PLCs aren’t the only option for making decisions in a control loop, but they are likely why you’re here.
This digital report explains how plant engineers and subject matter experts (SME) need support for time series data and its many challenges.
This article collection contains several articles on how advancements in vision system designs, computing power, algorithms, optics, and communications are making machine vision more cost effective than ever before.

Find and connect with the most suitable service provider for your unique application. Start searching the Global System Integrator Database Now!

Control room technology innovation; Practical approaches to corrosion protection; Pipeline regulator revises quality programs
Cloud, mobility, and remote operations; SCADA and contextual mobility; Custom UPS empowering a secure pipeline
Infrastructure for natural gas expansion; Artificial lift methods; Disruptive technology and fugitive gas emissions
Automation Engineer; Wood Group
System Integrator; Cross Integrated Systems Group
Jose S. Vasquez, Jr.
Fire & Life Safety Engineer; Technip USA Inc.
This course focuses on climate analysis, appropriateness of cooling system selection, and combining cooling systems.
This course will help identify and reveal electrical hazards and identify the solutions to implementing and maintaining a safe work environment.
This course explains how maintaining power and communication systems through emergency power-generation systems is critical.
The Engineers' Choice Awards highlight some of the best new control, instrumentation and automation products as chosen by Control Engineering subscribers. Vote now (if qualified)!
The System Integrator Giants program lists the top 100 system integrators among companies listed in CFE Media's Global System Integrator Database.
Each year, a panel of Control Engineering and Plant Engineering editors and industry expert judges select the System Integrator of the Year Award winners in three categories.
This eGuide illustrates solutions, applications and benefits of machine vision systems.
Learn how to increase device reliability in harsh environments and decrease unplanned system downtime.
This eGuide contains a series of articles and videos that considers theoretical and practical; immediate needs and a look into the future.
Maximize ROI with integrated control system approach; Microcontrollers vs. PLCs; Power quality; Accelerate and rewire IIoT; Traits for excellent engineers
HMI effectiveness; Distributed I/O; Engineers' Choice Award finalists; System Integrator advice; Inside Machines
Women in engineering; Engineering Leaders Under 40; PID benefits and drawbacks; Ladder logic; Cloud computing
Programmable logic controllers (PLCs) represent the logic (decision) part of the control loop of sense, decide, and actuate. As we know, PLCs aren’t the only option for making decisions in a control loop, but they are likely why you’re here.
This digital report explains how plant engineers and subject matter experts (SME) need support for time series data and its many challenges.
This article collection contains several articles on how advancements in vision system designs, computing power, algorithms, optics, and communications are making machine vision more cost effective than ever before.

Find and connect with the most suitable service provider for your unique application. Start searching the Global System Integrator Database Now!

Control room technology innovation; Practical approaches to corrosion protection; Pipeline regulator revises quality programs
Cloud, mobility, and remote operations; SCADA and contextual mobility; Custom UPS empowering a secure pipeline
Infrastructure for natural gas expansion; Artificial lift methods; Disruptive technology and fugitive gas emissions
Automation Engineer; Wood Group
System Integrator; Cross Integrated Systems Group
Jose S. Vasquez, Jr.
Fire & Life Safety Engineer; Technip USA Inc.
This course focuses on climate analysis, appropriateness of cooling system selection, and combining cooling systems.
This course will help identify and reveal electrical hazards and identify the solutions to implementing and maintaining a safe work environment.
This course explains how maintaining power and communication systems through emergency power-generation systems is critical.
click me