Zitat:Original von Kreuzle
Ah herrje :roll: so viele Reihen, das sind 450?
Eure Tabelle verstehe ich nicht so ganz, was die Zahlen genau bedeuten.
Beispiel:
<b></b>
<table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:62px;" /><col style="width:104px;" /><col style="width:104px;" /><col style="width:70px;" /><col style="width:104px;" /><col style="width:70px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td><td >F</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; ">getestete</td><td style="font-weight:bold; ">abgedeckte</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; ">fehlende</td><td style="font-weight:bold; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="font-weight:bold; ">Garantie</td><td style="font-weight:bold; ">Kombinationen</td><td style="font-weight:bold; ">Kombinationen</td><td style="font-weight:bold; ">Prozent %</td><td style="font-weight:bold; ">Kombinationen</td><td style="font-weight:bold; ">Prozent %</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="font-weight:bold; ">--------</td><td style="font-weight:bold; ">-------------</td><td style="font-weight:bold; ">-------------</td><td style="font-weight:bold; ">------------</td><td style="font-weight:bold; ">-------------</td><td style="font-weight:bold; ">------------</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="font-weight:bold; ">2aus2</td><td style="font-weight:bold; text-align:right; ">595</td><td style="font-weight:bold; text-align:right; ">595</td><td style="font-weight:bold; text-align:right; ">100</td><td style="font-weight:bold; text-align:right; ">0</td><td style="font-weight:bold; text-align:right; ">0</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="font-weight:bold; ">2aus3</td><td style="font-weight:bold; text-align:right; ">6.545</td><td style="font-weight:bold; text-align:right; ">6.545</td><td style="font-weight:bold; text-align:right; ">100</td><td style="font-weight:bold; text-align:right; ">0</td><td style="font-weight:bold; text-align:right; ">0</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="font-weight:bold; ">2aus4</td><td style="font-weight:bold; text-align:right; ">52.360</td><td style="font-weight:bold; text-align:right; ">52.360</td><td style="font-weight:bold; text-align:right; ">100</td><td style="font-weight:bold; text-align:right; ">0</td><td style="font-weight:bold; text-align:right; ">0</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="font-weight:bold; ">2aus5</td><td style="font-weight:bold; text-align:right; ">324.632</td><td style="font-weight:bold; text-align:right; ">324.632</td><td style="font-weight:bold; text-align:right; ">100</td><td style="font-weight:bold; text-align:right; ">0</td><td style="font-weight:bold; text-align:right; ">0</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="font-weight:bold; ">2aus6</td><td style="font-weight:bold; text-align:right; ">1.623.160</td><td style="font-weight:bold; text-align:right; ">1.623.160</td><td style="font-weight:bold; text-align:right; ">100</td><td style="font-weight:bold; text-align:right; ">0</td><td style="font-weight:bold; text-align:right; ">0</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="font-weight:bold; ">3aus3</td><td style="font-weight:bold; text-align:right; ">6.545</td><td style="font-weight:bold; text-align:right; ">4.485</td><td style="font-weight:bold; text-align:right; ">68,52559</td><td style="font-weight:bold; text-align:right; ">2.060</td><td style="font-weight:bold; text-align:right; ">31,47441</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="font-weight:bold; ">3aus4</td><td style="font-weight:bold; text-align:right; ">52.360</td><td style="font-weight:bold; text-align:right; ">51.877</td><td style="font-weight:bold; text-align:right; ">99,07754</td><td style="font-weight:bold; text-align:right; ">483</td><td style="font-weight:bold; text-align:right; ">0,92246</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="font-weight:bold; ">3aus5</td><td style="font-weight:bold; text-align:right; ">324.632</td><td style="font-weight:bold; text-align:right; ">324.632</td><td style="font-weight:bold; text-align:right; ">100</td><td style="font-weight:bold; text-align:right; ">0</td><td style="font-weight:bold; text-align:right; ">0</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="font-weight:bold; ">3aus6</td><td style="font-weight:bold; text-align:right; ">1.623.160</td><td style="font-weight:bold; text-align:right; ">1.623.160</td><td style="font-weight:bold; text-align:right; ">100</td><td style="font-weight:bold; text-align:right; ">0</td><td style="font-weight:bold; text-align:right; ">0</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td style="font-weight:bold; ">4aus4</td><td style="font-weight:bold; text-align:right; ">52.360</td><td style="font-weight:bold; text-align:right; ">2.250</td><td style="font-weight:bold; text-align:right; ">4,29717</td><td style="font-weight:bold; text-align:right; ">50.110</td><td style="font-weight:bold; text-align:right; ">95,70283</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td style="font-weight:bold; ">4aus5</td><td style="font-weight:bold; text-align:right; ">324.632</td><td style="font-weight:bold; text-align:right; ">67.890</td><td style="font-weight:bold; text-align:right; ">20,91291</td><td style="font-weight:bold; text-align:right; ">256.742</td><td style="font-weight:bold; text-align:right; ">79,08709</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td style="font-weight:bold; ">4aus6</td><td style="font-weight:bold; text-align:right; ">1.623.160</td><td style="font-weight:bold; text-align:right; ">857.995</td><td style="font-weight:bold; text-align:right; ">52,85955</td><td style="font-weight:bold; text-align:right; ">765.165</td><td style="font-weight:bold; text-align:right; ">47,14045</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td style="font-weight:bold; ">5aus5</td><td style="font-weight:bold; text-align:right; ">324.632</td><td style="font-weight:bold; text-align:right; ">450</td><td style="font-weight:bold; text-align:right; ">0,13862</td><td style="font-weight:bold; text-align:right; ">324.182</td><td style="font-weight:bold; text-align:right; ">99,86138</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td style="font-weight:bold; ">5aus6</td><td style="font-weight:bold; text-align:right; ">1.623.160</td><td style="font-weight:bold; text-align:right; ">13.500</td><td style="font-weight:bold; text-align:right; ">0,83171</td><td style="font-weight:bold; text-align:right; ">1.609.660</td><td style="font-weight:bold; text-align:right; ">99,16829</td></tr></table>
Excel Tabellen im Web darstellen >> <a style ="font-family:Arial; font-size:9pt; color:#fcf507; background-color:#800040; font-weight:bold;" href="http://www.excel-jeanie-html.de" target="_blank"> Excel Jeanie HTML 4 </a>
zu lesen so:
2aus2 zu 100 %
2aus3 zu 100 %
2aus4 zu 100 %
2aus5 zu 100 %
2aus6 zu 100 %
3aus3 zu 68,52559 %
3aus4 zu 99,07754 %
3aus5 zu 100 %
3aus6 zu 100 %
4aus4 zu 4,29717 %
4aus5 zu 20,91291 %
4aus6 zu 52,85955 %
5aus5 zu 0,13862 %
5aus6 zu 0,83171 %
Beispiel:
<b></b>
<table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:62px;" /><col style="width:104px;" /><col style="width:104px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >49</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; ">getestete</td><td style="font-weight:bold; ">abgedeckte</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >50</td><td style="font-weight:bold; ">Garantie</td><td style="font-weight:bold; ">Kombinationen</td><td style="font-weight:bold; ">Kombinationen</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >51</td><td style="font-weight:bold; ">--------</td><td style="font-weight:bold; ">-------------</td><td style="font-weight:bold; ">-------------</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >52</td><td style="font-weight:bold; ">2aus2</td><td style="font-weight:bold; text-align:right; ">595</td><td style="font-weight:bold; text-align:right; ">595</td></tr></table>
Excel Tabellen im Web darstellen >> <a style ="font-family:Arial; font-size:9pt; color:#fcf507; background-color:#800040; font-weight:bold;" href="http://www.excel-jeanie-html.de" target="_blank"> Excel Jeanie HTML 4 </a>
595 von 595 möglichen Kombinationen sind abgedeckt
Beispiel:
<b></b>
<table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:62px;" /><col style="width:104px;" /><col style="width:104px;" /><col style="width:70px;" /><col style="width:104px;" /><col style="width:70px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td><td >F</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >49</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; ">getestete</td><td style="font-weight:bold; ">abgedeckte</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; ">fehlende</td><td style="font-weight:bold; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >50</td><td style="font-weight:bold; ">Garantie</td><td style="font-weight:bold; ">Kombinationen</td><td style="font-weight:bold; ">Kombinationen</td><td style="font-weight:bold; ">Prozent %</td><td style="font-weight:bold; ">Kombinationen</td><td style="font-weight:bold; ">Prozent %</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >51</td><td style="font-weight:bold; ">--------</td><td style="font-weight:bold; ">-------------</td><td style="font-weight:bold; ">-------------</td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >52</td><td style="font-weight:bold; ">3aus4</td><td style="font-weight:bold; text-align:right; ">52.360</td><td style="font-weight:bold; text-align:right; ">51.877</td><td style="font-weight:bold; text-align:right; ">99,07754</td><td style="font-weight:bold; text-align:right; ">483</td><td style="font-weight:bold; text-align:right; ">0,92246</td></tr></table>
Excel Tabellen im Web darstellen >> <a style ="font-family:Arial; font-size:9pt; color:#fcf507; background-color:#800040; font-weight:bold;" href="http://www.excel-jeanie-html.de" target="_blank"> Excel Jeanie HTML 4 </a>
51.877 von 52.360 sind abgedeckt, 483
Kombinationen sind nicht abgedeckt.
Alles klar??
Gruß Peter
Erfahrung ist eine nützliche Sache.
Leider macht man sie immer erst kurz nachdem man sie brauchte.