/ 01 Challenge
Challenge
A weekly operational report lived in an Excel template uploaded to SharePoint. Consolidation required copying, cleaning, and reconciling versions by hand across multiple contributors. Errors were easy to introduce, and the process had no reliable audit trail.
/ 02 Approach
Approach
The system collects files from SharePoint, checks their structure and combines the data into a consolidated report. Differences and errors are flagged for review.
/ 03 Results
Results
The team receives consolidated data, automatic notifications and a history of each run.