Embedded Files
Implemented into daily workflow - March 2021
During a work-term, we encountered a measurement rounding issue where measurements imported from Inventor Assemblies (.iam) parts-only BOMs did not round to the correct imperial fractions.
To fix the rounding issue, and a few other formatting issues, I built an Excel VBA script to pre-process data. This spreadsheet automatically populates our ERP system upload sheet, spare parts materials list, and so on.
See before and after photos of an example BOM:
Before
After
Sample VBA code
Page updated
Google Sites
Report abuse