{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Nastavení","PřidatFakturu","PřehledFaktur","FakturyPřijaté","Souhrny","OAplikaci","Nastaveni"],"not_rendered":{"charts":1,"images":4,"macros":1,"external_links":0,"defined_names":43,"comments":0,"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":"Nastavení","index":0,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[[9,7,9,8]]}
[]
[null,"Nastavení xFaktur"]
[]
[null,"Údaje o dodavateli",null,null,"Společné údaje k fakturám",null,null,"Zdrojová data"]
[]
[null,"Název:",null,null,"Číslo první faktury:",2012001,null,"Aktuální účetní rok:",2012]
[]
[null,"Ulice:",null,null,"Doba splatnosti (dny):",14,null,"Označení zdrojových dat:"]
[]
[null,"Město:",null,null,"Implicitní způsob platby:","bankovním převodem",null,2012]
[]
[null,"PSČ:"]
[]
[null,"IČ:"]
[]
[null,"Číslo účtu:"]
[]
[null,"Kód banky:"]
[]
[null,"Banka:"]
[]
[null,"Konstantní symbol:"]
[]
[null,"Mobil:"]
[]
[null,"Telefon:"]
[]
[null,"E-mail:"]
[]
[null,"WWW:"]
[]
[null,"Zapsán v ŽR:"]
[]
[null,"Fakturu vystavil:"]

{"sheet":"PřidatFakturu","index":1,"n_rows":31,"n_cols":15,"rows_kept":31,"cut":false,"hidden":false,"merged":[[5,8,5,11],[6,8,6,11],[7,9,7,11],[5,3,5,6],[6,3,6,6],[7,4,7,6],[9,9,9,11],[26,10,26,11],[12,4,12,6],[16,10,16,11],[18,10,18,11],[19,10,19,11],[16,4,16,6],[9,4,9,6],[17,4,17,6],[13,4,13,6]]}
[]
[null,null,null,null,null,null,null,null,null,null,"Faktura č."]
[]
[null,null,"Dodavatel:",null,null,null,null,null,"Odběratel:"]
[]
[]
[]
[null,null,null,"",null,null,null,null,""]
[]
[null,null,null,"IČ:","",null,null,null,"IČ:"]
[]
[null,null,null,null,"",null,""]
[]
[]
[]
[null,null,"Bankovní spojení:",null,null,null,null,null,null,null,null,null,null,null,"Přehled faktur"]
[null,null,null,"Číslo účtu:","",null,null,null,"Způsob platby:"]
[null,null,null,"Banka:"]
[null,null,null,"Variabilní symbol:",null,null,"",null,"Datum vystavení:"]
[null,null,null,"Konstantní symbol:",null,null,"",null,"Datum splatnosti:"]
[]
[]
[null,null,"Popis",null,null,null,null,null,null,"Počet","Cena za jednotku","Cena celkem"]
[]
[null,"P"]
[]
[null,"C",null,null,null,null,null,null,null,"Celkem k úhradě:"]
[]
[null,null,null,null,null,null,null,null,"Podpis:"]
[]
[null,null,"Nejsem plátcem DPH."]

{"sheet":"PřehledFaktur","index":2,"n_rows":5,"n_cols":10,"rows_kept":5,"cut":false,"hidden":false,"merged":[[2,2,2,9]]}
[null,"ID_FAKTURY","CISLO_FAKTURY","DATUM_VYSTAVENI","DATUM_SPLATNOSTI","DATUM_UHRADY","NAZEV_ODB","ZPUSOB_PLATBY","CELKOVA_SUMA","UHRAZENA_CASTKA"]
[]
[null,null,"PŘEHLED FAKTUR VYSTAVENÝCH"]
[]
[null,null,"ČÍSLO FAKTURY","DATUM VYSTAVENÍ","DATUM SPLATNOSTI","DATUM ÚHRADY","NÁZEV ODBĚRATELE","ZPŮSOB PLATBY","CELKOVÁ ČÁSTKA","UHRAZENO CELKEM"]

{"sheet":"FakturyPřijaté","index":3,"n_rows":5,"n_cols":12,"rows_kept":5,"cut":false,"hidden":false,"merged":[[2,1,2,11]]}
[null,"ID_FAKTURY","DOSLO_DNE","CISLO_FAKTURY","DATUM_VYSTAVENI","DATUM_SPLATNOSTI","DATUM_UHRADY","DODAVATEL","ZPUSOB_UHRADY","CASTKA","VARIABILNI_SYMBOL","POZNAMKA"]
[]
[null,"PŘEHLED FAKTUR PŘIJATÝCH"]
[]
[null,"POŘ. ČÍSLO","DOŠLO DNE","ČÍSLO FAKTURY","DATUM VYSTAVENÍ","DATUM SPLATNOSTI","DATUM ÚHRADY","DODAVATEL","ZPŮSOB ÚHRADY","CELKOVÁ ČÁSTKA","VARIABILNÍ SYMBOL","POZNÁMKA"]

{"sheet":"Souhrny","index":4,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[[3,3,3,4],[3,5,3,6],[3,2,4,2],[1,2,1,5],[23,2,24,2],[23,3,23,4],[23,5,23,8],[19,2,19,7]]}
[]
[null,null,"ROČNÍ PŘEHLED",null,null,null,{"$f":"ucetniRok","v":2012}]
[]
[null,null,"Měsíc","Vystavené faktury",null,"Uhrazené faktury"]
[null,null,null,"počet","celková suma","počet","uhrazená částka"]
[null,1,"LEDEN",0,0,0,0]
[null,2,"ÚNOR",0,0,0,0]
[null,3,"BŘEZEN",0,0,0,0]
[null,4,"DUBEN",0,0,0,0]
[null,5,"KVĚTEN",0,0,0,0]
[null,6,"ČERVEN",0,0,0,0]
[null,7,"ČERVENEC",0,0,0,0]
[null,8,"SRPEN",0,0,0,0]
[null,9,"ZÁŘÍ",0,0,0,0]
[null,10,"ŘÍJEN",0,0,0,0]
[null,11,"LISTOPAD",0,0,0,0]
[null,12,"PROSINEC",0,0,0,0]
[null,null,"CELKEM",{"$f":"SUM(D6:D17)","v":0},{"$f":"SUM(E6:E17)","v":0},0,0]
[]
[null,null,"PŘEHLED PODLE ODBĚRATELŮ",null,null,null,null,null,{"$f":"ucetniRok","v":2012}]
[]
[null,null,"Odběratel:"]
[]
[null,null,"Měsíc","Vystavené faktury",null,"Uhrazené faktury"]
[null,null,null,"počet","celková suma","počet","uhrazená částka","uhrazeno po splatnosti","dní po splatnosti"]
[null,1,"LEDEN",0,0,0,0,0,0]
[null,2,"ÚNOR",0,0,0,0,0,0]
[null,3,"BŘEZEN",0,0,0,0,0,0]
[null,4,"DUBEN",0,0,0,0,0,0]
[null,5,"KVĚTEN",0,0,0,0,0,0]
[null,6,"ČERVEN",0,0,0,0,0,0]
[null,7,"ČERVENEC",0,0,0,0,0,0]
[null,8,"SRPEN",0,0,0,0,0,0]
[null,9,"ZÁŘÍ",0,0,0,0,0,0]
[null,10,"ŘÍJEN",0,0,0,0,0,0]
[null,11,"LISTOPAD",0,0,0,0,0,0]
[null,12,"PROSINEC",0,0,0,0,0,0]
[null,null,"CELKEM",{"$f":"SUM(D26:D37)","v":0},{"$f":"SUM(E26:E37)","v":0},0,0,0,0]

{"sheet":"OAplikaci","index":5,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"xFaktury"]
[]
[null,"verze:","2.2"]
[null,"datum vydání:","2011-12-14"]
[]
[null,"autor:","Linda Mrázková"]
[null,"e-mail:","Linda.Mrazkova@ToBudeteCubr.net"]
[null,"www:","http://reporty.tobudetecubr.net"]
[]
[]
[null,"Aplikace x Faktury je určena k volnému užití."]
[]
[]
[]
[null,"Prosím, informujte mě na výše uvedený e-mail o jakékoliv chybě, která se vyskytne při Vaší práci s aplikací."]

{"sheet":"Nastaveni","index":6,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["verze","2.2",null,"typy_faktur","data_odberatele","data_faktury","data_polozky","data_nastaveni","data_faktury_p"]
["aktualni faktura",-1,null,"faktura jednotková","ID_ODBERATELE","ID_FAKTURY","ID_POLOZKY","ID_DODAVATELE","ID_FAKTURY"]
["aktualni odberatel",0,null,"faktura za službu","NAZEV","CISLO_FAKTURY","ID_FAKTURY","NAZEV","DOSLO_DNE"]
["aktualni typ faktury",1,null,null,"ULICE","DATUM_VYSTAVENI","POPIS","ULICE","CISLO_FAKTURY"]
[null,null,null,null,"MESTO","DATUM_SPLATNOSTI","MNOZSTVI","MESTO","DATUM_VYSTAVENI"]
[null,null,null,null,"PSC","ID_ODBERATELE","JEDNOTKA","PSC","DATUM_SPLATNOSTI"]
[null,null,null,null,"IC","VS","JEDNOTKOVA_CENA","IC","DODAVATEL"]
[null,null,null,null,"KONTAKT_OSOBA","KS","CELKOVA_CENA","CISLO_UCTU","ZPUSOB_UHRADY"]
[null,null,null,null,"TELEFON","ZPUSOB_PLATBY",null,"KOD_BANKY","CASTKA"]
[null,null,null,null,"EMAIL","VYSTAVIL",null,"BANKA","DATUM_UHRADY"]
[null,null,null,null,"KONTAKT_ADRESA","NAZEV_DOD",null,"KS","VARIABILNI_SYMBOL"]
[null,null,null,null,null,"ULICE_DOD",null,"TELEFON","POZNAMKA"]
[null,null,null,null,null,"MESTO_DOD",null,"MOBIL"]
[null,null,null,null,null,"PSC_DOD",null,"EMAIL"]
[null,null,null,null,null,"IC_DOD",null,"ZAPSAN_ZR"]
[null,null,null,null,null,"TEL_DOD",null,"FAKTURU_VYSTAVIL"]
[null,null,null,null,null,"MOBIL_DOD",null,"PRVNI_CISLO"]
[null,null,null,null,null,"EMAIL_DOD",null,"DOBA_SPLATNOSTI"]
[null,null,null,null,null,"WWW_DOD",null,"ZPUSOB_PLATBY"]
[null,null,null,null,null,"NAZEV_ODB",null,"DATUM_ZMENY"]
[null,null,null,null,null,"ULICE_ODB",null,"UCETNI_ROK"]
[null,null,null,null,null,"MESTO_ODB",null,"WWW"]
[null,null,null,null,null,"PSC_ODB"]
[null,null,null,null,null,"IC_ODB"]
[null,null,null,null,null,"UCET"]
[null,null,null,null,null,"BANKA"]
[null,null,null,null,null,"CELKOVA_SUMA"]
[null,null,null,null,null,"DATUM_UHRADY"]
[null,null,null,null,null,"UHRAZENA_CASTKA"]
[null,null,null,null,null,"POZNAMKA"]
[null,null,null,null,null,"TYP"]