[求助]哪位高手可以帮我把BOM整理出来啊 [复制链接]

PART LOCATION
Branch/Plant : 10
PCBA P/N : 1EVTTG24T.A1G
PCB P/N : 8EVTTG24T2A1G
Revise : 09/05/01
Side Field : C - component side
             S - soldering side
Seq# Item Part No    Description
          Qty Locator List                  Package Side
========================================================
  1  100000149900G   IC TTL 74LVC14ADBR 14P
          5   U23   U25   U26   U64   U179   SMD    C
      
  OPT:111900149108G  IC COMS 74LVC14ADB SSOP14
      
  2  220576031200G   RES 5.76K 1% 1/16W SMD 0402
         48   R1418 R1419 R1420 R1421 R1422  SMD    S
              R1423 R1424 R1425 R1426 R1427
              R1428 R1429 R1431 R1432 R1433
              R1434 R1435 R1436 R1437 R1438
              R1439 R1440 R1441 R1442 R1443
              R1444 R1445 R1446 R1447 R1448
              R1449 R1450 R1451 R1452 R1453
              R1454 R1455 R1456 R1457 R1458
              R1459 R1460 R1461 R1462 R1463
              R1464 R1465 R1466
      
  3  520003312060G   EMI FILTER ACH32C-331-T001 SMD
         50   L21   L22   L23   L25   L29    SMD    C
              L30   L51   L52   L53   L54
              L55   L56   L57   L58   L59
              L60   L61   L62   L63   L64
              L65   L66   L67   L68   L69
              L70   L71   L72   L73   L74
              L75   L76   L77   L78   L79
              L80   L81   L82   L83   L84
              L85   L86   L87   L88   L89
              L90   L99   L100  L101  L102
      
  4  192601010790G   IC X'CEIVER TN1010-B2 BGA576
         12   U148  U149  U150  U151  U152   SMD    C
              U153  U154  U155  U156  U157
              U158  U159
      
  5  6002800807ENG   ENG P/J 8P8C 1*1 F/S 10G
         12   P14   P15   P16   P17   P18    DIP    C
              P19   P20   P21   P22   P23
              P24   P25
      
  6  220576011200G   RES 57.6 1% 1/16W SMD 0402
         96   R621  R622  R623  R624  R625   SMD    C
              R626  R627  R628  R629  R630
              R631  R632  R633  R634  R635
              R636  R637  R638  R639  R640
              R641  R642  R643  R644  R645
              R646  R647  R648  R649  R650
              R651  R652  R653  R654  R655
              R656  R657  R658  R659  R660
              R661  R662  R663  R664  R665
              R666  R667  R668  R669  R670
              R671  R672  R673  R674  R675
              R676  R677  R678  R679  R680
              R681  R682  R683  R684  R685
              R686  R687  R688  R689  R690
              R691  R692  R693  R694  R695
              R696  R697  R698  R699  R700
              R701  R702  R703  R704  R705
              R706  R707  R708  R709  R710
              R711  R712  R713  R714  R715
              R716
      
  7  1006G           RD CIS Temp. Item No. 006G
         12   T2    T3    T4    T5    T6     SMD    C
              T7    T8    T9    T10   T11
              T12   T13
      
  8  601327635010G   CONN 1P D:10.31 F/M
          2   JP14  JP15                     DIP    C
      
  9  551250064640G   OSC 125.00625MHZ 50PPM 2.5VSMD
          4   X10   X11   X12   X13          SMD    C
      
10  146898327900G   IC SY89832UMG MLF16
          4   U117  U118  U120  U161         SMD    C
      
11  601414580202G   CONN HDM 351PIN P:2.0MM FEMALE
          1   P8                             SMD    C
      
12  601928766820G   CONN 72P P:2.54 F/M BLK P/F
          2   P6    P7                       DIP    C
      
13  1600101240ENG   IC CPU BCM1240C4K700G PBGA860
          1   U18                            SMD    C
      
  OPT:160000124054G  IC CPU BCM1240B2K700G PBGA860
      
14  147010667500G   IC SEQUENCER ADM1066ASUZ
          2   U66   U67                      SMD    C
      
15  146033738700G   IC TRANSLATOR MAX3373EEKA+
          1   U16                            SMD    C
      
16  160108993290G   IC MICRO/CTRL P89LPC932A1FDH
          1   U15                            SMD    C
      
17  601927591031G   CONN I-TRAC 7591-3123
          1   P4                             DIP    C
      
18  601927591016G   CONN I-TRAC 75910-1603
          1   P5                             DIP    C
      
19  601927591051G   CONN I-TRAC 75910-5123
          1   P3                             DIP    C
      
20  601320040140G   CONN 40PIN P:1.27MM FEMALE
          1   P1                             DIP    C
      
21  148079359800G   IC SENSOR G793D5U TSSOP20
          2   U9    U10                      SMD    C
      
22  142009946500G   IC DRIVER G994P1U SOP8
          6   U1    U2    U3    U4    U5     SMD    C
              U6
      
23  142009946500G   IC DRIVER G994P1U SOP8
          6   U163  U164  U165  U166  U168   SMD    S
              U170
      
24  192101760680G   IC USB/CTRL ISP1760BE LQFP128
          1   U17                            SMD    C
      
25  1611056821ENG   IC ETH/SW BCM56821A0KFSBG
          2   U51   U52                      SMD    C
      
26  111101642105G   IC  MC74HC164ADR2G SOIC 14P
          2   U65   U160                     SMD    C

谁有整理BOM的软件，可以分享一下吗，感谢

坛子里有的，搜一下

用excel上来

这种特殊格式的  用EXCEl好了   没有人专门写这种格式的BOM整理软件
这种BOM通用性不强

smtlnb:用excel上来 (2012-08-16 16:34) 

excel 打开也没有规律

jerryliuc:[图片] (2012-08-17 09:03) 

有哪位兄弟搞定发我邮箱115975077@qq.com

如果你很多这样的BOM，就要定制一个模板来整理，我伏做过很多非标的BOM。

此类BOM还是找高手定制吧

这种一般是ERP系统里面下载下来的BOM，定制一个小程序去读它就OK了。