How to Catalog Parts

View

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

Hard Way Hughes

"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."

Tags: