CC Dispatch [Issue 77: 14-08-2012] The Yoshi Report

All issues of the newsletter.

Moderator: Community Team

Locked
User avatar
DoomYoshi
Posts: 10728
Joined: Tue Nov 16, 2010 9:30 pm
Gender: Male
Location: Niu York, Ukraine

CC Dispatch [Issue 77: 14-08-2012] The Yoshi Report

Post by DoomYoshi »

Image

Welcome to the 77th edition of our current dispatch. Unfortunately, we have passed the deadline of fashionably late, but most of the news is still freshish. In this case, it is 100% my fault. I am far too busy to take my turns sometimes, let alone publish a newsletter. It is thus, with great dismay, that I announce the hibernation of the strategy section. With only one writer and one executive too busy to write, this section can not subsist. Of course, you can help! If you are reading this, you probably read the newsetter with some regularity. Please don't be afraid to join up and help write for the strategy section, or for any other section you are interested in.

[player]Pirlo[/player] is the interviewee this week and as expected, there is a copious amount of phallic discussion in the interview. Who knew the newsletter could be so titillating? The tournament section is bursting at the seams with articles, as is the foundry. Many are awaiting on the "Death of the Foundry" report, so make sure to read that first. As expected, clan life is motoring on with many new wars and old scores settled.


[player]DoomYoshi[/player]
Chief Executive


Image

If you would like to apply to join the news team, please visit the thread below for more details!

Click here for Recruitment Details...

Image

Welcome back to Freestyle readers. This issue, vodean discusses recent community events, there is a new scum insider, and Pirlo discusses an itch. Enjoy!

You Stay Classy, CC.

[player]safariguy5[/player]
Freestyle Executive


A Dying Way of Life? by vodean
show


The Scum Insider by safariguy5
show


Image

[spoiler=Interrogation of Pirlo]Q. Will you play dubs with me (Campin_Killer)?

A. Of course, I would play with any cool player, including yourself.

Q. You're always in a good mood. You're always so kind and helping, how you doing that?

A. I actually treat people as they treat me. Considering you are my sweetest friend around, you will always see me as much kind as possible :D.

Q. Why don't you love me (pmchugh) any more?

A. I can't stop loving you. I just don't see you anymore.


Q. Why did you stop being a mercenary and start being a big fat ugly cow?

A. I don't think I've ever been a mercenary. I started with TIME clan and left when there was a split and too much drama. Then stayed off clans for a while because I was kinda pissed off. A while later, General Brock II, a cool friend of mine, invited me to the 1RFG and it sounded fun. Meanwhile, KORT was a target for me, but I didn't bother to play because I didn't think I had enough skills to get there, so decided to wait for the right time. Timing is one of my most important tactics, even in real life. I know a lot of cows, and they are great fellas and very nice people who make you eager to be one of them. Although 3 of them invited me many times before I even apply, I still thought it wasn't the right time to say yes because I didn't want to take an immature opportunity and blow it due to lack of skills. :D

Q. What is your favourite map and settings? for singles, doubs, trips and quads ;P

A. Korea for 1v1. Feudal War for 2v2. Malta for 3v3. Europa for 4v4. I'm not a big fan of multiple opponents games like 1v1v1v1, or 2v2v2v2 because I don't like diplomacy and stuff. I just play a few of them at some private and escalating games where all opponents know how to play and wouldn't ruin your experience. :P

Q. If you have to pick 3 partners for the perfect team(not only strategically perfect but also cool and funny) who would you pick?

A. This is one of the most difficult questions I may ever have. Even math could be a bit easier, given that I really suck at math. :P
But let's say italianipastido (no kidding,) loes, drunkmonkey, JaneAustin, Ace Rimmer, codeblue, Big Yuma Ripper, larsin, and a few more. Sorry, but there's no way to make the list any shorter, they are all amazing in terms of strategy and fun. :D


Q. Do you have any trauma with penis?

A. No, not at all. My penis was just itchy due to heat, but my lotion solved that problem.

Q. Are you an ass or breast man?

A. Breast of course, and love everything pink. ;)

Q. Where would you most like to live?

A. My work is online and I could live anywhere I want with no work/job barrier, so I think I'm fine where I am now, but Milan and Paris are kinda my favorite cities.

Q. Hottest female you have ever seen for real? Hottest model/actress? Hottest woman in CC?

A. I saw the hottest female for real in Lebanon, and she was a prostitute, but I didn't f*ck her because I don't use hookers in general. :P Models and actresses are pretty fake and they don't attract me, but Nicole Kidman is smoking hot IMO. Hottest woman in CC? another tough question, but there are a few I find em perfect in terms of look and attitude. On the very top, I have to say JaneAustin and Tisha.

Q. Do you think your time as mercenary made you a better CC player, or did it just burn you out?

