Käynnissä

Nursing Employee Monthly / Daily Schedule

Need to add some back end functionality to simply staffing procedures. I've attached current schedule.

Need to be able to select employee from drop down it should auto populate title etc.

Need to auto populate the names and titles in the daily schedule.

Formulas are currently not functional

Also need to integrate a budget worksheet to help staffer ensure compliance with budgets.

Form is pretty much designed just need to format it and improve it.

Triggers

Work Week = Sunday - Saturday (11:00pm cutoff) ... should be able to change this parameter

5+ days in a work week should display alert ... Overtime!

8+ hours in a day...should display alert ... Overtime!

Schedule

4 on 2 off

Special rule - Custom defined schedule

Cart # 1-4 (Assignments)

Treatment

Desk

etc. (See key in file attached)

Attendance Trending

Call offs

Vacation

Sickr

Switch

Shifts...

Nurses

6:30 am - 3:00 pm

2:30 am - 11:00 pm

10:30 pm - 7:00 am

CNA's...

Taidot: tietojenkäsittely, Excel

Näytä lisää: select staffing, nurses 2, employee need, custom staffing, custom formulas excel, compliance staffing, compliance 11, auto alert, week schedule, auto populate data excel, work schedule, trending, employee, compliance call, cna, call schedule, schedule days, excel monthly daily, pretty schedule, add alert excel, excel change data format, work attendance excel, need employee, excel employee budget, excel drop

About the Employer:
( 3 reviews ) Granite Bay, United States

Projektin tunnus: #4235506

Myönnetty käyttäjälle:

pierreho

Dear dantelouis, I am an excel expert. Your need will be easy to match. Looking foreward. Regards

250 $ USD 3 päivässä
(24 arvostelua)
4.8

7 freelanceria on tarjonnut keskimäärin 307 $ tähän työhön

bharanisrihari

Hello, Excel VBA expert here. I've done similar project for Starwood Hotels group. Please check PM for details. Thanks!

500 $ USD 7 päivässä
(57 arvostelua)
6.3
pkcyber

See your PMB

350 $ USD 3 päivässä
(17 arvostelua)
5.1
rengrish

Hi I went through the requirement. I am very much confident that i can design clean & simple easy to maintain template.

250 $ USD 3 päivässä
(17 arvostelua)
4.0
deepananda

Hi, I am interested to do this project as i have a good typing speed.

300 $ USD 6 päivässä
(0 arvostelua)
0.0
danneacsu

seems like an ordinary job for an excel-man :), but need additional explanations and more details

250 $ USD 2 päivässä
(0 arvostelua)
0.0
onlineupdatebd

I am experience with my skills. Please see PMB.

250 $ USD 10 päivässä
(0 arvostelua)
0.0