Benutzer:Mediator/TabelleTest/TableEdit/players1/timi: Unterschied zwischen den Versionen
< Benutzer:Mediator | TabelleTest | TableEdit
Zur Navigation springen
Zur Suche springen
K |
K (Schützte „Benutzer:Mediator/TabelleTest/TableEdit/players1/timi“ ([edit=sysop] (unbeschränkt) [move=sysop] (unbeschränkt))) |
||
| (31 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt) | |||
| Zeile 1: | Zeile 1: | ||
| + | {{mTheTitleColored2|text={{FULLPAGENAME}}|color=White|backcolor=SlateGray}} | ||
;benutzte extensions: | ;benutzte extensions: | ||
[http://www.mediawiki.org/wiki/Extension:HashTables HashTables]| | [http://www.mediawiki.org/wiki/Extension:HashTables HashTables]| | ||
| Zeile 4: | Zeile 5: | ||
[http://www.mediawiki.org/wiki/Extension:StringFunctions#.23explode: StringFunctions] | [http://www.mediawiki.org/wiki/Extension:StringFunctions#.23explode: StringFunctions] | ||
---- | ---- | ||
| − | [[Datei:Page_edit.png|link=http://www.chessmail.info/cmwiki/index.php?title=Vorlage:MTID01timi&action=edit]] | + | [[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 | ||
| Zeile 44: | Zeile 45: | ||
<!-- ------------------------------------------------------------------------------ --> | <!-- ------------------------------------------------------------------------------ --> | ||
{{#vardefine:anzrows|{{#arraysize:arrayIDtimi}}}}{{#vardefine:ctrloops|{{#expr:({{#var:anzrows}} - 3)}}}}{{#vardefine:sumPtsSoFar|0}}{{#vardefine:sumGamesRunningSoFar|0}} | {{#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: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}} |
<!-- ------------------------------------------------------------------------------ --> | <!-- ------------------------------------------------------------------------------ --> | ||
{{ | {{ | ||
| Zeile 51: | Zeile 52: | ||
| {{#var:ctrloops}} <!-- number of loops --> | | {{#var:ctrloops}} <!-- number of loops --> | ||
| <nowiki/> | | <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)}} }} | + | * {{#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> |
}} | }} | ||
<!-- ------------------------------------------------------------------------------ --> | <!-- ------------------------------------------------------------------------------ --> | ||
| Zeile 73: | Zeile 74: | ||
* 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: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}}) | * '''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> | </div> | ||
Aktuelle Version vom 4. Mai 2013, 20:59 Uhr
Benutzer:Mediator/TabelleTest/TableEdit/players1/timi
- 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}})}}