{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["lFunkce","lFormátování","lAdresace","lStavebniny","lStavebObch","lStavebPodmFmt","lDataSeskHwd","lDataSeskupitHwd","lSeskHwd","lMirek","lKarel","lPetr","lStavebSloucene","lDataAutPrehledPetr","lAutPrehledPetr","lVydaje","lDruhy","lObchody"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"lFunkce","index":0,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["PRIJMENI","JMENO","POHL","NAROZEN","VEK","TARIF_HOD","POHLAVÍ"]
["Foretník","Vadim","M","1996-01-08",{"$f":"(TODAY()-D2)/365.25","v":29.349760438056126},158,{"$f":"IF(C2=\"M\",\"Mužské\",\"Ženské\")","v":"Mužské"}]
["Hofbrucker","Adrian","M","1986-12-06",{"$f":"(TODAY()-D3)/365.25","v":38.439425051334702},196,{"$f":"IF(C3=\"M\",\"Mužské\",\"Ženské\")","v":"Mužské"}]
["Hubačová","Adriana","Z","1981-04-29",44.043805612594113,215,"Ženské"]
["Klusová","Jitka","Z","1957-08-24",67.723477070499655,238,"Ženské"]
["Kovalčík","Sebastián","M","1963-05-17",61.995893223819301,240,"Mužské"]
["Kryštofovič","Leo","M","1970-01-15",55.329226557152637,236,"Mužské"]
["Kyllarová","Danuše","Z","1966-06-02",58.951403148528406,238,"Ženské"]
["Mahdalík","Vítězslav","M","1957-06-06",67.939767282683093,238,"Mužské"]
["Navrátil","Luděk","M","1950-04-29",75.044490075290895,"Nenastoupil","Mužské"]
["Nullová","Miloslava","Z","1981-03-29",44.128678986995212,215,"Ženské"]
["Pabiš","Arnold","M","1982-02-15",43.244353182751539,212,"Mužské"]
["Paříková","Božena","Z","1965-04-28",60.046543463381248,239,"Ženské"]
["Pištěk","Svatoslav","M","1946-05-30",78.959616700889796,132,"Mužské"]
["Šalman","Vladislav","M","1982-08-10",42.762491444216288,210,"Mužské"]
["Smetáková","Nora","Z","1961-06-22",63.89596167008898,239,"Ženské"]
["Srpová","Jiřina","Z","1981-11-19",43.485284052019168,212,"Ženské"]
["Stránská","Oldřiška","Z","1948-12-31",76.369609856262841,131,"Ženské"]
["Tabányi","Veleslav","M","1978-03-31",47.123887748117724,223,"Mužské"]
["Vaisar","Ryan","M","1962-11-25",62.469541409993155,240,"Mužské"]
["Valčíková","Erlína","Z","1982-03-30",43.126625598904859,212,"Ženské"]
[]
[]
["SumIf Muži",null,null,null,null,{"$f":"SUMIF(C2:C21,\"M\",F2:F21)","v":2085}]
["Sum s nečís.hodnotou",null,null,null,null,{"$f":"SUM(F2:F21)","v":4024}]
["Sum starší než 40",null,null,null,null,{"$f":"\"???\"","v":"???"}]
[]
[]
["FCE KDYŽ (C12=\"M\"; Yes; No)"]

{"sheet":"lFormátování","index":1,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Převod z 2024","2024-12-31",27000,27000]
["Mzda","2025-01-12",28000,55000]
["Odměny","2025-01-12",2800,57800,{"$f":"\"[zelená]# ##0,00 Kč;[Červená]-# ##0,00 Kč\"","v":"[zelená]# ##0,00 Kč;[Červená]-# ##0,00 Kč"}]
["Nájem","2025-01-15",-14000,43800,{"$f":"\"[zelená]# ##0,00 Kč;[Červená]-# ##0,00 Kč\"","v":"[zelená]# ##0,00 Kč;[Červená]-# ##0,00 Kč"},{"$f":"\"   \"","v":"   "}]
["Benzin","2025-01-17",-1200,42600]
["Potraviny","2025-01-31",-12000,30600]
["Mzda","2025-02-12",28000,58600]
[]
[]
["Sekce formátu:"]
["S1","S2","S3","S4"]
["Kladná","Záporná","Nula","Text","Text - dle formátu"]
["Kladná","Záporná","Nula",null,"Text - všechny jeho znaky"]
["Kladná nebo nula","Záporná"]
["Jen jedna sekce",null,null,null,"Dle formátu"]

{"sheet":"lAdresace","index":2,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[8,4,8,5]]}
["PRIJMENI","JMENO","POHL","NAROZEN","VEK","TARIF_HOD",null,"PRIJMENI","JMENO","POHL","NAROZEN","VEK","TARIF_HOD"]
["Foretník","Vadim","M","1996-01-08",29,100,null,"Hubačová","Adriana","Z","1981-04-29",44,150]
["Hofbrucker","Adrian","M","1986-12-06",38,100,null,"Klusová","Jitka","Z","1957-08-24",67,150]
["Kovalčík","Sebastián","M","1963-05-17",61,"alfa",null,"Kyllarová","Danuše","Z","1966-06-02",58,"beta"]
["Kryštofovič","Leo","M","1970-01-15",55,100]
["Mahdalík","Vítězslav","M","1957-06-06",67,100]
[]
["Nespojité oblasti F2:F6 ; M2:M4",null,null,null,null,{"$f":"SUM(F2:F6,M2:M4)","v":700}]
[null,null,null,null,{"$f":"\"SUMA(F2:F6;M2:M4)\"","v":"SUMA(F2:F6;M2:M4)"}]

{"sheet":"lStavebniny","index":3,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["JMENO","ZBOZI","NAKOUPENO","CENA"]
["Petr","Cihly","2020-10-26",300]
["Karel","Malta","2020-03-10",800]
["Mirek","Písek","2020-07-18",200]
["Petr","Cihly","2020-04-09",100]
["Karel","Písek","2020-02-04",400]
["Petr","Malta","2020-03-10",800]
["Petr","Malta","2020-05-14",500]
["Karel","Písek","2020-06-18",900]
["Mirek","Cihly","2020-04-09",100]
["Mirek","Písek","2020-05-14",500]
["Petr","Malta","2020-08-22",600]
["Karel","Písek","2020-06-18",900]
["Mirek","Cihly","2020-05-14",500]
["Petr","Cihly","2020-11-30",700]
["Mirek","Malta","2020-05-14",500]
["Petr","Písek","2020-04-09",100]
["Mirek","Malta","2020-10-26",300]
["Mirek","Písek","2020-11-30",700]
["Mirek","Cihly","2020-07-18",200]
["Petr","Malta","2020-02-04",400]
["Karel","Cihly","2020-02-04",400]
["Mirek","Písek","2020-04-09",100]
["Petr","Písek","2020-11-30",700]
["Mirek","Cihly","2020-02-04",400]
["Karel","Malta","2020-05-14",500]
["Mirek","Malta","2020-05-14",500]
["Petr","Cihly","2020-10-26",300]
["Karel","Písek","2020-07-18",200]

{"sheet":"lStavebObch","index":4,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["JMENO","ZBOZI","OBCHOD","LEDEN","UNOR","BREZEN"]
["Pavel","Pisek","Hornbach",276,204,174]
["Petr","Pisek","Hornbach",274,184,267]
["Pavel","Malta","Hornbach",134,130,134]
["Mirek","Pisek","Baumax",194,246,210]
["Pavel","Cihly","Baumax",256,102,243]
["Mirek","Pisek","Baumax",269,204,239]
["Petr","Cihly","Baumax",190,119,294]
["Pavel","Pisek","Hornbach",207,279,245]
["Petr","Malta","Hornbach",171,130,228]
["Pavel","Pisek","Hornbach",217,230,280]
["Petr","Malta","Hornbach",110,115,227]
["Pavel","Cihly","Baumax",249,108,203]
["Petr","Cihly","Baumax",122,180,124]
["Mirek","Cihly","Baumax",212,161,133]
["Mirek","Pisek","Baumax",276,256,241]
["Petr","Malta","Hornbach",206,142,256]
["Pavel","Malta","Hornbach",265,288,258]
["Petr","Malta","Hornbach",131,118,136]
["Pavel","Malta","Hornbach",112,214,251]
["Mirek","Cihly","Baumax",284,185,257]
["Petr","Pisek","Baumax",234,156,132]
["Petr","Cihly","Baumax",133,271,133]
["Mirek","Cihly","Baumax",177,118,267]
["Pavel","Malta","Hornbach",126,288,140]

{"sheet":"lStavebPodmFmt","index":5,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["JMENO","ZBOZI","OBCHOD","LEDEN","UNOR","BREZEN"]
["Pavel","Pisek","Hornbach",276,204,174]
["Petr","Pisek","Hornbach",274,184,267]
["Pavel","Malta","Hornbach",134,130,134]
["Mirek","Pisek","Baumax",194,246,210]
["Pavel","Cihly","Baumax",256,102,243]
["Mirek","Pisek","Baumax",269,204,239]
["Petr","Cihly","Baumax",190,119,294]
["Pavel","Pisek","Hornbach",207,279,245]
["Petr","Malta","Hornbach",171,130,228]
["Pavel","Pisek","Hornbach",217,230,280]
["Petr","Malta","Hornbach",110,115,227]
["Pavel","Cihly","Baumax",249,108,203]
["Petr","Cihly","Baumax",122,180,124]
["Mirek","Cihly","Baumax",212,161,133]
["Mirek","Pisek","Baumax",276,256,241]
["Petr","Malta","Hornbach",206,142,256]
["Pavel","Malta","Hornbach",265,288,258]
["Petr","Malta","Hornbach",131,118,136]
["Pavel","Malta","Hornbach",112,214,251]
["Mirek","Cihly","Baumax",284,185,257]
["Petr","Pisek","Baumax",234,156,132]
["Petr","Cihly","Baumax",133,271,133]
["Mirek","Cihly","Baumax",177,118,267]
["Pavel","Malta","Hornbach",126,288,140]
[]
["pod Prům-25",null,null,{"$f":"PrumLeden-25","v":176.04166666666666}]
["Průměr",null,null,{"$f":"AVERAGE(D2:D25)","v":201.04166666666666},{"$f":"AVERAGE(E2:E25)","v":184.5},211.33333333333334]
["Nad Prům+25",null,null,{"$f":"PrumLeden+25","v":226.04166666666666}]

{"sheet":"lDataSeskHwd","index":6,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,11,37,11],[5,9,28,9],[6,7,7,7],[13,7,22,7],[20,5,22,5],[32,7,33,7]]}
[null,"Disky"]
[null,null,"externí"]
[]
[null,null,"interní"]
[]
[null,"Monitory"]
[null,null,"klasické CRT"]
[]
[null,null,"LCD 3:4"]
[null,null,null,"17\""]
[null,null,null,null,"Acer V173DOb 17\" "]
[null,null,null,"19\""]
[null,null,null,null,"Acer V193DObmd"]
[null,null,"LCD širokoúhlé"]
[null,null,null,"19\""]
[null,null,null,null,"AOC E950Swda"]
[null,null,null,"20\""]
[null,null,null,null,"Fujitsu L20T-3 LED"]
[null,null,null,"22\""]
[null,null,null,null,"BenQ G2225HD"]
[null,null,null,"24\""]
[null,null,null,null,"Philips 246EL2SBH"]
[null,null,null,null,"Philips 273V"]
[null,null,"LCD dotykové"]
[null,null,null,"19\""]
[null,null,null,null,"LG T1910B-BN černý 19\" dotykový"]
[null,null,"LCD s TV"]
[null,null,null,"24\""]
[null,null,null,null,"Samsung P2470LHD 24\" s MPEG-4 TV tunerem"]
[null,"Paměti"]
[null,null,"DIMM"]
[]
[null,null,"SO-DIMM pro notebooky"]
[]
[null,null,"Flash disky"]
[]
[null,null,"Paměťové karty"]

{"sheet":"lDataSeskupitHwd","index":7,"n_rows":37,"n_cols":4,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Disky"]
[null,"externí"]
[]
[null,"interní"]
[]
["Monitory"]
[null,"klasické CRT"]
[]
[null,"LCD 3:4"]
[null,null,"17\""]
[null,null,null,"Acer V173DOb 17\" "]
[null,null,"19\""]
[null,null,null,"Acer V193DObmd"]
[null,"LCD širokoúhlé"]
[null,null,"19\""]
[null,null,null,"AOC E950Swda"]
[null,null,"20\""]
[null,null,null,"Fujitsu L20T-3 LED"]
[null,null,"22\""]
[null,null,null,"BenQ G2225HD"]
[null,null,"24\""]
[null,null,null,"Philips 246EL2SBH"]
[null,null,null,"Philips 273V"]
[null,"LCD dotykové"]
[null,null,"19\""]
[null,null,null,"LG T1910B-BN černý 19\" dotykový"]
[null,"LCD s TV"]
[null,null,"24\""]
[null,null,null,"Samsung P2470LHD 24\" s MPEG-4 TV tunerem"]
["Paměti"]
[null,"DIMM"]
[]
[null,"SO-DIMM pro notebooky"]
[]
[null,"Flash disky"]
[]
[null,"Paměťové karty"]

{"sheet":"lSeskHwd","index":8,"n_rows":37,"n_cols":4,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Disky"]
[null,"externí"]
[]
[null,"interní"]
[]
["Monitory"]
[null,"klasické CRT"]
[]
[null,"LCD 3:4"]
[null,null,"17\""]
[null,null,null,"Acer V173DOb 17\" "]
[null,null,"19\""]
[null,null,null,"Acer V193DObmd"]
[null,"LCD širokoúhlé"]
[null,null,"19\""]
[null,null,null,"AOC E950Swda"]
[null,null,"20\""]
[null,null,null,"Fujitsu L20T-3 LED"]
[null,null,"22\""]
[null,null,null,"BenQ G2225HD"]
[null,null,"24\""]
[null,null,null,"Philips 246EL2SBH"]
[null,null,null,"Philips 273V"]
[null,"LCD dotykové"]
[null,null,"19\""]
[null,null,null,"LG T1910B-BN černý 19\" dotykový"]
[null,"LCD s TV"]
[null,null,"24\""]
[null,null,null,"Samsung P2470LHD 24\" s MPEG-4 TV tunerem"]
["Paměti"]
[null,"DIMM"]
[]
[null,"SO-DIMM pro notebooky"]
[]
[null,"Flash disky"]
[]
[null,"Paměťové karty"]

{"sheet":"lMirek","index":9,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Mirek","Praha","Teplice","Most","Bílina"]
["Cihly",7,2,2,8]
["Písek",3,4,4,9]
["Tvárnice",4,9,6,7]

{"sheet":"lKarel","index":10,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Karel","Ústí","Chomutov","Most"]
["Malta",9,5,2]
["Cihly",2,3,6]
["Písek",1,3,6]

{"sheet":"lPetr","index":11,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Petr","Praha","Most","Chomutov"]
["Cihly",6,4,1]
["Malta",3,6,9]
["Písek",6,4,8]
["Štěrk",9,5,1]

{"sheet":"lStavebSloucene","index":12,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Ústí","Chomutov","Praha","Teplice","Most","Bílina"]
[null,"Vyuka",{"$f":"lKarel!$B$2","v":9},{"$f":"lKarel!$C$2","v":5},null,null,{"$f":"lKarel!$D$2","v":2}]
[null,"Vyuka",null,{"$f":"lPetr!$D$3","v":9},{"$f":"lPetr!$B$3","v":3},null,{"$f":"lPetr!$C$3","v":6}]
["Malta",null,{"$f":"SUM(C3:C4)","v":9},{"$f":"SUM(D3:D4)","v":14},{"$f":"SUM(E3:E4)","v":3},null,{"$f":"SUM(G3:G4)","v":8}]
[null,"Vyuka",{"$f":"lKarel!$B$3","v":2},{"$f":"lKarel!$C$3","v":3},null,null,{"$f":"lKarel!$D$3","v":6}]
[null,"Vyuka",null,null,{"$f":"lMirek!$B$2","v":7},{"$f":"lMirek!$C$2","v":2},{"$f":"lMirek!$D$2","v":2},{"$f":"lMirek!$E$2","v":8}]
[null,"Vyuka",null,{"$f":"lPetr!$D$2","v":1},{"$f":"lPetr!$B$2","v":6},null,{"$f":"lPetr!$C$2","v":4}]
["Cihly",null,{"$f":"SUM(C6:C8)","v":2},4,13,2,12,8]
[null,"Vyuka",{"$f":"lKarel!$B$4","v":1},{"$f":"lKarel!$C$4","v":3},null,null,{"$f":"lKarel!$D$4","v":6}]
[null,"Vyuka",null,null,{"$f":"lMirek!$B$3","v":3},{"$f":"lMirek!$C$3","v":4},{"$f":"lMirek!$D$3","v":4},{"$f":"lMirek!$E$3","v":9}]
[null,"Vyuka",null,{"$f":"lPetr!$D$4","v":8},{"$f":"lPetr!$B$4","v":6},null,{"$f":"lPetr!$C$4","v":4}]
["Písek",null,{"$f":"SUM(C10:C12)","v":1},11,9,4,14,9]
[null,"Vyuka",null,null,{"$f":"lMirek!$B$4","v":4},{"$f":"lMirek!$C$4","v":9},{"$f":"lMirek!$D$4","v":6},{"$f":"lMirek!$E$4","v":7}]
["Tvárnice",null,null,null,{"$f":"SUM(E14)","v":4},{"$f":"SUM(F14)","v":9},{"$f":"SUM(G14)","v":6},{"$f":"SUM(H14)","v":7}]
[null,"Vyuka",null,{"$f":"lPetr!$D$5","v":1},{"$f":"lPetr!$B$5","v":9},null,{"$f":"lPetr!$C$5","v":5}]
["Štěrk",null,null,{"$f":"SUM(D16)","v":1},{"$f":"SUM(E16)","v":9},null,{"$f":"SUM(G16)","v":5}]
[]
[]
[]
[]
[null,"Petr","Praha","Most","Chomutov"]
[null,"Cihly",6,4,1]
[null,"Malta",3,6,9]
[null,"Písek",6,4,8]
[null,"Štěrk",9,5,1]
[]
[]
[null,"Karel","Ústí","Chomutov","Most"]
[null,"Malta",9,5,2]
[null,"Cihly",2,3,6]
[null,"Písek",1,3,6]
[]
[]
[null,"Mirek","Praha","Teplice","Most","Bílina"]
[null,"Cihly",7,2,2,8]
[null,"Písek",3,4,4,9]
[null,"Tvárnice",4,9,6,7]

{"sheet":"lDataAutPrehledPetr","index":13,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,"projejna1",null,null,null,"prodejna2",null,null,null,"prodejna3",null,null,null,"celkem"]
[null,"leden","únor","březen","I.Q","leden","únor","březen","I.Q","leden","únor","březen","I.Q","I.Q"]
["chléb",2,3,4,{"$f":"SUM(B3:D3)","v":9},3,4,5,{"$f":"SUM(F3:H3)","v":12},3,4,5,{"$f":"SUM(J3:L3)","v":12},{"$f":"E3+I3+M3","v":33}]
["mouka",2,3,4,{"$f":"SUM(B4:D4)","v":9},3,2,1,{"$f":"SUM(F4:H4)","v":6},2,3,4,{"$f":"SUM(J4:L4)","v":9},{"$f":"E4+I4+M4","v":24}]
["káva",3,3,3,9,4,3,2,9,3,5,7,15,33]
["potraviny celkem",{"$f":"SUM(B3:B5)","v":7},{"$f":"SUM(C3:C5)","v":9},{"$f":"SUM(D3:D5)","v":11},27,{"$f":"SUM(F3:F5)","v":10},{"$f":"SUM(G3:G5)","v":9},{"$f":"SUM(H3:H5)","v":8},27,{"$f":"SUM(J3:J5)","v":8},{"$f":"SUM(K3:K5)","v":12},{"$f":"SUM(L3:L5)","v":16},36,90]
["šroubky",4,5,6,15,3,2,1,6,5,4,3,12,33]
["matky",4,0,3,7,6,5,4,15,6,7,8,21,43]
["podložky",3,4,5,12,4,5,6,15,4,3,2,9,36]
["kovo celkem",{"$f":"SUM(B7:B9)","v":11},{"$f":"SUM(C7:C9)","v":9},{"$f":"SUM(D7:D9)","v":14},34,{"$f":"SUM(F7:F9)","v":13},{"$f":"SUM(G7:G9)","v":12},{"$f":"SUM(H7:H9)","v":11},36,{"$f":"SUM(J7:J9)","v":15},{"$f":"SUM(K7:K9)","v":14},{"$f":"SUM(L7:L9)","v":13},42,112]
["prodejna celkem",{"$f":"B6+B10","v":18},{"$f":"C6+C10","v":18},25,61,23,21,19,63,23,26,29,78,202]

{"sheet":"lAutPrehledPetr","index":14,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,"projejna1",null,null,null,"prodejna2",null,null,null,"prodejna3",null,null,null,"celkem"]
[null,"leden","únor","březen","I.Q","leden","únor","březen","I.Q","leden","únor","březen","I.Q","I.Q"]
["chléb",2,3,4,{"$f":"SUM(B3:D3)","v":9},3,4,5,{"$f":"SUM(F3:H3)","v":12},3,4,5,{"$f":"SUM(J3:L3)","v":12},{"$f":"E3+I3+M3","v":33}]
["mouka",2,3,4,{"$f":"SUM(B4:D4)","v":9},3,2,1,{"$f":"SUM(F4:H4)","v":6},2,3,4,{"$f":"SUM(J4:L4)","v":9},{"$f":"E4+I4+M4","v":24}]
["káva",3,3,3,9,4,3,2,9,3,5,7,15,33]
["potraviny celkem",{"$f":"SUM(B3:B5)","v":7},{"$f":"SUM(C3:C5)","v":9},{"$f":"SUM(D3:D5)","v":11},27,{"$f":"SUM(F3:F5)","v":10},{"$f":"SUM(G3:G5)","v":9},{"$f":"SUM(H3:H5)","v":8},27,{"$f":"SUM(J3:J5)","v":8},{"$f":"SUM(K3:K5)","v":12},{"$f":"SUM(L3:L5)","v":16},36,90]
["šroubky",4,5,6,15,3,2,1,6,5,4,3,12,33]
["matky",4,0,3,7,6,5,4,15,6,7,8,21,43]
["podložky",3,4,5,12,4,5,6,15,4,3,2,9,36]
["kovo celkem",{"$f":"SUM(B7:B9)","v":11},{"$f":"SUM(C7:C9)","v":9},{"$f":"SUM(D7:D9)","v":14},34,{"$f":"SUM(F7:F9)","v":13},{"$f":"SUM(G7:G9)","v":12},{"$f":"SUM(H7:H9)","v":11},36,{"$f":"SUM(J7:J9)","v":15},{"$f":"SUM(K7:K9)","v":14},{"$f":"SUM(L7:L9)","v":13},42,112]
["prodejna celkem",{"$f":"B6+B10","v":18},{"$f":"C6+C10","v":18},25,61,23,21,19,63,23,26,29,78,202]

{"sheet":"lVydaje","index":15,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["DATUM","KC","CO","MNOZSTVI","JEDNOTKA","DRUH","OBCHOD","JEDCENA","NAZ_DRUHU","NAZ_OBCH"]
["2021-01-05",15,"Chléb normální",0.6,"kg","CH","T",null,{"$f":"VLOOKUP(F2,lDruhy!$A$1:$C$18,2,FALSE)","v":"Chléb, pečivo"},{"$f":"VLOOKUP(G2,lObchody!$A$1:$D$5,2,FALSE)","v":"Tesco"}]
["2021-01-05",19,"Rohlíky",10,"ks","CH","T",null,{"$f":"VLOOKUP(F3,lDruhy!$A$1:$C$18,2,FALSE)","v":"Chléb, pečivo"},{"$f":"VLOOKUP(G3,lObchody!$A$1:$D$5,2,FALSE)","v":"Tesco"}]
["2021-01-05",41,"Máslo",0.25,"kg","TU","T",null,{"$f":"VLOOKUP(F4,lDruhy!$A$1:$C$18,2,FALSE)","v":"Tuky"},{"$f":"VLOOKUP(G4,lObchody!$A$1:$D$5,2,FALSE)","v":"Tesco"}]
["2021-01-05",50,"Kapucino",0.14299999999999999,"kg","KA","T",null,{"$f":"VLOOKUP(F5,lDruhy!$A$1:$C$18,2,FALSE)","v":"Káva, čaj"},{"$f":"VLOOKUP(G5,lObchody!$A$1:$D$5,2,FALSE)","v":"Tesco"}]
["2021-01-06",129,"Bohemia Brut",0.75,"l","AL","A",null,{"$f":"VLOOKUP(F6,lDruhy!$A$1:$C$18,2,FALSE)","v":"Alkoholické nápoje"},{"$f":"VLOOKUP(G6,lObchody!$A$1:$D$5,2,FALSE)","v":"Albert"}]
["2021-01-06",11.4,"Rohlíky",6,"ks","CH","A",null,{"$f":"VLOOKUP(F7,lDruhy!$A$1:$C$18,2,FALSE)","v":"Chléb, pečivo"},{"$f":"VLOOKUP(G7,lObchody!$A$1:$D$5,2,FALSE)","v":"Albert"}]
["2021-01-06",16.399999999999999,"Rajčata",0.222,"kg","ZE","A",null,{"$f":"VLOOKUP(F8,lDruhy!$A$1:$C$18,2,FALSE)","v":"Zelenina"},{"$f":"VLOOKUP(G8,lObchody!$A$1:$D$5,2,FALSE)","v":"Albert"}]
["2021-01-07",9,"Řezy z matjesa",0.04,"kg","RD","T",null,{"$f":"VLOOKUP(F9,lDruhy!$A$1:$C$18,2,FALSE)","v":"Ryby, drůbež, zvěřina"},{"$f":"VLOOKUP(G9,lObchody!$A$1:$D$5,2,FALSE)","v":"Tesco"}]
["2021-01-07",33.799999999999997,"Hermelín",0.12,"kg","ML","T",null,{"$f":"VLOOKUP(F10,lDruhy!$A$1:$C$18,2,FALSE)","v":"Mléko, mléčné výrobky"},{"$f":"VLOOKUP(G10,lObchody!$A$1:$D$5,2,FALSE)","v":"Tesco"}]
["2021-01-07",22.9,"Jogurt",0.5,"kg","ML","T",null,{"$f":"VLOOKUP(F11,lDruhy!$A$1:$C$18,2,FALSE)","v":"Mléko, mléčné výrobky"},{"$f":"VLOOKUP(G11,lObchody!$A$1:$D$5,2,FALSE)","v":"Tesco"}]
["2021-01-07",71.599999999999994,"Relax pomer.",2,"l","NN","T",null,{"$f":"VLOOKUP(F12,lDruhy!$A$1:$C$18,2,FALSE)","v":"Nealkoholické nápoje"},{"$f":"VLOOKUP(G12,lObchody!$A$1:$D$5,2,FALSE)","v":"Tesco"}]
["2021-01-07",14.9,"Mattoni",1.5,"l","NN","K",null,{"$f":"VLOOKUP(F13,lDruhy!$A$1:$C$18,2,FALSE)","v":"Nealkoholické nápoje"},{"$f":"VLOOKUP(G13,lObchody!$A$1:$D$5,2,FALSE)","v":"Kaufland"}]
["2021-01-07",21,"Pomer. Džus",1.5,"l","NN","T",null,{"$f":"VLOOKUP(F14,lDruhy!$A$1:$C$18,2,FALSE)","v":"Nealkoholické nápoje"},{"$f":"VLOOKUP(G14,lObchody!$A$1:$D$5,2,FALSE)","v":"Tesco"}]
["2021-01-07",19.8,"Vlašský",0.14299999999999999,"kg","PO","T",null,{"$f":"VLOOKUP(F15,lDruhy!$A$1:$C$18,2,FALSE)","v":"Polotovary, hotová jídla"},{"$f":"VLOOKUP(G15,lObchody!$A$1:$D$5,2,FALSE)","v":"Tesco"}]
["2021-01-07",24,"Sekaná",0.152,"kg","PO","K",null,{"$f":"VLOOKUP(F16,lDruhy!$A$1:$C$18,2,FALSE)","v":"Polotovary, hotová jídla"},{"$f":"VLOOKUP(G16,lObchody!$A$1:$D$5,2,FALSE)","v":"Kaufland"}]
["2021-01-08",258,"Bohemia Brut",1.5,"l","AL","K",null,{"$f":"VLOOKUP(F17,lDruhy!$A$1:$C$18,2,FALSE)","v":"Alkoholické nápoje"},{"$f":"VLOOKUP(G17,lObchody!$A$1:$D$5,2,FALSE)","v":"Kaufland"}]
["2021-01-08",19,"Rohlíky",10,"ks","CH","K",null,{"$f":"VLOOKUP(F18,lDruhy!$A$1:$C$18,2,FALSE)","v":"Chléb, pečivo"},{"$f":"VLOOKUP(G18,lObchody!$A$1:$D$5,2,FALSE)","v":"Kaufland"}]
["2021-01-08",33.799999999999997,"Hermelín",0.12,"kg","ML","T",null,{"$f":"VLOOKUP(F19,lDruhy!$A$1:$C$18,2,FALSE)","v":"Mléko, mléčné výrobky"},{"$f":"VLOOKUP(G19,lObchody!$A$1:$D$5,2,FALSE)","v":"Tesco"}]
["2021-01-08",23.6,"Jogurt",0.5,"kg","ML","T",null,{"$f":"VLOOKUP(F20,lDruhy!$A$1:$C$18,2,FALSE)","v":"Mléko, mléčné výrobky"},{"$f":"VLOOKUP(G20,lObchody!$A$1:$D$5,2,FALSE)","v":"Tesco"}]
["2021-01-08",26.4,"Mléko",1,"l","ML","T",null,{"$f":"VLOOKUP(F21,lDruhy!$A$1:$C$18,2,FALSE)","v":"Mléko, mléčné výrobky"},{"$f":"VLOOKUP(G21,lObchody!$A$1:$D$5,2,FALSE)","v":"Tesco"}]
["2021-01-08",52,"Paralen",24,"ks","LE","M",null,{"$f":"VLOOKUP(F22,lDruhy!$A$1:$C$18,2,FALSE)","v":"Léky"},{"$f":"VLOOKUP(G22,lObchody!$A$1:$D$5,2,FALSE)","v":"DrMax"}]
["2021-01-08",999,"Sunar",1.2,"kg","DV","M",null,{"$f":"VLOOKUP(F23,lDruhy!$A$1:$C$18,2,FALSE)","v":"Dětská výživa"},{"$f":"VLOOKUP(G23,lObchody!$A$1:$D$5,2,FALSE)","v":"DrMax"}]
["2021-01-09",48.8,"Tvrdý sýr",0.28999999999999998,"kg","ML","T",null,{"$f":"VLOOKUP(F24,lDruhy!$A$1:$C$18,2,FALSE)","v":"Mléko, mléčné výrobky"},{"$f":"VLOOKUP(G24,lObchody!$A$1:$D$5,2,FALSE)","v":"Tesco"}]
["2021-01-09",31.2,"Papriky",0.52,"kg","ZE","K",null,{"$f":"VLOOKUP(F25,lDruhy!$A$1:$C$18,2,FALSE)","v":"Zelenina"},{"$f":"VLOOKUP(G25,lObchody!$A$1:$D$5,2,FALSE)","v":"Kaufland"}]
["2021-01-09",35.200000000000003,"Rajčata",0.81,"kg","ZE","K",null,{"$f":"VLOOKUP(F26,lDruhy!$A$1:$C$18,2,FALSE)","v":"Zelenina"},{"$f":"VLOOKUP(G26,lObchody!$A$1:$D$5,2,FALSE)","v":"Kaufland"}]
["2021-01-09",39.6,"Rýže",0.96,"kg","ZE","K",null,{"$f":"VLOOKUP(F27,lDruhy!$A$1:$C$18,2,FALSE)","v":"Zelenina"},{"$f":"VLOOKUP(G27,lObchody!$A$1:$D$5,2,FALSE)","v":"Kaufland"}]
["2021-01-09",15.6,"Steril.fazole",0.13,"kg","ZE","K",null,{"$f":"VLOOKUP(F28,lDruhy!$A$1:$C$18,2,FALSE)","v":"Zelenina"},{"$f":"VLOOKUP(G28,lObchody!$A$1:$D$5,2,FALSE)","v":"Kaufland"}]
["2021-01-09",35.799999999999997,"Relax pomer.",1,"l","NN","T",null,{"$f":"VLOOKUP(F29,lDruhy!$A$1:$C$18,2,FALSE)","v":"Nealkoholické nápoje"},{"$f":"VLOOKUP(G29,lObchody!$A$1:$D$5,2,FALSE)","v":"Tesco"}]
["2021-01-09",226,"Borges Extra Virgin",0.5,"l","TU","T",null,{"$f":"VLOOKUP(F30,lDruhy!$A$1:$C$18,2,FALSE)","v":"Tuky"},{"$f":"VLOOKUP(G30,lObchody!$A$1:$D$5,2,FALSE)","v":"Tesco"}]
["2021-01-09",150,"Mariana Dessert",0.25,"kg","KA","T",null,{"$f":"VLOOKUP(F31,lDruhy!$A$1:$C$18,2,FALSE)","v":"Káva, čaj"},{"$f":"VLOOKUP(G31,lObchody!$A$1:$D$5,2,FALSE)","v":"Tesco"}]
["2021-01-09",36.6,"Paprika mletá",7.4999999999999997E-2,"kg","SK","T",null,{"$f":"VLOOKUP(F32,lDruhy!$A$1:$C$18,2,FALSE)","v":"Sůl, koření"},{"$f":"VLOOKUP(G32,lObchody!$A$1:$D$5,2,FALSE)","v":"Tesco"}]
["2021-01-09",36.9,"Hellmanns",0.375,"l","PO","T",null,{"$f":"VLOOKUP(F33,lDruhy!$A$1:$C$18,2,FALSE)","v":"Polotovary, hotová jídla"},{"$f":"VLOOKUP(G33,lObchody!$A$1:$D$5,2,FALSE)","v":"Tesco"}]

{"sheet":"lDruhy","index":16,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["KOD","NAZEV","DAN"]
["AL","Alkoholické nápoje",21]
["CU","Cukr, cukrářské výrobky",15]
["DV","Dětská výživa",10]
["CH","Chléb, pečivo",15]
["KA","Káva, čaj",15]
["LE","Léky",10]
["MA","Maso, masné výrobky",15]
["ML","Mléko, mléčné výrobky",15]
["MO","Mouka",15]
["NN","Nealkoholické nápoje",15]
["OV","Ovoce",15]
["PO","Polotovary, hotová jídla",15]
["RD","Ryby, drůbež, zvěřina",15]
["SK","Sůl, koření",15]
["TU","Tuky",15]
["UZ","Uzeniny",15]
["ZE","Zelenina",15]

{"sheet":"lObchody","index":17,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["KOD","NAZEV","SIDLO","OBCHODU"]
["A","Albert","Brno",34]
["T","Tesco","Praha",48]
["K","Kaufland","Praha",19]
["M","DrMax","Pardubice",61]