Spreadsheet: 222960d1363981936-group-companies-and-identify-the-ones-that-have-buyer-and-seller-net-out
Sheet: Sheet2

Flow Date | [NAME] | Deal Number | Counterparty | Point Of Title Transfer | Volume Group Pipeline | [NAME] | Actual Volume
2013-02-01 00:00:00 | Buyer | 74845 | Company 1 | ANR - SE Pool | ANR | 9800 | 9800 | 1 |  | Row Labels | Sum of Actual Volume
2013-02-01 00:00:00 | [NAME] | 69740 | Company 1 | ANR - SE Pool | ANR | -20000 | -20000 | 1 |  | Company 1 | -30200
2013-02-01 00:00:00 | [NAME] | 70080 | Company 1 | ANR - SE Pool | ANR | -10000 | -10000 | 1 |  | Buyer | 9800
2013-02-01 00:00:00 | [NAME] | 70139 | Company 1 | ANR - SE Pool | ANR | -10000 | -10000 | 1 |  | [NAME] | -40000
2013-02-01 00:00:00 | Buyer | 74829 | Company 2 | ANR - SE Pool | ANR | 5000 | 5000 | 2 |  | Company 2 | 6300
2013-02-01 00:00:00 | Buyer | 74846 | Company 2 | ANR - SE Pool | ANR | 1300 | 1300 | 2 |  | Buyer | 6300
2013-02-02 00:00:00 | [NAME] | 69740 | Company 3 | ANR - SE Pool | ANR | -20000 | -20000 | 3 |  | Company 3 | -159138
2013-02-02 00:00:00 | [NAME] | 70080 | Company 3 | ANR - SE Pool | ANR | -10000 | -10000 | 3 |  | [NAME] | -159138
2013-02-02 00:00:00 | [NAME] | 70139 | Company 3 | ANR - SE Pool | ANR | -10000 | -10000 | 3 |  | Company 4 | 9000
2013-02-03 00:00:00 | [NAME] | 69740 | Company 3 | ANR - SE Pool | ANR | -20000 | -19570 | 3 |  | Buyer | 9000
2013-02-03 00:00:00 | [NAME] | 70080 | Company 3 | ANR - SE Pool | ANR | -10000 | -9784 | 3 |  | Company 5 | -40000
2013-02-03 00:00:00 | [NAME] | 70139 | Company 3 | ANR - SE Pool | ANR | -10000 | -9784 | 3 |  | [NAME] | -40000
2013-02-04 00:00:00 | [NAME] | 69740 | Company 3 | ANR - SE Pool | ANR | -20000 | -20000 | 3 |  | Company 6 | -8400
2013-02-04 00:00:00 | [NAME] | 70080 | Company 3 | ANR - SE Pool | ANR | -10000 | -10000 | 3 |  | [NAME] | -8400
2013-02-04 00:00:00 | [NAME] | 70139 | Company 3 | ANR - SE Pool | ANR | -10000 | -10000 | 3 |  | Company 7 | -34500
2013-02-05 00:00:00 | [NAME] | 69740 | Company 3 | ANR - SE Pool | ANR | -20000 | -20000 | 3 |  | Buyer | 5500
2013-02-05 00:00:00 | [NAME] | 70080 | Company 3 | ANR - SE Pool | ANR | -10000 | -10000 | 3 |  | [NAME] | -40000
2013-02-05 00:00:00 | [NAME] | 70139 | Company 3 | ANR - SE Pool | ANR | -10000 | -10000 | 3 |  | Company 8 | -28800
2013-02-05 00:00:00 | Buyer | 74937 | Company 4 | ANR - SE Pool | ANR | 1000 | 1000 | 4 |  | [NAME] | -28800
2013-02-05 00:00:00 | Buyer | 74938 | Company 4 | ANR - SE Pool | ANR | 8000 | 8000 | 4 |  | Grand Total | -285738
2/6/2013 | [NAME] | 69740 | Company 5 | ANR - SE Pool | ANR | -20000 | -20000 | 5
2/6/2013 | [NAME] | 70080 | Company 5 | ANR - SE Pool | ANR | -10000 | -10000 | 5
2/6/2013 | [NAME] | 70139 | Company 5 | ANR - SE Pool | ANR | -10000 | -10000 | 5
2/6/2013 | [NAME] | 75036 | Company 6 | ANR - SE Pool | ANR | -3200 | -3200 | 6
2/6/2013 | [NAME] | 75037 | Company 6 | ANR - SE Pool | ANR | -5200 | -5200 | 6
2013-02-07 00:00:00 | Buyer | 75095 | Company 7 | ANR - SE Pool | ANR | 5500 | 5500 | 7
2013-02-07 00:00:00 | [NAME] | 69740 | Company 7 | ANR - SE Pool | ANR | -20000 | -20000 | 7
2013-02-07 00:00:00 | [NAME] | 70080 | Company 7 | ANR - SE Pool | ANR | -10000 | -10000 | 7
2013-02-07 00:00:00 | [NAME] | 70139 | Company 7 | ANR - SE Pool | ANR | -10000 | -10000 | 7
2013-02-07 00:00:00 | [NAME] | 75067 | Company 8 | ANR - SE Pool | ANR | -20000 | -20000 | 8
2013-02-07 00:00:00 | [NAME] | 75080 | Company 8 | ANR - SE Pool | ANR | -8800 | -8800 | 8