{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Originál","Inventár","Sumár","Sklad","0","1","2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"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":"Originál","index":0,"n_rows":152,"n_cols":22,"rows_kept":152,"cut":false,"hidden":false,"merged":[[13,20,14,20],[13,21,14,21],[58,20,59,20],[58,21,59,21],[107,20,108,20],[107,21,108,21],[13,18,14,18],[58,1,59,1],[58,2,59,2],[58,3,59,3],[58,4,59,4],[13,1,14,1],[58,15,59,15],[58,16,59,16],[13,15,14,15],[13,16,14,16],[13,2,14,2],[13,3,14,3],[13,4,14,4],[58,6,59,6],[58,8,59,8],[58,9,59,9],[0,14,0,17],[1,15,1,16],[13,5,14,5],[13,6,14,6],[13,8,14,8],[13,9,14,9],[13,10,14,10],[13,11,14,11],[13,14,14,14],[2,7,2,8],[13,17,14,17],[0,2,0,9],[1,7,1,9],[58,18,59,18],[107,1,108,1],[107,2,108,2],[107,3,108,3],[107,4,108,4],[107,5,108,5],[107,6,108,6],[107,8,108,8],[107,9,108,9],[107,10,108,10],[107,14,108,14],[107,15,108,15],[107,16,108,16],[58,10,59,10],[58,14,59,14],[107,18,108,18],[58,5,59,5],[58,17,59,17],[141,3,141,4],[140,3,140,4],[142,3,142,4],[138,14,139,14],[138,15,139,15],[138,16,139,16],[138,17,139,17],[138,18,139,18],[149,3,149,4],[150,3,150,4],[151,3,151,4],[107,17,108,17]]}
[null,null,"Vyučtovanie výčapu 2018",null,null,null,null,null,null,null,null,null,null,null,"Denný sumár"]
[null,null,null,null,null,null,"Meno:",null,null,null,null,null,null,"Juniorka","Meno:",{"$f":"I2","v":0}]
[null,null,null,null,null,null,"Dátum:",null,null,"/2018",null,null,null,"Šipulová","Dátum:",{"$f":"I3","v":0},"/2018"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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.","aaa",null,null,{"$f":"D16+E16","v":0},null,null,{"$f":"D16+E16-G16","v":0},2,{"$f":"I16*J16","v":0},"l.",null,null,1.032,{"$f":"J16","v":2},{"$f":"I16*J16","v":0},{"$f":"(P16-O16)*I16","v":0},{"$f":"R16*0.8","v":0},null,{"$f":"G16","v":0},{"$f":"U16*O16","v":0}]
[null,"2.","sss",null,null,0,null,null,0,2,{"$f":"I17*J17","v":0},"l.",null,null,0.49299999999999999,{"$f":"J17","v":2},{"$f":"I17*J17","v":0},{"$f":"(P17-O17)*I17","v":0},{"$f":"R17*0.8","v":0},null,{"$f":"G17","v":0},{"$f":"U17*O17","v":0}]
[null,"3.","dddd",null,null,0,null,null,0,2.8,0,"l.",null,null,1.52,2.8,0,{"$f":"(P18-O18)*I18","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.","ref",null,null,0,null,null,0,0.8,0,"ks.",null,null,0.41,0.8,0,0,0,null,0,0]
[null,"6.","erfer",null,null,0,null,null,0,0.9,0,"ks.",null,null,0.47,0.9,0,0,0,null,0,0]
[null,"7.","erferf",null,null,0,null,null,0,1.2,0,"ks.",null,null,0.64,1.2,0,0,0,null,0,0]
[null,"8.","erferf",null,null,0,null,null,0,0.9,0,"ks.",null,null,0.49,0.9,0,0,0,null,0,0]
[null,"9.","ergfer",null,null,0,null,null,0,1.3,0,"ks.",null,null,0.93,1.3,0,0,0,null,0,0]
[null,"10.","rgerg",null,null,0,null,null,0,1,0,"ks.",null,null,0.77,1,0,0,0,null,0,0]
[null,"11.","hzh",null,null,0,null,null,0,0.9,0,"ks.",null,null,0.49,0.9,0,0,0,null,0,0]
[null,"12.","zthtz",null,null,0,null,null,0,1,0,"ks.",null,null,0.42,1,0,0,0,null,0,0]
[null,"13.",null,null,null,0,null,null,0,1.2,0,"ks.",null,null,0.75,1.2,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.",null,null,null,0,null,null,0,3,0,"l.",null,null,1.29,3,0,0,0,null,0,0]
[null,"16.",null,null,null,0,null,null,0,3,0,"l.",null,null,1.29,3,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,12,0,"l.",null,null,6.35,12,0,0,0,null,0,0]
[null,"19.",null,null,null,0,null,null,0,12,0,"l.",null,null,6.35,12,0,0,0,null,0,0]
[null,"20.",null,null,null,0,null,null,0,14,0,"l.",null,null,5.83,14,0,0,0,null,0,0]
[null,"21.",null,null,null,0,null,null,0,12,0,"l.",null,null,5.78,12,0,0,0,null,0,0]
[null,"22.",null,null,null,0,null,null,0,14,0,"l.",null,null,7.1,14,0,0,0,null,0,0]
[null,"23.",null,null,null,0,null,null,0,14,0,"l.",null,null,5.74,14,0,0,0,null,0,0]
[null,"24.",null,null,null,0,null,null,0,12,0,"l.",null,null,6.17,12,0,0,0,null,0,0]
[null,"25.",null,null,null,0,null,null,0,12,0,"l.",null,null,4.92,12,0,0,0,null,0,0]
[null,"26.",null,null,null,0,null,null,0,14,0,"l.",null,null,4.38,14,0,0,0,null,0,0]
[null,"27.",null,null,null,0,null,null,0,20,0,"l.",null,null,10.8,20,0,0,0,null,0,0]
[null,"28.",null,null,null,0,null,null,0,20,0,"l.",null,null,9.69,20,0,0,0,null,0,0]
[null,"29.",null,null,null,0,null,null,0,14,0,"l.",null,null,7.15,14,0,0,0,null,0,0]
[null,"30.",null,null,null,0,null,null,0,24,0,"l.",null,null,16.91,24,0,0,0,null,0,0]
[null,"31.",null,null,null,0,null,null,0,20,0,"l.",null,null,5.9980000000000002,20,0,0,0,null,0,0]
[null,"32.",null,null,null,0,null,null,0,20,0,"l.",null,null,9.69,20,0,0,0,null,0,0]
[null,"33.",null,null,null,0,null,null,0,12,0,"l.",null,null,5.08,12,0,0,0,null,0,0]
[null,"34.",null,null,null,0,null,null,0,18,0,"l.",null,null,4.9000000000000004,18,0,0,0,null,0,0]
[null,"35.",null,null,null,0,null,null,0,24,0,"l.",null,null,11.45,24,0,0,0,null,0,0]
[null,"36.",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(D16:D51)","v":0},null,null,{"$f":"SUM(G16:G51)","v":0},null,null,"Celkom:",{"$f":"SUM(K16:K51)","v":0},null,null,null,null,"Celkom:",{"$f":"SUM(Q16:Q51)","v":0},{"$f":"SUM(R16:R51)","v":0},{"$f":"SUM(S16:S51)","v":0},null,"Za tovar:",{"$f":"SUM(V16:V51)","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,"37.",null,null,null,{"$f":"D61+E61","v":0},null,null,{"$f":"D61+E61-G61","v":0},1.1000000000000001,{"$f":"I61*J61","v":0},"ks.",null,null,0.78,{"$f":"J61","v":1.1000000000000001},{"$f":"I61*J61","v":0},{"$f":"(P61-O61)*I61","v":0},{"$f":"R61*0.8","v":0},null,{"$f":"G61","v":0},{"$f":"U61*O61","v":0}]
[null,"38.",null,null,null,{"$f":"D62+E62","v":0},null,null,{"$f":"D62+E62-G62","v":0},2,{"$f":"I62*J62","v":0},"ks.",null,null,0.72599999999999998,{"$f":"J62","v":2},{"$f":"I62*J62","v":0},{"$f":"(P62-O62)*I62","v":0},{"$f":"R62*0.8","v":0},null,{"$f":"G62","v":0},{"$f":"U62*O62","v":0}]
[null,"39.",null,null,null,0,null,null,0,0.9,0,"ks.",null,null,0.52800000000000002,0.9,0,{"$f":"(P63-O63)*I63","v":0},0,null,0,0]
[null,"40.",null,null,null,0,null,null,0,1.1000000000000001,0,"ks.",null,null,0.49,1.1000000000000001,0,0,0,null,0,0]
[null,"41.",null,null,null,0,null,null,0,0.5,0,"ks.",null,null,0.2,0.5,0,0,0,null,0,0]
[null,"42.",null,null,null,0,null,null,0,1.8,0,"ks.",null,null,0.25,1.8,0,0,0,null,0,0]
[null,"43.",null,null,null,0,null,null,0,0.5,0,"ks.",null,null,0.11,0.5,0,0,0,null,0,0]
[null,"44.",null,0,null,0,0,null,0,1.5,0,"l.",null,null,0.23,1.5,0,0,0,null,0,0]
[null,"45.",null,null,null,0,null,null,0,1,0,"ks.",null,null,0.46,1,0,0,0,null,0,0]
[null,"46.",null,null,null,0,null,null,0,3,0,"ks.",null,null,1.1879999999999999,3,0,0,0,null,0,0]
[null,"47.",null,null,null,0,null,null,0,1.1000000000000001,0,"l.",null,null,0.33,1.1000000000000001,0,0,0,null,0,0]
[null,"48.",null,null,null,0,null,null,0,0.8,0,"ks.",null,null,0.32,0.8,0,0,0,null,0,0]
[null,"49.",null,null,null,0,null,null,0,1.1000000000000001,0,"ks.",null,null,0.624,1.1000000000000001,0,0,0,null,0,0]
[null,"50.",null,null,null,0,null,null,0,1.1000000000000001,0,"ks.",null,null,0.504,1.1000000000000001,0,0,0,null,0,0]
[null,"51.",null,null,null,0,null,null,0,1.2,0,"ks.",null,null,0.64,1.2,0,0,0,null,0,0]
[null,"52.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"53.",null,null,null,0,null,null,{"$f":"(D77+E77-G77)/7","v":0},0.5,0,"gr.",null,null,3.4000000000000002E-2,0.5,{"$f":"K77","v":0},0,0,null,0,0]
[null,"54.",null,null,null,0,null,null,0,0.5,0,"ks.",null,null,0.14000000000000001,0.5,0,0,0,null,0,0]
[null,"55.",null,null,null,0,null,null,0,0.5,{"$f":"I79*J79","v":0},"ks.",null,null,5.8000000000000003E-2,0.5,{"$f":"I79*J79","v":0},0,0,null,0,{"$f":"U79*O80","v":0}]
[null,"56.",null,null,null,0,null,null,0,0.1,{"$f":"I80*J80","v":0},"ks.",null,null,3.5999999999999997E-2,0.1,{"$f":"I80*J80","v":0},0,0,null,0,{"$f":"U80*O81","v":0}]
[null,"57.",null,null,null,0,null,null,0,0.05,{"$f":"I81*J81","v":0},"ks.",null,null,0.08,0.05,{"$f":"I81*J81","v":0},0,0,null,0,{"$f":"U81*O82","v":0}]
[null,"58.",null,null,null,0,null,null,0,null,{"$f":"I82*J82","v":0},null,null,null,null,0,{"$f":"I82*J82","v":0},0,0,null,0,{"$f":"U82*O83","v":0}]
[null,"59.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,{"$f":"(P83-O83)*I83","v":0},0,null,0,0]
[null,"60.",null,null,null,0,null,null,0,3.2,0,"ks.",null,null,3.04,3.2,0,0,0,null,0,0]
[null,"61.",null,null,null,0,null,null,0,3.3,0,"ks.",null,null,3.3,3.3,0,0,0,null,0,0]
[null,"62.",null,null,null,0,null,null,0,3.4,0,"ks.",null,null,3.32,3.4,0,0,0,null,0,0]
[null,"63.",null,null,null,0,null,null,0,3.6,0,"ks.",null,null,2.95,3.6,0,0,0,null,0,0]
[null,"64.",null,null,null,0,null,null,0,3.3,0,"ks.",null,null,3.04,3.3,0,0,0,null,0,0]
[null,"65.",null,null,null,0,null,null,0,3.2,0,"ks.",null,null,3.04,3.2,0,0,0,null,0,0]
[null,"66.",null,null,null,0,null,null,0,3.1,0,"ks.",null,null,2.94,3.1,0,0,0,null,0,0]
[null,"67.",null,null,null,0,null,null,0,3.2,0,"ks.",null,null,3.04,3.2,0,0,0,null,0,0]
[null,"68.",null,null,null,0,null,null,0,3.1,0,"ks.",null,null,null,3.1,0,0,0,null,0,0]
[null,"69.",null,null,null,0,null,null,0,3.3,0,"ks.",null,null,null,3.3,0,0,0,null,0,0]
[null,"70.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"71.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"72.",null,null,null,0,null,null,0,0.2,0,"ks.",null,null,8.8999999999999996E-2,0.2,0,0,0,null,0,0]
[null,"73.",null,null,null,0,null,null,0,0.5,0,"ks.",null,null,0.17,0.5,0,0,0,null,0,0]
[null,"74.",null,null,null,0,null,null,0,0.1,0,"ks.",null,null,0.04,0.1,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.",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(D61:D101)","v":0},null,null,{"$f":"SUM(G61:G101)","v":0},null,null,"Celkom :",{"$f":"SUM(K61:K101)","v":0},null,null,null,null,"Celkom:",{"$f":"SUM(Q61:Q101)","v":0},{"$f":"SUM(R61:R101)","v":0},{"$f":"SUM(S61:S101)","v":0},null,"Za tovar:",{"$f":"SUM(V61:V101)","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,"78.",null,null,null,{"$f":"D110+E110","v":0},null,null,{"$f":"D110+E110-G110","v":0},1.2,{"$f":"I110*J110","v":0},"ks.",null,null,0.73,{"$f":"J110","v":1.2},{"$f":"I110*J110","v":0},{"$f":"(P110-O110)*I110","v":0},{"$f":"R110*0.8","v":0},null,{"$f":"G110","v":0},{"$f":"U110*O110","v":0}]
[null,"79.",null,null,null,{"$f":"D111+E111","v":0},null,null,{"$f":"D111+E111-G111","v":0},0.6,{"$f":"I111*J111","v":0},"ks.",null,null,0.28999999999999998,{"$f":"J111","v":0.6},{"$f":"I111*J111","v":0},{"$f":"(P111-O111)*I111","v":0},{"$f":"R111*0.8","v":0},null,{"$f":"G111","v":0},{"$f":"U111*O111","v":0}]
[null,"80.",null,null,null,0,null,null,0,0.6,0,"ks.",null,null,0.28000000000000003,0.6,0,{"$f":"(P112-O112)*I112","v":0},0,null,0,0]
[null,"81.",null,null,null,0,null,null,0,1.5,0,"ks.",null,null,0.9,1.5,0,0,0,null,0,0]
[null,"82.",null,null,null,0,null,null,0,0.6,0,"ks.",null,null,0.32,0.6,0,0,0,null,0,0]
[null,"83.",null,null,null,0,null,null,0,0.6,0,"ks.",null,null,0.26,0.6,0,0,0,null,0,0]
[null,"84.",null,null,null,0,null,null,0,0.6,0,"ks.",null,null,0.4,0.6,0,0,0,null,0,0]
[null,"85.",null,null,null,0,null,null,0,null,0,"ks.",null,null,null,0,0,0,0,null,0,0]
[null,"86.",null,null,null,0,null,null,0,0.6,0,"ks.",null,null,0.33,0.6,0,0,0,null,0,0]
[null,"87.",null,null,null,0,null,null,0,0.3,0,"ks.",null,null,0.1,0.3,0,0,0,null,0,0]
[null,"88.",null,null,null,0,null,null,0,0.8,0,"ks.",null,null,0.5,0.8,0,0,0,null,0,0]
[null,"89.",null,null,null,0,null,null,0,2.6,0,"ks.",null,null,1.62,2.6,0,0,0,null,0,0]
[null,"90.",null,null,null,0,null,null,0,1.5,0,"ks.",null,null,0.73,1.5,0,0,0,null,0,0]
[null,"91.",null,null,null,0,null,null,0,0.5,0,"ks.",null,null,0.24,0.5,0,0,0,null,0,0]
[null,"92.",null,null,null,0,null,null,0,0.8,0,"ks.",null,null,0.33,0.8,0,0,0,null,0,0]
[null,"93.",null,null,null,0,null,null,0,0.6,0,"ks.",null,null,0.3,0.6,0,0,0,null,0,0]
[null,"94.",null,null,null,0,null,null,0,0.1,0,"ks.",null,null,5.1999999999999998E-2,0.1,0,0,0,null,0,0]
[null,"95.",null,null,null,0,null,null,0,0.6,0,"ks.",null,null,0.37,0.6,0,0,0,null,0,0]
[null,"96.",null,null,null,0,null,null,0,0.9,0,"ks.",null,null,0.54,0.9,0,0,0,null,0,0]
[null,"97.",null,null,null,0,null,null,0,0.7,0,"ks.",null,null,0.3,0.7,0,0,0,null,0,0]
[null,"98.",null,null,null,0,null,null,0,0.5,0,"ks.",null,null,0.27,0.5,0,0,0,null,0,0]
[null,"99.",null,null,null,0,null,null,0,0.6,0,"ks.",null,null,0.32,0.6,0,0,0,null,0,0]
[null,"100.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"101.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"102.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"103.",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(D110:D135)","v":0},null,null,{"$f":"SUM(G110:G135)","v":0},null,null,"Celkom:",{"$f":"SUM(K110:K135)","v":0},null,null,null,null,"Celkom:",{"$f":"SUM(Q110:Q135)","v":0},{"$f":"SUM(R110:R135)","v":0},{"$f":"SUM(S110:S135)","v":0},null,"Za tovar:",{"$f":"SUM(V110:V135)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tržba","Zisk","Zisk po zdanený"]
[]
[null,null,null,"Stávková:",null,null,null,null,"Strana 1:",{"$f":"K53","v":0},null,null,null,null,null,"Strana 1",{"$f":"Q53","v":0},{"$f":"R53","v":0},{"$f":"S53","v":0},null,"Strana 1:",{"$f":"V53","v":0}]
[null,null,null,"Refil:",null,null,null,null,"Strana 2:",{"$f":"K103","v":0},null,null,null,null,null,"Strana 2",{"$f":"Q103","v":0},{"$f":"R103","v":0},{"$f":"S103","v":0},null,"Strana 2:",{"$f":"V103","v":0}]
[null,null,null,"Výdavky:",null,null,null,null,"Strana 3:",{"$f":"K137","v":0},null,null,null,null,null,"Strana 3",{"$f":"Q137","v":0},{"$f":"R137","v":0},{"$f":"S137","v":0},null,"Strana 3:",{"$f":"V137","v":0}]
[]
[null,null,null,null,"Spolu:",{"$f":"SUM(F141:F143)","v":0},null,null,"Spolu:",{"$f":"SUM(J141:J143)","v":0},null,null,null,null,null,"Spolu:",{"$f":"SUM(Q141:Q143)","v":0},{"$f":"SUM(R141:R143)","v":0},{"$f":"SUM(S141:S143)","v":0},null,"Spolu:",{"$f":"SUM(V141:V143)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spolu:",{"$f":"Q145-F145","v":0}]
[null,null,null,null,null,null,null,null,"Spolu :",{"$f":"J145-F145","v":0}]
[]
[null,null,"Zostatok hotovosť:"]
[]
[null,null,"rozdiel:",{"$f":"D150-J148","v":0}]

{"sheet":"Inventár","index":1,"n_rows":153,"n_cols":4,"rows_kept":153,"cut":false,"hidden":false,"merged":[[3,0,4,0],[0,0,0,3],[153,2,153,3],[3,1,4,1],[3,2,4,2],[3,3,4,3]]}
["Inventár Jún 2018"]
[]
[]
["Názov  tovaru","Zostatok v sklade","J.M","Suma tovaru"]
[]
["aaa",8,"l.",8.2560000000000002]
["sss",10,"l.",4.93]
["dddd",4,"l.",6.08]
[null,null,null,0]
["ref",17,"ks.",6.97]
["erfer",35,"ks.",16.45]
["erferf",450,"ks.",288]
["erferf",39,"ks.",19.11]
["ergfer",17,"ks.",15.81]
["rgerg",48,"ks.",36.96]
["hzh",1,"ks.",0.49]
["zthtz",null,"ks.",0]
[null,null,"ks.",0]
[null,null,null,0]
[null,null,"l.",0]
[null,null,"l.",0]
[null,null,null,0]
[null,null,"l.",0]
[null,null,"l.",0]
[null,null,"l.",0]
[null,null,"l.",0]
[null,null,"l.",0]
[null,null,"l.",0]
[null,null,"l.",0]
[null,null,"l.",0]
[null,null,"l.",0]
[null,null,"l.",0]
[null,null,"l.",0]
[null,null,"l.",0]
[null,null,"l.",0]
[null,null,"l.",0]
[null,null,"l.",0]
[null,null,"l.",0]
[null,null,"l.",0]
[null,null,"l.",0]
[null,null,null,0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,0,"l.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"l.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,null,0]
[null,null,"gr.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,null,0]
[null,null,null,0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,null,0]
[null,null,null,0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,"ks.",0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Celkom:",{"$f":"SUBTOTAL(9,D6:D150)","v":403.05599999999998}]

{"sheet":"Sumár","index":2,"n_rows":148,"n_cols":19,"rows_kept":148,"cut":false,"hidden":false,"merged":[[1,15,1,16],[0,14,0,17],[141,3,141,4],[140,3,140,4],[13,6,14,6],[13,8,14,8],[13,9,14,9],[13,10,14,10],[13,11,14,11],[13,14,14,14],[13,15,14,15],[13,16,14,16],[13,17,14,17],[107,6,108,6],[13,2,14,2],[13,3,14,3],[13,4,14,4],[13,5,14,5],[0,2,0,9],[1,8,1,9],[13,18,14,18],[58,1,59,1],[58,2,59,2],[58,3,59,3],[58,4,59,4],[58,5,59,5],[58,6,59,6],[58,8,59,8],[58,9,59,9],[58,10,59,10],[58,14,59,14],[58,15,59,15],[58,16,59,16],[58,17,59,17],[58,18,59,18],[13,1,14,1],[107,1,108,1],[107,2,108,2],[107,3,108,3],[107,4,108,4],[107,5,108,5],[138,18,139,18],[142,3,142,4],[107,18,108,18],[107,16,108,16],[107,17,108,17],[138,14,139,14],[138,15,139,15],[138,16,139,16],[138,17,139,17],[107,8,108,8],[107,9,108,9],[107,10,108,10],[107,14,108,14],[107,15,108,15]]}
[10,null,"Vyučtovanie výčapu 2017",null,null,null,null,null,null,null,null,null,null,null,"Mesačný sumár"]
[null,null,null,null,null,null,"Meno:",null,null,null,null,null,null,null,null,{"$f":"I2","v":0}]
[null,null,null,null,null,null,"Dátum:",null,null,null,null,null,null,null,null,{"$f":"I3","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Strana 1:",null,null,null,null,null,null,null,null,null,null,null,"Strana 1:"]
[null,"P.Č.","Názov  tovaru","Poč. stav","Mesačný príjem","J.M.","Zostatok v sklade",null,"Mesačný predaj","Cena €","Suma celkom €","J.M.",null,null,"Nákupná cena","Predajná cena","Tržba","Zisk","Zisk po zdanení"]
[]
[null,"1.",{"$f":"Originál!C16","v":"aaa"},null,300,{"$f":"Originál!L16","v":"l."},null,0,291.39999999999998,{"$f":"Originál!J16","v":2},{"$f":"I16*J16","v":582.79999999999995},{"$f":"Originál!L16","v":"l."},null,null,{"$f":"Originál!O16","v":1.032},{"$f":"J16","v":2},{"$f":"I16*J16","v":582.79999999999995},{"$f":"(P16-O16)*I16","v":282.0752},{"$f":"R16*0.8","v":225.66016000000002}]
[null,"2.",{"$f":"Originál!C17","v":"sss"},null,140,{"$f":"Originál!L17","v":"l."},null,0,180.39999999999998,{"$f":"Originál!J17","v":2},{"$f":"I17*J17","v":360.79999999999995},{"$f":"Originál!L17","v":"l."},null,null,{"$f":"Originál!O17","v":0.49299999999999999},{"$f":"J17","v":2},{"$f":"I17*J17","v":360.79999999999995},{"$f":"(P17-O17)*I17","v":271.86279999999999},{"$f":"R17*0.8","v":217.49024}]
[null,"3.",{"$f":"Originál!C18","v":"dddd"},null,30,{"$f":"Originál!L18","v":"l."},null,0,21.4,{"$f":"Originál!J18","v":2.8},59.919999999999995,{"$f":"Originál!L18","v":"l."},null,null,{"$f":"Originál!O18","v":1.52},2.8,59.919999999999995,{"$f":"(P18-O18)*I18","v":27.391999999999992},21.913599999999995]
[null,"4.",{"$f":"Originál!C19","v":0},null,0,{"$f":"Originál!L19","v":0},null,0,0,{"$f":"Originál!J19","v":0},0,{"$f":"Originál!L19","v":0},null,null,{"$f":"Originál!O19","v":0},0,0,0,0]
[null,"5.",{"$f":"Originál!C20","v":"ref"},null,20,{"$f":"Originál!L20","v":"ks."},null,0,11,{"$f":"Originál!J20","v":0.8},8.8000000000000007,{"$f":"Originál!L20","v":"ks."},null,null,{"$f":"Originál!O20","v":0.41},0.8,8.8000000000000007,4.2900000000000009,3.4320000000000008]
[null,"6.",{"$f":"Originál!C21","v":"erfer"},null,20,{"$f":"Originál!L21","v":"ks."},null,0,33,{"$f":"Originál!J21","v":0.9},29.7,{"$f":"Originál!L21","v":"ks."},null,null,{"$f":"Originál!O21","v":0.47},0.9,29.7,14.190000000000001,11.352000000000002]
[null,"7.",{"$f":"Originál!C22","v":"erferf"},null,40,{"$f":"Originál!L22","v":"ks."},null,0,29,{"$f":"Originál!J22","v":1.2},34.799999999999997,{"$f":"Originál!L22","v":"ks."},null,null,{"$f":"Originál!O22","v":0.64},1.2,34.799999999999997,16.239999999999998,12.991999999999999]
[null,"8.",{"$f":"Originál!C23","v":"erferf"},null,40,{"$f":"Originál!L23","v":"ks."},null,0,38,{"$f":"Originál!J23","v":0.9},34.200000000000003,{"$f":"Originál!L23","v":"ks."},null,null,{"$f":"Originál!O23","v":0.49},0.9,34.200000000000003,15.580000000000002,12.464000000000002]
[null,"9.",{"$f":"Originál!C24","v":"ergfer"},null,20,{"$f":"Originál!L24","v":"ks."},null,0,23,{"$f":"Originál!J24","v":1.3},29.900000000000002,{"$f":"Originál!L24","v":"ks."},null,null,{"$f":"Originál!O24","v":0.93},1.3,29.900000000000002,8.51,6.8079999999999998]
[null,"10.",{"$f":"Originál!C25","v":"rgerg"},null,0,{"$f":"Originál!L25","v":"ks."},null,0,0,{"$f":"Originál!J25","v":1},0,{"$f":"Originál!L25","v":"ks."},null,null,{"$f":"Originál!O25","v":0.77},1,0,0,0]
[null,"11.",{"$f":"Originál!C26","v":"hzh"},null,0,{"$f":"Originál!L26","v":"ks."},null,0,-3,{"$f":"Originál!J26","v":0.9},-2.7,{"$f":"Originál!L26","v":"ks."},null,null,{"$f":"Originál!O26","v":0.49},0.9,-2.7,-1.23,-0.98399999999999999]
[null,"12.",{"$f":"Originál!C27","v":"zthtz"},null,0,{"$f":"Originál!L27","v":"ks."},null,0,0,{"$f":"Originál!J27","v":1},0,{"$f":"Originál!L27","v":"ks."},null,null,{"$f":"Originál!O27","v":0.42},1,0,0,0]
[null,"13.",{"$f":"Originál!C28","v":0},null,0,{"$f":"Originál!L28","v":"ks."},null,0,0,{"$f":"Originál!J28","v":1.2},0,{"$f":"Originál!L28","v":"ks."},null,null,{"$f":"Originál!O28","v":0.75},1.2,0,0,0]
[null,"14.",{"$f":"Originál!C29","v":0},null,0,{"$f":"Originál!L29","v":0},null,0,0,{"$f":"Originál!J29","v":0},0,{"$f":"Originál!L29","v":0},null,null,{"$f":"Originál!O29","v":0},0,0,0,0]
[null,"15.",{"$f":"Originál!C30","v":0},null,72,{"$f":"Originál!L30","v":"l."},null,0,40.200000000000003,{"$f":"Originál!J30","v":3},120.60000000000001,{"$f":"Originál!L30","v":"l."},null,null,{"$f":"Originál!O30","v":1.29},3,120.60000000000001,68.742000000000004,54.993600000000008]
[null,"16.",{"$f":"Originál!C31","v":0},null,0,{"$f":"Originál!L31","v":"l."},null,0,-5.8000000000000007,{"$f":"Originál!J31","v":3},-17.400000000000002,{"$f":"Originál!L31","v":"l."},null,null,{"$f":"Originál!O31","v":1.29},3,-17.400000000000002,-9.918000000000001,-7.934400000000001]
[null,"17.",{"$f":"Originál!C32","v":0},null,0,{"$f":"Originál!L32","v":0},null,0,0,{"$f":"Originál!J32","v":0},0,{"$f":"Originál!L32","v":0},null,null,{"$f":"Originál!O32","v":0},0,0,0,0]
[null,"18.",{"$f":"Originál!C33","v":0},null,24,{"$f":"Originál!L33","v":"l."},null,0,15.900000000000007,{"$f":"Originál!J33","v":12},190.8000000000001,{"$f":"Originál!L33","v":"l."},null,null,{"$f":"Originál!O33","v":6.35},12,190.8000000000001,89.835000000000051,71.868000000000038]
[null,"19.",{"$f":"Originál!C34","v":0},null,36,{"$f":"Originál!L34","v":"l."},null,0,21.450000000000003,{"$f":"Originál!J34","v":12},257.40000000000003,{"$f":"Originál!L34","v":"l."},null,null,{"$f":"Originál!O34","v":6.35},12,257.40000000000003,121.19250000000002,96.954000000000022]
[null,"20.",{"$f":"Originál!C35","v":0},null,8.4,{"$f":"Originál!L35","v":"l."},null,0,6.65,{"$f":"Originál!J35","v":14},93.100000000000009,{"$f":"Originál!L35","v":"l."},null,null,{"$f":"Originál!O35","v":5.83},14,93.100000000000009,54.330500000000001,43.464400000000005]
[null,"21.",{"$f":"Originál!C36","v":0},null,6,{"$f":"Originál!L36","v":"l."},null,0,11.25,{"$f":"Originál!J36","v":12},135,{"$f":"Originál!L36","v":"l."},null,null,{"$f":"Originál!O36","v":5.78},12,135,69.974999999999994,55.98]
[null,"22.",{"$f":"Originál!C37","v":0},null,3,{"$f":"Originál!L37","v":"l."},null,0,2.7,{"$f":"Originál!J37","v":14},37.800000000000004,{"$f":"Originál!L37","v":"l."},null,null,{"$f":"Originál!O37","v":7.1},14,37.800000000000004,18.630000000000003,14.904000000000003]
[null,"23.",{"$f":"Originál!C38","v":0},null,0,{"$f":"Originál!L38","v":"l."},null,0,0.55000000000000027,{"$f":"Originál!J38","v":14},7.7000000000000037,{"$f":"Originál!L38","v":"l."},null,null,{"$f":"Originál!O38","v":5.74},14,7.7000000000000037,4.5430000000000019,3.6344000000000016]
[null,"24.",{"$f":"Originál!C39","v":0},null,6,{"$f":"Originál!L39","v":"l."},null,0,6.8499999999999979,{"$f":"Originál!J39","v":12},82.199999999999974,{"$f":"Originál!L39","v":"l."},null,null,{"$f":"Originál!O39","v":6.17},12,82.199999999999974,39.93549999999999,31.948399999999992]
[null,"25.",{"$f":"Originál!C40","v":0},null,12,{"$f":"Originál!L40","v":"l."},null,0,17.2,{"$f":"Originál!J40","v":12},206.39999999999998,{"$f":"Originál!L40","v":"l."},null,null,{"$f":"Originál!O40","v":4.92},12,206.39999999999998,121.776,97.4208]
[null,"26.",{"$f":"Originál!C41","v":0},null,0,{"$f":"Originál!L41","v":"l."},null,0,1.2999999999999998,{"$f":"Originál!J41","v":14},18.199999999999996,{"$f":"Originál!L41","v":"l."},null,null,{"$f":"Originál!O41","v":4.38},14,18.199999999999996,12.506,10.004800000000001]
[null,"27.",{"$f":"Originál!C42","v":0},null,0,{"$f":"Originál!L42","v":"l."},null,0,4.05,{"$f":"Originál!J42","v":20},81,{"$f":"Originál!L42","v":"l."},null,null,{"$f":"Originál!O42","v":10.8},20,81,37.26,29.808]
[null,"28.",{"$f":"Originál!C43","v":0},null,6,{"$f":"Originál!L43","v":"l."},null,0,5.8000000000000007,{"$f":"Originál!J43","v":20},116.00000000000001,{"$f":"Originál!L43","v":"l."},null,null,{"$f":"Originál!O43","v":9.69},20,116.00000000000001,59.798000000000009,47.838400000000007]
[null,"29.",{"$f":"Originál!C44","v":0},null,3,{"$f":"Originál!L44","v":"l."},null,0,2.9499999999999997,{"$f":"Originál!J44","v":14},41.3,{"$f":"Originál!L44","v":"l."},null,null,{"$f":"Originál!O44","v":7.15},14,41.3,20.207499999999996,16.165999999999997]
[null,"30.",{"$f":"Originál!C45","v":0},null,0,{"$f":"Originál!L45","v":"l."},null,0,3.25,{"$f":"Originál!J45","v":24},78,{"$f":"Originál!L45","v":"l."},null,null,{"$f":"Originál!O45","v":16.91},24,78,23.0425,18.434000000000001]
[null,"31.",{"$f":"Originál!C46","v":0},null,0,{"$f":"Originál!L46","v":"l."},null,0,0,{"$f":"Originál!J46","v":20},0,{"$f":"Originál!L46","v":"l."},null,null,{"$f":"Originál!O46","v":5.9980000000000002},20,0,0,0]
[null,"32.",{"$f":"Originál!C47","v":0},null,0,{"$f":"Originál!L47","v":"l."},null,0,0,{"$f":"Originál!J47","v":20},0,{"$f":"Originál!L47","v":"l."},null,null,{"$f":"Originál!O47","v":9.69},20,0,0,0]
[null,"33.",{"$f":"Originál!C48","v":0},null,0,{"$f":"Originál!L48","v":"l."},0,0,0.54999999999999982,{"$f":"Originál!J48","v":12},6.5999999999999979,{"$f":"Originál!L48","v":"l."},null,null,{"$f":"Originál!O48","v":5.08},12,6.5999999999999979,3.8059999999999987,3.0447999999999991]
[null,"34.",{"$f":"Originál!C49","v":0},null,3,{"$f":"Originál!L49","v":"l."},0,0,0.95000000000000007,{"$f":"Originál!J49","v":18},17.100000000000001,{"$f":"Originál!L49","v":"l."},null,null,{"$f":"Originál!O49","v":4.9000000000000004},18,17.100000000000001,12.445,9.9560000000000013]
[null,"35.",{"$f":"Originál!C50","v":0},null,3,{"$f":"Originál!L50","v":"l."},0,0,1.8499999999999996,{"$f":"Originál!J50","v":24},44.399999999999991,{"$f":"Originál!L50","v":"l."},null,null,{"$f":"Originál!O50","v":11.45},24,44.399999999999991,23.217499999999998,18.573999999999998]
[null,"36.",{"$f":"Originál!C51","v":0},null,0,{"$f":"Originál!L51","v":0},0,0,0,null,0,{"$f":"Originál!L51","v":0},null,null,{"$f":"Originál!O51","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"SUM(D16:D51)","v":0},null,null,{"$f":"SUM(G16:G51)","v":0},null,null,"Celkom:",{"$f":"SUM(K16:K51)","v":2654.4199999999996},null,null,null,null,"Celkom:",{"$f":"SUM(Q16:Q51)","v":2654.4199999999996},{"$f":"SUM(R16:R51)","v":1410.2340000000002},{"$f":"SUM(S16:S51)","v":1128.1871999999998}]
[]
[]
[]
[]
[null,null,"Strana 2:",null,null,null,null,null,null,null,null,null,null,null,"Strana 2:"]
[null,"P.Č.","Názov  tovaru","Poč. stav","Mesačný príjem","Spolu","Zostatok v sklade",null,"Mesačný predaj","Cena €","Suma celkom €",null,null,null,"Nákupná cena","Predajná cena","Tržba","Zisk","Zisk po zdanení"]
[]
[null,"37.",{"$f":"Originál!C61","v":0},null,0,{"$f":"D61+E61","v":0},null,0,18,{"$f":"Originál!J61","v":1.1000000000000001},{"$f":"I61*J61","v":19.8},{"$f":"Originál!L61","v":"ks."},null,null,{"$f":"Originál!O61","v":0.78},{"$f":"J61","v":1.1000000000000001},{"$f":"I61*J61","v":19.8},{"$f":"(P61-O61)*I61","v":5.7600000000000016},{"$f":"R61*0.8","v":4.6080000000000014}]
[null,"38.",{"$f":"Originál!C62","v":0},null,0,{"$f":"D62+E62","v":0},null,0,-4.1000000000000014,{"$f":"Originál!J62","v":2},{"$f":"I62*J62","v":-8.2000000000000028},{"$f":"Originál!L62","v":"ks."},null,null,{"$f":"Originál!O62","v":0.72599999999999998},{"$f":"J62","v":2},{"$f":"I62*J62","v":-8.2000000000000028},{"$f":"(P62-O62)*I62","v":-5.2234000000000016},{"$f":"R62*0.8","v":-4.1787200000000011}]
[null,"39.",{"$f":"Originál!C63","v":0},null,60,60,null,0,23,{"$f":"Originál!J63","v":0.9},20.7,{"$f":"Originál!L63","v":"ks."},null,null,{"$f":"Originál!O63","v":0.52800000000000002},0.9,20.7,{"$f":"(P63-O63)*I63","v":8.5559999999999992},6.8447999999999993]
[null,"40.",{"$f":"Originál!C64","v":0},null,0,0,null,0,0,{"$f":"Originál!J64","v":1.1000000000000001},0,{"$f":"Originál!L64","v":"ks."},null,null,{"$f":"Originál!O64","v":0.49},1.1000000000000001,0,0,0]
[null,"41.",{"$f":"Originál!C65","v":0},null,54,54,null,0,50,{"$f":"Originál!J65","v":0.5},25,{"$f":"Originál!L65","v":"ks."},null,null,{"$f":"Originál!O65","v":0.2},0.5,25,15,12]
[null,"42.",{"$f":"Originál!C66","v":0},null,0,0,null,0,13,{"$f":"Originál!J66","v":1.8},23.400000000000002,{"$f":"Originál!L66","v":"ks."},null,null,{"$f":"Originál!O66","v":0.25},1.8,23.400000000000002,20.150000000000002,16.12]
[null,"43.",{"$f":"Originál!C67","v":0},null,40,40,null,0,21,{"$f":"Originál!J67","v":0.5},10.5,{"$f":"Originál!L67","v":"ks."},null,null,{"$f":"Originál!O67","v":0.11},0.5,10.5,8.19,6.5519999999999996]
[null,"44.",{"$f":"Originál!C68","v":0},null,0,0,null,0,19.600000000000001,{"$f":"Originál!J68","v":1.5},29.400000000000002,{"$f":"Originál!L68","v":"l."},null,null,{"$f":"Originál!O68","v":0.23},1.5,29.400000000000002,24.892000000000003,19.913600000000002]
[null,"45.",{"$f":"Originál!C69","v":0},null,0,0,null,0,-5,{"$f":"Originál!J69","v":1},-5,{"$f":"Originál!L69","v":"ks."},null,null,{"$f":"Originál!O69","v":0.46},1,-5,-2.7,-2.16]
[null,"46.",{"$f":"Originál!C70","v":0},null,12,12,null,0,8.3999999999999986,{"$f":"Originál!J70","v":3},25.199999999999996,{"$f":"Originál!L70","v":"ks."},null,null,{"$f":"Originál!O70","v":1.1879999999999999},3,25.199999999999996,15.220799999999999,12.176639999999999]
[null,"47.",{"$f":"Originál!C71","v":0},null,12,12,null,0,8,{"$f":"Originál!J71","v":1.1000000000000001},8.8000000000000007,{"$f":"Originál!L71","v":"l."},null,null,{"$f":"Originál!O71","v":0.33},1.1000000000000001,8.8000000000000007,6.16,4.9280000000000008]
[null,"48.",{"$f":"Originál!C72","v":0},null,0,0,null,0,16,{"$f":"Originál!J72","v":0.8},12.8,{"$f":"Originál!L72","v":"ks."},null,null,{"$f":"Originál!O72","v":0.32},0.8,12.8,7.6800000000000006,6.144000000000001]
[null,"49.",{"$f":"Originál!C73","v":0},null,0,0,null,0,0,{"$f":"Originál!J73","v":1.1000000000000001},0,{"$f":"Originál!L73","v":"ks."},null,null,{"$f":"Originál!O73","v":0.624},1.1000000000000001,0,0,0]
[null,"50.",{"$f":"Originál!C74","v":0},null,0,0,null,0,-8,{"$f":"Originál!J74","v":1.1000000000000001},-8.8000000000000007,{"$f":"Originál!L74","v":"ks."},null,null,{"$f":"Originál!O74","v":0.504},1.1000000000000001,-8.8000000000000007,-4.7680000000000007,-3.8144000000000009]
[null,"51.",{"$f":"Originál!C75","v":0},null,0,0,null,0,5,{"$f":"Originál!J75","v":1.2},6,{"$f":"Originál!L75","v":"ks."},null,null,{"$f":"Originál!O75","v":0.64},1.2,6,2.8,2.2399999999999998]
[null,"52.",{"$f":"Originál!C76","v":0},null,0,0,null,0,0,{"$f":"Originál!J76","v":0},0,{"$f":"Originál!L76","v":0},null,null,{"$f":"Originál!O76","v":0},0,0,0,0]
[null,"53.",{"$f":"Originál!C77","v":0},null,0,0,null,0,78.571428571428569,{"$f":"Originál!J77","v":0.5},39.285714285714285,{"$f":"Originál!L77","v":"gr."},null,null,{"$f":"Originál!O77","v":3.4000000000000002E-2},0.5,{"$f":"K77","v":39.285714285714285},36.614285714285714,29.291428571428572]
[null,"54.",{"$f":"Originál!C78","v":0},null,0,0,null,0,19,{"$f":"Originál!J78","v":0.5},9.5,{"$f":"Originál!L78","v":"ks."},null,null,{"$f":"Originál!O78","v":0.14000000000000001},0.5,9.5,{"$f":"(P78-O78)*I78","v":6.84},5.4720000000000004]
[null,"55.",{"$f":"Originál!C79","v":0},null,0,0,null,0,16,{"$f":"Originál!J79","v":0.5},8,{"$f":"Originál!L79","v":"ks."},null,null,{"$f":"Originál!O79","v":5.8000000000000003E-2},0.5,8,{"$f":"(P79-O79)*I79","v":7.0720000000000001},5.6576000000000004]
[null,"56.",{"$f":"Originál!C80","v":0},null,100,100,null,0,92,{"$f":"Originál!J80","v":0.1},9.2000000000000011,{"$f":"Originál!L80","v":"ks."},null,null,{"$f":"Originál!O80","v":3.5999999999999997E-2},0.1,9.2000000000000011,5.8879999999999999,4.7103999999999999]
[null,"57.",{"$f":"Originál!C81","v":0},null,0,0,null,0,428,{"$f":"Originál!J81","v":0.05},21.400000000000002,{"$f":"Originál!L81","v":"ks."},null,null,{"$f":"Originál!O81","v":0.08},0.05,21.400000000000002,-12.84,-10.272]
[null,"58.",{"$f":"Originál!C82","v":0},null,0,0,null,0,0,{"$f":"Originál!J82","v":0},0,{"$f":"Originál!L82","v":0},null,null,{"$f":"Originál!O82","v":0},0,0,0,0]
[null,"59.",{"$f":"Originál!C83","v":0},null,0,0,null,0,0,{"$f":"Originál!J83","v":0},0,{"$f":"Originál!L83","v":0},null,null,{"$f":"Originál!O83","v":0},0,0,0,0]
[null,"60.",{"$f":"Originál!C84","v":0},null,60,60,null,0,38,{"$f":"Originál!J84","v":3.2},121.60000000000001,{"$f":"Originál!L84","v":"ks."},null,null,{"$f":"Originál!O84","v":3.04},3.2,121.60000000000001,6.0800000000000054,4.8640000000000043]
[null,"61.",{"$f":"Originál!C85","v":0},null,20,20,null,0,18,{"$f":"Originál!J85","v":3.3},59.4,{"$f":"Originál!L85","v":"ks."},null,null,{"$f":"Originál!O85","v":3.3},3.3,59.4,0,0]
[null,"62.",{"$f":"Originál!C86","v":0},null,0,0,null,0,0,{"$f":"Originál!J86","v":3.4},0,{"$f":"Originál!L86","v":"ks."},null,null,{"$f":"Originál!O86","v":3.32},3.4,0,0,0]
[null,"63.",{"$f":"Originál!C87","v":0},null,20,20,null,0,14,{"$f":"Originál!J87","v":3.6},50.4,{"$f":"Originál!L87","v":"ks."},null,null,{"$f":"Originál!O87","v":2.95},3.6,50.4,9.0999999999999979,7.2799999999999985]
[null,"64.",{"$f":"Originál!C88","v":0},null,110,110,null,0,54,{"$f":"Originál!J88","v":3.3},178.2,{"$f":"Originál!L88","v":"ks."},null,null,{"$f":"Originál!O88","v":3.04},3.3,178.2,14.039999999999988,11.231999999999992]
[null,"65.",{"$f":"Originál!C89","v":0},null,20,20,null,0,10,{"$f":"Originál!J89","v":3.2},32,{"$f":"Originál!L89","v":"ks."},null,null,{"$f":"Originál!O89","v":3.04},3.2,32,1.6000000000000014,1.2800000000000011]
[null,"66.",{"$f":"Originál!C90","v":0},null,0,0,null,0,0,{"$f":"Originál!J90","v":3.1},0,{"$f":"Originál!L90","v":"ks."},null,null,{"$f":"Originál!O90","v":2.94},3.1,0,0,0]
[null,"67.",{"$f":"Originál!C91","v":0},null,0,0,null,0,0,{"$f":"Originál!J91","v":3.2},0,{"$f":"Originál!L91","v":"ks."},null,null,{"$f":"Originál!O91","v":3.04},3.2,0,0,0]
[null,"68.",{"$f":"Originál!C92","v":0},null,80,80,null,0,34,{"$f":"Originál!J92","v":3.1},105.4,{"$f":"Originál!L92","v":"ks."},null,null,{"$f":"Originál!O92","v":0},3.1,105.4,105.4,84.320000000000007]
[null,"69.",{"$f":"Originál!C93","v":0},null,0,0,null,0,0,{"$f":"Originál!J93","v":3.3},0,{"$f":"Originál!L93","v":"ks."},null,null,{"$f":"Originál!O93","v":0},3.3,0,0,0]
[null,"70.",{"$f":"Originál!C94","v":0},null,0,0,null,0,0,{"$f":"Originál!J94","v":0},0,{"$f":"Originál!L94","v":0},null,null,{"$f":"Originál!O94","v":0},0,0,0,0]
[null,"71.",{"$f":"Originál!C95","v":0},null,0,0,null,0,0,{"$f":"Originál!J95","v":0},0,{"$f":"Originál!L95","v":0},null,null,{"$f":"Originál!O95","v":0},0,0,0,0]
[null,"72.",{"$f":"Originál!C96","v":0},null,30,30,null,0,-24,{"$f":"Originál!J96","v":0.2},-4.8000000000000007,{"$f":"Originál!L96","v":"ks."},null,null,{"$f":"Originál!O96","v":8.8999999999999996E-2},0.2,-4.8000000000000007,-2.6640000000000006,-2.1312000000000006]
[null,"73.",{"$f":"Originál!C97","v":0},null,150,150,null,0,128,{"$f":"Originál!J97","v":0.5},64,{"$f":"Originál!L97","v":"ks."},null,null,{"$f":"Originál!O97","v":0.17},0.5,64,42.239999999999995,33.791999999999994]
[null,"74.",{"$f":"Originál!C98","v":0},null,100,100,0,0,16,{"$f":"Originál!J98","v":0.1},1.6,{"$f":"Originál!L98","v":"ks."},null,null,{"$f":"Originál!O98","v":0.04},0.1,1.6,0.96000000000000008,0.76800000000000013]
[null,"75.",{"$f":"Originál!C99","v":0},null,0,0,0,0,0,{"$f":"Originál!J99","v":0},0,{"$f":"Originál!L99","v":0},null,null,{"$f":"Originál!O99","v":0},0,0,0,0]
[null,"76.",{"$f":"Originál!C100","v":0},null,0,0,0,0,0,{"$f":"Originál!J100","v":0},0,{"$f":"Originál!L100","v":0},null,null,{"$f":"Originál!O100","v":0},0,0,0,0]
[null,"77.",{"$f":"Originál!C101","v":0},null,0,0,0,0,0,{"$f":"Originál!J101","v":0},0,{"$f":"Originál!L101","v":0},null,null,{"$f":"Originál!O101","v":0},0,0,0,0]
[]
[null,null,null,{"$f":"SUM(D61:D101)","v":0},null,null,{"$f":"SUM(G61:G101)","v":0},null,null,"Celkom :",{"$f":"SUM(K61:K101)","v":854.78571428571422},null,null,null,null,"Celkom:",{"$f":"SUM(Q61:Q101)","v":854.78571428571422},{"$f":"SUM(R61:R101)","v":322.04768571428571},{"$f":"SUM(S61:S101)","v":257.63814857142853}]
[]
[]
[]
[null,null,"Strana 3:",null,null,null,null,null,null,null,null,null,null,null,"Strana 3:"]
[null,"P.Č.","Názov  tovaru","Poč. stav","Mesačný príjem","Spolu","Zostatok v sklade",null,"Mesačný predaj","Cena €","Suma celkom €",null,null,null,"Nákupná cena","Predajná cena","Tržba","Zisk","Zisk po zdanení"]
[]
[null,"78.",{"$f":"Originál!C110","v":0},null,0,{"$f":"D110+E110","v":0},null,0,0,{"$f":"Originál!J110","v":1.2},{"$f":"I110*J110","v":0},{"$f":"Originál!L110","v":"ks."},null,null,{"$f":"Originál!O110","v":0.73},{"$f":"J110","v":1.2},{"$f":"I110*J110","v":0},{"$f":"(P110-O110)*I110","v":0},{"$f":"R110*0.8","v":0}]
[null,"79.",{"$f":"Originál!C111","v":0},null,40,{"$f":"D111+E111","v":40},null,0,16,{"$f":"Originál!J111","v":0.6},{"$f":"I111*J111","v":9.6},{"$f":"Originál!L111","v":"ks."},null,null,{"$f":"Originál!O111","v":0.28999999999999998},{"$f":"J111","v":0.6},{"$f":"I111*J111","v":9.6},{"$f":"(P111-O111)*I111","v":4.96},{"$f":"R111*0.8","v":3.968}]
[null,"80.",{"$f":"Originál!C112","v":0},null,20,20,null,0,18,{"$f":"Originál!J112","v":0.6},10.799999999999999,{"$f":"Originál!L112","v":"ks."},null,null,{"$f":"Originál!O112","v":0.28000000000000003},0.6,10.799999999999999,{"$f":"(P112-O112)*I112","v":5.7599999999999989},4.6079999999999997]
[null,"81.",{"$f":"Originál!C113","v":0},null,10,10,null,0,9,{"$f":"Originál!J113","v":1.5},13.5,{"$f":"Originál!L113","v":"ks."},null,null,{"$f":"Originál!O113","v":0.9},1.5,13.5,5.3999999999999995,4.3199999999999994]
[null,"82.",{"$f":"Originál!C114","v":0},null,10,10,null,0,4,{"$f":"Originál!J114","v":0.6},2.4,{"$f":"Originál!L114","v":"ks."},null,null,{"$f":"Originál!O114","v":0.32},0.6,2.4,1.1199999999999999,0.89599999999999991]
[null,"83.",{"$f":"Originál!C115","v":0},null,10,10,null,0,5,{"$f":"Originál!J115","v":0.6},3,{"$f":"Originál!L115","v":"ks."},null,null,{"$f":"Originál!O115","v":0.26},0.6,3,1.6999999999999997,1.3599999999999999]
[null,"84.",{"$f":"Originál!C116","v":0},null,0,0,null,0,3,{"$f":"Originál!J116","v":0.6},1.7999999999999998,{"$f":"Originál!L116","v":"ks."},null,null,{"$f":"Originál!O116","v":0.4},0.6,1.7999999999999998,0.59999999999999987,0.47999999999999993]
[null,"85.",{"$f":"Originál!C117","v":0},null,0,0,null,0,0,{"$f":"Originál!J117","v":0},0,{"$f":"Originál!L117","v":"ks."},null,null,{"$f":"Originál!O117","v":0},0,0,0,0]
[null,"86.",{"$f":"Originál!C118","v":0},null,40,40,null,0,21,{"$f":"Originál!J118","v":0.6},12.6,{"$f":"Originál!L118","v":"ks."},null,null,{"$f":"Originál!O118","v":0.33},0.6,12.6,5.669999999999999,4.5359999999999996]
[null,"87.",{"$f":"Originál!C119","v":0},null,0,0,null,0,4,{"$f":"Originál!J119","v":0.3},1.2,{"$f":"Originál!L119","v":"ks."},null,null,{"$f":"Originál!O119","v":0.1},0.3,1.2,0.79999999999999993,0.64]
[null,"88.",{"$f":"Originál!C120","v":0},null,24,24,null,0,43,{"$f":"Originál!J120","v":0.8},34.4,{"$f":"Originál!L120","v":"ks."},null,null,{"$f":"Originál!O120","v":0.5},0.8,34.4,12.900000000000002,10.320000000000002]
[null,"89.",{"$f":"Originál!C121","v":0},null,6,6,null,0,3,{"$f":"Originál!J121","v":2.6},7.8000000000000007,{"$f":"Originál!L121","v":"ks."},null,null,{"$f":"Originál!O121","v":1.62},2.6,7.8000000000000007,2.94,2.3519999999999999]
[null,"90.",{"$f":"Originál!C122","v":0},null,0,0,null,0,0,{"$f":"Originál!J122","v":1.5},0,{"$f":"Originál!L122","v":"ks."},null,null,{"$f":"Originál!O122","v":0.73},1.5,0,0,0]
[null,"91.",{"$f":"Originál!C123","v":0},null,0,0,null,0,15,{"$f":"Originál!J123","v":0.5},7.5,{"$f":"Originál!L123","v":"ks."},null,null,{"$f":"Originál!O123","v":0.24},0.5,7.5,3.9000000000000004,3.1200000000000006]
[null,"92.",{"$f":"Originál!C124","v":0},null,0,0,null,0,2,{"$f":"Originál!J124","v":0.8},1.6,{"$f":"Originál!L124","v":"ks."},null,null,{"$f":"Originál!O124","v":0.33},0.8,1.6,0.94000000000000006,0.75200000000000011]
[null,"93.",{"$f":"Originál!C125","v":0},null,24,24,null,0,16,{"$f":"Originál!J125","v":0.6},9.6,{"$f":"Originál!L125","v":"ks."},null,null,{"$f":"Originál!O125","v":0.3},0.6,9.6,4.8,3.84]
[null,"94.",{"$f":"Originál!C126","v":0},null,100,100,null,0,70,{"$f":"Originál!J126","v":0.1},7,{"$f":"Originál!L126","v":"ks."},null,null,{"$f":"Originál!O126","v":5.1999999999999998E-2},0.1,7,3.3600000000000008,2.6880000000000006]
[null,"95.",{"$f":"Originál!C127","v":0},null,60,60,null,0,47,{"$f":"Originál!J127","v":0.6},28.2,{"$f":"Originál!L127","v":"ks."},null,null,{"$f":"Originál!O127","v":0.37},0.6,28.2,10.809999999999999,8.6479999999999997]
[null,"96.",{"$f":"Originál!C128","v":0},null,0,0,null,0,3,{"$f":"Originál!J128","v":0.9},2.7,{"$f":"Originál!L128","v":"ks."},null,null,{"$f":"Originál!O128","v":0.54},0.9,2.7,1.08,0.8640000000000001]
[null,"97.",{"$f":"Originál!C129","v":0},null,0,0,null,0,-35,{"$f":"Originál!J129","v":0.7},-24.5,{"$f":"Originál!L129","v":"ks."},null,null,{"$f":"Originál!O129","v":0.3},0.7,-24.5,-13.999999999999998,-11.2]
[null,"98.",{"$f":"Originál!C130","v":0},null,0,0,null,0,8,{"$f":"Originál!J130","v":0.5},4,{"$f":"Originál!L130","v":"ks."},null,null,{"$f":"Originál!O130","v":0.27},0.5,4,1.8399999999999999,1.472]
[null,"99.",{"$f":"Originál!C131","v":0},null,0,0,null,0,0,{"$f":"Originál!J131","v":0.6},0,{"$f":"Originál!L131","v":"ks."},null,null,{"$f":"Originál!O131","v":0.32},0.6,0,0,0]
[null,"100.",{"$f":"Originál!C132","v":0},null,0,0,null,0,0,{"$f":"Originál!J132","v":0},0,{"$f":"Originál!L132","v":0},null,null,{"$f":"Originál!O132","v":0},0,0,0,0]
[null,"101.",{"$f":"Originál!C133","v":0},null,0,0,0,0,0,{"$f":"Originál!J133","v":0},0,{"$f":"Originál!L133","v":0},null,null,{"$f":"Originál!O133","v":0},0,0,0,0]
[null,"102.",{"$f":"Originál!C134","v":0},null,0,0,0,0,0,{"$f":"Originál!J134","v":0},0,{"$f":"Originál!L134","v":0},null,null,{"$f":"Originál!O134","v":0},0,0,0,0]
[null,"103.",{"$f":"Originál!C135","v":0},null,0,0,0,0,0,{"$f":"Originál!J135","v":0},0,{"$f":"Originál!L135","v":0},null,null,{"$f":"Originál!O135","v":0},0,0,0,0]
[]
[null,null,null,{"$f":"SUM(D110:D135)","v":0},null,null,{"$f":"SUM(G110:G135)","v":0},null,null,"Celkom:",{"$f":"SUM(K110:K135)","v":133.19999999999996},null,null,null,null,"Celkom:",{"$f":"SUM(Q110:Q135)","v":133.19999999999996},{"$f":"SUM(R110:R135)","v":54.579999999999984},{"$f":"SUM(S110:S135)","v":43.663999999999994}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tržba","Zisk","Zisk po zdanený"]
[]
[null,null,null,null,null,null,null,null,"Strana 1:",{"$f":"K53","v":2654.4199999999996},null,null,null,null,null,"Strana 1",{"$f":"Q53","v":2654.4199999999996},{"$f":"R53","v":1410.2340000000002},{"$f":"S53","v":1128.1871999999998}]
[null,null,null,null,null,null,null,null,"Strana 2:",{"$f":"K103","v":854.78571428571422},null,null,null,null,null,"Strana 2",{"$f":"Q103","v":854.78571428571422},{"$f":"R103","v":322.04768571428571},{"$f":"S103","v":257.63814857142853}]
[null,null,null,null,null,null,null,null,"Strana 3:",{"$f":"K137","v":133.19999999999996},null,null,null,null,null,"Strana 3",{"$f":"Q137","v":133.19999999999996},{"$f":"R137","v":54.579999999999984},{"$f":"S137","v":43.663999999999994}]
[]
[null,null,null,null,null,{"$f":"SUM(F141:F143)","v":0},null,null,"Spolu:",{"$f":"SUM(J141:J143)","v":3642.4057142857137},null,null,null,null,null,"Spolu:",{"$f":"SUM(Q141:Q143)","v":3642.4057142857137},{"$f":"SUM(R141:R143)","v":1786.8616857142858},{"$f":"SUM(S141:S143)","v":1429.4893485714283}]
[]
[]
[null,null,null,null,null,null,null,null,"Spolu :",{"$f":"J145-F145","v":3642.4057142857137}]

{"sheet":"Sklad","index":3,"n_rows":53,"n_cols":12,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,1,0,11],[52,1,52,11]]}
[null,"Evidencia skladu 2018"]
[]
[null,"Názov tovaru","Príjem","Sklad","Predajňa","Spolu",null,"Názov tovaru","Príjem","Sklad","Predajňa","Spolu"]
[null,{"$f":"Originál!C16","v":"aaa"},null,null,null,null,null,{"$f":"Originál!C77","v":0}]
[null,{"$f":"Originál!C17","v":"sss"},null,null,null,null,null,{"$f":"Originál!C78","v":0}]
[null,{"$f":"Originál!C18","v":"dddd"},null,null,null,null,null,{"$f":"Originál!C79","v":0}]
[null,{"$f":"Originál!C20","v":"ref"},null,null,null,null,null,{"$f":"Originál!C80","v":0}]
[null,{"$f":"Originál!C21","v":"erfer"},null,null,null,null,null,{"$f":"Originál!C81","v":0}]
[null,{"$f":"Originál!C22","v":"erferf"},null,null,null,null,null,{"$f":"Originál!C82","v":0}]
[null,{"$f":"Originál!C23","v":"erferf"},null,null,null,null,null,{"$f":"Originál!C83","v":0}]
[null,{"$f":"Originál!C24","v":"ergfer"},null,null,null,null,null,{"$f":"Originál!C84","v":0}]
[null,{"$f":"Originál!C25","v":"rgerg"},null,null,null,null,null,{"$f":"Originál!C85","v":0}]
[null,{"$f":"Originál!C26","v":"hzh"},null,null,null,null,null,{"$f":"Originál!C86","v":0}]
[null,{"$f":"Originál!C27","v":"zthtz"},null,null,null,null,null,{"$f":"Originál!C87","v":0}]
[null,{"$f":"Originál!C28","v":0},null,null,null,null,null,{"$f":"Originál!C88","v":0}]
[null,{"$f":"Originál!C29","v":0},null,null,null,null,null,{"$f":"Originál!C89","v":0}]
[null,{"$f":"Originál!C30","v":0},null,null,null,null,null,{"$f":"Originál!C90","v":0}]
[null,{"$f":"Originál!C31","v":0},null,null,null,null,null,{"$f":"Originál!C91","v":0}]
[null,{"$f":"Originál!C32","v":0},null,null,null,null,null,{"$f":"Originál!C92","v":0}]
[null,{"$f":"Originál!C33","v":0},null,null,null,null,null,{"$f":"Originál!C93","v":0}]
[null,{"$f":"Originál!C34","v":0},null,null,null,null,null,{"$f":"Originál!C94","v":0}]
[null,{"$f":"Originál!C35","v":0},null,null,null,null,null,{"$f":"Originál!C95","v":0}]
[null,{"$f":"Originál!C36","v":0},null,null,null,null,null,{"$f":"Originál!C96","v":0}]
[null,{"$f":"Originál!C37","v":0},null,null,null,null,null,{"$f":"Originál!C97","v":0}]
[null,{"$f":"Originál!C38","v":0},null,null,null,null,null,{"$f":"Originál!C98","v":0}]
[null,{"$f":"Originál!C39","v":0},null,null,null,null,null,{"$f":"Originál!C110","v":0}]
[null,{"$f":"Originál!C40","v":0},null,null,null,null,null,{"$f":"Originál!C111","v":0}]
[null,{"$f":"Originál!C41","v":0},null,null,null,null,null,{"$f":"Originál!C112","v":0}]
[null,{"$f":"Originál!C42","v":0},null,null,null,null,null,{"$f":"Originál!C113","v":0}]
[null,{"$f":"Originál!C43","v":0},null,null,null,null,null,{"$f":"Originál!C114","v":0}]
[null,{"$f":"Originál!C44","v":0},null,null,null,null,null,{"$f":"Originál!C115","v":0}]
[null,{"$f":"Originál!C45","v":0},null,null,null,null,null,{"$f":"Originál!C116","v":0}]
[null,{"$f":"Originál!C46","v":0},null,null,null,null,null,{"$f":"Originál!C117","v":0}]
[null,{"$f":"Originál!C47","v":0},null,null,null,null,null,{"$f":"Originál!C118","v":0}]
[null,{"$f":"Originál!C48","v":0},null,null,null,null,null,{"$f":"Originál!C119","v":0}]
[null,{"$f":"Originál!C49","v":0},null,null,null,null,null,{"$f":"Originál!C120","v":0}]
[null,"Captain Morgen",null,null,null,null,null,{"$f":"Originál!C121","v":0}]
[null,{"$f":"Originál!C61","v":0},null,null,null,null,null,{"$f":"Originál!C122","v":0}]
[null,{"$f":"Originál!C62","v":0},null,null,null,null,null,{"$f":"Originál!C123","v":0}]
[null,{"$f":"Originál!C63","v":0},null,null,null,null,null,{"$f":"Originál!C124","v":0}]
[null,{"$f":"Originál!C64","v":0},null,null,null,null,null,{"$f":"Originál!C125","v":0}]
[null,{"$f":"Originál!C65","v":0},null,null,null,null,null,{"$f":"Originál!C126","v":0}]
[null,{"$f":"Originál!C66","v":0},null,null,null,null,null,{"$f":"Originál!C127","v":0}]
[null,{"$f":"Originál!C67","v":0},null,null,null,null,null,{"$f":"Originál!C128","v":0}]
[null,{"$f":"Originál!C68","v":0},null,null,null,null,null,{"$f":"Originál!C129","v":0}]
[null,{"$f":"Originál!C69","v":0},null,null,null,null,null,{"$f":"Originál!C130","v":0}]
[null,{"$f":"Originál!C70","v":0},null,null,null,null,null,{"$f":"Originál!C131","v":0}]
[null,{"$f":"Originál!C71","v":0},null,null,null,null,null,{"$f":"Originál!C132","v":0}]
[null,{"$f":"Originál!C72","v":0},null,null,null,null,null,{"$f":"Originál!C133","v":0}]
[null,{"$f":"Originál!C73","v":0},null,null,null,null,null,{"$f":"Originál!C134","v":0}]
[null,{"$f":"Originál!C74","v":0},null,null,null,null,null,{"$f":"Originál!C135","v":0}]
[null,{"$f":"Originál!C75","v":0},null,null,null,null,null,{"$f":"Originál!C136","v":0}]
[null,"Výdavky:                                   Stávková:                              Hotovosť:"]

{"sheet":"0","index":4,"n_rows":152,"n_cols":22,"rows_kept":152,"cut":false,"hidden":false,"merged":[[140,3,140,4],[141,3,141,4],[142,3,142,4],[149,3,149,4],[150,3,150,4],[151,3,151,4],[107,17,108,17],[107,18,108,18],[107,20,108,20],[107,21,108,21],[138,14,139,14],[138,15,139,15],[138,16,139,16],[138,17,139,17],[138,18,139,18],[107,8,108,8],[107,9,108,9],[107,10,108,10],[107,14,108,14],[107,15,108,15],[107,16,108,16],[58,17,59,17],[58,18,59,18],[58,20,59,20],[58,21,59,21],[107,1,108,1],[107,2,108,2],[107,3,108,3],[107,4,108,4],[107,5,108,5],[107,6,108,6],[58,8,59,8],[58,9,59,9],[58,10,59,10],[58,14,59,14],[58,15,59,15],[58,16,59,16],[58,1,59,1],[58,2,59,2],[58,3,59,3],[58,4,59,4],[58,5,59,5],[58,6,59,6],[13,15,14,15],[13,16,14,16],[13,17,14,17],[13,18,14,18],[13,20,14,20],[13,21,14,21],[13,6,14,6],[13,8,14,8],[13,9,14,9],[13,10,14,10],[13,11,14,11],[13,14,14,14],[0,2,0,9],[0,14,0,17],[1,7,1,9],[1,15,1,16],[2,7,2,8],[13,1,14,1],[13,2,14,2],[13,3,14,3],[13,4,14,4],[13,5,14,5]]}
[null,null,"Vyučtovanie výčapu 2018",null,null,null,null,null,null,null,null,null,null,null,"Denný sumár"]
[null,null,null,null,null,null,"Meno:",null,null,null,null,null,null,"Juniorka","Meno:",{"$f":"I2","v":0}]
[null,null,null,null,null,null,"Dátum:",null,null,"/2018",null,null,null,"Šipulová","Dátum:",{"$f":"I3","v":0},"/2018"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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.","aaa",5,null,{"$f":"D16+E16","v":5},4,null,{"$f":"D16+E16-G16","v":1},2,{"$f":"I16*J16","v":2},"l.",null,null,1.032,{"$f":"J16","v":2},{"$f":"I16*J16","v":2},{"$f":"(P16-O16)*I16","v":0.96799999999999997},{"$f":"R16*0.8","v":0.77439999999999998},null,{"$f":"G16","v":4},{"$f":"U16*O16","v":4.1280000000000001}]
[null,"2.","sss",10,null,10,9,null,1,2,{"$f":"I17*J17","v":2},"l.",null,null,0.49299999999999999,{"$f":"J17","v":2},{"$f":"I17*J17","v":2},{"$f":"(P17-O17)*I17","v":1.5070000000000001},{"$f":"R17*0.8","v":1.2056000000000002},null,{"$f":"G17","v":9},{"$f":"U17*O17","v":4.4370000000000003}]
[null,"3.","dddd",1,null,1,1,null,0,2.8,0,"l.",null,null,1.52,2.8,0,{"$f":"(P18-O18)*I18","v":0},0,null,1,1.52]
[null,"4.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"5.","ref",22,null,22,21,null,1,0.8,0.8,"ks.",null,null,0.41,0.8,0.8,0.39000000000000007,0.31200000000000006,null,21,8.61]
[null,"6.","erfer",55,null,55,51,null,4,0.9,3.6,"ks.",null,null,0.47,0.9,3.6,1.7200000000000002,1.3760000000000003,null,51,23.97]
[null,"7.","erferf",888,null,888,758,null,130,1.2,156,"ks.",null,null,0.64,1.2,156,72.8,58.24,null,758,485.12]
[null,"8.","erferf",44,null,44,40,null,4,0.9,3.6,"ks.",null,null,0.49,0.9,3.6,1.6400000000000001,1.3120000000000003,null,40,19.600000000000001]
[null,"9.","ergfer",19,null,19,14,null,5,1.3,6.5,"ks.",null,null,0.93,1.3,6.5,1.85,1.4800000000000002,null,14,13.020000000000001]
[null,"10.","rgerg",59,null,59,59,null,0,1,0,"ks.",null,null,0.77,1,0,0,0,null,59,45.43]
[null,"11.","hzh",54,null,54,54,null,0,0.9,0,"ks.",null,null,0.49,0.9,0,0,0,null,54,26.46]
[null,"12.","zthtz",15,null,15,10,null,5,1,5,"ks.",null,null,0.42,1,5,2.9000000000000004,2.3200000000000003,null,10,4.2]
[null,"13.",null,null,null,0,null,null,0,1.2,0,"ks.",null,null,0.75,1.2,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.",null,null,null,0,null,null,0,3,0,"l.",null,null,1.29,3,0,0,0,null,0,0]
[null,"16.",null,null,null,0,null,null,0,3,0,"l.",null,null,1.29,3,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,12,0,"l.",null,null,6.35,12,0,0,0,null,0,0]
[null,"19.",null,null,null,0,null,null,0,12,0,"l.",null,null,6.35,12,0,0,0,null,0,0]
[null,"20.",null,null,null,0,null,null,0,14,0,"l.",null,null,5.83,14,0,0,0,null,0,0]
[null,"21.",null,null,null,0,null,null,0,12,0,"l.",null,null,5.78,12,0,0,0,null,0,0]
[null,"22.",null,null,null,0,null,null,0,14,0,"l.",null,null,7.1,14,0,0,0,null,0,0]
[null,"23.",null,null,null,0,null,null,0,14,0,"l.",null,null,5.74,14,0,0,0,null,0,0]
[null,"24.",null,null,null,0,null,null,0,12,0,"l.",null,null,6.17,12,0,0,0,null,0,0]
[null,"25.",null,null,null,0,null,null,0,12,0,"l.",null,null,4.92,12,0,0,0,null,0,0]
[null,"26.",null,null,null,0,null,null,0,14,0,"l.",null,null,4.38,14,0,0,0,null,0,0]
[null,"27.",null,null,null,0,null,null,0,20,0,"l.",null,null,10.8,20,0,0,0,null,0,0]
[null,"28.",null,null,null,0,null,null,0,20,0,"l.",null,null,9.69,20,0,0,0,null,0,0]
[null,"29.",null,null,null,0,null,null,0,14,0,"l.",null,null,7.15,14,0,0,0,null,0,0]
[null,"30.",null,null,null,0,null,null,0,24,0,"l.",null,null,16.91,24,0,0,0,null,0,0]
[null,"31.",null,null,null,0,null,null,0,20,0,"l.",null,null,5.9980000000000002,20,0,0,0,null,0,0]
[null,"32.",null,null,null,0,null,null,0,20,0,"l.",null,null,9.69,20,0,0,0,null,0,0]
[null,"33.",null,null,null,0,null,null,0,12,0,"l.",null,null,5.08,12,0,0,0,null,0,0]
[null,"34.",null,null,null,0,null,null,0,18,0,"l.",null,null,4.9000000000000004,18,0,0,0,null,0,0]
[null,"35.",null,null,null,0,null,null,0,24,0,"l.",null,null,11.45,24,0,0,0,null,0,0]
[null,"36.",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(D16:D51)","v":1172},null,null,{"$f":"SUM(G16:G51)","v":1021},null,null,"Celkom:",{"$f":"SUM(K16:K51)","v":179.5},null,null,null,null,"Celkom:",{"$f":"SUM(Q16:Q51)","v":179.5},{"$f":"SUM(R16:R51)","v":83.774999999999991},{"$f":"SUM(S16:S51)","v":67.02000000000001},null,"Za tovar:",{"$f":"SUM(V16:V51)","v":636.495}]
[]
[]
[]
[]
[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,"37.",null,null,null,{"$f":"D61+E61","v":0},null,null,{"$f":"D61+E61-G61","v":0},1.1000000000000001,{"$f":"I61*J61","v":0},"ks.",null,null,0.78,{"$f":"J61","v":1.1000000000000001},{"$f":"I61*J61","v":0},{"$f":"(P61-O61)*I61","v":0},{"$f":"R61*0.8","v":0},null,{"$f":"G61","v":0},{"$f":"U61*O61","v":0}]
[null,"38.",null,null,null,{"$f":"D62+E62","v":0},null,null,{"$f":"D62+E62-G62","v":0},2,{"$f":"I62*J62","v":0},"ks.",null,null,0.72599999999999998,{"$f":"J62","v":2},{"$f":"I62*J62","v":0},{"$f":"(P62-O62)*I62","v":0},{"$f":"R62*0.8","v":0},null,{"$f":"G62","v":0},{"$f":"U62*O62","v":0}]
[null,"39.",null,null,null,0,null,null,0,0.9,0,"ks.",null,null,0.52800000000000002,0.9,0,{"$f":"(P63-O63)*I63","v":0},0,null,0,0]
[null,"40.",null,null,null,0,null,null,0,1.1000000000000001,0,"ks.",null,null,0.49,1.1000000000000001,0,0,0,null,0,0]
[null,"41.",null,null,null,0,null,null,0,0.5,0,"ks.",null,null,0.2,0.5,0,0,0,null,0,0]
[null,"42.",null,null,null,0,null,null,0,1.8,0,"ks.",null,null,0.25,1.8,0,0,0,null,0,0]
[null,"43.",null,null,null,0,null,null,0,0.5,0,"ks.",null,null,0.11,0.5,0,0,0,null,0,0]
[null,"44.",null,0,null,0,0,null,0,1.5,0,"l.",null,null,0.23,1.5,0,0,0,null,0,0]
[null,"45.",null,null,null,0,null,null,0,1,0,"ks.",null,null,0.46,1,0,0,0,null,0,0]
[null,"46.",null,null,null,0,null,null,0,3,0,"ks.",null,null,1.1879999999999999,3,0,0,0,null,0,0]
[null,"47.",null,null,null,0,null,null,0,1.1000000000000001,0,"l.",null,null,0.33,1.1000000000000001,0,0,0,null,0,0]
[null,"48.",null,null,null,0,null,null,0,0.8,0,"ks.",null,null,0.32,0.8,0,0,0,null,0,0]
[null,"49.",null,null,null,0,null,null,0,1.1000000000000001,0,"ks.",null,null,0.624,1.1000000000000001,0,0,0,null,0,0]
[null,"50.",null,null,null,0,null,null,0,1.1000000000000001,0,"ks.",null,null,0.504,1.1000000000000001,0,0,0,null,0,0]
[null,"51.",null,null,null,0,null,null,0,1.2,0,"ks.",null,null,0.64,1.2,0,0,0,null,0,0]
[null,"52.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"53.",null,null,null,0,null,null,{"$f":"(D77+E77-G77)/7","v":0},0.5,0,"gr.",null,null,3.4000000000000002E-2,0.5,{"$f":"K77","v":0},0,0,null,0,0]
[null,"54.",null,null,null,0,null,null,0,0.5,0,"ks.",null,null,0.14000000000000001,0.5,0,0,0,null,0,0]
[null,"55.",null,null,null,0,null,null,0,0.5,{"$f":"I79*J79","v":0},"ks.",null,null,5.8000000000000003E-2,0.5,{"$f":"I79*J79","v":0},0,0,null,0,{"$f":"U79*O80","v":0}]
[null,"56.",null,null,null,0,null,null,0,0.1,{"$f":"I80*J80","v":0},"ks.",null,null,3.5999999999999997E-2,0.1,{"$f":"I80*J80","v":0},0,0,null,0,{"$f":"U80*O81","v":0}]
[null,"57.",null,null,null,0,null,null,0,0.05,{"$f":"I81*J81","v":0},"ks.",null,null,0.08,0.05,{"$f":"I81*J81","v":0},0,0,null,0,{"$f":"U81*O82","v":0}]
[null,"58.",null,null,null,0,null,null,0,null,{"$f":"I82*J82","v":0},null,null,null,null,0,{"$f":"I82*J82","v":0},0,0,null,0,{"$f":"U82*O83","v":0}]
[null,"59.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"60.",null,null,null,0,null,null,0,3.2,0,"ks.",null,null,3.04,3.2,0,0,0,null,0,0]
[null,"61.",null,null,null,0,null,null,0,3.3,0,"ks.",null,null,3.3,3.3,0,0,0,null,0,0]
[null,"62.",null,null,null,0,null,null,0,3.4,0,"ks.",null,null,3.32,3.4,0,0,0,null,0,0]
[null,"63.",null,null,null,0,null,null,0,3.6,0,"ks.",null,null,2.95,3.6,0,0,0,null,0,0]
[null,"64.",null,null,null,0,null,null,0,3.3,0,"ks.",null,null,3.04,3.3,0,0,0,null,0,0]
[null,"65.",null,null,null,0,null,null,0,3.2,0,"ks.",null,null,3.04,3.2,0,0,0,null,0,0]
[null,"66.",null,null,null,0,null,null,0,3.1,0,"ks.",null,null,2.94,3.1,0,0,0,null,0,0]
[null,"67.",null,null,null,0,null,null,0,3.2,0,"ks.",null,null,3.04,3.2,0,0,0,null,0,0]
[null,"68.",null,null,null,0,null,null,0,3.1,0,"ks.",null,null,null,3.1,0,0,0,null,0,0]
[null,"69.",null,null,null,0,null,null,0,3.3,0,"ks.",null,null,null,3.3,0,0,0,null,0,0]
[null,"70.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"71.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"72.",null,null,null,0,null,null,0,0.2,0,"ks.",null,null,8.8999999999999996E-2,0.2,0,0,0,null,0,0]
[null,"73.",null,null,null,0,null,null,0,0.5,0,"ks.",null,null,0.17,0.5,0,0,0,null,0,0]
[null,"74.",null,null,null,0,null,null,0,0.1,0,"ks.",null,null,0.04,0.1,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.",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(D61:D101)","v":0},null,null,{"$f":"SUM(G61:G101)","v":0},null,null,"Celkom :",{"$f":"SUM(K61:K101)","v":0},null,null,null,null,"Celkom:",{"$f":"SUM(Q61:Q101)","v":0},{"$f":"SUM(R61:R101)","v":0},{"$f":"SUM(S61:S101)","v":0},null,"Za tovar:",{"$f":"SUM(V61:V101)","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,"78.",null,null,null,{"$f":"D110+E110","v":0},null,null,{"$f":"D110+E110-G110","v":0},1.2,{"$f":"I110*J110","v":0},"ks.",null,null,0.73,{"$f":"J110","v":1.2},{"$f":"I110*J110","v":0},{"$f":"(P110-O110)*I110","v":0},{"$f":"R110*0.8","v":0},null,{"$f":"G110","v":0},{"$f":"U110*O110","v":0}]
[null,"79.",null,null,null,{"$f":"D111+E111","v":0},null,null,{"$f":"D111+E111-G111","v":0},0.6,{"$f":"I111*J111","v":0},"ks.",null,null,0.28999999999999998,{"$f":"J111","v":0.6},{"$f":"I111*J111","v":0},{"$f":"(P111-O111)*I111","v":0},{"$f":"R111*0.8","v":0},null,{"$f":"G111","v":0},{"$f":"U111*O111","v":0}]
[null,"80.",null,null,null,0,null,null,0,0.6,0,"ks.",null,null,0.28000000000000003,0.6,0,{"$f":"(P112-O112)*I112","v":0},0,null,0,0]
[null,"81.",null,null,null,0,null,null,0,1.5,0,"ks.",null,null,0.9,1.5,0,0,0,null,0,0]
[null,"82.",null,null,null,0,null,null,0,0.6,0,"ks.",null,null,0.32,0.6,0,0,0,null,0,0]
[null,"83.",null,null,null,0,null,null,0,0.6,0,"ks.",null,null,0.26,0.6,0,0,0,null,0,0]
[null,"84.",null,null,null,0,null,null,0,0.6,0,"ks.",null,null,0.4,0.6,0,0,0,null,0,0]
[null,"85.",null,null,null,0,null,null,0,null,0,"ks.",null,null,null,0,0,0,0,null,0,0]
[null,"86.",null,null,null,0,null,null,0,0.6,0,"ks.",null,null,0.33,0.6,0,0,0,null,0,0]
[null,"87.",null,null,null,0,null,null,0,0.3,0,"ks.",null,null,0.1,0.3,0,0,0,null,0,0]
[null,"88.",null,null,null,0,null,null,0,0.8,0,"ks.",null,null,0.5,0.8,0,0,0,null,0,0]
[null,"89.",null,null,null,0,null,null,0,2.6,0,"ks.",null,null,1.62,2.6,0,0,0,null,0,0]
[null,"90.",null,null,null,0,null,null,0,1.5,0,"ks.",null,null,0.73,1.5,0,0,0,null,0,0]
[null,"91.",null,null,null,0,null,null,0,0.5,0,"ks.",null,null,0.24,0.5,0,0,0,null,0,0]
[null,"92.",null,null,null,0,null,null,0,0.8,0,"ks.",null,null,0.33,0.8,0,0,0,null,0,0]
[null,"93.",null,null,null,0,null,null,0,0.6,0,"ks.",null,null,0.3,0.6,0,0,0,null,0,0]
[null,"94.",null,null,null,0,null,null,0,0.1,0,"ks.",null,null,5.1999999999999998E-2,0.1,0,0,0,null,0,0]
[null,"95.",null,null,null,0,null,null,0,0.6,0,"ks.",null,null,0.37,0.6,0,0,0,null,0,0]
[null,"96.",null,null,null,0,null,null,0,0.9,0,"ks.",null,null,0.54,0.9,0,0,0,null,0,0]
[null,"97.",null,null,null,0,null,null,0,0.7,0,"ks.",null,null,0.3,0.7,0,0,0,null,0,0]
[null,"98.",null,null,null,0,null,null,0,0.5,0,"ks.",null,null,0.27,0.5,0,0,0,null,0,0]
[null,"99.",null,null,null,0,null,null,0,0.6,0,"ks.",null,null,0.32,0.6,0,0,0,null,0,0]
[null,"100.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"101.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"102.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"103.",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(D110:D135)","v":0},null,null,{"$f":"SUM(G110:G135)","v":0},null,null,"Celkom:",{"$f":"SUM(K110:K135)","v":0},null,null,null,null,"Celkom:",{"$f":"SUM(Q110:Q135)","v":0},{"$f":"SUM(R110:R135)","v":0},{"$f":"SUM(S110:S135)","v":0},null,"Za tovar:",{"$f":"SUM(V110:V135)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tržba","Zisk","Zisk po zdanený"]
[]
[null,null,null,"Stávková:",null,null,null,null,"Strana 1:",{"$f":"K53","v":179.5},null,null,null,null,null,"Strana 1",{"$f":"Q53","v":179.5},{"$f":"R53","v":83.774999999999991},{"$f":"S53","v":67.02000000000001},null,"Strana 1:",{"$f":"V53","v":636.495}]
[null,null,null,"Refil:",null,null,null,null,"Strana 2:",{"$f":"K103","v":0},null,null,null,null,null,"Strana 2",{"$f":"Q103","v":0},{"$f":"R103","v":0},{"$f":"S103","v":0},null,"Strana 2:",{"$f":"V103","v":0}]
[null,null,null,"Výdavky:",null,null,null,null,"Strana 3:",{"$f":"K137","v":0},null,null,null,null,null,"Strana 3",{"$f":"Q137","v":0},{"$f":"R137","v":0},{"$f":"S137","v":0},null,"Strana 3:",{"$f":"V137","v":0}]
[]
[null,null,null,null,"Spolu:",{"$f":"SUM(F141:F143)","v":0},null,null,"Spolu:",{"$f":"SUM(J141:J143)","v":179.5},null,null,null,null,null,"Spolu:",{"$f":"SUM(Q141:Q143)","v":179.5},{"$f":"SUM(R141:R143)","v":83.774999999999991},{"$f":"SUM(S141:S143)","v":67.02000000000001},null,"Spolu:",{"$f":"SUM(V141:V143)","v":636.495}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spolu:",{"$f":"Q145-F145","v":179.5}]
[null,null,null,null,null,null,null,null,"Spolu :",{"$f":"J145-F145","v":179.5}]
[]
[null,null,"Zostatok hotovosť:"]
[]
[null,null,"rozdiel:",{"$f":"D150-J148","v":-179.5}]

{"sheet":"1","index":5,"n_rows":152,"n_cols":22,"rows_kept":152,"cut":false,"hidden":false,"merged":[[140,3,140,4],[141,3,141,4],[142,3,142,4],[149,3,149,4],[150,3,150,4],[151,3,151,4],[107,17,108,17],[107,18,108,18],[107,20,108,20],[107,21,108,21],[138,14,139,14],[138,15,139,15],[138,16,139,16],[138,17,139,17],[138,18,139,18],[107,8,108,8],[107,9,108,9],[107,10,108,10],[107,14,108,14],[107,15,108,15],[107,16,108,16],[58,17,59,17],[58,18,59,18],[58,20,59,20],[58,21,59,21],[107,1,108,1],[107,2,108,2],[107,3,108,3],[107,4,108,4],[107,5,108,5],[107,6,108,6],[58,8,59,8],[58,9,59,9],[58,10,59,10],[58,14,59,14],[58,15,59,15],[58,16,59,16],[58,1,59,1],[58,2,59,2],[58,3,59,3],[58,4,59,4],[58,5,59,5],[58,6,59,6],[13,15,14,15],[13,16,14,16],[13,17,14,17],[13,18,14,18],[13,20,14,20],[13,21,14,21],[13,6,14,6],[13,8,14,8],[13,9,14,9],[13,10,14,10],[13,11,14,11],[13,14,14,14],[0,2,0,9],[0,14,0,17],[1,7,1,9],[1,15,1,16],[2,7,2,8],[13,1,14,1],[13,2,14,2],[13,3,14,3],[13,4,14,4],[13,5,14,5]]}
[null,null,"Vyučtovanie výčapu 2018",null,null,null,null,null,null,null,null,null,null,null,"Denný sumár"]
[null,null,null,null,null,null,"Meno:",null,null,null,null,null,null,"Juniorka","Meno:",{"$f":"I2","v":0}]
[null,null,null,null,null,null,"Dátum:",null,null,"/2018",null,null,null,"Šipulová","Dátum:",{"$f":"I3","v":0},"/2018"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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.","aaa",4,5,{"$f":"D16+E16","v":9},9,null,{"$f":"D16+E16-G16","v":0},2,{"$f":"I16*J16","v":0},"l.",null,null,1.032,{"$f":"J16","v":2},{"$f":"I16*J16","v":0},{"$f":"(P16-O16)*I16","v":0},{"$f":"R16*0.8","v":0},null,{"$f":"G16","v":9},{"$f":"U16*O16","v":9.2880000000000003}]
[null,"2.","sss",9,5,14,14,null,0,2,{"$f":"I17*J17","v":0},"l.",null,null,0.49299999999999999,{"$f":"J17","v":2},{"$f":"I17*J17","v":0},{"$f":"(P17-O17)*I17","v":0},{"$f":"R17*0.8","v":0},null,{"$f":"G17","v":14},{"$f":"U17*O17","v":6.9020000000000001}]
[null,"3.","dddd",1,5,6,5,null,1,2.8,2.8,"l.",null,null,1.52,2.8,2.8,{"$f":"(P18-O18)*I18","v":1.2799999999999998},1.0239999999999998,null,5,7.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.","ref",21,null,21,19,null,2,0.8,1.6,"ks.",null,null,0.41,0.8,1.6,0.78000000000000014,0.62400000000000011,null,19,7.7899999999999991]
[null,"6.","erfer",51,5,56,40,null,16,0.9,14.4,"ks.",null,null,0.47,0.9,14.4,6.8800000000000008,5.5040000000000013,null,40,18.799999999999997]
[null,"7.","erferf",758,25,783,458,null,325,1.2,390,"ks.",null,null,0.64,1.2,390,181.99999999999997,145.6,null,458,293.12]
[null,"8.","erferf",40,2,42,40,null,2,0.9,1.8,"ks.",null,null,0.49,0.9,1.8,0.82000000000000006,0.65600000000000014,null,40,19.600000000000001]
[null,"9.","ergfer",14,5,19,18,null,1,1.3,1.3,"ks.",null,null,0.93,1.3,1.3,0.37,0.29599999999999999,null,18,16.740000000000002]
[null,"10.","rgerg",59,2,61,50,null,11,1,11,"ks.",null,null,0.77,1,11,2.5299999999999998,2.024,null,50,38.5]
[null,"11.","hzh",54,null,54,2,null,52,0.9,46.800000000000004,"ks.",null,null,0.49,0.9,46.800000000000004,21.32,17.056000000000001,null,2,0.98]
[null,"12.","zthtz",10,null,10,8,null,2,1,2,"ks.",null,null,0.42,1,2,1.1600000000000001,0.92800000000000016,null,8,3.36]
[null,"13.",null,null,null,0,null,null,0,1.2,0,"ks.",null,null,0.75,1.2,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.",null,null,null,0,null,null,0,3,0,"l.",null,null,1.29,3,0,0,0,null,0,0]
[null,"16.",null,null,null,0,null,null,0,3,0,"l.",null,null,1.29,3,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,12,0,"l.",null,null,6.35,12,0,0,0,null,0,0]
[null,"19.",null,null,null,0,null,null,0,12,0,"l.",null,null,6.35,12,0,0,0,null,0,0]
[null,"20.",null,null,null,0,null,null,0,14,0,"l.",null,null,5.83,14,0,0,0,null,0,0]
[null,"21.",null,null,null,0,null,null,0,12,0,"l.",null,null,5.78,12,0,0,0,null,0,0]
[null,"22.",null,null,null,0,null,null,0,14,0,"l.",null,null,7.1,14,0,0,0,null,0,0]
[null,"23.",null,null,null,0,null,null,0,14,0,"l.",null,null,5.74,14,0,0,0,null,0,0]
[null,"24.",null,null,null,0,null,null,0,12,0,"l.",null,null,6.17,12,0,0,0,null,0,0]
[null,"25.",null,null,null,0,null,null,0,12,0,"l.",null,null,4.92,12,0,0,0,null,0,0]
[null,"26.",null,null,null,0,null,null,0,14,0,"l.",null,null,4.38,14,0,0,0,null,0,0]
[null,"27.",null,null,null,0,null,null,0,20,0,"l.",null,null,10.8,20,0,0,0,null,0,0]
[null,"28.",null,null,null,0,null,null,0,20,0,"l.",null,null,9.69,20,0,0,0,null,0,0]
[null,"29.",null,null,null,0,null,null,0,14,0,"l.",null,null,7.15,14,0,0,0,null,0,0]
[null,"30.",null,null,null,0,null,null,0,24,0,"l.",null,null,16.91,24,0,0,0,null,0,0]
[null,"31.",null,null,null,0,null,null,0,20,0,"l.",null,null,5.9980000000000002,20,0,0,0,null,0,0]
[null,"32.",null,null,null,0,null,null,0,20,0,"l.",null,null,9.69,20,0,0,0,null,0,0]
[null,"33.",null,null,null,0,null,null,0,12,0,"l.",null,null,5.08,12,0,0,0,null,0,0]
[null,"34.",null,null,null,0,null,null,0,18,0,"l.",null,null,4.9000000000000004,18,0,0,0,null,0,0]
[null,"35.",null,null,null,0,null,null,0,24,0,"l.",null,null,11.45,24,0,0,0,null,0,0]
[null,"36.",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(D16:D51)","v":1021},null,null,{"$f":"SUM(G16:G51)","v":663},null,null,"Celkom:",{"$f":"SUM(K16:K51)","v":471.70000000000005},null,null,null,null,"Celkom:",{"$f":"SUM(Q16:Q51)","v":471.70000000000005},{"$f":"SUM(R16:R51)","v":217.13999999999996},{"$f":"SUM(S16:S51)","v":173.71200000000002},null,"Za tovar:",{"$f":"SUM(V16:V51)","v":422.68000000000006}]
[]
[]
[]
[]
[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,"37.",null,null,null,{"$f":"D61+E61","v":0},null,null,{"$f":"D61+E61-G61","v":0},1.1000000000000001,{"$f":"I61*J61","v":0},"ks.",null,null,0.78,{"$f":"J61","v":1.1000000000000001},{"$f":"I61*J61","v":0},{"$f":"(P61-O61)*I61","v":0},{"$f":"R61*0.8","v":0},null,{"$f":"G61","v":0},{"$f":"U61*O61","v":0}]
[null,"38.",null,null,null,{"$f":"D62+E62","v":0},null,null,{"$f":"D62+E62-G62","v":0},2,{"$f":"I62*J62","v":0},"ks.",null,null,0.72599999999999998,{"$f":"J62","v":2},{"$f":"I62*J62","v":0},{"$f":"(P62-O62)*I62","v":0},{"$f":"R62*0.8","v":0},null,{"$f":"G62","v":0},{"$f":"U62*O62","v":0}]
[null,"39.",null,null,null,0,null,null,0,0.9,0,"ks.",null,null,0.52800000000000002,0.9,0,{"$f":"(P63-O63)*I63","v":0},0,null,0,0]
[null,"40.",null,null,null,0,null,null,0,1.1000000000000001,0,"ks.",null,null,0.49,1.1000000000000001,0,0,0,null,0,0]
[null,"41.",null,null,null,0,null,null,0,0.5,0,"ks.",null,null,0.2,0.5,0,0,0,null,0,0]
[null,"42.",null,null,null,0,null,null,0,1.8,0,"ks.",null,null,0.25,1.8,0,0,0,null,0,0]
[null,"43.",null,null,null,0,null,null,0,0.5,0,"ks.",null,null,0.11,0.5,0,0,0,null,0,0]
[null,"44.",null,0,null,0,0,null,0,1.5,0,"l.",null,null,0.23,1.5,0,0,0,null,0,0]
[null,"45.",null,null,null,0,null,null,0,1,0,"ks.",null,null,0.46,1,0,0,0,null,0,0]
[null,"46.",null,null,null,0,null,null,0,3,0,"ks.",null,null,1.1879999999999999,3,0,0,0,null,0,0]
[null,"47.",null,null,null,0,null,null,0,1.1000000000000001,0,"l.",null,null,0.33,1.1000000000000001,0,0,0,null,0,0]
[null,"48.",null,null,null,0,null,null,0,0.8,0,"ks.",null,null,0.32,0.8,0,0,0,null,0,0]
[null,"49.",null,null,null,0,null,null,0,1.1000000000000001,0,"ks.",null,null,0.624,1.1000000000000001,0,0,0,null,0,0]
[null,"50.",null,null,null,0,null,null,0,1.1000000000000001,0,"ks.",null,null,0.504,1.1000000000000001,0,0,0,null,0,0]
[null,"51.",null,null,null,0,null,null,0,1.2,0,"ks.",null,null,0.64,1.2,0,0,0,null,0,0]
[null,"52.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"53.",null,null,null,0,null,null,{"$f":"(D77+E77-G77)/7","v":0},0.5,0,"gr.",null,null,3.4000000000000002E-2,0.5,{"$f":"K77","v":0},0,0,null,0,0]
[null,"54.",null,null,null,0,null,null,0,0.5,0,"ks.",null,null,0.14000000000000001,0.5,0,0,0,null,0,0]
[null,"55.",null,null,null,0,null,null,0,0.5,{"$f":"I79*J79","v":0},"ks.",null,null,5.8000000000000003E-2,0.5,{"$f":"I79*J79","v":0},0,0,null,0,{"$f":"U79*O80","v":0}]
[null,"56.",null,null,null,0,null,null,0,0.1,{"$f":"I80*J80","v":0},"ks.",null,null,3.5999999999999997E-2,0.1,{"$f":"I80*J80","v":0},0,0,null,0,{"$f":"U80*O81","v":0}]
[null,"57.",null,null,null,0,null,null,0,0.05,{"$f":"I81*J81","v":0},"ks.",null,null,0.08,0.05,{"$f":"I81*J81","v":0},0,0,null,0,{"$f":"U81*O82","v":0}]
[null,"58.",null,null,null,0,null,null,0,null,{"$f":"I82*J82","v":0},null,null,null,null,0,{"$f":"I82*J82","v":0},0,0,null,0,{"$f":"U82*O83","v":0}]
[null,"59.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"60.",null,null,null,0,null,null,0,3.2,0,"ks.",null,null,3.04,3.2,0,0,0,null,0,0]
[null,"61.",null,null,null,0,null,null,0,3.3,0,"ks.",null,null,3.3,3.3,0,0,0,null,0,0]
[null,"62.",null,null,null,0,null,null,0,3.4,0,"ks.",null,null,3.32,3.4,0,0,0,null,0,0]
[null,"63.",null,null,null,0,null,null,0,3.6,0,"ks.",null,null,2.95,3.6,0,0,0,null,0,0]
[null,"64.",null,null,null,0,null,null,0,3.3,0,"ks.",null,null,3.04,3.3,0,0,0,null,0,0]
[null,"65.",null,null,null,0,null,null,0,3.2,0,"ks.",null,null,3.04,3.2,0,0,0,null,0,0]
[null,"66.",null,null,null,0,null,null,0,3.1,0,"ks.",null,null,2.94,3.1,0,0,0,null,0,0]
[null,"67.",null,null,null,0,null,null,0,3.2,0,"ks.",null,null,3.04,3.2,0,0,0,null,0,0]
[null,"68.",null,null,null,0,null,null,0,3.1,0,"ks.",null,null,null,3.1,0,0,0,null,0,0]
[null,"69.",null,null,null,0,null,null,0,3.3,0,"ks.",null,null,null,3.3,0,0,0,null,0,0]
[null,"70.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"71.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"72.",null,null,null,0,null,null,0,0.2,0,"ks.",null,null,8.8999999999999996E-2,0.2,0,0,0,null,0,0]
[null,"73.",null,null,null,0,null,null,0,0.5,0,"ks.",null,null,0.17,0.5,0,0,0,null,0,0]
[null,"74.",null,null,null,0,null,null,0,0.1,0,"ks.",null,null,0.04,0.1,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.",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(D61:D101)","v":0},null,null,{"$f":"SUM(G61:G101)","v":0},null,null,"Celkom :",{"$f":"SUM(K61:K101)","v":0},null,null,null,null,"Celkom:",{"$f":"SUM(Q61:Q101)","v":0},{"$f":"SUM(R61:R101)","v":0},{"$f":"SUM(S61:S101)","v":0},null,"Za tovar:",{"$f":"SUM(V61:V101)","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,"78.",null,null,null,{"$f":"D110+E110","v":0},null,null,{"$f":"D110+E110-G110","v":0},1.2,{"$f":"I110*J110","v":0},"ks.",null,null,0.73,{"$f":"J110","v":1.2},{"$f":"I110*J110","v":0},{"$f":"(P110-O110)*I110","v":0},{"$f":"R110*0.8","v":0},null,{"$f":"G110","v":0},{"$f":"U110*O110","v":0}]
[null,"79.",null,null,null,{"$f":"D111+E111","v":0},null,null,{"$f":"D111+E111-G111","v":0},0.6,{"$f":"I111*J111","v":0},"ks.",null,null,0.28999999999999998,{"$f":"J111","v":0.6},{"$f":"I111*J111","v":0},{"$f":"(P111-O111)*I111","v":0},{"$f":"R111*0.8","v":0},null,{"$f":"G111","v":0},{"$f":"U111*O111","v":0}]
[null,"80.",null,null,null,0,null,null,0,0.6,0,"ks.",null,null,0.28000000000000003,0.6,0,{"$f":"(P112-O112)*I112","v":0},0,null,0,0]
[null,"81.",null,null,null,0,null,null,0,1.5,0,"ks.",null,null,0.9,1.5,0,0,0,null,0,0]
[null,"82.",null,null,null,0,null,null,0,0.6,0,"ks.",null,null,0.32,0.6,0,0,0,null,0,0]
[null,"83.",null,null,null,0,null,null,0,0.6,0,"ks.",null,null,0.26,0.6,0,0,0,null,0,0]
[null,"84.",null,null,null,0,null,null,0,0.6,0,"ks.",null,null,0.4,0.6,0,0,0,null,0,0]
[null,"85.",null,null,null,0,null,null,0,null,0,"ks.",null,null,null,0,0,0,0,null,0,0]
[null,"86.",null,null,null,0,null,null,0,0.6,0,"ks.",null,null,0.33,0.6,0,0,0,null,0,0]
[null,"87.",null,null,null,0,null,null,0,0.3,0,"ks.",null,null,0.1,0.3,0,0,0,null,0,0]
[null,"88.",null,null,null,0,null,null,0,0.8,0,"ks.",null,null,0.5,0.8,0,0,0,null,0,0]
[null,"89.",null,null,null,0,null,null,0,2.6,0,"ks.",null,null,1.62,2.6,0,0,0,null,0,0]
[null,"90.",null,null,null,0,null,null,0,1.5,0,"ks.",null,null,0.73,1.5,0,0,0,null,0,0]
[null,"91.",null,null,null,0,null,null,0,0.5,0,"ks.",null,null,0.24,0.5,0,0,0,null,0,0]
[null,"92.",null,null,null,0,null,null,0,0.8,0,"ks.",null,null,0.33,0.8,0,0,0,null,0,0]
[null,"93.",null,null,null,0,null,null,0,0.6,0,"ks.",null,null,0.3,0.6,0,0,0,null,0,0]
[null,"94.",null,null,null,0,null,null,0,0.1,0,"ks.",null,null,5.1999999999999998E-2,0.1,0,0,0,null,0,0]
[null,"95.",null,null,null,0,null,null,0,0.6,0,"ks.",null,null,0.37,0.6,0,0,0,null,0,0]
[null,"96.",null,null,null,0,null,null,0,0.9,0,"ks.",null,null,0.54,0.9,0,0,0,null,0,0]
[null,"97.",null,null,null,0,null,null,0,0.7,0,"ks.",null,null,0.3,0.7,0,0,0,null,0,0]
[null,"98.",null,null,null,0,null,null,0,0.5,0,"ks.",null,null,0.27,0.5,0,0,0,null,0,0]
[null,"99.",null,null,null,0,null,null,0,0.6,0,"ks.",null,null,0.32,0.6,0,0,0,null,0,0]
[null,"100.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"101.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"102.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"103.",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(D110:D135)","v":0},null,null,{"$f":"SUM(G110:G135)","v":0},null,null,"Celkom:",{"$f":"SUM(K110:K135)","v":0},null,null,null,null,"Celkom:",{"$f":"SUM(Q110:Q135)","v":0},{"$f":"SUM(R110:R135)","v":0},{"$f":"SUM(S110:S135)","v":0},null,"Za tovar:",{"$f":"SUM(V110:V135)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tržba","Zisk","Zisk po zdanený"]
[]
[null,null,null,"Stávková:",null,null,null,null,"Strana 1:",{"$f":"K53","v":471.70000000000005},null,null,null,null,null,"Strana 1",{"$f":"Q53","v":471.70000000000005},{"$f":"R53","v":217.13999999999996},{"$f":"S53","v":173.71200000000002},null,"Strana 1:",{"$f":"V53","v":422.68000000000006}]
[null,null,null,"Refil:",null,null,null,null,"Strana 2:",{"$f":"K103","v":0},null,null,null,null,null,"Strana 2",{"$f":"Q103","v":0},{"$f":"R103","v":0},{"$f":"S103","v":0},null,"Strana 2:",{"$f":"V103","v":0}]
[null,null,null,"Výdavky:",null,null,null,null,"Strana 3:",{"$f":"K137","v":0},null,null,null,null,null,"Strana 3",{"$f":"Q137","v":0},{"$f":"R137","v":0},{"$f":"S137","v":0},null,"Strana 3:",{"$f":"V137","v":0}]
[]
[null,null,null,null,"Spolu:",{"$f":"SUM(F141:F143)","v":0},null,null,"Spolu:",{"$f":"SUM(J141:J143)","v":471.70000000000005},null,null,null,null,null,"Spolu:",{"$f":"SUM(Q141:Q143)","v":471.70000000000005},{"$f":"SUM(R141:R143)","v":217.13999999999996},{"$f":"SUM(S141:S143)","v":173.71200000000002},null,"Spolu:",{"$f":"SUM(V141:V143)","v":422.68000000000006}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spolu:",{"$f":"Q145-F145","v":471.70000000000005}]
[null,null,null,null,null,null,null,null,"Spolu :",{"$f":"J145-F145","v":471.70000000000005}]
[]
[null,null,"Zostatok hotovosť:"]
[]
[null,null,"rozdiel:",{"$f":"D150-J148","v":-471.70000000000005}]

{"sheet":"2","index":6,"n_rows":152,"n_cols":22,"rows_kept":152,"cut":false,"hidden":false,"merged":[[140,3,140,4],[141,3,141,4],[142,3,142,4],[149,3,149,4],[150,3,150,4],[151,3,151,4],[107,17,108,17],[107,18,108,18],[107,20,108,20],[107,21,108,21],[138,14,139,14],[138,15,139,15],[138,16,139,16],[138,17,139,17],[138,18,139,18],[107,8,108,8],[107,9,108,9],[107,10,108,10],[107,14,108,14],[107,15,108,15],[107,16,108,16],[58,17,59,17],[58,18,59,18],[58,20,59,20],[58,21,59,21],[107,1,108,1],[107,2,108,2],[107,3,108,3],[107,4,108,4],[107,5,108,5],[107,6,108,6],[58,8,59,8],[58,9,59,9],[58,10,59,10],[58,14,59,14],[58,15,59,15],[58,16,59,16],[58,1,59,1],[58,2,59,2],[58,3,59,3],[58,4,59,4],[58,5,59,5],[58,6,59,6],[13,15,14,15],[13,16,14,16],[13,17,14,17],[13,18,14,18],[13,20,14,20],[13,21,14,21],[13,6,14,6],[13,8,14,8],[13,9,14,9],[13,10,14,10],[13,11,14,11],[13,14,14,14],[0,2,0,9],[0,14,0,17],[1,7,1,9],[1,15,1,16],[2,7,2,8],[13,1,14,1],[13,2,14,2],[13,3,14,3],[13,4,14,4],[13,5,14,5]]}
[null,null,"Vyučtovanie výčapu 2018",null,null,null,null,null,null,null,null,null,null,null,"Denný sumár"]
[null,null,null,null,null,null,"Meno:",null,null,null,null,null,null,"Juniorka","Meno:",{"$f":"I2","v":0}]
[null,null,null,null,null,null,"Dátum:",null,null,"/2018",null,null,null,"Šipulová","Dátum:",{"$f":"I3","v":0},"/2018"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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.","aaa",9,null,{"$f":"D16+E16","v":9},8,null,{"$f":"D16+E16-G16","v":1},2,{"$f":"I16*J16","v":2},"l.",null,null,1.032,{"$f":"J16","v":2},{"$f":"I16*J16","v":2},{"$f":"(P16-O16)*I16","v":0.96799999999999997},{"$f":"R16*0.8","v":0.77439999999999998},null,{"$f":"G16","v":8},{"$f":"U16*O16","v":8.2560000000000002}]
[null,"2.","sss",14,null,14,10,null,4,2,{"$f":"I17*J17","v":8},"l.",null,null,0.49299999999999999,{"$f":"J17","v":2},{"$f":"I17*J17","v":8},{"$f":"(P17-O17)*I17","v":6.0280000000000005},{"$f":"R17*0.8","v":4.8224000000000009},null,{"$f":"G17","v":10},{"$f":"U17*O17","v":4.93}]
[null,"3.","dddd",5,null,5,4,null,1,2.8,2.8,"l.",null,null,1.52,2.8,2.8,{"$f":"(P18-O18)*I18","v":1.2799999999999998},1.0239999999999998,null,4,6.08]
[null,"4.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"5.","ref",19,null,19,17,null,2,0.8,1.6,"ks.",null,null,0.41,0.8,1.6,0.78000000000000014,0.62400000000000011,null,17,6.97]
[null,"6.","erfer",40,null,40,35,null,5,0.9,4.5,"ks.",null,null,0.47,0.9,4.5,2.1500000000000004,1.7200000000000004,null,35,16.45]
[null,"7.","erferf",458,null,458,450,null,8,1.2,9.6,"ks.",null,null,0.64,1.2,9.6,4.4799999999999995,3.5839999999999996,null,450,288]
[null,"8.","erferf",40,null,40,39,null,1,0.9,0.9,"ks.",null,null,0.49,0.9,0.9,0.41000000000000003,0.32800000000000007,null,39,19.11]
[null,"9.","ergfer",18,null,18,17,null,1,1.3,1.3,"ks.",null,null,0.93,1.3,1.3,0.37,0.29599999999999999,null,17,15.81]
[null,"10.","rgerg",50,null,50,48,null,2,1,2,"ks.",null,null,0.77,1,2,0.45999999999999996,0.36799999999999999,null,48,36.96]
[null,"11.","hzh",2,null,2,1,null,1,0.9,0.9,"ks.",null,null,0.49,0.9,0.9,0.41000000000000003,0.32800000000000007,null,1,0.49]
[null,"12.","zthtz",8,null,8,null,null,8,1,8,"ks.",null,null,0.42,1,8,4.6400000000000006,3.7120000000000006,null,0,0]
[null,"13.",null,null,null,0,null,null,0,1.2,0,"ks.",null,null,0.75,1.2,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.",null,null,null,0,null,null,0,3,0,"l.",null,null,1.29,3,0,0,0,null,0,0]
[null,"16.",null,null,null,0,null,null,0,3,0,"l.",null,null,1.29,3,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,12,0,"l.",null,null,6.35,12,0,0,0,null,0,0]
[null,"19.",null,null,null,0,null,null,0,12,0,"l.",null,null,6.35,12,0,0,0,null,0,0]
[null,"20.",null,null,null,0,null,null,0,14,0,"l.",null,null,5.83,14,0,0,0,null,0,0]
[null,"21.",null,null,null,0,null,null,0,12,0,"l.",null,null,5.78,12,0,0,0,null,0,0]
[null,"22.",null,null,null,0,null,null,0,14,0,"l.",null,null,7.1,14,0,0,0,null,0,0]
[null,"23.",null,null,null,0,null,null,0,14,0,"l.",null,null,5.74,14,0,0,0,null,0,0]
[null,"24.",null,null,null,0,null,null,0,12,0,"l.",null,null,6.17,12,0,0,0,null,0,0]
[null,"25.",null,null,null,0,null,null,0,12,0,"l.",null,null,4.92,12,0,0,0,null,0,0]
[null,"26.",null,null,null,0,null,null,0,14,0,"l.",null,null,4.38,14,0,0,0,null,0,0]
[null,"27.",null,null,null,0,null,null,0,20,0,"l.",null,null,10.8,20,0,0,0,null,0,0]
[null,"28.",null,null,null,0,null,null,0,20,0,"l.",null,null,9.69,20,0,0,0,null,0,0]
[null,"29.",null,null,null,0,null,null,0,14,0,"l.",null,null,7.15,14,0,0,0,null,0,0]
[null,"30.",null,null,null,0,null,null,0,24,0,"l.",null,null,16.91,24,0,0,0,null,0,0]
[null,"31.",null,null,null,0,null,null,0,20,0,"l.",null,null,5.9980000000000002,20,0,0,0,null,0,0]
[null,"32.",null,null,null,0,null,null,0,20,0,"l.",null,null,9.69,20,0,0,0,null,0,0]
[null,"33.",null,null,null,0,null,null,0,12,0,"l.",null,null,5.08,12,0,0,0,null,0,0]
[null,"34.",null,null,null,0,null,null,0,18,0,"l.",null,null,4.9000000000000004,18,0,0,0,null,0,0]
[null,"35.",null,null,null,0,null,null,0,24,0,"l.",null,null,11.45,24,0,0,0,null,0,0]
[null,"36.",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(D16:D51)","v":663},null,null,{"$f":"SUM(G16:G51)","v":629},null,null,"Celkom:",{"$f":"SUM(K16:K51)","v":41.6},null,null,null,null,"Celkom:",{"$f":"SUM(Q16:Q51)","v":41.6},{"$f":"SUM(R16:R51)","v":21.976000000000003},{"$f":"SUM(S16:S51)","v":17.5808},null,"Za tovar:",{"$f":"SUM(V16:V51)","v":403.05599999999998}]
[]
[]
[]
[]
[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,"37.",null,null,null,{"$f":"D61+E61","v":0},null,null,{"$f":"D61+E61-G61","v":0},1.1000000000000001,{"$f":"I61*J61","v":0},"ks.",null,null,0.78,{"$f":"J61","v":1.1000000000000001},{"$f":"I61*J61","v":0},{"$f":"(P61-O61)*I61","v":0},{"$f":"R61*0.8","v":0},null,{"$f":"G61","v":0},{"$f":"U61*O61","v":0}]
[null,"38.",null,null,null,{"$f":"D62+E62","v":0},null,null,{"$f":"D62+E62-G62","v":0},2,{"$f":"I62*J62","v":0},"ks.",null,null,0.72599999999999998,{"$f":"J62","v":2},{"$f":"I62*J62","v":0},{"$f":"(P62-O62)*I62","v":0},{"$f":"R62*0.8","v":0},null,{"$f":"G62","v":0},{"$f":"U62*O62","v":0}]
[null,"39.",null,null,null,0,null,null,0,0.9,0,"ks.",null,null,0.52800000000000002,0.9,0,{"$f":"(P63-O63)*I63","v":0},0,null,0,0]
[null,"40.",null,null,null,0,null,null,0,1.1000000000000001,0,"ks.",null,null,0.49,1.1000000000000001,0,0,0,null,0,0]
[null,"41.",null,null,null,0,null,null,0,0.5,0,"ks.",null,null,0.2,0.5,0,0,0,null,0,0]
[null,"42.",null,null,null,0,null,null,0,1.8,0,"ks.",null,null,0.25,1.8,0,0,0,null,0,0]
[null,"43.",null,null,null,0,null,null,0,0.5,0,"ks.",null,null,0.11,0.5,0,0,0,null,0,0]
[null,"44.",null,0,null,0,0,null,0,1.5,0,"l.",null,null,0.23,1.5,0,0,0,null,0,0]
[null,"45.",null,null,null,0,null,null,0,1,0,"ks.",null,null,0.46,1,0,0,0,null,0,0]
[null,"46.",null,null,null,0,null,null,0,3,0,"ks.",null,null,1.1879999999999999,3,0,0,0,null,0,0]
[null,"47.",null,null,null,0,null,null,0,1.1000000000000001,0,"l.",null,null,0.33,1.1000000000000001,0,0,0,null,0,0]
[null,"48.",null,null,null,0,null,null,0,0.8,0,"ks.",null,null,0.32,0.8,0,0,0,null,0,0]
[null,"49.",null,null,null,0,null,null,0,1.1000000000000001,0,"ks.",null,null,0.624,1.1000000000000001,0,0,0,null,0,0]
[null,"50.",null,null,null,0,null,null,0,1.1000000000000001,0,"ks.",null,null,0.504,1.1000000000000001,0,0,0,null,0,0]
[null,"51.",null,null,null,0,null,null,0,1.2,0,"ks.",null,null,0.64,1.2,0,0,0,null,0,0]
[null,"52.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"53.",null,null,null,0,null,null,{"$f":"(D77+E77-G77)/7","v":0},0.5,0,"gr.",null,null,3.4000000000000002E-2,0.5,{"$f":"K77","v":0},0,0,null,0,0]
[null,"54.",null,null,null,0,null,null,0,0.5,0,"ks.",null,null,0.14000000000000001,0.5,0,0,0,null,0,0]
[null,"55.",null,null,null,0,null,null,0,0.5,{"$f":"I79*J79","v":0},"ks.",null,null,5.8000000000000003E-2,0.5,{"$f":"I79*J79","v":0},0,0,null,0,{"$f":"U79*O80","v":0}]
[null,"56.",null,null,null,0,null,null,0,0.1,{"$f":"I80*J80","v":0},"ks.",null,null,3.5999999999999997E-2,0.1,{"$f":"I80*J80","v":0},0,0,null,0,{"$f":"U80*O81","v":0}]
[null,"57.",null,null,null,0,null,null,0,0.05,{"$f":"I81*J81","v":0},"ks.",null,null,0.08,0.05,{"$f":"I81*J81","v":0},0,0,null,0,{"$f":"U81*O82","v":0}]
[null,"58.",null,null,null,0,null,null,0,null,{"$f":"I82*J82","v":0},null,null,null,null,0,{"$f":"I82*J82","v":0},0,0,null,0,{"$f":"U82*O83","v":0}]
[null,"59.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"60.",null,null,null,0,null,null,0,3.2,0,"ks.",null,null,3.04,3.2,0,0,0,null,0,0]
[null,"61.",null,null,null,0,null,null,0,3.3,0,"ks.",null,null,3.3,3.3,0,0,0,null,0,0]
[null,"62.",null,null,null,0,null,null,0,3.4,0,"ks.",null,null,3.32,3.4,0,0,0,null,0,0]
[null,"63.",null,null,null,0,null,null,0,3.6,0,"ks.",null,null,2.95,3.6,0,0,0,null,0,0]
[null,"64.",null,null,null,0,null,null,0,3.3,0,"ks.",null,null,3.04,3.3,0,0,0,null,0,0]
[null,"65.",null,null,null,0,null,null,0,3.2,0,"ks.",null,null,3.04,3.2,0,0,0,null,0,0]
[null,"66.",null,null,null,0,null,null,0,3.1,0,"ks.",null,null,2.94,3.1,0,0,0,null,0,0]
[null,"67.",null,null,null,0,null,null,0,3.2,0,"ks.",null,null,3.04,3.2,0,0,0,null,0,0]
[null,"68.",null,null,null,0,null,null,0,3.1,0,"ks.",null,null,null,3.1,0,0,0,null,0,0]
[null,"69.",null,null,null,0,null,null,0,3.3,0,"ks.",null,null,null,3.3,0,0,0,null,0,0]
[null,"70.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"71.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"72.",null,null,null,0,null,null,0,0.2,0,"ks.",null,null,8.8999999999999996E-2,0.2,0,0,0,null,0,0]
[null,"73.",null,null,null,0,null,null,0,0.5,0,"ks.",null,null,0.17,0.5,0,0,0,null,0,0]
[null,"74.",null,null,null,0,null,null,0,0.1,0,"ks.",null,null,0.04,0.1,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.",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(D61:D101)","v":0},null,null,{"$f":"SUM(G61:G101)","v":0},null,null,"Celkom :",{"$f":"SUM(K61:K101)","v":0},null,null,null,null,"Celkom:",{"$f":"SUM(Q61:Q101)","v":0},{"$f":"SUM(R61:R101)","v":0},{"$f":"SUM(S61:S101)","v":0},null,"Za tovar:",{"$f":"SUM(V61:V101)","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,"78.",null,null,null,{"$f":"D110+E110","v":0},null,null,{"$f":"D110+E110-G110","v":0},1.2,{"$f":"I110*J110","v":0},"ks.",null,null,0.73,{"$f":"J110","v":1.2},{"$f":"I110*J110","v":0},{"$f":"(P110-O110)*I110","v":0},{"$f":"R110*0.8","v":0},null,{"$f":"G110","v":0},{"$f":"U110*O110","v":0}]
[null,"79.",null,null,null,{"$f":"D111+E111","v":0},null,null,{"$f":"D111+E111-G111","v":0},0.6,{"$f":"I111*J111","v":0},"ks.",null,null,0.28999999999999998,{"$f":"J111","v":0.6},{"$f":"I111*J111","v":0},{"$f":"(P111-O111)*I111","v":0},{"$f":"R111*0.8","v":0},null,{"$f":"G111","v":0},{"$f":"U111*O111","v":0}]
[null,"80.",null,null,null,0,null,null,0,0.6,0,"ks.",null,null,0.28000000000000003,0.6,0,{"$f":"(P112-O112)*I112","v":0},0,null,0,0]
[null,"81.",null,null,null,0,null,null,0,1.5,0,"ks.",null,null,0.9,1.5,0,0,0,null,0,0]
[null,"82.",null,null,null,0,null,null,0,0.6,0,"ks.",null,null,0.32,0.6,0,0,0,null,0,0]
[null,"83.",null,null,null,0,null,null,0,0.6,0,"ks.",null,null,0.26,0.6,0,0,0,null,0,0]
[null,"84.",null,null,null,0,null,null,0,0.6,0,"ks.",null,null,0.4,0.6,0,0,0,null,0,0]
[null,"85.",null,null,null,0,null,null,0,null,0,"ks.",null,null,null,0,0,0,0,null,0,0]
[null,"86.",null,null,null,0,null,null,0,0.6,0,"ks.",null,null,0.33,0.6,0,0,0,null,0,0]
[null,"87.",null,null,null,0,null,null,0,0.3,0,"ks.",null,null,0.1,0.3,0,0,0,null,0,0]
[null,"88.",null,null,null,0,null,null,0,0.8,0,"ks.",null,null,0.5,0.8,0,0,0,null,0,0]
[null,"89.",null,null,null,0,null,null,0,2.6,0,"ks.",null,null,1.62,2.6,0,0,0,null,0,0]
[null,"90.",null,null,null,0,null,null,0,1.5,0,"ks.",null,null,0.73,1.5,0,0,0,null,0,0]
[null,"91.",null,null,null,0,null,null,0,0.5,0,"ks.",null,null,0.24,0.5,0,0,0,null,0,0]
[null,"92.",null,null,null,0,null,null,0,0.8,0,"ks.",null,null,0.33,0.8,0,0,0,null,0,0]
[null,"93.",null,null,null,0,null,null,0,0.6,0,"ks.",null,null,0.3,0.6,0,0,0,null,0,0]
[null,"94.",null,null,null,0,null,null,0,0.1,0,"ks.",null,null,5.1999999999999998E-2,0.1,0,0,0,null,0,0]
[null,"95.",null,null,null,0,null,null,0,0.6,0,"ks.",null,null,0.37,0.6,0,0,0,null,0,0]
[null,"96.",null,null,null,0,null,null,0,0.9,0,"ks.",null,null,0.54,0.9,0,0,0,null,0,0]
[null,"97.",null,null,null,0,null,null,0,0.7,0,"ks.",null,null,0.3,0.7,0,0,0,null,0,0]
[null,"98.",null,null,null,0,null,null,0,0.5,0,"ks.",null,null,0.27,0.5,0,0,0,null,0,0]
[null,"99.",null,null,null,0,null,null,0,0.6,0,"ks.",null,null,0.32,0.6,0,0,0,null,0,0]
[null,"100.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"101.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"102.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0,null,0,0]
[null,"103.",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(D110:D135)","v":0},null,null,{"$f":"SUM(G110:G135)","v":0},null,null,"Celkom:",{"$f":"SUM(K110:K135)","v":0},null,null,null,null,"Celkom:",{"$f":"SUM(Q110:Q135)","v":0},{"$f":"SUM(R110:R135)","v":0},{"$f":"SUM(S110:S135)","v":0},null,"Za tovar:",{"$f":"SUM(V110:V135)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tržba","Zisk","Zisk po zdanený"]
[]
[null,null,null,"Stávková:",null,null,null,null,"Strana 1:",{"$f":"K53","v":41.6},null,null,null,null,null,"Strana 1",{"$f":"Q53","v":41.6},{"$f":"R53","v":21.976000000000003},{"$f":"S53","v":17.5808},null,"Strana 1:",{"$f":"V53","v":403.05599999999998}]
[null,null,null,"Refil:",null,null,null,null,"Strana 2:",{"$f":"K103","v":0},null,null,null,null,null,"Strana 2",{"$f":"Q103","v":0},{"$f":"R103","v":0},{"$f":"S103","v":0},null,"Strana 2:",{"$f":"V103","v":0}]
[null,null,null,"Výdavky:",null,null,null,null,"Strana 3:",{"$f":"K137","v":0},null,null,null,null,null,"Strana 3",{"$f":"Q137","v":0},{"$f":"R137","v":0},{"$f":"S137","v":0},null,"Strana 3:",{"$f":"V137","v":0}]
[]
[null,null,null,null,"Spolu:",{"$f":"SUM(F141:F143)","v":0},null,null,"Spolu:",{"$f":"SUM(J141:J143)","v":41.6},null,null,null,null,null,"Spolu:",{"$f":"SUM(Q141:Q143)","v":41.6},{"$f":"SUM(R141:R143)","v":21.976000000000003},{"$f":"SUM(S141:S143)","v":17.5808},null,"Spolu:",{"$f":"SUM(V141:V143)","v":403.05599999999998}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spolu:",{"$f":"Q145-F145","v":41.6}]
[null,null,null,null,null,null,null,null,"Spolu :",{"$f":"J145-F145","v":41.6}]
[]
[null,null,"Zostatok hotovosť:"]
[]
[null,null,"rozdiel:",{"$f":"D150-J148","v":-41.6}]