The firm was formed by the merger of two design offices. The way it worked lived in the heads of the managing director, the owners, the designers and the project coordinators, as well as in Excel sheets, while more and more tasks and projects came in at the same time.
Timesheets and quotes were in Access. Weekly capacity was in a start-of-week Excel file. Documents were in NAS folders. Data was created in three places and never came together into one picture.
They wanted one place where you can see who is working on what, by when, what the deadlines are, and where the project stands.
The goal was not a perfect system, but a unified one.