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
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 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | |||||||||||
2 | QUAN | FT | IN | ||||||||
3 | 2 | 10 | |||||||||
4 | 3 | 6 | |||||||||
5 | 4 | 0 | |||||||||
6 | 40 | 4 | 6 | ||||||||
7 | 4 | 8 | |||||||||
8 | 5 | 4 | |||||||||
9 | 40 | 5 | 10 | ||||||||
10 | 6 | 6 | |||||||||
11 | 40 | 7 | 6 | ||||||||
12 | 8 | 0 | |||||||||
13 | |||||||||||
14 | 20-7'6REG | 20-5'10REG | 20-4'6REG | ||||||||
15 | |||||||||||
16 | |||||||||||
17 | |||||||||||
18 | |||||||||||
19 | |||||||||||
20 | |||||||||||
21 | |||||||||||
22 | FRONT | REAR | |||||||||
23 | 20-7'6REG | 20-5'10REG | 20-4'6REG | ||||||||
24 | |||||||||||
25 | |||||||||||
26 | |||||||||||
27 | |||||||||||
28 | |||||||||||
29 | |||||||||||
30 | |||||||||||
31 | |||||||||||
Sheet1 |