• Home
  • Assertions
  • Poetry
  • Programming

Record and Reverie

General things I find interesting

Feed on
Posts
Comments
« Digital TV Delay
Growing Sense of Entitlement »

Why I Hate Microsoft Software

Mar 18th, 2009 by Graham Booker

So, I occasionally get asked why I hate Microsoft software so much, and today was a great example of my rationale.

I was working with a tremendous amount of data within Excel. Due to how the data was generated, I actually needed the transpose of the data in the spreadsheet. I spent nearly an hour trying to find the transpose function which used to be in the “Paste Special” function, but now appears to have been removed. I searched the help, and found nothing helpful. Google’s results pointed to the “Paste Special” function which I know no longer contains a transpose.

End result: I wrote a small program which conducts the transpose within it. It reads the input file, performs the transpose, and write the result.

  • Time wasted trying to find a function Excel used to have: 1 hour
  • Time it took to write the program to do the job: 5-10 minutes
  • Time the program took to execute: 1-2 seconds

Due to a site license deal with my University, I only paid $20 for office, but I don’t think it’s even worth that. I lost an hour of my time due to the fact that one of the few functions I actually use was removed. After all this, Microsoft likely wonder why I turned down a job offer to work for them.

Posted in General

2 Responses to “Why I Hate Microsoft Software”

  1. on 19 Mar 2009 at 1:20 pm1Paul

    Out of curiosity I thought I would look at Excel’s Paste Special and there is a transpose radio button just above the cancel button. This is the Mac version 2008 though, and I am not sure what you have. Wish our university would offer a $20 license.

  2. on 20 Mar 2009 at 12:47 pm2Graham Booker

    Paul,
    I can see it there now, but it was not there when I was looking for it. Perhaps I was using too large of a dataset (Excel was already being very very clunky because I had so much data). Interestingly enough, my transpose function took 1-2 seconds to read the data, transpose it in memory, and write it out to a new file when Excel took over 10 seconds to just read it, and I didn’t even write my function for speed.

  • Recent Posts

    • Incorrect Podcast Order on my iPod
    • Text Compression Techniques
    • New Car
    • Using Newer Subversion in Xcode
    • Working With Core Data
    • Growing Sense of Entitlement
  • Archives

    2021
    2020
    March 2020 (1)
    2019
    November 2019 (1)
    2018
    June 2018 (1)July 2018 (1)December 2018 (1)
    2017
    January 2017 (2)June 2017 (1)August 2017 (1)
    2016
    June 2016 (1)August 2016 (1)
    2015
    January 2015 (1)February 2015 (1)December 2015 (1)
    2014
    June 2014 (1)July 2014 (1)August 2014 (2)
    2013
    February 2013 (2)March 2013 (1)April 2013 (1)June 2013 (1)November 2013 (1)
    2012
    April 2012 (2)May 2012 (1)June 2012 (1)November 2012 (1)
    2011
    January 2011 (1)October 2011 (1)November 2011 (1)December 2011 (1)
    2010
    February 2010 (2)April 2010 (1)June 2010 (1)July 2010 (1)August 2010 (1)September 2010 (1)October 2010 (2)December 2010 (3)
    2009
    January 2009 (1)February 2009 (1)March 2009 (2)May 2009 (1)July 2009 (3)September 2009 (1)
    2008
    January 2008 (1)February 2008 (4)March 2008 (1)April 2008 (6)May 2008 (1)June 2008 (3)August 2008 (1)September 2008 (2)October 2008 (2)December 2008 (1)
    2007
    January 2007 (1)February 2007 (4)March 2007 (5)April 2007 (4)May 2007 (1)June 2007 (6)August 2007 (3)September 2007 (3)November 2007 (3)December 2007 (4)
    2006
    January 2006 (4)February 2006 (10)March 2006 (4)April 2006 (6)May 2006 (2)June 2006 (4)July 2006 (1)August 2006 (1)September 2006 (4)October 2006 (6)November 2006 (3)December 2006 (3)
    2005
    October 2005 (6)November 2005 (13)December 2005 (1)
    2004
    February 2004 (2)March 2004 (1)April 2004 (1)May 2004 (6)June 2004 (6)July 2004 (3)August 2004 (2)September 2004 (1)November 2004 (5)
    2003
    September 2003 (1)October 2003 (3)November 2003 (1)December 2003 (1)
  • Categories

    • Breakaway (5)
    • Family (4)
    • Friends (2)
    • General (148)
    • Nature Pictures (8)
    • Politics (2)
    • Programming (41)
    • School (11)
    • SysAdmin (8)
    • Teaching (2)
  • Tags

    AC3 Ads Code Frontrow Java Objective-C Open Source Perian Perl permissions plex plugin RSS Sapphire School Servers ZFS

  • Pages

    • Assertions
      • Female Friends Who Won’t Date You
      • Not Dating Friends
    • Poetry
      • Curtis Staying Over
      • Girl Questions
      • Scaring Girls Off
      • Summer’s End
    • Programming
      • Fire Development
      • Kyocera Ringtone Converter for the Mac
      • Perian
      • Text Compression

Record and Reverie © 2021 All Rights Reserved.

WordPress Themes | Web Hosting Bluebook