Tracking System
Client
Back Combined
Status
Completed
Industry
Construction
Date
2024-04-24
Our elite client Back Combined approached us with the need to keep track of documents for authorities' approvals without losing important dates and deadlines.
Key Achievements & Impact
We developed an Excel tracking system with embedded coding to meet this requirement.
The system features color-coded status indicators that update automatically based on dates and inputs, eliminating the need for manual entry.
Additionally, all fields where users need to enter data are implemented as dropdown lists to avoid mistakes and ensure consistency.
This effective, yet simple, tracking system also includes a button that, when pressed, prepares an email to the relevant people regarding delayed items.
The system’s items are interconnected by dates and predecessors, ensuring smooth tracking and a correct workflow.
This solution helps our client maintain organization, meet deadlines, and streamline the approval process.
