{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["قائمة البيانات","الرتب","الاستعلام عن اسماء المغتمرين","R100"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":2,"defined_names":1,"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":53,"n_cols":7,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["رقم الحافلة ","رقم الرحلة ","نوع الرحلة ","تاريخ الرحلة ","اسم المرشد ","فندق المدينة المنورة ","فندق مكة المكرمة "]
[1,"R100","طيران ","25-9-2018","علي القرم ","الايمان رويال ","انجم "]
[1,"R101","حافلات VIP","26-9-2018","فوزي شحادة ","ديار طابا ","صفوة الضيافة "]
[1,"R102","حافلات  VIP","14-11-2018","احمد ابو بكر ","ديار طابا ","رويال "]
[1,"R103","حافلات VIP","2018-05-12","ارود ابو النور","ديار طابا "]
[1,"R104"]
[1,"R105"]
[1,"R106"]
[1,"R107"]
[null,"R108"]
[null,"R109"]
[null,"R110"]
[1,"R111"]
[null,"R112"]
[null,"R113"]
[null,"R114"]
[null,"R115"]
[null,"R116"]
[null,"R117"]
[null,"R118"]
[null,"R119"]
[null,"R120"]
[null,"R121"]
[null,"R122"]
[null,"R123"]
[null,"R124"]
[null,"R125"]
[null,"R126"]
[null,"R127"]
[null,"R128"]
[null,"R129"]
[null,"R130"]
[null,"R131"]
[null,"R132"]
[null,"R133"]
[null,"R134"]
[null,"R135"]
[null,"R136"]
[null,"R137","طيران "]
[null,"R138"]
[null,"R139"]
[null,"R140"]
[2,"R141","حافلات سياحية ","2018-06-01","سعيد","ديار طابا ","دار الايمان اجياد"]
[null,"R142"]
[null,"R143"]
[null,"R144"]
[null,"R145"]
[null,"R146"]
[null,"R147"]
[null,"R148"]
[null,"R149"]
[null,"R150","حافلات سياحية ","2019-10-01","سعد ","ديار طابا ","دار الايمان اجياد"]
[2,"اللل","للللل",25222,2222,"قفقف"]

{"sheet":"الرتب","index":1,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["م","الدرجة"]
[1,"عسكرى"]
[2,"عريف",null,"Degree"]
[3,"رقيب"]
[4,"رقيب أول"]
[5,"مساعد"]
[6,"مساعد أول"]
[7,"ملازم"]
[8,"ملازم أول"]
[9,"نقيب"]
[10,"رائد"]
[11,"مقدم"]
[12,"عقيد"]
[13,"عميد"]
[14,"لواء"]
[15,"فريق"]
[16,"فريق أول"]
[17,"مشير"]

{"sheet":"الاستعلام عن اسماء المغتمرين","index":2,"n_rows":45,"n_cols":13,"rows_kept":45,"cut":false,"hidden":false,"merged":[[77,2,77,3],[77,6,77,7],[77,8,77,9],[78,2,78,3],[78,6,78,7],[78,8,78,9],[72,1,76,1],[72,2,72,3],[72,6,72,7],[72,8,72,9],[73,6,73,7],[73,8,73,9],[74,2,74,3],[76,2,76,3],[76,6,76,7],[76,8,76,9],[74,6,74,7],[74,8,74,9],[75,2,75,3],[75,6,75,7],[75,8,75,9],[67,1,70,1],[67,2,67,3],[67,6,67,7],[67,8,67,9],[68,2,68,3],[68,6,68,7],[68,8,68,9],[69,2,69,3],[69,6,69,7],[69,8,69,9],[70,2,70,3],[70,6,70,7],[70,8,70,9],[63,1,65,1],[63,2,63,3],[63,6,63,7],[63,8,63,9],[64,2,64,3],[64,6,64,7],[64,8,64,9],[65,2,65,3],[65,6,65,7],[65,8,65,9],[9,11,9,12],[5,2,6,4],[60,1,61,1],[60,2,60,3],[61,2,61,3],[9,8,9,9],[44,0,44,9],[53,3,54,4],[56,7,56,8],[58,7,58,8],[59,1,59,9]]}
[]
[]
[]
[null,null,null,null,null,null,null,"قائمة البيانات"]
[]
[null,null,"الاستعلام عن اسماء المعتمرين "]
[null,null,null,null,null,{"$f":"IFERROR(INDEX([1]البيانات!$A$2:$A$1000,MATCH($B$9,[1]البيانات!$B$2:$B$1000,0)),\"\")","v":""}]
[]
["رقم الرحلة",null,null,"نوع الرحلة",null,null,"فندق المدينة المنورة  ",null,null,"رقم الحافلة "]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,[1]البيانات!$B$2:$D$1000,3,0)=\"\",\"\",VLOOKUP($B$9,[1]البيانات!$B$2:$D$1000,3,0)),\"\")","v":""},null,"اسم المرشد",null,null,"فندق مكة المكرمة"]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","المبيعات","المبلغ المقبوض ","الرصيد "]
[1,"محمد ","رجل ","مصرى",2135206,1236555211,"2018-01-01","2019-12-10","ننن","طيران",null,2000,3000]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
["الاجمالي",null,null,null,null,null,null,null,null,null,null,2000,3000]

