About Using Case for the Formula Property Definition Worksheet

Creating a formula that returns valid data can be a complex task. As the following example shows, you can simplify the process by using the Formula Property Definition worksheet to construct the formula with VBScript Code. You then insert sample values into the formula and evaluate the result.

Example of Completed Formula

The space object has a single numeric value for its height, which is adequate for the majority of spaces in a room schedule. However, to get more control over how space heights are displayed for rooms without flat ceilings, you can create a formula that returns a text override, such as “Vaulted” for a cathedral ceiling, or return the actual height. The completed worksheet for such a formula is shown below.

Process Used to Complete Example

Using primarily the default property set definitions in the Style Manager, the following process was completed.

Added SpaceStyles as a new property set definition

On the Definition tab for the SpaceObjects property set definition

Edited the HeightDisplayed formula property definition on the Formula Property Definition worksheet

Sample values are formatted and inserted into the formula in place of the corresponding property definition names with brackets surrounding them. The entire sample formula is evaluated, and the result displays in the Sample Result pane.

Because this formula contains the word RESULT, it is evaluated as a function instead of an expression, and the value of the formula property is the last value assigned to RESULT. The result of this valid formula is Vaulted.