{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["A","B"],"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":"A","index":0,"n_rows":31,"n_cols":17,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,1,1,2],[12,11,12,12],[18,11,18,12],[22,11,22,12],[26,11,26,12]]}
[]
[null,"المدة",null,"النوع","التفصيل","المنطقة","المبلغ",null,null,null,null,null,null,"ورقة الإضافة"]
[1,"2022-01-04","2022-01-11","AAAA",1245,"الأولى",50,null,null,null,null,null,null,"المضاف ينتقل مباشرة للورقة \"B\" تحت القسم الخاص به"]
[2,"2022-01-04","2022-01-11","AAAA",1264,"الثانية ",100]
[3,"2022-01-04","2022-01-11","AAAA",1283,"الأولى",1000,null,null,null,null,null,null,"الإضافة التي ليس لديها قسم خاص ينشأ لها قسم بشكل آلي"]
[4,"2022-01-04","2022-01-11","BBBB",1302,"الثانية ",400]
[5,"2022-01-04","2022-01-11","AAAA",1321,"الأولى",550,null,null,null,null,null,null,null,null,null,"شرح جديد"]
[6,"2022-01-04","2022-01-11","BBBB",1340,"الثانية ",810,null,null,null,null,null,null,null,null,null,"في الورقة \"A\" يتم ادخال معلومات كثيرة بتواريخ اصدار وانتهاء مختلفة  "]
[7,"2022-01-04","2022-01-18","AAAA",1359,"الأولى",940,null,null,null,null,null,null,null,null,null,"بعضهم يلتقون في نفس المدة من تاريخ اصدار وانتهاء ولكن النوع مختلف"]
[8,"2022-02-01","2022-02-08","AAAA",1378,"الثانية ",1070,null,null,null,null,null,null,null,null,null,"اريد تصنيف منفصل لكل نوع حسب النوع والمدة في الورقة \"B\""]
[9,"2022-02-01","2022-02-08","BBBB",1397,"الأولى",1200]
[10,"2022-02-01","2022-02-08","CCCC",1416,"الثانية ",1330,null,null,null,null,null,null,"مثال"]
[11,"2022-02-04","2022-02-11","BBBB",1435,"الأولى",1460,null,null,null,"مجموعة ا","الصلاحية",null,"النوع ","التفصيل","المنطقة","المبلغ"]
[12,"2022-02-04","2022-02-11","BBBB",1454,"الثانية ",1590,null,null,null,null,"2022-01-04","2022-01-11"," AAAA",1245,"الأولى",50]
[13,"2022-02-04","2022-02-18","CCCC",1473,"الأولى",1720,null,null,null,null,"2022-01-04","2022-01-11","AAAA",1264,"الثانية ",100]
[14]
[15,null,null,null,null,null,null,null,null,null,null,null,null,"المتشابه في الثلاث الخانات في مجموعه لحالهم"]
[16]
[null,null,null,null,null,null,null,null,null,null,"مجموعة ب","الصلاحية",null,"النوع ","التفصيل","المنطقة","المبلغ"]
[null,null,null,null,null,null,null,null,null,null,null,"2022-01-04","2022-01-18","AAAA",1359,"الأولى",940]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"مجموعة ت","الصلاحية",null,"النوع ","التفصيل","المنطقة","المبلغ"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"مجموعة ث","الصلاحية",null,"النوع ","التفصيل","المنطقة","المبلغ"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"عند اضافة نوع جديد في الورقة \"A\" وليس له مجموعه يقوم بإنشاء مجموعه خاصة له في الورقة \"B\""]

{"sheet":"B","index":1,"n_rows":44,"n_cols":14,"rows_kept":44,"cut":false,"hidden":false,"merged":[[42,1,42,2],[2,1,2,2],[10,1,10,2],[16,1,16,2],[21,1,21,2],[26,1,26,2],[36,1,36,2],[31,1,31,2]]}
[]
[]
[null,"AAAA",null,"التفصيل"]
[1,"2022-01-04","2022-01-11",1245,"الأولى",50]
[2,"2022-01-04","2022-01-11",1264,"الثانية ",100]
[3,"2022-01-04","2022-01-11",1283,"الأولى",1000]
[4,"2022-01-04","2022-01-11",1321,"الأولى",550]
[]
[]
[]
[null,"BBBB"]
[1,"2022-01-04","2022-01-11",1302,"الثانية ",400,null,null,null,null,null,null,null,"الفرز مبني على النوع والتاريخين "]
[2,"2022-01-04","2022-01-11",1340,"الثانية ",810]
[]
[]
[]
[null,"AAAA"]
[1,"2022-01-04","2022-01-18",1359,"الأولى",940]
[]
[]
[]
[null,"AAAA"]
[1,"2022-02-01","2022-02-08",1378,"الثانية ",1070]
[]
[]
[]
[null,"BBBB"]
[1,"2022-02-01","2022-02-08",1397,"الأولى",1200]
[]
[]
[]
[null,"CCCC"]
[1,"2022-02-01","2022-02-08",1416,"الثانية ",1330]
[]
[]
[]
[null,"BBBB"]
[1,"2022-02-04","2022-02-11",1435,"الأولى",1460]
[2,"2022-02-04","2022-02-11",1454,"الثانية ",1590]
[]
[]
[]
[null,"CCCC"]
[1,"2022-02-04","2022-02-18",1473,"الأولى",1720]