Dynamic programming in Excel

[Makafi]

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