Thread: [Solved] Manager On Duty Monthly Automatic Schedule
View Single Post
 
Old 11-30-2011, 12:50 AM
erwinar erwinar is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: Nov 2011
Posts: 2
erwinar is on a distinguished road
Default Manager On Duty Monthly Automatic Schedule
I have a problem regarding the preparation of MOD schedules. Due to:
  1. The number of MOD staff exceeds the number of days in that month.
  2. There MOD officials who can not perform their duties on certain days such as Puji Ariyani and Suryanti.
My Question is:


  1. How to make automatic generated monthly schedule of person who incharge MOD?
  2. How to make the rest person to do the MOD in the next month automatically? Because in one month have 28 to 31 days but the person incharge more than 40 attendant.
Herewith I attach an example of data in question.
Thanks for your help.
Attached Files
File Type: xlsx WHOLE YEARS MOD SCH Testing.xlsx (30.7 KB, 26 views)
Last edited by erwinar; 11-30-2011 at 09:51 PM. Reason: Insert questions and new sample of schedule
Reply With Quote