×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Use volume in equation

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.

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

RE: Use volume in equation

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

cheers

RE: Use volume in equation

(OP)
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

RE: Use volume in equation

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.

cheers

RE: Use volume in equation

(OP)
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

RE: Use volume in equation

$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.

cheers

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources