{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["OBJ_PUR_SEZNAM","Seznam výkresů","Vypocet"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":18,"comments":1,"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":"OBJ_PUR_SEZNAM","index":0,"n_rows":32,"n_cols":20,"rows_kept":32,"cut":false,"hidden":false,"merged":[[6,0,6,1],[7,0,7,1],[6,11,6,14],[8,0,8,1],[5,0,5,1],[5,3,5,8],[6,3,6,8],[5,11,5,14],[5,9,5,10],[6,9,6,10],[12,0,13,0],[12,14,13,14],[12,11,13,11],[12,5,12,7],[12,4,13,4],[12,10,13,10],[12,12,12,13],[12,1,12,3],[12,15,12,19],[12,9,13,9],[12,8,13,8],[7,3,7,8],[8,3,8,8],[8,11,8,14],[7,11,7,14],[10,9,10,10],[10,2,10,5],[7,9,7,10],[0,0,0,14],[1,0,1,14],[2,0,2,1],[3,0,3,1],[4,0,4,1],[4,11,4,14],[3,11,3,14],[2,11,2,14],[2,9,2,10],[3,9,3,10],[4,9,4,10],[2,3,2,8],[3,3,3,8],[4,3,4,8]]}
["OBJEDNÁVKA PUR - podkladní profily",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jestliže program nefunguje nemáte povoleny makra"]
["Jedná se o typy: PUR, PUR HS, KER a KER HS"]
["Objednatel:",null,"List č.1 z 1",null,null,null,null,null,null,"bm:",null,null,null,null,null,"Vyplňte hodnoty v bílém poli"]
[null,null,"č. objednávky:",null,null,null,null,null,null,{"$f":"SUMPRODUCT(E15:E32,H15:H32)/1000","v":0},null,null,null,null,null,"Modré hodnoty jsou navržené systémem"]
[null,null,"Datum objednání:",null,null,null,null,null,null,"Váha:",null,null,null,null,null,"Nemněňte červené hodnoty v šedém poli"]
[null,null,"Datum dodání:",null,null,null,null,null,null,{"$f":"SUM(S15:S32)","v":0},null,"PARAPETY Sadil s.r.o."]
[null,null,"Adresa dodání:",null,null,null,null,null,null,"ks:",null,"Žerotínova 3334"]
[null,null,"Kontakt:",null,null,null,null,null,null,{"$f":"SUM(E15:E32)","v":0},null,"Šumperk, 787 01"]
[null,null,"Zakázka:",null,null,null,null,null,null,null,null,"IČ: 27857662               DIČ: CZ27857662"]
[]
[null,null,"Zadáváte pohledovou výšku ?",null,null,null,"Ano",null,null,"Úhelníky:",null,0,"/ks"]
[]
["Pozice","Typ",null,null,"Ks","Rozměry (mm)",null,null,"Vrtání","Vzdálenost od vnitřní hrany","Dodání šroubů","Zahloubení pro šrouby","Šrouby",null,"Vypočtená celková výška ","Doporučené a vypočítané hodnoty"]
[null,"Označení profilu","(Číslo výkresu)","Materiál",null,"Šířka","Výška","Délka",null,null,null,null,"Počet šroubů na kus","Délka šroubu",null,"Navržená délka šroubu","Navržené zahloubení šroubů","Navržený počet šroubů","Vypočítaná váha položky kg","Vypočtená výška profilace"]
[null,null,{"$f":"VLOOKUP(B15,'Seznam výkresů'!$A$2:$B$29,2,FALSE)","v":0},null,null,null,null,null,null,null,null,{"$f":"Q15","v":""},{"$f":"R15","v":""},{"$f":"P15","v":""},{"$f":"VypCelkoveVysky($G$11,G15,T15)","v":""},{"$f":"VypDelSroA(I15,K15,O15,PresahSroubu,DelkySroubuArray)","v":""},{"$f":"VypZahloubeniSro(I15,O15,P15,PresahSroubu)","v":""},{"$f":"VypPocetSro(D15,E15,H15,K15,TVP,MDZVV,DVV)","v":""},{"$f":"VypVahy(D15,E15,F15,O15,H15,M15,N15,VahaXPS,VahaPUR,VahaKER,VahaJednohoSroubu)","v":""},{"$f":"VypProfilace(C15)","v":""}]
[null,null,{"$f":"VLOOKUP(B16,'Seznam výkresů'!$A$2:$B$29,2,FALSE)","v":0},null,null,null,null,null,null,null,null,"","","","",{"$f":"VypDelSroA(I16,K16,O16,PresahSroubu,DelkySroubuArray)","v":""},{"$f":"VypZahloubeniSro(I16,O16,P16,PresahSroubu)","v":""},{"$f":"VypPocetSro(D16,E16,H16,K16,TVP,MDZVV,DVV)","v":""},{"$f":"VypVahy(D16,E16,F16,O16,H16,M16,N16,VahaXPS,VahaPUR,VahaKER,VahaJednohoSroubu)","v":""},""]
[null,null,{"$f":"VLOOKUP(B17,'Seznam výkresů'!$A$2:$B$29,2,FALSE)","v":0},null,null,null,null,null,null,null,null,"","","","",{"$f":"VypDelSroA(I17,K17,O17,PresahSroubu,DelkySroubuArray)","v":""},{"$f":"VypZahloubeniSro(I17,O17,P17,PresahSroubu)","v":""},{"$f":"VypPocetSro(D17,E17,H17,K17,TVP,MDZVV,DVV)","v":""},{"$f":"VypVahy(D17,E17,F17,O17,H17,M17,N17,VahaXPS,VahaPUR,VahaKER,VahaJednohoSroubu)","v":""},""]
[null,null,{"$f":"VLOOKUP(B18,'Seznam výkresů'!$A$2:$B$29,2,FALSE)","v":0},null,null,null,null,null,null,null,null,"","","","",{"$f":"VypDelSroA(I18,K18,O18,PresahSroubu,DelkySroubuArray)","v":""},{"$f":"VypZahloubeniSro(I18,O18,P18,PresahSroubu)","v":""},{"$f":"VypPocetSro(D18,E18,H18,K18,TVP,MDZVV,DVV)","v":""},{"$f":"VypVahy(D18,E18,F18,O18,H18,M18,N18,VahaXPS,VahaPUR,VahaKER,VahaJednohoSroubu)","v":""},""]
[null,null,{"$f":"VLOOKUP(B19,'Seznam výkresů'!$A$2:$B$29,2,FALSE)","v":0},null,null,null,null,null,null,null,null,"","","","",{"$f":"VypDelSroA(I19,K19,O19,PresahSroubu,DelkySroubuArray)","v":""},{"$f":"VypZahloubeniSro(I19,O19,P19,PresahSroubu)","v":""},{"$f":"VypPocetSro(D19,E19,H19,K19,TVP,MDZVV,DVV)","v":""},{"$f":"VypVahy(D19,E19,F19,O19,H19,M19,N19,VahaXPS,VahaPUR,VahaKER,VahaJednohoSroubu)","v":""},""]
[null,null,{"$f":"VLOOKUP(B20,'Seznam výkresů'!$A$2:$B$29,2,FALSE)","v":0},null,null,null,null,null,null,null,null,"","","","",{"$f":"VypDelSroA(I20,K20,O20,PresahSroubu,DelkySroubuArray)","v":""},{"$f":"VypZahloubeniSro(I20,O20,P20,PresahSroubu)","v":""},{"$f":"VypPocetSro(D20,E20,H20,K20,TVP,MDZVV,DVV)","v":""},{"$f":"VypVahy(D20,E20,F20,O20,H20,M20,N20,VahaXPS,VahaPUR,VahaKER,VahaJednohoSroubu)","v":""},""]
[null,null,{"$f":"VLOOKUP(B21,'Seznam výkresů'!$A$2:$B$29,2,FALSE)","v":0},null,null,null,null,null,null,null,null,"","","","",{"$f":"VypDelSroA(I21,K21,O21,PresahSroubu,DelkySroubuArray)","v":""},{"$f":"VypZahloubeniSro(I21,O21,P21,PresahSroubu)","v":""},{"$f":"VypPocetSro(D21,E21,H21,K21,TVP,MDZVV,DVV)","v":""},{"$f":"VypVahy(D21,E21,F21,O21,H21,M21,N21,VahaXPS,VahaPUR,VahaKER,VahaJednohoSroubu)","v":""},""]
[null,null,{"$f":"VLOOKUP(B22,'Seznam výkresů'!$A$2:$B$29,2,FALSE)","v":0},null,null,null,null,null,null,null,null,"","","","",{"$f":"VypDelSroA(I22,K22,O22,PresahSroubu,DelkySroubuArray)","v":""},{"$f":"VypZahloubeniSro(I22,O22,P22,PresahSroubu)","v":""},{"$f":"VypPocetSro(D22,E22,H22,K22,TVP,MDZVV,DVV)","v":""},{"$f":"VypVahy(D22,E22,F22,O22,H22,M22,N22,VahaXPS,VahaPUR,VahaKER,VahaJednohoSroubu)","v":""},""]
[null,null,{"$f":"VLOOKUP(B23,'Seznam výkresů'!$A$2:$B$29,2,FALSE)","v":0},null,null,null,null,null,null,null,null,"","","","",{"$f":"VypDelSroA(I23,K23,O23,PresahSroubu,DelkySroubuArray)","v":""},{"$f":"VypZahloubeniSro(I23,O23,P23,PresahSroubu)","v":""},{"$f":"VypPocetSro(D23,E23,H23,K23,TVP,MDZVV,DVV)","v":""},{"$f":"VypVahy(D23,E23,F23,O23,H23,M23,N23,VahaXPS,VahaPUR,VahaKER,VahaJednohoSroubu)","v":""},""]
[null,null,{"$f":"VLOOKUP(B24,'Seznam výkresů'!$A$2:$B$29,2,FALSE)","v":0},null,null,null,null,null,null,null,null,"","","","",{"$f":"VypDelSroA(I24,K24,O24,PresahSroubu,DelkySroubuArray)","v":""},{"$f":"VypZahloubeniSro(I24,O24,P24,PresahSroubu)","v":""},{"$f":"VypPocetSro(D24,E24,H24,K24,TVP,MDZVV,DVV)","v":""},{"$f":"VypVahy(D24,E24,F24,O24,H24,M24,N24,VahaXPS,VahaPUR,VahaKER,VahaJednohoSroubu)","v":""},""]
[null,null,{"$f":"VLOOKUP(B25,'Seznam výkresů'!$A$2:$B$29,2,FALSE)","v":0},null,null,null,null,null,null,null,null,"","","","",{"$f":"VypDelSroA(I25,K25,O25,PresahSroubu,DelkySroubuArray)","v":""},{"$f":"VypZahloubeniSro(I25,O25,P25,PresahSroubu)","v":""},{"$f":"VypPocetSro(D25,E25,H25,K25,TVP,MDZVV,DVV)","v":""},{"$f":"VypVahy(D25,E25,F25,O25,H25,M25,N25,VahaXPS,VahaPUR,VahaKER,VahaJednohoSroubu)","v":""},""]
[null,null,{"$f":"VLOOKUP(B26,'Seznam výkresů'!$A$2:$B$29,2,FALSE)","v":0},null,null,null,null,null,null,null,null,"","","","",{"$f":"VypDelSroA(I26,K26,O26,PresahSroubu,DelkySroubuArray)","v":""},{"$f":"VypZahloubeniSro(I26,O26,P26,PresahSroubu)","v":""},{"$f":"VypPocetSro(D26,E26,H26,K26,TVP,MDZVV,DVV)","v":""},{"$f":"VypVahy(D26,E26,F26,O26,H26,M26,N26,VahaXPS,VahaPUR,VahaKER,VahaJednohoSroubu)","v":""},""]
[null,null,{"$f":"VLOOKUP(B27,'Seznam výkresů'!$A$2:$B$29,2,FALSE)","v":0},null,null,null,null,null,null,null,null,"","","","",{"$f":"VypDelSroA(I27,K27,O27,PresahSroubu,DelkySroubuArray)","v":""},{"$f":"VypZahloubeniSro(I27,O27,P27,PresahSroubu)","v":""},{"$f":"VypPocetSro(D27,E27,H27,K27,TVP,MDZVV,DVV)","v":""},{"$f":"VypVahy(D27,E27,F27,O27,H27,M27,N27,VahaXPS,VahaPUR,VahaKER,VahaJednohoSroubu)","v":""},""]
[null,null,{"$f":"VLOOKUP(B28,'Seznam výkresů'!$A$2:$B$29,2,FALSE)","v":0},null,null,null,null,null,null,null,null,"","","","",{"$f":"VypDelSroA(I28,K28,O28,PresahSroubu,DelkySroubuArray)","v":""},{"$f":"VypZahloubeniSro(I28,O28,P28,PresahSroubu)","v":""},{"$f":"VypPocetSro(D28,E28,H28,K28,TVP,MDZVV,DVV)","v":""},{"$f":"VypVahy(D28,E28,F28,O28,H28,M28,N28,VahaXPS,VahaPUR,VahaKER,VahaJednohoSroubu)","v":""},""]
[null,null,{"$f":"VLOOKUP(B29,'Seznam výkresů'!$A$2:$B$29,2,FALSE)","v":0},null,null,null,null,null,null,null,null,"","","","",{"$f":"VypDelSroA(I29,K29,O29,PresahSroubu,DelkySroubuArray)","v":""},{"$f":"VypZahloubeniSro(I29,O29,P29,PresahSroubu)","v":""},{"$f":"VypPocetSro(D29,E29,H29,K29,TVP,MDZVV,DVV)","v":""},{"$f":"VypVahy(D29,E29,F29,O29,H29,M29,N29,VahaXPS,VahaPUR,VahaKER,VahaJednohoSroubu)","v":""},""]
[null,null,{"$f":"VLOOKUP(B30,'Seznam výkresů'!$A$2:$B$29,2,FALSE)","v":0},null,null,null,null,null,null,null,null,"","","","",{"$f":"VypDelSroA(I30,K30,O30,PresahSroubu,DelkySroubuArray)","v":""},{"$f":"VypZahloubeniSro(I30,O30,P30,PresahSroubu)","v":""},{"$f":"VypPocetSro(D30,E30,H30,K30,TVP,MDZVV,DVV)","v":""},{"$f":"VypVahy(D30,E30,F30,O30,H30,M30,N30,VahaXPS,VahaPUR,VahaKER,VahaJednohoSroubu)","v":""},""]
[null,null,{"$f":"VLOOKUP(B31,'Seznam výkresů'!$A$2:$B$29,2,FALSE)","v":0},null,null,null,null,null,null,null,null,"","","","",{"$f":"VypDelSroA(I31,K31,O31,PresahSroubu,DelkySroubuArray)","v":""},{"$f":"VypZahloubeniSro(I31,O31,P31,PresahSroubu)","v":""},{"$f":"VypPocetSro(D31,E31,H31,K31,TVP,MDZVV,DVV)","v":""},{"$f":"VypVahy(D31,E31,F31,O31,H31,M31,N31,VahaXPS,VahaPUR,VahaKER,VahaJednohoSroubu)","v":""},""]
[null,null,{"$f":"VLOOKUP(B32,'Seznam výkresů'!$A$2:$B$29,2,FALSE)","v":0},null,null,null,null,null,null,null,null,"","","","",{"$f":"VypDelSroA(I32,K32,O32,PresahSroubu,DelkySroubuArray)","v":""},{"$f":"VypZahloubeniSro(I32,O32,P32,PresahSroubu)","v":""},{"$f":"VypPocetSro(D32,E32,H32,K32,TVP,MDZVV,DVV)","v":""},{"$f":"VypVahy(D32,E32,F32,O32,H32,M32,N32,VahaXPS,VahaPUR,VahaKER,VahaJednohoSroubu)","v":""},""]

{"sheet":"Seznam výkresů","index":1,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Seznam čísel výkresů"]
[0,0]
["UNI 30 BEZ","UNI PUR 30-BEZ/0"]
["UNI 40 BEZ","UNI PUR 40-BEZ/0"]
["UNI 50 BEZ","UNI PUR 50-BEZ/0"]
["UNI 60 BEZ","UNI PUR 60-BEZ/0"]
["UNI 70 BEZ","UNI PUR 70-BEZ/0"]
["UNI 80 BEZ","UNI PUR 80-BEZ/0"]
["UNI 90 BEZ","UNI PUR 90-BEZ/0"]

{"sheet":"Vypocet","index":2,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Materiál",null,"Vrtání",null,"Poh výška",null,"Šrouby",null,"Delky šroubů",null,"TypVrtani",null,"Koef delky šroubu",0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Přesah šroubu",20]
[null,"PUR",null,"Ne",null,"Ano",null,"Ano",null,38,null,"Sym",null,"Tlouštka vnitřní příčky",50]
[null,"KER",null,"Sym",null,"Ne",null,"Ne",null,60,null,"Asym",null,"Min Delka vnitřní výplně",100]
[null,"PUR HS",null,"Asym",null,null,null,null,null,80,null,null,null,"Delka vnitřní výplně",400]
[null,"KER HS",null,"Výkres",null,null,null,null,null,100,null,null,null,"VahaXPS",120]
[null,null,null,null,null,null,null,null,null,120,null,null,null,"VahaPUR",550]
[null,null,null,null,null,null,null,null,null,140,null,null,null,"VahaKER",180]
[null,null,null,null,null,null,null,null,null,160,null,null,null,"VahaJednohoSroubu",2.2000000000000001E-3]
[null,null,null,null,null,null,null,null,null,180]
[null,null,null,null,null,null,null,null,null,200]