Excel Formula required for Container Allocation

[hrayani]

Hello Friends,

See below - if it can be achieved with a formula

Book1
	A	B	C	D	E
1	Volume	Result	Reason	Container Type	Capacity
2	1,515	23x40 HC + 1x20 STD	23x40-HC = 1,495 & remaining 20 in 1x20-STD	40-HC	65
3	120	1x10 HC + 1x20 STD	1x40-HC = 65 & remaining 55 in 1x40-STD	40-STD	55
4	56	1x40 STD + 1x20 STD	1x40-STD = 65 & remaining 1 in 1x20-STD	20-STD	20
5	25	1x20 STD	1x20-STD = 25
6	26	1x40 STD	1x40 STD = 55
7	145	2x40-HC + 1x20-STD	2x40-HC = 130 & remaining 15 in 1x20-STD	< Incorrect
8	145	1x40-HC + 1x40-STD + 1x20-STD	1x40-HC = 65 & 1x40-STD = 55 remaining 25 in 1x20-STD	< Correct
Sheet1

Regards,

Humayun

 

[RobP]

Just curious, before I even look at formula ... Line 8.

Your reason to fit 145 inside 1 x 40HC @ 65, 1x40SD @ 55, and then 1x20STD to fit remaining 25 ? I am curious how you fit the last 25 into a container you state has a size 20.

thanks to clarify ..

Rob

 

[hrayani]

Just curious, before I even look at formula ... Line 8.

Your reason to fit 145 inside 1 x 40HC @ 65, 1x40SD @ 55, and then 1x20STD to fit remaining 25 ? I am curious how you fit the last 25 into a container you state has a size 20.

thanks to clarify ..

Rob

Good Question

There is a typo in cell E4
Instead of writing 25 there I wrote 20..... My BAD!
It's a 20 size container which can hold 25 M3 (Volume) of goods

Pls see below with correction

Book3
	A	B	C	D	E
1	Volume	Result	Reason	Container Type	Capacity
2	1515	23x40 HC + 1x20 STD	23x40-HC = 1,495 & remaining 20 in 1x20-STD	40-HC	65
3	120	1x10 HC + 1x20 STD	1x40-HC = 65 & remaining 55 in 1x40-STD	40-STD	55
4	56	1x40 STD + 1x20 STD	1x40-STD = 65 & remaining 1 in 1x20-STD	20-STD	25
5	25	1x20 STD	1x20-STD = 25
6	26	1x40 STD	1x40 STD = 55
7	145	2x40-HC + 1x20-STD	2x40-HC = 130 & remaining 15 in 1x20-STD	< Incorrect
8	145	1x40-HC + 1x40-STD + 1x20-STD	1x40-HC = 65 & 1x40-STD = 55 remaining 25 in 1x20-STD	< Correct
Sheet1