## Worksheet Functions

Worksheet functions take an argument, perform an action, and return a value or values. There are two basic types of functions: those that use the values you enter, and those that use information from objects in the drawing. The arguments required by the two function types are different.

Number or text arguments: Functions that begin with a lower case letter typically require a number value or a cell address as the argument. For example, the acos function returns the arccosine of the value that is specified in the function argument. The argument you enter can be a mathematical expression (such as 3/5), an address of a cell that contains a number (such as A12), or an actual number. The argument for all trigonometry functions must be in radians.

Criteria arguments: Functions that begin with a capital letter must be applied to one or more specific objects in the drawing. In a cell in a database header row, a function is automatically applied to the object listed in each sub-row, so no criteria argument is required.

However, in a spreadsheet cell, you must enter criteria to select the objects the function applies to. For example, the Area function returns the combined area of all 2D objects that meet the criteria. To specify which objects to obtain the area of, either use the Insert > Criteria command on the Worksheet menu, or enter the criteria manually. For details about how to specify criteria such as the object type, class, or visibility, see the developer-oriented documentation here (Internet access required):

The following table lists all of the worksheet functions available, as well as what kind of argument the function takes.

You may want to display an attribute associated with a drawing object in the worksheet (such as the object’s class, or which layer it is on); see Retrieving Object Attributes in a Worksheet.

##### Example

acos(number)

The arccosine of a number. The arccosine is the angle whose cosine is number. The returned angle is given in radians in the range 0 to pi.

Number is the cosine of the angle, and must be from -1 to 1.

=acos(3/5)

(returns the angle for which the cosine value is 3/5)

Related functions: cos

Angle(criteria)

The angle (measured from horizontal) of the objects that meet the specified criteria, in degrees.

Use this function to return the angles of lines and walls (measured from horizontal), the span angles of arcs, and the slope angles of slabs.

=Angle

(returns the angle of each object in the database)

=Angle((t=arc)&(n='arc-1'))

(returns the sweep angle of the arc object named “arc-1” in the drawing)

Area(criteria)

The total area of 2D objects that meet the specified criteria, based on the Area units in the Units dialog box

=Area

(returns the area of each object in the database)

=Area(t=rect)

(returns the combined area of all rectangle objects in the drawing)

Related functions: Perim

asin(number)

The arcsine of a number. The arcsine is the angle whose sine is number. The returned angle is given in radians in the range -pi/2 to pi/2. To express the arcsine in degrees, use the rad2deg function (or multiply the result by 180/pi).

Number is the sine of the angle and must be from -1 to 1.

=asin(A3)

(returns the angle for which the sine value is given in cell A3)

Related functions: sin

atan(number)

The arctangent of a number. The arctangent is the angle whose tangent is number. The returned angle is given in radians in the range -pi/2 to pi/2. To express the arctangent in degrees, use the rad2deg function (or multiply the result by 180/pi).

Number is the tangent of the angle in question.

=atan(4/3)

(returns the angle for which the tangent value is 4/3)

Related functions: tan

average(number1, number2...)

The average (mean) of the arguments

=average(85,70,95)

(returns the average of the three numbers)

Related functions: max, min, sum

BotBound(criteria)

The bottom 2D boundary (minimum y coordinate) of the objects that meet the specified criteria

=BotBound

(returns the bottom 2D boundary of each object in the database)

=BotBound(t=locus)

(returns the bottom 2D boundary of the locus that has the lowest bottom 2D boundary value in the drawing)

Related functions: LeftBound, RightBound, TopBound

CompAreaByClass
(criteria, class)

The area (minus any holes) of one side of the components that meet the specified criteria and are in the specified class

=CompAreaByClass('Class-1')

(returns the area of the components assigned to the class “Class-1” for each wall, round wall, roof, roof face, and slab object in the database)

=CompAreaByClass(t=wall,'Class-1')

(returns the combined area of the components assigned to the class “Class-1” for all walls in the drawing)

Related functions: CompAreaByName, ComponentArea

CompAreaByName
(criteria, name)

The area (minus any holes) of one side of the components that meet the specified criteria and have the specified name

=CompAreaByName('Brick Veneer')

(returns the area of the components with the name “Brick Veneer” for each wall, round wall, roof, roof face, and slab object in the database)

=CompAreaByName(t=wall,'Brick Veneer')

