Dynasty Tracker

Post by **Chilikonkarne** » Wed Apr 01, 2015 11:14 am

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 :

TOTAL	V	NBA	Final	Conf	2nd	1st	MVP	GMOY	6e	ROY	DFY	All T	AS	TOTAL	Ranking
INDIANA PACERS	106	50	0	0	0	0	0	0	0	0	0	2	4	162	1
DETROIT PISTONS	107	0	0	25	0	0	0	0	0	0	0	2	10	144	2
MEMPHIS GRIZZLIES	96	0	35	0	0	0	0	0	0	0	0	1	2	134	3
ATLANTA HAWKS	109	0	0	0	15	0	0	0	0	0	0	1	8	133	4
OKLAHOMA CITY THUNDER	105	0	0	0	0	7	5	0	0	0	0	3	8	128	5
BOSTON CELTICS	100	0	0	0	15	0	0	0	0	3	0	1	2	121	6
DENVER NUGGETS	97	0	0	0	15	0	0	0	0	0	0	1	4	117	7
LOS ANGELES CLIPPERS	102	0	0	0	0	7	0	0	0	0	0	1	2	112	8
WASHINGTON WIZARDS	95	0	0	0	0	7	0	0	0	0	0	3	4	109	9
CHARLOTTE BOBCATS	91	0	0	0	0	7	0	0	0	0	3	3	4	108	10
MIAMI HEAT	98	0	0	0	0	7	0	0	0	0	0	1	2	108	10
MINNESOTA TIMBERWOLVES	83	0	0	0	15	0	0	0	3	0	0	1	4	106	12
HOUSTON ROCKETS	99	0	0	0	0	0	0	0	0	0	0	1	6	106	12
SAN ANTONIO SPURS	79	0	0	25	0	0	0	0	0	0	0	0	0	104	14
CHICAGO BULLS	83	0	0	0	0	7	0	0	0	0	0	1	6	97	15
GOLDEN STATE WARRIORS	78	0	0	0	0	7	0	0	0	0	0	2	4	91	16
DALLAS MAVERICKS	73	0	0	0	0	7	0	0	0	0	0	1	2	83	17
CLEVELAND CAVALIERS	76	0	0	0	0	0	0	0	0	0	0	0	2	78	18
PORTLAND TRAIL BLAZERS	73	0	0	0	0	0	0	0	0	0	0	0	4	77	19
NEW YORK KNICKS	71	0	0	0	0	0	0	0	0	0	0	1	4	76	20
NEW ORLEANS PELICANS	67	0	0	0	0	0	0	0	0	0	0	3	4	74	21
TORONTO RAPTORS	72	0	0	0	0	0	0	0	0	0	0	0	0	72	22
UTAH JAZZ	51	0	0	0	0	0	0	0	0	0	0	1	6	58	23
BROOKLYN NETS	50	0	0	0	0	0	0	0	0	0	0	1	2	53	24
PHOENIX SUNS	53	0	0	0	0	0	0	0	0	0	0	0	0	53	24
SACRAMENTO KINGS	44	0	0	0	0	0	0	0	0	0	0	1	0	45	26
LOS ANGELES LAKERS	43	0	0	0	0	0	0	0	0	0	0	0	0	43	27
PHILADELPHIA 76ERS	33	0	0	0	0	0	0	0	0	0	0	3	2	38	28
ORLANDO MAGIC	29	0	0	0	0	0	0	0	0	0	0	0	0	29	29
MILWAUKEE BUCKS	21	0	0	0	0	0	0	0	0	0	0	0	0	21	30

SEASON 1	V	NBA	Final	Conf	2nd	1st	MVP	GMOY	6e	ROY	DFY	All T	AS	TOTAL	Ranking
INDIANA PACERS	65	50										2	2	119	1
MEMPHIS GRIZZLIES	54		35									1	2	92	2
DETROIT PISTONS	53			25								2	6	86	3
ATLANTA HAWKS	59				15							1	4	79	4
OKLAHOMA CITY THUNDER	59					7	5					3	4	78	5
DENVER NUGGETS	55				15							1	2	73	6
CHARLOTTE BOBCATS	57					7					3	3	2	72	7
SAN ANTONIO SPURS	46			25										71	8
BOSTON CELTICS	49				15					3		1		68	9
LOS ANGELES CLIPPERS	60					7						1		68	9
WASHINGTON WIZARDS	56					7						3	2	68	9
MINNESOTA TIMBERWOLVES	45				15				3			1	2	66	12
GOLDEN STATE WARRIORS	51					7						2	2	62	13
MIAMI HEAT	51					7						1		59	14
DALLAS MAVERICKS	48					7						1	2	58	15
CHICAGO BULLS	44					7						1	2	54	16
NEW ORLEANS PELICANS	43											3	2	48	17
HOUSTON ROCKETS	44											1	2	47	18
PORTLAND TRAIL BLAZERS	38												2	40	19
TORONTO RAPTORS	39													39	20
BROOKLYN NETS	32											1	2	35	21
CLEVELAND CAVALIERS	33													33	22
NEW YORK KNICKS	28											1	2	31	23
UTAH JAZZ	26											1	4	31	23
LOS ANGELES LAKERS	25													25	25
PHOENIX SUNS	21													21	26
SACRAMENTO KINGS	17											1		18	27
PHILADELPHIA 76ERS	12											3	2	17	28
ORLANDO MAGIC	12													12	29
MILWAUKEE BUCKS	8													8	30

