OK - with spaces in, it works - sorry about not checking it first! Apart from the lack of table format the codes are:
For instance, game invitations appear as “View Game 8918488 (Auto-Join Game)” for which the coding is “[ to ]1234567 Password[ /to ]” where 1234567 is the game number and Password is the password. In Excel, the coding to get this is:
="[ to ]"&A12&" "&B$4&"[ /to ]" where A12 holds the game number and B4 the password. In this way you can keep lists of the opponents and game numbers and a list of the coding which can then be copied and pasted into pm’s to the various contestants. This makes multiple invitations by pm far easier!
In the game thread, I write it so that the game information appears as “Game 1234567 Dave vs DaveH” and, when the game is over, the result is shown as “Game 1234567 Dave vs DaveH (or with the first player’s name crossed out of course!).
In CC coding this is [ game ]8918488[ /game ] Dave vs DaveH and then [ game ]8918488[ /game ] Dave vs [ s ] DaveH[ /s ]
(or [ game ]8918488[ /game ] [ s ]Dave[ /s ] vs DaveH depending on the result)
Arranged in Excel such as:
A B C D E
1 Player 1 Player 2 Game Number Winner
2 Dave DaveH 1234567
The conditional statement in Excel that is copied to 2E is then:
=IF(D2="","[ game ]"&C2&"[ /game ] "&A2&" vs "&B2,IF(D2=A2, "[ game ]"&C2&"[ /game ] "&A2&" vs [ s ]"&B2&"[ /s ]", "[ game ]"&C2&"[ /game ] [ s ]"&A2&"[ /s ] vs "&B2))
This allows a complete list of results to be quickly copied and pasted into the main thread.