{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Menu","Originál","Tlač","Sumár ","Inventár","Sklad","0","1","2","3"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":22,"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":"Menu","index":0,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,1,18,2],[14,5,14,7],[14,9,14,11],[2,1,2,3],[2,5,2,7],[2,9,2,11],[3,1,3,3],[3,5,3,7],[3,9,3,11],[4,1,4,3],[4,5,4,7],[4,9,4,11],[5,1,5,3],[5,5,5,7],[5,9,5,11],[6,1,6,3],[6,5,6,7],[6,9,6,11],[7,1,7,3],[7,5,7,7],[7,9,7,11],[8,1,8,3],[8,5,8,7],[8,9,8,11],[9,1,9,3],[9,5,9,7],[9,9,9,11],[10,1,10,3],[10,5,10,7],[10,9,10,11],[13,1,13,3],[13,5,13,7],[13,9,13,11],[11,1,11,3],[11,5,11,7],[11,9,11,11],[12,1,12,3],[12,5,12,7],[12,9,12,11]]}
[]
[]
[null,"Vyučtovanie 2016",null,null,null,"Vyučtovanie 2017",null,null,null,"Vyučtovanie 2018"]
[null,"vyučtovanie  december 2016",null,null,null,"vyučtovanie  Január 2017",null,null,null,"vyučtovanie Január 2018"]
[null,null,null,null,null,"vyučtovanie  Február 2017",null,null,null,"vyučtovanie Február 2018"]
[null,null,null,null,null,"vyučtovanie Marec 2017",null,null,null,"vyučtovanie Marec 2018"]
[null,null,null,null,null,"vyučtovanie  Apríl 2017",null,null,null,"vyučtovanie Apríl 2018"]
[null,null,null,null,null,"vyučtovanie  Máj 2017 ",null,null,null,"vyučtovanie Máj 2018"]
[null,null,null,null,null,"vyučtovanie Jún 2017",null,null,null,"vyučtovanie Jún 2018"]
[null,null,null,null,null,"vyučtovanie Júl 2017",null,null,null,"vyučtovanie Júl 2018"]
[null,null,null,null,null,"vyučtovanie August 2017",null,null,null,"vyučtovanie August 2018"]
[null,null,null,null,null,"vyučtovanie September 2017",null,null,null,"vyučtovanie September 2018"]
[null,null,null,null,null,"vyučtovanie Oktober 2017 ",null,null,null,"vyučtovanie Október 2018"]
[null,null,null,null,null,"vyučtovanie  November 2017",null,null,null,"vyučtovanie November 2018"]
[null,null,null,null,null,"vyučtovanie December  2017",null,null,null,"vyuctovanie December 2018 "]
[]
[]
[]
[null,"Tlač vyučtovaný:"]

