{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Tabelle 1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":28,"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":"Tabelle 1","index":0,"n_rows":29,"n_cols":18,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,0,28,2],[19,0,19,5],[25,9,25,12],[0,0,0,6],[10,0,10,5],[1,0,1,1],[16,9,16,12],[17,9,17,12],[23,0,23,5],[18,9,18,12],[19,9,19,12],[20,9,20,12],[25,0,25,5],[22,0,22,5],[18,0,18,5]]}
["Bauteile mit rechnerisch erforderlicher Querkraftbewehrung\nnach EN 1992-1-1:2004 und DIN EN 1992-1-1/NA:2013-04"]
["Betonfestigkeitsklasse:",null,"C30/37",null,null,null,null,null,null,"Werstoffkennwerte für Beton in [N/mm2]"]
[null,"αct = ",{"$f":"m_alct","v":0.85},"[-]",null,null,null,null,null,"αct = ",0.85]
[null,"γc = ",{"$f":"m_gammac","v":1.5},"[-]",null,null,null,null,null,"γc = ",1.5]
[null,"fck =",{"$f":"VLOOKUP(m_strfck,Werkstoffkennwerte,2,FALSE)","v":30},"[N/mm2]",null,null,null,null,null,null,"fck","fck,cube","fcm","fcd","fctm","fctd","Ecm","ρw,min [‰]"]
[null,"fcd =",{"$f":"VLOOKUP(m_strfck,Werkstoffkennwerte,5,FALSE)","v":17},"[N/mm2]",null,null,null,null,null,"C12/15",12,15,{"$f":"K6+8","v":20},{"$f":"m_alct*K6/m_gammac","v":6.8},{"$f":"POWER(K6,2/3)*0.3","v":1.5724448365253381},{"$f":"0.7*O6*m_alct/m_gammac","v":0.62373645182171733},27000,{"$f":"0.16*O6/500*1000","v":0.50318234768810821}]
[null,"fywd =",435,"[N/mm2]",null,null,null,null,null,"C16/20",16,20,{"$f":"K7+8","v":24},9.0666666666666664,{"$f":"POWER(K7,2/3)*0.3","v":1.9048812623618392},0.75560290073686287,29000,{"$f":"0.16*O7/500*1000","v":0.60956200395578852}]
[null,"VEd =",318.3,"[kN]",null,null,null,null,null,"C20/25",20,25,28,11.333333333333334,2.2104188991842313,0.87679949667641166,30000,0.70733404773895403]
[null,"h =",60,"[cm]",null,null,null,null,null,"C25/30",25,30,33,14.166666666666666,2.5649639200150443,1.0174356882726341,31000,0.82078845440481418]
[null,"b =",30,"[cm]",null,null,null,null,null,"C30/37",30,37,38,17,2.896468153816889,1.1489323676806993,33000,0.92686980922140449]
["σcd = NEd / Ac",null,null,null,null,null,null,null,null,"C35/45",35,45,43,19.833333333333332,3.2099624416952368,1.2732851018724438,34000,1.0271879813424758]
[null,"NEd =",0,"[kN]",null,null,null,null,null,"C40/50",40,50,48,22.666666666666668,3.5088212858554391,1.3918324433893241,35000,1.1228228114737406]
[null,"Ac =",1800,"[cm2]",null,null,null,null,null,"C45/55",45,55,53,25.5,3.7954469938578708,1.5055273075636217,36000,1.2145430380345186]
[null,"σcd =",{"$f":"MIN(m_NEd*10/m_Ac,0.2*m_fcd)","v":0},"[N/mm2]",null,null,null,null,null,"C50/60",50,60,{"$f":"K14+8","v":58},{"$f":"m_alct*K14/m_gammac","v":28.333333333333332},{"$f":"POWER(K14,2/3)*0.3","v":4.0716264248923588},{"$f":"0.7*O14*m_alct/m_gammac","v":1.615078481873969},37000,1.3029204559655549]
[null,"bw =",30,"[cm]"," "]
[null,"cv,l =",2,"[cm]",null,null,null,null,null,"Formeln für Werkstoffkennwerte"]
[null,"d =",58,"[cm]",null,null,null,null,null,"fcm = fck + 8 [N/mm2]"]
[null,"z =",52.2,"[cm]",null,null,null,null,null,"fcd = αct · fck / γc"]
["1 ≤ cot Θ = (1.2 + 1.4 · σcd / fcd) / (1 - VRd,cc / VEd) ≤ 3",null,null,null,null,null,null,null,null,"fctm = 0,3 · fck2/3"]
["mit VRd,cc = 0.24 · fck1/3 · (1 - 1.2 · σcd / fcd) · bw · z",null,null,null,null,null,null,null,null,"fctd = 0,7 · fctm · αct  / γc"]
[null,"Θ =",27.82,"[Grad]",null,null,null,null,null,"ρw,min = 0.16 · fctm / fyk"]
[null,"α =",90,"[Grad]"]
["Erforderliche Querkraftbewehrung asw aus Nachweis VEd ≤ VRd,s ",null,null,null,null,null,null,null,null,"Mindestquerkraftbewehrung min asw"]
["asw = Asw / sw =VEd / (fywd · z · (cot Θ + cot α) · sin α) ",null,null,null,null,null,null,null,null,"ρw,min =",{"$f":"VLOOKUP(m_strfck,Werkstoffkennwerte,9,FALSE)","v":0.92686980922140449},"[‰]"]
[null,"asw =",{"$f":"m_VEd/(m_fywd/10*m_z/100*(_xlfn.COT(m_theta*PI()/180)+_xlfn.COT(m_al*PI()/180))*SIN(m_al*PI()/180))","v":7.3969512413481358},"[cm2/m]",null,null,null,null,null,"b / h =",{"$f":" m_b/m_h","v":0.5},"[-]"]
["VRd,max = bw · z · 0.75 · fcd · (cot Θ + cot α) / (1 + cot2 Θ)",null,null,null,null,null,null,null,null,"min asw = ρw,min · bw · sin α"]
[null,"VRd,max =",{"$f":"m_bw*m_z*0.75*m_fcd/10*(_xlfn.COT(m_theta*PI()/180)+_xlfn.COT(m_al*PI()/180))/(1+_xlfn.COT(m_theta*PI()/180)*_xlfn.COT(m_theta*PI()/180))","v":824.12499311753902},"[kN]",null,null,null,null,null,"min asw =",{"$f":"IF(m_bh<4,1,IF(m_bh>5,0.6,(1-0.4*(m_bh-4))))*m_rhowmin*m_bw*SIN(m_al*PI()/180)/10","v":2.7806094276642135},"[cm2/m]"]
[]
["VEd ≤ VRd,max ",null,null,{"$f":"IF(m_VEd<=m_VRdmax,\" Nachweis wurde erfüllt!\",\" Nachweis wurde nicht erfüllt!\")","v":" Nachweis wurde erfüllt!"},null,null,null,null," "]