{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["TISK_CHYBY","BLANK","CONFIG","TISK","TISK_VYROBKY","TISK_RECEPTURY","TISK_SUROVINA","TISK_PRVNIKONTROLA","TISK_DODANE_VYROBKY","TISK_OBRAZKY"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":59,"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":"TISK_CHYBY","index":0,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":true,"merged":[[6,4,6,6],[7,4,7,6],[8,4,8,6],[9,4,9,6],[2,1,2,6]]}
[null,"C1","C2","C3","C4","C5","C6"]
["H0"]
["H0","CHYBY V DATOVÉ STRUKTUŘE"]
["H0"]
["T1H"]
["T1H","Seznam zjištěných chyb"]
["T1H","Problém","Tabulka","Index","Poznamka"]
["T1FL","Datum","dddd",2222,55]
["T1L","Datum","dddd",2222,55]
["T1BL","Datum","dddd",2222,55]

{"sheet":"BLANK","index":1,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[13,1,13,3],[13,4,13,5],[1,1,1,31],[3,1,3,2]]}
[]
[null,"EDoK - Evidence surovin, receptur a výrobků Domácích Kutilů"]
[]
[null,"Počet záznamů v databázi",null,null,null,null,null,null,null,"Verze : 11.03 (2.1.2021)"]
[null,"SUROVINY",492]
[null,"RECEPTURY",63]
[null,"VÝROBKY",166]
[null,"KONTAKTY",16]
[null,"OBRÁZKY",8]
[null,"TS_Data.xlsx"]
[null,"Verze datového souboru:  11"]
[null,"D:\\EDOK\\TS_Data.xlsx"]

