{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Navod k nastaveni aplikace","Pripojeni k iDokladu","Hlavní Přehled","Zákazníci","Faktury","Produkty","Plánování tržeb","Přehled DPH","DPH data","Vlastní Analýza","Intelligent Technologies","login","Roky a měsíce","SecureToken"],"not_rendered":{"charts":8,"images":10,"macros":1,"external_links":0,"defined_names":21,"comments":0,"pivot_tables":15},"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":"Navod k nastaveni aplikace","index":0,"n_rows":89,"n_cols":15,"rows_kept":89,"cut":false,"hidden":false,"merged":[[14,13,14,19],[5,10,5,12],[5,13,5,18]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Před prvním spuštěním je nutné:",null,null,"1) Stáhnout a nainstalovat Power Query"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2) Povolit Power Query v Excelu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3) Aktivovat možnost \"Rychle zkombinovat\" v Power Query"]
[null,"Vítejte v BI aplikaci iSmart pro Vaši fakturaci v iDokladu",null,null,null,null,null,null,null,null,null,null,null,"4) Potvrdit anonymní přístup k iDokladu"]
[]
[null,"Pro správné fungování této aplikace je nutné mít verzi Microsoft Excel 2013, která v sobě zahrnuje doplněk Power Pivot. Jedná se o verze Office 2013 Professional Plus, Office 365 Pro Plus a "]
[null,"samostatná verze Microsoft Excel 2013. "]
[null,"Aby byla Vaše data v pořádku dopravena do aplikace, je zapotřebí mít doinstalovaný volně dostupný a bezplatný doplňek od Microsoftu,",null,null,null,null,null,null,null,null,null,null,null,null,"Power Query."]
[null,"1) Stažení a nainstalování Power Query"]
[null,"Aplikace Vás sama vyzve k jeho stažení a nainstalování. Případně si doplněk můžete stáhnout na stránkách Microsoftu na adrese: ",null,null,null,null,null,null,null,null,null,null,null,"http://www.microsoft.com/cs-cz/download/details.aspx?id=39379"]
[null,"2) Povolení doplňku v aplikaci Excel"]
[null,"Po úspěšném stažení a nainstalování Power Query je nutné doplněk povolit přímo v aplikaci Excel. "]
[null,"Klikněte v pravém horním rohu na položku \"SOUBOR\", poté z nabídky vyberte položku \"Možnosti\" a přepněte se na záložku \"Doplňky\"."]
[null,"Otevře se Vám následující okno:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Ze seznamu vyberte možnost \"Doplňky modelu COM\" a klikněte na tlačítku \"Přejít…\""]
[null,"V okně zaškrtněte možnost \"Power Query pro Microsoft Excel\" a potvrďte tlačítkem \"OK\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Nyní je doplněk povolen a může být používán."]
[null,"3) Aktivování možnosti Rychle zkombinovat"]
[null,"Jakmile máte doplněk Power Query nainstalovaný, povolte funkci \"Rychle zkombinovat\" v kartě doplňku, která se za Vás postará o veškerá přístupová zabezpečení "]
[null,"do databáze iDokladu. Všechna data jsou zabezpečena na straně iDokladu."]
[]
[]
[]
[]
[]
[]
[]
[null,"4) Potvrzení anonymního přístupu k iDokladu"]
[null,"Při prvním přihlášení budete Excelem požádání o nastavení přístupu k iDokladu, nechte označenou volbu \"Anonymní přístup\" potvrďte tlačítkem Uložit"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Jakmile bude přihlášení úspěšné, objeví se dialogové okno, které potvrdí správnost Vámi zadaného jména a hesla a aplikace stáhne Vaše data z iDokladu. "]
[null,"Aktualizaci nejnovějších dat můžete vyvolat, pokud jste správně přihlášeni, kdykoliv."]
[]
[null,"Doporučujeme si po úspěšném přihlášení soubor uložit, abyste nemuseli po každém spuštění zadávat přihlašovací jméno a heslo."]
[]
[null,"V případě dotazů nebo dalších informací nás můžete kontaktovat na adrese ",null,null,null,null,null,null,"powerpivot@intecs.cz"]
[]
[null,"Tým Intelligent Technologies"]

{"sheet":"Pripojeni k iDokladu","index":1,"n_rows":200,"n_cols":9,"rows_kept":200,"cut":false,"hidden":false,"merged":[[7,7,7,15],[8,7,8,15],[7,3,7,5],[8,3,8,5],[1,1,3,14]]}
[]
[null,"BI aplikace iSmart"]
[]
[]
[null,null,null,null,null,null,null,"verze","1.1"]
[]
[null,null,null,null,null,null,null,"Zadejte váš e-mail..."]
[null,null,null,"Aktivní uživatel:",null,null,null,"powerpivot@intecs.cz (ukázková data)"]
[null,null,null,"Stav:",null,null,null,"Prihlášen, stací data jen aktualizovat"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1]

{"sheet":"Hlavní Přehled","index":2,"n_rows":1002,"n_cols":26,"rows_kept":1002,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"Nástroj Power View umožňuje pouze postupný tisk listů."]
[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,"Přejděte na požadovaný list a opakujte akci."]

{"sheet":"Zákazníci","index":3,"n_rows":62,"n_cols":9,"rows_kept":62,"cut":false,"hidden":false,"merged":[[0,0,3,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Společnost - datum ZP - faktura","Tržby"]
[null,"Ondrovy hodinky s.r.o.",90639]
[null,"KOSCOM HODINKY s.r.o.",85628]
[null,"Safe Trade s.r.o.",79791]
[null,"Easy Watches",75498]
[null,"iHodinky",71686]
[null,"ŽILKA HODINKY s.r.o.",67648]
[null,"Hoďky s.r.o.",48536]
[null,"LIVECAR, s.r.o.",41182]
[null,"Hodinářství HK",39070]
[null,"Miroslav Barnet",38556]
[null,"HELVETIA boutique",38358]
[null,"Pán hodinek",35019]
[null,"Jan Smrž",34760]
[null,"Top Time",34696]
[null,"Zlatnictví Sara",34324]
[null,"LABEMAN FAN s.r.o.",34258]
[null,"World Watches",32158,null,null,"Rok - měsíc","Zákazníků","Vracejících se","Nových zákazníků"]
[null,"Hodinkařiny s.r.o.",30896,null,null,2013,27,null,27]
[null,"Chronoshop",29130,null,null,2014,28,23,5]
[null,"Megastore s.r.o.",26879,null,null,"Celkový součet",32,32]
[null,"Hras",26140]
[null,"Hodinářství.cz s.r.o.",25478]
[null,"Hodinky Svět s.r.o.",21729]
[null,"TipShop s.r.o.",19868]
[null,"Hodinky watches",19406]
[null,"Náramky a hodinky a.s.",16859]
[null,"Klenoty OPLUŠTIL",14665]
[null,"Tomáš Vyskočil",8799]
[null,"Celkový součet",1121656]

{"sheet":"Faktury","index":4,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,1,3,11]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Rozsah roku","TRUE"]
[]
[null,"Rok - kvartál - měsíc","Tržby bez DPH","DPH","Tržby","Tržby minulý rok","Kumulované tržby","Kumulované tržby loni","Průměrně na 1 fakturu","Průměrně na zákazníka"]
[null,2013,1222512.8799999999,256810.12,1479323,null,1479323,null,24655.383333333335,54789.740740740737]
[null,"Q1 2013",397922.41,83590.59,481513,null,481513,null,22929.190476190477,25342.78947368421]
[null,"Q2 2013",186666.47,39212.53,225879,null,707392,null,18823.25,18823.25]
[null,"Q3 2013",241560.12,50743.88,292304,null,999696,null,24358.666666666668,24358.666666666668]
[null,"Q4 2013",396363.88,83263.12,479627,null,1479323,null,31975.133333333335,34259.071428571428]
[null,2014,926936.83,194719.17,1121656,1479323,1121656,1479323,29517.263157894737,40059.142857142855]
[null,"Q1 2014",301122.09000000003,63255.91,364378,481513,364378,481513,28029.076923076922,28029.076923076922]
[null,"Q2 2014",224555.27,47171.73,271727,225879,636105,707392,27172.7,30191.888888888891]
[null,"Q3 2014",252795,53104,305899,292304,942004,999696,30589.9,30589.9]
[null,"Q4 2014",148464.47,31187.53,179652,479627,1121656,1479323,35930.400000000001,35930.400000000001]
[null,"Celkový součet",2149449.71,451529.29,2600979,1479323,1121656,1479323,26540.602040816328,81280.59375]

{"sheet":"Produkty","index":5,"n_rows":60,"n_cols":11,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Typ položky","0"]
[]
[null,null,null,null,null,null,"Popis produktu","Počet KS","Tržby bez DPH","DPH","Tržby"]
[null,null,null,null,null,null,"Swatch Batman",16,12957.92,2722.08,15680]
[null,null,null,null,null,null,"Timex Ironman",15,15507.44,3257.56,18765]
[null,null,null,null,null,null,"Quiksilver Random",15,32093.25,6741.75,38835]
[null,null,null,null,null,null,"Esprit Classroom",14,13305.04,2794.96,16100]
[null,null,null,null,null,null,"Diesel DZ",14,85267.98,17912.02,103180]
[null,null,null,null,null,null,"Bentime",14,7867.31,1652.69,9520]
[null,null,null,null,null,null,"Casio G-shock",14,32279.24,6780.76,39060]
[null,null,null,null,null,null,"Casio Sport",14,19552.66,4107.34,23660]
[null,null,null,null,null,null,"Sigma Sporttester",13,16651.96,3498.04,20150]
[null,null,null,null,null,null,"Calvin Klein City",13,55327.48,11622.52,66950]
[null,null,null,null,null,null,"Boccia Titanium",13,23527.66,4942.34,28470]
[null,null,null,null,null,null,"Adidas Timing Response",13,10592.79,2225.21,12818]
[null,null,null,null,null,null,"Tommy Hilfiger White",13,52641.68,11058.32,63700]
[null,null,null,null,null,null,"Festina Retro",12,29651.27,6228.73,35880]
[null,null,null,null,null,null,"Casio Edifice",12,35601.35,7478.65,43080]
[null,null,null,null,null,null,"Casio Wave",12,24692.86,5187.1400000000003,29880]
[null,null,null,null,null,null,"Festina Chrono Dual Time",12,44526.47,9353.5300000000007,53880]
[null,null,null,null,null,null,"Festina Klasik",11,21726.1,4563.8999999999996,26290]
[null,null,null,null,null,null,"Roxy Dolphy",10,8834.2000000000007,1855.8,10690]
[null,null,null,null,null,null,"Wenger Field Classic",10,25535.79,5364.21,30900]
[null,null,null,null,null,null,"Timex Fly-Back",10,34138.6,7171.4,41310]
[null,null,null,null,null,null,"Festina Trend",10,24709.4,5190.6000000000004,29900]
[null,null,null,null,null,null,"Lorus RT",9,18541.96,3895.04,22437]
[null,null,null,null,null,null,"Suunto Vector",9,35618.67,7482.33,43101]
[null,null,null,null,null,null,"Casio Collection",9,14867.73,3123.27,17991]
[null,null,null,null,null,null,"Jacques Lemans Rome",9,20825.28,4374.72,25200]
[null,null,null,null,null,null,"Designhütte Space",8,19701.36,4138.6400000000003,23840]
[null,null,null,null,null,null,"Nextime Testpage",8,10571.28,2220.7199999999998,12792]
[null,null,null,null,null,null,"Wenger Commando",7,57842.19,12150.81,69993]
[null,null,null,null,null,null,"Police Dimension",7,19263.37,4046.63,23310]
[null,null,null,null,null,null,"Polar Fitness",7,15040.48,3159.52,18200]
[null,null,null,null,null,null,"Emporio Armani Classic",6,54537.42,11456.58,65994]
[null,null,null,null,null,null,"Police Python",6,34956.720000000001,7343.28,42300]
[null,null,null,null,null,null,"Celkový součet",365,928754.91,195101.09,1123856]

{"sheet":"Plánování tržeb","index":6,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Plánování tržeb"]
[null,"Pro plánování tržeb zadejte požadované údaje do následující tabulky a klikněte na tlačítko \"Aktualizovat plán\""]
[]
[]
[null,"Rok","Měsíc","Plánované tržby"]
[null,2014,1,150000]
[null,2014,2,110000]
[null,2014,3,110000]
[null,2014,4,100000]
[null,2014,5,100000]
[null,2014,6,90000]
[null,2014,7,120000]
[null,2014,8,100000]
[null,2014,9,115000]
[null,2014,10,100000]
[null,2014,11,130000]
[null,2014,12,170000]

{"sheet":"Přehled DPH","index":7,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[[24,1,25,3],[26,1,27,3],[24,4,25,8],[26,4,27,8],[24,10,25,12],[24,13,25,15],[24,16,25,18],[26,10,27,12],[26,13,27,15],[26,16,27,18],[29,1,29,3],[29,10,30,12],[29,13,30,15],[29,16,30,18],[31,10,32,12],[31,13,32,15],[31,16,32,18]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Informace pro neplátce DPH",null,null,null,null,null,null,null,null,"Informace pro plátce DPH"]
[null,null,null,null,null,null,null,null,null,null,"Fakturováno DPH"]
[null,"Obrat za posledních 12 měsíců",null,null,"Povolený obrat tento měsíc, abych nebyl plátcem",null,null,null,null,null,"Tento měsíc",null,null,"Tento kvartál",null,null,"Tento rok"]
[]
[null,{"$f":"'DPH data'!I5","v":1480629},null,null,{"$f":"'DPH data'!J5","v":0},null,null,null,null,null,{"$f":"'DPH data'!C5","v":6693.3},null,null,{"$f":"'DPH data'!D5","v":31187.53},null,null,{"$f":"'DPH data'!E5","v":194719.16999999998}]
[]
[]
[null,"Povinnost platit DPH:",null,null,{"$f":"'DPH data'!K5","v":"Ano"},null,null,null,null,null,"Minulý měsíc",null,null,"Minulý kvartál",null,null,"Minulý rok"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'DPH data'!F5","v":24494.23},null,null,{"$f":"'DPH data'!G5","v":53104},null,null,{"$f":"'DPH data'!H5","v":256810.11999999994}]

{"sheet":"DPH data","index":8,"n_rows":6,"n_cols":11,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Popisky řádků","DPH tento měsíc","DPH tento kvartál","DPH tento rok","DPH minulý měsíc","DPH minulý kvartál","DPH minulý rok","Tržby za poslední rok","Povolený obrat","Plátce DPH"]
[null,"2014-11-04",6693.3,31187.53,194719.16999999998,24494.23,53104,256810.11999999994,1480629,0,"Ano"]
[null,"Celkový součet",6693.3,31187.53,194719.17,24494.23,53104,256810.12]

{"sheet":"Vlastní Analýza","index":9,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"V tomto si můžete vytvořit vlastní analýzu dat podle vašich potřeb, vše funguje jako standardní kontingenční tabulka."]
[]
[null,"Popisky řádků","Tržby","Tržby bez DPH"]
[null,"Chronoshop",29130,24073.040000000001]
[null,"Easy Watches",75498,62391.56]
[null,"HELVETIA boutique",38358,31699.05]
[null,"Hodinářství HK",39070,32287.46]
[null,"Hodinářství.cz s.r.o.",25478,21055.03]
[null,"Hodinkařiny s.r.o.",30896,25532.47]
[null,"Hodinky Svět s.r.o.",21729,17956.84]
[null,"Hodinky watches",19406,16037.13]
[null,"Hoďky s.r.o.",48536,40110.19]
[null,"Hras",26140,21602.12]
[null,"iHodinky",71686,59241.33]
[null,"Jan Smrž",34760,28725.67]
[null,"Klenoty OPLUŠTIL",14665,12119.16]
[null,"KOSCOM HODINKY s.r.o.",85628,70763]
[null,"LABEMAN FAN s.r.o.",34258,28310.82]
[null,"LIVECAR, s.r.o.",41182,34032.81]
[null,"Megastore s.r.o.",26879,22212.81]
[null,"Miroslav Barnet",38556,31862.7]
[null,"Náramky a hodinky a.s.",16859,13932.29]
[null,"Ondrovy hodinky s.r.o.",90639,74904.100000000006]
[null,"Pán hodinek",35019,28939.71]
[null,"Safe Trade s.r.o.",79791,65939.289999999994]
[null,"TipShop s.r.o.",19868,16418.91]
[null,"Tomáš Vyskočil",8799,7271.49]
[null,"Top Time",34696,28672.79]
[null,"World Watches",32158,26575.37]
[null,"ŽILKA HODINKY s.r.o.",67648,55904.33]
[null,"Zlatnictví Sara",34324,28365.360000000001]
[null,"Celkový součet",1121656,926936.83]

{"sheet":"Intelligent Technologies","index":10,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":false,"merged":[[5,1,8,18],[0,7,3,19],[11,11,11,18],[61,1,61,7],[32,11,32,13],[32,15,32,17],[11,1,11,8],[12,1,21,8],[12,11,21,18],[23,1,23,8],[23,11,23,18],[24,1,31,8],[24,11,30,18]]}
[null,null,null,null,null,null,null,"Vítejte v Intelligent Technologies"]
[]
[]
[]
[]
[null,"Česká konzultační a vývojářská společnost Intelligent Technologies pomáhá svým klientům dělat lepší rozhodnutí. Společnost implementuje a dodává řešení v oblasti business intelligence a data warehousingu."]
[]
[]
[]
[]
[]
[null,"Realizované projekty",null,null,null,null,null,null,null,null,null,"Specializace"]
[null,"Realizovali jsme řadu projektů u různých zákazníků, od malých a středních společností až po velké mezinárodní koncerny. Umíme projekty dotáhnout do úspěšného konce (naplnění očekávání klienta) a překonávat různé implementační překážky. Společnost Intelligent Technologies je Microsoft Silver Certified Partner v kompetenci Business Intelligence. Specialisté, kteří se věnují projektům našich zákazníků jsou profesionálové s dosaženou úrovní expertizy MCP, MCTS, MCDBA a MCSD. Naše špičkové know-how ocenili také naši zahraničtí klienti s nimiž již řadu let spolupracujeme.",null,null,null,null,null,null,null,null,null,"Specializujeme se na projekty v oblasti datových skladů (DWH), Business Intelligence, reportingu a manažerských informačních systémů. Máme zkušenosti s tím, co je třeba vyvinout a dodat pro úspěšné dokončení úkolu k plné spokojenosti zadavatele. Řešení implementujeme na Microsoft platformě, jejíž silné stránky známe opravdu dokonale. Dbáme na pravidelné školení zaměstnanců a jsme vždy o krok před konkurencí. Jsme Microsoft Silver Certified Partner s kompetencí Business Intelligence. To nám dává přístup k novým technologiím, možnost podílet se na vývoji produktů a také zdroj nejnovějších technických informací."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Transparentnost",null,null,null,null,null,null,null,null,null,"Osobní přístup"]
[null,"Svým klientům neustále předáváme maximum informací. Vysvětlujeme metodologii použitou pro daný projekt, předáváme kvalitní dokumentaci, zaškolujeme technické pracovníky klientů tak, aby byli kdykoliv schopni sami převzít a řídit projekt. Neexistují omezující smluvní ustanovení, tajná nastavení či neochota vysvětlit nebo přizpůsobit zvolené řešení. Naši klienti jsou opravdovými vlastníky realizovaných projektů.",null,null,null,null,null,null,null,null,null,"Ke všem našim klientům máme více než profesionální přístup. Jejich úspěch je i náš úspěch, proto jsme pro ně vždy k dispozici, případný naléhavý úkol řešíme bezodkladně a do jeho vyřešení. Jsme rádi, že se na nás naši klienti mohou spolehnout. Naše práce nás baví."]
[]
[]
[]
[]
[]
[]
[]
[null,"Pro více informací o našich projektech a zákaznících navštivte naše stránky",null,null,null,null,null,null,null,null,null,"www.powerpivot.cz",null,null,"nebo","www.intecs.cz"]
[]
[null,"Tým Intelligent Technologies"]

{"sheet":"login","index":11,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["jmeno","heslo"]

{"sheet":"Roky a měsíce","index":12,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[]
[null,2014,1]
[null,2015,2]
[null,2016,3]
[null,2017,4]
[null,2018,5]
[null,2019,6]
[null,2020,7]
[null,null,8]
[null,null,9]
[null,null,10]
[null,null,11]
[null,null,12]

{"sheet":"SecureToken","index":13,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Value"]
["9aeafb5ee31b6ba4c9fded6ebfdce9979e445b1000456b6fc72d7cbb55ce3687"]
[]
[{"$f":"A2","v":"9aeafb5ee31b6ba4c9fded6ebfdce9979e445b1000456b6fc72d7cbb55ce3687"},1]