Post by KW » Wed Apr 01, 2015 11:41 am

Looks awesome! Are you going to keep updating this?

Post by **Chilikonkarne** » Wed Apr 01, 2015 11:43 am

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.

Post by **emplep7** » Wed Apr 01, 2015 12:32 pm

Great job here man. Will be cool to see how this changes over time.

Monte_Cristo · Post by **Monte_Cristo** » Wed Apr 01, 2015 12:37 pm

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!

Will there be an annual release of the tracker from now on?

Post by **Chilikonkarne** » Wed Apr 01, 2015 12:58 pm

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!
Will there be an annual release of the tracker from now on?

Excel is a friend, not a sickness!

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

Post by **Rizzo** » Wed Apr 01, 2015 1:21 pm

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.

Sky · Post by **Sky** » Wed Apr 01, 2015 1:36 pm

Pretty cool idea you got here.. Good job man! and pretty surprised with 5 MVPs..

Dennis · Post by **Dennis** » Wed Apr 01, 2015 1:37 pm

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.

NanashiWake · Post by **NanashiWake** » Wed Apr 01, 2015 2:04 pm

Looks very cool, thanks for doing this.

Post by **Marcos_Beck** » Wed Apr 01, 2015 2:09 pm

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

Post by **Chilikonkarne** » Wed Apr 01, 2015 3:06 pm

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 1	V	NBA	Final	Conf	2nd	1st	MVP	GMOY	6e	ROY	DFY	All T	AS	TOTAL	Ranking
INDIANA PACERS	65	50										2	2	119	1
MEMPHIS GRIZZLIES	54		35									1	2	92	2
DETROIT PISTONS	53			25								2	6	86	3
ATLANTA HAWKS	59				15							1	4	79	4
OKLAHOMA CITY THUNDER	59					7	5					3	4	78	5
DENVER NUGGETS	55				15							1	2	73	6
CHARLOTTE BOBCATS	57					7					3	3	2	72	7
SAN ANTONIO SPURS	46			25										71	8
BOSTON CELTICS	49				15					3		1		68	9
LOS ANGELES CLIPPERS	60					7						1		68	9
WASHINGTON WIZARDS	56					7						3	2	68	9
MINNESOTA TIMBERWOLVES	45				15				3			1	2	66	12
GOLDEN STATE WARRIORS	51					7						2	2	62	13
MIAMI HEAT	51					7						1		59	14
DALLAS MAVERICKS	48					7						1	2	58	15
CHICAGO BULLS	44					7						1	2	54	16
NEW ORLEANS PELICANS	43											3	2	48	17
HOUSTON ROCKETS	44											1	2	47	18
PORTLAND TRAIL BLAZERS	38												2	40	19
TORONTO RAPTORS	39													39	20
BROOKLYN NETS	32											1	2	35	21
CLEVELAND CAVALIERS	33													33	22
NEW YORK KNICKS	28											1	2	31	23
UTAH JAZZ	26											1	4	31	23
LOS ANGELES LAKERS	25													25	25
PHOENIX SUNS	21													21	26
SACRAMENTO KINGS	17											1		18	27
PHILADELPHIA 76ERS	12											3	2	17	28
ORLANDO MAGIC	12													12	29
MILWAUKEE BUCKS	8													8	30

Post by **andrei** » Wed Apr 01, 2015 3:57 pm

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?

Post by **Chilikonkarne** » Wed Apr 01, 2015 5:00 pm

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

Post by **WillyJakkz** » Thu Apr 02, 2015 3:33 am

Really outstanding work buddy

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

#Arrival2016

Post by bt » Sun Apr 05, 2015 1:18 am

WillyJakkz wrote:Really outstanding work buddy

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

#Arrival2016

+1

Post by **Chilikonkarne** » Wed Apr 29, 2015 3:09 pm

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

NanashiWake · Post by **NanashiWake** » Wed Apr 29, 2015 3:27 pm

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

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

Post by **GreenBear** » Wed Apr 29, 2015 3:31 pm

Suns: USA

Post by **Chilikonkarne** » Wed Apr 29, 2015 3:45 pm

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)

Dynasty Tracker

Dynasty Tracker

Re: Dynasty Tracker

Re: Dynasty Tracker

Re: Dynasty Tracker

Re: Dynasty Tracker

Re: Dynasty Tracker

Re: Dynasty Tracker

Re: Dynasty Tracker

Re: Dynasty Tracker

Re: Dynasty Tracker

Re: Dynasty Tracker

Re: Dynasty Tracker

Re: Dynasty Tracker

Re: Dynasty Tracker

Re: Dynasty Tracker

Re: Dynasty Tracker

Re: Dynasty Tracker

Re: Dynasty Tracker

Re: Dynasty Tracker

Re: Dynasty Tracker