25 replies to this topic

[Carnat]

Hi everyone,

I've been lurking around on the forum for about a month now and been playing the game on my own for a couple of weeks.  I like to simulate stuff so for those interested, I created an excel file that will create tournament scores for PGA tour players and Web.com tour players to compete against.

I realize that most of you prefer playing against other people but just in case it might interest someone here, I'm uploading the file.  Please note that there are some macros; obviously, do not download the file if you do not feel it is safe enough for you - especially since this is my first post on this forum!

The players strength is based on the 2014 scoring average.  The workbook is unlocked so you can edit the average (AVG in column S) to your liking to make players more or less competitive.  You can use both the PGA tab or the WEB.COM tab; the WEB.COM one is less competitive (I barely started playing and playing with no aids so I'm using that one for the moment so to give myself a chance!).  You might notice the course name at the top with it's par.  Eventually, this should be a kind of 'slope' rating for the course and can be edited in the (hidden) column AL if you wish.

Anyway, here what it looks like...  Just in case it could be useful to someone!

(preview) https://drive.google...iew?usp=sharing

(file) https://drive.google...xRFE/view?pli=1

 

 

[Armand]

I had a look at your spreadsheet, Carnat.  It seems pretty good on the first few clicks.

 

Is there a way to insert the player's name into the names on the PGA/Web.com sheets?  I think it might be good if that option was in (and perhaps highlight the human player in the list).  I didn't look at the coding/macros too much to figure out how you determine what each player scores, but on first trial, it seems pretty good.  I also noticed that the selected course is only relevant at the start of the tournament.  Each round thereafter uses the course par used for the first round as par for all other rounds.  That is generally the case, but it limits players from using different courses for different rounds - definitely not a big deal!
 

[Carnat]

I just finished updating the file with Armand's suggestions (thanks again), if anyone is interested!

https://drive.google...iew?usp=sharing

 

EDIT:  made some corrections, version 3 can be downloaded here

https://drive.google...iew?usp=sharing

[Armand]

I like the improvements in your spreadsheet for solo play.   Have you had some interest in it?  I appreciate it's maybe something you developed for your own purposes and decided to share it with the rest of us (thanks!), so it probably doesn't matter much what the interest level is.

 

With the addition of the human player, I've thought of another potential improvement - and maybe it's not something you're interested in adding (I'm not sure I'd be able to do it).  This might be really pie-in-the-sky stuff, but I'll pitch it to you anyway:

 

After the 2nd round, would it make sense to have the players below you on the leader board play their round, then you enter your score, and then the players above you finish their rounds?  If you really want to get fancy, you could even compute the scores for players one at a time, populate the leaderboard and re-sort them before the next player's score is determined.  That way, you could watch your position on the leaderboard as the scores for other players are posted....

 

Hehehe ... I don't want to take over your sheet, though.  Update it or not based on your wishes. 

 

EDIT:  I just noticed the "How to Use" tab .... I was going to suggest instruction be added, but I see it already has been!

Edited by Armand, 15 May 2015 - 04:57 AM.

[Carnat]

No interest whatsoever except for you!   But like you said, I'm doing it for me first for foremost so it does not really matter.  I'll keep posting it as some people might have in interest in it and not actually post in the thread.

 

So, I took up your challenge and actually succeeded in making what you suggested.  After the 2nd round, when you start a round, you will only see the final scores of the ones that were behind you the previous round, with an updated leaderboard.  After you enter your score and refresh, the scores for the round will be shown for the entire field.    Never thought in a million years that I would be able to make that work but it does seem to be working .  I didn't make it populate one player at a time though, I'm not sure I would want to wait for players 100 ranks below me (or more likely, above me ) to finish their round and see their scores.  I might look into it eventually though, it would add to the immersion.

 

I also added a field to enter a total purse for a tournament (in case somebody would like to create multiple tournaments and keep an earning rankings).  The earnings are shown after you refresh the final round.

 

Here is the file!

https://drive.google...iew?usp=sharing

[newboy26uk]

Hi Carnat,

I have tried out your spreadsheet and it definitely adds an increased level of interest for solo play. Reminds me of something I used a lot with Links back in the day called Greybeard's Virtual Career (GBVC). Personally  I would love to see something along the same lines for PG but don't have the expertise in Excel to do it myself.  I don't know if you would eventually like to take your spreadsheet to the level of GBVC (and with the amount of work involved who would blame you) but maybe it would give you some ideas to further improve/enhance your current spreadsheet. 

Anyway thanks for what you have already done and I will continue to watch this thread with interest.

Here's a link for GBVC

http://linkscourses....30977575f1bfe52

[Armand]

Wow, speedy work!  It seems your VBA skills probably already surpass mine.  One final suggestion from me:  I know you can automatically run a macro when a cell value changes.  I'm thinking as soon as you enter your score, the refresh standings macro could run.  The only issue is that the score is not entered in the same cell all the time, but there must be a way to affect that change (either with an if/then on the round number or make the macro run when any cell in that range of cells changes.

 

Greybeard's spreadsheet has many, many macros and many sheets - it's fairly complex and very well done (at least the little bit I've seen of it).  I have it, but haven't used it.  I tried to tweak it at one time to make it compatible with OpenOffice, but the macros were a show-stopper at the time.  I also just looked at it yesterday, trying to help someone out with a question about it at LinksCorner.org.  It might be a big project to convert it for use with PG, and to be honest, I'm not sure I could even do it.  If someone did the upgrade, it wouldn't be right to share it with the community without Greybeard's permission.  I don't know if Greybeard has moved over to PG or is even still involved with computer golf.  Perhaps he would take it on????

[Carnat]

OMG, I was on LinksCorner (as a lurker) and never saw Greybeard's spreadsheet!!  It's amazing what he has done... Thanks for the link Morgan!

 

Obviously, I don't have the patience (and more importantly, the skills ) to do something like this so yeah, let's hope he falls in love with the game and takes on the challenge.  WAAAYYY too complex for me!

[Carnat]

One final suggestion from me:  I know you can automatically run a macro when a cell value changes.  I'm thinking as soon as you enter your score, the refresh standings macro could run.  The only issue is that the score is not entered in the same cell all the time, but there must be a way to affect that change (either with an if/then on the round number or make the macro run when any cell in that range of cells changes.

Done!

https://drive.google...iew?usp=sharing

[Armand]

Excellent, Carnat.  Now, set it up for an entire season and/or career, and you've got Greybeard's sheet for PG!  LOL, it's so easy to sit back and make suggestions.

[newboy26uk]

All looking good Carnat. Just one more suggestion/challenge from me. Is there a way to incorporate a cut after Round 2 like in real life tournaments. Probably means I'll more often than not only play two rounds but would add a little more to the realism,

As Armand says it's easy to sit back and come up with suggestions so I for one appreciate your time and effort.

Cheers

[Carnat]

The cut is one thing I also want to put in for realism sake, I'll see if I can find a way to make it work!  No guarantees though

I welcome both your suggestions as it actually force to learn VBA

[Carnat]

Was finally able to implement cuts after the 2nd round with the new version!

 

https://drive.google...iew?usp=sharing

 

Baby steps...

[Carnat]

OK, probably my last update on this!

 

Now added a 'season mode' where up to 25 tournaments can be compiled.  It creates a leaderboard sorted by money earned as you play tournaments...

 

https://drive.google...iew?usp=sharing

 

Enjoy and thanks for the input everyone!

[Armand]

I have just downloaded the sheet, but haven't yet played around with it.  I don't normally do the career mode thing, but will still check this spreadsheet out.  Looking where your spreadsheet was a bit over two weeks ago compared to its current state is impressive, in my opinion.

 

Great work, Carnat!

[Ted_Ball]

This is a wonderful concept Carnat. I haven't commented before this as I've been too busy sorting out my forum tournaments to check it out thoroughly.

 

I'm looking forward to starting my career (as a Pro (off/off)).

 

Great work

[robbiet71]

Carnat, this looks like just the thing I need. I downloaded Excel to my ipad and signed in and opened your latest .xlsm file but when I pressed Start Round 2 button nothing happened and there is no Round 2 column showing. There is also a warnings notice upon opening the spreadsheet about being unable to run certain macros.

I am clueless about spreadsheets but would love to use this. (I was actually working on a method using dice to generate scores lol)

Any help would be appreciated.

[Armand]

With Excel, the default is to disable macros on most (all?) files.  You will need to look for a message bar when you open the file to allow macros to run.  If that bar doesn't appear, then you'll need to adjust the settings in the trust center of Excel.  I'm not sure how to adjust those settings in the MAC version of Excel, but DuckDuckGo (a Google alternate) tells me that the Mac version of Excel doesn't have a trust center. 

 

So that isn't of much help, unless you can find some way to ensure that Macros run on your computer/installation.  I found a couple of other posts that may shed some light (not too positive, though):

http://answers.micro...92-0258b3e82743

http://www.mrexcel.c...macros-mac.html

[robbiet71]

Thank you Armand. I have a pc too. I think the problem is I'm trying to use the free online version of excel and it doesn't support some of the functionality (like the buttons).

Oh well, I might have to shell out for the desktop version. Cheers anyway.

[ProFirefighter]

How does this get applied to PG?