Page 1 of 1
Question about the Addin simulations with incomplete data
Posted: Tue Dec 15, 2015 1:36 pm
One of users had incorrectly added information required for selecting the statistical distribution as show in the Mapping dialog. He was just entering in a text description “triangular” in the field he had mapped, in this case Text 27. From the documentation it appears that we need to use the Duration dialog box and it adds a string of code to the text field that has been mapped. Is this correct.
Re: Question about the Addin simulations with incomplete data
Posted: Tue Dec 15, 2015 1:44 pm
The Addin has been designed to be very flexible. We strongly recommend that users always use the dialog boxes provide in the Input Distributions group on the ribbon to enter or modify statistical distribution data. This will ensure consistency in the data in the simulations. We do allow for users to manually update the data once it is entered as some find this to be more convenient. In which case, the Addin will check to see if there are differences between the values entered in Statistical Distribution text field and the Durations for Low and High estimates. If there is a discrepancy, the Addin will use the values in the Duration fields for the simulation. In addition, if the Addin finds values in the Low and High duration fields as setup up in the mapping, but does not find the statistical distribution code, it will automatically assign a triangular distribution and allow the user to run the simulation.
Again we strongly recommend user to use the Statistical Distribution to add and maintain the low and high estimates and statistical distribution type for the Monte Carlo schedule risk analysis.