Archive for the ‘Tenth Hole Tracker’ Category.

No Topic

Weekends are kind of slow around here, so let's try this: A post about nothing.
This is where you, a reader, post. Ask questions. Suggest ideas for posts. Tell us how you use Excel. Tell us how you first met Excel. Anything goes as long as it's possibly marginally related somehow to Excel, people who [...]

Starting Handicaps

In the Handicap UDF, there’s a call to another UDF: GetStartingHC. Every golfer has a handicap to start and it’s stored in TblPlayers. For most golfers, it’s a carry over from last season. For new members, it can be their USGA handicap. When a golfer doesn’t have three scores, the starting [...]

The Handicap Function

It’s time to write the first formula for my golf league program. I started with a function to compute the handicap because it was at the bottom of my sketch. I knew that this program was going to be primarily UDF’s that filled worksheets. Because of that, I need to be aware [...]

Where to Start

By the time I decided to move back to Excel, I had already created an Access form that worked quite nicely. I wasn’t really in the mood to recreate the form in Excel, but I knew I had these as bookends:
Input - physical scorecards inputed via a userform.
Output - HTML pages showing results
I had [...]

Setting Up the Data

As I mentioned in Everything Ain’t a Nail, I’m putting together a little program to keep track of my golf league. It’s more difficult than I thought it would be, particularly the algorithms to compute the scores. As long as I’m spending so much energy on this, I might as well document my [...]