Placing An Auto-shape based on dimensions of (L*W*H)

[mohammedalkhatim]

Hi everyone,

sometimes i may need to make a load plan for a special cargo different the normal cargo per ton; and the calculation has to be different, as it takes space nor than weight and it called vole-metric ton.

To handle this kind of stuff, I made an acquisition which will calculate the dimensions for (L*W*H) and divide the total available space in the barge by the sum of calculation then divided again by the actual barge capacity ( about 400 tons).

However, I 'am looking for something that would enable me to enter a dimension for e.g. Light vehicle, Truck...etc, and automatically generates a shape into a predefined area accordingly.

For example, I want to load a barge by number of light vehicles, and the barge loading area has already placed on excel by dimensions, I just want to enter the dimension (L*W*H) and automatically it has to calculate how many items of this light vehicle I would be able to load and place this calculation as visualized loading plan using shape.

CHECK THE ATTACHED FILE