Mein System

Monopolis · April 22, 2007

So dürfte das "Biersystem" passen. Die Werte sind aus der Sicht der Bank betrachtet; Pluskontostände bedeuten für den Spieler M I N U S !

<b>WHG-TVS</b><br /><br /><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="width:30px; " /><col style="width:40px;" /><col style="width:40px;" /><col style="width:26px;" /><col style="width:26px;" /><col style="width:34px;" /><col style="width:26px;" /><col style="width:26px;" /><col style="width:26px;" /></colgroup><tr style="background-color:#cacaca; text-align:center;font-size:8pt; "><td > </td><td >A</td><td >B</td><td >J</td><td >K</td><td >Z</td><td >AA</td><td >AB</td><td >AC</td></tr><tr style="height:15px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td><td style="font-size:8pt; text-align:center; ">107</td><td style="font-size:8pt; text-align:center; ">155</td><td style="font-size:8pt; text-align:center; ">ZEILE</td><td style="font-size:8pt; text-align:center; ">0</td><td style="font-size:8pt; text-align:center; ">1</td><td style="font-size:8pt; text-align:center; ">2</td></tr><tr style="height:15px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="font-size:8pt; text-align:center; ">COUP-</td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td><td style="font-size:8pt; text-align:center; ">-10</td><td style="font-size:8pt; text-align:center; ">2</td><td style="font-size:8pt; text-align:center; ">Z</td><td style="font-size:8pt; text-align:center; ">1</td><td style="font-size:8pt; text-align:center; ">1</td></tr><tr style="height:15px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="font-size:8pt; text-align:center; ">NR.</td><td style="font-size:8pt; text-align:center; ">ZAHL</td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td><td style="font-size:8pt; text-align:center; ">3</td><td style="font-size:8pt; text-align:center; ">Z</td><td style="font-size:8pt; text-align:center; ">1</td><td style="font-size:8pt; text-align:center; ">1</td></tr><tr style="height:15px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="background-color:#ffff99; font-size:8pt; text-align:center; ">1</td><td style="font-size:8pt; text-align:center; ">6</td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td></tr><tr style="height:15px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="background-color:#ffff99; font-size:8pt; text-align:center; ">2</td><td style="font-size:8pt; text-align:center; ">27</td><td style="font-size:8pt; text-align:center; ">-1</td><td style="font-size:8pt; text-align:center; ">-1</td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td></tr><tr style="height:15px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="background-color:#ffff99; font-size:8pt; text-align:center; ">3</td><td style="font-size:8pt; text-align:center; ">31</td><td style="font-size:8pt; text-align:center; ">-1</td><td style="font-size:8pt; text-align:center; ">-2</td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td></tr><tr style="height:15px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="background-color:#ffff99; font-size:8pt; text-align:center; ">4</td><td style="font-size:8pt; text-align:center; ">4</td><td style="font-size:8pt; text-align:center; ">-1</td><td style="font-size:8pt; text-align:center; ">-3</td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td></tr><tr style="height:15px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="background-color:#ffff99; font-size:8pt; text-align:center; ">5</td><td style="font-size:8pt; text-align:center; ">27</td><td style="font-size:8pt; text-align:center; ">-1</td><td style="font-size:8pt; text-align:center; ">-4</td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td></tr><tr style="height:15px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="background-color:#ffff99; font-size:8pt; text-align:center; ">6</td><td style="font-size:8pt; text-align:center; ">7</td><td style="font-size:8pt; text-align:center; ">-1</td><td style="font-size:8pt; text-align:center; ">-5</td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td></tr><tr style="height:15px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="background-color:#ffff99; font-size:8pt; text-align:center; ">7</td><td style="font-size:8pt; text-align:center; ">32</td><td style="font-size:8pt; text-align:center; ">-1</td><td style="font-size:8pt; text-align:center; ">-6</td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td></tr><tr style="height:15px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="background-color:#ffff99; font-size:8pt; text-align:center; ">8</td><td style="font-size:8pt; text-align:center; ">30</td><td style="font-size:8pt; text-align:center; ">-1</td><td style="font-size:8pt; text-align:center; ">-7</td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td></tr><tr style="height:15px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="background-color:#ffff99; font-size:8pt; text-align:center; ">9</td><td style="font-size:8pt; text-align:center; ">30</td><td style="font-size:8pt; text-align:center; ">5</td><td style="font-size:8pt; text-align:center; ">-2</td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td></tr><tr style="height:15px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td style="background-color:#ffff99; font-size:8pt; text-align:center; ">10</td><td style="font-size:8pt; text-align:center; ">15</td><td style="font-size:8pt; text-align:center; ">-1</td><td style="font-size:8pt; text-align:center; ">-3</td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td></tr><tr style="height:15px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td style="background-color:#ffff99; font-size:8pt; text-align:center; ">11</td><td style="font-size:8pt; text-align:center; ">19</td><td style="font-size:8pt; text-align:center; ">-1</td><td style="font-size:8pt; text-align:center; ">-4</td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td><td style="font-size:8pt; "> </td></tr></table><br /><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 >J1</td><td >=ZÄHLENWENN(J5:J503;5)</td></tr><tr><td >K1</td><td >=MAX(K5:K503)</td></tr><tr><td >K2</td><td >=MIN(K5:K503)</td></tr><tr><td >B4</td><td >=Auswertungen!$B4</td></tr><tr><td >A5</td><td >=WENN($B5="";"";$A4+1)</td></tr><tr><td >B5</td><td >=Auswertungen!$B5</td></tr><tr><td >J5</td><td >=WENN(D5="Z";5;WENN(D5=D4;5;-1))</td></tr><tr><td >K5</td><td >=J5</td></tr><tr><td >A6</td><td >=WENN($B6="";"";$A5+1)</td></tr><tr><td >B6</td><td >=Auswertungen!$B6</td></tr><tr><td >J6</td><td >=WENN(D6="Z";5;WENN(D6=D5;5;-1))</td></tr><tr><td >K6</td><td >=K5+J6</td></tr><tr><td >A7</td><td >=WENN($B7="";"";$A6+1)</td></tr><tr><td >B7</td><td >=Auswertungen!$B7</td></tr><tr><td >J7</td><td >=WENN(D7="Z";5;WENN(D7=D6;5;-1))</td></tr><tr><td >K7</td><td >=K6+J7</td></tr><tr><td >A8</td><td >=WENN($B8="";"";$A7+1)</td></tr><tr><td >B8</td><td >=Auswertungen!$B8</td></tr><tr><td >J8</td><td >=WENN(D8="Z";5;WENN(D8=D7;5;-1))</td></tr><tr><td >K8</td><td >=K7+J8</td></tr><tr><td >A9</td><td >=WENN($B9="";"";$A8+1)</td></tr><tr><td >B9</td><td >=Auswertungen!$B9</td></tr><tr><td >J9</td><td >=WENN(D9="Z";5;WENN(D9=D8;5;-1))</td></tr><tr><td >K9</td><td >=K8+J9</td></tr><tr><td >A10</td><td >=WENN($B10="";"";$A9+1)</td></tr><tr><td >B10</td><td >=Auswertungen!$B10</td></tr><tr><td >J10</td><td >=WENN(D10="Z";5;WENN(D10=D9;5;-1))</td></tr><tr><td >K10</td><td >=K9+J10</td></tr><tr><td >A11</td><td >=WENN($B11="";"";$A10+1)</td></tr><tr><td >B11</td><td >=Auswertungen!$B11</td></tr><tr><td >J11</td><td >=WENN(D11="Z";5;WENN(D11=D10;5;-1))</td></tr><tr><td >K11</td><td >=K10+J11</td></tr><tr><td >A12</td><td >=WENN($B12="";"";$A11+1)</td></tr><tr><td >B12</td><td >=Auswertungen!$B12</td></tr><tr><td >J12</td><td >=WENN(D12="Z";5;WENN(D12=D11;5;-1))</td></tr><tr><td >K12</td><td >=K11+J12</td></tr><tr><td >A13</td><td >=WENN($B13="";"";$A12+1)</td></tr><tr><td >B13</td><td >=Auswertungen!$B13</td></tr><tr><td >J13</td><td >=WENN(D13="Z";5;WENN(D13=D12;5;-1))</td></tr><tr><td >K13</td><td >=K12+J13</td></tr><tr><td >A14</td><td >=WENN($B14="";"";$A13+1)</td></tr><tr><td >B14</td><td >=Auswertungen!$B14</td></tr><tr><td >J14</td><td >=WENN(D14="Z";5;WENN(D14=D13;5;-1))</td></tr><tr><td >K14</td><td >=K13+J14</td></tr></table></td></tr></table> <br /><br /><span style="font-family:Arial; font-size:9pt; font-weight:bold;background-color:#ffffff; color:#000000; ">Excel Tabellen im Web darstellen >> </span><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>

