Carton box stuffing calculator

Hello I'am new here
I work as material handling improvement
and My job is to design the handling method

Then I have the product list with carton dimension (A3:E18)
I would like you to help me create the formular for stuffing calculator
(by utilize box to dolly with any direction)
then return the Dolly number in column F.

This will realy help my to reduce the manual job and optimize delivery to reach maximum boxes per round

Note : The product have to seperate by Destination

Stuffing calculator.xlsx

This is a well known problem that is not so easy to solve:
https://en.wikipedia.org/wiki/Bin_packing_problem

Do you have a limited number of box sizes?

We need to know roughly how many different sizes a box can be (fewer is better). Ignoring orientation, your example only used 2 (30x10x10 and 20x10x10). Also, if every box has at least 1 dimension in common (10 cm in your example), can it be treated as multi-layer 2-dimensional problem, instead of 3-dimensional?

Also, packing instructions would need to include each box's orientation + position (or order of insertion, using rules of placement) within the specified dolly. If you have more than a few easily identifiable sizes, your packers would have to process a lot of information.