The worksheet functionality in the Vectorworks program complements its drawing functionality. From the information present in the file, you can create worksheets to track data, create cost and material lists, perform calculations, and more. Worksheets are integrated within the Vectorworks file, which eliminates the need for a separate program and reduces the number of files per project. Worksheets can be imported and exported, which allows data to be shared between worksheets, files, and other spreadsheet programs.
To get a quick overview of worksheet features, see Worksheet Tutorial: Creating a Wall Schedule.
Worksheets can have two types of rows: spreadsheet and database. The cells in a spreadsheet row contain constants (text or numbers), or formulas. Database rows consist of a header row and sub-rows, and they show data that are associated with specific drawing objects. Set selection criteria for the header row, and a sub-row is created for each object that meets the criteria.
In this example, spreadsheet row 1 has labels for the database columns. Database header row 2 is set to list each object in the drawing that has an “appliance record” attached to it. The sub-rows 2.1 through 2.5 represent the five objects in the drawing that meet this criteria.
Columns are labeled with letters, and rows are labeled with numbers. Database sub-rows are numbered with the database header row’s number, followed by a decimal and sequential numbers. The cell’s column letter and row number indicate the spreadsheet cell address, as in A4 or D2 (database sub-rows do not display an address).
When worksheets exist in an open file, the Window > Worksheets command becomes available. All the worksheets present in the file are listed. Worksheets with a check mark are currently open. To open a worksheet, select it from this menu, or from the Resource Manager, right-click on the resource, and select Open from the context menu.
A worksheet opens in a separate window, which can be resized, moved, and closed. The worksheet window contains its own menu and context menus.
Because an open worksheet is in a separate window, it is not printed with the drawing. To include a worksheet as part of a drawing, from the open worksheet window, select File > Worksheet on Drawing. (Alternatively, drag the worksheet from the Resource Manager to the drawing area.) When the worksheet is open, the worksheet on the drawing displays as an X. To open a closed worksheet from the drawing, double-click on it. See Placing a Worksheet on the Drawing.
~~~~~~~~~~~~~~~~~~~~~~~~~
For complex drawings, it is best to create separate worksheets for each task rather than one large worksheet. Worksheets can be linked to share data, formulas, and calculations.
Worksheets can be created in several ways:
• Use the Create Report command to select worksheet data from the information associated with the objects in the drawing. See Creating Reports.
• Import worksheets from other Vectorworks files or from other spreadsheet programs. See Importing Worksheets.
• If Vectorworks Design Series is installed, preformatted records and schedules such as room finishes, plant lists, and lighting instruments can be added to the drawing. See Using Preformatted Reports.
• Use the Resource Manager to create a blank worksheet, and then add the desired information to it. See Creating a Blank Worksheet.
Once created, a worksheet is saved with the file and is listed in the Resource Manager. It can also be accessed by selecting Window > Worksheets.
If the same objects are typically used in your drawings, you can create a template file with a worksheet that serves as a “master price list” listing all the objects and their costs. Then, to create materials lists and cost estimates for a new design, simply import the worksheet into the new drawing file.
Instead of using the Create Report command, you can create a blank worksheet and add data to it manually. This gives you more control over the contents and format of the worksheet.
To create a blank worksheet:
1 From the Resource Manager, click New Resource, select Worksheet, and then click Create. Alternatively, from the Resource Manager, select Worksheets from the list of resource types on the tool bar, and click New Worksheet.
The Create Worksheet dialog box opens.
► Clique para exibir/ocultar parâmetros.
2 Specify the basic worksheet parameters.
A new worksheet window opens.
3 At this point, all rows contain spreadsheet cells, and they are all undefined. Define the contents of each row and cell as needed:
• To add simple text, numbers, or formulas to the worksheet, see Spreadsheet Rows.
• To list data that is associated with objects in the drawing, change a spreadsheet row into a database row, and specify which objects to include in the list. A sub-row displays for each object that matches the criteria defined in the database header row. Then specify which information to display in the columns for each row; these can be fields from the object’s data record, as well as text, numbers, or formulas. See Displaying Object Properties in a Database Column and Displaying Record Information in a Database Column.
• To add images to either spreadsheet or database rows, see Inserting Images in Worksheet Cells (Vectorworks Design Series required).
~~~~~~~~~~~~~~~~~~~~~~~~~
The main menu is at the top of the worksheet window. Many of the main menu commands are also available from context menus. Right-click on a worksheet row number, column letter, or cell to open a context menu.
► Click to show/hide the commands.
Most of the commands are also available on the Worksheet Menu. The following commands are available only on the context menu.
► Click to show/hide the commands.
Most of the commands are also available on the Worksheet Menu. The following commands are available only on the context menu.
► Click to show/hide the commands.
Worksheets can have two types of rows: spreadsheet and database. Generally, the cells in a spreadsheet row contain explanatory information. Database rows consist of a header row and sub-rows, and they show data that are associated with specific drawing objects. The database header row is identified by a diamond shape next to the row number, a gray background, and buttons in the right corner of each cell.
Three types of information can be defined for these rows: constant values (including text or numbers), formulas, and images (Vectorworks Design Series required). In addition, a cell can reference another cell in the same worksheet or in another worksheet.
• Text helps to identify the purpose of a worksheet and labels the columns in a worksheet.
• Use formulas to perform calculations based on drawing data. A formula can be a simple mathematical equation, or it can include one or more built-in functions. The Vectorworks program provides mathematical functions (for example, a square root function), as well as functions that pull information from drawing objects (for example, a function that returns the volume of selected objects). Worksheet Functions lists all the functions available.
• Images add visual information about items on a worksheet, and can also be used to create a drawing legend (Vectorworks Design Series required).
In the following example, spreadsheet row 1 contains labels for each column in the database. Database header row 2 has its criteria set to list all the objects in the drawing that have the appliance record attached to them. These objects display in sub-rows 2.1 through 2.5. For row 2, columns A through D list the contents of the data fields in the appliance record: the appliance type, manufacturer, model number, and price. Column E contains a formula, which uses the value in column D to calculate the price of the appliance with sales tax. Column F lists which layer of the drawing contains the object.
Command |
Path |
|---|---|
Spreadsheet |
Row context menu |
Spreadsheet rows are useful for creating explanatory information, such as column labels, column totals, drawing legends, and general calculations.
To define a spreadsheet row:
1 Right-click on the number of the row to change.
2 Select the command.
3 The cells in the row are empty until you define the contents. Select a cell, and then enter the desired information in the worksheet Formula bar located at the top of the worksheet.
• To enter text or numbers, see Entering Constant Values in Worksheet Cells.
• To enter a formula, see Entering Formulas in Worksheet Cells.
• To reference other cells in this cell, see Referencing Other Worksheet Cells.
• To insert an image, see Inserting Images in Worksheet Cells.
Command |
Path |
|---|---|
Database |
Row context menu |
Database rows display data fields, calculations, or images associated with the objects in a drawing. When you create the database row, set the criteria to determine which objects will be listed in the related sub-rows. For example, you might set a header row to list all chairs in the drawing. (If no object meets the header row criteria, no sub-rows are created.) You can specify multiple criteria; for example, create a list of all the chairs in a resort, or list only the green wing-backed chairs from all the two-room suites that are scattered throughout the resort.
In each cell in the database header row, specify which information about the objects to display in that column. A column can list a specific property of each sub-row object, such as its class or layer. A column can also list a data field contained in a record attached to each object. Alternatively, a column can contain a constant, an image, or a formula, just as a spreadsheet cell can.
To define a database row:
1 Right-click on the number of the row to change.
2 Do one of the following:
• The easiest option is to select Create Report (or Edit Report, if you are editing an existing row), and then specify the database criteria and the columns to display as described in Creating Reports.
• If you are familiar with worksheets, select Database, and then use the following steps.
3 From The Criteria Dialog Box, specify which objects to include in the database.
4 In the worksheet, sub-rows are created beneath the header row for each drawing object that meets the criteria specified. The columns are empty until you define which data from the objects to display in each column.
5 From each cell in the database header row, specify the information to be shown in that column:
• To list a simple property of each object (such as layer or class), see Displaying Object Properties in a Database Column.
• To list record data associated with each object (such as color or price), see Displaying Record Information in a Database Column.
• To show the results of a formula for each object, see Entering Formulas in Worksheet Cells.
• To show an image for each object, select Insert > Image Function from the Worksheet menu. Alternatively, select Insert Image Function from the cell context menu. See Inserting Images in Worksheet Cells.
6 Each sub-row cell displays the information requested. Each cell in the header row displays the total number of objects found, or, if the column returns numerical data, the header cell displays the sum for all sub-rows. Information found in each column can be sorted, summarized, and summed; see Cell Context Menu.
7 Once all the data is added, edit the worksheet as needed. For example, add rows or columns, change the text format, or add color.
A database row can be “undefined” to turn it into a spreadsheet row.
To undefine a database row:
1 Right-click on the number of the database header row to change.
2 Select Spreadsheet.
Undefining a database row removes the database row criteria and all sub-rows. Any formulas that were defined in the columns of the header row remain intact.
The Criteria dialog box defines the criteria for a database row in a worksheet, or for a worksheet function.
From the dialog box, select a main criterion from the first field. Depending on the type of criterion selected, additional controls display to the right of the first field to allow you to complete the criteria statement.
If desired, select one or more options to include components of symbols, plug-in objects, viewport annotations, and design layer viewports (Vectorworks Design Series required). The number of objects that meet the criteria displays, to help you verify that the criteria statement is correct.
Click More Choices to specify additional criteria. Click Fewer Choices to remove added criteria.
In the following example, “IFC Entity” is the main criterion, the second criterion is “is,” and then the button on the right was clicked to select the IfcStair entity from another dialog box.
~~~~~~~~~~~~~~~~~~~~~~~~~
Add constant values to both spreadsheet and database cells to provide labels or other explanatory information. Constant values consist of numbers, spaces, non-numeric characters, or any combination of these. Constant values are not part of a formula or the result of a formula.
The formula phrase “=1”, or any number following an equal sign, is also considered a constant value.
Select the cell, and then enter the text or numbers needed; your entries automatically display in the worksheet Formula bar. When you click the green check mark on the Formula bar, the value displays in the cell.
Keep in mind the following:
• Most constant values are treated as text and default to the General format. However, some combinations of numeric and non-numeric characters are interpreted as a particular number format. For example, an entry of 07/19/2018 automatically changes the format to the month/day/year date format. (See Formatting Worksheet Cells.)
• Text is left-aligned unless the cell is formatted differently on the Alignment tab in the Format Cells dialog box (select Format > Cells from the Worksheet menu).
• Numbers entered in cells default to the General format. To change them to another format (for example, dimension or fractional), select Format > Cells from the Worksheet menu, and select the new format on the Number tab in the Format Cells dialog box.
~~~~~~~~~~~~~~~~~~~~~~~~~
Use formulas in both spreadsheet and database cells to evaluate and perform operations on drawing data. Formulas always begin with an equal sign (=) and consist of a combination of functions, cell references, or operators that combine values to produce a new value.
There are three ways to enter a function in a cell:
• In a database row cell, click the button and select a function from the Set Field dialog box.
• Manually enter a formula in the Formula bar.
• Use the Insert > Function and Insert > Criteria commands.
To quickly enter a single-function formula for a database column (for example, Volume), click the button on the cell and select the function as described in Displaying Object Properties in a Database Column.
To manually enter a formula:
1 Select the cell.
2 Enter an equal sign (=), and then enter the formula. The entries display in the worksheet Formula bar. A formula can consist of functions, operators, cell references, and constant values.
3 When the formula is complete, click the green check mark or press Enter to validate the entry. To cancel an entry, click the red X or press Esc.
4 The formula executes as soon as the cell entry has been validated (Auto-recalc must be selected in the worksheet preferences; see Preferences).
Command |
Path |
|---|---|
Function |
Insert (worksheet menu) |
To enter a formula with the Function and Criteria commands:
1 Select the cell.
2 Enter an equal sign (=). The entry automatically displays in the worksheet Formula bar.
3 Select the command.
The Select Function dialog box opens.
4 Select a function from the list.
The formula is placed in the worksheet Formula bar and the cursor is placed between the parentheses, awaiting an argument, if necessary.
5 Do one of the following:
• If the function requires numbers or text, enter the argument between the parentheses and proceed to step 8.
• If the function requires selection criteria, select Insert > Criteria from the Worksheet menu.
6 If an object is selected when the Criteria command is selected, the Paste Attributes dialog box opens. Otherwise, proceed to step 7.
Do one of the following:
• To use attributes of the selected object as the only selection criteria, select the attributes and proceed to step 8.
• To specify other criteria, or to use attributes of other objects in the drawing, click the Custom button.
7 The Criteria Dialog Box opens. Specify the criteria for the function.
8 When the formula is complete, click the green check mark or press Enter to validate the entry. To cancel the entry, click the red X or press Esc.
9 The formula executes as soon as the cell entry has been validated (Auto-recalc must be selected in the worksheet preferences; see Preferences).
Formulas must be entered with a specific syntax. If the formula is not entered correctly, the formula entry itself displays in the cell, instead of the result of the formula. Two common mistakes in syntax include forgetting to use pairs of parentheses, and omitting required commas when arguments are present. Formula syntax is described in the following table.
► Click to show/hide the syntax operators.
To force the program to treat a number as text, enclose the number in single quotation marks, as in '40'; or format the cell as Text on the Number tab of the Format Cells dialog box.
Formulas follow standard algebraic rules of hierarchy. In the following example, the value in cell C28 is first multiplied by 12, and then 4.5 is subtracted from that value. The result is then divided by 12.
=((C28*12)-4.5)/12
There are several built-in functions that can be used in formulas, including mathematical functions and functions that pull information from objects in the drawing. To use one or more worksheet functions in a formula, either enter the function manually, or use the Insert > Function and Insert > Criteria commands to select a function and selection criteria (if required) from dialog boxes. See Worksheet Functions for more information about how to use functions.
If there is a logic problem or calculation error with a formula, an error code displays in the cell.
► Click to show/hide the error codes.
In a worksheet, a formula can reference the contents of one or more other cells. The cells can be referenced within the current worksheet (internal references), or from another worksheet (external references) within the same file.
External references must include the full path name to the other worksheet. The following table shows the syntax for entering an external reference into a formula.
Syntax |
Example |
|---|---|
worksheet name:cell address |
=MyWorksheet:A1 |
worksheet name:range of addresses |
=SUM(MyWorksheet:A1..A12) |
If the name of the worksheet contains spaces, the name must be enclosed with single quotes as in the following example: ='Appliance Schedule':A1
To update an external reference, select File > Recalculate from the Worksheet menu.
Cell references in a worksheet can be either relative or absolute. When the formula that contains the reference is moved, an absolute reference always refers to the original cell address, while a relative reference changes depending on the location of the cell that contains the reference.
Use the dollar sign ($) character to indicate an absolute reference. The $ character locks the part of the cell reference it precedes, as described in the following table.
Combination |
Description |
|---|---|
$A1 |
Locks the specified column reference but leaves the row reference relative; the same column is always referred to, but the row changes if the formula is placed in a different row |
$A$1 |
Locks both the specified column and row references; regardless of where the formula is copied, it always refers to the original cell |
A$1 |
Locks the specified row reference but leaves the column reference relative; the same row is always referred to, but the column changes if the formula is placed in a different column |
In the following example worksheet, the formula =AVERAGE(B1..B3) is in cell B4. If the formula were copied to cell E9, the formula would automatically be changed to =AVERAGE(E6..E8). Because the references are relative, both the column and row would change relative to the cell where the formula is placed—always indicating the three cells directly above the formula.
~~~~~~~~~~~~~~~~~~~~~~~~~
Inserting
Images in Worksheet CellsIf Vectorworks Design Series is installed, add images to both spreadsheet and database cells to provide graphic views of the objects in a drawing. The images can be either thumbnail versions of objects, or samples of the 2D attributes of objects. For example, you might create a window schedule that shows top and front thumbnail views of each type of window in your drawing, in addition to data about each window.
To insert an image in a cell, use the image function, which works the same as other standard worksheet functions; see Entering Formulas in Worksheet Cells.
For plant images, you can also use the PlantImage functions.
Like other functions, you can enter an image function manually on the Formula bar, or use commands and dialog boxes to build a formula that uses the image function.
A cell that uses the image function in a formula can include either a text expression or an image, but not both.
To manually enter an image formula:
1 Select the cell.
2 Enter the image function (=IMAGE). The entry automatically displays in the worksheet Formula bar. If the cell is in a database header row, no further entry is required.
3 If the cell is in a spreadsheet row, enter the rest of the formula to specify which object to display. For example, to display an image of the symbol called K-02221, enter this:
=IMAGE(S='K-02221')
4 When the formula is complete, click the green check mark to validate the entry. To cancel an entry, click the red X.
5 The formula executes, and the image displays (Auto-recalc must be selected in the worksheet preferences).
6 Customize the image display from the Image tab of the Format Cells dialog box as described in Formatting Worksheet Cells.
Command |
Path |
|---|---|
Image Function |
Insert (worksheet menu) |
To enter a formula with the Image Function and Criteria commands:
1 Select the cell.
2 Select the command. Alternatively, right-click the cell and select Insert Image Function.
The image function is placed in the worksheet Formula bar and the cursor is placed between the parentheses, awaiting an argument. If the cell is in a database header row, no further entry is required.
3 If the cell is in a spreadsheet row, enter criteria to specify which drawing object to display. Select Insert > Criteria from the Worksheet menu.
4 If an object is selected when the Criteria command is selected, the Paste Attributes dialog box opens. Otherwise, proceed to step 5.
Do one of the following:
• To use attributes of the selected object as the only selection criteria, select the attributes.
• To specify other criteria, or to use attributes of other objects in the drawing, click Custom.
5 The Criteria Dialog Box opens. Specify the criteria for the function.
6 When the formula is complete, click the green check mark to validate the entry. To cancel the entry, click the red X.
7 The formula executes, and the image displays (Auto-recalc must be selected in the worksheet preferences).
8 Customize the image from the Image tab of the Format Cells dialog box as described in Formatting Worksheet Cells.
|
Click here for a video tip about this topic (internet access required). |
~~~~~~~~~~~~~~~~~~~~~~~~~
A drawing object can have several properties, such as the layer it is on, the type of object it is, its height, and whether it is currently selected. You can display this information in the database rows of a worksheet.
To display object information in a database column:
1 From the database header row, click the button on the right side of the column where you want the data to display.
The Set Field dialog box opens.
2 From the first field, select Functions. From the second field, select a function to display data in this column. For example, Layer displays the design layer where each database object is located. See Worksheet Functions for details.
3 If desired, set a Sort option for this column, and select whether to Summarize Items and Sum Values in the column. These options are also available on the Cell Context Menu.
4 When you click OK, the data displays in the worksheet, and the Formula bar displays the appropriate function. For example, “=Layer” displays for the Layer function.
Advanced users can specify more complicated formulas in the Formula bar directly, as described in Worksheet Functions.
~~~~~~~~~~~~~~~~~~~~~~~~~
Database records are created in the Record Formats dialog box. These records are then assigned to objects through the Data tab of the Object Info palette. See Attaching Record Formats to Symbols and Objects for more information. This information can be displayed in the database rows of a worksheet.
To display record information in a database column:
1 From the database header row, click the button on the right side of the column where you want the data to display.
The Set Field dialog box opens.
2 From the first field, select Records. From the second field, select the record to display data from.
3 Below those fields, the list of data fields in that record displays. Select the field to display in this column.
4 If desired, set a Sort option for this column, and select whether to Summarize Items and Sum Values in the column. These options are also available on the Cell Context Menu.
5 When you click OK, the data displays in the worksheet, and the worksheet Formula bar displays the syntax for the displaying record information:
Syntax |
Example |
|---|---|
=record name.field name |
=’Appliance Record’.’Type’ |
Note that a period (.) separates the two names. Also, if the name of the record format or field name contains spaces, the name must be enclosed with single quotes. If you know the record and field names, you can enter this syntax into the Formula bar directly.
~~~~~~~~~~~~~~~~~~~~~~~~~
The contents of cells can be edited and the rows and columns can be resized, cut, copied, pasted, added, and moved.
Worksheets can also be scaled once they have been placed on the drawing; see Scaling Worksheets.
The following table describes the keys used to move around in the worksheet.
Keys |
Description |
|---|---|
Arrow (Up, Down, Right, Left) |
Moves by one cell in the direction indicated |
Tab |
Moves right by one cell |
Enter |
Moves down by one cell |
Shift+Tab |
Moves left by one cell |
Shift+Enter |
Moves up by one cell |
If more than one cell is selected, movement is restricted to the selected cells only.
Selected cells are surrounded with a black outline. When multiple cells are selected, the active cell is white, and the remaining selected cells are highlighted in blue.
Selection |
Action |
|---|---|
A single cell |
Click the cell |
A range of cells |
Click-drag across a range of cells to select them, or click in one corner and Shift-click in the opposite corner |
An entire column or row |
Click the column letter or row number; to select multiple rows or columns, click-drag across the column letters or row numbers, or click the first column letter or row number, and then Shift-click the last column letter or row number in the desired range |
Non-contiguous cells, rows, or columns |
Press and hold the Ctrl (Windows) or Command (Mac) key and then click each cell, row, or column to select |
The entire worksheet |
Click the upper left corner of the worksheet (above the first row number) |
When a cell is selected, the display of the Formula bar indicates whether the contents of the cell can be edited.
Only one cell can be edited at a time; if you select multiple cells, only the first cell in the selection is changed.
Formula Bar Display |
Explanation |
|---|---|
The cell address displays, and the red X and green check mark are active |
The cell is in a spreadsheet row or database header row. Edit the text, numbers, or formula from the Formula bar, or double-click the cell and edit the contents directly. To accept the edits, do one of the following: • Click the green check mark. • Press Tab. • Press Enter (Windows) or Return (Mac). To cancel the edits, press Esc or click the red X. |
No cell address displays; the current cell value is not editable |
In database sub-rows, the results of calculations cannot be edited. In addition, object attribute information, such as the class the object belongs to, cannot be edited in the worksheet. |
No cell address displays, and the red X and green check mark are active (Design Series required) |
In database sub-rows, if Vectorworks Design Series products are installed, information that comes from the object’s data record can be edited in the worksheet, and the object’s record is updated automatically. For example, the price data for a sub-row object could be updated. Edit the data from the Formula bar, or double-click the cell and edit the data directly. To accept the edits and change both the worksheet and record, do one of the following: • Click the green check mark. • Select another cell. • Press Tab. • Press Enter (Windows) or Return (Mac). To cancel the edits, press Esc or click the red X. |
No cell address displays; a list of the values that are available for the current cell displays (Design Series required) |
In database sub-rows, if Vectorworks Design Series products are installed, some fields that come from the object’s data record can be edited, but they only allow certain pre-defined values. For example, the sill style for a window sub-row object could be changed. From either the Formula bar or the cell, select the new value from the list to change both the worksheet and record. |
Neither a cell address nor a cell value displays
|
In database sub-rows, if the Vectorworks Architect or Vectorworks Landmark product is not installed, information that comes from the object’s data record cannot be edited in the worksheet. To edit a value that displays in a sub-row, right-click the number of the row that is associated with the item in the drawing, and select Select Item. Then use the Data tab of the Object Info palette to edit the object data. |
To adjust column width or row height, drag the divider bar between the column letters or row numbers. If you select multiple rows or columns before you drag the bar, all rows or columns are adjusted to the same size.
Alternatively, select the Column Width command from either the Format menu or the column context menu (see Column Width). Adjust the row height with the Row Height command from either the Format menu or the row context menu (see Row Height).
Text that is longer than the width of a cell “floats” over empty adjacent cells. Numbers that exceed the cell width are displayed with # characters. Alternatively, text can be set to wrap (see Formatting Worksheet Cells).
To hide a row or column, set the Column Width or Row Height to 0. To display the column or row again, position the cursor over the column letter or row number adjacent to the hidden column or row. When the cursor changes to a double bar resize cursor, click-drag the bar to resize the column or row.
The standard shortcut keys for Cut and Paste can be used for worksheet editing. The same value or formula can be copied and pasted to a range of cells.
To copy cell contents to a cell or range of cells:
1 Select the cell with the information to repeat, and then press Ctrl+C (Windows) or Command+C (Mac) to copy the cell.
Alternatively, select the Copy command from either the Edit menu or the appropriate context menu (see Copy).
2 Select the destination cell for the information, and then press Ctrl+V (Windows) or Command+V (Mac) to paste. The formula or value is repeated in each of the selected cells.
Alternatively, select the Paste command from either the Edit menu or the appropriate context menu (see Paste).
From the Insert menu, you can insert rows and columns (see Worksheet Commands). An empty row is added above the current row, or an empty column is added to the left of the current column. Another option is to position the cursor at the bottom right corner of the worksheet to activate a special resize cursor; drag to add rows and columns to the bottom and right side of the worksheet.
Use the drag and drop method to move contiguous rows and columns or to move a copy of contiguous rows and columns.
To move a copy of rows or columns:
1 Click the column letter or row number to select a column or row (click-drag across the letters or numbers to select multiple columns or rows).
2 Press and hold Ctrl (Windows) or Option (Mac) and move the cursor to the edge of the selected rows or columns. When the cursor changes to a copy cursor to indicate that moving a copy is permitted, drag the selection to the desired location in the worksheet.
To move rows or columns:
1 Click the column letter or row number to select a column or row (click-drag across the letters or numbers to select multiple columns or rows).
2 Move the cursor to the edge of the selected rows or columns. When the cursor changes to a move cursor to indicate that moving the rows or columns is permitted, drag the selection to the desired location in the worksheet.
Command |
Path |
|---|---|
• Select Data Items • Select Item |
Context menu |
You can use the database rows in a worksheet to select the objects in the drawing that are related to that row.
To select database objects:
1 Either all database objects or a single database object can be selected.
• To select all database objects that meet the database row criteria, right-click the row number of the database header row to open the context menu.
• To select an individual database object, right-click the row number of the sub-row that contains the object to open the context menu.
2 Select the command.
All database objects that are represented by the header row, or the individual row object, are selected. If an individual object is selected with Select Item, the drawing view changes to display the selected object. The Select Item command is grayed if the sub-row is summarized (see Formatting Worksheet Cells).
Editing
Drawing Objects from a WorksheetIf Vectorworks Design Series is installed, you can use the database rows in a worksheet to make global changes to symbol and plug-in object record information, as well as IFC data. The objects and any associated data tags are updated automatically on the drawing. Similarly, if a symbol or plug-in object has record or IFC information displayed on a data tag, you can edit the information from the data tag.
Only database rows are directly associated with drawing elements, and can update the drawing in this way. Fields that result from a calculation, or from locked objects, referenced items, or control points, cannot edit drawing elements.
To edit drawing object data from a worksheet:
1 Open the worksheet that contains the data to be edited. From the Resource Manager, right-click on the resource, and select Edit from the context menu. Alternatively, select the worksheet from the Window > Worksheets menu.
2 Select the database row cell to be edited.
Text and number fields can be edited directly, while popup fields allow a selection to be made, either from the edit list at the top of the worksheet, or from the Pick Value from List context menu item.
To repeat the same value in several text or number fields, copy the desired value from one field, select multiple rows, and paste. (You cannot paste values for popup fields.)
3 The drawing objects are automatically updated with the new information.
If you edit a field from a summarized database row, all objects referenced by the row are edited.
~~~~~~~~~~~~~~~~~~~~~~~~~
Command |
Path |
|---|---|
Cells |
Format (worksheet menu) |
Set the appearance of worksheet cells with a variety of formatting options. Formatting applied to a database header row applies to all of the associated database sub-rows. The worksheet formatting also applies to worksheets placed on a drawing.
You can apply Fill and Pen attributes to the worksheet image on the drawing (from the Attributes palette). However, it is not recommended to apply both cell formatting and attributes to the same object, because the results can be unpredictable.
To format worksheet cells:
1 Select the cells to format.
2 Select the command.
The Format Cells dialog box opens.
On the Number tab, set the number format for the selected cells.
► Clique para exibir/ocultar parâmetros.
3 Click the Alignment tab to specify text alignment options.
► Clique para exibir/ocultar parâmetros.
4 Click the Font tab to specify the font, font size, style, and color of text in selected cells. See Formatando Textos.
5 Click the Border tab to set cell border formatting options.
Select the Line Attributes, and then use the Presets or Preview buttons to add or remove border elements.
► Clique para exibir/ocultar parâmetros.
6 Click the Patterns tab to specify fill options for the selected cells.
► Clique para exibir/ocultar parâmetros.
7 If Vectorworks Design Series is installed, click the Images tab to specify the type, size, view, and margin for images in the selected cells. For more information, see Inserting Images in Worksheet Cells.
► Clique para exibir/ocultar parâmetros.
~~~~~~~~~~~~~~~~~~~~~~~~~
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):
developer.vectorworks.net/index.php/VS:Search_Criteria#Search_Criteria_Tables
developer.vectorworks.net/index.php/VS:Function_Reference_Appendix#attrCrit
Use the Formula Syntax rules when entering worksheet functions.
In the following list of worksheet functions, the type of argument the function takes is shown in parentheses.
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. Related function: cos
Example: =acos(3/5) returns the angle for which the cosine value is 3/5
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.
Examples:
• Database header cell: =Angle returns the angle of each object in the database
• Spreadsheet cell: =Angle((t=arc)&(n='arc-1')) returns the sweep angle of the arc object named “arc-1” in the drawing
The total area of 2D objects that meet the specified criteria, based on the Area units in the Units dialog box. Related function: Perim
Examples:
• Database header cell: =Area returns the area of each object in the database
• Spreadsheet cell: =Area(t=rect) returns the combined area of all rectangle objects in the drawing
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. Related function: sin
Example: =asin(A3) returns the angle for which the sine value is given in cell A3
The bottom 2D boundary (minimum y coordinate) of the objects that meet the specified criteria. Related functions: LeftBound, RightBound, TopBound
Examples:
• Database header cell: =BotBound returns the bottom 2D boundary of each object in the database
• Spreadsheet cell: =BotBound(t=locus) returns the bottom 2D boundary of the locus that has the lowest bottom 2D boundary value in the drawing
The class name of objects that meet the specified criteria.
Examples:
• Database header cell: =Class returns the class of each object in the database
• Spreadsheet cell: =Class(sel=true) returns the class name of the selected objects in the drawing
The area (minus any holes) of one side of the components that meet the specified criteria and are in the specified class. Related functions: CompAreaByName, ComponentArea
Examples:
• Database header cell: =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
• Spreadsheet cell: =CompAreaByClass(t=wall,'Class-1') returns the combined area of the components assigned to the class “Class-1” for all walls in the drawing
The area (minus any holes) of one side of the components that meet the specified criteria and have the specified name. Related functions: CompAreaByClass, ComponentArea
Examples:
• Database header cell: =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
• Spreadsheet cell: =CompAreaByName(t=wall,'Brick Veneer') returns the combined area of the components with the name “Brick Veneer” for all walls in the drawing
The name of the components that meet the specified criteria and have the specified name. Related function: CompNameByClass
Examples:
• Database header cell: =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
• Spreadsheet cell: =CompClassByName(t=wall,'Brick Veneer') returns the class of the first component with the name “Brick Veneer” for all walls in the drawing
The Lambda value of the components that meet the specified criteria and are in the specified class. Related functions: CompLambdaByName, ComponentLambda
Examples:
• Database header cell: =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
• Spreadsheet cell: =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
The Lambda value of the components that meet the specified criteria and have the specified name. Related functions: CompLambdaByClass, ComponentLambda
Examples:
• Database header cell: =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
• Spreadsheet cell: =CompLambdaByName(t=wall,'Brick Veneer') returns the Lambda value of the first component with the name “Brick Veneer” for all walls in the drawing
The name of the components that meet the specified criteria and are in the specified class. Related function: CompClassByName
Examples:
• Database header cell: =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
• Spreadsheet cell: =CompNameByClass(t=wall,'Class-1') returns the name of the first component assigned to the class “Class-1” for all walls in the drawing
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. Related function: CompAreaByClass, CompAreaByName
Examples:
• Database header cell: =ComponentArea(2) returns the area of the second component for each wall, round wall, roof, roof face, and slab object in the database
• Spreadsheet cell: =ComponentArea(t=wall,1) returns the combined area of the first components for all walls in the drawing
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. Related functions: CompLambdaByClass, CompLambdaByName
Examples:
• Database header cell: =ComponentLambda(2) returns the Lambda value of the second component for each wall, round wall, roof, roof face, and slab object in the database
• Spreadsheet cell: =ComponentLambda(t=wall,1) returns the Lambda value of the first component for all walls in the drawing
The name of the components that meet the specified criteria and have the specified index. Index is the 1-based index identifying the component. Related function: CompNameByClass
Examples:
• Database header cell: =ComponentName(2) returns the name of the second component for each wall, round wall, roof, roof face, and slab object in the database
• Spreadsheet cell: =ComponentName(t=wall,1) returns the name of the first component for all walls in the drawing
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. Related functions: CompRValueByClass, CompRValueByName
Examples:
• Database header cell: =ComponentRValue(2) returns the R-value of the second component for each wall, round wall, roof, roof face, and slab object in the database
• Spreadsheet cell: =ComponentRValue(t=wall,1) returns the combined R-values of the first components for all walls in the drawing
The thickness of the components that meet the specified criteria and have the specified index. Index is the 1-based index identifying the component. Related functions: CompThicknessByClass, CompThicknessByName
Examples:
• Database header cell: =ComponentThickness(2) returns the thickness of the second component for each wall, round wall, roof, roof face, and slab object in the database
• Spreadsheet cell: =ComponentThickness(t=wall,1) returns the combined thickness of the first components for all walls in the drawing
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. Related functions: CompUValueByClass, CompUValueByName
Examples:
• Database header cell: =ComponentUValue(2) returns the U-value of the second component for each wall, round wall, roof, roof face, and slab object in the database
• Spreadsheet cell: =ComponentUValue(t=wall,1) returns the combined U-values of the first components for all walls in the drawing
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. Related functions: CompVolumeByClass, CompVolumeByName
Examples:
• Database header cell: =ComponentVolume(2) returns the volume of the second component for each wall, round wall, roof, roof face, and slab object in the database
• Spreadsheet cell: =ComponentVolume(t=wall,1) returns the combined volume of the first components for all walls in the drawing
The R-value of the components that meet the specified criteria and are in the specified class. Related functions: CompRValueByClass, ComponentRValue
Examples:
• Database header cell: =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
• Spreadsheet cell: =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
The R-value of the components that meet the specified criteria and have the specified name. Related functions: CompRValueByClass, ComponentRValue
Examples:
• Database header cell: =CompRValueByName(t=wall,'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
• Spreadsheet cell: =CompRValueByName(t=wall,'Brick Veneer') returns the combined R-values of the components with the name “Brick Veneer” for all walls in the drawing
The thickness of the components that meet the specified criteria and are in the specified class. Related functions: CompThicknessByName, ComponentThickness
Examples:
• Database header cell: =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
• Spreadsheet cell: =CompThicknessByClass(t=wall,'Class-1') returns the combined thickness of the components assigned to the class “Class-1” for all walls in the drawing
The thickness of the components that meet the specified criteria and have the specified name. Related functions: CompThicknessByClass, ComponentThickness
Examples:
• Database header cell: =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
• Spreadsheet cell: =CompThicknessByName(t=wall,'Brick Veneer') returns the combined thickness of the components with the name “Brick Veneer” for all walls in the drawing
The U-value of the components that meet the specified criteria and are in the specified class. Related functions: CompUValueByName, ComponentUValue
Examples:
• Database header cell: =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
• Spreadsheet cell: =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
The U-value of the components that meet the specified criteria and have the specified name. Related functions: CompUValueByClass, ComponentUValue
Examples:
• Database header cell: =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
• Spreadsheet cell: =CompUValueByName(t=wall,'Brick Veneer' returns the combined U-values of the components with the name “Brick Veneer” for all walls in the drawing
The volume of the components that meet the specified criteria and are in the specified class. Related functions: CompVolumeByName, ComponentVolume
Examples:
• Database header cell: =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
• Spreadsheet cell: =CompVolumeByClass(t=wall,'Class-1') returns the combined volume of the components assigned to the class “Class-1” for all walls in the drawing
The volume of the components that meet the specified criteria and have the specified name. Related functions: CompVolumeByClass, ComponentVolume
Examples:
• Database header cell: =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
• Spreadsheet cell: =CompVolumeByName(t=wall,'Brick Veneer') returns the combined volume of the components with the name “Brick Veneer” for all walls in the drawing
Joins several text strings into one text string.
Example: =concat(B3,', ',B4) returns the contents of cells B3 and B4 as a single string, separated by a comma and a space
The cosine of a given angle. Number is the angle in radians for which the cosine is calculated. Related function: acos
Example: =cos(deg2rad(23)) converts a 23-degree angle to its radian equivalent, and returns the cosine of the angle
The number of objects that meet the specified criteria.
Examples:
• Database header cell: =Count returns the total number of objects for each row in the database
• Spreadsheet cell: =Count(s='simple sofa') returns the total number of symbol objects named “simple sofa” in the drawing
When used with the COUNT function, the SEL (selection status) criterion counts objects that are actually non-selectable, such as the individual items within a group. The VSEL (visible selection status) criterion counts only the visibly selected items, which is the same counting method used for the Object Info palette. For example, if you select and count a group that has 11 items in it, the SEL criterion returns a value of 12 (the group, plus the 11 items). The VSEL criterion returns a value of 1 (the group only).
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. Related functions: CurtWallPnlAreaNet, CurtWallPnlAreaGross
Examples:
• Database header cell: =CurtWallFrameLength('') returns the combined length of the curtain wall frames for each curtain wall in the database
• Spreadsheet cell: =CurtWallFrameLength(t=wall, '') returns the combined length of the curtain wall frames for all curtain walls in the drawing
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. Related functions: CurtWallFrameLength, CurtWallPnlAreaNet
Examples:
• Database header cell: =CurtWallPnlAreaGross('') returns the combined gross area of the curtain wall panels for each curtain wall in the database
• Spreadsheet cell: =CurtWallPnlAreaGross(t=wall, '') returns the combined gross area of the curtain wall panels for all curtain walls in the drawing
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. Related functions: CurtWallFrameLength, CurtWallPnlAreaGross
Examples:
• Database header cell: =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
• Spreadsheet cell: =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
Converts a number from degrees to radians. Number is the value in degrees to be converted to radians.
Example: =deg2rad(47) converts the 47-degree angle measurement to its radian equivalent
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.
Example: =exp(2) returns the numeric value of e raised to the power of 2
(Vectorworks Design Series required) The value of a COBie property for an object. The criteria is a string with two elements separated by a period. The first element is the name of the COBie worksheet and the second element is the name of the column in that worksheet.
Example: =GETCOBIEPROPERTY ('space.floorname') returns the FloorName value for objects whose COBie property is Space
(Vectorworks Design Series required) The data source of the selected worksheet and column of an object. The criteria is a string with two elements separated by a period. The first element is the name of the COBie worksheet and the second element is the name of the column in that worksheet
Example: =GETCOBIESOURCE ('space.floorname') returns the FloorName data source for objects whose COBie property is Space
(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.
Example: =GETIFCPROPERTY ('ifcfurnishingelement.name') returns the Name value for IFC objects whose IFC entity is IfcFurnishingElement
(Vectorworks Architect required) The name of the space that surrounds the object that meets the specified criteria. Related function: GetSpaceNumForObj
Examples:
• Database header cell: =GetSpaceNameForObj returns the space name for each object in the database
• Spreadsheet cell: =GetSpaceNameForObj(n='chair-1') returns the space name for the object named “chair-1”
(Vectorworks Architect required) The number of the space that surrounds the object that meets the specified criteria. Related function: GetSpaceNameForObj
Examples:
• Database header cell: =GetSpaceNumForObj returns the space number for each object in the database
• Spreadsheet cell: =GetSpaceNumForObj(n='chair-1') returns the space number for the object named “chair-1”
The gradient fill of objects that meet the specified criteria.
Examples:
• Database header cell: =GradientFill returns the gradient fill for each object in the database
• Spreadsheet cell: =GradientFill(sel=true) returns the gradient fill of the selected objects in the drawing
The hatch fill of objects that meet the specified criteria.
Examples:
• Database header cell: =HatchFill returns the hatch fill for each object in the database
• Spreadsheet cell: =HatchFill(sel=true) returns the hatch fill of the selected objects in the drawing
The combined delta y (height) of objects that meet the specified criteria. Related function: Width
Examples:
• Database header cell: =Height returns the height (delta y) for each object in the database
• Spreadsheet cell: =Height(sel=true) returns the combined height (delta y) value of the selected objects in the drawing
Use value_if_true if logical_test is true, value_if_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.
Examples:
• =if(('Existing Tree'.'Condition'='Not Set'), '-', 'Existing Tree'.'Condition') If no condition value was set for the existing tree object, the value in this cell is a dash; otherwise, the value in this cell is the condition value that was set for the tree object.
• =if(('Existing Tree'.'Condition'='Not Set'); '-'; 'Existing Tree'.'Condition')
(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.
Examples:
• Database header cell: =Image returns the image for each object in the database
• Spreadsheet cell: =Image(s='cabinet') returns the image of the symbol named “Cabinet”
The image fill of objects that meet the specified criteria.
Examples:
• Database header cell: =ImageFill returns the image fill for each object in the database
• Spreadsheet cell: =ImageFill(sel=true) returns the image fill of the selected objects in the drawing
Removes any fractional part of a number. Number is the real number to be changed to an integer. Related function: round
Example: =int(B9) returns the value in cell B9 without its fractional component
The flipped state of the objects that meet the specified criteria.
Examples:
• Database header cell: =IsFlipped returns the flip state for each object in the database
• Spreadsheet cell: =IsFlipped(PON=window) returns the total number of window objects in the drawing that are flipped
The layer name of objects that meet the specified criteria.
Examples:
• Database header cell: =Layer returns the layer of each object in the database
• Spreadsheet cell: =Layer(sel=true) returns the layer name of the selected objects in the drawing
The left side 2D boundary (minimum x coordinate) of the objects that meet the specified criteria. Related functions: BotBound, TopBound, RightBound
Examples:
• Database header cell: =LeftBound returns the left 2D boundary for each object in the database
• Spreadsheet cell: =LeftBound(t=locus) returns the left 2D boundary of the leftmost locus in the drawing
The length of lines, walls, or path-based objects that meet the specified criteria.
Examples:
• Database header cell: =Length returns the length for each object in the database
• Spreadsheet cell: =Length(t=line) returns the total length of all line objects in the drawing
The line type of objects that meet the specified criteria.
Examples:
• Database header cell: =LineType returns the line type for each object in the database
• Spreadsheet cell: =LineType(sel=true) returns the line type of the selected objects in the drawing
The natural logarithm (base e). Number is the positive real number for which the logarithm is calculated. Related function: exp
Example: =ln(12) returns the natural logarithm of 12
The base 10 logarithm. Number is the positive real number for which the logarithm is calculated. Related function: ln
Example: =ln(12) returns the natural logarithm of 12
The largest number in the list of arguments. Number is 1–14 numbers for which the maximum value is to be found. Related function: min
Example: =max(C5,C7,C9) returns the largest of the numbers that are in cells C5, C7, and C9
The smallest number in the list of arguments. Number is 1–14 numbers for which the minimum value is to be found. Related function: max
Example: =min(C5,C7,C9) returns the smallest of the numbers that are in cells C5, C7, and C9
The name of objects that meet the specified criteria.
Examples:
• Database header cell: =Name returns the name for each object in the database
• Spreadsheet cell: =Name(sel=true) returns the name of the selected objects in the drawing
The texture of objects that meet the specified criteria.
Examples:
• Database header cell: =ObjectTexture returns the texture of each object in the database
• Spreadsheet cell: =ObjectTexture(sel=true) returns the texture of the selected objects in the drawing
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):
developer.vectorworks.net/index.php/VS:Function_Reference_Appendix#objects
Examples:
• Database header cell: =ObjectType returns the object type value for each object in the database
• Spreadsheet cell: =ObjectType(sel=true) returns the object type value of the selected object; for example, the object type value for a light is 81
The type name of objects that meet the specified criteria.
Examples:
• Database header cell: =ObjectTypeName returns the type name for each object in the database
• Spreadsheet cell: =ObjectTypeName(sel=true) returns the type name of the selected objects in the drawing
(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.
Examples:
• Database header cell: =ObjIncludeInEnergos returns the Energos status for each wall, round wall, roof, roof face, slab, door, and window object in the database
• Spreadsheet cell: =ObjIncludeInEnergos(t=wall) returns the Energos status for all walls in the drawing
(Vectorworks Architect required) The R-value of objects that meet the specified criteria. Related function: ObjUValue
Examples:
• Database header cell: =ObjectRValue returns the R-value for each wall, round wall, roof, roof face, slab, door, and window object in the database
• Spreadsheet cell: =ObjectRValue(n='wall-1') returns the R-value for the wall named “wall-1”
(Vectorworks Architect required) The U-value of objects that meet the specified criteria. Related function: ObjRValue
Examples:
• Database header cell: =ObjectUValue returns the U-value for each wall, round wall, roof, roof face, slab, door, and window object in the database
• Spreadsheet cell: =ObjectUValue(n='wall-1') returns the U-value for the wall named “wall-1”
The combined perimeter of objects that meet the specified criteria.
Examples:
• Database header cell: =Perim returns the perimeter for each object in the database
• Spreadsheet cell: =Perim(sel=true) returns the total perimeter of all selected objects
(Vectorworks Landmark required) The specific plant image from the plant style’s plant data pane. Indicate 1, 2, 3, or 4 to set the image from the Image Plant Form, Image Detail, Image Misc, or Custom Image, respectively. In the cell format, specify the plant by criteria (by selecting the plant with criteria such as, Field value = Plant ID = xx).
Examples:
• Database header cell: =PlantImage(2) displays the image specified for Image Detail in the Plant Data pane of the plant symbol definition
• Spreadsheet cell: =PlantImage((‘Plant’.’plant ID’=’TaxfR’), 4) displays the image specified for Custom Image in the Plant Data pane of the plant symbol definition with a plant ID of TaxfR
Converts a number from radians to degrees. Number is the value in radians to be converted to degrees.
Example: =rad2deg(0.5235987) converts the radian angle measurement to its degree equivalent
The right side 2D boundary (maximum x coordinate) of the objects that meet the specified criteria. Related functions: BotBound, TopBound, LeftBound
Examples:
• Database header cell: =RightBound returns the right 2D boundary for each object in the database
• Spreadsheet cell: =RightBound(t=rect) returns the right 2D boundary of the rightmost rectangle in the drawing
The heated area of the roof (minus the eave overhang) along the slope, combined for all objects that meet the specified criteria. Related function: RoofArea_HeatedProj
Examples:
• Database header cell: =RoofArea_Heated returns the heated area for each roof and roof face object in the database
• Spreadsheet cell: =RoofArea_Heated (st=roofface) returns the combined heated area of all roof face objects in the drawing
The heated area of the roof (minus the eave overhang) projected to the layer plane, combined for all objects that meet the specified criteria. Related function: RoofArea_Heated
Examples:
• Database header cell: =RoofArea_HeatedProj returns the heated area for each roof and roof face object in the database, as projected to the layer plane
• Spreadsheet cell: =RoofArea_HeatedProj (t=roof) returns the combined heated area of all roof objects in the drawing, as projected to the layer plane
The total area of the roof along the slope. Related function: RoofArea_TotalProj
Examples:
• Database header cell: =RoofArea_Total returns the total area for each roof and roof face object in the database
• Spreadsheet cell: =RoofArea_Total(st=roofface) returns the combined total area of all roof face objects in the drawing
The total area of the roof, projected to the layer plane. Related function: RoofArea_Total
Examples:
• Database header cell: =RoofArea_TotalProj returns the total area for each roof and roof face object in the database, as projected to the layer plane
• Spreadsheet cell: =RoofArea_Totalproj(t=roof) returns the combined total area of all roof objects in the drawing, as projected to the layer plane
(Vectorworks Design Series required) The name of the roof style.
Examples:
• Database header cell: =RoofStyleName returns the roof style name for each roof object in the database
• Spreadsheet cell: =RoofStyleName(n='roof-1') returns the roof style name for the object named “roof-1”
Rounds the specified number to the nearest whole number. Related function: int
Example: =round(2.345) returns 2
Rounds the specified number down to the specified number of decimal digits. Related functions: round, roundup
Example: =rounddown(2.345, 2) returns 2.34
Rounds the specified number up to the specified number of decimal digits. Related functions: round, rounddown
Example: =roundup(2.345, 2) returns 2.35
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):
developer.vectorworks.net/index.php/VS:GetFolderPath
See Running Scripts from Worksheets for details.
Examples:
• Database header cell: =RunScript('My Script') executes the VectorScript script named “My Script” and returns a value for each object in the database
• Spreadsheet cell: =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
The sine of a given angle. Number is the angle in radians for which the sine is calculated. Related function: asin
Example: =sin(deg2rad(32)) converts a 32-degree angle to its radian equivalent, and returns the sine of the angle
The sketch style of objects that meet the specified criteria.
Examples:
• Database header cell: =SketchStyle returns the sketch style for each object in the database
• Spreadsheet cell: =SketchStyle(sel=true) returns the sketch style of the selected objects in the drawing
(Vectorworks Design Series required) The name of the slab style.
Example:
• Database header cell: =SlabStyleName returns the name of the slab style for each slab object in the database
• Spreadsheet cell: =SlabStyleName(n='slab-1') returns the name of the slab style for the object named “slab-1”
(Vectorworks Designer required) The combined thickness of slab objects (floors and roof faces) that meet the specified criteria.
Examples:
• Database header cell: =SlabThickness returns the thickness for each object in the database
• Spreadsheet cell: =SlabThickness(PON=slab) returns the combined thickness of all slab objects in the drawing
A positive square root. Number is the number for which the square root is calculated.
Example: =sqrt(D27) returns the square root of the number in cell D27
The story name of objects that meet the specified criteria.
Examples:
• Database header cell: =Story returns the story name for each object in the database
• Spreadsheet cell: =Story(sel=true) returns the story name of the selected objects in the drawing
Splits a single string into an array of strings using a delimiter, and outputs each string at the specified index.
Example: =SUBSTRING(('kitchen;bedroom;bathroom;basement', ';', 2) returns “bedroom,” which is the second substring in the specified string
The sum of all numbers in the list of arguments. Number is 1–14 numbers for which the sum is calculated. Related function: Average
Example: =sum(A2,A10..A12) returns the sum of the numbers contained in cells A2, A10, A11, and A12
The total surface area of all objects that meet the criteria, based on the Area units in the Units dialog box.
Examples:
• Database header cell: =SurfaceArea returns the surface area for each object in the database
• Spreadsheet cell: =SurfaceArea(st=sphere) returns the total surface area of all sphere objects in the drawing
The symbol name of the symbol instances that meet the specified criteria.
Examples:
• Database header cell: =SymbolName returns the name for each symbol instance in the database
• Spreadsheet cell: =SymbolName(sel=true) returns the symbol name of the selected symbol instances in the drawing
The tangent of the given angle. Number is the angle in radians for which the tangent is calculated. Related function: atan
Example: =tan(deg2rad(32)) converts a 32-degree angle to its radian equivalent, and returns the tangent of the angle
The top 2D boundary (maximum y coordinate) of the objects that meet the specified criteria. Related functions: BotBound, LeftBound, RightBound
Examples:
• Database header cell: =TopBound returns the top 2D boundary for each object in the database
• Spreadsheet cell: =TopBound(sel=true) returns the top 2D boundary of the topmost selected object
Converts a text string that represents a number to a number.
Example: =value('2e3') returns the numeric value of 2 times 10 raised to the power of 3
The total volume of all objects that meet the criteria, based on the Volume units in the Units dialog box.
Examples:
• Database header cell: =Volume returns the volume for each object in the database
• Spreadsheet cell: =Volume(t=xtrd) returns the total volume of all extrude objects in the drawing
The average of the 2D gross surface area of the interior and exterior face of one wall (ignoring holes in the wall), for walls that meet the specified criteria. Related functions: WallArea_Net, ComponentArea, CompAreaByClass, CompAreaByName
Examples:
• Database header cell: =WallArea_Gross returns the average of the gross area of the interior and exterior face of the wall, for each wall in the database; the gross area ignores holes in the wall
• Spreadsheet cell: =WallArea_Gross(t=wall) returns the average of the gross area of the interior and exterior face of the wall, combined for all walls in the drawing; the gross area ignores holes in the wall
The average of the 2D net surface area of the interior and exterior face of one wall (adjusted for holes in the wall), for walls that meet the specified criteria. Related functions: WallArea_Gross, ComponentArea, CompAreaByClass, CompAreaByName
Examples:
• Database header cell: =WallArea_Net returns the average of the net area of the interior and exterior face of the wall, for each wall in the database; the net area is adjusted for holes in the wall
• Spreadsheet cell: =WallArea_Net(t=wall) returns the average of the net area of the interior and exterior face of the wall, combined for all walls in the drawing; the net area is adjusted for holes in the wall
The average height of a wall, including wall peaks and different starting and ending heights.
Examples:
• Database header cell: =WallAverageHeight returns the average height for each wall object in the database
• Spreadsheet cell: =WallAverageHeight((t=wall)&(sel=true)) returns the average height of all walls that are selected in the drawing
(Vectorworks Design Series required) The name of the wall style.
Example:
• Database header cell: =WallStyleName returns the name of the wall style for each wall object in the database
• Spreadsheet cell: =WallStyleName(n='wall-1') returns the name of the wall style for the object named “wall-1”
The combined thickness of wall objects that meet the specified criteria.
Examples:
• Database header cell: =WallThickness returns the thickness for each wall object in the database
• Spreadsheet cell: =WallThickness(t=wall) returns the combined thickness of all walls in the drawing
The combined delta x (width) of objects that meet the specified criteria. Related function: Height
Examples:
• Database header cell: =Width returns the width (delta x) for each object in the database
• Spreadsheet cell: =Width(sel=true) returns the combined width (delta x value) of the selected object
The x coordinate of the center point of an object that meets the specified criteria. Related functions: YCenter, ZCenter, XCoordinate
Examples:
• Database header cell: =XCenter returns the x coordinate value of the center of the 2D boundary for each object in the database
• Spreadsheet cell: =XCenter(sel=true) returns the x coordinate value of the center of the 2D boundary of the selected object
The x coordinate of the insertion point for symbols, point plug-in objects, and loci. The returned value is relative to the user origin. Related functions: YCoordinate, ZCoordinate, XCenter
Example:
• Database header cell: =XCoordinate returns the x coordinate value for each object in the database
The y coordinate of the center point of an object that meets the specified criteria. Related functions: XCenter, ZCenter, YCoordinate
Examples:
• Database header cell: =YCenter returns the y coordinate value of the center of the 2D boundary for each object in the database
• Spreadsheet cell: =YCenter(sel=true) returns the y coordinate value of the center of the 2D boundary of the selected object
The y coordinate of the insertion point for symbols, point plug-in objects, and loci. The returned value is relative to the user origin. Related functions: XCoordinate, ZCoordinate, YCenter
Example:
• Database header cell: =YCoordinate returns the y coordinate value for each object in the database
The z coordinate of the center point of an object that meets the specified criteria. Related functions: XCenter, YCenter, ZCoordinate
Examples:
• Database header cell: =ZCenter returns the z coordinate value of the center of the 2D boundary for each object in the database
• Spreadsheet cell: =ZCenter(sel=true) returns the z coordinate value of the center of the 2D boundary of the selected object
The z coordinate of the insertion point for symbols, point plug-in objects, and loci. The returned value is relative to the user origin. Related functions: XCoordinate, YCoordinate, ZCenter
Example:
• Database header cell: =ZCoordinate returns the z coordinate value for each object in the database
Data from a wide variety of worksheet formats can be imported into a file, including worksheet data from other programs and worksheets from other Vectorworks files.
Command |
Path |
|---|---|
Import Worksheet |
File (worksheet menu) |
During import, the spreadsheet data is imported, but the formulas (logic) are not.
To import worksheet data into a Vectorworks file:
1 Select the command.
2 Select the worksheet file to be imported. The worksheet must be in one of the following formats:
• Tab delimited text (.txt)
• Comma delimited text (.csv)
• DIF (.dif)
• SYLK (.slk)
3 Click Open. The worksheet is imported as a new worksheet in the Vectorworks file.
To import a Vectorworks worksheet from another Vectorworks file:
1 From the Resource Manager, right-click on the resource, and select Import.
2 Alternatively, drag the worksheet resource into the desired Vectorworks file to insert it as a drawing object; see Placing a Worksheet on the Drawing.
The selected worksheet is imported into the current file.
The following procedure is an example of how to import a table from Microsoft Word into a Vectorworks worksheet.
To import a Word table into a worksheet:
1 In Word, select the entire table to be imported.
2 Select the Table Tools > Layout > Convert to Text.
The Convert Table to Text dialog box opens.
3 In the dialog box, click Tabs for the separation identifier.
4 Click OK.
5 Save the table.
If the file consists of only the table, select File > Save As. In the Save As dialog box that opens, select Text Only from the Save as type list.
If the table is part of a larger file, copy the table to the Clipboard. Select File > New, and paste the table text into a new document. Save the file as a text file.
6 Return to the Vectorworks file and import the table as described in Importing Worksheet Data from Another Program.
Command |
Path |
|---|---|
Export Worksheet |
File (worksheet menu) |
Vectorworks worksheet files can be exported and read by spreadsheet programs, such as Excel, as well as by some word processing programs. Because many of these programs have different format requirements, several export formats are available. These include comma delimited, tab delimited, merge, DIF, and SYLK. Using the tab delimited format, for example, creates a file that can be opened as a table in Microsoft Word.
To export a worksheet from a Vectorworks file:
1 Open the worksheet to export.
2 Select the command.
3 The Export Worksheet dialog box opens.
Select the format for the export, and whether to export all rows or only the selected rows.
4 Specify the name and location of the exported worksheet.
Command |
Path |
|---|---|
Worksheet On Drawing |
File (worksheet menu) |
To include a worksheet as an object on the drawing:
1 The worksheet must be a part of the current file. If the worksheet is part of another file, first import it into the current file. See Importing Worksheets from Another Vectorworks File.
2 Select the command. Alternatively, do one of the following from the Resource Manager:
• Right-click on the resource, and select Worksheet On Drawing.
• Double-click on the resource.
• Drag the resource to the desired location in the drawing file.
The worksheet is now included in the drawing as a graphic object. If the worksheet is currently open, the contents of the worksheet in the drawing are replaced with an X.
3 With the worksheet window open, use the Format Cells command to format individual rows, columns, and cells of the worksheet. The format is retained when the worksheet is included on the drawing. Alternatively, with the worksheet window closed, select the worksheet object on the drawing, and use the Attributes palette to modify the fill, pen, and line thickness attributes for the entire object.
To edit a worksheet included as a drawing object:
1 From the Resource Manager, right-click on the resource, and select Open. Alternatively, double-click the worksheet object in the drawing.
2 The worksheet is opened and available for editing. The contents of the worksheet in the drawing are replaced with an X. Close the worksheet to display the worksheet contents in the drawing.
3 To display the database header rows in the drawing object, click Show Database Headers from the Object Info palette. This does not affect the visibility of the database headers in the worksheet window.
There are multiple ways to scale a worksheet within the drawing area; all scaling operations scale the worksheet symmetrically and preserve the aspect ratio.
From the Object Info palette for a selected worksheet, enter a Scale Factor; for example, enter 2 to double or 0.5 to halve the scale.
Alternatively, select Modify > Scale Objects and perform one of the symmetric operations (see Escalar Objetos).
A selected worksheet can also be scaled less precisely by dragging a reshape handle with the Selection tool.
When a selected worksheet has been scaled, that is reflected in the object’s name at the top of the Object Info palette: “Worksheet Data - Scaled.” Scaled worksheets will revert to their unscaled size if the file is saved to a Vectorworks version prior to 2017.
In addition to scaling worksheets in the drawing area, you can scale them to fit to printed pages, as described in Worksheet Menu.
This simple tutorial explains how to create a customized schedule that links wall objects in a drawing to a database worksheet. The schedule will display data for wall areas, wall thicknesses, labor cost, material cost, taxes, and total cost per wall style.
The WorksheetTutorial.vwx file contains the data required to perform the tutorial steps. Though wall styles are a Vectorworks Design Series feature, any Vectorworks license can use the wall styles that already exist in the tutorial file. Download the file here (internet access required) and open it in Vectorworks to begin.
There are three ways to create a schedule using worksheets. This tutorial uses the first option below.
• Start with a blank worksheet, and create the schedule from scratch. See Creating a Blank Worksheet.
• Create a schedule using the Create Report dialog box, where you can specify the criteria for the database rows and the columns of data to display. See Creating Reports.
• Start with a preformatted report and customize it to achieve your goals. See Using Preformatted Reports.
To create a blank worksheet:
1 From the Resource Manager, click New Resource, select Worksheet, and then click Create. The Create Worksheet dialog box opens.
2 Enter “Wall Area and Costs” as the name for the new worksheet. You will add more rows and columns later.
A blank worksheet window opens.
Next, create a database of the objects in the drawing from which to extract the wall area data. You can combine multiple criteria to collect the desired subset of objects.
For this tutorial, a single database of wall objects will be created and limited to a specified set of wall styles.
An alternative would be to create one database per wall style and include multiple databases in the same worksheet. However, for very large databases, it is recommended to create separate worksheets rather than include multiple databases into a single worksheet.
To set the database criteria:
1 Right-click on the header box for row 3, and select Database from the context menu. The Criteria dialog box opens.
2 Set the three criteria options as follows:
• Type
• is
• Wall
3 Click More Choices, and set the next three criteria as follows:
• Wall Style
• is
• Aspen Interior Walls
4 Click More Choices, and set the next three criteria as follows:
• Wall Style
• is
• Ext-CIP Conc 36”-Footing
To include all wall styles in the schedule, do not enter criteria for walls and wall styles; instead, use the following criteria: Record, Wall Data, is present.
5 Click OK to set the criteria. The database of walls for the specified set of wall styles is created. The database header (row 3) now has a diamond next to the row number. Beneath row 3 are sub-rows for each object in the database (3.1 through 3.45).
For this tutorial, you need to expand the worksheet. Since no data has been assigned to the columns yet, it does not matter where the columns are added.
Use one of the following methods to add three columns to the worksheet, for a total of eight.
• Select Insert > Columns. An empty column is added to the left of the current column.
• Right-click the column header where you want to add a column, and select Insert Columns from the context menu.
• Position the cursor at the bottom right corner of the worksheet to activate a special resize cursor; drag to add columns to the right side of the worksheet.
Next, add database functions to the worksheet to extract the desired data from the database. Select a function for each cell in the database header row.
For this tutorial, the following data will be extracted:
• Wall Style Name
• Gross Wall Area
• Net Wall Area
• Wall Thickness
To extract the data associated with the walls in the database:
1 From each of the following cells, click the button on the right side of the cell, select Functions, and then select the function shown to extract data for each item in the database.
• In A3 select WallStyleName
• In B3 select WallArea_Gross
• In C3 select WallArea_Net
• In D3 select WallThickness
Alternatively, use the worksheet menu command Insert > Function to insert functions.
2 By default, numerical data is unformatted and must be formatted to display appropriate units. Formatting applied to a database header cell is automatically applied to all sub-rows for that column.
Right-click each of the following cells, and select Format Cells from the context menu. The Format Cells dialog box opens. On the Number tab, select the format option shown.
• For B3 select Dimension Area
• For C3 select Dimension Area
• For D3 select Dimension
Alternatively, use the worksheet menu command Format > Cells to format cells.
3 Add labels for columns A through D by typing names in the cells in row 2.
• In A2 enter Wall Style Name
• In B2 enter Wall Area (Gross)
• In C2 enter Wall Area (Net)
• In D2 enter Wall Thickness
Various types of data can be extracted from Vectorworks objects into a worksheet database, as described in the following topics.
• Displaying Object Properties in a Database Column
• Displaying Record Information in a Database Column
• Entering Formulas in Worksheet Cells
Instead of listing each wall individually in the database, you can summarize all walls with the same wall style, automatically calculating the total quantities for each, and shortening the list.
To summarize the wall styles:
1 Click the button in A3, which is the database header cell for wall styles.
2 From the dialog box that opens, click Summarize Items. The number of sub-rows is reduced to only two (one row per wall style).
3 The numerical values in columns B and C are now dashes, because the area is different for each wall. To show the area values for all walls combined, click the button in B3, click Sum Values. Repeat for cell C3.
Next, calculate costs using worksheet operations and formulas.
For this tutorial, the following data will be calculated:
• Labor cost per wall style
• Material cost per wall style
• Taxes
• Total cost
To calculate costs with formulas:
1 Add labels for columns E through H by typing names in the cells in row 2.
• In E2 enter Labor Cost
• In F2 enter Material Cost
• In G2 enter Taxes
• In H2 enter Total Cost
2 Click the following cells and enter the formula shown to determine the cost sums. Be sure to include the equal sign (=) before each item. When each formula is complete, click the green check mark or press Enter to validate the entry.
• In E3 enter =C3*15.5 (multiply the value in C3 by 15.5, the estimated rate of labor cost per area unit)
• In F3 enter =C3*9.2 (multiply the value in C3 by 9.2, the estimated material cost per area unit)
• In G3 enter =F3*.08 (multiply the value in F3 by 0.08, the estimated tax rate)
• In H3 enter =E3+F3+G3 (calculate the total cost of labor, material, and taxes)
Instead of entering the tax rate directly into the calculation, an alternative and more flexible approach is to set the tax rate in a separate spreadsheet cell and simply reference it in the calculation.
3 The numerical values in columns E through H are now dashes, because the cost is different for each wall. To show the cost values for all walls combined, click the button in E3, click Sum Values. Repeat for cells F3, G3, and H3.
4 Format all of the cost data the same way. Select the four cost header cells (E3 through H3), and then right-click and select Format Cells from the context menu. The Format Cells dialog box opens. On the Number tab, select the options shown.
• Select Decimal
• In Dec. Places, enter 2
• Select Use Commas
• In Leader, enter $ (dollar sign)
Next, set up totals at the bottom of the columns as appropriate. The cells in the database header row (in this case, row 3) display sums for all of the database columns. Reference these database header row cells in spreadsheet cells to set up the totals.
To set up the totals:
1 Click the following cells and enter the formula shown to show sums from the database header row. Be sure to include the equal sign (=) before each item.
• In B4 enter =B3
• In C4 enter =C3
• In E4 enter =E3
• In F4 enter =F3
• In G4 enter =G3
• In H4 enter =H3
2 Select cells B4 and C4, right-click, and select Format Cells from the context menu. On the Number tab, select Dimension Area.
3 Select cells E4 through H4, right-click, and select Format Cells from the context menu. On the Number tab, select the options shown.
• Select Decimal
• In Dec. Places, enter 2
• Select Use Commas
• In Leader, enter $ (dollar sign)
4 Click cell A1 and enter Wall Areas and Costs as the schedule title.
5 Select row 2, right-click, and select Insert Rows from the context menu to add an empty row between the schedule title and the column labels.
6 Select the empty rows at the bottom of the worksheet (6 through 11), right-click, and select Delete Rows from the context menu.
7 Select View > Grid Lines to hide the grid lines in the table.
Finally, select cells and use the Format Cells command to format the worksheet. You can change the font, font style, size, and color to format the text. Add cell borders, and change cell background color, as desired. Change the text alignment in cells, and resize rows and columns, if necessary. Select File > Worksheet On Drawing to place the worksheet in the drawing area.
See Formatting Worksheet Cells for details.
symbol.
