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

Search Results

Automate from Excel for a Combinations Analysis

To automate a Combinations Analysis:

  1. Create a new SWedge model file.
  2. Set up the Project Settings dialog. Select Analysis > Project Settings.
  3. Set Analysis = Combinations.
  4. If a Basal Joint is to be considered, set Block Shape = Basal Joint.
  5. Select OK to close the dialog.
  6. Set up the Combinations Input Data dialog. Select Analysis > Input Data.
  7. Under the Slope page, set the check box, and radio controls as applicable.
  8. Under the Joints page, set the combo box controls as applicable
  9. Joint Planes are not automated inputs from Automate from Excel. If any joint plane orientations (i.e., Dip and Dip Direction) are to be considered in joint combinations, they must be entered into the Combinations Input Data dialog.
  10. Under the Forces page, set the check box and combo box controls as applicable.
    External Forces are not automated inputs from Automate from Excel.
  11. If any external forces are to be applied, they must be entered into the Combinations Input Data dialog.
  12. Under the Water page, set the checkbox, radio, and combo box controls as applicable.
  13. Select OK to close the dialog.
  • Set up the Scale Wedge dialog. Select Analysis > Scale Wedge.
  • Set the check box controls as applicable.
  • Pre-process input data
  1. Save a copy of the input Excel template.
  2. The Excel workbook is protected to prevent accidental manipulation of worksheets. The predefined column header cells are protected to prevent accidental manipulation of input columns.
  3. Each row of input data represents a separate Combinations computation in SWedge (i.e., number of wedges = number of combinations). Enter in all applicable numerical data corresponding to the selections in the Combinations Input Data dialog and the Scale Wedge dialog.
  4. All applicable data must be entered into the Excel input file. If any required columns are left blank, in an incorrect format, or outside the valid range, the Error Log generated from Automate from Excel will indicate these errors.
  5. Save and close the Excel input file.
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 RSWall Settle3 Slide2 Slide3 SWedge UnWedge RocTunnel3 RocSlope2 BlastMetrix ShapeMetriX Fragmenter TestLicense Commercial License Education License Trial License Shop safe & secure Money-back guarantee