obviouslytom Posted July 21, 2014 Share Posted July 21, 2014 First time posting in this forum. I have been coming here for a while and have found many useful things within the forum but can't seem to find what I am currently looking for. What I want to know is how, after making a specific symbol, have Vectorworks tell me how many I have in a given layout. This past Friday I was working on an electrical drawing (I work in the trade show industry) that has specific electrical power requirements drawn out. An example would be 120v 5amp and 208v 3ph 20amp and so forth. The drawing that I did on Friday has at least 100 or more different electrical drops that I had to go and count manually to make a legend for. Any help with this would be greatly appreciated and would make my job easier and faster considering that over the next 2 months, I have about 50 layouts to do, along with all sorts of other service drawings and design layouts. Quote Link to comment
Vectorworks, Inc Employee PVA - Admin Posted July 21, 2014 Vectorworks, Inc Employee Share Posted July 21, 2014 Should be a simple " =COUNT " used in a database header. I believe the basics are covered here, specifically in the "Criteria" video which shows how to isolate specific attributes of objects, like their symbol name: Quote Link to comment
mike m oz Posted July 21, 2014 Share Posted July 21, 2014 Tools / Report / Create Report Set the dialog box as shown in the attached image. You can find more information on reports in Help Quote Link to comment
obviouslytom Posted July 21, 2014 Author Share Posted July 21, 2014 Mike_m_oz, Thanks for that, it worked the easiest. In a way, I feel somewhat stupid for not realizing that. Quote Link to comment
mike m oz Posted July 22, 2014 Share Posted July 22, 2014 To ensure you don't double count make sure you add Criteria to the Database Header Row. eg. restricting the count to a specific Design Layer. You can also use Class Criteria to split the symbol counting into sensible groups. Make sure you look at the movie suggested by Jim and explore Help. Be careful with Legends as these can lead to additional symbols in the count. Make those symbols Groups or use a Viewport for the Legend and exclude Viewports from the count. Quote Link to comment
sle7en7 Posted July 25, 2014 Share Posted July 25, 2014 I have a question as well; somewhat in the same ballpark. Say, I have a worksheet with a single database header. Can I limit the columns that the Database Sub Rows goes? Meaning, I want to create other columns which have editable rows in them for comparison purposes which I will manually punch in the numbers. Thank you for the support. Quote Link to comment
Pat Stanford Posted July 26, 2014 Share Posted July 26, 2014 Can I limit the columns that the Database Sub Rows goes? Meaning, I want to create other columns which have editable rows in them for comparison purposes which I will manually punch in the numbers. The answer is no, but there is a work around. A Database section of a worksheet must contain all record fields about the object(s) that are included in that specific subrow, so you can't just mark some columns as being editable fields. The workaround is that the columns in the database section don't have to be from the same record. For editable fields, create a custom Record Format and attach that Record to the objects. Set the criteria for the column to show the fields from the custom Record. You can then enter the data either manually into the cells in the database or using the Data pane of the Object Info Pallette (OIP). Quote Link to comment
sle7en7 Posted July 28, 2014 Share Posted July 28, 2014 Thank you Pat, I understand. I'll let you know how that goes. Quote Link to comment
sle7en7 Posted July 28, 2014 Share Posted July 28, 2014 That worked fine PAT, thank you. Quote Link to comment
sle7en7 Posted July 28, 2014 Share Posted July 28, 2014 (edited) ok PAT (or anybody), I have another question/problem. I'm attaching the worksheet I'm working on as well. I have done what you have told me I suppose; For editable fields, create a custom Record Format and attach that Record to the objects. Set the criteria for the column to show the fields from the custom Record. You can then enter the data either manually into the cells in the database or using the Data pane of the Object Info Pallette (OIP) This time, the custom record format I have created gets multiplied by the number of symbol instances in the file and result in a wrong "DIFFERENCE" number. I have tried couple of tricks ("VALUE" function or storing the record format as text information) but couldn't find a way around. You think there is a way around this? Thank you once again. Edited July 28, 2014 by sle7en7 Quote Link to comment
Pat Stanford Posted July 29, 2014 Share Posted July 29, 2014 Short answer for now. Drag another SUM tile to the Quantity column. This will actual "UNSUM" the values and give you the value for just one instance. I am trying to think of a better way to store the "inventory" quantities so that you can still access them other than putting them into the record for each object. If I were to set this up from scratch, I would probably create a different symbol for each height cabinet and store the 2H/3H stuff in a record attached to the symbol definition. That way you don't have to manually put the data into each instance. Quote Link to comment
sle7en7 Posted August 1, 2014 Share Posted August 1, 2014 Thanks again for the response, Pat. That's what I will do next time probably. Quote Link to comment
cberg Posted August 1, 2014 Share Posted August 1, 2014 This is a similar but related question. If I have an object like a parking space, where I need to summarize a field, like the number of spaces, how do I collapse or summarize the information. For example, in the attached file, I don't need to list all the parking space objects individually. I need a tally of total spaces, preferably by layer. I'd like to be able to summarize by a field. See attached. Quote Link to comment
Pat Stanford Posted August 1, 2014 Share Posted August 1, 2014 In your smaller worksheet all you need to do is add a second column with a formal of =L. This will give you a column that shows the layer name of each object. With the database headers showing, drag the SUM tile to the column that has the Layer Name in it. Quote Link to comment
cberg Posted August 1, 2014 Share Posted August 1, 2014 I see what you have to do. Set some additional criteria, and summarize by that criteria. Like the parking width. This will work if all the parking spaces have the same field values. It's a little bit of a cludge, but I guess it will do. Quote Link to comment
cberg Posted August 1, 2014 Share Posted August 1, 2014 That's even better, thank you! I never knew about the =L trick. Is there a list of format commands for worksheets? Quote Link to comment
michaelk Posted August 1, 2014 Share Posted August 1, 2014 There is a list of them in Help. Search for "Retrieving Object Attributes in a Worksheet" hth mk Quote Link to comment
Recommended Posts
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.