NCAAB Tournament Spreadsheet

Forum: College Basketball Page 1 of 7  1 2 3 4 5   »
Author: [College Basketball] Topic: NCAAB Tournament Spreadsheet
kindergartencapper PM kindergartencapper
Joined: Nov 2004
Posts: 11688
North Carolina
 
kindergartencapper
Participation Meter
Posted: 3/11/2012 9:49:26 PM
Not heading to Vegas for the first time in years, but still just as excited for March Madness here in Charlotte.

Last year the web traffic on my spreadsheet was unreal for the days leading up to and also during the Madness.  It was funny running into people who had printed it out in Vegas and at the airport.

Here is the link to the one that I created this year
https://docs.google.com/spreadsheet/ccc?key=0Aulb4AJ0_1NRdF9JZEY2dzM4YVE1U1BXVGJpODhTU3c


Breaking down the spreadsheet---all rankings from 345 NCAA Teams
  • Offensive Efficiency
  • Defensive Efficiency
  • Offensive Turnovers
  • Defensive Turnovers
  • Foul Shooting %
  • 3 Pt (how much % of their points come from 3 Point shots)
  • 2PT(how much % of their points come from 2 Point shots)
  • Tempo(speed they play)
  • SOS/O(Strength of Schedule Offenses they played)
  • SOS/D (Strength of Schedule Defenses they played)
  • SOS(Overall SOS)
  • Experience
  • Height(From players who are actually playing a certain % of each game)
  • PPG/O (Points per game Offense)
  • PPG/D( Points per game Defense)

At the bottom of the spreadsheet you will find tabs that if you click on them they will sort all the stats into rankings for just the teams in the tournament.

Hope this helps and GOOD LUCK TO EVERYONE THIS YEAR


jshep PM jshep
Joined: Jan 2011
Posts: 5789
Virginia
 
jshep
Participation Meter
Posted: 3/11/2012 9:56:58 PM
superb work KG! simply amazing. BOL to you
gollum PM gollum
Joined: Jun 2004
Posts: 2032
Michigan
 
gollum
Participation Meter
Posted: 3/11/2012 9:57:07 PM
Thanks, this is great!
allicat PM allicat
Joined: Aug 2009
Posts: 1147
Texas
 
allicat
Participation Meter
Posted: 3/11/2012 9:59:16 PM
PapaShango PM PapaShango
Joined: Dec 2010
Posts: 22368
 
PapaShango
Participation Meter
Posted: 3/11/2012 10:25:27 PM
jmoo2k8 PM jmoo2k8
Joined: Dec 2007
Posts: 207
 
jmoo2k8
Participation Meter
Posted: 3/11/2012 10:37:46 PM
thanks
Jaysvdubwhat PM Jaysvdubwhat
Joined: Aug 2008
Posts: 23759
Ontario
 
Jaysvdubwhat
Participation Meter
Posted: 3/11/2012 10:45:41 PM
thank you
Rocafella PM Rocafella
Joined: Oct 2005
Posts: 21463
Pennsylvania
 
Rocafella
Participation Meter
Posted: 3/11/2012 10:47:21 PM
jms5417 PM jms5417
Joined: Nov 2007
Posts: 130
Pennsylvania
 
jms5417
Participation Meter
Posted: 3/11/2012 10:52:17 PM
for the turnovers section is it 1--for most turnovers, or ranked 1 for turns the bal over least
HotRoute PM HotRoute
Joined: Sep 2007
Posts: 25134
Wisconsin
 
HotRoute
Participation Meter
Posted: 3/11/2012 10:53:47 PM
--phillyfan-- PM --phillyfan--
Joined: Apr 2009
Posts: 14434
United States
 
--phillyfan--
Participation Meter
Posted: 3/11/2012 10:58:09 PM
Thanks for the Info KGC..  
Zoot PM Zoot
Joined: Dec 2003
Posts: 20154
Nevada
 
Zoot
Participation Meter
Posted: 3/11/2012 10:58:58 PM
well done
EZrider PM EZrider
Joined: Mar 2004
Posts: 353
Michigan
 
EZrider
Participation Meter
Posted: 3/11/2012 10:59:21 PM

