Hello.
I would really appreciate any help on this.
I am trying to create a working schedule in table 3 (tab 3) that autosort available caregivers from table 1 (tab 1) to caretakers from table 2 (tab 2) on a specific day of month. Generated schedule must consider that caregivers work only on specific days of month and can offer their care only to some of caretakers (which allow to work with them). Each caregiver spends 1 hour of his/her working time at one caretaker so that he/she can visit more than one caretaker per day. Daily working hours must be roughly divided among available caregivers.
Table 1 shows which caregiver is available for work on a specific day of month.
Table 2 shows which caretaker allows specific caregiver to offer him a care (work with him).
I've attached the spreadsheet I am working on.
Appreciate any help possible
Bookmarks