A. Although me being a mercenary is disputable, let's say yes of course. Playing with a big variety of people is definitely effective.

Q. Is it still itchy?

A. No, not at all.

Q. How many PJs do you need a day to satisfy your need?
oh yeah, i went there. all of CC will know all the gory details.
feel free to make up an embarrassing story about me to make up for it in your response.


A. Well, I can't get enough of any oral sex in general. Not mention how amazing your mouth skill is. ;) so definitely unlimited. XD

Q. How much do you enjoy giving me (vodean) BJs?

A. A lot. XD I actually enjoy giving Cunnilingus, and if you were a chick, you'd probably love it more than penetration itself. ;) Ask my EXs about that.

Q. How deep and unending is your love for me (vodean)? Is it greater or less than your love for loes?

A. Sorry bro, my love for loes is unmatchable. No one is like her, no one is even close. Once you or anybody else put themselves in a comparison with her, they just like started an absolutely lost battle/challenge. :P

Q. Why do you have 69 people on your friends list? How many are on your foe list?

A. Because 69 sounds hot for an oral fan. :D Well, they are more now, but happened to be 69 when I posted in that thread of GD :P
My foe list is usually clear. There might be few there who used to join too much of my trench games.


Q. What are some of your ideas for making LC a friendlier and more appropriate place? How can we encourage new people to come there?

A. LC is good enough IMO. It wasn't so a while ago when IR was there, but it's a lot better now with a great liberty and free speech made by friendly people who wouldn't abuse that liberty to insult people, albeit I take no offense no matter how much effort one would make to bother me.

Q. Would you still consider yourself an Independent Mercenary now that you are in KORT?

A. I thought of KORT as my final destination, and now, it's my home. When my tryout games where on, I wanted to be in; and if I failed to make in, I had a plan to not join any other clan, including my ex clan which I had decided to leave even before I know whether I was going to be accepted as a cow or not. I was like either KORT or none.

Q. Did your anti-itch cream finally work? And once it does, will you stop posting about it in LC?

A. Yes it did, and I already stopped posting about it everywhere.

Q. Why do you pretend to be gay in LC?

I don't. many people are aware that I'm straight and just joking around. I think I'm flexible enough to get some people confused about my sexual orientation. I still wonder how the f*ck I was accused of homophobia. It was just ridiculous lol

Q. Besides myself (VioIet) and caymanmew, who else do you like to jab at in LC?


A. Well, I'm highly confident you know that I don't "like" to jab anybody unless they wanted so for the sake of joking and fun. ;)

Q. Do you feel that there should be a point reset in the following game? Game 11177036

A. Maybe. I don't like to talk about past, especially when it comes to a game. I trust the decision made by the tourney organizer regardless of its effect or whether it was in my favor or not, he still has the final word, although I might disagree. But I just don't want to talk about it.

Q. Are you an Ace or Ass (assassin) man?

A. I prefer the latter.

Q. What's your favorite sport?

A. Football (aka soccer in America.)

Q. What would be your perfect soccer team?

A. If I have the ability to pick an all stars team. GK = Buffon. Defense = Tiago Silva, David Luiz, Fabio Coentrao and Dani Alves. Midfield = Xavi, Iniesta, Andrea Pirlo and Luka Modric or maybe Recardo Kaka. Offense = Lionel Messi and Cristiano Ronaldo.

Q. Why do you like getting kicked from live chat so much?


A. I think it's sometimes fun to drive the mod crazy. :P Just to go too far because it could be annoying for real.

Q. Do you realise you have the same number of friends as Ace has medals?

A. I didn't really know this. :P

Q. When are you going to teach me the Monster map for real?

A. I'm sorry for forgetting this. But we already started a game to fix this and you missed a turn. I forgot to tell ya that missing a turn and/or a tiny mistake are not affordable on that map; well, it depends on your opponents to be clear.

Q. What do you say to the people who would say that this is the most pointless interrogation yet?

A. Nothing.

Q. Why does it itch? And didn't it stop itching after being cut off? (before it grew back again I mean.)

A. It used to itch because of heat, and it wasn't cut off, okay?


Q. Who's your greatest admirer and who do you admire the most?

A. Are we talking about CC community/game? I don't think I know my greatest admirer. As for who I admire the most, there are few, but for now I can name italianipastido, Ace Rimmer and josko.ri

Q. Who's your daddy?

A. I'm afraid you need to ask my mom about this. :P

Q. What is the square root of 34?

A. I told you how much I suck at math, seriously. I can't answer this. :P

Q. Am I (gillipig) being funny?

A. Yes, at least for me.

Q. Do you enjoy being GLG's "maned man"?

A. Yes I do.

Q. What does being "GLG's maned man" mean to you?

A. It means a lot, and you know that you are one of my very first friends on CC.

