Creating Worksheets

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 Schedules and Creating 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.

Creating a Blank Worksheet

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.

Click to show/hide the parameters.

Parameter	Description
Name	Enter a worksheet name. To rename the worksheet later on, from the Resource Manager, right-click (Windows) or Ctrl-click (Mac) on the resource, and select Rename from the context menu.
Rows / Columns	Enter the number of rows and columns for the worksheet; the number of rows and columns can be modified later

2. Specify the basic worksheet parameters and click OK.

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 Entering Data in Spreadsheet Cells.

●    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 Entering Data in Database Rows.

●    To add images to either spreadsheet or database rows, see Inserting Images in Worksheets (Vectorworks Design Series required).

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

Creating Reports

Using Worksheets

Was this page helpful?

vectorworks.net