{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data","MARCH","TOOLS"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Data","index":0,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,0,1,2]]}
[]
["سهرات المصنع "]
[null,null,null,null,null,"اسم الموظف"]
["اليوم",{"$f":"TEXT(I4, \"dddd\")","v":"الإثنين"},null,null,null,"طه جمال",null,"التاريخ","2022-03-21"]
[]
["اسم الموظف","التاريخ","القسم","الحضور","بداية ساعة الراحة","نهاية ساعة الراحة","موعد الانصارف","عدد ساعات العمل الاساسية","الاضافي","ملاحظات"]
["طه جمال",{"$f":"IF(A7=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A7),MARCH!$B$7:$B$100))","v":"2022-03-21"},{"$f":"IF(A7=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A7),MARCH!$C$7:$C$100))","v":"مخازن"},{"$f":"IF(A7=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A7),MARCH!$D$7:$D$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A7),MARCH!$D$7:$D$100)))","v":"08:00:00"},{"$f":"IF(A7=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A7),MARCH!$E$7:$E$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A7),MARCH!$E$7:$E$100)))","v":""},{"$f":"IF(A7=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A7),MARCH!$F$7:$F$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A7),MARCH!$F$7:$F$100)))","v":""},{"$f":"IF(A7=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A7),MARCH!$G$7:$G$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A7),MARCH!$G$7:$G$100)))","v":"20:00:00"},{"$f":"IF(A7=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A7),MARCH!$H$7:$H$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A7),MARCH!$H$7:$H$100)))","v":8},{"$f":"IF(A7=\"\",\"\",SUMIF(MARCH!$A$7:$A$114,A7,MARCH!$I$7:$I$114))","v":4}]
["خالد محمد",{"$f":"IF(A8=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A8),MARCH!$B$7:$B$100))","v":"2022-03-21"},{"$f":"IF(A8=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A8),MARCH!$C$7:$C$100))","v":"مخازن"},{"$f":"IF(A8=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A8),MARCH!$D$7:$D$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A8),MARCH!$D$7:$D$100)))","v":"08:00:00"},{"$f":"IF(A8=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A8),MARCH!$E$7:$E$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A8),MARCH!$E$7:$E$100)))","v":""},{"$f":"IF(A8=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A8),MARCH!$F$7:$F$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A8),MARCH!$F$7:$F$100)))","v":""},{"$f":"IF(A8=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A8),MARCH!$G$7:$G$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A8),MARCH!$G$7:$G$100)))","v":"18:00:00"},{"$f":"IF(A8=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A8),MARCH!$H$7:$H$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A8),MARCH!$H$7:$H$100)))","v":8},{"$f":"IF(A8=\"\",\"\",SUMIF(MARCH!$A$7:$A$114,A8,MARCH!$I$7:$I$114))","v":2}]
["عماد احمد",{"$f":"IF(A9=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A9),MARCH!$B$7:$B$100))","v":"2022-03-21"},{"$f":"IF(A9=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A9),MARCH!$C$7:$C$100))","v":"صيانة"},{"$f":"IF(A9=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A9),MARCH!$D$7:$D$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A9),MARCH!$D$7:$D$100)))","v":"08:00:00"},{"$f":"IF(A9=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A9),MARCH!$E$7:$E$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A9),MARCH!$E$7:$E$100)))","v":""},{"$f":"IF(A9=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A9),MARCH!$F$7:$F$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A9),MARCH!$F$7:$F$100)))","v":""},{"$f":"IF(A9=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A9),MARCH!$G$7:$G$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A9),MARCH!$G$7:$G$100)))","v":"20:00:00"},{"$f":"IF(A9=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A9),MARCH!$H$7:$H$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A9),MARCH!$H$7:$H$100)))","v":8},{"$f":"IF(A9=\"\",\"\",SUMIF(MARCH!$A$7:$A$114,A9,MARCH!$I$7:$I$114))","v":4}]
["محمود السيد",{"$f":"IF(A10=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A10),MARCH!$B$7:$B$100))","v":"2022-03-21"},{"$f":"IF(A10=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A10),MARCH!$C$7:$C$100))","v":"خط 1"},{"$f":"IF(A10=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A10),MARCH!$D$7:$D$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A10),MARCH!$D$7:$D$100)))","v":"08:00:00"},{"$f":"IF(A10=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A10),MARCH!$E$7:$E$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A10),MARCH!$E$7:$E$100)))","v":""},{"$f":"IF(A10=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A10),MARCH!$F$7:$F$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A10),MARCH!$F$7:$F$100)))","v":""},{"$f":"IF(A10=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A10),MARCH!$G$7:$G$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A10),MARCH!$G$7:$G$100)))","v":"20:00:00"},{"$f":"IF(A10=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A10),MARCH!$H$7:$H$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A10),MARCH!$H$7:$H$100)))","v":8},{"$f":"IF(A10=\"\",\"\",SUMIF(MARCH!$A$7:$A$114,A10,MARCH!$I$7:$I$114))","v":4}]
["ابراهيم محرم",{"$f":"IF(A11=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A11),MARCH!$B$7:$B$100))","v":"2022-03-21"},{"$f":"IF(A11=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A11),MARCH!$C$7:$C$100))","v":"خط 2"},{"$f":"IF(A11=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A11),MARCH!$D$7:$D$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A11),MARCH!$D$7:$D$100)))","v":"08:00:00"},{"$f":"IF(A11=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A11),MARCH!$E$7:$E$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A11),MARCH!$E$7:$E$100)))","v":""},{"$f":"IF(A11=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A11),MARCH!$F$7:$F$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A11),MARCH!$F$7:$F$100)))","v":""},{"$f":"IF(A11=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A11),MARCH!$G$7:$G$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A11),MARCH!$G$7:$G$100)))","v":"20:00:00"},{"$f":"IF(A11=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A11),MARCH!$H$7:$H$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A11),MARCH!$H$7:$H$100)))","v":8},{"$f":"IF(A11=\"\",\"\",SUMIF(MARCH!$A$7:$A$114,A11,MARCH!$I$7:$I$114))","v":4}]
["محمد صالح",{"$f":"IF(A12=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A12),MARCH!$B$7:$B$100))","v":"2022-03-21"},{"$f":"IF(A12=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A12),MARCH!$C$7:$C$100))","v":"خط 3"},{"$f":"IF(A12=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A12),MARCH!$D$7:$D$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A12),MARCH!$D$7:$D$100)))","v":"08:00:00"},{"$f":"IF(A12=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A12),MARCH!$E$7:$E$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A12),MARCH!$E$7:$E$100)))","v":""},{"$f":"IF(A12=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A12),MARCH!$F$7:$F$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A12),MARCH!$F$7:$F$100)))","v":""},{"$f":"IF(A12=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A12),MARCH!$G$7:$G$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A12),MARCH!$G$7:$G$100)))","v":"20:00:00"},{"$f":"IF(A12=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A12),MARCH!$H$7:$H$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A12),MARCH!$H$7:$H$100)))","v":8},{"$f":"IF(A12=\"\",\"\",SUMIF(MARCH!$A$7:$A$114,A12,MARCH!$I$7:$I$114))","v":4}]
["كريم حسن",{"$f":"IF(A13=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A13),MARCH!$B$7:$B$100))","v":"2022-03-21"},{"$f":"IF(A13=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A13),MARCH!$C$7:$C$100))","v":" خط 4"},{"$f":"IF(A13=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A13),MARCH!$D$7:$D$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A13),MARCH!$D$7:$D$100)))","v":"08:00:00"},{"$f":"IF(A13=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A13),MARCH!$E$7:$E$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A13),MARCH!$E$7:$E$100)))","v":""},{"$f":"IF(A13=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A13),MARCH!$F$7:$F$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A13),MARCH!$F$7:$F$100)))","v":""},{"$f":"IF(A13=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A13),MARCH!$G$7:$G$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A13),MARCH!$G$7:$G$100)))","v":"20:00:00"},{"$f":"IF(A13=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A13),MARCH!$H$7:$H$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A13),MARCH!$H$7:$H$100)))","v":8},{"$f":"IF(A13=\"\",\"\",SUMIF(MARCH!$A$7:$A$114,A13,MARCH!$I$7:$I$114))","v":4}]
["هشام عيد",{"$f":"IF(A14=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A14),MARCH!$B$7:$B$100))","v":"2022-03-21"},{"$f":"IF(A14=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A14),MARCH!$C$7:$C$100))","v":"الورشة"},{"$f":"IF(A14=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A14),MARCH!$D$7:$D$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A14),MARCH!$D$7:$D$100)))","v":"08:00:00"},{"$f":"IF(A14=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A14),MARCH!$E$7:$E$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A14),MARCH!$E$7:$E$100)))","v":""},{"$f":"IF(A14=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A14),MARCH!$F$7:$F$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A14),MARCH!$F$7:$F$100)))","v":""},{"$f":"IF(A14=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A14),MARCH!$G$7:$G$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A14),MARCH!$G$7:$G$100)))","v":"20:00:00"},{"$f":"IF(A14=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A14),MARCH!$H$7:$H$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A14),MARCH!$H$7:$H$100)))","v":8},{"$f":"IF(A14=\"\",\"\",SUMIF(MARCH!$A$7:$A$114,A14,MARCH!$I$7:$I$114))","v":4}]
["هشام طارق",{"$f":"IF(A15=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A15),MARCH!$B$7:$B$100))","v":"2022-03-21"},{"$f":"IF(A15=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A15),MARCH!$C$7:$C$100))","v":"كهرباء"},{"$f":"IF(A15=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A15),MARCH!$D$7:$D$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A15),MARCH!$D$7:$D$100)))","v":"08:00:00"},{"$f":"IF(A15=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A15),MARCH!$E$7:$E$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A15),MARCH!$E$7:$E$100)))","v":""},{"$f":"IF(A15=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A15),MARCH!$F$7:$F$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A15),MARCH!$F$7:$F$100)))","v":""},{"$f":"IF(A15=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A15),MARCH!$G$7:$G$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A15),MARCH!$G$7:$G$100)))","v":"20:00:00"},{"$f":"IF(A15=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A15),MARCH!$H$7:$H$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A15),MARCH!$H$7:$H$100)))","v":8},{"$f":"IF(A15=\"\",\"\",SUMIF(MARCH!$A$7:$A$114,A15,MARCH!$I$7:$I$114))","v":4}]
["هشام حسن",{"$f":"IF(A16=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A16),MARCH!$B$7:$B$100))","v":"2022-03-21"},{"$f":"IF(A16=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A16),MARCH!$C$7:$C$100))","v":"كلارك"},{"$f":"IF(A16=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A16),MARCH!$D$7:$D$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A16),MARCH!$D$7:$D$100)))","v":"08:00:00"},{"$f":"IF(A16=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A16),MARCH!$E$7:$E$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A16),MARCH!$E$7:$E$100)))","v":""},{"$f":"IF(A16=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A16),MARCH!$F$7:$F$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A16),MARCH!$F$7:$F$100)))","v":""},{"$f":"IF(A16=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A16),MARCH!$G$7:$G$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A16),MARCH!$G$7:$G$100)))","v":"20:00:00"},{"$f":"IF(A16=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A16),MARCH!$H$7:$H$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A16),MARCH!$H$7:$H$100)))","v":8},{"$f":"IF(A16=\"\",\"\",SUMIF(MARCH!$A$7:$A$114,A16,MARCH!$I$7:$I$114))","v":4}]
["عيد سلطان",{"$f":"IF(A17=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A17),MARCH!$B$7:$B$100))","v":"2022-03-21"},{"$f":"IF(A17=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A17),MARCH!$C$7:$C$100))","v":"كلارك"},{"$f":"IF(A17=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A17),MARCH!$D$7:$D$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A17),MARCH!$D$7:$D$100)))","v":"08:00:00"},{"$f":"IF(A17=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A17),MARCH!$E$7:$E$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A17),MARCH!$E$7:$E$100)))","v":""},{"$f":"IF(A17=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A17),MARCH!$F$7:$F$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A17),MARCH!$F$7:$F$100)))","v":""},{"$f":"IF(A17=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A17),MARCH!$G$7:$G$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A17),MARCH!$G$7:$G$100)))","v":"20:00:00"},{"$f":"IF(A17=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A17),MARCH!$H$7:$H$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A17),MARCH!$H$7:$H$100)))","v":8},{"$f":"IF(A17=\"\",\"\",SUMIF(MARCH!$A$7:$A$114,A17,MARCH!$I$7:$I$114))","v":4}]
["سيد عبد الحميد ",{"$f":"IF(A18=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A18),MARCH!$B$7:$B$100))","v":"2022-03-21"},{"$f":"IF(A18=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A18),MARCH!$C$7:$C$100))","v":"كلارك"},{"$f":"IF(A18=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A18),MARCH!$D$7:$D$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A18),MARCH!$D$7:$D$100)))","v":"08:00:00"},{"$f":"IF(A18=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A18),MARCH!$E$7:$E$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A18),MARCH!$E$7:$E$100)))","v":""},{"$f":"IF(A18=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A18),MARCH!$F$7:$F$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A18),MARCH!$F$7:$F$100)))","v":""},{"$f":"IF(A18=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A18),MARCH!$G$7:$G$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A18),MARCH!$G$7:$G$100)))","v":"20:00:00"},{"$f":"IF(A18=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A18),MARCH!$H$7:$H$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A18),MARCH!$H$7:$H$100)))","v":8},{"$f":"IF(A18=\"\",\"\",SUMIF(MARCH!$A$7:$A$114,A18,MARCH!$I$7:$I$114))","v":4}]
["اشرف رضا",{"$f":"IF(A19=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A19),MARCH!$B$7:$B$100))","v":"2022-03-21"},{"$f":"IF(A19=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A19),MARCH!$C$7:$C$100))","v":"مخازن "},{"$f":"IF(A19=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A19),MARCH!$D$7:$D$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A19),MARCH!$D$7:$D$100)))","v":"08:00:00"},{"$f":"IF(A19=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A19),MARCH!$E$7:$E$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A19),MARCH!$E$7:$E$100)))","v":""},{"$f":"IF(A19=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A19),MARCH!$F$7:$F$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A19),MARCH!$F$7:$F$100)))","v":""},{"$f":"IF(A19=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A19),MARCH!$G$7:$G$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A19),MARCH!$G$7:$G$100)))","v":"20:00:00"},{"$f":"IF(A19=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A19),MARCH!$H$7:$H$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A19),MARCH!$H$7:$H$100)))","v":8},{"$f":"IF(A19=\"\",\"\",SUMIF(MARCH!$A$7:$A$114,A19,MARCH!$I$7:$I$114))","v":4}]
["صابر محمد ",{"$f":"IF(A20=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A20),MARCH!$B$7:$B$100))","v":"2022-03-21"},{"$f":"IF(A20=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A20),MARCH!$C$7:$C$100))","v":"خط 2"},{"$f":"IF(A20=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A20),MARCH!$D$7:$D$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A20),MARCH!$D$7:$D$100)))","v":"08:00:00"},{"$f":"IF(A20=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A20),MARCH!$E$7:$E$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A20),MARCH!$E$7:$E$100)))","v":""},{"$f":"IF(A20=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A20),MARCH!$F$7:$F$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A20),MARCH!$F$7:$F$100)))","v":""},{"$f":"IF(A20=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A20),MARCH!$G$7:$G$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A20),MARCH!$G$7:$G$100)))","v":"20:00:00"},{"$f":"IF(A20=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A20),MARCH!$H$7:$H$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A20),MARCH!$H$7:$H$100)))","v":8},{"$f":"IF(A20=\"\",\"\",SUMIF(MARCH!$A$7:$A$114,A20,MARCH!$I$7:$I$114))","v":4}]
["محمد سلطان",{"$f":"IF(A21=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A21),MARCH!$B$7:$B$100))","v":"2022-03-21"},{"$f":"IF(A21=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A21),MARCH!$C$7:$C$100))","v":"مخازن"},{"$f":"IF(A21=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A21),MARCH!$D$7:$D$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A21),MARCH!$D$7:$D$100)))","v":"08:00:00"},{"$f":"IF(A21=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A21),MARCH!$E$7:$E$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A21),MARCH!$E$7:$E$100)))","v":""},{"$f":"IF(A21=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A21),MARCH!$F$7:$F$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A21),MARCH!$F$7:$F$100)))","v":""},{"$f":"IF(A21=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A21),MARCH!$G$7:$G$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A21),MARCH!$G$7:$G$100)))","v":"20:00:00"},{"$f":"IF(A21=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A21),MARCH!$H$7:$H$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A21),MARCH!$H$7:$H$100)))","v":8},{"$f":"IF(A21=\"\",\"\",SUMIF(MARCH!$A$7:$A$114,A21,MARCH!$I$7:$I$114))","v":4}]
["محمد عبد الفتاح",{"$f":"IF(A22=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A22),MARCH!$B$7:$B$100))","v":"2022-03-25"},{"$f":"IF(A22=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A22),MARCH!$C$7:$C$100))","v":"مخازن"},{"$f":"IF(A22=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A22),MARCH!$D$7:$D$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A22),MARCH!$D$7:$D$100)))","v":"08:00:00"},{"$f":"IF(A22=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A22),MARCH!$E$7:$E$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A22),MARCH!$E$7:$E$100)))","v":""},{"$f":"IF(A22=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A22),MARCH!$F$7:$F$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A22),MARCH!$F$7:$F$100)))","v":""},{"$f":"IF(A22=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A22),MARCH!$G$7:$G$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A22),MARCH!$G$7:$G$100)))","v":"20:00:00"},{"$f":"IF(A22=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A22),MARCH!$H$7:$H$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A22),MARCH!$H$7:$H$100)))","v":8},{"$f":"IF(A22=\"\",\"\",SUMIF(MARCH!$A$7:$A$114,A22,MARCH!$I$7:$I$114))","v":16},{"$f":"IF(MARCH!J22=\"\",\"\",MARCH!J22)","v":""}]
["محمد غزالي",{"$f":"IF(A23=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A23),MARCH!$B$7:$B$100))","v":"2022-03-27"},{"$f":"IF(A23=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A23),MARCH!$C$7:$C$100))","v":"مخازن"},{"$f":"IF(A23=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A23),MARCH!$D$7:$D$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A23),MARCH!$D$7:$D$100)))","v":"08:00:00"},{"$f":"IF(A23=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A23),MARCH!$E$7:$E$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A23),MARCH!$E$7:$E$100)))","v":""},{"$f":"IF(A23=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A23),MARCH!$F$7:$F$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A23),MARCH!$F$7:$F$100)))","v":""},{"$f":"IF(A23=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A23),MARCH!$G$7:$G$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A23),MARCH!$G$7:$G$100)))","v":"20:00:00"},{"$f":"IF(A23=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A23),MARCH!$H$7:$H$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A23),MARCH!$H$7:$H$100)))","v":8},{"$f":"IF(A23=\"\",\"\",SUMIF(MARCH!$A$7:$A$114,A23,MARCH!$I$7:$I$114))","v":8},{"$f":"IF(MARCH!J23=\"\",\"\",MARCH!J23)","v":""}]
[null,{"$f":"IF(A24=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A24),MARCH!$B$7:$B$100))","v":""},{"$f":"IF(A24=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A24),MARCH!$C$7:$C$100))","v":""},{"$f":"IF(A24=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A24),MARCH!$D$7:$D$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A24),MARCH!$D$7:$D$100)))","v":""},{"$f":"IF(A24=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A24),MARCH!$E$7:$E$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A24),MARCH!$E$7:$E$100)))","v":""},{"$f":"IF(A24=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A24),MARCH!$F$7:$F$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A24),MARCH!$F$7:$F$100)))","v":""},{"$f":"IF(A24=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A24),MARCH!$G$7:$G$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A24),MARCH!$G$7:$G$100)))","v":""},{"$f":"IF(A24=\"\",\"\",IF(LOOKUP(2,1/(MARCH!$A$7:$A$100=A24),MARCH!$H$7:$H$100)=\"\",\"\",LOOKUP(2,1/(MARCH!$A$7:$A$100=A24),MARCH!$H$7:$H$100)))","v":""},{"$f":"IF(A24=\"\",\"\",SUMIF(MARCH!$A$7:$A$114,A24,MARCH!$I$7:$I$114))","v":""},{"$f":"IF(MARCH!J24=\"\",\"\",MARCH!J24)","v":""}]

