• Advertise
  • Contact Us
  • Supplier Directory
  • SCB YouTube
  • About Us
  • Login
  • Subscribe
  • Logout
  • My Profile
  • LOGISTICS
    • Air Cargo
    • All Logistics
    • Facility Location Planning
    • Freight Forwarding/Customs Brokerage
    • Global Gateways
    • Global Logistics
    • Last Mile Delivery
    • Logistics Outsourcing
    • LTL/Truckload Services
    • Ocean Transportation
    • Parcel & Express
    • Rail & Intermodal
    • Reverse Logistics
    • Service Parts Management
    • Transportation & Distribution
  • TECHNOLOGY
    • All Technology
    • Artificial Intelligence
    • Cloud & On-Demand Systems
    • Data Management (Big Data/IoT/Blockchain)
    • ERP & Enterprise Systems
    • Forecasting & Demand Planning
    • Global Trade Management
    • Inventory Planning/ Optimization
    • Product Lifecycle Management
    • Robotics
    • Sales & Operations Planning
    • SC Finance & Revenue Management
    • SC Planning & Optimization
    • Supply Chain Visibility
    • Transportation Management
  • GENERAL SCM
    • Business Strategy Alignment
    • Customer Relationship Management
    • Education & Professional Development
    • Global Supply Chain Management
    • Global Trade & Economics
    • Green Energy
    • HR & Labor Management
    • Quality & Metrics
    • Regulation & Compliance
    • Sourcing/Procurement/SRM
    • SC Security & Risk Mgmt
    • Supply Chains in Crisis
    • Sustainability & Corporate Social Responsibility
  • WAREHOUSING
    • All Warehouse Services
    • Conveyors & Sortation
    • Lift Trucks & AGVs
    • Order Management & Fulfillment
    • Packaging
    • RFID, Barcode, Mobility & Voice
    • Warehouse Automation
    • Warehouse Management Systems
  • INDUSTRIES
    • Aerospace & Defense
    • Apparel
    • Automotive
    • Chemicals & Energy
    • Consumer Packaged Goods
    • E-Commerce/Omni-Channel
    • Food & Beverage
    • Healthcare
    • High-Tech/Electronics
    • Industrial Manufacturing
    • Pharmaceutical/Biotech
    • Retail
  • THINK TANK
  • WEBINARS
    • On-Demand Webinars
    • Upcoming Webinars
    • Webinar Library
  • PODCASTS
  • WHITEPAPERS
  • VIDEOS
Home » Tough Love for Spreadsheets: It's Time They Were Sent Packing

Tough Love for Spreadsheets: It's Time They Were Sent Packing

August 26, 2009
Greg Baxter, President, Baxter Planning Systems

We've all seen the plot. Something helpful and friendly comes into our lives, and we make it part of our routine. But then it grows out of control and becomes a monster, knocking down neighborhoods, stock exchanges and even whole economies.

We might feel like we're living through that horror movie now.  But there's another menace out there that hasn't gotten the attention it deserves, even though it has cost companies and consumers billions and played a central role in the demise of some formidable institutions.  It sits on nearly every PC in the world, and it goes by the name of Excel, Quattro Pro, Numbers and lesser-known brands.

Yes, it's our common electronic spreadsheet, and some of its more notable snafus include a $2.4bn overstatement of dividends by Fidelity Investments, and the artificial inflation of U.S. natural gas prices by as much as $1bn. Faulty spreadsheets also led to the undoing of Enron, WorldCom and Parmalat, the Italian food and dairy conglomerate.

Although this year marks the 30th anniversary of the electronic spreadsheet, its problems continue unabated. Just ask Barclays.  A formatting error on an Excel program put the investment giant on the hook for millions in Lehman Brother legacy assets that they did not intend to buy.

How did we get to this point, and why don't we do something?

First a confession.  I did my part in feeding this menace. When I was fresh out of college, I was tasked with developing a service parts inventory system for a major high-tech company.  Around the same time, a wonderful new tool had come on the market called VisiCalc.

It was like a leap into the future. VisiCalc did all the calculations in a spreadsheet's cells automatically - without our having to re-enter them.  And it fit easily on every computer terminal. I encouraged my Fortune 250 company to use the program, and for the first time ever, service parts became consistently available when and where we needed them.  Moreover, we saved millions of dollars by not over-investing in stock levels.

VisiCalc was soon replaced by Lotus 1-2-3, and suddenly the new child in our midst had become a vibrant teenager.  It could drive more numbers, develop graphics and perform database operations. But already it was giving us headaches, as if it had a teenage mind of its own.  If someone in our company entered data inconsistently, or changed a variable, or came up with a homegrown application, our calculations would be off, frequently without our knowledge.  And despite the greater sophistication of spreadsheet products over the years, they continue to be unreliable. One research study found that through the late 1990s and early 2000s, an average 94 percent of organizational spreadsheets contained errors.

There have been attempts to rein in spreadsheets, such as dedicated planning systems and packaged software.  But these solutions require constant updates and heavy investment in IT infrastructure, not to mention an inordinate amount of staff hours.  So, most organizations continue to depend on spreadsheets, despite their adolescent tendencies - such as driving a company into the ditch now and again.

There is an alternative, however, to arrested technological development.  And that alternative is tough love.  Throw the teenager out - or, at least, off the premises.

