{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["اليومية","الشهر","البحث"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"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":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["الشهر","اليوم","كمال","شريف","فاتح","أحمد ","محمد"]
["2020-01-01",{"$f":"DAY(A2)","v":1},"setit","boug","setif","boug","tizi"]
["2020-01-02",{"$f":"DAY(A3)","v":2},"alg","tizi","boug","tizi","boug"]
["2020-01-03",3,"tizi","alg","alg","setif","cos"]
["2020-01-04",4,"boug","tizi","tizi","boug","setif"]
["2020-01-05",5,"boug","alg","tizi","boug","cos"]
["2020-01-06",{"$f":"DAY(A7)","v":6},"boug","alg","tizi","boug","أجاز"]
["2020-01-07",7,"boug","tizi","tizi","boug","cos"]
["2020-01-08",8,"boug","alg","tizi","boug","أجاز"]
["2020-01-09",{"$f":"DAY(A10)","v":9},"boug","alg","tizi","boug","cos"]
["2020-01-10",10,"boug","tizi","tizi","boug","أجاز"]
["2020-01-11",11,"setif","setif","setif","اجازه","غائب"]
["2020-01-12",12,"boug","tizi","setif","boug","غائب"]
["2020-01-13",13,"cos","boug","cos","boug","boug"]
["2020-01-14",14,"setif","setif","setif","غائب","boug"]
["2020-01-15",15,"boug","tizi","setif","boug","إجازة"]
["2020-01-16",16,"cos","boug","cos","boug","boug"]
["2020-01-17",17,"setif","setif","setif","غائب","boug"]
["2020-01-18",18,"boug","tizi","setif","boug","اجازه"]
["2020-01-19",19,"cos","boug","cos","boug","boug"]
["2020-01-20",20,"setif","setif","setif","اجازه","boug"]
["2020-01-21",{"$f":"DAY(A22)","v":21},0,0,0,0,0]
["2020-01-22",22,0,0,0,0,0]
["2020-01-23",23,0,0,0,0,0]
["2020-01-24",24,0,0,0,0,0]
["2020-01-25",25,0,0,0,0,0]
["2020-01-26",26,0,0,0,0,0]
["2020-01-27",27,0,0,0,0,0]
["2020-01-28",28,0,0,0,0,0]
["2020-01-29",29,0,0,0,0,0]
["2020-01-30",30,0,0,0,0,0]
["2020-01-31",31,0,0,0,0,0]

{"sheet":"الشهر","index":1,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"الشهر","2020-01-05","الساءق","شريف"]
[]
[null,"اليوم","الاتجاه",null,null,null,null,null,null,null,"janvier",null,"كمال"]
[null,{"$f":"VLOOKUP($C$2,data_2,2,FALSE)","v":5},{"$f":"IFERROR(INDEX(data,MATCH($C$2,moth,0),MATCH($E$2,name,0)),\"\")","v":"alg"},null,null,null,null,null,null,null,"février",null,"شريف"]
[null,null,null,null,null,null,null,null,null,null,"mars",null,"فاتح"]
[null,null,null,null,null,null,null,null,null,null,"avril",null,"أحمد "]
[null,null,null,null,null,null,null,null,null,null,"mai",null,"محمد"]
[null,null,null,null,null,null,null,null,null,null,"juin"]
[null,null,null,null,null,null,null,null,null,null,"juillet"]
[null,null,null,null,null,null,null,null,null,null,"août"]
[null,null,null,null,null,null,null,null,null,null,"septembre"]
[null,null,null,null,null,null,null,null,null,null,"octobre"]
[null,null,null,null,null,null,null,null,null,null,"novembre"]
[null,null,null,null,null,null,null,null,null,null,"décembre"]

{"sheet":"البحث","index":2,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[[7,9,9,13]]}
[]
[]
[null,"التاريح من","2020-01-04"]
[null,"التاريح الي ","2020-01-11"]
[]
[]
[]
[null,"الشهر","اليوم","كمال","شريف","فاتح","أحمد ","محمد",null,"تم تعديل الجدول ليتلام مع الفلترة وسيتم البحث في كافة العمال على أساس الشهر وللفترة المحددة  ولايمكن الفلترة على أساس عامل واحد لعدم وجود الشرط..  كون ان العمال موزعين لكل عامل عمود خاص به",null,null,null,null,"أولا"]
[null,"2020-01-04",4,"boug","tizi","tizi","boug","setif"]
[null,"2020-01-05",5,"boug","alg","tizi","boug","cos"]
[null,"2020-01-06",6,"boug","alg","tizi","boug","أجاز",null,null,null,null,null,"اختر من - الى    ثم نفذ","ثانيا"]
[null,"2020-01-07",7,"boug","tizi","tizi","boug","cos"]
[null,"2020-01-08",8,"boug","alg","tizi","boug","أجاز"]
[null,"2020-01-09",9,"boug","alg","tizi","boug","cos"]
[null,"2020-01-10",10,"boug","tizi","tizi","boug","أجاز"]
[null,"2020-01-11",11,"setif","setif","setif","اجازه","غائب"]