Export Query to Excel

The Export Query to Excel option from the Statistics menu allows you to export the material query data to Excel after a Probabilistic Analysis. This option is only available if you have computed a Probabilistic Analysis.

To use the option:

1. To enable this option, make sure the model has been computed with a probabilistic analysis.
2. First select the data type you would like to view from the drop-list at the top of the screen (e.g. Sigma 1, Total Displacement, Strength Factor etc).
3. Add a Material Query that you would like to export data from using Add Material Query, Query Boundary, Query Excavations, or Query Nodes from the Query menu.
4. Select Export Query to Excel from the Statistics menu. A dialog will be prompted.



5. In the Export Queries dialog, you can choose to export all material queries in the model (Export All), or export a selection of material queries (Export Selected Only). Select OK when complete selection.
   1. If Export Selected Only is selected, you will be prompted to select the material queries to export.
   2. You can select individual queries with the left mouse button, or multiple queries with a window. Right-click on the screen for more selection options.
   3. When completed selection, press Enter or right-click and select Done Selection.
6. A Save As dialog will be prompted. Enter the Excel file name and location, and click Save.

7. The Excel file will be saved and open.

8. The Excel file display the contour data of selected query points computed for each statistical component files and the Base File.

   For example, if your model uses two random variables:

   • Cohesion (Mean = 5, Std.Dev. = 1)
   • Friction Angle (Mean = 30, Std.Dev. = 3)

   The analysis will be computed four times. In addition, RS2 will compute it once more using the mean values of all parameters as the Base File. Five statistical component files will be computed in total. See Probabilistic Analysis topic, and Probabilistic Analysis – Show Values page for more information.

9. Two tabs will be generated in the Excel file. The first tab contains the material and joint (if applicable) stiffness. The second tab contains the contour data values for selected query points.