Announcement

Collapse
No announcement yet.

Creating BOM from template

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Creating BOM from template

    Hello,
    I have issue creating BOM from template.
    In attached picture 1 you can see my generated BOM. Somehow EXEL is interpreted all numbers as text, so I get error. And this is begining of my problems, in my template are mathematical formulas which simple calculated total price of two “subtotal” columns, so it can’t calculate while it’s text...
    Yes, I know I can simple click on each “number” and convert it to number, but it is annoying… Also tried first convert all empty fields in my template to number format, but it did not help. Why Altium export numbers as text?
    Second problem is some numbers in “Supplier Unit Price 1” column are huge, in picture 2 we can see that before exporting BOM capacitor C6 price is 1.466$ and after exporting is 1466$, what the hell is wrong?
    I'm looking forward to your replies.
    Thanks!
    Click image for larger version

Name:	1.JPG
Views:	1
Size:	426.7 KB
ID:	469 Click image for larger version

Name:	2.JPG
Views:	2
Size:	342.3 KB
ID:	468
    Attached Files

  • #2
    Maybe this will help you: http://www.fedevel.com/designhelp/fo...ype-of-the-bom

    Comment


    • Lukas
      Lukas commented
      Editing a comment
      Thanks! Perfect

  • #3
    So many thanks. This is so usefull.

    Comment


    • #4
      Thanks Robert.

      Comment

      Working...
      X