Spreadsheet: 37422d1235437701-sumif-formula-based-on-text-in-cell-mellon-test
Sheet: Data Dump

AS OF DATE |  |  | CURRENCY | TRAN TYPE | TYPE CODE | TYPE CODE DESCRIPTION | AMOUNT | FUNDS TYPE | IMMEDIATE | ONE DAY | TWO DAY | BANK REFERENCE | [NAME] |  | [NAME] | ENTRY CLASS CODE | EFFECTIVE DATE | ORIGINATOR NAME | RECEIVER NAME | ORIG COMPANY ID | RECEIVER ID | COMPANY ENTRY DESC | TRACE NUMBER | ORIG BANK TR | RECG BANK TR | COMPANY DISCR DATA | TRANS CODE | COMPANY DESCR DATE | ADDENDA REC IND | ORIG BANK TR/BATCH | DISCR DATA | ADDENDA INFORMATION | DIVISION | GROUP
2009-02-13 00:00:00 |  |  | USD | DB | 698 | MISC FEES | 20381.31 | Z | 0 | 0 | 0 | 1 |  | 0
2009-01-26 00:00:00 |  |  | USD | DB | 495 | OUTGOING MONEY TRANSFR | 16225184.11 | 11 | 0 | 0 | 0 | 1 |  | 1 | RRN 622 RCV *OBI= INC COMPANY #501*  REF#=25014 WIRE TYPE=FW [NAME] REF#=4441 17:30 01-26-09
2009-01-27 00:00:00 |  |  | USD | DB | 495 | OUTGOING MONEY TRANSFR | 9847442.51 | Z | 0 | 0 | 0 | 1 |  | 2 | RRN 622 *OBI= INC COMPANY #501*  REF#=22771 WIRE TYPE=FW NETWORK REF#=4292 17:30 01-27-09
2009-01-28 00:00:00 |  |  | USD | DB | 495 | OUTGOING MONEY TRANSFR | 5659519.78 | Z | 0 | 0 | 0 | 1 |  | 3 | RRN 622 *OBI= INC COMPANY #501*  REF#=22570 WIRE TYPE=FW NETWORK REF#=4022 17:30 01-28-09
2009-01-29 00:00:00 |  |  | USD | DB | 495 | OUTGOING MONEY TRANSFR | 8309461.12 | Z | 0 | 0 | 0 | 1 |  | 4 | RRN 622 *OBI= INC COMPANY #501*  REF#=25230 WIRE TYPE=FW NETWORK REF#=4573 17:30 01-29-09
2009-01-30 00:00:00 |  |  | USD | DB | 495 | OUTGOING MONEY TRANSFR | 5884758.61 | Z | 0 | 0 | 0 | 1 |  | 5 | RRN 622 *OBI= INC COMPANY #501*  [NAME] TYPE=FW NETWORK REF#=7512 17:30 01-30-09
2009-02-02 00:00:00 |  |  | USD | DB | 495 | OUTGOING MONEY TRANSFR | 11666350.42 | Z | 0 | 0 | 0 | 1 |  | 6 | RRN 622 *OBI= INC COMPANY #501*  REF#=30517 WIRE TYPE=FW [NAME] REF#=5191 17:30 02-02-09
2009-02-03 00:00:00 |  |  | USD | DB | 495 | OUTGOING MONEY TRANSFR | 6402935.85 | Z | 0 | 0 | 0 | 1 |  | 7 | RRN 622 *OBI= INC COMPANY #501*  REF#=24298 WIRE TYPE=FW NETWORK REF#=4242 17:30 02-03-09
2009-02-04 00:00:00 |  |  | USD | DB | 495 | OUTGOING MONEY TRANSFR | 5814862.08 | Z | 0 | 0 | 0 | 1 |  | 8 | RRN 622 *OBI= INC COMPANY #501*  REF#=23959 WIRE TYPE=FW NETWORK REF#=4185 17:30 02-04-09
2009-02-05 00:00:00 |  |  | USD | DB | 495 | OUTGOING MONEY TRANSFR | 6069948.22 | Z | 0 | 0 | 0 | 1 |  | 9 | RRN 622 *OBI= INC COMPANY #501*  REF#=23210 WIRE TYPE=FW NETWORK REF#=4097 17:30 02-05-09
2009-02-06 00:00:00 |  |  | USD | DB | 495 | OUTGOING MONEY TRANSFR | 4771302.72 | Z | 0 | 0 | 0 | 1 |  | 10 | RRN 622 *OBI= INC COMPANY #501*  REF#=24173 WIRE TYPE=FW NETWORK REF#=4356 17:30 02-06-09
2009-02-09 00:00:00 |  |  | USD | DB | 495 | OUTGOING MONEY TRANSFR | 10402856.36 | Z | 0 | 0 | 0 | 1 |  | 11 | RRN 622 *OBI= INC COMPANY #501*  REF#=23567 WIRE TYPE=FW [NAME] REF#=4440 17:30 02-09-09
2009-02-09 00:00:00 |  |  | USD | DB | 495 | OUTGOING MONEY TRANSFR | 135510.48 | Z | 0 | 0 | 0 | 1 |  | 0 | RRN RCV*BBI=RE YOUR FED RE F DCM0901128837700 DT*D 020309 BNF RETURNING FUNDS.*  REF#=19188 WIRE TYPE=FW [NAME] REF#=3608 15:13 02-09-09
2009-02-10 00:00:00 |  |  | USD | DB | 495 | OUTGOING MONEY TRANSFR | 7130424.22 | Z | 0 | 0 | 0 | 1 |  | 12 | RRN 622 *OBI= INC COMPANY #501*  [NAME] TYPE=FW NETWORK REF#=3956 17:30 02-10-09
2009-02-11 00:00:00 |  |  | USD | DB | 495 | OUTGOING MONEY TRANSFR | 5634470.39 | Z | 0 | 0 | 0 | 1 |  | 13 | RRN 622 *OBI= INC COMPANY #501*  [NAME] TYPE=FW NETWORK REF#=3948 17:30 02-11-09
2009-02-12 00:00:00 |  |  | USD | DB | 495 | OUTGOING MONEY TRANSFR | 5649027.76 | Z | 0 | 0 | 0 | 1 |  | 14 | RRN 622 *OBI= INC COMPANY #501*  REF#=26634 WIRE TYPE=FW NETWORK REF#=4131 17:30 02-12-09
2009-02-13 00:00:00 |  |  | USD | DB | 495 | OUTGOING MONEY TRANSFR | 7505000.96 | Z | 0 | 0 | 0 | 1 |  | 15 | RRN 622 *OBI= INC COMPANY #501*  REF#=27611 WIRE TYPE=FW [NAME] REF#=5129 17:30 02-13-09
2009-02-17 00:00:00 |  |  | USD | DB | 495 | OUTGOING MONEY TRANSFR | 10998362.23 | Z | 0 | 0 | 0 | 1 |  | 16 | RRN 622 *OBI= INC COMPANY #501*  REF#=28828 WIRE TYPE=FW NETWORK REF#=5095 17:30 02-17-09
2009-02-18 00:00:00 |  |  | USD | DB | 495 | OUTGOING MONEY TRANSFR | 16532080.85 | Z | 0 | 0 | 0 | 1 |  | 17 | RRN 622 *OBI= INC COMPANY #501*  REF#=25066 WIRE TYPE=FW [NAME] REF#=4440 17:30 02-18-09
2009-02-19 00:00:00 |  |  | USD | DB | 495 | OUTGOING MONEY TRANSFR | 11167167.28 | Z | 0 | 0 | 0 | 1 |  | 18 | RRN 622 *OBI= INC COMPANY #501*  REF#=23836 WIRE TYPE=FW NETWORK REF#=4414 17:30 02-19-09
2009-02-20 00:00:00 |  |  | USD | DB | 495 | OUTGOING MONEY TRANSFR | 10194317.88 | Z | 0 | 0 | 0 | 1 |  | 19 | RRN 622 *OBI= INC COMPANY #501*  REF#=26148 WIRE TYPE=FW [NAME] REF#=4923 17:30 02-20-09