{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["MainSheet","موقف الغياب اليومي","موقف الغياب الشهري"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"MainSheet","index":0,"n_rows":200,"n_cols":35,"rows_kept":200,"cut":false,"hidden":false,"merged":[[1,34,2,34],[1,0,1,2]]}
[null,null,"الجمعة",{"$f":"IF(D2=$C$1,1,0)","v":0},{"$f":"IF(E2=$C$1,1,0)","v":0},0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0]
[{"$f":"D3","v":"2025-07-01"},null,null,{"$f":"TEXT(D3,\"ddd\")","v":"الثلاثاء"},"الأربعاء","الخميس","الجمعة","السبت","الأحد","الإثنين","الثلاثاء","الأربعاء","الخميس","الجمعة","السبت","الأحد","الإثنين","الثلاثاء","الأربعاء","الخميس","الجمعة","السبت","الأحد","الإثنين","الثلاثاء","الأربعاء","الخميس","الجمعة","السبت","الأحد","الإثنين","الثلاثاء","الأربعاء","الخميس","مجموع الغياب"]
["ت","إسم الموظف","الوظيفة","2025-07-01",{"$f":"D3+1","v":"2025-07-02"},"2025-07-03",{"$f":"F3+1","v":"2025-07-04"},{"$f":"G3+1","v":"2025-07-05"},"2025-07-06","2025-07-07","2025-07-08","2025-07-09","2025-07-10","2025-07-11","2025-07-12","2025-07-13","2025-07-14","2025-07-15","2025-07-16","2025-07-17","2025-07-18","2025-07-19","2025-07-20","2025-07-21","2025-07-22","2025-07-23","2025-07-24","2025-07-25","2025-07-26","2025-07-27","2025-07-28","2025-07-29","2025-07-30","2025-07-31"]
[{"$f":"ROW()-3","v":1},"موظف 1","مهندس",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":"COUNTIFS($D4:$AH4,\"غ\")","v":4}]
[{"$f":"ROW()-3","v":2},"موظف 2","عتال",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":"COUNTIFS($D5:$AH5,\"غ\")","v":0}]
[{"$f":"ROW()-3","v":3},"موظف 3","حرفي","غ",null,"غ","غ","غ",null,null,null,null,"غ","غ","غ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[4,"موظف 4","مبرمج",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,0]
[5,"موظف 5",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,0]
[6,"موظف 6",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,0]
[7,"موظف 7",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,0]
[8,"موظف 8",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,0]
[9,"موظف 9",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,0]
[10,"موظف 10",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,0]
[11,"موظف 11",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,0]
[12,"موظف 12",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,0]
[13,"موظف 13",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,0]
[14,"موظف 14",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,0]
[15,"موظف 15",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,0]
[16,"موظف 16",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,0]
[17,"موظف 17",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,0]
[18,"موظف 18",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,0]
[19,"موظف 19",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,0]
[20,"موظف 20",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,0]
[21,120,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,0]
[22,121,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,0]
[23,122,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,0]
[24,123,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,0]
[25,124,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,0]
[26,125,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,0]
[27,126,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,0]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[{"$f":"ROW()-3","v":67}]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[{"$f":"ROW()-3","v":131}]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[{"$f":"ROW()-3","v":195}]
[196]
[197]

{"sheet":"موقف الغياب اليومي","index":1,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,4,6,7]]}
[null,null,null,null,"اظهار نتيجة البحث لتاريخ معين يظهر الموظفين الذين تسجل غياب لديهم في هذا اليوم"]
[null,"تاريخ الغياب","2025-07-05"]
[]
["ت","إسم الموظف","الوظيفة","تاريخ الغياب"]
[1,"موظف 1","مهندس","2025-07-05"]

{"sheet":"موقف الغياب الشهري","index":2,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,4,3,10]]}
[null,"بحث ببن تاريخين",null,null,"اظهار نتائج اعتمادا على شيت الرئيسي main يظهر عدد الموظفين الذبن لديهم غياب مع عدد ايام الغياب وتاريخ الغياب ويوم الغياب .. علما ان بحث بين تاريخين بعتمد على فترة محددة ليس شرط شهر واحد احتمال ان يكون ايام محددة من تاريخ الى تاريخ اخر اسبوع او عشرون يوما كمثال"]
[null,"من تاريخ","2025-07-01"]
[null,"الى تاريخ","2025-07-30"]
[]
["ت","إسم الموظف","الوظيفة","عدد أيام الغياب","تواريخ الغياب","اليوم"]
[1,"موظف 1","مهندس",4,"5/7/2025\n14/7/2025\n21/7/2025\n28/7/2025","السبت\nالاثنين\nالاثنين\nالاثنين"]
[2,"موظف 3","حرفي",10]