process to calculate perfect attendance

[THWatson]

Using Access 2003 in 2000 format.

The database keeps track of members and their attendance. Meetings are held weekly. The member also has an opportunity to attend Makeup Activities which are counted towards perfect attendance.

A perfect attendance award is granted if the member has perfect attendance in any 12 consecutive months.

If it's a 4 Thursday month, the member needs 4 attendance credits, if it's a 5 Thursday month, the member needs 5 attendance credits, in order for that particular month to be credited towards perfect attendance.

The needed 4 or 5 attendance credits in a month will be comprised of the combination of Regular meetings attended plus Makeup Activities attended, but only 4 Makeups in a given month can be counted regardless of how many Makeups a person does.

As you can see, a member could potentially have 11 straight months of perfect attendance, but miss the 12th month and he/she starts back at 0. This means that every individual member in the club is on a different cycle towards perfect attendance.

I am trying to think through 2 things...
1. A system to calculate attendance for a month, given the maximum of 4 Makeups to be counted, where more than 4 might have been attended.
2. A system to evaluate attendance and determine how many consecutive months a member has gained the perfect attendance requirement.

Maybe there's a model out there somewhere for this?

Tom

 

[GSCaupling]

Hi THWatson,

I think more details might be needed.

For example, does one makeup activity = one regular meeting? Do makeup activities for a missed weekly meeting have to be completed before the next weekly meeting, or can a member do makeup activities in a rush at the end of the month? Do makeup activities have be completed within the calendar month toward which they are to be counted? Can a member attend a makeup activity before a meeting he/she anticipates missing?

Finally, is perfect attendence calculated based on whole months? In other words, does it count if a member attends every Wednesday meeting from 3/18/09 thru 3/17/10?

GS

[small][navy]**********************^*********************
I always know where people are going to sit. I'm chairvoyant.[/navy][/small]

 

[THWatson]

GS
Thanks for the questions.

Does one makeup activity = one regular meeting?
In most respects yes. For example, in a 4 Thursday month (regular meetings are always on Thursdays), a member could not attend any regular meetings but go engage in 4 makeup activities, and that would count for perfect attendance. However, in a 5 Thursday month the member would have to attend at least 1 regular meeting, because 5 attendance credits would be required and a max of 4 makeups can be used regardless of how many makeup activities one did.

Do makeup activities have to be completed before the next weekly meeting?
No. As long as they are completed within that calendar month they will be counted.

Can a member attend a makeup activity before a meeting she/he anticipates missing?
Yes. The club wishes to reward doing things, not punish for not doing.

Is perfect attendance based on whole months?
Yes, it is calculated by month. One needs to have 4 credits in a 4 Thursday month, and 5 credits in a 5 Thursday month. However, if Christmas and New Year's fall on Thursdays no credit is needed for those days. That means that you might only need 3 credits in either December or January if that were the case.
If the member attended every Thursday from 3/19/09 through 3/18/10, that would be perfect attendance.

Tom