{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["الاسئلة","الاختبارات","اسماء المتسابقين"],"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":"الاسئلة","index":0,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["م","الاسم","الاختيار 1","الاختيار 2","الاختيار 3","الاختيار 4","الإجابة"]
[1,"من هو الصديق","عمر بن الخطاب","عثمان بن عفان","أبو بكر – عبد الله بن قحافة","علي بن أبي طالب","أبو بكر – عبد الله بن قحافة"]
[2,"الفاروق - شهيد المحراب","عبدالله بن عباس","سعد بن أبي وقاص","عبدالله بن الزبير","عمر بن الخطاب","عمر بن الخطاب"]
[3,"ذو النورين","الزبير بن العوام","عثمان بن عفان","عبدالرحمن بن عوف","أبو عبيدة عامر بن الجراح","عثمان بن عفان"]
[4,"فدائي الهجرة","علي بن أبي طالب","عمر بن الخطاب","عثمان بن عفان","أبو بكر – عبد الله بن قحافة","علي بن أبي طالب"]
[5,"حبر الأمة - ترجمان القرآن","عبدالله بن عباس","سعد بن أبي وقاص","عبدالله بن عباس","عبدالله بن الزبير","عبدالله بن عباس"]
[6,"الأسد في براثنه","أسامة بن حارثة","سعد بن أبي وقاص","الحسن والحسين","بلال بن رباح","سعد بن أبي وقاص"]
[7,"أسد الله - سيد الشهداء","العباس بن عبدالمطلب","الزبير بن العوام","حمزة بن عبدالمطلب","أبو عبيدة عامر بن الجراح","حمزة بن عبدالمطلب"]
[8,"خطيب رسول الله","ثابت بن قيس","خالد بن الوليد","زيد بن حارثة","أسامة بن حارثة","ثابت بن قيس"]
[9,"صاحبة الهجرتين","حفصة بنت عمر","أسماء بنت عميس","نسيبة بنت كعب الأنصارية","أم حرام","أسماء بنت عميس"]
[10,"حِبُ رسول الله","خبيب بن عدي","عكرمة بن أبي جهل","عمرو بن العاص","زيد بن حارثة","زيد بن حارثة"]
[11,"ريحانتي الرسول","جعفر بن أبي طالب","الحسن والحسين","بلال بن رباح","حسان بن ثابت","الحسن والحسين"]
[12,"مدة خلافة أبو بكر الصديق","4 سنوات و 3 اشهر","11 سنة","سنتان و3 أشهر","8 سنوات و 6 اشهر","سنتان و3 أشهر"]
[13,"مدة خلافة عمر بن الخطاب","6 سنوات و8 اشهر","10 سنوات و4 أشهر","3 سنوات و 4 اشهر","7 سنوات وشهران","10 سنوات و4 أشهر"]
[14,"مدة خلافة عثمان بن عفان","12 سنة","11 سنة","6 سنوات","9 سنوات","12 سنة"]
[15," مدة خلافةعلي بن أبي طالب","3 سنوت و 5 اشهر","4 سنوات","13 سنة ","5 سنوات","5 سنوات"]

{"sheet":"الاختبارات","index":1,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,2,0,8],[1,2,1,7],[10,2,13,3],[2,5,2,8]]}
[null,null,"السلام عليكم ورحمة الله وبركاته بعد البحث في المنتدى وجدت ضالتى في هذا الكود وهو وضع مؤشر الفارة على اى إجابة تظهر النتيجة في الخلية D10 وهو المطلوب بالبضط\n"]
[null,null,"ولكن متبقى بعض اللمسات الفنية منكم وهو عند وضع مؤشر الفارة على الاجوابة ان كانت الإجابة صحية تميض لون اخضر لبضع ثوانى وان كانت خاطئة تميض لون احمر لبضع ثوانى ثم يتم تغير السؤال الى وفي الخلية C9 الى السؤال الثالى بدون تدخل منى وهكذا + عمل كود مؤقت زمنى لسؤال وهو 30 ثانية وعند الانتهاء من 30 ثانية ثم يتم تغير السؤال الى وفي الخلية C9 الى السؤال الثالى بدون تدخل منى وهكذا",null,null,null,null,null,null,null,{"$f":"VLOOKUP(RIGHT(C8,LEN(C8)-SEARCH(\":\",C8))*1,الاسئلة!$A$2:$G$16,7,0)","v":"سعد بن أبي وقاص"}]
["ملحوظة لكل طالب 5 أسئلة على أساس ذلك يتم الترحيل",null,"اسم المتسابق","تلميذ 1",null,"اخر الشروط ترحيل اسم المتسابق والصف والاجوابة ان كانت صحية او خاطئة الى شيت أسماء المتسابقين وفى الخلية D5 تحسب الاجوابة الصحيحة  وفى الخلية D6 تحسب الاجوابةا الخاطئة نموذج ترحيل اسم المتسابق يوجد في شيت أسماء المتسابقين"]
["ولكم منا جزيل الشكر والاحترام",null,"الصف الذى به الطالب","السادس"]
[null,null,"الاجوابة الصحيحة",4,null,"مؤقت زمنى للاسئلة"]
[null,null,"الاجوابة الخاطئة",1]
[null,null,null,null,null,"بيان النتيجة",{"$f":"IF(D10=K2,\"إجابة صحيحة\",\"إجابة خاطئة\")","v":"إجابة صحيحة"}]
[null,null,"السؤال السادس :6",{"$f":"VLOOKUP(RIGHT(C8,LEN(C8)-SEARCH(\":\",C8))*1,الاسئلة!$A$2:$G$16,2,0)","v":"الأسد في براثنه"}]
[]
[null,null,"الإجابة","سعد بن أبي وقاص"]
[]
[null,{"$f":"VLOOKUP(RIGHT(C8,LEN(C8)-SEARCH(\":\",C8))*1,الاسئلة!$A$2:$G$16,3,0)","v":"أسامة بن حارثة"},null,null,{"$f":"VLOOKUP(RIGHT(C8,LEN(C8)-SEARCH(\":\",C8))*1,الاسئلة!$A$2:$G$16,4,0)","v":"سعد بن أبي وقاص"}]
[]
[null,{"$f":"VLOOKUP(RIGHT(C8,LEN(C8)-SEARCH(\":\",C8))*1,الاسئلة!$A$2:$G$16,5,0)","v":"الحسن والحسين"},null,null,{"$f":"VLOOKUP(RIGHT(C8,LEN(C8)-SEARCH(\":\",C8))*1,الاسئلة!$A$2:$G$16,6,0)","v":"بلال بن رباح"}]

