Erweiterte Gewinntabelle des Lottosystems C(11,5,4) <=66

[aekey]

Hallo Leute ich brauche ein Programm (z.B. EXCEL) das mir anzeigt wieviel 1er 2er 3er oder 4er mit dem System C(11,5,4) <=66 zu erreichen sind.
Danke im Voraus.

[MarkoM]

Hallo aekey,
Habe zwar kein EXCEL-Program aber es sieht so aus:

1 Treffer = 100% 30x1
2 Treffer = 100% 12x2, 36x1
3 Treffer = 100% 4x3, 24x2, 30x1
4 Treffer = 100% 1x4, 12x3, 30x2, 20x1

5 Treffer = 80% 5x4, 20x3, 30x2, 10x1
5 Treffer = 20% 1x5, 0x4, 30x3, 20x2, 15x1

Viel Glück

[Conquistador]

Hallo aekey

nachfolgend die Treffertabelle

<b>Treffertabelle</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:14px;" /><col style="width:25px;" /><col style="width:19px;" /><col style="width:14px;" /><col style="width:81px;" /><col style="width:81px;" /><col style="width:81px;" /><col style="width:81px;" /><col style="width:80px;" /></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><td >G</td><td >H</td><td >I</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td colspan="9" style="font-weight:bold; text-align:center; ">11 Zahlen in 66 Reihen</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">T</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">aus</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">M</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; "> </td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">getestete</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">abgedeckte</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">%</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">fehlende</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; "> </td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; "> </td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; "> </td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; "> </td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">Reihen</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">Reihen</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; "> </td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">Reihen</td><td style="background-color:#ffff00; color:#ff0000; 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; text-align:right; ">2</td><td style="font-weight:bold; text-align:center; ">If</td><td style="font-weight:bold; text-align:right; ">2</td><td style="font-weight:bold; ">:</td><td style="font-weight:bold; text-align:right; ">55</td><td style="font-weight:bold; text-align:right; ">55</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; text-align:right; ">2</td><td style="font-weight:bold; text-align:center; ">If</td><td style="font-weight:bold; text-align:right; ">3</td><td style="font-weight:bold; ">:</td><td style="font-weight:bold; text-align:right; ">165</td><td style="font-weight:bold; text-align:right; ">165</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; text-align:right; ">2</td><td style="font-weight:bold; text-align:center; ">If</td><td style="font-weight:bold; text-align:right; ">4</td><td style="font-weight:bold; ">:</td><td style="font-weight:bold; text-align:right; ">330</td><td style="font-weight:bold; text-align:right; ">330</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; text-align:right; ">2</td><td style="font-weight:bold; text-align:center; ">If</td><td style="font-weight:bold; text-align:right; ">5</td><td style="font-weight:bold; ">:</td><td style="font-weight:bold; text-align:right; ">462</td><td style="font-weight:bold; text-align:right; ">462</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; text-align:right; ">2</td><td style="font-weight:bold; text-align:center; ">If</td><td style="font-weight:bold; text-align:right; ">6</td><td style="font-weight:bold; ">:</td><td style="font-weight:bold; text-align:right; ">462</td><td style="font-weight:bold; text-align:right; ">462</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; text-align:right; ">2</td><td style="font-weight:bold; text-align:center; ">If</td><td style="font-weight:bold; text-align:right; ">7</td><td style="font-weight:bold; ">:</td><td style="font-weight:bold; text-align:right; ">330</td><td style="font-weight:bold; text-align:right; ">330</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; " >10</td><td style="font-weight:bold; text-align:right; ">3</td><td style="font-weight:bold; text-align:center; ">If</td><td style="font-weight:bold; text-align:right; ">3</td><td style="font-weight:bold; ">:</td><td style="font-weight:bold; text-align:right; ">165</td><td style="font-weight:bold; text-align:right; ">165</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; " >11</td><td style="font-weight:bold; text-align:right; ">3</td><td style="font-weight:bold; text-align:center; ">If</td><td style="font-weight:bold; text-align:right; ">4</td><td style="font-weight:bold; ">:</td><td style="font-weight:bold; text-align:right; ">330</td><td style="font-weight:bold; text-align:right; ">330</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; text-align:right; ">3</td><td style="font-weight:bold; text-align:center; ">If</td><td style="font-weight:bold; text-align:right; ">5</td><td style="font-weight:bold; ">:</td><td style="font-weight:bold; text-align:right; ">462</td><td style="font-weight:bold; text-align:right; ">462</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; text-align:right; ">3</td><td style="font-weight:bold; text-align:center; ">If</td><td style="font-weight:bold; text-align:right; ">6</td><td style="font-weight:bold; ">:</td><td style="font-weight:bold; text-align:right; ">462</td><td style="font-weight:bold; text-align:right; ">462</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; " >14</td><td style="font-weight:bold; text-align:right; ">3</td><td style="font-weight:bold; text-align:center; ">If</td><td style="font-weight:bold; text-align:right; ">7</td><td style="font-weight:bold; ">:</td><td style="font-weight:bold; text-align:right; ">330</td><td style="font-weight:bold; text-align:right; ">330</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; " >15</td><td style="font-weight:bold; text-align:right; ">4</td><td style="font-weight:bold; text-align:center; ">If</td><td style="font-weight:bold; text-align:right; ">4</td><td style="font-weight:bold; ">:</td><td style="font-weight:bold; text-align:right; ">330</td><td style="font-weight:bold; text-align:right; ">330</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; " >16</td><td style="font-weight:bold; text-align:right; ">4</td><td style="font-weight:bold; text-align:center; ">If</td><td style="font-weight:bold; text-align:right; ">5</td><td style="font-weight:bold; ">:</td><td style="font-weight:bold; text-align:right; ">462</td><td style="font-weight:bold; text-align:right; ">462</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; " >17</td><td style="font-weight:bold; text-align:right; ">4</td><td style="font-weight:bold; text-align:center; ">If</td><td style="font-weight:bold; text-align:right; ">6</td><td style="font-weight:bold; ">:</td><td style="font-weight:bold; text-align:right; ">462</td><td style="font-weight:bold; text-align:right; ">462</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; " >18</td><td style="font-weight:bold; text-align:right; ">4</td><td style="font-weight:bold; text-align:center; ">If</td><td style="font-weight:bold; text-align:right; ">7</td><td style="font-weight:bold; ">:</td><td style="font-weight:bold; text-align:right; ">330</td><td style="font-weight:bold; text-align:right; ">330</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; " >19</td><td style="font-weight:bold; text-align:right; ">5</td><td style="font-weight:bold; ">If</td><td style="font-weight:bold; text-align:right; ">6</td><td style="font-weight:bold; ">:</td><td style="font-weight:bold; text-align:right; ">462</td><td style="font-weight:bold; text-align:right; ">396</td><td style="font-weight:bold; text-align:right; ">85,71429</td><td style="font-weight:bold; text-align:right; ">66</td><td style="font-weight:bold; text-align:right; ">14,28571</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >20</td><td style="font-weight:bold; text-align:right; ">5</td><td style="font-weight:bold; ">If</td><td style="font-weight:bold; text-align:right; ">7</td><td style="font-weight:bold; ">:</td><td style="font-weight:bold; text-align:right; ">330</td><td style="font-weight:bold; text-align:right; ">330</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></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>



