Drop up to 5 station-grid schedules. They merge into one sheet, then I scan for officers double-booked on the same day.
[ DROP FILES HERE ]
or tap to browse · .xlsx / .xls
COMBINE OPTIONS
MY SHEET (kept on top):
OVERRIDE (replace one supervisor's blocks):← with blocks from:
Pick a supervisor + the file holding their newest schedule. Their old blocks in every other file are dropped, so only the new ones survive.
DATE FIX (force a supervisor's week):→ week starting
Sets every one of that supervisor's date rows to the chosen Friday-start week — fixes stray/old weeks (e.g. 5/22, typos).
SCAN MODE:
Same-day: flags an officer posted at 2+ stations on the same date (true conflict). Any 2nd station: flags an officer listed at more than one station at all (broader — includes rovers).
ALSO SCAN:
CALIBRATING SENSOR ARRAY...
contacts: 0 · sweep 0%
— COMMAND REPORT —
★ STAGE CLEAR ★
No More Errors! Take that, L.D.’s!
Combined schedule = 1 tab. Vacated slots are filled red. Report downloads as a separate file.