Big Grandaddy of Excel Project Tracking

Big Grandaddy of Excel Project Tracking

Grandaddy of Project Tracking in ExcelI know my company sells project tracking services, but I’m the first to admit that some projects aren’t complex enough to need what I sell. So for folks out there who want a centralized way of keeping track of all your data, I offer you this bad boy for free!

If you’re familiar with PMI recommendations for keeping track of projects, or you need a way to perform Earned Value Analysis (EVA), everything you need is right here.

Every project I make up one of these, even if there’s a portfolio management system in place. Those big enterprise systems CAN handle much of this data but they’re not always the easiest to use, and sometimes, I just want something to play around with that doesn’t require a login. My other issue with portfolio management systems is that, as much intelligence can be built into them, sometimes I need to see more. Because this file is in Excel, it prints out, is easy to photocopy and bring along to meetings (shh! don’t tell the FSC!). Some clients are satisfied with a simple dashboard; others demand more detail. From a generic project perspective, everything they could need to see is right here (and it’s up to you what you do or don’t put on the table).

Inside this file, you’ll find the following sections:

  • A tab for milestones, where you can break your project into high level phases. This tab shows you relevant EVA data to your milestones if you need it, automatically filled in from your other tabs.
  • A tasks tab where you can enter the tasks in your project. You can set baseline information, and actual/revised dates. It even makes suggestions on new dates if one of your tasks slips.
  • A resource tab where you can enter all your project resources. This isn’t just people, it can be equipment or materials as well. Your resource rates go here, and that will calculate your project costs.
  • A detailed cost worksheet. This is where you would do the bulk of your work. Enter your baseline data, and then make modifications as you go through your project. If you have a lot of information here, use the autofilter buttons at the top to simplify your view.
  • A change request log.
  • A quality log.
  • An issues log, colour coded by severity, where you can monitor current activity and have a log of resolutions in case the issue crops up again. It also tracks the number of days to close issues.
  • A risk log to plan risk responses, that generates a (simple) risk score before and after mitigations.
  • A complete dashboard that tracks all aspects of your project on a single page to give your stakeholders.

I hope you enjoy this file. You’re free to use it however you like, and pass it around. You don’t even need to attribute it to Papercut, although hugs are free if you do! :-)

I’m a professor of project management at the college where I work. My students continually amaze me with their insights, passion and all-around awesomeness. I figure they deserve access to more answers than I can give them by myself. This site is for them.
  • PatrickRichard

    I'm stealing this! Once again a great free tool to impress my bosses with.

  • http://edge.papercutpm.com/ PapercutPM

    Wonderful! You are more than welcome to use it as you like my friend! :-)

  • http://www.mercuryminds.com/ Dongan

    Excellant tool!. thank you so much. Simple & Effective.

  • http://edge.papercutpm.com/ PapercutPM

    Thank you for your kind words, Dongan! I hope you enjoy it! :-)

  • Jameel Ahamed

    Thanks very nice.
    For sure I would like to use it.
    Thanks for Free ;-)

  • Lori LaBeau, PMP

    Very nice! I am impressed, thank you for sharing this with the rest of us!

  • amyalbright

    This is awesome! Thank you! I will certainly impress my stakeholders!

  • http://edge.papercutpm.com/ PapercutPM

    Thank you so much, Lori! Please use it as you like, and if you'd like to see changes, by all means post them here! :-)

  • http://edge.papercutpm.com/ PapercutPM

    Thank you very much, Amy. I hope it serves you well. :-)

  • http://edge.papercutpm.com/ PapercutPM

    You're very welcome, Jameel. Have fun with it! :-)

  • william

    what a great tool, thank you buddy

  • http://edge.papercutpm.com/ PapercutPM

    You're very welcome, my friend! I hope you get some good use from it! :-)

  • arunkulandai

    Hey…thanks for sharing this….i am surely going to use this in the current project.

  • johnmoverley

    I would like to try this out for real as I work as a consultant for government and they want reports of reports on projects. First impressions are pretty good. I would like to see if, and how it operates with Primavera. Many Thanks for the opportunity

    John Moverley

  • http://edge.papercutpm.com/ PapercutPM

    By all means, John! Thanks so much for the comment. Please let me know how it works for you! :-)
    I hope you'll find it a good complement to Primavera. Ultimately, Excel isn't particularly robust. But Primavera can be so complicated you can't easily slice data in the way you want without spending a lot of time. The workbook was really meant to be a nice medium between the two. Good luck!

  • Pingback: Risk Analysis Workbook «Papercut Edge

  • Pingback: Talking Work » Blog Archive » Risk Analysis Workbook

  • Pingback: Tweets that mention Big Grandaddy of Excel Project Tracking «Papercut Edge -- Topsy.com

  • Uwekops

    Thanks a lot for your free excel ppm tool – I always prefer the thin-tool-way, just to have more time for the important parts of PM no tool ever will resolve (like all about people)
    Uwe Kops (Cologne, Germany)

  • http://edge.papercutpm.com/ Geoff Crane

    You’re very welcome, Uwe and thank you for the kind words!

  • Pingback: Updates and Stuff « Papercut Edge

  • Nikos Chronaios

    Hello Geof, i cant locate the actual file on these links. Has it been removed for some reason?
    Thanks!
    Nikos -Athens

  • http://edge.papercutpm.com/ Geoff Crane

    My apologies, Thomas! When I redesigned my blog, I broke some of the links. This should be back up and working correctly. Cheers!

  • http://edge.papercutpm.com/ Geoff Crane

    My apologies, Nikos! When I redesigned my blog, I broke some of the links. This should be back up and working correctly. Cheers!

  • Kester Fernando

    thx chap MUCH appreciated

Real Time Analytics

YAY! YOU FOUND ME!

My name is Geoff. I write about project management pretty regularly. From time to time, I also make tools and templates to give away.

You can keep on top of these freebies in one of two FREE ways:


1

Subscribe to my RSS feed. Every time I publish an article, it will magically appear in your reader.


2

Join my community. A couple times a month, you'll get a digest of my latest articles. You ALSO get my FREE ebook, Nine Destructive Behaviours.

Either way, you'll never miss a post! How cool is that? (Psst...if you'd rather just hide me, click the tab again. No one has to know.)