Golf Quota Point System Formula Help

[Jonezy47]

Good Afternoon,

I am in dire need of help. I am not to savvy with Excel. I have been struggling and seem to find no answers on how to convert someones score to par, to points in the row below. For example in quota point system, its a lot like Stableford, but ones handicap is subtracted from 36, and must obtain that many of points. For instance, if the hole is a par 5, in F11 I would enter someones score, and in F2 it would show there points earned according to par.

Eagle 8
Birdie 4
Par 2
Bogey 1
Double Bogey or worse 0

So if someone got a 6 on the hole it would show 1 in A4, and same for if someone got a 4 it would show a 4 in A4 all depending on what they scored. Hope this makes sense thank you

 

[Fluff]

You can drag the formula across.

 

[Jonezy47]

Is there a way to copy and paste A10&11 thru X10&11? So I can just copy and paste for each new player without having to do all the formulas and stuff again for each player? and do the formulas adjust to where the new rows and columns that they will be in? I have 24 players and will be easier to just copy and paste it 24 times.

 

[Fluff]

Yes you can copy/paste the formula.

 

[Jonezy47]

Is there a way to show skins for each hole? I have provided what I have done so far, but the final step to this sheet and will save me a whole lot of time is if it could calculate the skins for me. There are two options I wouldn't mind using that I have shown as a little bit of an example. Whether it just shows how many birdies/pars etc were made on hole 1 and so on, or if there was just a way to autmatically show who won, with their name and hole info!

 

[Fluff]

As this is a totally different question, it needs a new thread. Thanks