{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ورقة1","Salim"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":94,"n_cols":12,"rows_kept":94,"cut":false,"hidden":false,"merged":[[1,9,1,11]]}
["رمز  الموظف","الاسم","التاريخ الملاحظة","الملاحظات"]
[112,"احمد","2019-01-01","حاضر",null,null,null,null,null,"الملخص"]
[112,"احمد","2019-01-02","حاضر",null,null,null,null,null,"رمز  الموظف","الاسم","الملاحظات حسب التاريخها"]
[112,"احمد","2019-01-03","حاضر",null,null,null,null,null,112,"احمد","غياب 14/1/2019& تأخير 15/1/2019& خرج بدون اذن 16/1/2019"]
[112,"احمد","2019-01-04","حاضر",null,null,null,null,null,118,"علي","غياب  من 1/1/2019 لغاية 2/1/2019 & لديه دورة من 3/1/2019 لغاية 5/1/2019 & متاخير من 6/1/2019 لغاية 8/1/2019"]
[112,"احمد","2019-01-05","حاضر",null,null,null,null,null,179,"حسن","متاخر 5/01/2019&غياب 10/1/2019& لديه دورة 16/1/2019"]
[112,"احمد","2019-01-06","حاضر"]
[112,"احمد","2019-01-07","حاضر"]
[112,"احمد","2019-01-08","حاضر"]
[112,"احمد","2019-01-09","حاضر"]
[112,"احمد","2019-01-10","حاضر"]
[112,"احمد","2019-01-11","حاضر"]
[112,"احمد","2019-01-12","حاضر"]
[112,"احمد","2019-01-13","حاضر",null,null,null,null,null,null,null,"السلام عليكم ورحمة الله وبركاته اخواني الاحبة المطلوب هو عمل الملخص لبيانات  كما في أعلاه من "]
[112,"احمد","2019-01-14","غياب",null,null,null,null,null,null,null,"1- القيام بإزالة التكرار ووضع البيانات في الجدول أعلاه "]
[112,"احمد","2019-01-15","تأخير",null,null,null,null,null,null,null,"2- جلب  الملاحظات فقط المذكورة مثل (غياب-تأخير -خروج بدون اذن -لديه دورية) حسب اليوم التي حدثت فيه عمود التاريخ"]
[112,"احمد","2019-01-16","خروج بدون اذن"]
[112,"احمد","2019-01-17","مجاز"]
[112,"احمد","2019-01-18","مجاز"]
[112,"احمد","2019-01-19","مجاز"]
[112,"احمد","2019-01-20","مجاز"]
[112,"احمد","2019-01-21","مجاز"]
[112,"احمد","2019-01-22","مجاز"]
[112,"احمد","2019-01-23","مجاز"]
[112,"احمد","2019-01-24","مجاز"]
[112,"احمد","2019-01-25","مجاز"]
[112,"احمد","2019-01-26","مجاز"]
[112,"احمد","2019-01-27","مجاز"]
[112,"احمد","2019-01-28","مجاز"]
[112,"احمد","2019-01-29","مجاز"]
[112,"احمد","2019-01-30","مجاز"]
[112,"احمد","2019-01-31","مجاز"]
[118,"علي","2019-01-01","غياب"]
[118,"علي","2019-01-02","غياب"]
[118,"علي","2019-01-03","لديه دورة"]
[118,"علي","2019-01-04","لديه دورة"]
[118,"علي","2019-01-05","لديه دورة"]
[118,"علي","2019-01-06","متأخر"]
[118,"علي","2019-01-07","متأخر"]
[118,"علي","2019-01-08","متأخر"]
[118,"علي","2019-01-09","مجاز"]
[118,"علي","2019-01-10","مجاز"]
[118,"علي","2019-01-11","مجاز"]
[118,"علي","2019-01-12","مجاز"]
[118,"علي","2019-01-13","مجاز"]
[118,"علي","2019-01-14","مجاز"]
[118,"علي","2019-01-15","مجاز"]
[118,"علي","2019-01-16","مجاز"]
[118,"علي","2019-01-17","مجاز"]
[118,"علي","2019-01-18","مجاز"]
[118,"علي","2019-01-19","مجاز"]
[118,"علي","2019-01-20","مجاز"]
[118,"علي","2019-01-21","مجاز"]
[118,"علي","2019-01-22","حاضر"]
[118,"علي","2019-01-23","حاضر"]
[118,"علي","2019-01-24","حاضر"]
[118,"علي","2019-01-25","حاضر"]
[118,"علي","2019-01-26","حاضر"]
[118,"علي","2019-01-27","حاضر"]
[118,"علي","2019-01-28","حاضر"]
[118,"علي","2019-01-29","حاضر"]
[118,"علي","2019-01-30","حاضر"]
[118,"علي","2019-01-31","حاضر"]
[179,"حسن","2019-01-01","حاضر"]
[179,"حسن","2019-01-02","حاضر"]
[179,"حسن","2019-01-03","حاضر"]
[179,"حسن","2019-01-04","حاضر"]
[179,"حسن","2019-01-05","متأخر"]
[179,"حسن","2019-01-06","مجاز"]
[179,"حسن","2019-01-07","مجاز"]
[179,"حسن","2019-01-08","مجاز"]
[179,"حسن","2019-01-09","مجاز"]
[179,"حسن","2019-01-10","غياب"]
[179,"حسن","2019-01-11","مجاز"]
[179,"حسن","2019-01-12","مجاز"]
[179,"حسن","2019-01-13","مجاز"]
[179,"حسن","2019-01-14","مجاز"]
[179,"حسن","2019-01-15","مجاز"]
[179,"حسن","2019-01-16","لديه دورة"]
[179,"حسن","2019-01-17","حاضر"]
[179,"حسن","2019-01-18","حاضر"]
[179,"حسن","2019-01-19","حاضر"]
[179,"حسن","2019-01-20","حاضر"]
[179,"حسن","2019-01-21","حاضر"]
[179,"حسن","2019-01-22","حاضر"]
[179,"حسن","2019-01-23","حاضر"]
[179,"حسن","2019-01-24","حاضر"]
[179,"حسن","2019-01-25","حاضر"]
[179,"حسن","2019-01-26","حاضر"]
[179,"حسن","2019-01-27","حاضر"]
[179,"حسن","2019-01-28","حاضر"]
[179,"حسن","2019-01-29","حاضر"]
[179,"حسن","2019-01-30","حاضر"]
[179,"حسن","2019-01-31","حاضر"]

