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

{"sheet":"Vyúčtování výdajů","index":0,"n_rows":45,"n_cols":10,"rows_kept":45,"merged":[[18,1,18,9],[27,1,27,9],[35,1,35,9],[40,1,43,4]]}
["NÁZEV SPOLEČNOSTI"]
["VYÚČTOVÁNÍ VÝDAJŮ"]
[]
[null,"ZAMĚSTNANCI:","Helena Kupková",{"$nulls":3},"SCHVÁLIL(A):"]
[null,"ODDĚLENÍ:","Prodej"]
[null,"KONEC TÝDNE:","2013-03-07",{"$nulls":3},"DATUM:"]
[null,"RYCHLOST V KM:",{"v":0.67,"d":"0.67 Kč"}]
[]
[null,null,{"$f":"UPPER(TEXT(C10,\"dddd\"))","v":"PÁTEK"},{"$f":"UPPER(TEXT(D10,\"dddd\"))","v":"SOBOTA"},"NEDĚLE","PONDĚLÍ","ÚTERÝ","STŘEDA","ČTVRTEK"]
[null,"DOPRAVA",{"$f":"KonecTýdne-6","v":"2013-03-01"},{"$f":"KonecTýdne-5","v":"2013-03-02"},{"$f":"KonecTýdne-4","v":"2013-03-03"},{"$f":"KonecTýdne-3","v":"2013-03-04"},{"$f":"KonecTýdne-2","v":"2013-03-05"},{"$f":"KonecTýdne-1","v":"2013-03-06"},{"$f":"KonecTýdne","v":"2013-03-07"},"CELKEM"]
[null,"Najeté kilometry",145,{"$nulls":6},{"$f":"SUM(doprava[[#This Row],[Den 1]:[Den 7]])","v":145}]
[null,"Úhrada ujetých km",{"$f":"C11*Kilometrovné","v":{"v":97.15,"d":"97.15 Kč"}},{"v":0,"d":"0.00 Kč"},{"v":0,"d":"0.00 Kč"},{"v":0,"d":"0.00 Kč"},{"v":0,"d":"0.00 Kč"},{"v":0,"d":"0.00 Kč"},{"v":0,"d":"0.00 Kč"},{"$f":"SUM(doprava[[#This Row],[Den 1]:[Den 7]])","v":{"v":97.15,"d":"97.15 Kč"}}]
[null,"Parkování a poplatky",{"$nulls":3},{"v":17,"d":"17.00 Kč"},{"$nulls":3},{"$f":"SUM(doprava[[#This Row],[Den 1]:[Den 7]])","v":{"v":17,"d":"17.00 Kč"}}]
[null,"Pronájem auta",{"v":79,"d":"79.00 Kč"},null,null,{"v":79,"d":"79.00 Kč"},{"$nulls":3},{"$f":"SUM(doprava[[#This Row],[Den 1]:[Den 7]])","v":{"v":158,"d":"158.00 Kč"}}]
[null,"Taxi / doprava",{"$nulls":7},{"$f":"SUM(doprava[[#This Row],[Den 1]:[Den 7]])","v":{"v":0,"d":"0.00 Kč"}}]
[null,"Jiné (železnice nebo autobus)",{"$nulls":7},{"$f":"SUM(doprava[[#This Row],[Den 1]:[Den 7]])","v":{"v":0,"d":"0.00 Kč"}}]
[null,"Letecká doprava",{"$nulls":3},{"v":235,"d":"235.00 Kč"},{"$nulls":3},{"$f":"SUM(doprava[[#This Row],[Den 1]:[Den 7]])","v":{"v":235,"d":"235.00 Kč"}}]
[null,"CELKEM",{"$f":"SUBTOTAL(109,C12:C17)","v":{"v":176.15,"d":"176.15 Kč"}},{"$f":"SUBTOTAL(109,D12:D17)","v":{"v":0,"d":"0.00 Kč"}},null,{"v":331,"d":"331.00 Kč"},{"v":0,"d":"0.00 Kč"},{"v":0,"d":"0.00 Kč"},{"v":0,"d":"0.00 Kč"},{"$f":"SUM(J12:J17)","v":{"v":507.15,"d":"507.15 Kč"}}]
[]
[null,"UBYTOVÁNÍ & STRAVA"]
[null,"Ubytování",{"v":145,"d":"145.00 Kč"},{"$nulls":6},{"$f":"SUM(UbytováníStrava[[#This Row],[Den 1]:[Den 7]])","v":{"v":145,"d":"145.00 Kč"}}]
[null,"Snídaně",{"v":11.49,"d":"11.49 Kč"},{"$nulls":6},{"$f":"SUM(UbytováníStrava[[#This Row],[Den 1]:[Den 7]])","v":{"v":11.49,"d":"11.49 Kč"}}]
[null,"Oběd",{"v":12,"d":"12.00 Kč"},{"$nulls":6},{"$f":"SUM(UbytováníStrava[[#This Row],[Den 1]:[Den 7]])","v":{"v":12,"d":"12.00 Kč"}}]
[null,"Večeře",{"v":17,"d":"17.00 Kč"},{"$nulls":6},{"$f":"SUM(UbytováníStrava[[#This Row],[Den 1]:[Den 7]])","v":{"v":17,"d":"17.00 Kč"}}]
[null,"Občerstvení",{"$f":"C24*Kilometrovné","v":{"v":11.39,"d":"11.39 Kč"}},{"$nulls":6},{"$f":"SUM(UbytováníStrava[[#This Row],[Den 1]:[Den 7]])","v":{"v":11.39,"d":"11.39 Kč"}}]
[null,"Mezisoučet za jídlo",{"$f":"SUM(C22:C24)","v":{"v":40.49,"d":"40.49 Kč"}},{"$f":"SUM(D22:D24)","v":{"v":0,"d":"0.00 Kč"}},{"v":0,"d":"0.00 Kč"},{"v":0,"d":"0.00 Kč"},{"v":0,"d":"0.00 Kč"},{"v":0,"d":"0.00 Kč"},{"v":0,"d":"0.00 Kč"},{"$f":"SUM(UbytováníStrava[[#This Row],[Den 1]:[Den 7]])","v":{"v":40.49,"d":"40.49 Kč"}}]
[null,"CELKEM",{"$f":"SUBTOTAL(109,C21,C26)","v":{"v":185.49,"d":"185.49 Kč"}},{"$f":"SUBTOTAL(109,D21,D26)","v":{"v":0,"d":"0.00 Kč"}},{"v":0,"d":"0.00 Kč"},{"v":0,"d":"0.00 Kč"},{"v":0,"d":"0.00 Kč"},{"v":0,"d":"0.00 Kč"},{"v":0,"d":"0.00 Kč"},{"$f":"SUBTOTAL(109,J21,J26)","v":{"v":185.49,"d":"185.49 Kč"}}]
[]
[null,"RŮZNÉ"]
[null,"Zásoby",{"$nulls":7},{"$f":"SUM(Různé[[#This Row],[Den 1]:[Den 7]])","v":{"v":0,"d":"0.00 Kč"}}]
[null,"Zařízení",{"$nulls":7},{"$f":"SUM(Různé[[#This Row],[Den 1]:[Den 7]])","v":{"v":0,"d":"0.00 Kč"}}]
[null,"Telefon, fax, Internet",{"$nulls":7},{"$f":"SUM(Různé[[#This Row],[Den 1]:[Den 7]])","v":{"v":0,"d":"0.00 Kč"}}]
[null,"Jiné*",{"$nulls":7},{"$f":"SUM(Různé[[#This Row],[Den 1]:[Den 7]])","v":{"v":0,"d":"0.00 Kč"}}]
[null,"Zábava*",{"$nulls":3},{"v":199,"d":"199.00 Kč"},{"$nulls":3},{"$f":"SUM(Různé[[#This Row],[Den 1]:[Den 7]])","v":{"v":199,"d":"199.00 Kč"}}]
[null,"CELKEM",{"$f":"SUBTOTAL(109,Různé[Den 1])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,Různé[Den 2])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,Různé[Den 3])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,Různé[Den 4])","v":{"v":199,"d":"199.00 Kč"}},{"$f":"SUBTOTAL(109,Různé[Den 5])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,Různé[Den 6])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,Různé[Den 7])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,Různé[Celkem])","v":{"v":199,"d":"199.00 Kč"}}]
[]
[null,"CELKOVÉ SOUČTY",{"$f":"SUM(Různé[[#Totals],[Den 1]],UbytováníStrava[[#Totals],[Den 1]],doprava[[#Totals],[Den 1]])","v":{"v":361.64,"d":"361.64 Kč"}},{"$f":"SUM(Různé[[#Totals],[Den 2]],UbytováníStrava[[#Totals],[Den 2]],doprava[[#Totals],[Den 2]])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUM(Různé[[#Totals],[Den 3]],UbytováníStrava[[#Totals],[Den 3]],doprava[[#Totals],[Den 3]])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUM(Různé[[#Totals],[Den 4]],UbytováníStrava[[#Totals],[Den 4]],doprava[[#Totals],[Den 4]])","v":{"v":530,"d":"530.00 Kč"}},{"$f":"SUM(Různé[[#Totals],[Den 5]],UbytováníStrava[[#Totals],[Den 5]],doprava[[#Totals],[Den 5]])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUM(Různé[[#Totals],[Den 6]],UbytováníStrava[[#Totals],[Den 6]],doprava[[#Totals],[Den 6]])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUM(Různé[[#Totals],[Den 7]],UbytováníStrava[[#Totals],[Den 7]],doprava[[#Totals],[Den 7]])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUM(Různé[[#Totals],[Celkem]],UbytováníStrava[[#Totals],[Celkem]],doprava[[#Totals],[Celkem]])","v":{"v":891.64,"d":"891.64 Kč"}}]
[]
[{"$nulls":9},"VÝDAJE CELKEM"]
[null,"*Obchodní účel pro položky Zábava a Ostatní:",{"$nulls":7},{"$f":"SUM(J18,J27,J35)","v":{"v":891.64,"d":"891.64 Kč"}}]
[{"$nulls":9},"POKROKY"]
[]
[{"$nulls":9},"ÚHRADA CELKEM"]
[{"$nulls":9},{"$f":"J40-J42","v":{"v":891.64,"d":"891.64 Kč"}}]
[{"$nulls":9},"Připojte prosím všechny příjmové doklady."]