Loading Cargo with Excel

[LogCoord]

I'm hoping someone could give me a few pointers in trying to set up a spreadsheet. I'll lay it out:

-Setup is a list of trailers that contain a product (quantity is listed beside)
-Orders are loaded out of these trailers, orders are always 30,000 kg
-Two customers (A & B) cannot load out of the same trailer. For example, if 2 orders for customer A come out of trailer MT882 and the next order is for customer B, you must move to the next trailer down even if there is product remaining in the previous one. Orders for A and B are in sequence (i.e. AAAA, BBBBB not ABABABABBA etc.)

Basically in the available weight column I have a formula set up to show what remains in the trailer depending on the number of orders:

=IF(AND(D7>=B7,D7>0),B7,IF(D7<0,"0",IF(D7<B7,D7)))

I also have it set up to show Loading or Loading/Empty (with a 1000 tolerance)

=IF(AND(D7>1000,D7<B7),"LOADING",IF(B7<=D7,"",IF(D7<=1000,"LOADING/EMPTY")))

Basically, it works as I want it to except for the fact that I must jump to the next trailer when loading for the second customer. Can anyone propose a formula that would do that and still work with the Loading/Empty display?

Below, the correct sequence would be:

Loading/Empty
Loading
Loading/Empty
Loading
8.JPG

[tony h]

It might be worth uploading the spreadsheet