Software Venture Consulting

FileMaker Pro downloads & Resources
FileMaker Custom Functions
FileMaker Web Viewer Examples
FileMaker Pro & Lasso Consulting
FileMaker Books
FileMaker Articles
FileMaker Error Reference

Free Web Tools
Free FileMaker Tools

Personal Pages

Shopping Cart
Shopping Cart


Free Newsletter


Privacy Policy

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


 FileMaker Pro Custom Functions

List  |  Show Random  |  Upload  |  Add This to Your Site

ThreePoint ( Optimistic ; Pessimistic; MostLikely)

Rate this function:  

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

Dwayne Wright,

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:

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


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.

More info ... visit

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

This is my Custom Function and I want to edit it


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:
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 4 + 4 =
Search for Custom Functions:

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

Newest Custom Functions:

1. HexUUIDToNum_cf (_uuid)
  (Sat, Jun 16, 1:55pm)
2. httpResponseCode ( responseHeaders )
  (Tue, Jun 12, 10:40pm)
3. FindDuplicateCharacters ( string )
  (Fri, Jun 08, 5:01pm)
4. FieldRepetitionLast ( field ; maxRepetition )
  (Wed, Jun 06, 6:05pm)
5. CountModifiedRecords ( NameTimestampField ; StartTimestamp ; EndTimestamp )
  (Mon, May 28, 8:23am)
6. JSONArrayLength ( JSONArrayStr )
  (Fri, May 25, 7:46am)
7. interpolation (y1; y2; y3; x1; x2; x3; x1y1; x2y1; x1y2; x2y2; rnd)
  (Sat, May 19, 3:55am)
8. @JSONFormatElements ( json )
  (Tue, May 15, 3:31am)

RSS Feed of Custom Functions