(returns the combined area of the components with the name “Brick Veneer” for all walls in the drawing)

Related functions: CompAreaByClass, ComponentArea

CompClassByName
(criteria, name)

The name of the components that meet the specified criteria and have the specified name

=CompClassByName('Brick Veneer')

(returns the class of the components with the name “Brick Veneer” for each wall, round wall, roof, roof face, and slab object in the database)

=CompClassByName(t=wall,'Brick Veneer')

(returns the class of the first component with the name “Brick Veneer” for all walls in the drawing)

Related functions: CompNameByClass

CompLambdaByClass
(criteria, class)

The Lambda value of the components that meet the specified criteria and are in the specified class

=CompLambdaByClass('Class-1')

(returns the Lambda value of the components assigned to the class “Class-1” for each wall, round wall, roof, roof face, and slab object in the database)

=CompLambdaByClass(t=wall,'Class-1')

(returns the Lambda value of the first component assigned to the class “Class-1” for all walls in the drawing)

Related functions: CompLambdaByName, ComponentLambda

CompLambdaByName
(criteria, name)

The Lambda value of the components that meet the specified criteria and have the specified name

=CompLambdaByName('Brick Veneer')

(returns the Lambda value of the components with the name “Brick Veneer” for each wall, round wall, roof, roof face, and slab object in the database)

=CompLambdaByName(t=wall,'Brick Veneer')

(returns the Lambda value of the first component with the name “Brick Veneer” for all walls in the drawing)

Related functions: CompLambdaByClass, ComponentLambda

CompNameByClass
(criteria, class)

The name of the components that meet the specified criteria and are in the specified class

=CompNameByClass('Class-1')

(returns the name of the components assigned to the class “Class-1” for each wall, round wall, roof, roof face, and slab object in the database)

=CompNameByClass(t=wall,'Class-1')

(returns the name of the first component assigned to the class “Class-1” for all walls in the drawing)

Related functions: CompClassByName

ComponentArea
(criteria, index)

The area (minus any holes) of one side of the components that meet the specified criteria and have the specified index.

Index is the 1-based index identifying the component.

=ComponentArea(2)

(returns the area of the second component for each wall, round wall, roof, roof face, and slab object in the database)

=ComponentArea(t=wall,1)

(returns the combined area of the first components for all walls in the drawing)

Related functions: CompAreaByClass, CompAreaByName

ComponentLambda
(criteria, index)

The Lambda value of the components that meet the specified criteria and have the specified index.

Index is the 1-based index identifying the component.

=ComponentLambda(2)

(returns the Lambda value of the second component for each wall, round wall, roof, roof face, and slab object in the database)

=ComponentLambda(t=wall,1)

(returns the Lambda value of the first component for all walls in the drawing)

Related functions: CompLambdaByClass, CompLambdaByName

ComponentName
(criteria, index)

The name of the components that meet the specified criteria and have the specified index.

Index is the 1-based index identifying the component.

=ComponentName(2)

(returns the name of the second component for each wall, round wall, roof, roof face, and slab object in the database)

=ComponentName(t=wall,1)

(returns the name of the first component for all walls in the drawing)

Related functions: CompNameByClass

ComponentRValue
(criteria, index)

The R-value of the components that meet the specified criteria and have the specified index.

Index is the 1-based index identifying the component.

=ComponentRValue(2)

(returns the R-value of the second component for each wall, round wall, roof, roof face, and slab object in the database)

=ComponentRValue(t=wall,1)

(returns the combined R-values of the first components for all walls in the drawing)

Related functions: CompRValueByClass, CompRValueByName

ComponentThickness
(criteria, index)

The thickness of the components that meet the specified criteria and have the specified index.

Index is the 1-based index identifying the component.

=ComponentThickness(2)

(returns the thickness of the second component for each wall, round wall, roof, roof face, and slab object in the database)

=ComponentThickness(t=wall,1)

(returns the combined thickness of the first components for all walls in the drawing)

Related functions: CompThicknessByClass, CompThicknessByName

ComponentUValue
(criteria, index)

The U-value of the components that meet the specified criteria and have the specified index.

Index is the 1-based index identifying the component.

=ComponentUValue(2)

(returns the U-value of the second component for each wall, round wall, roof, roof face, and slab object in the database)

=ComponentUValue(t=wall,1)

