2K PGA Tour Simulation System [Solo Society Replacement]

[mike081989]

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

Updated version of the Hole by Hole file and instructions are attached.

Just make sure you re-link the workbooks to get everything flowing through correctly.

Also, you don't need to change the font color if you're using the live leaderboard. It will fill in the holes automatically in black text.

[mvayda]

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

So I've been following this for some time, thank you all for the work you have put into it. I will be attempting to use this considering how poorly the in game career mode is. A few questions though:

Do we have published courses that apply to each of these tournaments? I assume the answer is no but I know there are a good amount out. If not, what have people been using? Digging through courses takes a while to get one that matches the tourney. Also...this might be too much work, or it might already be a thing. But do tiers update ever? I know the initial setup was by OWGR but over the course of a season those change, somewhat drastically if players win multiple tournaments. Or are these tiers pretty much set in stone?

[mike081989]

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

Yea I'm really happy i stumbled upon what Krebstar created and was able to kind of run with it - two heads are better than one as they say, so our combined spreadsheets here are really working well.

Do we have published courses that apply to each of these tournaments? I assume the answer is no but I know there are a good amount out. If not, what have people been using? Digging through courses takes a while to get one that matches the tourney.

Not quite but there's enough to make it work for sure. But for the most part you can just skip the events where you can't find a good course for it unless its a big name event. Real PGA pros don't even come clsoe to playing every week (unless you're Sungjae Im lol), so I've only played in 3 or 4 out of the first 10 events so far.

I just got to the Tournament of Champions at Kapalua and noticed the version on the game is only a par 70. The real course is a par 73 so I'm not using it. I switched over to Wolf Creek for this tournament.

Also...this might be too much work, or it might already be a thing. But do tiers update ever? I know the initial setup was by OWGR but over the course of a season those change, somewhat drastically if players win multiple tournaments. Or are these tiers pretty much set in stone?

So its really kind of up to you what you want to do. It's not going to do anything automatically.

Let me take a step back and try to give an explanation of how the scoring works and how that relates to the tiers (sorry for the long winded answer but I think its important)

TLDR: I'd say read the whole thing but TLDR is that everyone in each tier has the same stats/scoring potential right now but they can be easily edited directly on the "pga" tab in the Hole by Hole workbook.

I started off with Krebstar's tiered breakdown - and yes I did reshuffle them a bit to be the exact Official World Golf Rankings, but that was just to make it easier for me to set up, and for the most part they're pretty similar. So I looked at his tiers and said "ok there's 20 golfers in A, 30 in B, etc etc."

I then went and got a raw data dump, by player, of every hole of every tournament in 2019 and 2020. Using Tier 2 as an example, I took golfers #21-50 in the analytical rankings - pure numbers and not associated by name in any way, and averaged them and applied those stats to all of Tier 2.

Now I could potentially get down to the level of each individual golfer having their own unique statistics. It's definitely possible and definitely something I want to do over the next few days. In the interest of time and getting this thing up and running, taking an average was the easiest and quickest way to do it because the mismatches between the OWGR and the raw data were causing problems for me. Even something as simple as showing up in the rankings as Sungjae Im and the in the stats as Sung Jae Im would cause the formula to error out.

So the above paragraph is the extent of using the tiers.

Now on to how scoring is determined and can be edited:

My scoring formula is very similar to Krebstar's - with the obvious difference being that mine is calculating an individual hole score based on probability vs a randomly generated number and Krebstar was calculating a full 18 hole score based on probability.

If you go to the 'pga' tab you'll see a whole bunch of numbers and you'll also notice there's a section for Par 3, 4, and 5. If you look at Tier 1 golfers for par 3's, this is telling you:
1) 100% of the time, the golfer gets a triple bogey or better
2) 99.8% of the time, the golfer gets a double bogey or better
3) 99.2% of the time, the golfer gets a bogey or better
4) 88.5% of the time, the golfer gets a par or better
5) 16.1% of the time, the golfer gets a birdie or better; and
6) .03% of the time, the golfer gets a eagle (aka hole in one)

The same applies to the other columns for Par 4 and Par 5.

If you want to make a golfer better, you can go to any of these cells and increase the number. Basically you need to multiply the percentage that you want x 100 and put it in that cell. So my examples above - 16.1% means you would type 161 into that cell.

Well that response turned out a whole lot longer than I had planned but there you go haha

[mikemarc1]

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

2 more questions, comments:

1- Is it possible to merge the post cut and precut leaderboards into one final sheet that shows the final leaderboard after round 4 from 1-156?

2- This May be asking a lot but curious..if a Tier 3,4,5 golfer leads after Rd. 1, is it possible their odds can improve shooting in rounds 2,3 and 4? (Kinda as if they’re in tier 1 or 2) The few rounds I’ve simulated just feels like the rounds are so all over the place. Feel like it a golfer has a great opening round regardless of tier they should continue the good play.

[itsmb8]

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

2 more questions, comments:

1- Is it possible to merge the post cut and precut leaderboards into one final sheet that shows the final leaderboard after round 4 from 1-156?

