Rocscience International Conference 2025 is going to take place in Sydney, Australia Read more

Search Results

Starting an AGS Project

Before starting the import process, please ensure the open Excel workbook is empty. Once the import process begins, all existing sheets will be deleted! Once you have signed in to the Excel Add-in successfully, the following screen will appear:

Upload from AGS 4.1 Screen

If you have an AGS 4.1 file, Drag and Drop your file or select Choose file to open your system file dialog. Once a file is uploaded, a progress bar will appear while the file is processed and converted to an AGS Excel workbook.

If you want to create an AGS project from scratch, select the “Create AGS” button, which presents the following:

Create AGS Screen

Here, you can select all the AGS 4.1 sheets you want to create in your AGS project. The Disabled sheets “PROJ, ABBR, DICT, TRAN, TYPE, UNIT” are selected by default and are required for RSLog compatibility. A search bar is also at the top to quickly help you find a sheet. You can scroll and select through all AGS sheets as necessary, and once done, select the Add Sheet(s) button to initiate the project.

Home Page

After a successful file import or create AGS from scratch, you will be presented with the home page:

AGS Home Page

The main Add-in page has the following three sections:

  1. All Sheets: In this card, you can add either standard or user-defined sheets. Additionally, you can delete sheet(s) as well. Please check their associated sections to check the functionality available for each button. The three dots on the top right of the card reveal a button to Autofit All tables in the AGS worksheets.
  2. Current Sheet: The current sheet card can search all AGS Groups in the Excel workbook through a dropdown menu. Once an option is selected, the active worksheet in Excel reflects the chosen group. In the edit column(s) split button, you can add a standard, user-defined, or delete a column in the current worksheet. In the edit row(s) split button, you can add or delete rows from the table in the active sheet.

There are three buttons below the Current Sheet card:

  • Export to AGS: Once clicked, an AGS 4.1 file will be created based on the Excel workbook, and a system file dialog opens to choose where in your computer directory to save the AGS file.
  • Sync to RSLog: Once clicked, the program checks if a project has been created inside of RSLog already. Otherwise, it will create a new one inside of the RSLog Database. Basic Project information and a list of Boreholes from the LOCA group are stored.

A coordinate system is also set for the project based on the LOCA group.

  • The default coordinate system is set to Local (X, Y).
  • If All boreholes in the LOCA group have values for LOCA_LAT and LOCA_LON, then the coordinate system is set to Geographic
  • If All boreholes have values for LOCA_GREF, then the coordinate system is set to Projected with its associated ESPG code
  • If LOCA_GREF is not set, but all entries for LOCA_NATE and LOCA_NATN are set, the coordinate system is set as UTM

You will be notified if the coordinate system is unidentified, in which case the default coordinate system is used. Once the data is successfully saved in RSLog, you can open RSLog to interact with the GIS map to look at all available boreholes

  • Generate Log(s): The Generate Log(s) page opens once clicked. Check the Borehole Generation Tab in the documentation for more information.

  • Imported File(s): This card will display all files that have been imported into this project. On the top right is an import button to attach extra files to the current workbook. Note that the current import feature does not remove duplicate entries!

Editing Data

The AGS Excel Add-in also makes navigating Excel and manipulating AGS data easier.

AGS Excel Add-in Dialog

Above are the first few action buttons: Add Sheet(s) and Delete Sheet(s)

  1. Add Standard Sheet(s)
  2. Add Standard Sheet dialog

    Here, you can select any number of AGS groups that don’t exist in the current workbook in the scrollable card.

  3. Add User-Defined Sheet(s)
  4. User-Defined Sheets

    You can specify the Sheet Name and Sheet Description, creating a user-defined group.

  5. Delete Sheet(s)
  6. Delete Sheets Dialog

    Here, you can delete any sheet that is not mandatory for AGS files. The following section on the home page is the Current Sheet.

    Delete Options 1

    Add Options drop-down menu


    Above are the following manipulation buttons, only enabled inside AGS sheets.

  7. Add User-Defined Columns
  8. Add User-Defined Columns Dialog

    A new user-defined column requires the above information and will create an entry inside the DICT sheet. Data Type and Unit also have associating dropdowns that have an AGS compliant list of possibilities.

  9. Add Standard AGS Column(s)
  10. Add Standard AGS Columns Dialog

    Any AGS standard columns that don’t already exist inside of the active sheet appear here.

  11. Delete Column(s)
  12. Select Columns to Delete Dialog

    The list of possible columns to delete is populated based on the active Excel sheet.

  13. Add Row
  14. This button will add a row below the final row in the active table.

  15. Add Multiple rows
  16. Add Multiple Rows Dialog

    Any number of rows can be added to the active table in the above Modal. Another data manipulation helper is the magic wand, which is present in every standard AGS column.

    Standard AGS Column Options

    Clicking the wand opens a pop-up card, providing additional information on a standard column: Data Type, Description, Unit.

    Additionally, cells with the data type PA have an associating dropdown with possibly AGS values for that cell:

    Excel Cell Dialog

Rocscience logo, click here to return to the homepage Portal Account Portal Account Log In Log Out Home 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" Previous Next 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 X page Click here to visit Rocscience's Facebook page Click here to visit Rocscience's Instagram page Click here to visit Rocscience's Reddit page Bookmark Network Scroll down for more Checkmark Download Print Back to top Single User Multiple Users RSLog RocFall3 CPillar Dips EX3 RocFall RocPlane RocSlope3 RocSupport RocTopple RS2 RS3 RSData RSPile RSWall Settle3 Slide2 Slide3 SWedge UnWedge RocTunnel3 RocSlope2 BlastMetrix ShapeMetriX Fragmenter TestLicense Commercial License Education License Trial License Shop safe & secure Money-back guarantee