I gang


I need an Excel script for the company staff for equally and fairly scheduling their shifts.

- 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 when 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: Excel

Se mere: shift scheduling, project scheduling, need staff account, return time excel, staff work schedule, private people, staff scheduling, staff schedule, information system excel project, days shift, shift days, staff excel, scheduling excel, schedule shifts, days shifts schedule, shifts days, vacation excel, want shift schedule, shift work excel, account information system excel, work schedule system, work schedule excel, excel time schedule, excel company shift, need company vacation

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

Projekt-ID: #4056568

Tildelt til:


Hi my friend, thank you so much for awarding the private project to me. And I had sent messages to your PMB, for the detail, please kindly check it :) With thanks, Dohko

$60 USD in 2 dage
(0 bedømmelser)

4 freelancere byder i gennemsnit $64 for dette job


Confident in delivering you this project.

$60 USD in 2 dage
(11 bedømmelser)

Sir, I am Excel [url removed, login to view] see pmb.

$70 USD in 7 dage
(0 bedømmelser)

Sir, I've read out your shift requirements very [url removed, login to view] waiting to be colleague of 30 member's staff.A great experience you will be served I hope. I'm waiting to get your quick kind [url removed, login to view]

$66 USD in 30 dage
(0 bedømmelser)