Auditing a Tenement List

LandTracker allows you to audit your spreadsheets against the data service. See Update from LandTrack Data Service.

1. Open Due Diligence screen.

2. Upload the spreadsheet that contains the tenement set you wish to audit. See Manage Tenement Sets.

   Important: The fields of Tenement ID Column, Jurisdiction Column, and Default must be in upper case for the audit to function.

3. Click Edit Column Map.

   A window displays columns to be mapped.

   Note: Columns displayed are defined as follows:

   • ColNo—Number associated with spreadsheet column.
   • Column—Letter associated with spreadsheet column.
   • Header—Header in your spreadsheet.
   • MapTo—LandTracker data type.
   • Match Order—When multiple columns exist for the same data, you can choose the priority of the columns to retrieve the match.
   • Conversion—Convert data to a special format such as date or money.
   • Options—Designed to specify select conversions to perform, not yet implemented.

   Note: They may be empty; however, data may also be stored from a previous search. be sure to update the list to ensure you are using the current data.

4. Click Load Column List.

   The data from your spreadsheet displays in the columns.

   Note: LandTracker automatically maps columns with recognisable headers to the MapTo column. If it is empty or incorrectly mapped, you can select a new destination from the menu.

5. Update the MapTo column by selecting an option from the menu, if required.

6. To add a column without losing your mapped columns:

   1. Add the column at the end of your spreadsheet and save.

   2. Click Update List.

      The screen adds the column to the end of the column map.

      Note: The new column must be at the end of your spreadsheet. If you add a column to the middle of your spreadsheet the update still adds the column at the end of the list and then requires you to re-map.

7. Click OK.

8. In the Due Diligence screen, click Load Tenement List.

   The Auditing area activates, with Audit Only pre-selected. The Results area displays the number of tenements located.

9. In the Auditing area, select any combination of the following:

   • Audit Only—When selected it creates an audit sheet with results but doesn't change the original sheet cells. Deselecting it updates differences directly on the original sheet.
   • Append Date to Audit Sheet—Includes today’s date in the worksheet name.

   • Remove Missing Tenements—Creates audit sheet displaying changes and deletes invalid tenement IDs from the original worksheet.

     Note: Audit Only must be deselected for Remove Missing Tenements audit to function.

10. Click Audit Spreadsheet.

    A workbook opens with results of selected audit criteria.

    When requested, a separate sheet is created for the audit results. The results are colour-coded in the following manner:

    • Green—No changes made.
    • Yellow—Different value to what is in the database. The databases value is inserted into the cell while the original value is placed into a cell comment.

    • Red—Indicates the row does not match the tenement ID. If duplicate tenement ID's are found, the second and subsequent instances are marked in red.

      Note: If checking a spreadsheet for duplicate tenement IDs, not that they may be in multiple formats that Excel may not identify as the same (example: M25/27. M 26/27, M26/027).

    • Orange—Indicates values have been inserted from the database into a cell that was previously empty.
    • Uncoloured—Indicates they have not been audited because they were not mapped to database fields or the tenement ID is unrecognisable.