Lotto Am Samstag

[Conquistador]

Hallo @all

Ich habe im Pool 2 in den Nebenzahlen die 49 gegen die 38 ausgetauscht

außerdem die 43 gegen die 19, da auch hier doppelt.

Im Pool 1 habe ich in den Nebenzahlen die 30 gegen die 41 ersetzt, da die 30 schon in den HZ vorhanden ist.

Bin schon ganz trieselig vom vielen Zahlen :guck:

Ich hoffe jetzt stimmt alles. Demnach sehen unsere Pools folgendermaßen aus:

<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:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /></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><td >J</td><td >K</td><td >L</td><td >M</td><td >N</td><td >O</td><td >P</td><td >Q</td><td >R</td><td >S</td><td >T</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td colspan="20" style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">Pool 1</td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td colspan="7" style="background-color:#00ff00; font-weight:bold; font-size:12pt; text-align:center; ">Hauptzahlen 1 -7</td><td colspan="13" style="font-weight:bold; font-size:12pt; text-align:center; ">Nebenzahlen 8 - 20</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="color:#000080; background-color:#00ff00; font-weight:bold; font-size:12pt; text-align:center; ">10</td><td style="color:#000080; background-color:#00ff00; font-weight:bold; font-size:12pt; text-align:center; ">15</td><td style="color:#000080; background-color:#00ff00; font-weight:bold; font-size:12pt; text-align:center; ">30</td><td style="color:#000080; background-color:#00ff00; font-weight:bold; font-size:12pt; text-align:center; ">21</td><td style="color:#000080; background-color:#00ff00; font-weight:bold; font-size:12pt; text-align:center; ">28</td><td style="color:#000080; background-color:#00ff00; font-weight:bold; font-size:12pt; text-align:center; ">29</td><td style="color:#000080; background-color:#00ff00; font-weight:bold; font-size:12pt; text-align:center; ">33</td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">5</td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">6</td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">9</td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">18</td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">27</td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">41</td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">31</td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">32</td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">37</td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">38</td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">39</td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">48</td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">49</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td colspan="20" > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td colspan="20" style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">Pool 2</td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td colspan="7" style="background-color:#ffcc99; color:#0000ff; font-weight:bold; font-size:12pt; text-align:center; ">Hauptzahlen 1 - 7</td><td colspan="13" style="background-color:#ccffff; color:#0000ff; font-weight:bold; font-size:12pt; text-align:center; ">Nebenzahlen 8 - 20</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="color:#0000ff; background-color:#ffcc99; font-weight:bold; font-size:12pt; text-align:center; ">15</td><td style="color:#0000ff; background-color:#ffcc99; font-weight:bold; font-size:12pt; text-align:center; ">20</td><td style="color:#0000ff; background-color:#ffcc99; font-weight:bold; font-size:12pt; text-align:center; ">21</td><td style="color:#0000ff; background-color:#ffcc99; font-weight:bold; font-size:12pt; text-align:center; ">28</td><td style="color:#0000ff; background-color:#ffcc99; font-weight:bold; font-size:12pt; text-align:center; ">37</td><td style="color:#0000ff; background-color:#ffcc99; font-weight:bold; font-size:12pt; text-align:center; ">43</td><td style="color:#0000ff; background-color:#ffcc99; font-weight:bold; font-size:12pt; text-align:center; ">49</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">3</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">6</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">10</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">11</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">16</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">18</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">31</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">33</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">34</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">19</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">46</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">48</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">38</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>




28 Zahlen im gesamten Pool

folgende Zahlen sind in beiden Pools enthallten:

6 10 15 18 21 28 31 33 37 38 48 49




