I’d like to have a VBA code that generates schedules to be ‘Covered’ based on a half hour interval planning distribution. For example, let’s say that from 6:00 AM to 8:00 AM I require 3 employees to cover the workload, but I only have 2 scheduled, then the VBA code will print a ‘To Cover’ schedule from 6:00 AM to 8:00 AM where the understaffing is located for the 1 employee missing to complete the required. I think this can be accomplished with VBA-Solver, unless you have a better approach.

• Additional details:

I have this half hour interval distribution planning:

As you see in image above:

• First column: Time Intervals.

• Second column (RQ): Required staff. This is basically the amount of ‘half hours’ I require to cover the workload.

• Third column (Staff): Number of ‘Half hours’ I have staffed for the interval.

• Fourth column (Diff.): Shows de difference between Staff-REQ.

Based on these columns I’m looking forward to getting this output:

One thing to consider is that I’d like to get the optimum number of ‘To Cover’ schedules, meaning that I’d like to avoid overstaffing to prevent unnecessary expenses, but at the same time, avoid being understaffed so I can handle the workload.