how to let excel plan out work schedule by itself based on conflicting criteria

[Phenomi]

Hi guys,

Need some help here. I have a library of recipes which acquire several systems.

All recipes have a specific number of hours in which they will take when you run them.

Now I wanted to run multiple recipes together but some of the recipes conflict with each other as they acquire the same systems. Therefore, other recipes can only wait until the systems have been released for acquiring.

How can I teach excel to plan out a schedule if I pick some recipes out from the library which some of them acquire the same systems.

Please see attached for the working excel sheet. As I wanted flexibility in choosing my recipes, I have done up a VLOOKUP table for your convenience.

Hope you can help me!!

 

[alansidman]

crossposted: how to let excel plan out work schedule by itself based on conflicting criteria

 

[Peter_SSs]

Please review our Forum Rules, especially in relation to cross-posting, and then update your thread with any other relevant links. Thanks.

 

[Phenomi]

Hi sorry for cross posting, here is the original link of my question!

how to let excel plan out work schedule by itself based on conflicting criteria

Hi guys, Need some help here. I have a library of recipes which acquire several systems. All recipes have a specific number of hours in which they will take when you run them. Now I wanted to run multiple recipes together but some of the recipes conflict with each other as they...

www.excelforum.com