Category Archives: 8.4 Planning and Tracking with the Total Project Estimate

Project Management Spreadsheet with In-Progress Tracking for the High Holiday Ushers Deliverable (Chapter 8)

p220ref

Click here to see a sample Project Management Spreadsheet that I filled in with in-progress tracking on the estimates for “High Holiday Ushers” subtasks that appear in Chapter 8 of Growth through Governance.  You may copy and use the sheet for yourself, but please respect the open-source license: you may not sell it, and the attribution with my e-mail address must stay intact.

  • Click here to access a blank Project Management Spreadsheet for your use in other projects.
  • Click here to see the same Project Management Spreadsheet without the progress tracking (as the project would look at its beginning).
  • Click here if you’d like more detail on how the whole thing works.

Project Management Spreadsheet for the High Holiday Ushers Deliverable (Chapter 8)

p216bref

Click here to see a sample Project Management Spreadsheet that I filled in with the estimates for “High Holiday Ushers” subtasks that appear in Chapter 8 of Growth through Governance.  You may copy and use the sheet for yourself, but please respect the open-source license: you may not sell it, and the attribution with my e-mail address must stay intact.

  • Click here to access a blank Project Management Spreadsheet for your use in other projects.
  • Click here to see the same Project Management Spreadsheet being used for tracking, according to the sample results mentioned in Chapter 8 of my book.
  • Click here if you’d like more detail on how the whole thing works.

By the way, I realize the estimates on the sheet are not exactly what they are in the book in Figure 8 on page 216, although I think the subtask estimates are the same as those in Figure 9 on page 217.  I’m not surprised that happened.  I must have played around with the numbers a little bit after sending in Figure 8.  In any case, our whole point is that the precision doesn’t matter a whole lot.  We’re already tremendously more precise than we would be with a one-point estimate, which, as I mention in Growth through Governance (see p. 218 at the top), would have put us at 24 hours instead of 33 or 34.  We’re interested in getting the ballpark right.  Slightly different subtask estimates would result in slightly different project estimates, too, and those differences are just matters of opinion.  You’ll be fine if you’re anywhere in the ballpark of the low 30s of hours for this small project, and not in the low 20s.  If you want to try for greater precision in project estimates, see Chapter 10 of the book.

This may be a lot, so please feel free to ask any questions by leaving a reply below!

Anyone Know of Low-Cost Project Management Software that Supports Three-Point Estimates?

p216ref

There’s no reason for three-point estimates to be the domain of $300,000 software and of non-customer-oriented tools like my Project Management Spreadsheet.  We ought to have a user-friendly, interface-driven, online product that supports three-point estimates.  If you know of one, please leave a reply and let me know!

Rabbi Sher’s Project Management Spreadsheet

p210ref

p215ref

Here’s the spreadsheet that’s been the secret to my on-target project estimation, project bids, and responsive project management for 15 years.  Would it ever be nice to find a low-cost software product that supports three-point estimates!  (Let me know if you know of one.)  For now, you’re welcome to copy and use this Google Sheet.  You’ll find instructions as well as the terms of use on the second page of the workbook.  Please respect the open-source license: you’re welcome to copy and use it, but you may not sell it, and the attribution to me with the e-mail address must remain intact.  With that, have at it, here it is!

I explained in Growth through Governance how to use the workbook, but if you have a question as you go along, please feel free to share it here.  I’d also love to hear about your experiences getting into three-point project estimates.

  • See this post for my best effort explaining how this works without mathematical equations.
  • See this post for example Project Management Spreadsheet workbooks for the High Holiday ushers deliverable that is planned in Chapter 8 of Growth through Governance.

Mathematical Derivations of the Three-Point Estimate

p206ref

p214ref

I’ve explained the mathematical derivations in brief within my Project Management Spreadsheet workbook; click here to go directly to the explanation page.  You may copy the file and use it yourself; please respect the open-source license (you may not sell it, and the attribution must be kept intact).

While I’ve been happy with the 1996 edition, the latest edition of the Guide to the Project Management Body of Knowledge and pertinent professional training opportunities can be found here, at the Project Management Institute (PMI) website.  In-depth mathematical derivations can be found there.

My best effort to explain in intuitive, non-mathematical terms why three-point estimates work appears on pp. 214-215 of Growth through Governance, during the discussion of the concept of variance.

For those who wish a little more depth on these derivations than what appears in my book, but who don’t want to read mathematical equations, here goes.  A project consists of many subtasks, which all share a couple important core statistical characteristics, even though they may differ broadly in their particulars.  Every subtask has a shape describing the likelihood of results in time or cost, with a hump or point in the middle, where the likelihood is highest, and a lower likelihood out at the tail ends of the best and worst cases.  In between those outlying cases, the likelihood generally gets higher as you proceed toward the middle, and lower as you proceed toward the outlying edges.  These shapes are called probability distributions.

Of course, there will be tasks whose probability distributions don’t actually fit this basic shape: they might be bimodal (having two most-likely peaks).  An everyday example is how long it takes me to get to work on the bus.  If the bus comes every 20 minutes, and the bus ride is 10 minutes, and I’ve looked at the bus schedule so I can try to be at the bus stop 3 minutes before the bus, you’ll see at least two peaks in the probability distribution of how long it takes me to get to work: one peak at 13 minutes, and then another smaller peak at 33 minutes, in case I miss that first bus.  The probability distribution will reach a low at 23 minutes, between the peaks, corresponding to a time when the bus is not scheduled to come.  Regardless of this and other cases where the single-peak distribution doesn’t quite fit, the single-peak shape turns out to be a pretty good model, and deviations from it in practice tend to average out.

So, project managers have found through experience that it’s a best practice to simplify the probability distribution of subtasks down to a “most likely” estimate at that peak of likelihood, as well as a low-likelihood estimate for “best case” and “worst case.”  We then draw a model of the subtask’s probability distribution as a triangle between those three points, or as a bell curve with a hump in the middle and low-likelihood tail ends at the best- and worst-case estimates.  The exact shape of the distribution doesn’t matter a whole lot, certainly not for the purposes of the relatively small projects Growth through Governance is mainly intended for; again, little discrepancies tend to average out.  (By “small” projects, I mean that you’re more likely to be planning a community event than building 100 airplanes.)

Note that this method, while mathematical, is imprecise.  It’s imprecise in a mathematical way.  The underlying math gives us a pretty good sense of just how imprecise it is, and it’s a good sight less imprecise than traditional one-point estimates.  I’ve found three-point estimates to be a powerful tool, an admittedly heavy tool, but one that has consistently worked for me for over 15 years.