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 25.1.0213.641
The following release notes apply to Toolbox build 25.1.0213.641. Stay Down Nesting Additions 3 new settings have been added to Stay Down Nesting, to resolve specific issues with routes and connectors that have been reported: Fig. 1: New options in ...Toolbox Release Notes: Year of 2024
This document will catalog all releases for Microvellum Toolbox software builds that were released in the year 2024. This encompasses builds 24.1.0104.641 to 24.1.1206.641. Toolbox Release Notes | Build 24.1.1206.641 The following release notes apply ...Toolbox Release Notes | Build 25.1.0129.641
The following release notes apply to Toolbox build 25.1.0129.641. SMA Fixes A wide variety of issues with the Solid Model Analyzer have been resolved. Multiple modifications to existing interfaces or settings have been made to improve precision and ...Microvellum Foundation Library Release Notes | Build 25.0124
The following release notes apply to Microvellum Foundation Library build 25.0124. Additions Added Century Components Waste Bins, Vanity Organizers, and Base Cabinet Organizers. 11”, 14”, 17” Signature Series Bottom Mount 34qt & 50qt. 4”, 5”, 6”, 9”, ...SQL Server Backups
This article will list out the various types of backups you can create for databases hosted on an SQL Server, explore methods for creating backups manually and automatically, as well as list software/services that may assist you with backing up your ...