{"sheet":"اسماء المتسابقين","index":2,"n_rows":319,"n_cols":12,"rows_kept":319,"cut":false,"hidden":false,"merged":[[2,8,2,9],[2,10,2,11],[1,8,1,11],[10,7,15,12]]}
[]
[null,null,null,null,null,null,null,null,"جدول التوزيع"]
["اسم المتسابق","الصف الذى به الطالب","الاجوابة الصحيحة","الاجوابة الخاطئة","رقم الجلوس","رقم السرى",null,null,"رقم الجلوس",null,"الرقم السرى"]
["تلميذ 1","السادس",4,1,1,236,null,null,"من","الى","من","الى"]
[null,null,null,null,2,237,"وهذا هو النوذج الإجابة",null,1,81,236,316]
[null,null,null,null,3,238,null,null,82,316,1,235]
[null,null,null,null,4,239]
[null,null,null,null,5,240]
[null,null,null,null,6,241]
[null,null,null,null,7,242]
[null,null,null,null,8,243,null,"وفى هذا الشيت عمل توزيع ارقام سرية لكل طالب يعنى رقم الجلوس من رقم 1 الى رقم 81 يوضع ارقام السرية من الجدول من 236 الى 316 ويقف ثم يبدء من رقم الجلوس 82 الى رقم الجلوس 316 يوضع الأرقام السرية من 1 الى 235 كما هو موضح في هذا المثال ولكم منا كل الاحترام والتقدير والشكر الى ما تقدومنه من مساعدات"]
[null,null,null,null,9,244]
[null,null,null,null,10,245]
[null,null,null,null,11,246]
[null,null,null,null,12,247]
[null,null,null,null,13,248]
[null,null,null,null,14,249]
[null,null,null,null,15,250]
[null,null,null,null,16,251]
[null,null,null,null,17,252]
[null,null,null,null,18,253]
[null,null,null,null,19,254]
[null,null,null,null,20,255]
[null,null,null,null,21,256]
[null,null,null,null,22,257]
[null,null,null,null,23,258]
[null,null,null,null,24,259]
[null,null,null,null,25,260]
[null,null,null,null,26,261]
[null,null,null,null,27,262]
[null,null,null,null,28,263]
[null,null,null,null,29,264]
[null,null,null,null,30,265]
[null,null,null,null,31,266]
[null,null,null,null,32,267]
[null,null,null,null,33,268]
[null,null,null,null,34,269]
[null,null,null,null,35,270]
[null,null,null,null,36,271]
[null,null,null,null,37,272]
[null,null,null,null,38,273]
[null,null,null,null,39,274]
[null,null,null,null,40,275]
[null,null,null,null,41,276]
[null,null,null,null,42,277]
[null,null,null,null,43,278]
[null,null,null,null,44,279]
[null,null,null,null,45,280]
[null,null,null,null,46,281]
[null,null,null,null,47,282]
[null,null,null,null,48,283]
[null,null,null,null,49,284]
[null,null,null,null,50,285]
[null,null,null,null,51,286]
[null,null,null,null,52,287]
[null,null,null,null,53,288]
[null,null,null,null,54,289]
[null,null,null,null,55,290]
[null,null,null,null,56,291]
[null,null,null,null,57,292]
[null,null,null,null,58,293]
[null,null,null,null,59,294]
[null,null,null,null,60,295]
[null,null,null,null,61,296]
[null,null,null,null,62,297]
[null,null,null,null,63,298]
[null,null,null,null,64,299]
[null,null,null,null,65,300]
[null,null,null,null,66,301]
[null,null,null,null,67,302]
[null,null,null,null,68,303]
[null,null,null,null,69,304]
[null,null,null,null,70,305]
[null,null,null,null,71,306]
[null,null,null,null,72,307]
[null,null,null,null,73,308]
[null,null,null,null,74,309]
[null,null,null,null,75,310]
[null,null,null,null,76,311]
[null,null,null,null,77,312]
[null,null,null,null,78,313]
[null,null,null,null,79,314]
[null,null,null,null,80,315]
[null,null,null,null,81,316]
[null,null,null,null,82,1]
[null,null,null,null,83,2]
[null,null,null,null,84,3]
[null,null,null,null,85,4]
[null,null,null,null,86,5]
[null,null,null,null,87,6]
[null,null,null,null,88,7]
[null,null,null,null,89,8]
[null,null,null,null,90,9]
[null,null,null,null,91,10]
[null,null,null,null,92,11]
[null,null,null,null,93,12]
[null,null,null,null,94,13]
[null,null,null,null,95,14]
[null,null,null,null,96,15]
[null,null,null,null,97,16]
[null,null,null,null,98,17]
[null,null,null,null,99,18]
[null,null,null,null,100,19]
[null,null,null,null,101,20]
[null,null,null,null,102,21]
[null,null,null,null,103,22]
[null,null,null,null,104,23]
[null,null,null,null,105,24]
[null,null,null,null,106,25]
[null,null,null,null,107,26]
[null,null,null,null,108,27]
[null,null,null,null,109,28]
[null,null,null,null,110,29]
[null,null,null,null,111,30]
[null,null,null,null,112,31]
[null,null,null,null,113,32]
[null,null,null,null,114,33]
[null,null,null,null,115,34]
[null,null,null,null,116,35]
[null,null,null,null,117,36]
[null,null,null,null,118,37]
[null,null,null,null,119,38]
[null,null,null,null,120,39]
[null,null,null,null,121,40]
[null,null,null,null,122,41]
[null,null,null,null,123,42]
[null,null,null,null,124,43]
[null,null,null,null,125,44]
[null,null,null,null,126,45]
[null,null,null,null,127,46]
[null,null,null,null,128,47]
[null,null,null,null,129,48]
[null,null,null,null,130,49]
[null,null,null,null,131,50]
[null,null,null,null,132,51]
[null,null,null,null,133,52]
[null,null,null,null,134,53]
[null,null,null,null,135,54]
[null,null,null,null,136,55]
[null,null,null,null,137,56]
[null,null,null,null,138,57]
[null,null,null,null,139,58]
[null,null,null,null,140,59]
[null,null,null,null,141,60]
[null,null,null,null,142,61]
[null,null,null,null,143,62]
[null,null,null,null,144,63]
[null,null,null,null,145,64]
[null,null,null,null,146,65]
[null,null,null,null,147,66]
[null,null,null,null,148,67]
[null,null,null,null,149,68]
[null,null,null,null,150,69]
[null,null,null,null,151,70]
[null,null,null,null,152,71]
[null,null,null,null,153,72]
[null,null,null,null,154,73]
[null,null,null,null,155,74]
[null,null,null,null,156,75]
[null,null,null,null,157,76]
[null,null,null,null,158,77]
[null,null,null,null,159,78]
[null,null,null,null,160,79]
[null,null,null,null,161,80]
[null,null,null,null,162,81]
[null,null,null,null,163,82]
[null,null,null,null,164,83]
[null,null,null,null,165,84]
[null,null,null,null,166,85]
[null,null,null,null,167,86]
[null,null,null,null,168,87]
[null,null,null,null,169,88]
[null,null,null,null,170,89]
[null,null,null,null,171,90]
[null,null,null,null,172,91]
[null,null,null,null,173,92]
[null,null,null,null,174,93]
[null,null,null,null,175,94]
[null,null,null,null,176,95]
[null,null,null,null,177,96]
[null,null,null,null,178,97]
[null,null,null,null,179,98]
[null,null,null,null,180,99]
[null,null,null,null,181,100]
[null,null,null,null,182,101]
[null,null,null,null,183,102]
[null,null,null,null,184,103]
[null,null,null,null,185,104]
[null,null,null,null,186,105]
[null,null,null,null,187,106]
[null,null,null,null,188,107]
[null,null,null,null,189,108]
[null,null,null,null,190,109]
[null,null,null,null,191,110]
[null,null,null,null,192,111]
[null,null,null,null,193,112]
[null,null,null,null,194,113]
[null,null,null,null,195,114]
[null,null,null,null,196,115]
[null,null,null,null,197,116]
[null,null,null,null,198,117]
[null,null,null,null,199,118]
[null,null,null,null,200,119]
[null,null,null,null,201,120]
[null,null,null,null,202,121]
[null,null,null,null,203,122]
[null,null,null,null,204,123]
[null,null,null,null,205,124]
[null,null,null,null,206,125]
[null,null,null,null,207,126]
[null,null,null,null,208,127]
[null,null,null,null,209,128]
[null,null,null,null,210,129]
[null,null,null,null,211,130]
[null,null,null,null,212,131]
[null,null,null,null,213,132]
[null,null,null,null,214,133]
[null,null,null,null,215,134]
[null,null,null,null,216,135]
[null,null,null,null,217,136]
[null,null,null,null,218,137]
[null,null,null,null,219,138]
[null,null,null,null,220,139]
[null,null,null,null,221,140]
[null,null,null,null,222,141]
[null,null,null,null,223,142]
[null,null,null,null,224,143]
[null,null,null,null,225,144]
[null,null,null,null,226,145]
[null,null,null,null,227,146]
[null,null,null,null,228,147]
[null,null,null,null,229,148]
[null,null,null,null,230,149]
[null,null,null,null,231,150]
[null,null,null,null,232,151]
[null,null,null,null,233,152]
[null,null,null,null,234,153]
[null,null,null,null,235,154]
[null,null,null,null,236,155]
[null,null,null,null,237,156]
[null,null,null,null,238,157]
[null,null,null,null,239,158]
[null,null,null,null,240,159]
[null,null,null,null,241,160]
[null,null,null,null,242,161]
[null,null,null,null,243,162]
[null,null,null,null,244,163]
[null,null,null,null,245,164]
[null,null,null,null,246,165]
[null,null,null,null,247,166]
[null,null,null,null,248,167]
[null,null,null,null,249,168]
[null,null,null,null,250,169]
[null,null,null,null,251,170]
[null,null,null,null,252,171]
[null,null,null,null,253,172]
[null,null,null,null,254,173]
[null,null,null,null,255,174]
[null,null,null,null,256,175]
[null,null,null,null,257,176]
[null,null,null,null,258,177]
[null,null,null,null,259,178]
[null,null,null,null,260,179]
[null,null,null,null,261,180]
[null,null,null,null,262,181]
[null,null,null,null,263,182]
[null,null,null,null,264,183]
[null,null,null,null,265,184]
[null,null,null,null,266,185]
[null,null,null,null,267,186]
[null,null,null,null,268,187]
[null,null,null,null,269,188]
[null,null,null,null,270,189]
[null,null,null,null,271,190]
[null,null,null,null,272,191]
[null,null,null,null,273,192]
[null,null,null,null,274,193]
[null,null,null,null,275,194]
[null,null,null,null,276,195]
[null,null,null,null,277,196]
[null,null,null,null,278,197]
[null,null,null,null,279,198]
[null,null,null,null,280,199]
[null,null,null,null,281,200]
[null,null,null,null,282,201]
[null,null,null,null,283,202]
[null,null,null,null,284,203]
[null,null,null,null,285,204]
[null,null,null,null,286,205]
[null,null,null,null,287,206]
[null,null,null,null,288,207]
[null,null,null,null,289,208]
[null,null,null,null,290,209]
[null,null,null,null,291,210]
[null,null,null,null,292,211]
[null,null,null,null,293,212]
[null,null,null,null,294,213]
[null,null,null,null,295,214]
[null,null,null,null,296,215]
[null,null,null,null,297,216]
[null,null,null,null,298,217]
[null,null,null,null,299,218]
[null,null,null,null,300,219]
[null,null,null,null,301,220]
[null,null,null,null,302,221]
[null,null,null,null,303,222]
[null,null,null,null,304,223]
[null,null,null,null,305,224]
[null,null,null,null,306,225]
[null,null,null,null,307,226]
[null,null,null,null,308,227]
[null,null,null,null,309,228]
[null,null,null,null,310,229]
[null,null,null,null,311,230]
[null,null,null,null,312,231]
[null,null,null,null,313,232]
[null,null,null,null,314,233]
[null,null,null,null,315,234]
[null,null,null,null,316,235]