Schedule Builder

Is it possible to write a code that builds a monthly schedule for employees? The problem is that I need varying levels of coverage during different times of the month. For example, I need about 65% of my staff working on weekends and less on weekdays. Additionally, special events and holidays need extra staffing.

I ususally build these schedules by hand, but it's becoming cumbersome. I'm familiar with VBA, but I've never seen or written a code that could build something like this from scratch. The most difficult thing about this process is building around the company work rules. They are as follows:

1. Working days cannot exceed 6 in a row
   • 3,4,or 5 days in a row are preferred
   • If there is a block of 5 or 6 days in a row, there must be 3 days off following (including the end of the month)
2. No single days working - minimum of 2 work days in a row (except for the first and/or last day(s) of the month)
3. Must have 3 days off between groups of work days, with the following exceptions:
   • The first and/or last day of the month can be a single day off
   • There can only be one block of 2 days off but it can only occur within the first 6 days of the month
4. Total days working in the month can not exceed 19 (this can/will change in the future, but for this month it's pretty much static)
5. The employees in my example are represented by A, B, C, etc. but the number of employees is variable and could change from one month to the next (In my example there are only 7 employees, but next month there could be more or there could be less)
6. Work days are to marked with an "x" and off days are blank
7. Each day of the month has a unique % target value

I have attached an example workbook.

FYI, I cross posted this issue, in the hopes that I might be able to get help with it.

Here is a link to the other post.