{"text_format":"1","workbook":"xlsx","n_sheets":34,"sheets":["Prehled","Kalkulace","Kalkulace_stara","Kalkulace (2)","NEPOUZIVAT","zaloha_2018","List1","Pokus","Milan","cenik_final","cenik_final_2","Vstupy","Kurzy","Sazby","Material","Mzdy","Rezie","Marze","Vyroba_A","Vyroba_B","Vyroba_C","Sestava","Souhrn","Export","Data_import","pomocne","temp","List1 (2)","Kontrola","Archiv_2017","Poznamky","Ceník_2019","Sheet1","zaloha_2018 (2)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":13,"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":"Prehled","index":0,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Přehled kalkulace ceníku"]
[{"$f":"NOW()","v":null}]
[]
["Náklady celkem",{"$f":"Souhrn!B4","v":null},null,{"$error":"#REF!"}]
["Cena bez DPH celkem",{"$f":"Souhrn!B5","v":null},null,{"$f":"OFFSET(Souhrn!$B$4,1,0)","v":null}]
["Cena s DPH celkem",{"$f":"Kalkulace!G10","v":null},null,{"$f":"INDIRECT(\"cenik_final!E\"&ROW())","v":null}]
["Ceník v1 celkem",{"$f":"SUM(cenik_final!E4:E9)","v":null}]
["Ceník v2 celkem",{"$f":"SUM(cenik_final_2!C4:C9)","v":null}]
["Rozdíl v2 proti v1",{"$f":"B8-B7","v":null}]
["Kurz EUR",{"$f":"Kurzy!$B$4","v":null}]
["Počet položek",{"$f":"Souhrn!B12","v":null}]
["Poslední přepočet",{"$f":"TODAY()","v":null}]
["Kontrolní součet",{"$f":"Kontrola!B4","v":null}]

{"sheet":"Kalkulace","index":1,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,1,14,3],[6,1,6,2]]}
["KALKULACE CENÍKU 2019 — FINAL v3 (opraveno)"]
[]
["Kód","Položka","Náklad","Marže","Cena bez DPH","DPH","Cena s DPH","Pásmo"]
[{"$f":"Sestava!A4","v":null},{"$f":"Vstupy!B4","v":null},{"$f":"Sestava!E4","v":null},{"$f":"Marze!D4","v":null},{"$f":"Souhrn!$B$9*0+Marze!D4","v":null},{"$f":"Marze!D4*21/100","v":null},{"$f":"Marze!D4*1.21","v":null},{"$f":"IF(Sestava!$E$4<1000,Sestava!$E$4*1.35+Sazby!$B$8*1,IF(Sestava!$E$4<1850,Sestava!$E$4*1.3350000000000002+Sazby!$B$8*2,IF(Sestava!$E$4<2700,Sestava!$E$4*1.32+Sazby!$B$8*3,IF(Sestava!$E$4<3550,Sestava!$E$4*1.3050000000000002+Sazby!$B$8*4,IF(Sestava!$E$4<4400,Sestava!$E$4*1.29+Sazby!$B$8*5,IF(Sestava!$E$4<5250,Sestava!$E$4*1.2750000000000001+Sazby!$B$8*6,IF(Sestava!$E$4<6100,Sestava!$E$4*1.26+Sazby!$B$8*7,IF(Sestava!$E$4<6950,Sestava!$E$4*1.245+Sazby!$B$8*8,IF(Sestava!$E$4<7800,Sestava!$E$4*1.23+Sazby!$B$8*9,IF(Sestava!$E$4<8650,Sestava!$E$4*1.215+Sazby!$B$8*10,IF(Sestava!$E$4<9500,Sestava!$E$4*1.2000000000000002+Sazby!$B$8*11,IF(Sestava!$E$4<10350,Sestava!$E$4*1.185+Sazby!$B$8*12,Sestava!$E$4*Sazby!$B$6))))))))))))","v":null}]
[{"$f":"Sestava!A5","v":null},{"$f":"Vstupy!B5","v":null},{"$f":"Sestava!E5","v":null},{"$f":"Marze!D5","v":null},{"$f":"Souhrn!$B$9*0+Marze!D5","v":null},{"$f":"Marze!D5*21/100","v":null},{"$f":"Marze!D5*1.21","v":null},{"$f":"IF(H4>0,H4*Sazby!$B$6,IF(Souhrn!B4>0,Souhrn!B4*1.35,Kalkulace_stara!E4))","v":null}]
[{"$f":"Sestava!A6","v":null},{"$f":"Vstupy!B6","v":null},{"$f":"Sestava!E6","v":null},{"$f":"Marze!D6","v":null},{"$f":"Souhrn!$B$9*0+Marze!D6","v":null},{"$f":"Marze!D6*21/100","v":null},{"$f":"Marze!D6*1.21","v":null}]
[{"$f":"Sestava!A7","v":null},"Profil L 40x40 (sloučeno 2018)",null,{"$f":"Marze!D7","v":null},{"$f":"Souhrn!$B$9*0+Marze!D7","v":null},{"$f":"Marze!D7*21/100","v":null},{"$f":"Marze!D7*1.21","v":null}]
[{"$f":"Sestava!A8","v":null},{"$f":"Vstupy!B8","v":null},{"$f":"Sestava!E8","v":null},{"$f":"Marze!D8","v":null},{"$f":"Souhrn!$B$9*0+Marze!D8","v":null},{"$f":"Marze!D8*21/100","v":null},{"$f":"Marze!D8*1.21","v":null}]
[{"$f":"Sestava!A9","v":null},{"$f":"Vstupy!B9","v":null},{"$f":"Sestava!E9","v":null},{"$f":"Marze!D9","v":null},{"$f":"Souhrn!$B$9*0+Marze!D9","v":null},{"$f":"Marze!D9*21/100","v":null},{"$f":"Marze!D9*1.21","v":null}]
[null,null,null,null,{"$f":"SUM(E4:E9)","v":null},null,{"$f":"SUM(G4:G9)","v":null}]
[]
[]
[]
[]
[null,"Kabel CYKY 3x1,5 — pozor, ruční zásah"]

