Rename Drill Holes Command

D_RenumberDrillHoles_600ppi   Rename Drill Holes

Command Licensing and Default Menu Location

  • The Rename Drill Holes command is part of the RPS Tool Shed Toolbox
  • The command is located on the Tool Shed macros menu ribbon
  • The command is located in the Drilling menu group

The command requires the v5.31 update to Trimble Business Center to satisfy the complete changes required for this workflow. v5.31 of TBC incorporates the following additional changes

  • The Drill Hole Quality Report can now be executed with or without imported hole quality as built data, meaning that you can now report Design Hole data only.
  • The Create Drill Plan command has been updated to allow for a skew angle between the Drill Plan rows and columns.

Command Description

Provides the ability to rename / renumber drill holes in a drill plan, allowing for irregular shaped boundaries, the addition of extra drill holes and the movement of drill holes to allow for fault patterns through the drilling area. All holes are renamed uniquely and regularly along rows and columns of the drill plan. Drill hole names / numbers can be defined using a user defined name pattern.

Command Interface Description

The Rename Drill Holes command dialog looks as follows

Drill Plan
Select the Drill Plan that you wish to renumber. Note the Drill Plan type needs to be the Grid Type of Plan for this renaming command to work. Note that the origin and orientation of the drill plan is always honored in the renaming scheme, the renaming will start from the same origin points. If the project does not have any Grid Plan types, then the selection dialog will be empty.

The renaming process uses the half spacing of the rows and columns to determine which row an added hole belongs to. The added holes are added to the row and column based on their closest proximity within a half row or half column spacing.

Name Mask:
Define the hole naming system that you wish to use e.g. {R}:{C} for Row:Column or {R}-{C} for Row-Column

Start Column Number:
Enter the number for the first column of the plan

Reverse Columns Checkbox:
If you wish to reverse the numbering system, check this check box i.e. you can start at 8 and reverse the numbering so it numbers the columns 8,7,6,5,4,3,2,1 etc:

Start Row Number:
Enter the first Row Number for the plan

Reverse Rows Checkbox:
If you wish to reverse the numbering system, check this check box i.e. you can start at 8 and reverse the numbering so it numbers the rows 8,7,6,5,4,3,2,1 etc:

When you tap Test, you will see a preview of the results that will be applied on tapping OK. You can modify the settings as often as required using Test to see the results prior to committing the changes.

Executes the command and renames the Drill Holes for the Drill Plan and closes on completion

Closes the command without further execution.

Video Demonstration

The following video shows how to utilize the Rename Drill Holes command

Use Case Videos

The following videos show the use of the Rename Drill Holes command in a work process context

Feedback and Enhancement Requests

If you would like to provide feedback on the use of the Rename Drill Holes command or to request enhancements or improvements to the command please Click Here