Worksheet Novice

[GWS]

I am just getting into worksheets and need a few pointers.

I have looked at the VW help which is a start but could anyone tell me how I list and count the different nuts and bolts I have used in my design.

Is this possible?

i.e. 48 x M6 Cap Heads, 32 x M4 Csk Pan Heads etc....

Many thanks

[gmm18]

First you need to know the Record & Field Names that will give you the data you need.

To get these "codes" I use Pat's Worksheet of Plug-in Objects menu item.

The following link will take you to it, and in that thread you will also find instructions

on how to use it:

http://techboard.nemetschek.net/ubbthreads/ubbthreads.php?ubb=showflat&Number=112259#Post112259

Okay, you click on a Plug-in Object, then run the WS-of-PIO thing,

now you have the codes to pull out the data you want.

Create a New Worksheet. Right-click on say row 3, change to "Database"

Now Right Click again on row 3, select "Set Criteria"

In the Criteria, change to Type>is>(your object type here) - in my example I am using the "Bolt and Nut -inch" Plug-in Object.

Okay, now copy paste in the Record and Field Names you want into Row 3.

Add one called "=count" to get your totals.

Then with the row 3 selected, drag the "Sum" icon to each of the appropriate columns so you can summarize the different types you want to count.

Results of Pat's WS_of_PIO menu item:

My worksheet to count different bolts in my drawing:

You can see that I have (5) 1/2" Hex bolts that are 7" long, and (3) that are 5" long./

Now I have a functioning worksheet. I can add or remove columns as I refine what I want to parse out.

You can format the cells to make it look and read better.

You can also turn off the Header Row if you like.

And when you change your drawing, be sure to "Recalculate" the worksheet

by right clicking on the worksheet on your drawing and selecting recalculate,

or if you have the worksheet open, you can find recalc. under the "down arrow"

in the upper left of the window.

[GWS]

Thank you, gmm18 (and Pat) for a very comprehensive answer.

Worksheets seem to be a very useful tool to employ and they look like they will make things a lot easier.

Many thanks

[gmm18]

Worksheets are very useful.

But remember: Computers may be faster, but they take longer.