{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ورقة1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"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":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["ت","رقم قيده","اسم التلميذ","الصف والشعبة","الجنس","الاسلامية*","العربية*","الرياضيات*","العلوم*","الفنية والنشيد*","الرياضة*","الاجتماعيات*","النتيجة*"]
[{"$f":"COUNTIF($D$5:D5,D5)","v":1},{"$f":"IFERROR(IF($DF5=\"\",\"\",INDEX('[1]بيانات التلاميذ'!$C$16:$C$597,MATCH($DF5,'[1]بيانات التلاميذ'!$A$16:$A$597,0))),\"\")","v":""},"احمد1",{"$f":"IFERROR(IF($DF5=\"\",\"\",INDEX('[1]بيانات التلاميذ'!$F$16:$F$597,MATCH($DF5,'[1]بيانات التلاميذ'!$A$16:$A$597,0))),\"\")","v":""},"ذكر",10,10,10,10,10,10,null,{"$f":"IF(COUNTIF(F5:L5,\"<>\")<6,\"\",IF(COUNTIF(F5:L5,\"صفر\")>=6,IF($E5=\"ذكر\",\"غائب\",\"غائبة\"),IF(COUNTIF(F5:L5,\"<5\")+COUNTIF(F5:L5,\"صفر\")>=3,IF($E5=\"ذكر\",\"راسب\",\"راسبة\"),IF(COUNTIF(F5:L5,\"<5\")+COUNTIF(F5:L5,\"غائب\")=1,IF($E5=\"ذكر\",\"مكمل\",\"مكملة\"),IF(COUNTIF(F5:L5,\"<5\")+COUNTIF(F5:L5,\"غائب\")=2,IF($E5=\"ذكر\",\"مكمل\",\"مكملة\"),IF($E5=\"ذكر\",\"ناجح\",\"ناجحة\"))))))","v":"ناجح"},{"$f":"IF(C5=\"\",\"\",IF(M5=\"ناجحة\",\"ناجح\",IF(M5=\"راسبة\",\"راسب\",IF(M5=\"غائبة\",\"غائب\",IF(M5=\"مكملة\",\"مكمل\",M5)))))","v":"ناجح"}]
[{"$f":"COUNTIF($D$5:D6,D6)","v":2},{"$f":"IFERROR(IF($DF6=\"\",\"\",INDEX('[1]بيانات التلاميذ'!$C$16:$C$597,MATCH($DF6,'[1]بيانات التلاميذ'!$A$16:$A$597,0))),\"\")","v":""},"احمد2",{"$f":"IFERROR(IF($DF6=\"\",\"\",INDEX('[1]بيانات التلاميذ'!$F$16:$F$597,MATCH($DF6,'[1]بيانات التلاميذ'!$A$16:$A$597,0))),\"\")","v":""},"ذكر",10,10,10,10,10,10,null,{"$f":"IF(COUNTIF(F6:L6,\"<>\")<6,\"\",IF(COUNTIF(F6:L6,\"صفر\")>=6,IF($E6=\"ذكر\",\"غائب\",\"غائبة\"),IF(COUNTIF(F6:L6,\"<5\")+COUNTIF(F6:L6,\"صفر\")>=3,IF($E6=\"ذكر\",\"راسب\",\"راسبة\"),IF(COUNTIF(F6:L6,\"<5\")+COUNTIF(F6:L6,\"غائب\")=1,IF($E6=\"ذكر\",\"مكمل\",\"مكملة\"),IF(COUNTIF(F6:L6,\"<5\")+COUNTIF(F6:L6,\"غائب\")=2,IF($E6=\"ذكر\",\"مكمل\",\"مكملة\"),IF($E6=\"ذكر\",\"ناجح\",\"ناجحة\"))))))","v":"ناجح"},{"$f":"IF(C6=\"\",\"\",IF(M6=\"ناجحة\",\"ناجح\",IF(M6=\"راسبة\",\"راسب\",IF(M6=\"غائبة\",\"غائب\",IF(M6=\"مكملة\",\"مكمل\",M6)))))","v":"ناجح"}]
[{"$f":"COUNTIF($D$5:D7,D7)","v":3},{"$f":"IFERROR(IF($DF7=\"\",\"\",INDEX('[1]بيانات التلاميذ'!$C$16:$C$597,MATCH($DF7,'[1]بيانات التلاميذ'!$A$16:$A$597,0))),\"\")","v":""},"احمد3",{"$f":"IFERROR(IF($DF7=\"\",\"\",INDEX('[1]بيانات التلاميذ'!$F$16:$F$597,MATCH($DF7,'[1]بيانات التلاميذ'!$A$16:$A$597,0))),\"\")","v":""},"ذكر",10,10,10,10,10,10,null,{"$f":"IF(COUNTIF(F7:L7,\"<>\")<6,\"\",IF(COUNTIF(F7:L7,\"صفر\")>=6,IF($E7=\"ذكر\",\"غائب\",\"غائبة\"),IF(COUNTIF(F7:L7,\"<5\")+COUNTIF(F7:L7,\"صفر\")>=3,IF($E7=\"ذكر\",\"راسب\",\"راسبة\"),IF(COUNTIF(F7:L7,\"<5\")+COUNTIF(F7:L7,\"غائب\")=1,IF($E7=\"ذكر\",\"مكمل\",\"مكملة\"),IF(COUNTIF(F7:L7,\"<5\")+COUNTIF(F7:L7,\"غائب\")=2,IF($E7=\"ذكر\",\"مكمل\",\"مكملة\"),IF($E7=\"ذكر\",\"ناجح\",\"ناجحة\"))))))","v":"ناجح"},"ناجح"]
[{"$f":"COUNTIF($D$5:D8,D8)","v":4},{"$f":"IFERROR(IF($DF8=\"\",\"\",INDEX('[1]بيانات التلاميذ'!$C$16:$C$597,MATCH($DF8,'[1]بيانات التلاميذ'!$A$16:$A$597,0))),\"\")","v":""},"احمد4",{"$f":"IFERROR(IF($DF8=\"\",\"\",INDEX('[1]بيانات التلاميذ'!$F$16:$F$597,MATCH($DF8,'[1]بيانات التلاميذ'!$A$16:$A$597,0))),\"\")","v":""},"ذكر",6,5,4,8,9,10,null,"مكمل","مكمل"]
[{"$f":"COUNTIF($D$5:D9,D9)","v":5},{"$f":"IFERROR(IF($DF9=\"\",\"\",INDEX('[1]بيانات التلاميذ'!$C$16:$C$597,MATCH($DF9,'[1]بيانات التلاميذ'!$A$16:$A$597,0))),\"\")","v":""},"احمد5",{"$f":"IFERROR(IF($DF9=\"\",\"\",INDEX('[1]بيانات التلاميذ'!$F$16:$F$597,MATCH($DF9,'[1]بيانات التلاميذ'!$A$16:$A$597,0))),\"\")","v":""},"ذكر",10,10,10,10,10,10,null,"ناجح","ناجح"]
[{"$f":"COUNTIF($D$5:D10,D10)","v":6},{"$f":"IFERROR(IF($DF10=\"\",\"\",INDEX('[1]بيانات التلاميذ'!$C$16:$C$597,MATCH($DF10,'[1]بيانات التلاميذ'!$A$16:$A$597,0))),\"\")","v":""},"احمد6",{"$f":"IFERROR(IF($DF10=\"\",\"\",INDEX('[1]بيانات التلاميذ'!$F$16:$F$597,MATCH($DF10,'[1]بيانات التلاميذ'!$A$16:$A$597,0))),\"\")","v":""},"ذكر",10,10,8,9,10,10,null,"ناجح","ناجح"]
[{"$f":"COUNTIF($D$5:D11,D11)","v":7},{"$f":"IFERROR(IF($DF11=\"\",\"\",INDEX('[1]بيانات التلاميذ'!$C$16:$C$597,MATCH($DF11,'[1]بيانات التلاميذ'!$A$16:$A$597,0))),\"\")","v":""},"اسماء1",{"$f":"IFERROR(IF($DF11=\"\",\"\",INDEX('[1]بيانات التلاميذ'!$F$16:$F$597,MATCH($DF11,'[1]بيانات التلاميذ'!$A$16:$A$597,0))),\"\")","v":""},"انثى",4,4,4,7,8,8,null,"راسبة","راسب"]
[{"$f":"COUNTIF($D$5:D12,D12)","v":8},{"$f":"IFERROR(IF($DF12=\"\",\"\",INDEX('[1]بيانات التلاميذ'!$C$16:$C$597,MATCH($DF12,'[1]بيانات التلاميذ'!$A$16:$A$597,0))),\"\")","v":""},"اسماء2",{"$f":"IFERROR(IF($DF12=\"\",\"\",INDEX('[1]بيانات التلاميذ'!$F$16:$F$597,MATCH($DF12,'[1]بيانات التلاميذ'!$A$16:$A$597,0))),\"\")","v":""},"انثى",5,5,5,7,8,8,null,"ناجحة","ناجح"]
[{"$f":"COUNTIF($D$5:D13,D13)","v":9},{"$f":"IFERROR(IF($DF13=\"\",\"\",INDEX('[1]بيانات التلاميذ'!$C$16:$C$597,MATCH($DF13,'[1]بيانات التلاميذ'!$A$16:$A$597,0))),\"\")","v":""},"اسماء3",{"$f":"IFERROR(IF($DF13=\"\",\"\",INDEX('[1]بيانات التلاميذ'!$F$16:$F$597,MATCH($DF13,'[1]بيانات التلاميذ'!$A$16:$A$597,0))),\"\")","v":""},"انثى",4,4,4,7,8,8,null,"راسبة","راسب"]
[{"$f":"COUNTIF($D$5:D14,D14)","v":10},{"$f":"IFERROR(IF($DF14=\"\",\"\",INDEX('[1]بيانات التلاميذ'!$C$16:$C$597,MATCH($DF14,'[1]بيانات التلاميذ'!$A$16:$A$597,0))),\"\")","v":""},"اسماء4",{"$f":"IFERROR(IF($DF14=\"\",\"\",INDEX('[1]بيانات التلاميذ'!$F$16:$F$597,MATCH($DF14,'[1]بيانات التلاميذ'!$A$16:$A$597,0))),\"\")","v":""},"انثى",5,4,5,8,8,10,null,"مكملة","مكمل"]
[{"$f":"COUNTIF($D$5:D15,D15)","v":11},{"$f":"IFERROR(IF($DF15=\"\",\"\",INDEX('[1]بيانات التلاميذ'!$C$16:$C$597,MATCH($DF15,'[1]بيانات التلاميذ'!$A$16:$A$597,0))),\"\")","v":""},"اسماء5",{"$f":"IFERROR(IF($DF15=\"\",\"\",INDEX('[1]بيانات التلاميذ'!$F$16:$F$597,MATCH($DF15,'[1]بيانات التلاميذ'!$A$16:$A$597,0))),\"\")","v":""},"انثى",7,4,6,8,8,9,null,"مكملة","مكمل"]