I need tables of component parts for a number of items I stock in various brands. This job requires no programming per se, but setting up calculations to determine container components will make this job very simple once catalog numbers are studied and their patterns are understood. I have included an excel spreadsheet of all stock codes I want to break down. Deliverables shall be two .csv files. The first .csv file shall have the following fields: Stock code, Assembly indicator (true or false). The second .csv file shall have the following fields: Stock code, Component Stock Code, Component quantity. Thus it would probably be easier to build this in a simple database with two tables related by stock code. Not all stock codes contained on the spread sheet will be container assemblies.
I need this quickly as there are more parts (different types and manufacturers) that need to be done.
Examples of what I need are included in uploaded files. I am willing to try someone with no feedback but terms will be escrow only.
You will need acrobat 7.0 to read the files; there is a size upload limit on this system which will not allow me to upload all relevant files. Complete catalog files (you will be interested in 800H, 800T, and 800R) can be found at [url removed, login to view]