Using Worksheets

Worksheets can obtain data from the drawing based on specified criteria, and then list the data and allow calculations to be performed on the data.

Worksheet_example.png 

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. The database header row is marked with a diamond shape next to the row number. Set selection criteria for this row, and a sub-row is created for each object that meets the criteria. In this example, the 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.

Rows are numbered sequentially starting with 1, and columns are labeled alphabetically starting with A. Database sub-rows are numbered with the database header row’s number, followed by a decimal and sequential numbers (header row 2 has sub-rows 2.1, 2.2, 2.3, and so on). The cell’s column letter and row number indicate the spreadsheet cell address, as in A4 or D2 (database sub-rows display a blank 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 (Windows) or Ctrl-click (Mac) on the resource, and select Open from the context menu.

Worksheets00003.png 

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 Resource Manager, right-click (Windows) or Ctrl-click (Mac) on the resource, and select Worksheet on Drawing from the context menu. When the worksheet is open, the worksheet on the drawing displays as an X. Double-click the worksheet from the drawing to open it. See Placing a Worksheet on the Drawing.

WorksheetOnDrawing.png 

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

Editing Worksheets

Worksheet Commands

Formatting Worksheet Cells

Was this page helpful?

vectorworks.net