Design World

  • Home
  • Technologies
    • 3D CAD
    • Electronics • electrical
    • Fastening & Joining
    • Factory automation
    • Linear Motion
    • Motion Control
    • Test & Measurement
    • Sensors
    • Fluid power
  • Learn
    • Ebooks / Tech Tips
    • Engineering Week
    • Future of Design Engineering
    • MC² Motion Control Classrooms
    • Podcasts
    • Videos
    • Webinars
  • LEAP AWARDS
  • Leadership
    • 2022 Voting
    • 2021 Winners
  • Design Guide Library
  • Resources
    • 3D Cad Models
      • PARTsolutions
      • TraceParts
    • Digital Issues
      • Design World
      • EE World
    • Women in Engineering
  • Supplier Listings

Trust me — My spreadsheets are perfect

By Lee Teschler | August 31, 2017

Share

Leland Teschler – Executive Editor

[email protected]

On Twitter @ DW—LeeTeschler

I recently heard an application engineer describe a new spreadsheet calculator his Tier Two automotive employer had devised. The spreadsheet helped calculate several technical parameters that went into sizing and selecting a new high-tech automotive component. Meant to be filled out by design engineers at Tier One suppliers, it would be used in the specification of engineered parts valued in the millions, if not tens of millions, of dollars.

I only had one question for the engineer: Who had verified the accuracy and logic of that spreadsheet LTeschlerTHthat was destined to be responsible for so much of the firm’s sales? The answer: “The engineer who wrote it verified it himself….probably.”

For that company’s sake, I hope its spreadsheet is correct. But you’d have to say they have a lot of confidence in a key spreadsheet that no one but the spreadsheet creator has ever examined.

It turns out that this scenario isn’t out of the ordinary, even for researchers with a technical background. So say a couple of computer scientists from the UK. In a paper available from the arXiv.org open-access library maintained by Cornell University, they describe a study of neuroscience researchers who regularly use spreadsheets to tabulate and manipulate data. The majority of the study participants said they didn’t show their spreadsheets to anyone else for a sanity check. Only about 20% did an accuracy check by asking one of their peers to look at their work.

Also interesting was that nearly a third of the researchers in the study didn’t bother documenting their spreadsheets as to the inputs, computations, output, and data point entries. And researchers tend to be self-taught when it comes to spreadsheet skills. None of those in the study had taken a training course in how to create spreadsheets. The majority had picked up what they needed to know on the job while about a quarter of them had some tutoring from their peers.

The irony was that though a minority of the researchers in the study had ever seen the inside of a class room devoted to spreadsheet work, almost three-quarters of them rated their own proficiency in Exel as being in the intermediate range. The scientists running the study point out that this reply smacks of overconfidence. They point to a previous study of spreadsheet use in which nine highly experienced spreadsheet developers all were found to have made at least one error, and 63% of the spreadsheets they created overall had errors. Yet when asked about how confident they were in their work, the median reply was “very confident.”

I’d have to say the results these scientists report has the ring of truth. I also have to admit it’s been a long time since I had anyone check a spreadsheet I made. Ditto for anyone asking me to check a spreadsheet they’d created. I suspect that the experience of most technical professionals mirrors my own.

Getting back to the automotive Tier Two supplier, the engineer with whom I spoke did, in fact, have a way ensuring accuracy in spreadsheets. “I once created a huge spreadsheet for a thermal analysis while I had a 103⁰ fever,” he said. “I knew I was sick so I focused intently on my work. When I went back and checked, I had made errors in only two cells, both of which held complicated equations.”

Oddly, creating a spreadsheet while feverish was not one of the practices the UK scientists mentioned.


Filed Under: Commentary • expert insight

 

Tell Us What You Think!

Related Articles Read More >

engineering in plain sight
Book review: A plain explanation of every day engineering
who is reading your email
Who’s reading your email?
Hirschtick on the cloud, CAD, and the future
china-manufacturing-future-image
Is China’s manufacturing future in trouble?

DESIGN GUIDE LIBRARY

“motion

Enews Sign Up

Motion Control Classroom

Design World Digital Edition

cover

Browse the most current issue of Design World and back issues in an easy to use high quality format. Clip, share and download with the leading design engineering magazine today.

EDABoard the Forum for Electronics

Top global problem solving EE forum covering Microcontrollers, DSP, Networking, Analog and Digital Design, RF, Power Electronics, PCB Routing and much more

EDABoard: Forum for electronics

Sponsored Content

  • Renishaw next-generation FORTiS™ enclosed linear encoders offer enhanced metrology and reliability for machine tools
  • WAGO’s smartDESIGNER Online Provides Seamless Progression for Projects
  • Epoxy Certified for UL 1203 Standard
  • The Importance of Industrial Cable Resistance to Chemicals and Oils
  • Optimize, streamline and increase production capacity with pallet-handling conveyor systems
  • Global supply needs drive increased manufacturing footprint development

Design World Podcasts

June 12, 2022
How to avoid over engineering a part
See More >
Engineering Exchange

The Engineering Exchange is a global educational networking community for engineers.

Connect, share, and learn today »

Design World
  • Advertising
  • About us
  • Contact
  • Manage your Design World Subscription
  • Subscribe
  • Design World Digital Network
  • Engineering White Papers
  • LEAP AWARDS

Copyright © 2022 WTWH Media LLC. All Rights Reserved. The material on this site may not be reproduced, distributed, transmitted, cached or otherwise used, except with the prior written permission of WTWH Media
Privacy Policy | Advertising | About Us

Search Design World

  • Home
  • Technologies
    • 3D CAD
    • Electronics • electrical
    • Fastening & Joining
    • Factory automation
    • Linear Motion
    • Motion Control
    • Test & Measurement
    • Sensors
    • Fluid power
  • Learn
    • Ebooks / Tech Tips
    • Engineering Week
    • Future of Design Engineering
    • MC² Motion Control Classrooms
    • Podcasts
    • Videos
    • Webinars
  • LEAP AWARDS
  • Leadership
    • 2022 Voting
    • 2021 Winners
  • Design Guide Library
  • Resources
    • 3D Cad Models
      • PARTsolutions
      • TraceParts
    • Digital Issues
      • Design World
      • EE World
    • Women in Engineering
  • Supplier Listings