Q. You are 6-0 in team games with GLG. If you played 14 more games, what do you think the record would be? Is he any good, be honest?

A. I think it would be 20-0. And yes, he definitely is, quite honestly.

Q. Why did you join KoRT?

A. You join a top clan like KORT to become a champion. Not to mention how many cool people are there.

Q. How have you found KoRT? Fun or no fun? Exciting/boring?

A. Like anyone finds his own home.

Q. Can you eat my (vodean) pie please?

A. Maybe.

Q. How about if I (vodean) feed it to you?
Open up for the choo choo train!!!!


A. It would depend on the situation.

Q. How can you hold back from freaking out when you're trying to teach dummies like me (queen victorious) on Monsters? Don't you get frustrated? Oh wait - I think I know how you may deal with that

A. People who ask you for help are willing to improve a certain skill, and their willingness to learn should be an enough motivation for any sound teacher. Add to it that you are a special sweetheart, and yes we deal with it very well, if you know what I mean. ;)

Q. Why did you leave 1RFG before I (queen victorious) got a chance to play with you in that clan? You promised to play with me there, then all of a sudden you were gone. That was not very nice ;-(

A. We don't have to be in the same group/clan to keep playing together. Also, my quit was already planned to happen by summer simple because I had nothing more to add. You are great guys and I long the time when we used to post in the forum and celebrate after every victory we made. :D

Q. Do you see a lot of difference between in how KORT is run/forum activity/etc than you did in your previous clans? Do you feel that it makes a difference as to the success of the clan?

A. I think I do. KORT is full of veterans who have a lot of experiences. The forum clan is no difference. I think it's the same everywhere because you don't always have new people to add something unusual.

Q. What is the length of the biggest penis you have seen? Felt?

A. I never felt any penis of course, and the biggest ones I've see were in porn movies.

Q. Why does everything revolve around MY (vodean) sex life??

A. you might be obsessed with sex?

Q. If you could travel through time and be present for any famous historical event, what would you go see?

A. I'm not a fan of historical places. We have Petra here and I didn't enjoy my trip there. But I think I would enjoy Athens and Rome.

Q. Are you Italian? With any connections to La Cosa Nostra? Or would you have to kill me if you told me?

A. No, I'm a pure Palestinian, at least up to 5 generations ago. As for La Cosa Nostra, I'm a fan of mafia stories and movies. The Godfather is my favorite movie of all time, and Al Pacino is my saint. :D

Q. Why does vodean like to act like he's gay? Do you two have gay relations together? How often do these encounters take place?

A. You need to ask him this. And no, we don't. I think he's just as flexible as myself, and we just like to joke as humor fans.

Q. Why do people have problems with homosexual behavior?

A. Some people are just to nosey to leave everyone alone. I have no idea why people have to care about whom I f*ck as long as they are not directly or indirectly affected.

Q. Has there ever been a woman (or man) that you feel was the "one that got away"?

A. Not sure. Things change a lot and nothing would remain the same.

Q. Are you having more or less sex now that you are single?

A. Considering I don't use hookers, and I don't have enough time on weekends to go to bars and night clubs, my sex is near zero.

Q. Craziest masturbation story? (preferably public masturbation!!)

A. I think it was in a cinema when a guy sitting beside me started masturbating. For the record, he didn't do it because the movie contained hot scenes, but because a couple sitting in front of us were kissing and playing. I think it was disgusting though.

Q. Are you keeping Victor Sullivan hostage?

A. No. lol

Q. How much Nivea do you use per day?

A. I used 100 ml only, and my penis is fine.

Q. Baseball or Softball?

A. Neither.

Q. Gloves or Mittens?

A. Gloves of course. Just because it reminds me of my sweetie FoxGlove. :P

Q. Mittens or Kittens?

A. Kittens.

Q. Seals or Elephants?

A. Neither.

Q. Peanuts or Snoopy?

A. Neither.

Q. Linus or Schroeder?

A. Neither.

Q. The Great Pumpkin or the white-bearded chimney sweep?

A. Neither.

Q. Mozart or Beethoven?

A. Both.

Q. Are you going to answer: 2, 4, or 8 of the questions in this post ? (must choose one of the answers provided)

A. I'm answering all questions, with no exception, all of them.

Q. Are you worried that x-raider doesnt know how to count? There were nine questions. He is not ALLOWING you to answer them all, apparently... :/

A. No, I'm not. :P

Q. Who are 5 CC members that you would love to teabag but haven't done so yet?

A. No one I think. I even teabagged lackattack, so this should tell ya that no one is untouchable. ;)

Q. What do you think is the single most important change that can be made to CC to help save it?

A. Giving freemiums a free speeder per day because people join to play not to get stuck in a casual game with deadbeats.

Q. Are your days as a free agent among clans complete?

