Тозакунандаи CSV-и чоҳи пармакунӣ

CSV-ҳои чоҳи пармакуниро дар браузер пеш аз он ки аз истгоҳи корӣ хориҷ шаванд, санҷед.

Ҷадвалҳои оғози чоҳ, сурвей, анализ ва литология-ро якҷоя бор кунед, номувофиқатиро баррасӣ кунед ва CSV-ҳои тозаро бе фиристодани додаҳо ба сервер содир кунед.

Бе сабти ном / Ройгон Коркарди танҳо дар браузер Чаҳор ҷадвалро якҷо месанҷад

Чӣ тавр истифода бурдан

  1. Бор кардан or paste the оғози чоҳ, сурвей, анализ, and литология CSVs.
  2. Confirm the detected headers and adjust the мувофиқсозии майдон if needed.
  3. Интихоб кунед the воҳидҳо and cleanup танзимот that match the source files.
  4. Санҷишро иҷро кунед, then баррасӣ the issue list and suggestions.
  5. Ариза диҳед ислоҳҳои бехатар and download the clean CSVs plus the гузориши масъалаҳо.

Намуна

Mixed чоҳи пармакунӣ QA sample

The sample includes a depth reversal, an overlap, and a missing оғози чоҳ depth.

Вуруд
# оғози чоҳ.CSV
hole_id,x,y,z,total_depth,project
DH-001,500000,6200000,1250,305,Неrth Ridge
DH-002,500120,6200120,1242,,Ҷануб Ridge
DH-003,500240,6200250,1238,180,Ҷануб Ridge

# сурвей.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

# анализ.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

# литология.CSV
hole_id,from,to,литология,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 output

The sample includes a depth reversal, an overlap, and a missing оғози чоҳ depth.

Expected output
Хатоҳо: 4
Огоҳӣҳо: 2
Ислоҳшаванда: 3
- DH-001 сурвей depth reversal at 45 m
- DH-001 анализ overlap at 18-20 m
- DH-002 оғози чоҳ is missing total depth
- DH-003 литология extends past оғози чоҳ depth

Саволҳои маъмул

Can I истифода it offline?

Ҳа. Processing stays in your браузер and the CSV content is not uploaded to a server.

Do I need all four tables?

Не, but the cross-table checks are strongest when оғози чоҳ, сурвей, анализ, and литология are all loaded together.

Will it change my original file?

Не. 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 Воҳид assumption is still yours to confirm before release.

What if my header names are different?

Истифода баред the мувофиқсозии майдон назоратҳо. The tool also tries common aliases such as hole_id, BHID, from_m, and to_m.

Луғат

Қафаси чоҳ

The чоҳ start point and оғози чоҳ location, usually with coordinates and total depth.

Сурвей

A downhole station table with depth, azimuth, and dip values.

Анализ

A sample interval table with grade or кимиё натиҷаҳо.

Литология

A logged geology interval table 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 чоҳи пармакунӣ Самт between сурвей stations.

Depth reversal

When a later Қатор has a smaller depth than the previous Қатор.