{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["الصفحة الرئيسية","التفاصيل الشخصية","تفاصيل السفر","الفندق والأنشطة","إيجار سيارة","تفاصيل الطوارئ"],"not_rendered":{"images":19,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"الصفحة الرئيسية","index":0,"n_rows":34,"n_cols":22,"rows_kept":34,"merged":[[32,1,32,3],[32,6,32,8],[32,11,32,13],[32,16,32,18],[32,21,32,23],[33,1,33,3],[33,6,33,8],[33,11,33,13],[33,16,33,18],[33,21,33,23]]}
{"$rows_empty":32}
[null,{"$f":"PersonalEntry/PersonalCount","v":{"v":1,"d":"100%"}},{"$nulls":4},{"$f":"TravelEntry/TravelCount","v":{"v":0.65,"d":"65%"}},{"$nulls":4},{"$f":"HotelEntry/HotelCount","v":{"v":0.5384615384615384,"d":"54%"}},{"$nulls":4},{"$f":"IF('إيجار سيارة'!D4=\"نعم\",CarRentalEntry/CarRentalCount,1)","v":{"v":0.2857142857142857,"d":"29%"}},{"$nulls":4},{"$f":"EmergencyEntry/EmergencyCount","v":{"v":0.625,"d":"63%"}}]
[null,{"$f":"TEXT(B33,\"0% \"\"كامل\"\"\")","v":"100% كامل"},{"$nulls":4},{"$f":"TEXT(G33,\"0% \"\"كامل\"\"\")","v":"65% كامل"},{"$nulls":4},{"$f":"TEXT(L33,\"0% \"\"كامل\"\"\")","v":"54% كامل"},{"$nulls":4},{"$f":"TEXT(Q33,\"0% \"\"كامل\"\"\")","v":"29% كامل"},{"$nulls":4},{"$f":"TEXT(V33,\"0% \"\"كامل\"\"\")","v":"63% كامل"}]

{"sheet":"التفاصيل الشخصية","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"merged":[[4,2,5,2],[4,3,5,3],[4,4,5,4],[7,2,8,2],[7,3,8,3],[7,4,8,4],[17,1,17,4]]}
[]
[]
[{"$f":"IF(COUNTA(B4:B8)<1,\"*\",\"\")","v":""},"الأسماء الكاملة والكنى",{"$f":"IF(E3=\"\",1,\"\")","v":""},"عنوان المنزل","987 شمال الشارع الخامس، الرياض"]
[null,"حاتم عياد"]
[null,"جاكلين حداد",{"$f":"IF(E5=\"\",1,\"\")","v":""},"هاتف المنزل",3455550123]
[null,"عمرو زكي"]
[]
[null,null,{"$f":"IF((E8=0)+(E8=\"\"),1,\"\")","v":""},"الهواتف الخلوية",3455550124]
[]
[]
[{"$f":"PersonalEntry","v":3},{"$f":"IF(A11<>PersonalCount,\"تفاصيل مهمة مفقودة\",\"اكتملت التفاصيل المهمة\")","v":"اكتملت التفاصيل المهمة"}]

{"sheet":"تفاصيل السفر","index":2,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[23,1,23,5]]}
[]
[]
[null,"تفاصيل المغادرة",null,null,"تفاصيل العودة"]
[{"$f":"IF(C4=\"\",1,\"\")","v":""},"التاريخ",{"$f":"TODAY()+45","v":"2013-01-31"},{"$f":"IF(F4=\"\",1,\"\")","v":""},"التاريخ",{"$f":"TODAY()+51","v":"2013-02-06"}]
[{"$f":"IF(C5=\"\",1,\"\")","v":""},"شركة الطيران","الشركة الوطنية للإنتاج","","شركة الطيران","الشركة الوطنية للإنتاج"]
[{"$f":"IF(C6=\"\",1,\"\")","v":""},"رقم رحلة الطيران","WS192",1,"رقم رحلة الطيران"]
[{"$f":"IF(C7=\"\",1,\"\")","v":""},"من","الرياض","","من","جدة"]
[{"$f":"IF(C8=\"\",1,\"\")","v":""},"وقت المغادرة","12:30:00",1,"وقت المغادرة"]
[null,"محطة/بوابة المغادرة",null,1,"محطة/بوابة المغادرة"]
[{"$f":"IF(C10=\"\",1,\"\")","v":""},"إلى","جدة",1,"إلى"]
[{"$f":"IF(C11=\"\",1,\"\")","v":""},"وقت الوصول","12:32:00",1,"وقت الوصول"]
[null,"طول الرحلة","6 ساعات",null,"طول الرحلة"]
[{"$f":"IF(C13=\"\",1,\"\")","v":""},"أرقام المقاعد","A1, A2,A3",{"$f":"IF(F13=\"\",1,\"\")","v":1},"أرقام المقاعد"]
[{"$f":"IF(C14=\"\",1,\"\")","v":""},"الأرقام المؤكدة","نفسها",{"$f":"IF(F14=\"\",1,\"\")","v":1},"الأرقام المؤكدة"]
[{"$f":"IF(C15=\"\",1,\"\")","v":""},"الوجبة","بلا قيود",null,"الوجبة"]
[null,"رقم هاتف شركة الطيران",1235550234,null,"رقم هاتف شركة الطيران",1235550234]
[]
[{"$f":"TravelEntry","v":13},{"$f":"IF(A18<>TravelCount,\"تفاصيل مهمة مفقودة\",\"اكتملت التفاصيل المهمة\")","v":"تفاصيل مهمة مفقودة"}]

{"sheet":"الفندق والأنشطة","index":3,"n_rows":15,"n_cols":7,"rows_kept":15,"merged":[[21,1,21,6]]}
[]
[]
[null,"تفاصيل الإقامة في الفندق",{"$nulls":3},"تفاصيل نشاط العطلة"]
[{"$f":"IF(C4=\"\",1,\"\")","v":""},"تاريخ الحجز",{"$f":"TODAY()+45","v":"2013-01-31"},null,null,"النشاط 1","التزلج"]
["","اسم الفندق","شركة القمر المنير",null,{"$f":"IF(AND($G$4<>\"\",G5=\"\"),1,\"\")","v":1},"التواريخ/الأوقات"]
["","عنوان الفندق","789 الشارع الرئيسي",null,{"$f":"IF(AND($G$4<>\"\",G6=\"\"),1,\"\")","v":1},"تاريخ الحجز"]
["","رقم هاتف الفندق","جدة",null,{"$f":"IF(AND($G$4<>\"\",G7=\"\"),1,\"\")","v":1},"الرقم المؤكد"]
["","يوم/وقت التسجيل في الفندق",{"$f":"TODAY()+45.5","v":"2013-01-31T12:00:00"},null,null,"النشاط 2","ركن الهواة"]
["","يوم/وقت مغادرة الفندق",{"$f":"TODAY()+50.5","v":"2013-02-05T12:00:00"},null,{"$f":"IF(AND($G$8<>\"\",G9=\"\"),1,\"\")","v":1},"التواريخ/الأوقات"]
["","الرقم المؤكد","CJ1234567",null,{"$f":"IF(AND($G$8<>\"\",G10=\"\"),1,\"\")","v":1},"تاريخ الحجز"]
[{"$nulls":4},{"$f":"IF(AND($G$8<>\"\",G11=\"\"),1,\"\")","v":1},"الرقم المؤكد"]
[{"$f":"HotelEntry","v":7},{"$f":"IF(A12<>HotelCount,\"تفاصيل مهمة مفقودة\",\"اكتملت التفاصيل المهمة\")","v":"تفاصيل مهمة مفقودة"},{"$nulls":3},"النشاط 3"]
[{"$nulls":4},{"$f":"IF(AND($G$12<>\"\",G13=\"\"),1,\"\")","v":""},"التواريخ/الأوقات"]
[{"$nulls":4},{"$f":"IF(AND($G$12<>\"\",G14=\"\"),1,\"\")","v":""},"تاريخ الحجز"]
[{"$nulls":4},{"$f":"IF(AND($G$12<>\"\",G15=\"\"),1,\"\")","v":""},"الرقم المؤكد"]

{"sheet":"إيجار سيارة","index":4,"n_rows":13,"n_cols":4,"rows_kept":13,"merged":[[18,0,18,4]]}
[]
[]
[null,null,"معلومات تأجير السيارة"]
[null,null,"هل تريد تأجير سيارة؟","نعم"]
[null,{"$f":"IF(AND($D$4=\"نعم\",D5=\"\"),1,\"\")","v":""},"تاريخ الحجز",{"$f":"TODAY()+45","v":"2013-01-31"}]
[null,{"$f":"IF(AND($D$4=\"نعم\",D6=\"\"),1,\"\")","v":1},"شركة التأجير"]
[null,1,"يوم/وقت استلام السيارة"]
[null,1,"يوم/وقت إعادة السيارة"]
[null,1,"الرقم المؤكد"]
[null,"","نوع السيارة","الاقتصادية"]
[null,1,"رقم الهاتف"]
[]
[null,{"$f":"CarRentalEntry","v":2},{"$f":"IF(B13<>CarRentalCount,\"تفاصيل مهمة مفقودة\",\"اكتملت التفاصيل المهمة\")","v":"تفاصيل مهمة مفقودة"}]

{"sheet":"تفاصيل الطوارئ","index":5,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[3,4,4,4],[3,5,4,5],[3,6,4,6],[5,4,6,4],[5,5,6,5],[5,6,6,6],[7,5,8,5],[7,6,8,6],[16,1,16,6]]}
[]
[]
[null,"تفاصيل التأمين",{"$nulls":3},"تفاصيل جهة اتصال الطوارئ"]
[{"$f":"IF(C4=\"\",1,\"\")","v":""},"شركة التأمين","الشركة الوطنية",null,{"$f":"IF(G4=\"\",1,\"\")","v":1},"الاسم/العلاقة/الهاتف"]
["","رقم الهاتف",1235550567]
["","نوع التغطية","1900-01-05",null,{"$f":"IF(G6=\"\",1,\"\")","v":1},"الاسم/العلاقة/الهاتف"]
["","الرقم المؤكد","1900-01-05"]
["","تاريخ الشراء",{"$f":"TODAY()","v":"2012-12-17"},null,null,"الاسم/العلاقة/الهاتف"]
[1,"تواريخ التغطية"]
[]
[{"$f":"EmergencyEntry","v":5},{"$f":"IF(A11<>EmergencyCount,\"تفاصيل مهمة مفقودة\",\"اكتملت التفاصيل المهمة\")","v":"تفاصيل مهمة مفقودة"}]