A. I'm a happy cow now, and not a free agent. I have a commitment to KORT.

Q. Do you feel any regret at leaving 1RFG for greener pastures?

A. I don't regret my decisions because I take my time before I make them.

Q. What do you miss most from your previous clan?

A. The cool people, because the game is the same everywhere.

Q. How did you go about deciding with italianipastido to try out for KoRT?

A. italianipasito and I didn't make a mutual decision. I left alone, and he came alone. JaneAustin invited me last summer, and as I said, I didn't feel it was the right time. In February, loes invited me and I wasn't ready. In March, Bruceswar invited me and I should give it more consideration because it came from 3 different cows and none of them knew about the 2 others. I had already told General Brock II of my quit because I won't be available for clan games in summer, and one day, I told loes that I was ready to make the tryout games before the busy summer started. Therefore, I played few games with some cows, then loes found out that italianipastido is my full time partner and like my other half on CC. She liked him and thought of him as a potential cow, so she asked me about him. I told her to ask him if she wanted him. We didn't go to KORT as a package.

Q. What do you enjoy most about your new clan?

A. Playing with some cows who I didn't know before like drunkmonkey and denthefrog.

Q. How is the environment different from your previous clan?

A. The environment is almost the same, maybe because I haven't been involved in clan games in KORT colors yet. But cool people are here and there. I think the competition level would be the only difference though.

Q. What do you think are the primary contributing factors to KoRT's double Conquer Cup success?

A. I wasn't there, so I can't tell. I'm not a lot into the clan world, I just focus on my own games and let people focus on theirs.

Q. Has your new clan helped to improve your CC abilities, and if so, How has it done so?

A. As I haven't played any clan game with KORT yet, I haven't felt a lot of difference. But I have to admit that I learnt some new tricks from josko in our tryout game.

Q. What is/are your favourite game type/s?

A. Team games and no spoils. I like trench too.

Q. What is your favourite map?

A. Europa.

Q. Who is your favourite player?

A. italianipastido.

Q. Who is your favourite teammate?

A. italianipastido.

Q. Who is your most challenging opponent?

A. Josko.ri and Rodion.

Q. Which player/s do you respect/admire the most?

A. Josko.ri.

Q. Which player/s do you dislike?

A. I don't think I dislike anyone.

Q. How did you get introduced to the site?

A. Search engine.

Q. How did your development on the site happen? (how did you improve etc?)

A. I used to play as a noob until I met Big Yuma Ripper who said he wanted to be friend with me because I'm from Jordan and he like to meet people from different cultures. We started playing team games with codeblue and larsin as a quad team and I learnt a lot from those great and nice guys. I gotta admit too that GLG helped me a lot when I needed advices and asked consulted him about what the right move I should make in my own games, and he explained a lot to me.

Q. Are there any distinct stages or games you went through to become the player you now are? (Did you farm for a period of time, just play for enjoyment etc?)

A. Ya as I said above, meeting Big Yuma Ripper was a turning point for my CC skills. A while later, I met italianipastido and he was the reason why I got back to the cite after I had gotten bored and decided to not renew my premium, then dazerazer insisted and buy me a premium so we played a lot of monsters games. (I farmed for 2 or 3 games then got bored and sick of it.) lol Now I play for enjoyment only.

Q. What is your most memorable game?

A. I barely remember the past, and I don't usually look behind. But I think there was a California trips game with jsnyder and zidane -21. We were losing and my teammates did say "gg" in game chat. We actually started our turns and just drop and end, so that accumulated a stack after a round or 2. Our opponents who were sdh and two others got really really bad rolls and epic dice fail. I decided to use the accumulated stack and got a lot of regions count then a bonus, while sdh's team dice remained awful and we ended up winning the game. It's not easy to see this in a no spoils game.

Q. Where did your name come from?

A. The footballer, Andrea Pirlo, I love his style and mentality in the football game.

Q. Is it a fondness for the game or the country?


A. It's more about the Country because I'm fond of Italy and Italian lifestyle.

Q. Do you like his position particularly much?

A. Yes, it would be my favorite position as a maestro if I was a footballer.

Q. Can you explain some about your heritage?

A. I believe in individualism and I don’t care about any people heritage.

Q. What are your feelings on the Middle Eastern Environment?

A. Normal, just like any other place. I don't have loyalty to any nation in a patriotic sense. My race = human, and my homeland = earth.

Q. What do you consider your religious affiliation to be?

A. I'm defined as a Muslim Freethinker, albeit I'm not practicing. I depend on my own logic to interpret stuff and to tell what's right and/or wrong. I don't trust any clergy of any brand of faith/religion. And in general, I'm not a big fan of religions. I rather tend to believe that religions are poison especially when they are abused for personal interests. Sadly, this is happening everywhere; hence, I'm a big fan of secularism.

