Drill Hole CSV Cleaner
drill hole survey CSV ને normalize, sort, અને clean કરો.
missing fields, reversed intervals, duplicates, અને coordinate issues માટે browser-only cleanup.
drill hole survey CSV ને normalize, sort, અને clean કરો.
missing fields, reversed intervals, duplicates, અને coordinate issues માટે browser-only cleanup.
નમૂનામાં depth reversal, overlap અને ગુમ collar depth શામેલ છે.
# 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
નમૂનામાં depth reversal, overlap અને ગુમ collar depth શામેલ છે.
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
હા. તમે applied fixes સાથે નવી CSV export કરી શકો છો.
No, but the cross-table checks are strongest when collar, survey, assay, and lithology are all loaded together.
No. The source text stays as-is until you export a cleaned CSV after choosing fixes.
It flags suspicious ratios, but the unit assumption is still yours to confirm before release.
Use the field mapping controls. The tool also tries common aliases such as hole_id, BHID, from_m, and to_m.
The hole start point and collar location, usually with coordinates and total depth.
A downhole station table with depth, azimuth, and dip values.
ગ્રેડ અથવા રસાયણિક પરિણામો ધરાવતું નમૂના interval table.
A logged geology interval table describing rock types or codes.
Two intervals that claim the same depth range.
A missing depth range between two adjacent intervals.
A sharp change in drillhole direction between survey stations.
When a later row has a smaller depth than the previous row.