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 .
   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.
      Ground/Truncation Surface and Water Pressure Grid are not automated inputs from Automate from Excel. If any water pressure surface or grid is 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 .
   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 .
   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.
   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.
   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 from the File menu.
7. In the Automated Compute dialog:
   1. Add Excel input file(s) to the File Queue by selecting the Open button.
   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 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.