OMFL - Individual Player Stat Book

Discussion in 'Thread Archive' started by BadaBing319, Sep 30, 2010.

  1. BadaBing319

    BadaBing319 OMFL Broncos / PMFL Eagles

    Joined:
    Jul 16, 2010
    Messages:
    1,409
    OMFL - Individual Player Stat Book

    Hey guys, glad to be on board in the OMFL. Lost my first game last night, but it was a battle and I'm looking forward to competing with the rest of you.

    I've been working with a couple of the board members trying to figure out something I could contribute to the league on a weekly basis. I was checking out Win's awesome team stat book when the idea of an individual player stat book hit me.

    I did some digging and figured out that with our new League Central tool (be sure to check it out if you haven't already), I am able to extract the stats to Excel. From there, I did some messing around with the data and uploaded it to Google Docs. That's when it really got interesting - I had no idea the stuff Google Docs could do. Using just 3 Excel sheets of stats downloaded from LC (NFL passing, NFL rushing, NFL receiving in the google spreadsheet), I was able to write formulas to automatically generate the following 39 sheets of data:

    • 6 AFC/NFC Stat Sheets - individual player passing, rushing & receiving stats filtered out by conference.
    • 32 Team Stat Pages - individual offensive stats for all 32 teams
    • Team Tendency page - with formulas on the team stat pages, I was able to come up with a tendency sheet, which basically says how often a team runs vs. passes. Nice little scouting tool :)

    Here's a link to my creation: OMFL Individual Stat Book

    I will be updating this at every advance so we'll always have a fresh set of statistics to look at. A lot easier than trying to navigate through the Online Franchise site!

    Let me know what you guys think...hopefully at least a few of you stat-junkies out there will get something out of it.
     
  2. Emmdotfrisk

    Emmdotfrisk Working half days on my days off.

    Joined:
    Oct 8, 2009
    Messages:
    11,955
    Nice! Good to have someone else on board that knows excel! Keys collaborate sometime and exchange some macros!
     
  3. Claven

    Claven OMFL-Redskins

    Joined:
    Oct 8, 2009
    Messages:
    1,686
    Nice work Bada
     
  4. Winuvas

    Winuvas OMFL Jets

    Joined:
    Oct 8, 2009
    Messages:
    5,849
    Yeah. You excel nerds make my head hurt. I know just enough to not get me into trouble, and even that I barely know. :)
     
  5. bigox1337

    bigox1337 Walk On

    Joined:
    Oct 8, 2009
    Messages:
    2,334
    hell yeah bada, your the man, gotta love football stats wither madden or NFL
     
  6. natedawg212000

    natedawg212000 New Orleans Saints

    Joined:
    Jul 29, 2009
    Messages:
    6,558
    pretty amazing stuff
     
  7. natedawg212000

    natedawg212000 New Orleans Saints

    Joined:
    Jul 29, 2009
    Messages:
    6,558
    this for only offense?
     
  8. Miklos_Nyiszli

    Miklos_Nyiszli Walk On

    Joined:
    Sep 16, 2010
    Messages:
    735
    looks great but what nate said is it only offense?
     
  9. BadaBing319

    BadaBing319 OMFL Broncos / PMFL Eagles

    Joined:
    Jul 16, 2010
    Messages:
    1,409
    I had some individual defense stats, but they didn't seem to have everyone in the file. Instead of just having half of the players, I decided to wait until I had a little more time to work on it. Hopefully this week or next...
     
  10. natedawg212000

    natedawg212000 New Orleans Saints

    Joined:
    Jul 29, 2009
    Messages:
    6,558
    cool. looks pretty freaking awesome.
     
  11. BadaBing319

    BadaBing319 OMFL Broncos / PMFL Eagles

    Joined:
    Jul 16, 2010
    Messages:
    1,409
    Individual stat book is also updated through week 9. Working on adding some more features to it (possibly league leaders) this weekend...

    Also, figured out a quick way (took me less than 2 minutes) to copy your team's stats from the stat book and paste them on the forum in table format. See below:

    Passing Games Comp Att Comp % Pass Yds Yds/Att Yds/Gm TD INT QB Rating
    Kyle Orton 8 128 220 58.18 1796 8.16 224.5 15 9 90.27
    Tim Tebow 5 5 13 38.46 105 8.08 21 2 1 75.32
    Brady Quinn 2 8 15 53.33 73 4.87 36.5 66.81
    Derek Anderson 2 1 3 33.33 19 6.33 9.5 56.25


    Rushing Games Att Rush Yds Yds/Att Yds/Gm TD
    Knowshon Moreno 7 122 455 3.73 65 2
    Tim Tebow 4 7 56 8 14 1
    Correll Buckhalter 3 17 42 2.47 14
    Justin Fargas 2 8 17 2.13 8.5
    LenDale White 2 6 15 2.5 7.5
    B.J. Askew 1 1 3 3 3
    Demaryius Thomas 1 1 3 3 3
    Eddie Royal 1 1 2 2 2
    Kyle Orton 6 12 1 0.08 0.17


    Receiving Games Rec Rec Yds Yds/Rec Yds/Gm TD
    Eric Decker 7 30 488 16.27 69.71 5
    Terrell Owens 8 25 418 16.72 52.25 4
    Demaryius Thomas 8 23 307 13.35 38.38 3
    Daniel Graham 6 12 176 14.67 29.33
    Knowshon Moreno 5 12 115 9.58 23
    Correll Buckhalter 1 4 104 26 104 1
    J.P. Foschi 2 2 32 16 16
    Brandon Stokley 2 3 29 9.67 14.5 1
    B.J. Askew 4 8 24 3 6
    Justin Fargas 1 2 20 10 20
    Dezmon Briscoe 1 1 18 18 18
    Dedrick Epps 2 2 13 6.5 6.5


    If you guys are interested in doing this, let me know and I can write up a quick tutorial. I posted mine in my team news thread:
    http://traditionfootball.com/forums/showthread.php?goto=newpost&t=36941
     
  12. BadaBing319

    BadaBing319 OMFL Broncos / PMFL Eagles

    Joined:
    Jul 16, 2010
    Messages:
    1,409
  13. BadaBing319

    BadaBing319 OMFL Broncos / PMFL Eagles

    Joined:
    Jul 16, 2010
    Messages:
    1,409
    Updated through week 10...stat of the week to follow shortly.
     
  14. Big D

    Big D Walk On

    Joined:
    Oct 8, 2009
    Messages:
    4,398
    Nice work again.
     
  15. BadaBing319

    BadaBing319 OMFL Broncos / PMFL Eagles

    Joined:
    Jul 16, 2010
    Messages:
    1,409
  16. BadaBing319

    BadaBing319 OMFL Broncos / PMFL Eagles

    Joined:
    Jul 16, 2010
    Messages:
    1,409
    Updated through week 14 games...
     
  17. pbates86

    pbates86 Walk On

    Joined:
    Mar 5, 2010
    Messages:
    835
    NFC recieving tab actually has the AFC recievers.
     
  18. BadaBing319

    BadaBing319 OMFL Broncos / PMFL Eagles

    Joined:
    Jul 16, 2010
    Messages:
    1,409
    Thanks for pointing that out - it's now fixed...
     
  19. BadaBing319

    BadaBing319 OMFL Broncos / PMFL Eagles

    Joined:
    Jul 16, 2010
    Messages:
    1,409

Share This Page