Two Plus Two Publishing LLC Two Plus Two Publishing LLC
 

Go Back   Two Plus Two Poker Forums > >

Two Plus Two Pokercast Discussions about the Two Plus Two Pokercast featuring interactions with the weekly special guests.

Reply
 
Thread Tools Display Modes
Old 06-07-2017, 09:38 AM   #101
WesleyNobels
newbie
 
Join Date: May 2017
Posts: 16
Re: **WSOP FANTASY LEAGUE 2017 - SWEAT THREAD**

If you want to look at my fantasy league: https://docs.google.com/spreadsheets...it?usp=sharing
WesleyNobels is offline   Reply With Quote
Old 06-07-2017, 12:00 PM   #102
ByeByeJoe
centurion
 
Join Date: Aug 2006
Posts: 198
Re: **WSOP FANTASY LEAGUE 2017 - SWEAT THREAD**

Go Abe!!!
ByeByeJoe is offline   Reply With Quote
Old 06-07-2017, 12:12 PM   #103
PeteBlow
Pooh-Bah
 
Join Date: May 2012
Location: Guildford, UK
Posts: 5,917
Re: **WSOP FANTASY LEAGUE 2017 - SWEAT THREAD**

Maybe Pokergo are running the POY. They seem to be into giving incomplete coverage.
PeteBlow is offline   Reply With Quote
Old 06-07-2017, 04:25 PM   #104
AdamSchwartz
Shippy McShiperson
 
AdamSchwartz's Avatar
 
Join Date: Dec 2007
Location: 2 twins no cups
Posts: 8,469
Re: **WSOP FANTASY LEAGUE 2017 - SWEAT THREAD**

shots fired
AdamSchwartz is offline   Reply With Quote
Old 06-07-2017, 05:32 PM   #105
AllInNTheDark
old hand
 
AllInNTheDark's Avatar
 
Join Date: Jun 2011
Location: Pacific coast
Posts: 1,483
Re: **WSOP FANTASY LEAGUE 2017 - SWEAT THREAD**

Miami John finally in an event (HORSE), which helps make up for Doyle faking me out.
Sweating Benny & ODB in NLSD.
AllInNTheDark is offline   Reply With Quote
Old 06-07-2017, 06:52 PM   #106
PeteBlow
Pooh-Bah
 
Join Date: May 2012
Location: Guildford, UK
Posts: 5,917
Re: **WSOP FANTASY LEAGUE 2017 - SWEAT THREAD**

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
PeteBlow is offline   Reply With Quote
Old 06-07-2017, 09:43 PM   #107
ByeByeJoe
centurion
 
Join Date: Aug 2006
Posts: 198
Re: **WSOP FANTASY LEAGUE 2017 - SWEAT THREAD**

More importantly it gives me a 1st
ByeByeJoe is offline   Reply With Quote
Old 06-07-2017, 11:06 PM   #108
WayAbvPar
Pooh-Bah
 
WayAbvPar's Avatar
 
Join Date: Aug 2003
Location: Getting Headlined by Puppet Shows
Posts: 4,064
Re: **WSOP FANTASY LEAGUE 2017 - SWEAT THREAD**

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.
WayAbvPar is offline   Reply With Quote
Old 06-07-2017, 11:48 PM   #109
PeteBlow
Pooh-Bah
 
Join Date: May 2012
Location: Guildford, UK
Posts: 5,917
Re: **WSOP FANTASY LEAGUE 2017 - SWEAT THREAD**

Boom. David Bach wins the dealers choice.

