Spreadsheet: 862053d1709837008-update-vertical-price-tables-via-horizontal-price-sheet-please-see-below-data-examples-acme-test-dj
Sheet: Acme Extract

Customer | Customer PO No | Customer Part No | Customer Part Revision | Price | Effective Date | Expiration Date | Account No | Amount | Part No | Revision | Breakpoint Quantity | Note | Master Price | Active | Unit | Primary Price | Currency | Formula1 | Formula2
Acme | 68 | WR4111Z1 |  | 0.2158 | 2022-09-01 00:00:00 | 2024-03-30 00:00:00 |  |  | COL0809Z1 |  | 2000
Acme | 68 | WR4111Z1 |  | 0.2158 | 2022-09-01 00:00:00 | 2024-03-30 00:00:00 |  |  | COL0809Z1 |  | 5000
Acme | 68 | WR4111Z1 |  | 0.2158 | 2022-09-01 00:00:00 | 2024-03-30 00:00:00 |  |  | COL0809Z1 |  | 10000
Acme | 68 | WR4111Z1 |  | 0.2158 | 2022-09-01 00:00:00 | 2024-03-30 00:00:00 |  |  | COL0809Z1 |  | 25000
Acme | 68 | 2121Z1 |  | 0.4841 | 2022-09-01 00:00:00 | 2024-03-30 00:00:00 |  | 0 | COL1409Z1 |  | 2000 |  | 1 | 1 | $/pc | 0
Acme | 68 | 2121Z1 |  | 0.2814 | 2022-09-01 00:00:00 | 2024-03-30 00:00:00 |  | 0 | COL1409Z1 |  | 5000 |  | 1 | 1 | $/pc | 0
Acme | 68 | 2121Z1 |  | 0.2433 | 2022-09-01 00:00:00 | 2024-03-30 00:00:00 |  | 0 | COL1409Z1 |  | 10000 |  | 1 | 1 | $/pc | 0
Acme | 68 | 2121Z1 |  | 0.2195 | 2022-09-01 00:00:00 | 2024-03-30 00:00:00 |  | 0 | COL1409Z1 |  | 25000 |  | 1 | 1 | $/pc | 0
Acme | 68 | 4013Z1 |  | 0.7453 | 2022-09-01 00:00:00 | 2024-03-30 00:00:00 |  |  | COL4013Z1 |  | 1000
Acme | 68 | 4013Z1 |  | 0.7453 | 2022-09-01 00:00:00 | 2024-03-30 00:00:00 |  | 0 | COL4013Z1 |  | 5000 |  | 1 | 1 | $/pc | 0
Acme | 68 | 4013Z1 |  | 0.7453 | 2022-09-01 00:00:00 | 2024-03-30 00:00:00 |  |  | COL4013Z1 |  | 10000
Acme | 68 | 4013Z1 |  | 0.7453 | 2022-09-01 00:00:00 | 2024-03-30 00:00:00 |  |  | COL4013Z1 |  | 25000
Acme | 68 | L5213Z1 |  | 0.8588 | 2022-09-01 00:00:00 | 2024-03-30 00:00:00 |  | 0 | COL5213Z1 |  | 1000
Acme | 68 | L5213Z1 |  | 0.8588 | 2022-09-01 00:00:00 | 2024-03-30 00:00:00 |  | 0 | COL5213Z1 |  | 5000 |  | 1 | 1 | $/pc | 0
Acme | 68 | L5213Z1 |  | 0.8588 | 2022-09-01 00:00:00 | 2024-03-30 00:00:00 |  | 0 | COL5213Z1 |  | 10000 |  | 1 | 1 | $/pc | 0
Acme | 68 | L5213Z1 |  | 0.8588 | 2022-09-01 00:00:00 | 2024-03-30 00:00:00 |  | 0 | COL5213Z1 |  | 25000
Acme | 68 | X5213Z1 |  | 0.8588 | 2022-09-01 00:00:00 | 2024-03-30 00:00:00 |  |  | CCV0509Z1 |  | 1000
Acme | 68 | X5213Z1 |  | 0.8588 | 2022-09-01 00:00:00 | 2024-03-30 00:00:00 |  |  | CCV0509Z1 |  | 5000
Acme | 68 | X5213Z1 |  | 0.8588 | 2022-09-01 00:00:00 | 2024-03-30 00:00:00 |  |  | CCV0509Z1 |  | 10000
Acme | 68 | X5213Z1 |  | 0.8588 | 2022-09-01 00:00:00 | 2024-03-30 00:00:00 |  |  | CC 3313Z1 |  | 1000
Acme | 68 | X5213Z1 |  | 0.8588 | 2022-09-01 00:00:00 | 2024-03-30 00:00:00 |  |  | CC 3313Z1 |  | 5000
Acme | 68 | X5213Z1 |  | 0.8588 | 2022-09-01 00:00:00 | 2024-03-30 00:00:00 |  |  | CC 3313Z1 |  | 10000
Acme | 68 | L5213Z1 |  | 0.8588 | 2022-09-01 00:00:00 | 2024-03-30 00:00:00 |  |  | CC 3315Z1 |  | 1000
Acme | 68 | L5213Z1 |  | 0.8588 | 2022-09-01 00:00:00 | 2024-03-30 00:00:00 |  |  | CC 3315Z1 |  | 5000
Acme | 68 | L5213Z1 |  | 0.8588 | 2022-09-01 00:00:00 | 2024-03-30 00:00:00 |  |  | CC 3317Z1 |  | 1000
Acme | 68 | L5213Z1 |  | 0.8588 | 2022-09-01 00:00:00 | 2024-03-30 00:00:00 |  |  | CC 3317Z1 |  | 5000
Formula1
Formula2