I've been using the ULP BOM-AM-15 to create all my BOM output and placement
files.
The BOM is grouped by same values and gives columns of quantity, part
designator (C1, R1..), value package and description.
The Placement file is grouped by part and gives columns of part, package,
location (x,y), angle, side and description.
Output is chosen as html. The output files will both import nicely into
Excel (which the assembly house uses) and will open in Internet Explorer
with nicely formed columns (for printing).
Since the setup files for BOM and placement are used with all of our
projects, there is no need to put a copy in each design folder. A single
copy of the setup files (*.BOMsu) is in the top level of the projects
folder. From any design, open the ulp, choose the output tab and click 'get
setup'. From the file menu, just go up a level (as necessary) and select the
desired setup file (*.BOMsu). When output is created, it will be in the
original project directory.
Recently our board/assembly house asked that we include a RoHS specifier in
the BOM file. I found that it was easy to do within the BOM ulp.
As usual, from the design, open the ulp, go to the output tab and get setup
file.
Click Default output title and add any extra text that may be needed. I was
entering the RoHS spec here but the line gets cluttered and I wanted to put
it on a separate line. Found that using html tags, that multiple lines can
be printed for this header information. At the end of what would be the
first line, add
followed by the text for the second line and follow
with
Using
creates a new line and the
is a horizontal line which
visually separates the header from the column headings.
Will experiment later trying to add the html tags to the Title= lines in the
listings below.
There is a very minor bug in the ulp in that the first get setup file opens
OK but the second setup file initially does not open as expected.
Work-around is to get setup file a second time and it will open as expected.
BOM.BOMsu file contents
Version=BOM-BIO8
GroupedBy=1
ValuesToShow=0
DisplayPackage=0
SchematicName=
Title=
OutputColumn=5
OutputColumn=0
OutputColumn=1
OutputColumn=2
OutputColumn=3
OutputColumn=4
BlankLineIndex=-1
OutputFormat=1
Place.BOMsu file contents
Version=BOM-BIO8
GroupedBy=0
ValuesToShow=0
DisplayPackage=0
SchematicName=
Title=
OutputColumn=0
OutputColumn=3
OutputColumn=7
OutputColumn=8
OutputColumn=9
OutputColumn=10
OutputColumn=11
OutputColumn=6
OutputColumn=2
BlankLineIndex=-1
OutputFormat=1