Q. What do you think about the 'Arab Spring'?

A. It started greatly in Tunisia and Egypt, the USA and NATO decided to make that useful for their greed and interests, so it turned to crap in Libya, Syria, Bahrain… etc and I don't like how the radical Muslims (supported by USA & NATO) are raising to power in some countries after they were secular nations. I don't also like the rise of bigotry and hatred against Shiites minorities around.

Q. Specifically, what do you think about the situation North of you in Syria?

A. Miserable thanks to USA and NATO again. I think Syrians revolted legitimately in the beginning, then traitors who live abroad and supported by world leading powers decided to use the ignorance of those desperate "rebellions."

Q. How has the above affected you?

A. Personally, I wasn't affected due to the nature of my work (online business) which has nothing to do with national/regional security. But a lot of my relatives and friends were negatively affected. That's for the economic side. As for humanistic side, violence pisses me off, plain and simple.

Q. What do you think are the environment and other aspects that have shaped you into the person you now are?

A. I experienced a lot. Being a son of Palestinian parents who were forced to leave their home and move east after the Israeli invasion some decades ago, I was raised away from a homeland (pretty homeless.) For a long period of time, my own parents had to deal with the fact that they were dismissed off their homes and the fact that everything is possible in our world. Then I happened to have a similar firsthand experience. I was born in Kuwait which was invaded by Iraq in 1990. This means I was in a war zone for months, and then had to move to Jordan. It wasn't very easy to move from one of the world richest countries to one of the poorest places. For about 10 years, I live in one of the poorest neighborhoods in one of the poorest countries. It was a neighborhood where terrorists come from Afghanistan to recruit ignorant, poor and desperate teenagers. With my bare eyes, I witnessed some recruitment processes and I saw neighbors I knew being recruited and taken to Afghanistan to be prepared for some suicidal action somewhere. You might be curious about me; but yes, recruiters approached me, and I think I was to smart to for their criteria that requires ignorance for an easier brainwash. :P

Q. Did your hands cramp up while answering Leehar's questions?

A. I like Leehar's questions. I enjoyed answering them. :P

Q. Did you have a "ghost writer" answer them?

A. I'm a writer and journalist, so you tell me if I would get bored of answering and writing. XD My typing skills will still be very good and almost free of spelling mistakes even when I get drunk. :D I just type a lot everyday.

Q. When you saw tbc did you cringe?

A. Not really.

Q. What's your take on cow tipping?

A. Cows are just amazing, and everything they do is fun :D

Q. Penis?

A. Yes? :P[/spoiler]

Image

Hello again my friends, and welcome to your favorite part of the Newsletter, "War Games", where you can find information about CC Tournaments! Now that the Olympics are over (Congrats to all our British members on a job well done!), perhaps we can all turn our attention to more serious matters, like CC..:)


To, let me introduce to you our newest reporter, [player]Campin_Killer[/player]! Campin will be taking a stroll down a special Memory Lane, to shine a light on some of the very first tourneys ever played on CC! I find this a fascinating subject myself, and I hope some of you do too. Certainly Campin has given us and excellent first look.

Dave continues with his Tournament Tips, and also with Updating the TPA. His Update begins with the words
We have scores!
which quite likely is enough to sell it to most of you...:)

The discussion is under way for what changes should be made before launching TPA3, so if you want your input, get in there!

James is on vacation, but in a true show of dedication he logged on long enough to produce Join This? Or Not! Thanks again for this exemplary effort.

[player]Dukasaur[/player]
Tournament Executive

Down Tournament Lane by Campin_Killer
show

Tournament Tips by DaveH
[spoiler=Excel coding to set up a tournament - Part 3]As we continue the coding for setting up a tournament spreadsheet, in this article we will start the "Create Template" menu heading coding.

We will start off simply enough, defining a grid where the singles or doubles players will have their names inserted. The size depends on the 8, 16, 32 or 64 player selection and whether the names are listed in one or two columns according to the singles/doubles selection. For instance a doubles tournament with 16 players or an 8 player singles tournament will appear as follows:
Image Image

Selecting the "Create Template" menu item, as coded in the last two articles, runs the "FormatCode" macro. This is started off as follows:

Code: Select all

Sub FormatCode()
    Dim irow As Integer
    Dim icol As Integer
    Dim aplayer As String
    irow = 7    'starting row position
    icol = 3    'starting column position
   
    i = Cells(3, 2).Value 'Number of players
    aplayer = Cells(4, 2).Value 'Type of game
    k = 0                             'Flag = 0 for Singles)
    If aplayer = "Doubles" Then k = 1    'Flag = 1 for Doubles)

The irow, icol matrix position on the spreadsheet is defined as the starting position of the grid. "i" records the number of players in cell position (3,2) - as defined by the other menu selections in the last 2 articles and "aplayer" whether this is a singles or doubles tournament. If it is a doubles tournament "k" is set to 1 from 0.

