Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Looking for Excel template for fluid balance chart (nursing) Carol in Chicago Excel Discussion (Misc queries) 1 April 29th 10 04:25 PM
Nursing Rota Question [email protected] Excel Worksheet Functions 2 July 23rd 06 08:31 AM
More column shifts ... fak119 Excel Discussion (Misc queries) 1 May 29th 06 03:50 PM
No entire view in edited shift dropdown list Nursing Schedule Exc nanmacarb55 New Users to Excel 8 April 10th 06 10:12 PM
Nursing Educator tool alanita Excel Discussion (Misc queries) 0 August 26th 05 10:20 PM


All times are GMT +1. The time now is 07:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"