NFL Vegas Contest Top 50 Leaders Picks Wk 16

[jgm4661]

Top 5 went 4-1 in week 15. 24-11 for the year or 69%.

Here are the most picked teams from the top 50 leaders. Please note spread differences. They have CAR -1.5 (vs -3.5) DET -6.5 (vs -8.5), DAL -3 (-3.5), STL -4.5 (-6.5) ,BUF -5.5 (-6.5) etc

Team	#	Line
CAR	32	1.5
DET	27	-6.5
DAL	21	-3
STL	17	-4.5
MIN	15	6.5
ARI	12	8
BUF	11	-5.5
ATL	8	6.5
GB	8	-10.5
HOU	8	5.5
KC	8	3
WAS	8	7.5
CIN	7	3
DEN	7	-3
JAX	7	-3
SD	7	1
OAK	6	5.5
BAL	5	-5.5
IND	5	3
PIT	5	-3
CHI	4	6.5
NYG	4	4.5
SF	4	-1
MIA	3	-6.5
TB	3	10.5
NO	2	-6.5
NYJ	2	10
SEA	2	-8
CLE	1	-1.5
NE	1	-10

 

[jgm4661]

Correction. They have CAR 1.5 vs -4 currently.

 

[cordial]

Thank you for compiling their picks...BOL to you...

 

[athan12]

Top 5 went 4-1 in week 15. 24-11 for the year or 69%.

Here are the most picked teams from the top 50 leaders. Please note spread differences. They have CAR -1.5 (vs -3.5) DET -6.5 (vs -8.5), DAL -3 (-3.5), STL -4.5 (-6.5) ,BUF -5.5 (-6.5) etc

Team	#	Line
CAR	32	1.5
DET	27	-6.5
DAL	21	-3
STL	17	-4.5
MIN	15	6.5
ARI	12	8
BUF	11	-5.5
ATL	8	6.5
GB	8	-10.5
HOU	8	5.5
KC	8	3
WAS	8	7.5
CIN	7	3
DEN	7	-3
JAX	7	-3
SD	7	1
OAK	6	5.5
BAL	5	-5.5
IND	5	3
PIT	5	-3
CHI	4	6.5
NYG	4	4.5
SF	4	-1
MIA	3	-6.5
TB	3	10.5
NO	2	-6.5
NYJ	2	10
SEA	2	-8
CLE	1	-1.5
NE	1	-10

Thank you for your work every week man. Your thread has been very helpful to this board.

I just have a question man. How do you do this chart? Do you like do them 1 by 1 and count them 1 by 1? What program or site do you use to do this kind of chart?

I was just wondering just so I can make my own chart just in case you go on vacation

 

[TheComputerGroup]

Good stuff JGM......when did you start compiling the top 5? I see the record is 24-11 ATS........

 

[jgm4661]

Good stuff JGM......when did you start compiling the top 5? I see the record is 24-11 ATS........

Hi Computer,

Started in week 8 but missed one week.

 

[OppieFreelie]

Actually this list doesn't help much because it does absolutely nothing if 2 teams are evenly picked and they happen to face each other.... and means even less if those 2 teams are towards the top of the list as well.

 

[jgm4661]

Thank you for your work every week man. Your thread has been very helpful to this board.

I just have a question man. How do you do this chart? Do you like do them 1 by 1 and count them 1 by 1? What program or site do you use to do this kind of chart?

I was just wondering just so I can make my own chart just in case you go on vacation

Hi athan,

You can do this in MS Excel relatively quickly if you are familiar w the program or know someone who is.

1 Copy and paste the values from the "Weekly picks' page on the NFL Westgate site into excel on page 1
https://www.westgatedestinations.co...e-las-vegas-hotel-casino/casino/supercontest/
2 Copy and paste the values for the standings using a mouse to select the top leaders into page 2
3 On p2 select the top 50 and delete any extra rows
4 On p2 use excel formula vlookup to lookup the picks from the "weekly picks p1 to copy the 5 picks over for each leader
5 Once you have all the picks for the top 50 you can copy and paste special to convert the formulas to values
6 Put all the picks into one column
7 Run a pivot table that groups and counts the picks for each team
8 you can then sort the pivot table from most to least # for each team

Ask anyone you know who is familiar w excel and they can do this for you in 5 minutes. if you have excel let me know and I can detail the steps more clearly.

 

[jgm4661]

Actually this list doesn't help much because it does absolutely nothing if 2 teams are evenly picked and they happen to face each other.... and means even less if those 2 teams are towards the top of the list as well.

They aren't usually. The top 5 are almost 70%.

 

[athan12]

Hi athan,

You can do this in MS Excel relatively quickly if you are familiar w the program or know someone who is.

1 Copy and paste the values from the "Weekly picks' page on the NFL Westgate site into excel on page 1
https://www.westgatedestinations.co...e-las-vegas-hotel-casino/casino/supercontest/
2 Copy and paste the values for the standings using a mouse to select the top leaders into page 2
3 On p2 select the top 50 and delete any extra rows
4 On p2 use excel formula vlookup to lookup the picks from the "weekly picks p1 to copy the 5 picks over for each leader
5 Once you have all the picks for the top 50 you can copy and paste special to convert the formulas to values
6 Put all the picks into one column
7 Run a pivot table that groups and counts the picks for each team
8 you can then sort the pivot table from most to least # for each team

Ask anyone you know who is familiar w excel and they can do this for you in 5 minutes. if you have excel let me know and I can detail the steps more clearly.

I use a different program but its like the excel. I'll try this procedure and let you know if I have a problem

 

[reddog49]

Top of the list got banged!

 

[BigHurt007]

Top of the list got banged!

Yep
Seems like Buff/Stl are the only ones left not to have crossed over the keys
Hopefully Dallas drops back to 3 by kick

 

[Cheddarforme]

Yep
Seems like Buff/Stl are the only ones left not to have crossed over the keys
Hopefully Dallas drops back to 3 by kick

Buy the .5 like I did....obviously didn't need it! But it's well worth the juice brah