{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Print"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":4,"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":"Sheet1","index":0,"n_rows":186,"n_cols":20,"rows_kept":186,"cut":false,"hidden":false,"merged":[[2,16,2,18],[2,2,3,2],[2,3,3,3],[2,19,3,19],[2,4,2,11],[2,12,2,15]]}
[]
[]
[null,null,"#","رقم السند","بيانات المسافرين",null,null,null,null,null,null,null,"بيانات الرحله",null,null,null,"بيانات الدفع",null,null,"الملاحظات "]
[null,null,null,null,"الاسم","رقم الجواز","محل الميلاد","تاريخ الميلاد","تاريخ الإصدار","تاريخ الانتهاء","رقم التلفون","جهة اصداره","تاريخ الدفع","الشركه الناقله","الى مدينة","تاريخ الرحله","المبلغ","المدفوع","الباقي"]
[null,null,null,1]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D6)","v":1},100116,"ali","ali","ali","ali","ali","ali","ali","ali","ali","ali","ali","ali","ali","ali","ali","ali"]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D7)","v":2},20000,"ali","ali","ali","ali","ali","ali","ali","ali","ali","ali","ali","ali","ali","ali","ali","ali"]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D8)","v":3},20001,"ali","ali","ali","ali","ali","ali","ali","ali","ali","ali","ali","ali","ali","ali","ali","ali"]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D9)","v":4},20002,"ali","ali","ali","ali","ali","ali","ali","ali","ali","ali","ali","ali","ali","ali","ali","ali"]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D10)","v":5},20003,"ali","ali","ali","ali","ali","ali","ali","ali","ali","ali","ali","ali","ali","ali","ali","ali"]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D11)","v":6},20004,"علي عاتي",123456789,"جدة ",2000,2020,2030,123456789,"جدة",44594,"السراج","الرياض ","2022-02-02",1000,300,700,"لا توجد ملاحظة "]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D12)","v":6},null,"علي عاتي",123456789,"جدة ",2000,2020,2030,123456789,"جدة",null,null,null,null,null,null,0,"لا توجد ملاحظة "]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D13)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D14)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D15)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D16)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D17)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D18)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D19)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D20)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D21)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D22)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D23)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D24)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D25)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D26)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D27)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D28)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D29)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D30)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D31)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D32)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D33)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D34)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D35)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D36)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D37)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D38)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D39)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D40)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D41)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D42)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D43)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D44)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D45)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D46)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D47)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D48)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D49)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D50)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D51)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D52)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D53)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D54)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D55)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D56)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D57)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D58)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D59)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D60)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D61)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D62)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D63)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D64)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D65)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D66)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D67)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D68)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D69)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D70)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D71)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D72)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D73)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D74)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D75)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D76)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D77)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D78)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D79)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D80)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D81)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D82)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D83)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D84)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D85)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D86)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D87)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D88)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D89)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D90)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D91)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D92)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D93)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D94)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D95)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D96)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D97)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D98)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D99)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D100)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D101)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D102)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D103)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D104)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D105)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D106)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D107)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D108)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D109)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D110)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D111)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D112)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D113)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D114)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D115)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D116)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D117)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D118)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D119)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D120)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D121)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D122)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D123)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D124)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D125)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D126)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D127)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D128)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D129)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D130)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D131)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D132)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D133)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D134)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D135)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D136)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D137)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D138)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D139)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D140)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D141)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D142)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D143)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D144)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D145)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D146)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D147)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D148)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D149)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D150)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D151)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D152)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D153)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D154)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D155)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D156)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D157)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D158)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D159)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D160)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D161)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D162)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D163)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D164)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D165)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D166)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D167)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D168)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D169)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D170)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D171)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D172)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D173)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D174)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D175)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D176)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D177)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D178)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D179)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D180)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D181)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D182)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D183)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D184)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D185)","v":6}]
[null,null,{"$f":"SUBTOTAL(3,$D$6:D186)","v":6}]

