Use Excel's WhatIf Function to do a Monte Carlo simulation of Project Duration
HTML-код
- Опубликовано: 22 авг 2024
- In this video we will use the built in "WhatIf" function in Excel to carry out a Monte Carlo simulation of Project Duration. This is a simple means of carrying out a simulation that will manage the complexity of Path Convergence when analyzing the uncertainty surrounding your Project Duration.
As a follow on to this video I used VBA to make it more useable and visually demonstrate the challenges of convergence bias amongst the various paths through the project:
• Use Excel and VBA to A...
#PatJHeffernan