Page 1 of 2

Dynasty Tracker

Posted: Wed Apr 01, 2015 11:14 am
by Chilikonkarne
Hi guys,

Not sure where to post this but I will go with CSL insider.
As discussed before in league ideas, I was gathering awards data from last year and the beginning of the CSL. Thanks to Dennis and Sky, these awards are now on the forum and it really facilitated my work.

Let me introduce you the Dynasty Tracker.

What is it?

It is a simple tracker which record all achievements of a team. The formula is pretty simple, it combines victories, playoffs performance, end-season awards and all-star selection.
Objective is to track the best team over the years. I usually use it when playing solo in order to try staying at the top the longest possible and identify the best teams of a decade.
I believe it also a good indicator for a multiplayer league and I will update it every year to see which teams are distinguish themselves from others

What is the formula?

As said before, it is pretty simple.
Victory : You get 1 point by win (only regular season)
Playoffs : Depends how you perform. If you don’t pass the first round (7pts), if you get eliminated in 2nd round (15pts), If you lose in conference final (25pts), if you lose in finals (35pts) and finally if you win the finals (50pts)
Awards : MVP (5pts), GM of the Year (5pts), 6th man (3pts), ROY (3pts) and DPY (3pts)
Teams : 1 point by appearance (1st, 2nd, 3rd All CSL teams, 1st, 2nd Defensive CSL teams and 1st, 2nd Rookie CSL teams)
All Star : 2 points by player

Let’s see Indiana as example since they are currently leading the ranking.
Last year they got 119pts : 65 (victories) + 50 (champion) + 2 (P.George All Star) + 1 (P.George All CSL Team) + 1 (P.George Defensive Team)

As you can see Playoffs are the real deal and tanking few years before reaching the top may cause you lot of points. Moreover a huge star who will insure All Star + All CSL team every year is a good point investment.

#1 Indiana still at the top with 162pts but a non-qualification for playoffs this would make them lose couple of spots
#2 Detroit got 144 pts – 2 solid seasons, conference final last year and 10 pts via the all-star game (record of the league)
#3 Memphis follow behind with 134 pts – Final appearance brought them 35 pts last year
#4 Atlanta and their 109 accumulated win in regular season (1st) and 8 pts via All-star allow them to stay in the leadership (133 pts)
#5 Oklahoma City. Disappointing playoffs last year but a MVP (5), 3 pts via all teams and 8pts via all-star ensured them a good spot. (128 pts)

Then we have Boston (121)and Denver (117). Milwaukee close the ranking with 21 pts (21 victories combined, no reward).

Please find below the accumulated points by team :
TOTALVNBAFinalConf2nd1stMVPGMOY6eROYDFYAll TASTOTALRanking
INDIANA PACERS10650000000000241621
DETROIT PISTONS107002500000002101442
MEMPHIS GRIZZLIES9603500000000121343
ATLANTA HAWKS10900015000000181334
OKLAHOMA CITY THUNDER1050000750000381285
BOSTON CELTICS10000015000030121216
DENVER NUGGETS9700015000000141177
LOS ANGELES CLIPPERS1020000700000121128
WASHINGTON WIZARDS950000700000341099
CHARLOTTE BOBCATS9100007000033410810
MIAMI HEAT9800007000001210810
MINNESOTA TIMBERWOLVES83000150003001410612
HOUSTON ROCKETS9900000000001610612
SAN ANTONIO SPURS79002500000000010414
CHICAGO BULLS830000700000169715
GOLDEN STATE WARRIORS780000700000249116
DALLAS MAVERICKS730000700000128317
CLEVELAND CAVALIERS760000000000027818
PORTLAND TRAIL BLAZERS730000000000047719
NEW YORK KNICKS710000000000147620
NEW ORLEANS PELICANS670000000000347421
TORONTO RAPTORS720000000000007222
UTAH JAZZ510000000000165823
BROOKLYN NETS500000000000125324
PHOENIX SUNS530000000000005324
SACRAMENTO KINGS440000000000104526
LOS ANGELES LAKERS430000000000004327
PHILADELPHIA 76ERS330000000000323828
ORLANDO MAGIC290000000000002929
MILWAUKEE BUCKS210000000000002130
SEASON 1VNBAFinalConf2nd1stMVPGMOY6eROYDFYAll TASTOTALRanking
INDIANA PACERS6550221191
MEMPHIS GRIZZLIES543512922
DETROIT PISTONS532526863
ATLANTA HAWKS591514794
OKLAHOMA CITY THUNDER597534785
DENVER NUGGETS551512736
CHARLOTTE BOBCATS577332727
SAN ANTONIO SPURS4625718
BOSTON CELTICS491531689
LOS ANGELES CLIPPERS6071689
WASHINGTON WIZARDS56732689
MINNESOTA TIMBERWOLVES45153126612
GOLDEN STATE WARRIORS517226213
MIAMI HEAT51715914
DALLAS MAVERICKS487125815
CHICAGO BULLS447125416
NEW ORLEANS PELICANS43324817
HOUSTON ROCKETS44124718
PORTLAND TRAIL BLAZERS3824019
TORONTO RAPTORS393920
BROOKLYN NETS32123521
CLEVELAND CAVALIERS333322
NEW YORK KNICKS28123123
UTAH JAZZ26143123
LOS ANGELES LAKERS252525
PHOENIX SUNS212126
SACRAMENTO KINGS1711827
PHILADELPHIA 76ERS12321728
ORLANDO MAGIC121229
MILWAUKEE BUCKS8830

