Worksheets

 

What Is a Worksheet?

Worksheets are like simple spreadsheets. Worksheets allow you to calculate and report information from your Vectorworks files. This is a powerful technique. It has been available in Vectorworks for many years.

You can use worksheets to find objects, report them, and do calculations on the objects that have been found.

How Do Worksheets Work?

Worksheets are set up to look for specific information. It uses criteria to define what the search looks for. When Vectorworks finds that information it fills in the worksheet.

001

When you are setting up the worksheets, it is important to plan your report. There are so many options—you have to have some idea of how you are going to find the information in your file. For example, if you are creating a report to find the site area, you could look for a property line object. If there is more than one property line, then you might look for one on a particular class. You could name the object and then use that name to find it. As you can see, even with a simple object, there are so many choices.  It is best to think about all of this before you get started.

What Types of Worksheets Are There?

We can classify the worksheets into a few different groups depending on the nature of the worksheets:

  • Count/select objects (typically symbols) throughout the file. They do not need to have a record attached or be on the same Class or Layer. We can choose to count symbols on a specific layer or assigned to a specific class.
  • Do mathematical operations with the parameters of drawn objects: areas, perimeters, volumes, etc. Name the objects (Object Info palette) and find their properties and their combinations.
  • Create reports using symbols with records and list the field values from the symbols in the report.
There is some great protected information here that is only available to paying subscribers. You must be an active paying subscriber to see it, but you can  Subscribe here.

Leave a Reply