2K PGA Tour Simulation System [Solo Society Replacement]

[mike081989]

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/11orkmslb9...vent.xlsx?dl=0

[mike081989]

Quote: Originally Posted by mikemarc1

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]

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]

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

[mike081989]

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]

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]

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]

Quote: Originally Posted by mikemarc1

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