Ditch the Spreadsheet & Save Nancy
The IT team at Skagit Regional Health wanted a new approach to how they tracked their internal resource capacity. Their method of an excel spreadsheet linked to an Access database had become far too cumbersome for their fast-paced environment. This process was also creating a huge burden for the team member that had to manage it. The solution was to create an internal web-based application connected to a fast SQL database that could be updated easily and efficiently. The project was affectionately nicknamed “Save Nancy.”
The Role of Color & the User
In many ways the tool needed to emulate time-tracking software where users would log time predictions in segments of 8 hours, nothing less. From the beginning, it was stressed that team leaders should be able to access and update resource allocations in 10 minutes or less. They didn’t want the resource capacity tracking to become its own line item. Once all the time had been allocated, reports would be created so that directors and c-suite officers could view the data easily. To accomplish this color was used to clearly identify which teams and projects were over-allocated.
Make it Easy
Every aspect of the application was audited to make sure simple flows of information were created for each and every role. The application steps were examined and tested to make sure they were intuitive and easy to navigate. The result was a clean minimalistic interface that allowed color to stand out and create visual cues for the end user.