DevOps Zone is brought to you in partnership with:

Having worked as both a developer and an operations manager, I’ve gotten all too familiar with the ever widening gap between what developers and customers consider “done”. In order to help narrow this, I’d like to share some of my ideas and experiences concerning the software development processes with a vision towards actually releasing what customers need. Daniel is a DZone MVB and is not an employee of DZone and has posted 27 posts at DZone. You can read more from them at their website. View Full User Profile

Why Excel Spreadsheets Hurt Project Management

07.21.2011
| 6075 views |
  • submit to reddit
Today was a great day. I helped import our entire “roadmap” of functional requirements from an Excel spreadsheet into Pivotal Tracker. Even though we allocated almost a half-day to accomplish this, it was done in less than two hours (including in-depth descriptions and backgrounds on many features I hadn’t yet seen).

The product manager’s eyes lit up when I showed him how priorities were set (drag & drop, top story rules) and how easy it was to add screenshots to stories (again drag & drop). He spoke often about the pain that spreadsheet caused him and the entire team. Ironically enough, just before we were to sit down and do the migration, he realized he’d lost the changes to the spreadsheet made last week in the team meeting! A fitting farewell from an overly abused project management tool.

Creative Commons License Elaine with Grey Cats

 


Lack of Transparency

Unless you’re using Google Docs or are a “lucky” user of the new MS Office 365, you’re spreadsheet program is most likely Microsoft Excel. Doing PM using Excel is like playing darts in the dark. Though it might be exciting for the “thrower” (Project Manager), the rest of the team is cowered in the corner hoping not to get hit.

The PM finishes editing the spreadsheet, and attaches it to an email sent around to key stakeholders and the big boss. Other edits are made and sent back to the PM who has to manually merge the changes back into the “master” file. Maybe you’re lucky and this “master” file lives on a shared network drive.

Even so, how many copies of this spreadsheet have been distributed? When you show up to project meetings, it’s not surprising to see teammates frantically clutching months-old project plans in their sweaty fists – half-convinced they’ve blown the release date.

Agile project management demands one online, accessible plan shared to the entire team. Features and functionality are updated so quickly today (even in large enterprises), that trying to keep up with an email file attachment is just ridiculous.

Lack of Clarity

Spreadsheets are optimized for one thing – calculations. Oh, and they make pretty graphs. Project management? Check out cell G9 : =$A$4-B$7. WTF?

Regardless how the PM tries to push a feature matrix into a spreadsheet, it comes out half-assed and confusing to everyone else in the room. We’re all considerate human beings and we really try to understand what the guy meant when he created this thing last nite at 1:30am, but it’s hard.

Then there’s this unspoken rule about never deleting anything from the spreadsheet. Because, after all, there’s no version control or history available on this thing, right? So there are items that are “struck-out” or grayed-out (or both) – reminds me of the current problem we have up in orbit with space debris.

Between the chaotic layout and ever-growing cruft, it’s damn near impossible to sort through one of these sheets a year into the project.

If you’re serious about project management, invest in a real tool (online or offline) and get the hell out your team’s way!

Insufficent tools cause bifurcation

As the spreadsheet is such a pain, you can’t do ad-hoc type requests there. Take bugs, for example. Since we needed a real tool for managing these, the decision was taken to use Sharepoint’s BugTracker – an intranet based tool that is hard to use, harder to understand and provides little integration with non-Microsoft based source code repositories and build tools.

This is next on my list of TODOs – migrating these bugs directly into Pivotal Tracker. Afterwards, we’ll have a single source of truth for our project management process and a much better overview of who’s working on what and when we can expect certain features to be delivered.

What are the strangest project management tools you’ve run across in your work?

References
Published at DZone with permission of Daniel Ackerson, author and DZone MVB. (source)

(Note: Opinions expressed in this article and its replies are the opinions of their respective authors and not those of DZone, Inc.)

Comments

Marco Tedone replied on Fri, 2011/07/22 - 4:23am

From the above it seems your organisation is following a structured approach (waterfall? UP?). Have you considered moving to Agile, where there is no PM or architect but indeed a team with a product owner (and a Scrum Master for young teams)?

I'm team lead in an Agile project and I use Excel to publish things such as sprint burndown, team's velocity, technical debt, etc. and for these kind of things I find Excel to be great (mind that on a scale of 1-10 of Microsoft fans, I probably sit within the -1 range).

Daniel Ackerson replied on Mon, 2011/07/25 - 1:44pm

Yes, they have done waterfall style PM for over 20 years. Part of my job is to get the web development team started with Scrum (which I've started rolling out today with the migration to PT). It's going to be a difficult transition, but good news is the web guys have already been doing multiple releases per week. PivotalTracker supplies a lot of those graphs and reports you do out of the box - I highly recommend the tool.

Michael Lynn replied on Sat, 2013/01/19 - 10:46am

Daniel,

Intelligent and insightful article.  I think you are correct in your assertions regarding Excel and its primary usefulness being calculations.  However, I feel like that assumes users are leveraging Excel out of the box.  There are some Excel PM templates out there (one which I put together http://www.mlynn.org/2012/09/excel-project-planning-spreadsheet-updated-version-3  that provide project managers (as well as those responsible for managing projects that are not necessarily PM's by title) with free options that jump start their efforts and leverage a tool that they, and most likely their project team already own.  

Not arguing against higher potential tools such as Pivotal Tracker for the advanced PM and task leader... just offering another perspective.

Thank you for your insights.

Regards,

Michael

http://www.mlynn.org 

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.