{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","نموذج حصر غياب الموظفين"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":200,"n_cols":5,"rows_kept":200,"cut":false,"hidden":true,"merged":[]}
[null,null,"الأسماء المشتركة","الأسماء الموجود في العمود A وغير موجود في العمود B","الأسماء الموجود في العمود B وغير موجود في العمود A"]
["محمد ","احمد",{"$f":"IFERROR(INDEX($A$2:$A$200,_xlfn.AGGREGATE(15,6,ROW($A$2:$A$200)-1/ISNUMBER(MATCH($A$2:$A$200,$B$2:$B$200,0)),ROW(A1))),\"\")","v":"خالد"},{"$f":"IFERROR(INDEX($A$2:$A$200,_xlfn.AGGREGATE(15,6,ROW($A$2:$A$200)-1/ISNA(MATCH($A$2:$A$200,$B$2:$B$200,0)),ROW(A1))),\"\")","v":"محمد "},{"$f":"IFERROR(INDEX($B$2:$B$200,_xlfn.AGGREGATE(15,6,ROW($B$2:$B$200)-1/ISNA(MATCH($B$2:$B$200,$A$2:$A$200,0)),ROW(A1))),\"\")","v":"احمد"}]
["خالد","خالد",{"$f":"IFERROR(INDEX($A$2:$A$200,_xlfn.AGGREGATE(15,6,ROW($A$2:$A$200)-1/ISNUMBER(MATCH($A$2:$A$200,$B$2:$B$200,0)),ROW(A2))),\"\")","v":""},{"$f":"IFERROR(INDEX($A$2:$A$200,_xlfn.AGGREGATE(15,6,ROW($A$2:$A$200)-1/ISNA(MATCH($A$2:$A$200,$B$2:$B$200,0)),ROW(A2))),\"\")","v":"احمد "},{"$f":"IFERROR(INDEX($B$2:$B$200,_xlfn.AGGREGATE(15,6,ROW($B$2:$B$200)-1/ISNA(MATCH($B$2:$B$200,$A$2:$A$200,0)),ROW(A2))),\"\")","v":"محمد"}]
["احمد ","محمد","",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,{"$f":"IFERROR(INDEX($A$2:$A$200,_xlfn.AGGREGATE(15,6,ROW($A$2:$A$200)-1/ISNUMBER(MATCH($A$2:$A$200,$B$2:$B$200,0)),ROW(A66))),\"\")","v":""},{"$f":"IFERROR(INDEX($A$2:$A$200,_xlfn.AGGREGATE(15,6,ROW($A$2:$A$200)-1/ISNA(MATCH($A$2:$A$200,$B$2:$B$200,0)),ROW(A66))),\"\")","v":0},{"$f":"IFERROR(INDEX($B$2:$B$200,_xlfn.AGGREGATE(15,6,ROW($B$2:$B$200)-1/ISNA(MATCH($B$2:$B$200,$A$2:$A$200,0)),ROW(A66))),\"\")","v":0}]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,{"$f":"IFERROR(INDEX($A$2:$A$200,_xlfn.AGGREGATE(15,6,ROW($A$2:$A$200)-1/ISNUMBER(MATCH($A$2:$A$200,$B$2:$B$200,0)),ROW(A130))),\"\")","v":""},{"$f":"IFERROR(INDEX($A$2:$A$200,_xlfn.AGGREGATE(15,6,ROW($A$2:$A$200)-1/ISNA(MATCH($A$2:$A$200,$B$2:$B$200,0)),ROW(A130))),\"\")","v":0},{"$f":"IFERROR(INDEX($B$2:$B$200,_xlfn.AGGREGATE(15,6,ROW($B$2:$B$200)-1/ISNA(MATCH($B$2:$B$200,$A$2:$A$200,0)),ROW(A130))),\"\")","v":0}]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,{"$f":"IFERROR(INDEX($A$2:$A$200,_xlfn.AGGREGATE(15,6,ROW($A$2:$A$200)-1/ISNUMBER(MATCH($A$2:$A$200,$B$2:$B$200,0)),ROW(A194))),\"\")","v":""},{"$f":"IFERROR(INDEX($A$2:$A$200,_xlfn.AGGREGATE(15,6,ROW($A$2:$A$200)-1/ISNA(MATCH($A$2:$A$200,$B$2:$B$200,0)),ROW(A194))),\"\")","v":0},{"$f":"IFERROR(INDEX($B$2:$B$200,_xlfn.AGGREGATE(15,6,ROW($B$2:$B$200)-1/ISNA(MATCH($B$2:$B$200,$A$2:$A$200,0)),ROW(A194))),\"\")","v":0}]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"",0,0]
[null,null,"","",""]

{"sheet":"نموذج حصر غياب الموظفين","index":1,"n_rows":71,"n_cols":5,"rows_kept":71,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4],[4,3,4,4],[5,3,5,4]]}
["مدرسة "]
["حضور و غياب المعلمين "]
[null,"اليوم  : ",{"$f":"TODAY()","v":"2021-12-07"}]
[null,"التاريخ : ",{"$f":"TODAY()","v":"2021-12-07"}]
[null,"عددالموظفين","عدد الحضور ","عدد الغياب "]
[null,{"$f":"COUNTA(B9:B68)","v":6},{"$f":"COUNTA(C9:C68)","v":3},{"$f":"B6-C6","v":3},{"$f":"COUNTA(E9:E68)","v":4}]
[]
["ت","اسماء الموظفين","الحضور ","ت","الغياب "]
[1,"ابراهيم  احمد","احمد ابراهيم ",1,"ابراهيم  احمد"]
[2,"ابراهيم ربحي ","احمد عصام نمر ",{"$f":"IF(E10<>\"\",D9+1,\"\")","v":2},"ابراهيم ربحي "]
[3,"احمد ابراهيم ","انس عوض",{"$f":"IF(E11<>\"\",D10+1,\"\")","v":3},"امين محمد حمدان النجار"]
[4,"احمد عصام نمر ",null,4,"انس رضوان "]
[5,"امين محمد حمدان النجار",null,""]
[6,"انس رضوان ",null,""]
[7,null,null,""]
[8,null,null,""]
[9,null,null,""]
[10,null,null,""]
[11,null,null,""]
[12,null,null,""]
[13,null,null,""]
[14,null,null,""]
[15,null,null,""]
[16,null,null,""]
[17,null,null,""]
[18,null,null,""]
[19,null,null,""]
[20,null,null,""]
[21,null,null,""]
[22,null,null,""]
[23,null,null,""]
[24,null,null,""]
[25,null,null,""]
[26,null,null,""]
[27,null,null,""]
[28,null,null,""]
[29,null,null,""]
[30,null,null,""]
[31,null,null,""]
[32,null,null,""]
[33,null,null,""]
[34,null,null,""]
[35,null,null,""]
[36,null,null,""]
[37,null,null,""]
[38,null,null,""]
[39,null,null,""]
[40,null,null,""]
[41,null,null,""]
[42,null,null,""]
[43,null,null,""]
[44,null,null,""]
[45,null,null,""]
[46,null,null,""]
[47,null,null,""]
[48,null,null,""]
[49,null,null,""]
[50,null,null,""]
[51,null,null,""]
[52,null,null,""]
[53,null,null,""]
[54,null,null,""]
[55,null,null,""]
[56,null,null,""]
[57,null,null,""]
[58,null,null,""]
[59,null,null,""]
[60,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]