{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["الفيزياء","inpout"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":9,"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":"الفيزياء","index":0,"n_rows":28,"n_cols":20,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,5,1,6],[1,7,1,8],[1,9,1,11],[1,12,1,13],[3,1,6,1],[3,2,6,2],[4,5,4,7],[4,8,4,10],[3,5,3,7],[3,8,3,10],[3,16,6,16],[3,14,6,14],[3,15,6,15],[3,3,6,3],[3,4,6,4],[1,14,1,15],[3,13,5,13],[3,11,5,11],[3,12,5,12],[1,1,1,4]]}
[null,null,null,null,null,null,null,"العام","العلمي"]
[null,"درجات مادة الفيزياء",null,null,null,"للصـــف",null,{"$f":"IF(M2=\"العلمي\",\"الثاني\",IF(M2=\"الأدبي\",\"الثاني\",IF(M2=\"العام\",\"الأول\")))","v":"الأول"},null,"القســــــــــم",null,null,"العام",null,"وعددهم",null,{"$f":"MAX(B:B)","v":20}]
[]
[null,"رقم مسلسل","اسم الطالب بالكامل","رقــم الجلـــــــــــــــــــــوس","الرقـــــم الســــــــــــــــــــري","عدد الحصص",null,null,5,null,null,"مجمــــوع أعمـــال السنة","مجموع درجتي الأمتحان","المجمــــــوع الكلـــــــي","الفصــــــــــــــــــــــــــــــــــل","الجنـــــــــــــــــــــــــــــــــس","التخصــــــــــــــــــــــــــــص"]
[null,null,null,null,null,"الفصل الأول",null,null,"الفصل الثاني"]
[null,null,null,null,null,"اعمـــــال السنة ","درجة الأمتحان","المجمــــــــــوع","اعمـــــال السنة ","درجة الأمتحان","المجمــــــــــوع"]
[null,null,null,null,null,{"$f":"IF(M2=\"العام\",30,IF(M2=\"العلمي\",50))","v":30},{"$f":"IF(M2=\"العام\",30,IF(M2=\"العلمي\",50))","v":30},{"$f":"F7+G7","v":60},{"$f":"IF(M2=\"العام\",30,IF(M2=\"العلمي\",50))","v":30},{"$f":"IF(M2=\"العام\",30,IF(M2=\"العلمي\",50))","v":30},{"$f":"I7+J7","v":60},{"$f":"F7+I7","v":60},{"$f":"G7+J7","v":60},{"$f":"L7+M7","v":120}]
[null,"عمود1","عمود2","عمود22","عمود23","عمود3","عمود4","عمود5","عمود6","عمود7","عمود8","عمود9","عمود10","عمود11","عمود14","عمود15","عمود16"]
[null,{"$f":"IF(C9<>\"\",SUBTOTAL(3,$C$9:C9),\"\")","v":1},"طالب 1",101,520,19,9,28,21,null,null,null,null,null,"5/1","انثى","العام",null,null,0]
[null,{"$f":"IF(C10<>\"\",SUBTOTAL(3,$C$9:C10),\"\")","v":2},"طالب 2",102,519,15,12,27,17,null,null,null,null,null,"3/1","ذكر","العام",null,null,0]
[null,{"$f":"IF(C11<>\"\",SUBTOTAL(3,$C$9:C11),\"\")","v":3},"طالب 3",103,518,26,23,49,28,null,null,null,null,null,"3/1","ذكر","العام",null,null,0]
[null,{"$f":"IF(C12<>\"\",SUBTOTAL(3,$C$9:C12),\"\")","v":4},"طالب 4",104,517,18,18,36,20,null,null,null,null,null,"4/1","ذكر","العام",null,null,0]
[null,{"$f":"IF(C13<>\"\",SUBTOTAL(3,$C$9:C13),\"\")","v":5},"طالب 5",105,516,13,10,23,15,null,null,null,null,null,"2/1","ذكر","العام",null,null,0]
[null,{"$f":"IF(C14<>\"\",SUBTOTAL(3,$C$9:C14),\"\")","v":6},"طالب 6",106,515,17,5,22,19,null,null,null,null,null,"6/1","ذكر","العام",null,null,0]
[null,{"$f":"IF(C15<>\"\",SUBTOTAL(3,$C$9:C15),\"\")","v":7},"طالب 7",107,514,15,12,27,17,null,null,null,null,null,"4/1","ذكر","العام",null,null,0]
[null,{"$f":"IF(C16<>\"\",SUBTOTAL(3,$C$9:C16),\"\")","v":8},"طالب 8",108,513,28,20,48,30,null,null,null,null,null,"6/1","ذكر","العام",null,null,0]
[null,{"$f":"IF(C17<>\"\",SUBTOTAL(3,$C$9:C17),\"\")","v":9},"طالب 9",109,512,23,14,37,25,null,null,null,null,null,"1/1","ذكر","العام",null,null,0]
[null,{"$f":"IF(C18<>\"\",SUBTOTAL(3,$C$9:C18),\"\")","v":10},"طالب 10",110,511,15,9,24,17,12,29,32,21,53,"3/1","ذكر","العام",null,null,0]
[null,{"$f":"IF(C19<>\"\",SUBTOTAL(3,$C$9:C19),\"\")","v":11},"طالب 11",111,510,29,25,54,31,null,null,null,null,null,"5/1","انثى","العام",null,null,0]
[null,{"$f":"IF(C20<>\"\",SUBTOTAL(3,$C$9:C20),\"\")","v":12},"طالب 12",112,509,26,21,47,28,null,null,null,null,null,"6/1","انثى","العام",null,null,0]
[null,{"$f":"IF(C21<>\"\",SUBTOTAL(3,$C$9:C21),\"\")","v":13},"طالب 13",113,508,26,27,53,28,null,null,null,null,null,"1/1","انثى","العام",null,null,0]
[null,{"$f":"IF(C22<>\"\",SUBTOTAL(3,$C$9:C22),\"\")","v":14},"طالب 14",114,507,28,20,48,30,null,null,null,null,null,"5/1","ذكر","العام",null,null,0]
[null,{"$f":"IF(C23<>\"\",SUBTOTAL(3,$C$9:C23),\"\")","v":15},"طالب 15",115,506,24,21,45,26,null,null,null,null,null,"1/1","ذكر","العام",null,null,219]
[null,{"$f":"IF(C24<>\"\",SUBTOTAL(3,$C$9:C24),\"\")","v":16},"طالب 16",116,505,13,17,30,15,null,null,null,null,null,"3/1","ذكر","العام",null,null,104]
[null,{"$f":"IF(C25<>\"\",SUBTOTAL(3,$C$9:C25),\"\")","v":17},"طالب 17",117,504,28,21,49,30,null,null,null,null,null,"4/1","انثى","العام",null,null,96]
[null,{"$f":"IF(C26<>\"\",SUBTOTAL(3,$C$9:C26),\"\")","v":18},"طالب 18",118,503,22,14,36,24,null,null,null,null,null,"1/1","انثى","العام",null,null,68]
[null,{"$f":"IF(C27<>\"\",SUBTOTAL(3,$C$9:C27),\"\")","v":19},"طالب 19",119,502,19,16,35,21,null,null,null,null,null,"4/1","انثى","العام",null,null,160]
[null,{"$f":"IF(C28<>\"\",SUBTOTAL(3,$C$9:C28),\"\")","v":20},"طالب 20",120,501,23,14,37,25,null,null,null,null,null,"4/1","انثى","العام",null,null,206]

{"sheet":"inpout","index":1,"n_rows":24,"n_cols":21,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,20]]}
["درجات الامتحان النهائي "]
[]
["الرقم","اسم الطالب","الجنس","التخصص","رقم الجلوس","الرقم السري","اللغة العربية","اللغة الإنجليزية","الرياضيات","الفيزياء","الكيمياء","الاحياء","التربية الإسلامية","الحاسوب","التاريخ","الجغرافيا","اساسيات الحياة الاجتماعية","الاحصاء","الفلسفة","علم الاجتماع","علم النفس"]
[null,null,null,null,null,null,70,70,70,36,36,36,28,24,28,28,14,28,28,28,28]
[1,"طالب 1","انثى","عام",101,520,65,58,52,30,36,32,27,21,22,27,14]
[2,"طالب 2","ذكر","عام",102,519,55,65,48,17,20,31,25,19,22,23,11]
[3,"طالب 3","ذكر","عام",103,518,51,54,29,28,21,29,20,18,22,21,12]
[4,"طالب 4","ذكر","عام",104,517,40,20,9,12,1,18,6,7,6,9,9]
[5,"طالب 5","ذكر","عام",105,516,40,17,18,9,10,14,16,10,11,9,13]
[6,"طالب 6","ذكر","عام",106,515,38,42,28,14,9,24,21,10,11,16,8]
[7,"طالب 7","ذكر","عام",107,514,44,52,30,17,12,21,24,13,14,17,13]
[8,"طالب 8","ذكر","عام",108,513,56,70,59,32,23,32,27,22,25,24,14]
[9,"طالب 9","ذكر","عام",109,512,37,33,13,15,1,20,14,10,12,19,8]
[10,"طالب 10","ذكر","عام",110,511,37,46,20,12,6,19,15,11,12,12,12]
[11,"طالب 11","انثى","عام",111,510,50,30,47,17,15,12,14,8,24,15,4]
[12,"طالب 12","انثى","عام",112,509,60,54,45,28,29,25,24,17,21,27,6]
[13,"طالب 13","انثى","عام",113,508,59,44,42,19,24,15,25,16,21,21,4]
[14,"طالب 14","ذكر","عام",114,507,31,38,28,14,11,18,17,7,14,16,8]
[15,"طالب 15","ذكر","عام",115,506,32,35,18,8,6,16,16,12,8,7,7]
[16,"طالب 16","ذكر","عام",116,505,12,11,0,2,0,0,4,3,2,6,4]
[17,"طالب 17","انثى","عام",117,504,38,37,43,27,18,17,24,17,17,18,6]
[18,"طالب 18","انثى","عام",118,503,61,58,53,29,31,33,26,21,21,24,14]
[19,"طالب 19","انثى","عام",119,502,54,43,29,27,23,20,21,17,11,16,6]
[20,"طالب 20","انثى","عام",120,501,56,64,55,30,32,30,26,21,26,27,13]