Monopolis · April 22, 2007

Kontrolle:

#26;J1 - #25;F1 = 107 - 91 = 16 (Anzahl Zero am 21.04.2007, CC Tisch1)

Wenn es passt, habe ich richtig gerechnet. :anstoss:

NACHTRAG: 16 x Zero = OK.

Und der guten Ordnung halber: Noch mal die 21 Tage mit der korrigierten

Bemerkung.

bearbeitet April 22, 2007 von Monopolis

Monopolis · April 22, 2007

<b>Z-ERG</b><br /><br /><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="width:30px; " /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /></colgroup><tr style="background-color:#cacaca; text-align:center;font-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></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">DATUM</td><td > </td><td colspan="6" style="background-color:#ffcc99; font-size:12pt; text-decoration:underline; text-align:left; ">DIE ERSTEN 21 APRILTAGE IM CC AN TISCH 1:</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">21.04.2007</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">TAG-NR.</td><td > </td><td colspan="6" style="background-color:#ffcc99; "> </td><td style="text-align:center; ">811</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="font-weight:bold; font-size:8pt; ">TVS</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">SUMME</td><td > </td><td colspan="6" style="background-color:#ffcc99; text-align:left; ">SUMME = ANZAHL DER TREFFER / NICHTTREFFER.</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">91</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">MAX</td><td > </td><td colspan="6" style="background-color:#ffcc99; text-align:left; ">MAX = HÖCHSSTAND BEI SATZ AUF WIEDERHOLUNG.</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">65</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">MIN</td><td > </td><td colspan="6" style="background-color:#ffcc99; text-align:left; ">MIN = TIEFSTSTAND BEI SATZ AUF WIEDERHOLUNG.</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-10</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td > </td><td style="font-weight:bold; font-size:8pt; "> </td><td > </td><td colspan="6" style="background-color:#ffcc99; "> </td><td style="font-weight:bold; font-size:8pt; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="font-weight:bold; font-size:8pt; ">TVP</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">SUMME</td><td > </td><td colspan="6" style="background-color:#ffcc99; text-align:left; ">DIE ERGEBNISSE GELTEN FÜR SATZ AUF WIEDERHOLUNG DER</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">50</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">MAX</td><td > </td><td colspan="6" style="background-color:#ffcc99; text-align:left; ">TVS / TVP.</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">131</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">MIN</td><td > </td><td colspan="6" style="background-color:#ffcc99; text-align:left; ">KORREKTUR: 070422</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-7</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</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; " >11</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; " >12</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">DATUM</td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">20.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">19.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">18.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">17.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">16.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">15.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">14.04.2007</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">TAG-NR.</td><td > </td><td style="text-align:center; ">810</td><td style="text-align:center; ">809</td><td style="text-align:center; ">808</td><td style="text-align:center; ">807</td><td style="text-align:center; ">806</td><td style="text-align:center; ">805</td><td style="text-align:center; ">804</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td style="font-weight:bold; font-size:8pt; ">TVS</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">SUMME</td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">87</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">74</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">75</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">87</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">84</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">84</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">78</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">MAX</td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">39</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">26</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">51</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">19</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">21</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">4</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">MIN</td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-11</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-55</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-62</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-18</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-33</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-24</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-41</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td > </td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td style="font-weight:bold; font-size:8pt; ">TVP</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">SUMME</td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">39</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">36</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">32</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">50</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">40</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">47</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">36</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >19</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">MAX</td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">58</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">38</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">14</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">103</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">23</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">80</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">29</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >20</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">MIN</td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-31</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-77</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-152</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-31</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-71</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-30</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-96</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >21</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; " >22</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; " >23</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">DATUM</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">13.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">12.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">11.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">10.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">09.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">08.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">07.04.2007</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >24</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">TAG-NR.</td><td > </td><td style="text-align:center; ">803</td><td style="text-align:center; ">802</td><td style="text-align:center; ">801</td><td style="text-align:center; ">800</td><td style="text-align:center; ">799</td><td style="text-align:center; ">798</td><td style="text-align:center; ">797</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >25</td><td style="font-weight:bold; font-size:8pt; ">TVS</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">SUMME</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">72</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">94</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">70</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">83</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">72</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">80</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">71</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >26</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">MAX</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">8</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">68</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">9</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">23</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">2</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">43</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-1</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >27</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">MIN</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-93</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-27</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-79</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-25</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-75</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-35</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-93</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >28</td><td > </td><td style="font-weight:bold; font-size:8pt; "> </td><td > </td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >29</td><td style="font-weight:bold; font-size:8pt; ">TVP</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">SUMME</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">30</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">53</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">34</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">41</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">33</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">38</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">37</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >30</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">MAX</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">8</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">162</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">19</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">25</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">8</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">18</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-1</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >31</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">MIN</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-178</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-32</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-91</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-39</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-103</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-72</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-94</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >32</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; " >33</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; " >34</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">DATUM</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">06.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">05.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">04.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">04.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">03.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">02.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">01.04.2007</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >35</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">TAG-NR.</td><td > </td><td style="text-align:center; ">796</td><td style="text-align:center; ">795</td><td style="text-align:center; ">794</td><td style="text-align:center; ">794</td><td style="text-align:center; ">793</td><td style="text-align:center; ">792</td><td style="text-align:center; ">791</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >36</td><td style="font-weight:bold; font-size:8pt; ">TVS</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">SUMME</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">67</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">65</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">85</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">85</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">68</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">72</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">92</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >37</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">MAX</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">19</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">9</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">12</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">12</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">8</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">0</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">63</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >38</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">MIN</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-118</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-122</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-42</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-42</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-100</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-75</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-41</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >39</td><td > </td><td style="font-weight:bold; font-size:8pt; "> </td><td > </td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >40</td><td style="font-weight:bold; font-size:8pt; ">TVP</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">SUMME</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">31</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">28</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">42</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">42</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">24</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">34</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">47</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >41</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">MAX</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">15</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">48</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">48</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">20</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">3</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">71</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >42</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">MIN</td><td > </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-167</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-178</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-62</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-62</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-213</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-100</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-53</td></tr></table> <br /><br /><span style="font-family:Arial; font-size:9pt; font-weight:bold;background-color:#ffffff; color:#000000; ">Excel Tabellen im Web darstellen >> </span><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>

Revanchist · April 22, 2007

Nichts gegen diese Tabelle, aber ich dachte eigentlich an folgendes.
←

Hallo Bierfreund

ich glaube so etwas wie unten dargestellt könnte deiner Vorstellung am nähesten kommen:

Moin Monopolis

