The Rocscience International Conference 2021 Proceedings are now available. Read Now

Search Results

20 - Multiple Load Import

1.0 Introduction

In Settle3, multiple loads can be imported from structural software such as SAFE through excel spreadsheet using load import from SAFE feature. This feature allows users to import multiple segments of load from structural software such as SAFE in excel file to Settle3 for subgrade modulus reaction. Previously, the users had to manually import the load with the corresponding coordinates and magnitude of load to Settle3.

In this tutorial, we will show how this procedure is made more robust by showing you how to import batch loads with associated coordinates, magnitude, and elevation. Then, this tutorial will show the automatically generated query points at the center of each imported load for output results such as subgrade soil modulus.

Topics Covered in this Tutorial:

  • Multiple load import
  • Modulus of subgrade reaction export

Finished file:

The finished file of this tutorial can be found in the Tutorial 20 multiple load import_final.s3z file. All tutorial files installed with Settle3 can be accessed by selecting File > Recent Folders > Tutorials Folder from the Settle3 main menu.

2.0 Model

2.1 Project Settings

  1. Select Analysis > Project Settings (CTRL + J) to open the Project settings icon Project Settings dialog.
  2. In the General tab, make sure the Units are set as Metric, stress as tonns/m2.
    Project settings dialogProject Settings Dialog
  3. Select Soil Profiles tab. Select 'Depth below Ground Surface' option.
  4. Click OK to close the dialog and save your changes.

Note: You may be warned that the unit system has changed. If this is the case, select Yes to reset the unit-dependent values.

3.0 Import Load import from SAFE

  1. Select: Loads > Loads from SAFE > Import Loads
  2. Import two excel spreadsheet for Area Connectivity and Soil Pressures files from the tutorial folder.
    - Select the Browse button in Area Connectivity and import 'Areas connectivity.xlsx' file
    - Select the Browse button in Soil Pressures and import 'Soil Pressures.xlsx' file
    Import Loads from SAFE
  3. Select Next and you will see the settings for import loads
    Import Loads from Safe
  4. Make sure to keep the default value of divisions to 30, select the colorize loads for each stress division, and select the customize button.
  5. Customize stress division will be divided based on the min/max values of the load from the spreadsheet, divided by the number of sections defined from previous step.
    Custom Stress Divisions Dialog
    Select OK.
  6. Keep the Merge close vertices with distance smaller than 0.1.
  7. Set loads to depth (m) to 0. Make sure the 'create excavation load' is unselected.
  8. Select Finish.
  9. You'll be prompted with this error message because there are some nodes missing pressure values for the nodes. Settle3 will detect those nodes and will automatically apply average of the nearby nodes. Select OK.
Settle3 Warning Message

Press F2 to zoom all. You will see the imported load with colors showing the division with previously defined range as shown below:

Imported Load Model View

4.0 Subgrade Modulus Reaction

After multiple loads are imported, you can check the modulus of subgrade reaction for each query points created in the middle of each loads.

Select: Compute

After the compute, you will see the results are displayed. Change the result type to Modulus of Subgrade reaction (total) as shown below and you will see the result with values at each query points.

Excel View of Subgrade Modulus Reaction

Now we will export the subgrade modulus results obtained from Settle3 to Excel spreadsheet.

4.1 Export Modulus of subgrade reaction

Select: Loads from SAFE > Export Modulus of Subgrade Reaction.

The neat feature from this dialog is that users can define the range of the modulus of subgrade reaction with min/max values and Settle3 will categorize each area of the load with the appropriate category of the modulus. For this tutorial, we will fill out 6 categories with min/max ranges as shown below:

- 6 categories with range of 10 (tonns/m2/m), except for the last category.

- Name each category as you desire (for this tutorial we used the name label with S1 to S6.)

Export Modulus of Subgrade Reactions Dialog Values Filled

Select OK.

You will see the results in spreadsheet shown below:

Excel Results

As shown in the spreadsheet, each area label is now assigned with category of modulus we have defined, and modulus of subgrade reaction is shown for each load (query results).

This tutorial has shown how to use the multiple load import feature using Settle3 and output the results in spreadsheet for modulus of subgrade reaction. For more detailed information, we encourage you to check out our Online help for multiple load import.

This concludes the tutorial with multiple load import using Settle3.

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