As always, good work, sir.
Thanks
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
Re: Excel sheet that calculates advanced stats for download
-
- Retired Mod
- Posts: 80,406
- And1: 23,765
- Joined: Jan 24, 2004
-
Re: Excel sheet that calculates advanced stats for download
- 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
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
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
Re: Excel sheet that calculates advanced stats for download
-
- RealGM
- Posts: 34,959
- And1: 9,767
- Joined: Dec 04, 2001
-
Re: Excel sheet that calculates advanced stats for download
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
Re: Excel sheet that calculates advanced stats for download
- 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
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
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.
Again I dont know if I did this correctly Im not a big numbers guy, but my God these are some numbers.
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

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.

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
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
Re: Excel sheet that calculates advanced stats for download
- B-easy
- Starter
- Posts: 2,166
- And1: 639
- Joined: Apr 08, 2010
Re: Excel sheet that calculates advanced stats for download
Thanks for this, alucr.
Re: Excel sheet that calculates advanced stats for download
-
- Bench Warmer
- Posts: 1,363
- And1: 224
- Joined: Jul 07, 2013
Re: Excel sheet that calculates advanced stats for download
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%)
Re: Excel sheet that calculates advanced stats for download
- JackFinn
- RealGM
- Posts: 15,121
- And1: 1,605
- Joined: Oct 08, 2006
Re: Excel sheet that calculates advanced stats for download
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.