Jump to content
EFL News
ECFA: MONDAY WEDNESDAY FRIDAY SATURDAY EFL: TUESDAY THURSDAY FRIDAY SATURDAY

Career Statistics Template


McWolf
 Share

Recommended Posts

So I have been asked a bunch of times if I could do lists for career records by current GMs and ADs. I would have wanted to help with it, but I also didn't really want to have to update 12 different teams' record lists every season so, when Zeke asked me to show him how to do a career statistics spreadsheet, I decided I would build one that every GM or AD could use:

 

Career Records Template

 

There are a total of 17 tabs:

 

- The first one is where you will input the team you want the stats for. Just use the same abbreviation that's used in the index.

 

- A set of 8 "positions" (Passing, Rushing, Receiving, Defense, Kicking, Punting, Offensive Line, Kick Returning) split in two tabs each:

 

- The DATA tabs is where you will input the raw data, so just copy paste the full tables from the index (without the header) for all the seasons you need. You will have to do it 8 times, for each of the stat page.

 

- The sheet will work its magic (it will filter to only get the rows with the team you selected in the TEAM tab and give the sum of the statlines of each of these players) and the career stats will be available in the LIST tabs.

 

That's pretty much it. Just make a copy of the sheet and start making lists yourself. Let me know if there are any problem with it.

  • Like 3
  • Love 1
  • That's Lit! 1
Link to comment
Share on other sites

  • 9 months later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...