Dave's Tournament Tips Archive

The place for ideas, discussion of tournament related topics, and finding answers to questions about tournaments.

Moderators: Tournament Directors, Global Moderators

Forum rules
Please read the Community Guidelines before posting.

Dave's Tournament Tips Archive

Postby DaveH on Wed Feb 29, 2012 12:33 pm

show


#1, Issue 58 - Beginner's guide to starting a tournament + links to CC'c tournament reference guides.
show: getting started

#2, Issue 59 - Different methods of randomisiong your list of players.
show: randomising your player list

#3, Issue 60 - Excel coding of single player CC game invite pm's.
show: Inviting Your Players

#4, Issue 61 - Excel coding of game progress reports for your tournament thread.
show: updating your tournament thread

#5, Issue 62 - Excel macro to summarise your tournament thread's winner list.
show: updating your results

#6, Issue 63 - Different scoring possibilities for Round Robin Tournaments.
show: Round Robin Scoring

#7, Issue 64 - An Excel template for managing single elimination tournaments.
show: Single Elimination Games

#8, Issue 64 - Double elimination tournament formating.
show: Double Eliminations Tournaments

#9, Issue 65 - Design considerations for multiple elimination tournaments.
show: Double, Triple and Quad Elimination Game Design

#10, Issue 66 - An Excel macro that totals tournament points.
show: Excel Macro to Summarise Points
Last edited by DaveH on Mon Sep 17, 2012 12:41 am, edited 3 times in total.
Image
User avatar
Lieutenant DaveH
Media Volunteer
Media Volunteer
 
Posts: 1483
Joined: Sun Dec 06, 2009 9:12 am
Location: Torquay, Devon
Medals: 104
Standard Achievement (4) Doubles Achievement (3) Triples Achievement (3) Quadruples Achievement (3) Terminator Achievement (2)
Assassin Achievement (3) Manual Troops Achievement (3) Freestyle Achievement (2) Polymorphic Achievement (1) Nuclear Spoils Achievement (3)
Fog of War Achievement (4) Trench Warfare Achievement (3) Speed Achievement (1) Teammate Achievement (2) Random Map Achievement (2)
Cross-Map Achievement (3) Ratings Achievement (4) Tournament Achievement (10) General Achievement (4) Clan Achievement (4)
Tournament Contribution (30) General Contribution (10)

Dave's Tips #11 to #20 Archive

Postby DaveH on Mon Jun 04, 2012 1:29 am

#11, Issue 67 - Using an Excel lookup table to simplify tournament game match-ups.
show: Using an Excel Lookup Table

#12, Issue 68 - Designing a 4-player tournament in which each player meets everyone else just once.
show: 4-player games - playing 15 opponents once

#13, Issue 69 - Design of a 16 player pair tournament in which you pair everyone else just once.
show: Partnering Your Opponents

#14, Issue 70 - Excel code for inviting players into team games.
show: Inviting Teams

#15, Issue 71 - Excel code for updating team games.
show: Updating Team Games Results

#16, Issue 72 - Using Excel to get a list of all of CC's maps.
show: List of CC maps

#17, Issue 73 - Excel code to update tournament winners from a list.
show: Updating winners

#18, Issue 74 - Setting up an additional Excel menu
show: Customising Excel Menus

#19, Issue 75 - Excel code that creates a tournament spreadsheet template - Part 1.
show: Excel coding to set up a tournament - Part 1

#20, Issue 76 - Excel code that creates a tournament spreadsheet template - Part 2.
show: Excel coding to set up a tournament - Part 2
Image
User avatar
Lieutenant DaveH
Media Volunteer
Media Volunteer
 
Posts: 1483
Joined: Sun Dec 06, 2009 9:12 am
Location: Torquay, Devon
Medals: 104
Standard Achievement (4) Doubles Achievement (3) Triples Achievement (3) Quadruples Achievement (3) Terminator Achievement (2)
Assassin Achievement (3) Manual Troops Achievement (3) Freestyle Achievement (2) Polymorphic Achievement (1) Nuclear Spoils Achievement (3)
Fog of War Achievement (4) Trench Warfare Achievement (3) Speed Achievement (1) Teammate Achievement (2) Random Map Achievement (2)
Cross-Map Achievement (3) Ratings Achievement (4) Tournament Achievement (10) General Achievement (4) Clan Achievement (4)
Tournament Contribution (30) General Contribution (10)

Re: Dave's Tips #21 to #30 Archive

Postby DaveH on Fri Jul 27, 2012 5:10 am

#21, Issue 77 - Excel code that creates a tournament spreadsheet template - Part 3; Adding the main menu code.
show: Excel coding to set up a tournament - Part 3

#22, Issue 78 - Excel code that creates a tournament spreadsheet template - Part 4; Randomising the player list.
show: Excel coding to set up a tournament - Part 4

