{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["KALKULÁTOR","ZDROJ"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":6,"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":"KALKULÁTOR","index":0,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":false,"merged":[[17,1,17,3],[18,1,18,3],[25,2,25,4],[30,3,32,5],[19,1,19,3],[10,1,10,11],[26,2,26,4],[24,1,24,5],[28,2,28,4],[21,1,21,3],[27,2,27,4],[12,1,12,11],[15,8,15,9],[13,1,13,11],[15,1,15,3],[16,1,16,3],[20,1,20,3],[22,1,22,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"kalkulátor spotřeby materiálu - předsazená montáž oken"]
[]
[null,"ZADEJTE ROZMĚRY JEDNOTLIVÝCH OKEN NEBO OBVOD OKEN V BĚŽNÝCH METRECH"]
[null,"PRO PŘESNĚJŠÍ VÝPOČET VČETNĚ PODKLADOVÉHO PROFILU A PŘESAHU VWM PROFILŮ VYUŽIJTE MOŽNOST ZADÁNÍ JEDNOTLIVÝCH OKEN"]
[]
[null,"Celkový obvod oken",null,null,{"$f":"SUM(L17:L36)","v":0},"běžných metrů",null,null,"Šířka mm x Výška mm",null,"Počet ks","BM"]
[null,"Hodnota prořezu (%)",null,null,0,"%",null,"Okno 1",null,null,null,{"$f":"((2*I17+320+2*J17+2*$E$20)/1000)*K17","v":0}]
[null,"Vyberte způsob kotvení",null,null,"-",null,null,"Okno 2",null,null,null,{"$f":"((2*I18+320+2*J18+2*$E$20)/1000)*K18","v":0}]
[null,"Vyberte rozměr kotvení",null,null,"-",null,null,"Okno 3",null,null,null,0]
[null,"Vyberte podkladový profil",null,null,null,"mm",null,"Okno 4",null,null,null,0]
[null,"Potřebné množství profilů",null,null,{"$f":"(E16/1.2)+(E16/1.2*E17%)","v":0},null,null,"Okno 5",null,null,null,0]
[null,"Potřebné množství lepidla",null,null,{"$f":"E21/4","v":0},null,null,"Okno 6",null,null,null,0]
[null,"Potřebné množství kotevních bodů",null,null,{"$f":"E21*5","v":0},null,null,"Okno 7",null,null,null,0]
[null,null,null,null,null,null,null,"Okno 8",null,null,null,0]
[null,"návrh objednávky",null,null,null,null,null,"Okno 9",null,null,null,0]
[null,"Artiklové číslo","Název zboží",null,null,"Množství",null,"Okno 10",null,null,null,0]
[null,"0479743208",{"$f":"ZDROJ!J2","v":"MONT.UHEL.VWM.SYS.EPS-BÍLÁ-80X80X1200MM"},null,null,{"$f":"CEILING(E21,1)","v":0},null,"Okno 11",null,null,null,0]
[null,{"$f":"ZDROJ!K2","v":"0479743200"},{"$f":"ZDROJ!L2","v":"KONSTRUK.LEPIDLO-MONTÁŽ.-VWM-SÁČEK-600ML"},null,null,{"$f":"CEILING(E22,1)","v":0},null,"Okno 12",null,null,null,0]
[null,{"$f":"IFERROR(VLOOKUP(E19,ZDROJ!C:D,2,0),IFERROR(VLOOKUP(KALKULÁTOR!E19,ZDROJ!F:G,2,0),\"VYBERTE KOTVENÍ\"))","v":"VYBERTE KOTVENÍ"},{"$f":"IFERROR(VLOOKUP(B29,ZDROJ!D:E,2,0),IFERROR(VLOOKUP(B29,ZDROJ!G:H,2,0),\"VYBERTE KOTVENÍ\"))","v":"VYBERTE KOTVENÍ"},null,null,{"$f":"F27*5","v":0},null,"Okno 13",null,null,null,0]
[null,null,null,null,null,null,null,"Okno 14",null,null,null,0]
[null,null,null,"V případě otázek kontaktujte specialistu na montáž oken Jaroslava Pavlíka",null,null,null,"Okno 15",null,null,null,0]
[null,null,null,null,null,null,null,"Okno 16",null,null,null,0]
[null,null,null,null,null,null,null,"Okno 17",null,null,null,0]
[null,null,null,"Tel:","+ 420 733 252 521",null,null,"Okno 18",null,null,null,0]
[null,null,null,"E-mail:","okna@wuerth.cz",null,null,"Okno 19",null,null,null,0]
[null,null,null,null,null,null,null,"Okno 20",null,null,null,0]

{"sheet":"ZDROJ","index":1,"n_rows":6,"n_cols":12,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["AMO_ŠROUBY","PODKLADOVÝ_PROFIL","AMO_ŠROUBY",null,null,"RÁMOVÉ_HMOŽDINKY",null,null,"MONTÁŽNÍ PROFIL",null,"LEPDIDLO"]
["RÁMOVÉ_HMOŽDINKY","30","7,5x152 mm RW30","0234930152","ŠROUB AMOIII TYP3MOD.POZ.7,5X152RW30","10x160 mm AW40","5912810405","HM.SHARK-UR10-PLAST(A2K)-AW40-90-10X160","0479743208","MONT.UHEL.VWM.SYS.EPS-BÍLÁ-80X80X1200MM","0479743200","KONSTRUK.LEPIDLO-MONTÁŽ.-VWM-SÁČEK-600ML"]
["-","40","7,5x182 mm RW30","0234930182","ŠROUB AMOIII TYP3MOD.POZ.7,5X182RW30","10x185 mm AW40","5912810406","HM.SHARK-UR10-PLAST(A2K)-AW40-115-10X185"]
[null,"50","7,5x212 mm RW30","0234930212","ŠROUB AMOIII TYP3MOD.POZ.7,5X212RW30","10x200 mm AW40","5912810407","HM.SHARK-UR10-PLAST(A2K)-AW40-130-10X200"]
[null,"60","-","VYBERTE KOTVENÍ","VYBERTE KOTVENÍ","10x230 mm AW40","5912810408","HM.SHARK-UR10-PLAST(A2K)-AW40-160-10X230"]
[null,"0",null,null,null,"-","VYBERTE KOTVENÍ"]