The next code is as follows:

Code: Select all

For j = 0 To k                         'One or two player rows
        Cells(irow, icol + j).Select
            With Selection.Borders(xlEdgeTop)
            .LineStyle = xlContinuous       'Top border
        End With

The "For/Next" loop runs for 1 loop for singles or 2 loops for doubles as defined by the flag "k". the next "With/End With" loop is the rather long-winded method used to format a cell. Firstly the cell is defined, "Cells(irow, icol + j).Select" then the loop is used to define the type of formatting used; in this first case an border line at the top of the defined cell.

Code: Select all

Cells(irow, icol + j).Offset(i / (k + 1), 0).Select
        With Selection.Borders(xlEdgeBottom)
         .LineStyle = xlContinuous       'Bottom border
        End With

Now a bottom edge - note the offset addition is coded so that if it is a doubles tournament the lower line is half the number of players because there will be two columns for doubles tournaments.

Code: Select all

         Cells(irow, icol + j).Select
        With Selection.Borders(xlEdgeBottom)
            .LineStyle = xlContinuous
            Selection.Font.Bold = True
            If aplayer = "Singles" Then
                ActiveCell.Value = "Players"
            Else
                If j = 0 Then ActiveCell.Value = "Player A"
                If j = 1 Then ActiveCell.Value = "Player B"
            End If
        End With

Next we put a lower line after the heading and include the heading as either "Players" or, for doubles, "Player A" with "Player B" in the next cell.

Code: Select all

For l = 0 To i / (k + 1)
        Cells(irow, icol + j).Offset(l, 0).Select
        If l > 0 And j = 0 Then Cells(irow, icol + j).Offset(l, -1).Value = l
        Cells(irow, icol + j).Offset(l, -1).HorizontalAlignment = xlRight
        With Selection.Borders(xlEdgeLeft)
            .LineStyle = xlContinuous          'Left border
        End With
        With Selection.Borders(xlEdgeRight)
            .LineStyle = xlContinuous          'Right border
        End With
    Next l
    Next j
End Sub

The last part of the routine is to define the edges of the grid and number the players, or doubles team numbers, down the left hand edge. The codes used are as follows: "i/(k+1)" is the number of players divided by 1 (for singles) or 2 (for doubles) to define the number of rows required.
"If l > 0 And j = 0 Then Cells(irow, icol + j).Offset(l, -1).Value = l" states that if the counter is not 0 (i.e. not at the heading position) and it is the first pass through the two loop cycle then put "l" which is the player/team number in the defined cell, offset by -1 into the column before the defined cell.

The full code is as follows:

Code: Select all

Sub FormatCode()
    Dim irow As Integer
    Dim icol As Integer
    Dim aplayer As String
    irow = 7    'starting row position
    icol = 3    'starting column position
   
    i = Cells(3, 2).Value 'Number of players
    aplayer = Cells(4, 2).Value 'Type of game
    k = 0                             'Flag = 0 for Singles)
    If aplayer = "Doubles" Then k = 1    'Flag = 1 for Doubles)
    For j = 0 To k                         'One or two player rows
        Cells(irow, icol + j).Select
            With Selection.Borders(xlEdgeTop)
            .LineStyle = xlContinuous       'Top border
        End With
        Cells(irow, icol + j).Offset(i / (k + 1), 0).Select
        With Selection.Borders(xlEdgeBottom)
         .LineStyle = xlContinuous       'Bottom border
        End With
         Cells(irow, icol + j).Select
        With Selection.Borders(xlEdgeBottom)
            .LineStyle = xlContinuous
            Selection.Font.Bold = True
            If aplayer = "Singles" Then
                ActiveCell.Value = "Players"
            Else
                If j = 0 Then ActiveCell.Value = "Player A"
                If j = 1 Then ActiveCell.Value = "Player B"
            End If
        End With
    For l = 0 To i / (k + 1)
        Cells(irow, icol + j).Offset(l, 0).Select
        If l > 0 And j = 0 Then Cells(irow, icol + j).Offset(l, -1).Value = l
        Cells(irow, icol + j).Offset(l, -1).HorizontalAlignment = xlRight
        With Selection.Borders(xlEdgeLeft)
            .LineStyle = xlContinuous          'Left border
        End With
        With Selection.Borders(xlEdgeRight)
            .LineStyle = xlContinuous          'Right border
        End With
    Next l
    Next j
End Sub

Next article we will see about randomising the players names.

(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]
TPA Wrap by DaveH
show

Join This? Or Not! by WorldCup4James
show

Image

