+ Reply to Thread
Results 1 to 2 of 2

Hockey Stats Tracking - Data Entry add to data on other sheets in specific scenarios

  1. #1
    Registered User
    Join Date
    02-20-2012
    Location
    Powell River, BC
    MS-Off Ver
    Excel 2007
    Posts
    32

    Hockey Stats Tracking - Data Entry add to data on other sheets in specific scenarios

    For the last little while, I've been building a master excel sheet for the hockey team I cover. I would like to take this to the next level. Please view the attachment to follow along while I try to describe what's in my head:

    scoresheet.xlsx

    I want to have a scoresheet for every game (56 in total, each on a different date) and have the information that I enter into it during a game, feed the players (21 in total, all different numbers) individual game logs. I've provided examples of both in the attachment.

    In the case of the attachment above, I've entered 3 goals into the sheet, all scored by number 27. However I only really care about the ones scored by my players (marked as 'k' in the 'team' column). The 3rd 27, scored by team 'O' doesn't need to be tabulated anywhere else. So part one of the challenge is to tabulate the number of goals scored by a player, then use that information to fill their player game log (sheet '27') in the attachment.

    HOWEVER...

    I also want to track types of goals. So in this case, 27 scored a goal EV (even strength) and PP (powerplay). You can see cells available for all different types of goals, each with their own abbreviation (EV, PP, SH, EN, PS). So a goal from K #27 that is PP in type column (Y), then puts a 1 in I4 of sheet '27'. Then the next game, if 27 scores a SH goal, a 1 would be added to J5 on sheet '27'.

    Does this make sense? I essentially want the scoresheet to automatically fill out the player logs for scoring. I'd like to extend this to penalties as well, but that's down the line and if I can get a handle for the required formula/technique, then I can hopefully apply it to other areas as well.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Hockey Stats Tracking - Data Entry add to data on other sheets in specific scenarios

    could you give an example of what you are trying to achieve? for instance, what data comes from where, and goes to where, based on what conditions

    will each game be on a new sheet, or how will it be recorded?
    how do you tell who scored.

    im sure that we can come up with something to help you with, it may just take a lot of back-and-forth to make sure you get what you want
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1