Owes macro enabled format. Old : owes
TinyGraphsFn
"CheckStrLens3.xls" "lastIndexOf.xls" "LatestFolder.xls" "Quiz.xls" "readme.html"
Owes is not what you would expect, but is an answer to a stackoverflow question :
I have a group of people who have different expenses during a period. Everybody has a balance after this period. It looks like this in excel:
Person A: 6
Person B: 10
Person C: -7,5
Person D: -8,5
After this period a settlement will take place. I currently do this by manually. This results in:
Person C pays 6 to person A.
Person C pays 1,5 to person B.
Person D pays 8,5 to person B.
Person A gets 6 from person C.
Person B gets 1,5 form person C.
Peron B gets 8,5 from person D.
(There are multiple solutions possible when more persons are involved.)
The problem is that I have to apply this procedure for a big group of people. So my question is: 'How to apply this 'who owes who'-procedure by using an excel spreadsheet algorithm or macro?'.
Assumed left-right default answer to iron out when one person can give to more than one person. So this is one possible solution.