{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Avaleht","Isikuandmed","Reisimise üksikasjad","Hotell ja tegevused","Autorent","Hädaolukorra üksikasjad"],"not_rendered":{"images":19,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Avaleht","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":"IsiklikKirje/IsiklikArv","v":{"v":1,"d":"100%"}},{"$nulls":4},{"$f":"ReisimineKirje/ReisimineArv","v":{"v":0.65,"d":"65%"}},{"$nulls":4},{"$f":"HotellKirje/HotellArv","v":{"v":0.5384615384615384,"d":"54%"}},{"$nulls":4},{"$f":"IF(Autorent!D4=\"Jah\",AutorentKirje/AutorentArv,1)","v":{"v":0.2857142857142857,"d":"29%"}},{"$nulls":4},{"$f":"HädaolukordKirje/HädaolukordArv","v":{"v":0.625,"d":"63%"}}]
[null,{"$f":"TEXT(B33,\"0% \"\"Täielik\"\"\")","v":"100% Täielik"},{"$nulls":4},{"$f":"TEXT(G33,\"0% \"\"Täielik\"\"\")","v":"65% Täielik"},{"$nulls":4},{"$f":"TEXT(L33,\"0% \"\"Täielik\"\"\")","v":"54% Täielik"},{"$nulls":4},{"$f":"TEXT(Q33,\"0% \"\"Täielik\"\"\")","v":"29% Täielik"},{"$nulls":4},{"$f":"TEXT(V33,\"0% \"\"Täielik\"\"\")","v":"63% Täielik"}]

{"sheet":"Isikuandmed","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":""},"Täisnimed ja hüüdnimed",{"$f":"IF(E3=\"\",1,\"\")","v":""},"Kodune aadress","Põhjamaa tee 987, Haapsalu, 01234"]
[null,"Kalju Luik"]
[null,"Aigi Luik",{"$f":"IF(E5=\"\",1,\"\")","v":""},"Kodutelefon",3455550123]
[null,"Siim Savi"]
[]
[null,null,{"$f":"IF((E8=0)+(E8=\"\"),1,\"\")","v":""},"Mobiiltelefonid",3455550124]
[]
[]
[{"$f":"IsiklikKirje","v":3},{"$f":"IF(A11<>IsiklikArv,\"Olulised üksikasjad puuduvad\",\"Olulised üksikasjad on täielikud\")","v":"Olulised üksikasjad on täielikud"}]

{"sheet":"Reisimise üksikasjad","index":2,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[23,1,23,5]]}
[]
[]
[null,"Väljalennu üksikasjad",null,null,"Tagasilennu üksikasjad"]
[{"$f":"IF(C4=\"\",1,\"\")","v":""},"Kuupäev",{"$f":"TODAY()+45","v":"2013-02-10"},{"$f":"IF(F4=\"\",1,\"\")","v":""},"Kuupäev",{"$f":"TODAY()+51","v":"2013-02-16"}]
[{"$f":"IF(C5=\"\",1,\"\")","v":""},"Lennuliin","Blue Yonder Airlines","","Lennuliin","Blue Yonder Airlines"]
[{"$f":"IF(C6=\"\",1,\"\")","v":""},"Lennu number","WS192",1,"Lennu number"]
[{"$f":"IF(C7=\"\",1,\"\")","v":""},"Lähtekoht","Haapsalu","","Lähtekoht","Otepää"]
[{"$f":"IF(C8=\"\",1,\"\")","v":""},"Väljalennu kellaaeg","12:30:00",1,"Väljalennu kellaaeg"]
[null,"Väljalennu terminal/värav",null,1,"Väljalennu terminal/värav"]
[{"$f":"IF(C10=\"\",1,\"\")","v":""},"Sihtkoht","Otepää",1,"Sihtkoht"]
[{"$f":"IF(C11=\"\",1,\"\")","v":""},"Saabumise kellaaeg","12:32:00",1,"Saabumise kellaaeg"]
[null,"Lennu kestus","6 tundi",null,"Lennu kestus"]
[{"$f":"IF(C13=\"\",1,\"\")","v":""},"Kohtade numbrid","A1, A2, A3",{"$f":"IF(F13=\"\",1,\"\")","v":1},"Kohtade numbrid"]
[{"$f":"IF(C14=\"\",1,\"\")","v":""},"Kinnituse numbrid","Sama",{"$f":"IF(F14=\"\",1,\"\")","v":1},"Kinnituse numbrid"]
[{"$f":"IF(C15=\"\",1,\"\")","v":""},"Eine","Kitsendusteta",null,"Eine"]
[null,"Lennuliini telefoninumber",1235550234,null,"Lennuliini telefoninumber",1235550234]
[]
[{"$f":"ReisimineKirje","v":13},{"$f":"IF(A18<>ReisimineArv,\"Olulised üksikasjad puuduvad\",\"Olulised üksikasjad on täielikud\")","v":"Olulised üksikasjad puuduvad"}]

