2025 Endzone's Best Ball Challenge - Charles Schwab Challenge

#52
#52
GVF said:
I have an excel I set up for my use. A smaller version of what 95 prob does. I have it programmed for birdies, bogies, etc. Takes strokes away from my total if all 4 golfers bogie a hole, etc. All I have to do is put the par scores in for the course and put my golfer's scores in and the sheet does everything else.

I've tried importing scores before and then just do lookups to fill in the scores. Was going to jack my spreadsheet up and send it to 95, but I never got the score importing right. I'm sure there's ways to accomplish this that is probably pretty easy once figured out.

Even semi-manual, depending on how 95 has it set up, one can cut alot of corners doing this. Tab for each participant. Master table for each golfer selected by round. Lookup and sort tables. Setting up the weekly picks would take the longest. After that just enter the scores for the round and everything is done automatic at that point.
Click to expand...
This is very similar to what I created. I don't know how to auto insert the numbers onto different sheets (set up as you mentioned with each player) though, so i have to copy and paste each score each round. I screwed up initially with how I discovered the low score (somehow screwed up copying and pasting the "min" results).
 
#53
#53
Standings after Round 3. Again, please check your score...

NorCal67 -33
WestTennesseeFox -32
GordonC -30
Danl -28
joevol33 -28
82_VOL_83 -28
go aeiou -25
Tri-CitiesVol -25
Thunder Good Oil -25
95 Vol Alum -24
VolInNorthCack -23
MalinoisVol -21
volfanbill -21
YankeeVol -21
jhen713 -20
peaygolf -18
GVF -13
 
#61
#61
Congrats to @WTF. I really wanted those legos man... Please, please check your score.

WestTennesseeFox -42
NorCal67 -41
joevol33 -36
Danl -35
GordonC -33
82_VOL_83 -33
Tri-CitiesVol -30
Thunder Good Oil -30
95 Vol Alum -29
MalinoisVol -29
go aeiou -28
YankeeVol -26
VolInNorthCack -24
volfanbill -23
jhen713 -16
peaygolf -15
GVF -10

Imma wait on @95 Vol Alum to do Season Standings.
 
  • Like
Reactions: 95 Vol Alum and NorCalVol67
#68
#68
volfanbill said:
This is very similar to what I created. I don't know how to auto insert the numbers onto different sheets (set up as you mentioned with each player) though, so i have to copy and paste each score each round. I screwed up initially with how I discovered the low score (somehow screwed up copying and pasting the "min" results).
Click to expand...
I have a table by participant set up for each round. In the participant score cards, each a/b/c/d golfer has a row for each round. I can enter the golfer scores in the master tab for each round, but they have to sort in alphabetical order for vlookups to work. So, at that point each participant card references the round card with a lookup and copy function. In the participant cards I have a hidden table that calculates the strokes for a hole, and the visible card just copies that result. Then, I set up a standings sheet that does some calculations and sorts in a hidden tab that updates as you post scores. I had some things hit my brain yesterday and I finished it off and got it operational the way I envisioned it working for me if I were doing it, yet something anyone could pick up and use with about 2-3 minutes pondering. Not as involved as it sounds. I started by just making my own tracker. It's good for just one participant to follow thir golfers over the weekend. I used that as the base to build the group model, just to see if I could get it pretty slick sans score importing, with as little manual work as possible. Manager at the bowling center always asks me to set up tourney sheets to track this or that, or other needs just to see if I can make one to do what's in his head. It's just a fun challenge. Keeps the battery running the ticker.

sounds like you're pretty decent at excel also. I am better than average, but not the visual basic side of excel. I can't do that coding stuff in the background so I set up and hide alot of stuff and bring back in to what I want seen. Know a guy that has all that mastered and I no longer feel great about my skills.

You're welcome to it if you want it. In my final set up as it now exists, you do very little manually. You enter our picks on our cards. (We each have our own tab, alphabetically arranged to make finding us easy). Each round has it's own tab. Those Tabs auto populate with the golfers selected from our cards, and duplicates are filtered out. So, at hte end of each round you just enter all the selected scores in one place, enter a "Y" at the top of the round card where I have it highlighted, and all the cards pick up their scores, and the standings tab updates. I have it laid out like 95 posts it in here, so all you have to do is copy and paste each rounds updates in the thread. The primary quality check is that the golfers are spelled correctly on all the cards when you set them up. Any misspelling will pick up the wrong scores. For instance, if you spell Scheffler on a card without the 'C', the vlookop will stop at the name before his, and pick up that golfers score, or throw an error. By my estimate messing around with it, it's take about 30 minutes to put all our picks in, then 15-20 minutes to enter each rounds scores. So, i'm guessing 2 hours max for this portion, plus the extra time 95 spends on segment rankngs and points and such. The other thing to do when entering picks, is the top left cell (A1) on each card has to say ACTIVE or NA. THat way if a person misses a week they basically score 0 that week instead of EVEN par. All ACTIVE cards default to EVEN till scores are posted.

