{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["HOME","Objednávky","Výroba","Zamestnanci zoznam","Zamestnanci - Plán hodín ","Zamestnanci - mzdy","Transport","Výpočet ceny","Finančné oddelenie","Graf_Mzdy","Graf_Objednávky","Graf_Transport","Graf_Mzdy_Dealeri","Graf_Mzdy_brigádnici","Graf_Mzdy_výroba","Graf_Náklady","Graf_Príjmy"],"not_rendered":{"charts":17,"images":0,"macros":1,"external_links":0,"defined_names":141,"comments":0,"pivot_tables":1},"unopened":[{"sheet":"Graf_Mzdy","index":9,"reason":"not_a_worksheet"},{"sheet":"Graf_Objednávky","index":10,"reason":"not_a_worksheet"},{"sheet":"Graf_Transport","index":11,"reason":"not_a_worksheet"},{"sheet":"Graf_Mzdy_Dealeri","index":12,"reason":"not_a_worksheet"},{"sheet":"Graf_Mzdy_brigádnici","index":13,"reason":"not_a_worksheet"},{"sheet":"Graf_Mzdy_výroba","index":14,"reason":"not_a_worksheet"},{"sheet":"Graf_Náklady","index":15,"reason":"not_a_worksheet"},{"sheet":"Graf_Príjmy","index":16,"reason":"not_a_worksheet"}],"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":"HOME","index":0,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"EKONOMICKÉ MODELOVANIE V TABUĽKOVOM KALKULÁTORE"]

