{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["报价对比","广东铵特电子科技股份有限公司报价","广州千兆精密电子有限公司报价","主板BOM","前脚 BOM","后脚 BOM"],"not_rendered":{"charts":0,"images":1,"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":"报价对比","index":0,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,6],[20,0,20,6],[37,0,37,1],[38,0,38,1],[17,0,17,1],[18,0,18,1]]}
["广州千兆精密电子有限公司报价"]
["序号","产品名称","含税单价","数量","含税总价","发票税点","备注"]
[1,"主机物料费",28.64,7000,{"$f":"C3*D3","v":200480},"11(实际开13个点增值税发票)","电池3.9元"]
[2,"前脚物料费",10.98,7000,{"$f":"C4*D4","v":76860},"11(实际开13个点增值税发票)"]
[3,"后脚物料费",2.1800000000000002,7000,15260.000000000002,"11(实际开13个点增值税发票)"]
[4,"焊接加工费",4.6399999999999997,7000,32479.999999999996,"11(实际开13个点增值税发票)"]
[5,"产品灌胶测试",3.89,7000,27230,"11(实际开13个点增值税发票)","工时费38元/小时"]
[6,"振动电机",1.57,7000,10990,"13个点增值税发票"]
[7,"4芯连接线",0.75,7000,5250,"13个点增值税发票"]
[8,"6芯连接线",1.27,7000,8890,"13个点增值税发票"]
[9,"外壳",0.82,7000,5740,"13个点增值税发票"]
[10,"磁吸充电头",5.15,7000,36050,"13个点增值税发票","生产时间需要21天"]
[11,"蓝牙天线",0.71,7000,4970,"13个点增值税发票"]
[12,"高温磁铁",0.44,7000,3080,"13个点增值税发票"]
[13,"铁片",1,7000,7000,"不开发票"]
[14,"充电线",7,7000,49000,"13个点增值税发票"]
[15,"5V充电头",3.355,7000,23485,"10(实际开13个点增值税发票)"]
["单只总价",null,{"$f":"SUM(C3:C17)","v":72.39500000000001},7000,506765.00000000006,"13个点增值税发票","生产时间需要40天，如果紧急，需要提前做磁吸头"]
["一双总价",null,{"$f":"C18*2","v":144.79000000000002},null,null,"13个点增值税发票"]
[]
["广东铵特电子科技股份有限公司报价"]
["序号","产品名称","含税单价","数量","含税总价",null,"备注"]
[1,"主机物料费",34.799999999999997,7000,{"$f":"C23*D23","v":243599.99999999997},"13个点增值税发票","电池7元"]
[2,"前脚物料费",10.199999999999999,7000,{"$f":"C24*D24","v":71400},"13个点增值税发票"]
[3,"后脚物料费",2.1,7000,14700,"13个点增值税发票"]
[4,"焊接加工费",9.06,7000,63420,"13个点增值税发票"]
[5,"产品灌胶",1.73,7000,12110,"13个点增值税发票"]
[6,"产品测试",1.55,7000,10850,"13个点增值税发票","工时费50元/小时"]
[7,"4芯连接线",0.75,7000,5250,"13个点增值税发票"]
[8,"6芯连接线",1.27,7000,8890,"13个点增值税发票"]
[9,"外壳",0.82,7000,5740,"13个点增值税发票"]
[10,"磁吸充电头",5.15,7000,36050,"13个点增值税发票","生产时间需要21天"]
[11,"蓝牙天线",0.71,7000,4970,"13个点增值税发票"]
[12,"高温磁铁",0.44,7000,3080,"13个点增值税发票"]
[13,"铁片",1,7000,7000,"不开发票"]
[14,"充电线",7,7000,49000,"13个点增值税发票"]
[15,"5V充电头",3.355,7000,23485,"10(实际开13个点增值税发票)"]
["单只总价",null,{"$f":"SUM(C23:C37)","v":79.935000000000002},7000,559545,"13个点增值税发票","生产时间需要40天，如果紧急，需要提前做磁吸头"]
["一双总价",null,{"$f":"C38*2","v":159.87},null,null,"13个点增值税发票"]

