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 RocTopple model file
  2. Set up the Project Settings dialog. Select Analysis > Project Settings.
  3. Set Analysis = Deterministic
  4. Under the Toppling Model tab, set the Toppling Model as applicable.
  5. Select OK to close the dialog
  6. Set up the Deterministic Input Data dialog. Select Analysis > Input Data.
  7. Under the Geometry tab, set the check box controls as applicable.
  8. Under the Point of Force Application tab, set the controls as applicable.
  9. Under the Base and Bedding Strength tab, set the combo box controls as applicable.
  10. Under the Internal Rock Strength tab (only available if Toppling Model = Block Flexure Toppling), set the combo box controls as applicable.
  11. Select OK to close the dialog.
  12. Set up the Seismic Load dialog. Select Loading > Seismic Load.
  13. NOTE: Line Loads and Distributed Loads are not automated inputs from Automate from Excel. If any external forces are to be applied, they must be already defined and placed in the model (and are to be used for all automation cases).

  14. Set up the Water Pressure dialog. Select Water > Water Pressure Options.
  15. Select Pore Pressure in Joints radio control to automate % Fill.
  16. NOTE: The phreatic surface is not an automated input from Automate from Excel. If a phreatic surface is to be applied, it must be already defined and placed in the model (and are to be used for all automation cases).

  17. Pre-process input data.
  18. Select Analysis > Automate Compute > Deterministic Excel Template.
  19. A blank Deterministic Excel Template will open.

    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 RocTopple (i.e., one topple analysis).

  20. Save a copy of the input Excel template.
  21. Enter in all applicable numerical data corresponding to the selections in the Deterministic Input Data dialog, Seismic Load dialog, and Water Pressure dialog.
  22. Save and close the Excel input file.
  23. 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.

  24. Select Automate from Excel from the Analysis menu.
  25. In the Automated Compute dialog:
  26. Add Excel input file(s) to the File Queue by selecting the Add Files or Add Folder button.
  27. NOTE: Only files created from RocTopple Automation Template_Deterministic.xlsx can be automated since the project setting and input data setup, and file reading is format-specific to the program RocTopple and to the Analysis Type.

  28. 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 is generated; the results are comma delimited and listed as one topple analysis per row. One Excel file per Excel input file is generated; the results are separated by columns and listed as one topple analysis per row.
  29. Select the Compute button to run the analysis and write the results on all Excel input files in the File Queue.
  30. 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.
  31. 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