# Perpetually summing totals for a rolling 6 month period

M

#### mdmonzon

I have an attendance report where I keep track of absences, tardies, an
lates on a monthly basis. Absences are tracked separately fro
tardies/lates.

Tardies and lates are tracked by instance. Each tardy equals half
late. So if Joe is tardy 3 times and is late 2 times in January, hi
total tardies/lates for January is 3.5.

Absences are tracked by hours. So if Joe is out sick for 2 days in
January and he works 8 hours a day, his total absences for January i
16.

Attendance is tracked in a rolling 6-month period. So in July, Joe'
3.5 tardies/lates and his 16 absence hours roll off.

This is what I need it to do:

I want to do track attendance for a rolling 6 months. I want it s
that when I look at July's absence or tardies/lates numbers, it will b
a number that is SUM (January to July) minus January. August's number
will be SUM (January to August) minus January, February. And so on.

****************************************************

I think this would have to be done manually by me, but this what I wan
it to do:

I also want another column to read the monthly number for absences an
then populate another column with the following:

Absence hours in that month plus the prior rolling 6 months
0 - 31 hours, column should populate 0
32-39 hours, column should populate -1
40-47 hours, column should populate -2
48-55 hours, column should populate -3

If someone is on a 0, -1, or -2, -3, it will go to 0 for the nex
month, if they don't get any more absences that will bring them to th
next level. If someone is on a 0, -1, -2, it will go to the next leve
for the next month if they get more absences that bring them to the nex
level. If someone is on a -3, and they get more absences, they wil
remain a -3 for the next month.

The same goes for tardies/lates, but with the following threshholds:

Tardies/Lates instances in that month plus the prior rolling 6 months
0-9 instances, column should popluate 0
10-11 instances, column should popluate -1
12-13 instances, column should popluate -2
14-15 instances, column should popluate -3

Hope this makes sense