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

{"sheet":"R100","index":1,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[14,0,14,9],[5,2,6,3],[8,10,8,11],[10,8,10,9],[10,10,10,11],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[8,8,8,9]]}
[]
[3,"للللل","لللل","للل"]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":1}]
[]
["رقم الرحلة","R100",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":"طيران "},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":"الايمان رويال "}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":"25-9-2018"},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":"علي القرم "},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":"انجم "}]
[]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF($C$17:$C$100,\"رجل\")","v":2},{"$f":"COUNTIF($C$17:$C$100,\"نساء\")","v":0},{"$f":"COUNTIF($C$17:$C$100,\"طفل\")","v":0},{"$f":"A14+B14+C14","v":2}]
["الاجمالي",null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,$K$17:$K$997)","v":150},{"$f":"SUBTOTAL(9,$L$17:$L$997)","v":200}]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[1,"أحمد يوسف","رجل","مصرى",1001,1063220,"2018-10-01","2019-09-01","عمر محمد","طيران",150,200]
[2,"سعيد رضوان","رجل"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(B45=\"\",\"\",SUBTOTAL(3,$B$17:B45))","v":""}]

{"sheet":"R101","index":2,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[10,5,10,6],[8,8,8,9],[5,2,6,3],[10,3,10,4],[8,3,8,4]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":1}]
[]
["رقم الرحلة","R101",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":"حافلات VIP"},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":"ديار طابا "}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":"26-9-2018"},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":"فوزي شحادة "},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":"صفوة الضيافة "}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[1,"فوزي حسن جبر شحادة","رجل ","مصرى",9681818453,4632509,"17-09-2018","16-09-2023","ننن","طيران",2000,3000]
[2,"محمد عيسى حمدان كوازبه","رجل ",null,904569340,3823218,"2016-08-02","2021-07-02"]
[3,"سلام طايع صادق زين الدين","رجل ",null,854026125,3736013,"13-09-2015","2020-12-09"]
[4,"زيد بشير اسماعيل اغبر ","رجل ",null,405320862,4509163,"2018-05-08","2023-04-08"]
[5,"عبد النبي طايع صادق زين الدين","رجل ",null,941462061,4630704,"2018-09-09","2023-08-09"]
[6,"جميلة محمد عفيف عارف اغبر ","إمرأة",null,942520677,4506098,"22-07-2018","21-07-2023"]
[7,"صبحية عيسى حمدان الكوازبه ","إمرأة",null,994244036,4576077,"2018-10-09","2023-09-09"]
[8,"مجدولين احمد حسن كوازبه","إمرأة",null,852464353,4576417,"2018-12-09","2023-11-09"]
[9,"عرفات محمد يوسف كوازبه ","رجل ",null,941128522,4576418,"2018-12-09","2023-11-09"]
[10,"محمد يوسف ابراهيم كوازبه ","رجل ",null,984420265,3993202,"2016-04-10","2021-03-10"]
[11,"ناديه سعدي حسين كوازبه","إمرأة",null,852497502,4083850,"2016-01-11","31-10-2021"]
[12,"نائل سعدي حسين الكوازبه","رجل ",null,904635067,3516526,"15-12-2014","14-12-2019"]
[13,"مياده نائل سعدي الكوازبه ","إمرأة",null,405063769,4576419,"2018-12-09","2023-11-09"]
[14,"حنين جمال جميل حمايل ","إمرأة",null,859014987,4628290,"27-08-2018","26-08-2023"]
[15,"عزيز سعدي حسين الكوازبه ","رجل ",null,907239545,4253185,"2017-04-07","2022-03-07"]
[16,"وجدان سعدي حسين الكوازبه","إمرأة",null,403453384,4576075,"2018-10-09","2023-09-09"]
[17,"ثابت مصطفى احمد حمايل ","رجل ",null,850029349,4628291,"27-08-2018","26-08-2023"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]

