I am looking for excel sheet for 4 crew 5-5-4 schedule. Total of 60 workers work in 4 , 12 hour crews. This Sheet will be about number of hours an employee worked during period of six months. It should satisfy following conditions:
• whenever colleague call in, to replace him/her an overtime opportunity arises. Replacement should be in accordance with seniority, also there should be equal division of overtime opportunities to all employees. for Example: Senior employee get called once, he will be called next time only if there is no junior employee to work or if no body sign up for overtime. just to explain more here is another example: most senior employee, is allotted overtime opportunity, next opportunity will go to employee next in line of progression, or to next one, if the worker next to him is not interested. But if there is no employee interested in that case, the senior who already got called last time could get called again as there is no body interested to work.
• This sheet should show how much overtime each employee worked, for period of six months and then reset. So, it will collect data from January-June and then start again from July-DEC and then start fresh
• The data which keep collecting overtime should be visible as graph or any other interactive way , so that if superior need to call he could know which worker had most overtime hours and which have least , so that colleague with least number of overtime could get priority among all the workers could get opportunity .
• One more Example: Let one senior colleague worked for 108 hours of work time, another colleague worked for 84 hours of overtime and third collogue worked for 48 hours. There should be chart showing that Senior worker worked most hours, so workers with least hours should get opportunity , it could be like 108 hours could be showing as red bar in a chart , 84 as orange and 48 as green.
43 pekerja bebas membida secara purata $156 untuk pekerjaan ini
Hi. I am an expert in Excel and 20 years of experience in software development, I know very well the problem that you must solve, so I can help you. You can contact me to expand more details of the requirement.
If relationship with a difference is what you desire, look no further.. You are in safe hands The language I understand is "I am satisfied with the job"