Golf League - Annual Scorecard for each player, each hole format issue

I want to track individual scores for each golfer in my golf league on a hole by hole basis. My goal is to see, for example, how many pars\birdies\bogies\etc. Golfer A had on hole #1 throughout the year. I'm struggling to find the best format of the spreadsheet. I'm not so much concerned about what I will do with that data at the end of the season right now (I'm sure I'll be back for help at that point). Ultimately I'm going to show which holes saw the most birdies, pars, bogies...which golfers had the most birdies both aggregately and on a hole by hole basis...among other things.

- 36 players, 7 subs (for the sake of this project, we can just focus on the 36 regular players).
- 1 course - we play 9 holes one week, the other 9 holes the following week
- 17 weeks

My initial thought is putting the golfer's names in column A. Then put the dates in Row A. Where I get lost is where to put the hole numbers (1-18). I saw some other threads where they didn't list Dates. They used formulas by setting up Par, then birdie would be Par-1, Bogie would be Par+1, or something along those lines.

Any help is appreciated. Just looking for someone to point me in the right direction. I realize this will be a lot of data entry but I think the end product will be really awesome.

Sorry about that. I am using a Mac but it's Microsoft Excel 2013 I believe (maybe 2011)

Should I be posting this somewhere else? I figured since I am using a Mac I would post in this section but I use a PC at work so either would work. I am mainly struggling with the formatting of it, and not so much the formulas.

I have seen a lot of individual scorecard tracking templates. The more I think about it, I think this is going to likely involve individual worksheets for each golfer where their weekly results are added. Dates would be in Column A (rows 2-19), Hole #s 1-18 would be in Column B-S.

Then have one aggregate worksheet. Golfer Names in the first column down to row 37 for the 36 golfers, hole #s across the top.

In the aggregate worksheet, it would add up the number of Birdies, Pars, Bogies, Double Bogies, etc. per golfer based on the data entered in their individual worksheet.

With all of the data in the aggregate worksheet, I could also determine the league average on a hole by hole basis, individual averages on a hole by hole basis, who had the most birdies in the whole season (all holes and individual holes).

I was hoping someone has attempted tracking something along these lines for an entire league as opposed to just an individual summary. If there were any good templates out there or recommended formats to use, that would be awesome.

Thanks, I've seen this one too. This would be perfect for an individual trying to track his\her own scores. This is what I've been basically working off of (in my head) but I'll try mocking something up. It's hard to do that when the league hasn't started yet. Thank you for your help!

OK I'm back...I attached a mock-up which I will admit is using a lot of ideas from the website that you gave me before. I thought about ways to make that work for my particular project.

The two tabs next to Aggregate -- Baldi and Joey B -- are the only two golfers I added the weekly scorecard to so far. The rest are blank.

What do you think? Without any data to use, this becomes sort of a trial and error situation but I'm wondering if there is anything that I'm missing, that I can improve on, or if anyone has suggestions to make this better.