2K PGA Tour Simulation System [Solo Society Replacement]

[sw88]

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

Hi all,

Amazing work on this! I've been so frustrated with career mode on 2K21 and this looks like a brilliant alternative.

As a bit of an Excel novice I'd be most grateful if a more detailed walkthrough could be provided. I'm getting as far as generating scores but then cannot seem to get a leaderboard working.

In particular I am struggling to understand which files need to be linked as it's not 100% clear, i.e. the Event file surely needs to be linked to Hole by Hole once the field is generated?

Appreciate any help!

[Krebstar]

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

Not sure if anyone is still messing around with anything like this. I'm moving slow but in my second season using my original sheets plus some edits and have decided to add a new wrinkle. Essentially, I'm going to track hot and cold players and let that affect their rounds.

I haven't decided yet by how much, but if a player has several solid finishes in a row or keeps making cuts, I'm going to have their generated scores improve. For example, perhaps their generated scores put them at -12 at the end of a tournament. But since they're on a hot streak, that -12 then goes to a -13 or -14.

Basically, just giving them a manual boost and not letting the randomized generated scores entirely determine their finishes.

How long I'll keep players hot or cold, not sure. I'm currently twelve events into the season, which I feel like is actually a good time to start playing with this. Will be interesting to see how much effect it has.

Really...maybe I'll just do hot streaks? Players who are cold an entire season get demoted a tier, most likely. Eh, we'll see.

[ren6175]

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

Just now finding this thread. Would appreciate and upload of your most current version if possible. I plan to do some editing, but would like to start from all the great work you've already done.

[Krebstar]

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

Just now finding this thread. Would appreciate and upload of your most current version if possible. I plan to do some editing, but would like to start from all the great work you've already done.

I'll package and throw them up today or tomorrow!

[Krebstar]

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

Here's the packaged files of the latest 'system' that I've been using, which includes some more stat tracking, the whole 'streaks' (automated after you decide who is on a hot or cold streak) and just some better automation in general than the original files.


https://www.mediafire.com/file/ajrtq...em_V2.zip/file

[Krebstar]

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

I'm still in the early part of my second season, well, about mid-season, and I'm working on a better way to track 'streaks' so hot and cold streaks are more noticeable. Once I've done that and included it in the packaged files, I can make a new .zip to upload, and if anyone is interested do an updated video on how everything works—the event and leaderboard files are much different than they were when those first videos were recorded.

[Krebstar]

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

I did figure out a decent option for tracking streaks—still getting the formula just right, though. Essentially, in a new sheet, every golfer's event average is recorded, and from there you can control how many of their past events you want to include in their average to see what kind of streak they're on in terms of how well they're playing each event. Last five events, seven, ten, etc.

[mvayda]

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

I did figure out a decent option for tracking streaks—still getting the formula just right, though. Essentially, in a new sheet, every golfer's event average is recorded, and from there you can control how many of their past events you want to include in their average to see what kind of streak they're on in terms of how well they're playing each event. Last five events, seven, ten, etc.

