Forums

Help › Forums

Rate My H'cap System Please

rated by 0 users
Thu, Apr 30 2015 8:34 AM (17 replies)
  • PAGES
  • 1
  • 2
  • mantis0014
    8,946 Posts
    Fri, Apr 24 2015 5:52 PM

    For Wgt you have to use  + (plus)  h/caps.

    Based on a proper h/cap system we use in real life.  

    The good players playing here will have a high H/cap and the high ave players will have a lower h/cap

    eg;   A good player of the club will have a 12 h/cap... that person shoots 60 + 12 =72

           A high Ave player will have a h/cap of 4 ... that person shoots 67 + 4 = 71

    You just have to work out everybodys ave score for the past set number of games to get the h/cap

    -Roger

    Edit ...  as in real life your h/cap is 12.3   so after each game you play...  that decimal point can go up or down.   We only update peoples h/cap on Single Games and not unlimited

  • EasyEdward
    13,507 Posts
    Sat, Apr 25 2015 2:46 PM

    Premed:

    Tnx EE for your detailed replies. Everything you say makes sense and I accept that you really know your stuff. However I couldnt possibly  spend that amount of time in maintaining a hcap system.

    Under the assumption that no system is perfect I am going to run with my easy to administer imperfect system. However if you would like to leave the Peoples club ( even for a sabbatical) and join Majestic Mountain you could help get your hcap system up and running for us. :) 

    Pre

    Pre:

    Only way I will leave The Peoples Club is when I get booted after being dead for 30 days - then I would be no help to you either - lol   :-)

    Let me ask something though: What is your knowledge level for Excel (and do you have it on your computer)? 

    If you have a little more than basic knowledge of Excel I may be able to help from afar.

     

     

     

     

  • Premed
    776 Posts
    Sat, Apr 25 2015 4:23 PM

    ya Im pretty ok with excel, formulas etc,  but not great with macros,  and anything i dont know i can pick up easily enough, - but time is my enemy, I already look after everything to to with tourneys and I need hcap to be simple. I cant see anyway to capture data from 200 individual pages quickly, and to do that maybe every month ?? But id be interested in any help I can get.

  • EasyEdward
    13,507 Posts
    Sun, Apr 26 2015 2:51 PM

    Pre:

    OK I figured out a somewhat easy way to do it. You will be using the CC Closed Tourneys to pull the results NOT all your members' profile pages individually. That way you are just copying and pasting from there for each tourney.

    If you intend to do a HC for next month based on how the members did in say 5 (or more) of 10 specific tourneys in this month my guess is that you could calculate them all in under an hour (maybe 2 hours the first month).

    I can either explain it in a PM (just send a FR) or I can set something up in my Excel Online page and get you the link to it when I have time. I have a golfing buddy showing up at my place this week. 

    EE

     

  • oneeyedjohn
    9,588 Posts
    Sun, Apr 26 2015 3:21 PM

    Hi Ed,

    I could do wiv some help copying and pasting the closed tourney leaderboards into Excel.

    Would be very useful if ya could gimme some examples or directions.

    Thanks

    1i

  • Premed
    776 Posts
    Sun, Apr 26 2015 4:30 PM

    EasyEdward:

    Pre:

    OK I figured out a somewhat easy way to do it. You will be using the CC Closed Tourneys to pull the results NOT all your members' profile pages individually. That way you are just copying and pasting from there for each tourney.

     

    EE

     

    Ty EE, I have no prob copying & pasting from past tourneys into an excel, use formulas to "clean" the data. But thats not the way to go for me. Too much work and still got probs with that as i doesnt include all members, only those who have played recently, and then when there are new members they have no play history. Also we have such a variety of tourneys with different settings then thats not really helpful either

    My system is crude and imperfect, but simple. It is already showing popularity and success with top tier players having to work hard instead of coasting. Best of all its easy to administer and this is not a paying gig im all for making life easy where possible :)

  • EasyEdward
    13,507 Posts
    Mon, Apr 27 2015 12:21 PM

    1i

    Instead of giving a long lesson in Excel - I will give you a simple easy to explain 3 step process:

    Step 1 - Open your tourney and highlight the scores and click on copy  - it should look like this [well not exactly as you are not in The Peoples Club - lol):

    Step 2 -  In excel you have just 2 Paste choices "Keep Source Formatting" or "Keep Destination Formatting".  Neither are great options unless one formats all of the destination cells so even though it looks crazy use "Keep Source Formatting"   It will look like this:

    Step 3 - Next to get rid of the graphics and make this useable copy what you just pasted and paste it again somewhere else on the page 9or a different "clean" page). Tthis time you have 6 choices (don't you love having choices?) - pick "Values" [the one with 123 on the clipboard] and paste it. It will then look like this:

    Now you can do whatever you want with it.

    EE

    Note: The down and dirty simple process set forth above leaves a bunch to be desired BUT everyone should be able to understand it.  You will find that if you try to delete the columns (A-F above) they do not fully delete. There are ways around this but the simplest thing to do is to set up a page (call it temporary, scratch or whatever) to just to go through steps above and then move the nice clean info (Cols H-M) into where you want to work with it.

     

  • Premed
    776 Posts
    Thu, Apr 30 2015 8:34 AM

    Thats a great instructable EE, well explained for those who may only have basic excel skill. Usually I just paset as plain text first time, works fine for me.

  • PAGES
  • 1
  • 2
RSS