- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
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:
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:
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