Author Topic: 2009 CB NBA Draft as a fantasy basketball league.  (Read 22838 times)

0 Members and 0 Guests are viewing this topic.

2009 CB NBA Draft as a fantasy basketball league.
« on: November 04, 2009, 08:12:17 PM »

Offline nickagneta

  • James Naismith
  • *********************************
  • Posts: 48121
  • Tommy Points: 8800
  • President of Jaylen Brown Fan Club
Not really.

But what I have put together is a spreadsheet that by inputting each player's cumulative stats into it will measure, in a very simplistic way, the strength of each team so that we can compare them.

So each player on the team will have his total games, points scored, rebounds, assists, blocks, steals turnovers and totals missed shots(missed field goals + missed free throws) put into the following formula to come up with a score for each player

(games+points+rebounds+assists+blocks+steals) - (turnovers+total missed shots) = player score

Then every player on the team will have their scores added up and that number will be divided by the total number of games played by every player to come up with an average player strength score. Then that score will be multiplied by the number of players that have played in games for that team thus far this year giving that team a team strength score.

Here for example is what my team the Washington Boxers stat sheet would look like. Sorry if I don't pretty it up into nice even columns but I think you can get the jist of things.

   Games   Points   Rebounds   Assists   Steals   Blocks   TOs   Misses   Total
Washington Boxers (nickagneta)               
Stephen Jackson   3   50   6   12   3   1   9   28   38
Ramon Sessions   5   28   27   13   2   0   7   19   49
Gerald Wallace   4   63   56   0   9   3   13   45   77
Luis Scola   5   62   49   6   4   3   10   37   82
Joel Pryzbilla    5   12   20   1   1   7   7   8   31
George Hill   3   35   9   5   4   3   4   14   41
Anthony Morrow   3   38   5   2   1   2   1   2   48
Julian Wright   4   28   21   4   0   2   7   15   37
Darko Milicic   5   12   16   3   4   1   2   8   31
Dan Gadzuric   3   14   13   1   0   2   4   6   23
Tyronne Lue   0   0   0   0   0   0   0   0   0
Juwan Howard   2   5   2   0   0   1   1   4   5
Kris Humphries   5   29   21   3   2   0   7   19   34
Gerald Green   0   0   0   0   0   0   0   0   0
Alexis Ajinca   2   6   0   0   0   1   0   1   8
   49   382   245   50   30   26   72   206   504




So the Boxers average player strength score is 10.28571429 and their team strength score is 133.7142857.         

I'm going to try to input everyone's stats into the already established spreadsheet I have for the entire league with players for each team listed. The Excel spreadsheet is all set up with formulas already so all I have to do is look up each player and put his stats in. It took me about 10 minutes for me to do the Boxers so have patience, it might be a while before I have every team in and updated.

If you want a copy of the Excel spreadsheet, I can e=mail it to you just PM me and then if you want you can keep track of your own team or some or all. I will be listing the scores for every team once a month until season's end.
« Last Edit: November 05, 2009, 05:04:06 PM by nickagneta »

Re: 2009 CB NBA Draft as a fantasy basketball league.
« Reply #1 on: November 05, 2009, 06:16:16 PM »

Offline nickagneta

  • James Naismith
  • *********************************
  • Posts: 48121
  • Tommy Points: 8800
  • President of Jaylen Brown Fan Club
So I finished inputting all the data for the Eastern Conference Teams and will now list all the Eastern Conference teams in order of team strength. The numbers given will be the Average Player Score(AVP), the # of Players that have played this year for that team(#P) and the Team Strength Score(TSS).

Team                   AVP     #P     TSS

Cleveland          15.37   12   184.43
Orlando              12.41   14   173.69
Chicago             14.11   12   169.36
Philadelphia      13.70  12    164.43
Miami                 10.78   13   140.17
Washington       10.29  13    133.71
Boston               12.11   11   133.28
Indiana              14.17     9   127.54
Toronto              11.45   11   126.00
New York             9.95   12   119.49
Detroit                11.71   10   117.14
Milwaukee         10.86   10   108.57
New Jersey         9.83   10    98.29
Atlanta               12.26      8    98.07
Charlotte             8.15      6    48.94

I know it is still early with most teams only playing about 5 games but I thought it interesting to see where we stand. This is how the voting placed the eastern Conference

1. Orlando
2. Chicago
3. Toronto
4. Philadelphia
5. Boston
6. New Jersey
7. Detroit
8. Cleveland
9. Washington

