01
Automotive · dealer network
From branch exports to one report.
- Situation & inputs
- Different DMS export formats and manual consolidation.
- Solution
- Excel and VBA load exports, align data and prepare a PDF report.
- Outcome
- Repeatable report preparation with input consistency checks.
- Scope
- Spare-parts reporting; processing exports rather than replacing the DMS.