{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["R和L BOM清单-10Kpcs","前脚 BOM清单-20Kpcs","后脚 BOM清单-20Kpcs","加工"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"R和L BOM清单-10Kpcs","index":0,"n_rows":38,"n_cols":16,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["主板BOM清单"]
["序号","名称","型号","封装","位号","用量","总用量","采购数量","备注","材料单价","材料金额","加工点数","加工总点数","加工单价","加工总金额"]
[1,"贴片电容","0.1uF","0402C","C1, C7, C9, C12, C14, C15, C17",7,{"$f":"F3*20000","v":140000},null,"50V",0.05,{"$f":"J3*F3","v":0.35000000000000003},2,{"$f":"L3*F3","v":14},8.0000000000000002E-3,{"$f":"N3*M3","v":0.112}]
[2,"贴片电容","10uF","0402C","C2",1,{"$f":"F4*20000","v":20000},null,"10V",0.06,{"$f":"J4*F4","v":0.06},2,{"$f":"L4*F4","v":2},8.0000000000000002E-3,1.6E-2]
[3,"贴片电容","22uF","0805C","C3, C5, C16, C19",4,80000,null,"25V",0.14000000000000001,0.56000000000000005,2,8,8.0000000000000002E-3,6.4000000000000001E-2]
[4,"贴片电容","1uF","0402C","C4, C18, C24",3,60000,null,"25V",0.02,0.06,2,6,8.0000000000000002E-3,4.8000000000000001E-2]
[5,"贴片电容","2.2uF","0402C","C6, C20",2,40000,null,"25V",8.5000000000000006E-2,0.17,2,4,8.0000000000000002E-3,3.2000000000000001E-2]
[6,"贴片电容","12pF","0402C","C8, C10",2,40000,null,"50V",8.0000000000000002E-3,1.6E-2,2,4,8.0000000000000002E-3,3.2000000000000001E-2]
[7,"贴片电容","100pF","0402C","C11",1,20000,null,"50V",7.0000000000000001E-3,7.0000000000000001E-3,2,2,8.0000000000000002E-3,1.6E-2]
[8,"贴片电容","1.0pF","0402C","C13",1,20000,null,"50V",8.0000000000000002E-3,8.0000000000000002E-3,2,2,8.0000000000000002E-3,1.6E-2]
[9,"贴片二极管","SS14","SOD-323","D1, D3",2,40000,null,null,4.1000000000000002E-2,8.2000000000000003E-2,2,4,8.0000000000000002E-3,3.2000000000000001E-2]
[10,"贴片电感","3.3nH","0402L","L3",1,20000,null,null,1.4999999999999999E-2,1.4999999999999999E-2,2,2,8.0000000000000002E-3,1.6E-2]
[11,"贴片三极管","AO3401","SOT-23-3","Q1, Q3",2,40000,null,null,0.13,0.26,3,6,8.0000000000000002E-3,4.8000000000000001E-2]
[12,"贴片三极管","AO3400","SOT-23","Q2",1,20000,null,null,0.13,0.13,3,3,8.0000000000000002E-3,2.4E-2]
[13,"贴片电阻","3K/1%","0603RM","R1",1,20000,null,null,3.7000000000000002E-3,3.7000000000000002E-3,2,2,8.0000000000000002E-3,1.6E-2]
[14,"贴片电阻","200K/1%","0402R","R2",1,20000,null,null,2.2000000000000001E-3,2.2000000000000001E-3,2,2,8.0000000000000002E-3,1.6E-2]
[15,"贴片电阻","300K/1%","0402R","R3",1,20000,null,null,2.2000000000000001E-3,2.2000000000000001E-3,2,2,8.0000000000000002E-3,1.6E-2]
[16,"贴片电阻","1K","0402R","R4, R11",2,40000,null,null,2E-3,4.0000000000000001E-3,2,4,8.0000000000000002E-3,3.2000000000000001E-2]
[17,"贴片电阻","10K","0402R","R5, R6, R8",3,60000,null,null,2E-3,6.0000000000000001E-3,2,6,8.0000000000000002E-3,4.8000000000000001E-2]
[18,"芯片","TP4056X","SOP-8P","U1",1,20000,null,null,0.72,0.72,8,8,8.0000000000000002E-3,6.4000000000000001E-2]
[19,"芯片","QMA7981","LGA-12_2*2-e0.25","U2",1,20000,null,null,4.5,{"$f":"J21*F21","v":4.5},12,{"$f":"L21*F21","v":12},8.0000000000000002E-3,{"$f":"N21*M21","v":9.6000000000000002E-2}]
[20,"芯片","NRF52832-QFAA-R","QFN48P-6X6","U3",1,20000,null,null,32,32,48,48,8.0000000000000002E-3,0.38400000000000001]
[21,"芯片","XC6206P302MR","SOT-23","U4",1,20000,null,"TOREX/特瑞仕",0.48,0.48,3,3,8.0000000000000002E-3,2.4E-2]
[22,"晶振","32MHz/12pF/10PPM","XTAL-SMD-2016","Y1",1,20000,null,null,0.68,0.68,4,4,8.0000000000000002E-3,3.2000000000000001E-2]
[23,"PCB板","FR4 34*25 厚1.0mm 沉金 绿油 ",null,null,1,20000,null,"由贴片厂拼板",0.5,0.5,1,1,0.2,0.2]
[24,"蓝牙天线","定制，FR4 43*4 厚0.6mm，3M背胶，2.4G，3dB，馈线线长15cm，焊接",null,null,1,20000,null,"我司提供",0.8,0.8,1,1,0.2,0.2,"东莞市连讯电子有限公司，吴先生，13925895621,https://dglianxun.taobao.com/?spm=2013.1.1000126.d21.16812536XOPYVt"]
[25,"4芯连接线","定制，单根外径2.5mm，长 7cm，护套剥皮8mm，线芯剥皮2mm上锡，两头焊接",null,null,1,20000,null,"我司提供",0.28000000000000003,0.28000000000000003,8,8,0.12,0.96,"两头焊接"]
[26,"6芯连接线","定制，单根外径3.0mm，长15cm，护套剥皮8mm，线芯剥皮2mm上锡，两头焊接",null,null,1,20000,null,"我司提供",0.33,0.33,12,12,0.12,1.44,"两头焊接"]
[27,"振动电机","扁平振动电机0827，出线3cm，焊接",null,null,1,20000,null,"我司提供",1.6,1.6,2,2,0.2,0.4]
[28,"高温电池","高温(耐高温80度)聚合物锂电池602530，真实容量>400mah，出线长1.5cm，电流>1A，焊接",null,null,1,20000,null,"我司提供",10.1,10.1,2,2,0.2,0.4]
[29,"外壳","定制，40*27*10.8mm",null,null,1,20000,null,"我司提供",0.2,0.2,1,1,0.3,0.3]
[30,"磁吸充电头","定制，4芯连接线，单根外径2.5mm，长 16cm，护套剥皮8mm，线芯剥皮2mm上锡，焊接",null,null,1,20000,null,"我司提供",4,4,1,5,0.12,0.6]
[31,"屏蔽罩","定制，洋白铜，0.2mm厚度，焊接",null,null,1,20000,null,"我司提供",2.8,2.8,3,3,0.2,0.60000000000000009]
[]
[]
[{"$nulls":10},{"$f":"SUM(K3:K35)*1.1","v":66.79871},null,null,null,{"$f":"SUM(O3:O35)","v":6.2840000000000007}]
[{"$nulls":9},"合计：",{"$f":"K36+O36","v":73.082710000000006}]
[{"$nulls":7},"一套合计：",{"$f":"K37+'前脚 BOM清单-20Kpcs'!M15+'后脚 BOM清单-20Kpcs'!M11","v":97.949110000000005}]

{"sheet":"前脚 BOM清单-20Kpcs","index":1,"n_rows":15,"n_cols":17,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,7],[2,16,7,16]]}
["前脚 BOM"]
["序号","名称","型号","封装","位号","用量","总用量","采购数量","单价","总金额","备注","材料单价","材料金额","加工点数","加工总点数","加工单价","加工总金额"]
[1,"贴片电容","1uF","0402C","C2, C3, C4",3,{"$f":"F3*20000","v":60000},null,null,null,"25V",0.02,{"$f":"L3*F3","v":0.06},2,{"$f":"N3*F3","v":6},8.0000000000000002E-3,0.5]
[2,"贴片电容","10uF","0603C","C5",1,{"$f":"F4*20000","v":20000},null,null,null,"16V",0.1,{"$f":"L4*F4","v":0.1},2,{"$f":"N4*F4","v":2},8.0000000000000002E-3]
[2,"贴片电容","0.1uF","0603C","C6, C7",2,{"$f":"F5*20000","v":40000},null,null,null,"16V",0.05,{"$f":"L5*F5","v":0.1},2,{"$f":"N5*F5","v":4},8.0000000000000002E-3]
[3,"贴片电阻","4.7K","0402R","R1, R2",2,40000,{"$nulls":4},2E-3,4.0000000000000001E-3,2,4,8.0000000000000002E-3]
[4,"芯片","LSM6DS3TR-C","LGA-14_2.5*3-e0.5","U1",1,20000,{"$nulls":4},10.8,10.8,14,14,8.0000000000000002E-3]
[5,"芯片","QMC6310U","LGA-8_1.2*1.2-E0.4","U2",1,20000,{"$nulls":4},1.75,1.75,8,8,8.0000000000000002E-3]
[6,"PCB板","FR4 14*13 厚1.0mm 沉金 绿油 ",null,null,1,20000,{"$nulls":4},0.26,0.26,1,1,0.1,{"$f":"P9*O9","v":0.1}]
[7,"外壳","直径2cm，厚度3mm，带6芯线(OD3.0mm)",null,null,1,20000,null,null,null,"我司提供",0.2,0.2]
[8,"磁铁","直径1cm，厚度1mm，高温磁铁",null,null,2,40000,null,null,null,"我司提供",0.7,1.4,1,1,0.2,0.2]
[9,"铁片","直径2cm，厚度 0.3mm，带背胶",null,null,2,40000,null,null,null,"我司提供",0.5,1,1,2,0.2,0.4]
[]
[{"$nulls":12},{"$f":"SUM(M3:M13)*1.1","v":17.241400000000002},null,null,null,{"$f":"SUM(Q3:Q13)","v":1.2000000000000002}]
[{"$nulls":11},"合计：",{"$f":"M14+Q14","v":18.441400000000002}]

