How to split a number by date?

Question

excel

Hello
It is necessary to compare the size of the warehouse-order, in case of a match, decompose the total number from the warehouse into positions.
For example warehouse 45,
positions 40 and 10.
You need to decompose 40 and 5
excel file
https://drive.google.com/file/d/1vfjCd0mJSkonUqxvC...

Answer 1

=MIN(SUMIF(I:I;B3;J:J)-SUMMIF($B$1:B2;B3;$E$1:E2);D3)
splits like this.. but you need to start from the smallest in terms.