100 Staff 52 Weeks Bonus Pay.

[mstodge]

HI,

Please help.

I have a spreadsheet with 100 staff and 52 weeks. (which is all i have
at the moment)

we have implemented a merit system at work, where if a member of staff
is off sick for three days within a 6 week period they would not be
eligable for a bonus pay. But if they went 6 Weeks without being Off
The would get the bonus.

So in column A it would Give an "No" if they have had 3 days off within
6 weeks. if they go another 6 weeks without a day off it would give a
"Yes" or something.

I hope this makes sense.

Many Thanks
Mark.

 

[Fabian]

we have implemented a merit system at work, where if a member of staff
is off sick for three days within a 6 week period they would not be
eligable for a bonus pay. But if they went 6 Weeks without being Off
The would get the bonus.

Isnt that a little unfair? Shouldnt bonuses be paid for performance,
rather than things the people cannot control? Or are you deliberately
encouraging people to come into work and spread all their fun diseases
around the workplace, as they do in the country I live in now?

 

[Jim Carlock]

I'd create a column that holds DTO. Days taken off.

Start if off at 0. If they take a day off, increment it by one. If they
come in late, increment it by a half.

You can then run a procedure to run through all items in that at
end of six weeks. If you'd like to be proper, you can create an
additional column to track the number of weeks for each. Call it
Week# (for the heading of the column). At the end of each week
you can increment it. You can run a procedure to go through that
column to see if an employee hit six weeks, if they have, check
the number of days missed, and if applicable put a bonus in the
bonus column.

;-)

Hope that helps.

 

[Jim Carlock]

Must be a job that no one wants to come to work to.