.XLS Guru to extract data
Budget: $30 – $250 AUD
Require a Microsoft XCEL Guru to take a Bill of Material Spreadsheet (BOM), about 150-line items but not fixed and extract Manufacturing Batch Cards information into new Spreadsheets/List (simple filter and query task).
The Master BOM has many columns of data for description, pricing, etc and 4 each item is assigned to a batch card.
We have 3 basic products and each product requires 4 different Batch cards for manufacturing process, so we require 12 Lists/spreadsheets of items which are derived from the Master BOM.
Require automatic generation of the batch cards when the BOM is updated.
Batch cards need to copy data from the BOM into a separate spreadsheet/List. Need to filter out parts that are not used so we populate a Batch card with only the used parts.
simple job 1-2 hours
The Master BOM has many columns of data for description, pricing, etc and 4 each item is assigned to a batch card.
We have 3 basic products and each product requires 4 different Batch cards for manufacturing process, so we require 12 Lists/spreadsheets of items which are derived from the Master BOM.
Require automatic generation of the batch cards when the BOM is updated.
Batch cards need to copy data from the BOM into a separate spreadsheet/List. Need to filter out parts that are not used so we populate a Batch card with only the used parts.
simple job 1-2 hours