View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Makafi Makafi is offline
external usenet poster
 
Posts: 1
Default 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