Monte Carlo Simulation
Monte Carlo Simulation
(OP)
Hi all of you out there..
I am currently inverstigating putting together a little spreadsheet in Excel or similar that will do Monte Carlo simulation's for projects.
This means that you find the critical path of the project and input ideal, optimistic and pessimistic duration for each task and the spreadsheet will then 'simulate' any number of possible total project durations and give you a analysis at the end for example - project is 95% likely to take X days, etc.
Is this of any interest to anyone, has it been done before and is it worth my time?
Yours input and/or suggestions would be appreciated.
S
I am currently inverstigating putting together a little spreadsheet in Excel or similar that will do Monte Carlo simulation's for projects.
This means that you find the critical path of the project and input ideal, optimistic and pessimistic duration for each task and the spreadsheet will then 'simulate' any number of possible total project durations and give you a analysis at the end for example - project is 95% likely to take X days, etc.
Is this of any interest to anyone, has it been done before and is it worth my time?
Yours input and/or suggestions would be appreciated.
S





RE: Monte Carlo Simulation
www.jimstemple.com/mcsim.zip
S
RE: Monte Carlo Simulation
Thanks
RE: Monte Carlo Simulation
www.jimstemple.com/mcsim.zip
S
RE: Monte Carlo Simulation
Please advise.
Thank you
RE: Monte Carlo Simulation
To use the simulator you have to have the Data Anlysis Add-In installed..
Go to Tools - Add-Ins and Select Analysis Toolpack and Analysis Toolpack VBA and install these, the sheet uses the random number generation function to 'simulate the project'.
Hope this helps..
Any more problems, let me know.
S
RE: Monte Carlo Simulation
Now I can prove that I deserve my pay rise!!
RE: Monte Carlo Simulation
I think that this could be useful as one of many tools a project manager can use in order to improve plans and exucution of the plans.
I will use it in other aspects also such as anlyse of impact for identified risks etc.
RE: Monte Carlo Simulation
I have never used the Analysis-Toolpak before and it seems there must be some interesting stuff in there.
RE: Monte Carlo Simulation
To change this is simply to change the number in the argument of the number generator in the sheet macro, it is set at 2 = normal now but you can change this integer to another to use a different distribution. Don't know how this would affect the sheet though.. It would probably not work without some firther work.
S
RE: Monte Carlo Simulation
RE: Monte Carlo Simulation
Nice product. Based on your knowlege of the technique, can I use the same program for cost data to achieve a Monte Carlo simulation of my project budget?
RE: Monte Carlo Simulation
I have just done a quick test and you can use the spreadsheet as above but where it says duration, days etc, just imagine it says optimistic cost, ideal cost, etc.
If you do have any problems then send me an e-mail @
simmantix@jimstemple.com
with your problem and I will adjust the code to suit. The only problems I can foresee are integer and value designation problems but, if they occur, they are easily fixed..
Regards
Sim
RE: Monte Carlo Simulation
www.jimstemple.com/mcsim.zip
So you can now do critical path simulation or project budget simulation..
Hope this helps..
Sim
RE: Monte Carlo Simulation
1) The variation in task duration may change the critical path. One would have to see if a second path s near critical in duration and run the simulation for this second path to see if there is a change in critical path.
2) The variation in any one task is independent of the variation in all other tasks. This might not be true for example if the critical path is weather dependant i.e. (site and earth work) or if one sub contractor is fast or slow on all tasks. (i.e. if the concrete crew in slow in erecting the forms they may be slow in stripping the forms.) This could be accounted for by grouping these tasks into one task.
Rick Kitson MBA P.Eng
Construction Project Management
From conception to completion
www.kitsonengineering.com
RE: Monte Carlo Simulation
Both offer a limited compatibility with MS Project (that is you can import from MSP at the outset, but neither export data back, or import plan updates).
Over the last three or four years, I've used both. Risk Analyser is basic Monte-Carlo. Risk Controller starts to integrate a risk register, and has a slightly friendlier interface.
Advice from bitter experience for what it's worth, is to be very careful with the results from Monte-Carlo simulations. It's easy to lose sight of the simplifying assumptions in all the excitement of a vast simulation. A common trouble area is that a triangular distribution based on three point estimates is actually quite a poor model of task duration (the same may not be quite so true for cost). Most real distributions are reasonably tight, with one or two smaller peaks off to the right somewhere. The difference, once fed into a simulation is remarkable.
ANM.
RE: Monte Carlo Simulation
RE: Monte Carlo Simulation
bwst of luck with your simulations.
RE: Monte Carlo Simulation
Best Regards,
RE: Monte Carlo Simulation
After I authored the program, I uploaded it to my website..
I am afraid that my website is no more..
If you would like the program then please contact me on:
james@elsl.co.uk
Thanks for your interest..
Simmantix..
Simmantix
---------
Phases of a Project:
Exultation, Disenchantment, Search for the Guilty, Punishment of the Innocent, Praise for the Uninvolved...
RE: Monte Carlo Simulation
11.2 Scheduling with Uncertain Durations
The most common formal approach to incorporate uncertainty in the scheduling process is to apply the critical path scheduling process ... and then analyze the results from a probabilistic perspective. This process is usually referred to as the PERT scheduling or evaluation method. ... the duration of the critical path represents the minimum time required to complete the project. Using expected activity durations and critical path scheduling, a critical path of activities can be identified. This critical path is then used to analyze the duration of the project incorporating the uncertainty of the activity durations along the critical path. The expected project duration is equal to the sum of the expected durations of the activities along the critical path. Assuming that activity durations are independent random variables, the variance or variation in the duration of this critical path is calculated as the sum of the variances along the critical path. With the mean and variance of the identified critical path known, the distribution of activity durations can also be computed.
...
While the PERT method has been made widely available, it suffers from three major problems. First, the procedure focuses upon a single critical path, when many paths might become critical due to random fluctuations. For example, suppose that the critical path with longest expected time happened to be completed early. Unfortunately, this does not necessarily mean that the project is completed early since another path or sequence of activities might take longer. Similarly, a longer than expected duration for an activity not on the critical path might result in that activity suddenly becoming critical. As a result of the focus on only a single path, the PERT method typically underestimates the actual project duration.
As a second problem with the PERT procedure, it is incorrect to assume that most construction activity durations are independent random variables. In practice, durations are correlated with one another. For example, if problems are encountered in the delivery of concrete for a project, this problem is likely to influence the expected duration of numerous activities involving concrete pours on a project. Positive correlations of this type between activity durations imply that the PERT method underestimates the variance of the critical path and thereby produces over-optimistic expectations of the probability of meeting a particular project completion deadline.
Finally, the PERT method requires three duration estimates for each activity rather than the single estimate developed for critical path scheduling. Thus, the difficulty and labor of estimating activity characteristics is multiplied threefold.
As an alternative to the PERT procedure, a straightforward method of obtaining information about the distribution of project completion times (as well as other schedule information) is through the use of Monte Carlo simulation. This technique calculates sets of artificial (but realistic) activity duration times and then applies a deterministic scheduling procedure to each set of durations. Numerous calculations are required in this process since simulated activity durations must be calculated and the scheduling procedure applied many times. For realistic project networks, 40 to 1,000 separate sets of activity durations might be used in a single scheduling simulation. ...
...
The disadvantage of Monte Carlo simulation results from the additional information about activity durations that is required and the computational effort involved in numerous scheduling applications for each set of simulated durations. For each activity, the distribution of possible durations as well as the parameters of this distribution must be specified. For example, durations might be assumed or estimated to be uniformly distributed between a lower and upper value. In addition, correlations between activity durations should be specified. For example, if two activities involve assembling forms in different locations and at different times for a project, then the time required for each activity is likely to be closely related. If the forms pose some problems, then assembling them on both occasions might take longer than expected. This is an example of a positive correlation in activity times. In application, such correlations are commonly ignored, leading to errors in results. As a final problem and discouragement, easy to use software systems for Monte Carlo simulation of project schedules are not generally available. This is particularly the case when correlations between activity durations are desired.
Project Management for Construction by Chris Hendrickson, Department of Civil and Environmental Engineering, Carnegie Mellon University
http://www.ce.cmu.edu/pmbook/11_Advanced_Scheduling_Tec...
Bernard Ertl
www.interplansystems.com
- eTaskMaker Project Planning Software
- ATC Professional Turnaround Management Software
RE: Monte Carlo Simulation
Anyone interested?
Jim
Simmantix
---------
Phases of a Project:
Exultation, Disenchantment, Search for the Guilty, Punishment of the Innocent, Praise for the Uninvolved...
RE: Monte Carlo Simulation
D-Risk from Frazer-Nash Consulting
www.fnc.c
This one's only been on the market since July, so I guess its stability isn't as well proven as some of the alternatives - nonetheless, I haven't seen any real problems in the several months I've been playing.
Comes as a straight plugin to MS Project, with output direct to MSP too, so fairly painless to use. I quite like it.
A.
RE: Monte Carlo Simulation
TTFN
RE: Monte Carlo Simulation
http://www.elsl.co.uk/assets/files/mcsim.zip
Please do me the kindness of posting or e-mailing me if you take a copy so I can issue updates if neccessary..
Thanks
Jim
Simmantix
---------
Phases of a Project:
Exultation, Disenchantment, Search for the Guilty, Punishment of the Innocent, Praise for the Uninvolved...
RE: Monte Carlo Simulation
TTFN
RE: Monte Carlo Simulation
Simmantix
---------
Phases of a Project:
Exultation, Disenchantment, Search for the Guilty, Punishment of the Innocent, Praise for the Uninvolved...
RE: Monte Carlo Simulation
TTFN