Knowing that excel can be use to solver the rostering problem by using SOLVER . Instead of setting the changing cells to "binary mode"(1 represent is working day and 0 is an off day). Because need to deal with different shift in a day, can we set the changing cells to "integer mode"?(different number represent different shift). But i stuck when i want to set a minimum number of ppl in every shift. Can any expert please enlight me?
Thank you very much..