Drill Table
Plugin for AutoCAD and BricsCAD AVC_DrillTable.
List of cylindrical holes in solids. Drilling coordinates and direction.
Output to a table or Excel.
The program will help you compile a list of holes suitable for drilling, as is done in some furniture programs. The program finds all cylindrical holes in 3D solids, determines their diameter, depth, direction and coordinates from the solid corner. And makes a table according to your settings.
Features of the program:
The program distinguishes between vertical through and blind holes, end holes from 4 sides and from an arbitrary turn, inclined holes.
The program recognizes tapered hole ends and countersinks and writes the full depth into the table. Countersinking parameters can also be displayed in a table.
The program selects only those holes for which there is a suitable drill diameter. The rest of the holes are considered to be milled and ignored. The list of diameters is customizable.
The program is focused on rectangular furniture pieces, but will work on pieces of any complex shape.
Before drawing up the table, all parts must be laid out in the XY plane using the LAY command. However, you can freely rotate the parts around the Z axis if you find it more convenient to specify the coordinates of the holes from a different corner.
You can customize the grouping and sorting of the table, add and remove columns.
You can also display any data about the part, its block and drawing in the table. By default, the table is grouped by part name.
The part itself can be inside a block or even in an external reference.
You can create one table for several parts. For example, when several details are designed on one sheet. In this case, remember to use part name substitution in the grouping field.
The finished table can be inserted into a sheet or into a model. Or saved in Excel or CSV files.
You can simply select the detail viewport and an empty table with a frame and call the DrillTable command. The program itself will find the part and fill in the table without any questions.
There are three preset Drill Table styles. You can change them and create up to 9 styles. Styles can be quickly switched from the command line.
The program works only with solid bodies (3D Solid), does not work with surfaces, meshes and planar contours.
According to your request I can optimize the command for you. Offer your price.
Read about downloading and installing the program here.
To run the plugin, you will have to register account and top up your account balance by making a donation or receiving bonuses.
Then you can activate one of the licenses:
Annual license - 15 EUR.
Unlimited license - 75 EUR. Free updates for 1 year.
The trial period is 20 days.
How to use the program
It is required to pre-configure the list of hole diameters and the list of columns.
Draw a 3D Solid model of your product. Add an additive for fasteners and fittings (you can use the Fixture and Drill commands).
Lay out all parts in the XY plane using the LAY command. If you do not like the location or the spread of the part after laying out, you can rotate them as you like. But it is important to keep the position of the parts lying on the XY plane.
Please note that the coordinates of the holes are set from the lower left corner of the overall box of the part. Even if the part is cut or rounded in this corner, the X coordinate will still be calculated from the leftmost point of the part, and the Y coordinate from the lowest point.
Do not call the NC Prepare command immediately. It will flatten the parts and the Drill Table command will not work. Fill in the table first, and then draw out the outlines and annotations.
Select the part and call the DrillTable command. You can select several parts at once - in any case, a single table will be created. You can select a viewport or multiple viewports, in which the laid out details are visible. You can add an empty table to the selection that you want to fill - then the program will not ask you to select a table.
If nothing has been selected in advance, the program will prompt you to select a part. There are two options in the request:
SwitchStyle: Quickly switch between presets by number.
TUNE: Opens the table settings dialog. But in this dialog there are no settings for the CNC style, hole diameters.
Next, the program will extract hole data from all selected parts and create a table. If you select several identical parts, you will get several identical lines for each hole - the program does not combine identical parts.
You can split a table into multiple sheets with the TableSplit command.
Program setting
To customize the program, call the Options Palette (AvcOptions).
The Drill Table settings are located on two tabs.
CNC Prepare
On the NC Prepare tab, you can set the drilling parameters. These settings are switched with the NC style and affect the operation of all contouring commands: NC Prepare, DXF Export, Outside Loop, and so on. You cannot change them directly from the Drill Table command - you must use the Options Palette. In the Drilling group you can find the following settings:
List of drill hole diameters. All other holes are ignored by the Drilling Table - it considers it to be milling.
Drill thin holes - this option allows to include in the Drilling Table all thin holes with a diameter less than the cutter diameter (specified in the Milling group).
Direction names - The names of the drilling directions are used in the %drill% substitution. The list should contain 9 names separated by semicolons:
1 - vertical through drilling;
2 - blind vertical drilling from the facade;
3 - blind vertical drilling from the rear;
4 - lateral drilling on the left (along X);
5 - lateral drilling from above (in -Y);
6 - lateral drilling on the right (along -X);
7 - lateral drilling from below (along Y);
8 - lateral drilling not along the axes;
9 - oblique drilling at arbitrary angles;
Note that the multiply dimension setting used in Biesse layers does not apply to the Drill Table. The diameter and depth of the holes in the table remain the same as measured.
Drill Table
The Drilling Table tab contains:
Style Name - Up to 9 Styles can be configured. You can write the name of the style in the header of the table.
Group - settings for grouping table rows. I recommend that you write down the name substitution and other data about the solid here.
Columns - Column names, property substitutions and table sorting settings, list of table columns. Note that in the form for entering substitutions, a new section, Drilling Table, appears - there is only one substitution in it - the table row number %row%.
Object selection filter - to exclude unnecessary objects from the selected parts. It will help when working with viewports and parts in blocks.
Convert numbers to string - formatting of dimensions and coordinates (if not specified in the substitution)
Inserting data - select the recipient of the table: to a Table in a drawing, to Excel, to a CSV file, and so on.
All settings are similar to the Data Table.