Creating a shift schedule could be confusing and time consuming especially if it has to meet a certain criteria, for example, number of shifts, number of people, maximum working hour per week, certain off day, and many other requirements that could be different among different types of companies. The main challenge should be, how to create a comfortable pattern to be implemented to company’s employees that will give them enough rests and maintain their productivity within their working hours to maintain company’s product and service quality on serving clients.
Because it has become major issues among many companies, there are many wellknown shift patterns have been designed by experts to help those companies solve the issues. Some are very popular and widely used in many industries.
Here, I didn’t create an excel template to generate a new shift pattern or formula. I just adopted common patterns and map it into a 52 week shift schedule (lite version is only accommodate 4 week shift schedule). This template should help you finding the most suitable shift plan and map your employees into a printable shift schedule and distribute it to your employees within minutes. And if you can’t find one, there is a custom shift plan feature that will allow you to create your own pattern. It should remove your duty works on planning from the scratch.
It is more suitable for small scale industries where the companies have no more than 200 employees and want to implement simple shift patterns. If you are working in a big company with more than 200 employees, I don’t think this template is a good fit for your needs. Using more sophisticated software should be more beneficial for you where those software should help you not just to plan a suitable shift schedule but also will help you managing all shift schedule related activities, such as attendance related activities.
There were several questions came into my inbox asking on how to make flags in my World Cup 2014 spreadsheets changed dynamically based on country names. I have made a draft on how to create that function one year ago but never had a chance to finish and publish it until now. Because I think, I would rather make a video version of this tutorial to accompany my tutorial article.
Here is the step on creating the excel function, without macros, that will make you change image dynamically based on certain cell value. There are two excel functions used in this spreadsheets (VLOOKUP and INDIRECT) to form dynamic image function. And with a simple trick to combine it with Linked Picture function, you can easily implement it into your excel spreadsheet. You can find online resources or your excel help file to understand those excel functions, if you need more explanation about them.
These are 2014/2015 academic calendars that you can download and use for your school academic scheduling purposes. There are no major modification in these calendars. Based on your feedback, I have created additional calendars that will give you more options on selecting the most suitable one for your school planning.
Newly created additional calendars are :
- Academic Calendars that start on Monday in every week. You can choose between Monday or Sunday as the first day of the week.
- Linear Academic Calendars. With these calendars, you will have another type of calendars that will show your school events in linear layout.
12/13 Month Academic Calendars
For you who are new on using these calendars, these are excel calendars which give you a flexibility to mark its date based on your school academic planning. You can mark just a single date or mark consecutive dates based on your start and end date of you school event period.
Marking Single Date
- Go to Exam-Holiday-Event worksheet
- Type the date and its description in Exam, Holiday, and Important Event Table. Each table will represent different color marker in your calendar. You can change their titles to suit your needs.
Marking Consecutive Dates
- Go to Exam-Holiday-Event worksheet
- There are 3 tables with different color at the rightside of the worksheet where you can type your start and end date to mark your event period.