Jump to content
  • 0
SarahISO

Create report with quantity

Question

Hello, 

 

I am creating a report to list all the electrical symbols that I have in my document, sockets, switches, etc. I want to create a column on my report which lists the quantity of items, I can summarise the items but this does not create a quantity. Is there a way to do this?

 

Thanks. 

sarah 

Share this post


Link to post

6 answers to this question

Recommended Posts

  • 0

Use the =COUNT formula in the database header for the column you want to add the quantity. Then you have to make sure that the box for sum items is checked. Also, be sure you are summarizing the column for symbol name. This will lump all of the similar objects together and add together their quantities. 

 

Hope this helps.

  • Like 2

Share this post


Link to post
  • 0

What is the best way to add a column for additional notes? I can add a notes section to the record itself but is there a way to add this directly to the report so that I can manually type in additional information after the report is created?

 

Thanks again, 

Sarah 

Share this post


Link to post
  • 0

Hi @SarahISO. I'm not sure what the nature of the symbols or plug-in objects are that you are reporting in the worksheet. Are they plug-in objects with inherent parameters/records already attached? Or are they basic symbols?

 

The reason is that in order to add a column for notes, some sort of additional record format is needed beyond a basic symbol. If you are using basic symbols, you could create a very basic record to attach to them, with the field "Notes". Then in your worksheet you could add a column that reports the "notes" record field attached to the objects and edit it there.

 

If these are plug-in objects, there may already be a notes or comment field to which to query and apply this information.

Share this post


Link to post
  • 0

Hi Eric, 

 

Apologies for not getting back to you sooner, got distracted with another project!

They are mainly basic symbols - i've found a way around adding notes now but I have another query...

 

Is there a way to calculate (and display in a worksheet) the total area of a wall if it has a 'wall recess'? 

 

See attachments - 1 I have managed to calculate the area of the wall and display in a worksheet as desired 6m2, however (see attachment 2) when I cut the wall recess out of the wall the number changes and becomes incorrect 3m2. Do you know of a way around this? 

 

I am trying to create an automatic scope of works which can be exported, showing all the doors/windows, sockets/switches, pipework, walls/floor/ceiling finishes - these with areas (using AREA for ceiling/floor and WallArea_Net for walls). I've managed to create this but am just falling down on the walls with recesses which is a big part of our projects. 

 

Thanks for all your help. 

 

Best Wishes, 

Sarah 

Attachment 1.pngAttachment 2.png

Edited by SarahISO

Share this post


Link to post

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×
×
  • Create New...