Export Monte Carlo simulation data

General discussion and questions about project risk management and risk analysis software RiskyProject. Includes discussion on how to perform efficient project risk analysis using our software.

Moderator: Intaver Support

Post Reply
Omaha 23
Posts: 6
Joined: Fri May 25, 2007 9:12 am
Location: Omaha, USA

Export Monte Carlo simulation data

Post by Omaha 23 » Wed Sep 16, 2015 2:54 pm

Is there a quick way to move the simulation data from RiskyProject to a spreadsheet?

Intaver Support
Posts: 992
Joined: Wed Nov 09, 2005 9:55 am

Re: Export Monte Carlo simulation data

Post by Intaver Support » Wed Sep 16, 2015 3:13 pm

Yes, once you have run your Monte Carlo simulations all of the data is available to export as a CSV (comma delimited file). All results including schedule, finish times, cost are included in the file
To export your simulation data, run a simulation. In the Project View or Results Gantt, select the tasks, whose data you want to export. You can press down the <Ctrl> or <Shift> keys to select more than one task. Then go to the File menu, Export> Statistics. You will be prompted to save the file to a local folder. Please note that each iteration creates a row. If you run a large amount of iterations (>2500) be aware that it will create a single row for each iteration.

You may also copy results of Monte Carlo simulations for the particular tasks to the clipboard the paste into Excel. To do it double click on any Gantt bar within a Gantt chart. Then you may right click on particular statistical distribution, and select Copy Data to Clipboard. You may also enlarge statistical distribution by double clicking on it and then again right click on the chart, and select Copy Data to Clipboard.

Image
Intaver Support Team
Intaver Institute Inc.
Home of Project Risk Management and Project Risk Analysis software RiskyProject
www.intaver.com

Post Reply