Skip to main content

Importing a blast plan

Bring the blast's design in from a CSV, Excel or DXF file: choose the file, check its columns, match each recorded hole to its planned one, and import. Nothing is saved until you do.

A blast plan is the design for the whole blast: each hole's position, geometry, charge and timing. It belongs to the blast, so every recording on the blast reads the same design. Importing it copies each planned hole's figures, its planned VoD and its delay among them, onto the recorded hole matched to it. Press Shift+I to import one.

0:18
Importing a blast plan, narrated: choose the file, check the columns, match the recorded holes to the planned ones, and review the import. The walk stops before Import, so nothing is saved.

Opening the import

  • Press Shift+I anywhere on the page. The shortcuts sheet and the command palette call it Import a blast plan.
  • With the Timeline showing (Shift+O), click Import blast plan on the Timing track. It is there while the blast has no plan.

The same walk imports a plan from the blast's own page.

The walk

The dialog moves through up to four screens, and the chips along its top say what has been decided. Cancel at any point leaves everything as it was: nothing is saved until you press Import plan.

  1. Which file is the plan? Drop the file or click Choose file: CSV, Excel (the first sheet) or DXF (points and circles), up to 10 MB and 5,000 holes. The file wants a header row and one hole per row, with units in the header, as in Download a sample CSV. A file that cannot be read is refused whole, and the rows at fault are listed.
  2. Which column is which? Each of the plan's fields, grouped from Identity to Context, is matched to one of your columns. Choose Use column…, Constant… for a value that is the same for every hole, or Not in file. A column the analyser does not recognise stays in the file and is not imported. A match made on a similar name says so. Check it.
  3. Which planned hole is each recorded one? Each hole the recording found, beside the planned hole its figures will come from. Match by name pairs them by Hole ID, Match in order pairs them in the order they come, and Clear all starts again. A recorded hole left unmatched keeps its own values.
  4. Check and import. The plan (its holes, its charge per delay, its timing and its grid, with a preview of the first holes), the blast it goes to, and the file it came from. When the holes are angled, How the file writes inclination shows each hole's collar and toe read that way, so a flipped sign shows before it is saved.
The first screen of the import: which file is the plan

The analyser skips Which column is which? when it recognised every header with confidence, or when the mapping you used last time on this project fits the file. Click the columns chip to open it anyway. Which planned hole is each recorded one? appears only when the recording has holes of its own.

Matching each recorded hole to its planned one
The review before Import: the plan, the blast and the source

Importing copies the planned values onto each matched recorded hole. Its start sample, cable lengths and notes stay as recorded. If the recording is not yet on a blast, the import creates one from it.

Replacing a plan

A blast has one plan. Importing into a blast that already has one replaces it: the dialog reads Replace blast plan, the last screen says which plan goes and when it was imported, and the button reads Replace plan. The old plan's holes go with it, and recorded holes matched to them lose the link until the new plan is matched.

In the analyser, Shift+I is the way in once a plan exists, since the Timing track's button only shows before there is one.

Saved mappings

  • As last time on this project is applied by itself when the new file has every column it names.
  • Presets are kept for your team. Open the columns chip, choose Save as preset… and name it. Anyone on the team account can pick it for the next file, and Delete preset removes it.

Things to know

  • A recording already on another blast has to be detached from it before its plan can be imported here.
  • A hole's planned VoD is what vs plan and the dashed Plan line on Continuous VoD read. It comes from the plan, or from the hole's own Planned VoD field.
  • When the holes read as an underground ring, the last screen offers Set the blast type to Underground on import.

Search the documentation

Find a page, a shortcut, or a metric