{"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":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["الأول"]
["الثاني"]
["الثالث"]
["الرابع"]
["الخامس"]
["السادس"]
["السابع"]
["الثامن"]
["التاسع"]
["العاشر"]

{"sheet":"Salim","index":1,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[[12,1,12,2],[13,1,13,2],[12,3,13,6],[14,1,17,6],[7,1,7,6],[9,1,9,2],[8,3,9,6],[8,1,8,2],[10,1,10,2],[11,1,11,2],[10,3,11,6]]}
[]
["الصف :","ثالث"]
["دين","عربي","E","علوم","رياضيات","اجتماعيات","مهني","حاسوب","مالية","المعدل",null,"المعدل"]
[50,90,80,86,87,99,98,60,60,{"$f":"CHOOSE((MATCH($B$2,{\"اول\";\" ثاني\";\"ثالث\";\"رابع\";\" خامس\";\"سادس\";\"سابع\";\"ثامن\";\"تاسع\";\"عاشر\"},0)<=6)+1,ROUND(AVERAGE($A$4:$I$4),2),ROUND(AVERAGE($A$4:$F$4),2))","v":82},null,"معدل حتى السّادس :82\nمعدل فوق السّادس : 78.89"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"ثالث"]
[null,"المطلوب :اذا تم كتابة ( اسم الصف ) في الخلية B2 ، ان تتغير طريقة حساب المعدل مثال :",null,null,null,null,null,null,null,null,null,null,null,"رابع"]
[null,"اذا كتبنا اسم الصف  :",null,{"$f":"IF(MATCH($B$2,{\"اول\";\" ثاني\";\"ثالث\";\"رابع\";\" خامس\";\"سادس\";\"سابع\";\"ثامن\";\"تاسع\";\"عاشر\"},0)>6,\"\",CHOOSE((MATCH($B$2,$N$5:$N$14,0)<=6)+1,ROUND(AVERAGE($A$4:$I$4),2),ROUND(AVERAGE($A$4:$F$4),2)))","v":82},null,null,null,null,"يحسب المعدل وفق 6 علامات ( دين + العربي+E+ علوم + رياضيات + اجتماعيات ) فقط",null,null,null,null," خامس"]
[null,"اول أو ثاني أو ثالث",null,null,null,null,null,null,null,null,null,null,null,"سادس"]
[null,"اذا كتبنا اسم الصف  :",null,{"$f":"IF(MATCH($B$2,{\"اول\";\" ثاني\";\"ثالث\";\"رابع\";\" خامس\";\"سادس\";\"سابع\";\"ثامن\";\"تاسع\";\"عاشر\"},0)>6,\"\",CHOOSE((MATCH($B$2,$N$5:$N$14,0)<=6)+1,ROUND(AVERAGE($A$4:$I$4),2),ROUND(AVERAGE($A$4:$F$4),2)))","v":82},null,null,null,null,"يحسب المعدل وفق 6 علامات ( دين + العربي+E+ علوم + رياضيات + اجتماعيات ) فقط",null,null,null,null,"سابع"]
[null,"رابع او خامس او سادس",null,null,null,null,null,null,null,null,null,null,null,"ثامن"]
[null,"اذا كتبنا اسم الصف  :",null,{"$f":"IF(MATCH($B$2,{\"اول\";\" ثاني\";\"ثالث\";\"رابع\";\" خامس\";\"سادس\";\"سابع\";\"ثامن\";\"تاسع\";\"عاشر\"},0)<=6,\"\",CHOOSE((MATCH($B$2,$N$5:$N$14,0)<=6)+1,ROUND(AVERAGE($A$4:$I$4),2),ROUND(AVERAGE($A$4:$F$4),2)))","v":""},null,null,null,null,"يحسب المعدل وفق 9 علامات ( دين + العربي+E+ علوم + رياضيات + اجتماعيات+مهني + حاسوب+مالية) فقط",null,null,null,null,"تاسع"]
[null,"سابع وثامن وتاسع عاشر",null,null,null,null,null,null,null,null,null,null,null,"عاشر"]
[null,"شاكر لكم حسن تعاونكم "]