2K PGA Tour Simulation System [Solo Society Replacement]

[mike081989]

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

Sorry, must have forgotten to delete out my data. That is where you're going to paste in the individual tournament stats. I'm working on a full set of instructions, so I'll share that soon.

Responding to your other question on the generator - you are completely right. That's soemthing I didn't even notice it was doing. Its a product of the Rank.Eq function I have in there. Let me see if I can re-work it a bit...

What its doing is ranking the values it spits out - so if only four values come out, its going to rank them 1-4 and give that as your result. Ugh just when I thought I had it sorted out..

[mikemarc1]

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

Yah it was spitting out the same 3 but just in a different Order each time.

Appreciate ya!!

[mike081989]

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

I see that now.

Let's see if I can fix it!

I'm sharing my Event Leaderboard and Score Generator file at the links below. Instructions are also linked below. I'm still working on the instructions by the score generator and the event leaderboard are pretty much good to go.

There's now also a column on the event leaderboard which will give the current FedEx Cup ranking of each player (green for inside the top 125, red for outside). Hopefully sharing them on DropBox won't break my formulas linking the two workbooks together. Let me know if you have any issues or questions.

Instructions (ignore the field generator for now, working on a fix): https://www.dropbox.com/s/ybdhfx8g0f...ions.docx?dl=0

Hole by Hole Scores: https://www.dropbox.com/s/tk0cm3cdj6...ores.xlsx?dl=0

Event Leaderboard:

https://www.dropbox.com/s/11orkmslb95lid3/01_Event.xlsx?dl=0

[mike081989]

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

Yah it was spitting out the same 3 but just in a different Order each time.

Appreciate ya!!

Here's my thought on this. I can make this a whole lot easier if I do this:
Instead of randomly generating a set number from each tier, i can randomly generate the ORDER in which they appear -

I'll explain what I mean by that.
Say you want 10 from T1, 20 from T2, 30 from T3.

I can generate a list so all 20 will appear from Tier 1, but then you can go in and mark off the first 10 that pop up as your golfers. You can do something like adding an X next to the first 10 golfers and they'll pop up as in your field.

Does that work? I can keep trying to get this to work, but I think it requires array functions, which are a whole different beast and they're a pain to actually use.

Let me know your thoughts!

[kmax40]

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

Great Work!! I think I fixed your Field Generator problem but I can't upload the file because I haven't posted enough so I'll just try to talk you through it briefly.

In the "Player Database" tab I inserted a column between RANK and TIER and put the formula RAND() to create a random number between 0 and 1. Then I ranked those random numbers in order to get a random rank for each player. I used the below formula in the RANK column to do this based on tiers.

COUNTIFS($C$2:$C$301,C2,$B$2:$B$301,">"&B2)+IF(C2= "T1",'Field Generator'!$K$2,IF(C2="T2",'Field Generator'!$K$3,IF(C2="T3",'Field Generator'!$K$4,IF(C2="T4",'Field Generator'!$K$5,'Field Generator'!$K$6))))

Now it should pull random players from each tier into the "Field Generator" tab correctly. But you may need to update the VLOOKUPS in E and F of the "Field Generator" tab to pull the right info over.

Hopefully this makes sense!

[kmax40]

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

I think I figured out how to get it to post the file. Hope this works now!

[mike081989]

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

I just figured out how to make the field generator work as intended. Re-uploading!

This will work like the other version was supposed to. SHould only need to edit the number of golfers you want from each tier in the yellow section, and then follow the rest of the instructions on that tab to get your field.

[mikemarc1]

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

Amazing work to all 3 of you!

Thanks, looks like the field generator is working!


The other two workbooks look very confusing but im hoping its not..haha

[mike081989]

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

Haha there's a whole lot going on in those for sure. Once you do it once or twice you'll have it figured out.

Let me know if any questions come up. Hopefully I put good instructions!

Edit: Also, you can put zero for Tier 1 and it should still work. I can do the same for Tier 2 if people want that, but you usually have a couple of those guys show up to even the worst of tournaments, so figured I'd leave it as is. I think if you put zero for T1 and T2 it might cause problems currently.

[mike081989]

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

Amazing work to all 3 of you!

Thanks, looks like the field generator is working!


The other two workbooks look very confusing but im hoping its not..haha

If I get some time over the next few days I'll try and record a video and post it to youtube so you can see how I do it. That's probably a bit easier than reading through the instructions

[mikemarc1]

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

First question:

What is the "ranking hidden" tab?

I see a RANKING tab and a RANKING DATA tab.

[mike081989]

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

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]

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

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]

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

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]

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

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!