{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Kalkulačka - zjednodušená","Kalkulačka - detail","Data"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Kalkulačka - zjednodušená","index":0,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[[5,1,5,2],[6,1,6,2]]}
[]
[]
[null,"MINISTERSTVO ZDRAVOTNÍCTVA"]
[null,"Slovenskej republiky"]
[]
[null,"Výpočet cien - Degresívna obchodná prirážka pre lieky"]
[null,"Zjednodušená kalkulačka - mena euro"]
[]
[]
[null,"Model Degresívnej obchodnej prirážky"]
[]
[null,"Prosím, zadajte cenu výrobcu:"]
[]
[null,"Konečná cena v lekárni s 5% DPH:",{"$f":"+ROUND((ROUND(C12,2)+VLOOKUP(VLOOKUP(ROUND(C12,2),Data!$B$2:$H$12,1,1),Data!$B$2:$H$12,6,1)+(ROUND(C12,2)-VLOOKUP(ROUND(C12,2),Data!$B$2:$I$12,8,1))*VLOOKUP(VLOOKUP(ROUND(C12,2),Data!$B$2:$H$12,1,1),Data!$B$2:$H$12,7,1))*(1+0.05),2)","v":0}]
[]
[]
[]
[]
[null,"Prevrátený model Degresívnej obchodnej prirážky"]
[]
[null,"Prosím, zadajte konečnú cenu v lekárni s 5% DPH:"]
[]
[null,"Cena výrobcu:",{"$f":"ROUND((ROUND(C21,2)/(1+0.05)-VLOOKUP(VLOOKUP(ROUND(C21,2)/(1+0.05),Data!$A$2:$H$12,2,1),Data!$B$2:$H$12,6,1)+VLOOKUP(ROUND(C21,2)/(1+0.05),Data!$A$2:$I$12,9,1)*VLOOKUP(VLOOKUP(ROUND(C21,2)/(1+0.05),Data!$A$2:$H$12,2,1),Data!$B$2:$H$12,7,1))/(1+VLOOKUP(VLOOKUP(ROUND(C21,2)/(1+0.05),Data!$A$2:$H$12,2,1),Data!$B$2:$H$12,7,1)),2)","v":0}]