#23, Issue 79 - Use of VLookup function for assigning scores to a tournament spreadsheet.
show: Use of VLookup function for assigning scores.

#24, Issue 80 - TPA2 Scoring Spreadsheet - Adding an individual tournament score to a master spreadsheet.
show: TPA2 Scoring Spreadsheet.

#25, Issue 81 - Using Buttons - Getting to url's via buttons or pictures.
show: Using Buttons

#26, Issue 82 - Tournament Rescue and Round Robins
show: Tournament Rescue and Round Robins.

#27, Issue 83 - Excel code to automate the game information for a round robin tournament.
show: Automating a Round Robin Tournament.

#28, Issue 84 - Excel code for extracting the order of terminations.
show: Terminator Tournaments

#29, Issue 85 - Excel code used to add tournament result points to the TPA2 master spreadsheet.
show: TPA2 Coding to Modify the Results Spreadsheet

#30, Issue 86 - Finding a game without using Game Finder and what the various labels in refer to.
show: Secrets of Game Finder
Last edited by DaveH on Wed Jan 09, 2013 12:16 am, edited 3 times in total.
Image
User avatar
Lieutenant DaveH
Media Volunteer
Media Volunteer
 
Posts: 1483
Joined: Sun Dec 06, 2009 9:12 am
Location: Torquay, Devon
Medals: 104
Standard Achievement (4) Doubles Achievement (3) Triples Achievement (3) Quadruples Achievement (3) Terminator Achievement (2)
Assassin Achievement (3) Manual Troops Achievement (3) Freestyle Achievement (2) Polymorphic Achievement (1) Nuclear Spoils Achievement (3)
Fog of War Achievement (4) Trench Warfare Achievement (3) Speed Achievement (1) Teammate Achievement (2) Random Map Achievement (2)
Cross-Map Achievement (3) Ratings Achievement (4) Tournament Achievement (10) General Achievement (4) Clan Achievement (4)
Tournament Contribution (30) General Contribution (10)

Re: Dave's Tips #31 to #40 Archive

Postby DaveH on Sun Sep 16, 2012 2:00 am

#31, Issue 87 - Translating Visual Basic Code into CC Code via Excel.
show: Translating VBE into CC Code via Excel

#32, Issue 88 - Scoring termination games by analysing the game log.
show: Analysis of termination Information

#33, Issue 89 - Part 1 of coding that can be used in League type tournaments.
show: League Tournaments - part 1

#34, Issue 90 - Part 2 of coding that can be used in League type tournaments.
show: League Tournaments - part 2

#35, Issue 91 - Part 3 of coding that can be used in League type tournaments.
show: League Tournaments - part 3

#36, Issue 92 - Part 4 of coding that can be used in League type tournaments.
show: League Tournaments - part 4

#37, Issue 93 - Using Excel to create a table in a thread.
show: Creating tables from Excel

#38. Issue 94 - Tables Revisited
show: Creating Tables - Revisited

#39, Issue 95 - More uses for the Excel VLookup function.
show: More VLookup Uses

#40, Issue 96 - Extracting terminator data - updated.
show: Terminator Scoring
Last edited by DaveH on Thu Sep 26, 2013 1:12 pm, edited 7 times in total.
Image
User avatar
Lieutenant DaveH
Media Volunteer
Media Volunteer
 
Posts: 1483
Joined: Sun Dec 06, 2009 9:12 am
Location: Torquay, Devon
Medals: 104
Standard Achievement (4) Doubles Achievement (3) Triples Achievement (3) Quadruples Achievement (3) Terminator Achievement (2)
Assassin Achievement (3) Manual Troops Achievement (3) Freestyle Achievement (2) Polymorphic Achievement (1) Nuclear Spoils Achievement (3)
Fog of War Achievement (4) Trench Warfare Achievement (3) Speed Achievement (1) Teammate Achievement (2) Random Map Achievement (2)
Cross-Map Achievement (3) Ratings Achievement (4) Tournament Achievement (10) General Achievement (4) Clan Achievement (4)
Tournament Contribution (30) General Contribution (10)

Re: Dave's Tips #41 to #50 Archive

Postby DaveH on Sun Sep 16, 2012 2:01 am

#41, Issue 97 - The second part of extracting terminator data - macro details.
show: Terminator Scoring - Part 2

#42, Issue 98 - Coding for using the Tournament Statistics facility to get results data.
show: Amazing Race

#43, Issue 99 - Macros and coding for updating a tournament such as the "7-Up" one.
show: Seven Up

#44, Issue 100 - Second part of updating tournaments such as the "7-Up" on.
show: Seven Up - Part 2

#45, Issue 101 - Indicating results in a poker simulation tournament
show: Poker Tournament

#46, Issue 102 - Using pictures to illustrate your tournament results
show: Noughts and Crosses Tournament

#47, Issue 103 - Tables for 5-player tournaments in which every player plays each other player just once.
show: Unique 5-Player Games

