View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LiAD LiAD is offline
external usenet poster
 
Posts: 386
Default Solver with text

Hi,

I need solver to calculate the order to make certain products A B C etc.
Based on other numerical data, production time, date etc I can figure out
when products should be started and finished. However I would like excel
solver to re-arrange the product list from A B C A B A B C to A A A B B B C
in order to minimise set-up time providing the products will be delivered on
time.

Is it possible for solver can do this product re-arrangement?