The tool is macro based program written in VBA and implemented in MS Excel office applications. It's intend for back office corporate operations when it is necessary to allocate people and plan work in a large corporate teams.
It has automated a process that previously demanded considerable manual work. Now, we are saving at least 80 hours annually. This tool brings in a more equal distribution of onboarding days among our team members. It automatically populates absences, evaluates additional responsibilities, matches certain skill requirement with its holder as well as hints towards skillsets that potentially require additional FTE allocation. 🚀
The front view of the program interface where a user (planner) by clicking on single button can automatically schedule employees for upcoming month.
A user can choose from the user input forms particular options:
The program has many additional features such as error handling function, program progress and attention message boxes to inform a user how to handle the tool safely.
