Baserow Explanation

It may be helpful to have Baserow open to follow along. For getting to Baserow: Accessing Baserow (see Creating A Door).

1. Table Overview

Work_Order

This is where the jobs waiting to be cut live. Each row is one work order: the door to cut and how many. The machine looks work orders up by Name when one is typed or scanned on the Job Queue page. A work order is removed from this table once every door on it has been cut.

Model

Saved door models. A model has the same columns as a work order, so it can be used as a starting point when entering a new work order in the WO Entry app. The machine does not cut models directly.

History

One row for every door the machine has cut, written by the machine when the door's program finishes. Old doors can be found here and used again in the WO Entry app.

Slab

Describes door slabs using height and width.

Material

Feed rate and cutting data for each type of door material.

Location

Data on where to place the cutouts, latch and deadbolt on the door.

Cutout

Data used to describe a cutout (lite, vent, mail slot) to the gcode creating software.

Lock

Data used to describe a latch or deadbolt to the gcode creating software. The same lock can be used as a Latch or a Deadbolt.

Hole_Pattern

Repeated hole patterns found in locks to be used in Lock.

2. Door Coordinates

The door lies on the machine with its top edge at X0 and its lock edge at Y0.

X runs down the height of the door. A hole with a positive X is toward the top of the door.

Y runs across the width of the door. A hole with a positive Y is away from the lock edge, toward the hinge edge.

Every column name with an X or a Y in it uses these directions.

All sizes and distances are in inches.

3. Table Explanations

In-depth look into the different tables. Describing what each of their columns do.

3.1 Work_Order

Name

The work order number. This is what the operator types or scans on the Job Queue page, so it should be unique.

Slab

Which slab to use for the door. Lets you pick from created slabs in Slab.

Cutout1, Cutout2, Cutout3, Cutout4

Up to four cutouts for the door. Lets you pick from created cutouts in Cutout. All four are optional. They are cut in order, Cutout1 first, and each is placed by its own columns in Location.

Latch

Which lock to cut as the latch. Lets you pick from created locks in Lock. Optional.

Deadbolt

Which lock to cut as the deadbolt. Lets you pick from created locks in Lock. Optional.

Location

Which location to use for the door. Lets you pick from created locations in Location.

Material

Which material to use for the door. Lets you pick from created materials in Material.

Quantity

How many doors to cut for this work order. Blank, 0 or a negative number means 1.

3.2 Model

Same columns as Work_Order. Name is the model name and should be unique. When a model is picked in the WO Entry app it fills in the Slab, Cutouts, Latch, Deadbolt, Location, Material and Quantity, which can then be changed before the work order is sent.

3.3 History

The machine fills in these rows. They do not need to be edited.

Name

The work order the door was cut for, or Manual for a door entered by hand on the machine.

Date

When the door was finished.

Time

How long the door took to cut, from Cycle Start to the end of its program.

Slab, Location, Cutout1-Cutout4, Latch, Deadbolt, Material

What was cut on the door. If the operator changed the job on the machine, this is what was really cut.

3.4 Slab

Slab - The door blank that is loaded into the machine

Name

Unique identifier for a slab. Ex: 3068

Nominal_Width

"Pretty" representation of the slab's actual width

Nominal_Height

"Pretty" representation of the slab's actual height

Actual_Width

Actual width of slab. Cutouts are centred across the door using this, so it should be the measured width.

Actual_Height

Actual height of slab

3.5 Material

Material - What the door is made out of

Name

Unique identifier for a material.

Feed

Decimal representing a percent factor on the tool's feed rate when cutting cutouts. Ex: .75 = 75%

Plunge_Feed

Decimal representing a percent factor on the tool's feed rate when plunging into a cutout. Ex: .75 = 75%

Lock_Feed

Decimal representing a percent factor on the tool's feed rate when cutting a lock. Ex: .75 = 75%

Lock_Plunge_Feed

Decimal representing a percent factor on the tool's feed rate when plunging into a lock. Ex: .75 = 75%

Thickness

Thickness of the door. Cutouts and through holes are cut just past this depth.

Cut_Spindle_Speed

Decimal representing a percent factor on the tool's spindle speed. Ex: .75 = 75%

Recip_Amplitude

How far Z moves up and down while cutting a cutout, so the whole length of the bit is used. Blank or 0 means no reciprocation. Only used on a machine with a reciprocating axis set up.

Cutout_Stepdown

The deepest each pass of a cutout or through bore may go. The full depth is split into equal passes no deeper than this. Set it to the door thickness to cut in one pass.

Cut_Size_Comp

Opens every generated cutout and bore up by this much on each side. 0 cuts them exactly to size. Drilled holes are not changed.

3.6 Location

Name

Unique identifier for a location.

Top_of_Door_to_Cutout1 - Top_of_Door_to_Cutout4

