Input format
Strip Logs reads one Excel workbook exported from your drillhole database, with a sheet per database view. The sheets are recognised by their columns, whatever they are called, and the columns can be in any order. Extra columns are ignored.
IDs and codes (HOLEID, SAMPLEID …) must be text cells, so leading zeros survive.
| Sheet | Columns |
|---|---|
| Collar | HOLEID, PROJECTCODE, EAST, NORTH, RL, GRIDNAME, DEPTH |
| HoleDetails | HOLEID, PROJECTCODE, NAME, VALUE |
| Survey | HOLEID, PROJECTCODE, DEPTH, SURVTYPE, PRIORITY, DIP, AZIMUTH, AZIMUTH_SOURCE, AZIMUTH_LOGGED, AZIMUTHTYPE, ADJUSTMENT, AZIMUTHGRIDNAME, AZIMUTH_GD, AZIMUTH_CONFLICT, COLLAR_GRIDNAME |
| Geology | HOLEID, PROJECTCODE, GEOLFROM, GEOLTO, PRIORITY, CATEGORY, CATEGORY_DESC, CONTINUITY, ATTRIBUTE, ATTRIBUTE_DESC, DATATYPE, UNITS, VALUE, VALUE_DESC, SOURCE |
| SampleIntervals | SAMPLEID, HOLEID, PROJECTCODE, SAMPFROM, SAMPTO, SAMPLETYPE, SAMPLETYPE_DESC, PRIORITY, N_CHECKS, N_ASSAY_ROWS |
| Assays | HOLEID, PROJECTCODE, SAMPLEID, SAMPFROM, SAMPTO, SAMPLETYPE, ASSAY, ELEMENT, UNITS, ANALYSISMETHOD, DIGESTTYPE, ASSAY_RANK, PRIORITY, PRIORITY_STATUS, VALUE, DSC, DSC_DESC, LOWERDETECTION, UPPERDETECTION, LABJOBNO, LOADDATE, DESPATCHNO, LABCODE |
| QCDuplicates | HOLEID, PROJECTCODE, SAMPLEID, SAMPFROM, SAMPTO, LABCODE, DESPATCHNO, LABJOBNO, ASSAY, ELEMENT, ASSAY_RANK, ASSAYPRIORITY_OR, ASSAYPRIORITY_CK, ORIG_SAMPLE, CHECK_SAMPLE, ASSAYVALUE_OR, ASSAYVALUE_CK, SENDDATE, RETURNDATE, PAIR_TYPE |
| QCStandardsBlanks | CHECKID, CHECK_LABEL, QC_TYPE, STANDARDID, ASSAY, ELEMENT, PRIORITY, VALUE, DSC, DESPATCHNO, LABJOBNO, LOADDATE |
| Grids | GRIDNAME, GRIDTYPE, PARENTGRIDNAME, ROTATIONANGLE, PROJECTION |
| GridPickup | GRIDNAME, PICKUPNO, LOCALEAST, LOCALNORTH, BASEEAST, BASENORTH |
| HoleCoords | HOLEID, PROJECTCODE, COORDINATESET, X, Y, Z, GRIDNAME, RANK |
Collar, Survey, Geology and Assays draw the log (each assay’s QC status, its PRIORITY, gives the shading); HoleDetails gives Logged by; HoleCoords gives the Report coordinates under Print. SampleIntervals, the QC sheets, Grids and GridPickup are checked in Data health.
In the app, Input format in the header shows the same list, and downloads the demo workbook as an example.