Forum Discussion
Calculating equal batches
Hi guys,
I have a question regarding the formula to use in order to calculate equal batches.
To be clearer, my order being different every day and my batches needing to be equal and containing between 100 and 200 units, an automated formula would save me a lot of time in calculating the numbers every day.
Hope some of you will be able to help.
Thank you in advance
Hi Jessica231
So there's probably a more elegant formula way of doing this but I've approached it using a table
Let me know if it works for you
13 Replies
- Hi
Could you attach a sample Excel file to help demonstrate what you want to achieve please,
Thanks
WynWyn Hopkins Thanks ! I hope this helps.
Basically my batches of red and blue always consist of 200 or 190 units so it quite easy to calculate.
On the other hand orange and purple batch size varies depending on my order. The important thing is for my batches to consist of between 100 and 200 units and be equal. I hope that makes sense.
As you probably guessed I m very new to this and not exactly well versed in excel terminology. I hope I provided the necessary info. Thanks again
So there's quite a few calculations going on here that I'll need some help to understand
Why does the Quantity represent. Quantity of what?
The yellow cell is taking the total Quantity and splitting it by 200 items to get the number of batches of Red items
The Green cell is splitting it by 210 items (you mention 190 in your post) to get the number of batches of Blues
I'm not clear on what you want the formula to do for Orange or Purple?