In the small company I run now, which enables much larger companies to optimize their supply chain management, we've gone through a number of solutions.  The best one turns out to be something called software as a service - or SaaS, for short - just the thing for an unruly teenager.

SaaS basically takes all the inputs that once went into the end-user spreadsheet and sends them to an off-site IT system, where designated techies control the data.  Your organization can still request models, reports, communications and a wide variety of data analyses.  But SaaS has taken the keys away - the ones on the PC - as far as the spreadsheet functions go.

The advantages over spreadsheets are several.  Data inputs are more secure.  Software updates are tested for soundness and then automatically deployed.  And investment in IT infrastructure is minimal.  SaaS does require organizations to trust others with their data.  And it represents a tightening of end-user control, which might seem counterintuitive in this age of ever-downward shifting power.  But as we move toward smart grids, electronic healthcare reports and other forms of societal digitization, SaaS provides a 21st Century technology that is up to the task.

Meanwhile, error-prone spreadsheets continue to underpin such critical functions as financial reporting, data storage, supply chain management and regulatory compliance -feeding future debacles that are largely hidden from us.  With so much at stake, isn't it time we forced this underachiever to leave home and join the networked world?

    RELATED CONTENT

    RELATED VIDEOS

    Technology Cloud & On-Demand Systems Business Strategy Alignment Global Supply Chain Management Quality & Metrics
    KEYWORDS Business Strategy Alignment Cloud, SaaS & On-Demand Systems Global Supply Chain Management Quality & Metrics Technology
    • Related Articles

      How Supply Chain Experts Said They Were Handling the Peak Season Rush

      Despite Their Growth, Many Companies Cutting Costs Like They Were in Trouble

      America’s Love for Cheap Drugs Has a Hidden Cost

    Greg Baxter, President, Baxter Planning Systems

    More from this author

    Subscribe to our Daily Newsletter!

    Timely, incisive articles delivered directly to your inbox.

    Featured Product

    Popular Stories

    • A TRUCK WITH ITS CONTAINER DOOR OPEN SITS UNDER A SIGN THAT READS INTERNATIONAL BORDER COMMERCIAL TRUCKS

      Importers Into Mexico Can No Longer Delay Complying With New Customs Declaration Law

      Data Management (Big Data/IoT/Blockchain)
    • 018_how_3pls_can_get_started_with_ai_v1-(540p).png

      Watch: How 3PLs Can Get Started With Automation

      Logistics Outsourcing
    • An employee in a warm suit crouches down to get boxes of food ready for shipping at a warehouse

      Packaging Optimization Is Boosting Cold Chain Growth

      Air Cargo
    • A FIGURE IN CAMOUFLAGE LOOKS THROUGH A SCOPING DEVICE AT A SHIP IN THE DISTANCE, BELCHING SMOKE

      Strait of Hormuz Ship Transits Are Rising Thanks to U.S. Help

      Global Gateways
    • Heat Haze Distorts Video of Semi-Trucks Driving Down an Interstate Surrounded by Mountains on a Sunny Day

      The Biggest Challenges Facing Logistics Operators This Summer

      Logistics

    Digital Edition

    2026 esg cover main scb q2 2026 cover

    SupplyChainBrain 2026 ESG Guide: ESG — The Supply Chain’s Biggest Secret

    VIEW THE LATEST ISSUE

    Case Studies

    • Recycled Tagging Fasteners: Small Changes Make a Big Impact

    • A GRAPHIC SHOWING MULTIPLE FORMS OF SHIPPING, WITH A HUMAN STANDING AT THE CENTER, TOUCHING A SYMBOLIC MAP OF THE WORLD

      Enhancing High-Value Electronics Shipment Security with Tive's Real-Time Tracking

    • A GRAPHIC OF INTERLACING HONEYCOMBED ELEMENTS REPRESENTING GLOBAL BUSINESS TRANSACTIONS

      Moving Robots Site-to-Site

    • JLL Finds Perfect Warehouse Location, Leading to $15M Grant for Startup

    • Robots Speed Fulfillment to Help Apparel Company Scale for Growth

    Visit Our Sponsors

    4flow Arkieva Blue Yonder
    Carton Cloud CoEnterprise Dassault
    Duravant E2Open General Logistics Systems
    Hy-Tek iGPS Korber
    Lyngsoe Procurability Quinyx
    SAP Sikick Systech
    S&P Global Mobility TADA TransImpact
    US Bank Werner Enterprises WSI
    • More From SCB
      • Featured Content
      • Video Library
      • Think Tank Blog
      • SupplyChainBrain Podcast
      • Whitepapers
      • On-Demand Webinars
      • Upcoming Webinars
    • Digital Offerings
      • Digital Issue
      • Subscribe
      • Manage Email Preferences
      • Newsletters
    • Resources
      • Events Calendar
      • 2026 Event Coverage
      • SCB's Great Supply Chain Partners
      • Supplier Directory
      • Case Study Showcase
      • Supply Chain Innovation Awards
      • 100 Great Partners Form
    • SCB Corporate
      • Advertise on SCB.COM
      • About Us
      • Privacy Policy
      • Contact Us
      • Data Sharing Opt-Out

    All content copyright ©2026 Keller International Publishing Corp All rights reserved. No reproduction, transmission or display is permitted without the written permissions of Keller International Publishing Corp

    Design, CMS, Hosting & Web Development :: ePublishing