Help with Truck Load sheet

sampson32

Active Member
Joined
Jul 16, 2003
Messages
312
Hello,

I need some help/advice on a project I will be starting shortly. It’s very complicated.

We make and distribute lintels that consist of several different lengths/weights to our several branches.

The shipping department receives an excel spreadsheet (form) listing the quantities of specific lintels wanted.

Then the shipping department lists the different lintels and quantities in specific positions on an excel diagram (depicting the surface of a flat bed trailer) showing the workers exactly how each trailer must be loaded so the weight is distributed as evenly as possible.

The lintels are usually stacked 5 to a row.

This is a truncated example of the form with the trailer depiction – in this example 120 lintels (40 each of 3 different sizes) are ordered and the lintels placed on the trailer with the largest/heaviest to the front evenly distributed on both sides (5 lintels to a row/4 rows high) then the next size/weight down – again evenly distributed on both sides of the trailer.

On a fully loaded trailer we will place the largest/heaviest on the front and rear and work our way in to the center.

Considering the seemingly endless variations/combinations that are possible – I don’t know if automating this procedure in VBA is possible or even where to start.

If some kind soul has any ideas or can direct me to an existing post or website that can be of some assistance I would be extremely grateful.

Thank you,

Vinnie
Truck Sample.xls
ABCDEFGHI
1
2QUANFTIN
3210
436
540
64046
748
854
940510
1066
114076
1280
13
1420-7'6REG20-5'10REG20-4'6REG
15
16
17
18
19
20
21
22FRONTREAR
2320-7'6REG20-5'10REG20-4'6REG
24
25
26
27
28
29
30
31
Sheet1
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
L

Legacy 98055

Guest
It can be done. I have seen similiar algorithms for cutting wood. For example, the best combination of cuts taken from a standard stock dimension to fill an order. Very similiar to your problem. This would be a great challenge of the month question. I'll mention it to Von Pookster. The actual programming is out of my league. Search Google for "Knapsack Algorithm". I think this is what you will need.
 
L

Legacy 98055

Guest
Bump.

I would love to see this one solved. Where's Tusharm? :)
 

Forum statistics

Threads
1,144,163
Messages
5,722,853
Members
422,461
Latest member
kelleys315

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top