Page 1 of 1
I would like to apply distributions with VBA in MSP.
Posted: Wed Jan 13, 2016 11:55 am
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
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.
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.