{"sheet":"CONFIG","index":2,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["Položka konfigurace","Hodnota"]
["SourceDataFile","D:\\EDOK\\TS_Data.xlsx"]
["PictureFolder_SUR","D:\\EDOK\\Obrazky\\Suroviny"]
["BackupFolder","D:\\EDOK\\Zaloha"]
["CopyToAppFolder",1]
["ShowDialog",0]
["MaterialExp (ANO/NE, počet dní)",1,10]
["ProductExp (ANO/NE, počet dní)",1,10]
["Seznam tabulek datového souboru"]
["DATA_VERSION"]
["SKUPINY_SUROVIN",{"$f":" MAX($A$2:$A$1000000)","v":0},"Jméno skupiny"]
["SKLAD_MISTO",{"$f":" MAX($A$2:$A$1000000)","v":0},"Oznaceni Mista"]
["SUROVINY",0,"Skupina","Surovina","Jednotka","Množství","Pořizovací cena","Dodavatel","Datum Nákupu","Datum Spotřeby","Cena/MJ","Poznámka","Umístění","Blank","Blank","Inventura"]
["NAKUP",0,"Datum","IndexDodavatele","Jmeno Dodavatele(Info)","Poznámka"]
["SUROVINY_NAKUP",0,"Index Suroviny","IndexNakup","Surovina","Jednotka","Množství","Pořizovací cena","Dodavatel(info)","Datum Nákupu(Info)","Datum Spotřeby","Spotřebováno","Poznámka","Cena/MJ","Temp","Inventura"]
["RECEPTURY",0,"NazevReceptury","Autor","Poznamka","Množství","MJ"]
["RECEPTURY_POL",0,"IndexReceptury","IndexSuroviny","Název(Jen Info)","Množství","MJ(Jen Info)"]
["VYROBA",0,"IndexReceptury","Množství(Poměr k receptuře)","DatumVýroby","Vyrobené Množství","Datum Doporučené spotřeby","Název výrobku","Příprav/Hotovo","Dodáno","Měrná jednotka","Výrobní cena","Skladem"]
["VYROBA_POL",0,"IndexVyrobku","IndexSurovinaNakup","IndexSurovina","Množství","CenaPoložky"]
["VYROBA_ODBER",0,"IndexVyrobku","Index Odběratele","DatumDodávky","Objem","Poznámka","Cena"]
["VYROBA_SKLAD",0,"IndexPolozkyVyrobku","IndexNakupuSuroviny","Pocet"]
["KONTAKTY",0,"Odberatel","Dodavatel","Nazev_Jmeno","Adresa","Město","PSC","Telefon","Telefon2","Email","WWW","Poznamka"]
["OBRAZKY",0,"Soubor","Modul (SUROVINY/RECEPTURY/VYROBKY/KONTAKTY)","Index modulu","Report","In App Gallery"]
["OBR-MODULE",0,"Jmeno","Sheet","NameColumn"]
["BLANK"]
[null,"Buňka vlevo musí zůstat prázdná !!"]
[]
[]
[]
["PictureFolder_REC","D:\\EDOK\\Obrazky\\Receptury"]
["PictureFolder_VYR","D:\\EDOK\\Obrazky\\Výrobky"]
["PictureFolder_KON","D:\\EDOK\\Obrazky\\Kontakty"]
[]
[]
["DataFile is Visible",1,"Datový soubor bude viditelný (nebude skrytý), podud je tento parametr  1"]

{"sheet":"TISK","index":3,"n_rows":108,"n_cols":6,"rows_kept":108,"cut":false,"hidden":true,"merged":[[107,1,107,3],[107,4,107,5],[0,1,0,5],[1,2,1,5],[2,2,2,5]]}
[null,"INVENTURNÍ SOUPISKA"]
[null,"Skupina surovin:","Másla a oleje"]
[null,"Umístění surovin:","VŠECHNA místa"]
[null,"Název suroviny OBSAHUJE text :",""]
[null,"Zobrazovat i NULOVÉ stavy skladu ?","ANO"]
[null,"Název suroviny","MJ","Množství","Cena","Inventura"]
[null,"Ricinový olej","ml"," 75,00"," 43,50"]
[null,"Ultraskvalan / Hemiskvalan","ml"," 0,00"," 0,00"]
[null,"Sacha Inchi Organic","ml"," 0,00"," 0,00"]
[null,"Makadamiový olej","ml"," 20,00"," 39,60"]
[null,"Caprylis (MCT neutrální olej)","ml"," 152,30"," 106,61"]
[null,"Arganový olej BIO LZS","ml"," 226,00"," 578,94"]
[null,"Cupuacu máslo divoký sběr","g"," 50,00"," 120,00"]
[null,"Illipe máslo","g"," 97,50"," 135,52"]
[null,"Mango máslo LZS","g"," 78,10"," 109,34"]
[null,"Kyselina Stearová","g"," 39,00"," 35,10"]
[null,"Lanolin","g"," 169,00"," 143,65"]
[null,"Meruňkový olej BIO LZS","ml"," 0,00"," 0,00"]
[null,"Skvalan 50ml","ml"," 50,00"," 164,00"]
[null,"Kávové máslo 50g","g"," 1,00"," 2,40"]
[null,"Marulový olej 30ml","ml"," 57,00"," 255,08"]
[null,"Yangu olej 30ml","ml"," 30,00"," 159,00"]
[null,"Olivový olej Pomace","ml","1 830,00"," 195,47"]
[null,"Meruňkový olej BIO LZS","ml"," 16,20"," 22,03"]
[null,"Mandlový olej raf.","ml"," 800,29"," 239,29"]
[null,"Avokádový olej 100 ml","ml"," 0,00"," 0,00"]
[null,"Olej ze semen révy vinné 100 ml","ml"," 30,00"," 19,80"]
[null,"Jojobový olej 100 ml","ml"," 0,00"," 0,00"]
[null,"Konopný olej","ml"," 22,70"," 44,95"]
[null,"vavřínový olej","g"," 0,00"," 0,00"]
[null,"pupalkový olej","ml"," 117,10"," 289,37"]
[null,"BIO kakaové máslo LZS raw","g"," 571,80"," 397,44"]
[null,"Dermofeel sensolv","ml"," 64,00"," 69,76"]
[null,"kokosový olej","g"," 0,00"," 0,00"]
[null,"demi voda","ml","4 019,69"," 60,30"]
[null," BIO kakaové máslo LZS","g"," 0,00"," 0,00"]
[null,"Bambucké máslo RAF","g","1 015,00"," 201,99"]
[null,"Bambucké máslo  BIO - divoký sběr","g"," 0,00"," 0,00"]
[null,"BIO makový olej","ml"," 129,00"," 123,71"]
[null,"BIO kakaové máslo LZS","G"," 0,00"," 0,00"]
[null,"Tamanu olej","ml"," 14,00"," 33,32"]
[null,"Baobab olej LZS","ml"," 80,00"," 177,00"]
[null,"Camellia olej","ml"," 57,00"," 150,08"]
[null,"Capuacu máslo divoký sběr","g"," 5,00"," 13,00"]
[null,"Papaya olej LZ","ml"," 10,00"," 39,67"]
[null,"Světlicový olej","ml"," 581,00"," 109,69"]
[null,"neroli premium absolute oil","ml"," 6,95"," 96,60"]
[null,"olej z černého bezu","ml"," 0,00"," 0,00"]
[null,"moringový olej","ml"," 250,00"," 129,00"]
[null,"cacay olej","ml"," 5,00"," 95,00"]
[null,"Olej z černého kmínu LZS BIO","ml"," 40,00"," 63,20"]
[null,"Green coffee olej","ml"," 19,00"," 100,70"]
[null,"BIO bambucké máslo LZS","g"," 56,30"," 24,77"]
[null,"Plantsils natur","ml"," 170,00"," 236,30"]
[null,"Squalan","ml"," 32,00"," 102,40"]
[null,"Amarantový skvalan","ml"," 0,00"," 0,00"]
[null,"vanilka absolute","ml"," 0,01"," 0,50"]
[null,"Monoi tiare de tahiti oil","ml"," 118,00"," 223,02"]
[null,"třtinový skvalan","ml"," 0,00"," 0,00"]
[null,"sacha inchi olej","ml"," 10,00"," 23,90"]
[null,"Jamajský ricinový  černý olej","ml"," 16,00"," 60,48"]
[null,"kokosový olej BIO panenský","g"," 645,00"," 380,20"]
[null,"Okurkový olej","ml"," 27,00"," 134,11"]
[null,"Lískový ořech olej","ml"," 45,00"," 49,05"]
[null,"Mrkvový olej","ml"," 14,00"," 24,50"]
[null,"Malinový olej","ml"," 0,00"," 0,00"]
[null,"Šípkový olej","ml"," 0,00"," 0,00"]
[null,"Švestkový olej","ml"," 36,00"," 150,01"]
[null,"Lasemul","ml"," 0,00"," 0,00"]
[null,"Tucuma Virgin máslo","g"," 29,00"," 57,71"]
[null,"Murumuru Virgin máslo","g"," 38,00"," 75,62"]
[null,"Ucuuba Virgin máslo","g"," 0,00"," 0,00"]
[null,"BIO brokolicový olej","ml"," 45,00"," 143,10"]
[null,"orchidejový olej","ml"," 3,00"," 36,00"]
[null,"Labdanium PQ abs. oil","ml"," 8,00"," 71,20"]
[null,"Organická sérum báze hydro","ml"," 0,00"," 0,00"]
[null,"Olej z černého rybízu","ml"," 25,00"," 88,32"]
[null,"Organická sérum báze oil","ml"," 50,00"," 180,00"]
[null,"ovesný lipidový olej","ml"," 24,00"," 115,99"]
[null,"Isopropyl myristate","ml"," 0,00"," 0,00"]
[null,"Kokum máslo","g"," 90,00"," 161,10"]
[null,"Jojobový olej BIO","ml"," 226,30"," 398,34"]
[null,"Palmojádrový olej BIO ","g"," 100,00"," 31,80"]
[null,"Palmový olej","ml"," 460,00"," 32,20"]
[null,"Meruňkový olej RAW z hořkých jader","ml"," 64,00"," 95,36"]
[null,"Hroznový olej BIO LZS","ml"," 45,00"," 89,10"]
[null,"Hovězí lůj bílý","g"," 230,00"," 59,34"]
[null,"kokosový olej RAF","g","5 498,00"," 459,26"]
[null,"Avokádový olej panenský LSZ","ml"," 80,00"," 48,00"]
[null,"Mandlový olej BIO","ml"," 61,80"," 72,31"]
[null,"Slunečnicový olejHigh oleic","ml"," 959,30"," 71,95"]
[null,"Olivový olej extra virgin RAW","ml","1 500,00"," 263,00"]
[null,"Třešňový olej","ml"," 63,00"," 74,34"]
[null,"Rýžový olej Bran","ml"," 112,00"," 99,68"]
[null,"Červený palmový olej","ml"," 100,00"," 89,00"]
[null,"Bacuri virgin máslo","g"," 50,00"," 79,50"]
[null,"Babassu olej","ml"," 380,00"," 151,24"]
[null,"Nimbový olej BIO","ml"," 50,00"," 104,00"]
[null,"Olej z dračího ovoce","ml"," 27,50"," 139,34"]
[null,"Chia olej LZS","ml"," 29,00"," 91,84"]
[null,"Echium olej","ml"," 17,00"," 180,50"]
[null,"Borůvkový olej LZS","ml"," 28,88"," 118,41"]
[null,"Kakaové máslo desodorované","g"," 500,00"," 230,00"]
[null,"Olej z pšeničných klíčků","ml"," 50,00"," 75,00"]
[null,"Šípkový olej LZS","ml"," 60,00"," 202,02"]
[null,"Olej z granátového jablka","ml"," 50,00"," 155,00"]
[]
[null,"Celková cena zobrazeného seznamu surovin ",null,null,"10 312,92 Kč"]

{"sheet":"TISK_VYROBKY","index":4,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":true,"merged":[[1,1,6,1],[1,2,1,4]]}
[null,"C1","C2","C3","C4","C5","C6"]
["H0","SEZNAM VÝROBKŮ","Nastavení filtů pro zobrazení seznamu:"]
["H0",null,null,"Připravované (**) :","_V01"]
["H0",null,null,"Hotové :","_V02"]
["H0",null,null,"Skladem > 0 ks :","_V03"]
["H0",null,null,"Obshuje text:","_V04"]
["H0"]
["H0"]
["T1H","Název výrobku","Vyrobeno","Množství","Zůstatek","Použít do"]
["T1FL","TRLG - Osvětlení terasy","1.5.2020"," 1,00"," 0,00"]
["T1L","CSTT02 - čistička ","25.12.2019"," 1,00"," 1,00"]
["T1BL","jsfddsg","20.6.2020"," 1,50"," 0,00"]

{"sheet":"TISK_RECEPTURY","index":5,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":true,"merged":[[9,4,9,5],[1,1,1,5],[3,2,3,4],[6,4,6,5],[7,4,7,5],[8,4,8,5]]}
[null,"c1","c2","c3","c4","c5","c6"]
["H0","SOUPISKA RECEPTUR"]
["H0"]
["H0","které v textech obsahují:","_V01"]
["H0"]
["H0"]
["T1H","Název receptury","MJ","Množství","Autor"]
["T1FL","WeMos D1 Mini ESP8266 WIFI Module Board Pro 16M Bytes External Antenna Contor ESP8266 WIFI IOT Development Board Micro USB","ks"," 3,00"," 270,66"]
["T1L","1n1","ks"," 0,00"," 0,00"]
["BL","5A656","ks"," 0,00"," 0,00"]

{"sheet":"TISK_SUROVINA","index":6,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":true,"merged":[[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[2,1,2,6],[17,4,17,6],[18,4,18,6],[19,4,19,6],[20,4,20,6]]}
[null,"C1","C2","C3","C4","C5","C6"]
["H0","Detailní informace o SUROVINĚ"]
["H0","V02"]
["H0"]
["H0"]
["H0","Skupina:","V03",null,"Počet:","V06","V09"]
["H0","Místo:","V04",null,"Skladová cena:","V07","Kč"]
["H0","Dodavatel:","V05",null,"Cena /MJ:","V08","Kč"]
["H0"]
["H0"]
["T1H","Seznam jednotlivých nákupů suroviny:"]
["T1H","Datum","Dodavatel","Dodáno:","Spotřeb:","Cena:","Dop spotř:"]
["T1FL","Datum","dddd",2222,55,333,"dat"]
["T1L","Datum","dddd",2222,55,333,"dat"]
["T1BL","Datum","dddd",2222,55,333,"dat"]
["T2H"]
["T2H","Surovina byla využita k výrobě následujících VÝROBKŮ:"]
["T2H","Datum","Výrobek (** připravovaný výrobek)","Množství","Dle receptury"]
["T2FL","Datum","vvv",222,"rrr"]
["T2L","Datum","vvv",222,"rrr"]
["T2BL","Datum","vvv",222,"rrr"]
["T3H"]
["T3H","Surovina je součásttí následujících RECEPTUR:"]
["T3H","Receptura",null,"Autor","Množství"]
["T3FL","rrr",null,"aaa",333]
["T3L","rrr",null,"aaa",333]
["T3BL","rrr",null,"aaa",333]
["P1H"]
["P1FL","Obrázky připojené k surovině:"]

{"sheet":"TISK_PRVNIKONTROLA","index":7,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":true,"merged":[[2,1,2,6]]}
[null,"C1","C2","C3","C4","C5","C6"]
["H0"]
["H0","Problematické suroviny a výrobky"]
["H0"]
["T1H","Seznam surovin s propadlou nebo blízkou dobou spotřeby"]
["T1H","Nákup","Surovina","Skladem","Cena","Spotřebovat","Zbývá"]
["T1FL","Datum","dddd",2222,55,333,"dat"]
["T1L","Datum","dddd",2222,55,333,"dat"]
["T1BL","Datum","dddd",2222,55,333,"dat"]
["T2H"]
["T2H","Seznam surovin s malou skladovou zásobou"]
["T2H","Nákup","Surovina","Skladem","Cena","Minimum","Chybí"]
["T2FL","Datum","vvv",222,55,55,44]
["T2L","Datum","vvv",222,55,55,44]
["T2BL","Datum","vvv",222,55,55,44]
["T3H"]
["T3H","Seznam výrobků s prošlou nebo blízkou dobou doporučené spotřeby"]
["T3H","Vyrobeno","Výrobek","Skladem","MJ","Spotřebovat","Zbývá"]
["T3FL","Datum","vvv",222,55,55,44]
["T3L","Datum","vvv",222,55,55,44]
["T3BL","Datum","vvv",222,55,55,44]

{"sheet":"TISK_DODANE_VYROBKY","index":8,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":true,"merged":[[12,2,12,3],[2,1,2,6],[5,3,5,4],[9,2,9,3],[10,2,10,3],[11,2,11,3]]}
[null,"C1","C2","C3","C4","C5","C6"]
["H0","SEZNAM VÝROBKŮ DODANÝCH JEDNOMU ODBĚRATELI"]
["H0","_V02"]
["H0"]
["H0"]
["H0",null,"Celková cena dodaných výrobků:","_V03",null,"Kč"]
["H0"]
["H0"]
["T1H","Seznam jednotlivých VÝROBKŮ:"]
["T1H","Datum","Výrobek",null,"Množství:","Cena:"]
["T1FL","Datum","dddd",null,55,333]
["T1L","Datum","dddd",null,55,333]
["T1BL","Datum","dddd",null,55,333]
["T2H"]

{"sheet":"TISK_OBRAZKY","index":9,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":true,"merged":[[5,1,5,5],[6,1,6,5],[7,1,7,5],[8,1,8,5],[2,1,2,6]]}
[null,"C1","C2","C3","C4","C5","C6"]
["H0"]
["H0","V02"]
["H0"]
["T1H","Seznam propojených obrázků a dokumentů:"]
["T1H","Dokument (obrázek)",null,null,null,null,"Tisknout"]
["T1FL","Dok1",null,null,null,null,"dat"]
["T1L","Dok2",null,null,null,null,"dat"]
["T1BL","Dok3",null,null,null,null,"dat"]
["P1H"]
["P1FL","Připojené obrázky:"]