{"sheet":"Originál","index":1,"n_rows":158,"n_cols":22,"rows_kept":158,"cut":false,"hidden":false,"merged":[[155,3,155,4],[156,3,156,4],[157,3,157,4],[114,17,115,17],[148,3,148,4],[114,18,115,18],[114,6,115,6],[114,8,115,8],[114,9,115,9],[114,10,115,10],[114,14,115,14],[62,5,63,5],[62,17,63,17],[147,3,147,4],[146,3,146,4],[114,15,115,15],[114,16,115,16],[62,10,63,10],[62,14,63,14],[114,1,115,1],[114,2,115,2],[114,3,115,3],[114,4,115,4],[114,5,115,5],[114,20,115,20],[114,21,115,21],[10,18,11,18],[62,1,63,1],[62,2,63,2],[62,3,63,3],[62,4,63,4],[10,1,11,1],[62,15,63,15],[62,16,63,16],[10,15,11,15],[10,16,11,16],[10,2,11,2],[10,3,11,3],[10,4,11,4],[62,6,63,6],[0,14,0,17],[1,15,1,16],[10,5,11,5],[10,6,11,6],[10,8,11,8],[10,9,11,9],[10,10,11,10],[10,14,11,14],[10,17,11,17],[4,7,4,9],[0,6,0,8],[6,7,6,8],[10,20,11,20],[10,21,11,21],[62,20,63,20],[62,21,63,21],[62,8,63,8],[62,9,63,9],[62,18,63,18],[10,11,11,11]]}
[null,null,null,"Vyučtovanie výčapu ",null,null,null,null,null,"/2019",null,null,null,null,"Denný sumár"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Juniorka","Meno:",{"$f":"I2","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Šipulová","Dátum:",{"$f":"I3","v":0},"/2019"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Hermanová"]
[null,null,null,null,null,null,"Meno:"]
[]
[null,null,null,null,null,null,"Dátum:",null,null,"/2019"]
[]
[]
[null,null,"Strana 1:",null,null,null,null,null,null,null,null,null,null,null,"Strana 1:"]
[null,"P.Č.","Názov  tovaru","Poč. stav","Denný príjem","Spolu","Zostatok v sklade",null,"Denný predaj","Cena €","Suma celkom €","J.M.",null,null,"Nákupná cena","Predajná cena","Tržba","Zisk","Zisk po zdanení",null,"Zostatok v krčme","Suma tovaru"]
[]
[null,"1.","Pernštejn čap. 10˚",null,null,{"$f":"D13+E13","v":0},null,null,{"$f":"D13+E13-G13","v":0},2,{"$f":"I13*J13","v":0},"l.",null,null,1.032,{"$f":"J13","v":2},{"$f":"I13*J13","v":0},{"$f":"(P13-O13)*I13","v":0},{"$f":"R13*0.8","v":0},null,{"$f":"G13","v":0},{"$f":"U13*O13","v":0}]
[null,"2.","Malinovka čap.",null,null,0,null,null,0,2,{"$f":"I14*J14","v":0},"l.",null,null,0.49299999999999999,{"$f":"J14","v":2},{"$f":"I14*J14","v":0},{"$f":"(P14-O14)*I14","v":0},{"$f":"R14*0.8","v":0},null,{"$f":"G14","v":0},{"$f":"U14*O14","v":0}]
[null,"3.","Radler čap.",null,null,0,null,null,0,2.6,0,"l.",null,null,1.52,2.6,0,{"$f":"(P15-O15)*I15","v":0},0,null,0,0]
[null,"4.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"5.","Šariš 10˚ fľaša",null,null,0,null,null,0,0.8,0,"ks.",null,null,0.34,0.8,0,0,0,null,0,0]
[null,"6.","Kozel 10˚ fľaša",null,null,0,null,null,0,0.9,0,"ks.",null,null,0.47,0.9,0,0,0,null,0,0]
[null,"7.","Birell nealko fľaša",null,null,0,null,null,0,1.2,0,"ks.",null,null,0.64,1.2,0,0,0,null,0,0]
[null,"8.","Gambrinus fľaša",null,null,0,null,null,0,0.9,0,"ks.",null,null,0.56000000000000005,0.9,0,0,0,null,0,0]
[null,"9.","Plzeň 12˚ fľaša",null,null,0,null,null,0,1.3,0,"ks.",null,null,0.69399999999999995,1.3,0,0,0,null,0,0]
[null,"10.",null,null,null,0,null,null,0,null,0,"ks.",null,null,null,0,0,0,0,null,0,0]
[null,"11.","Gambrinus plech.",null,null,0,null,null,0,1,0,"ks.",null,null,0.49,1,0,0,0,null,0,0]
[null,"12.",null,null,null,0,null,null,0,null,0,"ks.",null,null,0.42,0,0,0,0,null,0,0]
[null,"13.",null,null,null,0,null,null,0,null,0,"ks.",null,null,0.75,0,0,0,0,null,0,0]
[null,"14.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"15.","Práznde sudy",null,null,0,null,null,0,null,0,"ks.",null,null,null,0,0,0,0,null,0,0]
[null,"16.","Práznde fľaše",null,null,0,null,null,0,null,0,"ks.",null,null,null,0,0,0,0,null,0,0]
[null,"17.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"18.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"19.","Víno biele",null,null,0,null,null,0,3,0,"l.",null,null,1.29,3,0,0,0,null,0,0]
[null,"20.","Víno červené",null,null,0,null,null,0,3,0,"l.",null,null,1.29,3,0,0,0,null,0,0]
[null,"21.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"22.","Vodka",null,null,0,null,null,0,12,0,"l.",null,null,6.54,12,0,0,0,null,0,0]
[null,"23.","Borovička",null,null,0,null,null,0,12,0,"l.",null,null,6.56,12,0,0,0,null,0,0]
[null,"24.","Koniferka",null,null,0,null,null,0,14,0,"l.",null,null,5.95,14,0,0,0,null,0,0]
[null,"25.","RUM",null,null,0,null,null,0,12,0,"l.",null,null,5.78,12,0,0,0,null,0,0]
[null,"26.","Hruška",null,null,0,null,null,0,14,0,"l.",null,null,7.2,14,0,0,0,null,0,0]
[null,"27.","Spišská borovička",null,null,0,null,null,0,14,0,"l.",null,null,8.5500000000000007,14,0,0,0,null,0,0]
[null,"28.","Trenčianské hradné",null,null,0,null,null,0,12,0,"l.",null,null,6.6360000000000001,12,0,0,0,null,0,0]
[null,"29.","Karpatská horká",null,null,0,null,null,0,12,0,"l.",null,null,5.32,12,0,0,0,null,0,0]
[null,"30.","Vodka Peach",null,null,0,null,null,0,14,0,"l.",null,null,4.41,14,0,0,0,null,0,0]
[null,"31.","Becherovka",null,null,0,null,null,0,20,0,"l.",null,null,10.67,20,0,0,0,null,0,0]
[null,"32.","Fernet",null,null,0,null,null,0,20,0,"l.",null,null,9.69,20,0,0,0,null,0,0]
[null,"33.","Slivka",null,null,0,null,null,0,14,0,"l.",null,null,7.21,14,0,0,0,null,0,0]
[null,"34.","Bošácka slivovica",null,null,0,null,null,0,24,0,"l.",null,null,17.61,24,0,0,0,null,0,0]
[null,"35.","Karpatská KB",null,null,0,null,null,0,20,0,"l.",null,null,5.9980000000000002,20,0,0,0,null,0,0]
[null,"36.","Fernet Citrus",null,null,0,null,null,0,20,0,"l.",null,null,9.69,20,0,0,0,null,0,0]
[null,"37.","Pepermint",null,null,0,null,null,0,12,0,"l.",null,null,5.2,12,0,0,0,null,0,0]
[null,"38.","Nicolaus vodka",null,null,0,null,null,0,18,0,"l.",null,null,8.6199999999999992,18,0,0,0,null,0,0]
[null,"39.","Captain Morgan",null,null,0,null,null,0,24,0,"l.",null,null,11.74,24,0,0,0,null,0,0]
[null,"40.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"41.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"SUM(D13:D53)","v":0},null,null,{"$f":"SUM(G13:G53)","v":0},null,null,"Celkom:",{"$f":"SUM(K13:K53)","v":0},null,null,null,null,"Celkom:",{"$f":"SUM(Q13:Q53)","v":0},{"$f":"SUM(R13:R53)","v":0},{"$f":"SUM(S13:S53)","v":0},null,"Za tovar:",{"$f":"SUM(V13:V53)","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,"Strana 2:",null,null,null,null,null,null,null,null,null,null,null,"Strana 2:"]
[null,"P.Č.","Názov  tovaru","Poč. stav","Denný príjem","Spolu","Zostatok v sklade",null,"Denný predaj","Cena €","Suma celkom €",null,null,null,"Nákupná cena","Predajná cena","Tržba","Zisk","Zisk po zdanení",null,"Zostatok v krčme","Suma tovaru"]
[]
[null,"42.","PEPSI + 7UP 0,5l",null,null,{"$f":"D65+E65","v":0},null,null,{"$f":"D65+E65-G65","v":0},1.1000000000000001,{"$f":"I65*J65","v":0},"ks.",null,null,0.78,{"$f":"J65","v":1.1000000000000001},{"$f":"I65*J65","v":0},{"$f":"(P65-O65)*I65","v":0},{"$f":"R65*0.8","v":0},null,{"$f":"G65","v":0},{"$f":"U65*O65","v":0}]
[null,"43.","Sprite +Tonic",null,null,{"$f":"D66+E66","v":0},null,null,{"$f":"D66+E66-G66","v":0},2,{"$f":"I66*J66","v":0},"ks.",null,null,0.72599999999999998,{"$f":"J66","v":2},{"$f":"I66*J66","v":0},{"$f":"(P66-O66)*I66","v":0},{"$f":"R66*0.8","v":0},null,{"$f":"G66","v":0},{"$f":"U66*O66","v":0}]
[null,"44.","Minerálka 0,5l",null,null,0,null,null,0,1,0,"ks.",null,null,0.52800000000000002,1,0,{"$f":"(P67-O67)*I67","v":0},0,null,0,0]
[null,"45.","Kofola 0,5l",null,null,0,null,null,0,1.1000000000000001,0,"ks.",null,null,0.49,1.1000000000000001,0,0,0,null,0,0]
[null,"46.","Džús krabička",null,null,0,null,null,0,0.5,0,"ks.",null,null,0.17,0.5,0,0,0,null,0,0]
[null,"47.","Energetický nápoj",null,null,0,null,null,0,2,0,"ks.",null,null,0.25,2,0,0,0,null,0,0]
[null,"48.","Limo 0,33l fľaša",null,null,0,null,null,0,0.5,0,"ks.",null,null,0.1,0.5,0,0,0,null,0,0]
[null,"49.","Minerálka 2l",0,null,0,null,null,0,1.5,0,"l.",null,null,0.23,1.5,0,0,0,null,0,0]
[null,"50.","Relax džús fľaška",null,null,0,null,null,0,1,0,"ks.",null,null,0.55000000000000004,1,0,0,0,null,0,0]
[null,"51.","Ďžús nalievaný",null,null,0,null,null,0,3,0,"l.",null,null,1.1879999999999999,3,0,0,0,null,0,0]
[null,"52.","Toma",null,null,0,null,null,0,1.1000000000000001,0,"l.",null,null,0.33,1.1000000000000001,0,0,0,null,0,0]
[null,"53.","HELLO Jupík",null,null,0,null,null,0,0.8,0,"ks.",null,null,0.33,0.8,0,0,0,null,0,0]
[null,"54.","COCA COLA",null,null,0,null,null,0,1.1000000000000001,0,"ks.",null,null,0.624,1.1000000000000001,0,0,0,null,0,0]
[null,"55.","Vinea",null,null,0,null,null,0,1.1000000000000001,0,"ks.",null,null,0.504,1.1000000000000001,0,0,0,null,0,0]
[null,"56.","ALOE VERA",null,null,0,null,null,0,1.2,0,"ks.",null,null,0.65,1.2,0,0,0,null,0,0]
[null,"57.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"58.","Káva turecká",null,null,0,null,null,{"$f":"(D81+E81-G81)/7","v":0},0.5,0,"gr.",null,null,3.4000000000000002E-2,0.5,{"$f":"K81","v":0},0,0,null,0,0]
[null,"59.","Nescafé 3v1",null,null,0,null,null,0,0.5,0,"ks.",null,null,0.14000000000000001,0.5,0,0,0,null,0,0]
[null,"60.","Čaj",null,null,0,null,null,0,0.5,{"$f":"I83*J83","v":0},"ks.",null,null,5.8000000000000003E-2,0.5,{"$f":"I83*J83","v":0},0,0,null,0,{"$f":"U83*O84","v":0}]
[null,"61.","Mlieko do kávy",null,null,0,null,null,0,0.1,{"$f":"I84*J84","v":0},"ks.",null,null,3.5999999999999997E-2,0.1,{"$f":"I84*J84","v":0},0,0,null,0,{"$f":"U84*O85","v":0}]
[null,"62.","Cukor HB",null,null,0,null,null,0,0.05,{"$f":"I85*J85","v":0},"ks.",null,null,8.0000000000000002E-3,0.05,{"$f":"I85*J85","v":0},0,0,null,0,{"$f":"U85*O86","v":0}]
[null,"63.",null,null,null,0,null,null,0,null,{"$f":"I86*J86","v":0},null,null,null,null,0,{"$f":"I86*J86","v":0},0,0,null,0,{"$f":"U86*O87","v":0}]
[null,"64.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,{"$f":"(P87-O87)*I87","v":0},0,null,0,0]
[null,"65.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"66.","Golden",null,null,0,null,null,0,3.4,0,"ks.",null,null,3.22,3.4,0,0,0,null,0,0]
[null,"67.","Petra 3,40€",null,null,0,null,null,0,3.4,0,"ks.",null,null,3.23,3.4,0,0,0,null,0,0]
[null,"68.","Malboro 3,70€",null,null,0,null,null,0,3.7,0,"ks.",null,null,3.51,3.7,0,0,0,null,0,0]
[null,"69.","LM 3,40€",null,null,0,null,null,0,3.4,0,"ks.",null,null,3.23,3.4,0,0,0,null,0,0]
[null,"70.","Mars",null,null,0,null,null,0,3.4,0,"ks.",null,null,3.22,3.4,0,0,0,null,0,0]
[null,"71.","West",null,null,0,null,null,0,3.2,0,"ks.",null,null,3.04,3.2,0,0,0,null,0,0]
[null,"72.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"73.","Malboro 4,00€",null,null,0,null,null,0,4,0,"ks.",null,null,3.9,4,0,0,0,null,0,0]
[null,"74.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"75.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"76.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"77.","Hyg. vreckovky",null,null,0,null,null,0,0.2,0,"ks.",null,null,8.8999999999999996E-2,0.2,0,0,0,null,0,0]
[null,"78.","Zapaľovač",null,null,0,null,null,0,0.5,0,"ks.",null,null,0.17,0.5,0,0,0,null,0,0]
[null,"79.","Zápalky",null,null,0,null,null,0,0.1,0,"ks.",null,null,0.04,0.1,0,0,0,null,0,0]
[null,"80.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"81.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"82.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[]
[null,null,null,{"$f":"SUM(D65:D105)","v":0},null,null,{"$f":"SUM(G65:G105)","v":0},null,null,"Celkom :",{"$f":"SUM(K65:K105)","v":0},null,null,null,null,"Celkom:",{"$f":"SUM(Q65:Q105)","v":0},{"$f":"SUM(R65:R105)","v":0},{"$f":"SUM(S65:S105)","v":0},null,"Za tovar:",{"$f":"SUM(V65:V105)","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,"Strana 3:",null,null,null,null,null,null,null,null,null,null,null,"Strana 3:"]
[null,"P.Č.","Názov  tovaru","Poč. stav","Denný príjem","Spolu","Zostatok v sklade",null,"Denný predaj","Cena €","Suma celkom €",null,null,null,"Nákupná cena","Predajná cena","Tržba","Zisk","Zisk po zdanení",null,"Zostatok v krčme","Suma tovaru"]
[]
[null,"83.","Kinderko",null,null,{"$f":"D117+E117","v":0},null,null,{"$f":"D117+E117-G117","v":0},1.5,{"$f":"I117*J117","v":0},"ks.",null,null,0.93,{"$f":"J117","v":1.5},{"$f":"I117*J117","v":0},{"$f":"(P117-O117)*I117","v":0},{"$f":"R117*0.8","v":0},null,{"$f":"G117","v":0},{"$f":"U117*O117","v":0}]
[null,"84.","Horalka",null,null,{"$f":"D118+E118","v":0},null,null,{"$f":"D118+E118-G118","v":0},0.6,{"$f":"I118*J118","v":0},"ks.",null,null,0.31,{"$f":"J118","v":0.6},{"$f":"I118*J118","v":0},{"$f":"(P118-O118)*I118","v":0},{"$f":"R118*0.8","v":0},null,{"$f":"G118","v":0},{"$f":"U118*O118","v":0}]
[null,"85.","Kávenky",null,null,0,null,null,0,0.6,0,"ks.",null,null,0.28000000000000003,0.6,0,{"$f":"(P119-O119)*I119","v":0},0,null,0,0]
[null,"86.","Kinder čokoláda",null,null,0,null,null,0,1.8,0,"ks.",null,null,0.9,1.8,0,0,0,null,0,0]
[null,"87.","3-BIT",null,null,0,null,null,0,0.6,0,"ks.",null,null,0.32,0.6,0,0,0,null,0,0]
[null,"88.","Banán",null,null,0,null,null,0,0.6,0,"ks.",null,null,0.26,0.6,0,0,0,null,0,0]
[null,"89.","Margot",null,null,0,null,null,0,0.6,0,"ks.",null,null,0.4,0.6,0,0,0,null,0,0]
[null,"90.","Lízatko 2",null,null,0,null,null,0,0.2,0,"ks.",null,null,0.04,0.2,0,0,0,null,0,0]
[null,"91.","Mila",null,null,0,null,null,0,0.6,0,"ks.",null,null,0.37,0.6,0,0,0,null,0,0]
[null,"92.","Lízatko",null,null,0,null,null,0,0.3,0,"ks.",null,null,0.1,0.3,0,0,0,null,0,0]
[null,"93.","Chipsy",null,null,0,null,null,0,1,0,"ks.",null,null,0.42,1,0,0,0,null,0,0]
[null,"94.","Tofife",null,null,0,null,null,0,3,0,"ks.",null,null,1.62,3,0,0,0,null,0,0]
[null,"95.","Milka čok.",null,null,0,null,null,0,1.8,0,"ks.",null,null,0.73,1.8,0,0,0,null,0,0]
[null,"96.","Tyčinky DRU",null,null,0,null,null,0,0.5,0,"ks.",null,null,0.23,0.5,0,0,0,null,0,0]
[null,"97.","Arašidy",null,null,0,null,null,0,0.8,0,"ks.",null,null,0.41,0.8,0,0,0,null,0,0]
[null,"98.","TIC-TAC",null,null,0,null,null,0,0.6,0,"ks.",null,null,0.3,0.6,0,0,0,null,0,0]
[null,"99.","Žuvažky plátky",null,null,0,null,null,0,0.1,0,"ks.",null,null,5.1999999999999998E-2,0.1,0,0,0,null,0,0]
[null,"100.","Žuvažky dražé",null,null,0,null,null,0,0.6,0,"ks.",null,null,0.37,0.6,0,0,0,null,0,0]
[null,"101.","Hašlerky",null,null,0,null,null,0,0.9,0,"ks.",null,null,0.54,0.9,0,0,0,null,0,0]
[null,"102.","Žuvačky guličky",null,null,0,null,null,0,0.7,0,"ks.",null,null,0.3,0.7,0,0,0,null,0,0]
[null,"103.","Chrumky",null,null,0,null,null,0,0.6,0,"ks.",null,null,0.27,0.6,0,0,0,null,0,0]
[null,"104.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"105.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"106.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"107.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"108.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,{"$f":"SUM(D117:D142)","v":0},null,null,{"$f":"SUM(G117:G142)","v":0},null,null,"Celkom:",{"$f":"SUM(K117:K142)","v":0},null,null,null,null,"Celkom:",{"$f":"SUM(Q117:Q142)","v":0},{"$f":"SUM(R117:R142)","v":0},{"$f":"SUM(S117:S142)","v":0},null,"Za tovar:",{"$f":"SUM(V117:V142)","v":0}]
[]
[]
[null,null,null,"Stávková:",null,null,null,null,"Strana 1:",{"$f":"K55","v":0},null,null,null,null,null,"Strana 1",{"$f":"Q55","v":0},{"$f":"R55","v":0},{"$f":"S55","v":0},null,"Strana 1:",{"$f":"V55","v":0}]
[null,null,null,"Refil:",null,null,null,null,"Strana 2:",{"$f":"K107","v":0},null,null,null,null,null,"Strana 2",{"$f":"Q107","v":0},{"$f":"R107","v":0},{"$f":"S107","v":0},null,"Strana 2:",{"$f":"V107","v":0}]
[null,null,null,"Výdavky:",null,null,null,null,"Strana 3:",{"$f":"K144","v":0},null,null,null,null,null,"Strana 3",{"$f":"Q144","v":0},{"$f":"R144","v":0},{"$f":"S144","v":0},null,"Strana 3:",{"$f":"V144","v":0}]
[]
[null,null,null,null,"Spolu:",{"$f":"SUM(F147:F149)","v":0},null,null,"Spolu:",{"$f":"SUM(J147:J149)","v":0},null,null,null,null,null,"Spolu:",{"$f":"SUM(Q147:Q149)","v":0},{"$f":"SUM(R147:R149)","v":0},{"$f":"SUM(S147:S149)","v":0},null,"Spolu:",{"$f":"SUM(V147:V149)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spolu:",{"$f":"Q151-F151","v":0},{"$f":"R151-G151","v":0},{"$f":"S151-H151","v":0}]
[null,null,null,null,null,null,null,null,"Celkom :",{"$f":"J151-F151","v":0}]
[]
[null,null,"Zostatok hotovosť:"]
[]
[null,null,"rozdiel:",{"$f":"D156-J154","v":0}]

{"sheet":"Tlač","index":2,"n_rows":156,"n_cols":12,"rows_kept":156,"cut":false,"hidden":false,"merged":[[62,5,63,5],[114,6,115,6],[114,8,115,8],[114,1,115,1],[114,2,115,2],[114,3,115,3],[114,4,115,4],[62,1,63,1],[62,2,63,2],[62,3,63,3],[62,4,63,4],[0,6,0,8],[10,1,11,1],[10,2,11,2],[10,3,11,3],[10,4,11,4],[10,5,11,5],[10,6,11,6],[10,8,11,8],[4,7,4,9],[10,9,11,9],[6,7,6,8],[114,9,115,9],[114,10,115,10],[10,11,11,11],[62,6,63,6],[62,8,63,8],[62,9,63,9],[62,10,63,10],[10,10,11,10],[155,3,155,4],[146,3,146,4],[114,5,115,5],[147,3,147,4],[148,3,148,4]]}
[null,null,null,"Vyučtovanie výčapu ",null,null,null,null,null,"/2019"]
[]
[]
[]
[null,null,null,null,null,null,"Meno:"]
[]
[null,null,null,null,null,null,"Dátum:",null,null,"/2019"]
[]
[]
[null,null,"Strana 1:"]
[null,"P.Č.","Názov  tovaru","Poč. stav","Denný príjem","Spolu","Zostatok v sklade",null,"Denný predaj","Cena €","Suma celkom €","J.M."]
[]
[null,"1.","Pernštejn čap. 10˚",null,null,{"$f":"D13+E13","v":0},null,null,{"$f":"D13+E13-G13","v":0},2,{"$f":"I13*J13","v":0},"l."]
[null,"2.","Malinovka čap.",null,null,0,null,null,0,2,{"$f":"I14*J14","v":0},"l."]
[null,"3.","Radler čap.",null,null,0,null,null,0,2.6,0,"l."]
[null,"4.",null,null,null,0,null,null,0,null,0]
[null,"5.","Šariš 10˚ fľaša",null,null,0,null,null,0,0.8,0,"ks."]
[null,"6.","Kozel 10˚ fľaša",null,null,0,null,null,0,0.9,0,"ks."]
[null,"7.","Birell nealko fľaša",null,null,0,null,null,0,1.2,0,"ks."]
[null,"8.","Gambrinus fľaša",null,null,0,null,null,0,0.9,0,"ks."]
[null,"9.","Plzeň 12˚ fľaša",null,null,0,null,null,0,1.3,0,"ks."]
[null,"10.",null,null,null,0,null,null,0,null,0,"ks."]
[null,"11.","Gambrinus plech.",null,null,0,null,null,0,1,0,"ks."]
[null,"12.",null,null,null,0,null,null,0,null,0,"ks."]
[null,"13.",null,null,null,0,null,null,0,null,0,"ks."]
[null,"14.",null,null,null,0,null,null,0,null,0]
[null,"15.","Práznde sudy",null,null,0,null,null,0,null,0,"ks."]
[null,"16.","Práznde fľaše",null,null,0,null,null,0,null,0,"ks."]
[null,"17.",null,null,null,0,null,null,0,null,0]
[null,"18.",null,null,null,0,null,null,0,null,0]
[null,"19.","Víno biele",null,null,0,null,null,0,3,0,"l."]
[null,"20.","Víno červené",null,null,0,null,null,0,3,0,"l."]
[null,"21.",null,null,null,0,null,null,0,null,0]
[null,"22.","Vodka",null,null,0,null,null,0,12,0,"l."]
[null,"23.","Borovička",null,null,0,null,null,0,12,0,"l."]
[null,"24.","Koniferka",null,null,0,null,null,0,14,0,"l."]
[null,"25.","RUM",null,null,0,null,null,0,12,0,"l."]
[null,"26.","Hruška",null,null,0,null,null,0,14,0,"l."]
[null,"27.","Spišská borovička",null,null,0,null,null,0,14,0,"l."]
[null,"28.","Trenčianské hradné",null,null,0,null,null,0,12,0,"l."]
[null,"29.","Karpatská horká",null,null,0,null,null,0,12,0,"l."]
[null,"30.","Vodka Peach",null,null,0,null,null,0,14,0,"l."]
[null,"31.","Becherovka",null,null,0,null,null,0,20,0,"l."]
[null,"32.","Fernet",null,null,0,null,null,0,20,0,"l."]
[null,"33.","Slivka",null,null,0,null,null,0,14,0,"l."]
[null,"34.","Bošácka slivovica",null,null,0,null,null,0,24,0,"l."]
[null,"35.","Karpatská KB",null,null,0,null,null,0,20,0,"l."]
[null,"36.","Fernet Citrus",null,null,0,null,null,0,20,0,"l."]
[null,"37.","Pepermint",null,null,0,null,null,0,12,0,"l."]
[null,"38.","Nicolaus vodka",null,null,0,null,null,0,18,0,"l."]
[null,"39.","Captain Morgan",null,null,0,null,null,0,24,0,"l."]
[null,"40.",null,null,null,0,null,null,0,null,0]
[null,"41.",null,null,null,0,null,null,0,null,0]
[]
[null,null,null,{"$f":"SUM(D13:D53)","v":0},null,null,{"$f":"SUM(G13:G53)","v":0},null,null,"Celkom:",{"$f":"SUM(K13:K53)","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,"Strana 2:"]
[null,"P.Č.","Názov  tovaru","Poč. stav","Denný príjem","Spolu","Zostatok v sklade",null,"Denný predaj","Cena €","Suma celkom €"]
[]
[null,"42.","PEPSI + 7UP 0,5l",null,null,{"$f":"D65+E65","v":0},null,null,{"$f":"D65+E65-G65","v":0},1.1000000000000001,{"$f":"I65*J65","v":0},"ks."]
[null,"43.","Sprite +Tonic",null,null,{"$f":"D66+E66","v":0},null,null,{"$f":"D66+E66-G66","v":0},2,{"$f":"I66*J66","v":0},"ks."]
[null,"44.","Minerálka 0,5l",null,null,0,null,null,0,1,0,"ks."]
[null,"45.","Kofola 0,5l",null,null,0,null,null,0,1.1000000000000001,0,"ks."]
[null,"46.","Džús krabička",null,null,0,null,null,0,0.5,0,"ks."]
[null,"47.","Energetický nápoj",null,null,0,null,null,0,2,0,"ks."]
[null,"48.","Limo 0,33l fľaša",null,null,0,null,null,0,0.5,0,"ks."]
[null,"49.","Minerálka 2l",0,null,0,null,null,0,1.5,0,"l."]
[null,"50.","Relax džús fľaška",null,null,0,null,null,0,1,0,"ks."]
[null,"51.","Ďžús nalievaný",null,null,0,null,null,0,3,0,"l."]
[null,"52.","Toma",null,null,0,null,null,0,1.1000000000000001,0,"l."]
[null,"53.","HELLO Jupík",null,null,0,null,null,0,0.8,0,"ks."]
[null,"54.","COCA COLA",null,null,0,null,null,0,1.1000000000000001,0,"ks."]
[null,"55.","Vinea",null,null,0,null,null,0,1.1000000000000001,0,"ks."]
[null,"56.","ALOE VERA",null,null,0,null,null,0,1.2,0,"ks."]
[null,"57.",null,null,null,0,null,null,0,null,0]
[null,"58.","Káva turecká",null,null,0,null,null,{"$f":"(D81+E81-G81)/7","v":0},0.5,0,"gr."]
[null,"59.","Nescafé 3v1",null,null,0,null,null,0,0.5,0,"ks."]
[null,"60.","Čaj",null,null,0,null,null,0,0.5,{"$f":"I83*J83","v":0},"ks."]
[null,"61.","Mlieko do kávy",null,null,0,null,null,0,0.1,{"$f":"I84*J84","v":0},"ks."]
[null,"62.","Cukor HB",null,null,0,null,null,0,0.05,{"$f":"I85*J85","v":0},"ks."]
[null,"63.",null,null,null,0,null,null,0,null,{"$f":"I86*J86","v":0}]
[null,"64.",null,null,null,0,null,null,0,null,0]
[null,"65.",null,null,null,0,null,null,0,null,0]
[null,"66.","Golden",null,null,0,null,null,0,3.4,0,"ks."]
[null,"67.","Petra 3,40€",null,null,0,null,null,0,3.4,0,"ks."]
[null,"68.","Malboro 3,70€",null,null,0,null,null,0,3.7,0,"ks."]
[null,"69.","LM 3,40€",null,null,0,null,null,0,3.4,0,"ks."]
[null,"70.","Mars",null,null,0,null,null,0,3.4,0,"ks."]
[null,"71.","West",null,null,0,null,null,0,3.2,0,"ks."]
[null,"72.",null,null,null,0,null,null,0,null,0]
[null,"73.","Malboro 4,00€",null,null,0,null,null,0,4,0,"ks."]
[null,"74.",null,null,null,0,null,null,0,null,0]
[null,"75.",null,null,null,0,null,null,0,null,0]
[null,"76.",null,null,null,0,null,null,0,null,0]
[null,"77.","Hyg. vreckovky",null,null,0,null,null,0,0.2,0,"ks."]
[null,"78.","Zapaľovač",null,null,0,null,null,0,0.5,0,"ks."]
[null,"79.","Zápalky",null,null,0,null,null,0,0.1,0,"ks."]
[null,"80.",null,null,null,0,null,null,0,null,0]
[null,"81.",null,null,null,0,null,null,0,null,0]
[null,"82.",null,null,null,0,null,null,0,null,0]
[]
[null,null,null,{"$f":"SUM(D65:D105)","v":0},null,null,{"$f":"SUM(G65:G105)","v":0},null,null,"Celkom :",{"$f":"SUM(K65:K105)","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,"Strana 3:"]
[null,"P.Č.","Názov  tovaru","Poč. stav","Denný príjem","Spolu","Zostatok v sklade",null,"Denný predaj","Cena €","Suma celkom €"]
[]
[null,"83.","Kinderko",null,null,{"$f":"D117+E117","v":0},null,null,{"$f":"D117+E117-G117","v":0},1.5,{"$f":"I117*J117","v":0},"ks."]
[null,"84.","Horalka",null,null,{"$f":"D118+E118","v":0},null,null,{"$f":"D118+E118-G118","v":0},0.6,{"$f":"I118*J118","v":0},"ks."]
[null,"85.","Kávenky",null,null,0,null,null,0,0.6,0,"ks."]
[null,"86.","Kinder čokoláda",null,null,0,null,null,0,1.8,0,"ks."]
[null,"87.","3-BIT",null,null,0,null,null,0,0.6,0,"ks."]
[null,"88.","Banán",null,null,0,null,null,0,0.6,0,"ks."]
[null,"89.","Margot",null,null,0,null,null,0,0.6,0,"ks."]
[null,"90.","Lízatko 2",null,null,0,null,null,0,0.2,0,"ks."]
[null,"91.","Mila",null,null,0,null,null,0,0.6,0,"ks."]
[null,"92.","Lízatko",null,null,0,null,null,0,0.3,0,"ks."]
[null,"93.","Chipsy",null,null,0,null,null,0,1,0,"ks."]
[null,"94.","Tofife",null,null,0,null,null,0,3,0,"ks."]
[null,"95.","Milka čok.",null,null,0,null,null,0,1.8,0,"ks."]
[null,"96.","Tyčinky DRU",null,null,0,null,null,0,0.5,0,"ks."]
[null,"97.","Arašidy",null,null,0,null,null,0,0.8,0,"ks."]
[null,"98.","TIC-TAC",null,null,0,null,null,0,0.6,0,"ks."]
[null,"99.","Žuvažky plátky",null,null,0,null,null,0,0.1,0,"ks."]
[null,"100.","Žuvažky dražé",null,null,0,null,null,0,0.6,0,"ks."]
[null,"101.","Hašlerky",null,null,0,null,null,0,0.9,0,"ks."]
[null,"102.","Žuvačky guličky",null,null,0,null,null,0,0.7,0,"ks."]
[null,"103.","Chrumky",null,null,0,null,null,0,0.6,0,"ks."]
[null,"104.",null,null,null,0,null,null,0,null,0]
[null,"105.",null,null,null,0,null,null,0,null,0]
[null,"106.",null,null,null,0,null,null,0,null,0]
[null,"107.",null,null,null,0,null,null,0,null,0]
[null,"108.",null,null,null,0,null,null,0,null,0]
[]
[null,null,null,{"$f":"SUM(D117:D142)","v":0},null,null,{"$f":"SUM(G117:G142)","v":0},null,null,"Celkom:",{"$f":"SUM(K117:K142)","v":0}]
[]
[]
[null,null,null,"Stávková:",null,null,null,null,"Strana 1:",{"$f":"K55","v":0}]
[null,null,null,"Refil:",null,null,null,null,"Strana 2:",{"$f":"K107","v":0}]
[null,null,null,"Výdavky:",null,null,null,null,"Strana 3:",{"$f":"K144","v":0}]
[]
[null,null,null,null,"Spolu:",{"$f":"SUM(F147:F149)","v":0},null,null,"Spolu:",{"$f":"SUM(J147:J149)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,"Celkom :",{"$f":"J151-F151","v":0}]
[]
[null,null,"Zostatok hotovosť:"]

{"sheet":"Sumár ","index":3,"n_rows":142,"n_cols":21,"rows_kept":142,"cut":false,"hidden":false,"merged":[[0,1,0,10],[0,16,0,19],[1,17,1,18],[10,1,11,1],[10,2,11,2],[10,3,11,3],[10,4,11,4],[10,5,11,5],[10,6,11,6],[10,7,11,7],[10,18,11,18],[10,19,11,19],[10,20,11,20],[10,8,11,8],[10,10,11,10],[10,11,11,11],[10,12,11,12],[10,16,11,16],[10,17,11,17]]}
[10,"Mesačný sumár",null,null,null,null,null,null,null,null,null,"Jún","/2019",null,null,null,"Mesačný sumár"]
[null,null,null,null,null,null,"Meno:",null,null,null,null,null,null,null,null,null,null,{"$f":"H2","v":0}]
[null,null,null,null,null,null,"Dátum:",null,null,null,null,null,null,null,null,null,null,{"$f":"H3","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,"P.Č.","Názov  tovaru","Poč. stav","Mesačný  príjem","Spolu","Zostatok v sklade","Mesačný   predaj","J.M.",null,"Cena €","Mesačný nákup celkom","Mesačný predaj     celkom ",null,null,null,"Nákupná cena","Predajná cena","Tržba","Zisk","Zisk po zdanení"]
[]
[null,"1.","Pernštejn čap. 10˚",146.44999999999999,{"$f":"SUM('0:3'!E13)","v":0},{"$f":"D13+E13","v":146.44999999999999},201.4,{"$f":"SUM('0:3'!I13)","v":192.5},"l.",null,2,{"$f":"E13*Q13","v":0},{"$f":"H13*K13","v":385},null,null,null,1.032,{"$f":"K13","v":2},{"$f":"H13*K13","v":385},{"$f":"(R13-Q13)*H13","v":186.34},{"$f":"T13*0.8","v":149.072}]
[null,"2.","Malinovka čap.",53.2,{"$f":"SUM('0:3'!E14)","v":80},133.19999999999999,125.2,{"$f":"SUM('0:3'!I14)","v":124.5},"l.",null,2,39.44,249,null,null,null,0.49299999999999999,2,249,187.62150000000003,150.09720000000002]
[null,"3.","Radler čap.",10,{"$f":"SUM('0:3'!E15)","v":30},40,8,{"$f":"SUM('0:3'!I15)","v":22.9},"l.",null,2.6,45.6,59.54,null,null,null,1.52,2.6,59.54,24.731999999999999,19.785600000000002]
[null,"4.",null,null,{"$f":"SUM('0:3'!E16)","v":0},0,null,{"$f":"SUM('0:3'!I16)","v":0},null,null,null,0,0,null,null,null,null,0,0,0,0]
[null,"5.","Šariš 10˚ fľaša",7,{"$f":"SUM('0:3'!E17)","v":20},27,26,{"$f":"SUM('0:3'!I17)","v":17},"ks.",null,0.8,6.8000000000000007,13.600000000000001,null,null,null,0.34,0.8,13.600000000000001,7.82,6.2560000000000002]
[null,"6.","Kozel 10˚ fľaša",16,{"$f":"SUM('0:3'!E18)","v":20},36,33,{"$f":"SUM('0:3'!I18)","v":17},"ks.",null,0.9,9.3999999999999986,15.3,null,null,null,0.47,0.9,15.3,7.3100000000000005,5.8480000000000008]
[null,"7.","Birell nealko fľaša",61,{"$f":"SUM('0:3'!E19)","v":-20},41,52,{"$f":"SUM('0:3'!I19)","v":11},"ks.",null,1.2,-12.8,13.2,null,null,null,0.64,1.2,13.2,6.1599999999999993,4.9279999999999999]
[null,"8.","Gambrinus fľaša",6,{"$f":"SUM('0:3'!E20)","v":20},26,40,{"$f":"SUM('0:3'!I20)","v":43},"ks.",null,0.9,11.200000000000001,38.700000000000003,null,null,null,0.56000000000000005,0.9,38.700000000000003,14.62,11.696]
[null,"9.","Plzeň 12˚ fľaša",41,{"$f":"SUM('0:3'!E21)","v":0},41,29,{"$f":"SUM('0:3'!I21)","v":36},"ks.",null,1.3,0,46.800000000000004,null,null,null,0.69399999999999995,1.3,46.800000000000004,21.816000000000003,17.452800000000003]
[null,"10.",null,null,{"$f":"SUM('0:3'!E22)","v":0},0,null,{"$f":"SUM('0:3'!I22)","v":0},"ks.",null,null,0,0,null,null,null,null,0,0,0,0]
[null,"11.","Gambrinus plech.",18,{"$f":"SUM('0:3'!E23)","v":0},18,17,{"$f":"SUM('0:3'!I23)","v":13},"ks.",null,0.9,0,11.700000000000001,null,null,null,0.49,0.9,11.700000000000001,5.33,4.2640000000000002]
[null,"12.",null,null,{"$f":"SUM('0:3'!E24)","v":0},0,null,{"$f":"SUM('0:3'!I24)","v":0},"ks.",null,null,0,0,null,null,null,0.42,0,0,0,0]
[null,"13.",null,null,{"$f":"SUM('0:3'!E25)","v":0},0,null,{"$f":"SUM('0:3'!I25)","v":0},"ks.",null,null,0,0,null,null,null,0.75,0,0,0,0]
[null,"14.",null,null,{"$f":"SUM('0:3'!E26)","v":0},0,null,{"$f":"SUM('0:3'!I26)","v":0},null,null,null,0,0,null,null,null,null,0,0,0,0]
[null,"15.","Práznde sudy",null,{"$f":"SUM('0:3'!E27)","v":0},0,null,{"$f":"SUM('0:3'!I27)","v":0},"ks.",null,null,0,0,null,null,null,null,0,0,0,0]
[null,"16.","Práznde fľaše",null,{"$f":"SUM('0:3'!E28)","v":0},0,null,{"$f":"SUM('0:3'!I28)","v":0},"ks.",null,null,0,0,null,null,null,null,0,0,0,0]
[null,"17.",null,null,{"$f":"SUM('0:3'!E29)","v":0},0,null,{"$f":"SUM('0:3'!I29)","v":0},null,null,null,0,0,null,null,null,null,0,0,0,0]
[null,"18.",null,null,{"$f":"SUM('0:3'!E30)","v":0},0,null,{"$f":"SUM('0:3'!I30)","v":0},null,null,null,0,0,null,null,null,null,0,0,0,0]
[null,"19.","Víno biele",54.4,{"$f":"SUM('0:3'!E31)","v":24},78.400000000000006,49.8,{"$f":"SUM('0:3'!I31)","v":15.599999999999998},"l.",null,3,30.96,46.8,null,null,null,1.29,3,46.8,26.675999999999995,21.340799999999998]
[null,"20.","Víno červené",28.4,{"$f":"SUM('0:3'!E32)","v":12},40.4,27.3,{"$f":"SUM('0:3'!I32)","v":7.3999999999999986},"l.",null,3,15.48,22.199999999999996,null,null,null,1.29,3,22.199999999999996,12.653999999999998,10.123199999999999]
[null,"21.",null,null,{"$f":"SUM('0:3'!E33)","v":0},0,null,{"$f":"SUM('0:3'!I33)","v":0},null,null,null,0,0,null,null,null,null,0,0,0,0]
[null,"22.","Vodka",51.1,{"$f":"SUM('0:3'!E34)","v":24},75.099999999999994,43,{"$f":"SUM('0:3'!I34)","v":22.1},"l.",null,12,152.39999999999998,265.20000000000005,null,null,null,6.35,12,265.20000000000005,124.86500000000001,99.89200000000001]
[null,"23.","Borovička",45.2,{"$f":"SUM('0:3'!E35)","v":36},81.2,34.799999999999997,{"$f":"SUM('0:3'!I35)","v":23.200000000000006},"l.",null,12,228.6,278.40000000000009,null,null,null,6.35,12,278.40000000000009,131.08000000000004,104.86400000000003]
[null,"24.","Koniferka",13.15,{"$f":"SUM('0:3'!E36)","v":8.4},21.55,11.4,{"$f":"SUM('0:3'!I36)","v":4.9000000000000012},"l.",null,14,48.972000000000001,68.600000000000023,null,null,null,5.83,14,68.600000000000023,40.033000000000008,32.02640000000001]
[null,"25.","RUM",14.85,{"$f":"SUM('0:3'!E37)","v":6},20.85,11.2,{"$f":"SUM('0:3'!I37)","v":4.3999999999999986},"l.",null,12,34.68,52.799999999999983,null,null,null,5.78,12,52.799999999999983,27.367999999999991,21.894399999999994]
[null,"26.","Hruška",5.45,{"$f":"SUM('0:3'!E38)","v":5},10.45,4.25,{"$f":"SUM('0:3'!I38)","v":2.5000000000000004},"l.",null,14,35.5,35.000000000000007,null,null,null,7.1,14,35.000000000000007,17.250000000000004,13.800000000000004]
[null,"27.","Spišská borovička",0.9,{"$f":"SUM('0:3'!E39)","v":0},0.9,0.3,{"$f":"SUM('0:3'!I39)","v":0.40000000000000036},"l.",null,14,0,5.600000000000005,null,null,null,5.74,14,5.600000000000005,3.3040000000000029,2.6432000000000024]
[null,"28.","Trenčianské hradné",18.350000000000001,{"$f":"SUM('0:3'!E40)","v":12},30.35,15.8,{"$f":"SUM('0:3'!I40)","v":7.8500000000000014},"l.",null,12,74.039999999999992,94.200000000000017,null,null,null,6.17,12,94.200000000000017,45.76550000000001,36.612400000000008]
[null,"29.","Karpatská horká",15.85,{"$f":"SUM('0:3'!E41)","v":0},15.85,12.5,{"$f":"SUM('0:3'!I41)","v":7.45},"l.",null,12,0,89.4,null,null,null,4.92,12,89.4,52.746000000000002,42.196800000000003]
[null,"30.","Vodka Peach",3.15,{"$f":"SUM('0:3'!E42)","v":2},5.15,2.5,{"$f":"SUM('0:3'!I42)","v":2.0999999999999992},"l.",null,14,8.76,29.399999999999988,null,null,null,4.38,14,29.399999999999988,20.201999999999995,16.161599999999996]
[null,"31.","Becherovka",1.95,{"$f":"SUM('0:3'!E43)","v":2},3.95,1.6,{"$f":"SUM('0:3'!I43)","v":1.5999999999999996},"l.",null,20,21.6,31.999999999999993,null,null,null,10.8,20,31.999999999999993,14.719999999999995,11.775999999999996]
[null,"32.","Fernet",3.5,{"$f":"SUM('0:3'!E44)","v":6},9.5,3,{"$f":"SUM('0:3'!I44)","v":2.3000000000000003},"l.",null,20,58.14,46.000000000000007,null,null,null,9.69,20,46.000000000000007,23.713000000000005,18.970400000000005]
[null,"33.","Slivka",2.0499999999999998,{"$f":"SUM('0:3'!E45)","v":0},{"$f":"D45+E45","v":2.0499999999999998},1.75,{"$f":"SUM('0:3'!I45)","v":0.35000000000000053},"l.",null,14,{"$f":"E45*Q45","v":0},{"$f":"H45*K45","v":4.9000000000000075},null,null,null,7.15,{"$f":"K45","v":14},{"$f":"H45*K45","v":4.9000000000000075},{"$f":"(R45-Q45)*H45","v":2.3975000000000035},{"$f":"T45*0.8","v":1.9180000000000028}]
[null,"34.","Bošácka slivovica",3.25,{"$f":"SUM('0:3'!E46)","v":5},8.25,2.7,{"$f":"SUM('0:3'!I46)","v":1.3000000000000003},"l.",null,24,84.55,31.200000000000006,null,null,null,16.91,24,31.200000000000006,9.2170000000000023,7.3736000000000024]
[null,"35.","Karpatská KB",null,{"$f":"SUM('0:3'!E47)","v":0},0,null,{"$f":"SUM('0:3'!I47)","v":0},"l.",null,20,0,0,null,null,null,5.9980000000000002,20,0,0,0]
[null,"36.","Fernet Citrus",null,{"$f":"SUM('0:3'!E48)","v":0},0,null,{"$f":"SUM('0:3'!I48)","v":0},"l.",null,20,0,0,null,null,null,9.69,20,0,0,0]
[null,"37.","Pepermint",4.3,{"$f":"SUM('0:3'!E49)","v":3},7.3,4.25,{"$f":"SUM('0:3'!I49)","v":1.1499999999999995},"l.",null,12,15.24,13.799999999999994,null,null,null,5.08,12,13.799999999999994,7.9579999999999966,6.3663999999999978]
[null,"38.","Nicolaus vodka",1.45,{"$f":"SUM('0:3'!E50)","v":3},4.45,0.75,{"$f":"SUM('0:3'!I50)","v":1.0000000000000002},"l.",null,18,14.700000000000001,18.000000000000004,null,null,null,4.9000000000000004,18,18.000000000000004,13.100000000000003,10.480000000000004]
[null,"39.","Captain Morgan",2.35,{"$f":"SUM('0:3'!E51)","v":0},2.35,2.35,{"$f":"SUM('0:3'!I51)","v":0.70000000000000018},"l.",null,24,0,16.800000000000004,null,null,null,11.45,24,16.800000000000004,8.7850000000000019,7.0280000000000022]
[null,"40.",null,null,{"$f":"SUM('0:3'!E52)","v":0},0,null,{"$f":"SUM('0:3'!I52)","v":0},null,null,null,0,0,null,null,null,null,0,0,0,0]
[null,"41.",null,null,{"$f":"SUM('0:3'!E53)","v":0},0,null,{"$f":"SUM('0:3'!I53)","v":0},null,null,null,0,0,null,null,null,null,0,0,0,0]
[null,"42.","PEPSI + 7UP 0,5l",9,{"$f":"SUM('0:3'!E65)","v":0},9,9,{"$f":"SUM('0:3'!I65)","v":0},"ks.",null,1.1000000000000001,0,0,null,null,null,0.78,1.1000000000000001,0,0,0]
[null,"43.","Sprite +Tonic",34.6,{"$f":"SUM('0:3'!E66)","v":0},34.6,32.299999999999997,{"$f":"SUM('0:3'!I66)","v":7.4},"ks.",null,2,0,14.8,null,null,null,0.72599999999999998,2,14.8,9.4276,7.5420800000000003]
[null,"44.","Minerálka 0,5l",19,{"$f":"SUM('0:3'!E67)","v":36},55,17,{"$f":"SUM('0:3'!I67)","v":36},"ks.",null,0.9,19.008000000000003,32.4,null,null,null,0.52800000000000002,0.9,32.4,13.391999999999999,10.7136]
[null,"45.","Kofola 0,5l",6,{"$f":"SUM('0:3'!E68)","v":0},6,17,{"$f":"SUM('0:3'!I68)","v":6},"ks.",null,1.1000000000000001,0,6.6000000000000005,null,null,null,0.49,1.1000000000000001,6.6000000000000005,3.6600000000000006,2.9280000000000008]
[null,"46.","Džús krabička",48,{"$f":"SUM('0:3'!E69)","v":0},48,41,{"$f":"SUM('0:3'!I69)","v":9},"ks.",null,0.5,0,4.5,null,null,null,0.17,0.5,4.5,2.9699999999999998,2.3759999999999999]
[null,"47.","Energetický nápoj",18,{"$f":"SUM('0:3'!E70)","v":-2},16,18,{"$f":"SUM('0:3'!I70)","v":0},"ks.",null,1.8,-0.5,0,null,null,null,0.25,1.8,0,0,0]
[null,"48.","Limo 0,33l fľaša",30,{"$f":"SUM('0:3'!E71)","v":20},50,30,{"$f":"SUM('0:3'!I71)","v":28},"ks.",null,0.5,2,14,null,null,null,0.1,0.5,14,11.200000000000001,8.9600000000000009]
[null,"49.","Minerálka 2l",30,{"$f":"SUM('0:3'!E72)","v":0},30,25.7,{"$f":"SUM('0:3'!I72)","v":12.5},"l.",null,1.5,0,18.75,null,null,null,0.23,1.5,18.75,15.875,12.700000000000001]
[null,"50.","Relax džús fľaška",41,{"$f":"SUM('0:3'!E73)","v":48},89,36,{"$f":"SUM('0:3'!I73)","v":10},"ks.",null,1,22.080000000000002,10,null,null,null,0.46,1,10,5.4,4.32]
[null,"51.","Ďžús nalievaný",11.2,{"$f":"SUM('0:3'!E74)","v":0},11.2,9,{"$f":"SUM('0:3'!I74)","v":3.4000000000000021},"l.",null,3,0,10.200000000000006,null,null,null,1.1879999999999999,3,10.200000000000006,6.1608000000000036,4.9286400000000032]
[null,"52.","Toma",3,{"$f":"SUM('0:3'!E75)","v":0},3,15,{"$f":"SUM('0:3'!I75)","v":6},"l.",null,1.1000000000000001,0,6.6000000000000005,null,null,null,0.33,1.1000000000000001,6.6000000000000005,4.62,3.6960000000000002]
[null,"53.","HELLO Jupík",20,{"$f":"SUM('0:3'!E65)","v":0},20,17,{"$f":"SUM('0:3'!I76)","v":3},"ks.",null,0.8,0,2.4000000000000004,null,null,null,0.17599999999999999,0.8,2.4000000000000004,1.8720000000000003,1.4976000000000003]
[null,"54.","COCA COLA",7,{"$f":"SUM('0:3'!E66)","v":0},7,19,{"$f":"SUM('0:3'!I77)","v":5},"ks.",null,1.1000000000000001,0,5.5,null,null,null,0.624,1.1000000000000001,5.5,2.3800000000000003,1.9040000000000004]
[null,"55.","Vinea",1,{"$f":"SUM('0:3'!E67)","v":36},37,25,{"$f":"SUM('0:3'!I78)","v":6},"ks.",null,1.1000000000000001,18.143999999999998,6.6000000000000005,null,null,null,0.504,1.1000000000000001,6.6000000000000005,3.5760000000000005,2.8608000000000007]
[null,"56.","ALOE VERA",7,{"$f":"SUM('0:3'!E68)","v":0},7,7,{"$f":"SUM('0:3'!I79)","v":5},"ks.",null,1.2,0,6,null,null,null,0.64,1.2,6,2.8,2.2399999999999998]
[null,"57.",null,null,{"$f":"SUM('0:3'!E69)","v":0},0,null,{"$f":"SUM('0:3'!I80)","v":0},null,null,null,0,0,null,null,null,null,0,0,0,0]
[null,"58.","Káva turecká",500,{"$f":"SUM('0:3'!E70)","v":-2},498,900,{"$f":"SUM('0:3'!I81)","v":54.285714285714285},"gr.",null,0.5,-6.8000000000000005E-2,27.142857142857142,null,null,null,3.4000000000000002E-2,0.5,{"$f":"M70","v":27.142857142857142},25.297142857142855,20.237714285714286]
[null,"59.","Nescafé 3v1",34,{"$f":"SUM('0:3'!E71)","v":20},54,31,{"$f":"SUM('0:3'!I82)","v":6},"ks.",null,0.5,2.8000000000000003,3,null,null,null,0.14000000000000001,0.5,{"$f":"H71*K71","v":3},2.16,1.7280000000000002]
[null,"60.","Čaj",74,{"$f":"SUM('0:3'!E72)","v":0},74,64,{"$f":"SUM('0:3'!I83)","v":4},"ks.",null,0.5,0,2,null,null,null,5.8000000000000003E-2,0.5,2,1.768,1.4144000000000001]
[null,"61.","Mlieko do kávy",43,{"$f":"SUM('0:3'!E73)","v":48},91,38,{"$f":"SUM('0:3'!I84)","v":15},"ks.",null,0.1,1.7279999999999998,1.5,null,null,null,3.5999999999999997E-2,0.1,1.5,0.96,0.76800000000000002]
[null,"62.","Cukor HB",914,{"$f":"SUM('0:3'!E74)","v":0},914,858,{"$f":"SUM('0:3'!I85)","v":111},"ks.",null,0.05,0,5.5500000000000007,null,null,null,8.0000000000000002E-3,0.05,5.5500000000000007,4.6619999999999999,3.7296]
[null,"63.",null,null,{"$f":"SUM('0:3'!E75)","v":0},0,null,{"$f":"SUM('0:3'!I86)","v":0},null,null,null,0,0,null,null,null,null,0,0,0,0]
[null,"64.",null,null,{"$f":"SUM('0:3'!E76)","v":6},6,null,{"$f":"SUM('0:3'!I87)","v":0},null,null,null,0,0,null,null,null,null,0,0,0,0]
[null,"65.",null,null,{"$f":"SUM('0:3'!E77)","v":0},{"$f":"D77+E77","v":0},null,{"$f":"SUM('0:3'!I88)","v":0},null,null,null,{"$f":"E77*Q77","v":0},{"$f":"H77*K77","v":0},null,null,null,null,{"$f":"K77","v":0},0,{"$f":"(R77-Q77)*H77","v":0},{"$f":"T77*0.8","v":0}]
[null,"66.","Golden",44,{"$f":"SUM('0:3'!E78)","v":6},50,36,{"$f":"SUM('0:3'!I89)","v":37},"ks.",null,3.4,18.240000000000002,125.8,null,null,null,3.04,3.4,125.8,13.319999999999995,10.655999999999997]
[null,"67.","Petra 3,40€",22,{"$f":"SUM('0:3'!E79)","v":24},46,18,{"$f":"SUM('0:3'!I90)","v":15},"ks.",null,3.4,76.800000000000011,51,null,null,null,3.2,3.4,51,2.999999999999996,2.3999999999999968]
[null,"68.","Malboro 3,70€",9,{"$f":"SUM('0:3'!E80)","v":0},9,8,{"$f":"SUM('0:3'!I91)","v":28},"ks.",null,3.7,0,103.60000000000001,null,null,null,2.95,3.7,103.60000000000001,21,16.8]
[null,"69.","LM 3,40€",58,{"$f":"SUM('0:3'!E81)","v":500},558,40,{"$f":"SUM('0:3'!I92)","v":59},"ks.",null,3.4,1520,200.6,null,null,null,3.04,3.4,200.6,21.239999999999991,16.991999999999994]
[null,"70.","Mars",12,{"$f":"SUM('0:3'!E82)","v":0},12,10,{"$f":"SUM('0:3'!I93)","v":6},"ks.",null,3.4,0,20.399999999999999,null,null,null,3.04,3.4,20.399999999999999,2.1599999999999993,1.7279999999999995]
[null,"71.","West",33,{"$f":"SUM('0:3'!E83)","v":0},33,17,{"$f":"SUM('0:3'!I94)","v":32},"ks.",null,3.2,0,102.4,null,null,null,2.94,3.2,102.4,8.3200000000000074,6.6560000000000059]
[null,"72.",null,null,{"$f":"SUM('0:3'!E84)","v":100},100,null,{"$f":"SUM('0:3'!I95)","v":0},null,null,null,0,0,null,null,null,null,0,0,0,0]
[null,"73.","Malboro 4,00€",null,{"$f":"SUM('0:3'!E85)","v":950},950,null,{"$f":"SUM('0:3'!I96)","v":0},"ks.",null,4,3705,0,null,null,null,3.9,4,0,0,0]
[null,"74.",null,null,{"$f":"SUM('0:3'!E86)","v":0},0,null,{"$f":"SUM('0:3'!I97)","v":0},null,null,null,0,0,null,null,null,null,0,0,0,0]
[null,"75.",null,null,{"$f":"SUM('0:3'!E87)","v":0},0,null,{"$f":"SUM('0:3'!I98)","v":0},null,null,null,0,0,null,null,null,null,0,0,0,0]
[null,"76.",null,null,{"$f":"SUM('0:3'!E88)","v":0},0,null,{"$f":"SUM('0:3'!I99)","v":0},null,null,null,0,0,null,null,null,null,0,0,0,0]
[null,"77.","Hyg. vreckovky",31,{"$f":"SUM('0:3'!E89)","v":60},91,27,{"$f":"SUM('0:3'!I100)","v":8},"ks.",null,0.2,5.34,1.6,null,null,null,8.8999999999999996E-2,0.2,1.6,0.88800000000000012,0.71040000000000014]
[null,"78.","Zapaľovač",61,{"$f":"SUM('0:3'!E90)","v":20},81,59,{"$f":"SUM('0:3'!I101)","v":8},"ks.",null,0.5,3.4000000000000004,4,null,null,null,0.17,0.5,4,2.6399999999999997,2.1119999999999997]
[null,"79.","Zápalky",83,{"$f":"SUM('0:3'!E91)","v":20},103,81,{"$f":"SUM('0:3'!I102)","v":3},"ks.",null,0.1,0.8,0.30000000000000004,null,null,null,0.04,0.1,0.30000000000000004,0.18000000000000002,0.14400000000000002]
[null,"80.",null,null,{"$f":"SUM('0:3'!E92)","v":60},60,null,{"$f":"SUM('0:3'!I103)","v":0},null,null,null,0,0,null,null,null,null,0,0,0,0]
[null,"81.",null,null,{"$f":"SUM('0:3'!E93)","v":10},10,null,{"$f":"SUM('0:3'!I104)","v":0},null,null,null,0,0,null,null,null,null,0,0,0,0]
[null,"82.",null,null,{"$f":"SUM('0:3'!E94)","v":59},59,null,{"$f":"SUM('0:3'!I105)","v":0},null,null,null,0,0,null,null,null,null,0,0,0,0]
[null,"83.","Kinderko",4,{"$f":"SUM('0:3'!E95)","v":0},4,2,{"$f":"SUM('0:3'!I117)","v":0},"ks.",null,1.2,0,0,null,null,null,0.73,1.2,0,0,0]
[null,"84.","Horalka",32,{"$f":"SUM('0:3'!E96)","v":0},32,26,{"$f":"SUM('0:3'!I118)","v":14},"ks.",null,0.6,0,8.4,null,null,null,0.26,0.6,8.4,4.76,3.8079999999999998]
[null,"85.","Kávenky",14,{"$f":"SUM('0:3'!E97)","v":0},14,13,{"$f":"SUM('0:3'!I119)","v":2},"ks.",null,0.6,0,1.2,null,null,null,0.25,0.6,1.2,0.7,0.55999999999999994]
[null,"86.","Kinder čokoláda",4,{"$f":"SUM('0:3'!E98)","v":0},4,4,{"$f":"SUM('0:3'!I120)","v":4},"ks.",null,1.5,0,6,null,null,null,0.9,1.5,6,2.4,1.92]
[null,"87.","3-BIT",4,{"$f":"SUM('0:3'!E99)","v":0},4,4,{"$f":"SUM('0:3'!I121)","v":1},"ks.",null,0.6,0,0.6,null,null,null,0.32,0.6,0.6,0.27999999999999997,0.22399999999999998]
[null,"88.","Banán",9,{"$f":"SUM('0:3'!E100)","v":0},9,9,{"$f":"SUM('0:3'!I122)","v":8},"ks.",null,0.6,0,4.8,null,null,null,0.26,0.6,4.8,2.7199999999999998,2.1759999999999997]
[null,"89.","Margot",3,{"$f":"SUM('0:3'!E101)","v":0},3,42,{"$f":"SUM('0:3'!I123)","v":5},"ks.",null,0.6,0,3,null,null,null,0.4,0.6,3,0.99999999999999978,0.79999999999999982]
[null,"90.","Lízatko 2",30,{"$f":"SUM('0:3'!E102)","v":0},30,30,{"$f":"SUM('0:3'!I124)","v":0},"ks.",null,0.2,0,0,null,null,null,0.04,0.2,0,0,0]
[null,"91.","Mila",25,{"$f":"SUM('0:3'!E103)","v":0},25,24,{"$f":"SUM('0:3'!I125)","v":9},"ks.",null,0.6,0,5.3999999999999995,null,null,null,0.33,0.6,{"$f":"H103*K103","v":5.3999999999999995},2.4299999999999997,1.944]
[null,"92.","Lízatko",20,{"$f":"SUM('0:3'!E104)","v":0},20,115,{"$f":"SUM('0:3'!I126)","v":10},"ks.",null,0.3,0,3,null,null,null,0.1,0.3,3,1.9999999999999998,1.5999999999999999]
[null,"93.","Chipsy",38,{"$f":"SUM('0:3'!E105)","v":0},38,24,{"$f":"SUM('0:3'!I127)","v":20},"ks.",null,1,0,20,null,null,null,0.42,1,20,11.600000000000001,9.2800000000000011]
[null,"94.","Tofife",11,{"$f":"SUM('0:3'!E128)","v":0},11,11,{"$f":"SUM('0:3'!I128)","v":0},"ks.",null,2.6,0,0,null,null,null,1.62,2.6,0,0,0]
[null,"95.","Milka čok.",3,{"$f":"SUM('0:3'!E129)","v":5},8,3,{"$f":"SUM('0:3'!I129)","v":2},"ks.",null,1.5,3.65,3,null,null,null,0.73,1.5,3,1.54,1.2320000000000002]
[null,"96.","Tyčinky DRU",10,{"$f":"SUM('0:3'!E130)","v":0},10,7,{"$f":"SUM('0:3'!I130)","v":2},"ks.",null,0.5,0,1,null,null,null,0.23,0.5,1,0.54,0.43200000000000005]
[null,"97.","Arašidy",4,{"$f":"SUM('0:3'!E131)","v":0},{"$f":"D109+E109","v":4},4,{"$f":"SUM('0:3'!I131)","v":0},"ks.",null,0.8,{"$f":"E109*Q109","v":0},{"$f":"H109*K109","v":0},null,null,null,0.33,{"$f":"K109","v":0.8},0,{"$f":"(R109-Q109)*H109","v":0},{"$f":"T109*0.8","v":0}]
[null,"98.","TIC-TAC",59,{"$f":"SUM('0:3'!E132)","v":0},59,55,{"$f":"SUM('0:3'!I132)","v":7},"ks.",null,0.6,0,4.2,null,null,null,0.3,0.6,4.2,2.1,1.6800000000000002]
[null,"99.","Žuvažky plátky",132,{"$f":"SUM('0:3'!E133)","v":0},132,130,{"$f":"SUM('0:3'!I133)","v":16},"ks.",null,0.1,0,1.6,null,null,null,5.1999999999999998E-2,0.1,1.6,0.76800000000000013,0.61440000000000017]
[null,"100.","Žuvažky dražé",35,{"$f":"SUM('0:3'!E134)","v":60},95,31,{"$f":"SUM('0:3'!I134)","v":14},"ks.",null,0.6,22.2,8.4,null,null,null,0.37,0.6,8.4,3.2199999999999998,2.5760000000000001]
[null,"101.","Hašlerky",4,{"$f":"SUM('0:3'!E135)","v":0},4,4,{"$f":"SUM('0:3'!I135)","v":0},"ks.",null,0.9,0,0,null,null,null,0.54,0.9,0,0,0]
[null,"102.","Žuvačky guličky",2,{"$f":"SUM('0:3'!E136)","v":0},2,42,{"$f":"SUM('0:3'!I136)","v":4},"ks.",null,0.7,0,2.8,null,null,null,0.3,0.7,2.8,1.5999999999999999,1.28]
[null,"103.","Chrumky",null,{"$f":"SUM('0:3'!E137)","v":0},0,null,{"$f":"SUM('0:3'!I137)","v":0},"ks.",null,0.6,0,0,null,null,null,0.27,0.6,0,0,0]
[null,"104.",null,null,{"$f":"SUM('0:3'!E138)","v":0},0,null,{"$f":"SUM('0:3'!I138)","v":0},null,null,null,0,0,null,null,null,null,0,0,0,0]
[null,"105.",null,null,{"$f":"SUM('0:3'!E117)","v":0},0,null,{"$f":"SUM('0:3'!I139)","v":0},null,null,null,0,0,null,null,null,null,0,0,0,0]
[null,"106.",null,null,{"$f":"SUM('0:3'!E118)","v":0},0,null,{"$f":"SUM('0:3'!I140)","v":0},null,null,null,0,0,null,null,null,null,0,0,0,0]
[null,"107.",null,null,{"$f":"SUM('0:3'!E119)","v":0},0,null,{"$f":"SUM('0:3'!I141)","v":0},null,null,null,0,0,null,null,null,null,0,0,0,0]
[null,"108.",null,null,{"$f":"SUM('0:3'!E120)","v":0},0,null,{"$f":"SUM('0:3'!I142)","v":0},null,null,null,0,0,null,null,null,null,0,0,0,0]
[null,null,null,null,{"$f":"SUM('0:3'!E121)","v":0}]
[null,null,null,{"$f":"SUM(D95:D120)","v":443},null,null,{"$f":"SUM(G95:G120)","v":580},null,null,null,"Celkom:",{"$f":"SUM(L13:L120)","v":6343.8839999999991},{"$f":"SUM(M13:M120)","v":2843.7828571428577},null,null,null,null,"Celkom:",{"$f":"SUM(S13:S120)","v":2843.7828571428577},{"$f":"SUM(T13:T120)","v":1272.1700428571435},{"$f":"SUM(U13:U120)","v":1017.7360342857146}]
[null,null,null,null,null,{"$f":"SUM(F119:F121)","v":0},null,null,null,null,{"$f":"SUM(K119:K121)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(T119:T121)","v":0},{"$f":"SUM(U119:U121)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Zisk bez výdavkov:",{"$f":"M122-L122","v":-3500.1011428571414}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"SUM('0:3'!E140)","v":0}]
[null,null,null,null,{"$f":"SUM('0:3'!E141)","v":0}]
[null,null,null,null,{"$f":"SUM('0:3'!E142)","v":0},null,null,null,{"$f":"SUM('0:3'!I142)","v":0}]

{"sheet":"Inventár","index":4,"n_rows":153,"n_cols":5,"rows_kept":153,"cut":false,"hidden":false,"merged":[[0,2,0,3],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4]]}
[null,"Inventár","Apríl",null,2019]
[]
[]
[null,"Názov  tovaru","Zostatok v sklade","J.M.","Suma tovaru"]
[]
[null,"Pernštejn čap. 10˚",194.4,"l.",200.6208]
[null,"Malinovka čap.",161.19999999999999,"l.",79.471599999999995]
[null,"Radler čap.",30,"l.",45.6]
[null,null,null,null,0]
[null,"Šariš 10˚ fľaša",39,"ks.",13.260000000000002]
[null,"Kozel 10˚ fľaša",16,"ks.",7.52]
[null,"Birell nealko fľaša",65,"ks.",41.6]
[null,"Gambrinus fľaša",39,"ks.",21.840000000000003]
[null,"Plzeň 12˚ fľaša",35,"ks.",24.29]
[null,null,null,"ks.",0]
[null,"Gambrinus plech.",11,"ks.",5.39]
[null,null,null,"ks.",0]
[null,null,null,"ks.",0]
[null,null,null,null,0]
[null,"Práznde sudy",null,"ks.",0]
[null,"Práznde fľaše",null,"ks.",0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,"Víno biele",32.200000000000003,"l.",41.538000000000004]
[null,"Víno červené",14.9,"l.",19.221]
[null,null,null,null,0]
[null,"Vodka",40.1,"l.",254.63499999999999]
[null,"Borovička",73.849999999999994,"l.",468.94749999999993]
[null,"Koniferka",12.65,"l.",73.749499999999998]
[null,"RUM",12.5,"l.",72.25]
[null,"Hruška",6.9,"l.",48.99]
[null,"Spišská borovička",3.15,"l.",27.247499999999999]
[null,"Trenčianské hradné",20.45,"l.",126.17649999999999]
[null,"Karpatská horká",18.350000000000001,"l.",90.282000000000011]
[null,"Vodka Peach",6.6,"l.",29.105999999999998]
[null,"Becherovka",5.45,"l.",58.151499999999999]
[null,"Fernet",6,"l.",58.14]
[null,"Slivka",2.85,"l.",20.548500000000001]
[null,"Bošácka slivovica",4.75,"l.",80.322500000000005]
[null,"Karpatská KB",null,"l.",0]
[null,"Fernet Citrus",null,"l.",0]
[null,"Pepermint",4.5999999999999996,"l.",23.367999999999999]
[null,"Nicolaus vodka",2.85,"l.",24.538499999999999]
[null,"Captain Morgan",0.8,"l.",9.16]
[null,null,null,null,0]
[null,null,null,null,0]
[null,"PEPSI + 7UP 0,5l",null,"ks.",0]
[null,"Sprite +Tonic",3.7,"ks.",2.6861999999999999]
[null,"Minerálka 0,5l",31,"ks.",16.368000000000002]
[null,"Kofola 0,5l",22,"ks.",10.78]
[null,"Džús krabička",61,"ks.",10.370000000000001]
[null,"Energetický nápoj",12,"ks.",3]
[null,"Limo 0,33l fľaša",38,"ks.",3.8000000000000003]
[null,"Minerálka 2l",30.6,"l.",7.0380000000000003]
[null,"Relax džús fľaška",59,"ks.",32.450000000000003]
[null,"Ďžús nalievaný",9.3000000000000007,"ks.",11.048400000000001]
[null,"Toma",34,"l.",11.22]
[null,"HELLO Jupík",26,"ks.",8.58]
[null,"COCA COLA",16,"ks.",9.984]
[null,"Vinea",28,"ks.",14.112]
[null,"ALOE VERA",2,"ks.",1.28]
[null,null,null,null,0]
[null,"Káva turecká",900,"gr.",30.6]
[null,"Nescafé 3v1",60,"ks.",8.4]
[null,"Čaj",135,"ks.",4.8599999999999994]
[null,"Mlieko do kávy",76,"ks.",0.60799999999999998]
[null,"Cukor HB",1181,"ks.",0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,"ks.",0]
[null,"Golden",24,"ks.",77.28]
[null,"Petra 3,40€",19,"ks.",61.37]
[null,"Malboro 3,70€",19,"ks.",66.69]
[null,"LM 3,40€",97,"ks.",313.31]
[null,"Mars",10,"ks.",32.200000000000003]
[null,"West",34,"ks.",103.36]
[null,null,null,"ks.",0]
[null,"Malboro 4,00€",null,"ks.",0]
[null,null,null,"ks.",0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,"Hyg. vreckovky",46,"ks.",4.0939999999999994]
[null,"Zapaľovač",72,"ks.",12.24]
[null,"Zápalky",42,"ks.",1.68]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,"Kinderko",16,"ks.",14.88]
[null,"Horalka",36,"ks.",11.16]
[null,"Kávenky",19,"ks.",5.32]
[null,"Kinder čokoláda",9,"ks.",8.1]
[null,"3-BIT",10,"ks.",3.2]
[null,"Banán",15,"ks.",4.95]
[null,"Margot",10,"ks.",4]
[null,"Lízatko 2",9,"ks.",0.36]
[null,"Mila",24,"ks.",8.3999999999999986]
[null,"Lízatko",81,"ks.",8.1]
[null,"Chipsy",32,"ks.",13.44]
[null,"Tofife",9,"ks.",14.580000000000002]
[null,"Milka čok.",9,"ks.",6.57]
[null,"Tyčinky DRU",13,"ks.",2.99]
[null,"Arašidy",2,"ks.",0.66]
[null,"TIC-TAC",25,"ks.",7.5]
[null,"Žuvažky plátky",155,"ks.",8.06]
[null,"Žuvažky dražé",40,"ks.",14.8]
[null,"Hašlerky",2,"ks.",1.08]
[null,"Žuvačky guličky",33,"ks.",9.9]
[null,"Chrumky",null,"ks.",0]
[null,null,null,"ks.",0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Celkom:",{"$f":"SUBTOTAL(9,E6:E150)","v":2973.4229999999998}]

{"sheet":"Sklad","index":5,"n_rows":56,"n_cols":10,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,3,0,4],[0,1,0,2],[0,6,0,8],[55,1,55,2],[55,3,55,6],[55,7,55,9]]}
[null,"Evidencia skladu 2019",null,"Meno:",null,null,"Dátum:",null,null,"/2019"]
[]
[null,"Názov tovaru","Sklad","Predajňa","Spolu",null,"Názov tovaru","Sklad","Predajňa","Spolu"]
[null,{"$f":"Originál!C13","v":"Pernštejn čap. 10˚"},null,null,null,null,{"$f":"Originál!C81","v":"Káva turecká"}]
[null,{"$f":"Originál!C14","v":"Malinovka čap."},null,null,null,null,{"$f":"Originál!C82","v":"Nescafé 3v1"}]
[null,{"$f":"Originál!C15","v":"Radler čap."},null,null,null,null,{"$f":"Originál!C83","v":"Čaj"}]
[null,null,null,null,null,null,{"$f":"Originál!C84","v":"Mlieko do kávy"}]
[null,{"$f":"Originál!C17","v":"Šariš 10˚ fľaša"},null,null,null,null,{"$f":"Originál!C85","v":"Cukor HB"}]
[null,{"$f":"Originál!C18","v":"Kozel 10˚ fľaša"}]
[null,{"$f":"Originál!C19","v":"Birell nealko fľaša"},null,null,null,null,{"$f":"Originál!C89","v":"Golden"}]
[null,{"$f":"Originál!C20","v":"Gambrinus fľaša"},null,null,null,null,{"$f":"Originál!C90","v":"Petra 3,40€"}]
[null,{"$f":"Originál!C21","v":"Plzeň 12˚ fľaša"},null,null,null,null,{"$f":"Originál!C91","v":"Malboro 3,70€"}]
[null,{"$f":"Originál!C23","v":"Gambrinus plech."},null,null,null,null,{"$f":"Originál!C92","v":"LM 3,40€"}]
[null,null,null,null,null,null,{"$f":"Originál!C93","v":"Mars"}]
[null,{"$f":"Originál!C27","v":"Práznde sudy"},null,null,null,null,{"$f":"Originál!C94","v":"West"}]
[null,{"$f":"Originál!C28","v":"Práznde fľaše"},null,null,null,null,{"$f":"Originál!C96","v":"Malboro 4,00€"}]
[]
[null,{"$f":"Originál!C31","v":"Víno biele"}]
[null,{"$f":"Originál!C32","v":"Víno červené"},null,null,null,null,{"$f":"Originál!C100","v":"Hyg. vreckovky"}]
[null,null,null,null,null,null,{"$f":"Originál!C101","v":"Zapaľovač"}]
[null,{"$f":"Originál!C34","v":"Vodka"},null,null,null,null,{"$f":"Originál!C102","v":"Zápalky"}]
[null,{"$f":"Originál!C35","v":"Borovička"}]
[null,{"$f":"Originál!C36","v":"Koniferka"},null,null,null,null,{"$f":"Originál!C117","v":"Kinderko"}]
[null,{"$f":"Originál!C37","v":"RUM"},null,null,null,null,{"$f":"Originál!C118","v":"Horalka"}]
[null,{"$f":"Originál!C38","v":"Hruška"},null,null,null,null,{"$f":"Originál!C119","v":"Kávenky"}]
[null,{"$f":"Originál!C39","v":"Spišská borovička"},null,null,null,null,{"$f":"Originál!C120","v":"Kinder čokoláda"}]
[null,{"$f":"Originál!C40","v":"Trenčianské hradné"},null,null,null,null,{"$f":"Originál!C121","v":"3-BIT"}]
[null,{"$f":"Originál!C41","v":"Karpatská horká"},null,null,null,null,{"$f":"Originál!C122","v":"Banán"}]
[null,{"$f":"Originál!C42","v":"Vodka Peach"},null,null,null,null,{"$f":"Originál!C123","v":"Margot"}]
[null,{"$f":"Originál!C43","v":"Becherovka"},null,null,null,null,{"$f":"Originál!C124","v":"Lízatko 2"}]
[null,{"$f":"Originál!C44","v":"Fernet"},null,null,null,null,{"$f":"Originál!C125","v":"Mila"}]
[null,{"$f":"Originál!C45","v":"Slivka"},null,null,null,null,{"$f":"Originál!C126","v":"Lízatko"}]
[null,{"$f":"Originál!C46","v":"Bošácka slivovica"},null,null,null,null,{"$f":"Originál!C127","v":"Chipsy"}]
[null,{"$f":"Originál!C47","v":"Karpatská KB"},null,null,null,null,{"$f":"Originál!C128","v":"Tofife"}]
[null,{"$f":"Originál!C48","v":"Fernet Citrus"},null,null,null,null,{"$f":"Originál!C129","v":"Milka čok."}]
[null,{"$f":"Originál!C49","v":"Pepermint"},null,null,null,null,{"$f":"Originál!C130","v":"Tyčinky DRU"}]
[null,{"$f":"Originál!C50","v":"Nicolaus vodka"},null,null,null,null,{"$f":"Originál!C131","v":"Arašidy"}]
[null,{"$f":"Originál!C51","v":"Captain Morgan"},null,null,null,null,{"$f":"Originál!C132","v":"TIC-TAC"}]
[null,null,null,null,null,null,{"$f":"Originál!C133","v":"Žuvažky plátky"}]
[null,{"$f":"Originál!C65","v":"PEPSI + 7UP 0,5l"},null,null,null,null,{"$f":"Originál!C134","v":"Žuvažky dražé"}]
[null,{"$f":"Originál!C66","v":"Sprite +Tonic"},null,null,null,null,{"$f":"Originál!C135","v":"Hašlerky"}]
[null,{"$f":"Originál!C67","v":"Minerálka 0,5l"},null,null,null,null,{"$f":"Originál!C136","v":"Žuvačky guličky"}]
[null,{"$f":"Originál!C68","v":"Kofola 0,5l"},null,null,null,null,{"$f":"Originál!C137","v":"Chrumky"}]
[null,{"$f":"Originál!C69","v":"Džús krabička"}]
[null,{"$f":"Originál!C70","v":"Energetický nápoj"}]
[null,{"$f":"Originál!C71","v":"Limo 0,33l fľaša"}]
[null,{"$f":"Originál!C72","v":"Minerálka 2l"}]
[null,{"$f":"Originál!C73","v":"Relax džús fľaška"}]
[null,{"$f":"Originál!C74","v":"Ďžús nalievaný"}]
[null,{"$f":"Originál!C75","v":"Toma"}]
[null,{"$f":"Originál!C76","v":"HELLO Jupík"}]
[null,{"$f":"Originál!C77","v":"COCA COLA"}]
[null,{"$f":"Originál!C78","v":"Vinea"}]
[null,{"$f":"Originál!C79","v":"ALOE VERA"}]
[]
[null,"Výdavky:",null,"Stávková:",null,null,null,"Hotovosť:"]

{"sheet":"0","index":6,"n_rows":158,"n_cols":22,"rows_kept":158,"cut":false,"hidden":false,"merged":[[148,3,148,4],[155,3,155,4],[156,3,156,4],[157,3,157,4],[114,17,115,17],[114,21,115,21],[146,3,146,4],[147,3,147,4],[114,8,115,8],[114,9,115,9],[114,10,115,10],[114,14,115,14],[114,15,115,15],[114,16,115,16],[62,20,63,20],[62,21,63,21],[114,1,115,1],[114,2,115,2],[114,3,115,3],[114,4,115,4],[114,5,115,5],[114,6,115,6],[62,8,63,8],[62,9,63,9],[62,10,63,10],[62,14,63,14],[62,15,63,15],[62,16,63,16],[114,18,115,18],[114,20,115,20],[62,1,63,1],[62,2,63,2],[62,3,63,3],[62,4,63,4],[62,5,63,5],[62,6,63,6],[10,15,11,15],[10,16,11,16],[10,17,11,17],[10,18,11,18],[62,17,63,17],[62,18,63,18],[10,20,11,20],[10,21,11,21],[10,6,11,6],[10,8,11,8],[10,9,11,9],[10,10,11,10],[10,11,11,11],[10,14,11,14],[0,6,0,8],[0,14,0,17],[1,15,1,16],[4,7,4,9],[6,7,6,8],[10,1,11,1],[10,2,11,2],[10,3,11,3],[10,4,11,4],[10,5,11,5]]}
[null,null,null,"Vyučtovanie výčapu ",null,null,"august",null,null,"/2019",null,null,null,null,"Denný sumár"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Juniorka","Meno:",{"$f":"I2","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Šipulová","Dátum:",{"$f":"I3","v":0},"/2019"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Hermanová"]
[null,null,null,null,null,null,"Meno:"]
[]
[null,null,null,null,null,null,"Dátum:",null,null,"/2019"]
[]
[]
[null,null,"Strana 1:",null,null,null,null,null,null,null,null,null,null,null,"Strana 1:"]
[null,"P.Č.","Názov  tovaru","Poč. stav","Denný príjem","Spolu","Zostatok v sklade",null,"Denný predaj","Cena €","Suma celkom €","J.M.",null,null,"Nákupná cena","Predajná cena","Tržba","Zisk","Zisk po zdanení",null,"Zostatok v krčme","Suma tovaru"]
[]
[null,"1.","Pernštejn čap. 10˚",332.3,null,{"$f":"D13+E13","v":332.3},289.8,null,{"$f":"D13+E13-G13","v":42.5},2,{"$f":"I13*J13","v":85},"l.",null,null,1.032,{"$f":"J13","v":2},{"$f":"I13*J13","v":85},{"$f":"(P13-O13)*I13","v":41.14},{"$f":"R13*0.8","v":32.911999999999999},null,{"$f":"G13","v":289.8},{"$f":"U13*O13","v":299.0736}]
[null,"2.","Malinovka čap.",146.6,null,146.6,116.3,null,30.299999999999997,2,{"$f":"I14*J14","v":60.599999999999994},"l.",null,null,0.49299999999999999,{"$f":"J14","v":2},{"$f":"I14*J14","v":60.599999999999994},{"$f":"(P14-O14)*I14","v":45.662100000000002},{"$f":"R14*0.8","v":36.529680000000006},null,{"$f":"G14","v":116.3},{"$f":"U14*O14","v":57.335899999999995}]
[null,"3.","Radler čap.",22.9,null,22.9,17.100000000000001,null,5.7999999999999972,2.6,15.079999999999993,"l.",null,null,1.52,2.6,15.079999999999993,{"$f":"(P15-O15)*I15","v":6.2639999999999976},5.0111999999999988,null,17.100000000000001,25.992000000000001]
[null,"4.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"5.","Šariš 10˚ fľaša",25,null,25,20,null,5,0.8,4,"ks.",null,null,0.34,0.8,4,2.3000000000000003,1.8400000000000003,null,20,6.8000000000000007]
[null,"6.","Kozel 10˚ fľaša",23,null,23,21,null,2,0.9,1.8,"ks.",null,null,0.47,0.9,1.8,0.8600000000000001,0.68800000000000017,null,21,9.8699999999999992]
[null,"7.","Birell nealko fľaša",61,-20,41,39,null,2,1.2,2.4,"ks.",null,null,0.64,1.2,2.4,1.1199999999999999,0.89599999999999991,null,39,24.96]
[null,"8.","Gambrinus fľaša",50,null,50,43,null,7,0.9,6.3,"ks.",null,null,0.56000000000000005,0.9,6.3,2.38,1.9039999999999999,null,43,24.080000000000002]
[null,"9.","Plzeň 12˚ fľaša",50,null,50,46,null,4,1.3,5.2,"ks.",null,null,0.69399999999999995,1.3,5.2,2.4240000000000004,1.9392000000000005,null,46,31.923999999999999]
[null,"10.",null,null,null,0,null,null,0,null,0,"ks.",null,null,null,0,0,0,0,null,0,0]
[null,"11.","Gambrinus plech.",39,null,39,36,null,3,0.9,2.7,"ks.",null,null,0.49,0.9,2.7,1.23,0.98399999999999999,null,36,17.64]
[null,"12.",null,null,null,0,null,null,0,null,0,"ks.",null,null,0.42,0,0,0,0,null,0,0]
[null,"13.",null,null,null,0,null,null,0,null,0,"ks.",null,null,0.75,0,0,0,0,null,0,0]
[null,"14.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"15.","Práznde sudy",null,null,0,null,null,0,null,0,"ks.",null,null,null,0,0,0,0,null,0,0]
[null,"16.","Práznde fľaše",null,null,0,null,null,0,null,0,"ks.",null,null,null,0,0,0,0,null,0,0]
[null,"17.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"18.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"19.","Víno biele",29.8,null,29.8,25,null,4.8000000000000007,3,14.400000000000002,"l.",null,null,1.29,3,14.400000000000002,8.2080000000000002,6.5664000000000007,null,25,32.25]
[null,"20.","Víno červené",17.2,null,17.2,15,null,2.1999999999999993,3,6.5999999999999979,"l.",null,null,1.29,3,6.5999999999999979,3.7619999999999987,3.0095999999999989,null,15,19.350000000000001]
[null,"21.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"22.","Vodka",40.1,null,40.1,36.65,null,3.4500000000000028,12,41.400000000000034,"l.",null,null,6.54,12,41.400000000000034,18.837000000000014,15.069600000000012,null,36.65,239.691]
[null,"23.","Borovička",43.2,null,43.2,41.3,null,1.9000000000000057,12,22.800000000000068,"l.",null,null,6.56,12,22.800000000000068,10.336000000000032,8.2688000000000255,null,41.3,270.92799999999994]
[null,"24.","Koniferka",6.2,null,6.2,4.95,null,1.25,14,17.5,"l.",null,null,5.95,14,17.5,10.0625,8.0500000000000007,null,4.95,29.452500000000001]
[null,"25.","RUM",10.45,null,10.45,9.6,null,0.84999999999999964,12,10.199999999999996,"l.",null,null,5.78,12,10.199999999999996,5.2869999999999973,4.2295999999999978,null,9.6,55.488]
[null,"26.","Hruška",4.3,null,4.3,3.8,null,0.5,14,7,"l.",null,null,7.2,14,7,3.4,2.72,null,3.8,27.36]
[null,"27.","Spišská borovička",4.5,null,4.5,4.4000000000000004,null,9.9999999999999645E-2,14,1.399999999999995,"l.",null,null,8.5500000000000007,14,1.399999999999995,0.54499999999999804,0.43599999999999844,null,4.4000000000000004,37.620000000000005]
[null,"28.","Trenčianské hradné",7.8,null,7.8,6.8,null,1,12,12,"l.",null,null,6.6360000000000001,12,12,5.3639999999999999,4.2911999999999999,null,6.8,45.1248]
[null,"29.","Karpatská horká",14.15,null,14.15,13.1,null,1.0500000000000007,12,12.600000000000009,"l.",null,null,5.32,12,12.600000000000009,7.0140000000000047,5.6112000000000037,null,13.1,69.692000000000007]
[null,"30.","Vodka Peach",4.75,null,4.75,4.55,null,0.20000000000000018,14,2.8000000000000025,"l.",null,null,4.41,14,2.8000000000000025,1.9180000000000017,1.5344000000000015,null,4.55,20.0655]
[null,"31.","Becherovka",4.5999999999999996,null,4.5999999999999996,4.5,null,9.9999999999999645E-2,20,1.9999999999999929,"l.",null,null,10.67,20,1.9999999999999929,0.93299999999999672,0.7463999999999974,null,4.5,48.015000000000001]
[null,"32.","Fernet",1.8,null,1.8,0.95,null,0.85000000000000009,20,17,"l.",null,null,9.69,20,17,8.7635000000000005,7.0108000000000006,null,0.95,9.2054999999999989]
[null,"33.","Slivka",5.2,null,5.2,5.2,null,0,14,0,"l.",null,null,7.21,14,0,0,0,null,5.2,37.492000000000004]
[null,"34.","Bošácka slivovica",1.1499999999999999,null,1.1499999999999999,0.9,null,0.24999999999999989,24,5.9999999999999973,"l.",null,null,17.61,24,5.9999999999999973,1.5974999999999995,1.2779999999999996,null,0.9,15.849]
[null,"35.","Karpatská KB",null,null,0,null,null,0,20,0,"l.",null,null,5.9980000000000002,20,0,0,0,null,0,0]
[null,"36.","Fernet Citrus",null,null,0,null,null,0,20,0,"l.",null,null,9.69,20,0,0,0,null,0,0]
[null,"37.","Pepermint",3.55,null,3.55,3.4,null,0.14999999999999991,12,1.7999999999999989,"l.",null,null,5.2,12,1.7999999999999989,1.0199999999999994,0.8159999999999995,null,3.4,17.68]
[null,"38.","Nicolaus vodka",0.8,null,0.8,0.8,null,0,18,0,"l.",null,null,8.6199999999999992,18,0,0,0,null,0.8,6.8959999999999999]
[null,"39.","Captain Morgan",2.75,null,2.75,2.65,null,0.10000000000000009,24,2.4000000000000021,"l.",null,null,11.74,24,2.4000000000000021,1.2260000000000011,0.98080000000000089,null,2.65,31.111000000000001]
[null,"40.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"41.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"SUM(D13:D53)","v":952.09999999999991},null,null,{"$f":"SUM(G13:G53)","v":811.74999999999989},null,null,"Celkom:",{"$f":"SUM(K13:K53)","v":360.98000000000008},null,null,null,null,"Celkom:",{"$f":"SUM(Q13:Q53)","v":360.98000000000008},{"$f":"SUM(R13:R53)","v":191.65360000000007},{"$f":"SUM(S13:S53)","v":153.32288},null,"Za tovar:",{"$f":"SUM(V13:V53)","v":1510.9458000000002}]
[]
[]
[]
[]
[]
[]
[null,null,"Strana 2:",null,null,null,null,null,null,null,null,null,null,null,"Strana 2:"]
[null,"P.Č.","Názov  tovaru","Poč. stav","Denný príjem","Spolu","Zostatok v sklade",null,"Denný predaj","Cena €","Suma celkom €",null,null,null,"Nákupná cena","Predajná cena","Tržba","Zisk","Zisk po zdanení",null,"Zostatok v krčme","Suma tovaru"]
[]
[null,"42.","PEPSI + 7UP 0,5l",null,null,{"$f":"D65+E65","v":0},null,null,{"$f":"D65+E65-G65","v":0},1.1000000000000001,{"$f":"I65*J65","v":0},"ks.",null,null,0.78,{"$f":"J65","v":1.1000000000000001},{"$f":"I65*J65","v":0},{"$f":"(P65-O65)*I65","v":0},{"$f":"R65*0.8","v":0},null,{"$f":"G65","v":0},{"$f":"U65*O65","v":0}]
[null,"43.","Sprite +Tonic",22.5,null,{"$f":"D66+E66","v":22.5},20.2,null,{"$f":"D66+E66-G66","v":2.3000000000000007},2,{"$f":"I66*J66","v":4.6000000000000014},"ks.",null,null,0.72599999999999998,{"$f":"J66","v":2},{"$f":"I66*J66","v":4.6000000000000014},{"$f":"(P66-O66)*I66","v":2.930200000000001},{"$f":"R66*0.8","v":2.3441600000000009},null,{"$f":"G66","v":20.2},{"$f":"U66*O66","v":14.665199999999999}]
[null,"44.","Minerálka 0,5l",44,36,80,73,null,7,0.9,6.3,"ks.",null,null,0.52800000000000002,0.9,6.3,{"$f":"(P67-O67)*I67","v":2.6040000000000001},2.0832000000000002,null,73,38.544000000000004]
[null,"45.","Kofola 0,5l",18,null,18,14,null,4,1.1000000000000001,4.4000000000000004,"ks.",null,null,0.49,1.1000000000000001,4.4000000000000004,2.4400000000000004,1.9520000000000004,null,14,6.8599999999999994]
[null,"46.","Džús krabička",67,null,67,65,null,2,0.5,1,"ks.",null,null,0.17,0.5,1,0.65999999999999992,0.52799999999999991,null,65,11.05]
[null,"47.","Energetický nápoj",6,null,6,6,null,0,1.8,0,"ks.",null,null,0.25,1.8,0,0,0,null,6,1.5]
[null,"48.","Limo 0,33l fľaša",68,null,68,64,null,4,0.5,2,"ks.",null,null,0.1,0.5,2,1.6,1.2800000000000002,null,64,6.4]
[null,"49.","Minerálka 2l",56.6,null,56.6,56,null,0.60000000000000142,1.5,0.90000000000000213,"l.",null,null,0.23,1.5,0.90000000000000213,0.76200000000000179,0.60960000000000147,null,56,12.88]
[null,"50.","Relax džús fľaška",23,null,23,21,null,2,1,2,"ks.",null,null,0.55000000000000004,1,2,0.89999999999999991,0.72,null,21,11.55]
[null,"51.","Ďžús nalievaný",17.600000000000001,null,17.600000000000001,17.600000000000001,null,0,3,0,"l.",null,null,1.1879999999999999,3,0,0,0,null,17.600000000000001,20.908799999999999]
[null,"52.","Toma",24,null,24,23,null,1,1.1000000000000001,1.1000000000000001,"l.",null,null,0.33,1.1000000000000001,1.1000000000000001,0.77,0.6160000000000001,null,23,7.5900000000000007]
[null,"53.","HELLO Jupík",30,6,36,36,null,0,0.8,0,"ks.",null,null,0.33,0.8,0,0,0,null,36,11.88]
[null,"54.","COCA COLA",27,null,27,27,null,0,1.1000000000000001,0,"ks.",null,null,0.624,1.1000000000000001,0,0,0,null,27,16.847999999999999]
[null,"55.","Vinea",24,null,24,22,null,2,1.1000000000000001,2.2000000000000002,"ks.",null,null,0.504,1.1000000000000001,2.2000000000000002,1.1920000000000002,0.95360000000000023,null,22,11.088000000000001]
[null,"56.","ALOE VERA",null,null,0,null,null,0,1.2,0,"ks.",null,null,0.65,1.2,0,0,0,null,0,0]
[null,"57.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"58.","Káva turecká",580,500,1080,1010,null,{"$f":"(D81+E81-G81)/7","v":10},0.5,5,"gr.",null,null,3.4000000000000002E-2,0.5,{"$f":"K81","v":5},4.66,3.7280000000000002,null,1010,34.340000000000003]
[null,"59.","Nescafé 3v1",56,null,56,55,null,1,0.5,0.5,"ks.",null,null,0.14000000000000001,0.5,0.5,0.36,0.28799999999999998,null,55,7.7000000000000011]
[null,"60.","Čaj",106,null,106,104,null,2,0.5,{"$f":"I83*J83","v":1},"ks.",null,null,5.8000000000000003E-2,0.5,{"$f":"I83*J83","v":1},0.88400000000000001,0.70720000000000005,null,104,{"$f":"U83*O84","v":3.7439999999999998}]
[null,"61.","Mlieko do kávy",41,null,41,37,null,4,0.1,{"$f":"I84*J84","v":0.4},"ks.",null,null,3.5999999999999997E-2,0.1,{"$f":"I84*J84","v":0.4},0.25600000000000001,0.20480000000000001,null,37,{"$f":"U84*O85","v":0.29599999999999999}]
[null,"62.","Cukor HB",232,null,232,202,null,30,0.05,{"$f":"I85*J85","v":1.5},"ks.",null,null,8.0000000000000002E-3,0.05,{"$f":"I85*J85","v":1.5},1.26,1.008,null,202,{"$f":"U85*O86","v":0}]
[null,"63.",null,null,null,0,null,null,0,null,{"$f":"I86*J86","v":0},null,null,null,null,0,{"$f":"I86*J86","v":0},0,0,null,0,{"$f":"U86*O87","v":0}]
[null,"64.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"65.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"66.","Golden",12,30,42,32,null,10,3.4,34,"ks.",null,null,3.22,3.4,34,1.7999999999999972,1.4399999999999977,null,32,103.04]
[null,"67.","Petra 3,40€",12,null,12,10,null,2,3.4,6.8,"ks.",null,null,3.23,3.4,6.8,0.33999999999999986,0.27199999999999991,null,10,32.299999999999997]
[null,"68.","Malboro 3,70€",15,10,25,18,null,7,3.7,25.900000000000002,"ks.",null,null,3.51,3.7,25.900000000000002,1.3300000000000027,1.0640000000000023,null,18,63.179999999999993]
[null,"69.","LM 3,40€",51,null,51,40,null,11,3.4,37.4,"ks.",null,null,3.23,3.4,37.4,1.8699999999999992,1.4959999999999996,null,40,129.19999999999999]
[null,"70.","Mars",6,null,6,5,null,1,3.4,3.4,"ks.",null,null,3.22,3.4,3.4,0.17999999999999972,0.14399999999999977,null,5,16.100000000000001]
[null,"71.","West",17,39,56,45,null,11,3.2,35.200000000000003,"ks.",null,null,3.04,3.2,35.200000000000003,1.7600000000000016,1.4080000000000013,null,45,136.80000000000001]
[null,"72.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"73.","Malboro 4,00€",null,null,0,null,null,0,4,0,"ks.",null,null,3.9,4,0,0,0,null,0,0]
[null,"74.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"75.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"76.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"77.","Hyg. vreckovky",16,null,16,14,null,2,0.2,0.4,"ks.",null,null,8.8999999999999996E-2,0.2,0.4,0.22200000000000003,0.17760000000000004,null,14,1.246]
[null,"78.","Zapaľovač",59,null,59,58,null,1,0.5,0.5,"ks.",null,null,0.17,0.5,0.5,0.32999999999999996,0.26399999999999996,null,58,9.8600000000000012]
[null,"79.","Zápalky",48,null,48,47,null,1,0.1,0.1,"ks.",null,null,0.04,0.1,0.1,6.0000000000000005E-2,4.8000000000000008E-2,null,47,1.8800000000000001]
[null,"80.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"81.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"82.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[]
[null,null,null,{"$f":"SUM(D65:D105)","v":1678.7},null,null,{"$f":"SUM(G65:G105)","v":2121.8000000000002},null,null,"Celkom :",{"$f":"SUM(K65:K105)","v":176.60000000000002},null,null,null,null,"Celkom:",{"$f":"SUM(Q65:Q105)","v":176.60000000000002},{"$f":"SUM(R65:R105)","v":29.170200000000001},{"$f":"SUM(S65:S105)","v":23.33616},null,"Za tovar:",{"$f":"SUM(V65:V105)","v":711.44999999999993}]
[]
[]
[]
[]
[]
[]
[null,null,"Strana 3:",null,null,null,null,null,null,null,null,null,null,null,"Strana 3:"]
[null,"P.Č.","Názov  tovaru","Poč. stav","Denný príjem","Spolu","Zostatok v sklade",null,"Denný predaj","Cena €","Suma celkom €",null,null,null,"Nákupná cena","Predajná cena","Tržba","Zisk","Zisk po zdanení",null,"Zostatok v krčme","Suma tovaru"]
[]
[null,"83.","Kinderko",null,null,{"$f":"D117+E117","v":0},null,null,{"$f":"D117+E117-G117","v":0},1.2,{"$f":"I117*J117","v":0},"ks.",null,null,0.93,{"$f":"J117","v":1.2},{"$f":"I117*J117","v":0},{"$f":"(P117-O117)*I117","v":0},{"$f":"R117*0.8","v":0},null,{"$f":"G117","v":0},{"$f":"U117*O117","v":0}]
[null,"84.","Horalka",31,null,{"$f":"D118+E118","v":31},27,null,{"$f":"D118+E118-G118","v":4},0.6,{"$f":"I118*J118","v":2.4},"ks.",null,null,0.31,{"$f":"J118","v":0.6},{"$f":"I118*J118","v":2.4},{"$f":"(P118-O118)*I118","v":1.1599999999999999},{"$f":"R118*0.8","v":0.92799999999999994},null,{"$f":"G118","v":27},{"$f":"U118*O118","v":8.3699999999999992}]
[null,"85.","Kávenky",26,null,26,26,null,0,0.6,0,"ks.",null,null,0.28000000000000003,0.6,0,{"$f":"(P119-O119)*I119","v":0},0,null,26,7.2800000000000011]
[null,"86.","Kinder čokoláda",8,null,8,6,null,2,1.8,3.6,"ks.",null,null,0.9,1.8,3.6,1.8,1.4400000000000002,null,6,5.4]
[null,"87.","3-BIT",16,null,16,16,null,0,0.6,0,"ks.",null,null,0.32,0.6,0,0,0,null,16,5.12]
[null,"88.","Banán",12,null,12,11,null,1,0.6,0.6,"ks.",null,null,0.26,0.6,0.6,0.33999999999999997,0.27199999999999996,null,11,2.8600000000000003]
[null,"89.","Margot",13,null,13,13,null,0,0.6,0,"ks.",null,null,0.4,0.6,0,0,0,null,13,5.2]
[null,"90.","Lízatko 2",null,null,0,null,null,0,0.2,0,"ks.",null,null,0.04,0.2,0,0,0,null,0,0]
[null,"91.","Mila",19,null,19,18,null,1,0.6,0.6,"ks.",null,null,0.37,0.6,0.6,0.22999999999999998,0.184,null,18,6.66]
[null,"92.","Lízatko",129,null,129,126,null,3,0.3,0.89999999999999991,"ks.",null,null,0.1,0.3,0.89999999999999991,0.6,0.48,null,126,12.600000000000001]
[null,"93.","Chipsy",28,null,28,27,null,1,1,1,"ks.",null,null,0.42,1,1,0.58000000000000007,0.46400000000000008,null,27,11.34]
[null,"94.","Tofife",9,null,9,9,null,0,3,0,"ks.",null,null,1.62,3,0,0,0,null,9,14.580000000000002]
[null,"95.","Milka čok.",2,null,2,2,null,0,1.5,0,"ks.",null,null,0.73,1.5,0,0,0,null,2,1.46]
[null,"96.","Tyčinky DRU",30,null,30,28,null,2,0.5,1,"ks.",null,null,0.23,0.5,1,0.54,0.43200000000000005,null,28,6.44]
[null,"97.","Arašidy",8,null,8,8,null,0,0.8,0,"ks.",null,null,0.41,0.8,0,0,0,null,8,3.28]
[null,"98.","TIC-TAC",76,null,76,76,null,0,0.6,0,"ks.",null,null,0.3,0.6,0,0,0,null,76,22.8]
[null,"99.","Žuvažky plátky",61,null,61,56,null,5,0.1,0.5,"ks.",null,null,5.1999999999999998E-2,0.1,0.5,0.24000000000000005,0.19200000000000006,null,56,2.9119999999999999]
[null,"100.","Žuvažky dražé",13,null,13,11,null,2,0.6,1.2,"ks.",null,null,0.37,0.6,1.2,0.45999999999999996,0.36799999999999999,null,11,4.07]
[null,"101.","Hašlerky",8,null,8,8,null,0,0.9,0,"ks.",null,null,0.54,0.9,0,0,0,null,8,4.32]
[null,"102.","Žuvačky guličky",48,null,48,45,null,3,0.7,2.0999999999999996,"ks.",null,null,0.3,0.7,2.0999999999999996,1.2,0.96,null,45,13.5]
[null,"103.","Chrumky",null,null,0,null,null,0,0.6,0,"ks.",null,null,0.27,0.6,0,0,0,null,0,0]
[null,"104.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"105.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"106.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"107.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"108.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,{"$f":"SUM(D117:D142)","v":537},null,null,{"$f":"SUM(G117:G142)","v":513},null,null,"Celkom:",{"$f":"SUM(K117:K142)","v":13.899999999999999},null,null,null,null,"Celkom:",{"$f":"SUM(Q117:Q142)","v":13.899999999999999},{"$f":"SUM(R117:R142)","v":7.15},{"$f":"SUM(S117:S142)","v":5.7200000000000006},null,"Za tovar:",{"$f":"SUM(V117:V142)","v":138.19199999999998}]
[]
[]
[null,null,null,"Stávková:",null,5.5,null,null,"Strana 1:",{"$f":"K55","v":360.98000000000008},null,null,null,null,null,"Strana 1",{"$f":"Q55","v":360.98000000000008},{"$f":"R55","v":191.65360000000007},{"$f":"S55","v":153.32288},null,"Strana 1:",{"$f":"V55","v":1510.9458000000002}]
[null,null,null,"Refil:",null,null,null,null,"Strana 2:",{"$f":"K107","v":176.60000000000002},null,null,null,null,null,"Strana 2",{"$f":"Q107","v":176.60000000000002},{"$f":"R107","v":29.170200000000001},{"$f":"S107","v":23.33616},null,"Strana 2:",{"$f":"V107","v":711.44999999999993}]
[null,null,null,"Výdavky:",null,16.5,null,null,"Strana 3:",{"$f":"K144","v":13.899999999999999},null,null,null,null,null,"Strana 3",{"$f":"Q144","v":13.899999999999999},{"$f":"R144","v":7.15},{"$f":"S144","v":5.7200000000000006},null,"Strana 3:",{"$f":"V144","v":138.19199999999998}]
[]
[null,null,null,null,"Spolu:",{"$f":"SUM(F147:F149)","v":22},null,null,"Spolu:",{"$f":"SUM(J147:J149)","v":551.48000000000013},null,null,null,null,null,"Spolu:",{"$f":"SUM(Q147:Q149)","v":551.48000000000013},{"$f":"SUM(R147:R149)","v":227.97380000000007},{"$f":"SUM(S147:S149)","v":182.37904},null,"Spolu:",{"$f":"SUM(V147:V149)","v":2360.5878000000002}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spolu:",{"$f":"Q151-F151","v":529.48000000000013},{"$f":"R151-G151","v":227.97380000000007},{"$f":"S151-H151","v":182.37904}]
[null,null,null,null,null,null,null,null,"Celkom :",{"$f":"J151-F151","v":529.48000000000013}]
[]
[null,null,"Zostatok hotovosť:",531]
[]
[null,null,"rozdiel:",{"$f":"D156-J154","v":1.5199999999998681}]

{"sheet":"1","index":7,"n_rows":158,"n_cols":22,"rows_kept":158,"cut":false,"hidden":false,"merged":[[10,1,11,1],[10,2,11,2],[10,3,11,3],[10,4,11,4],[10,5,11,5],[0,6,0,8],[0,14,0,17],[1,15,1,16],[4,7,4,9],[6,7,6,8],[10,20,11,20],[10,21,11,21],[10,6,11,6],[10,8,11,8],[10,9,11,9],[10,10,11,10],[10,11,11,11],[10,14,11,14],[62,6,63,6],[10,15,11,15],[10,16,11,16],[10,17,11,17],[10,18,11,18],[62,17,63,17],[62,18,63,18],[62,1,63,1],[62,2,63,2],[62,3,63,3],[62,4,63,4],[62,5,63,5],[62,20,63,20],[62,21,63,21],[114,1,115,1],[114,2,115,2],[114,3,115,3],[114,4,115,4],[114,5,115,5],[114,6,115,6],[62,8,63,8],[62,9,63,9],[62,10,63,10],[62,14,63,14],[62,15,63,15],[62,16,63,16],[114,18,115,18],[114,20,115,20],[114,21,115,21],[146,3,146,4],[147,3,147,4],[114,8,115,8],[114,9,115,9],[114,10,115,10],[114,14,115,14],[114,15,115,15],[114,16,115,16],[148,3,148,4],[155,3,155,4],[156,3,156,4],[157,3,157,4],[114,17,115,17]]}
[null,null,null,"Vyučtovanie výčapu ",null,null,"august",null,null,"/2019",null,null,null,null,"Denný sumár"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Juniorka","Meno:",{"$f":"I2","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Šipulová","Dátum:",{"$f":"I3","v":0},"/2019"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Hermanová"]
[null,null,null,null,null,null,"Meno:"]
[]
[null,null,null,null,null,null,"Dátum:",null,null,"/2019"]
[]
[]
[null,null,"Strana 1:",null,null,null,null,null,null,null,null,null,null,null,"Strana 1:"]
[null,"P.Č.","Názov  tovaru","Poč. stav","Denný príjem","Spolu","Zostatok v sklade",null,"Denný predaj","Cena €","Suma celkom €","J.M.",null,null,"Nákupná cena","Predajná cena","Tržba","Zisk","Zisk po zdanení",null,"Zostatok v krčme","Suma tovaru"]
[]
[null,"1.","Pernštejn čap. 10˚",289.8,null,{"$f":"D13+E13","v":289.8},238.8,null,{"$f":"D13+E13-G13","v":51},2,{"$f":"I13*J13","v":102},"l.",null,null,1.032,{"$f":"J13","v":2},{"$f":"I13*J13","v":102},{"$f":"(P13-O13)*I13","v":49.367999999999995},{"$f":"R13*0.8","v":39.494399999999999},null,{"$f":"G13","v":238.8},{"$f":"U13*O13","v":246.44160000000002}]
[null,"2.","Malinovka čap.",116.3,null,116.3,78.400000000000006,null,37.899999999999991,2,{"$f":"I14*J14","v":75.799999999999983},"l.",null,null,0.49299999999999999,{"$f":"J14","v":2},{"$f":"I14*J14","v":75.799999999999983},{"$f":"(P14-O14)*I14","v":57.115299999999991},{"$f":"R14*0.8","v":45.692239999999998},null,{"$f":"G14","v":78.400000000000006},{"$f":"U14*O14","v":38.651200000000003}]
[null,"3.","Radler čap.",17.100000000000001,null,17.100000000000001,8.9,null,8.2000000000000011,2.6,21.320000000000004,"l.",null,null,1.52,2.6,21.320000000000004,{"$f":"(P15-O15)*I15","v":8.8560000000000016},7.0848000000000013,null,8.9,13.528]
[null,"4.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"5.","Šariš 10˚ fľaša",20,null,20,17,null,3,0.8,2.4000000000000004,"ks.",null,null,0.34,0.8,2.4000000000000004,1.3800000000000001,1.1040000000000001,null,17,5.78]
[null,"6.","Kozel 10˚ fľaša",21,null,21,17,null,4,0.9,3.6,"ks.",null,null,0.47,0.9,3.6,1.7200000000000002,1.3760000000000003,null,17,7.9899999999999993]
[null,"7.","Birell nealko fľaša",39,null,39,37,null,2,1.2,2.4,"ks.",null,null,0.64,1.2,2.4,1.1199999999999999,0.89599999999999991,null,37,23.68]
[null,"8.","Gambrinus fľaša",43,null,43,28,null,15,0.9,13.5,"ks.",null,null,0.56000000000000005,0.9,13.5,5.0999999999999996,4.08,null,28,15.680000000000001]
[null,"9.","Plzeň 12˚ fľaša",46,null,46,39,null,7,1.3,9.1,"ks.",null,null,0.69399999999999995,1.3,9.1,4.2420000000000009,3.3936000000000011,null,39,27.065999999999999]
[null,"10.",null,null,null,0,null,null,0,null,0,"ks.",null,null,null,0,0,0,0,null,0,0]
[null,"11.","Gambrinus plech.",36,null,36,32,null,4,0.9,3.6,"ks.",null,null,0.49,0.9,3.6,1.6400000000000001,1.3120000000000003,null,32,15.68]
[null,"12.",null,null,null,0,null,null,0,null,0,"ks.",null,null,0.42,0,0,0,0,null,0,0]
[null,"13.",null,null,null,0,null,null,0,null,0,"ks.",null,null,0.75,0,0,0,0,null,0,0]
[null,"14.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"15.","Práznde sudy",null,null,0,null,null,0,null,0,"ks.",null,null,null,0,0,0,0,null,0,0]
[null,"16.","Práznde fľaše",null,null,0,null,null,0,null,0,"ks.",null,null,null,0,0,0,0,null,0,0]
[null,"17.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"18.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"19.","Víno biele",25,null,25,22.1,null,2.8999999999999986,3,8.6999999999999957,"l.",null,null,1.29,3,8.6999999999999957,4.9589999999999979,3.9671999999999983,null,22.1,28.509000000000004]
[null,"20.","Víno červené",15,null,15,13.5,null,1.5,3,4.5,"l.",null,null,1.29,3,4.5,2.5649999999999999,2.052,null,13.5,17.414999999999999]
[null,"21.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"22.","Vodka",36.65,null,36.65,27.4,null,9.25,12,111,"l.",null,null,6.54,12,111,50.505000000000003,40.404000000000003,null,27.4,179.196]
[null,"23.","Borovička",41.3,null,41.3,29.95,null,11.349999999999998,12,136.19999999999999,"l.",null,null,6.56,12,136.19999999999999,61.743999999999993,49.395199999999996,null,29.95,196.47199999999998]
[null,"24.","Koniferka",4.95,null,4.95,4.0999999999999996,null,0.85000000000000053,14,11.900000000000007,"l.",null,null,5.95,14,11.900000000000007,6.8425000000000047,5.4740000000000038,null,4.0999999999999996,24.395]
[null,"25.","RUM",9.6,null,9.6,7.5,null,2.0999999999999996,12,25.199999999999996,"l.",null,null,5.78,12,25.199999999999996,13.061999999999998,10.449599999999998,null,7.5,43.35]
[null,"26.","Hruška",3.8,null,3.8,2.9,null,0.89999999999999991,14,12.599999999999998,"l.",null,null,7.2,14,12.599999999999998,6.1199999999999992,4.8959999999999999,null,2.9,20.88]
[null,"27.","Spišská borovička",4.4000000000000004,null,4.4000000000000004,4.3499999999999996,null,5.0000000000000711E-2,14,0.70000000000000995,"l.",null,null,8.5500000000000007,14,0.70000000000000995,0.27250000000000385,0.21800000000000308,null,4.3499999999999996,37.192500000000003]
[null,"28.","Trenčianské hradné",6.8,null,6.8,2.9,null,3.9,12,46.8,"l.",null,null,6.6360000000000001,12,46.8,20.919599999999999,16.735679999999999,null,2.9,19.244399999999999]
[null,"29.","Karpatská horká",13.1,null,13.1,11.35,null,1.75,12,21,"l.",null,null,5.32,12,21,11.69,9.3520000000000003,null,11.35,60.381999999999998]
[null,"30.","Vodka Peach",4.55,null,4.55,3.6,null,0.94999999999999973,14,13.299999999999997,"l.",null,null,4.41,14,13.299999999999997,9.1104999999999965,7.2883999999999975,null,3.6,15.876000000000001]
[null,"31.","Becherovka",4.5,null,4.5,3.7,null,0.79999999999999982,20,15.999999999999996,"l.",null,null,10.67,20,15.999999999999996,7.4639999999999986,5.9711999999999996,null,3.7,39.478999999999999]
[null,"32.","Fernet",0.95,null,0.95,0.15,null,0.79999999999999993,20,15.999999999999998,"l.",null,null,9.69,20,15.999999999999998,8.2479999999999993,6.5983999999999998,null,0.15,1.4534999999999998]
[null,"33.","Slivka",5.2,null,5.2,5,null,0.20000000000000018,14,2.8000000000000025,"l.",null,null,7.21,14,2.8000000000000025,1.3580000000000012,1.0864000000000009,null,5,36.049999999999997]
[null,"34.","Bošácka slivovica",0.9,null,0.9,null,null,0.9,24,21.6,"l.",null,null,17.61,24,21.6,5.7510000000000003,4.6008000000000004,null,0,0]
[null,"35.","Karpatská KB",null,null,0,null,null,0,20,0,"l.",null,null,5.9980000000000002,20,0,0,0,null,0,0]
[null,"36.","Fernet Citrus",null,null,0,null,null,0,20,0,"l.",null,null,9.69,20,0,0,0,null,0,0]
[null,"37.","Pepermint",3.4,null,3.4,2.95,null,0.44999999999999973,12,5.3999999999999968,"l.",null,null,5.2,12,5.3999999999999968,3.0599999999999983,2.4479999999999986,null,2.95,15.340000000000002]
[null,"38.","Nicolaus vodka",0.8,null,0.8,0.75,null,5.0000000000000044E-2,18,0.9000000000000008,"l.",null,null,8.6199999999999992,18,0.9000000000000008,0.46900000000000047,0.37520000000000042,null,0.75,6.4649999999999999]
[null,"39.","Captain Morgan",2.65,null,2.65,2.4500000000000002,null,0.19999999999999973,24,4.7999999999999936,"l.",null,null,11.74,24,4.7999999999999936,2.4519999999999968,1.9615999999999976,null,2.4500000000000002,28.763000000000002]
[null,"40.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"41.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"SUM(D13:D53)","v":811.74999999999989},null,null,{"$f":"SUM(G13:G53)","v":640.75000000000023},null,null,"Celkom:",{"$f":"SUM(K13:K53)","v":693.11999999999989},null,null,null,null,"Celkom:",{"$f":"SUM(Q13:Q53)","v":693.11999999999989},{"$f":"SUM(R13:R53)","v":347.13339999999994},{"$f":"SUM(S13:S53)","v":277.70671999999996},null,"Za tovar:",{"$f":"SUM(V13:V53)","v":1164.9591999999998}]
[]
[]
[]
[]
[]
[]
[null,null,"Strana 2:",null,null,null,null,null,null,null,null,null,null,null,"Strana 2:"]
[null,"P.Č.","Názov  tovaru","Poč. stav","Denný príjem","Spolu","Zostatok v sklade",null,"Denný predaj","Cena €","Suma celkom €",null,null,null,"Nákupná cena","Predajná cena","Tržba","Zisk","Zisk po zdanení",null,"Zostatok v krčme","Suma tovaru"]
[]
[null,"42.","PEPSI + 7UP 0,5l",null,null,{"$f":"D65+E65","v":0},null,null,{"$f":"D65+E65-G65","v":0},1.1000000000000001,{"$f":"I65*J65","v":0},"ks.",null,null,0.78,{"$f":"J65","v":1.1000000000000001},{"$f":"I65*J65","v":0},{"$f":"(P65-O65)*I65","v":0},{"$f":"R65*0.8","v":0},null,{"$f":"G65","v":0},{"$f":"U65*O65","v":0}]
[null,"43.","Sprite +Tonic",20.2,null,{"$f":"D66+E66","v":20.2},19.8,null,{"$f":"D66+E66-G66","v":0.39999999999999858},2,{"$f":"I66*J66","v":0.79999999999999716},"ks.",null,null,0.72599999999999998,{"$f":"J66","v":2},{"$f":"I66*J66","v":0.79999999999999716},{"$f":"(P66-O66)*I66","v":0.50959999999999817},{"$f":"R66*0.8","v":0.40767999999999854},null,{"$f":"G66","v":19.8},{"$f":"U66*O66","v":14.3748}]
[null,"44.","Minerálka 0,5l",73,null,73,67,null,6,0.9,5.4,"ks.",null,null,0.52800000000000002,0.9,5.4,{"$f":"(P67-O67)*I67","v":2.2320000000000002},1.7856000000000003,null,67,35.376000000000005]
[null,"45.","Kofola 0,5l",14,null,14,13,null,1,1.1000000000000001,1.1000000000000001,"ks.",null,null,0.49,1.1000000000000001,1.1000000000000001,0.6100000000000001,0.4880000000000001,null,13,6.37]
[null,"46.","Džús krabička",65,null,65,60,null,5,0.5,2.5,"ks.",null,null,0.17,0.5,2.5,1.65,1.32,null,60,10.200000000000001]
[null,"47.","Energetický nápoj",6,null,6,6,null,0,1.8,0,"ks.",null,null,0.25,1.8,0,0,0,null,6,1.5]
[null,"48.","Limo 0,33l fľaša",64,null,64,51,null,13,0.5,6.5,"ks.",null,null,0.1,0.5,6.5,5.2,4.16,null,51,5.1000000000000005]
[null,"49.","Minerálka 2l",56,null,56,52,null,4,1.5,6,"l.",null,null,0.23,1.5,6,5.08,4.0640000000000001,null,52,11.96]
[null,"50.","Relax džús fľaška",21,null,21,15,null,6,1,6,"ks.",null,null,0.55000000000000004,1,6,2.6999999999999997,2.1599999999999997,null,15,8.25]
[null,"51.","Ďžús nalievaný",17.600000000000001,null,17.600000000000001,16.5,null,1.1000000000000014,3,3.3000000000000043,"l.",null,null,1.1879999999999999,3,3.3000000000000043,1.9932000000000025,1.5945600000000022,null,16.5,19.602]
[null,"52.","Toma",23,null,23,23,null,0,1.1000000000000001,0,"l.",null,null,0.33,1.1000000000000001,0,0,0,null,23,7.5900000000000007]
[null,"53.","HELLO Jupík",36,null,36,36,null,0,0.8,0,"ks.",null,null,0.33,0.8,0,0,0,null,36,11.88]
[null,"54.","COCA COLA",27,null,27,27,null,0,1.1000000000000001,0,"ks.",null,null,0.624,1.1000000000000001,0,0,0,null,27,16.847999999999999]
[null,"55.","Vinea",22,null,22,21,null,1,1.1000000000000001,1.1000000000000001,"ks.",null,null,0.504,1.1000000000000001,1.1000000000000001,0.59600000000000009,0.47680000000000011,null,21,10.584]
[null,"56.","ALOE VERA",null,null,0,null,null,0,1.2,0,"ks.",null,null,0.65,1.2,0,0,0,null,0,0]
[null,"57.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"58.","Káva turecká",1010,null,1010,860,null,{"$f":"(D81+E81-G81)/7","v":21.428571428571427},0.5,10.714285714285714,"gr.",null,null,3.4000000000000002E-2,0.5,{"$f":"K81","v":10.714285714285714},9.985714285714284,7.9885714285714275,null,860,29.240000000000002]
[null,"59.","Nescafé 3v1",55,null,55,55,null,0,0.5,0,"ks.",null,null,0.14000000000000001,0.5,0,0,0,null,55,7.7000000000000011]
[null,"60.","Čaj",104,null,104,104,null,0,0.5,{"$f":"I83*J83","v":0},"ks.",null,null,5.8000000000000003E-2,0.5,{"$f":"I83*J83","v":0},0,0,null,104,{"$f":"U83*O84","v":3.7439999999999998}]
[null,"61.","Mlieko do kávy",37,null,37,32,null,5,0.1,{"$f":"I84*J84","v":0.5},"ks.",null,null,3.5999999999999997E-2,0.1,{"$f":"I84*J84","v":0.5},0.32,0.25600000000000001,null,32,{"$f":"U84*O85","v":0.25600000000000001}]
[null,"62.","Cukor HB",202,null,202,173,null,29,0.05,{"$f":"I85*J85","v":1.4500000000000002},"ks.",null,null,8.0000000000000002E-3,0.05,{"$f":"I85*J85","v":1.4500000000000002},1.218,0.97440000000000004,null,173,{"$f":"U85*O86","v":0}]
[null,"63.",null,null,null,0,null,null,0,null,{"$f":"I86*J86","v":0},null,null,null,null,0,{"$f":"I86*J86","v":0},0,0,null,0,{"$f":"U86*O87","v":0}]
[null,"64.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"65.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"66.","Golden",32,null,32,27,null,5,3.4,17,"ks.",null,null,3.22,3.4,17,0.89999999999999858,0.71999999999999886,null,27,86.940000000000012]
[null,"67.","Petra 3,40€",10,null,10,3,null,7,3.4,23.8,"ks.",null,null,3.23,3.4,23.8,1.1899999999999995,0.95199999999999962,null,3,9.69]
[null,"68.","Malboro 3,70€",18,null,18,10,null,8,3.7,29.6,"ks.",null,null,3.51,3.7,29.6,1.5200000000000031,1.2160000000000026,null,10,35.099999999999994]
[null,"69.","LM 3,40€",40,null,40,18,null,22,3.4,74.8,"ks.",null,null,3.23,3.4,74.8,3.7399999999999984,2.9919999999999991,null,18,58.14]
[null,"70.","Mars",5,null,5,null,null,5,3.4,17,"ks.",null,null,3.22,3.4,17,0.89999999999999858,0.71999999999999886,null,0,0]
[null,"71.","West",45,null,45,37,null,8,3.2,25.6,"ks.",null,null,3.04,3.2,25.6,1.2800000000000011,1.0240000000000009,null,37,112.48]
[null,"72.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"73.","Malboro 4,00€",null,null,0,null,null,0,4,0,"ks.",null,null,3.9,4,0,0,0,null,0,0]
[null,"74.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"75.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"76.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"77.","Hyg. vreckovky",14,null,14,11,null,3,0.2,0.60000000000000009,"ks.",null,null,8.8999999999999996E-2,0.2,0.60000000000000009,0.33300000000000007,0.26640000000000008,null,11,0.97899999999999998]
[null,"78.","Zapaľovač",58,null,58,52,null,6,0.5,3,"ks.",null,null,0.17,0.5,3,1.9799999999999998,1.5839999999999999,null,52,8.84]
[null,"79.","Zápalky",47,null,47,46,null,1,0.1,0.1,"ks.",null,null,0.04,0.1,0.1,6.0000000000000005E-2,4.8000000000000008E-2,null,46,1.84]
[null,"80.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"81.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"82.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[]
[null,null,null,{"$f":"SUM(D65:D105)","v":2121.8000000000002},null,null,{"$f":"SUM(G65:G105)","v":1835.3},null,null,"Celkom :",{"$f":"SUM(K65:K105)","v":236.86428571428573},null,null,null,null,"Celkom:",{"$f":"SUM(Q65:Q105)","v":236.86428571428573},{"$f":"SUM(R65:R105)","v":43.997514285714274},{"$f":"SUM(S65:S105)","v":35.198011428571427},null,"Za tovar:",{"$f":"SUM(V65:V105)","v":514.5838}]
[]
[]
[]
[]
[]
[]
[null,null,"Strana 3:",null,null,null,null,null,null,null,null,null,null,null,"Strana 3:"]
[null,"P.Č.","Názov  tovaru","Poč. stav","Denný príjem","Spolu","Zostatok v sklade",null,"Denný predaj","Cena €","Suma celkom €",null,null,null,"Nákupná cena","Predajná cena","Tržba","Zisk","Zisk po zdanení",null,"Zostatok v krčme","Suma tovaru"]
[]
[null,"83.","Kinderko",null,null,{"$f":"D117+E117","v":0},null,null,{"$f":"D117+E117-G117","v":0},1.2,{"$f":"I117*J117","v":0},"ks.",null,null,0.93,{"$f":"J117","v":1.2},{"$f":"I117*J117","v":0},{"$f":"(P117-O117)*I117","v":0},{"$f":"R117*0.8","v":0},null,{"$f":"G117","v":0},{"$f":"U117*O117","v":0}]
[null,"84.","Horalka",27,null,{"$f":"D118+E118","v":27},23,null,{"$f":"D118+E118-G118","v":4},0.6,{"$f":"I118*J118","v":2.4},"ks.",null,null,0.31,{"$f":"J118","v":0.6},{"$f":"I118*J118","v":2.4},{"$f":"(P118-O118)*I118","v":1.1599999999999999},{"$f":"R118*0.8","v":0.92799999999999994},null,{"$f":"G118","v":23},{"$f":"U118*O118","v":7.13}]
[null,"85.","Kávenky",26,null,26,25,null,1,0.6,0.6,"ks.",null,null,0.28000000000000003,0.6,0.6,{"$f":"(P119-O119)*I119","v":0.31999999999999995},0.25599999999999995,null,25,7.0000000000000009]
[null,"86.","Kinder čokoláda",6,null,6,5,null,1,1.8,1.8,"ks.",null,null,0.9,1.8,1.8,0.9,0.72000000000000008,null,5,4.5]
[null,"87.","3-BIT",16,null,16,15,null,1,0.6,0.6,"ks.",null,null,0.32,0.6,0.6,0.27999999999999997,0.22399999999999998,null,15,4.8]
[null,"88.","Banán",11,null,11,7,null,4,0.6,2.4,"ks.",null,null,0.26,0.6,2.4,1.3599999999999999,1.0879999999999999,null,7,1.82]
[null,"89.","Margot",13,null,13,13,null,0,0.6,0,"ks.",null,null,0.4,0.6,0,0,0,null,13,5.2]
[null,"90.","Lízatko 2",null,null,0,null,null,0,0.2,0,"ks.",null,null,0.04,0.2,0,0,0,null,0,0]
[null,"91.","Mila",18,null,18,17,null,1,0.6,0.6,"ks.",null,null,0.37,0.6,0.6,0.22999999999999998,0.184,null,17,6.29]
[null,"92.","Lízatko",126,null,126,123,null,3,0.3,0.89999999999999991,"ks.",null,null,0.1,0.3,0.89999999999999991,0.6,0.48,null,123,12.3]
[null,"93.","Chipsy",27,null,27,24,null,3,1,3,"ks.",null,null,0.42,1,3,1.7400000000000002,1.3920000000000003,null,24,10.08]
[null,"94.","Tofife",9,null,9,9,null,0,3,0,"ks.",null,null,1.62,3,0,0,0,null,9,14.580000000000002]
[null,"95.","Milka čok.",2,null,2,2,null,0,1.5,0,"ks.",null,null,0.73,1.5,0,0,0,null,2,1.46]
[null,"96.","Tyčinky DRU",28,null,28,28,null,0,0.5,0,"ks.",null,null,0.23,0.5,0,0,0,null,28,6.44]
[null,"97.","Arašidy",8,null,8,8,null,0,0.8,0,"ks.",null,null,0.41,0.8,0,0,0,null,8,3.28]
[null,"98.","TIC-TAC",76,null,76,74,null,2,0.6,1.2,"ks.",null,null,0.3,0.6,1.2,0.6,0.48,null,74,22.2]
[null,"99.","Žuvažky plátky",56,null,56,56,null,0,0.1,0,"ks.",null,null,5.1999999999999998E-2,0.1,0,0,0,null,56,2.9119999999999999]
[null,"100.","Žuvažky dražé",11,null,11,7,null,4,0.6,2.4,"ks.",null,null,0.37,0.6,2.4,0.91999999999999993,0.73599999999999999,null,7,2.59]
[null,"101.","Hašlerky",8,null,8,8,null,0,0.9,0,"ks.",null,null,0.54,0.9,0,0,0,null,8,4.32]
[null,"102.","Žuvačky guličky",45,null,45,45,null,0,0.7,0,"ks.",null,null,0.3,0.7,0,0,0,null,45,13.5]
[null,"103.","Chrumky",null,null,0,null,null,0,0.6,0,"ks.",null,null,0.27,0.6,0,0,0,null,0,0]
[null,"104.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"105.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"106.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"107.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"108.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,{"$f":"SUM(D117:D142)","v":513},null,null,{"$f":"SUM(G117:G142)","v":489},null,null,"Celkom:",{"$f":"SUM(K117:K142)","v":15.899999999999999},null,null,null,null,"Celkom:",{"$f":"SUM(Q117:Q142)","v":15.899999999999999},{"$f":"SUM(R117:R142)","v":8.11},{"$f":"SUM(S117:S142)","v":6.4880000000000004},null,"Za tovar:",{"$f":"SUM(V117:V142)","v":130.40200000000002}]
[]
[]
[null,null,null,"Stávková:",null,null,null,null,"Strana 1:",{"$f":"K55","v":693.11999999999989},null,null,null,null,null,"Strana 1",{"$f":"Q55","v":693.11999999999989},{"$f":"R55","v":347.13339999999994},{"$f":"S55","v":277.70671999999996},null,"Strana 1:",{"$f":"V55","v":1164.9591999999998}]
[null,null,null,"Refil:",null,null,null,null,"Strana 2:",{"$f":"K107","v":236.86428571428573},null,null,null,null,null,"Strana 2",{"$f":"Q107","v":236.86428571428573},{"$f":"R107","v":43.997514285714274},{"$f":"S107","v":35.198011428571427},null,"Strana 2:",{"$f":"V107","v":514.5838}]
[null,null,null,"Výdavky:",null,null,null,null,"Strana 3:",{"$f":"K144","v":15.899999999999999},null,null,null,null,null,"Strana 3",{"$f":"Q144","v":15.899999999999999},{"$f":"R144","v":8.11},{"$f":"S144","v":6.4880000000000004},null,"Strana 3:",{"$f":"V144","v":130.40200000000002}]
[]
[null,null,null,null,"Spolu:",{"$f":"SUM(F147:F149)","v":0},null,null,"Spolu:",{"$f":"SUM(J147:J149)","v":945.88428571428562},null,null,null,null,null,"Spolu:",{"$f":"SUM(Q147:Q149)","v":945.88428571428562},{"$f":"SUM(R147:R149)","v":399.24091428571421},{"$f":"SUM(S147:S149)","v":319.39273142857138},null,"Spolu:",{"$f":"SUM(V147:V149)","v":1809.9449999999997}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spolu:",{"$f":"Q151-F151","v":945.88428571428562},{"$f":"R151-G151","v":399.24091428571421},{"$f":"S151-H151","v":319.39273142857138}]
[null,null,null,null,null,null,null,null,"Celkom :",{"$f":"J151-F151","v":945.88428571428562}]
[]
[null,null,"Zostatok hotovosť:"]
[]
[null,null,"rozdiel:",{"$f":"D156-J154","v":-945.88428571428562}]

{"sheet":"2","index":8,"n_rows":158,"n_cols":22,"rows_kept":158,"cut":false,"hidden":false,"merged":[[10,1,11,1],[10,2,11,2],[10,3,11,3],[10,4,11,4],[10,5,11,5],[0,6,0,8],[0,14,0,17],[1,15,1,16],[4,7,4,9],[6,7,6,8],[10,20,11,20],[10,21,11,21],[10,6,11,6],[10,8,11,8],[10,9,11,9],[10,10,11,10],[10,11,11,11],[10,14,11,14],[62,6,63,6],[10,15,11,15],[10,16,11,16],[10,17,11,17],[10,18,11,18],[62,17,63,17],[62,18,63,18],[62,1,63,1],[62,2,63,2],[62,3,63,3],[62,4,63,4],[62,5,63,5],[62,20,63,20],[62,21,63,21],[114,1,115,1],[114,2,115,2],[114,3,115,3],[114,4,115,4],[114,5,115,5],[114,6,115,6],[62,8,63,8],[62,9,63,9],[62,10,63,10],[62,14,63,14],[62,15,63,15],[62,16,63,16],[114,18,115,18],[114,20,115,20],[114,21,115,21],[146,3,146,4],[147,3,147,4],[114,8,115,8],[114,9,115,9],[114,10,115,10],[114,14,115,14],[114,15,115,15],[114,16,115,16],[148,3,148,4],[155,3,155,4],[156,3,156,4],[157,3,157,4],[114,17,115,17]]}
[null,null,null,"Vyučtovanie výčapu ",null,null,"august",null,null,"/2019",null,null,null,null,"Denný sumár"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Juniorka","Meno:",{"$f":"I2","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Šipulová","Dátum:",{"$f":"I3","v":0},"/2019"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Hermanová"]
[null,null,null,null,null,null,"Meno:"]
[]
[null,null,null,null,null,null,"Dátum:",null,null,"/2019"]
[]
[]
[null,null,"Strana 1:",null,null,null,null,null,null,null,null,null,null,null,"Strana 1:"]
[null,"P.Č.","Názov  tovaru","Poč. stav","Denný príjem","Spolu","Zostatok v sklade",null,"Denný predaj","Cena €","Suma celkom €","J.M.",null,null,"Nákupná cena","Predajná cena","Tržba","Zisk","Zisk po zdanení",null,"Zostatok v krčme","Suma tovaru"]
[]
[null,"1.","Pernštejn čap. 10˚",238.8,null,{"$f":"D13+E13","v":238.8},193.8,null,{"$f":"D13+E13-G13","v":45},2,{"$f":"I13*J13","v":90},"l.",null,null,1.032,{"$f":"J13","v":2},{"$f":"I13*J13","v":90},{"$f":"(P13-O13)*I13","v":43.56},{"$f":"R13*0.8","v":34.848000000000006},null,{"$f":"G13","v":193.8},{"$f":"U13*O13","v":200.00160000000002}]
[null,"2.","Malinovka čap.",78.400000000000006,80,158.4,132.80000000000001,null,25.599999999999994,2,{"$f":"I14*J14","v":51.199999999999989},"l.",null,null,0.49299999999999999,{"$f":"J14","v":2},{"$f":"I14*J14","v":51.199999999999989},{"$f":"(P14-O14)*I14","v":38.579199999999993},{"$f":"R14*0.8","v":30.863359999999997},null,{"$f":"G14","v":132.80000000000001},{"$f":"U14*O14","v":65.470399999999998}]
[null,"3.","Radler čap.",8.9,30,38.9,34.6,null,4.2999999999999972,2.6,11.179999999999993,"l.",null,null,1.52,2.6,11.179999999999993,{"$f":"(P15-O15)*I15","v":4.6439999999999975},3.7151999999999981,null,34.6,52.592000000000006]
[null,"4.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"5.","Šariš 10˚ fľaša",17,20,37,33,null,4,0.8,3.2,"ks.",null,null,0.34,0.8,3.2,1.84,1.4720000000000002,null,33,11.22]
[null,"6.","Kozel 10˚ fľaša",17,20,37,32,null,5,0.9,4.5,"ks.",null,null,0.47,0.9,4.5,2.1500000000000004,1.7200000000000004,null,32,15.04]
[null,"7.","Birell nealko fľaša",37,null,37,34,null,3,1.2,3.5999999999999996,"ks.",null,null,0.64,1.2,3.5999999999999996,1.6799999999999997,1.3439999999999999,null,34,21.76]
[null,"8.","Gambrinus fľaša",28,20,48,37,null,11,0.9,9.9,"ks.",null,null,0.56000000000000005,0.9,9.9,3.7399999999999998,2.992,null,37,20.720000000000002]
[null,"9.","Plzeň 12˚ fľaša",39,null,39,23,null,16,1.3,20.8,"ks.",null,null,0.69399999999999995,1.3,20.8,9.6960000000000015,7.7568000000000019,null,23,15.962]
[null,"10.",null,null,null,0,null,null,0,null,0,"ks.",null,null,null,0,0,0,0,null,0,0]
[null,"11.","Gambrinus plech.",32,null,32,30,null,2,0.9,1.8,"ks.",null,null,0.49,0.9,1.8,0.82000000000000006,0.65600000000000014,null,30,14.7]
[null,"12.",null,null,null,0,null,null,0,null,0,"ks.",null,null,0.42,0,0,0,0,null,0,0]
[null,"13.",null,null,null,0,null,null,0,null,0,"ks.",null,null,0.75,0,0,0,0,null,0,0]
[null,"14.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"15.","Práznde sudy",null,null,0,null,null,0,null,0,"ks.",null,null,null,0,0,0,0,null,0,0]
[null,"16.","Práznde fľaše",null,null,0,null,null,0,null,0,"ks.",null,null,null,0,0,0,0,null,0,0]
[null,"17.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"18.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"19.","Víno biele",22.1,24,46.1,42.1,null,4,3,12,"l.",null,null,1.29,3,12,6.84,5.4720000000000004,null,42.1,54.309000000000005]
[null,"20.","Víno červené",13.5,12,25.5,23.5,null,2,3,6,"l.",null,null,1.29,3,6,3.42,2.7360000000000002,null,23.5,30.315000000000001]
[null,"21.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"22.","Vodka",27.4,24,51.4,47.9,null,3.5,12,42,"l.",null,null,6.54,12,42,19.11,15.288,null,47.9,313.26600000000002]
[null,"23.","Borovička",29.95,36,65.95,62.8,null,3.1500000000000057,12,37.800000000000068,"l.",null,null,6.56,12,37.800000000000068,17.136000000000031,13.708800000000025,null,62.8,411.96799999999996]
[null,"24.","Koniferka",4.0999999999999996,8.4,12.5,10.95,null,1.5500000000000007,14,21.70000000000001,"l.",null,null,5.95,14,21.70000000000001,12.477500000000006,9.9820000000000064,null,10.95,65.152500000000003]
[null,"25.","RUM",7.5,6,13.5,13.5,null,0,12,0,"l.",null,null,5.78,12,0,0,0,null,13.5,78.03]
[null,"26.","Hruška",2.9,5,7.9,7.2,null,0.70000000000000018,14,9.8000000000000025,"l.",null,null,7.2,14,9.8000000000000025,4.7600000000000007,3.8080000000000007,null,7.2,51.84]
[null,"27.","Spišská borovička",4.3499999999999996,null,4.3499999999999996,4.0999999999999996,null,0.25,14,3.5,"l.",null,null,8.5500000000000007,14,3.5,1.3624999999999998,1.0899999999999999,null,4.0999999999999996,35.055]
[null,"28.","Trenčianské hradné",2.9,12,14.9,13.95,null,0.95000000000000107,12,11.400000000000013,"l.",null,null,6.6360000000000001,12,11.400000000000013,5.0958000000000059,4.0766400000000047,null,13.95,92.572199999999995]
[null,"29.","Karpatská horká",11.35,null,11.35,9.75,null,1.5999999999999996,12,19.199999999999996,"l.",null,null,5.32,12,19.199999999999996,10.687999999999997,8.550399999999998,null,9.75,51.870000000000005]
[null,"30.","Vodka Peach",3.6,2,5.6,5.4,null,0.19999999999999929,14,2.7999999999999901,"l.",null,null,4.41,14,2.7999999999999901,1.9179999999999933,1.5343999999999947,null,5.4,23.814000000000004]
[null,"31.","Becherovka",3.7,2,5.7,5.15,null,0.54999999999999982,20,10.999999999999996,"l.",null,null,10.67,20,10.999999999999996,5.1314999999999982,4.1051999999999991,null,5.15,54.950500000000005]
[null,"32.","Fernet",0.15,6,6.15,6,null,0.15000000000000036,20,3.0000000000000071,"l.",null,null,9.69,20,3.0000000000000071,1.5465000000000038,1.2372000000000032,null,6,58.14]
[null,"33.","Slivka",5,null,5,4.9000000000000004,null,9.9999999999999645E-2,14,1.399999999999995,"l.",null,null,7.21,14,1.399999999999995,0.67899999999999761,0.54319999999999813,null,4.9000000000000004,35.329000000000001]
[null,"34.","Bošácka slivovica",null,5,5,4.9000000000000004,null,9.9999999999999645E-2,24,2.3999999999999915,"l.",null,null,17.61,24,2.3999999999999915,0.63899999999999779,0.51119999999999821,null,4.9000000000000004,86.289000000000001]
[null,"35.","Karpatská KB",null,null,0,null,null,0,20,0,"l.",null,null,5.9980000000000002,20,0,0,0,null,0,0]
[null,"36.","Fernet Citrus",null,null,0,null,null,0,20,0,"l.",null,null,9.69,20,0,0,0,null,0,0]
[null,"37.","Pepermint",2.95,3,5.95,5.9,null,4.9999999999999822E-2,12,0.59999999999999787,"l.",null,null,5.2,12,0.59999999999999787,0.3399999999999988,0.27199999999999908,null,5.9,30.680000000000003]
[null,"38.","Nicolaus vodka",0.75,3,3.75,3.45,null,0.29999999999999982,18,5.3999999999999968,"l.",null,null,8.6199999999999992,18,5.3999999999999968,2.8139999999999987,2.251199999999999,null,3.45,29.738999999999997]
[null,"39.","Captain Morgan",2.4500000000000002,null,2.4500000000000002,2.2999999999999998,null,0.15000000000000036,24,3.6000000000000085,"l.",null,null,11.74,24,3.6000000000000085,1.8390000000000044,1.4712000000000036,null,2.2999999999999998,27.001999999999999]
[null,"40.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"41.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"SUM(D13:D53)","v":640.75000000000023},null,null,{"$f":"SUM(G13:G53)","v":823.95},null,null,"Celkom:",{"$f":"SUM(K13:K53)","v":389.78000000000009},null,null,null,null,"Celkom:",{"$f":"SUM(Q13:Q53)","v":389.78000000000009},{"$f":"SUM(R13:R53)","v":202.506},{"$f":"SUM(S13:S53)","v":162.00480000000002},null,"Za tovar:",{"$f":"SUM(V13:V53)","v":1947.7872}]
[]
[]
[]
[]
[]
[]
[null,null,"Strana 2:",null,null,null,null,null,null,null,null,null,null,null,"Strana 2:"]
[null,"P.Č.","Názov  tovaru","Poč. stav","Denný príjem","Spolu","Zostatok v sklade",null,"Denný predaj","Cena €","Suma celkom €",null,null,null,"Nákupná cena","Predajná cena","Tržba","Zisk","Zisk po zdanení",null,"Zostatok v krčme","Suma tovaru"]
[]
[null,"42.","PEPSI + 7UP 0,5l",null,null,{"$f":"D65+E65","v":0},null,null,{"$f":"D65+E65-G65","v":0},1.1000000000000001,{"$f":"I65*J65","v":0},"ks.",null,null,0.78,{"$f":"J65","v":1.1000000000000001},{"$f":"I65*J65","v":0},{"$f":"(P65-O65)*I65","v":0},{"$f":"R65*0.8","v":0},null,{"$f":"G65","v":0},{"$f":"U65*O65","v":0}]
[null,"43.","Sprite +Tonic",19.8,null,{"$f":"D66+E66","v":19.8},16.8,null,{"$f":"D66+E66-G66","v":3},2,{"$f":"I66*J66","v":6},"ks.",null,null,0.72599999999999998,{"$f":"J66","v":2},{"$f":"I66*J66","v":6},{"$f":"(P66-O66)*I66","v":3.8220000000000001},{"$f":"R66*0.8","v":3.0576000000000003},null,{"$f":"G66","v":16.8},{"$f":"U66*O66","v":12.1968}]
[null,"44.","Minerálka 0,5l",67,null,67,60,null,7,0.9,6.3,"ks.",null,null,0.52800000000000002,0.9,6.3,{"$f":"(P67-O67)*I67","v":2.6040000000000001},2.0832000000000002,null,60,31.68]
[null,"45.","Kofola 0,5l",13,null,13,12,null,1,1.1000000000000001,1.1000000000000001,"ks.",null,null,0.49,1.1000000000000001,1.1000000000000001,0.6100000000000001,0.4880000000000001,null,12,5.88]
[null,"46.","Džús krabička",60,null,60,58,null,2,0.5,1,"ks.",null,null,0.17,0.5,1,0.65999999999999992,0.52799999999999991,null,58,9.8600000000000012]
[null,"47.","Energetický nápoj",6,-2,4,4,null,0,1.8,0,"ks.",null,null,0.25,1.8,0,0,0,null,4,1]
[null,"48.","Limo 0,33l fľaša",51,20,71,66,null,5,0.5,2.5,"ks.",null,null,0.1,0.5,2.5,2,1.6,null,66,6.6000000000000005]
[null,"49.","Minerálka 2l",52,null,52,47.6,null,4.3999999999999986,1.5,6.5999999999999979,"l.",null,null,0.23,1.5,6.5999999999999979,5.5879999999999983,4.4703999999999988,null,47.6,10.948]
[null,"50.","Relax džús fľaška",15,48,63,62,null,1,1,1,"ks.",null,null,0.55000000000000004,1,1,0.44999999999999996,0.36,null,62,34.1]
[null,"51.","Ďžús nalievaný",16.5,null,16.5,15.4,null,1.0999999999999996,3,3.2999999999999989,"l.",null,null,1.1879999999999999,3,3.2999999999999989,1.9931999999999994,1.5945599999999995,null,15.4,18.295200000000001]
[null,"52.","Toma",23,null,23,23,null,0,1.1000000000000001,0,"l.",null,null,0.33,1.1000000000000001,0,0,0,null,23,7.5900000000000007]
[null,"53.","HELLO Jupík",36,null,36,33,null,3,0.8,2.4000000000000004,"ks.",null,null,0.33,0.8,2.4000000000000004,1.4100000000000001,1.1280000000000001,null,33,10.89]
[null,"54.","COCA COLA",27,null,27,25,null,2,1.1000000000000001,2.2000000000000002,"ks.",null,null,0.624,1.1000000000000001,2.2000000000000002,0.95200000000000018,0.76160000000000017,null,25,15.6]
[null,"55.","Vinea",21,6,27,25,null,2,1.1000000000000001,2.2000000000000002,"ks.",null,null,0.504,1.1000000000000001,2.2000000000000002,1.1920000000000002,0.95360000000000023,null,25,12.6]
[null,"56.","ALOE VERA",null,24,24,24,null,0,1.2,0,"ks.",null,null,0.65,1.2,0,0,0,null,24,15.600000000000001]
[null,"57.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"58.","Káva turecká",860,null,860,780,null,{"$f":"(D81+E81-G81)/7","v":11.428571428571429},0.5,5.7142857142857144,"gr.",null,null,3.4000000000000002E-2,0.5,{"$f":"K81","v":5.7142857142857144},5.3257142857142856,4.2605714285714287,null,780,26.520000000000003]
[null,"59.","Nescafé 3v1",55,null,55,52,null,3,0.5,1.5,"ks.",null,null,0.14000000000000001,0.5,1.5,1.08,0.8640000000000001,null,52,7.2800000000000011]
[null,"60.","Čaj",104,null,104,104,null,0,0.5,{"$f":"I83*J83","v":0},"ks.",null,null,5.8000000000000003E-2,0.5,{"$f":"I83*J83","v":0},0,0,null,104,{"$f":"U83*O84","v":3.7439999999999998}]
[null,"61.","Mlieko do kávy",32,100,132,128,null,4,0.1,{"$f":"I84*J84","v":0.4},"ks.",null,null,3.5999999999999997E-2,0.1,{"$f":"I84*J84","v":0.4},0.25600000000000001,0.20480000000000001,null,128,{"$f":"U84*O85","v":1.024}]
[null,"62.","Cukor HB",173,950,1123,1095,null,28,0.05,{"$f":"I85*J85","v":1.4000000000000001},"ks.",null,null,8.0000000000000002E-3,0.05,{"$f":"I85*J85","v":1.4000000000000001},1.1760000000000002,0.94080000000000019,null,1095,{"$f":"U85*O86","v":0}]
[null,"63.",null,null,null,0,null,null,0,null,{"$f":"I86*J86","v":0},null,null,null,null,0,{"$f":"I86*J86","v":0},0,0,null,0,{"$f":"U86*O87","v":0}]
[null,"64.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"65.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"66.","Golden",27,30,57,43,null,14,3.4,47.6,"ks.",null,null,3.22,3.4,47.6,2.519999999999996,2.0159999999999969,null,43,138.46]
[null,"67.","Petra 3,40€",3,20,23,22,null,1,3.4,3.4,"ks.",null,null,3.23,3.4,3.4,0.16999999999999993,0.13599999999999995,null,22,71.06]
[null,"68.","Malboro 3,70€",10,10,20,14,null,6,3.7,22.200000000000003,"ks.",null,null,3.51,3.7,22.200000000000003,1.1400000000000023,0.91200000000000192,null,14,49.14]
[null,"69.","LM 3,40€",18,60,78,61,null,17,3.4,57.8,"ks.",null,null,3.23,3.4,57.8,2.8899999999999988,2.3119999999999989,null,61,197.03]
[null,"70.","Mars",null,10,10,10,null,0,3.4,0,"ks.",null,null,3.22,3.4,0,0,0,null,10,32.200000000000003]
[null,"71.","West",37,20,57,49,null,8,3.2,25.6,"ks.",null,null,3.04,3.2,25.6,1.2800000000000011,1.0240000000000009,null,49,148.96]
[null,"72.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"73.","Malboro 4,00€",null,null,0,null,null,0,4,0,"ks.",null,null,3.9,4,0,0,0,null,0,0]
[null,"74.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"75.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"76.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"77.","Hyg. vreckovky",11,null,11,10,null,1,0.2,0.2,"ks.",null,null,8.8999999999999996E-2,0.2,0.2,0.11100000000000002,8.8800000000000018E-2,null,10,0.8899999999999999]
[null,"78.","Zapaľovač",52,null,52,52,null,0,0.5,0,"ks.",null,null,0.17,0.5,0,0,0,null,52,8.84]
[null,"79.","Zápalky",46,null,46,46,null,0,0.1,0,"ks.",null,null,0.04,0.1,0,0,0,null,46,1.84]
[null,"80.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"81.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"82.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[]
[null,null,null,{"$f":"SUM(D65:D105)","v":1835.3},null,null,{"$f":"SUM(G65:G105)","v":2937.8},null,null,"Celkom :",{"$f":"SUM(K65:K105)","v":200.41428571428571},null,null,null,null,"Celkom:",{"$f":"SUM(Q65:Q105)","v":200.41428571428571},{"$f":"SUM(R65:R105)","v":37.22991428571428},{"$f":"SUM(S65:S105)","v":29.783931428571425},null,"Za tovar:",{"$f":"SUM(V65:V105)","v":879.8280000000002}]
[]
[]
[]
[]
[]
[]
[null,null,"Strana 3:",null,null,null,null,null,null,null,null,null,null,null,"Strana 3:"]
[null,"P.Č.","Názov  tovaru","Poč. stav","Denný príjem","Spolu","Zostatok v sklade",null,"Denný predaj","Cena €","Suma celkom €",null,null,null,"Nákupná cena","Predajná cena","Tržba","Zisk","Zisk po zdanení",null,"Zostatok v krčme","Suma tovaru"]
[]
[null,"83.","Kinderko",null,null,{"$f":"D117+E117","v":0},null,null,{"$f":"D117+E117-G117","v":0},1.2,{"$f":"I117*J117","v":0},"ks.",null,null,0.93,{"$f":"J117","v":1.2},{"$f":"I117*J117","v":0},{"$f":"(P117-O117)*I117","v":0},{"$f":"R117*0.8","v":0},null,{"$f":"G117","v":0},{"$f":"U117*O117","v":0}]
[null,"84.","Horalka",23,null,{"$f":"D118+E118","v":23},19,null,{"$f":"D118+E118-G118","v":4},0.6,{"$f":"I118*J118","v":2.4},"ks.",null,null,0.31,{"$f":"J118","v":0.6},{"$f":"I118*J118","v":2.4},{"$f":"(P118-O118)*I118","v":1.1599999999999999},{"$f":"R118*0.8","v":0.92799999999999994},null,{"$f":"G118","v":19},{"$f":"U118*O118","v":5.89}]
[null,"85.","Kávenky",25,null,25,25,null,0,0.6,0,"ks.",null,null,0.28000000000000003,0.6,0,{"$f":"(P119-O119)*I119","v":0},0,null,25,7.0000000000000009]
[null,"86.","Kinder čokoláda",5,null,5,5,null,0,1.8,0,"ks.",null,null,0.9,1.8,0,0,0,null,5,4.5]
[null,"87.","3-BIT",15,null,15,15,null,0,0.6,0,"ks.",null,null,0.32,0.6,0,0,0,null,15,4.8]
[null,"88.","Banán",7,10,17,14,null,3,0.6,1.7999999999999998,"ks.",null,null,0.26,0.6,1.7999999999999998,1.02,0.81600000000000006,null,14,3.64]
[null,"89.","Margot",13,null,13,12,null,1,0.6,0.6,"ks.",null,null,0.4,0.6,0.6,0.19999999999999996,0.15999999999999998,null,12,4.8000000000000007]
[null,"90.","Lízatko 2",null,null,0,null,null,0,0.2,0,"ks.",null,null,0.04,0.2,0,0,0,null,0,0]
[null,"91.","Mila",17,null,17,17,null,0,0.6,0,"ks.",null,null,0.37,0.6,0,0,0,null,17,6.29]
[null,"92.","Lízatko",123,null,123,123,null,0,0.3,0,"ks.",null,null,0.1,0.3,0,0,0,null,123,12.3]
[null,"93.","Chipsy",24,24,48,39,null,9,1,9,"ks.",null,null,0.42,1,9,5.2200000000000006,4.176000000000001,null,39,16.38]
[null,"94.","Tofife",9,null,9,9,null,0,3,0,"ks.",null,null,1.62,3,0,0,0,null,9,14.580000000000002]
[null,"95.","Milka čok.",2,5,7,7,null,0,1.5,0,"ks.",null,null,0.73,1.5,0,0,0,null,7,5.1099999999999994]
[null,"96.","Tyčinky DRU",28,null,28,28,null,0,0.5,0,"ks.",null,null,0.23,0.5,0,0,0,null,28,6.44]
[null,"97.","Arašidy",8,null,8,8,null,0,0.8,0,"ks.",null,null,0.41,0.8,0,0,0,null,8,3.28]
[null,"98.","TIC-TAC",74,null,74,71,null,3,0.6,1.7999999999999998,"ks.",null,null,0.3,0.6,1.7999999999999998,0.89999999999999991,0.72,null,71,21.3]
[null,"99.","Žuvažky plátky",56,null,56,45,null,11,0.1,1.1000000000000001,"ks.",null,null,5.1999999999999998E-2,0.1,1.1000000000000001,0.52800000000000014,0.42240000000000011,null,45,2.34]
[null,"100.","Žuvažky dražé",7,60,67,64,null,3,0.6,1.7999999999999998,"ks.",null,null,0.37,0.6,1.7999999999999998,0.69,0.55199999999999994,null,64,23.68]
[null,"101.","Hašlerky",8,null,8,8,null,0,0.9,0,"ks.",null,null,0.54,0.9,0,0,0,null,8,4.32]
[null,"102.","Žuvačky guličky",45,null,45,45,null,0,0.7,0,"ks.",null,null,0.3,0.7,0,0,0,null,45,13.5]
[null,"103.","Chrumky",null,null,0,null,null,0,0.6,0,"ks.",null,null,0.27,0.6,0,0,0,null,0,0]
[null,"104.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"105.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"106.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"107.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"108.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,{"$f":"SUM(D117:D142)","v":489},null,null,{"$f":"SUM(G117:G142)","v":554},null,null,"Celkom:",{"$f":"SUM(K117:K142)","v":18.5},null,null,null,null,"Celkom:",{"$f":"SUM(Q117:Q142)","v":18.5},{"$f":"SUM(R117:R142)","v":9.718},{"$f":"SUM(S117:S142)","v":7.7744},null,"Za tovar:",{"$f":"SUM(V117:V142)","v":160.14999999999998}]
[]
[]
[null,null,null,"Stávková:",null,10,null,null,"Strana 1:",{"$f":"K55","v":389.78000000000009},null,null,null,null,null,"Strana 1",{"$f":"Q55","v":389.78000000000009},{"$f":"R55","v":202.506},{"$f":"S55","v":162.00480000000002},null,"Strana 1:",{"$f":"V55","v":1947.7872}]
[null,null,null,"Refil:",null,null,null,null,"Strana 2:",{"$f":"K107","v":200.41428571428571},null,null,null,null,null,"Strana 2",{"$f":"Q107","v":200.41428571428571},{"$f":"R107","v":37.22991428571428},{"$f":"S107","v":29.783931428571425},null,"Strana 2:",{"$f":"V107","v":879.8280000000002}]
[null,null,null,"Výdavky:",null,52.5,null,null,"Strana 3:",{"$f":"K144","v":18.5},null,null,null,null,null,"Strana 3",{"$f":"Q144","v":18.5},{"$f":"R144","v":9.718},{"$f":"S144","v":7.7744},null,"Strana 3:",{"$f":"V144","v":160.14999999999998}]
[]
[null,null,null,null,"Spolu:",{"$f":"SUM(F147:F149)","v":62.5},null,null,"Spolu:",{"$f":"SUM(J147:J149)","v":608.6942857142858},null,null,null,null,null,"Spolu:",{"$f":"SUM(Q147:Q149)","v":608.6942857142858},{"$f":"SUM(R147:R149)","v":249.45391428571426},{"$f":"SUM(S147:S149)","v":199.56313142857147},null,"Spolu:",{"$f":"SUM(V147:V149)","v":2987.7652000000003}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spolu:",{"$f":"Q151-F151","v":546.1942857142858},{"$f":"R151-G151","v":249.45391428571426},{"$f":"S151-H151","v":199.56313142857147}]
[null,null,null,null,null,null,null,null,"Celkom :",{"$f":"J151-F151","v":546.1942857142858}]
[]
[null,null,"Zostatok hotovosť:",546]
[]
[null,null,"rozdiel:",{"$f":"D156-J154","v":-0.19428571428579744}]

{"sheet":"3","index":9,"n_rows":158,"n_cols":22,"rows_kept":158,"cut":false,"hidden":false,"merged":[[10,1,11,1],[10,2,11,2],[10,3,11,3],[10,4,11,4],[10,5,11,5],[0,6,0,8],[0,14,0,17],[1,15,1,16],[4,7,4,9],[6,7,6,8],[10,20,11,20],[10,21,11,21],[10,6,11,6],[10,8,11,8],[10,9,11,9],[10,10,11,10],[10,11,11,11],[10,14,11,14],[62,6,63,6],[10,15,11,15],[10,16,11,16],[10,17,11,17],[10,18,11,18],[62,17,63,17],[62,18,63,18],[62,1,63,1],[62,2,63,2],[62,3,63,3],[62,4,63,4],[62,5,63,5],[62,20,63,20],[62,21,63,21],[114,1,115,1],[114,2,115,2],[114,3,115,3],[114,4,115,4],[114,5,115,5],[114,6,115,6],[62,8,63,8],[62,9,63,9],[62,10,63,10],[62,14,63,14],[62,15,63,15],[62,16,63,16],[114,18,115,18],[114,20,115,20],[114,21,115,21],[146,3,146,4],[147,3,147,4],[114,8,115,8],[114,9,115,9],[114,10,115,10],[114,14,115,14],[114,15,115,15],[114,16,115,16],[148,3,148,4],[155,3,155,4],[156,3,156,4],[157,3,157,4],[114,17,115,17]]}
[null,null,null,"Vyučtovanie výčapu ",null,null,"august",null,null,"/2019",null,null,null,null,"Denný sumár"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Juniorka","Meno:",{"$f":"I2","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Šipulová","Dátum:",{"$f":"I3","v":0},"/2019"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Hermanová"]
[null,null,null,null,null,null,"Meno:"]
[]
[null,null,null,null,null,null,"Dátum:",null,null,"/2019"]
[]
[]
[null,null,"Strana 1:",null,null,null,null,null,null,null,null,null,null,null,"Strana 1:"]
[null,"P.Č.","Názov  tovaru","Poč. stav","Denný príjem","Spolu","Zostatok v sklade",null,"Denný predaj","Cena €","Suma celkom €","J.M.",null,null,"Nákupná cena","Predajná cena","Tržba","Zisk","Zisk po zdanení",null,"Zostatok v krčme","Suma tovaru"]
[]
[null,"1.","Pernštejn čap. 10˚",193.8,null,{"$f":"D13+E13","v":193.8},139.80000000000001,null,{"$f":"D13+E13-G13","v":54},2,{"$f":"I13*J13","v":108},"l.",null,null,1.032,{"$f":"J13","v":2},{"$f":"I13*J13","v":108},{"$f":"(P13-O13)*I13","v":52.271999999999998},{"$f":"R13*0.8","v":41.817599999999999},null,{"$f":"G13","v":139.80000000000001},{"$f":"U13*O13","v":144.27360000000002}]
[null,"2.","Malinovka čap.",132.80000000000001,null,132.80000000000001,102.1,null,30.700000000000017,2,{"$f":"I14*J14","v":61.400000000000034},"l.",null,null,0.49299999999999999,{"$f":"J14","v":2},{"$f":"I14*J14","v":61.400000000000034},{"$f":"(P14-O14)*I14","v":46.264900000000033},{"$f":"R14*0.8","v":37.011920000000025},null,{"$f":"G14","v":102.1},{"$f":"U14*O14","v":50.335299999999997}]
[null,"3.","Radler čap.",34.6,null,34.6,30,null,4.6000000000000014,2.6,11.960000000000004,"l.",null,null,1.52,2.6,11.960000000000004,{"$f":"(P15-O15)*I15","v":4.9680000000000017},3.9744000000000015,null,30,45.6]
[null,"4.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"5.","Šariš 10˚ fľaša",33,null,33,28,null,5,0.8,4,"ks.",null,null,0.34,0.8,4,2.3000000000000003,1.8400000000000003,null,28,9.5200000000000014]
[null,"6.","Kozel 10˚ fľaša",32,null,32,26,null,6,0.9,5.4,"ks.",null,null,0.47,0.9,5.4,2.58,2.0640000000000001,null,26,12.219999999999999]
[null,"7.","Birell nealko fľaša",34,null,34,30,null,4,1.2,4.8,"ks.",null,null,0.64,1.2,4.8,2.2399999999999998,1.7919999999999998,null,30,19.2]
[null,"8.","Gambrinus fľaša",37,null,37,27,null,10,0.9,9,"ks.",null,null,0.56000000000000005,0.9,9,3.3999999999999995,2.7199999999999998,null,27,15.120000000000001]
[null,"9.","Plzeň 12˚ fľaša",23,null,23,14,null,9,1.3,11.700000000000001,"ks.",null,null,0.69399999999999995,1.3,11.700000000000001,5.4540000000000006,4.3632000000000009,null,14,9.7159999999999993]
[null,"10.",null,null,null,0,null,null,0,null,0,"ks.",null,null,null,0,0,0,0,null,0,0]
[null,"11.","Gambrinus plech.",30,null,30,26,null,4,0.9,3.6,"ks.",null,null,0.49,0.9,3.6,1.6400000000000001,1.3120000000000003,null,26,12.74]
[null,"12.",null,null,null,0,null,null,0,null,0,"ks.",null,null,0.42,0,0,0,0,null,0,0]
[null,"13.",null,null,null,0,null,null,0,null,0,"ks.",null,null,0.75,0,0,0,0,null,0,0]
[null,"14.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"15.","Práznde sudy",null,null,0,null,null,0,null,0,"ks.",null,null,null,0,0,0,0,null,0,0]
[null,"16.","Práznde fľaše",null,null,0,null,null,0,null,0,"ks.",null,null,null,0,0,0,0,null,0,0]
[null,"17.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"18.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"19.","Víno biele",42.1,null,42.1,38.200000000000003,null,3.8999999999999986,3,11.699999999999996,"l.",null,null,1.29,3,11.699999999999996,6.6689999999999978,5.3351999999999986,null,38.200000000000003,49.278000000000006]
[null,"20.","Víno červené",23.5,null,23.5,21.8,null,1.6999999999999993,3,5.0999999999999979,"l.",null,null,1.29,3,5.0999999999999979,2.9069999999999987,2.3255999999999992,null,21.8,28.122000000000003]
[null,"21.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"22.","Vodka",47.9,null,47.9,42,null,5.8999999999999986,12,70.799999999999983,"l.",null,null,6.54,12,70.799999999999983,32.213999999999992,25.771199999999993,null,42,274.68]
[null,"23.","Borovička",62.8,null,62.8,56,null,6.7999999999999972,12,81.599999999999966,"l.",null,null,6.56,12,81.599999999999966,36.99199999999999,29.593599999999995,null,56,367.35999999999996]
[null,"24.","Koniferka",10.95,null,10.95,9.6999999999999993,null,1.25,14,17.5,"l.",null,null,5.95,14,17.5,10.0625,8.0500000000000007,null,9.6999999999999993,57.714999999999996]
[null,"25.","RUM",13.5,null,13.5,12.05,null,1.4499999999999993,12,17.399999999999991,"l.",null,null,5.78,12,17.399999999999991,9.0189999999999948,7.2151999999999958,null,12.05,69.649000000000001]
[null,"26.","Hruška",7.2,null,7.2,6.8,null,0.40000000000000036,14,5.600000000000005,"l.",null,null,7.2,14,5.600000000000005,2.7200000000000024,2.1760000000000019,null,6.8,48.96]
[null,"27.","Spišská borovička",4.0999999999999996,null,4.0999999999999996,4.0999999999999996,null,0,14,0,"l.",null,null,8.5500000000000007,14,0,0,0,null,4.0999999999999996,35.055]
[null,"28.","Trenčianské hradné",13.95,null,13.95,11.95,null,2,12,24,"l.",null,null,6.6360000000000001,12,24,10.728,8.5823999999999998,null,11.95,79.300200000000004]
[null,"29.","Karpatská horká",9.75,null,9.75,6.7,null,3.05,12,36.599999999999994,"l.",null,null,5.32,12,36.599999999999994,20.373999999999999,16.299199999999999,null,6.7,35.644000000000005]
[null,"30.","Vodka Peach",5.4,null,5.4,4.6500000000000004,null,0.75,14,10.5,"l.",null,null,4.41,14,10.5,7.1924999999999999,5.7540000000000004,null,4.6500000000000004,20.506500000000003]
[null,"31.","Becherovka",5.15,null,5.15,5,null,0.15000000000000036,20,3.0000000000000071,"l.",null,null,10.67,20,3.0000000000000071,1.3995000000000033,1.1196000000000026,null,5,53.35]
[null,"32.","Fernet",6,null,6,5.5,null,0.5,20,10,"l.",null,null,9.69,20,10,5.1550000000000002,4.1240000000000006,null,5.5,53.294999999999995]
[null,"33.","Slivka",4.9000000000000004,null,4.9000000000000004,4.8499999999999996,null,5.0000000000000711E-2,14,0.70000000000000995,"l.",null,null,7.21,14,0.70000000000000995,0.33950000000000485,0.27160000000000389,null,4.8499999999999996,34.968499999999999]
[null,"34.","Bošácka slivovica",4.9000000000000004,null,4.9000000000000004,4.8499999999999996,null,5.0000000000000711E-2,24,1.2000000000000171,"l.",null,null,17.61,24,1.2000000000000171,0.31950000000000456,0.25560000000000366,null,4.8499999999999996,85.408499999999989]
[null,"35.","Karpatská KB",null,null,0,null,null,0,20,0,"l.",null,null,5.9980000000000002,20,0,0,0,null,0,0]
[null,"36.","Fernet Citrus",null,null,0,null,null,0,20,0,"l.",null,null,9.69,20,0,0,0,null,0,0]
[null,"37.","Pepermint",5.9,null,5.9,5.4,null,0.5,12,6,"l.",null,null,5.2,12,6,3.4,2.72,null,5.4,28.080000000000002]
[null,"38.","Nicolaus vodka",3.45,null,3.45,2.8,null,0.65000000000000036,18,11.700000000000006,"l.",null,null,8.6199999999999992,18,11.700000000000006,6.097000000000004,4.8776000000000037,null,2.8,24.135999999999996]
[null,"39.","Captain Morgan",2.2999999999999998,null,2.2999999999999998,2.0499999999999998,null,0.25,24,6,"l.",null,null,11.74,24,6,3.0649999999999999,2.452,null,2.0499999999999998,24.066999999999997]
[null,"40.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"41.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"SUM(D13:D53)","v":823.95},null,null,{"$f":"SUM(G13:G53)","v":667.3},null,null,"Celkom:",{"$f":"SUM(K13:K53)","v":539.2600000000001},null,null,null,null,"Celkom:",{"$f":"SUM(Q13:Q53)","v":539.2600000000001},{"$f":"SUM(R13:R53)","v":279.77239999999995},{"$f":"SUM(S13:S53)","v":223.81791999999999},null,"Za tovar:",{"$f":"SUM(V13:V53)","v":1688.2995999999996}]
[]
[]
[]
[]
[]
[]
[null,null,"Strana 2:",null,null,null,null,null,null,null,null,null,null,null,"Strana 2:"]
[null,"P.Č.","Názov  tovaru","Poč. stav","Denný príjem","Spolu","Zostatok v sklade",null,"Denný predaj","Cena €","Suma celkom €",null,null,null,"Nákupná cena","Predajná cena","Tržba","Zisk","Zisk po zdanení",null,"Zostatok v krčme","Suma tovaru"]
[]
[null,"42.","PEPSI + 7UP 0,5l",null,null,{"$f":"D65+E65","v":0},null,null,{"$f":"D65+E65-G65","v":0},1.1000000000000001,{"$f":"I65*J65","v":0},"ks.",null,null,0.78,{"$f":"J65","v":1.1000000000000001},{"$f":"I65*J65","v":0},{"$f":"(P65-O65)*I65","v":0},{"$f":"R65*0.8","v":0},null,{"$f":"G65","v":0},{"$f":"U65*O65","v":0}]
[null,"43.","Sprite +Tonic",16.8,null,{"$f":"D66+E66","v":16.8},15.1,null,{"$f":"D66+E66-G66","v":1.7000000000000011},2,{"$f":"I66*J66","v":3.4000000000000021},"ks.",null,null,0.72599999999999998,{"$f":"J66","v":2},{"$f":"I66*J66","v":3.4000000000000021},{"$f":"(P66-O66)*I66","v":2.1658000000000013},{"$f":"R66*0.8","v":1.7326400000000011},null,{"$f":"G66","v":15.1},{"$f":"U66*O66","v":10.9626}]
[null,"44.","Minerálka 0,5l",60,null,60,44,null,16,0.9,14.4,"ks.",null,null,0.52800000000000002,0.9,14.4,{"$f":"(P67-O67)*I67","v":5.952},4.7616000000000005,null,44,23.231999999999999]
[null,"45.","Kofola 0,5l",12,null,12,12,null,0,1.1000000000000001,0,"ks.",null,null,0.49,1.1000000000000001,0,0,0,null,12,5.88]
[null,"46.","Džús krabička",58,null,58,58,null,0,0.5,0,"ks.",null,null,0.17,0.5,0,0,0,null,58,9.8600000000000012]
[null,"47.","Energetický nápoj",4,null,4,4,null,0,1.8,0,"ks.",null,null,0.25,1.8,0,0,0,null,4,1]
[null,"48.","Limo 0,33l fľaša",66,null,66,60,null,6,0.5,3,"ks.",null,null,0.1,0.5,3,2.4000000000000004,1.9200000000000004,null,60,6]
[null,"49.","Minerálka 2l",47.6,null,47.6,44.1,null,3.5,1.5,5.25,"l.",null,null,0.23,1.5,5.25,4.4450000000000003,3.5560000000000005,null,44.1,10.143000000000001]
[null,"50.","Relax džús fľaška",62,null,62,61,null,1,1,1,"ks.",null,null,0.55000000000000004,1,1,0.44999999999999996,0.36,null,61,33.550000000000004]
[null,"51.","Ďžús nalievaný",15.4,null,15.4,14.2,null,1.2000000000000011,3,3.6000000000000032,"l.",null,null,1.1879999999999999,3,3.6000000000000032,2.1744000000000021,1.7395200000000017,null,14.2,16.869599999999998]
[null,"52.","Toma",23,null,23,18,null,5,1.1000000000000001,5.5,"l.",null,null,0.33,1.1000000000000001,5.5,3.85,3.08,null,18,5.94]
[null,"53.","HELLO Jupík",33,null,33,33,null,0,0.8,0,"ks.",null,null,0.33,0.8,0,0,0,null,33,10.89]
[null,"54.","COCA COLA",25,null,25,22,null,3,1.1000000000000001,3.3000000000000003,"ks.",null,null,0.624,1.1000000000000001,3.3000000000000003,1.4280000000000004,1.1424000000000003,null,22,13.728]
[null,"55.","Vinea",25,null,25,24,null,1,1.1000000000000001,1.1000000000000001,"ks.",null,null,0.504,1.1000000000000001,1.1000000000000001,0.59600000000000009,0.47680000000000011,null,24,12.096]
[null,"56.","ALOE VERA",24,null,24,19,null,5,1.2,6,"ks.",null,null,0.65,1.2,6,2.7499999999999996,2.1999999999999997,null,19,12.35]
[null,"57.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"58.","Káva turecká",780,null,780,700,null,{"$f":"(D81+E81-G81)/7","v":11.428571428571429},0.5,5.7142857142857144,"gr.",null,null,3.4000000000000002E-2,0.5,{"$f":"K81","v":5.7142857142857144},5.3257142857142856,4.2605714285714287,null,700,23.8]
[null,"59.","Nescafé 3v1",52,null,52,50,null,2,0.5,1,"ks.",null,null,0.14000000000000001,0.5,1,0.72,0.57599999999999996,null,50,7.0000000000000009]
[null,"60.","Čaj",104,null,104,102,null,2,0.5,{"$f":"I83*J83","v":1},"ks.",null,null,5.8000000000000003E-2,0.5,{"$f":"I83*J83","v":1},0.88400000000000001,0.70720000000000005,null,102,{"$f":"U83*O84","v":3.6719999999999997}]
[null,"61.","Mlieko do kávy",128,null,128,126,null,2,0.1,{"$f":"I84*J84","v":0.2},"ks.",null,null,3.5999999999999997E-2,0.1,{"$f":"I84*J84","v":0.2},0.128,0.1024,null,126,{"$f":"U84*O85","v":1.008}]
[null,"62.","Cukor HB",1095,null,1095,1071,null,24,0.05,{"$f":"I85*J85","v":1.2000000000000002},"ks.",null,null,8.0000000000000002E-3,0.05,{"$f":"I85*J85","v":1.2000000000000002},1.008,0.80640000000000001,null,1071,{"$f":"U85*O86","v":0}]
[null,"63.",null,null,null,0,null,null,0,null,{"$f":"I86*J86","v":0},null,null,null,null,0,{"$f":"I86*J86","v":0},0,0,null,0,{"$f":"U86*O87","v":0}]
[null,"64.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"65.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"66.","Golden",43,null,43,35,null,8,3.4,27.2,"ks.",null,null,3.22,3.4,27.2,1.4399999999999977,1.1519999999999981,null,35,112.7]
[null,"67.","Petra 3,40€",22,null,22,17,null,5,3.4,17,"ks.",null,null,3.23,3.4,17,0.84999999999999964,0.67999999999999972,null,17,54.91]
[null,"68.","Malboro 3,70€",14,null,14,7,null,7,3.7,25.900000000000002,"ks.",null,null,3.51,3.7,25.900000000000002,1.3300000000000027,1.0640000000000023,null,7,24.57]
[null,"69.","LM 3,40€",61,null,61,52,null,9,3.4,30.599999999999998,"ks.",null,null,3.23,3.4,30.599999999999998,1.5299999999999994,1.2239999999999995,null,52,167.96]
[null,"70.","Mars",10,null,10,10,null,0,3.4,0,"ks.",null,null,3.22,3.4,0,0,0,null,10,32.200000000000003]
[null,"71.","West",49,null,49,44,null,5,3.2,16,"ks.",null,null,3.04,3.2,16,0.80000000000000071,0.64000000000000057,null,44,133.76]
[null,"72.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"73.","Malboro 4,00€",null,null,0,null,null,0,4,0,"ks.",null,null,3.9,4,0,0,0,null,0,0]
[null,"74.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"75.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"76.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"77.","Hyg. vreckovky",10,null,10,8,null,2,0.2,0.4,"ks.",null,null,8.8999999999999996E-2,0.2,0.4,0.22200000000000003,0.17760000000000004,null,8,0.71199999999999997]
[null,"78.","Zapaľovač",52,null,52,51,null,1,0.5,0.5,"ks.",null,null,0.17,0.5,0.5,0.32999999999999996,0.26399999999999996,null,51,8.67]
[null,"79.","Zápalky",46,null,46,45,null,1,0.1,0.1,"ks.",null,null,0.04,0.1,0.1,6.0000000000000005E-2,4.8000000000000008E-2,null,45,1.8]
[null,"80.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"81.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"82.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[]
[null,null,null,{"$f":"SUM(D65:D105)","v":2937.8},null,null,{"$f":"SUM(G65:G105)","v":2746.4},null,null,"Celkom :",{"$f":"SUM(K65:K105)","v":173.36428571428573},null,null,null,null,"Celkom:",{"$f":"SUM(Q65:Q105)","v":173.36428571428573},{"$f":"SUM(R65:R105)","v":40.838914285714303},{"$f":"SUM(S65:S105)","v":32.671131428571435},null,"Za tovar:",{"$f":"SUM(V65:V105)","v":745.26319999999998}]
[]
[]
[]
[]
[]
[]
[null,null,"Strana 3:",null,null,null,null,null,null,null,null,null,null,null,"Strana 3:"]
[null,"P.Č.","Názov  tovaru","Poč. stav","Denný príjem","Spolu","Zostatok v sklade",null,"Denný predaj","Cena €","Suma celkom €",null,null,null,"Nákupná cena","Predajná cena","Tržba","Zisk","Zisk po zdanení",null,"Zostatok v krčme","Suma tovaru"]
[]
[null,"83.","Kinderko",null,null,{"$f":"D117+E117","v":0},null,null,{"$f":"D117+E117-G117","v":0},1.2,{"$f":"I117*J117","v":0},"ks.",null,null,0.93,{"$f":"J117","v":1.2},{"$f":"I117*J117","v":0},{"$f":"(P117-O117)*I117","v":0},{"$f":"R117*0.8","v":0},null,{"$f":"G117","v":0},{"$f":"U117*O117","v":0}]
[null,"84.","Horalka",19,null,{"$f":"D118+E118","v":19},17,null,{"$f":"D118+E118-G118","v":2},0.6,{"$f":"I118*J118","v":1.2},"ks.",null,null,0.31,{"$f":"J118","v":0.6},{"$f":"I118*J118","v":1.2},{"$f":"(P118-O118)*I118","v":0.57999999999999996},{"$f":"R118*0.8","v":0.46399999999999997},null,{"$f":"G118","v":17},{"$f":"U118*O118","v":5.27}]
[null,"85.","Kávenky",25,null,25,24,null,1,0.6,0.6,"ks.",null,null,0.28000000000000003,0.6,0.6,{"$f":"(P119-O119)*I119","v":0.31999999999999995},0.25599999999999995,null,24,6.7200000000000006]
[null,"86.","Kinder čokoláda",5,null,5,4,null,1,1.8,1.8,"ks.",null,null,0.9,1.8,1.8,0.9,0.72000000000000008,null,4,3.6]
[null,"87.","3-BIT",15,null,15,15,null,0,0.6,0,"ks.",null,null,0.32,0.6,0,0,0,null,15,4.8]
[null,"88.","Banán",14,null,14,14,null,0,0.6,0,"ks.",null,null,0.26,0.6,0,0,0,null,14,3.64]
[null,"89.","Margot",12,null,12,8,null,4,0.6,2.4,"ks.",null,null,0.4,0.6,2.4,0.79999999999999982,0.6399999999999999,null,8,3.2]
[null,"90.","Lízatko 2",null,null,0,null,null,0,0.2,0,"ks.",null,null,0.04,0.2,0,0,0,null,0,0]
[null,"91.","Mila",17,null,17,10,null,7,0.6,4.2,"ks.",null,null,0.37,0.6,4.2,1.6099999999999999,1.288,null,10,3.7]
[null,"92.","Lízatko",123,null,123,119,null,4,0.3,1.2,"ks.",null,null,0.1,0.3,1.2,0.79999999999999993,0.64,null,119,11.9]
[null,"93.","Chipsy",39,null,39,32,null,7,1,7,"ks.",null,null,0.42,1,7,4.0600000000000005,3.2480000000000007,null,32,13.44]
[null,"94.","Tofife",9,null,9,9,null,0,3,0,"ks.",null,null,1.62,3,0,0,0,null,9,14.580000000000002]
[null,"95.","Milka čok.",7,null,7,5,null,2,1.5,3,"ks.",null,null,0.73,1.5,3,1.54,1.2320000000000002,null,5,3.65]
[null,"96.","Tyčinky DRU",28,null,28,28,null,0,0.5,0,"ks.",null,null,0.23,0.5,0,0,0,null,28,6.44]
[null,"97.","Arašidy",8,null,8,8,null,0,0.8,0,"ks.",null,null,0.41,0.8,0,0,0,null,8,3.28]
[null,"98.","TIC-TAC",71,null,71,69,null,2,0.6,1.2,"ks.",null,null,0.3,0.6,1.2,0.6,0.48,null,69,20.7]
[null,"99.","Žuvažky plátky",45,null,45,45,null,0,0.1,0,"ks.",null,null,5.1999999999999998E-2,0.1,0,0,0,null,45,2.34]
[null,"100.","Žuvažky dražé",64,null,64,59,null,5,0.6,3,"ks.",null,null,0.37,0.6,3,1.1499999999999999,0.91999999999999993,null,59,21.83]
[null,"101.","Hašlerky",8,null,8,8,null,0,0.9,0,"ks.",null,null,0.54,0.9,0,0,0,null,8,4.32]
[null,"102.","Žuvačky guličky",45,null,45,44,null,1,0.7,0.7,"ks.",null,null,0.3,0.7,0.7,0.39999999999999997,0.32,null,44,13.2]
[null,"103.","Chrumky",null,null,0,null,null,0,0.6,0,"ks.",null,null,0.27,0.6,0,0,0,null,0,0]
[null,"104.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"105.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"106.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"107.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"108.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,{"$f":"SUM(D117:D142)","v":554},null,null,{"$f":"SUM(G117:G142)","v":518},null,null,"Celkom:",{"$f":"SUM(K117:K142)","v":26.299999999999997},null,null,null,null,"Celkom:",{"$f":"SUM(Q117:Q142)","v":26.299999999999997},{"$f":"SUM(R117:R142)","v":12.76},{"$f":"SUM(S117:S142)","v":10.208},null,"Za tovar:",{"$f":"SUM(V117:V142)","v":146.60999999999999}]
[]
[]
[null,null,null,"Stávková:",null,null,null,null,"Strana 1:",{"$f":"K55","v":539.2600000000001},null,null,null,null,null,"Strana 1",{"$f":"Q55","v":539.2600000000001},{"$f":"R55","v":279.77239999999995},{"$f":"S55","v":223.81791999999999},null,"Strana 1:",{"$f":"V55","v":1688.2995999999996}]
[null,null,null,"Refil:",null,null,null,null,"Strana 2:",{"$f":"K107","v":173.36428571428573},null,null,null,null,null,"Strana 2",{"$f":"Q107","v":173.36428571428573},{"$f":"R107","v":40.838914285714303},{"$f":"S107","v":32.671131428571435},null,"Strana 2:",{"$f":"V107","v":745.26319999999998}]
[null,null,null,"Výdavky:",null,null,null,null,"Strana 3:",{"$f":"K144","v":26.299999999999997},null,null,null,null,null,"Strana 3",{"$f":"Q144","v":26.299999999999997},{"$f":"R144","v":12.76},{"$f":"S144","v":10.208},null,"Strana 3:",{"$f":"V144","v":146.60999999999999}]
[]
[null,null,null,null,"Spolu:",{"$f":"SUM(F147:F149)","v":0},null,null,"Spolu:",{"$f":"SUM(J147:J149)","v":738.92428571428582},null,null,null,null,null,"Spolu:",{"$f":"SUM(Q147:Q149)","v":738.92428571428582},{"$f":"SUM(R147:R149)","v":333.37131428571422},{"$f":"SUM(S147:S149)","v":266.69705142857146},null,"Spolu:",{"$f":"SUM(V147:V149)","v":2580.1727999999998}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spolu:",{"$f":"Q151-F151","v":738.92428571428582},{"$f":"R151-G151","v":333.37131428571422},{"$f":"S151-H151","v":266.69705142857146}]
[null,null,null,null,null,null,null,null,"Celkom :",{"$f":"J151-F151","v":738.92428571428582}]
[]
[null,null,"Zostatok hotovosť:"]
[]
[null,null,"rozdiel:",{"$f":"D156-J154","v":-738.92428571428582}]