{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Main Monitor Board 0301 (RS-BOM"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Main Monitor Board 0301 (RS-BOM","index":0,"n_rows":89,"n_cols":13,"rows_kept":89,"cut":false,"hidden":false,"merged":[[5,1,5,2],[6,1,6,2]]}
["Bill Of Materials"]
["Report Written:","Thursday, February 07, 2019"]
["Project Path:","E:\\Electronics\\Can Bus\\Main Monitor Board 0301\\Main Monitor Board 0301.prj"]
["Design Path:","E:\\Electronics\\Can Bus\\Main Monitor Board 0301\\Main Monitor Board 0301.pcb"]
["Design Title:"]
["Created:","2018-02-22T16:31:33"]
["Last Saved:","2019-02-07T13:26:04"]
["Editing Time:","13892 min"]
["Units:","mm (precision 2)"]
[]
["Component","Value","Reel No","Package","RS Part Number","DigiKey No","Qty","Com Price","per","Price","In Stock","Ref Name","Description"]
["0R","0R",null,"RES0603","716-9743",null,1,257.47000000000003,5000,{"$f":"H12/I12*G12","v":5.1494000000000005E-2},null,"R72","Resistor,0R0 1% 0.1W SMT0603"]
["1k","1K",26,"RES0603","213-2266",null,19,0.214,1,{"$f":"H13/I13*G13","v":4.0659999999999998},null,"R11-13, R25-37, R51, R56, R75","Resistor,1K 1% 0.1W SMT0603"]
["1K8","1.8K",28,"RES0603","804-8867",null,2,55.07,5000,2.2027999999999999E-2,null,"R9-10","Resistor,1K8 SMT0603"]
["1M","1M",null,"RES0603","213-2676",null,1,0.372,1,0.372,null,"R41","Resistor,1M 1% 0.1W SMT0603"]
["1.0nF","1nF",null,"CAP_C0603","770-4140",null,4,0.45400000000000001,1,1.8160000000000001,null,"C26, C35, C41, C71","Cap 1.0nF SMT 0603"]
["2 Pin ST 5","2 ST","Hand","2 Con ST 5","361-7667",null,1,6.8840000000000003,1,6.8840000000000003,null,"J4","2 way Screw Terminal, 5mm pitch"]
["2K2","2.2K",30,"RES0603","213-2317",null,8,0.39800000000000002,1,3.1840000000000002,null,"R24, R39, R42, R44, R46, R54, R78, R80","Resistor,2K2 1% 0.1W SMT0603"]
["3K3","3.3K",31,"RES0603","213-2339",null,2,0.28399999999999997,1,0.56799999999999995,null,"R53, R67","Resistor,3K3 1% 0.1W SMT0603"]
["4 Pin ST 5","4 ST","Hand","4 Con ST 5","361-7689",null,2,11.676,1,23.352,null,"J5-6","4 way Screw Terminal,5mm pitch"]
["4K7","4.7K",33,"RES0603","213-2367",null,3,0.372,1,1.1160000000000001,null,"R47, R59, R62","Resistor,4K7 1% 0.1W SMT0603"]
["4.7uF 6.3v T","4.7uF 6.3V",null,"CAP_C1206T","538-2335",null,2,1.37,1,2.74,null,"C32, C78","Capacitor Tantalum SMT1206 4.7uF 6.3V"]
["4.7uF","4.7uF 6.3V",null,"CAP_C0603","815-1367",null,1,1.31,1,1.31,null,"C12","Cap 4.7uF SMT 0603"]
["5K6","5.6K",34,"RES0603","804-8899",null,1,1.7999999999999999E-2,1,1.7999999999999999E-2,null,"R66","Resistor,5K6 1% 0.1W SMT0603"]
["8mHz","8MHz","Hand","HEX15","547-6452",null,1,4.07,1,4.07,null,"XTAL2","Crystal 8.000MHz"]
["10K","10K",35,"RES0603","804-8921",null,24,55.07,5000,0.26433600000000002,null,"R16-19, R22, R38, R40, R43, R45, R52, R55, R57-58, R61, R64-65, R68-71, R73-74, R77, R79","Resistor,10K SMT0603"]
["10nF","10nF",40,"CAP_C0603","904-0101",null,15,0.216,1,3.2399999999999998,null,"C16, C21, C23, C28, C30, C34, C37, C40, C47, C60-61, C66-67, C72, C74","Cap 10nF SMT 0603"]
["10uF 6.3v T","10uF 6.3V",null,"CAP_C1206T","684-3913",null,4,1.91,1,7.64,null,"C24, C31, C38, C75","Capacitor Tantalum SMT1206 10uF 6.3V"]
["10uF 35v 1206","10uF",42,"CAP_C1206","111-0486",null,3,5.1180000000000003,1,15.354000000000001,null,"C46, C59, C70","Capacitor SMT1206 10uF 35v"]
["12MHz","12MHz","Hand","HEX15","814-9510",null,1,3.456,1,3.456,null,"XTAL1","Crystal 12.000MHz"]
["15pF","15pF",null,"CAP_C0603","545-4014",null,4,0.10299999999999999,1,0.41199999999999998,null,"C7, C15, C42-43","Cap 15pF SMT 0603"]
["15R 1206","15R",null,"RES 1206","802-9466",null,6,158.91,5000,0.19069199999999997,null,"R3-8","Resistor,15R 1% 0.25W SMT1206"]
["22nF","22nF",41,"CAP_C0603","180-6413",null,2,0.30399999999999999,1,0.60799999999999998,null,"C45, C52","Cap 22nF SMT 0603"]
["24LC512-I/SN","512 kbit",null,"SOIC 8","703-7961",null,1,23.86,1,23.86,null,"U4","EEPROM 512Kbit SOIC 8"]
["27R","27R",null,"RES0603","804-8722",null,2,69.400000000000006,5000,2.7760000000000003E-2,null,"R14-15","Resistor,27R SMT0603"]
["47K","47K",null,"RES0603","804-8987",null,2,56.78,5000,2.2712E-2,null,"R1-2","Resistor,47K 1% 0.1W SMT0603"]
["47pF","47pF",null,"CAP_C0603","766-5095",null,2,143.96,5000,5.7584000000000003E-2,null,"C8, C11","Cap 47pF SMT 0603"]
["47uF 25v T","47uF",null,"CAPT491D","801-5502",null,1,16.783999999999999,1,16.783999999999999,null,"C10","Capacitor Tantalum SMT T491D 47uF 25v"]
["100nF","100nF",21,"CAP_C0603","801-5347",null,32,0.28199999999999997,1,9.0239999999999991,null,"C1-6, C9, C13-14, C17-19, C22, C25, C27, C29, C33, C36, C39, C50, C53-58, C62-63, C68, C73, C76-77","Cap 100nF SMT 0603"]
["100R","100R",36,"RES0603","804-8760",null,2,100,5000,0.04,null,"R49-50","Resistor,100R 1% 0.1W SMT0603"]
["100uF 35v AD10","100uF","Hand","PCAP 10x10","520-2188",null,2,7.1310000000000002,1,14.262,null,"C49, C65","Cap Alum 100uF 35V SMD10"]
["120R","120R",37,"RES0603",2132159,null,1,0.28399999999999997,1,0.28399999999999997,null,"R60","Resistor,120R 1% 0.1W SMT0603"]
["220pF","220pF",20,"CAP_C0603","170-0129",null,2,80.010000000000005,1000,0.16002000000000002,null,"C44, C51","Cap 220pF SMT 0603"]
["330R","330R",null,"RES0603","804-8808",null,2,91.72,5000,3.6687999999999998E-2,null,"R20-21","Resistor,330R 1% 0.1W SMT0603"]
["470R","470R",38,"RES0603",2132222,null,3,0.21199999999999999,1,0.63600000000000001,null,"R48, R63, R76","Resistor,470R 1% 0.1W SMT0603"]
["470uF 25v AD10","470uF","Hand","PCAP 10x10","715-1293",null,2,7.8360000000000003,1,15.672000000000001,null,"C48, C64","Cap Alum 470uF 25V SMD10"]
["1000uF 35v D13X21.5 TH","1000uF","Hand","CAP_13 th","315-0754",null,1,20.25,1,20.25,null,"C20","Cap 1000uF 35v Dia 13 TH"]
["3296W-1-103LF","10K","Hand","SHDR3W54P0X254_1X3_953X483X115",5219647,null,1,34.659999999999997,1,34.659999999999997,null,"R23","3296W Through Hole Trimmer Resistor, 10K"]
["AT45DB641E-SHN-T","64 Mbit",null,"SOIC 8 Flash","Mouser/Digi-Key","AT45DB641E-SHN-TCT-ND",8,65.09,1,520.72,null,"FL1-8","FLASH Memory, SOIC 8"]
["BAS16","85V 250mA",null,"SOT23 D",8259291,null,2,0.44800000000000001,1,0.89600000000000002,null,"D3, D14","BAS16 0.25A 85V Switching Diode, SOT-23"]
["BC807","45V 500mA",1,"SOT23 T","146-0856",null,1,0.17899999999999999,1,0.17899999999999999,null,"U3","BC807, PNP TRANSISTOR, SOT-23"]
["BC817","45V 500mA",2,"SOT23 T","484-2252",null,8,0.32200000000000001,1,2.5760000000000001,null,"Q1-8","BC817, NPN Transistor, SOT-23"]
["CONN_DIL_34","72 Dil","Hand","34 DIL","547-3172",null,1,19.57,2,9.7850000000000001,null,"J7","34 Way Dil, 2.54"]
["CONN_SIL_6","20 Sil","Hand","6 SIL","681-3007",null,1,5.9189999999999996,3,1.9729999999999999,null,"PL1","6 way Pin Header"]
["CONN_SIL_6-2.0","20 Sil 2mm","Hand","6 SIL 2mm K2","681-3293",null,1,11.351000000000001,3,3.783666666666667,null,"PL3","6 way Pin Header 2mm Key 2"]
["CONN_SIL_7","20 Sil","Hand","7 SIL","681-3007",null,1,5.9189999999999996,3,1.9729999999999999,null,"PL4","7 way Pin Header"]
["CONN_SIL_8","20 Sil","Hand","8 SIL","681-3007",null,1,5.9189999999999996,2,2.9594999999999998,null,"PL2","8 way Pin Header"]
["ES3J","600V 3A",43,"DO-214AB","761-3619",null,3,6.5339999999999998,1,19.602,null,"D4, D7, D17","Diode Switching 600V 3A DO214AB"]
["FG0H104ZF","5.5V","Hand","CAP_11 TH","789-7952",null,1,12.744999999999999,1,12.744999999999999,null,"C69","Super Cap Dia 11 TH 5.5v"]
["FPC3AMR1-20TNBT-U","20 Way","Hand","ZIF-20 Bottom","673-6900",null,1,9.9580000000000002,1,9.9580000000000002,null,"J3","LCD 20, 2.54mm Pitch, Right Angle Header"]
["FT232RL","3 MBd",null,"SOP65P780X200-28M","406-580",null,1,70.790000000000006,1,70.790000000000006,null,"IC2","USB to Serial, X & T, SSOP-28"]
["FUSE HOLDER FLR","12V","Hand","SMTFuse 5x20","410-7672",null,1,19.97,1,19.97,null,"FS1","FUSE HOLDER, Blade, 5-20"]
["Ind 33nHz (DNF)","33 nHz",null,"L0603","863-7616",null,0,0.64300000000000002,1,0,null,"L7","INDUCTOR 33nHz L0603"]
["Ind 33uHz","33 uHz","Hand","SDR0805","736-1286",null,2,5.5979999999999999,1,11.196,null,"L5-6","INDUCTOR 33uHz SDR0805"]
["Ind 100nHz","100 nHz",null,"IND0603_3650_TYCO","532-3011",null,5,2.8380000000000001,1,14.190000000000001,null,"L1-4, L8","Inductor 100nH"]
["L5973D-HS","35V 2A",47,"HSOP8-L","380-034",null,2,42.805999999999997,1,85.611999999999995,null,"U2, U6","Switching Reg,2.5A,4-36Vin,HSOP8"]
["Led SMD0805 Green","Green",51,"LED_SM 0805","888-6304",null,2,0.872,1,1.744,null,"LED3-4","LED Uni-Color Green SMD0805"]
["Led SMD0805 Red","Red",52,"LED_SM_0805","888-6313",null,2,0.71399999999999997,1,1.4279999999999999,null,"LED1-2","LED Uni-Color Red SMD0805"]
["Led SMD0805 Yellow","Yellow",53,"LED_SM 0805","888-6316",null,1,0.85899999999999999,1,0.85899999999999999,null,"LED5","LED Uni-Color Yellow SMD0805"]
["LL4148-GS08","100V 2A",3,"MELF_SOD-80","700-2886",null,10,0.46200000000000002,1,4.62,null,"D5-6, D8-13, D21-22","Diode Switching 300mA 100V Mini-MELF"]
["M7395-2","2 Way","Hand","M7395-2","173-2916",null,2,8.1579999999999995,1,16.315999999999999,null,"J2, J8","2 way r/a PCB header w/friction lock"]
["M7395-4","4 Way","Hand","M7395-4","173-2944",null,2,2.778,1,5.556,null,"J1, J9","4 way r/a PCB header w/friction lock"]
["MAX3232EID 9.9x3.9","RS232 RX TX",null,"16 SOIC Small","528-252",null,1,23.562000000000001,1,23.562000000000001,null,"U7","RS-232 TRANSCEIVER"]
["MBS-12","1000uF","Hand","Buz12","511-7664",null,1,21.27,1,21.27,null,"BUZ1","Buzzer MBS-12"]
["MCP2551-I/SN","1MBps",null,"SOIC 8","738-6036",null,1,18.535,1,18.535,null,"U5","CAN Transceiver"]
["MCX Rt Angle Connector","MCX","Hand","ANT","885-7545","WM5541-ND",1,26.95,1,26.95,null,"ANT1","MCX Rt Angle / Straight Coax Connector"]
["PIC24EP512GU810-I/PT","16 Bit PIC",null,"TQFP100_12X12MC-L","755-9354","PIC24EP512GU810-I/PT-ND",1,120.65,1,{"$f":"H77/I77*G77","v":120.65},null,"U1","PIC24EP512GU810-I/PT"]
["S1216DR8","GPRS",null,"S1216R","NUVISION ??",null,1,220,1,220,null,"GPS1","GPS Module"]
["SMCJ26A","1500 W",44,"DO-214AB","714-7248",null,3,6.4729999999999999,1,19.419,null,"D1, D16, D19","Diode SMCJ26A"]
["SMS2100","100V 2A",27,"DO-213AB",{"$f":"'[1]Flow Control PCB 0401 (RS-BOM)'!$E$57","v":"Electrocomp"},null,4,6.08,1,24.32,null,"D2, D15, D18, D20","Diode Schottky-Rectifiers SMS2100"]
["V23105A5003A201","12V 3A","Hand","V23105",1354662,null,2,49.423999999999999,1,98.847999999999999,null,"K1-2","PCB Mount Non-Latching Relay, 12V dc Coil"]
["VNC2-48L1C","USB 2",null,"QFP50P900X900X160-48N","720-3874","768-1049-1-ND",1,60.67,1,60.67,null,"IC1","VNC2-48L1, USB 2, 48-Pin LQFP"]
["Totals",null,null,null,null,null,243,null,null,{"$f":"SUM(J12:J82)","v":1670.1664806666668},null,null,"Component Total"]
[]
[]
[null,null,null,"USD $","EX Rate"]
[null,null,null,50,14,null,5,{"$f":"D87*E87","v":700},null,{"$f":"H87/G87","v":140},null,null,"Bare Board Price"]
[null,null,null,null,null,null,null,null,null,70,null,null,"Pick & Place"]
[null,null,null,null,null,null,null,null,null,{"$f":"J83+J87+J88","v":1880.1664806666668},null,null,"Main Board Price"]