Spreadsheet: 862560d1710254111-how-to-use-solver-new-user-solver_-hydr-
Sheet: Sheet1

 |  | Working min | Total Minutes | Total Operator | Target Output
 |  | 480 |  | 14 | 259
Operation Minutes
Operation | Machine Type | Operator 1 | Operator 2 | Operator 3 | Operator 4 | Operator 5 | Operator 6 | Operator 7 | Operator 8 | Operator 9 | Operator 10 | Operator 11 | Operator 12 | Operator 13 | Operator 14
OP03-402 | A | 1.72 | 1.72 | 1.72 | 1.72 | 1.72 | 1.72 | 1.72 | 1.72 | 1.72 | 1.72 | 1.72 | 1.72 | 1.72 | 1.72
OP03-102 | A | 1.51 | 1.51 | 1.51 | 1.51 | 1.51 | 1.51 | 1.51 | 1.51 | 1.51 | 1.51 | 1.51 | 1.51 | 1.51 | 1.51
OP03-413 | B | 4.72 | 4.72 | 4.72 | 4.72 | 4.72 | 4.72 | 4.72 | 4.72 | 4.72 | 4.72 | 4.72 | 4.72 | 4.72 | 4.72
OP03-107 | B | 5.44 | 5.44 | 5.44 | 5.44 | 5.44 | 5.44 | 5.44 | 5.44 | 5.44 | 5.44 | 5.44 | 5.44 | 5.44 | 5.44
OP03-212 | B | 4.65 | 4.65 | 4.65 | 4.65 | 4.65 | 4.65 | 4.65 | 4.65 | 4.65 | 4.65 | 4.65 | 4.65 | 4.65 | 4.65
OP03-412 | B | 2.68 | 2.68 | 2.68 | 2.68 | 2.68 | 2.68 | 2.68 | 2.68 | 2.68 | 2.68 | 2.68 | 2.68 | 2.68 | 2.68
OP03-602 | B | 4.09 | 4.09 | 4.09 | 4.09 | 4.09 | 4.09 | 4.09 | 4.09 | 4.09 | 4.09 | 4.09 | 4.09 | 4.09 | 4.09
OP03-411 | B | 0.59 | 0.59 | 0.59 | 0.59 | 0.59 | 0.59 | 0.59 | 0.59 | 0.59 | 0.59 | 0.59 | 0.59 | 0.59 | 0.59
Qty/operator
Operation | Machine Type | Operator 1 | Operator 2 | Operator 3 | Operator 4 | Operator 5 | Operator 6 | Operator 7 | Operator 8 | Operator 9 | Operator 10 | Operator 11 | Operator 12 | Operator 13 | Operator 14 | Total | Target
OP03-402 | A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 51.69186046510968 | 207.3081395349016
OP03-102 | A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 259.0000000000055 | 0
OP03-413 | B | 0 | 0 | 0 | 6.576271186437962 | 0 | 101.6949152542336 | 101.6949152542474 | 0 | 49.03389830508515 | 0 | 0 | 0 | 0 | 0
OP03-107 | B | 0 | 0 | 0 | 82.52941176470918 | 88.23529411764733 | 0 | 0 | 88.2352941176438 | 0 | 0 | 0 | 0 | 0 | 0
OP03-212 | B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 52.54838709676403 | 103.2258064516175 | 103.2258064516294 | 0 | 0 | 0
OP03-412 | B | 0 | 142.0485074627006 | 115.3805970148977 | 0 | 0 | 0 | 0 | 0 | 1.570895522399775 | 0 | 0 | 0 | 0 | 0
OP03-602 | B | 117.3594132029444 | 24.28117359412285 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 117.3594132029307 | 7.405399629566908e-13 | 0
OP03-411 | B | 0 | 0 | 259.0000000000072 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Minutes
Working Minutes
 | Machine Time | Operator 1 | Operator 2 | Operator 3 | Operator 4 | Operator 5 | Operator 6 | Operator 7 | Operator 8 | Operator 9 | Operator 10 | Operator 11 | Operator 12 | Operator 13 | Operator 14
 | A
 | B
 | Binary vars | Operator 1 | Operator 2 | Operator 3 | Operator 4 | Operator 5 | Operator 6 | Operator 7 | Operator 8 | Operator 9 | Operator 10 | Operator 11 | Operator 12 | Operator 13 | Operator 14
 | A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1
 | B | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0
 | Constraint 1 | Operator 1 | Operator 2 | Operator 3 | Operator 4 | Operator 5 | Operator 6 | Operator 7 | Operator 8 | Operator 9 | Operator 10 | Operator 11 | Operator 12 | Operator 13 | Operator 14
 | Constraint 2 | Operator 1 | Operator 2 | Operator 3 | Operator 4 | Operator 5 | Operator 6 | Operator 7 | Operator 8 | Operator 9 | Operator 10 | Operator 11 | Operator 12 | Operator 13 | Operator 14
 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1