- Rewrote a 38-sheet macro-enabled Excel workbook in-place using a Python ZIP/XML transform – replacing all legacy brand references across shared strings, named ranges, and formula strings without touching the VBA binary or breaking any calculations
- Replaced three product line names throughout the model (Cabinet Energy Manager, Wire Theft Sensor, Lighting Controller) with ordered pre-passes to prevent compound-phrase duplication artifacts in multi-word substitutions
- Removed four embedded Office web add-ins (ArcGIS, MAPCITE, Ghostwriter, Adobe Document Cloud) at both the file XML layer and the Excel application level – discovering that Mac Excel 365 requires accepting consent modals before the removal UI is accessible
- Initiated rearchitecture of the model into a PostgreSQL + Python + Streamlit platform (Roadway Intelligence Platform): schema design completed across 4 schemas, 20 utility rate plans classified into 6 architecture types, California CCA registry extracted, and initial repo scaffold pushed to GitHub
