{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Vyúčtování výdajů"],"not_rendered":{"images":1,"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"Vyúčtování výdajů","index":0,"n_rows":21,"n_cols":12,"rows_kept":21,"merged":[[0,1,0,8],[0,9,0,11],[2,2,2,3],[2,4,2,5],[2,6,2,7],[5,2,5,3],[5,6,5,7],[5,10,5,11],[6,2,6,3],[6,6,6,7],[6,10,6,11],[17,1,17,10],[18,1,18,10],[19,1,19,10],[20,2,20,4],[20,6,20,9]]}
[null,"Název společnosti",{"$nulls":7},"Pouze pro interní použití"]
[null,"Vyúčtování výdajů"]
[null,"ÚČEL:",null,null,"ČÍSLO VYÚČTOVÁNÍ:",{"$nulls":4},"PLATEBNÍ OBDOBÍ:","Od",{"$f":"IFERROR(IF(LEN(B10)=0,\"\",MIN(Výdaje[Datum])), \"\")","v":""}]
[{"$nulls":10},"Do",{"$f":"IFERROR(IF(LEN(B10)=0,\"\",MAX(Výdaje[Datum])), \"\")","v":""}]
[null,"ÚDAJE O ZAMĚSTNANCI:"]
[null,"Jméno",{"$nulls":3},"Pozice",{"$nulls":3},"Rodné číslo"]
[null,"Oddělení",{"$nulls":3},"Nadřízený",{"$nulls":3},"ID zaměstnance"]
[]
[null,"Datum","Účet","Popis","Hotel","Doprava","Palivo","Strava","Telefon","Zábava","Různé","Celkem"]
[{"$nulls":11},{"$f":"IFERROR(SUM(Výdaje[[#This Row],[Hotel]:[Různé]]), \"\")","v":0}]
[{"$nulls":11},{"$f":"IFERROR(SUM(Výdaje[[#This Row],[Hotel]:[Různé]]), \"\")","v":0}]
[{"$nulls":11},{"$f":"IFERROR(SUM(Výdaje[[#This Row],[Hotel]:[Různé]]), \"\")","v":0}]
[{"$nulls":11},{"$f":"IFERROR(SUM(Výdaje[[#This Row],[Hotel]:[Různé]]), \"\")","v":0}]
[{"$nulls":11},{"$f":"IFERROR(SUM(Výdaje[[#This Row],[Hotel]:[Různé]]), \"\")","v":0}]
[{"$nulls":11},{"$f":"IFERROR(SUM(Výdaje[[#This Row],[Hotel]:[Různé]]), \"\")","v":0}]
[{"$nulls":11},{"$f":"IFERROR(SUM(Výdaje[[#This Row],[Hotel]:[Různé]]), \"\")","v":0}]
[null,"Celkem",null,null,{"$f":"SUBTOTAL(109,Výdaje[Hotel])","v":0},{"$f":"SUBTOTAL(109,Výdaje[Doprava])","v":0},{"$f":"SUBTOTAL(109,Výdaje[Palivo])","v":0},{"$f":"SUBTOTAL(109,Výdaje[Strava])","v":0},{"$f":"SUBTOTAL(109,Výdaje[Telefon])","v":0},{"$f":"SUBTOTAL(109,Výdaje[Zábava])","v":0},{"$f":"SUBTOTAL(109,Výdaje[Různé])","v":0},{"$f":"SUBTOTAL(109,Výdaje[Celkem])","v":0}]
[null,"Mezisoučet",{"$nulls":9},{"$f":"IFERROR(SUM(Výdaje[[#Totals],[Celkem]]), \"\")","v":0}]
[null,"Hotovostní zálohy"]
[null,"Celkem",{"$nulls":9},{"$f":"IFERROR((L18-L19), \"\")","v":0}]
[null,"SCHVÁLIL(A):",{"$nulls":3},"POZNÁMKY: "]