• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to have Excel tabulate and return the custom results in a golf match format

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 Lenham's name should show up in the next available cell - that would be cell I37 in LEADER tab??


Mark
 
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 Mark ,


Can you check this revision ?


https://www.dropbox.com/s/npewkulnwttmes2/2013DC_Revised.xlsx


I have changed the formulae for the results in column X for the first three matches ; I have deleted the results in the remaining columns for the first match ; you can do the same for the second and third match and verify.


If everything is OK , you can copy these formulae to the remaining cells in column X on the ONE tab.


The same technique should work on tab TWO also.


Narayan
 
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. Please check my revision.


https://www.dropbox.com/s/dp9bre8xaj8scp4/2013DC_Revised.xlsx


Mark
 
Hi Mark ,


Sorry ; I hadn't realized that if the result is AS , then the running total is 0.


I have modified the formula so that the test for an AS result is done first ; see the file now :


https://www.dropbox.com/s/npewkulnwttmes2/2013DC_Revised.xlsx


Narayan
 
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 would factor the resultant handicap in column B of SKINS tab.


Mark
 
Hi Mark ,


Can you see this revised file ? I have changed the formulae , but I am not sure that the results are correct ; you can verify and let me know.


https://www.dropbox.com/s/7onvt1nwd7hc5hl/NetSkins_rev1b.xlsx


Narayan
 
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 formula in column AE of RESULTS tab.


So with a odd numbered HCP, for example halving 25 should result as 12.5 thus returns as 13 in column AE of RESULTS tab and column B of SKINS tab. Yet reading across the rows at net strokes in SKINS tab, I see golfers with odd numbered handicap are still 1 short in their total -1s. Can you check and explain how you would resolve this matter?


https://www.dropbox.com/s/s6yronhlx5m96g5/NetSkins_rev1.xlsx


Mark
 
Hi Mark ,


I think you have not checked my latest uploaded file ; I find the earlier formulae in your file.


Can you recheck my upload ?


https://www.dropbox.com/s/7onvt1nwd7hc5hl/NetSkins_rev1b.xlsx


Narayan
 
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 is the latest:


https://www.dropbox.com/s/8m08pitm6p503o7/NetSkins_rev1c.xlsx


Mark
 
Hi Mark ,


Can you please give an example of which golfer has a problem ? I checked the values for DANNY SMITH , and I don't find any problem.


Narayan
 
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 are the same (look between F62 in RESULTS and E57 in SKINS tabs). This is how I realized the pattern is the same for all golfers with odd-numbered HCPs. Make sure you have the AE12 ('Netfactor') value at .5 so you can see the issue.


Mark
 
Hi Mark ,


I am slightly confused ; DANNY SMITH has an original handicap of 18 ; when you use a factor of 0.5 , his handicap becomes 9 , which is odd ; I am talking of this. With a handicap of 9 , I did not find any problem.


I will check TORY WATSON.


Narayan
 
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 Mark ,


Please understand the difference between formatting a cell to display a value , and actually having that value in a cell.


Since you have removed the ROUNDDOWN , the cell displays 13 , but what it really has is 12.5 !


Please incorporate a ROUND or a ROUNDUP in the formula in column AE , so that what is displayed as 13 is really 13.


Narayan
 
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.


Taking up your suggestion, I went to task, adding a ROUND, but that does not do the trick. Then yes, ROUNDUP did acheive the desired effect and thereby resolved the issue.


Thank you!


Mark
 
We have a group of 24 guys each year traveling and golfing 4 days straight. We play a lot of match play.
I have been trying to write the required formulas to get the hole by hole results.
I found this post and the back and forth is interesting. I would like to see the file but don't have a Dropbox account.
Is the an simpler way to get the scorecard file?
 
You must log in or register to reply here.
Back
Top