Cumulative Sum using List.Accumulate with a twist

however Anonymous 

always ready to get some nice and tricky request by you 😄

Jimmy

Thanks again Jimmy.

I am looking through the results now and noticed a few instances where the bin's are being overfilled? 

Hey

could you please share you real-life file.

What does overfill mean? that the function has calculated for example calculated 20 bins, when the order would need 30?

However, please share the file

Jimmy

 Sure. I highlighted 4 instances where the sum of the rows for each assigned bin exceeds the max bin limit, 

Not sure how to share excel files here so I uploaded to Google Drive:

Let me know if you cannot receive the file

https://drive.google.com/open?id=1W2LOCnsevvRTTDcuaRHQ2mcVo-Eyy6Rz 

hello Anonymous 

this is a .csv file. Not possible to highlight there something. But nevertheless... don't understand .. we never talked about max bin limit... the number we calculated was always how many bins you need to ship the order, considereing the sku count and the max sku count per bin... so we this framework, how would it possible that something gets exceeded?

Bye

Jimmy

My apologies, excel file is uploaded. to google drive.

I think the excel file will show you some good examples. What I called Max Bin Limit is the same as max SKU Count per bin.

For example if I have 3 rows within 1 Order and SKU count for each of these 3 rows is 10 and I have a Max Bin of 10 for this Order Then I would use 3 Bins and each row would be a new Bin Used number. Said in other words, the value in Max Bin column is the max allowed number SKU Counts that can fit into a single Bin. Hope that clears it up? 

Hello Anonymous 

are  you kidden me?

I mean, I'm loosing here time to check and understand (already used too much time) and at the end you are presenting wrong data. I mean when you ask a professional you pay deerly for all this. I did it for free in a very professional way to help....

I've downloaded your data, applied my funciton and it works perfectly fine as you have requested... a running sum to understand at wich point you need a new bin. The data you are represending in the file was not calculated with my function. see enclosed your version, and my version

your data

your raw data calculated with my function

the next thing is that you asked for a running sum, considering thi SKU count till that order line... but not considering that if a complete order line has to placed into a new bin once it's not possilbe to place it fully in the bin used before. This does mean you cant do a valuation like you did.

In Other words...

line 1 44000

line 2 5000

the function says 1 for line 1 and 2 for line 2. for a third line he would count 44000, 5000 and checks if for line 3 you would need a third bin this means that line 2 with bin 2 indicated are considere to be placed 500 in bin 1. So how can you sum all bin nr. 2 and check if this exceeds the max bin? Doesn't make any sense.

Sorry, but I'm off

If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun

Jimmy

Jimmy801 Obviously you are frustrated. There has been assumptions on both of our ends that has created this. I know there is logic built in the function that determines when the Bin used increments up by 1. I thought it would be a simple fix to change that logic from whatever it is now to increment up once the runningsum exceeds the Max Bin value. I thought that was obvious but as this post has proven nothing can be assumed. If you wish to not continue that is your perogative and I will respect it. Thank you for your time and efforts.