My work with Pak-Rite was centered around building a custom Visual Basic solution for updating BOMs generated by Solidworks for use in production. The project was built in Microsoft Excel and acts as a single-point utility.
Building and updating a Excel-based macro in Visual Basic for the purpose of updating a BOM. Necessary functions included organizing rows based on values, adding part numbers to rows based on cut size and material from a database, and sorting the BOM with a cut sequence for production.
Designing and building a central front-end in Excel for executing all macros and functions in sequence, complete with file browser and a console for reporting issues and general status updates.