Use volume in equation
Use volume in equation
(OP)
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.
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






RE: Use volume in equation
RE: Use volume in equation
What is the syntax to do that?
Chris C. Mechanical Engineer
SW07x64 SP2.2
Dell 490, Xeon Dual Core, 8GB ram
Nvidia Quadro FX3500
RE: Use volume in equation
RE: Use volume in equation
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
RE: Use volume in equation
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.