Automate from Excel for a Combinations Analysis
To automate a Combinations Analysis:
- Create a new SWedge model file.
- Set up the Project Settings dialog. Select Analysis > Project Settings.
- Set Analysis = Combinations.
- If a Basal Joint is to be considered, set Block Shape = Basal Joint.
- Select OK to close the dialog.
- Set up the Combinations Input Data dialog. Select Analysis > Input Data.
- Under the Slope page, set the check box, and radio controls as applicable.
- Under the Joints page, set the combo box controls as applicable
- Under the Forces page, set the check box and combo box controls as applicable.
External Forces are not automated inputs from Automate from Excel. - Under the Water page, set the checkbox, radio, and combo box controls as applicable.
- Select OK to close the dialog.
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.
If any external forces are to be applied, they must be entered into the Combinations Input Data dialog.
- Set up the Scale Wedge dialog. Select Analysis > Scale Wedge.
- Set the check box controls as applicable.
- Pre-process input data
- Save a copy of the input Excel template.
- 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.
- Save and close the Excel input file.
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.
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.