Benutzer:Mediator/TabelleTest/TableEdit/players1/timi: Unterschied zwischen den Versionen
(Die Seite wurde neu angelegt: „{{mTID01timi}}“) |
K (Schützte „Benutzer:Mediator/TabelleTest/TableEdit/players1/timi“ ([edit=sysop] (unbeschränkt) [move=sysop] (unbeschränkt))) |
||
| (196 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt) | |||
| Zeile 1: | Zeile 1: | ||
| − | {{mTID01timi}} | + | {{mTheTitleColored2|text={{FULLPAGENAME}}|color=White|backcolor=SlateGray}} |
| + | ;benutzte extensions: | ||
| + | [http://www.mediawiki.org/wiki/Extension:HashTables HashTables]| | ||
| + | [https://www.mediawiki.org/wiki/Extension:Arrays Arrays]|[http://www.mediawiki.org/wiki/Extension:HashTables#hashtoarray hashtoarray]| [http://www.mediawiki.org/wiki/Extension:Loops Loops]| | ||
| + | [http://www.mediawiki.org/wiki/Extension:StringFunctions#.23explode: StringFunctions] | ||
| + | ---- | ||
| + | [[Datei:Page link.png|link=Ranglistenturnier_2013]] [[Ranglistenturnier_2013|Ranglistenturnier 2013]] | [[Datei:Page_edit.png|Bearbeiten von „Vorlage:MTID01timi“ | link=http://www.chessmail.info/cmwiki/index.php?title=Vorlage:MTID01timi&action=edit]] | ||
| + | ---- | ||
| + | ;arraydefine:arrayIDtimi | ||
| + | {{#arraydefine: arrayIDtimi | {{mTID01timi}} |,}} | ||
| + | <!-- | ||
| + | ---- | ||
| + | {{#arrayprint:arrayIDtimi |<br/> }} | ||
| + | ---- | ||
| + | {{#arrayprint:arrayIDtimi||@@@@|<nowiki/> | ||
| + | <div>'''{{#explode:@@@@|;|0}}''' [http://www.chessmail.de/game/{{#explode:@@@@|;|1}} {{#explode:@@@@|;|1}}] {{#explode:@@@@|;|2}}</div>}} | ||
| + | --> | ||
| + | ---- | ||
| + | ;loop 1 | ||
| + | ---- | ||
| + | {{ | ||
| + | #loop: i | ||
| + | | 0 <!-- loops start value for {{#var:i}} --> | ||
| + | | 2 <!-- number of loops --> | ||
| + | | <nowiki/> | ||
| + | * {{#arraydefine: val | {{#arrayindex:arrayIDtimi | {{#var:i}} }} | ;}}<span style="color:red;">{{#arrayindex: val | 0}}</span><span style="color:blue;">{{#arrayindex: val | 1}}</span><span style="color:green;">{{#arrayindex: val | 2}}</span><span style="color:lime;">{{#arrayindex: val | 3}}</span> | ||
| + | }} | ||
| + | ---- | ||
| + | <!-- ------------------------------------------------------------------------------ --> | ||
| + | ;loop 2 | ||
| + | <!-- ------------------------------------------------------------------------------ --> | ||
| + | ---- | ||
| + | {{ | ||
| + | #loop: i | ||
| + | | 2 <!-- loops start value for {{#var:i}} --> | ||
| + | | 1 <!-- number of loops --> | ||
| + | | <nowiki/> | ||
| + | * {{#arraydefine: val | {{#arrayindex:arrayIDtimi | {{#var:i}} }} | ;}}<span style="color:red;">{{#arrayindex: val | 0}}</span><span style="color:blue;">{{#vardefineecho:player1|{{#arrayindex: val | 1}}}}</span> | ||
| + | }} | ||
| + | ---- | ||
| + | <!-- ------------------------------------------------------------------------------ --> | ||
| + | ;loop 3 | ||
| + | <!-- ------------------------------------------------------------------------------ --> | ||
| + | ---- | ||
| + | <!-- ------------------------------------------------------------------------------ --> | ||
| + | {{#vardefine:anzrows|{{#arraysize:arrayIDtimi}}}}{{#vardefine:ctrloops|{{#expr:({{#var:anzrows}} - 3)}}}}{{#vardefine:sumPtsSoFar|0}}{{#vardefine:sumGamesRunningSoFar|0}} | ||
| + | {{#vardefine:sumGamesFinishedSoFar|0}}{{#vardefine:sumGamesCanceledSoFar|0}}{{#vardefine:sumGamesTotal|{{#expr:{{#var:anzrows}}-3}}}}{{#vardefine:sumGamesWon|0}}{{#vardefine:sumGamesRem|0}}{{#vardefine:sumGamesLost|0}}{{#vardefine:sumELOSplayer1Alt|0}}{{#vardefine:sumELOSplayer2Alt|0}} | ||
| + | <!-- ------------------------------------------------------------------------------ --> | ||
| + | {{ | ||
| + | #loop: i | ||
| + | | 3 <!-- loops start value for {{#var:i}} --> | ||
| + | | {{#var:ctrloops}} <!-- number of loops --> | ||
| + | | <nowiki/> | ||
| + | * {{#arraydefine: val | {{#arrayindex:arrayIDtimi | {{#var:i}} }} | ;}}<span style="color:red;">{{#arrayindex: val | 0}}</span><span style="color:blue;">[http://www.chessmail.de/game/{{#arrayindex: val | 1}} PArtie]</span><span style="color:green;">{{#arrayindex: val | 2}}</span>{{#switch:{{#arrayindex: val | 2}}|2={{#vardefine:sumGamesWon|{{#expr:({{#var:sumGamesWon}} + 1)}} }} {{mIconBulletGreen}} | 0 = {{#vardefine:sumGamesLost|{{#expr:({{#var:sumGamesLost}} + 1)}} }} {{mIconBulletRed}}| 1 = {{#vardefine:sumGamesRem|{{#expr:({{#var:sumGamesRem}} + 1)}} }} {{mIconBulletYellow}} | {{mIconBulledBlack}}}} -/- {{#arrayindex: val | 2}} - [{{#vardefineecho:sumPtsSoFar | {{#expr:({{#arrayindex: val | 2}}+{{#var:sumPtsSoFar}} ) }} }}] <span style="color:DarkGray;">{{#arrayindex: val | 3}}</span>{{#switch: {{#arrayindex: val | 3}} | 0=running {{#vardefine:sumGamesRunningSoFar | {{#expr: {{#var:sumGamesRunningSoFar}} + 1}} }} | 1=finished {{#vardefine:sumGamesFinishedSoFar| {{#expr: {{#var:sumGamesFinishedSoFar}} + 1}} }} | -2=none | -1=Abbruch {{#vardefine:sumGamesCanceledSoFar | {{#expr: {{#var:sumGamesCanceledSoFar}} + 1}} }} | sonst}}++<span style="color: Navy;">{{#arrayindex: val | 4}}</span><span style="color:Brown;">{{#vardefineecho:sumELOSplayer1Alt|{{#expr:({{#var:sumELOSplayer1Alt}}+{{#arrayindex:val|4}}) }}}}</span>++<span style="color: Navy;">{{#arrayindex: val | 5}}</span>++<span style="color:Brown;">{{#vardefineecho:sumELOSplayer2Alt|{{#expr:({{#var:sumELOSplayer2Alt}}+{{#arrayindex:val|5}}) }}}}</span>++<span style="color: DarkGreen;">{{#expr: 100*{{mPlayer1ELOerwartungsWert | ELOplayer1={{#arrayindex: val | 4}}|ELOplayer2={{#arrayindex: val | 5}}}}round2}}</span>+++<span>{{#arrayindex: val | 6}}</span> | ||
| + | }} | ||
| + | <!-- ------------------------------------------------------------------------------ --> | ||
| + | ---- | ||
| + | <div style="border: 1px solid Gainsboro;"> | ||
| + | * player1: {{#var:player1}} | ||
| + | ---- | ||
| + | * sumGamesTotal: {{#vardefineecho:sumGamesToPlay|{{#expr: {{#var:sumGamesTotal}} - 1}} }} | ||
| + | ---- | ||
| + | * sumGamesRunningSoFar: {{#var:sumGamesRunningSoFar}} | ||
| + | * sumGamesFinishedSoFar: {{#var:sumGamesFinishedSoFar}} | ||
| + | * sumGamesCanceledSoFar: {{#var:sumGamesCanceledSoFar}} | ||
| + | * '''sumGamesToPlaySoFar''': {{#vardefineecho: sumGamesToPlaySoFar | {{#expr: ( {{#var:sumGamesToPlay}} - {{#var:sumGamesFinishedSoFar}} - {{#var:sumGamesCanceledSoFar}} ) }} }} | ||
| + | ---- | ||
| + | {{#vardefine:cfaktor1|2}}{{#vardefine:cfaktor2|1}} | ||
| + | * sumGamesWon: {{#var: sumGamesWon}} (pts:={{#expr: {{#var:cfaktor1}}*{{#var: sumGamesWon}}}}) (pts:={{#expr: {{#var:cfaktor2}}*{{#var: sumGamesWon}}}}) | ||
| + | * sumGamesRem: {{#var: sumGamesRem}} (pts:={{#expr:0.5*{{#var:cfaktor1}}*{{#var: sumGamesRem}}}}) (pts:={{#expr:0.5*{{#var:cfaktor2}}*{{#var: sumGamesRem}}}}) | ||
| + | * sumGamesLost: {{#var: sumGamesLost}} (pts:={{#expr:-0.5*{{#var:cfaktor1}}*{{#var: sumGamesLost}}}}) (pts:={{#expr:-0.5*{{#var:cfaktor2}}*{{#var: sumGamesLost}}}}) | ||
| + | * sumPtsSoFar: {{#expr: 2*{{#var:sumGamesWon}} + {{#var:sumGamesRem}} }} out of max. {{#expr: 2 * ({{#var:sumGamesTotal}} - 1)}} | ||
| + | ---- | ||
| + | * Punktestand: {{#expr: {{#var:cfaktor1}}*({{#var:sumGamesWon}} + 0.5*{{#var:sumGamesRem}}) }} :: {{#expr: {{#var:cfaktor1}}*({{#var:sumGamesLost}} + 0.5*{{#var:sumGamesRem}}) }} (cfaktor1:={{#var:cfaktor1}}) | ||
| + | * '''Punktestand: {{#expr: {{#var:cfaktor2}}*({{#var:sumGamesWon}} + 0.5*{{#var:sumGamesRem}})}} :: {{#expr: {{#var:cfaktor2}}*({{#var:sumGamesLost}} + 0.5*{{#var:sumGamesRem}}) }}''' (cfaktor2:={{#var:cfaktor2}}) | ||
| + | ---- | ||
| + | * sumELOSplayer1Alt: {{mNumForm|{{#var:sumELOSplayer1Alt}}}} | ||
| + | * sumELOSplayer2Alt: {{mNumForm|{{#var:sumELOSplayer2Alt}}}} | ||
| + | ---- | ||
| + | * Differenz (alt): {{#expr:({{#var:sumELOSplayer1Alt}}-{{#var:sumELOSplayer2Alt}})}} | ||
| + | </div> | ||
Aktuelle Version vom 4. Mai 2013, 20:59 Uhr
- benutzte extensions
HashTables| Arrays|hashtoarray| Loops| StringFunctions
- arraydefine
- arrayIDtimi
{{#arraydefine: arrayIDtimi | TurnierID01;;, TunierNameVeranstalter;TurnierModus_HR;TurnierStart01042013, player;timi;, 01;0000000000000000;-1;-2;0000;0000;name, 02;8d5a3bcca24c483d;2;1;1708;1766;Herodes01, 03;6710f136dd30472e;2;1;1736;1627;name, 04;d65958c850e24a49;2;1;1722;1684;name, 05;c324002563a84f46;0;1;1760;1631;name, 06;b7a6c72c04f5496d;2;1;1760;1800;name, 07;9fa3e87a8ea94acb;0;0;1708;1753;name, 08;ae0915c9b9e64ab3;0;1;1708;1704;name, 09;d0c17f47b3c942c7;0;1;1708;1804;name, 10;0734303f98584bfa;2;1;1708;1733;name, 11;4926c6da0bee4730;2;1;1708;1649;name, 12;f8e1d3fab0a74202;0;1;1748;1947;name, 13;d249f9ac01c04ef3;2;1;1742;1777;name, 14;d178b556cb714d7d;2;1;1760;1743;name, 15;5ca19086c7ab4786;2;1;1708;1739;name, 16;d6a22b23bf61453d;0;1;1708;1760;name, 17;6aeb36d2f0f14ee3;1;1;1708;1576;name, 18;31ac6a007c444462;2;1;1722;1363;simsa |,}}
- loop 1
{{
#loop: i | 0 | 2 |
- {{#arraydefine: val | {{#arrayindex:arrayIDtimi | {{#var:i}} }} | ;}}{{#arrayindex: val | 0}}{{#arrayindex: val | 1}}{{#arrayindex: val | 2}}{{#arrayindex: val | 3}}
}}
- loop 2
{{
#loop: i | 2 | 1 |
- {{#arraydefine: val | {{#arrayindex:arrayIDtimi | {{#var:i}} }} | ;}}{{#arrayindex: val | 0}}{{#vardefineecho:player1|{{#arrayindex: val | 1}}}}
}}
- loop 3
{{#vardefine:anzrows|{{#arraysize:arrayIDtimi}}}}{{#vardefine:ctrloops|{{#expr:({{#var:anzrows}} - 3)}}}}{{#vardefine:sumPtsSoFar|0}}{{#vardefine:sumGamesRunningSoFar|0}} {{#vardefine:sumGamesFinishedSoFar|0}}{{#vardefine:sumGamesCanceledSoFar|0}}{{#vardefine:sumGamesTotal|{{#expr:{{#var:anzrows}}-3}}}}{{#vardefine:sumGamesWon|0}}{{#vardefine:sumGamesRem|0}}{{#vardefine:sumGamesLost|0}}{{#vardefine:sumELOSplayer1Alt|0}}{{#vardefine:sumELOSplayer2Alt|0}} {{
#loop: i
| 3
| {{#var:ctrloops}}
|
- {{#arraydefine: val | {{#arrayindex:arrayIDtimi | {{#var:i}} }} | ;}}{{#arrayindex: val | 0}}val | 1}} PArtie{{#arrayindex: val | 2}}{{#switch:{{#arrayindex: val | 2}}|2={{#vardefine:sumGamesWon|{{#expr:({{#var:sumGamesWon}} + 1)}} }}
| 0 = {{#vardefine:sumGamesLost|{{#expr:({{#var:sumGamesLost}} + 1)}} }}
| 1 = {{#vardefine:sumGamesRem|{{#expr:({{#var:sumGamesRem}} + 1)}} }}
|
}} -/- {{#arrayindex: val | 2}} - [{{#vardefineecho:sumPtsSoFar | {{#expr:({{#arrayindex: val | 2}}+{{#var:sumPtsSoFar}} ) }} }}] {{#arrayindex: val | 3}}{{#switch: {{#arrayindex: val | 3}} | 0=running {{#vardefine:sumGamesRunningSoFar | {{#expr: {{#var:sumGamesRunningSoFar}} + 1}} }} | 1=finished {{#vardefine:sumGamesFinishedSoFar| {{#expr: {{#var:sumGamesFinishedSoFar}} + 1}} }} | -2=none | -1=Abbruch {{#vardefine:sumGamesCanceledSoFar | {{#expr: {{#var:sumGamesCanceledSoFar}} + 1}} }} | sonst}}++{{#arrayindex: val | 4}}{{#vardefineecho:sumELOSplayer1Alt|{{#expr:({{#var:sumELOSplayer1Alt}}+{{#arrayindex:val|4}}) }}}}++{{#arrayindex: val | 5}}++{{#vardefineecho:sumELOSplayer2Alt|{{#expr:({{#var:sumELOSplayer2Alt}}+{{#arrayindex:val|5}}) }}}}++{{#expr: 100*{{#expr: 1 / (1 + 10^( ( {{#arrayindex: val | 5}} - {{#arrayindex: val | 4}} ) / 250 ) ) }}round2}}+++{{#arrayindex: val | 6}}
}}
- player1: {{#var:player1}}
- sumGamesTotal: {{#vardefineecho:sumGamesToPlay|{{#expr: {{#var:sumGamesTotal}} - 1}} }}
- sumGamesRunningSoFar: {{#var:sumGamesRunningSoFar}}
- sumGamesFinishedSoFar: {{#var:sumGamesFinishedSoFar}}
- sumGamesCanceledSoFar: {{#var:sumGamesCanceledSoFar}}
- sumGamesToPlaySoFar: {{#vardefineecho: sumGamesToPlaySoFar | {{#expr: ( {{#var:sumGamesToPlay}} - {{#var:sumGamesFinishedSoFar}} - {{#var:sumGamesCanceledSoFar}} ) }} }}
{{#vardefine:cfaktor1|2}}{{#vardefine:cfaktor2|1}}
- sumGamesWon: {{#var: sumGamesWon}} (pts:={{#expr: {{#var:cfaktor1}}*{{#var: sumGamesWon}}}}) (pts:={{#expr: {{#var:cfaktor2}}*{{#var: sumGamesWon}}}})
- sumGamesRem: {{#var: sumGamesRem}} (pts:={{#expr:0.5*{{#var:cfaktor1}}*{{#var: sumGamesRem}}}}) (pts:={{#expr:0.5*{{#var:cfaktor2}}*{{#var: sumGamesRem}}}})
- sumGamesLost: {{#var: sumGamesLost}} (pts:={{#expr:-0.5*{{#var:cfaktor1}}*{{#var: sumGamesLost}}}}) (pts:={{#expr:-0.5*{{#var:cfaktor2}}*{{#var: sumGamesLost}}}})
- sumPtsSoFar: {{#expr: 2*{{#var:sumGamesWon}} + {{#var:sumGamesRem}} }} out of max. {{#expr: 2 * ({{#var:sumGamesTotal}} - 1)}}
- Punktestand: {{#expr: {{#var:cfaktor1}}*({{#var:sumGamesWon}} + 0.5*{{#var:sumGamesRem}}) }} :: {{#expr: {{#var:cfaktor1}}*({{#var:sumGamesLost}} + 0.5*{{#var:sumGamesRem}}) }} (cfaktor1:={{#var:cfaktor1}})
- Punktestand: {{#expr: {{#var:cfaktor2}}*({{#var:sumGamesWon}} + 0.5*{{#var:sumGamesRem}})}} :: {{#expr: {{#var:cfaktor2}}*({{#var:sumGamesLost}} + 0.5*{{#var:sumGamesRem}}) }} (cfaktor2:={{#var:cfaktor2}})
- sumELOSplayer1Alt: {{#number_format: {{#var:sumELOSplayer1Alt}} |0|,|.}}
- sumELOSplayer2Alt: {{#number_format: {{#var:sumELOSplayer2Alt}} |0|,|.}}
- Differenz (alt): {{#expr:({{#var:sumELOSplayer1Alt}}-{{#var:sumELOSplayer2Alt}})}}