Page 1 of 1

I would like to apply distributions with VBA in MSP.

Posted: Wed Jan 13, 2016 11:55 am
by PMBOK
I would like to be able to apply lo/hi durations programmatically through VBA; however, there appears to be a dependency with the Duration Distribution text field. ?Is there documentation on how to construct the "^" delimited formatting of the Duration Distribution text field?

Re: I would like to apply distributions with VBA in MSP.

Posted: Wed Jan 13, 2016 11:59 am
by Intaver Support
There is a description of the statistical distribution code in the documentation, see Format of distribution definition text field for RiskyProject/Microsoft Project”. One of our major clients uses VB to generate this code so it has been field tested. TaskID> estimates in minutes, Seed, statistical distribution type, number of parameters.

Image

You can use this information to create a macro which populate these fields. Our use documentation includes exact description of distribution parameters for each statistical distribution. If you use Triangular distribution, you don't need to define any parameters.