2K PGA Tour Simulation System [Solo Society Replacement]

[Krebstar]

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

I was just not going to have a match play event haha. That was my solution.

[mvayda]

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

When I download the updated Hole by Hole file and re link it to the other two files, anything referencing the Round by Round Scores tab breaks, is there one big updated zip file with all three files linked?

[mvayda]

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

Double posting here but I noticed something when trying to set up the first tournament, the field generator never actually changes, the paste values column stays the same while player column changes. That carries over to the player database having yes next to the same players no matter what. I fixed that by expending the vlookup to column G on Field Generator and reading from the third column instead of second to account for the expansion. This fixes the Player Database issue but when I filter for the Yes's it runs the randomizer again. Since the Hole by Hole workbook reads from who has Yes's in the Field Generator tab, and the Event leaderboard reads from the Hole by Hole workbook, I can't paste the field for a tournament without that field changing on me as I am pasting it...is anyone else experiencing this? Been trying to mess around with it but no luck

[mike081989]

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

Double posting here but I noticed something when trying to set up the first tournament, the field generator never actually changes, the paste values column stays the same while player column changes. That carries over to the player database having yes next to the same players no matter what. I fixed that by expending the vlookup to column G on Field Generator and reading from the third column instead of second to account for the expansion. This fixes the Player Database issue but when I filter for the Yes's it runs the randomizer again. Since the Hole by Hole workbook reads from who has Yes's in the Field Generator tab, and the Event leaderboard reads from the Hole by Hole workbook, I can't paste the field for a tournament without that field changing on me as I am pasting it...is anyone else experiencing this? Been trying to mess around with it but no luck

Yes you need to manually paste the values from one column to the other. So you generate them, then copy the names over to the next column to get your field to update.

Just saw your previous question on the broken links. I can re-zip everything later. Busy with real work today

But I'll re-post it all in a bit. I never got around to setting up the match play file but i think i can do it.

[mvayda]

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

Yes you need to manually paste the values from one column to the other. So you generate them, then copy the names over to the next column to get your field to update.

Just saw your previous question on the broken links. I can re-zip everything later. Busy with real work today

But I'll re-post it all in a bit. I never got around to setting up the match play file but i think i can do it.

I actually was able to do a simple find and replace for the broken references. I also was able to fix the field generator. If I were to want zero tier 1 players in a tournament it still would default to one. I replaced the formula in E19 to =IF(Z2>0,Z2,"") so instead of it returning a 0 it would return nothing, forcing Z19 to return out instead of In, thus removing that default one T1 player from the list. I am still running into the issue where it returns one less T5 player than I have it set to, but that isn't a huge issue I just put it one higher than desired.

I am slightly confused about where my name goes on the event leaderboard. I notice there are only 155 spots on that but usually the field is 156. Am I not included on that leaderboard? I have a few other tiny questions but I am sure I'll figure them out with some trial and error.

Overall this is some excellent work thank you for taking the time to put this together.

[ncp10]

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

Does the new version allow you to create a private society and play online against live rivals, as is done in TGC2019? And also, can you do Private Matches online w/ other players?

Thanks

[mike081989]

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

I actually was able to do a simple find and replace for the broken references. I also was able to fix the field generator. If I were to want zero tier 1 players in a tournament it still would default to one. I replaced the formula in E19 to =IF(Z2>0,Z2,"") so instead of it returning a 0 it would return nothing, forcing Z19 to return out instead of In, thus removing that default one T1 player from the list. I am still running into the issue where it returns one less T5 player than I have it set to, but that isn't a huge issue I just put it one higher than desired.

I am slightly confused about where my name goes on the event leaderboard. I notice there are only 155 spots on that but usually the field is 156. Am I not included on that leaderboard? I have a few other tiny questions but I am sure I'll figure them out with some trial and error.

Overall this is some excellent work thank you for taking the time to put this together.

Yea I accidentally left it at 155 spots. I've attached the latest versions of everything. You'll just need to re-link the workbooks and you should be good. Your name goes on the leaderboard just like everyone else's. After you generate your field, you go to the player databases, sort on YES, and paste the values into the leaderboard. It doesn't matter what order you paste the names into the event leaderboard. You really shouldn't need to change anything in the event leaderboard after you paste the field in - the rest is all getting pulled in from formulas.

