2K PGA Tour Simulation System [Solo Society Replacement]

[donkey33]

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

I only know Excel basics and this might not be the best way to do it but you could have your scores report to a hidden sheet (0 for even par), sort your scores here and then on your main sheet scoreboard, just use a simple if statement to replace your 0's with E's.

=if(CELL<>0, CELL, "E") for example

Being a basic user, I have always found it easier to report data to a separate sheet (which can be hidden and locked if need be) then use a main sheet as the display sheet to show data how I want it shown.

[Krebstar]

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

I removed 'E' showing for a score of 0 from the 1.1 version. Next update will consist of reworking the score generator to make sure tiers are scoring as they should. My concern right now is that Tier 1 is not performing as well as they should. I've made adjustments, just need to play/sim a several tournaments to see if it has helped.

[mike081989]

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

This is so awesome. I downloaded everything and started playing around with the spreadsheets. One of the things I need to do is make the simulated scores a bit higher, since I'm pretty much in the range of -3 to +2 when I play. But I can tweak that until I get something that works for me.

Another thing I did was to add a tab to the Rankings file to generate a random field. This is good for the tournaments where the top players usually don't even bother playing. It gives me a random list of 156 players and then I can paste them into the event file.

Let me know if that's something that would interest you and I can share the formulas and what I did. The formula is a bit complicated because of the need to avoid duplicates, but I've got it working pretty well right now.

For the WGCs and Majors, I can make my field without the randomizer since the top guys will typically all play in those tournaments. Another thing I did was to add another tab to the Event file for Invitational type tournaments. The FedEx Cup scoring is the same but these events will only have 120 players.

[mike081989]

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