<b>Treffertabelle Detail</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:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >K</td><td >L</td><td >M</td><td >N</td><td >O</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td colspan="5" style="font-weight:bold; text-align:center; ">3 Treffer</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">5</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">4</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">3</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">Total</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="font-weight:bold; text-align:center; ">-</td><td style="font-weight:bold; text-align:center; ">-</td><td style="font-weight:bold; text-align:center; ">4</td><td style="font-weight:bold; text-align:center; ">165</td><td style="font-weight:bold; text-align:center; ">100</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td colspan="5" style="font-weight:bold; text-align:center; ">4 Treffer</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">5</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">4</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">3</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">Total</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="font-weight:bold; text-align:center; ">-</td><td style="font-weight:bold; text-align:center; ">1</td><td style="font-weight:bold; text-align:center; ">12</td><td style="font-weight:bold; text-align:center; ">330</td><td style="font-weight:bold; text-align:center; ">100</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td colspan="5" style="font-weight:bold; text-align:center; ">5 Treffer</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">5</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">4</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">3</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">Total</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="font-weight:bold; text-align:center; ">-</td><td style="font-weight:bold; text-align:center; ">5</td><td style="font-weight:bold; text-align:center; ">20</td><td style="font-weight:bold; text-align:center; ">396</td><td style="font-weight:bold; text-align:center; ">85,71429</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td style="font-weight:bold; text-align:center; ">1</td><td style="font-weight:bold; text-align:center; ">0</td><td style="font-weight:bold; text-align:center; ">30</td><td style="font-weight:bold; text-align:center; ">66</td><td style="font-weight:bold; text-align:center; ">14,28571</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td colspan="5" style="font-weight:bold; text-align:center; ">6 Treffer</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">5</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">4</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">3</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">Total</td><td style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td style="font-weight:bold; text-align:center; ">-</td><td style="font-weight:bold; text-align:center; ">15</td><td style="font-weight:bold; text-align:center; ">20</td><td style="font-weight:bold; text-align:center; ">66</td><td style="font-weight:bold; text-align:center; ">14,28571</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td style="font-weight:bold; text-align:center; ">1</td><td style="font-weight:bold; text-align:center; ">10</td><td style="font-weight:bold; text-align:center; ">30</td><td style="font-weight:bold; text-align:center; ">396</td><td style="font-weight:bold; text-align:center; ">85,71429</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>


1er und 2er kann ich leider nicht testen

Gruß Peter

[aekey]

Hallo danke für die schnelle Antworten. Könnt Ihr mir vieleicht sagen wie sich so etwas berechnen lässt, damit ich es bei andere Systeme selber rechnen kann?

[Thomas]

Hallo aekey

ich bin etwas verwundert weshalb Du dich für ein 11 Zahlen System mit 66 Reihen interessierst ?

da doch ein System für 11 Zahlen mit 22 Reihen existiert welches bei 6 Treffern den 5er zu 100 % garantiert

[aekey]

Hallo Thomas. Es Interessiert mich deswegen weil ich in einem Looto spiele was 5 aus 45 ist und nicht 6 aus 49.

[Thomas]

Hallo aekey

Sorry alles klar --- wünsche Dir Glück bei der Auswahl der Zahlen

Gruss Thomas