Addin not calculating low and high correctly

This forum containts questions about RiskyProject project risk analysis and risk management software: features, issues, problem reports. If you have any problems or question, please submit it here.

Moderator: Intaver Support

Post Reply
Posts: 22
Joined: Tue Dec 18, 2007 3:39 pm
Location: USA, MI

Addin not calculating low and high correctly

Post by KerryMiller » Thu Oct 22, 2015 3:53 pm

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.
Project Engineer

Intaver Support
Posts: 892
Joined: Wed Nov 09, 2005 9:55 am

Re: Addin not calculating low and high correctly

Post by Intaver Support » Thu Oct 22, 2015 3:55 pm

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.

Intaver Support Team
Intaver Institute Inc.
Home of Project Risk Management and Project Risk Analysis software RiskyProject

Post Reply