{"sheet":"R102","index":3,"n_rows":79,"n_cols":12,"rows_kept":79,"cut":false,"hidden":false,"merged":[[56,7,56,8],[5,2,6,3],[67,8,67,9],[68,8,68,9],[69,8,69,9],[58,7,58,8],[59,1,59,9],[60,1,61,1],[60,2,60,3],[61,2,61,3],[5,5,5,6],[6,5,6,6],[8,5,8,6],[10,5,10,6],[8,8,8,9],[63,8,63,9],[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[67,1,70,1],[67,2,67,3],[63,1,65,1],[65,2,65,3],[65,6,65,7],[63,2,63,3],[63,6,63,7],[64,2,64,3],[64,6,64,7],[64,8,64,9],[65,8,65,9],[53,3,54,4],[72,1,76,1],[73,6,73,7],[69,2,69,3],[69,6,69,7],[70,2,70,3],[74,8,74,9],[75,6,75,7],[73,2,73,3],[74,2,74,3],[67,6,67,7],[72,2,72,3],[68,2,68,3],[68,6,68,7],[70,8,70,9],[70,6,70,7],[72,6,72,7],[72,8,72,9],[73,8,73,9],[74,6,74,7],[78,2,78,3],[78,6,78,7],[78,8,78,9],[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],[75,2,75,3]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":1}]
[]
["رقم الرحلة","R102",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":"حافلات  VIP"},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":"ديار طابا "}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":"14-11-2018"},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":"احمد ابو بكر "},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[1,"حسني عطا حسن معلا","رجل ",null,987480464,"4041978","2017-01-08","2022-01-07","","طيران",2000,3000]
[2,"مصطفى احمد خريوش حمايل","رجل ",null,965975238,"3217654","2015-03-09","2020-03-08",""]
[3,"هناء احمد خريوش دويكات","رجل ",null,997481171,"4634296","2018-10-02","2023-10-01","15-عصبة النساء"]
[4,"امين فايز محمد نصار","رجل ",null,939770806,"N629918","2015-11-22","2020-11-21",""]
[5,"فطوم عوض احمد عديلي","نساء",null,945653558,"3823711","2015-12-16","2020-12-15","15-عصبة النساء"]
[6,"ختام احمد خريوش معلا","نساء",null,997481155,"3730666","2015-08-09","2020-08-08","15-عصبة النساء"]
[7,"نوال عبد حمدان حمايل","نساء",null,946960283,"4166804","2017-08-07","2022-08-06","15-عصبة النساء"]
[8,"عدي فايز لطفي دويكات","رجل ",null,853898518,"4635814","2018-10-14","2023-10-13",""]
[9,"وليد ابراهيم نجم ضميدي","رجل ",null,939570487,"4634030","2018-09-26","2023-09-25",""]
[10,"عزيزه محمود موسى حمايل","نساء",null,965970239,"4635026","2018-10-08","2023-10-07","15-عصبة النساء"]
[11,"فايز محمد موسى حمايل","رجل ",null,900075300,"4635064","2018-10-08","2023-10-07",""]
[12,"ريا داود احميدان حمايل","نساء",null,946961125,"4601477","2018-10-14","2023-10-13","15-عصبة النساء"]
[13,"ميسر سعود سليمان دويكات","نساء",null,942781931,"3750684","2015-10-18","2020-10-17","15-عصبة النساء"]
[14,"عفاف هلال حمدان سلمان","نساء",null,987466067,"O799868","2018-02-27","2023-02-26","15-عصبة النساء"]
[15,"كوثر محمود محمد ضميدي","نساء",null,901214478,"4422397","2018-04-22","2023-04-21","15-عصبة النساء"]
[16,"ماجد فايز محمد حمايل","رجل ",null,907239214,"3200254","2015-04-23","2020-04-22",""]
[17,"الهام فايز محمد حمايل","نساء",null,904266236,"4633566","2018-09-24","2023-09-23","ماجد/ اخ"]
[18,"صالح محمد صالح بني مفلح","رجل ",null,965975691,"3947655","2016-07-19","2021-07-18",""]
[19,"ناهده عبدالرؤوف احمد بني مفلح","نساء",null,904269396,"4634231","2018-09-30","2023-09-29"," صالح/ زوج"]
[20,"محمد صبحي سليم دويكات","رجل ",null,853688174,"3750685","2015-10-18","2020-10-17",""]
[21,"منال صبحي سليم دويكات","نساء",null,412199895,"4634826","2018-10-07","2023-10-06","محمد / اخ"]
[22,"ياسر عبدالكريم غصاب حمايل","رجل ",null,907160485,"4629202","2018-08-30","2023-08-29",""]
[23,"رجاء نافز فوزي حمايل","نساء",null,853448843,"4633556","2018-09-24","2023-09-23"," ياسر /  زوج"]
[24,"معتز عثمان عزات قواريق","رجل ",null,404686735,"4634584","2018-10-04","2023-10-03",""]
[25,"ايناس محمود عوض عواد","نساء",null,403386030,"4635238","2018-10-09","2023-10-08"," معتز/ زوج"]
[26,"سونا احمد اسعد قواريق","نساء",null,907907539,"4634585","2018-10-04","2023-10-03","معتز/ ابن"]
[27,"تيم عثمان عزات قواريق","طفل ",null,438691727,"4634597","2018-10-04","2023-10-03","معتز / اخ"]
[28,"وئام عثمان عزات قواريق","طفل ",null,429360290,"4634818","2018-10-07","2023-10-06","معتز/ اخ"]
[29,"احمد محمد حسن ابو بكر ","رجل ",null,992396960,3728949,"30-07-2015","29-07-2020"]
[30]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C25)","v":13},{"$f":"COUNTIF(C15:C44,C27)","v":14},{"$f":"COUNTIF(C15:C44,C41)","v":2},{"$f":"A47+B47+C47","v":29}]
[]
[]
[]
[]
[]
[]
[null,null,null,"كشف تسكين المعتمرين للرحلة",null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"F7","v":1}]
[]
[null,"رقم الرحلة",{"$f":"B9","v":"R102"},null,"نوع الرحلة",{"$f":"F9","v":"حافلات  VIP"},null,"فندق المدينة ",null,{"$f":"K9","v":"ديار طابا "}]
[]
[null,"تاريخ الرحلة",{"$f":"B11","v":"14-11-2018"},null,"اسم المرشد",{"$f":"F11","v":"احمد ابو بكر "},null,"فندق مكة ",null,{"$f":"K11","v":0}]
[]
[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,"تأشيرة + مقعد ","وئام قواريق"]

