Welcome Comrades to the 62nd edition of the Dispatch :)
I hope you all have thoroughly enjoyed the 6th Anniversary Celebration thus far! I know I certainly enjoyed those 24 hours of Speed Battle Royales! Well, the we here at the Newsletter have cooked up a special contest in honor of Conquer Club's sixth birthday ourselves! That's right! We're offering 3 months of premium membership for the winner of the contest (and a few General Achievement medals for the runners-up). Here's the contest:
Phony Paragraph
- In one of the articles in this issue, there is a section that is made-up or untrue - complete bull, if you would. Find it, quote it, and send it to me via PM. The title of the PM must be "Phony Paragraph", and in the PM you must also state who wrote it and in which article. The first person to do so will win the premium! The second through sixth people will receive a General Achievement medal. I'll post when the first six people have sent me the correct PM. You may only PM me once, and you must follow the form described, otherwise it will be counted as wrong! Good luck and have fun.
Also, folks, remember to ask me questions in the Ask A Mod! thread, and ask [player]Quirk[/player] and [player]Quirks Wife[/player] questions in the interrogation thread :)
Now onto the issue! Freestyle's got a new Ask A Mod!, Scum Insider, and interrogation with [player]General Brock II[/player], the Tournament Team has whipped up another large set of articles including a chat with tournament organizer, [player]TheCrown[/player], and another Tournament Tips from [player]DaveH[/player], koontz wrote the whole Cartographic Surveillance segment, and [player]skillfusniper33[/player] wrote for us the only article for the Clan section this issue regarding Newcomers Cup 2.
Enjoy the fruits of our laboring fingers!
[player]Victor Sullivan[/player]
Chief Executive
P.S. Another issue with over the maximum smilies! I've sadly had to disable them again :(
P.S.S./P.P.S. Change is coming to the Dispatch - again! It all starts with a callout... Stay tuned!
If you would like to apply to join the news team, please visit the thread below for more details! :)
Click here for Recruitment Details...
Happy New Year Freestyle Readers. I hope everyone got their partying done and their Battle Royales joined.
New Scum Insider and Ask A Mod as usual, and we interview the leader of the 1st Regiment, General Brock II. May your resolutions be fulfilled in the coming year.
[player]safariguy5[/player]
Freestyle Executive
Ask A Mod! by Victor Sullivan
The Scum Insider by safariguy5
[spoiler=Interrogation of General Brock II]Q. Sir, General, Sir! *salutes*
At ease, soldier. *stands atop jeep hood with bullhorn*. Now listen up, chaps and chappettes, for what I’m about to say.
Q. Do you visit Brock's Monument in Queenston?
Unfortunately, I live relatively distant from Queenston. However, I do have relatives around Oshawa, and I may, some day, extend my drive to travel to St. Catherines and area. I’ve always wanted to visit Brock’s monument… Not only that, but I believe that every self respecting Canadian who lives less than nine hours’ drive away should visit the monument of the hero of Canada.
Q. Do you remember what it was like being a lower ranker?
Vaguely. It’s been a long time… I do remember the desperate, prolongued struggle from private (I never fell below private) to Sergeant. Sergeant didn’t last long, as I’d by then garnered much knowledge, stopped playing reckless games and found some amazing team-mates. Also, I remember the euphoria of gaining over fifty points in a 1 v. 1… It seems that, these days, I’m only capable of losing that many points in a 1 v. 1. :P
Q. When did you first know you were 'starting to make it,' in terms of achieving a rank and keeping it?
Well, as I mentioned above, I believe that when I surpassed Sergeant, I knew I was going to “make it.” I obtained the rank of lieutenant and clung to it for dear life. It was like entering a whole new league – the “big guns,” so to speak. I fluctuated about there for a couple of months, but then I eventually reached captain. I remember reading a forum thread at the time I obtained captain, and some hapless soul had written that captain was merely a “stepping point” – you were either going to fall back to lieutenant or move on to major. Well, after falling immediately thereafter to Lieutenant, I saw the truth in that statement. :P After that, though, it seemed like I clung to captain for a long time…. And now I’m a colonel. I’m quite content with colonel, and I doubt that I'll try for anything more, as I don’t really want to be paranoid about playing only certain games that are guaranteed victories, and I don’t want to concern myself with points… I play for the clan, so Colonel is as high as I need to go.
Q. Your profile says you are a history aficionado---what particular era or topic interests you the most? Do you have photos of your collection of items?
As my profile asserts, I’m certainly a history aficionado, and I enjoy absorbing whatever historical knowledge I can from whatever era or topic. I particularly favour the British Colonial era, and I’m proud to have an English heritage. There is much to be said for a “tiny” island nation that colonized enough of the world that, “The sun never set on the British Empire,” that obtained naval dominance in the 1600s and maintained it until as far as WWII and that still remains a highly respected nation in the Western World. Great Britain has defined many of the political, scientific, medical and social systems that you and I are familiar with.
I do have photographs of some of my swords and helmets. In particular, I stumbled across a vintage WWII Swiss helmet resplendent with intact unit markings.
Q. Why did you choose 1st Reg as your clan name?
When GeneralMatt and I originally began pondering the possibility of forming a clan (after O&H crumbled), we both favoured naming the clan after an authentic, and renowned, English unit. We did ponder a few generic names (“Global Raiders,” “Destructive Force,” “Militant Power”), but finally agreed that there were very few clans named after authentic units.
We then debated what unit to name the clan after. I favoured 8th Army, for obvious reasons. GeneralMatt favoured 3rd “The Buffs.” We also tossed around units like PPCLI, the Coldstream Guards, 1st Armoured Div, and, of course, the 1st Regiment of Foot Guards. I liked regimental size, as, obviously, we wouldn’t want to get even proportionately to the size of an army. :P But a regiment has easy logistics and is easy to handle. The deciding facts were that the 1st has a long and very renowned history, and that the Regiment is still active, as compared to the 3rd or 8th Army. Originally, we were going to allow only people from the Commonwealth into the clan, but the first months of clan membership are tough… We struggled to stay afloat with a broad range of nationalities. And I’m forever grateful that we have them. : )
Q. Why did you set up a clan in the first place?
After O&H disbanded, a lot of very good players were cast off. Only a number of Dan’s core team-mates were accepted into FOED. Truthfully, I hadn’t been very active in O&H, but a friend of mine had grown quite attached to them, and the break-up was a real blow to her. I (and the others) played solo for a short while, but then I hatched the notion to form a clan of our own. I then asked 86, General Flashman and Roy if they’d be up to it, gathered a few of my most common team-mates (and one or two other former O&H members), and the rest is, as they say, history.
Q. What made you start playing CC?
My Uncle, two cousins and Dad played a game of Risk several years ago. We had a smashing time, and I won. We resolved that we’d have to play more often, and my Uncle hatched the idea of looking for a site online. He found two… I favoured the other one because it looked simpler, but I was outvoted. :P We all signed onto CC, and it’s been a wonderful time since (though I’m the only one of the four of us still playing).
Q. Is it true your brother is obsessed with people's favourite colours?
Haha! What’s yours? I’ll let him know. :P
Q. What is the most satisfying thing about running your own clan?
My goodness, that’s a perplexing question. The camaraderie, I think. I love each and every player in the Regiment, and I ensure that I maintain communications with each member. I quite enjoy the logistical aspect and basically appreciate leading such a fine group of players (a well oiled machine, so beware!).
Q. When did you feel 1RFG first became truly competitive?
What?! We’ve become competitive? :P Our first significant victory was against RA. It was at that time that the old members of the clan were still more or less together, and we all proverbially shook hands and said, “Wow, this is great… We’ll make it.”
Q. What is your long term goals?
In life? I intend to finish a combined history/political science degree at University. Then I’ll become a highly educated historian who makes his funding by peddling goods at the flea markets in Florida (or getting elected into a prominent town council… not sure yet which I’d prefer).
On CC, my long term goal is to breach the top ten rankings and defeat KORT and the Pack.
Q. Whats the average airspeed velocity of an unladen swallow?
4k/h… if it’s European. ; ) Did you know that the HMS Swallow was a fifty gun fourth rate?
Q. What part of O&H do you think had the greatest influence on how you run your clan?
Taught me how not to run a clan. :P I quite enjoyed how “free” the players were under Rocket. You could join whatever game you wanted with whoever… I’ve tried to maintain that sense of looseness (though more practically…).
Q. What was it like to be a beginning player?
Odd and exhilarating, simultaneously. I thought that the rank system was neat, indubitably, but hadn't much knowledge of how the game actually worked... I remember my first freestyle game. I hadn’t the foggiest of what was going on. In fact, I think my cousin created it to be freestyle quite by accident.
Q. Any more "coughs" secret weapons that you plan to put in your clan? Or have you sworn off that habit? Did you learn something from your secret weapon program?
That would be classified information charged to the Regimental branch of Intelligence. We've been working on artificial intelligence and V2 rockets. ;)
Q. Public mea culpa as well?
This question and the last are somewhat related, so I’ll kind of address them together in a serious manner. Yes, it was my mistake to permit BlueBell into the clan without knowing all of the circumstances around his exile from CC. You see, I still believe that the case surrounding Buddysystem was entirely arbitrary and unfair, but he should have left his defense to individuals such as myself. I had not realized that he had created numerous accounts in order to argue, himself (thereby becoming a “multi”).
Therefore, in warning to the leaders of other, younger, clans, beware of each player that you accept into your clan. Get the current multi-hunter to run a check on each player you admit… It doesn’t take more than a simple pm to stave off a lot of trouble. The entire incident almost cost me membership on CC, and it almost cost the Regiment membership in the CLA.
Q. Where are all of the normal forum attendees with nothing to do but ask odd questions?
Apparently, this question is to myself… So, where in blazes are they? Don't seem to have anything better to do throughout the day.
Q. a/s/l?
Age: Between 100 and 10. Sex: Male. Location: Ontario
Q. Do you or do you not require subordinates to salute you upon sight?
Of course, sah! Wouldn’t think otherwise. Our parades are amazing spectacles.
Q. When you and General Roy see each other, do you just fist bump?
Fist bump? Are you serious? We bow to each-other, raise our pace sticks in recognition and then work through our top secret special handshake.
Q. In team games, do you follow a chain of command?
That’s an interesting notion. heh Certainly, there is some semblance of command in a team game, as team leaders somewhat assume control and advise the players how to proceed. However, we encourage the input and strategy provided by all players, and veto power is granted to nobody.
Q. Who makes the coffee?
The coffee percolator. :P
Q. How many members of your clan are veterans?
Actually, a good number of the members are army vets. I won’t name them without their permission, but we certainly have 3 or 4, and we’ve had more pass through the ranks. I’m honoured to have them aboard. We also have our own self-proclaimed “hippy.” :P
Q. How do you feel about women in the 1st Regiment?
I’m quite exultant to have women in the Regiment. They raise morale and add different thought processes and methods - a different "flavour". Since the Army hasn’t had any scruples with women in the army since the ‘40s, I don’t see any problems, either! So I’ll shout out to MegsEggs, Arya, Shakeycat and Queen Vic. Thanks for your significant contributions to the clan, and it’s been a pleasure to play with each of you!
Q. What's your favorite color?
Good query. Toronto Maple Leaf blue.
Q. Who is your favorite clan director?
Chemefreak! (yeah... I looked to see who asked this question. XD )
Q. What happened to General Brock I?
He passed away at the Battle of Queenston Heights on October 13, 1812. The Yankees killed him. An interesting fact is that he had noticeable close calls more than three times before.
Q. What is a Grenadier Guard?
A Grenadier Guard is an elite foot soldier (Quite probably another reason why I picked the name for our clan). In fact, in the 17th Century, the Grenadiers were the tallest and strongest of the soldiers, and a part of their task was to hurl grenades at the opponent. Grenade throwing became obsolete (kind of amusing, isn't it? Grenades are once again a very potent infantry weapon) with improved line warfare (and flintlock muskets), but the Grenadier Guards were still used as elite shock or assault troops. It also happens that the GG are preferred for parades, in part due to reputation and in part due to appearance.
Q. What setting is not typically used in clan wars do you wish would be used more often?
Hmm… I wouldn’t mind if nuclear were used more often, I suppose. On the other hand, I couldn’t care.
Q. How cool is Canada?
In the winter, fall and spring, very. :P
Q. Do you speak French?
My knowledge of the French language can be carved into a dinner-plate. I know enough to conduct crude communications… Which isn’t saying much, since I have gotten a Spanish person to tell me where the washroom is much more quickly than a French one. :P
Q. Preferred currency: Loonie or Toonie?
Toonie is worth more, so I select that one.
Q. I like your sig! The quotation "Of all the world's great heroes, there's none that can compare...to the British Grenadiers." is that just something you made up or is there a historical context?
Well, of course there’s historical context to the meaning behind the phrase. I spoke truthfully - the GG ARE the world's great heroes. ;)
Also, it’s a line from the British Grenadier Guards quick marching song.
Thanks, I like it, also!
Q. Wasn't Brock grossly over-rated? It was Shaeffe who won the battle, and whose name is forgotten now, while Brock's name is on a street in every municipality between Cornwall and Leamington.
Certainly not! I don’t think that the commander who conquered the entire Niagara Peninsula in a matter of five months, galvanised the shabby force of Canadian militiamen into an effective fighting force and assumed position as supreme commander of all forces in Upper Canada can be called “over-rated.” He capably and almost single-handedly designed Canada’s defences. Also, he created valuable allies out of the Shawnee and other First Nations tribes. General Brock was a respectful gentleman and officer, and his legacy is truly larger than life. He once accepted a duel against a professional duellist and known “bully” in the 49th Regiment of Foot. Since Brock was so tall, his compatriots were dismayed; however, he stipulated that the duel be fought over a handkerchief… His opponent backed off and also left the Regiment.
Sheaffe led the English to victory at Queenston Heights, but he didn’t even arrive at the battlefield until at least four hours after Brock died. Sheaffe was also unpopular with his subordinates and soldiers, and he is quite responsible for the loss of York.
Q. If you had to join another clan which clan would you petition for admittance to and why?
I would petition to join the Pig Renters. I find them to be a high quality clan composed of splendid players who have a sense of humour. I respect Gunn, alt and UK. I’m not fond of the name, but the military pig theme if amusing. And swine are predators to anything smaller or weaker.
Q. If you could afford your own private island, where would it be?
It’d be just off of Great Britain. I’d anchor it there, myself, if necessary.
Q. Is there any difference between tequila and diesel fuel?
Haha! Well, as far as I know, tequila hasn’t been known to cause brain damage by inhalation.
Q. What's more deadly, neurotoxin or saxitoxin?
Saxitoxin’s not deadly… it’s all hot air.
Q. How much wood could a woodchuck chuck, if a woodchuck could chuck wood?
Depends on what flipping dam it’s helping the beavers build. O_o Beware the Beavers! Have you seen the commercial? I think it was Michelin, maybe...
Q. If one of your CC games could be made into a movie, with live actors playing the troops, real settings for the maps, etc., which game would it be? Where would you film it? Who would be the stars?
There are two games in particular that come to mind. One, World 2.1, in which some chap who I had never played with before, and I, destroyed our opponents in a 8 player showdown. It’s one of very few 8 player doubles that I’ve won, and it was a no spoils match. Game 3476740
The other situation occurred in this game, when Rover invited me to join a game against the odds (ljex was a general, at the time), and we won the thing. Game 8934464
I would choose Oasis for the movie. It’d be a fascinating war film, with a lot of fast paced action and a climactic ending (ljex making a last drive and nearly killing ian… his own Battle of the Bulge. Not only that, but he was tremendously sore about losing and expressed it verbally on my wall… Drama!).
Stars… If I could get Harrison Ford in his younger years, count him in. He makes an excellent “soldier.” Tom Cruise and Barry Pepper would be nice, too. I would, of course, wish to cast Rover, Megs (feminine charm), Ian and myself. For the “enemy,” Dwayne Johnson, Billy Brown, Sean Connery and Al Pacino.
For Oasis, a good set would be the Egyptian Desert or maybe Arizona. I would prefer to get an experienced director of staged wars... Perhaps George Lucas or Steven Spielberg.
Cheers - Over and Out!
General Brock II
[/spoiler]
Hello again my friends, and welcome to your favorite part of the Newsletter, "War Games", where you can find information about CC Tournaments!
I really enjoyed being part of the Sci-Fi and Fantasy Tournament Contest, and I hope my article about it will accurately convey my delight!
Also in this issue, we have an interview with theCrown conducted by WorldCup4James, we have the fourth installment in DaveH's outstanding Tournament Tips series, a brand-new series by sensfan called A World Of Possibilities, and the second installment in sensfan's TPA Wrap.
On the downside, I have to report that [player]sonicsteve[/player] will no longer be with us, having gotten overwhelmed by the demands of his new R/L job. Steve was a tournament organiser of some repute, a Tournament Director, a great player, quite possibly the Grand Champion of Season 1 of the TPA, a very good writer who needed no proofreading, and a fun, upbeat guy to talk to. I'm not sure we will ever find all those attributes in one compact package again. He will definitely be missed.
[player]Dukasaur[/player]
Tournament Executive
Sci-Fi and Fantasy Contest Climaxes! by Dukasaur
Meet the Tournament Organisers: [player]TheCrown[/player] by WorldCup4James
[spoiler=interview with thecrown]To close off 2011, tournament organiser (and champion) [player]TheCrown[/player] will join us in giving some valuable ideas on what makes an enjoyable, memorable, and competitive tournament. [player]TheCrown[/player] has hosted 24 tournaments, and his trademark work is the "Strain your Brain" 20-tournament series. He's also won 18 tournaments after only 16 months at ConquerClub.
TheCrown continues to create unique, exciting, and fast-paced competitions; his brand-new Avalanche tournaments are set around the winter season and keep players interested by featuring a very creative and cool 1v1 method of advancement. It's something different from the generic single-elimination or round-robin style competitions. Let's see what he has to say,
I love tournaments that bring in creativity and create a festive CC holiday spirit. Tell me about your Avalanche series, which has picked up quite some popularity around the winter season. What sets this tourney apart?
I dreamed up the avalanche series of tournaments in a few days, trying to think of a fun new way to incorporate themed maps together. These tournaments are fun because you're never eliminated, but you play all the way down the mountains you are in and you can amass some big numbers at the end of the tourney and win, even if you were behind in the beginning. Stealing part of someone's mountain avalanche is what it's all about, and then rolling down and beating others on the mountain.
Creativity is key! Besides this, what ideas or type of format do you think are critical for a successful tournament? Lots of games? High-intensity, single-elimination style competitions?
I believe a successful tournament has a variety of maps, a fun and easy-to-understand format, good score-keeping and posting, and a quick finishing time. My first Avalanche tourney finished in just under a month and the GA medal was awarded just after a month. I have been in tournaments that have lasted 7 to 11 months. Sometimes the TO skips out for a few months and expects people to stay interested, and I find that appalling.
I can only have 3 tourneys at a time, so right now I have 2 "Avalanche" tourneys going and another called "Mini-clan war tourney". That tourney introduces people to what it's like to be in a clan. I got 32 people who were under 500 games completed and currently not in a clan, and I put them in 8 groups of 4, letting them fight it out in a single bracket tourney with 6 doubles, 6 triples, and 1 random quad game which they must fill from their mini-clan of 4 people. I have had a lot of feedback from this tourney from the players and they really seem to love it. In fact, I believe some of them are about to start up a real clan. It's pretty exciting.
Expect to see me putting on more of both of these types of tourneys for some time to come.
You've put together 25 tourneys (and counting), but it's also very much worth noting that you've won 18 tourneys. Throughout your tournament career, can you recall any other fellow organisers' tournament that were well-run and unique?
It's hard to remember all the tourneys I have played in, but the best tourneys I believe are [player]flexmaster33[/player]'s tourneys. Great scoring systems, great standings and great prizes. He could do with adding a few more GA medals because his tourneys are huge and long.
[player]tokle[/player] from TNC clan puts on some very well thought out themes with interesting stories. You can tell he puts a lot of work into his tourneys.
I like tourneys that have good scoring systems, and his are rewarding if you win your 1 vs. 1 games in fewer rounds. I liked the idea I used in my "Strain your Brain" tourney series where in the 1 vs. 1 games, if you went 1st and you won, you would get 3 points, and if you went 2nd and won, you would get 4 points. It is pretty difficult to win when you go 2nd in 1 vs. 1 play. Of course, it was a pain keeping the stats on who went 1st in each game, so I have quit doing it for now.
It's all about establishing a unique system players like.
So enough about CC for a minute :D :lol:
Wish to share any of your favorite sports or hobbies?
Sport #1 is slow pitch softball, which I have been playing for 19 years.
Sport #2 is to make myself better at sport #1 by weight-lifting, which I have been doing for 18 years off and on.
Hobbies - Watching "Heart of the Matter" by Shawn McCraney, watching American football, playing "Civilization" and "AOE" with my kids, and reading books about the Bible.
I love slow-pitch softball, since it often time puts all the emphasis on fielding (I was never good at hitting in baseball :lol: ). It's fun unless you're playing at third base and get your teeth knocked out :shock:
Yes, 3rd base is about the only place I don't want to play. I play everything else though. I love the Miken Freak and Worth Mayhem bats, and I stick with them and ignore the newest technology for bats. I am a .650 batter with the most power for home runs on my team... and I'm one of the oldest on the team at 41.
Impressive! Any favorite music?
Todd Agnew & Third Day & Regina Spektor.
I noticed a while back, you were a Brigadier. Did you ever eat any snacks that seemed to woo the intensity cubes in your favor? For me, it's a nice glass of cola :lol:
I think my stomach has been aching too much lately... maybe I need to try new foods.
Alka-Seltzer will help you roll 6s ;) No, I wish. :D
It's the end of the year, and the entire Tournament Team of the Newsletter is looking forward to the many new organisers that join in the fun of competitive risk-taking. Each organiser always brings something unique for players to enjoy. What's the one tip you'd like to mention to the aspiring TOs of 2012?
For TOs in 2012: I believe it's fun to see unique or different types of tournaments run.
Thanks [player]TheCrown[/player]! Best of luck in the new year![/spoiler]
Tournament Tips: by DaveH
[spoiler=updating your results]I'm quite lazy. Once I have updated my tournament results in Excel I like to be able to copy a block of text into the tournament thread to update the winners without needing additional typing. Therefore I use functions and macros where possible. Macros are accessed in Excel from the Tools/Macro menu. The best way I find of creating a new one is to go to Tools/Macro/Record New Macro; then enter the macro name (and perhaps a key press) that you want to use and then click the "stop" logo on the small window that appears. Then go to Tools/Macro/Macros, highlight your macro and choose "Edit" to open your macro into a new window so that you can edit and test your macro before saving the final version.
Obviously there are many different types of tournaments and ways of scoring, so I'll give an example from one of my present tournaments. In this one, a 4-player assassin tournament, I am recording the winner's name for each game and therefore need a macro that adds up the number of wins by each player.
The winners' names are in a list and I use the following macro to scan down the list and copy the winners names into a separate list.
Code: Select all
Dim i, j, itotal As Integer 'integers used in this macro
Dim Aname, Bname As String 'string fields used to hold the players' names
itotal = 0 'itotal is the number of winners
For i = 47 To 112 'start to last row number of the winners' list
Aname = Cells(i, 25).Value '25 is the player list's column number
If Aname <> "" Then 'not blank - so a player's name
itotal = itotal + 1 ' increment the number of winners
Cells(itotal + 46, 29).Value = Aname 'put the player's name in column 29
Cells(itotal + 46, 30).Value = 1 'put 1 (for 1 win) in the next column
End If
We now have a list of all the winners with 1's in the next column. Obviously there may be players who have won more than one game, so we sort them alphabetically:
Code: Select all
Range(Cells(47, 29), Cells(46 + itotal, 30)).Select
Selection.Sort Key1:=Range("AC47"), Order1:=xlAscending
We now scan down our list and, if there are two names the same, we add together the number of wins and delete one of the results. We then have to repeat the sort and check for duplicates until we have no further duplicates:
Code: Select all
j = 1 'j used as a "duplicate" flag
While j > 0 'repeat this sequence while j>0 (duplicates found)
j = 0 ' no duplicates yet
For i = 1 To itotal - 1
Aname = Cells(i + 46, 29) 'first name in list
Bname = Cells(i + 47, 29) 'second name in list
If Aname = Bname Then 'the player has more than 1 win
j = j + 1 'so j increased to flag that a duplicate has been found
Cells(i + 46, 30) = Cells(i + 46, 30) + Cells(i + 47, 30) 'add the number of wins together
Cells(i + 47, 29) = "" 'delete the duplicate name
Cells(i + 47, 30) = "" 'delete the second number
itotal = itotal - 1 ' 1 fewer names in winner's list
End If
Next i
Range(Cells(47, 29), Cells(46 + itotal + j, 30)).Select 're-sort our list
Selection.Sort Key1:=Range("AC47"), Order1:=xlAscending
Wend
The final act is to sort by the total number of wins:
Code: Select all
Range(Cells(47, 29), Cells(46 + itotal, 30)).Select
Selection.Sort Key1:=Range("AD47"), Order1:=xlDescending
The resulting block of names and number of games won can then be copied and pasted to your tournament thread.
The macro can then be accessed by assigning a keypress or using a button on the spreadsheet.
(These "tips" are ones that I have tried to make it a bit easier in managing my own tournaments. I am sure there are different and better methods than these, so please let me know. Any queries on the above I'll be glad to respond to!)[/spoiler]
A World of Possibilities by Sensfan
TPA Wrap by Sensfan
Hello, folks! Sully filling in for thehippo8 again; don't worry, he should be back from his vacation within the next 2 issues :) Well, I must say I'm more than impressed - koontz singlehandedly wrote the entire Foundry section composed of three articles for this issue! Kudos to him, for sure! Anywho, koontz has got the Foundry rundown on moved maps and dicussions, as well as the results of his little contest. Enjoy!
Victor Sullivan
Chief Executive
What's Where in the Foundry by koontz1973
Foundry News by koontz1973
Map Awards Results by koontz1973
Sully here for Leehar. Well, with the holidays, the Clan section is brief, I'm afraid. Thanks go to [player]skillusniper33[/player] for pulling through despite these busy times! He has provided us with a briefing on Round 2 of Newcomers Cup 2. Enjoy!
Victor Sullivan
Chief Executive
NC2 Round 2 by Skillfusniper33
Stay Tuned for the next issue of the ConquerClub Dispatch for an interrogation of [player]Quirk[/player] & [player]Quirks Wife[/player]. Post any questions you may have for them here --> Interrogation with Quirk & Quirks Wife
Submitting Your Own Articles
If you have a story you think the ConquerClub Community would find interesting, you can submit your articles to [player]Victor Sullivan[/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!
ConquerClub Dispatch Team
- [player]Victor Sullivan[/player] - Chief Executive
- [player]Dukasaur[/player] - Tournament Executive
- [player]sonicsteve[/player] - Tournament Reporter
- [player]WorldCup4James[/player] - Tournament Reporter
- [player]DaveH[/player] - Tournament Reporter
- [player]Fuzzy316[/player] - Tournament Reporter
- [player]sensfan[/player] - Tournament Reporter
- [player]NoSurvivors[/player] - Tournament Reporter
- [player]thehippo8[/player] - Foundry Executive
- [player]OliverFA[/player] - Foundry Reporter
- [player]koontz1973[/player] - Foundry Reporter
- [player]isaiah40[/player] - Foundry Reporter
- [player]lostatlimbo[/player] - Foundry Reporter
- [player]Leehar[/player] - Clan Executive
- [player]Master Fenrir[/player] - Clan Reporter
- [player]skillfusniper33[/player] - Clan Reporter
- [player]BoganGod[/player] - Clan Reporter
- [player]alt1978[/player] - Clan Reporter
- [player]QuikSilver[/player] - Clan Reporter
- [player]DJoach[/player] - Clan Reporter
- [player]safariguy5[/player] - Freestyle Executive
- [player]shieldgenerator7[/player] - Freestyle Writer
- [player]OleCowboyHippy[/player] - Freestyle Writer
Of course, it still would have required approval and what have you from the Boys in Blue.
