2K PGA Tour Simulation System [Solo Society Replacement]

[mikemarc1]

First question:

What is the "ranking hidden" tab?

I see a RANKING tab and a RANKING DATA tab.

[mike081989]

Quote: Originally Posted by mikemarc1

First question: What is the "ranking hidden" tab? I see a RANKING tab and a RANKING DATA tab.

It might be hidden in your workbook (as it should be after you do what you need to do in there). On one of the tabs at the bottom, right click, then unhide it. Then after you do those first couple steps you can re-hide it, since you won't need this again.

[mikemarc1]

Quote: Originally Posted by mike081989

It might be hidden in your workbook (as it should be after you do what you need to do in there). On one of the tabs at the bottom, right click, then unhide it. Then after you do those first couple steps you can re-hide it, since you won't need this again.

So when i click "unhide" im still not seeing it. only hidden tab i see is the OWGR tab..which i hid earlier cause i don't think thats really needed, correct?

[mikemarc1]

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.

[mike081989]

Quote: Originally Posted by mikemarc1

So when i click "unhide" im still not seeing it. only hidden tab i see is the OWGR tab..which i hid earlier cause i don't think thats really needed, correct?

Ohh I see what you mean. My bad, I forgot to copy that one back over. Let me re-post. Not having that is going to cause some problems with your formulas.

Here, use this version attached.

We'll get it working eventually!

[mike081989]

Quote: Originally Posted by mikemarc1

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]

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]

Quote: Originally Posted by mike081989

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.