Re: Dynasty Tracker

Posted: Wed Apr 01, 2015 11:41 am
by KW
Looks awesome! Are you going to keep updating this?

Re: Dynasty Tracker

Posted: Wed Apr 01, 2015 11:43 am
by Chilikonkarne
BizGilwalker wrote:Looks awesome! Are you going to keep updating this?
Yes.
I have an excel table ready and easy to update.
Dennis also provided me the 'Table maker" for the forum which save me a lot of time.

Re: Dynasty Tracker

Posted: Wed Apr 01, 2015 12:32 pm
by emplep7
Great job here man. Will be cool to see how this changes over time.

Re: Dynasty Tracker

Posted: Wed Apr 01, 2015 12:37 pm
by Monte_Cristo
I already heard about the tracker. It is definitely a good way to assess the performance of teams over a certain span of time.
The "Excelopathy" of Chili does have bright sides! :mrgreen:
Will there be an annual release of the tracker from now on?

Re: Dynasty Tracker

Posted: Wed Apr 01, 2015 12:58 pm
by Chilikonkarne
Monte_Cristo wrote:I already heard about the tracker. It is definitely a good way to assess the performance of teams over a certain span of time.
The "Excelopathy" of Chili does have bright sides! :mrgreen:
Will there be an annual release of the tracker from now on?
Excel is a friend, not a sickness! :mrgreen:

Yes. I will soon upload the first season and of course the second season once Playoffs and awards are over

Re: Dynasty Tracker

Posted: Wed Apr 01, 2015 1:21 pm
by Rizzo
I teach middle school computers and I love Excel! Such a great tool. Unfortunately my students don't feel the same way lol.

Love dynasty trackers and glad you're planning on keeping track of it here.

Re: Dynasty Tracker

Posted: Wed Apr 01, 2015 1:36 pm
by Sky
Pretty cool idea you got here.. Good job man! and pretty surprised with 5 MVPs.. :D

Re: Dynasty Tracker

Posted: Wed Apr 01, 2015 1:37 pm
by Dennis
Love it! Nice work man! Good to see we are close to the top! We need to make a deep run this year to pass some teams :)..
Just not sure what we are able to achieve this POs. From first round exit to the title everything is possible.

Re: Dynasty Tracker

Posted: Wed Apr 01, 2015 2:04 pm
by NanashiWake
Looks very cool, thanks for doing this.

Re: Dynasty Tracker

Posted: Wed Apr 01, 2015 2:09 pm
by Marcos_Beck
Great work man! I also use excel a lot and it is a really helpful tool for those who knows how to use it. I actually have some sheets about league which I use for keeping my Submatrix, DC, Philosophies, and stats from my team.. Just to make it better..

As for the ranks we're at 15th but hopefully we're going to increase our ranks when we get our first ring later this season :D

Re: Dynasty Tracker

