EXCEL as Risk Analysis Software

W
wjm014 👤 Member for 15 years 8 months

Yes, in business there are many risk applications using the pseudo random number generator RAND() function. Fram a CPM standpoint, if you had the time you could perform a monte carlo analysis using RAND(). In fact time might not be that big an issue if you wanted to model only select activities.

M
Mai Tawfeq 👤 Member for 16 years 3 months

Hi Dears:

 

For all the interested members in such concept (Risk Analysis Tools), Oracle has provide a much a mazing tool to re-plan and achieve a project goals in many meanings whether cost or time since the quality can be contended in project specifications, it called Oracle Primavera Risk Analysis, this tool can be used in conjunction with MSP, P3, P6, and can be loaded easily from officially Oracle website.

 

Mai 

M
manikarori rosky 👤 Member for 17 years 2 months

Dear all,



I just join the planning planet by today and I saw the subject is really interested. Can some body send me the soft file of excel for risk analysis to my email : [email protected] ?



appreciate with your support.



thanks,

ori

C
Chachrist Srisuwanrat 👤 Member for 19 years 4 months

thanks for the inputs from those who like and dislike my simple RISK Analysis macro. I didnt plan to make it as an end product. My macro and the code should be viewed as a starter. It should show you how to make a simple simulation out of MS Excel and MS Project.

By the way, sorry I didnt write the manual, since I believe we all can figure out how it works.

R
Raphael M. Dua 👤 Member for 25 years 4 months

Guys



I gave you the web address in my previous post



www.decisivetools.com



download a 30 day trial to see for yourself.





iDecide is an award-winning software program for decision and risk analysis. With iDecide you can quickly build influence diagrams describing the risk or decision and then run Monte Carlo simulation. The result is a statistically accurate representation of the range and likelihood of all possible outcomes. In other words, iDecide gives you the power to handle risks and decisions like a professional.



Raf

R
R. Catalan 👤 Member for 20 years 9 months

Dear PP’ers,



To all requesting copy of Chachrist’s risk analysis using MS Excel.



I copied here his Post # 13 for your convenience.



Just helping everyone.



Best regards,

R. Catalan

________________________________________________________



please goto

http://www.chachris.com/index_files/excel.htm

or

http://chachrist.googlepages.com/RiskAnalysis.pdf



I wish I have time to show you guys more. Anyway, this should give you an idea how to do this in EXCEL.



By the way, please check PERTMASTER and @RISK software. These two companies have add-on application for EXCEL, MS PROJECT,and P3 sebjected to RISK ANALYSIS

R
Raphael M. Dua 👤 Member for 25 years 4 months

Folks

If you are so keen to write Risk Analysis using Excel, then there is a far better tool which cost about $USD 150.00

Go to www.decisivetools.com and look for i-decide

It has more maths than you have ever learnt



Raf

M
Mark Bandong 👤 Member for 18 years 2 months

Hi all!



i would appreciate if someone send me a copy of the schedule risk analysis. Thank you!



regards,

denmark

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts