{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Originál","Sumár","1","2","3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":142,"n_cols":19,"rows_kept":142,"cut":false,"hidden":false,"merged":[[141,3,141,4],[4,1,5,1],[4,2,5,2],[51,1,52,1],[51,2,52,2],[98,1,99,1],[98,2,99,2],[98,3,99,3],[98,4,99,4],[132,3,132,4],[51,3,52,3],[4,18,5,18],[0,2,0,9],[4,3,5,3],[4,4,5,4],[4,6,5,6],[4,5,5,5],[4,10,5,10],[4,14,5,14],[4,15,5,15],[4,16,5,16],[4,17,5,17],[0,14,0,17],[1,8,1,9],[1,15,1,16],[4,8,5,8],[4,9,5,9],[51,9,52,9],[51,10,52,10],[51,4,52,4],[51,5,52,5],[51,6,52,6],[51,8,52,8],[51,14,52,14],[51,15,52,15],[51,16,52,16],[129,14,130,14],[129,15,130,15],[129,16,130,16],[98,5,99,5],[129,17,130,17],[129,18,130,18],[133,3,133,4],[51,17,52,17],[51,18,52,18],[98,6,99,6],[98,8,99,8],[98,9,99,9],[98,10,99,10],[98,14,99,14],[98,15,99,15],[98,16,99,16],[98,17,99,17],[98,18,99,18],[131,3,131,4]]}
[null,null,"Vyučtovanie výčapu",null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2016-12-13"},null,null,null,"Denný sumár",null,null,null,{"$f":"TODAY()","v":"2016-12-13"}]
[null,null,null,null,null,null,"Meno:",null,null,null,null,null,null,null,"Meno:",{"$f":"I2","v":0}]
[null,null,null,null,null,null,"Dátum:",null,null,"/2016",null,null,null,null,"Dátum:",{"$f":"I3","v":0},"/2016"]
[null,null,"Strana 1:","Strana 1:",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 €",null,null,null,"Nákupná cena","Predajná cena","Tržba","Zisk","Zisk po zdanení"]
[]
[null,"1.",null,null,null,{"$f":"D7+E7","v":0},null,null,{"$f":"D7+E7-G7","v":0},null,{"$f":"I7*J7","v":0},null,null,null,1,{"$f":"J7","v":0},{"$f":"I7*J7","v":0},{"$f":"(P7-O7)*I7","v":0},{"$f":"R7*0.8","v":0}]
[null,"2.",null,null,null,{"$f":"D8+E8","v":0},null,null,{"$f":"D8+E8-G8","v":0},null,{"$f":"I8*J8","v":0},null,null,null,1,{"$f":"J8","v":0},{"$f":"I8*J8","v":0},{"$f":"(P8-O8)*I8","v":0},{"$f":"R8*0.8","v":0}]
[null,"3.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,{"$f":"(P9-O9)*I9","v":0},0]
[null,"4.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"5.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"6.",null,null,null,0,null,null,0,null,0,null,null,null,0.52800000000000002,0,0,0,0]
[null,"7.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"8.",null,null,null,0,null,null,0,null,0,null,null,null,0.49,0,0,0,0]
[null,"9.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"10.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"11.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"12.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"13.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"14.",null,null,null,0,null,null,0,null,0,null,null,null,0.49199999999999999,0,0,0,0]
[null,"15.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"16.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"17.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"18.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"19.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"20.",null,null,null,0,null,null,0,null,0,null,null,null,6.3259999999999996,0,0,0,0]
[null,"21.",null,null,null,0,null,null,0,null,0,null,null,null,6.5430000000000001,0,0,0,0]
[null,"22.",null,null,null,0,null,null,0,null,0,null,null,null,5.65,0,0,0,0]
[null,"23.",null,null,null,0,null,null,0,null,0,null,null,null,5.89,0,0,0,0]
[null,"24.",null,null,null,0,null,null,0,null,0,null,null,null,6.96,0,0,0,0]
[null,"25.",null,null,null,0,null,null,0,null,0,null,null,null,11.28,0,0,0,0]
[null,"26.",null,null,null,0,null,null,0,null,0,null,null,null,6.5449999999999999,0,0,0,0]
[null,"27.",null,null,null,0,null,null,0,null,0,null,null,null,5.2,0,0,0,0]
[null,"28.",null,null,null,0,null,null,0,null,0,null,null,null,6.23,0,0,0,0]
[null,"29.",null,null,null,0,null,null,0,null,0,null,null,null,10.914,0,0,0,0]
[null,"30.",null,null,null,0,null,null,0,null,0,null,null,null,9.49,0,0,0,0]
[null,"31.",null,null,null,0,null,null,0,null,0,null,null,null,6.96,0,0,0,0]
[null,"32.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"33.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"34.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"35.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"36.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"37.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"38.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"39.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"40.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"41.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"42.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,"Celkom:",{"$f":"SUM(K7:K48)","v":0},null,null,null,null,"Celkom:",{"$f":"SUM(Q7:Q48)","v":0},{"$f":"SUM(R7:R48)","v":0},{"$f":"SUM(S7:S48)","v":0}]
[null,null,"Strana 2:","Strana 2:",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,"43.",null,null,null,{"$f":"D54+E54","v":0},null,null,{"$f":"D54+E54-G54","v":0},null,{"$f":"I54*J54","v":0},null,null,null,null,{"$f":"J54","v":0},{"$f":"I54*J54","v":0},{"$f":"(P54-O54)*I54","v":0},{"$f":"R54*0.8","v":0}]
[null,"44.",null,null,null,{"$f":"D55+E55","v":0},null,null,{"$f":"D55+E55-G55","v":0},null,{"$f":"I55*J55","v":0},null,null,null,null,{"$f":"J55","v":0},{"$f":"I55*J55","v":0},{"$f":"(P55-O55)*I55","v":0},{"$f":"R55*0.8","v":0}]
[null,"45.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,{"$f":"(P56-O56)*I56","v":0},0]
[null,"46.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"47.",null,null,null,0,null,null,0,null,0,null,null,null,0.20399999999999999,0,0,0,0]
[null,"48.",null,null,null,0,null,null,0,null,0,null,null,null,0.36,0,0,0,0]
[null,"49.",null,null,null,0,null,null,0,null,0,null,null,null,0.1113,0,0,0,0]
[null,"50.",null,null,null,0,0,null,0,null,0,null,null,null,0.308,0,0,0,0]
[null,"51.",null,null,null,0,null,null,0,null,0,null,null,null,0.372,0,0,0,0]
[null,"52.",null,null,null,0,null,null,0,null,0,null,null,null,0.372,0,0,0,0]
[null,"53.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"54.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"55.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"56.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"57.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"58.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"59.",null,null,null,0,0,null,0,null,{"$f":"(I70/7)*J70","v":0},null,null,null,4.9000000000000004,0,{"$f":"K70","v":0},0,0]
[null,"60.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,{"$f":"(P71-O71)*I71","v":0},0]
[null,"61.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,{"$f":"(P72-O72)*I72","v":0},0]
[null,"62.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"63.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"64.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"65.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"66.",null,null,null,0,null,null,0,null,0,null,null,null,2.96,0,0,0,0]
[null,"67.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"68.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"69.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"70.",null,null,null,0,null,null,0,null,0,null,null,null,2.9620000000000002,0,0,0,0]
[null,"71.",null,null,null,0,null,null,0,null,0,null,null,null,2.96,0,0,0,0]
[null,"72.",null,null,null,0,null,null,0,null,0,null,null,null,2.8660000000000001,0,0,0,0]
[null,"73.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"74.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"75.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"76.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"77.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"78.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"79.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"80.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"81.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"82.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"83.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"84.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,"Celkom :",{"$f":"SUM(K54:K95)","v":0},null,null,null,null,"Celkom:",{"$f":"SUM(Q54:Q95)","v":0},{"$f":"SUM(R54:R95)","v":0},{"$f":"SUM(S54:S95)","v":0}]
[null,null,"Strana 3:","Strana 3:",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,"85.",null,null,null,{"$f":"D101+E101","v":0},null,null,{"$f":"D101+E101-G101","v":0},null,{"$f":"I101*J101","v":0},null,null,null,null,{"$f":"J101","v":0},{"$f":"I101*J101","v":0},{"$f":"(P101-O101)*I101","v":0},{"$f":"R101*0.8","v":0}]
[null,"86.",null,null,null,{"$f":"D102+E102","v":0},null,null,{"$f":"D102+E102-G102","v":0},null,{"$f":"I102*J102","v":0},null,null,null,null,{"$f":"J102","v":0},{"$f":"I102*J102","v":0},{"$f":"(P102-O102)*I102","v":0},{"$f":"R102*0.8","v":0}]
[null,"87.",null,null,null,0,null,null,0,null,0,null,null,null,0.307,0,0,{"$f":"(P103-O103)*I103","v":0},0]
[null,"88.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"89.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"90.",null,null,null,0,null,null,0,null,0,null,null,null,0.27,0,0,0,0]
[null,"91.",null,null,null,0,null,null,0,null,0,null,null,null,0.35,0,0,0,0]
[null,"92.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"93.",null,null,null,0,null,null,0,null,0,null,null,null,0.33650000000000002,0,0,0,0]
[null,"94.",null,null,null,0,null,null,0,null,0,null,null,null,0.33600000000000002,0,0,0,0]
[null,"95.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"96.",null,null,null,0,null,null,0,null,0,null,null,null,0.34399999999999997,0,0,0,0]
[null,"97.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"98.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"99.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"100.",null,null,null,0,null,null,0,null,0,null,null,null,0.435,0,0,0,0]
[null,"101.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"102.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"103.",null,null,null,0,null,null,0,null,0,null,null,null,0.374,0,0,0,0]
[null,"104.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"105.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"106.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"107.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"108.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"109.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"110.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,"Celkom:",{"$f":"SUM(K101:K126)","v":0},null,null,null,null,"Celkom:",{"$f":"SUM(Q101:Q126)","v":0},{"$f":"SUM(R101:R126)","v":0},{"$f":"SUM(S101:S126)","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":"K50","v":0},null,null,null,null,null,"Strana 1",{"$f":"Q50","v":0},{"$f":"R50","v":0},{"$f":"S50","v":0}]
[null,null,null,"Refil:",null,null,null,null,"Strana 2:",{"$f":"K97","v":0},null,null,null,null,null,"Strana 2",{"$f":"Q97","v":0},{"$f":"R97","v":0},{"$f":"S97","v":0}]
[null,null,null,"Výdavky:",null,null,null,null,"Strana 3:",{"$f":"K128","v":0},null,null,null,null,null,"Strana 3",{"$f":"Q128","v":0},{"$f":"R128","v":0},{"$f":"S128","v":0}]
[]
[null,null,null,null,"Spolu:",{"$f":"SUM(F132:F134)","v":0},null,null,"Spolu:",{"$f":"SUM(J132:J134)","v":0},null,null,null,null,null,"Spolu:",{"$f":"SUM(Q132+Q134)","v":0},{"$f":"SUM(R132+R134)","v":0},{"$f":"SUM(S132+S134)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,"Spolu :",{"$f":"J136-F136","v":0}]
[]
[]
[null,null,"vystavené dňa:",{"$f":"TODAY()","v":"2016-12-13"}]

{"sheet":"Sumár","index":1,"n_rows":142,"n_cols":19,"rows_kept":142,"cut":false,"hidden":false,"merged":[[131,3,131,4],[132,3,132,4],[141,3,141,4],[98,16,99,16],[98,17,99,17],[98,8,99,8],[98,9,99,9],[98,10,99,10],[133,3,133,4],[98,18,99,18],[129,14,130,14],[129,15,130,15],[129,16,130,16],[129,17,130,17],[129,18,130,18],[98,14,99,14],[98,15,99,15],[51,18,52,18],[51,17,52,17],[51,8,52,8],[51,9,52,9],[51,14,52,14],[51,15,52,15],[51,16,52,16],[51,10,52,10],[0,2,0,9],[1,8,1,9],[1,15,1,16],[4,10,5,10],[4,18,5,18],[4,16,5,16],[4,17,5,17],[4,8,5,8],[4,9,5,9],[4,14,5,14],[4,15,5,15],[0,14,0,17],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,6,5,6],[4,5,5,5],[51,1,52,1],[51,6,52,6],[98,1,99,1],[98,2,99,2],[98,3,99,3],[98,4,99,4],[98,5,99,5],[98,6,99,6],[51,5,52,5],[51,2,52,2],[51,3,52,3],[51,4,52,4]]}
[null,null,"Vyučtovanie výčapu",null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2016-12-13"},null,null,null,"Denný sumár",null,null,null,{"$f":"TODAY()","v":"2016-12-13"}]
[null,null,null,null,null,null,"Meno:",null,null,null,null,null,null,null,"Meno:",{"$f":"I2","v":0}]
[null,null,null,null,null,null,"Dátum:",null,null,"/2016",null,null,null,null,"Dátum:",{"$f":"I3","v":0},"/2016"]
[null,null,"Strana 1:","Strana 1:",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 €",null,null,null,"Nákupná cena","Predajná cena","Tržba","Zisk","Zisk po zdanení"]
[]
[null,"1.",null,null,null,{"$f":"D7+E7","v":0},0,0,{"$f":"D7+E7-G7","v":0},null,{"$f":"I7*J7","v":0},null,null,null,1,{"$f":"J7","v":0},{"$f":"I7*J7","v":0},{"$f":"(P7-O7)*I7","v":0},{"$f":"R7*0.8","v":0}]
[null,"2.",null,null,null,{"$f":"D8+E8","v":0},0,0,{"$f":"D8+E8-G8","v":0},null,{"$f":"I8*J8","v":0},null,null,null,1,{"$f":"J8","v":0},{"$f":"I8*J8","v":0},{"$f":"(P8-O8)*I8","v":0},{"$f":"R8*0.8","v":0}]
[null,"3.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,{"$f":"(P9-O9)*I9","v":0},0]
[null,"4.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"5.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"6.",null,null,null,0,0,0,0,null,0,null,null,null,0.52800000000000002,0,0,0,0]
[null,"7.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"8.",null,null,null,0,0,0,0,null,0,null,null,null,0.49,0,0,0,0]
[null,"9.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"10.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"11.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"12.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"13.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"14.",null,null,null,0,0,0,0,null,0,null,null,null,0.49199999999999999,0,0,0,0]
[null,"15.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"16.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"17.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"18.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"19.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"20.",null,null,null,0,0,0,0,null,0,null,null,null,6.3259999999999996,0,0,0,0]
[null,"21.",null,null,null,0,0,0,0,null,0,null,null,null,6.5430000000000001,0,0,0,0]
[null,"22.",null,null,null,0,0,0,0,null,0,null,null,null,5.65,0,0,0,0]
[null,"23.",null,null,null,0,0,0,0,null,0,null,null,null,5.89,0,0,0,0]
[null,"24.",null,null,null,0,0,0,0,null,0,null,null,null,6.96,0,0,0,0]
[null,"25.",null,null,null,0,0,0,0,null,0,null,null,null,11.28,0,0,0,0]
[null,"26.",null,null,null,0,0,0,0,null,0,null,null,null,6.5449999999999999,0,0,0,0]
[null,"27.",null,null,null,0,0,0,0,null,0,null,null,null,5.2,0,0,0,0]
[null,"28.",null,null,null,0,0,0,0,null,0,null,null,null,6.23,0,0,0,0]
[null,"29.",null,null,null,0,0,0,0,null,0,null,null,null,10.914,0,0,0,0]
[null,"30.",null,null,null,0,0,0,0,null,0,null,null,null,9.49,0,0,0,0]
[null,"31.",null,null,null,0,0,0,0,null,0,null,null,null,6.96,0,0,0,0]
[null,"32.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"33.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"34.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"35.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"36.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"37.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"38.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"39.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"40.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"41.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"42.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,"Celkom:",{"$f":"SUM(K7:K48)","v":0},null,null,null,null,"Celkom:",{"$f":"SUM(Q7:Q48)","v":0},{"$f":"SUM(R7:R48)","v":0},{"$f":"SUM(S7:S48)","v":0}]
[null,null,"Strana 2:","Strana 2:",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,"43.",null,null,null,{"$f":"D54+E54","v":0},0,0,{"$f":"D54+E54-G54","v":0},null,{"$f":"I54*J54","v":0},null,null,null,null,{"$f":"J54","v":0},{"$f":"I54*J54","v":0},{"$f":"(P54-O54)*I54","v":0},{"$f":"R54*0.8","v":0}]
[null,"44.",null,null,null,{"$f":"D55+E55","v":0},0,0,{"$f":"D55+E55-G55","v":0},null,{"$f":"I55*J55","v":0},null,null,null,null,{"$f":"J55","v":0},{"$f":"I55*J55","v":0},{"$f":"(P55-O55)*I55","v":0},{"$f":"R55*0.8","v":0}]
[null,"45.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,{"$f":"(P56-O56)*I56","v":0},0]
[null,"46.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"47.",null,null,null,0,0,0,0,null,0,null,null,null,0.20399999999999999,0,0,0,0]
[null,"48.",null,null,null,0,0,0,0,null,0,null,null,null,0.36,0,0,0,0]
[null,"49.",null,null,null,0,0,0,0,null,0,null,null,null,0.1113,0,0,0,0]
[null,"50.",null,null,null,0,0,0,0,null,0,null,null,null,0.308,0,0,0,0]
[null,"51.",null,null,null,0,0,0,0,null,0,null,null,null,0.372,0,0,0,0]
[null,"52.",null,null,null,0,0,0,0,null,0,null,null,null,0.372,0,0,0,0]
[null,"53.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"54.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"55.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"56.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"57.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"58.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"59.",null,null,null,0,0,0,0,null,{"$f":"(I70/7)*J70","v":0},null,null,null,4.9000000000000004,0,{"$f":"K70","v":0},0,0]
[null,"60.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,{"$f":"(P71-O71)*I71","v":0},0]
[null,"61.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,{"$f":"(P72-O72)*I72","v":0},0]
[null,"62.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"63.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"64.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"65.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"66.",null,null,null,0,0,0,0,null,0,null,null,null,2.96,0,0,0,0]
[null,"67.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"68.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"69.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"70.",null,null,null,0,0,0,0,null,0,null,null,null,2.9620000000000002,0,0,0,0]
[null,"71.",null,null,null,0,0,0,0,null,0,null,null,null,2.96,0,0,0,0]
[null,"72.",null,null,null,0,0,0,0,null,0,null,null,null,2.8660000000000001,0,0,0,0]
[null,"73.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"74.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"75.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"76.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"77.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"78.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"79.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"80.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"81.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"82.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"83.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"84.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,"Celkom :",{"$f":"SUM(K54:K95)","v":0},null,null,null,null,"Celkom:",{"$f":"SUM(Q54:Q95)","v":0},{"$f":"SUM(R54:R95)","v":0},{"$f":"SUM(S54:S95)","v":0}]
[null,null,"Strana 3:","Strana 3:",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,"85.",null,null,null,{"$f":"D101+E101","v":0},null,null,{"$f":"D101+E101-G101","v":0},null,{"$f":"I101*J101","v":0},null,null,null,null,{"$f":"J101","v":0},{"$f":"I101*J101","v":0},{"$f":"(P101-O101)*I101","v":0},{"$f":"R101*0.8","v":0}]
[null,"86.",null,null,null,{"$f":"D102+E102","v":0},null,null,{"$f":"D102+E102-G102","v":0},null,{"$f":"I102*J102","v":0},null,null,null,null,{"$f":"J102","v":0},{"$f":"I102*J102","v":0},{"$f":"(P102-O102)*I102","v":0},{"$f":"R102*0.8","v":0}]
[null,"87.",null,null,null,0,0,0,0,null,0,null,null,null,0.307,0,0,{"$f":"(P103-O103)*I103","v":0},0]
[null,"88.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"89.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"90.",null,null,null,0,0,0,0,null,0,null,null,null,0.27,0,0,0,0]
[null,"91.",null,null,null,0,0,0,0,null,0,null,null,null,0.35,0,0,0,0]
[null,"92.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"93.",null,null,null,0,0,0,0,null,0,null,null,null,0.33650000000000002,0,0,0,0]
[null,"94.",null,null,null,0,0,0,0,null,0,null,null,null,0.33600000000000002,0,0,0,0]
[null,"95.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"96.",null,null,null,0,0,0,0,null,0,null,null,null,0.34399999999999997,0,0,0,0]
[null,"97.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"98.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"99.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"100.",null,null,null,0,0,0,0,null,0,null,null,null,0.435,0,0,0,0]
[null,"101.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"102.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"103.",null,null,null,0,0,0,0,null,0,null,null,null,0.374,0,0,0,0]
[null,"104.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"105.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"106.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"107.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"108.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"109.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,"110.",null,null,null,0,0,0,0,null,0,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0,null,"Celkom:",{"$f":"SUM(K101:K126)","v":0},null,null,null,null,"Celkom:",{"$f":"SUM(Q101:Q126)","v":0},{"$f":"SUM(R101:R126)","v":0},{"$f":"SUM(S101:S126)","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":"K50","v":0},null,null,null,null,null,"Strana 1",{"$f":"Q50","v":0},{"$f":"R50","v":0},{"$f":"S50","v":0}]
[null,null,null,"Refil:",null,null,null,null,"Strana 2:",{"$f":"K97","v":0},null,null,null,null,null,"Strana 2",{"$f":"Q97","v":0},{"$f":"R97","v":0},{"$f":"S97","v":0}]
[null,null,null,"Výdavky:",null,null,null,null,"Strana 3:",{"$f":"K128","v":0},null,null,null,null,null,"Strana 3",{"$f":"Q128","v":0},{"$f":"R128","v":0},{"$f":"S128","v":0}]
[]
[null,null,null,null,"Spolu:",{"$f":"SUM(F132:F134)","v":0},null,null,"Spolu:",{"$f":"SUM(J132:J134)","v":0},null,null,null,null,null,"Spolu:",{"$f":"SUM(Q132+Q134)","v":0},{"$f":"SUM(R132+R134)","v":0},{"$f":"SUM(S132+S134)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,"Spolu :",{"$f":"J136-F136","v":0}]
[]
[]
[null,null,"vystavené dňa:",{"$f":"TODAY()","v":"2016-12-13"}]

{"sheet":"1","index":2,"n_rows":142,"n_cols":19,"rows_kept":142,"cut":false,"hidden":false,"merged":[[129,14,130,14],[129,15,130,15],[129,16,130,16],[129,17,130,17],[129,18,130,18],[98,14,99,14],[98,15,99,15],[98,16,99,16],[98,17,99,17],[98,18,99,18],[98,5,99,5],[98,6,99,6],[98,8,99,8],[98,9,99,9],[98,10,99,10],[51,18,52,18],[51,6,52,6],[51,8,52,8],[51,9,52,9],[51,14,52,14],[51,15,52,15],[51,16,52,16],[51,17,52,17],[51,10,52,10],[4,18,5,18],[4,8,5,8],[4,9,5,9],[4,14,5,14],[4,15,5,15],[4,16,5,16],[4,17,5,17],[4,6,5,6],[4,5,5,5],[0,2,0,9],[1,8,1,9],[1,15,1,16],[4,10,5,10],[0,14,0,17],[51,5,52,5],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[133,3,133,4],[131,3,131,4],[132,3,132,4],[141,3,141,4],[51,1,52,1],[51,2,52,2],[51,3,52,3],[51,4,52,4],[98,1,99,1],[98,2,99,2],[98,3,99,3],[98,4,99,4]]}
[null,null,"Vyučtovanie výčapu",null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2016-12-13"},null,null,null,"Denný sumár",null,null,null,{"$f":"TODAY()","v":"2016-12-13"}]
[null,null,null,null,null,null,"Meno:",null,null,null,null,null,null,null,"Meno:",{"$f":"I2","v":0}]
[null,null,null,null,null,null,"Dátum:",null,null,"/2016",null,null,null,null,"Dátum:",{"$f":"I3","v":0},"/2016"]
[null,null,"Strana 1:","Strana 1:",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 €",null,null,null,"Nákupná cena","Predajná cena","Tržba","Zisk","Zisk po zdanení"]
[]
[null,"1.",null,null,null,{"$f":"D7+E7","v":0},null,null,{"$f":"D7+E7-G7","v":0},null,{"$f":"I7*J7","v":0},null,null,null,1,{"$f":"J7","v":0},{"$f":"I7*J7","v":0},{"$f":"(P7-O7)*I7","v":0},{"$f":"R7*0.8","v":0}]
[null,"2.",null,null,null,{"$f":"D8+E8","v":0},null,null,{"$f":"D8+E8-G8","v":0},null,{"$f":"I8*J8","v":0},null,null,null,1,{"$f":"J8","v":0},{"$f":"I8*J8","v":0},{"$f":"(P8-O8)*I8","v":0},{"$f":"R8*0.8","v":0}]
[null,"3.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,{"$f":"(P9-O9)*I9","v":0},0]
[null,"4.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"5.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"6.",null,null,null,0,null,null,0,null,0,null,null,null,0.52800000000000002,0,0,0,0]
[null,"7.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"8.",null,null,null,0,null,null,0,null,0,null,null,null,0.49,0,0,0,0]
[null,"9.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"10.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"11.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"12.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"13.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"14.",null,null,null,0,null,null,0,null,0,null,null,null,0.49199999999999999,0,0,0,0]
[null,"15.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"16.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"17.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"18.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"19.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"20.",null,null,null,0,null,null,0,null,0,null,null,null,6.3259999999999996,0,0,0,0]
[null,"21.",null,null,null,0,null,null,0,null,0,null,null,null,6.5430000000000001,0,0,0,0]
[null,"22.",null,null,null,0,null,null,0,null,0,null,null,null,5.65,0,0,0,0]
[null,"23.",null,null,null,0,null,null,0,null,0,null,null,null,5.89,0,0,0,0]
[null,"24.",null,null,null,0,null,null,0,null,0,null,null,null,6.96,0,0,0,0]
[null,"25.",null,null,null,0,null,null,0,null,0,null,null,null,11.28,0,0,0,0]
[null,"26.",null,null,null,0,null,null,0,null,0,null,null,null,6.5449999999999999,0,0,0,0]
[null,"27.",null,null,null,0,null,null,0,null,0,null,null,null,5.2,0,0,0,0]
[null,"28.",null,null,null,0,null,null,0,null,0,null,null,null,6.23,0,0,0,0]
[null,"29.",null,null,null,0,null,null,0,null,0,null,null,null,10.914,0,0,0,0]
[null,"30.",null,null,null,0,null,null,0,null,0,null,null,null,9.49,0,0,0,0]
[null,"31.",null,null,null,0,null,null,0,null,0,null,null,null,6.96,0,0,0,0]
[null,"32.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"33.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"34.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"35.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"36.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"37.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"38.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"39.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"40.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"41.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"42.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,"Celkom:",{"$f":"SUM(K7:K48)","v":0},null,null,null,null,"Celkom:",{"$f":"SUM(Q7:Q48)","v":0},{"$f":"SUM(R7:R48)","v":0},{"$f":"SUM(S7:S48)","v":0}]
[null,null,"Strana 2:","Strana 2:",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,"43.",null,null,null,{"$f":"D54+E54","v":0},null,null,{"$f":"D54+E54-G54","v":0},null,{"$f":"I54*J54","v":0},null,null,null,null,{"$f":"J54","v":0},{"$f":"I54*J54","v":0},{"$f":"(P54-O54)*I54","v":0},{"$f":"R54*0.8","v":0}]
[null,"44.",null,null,null,{"$f":"D55+E55","v":0},null,null,{"$f":"D55+E55-G55","v":0},null,{"$f":"I55*J55","v":0},null,null,null,null,{"$f":"J55","v":0},{"$f":"I55*J55","v":0},{"$f":"(P55-O55)*I55","v":0},{"$f":"R55*0.8","v":0}]
[null,"45.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,{"$f":"(P56-O56)*I56","v":0},0]
[null,"46.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"47.",null,null,null,0,null,null,0,null,0,null,null,null,0.20399999999999999,0,0,0,0]
[null,"48.",null,null,null,0,null,null,0,null,0,null,null,null,0.36,0,0,0,0]
[null,"49.",null,null,null,0,null,null,0,null,0,null,null,null,0.1113,0,0,0,0]
[null,"50.",null,null,null,0,0,null,0,null,0,null,null,null,0.308,0,0,0,0]
[null,"51.",null,null,null,0,null,null,0,null,0,null,null,null,0.372,0,0,0,0]
[null,"52.",null,null,null,0,null,null,0,null,0,null,null,null,0.372,0,0,0,0]
[null,"53.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"54.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"55.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"56.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"57.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"58.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"59.",null,null,null,0,0,null,0,null,{"$f":"(I70/7)*J70","v":0},null,null,null,4.9000000000000004,0,{"$f":"K70","v":0},0,0]
[null,"60.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,{"$f":"(P71-O71)*I71","v":0},0]
[null,"61.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,{"$f":"(P72-O72)*I72","v":0},0]
[null,"62.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"63.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"64.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"65.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"66.",null,null,null,0,null,null,0,null,0,null,null,null,2.96,0,0,0,0]
[null,"67.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"68.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"69.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"70.",null,null,null,0,null,null,0,null,0,null,null,null,2.9620000000000002,0,0,0,0]
[null,"71.",null,null,null,0,null,null,0,null,0,null,null,null,2.96,0,0,0,0]
[null,"72.",null,null,null,0,null,null,0,null,0,null,null,null,2.8660000000000001,0,0,0,0]
[null,"73.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"74.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"75.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"76.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"77.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"78.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"79.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"80.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"81.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"82.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"83.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"84.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,"Celkom :",{"$f":"SUM(K54:K95)","v":0},null,null,null,null,"Celkom:",{"$f":"SUM(Q54:Q95)","v":0},{"$f":"SUM(R54:R95)","v":0},{"$f":"SUM(S54:S95)","v":0}]
[null,null,"Strana 3:","Strana 3:",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,"85.",null,null,null,{"$f":"D101+E101","v":0},null,null,{"$f":"D101+E101-G101","v":0},null,{"$f":"I101*J101","v":0},null,null,null,null,{"$f":"J101","v":0},{"$f":"I101*J101","v":0},{"$f":"(P101-O101)*I101","v":0},{"$f":"R101*0.8","v":0}]
[null,"86.",null,null,null,{"$f":"D102+E102","v":0},null,null,{"$f":"D102+E102-G102","v":0},null,{"$f":"I102*J102","v":0},null,null,null,null,{"$f":"J102","v":0},{"$f":"I102*J102","v":0},{"$f":"(P102-O102)*I102","v":0},{"$f":"R102*0.8","v":0}]
[null,"87.",null,null,null,0,null,null,0,null,0,null,null,null,0.307,0,0,{"$f":"(P103-O103)*I103","v":0},0]
[null,"88.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"89.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"90.",null,null,null,0,null,null,0,null,0,null,null,null,0.27,0,0,0,0]
[null,"91.",null,null,null,0,null,null,0,null,0,null,null,null,0.35,0,0,0,0]
[null,"92.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"93.",null,null,null,0,null,null,0,null,0,null,null,null,0.33650000000000002,0,0,0,0]
[null,"94.",null,null,null,0,null,null,0,null,0,null,null,null,0.33600000000000002,0,0,0,0]
[null,"95.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"96.",null,null,null,0,null,null,0,null,0,null,null,null,0.34399999999999997,0,0,0,0]
[null,"97.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"98.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"99.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"100.",null,null,null,0,null,null,0,null,0,null,null,null,0.435,0,0,0,0]
[null,"101.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"102.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"103.",null,null,null,0,null,null,0,null,0,null,null,null,0.374,0,0,0,0]
[null,"104.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"105.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"106.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"107.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"108.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"109.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"110.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,"Celkom:",{"$f":"SUM(K101:K126)","v":0},null,null,null,null,"Celkom:",{"$f":"SUM(Q101:Q126)","v":0},{"$f":"SUM(R101:R126)","v":0},{"$f":"SUM(S101:S126)","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":"K50","v":0},null,null,null,null,null,"Strana 1",{"$f":"Q50","v":0},{"$f":"R50","v":0},{"$f":"S50","v":0}]
[null,null,null,"Refil:",null,null,null,null,"Strana 2:",{"$f":"K97","v":0},null,null,null,null,null,"Strana 2",{"$f":"Q97","v":0},{"$f":"R97","v":0},{"$f":"S97","v":0}]
[null,null,null,"Výdavky:",null,null,null,null,"Strana 3:",{"$f":"K128","v":0},null,null,null,null,null,"Strana 3",{"$f":"Q128","v":0},{"$f":"R128","v":0},{"$f":"S128","v":0}]
[]
[null,null,null,null,"Spolu:",{"$f":"SUM(F132:F134)","v":0},null,null,"Spolu:",{"$f":"SUM(J132:J134)","v":0},null,null,null,null,null,"Spolu:",{"$f":"SUM(Q132+Q134)","v":0},{"$f":"SUM(R132+R134)","v":0},{"$f":"SUM(S132+S134)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,"Spolu :",{"$f":"J136-F136","v":0}]
[]
[]
[null,null,"vystavené dňa:",{"$f":"TODAY()","v":"2016-12-13"}]

{"sheet":"2","index":3,"n_rows":142,"n_cols":19,"rows_kept":142,"cut":false,"hidden":false,"merged":[[131,3,131,4],[132,3,132,4],[133,3,133,4],[141,3,141,4],[98,17,99,17],[98,18,99,18],[129,14,130,14],[129,15,130,15],[129,16,130,16],[129,17,130,17],[129,18,130,18],[98,8,99,8],[98,9,99,9],[98,10,99,10],[98,14,99,14],[98,15,99,15],[98,16,99,16],[98,1,99,1],[98,2,99,2],[98,3,99,3],[98,4,99,4],[98,5,99,5],[98,6,99,6],[51,10,52,10],[51,14,52,14],[51,15,52,15],[51,16,52,16],[51,17,52,17],[51,18,52,18],[4,17,5,17],[4,18,5,18],[51,1,52,1],[51,2,52,2],[51,3,52,3],[51,4,52,4],[51,5,52,5],[51,6,52,6],[51,8,52,8],[51,9,52,9],[4,8,5,8],[4,9,5,9],[4,10,5,10],[4,14,5,14],[4,15,5,15],[4,16,5,16],[0,2,0,9],[0,14,0,17],[1,8,1,9],[1,15,1,16],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6]]}
[null,null,"Vyučtovanie výčapu",null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2016-12-13"},null,null,null,"Denný sumár",null,null,null,{"$f":"TODAY()","v":"2016-12-13"}]
[null,null,null,null,null,null,"Meno:",null,null,null,null,null,null,null,"Meno:",{"$f":"I2","v":0}]
[null,null,null,null,null,null,"Dátum:",null,null,"/2016",null,null,null,null,"Dátum:",{"$f":"I3","v":0},"/2016"]
[null,null,"Strana 1:","Strana 1:",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 €",null,null,null,"Nákupná cena","Predajná cena","Tržba","Zisk","Zisk po zdanení"]
[]
[null,"1.",null,0,50,{"$f":"D7+E7","v":50},null,null,{"$f":"D7+E7-G7","v":50},null,{"$f":"I7*J7","v":0},null,null,null,1,{"$f":"J7","v":0},{"$f":"I7*J7","v":0},{"$f":"(P7-O7)*I7","v":-50},{"$f":"R7*0.8","v":-40}]
[null,"2.",null,0,50,{"$f":"D8+E8","v":50},null,null,{"$f":"D8+E8-G8","v":50},null,{"$f":"I8*J8","v":0},null,null,null,1,{"$f":"J8","v":0},{"$f":"I8*J8","v":0},{"$f":"(P8-O8)*I8","v":-50},{"$f":"R8*0.8","v":-40}]
[null,"3.",null,0,50,50,null,null,50,null,0,null,null,null,null,0,0,{"$f":"(P9-O9)*I9","v":0},0]
[null,"4.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"5.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"6.",null,0,null,0,null,null,0,null,0,null,null,null,0.52800000000000002,0,0,0,0]
[null,"7.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"8.",null,0,null,0,null,null,0,null,0,null,null,null,0.49,0,0,0,0]
[null,"9.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"10.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"11.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"12.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"13.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"14.",null,0,null,0,null,null,0,null,0,null,null,null,0.49199999999999999,0,0,0,0]
[null,"15.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"16.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"17.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"18.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"19.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"20.",null,0,null,0,null,null,0,null,0,null,null,null,6.3259999999999996,0,0,0,0]
[null,"21.",null,0,null,0,null,null,0,null,0,null,null,null,6.5430000000000001,0,0,0,0]
[null,"22.",null,0,null,0,null,null,0,null,0,null,null,null,5.65,0,0,0,0]
[null,"23.",null,0,null,0,null,null,0,null,0,null,null,null,5.89,0,0,0,0]
[null,"24.",null,0,null,0,null,null,0,null,0,null,null,null,6.96,0,0,0,0]
[null,"25.",null,0,null,0,null,null,0,null,0,null,null,null,11.28,0,0,0,0]
[null,"26.",null,0,null,0,null,null,0,null,0,null,null,null,6.5449999999999999,0,0,0,0]
[null,"27.",null,0,null,0,null,null,0,null,0,null,null,null,5.2,0,0,0,0]
[null,"28.",null,0,null,0,null,null,0,null,0,null,null,null,6.23,0,0,0,0]
[null,"29.",null,0,null,0,null,null,0,null,0,null,null,null,10.914,0,0,0,0]
[null,"30.",null,0,null,0,null,null,0,null,0,null,null,null,9.49,0,0,0,0]
[null,"31.",null,0,null,0,null,null,0,null,0,null,null,null,6.96,0,0,0,0]
[null,"32.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"33.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"34.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"35.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"36.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"37.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"38.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"39.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"40.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"41.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"42.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,"Celkom:",{"$f":"SUM(K7:K48)","v":0},null,null,null,null,"Celkom:",{"$f":"SUM(Q7:Q48)","v":0},{"$f":"SUM(R7:R48)","v":-100},{"$f":"SUM(S7:S48)","v":-80}]
[null,null,"Strana 2:","Strana 2:",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,"43.",null,0,null,{"$f":"D54+E54","v":0},null,null,{"$f":"D54+E54-G54","v":0},null,{"$f":"I54*J54","v":0},null,null,null,null,{"$f":"J54","v":0},{"$f":"I54*J54","v":0},{"$f":"(P54-O54)*I54","v":0},{"$f":"R54*0.8","v":0}]
[null,"44.",null,0,null,{"$f":"D55+E55","v":0},null,null,{"$f":"D55+E55-G55","v":0},null,{"$f":"I55*J55","v":0},null,null,null,null,{"$f":"J55","v":0},{"$f":"I55*J55","v":0},{"$f":"(P55-O55)*I55","v":0},{"$f":"R55*0.8","v":0}]
[null,"45.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,{"$f":"(P56-O56)*I56","v":0},0]
[null,"46.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"47.",null,0,null,0,null,null,0,null,0,null,null,null,0.20399999999999999,0,0,0,0]
[null,"48.",null,0,null,0,null,null,0,null,0,null,null,null,0.36,0,0,0,0]
[null,"49.",null,0,null,0,null,null,0,null,0,null,null,null,0.1113,0,0,0,0]
[null,"50.",null,0,null,0,0,null,0,null,0,null,null,null,0.308,0,0,0,0]
[null,"51.",null,0,null,0,null,null,0,null,0,null,null,null,0.372,0,0,0,0]
[null,"52.",null,0,null,0,null,null,0,null,0,null,null,null,0.372,0,0,0,0]
[null,"53.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"54.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"55.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"56.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"57.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"58.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"59.",null,0,null,0,0,null,0,null,{"$f":"(I70/7)*J70","v":0},null,null,null,4.9000000000000004,0,{"$f":"K70","v":0},0,0]
[null,"60.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,{"$f":"(P71-O71)*I71","v":0},0]
[null,"61.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,{"$f":"(P72-O72)*I72","v":0},0]
[null,"62.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"63.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"64.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"65.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"66.",null,0,null,0,null,null,0,null,0,null,null,null,2.96,0,0,0,0]
[null,"67.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"68.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"69.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"70.",null,0,null,0,null,null,0,null,0,null,null,null,2.9620000000000002,0,0,0,0]
[null,"71.",null,0,null,0,null,null,0,null,0,null,null,null,2.96,0,0,0,0]
[null,"72.",null,0,null,0,null,null,0,null,0,null,null,null,2.8660000000000001,0,0,0,0]
[null,"73.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"74.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"75.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"76.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"77.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"78.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"79.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"80.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"81.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"82.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"83.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"84.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,"Celkom :",{"$f":"SUM(K54:K95)","v":0},null,null,null,null,"Celkom:",{"$f":"SUM(Q54:Q95)","v":0},{"$f":"SUM(R54:R95)","v":0},{"$f":"SUM(S54:S95)","v":0}]
[null,null,"Strana 3:","Strana 3:",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,"85.",null,null,null,{"$f":"D101+E101","v":0},null,null,{"$f":"D101+E101-G101","v":0},null,{"$f":"I101*J101","v":0},null,null,null,null,{"$f":"J101","v":0},{"$f":"I101*J101","v":0},{"$f":"(P101-O101)*I101","v":0},{"$f":"R101*0.8","v":0}]
[null,"86.",null,null,null,{"$f":"D102+E102","v":0},null,null,{"$f":"D102+E102-G102","v":0},null,{"$f":"I102*J102","v":0},null,null,null,null,{"$f":"J102","v":0},{"$f":"I102*J102","v":0},{"$f":"(P102-O102)*I102","v":0},{"$f":"R102*0.8","v":0}]
[null,"87.",null,0,null,0,null,null,0,null,0,null,null,null,0.307,0,0,{"$f":"(P103-O103)*I103","v":0},0]
[null,"88.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"89.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"90.",null,0,null,0,null,null,0,null,0,null,null,null,0.27,0,0,0,0]
[null,"91.",null,0,null,0,null,null,0,null,0,null,null,null,0.35,0,0,0,0]
[null,"92.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"93.",null,0,null,0,null,null,0,null,0,null,null,null,0.33650000000000002,0,0,0,0]
[null,"94.",null,0,null,0,null,null,0,null,0,null,null,null,0.33600000000000002,0,0,0,0]
[null,"95.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"96.",null,0,null,0,null,null,0,null,0,null,null,null,0.34399999999999997,0,0,0,0]
[null,"97.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"98.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"99.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"100.",null,0,null,0,null,null,0,null,0,null,null,null,0.435,0,0,0,0]
[null,"101.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"102.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"103.",null,0,null,0,null,null,0,null,0,null,null,null,0.374,0,0,0,0]
[null,"104.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"105.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"106.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"107.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"108.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"109.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"110.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,"Celkom:",{"$f":"SUM(K101:K126)","v":0},null,null,null,null,"Celkom:",{"$f":"SUM(Q101:Q126)","v":0},{"$f":"SUM(R101:R126)","v":0},{"$f":"SUM(S101:S126)","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":"K50","v":0},null,null,null,null,null,"Strana 1",{"$f":"Q50","v":0},{"$f":"R50","v":-100},{"$f":"S50","v":-80}]
[null,null,null,"Refil:",null,null,null,null,"Strana 2:",{"$f":"K97","v":0},null,null,null,null,null,"Strana 2",{"$f":"Q97","v":0},{"$f":"R97","v":0},{"$f":"S97","v":0}]
[null,null,null,"Výdavky:",null,null,null,null,"Strana 3:",{"$f":"K128","v":0},null,null,null,null,null,"Strana 3",{"$f":"Q128","v":0},{"$f":"R128","v":0},{"$f":"S128","v":0}]
[]
[null,null,null,null,"Spolu:",{"$f":"SUM(F132:F134)","v":0},null,null,"Spolu:",{"$f":"SUM(J132:J134)","v":0},null,null,null,null,null,"Spolu:",{"$f":"SUM(Q132+Q134)","v":0},{"$f":"SUM(R132+R134)","v":-100},{"$f":"SUM(S132+S134)","v":-80}]
[]
[]
[null,null,null,null,null,null,null,null,"Spolu :",{"$f":"J136-F136","v":0}]
[]
[]
[null,null,"vystavené dňa:",{"$f":"TODAY()","v":"2016-12-13"}]

{"sheet":"3","index":4,"n_rows":142,"n_cols":19,"rows_kept":142,"cut":false,"hidden":false,"merged":[[131,3,131,4],[132,3,132,4],[133,3,133,4],[141,3,141,4],[98,17,99,17],[98,18,99,18],[129,14,130,14],[129,15,130,15],[129,16,130,16],[129,17,130,17],[129,18,130,18],[98,8,99,8],[98,9,99,9],[98,10,99,10],[98,14,99,14],[98,15,99,15],[98,16,99,16],[98,1,99,1],[98,2,99,2],[98,3,99,3],[98,4,99,4],[98,5,99,5],[98,6,99,6],[51,10,52,10],[51,14,52,14],[51,15,52,15],[51,16,52,16],[51,17,52,17],[51,18,52,18],[4,17,5,17],[4,18,5,18],[51,1,52,1],[51,2,52,2],[51,3,52,3],[51,4,52,4],[51,5,52,5],[51,6,52,6],[51,8,52,8],[51,9,52,9],[4,8,5,8],[4,9,5,9],[4,10,5,10],[4,14,5,14],[4,15,5,15],[4,16,5,16],[0,2,0,9],[0,14,0,17],[1,8,1,9],[1,15,1,16],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6]]}
[null,null,"Vyučtovanie výčapu",null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2016-12-13"},null,null,null,"Denný sumár",null,null,null,{"$f":"TODAY()","v":"2016-12-13"}]
[null,null,null,null,null,null,"Meno:",null,null,null,null,null,null,null,"Meno:",{"$f":"I2","v":0}]
[null,null,null,null,null,null,"Dátum:",null,null,"/2016",null,null,null,null,"Dátum:",{"$f":"I3","v":0},"/2016"]
[null,null,"Strana 1:","Strana 1:",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 €",null,null,null,"Nákupná cena","Predajná cena","Tržba","Zisk","Zisk po zdanení"]
[]
[null,"1.",null,null,null,{"$f":"D7+E7","v":0},null,null,{"$f":"D7+E7-G7","v":0},null,{"$f":"I7*J7","v":0},null,null,null,1,{"$f":"J7","v":0},{"$f":"I7*J7","v":0},{"$f":"(P7-O7)*I7","v":0},{"$f":"R7*0.8","v":0}]
[null,"2.",null,null,null,{"$f":"D8+E8","v":0},null,null,{"$f":"D8+E8-G8","v":0},null,{"$f":"I8*J8","v":0},null,null,null,1,{"$f":"J8","v":0},{"$f":"I8*J8","v":0},{"$f":"(P8-O8)*I8","v":0},{"$f":"R8*0.8","v":0}]
[null,"3.",null,null,null,0,null,null,0,null,0,null,null,null,null,0,0,{"$f":"(P9-O9)*I9","v":0},0]
[null,"4.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"5.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"6.",null,0,null,0,null,null,0,null,0,null,null,null,0.52800000000000002,0,0,0,0]
[null,"7.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"8.",null,0,null,0,null,null,0,null,0,null,null,null,0.49,0,0,0,0]
[null,"9.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"10.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"11.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"12.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"13.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"14.",null,0,null,0,null,null,0,null,0,null,null,null,0.49199999999999999,0,0,0,0]
[null,"15.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"16.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"17.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"18.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"19.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"20.",null,0,null,0,null,null,0,null,0,null,null,null,6.3259999999999996,0,0,0,0]
[null,"21.",null,0,null,0,null,null,0,null,0,null,null,null,6.5430000000000001,0,0,0,0]
[null,"22.",null,0,null,0,null,null,0,null,0,null,null,null,5.65,0,0,0,0]
[null,"23.",null,0,null,0,null,null,0,null,0,null,null,null,5.89,0,0,0,0]
[null,"24.",null,0,null,0,null,null,0,null,0,null,null,null,6.96,0,0,0,0]
[null,"25.",null,0,null,0,null,null,0,null,0,null,null,null,11.28,0,0,0,0]
[null,"26.",null,0,null,0,null,null,0,null,0,null,null,null,6.5449999999999999,0,0,0,0]
[null,"27.",null,0,null,0,null,null,0,null,0,null,null,null,5.2,0,0,0,0]
[null,"28.",null,0,null,0,null,null,0,null,0,null,null,null,6.23,0,0,0,0]
[null,"29.",null,0,null,0,null,null,0,null,0,null,null,null,10.914,0,0,0,0]
[null,"30.",null,0,null,0,null,null,0,null,0,null,null,null,9.49,0,0,0,0]
[null,"31.",null,0,null,0,null,null,0,null,0,null,null,null,6.96,0,0,0,0]
[null,"32.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"33.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"34.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"35.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"36.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"37.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"38.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"39.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"40.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"41.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"42.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,"Celkom:",{"$f":"SUM(K7:K48)","v":0},null,null,null,null,"Celkom:",{"$f":"SUM(Q7:Q48)","v":0},{"$f":"SUM(R7:R48)","v":0},{"$f":"SUM(S7:S48)","v":0}]
[null,null,"Strana 2:","Strana 2:",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,"43.",null,0,null,{"$f":"D54+E54","v":0},null,null,{"$f":"D54+E54-G54","v":0},null,{"$f":"I54*J54","v":0},null,null,null,null,{"$f":"J54","v":0},{"$f":"I54*J54","v":0},{"$f":"(P54-O54)*I54","v":0},{"$f":"R54*0.8","v":0}]
[null,"44.",null,0,null,{"$f":"D55+E55","v":0},null,null,{"$f":"D55+E55-G55","v":0},null,{"$f":"I55*J55","v":0},null,null,null,null,{"$f":"J55","v":0},{"$f":"I55*J55","v":0},{"$f":"(P55-O55)*I55","v":0},{"$f":"R55*0.8","v":0}]
[null,"45.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,{"$f":"(P56-O56)*I56","v":0},0]
[null,"46.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"47.",null,0,null,0,null,null,0,null,0,null,null,null,0.20399999999999999,0,0,0,0]
[null,"48.",null,0,null,0,null,null,0,null,0,null,null,null,0.36,0,0,0,0]
[null,"49.",null,0,null,0,null,null,0,null,0,null,null,null,0.1113,0,0,0,0]
[null,"50.",null,0,null,0,0,null,0,null,0,null,null,null,0.308,0,0,0,0]
[null,"51.",null,0,null,0,null,null,0,null,0,null,null,null,0.372,0,0,0,0]
[null,"52.",null,0,null,0,null,null,0,null,0,null,null,null,0.372,0,0,0,0]
[null,"53.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"54.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"55.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"56.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"57.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"58.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"59.",null,0,null,0,0,null,0,null,{"$f":"(I70/7)*J70","v":0},null,null,null,4.9000000000000004,0,{"$f":"K70","v":0},0,0]
[null,"60.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,{"$f":"(P71-O71)*I71","v":0},0]
[null,"61.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,{"$f":"(P72-O72)*I72","v":0},0]
[null,"62.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"63.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"64.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"65.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"66.",null,0,null,0,null,null,0,null,0,null,null,null,2.96,0,0,0,0]
[null,"67.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"68.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"69.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"70.",null,0,null,0,null,null,0,null,0,null,null,null,2.9620000000000002,0,0,0,0]
[null,"71.",null,0,null,0,null,null,0,null,0,null,null,null,2.96,0,0,0,0]
[null,"72.",null,0,null,0,null,null,0,null,0,null,null,null,2.8660000000000001,0,0,0,0]
[null,"73.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"74.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"75.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"76.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"77.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"78.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"79.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"80.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"81.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"82.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"83.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"84.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,"Celkom :",{"$f":"SUM(K54:K95)","v":0},null,null,null,null,"Celkom:",{"$f":"SUM(Q54:Q95)","v":0},{"$f":"SUM(R54:R95)","v":0},{"$f":"SUM(S54:S95)","v":0}]
[null,null,"Strana 3:","Strana 3:",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,"85.",null,null,null,{"$f":"D101+E101","v":0},null,null,{"$f":"D101+E101-G101","v":0},null,{"$f":"I101*J101","v":0},null,null,null,null,{"$f":"J101","v":0},{"$f":"I101*J101","v":0},{"$f":"(P101-O101)*I101","v":0},{"$f":"R101*0.8","v":0}]
[null,"86.",null,null,null,{"$f":"D102+E102","v":0},null,null,{"$f":"D102+E102-G102","v":0},null,{"$f":"I102*J102","v":0},null,null,null,null,{"$f":"J102","v":0},{"$f":"I102*J102","v":0},{"$f":"(P102-O102)*I102","v":0},{"$f":"R102*0.8","v":0}]
[null,"87.",null,0,null,0,null,null,0,null,0,null,null,null,0.307,0,0,{"$f":"(P103-O103)*I103","v":0},0]
[null,"88.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"89.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"90.",null,0,null,0,null,null,0,null,0,null,null,null,0.27,0,0,0,0]
[null,"91.",null,0,null,0,null,null,0,null,0,null,null,null,0.35,0,0,0,0]
[null,"92.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"93.",null,0,null,0,null,null,0,null,0,null,null,null,0.33650000000000002,0,0,0,0]
[null,"94.",null,0,null,0,null,null,0,null,0,null,null,null,0.33600000000000002,0,0,0,0]
[null,"95.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"96.",null,0,null,0,null,null,0,null,0,null,null,null,0.34399999999999997,0,0,0,0]
[null,"97.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"98.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"99.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"100.",null,0,null,0,null,null,0,null,0,null,null,null,0.435,0,0,0,0]
[null,"101.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"102.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"103.",null,0,null,0,null,null,0,null,0,null,null,null,0.374,0,0,0,0]
[null,"104.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"105.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"106.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"107.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"108.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"109.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[null,"110.",null,0,null,0,null,null,0,null,0,null,null,null,null,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,"Celkom:",{"$f":"SUM(K101:K126)","v":0},null,null,null,null,"Celkom:",{"$f":"SUM(Q101:Q126)","v":0},{"$f":"SUM(R101:R126)","v":0},{"$f":"SUM(S101:S126)","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":"K50","v":0},null,null,null,null,null,"Strana 1",{"$f":"Q50","v":0},{"$f":"R50","v":0},{"$f":"S50","v":0}]
[null,null,null,"Refil:",null,null,null,null,"Strana 2:",{"$f":"K97","v":0},null,null,null,null,null,"Strana 2",{"$f":"Q97","v":0},{"$f":"R97","v":0},{"$f":"S97","v":0}]
[null,null,null,"Výdavky:",null,null,null,null,"Strana 3:",{"$f":"K128","v":0},null,null,null,null,null,"Strana 3",{"$f":"Q128","v":0},{"$f":"R128","v":0},{"$f":"S128","v":0}]
[]
[null,null,null,null,"Spolu:",{"$f":"SUM(F132:F134)","v":0},null,null,"Spolu:",{"$f":"SUM(J132:J134)","v":0},null,null,null,null,null,"Spolu:",{"$f":"SUM(Q132+Q134)","v":0},{"$f":"SUM(R132+R134)","v":0},{"$f":"SUM(S132+S134)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,"Spolu :",{"$f":"J136-F136","v":0}]
[]
[]
[null,null,"vystavené dňa:",{"$f":"TODAY()","v":"2016-12-13"}]