PROJECT: Data Management
CHALLENGE: Rebuild a complex and outdated capital improvement projects estimating tool. The existing 40-page workbook relied heavily on error-prone and time-consuming manual data entry.
SOLUTION: Create a tool in Excel which maintained the foundation of what the client liked about the old system while greatly improving the user interface and ease of use. Significantly reduce manual data entry and errors by incorporating proper data organization via a built-in database so data validation features and formulas can be applied.
IMPACT: With increased automation and greater reliability, the client saved 40% of his time with each use of the tool.