Adding to the litany of feedback: your BOM parser and manager is a source of pain. For a few BOM items it's fine, but for 50+ with 500+ placements there it's a heavy human lift with a lot of human error that is ripe for automation. Also, DNP interpretation are large hazard for silent failures. The spreadsheet is gospel.