{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["البيانات","الشيت الرئيسي","R100","R101","R102","R103","R104","R105","R106","R107","R108"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"البيانات","index":0,"n_rows":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["رقم الحافلة ","رقم الرحلة ","نوع الرحلة ","تاريخ الرحلة ","اسم المرشد ","فندق المدينة المنورة ","فندق مكة المكرمة "]
[1,"R100","طيران ","25-9-2018","محمود"]
[1,"R101","حافلات VIP",null,"حذيفه"]
[1,"R102","حافلات سياحية ",null,"علي"]
[2,"R103","طيران ",null,"حذيفه"]
[5,"R104",null,null,"علي"]
[null,"R105"]
[null,"R106"]
[null,"R107"]
[null,"R108"]
[null,"R109"]
[null,"R110"]
[null,"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"]
[null,"R141"]
[null,"R142"]
[null,"R143"]
[null,"R144"]
[null,"R145"]
[null,"R146"]
[null,"R147"]
[null,"R148"]
[null,"R149"]
[null,"R150"]

{"sheet":"الشيت الرئيسي","index":1,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,0,44,9],[10,5,10,6],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,"كود العميل"]
[null,null,"حساب الرحلة ",null,null,{"$f":"IFERROR(INDEX(البيانات!$A$2:$A$320,MATCH($B$9,البيانات!$B$2:$B$320,0)),\"\")","v":0}]
[]
["اسم العميل","R108",null,"تليفون",null,{"$f":"IFERROR(VLOOKUP(F7,البيانات!$A$1:$C$6,3,0),\"\")","v":""}]
["اسم المنشاة",null,null,"مدير مسئول"]
["العنوان",{"$f":"IFERROR(VLOOKUP(F7,البيانات!$A$1:$D$6,4,0),\"\")","v":""},null,"مندوب مبيعات ",null,{"$f":"IFERROR(VLOOKUP(F7,البيانات!$A$1:$E$6,5,0),\"\")","v":""}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[1,"محمد ","رجل ","مصرى",2135206,1236555211,"2018-01-01","2019-12-10","ننن","طيران",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,2000,3000]

{"sheet":"R100","index":2,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,"كود العميل"]
[null,null,"حساب الرحلة ",null,null,{"$f":"IFERROR(INDEX(البيانات!$A$2:$A$320,MATCH($B$9,البيانات!$B$2:$B$320,0)),\"\")","v":1}]
[]
["اسم العميل","R100",null,"تليفون",null,{"$f":"IFERROR(VLOOKUP(F7,البيانات!$A$1:$C$6,3,0),\"\")","v":"طيران "}]
["اسم المنشاة",null,null,"مدير مسئول"]
["العنوان",{"$f":"IFERROR(VLOOKUP(F7,البيانات!$A$1:$D$6,4,0),\"\")","v":"25-9-2018"},null,"مندوب مبيعات ",null,{"$f":"IFERROR(VLOOKUP(F7,البيانات!$A$1:$E$6,5,0),\"\")","v":"محمود"}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[1,"محمد ","رجل ","مصرى",2135206,1236555211,"2018-01-01","2019-12-10","ننن","طيران",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,{"$f":"SUM(K15:K44)","v":2000},{"$f":"SUM(L15:L44)","v":3000}]

{"sheet":"R101","index":3,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,"كود العميل"]
[null,null,"حساب الرحلة ",null,null,{"$f":"IFERROR(INDEX(البيانات!$A$2:$A$320,MATCH($B$9,البيانات!$B$2:$B$320,0)),\"\")","v":1}]
[]
["اسم العميل","R101",null,"تليفون",null,{"$f":"IFERROR(VLOOKUP(F7,البيانات!$A$1:$C$6,3,0),\"\")","v":"طيران "}]
["اسم المنشاة",null,null,"مدير مسئول"]
["العنوان",{"$f":"IFERROR(VLOOKUP(F7,البيانات!$A$1:$D$6,4,0),\"\")","v":"25-9-2018"},null,"مندوب مبيعات ",null,{"$f":"IFERROR(VLOOKUP(F7,البيانات!$A$1:$E$6,5,0),\"\")","v":"محمود"}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[1,"محمد ","رجل ","مصرى",2135206,1236555211,"2018-01-01","2019-12-10","ننن","طيران",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,{"$f":"SUM(K15:K44)","v":2000},{"$f":"SUM(L15:L44)","v":3000}]

{"sheet":"R102","index":4,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,"كود العميل"]
[null,null,"حساب الرحلة ",null,null,{"$f":"IFERROR(INDEX(البيانات!$A$2:$A$320,MATCH($B$9,البيانات!$B$2:$B$320,0)),\"\")","v":1}]
[]
["اسم العميل","R102",null,"تليفون",null,{"$f":"IFERROR(VLOOKUP(F7,البيانات!$A$1:$C$6,3,0),\"\")","v":"طيران "}]
["اسم المنشاة",null,null,"مدير مسئول"]
["العنوان",{"$f":"IFERROR(VLOOKUP(F7,البيانات!$A$1:$D$6,4,0),\"\")","v":"25-9-2018"},null,"مندوب مبيعات ",null,{"$f":"IFERROR(VLOOKUP(F7,البيانات!$A$1:$E$6,5,0),\"\")","v":"محمود"}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[1,"محمد ","رجل ","مصرى",2135206,1236555211,"2018-01-01","2019-12-10","ننن","طيران",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,{"$f":"SUM(K15:K44)","v":2000},{"$f":"SUM(L15:L44)","v":3000}]

{"sheet":"R103","index":5,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,"كود العميل"]
[null,null,"حساب الرحلة ",null,null,{"$f":"IFERROR(INDEX(البيانات!$A$2:$A$320,MATCH($B$9,البيانات!$B$2:$B$320,0)),\"\")","v":2}]
[]
["اسم العميل","R103",null,"تليفون",null,{"$f":"IFERROR(VLOOKUP(F7,البيانات!$A$1:$C$6,3,0),\"\")","v":"طيران "}]
["اسم المنشاة",null,null,"مدير مسئول"]
["العنوان",{"$f":"IFERROR(VLOOKUP(F7,البيانات!$A$1:$D$6,4,0),\"\")","v":"00:00:00"},null,"مندوب مبيعات ",null,{"$f":"IFERROR(VLOOKUP(F7,البيانات!$A$1:$E$6,5,0),\"\")","v":"حذيفه"}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[1,"محمد ","رجل ","مصرى",2135206,1236555211,"2018-01-01","2019-12-10","ننن","طيران",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,{"$f":"SUM(K15:K44)","v":2000},{"$f":"SUM(L15:L44)","v":3000}]

{"sheet":"R104","index":6,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,"كود العميل"]
[null,null,"حساب الرحلة ",null,null,{"$f":"IFERROR(INDEX(البيانات!$A$2:$A$320,MATCH($B$9,البيانات!$B$2:$B$320,0)),\"\")","v":5}]
[]
["اسم العميل","R104",null,"تليفون",null,{"$f":"IFERROR(VLOOKUP(F7,البيانات!$A$1:$C$6,3,0),\"\")","v":0}]
["اسم المنشاة",null,null,"مدير مسئول"]
["العنوان",{"$f":"IFERROR(VLOOKUP(F7,البيانات!$A$1:$D$6,4,0),\"\")","v":"00:00:00"},null,"مندوب مبيعات ",null,{"$f":"IFERROR(VLOOKUP(F7,البيانات!$A$1:$E$6,5,0),\"\")","v":"علي"}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[1,"محمد ","رجل ","مصرى",2135206,1236555211,"2018-01-01","2019-12-10","ننن","طيران",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,{"$f":"SUM(K15:K44)","v":2000},{"$f":"SUM(L15:L44)","v":3000}]

{"sheet":"R105","index":7,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,"كود العميل"]
[null,null,"حساب الرحلة ",null,null,{"$f":"IFERROR(INDEX(البيانات!$A$2:$A$320,MATCH($B$9,البيانات!$B$2:$B$320,0)),\"\")","v":0}]
[]
["اسم العميل","R105",null,"تليفون",null,{"$f":"IFERROR(VLOOKUP(F7,البيانات!$A$1:$C$6,3,0),\"\")","v":""}]
["اسم المنشاة",null,null,"مدير مسئول"]
["العنوان",{"$f":"IFERROR(VLOOKUP(F7,البيانات!$A$1:$D$6,4,0),\"\")","v":""},null,"مندوب مبيعات ",null,{"$f":"IFERROR(VLOOKUP(F7,البيانات!$A$1:$E$6,5,0),\"\")","v":""}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[1,"محمد ","رجل ","مصرى",2135206,1236555211,"2018-01-01","2019-12-10","ننن","طيران",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,{"$f":"SUM(K15:K44)","v":2000},{"$f":"SUM(L15:L44)","v":3000}]

{"sheet":"R106","index":8,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,"كود العميل"]
[null,null,"حساب الرحلة ",null,null,{"$f":"IFERROR(INDEX(البيانات!$A$2:$A$320,MATCH($B$9,البيانات!$B$2:$B$320,0)),\"\")","v":0}]
[]
["اسم العميل","R106",null,"تليفون",null,{"$f":"IFERROR(VLOOKUP(F7,البيانات!$A$1:$C$6,3,0),\"\")","v":""}]
["اسم المنشاة",null,null,"مدير مسئول"]
["العنوان",{"$f":"IFERROR(VLOOKUP(F7,البيانات!$A$1:$D$6,4,0),\"\")","v":""},null,"مندوب مبيعات ",null,{"$f":"IFERROR(VLOOKUP(F7,البيانات!$A$1:$E$6,5,0),\"\")","v":""}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[1,"محمد ","رجل ","مصرى",2135206,1236555211,"2018-01-01","2019-12-10","ننن","طيران",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,{"$f":"SUM(K15:K44)","v":2000},{"$f":"SUM(L15:L44)","v":3000}]

{"sheet":"R107","index":9,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,"كود العميل"]
[null,null,"حساب الرحلة ",null,null,{"$f":"IFERROR(INDEX(البيانات!$A$2:$A$320,MATCH($B$9,البيانات!$B$2:$B$320,0)),\"\")","v":0}]
[]
["اسم العميل","R107",null,"تليفون",null,{"$f":"IFERROR(VLOOKUP(F7,البيانات!$A$1:$C$6,3,0),\"\")","v":""}]
["اسم المنشاة",null,null,"مدير مسئول"]
["العنوان",{"$f":"IFERROR(VLOOKUP(F7,البيانات!$A$1:$D$6,4,0),\"\")","v":""},null,"مندوب مبيعات ",null,{"$f":"IFERROR(VLOOKUP(F7,البيانات!$A$1:$E$6,5,0),\"\")","v":""}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[1,"محمد ","رجل ","مصرى",2135206,1236555211,"2018-01-01","2019-12-10","ننن","طيران",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,{"$f":"SUM(K15:K44)","v":2000},{"$f":"SUM(L15:L44)","v":3000}]

{"sheet":"R108","index":10,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,0,44,9],[5,5,5,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[10,5,10,6]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,"كود العميل"]
[null,null,"حساب الرحلة ",null,null,{"$f":"IFERROR(INDEX(البيانات!$A$2:$A$320,MATCH($B$9,البيانات!$B$2:$B$320,0)),\"\")","v":0}]
[]
["اسم العميل","R108",null,"تليفون",null,{"$f":"IFERROR(VLOOKUP(F7,البيانات!$A$1:$C$6,3,0),\"\")","v":""}]
["اسم المنشاة",null,null,"مدير مسئول"]
["العنوان",{"$f":"IFERROR(VLOOKUP(F7,البيانات!$A$1:$D$6,4,0),\"\")","v":""},null,"مندوب مبيعات ",null,{"$f":"IFERROR(VLOOKUP(F7,البيانات!$A$1:$E$6,5,0),\"\")","v":""}]
[]
[]
["الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[1,"محمد ","رجل ","مصرى",2135206,1236555211,"2018-01-01","2019-12-10","ننن","طيران",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,{"$f":"SUM(K15:K44)","v":2000},{"$f":"SUM(L15:L44)","v":3000}]