10 Replies Latest reply on May 1, 2017 8:49 AM by BruceRobertson

# How to calculate "Perfect Attendance Award"

I would like to calculate the "Perfect Attendance Award" for each of my employees.

My company will reward \$100 per month for each employees who come to office without missing a date and late for work.

Below is my current calculation method:

Round ( 100 / 31 * Perfect Attendance Day ; 0 )

While "Perfect Attendance Day" is the number of days that the employee show up to work with out being late for work. Our company will still pay "Perfect Attendance Award" if the employee use his/her PTO to take a day off.

However, not every month has 31 days. Some of the months have only 30 days, and Feb has only either 28 or 29 days.

• ###### 1. Re: How to calculate "Perfect Attendance Award"

day ( Date ( M + 1 ; 0 ; Y ) )

where M is the month number  and Y is the year.

• ###### 2. Re: How to calculate "Perfect Attendance Award"

How about forgetting the "management-by-attendance model" altogether?

Just a thought.

• ###### 3. Re: How to calculate "Perfect Attendance Award"

In an ideal world, I would second that, but that ideal world does not exist. So sometimes people just work a bit better with a little extra incentive in the form of an award.

• ###### 4. Re: How to calculate "Perfect Attendance Award"

Plus!

• ###### 5. Re: How to calculate "Perfect Attendance Award"

In any case, it's a policy decision that is probably beyond the control of the database guy setting up the solution.

• ###### 6. Re: How to calculate "Perfect Attendance Award"

In my experience, when attendance is emphasized (rarely in software dev jobs), it's because real management isn't. As a software developer, who cares if I'm late, work offsite, take a long lunch, as long as I'm productive and get my work done? (Ans: no real manager cares.)

Strict Attendance <> productivity.

Strict Attendance <> morale (maybe the opposite)

etc.

However, my experience might not apply to your situation.

But, in my experience, you're solving the wrong problem.

I agree with beverly and philmodjunk, however, also.

Just sayin'...

• ###### 7. Re: How to calculate "Perfect Attendance Award"

I doubt that they are tracking the attendance patterns of software developers.

• ###### 8. Re: How to calculate "Perfect Attendance Award"

Every time you use one calc on more than one record, you must plan to deal with different records yielding the same result.

Besides that, the time I've put into it counts less than what I've put into the time.

Translated from italian: "Non conta il tempo che ci metto, conta cosa ci metto nel tempo."

• ###### 9. Re: How to calculate "Perfect Attendance Award"

There are lots of situations where it is needed that people arrive exactly in time for work and that has nothing to do with management skills.

You want your bus/train/plane to arrive exactly on the scheduled time, don't you? In such situations it is not a bad thing to stimulate employees to improve on their attendance record (or maintain their perfect record).

• ###### 10. Re: How to calculate "Perfect Attendance Award"

You will need to tell us more about how you are tracking attendance.

Is there strictly one attendance record per day?

Or might there be more records per day. Morning check-in record.

Break record.

Check in after lunch.

Etc.

How is attendance recorded?

Yes; Phil's first reply lets you calculate exact number of days in a month.