Excel Staff Roster for Food Manufacturing
Budget: $15 – $25 AUD
I'm in need of an Excel-based staff roster for a food manufacturing company. The roster should accommodate two daily shifts and incorporate various job functions such as Cook 1, Cook 2, Operator 1, Packer 1, Packer 2, etc. You will how we have tried to set this up in attached spreedsheet.
Key Requirements:
- The roster should be able to auto-fill cells based on inputted shift times for various job functions.
- It should include drop-down cells for breaks, and other elements of work such as SETUP, CLEANING, LUNCH, 10MIN, COVER which are to be color-coded. For
- Each cell should represent a half-hour block.
- We want to input time and have it visually display on spreedsheet so its easy to manage roster through day on the production floor with staff. We like to print these out as A3 (Landscape)
See attachment example for reference. Note: This sheet is my best attempt but I cant really make it work effectively.
The roster needs to be updated daily. Ideally, you should have extensive experience with Excel, particularly with creating complex spreadsheets and using functions such as auto-fill and drop-down menus. Understanding of shift work in a manufacturing context would be a plus.
Key Requirements:
- The roster should be able to auto-fill cells based on inputted shift times for various job functions.
- It should include drop-down cells for breaks, and other elements of work such as SETUP, CLEANING, LUNCH, 10MIN, COVER which are to be color-coded. For
- Each cell should represent a half-hour block.
- We want to input time and have it visually display on spreedsheet so its easy to manage roster through day on the production floor with staff. We like to print these out as A3 (Landscape)
See attachment example for reference. Note: This sheet is my best attempt but I cant really make it work effectively.
The roster needs to be updated daily. Ideally, you should have extensive experience with Excel, particularly with creating complex spreadsheets and using functions such as auto-fill and drop-down menus. Understanding of shift work in a manufacturing context would be a plus.