Ajuda

Blast Design Exchange

Moves blast hole data in and out of the project: the hole table and the drill plan go out to the rig, the surveyor and the detonator logger; drilling, dip, charging, survey and MWD files come back into the holes. Each command has its own section; press F1 over a ribbon button to open it.

All commands work on blast blocks. Commands that write into the holes use the selected blocks, or every block that is not on a locked layer when none is selected.

Export Holes

Writes the hole table of the blast blocks to a CSV file or a DXF drawing.

Where to find it

Blast Design tab → Drilling group → Export Holes. The same button is on the Blast block tab, in the Drilling group.

Before you start

• At least one blast block in the project. Without one the button is off ("The project has no blast blocks.").
• Select the blocks to export. With none selected, every block is exported.

How to

1. Click Export Holes.
2. In the Export holes dialog choose the file type: Hole table (\.csv) or AutoCAD DXF (\.dxf). If exactly one block is exported, its name is suggested as the file name.
3. Click Save. A message tells you how many holes of how many blocks were written.

What is written

The file type follows the extension: .dxf gives a drawing, anything else the CSV table.

CSV. One row per hole, with the columns separated by semicolons and a decimal point, so it opens in a spreadsheet under any regional settings. The file has a byte-order mark. Lengths are in metres, angles in degrees (dip from horizontal, negative down). Excluded holes are written too. The columns, in order:

The project's own hole attributes follow as extra columns, each named as the attribute.

The same table, filled in, can be read back with Import Drilling Fact: the drilling fact columns use the names that import reads.

DXF. For the surveyor. Each block's contour and, per hole, a point at the collar, a line from the collar to the toe and the hole number beside the collar, each kind on its own layer:

If something goes wrong

What next

Import Drilling Fact · Drill Plan for the Rig (IREDES)

Drill Plan for the Rig (IREDES)

Writes the drill plan of the selected blast blocks in IREDES, the open format that Epiroc and Sandvik surface drill rigs take.

Where to find it

Blast Design tab → Drilling group → More drop-down → Plan for the Rig (IREDES)…. On the Blast block tab it is in the Drilling group.

Before you start

Select the blast blocks to export. This command does not fall back to all blocks.

How to

1. Select the blocks and click Drill Plan for the Rig (IREDES).
2. In the Drill plan for the rig dialog choose the file name (type IREDES drill plan (*.xml)). The names of the blocks are suggested.
3. Click Save. A message gives the number of holes and blocks written.

What is written

A DRPPlan document with one Hole per hole that is not excluded, block by block, row by row. Each hole has:

• its number in the plan (1, 2, …) and its name; with more than one block the name is prefixed Block/Hole so equal names stay apart;
• the collar (StartPoint) and the bottom (EndPoint) in the project's coordinates;
• the type of hole and the bit diameter, in millimetres;
• MWD switched on.

Only the design is written, not the drilling fact. The file is indented UTF-8 without a byte-order mark, which some rig software cannot read.

If something goes wrong

What next

The rig's quality log comes back through Import Drilling Fact.

Import Drilling Fact

Reads what was really drilled (collars, depths, angles, dates, rig, water) from a rig or survey file into the holes of the blast blocks. The design is not overwritten: the reported values go into the hole's "actual" fields.

Where to find it

Blast Design tab → Drilling group → Import Drilling Fact. Also on the Blast block tab.

Before you start

• A blast block that is not on a locked layer. Without one the button is off ("The project has no unlocked blast blocks.").
• Select the blocks to fill, or select none to take every unlocked block.
• A file: delimited text (.csv, .tsv, .txt) or an IREDES quality log (.xml). To try the command without a rig, make a file with Simulate Drilling Fact.

How to

1. Click Import Drilling Fact.
2. In the Import drilling fact dialog pick the file.
3. Read the report that appears. The import is one undo step (Ctrl+Z) and adds a "drilled" entry to each block's journal.

The file

Table. Needs a header row. The separator may be a comma, semicolon or tab; the decimal mark a point, or a comma when the separator is not a comma; cells may be quoted; columns come in any order and are named in English, Russian or Ukrainian (case, spaces, dots, dashes and a unit in brackets are ignored). A cell that cannot be read is reported and skipped; the rest of its row still counts. The file needs a hole number column or collar coordinates.

Two rules keep design values from being read as facts:

• The collar comes from the Actual… columns when the file has them, from plain X/Y/Z only when it has not. The same goes for the depth.
• Angles are read only from fact columns. A positive dip is read as downward.

