Pick a Player Over/Under Points Game

[Redz]

My spreadsheet knows know limits!  I have the sheet set up now so I just punch in everyone's finish each night and it calculates all sorts of goodies for us.  Here is what I'm proposing for standings for playoffs purposes.  It's a 5 category rotisserie style scoring system.  I'll explain what everything means if anyone's interested.  Basically it balances average and cumulative performance.

If anyone knows how to convert a PDG to an image and can figure out how to link it as an image, let me know.  Thanks.

https://drive.google.com/file/d/0B2dc4y9oFlrqei1rUF9oNk5tbkk/view?usp=sharing

thanks for putting in that time and effort Redz!!  I can't open the document (hoping it's just due to my filters at work) but will try from home later. 

I know we're only halfway through the season but I'm open to suggestions from everyone who's played how they'd like to do it.  I believe in the past seedings were based on average daily +/- but I admit that I haven't tracked that at all and I don't see myself having the time to play catch up on it (although it looks like Redz has addressed that particular issue).

The years I was most involved we did an aggregate of your standings in both totals and average points based on the scoring system.  I haven't been keeping track of the actual +/- scores, just order of finish.

The way I'm keeping track should give a pretty good representation of who deserves to be where come seeding time, but we can always use just parts of it.  I just like finding ways to keep track and have excel do automated calculations. 

[Timdawgg]

1/22 picks
slamtheking - Trey Lyles, Utah: 4.9
Timdawgg- Kelly Olynyk, Celtics: 10.1

Thank you in advance for your help with paying out the TPs.

TPs owed -  slamtheking - 1, Redz - 1, Timdawgg - 7

[slamtheking]

1/22 picks
slamtheking - Trey Lyles, Utah: 4.9
Timdawgg- Kelly Olynyk, Celtics: 10.1


UPDATED
Thank you in advance for your help with paying out the TPs.

TPs owed -  slamtheking - 1, Redz - PAID, Timdawgg - 6

[33-00-32]

My spreadsheet knows know limits!  I have the sheet set up now so I just punch in everyone's finish each night and it calculates all sorts of goodies for us.  Here is what I'm proposing for standings for playoffs purposes.  It's a 5 category rotisserie style scoring system.  I'll explain what everything means if anyone's interested.  Basically it balances average and cumulative performance.

If anyone knows how to convert a PDG to an image and can figure out how to link it as an image, let me know.  Thanks.

https://drive.google.com/file/d/0B2dc4y9oFlrqei1rUF9oNk5tbkk/view?usp=sharing

thanks for putting in that time and effort Redz!!  I can't open the document (hoping it's just due to my filters at work) but will try from home later. 

I know we're only halfway through the season but I'm open to suggestions from everyone who's played how they'd like to do it.  I believe in the past seedings were based on average daily +/- but I admit that I haven't tracked that at all and I don't see myself having the time to play catch up on it (although it looks like Redz has addressed that particular issue).

The years I was most involved we did an aggregate of your standings in both totals and average points based on the scoring system.  I haven't been keeping track of the actual +/- scores, just order of finish.

The way I'm keeping track should give a pretty good representation of who deserves to be where come seeding time, but we can always use just parts of it.  I just like finding ways to keep track and have excel do automated calculations.

Gotta love the spreadsheets, haha! The one I was using for the past few years had grown into monster size with about 20 tabs. I was tracking all of the daily facts so that I didn't duplicate any of them from year to year. I added a bunch of automation so that it wrote the tables for me. My standings evolved to take into account a lot of what Redz is doing. It was a based on multiple factors and favored heavy usage and average ppg. I can't tell you how happy I am to not have to track them anymore, haha. Even with the automations I was spending quite a bit of time on it.

Nice job by both of you (Redz & Slam)!

[33-00-32]

1/22 picks
slamtheking - Trey Lyles, Utah: 4.9
Timdawgg- Kelly Olynyk, Celtics: 10.1
33-00-32 - Amar'e Stoudemire, Heat: 3.9


UPDATED
Thank you in advance for your help with paying out the TPs.

TPs owed -  slamtheking - PAID Redz - PAID, Timdawgg - 5

[mgent]

1/22 picks
slamtheking - Trey Lyles, Utah: 4.9
Timdawgg- Kelly Olynyk, Celtics: 10.1
33-00-32 - Amar'e Stoudemire, Heat: 3.9
MGent - IT, C's:  21.7

UPDATED
Thank you in advance for your help with paying out the TPs.

TPs owed -  slamtheking - PAID Redz - PAID, Timdawgg - 4

[Redz]

My spreadsheet knows know limits!  I have the sheet set up now so I just punch in everyone's finish each night and it calculates all sorts of goodies for us.  Here is what I'm proposing for standings for playoffs purposes.  It's a 5 category rotisserie style scoring system.  I'll explain what everything means if anyone's interested.  Basically it balances average and cumulative performance.

If anyone knows how to convert a PDG to an image and can figure out how to link it as an image, let me know.  Thanks.

https://drive.google.com/file/d/0B2dc4y9oFlrqei1rUF9oNk5tbkk/view?usp=sharing

thanks for putting in that time and effort Redz!!  I can't open the document (hoping it's just due to my filters at work) but will try from home later. 

I know we're only halfway through the season but I'm open to suggestions from everyone who's played how they'd like to do it.  I believe in the past seedings were based on average daily +/- but I admit that I haven't tracked that at all and I don't see myself having the time to play catch up on it (although it looks like Redz has addressed that particular issue).

The years I was most involved we did an aggregate of your standings in both totals and average points based on the scoring system.  I haven't been keeping track of the actual +/- scores, just order of finish.

