2K PGA Tour Simulation System [Solo Society Replacement]

[mike081989]

Re: 2K21 PGA Tour Simulation System [Solo Society Replacement]

so im seeing it on the original one you shared before you updated the field generator...

but im not seeing it on the one with the working field generator.

Yea when I got the field generator working I didn't want to mess up the current tournament I had going, so I copied it all to a new workbook and forgot that tab since it was hidden.

You're also going to need to re-link the vlookup for the field between the Rankings file and the Hole by Hole file's (Roster) tab. Formula for the first player in cell I3 should be something like this:

=IF(VLOOKUP(D3,'[02_Rankings and Field Generator V3.xlsx]Player Database'!$C:$D,2,FALSE)="YES",1,0)

[mike081989]

Re: 2K21 PGA Tour Simulation System [Solo Society Replacement]

Unfortunately Country Club of Jackson is borderline unplayable. Some of the pin locations are soooooo bad.

What are you guys planning to do about courses not in the game or a situation where the course is so bad its not even worth playing?

I guess there's two options - either skip the event and sim it as a week off, or substitute in another course.

[mikemarc1]

Re: 2K21 PGA Tour Simulation System [Solo Society Replacement]

Yea when I got the field generator working I didn't want to mess up the current tournament I had going, so I copied it all to a new workbook and forgot that tab since it was hidden.

You're also going to need to re-link the vlookup for the field between the Rankings file and the Hole by Hole file's (Roster) tab. Formula for the first player in cell I3 should be something like this:

=IF(VLOOKUP(D3,'[02_Rankings and Field Generator V3.xlsx]Player Database'!$C:$D,2,FALSE)="YES",1,0)

Sorry, more questions:

So when i copy the 156 players from the generator to the pre-cut leaderboard, am i just copying their names? or do i have to copy their rankings, country, teir, etc.

[mikemarc1]

Re: 2K21 PGA Tour Simulation System [Solo Society Replacement]

is it also possible to share your event workbook once again without any of your season data in it?

or is it just a matter of highlighting all your data and deleting it? (dont wanna delete the formulas is all)...thanks.

[mike081989]

Re: 2K21 PGA Tour Simulation System [Solo Society Replacement]

Sorry, more questions:

So when i copy the 156 players from the generator to the pre-cut leaderboard, am i just copying their names? or do i have to copy their rankings, country, teir, etc.

All good man ask away!

You should only have to copy the names. The country is a vlookup to the world golf ranking tab, so that should fill automatically. And the tiers are only used for generating the field so you don't need to copy that either.

The tiers are used to calc the scores, but they're assigned by player name so you don't need the T1 there either.

I'm still tweaking some stuff so I wouldn't say this is final quite yet. Also caught a formula error in grabbing the total number of eagles/birdies/pars for Round 4 only.

Your eagles formula should be the below formula. Then you can copy and paste formulas across to birdies, pars, bogey, doubles, triples:

=IF($V15=1,VLOOKUP($D2,'[Hole by Hole scores.xlsx]Round by Round Scores'!$B:$HE,'[Hole by Hole scores.xlsx]Round by Round Scores'!GL$5,FALSE),IF($V15=2,VLOOKUP($D2,'[Hole by Hole scores.xlsx]Round by Round Scores'!$B:$HE,'[Hole by Hole scores.xlsx]Round by Round Scores'!GS$5,FALSE),IF($V15=3,VLOOKUP($D2,'[Hole by Hole scores.xlsx]Round by Round Scores'!$B:$HE,'[Hole by Hole scores.xlsx]Round by Round Scores'!GZ$5,FALSE),IF($V15=4,VLOOKUP($D2,'[Hole by Hole scores.xlsx]Round by Round Scores'!$B:$HE,'[Hole by Hole scores_WIP.xlsx]Round by Round Scores'!GE$5,FALSE)))))

[mike081989]

Re: 2K21 PGA Tour Simulation System [Solo Society Replacement]