A collar without an elevation is taken as "not levelled" and keeps the designed elevation. A depth of zero or less is left out.

The program's own hole table from Export Holes, filled in, is such a file.

IREDES. A quality log (DRPQual) from the rig. Each Hole gives the collar (StartPoint), the bottom (EndPoint) and the finish time; the depth and the angles are worked out from the two points. A name written Block/Hole goes to that block. A drill plan (DRPPlan) is refused: export the quality log instead.

How rows find their hole

1. By the hole number, inside the block the row names when the file has a block column and a block with that name exists.
2. If several holes carry that number, the one whose designed collar is nearest in plan to the row's collar. Without a collar the row is not taken.
3. If no hole has that number (mistyped or blank), by position: the designed collar nearest in plan to the row's collar, as long as it is within half the block's smaller grid step (the smaller of burden and spacing).

Rows that report nothing are ignored. If a hole appears twice (a re-drill), the later row wins. Values a row leaves blank keep what the hole already had. A planned hole that takes a fact becomes Drilled; a charged or fired hole keeps its status.

The report

The message lists: holes that took the fact (and how many rows were found by number and by position), repeated rows, holes still without drilling fact, the largest collar offset in metres and its hole, the range of drilled depth against design, rows that found no hole (first eight), and values that could not be read (first eight).

If something goes wrong

What next

Hole Measurement for the dip before charging · Import Charging

Simulate Drilling Fact

Writes a made-up drilling fact file for the selected blast block, as a rig would report it. Use it to try Import Drilling Fact without a rig. It changes nothing in the project.

Where to find it

Blast Design tab → Drilling group → More drop-down → Simulate Drilling Fact…. On the Blast block tab it is in the Drilling group.

How to

1. Select one blast block with holes.
2. Click Simulate Drilling Fact.
3. In the Simulate drilling fact dialog save the file (suggested name: the block name plus -drilling-fact).
4. Read it in with Import Drilling Fact.

What the file contains

A table in a rig's own words: HoleID;Easting;Northing;Elevation;Depth;Date;Rig;Operator;Water;Comment. It imitates a real bench:

• collars a hand's breadth off their design and depths a little off;
• two rigs working the block row about, about 25 holes a shift each, starting today;
• a few holes not drilled yet, a few stopped short, water in some;
• a hole number left blank here and there, which the import finds by position;
• one hole drilled twice.

The same block always gives the same file.

If something goes wrong

Import Survey or MWD

Loads the inclinometry of the holes (depth, azimuth, dip) or their measurement while drilling (MWD: interval, rate and energy of drilling) from a table file.

Where to find it

Blast Design tab → Drilling group → More drop-down → Import Survey or MWD…. On the Blast block tab it is in the Drilling group.

Before you start

Select the blocks to fill, or select none to take every block not on a locked layer.

How to

1. Click Import Survey or MWD.
2. In the Import survey or MWD dialog pick a .csv or .txt file.
3. Read the message. The load is one undo step.

The file

One row per reading. A header row names the columns, in English or Russian, in any order. A hole column is required; a block column is optional and narrows the search to that block.

Other accepted names: Hole is also HoleID; Rate is also PenetrationRate; Energy is also SpecificEnergy. If a file has the columns of both kinds, it is read as a survey.

Each hole's new readings replace what it had. Rows are sorted by depth (survey) or by From (MWD).

If something goes wrong

The message lists up to eight unused rows.

Import Charging

Reads what was loaded into each hole (explosive, mass, stemming, column length, date) from a charging file and marks those holes as charged.

Where to find it

Blast Design tab → Charging group → Charging data drop-down → Import Charging…. On the Blast block tab it is in the Charging group.

Before you start

• A blast block that is not on a locked layer ("There is no unlocked blast block to take the charging data." otherwise).
• Select the blocks, or select none to take every unlocked block.
• Explosives named in the file must exist in the project's explosive table.

How to

1. Click Import Charging.
2. In the Import charging data dialog pick the file (.csv, .tsv, .txt).
3. Read the report. The import is one undo step and adds a "charged" entry to each block's journal (with the date from the file, when it has one, and the total mass).

The file

A delimited file with a header row, one row per hole:

Hole;Explosive;Mass;Stemming;ChargeLength;Date

Russian names are understood too (Скважина, ВВ, Масса, Забойка, Длина заряда, Дата). Only the hole and either the explosive or the mass are needed.

