Dynamic programming in Excel
 

Hi,

I want to create a program to help me with planning loading of trucks
On input I've got: truck dimensions (wide, lenght, height) an
different kind of assortments dimensions (also wide, lenght & height)
What I want on output - program should calculate optimal (free space -
min) arrangement of assortments on the truck.

I know that this kind of problems are resolved with dynamic programmin
algorithms (discrete knapsack problem) but I'm afraid my knowledge her
ends.

Does anyone knows the construction of algorithm (functions / VBA) tha
I could use to solve this? Any suggestions are welcome.

Makaf

--
Makaf
-----------------------------------------------------------------------
Makafi's Profile: http://www.excelforum.com/member.php...fo&userid=3082
View this thread: http://www.excelforum.com/showthread.php?threadid=50936