#48, Issue 104 - Updated coding to extract terminator data from a finished game.
show: Unique Terminator Kills

#49, Issue 105 - Keeping your thread up-to-date straight from an Excel sheet.
show: Alternative to Challonge

#50, Issue 106 - A macro for writing a round robin set of match-ups for any number of players.
show: Round Robin Code
Last edited by DaveH on Fri Mar 28, 2014 7:03 am, edited 3 times in total.
Image
User avatar
Lieutenant DaveH
Media Volunteer
Media Volunteer
 
Posts: 1483
Joined: Sun Dec 06, 2009 9:12 am
Location: Torquay, Devon
Medals: 104
Standard Achievement (4) Doubles Achievement (3) Triples Achievement (3) Quadruples Achievement (3) Terminator Achievement (2)
Assassin Achievement (3) Manual Troops Achievement (3) Freestyle Achievement (2) Polymorphic Achievement (1) Nuclear Spoils Achievement (3)
Fog of War Achievement (4) Trench Warfare Achievement (3) Speed Achievement (1) Teammate Achievement (2) Random Map Achievement (2)
Cross-Map Achievement (3) Ratings Achievement (4) Tournament Achievement (10) General Achievement (4) Clan Achievement (4)
Tournament Contribution (30) General Contribution (10)

Re: Dave's Tips #1 to #10 Archive [Copy]

Postby Dukasaur on Sun Sep 16, 2012 5:19 am

As originally promised here, we now make the Dave's Tips archive available!
User avatar
Captain Dukasaur
Head Socialite
Head Socialite
 
Posts: 10475
Joined: Sat Nov 20, 2010 4:49 pm
Location: Beautiful Niagara
Medals: 133
Standard Achievement (4) Doubles Achievement (3) Triples Achievement (2) Quadruples Achievement (2) Terminator Achievement (3)
Assassin Achievement (2) Manual Troops Achievement (2) Freestyle Achievement (2) Polymorphic Achievement (1) Nuclear Spoils Achievement (2)
Fog of War Achievement (4) Trench Warfare Achievement (2) Speed Achievement (1) Teammate Achievement (2) Random Map Achievement (3)
Cross-Map Achievement (4) Beta Map Achievement (2) Battle Royale Achievement (1) Ratings Achievement (4) Tournament Achievement (19)
General Achievement (14) Clan Achievement (9) Training Achievement (2) Challenge Achievement (3) Tournament Contribution (31)

Re: Dave's Tips #11 to #20 Archive

Postby chapcrap on Fri Oct 19, 2012 6:18 pm

DaveH wrote:At the time of writing this, chapcrap was continuing his many tournaments with (the rather unseasonal!) Chap's Christmas: Terminator Robin Style and Chap's Easter: Terminator Robin Style. http://www.conquerclub.com/forum/viewtopic.php?t=155760 and http://www.conquerclub.com/forum/viewtopic.php?t=155924#p3417398
...
Which leaves us with the possibility that Chapcrap is really the mathmatical genius "mathtalk-ga" and perhaps he even knows how to uniquely schedule 5 player matches?
...
If anyone out there does know how to uniquely schedule 5 and more player games, please let me know!

I know how to do that too. Do you still want the information?

EDIT: Here is what I had from my files

Click image to enlarge.
image


Click image to enlarge.
image
Image
User avatar
Major chapcrap
 
Posts: 9579
Joined: Sun Feb 03, 2008 12:46 am
Location: Kansas City
Medals: 167
Standard Achievement (4) Doubles Achievement (4) Triples Achievement (3) Quadruples Achievement (4) Terminator Achievement (3)
Assassin Achievement (3) Manual Troops Achievement (3) Freestyle Achievement (3) Polymorphic Achievement (1) Nuclear Spoils Achievement (3)
Fog of War Achievement (4) Trench Warfare Achievement (3) Speed Achievement (3) Teammate Achievement (2) Random Map Achievement (3)
Cross-Map Achievement (4) Beta Map Achievement (1) Battle Royale Achievement (1) Ratings Achievement (4) Tournament Achievement (31)
General Achievement (16) Clan Achievement (16) Training Achievement (6) Challenge Achievement (1) Tournament Contribution (34)

Re: Dave's Tournament Tips Archive

Postby DaveH on Tue Jul 08, 2014 1:13 pm

#51, Issue 109 - Getting in touch with missing players using a macro to summarise the "Find" data.
show: Finding Missing Players

#52, Issue 114 - Updating the "find" information to include in a thread.
show: updating the FIND instruction

#53, Issue 117 - Getting game data from a list of game numbers.
show: getting game data

#54, Issue 118 - Getting a summary or tournament data into Excel.
show: Downloading tournament game data into Excel.

#55, Issue 119 - Getting a summary or tournament data into Excel.
show: War Game Summariser