is it also possible to share your event workbook once again without any of your season data in it?

or is it just a matter of highlighting all your data and deleting it? (dont wanna delete the formulas is all)...thanks.

The event workbook or the rankings workbook? Let me do this - I'm going to zip all the files together with the couple of changes I made tonight and send clean versions in the morning.

[mikemarc1]

Re: 2K21 PGA Tour Simulation System [Solo Society Replacement]

The event workbook or the rankings workbook? Let me do this - I'm going to zip all the files together with the couple of changes I made tonight and send clean versions in the morning.

thanks buddy.

im just fooling around with this, quickly, generated a 156 player feild, posted my 156 names into the pre-cut leaderboard but some of the scores that were there already are still there, some of them say N/A...and it doesn't seem like the rankings pasted with the players names. the rankings stayed the same with the players you had in there. i just think it will make a bit more sense to me with clean versions of everything..

Yes, absolutely no rush, do what you gotta do. i go back to work tomorrow but ill be sure to keep checking back.

[mike081989]

Re: 2K21 PGA Tour Simulation System [Solo Society Replacement]

thanks buddy.

im just fooling around with this, quickly, generated a 156 player feild, posted my 156 names into the pre-cut leaderboard but some of the scores that were there already are still there, some of them say N/A...and it doesn't seem like the rankings pasted with the players names. the rankings stayed the same with the players you had in there. i just think it will make a bit more sense to me with clean versions of everything..

Yes, absolutely no rush, do what you gotta do. i go back to work tomorrow but ill be sure to keep checking back.

Ok yea sounds like the workbooks got unlinked which I thought might happen. I can either send instructions on how to link them or have to put all the tabs into one workbook. I’ll figure out what’s easier and reupload everything. Luckily I have two events down so I’ve been tweaking stuff as I go.

Everything’s working in my version now so it’s just a matter of cleaning out the data and uploading it in a way that all the formulas between different workbooks will work as intended.

[mike081989]

Re: 2K21 PGA Tour Simulation System [Solo Society Replacement]

I'll have new versions posted today with updated instructions, including how to link your workbooks together.

I've made some updates to what I sent out earlier so the newest version should be used. Right now I'm working on writing a macro to make getting the golfer's scores easier.

[Krebstar]

Re: 2K21 PGA Tour Simulation System [Solo Society Replacement]

Unfortunately Country Club of Jackson is borderline unplayable. Some of the pin locations are soooooo bad.

What are you guys planning to do about courses not in the game or a situation where the course is so bad its not even worth playing?

I guess there's two options - either skip the event and sim it as a week off, or substitute in another course.

There are several real courses that I'll be substituting in similar courses for, as as close to similar as possible, or even reimagining where else that event might move to that already has a real course in the game someone has published.

My approach is also to not play every event, especially those I wouldn't qualify for, as my "golfer" is still slowly climbing the ranks.

[mike081989]

Re: 2K21 PGA Tour Simulation System [Solo Society Replacement]

The updated files and updated instructions are attached here. Let me know if you see any issues or have questions. HOpefully this helps!

[mike081989]

Re: 2K21 PGA Tour Simulation System [Solo Society Replacement]

I may have forgotten to hit save before I posted the instructions, reattaching here.

[mikemarc1]

Re: 2K21 PGA Tour Simulation System [Solo Society Replacement]

Hey,

when i attempt your step 1 in the instructions and hit check status both change to OK and not "Source is open"

[mikemarc1]

Re: 2K21 PGA Tour Simulation System [Solo Society Replacement]

Another quick thing i noticed...the precut leaderboard only has 155 slots for players. when i paste 156 players the bottom player has no formulas in his row...is there an easy way to add?

[mikemarc1]

Re: 2K21 PGA Tour Simulation System [Solo Society Replacement]

The round by round tab looks good but the hole by hole sheet when i generate scores remains blank.

I'm also getting a leaderboard filled with #REF when i update the rounds in it.