Over the past few years, I’ve also been using Google Sheets (part of the Google Docs family) as my project management tool of choice. It’s quick, simple, and particularly useful for sharing project status with geographically distributed teams, which is becoming more and more important in today’s global workforce.
Here are a few more benefits:
- Much of the common Microsoft Excel functionality is mirrored in the Google Spreadsheets. If you know how to use Excel, you already know how to use Google Spreadsheets.
- Very flexible in terms of visual formatting options (fonts, colors, row/column sizes, etc…). It will probably do anything that you need.
- Changes and user actions are shown in real-time. When holding web conferences, all users can see as other members select and edit cells.
- Built-in version control.
- Built-in user permissioning. This allows you to give read/write access to specific users.
- Does not require users to download and install plugins*.
- Mobile friendly, and now available for offline editing.
- And, of course, it’s free. You can start using it as a proof of concept and explore its benefits/limitations before investing in a paid tool that might fit your needs more specifically.
So let’s dig into some specifics of using the tool for Agile project management.
I’ve developed a template over the years for both high-level and detailed Agile project management. It’s available for digital download for just $15 (via PayPal). Click on the button below to purchase and download immediately.
The template contains 2 sheets:
- Project Overview – Can be used for high-level planning and reporting of tasks.
- Individual Sprint Planning – This can be used for detailed day-to-day task management (ie. daily scrums). It contains a task list with estimates, a daily planner, and burn-down chart.
The first sheet, Project Overview, is a basic Gantt chart with the x-axis displaying the project timeline in quarters, project week number (week 1-n) and calendar week (ie. week of May 5, 2014). Project activities are listed vertically on the page and may be further categorized into sprints and sub-categories. Length and status of each activity is represented by the colored cells – green for “completed”, yellow for “in progress”, and blue for “planned”. Unfortunately, I haven’t linked this sheet to the remaining sheets, I might tackle that in a subsequent update.
The second sheet contains three parts that are linked and work together. This is the sheet that you can use for daily task management and stand-up scrums.
The first table (Task Estimation) is the task list with time estimates for each task. In an Agile environment, you might collect these from each responsible team member by using the planning poker method for task estimation. We would typically anchor each task to a specific wireframe (Wireframe ID column) or perhaps a numbered visual design.
The second table (Daily Planning) shows the daily work planned for the life of the project. Day/dates are listed vertically, and the total estimated hours for the project is taken from the sum of all tasks in the previous table. Estimating the hours in the “Daily Work > Planned” column is a tricky art – it must take into account how much time your resources are dedicating to this project vs. other responsibilities, vacations/holidays, and how many productive hours each person has in the work day. For the latter, we would typically assume 5 hours (in a typical work day of 8 hours, we allocated 3 hours for resources checking email, watching YouTube videos of bears falling out of trees, etc…)
The Burn Down chart at the bottom of the page is automatically generated from the Daily Planning table. The graph follows the planned remaining hours in the project vs. the actual remaining hours in the project. The closer the two lines are to each other, the more accurately you have planned.
So that’s it! Hope these templates can be useful for your future projects, and let me know if you have any questions. Again, the template is available for digital download for just $15 (via PayPal). It will download as Excel format which you can use natively, or simply upload to Google drive and open it there.
* This attribute is actually quite important – I can’t begin to estimate how much time we’ve lost and frustration caused over the years trying to get screen-sharing apps like GoToMeeting, WebEx, etc… to work on everyone’s computers, some with slow internet connections, company firewalls, lack of administrative rights for plugin installation, etc… With Google docs, you can simply have a phone conference and collaborate white-board-style using nothing but your browser.
Leave a ReplyWant to join the discussion?
Feel free to contribute!
Leave a Reply
You must be logged in to post a comment.
Very cool. Thank you for the overview.
Thank you for sharing this big big big work !
Thank you for sharing
Thanks for sharing, Charles.
Thank you so much for sharing this template!
We need more people willing to share their good practices with the community.
Kind regards from Montréal!
Hey very good article, this is exactly what I have been looking for. Thanks a lot for sharing.
I have a question please.. what is the definition of a sprint as per the gantt chart? I was under the impression a sprint encapsulates a set of deliverables to be submitted within a certain timeframe like ranging from a week to a month..
Thanks for the comment eg0maniac. In the chart, the sprint can encapsulate any time period that your organization uses. In scrum, teams generally use a fixed delivery cycle, typically around 2 weeks. In my previous company, we didn’t have a fixed delivery cycle – I believe this is called “Kanban” methodology. So we would define a set of requirements or functionality into a sprint and it would get done when it would get done. We purposefully did not promise a specified delivery date. It was a hard transition for stakeholders initially, but we won them over when they saw that we were producing things constantly and at a faster rate than before. Hope this answers your question.