BOM Tutorial

PollEx BOM is software that can import formatted text BOM or MS/Excel BOM and to use for searching components or check conjunction with PCB design file.

  1. Launch PollEx BOM.
  2. Import MS/Excel Format BOM.
    1. Click File > Import BOM > MS/Excel BOM from the menu.
    2. Select the Test-BOM.xlsx file from C:\Temp\Altair-PollEx\PollExBOM.


      Figure 1.
    3. Enter 1 in the Header Line under Excel Format Setup.


      Figure 2.
    4. Click the first column of Column Style and select Set As Reference from the menu.


      Figure 3.
      When the first column in the Excel Format Setup is clicked, the matched column is highlighted.
    5. Click the second column of Column Style and select Set As Part.


      Figure 4.
    6. Leave the third and fourth columns to Delete.
    7. Set the fifth column to Set As Type.
    8. Set the sixth column to Set As Description.
    9. Set the seventh column to Set AS Quantity.


      Figure 5.
    10. Click Apply.


      Figure 6.
  3. Save Column Style Setup.
    1. Enter Test for File name and click Apply to save the Excel setup.
    2. Click Save.
      After saving the .ebi file, BOM list is displayed as shown in Figure 7.


      Figure 7.
  4. Change Column Order.
    1. From the menu bar, click Tool > Define Column Order.
      The Column Order dialog opens.
    2. In the Column Order dialog, select Quantity from the Define Column and click Up twice.


      Figure 8.
      The Quantity column is moved to the middle.


      Figure 9.
  5. Save BOM with binary file (*.bdbb).
    1. From the menu bar, select File > Save.
    2. Enter Test in the File name field and click Save.
  6. Import ASCII Formatted BOM.
    1. From the menu bar, select File > Import BOM > ASCII BOM.
    2. Select the Test-BOM.txt file from C:\Temp\Altair-PollEx\PollExBOM.


    Figure 10.
  7. Delete Header Line.
    1. Right-click the second row from the top and select Delete Row.


      Figure 11.
  8. Column Style Setup.
    Click the columns to define types, such as reference, part, and so on.
    1. Set the first area to Set As Reference.
    2. Set the second area to Set As Part.
    3. Set the fifth area to Set As Type.
    4. Set the sixth area to Set As Description.
    5. Set the seventh area to Set As Quantity.


    Figure 12.
  9. Generate BOM.
    1. From the menu bar, select Tool > Get Final Report.


    Figure 13.
  10. Column Setting.
    If the columns are not displayed properly, you must define the column setting.
    1. Click Setting > Environment.
    2. Using the arrow keys, move the items below to the right and click OK.
      • PART
      • TYPE
      • DESCRIPTION
      • QUANTITY


      Figure 14.