No clearing or deleting. Each week just open the master sheet, do a save as for the tourney week before you do anything else and you're set up. If any newcomers join in, there's 3 extra tabs to just change the names in and they're off and running.
 
  • Like
Reactions: volfanbill
#69
#69
VolInNorthCack said:
Good grief... -23 after two rounds. Finish -24? Guess my guys took a payoff.

GG Fox.
Click to expand...
You finished with 1 player. I think you shot even on day 3 and 1 under on day 4. @YankeeVol had Thorbjensen (sp) withdraw early in round 1. Sorry I didn’t get the players remaining list up. I checked your numbers multiple times because it was so weird to me
 
  • Like
Reactions: VolInNorthCack
#70
#70
GVF said:
I have a table by participant set up for each round. In the participant score cards, each a/b/c/d golfer has a row for each round. I can enter the golfer scores in the master tab for each round, but they have to sort in alphabetical order for vlookups to work. So, at that point each participant card references the round card with a lookup and copy function. In the participant cards I have a hidden table that calculates the strokes for a hole, and the visible card just copies that result. Then, I set up a standings sheet that does some calculations and sorts in a hidden tab that updates as you post scores. I had some things hit my brain yesterday and I finished it off and got it operational the way I envisioned it working for me if I were doing it, yet something anyone could pick up and use with about 2-3 minutes pondering. Not as involved as it sounds. I started by just making my own tracker. It's good for just one participant to follow thir golfers over the weekend. I used that as the base to build the group model, just to see if I could get it pretty slick sans score importing, with as little manual work as possible. Manager at the bowling center always asks me to set up tourney sheets to track this or that, or other needs just to see if I can make one to do what's in his head. It's just a fun challenge. Keeps the battery running the ticker.

sounds like you're pretty decent at excel also. I am better than average, but not the visual basic side of excel. I can't do that coding stuff in the background so I set up and hide alot of stuff and bring back in to what I want seen. Know a guy that has all that mastered and I no longer feel great about my skills.

You're welcome to it if you want it. In my final set up as it now exists, you do very little manually. You enter our picks on our cards. (We each have our own tab, alphabetically arranged to make finding us easy). Each round has it's own tab. Those Tabs auto populate with the golfers selected from our cards, and duplicates are filtered out. So, at hte end of each round you just enter all the selected scores in one place, enter a "Y" at the top of the round card where I have it highlighted, and all the cards pick up their scores, and the standings tab updates. I have it laid out like 95 posts it in here, so all you have to do is copy and paste each rounds updates in the thread. The primary quality check is that the golfers are spelled correctly on all the cards when you set them up. Any misspelling will pick up the wrong scores. For instance, if you spell Scheffler on a card without the 'C', the vlookop will stop at the name before his, and pick up that golfers score, or throw an error. By my estimate messing around with it, it's take about 30 minutes to put all our picks in, then 15-20 minutes to enter each rounds scores. So, i'm guessing 2 hours max for this portion, plus the extra time 95 spends on segment rankngs and points and such. The other thing to do when entering picks, is the top left cell (A1) on each card has to say ACTIVE or NA. THat way if a person misses a week they basically score 0 that week instead of EVEN par. All ACTIVE cards default to EVEN till scores are posted.

No clearing or deleting. Each week just open the master sheet, do a save as for the tourney week before you do anything else and you're set up. If any newcomers join in, there's 3 extra tabs to just change the names in and they're off and running.
Click to expand...
If needed to do it again, I might ask for it. Might be easier than mine. It’s just inputting the scores (copied and pasted from ESPN) for each player and then copying and pasting their scores into each tab. I’m sure there’s way to have the scores automatically load into each user tab from the master sheet, but I couldn’t figure it out and wanted to let yall know the scores
 
#71
#71
Ultimately it was a lot of work on the front end, but I think it won’t be so bad now. If me doing this was a one off, I prolly could’ve just figured everyone up manually in the amount of time it took me for set up. I’m not great at excel by any means, just enough to get by if you will. But I am a nerd (see Legos and LOTR obsessions), so I enjoyed figuring out how to build it.
 
#72
#72
volfanbill said:
Ultimately it was a lot of work on the front end, but I think it won’t be so bad now. If me doing this was a one off, I prolly could’ve just figured everyone up manually in the amount of time it took me for set up. I’m not great at excel by any means, just enough to get by if you will. But I am a nerd (see Legos and LOTR obsessions), so I enjoyed figuring out how to build it.
Click to expand...

Thank you for doing this!
 
  • Like
Reactions: GordonC and volfanbill
#73
#73
OMG!

I knew my picks were crap, but -10 for an entire weekend. That's pitiful.
 
New posts
You must log in or register to reply here.

VN Store



Back
Top