{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ورقة1","ورقة2","ورقة3"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"ورقة1","index":0,"n_rows":17,"n_cols":38,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,0,3,0],[2,1,3,1],[2,34,3,34],[2,33,3,33],[2,35,3,35],[2,37,3,37],[16,2,17,21],[18,2,19,21],[20,2,21,21],[2,36,3,36],[2,32,3,32]]}
[]
[null,null,null,2022,null,null,null,null,null,null,null,null,null,null,"تشرين اول"]
["م","اسم الطالب","2019-09-01","2019-09-02","2019-09-03","2019-09-04","2019-09-05","2019-09-06","2019-09-07","2019-09-08","2019-09-09","2019-09-10","2019-09-11","2019-09-12","2019-09-13","2019-09-14","2019-09-15","2019-09-16","2019-09-17","2019-09-18","2019-09-19","2019-09-20","2019-09-21","2019-09-22","2019-09-23","2019-09-24","2019-09-25","2019-09-26","2019-09-27","2019-09-28","2019-09-29","2019-09-30","انذار أول ","تاريخه","انذار ثاني","تاريخه"," انذار ثالث","تاريخه"]
[null,null,"أحد","إثنين","ثلاثاء","أربعاء","خميس","جمعة","سبت","أحد","إثنين","ثلاثاء","أربعاء","خميس","جمعة","سبت","أحد","إثنين","ثلاثاء","أربعاء","خميس","جمعة","سبت","أحد","إثنين","ثلاثاء","أربعاء","خميس","جمعة","سبت","أحد","إثنين"]
[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,{"$f":"IF(COUNTIF(C5:AF5,\"غ\")>=7,\"انذار\",\"\")","v":"انذار"},{"$f":"IFERROR(OFFSET($B$3,,SMALL(IF($C5:$AF5=\"غ\",COLUMN($C5:$AF5)-2),7)),\"\")","v":"2019-09-24"},{"$f":"IF(COUNTIF(C5:AF5,\"غ\")>=14,\"انذار\",\"\")","v":""},{"$f":"IFERROR(OFFSET($B$3,,SMALL(IF($C5:$AF5=\"غ\",COLUMN($C5:$AF5)-2),14)),\"\")","v":""},{"$f":"IF(COUNTIF(D5:AF5,\"غ\")>=21,\"انذار\",\"\")","v":""},{"$f":"IFERROR(OFFSET($B$3,,SMALL(IF($C5:$AF5=\"غ\",COLUMN($C5:$AF5)-2),21)),\"\")","v":""}]
[2,"محمد2","غ","غ","غ","غ","غ",null,null,"غ",null,"غ","غ","غ",null,null,"غ","غ","غ","غ","غ",null,null,"غ","غ","غ","غ","غ",null,null,null,null,{"$f":"IF(COUNTIF(C6:AF6,\"غ\")>=7,\"انذار\",\"\")","v":"انذار"},{"$f":"IFERROR(OFFSET($B$3,,SMALL(IF($C6:$AF6=\"غ\",COLUMN($C6:$AF6)-2),7)),\"\")","v":"2019-09-10"},{"$f":"IF(COUNTIF(C6:AF6,\"غ\")>=14,\"انذار\",\"\")","v":"انذار"},{"$f":"IFERROR(OFFSET($B$3,,SMALL(IF($C6:$AF6=\"غ\",COLUMN($C6:$AF6)-2),14)),\"\")","v":"2019-09-19"},{"$f":"IF(COUNTIF(D6:AF6,\"غ\")>=21,\"انذار\",\"\")","v":""},{"$f":"IFERROR(OFFSET($B$3,,SMALL(IF($C6:$AF6=\"غ\",COLUMN($C6:$AF6)-2),21)),\"\")","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,"انذار",{"$f":"IFERROR(OFFSET($B$3,,SMALL(IF($C7:$AF7=\"غ\",COLUMN($C7:$AF7)-2),7)),\"\")","v":"2019-09-26"},"",{"$f":"IFERROR(OFFSET($B$3,,SMALL(IF($C7:$AF7=\"غ\",COLUMN($C7:$AF7)-2),14)),\"\")","v":""},"",{"$f":"IFERROR(OFFSET($B$3,,SMALL(IF($C7:$AF7=\"غ\",COLUMN($C7:$AF7)-2),21)),\"\")","v":""}]
[]
[]
[]
[null,null,null,null,"السلام عليكم ورحمة الله وبركاته"]
[]
[null,null,null,null,"هل يمكن ان نستدعي تاريخ بلوغ غياب الطالب سبعة ايام من الصف العلوي للجدول وتاريخ بلوغه 14يوم وتاريخ بلوغه 21 يوم"]
[null,null,null,null,null,"اقصد معادلة تحسب اول سبعة ايام وتعطيني الخلية التي في الاعلى فيها التاريخ وتحسب 14 يوم وتعطيني التاريخ من الصف الثالث في الاعلى من الجدول وكذلك 21 يوم"]
[null,null,null,null,null,"علما الجدول مستمر لتسعة اشهر متواصلة لكن ما اريده هو تارخ اول سبعة ايام وتاريخ اول 14 يوم وتاريخ اول 21 يوم"]
[]
[null,null,"وفقكم الله وبارك الله في جهودكم"]

{"sheet":"ورقة2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"ورقة3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}