{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["البيانات","الشيت الرئيسي","رحلة R100","رحلة R101","رحلة R102","رحلة R103","رحلة R104","ورقة1","ورقة2","ورقة3","ورقة4"],"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":13,"rows_kept":45,"cut":false,"hidden":false,"merged":[[10,6,10,7],[44,1,44,3],[5,6,5,7],[6,6,6,7],[8,6,8,7],[9,6,9,7]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"كود العميل"]
[null,null,null,"حساب الرحلة ",null,null,{"$f":"IFERROR(INDEX(البيانات!$A$2:$A$320,MATCH($C$9,البيانات!$B$2:$B$320,0)),\"\")","v":1}]
[]
[null,"اسم العميل","R102",null,"تليفون",null,{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$C$6,3,0),\"\")","v":"طيران "}]
[null,"اسم المنشاة",null,null,"مدير مسئول"]
[null,"العنوان",{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$D$6,4,0),\"\")","v":"25-9-2018"},null,"مندوب مبيعات ",null,{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$E$6,5,0),\"\")","v":"محمود"}]
[]
[]
[null,"الرقم ","اسم المعتمر ","الجنس ","الجنسية ","رقم الهوية ","رقم جواز السفر ","تاريخ الاصدار ","تاريخ الانتهاء ","اسم المحرم ","نوع الخدمة ","سعر الشراء ","سعر البيع "]
[null,1,"محمد ","رجل "]
[null,2]
[null,3,null,null,null,null,null,0]
[null,4,null,null,null,null,null,0]
[null,5,null,null,null,null,null,0]
[null,6,null,null,null,null,null,0]
[null,7,null,null,null,null,null,0]
[null,8,null,null,null,null,null,0]
[null,9,null,null,null,null,null,0]
[null,10,null,null,null,null,null,0]
[null,11,null,null,null,null,null,0]
[null,12,null,null,null,null,null,0]
[null,13,null,null,null,null,null,0]
[null,14,null,null,null,null,null,0]
[null,15,null,null,null,null,null,0]
[null,16,null,null,null,null,null,0]
[null,17,null,null,null,null,null,0]
[null,18,null,null,null,null,null,0]
[null,19,null,null,null,null,null,0]
[null,20,null,null,null,null,null,0]
[null,21,null,null,null,null,null,0]
[null,22,null,null,null,null,null,0]
[null,23,null,null,null,null,null,0]
[null,24,null,null,null,null,null,0]
[null,25,null,null,null,null,null,0]
[null,26,null,null,null,null,null,0]
[null,27,null,null,null,null,null,0]
[null,28,null,null,null,null,null,0]
[null,29,null,null,null,null,null,0]
[null,30,null,null,null,null,null,0]
[null,"الاجمالي",null,null,5000,null,3500]

{"sheet":"رحلة R100","index":2,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,1,44,3],[5,6,5,7],[6,6,6,7],[8,6,8,7],[9,6,9,7],[10,6,10,7]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"كود العميل"]
[null,null,null,"حساب عميل",null,null,1]
[]
[null,"اسم العميل",{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$B$6,2,0),\"\")","v":"R100"},null,"تليفون",null,{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$C$6,3,0),\"\")","v":"طيران "}]
[null,"اسم المنشاة",null,null,"مدير مسئول"]
[null,"العنوان",{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$D$6,4,0),\"\")","v":"25-9-2018"},null,"مندوب مبيعات ",null,{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$E$6,5,0),\"\")","v":"محمود"}]
[]
[]
[null,"الرقم ","الاسم ","ال","قيمة الفاتورة","رصيد سابق","المدفوع","رصيد متبقي","ملاحظات"]
[null,1,"2018-01-01",150,5000,100,3500,{"$f":"E15+F15-G15","v":1600}]
[null,2,null,null,null,null,null,{"$f":"E16+F16-G16","v":0}]
[null,3,null,null,null,null,null,0]
[null,4,null,null,null,null,null,0]
[null,5,null,null,null,null,null,0]
[null,6,null,null,null,null,null,0]
[null,7,null,null,null,null,null,0]
[null,8,null,null,null,null,null,0]
[null,9,null,null,null,null,null,0]
[null,10,null,null,null,null,null,0]
[null,11,null,null,null,null,null,0]
[null,12,null,null,null,null,null,0]
[null,13,null,null,null,null,null,0]
[null,14,null,null,null,null,null,0]
[null,15,null,null,null,null,null,0]
[null,16,null,null,null,null,null,0]
[null,17,null,null,null,null,null,0]
[null,18,null,null,null,null,null,0]
[null,19,null,null,null,null,null,0]
[null,20,null,null,null,null,null,0]
[null,21,null,null,null,null,null,0]
[null,22,null,null,null,null,null,0]
[null,23,null,null,null,null,null,0]
[null,24,null,null,null,null,null,0]
[null,25,null,null,null,null,null,0]
[null,26,null,null,null,null,null,0]
[null,27,null,null,null,null,null,0]
[null,28,null,null,null,null,null,0]
[null,29,null,null,null,null,null,0]
[null,30,null,null,null,null,null,0]
[null,"الاجمالي",null,null,{"$f":"SUM(E15:E44)","v":5000},null,{"$f":"SUM(G15:G44)","v":3500}]

