RebKell's Junkie Boards
Board Junkies Forums
 
Log in Register FAQ Memberlist Search RebKell's Junkie Boards Forum Index

Historical Teams and Coaches Register spreadsheet

 
Post new topic   Reply to topic    RebKell's Junkie Boards Forum Index » NCAA Women's Basketball - General Discussion
View previous topic :: View next topic  
Author Message
petrel



Joined: 26 May 2008
Posts: 2001
Location: Atlanta, GA


Back to top
PostPosted: 07/17/13 7:09 am    ::: Historical Teams and Coaches Register spreadsheet Reply Reply with quote

One of my side projects over the past few months has been a Historical Teams and Coaches Register. The idea was to create a spreadsheet with multiple tabs, where each tab would correspond to a team and each row would correspond to a season, a coach, and that coach's win loss record.

The effort is finally complete, and I wanted to share the results with anyone that had an interest in such things. A screen capture of one of the pages can be found here.

http://img841.imageshack.us/img841/475/ybe1.jpg

(Warning: large image.)

All of the teams from the power conferences (as of the end of the 2013 season) are included: these are the ACC, (old) Big East, Big 10, Big 12, Pac-12 and SEC.

The entire spreadsheet is about 511 KB. I thought I'd host it on Mediafire. This is the link I've been given; since I've never used Mediafire to share files, I hope that clicking on the link will do everything.

http://www.mediafire.com/view/5gtohel5d6jxeeh/Historical_Teams_and_Coaches_Register_2013.xlsx

Enjoy it, and if you notice any errors in it or make any additions, all I ask is that you notify me and/or send me the updated spreadsheet. Let me know about any download issues, and if the download link doesn't work, well...I might just e-mail it to you.

--Pet


LegoMyEggo



Joined: 02 Apr 2010
Posts: 284



Back to top
PostPosted: 07/17/13 12:19 pm    ::: Reply Reply with quote

Really outstanding work. Thank you, very much.


btharner



Joined: 17 Feb 2008
Posts: 109



Back to top
PostPosted: 07/17/13 5:57 pm    ::: Reply Reply with quote

Awesome work. There just isn't enough research done on the history of the women's college game.


petrel



Joined: 26 May 2008
Posts: 2001
Location: Atlanta, GA


Back to top
PostPosted: 07/27/13 10:44 am    ::: Reply Reply with quote

The register has now been updated. The updated file can be loaded here:

http://www.mediafire.com/view/dzndha2haqt46a5/Historical_Teams_and_Coaches_Register_2013.xlsx

The new teams coming to the Big East and AAC have been added. Those teams are:

Big East: Butler, Creighton, Xavier
AAC: Central Florida, Houston, Memphis, SMU, Temple


Phil



Joined: 22 Oct 2011
Posts: 1255



Back to top
PostPosted: 07/29/13 8:27 am    ::: Reply Reply with quote

I just downloaded it and it looks great.

I am very active in Wikipedia, and did some of the AIAW work.

Would like to contact you to see how we can work together. I sent an IM with an email address.


petrel



Joined: 26 May 2008
Posts: 2001
Location: Atlanta, GA


Back to top
PostPosted: 11/07/13 4:52 pm    ::: Reply Reply with quote

In honor of the women's college basketball regular season starting tomorrow, there is a new update to the file which should be downloadable from this link:

http://www.mediafire.com/view/50oluj8inotpjs0/Historical_Teams_and_Coaches_Register_2013_Subtotals_20131107.xlsx


The new file:

a) corrects a handful of errors
b) adds subtotals by era and conference
c) rearranges the team tabs to reflect current conference alignments
d) adds the Atlantic 10 as a conference
e) adds information about consecutive visits (or non-visits) to the NCAA Tournament.


petrel



Joined: 26 May 2008
Posts: 2001
Location: Atlanta, GA


Back to top
PostPosted: 04/26/14 10:33 am    ::: Reply Reply with quote

With the end of the 2014 season, the spreadsheet has been updated:

http://www.mediafire.com/view/4hrkcfjexanb949/Historical_Teams_and_Coaches_Register_2014_Subtotals_20140426.xlsx

Features:

* Coaching histories from the following conferences

ACC
Big Ten
Big Twelve
Pac-10
Southeastern

American
Big East
Atlantic Ten
Sun Belt (new)

