POG PUB JULY 2017 (LC;NSFW): I, for one, welcome our new JM3 overlord - Page 4

Two Plus Two Forums Sports and Games Puzzles and Other Games

POG PUB JULY 2017 (LC;NSFW): I, for one, welcome our new JM3 overlord

Closed Subscribe

...

Page 4 of 19

1 2 3 4 5 6 7 8 9 14

Page 4 of 19

1 2 3 4 5 6 7 8 9 14

07-05-2017 , 10:51 PM

#76

JMurder3

not god, probably jebus

Join Date: Mar 2007 Posts: 53,649

Quote:

Originally Posted by Kaze13

nah, just a good friend from college. i know a couple people that used to pub at least knew him

Ah, that's cool. Had dinner with him at a TWSS meetup. Nice guy. G'luck to him.

07-06-2017 , 08:11 AM

#77

Hero Value

BBV Series Inaugural Champ

Join Date: Apr 2011 Posts: 9,258

Also friends with him. Gg Ryan.

07-06-2017 , 06:33 PM

#78

rtspurs

Stats Amore

Join Date: Feb 2015 Posts: 20,684

Need some expert excel help please...

So here is a list of sheep players, scores and ranks:

What I want to do is grab the rank (column C) of each player and input automatically into column P (leaving players who didn't play blank). At the moment I just input the rank manually, like column N, and it automatically makes it a score 0-100, like column O.

So I need some sort of magic formula for column P that finds A4 (if lines guy) in a range of A315:A359 and inputs his rank (corresponding column C in 315:359) for that game or leaves it blank if he didn't play

07-06-2017 , 06:39 PM

#79

necro

Carpal \'Tunnel

Join Date: Mar 2011 Posts: 10,467

hi everyone

07-06-2017 , 06:39 PM

#80

xander biscuits

watching a movie

Join Date: Oct 2009 Posts: 39,746

Anyone got any ideas what I should write for my 20k post?

07-06-2017 , 06:41 PM

#81

Bloobird

Carpal \'Tunnel

Join Date: May 2012 Posts: 24,250

hi necro!

07-06-2017 , 06:42 PM

#82

soah

Unexpected

Join Date: Jun 2004 Posts: 61,667

can it be a necro bump if the thread was already at the top of the page?

07-06-2017 , 06:44 PM

#83

necro

Carpal \'Tunnel

Join Date: Mar 2011 Posts: 10,467

Quote:

Originally Posted by Bloobird

hi necro!

*waves*

07-06-2017 , 06:44 PM

#84

Bloobird

Carpal \'Tunnel

Join Date: May 2012 Posts: 24,250

spurs:=IFERROR(INDEX(C315:C359,MATCH(A4,A315:A359, 0)),"")

should do the trick I think?

07-06-2017 , 06:44 PM

#85

IAmRobik

Carpal \'Tunnel

Join Date: Nov 2013 Posts: 12,198

bye *******

07-06-2017 , 06:44 PM

#86

necro

Carpal \'Tunnel

Join Date: Mar 2011 Posts: 10,467

we need to have another pog london meetup, live ww is amazing fun

07-06-2017 , 07:24 PM

#87

rtspurs

Stats Amore

Join Date: Feb 2015 Posts: 20,684

Quote:

Originally Posted by Bloobird

spurs:=IFERROR(INDEX(C315:C359,MATCH(A4,A315:A359, 0)),"")

should do the trick I think?

You're a wizard Bloo! Seems to work perfectly

07-07-2017 , 09:29 AM

#88

eyebooger

Join Date: May 2010 Posts: 58,700

In Hero Value news:

Looks to be 8th out of 102 remaining.

07-07-2017 , 09:52 AM

#89

Sun Tzu

laconic

Join Date: Jun 2008 Posts: 84,770

getting a 5 on AP calc BC even though my class was only for AB is probably still my greatest achievement

07-07-2017 , 10:42 AM

#90

Willi

Carpal \'Tunnel

Join Date: Jan 2009 Posts: 41,524

My vacation started finally.

07-07-2017 , 11:08 AM

#91

Bloobird

Carpal \'Tunnel

Join Date: May 2012 Posts: 24,250

Quote:

Originally Posted by necro

we need to have another pog london meetup, live ww is amazing fun

07-07-2017 , 11:15 AM

#92

JMurder3

not god, probably jebus

Join Date: Mar 2007 Posts: 53,649

Quote:

Originally Posted by eyebooger

In Hero Value news:

Looks to be 8th out of 102 remaining.

Revealing a SHEEP in 45 minutes if anyone wants to play.

07-07-2017 , 11:34 AM

#93

gambit8888

Lack'n in some direction

Join Date: Aug 2008 Posts: 45,159

Quote:

Originally Posted by Willi

My vacation started finally.

Nice. What are your plans for vacation?

07-07-2017 , 11:42 AM

#94

Willi

Carpal \'Tunnel

Join Date: Jan 2009 Posts: 41,524

Quote:

Originally Posted by gambit8888

Nice. What are your plans for vacation?

Just rest. This audit season was prolly even harder than my year in army. I am super tired.

07-07-2017 , 11:58 AM

#95

Mark_K

Fast Food Value KING

Join Date: May 2006 Posts: 28,213

Quote:

Originally Posted by Sun Tzu

getting a 5 on AP calc BC even though my class was only for AB is probably still my greatest achievement

It amazes me that Calc BC is the highest scoring of all AP tests.

I think something like 42% get 5's

07-07-2017 , 12:02 PM

#96

Mark_K

Fast Food Value KING

Join Date: May 2006 Posts: 28,213

Quote:

Originally Posted by Willi

Just rest. This audit season was prolly even harder than my year in army. I am super tired.

A perfect time to play Kerbal Space Program!

Enjoy your well deserved break!

07-07-2017 , 01:15 PM

#97

Sun Tzu

laconic

Join Date: Jun 2008 Posts: 84,770

Quote:

Originally Posted by Mark_K

It amazes me that Calc BC is the highest scoring of all AP tests.

I think something like 42% get 5's

that's interesting

it makes sense though since anyone who doesn't know their stuff would take the AB instead

what's the ratio of people taking the 2 exams?

07-07-2017 , 01:28 PM

#98

Mark_K

Fast Food Value KING

Join Date: May 2006 Posts: 28,213

Quote:

Originally Posted by Sun Tzu

that's interesting

it makes sense though since anyone who doesn't know their stuff would take the AB instead

what's the ratio of people taking the 2 exams?

For 2017:
317,000 took AB
133,000 took BC

Again, I'm surprised. I figured the ratio would have been larger. Also I wonder if it is possible to take both the Calc AB and BC tests? Based on the small ratio I'm assuming no.

https://www.totalregistration.net/AP...tributions.php

edit: I found the answer to my taking both tests question... Since BC already gives an AB subscore, it's all inclusive.

Last edited by Mark_K; 07-07-2017 at 01:45 PM.