GA Extractor

Background

In luxury AV integration, someone sits with the general-arrangement drawings and retypes what they see, block by block, into a cable and equipment schedule spreadsheet. It is hours of error-prone work, repeated for every drawing revision. GA Extractor automates that step for a real integration workflow.

What it does

• Parses the .dwg/.dxf drawing and reads the equipment block attributes directly
• Resolves hub and panel names, including recovering names that the open-source CAD converter mangles on export
• Writes the schedule as an .xlsx workbook matching the format the workflow already uses
• Output is verified by diffing against a hand-built reference workbook from the same drawing

Limitations

• One known gap: the open-source DWG converter drops per-cable trunk destinations on one panel type, which undercounts a patch panel; closing it needs the proprietary ODA converter
• Built around one studio’s drawing conventions; generalising the block-attribute mapping is future work

The repository is private because it contains live project data.

What I learned

CAD file formats are hostile territory: the same drawing yields different data depending on the converter, so the tool has to verify its own output against ground truth rather than trust the parse. This project is also my clearest case for AI-assisted engineering: built in days, in spare moments, with an agentic workflow doing the mechanical work while the diff against the reference workbook kept it honest.