Counting Symbols in a Worksheet

[Eric Schoenberger]

Hi,

I'm looking for a way to count how many symbols of a certain type are in a drawing; for example how many S4-36's are in a light plot. From what I've gathered, it seems like the COUNT command is the best way to do this from within a worksheet, but I'm unclear what the exact formula should be. Thanks for any assistance.

Eric

[cad@sggsa]

Tools>Custom Selection>SelectOnly>Symbol is ???

[JBenghiat]

Actually. you don't need the count function.

First create a report:

Tools>Create Report

In the dialog, choose:

List all: objects with a record

Listing all objects with record: Lighting Device

Remove all fields, and add "Inst Type" and "Wattage".

Select Summarize all items with the same "Inst Type:

In the resulting worksheet, go to row C2, and simply enter "1". Column C will be your totals.

If you also want to break out instruments with varying wattages, select row 2 and drop the little "Sum" chip from the ribbon to the wattage column header.

Why does this work? When you summarize database rows, all non-matching fields combine. If they are numerical, they add up, so placing a 1 in column C gives you a sum.

-Josh

Edited March 7, 2012 by JBenghiat

[Eric Schoenberger]

Thanks so much for this. A couple of follow up questions:

Is there any way to have it just show me one unit type at a time instead of all of the various unit types together

Is there any way to rotate the worksheet after it's been inserted on the drawing.

Using Vectorworks 2010.

Thanks!

[gasjar]

thanks you've solved all the prior issues ive been trying to work out

I would give you an enormous hug for that bit of info. 5 yrs trying to figure that out

[RickR]

A few years ago I posted a worksheet for this and some other basics in the shared files section:

http://techboard.vectorworks.net/ubbthreads.php?ubb=showflat&Number=139781#Post139781