{"sheet":"Hotell ja tegevused","index":3,"n_rows":15,"n_cols":7,"rows_kept":15,"merged":[[21,1,21,6]]}
[]
[]
[null,"Hotelli / majutuse üksikasjad",{"$nulls":3},"Puhkusetegevuse üksikasjad"]
[{"$f":"IF(C4=\"\",1,\"\")","v":""},"Broneerimiskuupäev",{"$f":"TODAY()+45","v":"2013-02-10"},null,null,"Tegevus 1","Suusatamine"]
["","Hotelli nimi","Alpine Ski House",null,{"$f":"IF(AND($G$4<>\"\",G5=\"\"),1,\"\")","v":1},"Kuupäevad/kellaajad"]
["","Hotelli aadress","Peatänav 789",null,{"$f":"IF(AND($G$4<>\"\",G6=\"\"),1,\"\")","v":1},"Broneerimiskuupäev"]
["","Hotelli telefoninumber","Otepää",null,{"$f":"IF(AND($G$4<>\"\",G7=\"\"),1,\"\")","v":1},"Kinnituse number"]
["","Sisseregistreerimise kuupäev/kellaaeg",{"$f":"TODAY()+45.5","v":"2013-02-10T12:00:00"},null,null,"Tegevus 2","Coho Vineyard & Winery"]
["","Väljaregistreerimise kuupäev/kellaaeg",{"$f":"TODAY()+50.5","v":"2013-02-15T12:00:00"},null,{"$f":"IF(AND($G$8<>\"\",G9=\"\"),1,\"\")","v":1},"Kuupäevad/kellaajad"]
["","Kinnituse number","CJ1234567",null,{"$f":"IF(AND($G$8<>\"\",G10=\"\"),1,\"\")","v":1},"Broneerimiskuupäev"]
[{"$nulls":4},{"$f":"IF(AND($G$8<>\"\",G11=\"\"),1,\"\")","v":1},"Kinnituse number"]
[{"$f":"HotellKirje","v":7},{"$f":"IF(A12<>HotellArv,\"Olulised üksikasjad puuduvad\",\"Olulised üksikasjad on täielikud\")","v":"Olulised üksikasjad puuduvad"},{"$nulls":3},"Tegevus 3"]
[{"$nulls":4},{"$f":"IF(AND($G$12<>\"\",G13=\"\"),1,\"\")","v":""},"Kuupäevad/kellaajad"]
[{"$nulls":4},{"$f":"IF(AND($G$12<>\"\",G14=\"\"),1,\"\")","v":""},"Broneerimiskuupäev"]
[{"$nulls":4},{"$f":"IF(AND($G$12<>\"\",G15=\"\"),1,\"\")","v":""},"Kinnituse number"]

{"sheet":"Autorent","index":4,"n_rows":13,"n_cols":4,"rows_kept":13,"merged":[[18,0,18,4]]}
[]
[]
[null,null,"Autorendi teave"]
[null,null,"Autorent?","Jah"]
[null,{"$f":"IF(AND($D$4=\"Jah\",D5=\"\"),1,\"\")","v":""},"Broneerimiskuupäev",{"$f":"TODAY()+45","v":"2013-02-10"}]
[null,{"$f":"IF(AND($D$4=\"Jah\",D6=\"\"),1,\"\")","v":1},"Rendiettevõte"]
[null,{"$f":"IF(AND($D$4=\"Jah\",D7=\"\"),1,\"\")","v":1},"Järeletuleku kuupäev/kellaaeg"]
[null,{"$f":"IF(AND($D$4=\"Jah\",D8=\"\"),1,\"\")","v":1},"Tagastamise kuupäev/kellaaeg"]
[null,{"$f":"IF(AND($D$4=\"Jah\",D9=\"\"),1,\"\")","v":1},"Kinnituse number"]
[null,{"$f":"IF(AND($D$4=\"Jah\",D10=\"\"),1,\"\")","v":""},"Sõiduki tüüp","Sõiduauto"]
[null,{"$f":"IF(AND($D$4=\"Jah\",D11=\"\"),1,\"\")","v":1},"Telefoninumber"]
[]
[null,{"$f":"AutorentKirje","v":2},{"$f":"IF(B13<>AutorentArv,\"Olulised üksikasjad puuduvad\",\"Olulised üksikasjad on täielikud\")","v":"Olulised üksikasjad puuduvad"}]

{"sheet":"Hädaolukorra üksikasjad","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,"Kindlustuse üksikasjad",{"$nulls":3},"Kontaktisiku üksikasjad hädaolukorras"]
[{"$f":"IF(C4=\"\",1,\"\")","v":""},"Kindlustusfirma","Humongous Insurance",null,{"$f":"IF(G4=\"\",1,\"\")","v":1},"Nimi / seos / telefon"]
["","Telefoninumber",1235550567]
["","Kindlustuse tüüp","1900-01-05",null,{"$f":"IF(G6=\"\",1,\"\")","v":1},"Nimi / seos / telefon"]
["","Kinnituse number","1900-01-05"]
["","Ostukuupäev",{"$f":"TODAY()","v":"2012-12-27"},null,null,"Nimi / seos / telefon"]
[1,"Kindlustusperioodi kuupäevad"]
[]
[{"$f":"HädaolukordKirje","v":5},{"$f":"IF(A11<>HädaolukordArv,\"Olulised üksikasjad puuduvad\",\"Olulised üksikasjad on täielikud\")","v":"Olulised üksikasjad puuduvad"}]