EXCEL物料编码自动生成VIP免费

序号图纸编号客户物料编码材质线径CP02-PVC30S2CDQ00-WH0HJ-E-18001PVC3TPU2.5编码组成:大类(CP02)+材质(00)+线径(00)+线材类型(00)+芯线根数(00)+接口类型(00)+流水(00)+颜色(00)W02WS12001200左端DC5.5*2.1公头,右端剥皮10mm浸锡2mm,Φ3.0白色PVC,线长120mm接口类型颜色新编码直线2白色CP02-PVC30S2CDQ00-WH0弹簧线2白色CP02-TPU25C2CMT00-WH0(00)+流水(00)+颜色(00)线材类型芯线根数DC对浸锡Micro对Tyep-C物料大类CP02-辅助重复次数材质代码线径代码代码CP02-PVC30S2CDQ-WH01TPUTPU1.818弹簧线C0CP02-TPU25C2CMT-WH01TPETPE220直线S11PVCPVC3.43422TPEETPEE2.52533PEPE2.626442.82855330663.23273.83884.6*2.3462393.0*2.03020104.2*3.04230115.8*2.85828124.6*2.24622133.535141516线材类型芯线根数1718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193代码接口类型代码颜色代码0CMM白色-WH01CMT苹果灰-GY12CMP黑色-BK03CDQ4CKM5CAQ6CTQMQMAMXMSYMYTDTDR水晶头对浸锡RQ尾卡对尾卡SSTRMicro对MicroMicro对Tyep-CMicro对LightningDC对浸锡MK转MOLEX4PA公对浸锡Type-C对浸锡Micro对浸锡Micro对a公Micro对套绳线Micro对尾卡Micro哑机线Type-C哑机线DC转Type-CDC转水晶头Type-C对水晶头MRNT尾卡对浸锡SQDSKTDMRP水晶头对尾卡RSTS水晶头对套绳线RX浸锡对浸锡QQPQAD水晶头对水晶头RRTTSMASDDSTASMicro对水晶头Mini对Type-CDC对尾卡Type-C对MOLEX4PDC转Micro水晶头对LightningType-C对尾卡Lightning对浸锡A公对DCC/C对尾卡M/A对尾卡D/D对尾卡T/A对尾卡