Lurker > Moonroof

LurkerFAQs, Active DB, DB1, DB2, DB3, Database 4 ( 07.23.2018-12.31.2018 ), DB5, DB6, DB7, DB8, DB9, DB10, DB11, DB12, Clear
Board List
Page List: 1, 2, 3, 4, 5, 6, 7, 8 ... 12
TopicDid anyone get eother of today's matches correct
Moonroof
12/02/18 11:59:19 AM
#1
On their original bracket? Tifa is ruining everything while I dont think anyone had Snake losing to Zelda.
TopicCrono vs. Mega Man
Moonroof
12/02/18 11:57:15 AM
#16
Bump
TopicIf It Were Up to Board 8: Zelda vs. Magus and Miles Edgeworth vs. Mario
Moonroof
12/01/18 7:34:50 PM
#14
Magus
Mario
TopicWhen do we find out who all the DLC Smash characters are?
Moonroof
12/01/18 7:28:00 PM
#8
Nice, I always liked Earthbound. Do you think the DLC characters are going to be Paula, Jeff, Poo, Dr. Andonuts, and Giygas?
TopicWhen do we find out who all the DLC Smash characters are?
Moonroof
12/01/18 6:46:00 PM
#3
Snrkiko? More like snarky kiddo.
TopicWhen do we find out who all the DLC Smash characters are?
Moonroof
12/01/18 6:43:57 PM
#1
The Smash board is very mean and they dont answer my questions. So I will ask you guys. Also, what other DLC is there in the game?
TopicIf It Were Up to Board 8: Vivi vs. Mega Man and Cloud Strife vs. Crono
Moonroof
12/01/18 9:36:31 AM
#46
Vivi
Crono
TopicCrono vs. Mega Man
Moonroof
12/01/18 9:07:32 AM
#13
Bump
TopicCan you see the match pics after voting?
Moonroof
11/30/18 8:46:41 PM
#1
I cant. Granted I use mobile. On the results page, it just shows the first pics from the intros.
TopicI cant believe im going to spend $423 on Nintendo
Moonroof
11/30/18 8:42:07 PM
#9
Im not even close.
TopicI cant believe im going to spend $423 on Nintendo
Moonroof
11/30/18 8:36:08 PM
#7
Me too. I will become Sir Smash-A-Lot.
TopicI cant believe im going to spend $423 on Nintendo
Moonroof
11/30/18 8:23:12 PM
#4
The thing is, Im very responsible and have a great job that detracts from my ability to play video games. Is this a smart investment?
TopicI cant believe im going to spend $423 on Nintendo
Moonroof
11/30/18 8:04:14 PM
#1
Switch, Smash, GameCube controller and adaptor, Switch screen protector.

Worth?
TopicCrono vs. Mega Man
Moonroof
11/30/18 4:51:53 PM
#1
Crono Vs. Mega Man - Results (8 votes)
Crono
75% (6 votes)
6
Mega Man
25% (2 votes)
2
Last time, a vast majority of you voted Crono as being the weakest N9 member and hardly any of you voted for Mega Man.

Have the results swayed your minds with respect to these two? Who wins?
TopicI need Excel help
Moonroof
11/30/18 10:16:57 AM
#35
The neat thing too is that as I continue to add more games, all I have to do is swap some names around and the formula automatically updates the count for me.

I created a Cell Highlight rule to show me when people played with other people 0 times or greater than 5 times. I want the teams to be even, but I also want everyone to play with each other at least once (but not too many times either!). So its tricky, hence the need for this chart.
TopicI need Excel help
Moonroof
11/30/18 9:27:22 AM
#32
I did it :)

Thanks again, friend!
TopicI need Excel help
Moonroof
11/29/18 7:33:01 PM
#31
I cant wait to test this out tomorrow.
TopicI need Excel help
Moonroof
11/29/18 7:27:50 PM
#29
Niiiiice.
TopicI need Excel help
Moonroof
11/29/18 7:21:34 PM
#27
So I just copy and paste the same formula in each and every cell?
TopicI need Excel help
Moonroof
11/29/18 7:16:30 PM
#23
Sorry. So I put it in the first cell or N2 then? Do I put it in every single blank cell within the last screen shot? I cant see which is N2 in your pic.
TopicI need Excel help
Moonroof
11/29/18 7:13:32 PM
#20
So do I change the formula at all as I proceed downward?
TopicI need Excel help
Moonroof
11/29/18 7:12:39 PM
#19
Ingenious! I knew I could rely on you.
TopicI need Excel help
Moonroof
11/29/18 7:05:16 PM
#16
So what does concatenating do?
TopicI need Excel help
Moonroof
11/29/18 7:00:44 PM
#15
Whoaaaaa. Okay, awesome! I will test it out improve when I can get back to my computer. Ill probably have questions.

Thanks, friend.
TopicContest Stats and Discussion - Part 1312
Moonroof
11/29/18 6:22:02 PM
#498
Nonsense23 is a cyber bully.
TopicContest Stats and Discussion - Part 1312
Moonroof
11/29/18 6:18:29 PM
#488
Nanis23 posted...
Moonroof posted...
Nanis23 posted...
Moonroof posted...
Everyone is mocking me and while I find it funny, my now 130 friends dont. Some of them wont vote and others will vote for Zelda to spite you all. Sorry.