{"sheet":"R103","index":4,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[14,0,14,9],[8,10,8,11],[10,8,10,9],[10,10,10,11],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[8,8,8,9],[5,2,6,3]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":1}]
[]
["رقم الرحلة","R103",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":"حافلات VIP"},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":"12-05-2018"},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":"ارود ابو النور"},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF($C$17:$C$100,\"رجل\")","v":1},{"$f":"COUNTIF($C$17:$C$100,\"نساء\")","v":0},{"$f":"COUNTIF($C$17:$C$100,\"طفل\")","v":0},{"$f":"A14+B14+C14","v":1}]
["الاجمالي",null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,$K$17:$K$997)","v":0},{"$f":"SUBTOTAL(9,$L$17:$L$997)","v":0}]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[1,"أحمد يوسف",1,"رجل","مصرى",1002,"4810-12-29","2018-01-10"]
[2,"سعيد رضوان","رجل"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(B45=\"\",\"\",SUBTOTAL(3,$B$17:B45))","v":""}]

{"sheet":"R104","index":5,"n_rows":17,"n_cols":12,"rows_kept":17,"cut":false,"hidden":false,"merged":[[5,2,6,3],[14,0,14,9],[8,10,8,11],[10,8,10,9],[10,10,10,11],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":1}]
[]
["رقم الرحلة","R104",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF($C$17:$C$100,\"رجل\")","v":0},{"$f":"COUNTIF($C$17:$C$100,\"نساء\")","v":0},{"$f":"COUNTIF($C$17:$C$100,\"طفل\")","v":0},{"$f":"A14+B14+C14","v":0}]
["الاجمالي",null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,$K$17:$K$997)","v":0},{"$f":"SUBTOTAL(9,$L$17:$L$997)","v":0}]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[{"$f":"IF(B17=\"\",\"\",SUBTOTAL(3,$B$17:B17))","v":1},"أحمد يوسف",1,"رجل","مصرى",1001,"4810-12-31","2018-01-10"]

{"sheet":"R105","index":6,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[8,8,8,9],[5,2,6,3]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":1}]
[]
["رقم الرحلة","R105",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R106","index":7,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":1}]
[]
["رقم الرحلة","R106",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R107","index":8,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":1}]
[]
["رقم الرحلة","R107",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R108","index":9,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R108",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R109","index":10,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R109",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R110","index":11,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R110",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R111","index":12,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":1}]
[]
["رقم الرحلة","R111",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R112","index":13,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R112",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R113","index":14,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R113",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R114","index":15,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R114",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R115","index":16,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R115",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R116","index":17,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R116",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R117","index":18,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R117",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R118","index":19,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R118",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R119","index":20,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R119",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R120","index":21,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R120",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R121","index":22,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R121",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R122","index":23,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R122",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R123","index":24,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R123",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R124","index":25,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R124",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R125","index":26,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R125",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R126","index":27,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R126",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R127","index":28,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R127",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R128","index":29,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R128",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R129","index":30,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R129",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R130","index":31,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R130",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R131","index":32,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R131",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R132","index":33,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R132",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R133","index":34,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R133",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R134","index":35,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R134",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R135","index":36,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R135",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R136","index":37,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R136",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R137","index":38,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R137",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":"طيران "},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R138","index":39,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R138",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R139","index":40,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R139",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R140","index":41,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R140",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R141","index":42,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":2}]
[]
["رقم الرحلة","R141",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":"حافلات سياحية "},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":"ديار طابا "}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":"01-06-2018"},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":"سعيد"},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":"دار الايمان اجياد"}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R142","index":43,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R142",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R143","index":44,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R143",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R144","index":45,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R144",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R145","index":46,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R145",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R146","index":47,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R146",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R147","index":48,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R147",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R148","index":49,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R148",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R149","index":50,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":""}]
[]
["رقم الرحلة","R149",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":0},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":0}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":""},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":0},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":0}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]

