Keeping track of stats

[whughes]

I want to create a book in excel that i can enter in my stats on different sheets every week and then have one sheet that keeps a running total of the stats as i input them. I was wondering if anyone had already created something like this that they could send me? Or at least help me set up one for myself. Before you suggest it, I can't use the table generators on here because i don't have internet at my house. I'm posting this while at a friends house

[paarman]

Quote: Originally Posted by whughes

I want to create a book in excel that i can enter in my stats on different sheets every week and then have one sheet that keeps a running total of the stats as i input them. I was wondering if anyone had already created something like this that they could send me? Or at least help me set up one for myself. Before you suggest it, I can't use the table generators on here because i don't have internet at my house. I'm posting this while at a friends house

I have a spreadsheet that I've used for the past few years that I created myself. However, I've never added any formulas to total up any numbers or stats; if I've ever needed to do it for any reason, I've just totaled it myself... The game keeps career stats, so I've never had the need, and I'm not extremely fluent in Excel either.

I basically started using it back in Madden 10/11 for my offline franchise I would keep all the important stats down and use it year to year to track progression and improvement. I still use it now, but I don't fill in each players stats anymore, just their progression from season start to finish to determine if a player has improved reasonably over time.

If that's something you are interested in, shoot me a PM and I can send you the spreadsheet.

[roll2tide]

Quote: Originally Posted by whughes

I want to create a book in excel that i can enter in my stats on different sheets every week and then have one sheet that keeps a running total of the stats as i input them. I was wondering if anyone had already created something like this that they could send me? Or at least help me set up one for myself. Before you suggest it, I can't use the table generators on here because i don't have internet at my house. I'm posting this while at a friends house

Team stats or player stats or both?

[crawtv]

thats interesting, since iv been doing player reviews i have been keeping track of stats on stat sheets it actually really interesting. made a sick data point for Randy moss and how reliable he is

[mjavon]

I don't know that excel formulas can use data from different sheets, unfortunately.

[Beelzebot44]

Excel can definitely use data from other sheets and even other Excel workbooks. To get it to auto total you need to add two extra sheets, one at the start and one at the end. So the bottom would look something like:

|Start|Week 1|Week 2|... |Week 17|End|

Where each of those is a sheet for each game. Then, make a new sheet before the sheet called "Start" for the totals and use the formula "=SUM(Start:End!XX)" where XX equals the cell that you want totaled. I do this for my baseball team and it works really well.

[szostakzha]

i have been keeping track of stats on stat sheets

[dyukduken]

Team stats or player stats or both?