Welcome Comrades to the 80th edition of the Dispatch
We start of with another review on the latest from the danger mafia zone, and Macbone wax lyrical in his interrogation.
TPA is the highlight of the tournament arena right now, while WC4J is always good value with his wrap-up on the latest tournaments on the go at the moment.
Foundry continues with it's interactive experience with a new competition on the go this week as our most popular section continues to have widespread appeal while Clans is all about CC3/CL4 since apparently the other 50 wars aren't interesting enough to share
Unfortunately it's been a comedy of errors getting this latest issue out as without Sully we seem to be a somewhat headless bunch. We'll still be running without a Strategy section, but I hope you won't despair as we bring quality news on the latest & greatest from the world of CC.
[player]Leehar[/player]
Aide d'Exec
If you would like to apply to join the news team, please visit the thread below for more details!
Click here for Recruitment Details...
Welcome back to Freestyle readers. This issue, macbone talks about the Far East, the SoC, and some history. There's a new Scum Insider for your perusal, and it is sweltering out here in California. Just thought you should know.
You Stay Classy, CC.
[player]safariguy5[/player]
Freestyle Executive
The Scum Insider by safariguy5
[spoiler=Interrogation of macbone]Hi macbone!
Hola, saf!
Q. Okay, mac.... why are you such a cool dude? Did you take cool dude lessons, and where?
Me, cool? Definitely not. I’m so nerdy it’s painful. =) I’ve been fortunate enough to be friends with a number of cool dudes, though, so maybe I absorbed some through osmosis or something.
Q. Are you a Scottish skeleton? Mac-bone?
Ha! Yeah, I was going for a Scottish vibe with my username. I’m part Scotch-Irish, among other things.
Q. Any relation to Macbeth or Macduff?
This guy, actually.
Q. What does it take to become a Lvl. 3 Arcane Trickster?
Hard work, sleepless nights, and a limitless supply of banana peels!
Q. Tell us about SoC team training?
Wow, the answer to that question could be an article in itself. Short version – students join a training squad and are taught by their teacher, an experienced team player, the fine art of team games.
Q. What is life like in Hong Kong? Are you a native or transplant?
HK is very hectic! I’m an expat, and I’ve lived here for two years now.
Q. If you were a pokemon what pokemon would you be?
Oh, definitely Togemon.
Q. Have you ever talked to a psychotherapist about your helper syndrome?
It’s a gift, friend. Do you know how hard it is to find a good helper these days?
Q. How much of your CC time goes into helping others?
Dhallmeyer preaches 80/20, and I think I stick to that. I kinda feel guilty for not doing more, honestly.
Q. What is your favorite food/dish?
Oh, without a doubt lasagna, with ricotta cheese, Italian sausage and ground beef, and mozzarella and parmesan, layers and layers of the stuff. I’m sure there’s good lasagna to be had somewhere in HK, but I haven’t found it yet, though I did find a couple of good Mexican joints.
Q. What was your favourite moment in the Ten Cities tournament?
Oh, the Excursionist challenges, definitely. Dukasaur had the awesome idea of tying in a cultural challenge to each city stop along the way in the tournament, jokes about Montreal, Berlin’s connection to Hong Kong, stuff like that. Very fun, and very educational!
Q. So.. Mac, why do you hate people so much that you get them hooked on CC? what dark traumas stands behind your vindictive obsession with catching casual gamers and through lessons transforming them into risk-fiends?
I blame wacicha and mpjh, personally. First one’s free!
Q. As a sort of boss of the street-level dealers what is your kickback to the don (lack) and how does the upper echelons of the mafia offer their protection?
Andy sometimes gives me back massages, and I can have all the banana peels I can carry. I do it mostly for the psychic energy I drain from my students, though.
Q. Since you started your get them while they are young program, does lack and andy no longer storm into your irl risk-games flipping the board over and proclaiming it an accident?
Real-life Risk games? What are those? The Escalating Juggernaut does work, though. Unleash that bad boy on unsuspecting players, and it’s better than Park Place and Boardwalk with hotels!
Q. Do you own a mac? If so, please give a short summary as to why you think they are better than Windows based operators.
I never felt the need to own a mac, chiefly because they didn’t have as many games as Windows PCs did back in the day. But let me tell you, I love iPod touches. They’re wonderful little pieces of tiny computer goodness, and I don’t think there’s a Windows equivalent of a device that has all the conveniences of a smartphone without the phone. The Galaxy Tabs look nice, though – I wish the iPod touch was about twice as wide. It’d be just about perfect.
Q. Mountain Dew or Dr. Pepper?
Excuse me while I spew Dew all over my screen. What kind of a question is that? But seriously, I heart IBC Black Cherry.
The Dew in HK is surprisingly good, though, much better than the Canadian crap. You can’t get the Pepper in packs in HK, either, and at HK$9 a can, it’s a little pricey, but I do splurge sometimes. They used to sell Dew in this strangely green luminescent bottle, but cans are colder. It’s weird, but I see it more in the mainland than I do in Hong Kong.
Q. Do you come with MacFries and a soda?
Ha! That reminds me of a night in college. We were hanging out a Taco Bell, and this dude asked my friend, “Does fries come with that shake?”
Q. Are you a nice guy in real life as well or just role-playing in CC?
This question reminds me of "Combat Chuck," a horrible song by the greatest undead ska band in the world, Five Iron Frenzy. =)
I used to think I was a nice guy, but man, to my eternal shame, I am one mean, selfish dude in real life. Marriage has held up a mirror to my life and revealed stuff about myself that I had never known before. Better out than in, certainly, and it's been worth it, but we're all very much like the ghosts in C.S. Lewis' book <i>The Great Divorce</i>.
Q. Have you been to Austria/Europe already?
I spent a couple of weeks in Germany about fifteen years ago. Great people, great drinks, great food (well, ok, it was mostly bratwurst and sauerkraut, but I had a fantastic pizza while I was there).
Q. How do you spent your holidays except from CC powerplaying?
So we’re at the tail-end of a four-day weekend, courtesy of Mid-Autumn Festival and National Day. We hit our local park two nights in a row and walked around carrying lanterns and checking out the mobs of people. I guess you guys heard about the tragedy on the ferry Monday night. Awful, just awful.
For holidays, we hike a lot, hit the beach, or barbecue at a country park. Usually great quantities of food are consumed, because Chinese people eat like crazy. Basically, the first thing anyone says when we have a day off is, ok, we’re not at the office today, so let’s go out and do some stuff.
Q. What's the first thing you do when you wake up in the morning?
Wander into the living room, maybe fix a cup of coffee, look out the window at the harbor outside, and think, Man, we live in a beautiful world.
Q. Where is the first place you go when you log on to CC?
Usually my inbox to see if there’s anything I need to attend to right away. Then I run through my Chatglove games, then the rest of my waiting games, and then swing by the SoC and FOED forums if I have time, and get in a little Team CC reading.
Q. Do you miss the old days?
Yeah, I’m pretty nostalgic. I wish there was some way to stay in college forever, stay out all hours of the night, go to rock shows, but still have a decent job and keep my awesome wife and kids.
Q. How many random children have you kicked off your lawn?
See, I live in a hotel, so we don’t really have a lawn. =)
Q. How would you spend $5.2 million yen?
That’s not much, but I’d probably put it towards a village house in Hong Kong. That might be enough for a down payment, but I dunno.
Either that or comic books.
Q. Why is the lid of a coffin nailed down?
To keep the brains from leaking out, of course! But the second reason is the European vampires don't want the new breed rising from their graves, so they nail those suckers in.
Q. Name your top 3 CC pet peeves.
1. Cool people leaving (wacicha, emelar, mpjh, oldrisky44)
2. People who get incredibly riled up over a game. I mean, we all get upset every now and then, and blowing steam off is good and healthy, but acting all internet rude is just uncivilized. But hey, it's the internet. People going nuts is just par for the course.
3. Players who take advantage of other players and make the site less enjoyable for those folks. If I went over to a buddy’s house, and every week he sprang a new game on me with convoluted rules that he had already mastered and completely destroyed me before I had a chance to even ask what the game was called, I’d find a new friend.
Q. Kapa haka or Hongi?
Q. Haere mai or Haere ra?
Q. Tapu or Mana?
Q. Rangatiratanga or Tohunga?
Q. Ka pai or Utu?
Q. Or with the MacSow's blood, that hath eaten
Her nine MacFarrow, MacGrease that's sweaten
From the MacMurderer's gibbet throw,
Into the MacFlame?
`Twas brillig, and the slithy toves
Did gyre and gimble in the wabe:
All mimsy were the borogoves,
And the mome raths outgrabe.
Q. What do you like most about Conquer Club?
The cool people, the thrill of an escalating table sweep, and the complimentary martinis in the SoC teachers’ lounge.
Q. Why be a SoC Training Academy Instructor?
That’s a very good question! I’m still trying to figure that one out. =)
For me, it’s a way of saying thank you to guys like denthefrog, dhallmeyer, and Bruceswar. They helped me become a better player, and they’re still doing it for the latest generation of students.
Q. What are your thoughts on TeamCC as a whole?
I’m not as involved with the other departments as I should be. I respect the volunteers for their work at making Conquer Club a better place.
Q. What do you think about the institution of the SoC Training Grounds?
I think we have a good system worked out, but it can always be improved. What we do isn’t rocket science, but the SoC is the reason I stuck around CC back when I was a new player, and I’ve enjoyed the friendships and camaraderie we have there.
Q. As an SoC trainer, are there any stupid questions?
We do get some off the wall questions from time to time, but when we do, that’s a good chance to look at what we’re doing from another point of view. What might be obvious to me isn’t always obvious to someone else, and questions that bring that up are a good reminder, I think.
Q. Why won't you train me (chapcrap)?
Chap, I doubt there’s anything I can teach you, old boy. =)
Q. That goes double for me (L M S)?
L M S, didn’t we sign you up as a team trainer? And I seem to remember you being a good hand at solo Escalating in that one crazy tournament you ran. =)
Q. Why did Sid Vicious cross the road?
To do it his way, of course.
Q. What is your favorite Manga / Anime?
I really love Miyazaki. “Castle of Cagliostro,” “Howl’s Moving Castle,” “Whisper of the Heart,” “Spirited Away” – the man is a cinematic treasure.
Q. Are you a fan of Mila Superstar?
Never watched it. =)
Q. Which of the Sailormoon girls would you want to marry and why?
See, I’m already married to Kiki, so the question is moot. =)
Q. How did you join SoC?
I signed up as a new recruit. I don’t even think I’d finished a game yet. I found the SoC through the forums, I think.
Q. Did you start as a teacher?
No way. =) I worked my way up through the ranks, same as almost all of our teachers. =)
Q. Was what was taught at the Society different from how you already played and if it was in what way was it?
The SoC teaches primarily Escalating Terminator and Standard in our non-team training, and like a lot of players, I was focusing on taking continents, spreading out my forces. The whole Escalating Juggernaut idea was completely foreign to me.
Q. Other than the Redman who was most instrumental in getting you to where you are now?
I’ve mentioned them already, but mpjh, dhallmeyer, denthefrog, and Bruceswar all played a part, as did folks like gloryordeath, Lt. Futt, General Roy, and Deli.
Q. How excited are you that Wacicha has resurfaced?
I told them he wasn’t gone, but did they listen? Nooooooooo. =) OK, so he’s only checking in via phone, and he probably won’t return to his previous level of involvement, but any wacicha is a good thing. =) He’s still the toughest Escalating player I’ve played against. He and gloryordeath built the SoC, and it’s awesome to see him still lurking and helping out students. =)
Q. What are your three favourite eras in history?
I’m not really a history buff, but I guess I’d say the Greek Heroic era, the Victorian world of the League (well, let’s just say late 19th century fictional England in general), and the literary movements of 19th century America.
Thanks for your time macbone!
It’s been a pleasure! Sorry for all those stupid answers. =)[/spoiler]
Hello again my friends, and welcome to your favorite part of the Newsletter, "War Games", where you can find information about CC Tournaments!
The new TPA season is under way. Several TPA3 tournaments are already either started or in signups now. For those who are just starting to notice now, our own DaveH has taken over the running of TPA for the new season, as well as cleaning up the scoreboards of the first two. Below you will find both of Dave's articles reflecting this fact, as Tournament Tips discusses his advanced techniques for compiling the scores, and his TPA update gives a general overview of what's happening. And on a personal note, I will be launching a TPA3 effort of my own on October 8th!
Meanwhile, the other multi-tournament series, Capture the Flag, is coming to an end. We've been somewhat remiss in covering that one, compared to the heavy coverage we give the TPA, so I promise you that in our next issue we will have a full Capture the Flag Update!
[player]Dukasaur[/player]
Tournament Executive
Join This? Or Not! by WorldCup4James
TPA Wrap by DaveH
Tournament Tips by DaveH
[spoiler=TPA2 Scoring Spreadsheet.]Tournament Players Association Year 2 (TPA2) is a series of tournaments that goes on over a year. The first year there was one tournament released every week, this year I am helping to maintain the scoring for the 46 tournaments either completed or in progress and have used the spreadsheet that I will be describing in this article.
Last issue's article described the routine used to update the individual tournament scores from the finishing positions. Each tournament has its own sheet, so the routine needs to do the following actions:
* Input the tournament that you want to add its scores to the main spreadsheet scores;
* Add the players names and their scores to the main spreadsheet;
* Sort the spreadsheet by players names;
* Check for duplicate names - if you fine a duplicate, add the scores to one and delete the other;
* Sort by scores
And that's it - basically. It is complicated by the fact that the three types of tournaments have their own sub totals and also that it is such a large spreadsheet that I have found some anomalies with the way in which Excel works. For instance, I like to maintain totals as a way of checking and have found that the formula used in Excel, SUM (A1:A300) say, needs to be restated as it can reduce in value even though the routine has not changed it. I therefore found that checksums were incorrect when the size of the spreadsheet increased beyond a certain point.
OK. The spreadsheet looks like this:[bigimg]http://img600.imageshack.us/img600/3257/tpa2.jpg[/bigimg]
This is sheet 1 of the spreadsheet. Sheets 2 to 48 hold the individual tournament results and sheet 49 is the Scoring sheet that I referred to last week and holds the table of possible scores for the three different types of tournament.
We start, as usual, defining a few variables and assigning them values:
Code: Select all
Sub AddTourney() 'name of this routine
Dim irow As Integer 'row number for start
Dim icol As Integer 'column number for start
Dim isheet As Integer 'sheet stating number
Dim iplayers As Integer 'number of players
Dim itourneys As Integer 'number of tournaments
Dim aplayer As String 'player's name
Dim asheet As String 'sheet number
irow = 7 'starting row position
icol = 2 'starting column position
iplayer = 0
itourneys = 52 '52 maximum tournaments
isheet = 3
aplayer = ""
addsheet = True 'this is a flag to erase a tournament scoreCode: Select all
Call FindNumber(irow, icol, iplayers) 'find number of playersCode: Select all
Sub FindNumber(irow, icol, iplayers)
'Find number of players on master sheet
Sheets("Summary").Activate 'ensure you at the master sheet (called "Summary")
iplayers = 0 'number of players already
aplayer = Cells(irow + iplayers, icol).Value
While aplayer <> "" 'do this loop until we find a blank player name
iplayers = iplayers + 1 'increment number of players
aplayer = Cells(irow + iplayers, icol).Value 'get next player name
Cells(irow + iplayers, icol).Value = StrConv(aplayer, vbLowerCase) ' convert to lower case
Wend
Cells(irow - 1, icol).Value = iplayers & " Players"
End SubWe now want to find out which tournament is to be added to the master score sheet.
Code: Select all
'Add a sheet
For i = 1 To iplayers + 100
Cells(irow + i - 1, 1).Value = i 'put ranking order in
Next i
' which sheet?
B = InputBox("Add a tournament's scores? Enter week number (or 0 to exit) Enter a negative week number to subtract the scores.")
If B < 0 Then
addsheet = False 'subtract that sheet
B = -B
End If
If B <> "0" And B <> "" And B < itourneys Then 'b=week number
asheet = "Week " & B 'go to
Sheets(asheet).Activate
Else
Exit Sub 'invalid sheet number
End IfNow we need to get the players names.
Code: Select all
i = 0
aplayer = Cells(i + 2, 1).Value 'player name
If aplayer = "" Then 'no players' names in
MsgBox ("Week " & B & " is not completed yet.")
Sheets("Summary").Activate
Exit Sub
ElseIf Cells(8, 1).Value = "Entered" Then
MsgBox ("Week " & B & "'s results have already been entered.")
Sheets("Summary").Activate
Exit Sub
End If
While aplayer <> ""
i = i + 1 'i=number of players on the individual tourney sheet
aplayer = Cells(i + 2, 1).Value
If addsheet = False Then Cells(i + 1, 4).Value = -Cells(i + 1, 4).Value
Wend
Range(Cells(2, 1), Cells(2 + i - 1, 1)).Select
Selection.Copy 'copy list of players
atype = Cells(1, 5).Value 'type of tournamentCode: Select all
Sheets("Summary").Select
Cells(irow + iplayers, icol).Select
ActiveSheet.Paste 'paste list of players below last one on masterCode: Select all
Select Case atype
Case Is = "Major"
j = 1
Case Is = "Premier"
j = 2
Case Is = "Standard"
j = 3
Case Else
MsgBox (atype & " is not permitted")
Exit Sub
End Select
l = 1
If addsheet = False Then l = -1
For k = 1 To i
Cells(irow + iplayers + k - 1, icol + j).Value = Cells(irow + iplayers + k - 1, icol + j).Value + l 'increment number of Tournaments
Next kCode: Select all
Sheets(asheet).Activate 'back to individual sheet
Range(Cells(2, 4), Cells(1 + i, 4)).Select
Selection.Copy 'copy score list
Sheets("Summary").Select
Cells(irow + iplayers, Val(B) + 9).Select
ActiveSheet.Paste 'paste in next column
Cells(irow + iplayers, icol + 3 + j).Select
ActiveSheet.Paste 'pasteCode: Select all
If addsheet = False Then
Sheets(asheet).Activate 'back to individual sheet
Cells(8, 1).Value = "Entered"
For k = 1 To i
Cells(k + 1, 4).Value = -Cells(k + 1, 4).Value
Next k
Sheets("Summary").Select
End IfCode: Select all
Call FindNumber(irow, icol, iplayers) 'find number of players
Rows(irow & ":" & irow + iplayers - 1).Select 'select the players rows
Application.CutCopyMode = False
Selection.Sort Key1:=Range("B" & icol), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal 'sort into alpha orderCode: Select all
For k = 1 To iplayers - 1
aplayer = Cells(irow + k - 1, icol).Value
aplayer2 = Cells(irow + k, icol).Value
If aplayer = "" Then
ElseIf aplayer = aplayer2 Then
Cells(irow + k - 1, icol + j).Value = Cells(irow + k - 1, icol + j).Value + Cells(irow + k, icol + j).Value
Cells(irow + k - 1, icol + j + 3).Value = Cells(irow + k - 1, icol + 3 + j).Value + Cells(irow + k, icol + 3 + j).Value
For l = 10 To 10 + itourneys - 1
Cells(irow + k - 1, l).Value = Cells(irow + k - 1, l).Value + Cells(irow + k, l).Value
If Cells(irow + k - 1, l).Value = 0 Then Cells(irow + k - 1, l).Value = ""
Next l
ActiveWindow.Panes(1).Activate
Rows((irow + k) & ":" & (irow + k)).Select
Selection.Delete Shift:=xlUp
End If
Next k
Code: Select all
Call FindNumber(irow, icol, iplayers) 'find number of players
For k = 1 To iplayers
Cells(irow + k - 1, 9).Value = Cells(irow + k - 1, 8).Value + Cells(irow + k - 1, 7).Value + Cells(irow + k - 1, 6).Value
Next k
Rows(irow & ":" & irow + iplayers - 1).Select
Application.CutCopyMode = False
Selection.Sort Key1:=Range("I" & icol), Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormalCode: Select all
Call FindNumber(irow, icol, iplayers) 'find number of players
For i = 1 To iplayers
Cells(irow + i - 1, 1).Value = i 'put ranking order in
Next i
Range("F4").Select
ActiveCell.FormulaR1C1 = "=SUM(R[3]C:R[" & iplayers + 10 & "]C)"
Range("F4:I4").Select
Selection.FillRight
Range("I6").Select
ActiveCell.FormulaR1C1 = "=SUM(R[1]C:R[" & iplayers + 10 & "]C)"
Range("I6:BD6").Select
Selection.FillRight
End SubThe complete subroutines are as follows:
Code: Select all
Sub AddTourney()
Dim irow As Integer 'row number for start
Dim icol As Integer 'column number for start
Dim isheet As Integer 'sheet stating number
Dim iplayers As Integer 'number of players
Dim itourneys As Integer 'number of tournaments
Dim aplayer As String
Dim asheet As String 'sheet number
irow = 7 'starting row position
icol = 2 'starting column position
iplayer = 0
itourneys = 52
isheet = 3
aplayer = ""
addsheet = True
Call FindNumber(irow, icol, iplayers) 'find number of players
'Add a sheet
For i = 1 To iplayers + 100
Cells(irow + i - 1, 1).Value = i 'put ranking order in
Next i
' which sheet?
B = InputBox("Add a tournament's scores? Enter week number (or 0 to exit) Enter a negative week number to subtract the scores.")
If B < 0 Then
addsheet = False 'subtract that sheet
B = -B
End If
If B <> "0" And B <> "" And B < itourneys Then 'b=week number
asheet = "Week " & B 'go to
Sheets(asheet).Activate
Else
Exit Sub 'invalid sheet number
End If
i = 0
aplayer = Cells(i + 2, 1).Value 'player name
If aplayer = "" Then
MsgBox ("Week " & B & " is not completed yet.")
Sheets("Summary").Activate
Exit Sub
ElseIf Cells(8, 1).Value = "Entered" Then
MsgBox ("Week " & B & "'s results have already been entered.")
Sheets("Summary").Activate
Exit Sub
End If
While aplayer <> ""
i = i + 1 'i=number of players on the individual tourney sheet
aplayer = Cells(i + 2, 1).Value
If addsheet = False Then Cells(i + 1, 4).Value = -Cells(i + 1, 4).Value
Wend
Range(Cells(2, 1), Cells(2 + i - 1, 1)).Select
Selection.Copy 'copy list of players
atype = Cells(1, 5).Value 'type of tournament
Sheets("Summary").Select
Cells(irow + iplayers, icol).Select
ActiveSheet.Paste 'paste list of players below last one on master
Select Case atype
Case Is = "Major"
j = 1
Case Is = "Premier"
j = 2
Case Is = "Standard"
j = 3
Case Else
MsgBox (atype & " is not permitted")
Exit Sub
End Select
l = 1
If addsheet = False Then l = -1
For k = 1 To i
Cells(irow + iplayers + k - 1, icol + j).Value = Cells(irow + iplayers + k - 1, icol + j).Value + l 'increment number of Tournaments
Next k
Sheets(asheet).Activate 'back to individual sheet
Range(Cells(2, 4), Cells(1 + i, 4)).Select
Selection.Copy 'copy score list
Sheets("Summary").Select
Cells(irow + iplayers, Val(B) + 9).Select
ActiveSheet.Paste 'paste in next column
Cells(irow + iplayers, icol + 3 + j).Select
ActiveSheet.Paste 'paste
If addsheet = False Then
Sheets(asheet).Activate 'back to individual sheet
Cells(8, 1).Value = "Entered"
For k = 1 To i
Cells(k + 1, 4).Value = -Cells(k + 1, 4).Value
Next k
Sheets("Summary").Select
End If
Call FindNumber(irow, icol, iplayers) 'find number of players
Rows(irow & ":" & irow + iplayers - 1).Select 'select the players rows
Application.CutCopyMode = False
Selection.Sort Key1:=Range("B" & icol), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal 'sort into alpha order
For k = 1 To iplayers - 1
aplayer = Cells(irow + k - 1, icol).Value
aplayer2 = Cells(irow + k, icol).Value
If aplayer = "" Then
ElseIf aplayer = aplayer2 Then
Cells(irow + k - 1, icol + j).Value = Cells(irow + k - 1, icol + j).Value + Cells(irow + k, icol + j).Value
Cells(irow + k - 1, icol + j + 3).Value = Cells(irow + k - 1, icol + 3 + j).Value + Cells(irow + k, icol + 3 + j).Value
For l = 10 To 10 + itourneys - 1
Cells(irow + k - 1, l).Value = Cells(irow + k - 1, l).Value + Cells(irow + k, l).Value
If Cells(irow + k - 1, l).Value = 0 Then Cells(irow + k - 1, l).Value = ""
Next l
ActiveWindow.Panes(1).Activate
Rows((irow + k) & ":" & (irow + k)).Select
Selection.Delete Shift:=xlUp
End If
Next k
Call FindNumber(irow, icol, iplayers) 'find number of players
For k = 1 To iplayers
Cells(irow + k - 1, 9).Value = Cells(irow + k - 1, 8).Value + Cells(irow + k - 1, 7).Value + Cells(irow + k - 1, 6).Value
Next k
Rows(irow & ":" & irow + iplayers - 1).Select
Application.CutCopyMode = False
Selection.Sort Key1:=Range("I" & icol), Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Call FindNumber(irow, icol, iplayers) 'find number of players
For i = 1 To iplayers
Cells(irow + i - 1, 1).Value = i 'put ranking order in
Next i
Range("F4").Select
ActiveCell.FormulaR1C1 = "=SUM(R[3]C:R[" & iplayers + 10 & "]C)"
Range("F4:I4").Select
Selection.FillRight
Range("I6").Select
ActiveCell.FormulaR1C1 = "=SUM(R[1]C:R[" & iplayers + 10 & "]C)"
Range("I6:BD6").Select
Selection.FillRight
End Sub
Sub FindNumber(irow, icol, iplayers)
'Find number of players on master sheet
Sheets("Summary").Activate
iplayers = 0 'number of players already
aplayer = Cells(irow + iplayers, icol).Value
While aplayer <> ""
iplayers = iplayers + 1
aplayer = Cells(irow + iplayers, icol).Value
Cells(irow + iplayers, icol).Value = StrConv(aplayer, vbLowerCase)
Wend
Cells(irow - 1, icol).Value = iplayers & " Players"
End Sub
Phew!
(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! Please note that I use Excel 2003, so there may be variation in the menu instructions if you have Excel 2007)[/spoiler]
Sh-moan. Wah-hah! Another fortnight spins it's dial and cha-bang we are here again!
Some say that the Foundry runs on pure adrenalin and no one stops to ask why! Others say that the Foundry is a life form from another planet! All we know is that it is what we live for!
Like all good things interactive - you are in, we inter, and no-one can say we are not active. For those of you swooning over [player]koontz1973[/player]'s adept cycling of foundry maps - you are loved but gone - for this is the last time you will see it! One last taste of the Koontz magic and then, phwwoom, it's gone! Personally, I dunno, but we are nothing if not here to listen! And to top it, given the Turtle's speed, we are going to step our motion on that column to a monthly cylce from this point on! Frankly, it's safety before schedule on this ship!
And a warm welcome aboard the good ship Foundry to you all with a return to map retrospectives - this time from first time writer [player]Qyu[/player] with an article about your favourite map Doodly!! I'm sure we will be hearing a lot more from this smart mapmaker! Welcome [player]Qyu[/player]
And there can't be a true issue without hearing from [player]koontz1973[/player] and [player]thehippo8[/player] this time teaming up with the word de jour - AGENDA! Let's see if we can't get any feedback on that one. And while we are at it, I bung in a cheeky little comp - time to unscramble the puzzle in this week's Foundry Dispatch Competition - who's first for this round? In the words of Jim Rohn:If someone is going down the wrong road, he doesn't need motivation to speed him up. What he needs is education to turn him around.
[player]thehippo8[/player] -- Foundry Executive
Maps in Development. koontz1973
Doodly by Qyu
Agendas koontz1973 and thehippo8
Foundry Dispatch Competition by thehippo8
Welcome to my first section as supernumerary executive as I pinch-hit for Skillfusniper as he gets busy with travesty of College life!
Clan competition continues trucking along as we announce the winners after almost 6 months of competition in the Clan League 4 Bracket tournaments!
Conquer Cup 2 also heads into the business end of the tournament, as the Quarter-finalist's commence their battles
We also have the latest release of the premier ranking system for clans, and an in-depth analysis thereof
On a sadder note, we continue to be in need of interested parties to perhaps write some articles for us on clan activities as I bring you this issue single-handedly. Perhaps share a bit on the Wars you're participated in, or inter-clan events your clan is pioneering. Give us the high's and lows of Clan success and your parts in achieving it!
[player]Leehar[/player]
Aide de Exec
Conquerors Cup 3 Updates
Clan League Bracket Tournament winners
Latest F400 Ranking
Stay Tuned for the next issue of the ConquerClub Dispatch for an interrogation of [player]Masli[/player]. Post any questions you may have for them here --> Interrogation with Masli
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]Leehar[/player] - Aide d'Exec
- [player]Viceroy63[/player] - Strategy Executive
- [player]Viceroy63[/player] - Strategy Reporter
- [player]macbone[/player] - Strategy Assistant
- [player]Dukasaur[/player] - Tournament Executive
- [player]WorldCup4James[/player] - Tournament Reporter
- [player]DaveH[/player] - Tournament Reporter
- [player]Woopintroysbutt[/player] - Tournament Reporter
- [player]WorldCup4James[/player] - Tournament Reporter
- [player]thehippo8[/player] - Foundry Executive
- [player]koontz1973[/player] - Foundry Reporter
- [player]Flapcake[/player] - Foundry Reporter
- [player]nolefan5311[/player] - Foundry Reporter
- [player]Qyu[/player] - Foundry Reporter
- [player]skillfusniper33[/player] - Clan Executive
- [player]Swifte[/player] - Clan Reporter
- [player]QuikSilver[/player] - Clan Reporter
- [player]Master Fenrir[/player] - Clan Reporter
- [player]DJ Teflon[/player] - Clan Freelance
- [player]IcePack[/player] - Clan Freelance
- [player]The Voice[/player] - Clan Freelance
- [player]safariguy5[/player] - Freestyle Executive
- [player]shieldgenerator7[/player] - Freestyle Writer
- [player]Jdsizzleslice[/player] - Freestyle Writer
- [player]Commander9[/player] - Freestyle Writer
- [player]vodean[/player] - Freestyle Writer
- [player]Quirk[/player] - Freestyle Writer
- [player]kentington[/player] - Freestyle Writer
