QA Report Splitter
Version v1.0.0 · technical reference. Back to the case study →
Overview
Macro that splits batch QA reports from new system into individual language files matching legacy format.
Identified company-wide gap after system change caused hours of overhead across all QA teams. Created macro, adopted by lead developer and absorbed into company QA tools.
The Problem
Company changed QA systems after a decade. New file layout confused clients. QAs across entire company spent hours clicking through tabs to create individual reports for 26 languages—previously took 10 minutes.
The Solution
Created macro to run one batch file in new system, then split into individual files matching old format exactly. Adopted by lead developer and absorbed into company QA tools.
Features
Report splitting capabilities.
- Batch Splitting - Single input to multiple outputs
- Legacy Format Matching - Output matches old system exactly
- Multi-Language Support - 26 languages handled
- Company Adoption - Integrated into official QA tools
Results
Company-wide impact.
| Metric | Before | After |
|---|---|---|
| Processing Time | Hours | 10 minutes |
| Manual Effort | 26 languages manual | Batch + split |
| Impact | Company-wide pain | Adopted into QA tools |
Technology Stack
Technologies used.
- VBA - Macro logic
- Excel - File processing
- Data Processing - Format transformation