{"sheet":"رحلة R101","index":3,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,1,44,3],[5,6,5,7],[6,6,6,7],[8,6,8,7],[9,6,9,7],[10,6,10,7]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"كود العميل"]
[null,null,null,"حساب عميل",null,null,2]
[]
[null,"اسم العميل",{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$B$6,2,0),\"\")","v":"R103"},null,"تليفون",null,{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$C$6,3,0),\"\")","v":"طيران "}]
[null,"اسم المنشاة",null,null,"مدير مسئول"]
[null,"العنوان",{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$D$6,4,0),\"\")","v":"00:00:00"},null,"مندوب مبيعات ",null,{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$E$6,5,0),\"\")","v":"حذيفه"}]
[]
[]
[null,"م","التاريخ","رقم الفاتورة","قيمة الفاتورة","رصيد سابق","المدفوع","رصيد متبقي","ملاحظات"]
[null,1,"00:00:00","JJHHH",500,10,20,{"$f":"E15+F15-G15","v":490}]
[null,2,null,null,null,null,null,{"$f":"E16+F16-G16","v":0}]
[null,3,null,null,null,null,null,0]
[null,4,null,null,null,null,null,0]
[null,5,null,null,null,null,null,0]
[null,6,null,null,null,null,null,0]
[null,7,null,null,null,null,null,0]
[null,8,null,null,null,null,null,0]
[null,9,null,null,null,null,null,0]
[null,10,null,null,null,null,null,0]
[null,11,null,null,null,null,null,0]
[null,12,null,null,null,null,null,0]
[null,13,null,null,null,null,null,0]
[null,14,null,null,null,null,null,0]
[null,15,null,null,null,null,null,0]
[null,16,null,null,null,null,null,0]
[null,17,null,null,null,null,null,0]
[null,18,null,null,null,null,null,0]
[null,19,null,null,null,null,null,0]
[null,20,null,null,null,null,null,0]
[null,21,null,null,null,null,null,0]
[null,22,null,null,null,null,null,0]
[null,23,null,null,null,null,null,0]
[null,24,null,null,null,null,null,0]
[null,25,null,null,null,null,null,0]
[null,26,null,null,null,null,null,0]
[null,27,null,null,null,null,null,0]
[null,28,null,null,null,null,null,0]
[null,29,null,null,null,null,null,0]
[null,30,null,null,null,null,null,0]
[null,"الاجمالي",null,null,{"$f":"SUM(E15:E44)","v":500},null,{"$f":"SUM(G15:G44)","v":20}]

{"sheet":"رحلة R102","index":4,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,1,44,3],[5,6,5,7],[6,6,6,7],[8,6,8,7],[9,6,9,7],[10,6,10,7]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"كود العميل"]
[null,null,null,"حساب عميل",null,null,3]
[]
[null,"اسم العميل",{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$B$6,2,0),\"\")","v":""},null,"تليفون",null,{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$C$6,3,0),\"\")","v":""}]
[null,"اسم المنشاة",null,null,"مدير مسئول"]
[null,"العنوان",{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$D$6,4,0),\"\")","v":""},null,"مندوب مبيعات ",null,{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$E$6,5,0),\"\")","v":""}]
[]
[]
[null,"م","التاريخ","رقم الفاتورة","قيمة الفاتورة","رصيد سابق","المدفوع","رصيد متبقي","ملاحظات"]
[null,1,null,null,null,null,null,{"$f":"E15+F15-G15","v":0}]
[null,2,null,null,null,null,null,{"$f":"E16+F16-G16","v":0}]
[null,3,null,null,null,null,null,0]
[null,4,null,null,null,null,null,0]
[null,5,null,null,null,null,null,0]
[null,6,null,null,null,null,null,0]
[null,7,null,null,null,null,null,0]
[null,8,null,null,null,null,null,0]
[null,9,null,null,null,null,null,0]
[null,10,null,null,null,null,null,0]
[null,11,null,null,null,null,null,0]
[null,12,null,null,null,null,null,0]
[null,13,null,null,null,null,null,0]
[null,14,null,null,null,null,null,0]
[null,15,null,null,null,null,null,0]
[null,16,null,null,null,null,null,0]
[null,17,null,null,null,null,null,0]
[null,18,null,null,null,null,null,0]
[null,19,null,null,null,null,null,0]
[null,20,null,null,null,null,null,0]
[null,21,null,null,null,null,null,0]
[null,22,null,null,null,null,null,0]
[null,23,null,null,null,null,null,0]
[null,24,null,null,null,null,null,0]
[null,25,null,null,null,null,null,0]
[null,26,null,null,null,null,null,0]
[null,27,null,null,null,null,null,0]
[null,28,null,null,null,null,null,0]
[null,29,null,null,null,null,null,0]
[null,30,null,null,null,null,null,0]
[null,"الاجمالي",null,null,{"$f":"SUM(E15:E44)","v":0},null,{"$f":"SUM(G15:G44)","v":0}]