(returns the combined U-values of the first components for all walls in the drawing)

Related functions: CompUValueByClass, CompUValueByName

ComponentVolume
(criteria, index)

The volume (minus any holes) of the components that meet the specified criteria and have the specified index.

Index is the 1-based index identifying the component.

=ComponentVolume(2)

(returns the volume of the second component for each wall, round wall, roof, roof face, and slab object in the database)

=ComponentVolume(t=wall,1)

(returns the combined volume of the first components for all walls in the drawing)

Related functions: CompVolumeByClass, CompVolumeByName

CompRValueByClass
(criteria, class)

The R-value of the components that meet the specified criteria and are in the specified class

=CompRValueByClass('Class-1')

(returns the R-value of the components assigned to the class “Class-1” for each wall, round wall, roof, roof face, and slab object in the database)

=CompRValueByClass(t=wall,'Class-1')

(returns the combined R-values of the components assigned to the class “Class-1” for all walls in the drawing)

Related functions: CompRValueByClass, ComponentRValue

CompRValueByName
(criteria, name)

The R-value of the components that meet the specified criteria and have the specified name

=CompRValueByName('Brick Veneer')

(returns the R-value of the components with the name “Brick Veneer” for each wall, round wall, roof, roof face, and slab object in the database)

=CompRValueByName(t=wall,'Brick Veneer')

(returns the combined R-values of the components with the name “Brick Veneer” for all walls in the drawing)

Related functions: CompRValueByClass, ComponentRValue

CompThicknessByClass
(criteria, class)

The thickness of the components that meet the specified criteria and are in the specified class

=CompThicknessByClass('Class-1')

(returns the thickness of the components assigned to the class “Class-1” for each wall, round wall, roof, roof face, and slab object in the database)

=CompThicknessByClass(t=wall,'Class-1')

(returns the combined thickness of the components assigned to the class “Class-1” for all walls in the drawing)

Related functions: CompThicknessByClass, ComponentThickness

CompThicknessByName
(criteria, name)

The thickness of the components that meet the specified criteria and have the specified name

=CompThicknessByName('Brick Veneer')

(returns the thickness of the components with the name “Brick Veneer” for each wall, round wall, roof, roof face, and slab object in the database)

=CompThicknessByName(t=wall,'Brick Veneer')

(returns the combined thickness of the components with the name “Brick Veneer” for all walls in the drawing)

Related functions: CompThicknessByClass, ComponentThickness

CompUValueByClass
(criteria, class)

The U-value of the components that meet the specified criteria and are in the specified class

=CompUValueByClass('Class-1')

(returns the U-value of the components assigned to the class “Class-1” for each wall, round wall, roof, roof face, and slab object in the database)

=CompUValueByClass(t=wall,'Class-1')

(returns the combined U-values of the components assigned to the class “Class-1” for all walls in the drawing)

Related functions: CompUValueByName, ComponentUValue

CompUValueByName
(criteria, name)

The U-value of the components that meet the specified criteria and have the specified name

=CompUValueByName('Brick Veneer')

(returns the U-value of the components with the name “Brick Veneer” for each wall, round wall, roof, roof face, and slab object in the database)

=CompUValueByName(t=wall,'Brick Veneer')

(returns the combined U-values of the components with the name “Brick Veneer” for all walls in the drawing)

Related functions: CompUValueByClass, ComponentUValue

CompVolumeByClass
(criteria, class)

The volume of the components that meet the specified criteria and are in the specified class

=CompVolumeByClass('Class-1')

(returns the volume of the components assigned to the class “Class-1” for each wall, round wall, roof, roof face, and slab object in the database)

=CompVolumeByClass(t=wall,'Class-1')

(returns the combined volume of the components assigned to the class “Class-1” for all walls in the drawing)

Related functions: CompVolumeByName, ComponentVolume

CompVolumeByName
(criteria, name)

The volume of the components that meet the specified criteria and have the specified name

=CompVolumeByName('Brick Veneer')

(returns the volume of the components with the name “Brick Veneer” for each wall, round wall, roof, roof face, and slab object in the database)

=CompVolumeByName(t=wall,'Brick Veneer')

(returns the combined volume of the components with the name “Brick Veneer” for all walls in the drawing)

Related functions: CompVolumeByClass, ComponentVolume

concat(text1, text2, text3)

