World TTR League EDIT
From Tickipedia
With starting TTR League's season 7 we tried to use templates for the division pages to simplify the editing act - no more redundant "chinese" codes! Just click on "edit" at the top of your division page to see the code. To add ONE match result you have to do the following:
- insert the date and result of a match to the next line of |match results= with format *Feb 02: Player A vs '''Player B''' : 2.5 - 4.5, latest result at the top
- go to the code block of Player A and search for the 3 lines of Player A vs Player B like |1v5= |col1v5= |1v5results=
- the first line is set for the match result from the perspective of Player A like |1v5=2.5:4.5 in our example (in games without ties no need to use positions after decimal point)
- the second line is set for the result colour, a win gets limegreen, a tie goldenrod, a loss red - so in our example |col1v5=red
- the third line is set for the games results, put in the results of the 7 games a match is composed of - easy and fast way is to use the excel-converter file (see below)
- our example: |1v5results='''127''':122<br>079:'''116'''<br>'''109''':'''109'''<br>087:'''103'''<br>058:'''090'''<br>120:'''141'''<br>'''112''':104
- after you edited the match to Player A's code block you need to recalculate his points, a game won is worth 1 point, a match won is worth 2 additional points, for a tie both players get 1 additional point
- go to the end of Player A's code block, the 3 first lines are set for games won, games lost, games played (gw+gl=gp and gp has to be divisible by 7), in our example it was the first match of the whole division, so we edit: |1gw=02.5|1gl=04.5|1gp=07
- the next 3 lines are set for matches won, matches lost, matches played, we edit as follows (mw+ml=mp): |1mw=0.0|1ml=1.0|1mp=1
- the next 3 lines are set for points won, points lost, points played: we calculate pw=gw+2*mw, pl=gl+2*ml, pp=gp+2*mp (pw+pl=pp and pp has to be divisible by 9): |1pw=02.5|1pl=06.5|1pp=09
- the next line is set for the player's point average for all his matches played, we calculate pav=pw/mp: |1pav=2.50
- the last 2 lines of the code block are only to be changed after season: |col1= and |1rank=
- you now only have to edit the same lines you just edited for Player A in Player B's code block, of course now from the perspective of Player B
- click on "SHOW PREVIEW" at the bottom and after you checked everything is okay click on "SAVE PAGE" at the bottom
- CONGRATULATIONS - YOU ARE DONE WITH ADDING THE MATCH TO YOUR DIVISION PAGE!
If you do NOT want to add the games' results manually, you can use the excel-converter, use as follows:
- download the file "TTR-League-Converter.jpg" from the Toolpage and extract the excel sheet hidden within
- copy the results from the history of Player A
- open the excel file and use the macro: CTRL+y (or if you do not trust macros: mark K4:N10 and paste text only, then copy K29)
- paste results Player A to Tiki
- copy K30 to Tiki results Player2
- If you want to link screenshots of the games, paste the urls to the games' cell (R4:R10) before you copy K29 and K30 to Tiki
