{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["hd_220","List2","List3"],"not_rendered":{"charts":0,"images":45,"macros":1,"external_links":0,"defined_names":138,"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":"hd_220","index":0,"n_rows":351,"n_cols":15,"rows_kept":351,"cut":false,"hidden":false,"merged":[[325,11,325,12],[336,11,336,12],[285,11,285,12],[289,11,289,12],[174,11,174,12],[183,11,183,12]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"JV_ukazvzorec(E1)","v":""}]
[null,null,"LEGENDA",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"vstupní hodnoty",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"vstupní hodnoty | výstup odjinud -> vstup",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"výsledek",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"výsledek dílčí",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"výsledek rozhodující, posouzení",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,"VSTUPNÍ PARAMETRY",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"MATERIÁLY",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"OCEL B500B",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Ecm","=",32,"GPa",null,null,null,null,null,null,null,null,{"$f":"JV_ukazvzorec(E12)","v":"32"}]
[null,null,"fyk","=",500,"MPa",null,null,null,null,null,null,null,null,{"$f":"JV_ukazvzorec(E13)","v":"500"}]
[null,null,"fyd","=",{"$f":"fyk/1.15","v":434.78260869565219},"MPa",null,null,null,null,null,null,null,null,"=fyk/1.15"]
[null,null,"BETON C30/37",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"cement:",null,"třída N",null,null,null,null,null,null,null,null,null,"třída N"]
[null,null,"Es",null,200,"GPa",null,null,null,null,null,null,null,null,"200"]
[null,null,"fck","=",30,"MPa",null,null,null,null,null,null,null,null,"30"]
[null,null,"fcd","=",{"$f":"fck/1.5","v":20},"Mpa",null,null,null,null,null,null,null,null,"=fck/1.5"]
[null,null,"fctm","=",2.9,"Mpa",null,null,null,null,null,null,null,null,"2.9"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"GEOMETRIE",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,"hslab","=",220,"mm",null,null,null,null,null,null,null,null,"220"]
[null,null,"bslab","=",1000,"mm",null,null,null,null,null,null,null,null,"1000"]
[null,null,"cd,top","=",25,"mm",null,null,null,null,null,null,null,null,"25"]
[null,null,"cd,bot","=",30,"mm",null,null,null,null,null,null,null,null,"30"]
[null,null,"bslab","=",1000,"mm",null,null,null,null,null,null,null,null,"1000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Lx","=",7800,"mm"]
[null,null,"Ly","=",11700,"mm"]
[]
[null,null,"VYZTUŽENÍ",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,"směr X",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Ø2,x","=",8,"mm","/",150,"mm",null,null,null,null,null,"8"]
[null,null,"Ø1,x","=",12,"mm","/",180,"mm",null,null,null,null,null,"12"]
[null,null,"d2,x","=",{"$f":"cd_top+prumer_2_x/2","v":29},"mm",null,null,null,null,null,null,null,null,"=cd_top+prumer_2_x/2"]
[null,null,"d,x","=",{"$f":"h_slab-cd_bot-prumer_1_x/2","v":184},"mm",null,null,null,null,null,null,null,null,"=h_slab-cd_bot-prumer_1_x/2"]
[null,null,"d1,x","=",{"$f":"cd_bot+prumer_1_x/2","v":36},"mm",null,null,null,null,null,null,null,null,"=cd_bot+prumer_1_x/2"]
[null,null,"As,2,x","=",{"$f":"1000/H36*PI()*prumer_2_x*prumer_2_x/4","v":335.10321638291128},"mm2",null,null,null,null,null,null,null,null,"=1000/H36*PI()*prumer_2_x*prumer_2_x/4"]
[null,null,"As,1,x","=",{"$f":"1000/H37*PI()*prumer_1_x*prumer_1_x/4","v":628.31853071795854},"mm2",null,null,null,null,null,null,null,null,"=1000/H37*PI()*prumer_1_x*prumer_1_x/4"]
[null,null,"směr Y",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Ø2,y","=",8,"mm","/",150,"mm",null,null,null,null,null,"8"]
[null,null,"Ø1,y","=",10,"mm","/",180,"mm",null,null,null,null,null,"10"]
[null,null,"d2,y","=",{"$f":"cd_top+prumer_2_x+prumer_2_y/2","v":37},"mm",null,null,null,null,null,null,null,null,"=cd_top+prumer_2_x+prumer_2_y/2"]
[null,null,"d,y","=",{"$f":"h_slab-cd_bot-prumer_1_x-prumer_1_y/2","v":173},"mm",null,null,null,null,null,null,null,null,"=h_slab-cd_bot-prumer_1_x-prumer_1_y/2"]
[null,null,"d1,y","=",{"$f":"cd_bot+prumer_1_x+prumer_1_y/2","v":47},"mm",null,null,null,null,null,null,null,null,"=cd_bot+prumer_1_x+prumer_1_y/2"]
[null,null,"As,2,y","=",{"$f":"1000/H44*PI()*prumer_2_y*prumer_2_y/4","v":335.10321638291128},"mm2",null,null,null,null,null,null,null,null,"=1000/H44*PI()*prumer_2_y*prumer_2_y/4"]
[null,null,"As,1,y","=",{"$f":"1000/H45*PI()*prumer_1_y*prumer_1_y/4","v":436.33231299858232},"mm2",null,null,null,null,null,null,null,null,"=1000/H45*PI()*prumer_1_y*prumer_1_y/4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"KRÁTKODOBÉ ZATÍŽENÍ",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"PRŮŘEZ BEZ TRHLIN - CHARAKTERISTIKY",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"alpha_e","=",{"$f":"Es/Ecm","v":6.25},null,null,null,null,null,null,null,null,null,"=Es/Ecm"]
[null,null,null,null,null,null,{"$f":"JV_ukazvzorec(E54)","v":"=Es/Ecm"},null,null,null,null,null,null,null,""]
[null,null,"plocha ideálního průřezu",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"AI,x","=",{"$f":"h_slab*b_slab+alpha_e*(As_1_x+As_2_x)","v":226021.38591938044},"mm2",null,null,null,null,null,null,null,null,"=h_slab*b_slab+alpha_e*(As_1_x+As_2_x)"]
[null,null,null,null,null,null,{"$f":"JV_ukazvzorec(E57)","v":"=h_slab*b_slab+alpha_e*(As_1_x+As_2_x)"},null,null,null,null,null,null,null,""]
[null,null,"AI,y","=",{"$f":"h_slab*b_slab+alpha_e*(As_1_y+As_2_y)","v":224821.47205863433},"mm2",null,null,null,null,null,null,null,null,"=h_slab*b_slab+alpha_e*(As_1_y+As_2_y)"]
[null,null,"vzdálenost těžiště ideálního průřezu od horního okraje",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"aI,x","=",{"$f":"(h_slab*b_slab*h_slab/2+alpha_e*(As_1_x*d_x+As_2_x*d_2_x))/plocha_i_x","v":110.53513218083862},"mm",null,null,null,null,null,null,null,null,"=(h_slab*b_slab*h_slab/2+alpha_e*(As_1_x*d_x+As_2_x*d_2_x))/plocha_i_x"]
[null,null,"aI,y","=",{"$f":"(h_slab*b_slab*h_slab/2+alpha_e*(As_1_y*d_y+As_2_y*d_2_y))/plocha_i_y","v":110.08413344862164},"mm",null,null,null,null,null,null,null,null,"=(h_slab*b_slab*h_slab/2+alpha_e*(As_1_y*d_y+As_2_y*d_2_y))/plocha_i_y"]
[null,null,"moment setrvačnosti ideálního průřezu",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"II,x","=",{"$f":"1/12*b_slab*h_slab^3+b_slab*h_slab*(vzdalenost_i_x-h_slab/2)^2+alpha_e*(As_1_x*(d_x-vzdalenost_i_x)^2+As_2_x*(vzdalenost_i_x-d_2_x)^2)","v":922514136.37182832},"mm4",null,null,null,null,null,null,null,null,"=1/12*b_slab*h_slab^3+b_slab*h_slab*(vzdalenost_i_x-h_slab/2)^2+alpha_e*(As_1_x*(d_x-vzdalenost_i_x)^2+As_2_x*(vzdalenost_i_x-d_2_x)^2)"]
[null,null,"II,y","=",{"$f":"1/12*b_slab*h_slab^3+b_slab*h_slab*(vzdalenost_i_y-h_slab/2)^2+alpha_e*(As_1_y*(d_y-vzdalenost_i_y)^2+As_2_y*(vzdalenost_i_y-d_2_y)^2)","v":909316541.88864172},"mm4",null,null,null,null,null,null,null,null,"=1/12*b_slab*h_slab^3+b_slab*h_slab*(vzdalenost_i_y-h_slab/2)^2+alpha_e*(As_1_y*(d_y-vzdalenost_i_y)^2+As_2_y*(vzdalenost_i_y-d_2_y)^2)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"DLOUHODOBÉ ZATÍŽENÍ",null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,"ts","=",7,"d",null,"- doba ošetřování ",null,null,null,null,null,null,"7"]
[null,null,"t0","=",28,"d",null,"- začátek púsobení zatížení",null,null,null,null,null,null,"28"]
[null,null,"tinf","=",18250,"d",null,"- posouzení na konci životnosti (50let = 50*365=18250 dnů)",null,null,null,null,null,null,"18250"]
[null,null,"RH","=",50,"%",null,"- vlhokost okolního prostředí (horší z hodnot => interiér na horním povrchu)",null,null,null,null,null,null,"50"]
[]
[null,null,"h0","=",220,"mm",null,"- náhradní obvod",null,null,null,null,null,null,"220"]
[]
[null,null,"fi","=",2.35,null,null,"- součinitel dotvarování (odečtěno z grafu)",null,null,null,null,null,null,"2.35"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"PRŮŘEZ BEZ TRHLIN - CHARAKTERISTIKY",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"efektivní modul pružnosti",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Ec,ef","=",{"$f":"Ecm/(1+fi)","v":9.5522388059701484},"GPa",null,null,null,null,null,null,null,null,"=Ecm/(1+fi)"]
[null,null,"alphae,ef","=",{"$f":"Es/Ec_ef","v":20.937500000000004},null,null,null,null,null,null,null,null,null,"=Es/Ec_ef"]
[null,null,"plocha ideálního průřezu",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"AI,ef,x","=",{"$f":"h_slab*b_slab+alpha_e_ef*(As_1_x+As_2_x)","v":240171.64282992447},"mm2",null,null,null,null,null,null,null,null,{"$f":"JV_ukazvzorec(E83)","v":"=h_slab*b_slab+alpha_e_ef*(As_1_x+As_2_x)"}]
[null,null,"AI,ef,y","=",{"$f":"h_slab*b_slab+alpha_e_ef*(As_1_y+As_2_y)","v":236151.93139642503},"mm2",null,null,null,null,null,null,null,null,"=h_slab*b_slab+alpha_e_ef*(As_1_y+As_2_y)"]
[null,null,"vzdálenost těžiště ideálního průřezu od horního okraje",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"aI,ef,x","=",{"$f":"(h_slab*b_slab*h_slab/2+alpha_e_ef*(As_1_x*d_x+As_2_x*d_2_x))/plocha_i_ef_x","v":111.68707224434348},"mm",null,null,null,null,null,null,null,null,"=(h_slab*b_slab*h_slab/2+alpha_e_ef*(As_1_x*d_x+As_2_x*d_2_x))/plocha_i_ef_x"]
[null,null,"aI,ef,y","=",{"$f":"(h_slab*b_slab*h_slab/2+alpha_e_ef*(As_1_x*d_y+As_2_y*d_2_y))/plocha_i_ef_y","v":113.21308126862657},"mm",null,null,null,null,null,null,null,null,"=(h_slab*b_slab*h_slab/2+alpha_e_ef*(As_1_x*d_y+As_2_y*d_2_y))/plocha_i_ef_y"]
[null,null,"moment setrvačnosti ideálního průřezu",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"II,ef,x","=",{"$f":"1/12*b_slab*h_slab^3+b_slab*h_slab*(vzdalenost_i_ef_x-h_slab/2)^2+alpha_e_ef*(As_1_x*(d_x-vzdalenost_i_ef_x)^2+As_2_x*(vzdalenost_i_ef_x-d_2_x)^2)","v":1004722272.4745787},"mm4",null,null,null,null,null,null,null,null,"=1/12*b_slab*h_slab^3+b_slab*h_slab*(vzdalenost_i_ef_x-h_slab/2)^2+alpha_e_ef*(As_1_x*(d_x-vzdalenost_i_ef_x)^2+As_2_x*(vzdalenost_i_ef_x-d_2_x)^2)"]
[null,null,"II,ef,y","=",{"$f":"1/12*b_slab*h_slab^3+b_slab*h_slab*(vzdalenost_i_ef_y-h_slab/2)^2+alpha_e_ef*(As_1_y*(d_y-vzdalenost_i_ef_y)^2+As_2_y*(vzdalenost_i_ef_y-d_2_y)^2)","v":963013224.4679209},"mm4",null,null,null,null,null,null,null,null,"=1/12*b_slab*h_slab^3+b_slab*h_slab*(vzdalenost_i_ef_y-h_slab/2)^2+alpha_e_ef*(As_1_y*(d_y-vzdalenost_i_ef_y)^2+As_2_y*(vzdalenost_i_ef_y-d_2_y)^2)"]
[null,null,"=> ohybový moment při vzniku trhlin",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,"mcr,x","=",{"$f":"fctm*I_i_ef_x/(h_slab-vzdalenost_i_ef_x)/1000/1000","v":26.900709366376756},"kNm/m'",null,null,null,null,null,null,null,null,"=fctm*I_i_ef_x/(h_slab-vzdalenost_i_ef_x)/1000/1000"]
[null,null,"mcr,y",null,{"$f":"fctm*I_i_ef_y/(h_slab-vzdalenost_i_ef_y)/1000/1000","v":26.152438745631482},"kNm/m'",null,"(moment ve směru y není v tomto případě rozhodující)",null,null,null,null,null,null,"=fctm*I_i_ef_y/(h_slab-vzdalenost_i_ef_y)/1000/1000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"POSOUZENÍ VZNIKU TRHLIN",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,"kvazistálá kombinace",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"mE,qp","=",24.11,"kNm/m'",null,{"$f":"IF(E99<M_cr,\"<\",\">\")","v":"<"},{"$f":"M_cr","v":26.900709366376756},"= mcr",{"$f":"IF(E99<I99,\"=> trhliny NEVZNIKNOU\",\"trhliny VZIKNOU\")","v":"=> trhliny NEVZNIKNOU"},"  (příčky jako stálé)",null,null,"24.11"]
[null,null,"mE,qp","=",21.82,"kNm/m'",null,{"$f":"IF(E100<M_cr,\"<\",\">\")","v":"<"},{"$f":"M_cr","v":26.900709366376756},"= mcr",{"$f":"IF(E100<I100,\"=> trhliny NEVZNIKNOU\",\"trhliny VZIKNOU\")","v":"=> trhliny NEVZNIKNOU"},"  (příčky jako proměnné)",null,null,"21.82"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"častá kombinace",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"mE,fr","=",23.29,"kNm/m'",null,{"$f":"IF(E103<M_cr,\"<\",\">\")","v":"<"},{"$f":"M_cr","v":26.900709366376756},"= mcr",{"$f":"IF(E103<I103,\"=> trhliny NEVZNIKNOU\",\"trhliny VZIKNOU\")","v":"=> trhliny NEVZNIKNOU"},"  (příčky jako proměnné)",null,null,"23.29"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"charakteristická kombinace",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"mE,k","=",27.17,"kNm/m'",null,{"$f":"IF(E106<M_cr,\"<\",\">\")","v":">"},{"$f":"M_cr","v":26.900709366376756},"= mcr",{"$f":"IF(E106<I106,\"=> trhliny NEVZNIKNOU\",\"=> trhliny VZNIKAJÍ\")","v":"=> trhliny VZNIKAJÍ"},"  (příčky jako proměnné)",null,null,"27.17"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"PRŮŘEZ S TRHLINAMI - CHARAKTERISTIKY",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"vzdálenost neutrální osy od tlačeného okraje",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"xcr,ef,x","=",{"$f":"alpha_e_ef/b_slab*(As_1_x+As_2_x)*(-1+SQRT(1+(2*b_slab/alpha_e_ef)*((As_1_x*d_x+As_2_x*d_2_x)/(As_1_x+As_2_x)^2)))","v":55.028293486770067},"mm",null,null,null,null,null,null,null,null,"=alpha_e_ef/b_slab*(As_1_x+As_2_x)*(-1+SQRT(1+(2*b_slab/alpha_e_ef)*((As_1_x*d_x+As_2_x*d_2_x)/(As_1_x+As_2_x)^2)))"]
[null,null,"xcr,ef,y","=",{"$f":"alpha_e_ef/b_slab*(As_1_y+As_2_y)*(-1+SQRT(1+(2*b_slab/alpha_e_ef)*((As_1_y*d_y+As_2_y*d_2_y)/(As_1_y+As_2_y)^2)))","v":46.625774309479823},"mm",null,null,null,null,null,null,null,null,"=alpha_e_ef/b_slab*(As_1_y+As_2_y)*(-1+SQRT(1+(2*b_slab/alpha_e_ef)*((As_1_y*d_y+As_2_y*d_2_y)/(As_1_y+As_2_y)^2)))"]
[null,null,"moment setvračnosti potrhaného průřezu",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"III,ef,x","=",{"$f":"1/3*b_slab*x_cr_ef_x^3+alpha_e_ef*(As_1_x*(d_x-x_cr_ef_x)^2+As_2_x*(x_cr_ef_x-d_2_x)^2)","v":279120571.81197876},"mm4",null,null,null,null,null,null,null,null,{"$f":"JV_ukazvzorec(E113)","v":"=1/3*b_slab*x_cr_ef_x^3+alpha_e_ef*(As_1_x*(d_x-x_cr_ef_x)^2+As_2_x*(x_cr_ef_x-d_2_x)^2)"}]
[null,null,"III,ef,y","=",{"$f":"1/3*b_slab*x_cr_ef_y^3+alpha_e_ef*(As_1_y*(d_y-x_cr_ef_y)^2+As_2_y*(x_cr_ef_y-d_2_y)^2)","v":180338976.94793439},"mm4",null,null,null,null,null,null,null,null,{"$f":"JV_ukazvzorec(E114)","v":"=1/3*b_slab*x_cr_ef_y^3+alpha_e_ef*(As_1_y*(d_y-x_cr_ef_y)^2+As_2_y*(x_cr_ef_y-d_2_y)^2)"}]
[null,null,"rozdělovací součinitel",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Trhliny se v průžezu pro posuzovanou (kvazistálou) kombinaci zatížení neobjeví. ",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Během živostnosti vzniknou (charakteristická kombinace).",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"=>  mE,qp = mcr",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"// pro stanovení váženého momentu setrvačnosti je moment při kvazistálé hodnotě zatížení ",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"// uvažován jako moment při vzniku trhin",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"beta","=",0.5,null,"- dlouhodobě působící, mnohonásobně se opakující zatížení",null,null,null,null,null,null,null,"0.5"]
[null,null,"zeta","=",{"$f":"1-beta*(M_cr/M_cr)^2","v":0.5},null,null,null,null,null,null,null,null,null,"=1-beta*(M_cr/M_cr)^2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"vážený moment setrvačnosti",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Ilt,x","=",{"$f":"I_i_ef_x*I_ii_ef_x/(zeta*I_i_ef_x+(1-zeta)*I_ii_ef_x)","v":436873806.5618574},"mm4",null,null,null,null,null,null,null,null,"=I_i_ef_x*I_ii_ef_x/(zeta*I_i_ef_x+(1-zeta)*I_ii_ef_x)"]
[null,null,"Ilt,y","=",{"$f":"I_i_ef_y*I_ii_ef_y/(zeta*I_i_ef_y+(1-zeta)*I_ii_ef_y)","v":303788840.34651059},"mm4",null,null,null,null,null,null,null,null,"=I_i_ef_y*I_ii_ef_y/(zeta*I_i_ef_y+(1-zeta)*I_ii_ef_y)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"PRŮHYB PŘI KVAZISTÁLÉ KOMBINACI ZATÍŽENÍ",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"elastický průhyb (lineární)",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"fel","=",4.5999999999999996,"mm",null,"SCIA Engineer",null,null,null,null,null,null,"4.6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"průhyb při dlouhodobém zatížení (efektivní hodnoty - dotvarování, trhliny) | působení v jednom směru",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,"flt,qp,x","=",{"$f":"f_el*Ecm*1/12*b_slab*h_slab^3/(Ec_ef*I_lt_x)","v":31.299213780468612},"mm",null,null,null,null,null,null,null,null,"=f_el*Ecm*1/12*b_slab*h_slab^3/(Ec_ef*I_lt_x)"]
[null,null,"flt,qp,y","=",{"$f":"f_el*Ecm*1/12*b_slab*h_slab^3/(Ec_ef*I_i_ef_y)","v":14.198981196983715},"mm"]
[null,null,"fel,max,x",null,{"$f":"f_lim/(f_lt_qp_x/f_el)","v":4.5854186947519935},"mm",null,"(maximální elastický průhyb, tak aby vyhověla podmínka Lx/250)"]
[null,null,"fel,max,y",null,{"$f":"f_lim/(E135/f_el)","v":10.107767452392141},"mm",null,"(maximální elastický průhyb, tak aby vyhověla podmínka L/250)"]
[]
[null,null,"PRŮHYB PŘI KVAZISTÁLÉ KOMBINACI ZATÍŽENÍ"]
[null,null,"průhyb při dlouhodobém zatížení (efektivní hodnoty - dotvarování, trhliny) | působení ve dvou směrech"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Ir,x","=",{"$f":"0.75*I_lt_x","v":327655354.92139304},"mm4",null,null,null,"ve směru \"x\" s trhlinami",null,null,null,null,"=0.75*I_lt_x"]
[null,null,"Ir,y","=",{"$f":"0.75*I_i_ef_y","v":722259918.3509407},"mm4",null,null,null,"ve směru \"y\" bez trhlin",null,null,null,null,"=0.75*I_i_ef_y"]
[]
[]
[null,null,"Ie","=",{"$f":"(1+n_x*lambda^4/n_y)/(I_r_x+n_x*lambda^4*I_r_y/n_y)*I_r_x*I_r_y","v":602560109.02907765},null,null,null,null,null,null,null,null,null,"=(1+n_x*lambda^4/n_y)/(I_r_x+n_x*lambda^4*I_r_y/n_y)*I_r_x*I_r_y"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"flt,qp,xy","=",{"$f":"f_el*Ecm*1/12*b_slab*h_slab^3/(Ec_ef*I_e)","v":22.692850823961216},"mm",null,null,null,null,null,null,null,null,"=f_el*Ecm*1/12*b_slab*h_slab^3/(Ec_ef*I_e)"]
[null,null,"fel,max","=",{"$f":"f_lim/(E150/f_el)","v":6.3244587960036407},"mm"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"nx =",2]
[null,null,null,null,null,null,null,null,null,null,null,"ny =",2]
[null,null,null,null,null,null,null,null,null,null,null,"lambda = ",{"$f":"L_x/L_y","v":0.66666666666666663},null,{"$f":"JV_ukazvzorec(M155)","v":"=L_x/L_y"}]
[]
[]
[]
[]
[]
[]
[null,"POSOUZENÍ PRŮHYBU"]
[]
[null,null,"LIMITNÍ PRŮHYB"]
[]
[null,null,"Lmin",null,{"$f":"MIN(L_x,L_y)","v":7800},"mm"]
[null,null,"1/x","=",250,"omezení průhybu"]
[null,null,"flim","=",{"$f":"L_min/E167","v":31.2},"mm"]
[]
[null,null,"CELKOVÝ PRŮHYB | PŮSOBENÍ V JEDNOM SMĚRU (X)"]
[null,null,null,null,{"$f":"f_lt_qp_x","v":31.299213780468612},"mm","kvazistálé zatížení (dotvarování)"]
[null,null,null,null,0,"mm","smršťování"]
[null,null,"ftot","=",{"$f":"SUM(E171:E172)","v":31.299213780468612},"mm","celkový průhyb"]
[]
[null,null,"ftot","=",{"$f":"E173","v":31.299213780468612},"mm",null,{"$f":"IF(E175<I175,\"<\",\">\")","v":">"},{"$f":"f_lim","v":31.2},"mm","= flim",{"$f":"IF(E175<I175,\"=> VYHOVUJE\",\"=> NEVYHOVUJE\")","v":"=> NEVYHOVUJE"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"f_lt_qp_y*E176/f_el+E176","v":0}]
[null,null,"fel,max,x",null,{"$f":"(f_lim-E172)/(f_lt_qp_x/f_el)","v":4.5854186947519935},"mm",null,"=>",{"$f":"O177+E172","v":31.2},"mm","- maximální elastický průhyb aby byl limit splněn",null,null,null,{"$f":"f_lt_qp_x*E177/f_el","v":31.2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"JV_ukazvzorec(E178)","v":""}]
[null,null,"CELKOVÝ PRŮHYB | PŮSOBENÍ VE DVOU SMĚRECH (X,Y)",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"f_lt_qp_xy","v":22.692850823961216},"mm","kvazistálé zatížení (dotvarování)",null,null,null,null,null,null,null,"=f_lt_qp_xy"]
[null,null,null,null,0,"mm","smršťování",null,null,null,null,null,null,null,"0"]
[null,null,"ftot","=",{"$f":"SUM(E180:E181)","v":22.692850823961216},"mm","celkový průhyb"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"ftot","=",{"$f":"E182","v":22.692850823961216},"mm",null,{"$f":"IF(E184<I184,\"<\",\">\")","v":"<"},{"$f":"f_lim","v":31.2},"mm","= flim",{"$f":"IF(E184<I184,\"=> VYHOVUJE\",\"=> NEVYHOVUJE\")","v":"=> VYHOVUJE"},null,null,{"$f":"E184/E173","v":0.7250294203275498}]
[]
[null,null,"fel,max,xy",null,{"$f":"(f_lim-E181)/(f_lt_qp_xy/f_el)","v":6.3244587960036407},"mm","=>",null,{"$f":"O186+E181","v":31.2},"mm","- maximální elastický průhyb aby byl limit splněn",null,null,null,{"$f":"f_lt_qp_xy*E186/f_el","v":31.2}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"PRŮHYB OD SMRŠTĚNÍ",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Smrštění začíná působit v čase t0 (konec ošetřování). Vlhkost okolního prostředí <=> dotvarování.",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"fic,sh","=",2.85,null,"- součinitel dotvarování (odečtěno z grafu)",null,null,null,null,null,null,null,"2.85"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"poměrné smršťování vysycháním",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"betaRH","=",{"$f":"1.55*(1-(E205/RH_0)^3)","v":1.35625},null,null,null,null,null,null,null,null,null,"=1.55*(1-(E205/RH_0)^3)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"RH","=",50,"%",null,"- relativní vlhkost okolního prostředí (zadáno na vstupu)",null,null,null,null,null,null,"50"]
[null,null,"RH0","=",100,"%",null,null,null,null,null,null,null,null,"100"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"epsiloncd,0","=",{"$f":"0.85*((220+110*alpha_ds1)*EXP(-alpha_ds2*f_cm/f_cm_0))*10^-6*beta_RH","v":4.8224121929291294E-4},null,null,null,null,null,null,null,null,null,"=0.85*((220+110*alpha_ds1)*EXP(-alpha_ds2*f_cm/f_cm_0))*10^-6*beta_RH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"fcm0","=",10,"MPa",null,"- ČSN EN 1992-1-1",null,null,null,null,null,null,"10"]
[null,null,"fcm","=",38,"MPa",null,"- průměrná pevnost v tlaku C30/37",null,null,null,null,null,null,"38"]
[null,null,"alphads1","=",4,null,null,"- cement N (ČSN EN 1992-1-1)",null,null,null,null,null,null,"4"]
[null,null,"alphads2","=",0.12,null,null,"- cement N (ČSN EN 1992-1-1)",null,null,null,null,null,null,"0.12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"epsiloncd,inf","=",{"$f":"k_h*epsilon_cd_0","v":4.0026021201311772E-4},null,null,null,null,null,null,null,null,null,"=k_h*epsilon_cd_0"]
[null,null,null,null,null,null,null,null,null,null,null,"h0","kh",null,""]
[null,null,"h0","=",{"$f":"h_slab","v":220},"mm",null,null,null,null,null,200,0.85,null,"=h_slab"]
[null,null,null,null,null,null,null,null,null,null,null,300,0.75,null,{"$f":"JV_ukazvzorec(E218)","v":""}]
[null,null,"kh","=",{"$f":"M219","v":0.83},null,null,"- interpolací (tabulka vpravo) ->",null,null,null,{"$f":"E217","v":220},{"$f":"(M218-M217)/(L218-L217)*(L219-L217)+M217","v":0.83},null,{"$f":"JV_ukazvzorec(E219)","v":"=M219"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"betads","=",{"$f":"(t_inf-t_s)/((t_inf-t_s)+0.04*SQRT(h_0^3))","v":0.99289602334284988},null,null,null,null,null,null,null,null,null,"=(t_inf-t_s)/((t_inf-t_s)+0.04*SQRT(h_0^3))"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"tinf","=",{"$f":"t_inf","v":18250},"d",null,"- stáří betonu v uvažovaném okamžiku (50let = 50*365=18250 dnů)",null,null,null,null,null,null,"=t_inf"]
[null,null,"ts","=",{"$f":"t_s","v":7},"d",null,"- doba ošetřování",null,null,null,null,null,null,"=t_s"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"epsiloncd,t","=",{"$f":"beta_ds*epsilon_cd_inf","v":3.9741677281019056E-4},null,null,null,null,null,null,null,null,null,"=beta_ds*epsilon_cd_inf"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"poměrné autogenní smršťování",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"betaas(t)","=",{"$f":"1-EXP(-0.2*t_inf^0.5)","v":0.99999999999815492},null,null,null,null,null,null,null,null,null,"=1-EXP(-0.2*t_inf^0.5)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"epsilonca(inf)","=",{"$f":"2.5*(fck-10)*10^-6","v":4.9999999999999996E-5},null,null,null,null,null,null,null,null,null,"=2.5*(fck-10)*10^-6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"epsilonca(t)","=",{"$f":"beta_as_t*epsilon_ca_inf","v":4.9999999999907744E-5},null,null,null,null,null,null,null,null,null,"=beta_as_t*epsilon_ca_inf"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"CELKOVÉ POMĚRNÉ SMRŠŤOVÁNÍ",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,"epsiloncs","=",{"$f":"epsilon_cd_t+epsilon_ca_t","v":4.4741677281009832E-4},null,null,null,null,null,null,null,null,null,"=epsilon_cd_t+epsilon_ca_t"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"PRŮŘEZ BEZ TRHLIN - CHARAKTERISTIKY",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"efektivní modul pružnosti",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Ec,ef,sh","=",{"$f":"Ecm/(1+fi_c_sh)","v":8.3116883116883109},"GPa",null,null,null,null,null,null,null,null,"=Ecm/(1+fi_c_sh)"]
[null,null,"alpha_e,ef,sh","=",{"$f":"Es/Ec_ef_sh","v":24.062500000000004},null,null,null,null,null,null,null,null,null,"=Es/Ec_ef_sh"]
[null,null,"plocha ideálního průřezu",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"AI,ef,sh,x","=",{"$f":"h_slab*b_slab+alpha_e_ef_sh*(As_1_x+As_2_x)","v":243182.33578961468},"mm2",null,null,null,null,null,null,null,null,"=h_slab*b_slab+alpha_e_ef_sh*(As_1_x+As_2_x)"]
[null,null,"AI,ef,sh,y","=",{"$f":"h_slab*b_slab+alpha_e_ef_sh*(As_1_y+As_2_y)","v":238562.6674257422},"mm2",null,null,null,null,null,null,null,null,"=h_slab*b_slab+alpha_e_ef_sh*(As_1_y+As_2_y)"]
[null,null,"vzdálenost těžiště ideálního průřezu od horního okraje",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"aI,ef,sh,x","=",{"$f":"(h_slab*b_slab*h_slab/2+alpha_e_ef*(As_1_x*d_x+As_2_x*d_2_x))/plocha_i_ef_sh_x","v":110.30434236389131},"mm",null,null,null,null,null,null,null,null,"=(h_slab*b_slab*h_slab/2+alpha_e_ef*(As_1_x*d_x+As_2_x*d_2_x))/plocha_i_ef_sh_x"]
[null,null,"aI,ef,sh,y","=",{"$f":"(h_slab*b_slab*h_slab/2+alpha_e_ef*(As_1_x*d_y+As_2_y*d_2_y))/plocha_i_ef_sh_y","v":112.06903447811503},"mm",null,null,null,null,null,null,null,null,"=(h_slab*b_slab*h_slab/2+alpha_e_ef*(As_1_x*d_y+As_2_y*d_2_y))/plocha_i_ef_sh_y"]
[null,null,"moment setrvačnosti ideálního průřezu",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"II,ef,sh,x","=",{"$f":"1/12*b_slab*h_slab^3+b_slab*h_slab*(vzdalenost_i_ef_sh_x-h_slab/2)^2+alpha_e_ef_sh*(As_1_x*(d_x-vzdalenost_i_ef_sh_x)^2+As_2_x*(vzdalenost_i_ef_sh_x-d_2_x)^2)","v":1022767698.9508337},"mm4",null,null,null,null,null,null,null,null,"=1/12*b_slab*h_slab^3+b_slab*h_slab*(vzdalenost_i_ef_sh_x-h_slab/2)^2+alpha_e_ef_sh*(As_1_x*(d_x-vzdalenost_i_ef_sh_x)^2+As_2_x*(vzdalenost_i_ef_sh_x-d_2_x)^2)"]
[null,null,"II,ef,sh,y","=",{"$f":"1/12*b_slab*h_slab^3+b_slab*h_slab*(vzdalenost_i_ef_sh_y-h_slab/2)^2+alpha_e_ef_sh*(As_1_y*(d_y-vzdalenost_i_ef_sh_y)^2+As_2_y*(vzdalenost_i_ef_sh_y-d_2_y)^2)","v":972694731.24814785},"mm4",null,null,null,null,null,null,null,null,"=1/12*b_slab*h_slab^3+b_slab*h_slab*(vzdalenost_i_ef_sh_y-h_slab/2)^2+alpha_e_ef_sh*(As_1_y*(d_y-vzdalenost_i_ef_sh_y)^2+As_2_y*(vzdalenost_i_ef_sh_y-d_2_y)^2)"]
[null,null,"statický moment průřezové plochy k těžišti výztuže",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"SI,ef,sh,x","=",{"$f":"(As_1_x+As_2_x)*(d_x-vzdalenost_i_ef_sh_x)","v":70999.9992335274},"mm3",null,null,null,null,null,null,null,null,"=(As_1_x+As_2_x)*(d_x-vzdalenost_i_ef_sh_x)"]
[null,null,"SI,ef,sh,y","=",{"$f":"(As_1_y+As_2_y)*(d_y-vzdalenost_i_ef_sh_y)","v":47004.311643100868},"mm3",null,null,null,null,null,null,null,null,"=(As_1_y+As_2_y)*(d_y-vzdalenost_i_ef_sh_y)"]
[]
[null,null,"PRŮŘEZ S TRHLINAMI - CHARAKTERISTIKY",null,null,null,null,null,null,null,null,null,null,null,{"$f":"JV_ukazvzorec(E256)","v":""}]
[null,null,"vzdálenost neutrální osy od tlačeného okraje",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"xcr,ef,sh,x","=",{"$f":"alpha_e_ef_sh/b_slab*(As_1_x+As_2_x)*(-1+SQRT(1+(2*b_slab/alpha_e_ef_sh)*((As_1_x*d_x+As_2_x*d_2_x)/(As_1_x+As_2_x)^2)))","v":57.866166408355483},"mm",null,null,null,null,null,null,null,null,"=alpha_e_ef_sh/b_slab*(As_1_x+As_2_x)*(-1+SQRT(1+(2*b_slab/alpha_e_ef_sh)*((As_1_x*d_x+As_2_x*d_2_x)/(As_1_x+As_2_x)^2)))"]
[null,null,"xcr,ef,sh,y","=",{"$f":"alpha_e_ef_sh/b_slab*(As_1_y+As_2_y)*(-1+SQRT(1+(2*b_slab/alpha_e_ef_sh)*((As_1_y*d_y+As_2_y*d_2_y)/(As_1_y+As_2_y)^2)))","v":49.068723215285985},"mm",null,null,null,null,null,null,null,null,"=alpha_e_ef_sh/b_slab*(As_1_y+As_2_y)*(-1+SQRT(1+(2*b_slab/alpha_e_ef_sh)*((As_1_y*d_y+As_2_y*d_2_y)/(As_1_y+As_2_y)^2)))"]
[null,null,"moment setvračnosti potrhaného průřezu",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"III,ef,sh,x","=",{"$f":"1/3*b_slab*x_cr_ef_sh_x^3+alpha_e_ef_sh*(As_1_x*(d_x-x_cr_ef_sh_x)^2+As_2_x*(x_cr_ef_sh_x-d_2_x)^2)","v":311845106.93235701},"mm4",null,null,null,null,null,null,null,null,{"$f":"JV_ukazvzorec(E261)","v":"=1/3*b_slab*x_cr_ef_sh_x^3+alpha_e_ef_sh*(As_1_x*(d_x-x_cr_ef_sh_x)^2+As_2_x*(x_cr_ef_sh_x-d_2_x)^2)"}]
[null,null,"III,ef,sh,y","=",{"$f":"1/3*b_slab*x_cr_ef_sh_y^3+alpha_e_ef_sh*(As_1_y*(d_y-x_cr_ef_sh_y)^2+As_2_y*(x_cr_ef_sh_y-d_2_y)^2)","v":201813557.49610731},"mm4",null,null,null,null,null,null,null,null,{"$f":"JV_ukazvzorec(E262)","v":"=1/3*b_slab*x_cr_ef_sh_y^3+alpha_e_ef_sh*(As_1_y*(d_y-x_cr_ef_sh_y)^2+As_2_y*(x_cr_ef_sh_y-d_2_y)^2)"}]
[]
[null,null,"statický moment průřezové plochy k těžišti výztuže"]
[null,null,"SII,ef,sh,x","=",{"$f":"(As_1_x+As_2_x)*(d_x-x_cr_ef_sh_x)","v":121520.07832739255},"mm3"]
[null,null,"SII,ef,sh,y","=",{"$f":"(As_1_y+As_2_y)*(d_y-x_cr_ef_sh_y)","v":95604.99011334026},"mm3"]
[]
[null,null,"rozdělovací součinitel",null,null,null,null,null,null,null,null,null,null,null,{"$f":"JV_ukazvzorec(E268)","v":""}]
[null,null,"Trhliny se v průžezu pro posuzovanou (kvazistálou) kombinaci zatížení neobjeví. ",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Během živostnosti vzniknou (charakteristická kombinace).",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"=>  mE,qp = mcr",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"// pro stanovení váženého momentu setrvačnosti je moment při kvazistálé hodnotě zatížení ",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"// uvažován jako moment při vzniku trhin",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"beta","=",0.5,null,"- dlouhodobě působící, mnohonásobně se opakující zatížení",null,null,null,null,null,null,null,"0.5"]
[null,null,"zeta","=",{"$f":"1-beta*(M_cr/M_cr)^2","v":0.5},null,null,null,null,null,null,null,null,null,"=1-beta*(M_cr/M_cr)^2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"výsledná křivost od smršťování",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"curv_cs_x","=",{"$f":"epsilon_cs*alpha_e_ef_sh*((1-zeta)*S_I_ef_sh_x/I_i_ef_sh_x+zeta*S_ii_ef_sh_x/I_ii_ef_sh_x)","v":2.471329487000874E-6},null,"ve směru \"x\" s trhlinami",null,null,null,null,null,null,null,"=epsilon_cs*alpha_e_ef_sh*((1-zeta)*S_I_ef_sh_x/I_i_ef_sh_x+zeta*S_ii_ef_sh_x/I_ii_ef_sh_x)"]
[null,null,"curv_cs_y","=",{"$f":"epsilon_cs*alpha_e_ef_sh*((1-zeta)*S_I_ef_sh_y/I_i_ef_sh_y+zeta*S_I_ef_sh_y/I_i_ef_sh_y)","v":5.2025245870717271E-7},null,"ve směru \"y\" bez trhlin",null,null,null,null,null,null,null,"=epsilon_cs*alpha_e_ef_sh*((1-zeta)*S_I_ef_sh_y/I_i_ef_sh_y+zeta*S_I_ef_sh_y/I_i_ef_sh_y)"]
[null,null,"PRŮHYB OD SMRŠŤOVÁNÍ",null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,"kx","=",{"$f":"L286","v":7.399E-2},null,null,"- interpolací (tabulka vpravo) ->",null,null,null,"V-V","V-K"]
[null,null,null,null,null,null,null,null,null,null,0.3,6.6000000000000003E-2,8.6900000000000005E-2]
[null,null,null,null,null,null,null,null,null,null,0.35,5.7799999999999997E-2,8.6900000000000005E-2]
[null,null,null,null,null,null,null,null,null,null,0.33,{"$f":"(L284-L283)/(K284-K283)*(K285-K283)+L283","v":6.1079999999999995E-2},{"$f":"(M284-M283)/(K284-K283)*(L285-K283)+M283","v":8.6900000000000005E-2}]
[null,null,null,null,null,null,null,null,null," ","kx = ",{"$f":"(L285+M285)/2","v":7.399E-2}]
[]
[null,null,"ky",{"$f":"D282","v":"="},{"$f":"L290","v":6.6949999999999996E-2},null,null,"- interpolací (tabulka vpravo) ->",null,null,null,"V-V","V-K"]
[null,null,null,null,null,null,null,null,null,null,0.15,5.7799999999999997E-2,7.6100000000000001E-2]
[null,null,null,null,null,null,null,null,null," ","ky = ",{"$f":"(L289+M289)/2","v":6.6949999999999996E-2}]
[]
[null,null,"fsh,x","=",{"$f":"k_x*L_x^2*curv_cs_x","v":11.124817206335962},"mm",null,null,null,null,null,null,null,null,"=k_x*L_x^2*curv_cs_x"]
[null,null,"fsh,y","=",{"$f":"k_y*L_y^2*curv_cs_y","v":4.7680021898988452},"mm",null,null,null,null,null,null,null,null,"=k_y*L_y^2*curv_cs_y"]
[null,null,"fsh,res","=",{"$f":"(f_sh_x+f_sh_y)/2","v":7.9464096981174031},"mm",null,null,null,null,null,null,null,null,"=(f_sh_x+f_sh_y)/2"]
[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,{"$f":"JV_ukazvzorec(L323)","v":"=E323/E324"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"JV_ukazvzorec(L334)","v":"=E334/E335"}]
[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,null,null,null,""]
[null,"POSOUZENÍ PRŮHYBU",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"JV_ukazvzorec(E312)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"LIMITNÍ PRŮHYB",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,"Lmin",null,{"$f":"MIN(L_x,L_y)","v":7800},"mm",null,null,null,null,null,null,null,null,"=MIN(L_x,L_y)"]
[null,null,"1/x","=",250,"omezení průhybu",null,null,null,null,null,null,null,null,"250"]
[null,null,"flim","=",{"$f":"L_min/E317","v":31.2},"mm",null,null,null,null,null,null,null,null,"=L_min/E317"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"JV_ukazvzorec(E319)","v":""}]
[null,null,"CELKOVÝ PRŮHYB | PŮSOBENÍ V JEDNOM SMĚRU (X)",null,null,null,null,null,null,null,null,"poměrná část",null,null,""]
[null,null,null,null,0,"mm","elastický",null,null,null,null,null,null,null,"0"]
[null,null,null,null,{"$f":"f_lt_qp_x","v":31.299213780468612},"mm","kvazistálé zatížení (dotvarování)",null,null,null,null,{"$f":"E322/E324","v":0.79752112480890314},null,null,"=f_lt_qp_x"]
[null,null,null,null,{"$f":"f_sh_res","v":7.9464096981174031},"mm","smršťování",null,null,null,null,{"$f":"E323/E324","v":0.202478875191097},null,null,"=f_sh_res"]
[null,null,"ftot","=",{"$f":"SUM(E321:E323)","v":39.245623478586012},"mm","celkový průhyb"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"ftot","=",{"$f":"E324","v":39.245623478586012},"mm",null,{"$f":"IF(E326<I326,\"<\",\">\")","v":">"},{"$f":"f_lim","v":31.2},"mm","= flim",{"$f":"IF(E326<I326,\"=> VYHOVUJE\",\"=> NEVYHOVUJE\")","v":"=> NEVYHOVUJE"}]
[]
[null,null,"fel,max,x",null,{"$f":"(f_lim-E323)/(f_lt_qp_x/f_el)","v":3.4175464003319265},"mm",null,"=>",{"$f":"O328+E323","v":31.2},"mm","- maximální elastický průhyb aby byl limit splněn",null,null,null,{"$f":"f_lt_qp_x*E328/f_el","v":23.253590301882596}]
[null,null,"fel,max,y",null,2.7494805602355084,"mm",null,"=>",{"$f":"O329","v":11.236398555073819},"mm","(dopočítáno SOLVER)",null,null,null,{"$f":"f_lt_qp_y*E329/f_el+E329","v":11.236398555073819}]
[]
[null,null,"CELKOVÝ PRŮHYB | PŮSOBENÍ VE DVOU SMĚRECH (X,Y)",null,null,null,null,null,null,null,null,"poměrná část",null,null,""]
[null,null,null,null,0,"mm","elastický",null,null,null,null,null,null,null,"0"]
[null,null,null,null,{"$f":"f_lt_qp_xy","v":22.692850823961216},"mm","kvazistálé zatížení (dotvarování)",null,null,null,null,{"$f":"E333/E335","v":0.7406461656477894},null,null,"=f_lt_qp_xy"]
[null,null,null,null,{"$f":"f_sh_res","v":7.9464096981174031},"mm","smršťování",null,null,null,null,{"$f":"E334/E335","v":0.2593538343522106},null,null,"=f_sh_res"]
[null,null,"ftot","=",{"$f":"SUM(E332:E334)","v":30.639260522078619},"mm","celkový průhyb"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"ftot","=",{"$f":"E335","v":30.639260522078619},"mm",null,{"$f":"IF(E337<I337,\"<\",\">\")","v":"<"},{"$f":"f_lim","v":31.2},"mm","= flim",{"$f":"IF(E337<I337,\"=> VYHOVUJE\",\"=> NEVYHOVUJE\")","v":"=> VYHOVUJE"},null,null,{"$f":"E337/E326","v":0.78070515401027152}]
[]
[null,null,"fel,max,xy",null,{"$f":"(f_lim-E334)/(f_lt_qp_xy/f_el)","v":4.7136658244681522},"mm","=>",null,{"$f":"O339+E334","v":31.2},"mm","- maximální elastický průhyb aby byl limit splněn",null,null,null,{"$f":"f_lt_qp_xy*E339/f_el","v":23.253590301882596}]
[]
[null,null,null,null,null,280,"=",3.5,null,null,null,{"$f":"E333/E322","v":0.7250294203275498}]
[null,null,null,null,null,300,"=",3.3]
[null,null,null,null,null,350,"=",2.9]
[null,null,null,null,null,400,"=",2.7]
[]
[]
[null,null,"PRŮHYB OD SMRŠŤOVÁNÍ"]
[]
[null,null,"fsh,x","=",{"$f":"k_x*L_x^2*curv_cs_x","v":11.124817206335962},"mm"]
[null,null,"fsh,y","=",{"$f":"k_y*L_y^2*curv_cs_y","v":4.7680021898988452},"mm"]
[null,null,"fsh,res","=",{"$f":"(f_sh_x+f_sh_y)/2","v":7.9464096981174031},"mm"]

{"sheet":"List2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"List3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}