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

en voir plus : excel rotating overtime list, working leading people assignment, assignment working leading people, example rotating overtime list, overtime rotating list, rotating overtime list, list prerequisite skills working fractions unlike denominators, excel list names people working days, plesk mailing lists broken, client list india working java technologies

Concernant l'employeur :
( 0 commentaires ) United States

Nº du projet : #8540890

21 freelance font une offre moyenne de $146 pour ce travail


A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(210 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(36 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(67 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 9 jours
(31 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(79 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(64 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(38 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(12 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(2 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(4 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(7 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(4 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(2 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(2 Commentaires)

Im interested in this project.I have good knowledge on excel programs. I will complete the work in [url removed, login to view] will be helpful if you give this opportunity to me. Thanks in Advance

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)

Aucune proposition n'a encore été fournie.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)