+- Lotto-Totostrategen (https://Lotto-Totostrategen.de)
+-- Forum: Private Tippgemeinschaften (https://Lotto-Totostrategen.de/forumdisplay.php?fid=935)
+--- Forum: Tippgemeinschaften Bereich Lotto (https://Lotto-Totostrategen.de/forumdisplay.php?fid=1002)
+---- Forum: Lotto TG No Angie (https://Lotto-Totostrategen.de/forumdisplay.php?fid=885)
+---- Thema: Lotto Am Samstag (/showthread.php?tid=21067)
Hallo @all :wink: Ich habe im Pool 2 in den Nebenzahlen die 49 gegen die 38 ausgetauscht außerdem die 43 gegen die - Conquistador - 09.09.2009
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
Hallo Peter werde mich bemühen meine Zahlen genauer zu kontrollieren! die erwähnte 30 hatte ich noch sofort bemerk - Thomas - 09.09.2009
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.
Hallo Thomas, kein Problem. Hat ja alles geklappt. Ich habe die Zahlenreihen schon an Norbert geschickt. Gruß Pet - Conquistador - 09.09.2009
Hallo Thomas,
kein Problem. Hat ja alles geklappt.
Ich habe die Zahlenreihen schon an Norbert geschickt.
Gruß Peter
:wink:@all, Tippabgabe hat geklappt - siehe "Quittungen" !! wie verfahren wir zukünftig mit den Zahlentreffern??? - Liane - 11.09.2009
@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
Soll thomas entscheiden:dafür: - Norbert - 11.09.2009
Soll thomas entscheiden:dafür:
Gab wohl nix zu holen heute.:mist: - Norbert - 12.09.2009
Gab wohl nix zu holen heute.
Hallo@all, da wir in beiden HZ-ZP keine Treffer hatten, würde ich vorschlagen, für kommenden Sa UNVERÄNDERT nochmals - Liane - 12.09.2009
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
Hallo Liane im Pool 1 ; N zahlen Treffer 41 + Zz. 48 im Pool 2 : N Zahlen Treffer 19 + Zz. 48 jedefalls sehe - Thomas - 13.09.2009
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
[quote][i]Original von Thomas[/i] Hallo Liane im Pool 1 ; N zahlen Treffer 41 + Zz. 48 im Pool 2 : N Zahlen Tr - Liane - 13.09.2009
Zitat: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....
;(
Hallo Liane hatte sogar die 5 N Zahl übersehen! Schade ! Nur EIN H/Treffer dazu hätte uns in die Ränge gebrach - Thomas - 13.09.2009
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