sorry - aber warum hast du dir soviel Arbeit gemacht. Ich schrieb doch - kein Problem, ich hab da was, was ich nur anpassen muss.

<table><tr style="vertical-align:top; text-align:center; "><tr><td>Tabelle1</td></tr><tr><td><table border=1 cellspacing=0 cellpadding=0 style="font-family:Arial,Arial; font-size:10pt; padding-left:2pt; padding-right:2pt; "> <style type = "text/css"> th {font-weight:normal} </style> <colgroup><col width=45.99999885 ><col width=102.999997425 ><col width=48.999998775 ><col width=45.99999885 ><col width=41.99999895 ><col width=114.999997125 ><col width=79.999998 ><col width=48.999998775 ></colgroup><tr height=17><td style=""> </td><td style=""> </td><td style="text-align:center; "> </td><td style=""> </td><td style="text-align:center; "> </td><td style=""> </td><td style=""> </td><td style=""> </td></tr><tr height=21><td style=""> </td><th colspan="3" rowspan="1" style="background-color:#ffcc99; text-align:center; font-weight:bold; ">Salden</th><td style="font-size:12pt; text-align:center; font-weight:bold; ">+</td><th colspan="2" rowspan="1" style="background-color:#ffcc99; text-align:center; font-weight:bold; ">Ergebnisse</th><td style=""> </td></tr><tr height=22><td style=""> </td><td style="font-size:12pt; background-color:#00ffff; text-align:right; font-weight:bold; font-style:italic; ">Saldo</td><th colspan="2" rowspan="1" style="font-size:12pt; background-color:#00ffff; text-align:center; font-weight:bold; ">3 </th><td style="font-size:9pt; text-align:center; font-weight:bold; "> </td><td style="font-size:12pt; text-align:right; font-weight:bold; font-style:italic; ">Max Plus-Stand:</td><td style="font-size:12pt; text-align:right; font-weight:bold; ">3</td><td style=""> </td></tr><tr height=22><td style=""> </td><td style="font-size:12pt; text-align:right; font-weight:bold; font-style:italic; ">Treffer Anzahl:</td><th colspan="2" rowspan="1" style="font-size:12pt; text-align:center; font-weight:bold; ">13</th><td style="font-size:9pt; text-align:center; font-weight:bold; "> </td><td style="font-size:12pt; text-align:right; font-weight:bold; font-style:italic; ">Max Minus-Stand:</td><td style="font-size:12pt; text-align:right; font-weight:bold; ">-3</td><td style=""> </td></tr><tr height=21><td style=""> </td><td style="font-size:12pt; text-align:right; font-weight:bold; font-style:italic; ">Nieten Anzahl:</td><th colspan="2" rowspan="1" style="font-size:12pt; text-align:center; font-weight:bold; ">2</th><td style="text-align:center; "> </td><td style="font-size:12pt; text-align:right; font-weight:bold; font-style:italic; ">Coups:</td><td style="font-size:12pt; text-align:right; font-weight:bold; font-style:italic; ">16</td><td style=""> </td></tr><tr height=34><td style=""> </td><td style="font-size:8pt; background-color:#ffff99; text-align:center; font-weight:bold; ">PERMANENZ</td><td style="font-size:8pt; background-color:#ffff99; text-align:center; font-weight:bold; ">Wh</td><td style="font-size:12pt; color:#ffffff; background-color:#000000; text-align:center; font-weight:bold; ">13</td><td style="font-size:12pt; color:#ffffff; background-color:#ff0000; text-align:center; font-weight:bold; ">2</td><td style="background-color:#ccffff; text-align:center; font-weight:bold; ">Saldo<br>total</td><td style="font-size:8pt; background-color:#ffff99; text-align:center; font-weight:bold; ">Hilfs-<br>spalte</td><td style=""> </td></tr><tr height=22><td style=""> </td><td style="font-size:8pt; background-color:#ffff99; text-align:center; ">hier einfügen</td><td style="font-size:8pt; background-color:#ffff99; text-align:center; font-weight:bold; "> TVs</td><td style="font-size:8pt; background-color:#ffff99; text-align:center; font-weight:bold; ">Treffer</td><td style="font-size:8pt; background-color:#ffff99; text-align:center; font-weight:bold; ">Nieten</td><td style="font-size:12pt; background-color:#ccffff; text-align:center; font-weight:bold; ">3</td><td style="font-size:8pt; background-color:#ffff99; text-align:center; font-weight:bold; ">TVs</td><td style=""> </td></tr><tr height=17><td style=""> </td><td style="text-align:center; ">33</td><td style="text-align:center; "> </td><td style=""> </td><td style="text-align:center; "> </td><td style="text-align:center; font-weight:bold; ">0</td><td style="font-family:Arial CE; color:#808080; text-align:center; ">6</td><td style=""> </td></tr><tr height=21><td style=""> </td><td style="text-align:center; ">23</td><td style="font-family:Arial CE; text-align:center; "> </td><td style="font-family:Arial CE; font-size:12pt; text-align:center; font-weight:bold; ">1</td><td style="font-size:12pt; text-align:center; font-weight:bold; "> </td><td style="font-size:12pt; text-align:center; font-weight:bold; ">1</td><td style="font-family:Arial CE; color:#808080; text-align:center; ">4</td><td style=""> </td></tr><tr height=21><td style=""> </td><td style="text-align:center; ">36</td><td style="font-family:Arial CE; text-align:center; "> </td><td style="font-family:Arial CE; font-size:12pt; text-align:center; font-weight:bold; ">1</td><td style="font-size:12pt; text-align:center; font-weight:bold; "> </td><td style="font-size:12pt; text-align:center; font-weight:bold; ">2</td><td style="font-family:Arial CE; color:#808080; text-align:center; ">6</td><td style=""> </td></tr><tr height=21><td style=""> </td><td style="text-align:center; ">28</td><td style="font-family:Arial CE; text-align:center; "> </td><td style="font-family:Arial CE; font-size:12pt; text-align:center; font-weight:bold; ">1</td><td style="font-size:12pt; text-align:center; font-weight:bold; "> </td><td style="font-size:12pt; text-align:center; font-weight:bold; ">3</td><td style="font-family:Arial CE; color:#808080; text-align:center; ">5</td><td style=""> </td></tr><tr height=21><td style=""> </td><td style="text-align:center; ">30</td><td style="font-family:Arial CE; color:#808080; text-align:center; ">1</td><td style="font-family:Arial CE; font-size:12pt; color:#808080; text-align:center; "> </td><td style="font-size:12pt; color:#ff0000; text-align:center; font-weight:bold; ">-5</td><td style="font-size:12pt; text-align:center; font-weight:bold; ">-2</td><td style="font-family:Arial CE; color:#808080; text-align:center; ">5</td><td style=""> </td></tr><tr height=21><td style=""> </td><td style="text-align:center; ">23</td><td style="font-family:Arial CE; text-align:center; "> </td><td style="font-family:Arial CE; font-size:12pt; text-align:center; font-weight:bold; ">1</td><td style="font-size:12pt; text-align:center; font-weight:bold; "> </td><td style="font-size:12pt; text-align:center; font-weight:bold; ">-1</td><td style="font-family:Arial CE; color:#808080; text-align:center; ">4</td><td style=""> </td></tr><tr height=21><td style=""> </td><td style="text-align:center; ">35</td><td style="font-family:Arial CE; text-align:center; "> </td><td style="font-family:Arial CE; font-size:12pt; text-align:center; font-weight:bold; ">1</td><td style="font-size:12pt; text-align:center; font-weight:bold; "> </td><td style="font-size:12pt; text-align:center; font-weight:bold; ">0</td><td style="font-family:Arial CE; color:#808080; text-align:center; ">6</td><td style=""> </td></tr><tr height=21><td style=""> </td><td style="text-align:center; ">13</td><td style="font-family:Arial CE; text-align:center; "> </td><td style="font-family:Arial CE; font-size:12pt; text-align:center; font-weight:bold; ">1</td><td style="font-size:12pt; text-align:center; font-weight:bold; "> </td><td style="font-size:12pt; text-align:center; font-weight:bold; ">1</td><td style="font-family:Arial CE; color:#808080; text-align:center; ">3</td><td style=""> </td></tr><tr height=21><td style=""> </td><td style="text-align:center; ">19</td><td style="font-family:Arial CE; text-align:center; "> </td><td style="font-family:Arial CE; font-size:12pt; text-align:center; font-weight:bold; ">1</td><td style="font-size:12pt; text-align:center; font-weight:bold; "> </td><td style="font-size:12pt; text-align:center; font-weight:bold; ">2</td><td style="font-family:Arial CE; color:#808080; text-align:center; ">4</td><td style=""> </td></tr><tr height=21><td style=""> </td><td style="text-align:center; ">24</td><td style="font-family:Arial CE; color:#808080; text-align:center; ">1</td><td style="font-family:Arial CE; font-size:12pt; color:#808080; text-align:center; "> </td><td style="font-size:12pt; color:#ff0000; text-align:center; font-weight:bold; ">-5</td><td style="font-size:12pt; text-align:center; font-weight:bold; ">-3</td><td style="font-family:Arial CE; color:#808080; text-align:center; ">4</td><td style=""> </td></tr><tr height=21><td style=""> </td><td style="text-align:center; ">1</td><td style="font-family:Arial CE; text-align:center; "> </td><td style="font-family:Arial CE; font-size:12pt; text-align:center; font-weight:bold; ">1</td><td style="font-size:12pt; text-align:center; font-weight:bold; "> </td><td style="font-size:12pt; text-align:center; font-weight:bold; ">-2</td><td style="font-family:Arial CE; color:#808080; text-align:center; ">1</td><td style=""> </td></tr><tr height=21><td style=""> </td><td style="text-align:center; ">11</td><td style="font-family:Arial CE; text-align:center; "> </td><td style="font-family:Arial CE; font-size:12pt; text-align:center; font-weight:bold; ">1</td><td style="font-size:12pt; text-align:center; font-weight:bold; "> </td><td style="font-size:12pt; text-align:center; font-weight:bold; ">-1</td><td style="font-family:Arial CE; color:#808080; text-align:center; ">2</td><td style=""> </td></tr><tr height=21><td style=""> </td><td style="text-align:center; ">28</td><td style="font-family:Arial CE; text-align:center; "> </td><td style="font-family:Arial CE; font-size:12pt; text-align:center; font-weight:bold; ">1</td><td style="font-size:12pt; text-align:center; font-weight:bold; "> </td><td style="font-size:12pt; text-align:center; font-weight:bold; ">0</td><td style="font-family:Arial CE; color:#808080; text-align:center; ">5</td><td style=""> </td></tr><tr height=21><td style=""> </td><td style="text-align:center; ">36</td><td style="font-family:Arial CE; text-align:center; "> </td><td style="font-family:Arial CE; font-size:12pt; text-align:center; font-weight:bold; ">1</td><td style="font-size:12pt; text-align:center; font-weight:bold; "> </td><td style="font-size:12pt; text-align:center; font-weight:bold; ">1</td><td style="font-family:Arial CE; color:#808080; text-align:center; ">6</td><td style=""> </td></tr><tr height=21><td style=""> </td><td style="text-align:center; ">14</td><td style="font-family:Arial CE; text-align:center; "> </td><td style="font-family:Arial CE; font-size:12pt; text-align:center; font-weight:bold; ">1</td><td style="font-size:12pt; text-align:center; font-weight:bold; "> </td><td style="font-size:12pt; text-align:center; font-weight:bold; ">2</td><td style="font-family:Arial CE; color:#808080; text-align:center; ">3</td><td style=""> </td></tr><tr height=21><td style=""> </td><td style="text-align:center; ">1</td><td style="font-family:Arial CE; text-align:center; "> </td><td style="font-family:Arial CE; font-size:12pt; text-align:center; font-weight:bold; ">1</td><td style="font-size:12pt; text-align:center; font-weight:bold; "> </td><td style="font-size:12pt; text-align:center; font-weight:bold; ">3</td><td style="font-family:Arial CE; color:#808080; text-align:center; ">1</td><td style=""> </td></tr><tr height=17><td style=""> </td><td style=""> </td><td style="text-align:center; "> </td><td style=""> </td><td style="text-align:center; "> </td><td style=""> </td><td style=""> </td><td style=""> </td></tr></table></td></tr><tr><td> </td></tr></tr></table> <span style="font-family:'Arial'; font-size:9pt;font-weight:bold; ">Diagramm - Grafik - Excel Tabellen einfach im Web darstellen <a style ="font-family:'Arial'; font-size:9pt; color:#FCF507; background-color:#1506F7; font-weight:bold;" href='http://www.haserodt.de/ejh_do/ex_jean_info.htm' target='blank'> Excel Jeanie HTML 3.0 Download </a></span><br>

