{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Vyúčtovanie výdavkov"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Vyúčtovanie výdavkov","index":0,"n_rows":14,"n_cols":14,"rows_kept":14,"merged":[[0,1,0,5],[2,3,2,5],[2,6,2,7],[2,8,2,10],[4,3,4,5],[4,6,4,7],[4,8,4,10]]}
[null,"Vyúčtovanie cestovných výdavkov"]
[]
[null,"Meno","Lucia Králiková","Schválil/-a",null,null,"Jakub Varga",null,"Náhrada za kilometer",null,null,{"v":0.32,"d":"0.32 EUR"}]
[]
[null,"Oddelenie","Predaj","Dátum podania",null,null,{"$f":"TODAY()","v":"2018-05-14"},null,"Celková splatná náhrada",null,null,{"$f":"CelkováSplatnáNáhrada","v":{"v":550.3846011865525,"d":"550.38 EUR"}}]
[]
[null,"Obdobie",{"$f":"IF(MIN(B10:B13)=MAX(B10:B13),TEXT(MIN(B10:B13),\"d.m.yy\"),\"Od \"&TEXT(MIN(B10:B13),\"d.m.yy\")&\" do \"&TEXT(MAX(B10:B13),\"d.m.yy\"))","v":"Od 14.4.18 do 19.4.18"}]
[]
[null,"Dátum","Popis výdavku","Letenky","Ubytovanie","Pozemná doprava \n(palivo, požičanie auta, taxi)","Jedlo a prepitné","Konferencie a semináre","Kilometre","Náhrada nákladov podľa prejdených kilometrov","Rôzne","Výmenný kurz","Mena výdavku","Spolu"]
[null,{"$f":"TODAY()-30","v":"2018-04-14"},"Cesta na pracovisko klienta",{"v":350,"d":"350.00"},{"v":150,"d":"150.00"},{"v":45,"d":"45.00"},{"v":12,"d":"12.00"},{"v":50,"d":"50.00"},{"v":35,"d":"35.00"},{"$f":"IF('Vyúčtovanie výdavkov'!I10<>\"\",'Vyúčtovanie výdavkov'!I10*SumaNaKilometer,\"\")","v":{"v":11.200000000000001,"d":"11.20"}},null,{"v":1.517,"d":"1.52"},"EUR",{"$f":"IFERROR(IF(OR('Vyúčtovanie výdavkov'!$L10=\"\",'Vyúčtovanie výdavkov'!$L10=1),SUM('Vyúčtovanie výdavkov'!$J10:$K10,'Vyúčtovanie výdavkov'!$D10:$H10)*1,SUM('Vyúčtovanie výdavkov'!$J10:$K10,'Vyúčtovanie výdavkov'!$D10:$H10)/'Vyúčtovanie výdavkov'!$L10),\"\")","v":{"v":407.5148319050759,"d":"407.51 EUR"}}]
[null,{"$f":"TODAY()-30","v":"2018-04-14"},"Obed s klientom",{"$nulls":3},{"v":24.3,"d":"24.30"},null,{"v":12,"d":"12.00"},{"$f":"IF('Vyúčtovanie výdavkov'!I11<>\"\",'Vyúčtovanie výdavkov'!I11*SumaNaKilometer,\"\")","v":3.84},null,{"v":1.517,"d":"1.52"},"EUR",{"$f":"IFERROR(IF(OR('Vyúčtovanie výdavkov'!$L11=\"\",'Vyúčtovanie výdavkov'!$L11=1),SUM('Vyúčtovanie výdavkov'!$J11:$K11,'Vyúčtovanie výdavkov'!$D11:$H11)*1,SUM('Vyúčtovanie výdavkov'!$J11:$K11,'Vyúčtovanie výdavkov'!$D11:$H11)/'Vyúčtovanie výdavkov'!$L11),\"\")","v":{"v":18.5497692814766,"d":"18.55 EUR"}}]
[null,"2018-04-14","Popoludňajší seminár",{"$nulls":4},{"v":100,"d":"100.00"},{"v":6,"d":"6.00"},{"$f":"IF('Vyúčtovanie výdavkov'!I12<>\"\",'Vyúčtovanie výdavkov'!I12*SumaNaKilometer,\"\")","v":1.92},null,{"v":1,"d":"1.00"},"EUR",{"$f":"IFERROR(IF(OR('Vyúčtovanie výdavkov'!$L12=\"\",'Vyúčtovanie výdavkov'!$L12=1),SUM('Vyúčtovanie výdavkov'!$J12:$K12,'Vyúčtovanie výdavkov'!$D12:$H12)*1,SUM('Vyúčtovanie výdavkov'!$J12:$K12,'Vyúčtovanie výdavkov'!$D12:$H12)/'Vyúčtovanie výdavkov'!$L12),\"\")","v":{"v":101.92,"d":"101.92 EUR"}}]
[null,{"$f":"TODAY()-25","v":"2018-04-19"},"Cesta na letisko",{"$nulls":5},{"v":70,"d":"70.00"},{"$f":"IF('Vyúčtovanie výdavkov'!I13<>\"\",'Vyúčtovanie výdavkov'!I13*SumaNaKilometer,\"\")","v":{"v":22.400000000000002,"d":"22.40"}},null,{"v":1,"d":"1.00"},"EUR",{"$f":"IFERROR(IF(OR('Vyúčtovanie výdavkov'!$L13=\"\",'Vyúčtovanie výdavkov'!$L13=1),SUM('Vyúčtovanie výdavkov'!$J13:$K13,'Vyúčtovanie výdavkov'!$D13:$H13)*1,SUM('Vyúčtovanie výdavkov'!$J13:$K13,'Vyúčtovanie výdavkov'!$D13:$H13)/'Vyúčtovanie výdavkov'!$L13),\"\")","v":{"v":22.400000000000002,"d":"22.40 EUR"}}]
[null,"Spolu",null,{"$f":"SUBTOTAL(109,Výdavky[Letenky])","v":{"v":350,"d":"350.00"}},{"$f":"SUBTOTAL(109,Výdavky[Ubytovanie])","v":{"v":150,"d":"150.00"}},{"$f":"SUBTOTAL(109,Výdavky[Pozemná doprava \n(palivo, požičanie auta, taxi)])","v":{"v":45,"d":"45.00"}},{"$f":"SUBTOTAL(109,Výdavky[Jedlo a prepitné])","v":{"v":36.3,"d":"36.30"}},{"$f":"SUBTOTAL(109,Výdavky[Konferencie a semináre])","v":{"v":150,"d":"150.00"}},{"$f":"SUBTOTAL(109,Výdavky[Kilometre])","v":{"v":123,"d":"123.00"}},{"$f":"SUBTOTAL(109,Výdavky[Náhrada nákladov podľa prejdených kilometrov])","v":39.36},{"$f":"SUBTOTAL(109,Výdavky[Rôzne])","v":{"v":0,"d":"0.00"}},null,null,{"$f":"SUBTOTAL(109,Výdavky[Spolu])","v":{"v":550.3846011865525,"d":"550.38 EUR"}}]