Hello to everyone in the forum!
I learned a lot seeing examples and reasoning that they used here on the forum, so I come to answer a question that I haven't been able to solve for months.
I have a column of values that I distribute among 3 clients, and I try to make the sum of each of the 3 as close as possible in the end.
VALUES 1,2,3 CUSTOMER A CUSTOMER B CUSTOMER C
2.00 1 2.00 0.00 0.00
3.00 1 0.00 3.00 0.00
8.00 2 4.00 0.00 4.00
10.00 2 0.00 5.00 5.00
15.00 3 5.00 5.00 5.00
1.00 1 1.00 0.00 0.00
sums 12.00 13.00 14.00
Attached is the spreadsheet of an example that I managed to get distributed between 2, but I can't have any reasoning for it to count as 3 people to be distributed.
Would anyone have a light to help me with this?
Thanks in advance.
Bookmarks