1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

there has got to be an easier way

Discussion in 'Lounge' started by anlgp, Oct 31, 2009.

Tags:
  1. anlgp

    anlgp ↑ ↑ ↓ ↓ ← → ← → B A

    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?
     
  2. NaboCane

    NaboCane Banned

    31,949
    11,899
    0
    Nov 24, 2007
    Sounds like something an Access expert could do.

    Any of you geeks here?
     
  3. Stitches

    Stitches ThePhin's Biggest Killjoy Luxury Box

    53,148
    31,935
    113
    Nov 23, 2007
    Katy, TX
    I'm a geek, but not big enough of one apparently. Or at least my expertise is elsewhere.
     
  4. anlgp

    anlgp ↑ ↑ ↓ ↓ ← → ← → B A

    I'm a geek too, but not like this.
     
  5. Stitches

    Stitches ThePhin's Biggest Killjoy Luxury Box

    53,148
    31,935
    113
    Nov 23, 2007
    Katy, TX
    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. :lol:
     
    anlgp likes this.
  6. NaboCane

    NaboCane Banned

    31,949
    11,899
    0
    Nov 24, 2007
    I could almost see doing it in Excel...almost. Except the search function.

    But I'm pretty sure it could be done in Access.
     
  7. anlgp

    anlgp ↑ ↑ ↓ ↓ ← → ← → B A

    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..
     
  8. Stitches

    Stitches ThePhin's Biggest Killjoy Luxury Box

    53,148
    31,935
    113
    Nov 23, 2007
    Katy, TX
    Well there is a find function. I know it's not the same, but... :confused2:

    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.
     
    anlgp likes this.
  9. NaboCane

    NaboCane Banned

    31,949
    11,899
    0
    Nov 24, 2007
    Gotcha.
     

Share This Page