Monthly Shift Scheduling & Spreadsheet
Adrian Suryawinata
Monthly Shift Scheduling & Spreadsheet Audit
Developed and reviewed a monthly employee shift schedule using spreadsheets for real retail pharmacy operations.
The project involved:
Organizing morning and evening shifts based on staffing requirements.
Balancing shift assignments fairly among employees.
Managing planned leave days and individual scheduling preferences.
Checking daily staffing coverage to maintain operational continuity.
Identifying and avoiding exhausting three-day shift patterns, such as morning–evening–morning and evening–morning–evening.
Auditing the final schedule for shift totals, leave allocation, and scheduling conflicts.
Tools: Microsoft Excel, Spreadsheet Analysis, Workforce Scheduling.
Real project. Portfolio preview reconstructed using anonymized example data to protect employee information.
Like this project
Posted Oct 31, 2026
Monthly Shift Scheduling & Spreadsheet Audit Developed and reviewed a monthly employee shift schedule using spreadsheets for real retail pharmacy operations....
