Hi All,
I am trying to find an automated scheduling solution that could significantly save time. Attached is a sample file. I believe this could be done with either solver or a macro, neither of which I have much knowledge in.
Coming to the problem, I am trying to schedule machines that have a certain output profile. When brought online, each machine produces certain widgets based on it profile. These machines needs to be brought online in such a way that the daily average is mainted between 5-7, The way I do it now is, I would have to play with the online dates to maintain that average. I am too many machines and this is a very tedious process. I think this could be achieved either by solver or macro, either of which I have much knowledge in.
Any help would be really appreciated.
Thanks,
Abhi
I am trying to find an automated scheduling solution that could significantly save time. Attached is a sample file. I believe this could be done with either solver or a macro, neither of which I have much knowledge in.
Coming to the problem, I am trying to schedule machines that have a certain output profile. When brought online, each machine produces certain widgets based on it profile. These machines needs to be brought online in such a way that the daily average is mainted between 5-7, The way I do it now is, I would have to play with the online dates to maintain that average. I am too many machines and this is a very tedious process. I think this could be achieved either by solver or macro, either of which I have much knowledge in.
Any help would be really appreciated.
Thanks,
Abhi