{"sheet":"Salim","index":1,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["رمز  الموظف","الاسم","التاريخ الملاحظة","الملاحظات"]
[112,"احمد","2019-01-01","غياب",null,null,null,null,null,"الملخص"]
[112,"احمد","2019-01-11","حاضر",null,null,null,null,null,"رمز  الموظف","الاسم","الملاحظات حسب التاريخها"]
[112,"احمد","2019-01-12","حاضر",null,null,null,null,null,112,"احمد","غياب 01/01/2019 * غياب 14/01/2019 * تأخير 15/01/2019 * خروج بدون اذن 16/01/2019 * مجاز 17/01/2019 * مجاز 31/01/2019"]
[112,"احمد","2019-01-13","حاضر",null,null,null,null,null,113,"علي","غياب 01/01/2019 * غياب 02/01/2019 * لديه دورة 03/01/2019 * متأخر 07/01/2019 * متأخر 08/01/2019"]
[112,"احمد","2019-01-14","غياب",null,null,null,null,null,114,"حسن","متأخر 05/01/2019 * مجاز 06/01/2019 * مجاز 07/01/2019 * لديه دورة 16/01/2019"]
[112,"احمد","2019-01-15","تأخير"]
[112,"احمد","2019-01-16","خروج بدون اذن"]
[112,"احمد","2019-01-17","مجاز"]
[112,"احمد","2019-01-31","مجاز"]
[113,"علي","2019-01-01","غياب"]
[113,"علي","2019-01-02","غياب"]
[113,"علي","2019-01-03","لديه دورة"]
[113,"علي","2019-01-07","متأخر"]
[113,"علي","2019-01-08","متأخر"]
[113,"علي","2019-01-30","حاضر"]
[113,"علي","2019-01-31","حاضر"]
[114,"حسن","2019-01-01","حاضر"]
[114,"حسن","2019-01-04","حاضر"]
[114,"حسن","2019-01-05","متأخر"]
[114,"حسن","2019-01-06","مجاز"]
[114,"حسن","2019-01-07","مجاز"]
[114,"حسن","2019-01-16","لديه دورة"]
[114,"حسن","2019-01-17","حاضر"]
[114,"حسن","2019-01-30","حاضر"]
[114,"حسن","2019-01-31","حاضر"]