Recent content by deaflarch

Hi Narayan, That is right about 12.5. I had thought Excel would normally round it up to the next integer if I format the cells to show no decimal place. Bear that fact I do not deal with fractions in Excel so this came as a revelation for me to TELL Excel what to do with the decimal places...

Hi Narayan, Sorry for the confusion; yes, I am talking about those with the original odd-numbered HCP that has issue, not the factored HCP. You are now looking at TORY WATSON who has an original HCP of 25 as an example. Mark

Hi Narayan, That is because DANNY SMITH has a even numbered HCP. Go look at those golfers with odd-numbered HCP and you will see they are 1 short of -1s. Take a look at TORY WATSON; his shows 13 in AE62 and also in B57, yet notice his 13th hole handicap (Hole #3), the gross and net strokes...

HI Narayan, Yes, I did check and then went ahead to strip off the =ROUNDDOWN(). Currently the formula in column AE in RESULTS tab would read as =PRODUCT(Ycell,Netfactor). If you do see that, that is the latest file version. It would be better to resend with a 'c' version so you know it...

Hi Narayan, The committee decided against the ROUNDDOWN, meaning we allow the normal round up of .5 or higher to the next whole number above otherwise dropping to the lower whole number. Thus, I stripped off the =ROUNDDOWN formula and allowing Excel to round it off by using this =PRODUCT...

Hi Narayan, I have copied the formula for TWO and THREE tabs without a hitch. So far so good. The Range Names tab is a nice addition by the way. Thanks! Shall we now move on to the NETSKINS file. What do you think of how I added a formula in RESULTS tab to column AE. The formula in AE...

Hi Narayan, I did copy and paste to the rest of the games in ONE tab. This formula is even better than what we tried to do wiht the Conditional Formatting but my Excel 2008 can only take 3 rules. But, take a look at Y59:Y62; it would not return 'AS' even though the IF formula has it...

Hi Narayan, I am getting the hang of it with the PLAYERS tab. I dragged the cell B50 to B51 and I see Jeff Lenham's name show up then. The rest is resolved there. That is cool! Now waiting for the answer to results formula for ONE and TWO tabs, and the SKINS. :-) Mark

Hi Narayan, I am able to download and see the file. Thank you, and we are almost there. Jeff Lenham (cell B117 - THIRD tab) replaces Jerry NIchols. I do see his name in cell A267 of PLAYERS tab but for some reason, his name did not show up under Team California in the LEADER tab. Jeff...

Hi Narayan, Waiting for your reply the past two days afford me some further thinking. Would like to resolve quickly a couple of separate issues on this posting: Let's begin first with the error in the LEADER tab. Team California players has incorrect totals for rounds played. I see the...

Hi Narayan, Yes, we have understood each other and achieved for the objective of taking the gross score to arrive at net scores just fine. That design worked fine for our purpose. That is until this Desert Cup event when I heard for the first time about halving the golfer's handicap as a way...

Hi Narayan, Here is my thought on addressing the golfers handicap for Net Skins result. How about naming a cell, X8, 'Handicapper', and then add a formula to look at a golfer's handicap value and produces by a multiplier value to arrive at either whole or halved product. BUT I see the halved...

Hi Narayan, I understand the approach to troubleshooting for the problem that begins alphabetically with the first offending row and that begins with Jose Sermeno. Then, I do catch a mixup starting at C36 based on the pattern of formula above in Column C. Shoot, this is strange to think of...

Hi Narayan, Take a look at the uploaded file for Desert Cup 2013: https://www.dropbox.com/s/7udramsy9g98q5y/2013DC.xlsx Take a look at the LEADER tab and you will notice the number of rounds for TEAM CA players does not add up correctly. They all should show '3' under the AD column. Mark

Hi Narayan, I am back from the event. There are a few wrinkles to iron out in both MatchFormat and NetSkins files. Let me start first with this quick issue in the uploaded NetSkins. https://www.dropbox.com/s/0i2qqpdxelc34ag/NetSkins.xlsx It seems the table is corrupted again. I have...