{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["قائمة","اسماءالمراجعيين"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"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":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":false,"merged":[[11,1,12,7],[10,1,10,7],[29,7,30,7],[18,6,19,6],[18,7,19,7],[13,1,13,4],[25,7,26,7],[27,7,28,7]]}
["B ","الاسم الثلاثي","العمر","ألجنس","الطبيب المرسل",null,null,null,"أسماء الأطباء","عمود مساعد1","عمود مساعد2","عمود مساعد3","قائمة منسدلة"]
[2,"هاشم محمد",12,"ذكر",{"$f":"IFERROR(VLOOKUP($B2,اسماءالمراجعيين!$B$2:$E$6877,4,0),\"\")","v":"د.عمر المحترم"}," ","انثى",null,"د.عمر المحترم",{"$f":"IFERROR(SEARCH(INDIRECT(CELL(\"address\")),I2),0)","v":1},{"$f":"IF(J2=0,\"\",COUNTIF($J$2:J2,\">0\"))","v":1},{"$f":"IFERROR(INDEX(I:I,MATCH(ROW(J1),K:K,0)),\"\")","v":"د.عمر المحترم"}," "]
[3,"عدنان مهند",22,"ذكر",{"$f":"IFERROR(VLOOKUP($B3,اسماءالمراجعيين!$B$2:$E$6877,4,0),\"\")","v":"طارق المحترم"}," ","ذكر",null,"طارق المحترم",1,{"$f":"IF(J3=0,\"\",COUNTIF($J$2:J3,\">0\"))","v":2},"طارق المحترم"]
[4,"عليه حسن",54,"انثى",{"$f":"IFERROR(VLOOKUP($B4,اسماءالمراجعيين!$B$2:$E$6877,4,0),\"\")","v":"د. خالد المحترم"}," ",null,null,"د. خالد المحترم",1,{"$f":"IF(J4=0,\"\",COUNTIF($J$2:J4,\">0\"))","v":3},"د. خالد المحترم"]
[5,"فوزية حسين",44,"انثى",{"$f":"IFERROR(VLOOKUP($B5,اسماءالمراجعيين!$B$2:$E$6877,4,0),\"\")","v":"د. ذنون المحترم"}," ",null,null,"د. ذنون المحترم",1,{"$f":"IF(J5=0,\"\",COUNTIF($J$2:J5,\">0\"))","v":4},"د. ذنون المحترم"]
[6,"عليه حسن",{"$f":"IFERROR(VLOOKUP($B6,اسماءالمراجعيين!$B$2:$E$6871,2,0),\"\")","v":54},{"$f":"IFERROR(VLOOKUP($B6,اسماءالمراجعيين!$B$2:$E$6871,3,0),\"\")","v":"انثى"},{"$f":"IFERROR(VLOOKUP($B6,اسماءالمراجعيين!$B$2:$E$6877,4,0),\"\")","v":"د. خالد المحترم"}," ",null,null,"د. عامر المحترم",1,{"$f":"IF(J6=0,\"\",COUNTIF($J$2:J6,\">0\"))","v":5},"د. عامر المحترم"]
[7," ",{"$f":"IFERROR(VLOOKUP($B7,اسماءالمراجعيين!$B$2:$E$6871,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B7,اسماءالمراجعيين!$B$2:$E$6871,3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B7,اسماءالمراجعيين!$B$2:$E$6877,4,0),\"\")","v":""}," ",null,null,"د.محمد المحترم",1,{"$f":"IF(J7=0,\"\",COUNTIF($J$2:J7,\">0\"))","v":6},"د.محمد المحترم"]
[8," ",{"$f":"IFERROR(VLOOKUP($B8,اسماءالمراجعيين!$B$2:$E$6871,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B8,اسماءالمراجعيين!$B$2:$E$6871,3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B8,اسماءالمراجعيين!$B$2:$E$6877,4,0),\"\")","v":""}," ",null,null,"د. سعد المحترم",1,{"$f":"IF(J8=0,\"\",COUNTIF($J$2:J8,\">0\"))","v":7},"د. سعد المحترم"]
[9," ",{"$f":"IFERROR(VLOOKUP($B9,اسماءالمراجعيين!$B$2:$E$6871,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9,اسماءالمراجعيين!$B$2:$E$6871,3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9,اسماءالمراجعيين!$B$2:$E$6877,4,0),\"\")","v":""}," ",null,null,"الأستاذ عمارالمحترم",1,{"$f":"IF(J9=0,\"\",COUNTIF($J$2:J9,\">0\"))","v":8},"الأستاذ عمارالمحترم"]
[10," ",{"$f":"IFERROR(VLOOKUP($B10,اسماءالمراجعيين!$B$2:$E$6871,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10,اسماءالمراجعيين!$B$2:$E$6871,3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10,اسماءالمراجعيين!$B$2:$E$6877,4,0),\"\")","v":""}," ",null,null,"د. عمر المحترم",1,{"$f":"IF(J10=0,\"\",COUNTIF($J$2:J10,\">0\"))","v":9},"د. عمر المحترم"]
[11,"عند كتابة الاسم والعمر واختار الجنس والوصول الى خلية الطبيب المرسل",null,null,null,null,null,null,"  عبدالرحمن المحترم",1,{"$f":"IF(J11=0,\"\",COUNTIF($J$2:J11,\">0\"))","v":10},"  عبدالرحمن المحترم"]
[12,"عدم فتح القائمة المنسدلة في خلية الطبيب المرسل الا بعد النقر المزدوج في خلية فارغه علما ان الخلية تحتوى على (معادلة والقائمة المنسدلة يمكن البحث فيها). شنو السبب ؟؟",null,null,null,null,null,null,"د. سعد المحترم",1,{"$f":"IF(J12=0,\"\",COUNTIF($J$2:J12,\">0\"))","v":11},"د. سعد المحترم"]
[13,null,null,null,null,null,null,null,"حميد  المحترم",1,{"$f":"IF(J13=0,\"\",COUNTIF($J$2:J13,\">0\"))","v":12},"حميد  المحترم"]
[14,"عندي مشكلة بالتنسيق الشرطي في صفحة  اسماء المراجعين ",null,null,null," ",null,null,"حميد  المحترم",1,{"$f":"IF(J14=0,\"\",COUNTIF($J$2:J14,\">0\"))","v":13},"حميد  المحترم"]
[15," ",null,null,null," ",null,null,"حميد  المحترم",{"$f":"IFERROR(SEARCH(INDIRECT(CELL(\"address\")),I15),0)","v":1},{"$f":"IF(J15=0,\"\",COUNTIF($J$2:J15,\">0\"))","v":14},"حميد  المحترم"]
[16," ",null,null,null," ",null,null,"د. شامل لمحترم",1,{"$f":"IF(J16=0,\"\",COUNTIF($J$2:J16,\">0\"))","v":15},"د. شامل لمحترم"]
[17," ",null,null,null," ",null,null," ",1,{"$f":"IF(J17=0,\"\",COUNTIF($J$2:J17,\">0\"))","v":16}," "]
[18," ",null,null,null," ",null,null," ",1,{"$f":"IF(J18=0,\"\",COUNTIF($J$2:J18,\">0\"))","v":17}," "]
[19," ",null,null,null," ",null,null," ",1,{"$f":"IF(J19=0,\"\",COUNTIF($J$2:J19,\">0\"))","v":18}," "]
[20," ",null,null,null," ",null,null," ",1,{"$f":"IF(J20=0,\"\",COUNTIF($J$2:J20,\">0\"))","v":19}," "]
[21," ",null,null,null," ",null,null," ",1,{"$f":"IF(J21=0,\"\",COUNTIF($J$2:J21,\">0\"))","v":20}," "]
[22," ",null,null,null," ",null,null," ",1,{"$f":"IF(J22=0,\"\",COUNTIF($J$2:J22,\">0\"))","v":21}," "]
[23," ",null,null,null," ",null,null," ",1,{"$f":"IF(J23=0,\"\",COUNTIF($J$2:J23,\">0\"))","v":22}," "]
[24," ",null,null,null," ",null,null," ",1,{"$f":"IF(J24=0,\"\",COUNTIF($J$2:J24,\">0\"))","v":23}," "]
[25," ",null,null,null," ",null,null," ",1,{"$f":"IF(J25=0,\"\",COUNTIF($J$2:J25,\">0\"))","v":24}," "]
[26," ",null,null,null," ",null,null," ",1,{"$f":"IF(J26=0,\"\",COUNTIF($J$2:J26,\">0\"))","v":25}," "]
[27," ",null,null,null," ",null,null," ",1,{"$f":"IF(J27=0,\"\",COUNTIF($J$2:J27,\">0\"))","v":26}," "]
[28," ",null,null,null," ",null,null," ",1,{"$f":"IF(J28=0,\"\",COUNTIF($J$2:J28,\">0\"))","v":27}," "]
[29," ",null,null,null," ",null,null," ",1,{"$f":"IF(J29=0,\"\",COUNTIF($J$2:J29,\">0\"))","v":28}," "]
[30," ",null,null,null," ",null,null," ",{"$f":"IFERROR(SEARCH(INDIRECT(CELL(\"address\")),I30),0)","v":1},{"$f":"IF(J30=0,\"\",COUNTIF($J$2:J30,\">0\"))","v":29}," "]
[31," ",null,null,null," ",null,null," ",1,{"$f":"IF(J31=0,\"\",COUNTIF($J$2:J31,\">0\"))","v":30}," "]
[32," ",null,null,null," ",null,null," ",1,{"$f":"IF(J32=0,\"\",COUNTIF($J$2:J32,\">0\"))","v":31}," "]
[33," ",null,null,null," ",null,null," ",1,{"$f":"IF(J33=0,\"\",COUNTIF($J$2:J33,\">0\"))","v":32}," "]
[34," ",null,null,null," ",null,null," ",1,{"$f":"IF(J34=0,\"\",COUNTIF($J$2:J34,\">0\"))","v":33}," "]
[35," ",null,null,null," ",null,null," ",1,{"$f":"IF(J35=0,\"\",COUNTIF($J$2:J35,\">0\"))","v":34}," "]
[36," ",null,null,null," ",null,null," ",1,{"$f":"IF(J36=0,\"\",COUNTIF($J$2:J36,\">0\"))","v":35}," "]
[37," ",null,null,null," ",null,null," "," ",{"$f":"IF(J37=0,\"\",COUNTIF($J$2:J37,\">0\"))","v":35}," "]
[38," ",null,null,null," "]
[39," ",null,null,null," "]
[40," ",null,null,null," "]
[41," ",null,null,null," "]
[42," ",null,null,null," "]
[43,null,null,null,null," "]
[44," ",null,null,null," "]
[45]
[46]
[47]
[48]
[49]
[50]

{"sheet":"اسماءالمراجعيين","index":1,"n_rows":17,"n_cols":15,"rows_kept":17,"cut":false,"hidden":false,"merged":[[8,1,8,4],[12,1,12,4],[1,1,1,4],[16,1,16,4],[3,5,3,13],[11,6,11,12],[4,5,4,13],[6,5,6,13],[8,5,9,13]]}
[" ","الاسم الثلاثي","العمر","الجنس","الطبيب المرسل"]
[" ","10/12/2019"]
[null,"هاشم محمد",12,"ذكر","د.عمر المحترم"]
[null,"عدنان مهند",22,"ذكر","طارق المحترم","جربت اضيف تنسيقات لهذا الملف لم تصلح"]
[null,"عليه حسن",54,"انثى","د. خالد المحترم","  اضافة تنسيق شرطي لتلوين صفوف الصفحة مثلا صف ازرق وصف اخضر",null,null,null,null,null,null,null,null,1]
[null,"فوزية حسين",44,"انثى","د. ذنون المحترم"]
[null,"عليه حسن",54,"انثى","د. عامر المحترم","كيف يمكن اضافة تنسيق شرطي تلوين الأسماء المكررة في العمود B فقط",null,null,null,null,null,null,null,null,2]
[null,"فوزية حسين",44,"انثى","د.محمد المحترم"]
[null,"11/12/2019",null,null,null," هل يمكن  اضافة تنسيق شرطي  لون معين للتواريخ مع العلم \nان خلية التواريخ مدمجة ",null,null,null,null,null,null,null,null,3]
[null,"هاشم محمد",12,"ذكر","د.عمر المحترم"]
[null,"زيد مهند",22,"ذكر","طارق المحترم"]
[null,"عليه حسن",54,"انثى","د. خالد المحترم"]
[null,"12/12/2019",null,null,null,null,null,null,null," "]
[null,"فوزية حسين",44,"انثى","د. ذنون المحترم"]
[null,"عليه حسن",54,"انثى","د. عامر المحترم"]
[null,"فوزية حسين",44,"انثى","د.محمد المحترم"]
[null,"13/12/2019"]