1. If you haven't seen already, TSO is now powered by Discord! This means that we will eventually be disbanding the embedded chat on the main forum page. Head to this page to learn more on how to integrate your TSO account with discord! https://traditionsportsonline.com/wiki/discord-integration/

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,956
    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