This is fantastic! The only problem is that the free Solver tool is limited in how many variables you can solve for. However, the company Frontline sells upgraded Solver versions that can take more variables.
@cosmohj26
Жыл бұрын
hello, thank you for this video. How would i add an constraint that stops people working certain shifts? For example if a nurse works tuesday they cannot work thursday, or if a nurse works saturday they cannot work sunday? Thank you very much
@baileyshen5249
Жыл бұрын
Hmm, you could make another cell/constraint so that Tuesday + Thursday is less than or equal to one.
@Waleed-el5zu
6 ай бұрын
How can i add a constrain that days off have to be consecutive?
@TheOpenEducator
6 ай бұрын
You will find more here: www.theopeneducator.com/operations-and-supply-chain-management
Пікірлер: 6