{"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":52,"n_cols":8,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["الرقم","اللقب","الاسم","تاريخ الميلاد","مكان الميلاد","الجنس","الرقم الوطني"]
[1,"بحار","وصال","2011-01-27","وادي التاغية","VraiFaux(Gauche([الرقم الوطني];2)=10;\"ذ\";VraiFaux(Gauche([الرقم الوطني];2)=11;\"أ\";\"رقم غير صحيح\"))",1101129220002700,1]
[2,"بركاك","آمينة","2011-01-02","وادي التاغية","أنثى",1101129220000500,3]
[5,"بركاك","عبد القادر","2010-07-16","غريس","ذكر",1001029120140900,1]
[7,"بركاك","نسرين","2011-06-14","غريس","أنثى",1101129220098900,1]
[9,"بن ديخة","نور الهدى","2011-01-05","تغنيف","أنثى",1101129060006800,1]
[11,"بن سهلة","رضوان","2010-06-16","غريس","ذكر",1001029120109500,2]
[12,"بورزين","عبد القادر","2011-03-11","معسكر","ذكر",1001129010105700,1]
[16,"بومفتاح","دعاء","2011-04-23","وهران","أنثى",1101131010564100,3]
[18,"تبينة","فريدة","2010-06-18","وادي التاغية","أنثى",1101029220010600,2]
[19,"تبينة","كلثوم","2010-09-27","غريس","أنثى",1101029120197200,3]
[22,"دلة","محي الدين","2008-11-16","غريس","ذكر",1000829120171100,2]
[23,"دلة","ملوكة","2010-09-16","معسكر","أنثى",1101029010384200,1]
[26,"دوار","عونية","2010-09-20","وادي التاغية","أنثى",1101029220017100,2]
[27,"زعتر","محمد الأمين","2011-04-06","وادي التاغية","ذكر",1001129220006200,1]
[30,"عبدون","بهاء الدين هيثم","2010-11-14","ادرار","ذكر",1001001010197700,1]
[31,"عبدون","علاء الدين","2010-10-20","غريس","ذكر",1001029120212900,2]
[33,"فرعون","أسماء","2010-07-14","غريس","أنثى",1101029120130500,1]
[36,"فرعون","نور الهدى","2010-10-12","وادي التاغية","أنثى",1101029220018700,2]
[39,"قدوس","جيلالي","2010-05-18","وادي التاغية","ذكر",1001029220009400,3]
[45,"مدرار","حياة","2010-07-23","معسكر","أنثى",1101029010286200,2]
[46,"نعاس","محمد","2010-10-07","وهران","ذكر",1401031011656000,1]
[48,"وافريغ","وليد","2009-09-29","غريس","ذكر",1000929120158700,2]
[3,"بركاك","دعاء","2010-08-01","غريس","أنثى",1101029120146100,2]
[6,"بركاك","فاطيمة","2010-11-29","وادي التاغية","أنثى",1101029220021400,3]
[8,"بركاك","وئام فاطمة الزهراء","2010-12-02","وادي التاغية","أنثى",1101029220022000,3]
[10,"بن سعادة","مريم","2010-12-19","غريس","أنثى",1101029120253100,2]
[14,"بوعبد الله","هديل بشرى","2011-04-26","معسكر","أنثى",1101129010181900,2]
[15,"بومفتاح","حامد","2010-12-09","وادي التاغية","ذكر",1001029220022800,3]
[17,"تبينة","عبد الحق","2011-04-07","غريس","ذكر",1001129120058300,2]
[20,"درار","إبراهيم الخليل","2009-05-11","وادي التاغية","ذكر",1000929220009600,1]
[21,"درار","ياسر","2010-09-01","وادي التاغية","ذكر",1001029220016100,1]
[24,"دلة","نبيل","2011-05-24","وادي التاغية","ذكر",1001129220006900,3]
[25,"دوار","بدرة هاجر","2010-06-22","وادي التاغية","أنثى",1101029220010700,3]
[28,"زلبون","زكرياء","2010-08-12","غريس","ذكر",1001029120156000,3]
[29,"ستار","هشام","2010-08-31","غريس","ذكر",1001029120176300,3]
[32,"عبدون","وليد","2010-07-16","غريس","ذكر",1001029120132200,2]
[34,"فرعون","محمد","2011-01-02","وادي التاغية","ذكر",1001129220000600,1]
[35,"فرعون","منال","2010-11-16","غريس","أنثى",1101029120231700,2]
[37,"فيجل","نور الهدى","2010-06-21","غريس","أنثى",1101029120112200,3]
[40,"قرين","نريمان","2011-02-25","معسكر","أنثى",1101129010085200,1]
[41,"كعبور","آية الرحمن","2011-04-28","وادي التاغية","أنثى",1101129220007200,3]
[42,"كعبور","خديجة","2010-04-14","غريس","أنثى",1101029120064900,1]
[44,"كعبور","مريم","2011-02-02","وادي التاغية","أنثى",1101129220003000,3]
[47,"وافريغ","بسمة","2010-06-28","معسكر","أنثى",1101029010248200,1]
[null,null,"المؤسسة","م","ذ","أ"]
[null,null,"المدرسة الابتدائية ويزغت",{"$f":"SUM(E47:F47)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=\"ملحقة ويزغت\")*(F2:F45=\"ذكر\"))","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=\"ملحقة ويزغت\")*(F2:F45=\"أنثى\"))","v":{"$error":"#REF!"}}]
[null,null,"المجموع",{"$f":"SUM(D47:D47)","v":{"$error":"#REF!"}},{"$f":"SUM(E47:E47)","v":{"$error":"#REF!"}},{"$f":"SUM(F47:F47)","v":{"$error":"#REF!"}}]
[]
[null,null,"1م1",{"$f":"COUNTIF(#REF!,\"1م1\")","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=\"1م1\")*(F2:F45=\"ذكر\"))","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=\"1م1\")*(F2:F45=\"أنثى\"))","v":{"$error":"#REF!"}}]
[null,null,"1م2",{"$f":"COUNTIF(G2:G45,\"1م2\")","v":0},{"$f":"SUMPRODUCT((#REF!=\"1م2\")*(F2:F45=\"ذكر\"))","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT((#REF!=\"1م2\")*(F2:F45=\"أنثى\"))","v":{"$error":"#REF!"}}]
[null,null,"المجموع",{"$f":"SUM(D50:D51)","v":{"$error":"#REF!"}},{"$f":"SUM(E50:E51)","v":{"$error":"#REF!"}},{"$f":"SUM(F50:F51)","v":{"$error":"#REF!"}}]

{"sheet":"ورقة1","index":1,"n_rows":44,"n_cols":1,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[195]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]

{"sheet":"1م1","index":2,"n_rows":127,"n_cols":12,"rows_kept":127,"cut":false,"hidden":false,"merged":[]}
["الرقم","الاسم","اللقب","تاريخ الميلاد","مكان الميلاد","الجنس","الأب","الأم","العنوان","المدرسة","المعدل","القسم"]
[1,"بحار","وصال","2011-01-27","وادي التاغية","أنثى","1م1","بن صواق","بوعناني","غريسية","ملحقة ويزغت","Behar"]
[2,"بركاك","آمينة","2011-01-02","وادي التاغية","أنثى","1م1","قادة","مزوار","فظيلة","ملحقة ويزغت","Barkak"]
[5,"بركاك","عبد القادر","2010-07-16","غريس","ذكر","1م1",null,null,null,"ملحقة ويزغت","Barkak"]
[7,"بركاك","نسرين","2011-06-14","غريس","أنثى","1م1","رشيد","بركاك","ستي","ملحقة ويزغت","Barkak"]
[9,"بن ديخة","نور الهدى","2011-01-05","تغنيف","أنثى","1م1","بلحول",null,"سميرة","ملحقة ويزغت","Bendikha"]
[11,"بن سهلة","رضوان","2010-06-16","غريس","ذكر","1م1","بن علي","بن سهلة","فاطمة","ملحقة ويزغت","bensahla"]
[12,"بورزين","عبد القادر","2011-03-11","معسكر","ذكر","1م1","محمد","بورزين","زهرة","ملحقة ويزغت","Bourzine"]
[16,"بومفتاح","دعاء","2011-04-23","وهران","أنثى","1م1","بن صواق",null,"نادية","ملحقة ويزغت","Boumeftah"]
[18,"تبينة","فريدة","2010-06-18","وادي التاغية","أنثى","1م1","جيلالي","مدرار","فاطمة","ملحقة ويزغت","Tabina"]
[19,"تبينة","كلثوم","2010-09-27","غريس","أنثى","1م1","بن صواق","زواية","فظيلة","ملحقة ويزغت","Tabina"]
[22,"دلة","محي الدين","2008-11-16","غريس","ذكر","1م1","عدة","دلة","ام الجيلالي","ملحقة ويزغت","Della"]
[23,"دلة","ملوكة","2010-09-16","معسكر","أنثى","1م1","مجادي","باعو","دحاوية","ملحقة ويزغت","Della"]
[26,"دوار","عونية","2010-09-20","وادي التاغية","أنثى","1م1","مختار","دوار","خيرة","ملحقة ويزغت","Douar"]
[27,"زعتر","محمد الأمين","2011-04-06","وادي التاغية","ذكر","1م1","علي","ميلودي","خديجة","ملحقة ويزغت","Zaâter"]
[30,"عبدون","بهاء الدين هيثم","2010-11-14","ادرار","ذكر","1م1","بن عومر","عبدون","فتيحة","ملحقة ويزغت","Abdoune"]
[31,"عبدون","علاء الدين","2010-10-20","غريس","ذكر","1م1","قديم","قدوس","سميرة","ملحقة ويزغت","Abdoune"]
[33,"فرعون","أسماء","2010-07-14","غريس","أنثى","1م1","ماحي","فرعون","فاطيمة","ملحقة ويزغت","Feraoune"]
[36,"فرعون","نور الهدى","2010-10-12","وادي التاغية","أنثى","1م1","هواري","دوار","عونية","ملحقة ويزغت","Feraoune"]
[39,"قدوس","جيلالي","2010-05-18","وادي التاغية","ذكر","1م1","بن علي","بلهادي","يمينة","ملحقة ويزغت","Kaddous"]
[45,"مدرار","حياة","2010-07-23","معسكر","أنثى","1م1","بن عومر","قرين","نوال","ملحقة ويزغت","Medrar"]
[46,"نعاس","محمد","2010-10-07","وهران","ذكر","1م1","عبد القادر","بركاك","عونية","ملحقة ويزغت","Naas"]
[48,"وافريغ","وليد","2009-09-29","غريس","ذكر","1م1","حبيب","بركاك",null,"ملحقة ويزغت","Ouafrigh"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":[]}
["الرقم","الاسم","اللقب","تاريخ الميلاد","مكان الميلاد","الجنس","الأب","الأم","العنوان","المدرسة","المعدل","القسم"]
[3,"بركاك","دعاء","2010-08-01","غريس","أنثى","1م2","قادة","فيجل","كريمة","ملحقة ويزغت","Barkak"]
[6,"بركاك","فاطيمة","2010-11-29","وادي التاغية","أنثى","1م2","عبد القادر","خنثر","كريمة","ملحقة ويزغت","Barkak"]
[8,"بركاك","وئام فاطمة الزهراء","2010-12-02","وادي التاغية","أنثى","1م2","بن صواق","بركاك","محتارية","ملحقة ويزغت","Barkak"]
[10,"بن سعادة","مريم","2010-12-19","غريس","أنثى","1م2","بن عومر","درار","خيرة","ملحقة ويزغت","bensaada"]
[14,"بوعبد الله","هديل بشرى","2011-04-26","معسكر","أنثى","1م2","مختار","دوار","نصيرة","ملحقة ويزغت","Bouabdallh"]
[15,"بومفتاح","حامد","2010-12-09","وادي التاغية","ذكر","1م2","بن عومر","بكدي","ميمونة","ملحقة ويزغت","Boumeftah"]
[17,"تبينة","عبد الحق","2011-04-07","غريس","ذكر","1م2","نور الدين",null,"بدرة","ملحقة ويزغت","Tabina"]
[20,"درار","إبراهيم الخليل","2009-05-11","وادي التاغية","ذكر","1م2","قويدر","مباركي","ام الجيلالي","ملحقة ويزغت","Derrar"]
[21,"درار","ياسر","2010-09-01","وادي التاغية","ذكر","1م2","مختار","سبع","فاطيمة الزهراء","ملحقة ويزغت","Derrar"]
[24,"دلة","نبيل","2011-05-24","وادي التاغية","ذكر","1م2","عدة","دلة","ام الجيلالي","ملحقة ويزغت","Della"]
[25,"دوار","بدرة هاجر","2010-06-22","وادي التاغية","أنثى","1م2","ميلود","فريد","خيرة","ملحقة ويزغت","Douar"]
[28,"زلبون","زكرياء","2010-08-12","غريس","ذكر","1م2","قادة","فيتاح","نورة","ملحقة ويزغت","Zelboune"]
[29,"ستار","هشام","2010-08-31","غريس","ذكر","1م2","جمال","بوهي","خيرة","ملحقة ويزغت","Settar"]
[32,"عبدون","وليد","2010-07-16","غريس","ذكر","1م2","عبد الله","قدوس","فاطمة","ملحقة ويزغت","Abdoune"]
[34,"فرعون","محمد","2011-01-02","وادي التاغية","ذكر","1م2","بن صواق","مدرار","زهرة","ملحقة ويزغت","Feraoune"]
[35,"فرعون","منال","2010-11-16","غريس","أنثى","1م2","رشيد","فرعون","مريم","ملحقة ويزغت","Feraoune"]
[37,"فيجل","نور الهدى","2010-06-21","غريس","أنثى","1م2","محمد","تومي","نورة","ملحقة ويزغت","Fidjel"]
[40,"قرين","نريمان","2011-02-25","معسكر","أنثى","1م2","قديم","بركاك","سميرة","ملحقة ويزغت","Graïne"]
[41,"كعبور","آية الرحمن","2011-04-28","وادي التاغية","أنثى","1م2","قدور","قرين","خيرة","ملحقة ويزغت","Kaabour"]
[42,"كعبور","خديجة","2010-04-14","غريس","أنثى","1م2","بغداد","دوار","يمينة","ملحقة ويزغت","Kaabour"]
[44,"كعبور","مريم","2011-02-02","وادي التاغية","أنثى","1م2","الحبيب","نطاح","قدورية","ملحقة ويزغت","Kaabour"]
[47,"وافريغ","بسمة","2010-06-28","معسكر","أنثى","1م2","لحاج","بلهادي","مريم","ملحقة ويزغت","Ouafrigh"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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}]