| A | B | C | D | G | H | I | 1 | Grösser = | Kleiner | Faktor | Gruppe | SK Eigen | Gruppe | | 2 | | | | | 0,13 | 0 | 0 | 3 | 0,00000 | 0,50000 | | 0 | 0,14 | 0 | 0 | 4 | 0,50001 | 0,80000 | 0,30 | 1 | 0,49 | 0 | 0 | 5 | 0,80001 | 1,40000 | 0,60 | 2 | 0,51 | 1 | 1 | 6 | 1,40001 | 2,30000 | 0,90 | 3 | 0,51 | 1 | 1 | 7 | 2,30001 | 3,50000 | 1,20 | 4 | 0,54 | 1 | 1 | 8 | 3,50001 | 5,00000 | 1,50 | 5 | 0,81 | 2 | 2 | 9 | 5,00001 | 6,80000 | 1,80 | 6 | 0,81 | 2 | 2 | 10 | 6,80001 | 8,90000 | 2,10 | 7 | 1,40 | 3 | 3 | 11 | 8,90001 | 11,30000 | 2,40 | 8 | 1,40 | 3 | 3 | 12 | 11,30001 | 14,00000 | 2,70 | 9 | 1,40 | 3 | 3 | 13 | 14,00001 | 17,00000 | 3,00 | 10 | 1,40 | 3 | 3 | 14 | 17,00001 | 20,30000 | 3,30 | 11 | 1,40 | 3 | 3 | 15 | 20,30001 | 23,90000 | 3,60 | 12 | 1,40 | 3 | 3 | 16 | 23,90001 | 27,80000 | 3,90 | 13 | 2,24 | 3 | 3 | 17 | 27,80001 | 32,00000 | 4,20 | 14 | 2,24 | 3 | 3 | 18 | 32,00001 | 36,50000 | 4,50 | 15 | 3,71 | 4 | 5 | 19 | 36,50001 | 41,30000 | 4,80 | 16 | 3,73 | 4 | 5 | 20 | 41,30001 | 46,40000 | 5,10 | 17 | 3,73 | 4 | 5 | 21 | 46,40001 | 51,80000 | 5,40 | 18 | 4,08 | 4 | 5 | 22 | 51,80001 | 57,50000 | 5,70 | 19 | 4,08 | 4 | 5 | 23 | 57,50001 | 63,50000 | 6,00 | 20 | 4,10 | 4 | 5 | 24 | 63,50001 | 69,80000 | 6,30 | 21 | 6,48 | 5 | 6 | 25 | 69,80001 | 76,40000 | 6,60 | 22 | 6,48 | 5 | 6 | 26 | 76,40001 | 83,30000 | 6,90 | 23 | 6,79 | 5 | 6 | 27 | 83,30001 | 90,50000 | 7,20 | 24 | 6,79 | 5 | 6 | 28 | 90,50001 | 98,00000 | 7,50 | 25 | 6,79 | 5 | 6 | 29 | 98,00001 | 105,80000 | 7,80 | 26 | 7,75 | 6 | 7 | 30 | 105,80001 | 113,90000 | 8,10 | 27 | 7,80 | 6 | 7 | 31 | 113,90001 | 122,30000 | 8,40 | 28 | 7,80 | 6 | 7 | 32 | 122,30001 | 131,00000 | 8,70 | 29 | 7,86 | 6 | 7 | 33 | 131,00001 | 140,00000 | 9,00 | 30 | 8,32 | 6 | 7 | 34 | 140,00001 | 149,30000 | 9,30 | 31 | 8,32 | 6 | 7 | 35 | 149,30001 | 158,90000 | 9,60 | 32 | 8,32 | 6 | 7 | 36 | 158,90001 | 168,80000 | 9,90 | 33 | | | | 37 | 168,80001 | 179,00000 | 10,20 | 34 | | | | 38 | 179,00001 | 189,50000 | 10,50 | 35 | | | | 39 | 189,50001 | 200,30000 | 10,80 | 36 | | | | 40 | 200,30001 | | | | | | | Formeln der Tabelle | I2 : =SVERWEIS(G2;$A$2:$D$39;4;WAHR) I3 : =SVERWEIS(G3;$A$2:$D$39;4;WAHR) I4 : =SVERWEIS(G4;$A$2:$D$39;4;WAHR) I5 : =SVERWEIS(G5;$A$2:$D$39;4;WAHR) I6 : =SVERWEIS(G6;$A$2:$D$39;4;WAHR) I7 : =SVERWEIS(G7;$A$2:$D$39;4;WAHR) I8 : =SVERWEIS(G8;$A$2:$D$39;4;WAHR)
|
|