die Datei hänge ich mal an

Gruß der Revanchist :anstoss:

Anhang entfernt, da überarbeitet jetzt im Beitragslink: #43 neu verfügbar - 23.04.07

bearbeitet April 23, 2007 von Revanchist

Monopolis · April 22, 2007

Moin Revanchist! Deine Ankündigung hatte ich gelesen; ich nehme solche Anregungen zum Anlass, meinen "Auswertungsfilm" zu vergrößern. ==> Das Benefiz-Turnier findet am 24.08.2007 auf der Anlage Gut Waldhof statt. Grüße, Monopolis.

<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="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /></colgroup><tr style="height:17px ;"><td > </td><td > </td><td style="font-weight:bold; font-size:8pt; ">TVS</td><td > </td><td > </td><td > </td><td style="font-weight:bold; font-size:8pt; ">30 ZAHLEN</td><td colspan="2" style="font-weight:bold; font-size:8pt; text-align:center; ">BIERSYSTEM</td></tr><tr style="height:17px ;"><td style="font-weight:bold; font-size:8pt; text-align:center; ">DATUM</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">TAG-NR.</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">SUMME</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">MAX</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">MIN</td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">SUMME</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">MAX</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">MIN</td></tr><tr style="height:17px ;"><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; "> </td></tr><tr style="height:17px ;"><td style="font-weight:bold; font-size:8pt; text-align:center; ">22.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">812</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">76</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">23</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-44</td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">89</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">65</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-16</td></tr><tr style="height:17px ;"><td style="font-weight:bold; font-size:8pt; text-align:center; ">21.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">811</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">91</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">65</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-10</td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">107</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">155</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-10</td></tr><tr style="height:17px ;"><td style="font-weight:bold; font-size:8pt; text-align:center; ">20.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">810</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">87</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">39</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-11</td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">97</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">88</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-6</td></tr><tr style="height:17px ;"><td style="font-weight:bold; font-size:8pt; text-align:center; ">19.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">809</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">74</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">26</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-55</td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">83</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">26</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-17</td></tr><tr style="height:17px ;"><td style="font-weight:bold; font-size:8pt; text-align:center; ">18.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">808</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">75</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-62</td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">85</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">25</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-8</td></tr><tr style="height:17px ;"><td style="font-weight:bold; font-size:8pt; text-align:center; ">17.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">807</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">87</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">51</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-18</td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">101</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">124</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-1</td></tr><tr style="height:17px ;"><td style="font-weight:bold; font-size:8pt; text-align:center; ">16.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">806</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">84</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">19</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-33</td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">93</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">62</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-14</td></tr><tr style="height:17px ;"><td style="font-weight:bold; font-size:8pt; text-align:center; ">15.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">805</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">84</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">21</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-24</td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">95</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">81</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-3</td></tr><tr style="height:17px ;"><td style="font-weight:bold; font-size:8pt; text-align:center; ">14.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">804</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">78</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">4</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-41</td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">89</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">65</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-16</td></tr><tr style="height:17px ;"><td style="font-weight:bold; font-size:8pt; text-align:center; ">13.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">803</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">72</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">8</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-93</td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">83</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">17</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-61</td></tr><tr style="height:17px ;"><td style="font-weight:bold; font-size:8pt; text-align:center; ">12.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">802</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">94</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">68</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-27</td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">108</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">152</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-9</td></tr><tr style="height:17px ;"><td style="font-weight:bold; font-size:8pt; text-align:center; ">11.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">801</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">70</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">9</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-79</td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">80</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">39</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-19</td></tr><tr style="height:17px ;"><td style="font-weight:bold; font-size:8pt; text-align:center; ">10.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">800</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">83</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">23</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-25</td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">95</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">77</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-12</td></tr><tr style="height:17px ;"><td style="font-weight:bold; font-size:8pt; text-align:center; ">09.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">799</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">72</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">2</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-75</td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">85</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">36</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-16</td></tr><tr style="height:17px ;"><td style="font-weight:bold; font-size:8pt; text-align:center; ">08.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">798</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">80</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">43</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-35</td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">92</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">73</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-1</td></tr><tr style="height:17px ;"><td style="font-weight:bold; font-size:8pt; text-align:center; ">07.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">797</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">71</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-1</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-93</td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">84</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">34</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-27</td></tr><tr style="height:17px ;"><td style="font-weight:bold; font-size:8pt; text-align:center; ">06.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">796</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">67</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">19</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-118</td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">86</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">25</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-45</td></tr><tr style="height:17px ;"><td style="font-weight:bold; font-size:8pt; text-align:center; ">05.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">795</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">65</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">9</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-122</td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">74</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">15</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-74</td></tr><tr style="height:17px ;"><td style="font-weight:bold; font-size:8pt; text-align:center; ">04.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">794</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">85</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">12</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-42</td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">103</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">120</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-7</td></tr><tr style="height:17px ;"><td style="font-weight:bold; font-size:8pt; text-align:center; ">03.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">793</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">68</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">8</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-100</td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">81</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">29</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-29</td></tr><tr style="height:17px ;"><td style="font-weight:bold; font-size:8pt; text-align:center; ">02.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">792</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">72</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">0</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-75</td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">81</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">24</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-21</td></tr><tr style="height:17px ;"><td style="font-weight:bold; font-size:8pt; text-align:center; ">01.04.2007</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">791</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">92</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">63</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-41</td><td style="font-weight:bold; font-size:8pt; "> </td><td style="font-weight:bold; font-size:8pt; text-align:center; ">104</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">127</td><td style="font-weight:bold; font-size:8pt; text-align:center; ">-32</td></tr></table>

