Fermé

Rotating Overtime List with many varibles

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.

Compétences : Traitement de Données, Anglais (É.-U.), Orthographe anglaise, Excel, Microsoft Access

Voir plus : excel rotating overtime list, example rotating overtime list, overtime rotating list, rotating overtime list, plesk mailing lists broken

Concernant l'employeur :
( 0 commentaires ) United States

N° du projet : #8540890

21 freelance ont fait une offre moyenne de 146 $ pour ce travail

zExcel

A proposal has not yet been provided

200 $ USD en 3 jours
(210 Commentaires)
7.3
fabest

Dear, we are Team of French + US. 11 years experience on Access/Excel/VBA automations. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you c Plus

178 $ USD en 3 jours
(36 Commentaires)
6.0
cugamelover

I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. Please see reviews on my profile. It would be my pleasure to do your project. Please have a look at some Excel project Plus

180 $ USD en 5 jours
(67 Commentaires)
6.1
wsh2

Nice write-up. It is very apparent that you have given this a lot of thought. Well done. Greetings from Easton PA.. {smile} Highly experienced (25+ years) MsExcel Business programming and database expert with Gur Plus

210 $ USD en 9 jours
(31 Commentaires)
6.1
dpune

Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 250 projects. Please look at the feedback left by my employers to know more about my work. Wai Plus

100 $ USD en 7 jours
(79 Commentaires)
5.9
dviruki

Dear Sir/Madam, I have 12 years of experience in data processing using Excel and VBA. I have completed over 60 projects on Freelancer involving use of Excel and VBA. You task is perfectly doable in Excel using VBA. Ple Plus

87 $ USD en 3 jours
(64 Commentaires)
5.2
someka

You dont need to recruit me now. Drop me a message and i can make a free trial study for you. If you get happy, we can proceed. (as i want more references in my profile, i provide this service) I have a 5,5 years of Plus

30 $ USD en 3 jours
(38 Commentaires)
4.7
Midlander

I can start as soon as you pay the fee into the site and your existing details, Can do it under a Confidentiality and Non-Disclosure Agreement if required, I designed dashboards, reports and interactive spreadsheet Plus

206 $ USD en 3 jours
(12 Commentaires)
4.4
zu02

Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Acc Plus

155 $ USD en 3 jours
(2 Commentaires)
3.5
workerbee1974

I have 15 years experience in access database design and development. I have completed well over 250 custom databases in this time. I have worked on existing databases and created from scratch. A list of some databases Plus

111 $ USD en 3 jours
(4 Commentaires)
3.0
fazeelatmazhar

Sir/Madam, Greetings. This is an IT person , an experienced database developer , an experienced designer and an experienced technical writer. I have developed university management system , advanced timer, file t Plus

250 $ USD en 3 jours
(7 Commentaires)
3.6
gsanggara

Hello, I am interesting to your project & placed bid for your consideration. I'm excel coder, with 3year+ experienced in excel coder & formulas I am very confident that i will deliver good result as per your requir Plus

55 $ USD en 2 jours
(4 Commentaires)
2.2
aisvaryayemi

I developed Clinic management System where the doctors can book their admin hours and the channeling hours. According the the booking entry will calculate the overtime hours and the total pay for the month. Moreover, t Plus

155 $ USD en 2 jours
(2 Commentaires)
1.9
ufasoft

Hello! I can help in this project! I have the 16 years of experience in the field of automation of the financial sector and trading companies. I am an expert in the field of databases: MS Access; SQL Server 2000-20 Plus

155 $ USD en 3 jours
(2 Commentaires)
1.2
Padmaja06

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

135 $ USD en 3 jours
(0 Commentaires)
0.0
devenmehta2006

Please check my profile. I have worked in companies like Reliance and others for inventory management and employee management systems. I have experience in working on huge excel files with proper macros and fast implem Plus

122 $ USD en 3 jours
(0 Commentaires)
0.0
Nostrianemos

EXCEL FORMULA AND VBA MACRO EXPERT Highly experienced in developing excel user forms, VBA, pivot tables, power pivot, power query, and excel's data modeler. I have experienced 9 years in VBA macro excel. I am an Plus

133 $ USD en 2 jours
(0 Commentaires)
0.0
LoubabaB

Aucune proposition n'a encore été fournie.

177 $ USD en 5 jours
(0 Commentaires)
0.0
nooremostofa123

I'm able to enter data in Microsoft office. I have some experience in customer services. Also have a good skills in English language. Employed History: I was worked for an Asian Leading Mobile Brand as a seals offi Plus

244 $ USD en 3 jours
(0 Commentaires)
0.0
bravekid

A proposal has not yet been provided

155 $ USD en 3 jours
(0 Commentaires)
0.0