{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["بيانات","تصفية","ورقة3"],"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":"بيانات","index":0,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["م","رمز1","رمز2","الحالة","رمز4","رمز5","جهة","وقت","المعتمد","الكم","باقي"]
[1,"ج","م","مقبول",null,null,"غ","ص","خالد",22,1]
[2,"ج","م","مقبول",null,null,"غ","ص","كرم",3,1]
[3,"ج","م","مقبول",null,null,"غ","ص","لؤي",36,1]
[4,"ج","م","جيد",null,null,"غ","ص","جميل",336,1]
[5,"ج","م","مقبول",null,null,"غ","ص","بلال",25,1]
[6,"ج","م","مقبول",null,null,"غ","ص","صالح",22,1]
[7,"ج","م","مقبول",null,null,"غ","ص","وسيم",10,1]
[8,"ج","م","مقبول",null,null,"غ","ص","خالد",45,1]
[9,"ج","م","مقبول",null,null,"غ","ص","خالد",25,1]
[10,"ج","م","مقبول",null,null,"غ","م","بلال",58,1]
[11,"ج","م","مقبول",null,null,"غ","م","بلال",62,1]
[12,"ج","م","جيد",null,null,"غ","م","بلال",321,1]
[13,"ج","م","مقبول",null,null,"غ","م","وسيم",12,1]
[14,"ج","م","مقبول",null,null,"غ","م","كرم",22,1]
[15,"ج","م","مقبول",null,null,"غ","م","كرم",10,1]
[16,"ج","م","مقبول",null,null,"غ","م","كرم",10,1]
[17,"ج","م","مقبول",null,null,"غ","م","كرم",45,1]
[18,"ج","م","مقبول",null,null,"غ","م","كرم",48,1]
[19,"ج","م","مقبول",null,null,"غ","م","خالد",62,1]
[20,"ج","م","مقبول",null,null,"غ","م","جميل",35,1]
[21,"ج","م","مقبول",null,null,"غ","م","وسيم",51,1]
[22,"ج","م","مقبول",null,null,"غ","م","صالح",14,1]
[23,"ج","م","مقبول",null,null,"غ","م","صالح",8,1]

{"sheet":"تصفية","index":1,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,"المعتمد","الكم","باقي"]
[null,{"$f":"IFERROR(INDEX(بيانات!$I$2:$I$240,MATCH(0,INDEX(COUNTIF($B$1:B1,بيانات!$I$2:$I$240),),0)),\"\")","v":"خالد"},{"$f":"SUMIF(بيانات!$I$2:$I$240,$B2,بيانات!$J$2:$J$240)","v":154},{"$f":"SUMIF(بيانات!$I$2:$I$240,$B2,بيانات!$K$2:$K$240)","v":4}]
[null,{"$f":"IFERROR(INDEX(بيانات!$I$2:$I$240,MATCH(0,INDEX(COUNTIF($B$1:B2,بيانات!$I$2:$I$240),),0)),\"\")","v":"كرم"},{"$f":"SUMIF(بيانات!$I$2:$I$240,$B3,بيانات!$J$2:$J$240)","v":138},{"$f":"SUMIF(بيانات!$I$2:$I$240,$B3,بيانات!$K$2:$K$240)","v":6}]
[null,{"$f":"IFERROR(INDEX(بيانات!$I$2:$I$240,MATCH(0,INDEX(COUNTIF($B$1:B3,بيانات!$I$2:$I$240),),0)),\"\")","v":"لؤي"},{"$f":"SUMIF(بيانات!$I$2:$I$240,$B4,بيانات!$J$2:$J$240)","v":36},{"$f":"SUMIF(بيانات!$I$2:$I$240,$B4,بيانات!$K$2:$K$240)","v":1}]
[null,{"$f":"IFERROR(INDEX(بيانات!$I$2:$I$240,MATCH(0,INDEX(COUNTIF($B$1:B4,بيانات!$I$2:$I$240),),0)),\"\")","v":"جميل"},{"$f":"SUMIF(بيانات!$I$2:$I$240,$B5,بيانات!$J$2:$J$240)","v":371},{"$f":"SUMIF(بيانات!$I$2:$I$240,$B5,بيانات!$K$2:$K$240)","v":2},"السلام عليكمورحمة الله"]
[null,{"$f":"IFERROR(INDEX(بيانات!$I$2:$I$240,MATCH(0,INDEX(COUNTIF($B$1:B5,بيانات!$I$2:$I$240),),0)),\"\")","v":"بلال"},{"$f":"SUMIF(بيانات!$I$2:$I$240,$B6,بيانات!$J$2:$J$240)","v":466},{"$f":"SUMIF(بيانات!$I$2:$I$240,$B6,بيانات!$K$2:$K$240)","v":4},"المطلوب تجميع الاسماء المتعددة من صفحة بيانات واختصارها في هذا الجدول تلقائيا تزيد وتنقص بحسب المعتمدين"]
[null,{"$f":"IFERROR(INDEX(بيانات!$I$2:$I$240,MATCH(0,INDEX(COUNTIF($B$1:B6,بيانات!$I$2:$I$240),),0)),\"\")","v":"صالح"},{"$f":"SUMIF(بيانات!$I$2:$I$240,$B7,بيانات!$J$2:$J$240)","v":44},{"$f":"SUMIF(بيانات!$I$2:$I$240,$B7,بيانات!$K$2:$K$240)","v":3},"مثل خالد مكرر 10 مرات فيكون في هذا الجدول خالد مرة واحدة  ولكم شكر"]
[null,{"$f":"IFERROR(INDEX(بيانات!$I$2:$I$240,MATCH(0,INDEX(COUNTIF($B$1:B7,بيانات!$I$2:$I$240),),0)),\"\")","v":"وسيم"},{"$f":"SUMIF(بيانات!$I$2:$I$240,$B8,بيانات!$J$2:$J$240)","v":73},{"$f":"SUMIF(بيانات!$I$2:$I$240,$B8,بيانات!$K$2:$K$240)","v":3}]
[null,{"$f":"IFERROR(INDEX(بيانات!$I$2:$I$240,MATCH(0,INDEX(COUNTIF($B$1:B8,بيانات!$I$2:$I$240),),0)),\"\")","v":0},{"$f":"SUMIF(بيانات!$I$2:$I$240,$B9,بيانات!$J$2:$J$240)","v":0},{"$f":"SUMIF(بيانات!$I$2:$I$240,$B9,بيانات!$K$2:$K$240)","v":0}]
[null,{"$f":"IFERROR(INDEX(بيانات!$I$2:$I$240,MATCH(0,INDEX(COUNTIF($B$1:B9,بيانات!$I$2:$I$240),),0)),\"\")","v":""}]

{"sheet":"ورقة3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}