Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |