There are a variety of data entry shortcuts to speed up the process of data entry including:

• Worksheet Defaults – these can be used to auto-populate fields in new rows
• Execute Many Defaults – define which defaults to use and how many times each default should be applied to generate multiple records in one operation
• Tab into an empty cell that has a pick list attached and the pick list will auto activate
• Mouse or Touchscreen to select from pick list
• Type in first few letters of code to find in picklist, ENTER or TAB off cell to commit code to cell
• CTRL + R to copy down entry in cell
• CTRL + SHIFT + R to copy down entry in cell multiple times
• CTRL + I to increment numeric values by 1 from the selected cell to the cell below
• CTRL + SHIFT + I to increment numeric values by 1 from the selected cell to multiple rows below
• CTRL + ' to copy down entry from cell above

Note: the copy down and increment down functions will not insert new rows into the Worksheet, they only update data in existing rows.

In addition, the standard 'copy' and 'paste' shortcuts can be used to copy data from one cell to another - i.e. Select text to be copied, then Ctrl+c to copy and Ctrl+v to paste.

Each Worksheet can have multiple 'default sets' which make the process of data entry easier. It is possible to set up and use new defaults for each Worksheet. To access these defaults, in any Worksheet click on the Worksheet Default icon from the tool bar on the top of the screen or click on menu item Text Option->Execute->Parameter.

This will open up a form that lists all visible fields in the current Worksheet. The current defaults will also be displayed, similar to the diagram below - these defaults are applied each time a new row is created in the Worksheet:

When a set of defaults is saved using this form it is applied to the individual user based on the computer login. This screen also provides the ability to manage indvidual sets of defaults, saving them with specific names or deleting old/unwanted default sets.

Please note that the Column Name visible in this form is actually the system name and this may be different from the name visible in the logging Worksheet. However, the order the columns appear in this list will be the same as the order in which the columns appear across the Worksheet page.

You can select a column and choose what you want to happen when a new line is created.

• Replicate: Copies the data from the cell above
• Increment: Copies the data from the cell above and adds a user defined value to it
• Ignore: Does nothing, cell is blank
• Copy: Copies data down from nominated cell (generally DepthTo into DepthFrom)
• Default: Inserts the nominated default value

Once the choices have been made, type in a name for the Parameter set (in the space next to ‘Save As’) then select the ‘Save To Current User’ button. In order to make this a default Worksheet, tick the ‘Activate’ box. It is therefore possible to set up a number of default sets for a Worksheet to suit different drill types. For example you may be logging RAB chips at 2m intervals and RC at 1m, in which case you set up two Parameter sets and activate each as appropriate.

Once the Worksheet Row Parameter Defaults have been set up and activated for that Worksheet, whenever the new record is created, all fields with default values defined will be automatically populated.

If this function appears to be broken, then refresh the worksheet by selecting the ‘Refresh’ icon from the toolbar.

Viewing other users' defaults

It is possible to view other users' Worksheet defaults by clicking on one of the entries for that user in the 'tree' menu on the left hand side of "Worksheet Row Parameter Defaults" window. You would then be able to save those defaults under your own user name, by entering a new Worksheet name and clicking on the "Save to Current User" button.

Two options are available to allow insertion of new records into the Worksheet:

• Execute : One – Clicking on this adds one line using the Parameter set saved as the default for the Worksheet. It is the same as adding a new line to the Worksheet
• Execute : Many opens a form that lists all saved parameter sets available to the user:

Enter the number of times each default set is to be used and the order of execution, and click OK. The data is automatically entered as per the default settings. This is particularly useful for repetitive data entry such as Sample Intervals.

The CSV Export utilty will allow you to select specific holes, depth ranges and Worksheets for export. Using this option it is also possible to specify that 'user' column names are used rather than the system-generated column names which may make the exported file easier to work with.

You are also able to specify various options such as a 'default' destination directory for the csv files. Note that the ‘Start Depth’ and ‘End Depth’ selection boxes will only be useable if a single Site/Drillhole is selected. The CSV export exports data regardless of the ExportStatus flag and does not alter this Flag.

CSV exported data may be used as input to various GIS or other 3rd party programs.