{"sheet":"广东铵特电子科技股份有限公司报价","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"广州千兆精密电子有限公司报价","index":2,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7],[4,5,4,6],[6,0,7,0],[6,1,7,1],[6,4,7,4],[6,6,7,6],[6,7,7,7],[23,1,23,7],[24,1,24,6],[13,1,13,4],[14,1,14,7],[16,1,16,7],[18,1,18,7],[19,1,19,7],[22,1,22,7]]}
["广州千兆精密电子有限公司"]
["千兆精密电子报价单"]
["甲方：","广州偶游网络科技有限公司",null,null,"乙 方:","广州千兆精密电子有限公司"]
["联系人：","郑工",null,null,"业务：","杨树林"]
["电话：",15876555139,null,null,"电话：",18202072498]
["日期：","2022-8-31",null,null,"日期：","2022-8-31"]
["序号","产品名称","加工数量","产品单价","含税单价","产品含税总价","工艺要求","备注"]
[null,null,"PCS","RMB",null,"（RMB)"]
[1,"SmartShoes_V1.2.2 加工费",7000,4.18,{"$f":"ROUND(D9*1.11,2)","v":4.6399999999999997},{"$f":"E9*C9","v":32479.999999999996}]
[2,"产品灌胶",7000,3.5,{"$f":"ROUND(D10*1.11,2)","v":3.89},{"$f":"E10*C10","v":27230}]
[3,"前脚物料费",7000,9.89,{"$f":"ROUND(D11*1.11,2)","v":10.98},{"$f":"E11*C11","v":76860}]
[4,"后脚物料费",7000,1.96,{"$f":"ROUND(D12*1.11,2)","v":2.1800000000000002},{"$f":"E12*C12","v":15260.000000000002}]
[5,"主机物料费",7000,27.8,{"$f":"ROUND(D13*1.11,2)","v":30.86},{"$f":"E13*C13","v":216020},null,"不含线材（4芯、6芯）、振动电机"]
["汇总",{"$nulls":4},{"$f":"SUM(F9:F13)","v":367850}]
["备注","因测试无具体时间，报价不包含产品测试和测试所需的测试治具费用"]
["说明："]
["(1)","包公包料预付所有款项百分之60.剩余余款项产品交完，质量没问题全部付清"]
["(2)","此报价单含税。"]
["(3)","贴片元器件﹤1206（包含0201、0402、0603、0805封装）封装贴片CHIP料计2个焊点；>1206封装的计4个焊点；排容、排阻记8个焊点；IC 20脚以下1Pin为一焊点（含8脚），20脚以上2pin为一个焊点。玻璃二极管、三极管计3个点,钽电容B、C、D、E型算4个点,异形零件另计。"]
["(4)","物料损耗:Ｒ、C、D、Q等标准封装为0402的元器件为3%,0603封装和0805封装的元器件为2%,1206和三极管（或同类型封装）为0.3%，8脚（含8脚）IC以下为0.3%，8-14脚IC为0.3‰， (IC/PCB来料不良以一换一,订单批量少于1000PCS, 不计物料损耗。) 超损材料费在加工费中扣除。"]
["(5)","此报价单根据客户所提供的BOM单报价，贴片时以实际点数为准。"]
["(6)","自备钢网(    ),我方采购客户付款(     ),      元/张。  "]
["(7)","客户必须提供可以机贴物料（如卷料、盘料、管料），若提供散料或不良物料以及PCB    板，或由于设计原因，导致我公司发生额外工时，则另加工时费。"]
["(8)","由客户设计原因导致生产中出现的小封装元件贴大焊盘、大元件贴小焊盘而产生的品质缺陷（元件一头没锡、少锡、翘件等），我方不负责维修，或我方维修，客户承担维修费用。"]
["(9)","检验标准依据IPC-A-610C，允收水准为AQL：0.65(MA），如有特殊检验规范请事先告知。"]
["(10)","请客户在收到此报价单后三日内回签，超过三日将视为客户已确认无议。"]
[null,"本报价如确认，请签字并回传我公司，多谢！"]
[]
[null,"客户确认:",null,null,"供应商确定："]
[null,"日    期:",null,null,"日      期:"]
["税号：91440101MA5CLARHX0"]
["开户银行：广州银行股份有限公司东圃支行"]
["账号：800264416602013"]
["地址：广州市天河区新塘大街3号2栋202房                                                            "]
["电话:   020-82347216                                                                "]

{"sheet":"主板BOM","index":3,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
["主板BOM清单"]
["序号","名称","型号","封装","位号","用量","总用量","采购数量","单价","总金额","备注"]
[1,"贴片电容","0.1uF","0402C","C1, C7, C9, C12, C14, C15, C17, C24",8]
[2,"贴片电容","10uF","0402C","C2",1]
[3,"贴片电容","22uF","0805C","C3, C5, C16, C19",4]
[4,"贴片电容","1uF","0402C","C4, C18",3]
[5,"贴片电容","2.2uF","0402C","C6, C20",2]
[6,"贴片电容","12pF","0402C","C8, C10",2]
[7,"贴片电容","100pF","0402C","C11",1]
[8,"贴片电容","1.0pF","0402C","C13",1]
[9,"贴片二极管","SS14","SOD-323","D1, D3",2]
[10,"贴片电感","3.3nH","0402L","L3",1]
[11,"贴片三极管","AO3401","SOT-23-3","Q1, Q3",2]
[12,"贴片三极管","AO3400","SOT-23","Q2",1]
[13,"贴片电阻","3K/1%","0603RM","R1",1]
[14,"贴片电阻","200K/1%","0402R","R2",1]
[15,"贴片电阻","300K/1%","0402R","R3",1]
[16,"贴片电阻","1K/1%","0402R","R4, R11",2]
[17,"贴片电阻","10K/1%","0402R","R5, R6, R8",3]
[18,"芯片","TP4056X","SOP-8P","U1",1]
[19,"芯片","QMA7981","LGA-12_2*2-e0.25","U2",1]
[20,"芯片","NRF52832-QFAA-R","QFN48P-6X6","U3",1,{"$nulls":4},"先烧录再SMT加工"]
[21,"芯片","XC6206P302MR","SOT-23","U4",1,{"$nulls":4},"TOREX(特瑞仕)"]
[22,"晶振","32MHz/12pF/10PPM","XTAL-SMD-2016","Y1",1,{"$nulls":4},"YXC(扬兴科技)"]
[23,"PCB板","FR4 34*25 厚1.0mm 沉金 绿油 ",null,null,1,{"$nulls":4},"由贴片厂家拼板"]
[24,"振动电机","扁平振动电机0827，出线2cm，焊接",null,null,1]
[25,"高温电池","高温(耐高温80度)聚合物锂电池602530，真实容量>400mah，出线长1.5cm，电流>1A，焊接",null,null,1,{"$nulls":4},"需要确定线径和线长"]
[26,"4芯连接线","28AWG（19/0.08STCU）*6C + 过粉\nID: 0.62±0.03mm 铁氟龙绝缘，芯色：红，白，绿，黑，蓝， 焊接不缩皮\nOD: 2.5±0.1mm PVC 80P 黑色半雾面外被\n长（L）＝ 60mm ，两端脱皮7mm，剥皮镀锡2.0mm，两头焊接",null,null,1,{"$nulls":4},"我司提供"]
[27,"6芯连接线","28AWG（19/0.08STCU）*6C + 过粉\nID: 0.62±0.03mm 铁氟龙绝缘，芯色：红，白，绿，黑，蓝，黄 , 焊接不缩皮\nOD: 3.0±0.1mm PVC 80P 黑色半雾面外被\n长（L）＝ 150mm ，两端脱皮7mm，剥皮镀锡2.0mm，两头焊接",null,null,1,{"$nulls":4},"我司提供"]
[28,"外壳","定制，40*27*10.8mm",null,null,1,{"$nulls":4},"我司提供"]
[29,"磁吸充电头","定制，4芯连接线，单根外径2.5mm，长 12cm，护套剥皮10mm，线芯剥皮2mm上锡，焊接",null,null,1,{"$nulls":4},"我司提供"]
[30,"蓝牙天线","定制，FR4 43*4 厚0.6mm，3M背胶，2.4G，3dB，馈线线长12.3cm，焊接",null,null,1,{"$nulls":4},"我司提供"]

{"sheet":"前脚 BOM","index":4,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["前脚 BOM"]
["序号","名称","型号","封装","位号","用量","总用量","采购数量","单价","总金额","备注"]
[1,"贴片电容","1uF","0402C","C2, C3",2]
[2,"贴片电容","2.2uF","0402C","C4",1]
[3,"贴片电容","10uF","0603C","C5",1]
[4,"贴片电容","0.1uF","0402C","C6, C7",2]
[5,"贴片电阻","100K","0402R","R1, R2",2]
[6,"芯片","LSM6DS3TR-C","LGA-14_2.5*3-e0.5","U1",1]
[7,"芯片","QMC6310U","LGA-8_1.2*1.2-E0.4","U2",1,{"$nulls":4},"注意：这颗芯片SMT加工特别容易虚焊，建议开阶梯钢网"]
[8,"PCB板","FR4 17.5*17 厚1.0mm 沉金 绿油 ",null,null,1,{"$nulls":4},"注意：拼板要考虑到分板后不能有突起超过外形的，否则放不进壳子里"]
[9,"磁铁","直径0.6cm，厚度1mm，高温磁铁",null,null,2,{"$nulls":4},"我司提供"]
[10,"铁片","直径2cm，厚度 0.3mm，带背胶",null,null,2,{"$nulls":4},"我司提供"]
[11,"外壳","直径2cm，厚度3mm",null,null,1,{"$nulls":4},"我司提供"]

{"sheet":"后脚 BOM","index":5,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["后脚 BOM"]
["序号","名称","型号","封装","位号","用量","总用量","采购数量","单价","总金额","备注"]
[1,"贴片电容","1uF","0402C","C3",21]
[2,"贴片电容","2.2uF","0402C","C4",1]
[3,"贴片电容","10uF","0603C","C5",1]
[4,"芯片","QMC6310U","LGA-8_1.2*1.2-E0.4","U2",1,{"$nulls":4},"注意：这颗芯片SMT加工特别容易虚焊，建议开阶梯钢网"]
[5,"PCB板","FR4 14*13 厚1.0mm 沉金 绿油 ",null,null,1,{"$nulls":4},"注意：拼板要考虑到分板后不能有突起超过外形的，否则放不进壳子里"]
[6,"磁铁","直径0.6cm，厚度1mm，高温磁铁",null,null,2,{"$nulls":4},"我司提供"]
[7,"铁片","直径2cm，厚度 0.3mm，带背胶",null,null,2,{"$nulls":4},"我司提供"]
[8,"外壳","直径2cm，厚度3mm，带4芯线(OD2.5mm)",null,null,1,{"$nulls":4},"我司提供"]