{"sheet":"Objednávky","index":1,"n_rows":115,"n_cols":15,"rows_kept":115,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Objednávky",null,null,null,null,null,"Objednávky","Produkt"]
[null,"Dátum","Zamestnanec","Produkt","Počet ks",null,null,"Zamestnanec","-","A","B","C","D","E","SPOLU"]
[null,"2011-06-02","Peter Havran","A",2500,null,null,"Roman Sokol",null,7000,3000,3500,1500,4000,19000]
[null,"2011-06-02","Roman Sokol","B",3000,null,null,"Peter Havran",null,7500,8000,3500,null,3500,22500]
[null,"2011-06-03","Anton Herhaj","C",3000,null,null,"Anton Herhaj",null,11000,2000,9000,5000,3500,30500]
[null,"2011-06-03","Roman Sokol","D",1500,null,null,"-"]
[null,"2011-06-05","Peter Havran","E",3500,null,null,"SPOLU",null,25500,13000,16000,6500,11000,72000]
[null,"2011-06-07","Anton Herhaj","A",6000]
[null,"2011-06-08","Roman Sokol","E",4000]
[null,"2011-06-09","Peter Havran","C",3500]
[null,"2011-06-12","Anton Herhaj","B",2000]
[null,"2011-06-13","Roman Sokol","A",5000]
[null,"2011-06-14","Peter Havran","B",4000]
[null,"2011-06-15","Anton Herhaj","D",5000]
[null,"2011-06-17","Roman Sokol","C",3500]
[null,"2011-06-19","Roman Sokol","A",2000]
[null,"2011-06-21","Anton Herhaj","E",3500]
[null,"2011-06-22","Peter Havran","A",5000]
[null,"2011-06-22","Anton Herhaj","A",5000]
[null,"2011-06-23","Peter Havran","B",4000]
[null,"2011-06-27","Anton Herhaj","C",6000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2011-06-02","Peter Havran","A",2500]
[null,"2011-06-02","Roman Sokol ","B",3000]
[null,"2011-06-03","Anton Herhaj","C",3000]
[null,"2011-06-03","Roman Sokol ","D",1500]
[null,"2011-06-05","Peter Havran","E",3500]
[null,"2011-06-07","Anton Herhaj","A",6000]
[null,"2011-06-08","Roman Sokol ","E",3000]
[null,"2011-06-09","Peter Havran","C",3500]
[null,"2011-06-12","Anton Herhaj","B",2000]
[null,"2011-06-13","Roman Sokol ","A",5000]
[null,"2011-06-14","Peter Havran","B",4000]
[null,"2011-06-15","Anton Herhaj","D",5000]
[null,"2011-06-17","Roman Sokol ","C",3500]
[null,"2011-06-19","Roman Sokol ","A",2000]
[null,"2011-06-21","Anton Herhaj","E",3500]
[null,"2011-06-22","Peter Havran","A",5000]
[null,"2011-06-22","Anton Herhaj","A",5000]
[null,"2011-06-23","Peter Havran","B",4000]
[null,"2011-06-27","Anton Herhaj","C",6000]

{"sheet":"Výroba","index":2,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[[20,2,21,3],[0,0,0,1],[11,1,11,3],[11,5,11,7],[20,1,21,1],[12,1,13,1],[16,1,17,1],[16,2,17,2],[16,3,17,3],[12,2,13,2],[12,3,13,3],[2,5,2,10],[2,1,2,2],[21,4,21,6]]}
["Výroba"]
[]
[null,"Materiály",null,null,null,"Produkty"]
[null,"Materiál","Cena za jednotku",null,null,"Produkt","Materiál 1","Materiál 2","Materiál 3","Materiál 4","Materiál 5"]
[null,"Materiál 1",250,null,null,"Produkt A",0.25,0.6,"-",0.15,"-"]
[null,"Materiál 2",300,null,null,"Produkt B",0.3,"-",0.5,"-",0.2]
[null,"Materiál 3",300,null,null,"Produkt C",0.6,0.4]
[null,"Materiál 4",200,null,null,"Produkt D",0.3,"-",0.45,"-",0.25]
[null,"Materiál 5",500,null,null,"Produkt E","-",0.25,0.25,0.3,0.2]
[]
[]
[null,"Fond pracovných hodín",null,null,null,"Časová náročnosť*",null,null,null,"Priestory"]
[null,"Na 1 osobu","RPD","Nadčasy",null,null,null,null,null,20000,"Kč/mesiac"]
[null,null,null,null,null,"Počet kusov celkom",null,{"$f":"GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3)","v":72000}]
[null,"Zamestnanec",160,72,null,"Počet potrebných hodín",null,{"$f":"H14/G18","v":1800},null,"Energie"]
[null,"Brigádnik",80,null,null,null,null,null,null,20,"Kč/hod"]
[null,"Celkom","RPD","Nadčasy"]
[null,"Celkom",null,null,null,"ks/hod",40]
[null,"Zamestnanci",{"$f":"'Zamestnanci - Plán hodín '!I4","v":1600},{"$f":"'Zamestnanci - Plán hodín '!J4","v":167.00000244144042},null,"min/ks",{"$f":"60/G18","v":1.5}]
[null,"Brigádnici",{"$f":"'Zamestnanci - Plán hodín '!I5","v":800},null,null,"*Všetky produkty sú vyrobené za rovnaký čas"]
[null,"SPOLU:",{"$f":"'Zamestnanci - Plán hodín '!I6","v":2567.0000024414403}]
[null,null,null,null,{"$f":"IF(($H$15-$C$21)>=1,\"Potrebné zvýšiť úväzky o\",IF($H$15-$C$21<=-1,\"Potrebné znížit úväzky o\",\"Úväzky sedia\"))","v":"Potrebné znížit úväzky o"},null,null,{"$f":"IF(H15-C21>=1,H15-C21,IF(H15-C21<=-1,C21-H15,\"OK\"))","v":767.0000024414403},{"$f":"IF($H$22=\"OK\",\"\",\"hodín\")","v":"hodín"}]

{"sheet":"Zamestnanci zoznam","index":3,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":false,"merged":[[3,1,3,2],[3,4,3,5],[3,7,3,8],[1,1,1,7]]}
[]
[null,"EKONOMICKÉ MODELOVANIE V TABUĽKOVOM KALKULÁTORE"]
[null,null,null,null,null,null,null,null,null,null,"Počet zamestnancov:"]
[null,"Výroba",null,null,"Predaj",null,null,"Brigádnici",null,null,"Výroba",{"$f":"COUNTA(C6:C15)","v":10}]
[null,null,"Meno a priezvisko",null,null,"Meno a priezvisko",null,null,"Meno a priezvisko",null,"Brigádnici",{"$f":"COUNTA(I6:I15)","v":10}]
[null,"1.","Rudolf Záhora",null,"1.","Peter Havran",null,"1.","Lukáš Trilobit",null,"Predaj",{"$f":"COUNTA(F6:F9)","v":3}]
[null,"2.","Peter Butolický",null,"2.","Roman Sokol",null,"2.","Marián Sergej"]
[null,"3.","Ján Kukumberg",null,"3.","Anton Herhaj",null,"3.","Jakub Cvrlík"]
[null,"4.","Pavel Peniažka",null,null,null,null,"4.","Matúš Sobranec"]
[null,"5.","Miroslav Černý",null,null,null,null,"5.","Erik Sebák"]
[null,"6.","Ján Dobrman",null,null,null,null,"6.","Filip Tučný"]
[null,"7.","Oliver Manera",null,null,null,null,"7.","Andrej Chudý"]
[null,"8.","Samuel Dlhý",null,null,null,null,"8.","Eliáš Široký"]
[null,"9.","Jozef Novák",null,null,null,null,"9.","Edmund Kovalda"]
[null,"10.","Pavol Hurhaj",null,null,null,null,"10.","Stano Truhlár"]

{"sheet":"Zamestnanci - Plán hodín ","index":4,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,6,1,9],[2,6,2,7],[5,6,6,7],[5,8,6,9],[16,5,16,7],[13,6,13,8],[9,6,9,7],[13,1,14,1],[13,2,14,3],[1,1,2,1],[1,2,2,2],[1,3,2,3]]}
[]
[null,"Zamestnanci","Riadna pracovná doba","Nadčasy",null,null,"Fond pracovných hodín"]
[null,null,null,null,null,null,null,null,"RPD","Nadčasy"]
[null,{"$f":"'Zamestnanci zoznam'!C6","v":"Rudolf Záhora"},{"$f":"$I$10","v":160},30.363636807534625,null,null,"Zamestnanci",null,{"$f":"SUM(C4:C13)","v":1600},{"$f":"SUM(D4:D13)","v":167.00000244144042}]
[null,{"$f":"'Zamestnanci zoznam'!C7","v":"Peter Butolický"},160,15.181818403767309,null,null,"Brigádnici",null,{"$f":"SUM(C16:C25)","v":800}]
[null,{"$f":"'Zamestnanci zoznam'!C8","v":"Ján Kukumberg"},160,15.181818403767309,null,null,"Spolu",null,{"$f":"SUM(I4,J4,I5)","v":2567.0000024414403}]
[null,{"$f":"'Zamestnanci zoznam'!C9","v":"Pavel Peniažka"},160,15.181818403767309]
[null,{"$f":"'Zamestnanci zoznam'!C10","v":"Miroslav Černý"},160,15.181818403767309]
[null,{"$f":"'Zamestnanci zoznam'!C11","v":"Ján Dobrman"},160,15.181818403767309,null,null,"Na 1 osobu",null,"RPD","Nadčasy"]
[null,{"$f":"'Zamestnanci zoznam'!C12","v":"Oliver Manera"},160,15.181818403767309,null,null,"Zamestnanec",null,160,72]
[null,{"$f":"'Zamestnanci zoznam'!C13","v":"Samuel Dlhý"},160,15.181818403767309,null,null,"Brigádnik",null,80]
[null,{"$f":"'Zamestnanci zoznam'!C14","v":"Jozef Novák"},160,15.181818403767309,null,null,"Počet zamestnancov",null,null,{"$f":"'Zamestnanci zoznam'!L4","v":10}]
[null,{"$f":"'Zamestnanci zoznam'!C15","v":"Pavol Hurhaj"},160,15.181818403767307,null,null,"Počet brigádnikov",null,null,{"$f":"'Zamestnanci zoznam'!L5","v":10}]
[null,"Brigádnici",null,null,null,null,"Počet potrebných hodín",null,null,{"$f":"Výroba!H15","v":1800}]
[null,null,null,null,null,null,"Pracovné hodiny k dispozícii",null,null,{"$f":"I6","v":2567.0000024414403}]
[null,{"$f":"'Zamestnanci zoznam'!I6","v":"Lukáš Trilobit"},80]
[null,{"$f":"'Zamestnanci zoznam'!I7","v":"Marián Sergej"},80,null,null,{"$f":"IF(($J$14-$J$15)>=1,\"Potrebné zvýšiť úväzky o\",IF($J$14-$J$15<=-1,\"Potrebné znížiť úväzky o\",\"Úväzky sedia\"))","v":"Potrebné znížiť úväzky o"},null,null,{"$f":"IF(($J$14-$J$15)>=1,($J$14-$J$15),IF(($J$14-$J$15)<=-1,($J$15-$J$14),\"OK\"))","v":767.0000024414403},{"$f":"IF($I$17=\"OK\",\"\",\"hodín\")","v":"hodín"}]
[null,{"$f":"'Zamestnanci zoznam'!I8","v":"Jakub Cvrlík"},80]
[null,{"$f":"'Zamestnanci zoznam'!I9","v":"Matúš Sobranec"},80]
[null,{"$f":"'Zamestnanci zoznam'!I10","v":"Erik Sebák"},80]
[null,{"$f":"'Zamestnanci zoznam'!I11","v":"Filip Tučný"},80]
[null,{"$f":"'Zamestnanci zoznam'!I12","v":"Andrej Chudý"},80]
[null,{"$f":"'Zamestnanci zoznam'!I13","v":"Eliáš Široký"},80]
[null,{"$f":"'Zamestnanci zoznam'!I14","v":"Edmund Kovalda"},80]
[null,{"$f":"'Zamestnanci zoznam'!I15","v":"Stano Truhlár"},80]

{"sheet":"Zamestnanci - mzdy","index":5,"n_rows":28,"n_cols":19,"rows_kept":28,"cut":false,"hidden":false,"merged":[[23,9,23,10],[9,9,9,14],[10,9,10,14],[3,16,3,18],[3,8,4,9],[16,11,16,12],[18,16,18,17],[4,4,5,4],[4,1,5,1],[16,1,17,1],[2,1,2,6],[4,5,5,5],[4,6,5,6],[3,4,3,6],[3,2,3,3],[4,2,5,2],[0,0,0,1],[22,9,22,10],[19,9,19,14],[13,9,13,14],[20,9,21,11],[20,12,20,13],[16,13,18,14],[17,11,17,12],[18,11,18,12],[2,8,2,18],[3,10,3,15],[14,11,14,12],[15,11,15,12],[16,16,17,18],[19,16,19,17],[4,3,5,3]]}
["Zamestnanci - mzdy"]
[]
[null,"Výroba",null,null,null,null,null,null,"Predaj"]
[null,"Meno","Počet odpracovaných hodín",null,"Mzda",null,null,null,"Meno",null,"Počet kusov",null,null,null,null,null,"Mzda"]
[null,"Zamestnanci","Riadna pracovná doba","Nadčasy","Riadna pracovná doba","Nadčasy","Celkom",null,null,null,"A","B","C","D","E","Spolu","Norma","Prémie","Celkom"]
[null,null,null,null,null,null,null,null,{"$f":"'Zamestnanci zoznam'!F6","v":"Peter Havran"},null,{"$f":"GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Zamestnanec\",\"Peter Havran\",\"Produkt\",\"A\")","v":7500},{"$f":"GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Zamestnanec\",\"Peter Havran\",\"Produkt\",\"B\")","v":8000},{"$f":"GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Zamestnanec\",\"Peter Havran\",\"Produkt\",\"C\")","v":3500},{"$f":"GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Zamestnanec\",\"Peter Havran\",\"Produkt\",\"D\")","v":0},{"$f":"GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Zamestnanec\",\"Peter Havran\",\"Produkt\",\"E\")","v":3500},{"$f":"SUM(K6:O6)","v":22500},{"$f":"SUMPRODUCT($K$13:$O$13,K6:O6)","v":23130},{"$f":"IF(SUM(K6:O6)<=$N$16,0,(VLOOKUP(SUM(K6:O6)-$N$16,$J$16:$L$19,3)*(P6-$N$16)))","v":2625},{"$f":"SUM(Q6:R6)","v":25755}]
[null,{"$f":"'Zamestnanci zoznam'!$C$6","v":"Rudolf Záhora"},{"$f":"'Zamestnanci - Plán hodín '!C4","v":160},{"$f":"'Zamestnanci - Plán hodín '!D4","v":30.363636807534625},{"$f":"C7*$M$23","v":16000},{"$f":"D7*$N$23","v":4554.5455211301942},{"$f":"E7+F7","v":20554.545521130196},null,{"$f":"'Zamestnanci zoznam'!F7","v":"Roman Sokol"},null,{"$f":"GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Zamestnanec\",\"Roman Sokol\",\"Produkt\",\"A\")","v":7000},{"$f":"GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Zamestnanec\",\"Roman Sokol\",\"Produkt\",\"B\")","v":3000},{"$f":"GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Zamestnanec\",\"Roman Sokol\",\"Produkt\",\"C\")","v":3500},{"$f":"GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Zamestnanec\",\"Roman Sokol\",\"Produkt\",\"D\")","v":1500},{"$f":"GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Zamestnanec\",\"Roman Sokol\",\"Produkt\",\"E\")","v":4000},{"$f":"SUM(K7:O7)","v":19000},{"$f":"SUMPRODUCT($K$13:$O$13,K7:O7)","v":19440},{"$f":"IF(SUM(K7:O7)<=$N$16,0,(VLOOKUP(SUM(K7:O7)-$N$16,$J$16:$L$19,3)*(P7-$N$16)))","v":0},{"$f":"SUM(Q7:R7)","v":19440}]
[null,{"$f":"'Zamestnanci zoznam'!$C$7","v":"Peter Butolický"},{"$f":"'Zamestnanci - Plán hodín '!C5","v":160},{"$f":"'Zamestnanci - Plán hodín '!D5","v":15.181818403767309},16000,2277.2727605650962,{"$f":"E8+F8","v":18277.272760565094},null,{"$f":"'Zamestnanci zoznam'!F8","v":"Anton Herhaj"},null,{"$f":"GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Zamestnanec\",\"Anton Herhaj\",\"Produkt\",\"A\")","v":11000},{"$f":"GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Zamestnanec\",\"Anton Herhaj\",\"Produkt\",\"B\")","v":2000},{"$f":"GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Zamestnanec\",\"Anton Herhaj\",\"Produkt\",\"C\")","v":9000},{"$f":"GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Zamestnanec\",\"Anton Herhaj\",\"Produkt\",\"D\")","v":5000},{"$f":"GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Zamestnanec\",\"Anton Herhaj\",\"Produkt\",\"E\")","v":3500},30500,{"$f":"SUMPRODUCT($K$13:$O$13,K8:O8)","v":31210},{"$f":"IF(SUM(K8:O8)<=$N$16,0,(VLOOKUP(SUM(K8:O8)-$N$16,$J$16:$L$19,3)*(P8-$N$16)))","v":12074.999999999998},43285]
[null,{"$f":"'Zamestnanci zoznam'!C8","v":"Ján Kukumberg"},{"$f":"'Zamestnanci - Plán hodín '!C6","v":160},{"$f":"'Zamestnanci - Plán hodín '!D6","v":15.181818403767309},16000,2277.2727605650962,18277.272760565094]
[null,{"$f":"'Zamestnanci zoznam'!C9","v":"Pavel Peniažka"},{"$f":"'Zamestnanci - Plán hodín '!C7","v":160},{"$f":"'Zamestnanci - Plán hodín '!D7","v":15.181818403767309},16000,2277.2727605650962,18277.272760565094,null,null,"Mzdové tabuľky"]
[null,{"$f":"'Zamestnanci zoznam'!C10","v":"Miroslav Černý"},{"$f":"'Zamestnanci - Plán hodín '!C8","v":160},{"$f":"'Zamestnanci - Plán hodín '!D8","v":15.181818403767309},16000,2277.2727605650962,18277.272760565094,null,null,"Predaj"]
[null,{"$f":"'Zamestnanci zoznam'!C11","v":"Ján Dobrman"},{"$f":"'Zamestnanci - Plán hodín '!C9","v":160},{"$f":"'Zamestnanci - Plán hodín '!D9","v":15.181818403767309},16000,2277.2727605650962,18277.272760565094,null,null,"Produkt","A","B","C","D","E"]
[null,{"$f":"'Zamestnanci zoznam'!C12","v":"Oliver Manera"},{"$f":"'Zamestnanci - Plán hodín '!C10","v":160},{"$f":"'Zamestnanci - Plán hodín '!D10","v":15.181818403767309},16000,2277.2727605650962,18277.272760565094,null,null,"Koeficient",1,1.07,1,1.1000000000000001,1.02]
[null,{"$f":"'Zamestnanci zoznam'!C13","v":"Samuel Dlhý"},{"$f":"'Zamestnanci - Plán hodín '!C11","v":160},{"$f":"'Zamestnanci - Plán hodín '!D11","v":15.181818403767309},16000,2277.2727605650962,18277.272760565094,null,null,"Prémie"]
[null,{"$f":"'Zamestnanci zoznam'!C14","v":"Jozef Novák"},{"$f":"'Zamestnanci - Plán hodín '!C12","v":160},{"$f":"'Zamestnanci - Plán hodín '!D12","v":15.181818403767309},16000,2277.2727605650962,18277.272760565094,null,null,"od ","do","Koeficient",null,"Norma","Sadzba "]
[null,{"$f":"'Zamestnanci zoznam'!C15","v":"Pavol Hurhaj"},{"$f":"'Zamestnanci - Plán hodín '!C13","v":160},{"$f":"'Zamestnanci - Plán hodín '!D13","v":15.181818403767307},16000,2277.2727605650962,18277.272760565094,null,null,0,5000,1.05,null,20000,1]
[null,"Brigádnici",null,null,null,null,null,null,null,5000,10000,1.075,null,null,null,null,"Mzdy celkom"]
[null,null,null,null,null,null,null,null,null,10000,20000,1.1499999999999999]
[null,{"$f":"'Zamestnanci zoznam'!I6","v":"Lukáš Trilobit"},{"$f":"'Zamestnanci - Plán hodín '!C16","v":80},null,{"$f":"C19*$M$24","v":6400},null,{"$f":"E19","v":6400},null,null,20000,null,1.2,null,null,null,null,"Kategória",null,"Mzdy"]
[null,{"$f":"'Zamestnanci zoznam'!I7","v":"Marián Sergej"},{"$f":"'Zamestnanci - Plán hodín '!C17","v":80},null,6400,null,{"$f":"E20","v":6400},null,null,"Výroba",null,null,null,null,null,null,"RPD celkom",null,{"$f":"SUM(E7:E16)","v":160000}]
[null,{"$f":"'Zamestnanci zoznam'!I8","v":"Jakub Cvrlík"},{"$f":"'Zamestnanci - Plán hodín '!C18","v":80},null,6400,null,{"$f":"E21","v":6400},null,null,"Pracovný čas (mesačný)",null,null,"Hodinová sadzba",null,null,null,"Nadčasy celkom",null,{"$f":"SUM(F7:F16)","v":25050.000366216052}]
[null,{"$f":"'Zamestnanci zoznam'!I9","v":"Matúš Sobranec"},{"$f":"'Zamestnanci - Plán hodín '!C19","v":80},null,6400,null,6400,null,null,null,null,null,"RPD ","Nadčasy",null,null,"Brigádnici celkom",null,{"$f":"SUM(G19:G28)","v":64000}]
[null,{"$f":"'Zamestnanci zoznam'!I10","v":"Erik Sebák"},{"$f":"'Zamestnanci - Plán hodín '!C20","v":80},null,6400,null,6400,null,null,"Zamestnanci",null,160,100,150,null,null,"Dealeri celkom",null,{"$f":"SUM(S6:S8)","v":88480}]
[null,{"$f":"'Zamestnanci zoznam'!I11","v":"Filip Tučný"},{"$f":"'Zamestnanci - Plán hodín '!C21","v":80},null,6400,null,6400,null,null,"Brigádnici",null,40,80,null,null,null,"SPOLU:",null,{"$f":"SUM(S20:S23)","v":337530.00036621606}]
[null,{"$f":"'Zamestnanci zoznam'!I12","v":"Andrej Chudý"},{"$f":"'Zamestnanci - Plán hodín '!C22","v":80},null,6400,null,6400]
[null,{"$f":"'Zamestnanci zoznam'!I13","v":"Eliáš Široký"},{"$f":"'Zamestnanci - Plán hodín '!C23","v":80},null,6400,null,6400]
[null,{"$f":"'Zamestnanci zoznam'!I14","v":"Edmund Kovalda"},{"$f":"'Zamestnanci - Plán hodín '!C24","v":80},null,6400,null,6400]
[null,{"$f":"'Zamestnanci zoznam'!I15","v":"Stano Truhlár"},{"$f":"'Zamestnanci - Plán hodín '!C25","v":80},null,6400,null,{"$f":"E28","v":6400}]

{"sheet":"Transport","index":6,"n_rows":8,"n_cols":16,"rows_kept":8,"cut":false,"hidden":false,"merged":[[3,2,3,6],[2,9,2,15],[3,9,3,11],[3,13,3,15],[2,1,2,7],[3,7,4,7],[3,1,4,1]]}
[]
[]
[null,"Transport",null,null,null,null,null,null,null,"Náklady za transport"]
[null,"Transportná spoločnosť","Produkt",null,null,null,null,"Spolu",null,"TS 1",null,null,null,"TS 2"]
[null,null,"A","B","C","D","E",null,null,"od","do",null,null,"od","do"]
[null,"TS1",{"$f":"IF(OR(AND(GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"A\")>8000,GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"A\")<10000),AND(GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"A\")>15000,GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"A\")<20000)),GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"A\"),\"-\")","v":"-"},{"$f":"IF(OR(AND(GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"B\")>8000,GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"B\")<10000),AND(GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"B\")>15000,GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"B\")<20000)),GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"B\"),\"-\")","v":"-"},{"$f":"IF(OR(AND(GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"C\")>8000,GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"C\")<10000),AND(GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"C\")>15000,GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"C\")<20000)),GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"C\"),\"-\")","v":16000},{"$f":"IF(OR(AND(GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"D\")>8000,GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"D\")<10000),AND(GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"D\")>15000,GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"D\")<20000)),GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"D\"),\"-\")","v":"-"},{"$f":"IF(OR(AND(GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"E\")>8000,GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"E\")<10000),AND(GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"E\")>15000,GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"E\")<20000)),GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"E\"),\"-\")","v":"-"},{"$f":"SUM(C6:G6)","v":16000},null,0,10000,10000,null,0,8000,8000]
[null,"TS2",{"$f":"IF(OR(GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"A\")<8000,AND(GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"A\")>10000,GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"A\")<15000),GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"A\")>20000),GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"A\"),\"-\")","v":25500},{"$f":"IF(OR(GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"B\")<8000,AND(GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"B\")>10000,GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"B\")<15000),GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"B\")>20000),GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"B\"),\"-\")","v":13000},{"$f":"IF(OR(GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"C\")<8000,AND(GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"C\")>10000,GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"C\")<15000),GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"C\")>20000),GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"C\"),\"-\")","v":"-"},{"$f":"IF(OR(GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"D\")<8000,AND(GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"D\")>10000,GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"D\")<15000),GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"D\")>20000),GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"D\"),\"-\")","v":6500},{"$f":"IF(OR(GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"E\")<8000,AND(GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"E\")>10000,GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"E\")<15000),GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"E\")>20000),GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"E\"),\"-\")","v":11000},56000,null,10000,20000,20000,null,8000,15000,15000]
[null,"Cena:",{"$f":"IF(C6=\"-\",LOOKUP(C7,$N$6:$P$8),LOOKUP(C6,$J$6:$L$8))","v":25000},{"$f":"IF(D6=\"-\",LOOKUP(D7,$N$6:$P$8),LOOKUP(D6,$J$6:$L$8))","v":15000},{"$f":"IF(E6=\"-\",LOOKUP(E7,$N$6:$P$8),LOOKUP(E6,$J$6:$L$8))","v":20000},{"$f":"IF(F6=\"-\",LOOKUP(F7,$N$6:$P$8),LOOKUP(F6,$J$6:$L$8))","v":8000},{"$f":"IF(G6=\"-\",LOOKUP(G7,$N$6:$P$8),LOOKUP(G6,$J$6:$L$8))","v":15000},83000,null,20000,null,30000,null,15000,null,25000]

{"sheet":"Výpočet ceny","index":7,"n_rows":24,"n_cols":14,"rows_kept":24,"cut":false,"hidden":false,"merged":[[21,8,21,12],[20,8,20,13],[17,8,17,9],[12,8,12,10],[11,1,11,6],[20,1,20,3],[20,4,20,6],[12,11,12,12],[11,8,11,12]]}
[]
[]
[null,"Cena = ((cena M1 * váha M1 + cena M2 * váha M2 + cena M3 * váha M3 + cena M4 * váha M4 + cena M5 * váha M5) / 10) + (mzda za 1 ks) + (koeficient predajcu) + (medzná sadzba za transport) + (zisková marža) + (náklady nájom) + (náklady energie)"]
[]
[null,"CENA","Hrubý výpočet","Zaokrúhlené nahor"]
[null,"A",{"$f":"((SUMPRODUCT(C14:G14,$C$19:$G$19))/10)+$J$16+M14+$N$22+$I$19+$C$24+$F$24","v":33.083333333333336},{"$f":"CEILING(C6,1)","v":34}]
[null,"B",{"$f":"((SUMPRODUCT(C15:G15,$C$19:$G$19))/10)+$J$16+M15+$N$22+$I$19+$C$24+$F$24","v":38.403333333333336},{"$f":"CEILING(C7,1)","v":39}]
[null,"C",{"$f":"((SUMPRODUCT(C16:G16,$C$19:$G$19))/10)+$J$16+M16+$N$22+$I$19+$C$24+$F$24","v":32.833333333333336},{"$f":"CEILING(C8,1)","v":33}]
[null,"D",{"$f":"((SUMPRODUCT(C17:G17,$C$19:$G$19))/10)+$J$16+M17+$N$22+$I$19+$C$24+$F$24","v":39.433333333333337},40]
[null,"E",{"$f":"((SUMPRODUCT(C18:G18,$C$19:$G$19))/10)+$J$16+M18+$N$22+$I$19+$C$24+$F$24","v":36.853333333333339},37]
[]
[null,"Produkty",null,null,null,null,null,null,"Mzdy"]
[null,"Produkt","Materiál 1","Materiál 2","Materiál 3","Materiál 4","Materiál 5",null,"Výroba",null,null,"Predaj"]
[null,"Produkt A",0.25,0.6,"-",0.15,"-",null,"ks/hod",{"$f":"Výroba!G18","v":40},null,"A",{"$f":"'Zamestnanci - mzdy'!K13","v":1}]
[null,"Produkt B",0.3,"-",0.5,"-",0.2,null,"kč/hod",{"$f":"'Zamestnanci - mzdy'!M23","v":100},null,"B",{"$f":"'Zamestnanci - mzdy'!L13","v":1.07}]
[null,"Produkt C",0.6,0.4,null,null,null,null,"kč/ks",{"$f":"J15/J14","v":2.5},null,"C",{"$f":"'Zamestnanci - mzdy'!M13","v":1}]
[null,"Produkt D",0.3,"-",0.45,"-",0.25,null,null,null,null,"D",{"$f":"'Zamestnanci - mzdy'!N13","v":1.1000000000000001}]
[null,"Produkt E","-",0.25,0.25,0.3,0.2,null,"Zisková marža",null,null,"E",{"$f":"'Zamestnanci - mzdy'!O13","v":1.02}]
[null,"Cena",{"$f":"Výroba!C5","v":250},{"$f":"Výroba!C6","v":300},{"$f":"Výroba!C7","v":300},{"$f":"Výroba!C8","v":200},{"$f":"Výroba!C9","v":500},null,0.5,"Kč/ks"]
[]
[null,"Nájom",null,null,"Energie",null,null,null,"Transport"]
[null,"cena",{"$f":"Výroba!J13","v":20000},"Kč/mesiac","cena",{"$f":"Výroba!J16","v":20},"kč/hod",null,"Sadzby za transport sú po prepočítaní u oboch spoločností ",null,null,null,null,1]
[null,"norma",{"$f":"'Zamestnanci - mzdy'!N16*3","v":60000},"ks/mesiac","norma",{"$f":"Výroba!G18","v":40},"ks/hod"]
[null,"náklady",{"$f":"C22/C23","v":0.33333333333333331},"kč/ks","náklady",{"$f":"F22/F23","v":0.5},"kč/ks"]

{"sheet":"Finančné oddelenie","index":8,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[[3,1,3,2],[10,1,10,2],[1,3,2,4],[1,1,2,2]]}
[]
[null,"Náklady",null,"Príjmy"]
[]
[null,"Fixné"]
[null,"Mzdy (RPD)",{"$f":"SUM('Zamestnanci - mzdy'!E7:E16)","v":160000},"Predaj výrobkov",{"$f":"SUM(E6:E10)","v":2569000}]
[null,"Prenájom",{"$f":"Výroba!J13","v":20000},"Produkt A",{"$f":"(GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"A\"))*'Výpočet ceny'!D6","v":867000}]
[null,null,null,"Produkt B",{"$f":"(GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"B\"))*'Výpočet ceny'!D7","v":507000}]
[null,null,null,"Produkt C",{"$f":"(GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"C\"))*'Výpočet ceny'!D8","v":528000}]
[null,null,null,"Produkt D",{"$f":"(GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"D\"))*'Výpočet ceny'!D9","v":260000}]
[null,null,null,"Produkt E",{"$f":"(GETPIVOTDATA(\"Počet ks\",Objednávky!$H$3,\"Produkt\",\"E\"))*'Výpočet ceny'!D10","v":407000}]
[null,"Variabilné"]
[null,"Mzdy",{"$f":"SUM(C13:C15)","v":177530.00036621606}]
[null,"Nadčasy",{"$f":"'Zamestnanci - mzdy'!S21","v":25050.000366216052}]
[null,"Brigádnicke hodiny",{"$f":"SUM('Zamestnanci - mzdy'!E19:E28)","v":64000}]
[null,"Dealeri",{"$f":"SUM('Zamestnanci - mzdy'!S6:S8)","v":88480}]
[null,"Energie",{"$f":"SUMPRODUCT('Zamestnanci - Plán hodín '!J15,Výroba!J16)","v":51340.000048828806}]
[null,"Transport",{"$f":"Transport!H8","v":83000}]
[]
[]
[null,"SPOLU:"]
[null,"Náklady",{"$f":"SUM(C23,C22)","v":491870.00041504484}]
[null,"Variabilné",{"$f":"SUM(C12,C16,C17)","v":311870.00041504484}]
[null,"Fixné",{"$f":"SUM(C5:C6)","v":180000}]
[null,"Príjmy",{"$f":"SUM(E5)","v":2569000}]
[null,{"$f":"IF(C25>0,\"ZISK\",\"STRATA\")","v":"ZISK"},{"$f":"C24-C21","v":2077129.9995849552}]