Chris Johnston

Web development and design with a little VFX thrown in for fun
  • Home
  • About Me
  • Contact Me
  • Projects
  • Resume

Spreadsheats

Published by Chris Johnston on November 15, 2007 10:13 pm under Application Development, General

There is one thing about business that I don’t understand, why is it that the only application that business people seem to use is Excel Spreadsheet. I have seen people open Excel to simply take notes. Is there an MBA course called Spreadsheets 101? I think this is the biggest example of the hammer/nail principle.

What always worries me the most, though, is when businessy/management types try to manage projects using spreadsheets; everything needs to be recorded, tallied, and accounted for. Somewhere along the line the people get lost in all the numbers and cells.

I can’t quite put my finger on why exactly I dislike Excel, but I do. Maybe it is the formula/math part of it or maybe it is the fact that people try to use it for everything. Maybe it is just that I have had to create far too many programs where the specs where put into giant, multi-page spreadsheets which require a committee and several days or weeks to change. I think I’m just tired of trying to understand mapping instructions from spreadsheets that require 3 monitors to display the whole thing.

5 Comments so far

  1. Prashant Gandhi on November 16th, 2007

    Chris,

    I think you will find that it is the failure of IT to provide a tool that allows the business users to play around with figures that makes them use it. Put yourself in a position of a trader who has made a number of buys and sells today. It would be ideal if someone told him what his P&L is, what his exposure is and what the trend has been. Unfortunately for the trader, the IT are doing their own stuff building large platforms to cater to all the world’s problems. In the meanwhile, the business has to go on as usual and the spreadsheet seems to be the best compromise.

    regards,
    Prashant
    Batting on behalf of spreadsheet lovers of the world

  2. JZ on November 16th, 2007

    What a successful business tool – the spreadsheet! It actually has most features needed by the business people, who has completely different view of technology from that of the technical people. Spreadsheet is easy to learn and use – for the basic part; it also can do a lot of complex data analysis other than just recording the data. The speed to process the data is fast, compared to any popular web application. There is no need to learn how to write a program to draw a diagram like the Matlab, however, the savvy users will write some macros. People now talked about the Excel is an excellent example of DSL for the business domain. Of course, it is not a tool for specific purpose.

  3. Chris Johnston on November 17th, 2007

    I actually agree with both posts. I think Excel is probably the most successful application ever created. I just don’t think it should be used to record the minutes from a meeting or be the sole tool used in recording the metrics from a particular project.

    My argument is not with the tool or the proper use of the tool, it is with all the useless things I see people using it for. It just seems to be ingrained in business people that there computer equals Excel so everything gets done in Excel.

  4. matt m on November 17th, 2007

    I am really getting into Google Spreadsheets-: Multi-user adds a whole new dimension to it, you can see other users updating data in other cells. Fun.

  5. SJ on November 24th, 2007

    I think your post is rather pointless to put it bluntly. I mean if you have a problem with users using excel for “useless things” then you really don’t understand good software. In any case if a user decides to use excel rather than word or notepad to take down meeting minutes you have to ask yourself why? I don’t think using a software for other purposes than its intended use is really useless. In fact some people base this on good software. Software thats used for other purposes than its original intended purpose… isn’t that why we try to develop flexible useful software?

Posting your comment.

  • Search

  • Categories

    • .NET (2)
    • Agile (41)
    • Apple Mac (15)
    • Application Development (124)
    • Articles (4)
    • ColdFusion (2)
    • Demo/Tutorial (3)
    • Eclipse (1)
    • Flash (6)
    • General (567)
    • Git (1)
    • Google (1)
    • Hibernate (4)
    • J2EE (39)
    • Java (111)
    • Java Frameworks (5)
    • Links (1)
    • Linux (33)
    • Miscellanous (2)
    • NetBeans (3)
    • News (10)
    • Open Source (6)
    • Photography (2)
    • Programming (33)
    • Python (1)
    • Ruby (27)
    • Ruby on Rails (14)
    • Ruby on Rails Web Apps (1)
    • Software (14)
    • Spring (4)
    • Teaching (1)
    • TeamDocs (6)
    • Technology (2)
    • Test Driven Development (1)
    • Thoughts (33)
    • ThoughtWorks (8)
    • Tips and Tricks (1)
    • User Experience (1)
    • Web Design (7)
    • Web Development (37)
    • Wicket (1)
  • Archives

    • September 2009 (1)
    • June 2009 (1)
    • May 2009 (1)
    • April 2009 (7)
    • March 2009 (2)
    • February 2009 (6)
    • January 2009 (4)
    • December 2008 (3)
    • October 2008 (1)
    • September 2008 (2)
    • August 2008 (6)
    • July 2008 (4)
    • June 2008 (1)
    • May 2008 (8)
    • April 2008 (7)
    • March 2008 (2)
    • February 2008 (1)
    • January 2008 (5)
    • December 2007 (3)
    • November 2007 (4)
    • October 2007 (5)
    • September 2007 (2)
    • August 2007 (3)
    • July 2007 (6)
    • June 2007 (5)
    • May 2007 (5)
    • April 2007 (5)
    • March 2007 (6)
    • February 2007 (9)
    • January 2007 (16)
    • December 2006 (6)
    • November 2006 (15)
    • October 2006 (17)
    • September 2006 (27)
    • August 2006 (22)
    • July 2006 (14)
    • June 2006 (10)
    • May 2006 (18)
    • April 2006 (3)
    • March 2006 (6)
    • February 2006 (15)
    • January 2006 (7)
    • December 2005 (11)
    • November 2005 (8)
    • October 2005 (18)
    • September 2005 (24)
    • August 2005 (18)
    • July 2005 (21)
    • June 2005 (14)
    • May 2005 (23)
    • April 2005 (18)
    • March 2005 (34)
    • February 2005 (27)
    • January 2005 (27)
    • December 2004 (15)
    • November 2004 (17)
    • October 2004 (20)
    • September 2004 (10)
    • August 2004 (21)
    • July 2004 (9)
    • June 2004 (11)
    • May 2004 (4)
    • April 2004 (15)
    • March 2004 (12)
    • February 2004 (7)
    • January 2004 (17)
    • December 2003 (11)
    • November 2003 (8)
    • October 2003 (12)
    • September 2003 (12)
    • August 2003 (12)
    • July 2003 (23)
    • June 2003 (22)
    • May 2003 (14)
    • April 2003 (9)
    • March 2003 (22)
    • February 2003 (24)
    • January 2003 (32)
    • December 2002 (11)
    • November 2002 (16)
    • October 2002 (10)
    • September 2002 (9)
    • August 2002 (13)
  • Pages

    • About Me
    • Contact Me
    • Projects
    • Resume

Copyright © 2010 Chris Johnston
WordPress Theme based on Light Theme