{"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"]
[2,"贴片电容","10uF","0402C","C2",1,{"$f":"F4*20000","v":20000},null,"10V"]
[3,"贴片电容","22uF","0805C","C3, C5, C16, C19",4,80000,null,"25V"]
[4,"贴片电容","1uF","0402C","C4, C18, C24",3,60000,null,"25V"]
[5,"贴片电容","2.2uF","0402C","C6, C20",2,40000,null,"25V"]
[6,"贴片电容","12pF","0402C","C8, C10",2,40000,null,"50V"]
[7,"贴片电容","100pF","0402C","C11",1,20000,null,"50V"]
[8,"贴片电容","1.0pF","0402C","C13",1,20000,null,"50V"]
[9,"贴片二极管","SS14","SOD-323","D1, D3",2,40000]
[10,"贴片电感","3.3nH","0402L","L3",1,20000]
[11,"贴片三极管","AO3401","SOT-23-3","Q1, Q3",2,40000]
[12,"贴片三极管","AO3400","SOT-23","Q2",1,20000]
[13,"贴片电阻","3K/1%","0603RM","R1",1,20000]
[14,"贴片电阻","200K/1%","0402R","R2",1,20000]
[15,"贴片电阻","300K/1%","0402R","R3",1,20000]
[16,"贴片电阻","1K","0402R","R4, R11",2,40000]
[17,"贴片电阻","10K","0402R","R5, R6, R8",3,60000]
[18,"芯片","TP4056X","SOP-8P","U1",1,20000]
[19,"芯片","QMA7981","LGA-12_2*2-e0.25","U2",1,20000]
[20,"芯片","NRF52832-QFAA-R","QFN48P-6X6","U3",1,20000]
[21,"芯片","XC6206P302MR","SOT-23","U4",1,20000,null,"TOREX/特瑞仕"]
[22,"晶振","32MHz/12pF/10PPM","XTAL-SMD-2016","Y1",1,20000]
[23,"PCB板","FR4 34*25 厚1.2mm 沉金 绿油 ",null,null,1,20000,null,"由贴片厂拼板"]
[24,"蓝牙天线","定制，FR4 43*4 厚0.6mm，3M背胶，2.4G，3dB，馈线线长15cm，焊接",null,null,1,20000,{"$nulls":8},"东莞市连讯电子有限公司，吴先生，13925895621,https://dglianxun.taobao.com/?spm=2013.1.1000126.d21.16812536XOPYVt"]
[25,"4芯连接线","定制，单根外径2.5mm，长 6.5cm，护套剥皮10mm，线芯剥皮2mm上锡，两头焊接",null,null,1,20000,{"$nulls":8},"两头焊接"]
[26,"6芯连接线","定制，单根外径3.0mm，长15.5cm，护套剥皮10mm，线芯剥皮2mm上锡，两头焊接",null,null,1,20000,{"$nulls":8},"两头焊接"]
[27,"振动电机","扁平振动电机0827，出线3cm，焊接",null,null,1,20000]
[28,"高温电池","高温(耐高温80度)聚合物锂电池602530，真实容量>400mah，出线长1.5cm，电流>1A，焊接",null,null,1,20000]
[29,"外壳","定制，40*27*10.8mm",null,null,1,20000]
[30,"磁吸充电头","定制，4芯连接线，单根外径2.5mm，长 12.5cm，护套剥皮10mm，线芯剥皮2mm上锡，焊接",null,null,1,20000]
[]
[]
[]
[{"$nulls":10},{"$f":"SUM(K3:K35)*1.1","v":0},null,null,null,{"$f":"SUM(O3:O35)","v":0}]
[{"$nulls":9},"合计：",{"$f":"K36+O36","v":0}]
[{"$nulls":7},"一套合计：",{"$f":"K37+'前脚 BOM清单-20Kpcs'!M15+'后脚 BOM清单-20Kpcs'!M11","v":0}]

{"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"]
[2,"贴片电容","10uF","0603C","C5",1,{"$f":"F4*20000","v":20000},null,null,null,"16V"]
[2,"贴片电容","0.1uF","0402C","C6, C7",2,{"$f":"F5*20000","v":40000},null,null,null,"16V"]
[3,"贴片电阻","4.7K","0402R","R1, R2",2,40000]
[4,"芯片","LSM6DS3TR-C","LGA-14_2.5*3-e0.5","U1",1,20000]
[5,"芯片","QMC6310U","LGA-8_1.2*1.2-E0.4","U2",1,20000]
[6,"PCB板","FR4 14*13 厚1.0mm 沉金 绿油 ",null,null,1,20000]
[7,"外壳","直径2cm，厚度3mm",null,null,1,20000]
[8,"磁铁","直径0.6cm，厚度1mm，高温磁铁",null,null,2,40000]
[9,"铁片","直径2cm，厚度 0.3mm，带背胶",null,null,2,40000]
[]
[{"$nulls":12},{"$f":"SUM(M3:M13)*1.1","v":0},null,null,null,{"$f":"SUM(Q3:Q13)","v":0}]
[{"$nulls":11},"合计：",{"$f":"M14+Q14","v":0}]

{"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"]
[2,"贴片电容","10uF","0603C","C5",1,{"$f":"F4*20000","v":20000},null,null,null,"16V"]
[3,"芯片","QMC6310U","LGA-8_1.2*1.2-E0.4","U2",1,20000]
[4,"PCB板","FR4 14*13 厚1.0mm 沉金 绿油 ",null,null,1,20000]
[5,"外壳","直径2cm，厚度3mm，带4芯线(OD2.5mm)",null,null,1,20000]
[6,"磁铁","直径0.6cm，厚度1mm，高温磁铁",null,null,2,40000]
[7,"铁片","直径2cm，厚度 0.3mm，带背胶",null,null,2,40000]
[{"$nulls":12},{"$f":"SUM(M3:M9)*1.1","v":0},null,null,null,{"$f":"SUM(Q3:Q9)","v":0}]
[{"$nulls":11},"合计：",{"$f":"M10+Q10","v":0}]
[]
[]
[]
[]
[]
[]
[{"$nulls":18}," "]

{"sheet":"加工","index":3,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
["加工"]
["序号","名称","型号","封装","位号","用量","总用量","采购数量","单价","总金额"]
[1,"SMT加工","包括钢网",null,null,1]
[2,"测试工装",null,null,null,1]
[3,"脱机烧录器",null,null,null,1]
[4,"手工焊接",null,null,null,1]
[5,"灌胶",null,null,null,1]
[6,"生产检测充电线",null,null,null,1]
[7,"外壳模具费",null,null,null,1]
[8,"代料费用",null,null,null,1,{"$nulls":4},"这是什么费用?"]