{"sheet":"رحلة R103","index":5,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,1,44,3],[5,6,5,7],[6,6,6,7],[8,6,8,7],[9,6,9,7],[10,6,10,7]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"كود العميل"]
[null,null,null,"حساب عميل",null,null,4]
[]
[null,"اسم العميل",{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$B$6,2,0),\"\")","v":""},null,"تليفون",null,{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$C$6,3,0),\"\")","v":""}]
[null,"اسم المنشاة",null,null,"مدير مسئول"]
[null,"العنوان",{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$D$6,4,0),\"\")","v":""},null,"مندوب مبيعات ",null,{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$E$6,5,0),\"\")","v":""}]
[]
[]
[null,"م","التاريخ","رقم الفاتورة","قيمة الفاتورة","رصيد سابق","المدفوع","رصيد متبقي","ملاحظات"]
[null,1,null,null,null,null,null,{"$f":"E15+F15-G15","v":0}]
[null,2,null,null,null,null,null,{"$f":"E16+F16-G16","v":0}]
[null,3,null,null,null,null,null,0]
[null,4,null,null,null,null,null,0]
[null,5,null,null,null,null,null,0]
[null,6,null,null,null,null,null,0]
[null,7,null,null,null,null,null,0]
[null,8,null,null,null,null,null,0]
[null,9,null,null,null,null,null,0]
[null,10,null,null,null,null,null,0]
[null,11,null,null,null,null,null,0]
[null,12,null,null,null,null,null,0]
[null,13,null,null,null,null,null,0]
[null,14,null,null,null,null,null,0]
[null,15,null,null,null,null,null,0]
[null,16,null,null,null,null,null,0]
[null,17,null,null,null,null,null,0]
[null,18,null,null,null,null,null,0]
[null,19,null,null,null,null,null,0]
[null,20,null,null,null,null,null,0]
[null,21,null,null,null,null,null,0]
[null,22,null,null,null,null,null,0]
[null,23,null,null,null,null,null,0]
[null,24,null,null,null,null,null,0]
[null,25,null,null,null,null,null,0]
[null,26,null,null,null,null,null,0]
[null,27,null,null,null,null,null,0]
[null,28,null,null,null,null,null,0]
[null,29,null,null,null,null,null,0]
[null,30,null,null,null,null,null,0]
[null,"الاجمالي",null,null,{"$f":"SUM(E15:E44)","v":0},null,{"$f":"SUM(G15:G44)","v":0}]

{"sheet":"رحلة R104","index":6,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,1,44,3],[5,6,5,7],[6,6,6,7],[8,6,8,7],[9,6,9,7],[10,6,10,7]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"كود العميل"]
[null,null,null,"حساب عميل",null,null,5]
[]
[null,"اسم العميل",{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$B$6,2,0),\"\")","v":"R104"},null,"تليفون",null,{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$C$6,3,0),\"\")","v":0}]
[null,"اسم المنشاة",null,null,"مدير مسئول"]
[null,"العنوان",{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$D$6,4,0),\"\")","v":"00:00:00"},null,"مندوب مبيعات ",null,{"$f":"IFERROR(VLOOKUP(G7,البيانات!$A$1:$E$6,5,0),\"\")","v":"علي"}]
[]
[]
[null,"م","التاريخ","رقم الفاتورة","قيمة الفاتورة","رصيد سابق","المدفوع","رصيد متبقي","ملاحظات"]
[null,1,"2018-06-01",120,570,201,230,{"$f":"E15+F15-G15","v":541}]
[null,2,null,null,null,null,null,{"$f":"E16+F16-G16","v":0}]
[null,3,null,null,null,null,null,0]
[null,4,null,null,null,null,null,0]
[null,5,null,null,null,null,null,0]
[null,6,null,null,null,null,null,0]
[null,7,null,null,null,null,null,0]
[null,8,null,null,null,null,null,0]
[null,9,null,null,null,null,null,0]
[null,10,null,null,null,null,null,0]
[null,11,null,null,null,null,null,0]
[null,12,null,null,null,null,null,0]
[null,13,null,null,null,null,null,0]
[null,14,null,null,null,null,null,0]
[null,15,null,null,null,null,null,0]
[null,16,null,null,null,null,null,0]
[null,17,null,null,null,null,null,0]
[null,18,null,null,null,null,null,0]
[null,19,null,null,null,null,null,0]
[null,20,null,null,null,null,null,0]
[null,21,null,null,null,null,null,0]
[null,22,null,null,null,null,null,0]
[null,23,null,null,null,null,null,0]
[null,24,null,null,null,null,null,0]
[null,25,null,null,null,null,null,0]
[null,26,null,null,null,null,null,0]
[null,27,null,null,null,null,null,0]
[null,28,null,null,null,null,null,0]
[null,29,null,null,null,null,null,0]
[null,30,null,null,null,null,null,0]
[null,"الاجمالي",null,null,{"$f":"SUM(E15:E44)","v":570},null,{"$f":"SUM(G15:G44)","v":230}]

{"sheet":"ورقة1","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"ورقة2","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"ورقة3","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"ورقة4","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}