FILEMAKER: My ThreePoint Custom Function

From Dwayne Wright - Certified FileMaker 10 Developer
TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

So my big 2010 challenge is getting my PMP (project management professional) certification. This is all part of a “OMG the economy is in the ditches and I only have FileMaker skills’ neurosis and leading to my attempts to build a career backup plan. This posting isn’t about that but just some header info (because I’ll probably be writing a lot about project management calculation functions in the future).

Anyhoo ...

One of the blessed expected value estimation calculation formulas for the PMP is the three point estimate. What it does is take three estimation points and gives you a most likely result. It can be used to calculate time for schedules or money for budget estimates.

Here you can see three values and their three point result.

Here is a probably a better illustration. Say that a client is asking for an estimate of hours to do a project task. You have done this type of work before and have code you can apply to it. You feel pretty confident that you can do the job in 50 hours and perhaps as low as 40. You want to throw in a higher estimate because you might not have all the deliverable scope because the client isn’t that sure about their definitive needs. So you put in a high estimate of 120 hours into the mix.

You could tell the client that it could take anywhere from 40 to 120 hours. This might be a way to get them to better define their scope to you. It also may be a way to ensure that you never hear from the client again. A three point estimate says that if you give them an estimate of 60, you are pretty well covered.

Now every project is unique and no formula is bullet proof but this is one of them that is blessed by the Project Management Institute for PMP certification. Whether or not you are going to be giving the results of the three point estimate to your clients, it might be a worthwhile practice to track it internally. In fact, you could go more granular in this area and have three point estimates for each work package. That way you can refine your estimation skills and build your library of development related organizational process assets!

The custom function is ruthlessly simple. We take ...

- the most likely estimate times four
- add to that the optimistic estimate
- add to that the pessimistic estimate
- divide that total by six

Here is the custom function itself in living black and white!
More info about the author and FileMaker in general, contact me at

© 2009 - Dwayne Wright -

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.

ADVERTISEMENT ==================
Help support this blog by considering a donating to its ongoing growth. For more details, please visit /donate.html