Formulas extracting information from the cost model

Formula patterns

FOR FORMULA FOR

USE

YOU WILL SEE

AREA INFORMATION WITH HOLES AREA EXCLUDED

CONCRETE PARAMETER IN 1UP

$OneUpN.Cost.Parameter; format$

Extracts the value of a specified parameter in the loaded cost model in the 1up drawing.

CONCRETE PARAMETER IN LAYOUT

$LayoutN.Cost.Parameter; format$

Extracts the value of a specified parameter in the loaded cost model in the layout drawing.

SELECTION PARAMETERS

TO EXTRACT A FOR

USE

YOU WILL SEE

SELECTION PARAMETER IN 1UP

$#OneUpN.Cost.Parameter$

ON TWO CELLS: The name of a selected selection type entry, not its assigned value. For example, if the selection parameter ShapeComplexity has entries Simple, Medium and Complex, to each of which a numerical value is assigned, the formula returns the name of the selected entry, not the value assigned to it.

SELECTION PARAMETER IN LAYOUT

$#LayoutN.Cost.Parameter$

The name of a selected se it.

SELECTION PARAMETER DESCRIPTION IN 1UP

$OneUpN.Cost.Parameter.ValDescr$

ON TWO CELLS: The formula extracts the description text set for a selected selection type entry. For example, the selection parameter ShapeComplexity has entries Simple, Medium and Complex. If any descriptions are added to these entries, the texts of the descriptions will be displayed in the print drawing.

SELECTION PARAMETER DESCRIPTION IN LAYOUT

$LayoutN.Cost.Parameter.ValDescr$

The forrawing.

NOTES:

OneUpN and LayoutN designate the numbered predefined design frame areas the formula refers to.
If you do not specify a style name (StyleName), EngView calculates the combined length of all objects in the Cutting style.
The names of parameters are case-sensitive. This means that in formulas you must type them in the case in which they were created. For example, if a parameter was created as TOTALCOST, in formulas it must be referred to as TOTALCOST, not as totalcost, Totalcost or otherwise.
In the AreaEx formula, Yes means that the holes area will be excluded from the total area; No, that the holes area will be included in the total area.

Examples

GENERAL

TO CALCULATE THE AREA OF

USE THIS FORMULA

YOU WILL SEE

TOTAL COST OF LAYOUT DRAWING

$Layout1.Cost.TotalCost$

The value of the parameter 'TotalCost' from the currently loaded cost model in the Layout1 drawing.

EURO-DENOMINATED TOTAL COST OF LAYOUT DRAWING

$Layout1.Cost.TotalCost$ EUR

The value, in euros, of the parameter 'TotalCost' from the currently loaded cost model in the Layout1 drawing.

U.S. DOLLAR-DENOMINATED TOTAL COST OF LAYOUT DRAWING

$$$Layout1.Cost.TotalCost$

The value, in euros, of the parameter 'TotalCost' from the currently loaded cost model in the Layout1 drawing.

1UP DRAWING TOTAL COST

$OneUp1.Cost.TotalCost; n2$

The value of the parameter 'TotalCost' from the currently loaded cost model in the OneUp1 drawing in precision 2.

PARAMETER IN LAYOUT DRAWING IN SPECIFIED PRECISION

$Layout1.Cost.TotalRules; n3$

The value of the parameter 'TotaRules' from the currently loaded cost model in the Layout1 drawing in precision 3.

PARAMETER IN LAYOUT DRAWING IN SPECIFIED PRECISION & TEXT

$Layout1.Cost.TotalRules; 3$ m

The value of the parameter 'TotaRules' from the currently loaded cost model in the Layout1 drawing in precision 3 and with an added explanatory text (in this case, the letter 'm').

TOTAL RULES COST IN 1UP

$OneUp1.Cost.TotalRules; f2$

The value of the parameter 'TotaRules' from the currently loaded cost model in the OneUp1 drawing in precision f2.

