bom relations

[selsium]

hi all,


this is the algorithm i have for my drawing. but i dunno how to achieve this. i want to sort the components as below alogorithm.


your answer is most welcome.





<BR itxtvisited="1">1.1 :First N number of BOM items shall be only Standard parts (Parts that have P numbers or seperate drawing ex. P600001 etc..)


<BR itxtvisited="1">Rule 1.2: Within Standard parts, reverse alphabetical order shall be followed in sorting<BR itxtvisited="1"><BR itxtvisited="1">Rule 2.1After standard parts, the stock cut (No machining) components are grouped as follows (following reverse alphabetic order)<BR itxtvisited="1">Z<BR itxtvisited="1">Y<BR itxtvisited="1">.<BR itxtvisited="1">.<BR itxtvisited="1">Round Bar<BR itxtvisited="1">RHS <BR itxtvisited="1">Plate <BR itxtvisited="1"><BR itxtvisited="1">Rule 2.2 : Within each component group, the following sequence shall be followed<BR itxtvisited="1"> Largestin dimension wise<BR itxtvisited="1"> ....<BR itxtvisited="1"> Smallest in dimension wise<BR itxtvisited="1"><BR itxtvisited="1">Rule 2.2.1<BR itxtvisited="1"> For Round bars

 

[jelston]

It gave me a headache to try to sort thru it, but my advice is to use a numerical code for each type of part (i.e. standard parts will be a001, stock cut b001, etc). In you bom you will have a column for this numerical code, and sort by it first then sort alphabetically (or reverse alphabetically, or lateral alphabetically, which ever).


But you results should be


a0001 z


a001 y


b001 z


c001 z, etc


Hope this helps.
Edited by: jelston