Monopolis · April 22, 2007

Moin Bierfreund,

die Auswertung für die 22. Apriltage im CC (Tisch 1) zeigt, dass Du mit dieser

Strategie an einigen Tagen kaum ins Plus kommst.

Am 17.04.2007 hättest Du sicherlich nicht bei Bankminus 1 (= 1 Stück Plus für Dich)

aufgehört, sondern innerhalb der 500 Coups 124 Stücke verloren.

Der Satz auf Wiederholung einer TVS geht ebenfalls hin und wieder in die Hose.

Beispiele: 02.04.2007 und 07.04.2007 mit 0 bzw. 1 Plus. In dieser Liste ist der

Buchhalter ein Spieler, während beim Spiel auf 30 Zahlen der Buchhalter von

der Spielbankseite kommt.

Grüße, Monopolis.

NACHTRAG:

Leider peil ich diese Tabelle überhabt nicht...
Kann mir da jemand weiterhelfen.

SUMME = ANZAHL der Verluste

MAX = Höchster Kontostand während der 500 ausgewerteten Coups

MIN = Niedrigster Kontostand ....

Etwas ungewohnt ist die unterschiedliche Vorzeichenregelung für den, der keine

eigene Bank hat. :anstoss:

bearbeitet April 22, 2007 von Monopolis

Monopolis · April 22, 2007

Moin Revanchist! Das lob ich mir; da haste ja diesmal 'nen vollgetankten vorgefahren. Ich habe mir erlaubt, die Ladung vom 22.04.2007 einzupacken. Wollte prüfen, ob meine Ergebnisse stimmen. Bei dieser Gelegenheit habe ich Deine Formel in Zelle F4 leicht verändert, habe statt A504 A506 reingeschrieben, damit die Coupanzahl stimmt.

