# Automate from Excel for a Probabilistic Analysis

To automate a Probabilistic Analysis:

1. Create a new SWedge model file.
2. Set up the Project Settings dialog. Select Analysis > Project Settings.
3. Set Analysis = Probabilistic.
4. If a Basal Joint is to be considered, set Block Shape = Basal Joint.
5. Set the Sampling Method and Number of Samples.
6. Select OK to close the dialog.
7. Set up the Probabilistic Input Data dialog. Select Analysis > Input Data.
8. Under the Slope page, set the check box controls as applicable.
9. Under the Upper Face page, set the check box controls as applicable.
10. Under the Joint1, Joint2, and Basal Joint pages, set the combo box controls as applicable.
11. Under the Strength1, Strength2, and Basal Strength pages, set the combo box controls as applicable.
12. Under the Tension Crack page, set the check box, radio, and combo box controls as applicable.
13. Under the Seismic page, set the check.box and combo box controls as applicable.
14. External Forces are not automated inputs from Automate from Excel. If any external forces are to be applied, they must be entered into the Probabilistic Input Data dialog.
15. Under the Ponded Water and Joint Water pages, set the check box, radio, and combo box controls as applicable.
16. Select OK to close the dialog.
17. Set up the Scale Wedge dialog. Select Analysis > Scale Wedge from the menu.
18. Set the check box controls as applicable.
19. Pre-process input data.
20. Save a copy of the input Excel template.
21. 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.
22. Each row of input data represents a separate Probabilistic computation in SWedge (i.e., number of wedges = number of samples). Enter in all applicable numerical data corresponding to the selections in the Probabilistic Input Data dialog and the Scale Wedge dialog.
23. 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. Depending on the Statistical Distribution set for random variables, the Mean Value, in addition to the Standard Deviation, Relative Minimum and Relative Maximum may be required.
24. Save and close the Excel input file.
25. Select Automate from Excel option from the Analysis menu.
26. In the Automated Compute dialog:
27. Add Excel input file(s) to the File Queue by selecting the Open button.
28. Only files created from SWedge Automation Template_Probabilistic.xlsx can be automated since the project setting and input data setup, and file reading is format-specific to the program SWedge and to the Analysis Type.
29. Select the desired Output File Format (either Text File or Excel) of the results file in the combo box dropdown.
• One text file per Excel input file row (i.e., per case) is generated; the results are comma-delimited and listed as one wedge per row.
• One Excel file per Excel input file row (i.e., per case) is generated; the results are separated by columns and listed as one wedge per row.
30. Select the Compute button to run the analysis and write the results on all Excel input files in the File Queue.
31. 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 6.
32. Post-process output data.