Distance from the top of the door to the top of that cutout. For a diamond this is to the top point of the diamond. Only needed for the cutouts the door uses.

Cutout1_Y_Offset - Cutout4_Y_Offset

Moves that cutout across the door away from the centre of the door. Blank or 0 centres the cutout across the door.

Top_ofDoor_to_Lock

Distance from the top of the door to the centre line of the latch.

Top_of_Door_to_Deadbolt

Distance from the top of the door to the centre line of the deadbolt.

Lock_Y_Offset

Moves the latch and deadbolt across the door, added to the lock's Lock_Center. Blank or 0 leaves them at Lock_Center.

3.7 Cutout

Name

Unique identifier for a cutout. Ex: 22x36

Width

Width of the cutout, across the door (Y).

Height

Height of the cutout, down the door (X).

Corner_Radius

If [Corner_Radius] is 0 then the corners are as sharp as the bit allows (the bit's radius). Otherwise, creates rounded corners with a radius of [Corner_Radius].

Diamond

When ticked the cutout is turned 45° to make a diamond.

Punch

When ticked the cutout is punched out after it is cut, so the slug does not fall into the machine. A cutout narrower or shorter than the punch diameter (Core Config, Plyco Cutout Punch) is never punched.

Mill_Out

When ticked the whole inside of the cutout is milled away instead of only cutting its outline, so no slug is left. Used for small cutouts like the mail slot. A milled out cutout is never punched.

Gcode

If a gcode file is inserted here, that gcode will be used to cut the cutout instead of using the cutout data found in Cutout. It is drawn with the centre of the cutout at X0 Y0.

Subroutine

If [Subroutine] is any value other than -1, [Subroutine] will be called as a subroutine in gcode to cut the cutout instead of using data found in Cutout. It is called with the centre of the cutout at X0 Y0.

3.8 Lock

Notes:

X and Y origin is the center of the lock: Lock_Center across the door, and the Location's lock or deadbolt line down the door.

X is up the door (+ toward the top). Y is across the door (+ away from the lock edge).

# refers to any given hole number. EX: Hole_#X (Hole_1X, Hole_2X, Hole_3X)

Name

Unique identifier for a lock model.

GCode

If a gcode file is inserted here, that gcode will be used to cut the lock instead of using the lock data found in Lock table. It is drawn with the centre of the lock at X0 Y0.

Lock_Center

Distance from the lock edge of the door to the center of the lock (the backset). Ex: 2.75

Face

An options select for which side of the door the lock will be cut on. This should always be "Front".

Clearance

Kept for reference. The generated program does not use it.

Subroutine

If [Subroutine] is any value other than -1, [Subroutine] will be called as a subroutine in gcode to cut the lock instead of using data found in Lock. It is called with the centre of the lock at X0 Y0.

Drawing

An image or PDF file can be saved here for an easy visual reference for a lock.

Patterns

Lock hole patterns from Hole_Pattern can be selected. Their holes are cut along with the lock's own holes.

Hole_#X

X location of hole # from the centre of the lock, up the door.

Hole_#Y

Y location of hole # from the centre of the lock, across the door. A negative Y is toward the lock edge.

Hole_#Dia

If [Hole_#Dia] isn't empty, hole # will be cut with a diameter of [Hole_#Dia]. A drill of the same size from the tool table drills it. If a mill's bore range covers the size, the mill bores it instead.

Hole_#Depth

Distance hole is cut into door. A depth of at least the door Thickness goes through the door. A drilled hole goes to this depth, or just past the door if this is less. A bored hole goes just past the door.

Bore_Step_Down

Distance a bore that stops in the door will descend during each full revolution. A bore through the door uses the Material's Cutout_Stepdown instead.

Drill_Type

Option selector for which type of drill command to use.

73 - High Speed Peck

81 - Straight Drilling

83 - Peck Drilling

Drill_Retract

Height above the door the drill retracts to between holes. 0 would be flush with the door.

Drill_Peck

Distance drill will "Peck" into material if using peck drilling (73 or 83).

Notes

Any notes about a lock can be written here.

Example: LatchGuard95/99 has Lock_Center 2.75. Hole 1 is the 2.125 latch bore at X0 Y0. Holes 2 and 3 are the 0.438 bolt holes at X 4.8125 and X -4.8125, both at Y -1.75, which puts them 1.000 from the lock edge.

3.9 Hole_Pattern

Notes:

X and Y origin is the center of the lock the pattern is linked to.

X is up the door (+ toward the top). Y is across the door (+ away from the lock edge).

# refers to any given hole number. EX: Hole_#X (Hole_1X - Hole_5X)

Name

Unique identifier for a hole pattern.

Hole_#X

X location of a hole inside of a pattern.

Hole_#Y

Y location of a hole inside of a pattern.

Hole_#Dia

Diameter of a hole inside of a pattern.

Hole_#Depth

Distance the hole is cut into the door, the same as Hole_#Depth in Lock.