There are 2 type of analysis, Quality and Quantity and both can be applied to a programme. For Monte Carlo or function in Open Plan, they are classified into Quality type. For Quantity type, either use some software tools or build your own in Excel. However, use database is preferable since most quantitive analysis tool are established on database.
Member for
21 years 8 months
Member for21 years8 months
Submitted by Rafael Davila on Sat, 2004-04-03 10:29
Be carefull with simplistic PERT risk analysis. It is usually wrong as the individual risk distribution of near critical activities might affect the resulting distribution.
As far as I know there is no simple alternative other than a simulation.
If all your activieties are in tandem, none in parallel then you might use a simplistic approach.
I have carried out schedule risk analysis, but using proprietary tools as distinct from Excel. Tools I have used have evolved over the years. I have had experience of Primavera Monte Carlo, but currently mainly use the schedule risk functionality of Open Plan. Colleagues I work with also use other tools.
Would this sort of information help you, or are you only looking to use Excel?
Member for
23 years 8 monthsRE: Risk analysis
There are 2 type of analysis, Quality and Quantity and both can be applied to a programme. For Monte Carlo or function in Open Plan, they are classified into Quality type. For Quantity type, either use some software tools or build your own in Excel. However, use database is preferable since most quantitive analysis tool are established on database.
Member for
21 years 8 monthsRE: Risk analysis
Be carefull with simplistic PERT risk analysis. It is usually wrong as the individual risk distribution of near critical activities might affect the resulting distribution.
As far as I know there is no simple alternative other than a simulation.
If all your activieties are in tandem, none in parallel then you might use a simplistic approach.
Member for
24 years 1 monthRE: Risk analysis
I have carried out schedule risk analysis, but using proprietary tools as distinct from Excel. Tools I have used have evolved over the years. I have had experience of Primavera Monte Carlo, but currently mainly use the schedule risk functionality of Open Plan. Colleagues I work with also use other tools.
Would this sort of information help you, or are you only looking to use Excel?