{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["STName","Monthly1","MidYear","Monthly2","FinalYear","الشهادة"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":12,"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":"STName","index":0,"n_rows":36,"n_cols":17,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,17],[1,8,1,17],[1,0,1,7],[2,16,2,17],[2,13,2,15],[2,10,2,11],[2,7,2,8]]}
["اسم المدرسة"]
["Academic Year: 2024-2025",null,null,null,null,null,null,null,"Teacher:"]
[null,"2024-2025",null,null,null,null,null,"Moon",null,"A","Section:",null,null,"Grade 01",null,null,"Class:"]
[]
[]
[null,"اسم الطالب / أقصى علامة"]
[1,"اسم الطالب 1"]
[2,"اسم الطالب 2"]
[3,"اسم الطالب 3"]
[4,"اسم الطالب 4"]
[5,"اسم الطالب 5"]
[6,"اسم الطالب 6"]
[7,"اسم الطالب 7"]
[8,"اسم الطالب 8"]
[9,"اسم الطالب 9"]
[10,"اسم الطالب 10"]
[11,"اسم الطالب 11"]
[12,"اسم الطالب 12"]
[13,"اسم الطالب 13"]
[14,"اسم الطالب 14"]
[15,"اسم الطالب 15"]
[16,"اسم الطالب 16"]
[17,"اسم الطالب 17"]
[18,"اسم الطالب 18"]
[19,"اسم الطالب 19"]
[20,"اسم الطالب 20"]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]

{"sheet":"Monthly1","index":1,"n_rows":41,"n_cols":27,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,22],[1,2,1,4],[2,2,2,4],[2,5,2,7],[1,16,1,19],[2,16,2,19],[1,20,1,22],[2,20,2,22]]}
[{"$f":"STName!A1","v":"اسم المدرسة"}]
[null,"الصــــــــــــــــــــف:",{"$f":"STName!N3","v":"Grade 01"},null,null,null,null,null,null,null,null,null,null,null,null,null,"العـام الدراســـي:",null,null,null,{"$f":"STName!B3","v":"2024-2025"}]
[null,"الشــــــــــــــــــــعبة:",{"$f":"STName!J3","v":"A"},null,null,{"$f":"STName!H3","v":"Moon"},null,null,null,null,null,null,null,null,null,null,"عــلامــات شـهر:",null,null,null,"Monthly1"]
[]
["الرقم","اسم الطالب","Reading","Grammar","Dictation","Comp + Conv","Poetry","Handwriting","Science","Mathematics","القراءة","القواعد","الإملاء","التعبير والمحادثة","المحفوظات","الخط","تربية مدنية","Sport","المجموع","المعدل","الترتيب","الفئة","النتيجة",null,null,"ترتيب تصاعدي"]
[null,"العلامة القصوى",20,20,20,20,10,10,20,20,20,20,20,20,10,10,10,10,{"$f":"IF(C6<>0,SUM(C6:R6),\"\")","v":260},20]
[{"$f":"IF(B7<>0,STName!A7,\"\")","v":1},{"$f":"STName!B7","v":"اسم الطالب 1"},8,16,13,13,2,7,14,20,12,19,19,2,7,6,7,7,{"$f":"IF(C7<>0,SUM(C7:R7),\"\")","v":172},{"$f":"IF(C7<>0,S7/13,\"\")","v":13.23076923076923},{"$f":"IF(C7<>0,RANK(T7,$T$7:$T$36),\"\")","v":14},{"$f":"IF(C7<>0,IF(T7>=15,\"A\",IF(T7>=12,\"B\",IF(T7>=10,\"C\",IF(T7>=7.5,\"D\",\"E\")))),\"\")","v":"B"},{"$f":"IF(C7<>0,IF(T7>=10,\"ناجح\",\"راسب\"),\"\")","v":"ناجح"},null,1,"اسم الطالب 13","الأول"]
[{"$f":"IF(B8<>0,STName!A8,\"\")","v":2},{"$f":"STName!B8","v":"اسم الطالب 2"},12,19,19,15,7,7,2,2,2,5,2,1,7,7,7,7,121,9.3076923076923084,{"$f":"IF(C8<>0,RANK(T8,$T$7:$T$36),\"\")","v":19},{"$f":"IF(C8<>0,IF(T8>=15,\"A\",IF(T8>=12,\"B\",IF(T8>=10,\"C\",IF(T8>=7.5,\"D\",\"E\")))),\"\")","v":"D"},{"$f":"IF(C8<>0,IF(T8>=10,\"ناجح\",\"راسب\"),\"\")","v":"راسب"},null,2,"اسم الطالب 7","الثاني"]
[{"$f":"IF(B9<>0,STName!A9,\"\")","v":3},{"$f":"STName!B9","v":"اسم الطالب 3"},14,20,19,15,7,7,20,20,12,20,20,15,7,6,7,7,216,16.615384615384617,4,"A","ناجح",null,3,"اسم الطالب 19","الثاني 2"]
[{"$f":"IF(B10<>0,STName!A10,\"\")","v":4},{"$f":"STName!B10","v":"اسم الطالب 4"},6,12,11,12,5,5,9,8,9,12,10,6,6,5,7,7,130,10,17,"C","ناجح",null,4,"اسم الطالب 3","الثالث"]
[{"$f":"IF(B11<>0,STName!A11,\"\")","v":5},{"$f":"STName!B11","v":"اسم الطالب 5"},12,20,16,14,5,6,19,20,13,17,19,15,7,5,7,7,202,15.538461538461538,9,"A","ناجح",null,5,"اسم الطالب 10","الثالث 2"]
[{"$f":"IF(B12<>0,STName!A12,\"\")","v":6},{"$f":"STName!B12","v":"اسم الطالب 6"},13,20,19,14,7,7,19,17,12,19,20,14,7,6,7,7,208,16,7,"A","ناجح",null,6,"اسم الطالب 14","الرابع"]
[{"$f":"IF(B13<>0,STName!A13,\"\")","v":7},{"$f":"STName!B13","v":"اسم الطالب 7"},14,20,20,14,7,7,20,20,13,20,20,15,7,7,7,7,218,16.76923076923077,2,"A","ناجح",null,7,"اسم الطالب 18","الخامس"]
[{"$f":"IF(B14<>0,STName!A14,\"\")","v":8},{"$f":"STName!B14","v":"اسم الطالب 8"},8,16,13,13,2,7,14,20,12,19,19,2,7,6,7,7,172,13.23076923076923,14,"B","ناجح",null,8,"اسم الطالب 6","الخامس 2"]
[{"$f":"IF(B15<>0,STName!A15,\"\")","v":9},{"$f":"STName!B15","v":"اسم الطالب 9"},12,19,19,15,7,7,2,2,2,5,2,1,7,7,7,7,121,9.3076923076923084,19,"D","راسب",null,9,"اسم الطالب 5","السادس"]
[{"$f":"IF(B16<>0,STName!A16,\"\")","v":10},{"$f":"STName!B16","v":"اسم الطالب 10"},14,20,19,15,7,7,20,20,12,20,20,15,7,6,7,7,216,16.615384615384617,4,"A","ناجح",null,10,"اسم الطالب 12","السادس 2"]
[{"$f":"IF(B17<>0,STName!A17,\"\")","v":11},{"$f":"STName!B17","v":"اسم الطالب 11"},6,12,11,12,5,5,9,8,9,12,10,6,6,5,7,7,130,10,17,"C","ناجح",null,11,"اسم الطالب 16","السابع"]
[{"$f":"IF(B18<>0,STName!A18,\"\")","v":12},{"$f":"STName!B18","v":"اسم الطالب 12"},12,20,16,14,5,6,19,20,13,17,19,15,7,5,7,7,202,15.538461538461538,9,"A","ناجح",null,12,"اسم الطالب 20","السابع 2"]
[{"$f":"IF(B19<>0,STName!A19,\"\")","v":13},{"$f":"STName!B19","v":"اسم الطالب 13"},20,20,14,7,7,20,20,20,13,20,20,15,7,7,7,7,224,17.23076923076923,1,"A","ناجح",null,13,"اسم الطالب 15","الثامن"]
[{"$f":"IF(B20<>0,STName!A20,\"\")","v":14},{"$f":"STName!B20","v":"اسم الطالب 14"},12,20,20,15,7,6,20,17,12,20,20,15,7,5,7,7,210,16.153846153846153,6,"A","ناجح",null,14,"اسم الطالب 8","التاسع"]
[{"$f":"IF(B21<>0,STName!A21,\"\")","v":15},{"$f":"STName!B21","v":"اسم الطالب 15"},8,17,18,13,7,6,15,14,10,15,19,8,7,5,7,7,176,13.538461538461538,13,"B","ناجح",null,15,"اسم الطالب 1","التاسع 2"]
[{"$f":"IF(B22<>0,STName!A22,\"\")","v":16},{"$f":"STName!B22","v":"اسم الطالب 16"},12,16,20,15,4,6,20,14,11,17,20,13,7,6,7,7,195,15,11,"A","ناجح",null,16,"اسم الطالب 17","العاشر"]
[{"$f":"IF(B23<>0,STName!A23,\"\")","v":17},{"$f":"STName!B23","v":"اسم الطالب 17"},9,14,11,12,6,6,11,9,10,19,18,14,7,6,7,7,166,12.76923076923077,16,"B","ناجح",null,17,"اسم الطالب 11","الحادي عشر"]
[{"$f":"IF(B24<>0,STName!A24,\"\")","v":18},{"$f":"STName!B24","v":"اسم الطالب 18"},13,20,19,14,7,7,19,17,12,19,20,14,7,6,7,7,208,16,7,"A","ناجح",null,18,"اسم الطالب 4","الحادي عشر 2"]
[{"$f":"IF(B25<>0,STName!A25,\"\")","v":19},{"$f":"STName!B25","v":"اسم الطالب 19"},14,20,20,14,7,7,20,20,13,20,20,15,7,7,7,7,218,16.76923076923077,2,"A","ناجح",null,19,"اسم الطالب 9","الثاني عشر"]
[{"$f":"IF(B26<>0,STName!A26,\"\")","v":20},{"$f":"STName!B26","v":"اسم الطالب 20"},13,13,18,14,7,6,17,14,12,19,20,15,7,6,7,7,195,15,11,"A","ناجح",null,20,"اسم الطالب 2","الثاني عشر 2"]
[{"$f":"IF(B27<>0,STName!A27,\"\")","v":""},{"$f":"STName!B27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B28<>0,STName!A28,\"\")","v":""},{"$f":"STName!B28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B29<>0,STName!A29,\"\")","v":""},{"$f":"STName!B29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B30<>0,STName!A30,\"\")","v":""},{"$f":"STName!B30","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B31<>0,STName!A31,\"\")","v":""},{"$f":"STName!B31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B32<>0,STName!A32,\"\")","v":""},{"$f":"STName!B32","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B33<>0,STName!A33,\"\")","v":""},{"$f":"STName!B33","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B34<>0,STName!A34,\"\")","v":""},{"$f":"STName!B34","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B35<>0,STName!A35,\"\")","v":""},{"$f":"STName!B35","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B36<>0,STName!A36,\"\")","v":""},{"$f":"STName!B36","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[]
[null,"أعلى علامة",{"$f":"MAX(C7:C36)","v":20},{"$f":"MAX(D7:D36)","v":20},20,15,7,20,20,20,13,20,20,15,7,7,7,7,224,17.23076923076923]
[null,"أدنى علامة",{"$f":"MIN(C7:C36)","v":6},{"$f":"MIN(D7:D36)","v":12},11,7,2,5,2,2,2,5,2,1,6,5,7,7,121,9.3076923076923084]
[null,"عدد الناجحين",{"$f":"COUNTIF(C7:C36,\">=\"&C6/2)","v":14},20,20,19,17,20,16,15,16,18,18,13,20,20,20,20,{"$f":"COUNTIF(S7:S36,\">=\"&S6/2)","v":18},{"$f":"COUNTIF(T7:T36,\">=10\")","v":18}]
[null,"عدد الراسبين",{"$f":"COUNTIF(C7:C37,\"<\"&C6/2)","v":6},0,0,1,3,0,4,5,4,2,2,7,0,0,0,0,{"$f":"COUNTIF(S7:S37,\"<\"&S6/2)","v":2},{"$f":"COUNTIF(T7:T37,\"<10\")","v":2}]

{"sheet":"MidYear","index":2,"n_rows":41,"n_cols":27,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,22],[1,2,1,4],[2,2,2,4],[2,5,2,7],[1,16,1,19],[2,16,2,19],[1,20,1,22],[2,20,2,22]]}
[{"$f":"STName!A1","v":"اسم المدرسة"}]
[null,"الصــــــــــــــــــــف:",{"$f":"STName!N3","v":"Grade 01"},null,null,null,null,null,null,null,null,null,null,null,null,null,"العـام الدراســـي:",null,null,null,{"$f":"STName!B3","v":"2024-2025"}]
[null,"الشــــــــــــــــــــعبة:",{"$f":"STName!J3","v":"A"},null,null,{"$f":"STName!H3","v":"Moon"},null,null,null,null,null,null,null,null,null,null,"عــلامــات شـهر:",null,null,null,"MidYear"]
[]
["الرقم","اسم الطالب","Reading","Grammar","Dictation","Comp + Conv","Poetry","Handwriting","Science","Mathematics","القراءة","القواعد","الإملاء","التعبير والمحادثة","المحفوظات","الخط","تربية مدنية","Sport","المجموع","المعدل","الترتيب","الفئة","النتيجة",null,null,"ترتيب تصاعدي"]
[null,"العلامة القصوى",20,20,20,20,10,10,20,20,20,20,20,20,10,10,10,10,{"$f":"IF(C6<>0,SUM(C6:R6),\"\")","v":260},20]
[{"$f":"IF(B7<>0,STName!A7,\"\")","v":1},{"$f":"STName!B7","v":"اسم الطالب 1"},10,19,12,13,2,5,18,12,10,18,16,15,7,5,7,7,{"$f":"IF(C7<>0,SUM(C7:R7),\"\")","v":176},{"$f":"IF(C7<>0,S7/13,\"\")","v":13.538461538461538},{"$f":"IF(C7<>0,RANK(T7,$T$7:$T$36),\"\")","v":14},{"$f":"IF(C7<>0,IF(T7>=15,\"A\",IF(T7>=12,\"B\",IF(T7>=10,\"C\",IF(T7>=7.5,\"D\",\"E\")))),\"\")","v":"B"},{"$f":"IF(C7<>0,IF(T7>=10,\"ناجح\",\"راسب\"),\"\")","v":"ناجح"},null,1,"اسم الطالب 7","الأول"]
[{"$f":"IF(B8<>0,STName!A8,\"\")","v":2},{"$f":"STName!B8","v":"اسم الطالب 2"},12,19,19,13,7,7,20,18,13,17,20,15,7,6,7,7,207,15.923076923076923,{"$f":"IF(C8<>0,RANK(T8,$T$7:$T$36),\"\")","v":4},{"$f":"IF(C8<>0,IF(T8>=15,\"A\",IF(T8>=12,\"B\",IF(T8>=10,\"C\",IF(T8>=7.5,\"D\",\"E\")))),\"\")","v":"A"},{"$f":"IF(C8<>0,IF(T8>=10,\"ناجح\",\"راسب\"),\"\")","v":"ناجح"},null,2,"اسم الطالب 12","الأول 2"]
[{"$f":"IF(B9<>0,STName!A9,\"\")","v":3},{"$f":"STName!B9","v":"اسم الطالب 3"},9,16,17,11,3,6,15,8,11,17,19,12,7,5,7,7,170,13.076923076923077,16,"B","ناجح",null,3,"اسم الطالب 15","الثاني"]
[{"$f":"IF(B10<>0,STName!A10,\"\")","v":4},{"$f":"STName!B10","v":"اسم الطالب 4"},13,15,19,14,7,7,18,14,12,19,20,13,7,6,7,7,198,15.23076923076923,10,"A","ناجح",null,4,"اسم الطالب 2","الثالث"]
[{"$f":"IF(B11<>0,STName!A11,\"\")","v":5},{"$f":"STName!B11","v":"اسم الطالب 5"},13,20,19,14,7,6,19,14,12,20,20,15,7,6,7,7,206,15.846153846153847,5,"A","ناجح",null,5,"اسم الطالب 5","الرابع"]
[{"$f":"IF(B12<>0,STName!A12,\"\")","v":6},{"$f":"STName!B12","v":"اسم الطالب 6"},13,20,19,14,7,7,19,14,12,19,20,14,7,6,7,7,205,15.76923076923077,8,"A","ناجح",null,6,"اسم الطالب 10","الرابع 2"]
[{"$f":"IF(B13<>0,STName!A13,\"\")","v":7},{"$f":"STName!B13","v":"اسم الطالب 7"},14,20,20,14,7,7,20,14,13,20,20,15,7,7,7,7,212,16.307692307692307,1,"A","ناجح",null,7,"اسم الطالب 19","الرابع 3"]
[{"$f":"IF(B14<>0,STName!A14,\"\")","v":8},{"$f":"STName!B14","v":"اسم الطالب 8"},8,16,13,13,2,7,14,14,12,19,19,2,7,6,7,7,166,12.76923076923077,17,"B","ناجح",null,8,"اسم الطالب 11","الخامس"]
[{"$f":"IF(B15<>0,STName!A15,\"\")","v":9},{"$f":"STName!B15","v":"اسم الطالب 9"},13,15,19,14,7,7,18,14,12,19,20,13,7,6,7,7,198,15.23076923076923,10,"A","ناجح",null,9,"اسم الطالب 6","الخامس 2"]
[{"$f":"IF(B16<>0,STName!A16,\"\")","v":10},{"$f":"STName!B16","v":"اسم الطالب 10"},13,20,19,14,7,6,19,14,12,20,20,15,7,6,7,7,206,15.846153846153847,5,"A","ناجح",null,10,"اسم الطالب 9","السادس"]
[{"$f":"IF(B17<>0,STName!A17,\"\")","v":11},{"$f":"STName!B17","v":"اسم الطالب 11"},13,20,19,14,7,7,19,14,12,19,20,14,7,6,7,7,205,15.76923076923077,8,"A","ناجح",null,11,"اسم الطالب 18","السادس 2"]
[{"$f":"IF(B18<>0,STName!A18,\"\")","v":12},{"$f":"STName!B18","v":"اسم الطالب 12"},14,20,20,14,7,7,20,14,13,20,20,15,7,7,7,7,212,16.307692307692307,1,"A","ناجح",null,12,"اسم الطالب 4","السادس 3"]
[{"$f":"IF(B19<>0,STName!A19,\"\")","v":13},{"$f":"STName!B19","v":"اسم الطالب 13"},8,16,13,13,2,7,14,14,12,19,19,2,7,6,7,7,166,12.76923076923077,17,"B","ناجح",null,13,"اسم الطالب 20","السابع"]
[{"$f":"IF(B20<>0,STName!A20,\"\")","v":14},{"$f":"STName!B20","v":"اسم الطالب 14"},12,19,19,15,7,7,2,14,2,5,2,1,7,7,7,7,133,10.23076923076923,20,"C","ناجح",null,14,"اسم الطالب 17","الثامن"]
[{"$f":"IF(B21<>0,STName!A21,\"\")","v":15},{"$f":"STName!B21","v":"اسم الطالب 15"},14,20,19,15,7,7,20,14,12,20,20,15,7,6,7,7,210,16.153846153846153,3,"A","ناجح",null,15,"اسم الطالب 1","الثامن 2"]
[{"$f":"IF(B22<>0,STName!A22,\"\")","v":16},{"$f":"STName!B22","v":"اسم الطالب 16"},6,12,11,12,5,5,9,14,9,12,10,6,6,5,7,7,136,10.461538461538462,19,"C","ناجح",null,16,"اسم الطالب 3","التاسع"]
[{"$f":"IF(B23<>0,STName!A23,\"\")","v":17},{"$f":"STName!B23","v":"اسم الطالب 17"},9,16,17,11,3,6,15,14,11,17,19,12,7,5,7,7,176,13.538461538461538,14,"B","ناجح",null,17,"اسم الطالب 13","العاشر"]
[{"$f":"IF(B24<>0,STName!A24,\"\")","v":18},{"$f":"STName!B24","v":"اسم الطالب 18"},13,15,19,14,7,7,18,14,12,19,20,13,7,6,7,7,198,15.23076923076923,10,"A","ناجح",null,18,"اسم الطالب 8","العاشر 2"]
[{"$f":"IF(B25<>0,STName!A25,\"\")","v":19},{"$f":"STName!B25","v":"اسم الطالب 19"},13,20,19,14,7,6,19,14,12,20,20,15,7,6,7,7,206,15.846153846153847,5,"A","ناجح",null,19,"اسم الطالب 16","الحادي عشر"]
[{"$f":"IF(B26<>0,STName!A26,\"\")","v":20},{"$f":"STName!B26","v":"اسم الطالب 20"},13,13,18,14,7,6,17,14,12,19,20,15,7,6,7,7,195,15,13,"A","ناجح",null,20,"اسم الطالب 14","الثاني عشر"]
[{"$f":"IF(B27<>0,STName!A27,\"\")","v":""},{"$f":"STName!B27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B28<>0,STName!A28,\"\")","v":""},{"$f":"STName!B28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B29<>0,STName!A29,\"\")","v":""},{"$f":"STName!B29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B30<>0,STName!A30,\"\")","v":""},{"$f":"STName!B30","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B31<>0,STName!A31,\"\")","v":""},{"$f":"STName!B31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B32<>0,STName!A32,\"\")","v":""},{"$f":"STName!B32","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B33<>0,STName!A33,\"\")","v":""},{"$f":"STName!B33","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B34<>0,STName!A34,\"\")","v":""},{"$f":"STName!B34","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B35<>0,STName!A35,\"\")","v":""},{"$f":"STName!B35","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B36<>0,STName!A36,\"\")","v":""},{"$f":"STName!B36","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[]
[null,"أعلى علامة",{"$f":"MAX(C7:C36)","v":14},{"$f":"MAX(D7:D36)","v":20},20,15,7,7,20,18,13,20,20,15,7,7,7,7,212,16.307692307692307]
[null,"أدنى علامة",{"$f":"MIN(C7:C36)","v":6},{"$f":"MIN(D7:D36)","v":12},11,11,2,5,2,8,2,5,2,1,6,5,7,7,133,10.23076923076923]
[null,"عدد الناجحين",{"$f":"COUNTIF(C7:C36,\">=\"&C6/2)","v":15},20,20,20,15,20,18,19,18,19,19,16,20,20,20,20,{"$f":"COUNTIF(S7:S36,\">=\"&S6/2)","v":20},{"$f":"COUNTIF(T7:T36,\">=10\")","v":20}]
[null,"عدد الراسبين",{"$f":"COUNTIF(C7:C37,\"<\"&C6/2)","v":5},0,0,0,5,0,2,1,2,1,1,4,0,0,0,0,{"$f":"COUNTIF(S7:S37,\"<\"&S6/2)","v":0},{"$f":"COUNTIF(T7:T37,\"<10\")","v":0}]

{"sheet":"Monthly2","index":3,"n_rows":41,"n_cols":27,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,22],[1,2,1,4],[2,2,2,4],[2,5,2,7],[1,16,1,19],[2,16,2,19],[1,20,1,22],[2,20,2,22]]}
[{"$f":"STName!A1","v":"اسم المدرسة"}]
[null,"الصــــــــــــــــــــف:",{"$f":"STName!N3","v":"Grade 01"},null,null,null,null,null,null,null,null,null,null,null,null,null,"العـام الدراســـي:",null,null,null,{"$f":"STName!B3","v":"2024-2025"}]
[null,"الشــــــــــــــــــــعبة:",{"$f":"STName!J3","v":"A"},null,null,{"$f":"STName!H3","v":"Moon"},null,null,null,null,null,null,null,null,null,null,"عــلامــات شـهر:",null,null,null,"JunJul"]
[]
["الرقم","اسم الطالب","Reading","Grammar","Dictation","Comp + Conv","Poetry","Handwriting","Science","Mathematics","القراءة","القواعد","الإملاء","التعبير والمحادثة","المحفوظات","الخط","تربية مدنية","Sport","المجموع","المعدل","الترتيب","الفئة","النتيجة",null,null,"ترتيب تصاعدي"]
[null,"العلامة القصوى",20,20,20,20,10,10,20,20,20,20,20,20,10,10,10,10,{"$f":"IF(C6<>0,SUM(C6:R6),\"\")","v":260},20]
[{"$f":"IF(B7<>0,STName!A7,\"\")","v":1},{"$f":"STName!B7","v":"اسم الطالب 1"},20,20,14,7,7,20,20,20,13,20,20,15,7,7,7,7,{"$f":"IF(C7<>0,SUM(C7:R7),\"\")","v":224},{"$f":"IF(C7<>0,S7/13,\"\")","v":17.23076923076923},{"$f":"IF(C7<>0,RANK(T7,$T$7:$T$36),\"\")","v":1},{"$f":"IF(C7<>0,IF(T7>=15,\"A\",IF(T7>=12,\"B\",IF(T7>=10,\"C\",IF(T7>=7.5,\"D\",\"E\")))),\"\")","v":"A"},{"$f":"IF(C7<>0,IF(T7>=10,\"ناجح\",\"راسب\"),\"\")","v":"ناجح"},null,1,"اسم الطالب 1","الأول"]
[{"$f":"IF(B8<>0,STName!A8,\"\")","v":2},{"$f":"STName!B8","v":"اسم الطالب 2"},12,20,20,15,7,6,20,17,12,20,20,15,7,5,7,7,210,16.153846153846153,{"$f":"IF(C8<>0,RANK(T8,$T$7:$T$36),\"\")","v":5},{"$f":"IF(C8<>0,IF(T8>=15,\"A\",IF(T8>=12,\"B\",IF(T8>=10,\"C\",IF(T8>=7.5,\"D\",\"E\")))),\"\")","v":"A"},{"$f":"IF(C8<>0,IF(T8>=10,\"ناجح\",\"راسب\"),\"\")","v":"ناجح"},null,2,"اسم الطالب 7","الثاني"]
[{"$f":"IF(B9<>0,STName!A9,\"\")","v":3},{"$f":"STName!B9","v":"اسم الطالب 3"},8,17,18,13,7,6,15,14,10,15,19,8,7,5,7,7,176,13.538461538461538,14,"B","ناجح",null,3,"اسم الطالب 10","الثالث"]
[{"$f":"IF(B10<>0,STName!A10,\"\")","v":4},{"$f":"STName!B10","v":"اسم الطالب 4"},12,16,20,15,4,6,20,14,11,17,20,13,7,6,7,7,195,15,11,"A","ناجح",null,4,"اسم الطالب 19","الرابع"]
[{"$f":"IF(B11<>0,STName!A11,\"\")","v":5},{"$f":"STName!B11","v":"اسم الطالب 5"},9,14,11,12,6,6,11,9,10,19,18,14,7,6,7,7,166,12.76923076923077,18,"B","ناجح",null,5,"اسم الطالب 2","الخامس"]
[{"$f":"IF(B12<>0,STName!A12,\"\")","v":6},{"$f":"STName!B12","v":"اسم الطالب 6"},13,20,19,14,7,7,19,17,12,19,20,14,7,6,7,7,208,16,6,"A","ناجح",null,6,"اسم الطالب 6","السادس"]
[{"$f":"IF(B13<>0,STName!A13,\"\")","v":7},{"$f":"STName!B13","v":"اسم الطالب 7"},14,20,20,14,7,7,20,20,13,20,20,15,7,7,7,7,218,16.76923076923077,2,"A","ناجح",null,7,"اسم الطالب 16","السابع"]
[{"$f":"IF(B14<>0,STName!A14,\"\")","v":8},{"$f":"STName!B14","v":"اسم الطالب 8"},8,16,13,13,2,7,14,20,12,19,19,2,7,6,7,7,172,13.23076923076923,16,"B","ناجح",null,8,"اسم الطالب 12","الثامن"]
[{"$f":"IF(B15<>0,STName!A15,\"\")","v":9},{"$f":"STName!B15","v":"اسم الطالب 9"},12,19,19,15,7,7,2,2,2,5,2,1,7,7,7,7,121,9.3076923076923084,20,"D","راسب",null,9,"اسم الطالب 13","التاسع"]
[{"$f":"IF(B16<>0,STName!A16,\"\")","v":10},{"$f":"STName!B16","v":"اسم الطالب 10"},14,20,19,15,7,7,20,20,12,20,20,15,7,6,7,7,216,16.615384615384617,3,"A","ناجح",null,10,"اسم الطالب 18","العاشر"]
[{"$f":"IF(B17<>0,STName!A17,\"\")","v":11},{"$f":"STName!B17","v":"اسم الطالب 11"},6,12,11,12,5,5,9,8,9,12,10,6,6,5,7,7,130,10,19,"C","ناجح",null,11,"اسم الطالب 4","الحادي عشر"]
[{"$f":"IF(B18<>0,STName!A18,\"\")","v":12},{"$f":"STName!B18","v":"اسم الطالب 12"},12,20,16,14,5,6,19,20,13,17,19,15,7,5,7,7,202,15.538461538461538,8,"A","ناجح",null,12,"اسم الطالب 20","الحادي عشر 2"]
[{"$f":"IF(B19<>0,STName!A19,\"\")","v":13},{"$f":"STName!B19","v":"اسم الطالب 13"},13,19,19,13,4,6,18,17,12,17,20,15,7,5,7,7,199,15.307692307692308,9,"A","ناجح",null,13,"اسم الطالب 14","الثاني عشر"]
[{"$f":"IF(B20<>0,STName!A20,\"\")","v":14},{"$f":"STName!B20","v":"اسم الطالب 14"},12,19,20,15,7,7,14,17,12,20,1,13,7,7,7,7,185,14.23076923076923,13,"B","ناجح",null,14,"اسم الطالب 3","الثالث عشر"]
[{"$f":"IF(B21<>0,STName!A21,\"\")","v":15},{"$f":"STName!B21","v":"اسم الطالب 15"},10,19,12,13,2,5,18,12,10,18,16,15,7,5,7,7,176,13.538461538461538,14,"B","ناجح",null,15,"اسم الطالب 15","الثالث عشر 2"]
[{"$f":"IF(B22<>0,STName!A22,\"\")","v":16},{"$f":"STName!B22","v":"اسم الطالب 16"},12,19,19,13,7,7,20,18,13,17,20,15,7,6,7,7,207,15.923076923076923,7,"A","ناجح",null,16,"اسم الطالب 8","الرابع عشر"]
[{"$f":"IF(B23<>0,STName!A23,\"\")","v":17},{"$f":"STName!B23","v":"اسم الطالب 17"},9,16,17,11,3,6,15,8,11,17,19,12,7,5,7,7,170,13.076923076923077,17,"B","ناجح",null,17,"اسم الطالب 17","الخامس عشر"]
[{"$f":"IF(B24<>0,STName!A24,\"\")","v":18},{"$f":"STName!B24","v":"اسم الطالب 18"},13,15,19,14,7,7,18,14,12,19,20,13,7,6,7,7,198,15.23076923076923,10,"A","ناجح",null,18,"اسم الطالب 5","السادس عشر"]
[{"$f":"IF(B25<>0,STName!A25,\"\")","v":19},{"$f":"STName!B25","v":"اسم الطالب 19"},13,20,19,14,7,6,19,20,12,20,20,15,7,6,7,7,212,16.307692307692307,4,"A","ناجح",null,19,"اسم الطالب 11","السابع عشر"]
[{"$f":"IF(B26<>0,STName!A26,\"\")","v":20},{"$f":"STName!B26","v":"اسم الطالب 20"},13,13,18,14,7,6,17,14,12,19,20,15,7,6,7,7,195,15,11,"A","ناجح",null,20,"اسم الطالب 9","الثامن عشر"]
[{"$f":"IF(B27<>0,STName!A27,\"\")","v":""},{"$f":"STName!B27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B28<>0,STName!A28,\"\")","v":""},{"$f":"STName!B28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B29<>0,STName!A29,\"\")","v":""},{"$f":"STName!B29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B30<>0,STName!A30,\"\")","v":""},{"$f":"STName!B30","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B31<>0,STName!A31,\"\")","v":""},{"$f":"STName!B31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B32<>0,STName!A32,\"\")","v":""},{"$f":"STName!B32","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B33<>0,STName!A33,\"\")","v":""},{"$f":"STName!B33","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B34<>0,STName!A34,\"\")","v":""},{"$f":"STName!B34","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B35<>0,STName!A35,\"\")","v":""},{"$f":"STName!B35","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B36<>0,STName!A36,\"\")","v":""},{"$f":"STName!B36","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[]
[null,"أعلى علامة",{"$f":"MAX(C7:C36)","v":20},{"$f":"MAX(D7:D36)","v":20},20,15,7,20,20,20,13,20,20,15,7,7,7,7,224,17.23076923076923]
[null,"أدنى علامة",{"$f":"MIN(C7:C36)","v":6},{"$f":"MIN(D7:D36)","v":12},11,7,2,5,2,2,2,5,1,1,6,5,7,7,121,9.3076923076923084]
[null,"عدد الناجحين",{"$f":"COUNTIF(C7:C36,\">=\"&C6/2)","v":15},20,20,19,15,20,18,16,18,19,18,16,20,20,20,20,{"$f":"COUNTIF(S7:S36,\">=\"&S6/2)","v":19},{"$f":"COUNTIF(T7:T36,\">=10\")","v":19}]
[null,"عدد الراسبين",{"$f":"COUNTIF(C7:C37,\"<\"&C6/2)","v":5},0,0,1,5,0,2,4,2,1,2,4,0,0,0,0,{"$f":"COUNTIF(S7:S37,\"<\"&S6/2)","v":1},{"$f":"COUNTIF(T7:T37,\"<10\")","v":1}]

{"sheet":"FinalYear","index":4,"n_rows":41,"n_cols":26,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,22],[1,2,1,4],[2,2,2,4],[2,5,2,7],[1,16,1,19],[2,16,2,19],[1,20,1,22],[2,20,2,22]]}
[{"$f":"STName!A1","v":"اسم المدرسة"}]
[null,"الصــــــــــــــــــــف:",{"$f":"STName!N3","v":"Grade 01"},null,null,null,null,null,null,null,null,null,null,null,null,null,"العـام الدراســـي:",null,null,null,{"$f":"STName!B3","v":"2024-2025"}]
[null,"الشــــــــــــــــــــعبة:",{"$f":"STName!J3","v":"A"},null,null,{"$f":"STName!H3","v":"Moon"},null,null,null,null,null,null,null,null,null,null,"عــلامــات شـهر:",null,null,null,"Final"]
[]
["الرقم","اسم الطالب","Reading","Grammar","Dictation","Comp + Conv","Poetry","Handwriting","Science","Mathematics","القراءة","القواعد","الإملاء","التعبير والمحادثة","المحفوظات","الخط","تربية مدنية","Sport","المجموع","المعدل","الترتيب","الفئة","النتيجة",null,null,"ترتيب تصاعدي"]
[null,"العلامة القصوى",20,20,20,20,10,10,20,20,20,20,20,20,10,10,10,10,{"$f":"IF(C6<>0,SUM(C6:R6),\"\")","v":260},20]
[{"$f":"IF(B7<>0,STName!A7,\"\")","v":1},{"$f":"STName!B7","v":"اسم الطالب 1"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C7<>0,SUM(C7:R7),\"\")","v":""},{"$f":"IF(C7<>0,S7/13,\"\")","v":""},{"$f":"IF(C7<>0,RANK(T7,$T$7:$T$36),\"\")","v":""},{"$f":"IF(C7<>0,IF(T7>=15,\"A\",IF(T7>=12,\"B\",IF(T7>=10,\"C\",IF(T7>=7.5,\"D\",\"E\")))),\"\")","v":""},{"$f":"IF(C7<>0,IF(T7>=10,\"ناجح\",\"راسب\"),\"\")","v":""}]
[{"$f":"IF(B8<>0,STName!A8,\"\")","v":2},{"$f":"STName!B8","v":"اسم الطالب 2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IF(C8<>0,RANK(T8,$T$7:$T$36),\"\")","v":""},{"$f":"IF(C8<>0,IF(T8>=15,\"A\",IF(T8>=12,\"B\",IF(T8>=10,\"C\",IF(T8>=7.5,\"D\",\"E\")))),\"\")","v":""},{"$f":"IF(C8<>0,IF(T8>=10,\"ناجح\",\"راسب\"),\"\")","v":""}]
[{"$f":"IF(B9<>0,STName!A9,\"\")","v":3},{"$f":"STName!B9","v":"اسم الطالب 3"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B10<>0,STName!A10,\"\")","v":4},{"$f":"STName!B10","v":"اسم الطالب 4"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B11<>0,STName!A11,\"\")","v":5},{"$f":"STName!B11","v":"اسم الطالب 5"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B12<>0,STName!A12,\"\")","v":6},{"$f":"STName!B12","v":"اسم الطالب 6"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B13<>0,STName!A13,\"\")","v":7},{"$f":"STName!B13","v":"اسم الطالب 7"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B14<>0,STName!A14,\"\")","v":8},{"$f":"STName!B14","v":"اسم الطالب 8"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B15<>0,STName!A15,\"\")","v":9},{"$f":"STName!B15","v":"اسم الطالب 9"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B16<>0,STName!A16,\"\")","v":10},{"$f":"STName!B16","v":"اسم الطالب 10"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B17<>0,STName!A17,\"\")","v":11},{"$f":"STName!B17","v":"اسم الطالب 11"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B18<>0,STName!A18,\"\")","v":12},{"$f":"STName!B18","v":"اسم الطالب 12"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B19<>0,STName!A19,\"\")","v":13},{"$f":"STName!B19","v":"اسم الطالب 13"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B20<>0,STName!A20,\"\")","v":14},{"$f":"STName!B20","v":"اسم الطالب 14"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B21<>0,STName!A21,\"\")","v":15},{"$f":"STName!B21","v":"اسم الطالب 15"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B22<>0,STName!A22,\"\")","v":16},{"$f":"STName!B22","v":"اسم الطالب 16"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B23<>0,STName!A23,\"\")","v":17},{"$f":"STName!B23","v":"اسم الطالب 17"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B24<>0,STName!A24,\"\")","v":18},{"$f":"STName!B24","v":"اسم الطالب 18"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B25<>0,STName!A25,\"\")","v":19},{"$f":"STName!B25","v":"اسم الطالب 19"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B26<>0,STName!A26,\"\")","v":20},{"$f":"STName!B26","v":"اسم الطالب 20"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B27<>0,STName!A27,\"\")","v":""},{"$f":"STName!B27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B28<>0,STName!A28,\"\")","v":""},{"$f":"STName!B28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B29<>0,STName!A29,\"\")","v":""},{"$f":"STName!B29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B30<>0,STName!A30,\"\")","v":""},{"$f":"STName!B30","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B31<>0,STName!A31,\"\")","v":""},{"$f":"STName!B31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B32<>0,STName!A32,\"\")","v":""},{"$f":"STName!B32","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B33<>0,STName!A33,\"\")","v":""},{"$f":"STName!B33","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B34<>0,STName!A34,\"\")","v":""},{"$f":"STName!B34","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B35<>0,STName!A35,\"\")","v":""},{"$f":"STName!B35","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[{"$f":"IF(B36<>0,STName!A36,\"\")","v":""},{"$f":"STName!B36","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[]
[null,"أعلى علامة",{"$f":"MAX(C7:C36)","v":0},{"$f":"MAX(D7:D36)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"أدنى علامة",{"$f":"MIN(C7:C36)","v":0},{"$f":"MIN(D7:D36)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"عدد الناجحين",{"$f":"COUNTIF(C7:C36,\">=\"&C6/2)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"COUNTIF(S7:S36,\">=\"&S6/2)","v":0},{"$f":"COUNTIF(T7:T36,\">=10\")","v":0}]
[null,"عدد الراسبين",{"$f":"COUNTIF(C7:C37,\"<\"&C6/2)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"COUNTIF(S7:S37,\"<\"&S6/2)","v":0},{"$f":"COUNTIF(T7:T37,\"<10\")","v":0}]

{"sheet":"الشهادة","index":5,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,7,0,8],[0,5,0,6],[1,7,1,8],[1,5,1,6],[3,0,3,8],[4,0,4,8],[35,0,35,2],[34,0,34,8],[35,6,35,8],[10,6,10,8],[8,1,8,3]]}
[null,null,null,null,null,"بحث برقم الطالب",null,"إجمالي الشهادات"]
[null,null,null,null,null,1,null,{"$f":"COUNTIF(Monthly1!A7:A36,\">0\")","v":20}]
[]
[{"$f":"STName!A1","v":"اسم المدرسة"}]
[{"$f":"STName!A2","v":"Academic Year: 2024-2025"}]
["Class",{"$f":"STName!N3","v":"Grade 01"}]
["Section",{"$f":"STName!J3&\"  \"&STName!H3","v":"A  Moon"}]
["Student Number",{"$f":"LOOKUP(F2,Monthly1!A7:A36,Monthly1!A7:A36)","v":1},"from ",{"$f":"H2","v":20}]
["Student Name",{"$f":"LOOKUP(B8,Monthly1!A7:A36,Monthly1!B7:B36)","v":"اسم الطالب 1"}]
[]
[null,null,null,null,null,null,"   الشويفات/ هاتف: 05/000000"]
["Subject","Max Mark","Monthly1","Mid Year Exam","Semester One Average","Monthly2","Final Exam","Semester Two Average","Total Average"]
["Reading",20,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly1,$B$8,3)),\"\"))","v":8},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(MidYear,$B$8,3)),\"\"))","v":10},{"$f":"IF((C13<>\"\")*AND(D13<>\"\"),CEILING(AVERAGE(C13,D13),1),\"\")","v":9},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly2,$B$8,3)),\"\"))","v":20},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(FinalYear,$B$8,3)),\"\"))","v":""},{"$f":"IF((F13<>\"\")*AND(G13<>\"\"),CEILING(AVERAGE(F13,G13),1),\"\")","v":""},{"$f":"IF((E13<>\"\")*AND(H13<>\"\"),CEILING(AVERAGE(E13,H13),1),\"\")","v":""}]
["Grammar",20,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly1,$B$8,4)),\"\"))","v":16},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(MidYear,$B$8,4)),\"\"))","v":19},18,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly2,$B$8,4)),\"\"))","v":20},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(FinalYear,$B$8,4)),\"\"))","v":""},{"$f":"IF((F14<>\"\")*AND(G14<>\"\"),CEILING(AVERAGE(F14,G14),1),\"\")","v":""},""]
["Dictation",20,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly1,$B$8,5)),\"\"))","v":13},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(MidYear,$B$8,5)),\"\"))","v":12},13,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly2,$B$8,5)),\"\"))","v":14},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(FinalYear,$B$8,5)),\"\"))","v":""},"",""]
["Comp + Conv",20,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly1,$B$8,6)),\"\"))","v":13},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(MidYear,$B$8,6)),\"\"))","v":13},13,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly2,$B$8,6)),\"\"))","v":7},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(FinalYear,$B$8,6)),\"\"))","v":""},"",""]
["Poetry",10,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly1,$B$8,7)),\"\"))","v":2},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(MidYear,$B$8,7)),\"\"))","v":2},2,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly2,$B$8,7)),\"\"))","v":7},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(FinalYear,$B$8,7)),\"\"))","v":""},"",""]
["Handwriting",10,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly1,$B$8,8)),\"\"))","v":7},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(MidYear,$B$8,8)),\"\"))","v":5},6,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly2,$B$8,8)),\"\"))","v":20},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(FinalYear,$B$8,8)),\"\"))","v":""},"",""]
["Science",20,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly1,$B$8,9)),\"\"))","v":14},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(MidYear,$B$8,9)),\"\"))","v":18},16,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly2,$B$8,9)),\"\"))","v":20},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(FinalYear,$B$8,9)),\"\"))","v":""},"",""]
["Mathematics",20,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly1,$B$8,10)),\"\"))","v":20},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(MidYear,$B$8,10)),\"\"))","v":12},16,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly2,$B$8,10)),\"\"))","v":20},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(FinalYear,$B$8,10)),\"\"))","v":""},"",""]
["القراءة",20,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly1,$B$8,11)),\"\"))","v":12},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(MidYear,$B$8,11)),\"\"))","v":10},11,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly2,$B$8,11)),\"\"))","v":13},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(FinalYear,$B$8,11)),\"\"))","v":""},"",""]
["القواعد",20,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly1,$B$8,12)),\"\"))","v":19},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(MidYear,$B$8,12)),\"\"))","v":18},19,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly2,$B$8,12)),\"\"))","v":20},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(FinalYear,$B$8,12)),\"\"))","v":""},"",""]
["الإملاء",20,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly1,$B$8,13)),\"\"))","v":19},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(MidYear,$B$8,13)),\"\"))","v":16},18,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly2,$B$8,13)),\"\"))","v":20},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(FinalYear,$B$8,13)),\"\"))","v":""},"",""]
["التعبير والمحادثة",20,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly1,$B$8,14)),\"\"))","v":2},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(MidYear,$B$8,14)),\"\"))","v":15},9,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly2,$B$8,14)),\"\"))","v":15},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(FinalYear,$B$8,14)),\"\"))","v":""},"",""]
["المحفوظات",10,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly1,$B$8,15)),\"\"))","v":7},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(MidYear,$B$8,15)),\"\"))","v":7},7,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly2,$B$8,15)),\"\"))","v":7},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(FinalYear,$B$8,15)),\"\"))","v":""},"",""]
["الخط",10,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly1,$B$8,16)),\"\"))","v":6},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(MidYear,$B$8,16)),\"\"))","v":5},6,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly2,$B$8,16)),\"\"))","v":7},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(FinalYear,$B$8,16)),\"\"))","v":""},"",""]
["تربية مدنية",10,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly1,$B$8,17)),\"\"))","v":7},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(MidYear,$B$8,17)),\"\"))","v":7},7,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly2,$B$8,17)),\"\"))","v":7},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(FinalYear,$B$8,17)),\"\"))","v":""},"",""]
["Sport",10,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly1,$B$8,18)),\"\"))","v":7},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(MidYear,$B$8,18)),\"\"))","v":7},7,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly2,$B$8,18)),\"\"))","v":7},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(FinalYear,$B$8,18)),\"\"))","v":""},"",""]
["Total",{"$f":"IF(B13<>\"\",SUM(B13:B28),\"\")","v":260},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly1,$B$8,19)),\"\"))","v":172},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(MidYear,$B$8,19)),\"\"))","v":176},{"$f":"IF(E13<>\"\",SUM(E13:E28),\"\")","v":177},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly2,$B$8,19)),\"\"))","v":224},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(FinalYear,$B$8,19)),\"\"))","v":""},"",""]
["Average",{"$f":"IF(B29<>\"\",B29/13,\"\")","v":20},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly1,$B$8,20)),\"\"))","v":13.23076923076923},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(MidYear,$B$8,20)),\"\"))","v":13.538461538461538},{"$f":"IF(E29<>\"\",E29/13,\"\")","v":13.615384615384615},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly2,$B$8,20)),\"\"))","v":17.23076923076923},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(FinalYear,$B$8,20)),\"\"))","v":""},"",""]
["Rank",null,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly1,$B$8,21)),\"\"))","v":14},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(MidYear,$B$8,21)),\"\"))","v":14},null,{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(Monthly2,$B$8,21)),\"\"))","v":1},{"$f":"IF($B$8=\"\",\"\",IFERROR(1/(1/INDEX(FinalYear,$B$8,21)),\"\"))","v":""}]
["Evaluation",null,{"$f":"IF($B$8=\"\",\"\",IF(INDEX(Monthly1,$B$8,22)=0,\"\",INDEX(Monthly1,$B$8,22)))","v":"B"},{"$f":"IF($B$8=\"\",\"\",IF(INDEX(MidYear,$B$8,22)=0,\"\",INDEX(MidYear,$B$8,22)))","v":"B"},{"$f":"IF(E13<>\"\",IF(E30>=15,\"A\",IF(E30>=12,\"B\",IF(E30>=10,\"C\",IF(E30>=7.5,\"D\",\"E\")))),\"\")","v":"B"},{"$f":"IF($B$8=\"\",\"\",IF(INDEX(Monthly2,$B$8,22)=0,\"\",INDEX(Monthly2,$B$8,22)))","v":"A"},{"$f":"IF($B$8=\"\",\"\",IF(INDEX(FinalYear,$B$8,22)=0,\"\",INDEX(FinalYear,$B$8,22)))","v":""},"",""]
["Result",null,{"$f":"IF($B$8=\"\",\"\",IF(INDEX(Monthly1,$B$8,22)=0,\"\",INDEX(Monthly1,$B$8,23)))","v":"ناجح"},{"$f":"IF($B$8=\"\",\"\",IF(INDEX(MidYear,$B$8,22)=0,\"\",INDEX(MidYear,$B$8,23)))","v":"ناجح"},{"$f":"IF(E13<>\"\",IF(E30>=10,\"ناجح\",\"راسب\"),\"\")","v":"ناجح"},{"$f":"IF($B$8=\"\",\"\",IF(INDEX(Monthly2,$B$8,22)=0,\"\",INDEX(Monthly2,$B$8,23)))","v":"ناجح"},{"$f":"IF($B$8=\"\",\"\",IF(INDEX(FinalYear,$B$8,22)=0,\"\",INDEX(FinalYear,$B$8,23)))","v":""},"",""]
[]
["(A>15 = جيد جداً)    (B>12 = جيد)    (C>10 = وسط)    (D>7.5 = غير مقبول)    (D<7.5 = ضعيف جداً)  "]
["ختم الإدارة",null,null,null,null,null,"توقيع الأهل"]