Key Features

1. Drillhole data model — collar, survey (deviated holes), assay intervals, QAQC flags
2. CSV import wizard — 3-step import for Surpac, MineSight, and Leapfrog formats
3. Compositing — length-weighted with configurable interval and tail-cap percentage
4. Resource statements — JORC 2012 and NI 43-101 with modifying factors
5. Dual sign-off — draft → under_review → approved → superseded workflow
6. Geology dashboard — high-grade intercepts, campaign progress, QAQC status

Competent Person Setup

JORC 2012 and NI 43-101 resource statements require a Competent Person (CP) or Qualified Person (QP). To designate a CP:

1. Go to :menuselection:`Employees`.
2. Open the employee's record.
3. Check the :guilabel:`Is Competent Person` checkbox.
4. Fill in the organisation and membership reference fields.

Creating a Drillhole Collar

1. Go to :menuselection:`Mining Geology --> Drillholes --> Collars`.
2. Click :guilabel:`Create`.
3. Fill in the hole ID (unique per site), collar coordinates (easting/northing/elevation), azimuth (0–360°), dip (negative downward), total depth, and drilling method.
4. Link to a campaign.
5. Click :guilabel:`Start Drilling` to move to drilling state.

Adding Assay Intervals

From the collar form, open the :guilabel:`Assay Intervals` tab:

1. Click :guilabel:`Add a line`.
2. Set from_depth_m and to_depth_m (must not overlap with existing intervals).
3. Set lithology, recovery %, and add element values (one per row).
4. Set the QAQC flag for each value: ok, standard_used, blank_used, duplicate_used, or failed.

Importing Assay Data from CSV

1. Go to :menuselection:`Mining Geology --> Import --> Import Drillhole CSV`.
2. Step 1 — Upload your CSV file.
3. Step 2 — Map columns to system fields. Surpac, MineSight, and Leapfrog presets are available for automatic column aliasing.
4. Step 3 — Review the validation report:
   • BLOCK errors must be resolved before import (overlaps, missing elements)
   • WARN errors are imported with a flag (missing recovery, QAQC = failed)

Performance target: 50,000-row assay file imports in under 90 seconds.

Running Composites

1. Go to :menuselection:`Mining Geology --> Analysis --> Composite Runs`.
2. Click :guilabel:`Create`.
3. Select collars and elements to composite; set interval length (default 2.0m) and tail-cap % (default 25%).
4. Click :guilabel:`Compute` — composite lines are created with length-weighted grades.

For each composite interval of length L:
  composite_grade = Σ (assay_value × assay_length) / Σ assay_length

Tail intervals shorter than tail_cap_pct × L are discarded.

JORC / NI 43-101 Resource Statements

1. Go to :menuselection:`Mining Geology --> Reports --> Resource Statements`.
2. Click :guilabel:`Create`.
3. Select the reporting code (JORC 2012 or NI 43-101).
4. Select the signing Competent Person (must have is_competent_person = True).
5. Add category lines (inferred, indicated, measured, probable reserve, proven reserve).
6. Add modifying factors (mining, metallurgical, economic, environmental, legal, social, governmental).
7. Click :guilabel:`Submit for Review` → :guilabel:`Approve`.

Overlap Detection

The system prevents assay intervals from overlapping using a SQL constraint check. The import wizard also detects overlaps as BLOCK errors during the validation step.

QAQC Flag Propagation

QAQC flags are stored per element value. A failed QAQC flag does not automatically exclude an interval from compositing — it is flagged for geologist review via the activity system. The geologist must manually decide whether to exclude or accept.