{"sheet":"Sheet2","index":1,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[4,3,4,4],[4,6,4,7]]}
[]
[]
[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,null,null,"المبلغ",200,null,"تاريخ الإصدار"]
[]
[null,null,null,"المدفوع ",100,null,"تاريخ الانتهاء"]
[]
[null,null,null,"الباقي ",{"$f":"E15-E17","v":100},null,"رقم التلفون"]
[]
[null,null,null,"الملاحظات ",null,null,"جهة الإصدار"]

{"sheet":"Print","index":2,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,2,15,4],[1,1,2,1],[1,2,2,2],[1,3,2,4],[4,1,4,2],[4,3,4,4],[13,2,13,4],[14,1,15,1],[3,1,3,4]]}
[]
[null,"رقم السند",20004]
[]
[null,"اسم الشركة "]
[null,"بيانات الرحلة ",null,"بيانات المسافر ",null,null,null,"الدمام","البركة"]
[null,"تاريخ الدفع",{"$f":"VLOOKUP($C$2,Sheet1!$D$5:$T$9999,10,0)","v":"2022-02-02"},"الاسم",{"$f":"VLOOKUP($C$2,Sheet1!$D$6:$T$9999,2,0)","v":"علي عاتي"},null,null,"الرياض ","السراج"]
[null,"الشركه الناقله",{"$f":"VLOOKUP($C$2,Sheet1!D5:T9999,11,0)","v":"السراج"},"رقم الجواز",{"$f":"VLOOKUP($C$2,Sheet1!$D$6:$T$9999,3,0)","v":123456789},null,null,"جده","ابو سرهد"]
[null,"الى مدينة",{"$f":"VLOOKUP($C$2,Sheet1!$D$6:$T$9999,12,0)","v":"الرياض "},"محل الميلاد",{"$f":"VLOOKUP($C$2,Sheet1!$D$6:$T$9999,4,0)","v":"جدة "},null,null,"مكة","البراق"]
[null,"تاريخ الرحله",{"$f":"VLOOKUP($C$2,Sheet1!$D$6:$T$9999,13,0)","v":"2022-02-02"},"تاريخ الميلاد",{"$f":"VLOOKUP($C$2,Sheet1!$D$6:$T$9999,5,0)","v":2000},null,null,"الطائف","الافضل"]
[null,"المبلغ",{"$f":"VLOOKUP($C$2,Sheet1!$D$6:$T$9999,14,0)","v":"1902-09-26"},"تاريخ الإصدار",{"$f":"VLOOKUP($C$2,Sheet1!$D$6:$T$9999,6,0)","v":2020},null,null,"شرورة","النور"]
[null,"المدفوع",{"$f":"VLOOKUP($C$2,Sheet1!$D$6:$T$9999,15,0)","v":300},"تاريخ الانتهاء",{"$f":"VLOOKUP($C$2,Sheet1!$D$6:$T$9999,7,0)","v":2030},null,null,"خميس مشيط"]
[null,"الباقي",{"$f":"VLOOKUP($C$2,Sheet1!$D$6:$T$9999,16,0)","v":700},"رقم التلفون",{"$f":"VLOOKUP($C$2,Sheet1!$D$6:$T$9999,8,0)","v":123456789},null,null,"نجران"]
[null,"ملاحظة",{"$f":"VLOOKUP($C$2,Sheet1!$D$6:$T$9999,17,0)","v":"لا توجد ملاحظة "},"جهة اصداره",{"$f":"VLOOKUP($C$2,Sheet1!$D$6:$T$9999,9,0)","v":"جدة"},null,null,"جيزان "]
[null,"احكام التذكرة","التاجيل اوالالغاء يوم الرحله تفقد  قيمة التذكرة كاملة      التاجيل قبل الرحلة برسوم 30%",null,null,null,null,"ابها"]
[null,"العنوان","شارع العدين امام الكريمي الرئيسي هاتف رقم -04530971-سيار(771725725-717027334-735099431)"]