Excelguru is DA MAN

GeorgiaSnake · #1 (**permalink**) 06-01-2003, 03:20 AM

Keith you are the "MAN" when it comes to excell. My spreadsheet screams like a small block and has the power of a big block.

I owe you big time - send me a invoice or something or when you get back down here with your car I'll let you outrun my sb just to make you feel good.

Thanks again
Randy

excelguru · #2 (**permalink**) 06-03-2003, 05:45 PM

LOL - Aw shucks. You're too kind. I was happy to help. Let me know if you have any future Excel questions.

My favorite application was to create a spreadsheet that would take 21 golfers (and their handicaps) and create 7 teams of three for which:

(a) the team handicaps (sum of all 3 players) would not vary by more than an input value from the best team to the worst (say, no more than 3 strokes), and...

(b) the sum of the handicaps for the top two players of each team would also not vary by more than an input value (say, no more than 2 strokes), and...

(c) the spreadsheet must allow for changing these values as the user saw fit.

If my math is correct, there are several million combinations for creating 7 teams from 21 players. My spreadsheet can assign the required teams in several seconds, if a solution exists for the given criterea. That was obviously a slow day at work (heck, my boss was the one who asked for the spreadsheet).