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