{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ورقة1","ورقة2","ورقة3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"الناتج النهائيئ",63]
[]
[null,null,null,null,null,null,null,11,1]
[null,null,null,null,null,null,null,0,2]
[null,null,null,null,null,null,null,4,3]
[null,null,null,null,null,null,null,0,4]
[null,null,null,null,null,null,null,7,3]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,5]

{"sheet":"ورقة2","index":1,"n_rows":18,"n_cols":19,"rows_kept":18,"cut":false,"hidden":false,"merged":[[3,17,3,18],[3,13,3,14],[1,0,1,2],[1,9,1,12],[3,15,3,16],[3,1,3,2],[3,3,3,4]]}
[]
["جدول المعاملات",null,null,null,null,null,null,null,null,"جدول النتائج"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"حل مباشر",null,"حل بالدالة SUMPRODUCT"]
[null,"رياضيات",null,"فيزياء",null,null,null,null,null,"رياضيات",null,"فيزياء",null,"معدل بمعاملات",null,"معدل بمعاملات",null,"معدل بمعاملات"]
["الاقسام","فرض","اختبار","فرض","اختبار",null,null,null,"القسم","فرض","اختبار","فرض","اختبار","فروض","اختبارات","فروض","اختبارات","فروض","اختبارات"]
["3ر",7,7,3,3,null,null,"الطالب 1","3ر",14,12,11,20,131,144,{"$f":"$J6*OFFSET($B$5,MATCH($I6,$A$6:$A$9,0),0)+$L6*OFFSET($D$5,MATCH($I6,$A$6:$A$9,0),0)","v":131},{"$f":"$K6*OFFSET($C$5,MATCH($I6,$A$6:$A$9,0),0)+$M6*OFFSET($E$5,MATCH($I6,$A$6:$A$9,0),0)","v":144},{"$f":"SUMPRODUCT((($J6:$M6)*($J$5:$M$5=\"فرض\"))*(OFFSET($B$5:$E$5,MATCH($I6,$A$6:$A$9,0),0)*($B$5:$E$5=\"فرض\")))","v":131},{"$f":"SUMPRODUCT((($J6:$M6)*($J$5:$M$5=\"اختبار\"))*(OFFSET($B$5:$E$5,MATCH($I6,$A$6:$A$9,0),0)*($B$5:$E$5=\"اختبار\")))","v":144}]
["3ع",6,6,2,2,null,null,"الطالب 2","3ر",2,null,2,null,20,0,{"$f":"$J7*OFFSET($B$5,MATCH($I7,$A$6:$A$9,0),0)+$L7*OFFSET($D$5,MATCH($I7,$A$6:$A$9,0),0)","v":20},{"$f":"$K7*OFFSET($C$5,MATCH($I7,$A$6:$A$9,0),0)+$M7*OFFSET($E$5,MATCH($I7,$A$6:$A$9,0),0)","v":0},{"$f":"SUMPRODUCT((($J7:$M7)*($J$5:$M$5=\"فرض\"))*(OFFSET($B$5:$E$5,MATCH($I7,$A$6:$A$9,0),0)*($B$5:$E$5=\"فرض\")))","v":20},{"$f":"SUMPRODUCT((($J7:$M7)*($J$5:$M$5=\"اختبار\"))*(OFFSET($B$5:$E$5,MATCH($I7,$A$6:$A$9,0),0)*($B$5:$E$5=\"اختبار\")))","v":0}]
["2ر",5,5,3,3,null,null,"الطالب 3","3ع",6,3,5,11,57,54,46,40,46,40]
["2ع",5,5,1,1,null,null,"الطالب 4","3ع",4,7,5,11,43,82,34,64,34,64]
[null,null,null,null,null,null,null,"الطالب 5","2ر",null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,"الطالب 6","2ع",null,null,null,null,0,0,0,0,0,0]
[]
[]
["الاقسام","رياضيات","فيزياء",null,null,null,null,null,null,null,null,null,null,"المعادلات التي تُدرج نتائجها بالكود فيها خلل يجب مراجعتها (لا تراعي الأقسام إذ هي تعمل دائما بمعاملات القسم 3ر)"]
["3ر",7,3]
["3ع",6,2]
["2ر",5,3]
["2ع",5,1]

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