{"sheet":"后脚 BOM清单-20Kpcs","index":2,"n_rows":18,"n_cols":19,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,7],[2,16,4,16]]}
["后脚 BOM"]
["序号","名称","型号","封装","位号","用量","总用量","采购数量","单价","总金额","备注","材料单价","材料金额","加工点数","加工总点数","加工单价","加工总金额"]
[1,"贴片电容","1uF","0402C","C3, C4",2,{"$f":"F3*20000","v":40000},null,null,null,"25V",0.02,{"$f":"L3*F3","v":0.04},2,{"$f":"N3*F3","v":4},8.0000000000000002E-3,0.5]
[2,"贴片电容","10uF","0603C","C5",1,{"$f":"F4*20000","v":20000},null,null,null,"16V",0.1,{"$f":"L4*F4","v":0.1},2,{"$f":"N4*F4","v":2},8.0000000000000002E-3]
[3,"芯片","QMC6310U","LGA-8_1.2*1.2-E0.4","U2",1,20000,{"$nulls":4},1.75,1.75,8,8,8.0000000000000002E-3]
[4,"PCB板","FR4 14*13 厚1.0mm 沉金 绿油 ",null,null,1,20000,{"$nulls":4},0.26,0.26,1,1,0.1,{"$f":"P6*O6","v":0.1}]
[5,"外壳","直径2cm，厚度3mm，带4芯线(OD2.5mm)",null,null,1,20000,null,null,"我司提供",null,0.2,0.2]
[6,"磁铁","直径1cm，厚度1mm，高温磁铁",null,null,2,40000,null,null,"我司提供",null,0.7,1.4,1,1,0.2,0.2]
[7,"铁片","直径2cm，厚度 0.3mm，带背胶",null,null,2,40000,null,null,"我司提供",null,0.5,1,1,2,0.2,0.4]
[{"$nulls":12},{"$f":"SUM(M3:M9)*1.1","v":5.2250000000000005},null,null,null,{"$f":"SUM(Q3:Q9)","v":1.2000000000000002}]
[{"$nulls":11},"合计：",{"$f":"M10+Q10","v":6.4250000000000007}]
[]
[]
[]
[]
[]
[]
[{"$nulls":18}," "]

{"sheet":"加工","index":3,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
["加工"]
["序号","名称","型号","封装","位号","用量","总用量","采购数量","单价","总金额"]
[1,"SMT加工","包括钢网",null,null,1,null,null,220,{"$f":"I3*F3","v":220}]
[2,"测试工装",null,null,null,1,null,null,1500,{"$f":"I4*F4","v":1500}]
[3,"脱机烧录器",null,null,null,1,null,null,3750,3750]
[4,"手工焊接",null,null,null,1,null,null,8.74,8.74]
[5,"灌胶",null,null,null,1,null,null,2,2]
[6,"生产检测充电线",null,null,null,1,null,null,null,0]
[7,"外壳模具费",null,null,null,1,null,null,19000,19000]
[8,"代料费用",null,null,null,1,null,null,74.31,{"$f":"I10*F10","v":74.31},"这是什么费用?"]
[{"$nulls":9},{"$f":"SUM(J3:J10)","v":24555.05}]