Develop a Rostering program

已关闭 已发布的 7 年前 货到付款
已关闭 货到付款

I need a program that will achieve the following:

- roster 500 staff to different shift times across a 24 hr period / 7 days a week

- Staff are rostered to individual locations (up to 100 different locations)

- Staff can work at a different location each shift

- Staff need to be identified as both Casual or Part Time

- Shift times are inconsistent.

- examples of shift times are: Shift times cannot be limited though

a) 7.30am to 4.30pm

b) 8.30am to 5.00pm

c) 4.30pm to 9.00am (sleepover shift) (work 4.30pm to 11.00pm, sleepover at work 11.00pm to 7.00am, work 7.00am to 9.00am)

d) split shifts 6.00am to 9.00am / 3.00pm to 5.00pm

e) 4.00pm to 10.00pm

- Staff can work up to 7 days per week.

- Validation rule 1: Staff cannot be rostered on within 10 hours of previous shift unless exception rules apply.

Exception rule 1: If the staff member and employer agrees, there can be an 8 hour break if the break between the shifts if either side of a sleepover shift.

Exception rule 2: The individual employee has a written agreement in place with the employer to have less than an 8 hours break. (Agreement is known as an "Individual Flexibility Agreement")

- Validation rule 2: Must be able to differentiate between casual and part time employees.

- Validation rule 3: Must be able to document and highlight if a part time employee is under their contracted hours.

- Validation rule 4: Must show when an employee is exceeding 38 hours. (overtime would then apply)

- Validation rule 5: Part Time employee must have 2 x days off per 7 days.

- Validation rule 6: A split shift is allowed where the maximum number of hours from the time they start their first shift and the time they finish their last shift does not exceed 12 hours.

- Validation rule 7: A sleep over shift must have a sleep period of not less than 8 hours.

编程 数据处理 Excel 软件构架

项目ID: #10986500

关于项目

13个方案 远程项目 活跃的7 年前

有13名威客正在参与此工作的竞标,均价$2349/小时

schoudhary1553

Dear Project Poster, I have relevant hands on 5 years of experience . I have already completed same kind of project earlier. I assure you about the work quality and time delivery. Please give me chance to complete t 更多

$2000 AUD 在9天内
(371条评论)
8.0
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your pr 更多

$1500 AUD 在10天内
(241条评论)
7.5
chriskerpini

Hello, My name is Chris and, as you can see from my profile, I have 15+ years experience with Excel/VBA and 13+years teaching them both (all levels). I read carefully your post and i think i have understood every p 更多

$2000 AUD 在15天内
(94条评论)
6.8
oda79

Hello! I am ready to help you with your task! Do you need a web-based or desktop solution? I already had alike experience - developing from scratch web-based CRMs for different companies using PHP+MySQL+jQuery+Boots 更多

$2444 AUD 在30天内
(12条评论)
5.4
vahidtavana

Hi This is a timetabling problem you are dealing with. It's a textbook example of a NP-Complete case which means there cannot be a deterministic algorithm to address the issue. Genetic Algorithm is what you need a 更多

$2500 AUD 在20天内
(11条评论)
5.5
satishtl

I have very good expertise in MS Access using as input forms, DB storage, data retrieval, reporting of information with strong VBA skills. In addition I possess Excel macros, formulas, data merging from different shee 更多

$1500 AUD 在10天内
(51条评论)
6.0
mmadi

Dear Client, Greetings from Flowgica technologies, I have experience with these skills. We do have similar experience doing something similar to yours therefore I am looking forward to discuss and move ahead. please ch 更多

$2400 AUD 在29天内
(5条评论)
4.4
chungtranduc89

There are two options that we can offer: using VBA or using C#. VBA can be integrated into Excel, so you can easily monitor while C# can provide good graphical user interface just like commercialized software. Thank yo 更多

$2777 AUD 在20天内
(7条评论)
4.2
cosminpaleacu

Hello, I can help you build a web application to satisfy your needs according to the specifications mentioned. My bid is for build a web based app with authentication based on max 2 roles, with a Locations, Staff an 更多

$1888 AUD 在30天内
(6条评论)
3.5