Pembersih CSV Lubang Gerudi

Inspect lubang gerudi CSVs in the pelayar before they leave the kerjastation.

Muat collar, survey, analisis sampel, and likelogi jaduals kegether, Semak mismatches, and eksport CSV bersihs without sending the data ke a pelayan.

Tiada pendaftaran / Percuma Pemprosesan dalam pelayar sahaja Semaks four jaduals kegether

Cara guna

  1. Muat or paste the collar, survey, analisis sampel, and likelogi CSVs.
  2. Confirm the detected pengepalas and adjust the pemetaan medan if needed.
  3. Pilih the units and cleanup tetapan that match the source fails.
  4. Jalankan pengesahan, then Semak the isu list and suggestions.
  5. Terapkan selamat fixes and muat turun the CSV bersihs plus the laporan isu.

Contoh

Mixed lubang gerudi QA sampel

The sampel includes a pembalikan kedalaman, an pertindihan, and a hilang collar kedalaman.

Input di Padang
# 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

Output jangkaan

The sampel includes a pembalikan kedalaman, an pertindihan, and a hilang collar kedalaman.

Output jangkaan
Errors: 4
Warnings: 2
Fixable: 3
- DH-001 survey 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

Soalan Lazim (FAQ)

Can I use it offline?

Yes. Pemprosesan stays in your pelayar and the CSV content is not uploaded ke a pelayan.

Do I need all four jaduals?

No, but the cross-jadual checks are strongest when collar, survey, analisis sampel, and likelogi are all loaded kegether.

Will it change my original fail?

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

Can it detect feet-versus-meters mistakes?

It flags suspicious ratios, but the unit assumption is still yours ke confirm before release.

What if my pengepala names are different?

Guna the pemetaan medan kawalans. The alat also tries common aliases such as hole_id, BHID, daripada_m, and ke_m.

Glosari

Collar

The hole start point and collar location, usually with koordinat and kedalaman ketal.

Survey

A downhole station jadual with kedalaman, azimut, and kemiringan values.

Analisis sampel

A sampel julat jadual with grade or chemistry hasils.

Litologi

A logged geology julat jadual describing rock types or codes.

Pertindihan

Two julats that claim the same kedalaman range.

Jurang

A hilang kedalaman range between two adjacent julats.

Dogleg

A sharp change in lubang gerudi direction between stesen surveys.

Kedalaman reversal

When a later baris has a smaller kedalaman than the previous baris.