Spreadsheet: 166998d1341860322-multiple-tables-into-one-constantly-updated-table-ad-trial
Sheet: Add_Delete

 |  |  |  |  |  | DELETED ITEMS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Input Responsibility |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prod. Engineering |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Manufacturing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Procurement
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Finance
 |  |  |  |  |  |  |  |  |  |  | Date:
 |  |  |  |  |  |  | Material/Components - CURRENT |  |  |  |  |  |  | Material/Components - DELETE |  |  |  |  |  |  | Material/Components - ADDITIONS
 |  |  |  |  |  |  | P/N | Description | UOM | Qty | Ext Mat'l | [NAME] |  | P/N | Description | UOM | Qty | Ext Mat'l | [NAME] |  | P/N | Description | UOM | Qty | Ext Mat'l | [NAME] | Supplier | Supplier Location | Comments
 |  |  |  |  |  | x | 123456 | shock | ea | 1 | 1 | 1 |  | 123456 | Shock [NAME] | ea | 1 | 1 | 1 |  | 124456 | shock |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123457 | assembly | ea | 1 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123458 | part | ea | 1 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123459 | part | ea | 1 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123460 | part | ea | 1 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123461 | part | ea | 1 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123462 | part | ea | 1 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123463 | part | ea | 1 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123464 | part | ea | 1 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123465 | part | ea | 1 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123466 | part | ea | 1 | 0 | 0 |  | 0 | 0 | 0 | - | - | - |  | 123515 | part | - | - | 0 | 0
 |  |  |  |  |  |  | 123467 | part | ea | 1 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 123516 | part | EA | 1 | 1 | 1
 |  |  |  |  |  |  | 123468 | part | ea | 1 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 123517 | part | EA | 1 | 1 | 1
 |  |  |  |  |  |  | 123469 | part | ea | 1 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123470 | part | ea | 1 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123471 | part | ea | 1 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123472 | part | ea | 1 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123473 | part | ea | 1 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123474 | part | ea | 1 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123475 | part | ea | 1 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123476 | part | ea | 1 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123477 | part | ea | 1 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123478 | part | ea | 1 | 1 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123479 | part | ea | 1 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123480 | part | ea | 1 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123481 | part | ea | 1 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123482 | part | ea | 1 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123483 | part | ea | 1 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | x | 123484 | part | ea | 1 | 1 | 0 |  | 123484 | part | ea | 1 | 1 | 0 |  | 123518 | part | EA | 1 | 1 | 0
 |  |  |  |  |  |  | 123485 | part | ea | 1 | 1 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123486 | part | ea | 1 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123487 | part | ea | 1 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123488 | part | ea | 1 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123489 | part | ea | 1 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123490 | part | ea | 1 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123491 | part | ea | 1 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123492 | part | ea | 1 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123493 | part | ea | 1 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123494 | part | ea | 1 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123495 | part | ea | 1 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123496 | part | ea | 1 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123497 | part | ea | 1 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123498 | part | ea | 1 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123499 | part | ea | 1 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123500 | part | ea | 1 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123501 | part | ea | 1 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | x | 123502 | part | ea | 1 | 0 | 0 |  | 123502 | part | ea | 0 | 0 | 0 |  | 123519 | part | EA | - | - | -
 |  |  |  |  |  |  | 123503 | part | ea | 1 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123504 | part | ea | 1 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123505 | part | ea | 1 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123506 | part | ea | 1 | 1 | 0 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123507 | part | ea | 1 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123508 | part | ea | 1 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123509 | part | ea | 1 | 1 | 0 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123510 | part | ea | 1 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123511 | part | ea | 1 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123512 | part | ea | 1 | 1 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123513 | part | ea | 1 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 123514 | part | ea | 1 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | Total Base Cost |  |  | 35 | 29 |  |  | Total Deleted Cost |  |  | 2 | 1 |  |  | Total Added Cost |  |  | 3 | 2