#bom

Tagged posts

2 posts tagged with "bom".

March 16, 2026

~6 min read

Parsing the Unparseable: Adaptive BOM Ingestion for Customer Spreadsheets

Customers send spreadsheets that look nothing alike. Hardcoded column indices fail on day two. Here is the four-step heuristic pipeline that handles anything.

pythondata-engineeringexcelbomheuristicsmanufacturing

March 9, 2026

~7 min read

·engineering

Normalizing 20,000 Components: The Data Pipeline Behind SMT Assembly Intelligence

A 10kΩ resistor has at least eight names in the wild. Here is how a regex-driven normalization engine turns manufacturing chaos into a canonical data layer.

pythondata-engineeringmanufacturingregexsmtbom