EXCEL使用技巧（for orcad）

把1-10 分成1.2.3.4.5.....
=index(row(indirect(substitute($A1,"-",":"))),column(A1))
输出bom
输出excel时候分类明晰：
Value\tPCB Footprint\tReference\tDsecription
{Value}\t{PCB Footprint}\t{Reference}\t{Dsecription}
/
Item\tQuantity\tReference\tValue\tPCB Footprint\tInstalled\tPART_NUMBER\tImplementation\tVOLT\tDsecription\tDevice
{Item}\t{Quantity}\t{Reference}\t{Value}\t{PCB Footprint}\t{Installed}\t{PART_NUMBER}\t{Implementation}\t{VOLT}\t{Dsecription}\t{Device}
/
Value\tPCB Footprint\tReference\tDsecription\tOption
{Value}\t{PCB Footprint}\t{Reference}\t{Dsecription}\t{Option}
excel计算元件个数：
=LEN(B1)-LEN(SUBSTITUTE(B1,",",""))+1
计算表格内字符长度：
=LEN(C1)