{"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":[[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],[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],[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],[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]]}
["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,"Stará 205, 789 61, Bludov"]
[null,null,"Adresa dodání:",null,null,null,null,null,null,"ks:",null,"Provozovna:"]
[null,null,"Kontakt:",null,null,null,null,null,null,{"$f":"SUM(E15:E32)","v":0},null,"ul. Žerotínova 87, 787 01, Šumperk"]
[null,null,"Zakázka:",null,null,null,null,null,null,null,null,"bývalý areál Moravolenu (Bělidlo)"]
[]
[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,"Poznámka","(Čí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,null,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":"VypDelSro(I15,K15,O15,PresahSroubu,KoefDelSroubu,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,null,null,null,null,null,null,null,null,null,"","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q17","v":""},"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","",""]

{"sheet":"Seznam výkresů","index":1,"n_rows":29,"n_cols":2,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Seznam čísel výkresů"]
[]
[1,"UNI PUR 30-BEZ/0"]
[2,"UNI PUR 40-BEZ/0"]
[3,"UNI PUR 50-BEZ/0"]
[4,"UNI PUR 60-BEZ/0"]
[5,"UNI PUR 70-BEZ/0"]
[6,"UNI PUR 80-BEZ/0"]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]

{"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,"Šroub",null,38,null,"Sym",null,"Tlouštka vnitřní příčky",50]
[null,"KER",null,"Sym",null,"Ne",null,"Vrut",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]