SearchLondonJobs.co.uk

šŸ›ļø London's Premier Job Portal

← Back to London Jobs

Freelance Job: Custom Excel Rota and Job Allocation Tracker

Company: Unspecified

Location: Hungary, London

Posted: May 05, 2026

Apply for This Position

Submit Application

Position Details

Hi, I’m looking for someone to help me build a custom Excel rota and job tracker for our night shift cleaning team. We have around 36 colleagues and work on a weekly rota from Sunday to Saturday. I update the shifts manually every week. The rota changes every week as well, with everyone moving down one turn each week and the last person moving back to the top. We also use RDW shifts (overtime), which should still count as working shifts in the tracker. What I need is something simple, reliable and easy to use long term. The tracker should: * Allow me to update weekly shifts manually * Automatically calculate how many days each colleague is working each week, excluding OFF, A/L and Sick days * Automatically assign daily cleaning jobs only to colleagues who are working * Use a cleaning job list, which I can provide separately * Rotate jobs fairly across colleagues and not always start from the same job * Work day by day (Sunday, Monday, etc.), not just one single job column * Allow me to...