software

Hi, I have a workbook for working out Net scores and Stableford points based
on players handicap, par of the hole and stroke index of the hole (link below)

I have had a lot of help from you guys with this(thanks) and would like to
call on you once more!
Hopefully it's just a formula tweak!
The problem I am having is that when my Gross score for a hole returns a
zero or minus Net score it won't show the points correctly
i.e.
1 over par= 1point
par=3
1 under par=2
2 under par=3
3 under par=4
4 under par=5
Hole 17 on the 19/04/2006 highlights the problem
(I didn't get a hole in one :-(, just hit the wrong key when I entered the
score, but I can dream!! Entering the correct scorequot;2quot; has the same effect)
Hope it makes sense to someone.

www.flypicture.com?display=updoneamp;id=rtD2lKXdThx in advance
Kev

quot;kevhatchquot; wrote:

gt; Hi, I have a workbook for working out Net scores and Stableford points based
gt; on players handicap, par of the hole and stroke index of the hole (link below)
gt;
gt; I have had a lot of help from you guys with this(thanks) and would like to
gt; call on you once more!
gt; Hopefully it's just a formula tweak!
gt; The problem I am having is that when my Gross score for a hole returns a
gt; zero or minus Net score it won't show the points correctly
gt; i.e.
gt; 1 over par= 1point
gt; par=3
gt; 1 under par=2
gt; 2 under par=3
gt; 3 under par=4
gt; 4 under par=5
gt; Hole 17 on the 19/04/2006 highlights the problem
gt; (I didn't get a hole in one :-(, just hit the wrong key when I entered the
gt; score, but I can dream!! Entering the correct scorequot;2quot; has the same effect)
gt; Hope it makes sense to someone.
Sorry had a locked version, new link below.
gt;
gt; www.flypicture.com?display=updoneamp;id=rtDym6jf
gt;
gt;
gt; Thx in advance
gt; Kev
gt;



quot;kevhatchquot; wrote:

gt;
gt;
gt; quot;kevhatchquot; wrote:
gt;
gt; gt; Hi, I have a workbook for working out Net scores and Stableford points based
gt; gt; on players handicap, par of the hole and stroke index of the hole (link below)
gt; gt;
gt; gt; I have had a lot of help from you guys with this(thanks) and would like to
gt; gt; call on you once more!
gt; gt; Hopefully it's just a formula tweak!
gt; gt; The problem I am having is that when my Gross score for a hole returns a
gt; gt; zero or minus Net score it won't show the points correctly
gt; gt; i.e.
gt; gt; 1 over par= 1point
gt; gt; par=3
gt; gt; 1 under par=2
gt; gt; 2 under par=3
gt; gt; 3 under par=4
gt; gt; 4 under par=5
gt; gt; Hole 17 on the 19/04/2006 highlights the problem
gt; gt; (I didn't get a hole in one :-(, just hit the wrong key when I entered the
gt; gt; score, but I can dream!! Entering the correct scorequot;2quot; has the same effect)
gt; gt; Hope it makes sense to someone.
gt; Sorry posted a locked version, new link below.
gt; gt;
gt; gt; www.flypicture.com?display=updoneamp;id=rtDym6jf
gt; gt;
gt; gt;
gt; gt; Thx in advance
gt; gt; Kev
gt; gt;