{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ورقة1","salim"],"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":"ورقة1","index":0,"n_rows":15,"n_cols":18,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,0,9,3]]}
[]
["السلام عليكم :معادلة استخراج مواد الرسوب تضيف حتى المادة التي هي اصلا فراغ كون المادة لاتدرس في هذه المرحلة وانما لبقية المراحل تدرس وبها درجة::\nالمطلوب ان تكون المعادلة تستخرج المواد التي بها درجات او كلمات صفر او غائب اما اذا كانت الخلية الفراغ تتجاوزه ولاتدرج المادة التي بها فراغ من ضمن مواد الرسوب"]
[]
[null,null,null,null,null,"الاسلامية","العربية","الانكليزية","الرياضيات","الاحياء","الفيزياء","الكيمياء","الاجتماعيات",null,null,"مواد الرسوب"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"النتيجة المطلوبة"]
[]
[]
[]
[null,null,null,"الاول","ذكر",88,98,33,85,66,53,86,null,{"$f":"IF(COUNTIF(F11:M11,\"<>\")<7,\"\",IF(COUNTIF(F11:M11,\"غائب\")>=7,IF($E11=\"ذكر\",\"غائب\",\"غائبة\"),IF(COUNTIF(F11:M11,\"<50\")+COUNTIF(F11:M11,\"غائب\")>=3,IF($E11=\"ذكر\",\"راسب\",\"راسبة\"),IF(COUNTIF(F11:M11,\"<50\")+COUNTIF(F11:M11,\"غائب\")=1,IF($E11=\"ذكر\",\"مكمل\",\"مكملة\"),IF(COUNTIF(F11:M11,\"<50\")+COUNTIF(F11:M11,\"غائب\")=2,IF($E11=\"ذكر\",\"مكمل\",\"مكملة\"),IF($E11=\"ذكر\",\"ناجح\",\"ناجحة\"))))))","v":"مكمل"},{"$f":"IF(OR(N11=\"ناجح\",N11=\"راسب\",N11=\"ناجحة\",N11=\"راسبة\"),SUM(F11:M11),\"\")","v":""},{"$f":"IF(COUNTIF(F11:M11,\"<>\")<7,\"\",IF(N11=\"\",\"\",IF(F11=\"\",\"\",IF(OR(F11<50,F11=\"غائب\"),$F$4,\"\"&\" \"&IF(G11=\"\",\"\",IF(OR(G11<50,G11=\"غائب\"),$G$4,\"\")&\" \"&IF(H11=\"\",\"\",IF(OR(H11<50,H11=\"غائب\"),$H$4,\"\")&\" \"&IF(I11=\"\",\"\",IF(OR(I11<50,I11=\"غائب\"),$I$4,\"\")&\" \"&IF(J11=\"\",\"\",IF(OR(J11<50,J11=\"غائب\"),$J$4,\"\")&\" \"&IF(K11=\"\",\"\",IF(OR(K11<50,K11=\"غائب\"),$K$4,\"\")&\" \"&IF(L11=\"\",\"\",IF(OR(L11<50,L11=\"غائب\"),$L$4,\"\")&\" \"&IF(M11=\"\",\"\",IF(OR(M11<50,M11=\"غائب\"),$M$4,\"\"))))))))))))","v":"  الانكليزية     "},"الاجتماعيات زيادة","  الانكليزية     "]
[null,null,null,"الثاني","ذكر",75,44,55,88,77,44,63,null,{"$f":"IF(COUNTIF(F12:M12,\"<>\")<7,\"\",IF(COUNTIF(F12:M12,\"غائب\")>=7,IF($E12=\"ذكر\",\"غائب\",\"غائبة\"),IF(COUNTIF(F12:M12,\"<5\")+COUNTIF(F12:M12,\"غائب\")>=3,IF($E12=\"ذكر\",\"راسب\",\"راسبة\"),IF(COUNTIF(F12:M12,\"<5\")+COUNTIF(F12:M12,\"غائب\")=1,IF($E12=\"ذكر\",\"مكمل\",\"مكملة\"),IF(COUNTIF(F12:M12,\"<5\")+COUNTIF(F12:M12,\"غائب\")=2,IF($E12=\"ذكر\",\"مكمل\",\"مكملة\"),IF($E12=\"ذكر\",\"ناجح\",\"ناجحة\"))))))","v":"ناجح"},446,{"$f":"IF(COUNTIF(F12:M12,\"<>\")<7,\"\",IF(N12=\"\",\"\",IF(F12=\"\",\"\",IF(OR(F12<50,F12=\"غائب\"),$F$4,\"\"&\" \"&IF(G12=\"\",\"\",IF(OR(G12<50,G12=\"غائب\"),$G$4,\"\")&\" \"&IF(H12=\"\",\"\",IF(OR(H12<50,H12=\"غائب\"),$H$4,\"\")&\" \"&IF(I12=\"\",\"\",IF(OR(I12<50,I12=\"غائب\"),$I$4,\"\")&\" \"&IF(J12=\"\",\"\",IF(OR(J12<50,J12=\"غائب\"),$J$4,\"\")&\" \"&IF(K12=\"\",\"\",IF(OR(K12<50,K12=\"غائب\"),$K$4,\"\")&\" \"&IF(L12=\"\",\"\",IF(OR(L12<50,L12=\"غائب\"),$L$4,\"\")&\" \"&IF(M12=\"\",\"\",IF(OR(M12<50,M12=\"غائب\"),$M$4,\"\"))))))))))))","v":" العربية    الفيزياء  "},"الاجتماعيات زيادة"," العربية    الفيزياء  "]
[null,null,null,"الثالث","ذكر",55,66,75,33,44,88,78,null,"ناجح",439,"   الرياضيات الاحياء   ","الاجتماعيات زيادة","   الرياضيات الاحياء   "]
[null,null,null,"الرابع","ذكر",96,85,55,88,41,100,70,56,"ناجح",591,"    الاحياء   "]
[null,null,null,"الخامس","ذكر",53,85,33,95,65,75,85,55,"ناجح",546,{"$f":"IF(COUNTIF(F15:M15,\"<>\")<7,\"\",IF(N15=\"\",\"\",IF(F15=\"\",\"\",IF(OR(F15<50,F15=\"غائب\"),$F$4,\"\"&\" \"&IF(G15=\"\",\"\",IF(OR(G15<50,G15=\"غائب\"),$G$4,\"\")&\" \"&IF(H15=\"\",\"\",IF(OR(H15<50,H15=\"غائب\"),$H$4,\"\")&\" \"&IF(I15=\"\",\"\",IF(OR(I15<50,I15=\"غائب\"),$I$4,\"\")&\" \"&IF(J15=\"\",\"\",IF(OR(J15<50,J15=\"غائب\"),$J$4,\"\")&\" \"&IF(K15=\"\",\"\",IF(OR(K15<50,K15=\"غائب\"),$K$4,\"\")&\" \"&IF(L15=\"\",\"\",IF(OR(L15<50,L15=\"غائب\"),$L$4,\"\")&\" \"&IF(M15=\"\",\"\",IF(OR(M15<50,M15=\"غائب\"),$M$4,\"\"))))))))))))","v":"  الانكليزية     "}]

{"sheet":"salim","index":1,"n_rows":10,"n_cols":19,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,"الاسلامية","العربية","الانكليزية","الرياضيات","الاحياء","الفيزياء","الكيمياء","الاجتماعيات",null,null,null,"مواد الرسوب"]
[]
[null,null,null,"الاول","ذكر",88,98,33,85,66,40,86,null,{"$f":"IF(COUNTIF(F6:M6,\"<>\")<7,\"\",IF(COUNTIF(F6:M6,\"غائب\")>=7,IF($E6=\"ذكر\",\"غائب\",\"غائبة\"),IF(COUNTIF(F6:M6,\"<50\")+COUNTIF(F6:M6,\"غائب\")>=3,IF($E6=\"ذكر\",\"راسب\",\"راسبة\"),IF(COUNTIF(F6:M6,\"<50\")+COUNTIF(F6:M6,\"غائب\")=1,IF($E6=\"ذكر\",\"مكمل\",\"مكملة\"),IF(COUNTIF(F6:M6,\"<50\")+COUNTIF(F6:M6,\"غائب\")=2,IF($E6=\"ذكر\",\"مكمل\",\"مكملة\"),IF($E6=\"ذكر\",\"ناجح\",\"ناجحة\"))))))","v":"مكمل"},{"$f":"IF(OR(N6=\"ناجح\",N6=\"راسب\",N6=\"ناجحة\",N6=\"راسبة\"),SUM(F6:M6),\"\")","v":""},null,"الانكليزية   الفيزياء   ","الاجتماعيات زيادة","  الانكليزية     "]
[null,null,null,"الثاني","ذكر",75,44,"غائب",88,77,44,63,null,{"$f":"IF(COUNTIF(F7:M7,\"<>\")<7,\"\",IF(COUNTIF(F7:M7,\"غائب\")>=7,IF($E7=\"ذكر\",\"غائب\",\"غائبة\"),IF(COUNTIF(F7:M7,\"<5\")+COUNTIF(F7:M7,\"غائب\")>=3,IF($E7=\"ذكر\",\"راسب\",\"راسبة\"),IF(COUNTIF(F7:M7,\"<5\")+COUNTIF(F7:M7,\"غائب\")=1,IF($E7=\"ذكر\",\"مكمل\",\"مكملة\"),IF(COUNTIF(F7:M7,\"<5\")+COUNTIF(F7:M7,\"غائب\")=2,IF($E7=\"ذكر\",\"مكمل\",\"مكملة\"),IF($E7=\"ذكر\",\"ناجح\",\"ناجحة\"))))))","v":"مكمل"},"",null,"العربية   الانكليزية   الفيزياء   ","الاجتماعيات زيادة"," العربية    الفيزياء  "]
[null,null,null,"الثالث","ذكر",55,66,75,33,44,88,78,30,"ناجح",469,null,"الرياضيات   الاحياء   الاجتماعيات   ","الاجتماعيات زيادة","   الرياضيات الاحياء   "]
[null,null,null,"الرابع","ذكر",96,85,55,88,41,100,70,56,"ناجح",591,null,"الاحياء   "]
[null,null,null,"الخامس","ذكر",53,85,33,95,65,75,85,null,"ناجح",491,null,"الانكليزية   "]