EQ Functions
It is sometimes convenient to design a product that contains parts with a varying quantity. An adjustable shelf is a good example of this. The problem is that no two shelves can occupy the same place in space. There are two potential solutions for this problem:
- You could add the maximum number of shelves you would ever need and use formulas in the quantity column to determine how many have a quantity of “one” based on the quantity of shelves the user specified.
- You could use a special function in the Z origin of the part that is capable of placing multiple parts in different places in space. Thus, even though only one part is specified, when the product is drawn or cut listed, the number of parts actually produced will be reflected by the parameters of the function. The syntax for these four special functions is described below.
The EQ1 Function
EQ1 is utilized when we want to either space adjustable shelves, or fixed shelves positioned vertically in a cabinet. This function consists of arguments that specify the start and stopping point of the available space.
The EQ1 function will read the quantity and thickness of the part to determine the spacing.
The syntax can be expressed as follows:
The EQ2 Function
EQ2 is utilized when you want to use multiple quantities for a part and locate two of the parts at specified locations, calculating the remainder of the space available for additional parts. Nailers in a storage cabinet would be a good example. You may want to have a top and bottom nailer and a varying number of intermediate nailers, depending on the height of the cabinet. The EQ2 function consists of arguments that specify the start and stopping point of the space that is available.
Note: When using the EQ2 statement, it is important to remember the base point of the parts you are spacing. In this instance, the base point for located at the bottom of the part.
The syntax can be expressed as follows:
The starting point is the bottom of the product, plus the toe kick height, plus the thickness of the bottom. The stopping point is the height of the product, minus the width of the part you are using. If you only have a quantity of two parts, they will be spaced at the starting and stopping points. If the quantity is greater than two, the space available between the first two will be calculated, and the remainder of the parts will be equally spaced in that area.
The EQH Function
EQH is utilized when you want to space horizontal parts, such as adjustable shelves or fixed shelves between vertical partition(s). The EQH function consists of arguments that either specifies the quantity of the divisions or partitions the thickness of the cabinet sides to deduct from the width of the unit and the thick-ness of the partition.
Note: The EQH statement uses the width of the product along with the arguments described above to determine where to place the shelves in the X origin.
The syntax can be expressed as follows:
The EQV Function
The EQV function is utilized when you want to space vertical parts, such as partitions or sleepers, equally inside a cabinet. The EQV function consists of arguments that specify both the quantity of vertical partitions and the thickness of the cabinet sides.
The syntax can be expressed as follows:
There are three optional arguments you can also use. Just like the other arguments, use commas to separate them. The first optional argument will specify the thickness of the part. If this argument is omitted, the thickness of the part will be determined using the material name. This provision is useful for positioning intermediate stiles within a face frame. In this case, you would need to consider the part’s width instead of its thickness. The second and third optional arguments specify the starting and stopping points. If these arguments are omitted, the product’s origin will be the starting point and the product’s origin, plus the product’s width, will be considered to be the stopping point.
Related Articles
Understanding the OFFSETPOLYLINE Spreadsheet Function
The OFFSETPOLYLINE Spreadsheet Function allows for vector points to be entered, from a polyline token, for example, and the function then returns the vector coordinates offset by the desired amount. The OFFSETPOLYLINE function is formatted as such: ...Using Formula Editor
The Formula Editor is a handy tool for reading and writing formulas. To access the Formula Editor, select a cell and press the F2 key. Large Text – Checking the box will make all the text larger. Find and Replace – Launches the find and replace. Name ...Overview & Tutorials: Formula Generated Materials in Doors
This video explains and demonstrates how to use formula generated materials in the default 048 library data. Prior to this library version, this had not been included in the shipping library data although some Users have been doing this in their ...Overview: Formula Driven Materials
There are two distinct types of Microvellum materials – formula materials and non-formula (traditional) materials. This article focuses on formula-driven materials. Accessing Formula-Driven Materials You may use either the Add Formula Material ...Configuration Editor: AutoCAD Options
This article provides an overview of the options and settings available on the AutoCAD tab of the Configuration Editor (Options) Interface. For a complete list of available tabs and options visit Overview: Configuration Editor (Options) Interface. ...
Recent Articles
Toolbox Release Notes | Build 24.1.1105.641
The following release notes apply to Toolbox build 24.1.1105.641 Nesting Fix Fig. 1: The fatal error that would occur during processing. There was reportedly an issue that occurred when clients attempted to process a work order using the nesting ...Microvellum Foundation Library Release Notes | Build 24.1025
The following release notes apply to Microvellum Foundation Library build 24.1025. Additions Added new global variable “Remove Stop Dado On Bottom Edge” for wood drawer boxes. Check this option to run the dado through at the bottom of the sub front ...Toolbox Release Notes | Build 24.1.1030.641
The following release notes apply to Toolbox build 24.1.1030.641 Routing and Profile Fixes Several issues were found with routing and polyline paths: Fig. 1: Horizontal routes off of a part disappearing (left) and appearing correctly (right). When ...Toolbox Release Notes | Build 24.1.1010.641
The following release notes apply to Toolbox build 24.1.1010.641 Biesse Winstore Fix Several issues with the Biesse Winstore plugin have been resolved: There was an issue that would sometimes occur wherein materials that were intended to stack wound ...Toolbox Release Notes | Build 24.1.1001.641
The following release notes apply to Toolbox build 24.1.1001.641 HBore Toolfile Fix Fig. 1: The location in the Toolfile UI where the error would occur. There was an issue reported with the functionality of the Horizontal Boring Machine setting in ...