<b>ungerade/gerade Verteilung im System:</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:33px;" /><col style="width:33px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td colspan="2" style="background-color:#ffff00; color:#ff0000; font-weight:bold; ">Tippreihen</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="background-color:#c0c0c0; font-weight:bold; text-align:center; ">U/G</td><td style="background-color:#c0c0c0; font-weight:bold; text-align:center; ">Anz</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="color:#ff0000; font-weight:bold; text-align:center; ">6/0</td><td style="font-weight:bold; text-align:center; ">0</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td style="color:#ff0000; font-weight:bold; text-align:center; ">5/1</td><td style="font-weight:bold; text-align:center; ">7</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td style="color:#ff0000; font-weight:bold; text-align:center; ">4/2</td><td style="font-weight:bold; text-align:center; ">18</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td style="color:#ff0000; font-weight:bold; text-align:center; ">3/3</td><td style="font-weight:bold; text-align:center; ">18</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td style="color:#ff0000; font-weight:bold; text-align:center; ">2/4</td><td style="font-weight:bold; text-align:center; ">5</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td style="color:#ff0000; font-weight:bold; text-align:center; ">1/5</td><td style="font-weight:bold; text-align:center; ">0</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td style="color:#ff0000; font-weight:bold; text-align:center; ">0/6</td><td style="font-weight:bold; text-align:center; ">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>

Gruß Peter

[Thomas]

Hallo Peter

werde mich bemühen meine Zahlen genauer zu kontrollieren!

die erwähnte 30 hatte ich noch sofort bemerkt
und korrigert, ein paar Minuten später per Bearbeiten die 3er Ziffer auf die 2er Ziffer geändert, hatte mich zuerst vertippt, hatte auf der Papiervorlage dito die 20 wie im 2.Pool.


aber kann ja auch wieder die 30 erscheinen am nächsten Sa. ist ja sowieso eine Glückssache.

Gruss Thomas

bin zZt. sehr im Stress mit Arztbesuchen Reise in die Schweiz (ich und meine Gattin) und dazu ist noch mein Bruder aus den USA hier eingetroffen ect.
meine Nerven sind etwas angespannt. und auch meinen PC musste ich neu installieren, ging letzte
Woche nicht mehr richtig. und div stundenlangen
Downloads + installieren mit Übertragungsraten
varierend zwischen 2,3 bis 4 Kbits. Updates ausführen.
also Sorry.

[Conquistador]

Hallo Thomas,

kein Problem. Hat ja alles geklappt.
Ich habe die Zahlenreihen schon an Norbert geschickt.

Gruß Peter

[Liane]

@all,

Tippabgabe hat geklappt - siehe "Quittungen" !!

wie verfahren wir zukünftig mit den Zahlentreffern???

werden die - wie gehabt - ausgetauscht, und wenn ja, nur die HZ oder auch die NZ ????

Grüße, Liane

[Norbert]

Soll thomas entscheiden:dafür:

[Norbert]

Gab wohl nix zu holen heute.

[Liane]

Hallo@all,

da wir in beiden HZ-ZP keine Treffer hatten, würde ich vorschlagen, für kommenden Sa UNVERÄNDERT nochmals abzugeben - ich hab die Scheinchen vorsichtshalber aufgehoben :D

Grüße, Liane

[Thomas]

Hallo Liane

im Pool 1 ; N zahlen Treffer 41 + Zz. 48

im Pool 2 : N Zahlen Treffer 19 + Zz. 48

jedefalls sehe ich das so in Peters Posting vom 9.Sept
----------------------------

ich würde wechseln, aber überlasse die Entscheidung Dir.

Viele Grüsse Thomas

[Liane]

Original von Thomas
Hallo Liane

im Pool 1 ; N zahlen Treffer 41 + Zz. 48

im Pool 2 : N Zahlen Treffer 19 + Zz. 48

jedefalls sehe ich das so in Peters Posting vom 9.Sept
----------------------------

ich würde wechseln, aber überlasse die Entscheidung Dir.

Viele Grüsse Thomas

Hallo Thomas und @all

hier die - gelb markierten - Treffer, welche sich "nur" in den Nebenzahlen finden:

