| | | | | | | | | | | | | | | | | | | | | | | |
. | 120.00 | | | | | | | | | | Dinner paid by Alice | 120.00 | 0.00 | | 30.00 | 30.00 | 30.00 | 30.00 | | | | | |
. | | 300.00 | | | | | | | | | Hotel paid by Bob | 300.00 | 0.00 | | 75.00 | 75.00 | 75.00 | 75.00 | | | | | |
. | | 10.00 | 30.00 | | | | | | | | Default to even split (see right formula) | 40.00 | 0.00 | | 10.00 | 10.00 | 10.00 | 10.00 | | | | | |
. | | | 100.00 | | | | | | | | Example: uneven split | 100.00 | 0.00 | | 50.00 | 10.00 | 20.00 | 20.00 | | | | | |
. | 10.00 | | | -10.00 | | | | | | | Example: Alice paid 10 for Dave | 0.00 | 0.00 | | 0.00 | 0.00 | 0.00 | 0.00 | | | | | |
. | 100.00 | | | | | | | | | | Example: wrong row | 100.00 | 20.00 | | 50.00 | 10.00 | 10.00 | 10.00 | | | | | |
. | | | | | | | | | | | | 0.00 | 0.00 | | 0.00 | 0.00 | 0.00 | 0.00 | | | | | |
. | | | | | | | | | | | | 0.00 | 0.00 | | 0.00 | 0.00 | 0.00 | 0.00 | | | | | |
. | | | | | | | | | | | | 0.00 | 0.00 | | 0.00 | 0.00 | 0.00 | 0.00 | | | | | |
. | | | | | | | | | | | | 0.00 | 0.00 | | 0.00 | 0.00 | 0.00 | 0.00 | | | | | |
. | | | | | | | | | | | | 0.00 | 0.00 | | 0.00 | 0.00 | 0.00 | 0.00 | | | | | |
. | | | | | | | | | | | | 0.00 | 0.00 | | 0.00 | 0.00 | 0.00 | 0.00 | | | | | |
. | | | | | | | | | | | | 0.00 | 0.00 | | 0.00 | 0.00 | 0.00 | 0.00 | | | | | |
. | | | | | | | | | | | | 0.00 | 0.00 | | 0.00 | 0.00 | 0.00 | 0.00 | | | | | |
. | | | | | | | | | | | | 0.00 | 0.00 | | 0.00 | 0.00 | 0.00 | 0.00 | | | | | |
. | (stop at this line, but you can insert rows above) | | | | | | | | | | | | | | | | | | | | | | |
. | | | | | | | | | | | | | | | | | | | | | | | |
. | Net (negative=pay, positive=receive) | | | | | | | | | | Average per person | 165.00 | | | | | | | | | | | |
. | 15.00 | 175.00 | -15.00 | -155.00 | | | | | | | | | | | | | | | | | | | |