Joins several text strings into one text string

=concat(B3,', ',B4)

(returns the contents of cells B3 and B4 as a single string, separated by a comma and a space)

cos(number)

The cosine of a given angle.

Number is the angle in radians for which the cosine is calculated.

(converts a 23-degree angle to its radian equivalent, and returns the cosine of the angle)

Related functions: acos

Count(criteria)

The number of objects that meet the specified criteria

=Count

(returns the total number of objects for each row in the database)

=Count(s='simple sofa')

(returns the total number of symbol objects named “simple sofa” in the drawing)

CurtWallFrameLength
(criteria, class)

The combined length of the curtain wall frames that meet the specified criteria and are in the specified class. To find all frames in a curtain wall, use an empty class name.

=CurtWallFrameLength('')

(returns the combined length of the curtain wall frames for each curtain wall in the database)

=CurtWallFrameLength(t=wall, '')

(returns the combined length of the curtain wall frames for all curtain walls in the drawing)

Related functions: CurtWallPnlAreaNet, CurtWallPnlAreaGross

CurtWallPnlAreaGross(criteria, class)

The combined gross area of the curtain wall panels in the walls that meet the specified criteria and are in the specified class. The gross area includes portions of the panel covered by frames. To find all panels in a curtain wall, use an empty class name.

=CurtWallPnlAreaGross('')

(returns the combined gross area of the curtain wall panels for each curtain wall in the database)

=CurtWallPnlAreaGross(t=wall, '')

(returns the combined gross area of the curtain wall panels for all curtain walls in the drawing)

Related functions: CurtWallFrameLength, CurtWallPnlAreaNet

CurtWallPnlAreaNet
(criteria, class)

The net area of the curtain wall panels in the walls that meet the specified criteria and are in the specified class. The net area includes only the visible area bounded by frames. To find all panels in a curtain wall, use an empty class name.

=CurtWallPnlAreaNet ('Class-1')

(returns the combined net area of the curtain wall panels assigned to the class “Class-1” for each curtain wall in the database)

=CurtWallPnlAreaNet(t=wall, 'Class-1')

(returns the combined net area of the curtain wall panels assigned to the class “Class-1” for all curtain walls in the drawing)

Related functions: CurtWallFrameLength, CurtWallPnlAreaGross

Converts a number from degrees to radians.

Number is the value in degrees to be converted to radians.

(converts the 47-degree angle measurement to its radian equivalent)

exp(number)

e raised to the power of number. The constant e equals 2.71828182845904, the base of the natural logarithm.

Number is the exponent applied to the base e.

=exp(2)

(returns the numeric value of e raised to the power of 2)

GetIfcProperty(criteria)

(Vectorworks Design Series required)

The value of a specific IFC property associated with an IFC object. The criteria is a string with two elements separated by a period. The first element is either an IFC entity or PSet name, and the second element is the name of the IFC property.

=GETIFCPROPERTY ('ifcfurnishingelement.name')

(returns the Name value for IFC objects whose IFC entity is IfcFurnishingElement)

GetSpaceNameForObj
(criteria)

(Vectorworks Architect required)

The name of the space that surrounds the object that meets the specified criteria

=GetSpaceNameForObj

(returns the space name for each object in the database)

=GetSpaceNameForObj(n='chair-1')

(returns the space name for the object named “chair-1”)

Related functions: GetSpaceNumForObj

GetSpaceNumForObj
(criteria)

(Vectorworks Architect required)

The number of the space that surrounds the object that meets the specified criteria

=GetSpaceNumForObj

(returns the space number for each object in the database)

=GetSpaceNumForObj(n='chair-1')

(returns the space number for the object named “chair-1”)

Related functions: GetSpaceNameForObj

Height(criteria)

The combined delta y (height) of objects that meet the specified criteria

=Height

(returns the height (delta y) for each object in the database)

=Height(sel=true)

(returns the combined height (delta y) value of the selected objects in the drawing)

Related functions: Width

if ((logical_test), value_if_true, value_if_false)

Use value_if_true if logical_test is true, value_is_false if logical_test is false.

Use this function to conduct conditional tests on values and formulas and to branch based on the results of that test. The outcome of the test determines the value returned by the If function. The logical_test can be any value or expression that can be evaluated to true or false. Up to seven If statements can be nested as value_if_true, value_if_false arguments. Boolean statements within an if statement must be in parentheses. Text within an if statement should be enclosed within quotation marks.

