Club:Fairplay/statisches/test: Unterschied zwischen den Versionen

Aus chessmail Wiki
Wechseln zu: Navigation, Suche
K
K
 
(43 dazwischenliegende Versionen von einem Benutzer werden nicht angezeigt)
Zeile 1: Zeile 1:
−
{|
+
{{#CSS:
−
|| *gegner* || *anzg* || *pts* || *quoti*
+
thead tr {background-color: ActiveCaption; color: CaptionText;}
−
|-
+
      th, td {vertical-align: top; font-family: "Tahoma", Arial, Helvetica, sans-serif; font-size: 8pt; padding: 3px; }
−
|| zifnab || 34 || 26.5 || 77.9  
+
      table, td {border: 1px solid silver;}
−
|-
+
      table {border-collapse: collapse;}
−
|| h2m2 || 36 || 26.5 || 73.6 ||
+
      thead .col0 {width: 156px;}
−
|| alms || 34 || 23.5 || 69.1 ||
+
.theadcol0 {width: 150px; color: navy; text-align: left;}
−
|| Priwet || 8 || 5.5 || 68.8 ||
+
.theadcol1 {width: 050px;}
−
|| Chessking22 || 6 || 4.0 || 66.7 ||
+
.theadcol2 {width: 050px;}
−
|| nathanDERweise || 26 || 17.0 || 65.4 ||
+
.theadcol3 {width: 100px;}
−
|| Boeschinski || 4 || 2.5 || 62.5 ||
+
.theadcol4 {width: 050px;}
−
|| Diebfaenger || 18 || 10.5 || 58.3 ||
+
.col1 {text-align: right;}
−
|| petraK || 40 || 22.0 || 55.0 ||
+
.col2 {text-align: right;}
−
|| bumm || 26 || 14.0 || 53.8 ||
+
.col3 {text-align: right;}
−
|| Lanja || 8 || 4.0 || 50.0 ||
+
.col4 {text-align: right;}
−
|| Noel.S || 4 || 2.0 || 50.0 ||
+
}}
−
|| mira2407 || 40 || 19.0 || 47.5 ||
+
----
−
|| Quarkbeutel || 26 || 12.0 || 46.2 ||
+
<pre>
−
|| Etez || 26 || 12.0 || 46.2 ||
+
count(gegner) as anzg,
−
|| SG1951SON || 20 || 9.0 || 45.0 ||
+
round(sum(ergebnisS)/2,1) as pts,
−
|| DJ_Baheiz || 16 || 7.0 || 43.8 ||
+
round(count(TurnierNr)/2,1) as anzTurniere,
−
|| Klaus1998 || 6 || 2.0 || 33.3 ||
+
round(100*round(sum(ergebnisS)/2/count(gegner),3),1) as quoti
−
|| kani || 12 || 3.5 || 29.2 ||
+
from partien
−
|| Lukas93 || 3 || 0.0 || 0.0 ||
+
group by gegner
−
|| pyroman97 || 2 || 0.0 || 0.0 ||
+
order by quoti desc, anzg desc, pts desc;
−
|}
+
</pre>
 +
----   
 +
<table caption="partien (21 rows)" class="wikitable sortable">
 +
<tr>
 +
          <td class="theadcol0">gegner</td>
 +
          <td class="theadcol1">anzg</td>
 +
          <td class="theadcol2">pts</td>
 +
          <td class="theadcol3">anzTurniere</td>
 +
          <td class="theadcol4">quoti</td>
 +
</tr>
 +