Can't find results past the ninth team. Sorry


Re: 2009 CB NBA Draft as a fantasy basketball league.
« Reply #2 on: November 05, 2009, 06:18:45 PM »

Offline Donoghus

  • Global Moderator
  • Walter Brown
  • ********************************
  • Posts: 32502
  • Tommy Points: 1721
  • What a Pub Should Be

Can't find results past the ninth team. Sorry


Yeah, the intention of the voting was to establish the playoff seeds. 1-8.  There was a tie so we had 9 in the East.

Totals were never run for the non-playoff teams but if someone really wanted to, they could go back through the votes and determine the remaining seeds.

And don't look at me to do it....  I'm done with the draft.


2010 CB Historical Draft - Best Overall Team

Re: 2009 CB NBA Draft as a fantasy basketball league.
« Reply #3 on: November 05, 2009, 06:19:01 PM »

Offline Edgar

  • Kevin McHale
  • ************************
  • Posts: 24646
  • Tommy Points: 445
  • No contaban con mi astucia !!!
Great effort nick

Tp

very interesting how underrated Cle was stat based.
Once a CrotorNat always a CROTORNAT  2 times CB draft Champion 2009-2012

Nice to be back!

Re: 2009 CB NBA Draft as a fantasy basketball league.
« Reply #4 on: November 05, 2009, 06:28:50 PM »

Offline RebusRankin

  • Satch Sanders
  • *********
  • Posts: 9143
  • Tommy Points: 923
Is there a western version?

Re: 2009 CB NBA Draft as a fantasy basketball league.
« Reply #5 on: November 05, 2009, 06:35:34 PM »

Offline Roy Hobbs

  • In The Rafters
  • The Natural
  • *********************************
  • Posts: 33333
  • Tommy Points: 6430
  • Doc could learn a thing or two from Norman Dale
It's interesting to look at, but ultimately, I think the voting yields more accurate results.  Stats don't tell things like chemistry, fit, position, roster construction, etc. 

Still, nice effort nick.  TP.

All the negativity in this town sucks. It sucks, and it stinks, and it sucks. - Rick Pitino

Portland CrotoNats:  2009 CB Draft Champions

Re: 2009 CB NBA Draft as a fantasy basketball league.
« Reply #6 on: November 05, 2009, 06:41:46 PM »

Offline nickagneta

  • James Naismith
  • *********************************
  • Posts: 48121
  • Tommy Points: 8800
  • President of Jaylen Brown Fan Club
Is there a western version?
I'll be posting that tomorrow. Inputting every single player's data into the matrix is a long long process.

Re: 2009 CB NBA Draft as a fantasy basketball league.
« Reply #7 on: November 05, 2009, 06:47:02 PM »

Offline Fafnir

  • Bill Russell
  • ******************************
  • Posts: 30863
  • Tommy Points: 1330
It's interesting to look at, but ultimately, I think the voting yields more accurate results.  Stats don't tell things like chemistry, fit, position, roster construction, etc. 

Still, nice effort nick.  TP.
I'm not a fan of the formula you're using, it'll overrate volume scorers.

Still TPs for giving the Draft another fun perspective!

Re: 2009 CB NBA Draft as a fantasy basketball league.
« Reply #8 on: November 05, 2009, 06:49:32 PM »

Offline Lucky17

  • DKC Commish
  • JoJo White
  • ****************
  • Posts: 16021
  • Tommy Points: 2352
Good work, nick. TP for the effort.

Another metric by which to compare these teams is fine by me, especially one that's updated throughout the season.
DKC League is now on reddit!: http://www.reddit.com/r/dkcleague

Re: 2009 CB NBA Draft as a fantasy basketball league.
« Reply #9 on: November 05, 2009, 07:06:02 PM »

Offline nickagneta

  • James Naismith
  • *********************************
  • Posts: 48121
  • Tommy Points: 8800
  • President of Jaylen Brown Fan Club
It's interesting to look at, but ultimately, I think the voting yields more accurate results.  Stats don't tell things like chemistry, fit, position, roster construction, etc. 

Still, nice effort nick.  TP.
Interesting enough though it does follow pretty much in line with a ton of the votes that were cast. As I was looking at the total team stats and some of the arguments that were used for and against teams, some were spot on based on stats.

Chicago, for instance, is getting most of their contributions from 4 players and has no bench that Gasol is out and Ryan Anderson is starting for them. Other than Anderson and A bot of stuff from Williams, the Chicago team is all starters contributions. As was said.

