Spreadsheet: 108055d1305153817-excel-2007-if-formula-attendance-tracking-master
Sheet: Master Lists

 | Employee Master List |  |  |  |  | Infraction Codes
 | Enter New Employee Information Here |  |  |  |  | Enter Possible Infractions Here
 | Employee Name | Employee # | Date of Hire | Date of Termination/Transfer |  | Attendance Infraction | Infraction Code | Severity
 | Test 1 | 00001 |  |  |  | Late Arrival | LA | 1
 | Test 2 | 00002 |  |  |  | Early Departure | ED | 1
 | Test 3 | 00003 |  |  |  | No Show | NS | 2
 | Test 4 | 00004 |  |  |  | No Call/No Show | NC/NS | 3
 | Test 5 | 00005
 | Test 6 | 00006
 | Test 7 | 00007
 | Test 8 | 00008
 | Test 9 | 00009
 | Test 10 | 00010
 | Test 12 | 00012
 | Test 13 | 00013
 | Test 14 | 00014
 | Test 15 | 00015
 | Test 16 | 00016
 | Test 17 | 00017
 | Test 18 | 00018
 | Test 19 | 00019
 | Test 20 | 00020
 | Test 21 | 00021
 | Test 22 | 00022
 | Test 23 | 00023
 | Test 24 | 00024
 | Test 25 | 00025
 | Test 26 | 00026
 | Test 27 | 00027
 | Test 28 | 00028
 | Test 29 | 00029
 | Test 30 | 00030
 | Test 31 | 00031
 | Test 32 | 00032
 | Test 33 | 00033
 | Test 34 | 00034
 | Test 35 | 00035
 | Test 36 | 00036
 | Test 37 | 00037
 | Test 38 | 00038
 | Test 39 | 00039
 | Test 40 | 00040
 | Test 41 | 00041
 | Test 42 | 00042
 | Test 43 | 00043
 | Test 44 | 00044
 | Test 45 | 00045
 | Test 46 | 00046
 | Test 47 | 00047
 | Test 48 | 00048
 | Test 49 | 00049
 | Test 50 | 00050
 |  |  |  |  |  |  |  |  | Action to be Taken |  |  | Explanation
 |  |  |  |  |  |  |  |  | 1st Infraction: Verbal Reminder  (Step 1 - Positive Discipline Policy) |  | Step 1: Verbal Reminder | Verbal Reminder: On the job and in private the supervisor will offer the employee a casual and friendly reminder of the infraction.  It will be supportive in nature, and can take place anywhere so long as it is confidential.
 |  |  |  |  |  |  |  |  | Next Infraction within 56 days Verbal Reminder: Counseling Session  (Step 2 - Positive Discipline Policy) |  | Step 2: Counseling Session | Counseling Session: The supervisor will again address the incident on the job but will later call the individual into the office for a friendly but serious chat.  The supervisor will:  1.  Explain the need for the purpose of the rule(s)   2. Make sure the person understands the explanation   3. Express their confidence that the employee will henceforth decide to abide by them.  They will listen to any reasonable excuse the employee may bring up   4. Ask the employee for a verbal commitment to change. If the supervisor decides that the transgression was unintentional or based on a misunderstanding, they will of course inform the employee that the matter is closed.
 |  |  |  |  |  |  |  |  | Next Infraction within 56 days of Counseling Session: Documentation of Decision from Counseling Session (Step 3 Positive Discipline Policy) |  | Step 3: Documentation of Decision | Documentation of Decision from Conseling Session:   1.  An additional supervisor or HR representative is also present at the discussion    2. The employee’s attention is directed to the possibility that they may dislike the work we have to offer, or they may find the relatively strict industrial discipline distasteful.  In such case, the employee may feel that it would be better to look for some other job or line of work and should seriously think about that over the next few days.
 |  |  |  |  |  |  |  |  | Next Infraction within 56 days from Documentation of Decision: Decision Making Paid Leave  (Step 4 Positive Discipline Policy) - *Consult with HR Before Taking This Step |  | Step 4: Decision Making Paid Leave | Decision-making, paid leave:  Any employee who has received 6+ points in a calendar month, or 10+ points in a calendar quarter is called off the floor into the supervisor’s office, again in the presence of another supervisor or HR representative. There s(he) is directed to go home for the rest of the shift and consider seriously whether they wish to stay and abide by Company policies and procedures, or voluntarily leave.  They are informed that they will get full pay for the time, as a last expression of the company’s hope that they will wish to stay and abide by the rules. They are also reminded that their next attendance infraction in the given time period  may lead - regretfully - to termination.  They are asked to write their decision in a letter to the supervisor, and bring it with them to work the next shift. Please consult with HR before taking this step.
 |  |  |  |  |  |  |  |  | Next Infraction within reasonable time period: Termination  (Step 5 Positive Discipline Policy) - *Consult with HR Before Taking This Step |  | Step 5: Termination | Termination as the Employee's Decision: If another attendance infraction should occur within the given time period , the employee’s services may be terminated, not as punishment, but as a decision by the employee, and to avoid future trouble.  Please consult with HR before taking this step.