That is perfect; interested to see the linear model!
One followup question. Is it possible to add the constraint that the entry cells B7:B9 cannot be more than 1 step (integer) more than their starting integer? I.E. if it started as 1, 1, 1 the final values could not be higher than 2, 2, 2.
Not sure how to do that efficiently in solver!
Bookmarks