NOTE: If you want to display the character '$' in front of a text, insert it two more times in front of the formula. For example, if the formula for extracting the total cost is $OneUp1.Cost.TotalCost$, write $$$OneUp1.Cost.TotalCost$. The program will return a number preceded by the $ sign — for example, $21.32. (In the table above, see the example in the third row.)

Selection Parameters

TO EXTRACT

USE THIS FORMULA

YOU WILL SEE

SELECTED SELECTION ENTRY NAME (1UP)

$#OneUp1.Cost.ShapeComplexity$

OT TWO CELLS: The name of the selected selection type entry for the parameter ShapeComplexity in the drawing OneUp1. For example, if the parameter has the entries Simple, Medium and Complex, to each of which a numerical value is assigned, the formula returns the names of the entry selected in the cost model, not the value assigned to it.

SELECTED SELECTION ENTRY NAME (LAYOUT)

$#Layout1.Cost.ShapeComplexity$

OT TWO CELLS: The name of the selected selection type entry for the parameter ShapeComplexity in the drawing OneUp1. For example, if the parameter has the entries Simple, Medium and Complex, to each of which a numerical value is assigned, the formula returns the names of the entry selected in the cost model, not the value assigned to it.

SELECTION ENTRY NAME DESCRIPTION (1UP)

$OneUp1.Cost.ShapeComplexity.ValDescr$

OT TWO CELLS: The text that describes the selected selection type entry for the parameter ShapeComplexity in the drawing OneUp1. For example, if the parameter has the entries Simple, Medium and Complex, to each of which a description is set, the formula returns the description text. By analogy, the formula is used for the WorkQualification parameter in the drawing Layout1.

SELECTION ENTRY NAME DESCRIPTION (LAYOUT)

$Layout1.Cost.ShapeComplexity.ValDescr$

OT TWO CELLS: The text that describes the selected selection type entry for the parameter ShapeComplexity in the drawing OneUp1. For example, if the parameter has the entries Simple, Medium and Complex, to each of which a description is set, the formula returns the description text. By analogy, the formula is used for the WorkQualification parameter in the drawing Layout1.

Notes on Formula Syntax: Space-Separated Style Names; Case Sensitivity; List Separators

USE QUOTATION MARKS TO ENCLOSE SPACE-SEPARATED STYLE NAMES

In a formula, to refer to a style whose name is made up of multiple words separated by spaces, enclose the style name in quotation marks, like this (in red):

$OneUp1.Length("Rillen 3pt", m)$

$OneUp1.Length("Rillen mit Rillkörper", m)$

TYPE MEASUREMENT UNITS AND FORMATTING SYMBOLS IN LOWER CASE

When a formula contains measurement units and/or formatting symbols, type them in lower case, like this (in red):

$LayOUT1.SHEETWidth(mm); n2$

$Layout1.lenght(m)$

KNOW YOUR LIST SEPARATOR

This guide uses semicolon — (;) — to separate formula attributes. If your own system uses a list separator that is different from semicolon — for example, comma (,) — copying a formula from the help guide and then pasting it into Prinect will return an error and the formula will not calculate.

So when typing a formula, ensure that the list separator used in the formula is identical with the one set for your system. This means that you may need to edit either (1) your system's list separator setting or (2) the formula you are typing. The examples that follow illustrate how to edit formulas that use semicolons into ones that use colons (in red):

AS PRESENTED IN THE HELP GUIDE. LIST SEPARATOR IS SEMICOLON (;)

$Layout1.Area(m; Plotting); n2$

$Layout1.AreaEx(yes; mm); n2$

$Layout1.SheetHeight(mm); n2$

$Fold3D1.BoundingBoxWidth(Production; mm; yes)$

TYPE FORMULAS LIKE THIS IF YOUR LIST SEPARATOR IS COMMA (,)

$Layout1.Area(m, Plotting), n2$

$Layout1.AreaEx(yes, mm), n2$

$Layout1.SheetHeight(mm), n2$

$Fold3D1.BoundingBoxWidth(Production, mm, yes)$