Conquer Club

Dave's Tournament Tips Archive

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

Moderator: Tournament Directors

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
 
Posts: 1561
Joined: Sun Dec 06, 2009 9:12 am
Location: Torquay, Devon

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
 
Posts: 1561
Joined: Sun Dec 06, 2009 9:12 am
Location: Torquay, Devon

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
 
Posts: 1561
Joined: Sun Dec 06, 2009 9:12 am
Location: Torquay, Devon

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
 
Posts: 1561
Joined: Sun Dec 06, 2009 9:12 am
Location: Torquay, Devon

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
 
Posts: 1561
Joined: Sun Dec 06, 2009 9:12 am
Location: Torquay, Devon

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!
Image
User avatar
Captain Dukasaur
Community Team
Community Team
 
Posts: 25031
Joined: Sat Nov 20, 2010 4:49 pm
Location: Beautiful Niagara
22

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
Lieutenant chapcrap
 
Posts: 9689
Joined: Sun Feb 03, 2008 12:46 am
Location: Kansas City

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


Return to General Info, Q&A, Discussion

Who is online

Users browsing this forum: No registered users

cron