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, SampleIntervals and Assays draw the log; the QC sheets add the trust shading; Grids, GridPickup and HoleCoords check the coordinates (and HoleCoords gives the Report coordinates under Print).
In the app, Input format in the header shows the same list, and downloads the demo workbook as an example.