OK, i am attaching sample excel files 3 nos for your reference. In the file name "SAMPLE-MC" the product summary from drawing given based on this I have to generate the code. I have given 2 example one is of standard product and other is of non standard product. the product may vary in product type, belt width, tube length, bld type, skt type, boot type, em type, no of arm. all the parameters may vary. based on the parameter there is a...

Hi! I am Atanu. I am working in a company dealing with manufacturing of mechanical spear parts. When we release a product for manufacturing we make drawing and given the same to the factory. To make the drawing handy we make an excel sheet we call “MC” which contains the summary of the drawing like type of product, tube length, type of component etc. I have to generate the product code based on the drawing or “MC” and then make the BOM...