Solver Help
Errata....
On Jun 22, 10:26 pm, I wrote:
B16 computes the number of cuts. The formulas a
[....]
B16: =SUM(B2:B3,E1,G1:G2,I1:I3,K1:K2,M1) + 2*SUM(K3,M2:M3,O1:O2) +
3*Q1
I believe the formula for the number of cuts should be:
=B2+B3+E1+G1+I1 + 2*SUM(G2,I2:I3,K1:K3,M1:M2) + 3*SUM(M3,O1:O2,Q1)
I was counting the number of "+" in my labels. I overlooked the scrap
cut. I would not have made this mistake if I had included the scrap
length in my labels (e.g. 4+3+3+1 instead of 4+3+3).
Improvement....
I wrote:
7+5: E7: =I1
6+5: E8: =K1
5+5: E9: =M1
5+4+3: E10: =M2
5+3+3: E11: =M3
#5: E16: =sum(E7:E15,E9)
[ ....etc.... ]
I did not need to enumerate the patterns again. I could have referred
to the variable cells directly in the SUM() expression; e.g.
=sum(I1,K1,M1:M3). The above design just reflects my style; it makes
it easy to double-check.
|