football statistics

finally got around to that nfl spreadsheet i mentioned some time back. i have gotten the AFC complete for the most part, but the one big remaining piece of the puzzle is the conference per college. i have this: jersey #, name, position, height, weight, date of birth / age, yrs in league, college, team. the height and DOB / age are inconsistently formatted across team websites -- well really the entire body of data is inconsistently formatted, but the worst is the DOB / age and height. the years in league is also somewhat inconsistent, and because the position and college are verbiage, i doubt they are consistent, either. however, my brief analysis reveals that when i collected the active rosters on 27 septembre, there were 848 men on active AFC rosters and their total weight was 209633 lbs - that's just under 109 tons and an average 247 lbs per player.

i sorted on college and got only marcus buggs and jovan haye from vanderbilt. interesting. i know there are 3 bears from vandy which means there are more bears from vandy than in the entire AFC. some schools are listed differently, such as "kentucky" or "university of kentucky", but there is mostly consistency enough to sort it out. there are 9 players from hawaii, 20 from lsu, 5 from marshall, 18 from purdue, 1 from william & mary, 3 from harvard, 1 from nicholls state.

what i wanted to find out is which conference sends the most players to the NFL. i am not really much closer to learning that, now am i. after i get the NFC done, i'll work on the conference thing. maybe i'll get the NFC done tomorrow. goodness knows i'm not doing much at work. [haha.]