**WSOP FANTASY LEAGUE 2017 - SWEAT THREAD** - Page 5 - Two Plus Two Pokercast

Two Plus Two Forums Two Plus Two Two Plus Two Pokercast

**WSOP FANTASY LEAGUE 2017 - SWEAT THREAD**

...

Page 5 of 19

First

1 2 3 4 5 6 7 8 9 10 15

Last

Page 5 of 19

First

1 2 3 4 5 6 7 8 9 10 15

Last

06-07-2017 , 09:38 AM

#101

WesleyNobels

newbie

Join Date: May 2017 Posts: 16

If you want to look at my fantasy league: https://docs.google.com/spreadsheets...it?usp=sharing

06-07-2017 , 12:00 PM

#102

ByeByeJoe

journeyman

Join Date: Aug 2006 Posts: 218

Go Abe!!!

06-07-2017 , 12:12 PM

#103

PeteBlow

Carpal \'Tunnel

Join Date: May 2012 Posts: 14,550

Maybe Pokergo are running the POY. They seem to be into giving incomplete coverage.

06-07-2017 , 04:25 PM

#104

AdamSchwartz

Shippy McShiperson

Join Date: Dec 2007 Posts: 8,521

shots fired

06-07-2017 , 05:32 PM

#105

AllInNTheDark

veteran

Join Date: Jun 2011 Posts: 3,256

Miami John finally in an event (HORSE), which helps make up for Doyle faking me out.
Sweating Benny & ODB in NLSD.

06-07-2017 , 06:52 PM

#106

PeteBlow

Carpal \'Tunnel

Join Date: May 2012 Posts: 14,550

Daniel gets a lot of us a 2nd place.
David Bach with a massive chiplead 6 handed in the dealers choice is working out well too

06-07-2017 , 09:43 PM

#107

ByeByeJoe

journeyman

Join Date: Aug 2006 Posts: 218

More importantly it gives me a 1st

06-07-2017 , 11:06 PM

#108

WayAbvPar

Pooh-Bah

Join Date: Aug 2003 Posts: 4,073

Uniqueness score of 43. Even I haven't heard of most of my team!

Rep Porter is running deep in $1,500 No-Limit 2-7 Lowball Draw, (and Dan Shak cashed in something), so I won't get skunked for the first week.

06-07-2017 , 11:48 PM

#109

PeteBlow

Carpal \'Tunnel

Join Date: May 2012 Posts: 14,550

Boom. David Bach wins the dealers choice.