<tr>
 +
          <td class="col0">zifnab</td>
 +
          <td class="col1">34</td>
 +
          <td class="col2">26,5</td>
 +
          <td class="col3">17,0</td>
 +
          <td class="col4">77,9</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">h2m2</td>
 +
          <td class="col1">36</td>
 +
          <td class="col2">26,5</td>
 +
          <td class="col3">18,0</td>
 +
          <td class="col4">73,6</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">alms</td>
 +
          <td class="col1">34</td>
 +
          <td class="col2">23,5</td>
 +
          <td class="col3">17,0</td>
 +
          <td class="col4">69,1</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">Priwet</td>
 +
          <td class="col1">8</td>
 +
          <td class="col2">5,5</td>
 +
          <td class="col3">4,0</td>
 +
          <td class="col4">68,8</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">Chessking22</td>
 +
          <td class="col1">6</td>
 +
          <td class="col2">4,0</td>
 +
          <td class="col3">3,0</td>
 +
          <td class="col4">66,7</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">nathanDERweise</td>
 +
          <td class="col1">26</td>
 +
          <td class="col2">17,0</td>
 +
          <td class="col3">13,0</td>
 +
          <td class="col4">65,4</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">Boeschinski</td>
 +
          <td class="col1">4</td>
 +
          <td class="col2">2,5</td>
 +
          <td class="col3">2,0</td>
 +
          <td class="col4">62,5</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">Diebfaenger</td>
 +
          <td class="col1">18</td>
 +
          <td class="col2">10,5</td>
 +
          <td class="col3">9,0</td>
 +
          <td class="col4">58,3</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">petraK</td>
 +
          <td class="col1">40</td>
 +
          <td class="col2">22,0</td>
 +
          <td class="col3">20,0</td>
 +
          <td class="col4">55,0</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">bumm</td>
 +
          <td class="col1">26</td>
 +
          <td class="col2">14,0</td>
 +
          <td class="col3">13,0</td>
 +
          <td class="col4">53,8</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">Lanja</td>
 +
          <td class="col1">8</td>
 +
          <td class="col2">4,0</td>
 +
          <td class="col3">4,0</td>
 +
          <td class="col4">50,0</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">Noel.S</td>
 +
          <td class="col1">4</td>
 +
          <td class="col2">2,0</td>
 +
          <td class="col3">2,0</td>
 +
          <td class="col4">50,0</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">mira2407</td>
 +
          <td class="col1">40</td>
 +
          <td class="col2">19,0</td>
 +
          <td class="col3">20,0</td>
 +
          <td class="col4">47,5</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">Quarkbeutel</td>
 +
          <td class="col1">26</td>
 +
          <td class="col2">12,0</td>
 +
          <td class="col3">13,0</td>
 +
          <td class="col4">46,2</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">Etez</td>
 +
          <td class="col1">26</td>
 +
          <td class="col2">12,0</td>
 +
          <td class="col3">13,0</td>
 +
          <td class="col4">46,2</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">SG1951SON</td>
 +
          <td class="col1">20</td>
 +
          <td class="col2">9,0</td>
 +
          <td class="col3">10,0</td>
 +
          <td class="col4">45,0</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">DJ_Baheiz</td>
 +
          <td class="col1">16</td>
 +
          <td class="col2">7,0</td>
 +
          <td class="col3">8,0</td>
 +
          <td class="col4">43,8</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">Klaus1998</td>
 +
          <td class="col1">6</td>
 +
          <td class="col2">2,0</td>
 +
          <td class="col3">3,0</td>
 +
          <td class="col4">33,3</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">kani</td>
 +
          <td class="col1">12</td>
 +
          <td class="col2">3,5</td>
 +
          <td class="col3">6,0</td>
 +
          <td class="col4">29,2</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">Lukas93</td>
 +
          <td class="col1">3</td>
 +
          <td class="col2">0,0</td>
 +
          <td class="col3">1,5</td>
 +
          <td class="col4">0,0</td>
 +
        </tr>
 +
        <tr>
 +
          <td class="col0">pyroman97</td>
 +
          <td class="col1">2</td>
 +
          <td class="col2">0,0</td>
 +
          <td class="col3">1,0</td>
 +
          <td class="col4">0,0</td>
 +
        </tr>
 +
</table>

Aktuelle Version vom 21. Juni 2013, 21:54 Uhr

{{#CSS: thead tr {background-color: ActiveCaption; color: CaptionText;} 

     th, td {vertical-align: top; font-family: "Tahoma", Arial, Helvetica, sans-serif; font-size: 8pt; padding: 3px; }
     table, td {border: 1px solid silver;}
     table {border-collapse: collapse;}
     thead .col0 {width: 156px;}

.theadcol0 {width: 150px; color: navy; text-align: left;} .theadcol1 {width: 050px;} .theadcol2 {width: 050px;} .theadcol3 {width: 100px;} .theadcol4 {width: 050px;} .col1 {text-align: right;} .col2 {text-align: right;} .col3 {text-align: right;} .col4 {text-align: right;} }} 

count(gegner) as anzg,
round(sum(ergebnisS)/2,1) as pts, 
round(count(TurnierNr)/2,1) as anzTurniere,
round(100*round(sum(ergebnisS)/2/count(gegner),3),1) as quoti
from partien 
group by gegner 
order by quoti desc, anzg desc, pts desc;
gegner anzg pts anzTurniere quoti
zifnab 34 26,5 17,0 77,9
h2m2 36 26,5 18,0 73,6
alms 34 23,5 17,0 69,1
Priwet 8 5,5 4,0 68,8
Chessking22 6 4,0 3,0 66,7
nathanDERweise 26 17,0 13,0 65,4
Boeschinski 4 2,5 2,0 62,5
Diebfaenger 18 10,5 9,0 58,3
petraK 40 22,0 20,0 55,0
bumm 26 14,0 13,0 53,8
Lanja 8 4,0 4,0 50,0
Noel.S 4 2,0 2,0 50,0
mira2407 40 19,0 20,0 47,5
Quarkbeutel 26 12,0 13,0 46,2
Etez 26 12,0 13,0 46,2
SG1951SON 20 9,0 10,0 45,0
DJ_Baheiz 16 7,0 8,0 43,8
Klaus1998 6 2,0 3,0 33,3
kani 12 3,5 6,0 29,2
Lukas93 3 0,0 1,5 0,0
pyroman97 2 0,0 1,0 0,0
Von „https://chessmail.info/cmwiki/index.php?title=Club:Fairplay/statisches/test&oldid=94245“
Meine Werkzeuge
Namensräume

Varianten
Aktionen
chessmail Wiki
Schachserver
Informationen
Werkzeuge