It seems to be very difficult to make shifts at the nursing care facility where I am currently working, so I will develop an alternative tool (note that versatility is not considered because it is assumed that it can be used at my workplace).
For the time being, I thought about various things in order to bring out the functions I wanted.
First, itemize the points that you will consider when creating shifts.
-** Staff work styles include "day shift" and "night shift" ** -** There are "commuting", "staying", and "visiting" as service forms for users (customers) **
We will consider these points.
-** The number of users, the number of users, the usage time and service form vary from day to day **
It is mainly decided by the day of the week, but I am alert because there are slight fluctuations.
-** Pick-up staff is required on days when there are "commuting users" **
A license holder is required, and an auxiliary staff is also required. It should also be taken into account that the number of staff in the facility is decreasing during that time (if there are "staying users", a separate staff to stay is required).
-** Night shift is required on days when there are "staying users" **
Basically, it's okay if you have one person, but since night shifts span days, you actually eat two days' worth of schedule (by the way, each staff member seems to have an upper limit of 10 times a month).
-** One staff member enters the kitchen on days when the cook is absent **
The person cannot serve customers properly for about an hour before and after lunch, so an extra number of people is required.
-** Conditions for each staff **
Some people can only come out by specifying the day of the week, and some people have limited work styles.
As mentioned above, it seems that this is the place. ** To be honest, at first I thought it would be cool if I could automate all of this shift creation programmatically, but I gave up because I didn't understand the algorithm I wrote above. ** **
Regain your mind and go to the next.
This time, I briefly summarized the flow when actually making a shift (note that I have not made it myself, I just refer to the story I heard).
One thing I noticed here. Actually, ** 1 and 2 are separate materials, so you have to change your eyes each time you check, and then return to the Excel creation screen again. ** It's a hassle. I think it is better to display such information as it is on the creation screen.
Recommended Posts