Use volume in equation

[drillrig]

Hello all,

I am trying to create a part template to use for all of our hot rolled steel raw material (bulk sheets i.e. 4'x8'). I have a design table embedded in my template that specifies several custom properties, including:

StockLength
StockWidth
StockVolume

There are about 53 configurations total. What I want to be able to do is have the designer start a new part with this template and select a configuration corresponding to the type of plate he wants to use. Then he extrudes/cuts/etc whatever geometry is needed for the part. What I want SW to do is automatically calculate the quantity of the raw material, namely, the part volume divided by the StockVolume. I've asked my VAR and he says you can't use the SW property "Volume" in an equation.

Any thoughts?

Thanks.



Chris C. Mechanical Engineer
SW07x64 SP2.2
Dell 490, Xeon Dual Core, 8GB ram
Nvidia Quadro FX3500

 

[CorBlimeyLimey]

If you can't use Volume in an Equation, then use it in the Design Table.

 

[drillrig]

CBL,

What is the syntax to do that?



Chris C. Mechanical Engineer
SW07x64 SP2.2
Dell 490, Xeon Dual Core, 8GB ram
Nvidia Quadro FX3500

 

[CorBlimeyLimey]

The syntax for calling the volume in a DT is $PRP@Volume but you have to create the Volume property in the Custom and Config Specific Properties first using the Drop-down selection under Value / Text Expression.

 

[drillrig]

CBL,

Here's what I have defining my Quantity config specific property in the design table:

="$PRP@Volume"/G4

Where G4 is the column defining the StockVolume config specific property.

I've tried it both with and without the quotation marks, but Excel won't calculate a value.

Any other suggestions?



Chris C. Mechanical Engineer
SW07x64 SP2.2
Dell 490, Xeon Dual Core, 8GB ram
Nvidia Quadro FX3500

 

[CorBlimeyLimey]

$PRP@Volume is a value read from the model. Once it is in the DT it can be referenced in equations in other cells.

Create a new column and reference the cell that the $PRP@Volume is in. (eg. =F4/G4) The result can then propagate a property in the model, which in turn can propagate a column in a BOM.