{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dodavatel","Odběratelé","Vystavení faktury","Daňová evidence","Souhrn faktur"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Dodavatel","index":0,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Dodavatel"]
[null,"Účetní období (rok)"]
[]
[null,"Název"]
[]
[null,"Ulice",null,"č.p."]
[]
[null,"Město",null,"PSČ"]
[]
[null,"IČO",null,"DIČ"]
[]
[]
[]
[null,"Číslo účtu",null,null,"Převodem"]
[null,null,null,null,"Hotově"]
[null,"Telefon",null,null,"Variabilní symbol"]
[null,null,null,null,"Datum splatnosti",14]
[null,"E-mail"]

{"sheet":"Odběratelé","index":1,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Odběratelé"]
[]
[]
[null,"Název subjektu","ulice","č.p.","město","PSČ","IČ","DIČ"]
[null,"j","k",1,"h",123456,"4869613-","-"]

{"sheet":"Vystavení faktury","index":2,"n_rows":48,"n_cols":8,"rows_kept":48,"cut":false,"hidden":false,"merged":[[46,1,46,2],[47,1,47,2],[35,0,35,1],[29,0,30,5],[11,0,15,8],[27,6,27,8],[28,6,28,8],[27,0,27,2],[28,0,28,2],[17,4,17,5],[18,4,18,5],[19,4,19,5],[20,4,20,5],[21,4,21,5],[22,4,22,5],[23,4,23,5],[0,6,0,8],[32,5,32,6],[33,5,33,6],[29,6,30,8],[6,0,6,2],[7,0,7,2],[17,6,17,8],[18,6,18,8],[19,6,19,8],[20,6,20,8],[21,6,21,8],[22,6,22,8],[23,6,23,8],[24,6,24,8],[25,6,25,8],[26,6,26,8],[24,4,24,5],[25,4,25,5],[26,4,26,5],[27,4,27,5],[28,4,28,5],[22,0,22,2],[23,0,23,2],[24,0,24,2],[25,0,25,2],[26,0,26,2],[17,0,17,2],[18,0,18,2],[19,0,19,2],[20,0,20,2],[21,0,21,2],[16,6,16,8],[2,6,2,8],[2,0,2,2],[4,0,4,2],[4,6,4,8],[5,6,5,8],[6,6,6,8],[7,6,7,8],[9,6,9,8],[10,6,10,8],[5,0,5,2],[9,0,9,2],[10,0,10,2],[16,0,16,2],[16,4,16,5]]}
[null,null,null,null,null,"Faktura č.",2016005]
[]
["Dodavatel",null,null,null,null,null,"Odběratel"]
[]
[{"$f":"Dodavatel!C5","v":0},null,null,null,null,null,"j"]
[{"$f":"CONCATENATE(Dodavatel!C7,\" \",Dodavatel!E7)","v":" "},null,null,null,null,null,{"$f":"CONCATENATE((VLOOKUP($G$5,Odběratelé!B6:H10,2)),\" \",(VLOOKUP($G$5,Odběratelé!B6:H10,3)))","v":"k 1"}]
[{"$f":"Dodavatel!C9","v":0},null,null,null,null,null,{"$f":"VLOOKUP($G$5,Odběratelé!B6:H10,4)","v":"h"}]
[{"$f":"Dodavatel!E9","v":0},null,null,null,null,null,{"$f":"VLOOKUP($G$5,Odběratelé!B6:H10,5)","v":123456}]
[]
[{"$f":"\"IČ\"&\" \"&Dodavatel!C11","v":"IČ "},null,null,null,null,null,{"$f":"CONCATENATE(\"IČ\",\" \",(VLOOKUP($G$5,Odběratelé!B6:H10,6)))","v":"IČ 4869613-"}]
[{"$f":"\"DIČ\"&\"  \"&Dodavatel!E11","v":"DIČ  "},null,null,null,null,null,{"$f":"CONCATENATE(\"DIČ\",\" \",VLOOKUP($G$5,Odběratelé!B6:H10,7))","v":"DIČ -"}]
[]
[]
[]
[]
[]
["Popis",null,null,"Množství","Jednotková cena",null,"Cena"]
[0,null,null,1,5,null,12]
[null,null,null,null,null,null,2]
[null,null,null,null,null,null,51]
[null,null,null,null,null,null,22]
[null,null,null,null,null,null,{"$f":"IF(D22*E22=0,\"\",D22*E22)","v":""}]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
["Nejsem pátcem DPH!",null,null,null,null,null,{"$f":"IF(SUM(G18:I29)=0,\"\",SUM(G18:I29))","v":87}]
[]
[]
["Platba:",null,null,null,null,"Datum vystavení",null,{"$f":"TODAY()","v":"2016-02-19"}]
["Převodem",null,null,null,null,{"$f":"IF($A$34=Dodavatel!$E$15,Dodavatel!E18,\"\")","v":"Datum splatnosti"},null,{"$f":"IF(A34=Dodavatel!E15,TODAY()+Dodavatel!$F$18,\"\")","v":"2016-03-04"}]
[]
[{"$f":"IF(A34=Dodavatel!E15,Dodavatel!$B$15,\"\")","v":"Číslo účtu"},null,null,{"$f":"IF(A34=Dodavatel!E15,Dodavatel!$E$17,\"\")","v":"Variabilní symbol"}]
[{"$f":"IF(A34=Dodavatel!E15,Dodavatel!$C$15,\"\")","v":0},null,null,{"$f":"IF(A34=Dodavatel!E15,G1,\"\")","v":2016005}]
[]
[]
[]
[]
[]
[]
[]
[]
["Kontakt:"]
["telefon:",{"$f":"Dodavatel!C17","v":0}]
["e-mail:",{"$f":"Dodavatel!C19","v":0}]

{"sheet":"Daňová evidence","index":3,"n_rows":6,"n_cols":12,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,4,0],[0,1,0,11],[2,1,4,1],[2,3,4,3],[2,4,4,4],[1,1,1,3],[3,5,3,7],[3,8,3,10],[2,5,2,11],[3,11,4,11],[2,2,4,2],[1,5,1,6],[1,7,1,8],[1,9,1,11]]}
[]
[null,"Daňová evidence",null,null,{"$f":"Dodavatel!C3","v":0},{"$f":"Dodavatel!C5","v":0},null,{"$f":"\"IČ\"&\" \"&Dodavatel!C11","v":"IČ "},null,{"$f":"CONCATENATE(Dodavatel!C7,\"\",Dodavatel!E7,\"\",Dodavatel!C9,\"\",Dodavatel!E9)","v":""}]
[null,"Datum vystavení","Datum zaúčtování","Číslo dokladu","Popis","Peněžní prostředky"]
[null,null,null,null,null,"Hotovost",null,null,"Banka",null,null,"Celkový stav"]
[null,null,null,null,null,"příjmy","výdaje","zůstatek","příjmy","výdaje","zůstatek"]
[null,null,null,null,null,"počátek",null,1000000,"počátek",null,1000000,{"$f":"H6+K6","v":2000000}]

{"sheet":"Souhrn faktur","index":4,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Souhrn faktur",{"$f":"Dodavatel!C3","v":0}]
[]
[null,"Číslo faktury","Datum vystavení","Datum splatnosti","Odběratel","Suma"]
[null,{"$f":"HYPERLINK(\"D:\\Faktury\\2016001_j.pdf\",\"2016001\")","v":"2016001"},"2016-02-18","2016-03-03","j",87]
[null,{"$f":"HYPERLINK(\"D:\\Faktury\\2016002_j.pdf\",\"2016002\")","v":"2016002"},"2016-02-18","2016-03-03","j",87]
[null,{"$f":"HYPERLINK(\"D:\\Faktury\\2016003_j.pdf\",\"2016003\")","v":"2016003"},"2016-02-10","2016-02-24","j",87]
[null,{"$f":"HYPERLINK(\"D:\\Faktury\\2016004_j.pdf\",\"2016004\")","v":"2016004"},"2016-02-10","2016-02-24","j",87]