The way I'm keeping track should give a pretty good representation of who deserves to be where come seeding time, but we can always use just parts of it.  I just like finding ways to keep track and have excel do automated calculations.

Gotta love the spreadsheets, haha! The one I was using for the past few years had grown into monster size with about 20 tabs. I was tracking all of the daily facts so that I didn't duplicate any of them from year to year. I added a bunch of automation so that it wrote the tables for me. My standings evolved to take into account a lot of what Redz is doing. It was a based on multiple factors and favored heavy usage and average ppg. I can't tell you how happy I am to not have to track them anymore, haha. Even with the automations I was spending quite a bit of time on it.

Nice job by both of you (Redz & Slam)!

Assuming I leave it alone and don't try to build the Excel Mahal this sheet will require less than a minute of work per day.  It's a peach!

[Redz]

1/22 picks
slamtheking - Trey Lyles, Utah: 4.9
Timdawgg- Kelly Olynyk, Celtics: 10.1
33-00-32 - Amar'e Stoudemire, Heat: 3.9
MGent - IT, C's:  21.7
Redz - Raul Neto, Jazz: 5.7



TPs owed -  Zippo

[Humble G]

1/22 picks
slamtheking - Trey Lyles, Utah: 4.9
Timdawgg- Kelly Olynyk, Celtics: 10.1
33-00-32 - Amar'e Stoudemire, Heat: 3.9
MGent - IT, C's:  21.7
Redz - Raul Neto, Jazz: 5.7
Humble G - Myles Turner, Pacers: 7.4

[slamtheking]

almost a full house tonight.  would have hit this season's grand slam of attendance if TB had joined in.

[slamtheking]

PAPOUG 
2015-2016 REGULAR SEASON
1/22/2016  Results

OVER
Humble G - Myles Turner, Pacers: 7.4/31 = +23.6

slamtheking - Trey Lyles, Utah: 4.9/10 = +5.1

Redz - Raul Neto, Jazz: 5.7/10 = +4.3

33-00-32 - Amar'e Stoudemire, Heat: 3.9/8 = +4.1

Timdawgg- Kelly Olynyk, Celtics: 10.1/12 = +1.9

MGent - Isaiah Thomas, Celtics:  21.7/22 = +0.3

UNDER

A good night.  6 players and everyone finished with a positive score


1 TP paid to Humble G for the win, (11 owed) 
0 TP paid to slamtheking for second (5 owed)
1 TP paid to Redz for third (3 owed)
1 TP paid to 33-00-32 for fourth (2 owed)
1 TP paid to Timdawgg for fifth (1 owed)
and the Doody Prize paid to Mgent 0 owed

Thank you in advance for your help with paying out the TPs.

TPs owed - Humble G - 11, slamtheking - 5, Redz - 3, 33-00-32 - 2, Timdawgg - 1   


PREVIOUS 7 WINNERS (VOID LIST)
Humble G - Myles Turner, Pacers: 7.4/31 = +23.6
 
Timdawgg- Devin Booker, Suns 8.7/24 = +15.3

Redz - Kelly Olynyk, Celtics: 9.9/18 = +8.1

slamtheking - Myles Turner, Indiana: 6.9/15  = +8.1

slamtheking - terrence Ross, Toronto: 7.9/12 = +4.1

slamtheking - CJ Miles, Indiana - 13.4/12 = -1.4

Humble G - Cole aldrich, clippers: 4.9/19 = +14.1

CURRENT WINS LIST
timdawgg - 20.5,  Redz - 8, Thirstyboots18 - 8.5, 33-00-32 - 8, Humble G - 12, slamtheking - 21, MGent - 3

[slamtheking]

1/23 picks:
slamtheking - Allen Crabbe, Portland: 11.1

Thank you in advance for your help with paying out the TPs.

TPs owed - Humble G - 11, slamtheking - 5, Redz - 3, 33-00-32 - 2, Timdawgg - 1 

[Redz]

1/23 picks:
slamtheking - Allen Crabbe, Portland: 11.1
Redz - Lebron James, Cavs:  25.0

TPs owed - zero

[slamtheking]

PAPOUG 
2015-2016 REGULAR SEASON
1/23/2016  Results

OVER
Redz - Lebron James, Cavs:  25.0/26 = +1.0

 

 
UNDER

slamtheking - Allen Crabbe, Portland: 11.1/6 = -5.1


1 TP paid to Redz for the win, (3 owed) 
0 TP paid to COULD HAVE BEEN YOU
and the Doody Prize not paid to slamtheking 1 owed

Thank you in advance for your help with paying out the TPs.

TPs owed - slamtheking - 1, Redz - 3


PREVIOUS 7 WINNERS (VOID LIST)
Redz - Lebron James, Cavs:  25.0/26 = +1.0

Humble G - Myles Turner, Pacers: 7.4/31 = +23.6
 
Timdawgg- Devin Booker, Suns 8.7/24 = +15.3

Redz - Kelly Olynyk, Celtics: 9.9/18 = +8.1

slamtheking - Myles Turner, Indiana: 6.9/15  = +8.1

slamtheking - terrence Ross, Toronto: 7.9/12 = +4.1

slamtheking - CJ Miles, Indiana - 13.4/12 = -1.4

CURRENT WINS LIST
timdawgg - 20.5,  Redz - 9, Thirstyboots18 - 8.5, 33-00-32 - 8, Humble G - 12, slamtheking - 21, MGent - 3

[slamtheking]

1/24 picks
slamtheking - Marcus Smart, Celtics: 8.7