This program helps the designer to fill in the missing fields of BOM files when transferring them for PCB assembly.
When uploading boom files from altium and ordering components from compel, it becomes necessary to compare the elements that needed to be bought with those that were bought.
The program allows you to compare BOM files from altium and excel files from sds-compel specifications. After matching, columns are created in the BOM file with the items that were bought and their quantity. Compel excel creates a column with the number of used elements on the board, to control the number of purchased elements.
Download necessary files (Altium BOM and Compel Excel) in "change files" folder.
Run run_excel_parse.bat, and in GUI choose Altium BOM and Compel Excel. Push botton and and enjoy the result.
The program uses column numbers. Therefore, it is desirable to define the table structure in advance.
| Name | Description | Footprint | Designator | Quantity | Название/закуплено | Количество | Примечание |
|---|---|---|---|---|---|---|---|
| Piezoelectric Buzzer | PKMCS0909E4000-R1 | PKMCS0909E4000-R1 | BQ1 | 1 | PKMCS0909E4000-R1 | 25 | |
| 470Ohm | RC1206FR-07470RL | 1206 RESISTOR | R1, R2, R3 | 3 | CR-06FL7--470R | 70 | |
| TL431 | TL431 | SOT-23-3 | DA1 | 1 | RS431AYSF3 | 25 | |
| ... | ... | ... | ... | ... | ... | ... | ... |
| Имя строки | Наименование | Наименование товара | Производитель товара | Позиционное обозначение | Корпус | Примечание | Кол-во в изделии | Подобрано предложение | Приоритетный товар | Общее кол-во на партию | Используемое количество | Примечание |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RC1206FR-07470RL | CR-06FL7--470R (VIKING) | CR-06FL7--470R | VIKING | R1, R2, R3 | SMD120632X16MM | Корпус: 1206 RESISTOR 470 | 3 | да | нет | 70 | 60 | |
| RC1206FR-07470RL | AC1206FR-07470RL (YAG) | AC1206FR-07470RL | YAG | R1, R2, R3 | SMD120632X16MM | Корпус: 1206 RESISTOR 470 | 3 | нет | нет | 70 | 60 | |
| RC1206FR-07470RL | CRCW1206470RFKEA (VISHAY) | CRCW1206470RFKEA | VISHAY | R1, R2, R3 | SMD120632X16MM | Корпус: 1206 RESISTOR 470 | 3 | нет | нет | 70 | 60 | |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |