Sorry about that. Let me try to explain it more.

Location may be wide open, but resource schedule may be limited or vice- versa. In that case I have to select which one is restricted.

Ex:-Location 1 , Resource2, Resource Sch is wide open but location Sch is 9-12 & 13-17 which we have to take.

Another case : If either location or schedule any of them is unavailable then, it should be unavailable.

Ex :- Location1, Resource 4,

Another : - Both Location & Resource have weekly & onetime, but one time is unavailable , so we have to take one time only.

Location3, Resource 4

I also have attached excel from the data & results which I would be expecting.

Again thank you very much for putting your time to look into it.