Update on Canada John's golf league project

I recently sent Canada John version 2 of his golf league score input system. Things added in were automatic point (individual and team) calculation based upon the league's rules, pars & handicaps of each hole, and handicap differentials of the two players pitted against each other.

I also added in a feature to automatically fill in the all-pars hole scores for the defualt "play against the course" player to reduce data entry.

Also, to reduce data entry, I added a schedule where John can specify on a week-by-week basis which teams are playing against each other and what they're starting holes are. Then, all John needs to do is set the week number and the starting hole, and the teams automatically fill in. Then he auto-populates each team and deletes moves players as needed, auto-fills in the "course" player (if needed), inputs the hole-by-hole scores, and submits the scores to be archived for use in calculcating individual and team points standings as well as maintaining up-to-date individual player handicaps based upon the gross scores.

I already have ideas for v 3.0: string together some macros to further stream line data entry -- e.g. "Submit scores + clear scores and player names + move to next hole + auto-populate teams" would save a few clicks. Also, I'd like to create the weekly summary page and overall standings pages that can be published to the web in the way John does is now.

All of this I'm doing in between the flow of other projects, many of which are too boring to mention...but they're still worth $50.

Who else has $50?

Just sent off John's golf league management project

John, thanks again for the project. I had a great time doing it, and I'll take a few more cracks and further integrating what I built with what you have, if you like.

To everyone else, what I basically accomplished for John was to create an easy, quick user interface to input the weekly results of a golf league. Using some fairly complex look-up referencing in Excel formulas, coupled with some VBA, I essentially turned one sheet of an excel workbook into a userform, and several others into various "tables". It's practically a database now!

Here's the interface:


What John gets is two tables -- one for individual historic performance, and one for team historic performance -- from which he can run all of his calculations to maintain handicaps, team and individual standings, as well as generate weekly results pages that he can export to the web.

Pretty slick if you ask me...and all for $50.

People continue to take advantage of the $50 project deal

These keep coming in, and I'm steadily cranking them out...

A couple of the latest projects are from Brandy, who needed just a bit of help with some Excel Lab homework...

...and from John, who's looking to streamline the entry of golf scores into a golf league/handicap management spreadsheet that he uses to publish the results to a web page. Fun project, John, even though I'm not done yet. I was impressed by the publishing scripts in the file. Are they yours? This, of course, is right up my alley. Be sure to check out www.kolvensystems.com if you haven't yet.

More to come on other projects...E_G