Hello everyone,
I have an difficult problem and i do not even know if this is possible in MS Excel.
The question is as follows:
The Excel file should automatically calculate the amount of palletlocations needed for storage.
<tbody>
</tbody>
In the table above you can see that normally on monday there are 5 pallets of boxes produced, with 4 different varations.
These pallets should be stacked.
- Variation 2 + (20 boxes of) variation 5
- Variation 4 + variation 10
Stacked pallets have the following rules regarding capacity:
1 pallet = 260 boxes maximum
2 pallets = 240 boxes maximum
3 pallets = 220 boxes maximum
4 pallets = 200 boxes maximum
Other rules in this calculation are as follows:
- The Variations (as shown in table) need to be stacked together on one pallet!
example: 280 boxes = 260 on 1 pallet location and 20 remaining on another pallet, but these 20 may ofcourse be stacked.
I thought of multiple options (macro's, formulas) but all did not work out... I hope someone on the forum can help me.
If not completely clear, please react on this thread and i will try to explain further.
I have an difficult problem and i do not even know if this is possible in MS Excel.
The question is as follows:
The Excel file should automatically calculate the amount of palletlocations needed for storage.
Boxes | Monday | Tuesday |
Variation 1 | 0 | 0 |
Variation 2 | 140 | 130 |
Variation 3 | 0 | 110 |
Variation 4 | 140 | 120 |
Variation 5 | 280 | 190 |
Variation 6 | 0 | 0 |
Variation 7 | 0 | 0 |
Variation 8 | 0 | 0 |
Variation 9 | 0 | 0 |
Variation 10 | 60 | 110 |
Variation 11 | 0 | 110 |
<tbody>
</tbody>
In the table above you can see that normally on monday there are 5 pallets of boxes produced, with 4 different varations.
These pallets should be stacked.
- Variation 2 + (20 boxes of) variation 5
- Variation 4 + variation 10
Stacked pallets have the following rules regarding capacity:
1 pallet = 260 boxes maximum
2 pallets = 240 boxes maximum
3 pallets = 220 boxes maximum
4 pallets = 200 boxes maximum
Other rules in this calculation are as follows:
- The Variations (as shown in table) need to be stacked together on one pallet!
example: 280 boxes = 260 on 1 pallet location and 20 remaining on another pallet, but these 20 may ofcourse be stacked.
I thought of multiple options (macro's, formulas) but all did not work out... I hope someone on the forum can help me.
If not completely clear, please react on this thread and i will try to explain further.