Basically I would like to create a spreadsheet that does the same function as this website:
http://www.unihouse.co.uk/
Basically I would like to be able to enter expenses that need to be split between 6 people. Then the sheet should provide me with a kind of balance (i.e. who owes, and who needs to pay) and then provide me with an efficient way of who should pay back who.
For example, let's say due to expenses, the balance is as follows:
John: -$50
Phil: -$25
Erin: +$75
So obviously in this scenario, it is most efficient for John and Phil to just pay Erin direction, but I would like a more automatic way of doing this like it is done in Unihouse.
Any thoughts or suggestions would be greatly appreciated.
~Thanks!
http://www.unihouse.co.uk/
Basically I would like to be able to enter expenses that need to be split between 6 people. Then the sheet should provide me with a kind of balance (i.e. who owes, and who needs to pay) and then provide me with an efficient way of who should pay back who.
For example, let's say due to expenses, the balance is as follows:
John: -$50
Phil: -$25
Erin: +$75
So obviously in this scenario, it is most efficient for John and Phil to just pay Erin direction, but I would like a more automatic way of doing this like it is done in Unihouse.
Any thoughts or suggestions would be greatly appreciated.
~Thanks!