The Company
A large oil company that relies on more than 100 external laboratories to run quality tests on petroleum products. Test results must be consolidated and analyzed to detect issues and outliers before products move downstream.
The Challenge
Lab results were uploaded into a single Excel file for analysis. The file was slow and unstable. Recalculations often took several minutes, and uploads failed if any source file contained errors. This slowed quality checks and forced staff to restart uploads or troubleshoot data problems by hand.
The Solution
We reviewed the existing spreadsheet and identified the main causes of poor performance and crashes. Instead of rebuilding the system, we made targeted changes to how data was processed and validated. The upload process was redesigned to handle bad input files without stopping the full update, and calculations were streamlined to reduce load time.
The Result
The client avoided a full rebuild, saving thousands in development costs. Spreadsheet performance improved by more than 2,000%, and uploads no longer fail when individual test files contain errors. Quality teams now receive results faster and with far less disruption.
About MS Excel Solutions
At MS Excel Solutions, we engineer business intelligence solutions that transform the way companies operate. Our Excel-based builds collapse hours of manual effort into instant, reliable results. With every project, we solve business challenges and empower teams to drive business decisions with confidence.
We’re problem solvers, consultants, and business partners who make technology work for your business.