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

Aus chessmail Wiki @novasign.ch
Zur Navigation springen Zur Suche springen
K
K
 
(34 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt)
Zeile 1: Zeile 1:
−
{| class="wikitable sortable"
+
{{#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;}
−
|-
+
.theadcol0 {width: 150px; color: navy; text-align: left;}
−
|| alms || 34 || 23.5 || 69.1
+
.theadcol1 {width: 050px;}
−
|-
+
.theadcol2 {width: 050px;}
−
|| Priwet || 8 || 5.5 || 68.8
+
.theadcol3 {width: 100px;}
−
|-
+
.theadcol4 {width: 050px;}
−
|| Chessking22 || 6 || 4.0 || 66.7
+
.col1 {text-align: right;}
−
|-
+
.col2 {text-align: right;}
−
|| nathanDERweise || 26 || 17.0 || 65.4
+
.col3 {text-align: right;}
−
|-
+
.col4 {text-align: right;}
−
|| Boeschinski || 4 || 2.5 || 62.5
+
}}
−
|-
 
−
|| Diebfaenger || 18 || 10.5 || 58.3
 
−
|-
 
−
|| petraK || 40 || 22.0 || 55.0
 
−
|-
 
−
|| bumm || 26 || 14.0 || 53.8
 
−
|-
 
−
|| Lanja || 8 || 4.0 || 50.0 ||
 
−
|| Noel.S || 4 || 2.0 || 50.0 ||
 
−
|| mira2407 || 40 || 19.0 || 47.5 ||
 
−
|| Quarkbeutel || 26 || 12.0 || 46.2 ||
 
−
|| Etez || 26 || 12.0 || 46.2 ||
 
−
|| SG1951SON || 20 || 9.0 || 45.0 ||
 
−
|| DJ_Baheiz || 16 || 7.0 || 43.8 ||
 
−
|| Klaus1998 || 6 || 2.0 || 33.3 ||
 
−
|| kani || 12 || 3.5 || 29.2 ||
 
−
|| Lukas93 || 3 || 0.0 || 0.0 ||
 
−
|| pyroman97 || 2 || 0.0 || 0.0 ||
 
−
|}
 
 
----
 
----
−
<p style="font-family: monospace; white-space: pre;">select gegner,
+
<pre>
 
count(gegner) as anzg,
 
count(gegner) as anzg,
 
round(sum(ergebnisS)/2,1) as pts,  
 
round(sum(ergebnisS)/2,1) as pts,  
Zeile 42: Zeile 23:
 
from partien  
 
from partien  
 
group by gegner  
 
group by gegner  
−
order by quoti desc, anzg desc, pts desc;</p>
+
order by quoti desc, anzg desc, pts desc;
−
 
+
</pre>
−
    <table caption="partien (21 rows)">
+
----   
−
      <thead>
+
<table caption="partien (21 rows)" class="wikitable sortable">
−
        <tr>
+
<tr>
−
           <th class="col0">gegner</th>
+
           <td class="theadcol0">gegner</td>
−
           <th class="col1">anzg</th>
+
           <td class="theadcol1">anzg</td>
−
           <th class="col2">pts</th>
+
           <td class="theadcol2">pts</td>
−
           <th class="col3">anzTurniere</th>
+
           <td class="theadcol3">anzTurniere</td>
−
           <th class="col4">quoti</th>
+
           <td class="theadcol4">quoti</td>
−
        </tr>
+
</tr>
−
      </thead>
+
<tr>
−
      <tbody>
 
−
        <tr>
 
 
           <td class="col0">zifnab</td>
 
           <td class="col0">zifnab</td>
 
           <td class="col1">34</td>
 
           <td class="col1">34</td>
Zeile 202: Zeile 181:
 
           <td class="col4">0,0</td>
 
           <td class="col4">0,0</td>
 
         </tr>
 
         </tr>
−
      </tbody>
+
</table>
−
    </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
Abgerufen von „https://cm-wiki.novasign.ch/index.php?title=Club:Fairplay/statisches/test&oldid=94245“