Club:Fairplay/statisches/test: Unterschied zwischen den Versionen
Aus chessmail Wiki
K |
K |
||
(42 dazwischenliegende Versionen von einem Benutzer werden nicht angezeigt) | |||
Zeile 1: | Zeile 1: | ||
− | { | + | {{#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;} | |
− | + | }} | |
− | + | ---- | |
− | + | <pre> | |
− | + | 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; | |
− | + | </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 |