NWoodard

New Member
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,

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

oldbrewer

Board Regular
what does cube a trailer mean please ?

NWoodard

New Member
Cubing a trailer means filling it up. Essentially, we would have several different pallets (different sizes, weights etc.) and I would like t have an excel spreadsheet that shows the trailer filling up to its max (either weight or space, whatever comes first).

Below is a link to an online tool which completes this, but I do not want to use this tool for our 200+ trucks a day.

oldbrewer

Board Regular
if pallets are different widths and lengths they may leave a lot of redundant space - unless they are cunningly sized...

oldbrewer

Board Regular
if you said each trailer carries a maximum of 10 pallets and pallets are either 6 ft by 6 ft OR 6 ft by 3 ft then we can make a start........

NWoodard

New Member
Below is an example of some of the data I work with. We have 15 different part numbers, but only use 5 different containers (for this customer). The length, width and height of the package will be set (same with the trailer). I can quickly identify how many pallets are allowed to go beside one another, and how many can stack on top of one another if that helps. Essentially, the customer tells us how many pieces of a part they want, we determine how many pallets that is, and then have to determine how many trucks that is. We have a very manual, none visual way of completing this today, and we are looking to modernize it and provide visual templates to our drivers loading the material.

 PART # Rack Code Weight Pack Density L W H 1 a 1088 280 48 36 26 2 a 1087 280 48 36 26 3 a 1089 280 48 36 26 4 a 1081 280 48 36 26 5 a 868 420 48 36 26 6 a 860 420 48 36 26 7 b 1266 33 70 48 53 8 b 1269 33 70 48 53 9 c 1043 63 56 48 36 10 c 1127 72 56 48 53 11 c 968 54 56 48 53 12 d 1078 24 78 48 76 13 d 1076 24 78 48 76 14 e 1049 42 48 48 53 15 e 1056 42 48 48 53

<colgroup><col><col><col><col><col span="3"></colgroup><tbody>
</tbody>

oldbrewer

Board Regular
 is part 9 H= 36 ?

<tbody>
</tbody>

NWoodard

New Member
 9 c 1043 63 56 48 53 10 c 1127 72 56 48 53

<tbody>
</tbody>

Sorry, it should read 53 - the same as part 10 as it is the same pallet.

oldbrewer

Board Regular
if a lorry can carry say 20 of the 48 long, 15 of the 70 long, 18 of the 56 long and 10 of the 78 long and you check the weight of the 48, 70, 56 and 78 to ensure lorry not overloaded I do not see the issue - yet - lol. Why not go to a standard pallet size so say lorries carry 40 pallets unless weight reduces this....

NWoodard

New Member
Unfortunately our product shipping is different lengths/widths, thus calling for different pallet sizes!