In this session, we worked with Record Formats, including how to create a new Record Format resource, how to create a worksheet that reports the records, and how to create a schedule from the reported records, as well as how to modify a data tag to work with our Record Format resource.Continue reading
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.
1803 – Worksheets
- Beginner Topics
- Intermediate Topics
- Advanced Topics
In this session, we covered what goes into counting a site’s permeable and impermeable areas.
This is the first session for this Special Interest Group. In this session we looked at creating symbols, creating Record Formats, and reporting. In particular we looked at the problem of creating stage platforms, placing them in the design and reporting the number of stages needed.
Vectorworks has the tools and commands to quickly create a concept model. But we want mode than just a few elevations, we need to know if the main site can be subdivided, how large the project can be, and how much it might cost to construct.
In this manual we will be looking at ways to create and visualise the concept. We will start by creating the site, then the site model, create the adjoining buildings, create the design, and set up solar studies.
Creating A Budget Report – We have created a lot of valuable information, and while it might not seem like it, we have nearly enough to calculate the cost of our project.worksheets and Vectorworks are extremely powerful, allowing us to carry out investigations of areas, but also allowing us to use mathematical functions that would multiplying the area of our proposed house against an expected cost per square metre.
Creating Proposed Areas Report – Now that we have the report started for the existing areas, we can start to look at creating a report for our proposed site and proposed building.
Creating Existing Areas Report – When you have the accurate areas for the existing house and site, we can use Vectorworks to calculate the percentage cover, the percentage of the site covered by buildings.
- 00:30 Worksheet basics
- 00:51 plant schedules are worksheets
- 06:43 placing a worksheet from the library
- 08:30 locating a plant in the Resource Browser
- 09:10 placing plants
- 09:30 plant settings
- 09:35 edit plot definition (data)
- 11:37 connection of plants to the plant database
- 12:00 Vectorworks plants database
- 21:03 editing the plant schedule (how does it find trees )
- 38:20 editing the plant report to show accurate heights and spreads
- 46:19 placing a landscape area
Reporting – This is an extremely useful part of the Building Information Modeling. When your objects are created using the techniques we have described, they can be reported in a worksheet. The information in your report depends on the information you have attached to your objects.
This session looked at the challenges (bugs) encountered when counting plants in a worksheet, especially in regard of their height, spread and quantity. It also covered in detail how to create your own report (worksheet, schedule), how to edit an existing report (with its many record formats), showed the quickest way to update plant definitions and plant data and how to add additional information. It also discussed the difference between the height of a plant entered in Insertion Options vs. Plant Data. Furthermore it looked at the options of representing plants (2D and 3D) at various stages of their growth (e.g. when planted, 5 yrs, 10 yrs). To finish, Jonathan demonstrated how you can use a smartphone or tablet and Vectorworks Cloud Services to show off your projects. In the process topics also covered were: Invert Selection, Importing symbols from another file, On Plant List.
This session looked at the best tool to use when creating planted or landscaped areas: Plant tool, Landscape Area tool, Hardscape tool, or Texture Bed tool and how to edit them (e.g. content, plant types, spacing, as well as visually). Both the Plant and the Landscape Area tool enable plants to be placed at the desired elevation on a site model (and displayed as 3D objects) and the Landscape Area tool (Texture Bed setting) even follows the terrain if desired. Covered were the pros and cons of Landscape tool vs. Hardscape tool in regard of reporting & pricing (worksheets) as well as visual representation and their different influences (or not) on a site model. It demonstrated how Hardscapes are a very quick way to modify a site model and instantly produce a 2D and 3D representation. Texture beds are really only for 3D graphic representations on a site model. In the process also covered were: Visibility tool, Gradients, Attribute Mapping, Reshape tool with Hardscapes, Pad Modifier, Grade Limits, Reports.
When you use the standard Vectorworks Plant counting schedule, it does not always count the spacing, height and spread accurately. The problem is that Vectorworks multiplies the values of these by the number of plants or the number of plant groups that you have in the file. The solution that I use is to create my own record format that uses text rather than numeric values for reporting these. In this movie I show you the difference between the standard Vectorworks report and my edited report that shows the accurate spread, height and spacing. This movie will not show you how to create the record format.
This was a session that started to look at reporting materials. Starting with simple walls, we looked at how to report the areas and materials from them. Then we created more complex walls and looked at how to report the different materials from the walls.
In the last podcast I looked at the power of record formats. In this movie I will be looking at how to take a record format and create a report from it. This movie makes the technique look very easy, and even if you want to create more complex reports, the same technique applies.
There is almost no end the the uses for Record Formats. Many Vectorworks objects have their own Records attached, but if that is not enough, you can create your own Records and attach it to the objects you want.
Worksheets allow you count and schedule items in Vectorworks. For example you can count all the trees in a site, schedule all the doors on a particular floor of a project, count up and schedule even find the weight of a bracket in a 3D model. Worksheets are an underused area of VectorWorks and this workshop should open your eyes about what you are able to do with them.
I was teaching some of my clients the other day and I mentioned being able to count the number of symbols in the plan. We were looking at the interior design of commercial projects. They were not aware that you could count all the symbols easily with worksheets. Counting the symbol is only the start though, there is so much more you can do. Continue reading
This was the first session for the landmark special interest group. The users decided that they would like to learn more about worksheets, especially how to combine a worksheet that would count the planting, hardscape, and landscaped areas. If you do create this kind of worksheet it’s possible to save this in your library to make it available in every project.