Rocscience International Conference 2025 is going to take place in Sydney, Australia Read more

Search Results

9 - Automate Deterministic Analysis

This tutorial will familiarize you with the Automate Compute feature of RocPlane by automating a RocPlane Deterministic analysis.

Topics Covered in this Tutorial:

  • Deterministic Analysis RocPlane Model
  • Input Excel File Format
  • Adding Input Excel File(s) to Automate Compute File Queue
  • Output RocPlane Automate Compute Results File
  • RocPlane Automate Compute Error Log

Finished Product:

The finished products of this tutorial can be found in the Tutorial 12 Automate Compute - Deterministic Analysis folder, located in the Examples > Tutorials folder in your RocPlane installation folder. Inside, you will find:

  • Tutorial 09 Automate Compute - Deterministic_base file.pln4 RocPlane model file setup for automation
  • Tutorial 09 Automate Compute - Deterministic_inputs.xlsx Excel input file
  • Tutorial 09 Automate Compute - Deterministic_inputs folder containing the computed results files

1.0 Introduction

The Automate Compute option helps users quickly generate results for several RocPlane analysis cases at a time by reading in various model inputs from Excel. In this tutorial, we will automate the computation of three unique Deterministic cases (i.e., three wedges).

2.0 Creating a New File

If you have not already done so, run the RocPlane program by double-clicking the RocPlane icon in your installation folder or by selecting Programs > Rocscience > RocPlane > RocPlane in the Windows Start menu.

When the program starts, a default model is automatically created. If you do NOT see a model on your screen:

  1. Select File > New New file button

Whenever a new file is created, the default input data forms a valid wedge, as shown in the image below.

 New File

If the RocPlane application window is not already maximized, maximize it now so that the full screen is available for viewing the model.

Before we are ready to run Automate Compute, we must first set up the model environment in the following dialogs:

  1. Project Settings
  2. Input Data
  3. Scale Wedge
This RocPlane model file is meant to be used as a base file for automation. It contains the appropriate settings to be used for all automated cases and the engine for computation. It is not meant to be used for model creation and result viewing, as it does not save the model state for every case.

3.0 Project Settings

First, set the model Units, and Analysis Type.

  1. Select Analysis > Project Settings from the menu to open the Project Settings dialog.
  2. Set the Units = Metric, stress as kPa.
  3. Set the Analysis Type = Deterministic.
  4. Select OK to close the dialog.
The above Project Settings will apply to all cases analyzed in Automate Compute. Each case being analyzed is Deterministic (i.e. a single wedge, as defined) in this case.

4.0 Input Data

Next, set the optional input data.

  1. Select Analysis > Input Data from the menu to open the Deterministic Input Data dialog.
  2. Navigate to the Geometry tab.
  3. We will keep all the check box controls in the default state. Keep in mind that the following are required input parameters that have to be specified later on in the Input Excel File:

    • Slope Angle
    • Slope Height
    • Unit Weight
    • Failure Plane Angle
    • Failure Plane Waviness
    • Upper Face Angle

    Deterministic Input Data

  4. Navigate to the Strength tab.
  5. Set Shear Strength Model = Mohr-Coulomb.
  6. Keep in mind that the following are required input parameters that have to be specified later on in the Input Excel File:

    • Friction Angle
    • Cohesion

    Deterministic Input Data

  7. Navigate to the Forces tab.
  8. We will leave all the check box controls in the default state (unchecked). No input parameters are required since no Seismic or External Forces are applied.

    Deterministic Input Data

  9. Navigate to the Water tab.
  10. We will leave all the check box controls in the default state (unchecked). No input parameters are required since no Ponded Water Pressure or Joint Water Pressure are applied.

    Deterministic Input Data

  11. Select OK to close the dialog.
You can learn about RocPlane input data in detail in Overview of RocPlane Input Data.

5.0 Input Excel File

Now, let's take a look at the structure of the input Excel file.

  1. Obtain the RocPlane Deterministic Excel Template by selecting Analysis > Automate Compute > Deterministic Excel Template.
    A Read-Only Excel workbook titled RocPlane Automation Template_Deterministic.xlsx will be automatically opened (if you have Excel installed on your local machine).
    Deterministic Excel Template.
    The RocPlane Deterministic Input Data Automation Template Excel workbook and worksheets are protected to prevent any accidental modification to the tab structure and headers. The input Excel template contains 5 worksheets for inputting numerical parameters for automation.
  2. Create a folder called Tutorial 09 Automate Compute - Deterministic.

5.1 Geometry

  1. Navigate to the GEOMETRY worksheet.
  2. Under the Wedge ID column, provide the names of the wedges. We will name them arbitrarily Wedge A, Wedge B, and Wedge C. Each row in the input Excel file represents one Deterministic Analysis case in RocPlane.
  3. Enter the following:
  4. Wedge ID

    Slope

    Failure Plane

    Upper Face

    Angle

    Height

    Unit Weight

    Angle

    Waviness

    Angle

    Wedge A

    50

    60

    27

    35

    0

    10

    Wedge B

    45

    50

    25

    20

    0

    0

    Wedge C

    55

    40

    26

    45

    0

    -10

    As set up previously in the RocPlane Deterministic Input Data dialog, only the above input data are required since Bench Width, and Tension Crack are not applicable (i.e., checkbox controls are unchecked). Be aware of units set in RocPlane Project Settings when entering data into the input Excel file. The units should be the same for both !

    The GEOMETRY worksheet should look like this:

    Geometry worksheet

  5. Navigate to the STRENGTH worksheet.
  6. Under the Wedge ID column, provide the names of the wedges (Wedge A, Wedge B, and Wedge C ).
  7. Enter the following:

