Split / divide a number according to another number | ex: 750 | 250 | = 250 250 250

Hello,

I am trying to make a production schedule that will sort total order value into days according to max daily capacity, something like:

capacity amount could be different for different orders

order (piece) capaticy 01.03 02.03 03.03 04.03 05.03 06.03
1. 650 250 250 250 150
2. 1000 450 300 450 250
3. 3750 2000 1750 2000


I am asking to excel gurus how can i make a formula like this? I need to do it as i did on my excel file
Here my excel file
SAMPLE.xlsx

Originally Posted by zottiri

Hello,

I am asking to excel gurus how can i make a formula like this? I need to do it as i did on my excel file
Here my excel file
Attachment 379661

1) At cell F2, use the formula

Formula:

=IF(SUM(E7:$E7)>=$D2,"",MIN($C2,$D2-SUM(E7:$E7)))

Copy cross for F2:AM2

and
2) at cell F3

Formula:

=IF(SUM($E7:F7)<$D2,"",IF(F7<>"",$C3-F7,IF(SUM(E8:$E8)>=$D3,"",MIN($C3,$D3-SUM(E8:$E8)))))

copy cross-down for F3:AM5

Sorry, having a mistake

Plz change to 7 to 2 and 8 to 3 in both 2 formulas

Plz, change to these
1) F2:

Formula:

=IF(SUM(E2:$E2)>=$D2,"",MIN($C2,$D2-SUM(E2:$E2)))

copy to F2:AM2

2) at cell F3

Formula:

=IF(SUM($E2:F2)<$D2,"",IF(F2<>"",$C3-F2,IF(SUM(E3:$E3)>=$D3,"",MIN($C3,$D3-SUM(E3:$E3)))))

copy to F3:AM5

Originally Posted by zottiri

I experienced fatal errors with formula, can someone help about the issue?
Attachment 380373
here is the file, some values are negative and some calculations are wrong.

Use these formulas

* cell G3 (like as the old solution)

Formula:

=IF(SUM(F3:$F3)>=$E3,"",MIN($C3,$E3-SUM(F3:$F3)))

copy to row 3: G3:BI3

* cell G4

Formula:

=IF(SUM($F3:G3)<$E3,"",IF(G3<>"",MIN($C4-G3*($C4>G3),$E4),IF(SUM($F4:F4)>=$E4,"",MIN($C4,$E4-SUM($F4:F4)))))

Copy to G4:BI12

Don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding.

Try in F2:

=MIN($C2,$D2-SUM($E2:E2))

Drag accross to column AM

F3:

=MIN($C3,$D3-SUM($E3:E3))-SUM(F$2:F2)

Drag accross to column AM

F4:

=IF(F3=$C3,0,IF(SUM(F$2:F2)>0,0,MIN($C4,$D4-SUM($E4:E4))-SUM(F$2:F3)))

Drag F4 down and accross to column AM