I need a program either in excel or access that will make a rotating overtime list based on the following:
1. I have a list of names that has the following data:
a. ID number
b. Rank (Captain, Driver, EMT, Medic)
c. First name
d. Last name
e. Phone number
f. Shift (i.e. 3rd, 2nd and 1st)
2. I need to make a list that will do the following when calling overtime:
a. First, the initial list is based by ID number from lowest to highest
b. The Overtime list needs to be a list of names that can work for that day.
i. If the schedule shift working is 3rd Shift then only 2nd and 1st shift people are called.
ii. The list need to be broken down by Rank so when looking for a Driver only the available Drivers not assigned to that shift are called.
c. If person A works an overtime shift it will keep that date as the last time called.
i. Regardless of the date, if the person A works an overtime day that does not influence where they stay on the master list. The master list is based by ID number and not by the overtime date.
d. If a person C is called and takes the overtime than person D will be the next one up
i. The only exception to this rule is when the overtime is less than or equal to 12 hours, then person C will stay in the original order.
e. If person E is called but does not answer then they go into another list called No Contact.
i. This is where is gets tricky, well to me that is;
1. When someone on the No Contact lists takes the overtime on said date, they will go back into the master list based by ID number.
2. When someone on the No Contact list again does not answer the call person E will stay in the original order when they were placed into the No Contact list.
a. If I have a list of 10 persons on the No Contact list and person 5 takes the overtime, person 6 is not the first one to call the next time around. The first person on the No Contact list is still person 1 and is the first person called and person 6 now becomes person 5; thus having 9 persons on the No Contact list even though persons 1 through 4 will have a greater date verses persons 6 through 9.
Person 1 9/23/15
Person 2 9/23/15
Person 3 9/23/15
Person 4 9/23/15
Person 5 9/20
Person 6 9/20
Person 7 9/20
Person 8 9/20
Person 9 9/20
f. If person F is called and they do not take the overtime or say, “No, I cannot work it today” they go back into the master list.
21 freelance ont fait une offre moyenne de 146 $ pour ce travail
Im interested in this project.I have good knowledge on excel programs. I will complete the work in time.It will be helpful if you give this opportunity to me. Thanks in Advance