Image ImageImage Image

Excel sheet that calculates advanced stats for download here

Moderators: HomoSapien, coldfish, Payt10, Ice Man, dougthonus, Michael Jackson, Tommy Udo 6 , kulaz3000, fleet, DASMACKDOWN, GimmeDat, RedBulls23, AshyLarrysDiaper

kingkirk
Retired Mod
Retired Mod
Posts: 80,406
And1: 23,765
Joined: Jan 24, 2004
 

Re: Excel sheet that calculates advanced stats for download  

Post#21 » by kingkirk » Sat Nov 23, 2013 12:09 am

As always, good work, sir.

Thanks
User avatar
dumbell78
General Manager
Posts: 9,082
And1: 5,411
Joined: Apr 03, 2012
Location: Sydney, Aus. by way of Muddy Water land (Chicago)
       

Re: Excel sheet that calculates advanced stats for download  

Post#22 » by dumbell78 » Sat Nov 23, 2013 1:47 am

Quick question. Playing with this and the old MJ triple double streak back in 88-89. Can I just ignore the BA stat line since I don't have it? Probably won't matter much.
KC: Do you still think you're a championship-caliber team?
Gar: I never said that and correct me if I'm wrong.
KC: You were asked that question at the news conference announcing Thibodeau's dismissal and you answered yes
League Circles
RealGM
Posts: 34,959
And1: 9,767
Joined: Dec 04, 2001
       

Re: Excel sheet that calculates advanced stats for download  

Post#23 » by League Circles » Sat Nov 23, 2013 1:51 am

Cool, thanks for posting this. Does it calculate actual TS% or estimated (using the 86% estimate of FTA that aren't and-ones)?
https://august-shop.com/ - sneakers and streetwear
User avatar
dumbell78
General Manager
Posts: 9,082
And1: 5,411
Joined: Apr 03, 2012
Location: Sydney, Aus. by way of Muddy Water land (Chicago)
       

Re: Excel sheet that calculates advanced stats for download 

Post#24 » by dumbell78 » Sat Nov 23, 2013 4:08 am

Ok well I used this spreadsheet to figure MJ's PER during the triple double streak, if Im reading this right I never want to hear about Elias and/or ESPN and their record stats. If ppl recall MJ was inserted as the PG by Doug Collins during that 11 game stretch and had 10 triple doubles. Missing the 11th by 3 rebounds vs. Detroit.

11 game PER:
Game 1- 21.99
Game 2- 35.83
Game 3- 32.05
Game 4- 36.41
Game 5- 37.01
Game 6- 51.92 :o
Game 7- 33.81
Game 8- 45.56 (Detroit game)
Game 9- 39.57
Game10- 48.44
Game11- 32.62

Avg PER 37.746
I can imagine he was tired after this streak. :lol:
Again I dont know if I did this correctly Im not a big numbers guy, but my God these are some numbers.
KC: Do you still think you're a championship-caliber team?
Gar: I never said that and correct me if I'm wrong.
KC: You were asked that question at the news conference announcing Thibodeau's dismissal and you answered yes
User avatar
B-easy
Starter
Posts: 2,166
And1: 639
Joined: Apr 08, 2010

Re: Excel sheet that calculates advanced stats for download  

Post#25 » by B-easy » Sat Nov 23, 2013 4:35 am

Thanks for this, alucr.
mostek
Bench Warmer
Posts: 1,363
And1: 224
Joined: Jul 07, 2013

Re: Excel sheet that calculates advanced stats for download 

Post#26 » by mostek » Sat Nov 23, 2013 4:56 am

JackFinn wrote:
alucryts wrote:ts% - the true shooting percentage------54% is average, 58%+ is elite, 50% or below is the jennings.

47% or below is Tajesque

43% or below is Nateaque (currently 42.8%)
User avatar
JackFinn
RealGM
Posts: 15,121
And1: 1,605
Joined: Oct 08, 2006

Re: Excel sheet that calculates advanced stats for download 

Post#27 » by JackFinn » Sat Nov 23, 2013 5:04 am

mostek wrote:
JackFinn wrote:
alucryts wrote:ts% - the true shooting percentage------54% is average, 58%+ is elite, 50% or below is the jennings.

47% or below is Tajesque

43% or below is Nateaque (currently 42.8%)

Well that was a quick response.

Return to Chicago Bulls