<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Export Assy BOM and do Math functions in Inventor Programming - iLogic, Macros, AddIns &amp; Apprentice</title>
    <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/export-assy-bom-and-do-math-functions/m-p/10103238#M121246</link>
    <description>&lt;P&gt;&lt;SPAN class="VIiyi"&gt;&lt;SPAN class="JLqJ4b ChMk0b"&gt;&lt;SPAN&gt;Hi,&lt;/SPAN&gt;&lt;/SPAN&gt; &lt;SPAN class="JLqJ4b ChMk0b"&gt;&lt;SPAN&gt;do you mean something like that?&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;A href="https://www.youtube.com/watch?v=xv2MN2eMVqM" target="_blank" rel="noopener"&gt;https://www.youtube.com/watch?v=xv2MN2eMVqM&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Mon, 22 Feb 2021 22:23:59 GMT</pubDate>
    <dc:creator>dusan.naus.trz</dc:creator>
    <dc:date>2021-02-22T22:23:59Z</dc:date>
    <item>
      <title>Export Assy BOM and do Math functions</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/export-assy-bom-and-do-math-functions/m-p/10102432#M121241</link>
      <description>&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks in advance.&lt;/P&gt;</description>
      <pubDate>Mon, 22 Feb 2021 17:24:49 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/export-assy-bom-and-do-math-functions/m-p/10102432#M121241</guid>
      <dc:creator>blandb</dc:creator>
      <dc:date>2021-02-22T17:24:49Z</dc:date>
    </item>
    <item>
      <title>Re: Export Assy BOM and do Math functions</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/export-assy-bom-and-do-math-functions/m-p/10103238#M121246</link>
      <description>&lt;P&gt;&lt;SPAN class="VIiyi"&gt;&lt;SPAN class="JLqJ4b ChMk0b"&gt;&lt;SPAN&gt;Hi,&lt;/SPAN&gt;&lt;/SPAN&gt; &lt;SPAN class="JLqJ4b ChMk0b"&gt;&lt;SPAN&gt;do you mean something like that?&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;A href="https://www.youtube.com/watch?v=xv2MN2eMVqM" target="_blank" rel="noopener"&gt;https://www.youtube.com/watch?v=xv2MN2eMVqM&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Mon, 22 Feb 2021 22:23:59 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/export-assy-bom-and-do-math-functions/m-p/10103238#M121246</guid>
      <dc:creator>dusan.naus.trz</dc:creator>
      <dc:date>2021-02-22T22:23:59Z</dc:date>
    </item>
    <item>
      <title>Re: Export Assy BOM and do Math functions</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/export-assy-bom-and-do-math-functions/m-p/10103407#M121247</link>
      <description>&lt;P&gt;Don't think so, maybe the images below will help. I made a random assy with random parts.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have a parts only BOM style configured as shown:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="parts only.jpg" style="width: 999px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/884096i69B77BBF682DB9C5/image-size/large?v=v2&amp;amp;px=999" role="button" title="parts only.jpg" alt="parts only.jpg" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;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:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="excel.jpg" style="width: 799px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/884097i214F0E3AA8568C01/image-size/large?v=v2&amp;amp;px=999" role="button" title="excel.jpg" alt="excel.jpg" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;If there is a way to just rename the column header to be length, and not the parameter name, that would be great!&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;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.&amp;nbsp; Our drawings only show Item Quantity and length, but does not show a total length, they want this for the shop purposes.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks in advance&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Mon, 22 Feb 2021 23:35:04 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/export-assy-bom-and-do-math-functions/m-p/10103407#M121247</guid>
      <dc:creator>blandb</dc:creator>
      <dc:date>2021-02-22T23:35:04Z</dc:date>
    </item>
  </channel>
</rss>

