{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Sheet1","index":0,"n_rows":58,"n_cols":36,"rows_kept":58,"cut":false,"hidden":false,"merged":[[5,5,5,7],[57,0,57,16],[57,19,57,20],[5,32,6,32],[5,8,5,10],[5,11,5,12],[5,13,6,13],[5,14,6,14],[5,15,5,18],[5,19,5,22],[5,0,6,0],[5,1,6,1],[5,2,6,2],[5,3,6,3],[5,4,6,4],[7,35,11,35],[5,33,6,33],[5,23,5,24],[5,25,6,25],[5,26,6,26],[5,27,6,27],[5,28,6,28],[5,29,6,29],[5,30,6,30],[5,31,6,31]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.5,"   ( مثال : 1.25/ 1.50/ 2.00 )"]
[null,null,null,"Sunday"]
[]
["م","رقم الموظف","أسم الموظف","حالة الدوام","نوع الدوام","الدوام الرسمي الأول",null,null,"الدوام الرسمي الثاني",null,null,"إجمالي ساعات العمل",null,"أجر اليوم","معدل أجر الدقيقة","الدوام الأول",null,null,null,"الدوام الثاني",null,null,null,"العمل الفعلي",null,"إجمالي التأخير/الخروج المبكر (دقيقة)","الوقت الإضافي (دقيقة)","خصم التأخير","قيمة التأخير ","إحتساب الإضافي","قيمة الإضافي","صافي أجر اليوم","أيام العمل","أيام الغياب"]
[null,null,null,null,null,"من","إلي","تأخير مسموح (دقيقة)","من","إلي","تأخير مسموح (دقيقة)","دقيقة","ساعة",null,null,"دخول","خروج","دخول متأخر (دقيقة)","خروج مبكر (دقيقة)","دخول","خروج","دخول متأخر (دقيقة)","خروج مبكر (دقيقة)","دقيقة","ساعة"]
[1,1,null,"Day OFF","دوامين","09:00:00","14:00:00",5,"17:00:00","20:00:00",5,0,8,45,9.375E-2,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0,null,"أريد تعطيل كود جلب الوقت الحالى بدبل كليك فى العمودين رقم 20 و 21 \nأى العمودين T & U\nوذلك اذا كان نوع الدوام الموجود فى العمود E \"دوام واحد\"\n"]
[2,2,null,"Work Attended","دوام واحد","10:00:00","18:00:00",10,null,null,0,0,8,36.666666666666664,7.6388888888888881E-2,"17:14:00","17:14:00",424,46,"11:36:00","11:36:00",0,0,0,0,470,0,"نعم",35.902777777777771,"لا",0,0,1,0]
[3,3,null,"Work Attended","دوامين","10:00:00","16:00:00",5,"18:00:00","20:00:00",5,0,8,30,6.25E-2,"11:29:00","11:29:00",84,271,null,null,0,0,0,0,355,0,"نعم",22.1875,"لا",0,0,1,0]
[4,4,null,"Work Attended","دوامين","10:00:00","13:00:00",5,"16:00:00","21:00:00",5,0,8,36.666666666666664,7.6388888888888881E-2,"10:00:00","12:00:00",0,60,"16:30:00","19:00:00",25,120,30,4,205,0,"نعم",15.659722222222221,"لا",0,21.006944444444443,1,0]
[5,5,null,"Day OFF","دوام واحد","09:00:00","17:00:00",10,null,null,0,0,8,43.333333333333336,9.0277777777777776E-2,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[6,6,null,"Day OFF","دوامين","10:00:00","15:00:00",5,"17:00:00","20:00:00",5,0,8,45,9.375E-2,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[7,7,null,"Day OFF","دوامين","09:00:00","13:00:00",5,"15:00:00","19:00:00",5,0,8,36.666666666666664,7.6388888888888881E-2,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[8,8,null,"Day OFF","دوامين","10:00:00","14:00:00",5,"16:00:00","20:00:00",5,0,8,33.333333333333336,6.9444444444444448E-2,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[9,9,null,"Day OFF","دوامين","10:00:00","15:00:00",5,"18:00:00","21:00:00",5,0,8,36.666666666666664,7.6388888888888881E-2,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[10,10,null,"Day OFF","دوامين","10:00:00","15:00:00",5,"18:00:00","21:00:00",5,0,8,41.666666666666664,8.6805555555555552E-2,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[11,11,null,"Absence/Vacation","دوامين","10:00:00","16:00:00",5,"19:00:00","21:00:00",5,0,8,33.333333333333336,6.9444444444444448E-2,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,1]
[12,12,null,"Absence/Vacation","دوامين","10:00:00","15:00:00",5,"18:00:00","21:00:00",5,0,8,40,8.3333333333333329E-2,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,1]
[13,13,null,"Day OFF","دوامين","10:00:00","15:00:00",5,"18:00:00","21:00:00",5,0,8,36.666666666666664,7.6388888888888881E-2,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[14,14,null,"Absence/Vacation","دوامين","10:00:00","14:00:00",5,"17:00:00","21:00:00",5,0,8,30,6.25E-2,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,1]
[15,15,null,"Absence/Vacation","دوامين","10:00:00","13:00:00",5,"16:00:00","21:00:00",5,0,8,28.333333333333332,5.9027777777777776E-2,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,1]
[16,16,null,"Absence/Vacation","دوامين","10:00:00","14:00:00",5,"17:00:00","21:00:00",5,0,8,27.666666666666668,5.7638888888888892E-2,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,1]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[34,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[36,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[37,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[38,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[39,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[40,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[42,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[43,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[44,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[45,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[46,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[47,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[48,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[49,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
[50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,0,0,0,0,"نعم",0,"لا",0,0,0,0]
["إجماليات",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,508,377,null,null,25,120,30,4,1030,0,null,73.75,null,0,21.006944444444443,0,0]