Jump to content
Sign in to follow this  
boBob

Excel Template/Program to calculate Season & Career Stats?

Recommended Posts

I'm trying to find a MS Excel based Stats Template/Program that will allow me to input Season Stats for multiple years and keep a running total of each wrestlers Career Stats too. I know you can by specific stat programs but I would like to have something on a program that will continue to last for a long time, as well as, be assessable by multiple people. MS Excel seems to be the most useful program for this type of venture. However I have yet to find a Excel based template/program that has the coding needed to input season stats (not necessarily individual match stats), translate that into automatically calculated career stats, and then provide a format where I could view both the season and career leaders. Does anyone have a useful link or suggestion?

Share this post


Link to post
Share on other sites

Creating a master datasheet and using pivot tables within Excel would be the most simplistic way to do it. Pivot tables also allow you to easily filter data for drill-down purposes.

 

You can hide the master data sheet and create a template for data entry, using macro buttons to append new data to the master. Pretty simple really.

Share this post


Link to post
Share on other sites
Creating a master datasheet and using pivot tables within Excel would be the most simplistic way to do it. Pivot tables also allow you to easily filter data for drill-down purposes.

 

You can hide the master data sheet and create a template for data entry, using macro buttons to append new data to the master. Pretty simple really.

 

Must be a tech thing cause that seems a little more than my Excel brain could produce.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

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.

Loading...
Sign in to follow this  

×
×
  • Create New...