<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="width:103px;" /><col style="width:49px;" /><col style="width:46px;" /><col style="width:42px;" /><col style="width:115px;" /><col style="width:80px;" /></colgroup><tr style="height:21px ;"><td colspan="3" style="background-color:#ffcc99; font-weight:bold; text-align:center; ">Salden</td><td style="font-weight:bold; font-size:12pt; text-align:center; ">+</td><td colspan="2" style="background-color:#ffcc99; font-weight:bold; text-align:center; ">Ergebnisse</td></tr><tr style="height:22px ;"><td style="background-color:#00ffff; font-weight:bold; font-style:italic; font-size:12pt; text-align:right; ">Saldo</td><td colspan="2" style="background-color:#00ffff; font-weight:bold; font-size:12pt; text-align:center; ">-37 </td><td style="font-weight:bold; font-size:9pt; "> </td><td style="font-weight:bold; font-style:italic; font-size:12pt; text-align:right; ">Max Plus-Stand:</td><td style="font-weight:bold; font-size:12pt; text-align:right; ">16</td></tr><tr style="height:22px ;"><td style="font-weight:bold; font-style:italic; font-size:8pt; text-align:right; ">Treffer Anzahl:</td><td colspan="2" style="font-weight:bold; font-size:12pt; text-align:center; ">408</td><td style="font-weight:bold; font-size:9pt; "> </td><td style="font-weight:bold; font-style:italic; font-size:12pt; text-align:right; ">Max Minus-Stand:</td><td style="font-weight:bold; font-size:12pt; text-align:right; ">-65</td></tr><tr style="height:21px ;"><td style="font-weight:bold; font-style:italic; font-size:8pt; text-align:right; ">Nieten Anzahl:</td><td colspan="2" style="font-weight:bold; font-size:12pt; text-align:center; ">89</td><td > </td><td style="font-weight:bold; font-style:italic; font-size:12pt; text-align:right; ">Coups:</td><td style="font-weight:bold; font-style:italic; font-size:12pt; text-align:right; ">500</td></tr><tr style="height:34px ;"><td style="background-color:#ffff99; font-weight:bold; font-size:8pt; text-align:center; ">PERMANENZ</td><td style="background-color:#ffff99; font-weight:bold; font-size:8pt; text-align:center; ">Wh</td><td style="background-color:#000000; color:#ffffff; font-weight:bold; font-size:12pt; text-align:center; ">408</td><td style="background-color:#ff0000; color:#ffffff; font-weight:bold; font-size:12pt; text-align:center; ">89</td><td style="background-color:#ccffff; font-weight:bold; text-align:center; ">Saldo<br />total</td><td style="background-color:#ffff99; font-weight:bold; font-size:8pt; text-align:center; ">Hilfs-<br />spalte</td></tr><tr style="height:22px ;"><td style="background-color:#ffff99; font-size:8pt; text-align:center; ">hier einfügen</td><td style="background-color:#ffff99; font-weight:bold; font-size:8pt; text-align:center; "> TVs</td><td style="background-color:#ffff99; font-weight:bold; font-size:8pt; text-align:center; ">Treffer</td><td style="background-color:#ffff99; font-weight:bold; font-size:8pt; text-align:center; ">Nieten</td><td style="background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">-37</td><td style="background-color:#ffff99; font-weight:bold; font-size:8pt; text-align:center; ">TVs</td></tr><tr style="height:17px ;"><td style="text-align:center; ">6</td><td > </td><td > </td><td > </td><td style="font-weight:bold; text-align:center; ">0</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">1</td></tr><tr style="height:21px ;"><td style="text-align:center; ">12</td><td style="font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">1</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">2</td></tr><tr style="height:21px ;"><td style="text-align:center; ">34</td><td style="font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">2</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">6</td></tr><tr style="height:21px ;"><td style="text-align:center; ">16</td><td style="font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">3</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">3</td></tr><tr style="height:21px ;"><td style="text-align:center; ">27</td><td style="font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">4</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">5</td></tr><tr style="height:21px ;"><td style="text-align:center; ">31</td><td style="font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">5</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">6</td></tr><tr style="height:21px ;"><td style="text-align:center; ">20</td><td style="font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">6</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">4</td></tr><tr style="height:21px ;"><td style="text-align:center; ">1</td><td style="font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">7</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">1</td></tr><tr style="height:21px ;"><td style="text-align:center; ">33</td><td style="font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">8</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">6</td></tr><tr style="height:21px ;"><td style="text-align:center; ">34</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">1</td><td style="color:#808080; font-family:Arial CE; font-size:12pt; "> </td><td style="color:#ff0000; font-weight:bold; font-size:12pt; text-align:center; ">-5</td><td style="font-weight:bold; font-size:12pt; text-align:center; ">3</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">6</td></tr><tr style="height:21px ;"><td style="text-align:center; ">16</td><td style="font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">4</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">3</td></tr><tr style="height:21px ;"><td style="text-align:center; ">21</td><td style="font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">5</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">4</td></tr><tr style="height:21px ;"><td style="text-align:center; ">36</td><td style="font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">6</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">6</td></tr><tr style="height:21px ;"><td style="text-align:center; ">18</td><td style="font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">7</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">3</td></tr><tr style="height:21px ;"><td style="text-align:center; ">32</td><td style="font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">8</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">6</td></tr><tr style="height:21px ;"><td style="text-align:center; ">9</td><td style="font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">9</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">2</td></tr><tr style="height:21px ;"><td style="text-align:center; ">9</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">1</td><td style="color:#808080; font-family:Arial CE; font-size:12pt; "> </td><td style="color:#ff0000; font-weight:bold; font-size:12pt; text-align:center; ">-5</td><td style="font-weight:bold; font-size:12pt; text-align:center; ">4</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">2</td></tr><tr style="height:21px ;"><td style="text-align:center; ">11</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">1</td><td style="color:#808080; font-family:Arial CE; font-size:12pt; "> </td><td style="color:#ff0000; font-weight:bold; font-size:12pt; text-align:center; ">-5</td><td style="font-weight:bold; font-size:12pt; text-align:center; ">-1</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">2</td></tr><tr style="height:21px ;"><td style="text-align:center; ">32</td><td style="color:#808080; font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">0</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">6</td></tr><tr style="height:21px ;"><td style="text-align:center; ">10</td><td style="color:#808080; font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">1</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">2</td></tr><tr style="height:21px ;"><td style="text-align:center; ">27</td><td style="color:#808080; font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">2</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">5</td></tr><tr style="height:21px ;"><td style="text-align:center; ">13</td><td style="color:#808080; font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">3</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">3</td></tr><tr style="height:21px ;"><td style="text-align:center; ">30</td><td style="color:#808080; font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">4</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">5</td></tr><tr style="height:21px ;"><td style="text-align:center; ">24</td><td style="color:#808080; font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">5</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">4</td></tr><tr style="height:21px ;"><td style="text-align:center; ">14</td><td style="color:#808080; font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">6</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">3</td></tr><tr style="height:21px ;"><td style="text-align:center; ">9</td><td style="color:#808080; font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">7</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">2</td></tr><tr style="height:21px ;"><td style="text-align:center; ">6</td><td style="color:#808080; font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">8</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">1</td></tr><tr style="height:21px ;"><td style="text-align:center; ">0</td><td style="color:#808080; font-family:Arial CE; "> </td><td style="color:#808080; font-family:Arial CE; font-size:12pt; "> </td><td style="color:#ff0000; font-weight:bold; font-size:12pt; text-align:center; ">-5</td><td style="font-weight:bold; font-size:12pt; text-align:center; ">3</td><td style="color:#ffffff; background-color:#008000; font-weight:bold; font-family:Arial CE; text-align:center; ">0</td></tr><tr style="height:21px ;"><td style="text-align:center; ">22</td><td style="color:#ffffff; font-weight:bold; font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">4</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">4</td></tr><tr style="height:21px ;"><td style="text-align:center; ">7</td><td style="color:#808080; font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">5</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">2</td></tr><tr style="height:21px ;"><td style="text-align:center; ">5</td><td style="color:#808080; font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">6</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">1</td></tr><tr style="height:21px ;"><td style="text-align:center; ">3</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">1</td><td style="color:#808080; font-family:Arial CE; font-size:12pt; "> </td><td style="color:#ff0000; font-weight:bold; font-size:12pt; text-align:center; ">-5</td><td style="font-weight:bold; font-size:12pt; text-align:center; ">1</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">1</td></tr><tr style="height:21px ;"><td style="text-align:center; ">35</td><td style="color:#808080; font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">2</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">6</td></tr><tr style="height:21px ;"><td style="text-align:center; ">21</td><td style="color:#808080; font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">3</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">4</td></tr></table>

Monopolis · April 22, 2007

Es folgt die ausgefüllte Revanchist-Tabelle mit der CC-PERM vom 22.04.2007:

REVA_BIER.zip

Bierfreund · April 22, 2007

Hi Jungs,

danke für eure Mühe, genau das was ich gesucht habe...

Allerdings habe ich noch ein Kleines Problem.

Um möglichst schnell fiele zahlen auszuwerten sollte man sie nicht in xls. Schreiben, sonder sie sollten kopiert und reingefügt werde.

Da aber so ziemlich alle Spielbanken in Ihren Zahlen, beim Courpie-wecksel eine ----

Stehen habe erscheint bei dieser Formel auch eine 1 bei ----.

Das darf aber nicht sein, denn das verfälscht ja das Ergebnis.

Vielmehr müsste bei beim Courpie-wecksel (also----) ein leeres Feld erscheinen.

Um es euch zu zeigen lade ich eure Datei mal mit Originalzahlen aus HH hoch.

Kann man da noch was dran machen, à sprich wenn ---- erscheint soll die Auswertungszeile leer sein.

Danke und Gruß

Bierfreund · April 22, 2007

wie ich sehe ist mir dass hochladen der Datei nicht gelungen...

sorry

denke aber ihr wist was ich mein...

Monopolis · April 22, 2007

Moin Bierfreund,

Um möglichst schnell fiele zahlen auszuwerten sollte man sie nicht in xls.
Schreiben, sonder sie sollten kopiert und reingefügt werde.

solche Entscheidungen solltest Du Fachleuten überlassen. :rofl2:

Ich habe 1.000 Tage = 500.000 Coups auf einem EXCEL-Blatt und lasse die Auswertungen

wie im Film durchlaufen; dies für alle gängigen Strategien, die Erfolg versprechen.

