{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ورقة3","ورقة1","ورقة2"],"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":"ورقة3","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"ورقة1","index":1,"n_rows":103,"n_cols":22,"rows_kept":103,"cut":false,"hidden":false,"merged":[[15,5,15,7],[15,8,15,10],[14,11,15,15],[13,5,13,7],[13,8,13,10],[13,11,13,13],[13,14,13,15],[14,5,14,7],[14,8,14,10],[12,5,12,7],[12,8,12,10],[12,11,12,13],[12,14,12,15],[0,18,2,18],[0,19,2,19],[0,21,2,21],[0,20,2,20],[6,5,6,15],[0,17,2,17],[7,5,7,15],[8,5,11,15],[0,1,2,1],[0,0,2,0],[0,3,2,3],[5,13,5,14],[5,8,5,12],[4,8,4,12],[1,13,2,13],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[1,15,2,15],[1,10,2,10],[1,11,2,11],[1,12,2,12],[1,14,2,14]]}
["م","ألآسم","درجة لغة عربية","التقدير",null,null,null,null,null,null,null,null,null,null,null,null,null,"م","الاسم","النوع",null,"كود النوع"]
[null,null,100,null,null,"متقدم","غ","حاضر","ممتاز","جيد جدا","جيد","مقبول ","دون المستوى","ناجح","جملة","نسبة النجاح"]
[null,null,50]
[1,"A1",100,{"$f":"IF(C4>=85,\"ممتاز\",IF(C4>=75,\"جيد جدا\",IF(C4>=65,\"جيد\",IF(C4>=50,\"مقبول\",IF(C4<50,\"دون المستوى\",\"\")))))","v":"ممتاز"},null,null,null,null,null,null,null,null,null,null,null,null,null,1,"A1"]
[2,"A2",99,{"$f":"IF(C5>=85,\"ممتاز\",IF(C5>=75,\"جيد جدا\",IF(C5>=65,\"جيد\",IF(C5>=50,\"مقبول\",IF(C5<50,\"دون المستوى\",\"\")))))","v":"ممتاز"},null,null,null,null,null,null,null,null,null,null,null,null,null,2,"A2"]
[3,"A3",89,"ممتاز",null,"Max",null,null,"Countif",null,null,null,null,"Sum",null,"Roundup",null,3,"A3"]
[4,"A4",74,"جيد",null,"الدرس الخامس لشرح الاكسيل",null,null,null,null,null,null,null,null,null,null,null,4,"A4"]
[5,"A5",85,"ممتاز",null,"تمرين",null,null,null,null,null,null,null,null,null,null,null,5,"A5"]
[6,"A6",54,"مقبول",null,"فى الجدول الموضح باليسار ضع فى كود النوع 1 للولد و 2 للبنت وباستخدام قاعدة IF  كما تعلمت فى الدرس الثانى وفى النوع حدد الولد والبنت وانشاء جدول كالموضح بالاسفل حدد المطلوب بأستخدام الدوال التى درستها",null,null,null,null,null,null,null,null,null,null,null,6,"A6"]
[7,"A7",12,"دون المستوى",null,null,null,null,null,null,null,null,null,null,null,null,null,7,"A7"]
[8,"A8",88,"ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,8,"A8"]
[9,"A9",78,"جيد جدا",null,null,null,null,null,null,null,null,null,null,null,null,null,9,"A9"]
[10,"A10",74,"جيد",null,"متقدم",null,null,"عدد الاولاد",null,null,"عدد البنات",null,null,"الجملة",null,null,10,"A10"]
[11,"A11",62,"مقبول",null,null,null,null,null,null,null,null,null,null,null,null,null,11,"A11"]
[12,"A12",65,"جيد",null,"نسبة البنين",null,null,"نسبة البنات",null,null,"النسبة تحسب بالنسبة لعدد المتقدمين",null,null,null,null,null,12,"A12"]
[13,"A13",86,"ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,13,"A13"]
[14,"A14",69,"جيد",null,null,null,null,null,null,null,null,null,null,null,null,null,14,"A14"]
[15,"A15",69,"جيد",null,null,null,null,null,null,null,null,null,null,null,null,null,15,"A15"]
[16,"A16",69,"جيد",null,null,null,null,null,null,null,null,null,null,null,null,null,16,"A16"]
[17,"A17",95,"ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,17,"A17"]
[18,"A18",95,"ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,18,"A18"]
[19,"A19",95,"ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,19,"A19"]
[20,"A20",98,"ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,20,"A20"]
[21,"A21",95,"ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,21,"A21"]
[22,"A22",98,"ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,22,"A22"]
[23,"A23",94,"ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,23,"A23"]
[24,"A24",94,"ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,24,"A24"]
[25,"A25",92,"ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,25,"A25"]
[26,"A26",93,"ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,26,"A26"]
[27,"A27",86,"ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,27,"A27"]
[28,"A28",87,"ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,28,"A28"]
[29,"A29",74,"جيد",null,null,null,null,null,null,null,null,null,null,null,null,null,29,"A29"]
[30,"A30",75,"جيد جدا",null,null,null,null,null,null,null,null,null,null,null,null,null,30,"A30"]
[31,"A31",71,"جيد",null,null,null,null,null,null,null,null,null,null,null,null,null,31,"A31"]
[32,"A32",96,"ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,32,"A32"]
[33,"A33",96,"ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,33,"A33"]
[34,"A34",95,"ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,34,"A34"]
[35,"A35",92,"ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,35,"A35"]
[36,"A36",90,"ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,36,"A36"]
[37,"A37",23,"دون المستوى",null,null,null,null,null,null,null,null,null,null,null,null,null,37,"A37"]
[38,"A38",54,"مقبول",null,null,null,null,null,null,null,null,null,null,null,null,null,38,"A38"]
[39,"A39",85,"ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,39,"A39"]
[40,"A40",85,"ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,40,"A40"]
[41,"A41",84,"جيد جدا",null,null,null,null,null,null,null,null,null,null,null,null,null,41,"A41"]
[42,"A42",84,"جيد جدا",null,null,null,null,null,null,null,null,null,null,null,null,null,42,"A42"]
[43,"A43",84,"جيد جدا",null,null,null,null,null,null,null,null,null,null,null,null,null,43,"A43"]
[44,"A44",85,"ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,44,"A44"]
[45,"A45",85,"ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,45,"A45"]
[46,"A46",87,"ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,46,"A46"]
[47,"A47",65,"جيد",null,null,null,null,null,null,null,null,null,null,null,null,null,47,"A47"]
[48,"A48",64,"مقبول",null,null,null,null,null,null,null,null,null,null,null,null,null,48,"A48"]
[49,"A49",58,"مقبول",null,null,null,null,null,null,null,null,null,null,null,null,null,49,"A49"]
[50,"A50",59,"مقبول",null,null,null,null,null,null,null,null,null,null,null,null,null,50,"A50"]
[51,"A51",98,"ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,51,"A51"]
[52,"A52",97,"ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,52,"A52"]
[53,"A53",95,"ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,53,"A53"]
[54,"A54",95,"ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,54,"A54"]
[55,"A55",88,"ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,55,"A55"]
[56,"A56","غ","ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,56,"A56"]
[57,"A57",66,"جيد",null,null,null,null,null,null,null,null,null,null,null,null,null,57,"A57"]
[58,"A58",96,"ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,58,"A58"]
[59,"A59",98,"ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,59,"A59"]
[60,"A60",98,"ممتاز",null,null,null,null,null,null,null,null,null,null,null,null,null,60,"A60"]
[61,"A61",97,"ممتاز"]
[62,"A62",97,"ممتاز"]
[63,"A63",97,"ممتاز"]
[64,"A64",98,"ممتاز"]
[65,"A65",94,"ممتاز"]
[66,"A66",94,{"$f":"IF(C69>=85,\"ممتاز\",IF(C69>=75,\"جيد جدا\",IF(C69>=65,\"جيد\",IF(C69>=50,\"مقبول\",IF(C69<50,\"دون المستوى\",\"\")))))","v":"ممتاز"}]
[67,"A67",84,"جيد جدا"]
[68,"A68",81,"جيد جدا"]
[69,"A69",81,"جيد جدا"]
[70,"A70",85,"ممتاز"]
[71,"A71",84,"جيد جدا"]
[72,"A72",87,"ممتاز"]
[73,"A73",87,"ممتاز"]
[74,"A74",85,"ممتاز"]
[75,"A75",84,"جيد جدا"]
[76,"A76",85,"ممتاز"]
[77,"A77",81,"جيد جدا"]
[78,"A78",82,"جيد جدا"]
[79,"A79",94,"ممتاز"]
[80,"A80",45,"دون المستوى"]
[81,"A81","غ","ممتاز"]
[82,"A82",82,"جيد جدا"]
[83,"A83",66,"جيد"]
[84,"A84",65,"جيد"]
[85,"A85",63,"مقبول"]
[86,"A86",68,"جيد"]
[87,"A87",68,"جيد"]
[88,"A88",87,"ممتاز"]
[89,"A89",87,"ممتاز"]
[90,"A90",89,"ممتاز"]
[91,"A91",89,"ممتاز"]
[92,"A92",89,"ممتاز"]
[93,"A93",58,"مقبول"]
[94,"A94",58,"مقبول"]
[95,"A95",54,"مقبول"]
[96,"A96",57,"مقبول"]
[97,"A97",59,"مقبول"]
[98,"A98",95,"ممتاز"]
[99,"A99",95,"ممتاز"]
[100,"A100",86,"ممتاز"]

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