* A tab listing leaders by consecutive NCAA appearances and by consecutive years without an NCAA appearance
* The final standings of all NCAA Division I teams by conference and post-season results for 2012-13 and 2013-14.


petrel



Joined: 26 May 2008
Posts: 2001
Location: Atlanta, GA


Back to top
PostPosted: 04/20/15 2:34 pm    ::: Reply Reply with quote

The register has now been updated to reflect results of the 2014-15 seasons.

The CAA (Colonial) has now been added as a conference. The link can be found here:

http://www.mediafire.com/view/aag6g8y8d5mv3bt/Historical_Teams_and_Coaches_Register_2014_Subtotals_20150420.xlsx


petrel



Joined: 26 May 2008
Posts: 2001
Location: Atlanta, GA


Back to top
PostPosted: 05/20/16 3:30 pm    ::: Reply Reply with quote

The register has now been updated to reflect results of the 2015-16 seasons.

The Mid-American (MAC) has now been added as a conference.

The penultimate tab is now a list of active coaches by wins at school, win percentage at school, and Linear Wins at school. Linear Wins = (wins)*(win percentage) + wins over .500

The link to the spreadsheet can be found here:

http://www.mediafire.com/download/uw2c5605mdj9h81/Historical_Teams_and_Coaches_Register_2016_Subtotals_20160520.xlsx


Phil



Joined: 22 Oct 2011
Posts: 1255



Back to top
PostPosted: 05/20/16 9:28 pm    ::: Reply Reply with quote

Thanks


petrel



Joined: 26 May 2008
Posts: 2001
Location: Atlanta, GA


Back to top
PostPosted: 05/19/17 9:13 am    ::: Reply Reply with quote

The register has now been updated to reflect results of the 2016-17 seasons.

Changes:

* The West Coast, Summit, Mountain West, Ivy League, Conference USA and Big Sky conferences have been added.
* At the very end of the spreadsheet is a "Season Timelines" tab which expresses every team's post-season history in a glorious technicolor grid.

The link to the spreadsheet can be found here:

https://www.mediafire.com/?wymkwbywm62d06a


Phil



Joined: 22 Oct 2011
Posts: 1255



Back to top
PostPosted: 05/19/17 12:18 pm    ::: Reply Reply with quote

Very nice, thanks for all that work.


Phil



Joined: 22 Oct 2011
Posts: 1255



Back to top
PostPosted: 05/19/17 1:51 pm    ::: Reply Reply with quote

petrel

By coincidence, I was working on updating the Wikipedia article about Wes_Moore:

https://en.wikipedia.org/wiki/Wes_Moore_(basketball)

when I saw the notice about your update.

Unfortunately, it didn't help with my specific questions although I'm sure it will help with some others, but I thought I'd share the specific issue I'm having in case you've run across good source of information as part of your update process.

The table lists five years at Maryville College but he was there six years.

The list of seasons is missing 1992 – 93, although the records don't line up with the years; the missing record is the 23 – 6 result in 1990 – 91.

That's easy enough to fix by looking at the NCAA records but I want to double check the postseason results.

