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...
Pete Posted January 11, 2013 Share Posted January 11, 2013 http://www.nhl.com Link to comment Share on other sites More sharing options...
Hornet Posted January 11, 2013 Author Share Posted January 11, 2013 http://www.nhl.com Nice find! Must save it to my favorites for the future! Link to comment Share on other sites More sharing options...
Pete Posted January 11, 2013 Share Posted January 11, 2013 It would help you immensely, since they have an entire Web site devoted to what you're trying to do with an Excel sheet... Link to comment Share on other sites More sharing options...
Hornet Posted January 11, 2013 Author Share Posted January 11, 2013 Well that much is obvious, but I can't copy their source code and I want to have it in an Excel file. Link to comment Share on other sites More sharing options...
Pete Posted January 11, 2013 Share Posted January 11, 2013 Whatever floats your boat. You have black and white TV, too? :D Link to comment Share on other sites More sharing options...
H-Dreamer Posted January 11, 2013 Share Posted January 11, 2013 You clearly have to much time in your life hornet. lol Link to comment Share on other sites More sharing options...
Fuhgeddaboudit Posted January 11, 2013 Share Posted January 11, 2013 Looks pretty cool. I'd love to have that excel spreadsheet haha, but I would never have the time to do it. Link to comment Share on other sites More sharing options...
ZebraDude Posted January 11, 2013 Share Posted January 11, 2013 As Peetie noted, it's all done for you on the NHL's website. Why recreate the wheel when it's one click away?? Link to comment Share on other sites More sharing options...
Dave Posted January 11, 2013 Share Posted January 11, 2013 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. Link to comment Share on other sites More sharing options...
Pete Posted January 11, 2013 Share Posted January 11, 2013 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. Link to comment Share on other sites More sharing options...
josh Posted January 11, 2013 Share Posted January 11, 2013 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. Link to comment Share on other sites More sharing options...
Pete Posted January 11, 2013 Share Posted January 11, 2013 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. Link to comment Share on other sites More sharing options...
josh Posted January 11, 2013 Share Posted January 11, 2013 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? Link to comment Share on other sites More sharing options...
Pete Posted January 11, 2013 Share Posted January 11, 2013 :rofl: Link to comment Share on other sites More sharing options...
H-Dreamer Posted January 11, 2013 Share Posted January 11, 2013 Even if he uses the spoiler tag? lol, can't rep you damnit Link to comment Share on other sites More sharing options...
Dave Posted January 11, 2013 Share Posted January 11, 2013 To do that in excel is nearly impossible. Exel has if/then logic, it can't be all that hard. Link to comment Share on other sites More sharing options...
Pete Posted January 11, 2013 Share Posted January 11, 2013 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. Link to comment Share on other sites More sharing options...
Dave Posted January 11, 2013 Share Posted January 11, 2013 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. Link to comment Share on other sites More sharing options...
Pete Posted January 11, 2013 Share Posted January 11, 2013 So he needs and Access expert. Link to comment Share on other sites More sharing options...
Morphinity 2.0 Posted January 11, 2013 Share Posted January 11, 2013 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. Link to comment Share on other sites More sharing options...
Hornet Posted January 11, 2013 Author Share Posted January 11, 2013 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. Link to comment Share on other sites More sharing options...
Pete Posted January 11, 2013 Share Posted January 11, 2013 You're welcome! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.