EXCEL物料编码自动生成

序号图纸编号客户物料编码材质线径CP02-PVC30S2CDQ00-WH0HJ-E-18001W02WS12001200左端DC5.5*2.1公头,右端剥皮10mm浸锡2mm,Φ3.0白色PVC,线长120mmPVC3TPU2.5编码组成:大类(CP02)+材质(00)+线径(00)+线材类型(00)+芯线根数(00)+接口类型(00)+流水(00)+颜色(00)线材类型芯线根数接口类型颜色新编码直线2DC对浸锡白色CP02-PVC30S2CDQ00-WH0弹簧线2Micro对Tyep-C白色CP02-TPU25C2CMT00-WH0编码组成:大类(CP02)+材质(00)+线径(00)+线材类型(00)+芯线根数(00)+接口类型(00)+流水(00)+颜色(00)物料大类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编码组成:大类(CP02)+材质(00)+线径(00)+线材类型(00)+芯线根数(00)+接口类型(00)+流水(00)+颜色(00)1718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193代码接口类型代码颜色代码0CMicro对MicroMM白色-WH01CMicro对Tyep-CMT苹果灰-GY12CMicro对LightningMP黑色-BK03CDC对浸锡DQ4CMK转MOLEX4PKM5CA公对浸锡AQ6CType-C对浸锡TQMicro对浸锡MQMicro对a公MAMicro对套绳线MXMicro对尾卡MSMicro哑机线YMType-C哑机线YTDC转Type-CDTDC转水晶头DR水晶头对浸锡RQ尾卡对尾卡SSType-C对水晶头TRMicro对水晶头MRMini对Type-CNT尾卡对浸锡SQDC对尾卡DSType-C对MOLEX4PKTDC转MicroDM水晶头对LightningRP水晶头对尾卡RSType-C对尾卡TS水晶头对套绳线RX浸锡对浸锡QQLightning对浸锡PQA公对DCAD水晶头对水晶头RRC/C对尾卡TTSM/A对尾卡MASD/D对尾卡DDST/A对尾卡TAS