How to Catalog Parts
This part of the design process is as much record-keeping as it is anything else. What information do you need to keep?
3. Spreadsheet Setup
Once you find the part you will need to record some information that will eventually be used to create a Part Library. For now, we will create a spreadsheet/database with at least the following data for our reference when creating our parts libraries.
Manufacturer Part Number |
Distributor Part Number |
Description | Value | Package | Datasheet Link |
Webpage Link |
This can be a spreadsheet on your computer, the part library in Altium Designer, the BOM builder on the Digikey website, or something else. The key is accuracy and consistency. (We'll work together to populate a sample database in the next activity Bill of Materials.)
The "Add to BOM" link is directly below the "Add to Cart"
If you do create your own spreadsheet, keep in mind that this is different than the BOM that you will submit to your assembly house. We will use this initial spreadsheet to create a parts library for our design.
Manufacturer Part Number |
Distributor Part Number |
Description | Value | Package | Datasheet Link | Webpage Link |
12065A330JAT2A | 478-1474-1-ND | CAP 50V COG/NP0 | 33 pF | 1206 | http://datasheets.avx.com/C0GNP0-Dielectric.pdf | https://www.digikey.com/product-detail/en/avx-corporation/12065A330JAT2A/478-1474-1-ND/564506 |
RC0402JR-070RL | 311-0.0JRTR-ND | RES Jumper 1/16 W | 0 Ohm | 0402 | https://www.yageo.com/upload/media/product/productsearch/datasheet/rchip/PYu-RC_Group_51_RoHS_L_10.pdf | https://www.digikey.com/product-detail/en/yageo/RC0402JR-070RL/311-0.0JRTR-ND/726406 |
... | ... | ... | ... | ... | ...... | ... |
0545480833 | WM11195TR-ND | CONN FFC | 8 Pos | 0.5mm Bottom | https://www.molex.com/pdm_docs/sd/545480433_sd.pdf | https://www.digikey.com/product-detail/en/molex/0545480833/WM11195TR-ND/5116081 |
Your spreadsheet needs to at least have these columns to save you time later.
The assembly house will want the data in a slightly different arrangement. We'll worry about that format in the very last stages of design before the DFA check but I'll present it here to offer contrast.
While assembly houses will take a BOM in almost any format, the preferred document will likely be .xlsx or .csv. Advanced Assembly requests the following columns in txt, csv, or xlsx formats. It's easy enough to merge the Descriptions Value Package columns before submission or leave it for the part sourcing department to do.
Manufacturer Part Number | Description Value Package | Reference Designator | Quantity | DNP | Notes |
12065A330JAT2A | CAP 50V COG/NP0 33 pF 1206 | C1, C14, C32 | 3 | ||
RC0402JR-070RL | RES Jumper 1/16 W 0 Ohm 0402 | R1 | 0 | DNP | |
... | ... | ... | ... | ... | ... |
0545480833 | CONN FFC 8 Pos 0.5mm | J1, J3, J5, J7, J9 | 5 | See sample board for orientation |
"Get organized now! Electrical Engineering is too complicated a subject to "wing-it" or work from post-it notes or other poorly organized note-taking schemes. Almost every PCB layout mistake I've ever made can be traced back to an interruption of some sort and a disrupted thought-process."