Daily posts of Excel tips…and other stuff
Archive for the ‘Tenth Hole Tracker’ Category.
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