Posted: Wed Apr 01, 2015 3:06 pm
by Chilikonkarne
Thanks for the nice feedbacks!
Please find below season 1 table. If you are interested by the excel file, just pm me your email and i will send you the file.
Season 2 will be posted after playoffs and awards. I will also update the total table in the first message at that time
SEASON 1VNBAFinalConf2nd1stMVPGMOY6eROYDFYAll TASTOTALRanking
INDIANA PACERS6550221191
MEMPHIS GRIZZLIES543512922
DETROIT PISTONS532526863
ATLANTA HAWKS591514794
OKLAHOMA CITY THUNDER597534785
DENVER NUGGETS551512736
CHARLOTTE BOBCATS577332727
SAN ANTONIO SPURS4625718
BOSTON CELTICS491531689
LOS ANGELES CLIPPERS6071689
WASHINGTON WIZARDS56732689
MINNESOTA TIMBERWOLVES45153126612
GOLDEN STATE WARRIORS517226213
MIAMI HEAT51715914
DALLAS MAVERICKS487125815
CHICAGO BULLS447125416
NEW ORLEANS PELICANS43324817
HOUSTON ROCKETS44124718
PORTLAND TRAIL BLAZERS3824019
TORONTO RAPTORS393920
BROOKLYN NETS32123521
CLEVELAND CAVALIERS333322
NEW YORK KNICKS28123123
UTAH JAZZ26143123
LOS ANGELES LAKERS252525
PHOENIX SUNS212126
SACRAMENTO KINGS1711827
PHILADELPHIA 76ERS12321728
ORLANDO MAGIC121229
MILWAUKEE BUCKS8830

Re: Dynasty Tracker

Posted: Wed Apr 01, 2015 3:57 pm
by andrei
Looking good - thanks for that :)

Question on All-Stars - Big Al was selected this year but did not play due to injury. Are we getting the points for him?

Re: Dynasty Tracker

Posted: Wed Apr 01, 2015 5:00 pm
by Chilikonkarne
I took the initial selection so the points were counted.
However they were allocated to Charlotte since he played more games for the Hornets at that time. If M. Gasol was selected, you would have get the all-star points

Re: Dynasty Tracker

Posted: Thu Apr 02, 2015 3:33 am
by WillyJakkz
Really outstanding work buddy :D

That said being at the bottom sucks and will be all the more satisfying when we start climbing the chart!

#Arrival2016

Re: Dynasty Tracker

Posted: Sun Apr 05, 2015 1:18 am
by bt
WillyJakkz wrote:Really outstanding work buddy :D

That said being at the bottom sucks and will be all the more satisfying when we start climbing the chart!

#Arrival2016
+1

Re: Dynasty Tracker

Posted: Wed Apr 29, 2015 3:09 pm
by Chilikonkarne
Hi,

It seems we have a pretty international community in here.
Could each GM give me his nationality so I will incorporate into the ranking.

CHICAGO BULLS (BRA)
DETROIT PISTONS (USA)

Would be fun to see which team is owned by which nationality, similar to F1 ranking

Image

Re: Dynasty Tracker

Posted: Wed Apr 29, 2015 3:27 pm
by NanashiWake
Chilikonkarne wrote:Hi,

It seems we have a pretty international community in here.
Could each GM give me his nationality so I will incorporate into the ranking.

CHICAGO BULLS (BRA)
DETROIT PISTONS (USA)

Would be fun to see which team is owned by which nationality, similar to F1 ranking

Image
Yeah for sure. I represent the USA! Woo! MERICA'...

Re: Dynasty Tracker

Posted: Wed Apr 29, 2015 3:31 pm
by GreenBear
Suns: USA

Re: Dynasty Tracker

Posted: Wed Apr 29, 2015 3:45 pm
by Chilikonkarne
Let's update it here

Atlantic
Boston - Dennis (GER)
Brooklyn - OneNole (USA)
New York - Open
Philadelphia - StoftheStep (USA)
Toronto - Chilikonkarne (FRA)

Central
Chicago - Marcos_Beck (BRA)
Cleveland - Rizzo (USA)
Detroit - Emplep7 (USA)
Indiana - goikiri (SPA)
Milwaukee - Dylan (USA)

Southeast
Atlanta - dapralbe (SPA)
Charlotte - Open
Miami - enfantterrible
Orlando - WillyJakkz (USA)
Washington - NanashiWake (USA)

Southwest
Dallas - Myles (USA)
Houston - BizGilwalker (USA)
Memphis - Andrei (IRL)
New Orleans - Sun Scorched (USA)
San Antonio - cyrisnyte (USA)

Northwest
Denver - orangeparka (KOR)
Minnesota - rh0xxy (PHI)
Oklahoma City - Sky (PHI)
Portland - Monte_Cristo (FRA)
Utah - OPEN

Pacific
Golden State Warriors - Rob
Los Angeles Clippers - open
Los Angeles Lakers - Jestor (USA)
Phoenix Suns - GreenBear (USA)
Sacramento Kings - bt (AUS)