Any ideas with this? I have attached a version of the roster with all information stripped (the names are from a fake name generator to make the sheet "easier" to visualise).

Basically, the sheet "allocation" takes data from the other 3 sheets to create its output. I am looking for a simplified, backward-compatible way of doing this. At the moment, it uses needlessly complex formulas, and in the case of the day roster I create the data in advance before I pull it to make it easier to fix :s The "calculations" for the day roster are over to the right of the day roster, starting from column AG.

Basically, if you know of a way I can turn the Day Roster as it is into the allocation sheet as it is, that would be fantastic!