Wenn Dich die Handwechsel stören, musst Du diese rausschmeißen. Dies läuft

über Filtern.

Aber vielleicht baut Revanchist einen Schleudersitz in seinen Rennwagen, der

ausgelöst wird, wenn erkennbar ist, dass man nicht am Baum vorbei kommt. :flop9:

Grüße, Monopolis. :anstoss:

Monopolis · April 22, 2007

wie ich sehe ist mir dass hochladen der Datei nicht gelungen...
sorry
denke aber ihr wist was ich mein...
←

Ist wohl in Wenkes Sandfang hängen geblieben. :anstoss:

Bierfreund · April 22, 2007

Hi Monopolis,

das letzte mit Winke habe ich leider nicht verstanden...

Dein Tipp aber mit dem Autofilter ist nicht schlecht, danke.

Wenn mann aber mitlerweile 98% der Förmel aufgebaut hat und diese meine Erwartungen sogar übertreffen, dann sollte es doch für euch kein Problem sein den Handwechsel als lehres Feld zu bauen...

Danke und Gruß

PS. ich bin hartnäckig.

Revanchist · April 22, 2007

dann sollte es doch für euch kein Problem sein den Handwechsel als lehres Feld zu bauen...
←

Hallo Bierfreund

streng mal deine grauen Zellen etwas an.

Wenn du die Zellen mit --- in einer anderen Zelle als Leerzelle haben willst, musst du nur eine Zusatzanfrage mit einbauen.

So vielleicht: WENN(A47="---";"";WENN(.....

Oder als Nullnummer ist besser für die Aufsaldierung.

Wenn du es nicht gebacken bekommst, morgen später Nachmttg habe ich wieder etwas Luft.

Aber das kriegst du schon hin, wenn du an die Moneten willst.

Unter uns gesagt, mit dieser Strategie ist leider kein Blumentopf zu gewinnen, auch kein kleiner. Sorry

Ciao der Revanchist :anstoss:

Bierfreund · April 22, 2007

Hi Revanchist,

danke für deinen Tip mit der Blume...

An die Moneten möchte ich schon ran, aber ich warte gerne bis du etwas Zeit für mich hast...

Leider bekomme ich dies selber nicht hin...

würde mich also freuen wenn du bei gelegenheit denn Handwechsel auch noch mit einbaust...

Danke und Gruß

Monopolis · April 22, 2007

Moin Bierfreund,

Hi Monopolis,
das letzte mit Winke habe ich leider nicht verstanden...

was hast Du denn nicht verstanden? Kennst Du Wenke nicht oder weißt Du nicht,

was ein Sandfang ist?

1.) Wenke ist der Mensch, der das Klärwerk leitet. :flop9:

2.) Die groben Sachen landen im Grobrechen, die schweren im Sandfang

(so ein Ding hast Du auch in Deiner Aco-Drain-Rinne vor dem Garagentor),

der Rest geht dann in die Klärbecken (Absetz- / biologisches Becken) und landet

dann irgendwann im Faulturm.

Aus dem Faulschlamm werden dann später Zocker wie A..... gebacken! :flop9:

Grüße, Monopolis. :anstoss:

bearbeitet April 23, 2007 von Monopolis

Monopolis · April 23, 2007

Die letzte "Biernacht" im CC (23.04.2007):

<b>Tabelle1</b><br /><br /><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="width:30px; " /><col style="width:103px;" /><col style="width:49px;" /><col style="width:46px;" /><col style="width:42px;" /><col style="width:115px;" /><col style="width:80px;" /></colgroup><tr style="background-color:#cacaca; text-align:center;font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td><td >F</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td colspan="3" style="background-color:#ffcc99; font-weight:bold; text-align:center; ">Salden</td><td style="font-weight:bold; font-size:12pt; text-align:center; ">+</td><td colspan="2" style="background-color:#ffcc99; font-weight:bold; text-align:center; ">Ergebnisse</td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="background-color:#00ffff; font-weight:bold; font-style:italic; font-size:12pt; text-align:right; ">Saldo</td><td colspan="2" style="background-color:#00ffff; font-weight:bold; font-size:12pt; text-align:center; ">-91 </td><td style="font-weight:bold; font-size:9pt; "> </td><td style="font-weight:bold; font-style:italic; font-size:12pt; text-align:right; ">Max Plus-Stand:</td><td style="font-weight:bold; font-size:12pt; text-align:right; ">2</td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="font-weight:bold; font-style:italic; text-align:left; ">Treffer Anzahl:</td><td colspan="2" style="font-weight:bold; font-size:12pt; text-align:center; ">399</td><td style="font-weight:bold; font-size:9pt; "> </td><td style="font-weight:bold; font-style:italic; font-size:12pt; text-align:right; ">Max Minus-Stand:</td><td style="font-weight:bold; font-size:12pt; text-align:right; ">-99</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="font-weight:bold; font-style:italic; text-align:left; ">Nieten Anzahl:</td><td colspan="2" style="font-weight:bold; font-size:12pt; text-align:center; ">98</td><td > </td><td style="font-weight:bold; font-style:italic; font-size:12pt; text-align:right; ">Coups:</td><td style="font-weight:bold; font-style:italic; font-size:12pt; text-align:right; ">498</td></tr><tr style="height:34px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="background-color:#ffff99; font-weight:bold; font-size:8pt; text-align:center; ">PERMANENZ</td><td style="background-color:#ffff99; font-weight:bold; font-size:8pt; text-align:center; ">Wh</td><td style="background-color:#000000; color:#ffffff; font-weight:bold; font-size:12pt; text-align:center; ">399</td><td style="background-color:#ff0000; color:#ffffff; font-weight:bold; font-size:12pt; text-align:center; ">98</td><td style="background-color:#ccffff; font-weight:bold; text-align:center; ">Saldo<br />total</td><td style="background-color:#ffff99; font-weight:bold; font-size:8pt; text-align:center; ">Hilfs-<br />spalte</td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="background-color:#ffff99; font-size:8pt; text-align:center; ">hier einfügen</td><td style="background-color:#ffff99; font-weight:bold; font-size:8pt; text-align:center; "> TVs</td><td style="background-color:#ffff99; font-weight:bold; font-size:8pt; text-align:center; ">Treffer</td><td style="background-color:#ffff99; font-weight:bold; font-size:8pt; text-align:center; ">Nieten</td><td style="background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">-91</td><td style="background-color:#ffff99; font-weight:bold; font-size:8pt; text-align:center; ">TVs</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="text-align:right; ">15</td><td > </td><td > </td><td > </td><td style="font-weight:bold; text-align:center; ">0</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">3</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="text-align:right; ">29</td><td style="font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">1</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">5</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="color:#ffffff; background-color:#339966; font-weight:bold; text-align:right; ">0</td><td style="color:#ffffff; font-weight:bold; font-family:Arial CE; "> </td><td style="color:#ffffff; font-weight:bold; font-family:Arial CE; font-size:12pt; "> </td><td style="color:#ff0000; font-weight:bold; font-size:12pt; text-align:center; ">-5</td><td style="font-weight:bold; font-size:12pt; text-align:center; ">-4</td><td style="color:#ffffff; background-color:#008000; font-weight:bold; font-family:Arial CE; text-align:center; ">0</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="text-align:right; ">4</td><td style="font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">-3</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">1</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="text-align:right; ">33</td><td style="font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">-2</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">6</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="text-align:right; ">25</td><td style="font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">-1</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">5</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td style="text-align:right; ">29</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">1</td><td style="color:#808080; font-family:Arial CE; font-size:12pt; "> </td><td style="color:#ff0000; font-weight:bold; font-size:12pt; text-align:center; ">-5</td><td style="font-weight:bold; font-size:12pt; text-align:center; ">-6</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">5</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td style="color:#ffffff; background-color:#339966; font-weight:bold; text-align:right; ">0</td><td style="color:#ffffff; font-weight:bold; font-family:Arial CE; "> </td><td style="color:#ffffff; font-weight:bold; font-family:Arial CE; font-size:12pt; "> </td><td style="color:#ff0000; font-weight:bold; font-size:12pt; text-align:center; ">-5</td><td style="font-weight:bold; font-size:12pt; text-align:center; ">-11</td><td style="color:#ffffff; background-color:#008000; font-weight:bold; font-family:Arial CE; text-align:center; ">0</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td style="text-align:right; ">32</td><td style="font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">-10</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">6</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td style="text-align:right; ">8</td><td style="font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">-9</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">2</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td style="text-align:right; ">29</td><td style="font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">-8</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">5</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td style="text-align:right; ">32</td><td style="font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">-7</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">6</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >19</td><td style="text-align:right; ">10</td><td style="font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">-6</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">2</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >20</td><td style="text-align:right; ">8</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">1</td><td style="color:#808080; font-family:Arial CE; font-size:12pt; "> </td><td style="color:#ff0000; font-weight:bold; font-size:12pt; text-align:center; ">-5</td><td style="font-weight:bold; font-size:12pt; text-align:center; ">-11</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">2</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >21</td><td style="text-align:right; ">30</td><td style="font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">-10</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">5</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >22</td><td style="text-align:right; ">30</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">1</td><td style="color:#808080; font-family:Arial CE; font-size:12pt; "> </td><td style="color:#ff0000; font-weight:bold; font-size:12pt; text-align:center; ">-5</td><td style="font-weight:bold; font-size:12pt; text-align:center; ">-15</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">5</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >23</td><td style="text-align:right; ">35</td><td style="font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">-14</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">6</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >24</td><td style="text-align:right; ">33</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">1</td><td style="color:#808080; font-family:Arial CE; font-size:12pt; "> </td><td style="color:#ff0000; font-weight:bold; font-size:12pt; text-align:center; ">-5</td><td style="font-weight:bold; font-size:12pt; text-align:center; ">-19</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">6</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >25</td><td style="text-align:right; ">7</td><td style="color:#808080; font-family:Arial CE; "> </td><td style="font-weight:bold; font-family:Arial CE; font-size:12pt; text-align:center; ">1</td><td style="font-weight:bold; font-size:12pt; "> </td><td style="font-weight:bold; font-size:12pt; text-align:center; ">-18</td><td style="color:#808080; font-family:Arial CE; text-align:center; ">2</td></tr></table> <br /><br /><span style="font-family:Arial; font-size:9pt; font-weight:bold;background-color:#ffffff; color:#000000; ">Excel Tabellen im Web darstellen >> </span><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>

