How to use Equations in Drawing Tables

Do you have situation where you need equation to represent total weight, total length or something similar. I do sometimes need that. But now the question arises as how to do that. Where to put the equations to get the desired result. Let’s take a simple example of 4 welded pipe to explain the process.

The part contains a pipe of 2 different lengths welded corner to corner. The cut list shows the two different lengths and weight of one pipe each which means it is displaying the weight of just one pipe and not two pipe. Now someone on the manufacturing floor needs the combined weight of 2 pipes of same length. So we need to show the total weight of two pairs of pipe.

The weight displayed are 47.80 gms and 63.73 gms. But this is weight for one single pipe of each length and not the total weight. One way might had been to multiple the weight property in the cutlist (in part) by the quantity and get the desired result. Let’s try that.

  1. Open the part
  2. Expand the cut-list folder and right click on any of the cut-list item. Select Properties.
  3. Multiple the weight value by quantity i.e. by 2.
  4. The result is not what we need.

But this doesn’t mean it can be done. There are SW API experts who may be able to make a quick macro or script to do it. I’m not an expert with API so that is not in my scope.  Now the question is “Is there an easy way to do it”? The answer is Yes. Let’s see how to do it in an easy way.

  1. Start a new drawing.
  2. Add the required views. (I haven’t displayed the complete drawing but just an Isometric view)
  3. Add the cut-list. The cut-list format might be different on your machine. The cut-list here displays length and weight for one pipe but quantity displayed is two ech.
  4. Right click on the weight column. Select Insert > Column Right. This will add a new column on the right side.
  5. Hover your mouse on the top of new column and you’ll see a cyan box with some alphabet (F in this case).
  6. Click on the cyan box and you’ll see the column property manager.
  7. Keep the “User defined” selected under column properties and under tittle write TOTAL WEIGHT. You may write another tittle too. Click OK to set the tittle.
  8. Now click on cell next to weight value (in the first row). You’ll see the cell formatting window.
  9. Click on equation icon.
  10. Table Equation Editor will pop up.
  11. Now click on the column cell which you want to include in the equation.  Quantity cell (B2) in this case.
  12. Now type * (for multiplication).
  13. Now click on the Weight cell (E2) to include it in the equation (because we need total weight).
  14. The equation is complete now and will look like B2 * E2. You might have different cell number base don your cut list table.
  15. Finally click on OK to set the equation.
  16. The final value will appear in the required cell under Total Weight Column.
  17. Repeat the process for the bottom cell  or copy paste the equation from F2 to F3 but you’ll have to edit the cell number to get the correct value.

Similarly you can use the method for other drawing tables also.

Advertisements

6 thoughts on “How to use Equations in Drawing Tables

    1. Deepak Gupta Post author

      Jai, you need to make sure to have the property in the models. Then add a column and link the property to weight. Finally for total weight add one more column and use equation of qty x weight.

      Reply
  1. hemant

    Hiii admin…i use the equation as per your guidence but its shows 0 value in total wt. What the wrong please guide.
    Thanks

    Reply

I'll be happy to know your views and opinions as this will help me to improve. You can share them as comments below.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s