(You're welcome Adam)

06-08-2017 , 12:28 AM

#110

WayAbvPar

Pooh-Bah

Join Date: Aug 2003 Posts: 4,073

And I sweated Rep right out of the tournament. Sorry!

At least he outlasted Hellmuth.

Last edited by WayAbvPar; 06-08-2017 at 12:28 AM. Reason: f Hellmuth, that's why

06-08-2017 , 12:45 AM

#111

PeteBlow

Carpal \'Tunnel

Join Date: May 2012 Posts: 14,550

Quote:

Originally Posted by xander biscuits

If you add up the numbers from that table of the players in your team then you'll get an overall uniqueness number for your team (lower total = more unique, score of 10 = completely unique)

My score is 119 which is on the high side of the average which is 80

Finally got around to adding mine up.
120

Anyone higher?

06-08-2017 , 07:16 AM

#112

xander biscuits

watching a movie

Join Date: Oct 2009 Posts: 39,745

**EXCEL HELP NEEDED**

I have copied all the POY results from the wsop website for the individual events into excel. The formatting is pretty rubbish and it put everything in a single column. I removed all the unnecessary information and I now have a sheet like this for each event:

I have also made this sheet:

How do I get the appropriate data from the first sheet into the 2nd sheet?

TIA

06-08-2017 , 09:29 AM

#113

AllInNTheDark

veteran

Join Date: Jun 2011 Posts: 3,256

Quote:

Originally Posted by xander biscuits

How do I get the appropriate data from the first sheet into the 2nd sheet?

I think you want to insert a column to the left of the player name on the sheet for each event. Then you want to have the points for that event to the left of the player's name, which can be done easily by formula. Then in the main summary page, you want to use the VLOOKUP function to obtain the data from the individual sheets. All in all, quite a PITA though.

Through yest.:

Benny 101.59
ODB 145.64
Marco 99.46
Mouth 71.82
TOTAL 418.51

Sweating Marco & ETay in day 2 of HORSE. Adam Owen & DU still without a cash.

06-08-2017 , 09:33 AM

#114

xander biscuits

watching a movie

Join Date: Oct 2009 Posts: 39,745

Sorry to be an old useless person but would you mind showing me exactly what I should type in to get the information in the right place.

=VLOOKUP(???)

06-08-2017 , 11:32 AM

#115

jankynoname

centurion

Join Date: May 2011 Posts: 168

I could probably help out with this if you need a hand. Spend all day writing vlookups and index(match(match)) anyways so what's a few more...

06-08-2017 , 11:36 AM

#116

FerencL

Carpal \'Tunnel

Join Date: Apr 2010 Posts: 6,922

Sorry if I'm repeating myself but the official results on WSOP.com don't have POY points for event #2 (and #10). Where did you find them?

06-08-2017 , 12:52 PM

#117

PeteBlow

Carpal \'Tunnel

Join Date: May 2012 Posts: 14,550

Quote:

Originally Posted by FerencL

Sorry if I'm repeating myself but the official results on WSOP.com don't have POY points for event #2 (and #10). Where did you find them?

There's a long hand way of working them out.
For example, Daniel currently has 160.4 points, 133.8 of which come from the 10k 08. He therefore got 26.6 for the tag team - which kind of makes sense if you split the team points 4 ways.

06-08-2017 , 03:19 PM

#118

FerencL

Carpal \'Tunnel

Join Date: Apr 2010 Posts: 6,922

Quote:

Originally Posted by PeteBlow

That sounds like a lot of work. Once you can verify Daniel's points, then you can run the rest through the calculator that they provided. You'll need that for the 1K tag team because they won't be in the Top 100. The good news is that most of the players who cashed the 1K probably weren't picked in the draft.

06-08-2017 , 03:44 PM

#119

xander biscuits

watching a movie

Join Date: Oct 2009 Posts: 39,745

I have not yet got any data for the tag team events. I will tweet at WSOP and KevMath and ask what the points are.

Thanks for the help offer janky, I've emailed you.

06-09-2017 , 12:36 AM

#120

FerencL

Carpal \'Tunnel

Join Date: Apr 2010 Posts: 6,922

Ran a database program to get a complete list of POY rankings (excluding tag teams) and found something interesting: the WSOP.com numbers don't agree with the Top 100 numbers. Thomas Pomponio is #1 either way but he's 347.08 on the Top 100 but 347.6 on WSOP.com. They differ by 1/2 point. If you use their calculator, wsop.com has the correct number - Top 100 is wrong. Which is official?

06-09-2017 , 01:53 AM

#121

jankynoname

centurion

Join Date: May 2011 Posts: 168

Quote:

Originally Posted by xander biscuits

I have not yet got any data for the tag team events. I will tweet at WSOP and KevMath and ask what the points are.

Thanks for the help offer janky, I've emailed you.

Cool, just sent you some scoring data. Hopefully you get it because I'm off to a bachelor party tomorrow!

06-09-2017 , 02:27 AM

#122

xander biscuits

watching a movie

Join Date: Oct 2009 Posts: 39,745

We have a score update!!

https://docs.google.com/spreadsheets...#gid=584156833

It's all thanks to jankynoname who did this

It's for events up to #11 excluding the tag teams (we're still trying to figure out what's going on with them).

I'm just putting it straight up there because it's been a long time with no updates, but I would advise everyone to check their own team and players (mistakes can happen!)

When I get back from work I'll make it look prettier and get some sort of leader board that shows who's in 1st etc.

enjoy

06-09-2017 , 03:39 AM

#123

PeteBlow

Carpal \'Tunnel

Join Date: May 2012 Posts: 14,550

Thanks to both of you for your efforts.

06-09-2017 , 03:56 AM

#124

xander biscuits

watching a movie

Join Date: Oct 2009 Posts: 39,745

This looks to be the highest scoring team:

patstap2
Daniel Negreanu	134
Alan Ari Engel	0
Doug Polk	223
Jason Somerville	0
Barry Greenstein	148
Andy Frankenberger	0
Greg Raymer	49.2
Dan Shak	55.2
Dan Heimiller	77.6
Kyle Julius	35.7
Total	722

and the good news for patstap2 is that this doesn't even include the tag team yet...

06-09-2017 , 08:47 AM

#125

patstap2

journeyman

Join Date: May 2012 Posts: 261

Quote:

Originally Posted by xander biscuits

This looks to be the highest scoring team:

patstap2
Daniel Negreanu	134
Alan Ari Engel	0
Doug Polk	223
Jason Somerville	0
Barry Greenstein	148
Andy Frankenberger	0
Greg Raymer	49.2
Dan Shak	55.2
Dan Heimiller	77.6
Kyle Julius	35.7
Total	722

and the good news for patstap2 is that this doesn't even include the tag team yet...

My scores look to be correct (not counting the tag team events #2 & #10).

Does anyone know how much, if at all, Jason Somerville is planning on playing this summer?

Page 5 of 19

First

1 2 3 4 5 6 7 8 9 10 15

Last

...

Page 5 of 19

First

1 2 3 4 5 6 7 8 9 10 15

Last