Any Excel experts here? (Rangers related Excel)

So out of boredom I started preparing a Rangers season 2012-2013 Excel file in the past few days.

It's somewhat automated, but I would like to have someone to have a look and see if I overlooked something. It's pretty simple in formatting and stuff like that, but I put it together in 2 days. Mihht add more sections e.g. financial etc.

You need to fill in the score and if the game went to OT then the OT column. It counts the record and points automatically.

http://img.tapatalk.com/d/13/01/11/yruhaqy3.jpg

There's a link to each game sheet, where I fill in the goal scorers and whether a guy played or not. Again it counts the game based stats automatically. Might still add other stats as well. Now it's just goals, assists and saves...

http://img.tapatalk.com/d/13/01/11/8ynumyme.jpg

Each game has its own sheet so it counts them together in another sheet as season stats. Again it's just GP, G, A and PTS based. Might add other stats as well, if can be bothered.

http://img.tapatalk.com/d/13/01/11/enunu9ev.jpg

Also started working on a player based sheet, but up until now I don't know how to write the functions automatically without having to edit each cell individually. And it would be like 48*25 cells = 1200 cells...if anybody knows, your help would be appreciated. I could still play around with macros, but rather not.

http://img.tapatalk.com/d/13/01/11/3unaqymu.jpg

So any real Excel Gods here that wanna take a look? I'm pretty good myself, but far from a God.

http://www.nhl.com

Nice find! Must save it to my favorites for the future!

Whatever floats your boat.

You have black and white TV, too? :D

As Peetie noted, it's all done for you on the NHL's website. Why recreate the wheel when it's one click away??

The one thing you can't do with NHL.com that you can do if you have all the raw data is create your own comparables. Say you want to know how many goals Nash scored where Richards had the primary assist. Can't do that on NHL.com, but you could do that if you recorded that sort of data yourself.

The one thing you can't do with NHL.com that you can do if you have all the raw data is create your own comparables. Say you want to know how many goals Nash scored where Richards had the primary assist. Can't do that on NHL.com, but you could do that if you recorded that sort of data yourself.

To do that in excel is nearly impossible.

Unless you're an excel expert - hence the thread.

I think its a cool idea. I have no advice with excel, though.

Unless you're an excel expert - hence the thread.

 

 

I think its a cool idea. I have no advice with excel, though.

Even if you're an expert, excel isn't that capable, because when your file has too many tabs and formulas, excel crashes.

Even if you're an expert, excel isn't that capable, because when your file has too many tabs and formulas, excel crashes.

Even if he uses the spoiler tag?

Even if he uses the spoiler tag?

lol, can't rep you damnit

To do that in excel is nearly impossible.

Exel has if/then logic, it can't be all that hard.

Exel has if/then logic, it can't be all that hard.

I know it's theoretically possible, but that amount of data in one workbook is is unsustainable.

I know it's theoretically possible, but that amount of data in one workbook is is unsustainable.

Ok, so import the spread sheets into Access and use that to run reports.

It doesn't take an expert to run those Access queries cross-referencing Nash goals by Richards primary assists. That's the basis of Access.

Doing that kind of stuff in Excel is difficult because it's not built for that. It's built to store data and calculate data.

I know a boatfull of if/when/then/countif/sumif functions. I'm pretty good with Excel, but not a wizard. I know my way with data validations and so on.

I'm doing this for myself. I like to keep up stats, do calculations, probabilities for betting etc. stuff like that.

I will look into Access, but doubt I could do it by myself. Thanks for the suggestions, though. Except for the NHL.com ones.