{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Domov","Osobné údaje","Údaje o ceste","Ubytovanie a činnosti","Požičanie auta","Osobné údaje pre prípad núdze"],"not_rendered":{"images":19,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Domov","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":"PoložkaPersonálu/PočetPersonálu","v":{"v":1,"d":"100%"}},{"$nulls":4},{"$f":"PoložkaCesty/PočetCiest","v":{"v":0.65,"d":"65%"}},{"$nulls":4},{"$f":"PoložkaUbytovaniaVHoteli/PočetUbytovaníVHoteli","v":{"v":0.5384615384615384,"d":"54%"}},{"$nulls":4},{"$f":"IF('Požičanie auta'!D4=\"Áno\",PoložkaPožičaniaAuta/PočetPožičaníAuta,1)","v":{"v":0.2857142857142857,"d":"29%"}},{"$nulls":4},{"$f":"PoložkaPrípaduNúdze/PočetPrípadovNúdze","v":{"v":0.625,"d":"63%"}}]
[null,{"$f":"TEXT(B33,\"0% \"\"úplné\"\"\")","v":"100% úplné"},{"$nulls":4},{"$f":"TEXT(G33,\"0% \"\"úplné\"\"\")","v":"65% úplné"},{"$nulls":4},{"$f":"TEXT(L33,\"0% \"\"úplné\"\"\")","v":"54% úplné"},{"$nulls":4},{"$f":"TEXT(Q33,\"0% \"\"úplné\"\"\")","v":"29% úplné"},{"$nulls":4},{"$f":"TEXT(V33,\"0% \"\"úplné\"\"\")","v":"63% úplné"}]

{"sheet":"Osobné údaje","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":""},"Celé mená a prezývky",{"$f":"IF(E3=\"\",1,\"\")","v":""},"Bydlisko","Severná 987, 012 34 Kolumbus"]
[null,"Peter Horváth"]
[null,"Zuzana Horváthová",{"$f":"IF(E5=\"\",1,\"\")","v":""},"Telefón domov",3455550123]
[null,"Miroslav Horváth"]
[]
[null,null,{"$f":"IF((E8=0)+(E8=\"\"),1,\"\")","v":""},"Čísla na mobil",3455550124]
[]
[]
[{"$f":"PoložkaPersonálu","v":3},{"$f":"IF(A11<>PočetPersonálu,\"Chýbajúce dôležité podrobnosti\",\"Dôležité podrobnosti sú úplné\")","v":"Dôležité podrobnosti sú úplné"}]

{"sheet":"Údaje o ceste","index":2,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[23,1,23,5]]}
[]
[]
[null,"Podrobnosti o odlete",null,null,"Podrobnosti o návrate"]
[{"$f":"IF(C4=\"\",1,\"\")","v":""},"Dátum",{"$f":"TODAY()+45","v":"2013-02-21"},{"$f":"IF(F4=\"\",1,\"\")","v":""},"Dátum",{"$f":"TODAY()+51","v":"2013-02-27"}]
[{"$f":"IF(C5=\"\",1,\"\")","v":""},"Letecká spoločnosť","Blue Yonder Airlines","","Letecká spoločnosť","Blue Yonder Airlines"]
[{"$f":"IF(C6=\"\",1,\"\")","v":""},"Číslo letu","WS192",1,"Číslo letu"]
[{"$f":"IF(C7=\"\",1,\"\")","v":""},"Z:","Kolumbus","","Z:","Ružomberok"]
[{"$f":"IF(C8=\"\",1,\"\")","v":""},"Čas odletu","12:30:00",1,"Čas odletu"]
[null,"Odletový terminál/odletová brána",null,1,"Odletový terminál/odletová brána"]
[{"$f":"IF(C10=\"\",1,\"\")","v":""},"Do:","Ružomberok",1,"Do:"]
[{"$f":"IF(C11=\"\",1,\"\")","v":""},"Čas príletu","12:32:00",1,"Čas príletu"]
[null,"Dĺžka letu","6 hodín",null,"Dĺžka letu"]
[{"$f":"IF(C13=\"\",1,\"\")","v":""},"Čísla sedadiel","A1, A2, A3",{"$f":"IF(F13=\"\",1,\"\")","v":1},"Čísla sedadiel"]
[{"$f":"IF(C14=\"\",1,\"\")","v":""},"Číslo potvrdenia","Rovnaké",{"$f":"IF(F14=\"\",1,\"\")","v":1},"Číslo potvrdenia"]
[{"$f":"IF(C15=\"\",1,\"\")","v":""},"Jedlo","Bez obmedzení",null,"Jedlo"]
[null,"Telefónne číslo leteckej spoločnosti",1235550234,null,"Telefónne číslo leteckej spoločnosti",1235550234]
[]
[{"$f":"PoložkaCesty","v":13},{"$f":"IF(A18<>PočetCiest,\"Chýbajúce dôležité podrobnosti\",\"Dôležité podrobnosti sú úplné\")","v":"Chýbajúce dôležité podrobnosti"}]

