Thursday, May 31, 2012

Free Golf Scorecard Spreadsheet Template Download


The Memorial Golf Tournament 2012 officially kicks off today in Dublin, Ohio. Held at Muirfield Village, Jack Nicklaus’ tournament is one the highlights of the PGA Tour. I won’t be playing in any PGA tournaments any time soon, but I still like to head out to the greens every now and then and am trying to set up a golf league at my work. This also lead me to create my latest sports related Excel template: the golf score and stat tracking sheet. It’s another way to make golf fun – as frustrating as it can be some times.

So I thought I would share with all of you my golf scorecard spreadsheet template. This spreadsheet can help you with your golf scoring. It also doubles as a template to score a golf league – just copy the first sheet to add more players. There is even a golf handicap score row included in the spreadsheet to allow for you to keep track of each player’s handicap on each and every hole – it doesn’t matter whether you only play nine or go for the full eighteen. You can keep score either using the traditional golf scoring method or create your own points system based on a handicap score – the choice is yours!

The golf card spreadsheet is downloaded as an .xls file. The template is fully automated – no macros are needed or included with the workbook. There is a section on the scorecard for tracking a golf player’s stats. Using my COUNTIF formulas you can see how many eagles, birdies, pars, bogies, and double bogies you hit on the course. Are there any other stats you can think of that I am missing?


Download the Golf Score Card Spreadsheet Template from Google Docs. 

Visit our downloads page to see what other sports templates we have available for download.

Tuesday, May 15, 2012

Quick Tips: Yes/No Drop Down List


Today I'm going to show you how to make a quick and easy multiple option drop down list in Microsoft Excel 2007 (works in other versions too). Drop down lists are useful when you want to limit a user's entries to only values that you specify. I've showed you earlier how to create a drop down list using Named Ranges, which takes a few extra steps but offers more repeatability. Now I will show you a much faster and simpler solution for creating these types of lists in Excel. 
 
 
First, begin by selecting the cell you would like to add the selectable list to. Next, go to the Data tab on top and select Data Validation. A window will popup. Here you will find from the list of pull down options the ability to change the Allow: feature to List. Now, under the Source type in the name of the values you want to appear in the pull down menu, which each term separated by a comma. Click OK when you are done. That's it! 
 
 
If you click on the cell you should see an arrow appear on the right hand side of the cell. When you click the arrow you should see the name of the values that you entered in the Source box. You can fill down this cell to other cells you would like to contain the same pull down lists. 
 
 
 
Also, you can convert your user entered Yes or No value into a numeric value for calculations using a simple IF formula,: If the user selects Yes then the value is 1, if No, then 0: 
 
=IF(A1="Yes",1,0) 
 
For more Excel spreadsheets tips please consider joining our newsletter. 
 
Check out some of our recommended tools to learn Excel and how to write VBA macros.

Monday, May 7, 2012

Sports League Excel Spreadsheet Template


Here at Excel Spreadsheets Help we’re always looking for unique uses of Excel spreadsheet templates. Recently, a reader shared one of his sports templates with me, but it wasn’t what I was expecting: it was a score and stat keeping template for a horseshoes league! I’ve played horseshoes for fun on occasion but I never knew there were horseshoe leagues complete with standings and scoring. Luckily, Tom Moffat, the creator of this horseshoe league template agreed to further explain the sport as well as the template. Thanks to Tom, now onto the questions:

ESH: Is this an individual or team sport?

Tom: It is both a team sport and an individual sport.  Our league is a team sport but we keep your individual stats to determine handicaps for team matches.  In tournaments it really becomes individual and we have city, provincial (same as your state) championships and Nationals.

ESH: For those not familiar with horseshoes, what is a ringer and how does it differ from the average percentage? 

Tom: Horseshoes is like bowling – we throw two shoes at a time with a shoe within 6 inches is 1 point and a ringer (surrounding the peg) worth 3 pts.  We play 25 ends so that’s a total of 50 shoes. So the average is your average total score for a game.  Your ringer percentage is how many ringers you would throw in 100 shoes, all based on your game scores.


ESH: What do the classes mean?

Tom: We have different caliber players on each team in our league - some are very good and competitive, and others are just out to enjoy a night of fun.   So your average and ringer percentage determines your class.  AA is the best and E is the lowest



ESH: Where can you go if you want to know more about the sport and league?

Tom: Yes, you can visit our club website Greater Victoria Horseshoe Pitching Association.


To see the results weekly on our website is just a pdf of the spreadsheets under the men’s league.

Also, someone looking for horseshoe league information in their area can check out the National Horseshoe Pitching Association (NHPA).

Hope this helps you understand our game and it is really a great game for all ages.  And unlike bowling it is probably one of the cheapest sports around.   Check it out in your area!


ESH: There’s a lot more to horseshoes than I thought and it certainly sounds like fun! Thanks again to Tom for sharing his insight into the sport of horseshoes. Click here to download a blank version of his horseshoe league template if you’re interested in starting your own league or just want to keep score among friends or family.