Shared HR Department · Personal Computers (PC) & Personal Service Center (PCS) · Weekly Shift Roster with Auto-Shuffle & HR Export
0 Employee Master HR input
1 Select week
2 Shuffle / edit
3 Export PC & PCS files
0 Employee Master — HR-provided inputID · Official Name · Company · Department · Section
Maintain your staff list here — add when someone joins, remove (✕) when someone leaves. Section (TECHNICIANS / COUNTER) controls the shift types the auto-generator uses. Saved in this browser · use Export / Import CSV to back up or move to another computer.
Re-links the current week's roster to this master.
1 Select Week — roster auto-generates from the Employee Master
Every week you open auto-generates on first visit (Friday = DO · Technicians: MASI + rotating MNSI · Counter: alternating MAS/AN) and is then remembered (✓). 🔄 Regenerate rebuilds the current week from the Employee Master — use it after adding/removing staff or changing sections.
⚠️ Regenerating a week overwrites any manual edits and shuffle changes you made to it.
Optional — import an existing roster from Excel instead
Only needed if you want to start from a historical Excel roster rather than auto-generating. Staff are matched to the Employee Master by Official Name.
📥
Drop a Duty Roster .xlsx here or click to browse
Multi-week workbook (each sheet = one week, Fri→Thu)
Try with the provided Aug 2026 workbook.
2 Shuffle & Edit Roster
Auto-shuffle ideas:
All Staff
PC Personal Computers
PCS Personal Service Center
Click any cell to change its shift code. Friday is the weekly off (DO). Annual Leave (AL) is preserved during shuffle.
3 Export HR Files
CSV:Employee ID, Name, Department, MM-DD-YYYY ×7 with shift codes MASI / MNSI / MAS / AN / DO / AL — matches the HR Shift-Import template. PDF: Prints the current week's full roster with TECHNICIANS and COUNTER sections kept separate (header + dividing line), colour-coded shift cells, Fri→Thu.