Čistilec CSV vrtin

Inspect drillhole CSVs in the brskalnik before they zapusti the workstation.

Naloži collar, survey, analiza, and lithology tabele together, preglej mismatches, and izvozi očiščen CSVs without sending the data to a server.

Brez prijave / brezplačno Obdelava samo v brskalniku Skupaj preveri štiri tabele

Kako uporabljati

  1. Naloži or paste the collar, survey, analiza, and lithology CSVs.
  2. Potrdite zaznane glave stolpcev in po potrebi prilagodite preslikavo polj.
  3. Izberite enote in nastavitve čiščenja, ki ustrezajo izvornih datotekam.
  4. Zaženite preverjanje, nato preglejte seznam težav in predloge.
  5. Uporabite varne popravke in prenesite očiščene CSV-je ter poročilo o težavah.

Primer

Mixed drillhole QA vzorec

The vzorec includes a globina reversal, an overlap, and a missing collar globina.

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

# survey.csv
hole_id,depth,azimuth,dip
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

Pričakovani izhod

The vzorec includes a globina reversal, an overlap, and a missing collar globina.

Pričakovani izhod
Errors: 4
Opozorila: 2
Fixable: 3
- DH-001 survey globina reversal at 45 m
- DH-001 analiza overlap at 18-20 m
- DH-002 collar is missing skupni globina
- DH-003 lithology extends past collar globina

Pogosta vprašanja

Can I uporabi it offline?

Da. Obdelava stays in your brskalnik and the CSV content is not uploaded to a server.

Do I need all four tabele?

Ne, but the cross-tabela preveri are strongest when collar, survey, analiza, and lithology are all loaded together.

Will it change my original datoteka?

Ne. The vir text stays as-is until you izvozi a cleaned CSV after choosing popravki.

Ali lahko zazna napake med čevlji in metri?

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

Kaj, če so imena mojih glav stolpcev drugačna?

Uporabi the field mapping controls. The orodje also tries common aliases such as hole_id, BHID, from_m, and to_m.

Slovar

Collar

The vrtina start point and collar lokacija, usually with coordinates and skupni globina.

Survey

A downhole merilna točka tabela with globina, azimuth, and dip vrednosti.

Analiza

A vzorec interval tabela with vsebnost or chemistry results.

Lithology

A logged geology interval tabela describing rock types or codes.

Overlap

Two intervali that claim the same globina obseg.

Razlika

A missing globina obseg between two adjacent intervali.

Dogleg

Ostra sprememba smeri vrtine med merilnimi postajami.

Globina reversal

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