Hi,

I'm trying to create a schedule in Excel based on the team's availability imported from Doodle.

I have attached the documentDoodle 16.xls and I will try to explain my thought process in steps. Hopefully you'd be able to help me translate this into a coherent spreadsheet.

Step 1 - Availability - poll sheet

I have imported a spreadsheet from Doodle, containing the team's availability.

Step 2 - Cross Check sheet

I would manually cross reference pairs of two based on their availability. For example, the first two on the list are unavailable on the same shift three times.
Then I'd fill in another table with the results of this cross reference, manually, trying to find the best matches, the pairs of two team members that have the least overlaps in unavailability.
This is the step that I need most help with, as I am sure there is a faster way to do it..

Step 3 - Locations + Schedule sheet

After finding out which team members are most compatible, I'd pair them and assign them to a location. Further, I would sort them based on Attachment 396210location, so that the pairs of two are next to one another.

Then, the pairs should, ideally, have no overlap in unavailability, thus making the shifts assignation very easy. I will show this with rows 17 and 18. I have marked in red the shifts that are not covered, as the cross check was at random and they would definitely be a bad match.
But it's a good example, as it illustrates exactly what I am trying to avoid here.


Any chance this can be done easier, please?
I am to schedule a team of 80 volunteers, and this way is extremely time consuming.

Many many thanks in advance!!!