=if((C7>100),100,C7)

when commas are used as decimal separators by the operating system, use semicolons instead:

=if((C7>100);100;C7)

(if the value in cell C7 is greater than 100, the value in this cell is 100; otherwise, the value in this cell is the same as the value in cell C7)

Image(criteria)

(Vectorworks Design Series required)

The image associated with the object that meets the specified criteria. In the cell format, specify whether to show a thumbnail of the object, or the 2D attributes applied to the object.

=Image

(returns the image for each object in the database)

=Image(s='cabinet')

(returns the image of the symbol named “Cabinet”)

int(number)

Removes any fractional part of a number.

Number is the real number to be changed to an integer.

=int(B9)

(returns the value in cell B9 without its fractional component)

Related functions: round

IsFlipped(criteria)

The flipped state of the objects that meet the specified criteria

=IsFlipped

(returns the flip state for each object in the database)

=IsFlipped(PON=window)

(returns the total number of window objects in the drawing that are flipped)

LeftBound(criteria)

The left side 2D boundary (minimum x coordinate) of the objects that meet the specified criteria

=LeftBound

(returns the left 2D boundary for each object in the database)

=LeftBound(t=locus)

(returns the left 2D boundary of the leftmost locus in the drawing)

Related functions: BotBound, TopBound, RightBound

Length(criteria)

The length of lines, walls, or path-based objects that meet the specified criteria

=Length

(returns the length for each object in the database)

=Length(t=line)

(returns the total length of all line objects in the drawing)

ln(number)

The natural logarithm (base e).

Number is the positive real number for which the logarithm is calculated.

=ln(12)

(returns the natural logarithm of 12)

Related functions: exp

log(number)

The base 10 logarithm.

Number is the positive real number for which the logarithm is calculated.

=log(2)

(returns the base 10 logarithm of 2)

Related functions: ln

max(number1, number2,...)

The largest number in the list of arguments.

Number is 1 – 14 numbers for which the maximum value is to be found.

=max(C5,C7,C9)

(returns the largest of the numbers that are in cells C5, C7, and C9)

Related functions: min

min(number1, number2,...)

The smallest number in the list of arguments.

Number is 1 – 14 numbers for which the minimum value is to be found.

=min(C5,C7,C9)

(returns the smallest of the numbers that are in cells C5, C7, and C9)

Related functions: max

ObjectType(criteria)

The numeric object type ID of objects that meet the specified criteria.

For a list of object type IDs, see the developer-oriented documentation here (Internet access required):

=ObjectType

(returns the object type value for each object in the database)

=ObjectType(sel=true)

(returns the object type value of the selected object; for example, the object type value for a light is 81)

ObjIncludeInEnergos
(criteria)

(Vectorworks Architect required)

The Energos status (1 if it is included in calculations, 0 if it is not) of the objects that meet the specified criteria

=ObjIncludeInEnergos

(returns the Energos status for each wall, round wall, roof, roof face, slab, door, and window object in the database)

=ObjIncludeInEnergos(t=wall)

(returns the Energos status for all walls in the drawing)

ObjRValue(criteria)

(Vectorworks Architect required)

The R-value of objects that meet the specified criteria

=ObjectRValue

(returns the R-value for each wall, round wall, roof, roof face, slab, door, and window object in the database)

=ObjectRValue(n='wall-1')

(returns the R-value for the wall named “wall-1”)

Related functions: ObjUValue

ObjUValue(criteria)

(Vectorworks Architect required)

The U-value of objects that meet the specified criteria

=ObjectUValue

(returns the U-value for each wall, round wall, roof, roof face, slab, door, and window object in the database)

=ObjectUValue(n='wall-1')

(returns the U-value for the wall named “wall-1”)

Related functions: ObjRValue

Perim(criteria)

The combined perimeter of objects that meet the specified criteria

=Perim

(returns the perimeter for each object in the database)

=Perim(sel=true)

(returns the total perimeter of all selected objects)

Converts a number from radians to degrees.

Number is the value in radians to be converted to degrees.

(converts the radian angle measurement to its degree equivalent)

RightBound(criteria)

The right side 2D boundary (maximum x coordinate) of the objects that meet the specified criteria

=RightBound