What changes

• The hole is marked Charged with the mass loaded.
• With a stemming or a column length, the charge is laid out again: stemming at the top, then the explosive column.
• With only an explosive, the explosive decks the hole already has take it; a hole without decks is charged by the block's rule.
• A later row for the same hole wins.

If something goes wrong

The report lists holes marked charged, repeated rows, rows not taken and unreadable values (first eight of each).

What next

Hole Measurement · Delay Network

Simulate Measurement

Writes a made-up dip file for the selected blast block, as a charging crew would report it. Use it to try the Load of Hole Measurement without a crew. It changes nothing in the project.

Where to find it

Blast Design tab → Charging group → Charging data drop-down → Simulate Measurement…. On the Blast block tab it is in the Charging group.

How to

1. Select one blast block with holes.
2. Click Simulate Measurement.
3. In the Simulate measurement dialog save the file (suggested name: the block name plus -dip).
4. Load it in Hole Measurement.

What the file contains

Columns Скважина;Глубина;Вода;Мокрые стенки;Дата (hole, depth, water, wet walls, date; "да" marks wet walls), dated today, for every hole that is planned or drilled and not excluded. It imitates a dip: most holes a little shallower than drilled (cuttings fell back), a few caved in by a metre or more, the water found by drilling risen a little, water in a few more holes, wet walls here and there. The same block always gives the same file.

If something goes wrong

Export for the Detonator Logger

Writes the detonators of the selected blast blocks, with their holes, places and firing times, as a table for a detonator logger. You choose and order the columns, the separator and the decimal mark in a window and see the start of the file before saving.

Where to find it

Blast Design tab → Delay network group → Network drop-down → Export for the Logger…. On the Blast block tab it is in the Delay network group.

The window does not block the program. If it is open and you run the command with other blocks selected, the window takes them.

Before you start

• Select the blast blocks. With none selected: "Select the blast blocks to export first."
• The blocks need a delay network and detonators set in their holes (Delay Network, Charge Holes).

How to

1. Click Export for the Detonator Logger. The Export for the detonator logger window opens.
2. In 1 Columns, tick the columns to write. Select a column and use Up / Down to move it in the file.
3. In 2 File set the separator, the decimal mark, the order and the header.
4. Check 3 Preview (the first lines as written; the line above it counts detonators and tells what is left out).
5. Click Export…, choose a .csv or .txt file and save. The line at the bottom says "Exported N detonator(s) to 'file'."

The window follows the project: change the blocks and the preview updates. The layout you set is remembered.

Parameters

1 Columns (ticked ones are written, in the list order)

The header names in the file are fixed English, so the logger's import can be set up once.

Default columns: Hole no., X, Y, Z, Firing time, Detonator no.

2 File

The same settings are on the Detonator logger table page of the Blast design settings, where you can also tick the columns; their order is set only in this window. At least one column must stay ticked ("Tick the columns to write.").

What is written

One line per in-hole detonator, lines ending in CRLF, UTF-8 without a byte-order mark (a logger may not read one). Left out, and counted in the preview line: excluded holes, holes with no detonator ("Left out, no detonator: N hole(s)") and holes the delay network does not reach ("Left out, not reached by the delay network: N hole(s)").

If something goes wrong

What next

Delay Network

Field Form

Saves one HTML file with the holes of the selected blocks. Open it in the browser of a tablet or phone at the bench, fill in the drilling, the dip and the charging, and send the saved files back to the office.

Where to find it

Blast Design tab → Drilling group → More drop-down → Field Form…. On the Blast block tab it is in the Drilling group.

Before you start

Select the blast blocks (none selected: "Select the blast blocks to make the field form of first.").

How to

1. Click Field Form and save the .html file (suggested name field-<block names>.html).
2. Copy it to the tablet or phone and open it in the browser. It needs no network and no installation.
3. Use the three tabs at the top and fill the grid, one row per hole (excluded holes are not shown, rows are ordered by row and place):

1. Tap Save the file to download the page as a CSV (<page>-<date>.csv). Only rows with a depth (drilling, dip) or a mass (charging) are written. Clear the page erases what was typed on that page after a confirmation.
2. Load the files in the office: the drilling file with Import Drilling Fact, the dip file with the Load of Hole Measurement, the charging file with Import Charging.

What you type is kept in the browser until you clear the page, so closing the tab does not lose it.

If something goes wrong