Thread: Excel Functions
View Single Post
  #1   Report Post  
ChrisA
 
Posts: n/a
Default Excel Functions

Is there a way in Excel to produce results for the following problem:

Let's say I have a pipe to be installed that is 120 ft. long.

There are three lengths of pipe that I can use 8', 6', and 4'. I want to
know ALL of the possibilities for construction.

Example: One solution would be (10) 8' pipes (4) 6' pipes, and (4) 4' pipes.
I want to know ALL of the solutions.

Thanks

Chris

P.S. I know how to find the optimal solution with the solver (ie. lowest
cost) but still need to know all of the possibilities.