{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Výkaz o ujetých kilometrech..."],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Výkaz o ujetých kilometrech...","index":0,"n_rows":20,"n_cols":9,"rows_kept":20}
[null,"Výkaz o ujetých kilometrech a vyúčtování výdajů"]
[]
[null,"Jméno zaměstnance",null,"Sazba za kilometr",{"v":0.27,"d":"0.27 Kč"}]
[null,"Osobní číslo",null,"Za období",{"$f":"\"Od \"&TEXT(MIN(B9:B19),\"d.m.rr\")&\" do \"&TEXT(MAX(B9:B19),\"d.m.rr\")","v":"Od 4.8.17 do 5.8.17"}]
[null,"Popis vozidla",null,"Kilometry celkem",{"$f":"Vzdálenost_celkem","v":10}]
[null,"Schválil",null,"Proplaceno celkem",{"$f":"Proplaceno_celkem","v":{"v":2.7,"d":"2.70 Kč"}}]
[]
[null,"Datum","Výchozí bod","Cíl","Popis/Poznámky","Tachometr – počáteční stav","Tachometr – konečný stav","Najeté kilometry","Náhrady"]
[null,{"$f":"TODAY()","v":"2017-08-04"},"Domácí kancelář","Northwind Traders","Schůzka s klientem",36098,36103,{"$f":"IFERROR(IF(OR(ISBLANK(F9),ISBLANK(G9)),0,G9-F9), \"\")","v":5},{"$f":"IFERROR(H9*$E$3, \"\")","v":{"v":1.35,"d":"1.35 Kč"}}]
[null,{"$f":"TODAY()+1","v":"2017-08-05"},"Northwind Traders","Domácí kancelář","Schůzka s klientem",36103,36108,{"$f":"IFERROR(IF(OR(ISBLANK(F10),ISBLANK(G10)),0,G10-F10), \"\")","v":5},{"$f":"IFERROR(H10*$E$3, \"\")","v":{"v":1.35,"d":"1.35 Kč"}}]
[{"$nulls":7},0,{"v":0,"d":"0.00 Kč"}]
[{"$nulls":7},0,{"v":0,"d":"0.00 Kč"}]
[{"$nulls":7},0,{"v":0,"d":"0.00 Kč"}]
[{"$nulls":7},0,{"v":0,"d":"0.00 Kč"}]
[{"$nulls":7},0,{"v":0,"d":"0.00 Kč"}]
[{"$nulls":7},0,{"v":0,"d":"0.00 Kč"}]
[{"$nulls":7},0,{"v":0,"d":"0.00 Kč"}]
[{"$nulls":7},0,{"v":0,"d":"0.00 Kč"}]
[{"$nulls":7},{"$f":"IFERROR(IF(OR(ISBLANK(F19),ISBLANK(G19)),0,G19-F19), \"\")","v":0},{"$f":"IFERROR(H19*$E$3, \"\")","v":{"v":0,"d":"0.00 Kč"}}]
[{"$nulls":6},"Celkem",{"$f":"SUBTOTAL(109,Výdaje[Najeté kilometry])","v":10},{"$f":"SUBTOTAL(109,Výdaje[Náhrady])","v":{"v":2.7,"d":"2.70 Kč"}}]