Foraj Gaură CSV Cleaner

Inspect drillhole CSVs in the browser before they leave the workstation.

Încarcă collar, inventar, assay, and lithology tables together, review mismatches, and export clean CSVs without sending the data to a server.

Nu signup / Free Browser-only processing Verificăs four tables together

How to use

  1. Încarcă or paste the collar, inventar, assay, and lithology CSVs.
  2. Confirm the detected headers and adjust the field mapping if needed.
  3. Choose the unități and cleanup setări that match the source files.
  4. Run validation, then review the issue list and suggestions.
  5. Apply safe fixes and download the clean CSVs plus the issue report.

Exemplu

Mixed drillhole QA exemplu

The exemplu includes a depth reversal, an overlap, and a missing collar depth.

Intrare
# collar.csv
hole_id,x,y,z,total_depth,project
DH-001,500000,6200000,1250,305,Nurth Ridge
DH-002,500120,6200120,1242,,South Ridge
DH-003,500240,6200250,1238,180,South Ridge

# inventar.csv
hole_id,depth,azimut,înclinare
DH-001,0,90,-60
DH-001,50,92,-58
DH-001,45,94,-57
DH-002,0,110,-65
DH-003,0,180,-70
DH-003,30,181,-69

# assay.csv
hole_id,from,to,au_gpt,cu_pct
DH-001,0,10,0.12,0.18
DH-001,10,20,0.19,0.22
DH-001,18,30,0.21,0.25
DH-002,0,15,0.05,0.09
DH-003,40,30,0.08,0.11

# lithology.csv
hole_id,from,to,lithology,code
DH-001,0,25,Oxidized,OX
DH-001,25,55,Fresh,FR
DH-002,10,40,Andesite,AN
DH-003,0,20,Basalt,BA

Expected rezultat

The exemplu includes a depth reversal, an overlap, and a missing collar depth.

Expected rezultat
Errors: 4
Warnings: 2
Fixable: 3
- DH-001 inventar depth reversal at 45 m
- DH-001 assay overlap at 18-20 m
- DH-002 collar is missing total depth
- DH-003 lithology extends past collar depth

Întrebări frecvente

Can I use it offline?

Da. Processing stays in your browser and the CSV content is not uploaded to a server.

Do I need all four tables?

Nu, but the cross-tabel checks are strongest when collar, inventar, assay, and lithology are all loaded together.

Will it change my original file?

Nu. The source text stays as-is until you export a cleaned CSV after choosing fixes.

Can it detect feet-versus-meters mistakes?

It flags suspicious ratios, but the unitate assumption is still yours to confirm before release.

What if my header names are different?

Folosește the field mapping controale. The instrument also tries common aliases such as hole_id, BHID, from_m, and to_m.

Glossary

Collar

The gaură start point and collar location, usually with coordinates and total depth.

Inventar

A downhole station tabel with depth, azimut, and înclinare values.

Assay

A exemplu interval tabel with grad or chemistry rezultate.

Lithology

A logged geology interval tabel describing rock types or codes.

Overlap

Two intervals that claim the same depth range.

Gap

A missing depth range between two adjacent intervals.

Dogleg

A sharp change in drillhole direction between inventar stations.

Depth reversal

When a later row has a smaller depth than the previous row.