(You're welcome Adam)
PeteBlow is offline   Reply With Quote
Old 06-08-2017, 12:28 AM   #110
WayAbvPar
Pooh-Bah
 
WayAbvPar's Avatar
 
Join Date: Aug 2003
Location: Getting Headlined by Puppet Shows
Posts: 4,064
Re: **WSOP FANTASY LEAGUE 2017 - SWEAT THREAD**

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
WayAbvPar is offline   Reply With Quote
Old 06-08-2017, 12:45 AM   #111
PeteBlow
Pooh-Bah
 
Join Date: May 2012
Location: Guildford, UK
Posts: 5,917
Re: **WSOP FANTASY LEAGUE 2017 - SWEAT THREAD**

Quote:
Originally Posted by xander biscuits View Post
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?
PeteBlow is offline   Reply With Quote
Old 06-08-2017, 07:16 AM   #112
xander biscuits
watching a movie
 
xander biscuits's Avatar
 
Join Date: Oct 2009
Location: Lebanon
Posts: 21,987
Re: **WSOP FANTASY LEAGUE 2017 - SWEAT THREAD**

**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
xander biscuits is offline   Reply With Quote
Old 06-08-2017, 09:29 AM   #113
AllInNTheDark
old hand
 
AllInNTheDark's Avatar
 
Join Date: Jun 2011
Location: Pacific coast
Posts: 1,483
Re: **WSOP FANTASY LEAGUE 2017 - SWEAT THREAD**

Quote:
Originally Posted by xander biscuits View Post
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.
AllInNTheDark is offline   Reply With Quote
Old 06-08-2017, 09:33 AM   #114
xander biscuits
watching a movie
 
xander biscuits's Avatar
 
Join Date: Oct 2009
Location: Lebanon
Posts: 21,987
Re: **WSOP FANTASY LEAGUE 2017 - SWEAT THREAD**

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(???)
xander biscuits is offline   Reply With Quote
Old 06-08-2017, 11:32 AM   #115
jankynoname
centurion
 
Join Date: May 2011
Posts: 151
Re: **WSOP FANTASY LEAGUE 2017 - SWEAT THREAD**

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...
jankynoname is offline   Reply With Quote
Old 06-08-2017, 11:36 AM   #116
FerencL
journeyman
 
Join Date: Apr 2010
Location: Vancouver
Posts: 394
Re: **WSOP FANTASY LEAGUE 2017 - SWEAT THREAD**

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?
FerencL is offline   Reply With Quote
Old 06-08-2017, 12:52 PM   #117
PeteBlow
Pooh-Bah
 
Join Date: May 2012
Location: Guildford, UK
Posts: 5,917
Re: **WSOP FANTASY LEAGUE 2017 - SWEAT THREAD**

Quote:
Originally Posted by FerencL View Post
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.
PeteBlow is offline   Reply With Quote
Old 06-08-2017, 03:19 PM   #118
FerencL
journeyman
 
Join Date: Apr 2010
Location: Vancouver
Posts: 394
Re: **WSOP FANTASY LEAGUE 2017 - SWEAT THREAD**

Quote:
Originally Posted by PeteBlow View Post
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.
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.
FerencL is offline   Reply With Quote
Old 06-08-2017, 03:44 PM   #119
xander biscuits
watching a movie
 
xander biscuits's Avatar
 
Join Date: Oct 2009
Location: Lebanon
Posts: 21,987
Re: **WSOP FANTASY LEAGUE 2017 - SWEAT THREAD**

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.
xander biscuits is offline   Reply With Quote
Old 06-09-2017, 12:36 AM   #120
FerencL
journeyman
 
Join Date: Apr 2010
Location: Vancouver
Posts: 394
Re: **WSOP FANTASY LEAGUE 2017 - SWEAT THREAD**

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?
FerencL is offline   Reply With Quote
Old 06-09-2017, 01:53 AM   #121
jankynoname
centurion
 
Join Date: May 2011
Posts: 151
Re: **WSOP FANTASY LEAGUE 2017 - SWEAT THREAD**

Quote:
Originally Posted by xander biscuits View Post
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!
jankynoname is offline   Reply With Quote
Old 06-09-2017, 02:27 AM   #122
xander biscuits
watching a movie
 
xander biscuits's Avatar
 
Join Date: Oct 2009
Location: Lebanon
Posts: 21,987
Re: **WSOP FANTASY LEAGUE 2017 - SWEAT THREAD**

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
xander biscuits is offline   Reply With Quote
Old 06-09-2017, 03:39 AM   #123
PeteBlow
Pooh-Bah
 
Join Date: May 2012
Location: Guildford, UK
Posts: 5,917
Re: **WSOP FANTASY LEAGUE 2017 - SWEAT THREAD**

Thanks to both of you for your efforts.
PeteBlow is offline   Reply With Quote
Old 06-09-2017, 03:56 AM   #124
xander biscuits
watching a movie
 
xander biscuits's Avatar
 
Join Date: Oct 2009
Location: Lebanon
Posts: 21,987
Re: **WSOP FANTASY LEAGUE 2017 - SWEAT THREAD**

This looks to be the highest scoring team:

patstap2 
Daniel Negreanu134
Alan Ari Engel0
Doug Polk223
Jason Somerville0
Barry Greenstein148
Andy Frankenberger0
Greg Raymer49.2
Dan Shak55.2
Dan Heimiller77.6
Kyle Julius35.7
Total722

and the good news for patstap2 is that this doesn't even include the tag team yet...
xander biscuits is offline   Reply With Quote
Old 06-09-2017, 08:47 AM   #125
patstap2
journeyman
 
Join Date: May 2012
Location: formerly patstap (pre 2+2 hacking)
Posts: 206
Re: **WSOP FANTASY LEAGUE 2017 - SWEAT THREAD**

Quote:
Originally Posted by xander biscuits View Post
This looks to be the highest scoring team:

patstap2 
Daniel Negreanu134
Alan Ari Engel0
Doug Polk223
Jason Somerville0
Barry Greenstein148
Andy Frankenberger0
Greg Raymer49.2
Dan Shak55.2
Dan Heimiller77.6
Kyle Julius35.7
Total722

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?
patstap2 is offline   Reply With Quote

Reply
      

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 01:46 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © 2008-2010, Two Plus Two Interactive
 
Poker Players - Streaming Live Online