Rocscience International Conference 2023 | April 24-26, 2023 Learn More about RIC2023
 

Search Results

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. Export Queries dlg

  6. 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.
  7. A Save As dialog will be prompted. Enter the Excel file name and location, and click Save.
  8. The Excel file will be saved and open.

  9. 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.

  10. 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.
Account Icon - click here to log in or out of your account Shopping Cart icon Click here to search our site Click here to close Learning Tech Support Documentation Info Chevron Delete Back to Top View More" PDF File Calendar Location Language Fees Video Click here to visit Rocscience's LinkedIn page Click here to visit Rocscience's YouTube page Click here to visit Rocscience's Twitter page Click here to visit Rocscience's Facebook page Click here to visit Rocscience's Instagram page Bookmark Network Scroll down for more Checkmark Download Print Back to top Single User Multiple Users RSLog RocFall3 CPillar Dips EX3 RocFall RocPlane RocSupport RocTopple RS2 RS3 RSData RSPile Settle3 Slide2 Slide3 SWedge UnWedge Commercial License Education License Trial License Shop safe & secure Money-back guarantee