AW: Verknuepfunegen von Feldern!
12.05.2005 19:50:46
Feldern!
Hallo Axel,
https://www.herber.de/bbs/user/22529.xls
Tabellenblattname: gear units
A B C D E F G H I J K L M N
1 Firma A Firma B Ratio
Difference HR
Difference Firma A SumitomoPrice Difference
Fle-Sumi
2 Ratio HR Model Ratio HR Model Gearbox Price Gearbox Price
3 54,532 69,50048 H3BV05 56,507 67 9050 3,62172669258417E-02 -3,59778810160735E-02 7,156
4 51,484 73,6151 H3BV05 50,38 81 9050 -2,14435552793101E-02 0,100317733725826 7,156
5 48,689 77,84099 H3BV05 49,248 53,6 9040 1,14810326767853E-02 -0,311416774118623 7,156 Firma A Firma A
6 46,118 82,18049 H3BV05 46,033 83 9050 -1,84309813955507E-03 9,97207488054639E-03 7,156 Model Gearbox Price
7 45,495 83,30586 H3BV05 45,44 53,6 9040 -1,20892405758874E-03 -0,356587879892243 7,156 H3BV05 7,156
8 44,944 84,32716 H3BV05 44,338 36,9 9030 -1,34834460662158E-02 -0,562418561232229 7,156 H2BV06 7,1
9 44,944 84,32716 H3BV05 44,342 86 9050 -1,33944464222144E-02 1,98374995671619E-02 7,156 H3BV06 7,445
10 44,944 84,32716 H3BV05 44,375 54,9 9040 -1,26601993592026E-02 -0,348964200857707 7,156 H3BV07 8,945
11 44,944 84,32716 H3BV05 45,009 23,3 9025 1,44624421502309E-03 -0,723695189070757 7,156 H2BV08 10,02
12 44,944 84,32716 H3BV05 45,088 15 9015 3,20398718405123E-03 -0,822121366354565 7,156 H3BV08 10,655
13 43,745 86,63847 H3BV05 -1 -1 7,156 H3BV09 11,995
14 54,22 88,52822 H3BV06 56,894 106 9060 0,049317594983401 0,197358311281984 7,445 H2BV10 12,375
15 42,702 88,75463 H3BV05 -1 -1 7,156 H3BV10 14,065
16 42,125 89,97033 H3BV05 -1 -1 7,156 B3BV11 16,485
17 41,548 91,21979 H3BV05 41,134 40,2 9030 -9,96437855011075E-03 -0,559306154947298 7,156 H2BV12 18,745
18 41,548 91,21979 H3BV05 41,705 39,6 9030 3,77876191393079E-03 -0,565883675022712 7,156 H3BV12 19,41
19 41,548 91,21979 H3BV05 41,754 58,4 9040 4,95812072783277E-03 -0,35978804599309 7,156 H3BV13 22,375
20 50,347 95,33835 H3BV06 49,634 82 9050 -1,41617176793056E-02 -0,139905400082968 7,445 H3BV14 25,955
21 50,347 95,33835 H3BV06 52,711 114 9060 4,69541382803344E-02 0,195741273055386 7,445 H3BV15 31,83
Benutzte Formeln:
G3: =(D3-A3)/ABS(A3)
G4: =(D4-A4)/ABS(A4)
G5: =(D5-A5)/ABS(A5)
G6: =(D6-A6)/ABS(A6)
G7: =(D7-A7)/ABS(A7)
G8: =(D8-A8)/ABS(A8)
G9: =(D9-A9)/ABS(A9)
G10: =(D10-A10)/ABS(A10)
G11: =(D11-A11)/ABS(A11)
G12: =(D12-A12)/ABS(A12)
G13: =(D13-A13)/ABS(A13)
G14: =(D14-A14)/ABS(A14)
G15: =(D15-A15)/ABS(A15)
G16: =(D16-A16)/ABS(A16)
G17: =(D17-A17)/ABS(A17)
G18: =(D18-A18)/ABS(A18)
G19: =(D19-A19)/ABS(A19)
G20: =(D20-A20)/ABS(A20)
G21: =(D21-A21)/ABS(A21)
H3: =(E3-B3)/ABS(B3)
H4: =(E4-B4)/ABS(B4)
H5: =(E5-B5)/ABS(B5)
H6: =(E6-B6)/ABS(B6)
H7: =(E7-B7)/ABS(B7)
H8: =(E8-B8)/ABS(B8)
H9: =(E9-B9)/ABS(B9)
H10: =(E10-B10)/ABS(B10)
H11: =(E11-B11)/ABS(B11)
H12: =(E12-B12)/ABS(B12)
H13: =(E13-B13)/ABS(B13)
H14: =(E14-B14)/ABS(B14)
H15: =(E15-B15)/ABS(B15)
H16: =(E16-B16)/ABS(B16)
H17: =(E17-B17)/ABS(B17)
H18: =(E18-B18)/ABS(B18)
H19: =(E19-B19)/ABS(B19)
H20: =(E20-B20)/ABS(B20)
H21: =(E21-B21)/ABS(B21)
I3: =SVERWEIS(C3;$M$7:$N$21;2;0)
I4: =SVERWEIS(C4;$M$7:$N$21;2;0)
I5: =SVERWEIS(C5;$M$7:$N$21;2;0)
I6: =SVERWEIS(C6;$M$7:$N$21;2;0)
I7: =SVERWEIS(C7;$M$7:$N$21;2;0)
I8: =SVERWEIS(C8;$M$7:$N$21;2;0)
I9: =SVERWEIS(C9;$M$7:$N$21;2;0)
I10: =SVERWEIS(C10;$M$7:$N$21;2;0)
I11: =SVERWEIS(C11;$M$7:$N$21;2;0)
I12: =SVERWEIS(C12;$M$7:$N$21;2;0)
I13: =SVERWEIS(C13;$M$7:$N$21;2;0)
I14: =SVERWEIS(C14;$M$7:$N$21;2;0)
I15: =SVERWEIS(C15;$M$7:$N$21;2;0)
I16: =SVERWEIS(C16;$M$7:$N$21;2;0)
I17: =SVERWEIS(C17;$M$7:$N$21;2;0)
I18: =SVERWEIS(C18;$M$7:$N$21;2;0)
I19: =SVERWEIS(C19;$M$7:$N$21;2;0)
I20: =SVERWEIS(C20;$M$7:$N$21;2;0)
I21: =SVERWEIS(C21;$M$7:$N$21;2;0)
Namen in der Tabelle:
'gear units'!_FilterDatabase: ='gear units'!#BEZUG! ?
'gear units'!Print_Titles : ='gear units'!$1:$2 ?
Gruß
Reinhard