Revanchist · April 23, 2007

Leider bekomme ich dies selber nicht hin...
würde mich also freuen wenn du bei gelegenheit denn Handwechsel auch noch mit einbaust...
←

Hallo Bierfreund

die Handwechselberücksichtigung habe ich dir eingebaut.

Bitte unbedingt in Zelle B5 die je nach Casino unterschiedliche Darstellungsform

für den Handwechsel überprüfen und gegebenenfalls anpassen.

Da Dortmund und Wiesbaden die gleichen -- -- -- verwenden, habe ich die einmal als Basis eingebaut.

Sonst ist fast alles beim alten geblieben (Monopolis hat noch den Hinweis auf die Korrektur der "Letztzelle"

gegeben, die jetzt auch wieder stimmt, so dass die Formeln 500 Coups [ohne Handwechsel gerechnet] berücksichtigen.

Bei Bedarf kannst du natürlich auch alles anpassen bis auf über 1.048.500 Zeilen (im neuen Excel 2007).

Ciao der Revanchist :anstoss:

f_r_Bierfreund_Forumbeitrag.zip

Bierfreund · April 23, 2007

Hi Revanchist,

ich möchte mich bei Dir für die Mühe bedanken.

:flop9: :rofl2:

Wie anfänglich beschrieben, bin ich neu in diesem Forum.

Ein neuer Zocker bin ich aber nicht.

Ich habe 5 Jahren in der Spielbank Hittfeld gearbeitet, und kenne das Geschäft eigentlich recht gut.

In diesem Forum werde ich sicherlich noch einige male posten...

Ich würde mich freuen wenn ich mich bei dir Revanchist mal REVANGIEREN könnte.

Danke und alles gute

Bierfreund

Ps. Übrigens trinke ich gerne Hefe, bin zwar aus dem Norden aber auch da gibt es auch sowas... :anstoss:

Revanchist · April 23, 2007

Hallo Bierfreund

kein Problem - gern geschehen.

Bis demnächst in diesem Haus

Ciao der Revanchist......... und nicht unterkriegen lassen.......... :anstoss:

Silhana · April 26, 2007

Ich bin auch ziemlich neu hier im Forum.

Eine Frage zu Euren sehr guten Beiträgen. Kann ich mein System hier auch darstellen und von Euch beurteilen lassen bzw. sogar dafür eine Programmierung erhalten? Es beruht auf Einfache Chancen, wo ich eine amerikanische Abstreichprogression anwende. Die mühsamen überprüfungen per Hand meiner Permanenzen sind doch sehr Zeitaufwendig. Ich würd gern mehr posten, wenn Ihr mir helfen könnt, wovon ich überzugt bin. Natürlich muss ich mir dann auch diese Sprüche, das ich langfristig verlieren werde anhören. Schaun wir mal, was raus kommt. Vorab vielen Dank

Wenke · April 26, 2007

Hallo Silhana,

Natürlich muss ich mir dann auch diese Sprüche, das ich langfristig verlieren werde anhören.

Mach dir nichts draus. Diese blöden Sprüche stammen meist von usern die sonst nix drauf haben.

Fühlt man denen, mit ihren angelesenen "Aller-Welt - Weißheiten" auf den Zahn, dann müssen sie (meist) schnell passen.

Kann ich mein System hier auch darstellen und von Euch beurteilen lassen bzw. sogar dafür eine Programmierung erhalten? Es beruht auf Einfache Chancen, wo ich eine amerikanische Abstreichprogression anwende.

Sicher kannst du das. :bye1:

Beschreib einfach mal dein Spiel, den Quatsch mit +/- x% lass gleich weg, das ließt so wie so keiner. :bye1:

Mit Sicherheit wird es jemanden geben, der dir dann helfen wird.

Wichtig zur Beurteilung wären:

mit welchen Startzahlen begonnen wird
wann welche Chance gesetzt wird
was beim erscheinen der Zero passiert
die Abbruchbedingungen ( wie lange ein Angriff gespielt wird.)

Für den Fall der Fälle:

amerikanische Abstreichprogression = Labby mit Startfolge 1-1

das wurde schon von mir programmiert.

Nur den Link müsste ich noch suchen. :bye1:

Hier kannst du noch etwas über die Labby nachlesen:

Labby

Labbyvarianten im Quasi Realspiel

Optimierung der Labouchere

Das sollte erst einmal reichen.

Beste Grüße

Wenke :bigsmile:

Anmelden

Mein System

Recommended Posts

Monopolis

Monopolis

Monopolis

Revanchist

Monopolis

Monopolis

Monopolis

Monopolis

Bierfreund

Bierfreund

Monopolis

Monopolis

Bierfreund

Revanchist

Bierfreund

Monopolis

Monopolis

Revanchist

Bierfreund

Revanchist

Silhana

Wenke

Erstelle ein Benutzerkonto oder melde dich an, um zu kommentieren

Benutzerkonto erstellen

Anmelden

Umsehen

Aktivitäten