Hi all,
I'm trying to create a schedule in Excel based on the team's availability imported from Doodle. Ideally, after deciding on the pairs that would work opposite shifts, I would assign them to a location.
Then, using a pivot table, I am trying to determine whether these are the best pairs, but I cannot find a formula or sorting option to show this compatibility.
For example, Employee 1 and Employee 6 should always work opposite shifts on the same location. Screenshot 2015-05-20 16.06.32.png
The second part is, once I am certain of the availability, to import the time periods into the final schedule, but I don't know how to do this.
For example, upon deciding that Employee 1 does an AM shift on Day1, Employee 6 does a PM on Day 1, I leave the OK in the corresponding boxes. But how do I then use the OK as a 'tick' for the time period and import the name of the employee in the time period they are assigned to instead of the OK?
This is how the final schedule should look like..
Screenshot 2015-05-20 16.32.20.png
Many many thanks in advance, and I hope this makes some sense to someone.
Bookmarks