Decision Mechanics

Insight. Applied.

  • Services
    • Decision analysis
    • Big data analysis
    • Software development
  • Articles
  • Blog
  • Privacy
  • Hire us

Data organization in spreadsheets

November 16, 2017 By editor

Karl Broman and Kara Woo offer some good advice on organizing data in spreadsheets.

They advocate confining the use of spreadsheets to data entry and storage—moving calculations and visualizations to other tools. This certainly avoids some of the biggest problems with using spreadsheets.

However, spreadsheets don’t enforce any discipline. It’s up to the user to be vigilant and do the right thing. People are bad at maintaining consistency. Computers are excellent at it. Why make it hard for ourselves?

Spreadsheets. Just say no.

Print Friendly, PDF & Email

Share this:

  • Twitter
  • LinkedIn
  • Facebook

Filed Under: Data analysis, Data science Tagged With: spreadsheets

Search

Subscribe to blog via e-mail

Subscribe via RSS

Recent posts

  • Spreadsheet error delays opening of children’s hospital
  • 16,000 coronavirus cases missed by Excel
  • 20 cognitive biases that affect your decision-making
  • The science of decision-making and data
  • Confidence intervals

Copyright © 2021 · Decision Mechanics Limited · info@decisionmechanics.com