{"sheet":"Kalkulačka - detail","index":1,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[[5,1,5,13],[6,1,6,13],[28,13,29,13],[28,8,28,10],[28,5,28,7],[13,5,13,7],[13,8,13,10],[13,13,14,13],[13,11,13,12],[28,11,28,12]]}
[]
[]
[null,"MINISTERSTVO ZDRAVOTNÍCTVA"]
[null,"Slovenskej republiky"]
[]
[null,"Výpočet cien - Degresívna obchodná prirážka pre lieky"]
[null,"Kalkulačka - mena euro"]
[]
[]
[null,"Model Degresívnej obchodnej prirážky"]
[]
[null,"Prosím, zadajte cenu výrobcu:"]
[]
[null,"Výpočet:",null,null,null,"Distribútor",null,null,"Lekáreň",null,null,"Spolu",null,"Konečná cena \nv lekárni s 5% DPH"]
[{"$nulls":5},"Zákl. suma","Deg. obch. prir.","Predajná cena","Zákl. suma","Deg. obch. prir.","Predajná cena","Zákl. suma","Deg. obch. prir."]
[null,"Pásmo",{"$f":"VLOOKUP(C17,Data!$B$2:$H$12,1,1)","v":0},{"$f":"+VLOOKUP(C17,Data!$B$2:$I$12,8,1)","v":0},{"$f":"+VLOOKUP(C17,Data!$B$2:$J$12,9,1)","v":"od 0,00 do 2,66 euro"},{"$f":"VLOOKUP(C16,Data!$B$2:$H$12,2,1)","v":0},{"$f":"VLOOKUP(C16,Data!$B$2:$H$12,3,1)","v":0.14099999999999999},null,{"$f":"VLOOKUP(C16,Data!$B$2:$H$12,4,1)","v":0},{"$f":"VLOOKUP(C16,Data!$B$2:$H$12,5,1)","v":0.32899999999999996},null,{"$f":"VLOOKUP(C16,Data!$B$2:$H$12,6,1)","v":0},{"$f":"VLOOKUP(C16,Data!$B$2:$H$12,7,1)","v":0.47}]
[null,"Suma",{"$f":"+ROUND(H12,2)","v":0},null,{"$f":"+C17","v":0},{"$f":"+F16","v":0},{"$f":"(C17-D16)*G16","v":0},{"$f":"SUM(E17:G17)","v":0},{"$f":"+I16","v":0},{"$f":"(C17-D16)*J16","v":0},{"$f":"+C17+L17+M17","v":0},{"$f":"+L16","v":0},{"$f":"(C17-D16)*M16","v":0},{"$f":"+ROUND(K17*1.05,2)","v":0}]
[]
[null,"Konečná cena v lekárni s 5% DPH:",{"$nulls":5},{"$f":"+ROUND((C17+VLOOKUP(VLOOKUP(C17,Data!$B$2:$H$12,1,1),Data!$B$2:$H$12,6,1)+(C17-VLOOKUP(C17,Data!$B$2:$I$12,8,1))*VLOOKUP(VLOOKUP(C17,Data!$B$2:$H$12,1,1),Data!$B$2:$H$12,7,1))*(1+0.05),2)","v":0}]
[]
[]
[]
[]
[]
[null,"Prevrátený model Degresívnej obchodnej prirážky"]
[]
[null,"Prosím, zadajte konečnú cenu v lekárni s 5% DPH:"]
[]
[null,"Výpočet:",null,null,null,"Distribútor",null,null,"Lekáreň",null,null,"Spolu",null,"Konečná cena \nv lekárni s 5% DPH"]
[{"$nulls":5},"Zákl. suma","Deg. obch. prir.","Predajná cena","Zákl. suma","Deg. obch. prir.","Predajná cena","Zákl. suma","Deg. obch. prir."]
[null,"Pásmo",{"$f":"VLOOKUP(K32,Data!$A$2:$H$12,2,1)","v":0},{"$f":"+VLOOKUP(K32,Data!$A$2:$I$12,9,1)","v":0},{"$f":"+VLOOKUP(K32,Data!$A$2:$J$12,10,1)","v":"od 0,00 do 2,66 euro"},{"$f":"VLOOKUP(C31,Data!$B$2:$H$12,2,1)","v":0},{"$f":"VLOOKUP(C31,Data!$B$2:$H$12,3,1)","v":0.14099999999999999},null,{"$f":"VLOOKUP(C31,Data!$B$2:$H$12,4,1)","v":0},{"$f":"VLOOKUP(C31,Data!$B$2:$H$12,5,1)","v":0.32899999999999996},null,{"$f":"VLOOKUP(C31,Data!$B$2:$H$12,6,1)","v":0},{"$f":"VLOOKUP(C31,Data!$B$2:$H$12,7,1)","v":0.47}]
[null,"Suma",{"$f":"ROUND((K32-L31+D31*M31)/(1+M31),2)","v":0},null,{"$f":"+C32","v":0},{"$f":"+F31","v":0},{"$f":"(C32-D31)*G31","v":0},{"$f":"SUM(E32:G32)","v":0},{"$f":"+I31","v":0},{"$f":"(C32-D31)*J31","v":0},{"$f":"+N32/1.05","v":0},{"$f":"+L31","v":0},{"$f":"(C32-D31)*M31","v":0},{"$f":"+ROUND(H27,2)","v":0}]
[]
[null,"Cena výrobcu:",{"$nulls":5},{"$f":"ROUND((N32/(1+0.05)-VLOOKUP(VLOOKUP(N32/(1+0.05),Data!$A$2:$H$12,2,1),Data!$B$2:$H$12,6,1)+VLOOKUP(N32/(1+0.05),Data!$A$2:$I$12,9,1)*VLOOKUP(VLOOKUP(N32/(1+0.05),Data!$A$2:$H$12,2,1),Data!$B$2:$H$12,7,1))/(1+VLOOKUP(VLOOKUP(N32/(1+0.05),Data!$A$2:$H$12,2,1),Data!$B$2:$H$12,7,1)),2)","v":0}]

