Wednesday, September 14, 2005

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.

No comments: