{"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":""},"כתובת בבית","רחוב קונטוסו 123, תל-אביב 45678"]
[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,\"Missing important details\",\"פרטים חשובים מלאים\")","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-02-24"},{"$f":"IF(F4=\"\",1,\"\")","v":""},"תאריך",{"$f":"TODAY()+51","v":"2013-03-02"}]
[{"$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-02-24"},null,null,"פעילות 1","סקי"]
["","שם מלון","המרכז לציוד סקי",null,{"$f":"IF(AND($G$4<>\"\",G5=\"\"),1,\"\")","v":1},"תאריכים/שעות"]
["","כתובת מלון","רחוב הצפצפות 412",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-02-24T12:00:00"},null,null,"פעילות 2","כוהו קרם ויקב"]
["","יום/שעת עזיבה",{"$f":"TODAY()+50.5","v":"2013-03-01T12: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=\"Yes\",D5=\"\"),1,\"\")","v":""},"תאריך שמירה",{"$f":"TODAY()+45","v":"2013-02-24"}]
[null,"","חברת השכרת רכב"]
[null,"","יום/שעת איסוף"]
[null,"","יום/שעת החזרה"]
[null,"","מספר אישור"]
[null,"","סוג רכב","משפחתית"]
[null,"","מספר טלפון"]
[]
[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-05-01T12:00:00",null,{"$f":"IF(G6=\"\",1,\"\")","v":1},"שם / קשר / טלפון"]
["","מספר אישור","1900-05-01T12:00:00"]
["","תאריך רכישה",{"$f":"TODAY()","v":"2013-01-10"},null,null,"שם / קשר / טלפון"]
[1,"תאריכי כיסוי"]
[]
[{"$f":"EmergencyEntry","v":5},{"$f":"IF(A11<>EmergencyCount,\"פרטים חשובים חסרים\",\"פרטים חשובים מלאים\")","v":"פרטים חשובים חסרים"}]