Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nursing shifts
Can anyone help with this problem, its for my wife who works at the local
hospital and they want to optimise the staffing levels. If you need any further questions pls do not hesitate to ask. Thanks all Shift patterns Early (E) - 7.5 hrs Late (L) - 7.5 hrs Night (N) - 10 hrs Each member of staff has two days off per week, 36 days holiday and 10 days study leave (part time pro rata). Normal shift numbers would be on a Mon, Wed, Thur Sat & Sun. Two qualified members of staff and three unqualified staff are required on the E shift. Tue & Fri would require three qualified and two unqualified on the E shift. L shift would require two qualified and two unqualified. N shift would require two qualified and one unqualified. Ward has 18 patients, with 4 patients per nurse per shift on average (excluding night shift). Current staffing levels a 9 staff working 37.5 hrs per week 1 staff working 20 hrs (1 staff on maternity leave at 37.5 hrs per week) (1 staff currently on sick leave = 37.5 hrs per week) Unqualified 2 staff on 36 hrs 3 staff on 37.5 hrs 1 staff on 30 hrs 1 staff on 20 hrs 1) How many staff would be required to cover the above criteria? 2) How many beds would need to close for the above criteria to be met? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nursing shifts
Use
http://www.google.com to search for freeware shift scheduling software or perhaps a commercial package. I would expect there is plenty out there that will do what you need. -- Regards, Tom Ogilvy "Scooby Doo" wrote in message ... Can anyone help with this problem, its for my wife who works at the local hospital and they want to optimise the staffing levels. If you need any further questions pls do not hesitate to ask. Thanks all Shift patterns Early (E) - 7.5 hrs Late (L) - 7.5 hrs Night (N) - 10 hrs Each member of staff has two days off per week, 36 days holiday and 10 days study leave (part time pro rata). Normal shift numbers would be on a Mon, Wed, Thur Sat & Sun. Two qualified members of staff and three unqualified staff are required on the E shift. Tue & Fri would require three qualified and two unqualified on the E shift. L shift would require two qualified and two unqualified. N shift would require two qualified and one unqualified. Ward has 18 patients, with 4 patients per nurse per shift on average (excluding night shift). Current staffing levels a 9 staff working 37.5 hrs per week 1 staff working 20 hrs (1 staff on maternity leave at 37.5 hrs per week) (1 staff currently on sick leave = 37.5 hrs per week) Unqualified 2 staff on 36 hrs 3 staff on 37.5 hrs 1 staff on 30 hrs 1 staff on 20 hrs 1) How many staff would be required to cover the above criteria? 2) How many beds would need to close for the above criteria to be met? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nursing shifts shift scheduling software
"Scooby Doo" wrote in message ...
Can anyone help with this problem, its for my wife who works at the local hospital and they want to optimise the staffing levels. Hello If you ar looking for a Shift scheduling program, designed for nursing houses, take a look at http://www.cibit.fi/en/shiftscheduling.php to get a free demo. The software also calculates the salarybase according to your collective bargain agreement, so you can see the costs directly.... Its also possible to define the staffing levels for different weekdays. Sincerely Kim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looking for Excel template for fluid balance chart (nursing) | Excel Discussion (Misc queries) | |||
Nursing Rota Question | Excel Worksheet Functions | |||
More column shifts ... | Excel Discussion (Misc queries) | |||
No entire view in edited shift dropdown list Nursing Schedule Exc | New Users to Excel | |||
Nursing Educator tool | Excel Discussion (Misc queries) |