I gang

MS EXCEL: WORK SCHEDULING/SHIFTING SCRIPT

Hello,

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.

Færdigheder: Databehandling, Excel

Se mere: 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

Om arbejdsgiveren:
( 6 bedømmelser ) ankara, Turkey

Projekt-ID: #4046316

Tildelt til:

pyazlm

I can provide an appication in Excel using VBA.

$60 USD in 4 dage
(30 bedømmelser)
4.4

13 freelancere byder i gennemsnit $91 for dette job

sonarkaushik

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

$89 USD in 4 dage
(42 bedømmelser)
5.7
microk

Expert Here.. Please check PM..

$70 USD in 3 dage
(31 bedømmelser)
4.5
VedAlek

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

$70 USD in 5 dage
(19 bedømmelser)
4.0
FLtowhid

please see my PM

$80 USD in 5 dage
(4 bedømmelser)
3.8
cosconeaionut

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

$100 USD in 5 dage
(7 bedømmelser)
3.6
eugene2006

Hi. I interested in your project.

$70 USD in 7 dage
(9 bedømmelser)
3.5
sumshank

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 Mere

$100 USD in 10 dage
(3 bedømmelser)
2.4
renze

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 in 10 dage
(1 bedømmelse)
1.9
artisticdesigner

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

$80 USD in 5 dage
(0 bedømmelser)
0.0
LubnaEssa

hi. I can do this project for you.

$80 USD in 5 dage
(0 bedømmelser)
0.0
abyvas

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 Mere

$250 USD in 7 dage
(0 bedømmelser)
0.0
dohko1911

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 Mere

$50 USD in 5 dage
(0 bedømmelser)
1.6