Hi All, I have been trying to use Excel Solver to write what should be a simple solution but I do need assistance to get me started.
My Goal is  create enough 28 day roster profiles (with work days and days off) that meet the following rules. Each roster line must:
regards
GB
My Goal is  create enough 28 day roster profiles (with work days and days off) that meet the following rules. Each roster line must:
 contain 8 days off in 4 lots of day off pairs, and
 paired days off can't be less than 3 days apart, and
 paired days off can't be more than 6 days apart, and
 contain a minimum of 1 weekend off, and
 the "Total Work Days" (blank days) must be equal to or exceed the required "Daily Work Requirement"
regards
GB
Attachments

26 KB Views: 7