Well, congratulations CC community. You pulled together, had your say and made a difference. All in all a great fortnight's work. And long may the efforts behind the scenes continue! So much to do so much to gain. But the best thing that has been gained, particularly in the last fortnight, is a reinvigoration of the foundry and general comraderie. Again, well done one and all!

This issue, I bring the News and What's Where again. Hopefully next issue you will have [player]Koontz1973[/player] taking back those reigns and providing you with the familiar (and somewhat more knowledgeable) framework that you are used to! [player]Nolefan[/player] brinds us an update on XML, I write an esoteric article about Gamification and [player]Koontz1973[/player] has been run ragged catching up but has taken time out to give us the promised part two of his Special Report. Enjoy! And finally, let's all prove George Beernard Shaw wrong given he said:
The single biggest problem with communication is the illusion that it has taken place.


[player]thehippo8[/player] -- Foundry Executive

Foundry News by [player]thehippo8[/player]
show

Maps in Development by [player]thehippo8[/player]
show

Conditional Borders by nolefan5311
show

Gamification by [player]thehippo8[/player]
show

RIP foundry - Long live the foundry. Did it work? koontz1973
show

Image

The All Comers Cup 2 is just about to start underway with 20 Clans registered. Look for the first round to be started in about a week or so.

The Voice is walks us through a quick overview of seedings and expectations for the 1v1 challenge.

This issue we have a new Clan Executive taking over the clan section in [player]Skillfusniper33[/player].

Newcomers Cup 3 Update by Skillfusniper33 (IGNI)
show


Heads Up! by The Voice (EMP)

show

Image

