The tutorial files are a set of excel sheets that have been designed to introduce you to the basics of KeyAGS and its powerful features. Although these templates are mainly aimed at being used in a learning capacity, they may also be useful in some production environments.
To download any of these files, please put in a service request with our support team at https://apps.bentley.com/srmanager/ProductSupport with the filename in the description and a member of our support team will send a copy of the file to you.
| Item | Version | Description | Filename | Date Added |
|---|---|---|---|---|
| Key Fields do not need repeating | 1.0 | This simple example illustrates how the key field data does not need to be repeated for each row. In this example the PROJ_ID and HOLE_ID are not completed for the second row, as they are key fields KeyAGS will insert the last values instead of the blanks when it converts it. | Technique Tutorial No 1.xlt | 04th April 2016 |
| Using the Picklist Picker | 1.0 | This sample can be used to practice using the pick list picker. | Technique Tutorial No 2.xlt | 04th April 2016 |
| Converting Data from More than One Sheet | 1.0 | This example shows how data can be converted from more than one worksheet in a spreadsheet. | Technique Tutorial No 3.xlt | 04th April 2016 |
| Conflicting Data | 1.0 | This Example shows how data with the same Key Fields but different common fields will create an error when converting. | Technique Tutorial No 4.xlt | 04th April 2016 |
| Implementing the STOP Keyword | 1.0 | This sheet has been set up to work with a large number of rows with an equation based STOP keyword. | Technique Tutorial No 5.xlt | 04th April 2016 |
| Implementing Error Checking | 1.0 | This sheet has two Error Columns specified (H and I). In each of these columns there is a set of equations that will write text in the column if one of the rules is broken. | Technique Tutorial No 6.xlt | 04th April 2016 |
| Defining Table Output | 1.0 | This example shows how the creation of tables can be defined using the tables= command after the STOP column keyword. | Technique Tutorial No 7.xlt | 04th April 2016 |
| Contamination Conversion | 1.0 | This example shows how the Contamination Converter Functions. | Technique Tutorial No 8.xlt | 04th April 2016 |
| Using Grouping for PSD data | 1.0 | This page uses the array function in KeyAGS to create multiple entries from a single line of data. Each sieve size has a grad_perp and a grad_size record and each one has been set up with a different array number I.e cell G10 contains grad_size_001 and I10 contains grad_size_002 etc. | Technique Tutorial No 9.xlt | 04th April 2016 |