Rick,

Assuming that the Beginning Average is in cell B2, with the weekly scores
following on in that row then in say cell B10 enter =B2

To get the averages start in C2 and enter:
=IF(C2<"",((COLUMN($G$2)-COLUMN())*$B$2+SUM($C$2:C2))/5,"")

and copy along to G10

In H10 enter the formula:
=IF(H2="","",SUM(D2:H2)/5)
and copy along the row as far as required.

HTH

Sandy


--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"Golf League Schedule" wrote
in message ...
I am trying to handicap a golf league using only the last five scores
posted.
This handicap needs to change on a weekly basis as this information is fed
to
other programs. We begin with an entering ave (last years ending ave) and
use
this average for as many times necessary until the golfer has 5 rounds
played. We use the beg. ave. four times plus one actual score to determine
the new average after week one (if the player golfed). After two rounds
are
played, we use the beg. ave three times plus the two actual scores to find
the new average. Once 5 rounds are played, these five rounds are used for
that weeks new handicap. After 6 rounds are played, I use the last 5
scores
only for the new average.

Can anybody help with this?

Rick

Scores Beg Ave Week 1 Week 2 Week 3 Week 4 Week 5 Week 6
Golfer 1 82 85 78 83 84 86
Golfer 2 90 87 84 93 94 91
Golfer 3 85 86 85 80
Golfer 4 81 79 78 80 76

Average
Golfer 1 82 82.6 81.8 82 82 82.4 83.2
Golfer 2 90 90 90 90 70.2 71 71.2
Golfer 3 85 85 85 85 85.2 85.2 84.2
Golfer 4 81 80.6 80 79.8 79.8 78.8 78.8