BOM DATA VALIDATION

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: