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}})}}