Search results

I do get "Invalid Operation". However would it be worthwhile upgrading to 2011 for Mac. What would be the biggest reason(s) if any in your view?

I have Execl 2008 for Mac so this is equivalent to Excel 2007, right? What would make it worthwhile upgrading to 2011 for Mac?

Well, what if you decided to take up on golfing after finishing this task thanks to this concept of handicapping. Hmmm. From a quick visual inspection, the formulas you created appears to met its objective thus far. When I clear the content (names of golfers), I get pounds symbol in all the...

Finally had a chance to review what you did. Wow! You did great. This version does work! Will put that to the test this Saturday at a golf outing. I noticed that you use absolute cell references and would that be a problem if I could expand the range by copying a few rows in the middle and...

Shall this means I first name the range B10:B16 in SKINS tab as 'Golfer_Handicap' and then the range C7:U7 as the 'Men(?)_Hole_Handicap'. I suspect you prefer to do one thing at a time before we distinguish between two sets of Hole Handicaps, right? Then type the formula you gave in C10 on...

Let me practice on the tip on posting a small block of data in a Post after another reading on 'Posting a sample workbook' You wanted to know about GOLFER E and here is my try to copy and paste from Excel: HOLE PAR 5 4 3 4 4 4 4 3 5 4 4 4 3 4 3 4 5 4 GROSS...

Thanks Narayan for setting me straight on properly using the backticks. Still they do not exactly align perfectly like you did two replies ago. Hmmm.

For GOLFER F with HCP of 7 would work this way for Hole HCP deduction; Hole 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Hole Handicaps 10 4 14 16 8 2 12 18 6 5 15 9 13 1 17 11 7 3 Deduct 0 -1 0 0 0 -1 0 0 -1 -1 0 0 0 -1 0...

With GOLFER E's HCP of 37, we would go through first two loops and stop at Hole Handicap #1 on the third loop for the value limit. Hence the Net Scores should look like: Gross Scores 10 5 7 5 5 5 6 5 6 5 4 4 7 6 5 5 7 7 Hole HCP Deduct -2 -2 -2 -2 -2 -2 -2 -2 -2 -2 -2 -2 -2...

How do I know that you replied without refreshing this blog webpage? I wanted to reply in a timely manner. Oh, well. Thanks for explaining the power of backtick. How cool! The golfer's HCP is used to subtract against the Gross Score to result as Net Score you see in the RESULTS tab. To...

Hi BobHC, "...one gigantic bunker" as it seems like for Arizona in anybody's unseen imagination. LOL Back in the 1930's when the game of golf is first taking root in the Copper State, the course designer had thought how water would be unlimited drawing from deep wells and carpeted the whole...

How come you were able to keep the numbers aligned. I tried to do likewise but it is not.

You were taking down the numbers from the older version before I cleaned up and upload the file for your peruse. I changed from 20 to 23 for this problem challenge. So the net scores are now correctly read below for Golfer A: Par Scores 5 4 3 4 4 4 4 3 5 4 4 4...

I am sorry for the seemingly inconsistent net strokes in the SKINS tab as a result of butchering up effort reducing from 25 golfers to 7 here for the purpose of exercise to get an answer. It seems that you are taking a close look at Golfer A to get the drift of my challenge question, so I...

1. Yes, data is manually entered in the following cells on the RESULTS tab: D14:L14 and N14:V14 is for Hole Pars taken down from the golf course scorecard where the game is played at. C15:C21 is for the tees a golfer chose to play from. Values are based on the colors of tees; typically...

The remark on "too much golf in one day" gave me a good chuckle. OK. 1. We should first name the ranges for the men's and the ladies' hole handicaps to help Excel read off those values in the same SKINS workbook if that helps. Then a formula (possibly nested) can be written in Cell C10 for...

Sure, Narayan, I can try to explain where and how. Golfer A has a HCP of 20 and plays from white tees. Can an Excel formula read those values and go assigning -1 against the par in the order of the Men's Hole Handicap from 1 to 18 and then again from 1 thru 2 for the total HCP of 20. The...

Thank you Fasseh. Here is the link to my Excel file on golf handicap as explained above. Hopefully I am doing this right. https://www.dropbox.com/s/76egqytdczw9yhw/MasterNetSkins.xlsx

A golfer carries his handicap and use this for the Net Skins Game in golf. There is hole handicap assigned with 1 being the most difficult to 18 being the easiest to play in a random order on a given course. Let's say as an example, a golfer carries a 10 handicap, thus he get deduction of 1...