staff planning

Hello all, I'm trying to use VBA to accomplish the following task. 20 call center agents need training. The training is one hour long and a max of 4 agents can attend each session. The sessions may not be scheduled back to back. The training should be scheduled at a time when it impacts the...

Hi All, Say I have a restaurant and need certain staff on different tasks each night. We try to make it so that each member of staff perform each job at some point in the week. I want to avoid one member of staff being in the pair that for example washes pots 3 days a week when everyone...

Hello! I am having trouble with VBA and getting it to work with the formula I made. I am using it to find data on another sheet by going down a column and finding anyone with a "D" in the row then pulling the first column name and pasting it on another sheet. This is used for staffing and since...

Dear Excel Community, I run an events company operating Christmas grottos throughout the UK. Key to what we do is the rostering of staff. I have an Excel template, into which on the first tab I put the opening hours of grottos and it will populate the correct shift patterns for Santa and his...

Dear experts, I am trying to figure out how to put together a hire/release plan for temporary employees. I am beginning to think I’ve bitten way more than I can chew so any help or suggestions will be greatly appreciated. I apologise in advance but this is going to be a long post. What I have...