Formula

Tool(s): Define Cell + Modify Legends, Info

If a cell is to draw its information from a source other than an architectural element - for example, if it is to calculate a value based on other column entries - you can define a formula for it by using the Formula option.

To define a formula

1. Click Define Cell (How).
   

   Activate Define Cell in one of the following ways

   • Menu bar: Create Bonus Tools Templates: Reports, Legends, Labels

   • Palette: Tools Create area in the following module(s):

   Templates: Reports, Legends, Labels

2. On the Define Cell Context toolbar, click Formula.
3. Enter the formula.
4. Click OK to apply the settings.

   The cell is displayed attached to the crosshairs.

5. Define the cell's text parameters.
6. Specify the format.
7. Specify the unit.
8. Specify a border if you want.
9. Place the cell anywhere in your drawing file. You can use the tools in the input options to place it.
   

   The following additional tools are available in the Input options to assist you when placing labels:

   Horiz

   Places the label so that it is horizontal.

   Vertic

   Places the label so that it is vertical.

   Angle

   Places the label at an angle you specify. Before placing the label, enter the angle in the dialog line or click a point of rotation and direction in the workspace.

   Auto

   Places the label so that it automatically reflects the geometry of the selected component (important for window labels with label styles).

   Resize

   Changes the size of the label.
   Enter a factor in the dialog line.

   Skip

   Skips the current component (i.e., it is not labeled).

Examples of formulas

Syntax of Allplan's formula interpreter (Bachus Naur Form)

Note: Formulas with the TOTAL index must later be assigned to the subtotal or total region.

Note: To see how object numbers are assigned, look in the $STD\object.000 file.

For more information, click a button in the dialog box:

• Functions for a list of available functions.
• Conditions to see which conditions are available.
• General for a brief introduction to the options provided in this dialog box.