Spreadsheet: 702460d1604361057-cleaning-and-organizing-data-in-excel-sheet-raw-data
Sheet: Sheet1

2019 ANZ Mobile Opt1 - 2019 ANZ Mobile Opt1 |  |  |  |  |  |  | 4
2020-11-02 00:00:00 | 1132706S | 394051-001 |  | ANZ Mobile Lending - Engadine |  |  |  | 1 | 2020-11-03 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1132707S | 394051-002 |  | ANZ Mobile Lending - Engadine |  |  |  | 1 | 2020-11-03 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1132708S | 394051-003 |  | ANZ Mobile Lending - Engadine |  |  |  | 1 | 2020-11-03 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1132709S | 394051-004 |  | ANZ Mobile Lending - Engadine |  |  |  | 1 | 2020-11-03 00:00:00 |  | NSA
Total for 2019 ANZ Mobile Opt1 - 2019 ANZ Mobile Opt1 |  |  | Units: | 4 | Sales: | 181.818 |  | Cost of Goods: |  |  | 100.00%
2019 Asset Base - 2019 Asset Base |  |  |  |  |  |  | 1
2020-11-02 00:00:00 | 1131945S | 394212 |  | Asset Base |  |  |  | 1 | 2020-11-03 00:00:00 |  | RTP
Total for 2019 Asset Base - 2019 Asset Base |  |  | Units: | 1 | Sales: | 45.45450000000001 |  | Cost of Goods: |  |  | 64.24%
2019 BGW Op1 - 2019 BGW Op1 |  |  |  |  |  |  | 3
2020-10-30 00:00:00 | 1130428S | [PHONE] |  | CNW Pty Ltd |  |  |  | 1 | 2020-11-02 00:00:00 |  | RTP
2020-10-30 00:00:00 | 1130429S | [PHONE] |  | CNW Pty Ltd |  |  |  | 1 | 2020-11-05 00:00:00 |  | RTP
2020-10-30 00:00:00 | 1130433S | [PHONE] |  | CNW Pty Ltd |  |  |  | 1 | 2020-11-02 00:00:00 |  | RTP
Total for 2019 BGW Op1 - 2019 BGW Op1 |  |  | Units: | 3 | Sales: | 354.5454 |  | Cost of Goods: |  |  | 100.00%
2019 Datalink Opt1 BT - 2019 Datalink Opt1 BT |  |  |  |  |  |  | 1
2020-10-01 00:00:00 | 1106351S | 377185-010 |  | Datalink Software Consultants, Inc |  |  |  | 1 | 2020-11-05 00:00:00 |  | RTP
Total for 2019 Datalink Opt1 BT - 2019 Datalink Opt1 BT |  |  | Units: | 1 | Sales: | 141.1909 |  | Cost of Goods: |  |  | 100.00%
2019 Datalink Opt2 RT - 2019 Datalink Opt2 RT |  |  |  |  |  |  | 13
2020-10-01 00:00:00 | 1106338S | 377185-007 |  | Datalink Software Consultants, Inc |  |  |  | 1 | 2020-11-04 00:00:00 |  | RTP
2020-10-01 00:00:00 | 1106353S | 377185-012 |  | Datalink Software Consultants, Inc |  |  |  | 1 | 2020-11-04 00:00:00 |  | RTP
2020-10-01 00:00:00 | 1106356S | 377185-015 |  | Datalink Software Consultants, Inc |  |  |  | 1 | 2020-11-05 00:00:00 |  | RTP
2020-10-01 00:00:00 | 1106366S | 377185-025 |  | Datalink Software Consultants, Inc |  |  |  | 1 | 2020-11-04 00:00:00 |  | RTP
2020-10-01 00:00:00 | 1106372S | 377185-031 |  | Datalink Software Consultants, Inc |  |  |  | 1 | 2020-11-04 00:00:00 |  | RTP
2020-10-01 00:00:00 | 1106373S | 377185-032 |  | Datalink Software Consultants, Inc |  |  |  | 1 | 2020-11-04 00:00:00 |  | RTP
2020-10-01 00:00:00 | 1106393S | 377185-052 |  | Datalink Software Consultants, Inc |  |  |  | 1 | 2020-11-05 00:00:00 |  | RTP
2020-10-01 00:00:00 | 1106399S | 377185-058 |  | Datalink Software Consultants, Inc |  |  |  | 1 | 2020-11-05 00:00:00 |  | RTP
2020-10-01 00:00:00 | 1106400S | 377185-059 |  | Datalink Software Consultants, Inc |  |  |  | 1 | 2020-11-05 00:00:00 |  | RTP
2020-10-01 00:00:00 | 1106411S | 377185-070 |  | Datalink Software Consultants, Inc |  |  |  | 1 | 2020-11-04 00:00:00 |  | RTP
2020-10-01 00:00:00 | 1106412S | 377185-071 |  | Datalink Software Consultants, Inc |  |  |  | 1 | 2020-11-04 00:00:00 |  | RTP
2020-10-01 00:00:00 | 1106430S | 377185-089 |  | Datalink Software Consultants, Inc |  |  |  | 1 | 2020-11-04 00:00:00 |  | RTP
2020-10-01 00:00:00 | 1106431S | 377185-090 |  | Datalink Software Consultants, Inc |  |  |  | 1 | 2020-11-04 00:00:00 |  | RTP
Total for 2019 Datalink Opt2 RT - 2019 Datalink Opt2 RT |  |  | Units: | 13 | Sales: | 868.2816999999997 |  | Cost of Goods: |  |  | 100.00%
2019 IanReid Vendor - 2019 IanReid Vendor |  |  |  |  |  |  | 6
2020-10-30 00:00:00 | 1130436S | [PHONE] |  | [NAME] Vendor Advocates |  |  |  | 1 | 2020-11-02 00:00:00 |  | NSA
2020-10-30 00:00:00 | 1130437S | [PHONE] |  | [NAME] Vendor Advocates |  |  |  | 1 | 2020-11-02 00:00:00 |  | NSA
2020-10-30 00:00:00 | 1130438S | [PHONE] |  | [NAME] Vendor Advocates |  |  |  | 1 | 2020-11-02 00:00:00 |  | NSA
2020-10-30 00:00:00 | 1130439S | [PHONE] |  | [NAME] Vendor Advocates |  |  |  | 1 | 2020-11-02 00:00:00 |  | NSA
2020-10-30 00:00:00 | 1130440S | [PHONE] |  | [NAME] Vendor Advocates |  |  |  | 1 | 2020-11-02 00:00:00 |  | NSA
2020-10-30 00:00:00 | 1130444S | [PHONE] |  | [NAME] Vendor Advocates |  |  |  | 1 | 2020-11-02 00:00:00 |  | NSA
Total for 2019 IanReid Vendor - 2019 IanReid Vendor |  |  | Units: | 6 | Sales: | 327.273 |  | Cost of Goods: |  |  | 100.00%
2019 PhoneHomes Op1 - 2019 PhoneHomes Op1 |  |  |  |  |  |  | 6
2020-10-30 00:00:00 | 1130452S | 336787-0001B |  | Phone Homes |  |  |  | 1 | 2020-11-02 00:00:00 |  | NSA
2020-10-30 00:00:00 | 1130453S | 336787-0002B |  | Phone Homes |  |  |  | 1 | 2020-11-02 00:00:00 |  | NSA
2020-10-30 00:00:00 | 1130454S | 336787-0003B |  | Phone Homes |  |  |  | 1 | 2020-11-02 00:00:00 |  | NSA
2020-10-30 00:00:00 | 1130455S | 336787-0004B |  | Phone Homes |  |  |  | 1 | 2020-11-02 00:00:00 |  | NSA
2020-10-30 00:00:00 | 1130456S | 336787-0005B |  | Phone Homes |  |  |  | 1 | 2020-11-02 00:00:00 |  | NSA
2020-10-30 00:00:00 | 1130457S | 336787-0006B |  | Phone Homes |  |  |  | 1 | 2020-11-02 00:00:00 |  | NSA
Total for 2019 PhoneHomes Op1 - 2019 PhoneHomes Op1 |  |  | Units: | 6 | Sales: | 545.4546 |  | Cost of Goods: |  |  | 100.00%
2019 Two Red Shoes - 2019 Two Red Shoes |  |  |  |  |  |  | 1
2020-11-02 00:00:00 | 1131678S | 393720 |  | Two Red Shoes |  |  |  | 1 | 2020-11-03 00:00:00 |  | NSA
Total for 2019 Two Red Shoes - 2019 Two Red Shoes |  |  | Units: | 1 | Sales: | 81.8182 |  | Cost of Goods: |  |  | 100.00%
2020 Acrow Opt 2 - 2020 Acrow Opt 2 |  |  |  |  |  |  | 10
2020-10-28 00:00:00 | 1128449S | 353806 |  | Acrow Investments |  |  |  | 10 | 2020-11-02 00:00:00 |  | RTP
Total for 2020 Acrow Opt 2 - 2020 Acrow Opt 2 |  |  | Units: | 10 | Sales: | 909.0908999999999 |  | Cost of Goods: |  |  | 100.00%
2020 Adwealth Opt 1 - 2020 Adwealth Opt 1 |  |  |  |  |  |  | 50
2020-11-02 00:00:00 | 1131562S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131563S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131564S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131564S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131564S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131564S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131564S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131564S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131565S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131566S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131567S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131568S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131569S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131570S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131571S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131572S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131573S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131574S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131575S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131576S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131577S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131578S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131579S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131580S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131581S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131582S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131583S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131584S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131585S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131586S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131587S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131588S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131589S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131590S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131591S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131592S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131593S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131594S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131595S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131596S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131597S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131598S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131599S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131600S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131601S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131602S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131603S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131604S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131605S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA
2020-11-02 00:00:00 | 1131606S | [PHONE] |  | Adwealth Finance & Mortages |  |  |  | 1 | 2020-11-04 00:00:00 |  | NSA