(returns the right 2D boundary for each object in the database)

=RightBound(t=rect)

(returns the right 2D boundary of the rightmost rectangle in the drawing)

Related functions: BotBound, TopBound, LeftBound

RoofArea_Heated
(criteria)

The heated area of the roof (minus the eve overhang) along the slope, combined for all objects that meet the specified criteria

=RoofArea_Heated

(returns the heated area for each roof and roof face object in the database)

=RoofArea_Heated (st=roofface)

(returns the combined heated area of all roof face objects in the drawing)

Related functions: RoofArea_HeatedProj

RoofArea_HeatedProj
(criteria)

The heated area of the roof (minus the eve overhang) projected to the layer plane, combined for all objects that meet the specified criteria

=RoofArea_HeatedProj

(returns the heated area for each roof and roof face object in the database, as projected to the layer plane)

=RoofArea_Heatedproj(t=roof)

(returns the combined heated area of all roof objects in the drawing, as projected to the layer plane)

Related functions: RoofArea_Heated

RoofArea_Total
(criteria)

The total area of the roof along the slope

=RoofArea_Total

(returns the total area for each roof and roof face object in the database)

=RoofArea_Total(st=roofface)

(returns the combined total area of all roof face objects in the drawing)

Related functions: RoofArea_TotalProj

RoofArea_TotalProj
(criteria)

The total area of the roof, projected to the layer plane

=RoofArea_TotalProj

(returns the total area for each roof and roof face object in the database, as projected to the layer plane)

=RoofArea_Totalproj(t=roof)

(returns the combined total area of all roof objects in the drawing, as projected to the layer plane)

Related functions: RoofArea_Total

RoofStyleName(criteria)

(Vectorworks Design Series required)

The name of the roof style

=RoofStyleName

(returns the roof style name for each roof object in the database)

=RoofStyleName(n='roof-1')

(returns the roof style name for the object named “roof-1”)

round(number)

Rounds the specified number to the nearest whole number

=round(D11)

(returns the value in cell D11 rounded to the nearest whole number)

Related functions: int

RunScript(scriptName, param1, param2,...)

Runs the specified VectorScript or Python script, passing the parameters that follow the script name to the script.

An optional parameter before the script name specifies the script’s folder path within the Vectorworks installation. For a list of folder path values, see the developer-oriented documentation here (Internet access required):

See Running Scripts from Worksheets for details.

=RunScript('My Script')

(executes the VectorScript script named “My Script” and returns a value for each object in the database)

=RunScript(2, 'ScriptFile.py', 2, 1)

(executes the Python script “ScriptFile.py” in the Vectorworks Plug-Ins folder, passing the parameters “2” and “1,” and returns a value)

sin(number)

The sine of a given angle.

Number is the angle in radians for which the sine is calculated.

(converts a 32-degree angle to its radian equivalent, and returns the sine of the angle)

Related functions: asin

SlabStyleName

(Vectorworks Architect required)

The name of a slab style

=SlabStyleName

(returns the name of the slab style for each slab object in the database)

SlabThickness(criteria)

(Vectorworks Architect required)

The combined thickness of slab objects (floors and roof faces) that meet the specified criteria

=SlabThickness

(returns the thickness for each object in the database)

=SlabThickness(PON=slab)

(returns the combined thickness of all slab objects in the drawing)

sqrt(number)

A positive square root.

Number is the number for which the square root is calculated.

=sqrt(D27)

(returns the square root of the number in cell D27)

Substring(text/function, delimiter, index)

Splits a single string into an array of strings using a delimiter, and outputs each string at the specified index

