{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Calendrier 2019 - Tableau","ورقة1"],"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":"Calendrier 2019 - Tableau","index":0,"n_rows":35,"n_cols":41,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,2,8],[0,9,2,9],[0,11,2,12],[0,14,2,15],[0,17,2,17],[0,31,2,32],[0,34,2,35],[0,37,2,38],[0,40,2,41],[3,0,3,2],[3,3,3,5],[3,6,3,8],[3,9,3,11],[3,12,3,14],[3,15,3,17],[3,18,3,23],[3,24,3,29],[3,30,3,32],[3,33,3,35],[3,36,3,38],[3,39,3,41],[4,20,4,23],[4,26,4,29],[5,20,5,23],[5,26,5,29],[6,20,6,23],[6,26,6,29],[7,20,7,23],[7,26,7,29],[8,20,8,23],[8,26,8,29],[9,20,9,23],[9,26,9,29],[10,20,10,23],[10,26,10,29],[11,20,11,23],[11,26,11,29],[12,20,12,23],[12,26,12,29],[13,20,13,23],[13,26,13,29],[14,20,14,23],[14,26,14,29],[15,20,15,23],[15,26,15,29],[16,20,16,23],[16,26,16,29],[17,20,17,23],[17,26,17,29],[18,20,18,23],[18,26,18,29],[19,20,19,23],[19,26,19,29],[20,20,20,23],[20,26,20,29],[21,20,21,23],[21,26,21,29],[22,20,22,23],[22,26,22,29],[23,20,23,23],[23,26,23,29],[24,20,24,23],[24,26,24,29],[25,20,25,23],[25,26,25,29],[26,20,26,23],[26,26,26,29],[27,20,27,23],[27,26,27,29],[28,20,28,23],[28,26,28,29],[34,26,34,29],[29,20,29,23],[29,26,29,29],[30,20,30,23],[30,26,30,29],[31,20,31,23],[31,26,31,29],[34,30,34,32],[34,36,34,38],[32,3,34,5],[32,20,32,23],[32,26,32,29],[33,20,33,23],[33,26,33,29],[34,9,34,11],[34,15,34,17],[34,20,34,23]]}
["Calendrier 2019"]
[]
[]
["Janvier",null,null,"Février",null,null,"Mars",null,null,"Avril",null,null,"Mai",null,null,"Juin",null,null,"Juillet",null,null,null,null,null,"Août",null,null,null,null,null,"Septembre",null,null,"Octobre",null,null,"Novembre",null,null,"Décembre"]
[1,"Ma",null,1,"V",null,1,"V",null,1,"L",null,1,"Mer",null,1,"S",null,1,"L",null,null,null,null,1,"J",null,null,null,null,1,"D",null,1,"Ma",null,1,"V",null,1,"D"]
[2,"Mer",null,2,"S",null,2,"S",null,2,"Ma",null,2,"J",null,2,"D",null,2,"Ma",null,null,null,null,2,"V",null,null,null,null,2,"L",null,2,"Mer",null,2,"S",null,2,"L"]
[3,"J",null,3,"D",null,3,"D",null,3,"Mer",null,3,"V",null,3,"L",null,3,"Mer",null,null,null,null,3,"S",null,null,null,null,3,"Ma",null,3,"J",null,3,"D",null,3,"Ma"]
[4,"V",null,4,"L",null,4,"L",null,4,"J",null,4,"S",null,4,"Ma",null,4,"J",null,null,null,null,4,"D",null,null,null,null,4,"Mer",null,4,"V",null,4,"L",null,4,"Mer"]
[5,"S",null,5,"Ma",null,5,"Ma",null,5,"V",null,5,"D",null,5,"Mer",null,5,"V",null,null,null,null,5,"L",null,null,null,null,5,"J",null,5,"S",null,5,"Ma",null,5,"J"]
[6,"D",null,6,"Mer",null,6,"Mer",null,6,"S",null,6,"L",null,6,"J",null,6,"S",null,null,null,null,6,"Ma",null,null,null,null,6,"V",null,6,"D",null,6,"Mer",null,6,"V"]
[7,"L",null,7,"J",null,7,"J",null,7,"D",null,7,"Ma",null,7,"V",null,7,"D",null,null,null,null,7,"Mer",null,null,null,null,7,"S",null,7,"L",null,7,"J",null,7,"S"]
[8,"Ma",null,8,"V",null,8,"V",null,8,"L",null,8,"Mer",null,8,"S",null,8,"L",null,null,null,null,8,"J",null,null,null,null,8,"D",null,8,"Ma",null,8,"V",null,8,"D"]
[9,"Mer",null,9,"S",null,9,"S",null,9,"Ma",null,9,"J",null,9,"D",null,9,"Ma",null,null,null,null,9,"V",null,null,null,null,9,"L",null,9,"Mer",null,9,"S",null,9,"L"]
[10,"J",null,10,"D",null,10,"D",null,10,"Mer",null,10,"V",null,10,"L",null,10,"Mer",null,null,null,null,10,"S",null,null,null,null,10,"Ma",null,10,"J",null,10,"D",null,10,"Ma"]
[11,"V",null,11,"L",null,11,"L",null,11,"J",null,11,"S",null,11,"Ma",null,11,"J",null,null,null,null,11,"D",null,null,null,null,11,"Mer",null,11,"V",null,11,"L",null,11,"Mer"]
[12,"S",null,12,"Ma",null,12,"Ma",null,12,"V",null,12,"D",null,12,"Mer",null,12,"V",null,null,null,null,12,"L",null,null,null,null,12,"J",null,12,"S",null,12,"Ma",null,12,"J"]
[13,"D",null,13,"Mer",null,13,"Mer",null,13,"S",null,13,"L",null,13,"J",null,13,"S",null,null,null,null,13,"Ma",null,null,null,null,13,"V",null,13,"D",null,13,"Mer",null,13,"V"]
[14,"L",null,14,"J",null,14,"J",null,14,"D",null,14,"Ma",null,14,"V",null,14,"D",null,null,null,null,14,"Mer",null,null,null,null,14,"S",null,14,"L",null,14,"J",null,14,"S"]
[15,"Ma",null,15,"V",null,15,"V",null,15,"L",null,15,"Mer",null,15,"S",null,15,"L",null,null,null,null,15,"J",null,null,null,null,15,"D",null,15,"Ma",null,15,"V",null,15,"D"]
[16,"Mer",null,16,"S",null,16,"S",null,16,"Ma",null,16,"J",null,16,"D",null,16,"Ma",null,null,null,null,16,"V",null,null,null,null,16,"L",null,16,"Mer",null,16,"S",null,16,"L"]
[17,"J",null,17,"D",null,17,"D",null,17,"Mer",null,17,"V",null,17,"L",null,17,"Mer",null,null,null,null,17,"S",null,null,null,null,17,"Ma",null,17,"J",null,17,"D",null,17,"Ma"]
[18,"V",null,18,"L",null,18,"L",null,18,"J",null,18,"S",null,18,"Ma",null,18,"J",null,null,null,null,18,"D",null,null,null,null,18,"Mer",null,18,"V",null,18,"L",null,18,"Mer"]
[19,"S",null,19,"Ma",null,19,"Ma",null,19,"V",null,19,"D",null,19,"Mer",null,19,"V",null,null,null,null,19,"L",null,null,null,null,19,"J",null,19,"S",null,19,"Ma",null,19,"J"]
[20,"D",null,20,"Mer",null,20,"Mer",null,20,"S",null,20,"L",null,20,"J",null,20,"S",null,null,null,null,20,"Ma",null,null,null,null,20,"V",null,20,"D",null,20,"Mer",null,20,"V"]
[21,"L",null,21,"J",null,21,"J",null,21,"D",null,21,"Ma",null,21,"V",null,21,"D",null,null,null,null,21,"Mer",null,null,null,null,21,"S",null,21,"L",null,21,"J",null,21,"S"]
[22,"Ma",null,22,"V",null,22,"V",null,22,"L",null,22,"Mer",null,22,"S",null,22,"L",null,null,null,null,22,"J",null,null,null,null,22,"D",null,22,"Ma",null,22,"V",null,22,"D"]
[23,"Mer",null,23,"S",null,23,"S",null,23,"Ma",null,23,"J",null,23,"D",null,23,"Ma",null,null,null,null,23,"V",null,null,null,null,23,"L",null,23,"Mer",null,23,"S",null,23,"L"]
[24,"J",null,24,"D",null,24,"D",null,24,"Mer",null,24,"V",null,24,"L",null,24,"Mer",null,null,null,null,24,"S",null,null,null,null,24,"Ma",null,24,"J",null,24,"D",null,24,"Ma"]
[25,"V",null,25,"L",null,25,"L",null,25,"J",null,25,"S",null,25,"Ma",null,25,"J",null,null,null,null,25,"D",null,null,null,null,25,"Mer",null,25,"V",null,25,"L",null,25,"Mer"]
[26,"S",null,26,"Ma",null,26,"Ma",null,26,"V",null,26,"D",null,26,"Mer",null,26,"V",null,null,null,null,26,"L",null,null,null,null,26,"J",null,26,"S",null,26,"Ma",null,26,"J"]
[27,"D",null,27,"Mer",null,27,"Mer",null,27,"S",null,27,"L",null,27,"J",null,27,"S",null,null,null,null,27,"Ma",null,null,null,null,27,"V",null,27,"D",null,27,"Mer",null,27,"V"]
[28,"L",null,28,"J",null,28,"J",null,28,"D",null,28,"Ma",null,28,"V",null,28,"D",null,null,null,null,28,"Mer",null,null,null,null,28,"S",null,28,"L",null,28,"J",null,28,"S"]
[29,"Ma",null,null,null,null,29,"V",null,29,"L",null,29,"Mer",null,29,"S",null,29,"L",null,null,null,null,29,"J",null,null,null,null,29,"D",null,29,"Ma",null,29,"V",null,29,"D"]
[30,"Mer",null,null,null,null,30,"S",null,30,"Ma",null,30,"J",null,30,"D",null,30,"Ma",null,null,null,null,30,"V",null,null,null,null,30,"L",null,30,"Mer",null,30,"S",null,30,"L"]
[31,"J",null,null,null,null,31,"D",null,null,null,null,31,"V",null,null,null,null,31,"Mer",null,null,null,null,31,"S",null,null,null,null,null,null,null,31,"J",null,null,null,null,31,"Ma"]

{"sheet":"ورقة1","index":1,"n_rows":35,"n_cols":20,"rows_kept":35,"cut":false,"hidden":false,"merged":[[6,14,6,17],[1,4,2,4],[1,5,2,6],[2,10,2,21]]}
[]
[null,null,2019,null,null,"مجموع عدد الوجبات"]
[null,null,null,null,null,null,null,null,null,null,"أنا أريد دالة  نأخذ منها الأحد و الإثنين و الأربعاء والخميس فقط بمعنى إذا كانت الخلية c7= الأربعاء أو الحمييس أو الأحد أو الإثنين =01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ونضعها في الخلية N7 ومن بعد نعممها على العمود"]
[]
["الرقم","اللقب و الإسم","جانفي","فبراير","مارس","أبريل","ماي","جوان","سبتمبر","أكتوبر","نوفمبر","ديسمبر"]
[1,"محمد","2019-01-02","2019-02-03","2019-03-03","2019-04-01","2019-05-01","2019-06-02","2019-09-01","2019-10-02","2019-11-03","2019-12-01",null,null,"الدالة تكتب هنا ليس محمية أستاذ"]
[2,"أحمد","2019-01-03","2019-02-04","2019-03-04","2019-04-03","2019-05-02","2019-06-03","2019-09-02","2019-10-03","2019-11-04","2019-12-02"]
[3,"فريد","2019-01-06","2019-02-06","2019-03-06","2019-04-04","2019-05-05","2019-06-05","2019-09-04","2019-10-06","2019-11-06","2019-12-04"]
[4,"جمال","2019-01-07","2019-02-07","2019-03-07","2019-04-07","2019-05-06","2019-06-06","2019-09-05","2019-10-07","2019-11-07","2019-12-05"]
[5,"كمال","2019-01-09","2019-02-10","2019-03-10","2019-04-08","2019-05-08","2019-06-09","2019-09-08","2019-10-09","2019-11-10","2019-12-08"]
[6,null,"2019-01-10","2019-02-11","2019-03-11","2019-04-10","2019-05-09","2019-06-10","2019-09-09","2019-10-10","2019-11-11","2019-12-09"]
[7,null,"2019-01-13","2019-02-13","2019-03-13","2019-04-11","2019-05-12","2019-06-12","2019-09-11","2019-10-13","2019-11-13","2019-12-11"]
[8,null,"2019-01-14","2019-02-14","2019-03-14","2019-04-14","2019-05-13","2019-06-13","2019-09-12","2019-10-14","2019-11-14","2019-12-12"]
[9,null,"2019-01-16","2019-02-17","2019-03-17","2019-04-15","2019-05-15","2019-06-16","2019-09-15","2019-10-16","2019-11-17","2019-12-15"]
[10,null,"2019-01-17","2019-02-18","2019-03-18","2019-04-17","2019-05-16","2019-06-17","2019-09-16","2019-10-17","2019-11-18","2019-12-16"]
[11,null,"2019-01-20","2019-02-20","2019-03-20","2019-04-18","2019-05-19","2019-06-19","2019-09-18","2019-10-20","2019-11-20","2019-12-18"]
[12,null,"2019-01-21","2019-02-21","2019-03-21","2019-04-21","2019-05-20","2019-06-20","2019-09-19","2019-10-21","2019-11-21","2019-12-19"]
[13,null,"2019-01-23","2019-02-24","2019-03-24","2019-04-22","2019-05-22","2019-06-23","2019-09-22","2019-10-23","2019-11-24","2019-12-22"]
[14,null,"2019-01-24","2019-02-25","2019-03-25","2019-04-24","2019-05-23","2019-06-24","2019-09-23","2019-10-24","2019-11-25","2019-12-23"]
[15,null,"2019-01-27","2019-02-27","2019-03-27","2019-04-25","2019-05-26","2019-06-26","2019-09-25","2019-10-27","2019-11-27","2019-12-25"]
[16,null,"2019-01-28","2019-02-28","2019-03-28","2019-04-28","2019-05-27","2019-06-27","2019-09-26","2019-10-28","2019-11-28","2019-12-26"]
[17,null,"2019-01-30",null,"2019-03-31","2019-04-29","2019-05-29","2019-06-30","2019-09-29","2019-10-30","2019-12-01","2019-12-29"]
[18,null,"2019-01-31",null,null,"2019-05-01","2019-05-30","2019-07-01","2019-09-30","2019-10-31",null,"2019-12-30"]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]