Hornet Posted January 11, 2013 Share Posted January 11, 2013 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. Link to comment Share on other sites More sharing options...
This topic is now archived and is closed to further replies.