Hi all. I finally finished the latest and greatest tournament manager. It now includes player handicapping, including player trending, a gross and net score detail history worksheet and an easy way to get these reports setup to where you can "save as" a pdf file for sharing.
Here are some sample videos I recorded to show you how the spreadsheet works. The first one is the Setup Members macro. When you start using the tournament manager, you will need to setup all of your members. This macro does this for you quickly and automatically. All you need to do is copy your members into the windows clipboard, then click the "Continue" button. That's it. All your members will be transferred.
Check out the video:
The next step you'll need to do if you're planning on running "net score" tournaments is establish each member's handicap. The macro that is included with the tournament manager will handle this quickly and easily. You simply enter a "revision date", then select the member from a prefilled list. Once you have a member selected, you click a button to load their WGT profile, then load their score history. When you're finished copying all their scores into the Windows clipboard, just return to the program and click load scores. Then you can use one of 3 options to calculate handicaps. You can also set your own number of decimal places for the handicap index and the par value. You can adjust the handicap further by adding, subtracting, multiplying by or dividing by a set value. When everything is set, click "Calculate", then "Post Handicap". That's it. The boring part ... you'll need to do this for every member in your CC, and you'll want to revise the handicaps at least once a month. But it is easy to run ... just takes a while based on your CC's member size.
Check out the video:
Once you have your member's handicapped, you can paste and update the tournament scores quickly and easily. You only have to tell the macro if you're posting a 9 hole or 18 hole tournament; whether it's gross or net, then let the macro paste the scores to a Game Clipboard. If you have a makeup round, you can add it to the tournament just as easily. Once you have all the scores for the round transferred, you select Update, choose the scoring method, enter a tournament title and hyperlink then click the update button. This feature is extremely fast. In the sample video, there are 8 rounds updated, and it took 12 minutes from start to finish.
Check out the video:
Finally, to make your life easier, there is a reports generator. This macro will setup the print range, the page headers and the orientation for you. When your finished, you can use the "Save As" feature to create a PDF file you can share with all of your members. This is so easy, you'll be able to share updates as often as you wish.
Check out the video:
Now here's the requirements of the Tournament Manager. You'll need to have Microsoft Excel, version 2007 or greater in order to use it. You will also need to have an internet connection. That's it.
This is a "shareware" spreadsheet. I hope if you use it, you'll consider sending me a sleeve or two of Nike Level 81 golf balls. There's more than 100 hours of programming time in this program; so a sleeve isn't really much, considering all the time it will save you or your tournament manager.
So now you're asking, where do I get it. Well, since I like simple, downloading the new Tourney manager is relatively simple. Just make sure you download the version 3.0 spreadsheet and the documentation. The sample videos are also there if you want to use them as a training aid. So ...
to download the Tournament Manager and documentation,
Edit: No longer available.
Note: If the link does not work, just copy and paste to your browser.
I truly hope you enjoy this time saver! Enjoy!
Kat ♥
Edit: The links didn't work that well ... added videos instead.