J
joserabanales
I want to divide a total (lets say 1,000 pounds produced) into many groups with a given size (lets say 3 batches BatchA - 500 punds, batchB - 300 punds and BatchC 400 pounds).
What I want its to fill those batches and reduce the total. Obtaining the result of Batches A and B filled and batchC empty because its not enough production to fill it and my total (pounds produced) reduced to 200 pounds because its what its left)
In other words i want to apply some formula to what is on the left and obtain what is on the right
Total product 1 1000 Total product 1 200
Total product 2 500 Total product 2 100
Product Size Assigned Product Size Assigned
A Product 1 500 A Product 1 500 500
B Product 1 300 B Product 1 300 300
B Product 2 400 B Product 2 400 400
C Product 1 400 C Product 1 400
What I want its to fill those batches and reduce the total. Obtaining the result of Batches A and B filled and batchC empty because its not enough production to fill it and my total (pounds produced) reduced to 200 pounds because its what its left)
In other words i want to apply some formula to what is on the left and obtain what is on the right
Total product 1 1000 Total product 1 200
Total product 2 500 Total product 2 100
Product Size Assigned Product Size Assigned
A Product 1 500 A Product 1 500 500
B Product 1 300 B Product 1 300 300
B Product 2 400 B Product 2 400 400
C Product 1 400 C Product 1 400