Does anyone know if there's a way to limit the number of variables solver gives you? I have a slitting optimizer where the user is to select a "Raw" material# and the pivot table will then show all the different "Semi" materials/slits that can be cut out of that Raw material (there can be up to 10 or less different Semi materials that come out of one Raw material #). The user can also specify below what usage % they want solver to ignore, which I've built in with formulas. I have helper columns to force it to calculate at least one slit for every Semi material, except for the first help column which I want to look at only the largest usage item.
My question is can I force Solver to only give me 3 or less different slit widths in each scenario (shown in the #Slits columns). If you look at column M (under #Slits2) you see it gave me 4 different slit widths but I need to limit it to 3 or less.
Thanks in advance!
Bookmarks