Dear,
I already used variant functionals to get the attached Matrix BOM analysis, who can help to solve per VBA, here thanks in advance!
I already used variant functionals to get the attached Matrix BOM analysis, who can help to solve per VBA, here thanks in advance!
MultiBOM to MatrixBOM.xlsx | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
H | I | K | P | Q | R | ||||||||
1 | Add "SNR" | ||||||||||||
10 | No | Level | AL Part Number | Vendor | Component information | Short Text | |||||||
11 | 1 | 1 | 1307320067 | SNR | Z-DIODE | ||||||||
12 | 2 | 2 | 1307320067 | NEX | BZX84-C18 | Z-DIODE | |||||||
13 | 3 | 1 | 1307320096 | SNR | DIODE | ||||||||
14 | 4 | 1 | 1309997049 | SNR | RESISTOR OTHER | ||||||||
15 | 5 | 2 | 1304503290 | VIS | D25-CRCW1206 100 10R0 1% xx e3 | RESISTOR | |||||||
16 | 6 | 2 | 1461001605 | YAG | AC1206FR-xx10RL | RESISTOR OTHER | |||||||
17 | 7 | 2 | 1304503428 | KOA | RK73H2BT..10R0F | RESISTOR | |||||||
18 | 8 | 2 | 1461000599 | WAL | MR12X10R0F_L | RESISTOR OTHER | |||||||
19 | 9 | 1 | 1309997078 | SNR | RESISTOR OTHER | ||||||||
20 | 10 | 2 | 1304503296 | KOA | RK73H1JT..1002F | RESISTOR | |||||||
21 | 11 | 2 | 1461001322 | YAG | AC0603FR-xx10KL | RESISTOR OTHER | |||||||
22 | 12 | 2 | 1461000715 | WAL | MR06X1002F_L | RESISTOR OTHER | |||||||
23 | 13 | 2 | 1304503198 | VIS | D11-CRCW0603 100 10k0 1% xx e3 | RESISTOR | |||||||
24 | 14 | 1 | 1309997150 | SNR | RESISTOR OTHER | ||||||||
25 | 15 | 2 | 1461001559 | YAG | AC0603FR-xx39KL | RESISTOR OTHER | |||||||
26 | 16 | 2 | 1304503409 | VIS | D11-CRCW0603 100 39k0 1% xx e3 | RESISTOR | |||||||
27 | 17 | 2 | 1304503408 | KOA | RK73H1JT..3902F | RESISTOR | |||||||
28 | 18 | 2 | 1461000804 | WAL | MR06X3902F_L | RESISTOR OTHER | |||||||
29 | 19 | 1 | 1309997156 | SNR | CAPACITOR CERAMIC | ||||||||
30 | 20 | 2 | 1462000183 | TAY | HMK107B7103KAHT | CERAMIC-CAPACITOR | |||||||
31 | 21 | 2 | 1462000136 | VIS | VJ0603Y103KXBA_31X | CERAMIC-CAPACITOR | |||||||
32 | 22 | 2 | 1307328192 | TDK | CGA3E2X7R2A103KT | CERAMIC-CAPACITOR | |||||||
33 | 23 | 2 | 1307328194 | MUT | GCM188R72A103KA37D | CAPACITOR CERAMIC | |||||||
34 | 24 | 2 | 1462000265 | SAG | CL10B103KC85PB_ | CAPACITOR CERAMIC | |||||||
35 | 25 | 1 | 1309997193 | SNR | DIODE DIODE | ||||||||
36 | 26 | 2 | 1307320105 | NEX | BAS516-Q | DIODE | |||||||
37 | 27 | 1 | 1309997197 | SNR | RESISTOR OTHER | ||||||||
38 | 28 | 2 | 1304503458 | VIS | D11-CRCW0603 100 10R0 1% xx e3 | RESISTOR | |||||||
39 | 29 | 2 | 1304503457 | KOA | RK73H1JT..10R0F | RESISTOR | |||||||
40 | 30 | 2 | 1461001650 | YAG | AC0603FR-xx10RL | RESISTOR OTHER | |||||||
41 | 31 | 2 | 1461000728 | WAL | MR06X10R0F_L | RESISTOR OTHER | |||||||
42 | 32 | 1 | 1309997280 | SNR | CAPACITOR CERAMIC | ||||||||
43 | 33 | 2 | 1462000181 | TAY | HMK107B7223KAHT | CERAMIC-CAPACITOR | |||||||
44 | 34 | 2 | 1307328247 | MUT | GCM188R72A223KA37D | CAPACITOR CERAMIC | |||||||
45 | 35 | 2 | 1462000261 | SAG | CL10B223KC85PB_ | CAPACITOR CERAMIC | |||||||
46 | 36 | 2 | 1307328248 | TDK | CGA3E2X7R2A223KT | CERAMIC-CAPACITOR | |||||||
47 | 37 | 2 | 1307328249 | VIS | VJ0603Y223KXBA_31 | CERAMIC-CAPACITOR | |||||||
48 | 38 | 1 | 1309997302 | SNR | RESISTOR OTHER | ||||||||
49 | 39 | 2 | 1304503540 | KOA | RK73H1JT..2053F | RESISTOR | |||||||
50 | 40 | 2 | 1304503544 | VIS | D11-CRCW0603 100 205k 1% xx e3 | RESISTOR | |||||||
51 | 41 | 1 | 1309997409 | SNR | RESISTOR OTHER | ||||||||
52 | 42 | 2 | 1461001019 | WAL | MR04X1001F_L | RESISTOR OTHER | |||||||
53 | 43 | 2 | 1304503647 | VIS | CRCW0402 1k00 FK xx E3 | RESISTOR | |||||||
54 | 44 | 2 | 1461001542 | YAG | AC0402FR-xx1KL | RESISTOR OTHER | |||||||
55 | 45 | 2 | 1304503631 | KOA | RK73H1ET..1001F | RESISTOR | |||||||
56 | 46 | 1 | 1309997411 | SNR | RESISTOR OTHER | ||||||||
57 | 47 | 2 | 1461000585 | WAL | MR04X1002F_L | RESISTOR OTHER | |||||||
58 | 48 | 2 | 1304503649 | VIS | CRCW0402 10K0 FK xx E3 | RESISTOR | |||||||
59 | 49 | 2 | 1461001325 | YAG | AC0402FR-xx10KL | RESISTOR OTHER | |||||||
60 | 50 | 2 | 1304503619 | KOA | RK73H1ET..1002F | RESISTOR | |||||||
61 | 51 | 1 | 1309997416 | SNR | CAPACITOR CERAMIC | ||||||||
62 | 52 | 2 | 1462000458 | SAG | CL05C101JB51PB_ | CAPACITOR CERAMIC | |||||||
63 | 53 | 2 | 1462000213 | VIS | VJ0402A101JXAA_31X | CAPACITOR CERAMIC | |||||||
64 | 54 | 2 | 1307328287 | MUT | GCM1555C1H101JA16D | CAPACITOR CERAMIC | |||||||
65 | 55 | 2 | 1462000091 | TDK | CGA2B2C0G1H101JT | CERAMIC-CAPACITOR | |||||||
66 | 56 | 1 | 1309997419 | SNR | CAPACITOR CERAMIC | ||||||||
67 | 57 | 2 | 1462000266 | VIS | VJ0402Y332KXBA_31X | CAPACITOR CERAMIC | |||||||
68 | 58 | 2 | 1307328284 | MUT | GCM155R72A332KA37D | CAPACITOR CERAMIC | |||||||
69 | 59 | 2 | 1462000098 | TDK | CGA2B3X7S2A332KT | CAPACITOR CERAMIC | |||||||
70 | 60 | 1 | 1309997422 | SNR | CAPACITOR CERAMIC | ||||||||
71 | 61 | 2 | 1462000429 | TAY | UMK105 B7103KVH_ | CAPACITOR CERAMIC | |||||||
72 | 62 | 2 | 1307328281 | MUT | GCM155R71H103KA55D | CAPACITOR CERAMIC | |||||||
73 | 63 | 2 | 1462000083 | TDK | CGA2B3X7R1H103KT | CERAMIC-CAPACITOR | |||||||
74 | 64 | 2 | 1462000382 | SAG | CL05B103KB54PB_ | CAPACITOR CERAMIC | |||||||
75 | 65 | 2 | 1307328289 | VIS | VJ0402Y103KXAA_31 | CERAMIC-CAPACITOR | |||||||
76 | 66 | 1 | 1309997483 | SNR | DIODE DIODE | ||||||||
77 | 67 | 2 | 1307320147 | VIS | S1JHE3_A | DIODE DIODE | |||||||
78 | 68 | 1 | 1309997488 | SNR | CAPACITOR CERAMIC | ||||||||
79 | 69 | 2 | 1462000396 | SAG | CL32B475KBJ4PB_ | CAPACITOR CERAMIC | |||||||
80 | 70 | 2 | 1307328298 | MUT | GCM32ER71H475KA55L | CERAMIC-CAPACITOR | |||||||
81 | 71 | 2 | 1462000067 | TDK | CGA6P3X7R1H475KT | CAPACITOR CERAMIC | |||||||
82 | 72 | 2 | 1462000316 | TAY | UMK325_B7475KMH_ | CERAMIC-CAPACITOR | |||||||
83 | 73 | 1 | 1309997523 | SNR | RESISTOR OTHER | ||||||||
84 | 74 | 2 | 1304503790 | KOA | RK73H1ET..1962F | RESISTOR | |||||||
85 | 75 | 2 | 1461000792 | WAL | MR04X1962F_L | RESISTOR OTHER | |||||||
86 | 76 | 2 | 1304503791 | VIS | CRCW0402 19k6 FK xx E3 | RESISTOR | |||||||
87 | 77 | 1 | 1309997561 | SNR | CAPACITOR CERAMIC | ||||||||
88 | 78 | 2 | 1462000100 | TDK | CGA4J3X7R1E225KT | CAPACITOR CERAMIC | |||||||
89 | 79 | 2 | 1307328328 | MUT | GCM21BR71E225KA73L | CERAMIC-CAPACITOR | |||||||
90 | 80 | 1 | 1309997585 | SNR | RESISTOR OTHER | ||||||||
91 | 81 | 2 | 1304503850 | KOA | RK73H1ET..3162F | RESISTOR | |||||||
92 | 82 | 2 | 1304503851 | VIS | CRCW0402 31k6 FK xx E3 | RESISTOR | |||||||
93 | 83 | 2 | 1461000795 | WAL | MR04X3162F_L | RESISTOR OTHER | |||||||
94 | 84 | 2 | 1461001642 | YAG | AC0402FR-xx31K6L | RESISTOR OTHER | |||||||
95 | 85 | 1 | 1309997603 | SNR | INDUCTOR INDUCTOR | ||||||||
96 | 86 | 2 | 1463000261 | MUT | BLM21SP601SH1D | INDUCTOR INDUCTOR | |||||||
97 | 87 | 2 | 1307322049 | TDK | MPZ2012S601ATD25 | INDUCTANCE | |||||||
98 | 88 | 1 | 1309997616 | SNR | TRANSISTOR MOSFET | ||||||||
99 | 89 | 2 | 1307345114 | ONS | 2V7002KT1G | FET | |||||||
100 | 90 | 2 | 1307345091 | DIO | 2N7002KQ-7 | TRANSISTOR MOSFET | |||||||
101 | 91 | 1 | 1309997699 | SNR | INDUCTOR INDUCTOR | ||||||||
102 | 92 | 2 | 1307322056 | TDK | MPZ2012S300ATD25 | INDUCTANCE | |||||||
103 | 93 | 2 | 1463000263 | MUT | BLM21SN300SH1D | INDUCTOR INDUCTOR | |||||||
104 | 94 | 1 | 1309997782 | SNR | CAPACITOR CERAMIC | ||||||||
105 | 95 | 2 | 1462000390 | SAG | CL10B104KB8VPF_ | CAPACITOR CERAMIC | |||||||
106 | 96 | 2 | 1307328375 | TDK | CGA3E2X7R1H104KT***S | CERAMIC-CAPACITOR | |||||||
107 | 97 | 2 | 1462000073 | MUT | GCJ188R71H104KA12D | CAPACITOR CERAMIC | |||||||
108 | 98 | 1 | 1309997985 | SNR | CAPACITOR CERAMIC | ||||||||
109 | 99 | 2 | 1307328392 | TDK | CGA2B2C0G1H470JT | CERAMIC-CAPACITOR | |||||||
110 | 100 | 2 | 1462000304 | VIS | VJ0402A470JXAA_31X | CAPACITOR CERAMIC | |||||||
111 | 101 | 2 | 1307328393 | MUT | GCM1555C1H470JA16D | CERAMIC-CAPACITOR | |||||||
112 | 102 | 1 | 1460000223 | SNR | LED | ||||||||
113 | 103 | 2 | 1460000223 | OOS | LA E67F-CADA-24-3A5A | LED | |||||||
114 | 104 | 1 | 1466000036 | SNR | CAPACITOR CERAMIC | ||||||||
115 | 105 | 2 | 1462000161 | TAY | UMK316AC7475KLHTE | CERAMIC-CAPACITOR | |||||||
116 | 106 | 2 | 1462000032 | TDK | CGA5L3X7R1H475KT | CAPACITOR CERAMIC | |||||||
117 | 107 | 2 | 1462000267 | SAG | CL31B475KBHVPB_ | CAPACITOR CERAMIC | |||||||
118 | 108 | 2 | 1462000033 | MUT | GCM31CC71H475KA03L | CAPACITOR CERAMIC | |||||||
119 | 109 | 1 | 1466000042 | SNR | DIODE DIODE | ||||||||
120 | 110 | 2 | 1465000002 | NEX | BZX585-C4V7 | Z-DIODE | |||||||
121 | 111 | 2 | 1465000001 | ONS | SZMM5Z4V7T1G | Z-DIODE | |||||||
122 | 112 | 1 | 1466000066 | SNR | DIODE DIODE | ||||||||
123 | 113 | 2 | 1465000261 | TSC | P6SMB27CAH | DIODE DIODE | |||||||
124 | 114 | 2 | 1465000009 | VIS | P6SMB27CAHE3_A | DIODE DIODE | |||||||
125 | 115 | 1 | 1466000096 | SNR | RESISTOR OTHER | ||||||||
126 | 116 | 2 | 1461000037 | VIS | CRCW0402 4k70 FK xx E3 | RESISTOR | |||||||
127 | 117 | 2 | 1461000035 | KOA | RK73H1ET..4701F | RESISTOR | |||||||
128 | 118 | 2 | 1461000810 | WAL | MR04X4701F_L | RESISTOR OTHER | |||||||
129 | 119 | 2 | 1461001553 | YAG | AC0402FR-xx4K7L | RESISTOR OTHER | |||||||
130 | 120 | 1 | 1466000122 | SNR | INDUCTOR INDUCTOR | ||||||||
131 | 121 | 2 | 1463000010 | TAY | NRS6045T6R3MMGKV | INDUCTANCE | |||||||
132 | 122 | 1 | 1466000199 | SNR | RESISTOR OTHER | ||||||||
133 | 123 | 2 | 1461000112 | KOA | RK73H1ET..1302F | RESISTOR | |||||||
134 | 124 | 2 | 1461001492 | WAL | MR04X1302F_L | RESISTOR OTHER | |||||||
135 | 125 | 2 | 1461000113 | VIS | CRCW0402 13k0 FK xx E3 | RESISTOR OTHER | |||||||
136 | 126 | 1 | 1466000243 | SNR | CAPACITOR CERAMIC | ||||||||
137 | 127 | 2 | 1462000211 | TAY | EMK325_B7226KMH_ | CAPACITOR CERAMIC | |||||||
138 | 128 | 2 | 1462000055 | TDK | CGA6P1X7R1C226MT | CAPACITOR CERAMIC | |||||||
139 | 129 | 2 | 1462000395 | SAG | CL32B226KOJVPB_ | CAPACITOR CERAMIC | |||||||
140 | 130 | 2 | 1462000054 | MUT | GCM32ER71C226KE19L | CERAMIC-CAPACITOR | |||||||
141 | 131 | 1 | 1466000511 | SNR | RESISTOR OTHER | ||||||||
142 | 132 | 2 | 1461000445 | VIS | CRCW1206 4R70 FK xxe3 | RESISTOR | |||||||
143 | 133 | 2 | 1461001371 | WAL | MR12W4R70F_L | RESISTOR OTHER | |||||||
144 | 134 | 2 | 1461000494 | KOA | RK73H2BT..4R70F | RESISTOR | |||||||
145 | 135 | 1 | 1466000575 | SNR | TRANSISTOR BIPOLAR | ||||||||
146 | 136 | 2 | 1465000136 | NEX | BC846BW-Q | BIP_TRANSISTOR | |||||||
147 | 137 | 2 | 1465000101 | ONS | SBC846BWT1G | BIP_TRANSISTOR | |||||||
148 | 138 | 1 | 1466000611 | SNR | DIODE DIODE | ||||||||
149 | 139 | 2 | 1465000115 | ONS | SZBZX84B6V2LT_G | Z-DIODE | |||||||
150 | 140 | 2 | 1465000114 | NEX | BZX84-B6V2 | Z-DIODE | |||||||
151 | 141 | 2 | 1465000329 | VIS | BZX84B6V2-HE3 | DIODE DIODE | |||||||
152 | 142 | 1 | 1466000614 | SNR | RESISTOR OTHER | ||||||||
153 | 143 | 2 | 1461000554 | VIS | CRCW0603110kFKxxe3 | RESISTOR OTHER | |||||||
154 | 144 | 2 | 1461001248 | WAL | MR06X1103F_L | RESISTOR OTHER | |||||||
155 | 145 | 2 | 1461000553 | KOA | RK73H1JT..1103F | RESISTOR OTHER | |||||||
156 | 146 | 1 | 1466000629 | SNR | DIODE DIODE | ||||||||
157 | 147 | 2 | 1465000122 | VIS | S2JHE3_A | DIODE DIODE | |||||||
158 | 148 | 1 | 1466000635 | SNR | DIODE DIODE | ||||||||
159 | 149 | 2 | 1465000123 | NEX | BAS16-Q | DIODE DIODE | |||||||
160 | 150 | 2 | 1465000124 | ONS | SBAS16LT_G | DIODE DIODE | |||||||
161 | 151 | 1 | 1466000720 | SNR | INTEGRATED_CIRCUIT OTHER | ||||||||
162 | 152 | 2 | 1464000097 | TI | TPS92630QPWPRQ1 | INTEGRATED_CIRCUIT OTHER | |||||||
163 | 153 | 1 | 1466000744 | SNR | RESISTOR OTHER | ||||||||
164 | 154 | 2 | 1466000744 | SNR | Dummy | RESISTOR+SNR | |||||||
165 | 155 | 1 | 1466000761 | SNR | RESISTOR OTHER | ||||||||
166 | 156 | 2 | 1466000761 | SNR | Dummy | RESISTOR+SNR | |||||||
167 | 157 | 1 | 1466000811 | SNR | RESISTOR OTHER | ||||||||
168 | 158 | 2 | 1461000609 | VIS | CRCW0402 200K FK xx E3 | RESISTOR | |||||||
169 | 159 | 2 | 1461001459 | WAL | MR04X2003F | RESISTOR OTHER | |||||||
170 | 160 | 2 | 1461000608 | KOA | RK73H1ET..2003F | RESISTOR OTHER | |||||||
171 | 161 | 1 | 1466000947 | SNR | RESISTOR OTHER | ||||||||
172 | 162 | 2 | 1461001194 | WAL | MR04X1472F_L | RESISTOR OTHER | |||||||
173 | 163 | 2 | 1461001546 | YAG | AC0402FR-xx14K7L | RESISTOR OTHER | |||||||
174 | 164 | 2 | 1461001192 | KOA | RK73H1ET..1472F | RESISTOR OTHER | |||||||
175 | 165 | 2 | 1461001193 | VIS | CRCW0402 14k7 FK xx E3 | RESISTOR | |||||||
176 | 166 | 1 | 1466001011 | SNR | CAPACITOR CERAMIC | ||||||||
177 | 167 | 2 | 1462000162 | TAY | UMK325AB7106KMHP | CERAMIC-CAPACITOR | |||||||
178 | 168 | 2 | 1462000163 | TDK | CGA6P3X7S1H106KT | CERAMIC-CAPACITOR | |||||||
179 | 169 | 2 | 1462000164 | MUT | GCM32EC71H106KA03L | CAPACITOR CERAMIC | |||||||
180 | 170 | 1 | 1466001354 | SNR | CAPACITOR CERAMIC | ||||||||
181 | 171 | 2 | 1462000087 | MUT | GCM155R71H104KE02D | CAPACITOR CERAMIC | |||||||
182 | 172 | 2 | 1462000206 | TDK | CGA2B3X7R1H104KT | CERAMIC-CAPACITOR | |||||||
183 | 173 | 1 | 1466001356 | SNR | LED+SNR | ||||||||
184 | 174 | 2 | 1466001356 | OOS | KR DMLQ31.23-JZKY-24-J3T3 | LED | |||||||
185 | 175 | 1 | 1466001421 | SNR | RESISTOR OTHER | ||||||||
186 | 176 | 2 | 1304503189 | VIS | D11-CRCW0603 0R0 xx e3 | RESISTOR | |||||||
187 | 177 | 2 | 1304503435 | KOA | RK73Z1JT | RESISTOR | |||||||
188 | 178 | 1 | 1466001430 | SNR | RESISTOR OTHER | ||||||||
189 | 179 | 2 | 1461000933 | WAL | MR04X4022F_L | RESISTOR OTHER | |||||||
190 | 180 | 2 | 1461000931 | KOA | RK73H1ET..4022F | RESISTOR OTHER | |||||||
191 | 181 | 2 | 1461000932 | VIS | CRCW0402 40k2 FK xx E3 | RESISTOR | |||||||
192 | 182 | 1 | 1466001431 | SNR | RESISTOR OTHER | ||||||||
193 | 183 | 2 | 1461001749 | YAG | AC0402FR-xx28KL | RESISTOR OTHER | |||||||
194 | 184 | 2 | 1461000937 | KOA | RK73H1ET..2802F | RESISTOR OTHER | |||||||
195 | 185 | 2 | 1461000939 | WAL | MR04X2802F_L | RESISTOR OTHER | |||||||
196 | 186 | 2 | 1461000938 | VIS | CRCW0402 28k0 FK xx E3 | RESISTOR | |||||||
197 | 187 | 1 | 1466001870 | SNR | INDUCTOR INDUCTOR | ||||||||
198 | 188 | 2 | 1463000187 | VIS | IHLP3232DZER150M5A | INDUCTOR INDUCTOR | |||||||
199 | 189 | 1 | 1466002081 | SNR | DIODE DIODE | ||||||||
200 | 190 | 2 | 1465000360 | NEX | BZX585-C6V8 | DIODE DIODE | |||||||
MultiBOM toCombo |