<b>Tabelle1</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:47px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:46px;" /><col style="width:120px;" /><col style="width:37px;" /></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><td >J</td><td >K</td><td >L</td><td >M</td><td >N</td><td >O</td><td >P</td><td >Q</td><td >R</td><td >S</td><td >T</td><td >U</td><td >V</td><td >W</td><td >X</td><td >Y</td></tr><tr style="height:27px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td colspan="2" style="background-color:#ffff00; color:#ff0000; font-weight:bold; ">Tippreihen</td><td style="color:#ffffff; "> </td><td colspan="22" style="background-color:#000080; color:#ffff00; font-weight:bold; font-size:16pt; text-align:center; "> 2 x 20 Wahlzahlen a´24 Reihen = 48 Reihen</td></tr><tr style="height:27px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="background-color:#c0c0c0; font-weight:bold; text-align:center; ">U/G</td><td style="background-color:#c0c0c0; font-weight:bold; text-align:center; ">Anz</td><td style="color:#ffffff; "> </td><td style="font-weight:bold; ">EXCEL-Tabelle  2009 by Peter Franke (Deutschland)</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td colspan="12" style="background-color:#ffff00; font-weight:bold; font-size:14pt; text-align:center; ">7 H / 13 N 20 Wahlzahlensystem von Thomas </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="color:#ff0000; font-weight:bold; text-align:center; ">6/0</td><td style="font-weight:bold; text-align:center; ">0</td><td style="color:#ffffff; "> </td><td colspan="6" style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">ungerade/gerade Verteilung</td><td style="background-color:#c0c0c0; font-weight:bold; text-align:center; ">U</td><td style="background-color:#c0c0c0; font-weight:bold; text-align:center; ">G</td><td style="color:#ff0000; font-weight:bold; "> </td><td style="color:#ff0000; font-weight:bold; "> </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </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; " >4</td><td style="color:#ff0000; font-weight:bold; text-align:center; ">5/1</td><td style="font-weight:bold; text-align:center; ">7</td><td style="color:#ffffff; "> </td><td > </td><td > </td><td > </td><td colspan="3" style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">Zahlenpool</td><td style="font-weight:bold; text-align:center; ">22</td><td style="font-weight:bold; text-align:center; ">18</td><td > </td><td > </td><td colspan="8" style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">ungerade/gerade Verteilung in Ziehung</td><td style="background-color:#c0c0c0; font-weight:bold; text-align:center; ">U</td><td style="background-color:#c0c0c0; font-weight:bold; text-align:center; ">G</td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="color:#ff0000; font-weight:bold; text-align:center; ">4/2</td><td style="font-weight:bold; text-align:center; ">18</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td style="color:#ff0000; font-weight:bold; "> </td><td style="color:#ff0000; font-weight:bold; "> </td><td style="background-color:#000080; color:#ffff00; font-weight:bold; ">Gewinnzahlen zur Gewinnkontrolle</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; "> </td><td style="background-color:#000080; color:#ffff00; font-weight:bold; "> </td><td style="background-color:#000080; color:#ffff00; font-weight:bold; "> </td><td style="background-color:#000080; color:#ffff00; font-weight:bold; "> </td><td style="background-color:#000080; color:#ffff00; font-weight:bold; "> </td><td style="background-color:#000080; color:#ffff00; font-weight:bold; "> </td><td style="font-weight:bold; text-align:center; ">4</td><td style="font-weight:bold; text-align:center; ">3</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">Ziehung</td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="color:#ff0000; font-weight:bold; text-align:center; ">3/3</td><td style="font-weight:bold; text-align:center; ">18</td><td colspan="9" style="background-color:#ff0000; color:#ffff99; font-weight:bold; text-align:center; ">Die Pools können sich auch überschneiden!</td><td > </td><td > </td><td > </td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">1</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">2</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">3</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">4</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">5</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">6</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">ZZ</td><td > </td><td > </td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">vom</td><td > </td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="color:#ff0000; font-weight:bold; text-align:center; ">2/4</td><td style="font-weight:bold; text-align:center; ">5</td><td style="background-color:#ffff00; font-weight:bold; ">P 1</td><td colspan="5" style="background-color:#00ff00; font-weight:bold; font-size:12pt; text-align:center; ">Hauptzahlen 1 -7</td><td colspan="5" style="font-weight:bold; font-size:12pt; text-align:center; ">Nebenzahlen 8 - 20</td><td > </td><td style="color:#ff0000; background-color:#ffff00; font-weight:bold; text-align:center; ">5</td><td style="color:#ff0000; background-color:#ffff00; font-weight:bold; text-align:center; ">19</td><td style="font-weight:bold; text-align:center; ">23</td><td style="color:#ff0000; background-color:#ffff00; font-weight:bold; text-align:center; ">34</td><td style="font-weight:bold; text-align:center; ">40</td><td style="color:#ff0000; background-color:#ffff00; font-weight:bold; text-align:center; ">41</td><td style="color:#0000ff; background-color:#00ffff; font-weight:bold; text-align:center; ">48</td><td > </td><td > </td><td style="font-weight:bold; text-align:center; ">12.09.2009</td><td > </td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="color:#ff0000; font-weight:bold; text-align:center; ">1/5</td><td style="font-weight:bold; text-align:center; ">0</td><td style="background-color:#ffff00; font-weight:bold; ">P 2</td><td colspan="5" style="background-color:#ffcc99; color:#0000ff; font-weight:bold; font-size:12pt; text-align:center; ">Hauptzahlen 1 - 7</td><td colspan="5" style="background-color:#ccffff; color:#0000ff; font-weight:bold; font-size:12pt; text-align:center; ">Nebenzahlen 8 - 20</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </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; " >9</td><td style="color:#ff0000; font-weight:bold; text-align:center; ">0/6</td><td style="font-weight:bold; text-align:center; ">0</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">1</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">2</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">3</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">4</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">5</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">6</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">7</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">8</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">9</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">10</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">11</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">12</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">13</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">14</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">15</td><td > </td><td colspan="5" style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">Richtige Zahlen im Pool 1</td><td > </td><td > </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td > </td><td > </td><td style="color:#000080; background-color:#00ff00; font-weight:bold; font-size:12pt; text-align:center; ">10</td><td style="color:#000080; background-color:#00ff00; font-weight:bold; font-size:12pt; text-align:center; ">15</td><td style="color:#000080; background-color:#00ff00; font-weight:bold; font-size:12pt; text-align:center; ">30</td><td style="color:#000080; background-color:#00ff00; font-weight:bold; font-size:12pt; text-align:center; ">21</td><td style="color:#000080; background-color:#00ff00; font-weight:bold; font-size:12pt; text-align:center; ">28</td><td style="color:#000080; background-color:#00ff00; font-weight:bold; font-size:12pt; text-align:center; ">29</td><td style="color:#000080; background-color:#00ff00; font-weight:bold; font-size:12pt; text-align:center; ">33</td><td style="color:#ff0000; background-color:#ffff00; font-weight:bold; font-size:12pt; text-align:center; ">5</td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">6</td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">9</td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">18</td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">27</td><td style="color:#ff0000; background-color:#ffff00; font-weight:bold; font-size:12pt; text-align:center; ">41</td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">31</td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">32</td><td > </td><td > </td><td style="background-color:#ffff99; color:#0000ff; font-weight:bold; font-size:12pt; text-align:center; ">2</td><td colspan="2" style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">Zusatzz.</td><td style="background-color:#ffff99; color:#0000ff; font-weight:bold; font-size:12pt; text-align:center; ">1</td><td > </td><td > </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td > </td><td > </td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">37</td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">38</td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">39</td><td style="color:#0000ff; background-color:#00ffff; font-weight:bold; font-size:12pt; text-align:center; ">48</td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">49</td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td > </td><td colspan="5" style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">Richtige Zahlen im Pool 2</td><td > </td><td > </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td > </td><td > </td><td style="color:#0000ff; background-color:#ffcc99; font-weight:bold; font-size:12pt; text-align:center; ">15</td><td style="color:#0000ff; background-color:#ffcc99; font-weight:bold; font-size:12pt; text-align:center; ">20</td><td style="color:#0000ff; background-color:#ffcc99; font-weight:bold; font-size:12pt; text-align:center; ">21</td><td style="color:#0000ff; background-color:#ffcc99; font-weight:bold; font-size:12pt; text-align:center; ">28</td><td style="color:#0000ff; background-color:#ffcc99; font-weight:bold; font-size:12pt; text-align:center; ">37</td><td style="color:#0000ff; background-color:#ffcc99; font-weight:bold; font-size:12pt; text-align:center; ">43</td><td style="color:#0000ff; background-color:#ffcc99; font-weight:bold; font-size:12pt; text-align:center; ">49</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">3</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">6</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">10</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">11</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">16</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">18</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">31</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">33</td><td > </td><td > </td><td style="background-color:#ffff99; color:#0000ff; font-weight:bold; font-size:12pt; text-align:center; ">2</td><td colspan="2" style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">Zusatzz.</td><td style="background-color:#ffff99; color:#0000ff; font-weight:bold; font-size:12pt; text-align:center; ">1</td><td > </td><td > </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td > </td><td > </td><td style="color:#ff0000; background-color:#ffff00; font-weight:bold; font-size:12pt; text-align:center; ">34</td><td style="color:#ff0000; background-color:#ffff00; font-weight:bold; font-size:12pt; text-align:center; ">19</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">46</td><td style="color:#0000ff; background-color:#00ffff; font-weight:bold; font-size:12pt; text-align:center; ">48</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">38</td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">Durchschnitts-</td><td > </td></tr></table>
<table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Formeln der Tabelle</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Zelle</td><td >Formel</td></tr><tr><td >B3</td><td >=SUMMENPRODUKT(($A$16:$A$63=6)*($B$16:$B$63=0))</td></tr><tr><td >B4</td><td >=SUMMENPRODUKT(($A$16:$A$63=5)*($B$16:$B$63=1))</td></tr><tr><td >J4</td><td >{=SUMME(REST(C10:Q13;2))}</td></tr><tr><td >K4</td><td >{=ANZAHL(C10:Q13)-SUMME(REST(C10:Q13;2))}</td></tr><tr><td >B5</td><td >=SUMMENPRODUKT(($A$16:$A$63=4)*($B$16:$B$63=2))</td></tr><tr><td >V5</td><td >{=SUMME(REST(O7:U7;2))}</td></tr><tr><td >W5</td><td >{=ANZAHL(O7:U7)-SUMME(REST(O7:U7;2))}</td></tr><tr><td >B6</td><td >=SUMMENPRODUKT(($A$16:$A$63=3)*($B$16:$B$63=3))</td></tr><tr><td >B7</td><td >=SUMMENPRODUKT(($A$16:$A$63=2)*($B$16:$B$63=4))</td></tr><tr><td >B8</td><td >=SUMMENPRODUKT(($A$16:$A$63=1)*($B$16:$B$63=5))</td></tr><tr><td >B9</td><td >=SUMMENPRODUKT(($A$16:$A$63=0)*($B$16:$B$63=6))</td></tr><tr><td >T10</td><td >=SUMMENPRODUKT(ZÄHLENWENN($O$7:$T$7;C10:Q11))</td></tr><tr><td >W10</td><td >=SUMMENPRODUKT(ZÄHLENWENN($U$7;C10:Q11))</td></tr><tr><td >T12</td><td >=SUMMENPRODUKT(ZÄHLENWENN($O$7:$T$7;C12:Q13))</td></tr><tr><td >W12</td><td >=SUMMENPRODUKT(ZÄHLENWENN($U$7;C12:Q13))</td></tr></table></td></tr><tr><td >Enthält Matrixformel:
Umrandende { } nicht miteingeben,
sondern Formel mit STRG+SHIFT+RETURN abschließen!</td></tr><tr><td >Matrix verstehen</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>


wenn keiner was dagegen hat, geb ich nochmals unverändert ab (wahrscheinlich schon am Mittwoch!!)

Grüße@all, Liane

PS: sorry, ich krieg den Tab-Ausschnitt nicht anders ins Forum.... ;(

[Thomas]

Hallo Liane

hatte sogar die 5 N Zahl übersehen!

Schade !

Nur EIN H/Treffer dazu hätte uns in die Ränge gebracht.

Gruss Thomas