{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["معلومات","ورقة1","1م1","1م2"],"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":"معلومات","index":0,"n_rows":56,"n_cols":17,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
["الرقم","اللقب","الاسم","تاريخ الميلاد","مكان الميلاد","الجنس","القسم","اسم الأب"," لقب الأم","اسم  الأم","العنوان","Nom","Prenom","المعدل","الرقم الوطني","ر العقد"]
[1,"بحار","وصال","2011-01-27","وادي التاغية","أنثى","1م1","بن صواق","بوعناني","غريسية","ملحقة ويزغت","Behar","wissal",4.5,1101129220002700,27,"1م1"]
[2,"بركاك","آمينة","2011-01-02","وادي التاغية","أنثى","1م1","قادة","مزوار","فظيلة","ملحقة ويزغت","Barkak","Amina",7.5,1101129220000500,5]
[5,"بركاك","عبد القادر","2010-07-16","غريس","ذكر","1م1",null,null,null,"ملحقة ويزغت","Barkak","Abdelkader",5.4,1001029120140900,1409]
[7,"بركاك","نسرين","2011-06-14","غريس","أنثى","1م1","رشيد","بركاك","ستي","ملحقة ويزغت","Barkak","Nesrine",6.9,1101129220098900,989]
[9,"بن ديخة","نور الهدى","2011-01-05","تغنيف","أنثى","1م1","بلحول",null,"سميرة","ملحقة ويزغت","Bendikha","Nour elhouda",5.7,1101129060006800,68]
[11,"بن سهلة","رضوان","2010-06-16","غريس","ذكر","1م1","بن علي","بن سهلة","فاطمة","ملحقة ويزغت","bensahla","Redwane",7.5,1001029120109500,1095]
[12,"بورزين","عبد القادر","2011-03-11","معسكر","ذكر","1م1","محمد","بورزين","زهرة","ملحقة ويزغت","Bourzine","Abdelkader",4.5999999999999996,1001129010105700,1057]
[16,"بومفتاح","دعاء","2011-04-23","وهران","أنثى","1م1","بن صواق",null,"نادية","ملحقة ويزغت","Boumeftah","douaa",8.1999999999999993,1101131010564100,5641]
[18,"تبينة","فريدة","2010-06-18","وادي التاغية","أنثى","1م1","جيلالي","مدرار","فاطمة","ملحقة ويزغت","Tabina","Farida",7.7,1101029220010600,106]
[19,"تبينة","كلثوم","2010-09-27","غريس","أنثى","1م1","بن صواق","زواية","فظيلة","ملحقة ويزغت","Tabina","kaltoum",6.5,1101029120197200,1972]
[22,"دلة","محي الدين","2008-11-16","غريس","ذكر","1م1","عدة","دلة","ام الجيلالي","ملحقة ويزغت","Della","Mehiddine",4.4000000000000004,1000829120171100,1711]
[23,"دلة","ملوكة","2010-09-16","معسكر","أنثى","1م1","مجادي","باعو","دحاوية","ملحقة ويزغت","Della","Melouka",7.3,1101029010384200,3842]
[26,"دوار","عونية","2010-09-20","وادي التاغية","أنثى","1م1","مختار","دوار","خيرة","ملحقة ويزغت","Douar","Laounia",6.3,1101029220017100,171]
[27,"زعتر","محمد الأمين","2011-04-06","وادي التاغية","ذكر","1م1","علي","ميلودي","خديجة","ملحقة ويزغت","Zaâter","Mohamed Amine",7.4,1001129220006200,62]
[30,"عبدون","بهاء الدين هيثم","2010-11-14","ادرار","ذكر","1م1","بن عومر","عبدون","فتيحة","ملحقة ويزغت","Abdoune","Bahaa eddine haytham",5.8,1001001010197700,1977]
[31,"عبدون","علاء الدين","2010-10-20","غريس","ذكر","1م1","قديم","قدوس","سميرة","ملحقة ويزغت","Abdoune","Alla elddine",5.8,1001029120212900,2129]
[33,"فرعون","أسماء","2010-07-14","غريس","أنثى","1م1","ماحي","فرعون","فاطيمة","ملحقة ويزغت","Feraoune","Asmaa",8.8000000000000007,1101029120130500,1305]
[36,"فرعون","نور الهدى","2010-10-12","وادي التاغية","أنثى","1م1","هواري","دوار","عونية","ملحقة ويزغت","Feraoune","Nour elhouda",5.7,1101029220018700,187]
[39,"قدوس","جيلالي","2010-05-18","وادي التاغية","ذكر","1م1","بن علي","بلهادي","يمينة","ملحقة ويزغت","Kaddous","djillali",6.3,1001029220009400,94]
[45,"مدرار","حياة","2010-07-23","معسكر","أنثى","1م1","بن عومر","قرين","نوال","ملحقة ويزغت","Medrar","Hayat",8.1,1101029010286200,2862]
[46,"نعاس","محمد","2010-10-07","وهران","ذكر","1م1","عبد القادر","بركاك","عونية","ملحقة ويزغت","Naas","Mohamed",6.4,1401031011656000,16560]
[48,"وافريغ","وليد","2009-09-29","غريس","ذكر","1م1","حبيب","بركاك",null,"ملحقة ويزغت","Ouafrigh","Walid",5.3,1000929120158700,1587]
[3,"بركاك","دعاء","2010-08-01","غريس","أنثى","1م2","قادة","فيجل","كريمة","ملحقة ويزغت","Barkak","douaa",6.8,1101029120146100,1461]
[6,"بركاك","فاطيمة","2010-11-29","وادي التاغية","أنثى","1م2","عبد القادر","خنثر","كريمة","ملحقة ويزغت","Barkak","Fatima",4.5,1101029220021400,214]
[8,"بركاك","وئام فاطمة الزهراء","2010-12-02","وادي التاغية","أنثى","1م2","بن صواق","بركاك","محتارية","ملحقة ويزغت","Barkak","Wiam fatima zohra",5,1101029220022000,220]
[10,"بن سعادة","مريم","2010-12-19","غريس","أنثى","1م2","بن عومر","درار","خيرة","ملحقة ويزغت","bensaada","Meriem",7.4,1101029120253100,2531]
[14,"بوعبد الله","هديل بشرى","2011-04-26","معسكر","أنثى","1م2","مختار","دوار","نصيرة","ملحقة ويزغت","Bouabdallh","Hdil bouchra",4.9000000000000004,1101129010181900,1819]
[15,"بومفتاح","حامد","2010-12-09","وادي التاغية","ذكر","1م2","بن عومر","بكدي","ميمونة","ملحقة ويزغت","Boumeftah","Hamed",6.6,1001029220022800,228]
[17,"تبينة","عبد الحق","2011-04-07","غريس","ذكر","1م2","نور الدين",null,"بدرة","ملحقة ويزغت","Tabina","Abdelhak",6,1001129120058300,583]
[20,"درار","إبراهيم الخليل","2009-05-11","وادي التاغية","ذكر","1م2","قويدر","مباركي","ام الجيلالي","ملحقة ويزغت","Derrar","Ibrahim",4.7,1000929220009600,96]
[21,"درار","ياسر","2010-09-01","وادي التاغية","ذكر","1م2","مختار","سبع","فاطيمة الزهراء","ملحقة ويزغت","Derrar","Yasser",7.5,1001029220016100,161]
[24,"دلة","نبيل","2011-05-24","وادي التاغية","ذكر","1م2","عدة","دلة","ام الجيلالي","ملحقة ويزغت","Della","Nabil",5.4,1001129220006900,69]
[25,"دوار","بدرة هاجر","2010-06-22","وادي التاغية","أنثى","1م2","ميلود","فريد","خيرة","ملحقة ويزغت","Douar","Hajer",5.7,1101029220010700,107]
[28,"زلبون","زكرياء","2010-08-12","غريس","ذكر","1م2","قادة","فيتاح","نورة","ملحقة ويزغت","Zelboune","zakaria",5.5,1001029120156000,1560]
[29,"ستار","هشام","2010-08-31","غريس","ذكر","1م2","جمال","بوهي","خيرة","ملحقة ويزغت","Settar","Hichem",4,1001029120176300,1763]
[32,"عبدون","وليد","2010-07-16","غريس","ذكر","1م2","عبد الله","قدوس","فاطمة","ملحقة ويزغت","Abdoune","Walid",7.1,1001029120132200,1322]
[34,"فرعون","محمد","2011-01-02","وادي التاغية","ذكر","1م2","بن صواق","مدرار","زهرة","ملحقة ويزغت","Feraoune","Mohamed",5.9,1001129220000600,6]
[35,"فرعون","منال","2010-11-16","غريس","أنثى","1م2","رشيد","فرعون","مريم","ملحقة ويزغت","Feraoune","Manel",8.8000000000000007,1101029120231700,2317]
[37,"فيجل","نور الهدى","2010-06-21","غريس","أنثى","1م2","محمد","تومي","نورة","ملحقة ويزغت","Fidjel","Nour elhouda",6.8,1101029120112200,1122]
[40,"قرين","نريمان","2011-02-25","معسكر","أنثى","1م2","قديم","بركاك","سميرة","ملحقة ويزغت","Graïne","Narimene",7.9,1101129010085200,852]
[41,"كعبور","آية الرحمن","2011-04-28","وادي التاغية","أنثى","1م2","قدور","قرين","خيرة","ملحقة ويزغت","Kaabour","Aya",8.3000000000000007,1101129220007200,72]
[42,"كعبور","خديجة","2010-04-14","غريس","أنثى","1م2","بغداد","دوار","يمينة","ملحقة ويزغت","Kaabour","Khadidja",6,1101029120064900,649]
[44,"كعبور","مريم","2011-02-02","وادي التاغية","أنثى","1م2","الحبيب","نطاح","قدورية","ملحقة ويزغت","Kaabour","Meriem",7.5,1101129220003000,30]
[47,"وافريغ","بسمة","2010-06-28","معسكر","أنثى","1م2","لحاج","بلهادي","مريم","ملحقة ويزغت","Ouafrigh","Besma",7.9,1101029010248200,2482]
[13,"بوشدة","نوال","2010-07-02","وادي التاغية","أنثى",null,"ميلود","مدرار","فتيحة","ملحقة ويزغت","Bouchedda","Nawal",null,1101029220011700,117]
[4,"بركاك","عبد القادر","2010-07-26","غريس","ذكر","VraiFaux(Gauche([الرقم الوطني];2)=10;\"ذكر\";VraiFaux(Gauche([الرقم الوطني];2)=11;\"أنثى\";\"رقم غير صحيح\"))",null,null,null,"ملحقة ويزغت","Barkak","Abdelkader",null,1001029120132100,1321]
[38,"قدوس","ابراهيم","2010-01-06","وادي التاغية","ذكر",null,"قادة","بركاك","حفيظة","ملحقة ويزغت","Kaddous","Ibrahim",null,1001029220000300,3]
[43,"كعبور","محمد","2006-09-23","وادي التاغية","ذكر",null,"بوزيان","بن سهلة","عينونة","ملحقة ويزغت","Kaabour","Mohamed",null,1000629220018800,188]
[null,null,"المؤسسة","م","ذ","أ"]
[null,null,"المدرسة الابتدائية ويزغت",{"$f":"SUM(E51:F51)","v":47},{"$f":"SUMPRODUCT((K3:K49=\"ملحقة ويزغت\")*(F3:F49=\"ذكر\"))","v":22},{"$f":"SUMPRODUCT((K3:K49=\"ملحقة ويزغت\")*(F3:F49=\"أنثى\"))","v":25}]
[null,null,"المجموع",{"$f":"SUM(D51:D51)","v":47},{"$f":"SUM(E51:E51)","v":22},{"$f":"SUM(F51:F51)","v":25}]
[]
[null,null,"1م1",{"$f":"COUNTIF(G2:G49,\"1م1\")","v":22},{"$f":"SUMPRODUCT((G3:G49=\"1م1\")*(F3:F49=\"ذكر\"))","v":10},{"$f":"SUMPRODUCT((G2:G49=\"1م1\")*(F2:F49=\"أنثى\"))","v":12}]
[null,null,"1م2",{"$f":"COUNTIF(G2:O49,\"1م2\")","v":22},{"$f":"SUMPRODUCT((G2:G49=\"1م2\")*(F2:F49=\"ذكر\"))","v":9},{"$f":"SUMPRODUCT((G2:G49=\"1م2\")*(F2:F49=\"أنثى\"))","v":13}]
[null,null,"المجموع",{"$f":"SUM(D54:D55)","v":44},{"$f":"SUM(E54:E55)","v":19},{"$f":"SUM(F54:F55)","v":25}]

{"sheet":"ورقة1","index":1,"n_rows":33,"n_cols":1,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[400]
[401]
[402]
[403]
[404]
[405]
[406]
[407]
[408]
[409]
[410]
[411]
[412]
[413]
[414]
[415]
[416]
[417]
[418]
[419]
[420]
[421]
[422]
[423]
[424]
[425]
[426]
[427]
[428]
[429]
[430]
[431]
[432]

{"sheet":"1م1","index":2,"n_rows":127,"n_cols":12,"rows_kept":127,"cut":false,"hidden":false,"merged":[]}
["الرقم","الاسم","اللقب","تاريخ الميلاد","مكان الميلاد","الجنس","الأب","الأم","العنوان","المدرسة","المعدل","القسم"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"المؤسسة","م","ذ","أ"]
[null,null,"سيدي علي",{"$f":"COUNTIF(J2:J110,J95)","v":0},{"$f":"SUMPRODUCT((J2:J110=\"سيدي علي\")*(F2:F110=\"ذ\"))","v":0},{"$f":"SUMPRODUCT((J2:J110=\"سيدي علي\")*(F2:F110=\"أ\"))","v":0}]
[null,null,"أولاد بوحلوان",{"$f":"COUNTIF(J2:J110,J101)","v":0},{"$f":"SUMPRODUCT((J2:J110=\"ضياف علي \")*(F2:F110=\"ذ\"))","v":0},{"$f":"SUMPRODUCT((J2:J110=\"ضياف علي \")*(F2:F110=\"أ\"))","v":0}]
[null,null,"سيدي عيسى",{"$f":"COUNTIF(J2:J110,J90)","v":0},{"$f":"SUMPRODUCT((J2:J110=\"سيدي عيسى\")*(F2:F110=\"ذ\"))","v":0},{"$f":"SUMPRODUCT((J2:J110=\"سيدي عيسى\")*(F2:F110=\"أ\"))","v":0}]
[null,null,"المركز",{"$f":"COUNTIF(J2:J110,J100)","v":0},{"$f":"SUMPRODUCT((J2:J110=\"المركز\")*(F2:F110=\"ذ\"))","v":0},{"$f":"SUMPRODUCT((J2:J110=\"المركز\")*(F2:F110=\"أ\"))","v":0}]
[null,null,"المجموع",{"$f":"SUM(D116:D119)","v":0},{"$f":"SUM(E116:E119)","v":0},{"$f":"SUM(F116:F119)","v":0}]
[]
[null,null,"1م1",{"$f":"COUNTIF(L2:L110,1)","v":0},{"$f":"SUMPRODUCT((L2:L110=1)*(F2:F110=\"ذ\"))","v":0},{"$f":"SUMPRODUCT((L2:L110=1)*(F2:F110=\"أ\"))","v":0}]
[null,null,"1م2",{"$f":"COUNTIF(L2:L110,2)","v":0},{"$f":"SUMPRODUCT((L2:L110=2)*(F2:F110=\"ذ\"))","v":0},{"$f":"SUMPRODUCT((L2:L110=2)*(F2:F110=\"أ\"))","v":0}]
[null,null,"1م3",{"$f":"COUNTIF(L2:L110,3)","v":0},{"$f":"SUMPRODUCT((L2:L110=3)*(F2:F110=\"ذ\"))","v":0},{"$f":"SUMPRODUCT((L2:L110=3)*(F2:F110=\"أ\"))","v":0}]
[null,null,"1م4",{"$f":"COUNTIF(L2:L110,4)","v":0},{"$f":"SUMPRODUCT((L2:L110=4)*(F2:F110=\"ذ\"))","v":0},{"$f":"SUMPRODUCT((L2:L110=4)*(F2:F110=\"أ\"))","v":0}]
[null,null,"1م5",{"$f":"COUNTIF(L2:L110,5)","v":0},{"$f":"SUMPRODUCT((L2:L110=5)*(F2:F110=\"ذ\"))","v":0},{"$f":"SUMPRODUCT((L2:L110=5)*(F2:F110=\"أ\"))","v":0}]
[null,null,"المجموع",{"$f":"SUM(D122:D126)","v":0},{"$f":"SUM(E122:E126)","v":0},{"$f":"SUM(F122:F126)","v":0}]

{"sheet":"1م2","index":3,"n_rows":127,"n_cols":12,"rows_kept":127,"cut":false,"hidden":false,"merged":[]}
["الرقم","الاسم","اللقب","تاريخ الميلاد","مكان الميلاد","الجنس","الأب","الأم","العنوان","المدرسة","المعدل","القسم"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"المؤسسة","م","ذ","أ"]
[null,null,"سيدي علي",{"$f":"COUNTIF(J2:J110,J95)","v":0},{"$f":"SUMPRODUCT((J2:J110=\"سيدي علي\")*(F2:F110=\"ذ\"))","v":0},{"$f":"SUMPRODUCT((J2:J110=\"سيدي علي\")*(F2:F110=\"أ\"))","v":0}]
[null,null,"أولاد بوحلوان",{"$f":"COUNTIF(J2:J110,J101)","v":0},{"$f":"SUMPRODUCT((J2:J110=\"ضياف علي \")*(F2:F110=\"ذ\"))","v":0},{"$f":"SUMPRODUCT((J2:J110=\"ضياف علي \")*(F2:F110=\"أ\"))","v":0}]
[null,null,"سيدي عيسى",{"$f":"COUNTIF(J2:J110,J90)","v":0},{"$f":"SUMPRODUCT((J2:J110=\"سيدي عيسى\")*(F2:F110=\"ذ\"))","v":0},{"$f":"SUMPRODUCT((J2:J110=\"سيدي عيسى\")*(F2:F110=\"أ\"))","v":0}]
[null,null,"المركز",{"$f":"COUNTIF(J2:J110,J100)","v":0},{"$f":"SUMPRODUCT((J2:J110=\"المركز\")*(F2:F110=\"ذ\"))","v":0},{"$f":"SUMPRODUCT((J2:J110=\"المركز\")*(F2:F110=\"أ\"))","v":0}]
[null,null,"المجموع",{"$f":"SUM(D116:D119)","v":0},{"$f":"SUM(E116:E119)","v":0},{"$f":"SUM(F116:F119)","v":0}]
[]
[null,null,"1م1",{"$f":"COUNTIF(L2:L110,1)","v":0},{"$f":"SUMPRODUCT((L2:L110=1)*(F2:F110=\"ذ\"))","v":0},{"$f":"SUMPRODUCT((L2:L110=1)*(F2:F110=\"أ\"))","v":0}]
[null,null,"1م2",{"$f":"COUNTIF(L2:L110,2)","v":0},{"$f":"SUMPRODUCT((L2:L110=2)*(F2:F110=\"ذ\"))","v":0},{"$f":"SUMPRODUCT((L2:L110=2)*(F2:F110=\"أ\"))","v":0}]
[null,null,"1م3",{"$f":"COUNTIF(L2:L110,3)","v":0},{"$f":"SUMPRODUCT((L2:L110=3)*(F2:F110=\"ذ\"))","v":0},{"$f":"SUMPRODUCT((L2:L110=3)*(F2:F110=\"أ\"))","v":0}]
[null,null,"1م4",{"$f":"COUNTIF(L2:L110,4)","v":0},{"$f":"SUMPRODUCT((L2:L110=4)*(F2:F110=\"ذ\"))","v":0},{"$f":"SUMPRODUCT((L2:L110=4)*(F2:F110=\"أ\"))","v":0}]
[null,null,"1م5",{"$f":"COUNTIF(L2:L110,5)","v":0},{"$f":"SUMPRODUCT((L2:L110=5)*(F2:F110=\"ذ\"))","v":0},{"$f":"SUMPRODUCT((L2:L110=5)*(F2:F110=\"أ\"))","v":0}]
[null,null,"المجموع",{"$f":"SUM(D122:D126)","v":0},{"$f":"SUM(E122:E126)","v":0},{"$f":"SUM(F122:F126)","v":0}]