I did something similar but it took quite a bit of work. I basically made a duplicate file of the Rankings file you track fedexcup points in, and I made this my Official World Golf Rankings spreadsheet. Same concept, I fill out the points each player would be getting for the event and paste it into this file. I had to grab 300 players worth of data going back 104 weeks prior to get accurate rankings to start with (even then it wasn't perfect). It was a bit of work setting up but its not hard top maintain now, just an extra step before and after events but it makes the tiers constantly change throughout the season. Right now I am in year 3 and there are some familiar names in the top 20 and some new ones. Jon Rahm has fallen out of the top 20, Bryson all the way down to 53, while Max Homa actually got to world number one after a string of great tournaments. Really adds an extra dynamic to it during the season rather than just changing them up at the end of the season.

[GMR91]

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

I did figure out a decent option for tracking streaks—still getting the formula just right, though. Essentially, in a new sheet, every golfer's event average is recorded, and from there you can control how many of their past events you want to include in their average to see what kind of streak they're on in terms of how well they're playing each event. Last five events, seven, ten, etc.

Wondering if there's any further development of your system been done? Also wondering what would be the best way of calculating scores for the Developmental Tours - like the European or the Korn Ferry for example?

[Krebstar]

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

Wondering if there's any further development of your system been done? Also wondering what would be the best way of calculating scores for the Developmental Tours - like the European or the Korn Ferry for example?

The streak tracking sheet is finished—it can be a bit cumbersome, but really it's just another sheet you copy and paste event results into and for every golfer in your little universe you can see the average of their past X rounds. Much easier than trying to just look manually.

As for developmental tours, really it would just be a matter of creating those events and generating scores based on what 'tier' the golfers are in for those tours. This is something I never really thought of before, though. The idea that when those Tier 4 +5 golfers especially are not playing in a PGA tour event that week, they should still be playing and having progress tracked to see when and how much they should be playing in a PGA Tour event. Hmmm—might be making more sheets in the future haha.

As for the streaks, I can upload new files soon with the full streak tracking sheet included.

Even if I end up getting 2K23, this is what I'll still be doing. I don't want to play through whatever career mode they have with the same courses over and over. I'd rather just create my own little world.

Plus, with the season about to wrap, I might just scrap where I left off with my own and update tiers based on world rankings and essentially start fresh with a 22-23 season—I actually like the sound of that.

[Krebstar]

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

Are the up to date files available for this simulation system?

Hi! Here's V2, which includes the 'streak tracker' sheet.

https://www.mediafire.com/file/9jlaf...em_V2.zip/file


—

Might try and do a 2024 update to this*, updating the tiers, using the 2024 schedule, points awarded, etc. I'm what you could call less than a casual golf viewer, but when I want to play video game golf, I still use this system and I like the idea of updating it for the new 2024 calendar and basically starting my little universe over.

*Currently working on it—updating tiers based on regular season points over the past five seasons, will update the event spreadsheet, as well as points distribution for events, etc.

[Krebstar]

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

Not sure if anyone but me will be interested in it, but I am working on a big update for this little 'system' of mine. Updated 2024 season 'tiers' for the PGA, also including a Korn Ferry system to simulate those results.

The big things are redoing the 'streaks' so they effect individual round scores, as well as adding injuries. So, if you apply an injury to someone, just like a cold streak, it can have an effect on their individual round scores (or you can say they withdraw, or don't play for several events, etc).

So my current plan is something like this: if someone is on fire, they get -1 onto each of their generated round scores, if they're hot, it's -0.5, if they're cold or are playing through an injury it's +1 onto each round.

Things such as the .5 won't show, they'll be in hidden columns, but will be affecting the total score.

Also, just as important, reworked the score generation to hopefully be even more realistic.

—

Little update, been working away at it:

I've added streak randomly generators (or you can manually give them to those who are performing well), as well as random injury generators for injuries that can be played through, and those that can not. Each of those also generate a length of absence (will be easy to add more injuries and variety in the future).

Also, finally made it so with one button press, scores are generated for each tier (no more pasting in the formula, etc).

[Krebstar]

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

I have things fairly updated and ready: PGA database has 250 golfers in it, Korn Ferry has 200, there's a random injury generator with various types of injuries and lengths, and a streak generator.

But now I'm having so much fun adding other things such as a 'scenario generator' that can create random scenarios for golfers randomly such as:

• The Bear: Temporarily Move Up 2 Tiers Before Majors (season long)
• Personal Life Distraction: Temporarily Move Down 1 Tier (season long)
• Career Downturn: Move Down 1 Tier (permanent)

Just little things to add even more life to the little universe.

[Krebstar]

2K PGA Tour Simulation System [Solo Society Replacement]

Here's all 16 of the current 'scenarios' or 'events' I have. At any point in a season you can generate a scenario for one or several golfers randomly from the entire PGA database. Some affect specific tournament scoring, specific round scoring, or even more them up or down a 'tier' which is what determines their average tournament scores.

• Hires New Swing Coach: Move Up 1 Tier (permanent)
• Sudden Skill Growth: Move Up 2 Tiers (permanent)
• Career Downturn: Move Down 1 Tier (permanent)
• Bad Case of The Yips: Move Down 2 Tiers (permanent)
• Mr. Clutch: Temporarily Move Up 1 Tier Before Majors (season long)
• The Bear: Temporarily Move Up 2 Tiers Before Majors (season long)
• Not Clutch: Temporarily Move Down 1 Tier Before Majors (season long)
• Personal Life Distraction: Temporarily Move Down 1 Tier (season long)
• Long-Standing Caddie Split: Move Down 1 Tier (permanent)
• Hires New Caddie: Move Up 1 Tier (permanent)
• Injury Prone: Increase Future Generated Injury Lengths by 50% (permanent)
• Final Boss: -2 strokes added to every final round (next six events)
• Early Bird: -2 strokes added to every first round (season long)
• Links Player: -1 strokes added to every round of The Open (permanent)
• The Master: -1 strokes added to every round of The Masters (permanent)
• Fifth Major: -1 strokes added to every round of The PLAYERS (permanent)

—

Injuries are similar—you can choose to generate painful injuries (that can be played through but cost strokes) or severe injuries which mean someone must sit out a certain number of weeks. Here are just a few examples of painful and severe injuries:

• 2 Weeks: Rotator Cuff Strain (Minor)
• 4 Weeks: Back Strain (Mild)
• 3 Weeks: Knee Ligament Strain (Mild)
—
• 12 Weeks: Rotator Cuff Tear (Severe)
• 16 Weeks: Herniated Disc (Severe)
• 14 Weeks: Meniscus Tear (Severe)

Really trying to build out more of an experience with twists and turns, storylines, etc.

[Krebstar]

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

I was close to 'releasing' this, but I decided to entirely redo the PGA default rankings. I downloaded the Golf Data rankings at the start of the last six months, then averaged them, and will now build the rankings based on that. I'd used a few other metrics previously, but I think this will be the best—up to date, but also not too much weight on the last several tournaments/months.

Also going to do more testing and sample sizes on the score generation/tiers to make those as close to realistic as possible.

Obviously, if anyone else wants to use this they can move players around, change score generation percentages, etc. but I figured I'd try and have it in a good spot to start.