The editor who worked on this claim that Maryville was part of USA self athletic conference but that's not quite true (they were part of the conference for football but in different years). I haven't tracked down the conference they were in in 1993. (They were part of the Great South Athletic Conference, But that didn't start until 1999.)

The NCAA Division III history page:

http://www.ncaa.com/history/basketball-women/d3
identifies winners and runner-up in each year but I haven't tracked down full brackets.

Any chance you either have access to Division III brackets for those years?


Phil



Joined: 22 Oct 2011
Posts: 1255



Back to top
PostPosted: 05/19/17 2:00 pm    ::: Reply Reply with quote

petrel

Florida State had to vacate 16 wins in 2006 – 07 and six wins in 2007 – 08 Including two NCAA tournament wins.

http://www.hoopfeed.com/content/2010/02/08/academic-scandal-costs-florida-state-22-wins-16-from-breakout-season/

Is that the type of information you want to include or choose to ignore in your spreadsheet?

In Wikipedia, I handled it by including the original record in the table and adding and*to identify the vacated wins.

https://en.wikipedia.org/wiki/Sue_Semrau


petrel



Joined: 26 May 2008
Posts: 2001
Location: Atlanta, GA


Back to top
PostPosted: 05/19/17 5:06 pm    ::: Reply Reply with quote

Phil, it appears that in 1989 and 1990 the NCAA Division III tournaments broke the tournament into four-team Regionals for the years you're talking about. There were eight of these regionals for a 32-team tournament. A further complication was that that the two losers of the first round game played in a second game to determine the Region's third-place team.

In 1991, the NCAA Division III tournament moved to four eight-team "Sectionals" - still a 32-team tournament - and appear to have eliminated the Third Place games.

Here's what I'm finding.

1989: Maryville was in the South Regional with Virginia Wesleyan, Centre, and Nazareth.
Game #1: Lost to Nazareth 71-63.
Game #2. Beat Virginia Wesleyan 86-79 in Third Place Game for the South Regional.

1990: Maryville was in the South Regional with Roanoke, Marymount (VA) and Centre.
Game #1: Beat Roanoke 64-62.
Game #2: Lost in South Regional Final (as you would note, a Sweet Sixteen game) to Centre 73-63.

1991: Maryville was one of eight teams in the South Sectional. They won the quarterfinals game against Centre 88-80 and advance to the Round of 16 in a 32-team touranment but then lost to Washington (MO) 73-59.

1992: Maryville was assigned to the Great Lakes Sectional. They lost to Roanoke 73-71 in the First Round. I don't have them going to the "Sweet Sixteen" of the 32-team tournament due to the opening round loss.


Phil



Joined: 22 Oct 2011
Posts: 1255



Back to top
PostPosted: 05/20/17 9:39 am    ::: Reply Reply with quote

Thanks, that was helpful.

I have updated the Wikipedia page.


petrel



Joined: 26 May 2008
Posts: 2001
Location: Atlanta, GA


Back to top
PostPosted: 05/31/18 9:18 am    ::: Reply Reply with quote

The register has now been updated to reflect results of the 2017-18 seasons.

Changes:

* The Horizon, Southern, America East, Missouri Valley, Big West, Patriot, Ohio Valley, Metro Atlantic, WAC, and Atlantic Sun conferences have been added.
* With USC Upstate moving to the Big South (and with the Big South being one of five conferences currently not included), I have left the tab for USC Upstate's historical record as an outlier.
* I am working on the final five conferences, but I have no idea when they will be completed. If I get them completed before the end of the 2018-19 season I'll create a special update.

The link to the spreadsheet can be found here:


http://www.mediafire.com/file/k7rj8xkd8owgjyu/Historical%20Teams%20and%20Coaches%20Register%202018%20Subtotals_20180531_Final.xlsx


petrel



Joined: 26 May 2008
Posts: 2001
Location: Atlanta, GA


Back to top
PostPosted: 05/31/19 8:18 am    ::: Reply Reply with quote

The register has now been updated to reflect results of the 2018-19 season.

Changes:

* We now have every current NCAA Division I school represented. All conferences are included.
* In addition, Merrimack has been added. Merrimack moves from the Northeast 10 (Division II) to the Northeast Conference in 2019-20.
* Savannah State will move from the MEAC to Division II in 2019-20, but we will maintain a tab for Savannah State for now.

The link to the spreadsheet can be found here:

http://www.mediafire.com/file/3iof6x8zbts3im8/Historical_Teams_and_Coaches_Register_2019_Subtotals_20190531.xlsx/file


Luuuc
#NATC


Joined: 10 Feb 2005
Posts: 21900



Back to top
PostPosted: 05/31/19 8:06 pm    ::: Reply Reply with quote

petrel wrote:
The register has now been updated to reflect results of the 2018-19 season.

Changes:

* We now have every current NCAA Division I school represented. All conferences are included.
* In addition, Merrimack has been added. Merrimack moves from the Northeast 10 (Division II) to the Northeast Conference in 2019-20.
* Savannah State will move from the MEAC to Division II in 2019-20, but we will maintain a tab for Savannah State for now.

The link to the spreadsheet can be found here:

http://www.mediafire.com/file/3iof6x8zbts3im8/Historical_Teams_and_Coaches_Register_2019_Subtotals_20190531.xlsx/file

That is some impressive work, petrel


Display posts from previous:   
Post new topic   Reply to topic    RebKell's Junkie Boards Forum Index » NCAA Women's Basketball - General Discussion All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB 2.0.17 © 2001- 2004 phpBB Group
phpBB Template by Vjacheslav Trushkin