Page 1 of 1

Addin not calculating low and high correctly

Posted: Thu Oct 22, 2015 3:53 pm
by KerryMiller
Hello, we are trying to use the RiskyProject Addin in Microsoft Project, but are getting strange results for pessimistic (high) results when we run a Monte Carlo schedule risk analysis. We are using Duration1 and Duration2 for low and high durations.

Re: Addin not calculating low and high correctly

Posted: Thu Oct 22, 2015 3:55 pm
by Intaver Support
Most likely reason for the results you are getting is that the column mappings for duration are not set correctly. This is a common issue. The default column mappings for Low and High Duration when you first install the software are fields Duration 1 and Duration 3. However, people often are unaware that these fields are mapped and can be customized and therefore need to be setup before running the Monte Carlo risk analysis.

The field mappings can be found in the RiskyProject addin tab, Settings>Field Mappings. In the screenshot below is an example of how the field mapppings and the duration estimates can be mapped incorrectly. In this example to fix this, the user would need to switch the High duration to Duration 2.

Image