A local services provider required a low cost solution to manage their staffing needs across 6 Adventure Playgrounds with the flexibility to track staff seconded to any of the sites. An Excel spreadsheet was developed enabling site managers to schedule rota’s and track hours worked at an individual level with minimum administration. Data constraints, lookups, cell locking and conditionally formatted cell highlighting ensuring an easy user experience with a high level of data quality. Complex formula ensures start/end times entered in the rota automatically calculates hours worked/remaining for the year along with annual leave and other absences. This was followed up with a training and mentoring program to upskill in-house staff to take full ownership of the Rota document and equip them with the skills to build their own Excel solutions in the future.
Search
About
Happily escaped the Corporate grind and dreary UK weather to my happy place in the sun!
I now help businesses with simple to use, low cost solutions to their process, administration and data headaches.
I can streamline your processes, build templates, automation and websites using common tools which ensures you are not locked into me going forwards. Everything I deliver is fully owned by you, including WordPress Websites, Excel Apps, Automation and any associated custom coding.
I also provide consultancy and training in all aspects of Data and Getting the Most out of your MS365 Subscription.
Archive
Categories
Recent Posts
Gallery











