A resource tracking and forecasting system built for a global IT outsource company using Microsoft Excel and VBA, delivered via SharePoint. The solution included dynamic filtering to control user input forms, conditional format icons and graphs of actuals and forecast versus budget.
This spreadsheet shows how complicated requirements and processes can be boiled down into a tool that is relatively easy to use.