colgatesports.myfastforum.org Forum Index

colgatesports.myfastforum.org Forum Index -> Football -> Stats Project Page 1, 2, 3  Next
Post new topic  Reply to topic View previous topic :: View next topic 
Posted:
Please Register and Login to this forum to stop seeing this advertising.
 




Stats Project
PostPosted: Thu Jan 07, 2016 11:39 pm  Reply with quote
Gate63
Site Admin
 
Joined: 13 Dec 2015
Posts: 159
Location: NJ




Side project that I started a few years ago that I forgot about (or maybe I made myself forget because it is so tedious). Using newspaper articles from the time, I have been rebuilding the scoring stats for all of the early years where the school does not have any official records. So far I have completed 1890-1919. Way more complicated than you want to know, but the Excel doc is all connected with VLookups and links to each player's individual stat worksheet. Maybe in 10 or 20 years I'll actually finish... Shocked





Last edited by Gate63 on Sat Jan 30, 2016 11:46 am; edited 9 times in total

_________________
www.colgatefootballcollection.com
View user's profile Send private message Visit poster's website
PostPosted: Sat Jan 09, 2016 10:39 pm Reply with quote
Gate Raider
Adonal Foyle Club
 
Joined: 13 Dec 2015
Posts: 90




Ryan, do you need 1890 to 1907?  And, what years after 1920?
View user's profile Send private message
PostPosted: Sat Jan 09, 2016 10:47 pm Reply with quote
Gate63
Site Admin
 
Joined: 13 Dec 2015
Posts: 159
Location: NJ




I did 1890, so I still have 1891-1907 to do. Then I plan on going from 1920-1945ish. The official records for individual scoring leaders that the school has picks up at 1945ish so I want to fill in that gap. As a side effect, I have uncovered several players that have already been added (or will be) to the official record book for single play/game records.

_________________
www.colgatefootballcollection.com
View user's profile Send private message Visit poster's website
PostPosted: Tue Jan 12, 2016 9:08 pm Reply with quote
Gate63
Site Admin
 
Joined: 13 Dec 2015
Posts: 159
Location: NJ




Found a pretty significant record today. Ed Tryon scored 7 touchdowns (42 points) against Niagara in 1923.

As a side note, I also found that Tryon scored 34 points (5 touchdowns, 4 extra points) in a 1925 game against Clarkson.

The previous listed record was 5 touchdowns and 30 points shared by 4 players.

https://twitter.com/ColgateFootball/status/686967235710062592
https://twitter.com/ColgateFootball/status/686967934170861568

_________________
www.colgatefootballcollection.com
View user's profile Send private message Visit poster's website
PostPosted: Wed Jan 13, 2016 11:13 am Reply with quote
The Future
Howie Starr Club
 
Joined: 13 Dec 2015
Posts: 159




Looks like you rewrote the Colgate football history books after all.
View user's profile Send private message
PostPosted: Wed Jan 13, 2016 12:21 pm Reply with quote
Gate63
Site Admin
 
Joined: 13 Dec 2015
Posts: 159
Location: NJ




The Future wrote:
Looks like you rewrote the Colgate football history books after all.


Ha! Guess you're right.

_________________
www.colgatefootballcollection.com
View user's profile Send private message Visit poster's website
PostPosted: Wed Jan 13, 2016 11:01 pm Reply with quote
Gate Raider
Adonal Foyle Club
 
Joined: 13 Dec 2015
Posts: 90




Ryan, below is a link to a site you might not be familiar with but could be helpful in looking up some football stats. The name is misleading.  It is free and has microfiche copies of many NY state newspapers (Madison even had one)  that can be searched (by a name, school, school sport, and on).  Many of the papers go back into the 1800's.  It is quite voluminous but it works.  With you tech skills you should be able to narrow down results.  Search results are listed with the best hits listed first and that helps because there can be a lot of hits from several newspapers.  I have used it for other purposes.    
   The search fields are on the left side of the front page.  Be sure to scroll down below the search fields where you will find a scrolling horizontal line that has some tips on searching.  Obviously, narrowing the search will help.  You will find lots of info on Colgate football which could be helpful or searching might drive you crazy.  The site is pretty much the work of one man and must take a heck of a lot of time.  
   http://fultonhistory.com/Fulton.html
View user's profile Send private message
PostPosted: Thu Jan 14, 2016 12:25 am Reply with quote
Gate63
Site Admin
 
Joined: 13 Dec 2015
Posts: 159
Location: NJ




Gate Raider wrote:
Ryan, below is a link to a site you might not be familiar with but could be helpful in looking up some football stats. The name is misleading.  It is free and has microfiche copies of many NY state newspapers (Madison even had one)  that can be searched (by a name, school, school sport, and on).  Many of the papers go back into the 1800's.  It is quite voluminous but it works.  With you tech skills you should be able to narrow down results.  Search results are listed with the best hits listed first and that helps because there can be a lot of hits from several newspapers.  I have used it for other purposes.    
   The search fields are on the left side of the front page.  Be sure to scroll down below the search fields where you will find a scrolling horizontal line that has some tips on searching.  Obviously, narrowing the search will help.  You will find lots of info on Colgate football which could be helpful or searching might drive you crazy.  The site is pretty much the work of one man and must take a heck of a lot of time.  
   http://fultonhistory.com/Fulton.html


Thanks! I can't tell you how many hours I have sunk into that site and how many gigabytes of PDF documents I have saved from it. That and the Colgate Library Digital Archives (http://exlibris.colgate.edu/digital/index.html) have made this possible. Even so, there are 3 full games from 1905-1919 that I have not been able to find any scoring stats on:

- 1905 vs Cortland
- 1908 vs Hobart
- 1910 vs Clarkson

Every other game is almost 100% accounted for with the exception of who kicked an extra point here and there. As I work into the 1920's and 30's I'm sure I will be tempted to track more than just touchdowns, field goals, and extra points because the record keeping got a little better.

_________________
www.colgatefootballcollection.com
View user's profile Send private message Visit poster's website
PostPosted: Thu Jan 14, 2016 9:27 pm Reply with quote
Gate Raider
Adonal Foyle Club
 
Joined: 13 Dec 2015
Posts: 90




Sorry, I thought I had something for you.  You are right, that site consumes hours and can be annoying.  I'll search for info on those three games but, if you didn't find anything, I doubt I will.
View user's profile Send private message
PostPosted: Sun Jan 17, 2016 5:00 pm Reply with quote
Gate63
Site Admin
 
Joined: 13 Dec 2015
Posts: 159
Location: NJ




Re-writing the record books some more. Not in a good way though. Colgate's record in 1900 is listed as 3-7, but that will soon be changed to 2-8. The second game vs Colgate Academy was actually a 6-0 loss, not a 6-0 win. This will impact every milestone win since then (100th, 200th, 300th, etc.)  Shocked


_________________
www.colgatefootballcollection.com
View user's profile Send private message Visit poster's website
Stats Project
 colgatesports.myfastforum.org Forum Index -> Football
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
All times are GMT - 5 Hours  
Page 1 of 3  
Page 1, 2, 3  Next
  
  
 Post new topic  Reply to topic  
Powered by phpBB © 2001-2003 phpBB Group.     Theme created by Vjacheslav Trushkin.
Create your own free forum | Buy a domain to use with your forum