Excel spreadsheet-2
Budget: $2,000 – $6,000 HKD
I’m searching for an excel spreadsheet that will track overtime hours offered (worked and declined will need to separated). There are 4 rotating groups,
working a modified “pitman schedule”, and one group working a fixed schedule. Additionally, there is an hour cap a person can work straight, between a regular shift + OT, and a minimum time needed between their next shift of regular work
The five groups need to have their respective members listed individually so I can track the hours they worked and hours offered/declined.
The schedule is or fixed for the year, so I would like to be able to forecast who is available on any given day
working a modified “pitman schedule”, and one group working a fixed schedule. Additionally, there is an hour cap a person can work straight, between a regular shift + OT, and a minimum time needed between their next shift of regular work
The five groups need to have their respective members listed individually so I can track the hours they worked and hours offered/declined.
The schedule is or fixed for the year, so I would like to be able to forecast who is available on any given day