I've revisited the idea of creating a program based around the NFL. Here's what I've got. I've saved the Wikipedia entries for the NFL draft from 1990-2005 as .html files on my hard drive. Here's what I want to do. Take this information and either create a program that takes this information and sorts it by team/pick (or) pick/team (in either order) and outputs it all into a single list that would look like this Name / Team / Pick Joe Schmoe / Miami Dolphins / 1 Then I would take that organized data and create something that makes it searchable via division "AFCE", or round "1". This would be a graphical user interface (GUI). I would then search up those players statistics on a certain website and import that data into the page and make it show above average (green) average (bold) or below average (red). Except I've been searching all afternoon. I know there must be something out there. Either I just don't have the technical know how (entirely possible), or I'm just making this way more complicated than it needs to be. At least for the sorting this stuff and putting it into one sheet. Can anyone help?
Open Excel -> Past Special -> Text (rather than html or unicode). You then have 5 columns- Pick/Team/Player/Position/College You could then auto-fill a draft year into another column if you wanted. You could then sort players by pick, name, position, team, etc. Doing stuff beyond that I am not sure. I have a book on excel that I haven't opened in 6 years that I'm certain could tell how to do everything else. I don't know where it is though.
I could almost see doing it in Excel...almost. Except the search function. But I'm pretty sure it could be done in Access.
Yeah I kind of want to create the program anyway. The sorting of data is just the preliminary step that is necessary. Once that is sorted I want to stick it into a program (something with Python) and have it do all that stuff..
Well there is a find function. I know it's not the same, but... I'm certain you could link each pick to other workpages within excel and make them team specific, etc. I've not really ever used access, so I can't much relate. I have done a lot in excel though, including macro and vb stuff.