{"sheet":"MARCH","index":1,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,0,1,2]]}
[]
["سهرات المصنع "]
[null,null,null,null,"اسم الموظف"]
[null,"اليوم",{"$f":"TEXT(I4, \"dddd\")","v":"Monday"},null,null,null,null,"التاريخ","2022-03-21"]
[]
["اسم الموظف","التاريخ","القسم","الحضور","بداية ساعة الراحة","نهاية ساعة الراحة","موعد الانصارف","عدد ساعات العمل الاساسية","الاضافي","ملاحظات"]
["طه جمال","2022-03-21","مخازن","08:00:00",null,null,"20:00:00",8,{"$f":"IF(((E7-D7)+(G7-F7))*24>8, ((E7-D7)+(G7-F7))*24-8,0)","v":4}]
["خالد محمد","2022-03-21","مخازن","08:00:00",null,null,"18:00:00",8,{"$f":"IF(((E8-D8)+(G8-F8))*24>8, ((E8-D8)+(G8-F8))*24-8,0)","v":2}]
["عماد احمد","2022-03-21","صيانة","08:00:00",null,null,"20:00:00",8,4]
["محمود السيد","2022-03-21","خط 1","08:00:00",null,null,"20:00:00",8,4]
["ابراهيم محرم","2022-03-21","خط 2","08:00:00",null,null,"20:00:00",8,4]
["محمد صالح","2022-03-21","خط 3","08:00:00",null,null,"20:00:00",8,4]
["كريم حسن","2022-03-21"," خط 4","08:00:00",null,null,"20:00:00",8,4]
["هشام عيد","2022-03-21","الورشة","08:00:00",null,null,"20:00:00",8,4]
["هشام طارق","2022-03-21","كهرباء","08:00:00",null,null,"20:00:00",8,4]
["هشام حسن","2022-03-21","كلارك","08:00:00",null,null,"20:00:00",8,4]
["عيد سلطان","2022-03-21","كلارك","08:00:00",null,null,"20:00:00",8,4]
["سيد عبد الحميد ","2022-03-21","كلارك","08:00:00",null,null,"20:00:00",8,4]
["اشرف رضا","2022-03-21","مخازن ","08:00:00",null,null,"20:00:00",8,4]
["صابر محمد ","2022-03-21","خط 2","08:00:00",null,null,"20:00:00",8,4]
["محمد سلطان","2022-03-21","مخازن","08:00:00",null,null,"20:00:00",8,4]
["محمد عبد الفتاح","2022-03-22","سائقين","08:00:00",null,null,"20:00:00",8,4]
["محمد عبد الفتاح","2022-03-23","سائقين","08:00:00",null,null,"20:00:00",8,4]
["محمد عبد الفتاح","2022-03-24","سائقين","08:00:00",null,null,"20:00:00",8,4]
["محمد عبد الفتاح","2022-03-25","مخازن","08:00:00",null,null,"20:00:00",8,4]
["محمد غزالي","2022-03-26","مخازن","08:00:00",null,null,"20:00:00",8,4]
["محمد غزالي","2022-03-27","مخازن","08:00:00",null,null,"20:00:00",8,4]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]

{"sheet":"TOOLS","index":2,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,"حضور","انصراف",null,"خط 1"]
[null,null,null,"08:00:00","17:00:00",null,"خط 2"]
[null,null,null,null,"18:00:00",null,"خط 3"]
[null,null,null,null,"19:00:00",null,"خط 4"]
[null,null,null,null,"20:00:00",null,"مخازن"]
[null,null,null,null,"21:00:00",null,"صيانة "]
[null,null,null,null,null,null,"كلارك"]
[null,null,null,null,null,null,"الورشة"]
[null,null,null,null,null,null,"سائقين"]