How to calculate a number of boxes on pallet

[Nipun Drong]

Hi,

I am working in a Airlines in Cargo Operations Department. So that most of the time we have to play with different sizes of cargo. It's quite tricky to load the different size of Cargo in pallet and maximize load factory. Sometimes, we have to plan odd-size cargo and it's kill time to calculate in a short time. Hence I am looking for quickest way to calculate and save the time. To resolve this issue, I am looking for a formulated Excel sheet where I can input the Pallet size, Box dimensions, Box piece and it is automatically calculate and advice me. Most importantly, the Excel also suggest a diagram can help me for better understanding.

Most of the time we use below size of pallets:

Width * Lengt
PAG- 88 x 125 inc
PLA- 60.4 x 125 inc
PMC-96 x 125 inc

After searching in the website, I found a site which similar as my expectations but not clear how to create the Excel in this way. So need a assistance. Ref link below for check and attached pictures a sample copy of excel format.

Redirecting

Appreciate if assist to create the Excel and share with me. It's humble request.

 

[johnnyL]

Redirecting

Appreciate if assist to create the Excel and share with me. It's humble request.

Did you download and look at the code from that link?

 

[Nipun Drong]

Did yo

The Excel is no more available and the guidelines is not clear. If possible please guide or assist to share.

 

[johnnyL]

The link is right there on the first page, marked as an answer. It is also on the 4th (last) page marked as answer. Hint JLLatham.

 

[Nipun Drong]

Did you download and look at the code from that link?

The link is right there on the first page, marked as an answer. It is also on the 4th (last) page marked as answer. Hint JLLatham.

Hi Sir,
Pls assist to download the Excel I am looking for your kind help.

 

[johnnyL]

Link to file

 

[Nipun Drong]

Link to file

Thanks a lot Sir.

 

[johnnyL]

You are Welcome.