Page 1 of 1

Generating Risk Adjusted Margins

Posted: Sat Feb 22, 2020 5:36 pm
by KerryMiller
We have been asked to calculate schedule margin activities based on p80. How do can I calculate this in RiskyProject?

Re: Generating Risk Adjusted Margins

Posted: Sat Feb 22, 2020 5:44 pm
by Intaver Support
1. Set the High Results the simulations to p80 in the Project Options > Calculation tab.
Image

2. Run the simulation.
3. In the Reports > Simulation Results view, hide all of the columns with the exception of the Task Name, Base Duration (Duration Base – cur schedule), and Duration High.
Image

4. From the File menu, click Export > Microsoft Excel
Image

5. You are prompted to confirm the Export with some customization if required.
6. Click OK and the data will open as an Excel spreadsheet.
7. Add a additional column to the left Margin and using the Find and Replace remove the word “days” from all the cells (otherwise calculations will not work)
Image

8. The calculated margin is the difference between the Base duration of the deterministic schedule and the High Results. Create a formula that subtracts the Base duration from the High Duration in the Margin cells “=D2-C2”

9. Copy the formula down the Margin column. You now have values for all the activities in the schedule.
Image