After going with friends a couple times, paying, others paying, and waited to get billed from the payers. The most painful time is when we have to settle all those bills with different payers, trying to offset with each other, and finally give up to seperately repay.
So I decided to create this spreadsheet to settle all the expenses of the trip. Yes, this can automaticly offset against each payer!