Moderator: Community Team

Gilligan wrote:Q: Okay, Gilligan, you've been around CC since the dawn of time. What was your first encounter with the newsletter?
Being insanely active for the past 7 years (I'm ManBungalow's fountain of CC knowledge), I've seen a few rodeos here at Conquer Club (my favorite is when we made turtle soup out of Lack). I used to work for the Tournament Newsletter forever ago with Gozar in the tournament forum. Gozar was a pretty neat guy back in the day, he was a clanmate of mine and was a tournamentaholic (most from that era are gone now
). He hasn't been active for the past 3 years, but was active for about a 3 year span. Like with what happened to my old Hall of Fame, the tournament forum just became too large for any one man to keep up with (or a few, for that matter, since communication would be super important). Tournaments would boom and I would not be able to keep up with it as a Tournament Director, or even ask for help because it was all growing exponentially. With that, I told Lack that the tournaments forum is in very dire need of something automated because the current method was not working, and now we've got the Tournaments tab up at the top there. This is why I originally stepped down from the tournament newsletter, and a few months later the whole tournaments system was automated.
Once all that happened, the newsletter got something of a revamp as well...all of the newsletters would merge and find one big Conquer Club Newsletter. The Foundry Newsletter was not as well-kept as the Tournament Newsletter, it took me a bit just to find that one issue. Anywho, then we found samuelc812 (my predecessor of the Entertainment Team Head, and everyone knows he stole Pirates of the Caribbean avatars from me) working on the biggest newsletter we've seen., that incorporated most of the major aspects of Conquer Club, and it's all neatly stored here. Just before he left we hacked Andy's account, gave him a Kiera Knightley account and created the Easter map.![]()
![]()
After quite some time, we lost Sam and found ourselves Victor Sullivan to take the new publishing head, under my lead as Entertainment Team Head and the newsletter lived on through the Head Executive and Departmental Executives that would eventually join TeamCC for their work on their respective areas in the newsletter. After Victor seemingly up and left, we were caught in a pickle with who would run the newsletter since there was no final word. With that, thehippo8 and his executives would keep it running smoothly until I had to step down as the Entertainment Team Head, and as such the Media Team was born under supervision from thehippo8 for a few months. Fast forward to present day, Dukasaur is now heading the Media Team and the Newsletter and sempaispellcheck is running the Entertainment Department that samuelc and I worked so hard to create.





















Code: Select all
="[b]"&G152&" & "&H152 &" & "&I152&" & "&J152&"[/b]: [tot]"& R152&" R"&B$150 &" 1[/tot]"Code: Select all
="[b]"&L152&" & "&M152 &" & "&N152&" & "&O152&"[/b]: [tot]"& R152&" R"&B$150 &" 2[/tot]"Code: Select all
="[b]"&G164&" & "&H164 &" & "&I164&"[/b]: [tot]"& R164&" R"&B$150 &" 1[/tot]" (Team 1 Triples)
="[b]"&L164&" & "&M164 &" & "&N164&"[/b]: [tot]"& R164&" R"&B$150 &" 2[/tot]" (Team 2 Triples)
="[b]"&G176&" & "&H176 &"[/b]: [tot]"& R176&" R"&B$150 &" 1[/tot]" (Team 1 Doubles)
="[b]"&L176&" & "&M176 &"[/b]: [tot]"& R176&" R"&B$150 &" 2[/tot]" (Team 2 Doubles)
="[b]"&G212&" vs "&L212& ":[/b] [to]"&R212&" R"&B$150&"[/to] [to]"&U212&" R"&B$150&"[/to] [to]"&X212&" R"&B$150&"[/to] [to]"&AA212&" R"&B$150&"[/to] [to]"&AD212&" R"&B$150&"[/to]" (Singles)Code: Select all
Sub AddRound()
irowdepth = 71 'depth of list of players
' select the "Games" spraedsheet
Sheets("Games").Select
'select the row number of the last table's map reference number cell - this we will call LineStart
linestart = InputBox(Prompt:="Last Row Number", _
Title:="Enter the last row number", Default:="Enter Previous Row Number of the Round Number")
'select the map number in column "B" and Referenced Map in column "C"and
Range("B" & linestart, "E" & linestart).Select
Selection.Copy
'add irowdepth +3 to LineStart (depth of the table) for a variable we can call LineDest
linedest = linestart + irowdepth + 3
'Select and paste the two values to the destination cell
Range("B" & linedest, "E" & linedest).Select
ActiveSheet.Paste
'get the previous round number and increment it
iRoundNumber = Cells(linedest, 2).Value + 1
'paste this value into the destination cell - the VLOOkup function that we pasted next to it will automatically update the map to the new value
Cells(linedest, 2).Value = iRoundNumber
'get the previous map number and increase it
Cells(linedest, 3).Value = Cells(linedest, 3).Value + 6
'select the Round Robin sheet
Sheets("Round Robin").Select
'Look for the next round number (starting at column 8 and incremented by 3 for the next table
i = 3
While Cells(1, i).Value <> iRoundNumber
i = i + 3
Wend
'select the table below this round number
Range(Cells(3, i), Cells(2 + irowdepth, i + 1)).Select
Selection.Copy
' go back to the games spreadsheet
Sheets("Games").Select
'select the next table start position
Cells(linedest + 2, 2).Select
'paste the values into the table not the formulae!
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
'select the VLookup function from the previous table...
Range(Cells(linestart + 2, 4), Cells(linedest - 2, 15)).Select
'copy it..
Selection.Copy
'and paste in the first row of the second table
Cells(linedest + 2, 4).Select
ActiveSheet.Paste
'put the next map numbers in
For i = 1 To 5
Cells(linedest + i * 12, 3).Value = Cells(linedest, 3).Value + i
Next i
End Sub


Link to Individual Scores

Phantasia Altitudinis by Koontz1973
Q*quer by dolomite13
5 Lands of Shannara by Blakkrose
Bering Strait by lanyards
Democratic Republic of Congo by Avapocalypse
Gallic Wars by waauw
Homeworlds by dolomite13
War Of The Roses by Aleena
Baltic States by Bruceswar
District of Alaska by Seamus76
Ethiopia by cairnswk
Krazy Kingdoms by dolomite13
Rail S America by cairnswk
Research & Conquer by isaiah40
Ring of Fire by vaughn03
Spanish Amarda by cairnswk
Stronghold (GCCM Winner) by ManBungalow
WWI: Gallipoli by cairnswk

fixed, and thank you!agentcom wrote:Another great issue.
Minor note: At the very end, the link to the interview with jricart is mislabeled but links to the right place.
Great job Dispatch!
It wasn't a complete guess. I swear I remember talking to you about it sometime!DoomYoshi wrote:Wow. rds guessed me right.