Welcome Comrades to the 90th edition of the Dispatch
No it's not Helloween, but rather time for an interview with [player]b00060[/player]. While we are on freestyle check out the latest offering from the mafia files and ... drum roll ... a new set of challenges. [player]Leehar[/player]'s team brings us updates on CC3, CL5 and other Clan happenings. [player]Dukasaur[/player]'s team really went to town with some in depth stuff from both [player]DaveH[/player] and [player]generalhead[/player] and ... drum roll ... another new challenge!! And while the foundry may look a little thin this issue, you guessed it, there's ... drum roll ... another challenge!! So while you all get to your homework, we're going to collapse in a small heap before working on what delights to tempt you with next week.
While we are on winning, the Casual Battle Royale games have all come to an end. Congrats on the winners. I have interviewed them all but you will need to wait until next issue also to see that treat. And finally, in the words of Billy Allen:
I'm not afraid of death; I just don't want to be there when it happens.
Enjoy the fruit of our labouring fingers!
[player]thehippo8[/player] Chief Executive
If you would like to apply to join the news team, please visit the thread below for more details!
Hello again Freestylers. Doom would like to announce some new opportunities for community input, I have another Scum Insider, and b00060 is interviewed. You Stay Classy, CC.
We have another exciting update on CC3, qwert gets involved on what DD's think about their groups for CL5, and Swifte trials what will hopefully be a regular article for us, on the latest movers and shakers in the clan world.
We are also eager to present some in-depth analysis from BG's coaches poll next issue!
Hello again my friends, and welcome to your favorite part of the Newsletter, "War Games", where you can find information about CC Tournaments!
The Chatters have come up with an event, which, while not exactly a tournament, is somewhat tournamentish, so you can read about it below. DaveH has his usual installment of Tournament Tips, as well as another TPA update. In addition, I've decided to re-run generalhead's Showcase of Tournament Directors, since these are people you should know well.
Tournament Tipsby DaveH [spoiler=League Tournaments - part 2]In this article I will continue with the steps I am using to continue the 2012 NFL season tournament I picked up from flexmaster33.
The first thing I had to do was to update two weeks of results. Using Game Finder and selecting the tournament and then pressing the "Tour Stats" button, I selected the Results page which looks like: and copied all the results and pasted into Excel.
I sorted by the tournament number and then made it into a Lookup table by selecting the whole table, going to Insert/Name Define and called it "Results". This table links game numbers to Winning Round and Players.
I next needed to find all the games for the "Week 10" results, which was by using Game Finder with "W10" in the Game Label box under the tournament name. The easiest way of doing this is to paste the largest game number at the top of a column and copy the formula "=CelNoAbove-1". This creates a game number one less than the largest game number - and so on down the column. This works very well if all the games had been created consecutively, but there are invariably gaps which means I have to change the formula substituting -2, -3 etc for the -1 in some places in order to replicate the order exactly. OK, so I have checked and have a list of Week 10 games numbers, so I copy the list and select the menu Edit/Paste Special/Values to translate the formulae into numerals (formulas are OK but one error at the top of the table can spread all the way down!).
In the next columns I may want the winning player; losing player and Round number of the win. This is easy to do by selecting the VLookup function to lookup the relevant data from the table we just created. The function is VLOOKUP(Game Number Column, Results, 4, FALSE) for getting the data from column 2 of the Results table (Winning Player); VLOOKUP(Game Number Column, Results, 5, FALSE) for Losing Player; VLOOKUP(Game Number Column, Results, 3, FALSE) for Round Number.
In the next column I may want the Score attributed to winning in that particular round. This is obtained using another Vlookup function looking up the Score from a table based on the winning round. The scores that were used in this tournament were; With a 50 round limit, in Excel I needed to have a table of Round Number (from 1 to 50); Winning Points and Losing Points which I called Score and, for the special game field goal points a table called ScoreS with Round Number (1 to 50) and Winning Points. To get these points into the next column of my table I used the function VLOOKUP(WINNING ROUND CELL, Score, 2, FALSE) and VLOOKUP(WINNING ROUND CELL, Score, 3, FALSE) for the winning and losing points respectively. I also had to paste in the VLOOKUP(WINNING ROUND CELL, ScoreS, 2, FALSE) formula in those places where the special maps were used.
To get the Team Names into the next column of my table, I had to create a Vlookup table of the Players Names (in alphabetical order and called "Players") next to the team name they represented, so the two functions VLOOKUP(WINNING PLAYER CELL, Teams, 2, FALSE) and VLOOKUP(LOSING PLAYER CELL, Teams, 2, FALSE) put the team names of winners and losers into the next columns respectively.
My completed table now had: Game Number; Winning Player Name; Losing Player Name; Round Number; Winning Team Points; Losing Team Points; Winning Team; Losing Team, which gives me all the data I need to update the results for Week 10. Having created the various lookup tables, it was straight forward to do the same for the next week's data.
To simplify the process of extracting the data from the tables into a master scoresheet I created a Visual Basic Routine, which I will describe in the next article.
(These "tips" started off as ones that I used to make it a bit easier in managing my own tournaments. Now, I am looking at other types of tournaments and scoring systems by all you innovative TO's out there. So, if you have a unique scoring system that you would like me to have a go at automating, please let me know and I'll be pleased to try and assist. Any queries on the above I'll be glad to respond to of course. Please note that I use Excel 2003, so there may be variation in the menu instructions if you have other versions of Excel)[/spoiler] TPA3 Wrapby DaveH
Hope you are all enjoying the two new maps. The foundry already has another 6 ready to go.
Whilst we are all having fun playing, I have been having a hard time with all of the replies to Gilligan competition. In the end, I have decided to reward you all. This weeks one is a little harder. A suggestion dealing with maps cropped up in te suggestions forum again. Go and look if you like medals. DaveH asked how many territories are on each of the maps. Well, as usual, our beloved leader (in the foundry that is) thenobodies80 was on hand to help out. Number of Territories on Conquer Club Maps. Hopefully our beloved reporters will be back on duty next issue. Real life has had them snowed under. So whilst we are a little light this issue, can you help out in the future? Send me a PM if you think you can.
Stay Tuned for the next issue of the ConquerClub Dispatch for an interrogation of ... nope, not telling you! Send me a PM if you think you know who it is (or who you think it ought to be) and the best answer will win!
Submitting Your Own Articles
If you have a story you think the ConquerClub Community would find interesting, you can submit your articles to [player]thehippo8[/player] and you may just see your article published in the Newsletter!
Subscription
Did you enjoy this Issue? Have you subscribed to the Newsletter yet?
If you want each and every issue of the ConquerClub Dispatch delivered right into your Inbox, then Subscribe Here!
No deadline for the comp. I will take entries right up to when the next one is published. As for being hard, that is debatable. It all comes down to what maps you know.
Okay all, time to come clean. The next interviewee is [player]denthefrog[/player] and you can shoot to the thread by clicking here. UPDATE: [player]b00060[/player] has returned his answers so they will be in the next issue!!
koontz1973 wrote:No deadline for the comp. I will take entries right up to when the next one is published. As for being hard, that is debatable. It all comes down to what maps you know.
I have found all 3 in drafting room so far. Will continue with other threads in the evening. This competition is great!
ender516 wrote:The pedant in me wish to point out that the quote in the opening is, I believe, from Woody Allen, not Billy Allen (whoever that might be).
Correct! Go to the top of the class! I also do not know who Billy Allen is! Must have been possessed by his spirit at the time! Potential candidates include ...
ender516 wrote:The pedant in me wish to point out that the quote in the opening is, I believe, from Woody Allen, not Billy Allen (whoever that might be).
Correct! Go to the top of the class! I also do not know who Billy Allen is! Must have been possessed by his spirit at the time! Potential candidates include ...
The Voice wrote:The Interrogation spoiler doesn't have anything in it
I thought maybe it was a joke because half of CC has B000060 foe'd, the other half he ha foe'd
Not sure why you ake taking a cheap shot at me, unless you are falling into the hype of everyone else. Here is our last game, I dint say anything to you and since you joined my game, I obviously do not have you foed. Game 12166329
The Voice wrote:The Interrogation spoiler doesn't have anything in it
I thought maybe it was a joke because half of CC has B000060 foe'd, the other half he ha foe'd
Not sure why you ake taking a cheap shot at me, unless you are falling into the hype of everyone else. Here is our last game, I dint say anything to you and since you joined my game, I obviously do not have you foed. Game 12166329
You joine my game. I didn't have you foe'd.
I beat you in that game and asked you to rerate me from a previous game we played. When I was still new here you rated me bad for no real reason other than that I won.
Anyways. I asked you via your wall if you would rerate me. You posted some obscenities on my wall, told me I sucked and then you foe'd me.
This weeks one is a little harder. 
A suggestion dealing with maps cropped up in te suggestions forum again. Go and look if you like medals. DaveH asked how many territories are on each of the maps. Well, as usual, our beloved leader (in the foundry that is) thenobodies80 was on hand to help out. Number of Territories on Conquer Club Maps. 
