Golf scorecard again

Thanks for the clarification, Kev. Ok, thought it more straightforward to
just use your Table 1 (the one with the correct shot allowances) as a
reference source, and revise the earlier formula in D6 to read the figures
direct from Table 1 instead, via an INDEX(...,MATCH(...),MATCH(...)).

Here's the revised sample file: http://www.savefile.com/files/7533806
File: GolfScoreCard_kevhatch_newusers_2.xls

The revised construct hence reads as:

Put in D6:
=IF(C6="",0,C6-INDEX(Chk!$A:$S,MATCH($B6,Chk!$A:$A,0),MATCH(C$4,Chk!$A$5:$S$
5,0)))

(revised formula in D6, Table 1 is in sheet: Chk)

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)))

(no change to formula in E6)

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 (Erase all
the dummy scores in row 6 first)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"kevhatch" <[email protected]> wrote in message
news:[email protected]...
> ok max, thx. sorry to be a pain.
> I have applied and tested the formula and found a few discrepencies.
> Uploaded here:
>
> http://www.savefile.com/files/4982248
>
> Table 1 shows:
> what the extra shot allowance should be per hole according to players
h/cap
> and the stroke index of each hole.
>
> Table 2 is showing the formula results. Discrepencies being the blue
figures.
>
> Hope all this makes sense.
> Thx
> Kev

Thx Guys, excellent job. I'm learning..slowly!

"Max" wrote:

> Thanks for the clarification, Kev. Ok, thought it more straightforward to
> just use your Table 1 (the one with the correct shot allowances) as a
> reference source, and revise the earlier formula in D6 to read the figures
> direct from Table 1 instead, via an INDEX(...,MATCH(...),MATCH(...)).
>
> Here's the revised sample file: http://www.savefile.com/files/7533806
> File: GolfScoreCard_kevhatch_newusers_2.xls
>
> The revised construct hence reads as:
>
> Put in D6:
> =IF(C6="",0,C6-INDEX(Chk!$A:$S,MATCH($B6,Chk!$A:$A,0),MATCH(C$4,Chk!$A$5:$S$
> 5,0)))
>
> (revised formula in D6, Table 1 is in sheet: Chk)
>
> 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)))
>
> (no change to formula in E6)
>
> 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 (Erase all
> the dummy scores in row 6 first)
>
> --
> Rgds
> Max
> xl 97
> ---
> GMT+8, 1° 22' N 103° 45' E
> xdemechanik <at>yahoo<dot>com
> ----
> "kevhatch" <[email protected]> wrote in message
> news:[email protected]...
> > ok max, thx. sorry to be a pain.
> > I have applied and tested the formula and found a few discrepencies.
> > Uploaded here:
> >
> > http://www.savefile.com/files/4982248
> >
> > Table 1 shows:
> > what the extra shot allowance should be per hole according to players
> h/cap
> > and the stroke index of each hole.
> >
> > Table 2 is showing the formula results. Discrepencies being the blue
> figures.
> >
> > Hope all this makes sense.
> > Thx
> > Kev
>
>
>

Glad to hear it worked !
Thanks for the feedback ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"kevhatch" <[email protected]> wrote in message
news:[email protected]...
> Thx Guys, excellent job. I'm learning..slowly!