The Bobcats were universally hailed as the worst team and no surprise there. The Hawks were for the most part thought to be an afterthought and are. Orlando with LeBron and role players is strong but interestingly, Marc Gasol has almost the same player rating as LeBron and the two are carrying that team.

The big surprises I think are Toronto's drop off and Cleveland's rise. Toronto is having problems with some of their older players giving them what some expected and Cleveland is having Lou Williams, Andray Blatche, Carl Landry, Mike Miller and Jamal Crawford put up good numbers. Ultimately though, is that, like Roy hints at, a fantasy basketball derivative and relying on those guys to get you to the playoffs might be asking something.

But, I will try to update this once or twice a month ans see what the numbers tell us.

Roy, in case you and Edgar are interested, I ran the numbers for Portland and at this time you wouldn't finish in the top 4 in the East.

Re: 2009 CB NBA Draft as a fantasy basketball league.
« Reply #10 on: November 05, 2009, 07:10:40 PM »

Offline Edgar

  • Kevin McHale
  • ************************
  • Posts: 24646
  • Tommy Points: 445
  • No contaban con mi astucia !!!

Roy, in case you and Edgar are interested, I ran the numbers for Portland and at this time you wouldn't finish in the top 4 in the East.


lol... I see this comming
Old Timers needs a couple of month to get into championship form... :P

So we are now 5th. :) ?
Once a CrotorNat always a CROTORNAT  2 times CB draft Champion 2009-2012

Nice to be back!

Re: 2009 CB NBA Draft as a fantasy basketball league.
« Reply #11 on: November 05, 2009, 07:11:56 PM »

Offline Roy Hobbs

  • In The Rafters
  • The Natural
  • *********************************
  • Posts: 33333
  • Tommy Points: 6430
  • Doc could learn a thing or two from Norman Dale

Roy, in case you and Edgar are interested, I ran the numbers for Portland and at this time you wouldn't finish in the top 4 in the East.

The thing is, this doesn't have anything to do with where an actual team would finish (as you sort of acknowledge).  I mean, if great stats equated to winning, the Knicks and Suns would have been in the Finals every year.  Also, the reliance on an average player score doesn't seem right.  For instance, why should a team be marked down because the 13th, 14th, and 15th strongest players bring their average down?


All the negativity in this town sucks. It sucks, and it stinks, and it sucks. - Rick Pitino

Portland CrotoNats:  2009 CB Draft Champions

Re: 2009 CB NBA Draft as a fantasy basketball league.
« Reply #12 on: November 05, 2009, 07:19:46 PM »

Offline nickagneta

  • James Naismith
  • *********************************
  • Posts: 48121
  • Tommy Points: 8800
  • President of Jaylen Brown Fan Club
It's interesting to look at, but ultimately, I think the voting yields more accurate results.  Stats don't tell things like chemistry, fit, position, roster construction, etc. 

Still, nice effort nick.  TP.
I'm not a fan of the formula you're using, it'll overrate volume scorers.

Still TPs for giving the Draft another fun perspective!
Actually you would be surprised at some of the numbers and what subtracting missed shots and turnovers will do to a player's numbers.

Danny Granger, for instance, averages over 23 PPG but because of his high turnover ratio and and almost 10 missed shots per game, he has a rather average player rating for a big time scorer. Kevin Martin's numbers are not spectacular because of the over 12 missed shots per game that he misses.

On the other hand, guys like Marc Gasol and Paul Pierce, who have all around games and very, very good field goal percentages have great player numbers.

Re: 2009 CB NBA Draft as a fantasy basketball league.
« Reply #13 on: November 05, 2009, 07:20:31 PM »

Offline KCattheStripe

  • Danny Ainge
  • **********
  • Posts: 10726
  • Tommy Points: 830
I can't wait to see how my team is doing fantasy wise. Wings are underperforming, but the Bigs are doing slightly better than they usually do. i might end up starting the Israeli.

Re: 2009 CB NBA Draft as a fantasy basketball league.
« Reply #14 on: November 05, 2009, 07:24:50 PM »

Offline nickagneta

  • James Naismith
  • *********************************
  • Posts: 48121
  • Tommy Points: 8800
  • President of Jaylen Brown Fan Club
Also, just to let you know Roy and Edgar, as soon as Rashard Lewis starts contributing after his suspension is up, your team strength will be amongst the highest.