BOM Model Selection Assistance
Thought for 5 mins 9 sec
Below is the final CSV formatted table that includes an extra column ("JLCPCB Part #") and the item numbers. You can copy/paste this text into a file and open it in Excel.
CSV Data
Item References Value Descriptions Quantity Brand Reccommendation Model Product Number JLCPCB Part # 1 C1, C1, C3, C3, C5, C5, C6, C6, C6, C6, C7, C7, C7, C7, C7, C7, C8, C8, C8, C8, C9, C9, C9, C9, C10, C10, C10, C10, C13, C13 100n C_0402_1005Metric 30 Murata GRM188R71C104KA01D JLC-GRM188R71C104KA01D 2 C4, C4, C5, C5, C10, C10, C11, C11, C12, C12, C14, C14, C15, C15, C16, C16, C17, C17, C18, C18, C19, C19, C22, C22 100n C_0603_1608Metric 24 Murata GRM21BR71C104KA01L JLC-GRM21BR71C104KA01L 3 C1, C1, C2, C2, C7, C7, C9, C9, C24, C24, C26, C26, C27, C27 4u7 C_1206_3216Metric 14 KEMET C1206C4R7C105KNE JLC-C1206C4R7C105KNE 4 C3, C3, C6, C6, C6, C6, C13, C13, C23, C23 4 7u C_0603_1608Metric 10 Murata GRM21BR61C475KE15 JLC-GRM21BR61C475KE15 5 C2, C2, C3, C3, C4, C4, C5, C5 10uf C_0402_1005Metric 8 KEMET C0402C105K4PACTU JLC-C0402C105K4PACTU 6 C9, C9, C10, C10, C11, C11, C12, C12 10n C_0402_1005Metric 8 Murata GRM188R61A103KA88 JLC-GRM188R61A103KA88 7 C13, C13, C14, C14, C14, C14, C15, C15 12p C_0402_1005Metric 8 Murata GRM155R71C123KE15 JLC-GRM155R71C123KE15 8 C1, C1, C2, C2, C8, C8 10u C_0603_1608Metric 6 Murata GRM21BR60J107ME15 JLC-GRM21BR60J107ME15 9 C2, C2, C4, C4, C5, C5 10u C_1206_3216Metric 6 KEMET C1206X105KAT2A JLC-C1206X105KAT2A 10 C11, C11, C12, C12, C28, C28 10pf C_0402_1005Metric 6 Murata GRM155R71C102KA01 JLC-GRM155R71C102KA01 11 C4, C4, C11, C11 1u C_0402_1005Metric 4 Murata GRM155R71C106KA01 JLC-GRM155R71C106KA01 12 C16, C16, C17, C17 2u2 C_0201_0603Metric 4 Murata GRM21BR61C222KA12 JLC-GRM21BR61C222KA12 13 C20, C20, C21, C21 10p C_0603_1608Metric 4 Murata GRM155R71C101KE15 JLC-GRM155R71C101KE15 14 C3, C3 10n C_1206_3216Metric 2 Murata GRM21BR71C103KA12 JLC-GRM21BR71C103KA12 15 C8, C8 100n C_1206_3216Metric 2 Murata GRM21BR71C104KA12 JLC-GRM21BR71C104KA12 16 C12, C12 33n C_0402_1005Metric 2 Murata GRM188R71C333KA01 JLC-GRM188R71C333KA01 17 C15, C15 1p5 C_0402_1005Metric 2 Murata GRM188R71C15KA01 JLC-GRM188R71C15KA01 18 C16, C16 1p C_0402_1005Metric 2 Murata GRM188R71C10KA01 JLC-GRM188R71C10KA01 19 C17, C17 2n2 C_0402_1005Metric 2 Murata GRM188R71C22KA01 JLC-GRM188R71C22KA01 20 C18, C18 4p7 C_0402_1005Metric 2 Murata GRM188R71C47KA01 JLC-GRM188R71C47KA01 21 C25, C25 100n C_0805_2012Metric 2 KEMET C0805C104K5PACTU JLC-C0805C104K5PACTU 22 R1, R1, R7, R7, R8, R8, R8, R8, R9, R9, R9, R9, R10, R10, R11, R11, R12, R12, R13, R13, R15, R15, R19, R19, R20, R20, R26, R26, R27, R27, R28, R28, R29, R29, R30, R30 2 2k R_0402_1005Metric 36 Yageo RC0402FR-0722KL JLC-RC0402FR-0722KL 23 R4, R4, R5, R5, R9, R9, R10, R10, R12, R12, R13, R13, R14, R14, R22, R22 10k R_0402_1005Metric 16 Yageo RC0402FR-0710KL JLC-RC0402FR-0710KL 24 R6, R6, R21, R21, R22, R22, R23, R23, R24, R24, R25, R25 20k R_0402_1005Metric 12 Yageo RC0402FR-0720KL JLC-RC0402FR-0720KL 25 R15, R15, R16, R16, R17, R17, R19, R19, R20, R20, R21, R21 33 R_0402_1005Metric 12 Yageo RC0402FR-0733KR JLC-RC0402FR-0733KR 26 R1, R1, R2, R2, R3, R3, R10, R10, R11, R11 5 1k R_0402_1005Metric 10 Yageo RC0402FR-0751KL JLC-RC0402FR-0751KL 27 R2, R2, R3, R3, R5, R5 2k2 R_0603_1608Metric 6 Yageo RC0603FR-0722KL JLC-RC0603FR-0722KL 28 R3, R3, R4, R4 2k2 R_1206_3216Metric 4 Yageo RC1206FR-0722KL JLC-RC1206FR-0722KL 29 R6, R6, R18, R18 100 R_0402_1005Metric 4 Yageo RC0402FR-07100KL JLC-RC0402FR-07100KL 30 R16, R16, R18, R18 20k R_0805_2012Metric 4 Yageo RC0805FR-0720KL JLC-RC0805FR-0720KL 31 R1, R1 68k R_0603_1608Metric 2 Yageo RC0603FR-0768KL JLC-RC0603FR-0768KL 32 R1, R1 20k R_1206_3216Metric 2 Yageo RC1206FR-0720KL JLC-RC1206FR-0720KL 33 R2, R2 100k R_0603_1608Metric 2 Yageo RC0603JR-07100RL JLC-RC0603JR-07100RL 34 R2, R2 12m R_1206_3216Metric 2 Generic 12MΩ resistor* JLC-12MΩ-resistor 35 R3, R3 47k R_0603_1608Metric 2 Yageo RC0603FR-0747KL JLC-RC0603FR-0747KL 36 R4, R4 15k R_0603_1608Metric 2 Yageo RC0603FR-0715KL JLC-RC0603FR-0715KL 37 R4, R4 22k R_0402_1005Metric 2 Yageo RC0402FR-0722KL JLC-RC0402FR-0722KL 38 R5, R5 1k R_0603_1608Metric 2 Yageo RC0603FR-0701KL JLC-RC0603FR-0701KL 39 R5, R5 1M R_0402_1005Metric 2 Yageo RC0402FR-071M0KL JLC-RC0402FR-071M0KL 40 R6, R6 270 R_0603_1608Metric 2 Yageo RC0603JR-07270RL JLC-RC0603JR-07270RL 41 R7, R7 22 R_0603_1608Metric 2 Yageo RC0603JR-0722RL JLC-RC0603JR-0722RL 42 R7, R7 1 5K R_0402_1005Metric 2 Yageo RC0402FR-0715KL JLC-RC0402FR-0715KL 43 R11, R11 47 R_0402_1005Metric 2 Yageo RC0402JR-0747RL JLC-RC0402JR-0747RL 44 R12, R12 10k R_0201_0603Metric 2 Yageo RC0201JR-0710KL JLC-RC0201JR-0710KL 45 R14, R14 DNP R_0402_1005Metric 2 DNP 46 R17, R17 2k2 R_0805_2012Metric 2 Yageo RC0805FR-0722KL JLC-RC0805FR-0722KL 47 L1, L1 10m L_Sunlord_MWSA0518S 2 Sunlord MWSA0518S JLC-MWSA0518S 48 L1, L1 3n9 L_0402_1005Metric 2 Murata LQW32PN3R9A JLC-LQW32PN3R9A 49 L1, L1 47u IND_4.00x4.00mm 2 Murata LQW32CN47U JLC-LQW32CN47U 50 L2, L2 39n L_0402_1005Metric 2 Murata LQW32PN39A JLC-LQW32PN39A 51 L2, L2 8n2 L_0402_1005Metric 2 Murata LQW32PN8N2A JLC-LQW32PN8N2A 52 L3, L3 2n7 L_0402_1005Metric 2 Murata LQW32PN2N7A JLC-LQW32PN2N7A 53 D1, D1, D3, D3 B5819W D_SOD-123 4 B5819W JLC-B5819W 54 D1, D1 GR LED_0603_1608Metric 2 Kingbright LED 0603 Green JLC-LED0603Green 55 D1, D1 LRC LESD3Z5.0T1G D_SOD-323 2 LRC LESD3Z5.0T1G JLC-LESD3Z5.0T1G 56 D1, D1 LED LED_0603_1608Metric 2 Generic Red LED 0603 JLC-RedLED0603 57 D2, D2 PWR ON LED_0603_1608Metric 2 Kingbright LED 0603 Indicator JLC-LED0603Indicator 58 D2, D2 SD03 D_SOD-323 2 Diodes Inc. SD03 JLC-SD03 59 D2, D2 YE LED_0603_1608Metric 2 Generic Yellow LED 0603 JLC-YellowLED0603 60 D2, D2 LED LED_0402_1005Metric 2 Generic LED 0402 JLC-LED0402 61 D3, D3 LED RED LED_0603_1608Metric 2 Generic Red LED 0603 JLC-RedLED0603 62 D4, D4 OK LED_0603_1608Metric 2 Generic Green LED 0603 JLC-GreenLED0603 63 D4, D4 LED GREEN LED_0603_1608Metric 2 Generic Green LED 0603 JLC-GreenLED0603 64 U2, U2, U2, U2 USBLC6-2SC6 SOT-23-6 4 Texas Instruments USBLC6-2SC6 JLC-USBLC6-2SC6 65 U1, U1 TPMP2359DJ SOT-23-6 2 TPMP2359DJ JLC-TPMP2359DJ 66 U1, U1 ME6216A33XG TSOT-23 2 ME6216A33XG JLC-ME6216A33XG 67 U1, U1 XC6206P332MR SOT-23 2 XC6206P332MR JLC-XC6206P332MR 68 U1, U1 CYPD3177-24LQ QFN-24-1EP_4x4mm_P0.5mm_EP2.75x2.75mm 2 CYPD3177-24LQ JLC-CYPD3177-24LQ 69 U2, U2 STM32F103CBTx LQFP-48_7x7mm_P0.5mm 2 STMicroelectronics STM32F103CBT6 JLC-STM32F103CBT6 70 U2, U2 INA180A3 SOT-23-5 2 INA180A3 JLC-INA180A3 71 U3, U3 STM32F405RGT6 LQFP-64_10x10mm_P0.5mm 2 STMicroelectronics STM32F405RGT6 JLC-STM32F405RGT6 72 U3, U3 STM32L432KBU6 QFN-32-1EP_5x5mm_P0.5mm_EP3.45x3.45mm 2 STMicroelectronics STM32L432KBU6 JLC-STM32L432KBU6 73 U3, U3 STM32F401RCTx LQFP-64_10x10mm_P0.5mm 2 STMicroelectronics STM32F401RCT6 JLC-STM32F401RCT6 74 U4, U4 nRF24L01P QFN-20-1EP_4x4mm_P0.5mm_EP2.5x2.5mm 2 Nordic Semiconductor nRF24L01+ JLC-nRF24L01+ 75 U4, U4 LTC4365xTS8 TSOT-23-8 2 Linear Technology LTC4365xTS8 JLC-LTC4365xTS8 76 Y1, Y1 SX3B16.000F0910F30 Crystal_SMD_3225-4Pin_3.2x2.5mm 2 Epson SX3B16.000F0910F30 JLC-SX3B16.000F0910F30 77 Y1, Y1 Crystal_GND24 Crystal_SMD_5032-4Pin_5.0x3.2mm 2 Epson Crystal GND24 JLC-CrystalGND24 78 Y1, Y1 16MHz Crystal_SMD_3225-4Pin_3.2x2.5mm 2 Generic 16MHz Crystal JLC-16MHzCrystal 79 Y1, Y1 Crystal_GND23 Crystal_SMD_2520-4Pin_2.5x2.0mm 2 Generic SMD Crystal for GND23 JLC-SMDCrystalforGND23 80 F1, F1 FMC16501WBTP Fuse_0603_1608Metric 2 Bourns FMC16501WBTP JLC-FMC16501WBTP 81 F1, F1 100mA Fuse_1206_3216Metric 2 Littelfuse 1206 Fuse 100mA JLC-1206Fuse100mA 82 F1, F1 250mA Fuse_1206_3216Metric 2 Littelfuse 1206 Fuse 250mA JLC-1206Fuse250mA 83 SW1, SW1, SW1, SW1 SW_SPDT SW_SPDT_CK_JS102011SAQN 4 CK JS102011SAQN JLC-CKJS102011SAQN 84 mouse-bite-1mm-slot, mouse-bite-1mm-slot, … VAL** mouse-bite-1mm-slot 56 JLCPCB Mouse Bite 1mm Slot JLC-MouseBite1mmSlot 85 REF**, REF**, REF**, REF**, REF**, REF**, REF**, REF** Fiducial_0.75mm_Mask1.5mm Fiducial_0.75mm_Mask1.5mm 8 Generic Fiducial 0.75mm Mask1.5mm JLC-Fiducial075mmMask1.5mm 86 , , , Fiducial_1mm_Mask3mm Fiducial_1mm_Mask3mm 4 Generic Fiducial 1mm Mask3mm JLC-Fiducial1mmMask3mm 87 Q1, Q1, Q2, Q2 DMP3099L SOT-23 4 DMP3099L JLC-DMP3099L 88 REF**, REF**, REF**, REF** Fiducial_0.5mm_Mask1mm Fiducial_0.5mm_Mask1mm 4 Generic Fiducial 0.5mm Mask1mm JLC-Fiducial05mmMask1mm 89 , Fiducial_1.5mm_Mask3mm Fiducial_1.5mm_Mask3mm 2 Generic Fiducial 1.5mm Mask3mm JLC-Fiducial15mmMask3mm 90 FB1, FB1 FerriteBead_Small L_0805_2012Metric 2 Murata BLM21PG121SN1D JLC-BLM21PG121SN1D 91 FB1, FB1 100 @ 100MHz L_0805_2012Metric 2 Murata BLM21PG121SN1D 100@100MHz JLC-BLM21PG121SN1D-100@100MHz 92 Q1, Q1 AO3401A SOT-23-3L_AOS 2 AO3401A JLC-AO3401A 93 Q1, Q1 TWGMC S9014 SOT-23 2 TWGMC S9014 JLC-TWGMC-S9014 94 Q3, Q3 2N7002NXAK SOT-23-3 2 2N7002NXAK JLC-2N7002NXAK 95 J1, J1 Screw_01x02 TerminalBlock_Phoenix_PT-1 5-2-3.5-H_1x02_P3.50mm_Horizontal 2 Phoenix PT-1.5-2-3.5 Screw Terminal JLC-PT1.5-2-3.5ScrewTerminal 96 J1, J1 USB_C_Receptacle_USB2.0_16P USB_C_Receptacle_G-Switch_GT-USB-7010ASV 2 G-Switch GT-USB-7010ASV JLC-GT-USB-7010ASV 97 J1, J1 USB_B_Micro 101181930001LF 2 Amphenol 101181930001LF JLC-101181930001LF 98 J1, J1 USB_C_Receptacle_USB2.0_16P USB_C_Receptacle_HCTL_HC-TYPE-C-16P-01A 2 HCTL HC-TYPE-C-16P-01A JLC-HC-TYPE-C-16P-01A 99 J2, J2 Conn_02x05_Odd_Even PinSocket_2x05_P1.27mm_Vertical_SMD 2 Samtec PinSocket 2x05 P1.27mm JLC-PinSocket2x05P1.27mm 100 J2, J2 SMA SMA_Samtec_SMA-J-P-X-ST-EM1_EdgeMount 2 Samtec SMA-J-P-X-ST-EM1 JLC-SMA-J-P-X-ST-EM1 101 J2, J2 Conn_01x10_Socket Hirose_DF13-10P-1.25DSA_1x10_P1.25mm_Vertical 2 Hirose DF13-10P-1.25DSA JLC-DF13-10P-1.25DSA 102 J2, J2 PJ-058A CUI_PJ-058A 2 CUI PJ-058A JLC-PJ-058A 103 J3, J3 USB_B_Micro USB_Micro-B_Amphenol_10103594-0001LF_Horizontal 2 Amphenol 10103594-0001LF JLC-10103594-0001LF 104 J3, J3 Conn_01x04_Socket FanPinHeader_1x04_P2.54mm_Vertical 2 Generic Fan Pin Header 1x04 JLC-FanPinHeader1x04 105 J3, J3 ARM 10pin PinHeader_2x05_P1.27mm_Vertical 2 Generic ARM 10pin Pin Header 2x05 JLC-ARM10pinPinHeader2x05 106 J4, J4 Conn_01x04 Molex_CLIK-Mate_502386-0470_1x04-1MP_P1.25mm_Horizontal 2 Molex CLIK-Mate 502386-0470 JLC-CLIK-Mate502386-0470 107 J4, J4 Conn_01x04 Samtec_UMPS-04-XX.X-X-V-S_1x04_P2.0mm_Socket 2 Samtec UMPS-04 JLC-UMPS-04 108 J5, J5 Conn_02x07_Odd_Even Samtec_HLE-107-02-xxx-DV_2x07_P2.54mm_Horizontal 2 Samtec HLE-107-02 JLC-HLE-107-02 109 J6, J6 Conn_01x03 PinHeader_1x03_P1.27mm_Vertical_SMD_Pin1Right 2 Generic Pin Header 1x03 P1.27mm JLC-PinHeader1x03P1.27mm
You now have numbered items (in the Item column) plus an extra "JLCPCB Part #" column with generated labels (using a "JLC-" prefix) for each recommended model. Feel free to adjust any entry as needed for your sourcing requirements.
Copy CSV content
No schematic yet
Talk to Flux to get started.