You just don't know when to stop?
The joke is not funny anymore
I mean, it never was, but at least you tried
Now you are just beating a dead horse


Are you okay?

No I am sad that you passed me in the leaderboard


Youre not bad, Im just really good.
TopicContest Stats and Discussion - Part 1312
Moonroof
11/29/18 6:16:47 PM
#485
Nanis23 posted...
Moonroof posted...
Everyone is mocking me and while I find it funny, my now 130 friends dont. Some of them wont vote and others will vote for Zelda to spite you all. Sorry.

You just don't know when to stop?
The joke is not funny anymore
I mean, it never was, but at least you tried
Now you are just beating a dead horse


Are you okay?
TopicContest Stats and Discussion - Part 1312
Moonroof
11/29/18 6:16:02 PM
#483
Im very clever.
TopicContest Stats and Discussion - Part 1312
Moonroof
11/29/18 6:14:35 PM
#478
Everyone is mocking me and while I find it funny, my now 130 friends dont. Some of them wont vote and others will vote for Zelda to spite you all. Sorry.
TopicI need Excel help
Moonroof
11/29/18 6:11:45 PM
#11
Thanks friend.
TopicContest Stats and Discussion - Part 1312
Moonroof
11/29/18 6:10:33 PM
#468
I decided not to be sensitive and move forward anyway.

But now I see Wylvane has more. So its pointless. Sorry guys.
TopicContest Stats and Discussion - Part 1312
Moonroof
11/29/18 6:06:11 PM
#463
It took an inordinate amount of organizing to corral that many people. But redrocket took it for granted and now Im hurt.
TopicContest Stats and Discussion - Part 1312
Moonroof
11/29/18 6:03:19 PM
#458
If redrocket offers a humbling apology, I will reconsider.
TopicContest Stats and Discussion - Part 1312
Moonroof
11/29/18 6:02:48 PM
#457
You know what? Im telling all of my now 119 friends to not partake in this since everyone is bullying me. Suture yourselves.
TopicContest Stats and Discussion - Part 1312
Moonroof
11/29/18 5:59:30 PM
#452
Just got up to 115.
TopicI need Excel help
Moonroof
11/29/18 5:58:51 PM
#9
I have been doing it manually so far but its rrally hard when I shuffle around players.
TopicI need Excel help
Moonroof
11/29/18 5:56:43 PM
#7
Oh. Such as what?
TopicI need Excel help
Moonroof
11/29/18 5:56:18 PM
#6
How do I give the color criterion to indicate whos on whose team?
TopicI need Excel help
Moonroof
11/29/18 5:54:55 PM
#4
Its a 13x8 table. The top row is the name of each game. Each column contains the names of the 12 players, color-coded to show whos on whose team. I dont have a pic.
TopicI need Excel help
Moonroof
11/29/18 5:46:35 PM
#1
I cant find a solution online anywhere.

I have eight teams, each containing different variations of the same 12 people. Some games are 6v6, some are 4v4v4, and some are 3v3v3v3.

I am trying to calculate how many times each player plays on another players team (e.g., John plays with Carl 4 times, Tracy plays with Kim 2 times, etc.).

I color-coded my spreadsheet to indicate which and how many players are on each team, but I cannot figure out a way to translate this into a Pivot Table.

Anyone know?
TopicContest Stats and Discussion - Part 1312
Moonroof
11/29/18 5:42:19 PM
#447
111 people!
TopicContest Stats and Discussion - Part 1312
Moonroof
11/29/18 5:32:05 PM
#442
I hope you learned your lesson.

Currently up to 99 btw.
TopicContest Stats and Discussion - Part 1312
Moonroof
11/29/18 5:24:13 PM
#438
Nanis23 posted...
Moonroof posted...
I have 87 friends waiting to vote for Snake at 6:58 Eastern. Its not enough though. Were trying to get more.

I wanted this to be real and actually thought for a moment "it might be.." then I read the username


Im serious. Were up to 93 now. Youre just jealous Im ahead of you in the leaderboard.
TopicContest Stats and Discussion - Part 1312
Moonroof
11/29/18 5:16:11 PM
#435
I have 87 friends waiting to vote for Snake at 6:58 Eastern. Its not enough though. Were trying to get more.
TopicIs the Noble Nine falling apart?
Moonroof
11/28/18 10:42:40 PM
#2
No. Its stronger than ever
TopicNext contest needs a per-publisher cap on nominations/entrants
Moonroof
11/28/18 10:37:16 PM
#3
Nintendo and Square would 95/5 or 90/10 a majority of the field.
TopicWhich match will be the closest?
Moonroof
11/28/18 9:42:08 PM
#15
So far, everyone has been way off.
TopicNoble Nine is still intact
Moonroof
11/28/18 9:25:26 PM
#2
Duh. N9 will be broken if Snake loses today, including the raw vote.
TopicWait, it's Sonic vs Auron?
Moonroof
11/28/18 4:43:22 PM
#9
TC is not well-informed. Hes very naive.
TopicWhich match will be the closest?
Moonroof
11/28/18 2:41:22 PM
#14
Bump
Board List
Page List: 1, 2, 3, 4, 5, 6, 7, 8 ... 12