Re: Solver Help

Errata....

On Jun 22, 10:26 pm, I wrote:
B16 computes the number of cuts. The formulas are:
[....]
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.

.

Relevant Pages

  • Re: An observation...anyone agree?
    ... meet the design critera, at a resonable material or machining cost. ... OEE is the composite measure of three things, 1) equipment availablility, ... Productivity: The number of parts that would be theoretically possible ... Scrap: ...
    (alt.machines.cnc)
  • Re: pseudo-random key generator, not bad says i
    ... Or scrap the design... ... I'd scrap it alltogether. ... You're clearly not qualified to design a stream cipher "for use" right ... Faster more secure stream ciphers already exist. ...
    (sci.crypt)
  • Re: Sheesh!
    ... E. Walter Le Roy wrote: ... own design, made from scrap pieces picked up here and there. ...
    (rec.crafts.metalworking)
  • Re: The 2009 Worldcon Will Be In...
    ... is that environmental regulations make it uneconomic to scrap ... but features of the design are still considered ... sufficiently secret that transferring them overseas for scrapping ...
    (rec.arts.sf.fandom)