+ Reply to Thread
Results 1 to 10 of 10

Best yield from table

Hybrid View

  1. #1
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Best yield from table

    I take that back - the above was not an accurate solution... is the below better ?

    I4:
    =INDEX(F$4:F$7,MATCH(MIN(IF(($F$4:$F$7>=$C$4)*($G$4:$G$7>=$D$4),MOD($F$4:$F$7,$C$4)*$D$4+MOD($G$4:$G$7,$D$4)*INT($F$4:$F$7/$C$4))),MOD($F$4:$F$7,$C$4)*$D$4+MOD($G$4:$G$7,$D$4)*INT($F$4:$F$7/$C$4),0))
    confirmed with CTRL + SHIFT + ENTER and copied to J4
    So waste is determined by: waste height * width + waste width * complete units (as determined by height)

    Example:

    250/175 would return 1250/350 rather than 500/230 given the former leaves no waste whatsoever
    Last edited by DonkeyOte; 09-08-2010 at 08:51 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1