{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["كشف اسماء الموظفين","دفتر حضور وانصراف","ارشيف الموظفين"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":6,"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":"كشف اسماء الموظفين","index":0,"n_rows":300,"n_cols":6,"rows_kept":300,"cut":false,"hidden":false,"merged":[]}
["تاريخ الاستلام","كود الموظف","اسم الموظف","الوظيفه","الراتب","عدد ساعات العمل"]
[{"$f":"IF(C2<>\"\",IF(A2=\"\",NOW(),A2),\"\")","v":"2019-11-14T03:09:52.350"},1,"محمد","محاسب",3500,8]
["2019-11-14T03:09:52.350",2,"علي","مدخل بيانات",2000,8]
["2019-11-14T03:09:52.350",3,"حسين","مندوب مبيعات",2200,8]
["2019-11-14T03:09:52.350",4,"توفيق","مقاول",3500,8]
["2019-11-14T03:09:52.350",5,"زغلول","عامل",2300,12]
["2019-11-14T03:09:52.350",6,"احمد","شيال",2000,12]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(C66<>\"\",IF(A66=\"\",NOW(),A66),\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(C130<>\"\",IF(A130=\"\",NOW(),A130),\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(C194<>\"\",IF(A194=\"\",NOW(),A194),\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(C258<>\"\",IF(A258=\"\",NOW(),A258),\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]

{"sheet":"دفتر حضور وانصراف","index":1,"n_rows":11,"n_cols":21,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"حضور",{"$f":"IFERROR(LOOKUP(2,1/('ارشيف الموظفين'!$C$2:$C$1000='دفتر حضور وانصراف'!I6),'ارشيف الموظفين'!$L$2:$L$1000)+K9-(K8+M4),\"\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"انصراف"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"غياب"]
[null,null,null,null,null,null,null,"التاريخ",{"$f":"IF(I6=\"\",\"\",NOW())","v":""},"ساعات العمل",{"$f":"IFERROR(\"ساعات\"&\" \"&VLOOKUP(I5,'كشف اسماء الموظفين'!$B$2:$F$200,5,0),\"\")","v":""},"سلف الموظفين",null,null,null,null,null,null,null,"صرف راتب",{"$f":"NOW()","v":"2023-04-25T15:47:00.880"}]
[null,null,null,null,null,null,null,"كود الموظف",null,"الراتب",{"$f":"IFERROR(IF($I$5=\"\",\"\",IF($U$1=\"\",VLOOKUP(I5,'كشف اسماء الموظفين'!$B$2:MF$200,4,0)+K9-(K8+M4),$U$1)),\"\")","v":""},"تاريخ الاستلام",{"$f":"IFERROR(IF(I5=\"\",\"\",INDEX('كشف اسماء الموظفين'!$A$2:$B$1000,MATCH('دفتر حضور وانصراف'!I5,'كشف اسماء الموظفين'!$B$2:$B$1000,0),MATCH('دفتر حضور وانصراف'!L5,'كشف اسماء الموظفين'!$A$1:$F$1,0))),\"\")","v":""}]
[null,null,null,null,null,null,null,"اسم الموظف",{"$f":"IFERROR(VLOOKUP(I5,'كشف اسماء الموظفين'!$B$2:$D$200,2,0),\"\")","v":""},"ساعه الحضور"]
[null,null,null,null,null,null,null,"الوظيفه",{"$f":"IFERROR(VLOOKUP(I5,'كشف اسماء الموظفين'!$B$2:$D$200,3,0),\"\")","v":""},"ساعه الانصراف"]
[null,null,null,null,null,null,null,"حاله الموظف",null,"خصومات"]
[null,null,null,null,null,null,null,"ملاحظات",null,"علاوات"]
[]
[null,null,null,null,"التاريخ","كود الموظف","اسم الموظف","الوظيفه","حاله الموظف","ساعه الحضور","ساعه الانصراف","خصومات","علاوات","سلف الموظفين","تاريخ الاستلام","الراتب بعد الخصم والزياده","ملاحظات"]

{"sheet":"ارشيف الموظفين","index":2,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["التاريخ","كود الموظف","اسم الموظف","الوظيفه","حاله الموظف","ساعه الحضور","ساعه الانصراف","خصومات","علاوات","سلف الموظفين","تاريخ الاستلام","الراتب بعد الخصم والزياده","      ملاحظات"]
["2019-11-16T11:23:08",1,"محمد","محاسب","حضور","08:00:00",null,null,null,null,"2019-11-14T03:09:52",3500,"تم التوقيع"]
["2019-11-16T11:23:45",2,"علي","مدخل بيانات","حضور","08:00:00",null,null,null,null,"2019-11-14T03:09:52",2000,"تم التوقيع"]
["2019-11-16T11:24:41",3,"حسين","مندوب مبيعات","غياب",null,null,73,null,null,"2019-11-14T03:09:52",2127,"بدون اذن"]
["2019-11-16T11:25:52",3,"حسين","مندوب مبيعات",null,null,null,null,null,1000,"2019-11-14T03:09:52",1127,"سحب سلفه من الخزنه"]
["2019-11-16T11:27:30",1,"محمد","محاسب","انصراف",null,"16:00:00",null,null,null,"2019-11-14T03:09:52",3500,"تم التوقيع"]
["2023-04-25T15:43:01",1,"محمد","محاسب",null,null,null,null,null,null,"2019-11-14T03:09:52",3500]
["2023-04-25T15:43:45",1,"محمد","محاسب","غياب",null,null,null,null,null,"2019-11-14T03:09:52",3500]
["2023-04-25T15:43:52",2,"علي","مدخل بيانات","غياب",null,null,null,null,null,"2019-11-14T03:09:52",2000]
["2023-04-25T15:43:58",3,"حسين","مندوب مبيعات","غياب",null,null,null,null,null,"2019-11-14T03:09:52",1127]
["2023-04-25T15:46:04",5,"زغلول","عامل","غياب",null,null,null,null,null,"2019-11-14T03:09:52",2300]
["2023-04-25T15:46:14",6,"احمد","شيال","انصراف",null,null,null,null,null,"2019-11-14T03:09:52",2000]
["2023-04-25T15:46:22",4,"توفيق","مقاول","غياب",null,null,null,null,null,"2019-11-14T03:09:52",3500]