Hi everybody

i'm trying that Solver finds the best way to schedule several machines

I have a table with 15 rows (4-18) the machines and 21 columns for the 7
days/3 shifts (B:V)

these would be the changing cells
1rs constraint: binary to know if the machine is on (1) or off (0) on that
shift

column W sums the row total, and I have on column X how many shifts the
machine should be working
2nd constraint: W=X

row 19 sums the column total, and it should be equal or less that the
available machines per shift, shown in row 20
3rd constraint: 19<=20

since it's better to group the working shifts per machine
one approach to solve this was to use a secondary mirrow table
where it would be adding the mirrowd cell to the one that is before
(ie. for cell B4, its mirrow cell its AB4
for B5, the mirrow cell is AB5 with value of B5+AB4, and so on)
at the end, sum each mirrow row and get a grand total
this would be the target cell and objective: maximize)

i need help to add constraints and/or modify the target cell cause right now
i only get the message:
"Too many adjustable cells"