Spreadsheet: 76382d1276882268-make-relation-between-two-spreedsheets-att-1
Sheet: May&Jun Effects 

Effects of TECHNICALS
No. | Name | Titel | Absent Day | Penalty (day) | Over Times |  |  | 16 |  | 17 |  | 18 |  | 19 |  | 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 |  |  | Vacation Worked
 |  |  |  |  | Daylight Hours | Night Hours | Vactions Hours | SUN |  | MON |  | TUE |  | WED |  | THU |  | FRI |  | SAT |  | SUN |  | MON |  | TUE |  | WED |  | THU |  | FRI |  | SAT |  | SUN |  | MON |  | TUE |  | WED |  | THU |  | FRI |  | SAT |  | SUN |  | MON |  | TUE |  | WED |  | THU |  | FRI |  | SAT |  | SUN |  | MON |  | TUE
 |  |  |  |  |  |  |  | D | N | D | N | D | N | D | N | D | N | Vactation |  | Vactation |  | D | N | D | N | D | N | D | N | D | N | Vactation |  | Vactation |  | D | N | D | N | D | N | D | N | D | N | Vactation |  | Vactation |  | D | N | D | N | D | N | D | N | D | N | Vactation |  | Vactation |  | D | N | D | N | D | N
1 | [NAME] | Cutting Operator |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1:00:00 | 2:00:00
2 | [NAME] | Cutting Operator |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8:00:00
3 | [NAME] | Cutting Operator
4 | [NAME] Moemen | Grinder
5 | Ayman [NAME] | Grinder |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8:00:00
6 | Ayman [NAME] | Grinder |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8:00:00
7 | [NAME] | Grinder
8 | [NAME] | Rolling Operator
9 | Sobhy [NAME] | Rolling Operator |  |  |  |  |  |  |  |  |  | 1:00:00 | 3:00:00 |  |  |  |  |  |  | 8:00:00
10 | Maged [NAME] | SAW Operator |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8:00:00 |  |  |  |  | 3:00:00
11 | [NAME] Mohamed | SAW Operator |  |  |  |  |  |  |  | 1:00:00 | 2:00:00 |  |  | 1:00:00 | 2:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3:00:00
12 | Raafat Salem El-Sayed | SAW Operator |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1:00:00 | 2:00:00 | 1:00:00 | 2:00:00 | 1:00:00 | 2:00:00 |  |  |  |  |  |  |  |  | 1:00:00 | 2:00:00
13 | [NAME] | SAW Operator |  |  |  |  |  |  |  |  |  | 1:00:00 | 3:00:00 |  |  |  |  |  |  | 8:00:00 |  |  |  |  |  | 1:00:00 | 2:00:00
14 | [NAME] Hasham | SAW Operator |  |  |  |  |  |  |  |  |  | 1:00:00 | 3:00:00 |  |  | 1:00:00 | 10:00:00 |  |  |  |  |  |  |  |  | 1:00:00 | 2:00:00
15 | [NAME] | SAW Operator
16 | [NAME] | MAG Welder
17 | [NAME] | MAG Welder
18 | [NAME] | MAG Welder Door Frame
19 | [NAME] | MAG Welder Door Frame
20 | [NAME] | MAG Welder Brackets
21 | [NAME] | MAG Welder Brackets |  |  |  |  |  |  |  |  |  | 1:00:00 | 3:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 1:00:00 | 2:00:00 |  |  |  |  |  |  | 8:00:00
22 | [NAME] | MAG Welder Brackets
23 | El-Sayed Ezzat El-Sayed | Assembly |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8:00:00 |  | 1:00:00 | 2:00:00 | 1:00:00 | 2:00:00
24 | [NAME] | Assembly |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1:00:00 | 2:00:00 |  |  |  |  |  |  |  |  |  | 3:00:00
25 | [NAME] | Assembly
26 | [NAME] | Assembly |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1:00:00 | 2:00:00 |  |  |  |  | 8:00:00 |  | 1:00:00 | 2:00:00 | 1:00:00 | 2:00:00
27 | [NAME] | Assembly |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8:00:00
28 | [NAME] | Assembly
29 | [NAME] | Assembly
30 | Hatem Ibrahim | Brackets Fitter |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8:00:00
31 | Hamouda [NAME] | Brackets Fitter |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1:00:00 | 2:00:00
32 | Samy Nasif Hafez | Brackets Fitter |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1:00:00 | 2:00:00 |  |  |  |  |  |  | 8:00:00
33 | [NAME] | Brackets Fitter
34 | [NAME] [NAME] | Brackets Fitter |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1:00:00 | 2:00:00
35 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3:00:00
36 | [NAME] | [NAME]
37 | Tarek [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8:00:00
38 | Sherif [NAME] Khodary | blaster |  |  |  |  |  |  |  | 1:00:00 | 2:00:00
39 | Mehany [NAME] Mehany | Painter |  |  |  |  |  |  |  | 1:00:00 | 2:00:00
40 | [NAME] | H S E supervisor
41 | [NAME] | Senior Fitters |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8:00:00
42 | [NAME] | Fitting Supervisor |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1:00:00 | 2:00:00 |  |  |  |  |  |  |  |  | 1:00:00 | 2:00:00
43 | [NAME] | Welding Supervisor
44 | [NAME] | Warehouse keepers
45 | [NAME] | Warehouse keepers
46 | [NAME] Farouk | Warehouse keepers
47 | [NAME] | Forklift Drives-10 Ton
48 | [NAME] | Forklift Drives-10 [NAME]
49 | Hany [NAME] | Forklift Drives-5 Ton
50 | [NAME] | Forklift Drives-5 Ton |  |  |  |  |  |  |  | 1:00:00 | 2:00:00
51 | [NAME] | Crane Operator
52 | [NAME] | Crane Operator For Stronge Area
53 | [NAME] | Mechanic (Maintenance) |  |  |  |  |  |  |  |  |  |  |  | 1:00:00 | 2:00:00 | 1:00:00 | 10:00:00 |  |  | 8:00:00 |  | 1:00:00 | 2:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1:00:00 | 5:00:00
54 | [NAME] | Mechanic (Maintenance)
55 | [NAME] | Tech Gases (Maintenance) |  |  |  |  |  |  |  |  |  |  |  | 9:00:00 |  |  |  |  |  |  |  | 1:00:00 | 2:00:00 |  |  | 1:00:00 | 2:00:00 | 1:00:00 | 2:00:00 |  |  |  |  |  |  | 1:00:00 | 2:00:00 | 1:00:00 | 5:00:00
56 | [NAME] | Electration (Maintenance) |  |  |  |  |  |  |  |  |  |  |  | 1:00:00 | 2:00:00 | 1:00:00 | 10:00:00 |  |  |  |  |  |  |  |  | 9:00:00
57 | [NAME] | Electration (Maintenance) |  |  |  |  |  |  |  |  |  |  |  | 9:00:00 |  |  |  |  |  | 8:00:00 |  |  |  |  |  |  |  |  | 9:00:00
58 | [NAME] | Inspector  NDT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5:30:00
59 | Zaki [NAME] | Inspector (Raw Material ) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8:00:00
60 | [NAME] | Trainee
61 | [NAME] | Trainee
62 | [NAME] | Trainee
63 | [NAME] [NAME] | Trainee
64 | [NAME] | Trainee
65 | [NAME] Mohamed | [NAME] |  |  |  |  |  |  |  |  |  | 1:00:00 | 2:00:00
66
67
68
69
70
 | V: Vacation   S: Sick   Y: Army    A: Absant M: Massion