The Dynamic Staffing Table: Complex Review Tool
The staffing spreadsheet is a dynamic tool which has quickly evolved to offer customized views to HR, Operations and Sales, all of which must view and compare data sets (unique to their respective roles) to fill positions quickly. They must, in turn, be able to shed the temporary changes so the next wave of contributors can create their own custom views and make assignment decisions.
Forming and launching a dedicated team relies on collaboration between Sales, Operations and Human Resources. As these teams are distributed over time and geography, it became vital to create a tool that could facilitate dynamic data entry and customized views for on-the-spot candidate comparison, eligibility reviews and, ultimately, assignment to a particular studio.
Reassigning candidates to fill gaps caused by new-hire no-shows means fast access to current and relevant candidate data. The Excel file currently developed by the combined USA/India - HR/Ops/Sales teams enables streamlined data manipulation and fast collaboration. Review notes, opinions and assessments of an individual candidate’s suitability for assignment to a new studio is made visible through colored fields which can be hidden when not relevant, only to reappear, on command, should revised viewing profiles arise when visa, experience level or other data points become relevant.
As a simple analogy, consider how new studios, like fingerprints, have a degree of similarity when viewed at arms’ length. Yet draw your hands closer and the uniqueness of each fingerprint is evident. As studio launch dates approach, disruptions such as training visa denials and competitive offers uniquely impact each new studio startup. Decisive action rooted in accurate real-time data is now possible to resolve startup trauma.
What is the solution?
The AEC Dynamic Staffing table provides multiple fields of data, yet within a simple, tabbed, low-volume file that offers a 2D view and rides via email to any PC or smartphone. A low kilobyte file size enables fast transfer. We can message this tool into the sales process so stakeholders of any technical level can appreciate the value; it demonstrates the strategic caliber of our resource planning process.
Notice that columns C, G-L, R-U have been temporarily hidden to suit a particular scenario. Visa, personal info, resume links, and other fields can be resurfaced to suit the needs of any department and scenario.