{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Salim"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":"Salim","index":0,"n_rows":28,"n_cols":20,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,8,0,12],[1,8,1,12],[17,1,17,2],[17,3,17,4]]}
["فا",null,null,null,null,null,null,"G5"]
[null,"الاسم","إبراهيم الصيد العموري","سنة",2019,null,null,null,"ابراهيم الصيد العموري"]
[null,null,null,null,null,null,null,null,"الأحد","الإثنين","الثلاثاء","الأربعاء","الخميس"]
[null,"شهر الغياب","أيام الغياب","أيام الغياب بالحروف","عدد أيام الغياب","عمود1","اسم أيام الغياب","عدد الحصص في الأسبوع",4,3,1,3,3,"Pattern ( (all number starting with 1 or 2 or 3) Optional   then one number)",null,null,null,null,1,"يوم واجد"]
[1,"يناير","22 -20 -16 -13 -10 -3 ",{"$f":"IF(E5=\"\",\"\",VLOOKUP(E5,$S$4:$T$50,2,0))","v":"ستة أيّام"},6,2018,{"$f":"Salim_Extarct($E$2,C5,\"([1-3]?\\d+)\",ROWS($A$1:A1),\" AND \")","v":"الخميس AND الخميس AND الأحد AND الأربعاء AND الأحد AND الثلاثاء"},"عدد أيام الغياب",{"$f":"IFERROR(SUM(IF(--(MID(INDIRECT($H$1),ROW(INDIRECT(\"1:\"&LEN(INDIRECT($H$1)))),LEN(I$3))=I$3),1,\"\")),0)","v":2},{"$f":"IFERROR(SUM(IF(--(MID(INDIRECT($H$1),ROW(INDIRECT(\"1:\"&LEN(INDIRECT($H$1)))),LEN(J$3))=J$3),1,\"\")),0)","v":0},{"$f":"IFERROR(SUM(IF(--(MID(INDIRECT($H$1),ROW(INDIRECT(\"1:\"&LEN(INDIRECT($H$1)))),LEN(K$3))=K$3),1,\"\")),0)","v":1},{"$f":"IFERROR(SUM(IF(--(MID(INDIRECT($H$1),ROW(INDIRECT(\"1:\"&LEN(INDIRECT($H$1)))),LEN(L$3))=L$3),1,\"\")),0)","v":1},{"$f":"IFERROR(SUM(IF(--(MID(INDIRECT($H$1),ROW(INDIRECT(\"1:\"&LEN(INDIRECT($H$1)))),LEN(M$3))=M$3),1,\"\")),0)","v":2},"year",null,null,null,null,2,"يومان"]
[2,"فبراير","27 -26 ","يومان",2,2019,{"$f":"Salim_Extarct($E$2,C6,\"([1-3]?\\d+)\",ROWS($A$1:A2),\" AND \")","v":"الثلاثاء AND الأربعاء"},"مجموع حصص الغياب",{"$f":"I4*N(I5)","v":8},{"$f":"J4*N(J5)","v":0},1,3,6,"separator",null,null,null,null,3,"ثلاثة أيام"]
[3,"مارس","28 -26 -4 -3 ","أربعة أيّام",4,2020,{"$f":"Salim_Extarct($E$2,C7,\"([1-3]?\\d+)\",ROWS($A$1:A3),\" AND \")","v":"الأحد AND الإثنين AND الثلاثاء AND الخميس"},null,null,null,null,null,null,null,null,null,null,null,4,"أربعة أيّام"]
[4,"ابريل","","","",2021,{"$f":"Salim_Extarct($E$2,C8,\"([1-3]?\\d+)\",ROWS($A$1:A4),\" AND \")","v":""},null,null,null,null,null,null,null,null,null,null,null,5,"خمسة أيّام"]
[5,"مايو","","","",null,{"$f":"Salim_Extarct($E$2,C9,\"([1-3]?\\d+)\",ROWS($A$1:A5),\" AND \")","v":""},null,"  ",null,null,null,null," =Salim_Extarct($E$2,C6,\"([1-3]?\\d+)\",ROWS($A$1:A2),\" AND \")",null,null,null,null,6,"ستة أيّام"]
[6,"يونيو","","","",null,{"$f":"Salim_Extarct($E$2,C10,\"([1-3]?\\d+)\",ROWS($A$1:A6),\" AND \")","v":""},null,null,null,null,null,null,null,null,null,null,null,7,"سبعة أيّام"]
[7,"يوليو","","","",null,{"$f":"Salim_Extarct($E$2,C11,\"([1-3]?\\d+)\",ROWS($A$1:A7),\" AND \")","v":""},null,null,null,null,null,null,"the formula in column G",null,null,null,null,8,"ثمانية أيّام"]
[8,"أغسطس","","","",null,{"$f":"Salim_Extarct($E$2,C12,\"([1-3]?\\d+)\",ROWS($A$1:A8),\" AND \")","v":""},null,null,null,null,null,null,null,null,null,null,null,9,"تسعة أيّام"]
[9,"سبتمبر","","","",null,{"$f":"Salim_Extarct($E$2,C13,\"([1-3]?\\d+)\",ROWS($A$1:A9),\" AND \")","v":""},null,null,null,null,null,null,"you can change this  like :\"AND\",\"\\\",\"*\", etc….",null,null,null,null,10,"عشرة أيّام"]
[10,"أكتوبر","","","",null,{"$f":"Salim_Extarct($E$2,C14,\"([1-3]?\\d+)\",ROWS($A$1:A10),\" AND \")","v":""}]
[11,"نوفمبر","","","",null,{"$f":"Salim_Extarct($E$2,C15,\"([1-3]?\\d+)\",ROWS($A$1:A11),\" AND \")","v":""}]
[12,"ديسمبر","","","",null,{"$f":"Salim_Extarct($E$2,C16,\"([1-3]?\\d+)\",ROWS($A$1:A12),\" AND \")","v":""}]
[]
[null,"عـــــدد أيــــــــام الغيـــــــــــــاب خـــــــــــــلال السنــــــــــة ",null,{"$f":"SUM($E$5:$E$16)","v":12}]
[]
[]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]