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
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