{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["الشرح","القوائم","مثال1","مثال2","مثال3","مثال4"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":4,"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":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,"  مع تحيات منتدى اوفيسنا    عبدالله باقشير (خبور خير)"]
[null,"شرح امكانيات الفورم وكيفية الاستخدام"]
[]
["1 -","استخدام الفورم لاكثر من قاعدة بيانات  في المصنف"]
[null,"على ان يكون لكل قاعدة كود لاظهار الفورم يتغير فيه معطياتك في متغيرات"]
[null," kh_SetAddrss "]
[null," اولاً : اسم ورقة البيانات                    ( افتراضي )"]
[null,"ثانياً : نطاق صف رؤوس اعمدة البيانات  ( افتراضي )"]
[null,"ثالثاً : عمود التسلسل                         ( اختياري )"]
[null,"اذا اردت ادخال رقم تسلسل البيانات الخاص بالفورم  تلقائيا في عمود معين سجل عنوان راس  العمود  ."]
[null,"مع ملاحظة انه لا يكون من ضمن نطاق رؤوس اعمدة البيانات  كما هو معمول في المثال 2."]
["2 -","تستطيع اضافة قائمة لعمود معين في الفورم باضافة تعليق على عنوان العمود وتكتب اسم نطاق القائمة ."]
["3 -","ينسخ التنسيقات والمعادلات في السجل الجديد   ."]
["4 -","يبحث في جميع الاعمدة حسب الاختيار من القائمة في الفورم    ."]
["5 -","يعطي نتائج صحيحة عند البحث عن تاريخ اذا شيكت الزر البحث عن تاريخ   ."]
["6 -","امكانيات زر البحث عن تاريخ"]
[null,"يتم تحويل اي قيمة تضعها في مربع النص للبحث الى تاريخ بالتنسيق الافتراضي للفورم  ,,"]
[null,"مع امكانية ادخال رقم صحيح بين 1  الى 31  ليفهم على انه تاريخ اليوم للشهر الحالي والسنة الحالية "]
["7 -","ثوابت بامكانك تغييرها حسب طلبك بداية اكواد الفورم"]
[null,"1- تغيير تنسيقات إظهار التاريخ في الفورم  في الثابت DtF  "]
[null,"2- تغيير عٌرض مربعات  الادخال  في الثابت iWgt1  "]

{"sheet":"القوائم","index":1,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["الجنس","البلد"]
["ذكر","تونس"]
["انثى","مصر"]
[null,"اليمن"]
[null,"ليبيا"]
[null,"سوريا"]

{"sheet":"مثال1","index":2,"n_rows":26,"n_cols":41,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"الرقم","رقم القيد","الاسم1","تاريخ الميلاد","محل الميلاد","موقع السكن","الجنســــية","الجـــنس","المعيدون","المحولين إلى المدرسة ","الشعبة","القرآن الكريم/المحصلة الأولى","القرآن الكريم/الامتحان النصفي","القرآن الكريم/المحصلة الثانية","القرآن الكريم/الامتحان النهائي","التربية الإسلامية/المحصلة الأولى","التربية الإسلامية/الامتحان النصفي","التربية الإسلامية/المحصلة الثانية","التربية الإسلامية/الامتحان النهائي","اللغة العربية/المحصلة الأولى","اللغة العربية/الامتحان النصفي","اللغة العربية/المحصلة الثانية","اللغة العربية/الامتحان النهائي","اللغة الإنجليزية/المحصلة الأولى","اللغة الإنجليزية/الامتحان النصفي","اللغة الإنجليزية/المحصلة الثانية","اللغة الإنجليزية/الامتحان النهائي","الرياضيات/المحصلة الأولى","الرياضيات/الامتحان النصفي","الرياضيات/المحصلة الثانية","الرياضيات/الامتحان النهائي","العلوم/المحصلة الأولى","العلوم/الامتحان النصفي","العلوم/المحصلة الثانية","العلوم/الامتحان النهائي","/المحصلة الأولى","/الامتحان النصفي","/المحصلة الثانية","/الامتحان النهائي"]
[null,null,{"$f":"ROWS($D$11:D11)","v":1},1001,"ابراهيم صالح سالم حيمد باشعيوث","2012-10-09","تريم222","بين الكود","يمني","ذكر",16,null,"أ","18,5",24,18,26,18,27,13,19,17,28,18,26,13,22,10,15,16,17,13,20,16,22,15,22]
[null,null,{"$f":"ROWS($D$11:D12)","v":2},1002,"احمد يسلم سعيد سالم  صبيح","2012-10-08","تريم33","مولى عيديد","يمني","أنثى",null,null,"أ",14,10,12,18,14,20,13,19,14,19,19,29,15,13,10,15,13,11,12,14,13,14,11,17]
[null,null,{"$f":"ROWS($D$11:D13)","v":3},1003,"اسامة احمد عمر محمد   باحنان","2012-10-07","الغيظة","الروضة","يمني","أنثى",null,null,"أ",20,30,19,29,18,30,17,25,19,30,19,29,19,19,10,15,18,24,15,23,17,26,20,30]
[null,null,{"$f":"ROWS($D$11:D14)","v":4},1004,"اسماعيل عبيد سعيد فرج بريك","2012-10-06","تريم","الخليف","يمني","أنثى",null,null,"أ",15,20,16,24,16,23,14,22,17,26,18,26,10,9,16,15,12,22,15,23,14,16,11,16]
[null,null,{"$f":"ROWS($D$11:D15)","v":5},1005,"انس سعيد سالم عوض بازهير","2012-10-05","تريم","عيديد","يمني","ذكر",null,null,"أ",14,22,9,14,14,26,13,19,14,21,11,17,16,17,10,15,13,9,14,21,16,13,18,27]
[null,null,{"$f":"ROWS($D$11:D16)","v":6},1006,"ايوب احمد سعيد هادي باضاوي","2012-10-04","تريم","عيديد","يمني","ذكر",0,null,"أ",11,13,11,15,13,24,11,17,13,14,14,22,11,17,10,15,11,10,17,12,14,17,20,30]
[null,null,{"$f":"ROWS($D$11:D17)","v":7},1007,"باسل احمد محمد عمر   باعبود","2012-10-03","تريم","بين الكود","يمني","ذكر",null,null,"أ",18,29,20,30,18,30,19,29,18,29,20,30,19,28,14,21,17,29,17,26,17,28,18,27]
[null,null,{"$f":"ROWS($D$11:D18)","v":8},1008,"بشار كرامة عمر سالم باغيثان","2012-10-02","تريم","الروضة","يمني","ذكر",null,null,"أ",18,20,18,26,16,20,14,21,17,29,17,26,11,15,10,15,14,14,10,12,15,19,13,19]
[null,null,{"$f":"ROWS($D$11:D19)","v":9},1009,"جاسم سالم خميس علي باضاوي","2012-10-01","تريم","عيديد","يمني","ذكر",null,null,"أ",12,11,14,13,14,15,10,11,13,14,10,13,10,7,18,15,11,2,15,23,15,17,13,19]
[null,null,{"$f":"ROWS($D$11:D20)","v":10},1010,"جعفر عبد الكريم احمد عبيد بامقيشم","2012-09-30","تريم","الخليف","يمني","ذكر",null,null,"أ",20,30,20,30,19,29,19,29,20,30,19,29,20,27,11,17,18,25,18,27,18,26,20,30]
[null,null,{"$f":"ROWS($D$11:D21)","v":11},1011,"جلال حسن رمضان فرج باطحان","2012-09-29","تريم","عيديد","يمني","ذكر",null,null,"أ",15,14,17,26,16,30,14,22,15,26,14,20,14,23,12,18,14,18,16,24,15,19,20,30]
[null,null,{"$f":"ROWS($D$11:D22)","v":12},1012,"حداد عبد القادر عطاس عبد القادر الكاف","2012-09-28","تريم","الروضة","يمني","ذكر",null,null,"أ",20,30,19,29,20,30,19,29,20,30,20,30,20,30,19,29,20,30,20,30,20,30,20,30]
[null,null,{"$f":"ROWS($D$11:D23)","v":13},1013,"حسن احمد صالح علي بافضل","2012-09-27","تريم222","البدور","يمني","ذكر",null,null,"أ",19,29,20,30,20,29,20,30,18,29,20,30,20,29,13,20,16,29,19,29,17,30,20,30]
[null,null,{"$f":"ROWS($D$11:D24)","v":14},1014,"حسن بخيت عيسى علي  بريك","2012-09-26","تريم","السوق","يمني","ذكر","معيد",null,"أ",11,22,10,null,11,9,10,null,12,13,null,null,10,5,null,null,13,20,null,null,13,10]
[null,null,{"$f":"ROWS($D$11:D25)","v":15},1015,"حسن سالم احمد مبارك باحريش","2012-09-25","تريم","النويدرة","يمني","ذكر",null,null,"أ",14,24,20,29,15,27,15,22,18,27,18,28,11,12,12,15,15,25,15,23,17,24,15,22]
[null,null,{"$f":"ROWS($D$11:D26)","v":16},1016,"حسن علي احمد عوض باسلماء","1977-03-11","تريم155","الروضة","يمني","ذكر",null,null,"أ",14,10,14,22,14,27,17,26,15,17,18,28,12,16,12,18,13,16,9,12,14,17,16,25,"2012-09-25","تريم","الروضة","يمني"]

{"sheet":"مثال2","index":3,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"م","الاسم2","الجـــنس","الجنســــية","تاريخ الميلاد","محل الميلاد","الراتب"]
[null,1,"الشهابي","ذكر","اليمن","2013-12-11","تونس",1234.55]
[null,2,"محمدي عبد السميع","ذكر","مصر","2012-10-08","مصر",1244.58]
[null,3,"عبد الله باقُشير","ذكر","اليمن","2012-10-07","اليمن",1254.6099999999999]
[null,4,"ابو زياد","ذكر","ليبيا","2012-10-06","ليبيا",1264.6400000000001]
[null,5,"ياسر الحافظ","ذكر","سوريا","2013-12-12","سوريا",1274.67]
[null,6,"خبور1","ذكر","اليمن","2015-02-17","اليمن",1284.7]
[null,7,"خبور2","ذكر","اليمن","2016-04-24","اليمن",1294.73]
[null,8,"خبور3","ذكر","اليمن","2017-06-30","اليمن",1304.76]
[null,9,"خبور4","ذكر","اليمن","2018-09-05","اليمن",1314.79]
[null,10,"خبور5","ذكر","اليمن","2019-11-11","اليمن",1324.82]
[null,11,"خبور6","ذكر","اليمن","2021-01-16","اليمن",1334.85]
[null,12,"خبور7","ذكر","اليمن","2022-03-24","اليمن",1344.88]
[null,13,"خبور8","ذكر","اليمن","2023-05-30","اليمن",1354.91]
[null,14,"خبور9","ذكر","اليمن","2024-08-04","اليمن",1364.94]

{"sheet":"مثال3","index":4,"n_rows":20,"n_cols":41,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"الرقم","رقم القيد","الاسم3","تاريخ الميلاد","محل الميلاد","موقع السكن","الجنســــية","الجـــنس","المعيدون","المحولين إلى المدرسة ","الشعبة","القرآن الكريم/المحصلة الأولى","القرآن الكريم/الامتحان النصفي","القرآن الكريم/المحصلة الثانية","القرآن الكريم/الامتحان النهائي","التربية الإسلامية/المحصلة الأولى","التربية الإسلامية/الامتحان النصفي","التربية الإسلامية/المحصلة الثانية","التربية الإسلامية/الامتحان النهائي","اللغة العربية/المحصلة الأولى","اللغة العربية/الامتحان النصفي","اللغة العربية/المحصلة الثانية","اللغة العربية/الامتحان النهائي","اللغة الإنجليزية/المحصلة الأولى","اللغة الإنجليزية/الامتحان النصفي","اللغة الإنجليزية/المحصلة الثانية","اللغة الإنجليزية/الامتحان النهائي","الرياضيات/المحصلة الأولى","الرياضيات/الامتحان النصفي","الرياضيات/المحصلة الثانية","الرياضيات/الامتحان النهائي","العلوم/المحصلة الأولى","العلوم/الامتحان النصفي","العلوم/المحصلة الثانية","العلوم/الامتحان النهائي","/المحصلة الأولى","/الامتحان النصفي","/المحصلة الثانية","/الامتحان النهائي"]
[null,null,{"$f":"ROWS($D$11:D11)","v":1},1001,"ابراهيم صالح سالم حيمد باشعيوث","2012-10-09","تريم","بين الكود","يمني333","ذكر",16,null,"أ","2018-05-18",24,18,26,18,27,13,19,17,28,18,26,13,22,10,15,16,17,13,20,16,22,15,22]
[null,null,{"$f":"ROWS($D$11:D12)","v":2},1002,"احمد يسلم سعيد سالم  صبيح","2012-10-08","تريم","مولى عيديد","يمني","أنثى",null,null,"أ",14,10,12,18,14,20,13,19,14,19,19,29,15,13,10,15,13,11,12,14,13,14,11,17]
[null,null,{"$f":"ROWS($D$11:D13)","v":3},1003,"حميد","2012-10-07","الغيظة","الروضة","يمني","أنثى",null,null,"أ",20,30,19,29,18,30,17,25,19,30,19,29,19,19,10,15,18,24,15,23,17,26,20,30]
[null,null,{"$f":"ROWS($D$11:D14)","v":4},1004,"اسماعيل عبيد سعيد فرج بريك","2012-10-06","تريم","الخليف222","يمني","أنثى",null,null,"أ",15,20,16,24,16,23,14,22,17,26,18,26,10,9,16,15,12,22,15,23,14,16,11,16]
[null,null,{"$f":"ROWS($D$11:D15)","v":5},1005,"انس سعيد سالم عوض بازهير","2012-10-05","تريم","عيديد","يمني","ذكر",null,null,"أ",14,22,9,14,14,26,13,19,14,21,11,17,16,17,10,15,13,9,14,21,16,13,18,27]
[null,null,{"$f":"ROWS($D$11:D16)","v":6},1006,"هاشم","2012-10-04","تريم","عيديد11","يمني","ذكر",0,null,"أ",11,13,11,15,13,24,11,17,13,14,14,22,11,17,10,15,11,10,17,12,14,17,20,30]
[null,null,{"$f":"ROWS($D$11:D17)","v":7},1007,"باسل احمد محمد عمر   باعبود","2012-10-03","تريم","بين الكود","يمني","ذكر",null,null,"أ",18,29,20,30,18,30,19,29,18,29,20,30,19,28,14,21,17,29,17,26,17,28,18,27]
[null,null,{"$f":"ROWS($D$11:D18)","v":8},1008,"بشار كرامة عمر سالم باغيثان","2012-10-02","تريم","الروضة","يمني","ذكر",null,null,"أ",18,20,18,26,16,20,14,21,17,29,17,26,11,15,10,15,14,14,10,12,15,19,13,19]
[null,null,{"$f":"ROWS($D$11:D19)","v":9},1009,"كمال","2012-10-01","تريم","عيديد","يمني","ذكر",null,null,"أ",12,11,14,13,14,15,10,11,13,14,10,13,10,7,18,15,11,2,15,23,15,17,13,19]
[null,null,{"$f":"ROWS($D$11:D20)","v":10},1010,"جعفر عبد الكريم احمد عبيد بامقيشم","2012-09-30","تريم2221","الخليف","يمني55","ذكر",null,null,"أ",20,30,20,30,19,29,19,29,20,30,19,29,20,27,11,17,18,25,18,27,18,26,20,30]

{"sheet":"مثال4","index":5,"n_rows":24,"n_cols":41,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"الرقم","رقم القيد","الاسم4","تاريخ الميلاد","محل الميلاد","موقع السكن","الجنســــية","الجـــنس","المعيدون","المحولين إلى المدرسة ","الشعبة","القرآن الكريم/المحصلة الأولى","القرآن الكريم/الامتحان النصفي","القرآن الكريم/المحصلة الثانية","القرآن الكريم/الامتحان النهائي","التربية الإسلامية/المحصلة الأولى","التربية الإسلامية/الامتحان النصفي","التربية الإسلامية/المحصلة الثانية","التربية الإسلامية/الامتحان النهائي","اللغة العربية/المحصلة الأولى","اللغة العربية/الامتحان النصفي","اللغة العربية/المحصلة الثانية","اللغة العربية/الامتحان النهائي","اللغة الإنجليزية/المحصلة الأولى","اللغة الإنجليزية/الامتحان النصفي","اللغة الإنجليزية/المحصلة الثانية","اللغة الإنجليزية/الامتحان النهائي","الرياضيات/المحصلة الأولى","الرياضيات/الامتحان النصفي","الرياضيات/المحصلة الثانية","الرياضيات/الامتحان النهائي","العلوم/المحصلة الأولى","العلوم/الامتحان النصفي","العلوم/المحصلة الثانية","العلوم/الامتحان النهائي","/المحصلة الأولى","/الامتحان النصفي","/المحصلة الثانية","/الامتحان النهائي"]
[null,null,{"$f":"ROWS($D$11:D11)","v":1},1001,"ابراهيم صالح سالم حيمد باشعيوث","2012-10-09","تريم222","بين الكود","يمني","ذكر",16,null,"أ","18,5",24,18,26,18,27,13,19,17,28,18,26,13,22,10,15,16,17,13,20,16,22,15,22]
[null,null,{"$f":"ROWS($D$11:D12)","v":2},1002,"احمد يسلم سعيد سالم  صبيح","2012-10-08","تريم33","مولى عيديد","يمني","أنثى",null,null,"أ",14,10,12,18,14,20,13,19,14,19,19,29,15,13,10,15,13,11,12,14,13,14,11,17]
[null,null,{"$f":"ROWS($D$11:D13)","v":3},1003,"اسامة احمد عمر محمد   باحنان","2012-10-07","الغيظة","الروضة","يمني","أنثى",null,null,"أ",20,30,19,29,18,30,17,25,19,30,19,29,19,19,10,15,18,24,15,23,17,26,20,30]
[null,null,{"$f":"ROWS($D$11:D14)","v":4},1004,"اسماعيل عبيد سعيد فرج بريك","2012-10-06","تريم","الخليف","يمني","أنثى",null,null,"أ",15,20,16,24,16,23,14,22,17,26,18,26,10,9,16,15,12,22,15,23,14,16,11,16]
[null,null,{"$f":"ROWS($D$11:D15)","v":5},1005,"انس سعيد سالم عوض بازهير","2012-10-05","تريم","عيديد","يمني","ذكر",null,null,"أ",14,22,9,14,14,26,13,19,14,21,11,17,16,17,10,15,13,9,14,21,16,13,18,27]
[null,null,{"$f":"ROWS($D$11:D16)","v":6},1006,"ايوب احمد سعيد هادي باضاوي","2012-10-04","تريم","عيديد","يمني","ذكر",0,null,"أ",11,13,11,15,13,24,11,17,13,14,14,22,11,17,10,15,11,10,17,12,14,17,20,30]
[null,null,{"$f":"ROWS($D$11:D17)","v":7},1007,"باسل احمد محمد عمر   باعبود","2012-10-03","تريم","بين الكود","يمني","ذكر",null,null,"أ",18,29,20,30,18,30,19,29,18,29,20,30,19,28,14,21,17,29,17,26,17,28,18,27]
[null,null,{"$f":"ROWS($D$11:D18)","v":8},1008,"بشار كرامة عمر سالم باغيثان","2012-10-02","تريم","الروضة","يمني","ذكر",null,null,"أ",18,20,18,26,16,20,14,21,17,29,17,26,11,15,10,15,14,14,10,12,15,19,13,19]
[null,null,{"$f":"ROWS($D$11:D19)","v":9},1009,"جاسم سالم خميس علي باضاوي","2012-10-01","تريم","عيديد","يمني","ذكر",null,null,"أ",12,11,14,13,14,15,10,11,13,14,10,13,10,7,18,15,11,2,15,23,15,17,13,19]
[null,null,{"$f":"ROWS($D$11:D20)","v":10},1010,"جعفر عبد الكريم احمد عبيد بامقيشم","2012-09-30","تريم","الخليف","يمني","ذكر",null,null,"أ",20,30,20,30,19,29,19,29,20,30,19,29,20,27,11,17,18,25,18,27,18,26,20,30]
[null,null,{"$f":"ROWS($D$11:D21)","v":11},1011,"جلال حسن رمضان فرج باطحان","2012-09-29","تريم","عيديد","يمني","ذكر",null,null,"أ",15,14,17,26,16,30,14,22,15,26,14,20,14,23,12,18,14,18,16,24,15,19,20,30]
[null,null,{"$f":"ROWS($D$11:D22)","v":12},1012,"حداد عبد القادر عطاس عبد القادر الكاف","2012-09-28","تريم","الروضة","يمني","ذكر",null,null,"أ",20,30,19,29,20,30,19,29,20,30,20,30,20,30,19,29,20,30,20,30,20,30,20,30]
[null,null,{"$f":"ROWS($D$11:D23)","v":13},1013,"حسن احمد صالح علي بافضل","2012-09-27","تريم222","البدور","يمني","ذكر",null,null,"أ",19,29,20,30,20,29,20,30,18,29,20,30,20,29,13,20,16,29,19,29,17,30,20,30]
[null,null,{"$f":"ROWS($D$11:D24)","v":14},1014,"حسن بخيت عيسى علي  بريك","2012-09-26","تريم","السوق","يمني","ذكر","معيد",null,"أ",11,22,10,null,11,9,10,null,12,13,null,null,10,5,null,null,13,20,null,null,13,10]