Conquer Club

You Can Contribute to the Tournament Handbook

Where dead threads are laid to rest - No new topics, no new posts allowed

Moderator: Tournament Directors

Forum rules
Please read the Community Guidelines before posting.

Re: You Can Contribute to the Tournament Handbook

Postby DaveH on Mon Oct 10, 2011 7:55 am

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.
Image
User avatar
Corporal DaveH
 
Posts: 1595
Joined: Sun Dec 06, 2009 9:12 am
Location: Torquay, Devon

Re: You Can Contribute to the Tournament Handbook

Postby 6_roller on Fri Oct 14, 2011 8:59 am

I'd like to help, as someone who's organising their first tourny, I can tell you what's missing!
Sergeant 6_roller
 
Posts: 161
Joined: Sat Sep 05, 2009 4:54 am

Re: You Can Contribute to the Tournament Handbook

Postby chapcrap on Tue Jan 03, 2012 5:43 pm

Is there any updating that still needs done?
Lieutenant chapcrap
 
Posts: 9686
Joined: Sun Feb 03, 2008 12:46 am
Location: Kansas City

Re: You Can Contribute to the Tournament Handbook

Postby IcePack on Thu Jan 05, 2012 11:56 am

While you have several volunteers for this already I'd be happy to proofread and comment on clarity for writing & handbooks others write up.

IcePack
Image

fac vitam incredibilem memento vivere
Knowledge Weighs Nothing, Carry All You Can
User avatar
Major IcePack
Multi Hunter
Multi Hunter
 
Posts: 16524
Joined: Wed Aug 04, 2010 6:42 pm
Location: California

Previous

Return to Tournament Archives

Who is online

Users browsing this forum: No registered users