{"sheet":"Kalkulace_stara","index":2,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Kalkulace 2016 (nepoužívat, ponecháno pro jistotu)"]
[]
["Kód","Položka","Náklad","Marže","Cena"]
[{"$f":"Vstupy!A4","v":null},{"$f":"Vstupy!B4","v":null},{"$f":"Vstupy!C4*Vstupy!D4","v":null},1.35,{"$f":"C4*D4","v":null},{"$f":"#REF!+Vstupy!C4","v":null}]
[{"$f":"Vstupy!A5","v":null},{"$f":"Vstupy!B5","v":null},{"$f":"Vstupy!C5*Vstupy!D5","v":null},1.35,{"$f":"C5*D5","v":null},{"$f":"Vstupy!C4/Sazby!$B$9","v":null}]
[{"$f":"Vstupy!A6","v":null},{"$f":"Vstupy!B6","v":null},{"$f":"Vstupy!C6*Vstupy!D6","v":null},1.35,{"$f":"C6*D6","v":null}]
[{"$f":"Vstupy!A7","v":null},{"$f":"Vstupy!B7","v":null},{"$f":"Vstupy!C7*Vstupy!D7","v":null},1.35,{"$f":"C7*D7","v":null}]
[{"$f":"Vstupy!A8","v":null},{"$f":"Vstupy!B8","v":null},{"$f":"Vstupy!C8*Vstupy!D8","v":null},1.35,{"$f":"C8*D8","v":null}]
[]
[]
[]
[null,null,null,{"$error":"#REF!"}]
[null,null,null,{"$error":"#DIV/0!"}]

{"sheet":"Kalkulace (2)","index":3,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Kalkulace — kopie z 3.9.2018"]
[]
["Kód","Cena bez DPH","Cena s DPH","Rozdíl"]
[{"$f":"Kalkulace!A4","v":null},{"$f":"Kalkulace!E4","v":null},{"$f":"Kalkulace!E4*1.21","v":null},{"$f":"C4-Kalkulace!G4","v":null}]
[{"$f":"Kalkulace!A5","v":null},{"$f":"Kalkulace!E5","v":null},{"$f":"Kalkulace!E5*1.21","v":null},{"$f":"C5-Kalkulace!G5","v":null}]
[{"$f":"Kalkulace!A6","v":null},{"$f":"Kalkulace!E6","v":null},{"$f":"Kalkulace!E6*1.21","v":null},{"$f":"C6-Kalkulace!G6","v":null}]
[{"$f":"Kalkulace!A7","v":null},{"$f":"Kalkulace!E7","v":null},{"$f":"Kalkulace!E7*1.21","v":null},{"$f":"C7-Kalkulace!G7","v":null}]
[{"$f":"Kalkulace!A8","v":null},{"$f":"Kalkulace!E8","v":null},{"$f":"Kalkulace!E8*1.21","v":null},{"$f":"C8-Kalkulace!G8","v":null}]

{"sheet":"NEPOUZIVAT","index":4,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["NEPOUŽÍVAT — zůstalo po Milanovi, ceny jsou z roku 2016"]
[]
["Kód","Cena","Pozn."]
[{"$f":"'Kalkulace_stara'!A4","v":null},{"$f":"'Kalkulace_stara'!E4*1.19","v":null},null,{"$f":"VLOOKUP(\"MAT-999\",Vstupy!$A$4:$E$33,5,FALSE)","v":null}]
[{"$f":"'Kalkulace_stara'!A5","v":null},{"$f":"'Kalkulace_stara'!E5*1.19","v":null},{"$error":"#VALUE!"}]
[{"$f":"'Kalkulace_stara'!A6","v":null},{"$f":"'Kalkulace_stara'!E6*1.19","v":null},{"$error":"#N/A"}]
[{"$f":"'Kalkulace_stara'!A7","v":null},{"$f":"'Kalkulace_stara'!E7*1.19","v":null}]
[{"$f":"'Kalkulace_stara'!A8","v":null},{"$f":"'Kalkulace_stara'!E8*1.19","v":null}]
[{"$f":"'Kalkulace_stara'!A9","v":null},{"$f":"'Kalkulace_stara'!E9*1.19","v":null}]

{"sheet":"zaloha_2018","index":5,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Záloha 12/2018 před přepočtem"]
[]
["Kód","Cena","Marže"]
[{"$f":"Kalkulace_stara!A4","v":null},{"$f":"Kalkulace_stara!E4","v":null},1.35]
[{"$f":"Kalkulace_stara!A5","v":null},{"$f":"Kalkulace_stara!E5","v":null},1.35]
[{"$f":"Kalkulace_stara!A6","v":null},{"$f":"Kalkulace_stara!E6","v":null},1.35]
[{"$f":"Kalkulace_stara!A7","v":null},{"$f":"Kalkulace_stara!E7","v":null},1.35]
[{"$f":"Kalkulace_stara!A8","v":null},{"$f":"Kalkulace_stara!E8","v":null},1.35]

{"sheet":"List1","index":6,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["pokus o novy vzorec, nechavam"]
[]
[]
[{"$f":"Vstupy!A4","v":null},{"$f":"Vstupy!C4*Vstupy!D4","v":null}]
[{"$f":"Vstupy!A5","v":null},{"$f":"Vstupy!C5*Vstupy!D5","v":null}]
[{"$f":"Vstupy!A6","v":null},{"$f":"Vstupy!C6*Vstupy!D6","v":null}]
[{"$f":"Vstupy!A7","v":null},{"$f":"Vstupy!C7*Vstupy!D7","v":null}]
[{"$f":"Vstupy!A8","v":null},{"$f":"Vstupy!C8*Vstupy!D8","v":null}]

{"sheet":"Pokus","index":7,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["zkouska OFFSET, 2017"]
[]
[]
[{"$f":"OFFSET(Vyroba_A!$E$4,0,0)","v":null},{"$f":"INDIRECT(\"Vyroba_A!E\"&ROW())","v":null}]
[{"$f":"OFFSET(Vyroba_A!$E$4,1,0)","v":null}]
[{"$f":"OFFSET(Vyroba_A!$E$4,2,0)","v":null}]
[{"$f":"OFFSET(Vyroba_A!$E$4,3,0)","v":null}]
[{"$f":"OFFSET(Vyroba_A!$E$4,4,0)","v":null}]

{"sheet":"Milan","index":8,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Milanovy poznámky ke kalkulaci"]
[]
["Kód","Cena","Množství"]
[{"$f":"Kalkulace!A4","v":null},{"$f":"Kalkulace!E4","v":null},{"$f":"Vstupy!C4","v":null}]
[{"$f":"Kalkulace!A5","v":null},{"$f":"Kalkulace!E5","v":null},{"$f":"Vstupy!C5","v":null}]
[{"$f":"Kalkulace!A6","v":null},{"$f":"Kalkulace!E6","v":null},{"$f":"Vstupy!C6","v":null}]
[{"$f":"Kalkulace!A7","v":null},{"$f":"Kalkulace!E7","v":null},{"$f":"Vstupy!C7","v":null}]
[{"$f":"Kalkulace!A8","v":null},{"$f":"Kalkulace!E8","v":null},{"$f":"Vstupy!C8","v":null}]

{"sheet":"cenik_final","index":9,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Ceník 2019 — finální"]
[]
["Kód","Položka","Cena bez DPH","DPH","Cena s DPH","Platnost"]
[{"$f":"Kalkulace!A4","v":null},{"$f":"Kalkulace!B4","v":null},{"$f":"Kalkulace!E4","v":null},{"$f":"C4*21/100","v":null},{"$f":"C4+D4","v":null},{"$f":"TODAY()","v":null}]
[{"$f":"Kalkulace!A5","v":null},{"$f":"Kalkulace!B5","v":null},{"$f":"Kalkulace!E5","v":null},{"$f":"C5*21/100","v":null},{"$f":"C5+D5","v":null},{"$f":"TODAY()","v":null}]
[{"$f":"Kalkulace!A6","v":null},{"$f":"Kalkulace!B6","v":null},{"$f":"Kalkulace!E6","v":null},{"$f":"C6*21/100","v":null},{"$f":"C6+D6","v":null},{"$f":"TODAY()","v":null}]
[{"$f":"Kalkulace!A7","v":null},{"$f":"Kalkulace!B7","v":null},{"$f":"Kalkulace!E7","v":null},{"$f":"C7*21/100","v":null},{"$f":"C7+D7","v":null},{"$f":"TODAY()","v":null}]
[{"$f":"Kalkulace!A8","v":null},{"$f":"Kalkulace!B8","v":null},{"$f":"Kalkulace!E8","v":null},{"$f":"C8*21/100","v":null},{"$f":"C8+D8","v":null},{"$f":"TODAY()","v":null}]
[{"$f":"Kalkulace!A9","v":null},{"$f":"Kalkulace!B9","v":null},{"$f":"Kalkulace!E9","v":null},{"$f":"C9*21/100","v":null},{"$f":"C9+D9","v":null},{"$f":"TODAY()","v":null}]

{"sheet":"cenik_final_2","index":10,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Ceník 2019 — finální, opravený 14.1.2019"]
[]
["Kód","Cena bez DPH","Cena s DPH","Rozdíl proti v1"]
[{"$f":"cenik_final!A4","v":null},{"$f":"cenik_final!C4*1.03","v":null},{"$f":"B4*1.21","v":null},{"$f":"B4-Kalkulace!E4","v":null}]
[{"$f":"cenik_final!A5","v":null},{"$f":"cenik_final!C5*1.03","v":null},{"$f":"B5*1.21","v":null},{"$f":"B5-Kalkulace!E5","v":null}]
[{"$f":"cenik_final!A6","v":null},{"$f":"cenik_final!C6*1.03","v":null},{"$f":"B6*1.21","v":null},{"$f":"B6-Kalkulace!E6","v":null}]
[{"$f":"cenik_final!A7","v":null},{"$f":"cenik_final!C7*1.03","v":null},{"$f":"B7*1.21","v":null},{"$f":"B7-Kalkulace!E7","v":null}]
[{"$f":"cenik_final!A8","v":null},{"$f":"cenik_final!C8*1.03","v":null},{"$f":"B8*1.21","v":null},{"$f":"B8-Kalkulace!E8","v":null}]
[{"$f":"cenik_final!A9","v":null},{"$f":"cenik_final!C9*1.03","v":null},{"$f":"B9*1.21","v":null},{"$f":"B9-Kalkulace!E9","v":null}]

{"sheet":"Vstupy","index":11,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Vstupní data ke kalkulaci ceníku 2016"]
[]
["Kód","Položka","Množství","Cena/MJ","Měna",null,"Datum ceníku"]
["MAT-001","Ocelový plech 2 mm",120,14.5,"EUR",null,"2016-03-01"]
["MAT-002","Ocelový plech 3 mm",157,17.77,"CZK",null,"2018-11-30"]
["MAT-003","Profil L 40x40",194,21.04,"CZK",null,"2019-01-15"]
["MAT-004","Profil U 60","231",24.31,"EUR",null,"1.2.2019"]
["MAT-005","Trubka 32x2",268,27.58,"CZK",null,"2019/02/01"]
["MAT-006","Šroub M8x40",305,30.85,"CZK",null,{"$f":"TODAY()","v":null}]
["MAT-007","Matice M8","342 ",34.12,"EUR",null,{"$f":"NOW()","v":null}]
["MAT-008","Podložka 8",379,37.39,"CZK"]
["MAT-009","Barva základní",416,40.66,"CZK"]
["MAT-010","Barva vrchní","453-",43.93,"EUR"]
["MAT-011","Ředidlo S6006",490,47.2,"CZK"]
["MAT-012","Svařovací drát 1,0","527",50.47,"CZK"]
["MAT-013","Technický plyn",564,53.74,"EUR"]
["MAT-014","Ložisko 6204",601,57.01,"CZK"]
["MAT-015","Těsnění gumové",638,60.28,"CZK"]
["MAT-016","Kabel CYKY 3x1,5",675,63.55,"EUR"]
["MAT-017","Svorkovnice",712,66.81999999999999,"CZK"]
["MAT-018","Motor 0,55 kW","749 ",70.09,"CZK"]
["MAT-019","Řemenice",786,73.36,"EUR"]
["MAT-020","Klínový řemen","823",76.63,"CZK"]
["MAT-021","Krytka plastová",860,79.90000000000001,"CZK"]
["MAT-022","Štítek výrobní",897,83.17,"EUR"]
["MAT-023","Paleta EUR",934,86.44,"CZK"]
["MAT-024","Fólie stretch",971,89.70999999999999,"CZK"]
["MAT-025","Karton 600x400","1008-",92.98,"EUR"]
["MAT-026","Lepicí páska",1045,96.25,"CZK"]
["MAT-027","Rohová výztuha",1082,99.52,"CZK"]
["MAT-028","Antikorozní vosk","1 480",102.79,"EUR"]
["MAT-029","Čisticí prostředek",1156,106.06,"CZK"]
["MAT-030","Spojovací materiál ostatní",1193,109.33,"CZK"]

{"sheet":"Kurzy","index":12,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Kurzy měn"]
[]
["Měna","Kurz","Zdroj","Aktualizace"]
["EUR",25.4,"ČNB, ručně",{"$f":"TODAY()","v":null}]
["USD",22.85,"ČNB, ručně",{"$f":"TODAY()","v":null}]
["PLN",5.92,null,{"$f":"TODAY()","v":null}]
["EUR (síť)",{"$f":"[1]Kurzy!$B$2","v":null},"starý server",{"$f":"TODAY()","v":null}]
["EUR (kontrola)",{"$f":"B4-[1]Kurzy!$B$2","v":null},"rozdíl",{"$f":"TODAY()","v":null}]

{"sheet":"Sazby","index":13,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Sazby a koeficienty (needitovat)"]
[]
["Popis","Hodnota","Platnost od"]
["DPH základní",21,"2013-01-01"]
["DPH snížená",15]
["Marže standardní",1.35]
["Marže velkoodběr",1.18]
["Režie výrobní",0.18]
["Režie správní"]
["Hodinová sazba",180]

{"sheet":"Material","index":14,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Materiálové náklady"]
[]
["Kód","Položka","Množství","Cena/MJ","Kurz","Náklad","Pozn.","Kontrola"]
[{"$f":"Vstupy!A4","v":null},{"$f":"Vstupy!B4","v":null},{"$f":"Vstupy!C4","v":null},{"$f":"Vstupy!D4","v":null},25.4,{"$f":"Vstupy!C4*Vstupy!D4*25.4","v":null},"kurz ze starého serveru",{"$f":"[1]Kurzy!$B$3","v":null}]
[{"$f":"Vstupy!A5","v":null},{"$f":"Vstupy!B5","v":null},{"$f":"Vstupy!C5","v":null},{"$f":"Vstupy!D5","v":null},{"$f":"Kurzy!$B$4","v":null},{"$f":"Vstupy!C5*Vstupy!D5*Kurzy!$B$4","v":null}]
[{"$f":"Vstupy!A6","v":null},{"$f":"Vstupy!B6","v":null},{"$f":"Vstupy!C6","v":null},{"$f":"Vstupy!D6","v":null},{"$f":"Kurzy!$B$4","v":null},{"$f":"Vstupy!C6*Vstupy!D6*Kurzy!$B$4","v":null}]
[{"$f":"Vstupy!A7","v":null},{"$f":"Vstupy!B7","v":null},{"$f":"Vstupy!C7","v":null},{"$f":"Vstupy!D7","v":null},25.4,{"$f":"Vstupy!C7*Vstupy!D7*25.4","v":null}]
[{"$f":"Vstupy!A8","v":null},{"$f":"Vstupy!B8","v":null},{"$f":"Vstupy!C8","v":null},{"$f":"Vstupy!D8","v":null},{"$f":"Kurzy!$B$4","v":null},{"$f":"Vstupy!C8*Vstupy!D8*Kurzy!$B$4","v":null}]
[{"$f":"Vstupy!A9","v":null},{"$f":"Vstupy!B9","v":null},{"$f":"Vstupy!C9","v":null},{"$f":"Vstupy!D9","v":null},{"$f":"Kurzy!$B$4","v":null},{"$f":"Vstupy!C9*Vstupy!D9*Kurzy!$B$4","v":null}]
[{"$f":"Vstupy!A10","v":null},{"$f":"Vstupy!B10","v":null},{"$f":"Vstupy!C10","v":null},{"$f":"Vstupy!D10","v":null},25.4,{"$f":"Vstupy!C10*Vstupy!D10*25.4","v":null}]
[{"$f":"Vstupy!A11","v":null},{"$f":"Vstupy!B11","v":null},{"$f":"Vstupy!C11","v":null},{"$f":"Vstupy!D11","v":null},{"$f":"Kurzy!$B$4","v":null},{"$f":"Vstupy!C11*Vstupy!D11*Kurzy!$B$4","v":null}]
[{"$f":"Vstupy!A12","v":null},{"$f":"Vstupy!B12","v":null},{"$f":"Vstupy!C12","v":null},{"$f":"Vstupy!D12","v":null},{"$f":"Kurzy!$B$4","v":null},{"$f":"Vstupy!C12*Vstupy!D12*Kurzy!$B$4","v":null}]
[{"$f":"Vstupy!A13","v":null},{"$f":"Vstupy!B13","v":null},{"$f":"Vstupy!C13","v":null},{"$f":"Vstupy!D13","v":null},25.4,{"$f":"Vstupy!C13*Vstupy!D13*25.4","v":null}]
[{"$f":"Vstupy!A14","v":null},{"$f":"Vstupy!B14","v":null},{"$f":"Vstupy!C14","v":null},{"$f":"Vstupy!D14","v":null},{"$f":"Kurzy!$B$4","v":null},{"$f":"Vstupy!C14*Vstupy!D14*Kurzy!$B$4","v":null}]
[]
[null,null,null,null,null,{"$f":"SUM(F4:F14)","v":null}]

{"sheet":"Mzdy","index":15,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Mzdové náklady (důvěrné)"]
[]
["Kód","Norma hod.","Sazba","Náklad"]
[{"$f":"Vstupy!A4","v":null},0.4,{"$f":"Sazby!$B$10","v":null},{"$f":"B4*C4*Vstupy!C4","v":null}]
[{"$f":"Vstupy!A5","v":null},0.53,{"$f":"Sazby!$B$10","v":null},{"$f":"B5*C5*Vstupy!C5","v":null}]
[{"$f":"Vstupy!A6","v":null},0.66,{"$f":"Sazby!$B$10","v":null},{"$f":"B6*C6*Vstupy!C6","v":null}]
[{"$f":"Vstupy!A7","v":null},0.79,{"$f":"Sazby!$B$10","v":null},{"$f":"B7*C7*Vstupy!C7","v":null}]
[{"$f":"Vstupy!A8","v":null},0.92,{"$f":"Sazby!$B$10","v":null},{"$f":"B8*C8*Vstupy!C8","v":null}]
[{"$f":"Vstupy!A9","v":null},1.05,{"$f":"Sazby!$B$10","v":null},{"$f":"B9*C9*Vstupy!C9","v":null}]

{"sheet":"Rezie","index":16,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Režie"]
[]
["Kód","Materiál","Mzdy","Režie celkem"]
[{"$f":"Material!A4","v":null},{"$f":"Material!F4","v":null},{"$f":"Mzdy!D4","v":null},{"$f":"Material!F4*0.18+Mzdy!D4*0.12","v":null}]
[{"$f":"Material!A5","v":null},{"$f":"Material!F5","v":null},{"$f":"Mzdy!D5","v":null},{"$f":"Material!F5*0.18+Mzdy!D5*0.12","v":null}]
[{"$f":"Material!A6","v":null},{"$f":"Material!F6","v":null},{"$f":"Mzdy!D6","v":null},{"$f":"Material!F6*0.18+Mzdy!D6*0.12","v":null}]
[{"$f":"Material!A7","v":null},{"$f":"Material!F7","v":null},{"$f":"Mzdy!D7","v":null},{"$f":"Material!F7*0.18+Mzdy!D7*0.12","v":null}]
[{"$f":"Material!A8","v":null},{"$f":"Material!F8","v":null},{"$f":"Mzdy!D8","v":null},{"$f":"Material!F8*0.18+Mzdy!D8*0.12","v":null}]
[{"$f":"Material!A9","v":null},{"$f":"Material!F9","v":null},{"$f":"Mzdy!D9","v":null},{"$f":"Material!F9*0.18+Mzdy!D9*0.12","v":null}]

{"sheet":"Marze","index":17,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Marže"]
[]
["Kód","Náklad","Marže","Cena bez DPH"]
[{"$f":"Sestava!A4","v":null},{"$f":"Sestava!E4","v":null},{"$f":"Sazby!$B$6","v":null},{"$f":"Sestava!E4*Sazby!$B$6","v":null}]
[{"$f":"Sestava!A5","v":null},{"$f":"Sestava!E5","v":null},1.35,{"$f":"Sestava!E5*1.35","v":null}]
[{"$f":"Sestava!A6","v":null},{"$f":"Sestava!E6","v":null},{"$f":"Sazby!$B$6","v":null},{"$f":"Sestava!E6*Sazby!$B$6","v":null}]
[{"$f":"Sestava!A7","v":null},{"$f":"Sestava!E7","v":null},1.35,{"$f":"Sestava!E7*1.35","v":null}]
[{"$f":"Sestava!A8","v":null},{"$f":"Sestava!E8","v":null},{"$f":"Sazby!$B$6","v":null},{"$f":"Sestava!E8*Sazby!$B$6","v":null}]
[{"$f":"Sestava!A9","v":null},{"$f":"Sestava!E9","v":null},1.35,{"$f":"Sestava!E9*1.35","v":null}]

{"sheet":"Vyroba_A","index":18,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Výrobní linka A"]
[]
["Kód","Materiál","Mzdy","Režie","Náklad"]
[{"$f":"Material!A4","v":null},{"$f":"Material!F4*1.0","v":null},{"$f":"Mzdy!D4","v":null},{"$f":"Rezie!D4","v":null},{"$f":"B4+C4+D4","v":null}]
[{"$f":"Material!A5","v":null},{"$f":"Material!F5*1.0","v":null},{"$f":"Mzdy!D5","v":null},{"$f":"Rezie!D5","v":null},{"$f":"B5+C5+D5","v":null}]
[{"$f":"Material!A6","v":null},{"$f":"Material!F6*1.0","v":null},{"$f":"Mzdy!D6","v":null},{"$f":"Rezie!D6","v":null},{"$f":"B6+C6+D6","v":null}]
[{"$f":"Material!A7","v":null},{"$f":"Material!F7*1.0","v":null},{"$f":"Mzdy!D7","v":null},{"$f":"Rezie!D7","v":null},{"$f":"B7+C7+D7","v":null}]
[{"$f":"Material!A8","v":null},{"$f":"Material!F8*1.0","v":null},{"$f":"Mzdy!D8","v":null},{"$f":"Rezie!D8","v":null},{"$f":"B8+C8+D8","v":null}]
[{"$f":"Material!A9","v":null},{"$f":"Material!F9*1.0","v":null},{"$f":"Mzdy!D9","v":null},{"$f":"Rezie!D9","v":null},{"$f":"B9+C9+D9","v":null}]

{"sheet":"Vyroba_B","index":19,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Výrobní linka B"]
[]
["Kód","Materiál","Mzdy","Režie","Náklad"]
[{"$f":"Material!A4","v":null},{"$f":"Material!F4*1.08","v":null},{"$f":"Mzdy!D4","v":null},{"$f":"Rezie!D4","v":null},{"$f":"B4+C4+D4","v":null}]
[{"$f":"Material!A5","v":null},{"$f":"Material!F5*1.08","v":null},{"$f":"Mzdy!D5","v":null},{"$f":"Rezie!D5","v":null},{"$f":"B5+C5+D5","v":null}]
[{"$f":"Material!A6","v":null},{"$f":"Material!F6*1.08","v":null},{"$f":"Mzdy!D6","v":null},{"$f":"Rezie!D6","v":null},{"$f":"B6+C6+D6","v":null}]
[{"$f":"Material!A7","v":null},{"$f":"Material!F7*1.08","v":null},{"$f":"Mzdy!D7","v":null},{"$f":"Rezie!D7","v":null},{"$f":"B7+C7+D7","v":null}]
[{"$f":"Material!A8","v":null},{"$f":"Material!F8*1.08","v":null},{"$f":"Mzdy!D8","v":null},{"$f":"Rezie!D8","v":null},{"$f":"B8+C8+D8","v":null}]
[{"$f":"Material!A9","v":null},{"$f":"Material!F9*1.08","v":null},{"$f":"Mzdy!D9","v":null},{"$f":"Rezie!D9","v":null},{"$f":"B9+C9+D9","v":null}]

{"sheet":"Vyroba_C","index":20,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Výrobní linka C"]
[]
["Kód","Materiál","Mzdy","Režie","Náklad"]
[{"$f":"Material!A4","v":null},{"$f":"Material!F4*0.94","v":null},{"$f":"Mzdy!D4","v":null},{"$f":"Rezie!D4","v":null},{"$f":"B4+C4+D4","v":null}]
[{"$f":"Material!A5","v":null},{"$f":"Material!F5*0.94","v":null},{"$f":"Mzdy!D5","v":null},{"$f":"Rezie!D5","v":null},{"$f":"B5+C5+D5","v":null}]
[{"$f":"Material!A6","v":null},{"$f":"Material!F6*0.94","v":null},{"$f":"Mzdy!D6","v":null},{"$f":"Rezie!D6","v":null},{"$f":"B6+C6+D6","v":null}]
[{"$f":"Material!A7","v":null},{"$f":"Material!F7*0.94","v":null},{"$f":"Mzdy!D7","v":null},{"$f":"Rezie!D7","v":null},{"$f":"B7+C7+D7","v":null}]
[{"$f":"Material!A8","v":null},{"$f":"Material!F8*0.94","v":null},{"$f":"Mzdy!D8","v":null},{"$f":"Rezie!D8","v":null},{"$f":"B8+C8+D8","v":null}]
[{"$f":"Material!A9","v":null},{"$f":"Material!F9*0.94","v":null},{"$f":"Mzdy!D9","v":null},{"$f":"Rezie!D9","v":null},{"$f":"B9+C9+D9","v":null}]

{"sheet":"Sestava","index":21,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[9,0,11,0]]}
["Sestava výrobku"]
[]
["Kód","Linka A","Linka B","Linka C","Náklad","Posun",null,"Kurz"]
[{"$f":"Vyroba_A!A4","v":null},{"$f":"Vyroba_A!E4","v":null},{"$f":"Vyroba_B!E4","v":null},{"$f":"Vyroba_C!E4","v":null},{"$f":"B4+C4+D4","v":null},{"$f":"OFFSET(Vyroba_A!$E$4,0,0)","v":null},null,{"$f":"Kurzy!$B$4","v":null}]
[{"$f":"Vyroba_A!A5","v":null},{"$f":"Vyroba_A!E5","v":null},{"$f":"Vyroba_B!E5","v":null},{"$f":"Vyroba_C!E5","v":null},{"$f":"B5+C5+D5","v":null},{"$f":"OFFSET(Vyroba_A!$E$4,1,0)","v":null}]
[{"$f":"Vyroba_A!A6","v":null},{"$f":"Vyroba_A!E6","v":null},{"$f":"Vyroba_B!E6","v":null},{"$f":"Vyroba_C!E6","v":null},{"$f":"B6+C6+D6","v":null},{"$f":"OFFSET(Vyroba_A!$E$4,2,0)","v":null}]
[{"$f":"Vyroba_A!A7","v":null},{"$f":"Vyroba_A!E7","v":null},{"$f":"Vyroba_B!E7","v":null},{"$f":"Vyroba_C!E7","v":null},{"$f":"B7+C7+D7","v":null},{"$f":"OFFSET(Vyroba_A!$E$4,3,0)","v":null}]
[{"$f":"Vyroba_A!A8","v":null},{"$f":"Vyroba_A!E8","v":null},{"$f":"Vyroba_B!E8","v":null},{"$f":"Vyroba_C!E8","v":null},{"$f":"B8+C8+D8","v":null},{"$f":"OFFSET(Vyroba_A!$E$4,4,0)","v":null}]
[{"$f":"Vyroba_A!A9","v":null},{"$f":"Vyroba_A!E9","v":null},{"$f":"Vyroba_B!E9","v":null},{"$f":"Vyroba_C!E9","v":null},{"$f":"B9+C9+D9","v":null},{"$f":"OFFSET(Vyroba_A!$E$4,5,0)","v":null}]
["MAT-007 až 009"]

{"sheet":"Souhrn","index":22,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Souhrn kalkulace"]
[]
["Ukazatel","Hodnota","Pozn."]
["Náklady celkem",{"$f":"SUM(Sestava!E4:E9)","v":null},{"$f":"INDIRECT(\"Sestava!E4\")","v":null}]
["Cena bez DPH celkem",{"$f":"SUM(Marze!D4:D9)","v":null},{"$f":"INDIRECT(\"Marze!D\"&ROW())","v":null}]
["Materiál celkem",{"$f":"SUM(Material!F4:F14)","v":null}]
["Mzdy celkem",{"$f":"SUM(Mzdy!D4:D9)","v":null}]
["Režie celkem",{"$f":"SUM(Rezie!D4:D9)","v":null}]
["Průměrná marže",{"$f":"Souhrn!B5/Souhrn!B4","v":null}]
["Kurz EUR",{"$f":"Kurzy!$B$4","v":null}]
["Náklady v EUR",{"$f":"Souhrn!B4/Kurzy!$B$4","v":null}]
["Počet položek",{"$f":"COUNTA(Vstupy!A4:A33)","v":null}]
["Součet množství",{"$f":"SUM(Vstupy!C4:C33)","v":null}]
["Kontrola linek",{"$f":"Sestava!E4-Vyroba_A!E4-Vyroba_B!E4-Vyroba_C!E4","v":null}]
["Datum přepočtu",{"$f":"NOW()","v":null}]

{"sheet":"Export","index":23,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Podklad pro export do ERP"]
[]
["Kód","Cena","Zdroj"]
[{"$f":"cenik_final!A4","v":null},{"$f":"INDIRECT(\"cenik_final!E\"&ROW())","v":null},{"$f":"Prehled!$B$4","v":null}]
[{"$f":"cenik_final!A5","v":null},{"$f":"INDIRECT(\"cenik_final!E\"&ROW())","v":null},{"$f":"Prehled!$B$4","v":null}]
[{"$f":"cenik_final!A6","v":null},{"$f":"INDIRECT(\"cenik_final!E\"&ROW())","v":null},{"$f":"Prehled!$B$4","v":null}]
[{"$f":"cenik_final!A7","v":null},{"$f":"INDIRECT(\"cenik_final!E\"&ROW())","v":null},{"$f":"Prehled!$B$4","v":null}]
[{"$f":"cenik_final!A8","v":null},{"$f":"INDIRECT(\"cenik_final!E\"&ROW())","v":null},{"$f":"Prehled!$B$4","v":null}]

{"sheet":"Data_import","index":24,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Import z výroby (starý formát)"]
[]
["Kód","Množství"]
[{"$f":"Vstupy!A4","v":null},{"$f":"Vstupy!C4","v":null}]
[{"$f":"Vstupy!A5","v":null},{"$f":"Vstupy!C5","v":null}]
[{"$f":"Vstupy!A6","v":null},{"$f":"Vstupy!C6","v":null}]
[{"$f":"Vstupy!A7","v":null},{"$f":"Vstupy!C7","v":null}]

{"sheet":"pomocne","index":25,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["pomocné výpočty"]
["zpět na Kontrolu",{"$f":"Kontrola!C22","v":null}]
[]
[{"$f":"Material!A4","v":null},{"$f":"Material!F4/2","v":null}]
[{"$f":"Material!A5","v":null},{"$f":"Material!F5/2","v":null}]
[{"$f":"Material!A6","v":null},{"$f":"Material!F6/2","v":null}]
[{"$f":"Material!A7","v":null},{"$f":"Material!F7/2","v":null}]
[{"$f":"Material!A8","v":null},{"$f":"Material!F8/2","v":null}]

{"sheet":"temp","index":26,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["temp — smazat"]
[]
[]
[{"$f":"Material!F4","v":null}]
[{"$f":"Material!F5","v":null}]
[{"$f":"Material!F6","v":null}]
[{"$f":"Material!F7","v":null}]
[{"$f":"Material!F8","v":null}]

{"sheet":"List1 (2)","index":27,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["kopie Listu1"]
[]
[]
[{"$f":"'List1'!A4","v":null},{"$f":"'List1'!B4*1.02","v":null}]
[{"$f":"'List1'!A5","v":null},{"$f":"'List1'!B5*1.02","v":null}]
[{"$f":"'List1'!A6","v":null},{"$f":"'List1'!B6*1.02","v":null}]
[{"$f":"'List1'!A7","v":null},{"$f":"'List1'!B7*1.02","v":null}]

{"sheet":"Kontrola","index":28,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Kontroly"]
[]
["Kontrola","Hodnota","Stav"]
["Součet ceníku vs. kalkulace",{"$f":"SUM(cenik_final!C4:C9)-Kalkulace!E10","v":null}]
["Součet linek",{"$f":"SUM(Sestava!E4:E9)-SUM(Vyroba_A!E4:E9)-SUM(Vyroba_B!E4:E9)-SUM(Vyroba_C!E4:E9)","v":null}]
["Množství vs. text",{"$f":"SUM(Vstupy!C4:C33)-COUNT(Vstupy!C4:C33)*0","v":null}]
["Marže průměr",{"$f":"Souhrn!B5/Souhrn!B4","v":null}]
["Kurz",{"$f":"Kurzy!$B$4-25.4","v":null},null,null,{"$error":"#N/A"}]
["Materiál",{"$f":"Souhrn!B6-SUM(Material!F4:F33)","v":null}]
["Nedohledatelná položka",{"$f":"VLOOKUP(\"MAT-099\",Vstupy!$A$4:$E$33,3,FALSE)","v":null}]
["Dělení prázdnou sazbou",{"$f":"Souhrn!B4/Sazby!$B$9","v":null}]
["Text krát číslo",{"$f":"Vstupy!B4*2","v":null}]
[]
[]
[]
[]
[]
[]
[]
[null,"Kruh 1 (uvnitř listu)",{"$f":"C21+Souhrn!B4","v":null}]
[null,null,{"$f":"C20*0.5","v":null}]
[null,"Kruh 2 (přes listy)",{"$f":"pomocne!B2+1","v":null}]

{"sheet":"Archiv_2017","index":29,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Archiv 2017"]
[]
["Kód","Cena"]
[{"$f":"zaloha_2018!A4","v":null},{"$f":"zaloha_2018!B4*0.96","v":null}]
[{"$f":"zaloha_2018!A5","v":null},{"$f":"zaloha_2018!B5*0.96","v":null}]
[{"$f":"zaloha_2018!A6","v":null},{"$f":"zaloha_2018!B6*0.96","v":null}]
[{"$f":"zaloha_2018!A7","v":null},{"$f":"zaloha_2018!B7*0.96","v":null}]

{"sheet":"Poznamky","index":30,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Poznámky k sešitu"]
[]
["3.5.2016  Milan: prvni verze, kurz EUR rucne z CNB"]
["2.2.2017  Milan: pridana linka C, marze 1,35 zatim natvrdo",null,{"$f":"Kontrola!B4","v":null}]
["9.11.2017 Milan: sazba DPH v H4 je jenom pro pasma, needitovat",null,{"$f":"Kontrola!B5","v":null}]
["3.9.2018  Jana: kopie listu Kalkulace kvuli auditu",null,{"$f":"TODAY()","v":null}]
["6.12.2018 Jana: Milan odchazi, prevzala jsem sesit"]
["14.1.2019 Jana: ceny nesedely, udelala jsem cenik_final_2"]
["2.4.2019  Jana: nevim proc to hlasi kruhovy odkaz, necham byt"]
["?         nikdo netusi, k cemu je list Pokus"]

{"sheet":"Ceník_2019","index":31,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Ceník 2019 pro obchod"]
[]
["Kód","Cena s DPH","Zaokrouhleno"]
[{"$f":"cenik_final_2!A4","v":null},{"$f":"cenik_final_2!C4","v":null},{"$f":"ROUND(cenik_final_2!C4,0)","v":null}]
[{"$f":"cenik_final_2!A5","v":null},{"$f":"cenik_final_2!C5","v":null},{"$f":"ROUND(cenik_final_2!C5,0)","v":null}]
[{"$f":"cenik_final_2!A6","v":null},{"$f":"cenik_final_2!C6","v":null},{"$f":"ROUND(cenik_final_2!C6,0)","v":null}]
[{"$f":"cenik_final_2!A7","v":null},{"$f":"cenik_final_2!C7","v":null},{"$f":"ROUND(cenik_final_2!C7,0)","v":null}]
[{"$f":"cenik_final_2!A8","v":null},{"$f":"cenik_final_2!C8","v":null},{"$f":"ROUND(cenik_final_2!C8,0)","v":null}]
[{"$f":"cenik_final_2!A9","v":null},{"$f":"cenik_final_2!C9","v":null},{"$f":"ROUND(cenik_final_2!C9,0)","v":null}]

{"sheet":"Sheet1","index":32,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["leftover from english template"]
[]
[]
[{"$f":"Export!B4","v":null}]
[{"$f":"Export!B5","v":null}]
[{"$f":"Export!B6","v":null}]
[{"$f":"Export!B7","v":null}]

{"sheet":"zaloha_2018 (2)","index":33,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Záloha 12/2018 — druhá kopie"]
[]
["Kód","Cena"]
[{"$f":"zaloha_2018!A4","v":null},{"$f":"zaloha_2018!B4","v":null}]
[{"$f":"zaloha_2018!A5","v":null},{"$f":"zaloha_2018!B5","v":null}]
[{"$f":"zaloha_2018!A6","v":null},{"$f":"zaloha_2018!B6","v":null}]
[{"$f":"zaloha_2018!A7","v":null},{"$f":"zaloha_2018!B7","v":null}]
[{"$f":"zaloha_2018!A8","v":null},{"$f":"zaloha_2018!B8","v":null}]