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

• 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

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 - these defaults are applied each time a new row is created in the Worksheet:

This screen also provides the ability to manage indvidual sets of defaults, saving them with specific names or deleting old/unwanted default sets.

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 left blank
• Copy: Copies data down from a specified cell (e.g. 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.

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

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.