I need an Excel script for the company staff for equally and fairly scheduling their shifts. I have $100 budget for this project. Lower cost proposals will be considered first. Below are the specifications I need. Thank you in advance:

- I've got about 30 people working. Everyday only ONE staff will be on duty, including weekends and various holidays.

- Each person will have ONE shift every month. But if the number of the staff is insufficient, some people may have TWO SHIFTS.

- Each person's work schedule in months should definitely follow this CYCLE: Saturday--Thursday--Friday--Monday--Sunday--Tuesday--Wednesday and return to the beggining, Saturday. For example, someone who is working on Saturday this month, HAS TO work on Thursday the next month, Friday the following month, Monday the following month..etc.

- I must have the ability to specify periods for the staff when they'll be on vacation, when they are sick, etc. The script should exclude people in these specified periods of time.

- I must have the ability to specify any date as a NATIONAL HOLIDAY. Working on these days is unpleasant, so people who work on these holidays should be treated as they've worked at weekends, and their next shift should be a Thursday Or Tuesday.

- At the end of each 12 months, everyone should have worked equally as possible, especially in terms of weekends and national holidays. This should be shown for each person on a table for the staff to see and trust the system.

- And if it's possible, I want the past years shifts to be taken into account. Therefore I'll need the ability to enter past years shift information for the staff. These people have been working since two years and I don't want them to start from zero again.

Kemahiran: Pemprosesan Data, Excel

Lihat lagi: work proposals, proposals for work, project proposals example, excel work in company, example proposals, example project proposals, advance excel+, work vacation, excel advance, work schedule, work on ms excel, shift scheduling, scheduling, Project Scheduling , advance excel, people need work, script years, excel work processing, script schedule, return time excel, data table excel, staff work schedule, month budget example, staff scheduling, staff schedule

Tentang Majikan:
( 6 ulasan ) ankara, Turkey

ID Projek: #4046316

Dianugerahkan kepada:


I can provide an appication in Excel using VBA.

$60 USD dalam 4 hari
(30 Ulasan)

13 pekerja bebas membida secara purata $91 untuk pekerjaan ini


Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

$89 USD dalam 4 hari
(42 Ulasan)

Expert Here.. Please check PM..

$70 USD dalam 3 hari
(31 Ulasan)

Hi, 14+ years in Excel/VBA, strong mathematical background.

$70 USD dalam 5 hari
(19 Ulasan)

please see my PM

$80 USD dalam 5 hari
(4 Ulasan)

Hi,there are some [login to view URL] month has 30 days , another 31 . You might change the criteria

$100 USD dalam 5 hari
(7 Ulasan)

Hi. I interested in your project.

$70 USD dalam 7 hari
(9 Ulasan)

Thanks for your time in reading my bid. Here is what I can offer: - Excellent MS Excel skills, having used it extensively during my work with the Information Technology industry. - My Excel work includes usage of Lagi

$100 USD dalam 10 hari
(3 Ulasan)

WIth a rigid interpretation of the requirements, this will never be a $100 project. In my PM I have described what I can offer.

$80 USD dalam 10 hari
(1 Ulasan)

Dear sir I can do ur work in time. plz pm me

$80 USD dalam 5 hari
(0 Ulasan)

hi. I can do this project for you.

$80 USD dalam 5 hari
(0 Ulasan)

Hi This is a really complicated job that you have. I'm surprised at the above bids. Do they know how long is the SHIFT???. If you look at my profile, I have developed automated system of attendance and leaves for a Lagi

$250 USD dalam 7 hari
(0 Ulasan)

Dear Sir/Madam, I am Dohko who located in Wuhan, China, and am able to begin working on your job right away. Please feel free to contact me to discuss the project any time. I look forward to hearing from you. As Lagi

$50 USD dalam 5 hari
(0 Ulasan)