{"sheet":"R150","index":51,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,10,8,11],[10,8,10,9],[10,10,10,11],[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,2,6,3],[8,8,8,9]]}
[]
[]
[]
["القائمة الرئيسية","العودة لقائمة  أسماء المعتمرين الرئيسية"]
[]
[null,null,"قائمة أسماء المعتمرين للرحلة",null,null,"رقم الحافلة"]
[null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,2,0)),\"\")","v":2}]
[]
["رقم الرحلة","R150",null,"نوع الرحلة",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,3,0),\"\")","v":"حافلات سياحية "},null,null,"فندق المدينة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,6,0),\"\")","v":"ديار طابا "}]
[]
["تاريخ الرحلة",{"$f":"IFERROR(IF(VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)=\"\",\"\",VLOOKUP($B$9,البيانات!$A$2:$G$1000,4,0)),\"\")","v":"01-10-2019"},null,"اسم المرشد",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,5,0),\"\")","v":"سعد "},null,null,"فندق مكة ",null,{"$f":"IFERROR(VLOOKUP($B$9,البيانات!$A$2:$G$1000,7,0),\"\")","v":"دار الايمان اجياد"}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[]
[]
[null,null,null,null,null,null,"2018-02-10"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["الاجمالي",null,null,null,null,null,null,null,null,null,2000,3000]
["عدد الرجال ","عدد النساء ","عدد الاطفال ","الاجمالي "]
[{"$f":"COUNTIF(C15:C44,C15)","v":0},{"$f":"COUNTIF(C15:C44,C16)","v":0},{"$f":"COUNTIF(C15:C44,C17)","v":0},{"$f":"SUM(A47:C47)","v":0}]