{"sheet":"Ubytovanie a činnosti","index":3,"n_rows":15,"n_cols":7,"rows_kept":15,"merged":[[21,1,21,6]]}
[]
[]
[null,"Pobyt v hoteli/Podrobnosti ubytovania",{"$nulls":3},"Podrobnosti o dovolenkových aktivitách"]
[{"$f":"IF(C4=\"\",1,\"\")","v":""},"Dátum rezervácie",{"$f":"TODAY()+45","v":"2013-02-21"},null,null,"Činnosť 1","Lyžovanie"]
["","Názov hotela","Alpine Ski House",null,{"$f":"IF(AND($G$4<>\"\",G5=\"\"),1,\"\")","v":1},"Dátum/čas"]
["","Adresa hotela","Hlavná 123",null,{"$f":"IF(AND($G$4<>\"\",G6=\"\"),1,\"\")","v":1},"Dátum rezervácie"]
["","Telefónne číslo hotela","Ružomberok",null,{"$f":"IF(AND($G$4<>\"\",G7=\"\"),1,\"\")","v":1},"Číslo potvrdenia"]
["","Deň/čas ubytovania",{"$f":"TODAY()+45.5","v":"2013-02-21T12:00:00"},null,null,"Činnosť 2","Vinica a výrobňa vína Coho"]
["","Deň/čas odubytovania",{"$f":"TODAY()+50.5","v":"2013-02-26T12:00:00"},null,{"$f":"IF(AND($G$8<>\"\",G9=\"\"),1,\"\")","v":1},"Dátum/čas"]
["","Číslo potvrdenia","CJ1234567",null,{"$f":"IF(AND($G$8<>\"\",G10=\"\"),1,\"\")","v":1},"Dátum rezervácie"]
[{"$nulls":4},{"$f":"IF(AND($G$8<>\"\",G11=\"\"),1,\"\")","v":1},"Číslo potvrdenia"]
[{"$f":"PoložkaUbytovaniaVHoteli","v":7},{"$f":"IF(A12<>PočetUbytovaníVHoteli,\"Chýbajúce dôležité podrobnosti\",\"Dôležité podrobnosti sú úplné\")","v":"Chýbajúce dôležité podrobnosti"},{"$nulls":3},"Činnosť 3"]
[{"$nulls":4},{"$f":"IF(AND($G$12<>\"\",G13=\"\"),1,\"\")","v":""},"Dátum/čas"]
[{"$nulls":4},{"$f":"IF(AND($G$12<>\"\",G14=\"\"),1,\"\")","v":""},"Dátum rezervácie"]
[{"$nulls":4},{"$f":"IF(AND($G$12<>\"\",G15=\"\"),1,\"\")","v":""},"Číslo potvrdenia"]

{"sheet":"Požičanie auta","index":4,"n_rows":13,"n_cols":4,"rows_kept":13,"merged":[[18,0,18,4]]}
[]
[]
[null,null,"Informácie o požičaní auta"]
[null,null,"Požičanie auta?","Áno"]
[null,{"$f":"IF(AND($D$4=\"Áno\",D5=\"\"),1,\"\")","v":""},"Dátum rezervácie",{"$f":"TODAY()+45","v":"2013-02-21"}]
[null,1,"Požičovňa áut"]
[null,1,"Dátum/čas vyzdvihnutia"]
[null,1,"Dátum/čas vrátenia"]
[null,1,"Číslo potvrdenia"]
[null,"","Typ vozidla","Ekonomický"]
[null,1,"Telefónne číslo"]
[]
[null,{"$f":"PoložkaPožičaniaAuta","v":2},{"$f":"IF(B13<>PočetPožičaníAuta,\"Chýbajúce dôležité podrobnosti\",\"Dôležité podrobnosti sú úplné\")","v":"Chýbajúce dôležité podrobnosti"}]

{"sheet":"Osobné údaje pre prípad núdze","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,"Podrobnosti o poistení",{"$nulls":3},"Kontakt pre naliehavé prípady"]
[{"$f":"IF(C4=\"\",1,\"\")","v":""},"Poisťovňa","Životné poistenie, s. r. o.",null,{"$f":"IF(G4=\"\",1,\"\")","v":1},"Meno/vzťah/telefón"]
["","Telefónne číslo",1235550567]
["","Typ poistného krytia","1900-01-05",null,{"$f":"IF(G6=\"\",1,\"\")","v":1},"Meno/vzťah/telefón"]
["","Číslo potvrdenia","1900-01-05"]
["","Dátum zakúpenia",{"$f":"TODAY()","v":"2013-01-07"},null,null,"Meno/vzťah/telefón"]
[1,"Trvanie poistného krytia"]
[]
[{"$f":"PoložkaPrípaduNúdze","v":5},{"$f":"IF(A11<>PočetPrípadovNúdze,\"Chýbajúce dôležité podrobnosti\",\"Dôležité podrobnosti sú úplné\")","v":"Chýbajúce dôležité podrobnosti"}]