{"sheet":"R100","index":3,"n_rows":45,"n_cols":13,"rows_kept":45,"cut":false,"hidden":false,"merged":[[56,7,56,8],[5,2,6,4],[9,8,9,9],[9,11,9,12],[44,0,44,9],[53,3,54,4],[63,1,65,1],[63,2,63,3],[63,6,63,7],[63,8,63,9],[64,2,64,3],[58,7,58,8],[59,1,59,9],[60,1,61,1],[60,2,60,3],[61,2,61,3],[67,1,70,1],[67,2,67,3],[67,6,67,7],[67,8,67,9],[68,2,68,3],[70,2,70,3],[70,6,70,7],[70,8,70,9],[64,6,64,7],[64,8,64,9],[65,2,65,3],[65,6,65,7],[65,8,65,9],[68,6,68,7],[68,8,68,9],[69,2,69,3],[69,6,69,7],[69,8,69,9],[72,1,76,1],[72,2,72,3],[72,6,72,7],[72,8,72,9],[73,6,73,7],[73,8,73,9],[74,2,74,3],[74,6,74,7],[74,8,74,9],[75,2,75,3],[78,2,78,3],[78,6,78,7],[78,8,78,9],[75,6,75,7],[75,8,75,9],[76,2,76,3],[76,6,76,7],[76,8,76,9],[77,2,77,3],[77,6,77,7],[77,8,77,9]]}
[]
[]
[]
[null,null,null,null,null,null,null,"قائمة البيانات"]
[]
[null,null," اسماء المعتمرين "]
[null,null,null,null,null,{"$f":"IFERROR(INDEX([1]البيانات!$A$2:$A$1000,MATCH($B$9,[1]البيانات!$B$2:$B$1000,0)),\"\")","v":""}]
[]
["رقم الرحلة",null,null,"نوع الرحلة",null,null,"فندق المدينة المنورة  ",null,null,"رقم الحافلة "]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,[1]البيانات!$B$2:$D$1000,3,0)=\"\",\"\",VLOOKUP($B$9,[1]البيانات!$B$2:$D$1000,3,0)),\"\")","v":""},null,"اسم المرشد",null,null,"فندق مكة المكرمة"]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","المبيعات","المبلغ المقبوض ","الرصيد "]
[1,"محمد ","رجل ","مصرى",2135206,1236555211,"2018-01-01","2019-12-10","ننن","طيران",null,2000,3000]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
["الاجمالي",null,null,null,null,null,null,null,null,null,null,2000,3000]