Taro, on 21 May 2012 - 07:26 PM, said:
Great work on your excel form for the Callaway scoring system..
I'M holding a two tee start competition and wanted to ask your advise on how to adjust the cells so that i can include both the 17th & 18th holes? Or perhaps another option might be to omit the last hole on each side??
will be grateful to you for any advise and recommendations.
JMazz, on 18 August 2011 - 04:13 PM, said:
I had some spare time so I whipped one up in Excel. I'm pretty sure I worked all of the bugs out. It isn't anything flashy but it gets the job done. I've included an instruction tab and a macro in case you want to omit 16-18 as opposed to 17-18. I'm not sure if I can attach it here or not? I am giving it a shot.
EDIT: I guess that didn't work. Well, I have the excel file handy. If you can send me your email address or tell me how to attach things on this board I will send it out
EDIT EDIT: Full editor is tech. File attached!
I'm not sure of your Excel skills so I'll try and spell this out as simply as I can. My intention is not to insult your intelligence but to make sure anyone else that wants to do this can do so with next to no Excel experience.
If you don't want to omit 17 and 18:
1. Unhide the hidden columns in the Scores tab. To do this, highlight the columns across the page, right click somewhere in the highlighted area and select "Unhide". This reveals the working cells
2. Highlight columns AN and AO
3. Hit Ctrl+F to activate the Find module and click the "Replace" tab
4. On the replace tab, enter "AJ" in the "Find what" line and "AL" in the "Replace with" line. (Omit the quotes when entering these things)
5. Click Replace All.
6. Rehide columns U-AQ
That should do the trick.
Omitting the 9th and 18th holes will be a bit trickier. Basically, what we did above is extend the range of the MAX functions in the formulas. That is, originally, the formulas in AN and AO are finding the highest scores in cells U-AL which have been adjusted for the double par rule. This find/replace simply extends that range out to column AL (or hole 18). To pick holes 9 and 18, you would need to take the MAX of the MAXes of 1-8 and 10-17 so instead of MAX(U4:AI4) you would have MAX(MAX(U4:AB4),MAX(AD4:AK4). I don't have time to test and vet this so no guarantees that there isn't some rounding error or something silly in there! For simplicity's sake, I would go with including all 18 holes. I would hope no one keeping that much of an eye on the leader board to be able to purposefully tank late in the game.
Also, while doing this exercise, I realized I made a pretty massive error when configuring the macros to omit or not omit hole 16. It was a quick fix so if anyone wants that update send me a PM and I'll hook you up. Apparently no one has been able to download directly from the forum. This error shouldn't have made a difference for anyone that was using the sheet "as is" or if you switched back to the original setting. Basically the macro was only changed the first player to omit 16, instead of the whole field