Hello
After the holidays we wanted to sort out who has to pay whom how much. We used the App Splitwise, though not all people spent the whole holidays together. So i set up 4 different Groups in Splitwise.
Now everybody would have to do multiple transactions because we have 4 groups.
I started doing everything manually in Excel using this template: http://www.herber.de/bbs/user/70975.xls
From each of the four tables I calculated the average amount (what everybody should have spent in the end) together --> Column C
Persons A,B,C,D,E spent the whole holidays together. Thats way the all need to pay the same amount
Person F left ealier. So he has to pay less
Persons G and H came later and left ealier. Thats why the have to pay even more less.
Now my question is how do I calculated who has to pay whom how much. So not everybody has to make multiple transactions.
Using Office 2013
Attachment 530405
thank you
Bookmarks