Spreadsheet: 62926d1263913906-conditional-count-jan2010-job-attendance-template-matejabg
Sheet: OBRAZAC

 |  |  |  | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |  |  |  |  |  | REDOVAN | SR | RDP | DP | NR | 1.26 | 1.36 | GO | PO | BO | NO | NI | TO
 | COMPANY: |  | Company name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SHEET IS FILLED PROPERY |  |  |  |  |  |  |  |  |  |  | FUND OF WORK HOURS  FOR THIS MONTH |  |  |  |  |  | 176 |  |  |  |  | LEVEL 1 MANAGER SIGNATURE |  |  |  |  |  |  |  |  |  |  |  | LEVEL 2 MANAGER SIGNATURE
 | YEAR: |  | 2010
 | MONTH: |  | JANUARY
0 | DEPARTMENT: |  | name of department
0 | COST CENTER: |  | cost center of department
 |  |  |  |  |  | Legend
 |  | company logo
 |  |  |  | VK | RRD | RRD | RRD | RRD | RRD | VK | VK | RRD | RRD | RRD | RRD | DP | VK | VK | RRD | RRD | RRD | DP | RRD | VK | VK | RRD | RRD | RRD | RRD | RRD | VK | VK | RRD | RRD | FOR SHIFT LEADERS |  |  |  |  | FOR PAYROLL DEPARTMENT  (hours are manualy copied to salary calculation program) |  |  |  |  |  |  |  |  |  |  |  |  | SALES PERFORMANCE | 5
Provera | EMPLOYEE ID | NAME | SHIFT | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | Outstanding balance from previous month | Total regular work hours | Overtime hours | Outstanding balance from current month | Total outstanding balance | Regular work hours for payment | SR | RDP 110% | DP | NR | PR 126% | PR 136% | GO | PO | BO | NO | NI | TO | PERSONAL BONUS % | TOTAL BONUS % | BONUS % | BONUS  CURRENCY | Gross bonus | Employee signature
 |  |  | 1 |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | dp |  |  | 8 | 8 | 8 | dp | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 |  | 160 | 12 | 0 | 0 | 160 |  | 0 | 16 | 0 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 10 | 15 |  |  | 0
 |  |  | 2
 |  |  | 3
 |  | OVERTIME | PR |  |  |  | 4 |  |  |  |  |  | 1 |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 5
0 |  | [NAME] |  | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T | T | T | T
 |  |  | 1 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | go | go | go | go | go |  |  |  |  |  | 120 | 16 | 0 | 0 | 120 |  | 0 | 16 | 42 | 16 | 0 | 40 | 0 | 0 | 0 | 0 | 15 | 5 | 10 |  |  | 0
 |  |  | 2 |  |  |  |  |  |  |  |  | 8 | 4 | 8 | 4 | dp |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 8
 |  |  | 3 |  |  |  |  |  |  |  |  |  | 4 |  | 4 |  |  |  | 8 | 8 | 8 | dp | 8
 |  | OVERTIME | PR |  | 1 |  |  |  | 1 |  |  |  |  | 2 |  |  |  |  |  | 3 |  |  |  |  |  |  |  | 5 | 4
0 |  | [NAME] |  | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T | T | T | T
 |  |  | 1 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | bo | bo | bo | 8 | 8 |  |  |  |  | 32 | 104 | 11 | -32 | 0 | 136 |  | 0 | 16 | 35 | 11 | 0 | 0 | 0 | 24 | 0 | 0 | 17 |  | 0 |  | 150 | 213.9800285306705
 |  |  | 2 |  |  |  |  |  |  |  |  | sd | sd | sd | sd | dp |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 8
 |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 8 | 8 | dp | 8
 |  | OVERTIME | PR |  |  | 3 |  | 2 |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  | 3
0 |  | [NAME] |  | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T | T | T | T
 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 |  | 184 | 12 | 24 | 24 | 160 |  | 0 | 16 | 58 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 20 |  | 0 | 8 |  | 0
 |  |  | 2 |  |  |  |  |  |  |  |  | 8 | 8 | 8 | 8 | dp |  |  | 8 | 8 | 8 | dp | 8 |  |  |  |  | 2 | 4 | 4
 |  |  | 3 |  | 8 | 8 | 8 | 8 | 8 |  |  | 4 | 3 |  |  |  |  |  | 3 | 4
 |  | OVERTIME | PR |  |  | 4 |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  | 1 |  |  |  |  | 1 | 3
0 |  | [NAME] |  | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T | T | T | T
 |  |  | 1 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 8 | 8 | sd | sd |  |  |  |  |  | 144 | 0 | -16 | -16 | 160 |  | 0 | 16 | 32 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 |  | 0 | 5 |  | 0
 |  |  | 2 |  |  |  |  |  |  |  |  | 8 | 8 | 8 | 8 | dp |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 8
 |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 8 | 8 | dp | 8
 |  | OVERTIME | PR
0 |  | [NAME] |  | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T | T | T | T