{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["vypocet","profily"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"vypocet","index":0,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[null,"Výpočet odolne pricky",null,null,null,null,null,null,null,null,"Kontakt: fajman@fsv.cvut.cz"]
[null,"ZADÁNÍ"]
[null,"Rozměry pricky",null,null,null,"Plošné zatížení"]
[null,"vyýška pricky (h) =",1.5,"m",null,"Norma (kombinace)","EN-CSN"]
[null,"šířka pricky(b) =",1.2,"m",null,"Zat svisle od tíhy fg =",{"$f":"getZatizeniTiha(C26/1000, C6,  D18, GetDeska(C18,profily!A27:E30,\"G\"),  D20, IF(C20=0,0,GetDeska(C20,profily!A27:E30,\"G\")), C17)","v":0.15492},"kN/m"]
[null,"vzdalenost  profilu (bn) =",0.6,"m",null,"Zatížení   fw =",0,"kN/m2"]
[null,"celkový počet polí =",{"$f":"C5/C6","v":2},"ks",null,"Zatížení   svisle fn=",0,"kN/m2"]
[]
[]
[null,"Nosná konstrukce příčky",null,null,null,"Ram konstrukce"]
[null,"Zakladni svislý profil","CW 125/50/0,6",{"$f":"GetMaterial(profily!A4:O22,profily!B38:J43, C11, 1)","v":"DX51D"},null,"Zakladni profil","UW 100/40/0,6","A (x10-3 m2)=",{"$f":"GetAiWiIiOcel(G11,0, profily!A4:O22)","v":0.10700000000000001}]
[null,"Pridany profil , propojení",null,0,null,"materiál",{"$f":"GetMaterial(profily!A4:O22,profily!B38:J43, G11, 1)","v":"DX51D"},"I  (x10-6 m4)=",0.1668]
[null,{"$f":"\"ocel \"   &D11&\n\"        E(GPa), Ryd(MPa)\"","v":"ocel DX51D        E(GPa), Ryd(MPa)"},210,{"$f":"GetMaterial(profily!A4:O22,profily!B38:J43, C11, 3)","v":260.86956521739131},null,null,null,"Wmin (x10-6 m3)=",3.3359999999999999]
[null,null,null,null,null,"Kotveni ramu"]
[null,null,null,null,null,"Kotva vzd. Od sloupku",0.09]
[null,"Desky",null,null,null,"prumer d (m)=",0.02,"A (x10-3 m2)=",{"$f":"1000*3.14*G16*G16/4","v":0.314}]
[null,"jedno / oboustranné","jedno ",null,null,"delka L (m)=",0.15,"Aos (x10-3 m2) =",{"$f":"1000*3.14*G16/2*G17","v":4.71}]
[null,"deska 1  a tl. (m)","Torro",0.01,null,"material kotvy=","10_9","Aot (x10-3 m2) =",{"$f":"1000*G16*G17","v":3}]
[null,{"$f":"\"E(GPa), Ry(MPa)\"","v":"E(GPa), Ry(MPa)"},{"$f":"GetDeska(C18,profily!A27:E30,\"E\")","v":10},{"$f":"GetDeska(C18,profily!A27:E30,\"RY\")","v":10},null,"fy (Mpa)=",{"$f":"VLOOKUP(G18,profily!B46:H52,2,0)","v":900}]
[null,"deska 2  a tl. (m)","SDK",1.2E-2,null,"Beton","C25/30"]
[null,{"$f":"\"E(GPa), Ry(MPa)\"","v":"E(GPa), Ry(MPa)"},{"$f":"IF(C20=0,0,GetDeska(C20,profily!A27:E30,\"E\"))","v":2.2000000000000002},{"$f":"IF(C20=0,0,GetDeska(C20,profily!A27:E30,\"RY\"))","v":5},null,"fctk 0,05 (Mpa)=",{"$f":"VLOOKUP(G20,profily!B55:H60,5,0)","v":1.8},"Nk=A.Ry/1,3 = (kN)\nNk=Aos. 2,25.fctd/1,5 ",{"$f":"MIN(I16*G19/1.3, I17*G21*2.25/1.5)","v":12.716999999999999}]
[null,null,null,null,null,"fck  (Mpa)=",{"$f":"VLOOKUP(G20,profily!B55:H60,2,0)","v":25},"Vk=0,6A.Ry/1,3 = (kN)     Vk=Aot. fctd/1,5 ",{"$f":"MIN(I18*G22/1.5, 0.6*I16*G19/1.3)","v":50}]
[null,{"$f":"\"míra propojení P x D \"","v":"míra propojení P x D "},0.5]
[]
[null,"Svisly profil ","Nosnik","Deska","spojení"]
[null,"A (x10-3 m2)=",{"$f":"GetAiWiIiOcel(C11,C12, profily!A4:O22)","v":0.13999999999999999},{"$f":"GetAiIiWiDeska(C20, D18,D20,C6,C19/C21)","v":7.5840000000000005},{"$f":"GetAiIiWiSpoj(C26:C30, D26:D30,C17, C23,C13/C19)","v":0}]
[null,"I  (x10-6 m4)=",0.34210000000000002,6.9008E-2,2.3025911106043337]
[null,"Wmin (x10-6 m3)=",5.4736000000000002,13.167999999999999,20.764976996947823]
[null,"horni",-6.25E-2,-6.0000000000000001E-3]
[null,"dolni",6.25E-2,5.0000000000000001E-3]
[null,"pomer h/t",208.33333333333334]
[null,"Ry (Mpa)=",{"$f":"D13","v":260.86956521739131},{"$f":"D19","v":10}]
[null,null,null,null,null,"ŘEŠENÍ"]
[null,"Výpočet únosnosti",null,null,null,null,"Vyhodnocení"]
[null,"Unosnost svislého profilu ",null,"N=",{"$f":"-G5*C4-G7*C6","v":-0.23238},"kN",{"$f":"IF(G4=\"EN-CSN\",\"EN Mimořádná kombinace zatížení- fw+fg\",  \"kombinace zatížení fw+fg\")","v":"EN Mimořádná kombinace zatížení- fw+fg"}]
[null,null,null,"M=",{"$f":"GetMV(E35,C4,C17,C26:E26,C27:E27,C28:E28,C31,C32:D32,C13/C19)","v":4.8121024983715515},"kN/m","Svislý profil"]
[null,null,null,"Mpl=",6.7174130865655863,"kN/m","fw=",{"$f":"GetFV(E37, E38,G6,C4,C6 )","v":39.806892364833104},"kN/m2"]
[null,null,null,"V=",43.718839589962869,"kN","Reakce Vd=",17.913101564174898,"kN"]
[null,"Unosnost ramu",null,"M=",{"$f":"GetRam_MV(I11, I13, D13 )","v":0.75674858223062391},"kN/m","rozhodujici","moment"]
[null,null,null,"V=",14.01356797050056,"kN","RAM",{"$f":"GetRamPosudek(H38, E40,E39,G15,C6 )","v":1.2782684325564411},"< 1"]
[null,"Unosnost kotvení ",null,"V=",{"$f":"I22","v":50},"kN",null,"zesilit ram V"]
[null,null,null,"N=",{"$f":"I21","v":12.716999999999999},"kN","Kotveni",{"$f":"GetKotveniPosudek(H38, E41 )","v":0.35826203128349798},"< 1"]
[null,null,null,null,null,null,null,"kotveni OK"]

{"sheet":"profily","index":1,"n_rows":60,"n_cols":15,"rows_kept":60,"cut":false,"hidden":false,"merged":[[1,0,2,0]]}
["Průřezové hodnoty profilů Knauf"]
["Profil","material",null,null,"Fläche","Flächenträgheitsmoment",null,"Abstand d. Schwerachse",null,"Widerstandsmoment um Achse"]
[null,null,"H             cm","tl          cm","A                      cm²","IY                   cm4","IZ                                 cm4","dolni zd cm","horni zh cm","y - WYMAX cm3","y - WYMIN cm3","z - WYMAX cm3","z - WYMIN cm3","i (cm)"]
["CD 60/27/0,6","DX51D",6,0.06,0.74,0.69,4.3899999999999997,1.99,2.97,{"$f":"2*F4/C4","v":0.22999999999999998},{"$f":"2*F4/C4","v":0.22999999999999998}]
["CW 50/50/0,6","DX51D",5,0.06,0.95,4.3099999999999996,3.07,2.41,1.9,1.79,1.79,null,null,{"$f":"SQRT(F5/E5)","v":2.1299864096428309},{"$f":"SQRT(G5/E5)","v":1.7976592967991518}]
["CW 75/50/0,6","DX51D",7.5,0.06,1.1000000000000001,10.68,3.54,3.66,1.64,2.92,2.92,null,null,{"$f":"SQRT(F6/E6)","v":3.1159414161840249},{"$f":"SQRT(G6/E6)","v":1.7939291563999449}]
["CW 100/50/0,6","DX51D",10,0.06,1.25,20.49,3.89,4.91,1.44,4.17,4.17,null,null,{"$f":"SQRT(F7/E7)","v":4.0487034961824504},{"$f":"SQRT(G7/E7)","v":1.7640861656959956}]
["CW 125/50/0,6","DX51D",12.5,0.06,1.4,34.21,4.17,6.16,1.29,5.55,5.55,null,null,{"$f":"SQRT(F8/E8)","v":4.9432493651154488},{"$f":"SQRT(G8/E8)","v":1.7258538259572938}]
["CW 150/50/0,6","DX51D",15,0.06,1.55,52.3,4.4000000000000004,7.41,1.1599999999999999,7.06,7.06,null,null,{"$f":"SQRT(F9/E9)","v":5.8087808948066693},{"$f":"SQRT(G9/E9)","v":1.6848470783484639}]
["UW 50/40/0,6","DX51D",5,0.06,0.77,3.51,1.35,2.4700000000000002,1.22,1.42,1.42]
["UW 75/40/0,6","DX51D",7.5,0.06,0.92,8.65,1.53,3.72,1.03,2.33,2.33]
["UW 100/40/0,6","DX51D",10,0.06,1.07,16.68,1.67,4.97,0.88,3.36,3.36]
["UA 50/40/2,0","DX51D",5,0.2,2.5,10.25,4.2,2.34,1.22,4.38,4.38,null,null,{"$f":"SQRT(F13/E13)","v":2.0248456731316584},{"$f":"SQRT(G13/E13)","v":1.2961481396815722}]
["UA 75/40/2,0","DX51D",7.5,0.2,3,26.28,4.82,3.59,1.02,7.32,7.32,null,null,{"$f":"SQRT(F14/E14)","v":2.9597297173897483},{"$f":"SQRT(G14/E14)","v":1.2675435561221029}]
["UA 100/40/2,0","DX51D",10,0.2,3.5,51.66,5.26,4.84,0.87,10.67,10.67,null,null,{"$f":"SQRT(F15/E15)","v":3.8418745424597094},{"$f":"SQRT(G15/E15)","v":1.2259107401671392}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Materiál","g (kN/m3)","sig. Max (Mpa)","E1       (Gpa)"]
["VPKD",28,15,15]
["Torro",12,10,10]
["Cetris",14,9,5.7]
["SDK",10,5,2.2000000000000002]
[]
[]
[null,"Tabulka pevností ocelové výztuže"]
[]
["Tabulka pevností"]
["material","trida pevnosti","mez kluzu (0,2) fy [MPa]","navrhova pevnost fdy","pevnost v tahu","pevnost ve smyku","E","tiha","beta","gama"]
["ocelove vyvalky"]
["11373-378","S235",235,{"$f":"C38/J38","v":204.34782608695653},360,{"$f":"C38/SQRT(3)","v":135.67731325956206},210,78,0.8,1.1499999999999999]
["11443-449","S275",275,{"$f":"C39/J39","v":239.13043478260872},430,{"$f":"C39/SQRT(3)","v":158.7713240271471},210,78,0.85,1.1499999999999999]
["11503-523","S355",355,{"$f":"C40/J40","v":308.69565217391306},490,{"$f":"C40/SQRT(3)","v":204.95934556231717},210,78,0.9,1.1499999999999999]
[null,"S420",420,{"$f":"C41/J41","v":365.21739130434787},500,null,210,78,null,1.1499999999999999]
[null,"S460",460,400.00000000000006,530,null,210,78,null,1.1499999999999999]
["ocelovy plech","DX51D","140-270",{"$f":"300/J43","v":260.86956521739131},"270-500",{"$f":"D43/SQRT(3)","v":150.61311370164151},210,78,null,1.1499999999999999]
[]
[]
["srouby","4_6",240,null,400,null,null,1.45]
[null,"4_8",320,null,400,null,null,1.45]
[null,"5_6",300,null,500,null,null,1.45]
[null,"5_8",400,null,500,null,null,1.45]
[null,"6_8",400,null,500,null,null,1.45]
[null,"8_8",640,null,800,null,null,1.45]
[null,"10_9",900,null,1000,null,null,1.45]
[]
["Beton","třída","fck ","fcm ","fctm ","fctk 0,05 ","fctk 0,95 ","Trd"]
[null,"C12/15",12,20,1.6,1.1000000000000001,2,0.18]
[null,"C16/20",16,24,1.9,1.3,2.5,0.22]
[null,"C20/25",20,28,2.2000000000000002,1.5,2.9,0.26]
[null,"C25/30",25,33,2.6,1.8,3.3,0.3]
[null,"C30/37",30,38,2.9,2,3.8,0.34]
[null,"C35/45",35,43,3.2,2.2000000000000002,4.2,0.37]