Getting worksheets to report volume

[Michale Jasson]

Hi all

 

Is there anyone who can help me with some work sheet questions? 

I have created a worksheet that will report the linear metres of timber and number of sheets of ply wood in a model using volume by class:

 

=VOLUME_LEGACY(((C='Materials- Timber- Dar- 20x68')))

 

However there are a few flaws with this approach and I was wondering if there are any worksheet commands that could be used to help quantify materials on different layers in complex drawing?

 

Problem 1

This method will report the total amount on all layers, which is useful for a total costing, but no use for quantifying an individual multi material component within the lager model. Consequently I also need it to be applied to individual layers, preferably  by being able to drop the work sheet onto a given layer and having it report the volume by class for that layer only.

 

Problem 2

I appear to be using a Legacy command, does anyone know what the correct command would be for 2017? =volume does not return results.

 

If it helps I can attach a sample drawing with a typical layer/class structure that I am hoping to run the worksheet in.

 

The end goal is to have a worksheet that output a quantity and attach a cost to the items modelled whilst I am drawing them.

 

Any help here would be appreciated

[Pat Stanford]

Hi Michale,

 

Yes, please post a simple file. Much easier to help with a starting point.

 

I don't know why =Volume is not working for you. Possibly the type of objects. The sample file will help with that.

 

You can use a Database and edit the criteria to give you separate totals for each layer or even to break out separate worksheets by layer (or class or ???).