I have been really busy with work this week so haven't made much progress on the match play file.

[mike081989]

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

Does the new version allow you to create a private society and play online against live rivals, as is done in TGC2019? And also, can you do Private Matches online w/ other players?

Thanks

No it does not. That's why we've built this whole thing.

I do all my tournaments via local quick play, but I'm sure you could do the same with a friend and run a 2 person season using these files.

[mike081989]

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

One last thing I wanted to note. When you delete the CUT players, whoever is in last place and made the cut is going to have #REF for their "POS" in column A. Just copy the formula from the cell above and you'll be good to go.

[AlanBer]

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

One last thing I wanted to note. When you delete the CUT players, whoever is in last place and made the cut is going to have #REF for their "POS" in column A. Just copy the formula from the cell above and you'll be good to go.

Better yet, use conditional formatting to hide errors in cells.

[mike081989]

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

Better yet, use conditional formatting to hide errors in cells.

That'll work too. It just errors out because it looks at the next row of data to see if they're the same number so it knows to either put "2" or "T2". So when you delete that row, it creates a #REF error

[mike081989]

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

So I really dove in and started making a match play workbook. This thing is a beasttttt and taking a lot of work for just one tournament on the schedule. If I end up finishing and getting it working I can guarantee you I'm going to have more than one match play tournament in my season haha

At this point I have it set up and working for the entire round robin stage. Just getting the bracket squared away now. There might be a better way to do this but the way I'm going about it seems to be working so far. And the biggest roadblock I'm running into is matches that end in ties. I basically need to build out a whole new round just for the tiebreaker, even its just going to use a couple of holes.

Which brings me to a question - does anyone know what hole they start on for the tiebreakers in the Round of 16 and later? I know round robin sudden death starts on hole 1, so was assuming it would be the same for the bracket stage.

[mikemarc1]

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

Can you share instructions on how to use v4 of the hole by hole sheet? The live leaderboard and what not?

My hole by hole tab no longer shows hole by hole scores, just for round 4. I simmed rounds 1 and 2..how does the tee times tab work? it is blank after my 2nd round.

will this not work if i'm not playing as myself in a tournament?

thanks again for all your work.

[mike081989]

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

Can you share instructions on how to use v4 of the hole by hole sheet? The live leaderboard and what not?

My hole by hole tab no longer shows hole by hole scores, just for round 4. I simmed rounds 1 and 2..how does the tee times tab work? it is blank after my 2nd round.

will this not work if i'm not playing as myself in a tournament?

thanks again for all your work.

I posted updated instructions a few pages back on page 12 for using the live leaderboard and and the tee times tab but I'll repost again here. I also just noticed one of the formulas in the live leaderboard is based on my name so that's not going to work for anyone! I think this version should have that fixed.

Your hole by hole tab probably just needs the font color to change to get that to show up. Its all in white text on a white background.

And your last question - I'm not sure if this is going to work if you're not playing as yourself. All of the formulas and workbooks are kind of set up with that in mind. It would require a bit of an overhaul to be able to switch golfers every round and all the formulas are built based on you controlling golfer #300 on the player database list. You might be able to get away with changing that name to whoever you want to be, but I haven't tested any of that so I can't really be sure.

[mikemarc1]

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

I posted updated instructions a few pages back on page 12 for using the live leaderboard and and the tee times tab but I'll repost again here. I also just noticed one of the formulas in the live leaderboard is based on my name so that's not going to work for anyone! I think this version should have that fixed.

Your hole by hole tab probably just needs the font color to change to get that to show up. Its all in white text on a white background.

And your last question - I'm not sure if this is going to work if you're not playing as yourself. All of the formulas and workbooks are kind of set up with that in mind. It would require a bit of an overhaul to be able to switch golfers every round and all the formulas are built based on you controlling golfer #300 on the player database list. You might be able to get away with changing that name to whoever you want to be, but I haven't tested any of that so I can't really be sure.

So I ran thru a quick tournament as myself and I’m still having live leaderboard issues.

I followed your directions and on the live leaderboard round 3 tab, I’m putting my scores in row 304. The cells are changing colors in 304 based on my score, my score is updating above on the live leaderboard but no other scores are updating.