![]() For example, you can select a group of cells and change the shift number from 1 to 2 by using the Excel replace function. The advantage of using Excel for shift scheduling can be easily seen here. The letter "x" is used to specify days off while numbers 1 to 6 indicate shift numbers. You can copy the shift patterns from the Shift Patterns spreadsheet to schedule the employees. The portion highlighted in red requires your inputs. This is the worksheet that lets you specify the shift patterns. It is only used to maintain a consistent understanding of the shift hours. ![]() The start and stop shift time is actually not used by other parts of the spreadsheet. This shift information from cell C4 to G10 can be printed. A maximum of 25 employees and 6 types of shifts are supported. This worksheet lets you specify the Stat Date of the shift schedule, the Names of the employees, the Names of the shifts, the Start/Stop time of the shifts and the number of hours of each shift. All the input fields are also marked with the '*' symbol for you to identify them easily. The rest of the worksheets are generated automatically. If you recall from the previous section, only the following worksheets require user inputs or updates: This section describes the different worksheets of the Shift Scheduler spreadsheet in details. Shift Scheduler Spreadsheet (Staff Scheduling)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |