Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
blandb
267 Views, 2 Replies

Export Assy BOM and do Math functions

I have the parts only BOM tab set with the parameters I need to export, but I need to have a column added to the end in excel for "total Length" where it takes the G_L parameter and multiplies it by the Item quantity. Is there a way to do this? Do I use the GoExcel.CellValue to do this? I am not certain on how how actually accomplish this, I know it is probably something easy I am missing. I thought about setting up spreadsheet as a template with the column needed with a formula, but with the rows of the assembly always changing depending on what is being ran, I'm not certain on how to handle it.

 

Thanks in advance.

Autodesk Certified Professional
dusan.naus.trz
in reply to: blandb

Hi, do you mean something like that?

https://www.youtube.com/watch?v=xv2MN2eMVqM

 

blandb
in reply to: dusan.naus.trz

Don't think so, maybe the images below will help. I made a random assy with random parts.

 

I have a parts only BOM style configured as shown:

parts only.jpg

 

But I want a rule that will export this, but add a new column in the excel file to multiply the G_L cell by the item quantity for parts so I get a total length used as shown in excel:

 

excel.jpg

 

If there is a way to just rename the column header to be length, and not the parameter name, that would be great!

 

This way for all cut parts I can use this to tell the shop total linear length of cut shapes from channels, beams or extrusions.  Our drawings only show Item Quantity and length, but does not show a total length, they want this for the shop purposes.

 

Thanks in advance

 

Autodesk Certified Professional