Spreadsheet: 697812d1601553650-solved-help-analyzing-data-in-a-table-shared-expense-who-owes-whom-splitting-costs-tactics-pq
Sheet: method 2

 |  |  |  |  |  |  |  |  | -1
Date | Credit | Debit | Amount | Project |  | Debit | Credit | Amount |  |  | Credit | Debit | Sum of Amount
2018-11-17 00:00:00 | [NAME] | Adam | -1000 | Proj-5 |  | Adam | [NAME] | 1000 |  |  | Adam | [NAME] | 3260
2019-03-15 00:00:00 | [NAME] | Ellen | -280 | Proj-6 |  | Ellen | [NAME] | 280 |  |  | Adam | Ellen | 2000
2017-04-10 00:00:00 | Adam | [NAME] | -150 | Proj-8 |  | [NAME] | Adam | 150 |  |  | Adam | Emma | 1470
2018-12-07 00:00:00 | [NAME] | Adam | -1000 | Proj-5 |  | Adam | [NAME] | 1000 |  |  | [NAME] | Adam | 1380
2017-06-10 00:00:00 | Adam | [NAME] | -320 | Proj-5 |  | [NAME] | Adam | 320 |  |  | [NAME] | Emily | 400
2019-08-15 00:00:00 | Ellen | Emily | -700 | Proj-8 |  | Emily | Ellen | 700 |  |  | Ellen | [NAME] | 850
2019-04-20 00:00:00 | [NAME] | Adam | -1000 | Proj-5 |  | Adam | [NAME] | 1000 |  |  | Ellen | Emma | 3400
2020-04-30 00:00:00 | Adam | [NAME] | -200 | Proj-3 |  | [NAME] | Adam | 200 |  |  | Emily | Adam | 185
2019-02-15 00:00:00 | Adam | [NAME] | -2000 | Proj-5 |  | [NAME] | Adam | 2000 |  |  | Emily | [NAME] | 650
2019-01-09 00:00:00 | [NAME] | Ellen | -1700 | Proj-2 |  | Ellen | [NAME] | 1700 |  |  | Emily | Ellen | 1000
2018-08-26 00:00:00 | [NAME] | Adam | -500 | Proj-5 |  | Adam | [NAME] | 500 |  |  | Emily | [NAME] | 360
2017-04-10 00:00:00 | Adam | [NAME] | -180 | Proj-8 |  | [NAME] | Adam | 180 |  |  | [NAME] | Adam | 1205
2019-11-28 00:00:00 | Ellen | [NAME] | -400 | Proj-9 |  | [NAME] | Ellen | 400 |  |  | [NAME] | [NAME] | 2350
2018-08-02 00:00:00 | Emma | Adam | -920 | Proj-10 |  | Adam | Emma | 920 |  |  | [NAME] | Ellen | 220
2017-06-04 00:00:00 | [NAME] | Adam | -1000 | Proj-5 |  | Adam | [NAME] | 1000
2018-11-23 00:00:00 | Ellen | Adam | -1500 | Proj-6 |  | Adam | Ellen | 1500
2017-06-02 00:00:00 | Adam | [NAME] | -280 | Proj-1 |  | [NAME] | Adam | 280
2018-09-27 00:00:00 | [NAME] | Adam | -1170 | Proj-5 |  | Adam | [NAME] | 1170
2018-04-15 00:00:00 | [NAME] | [NAME] | -1000 | Proj-5 |  | [NAME] | [NAME] | 1000
2020-04-22 00:00:00 | Adam | [NAME] | -400 | Proj-3 |  | [NAME] | Adam | 400
2018-07-12 00:00:00 | [NAME] | Adam | -495 | Proj-5 |  | Adam | [NAME] | 495
2019-11-13 00:00:00 | Emily | [NAME] | -650 | Proj-9 |  | [NAME] | Emily | 650
2019-08-19 00:00:00 | Ellen | [NAME] | -500 | Proj-8 |  | [NAME] | Ellen | 500
2018-04-15 00:00:00 | [NAME] | Adam | -500 | Proj-5 |  | Adam | [NAME] | 500
2017-06-10 00:00:00 | Adam | [NAME] | -1000 | Proj-5 |  | [NAME] | Adam | 1000
2019-08-19 00:00:00 | Ellen | Emily | -300 | Proj-8 |  | Emily | Ellen | 300
2018-02-09 00:00:00 | [NAME] | Ellen | -400 | Proj-6 |  | Ellen | [NAME] | 400
2019-02-05 00:00:00 | Emma | Ellen | -3400 | Proj-7 |  | Ellen | Emma | 3400
2018-08-12 00:00:00 | Ellen | Adam | -500 | Proj-6 |  | Adam | Ellen | 500
2018-07-12 00:00:00 | Adam | [NAME] | -350 | Proj-5 |  | [NAME] | Adam | 350
2018-11-07 00:00:00 | Adam | Emily | -185 | Proj-6 |  | Emily | Adam | 185
2019-11-20 00:00:00 | Adam | [NAME] | -300 | Proj-9 |  | [NAME] | Adam | 300
2019-03-15 00:00:00 | [NAME] | Emily | -360 | Proj-6 |  | Emily | [NAME] | 360
2018-08-04 00:00:00 | [NAME] | Emily | -250 | Proj-1 |  | Emily | [NAME] | 250
2018-08-15 00:00:00 | Adam | [NAME] | -2000 | Proj-5 |  | [NAME] | Adam | 2000
2020-04-26 00:00:00 | Adam | [NAME] | -250 | Proj-3 |  | [NAME] | Adam | 250
2019-11-20 00:00:00 | Adam | [NAME] | -450 | Proj-9 |  | [NAME] | Adam | 450
2018-07-09 00:00:00 | [NAME] | [NAME] | -350 | Proj-5 |  | [NAME] | [NAME] | 350
2018-10-05 00:00:00 | Emma | Adam | -550 | Proj-5 |  | Adam | Emma | 550
2019-11-25 00:00:00 | Ellen | [NAME] | -300 | Proj-9 |  | [NAME] | Ellen | 300
2019-11-24 00:00:00 | [NAME] | Emily | -650 | Proj-4 |  | Emily | [NAME] | 650
2017-04-10 00:00:00 | Adam | [NAME] | -105 | Proj-10 |  | [NAME] | Adam | 105
2017-07-10 00:00:00 | Adam | [NAME] | -2000 | Proj-5 |  | [NAME] | Adam | 2000
2018-10-31 00:00:00 | [NAME] | Adam | -1500 | Proj-5 |  | Adam | [NAME] | 1500
2019-11-05 00:00:00 | Ellen | [NAME] | -400 | Proj-3 |  | [NAME] | Ellen | 400
2018-02-13 00:00:00 | [NAME] | Adam | -1000 | Proj-5 |  | Adam | [NAME] | 1000
2018-04-24 00:00:00 | [NAME] | Adam | -495 | Proj-5 |  | Adam | [NAME] | 495
2018-04-11 00:00:00 | [NAME] | Adam | -1000 | Proj-5 |  | Adam | [NAME] | 1000
2019-12-23 00:00:00 | Ellen | [NAME] | -150 | Proj-1 |  | [NAME] | Ellen | 150
2018-06-28 00:00:00 | [NAME] | [NAME] | -1000 | Proj-5 |  | [NAME] | [NAME] | 1000
 | Adam | [NAME] | 1000
 | Ellen | [NAME] | 280
 | [NAME] | Adam | 150
 | Adam | [NAME] | 1000
 | [NAME] | Adam | 320
 | Emily | Ellen | 700
 | Adam | [NAME] | 1000
 | [NAME] | Adam | 200
 | [NAME] | Adam | 2000
 | Ellen | [NAME] | 1700
 | Adam | [NAME] | 500
 | [NAME] | Adam | 180
 | [NAME] | Ellen | 400
 | Adam | Emma | 920
 | Adam | [NAME] | 1000
 | Adam | Ellen | 1500
 | [NAME] | Adam | 280
 | Adam | [NAME] | 1170
 | [NAME] | [NAME] | 1000
 | [NAME] | Adam | 400
 | Adam | [NAME] | 495
 | [NAME] | Emily | 650
 | [NAME] | Ellen | 500
 | Adam | [NAME] | 500
 | [NAME] | Adam | 1000
 | Emily | Ellen | 300
 | Ellen | [NAME] | 400
 | Ellen | Emma | 3400
 | Adam | Ellen | 500
 | [NAME] | Adam | 350
 | Emily | Adam | 185
 | [NAME] | Adam | 300
 | Emily | [NAME] | 360
 | Emily | [NAME] | 250
 | [NAME] | Adam | 2000
 | [NAME] | Adam | 250
 | [NAME] | Adam | 450
 | [NAME] | [NAME] | 350
 | Adam | Emma | 550
 | [NAME] | Ellen | 300
 | Emily | [NAME] | 650
 | [NAME] | Adam | 105
 | [NAME] | Adam | 2000
 | Adam | [NAME] | 1500
 | [NAME] | Ellen | 400
 | Adam | [NAME] | 1000
 | Adam | [NAME] | 495
 | Adam | [NAME] | 1000
 | [NAME] | Ellen | 150
 | [NAME] | [NAME] | 1000