Shopping Cart

Search:

Signup

Contact

FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.

# FileMaker Pro Custom Functions

ThreePoint ( Optimistic ; Pessimistic; MostLikely)

Rate this function:

Average rating: 3.9  (49 votes)
Discuss this Custom Function

Dwayne Wright, dwaynewright.com
http://www.dwaynewright.com

One of the blessed expected value estimation calculation formulas for the PMP is the three point estimate.

Sample Input:
 ThreePoint ( 40 ; 120; 50)
Sample Output:
 60

Then copy & paste into FileMaker Advanced's Edit Custom Function window.

## Description:

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.

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.

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

This is my Custom Function and I want to edit it

## Discuss:

your answer is not helpful at all, when one visit yo site he/she expect example not jus formulas.
wen dealing with figures u suppose to give examples so as to make it easy for your readers to have a more clear pict

andrew, Namibia
September 25, 2014 2:38pm

Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post:

 Your Name: City/Location: Comment: characters left. If you paste in more than 1500 characters, it will be truncated. Discuss the function - advertisements and other useless posts will be deleted. Answer 7 + 7 =
 Search for Custom Functions:

 Download the Custom Function Dashboard Widget for OS X Keep all the latest Custom Functions right at your fingertips!