Load Planning

[NWoodard]

Hello,

I am looking for a spread sheet which will allow me to "cube" a trailer based, either by weight or space. Trailer and pallet restrictions/dimensions will vary depending on the ship to destination. I am targeting an excel based program due to in house restrictions (I have found other software to perform the tasks but prefer excel).

Does anyone have a sheet already designed or created that may meet these requirements?

Thanks,

 

[oldbrewer]

..then I have no idea how to "fit" different size pallets onto a lorry footprint. ...maybe make your biggest pallet the only one you use ... or... have some blueprint layouts for different combinations of pallets in the form of posters on warehouse walls....

 

[oldbrewer]

if your lorry has a length L and a width W then pallet lengths should be L/8 L/6 L/4 L/3
and widths W/8 W/6 W/4 W/3 W/2

= 20 pallet sizes

 

[AhoyNC]

You may want to look at the following link. Under the video is a link to download the program and a PDF.
https://www.youtube.com/watch?v=-0MCkd-CjD0

I think you are going to find it rather difficult to do this in Excel and would be better off using one of the commercial programs available.