boubabi 4,725 Posted October 30, 2013 Share Posted October 30, 2013 Or any spreadsheet ? I want to improve some way a spreadsheet that I'm doing but my knowledge is limited. I'm trying to do something to help me doing my stats but I'm not sure this is not optimal. Link to comment https://vhlforum.com/topic/1782-whos-good-with-excel/ Share on other sites More sharing options...
Head Moderator frescoelmo 1,276 Posted October 30, 2013 Head Moderator Share Posted October 30, 2013 Excel is almost entirely what I use at work, hit me up if you need help. Link to comment https://vhlforum.com/topic/1782-whos-good-with-excel/#findComment-7539 Share on other sites More sharing options...
Mike 708 Posted October 30, 2013 Share Posted October 30, 2013 Ya I use it to upload data feeds for selling products online. Theres a lot of click+drag/formulas/etc that can be used to make things easier. Link to comment https://vhlforum.com/topic/1782-whos-good-with-excel/#findComment-7545 Share on other sites More sharing options...
Edgar 283 Posted October 30, 2013 Share Posted October 30, 2013 There's also lots of youtube videos that are pretty good at explaining things. Just make sure that you mimic the videos instead of just listening, or else you will forget everything Link to comment https://vhlforum.com/topic/1782-whos-good-with-excel/#findComment-7568 Share on other sites More sharing options...
CoachReilly 688 Posted October 30, 2013 Share Posted October 30, 2013 describe your issue. i'm good. Link to comment https://vhlforum.com/topic/1782-whos-good-with-excel/#findComment-7572 Share on other sites More sharing options...
boubabi 4,725 Posted October 30, 2013 Author Share Posted October 30, 2013 Well, here the speadsheet. https://docs.google.com/spreadsheet/ccc?key=0Ao1TE1RwokBAdDRBNGYySmJ0WkVBRTZLZ2xnT0lJOWc#gid=0 The first page has 2 boards. The first one called New stats and the other one is called old stats. In the other tab named ''calcul'', it's adding a goal or a pass each time you add a letter in a a column. Column E is for goals and column F is for pass. So if I add a letter in E2, Marc Mancari I'll have +1 goals in his stats. This kind off messy and thats why I don't think this is optimal. Sorry for this poor explication but look ak yourself what is my spreadsheet and if you have any idea how Can I improve this. Link to comment https://vhlforum.com/topic/1782-whos-good-with-excel/#findComment-7592 Share on other sites More sharing options...
CoachReilly 688 Posted October 30, 2013 Share Posted October 30, 2013 requested access. sounds like a simple =SUMIF or =COUNTIF could help? Link to comment https://vhlforum.com/topic/1782-whos-good-with-excel/#findComment-7597 Share on other sites More sharing options...
boubabi 4,725 Posted October 30, 2013 Author Share Posted October 30, 2013 oups updated. Now public Link to comment https://vhlforum.com/topic/1782-whos-good-with-excel/#findComment-7598 Share on other sites More sharing options...
CoachReilly 688 Posted October 30, 2013 Share Posted October 30, 2013 i'm confused as to the end goal i guess. Link to comment https://vhlforum.com/topic/1782-whos-good-with-excel/#findComment-7600 Share on other sites More sharing options...
boubabi 4,725 Posted October 30, 2013 Author Share Posted October 30, 2013 Let me explain you. I need to calculate my team stats. To do this, I need to see my game reports. Here's what it looks like. St. Louis Blues 5 , Detroit Red Wings 3 Shots: 25 - 29 STL PP: 0 of 1 (2 shots), Passing:69/77=89 %, Challenges:21/53=38 % DET PP: 0 of 0 (0 shots), Passing:70/88=79 %, Challenges:34/49=68 % Attendance: 19260 of 19260 (Kiel Center) Ticket income: 525798 Match televised: Yes BOXSCORE OF THE GAME ----------------------------------------------- 18:06 0-1 DET Shawn Matthias [12] (Stephen Weiss, Jason Zucker) 18:59 1-1 STL Viktor Stalberg [18] (Patrik Berglund) 19:41 2-1 STL Chris Stewart [18] (Ryan Whitney, Roman Polak) ------------------------------------------------------------ 29:42 2-2 DET Mattias Öhlund [4] (Shawn Matthias, Andrew Cogliano) 35:22 3-2 STL Andrew Ladd [31] (T.J. Oshie) ------------------------------------------------------------ 43:09 3-3 DET Daniel Alfredsson [24] (Tobias Enström, Jason Zucker) 49:02 4-3 STL Alexander Steen [20] (Erik Karlsson, Alex Pietrangelo) 59:54 5-3 STL Brenden Morrow [12] (Alexander Steen) EN ------------------------------------------------------------ Penalty summary: ----------------- ------------------------------------------------------------ ------------------------------------------------------------ 43:49 DET Justin Abdelkader (2 min for elbowing) ------------------------------------------------------------ St. Louis Blues scoring. ( G A Sh Hi Ga Ta PIM, +/- Icetime Rating) R Mark Mancari 0 0 1 0 2 0 0 0 6.40 5 R Chris Stewart 1 0 3 1 5 1 0 1 12.20 6 R Viktor Stalberg 1 0 2 2 4 0 0 0 19.30 7 R T.J. Oshie 0 1 3 1 3 0 0 1 19.30 7 C Dominic Moore 0 0 0 2 1 0 0 0 6.40 6 C Jaden Schwartz 0 0 1 0 2 1 0 1 13.40 6 C Patrik Berglund 0 1 4 3 1 2 0 1 20.30 8 C Derek Roy 0 0 2 1 1 0 0 0 19.10 7 C Adam Burish 0 0 0 2 1 2 0 0 6.40 6 L Brenden Morrow 1 0 2 0 0 0 0 1 12.50 7 L Alexander Steen 1 1 2 0 2 0 0 0 21.00 7 L Andrew Ladd 1 0 3 4 5 3 0 1 21.30 7 D Justin Braun 0 0 1 0 0 2 0 1 12.30 7 D Erik Karlsson 0 1 0 0 1 0 0 0 22.50 6 D Alex Pietrangelo 0 1 0 3 1 2 0 1 26.40 9 D Ryan Whitney 0 1 0 0 2 1 0 1 11.00 6 D Roman Polak 0 1 1 0 0 0 0 1 22.30 6 D Robyn Regehr 0 0 0 1 1 1 0 0 24.30 6 (GA, A, Sv , PIM, +/- Icetime Rating) G Ben Scrivens 3 0 26 0 0 60.00 7 G Jaroslav Halak 0 0 0 0 0 0.00 0 Detroit Red Wings scoring. ( G A Sh Hi Ga Ta PIM, +/- Icetime Rating) R Landon Ferraro 0 0 0 0 1 1 0 0 9.30 4 C Andrew Cogliano 0 1 2 2 0 2 0 2 16.40 7 R Daniel Alfredsson 1 0 3 0 1 0 0 -2 16.30 7 R Johan Franzen 0 0 2 0 2 0 0 -2 17.20 5 C Patrice Cormier 0 0 0 2 0 4 0 0 9.30 7 C Shawn Matthias 1 1 4 2 1 2 0 2 14.40 9 C Stephen Weiss 0 1 5 0 1 0 0 -2 16.30 6 C Pavel Datsyuk 0 0 2 1 0 0 0 -2 17.20 7 L Joakim Andersson 0 0 1 2 0 4 0 0 11.30 8 L Justin Abdelkader 0 0 2 3 0 3 2 2 14.40 7 L Jason Zucker 0 2 5 0 1 0 0 -2 16.30 8 L Henrik Zetterberg 0 0 3 0 3 0 0 -2 17.20 6 D Brian Lashoff 0 0 0 0 0 0 0 2 15.00 5 D Kyle Quincey 0 0 0 1 0 1 0 -2 18.40 6 D Erik Gudbranson 0 0 0 3 3 4 0 -2 26.20 6 D Mattias Öhlund 1 0 1 5 2 5 0 2 16.20 9 D Tobias Enström 0 1 0 1 0 1 0 -2 16.30 7 D Niklas Kronwall 0 0 0 3 0 5 0 -2 27.10 8 (GA, A, Sv , PIM, +/- Icetime Rating) G Jonas Gustavsson 5 0 20 0 0 58.00 4 G Petr Mrazek 0 0 0 0 0 0.00 0 Three stars of the game: 1st star: Alexander Steen 2nd star: Chris Stewart 3rd star: Viktor Stalberg Notes for St. Louis Blues: -Alexander Steen scored his 20th goal of the season. -Alex Pietrangelo notched his 30th assist of the season. -Viktor Stalberg finally ended his 18 game goal drought. Notes for Detroit Red Wings: -Shawn Matthias ended his 9 game goal drought. Other notes: Farm game result: Peoria Rivermen 4( 22) , St. John's IceCaps 3( 24) ------------------------------------------------------------ 0-1 SJO Tomas Jurco (Tomas Tatar) 1-1 PEO Anton Stralman (Anton Lander, Ben Lovejoy) 1-2 SJO Martin Frk (Ryan Sproul) 1-3 SJO Tomas Tatar (Tomas Jurco, Martin Frk) 2-3 PEO Ryan Tesink (Christian Hanson) 3-3 PEO Magnus Paajarvi (Ryan Reaves, Anton Stralman) 4-3 PEO Ty Rattie (Zach Hall) Goalies: Chet Pickard - Jared Coreau . Basically, every time my player score, I add a letter in his column and every time my player do an assists, I add another letter in the next column. My goal is to find a way to calculate this easily. Link to comment https://vhlforum.com/topic/1782-whos-good-with-excel/#findComment-7602 Share on other sites More sharing options...
CoachReilly 688 Posted October 30, 2013 Share Posted October 30, 2013 are these reports that come out in excel spreadsheets? Link to comment https://vhlforum.com/topic/1782-whos-good-with-excel/#findComment-7611 Share on other sites More sharing options...
boubabi 4,725 Posted October 30, 2013 Author Share Posted October 30, 2013 (edited) nope. Come from the sim If theres a way to insert these report in the spreadsheet and automatically calculate from this, this wll be optimal. But I don't know if this is possible Edited October 30, 2013 by boubabi Link to comment https://vhlforum.com/topic/1782-whos-good-with-excel/#findComment-7612 Share on other sites More sharing options...
CoachReilly 688 Posted October 30, 2013 Share Posted October 30, 2013 send the file / whatever output you get from your sim to me, fresco and crew. i believe you have my email. Link to comment https://vhlforum.com/topic/1782-whos-good-with-excel/#findComment-7633 Share on other sites More sharing options...
boubabi 4,725 Posted October 30, 2013 Author Share Posted October 30, 2013 (edited) well, it's a text file exported on dropbox http://dl.dropboxusercontent.com/u/175112496/SAISON%201/Jour%20143%20a%20149.txt and we ctrl+f (search) our team. (This case is STL for me) Edited October 30, 2013 by boubabi Link to comment https://vhlforum.com/topic/1782-whos-good-with-excel/#findComment-7637 Share on other sites More sharing options...
Edgar 283 Posted October 30, 2013 Share Posted October 30, 2013 You da Blues? Link to comment https://vhlforum.com/topic/1782-whos-good-with-excel/#findComment-7642 Share on other sites More sharing options...
boubabi 4,725 Posted October 30, 2013 Author Share Posted October 30, 2013 Link to comment https://vhlforum.com/topic/1782-whos-good-with-excel/#findComment-7645 Share on other sites More sharing options...
CoachReilly 688 Posted October 30, 2013 Share Posted October 30, 2013 hmm, i'll try something... maybe this weekend when i have some downtime. work is kicking my dick right now. Link to comment https://vhlforum.com/topic/1782-whos-good-with-excel/#findComment-7648 Share on other sites More sharing options...
.png.ed69a7260a477fcf4feead7a0e4b7506.png)
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now