Wedge ID

Strength

C

Phi

Wedge A

0

35

Wedge B

300

30

Wedge C

200

25

As set up previously in the RocPlane Deterministic Input Data dialog, only the above input data are required since other Shear Strength Model parameters (i.e., Barton-Bandis, Power Curve, etc.) are not applicable. Be aware of units set in RocPlane Project Settings when entering data into the input Excel file. The units should be the same for both !

5.2 Strength

The STRENGTH worksheet should look like this:

Strength worksheet

  • We do not need to enter any data in the FORCES, WATER, or SCALE WEDGE worksheets since those are not applicable.
  • Save the Excel file as Tutorial 09 Automate Compute - Deterministic_inputs.xlsx to the Tutorial 09 Automate Compute - Deterministic folder previously created.
NOTE: Since the RocPlane Automation Template_Deterministic.xlsx file is Read-Only, you must rename and save in a new location.

We are now ready to automate computations in RocPlane by reading from the input Excel file.

6.0 Automate from Excel

Return back to the RocPlane model.

The Automate Compute dialog allows you to add Excel input automation files to the queue, select a an output format, and compute the results.

6.1 ADD FILES TO FILE QUEUE

To add multiple files to the File Queue:

  1. Select Analysis > Automate from Excel from the menu to open the Automated Compute dialog.
    File Queue
  2. Click the Open Open File button button to open a standard dialog to choose an Excel input file. Navigate to the Tutorial 09 Automate Compute - Deterministic folder and select the Tutorial 09 Automate Compute - Deterministic_inputs.xlsx file.
    You will see the Excel input file appear under the File Queue list box.
    File Queue

7.0 Output Result Files

Results files are automatically generated and saved into the same directory as the input Excel file after Automated Compute is complete. Before we run Compute, first ensure that the Output File Format is set to the desired format. Users can select from either Text File or Excel format.

7.1 TEXT FILE FORMAT

While still in the Automated Compute dialog:

  1. Set the Output File Format dropdown to Text File.
  2. Select the Compute button to start the automated computing process.
  3. The Total Progress can be seen at the bottom of the dialog. When files have finished computing, they will appear in the Completed Files list box.

  4. When all files have finished computing, select Exit to close the dialog.

For each input Excel file, a text file (.txt) containing all results data is generated.

For a Deterministic Analysis (Tutorial 09 Automate Compute - Deterministic_inputs.xlsx), the results data for all cases are outputted following the header row. Each row of data represents one analysis case (i.e., one wedge). Each data type is separated by a comma (,) for easy parsing.

  • Take a look at the Results.txt result file.

Deterministic Analysis

7.2 EXCEL FILE FORMAT

Now, we will do the same as before, but this time we will generate the results as an Excel output file format.

  1. Select Analysis > Automate from Excel from the menu to open the Automated Compute dialog.
  2. Click the Open button to open a standard dialog to choose an Excel input file. Navigate to the Tutorial 09 Automate Compute - Deterministic folder and select the Tutorial 09 Automate Compute - Deterministic.xlsx file.
  3. You will see the Excel input file appear under the File Queue list box.

  4. Set the Output File Format dropdown to Excel File.
  5. Select the Save As RocPlane File(s) checkbox. This will save each automated compute case as a RocPlane file.
  6. Excel File Format

  7. Click the Compute button to start the automated computing process.
  8. Since there are already Text File results in the results directory, a popup will appear with the message "Results folder(s) not empty. Duplicated results file(s) will be overwritten. Continue?". Click Yes.
  9. When all files have finished computing, click Exit to close the dialog.

For each input Excel file, an Excel file (.xlsx) containing all results data is generated.

For a Deterministic Analysis (Tutorial 09 Automate Compute - Deterministic.xlsx), the results data for all cases are outputted following the header row. Each row of data represents one analysis case (i.e., one wedge). Each data type is separated by column.

  • Take a look at the Results.xlsx result file.

Deterministic Analysis

8.0 Error Log

As you may have noticed, an Error Log is also generated for each input Excel file. For each input Excel file, an Error Log text file (Automate Compute Error Log.txt) is generated, and saved into the same directory as the output file directories. Always check that the Error Log reports "No errors found" before post-processing the raw results data. If any errors do occur as a result of missing (i.e., blank cells) or invalid inputs, the Error Log will indicate which worksheet(s) and cell(s) are problematic.

This concludes the tutorial. You are now ready for the next tutorial, Tutorial 10 - Automate Probabilistic Analysis from Excel in RocPlane.

Rocscience logo, click here to return to the homepage Portal Account Portal Account Log In Log Out Home 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" Previous Next 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 X page Click here to visit Rocscience's Facebook page Click here to visit Rocscience's Instagram page Click here to visit Rocscience's Reddit page Bookmark Network Scroll down for more Checkmark Download Print Back to top Single User Multiple Users RSLog RocFall3 CPillar Dips EX3 RocFall RocPlane RocSlope3 RocSupport RocTopple RS2 RS3 RSData RSPile Settle3 Slide2 Slide3 SWedge UnWedge RocTunnel3 RocSlope2 BlastMetrix ShapeMetriX Fragmenter Commercial License Education License Trial License Shop safe & secure Money-back guarantee