2K PGA Tour Simulation System [Solo Society Replacement]

[mike081989]

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

Hey,

when i attempt your step 1 in the instructions and hit check status both change to OK and not "Source is open"

It will say "source is open" if you have all the workbooks open at the same time. Make sure you are linking them to the location on your computer - then hit check status with all of them open. I think OK should be fine too but if you have all open, it should really say source is open so it knows its looking at the correct workbook.

Another quick thing i noticed...the precut leaderboard only has 155 slots for players. when i paste 156 players the bottom player has no formulas in his row...is there an easy way to add?

For this, just go to the last player, click on the row number over on the left so it selects the whole row, and hit copy. Then click the empty row so it selects the entire row and click paste.

The round by round tab looks good but the hole by hole sheet when i generate scores remains blank.

I'm also getting a leaderboard filled with #REF when i update the rounds in it.

That should not be happening if you have the files linked correctly. (The #REF errors). Try re-linking and see if that works. That error is usually caused when you add/delete rows or columns. Is there a specific part of the formula in the formula bar where it says #REF? If you could share a screenshot or something that would help me diagnose the problem.

The hole by hole tab isn't actually blank - the text is white. Highlight it and make it black. It will only fill in numbers for the players that are playing in that particular tournament.

Hopefully that helps. Let me know if you're still having any issues.

[mike081989]

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

One last thing to check would be that the scores actually populated on the round by round tab. Are numbers showing up when you run the macro? If you don't have macros enabled it won't work either.

[mikemarc1]

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

One last thing to check would be that the scores actually populated on the round by round tab. Are numbers showing up when you run the macro? If you don't have macros enabled it won't work either.

This is what i see in the hole by hole tab when i highlight the sheet.

Everything else has been working this time around!

[mikemarc1]

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

This is what i see in the hole by hole tab when i highlight the sheet.

Everything else has been working this time around!

Ok so i figured it out..you literally have to make it black..i thought just highlighting it would work. Now i have a question though. McIlroy was -3 after the first round in the round by round tab..but on the hole by hole its showing that he's -6 after round 1.

[mike081989]

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

This is what i see in the hole by hole tab when i highlight the sheet.

Everything else has been working this time around!

Ok yea couple things - I think your text just needs to be changed to a different color - but I'll give a couple ideas/things to try.

1. What are you filtered on in column B? After you generate scores for round, that column will give you their position on the leaderboard in column B. Once you generate the scores, then filter out the blanks (if you want, you don't have to but it will remove the players with no scores). Looks like you still have some in there.
2. Have you accidentally "sorted" anything here? (that will cause issues with the formulas)
3. Go up to the top while you have all the round 1 scores highlighted and click on "Home" to go to the formatting options and make the text black. Its white so you can kind of unveil the final round scores if you go, hole by hole, to see each hole where you stand against someone. For example, i was 2 shots behind DJ going into the last round of my tournament and I made his scores black one by one as I played to see where I stood.

(screenshot attached)

[mikemarc1]

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

So i am getting this to finally work, thanks.

I still think there may be an issue with the hole by hole...

After the score on the 18th which is correct, the total column seems to always be doubled.

For example Rory McIlroy was +2 after round one. That's what showed in the 18th hole column in hole by hole, thats what showed his score in round by round..but when i made his final score black after round 1 in hole by hole it showed +4. Same with Justin Thomas..who was -2 after 1 round. That was his score on the 18th hole in hole by hole, thats what round by round showed, but when i made his final black after round 1, it was -4.

[mike081989]

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

Ok i think I see what happened there. Its fine in my workbook, so I think I know what you might have done.

So on your screenshot, we'll use Rory as the example. Did you copy and paste anything into cell U309? It looks like you may have copied the formula from the cell at the left. In cell U309, your formula should be =T309

That sohuld fix it. And copy that down for the whole column

[mikemarc1]

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

Sorry to be such a pain, but can you explain the cut process a bit more?

what is the point of having a post-cut and pre-cut leaderboard? Am i pasting everyone into the rankings data after round 2, or just those that didn't make the cut? I'm just pasting their names, points, and then the victories-average columns?

and then i'm doing the same thing after round 4? what's the reasoning behind doing it twice? thanks again.

[mike081989]

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

Looks like you may have copied that formula all the over a couple more columns too. The formulas are different for round 1 and round 2, so you’re going to throw off the calculations by doing that.

To fix it, you can highlight and entire row that hasn’t been edited And then paste it into Rory’s row. Just copy and paste (as in not paste values, you want the formulas)

[mikemarc1]

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

Ok i think I see what happened there. Its fine in my workbook, so I think I know what you might have done.

So on your screenshot, we'll use Rory as the example. Did you copy and paste anything into cell U309? It looks like you may have copied the formula from the cell at the left. In cell U309, your formula should be =T309

That sohuld fix it. And copy that down for the whole column

Gotcha. I may have dragged that formula over thinking i was dragging the black background over from the other cell...what's the best way to drag the black background all around?

[mike081989]

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

Gotcha. I may have dragged that formula over thinking i was dragging the black background over from the other cell...what's the best way to drag the black background all around?

You can use the format painter. Its in the home tab and looks like a paintbrush. If you double click the format painter, it will "lock" as on. If you single click and just click one cell, it will turn off after it copies the format to that one cell. Hope that makes sense. Screenshot shows where it is.

Sorry to be such a pain, but can you explain the cut process a bit more?

what is the point of having a post-cut and pre-cut leaderboard? Am i pasting everyone into the rankings data after round 2, or just those that didn't make the cut? I'm just pasting their names, points, and then the victories-average columns?

and then i'm doing the same thing after round 4? what's the reasoning behind doing it twice? thanks again.

So I'm going to write a macro to do that for you in the next day or two. Just didn't have time for it today.

But basically, there's more than one way to do it. I figured this way (removing them) was the easiest because you don't need to go in and start editing formulas.

The reason behind this:

Say you just finished round 2 and your total score is +1 and the cut was +2. You are in 65th place and Rory is in 66th place at +2 and missed the cut.

But then in round 3, you shoot +4 to make your total score +5. You're now going to show as being behind Rory, even though he missed the cut.

[mike081989]

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

Sorry to be such a pain, but can you explain the cut process a bit more?

what is the point of having a post-cut and pre-cut leaderboard? Am i pasting everyone into the rankings data after round 2, or just those that didn't make the cut? I'm just pasting their names, points, and then the victories-average columns?

and then i'm doing the same thing after round 4? what's the reasoning behind doing it twice? thanks again.

Forgot to answer the other parts of your question.

After round 2 do only the cut players. You want to paste all the relevant columns (paste values) in the rankings data tab. And you'll want to add a 1 for all these guys in the "missed cuts" column. The macro I'm going to write will do all this for you.

And then you're going to do it again after round 4 for all the players that made the cut. Make sure you're filling in the victory and top 10 columns. And then mark a zero for missed cuts for these guys

[mikemarc1]

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

Thanks again man.

Makes sense now, gonna run thru this again tomorrow night and hopefully things will go smoothly.

Appreciate the help

[mike081989]

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

Just made a minor change.

If you want your scores to show 0 as "E" without causing problems with the sorting of the scores, you can go into the number formatting. Couple ways to get there, but I'd say just highlight the entire To Par column, right click, then click on format cells.

In the box that says "Type", right now it should say +0;-0;0. Change that to +0;-0;"E" and your 0's will show as E's and behave like zero's instead of text.

[Krebstar]

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

In the box that says "Type", right now it should say +0;-0;0. Change that to +0;-0;"E" and your 0's will show as E's and behave like zero's instead of text.

Ooo, this is nice!