Čistač CSV-a bušotina

Pregledajte CSV datoteke bušotina u pregledaču pre nego što napuste radnu stanicu.

Učitajte tabele collar, survey, assay i lithology zajedno, pregledajte neslaganja i izvezite čiste CSV datoteke bez slanja podataka na server.

Bez registracije / besplatno obrada samo u pregledaču Checks four tabelas together

Kako koristiti

  1. učitaj or paste the ušće bušotine, merenja, analize, and litologija CSVs.
  2. Confirm the detected headers and adjust the polje mapping if needed.
  3. Choose the units and cleanup podešavanja that match the source files.
  4. Run validation, then review the problem list and suggestions.
  5. Apply bezbedne ispravke and preuzmi the clean CSVs plus the problem report.

Primer

Primer QA provere bušotine

The sample includes a depth reversal, an overlap, and a missing ušće bušotine depth.

Ulaz
# ušće bušotine.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

# merenja.csv
hole_id,depth,azimut,pad
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

# analize.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

# litologija.csv
hole_id,from,to,litologija,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

Očekivani izlaz

The sample includes a depth reversal, an overlap, and a missing ušće bušotine depth.

Očekivani izlaz
greške: 4
upozorenja: 2
Fixable: 3
- DH-001 merenja depth reversal at 45 m
- DH-001 analize overlap at 18-20 m
- DH-002 ušće bušotine is missing ukupna dubina
- DH-003 litologija extends past ušće bušotine depth

ČPP

Can I use it isključenoline?

Yes. Processing stays in your bredovier and the CSV content is not upučitajed to a server.

Do I need all four tabelas?

No, but the cross-tabela checks are strongest when ušće bušotine, merenja, analize, and litologija are all učitajed together.

Da li će promeniti moju originalnu datoteku?

No. The source text stays as-is until you izvezi a cleaned CSV after choosing ispravke.

Može li da otkrije greške između stopa i metara?

Označava sumnjive odnose, ali pretpostavku o jedinicama ipak morate sami potvrditi pre objavljivanja.

Šta ako su nazivi mojih zaglavlja drugačiji?

Use the polje mapping controls. The tool also tries common aliases such as hole_id, BHID, from_m, and to_m.

Rečnik

ušće bušotine

The hole start point and ušće bušotine location, usually with coordinates and ukupna dubina.

merenja

A downhole station tabela with depth, azimut, and pad values.

analize

A sample interval tabela with sadržaj or chemistry rezultati.

litologija

A logged geology interval tabela describing rock types or codes.

Overlap

Dva intervala koja zauzimaju isti opseg dubine.

Gap

Nedostajući opseg dubine između dva susedna intervala.

Dogleg

A sharp change in bušotina direction between merenja stations.

Obrt dubine

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