KC,

Thanks for your efforts!  I used this last year and it was great to have.

SInce you're not hangin at the Paris this year, will you be posting any picks?

wiseman22 PM wiseman22
Joined: Jun 2011
Posts: 5441
Ontario
 
wiseman22
Participation Meter
Posted: 3/11/2012 11:02:56 PM
well done, im sure alot of people will refer to these stats
detroitigerz PM detroitigerz
Joined: Mar 2012
Posts: 23
 
detroitigerz
Participation Meter
Posted: 3/11/2012 11:17:02 PM
Any particular stats you like to pay attention to the most during march madness?

Thanks for the spreadsheet!
BJaRz PM BJaRz
Joined: Oct 2008
Posts: 2410
New York
 
BJaRz
Participation Meter
Posted: 3/12/2012 12:07:27 AM
kindergartencapper PM kindergartencapper
Joined: Nov 2004
Posts: 11688
North Carolina
 
kindergartencapper
Participation Meter
Posted: 3/12/2012 12:21:46 AM
Thanks everyone.  It's been busy so far tonight.

Added a new stat that might be fun to watch.

  • Air Travel to first site in miles

I really like WVU PK right now with WVU basically playing 50 some air miles away.  Between all of the WVU and Ohio St fans, I think both will be rooting for each other so they can finally play in the next round.  Also liked Murray St when it opened early.

scott12308 PM scott12308
Joined: Jul 2011
Posts: 52
 
scott12308
Participation Meter
Posted: 3/12/2012 12:39:37 AM

Last year you told of a system in the NIT that said to play over on the 1st halfs of 60 or less. It did very well from what I can remember. Does the same apply for the NCAA?

i

sjfinger14 PM sjfinger14
Joined: Jan 2012
Posts: 162
California
 
sjfinger14
Participation Meter
Posted: 3/12/2012 1:12:50 AM
Thanks
kindergartencapper PM kindergartencapper
Joined: Nov 2004
Posts: 11688
North Carolina
 
kindergartencapper
Participation Meter
Posted: 3/12/2012 1:14:39 AM
QUOTE Originally Posted by scott12308:

Last year you told of a system in the NIT that said to play over on the 1st halfs of 60 or less. It did very well from what I can remember. Does the same apply for the NCAA?

i


Can't remember how it turned out.  There were some stats I threw out from past years about the amount of games that go over 60 in the first round.

The height factor has been interesting in the past years(not sure what last year ended up, I'll have to go through my binder from last year) with the Top 10 tallest teams have made the Sweet 16 at an alarming rate
WhySoSucK PM WhySoSucK
Joined: Jan 2009
Posts: 6848
United States
 
WhySoSucK
Participation Meter
Posted: 3/12/2012 1:50:02 AM
Hoyasaxa PM Hoyasaxa
Joined: Nov 2008
Posts: 3386
California
 
Hoyasaxa
Participation Meter
Posted: 3/12/2012 2:21:03 AM

Nice stuff-would  be helpful to write up what you feel are most useful-from your years of experience-I've definitely seen the lines get way tighter over the last 4 years-been going to Vegas for 10 now...used to be you could play all the DD dogs and do very well. Now they are hard to find-GT -3.4 over Belmont for example.

Your point about Bigs is well taken. It seems to me it's all about who has the best match-ups...pls advise

TDHCentral PM TDHCentral
Joined: Oct 2009
Posts: 14062
Alabama
 
TDHCentral
Participation Meter
Posted: 3/12/2012 2:33:35 AM
Very much appreciated!  I also used this info last year, and it was a great reference.  Thank you sir!
bob696969 PM bob696969
Joined: Feb 2008
Posts: 4019
Canada
 
bob696969
Participation Meter
Posted: 3/12/2012 2:49:05 AM
Nice
Posted using a mobile device.
Orangemen44 PM Orangemen44
Joined: Feb 2008
Posts: 33526
New York
 
Orangemen44
Participation Meter
Posted: 3/12/2012 5:45:04 AM
Forum: College Basketball Page 1 of 7  1 2 3 4 5   »
You have entered the forum as a GUEST. 
You must login/register to post or reply.