Desctription of work: Distribution of actions for regular maintenance, which is carried out every Wednesday in the windows from 9:00 a.m. to 11:00 a.m (once per week)
Problem to solve: correct distribution of actions (an even distribution of sums of actions for every person involved in maintenance for each week) - picture
Constants
- number of repetitions per year.
- Gap between repetitions of actions (see picture or file)
- Available only two type of maintanance worker during maintenance from three types (Mechanic / Electronic / Electrician)
Variables: distribution (Arrangement) of the actions for the whole year
Can you solve this problem using VBA or any programming language?