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

Search Results

Automate from Excel: Deterministic Analysis

To automate a Deterministic Analysis:

  1. Create a new UnWedge model file
    1. Set up the Project Settings dialog. Select Analysis > Project Settings.
    2. Set Analysis Type = Deterministic
    3. Select OK to close the dialog
  2. Set up the Deterministic Input Data dialog. Select Analysis > Input Data Input Data Icon.
    1. Under the General tab, set the checkbox controls as applicable.
    2. Under the Joint Orientations tab, add the Joints and set their Properties as applicable.
      • If you define more than 3 Joints, automation will be performed assuming all possible joint combinations. The joint orientations are not automatable, and any joint orientations input into the Excel template will be ignored.
      • If you define exactly 3 Joints, this will form only one possible joint combination. All 3 joint orientations are automatable from the Excel template.
    3. Under the Joint Properties tab, add Properties and set their checkbox and combo box controls as applicable.
      • If you define more than 3 Properties, the joint properties are not automatable, and any joint orientations input into the Excel template will be ignored.
        NOTE: Ground/Truncation Surface and Water Pressure Grid are not automated inputs from Automate from Excel. If any water pressure surface or grid are to be applied, they must be defined in the model.
    4. Select OK to close the dialog.
  3. Set up the Field Stress dialog. Select Analysis > Field Stress Field Stress Icon.
    1. Set the checkbox and combo box controls as applicable.
    2. Set the Advanced Settings for Stresses as applicable.
  4. Set up the Scale Wedges dialog. Select Analysis > Scale Wedges Scale Wedge Icon.
    1. Set the checkbox controls as applicable.
    2. Set Wedge to Scale = All Wedges. Automated scaling will be applied to all 10 possible wedges.
  5. Pre-process input data.
    1. Save a copy of the input Excel template.
      NOTE: 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.
      • Each row of input data represents a separate Deterministic computation in UnWedge (i.e., one tunnel).
    2. Enter in all applicable numerical data corresponding to the selections in the Deterministic Input Data dialog and the Scale Wedge dialog.
      NOTE: 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.
    3. Save and close the Excel input file.
  6. Select Automate from Excel Excel Icon from the File menu.
  7. In the Automated Compute dialog:
    1. Add Excel input file(s) to the File Queue by selecting the Open Folder Icon button.
      NOTE: Only files created from UnWedge Automation Template_Deterministic.xlsx can be automated since the project setting and input data setup, and file reading is format-specific to the program UnWedge and to the Analysis Type.
    2. Select the Compute Calculator Icon button to run the analysis and write the results on all Excel input files in the File Queue.
      • If there is only 1 Joint Combination, one Excel file per Excel input file is generated; the results are separated by columns and listed as one tunnel analysis per row.
      • If there are multiple Joint Combinations, one Excel file per analysis case (i.e., row) of the Excel input file is generated; the results are separated by columns and listed as one joint combination per row. Each output file contains number of rows = number of possible joint combinations.
  8. Check the Error Log for any errors detected in the Excel input file. If any errors are reported, correct them in the Excel input file and repeat step 7.
  9. Post-process output data.
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 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