2025 Endzone's Best Ball Challenge - Charles Schwab Challenge

#76
#76
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...
Good job. Seems you got everyone's scores right but mine. lol.
 
#78
#78
volfanbill said:
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
Click to expand...
Much simpler than you think, and you'd prob say I knew that. That's actually how I set this one up. Master sheet for the scores, then the tabs pick those up on a vlookup and copy function. As long as you sort the golfers alphabetically when you get done pasting scores, it works great.
 
  • Like
Reactions: volfanbill
#79
#79
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...
Vlookup is your friend.
 
  • Like
Reactions: GVF
#80
#80
82_VOL_83 said:
Vlookup is your friend.
Click to expand...
That and Sort. I've got a hidden tab That everyone's picks dumps into. Then I combine a Sort & Unique function to alphabetize the golfers and filter out the multiple picks so each name only shows once. Then I copy those over to the master card for the round. And our cards pick up our scores from that list.

In a perfect world it would always slot WTF next to last.
 
  • Like
Reactions: 82_VOL_83
#82
#82
GVF said:
That and Sort. I've got a hidden tab That everyone's picks dumps into. Then I combine a Sort & Unique function to alphabetize the golfers and filter out the multiple picks so each name only shows once. Then I copy those over to the master card for the round. And our cards pick up our scores from that list.

In a perfect world it would always slot WTF next to last.
Click to expand...

Can you do some Excel magic and find a way for it to dump some of your picks and make better ones?
 
  • Like
Reactions: 82_VOL_83
#83
#83
WestTennesseeFox said:
Can you do some Excel magic and find a way for it to dump some of your picks and make better ones?
Click to expand...
After this last one, it'd throw out an error. I was on the rise and doing good. Don't know how my entire team ranked as high as they were in each group sucked so bad.

You picked up a few buffalo nickels though on that team.
 
#84
#84
82_VOL_83 said:
Vlookup is your friend.
Click to expand...
I can link to the current leaderboard for the week back into excel, that should refresh each week to the current event.

My problem is not figuring out how to find & import a score by round/hole table.
 
#85
#85
GVF said:
After this last one, it'd throw out an error. I was on the rise and doing good. Don't know how my entire team ranked as high as they were in each group sucked so bad.

You picked up a few buffalo nickels though on that team.
Click to expand...

I got lucky. Had two guys barely sneak through the cut. I might have been the only one to have 4 make it to the weekend.
 
New posts
You must log in or register to reply here.

VN Store



Back
Top