Project Description

Excel VBA application to track power, temperature and other sensor data with data consolidated into reports and charts.

An industrial air-conditioning installation and servicing company hired us to write an application in Excel VBA to track power, temperature and other outputs. The data was then consolidated in charts measuring variance, min/max values, and sensitivity levels by customer, unit and site.

The solution was built using advanced VBA within Excel to process sensor files and utilising Excel tables and chart functionality to generate reports.
The build took 3 months using an agile based project approach. The development team size was 1.