Stay Tuned for the next issue of the ConquerClub Dispatch for an interrogation of [player]agentcom[/player]. Post any questions you may have for them here --> Interrogation with Agentcom

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]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]campin_killer[/player] - Tournament Reporter

  • [player]thehippo8[/player] - Foundry Executive
    • [player]koontz1973[/player] - Foundry Reporter
    • [player]Flapcake[/player] - Foundry Reporter
    • [player]Nolefan5311[/player] - Foundry Reporter

  • [player]Leehar[/player] - Clan Executive
    • [player]skillfusniper33[/player] - Clan Reporter
    • [player]BoganGod[/player] - Clan Reporter
    • [player]QuikSilver[/player] - Clan Reporter
    • [player]DJoach[/player] - Clan Reporter
    • [player]alt1978[/player] - Clan Reporter
    • [player]gunn217[/player] - Clan Reporter
    • [player]DJ Teflon[/player] - Clan Reporter
    • [player]Master Fenrir[/player] - Clan Reporter

  • [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
░▒▒▓▓▓▒▒░
User avatar
Dukasaur
Community Team
Community Team
Posts: 28213
Joined: Sat Nov 20, 2010 4:49 pm
Location: Beautiful Niagara

Re: CC Dispatch [Issue 77: 14-08-2012] The Yoshi Report

Post by Dukasaur »

Congrats on your first turn at Publishing!
“‎Life is a shipwreck, but we must not forget to sing in the lifeboats.”
― Voltaire
User avatar
Qwert
SoC Training Adviser
Posts: 9262
Joined: Tue Nov 07, 2006 5:07 pm
Location: VOJVODINA
Contact:

Re: CC Dispatch [Issue 77: 14-08-2012] The Yoshi Report

Post by Qwert »

conditional borders-this could be interesting addition in Battle of Antietam
Image
NEW REVOLUTION-NEW RANKS PRESS THESE LINK viewtopic.php?f=471&t=47578&start=0
User avatar
Leehar
Posts: 5492
Joined: Fri Mar 06, 2009 12:12 pm
Gender: Male
Location: Johannesburg
Contact:

Re: CC Dispatch [Issue 77: 14-08-2012] The Yoshi Report

Post by Leehar »

Was lovely to have your perspective on some of those things Pirlo!
show
Pirlo
Posts: 1856
Joined: Wed May 19, 2010 3:48 pm
Gender: Male

Re: CC Dispatch [Issue 77: 14-08-2012] The Yoshi Report

Post by Pirlo »

Leehar wrote:Was lovely to have your perspective on some of those things Pirlo!


Thanks
User avatar
thehippo8
Posts: 1025
Joined: Fri Feb 19, 2010 5:32 pm

Re: CC Dispatch [Issue 77: 14-08-2012] The Yoshi Report

Post by thehippo8 »

Every now and again these interviews have flashes of brilliance ... being selective I choose this from Pirlo ...

Q. What do you think is the single most important change that can be made to CC to help save it?

A. Giving freemiums a free speeder per day because people join to play not to get stuck in a casual game with deadbeats.
ImageImageImage
show
User avatar
Victor Sullivan
Posts: 6010
Joined: Mon Feb 08, 2010 8:17 pm
Gender: Male
Location: Columbus, OH
Contact:

Re: CC Dispatch [Issue 77: 14-08-2012] The Yoshi Report

Post by Victor Sullivan »

thehippo8 wrote:Every now and again these interviews have flashes of brilliance ... being selective I choose this from Pirlo ...

Q. What do you think is the single most important change that can be made to CC to help save it?

A. Giving freemiums a free speeder per day because people join to play not to get stuck in a casual game with deadbeats.

Sadly, however, this promotes multi accounts, for obvious reasons. I think something similar to this was suggested in the past and rejected on those grounds.

-Sully
[player]Beckytheblondie[/player]: "Don't give us the dispatch, give us a mustache ride."

Scaling back on my CC involvement...
Pirlo
Posts: 1856
Joined: Wed May 19, 2010 3:48 pm
Gender: Male

Re: CC Dispatch [Issue 77: 14-08-2012] The Yoshi Report

Post by Pirlo »

Victor Sullivan wrote:
thehippo8 wrote:Every now and again these interviews have flashes of brilliance ... being selective I choose this from Pirlo ...

Q. What do you think is the single most important change that can be made to CC to help save it?

A. Giving freemiums a free speeder per day because people join to play not to get stuck in a casual game with deadbeats.

Sadly, however, this promotes multi accounts, for obvious reasons. I think something similar to this was suggested in the past and rejected on those grounds.

-Sully


Also, getting stuck in 4 casual games that seem to be endless is the actual reason why people create another account currently!
User avatar
x-raider
Posts: 248
Joined: Tue Nov 17, 2009 5:32 am
Location: Lost in the Complexities of the Undiscovered Universe

Re: CC Dispatch [Issue 77: 14-08-2012] The Yoshi Report

Post by x-raider »

Pirlo wrote:
Victor Sullivan wrote:
thehippo8 wrote:Every now and again these interviews have flashes of brilliance ... being selective I choose this from Pirlo ...

Q. What do you think is the single most important change that can be made to CC to help save it?

A. Giving freemiums a free speeder per day because people join to play not to get stuck in a casual game with deadbeats.

Sadly, however, this promotes multi accounts, for obvious reasons. I think something similar to this was suggested in the past and rejected on those grounds.

-Sully


Also, getting stuck in 4 casual games that seem to be endless is the actual reason why people create another account currently!

Yes. Either way some people will make multis. This way they can discover CC without getting stuck.
User avatar
thehippo8
Posts: 1025
Joined: Fri Feb 19, 2010 5:32 pm

Re: CC Dispatch [Issue 77: 14-08-2012] The Yoshi Report

Post by thehippo8 »

x-raider wrote:
Pirlo wrote:
Victor Sullivan wrote:
thehippo8 wrote:Every now and again these interviews have flashes of brilliance ... being selective I choose this from Pirlo ...

Q. What do you think is the single most important change that can be made to CC to help save it?

A. Giving freemiums a free speeder per day because people join to play not to get stuck in a casual game with deadbeats.

Sadly, however, this promotes multi accounts, for obvious reasons. I think something similar to this was suggested in the past and rejected on those grounds.

-Sully


Also, getting stuck in 4 casual games that seem to be endless is the actual reason why people create another account currently!

Yes. Either way some people will make multis. This way they can discover CC without getting stuck.

I agree, sometimes pandering to the criminals all the time gets a bit on the dull side. CC has processes for finding and weeding out multis. But why should CC not look after the nice people? Also, after playing a few speed games there may be an incentive to pay their dues and join up properly. Sometimes you have to give something to get something!
ImageImageImage
show
User avatar
Gillipig
Posts: 3565
Joined: Fri Jan 09, 2009 1:24 pm

Re: CC Dispatch [Issue 77: 14-08-2012] The Yoshi Report

Post by Gillipig »

This is a respons to Koontz writing on "R.I.P Foundry"

As good as it was with one relevant update for once, it's not enough! Mr Lack should/"have to" make more update like these. And make them much more frequent. And not as the end result of a strike.
I've already voiced my opinion on this what seems like a hundred times. And many others have expressed similar views even more so.
One have to draw the conclusion that the man in charge has heard our opinion, and subsequently chosed to not give damn about it.
We will get some random update every once in a while but no serious attempt will be made to change the site for the better.
This is not how you stay competitive! This is not how you keep your customers and it's not how you attract new ones!
The only reason I'm still here, (despite my many tries to leave) is because of the community. The forum games, the occasional interesting discussion in the off topics and more recently the live chat. The site is going downhill because the game has not evolved. A lot of committed volunteers in the foundry (fewer and less committed ones as of recently) do what they can with the tools that have been given to them. But because almost no new tools are being developed, they can't evolve the game. And therefore Conquerclub is getting more and more outdated everyday.
AoG for President of the World!!
I promise he will put George W. Bush to shame!
Locked

Return to “Newsletter Issues”