![]() |
Lotto Am Samstag - Druckversion +- 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 ![]() 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 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 |