CharlesD Posted September 20, 2022 Share Posted September 20, 2022 I never really dug into reports before. I am looking for the right way of getting a quantity of of devices and adapters I have in my schematic. I can't seem to figure out what report I should be using. It looks like the Parts report makes most sense, however I see a worksheet row for every device or adapter on the drawing. Which report should I be using? Thanks! Quote Link to comment
Vectorworks, Inc Employee Nikolay Zhelyazkov Posted September 20, 2022 Vectorworks, Inc Employee Share Posted September 20, 2022 Hello @CharlesD, You can use the worksheet Count function in a non database cell with criteria to get the count of objects matching a criteria. The formula below will give you the count of all devices and adapters in the current document. You can edit the criteria to add more details in it: =COUNT((PON='Device') OR (PON='CC Adaptor')) Let me know if this helps. Best Regards, Nikolay Zhelyazkov Quote Link to comment
Vectorworks, Inc Employee Conrad Preen Posted September 20, 2022 Vectorworks, Inc Employee Share Posted September 20, 2022 Hi Charles, In the Parts Report you can sum the Qty column and summarize by the Item column which will give you quantities for each distinct Make+Model. Explore! Conrad Quote Link to comment
CharlesD Posted September 22, 2022 Author Share Posted September 22, 2022 Many thanks for these tips, I've been out of the VW Worksheet game for the better part of a decade! It does indeed work well. I wonder if it would possible to add this type of workflow to the manual or video training somewhere? I think it'd be helpful for others! 1 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.