7 - Automate Deterministic Analysis
1.0 Introduction
The Automate Compute option helps users quickly generate results for several RocTopple analysis cases at a time by reading in various model inputs from Excel.
This tutorial will familiarize you with the Automate Compute feature of RocTopple by automating the computation of three unique Deterministic cases (i.e., three toppling cases).
Topics Covered in this Tutorial:
- Deterministic Analysis RocTopple Model
- Input Excel File Format
- Adding Input Excel File(s) to Automate Compute File Queue
- Output RocTopple Automate Compute Results File
- RocTopple Automate Compute Error Log
Finished Product:
The finished products of this tutorial can be found in the Tutorial 7 Automate Compute - Deterministic Analysis folder, located in the Examples > Tutorials folder in your RocTopple installation folder. Inside, you will find:
- Tutorial 07 Automate Compute - Deterministic_base file.rtop RocTopple model file setup for automation
- Tutorial 07 Automate Compute - Deterministic_inputs.xlsx Excel input file
- Tutorial 07 Automate Compute - Deterministic_inputs folder containing the computed results files
2.0 Creating a New File
- If you have not already done so, run the RocTopple program by double-clicking the RocTopple icon in your installation folder or by selecting Programs > Rocscience > RocTopple > RocTopple 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:
- Select: File > New
Whenever a new file is created, the default input data forms a valid wedge, as shown in the image below.
If the RocTopple 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:
- Project Settings
- Input Data
- Seismic Load
- Water Pressure Options
3.0 Project Settings
First, set the model Units, and Analysis Type.
- Select Project Settings from the Analysis menu to open the Project Settings dialog.
- Set the Units = Metric, stress as kPa.
- Set the Analysis Type = Deterministic.
- In the Toppling Model tab, set the Toppling Model = Block Toppling.
- Select OK to close the dialog.
4.0 Input Data
Next, set the optional input data.
- Select Input Data from the Analysis menu to open the Deterministic Input Data dialog.
- Navigate to the Geometry tab.
- Slope Angle
- Slope Height
- Upper Slope Angle
- Toppling Joints Spacing
- Toppling Joints Dip
- Overall Base Inclination Angle
- Rock Unit Weight
- Navigate to the Point of Force Application tab.
- If Block Above is Sliding
- If Block Above is Shearing
- Navigate to the Base and Bedding Strength tab.
- Set Base Joints Shear Strength Model = Mohr-Coulomb.
- Set Toppling Joints Shear Strength Model = Mohr-Coulomb.
- Base Joints Friction Angle
- Base Joints Cohesion
- Base Joints Tensile Strength
- Toppling Joints Friction Angle
- Toppling Joints Cohesion
- Toppling Joints Tensile Strength
- Select OK to close the dialog.
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:
Keep in mind that the following are required input parameters that have to be specified later on in the Input Excel File:
Keep in mind that the following are required input parameters that have to be specified later on in the Input Excel File:
5.0 Input Excel File
Now, let's take a look at the structure of the input Excel file.
- Obtain the RocTopple Deterministic Excel Template by selecting Analysis > Automate Compute > Deterministic Excel Template
- Create a folder called Tutorial 7 Automate Compute - Deterministic.
- Navigate to the GEOMETRY worksheet.
- Under the Topple ID column, provide the names of the toppling cases. We will name them arbitrarily Topple A, Topple B, and Topple C. Each row in the input Excel file represents one Deterministic Analysis case in RocTopple.
- Enter the following:
- Navigate to the POINT OF FORCE APPLICATION worksheet.
- Under the Topple ID column, provide the names of the wedges (Topple A, Topple B, and Topple C).
- Enter the following:
- Navigate to the BASE AND BEDDING STRENGTH worksheet.
- Under the Topple ID column, provide the names of the wedges (Topple A, Topple B, and Topple C).
- Enter the following:
- Save the Excel file as Tutorial 7 Automate Compute - Deterministic_inputs.xlsx to the Tutorial 7 Automate Compute - Deterministic folder previously created.
A Read-Only Excel workbook titled RocTopple Automation Template_Deterministic.xlsx will be automatically opened (if you have Excel installed on your local machine).
The RocTopple 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 6 worksheets for inputting numerical parameters for automation.
Topple ID | Slope | Upper Slope | Toppling Joints | Overall Base Inclination | Rock Unit Weight | ||
Angle | Height | Angle | Spacing | Dip | |||
Topple A | 53 | 84 | 27 | 10 | 50.5 | 45 | 25 |
Topple B | 48 | 72 | 30 | 8 | 57.5 | 45 | 23 |
Topple C | 59 | 88 | 25 | 5 | 52.5 | 48 | 26 |
The GEOMETRY worksheet should look like this:
Topple ID | Point of Force Application Ratios | |
---|---|---|
If Block Above is Sliding | If Block Above is Shearing | |
Topple A | 0.85 | 0.85 |
Topple B | 0.78 | 0.79 |
Topple C | 0.75 | 0.73 |
The POINT OF FORCE APPLICATION worksheet should look like this:
Topple ID | Base Joints | Toppling Joints | ||||
---|---|---|---|---|---|---|
C | Phi | Tensile Strength | C | Phi | Tensile Strength | |
Topple A | 0.25 | 35 | 1 | 0.24 | 34.5 | 1 |
Topple B | 0.27 | 40 | 1.5 | 0.23 | 36 | 1.2 |
Topple C | 0.23 | 32 | 1.1 | 0.22 | 30.5 | 1.1 |
The BASE AND BEDDING STRENGTH worksheet should look like this:
We do not need to enter any data in the INTERNAL ROCK STRENGTH, FORCES, or WATER worksheets since those are not applicable.
We are now ready to automate computations in RocTopple by reading from the input Excel file.
6.0 Automate from Excel
- Return back to the RocTopple 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. To open the dialog:
- Select: Analysis > Automate Compute > Automate from Excel
6.1 ADD FILES TO FILE QUEUE
To add multiple files to the File Queue:
- Select Automate from Excel from the Analysis menu to open the Automated Compute dialog.
- Select the Open button to open a standard dialog to choose an Excel input file. Navigate to the Tutorial 7 Automate Compute - Deterministic folder and select the Tutorial 07 Automate Compute - Deterministic_inputs.xlsx file.
You will see the Excel input file appear under the File Queue list box.
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:
- Set the Output File Format dropdown to Text File.
- Select the Compute button to start the automated computing process.
- When all files have finished computing, select Close to exit the dialog.
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.
For each input Excel file, a text file (.txt) containing all results data is generated.
For a Deterministic Analysis (Tutorial 7 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 topple case). Each data type is separated by a comma (,) for easy parsing.
- Take a look at the Results.txt result file.
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.
- Select Automate from Excel from the File menu to open the Automated Compute dialog.
- Select the Add Files button to open a standard dialog to choose an Excel input file. Navigate to the Tutorial 7 Automate Compute - Deterministic folder and select the Tutorial 7 Automate Compute - Deterministic.xlsx file.
- Set the Output File Format dropdown to Excel.
- Select the Compute button to start the automated computing process.
- When all files have finished computing, select Close to exit the dialog.
You will see the Excel input file appear under the File Queue list box.
For each input Excel file, an Excel file (.xlsx) containing all results data is generated.
For a Deterministic Analysis (Tutorial 7 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 topple case). Each data type is separated by column.
- Take a look at the Results.xlsx result file.
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 08 - Automate Probabilistic Analysis from Excel in RocTopple.