2- This May be asking a lot but curious..if a Tier 3,4,5 golfer leads after Rd. 1, is it possible their odds can improve shooting in rounds 2,3 and 4? (Kinda as if they’re in tier 1 or 2) The few rounds I’ve simulated just feels like the rounds are so all over the place. Feel like it a golfer has a great opening round regardless of tier they should continue the good play.

AFAIK the scoring generator by tier isn't tied to players and is generated on its own, so you could just generate the tier 1 scores and assign those scores to the X number of players at the top of the leaderboard.

[mike081989]

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

2 more questions, comments:

1- Is it possible to merge the post cut and precut leaderboards into one final sheet that shows the final leaderboard after round 4 from 1-156?

2- This May be asking a lot but curious..if a Tier 3,4,5 golfer leads after Rd. 1, is it possible their odds can improve shooting in rounds 2,3 and 4? (Kinda as if they’re in tier 1 or 2) The few rounds I’ve simulated just feels like the rounds are so all over the place. Feel like it a golfer has a great opening round regardless of tier they should continue the good play.

1 - because of what I said earlier about the someone getting cut being ahead of someone who didn't get cut, this isn't quite going to work with the formulas. If you do want to do that, you could copy and paste values into another tab. Just make sure its in the right order before you copy/paste and you should be good.

2 - unfortunately that's not really possible. but like the other guy said, you could start mismatching the scores (as in give DJ's score to a tier 5 golfer). Its some added manual work but its an option. It really comes down to the RAND function in excel. Its tough to work with since it recalcs every time you do anything in the workbook, which is why i've written macros to paste values of the scores to lock them in place.

[Krebstar]

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

I plan on updating tiers manually based on players performance. So, if I notice players playing better than the rest of their tier, or worse (depending on who), I'll move them or swap them.

As for courses, don't bother looking for courses within the game—use TGC Tours course listing to find quality, realistic courses, or good recreations of real courses. The event listing I posted is not meant to be a "these are the courses you should use"—it's just the actual schedule. I'm still in the process of finding courses to use for those which are not in the game.

[mvayda]

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

Ahh I see, yeah I was browsing TGCTours for courses and I found a good one I could use for the Masters but when searching for it in 2K it didn't exist (no not Firethorn I know thats gone), I will have to check some others to make sure all those courses are there. Would be cool if the top creators decided to recreate a lot of the courses on tour.

As for the rankings I now see how this works, I might dig into those stats myself and have those keep updating as the season goes on, kinda like how the OWGR rankings update with results from 2 years prior YTD. But before I dig in just for my own sanity I need to assign courses to the tournaments.

Thank you!

[mvayda]

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

Ahh I see, yeah I was browsing TGCTours for courses and I found a good one I could use for the Masters but when searching for it in 2K it didn't exist (no not Firethorn I know thats gone), I will have to check some others to make sure all those courses are there. Would be cool if the top creators decided to recreate a lot of the courses on tour.

As for the rankings I now see how this works, I might dig into those stats myself and have those keep updating as the season goes on, kinda like how the OWGR rankings update with results from 2 years prior YTD. But before I dig in just for my own sanity I need to assign courses to the tournaments.

Thank you!

This was directed at Mike I might not be new to browsing OS but I am new to actually posting to it lol

[Krebstar]

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

Ahh I see, yeah I was browsing TGCTours for courses and I found a good one I could use for the Masters but when searching for it in 2K it didn't exist (no not Firethorn I know thats gone), I will have to check some others to make sure all those courses are there. Would be cool if the top creators decided to recreate a lot of the courses on tour.

To find Firethorne you need to either be a friend of someone who 'liked' it, or find a society who had an event at it.

On PS4 if you go to the Barstool Golf Society, then to their schedule, you'll see an event titled Boss Man Open. Go to that, and then view course details. It'll be Firethorne, and you can then add it to your favorites.

[voodoo_magic]

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

Maybe the best part about this system, if you have a horrible round you can just go "that was my practice round".

[mvayda]

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

How are we supposed to run the Match Play event?

[mike081989]

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

How are we supposed to run the Match Play event?

Great question I was actually thinking about that myself. How comfortable are you with excel?

I think a few of the pieces are already in place, but you're going to need to do a bit of work to calculate the scores.

I'm thinking the best way to do it is to mark the top 64 in the season standings as "in" for the event, and generate their scores. I'd then consider dumping those scores into a blank workbook and using them to calculate the matches. Not the best, I know, but i think its the easiest way to do it without completely building something from scratch for one tournament on the schedule

[mike081989]

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

I can't find out how hard it is if I don't try.

Let me see if I can put something together. Once I get going I might find that its going to be pretty easy.

[mvayda]

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

Great question I was actually thinking about that myself. How comfortable are you with excel?

I think a few of the pieces are already in place, but you're going to need to do a bit of work to calculate the scores.

I'm thinking the best way to do it is to mark the top 64 in the season standings as "in" for the event, and generate their scores. I'd then consider dumping those scores into a blank workbook and using them to calculate the matches. Not the best, I know, but i think its the easiest way to do it without completely building something from scratch for one tournament on the schedule

I'm actually very comfortable with excel that's most of my job responsibilities...I'm not as comfy as you clearly are considering what you've been able to do but I am decent. Long ways away until I get to the match play event anyways, I am still cruising through TGC to find courses to assign to each tournament.