{"sheet":"Data","index":2,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":true,"merged":[[0,2,0,3],[0,4,0,5],[0,6,0,7]]}
["Price limit KC bez DPH","Price limit CIP","distributors",null,"pharmacies",null,"Total"]
[0,0,0,0.14099999999999999,0,0.32899999999999996,{"$f":"+C2+E2","v":0},0.47,0,"od 0,00 do 2,66 euro","od 0,00 do 80,00 Sk"]
[3.91,2.6601000000000004,0.37,0.111,0.87,0.25900000000000001,1.24,0.37,2.66,"od 2,67 do 5,31 euro","od 80,01 do 160,00 Sk"]
[7.53,5.3100999999999994,0.67,8.1000000000000003E-2,1.56,0.18899999999999997,2.23,0.26999999999999996,5.31,"od 5,32 do 7,97 euro","od 160,01 do 240,00 Sk"]
[10.92,7.9700999999999995,0.88,5.0999999999999997E-2,2.06,0.11900000000000001,2.94,0.17,7.97,"od 7,98 do 13,28 euro","od 240,01 do 400,00 Sk"]
[17.12,13.280099999999999,1.1599999999999999,3.3000000000000002E-2,2.7,7.6999999999999999E-2,3.8600000000000003,0.11,13.28,"od 13,29 do 23,24 euro","od 400,01 do 700,00 Sk"]
[28.2,23.240099999999998,1.48,2.7E-2,3.46,6.3E-2,4.9399999999999995,0.09,23.24,"od 23,25 do 39,83 euro","od 700,01 do 1200,00 Sk"]
[46.26,39.830100000000002,1.93,2.4E-2,4.51,5.5999999999999994E-2,6.4399999999999995,7.9999999999999988E-2,39.83,"od 39,84 do 73,03 euro","od 1200,01 do 2200,00 Sk"]
[82.13,73.030100000000004,2.73,2.2499999999999999E-2,6.37,5.2499999999999998E-2,9.1,7.4999999999999997E-2,73.03,"od 73,04 do 165,97 euro","od 2200,01 do 5000,00 Sk"]
[182.04,165.9701,4.82,2.1000000000000001E-2,11.25,4.9000000000000002E-2,16.07,7.0000000000000007E-2,165.97,"od 165,98 do 331,94 euro","od 5000,01 do 10 000,00 Sk"]
[359.63,331.94009999999997,8.31,1.95E-2,19.38,4.5499999999999999E-2,27.689999999999998,6.5000000000000002E-2,331.94,"od 331,95 do 663,88 euro","od 10 000,01 do 20 000,00 Sk"]
[713.15,663.88009999999997,14.78,1.7999999999999999E-2,34.479999999999997,4.2000000000000003E-2,49.26,0.06,663.88,"viac ako 663,88 euro","viac ako 20 000,00 Sk"]
[]
[1,2,3,4,5,6,7,8,9,10]
[]
["Price limit CIP"]
[0,"od 0,00 do 2,66 euro"]
[2.66,"od 2,67 do 5,31 euro"]
[5.31,"od 5,32 do 7,97 euro"]
[7.97,"od 7,98 do 13,28 euro"]
[13.28,"od 13,29 do 23,24 euro"]
[23.24,"od 23,25 do 39,83 euro"]
[39.83,"od 39,84 do 73,03 euro"]
[73.03,"od 73,04 do 165,97 euro"]
[165.97,"od 165,98 do 331,94 euro"]
[331.94,"od 331,95 do 663,88 euro"]
[663.88,"viac ako 663,88 euro"]