One more thing I forgot to mention. I also added some formulas to help calculate the FedEx Cup points (this helps with the ties so you don't need to do it manually).

I can tell you how I did that step by step:
1. Copy and paste the fedex cup points from Column F into column R over on the right. This will be your "standard" points without ties.
2. In Column S, row 2, add this formula: =COUNTIF($E:$E,E2) and drag it down. This will count how many people are tied at each position.
3. Now back in column F you're going to have a formula to calculate the FedEx Cup points. In Cell F2 put this formula: =IF(S2=1,R2,SUMIF($E:$E,E2,$R:$R)/S2) and drag that down.


There you go! Should be all set. You'll just want to do your "sort" on column R at the end of the tournament instead of column F. What I'm referring to here is the sort function when you're telling excel not to expand the selection. Hopefully that makes sense. Let me know if you have any questions for me on that

[AlanBer]

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

This is great. Thanks for this.

I have a question that may take this to a crazier level...but would it be possible to generate scores hole-by-hole rather than round by round?

I believe there is something out there that does this, something that was connected with Links 2003.

Pardon if this has been posted elsewhere,

https://www.linkscorner.org/phpBB/viewtopic.php?f=14&t=91

[mike081989]

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

I believe there is something out there that does this, something that was connected with Links 2003.

Pardon if this has been posted elsewhere,

https://www.linkscorner.org/phpBB/vi....php?f=14&t=91

Wow this is really impressive. I was trying to dig through the macros to figure out how the hole by hole scores are being calculated but couldn't really figure it out.

[mike081989]

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

Wow this is really impressive. I was trying to dig through the macros to figure out how the hole by hole scores are being calculated but couldn't really figure it out.

I've got this thing figured out down to the bones. I'm making what I guess you'd call a merged version of the two workbooks.

I'm tweaking that really old one you sent the link for and making it out so the hole-by-hole scores will pop out and work with Krebstar's files. I'm pretty damn good with excel - its literally my job - so as I'm going through I'm also trying to find places I can make this easier and remove some of the manual copying and pasting.

Not sure the best way to share and who/if anyone's interested, but reply here and let me know!

(just a disclaimer - by no means am I going to try and pass anything I do here off as my own. Hope it didn't come off that way. I'm just trying to improve upon this awesome thing you created. Let's work together and make this thing even better!)

[Krebstar]

2K21 PGA Tour Simulation System [Solo Society Replacement]

(just a disclaimer - by no means am I going to try and pass anything I do here off as my own. Hope it didn't come off that way. I'm just trying to improve upon this awesome thing you created. Let's work together and make this thing even better!)

Keep going! I’m an Excel novice, and always hoped this thing could get bigger and better through collaboration, and have more automation.

I’m currently playing through the official career just to grab quick XP, but the more I play through it the more I know I’d much rather run my own manually. Players I want, courses I want, etc.

As for the random field generator, I think that would be good to include for those who want to use it. My approach in the last game and for what I figured I’d do going forward is to put all tier 1-2 players in certain events, and for certain events only use 4-5 etc. Basically, manually random in a way, but that’s why I have those event rankings to note what kind of field I should build.

[mikemarc1]

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

I've got this thing figured out down to the bones. I'm making what I guess you'd call a merged version of the two workbooks.

I'm tweaking that really old one you sent the link for and making it out so the hole-by-hole scores will pop out and work with Krebstar's files. I'm pretty damn good with excel - its literally my job - so as I'm going through I'm also trying to find places I can make this easier and remove some of the manual copying and pasting.

Not sure the best way to share and who/if anyone's interested, but reply here and let me know!

(just a disclaimer - by no means am I going to try and pass anything I do here off as my own. Hope it didn't come off that way. I'm just trying to improve upon this awesome thing you created. Let's work together and make this thing even better!)

This is great. Would love a way to simulate hole by hole results (at least for the top 10 or so at the top of the leaderboard)..while also making it realistic by using the tiered system the OP created.

If you can pass along what you have or what you do..that would be great.

Also interested in the way you randomize who plays in a tournament. Also one other question (I’m terrible with excel)...but can a column be added in the events sheet that shows the Current ranking of each player next to their teir?

[mike081989]

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

This is great. Would love a way to simulate hole by hole results (at least for the top 10 or so at the top of the leaderboard)..while also making it realistic by using the tiered system the OP created.

If you can pass along what you have or what you do..that would be great.

Also interested in the way you randomize who plays in a tournament. Also one other question (I’m terrible with excel)...but can a column be added in the events sheet that shows the Current ranking of each player next to their teir?

I'll figure out a way to share it soon. I'm still working on the overall workbook so its not quite ready yet. But I do have hole by hole scoring now and the ability to make it harder/easier. I incorporated OP's tiered scoring system somewhat, but had to re-work it a bit to get the hole-by-hole details. It still might need some tweaking to get the type of scores you're looking for.

Another thing I've added is totals for eagles, birdies, pars, etc. These can all be tracked throughout the season and within each tournament.

In response to your question, I can definitely figure out a way to get the players' current ranking into the leaderboard.

A couple other things I'm working on:
- Adding another tab in case you want to actually see the scores hole by hole as you play. This could be good for round 4 if you're in the final pairing. I'm going to make the text all white on this tab and you can highlight a hole and make it black to see the result for each hole as you go.
- Adding the stats to the event leaderboard
- Re-working the standings/rankings file a bit to incorporate all the above changes. Also going to make it formula based so you don't need to do anything except paste in the tournament results. It will also keep a record of each tournament's leaderboard if you want to go back and look at a prior week's event
- Event/field randomizer: Right now I have two different versions - one fully random, and the other is what I'd call a "strong field event" with 17 of 20 from T1, 25 of 30 from T2, etc. I want to add something where you can input how many guys you want from each tier and it will give you a random list. This is a little tricky to actually put into practice because of the potential duplicate issue, but I think I've got it figured out
- Cleaning up the difficulty modifiers. This way you can mark certain holes as easier/more difficult than others prior to the start of the tournament

THe biggest thing you'll need to manually do for hole-by-hole scoring is go through and input the scorecard from the course (just need the hole # and par). If you're familiar with the course, you can set your hole difficulty prior to the tournament. Another option would be playing a round and trying to figure out which holes you thought were harder or easier than others (such as marking a short or drive-able par 4 as easy to produce more birdies).

One last thing I'll mention. Unfortunately I had to remove the flags. They were causing problems for me, so any files I share will not have the country flags for each player. I'm going to add a column for country but instead of a flag its just going to say USA.

[Blue&Gold]

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

I'll figure out a way to share it soon. I'm still working on the overall workbook so its not quite ready yet. But I do have hole by hole scoring now and the ability to make it harder/easier. I incorporated OP's tiered scoring system somewhat, but had to re-work it a bit to get the hole-by-hole details. It still might need some tweaking to get the type of scores you're looking for.

Another thing I've added is totals for eagles, birdies, pars, etc. These can all be tracked throughout the season and within each tournament.

In response to your question, I can definitely figure out a way to get the players' current ranking into the leaderboard.

A couple other things I'm working on:
- Adding another tab in case you want to actually see the scores hole by hole as you play. This could be good for round 4 if you're in the final pairing. I'm going to make the text all white on this tab and you can highlight a hole and make it black to see the result for each hole as you go.
- Adding the stats to the event leaderboard
- Re-working the standings/rankings file a bit to incorporate all the above changes. Also going to make it formula based so you don't need to do anything except paste in the tournament results. It will also keep a record of each tournament's leaderboard if you want to go back and look at a prior week's event
- Event/field randomizer: Right now I have two different versions - one fully random, and the other is what I'd call a "strong field event" with 17 of 20 from T1, 25 of 30 from T2, etc. I want to add something where you can input how many guys you want from each tier and it will give you a random list. This is a little tricky to actually put into practice because of the potential duplicate issue, but I think I've got it figured out
- Cleaning up the difficulty modifiers. This way you can mark certain holes as easier/more difficult than others prior to the start of the tournament

THe biggest thing you'll need to manually do for hole-by-hole scoring is go through and input the scorecard from the course (just need the hole # and par). If you're familiar with the course, you can set your hole difficulty prior to the tournament. Another option would be playing a round and trying to figure out which holes you thought were harder or easier than others (such as marking a short or drive-able par 4 as easy to produce more birdies).

One last thing I'll mention. Unfortunately I had to remove the flags. They were causing problems for me, so any files I share will not have the country flags for each player. I'm going to add a column for country but instead of a flag its just going to say USA.

Man, this all sounds amazing. Thanks to both for giving time and effort to this. I love the gameplay and presentation of this game, but I am solely an offline career type player and am very disappointed at the lack of options and customization to this years mode.

I'm not great at Excel, but am familiar with it and I do typically make relatively simple spreadsheets for franchise modes in other sports games so if I can help please let me know.

Pumped to try this out!
Cheers!

[mike081989]

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

The Field Generator and Rankings file is ready to share. Hopefully the below link works, let me know if you have trouble accessing the file

https://www.dropbox.com/s/8bhxkog3am9j905/02_Rankings%20and%20Field%20Generator.xlsx?dl=0

Quick instructions for this file are below and the field generator instructions are within the document. Working on wrapping up the Scores Generator and Leaderboard so hopefully can share those later today. Also note this file has one event's worth of data in it. You can delete that if you want.

1. Rankings and Field Generator
a. Initial Setup
i. To start, you will need to add yourself to a few places in this workbook.
1. ‘Rankings HIDDEN’ tab – Cell D301
2. ‘Player Database’ tab – Cell C301
ii. After adding yourself to the database, you can hide the ‘Rankings HIDDEN’ tab. You will not need to view this again. This tab is being used to compile data and can run in the background.

[randogu]

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

Excellent thread gentlemen, I appreciate it.

[mikemarc1]

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

What is the "rankings data" tab on the spreadsheet?

I deleted everything in that sheet and the rankings sheet updated...

What would i have to do with that sheet when im doing a tournament?

thanks

[mikemarc1]

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

And im just fooling around with the field generator and not sure im doing it correctly.

I put 3 in the T1 tab (meaning i only want 3 T1 players, correct?) but every time it spit out Rahm, Justin Thomas and Dustin Johnson (the top 3 players).

It appears whatever number you put it for a Teir, it only takes up to that ranking in the tier. So if i put 12 in T1...it ALWAYS just puts 1-12 in the field.