| 1 | Order Qty: 10 =SUMME(BZ3:BZ1002) |
|---|
| 2 | Qty QtyOrder Part References Value Package Part Num Mfg Name HAN Description Lieferant0 Lieferant0ArtNr L0St0Ab L0St0Preis L0St1Ab L0St1Preis L0St2Ab L0St2Preis L0St3Ab L0St3Preis L0St4Ab L0St4Preis Lieferant1 Lieferant1ArtNr L1St0Ab L1St0Preis L1St1Ab L1St1Preis L1St2Ab L1St2Preis L1St3Ab L1St3Preis L1St4Ab L1St4Preis Lieferant2 Lieferant2ArtNr L2St0Ab L2St0Preis L2St1Ab L2St1Preis L2St2Ab L2St2Preis L2St3Ab L2St3Preis L2St4Ab L2St4Preis Lieferant3 Lieferant3ArtNr L3St0Ab L3St0Preis L3St1Ab L3St1Preis L3St2Ab L3St2Preis L3St3Ab L3St3Preis L3St4Ab L3St4Preis Lieferant4 Lieferant4ArtNr L4St0Ab L4St0Preis L4St1Ab L4St1Preis L4St2Ab L4St2Preis L4St3Ab L4St3Preis L4St4Ab L4St4Preis XREF bom_id BEST_EP0 BEST_EP1 BEST_EP2 BEST_EP3 BEST_EP4 BEST_EP GP BEST VENDOR |
|---|
| 3 | 1 =$B$1*A3 "M1" "IRM20" "IRM-20" BGEK075 Meanwell IRM-20-24 IRM20-24 Netzteil 24 V 20 Watt Schukat electronic Vertriebs GmbH IRM-20-24 0 6,02000000000000 200,00000000000000 5,73000000000000 25,00000000000000 5,97000000000000 50,00000000000000 5,87000000000000 100,00000000000000 5,82000000000000 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * REF286 =WENN(UND($B3>=T3;T3>0);U3;WENN(UND($B3>=R3;R3>0);S3;WENN(UND($B3>=P3;P3>0);Q3;WENN(UND($B3>=N3;N3>0);O3;M3)))) =WENN(UND($B3>=AF3;AF3>0);AG3;WENN(UND($B3>=AD3;AD3>0);AE3;WENN(UND($B3>=AB3;AA3>0);AC3;WENN(UND($B3>=Z3;Z3>0);AA3;Y3)))) =WENN(UND($B3>=AR3;AR3>0);AS3;WENN(UND($B3>=AP3;AP3>0);AQ3;WENN(UND($B3>=AN3;AN3>0);AO3;WENN(UND($B3>=AL3;AL3>0);AM3;AK3)))) =WENN(UND($B3>=BD3;BD3>0);BE3;WENN(UND($B3>=BB3;BB3>0);BC3;WENN(UND($B3>=AZ3;AZ3>0);BA3;WENN(UND($B3>=AX3;AX3>0);AY3;AW3)))) =WENN(UND($B3>=BP3;BP3>0);BQ3;WENN(UND($B3>=BN3;BN3>0);BO3;WENN(UND($B3>=BL3;BL3>0);BM3;WENN(UND($B3>=BJ3;BJ3>0);BK3;BI3)))) =MIN(BT3:BX3) =BY3*A3 =WENN(BT3=BY3;J3;WENN(BU3=BY3;V3;WENN(BV3=BY3;AH3;WENN(BW3=BY3;AT3;BF3)))) |
|---|
| 4 | 1 =$B$1*A4 "C6" "10n/275V" "C150-054X183" C005 KEMET R46KI21004001K FOLIENKONDENSATOR 10n 275V 10% X2 RM15 THT Mouser Electronics 80-R46KI21004001K 0 0,46200000000000 10,00000000000000 0,32900000000000 50,00000000000000 0,23100000000000 100,00000000000000 0,08400000000000 200,00000000000000 0,08100000000000 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * REF344 =WENN(UND($B4>=T4;T4>0);U4;WENN(UND($B4>=R4;R4>0);S4;WENN(UND($B4>=P4;P4>0);Q4;WENN(UND($B4>=N4;N4>0);O4;M4)))) =WENN(UND($B4>=AF4;AF4>0);AG4;WENN(UND($B4>=AD4;AD4>0);AE4;WENN(UND($B4>=AB4;AA4>0);AC4;WENN(UND($B4>=Z4;Z4>0);AA4;Y4)))) =WENN(UND($B4>=AR4;AR4>0);AS4;WENN(UND($B4>=AP4;AP4>0);AQ4;WENN(UND($B4>=AN4;AN4>0);AO4;WENN(UND($B4>=AL4;AL4>0);AM4;AK4)))) =WENN(UND($B4>=BD4;BD4>0);BE4;WENN(UND($B4>=BB4;BB4>0);BC4;WENN(UND($B4>=AZ4;AZ4>0);BA4;WENN(UND($B4>=AX4;AX4>0);AY4;AW4)))) =WENN(UND($B4>=BP4;BP4>0);BQ4;WENN(UND($B4>=BN4;BN4>0);BO4;WENN(UND($B4>=BL4;BL4>0);BM4;WENN(UND($B4>=BJ4;BJ4>0);BK4;BI4)))) =MIN(BT4:BX4) =BY4*A4 =WENN(BT4=BY4;J4;WENN(BU4=BY4;V4;WENN(BV4=BY4;AH4;WENN(BW4=BY4;AT4;BF4)))) |
|---|
| 5 | 2 =$B$1*A5 "C3, C4" "1µ/100V" "C1210" C216 SAMSUNG CL32B105KCJSNNE 1µ0 100V 10% X7R 1210 SMD Weltron Elektronik GmbH 082040042543 1000 0,06800000000000 3000,00000000000000 0,02980000000000 6000,00000000000000 0,02870000000000 * * * * Elpro K-SMD 1 µF 1210 X7R 100V 0 0,54000000000000 100,00000000000000 0,23000000000000 1000,00000000000000 0,04500000000000 * * * * TME Germany GmbH Kondensator: Keramik; MLCC; 1uF; 100V; X7R; ±10%; SMD; 1210 100 0,16800000000000 4000,00000000000000 0,06290000000000 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * REF552 =WENN(UND($B5>=T5;T5>0);U5;WENN(UND($B5>=R5;R5>0);S5;WENN(UND($B5>=P5;P5>0);Q5;WENN(UND($B5>=N5;N5>0);O5;M5)))) =WENN(UND($B5>=AF5;AF5>0);AG5;WENN(UND($B5>=AD5;AD5>0);AE5;WENN(UND($B5>=AB5;AA5>0);AC5;WENN(UND($B5>=Z5;Z5>0);AA5;Y5)))) =WENN(UND($B5>=AR5;AR5>0);AS5;WENN(UND($B5>=AP5;AP5>0);AQ5;WENN(UND($B5>=AN5;AN5>0);AO5;WENN(UND($B5>=AL5;AL5>0);AM5;AK5)))) =WENN(UND($B5>=BD5;BD5>0);BE5;WENN(UND($B5>=BB5;BB5>0);BC5;WENN(UND($B5>=AZ5;AZ5>0);BA5;WENN(UND($B5>=AX5;AX5>0);AY5;AW5)))) =WENN(UND($B5>=BP5;BP5>0);BQ5;WENN(UND($B5>=BN5;BN5>0);BO5;WENN(UND($B5>=BL5;BL5>0);BM5;WENN(UND($B5>=BJ5;BJ5>0);BK5;BI5)))) =MIN(BT5:BX5) =BY5*A5 =WENN(BT5=BY5;J5;WENN(BU5=BY5;V5;WENN(BV5=BY5;AH5;WENN(BW5=BY5;AT5;BF5)))) |
|---|
| 6 | 1 =$B$1*A6 "C7" "33µ/80V" "PANASONIC_G" C224 Panasonic EEHZA1K330P ELKO 33µF 80V 105°C 1,7A 36mOhm 10x10,2 (Size Code G) SMD Weltron Elektronik GmbH 085144179319 500 0,92430000000000 1500,00000000000000 0,89120000000000 3000,00000000000000 0,85820000000000 * * * * Future Electronics Deutschland GmbH EEH-ZA1K330P 500 0,86380000000000 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * REF560 =WENN(UND($B6>=T6;T6>0);U6;WENN(UND($B6>=R6;R6>0);S6;WENN(UND($B6>=P6;P6>0);Q6;WENN(UND($B6>=N6;N6>0);O6;M6)))) =WENN(UND($B6>=AF6;AF6>0);AG6;WENN(UND($B6>=AD6;AD6>0);AE6;WENN(UND($B6>=AB6;AA6>0);AC6;WENN(UND($B6>=Z6;Z6>0);AA6;Y6)))) =WENN(UND($B6>=AR6;AR6>0);AS6;WENN(UND($B6>=AP6;AP6>0);AQ6;WENN(UND($B6>=AN6;AN6>0);AO6;WENN(UND($B6>=AL6;AL6>0);AM6;AK6)))) =WENN(UND($B6>=BD6;BD6>0);BE6;WENN(UND($B6>=BB6;BB6>0);BC6;WENN(UND($B6>=AZ6;AZ6>0);BA6;WENN(UND($B6>=AX6;AX6>0);AY6;AW6)))) =WENN(UND($B6>=BP6;BP6>0);BQ6;WENN(UND($B6>=BN6;BN6>0);BO6;WENN(UND($B6>=BL6;BL6>0);BM6;WENN(UND($B6>=BJ6;BJ6>0);BK6;BI6)))) =MIN(BT6:BX6) =BY6*A6 =WENN(BT6=BY6;J6;WENN(BU6=BY6;V6;WENN(BV6=BY6;AH6;WENN(BW6=BY6;AT6;BF6)))) |
|---|
| 7 | 3 =$B$1*A7 "C1, C2, C5" "2,2µF/450V" "PANASONIC_G" C449 Panasonic EEVEB2W2R2Q ELKO 2µ2 20% 450 V 105 ° SIZE CODE G13 SMD TME Germany GmbH EEVEB2W2R2Q 0 1,77000000000000 10,00000000000000 1,38700000000000 50,00000000000000 1,14700000000000 100,00000000000000 1,07100000000000 250,00000000000000 0,94391000000000 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * REF784 =WENN(UND($B7>=T7;T7>0);U7;WENN(UND($B7>=R7;R7>0);S7;WENN(UND($B7>=P7;P7>0);Q7;WENN(UND($B7>=N7;N7>0);O7;M7)))) =WENN(UND($B7>=AF7;AF7>0);AG7;WENN(UND($B7>=AD7;AD7>0);AE7;WENN(UND($B7>=AB7;AA7>0);AC7;WENN(UND($B7>=Z7;Z7>0);AA7;Y7)))) =WENN(UND($B7>=AR7;AR7>0);AS7;WENN(UND($B7>=AP7;AP7>0);AQ7;WENN(UND($B7>=AN7;AN7>0);AO7;WENN(UND($B7>=AL7;AL7>0);AM7;AK7)))) =WENN(UND($B7>=BD7;BD7>0);BE7;WENN(UND($B7>=BB7;BB7>0);BC7;WENN(UND($B7>=AZ7;AZ7>0);BA7;WENN(UND($B7>=AX7;AX7>0);AY7;AW7)))) =WENN(UND($B7>=BP7;BP7>0);BQ7;WENN(UND($B7>=BN7;BN7>0);BO7;WENN(UND($B7>=BL7;BL7>0);BM7;WENN(UND($B7>=BJ7;BJ7>0);BK7;BI7)))) =MIN(BT7:BX7) =BY7*A7 =WENN(BT7=BY7;J7;WENN(BU7=BY7;V7;WENN(BV7=BY7;AH7;WENN(BW7=BY7;AT7;BF7)))) |
|---|
| 8 | 3 =$B$1*A8 "J2, J3, J4" "" "691322310002" CON353 WÜRTH 691 322 310 002 WANNENSTIFTLEISTE 1X2-POL GEWINKELT RM3.81 Würth Elektronik 691 322 310 002 100 0,10400000000000 1000,00000000000000 0,08900000000000 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * REF1117 =WENN(UND($B8>=T8;T8>0);U8;WENN(UND($B8>=R8;R8>0);S8;WENN(UND($B8>=P8;P8>0);Q8;WENN(UND($B8>=N8;N8>0);O8;M8)))) =WENN(UND($B8>=AF8;AF8>0);AG8;WENN(UND($B8>=AD8;AD8>0);AE8;WENN(UND($B8>=AB8;AA8>0);AC8;WENN(UND($B8>=Z8;Z8>0);AA8;Y8)))) =WENN(UND($B8>=AR8;AR8>0);AS8;WENN(UND($B8>=AP8;AP8>0);AQ8;WENN(UND($B8>=AN8;AN8>0);AO8;WENN(UND($B8>=AL8;AL8>0);AM8;AK8)))) =WENN(UND($B8>=BD8;BD8>0);BE8;WENN(UND($B8>=BB8;BB8>0);BC8;WENN(UND($B8>=AZ8;AZ8>0);BA8;WENN(UND($B8>=AX8;AX8>0);AY8;AW8)))) =WENN(UND($B8>=BP8;BP8>0);BQ8;WENN(UND($B8>=BN8;BN8>0);BO8;WENN(UND($B8>=BL8;BL8>0);BM8;WENN(UND($B8>=BJ8;BJ8>0);BK8;BI8)))) =MIN(BT8:BX8) =BY8*A8 =WENN(BT8=BY8;J8;WENN(BU8=BY8;V8;WENN(BV8=BY8;AH8;WENN(BW8=BY8;AT8;BF8)))) |
|---|
| 9 | 1 =$B$1*A9 "J1" "" "691322310004" CON354 WÜRTH 691 322 310 004 WANNENSTIFTLEISTE 1X4-POL GEWINKELT RM3.81 Würth Elektronik 691 322 310 004 100 0,19900000000000 500,00000000000000 0,17300000000000 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * REF1118 =WENN(UND($B9>=T9;T9>0);U9;WENN(UND($B9>=R9;R9>0);S9;WENN(UND($B9>=P9;P9>0);Q9;WENN(UND($B9>=N9;N9>0);O9;M9)))) =WENN(UND($B9>=AF9;AF9>0);AG9;WENN(UND($B9>=AD9;AD9>0);AE9;WENN(UND($B9>=AB9;AA9>0);AC9;WENN(UND($B9>=Z9;Z9>0);AA9;Y9)))) =WENN(UND($B9>=AR9;AR9>0);AS9;WENN(UND($B9>=AP9;AP9>0);AQ9;WENN(UND($B9>=AN9;AN9>0);AO9;WENN(UND($B9>=AL9;AL9>0);AM9;AK9)))) =WENN(UND($B9>=BD9;BD9>0);BE9;WENN(UND($B9>=BB9;BB9>0);BC9;WENN(UND($B9>=AZ9;AZ9>0);BA9;WENN(UND($B9>=AX9;AX9>0);AY9;AW9)))) =WENN(UND($B9>=BP9;BP9>0);BQ9;WENN(UND($B9>=BN9;BN9>0);BO9;WENN(UND($B9>=BL9;BL9>0);BM9;WENN(UND($B9>=BJ9;BJ9>0);BK9;BI9)))) =MIN(BT9:BX9) =BY9*A9 =WENN(BT9=BY9;J9;WENN(BU9=BY9;V9;WENN(BV9=BY9;AH9;WENN(BW9=BY9;AT9;BF9)))) |
|---|
| 10 | 3 =$B$1*A10 "BOM-PART1" "Stecker 2pol, gerade, 691 368 300 002 B" "*" CON355 WÜRTH 691 368 300 002 B STECKER KLEMMTECHNIK 2-POL RM3.81 GERADE Würth Elektronik 691 368 300 002 B 100 0,59000000000000 200,00000000000000 0,51000000000000 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * REF1119 =WENN(UND($B10>=T10;T10>0);U10;WENN(UND($B10>=R10;R10>0);S10;WENN(UND($B10>=P10;P10>0);Q10;WENN(UND($B10>=N10;N10>0);O10;M10)))) =WENN(UND($B10>=AF10;AF10>0);AG10;WENN(UND($B10>=AD10;AD10>0);AE10;WENN(UND($B10>=AB10;AA10>0);AC10;WENN(UND($B10>=Z10;Z10>0);AA10;Y10)))) =WENN(UND($B10>=AR10;AR10>0);AS10;WENN(UND($B10>=AP10;AP10>0);AQ10;WENN(UND($B10>=AN10;AN10>0);AO10;WENN(UND($B10>=AL10;AL10>0);AM10;AK10)))) =WENN(UND($B10>=BD10;BD10>0);BE10;WENN(UND($B10>=BB10;BB10>0);BC10;WENN(UND($B10>=AZ10;AZ10>0);BA10;WENN(UND($B10>=AX10;AX10>0);AY10;AW10)))) =WENN(UND($B10>=BP10;BP10>0);BQ10;WENN(UND($B10>=BN10;BN10>0);BO10;WENN(UND($B10>=BL10;BL10>0);BM10;WENN(UND($B10>=BJ10;BJ10>0);BK10;BI10)))) =MIN(BT10:BX10) =BY10*A10 =WENN(BT10=BY10;J10;WENN(BU10=BY10;V10;WENN(BV10=BY10;AH10;WENN(BW10=BY10;AT10;BF10)))) |
|---|
| 11 | 1 =$B$1*A11 "BOM-PART2" "Stecker 6pol. gerade, 691 368 300 004 B" "*" CON356 WÜRTH 691 368 300 004 B STECKER KLEMMTECHNIK 4-POL RM3.81 GERADE Würth Elektronik 691 368 300 004 B 100 1,30000000000000 150,00000000000000 1,15000000000000 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * REF1120 =WENN(UND($B11>=T11;T11>0);U11;WENN(UND($B11>=R11;R11>0);S11;WENN(UND($B11>=P11;P11>0);Q11;WENN(UND($B11>=N11;N11>0);O11;M11)))) =WENN(UND($B11>=AF11;AF11>0);AG11;WENN(UND($B11>=AD11;AD11>0);AE11;WENN(UND($B11>=AB11;AA11>0);AC11;WENN(UND($B11>=Z11;Z11>0);AA11;Y11)))) =WENN(UND($B11>=AR11;AR11>0);AS11;WENN(UND($B11>=AP11;AP11>0);AQ11;WENN(UND($B11>=AN11;AN11>0);AO11;WENN(UND($B11>=AL11;AL11>0);AM11;AK11)))) =WENN(UND($B11>=BD11;BD11>0);BE11;WENN(UND($B11>=BB11;BB11>0);BC11;WENN(UND($B11>=AZ11;AZ11>0);BA11;WENN(UND($B11>=AX11;AX11>0);AY11;AW11)))) =WENN(UND($B11>=BP11;BP11>0);BQ11;WENN(UND($B11>=BN11;BN11>0);BO11;WENN(UND($B11>=BL11;BL11>0);BM11;WENN(UND($B11>=BJ11;BJ11>0);BK11;BI11)))) =MIN(BT11:BX11) =BY11*A11 =WENN(BT11=BY11;J11;WENN(BU11=BY11;V11;WENN(BV11=BY11;AH11;WENN(BW11=BY11;AT11;BF11)))) |
|---|
| 12 | 4 =$B$1*A12 "D1, D2, D3, D4" "MURS360" "SMC" D049 Vishay MURS360 MURS360 ULTRAFAST DIODE DO-214AB (SMC) 3A 600V Mouser Electronics 625-MURS360-E3 0 0,36200000000000 10,00000000000000 0,34400000000000 100,00000000000000 0,32600000000000 250,00000000000000 0,32400000000000 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * REF1271 =WENN(UND($B12>=T12;T12>0);U12;WENN(UND($B12>=R12;R12>0);S12;WENN(UND($B12>=P12;P12>0);Q12;WENN(UND($B12>=N12;N12>0);O12;M12)))) =WENN(UND($B12>=AF12;AF12>0);AG12;WENN(UND($B12>=AD12;AD12>0);AE12;WENN(UND($B12>=AB12;AA12>0);AC12;WENN(UND($B12>=Z12;Z12>0);AA12;Y12)))) =WENN(UND($B12>=AR12;AR12>0);AS12;WENN(UND($B12>=AP12;AP12>0);AQ12;WENN(UND($B12>=AN12;AN12>0);AO12;WENN(UND($B12>=AL12;AL12>0);AM12;AK12)))) =WENN(UND($B12>=BD12;BD12>0);BE12;WENN(UND($B12>=BB12;BB12>0);BC12;WENN(UND($B12>=AZ12;AZ12>0);BA12;WENN(UND($B12>=AX12;AX12>0);AY12;AW12)))) =WENN(UND($B12>=BP12;BP12>0);BQ12;WENN(UND($B12>=BN12;BN12>0);BO12;WENN(UND($B12>=BL12;BL12>0);BM12;WENN(UND($B12>=BJ12;BJ12>0);BK12;BI12)))) =MIN(BT12:BX12) =BY12*A12 =WENN(BT12=BY12;J12;WENN(BU12=BY12;V12;WENN(BV12=BY12;AH12;WENN(BW12=BY12;AT12;BF12)))) |
|---|
| 13 | 1 =$B$1*A13 "LED1" "gn" "CHIP-LED0603" D078 OSRAM LG L29K-G2J1-24-Z LG L29K-G2J1-24-Z LED GRÜN LOW CURRENT 570MCD 1,8V 2mA 0603 SMD Mouser Electronics 720-LGL29KG2J124Z 0 0,34900000000000 10,00000000000000 0,27600000000000 25,00000000000000 0,22500000000000 100,00000000000000 0,17900000000000 * * reichelt elektronik GmbH & Co. KG LG L29K 0 0,12600000000000 * * * * * * * * TME Germany GmbH LGL29K-G2J1-24 0 0,14000000000000 25,00000000000000 0,07260000000000 100,00000000000000 0,04970000000000 500,00000000000000 0,04250000000000 * * * * * * * * * * * * * * * * * * * * * * * * * * REF1299 =WENN(UND($B13>=T13;T13>0);U13;WENN(UND($B13>=R13;R13>0);S13;WENN(UND($B13>=P13;P13>0);Q13;WENN(UND($B13>=N13;N13>0);O13;M13)))) =WENN(UND($B13>=AF13;AF13>0);AG13;WENN(UND($B13>=AD13;AD13>0);AE13;WENN(UND($B13>=AB13;AA13>0);AC13;WENN(UND($B13>=Z13;Z13>0);AA13;Y13)))) =WENN(UND($B13>=AR13;AR13>0);AS13;WENN(UND($B13>=AP13;AP13>0);AQ13;WENN(UND($B13>=AN13;AN13>0);AO13;WENN(UND($B13>=AL13;AL13>0);AM13;AK13)))) =WENN(UND($B13>=BD13;BD13>0);BE13;WENN(UND($B13>=BB13;BB13>0);BC13;WENN(UND($B13>=AZ13;AZ13>0);BA13;WENN(UND($B13>=AX13;AX13>0);AY13;AW13)))) =WENN(UND($B13>=BP13;BP13>0);BQ13;WENN(UND($B13>=BN13;BN13>0);BO13;WENN(UND($B13>=BL13;BL13>0);BM13;WENN(UND($B13>=BJ13;BJ13>0);BK13;BI13)))) =MIN(BT13:BX13) =BY13*A13 =WENN(BT13=BY13;J13;WENN(BU13=BY13;V13;WENN(BV13=BY13;AH13;WENN(BW13=BY13;AT13;BF13)))) |
|---|
| 14 | 1 =$B$1*A14 "D5" "SMBJ24A" "SMBJ" D212 DIODES INC./ ZETEX SMBJ24CA-13-F SMBJ24CA-13-F TVS-DIODE SUPRESSOR 24V SMB SMD Mouser Electronics 621-SMBJ24CA-13-F 0 0,36100000000000 10,00000000000000 0,30100000000000 100,00000000000000 0,20400000000000 500,00000000000000 0,15700000000000 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * REF1431 =WENN(UND($B14>=T14;T14>0);U14;WENN(UND($B14>=R14;R14>0);S14;WENN(UND($B14>=P14;P14>0);Q14;WENN(UND($B14>=N14;N14>0);O14;M14)))) =WENN(UND($B14>=AF14;AF14>0);AG14;WENN(UND($B14>=AD14;AD14>0);AE14;WENN(UND($B14>=AB14;AA14>0);AC14;WENN(UND($B14>=Z14;Z14>0);AA14;Y14)))) =WENN(UND($B14>=AR14;AR14>0);AS14;WENN(UND($B14>=AP14;AP14>0);AQ14;WENN(UND($B14>=AN14;AN14>0);AO14;WENN(UND($B14>=AL14;AL14>0);AM14;AK14)))) =WENN(UND($B14>=BD14;BD14>0);BE14;WENN(UND($B14>=BB14;BB14>0);BC14;WENN(UND($B14>=AZ14;AZ14>0);BA14;WENN(UND($B14>=AX14;AX14>0);AY14;AW14)))) =WENN(UND($B14>=BP14;BP14>0);BQ14;WENN(UND($B14>=BN14;BN14>0);BO14;WENN(UND($B14>=BL14;BL14>0);BM14;WENN(UND($B14>=BJ14;BJ14>0);BK14;BI14)))) =MIN(BT14:BX14) =BY14*A14 =WENN(BT14=BY14;J14;WENN(BU14=BY14;V14;WENN(BV14=BY14;AH14;WENN(BW14=BY14;AT14;BF14)))) |
|---|
| 15 | 1 =$B$1*A15 "L1" "33MH" "WE-CMBNC_M_7448030333" L072 WÜRTH 7448030333 STROKO NANOCRYSTALINE FERRIT 2X33mH 2,5A 90mOhm 250V STEHEND Würth Elektronik 7448030333 25 2,93000000000000 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * REF2327 =WENN(UND($B15>=T15;T15>0);U15;WENN(UND($B15>=R15;R15>0);S15;WENN(UND($B15>=P15;P15>0);Q15;WENN(UND($B15>=N15;N15>0);O15;M15)))) =WENN(UND($B15>=AF15;AF15>0);AG15;WENN(UND($B15>=AD15;AD15>0);AE15;WENN(UND($B15>=AB15;AA15>0);AC15;WENN(UND($B15>=Z15;Z15>0);AA15;Y15)))) =WENN(UND($B15>=AR15;AR15>0);AS15;WENN(UND($B15>=AP15;AP15>0);AQ15;WENN(UND($B15>=AN15;AN15>0);AO15;WENN(UND($B15>=AL15;AL15>0);AM15;AK15)))) =WENN(UND($B15>=BD15;BD15>0);BE15;WENN(UND($B15>=BB15;BB15>0);BC15;WENN(UND($B15>=AZ15;AZ15>0);BA15;WENN(UND($B15>=AX15;AX15>0);AY15;AW15)))) =WENN(UND($B15>=BP15;BP15>0);BQ15;WENN(UND($B15>=BN15;BN15>0);BO15;WENN(UND($B15>=BL15;BL15>0);BM15;WENN(UND($B15>=BJ15;BJ15>0);BK15;BI15)))) =MIN(BT15:BX15) =BY15*A15 =WENN(BT15=BY15;J15;WENN(BU15=BY15;V15;WENN(BV15=BY15;AH15;WENN(BW15=BY15;AT15;BF15)))) |
|---|
| 16 | 1 =$B$1*A16 "BOM-PART3" "Leiterplatte" "*" PT068 JLC ECS_GREENSMARTSWITCH_24V_POWER_LP SAUER_PS_LP JLCPCB * 10 0,00000000000000 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * REF2878 =WENN(UND($B16>=T16;T16>0);U16;WENN(UND($B16>=R16;R16>0);S16;WENN(UND($B16>=P16;P16>0);Q16;WENN(UND($B16>=N16;N16>0);O16;M16)))) =WENN(UND($B16>=AF16;AF16>0);AG16;WENN(UND($B16>=AD16;AD16>0);AE16;WENN(UND($B16>=AB16;AA16>0);AC16;WENN(UND($B16>=Z16;Z16>0);AA16;Y16)))) =WENN(UND($B16>=AR16;AR16>0);AS16;WENN(UND($B16>=AP16;AP16>0);AQ16;WENN(UND($B16>=AN16;AN16>0);AO16;WENN(UND($B16>=AL16;AL16>0);AM16;AK16)))) =WENN(UND($B16>=BD16;BD16>0);BE16;WENN(UND($B16>=BB16;BB16>0);BC16;WENN(UND($B16>=AZ16;AZ16>0);BA16;WENN(UND($B16>=AX16;AX16>0);AY16;AW16)))) =WENN(UND($B16>=BP16;BP16>0);BQ16;WENN(UND($B16>=BN16;BN16>0);BO16;WENN(UND($B16>=BL16;BL16>0);BM16;WENN(UND($B16>=BJ16;BJ16>0);BK16;BI16)))) =MIN(BT16:BX16) =BY16*A16 =WENN(BT16=BY16;J16;WENN(BU16=BY16;V16;WENN(BV16=BY16;AH16;WENN(BW16=BY16;AT16;BF16)))) |
|---|
| 17 | 2 =$B$1*A17 "RV1, RV2" "250VRMS" "WE-VD_10MM_820512511" R055 WÜRTH 820512511 VDR 250V 10 THT Würth Elektronik 820 512 511 200 0,15000000000000 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * REF2954 =WENN(UND($B17>=T17;T17>0);U17;WENN(UND($B17>=R17;R17>0);S17;WENN(UND($B17>=P17;P17>0);Q17;WENN(UND($B17>=N17;N17>0);O17;M17)))) =WENN(UND($B17>=AF17;AF17>0);AG17;WENN(UND($B17>=AD17;AD17>0);AE17;WENN(UND($B17>=AB17;AA17>0);AC17;WENN(UND($B17>=Z17;Z17>0);AA17;Y17)))) =WENN(UND($B17>=AR17;AR17>0);AS17;WENN(UND($B17>=AP17;AP17>0);AQ17;WENN(UND($B17>=AN17;AN17>0);AO17;WENN(UND($B17>=AL17;AL17>0);AM17;AK17)))) =WENN(UND($B17>=BD17;BD17>0);BE17;WENN(UND($B17>=BB17;BB17>0);BC17;WENN(UND($B17>=AZ17;AZ17>0);BA17;WENN(UND($B17>=AX17;AX17>0);AY17;AW17)))) =WENN(UND($B17>=BP17;BP17>0);BQ17;WENN(UND($B17>=BN17;BN17>0);BO17;WENN(UND($B17>=BL17;BL17>0);BM17;WENN(UND($B17>=BJ17;BJ17>0);BK17;BI17)))) =MIN(BT17:BX17) =BY17*A17 =WENN(BT17=BY17;J17;WENN(BU17=BY17;V17;WENN(BV17=BY17;AH17;WENN(BW17=BY17;AT17;BF17)))) |
|---|
| 18 | 1 =$B$1*A18 "R1" "10k" "R0603" R221 YAGEO RC0603FR-0710KL 10k0 0,1W 1% 0603 SMD Weltron Elektronik GmbH 029102006535 5000 0,00120000000000 100000,00000000000000 0,00060000000000 * * * * * * TME Germany GmbH RC0603FR-0710K 0 0,01350000000000 1000,00000000000000 0,00280000000000 5000,00000000000000 0,00132000000000 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * REF3119 =WENN(UND($B18>=T18;T18>0);U18;WENN(UND($B18>=R18;R18>0);S18;WENN(UND($B18>=P18;P18>0);Q18;WENN(UND($B18>=N18;N18>0);O18;M18)))) =WENN(UND($B18>=AF18;AF18>0);AG18;WENN(UND($B18>=AD18;AD18>0);AE18;WENN(UND($B18>=AB18;AA18>0);AC18;WENN(UND($B18>=Z18;Z18>0);AA18;Y18)))) =WENN(UND($B18>=AR18;AR18>0);AS18;WENN(UND($B18>=AP18;AP18>0);AQ18;WENN(UND($B18>=AN18;AN18>0);AO18;WENN(UND($B18>=AL18;AL18>0);AM18;AK18)))) =WENN(UND($B18>=BD18;BD18>0);BE18;WENN(UND($B18>=BB18;BB18>0);BC18;WENN(UND($B18>=AZ18;AZ18>0);BA18;WENN(UND($B18>=AX18;AX18>0);AY18;AW18)))) =WENN(UND($B18>=BP18;BP18>0);BQ18;WENN(UND($B18>=BN18;BN18>0);BO18;WENN(UND($B18>=BL18;BL18>0);BM18;WENN(UND($B18>=BJ18;BJ18>0);BK18;BI18)))) =MIN(BT18:BX18) =BY18*A18 =WENN(BT18=BY18;J18;WENN(BU18=BY18;V18;WENN(BV18=BY18;AH18;WENN(BW18=BY18;AT18;BF18)))) |
|---|
