I need some help with editing this form.
-I need help making 15 employee slots just like N.Davidson.
-I also need to see if you can make it so if a employee does not receive and point for 30 constitutive days he receives a + point or it adds a point back to his negative.
-Also make it that a Call In (CI) receives no points and if employee comes to work for 15 days then he will get the point that was earned to him for the 30 days.
So basically I need it to
Add a point to the employee if he comes to work and not late for 30 constitutive days.
Take off a point if employee has a unexcused absence
Employee can earn up to +5 points (PTO Days)
Also if employee calls in sick then we will add a new CA tag but if employee comes to work for 15 consecutive days after the CA then his points will continue from the day that he called in sick. Example
Employee 30 days is June 30 he has came to work for every day but had to call in sick on June 3 he gets a CI on that day, but employee comes back to work on June 6 and works consecutively till June 27 now the employee is eligible for a point on June 30th if attendance is good till then.
You can make it so each day has a P for present if that has to be a option to make this work
http://www.megafileupload.com/f66k/A...Sheet_(2).xlsx
Bookmarks