One play ..

Put in D6:
=IF(C6="",0,IF(C$4<$B6-18,C6-2,C6-1))

Put in E6:
=IF(D6=0,0,IF(OR(C$3-D6<-1,C$3-D6>3),0,VLOOKUP(C$3-D6,{-1,1;0,2;1,3;2,4;3,5}
,2)))

Select D6:E6 and copy / paste to G6:H6, J6:K6, M6:N6, P6:Q6, S6:T6, V6:W6,
Y6:Z6, AB6:AC6

Then just select D6:AD6 and fill down as many rows as required (but erase
all the dummy scores in row 6 first)

Sample file with the implemented construct available at:
http://www.savefile.com/files/8674458
File: GolfScoreCard_kevhatch_newusers_1.xls
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"kevhatch" <kevhatch@discussions.microsoft.com> wrote in message
news:DB69293F-3DAA-42E1-B1F4-715A347A02E1@microsoft.com...
> Is there a formula for this?
> Stableford Golf Scores.
> To work out a players total points based on their handicap.
>
> Each hole is handicapped (Stroke Index 1-18). The players handicap
> indicates the hole upon which he can deduct a stroke,
> ie. Players handicap is -4, he deducts a stroke on each of the first four
> handicapped holes.
> If his handicap is -28, he deducts a stroke on each hole, 1-18 and an
> additional stroke on holes handicapped 1 thru 10. (His handicap minus 18).
> Players handicaps run from -0 to -28.
>
> Points are scored as follows:
> 1 over par= 1pt
> par= 2pt
> 1 under par= 3pt
> 2 under par= 4pt
> 3 under par= 5pt
>
> I have started one based on a 28 handicap which I think is correct, and
> posted it here:
>
> http://www.flypicture.com?display=updone&id=qtr1m6U=
>
> Is there a way it can be worked with variable Stroke Indexes (for
different
> courses) and handicaps (different players)?
> Sounds impossible to me but I'm sure you guys can figure it out.
> Thx
>
---
> That link isn't working, try this one:
> http://www.flypicture.com?display=updone&id=qtr0k6g=
>