=SUBSTRING(('kitchen;bedroom;bathroom;basement', ';', 2)

(returns “bedroom,” which is the second substring in the specified string)

sum(number1, number2,...)

The sum of all numbers in the list of arguments.

Number is 1 – 14 numbers for which the sum is calculated.

=sum(A2,A10..A12)

(returns the sum of the numbers contained in cells A2, A10, A11, and A12)

Related functions: Average

SurfaceArea(criteria)

The total surface area of all objects that meet the criteria, based on the Area units in the Units dialog box

=SurfaceArea

(returns the surface area for each object in the database)

=SurfaceArea(st=sphere)

(returns the total surface area of all sphere objects in the drawing)

tan(number)

The tangent of the given angle.

Number is the angle in radians for which the tangent is calculated.

(converts a 32-degree angle to its radian equivalent, and returns the tangent of the angle)

Related functions: atan

TopBound(criteria)

The top 2D boundary (maximum y coordinate) of the objects that meet the specified criteria

=TopBound

(returns the top 2D boundary for each object in the database)

=TopBound(sel=true)

(returns the top 2D boundary of the topmost selected object)

Related functions: BotBound, LeftBound, RightBound

value(text)

Converts a text string that represents a number to a number

=value('2e3')

(returns the numeric value of 2 times 10 raised to the power of 3)

Volume(criteria)

The total volume of all objects that meet the criteria, based on the Volume units in the Units dialog box

=Volume

(returns the volume for each object in the database)

=Volume(t=xtrd)

(returns the total volume of all extrude objects in the drawing)

WallArea_Gross
(criteria)

The combined 2D gross surface area of one wall face for walls that meet the specified criteria

=WallArea_Gross

(returns the gross surface area of one wall face for each wall object in the database)

=WallArea_Gross(t=wall)

(returns the combined gross surface area of one wall face for all walls in the drawing)

Related functions: WallArea_Net

WallArea_Net(criteria)

The combined 2D net surface area of one wall face, without door, window, and inserted symbol areas, for walls that meet the specified criteria

=WallArea_Net

(returns the net surface area of one wall face, minus inserted object areas, for each object in the database)

=WallArea_Net(t=wall)

(returns the combined net surface area of one wall face, minus inserted object areas, for all walls in the drawing)

Related functions: WallArea_Gross

WallAverageHeight
(criteria)

The average height of a wall, including wall peaks and different starting and ending heights

=WallAverageHeight

(returns the average height for each wall object in the database)

=WallAverageHeight((t=wall)&
(sel=true))

(returns the average height of all walls that are selected in the drawing)

WallStyleName(criteria)

(Vectorworks Architect or Landmark required)

The name of a wall style

=WallStyleName

(returns the name of the wall style for each wall object in the database)

WallThickness(criteria)

The combined thickness of wall objects that meet the specified criteria

=WallThickness

(returns the thickness for each wall object in the database)

=WallThickness(t=wall)

(returns the combined thickness of all walls in the drawing)

Width(criteria)

The combined delta x (width) of objects that meet the specified criteria

=Width

(returns the width (delta x) for each object in the database)

=Width(sel=true)

(returns the combined width (delta x value) of the selected object)

Related functions: Height

XCenter(criteria)

The x coordinate of the center point of an object that meets the specified criteria

=XCenter

(returns the x coordinate value of the center of the 2D boundary for each object in the database)

=XCenter(sel=true)

(returns the x coordinate value of the center of the 2D boundary of the selected object)

Related functions: YCenter, ZCenter, XCoordinate

XCoordinate(critiera)

The x coordinate of the insertion point for symbols, point plug-in objects, and loci.

The returned value is relative to the user origin.

=XCoordinate

(returns the x coordinate value for each object in the database)

Related functions: YCoordinate, ZCoordinate, XCenter

YCenter(criteria)

The y coordinate of the center point of an object that meets the specified criteria

=YCenter

(returns the y coordinate value of the center of the 2D boundary for each object in the database)

=YCenter(sel=true)

(returns the y coordinate value of the center of the 2D boundary of the selected object)

Related functions: XCenter, ZCenter, YCoordinate

YCoordinate(criteria)

The y coordinate of the insertion point for symbols, point plug-in objects, and loci.

The returned value is relative to the user origin.

=YCoordinate

(returns the y coordinate value for each object in the database)

Related functions: XCoordinate, ZCoordinate, YCenter

ZCenter(criteria)

The z coordinate of the center point of an object that meets the specified criteria

=ZCenter

(returns the z coordinate value of the center of the 3D boundary for each object in the database)

=ZCenter(sel=true)

(returns the z coordinate value of the center of the 3D boundary of the selected object)

Related functions: XCenter, YCenter, ZCoordinate

ZCoordinate(criteria)

The z coordinate of the insertion point for symbols, point plug-in objects, and loci.

The returned value is relative to the user origin.

=ZCoordinate

(returns the z coordinate value for each object in the database)

Related functions: XCoordinate, YCoordinate, ZCenter

~~~~~~~~~~~~~~~~~~~~~~~~~ 