pcmagnetwork logo
Subscribe!

John C. Dvorak

Plus Main Dvorak
Dvorak 01/05/09
Top Web Sites 2008
Product Guides
top sellers
shop now

Find great products
and great deals.
Shop for:

(enter product name
or keywords)
in:

The 30th Anniversary of the (No Good) Spreadsheet App

Dvorak

Spreadsheets have elevated the once lowly bean counter to the executive suite—and enabled him to make some truly horrible decisions.

2009 marks the 30-year anniversary of the now-ubiquitous spreadsheet program. And society as a whole has deteriorated ever since its invention. It was the spreadsheet that triggered the PC revolution, with VisiCalc the original culprit. Can anyone say that we've actually benefited from its invention? Look around: I think we've suffered.

For one thing, the spreadsheet created the "what if" society. Instead of moving forward and progressing normally, the what-if society questions each and every move we make. It second-guesses everything. Because of the spreadsheet we've been forced to "do the numbers" whenever possible; once the numbers are in the spreadsheet, the what-if process can begin.

In fact, the spreadsheet has resulted in the rise of the once-lowly accountant/bean counter to a position of influence—and often the executive suite. How often in years past—the pre-spreadsheet era, that is—did an accountant take over a company? When and why did the CFO become a title? These people, at best, were once known as comptrollers.

The spreadsheet became a sword, and the accountants knew how to wield it.

And yes, while all the pundits and visionaries talk about business intelligence and modern practices and this and that, where's the evidence of improvement in the way business runs or works? Cars are shoddy, consumer goods are junk. Toxic substances are in the food supply. Lead is in toys. Most of what we buy is made cheaply elsewhere. At every level of the business scene today, some bean counter does a what-if calculation before making the decisions. The spineless CEO worries about what the shareholders would think if he disagreed with what the spreadsheet and the CFO told him to do. To make him feel better, the board will give the CEO a fat bonus for saving money.

The what-if society has marched forward with little actual regard for the customer. If the customer has a complaint, she can call someone in India—someone doing customer support there because the spreadsheet told the company it could save 1 cent a year on phone costs. There's no way this idea would have evolved without spreadsheets.

By letting a program designed for accountants tell you what to do and what to think, you end up with an economic meltdown. The mechanism itself is flawed. Nobody ever wants to talk about the flaw with spreadsheets, do they? Most spreadsheets are, in fact, fiction, or even fantasy.

This is what caused the mortgage crisis: Spreadsheets instead of people were making decisions on loans. Soon these loans were wrapped up into neat financial packages all based on spreadsheet accounting. Brokers gave these packages high, triple-A financial ratings because the spreadsheet told them to. All spreadsheets, except the most mundane, are flawed in one way or another. You guess what the growth rate might be. You guess at the future cost of goods. You play what-if until you get what you want. There's a lot of guessing games played with spreadsheets. This is a flaw.

The Enron scam and the more recent oil price scam were both developed with spreadsheet modeling. "What if we could fix prices?" they asked. Click, click, click. Wow!

So this is the 30th anniversary of the spreadsheet and the subsequent rise of the accountant—the guy calling the shots and doing the deals. This class of people, once known for their meekness and wonkery, has become so powerful that they have managed to protect their common incompetence (see Enron, MCI, and Madoff, among other screw-up examples) by instituting Sarbanes-Oxley, essentially a law that protects them in any situation that involves them.

I don't blame any of these folks for taking advantage of the spreadsheet and the evolution of what-if. But why give them the keys to the car when you knew they couldn't drive? Look around and see what's happened. You can thank the spreadsheet for all of this junk. Happy birthday.

More John C. Dvorak:
The 30th Anniversary of the (No Good) Spreadsheet App
Summarizing the Death Throes of 2008
Retro Computing and the Cloud
The Wireless Conundrum
Why Has Google Demanded a "Fast Lane"?
more

Go off-topic with John C. Dvorak.

CrankyGeeks

See John get cranky about technology in his new Cranky Geeks IPTV Show.

newsletters

Get PCMag.com's FREE email newsletters delivered to your inbox.

It's easy, just follow the steps.

Want more? Check out our other newsletters here.

Manage your newsletter subscriptions here.

1. Make your selections:

Daily News Alert
Inside PCMag.com
PCMag.com Small Business Update
PCMagCast Update
Productwire: First Looks Update
Security Watch
Tech Saver
Tip of the Day
Utility Library Update
What's New Now
PCMag Announcements

2. Select email format:

3. Enter email address:


NoteWhen 3: Clear the Clutter. Version 3




NoteWhen 3: Clear the Clutter. Version 3 adds many features that you, our subscribers, have been asking for. You can now:

Send notes by e-mail, including Gmail or secure servers
Synchronize notes with notes from other machines
Lock notes to prevent further editing
Archive notes, taking them out of the list without deleting them
View scheduled events on a bigger calendar showing note titles
Make NoteWhen portable for flash drives
Export notes to HTML, RTF, Text, or CSV
Print a list of notes

Download Now: NoteWhen3Setup.zip
PCMagCast
PC Magazine's live, online events make you more productive at work, home, and on the go. Best of all, they're FREE!

Featured Event:

Fighting the Economic Downturn: How Technology Can Help You Save Money
Sponsored by Dell SB360
Find the tools and best practices to cut cost and improve your business's productivity with technology. Start the course today.

See all PCMagCasts >>
 
More Free PCMagCasts:

On-Demand Applications: Easy Ways for Your Business to Work Online
Sponsored by Dell Sb360
We walk you through the best on-demand offerings and what they can do for your business. Attend now.

Virtualization: How Small Businesses Can Save Money and Boost Efficiency
Sponsored by Dell SB360
This course delves into how server strategies at small businesses can be optimized with virtualization, and how multiple operating systems can be efficiently deployed on single systems for networked use. Attend today.
 


Info Centers
 
Special Offers