{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Dateneingabe","Ergebnisse","Datenbasis"],"not_rendered":{"charts":2,"images":11,"macros":1,"external_links":0,"defined_names":2,"comments":3,"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":"Dateneingabe","index":0,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Bemessung für Querkraft nach EC2 bei rechteckigen Stahlbetonquerschnitten"]
[null,null,null,null,null,null,null,null,null,"Version:","09-2021"]
[null,"Teilsicherheitsbeiwert",null,null,null,null,"Beiwert für Bauteileigenschaften"]
[]
[null,null,null,null,null,"gC =",{"$f":"Datenbasis!E8","v":1.5},"Teilsicherheitsbeiwert für Beton",null,null,"[ 1 ]"]
[null,null,null,null,null,"gS =",{"$f":"Datenbasis!F8","v":1.1499999999999999},"Teilsicherheitsbeiwert für Betonstahl",null,null,"[ 1 ]"]
[]
[null,"Betonfestigkeitsklasse",null,null,null,null,"Materialparameter"]
[]
[null,null,null,null,true,"fcd =",{"$f":"Datenbasis!G58","v":11.333333333333334},"Bemessungswert für die Druckfestigkeit",null,null,"[N/mm²]"]
[null,null,null,null,false,"fck =",{"$f":"Datenbasis!C22","v":20},"Zylinderdruckfestigkeit des Betons",null,null,"[N/mm²]"]
[null,null,null,null,null,"fyd =",{"$f":"Datenbasis!E15","v":434.78260869565219},"Bemessungswert für die Streckgrenze",null,null,"[N/mm²]"]
[]
[null,"Betonstahlgüte",null,null,null,null,"Neigung der Querkraftbewehrung",null,null,"(gegen Stabachse)"]
[null,"für","Querkraft-"]
[null,null,"bewehrung",null,null,"q =",null,null,null,90,"[° ]"]
[null,null,null,null,null,null,"geneigt (45°)",null,"lotrecht (90°)"]
[null,null,null,"bw =",1200,"[mm]"]
[null,"Querschnittsangaben",null,"h =",320,"[mm]","Einwirkungen"]
[null,null,null,"d =",260,"[mm]",null,"VEd =",150,{"$f":"IF(Datenbasis!$M$2,\"[kN/m]\",\"[kN]\")","v":"[kN]"}]
[null,{"$f":"IF(Datenbasis!M2,\"Plattenquerschnitt\",\"Balkenquerschnitt\")","v":"Balkenquerschnitt"},null,"cv,l =",25,"[mm]",null,"VEd,0 =",210,{"$f":"IF(Datenbasis!$M$2,\"[kN/m]\",\"[kN]\")","v":"[kN]"}]
[null,"bw / h =",{"$f":"IF(AND(E19/E20 >=4,NOT(Datenbasis!M2)), CONCATENATE(ROUND(E19/E20,2),\" !!\"), E19/E20)","v":3.75},"Asl =",9.42,"[cm²]",null,"NEd =",0,{"$f":"IF(Datenbasis!$M$2,\"[kN/m]\",\"[kN]\")","v":"[kN]"}]

{"sheet":"Ergebnisse","index":1,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"Dateneingabe!B2","v":"Bemessung für Querkraft nach EC2 bei rechteckigen Stahlbetonquerschnitten"}]
[]
[null,"Einwirkungen",null,null,null,null,"Angaben zur Bewehrung",null,null,null,null,{"$f":"IF(Datenbasis!$M$2,\"Platte\",\"\")","v":""}]
[]
[null,"VEd = ",{"$f":"Datenbasis!K14/1000","v":150},{"$f":"IF(Datenbasis!$M$2,\"[kN/m]\",\"[kN]\")","v":"[kN]"},{"$f":"Datenbasis!M14/100","v":1},null,"asw,rqd =",{"$f":"Datenbasis!K49","v":5.4761904761904763},"[cm²/m]","Abstände in"]
[null,"VEd,0 = ",{"$f":"Datenbasis!K15/1000","v":210},{"$f":"IF(Datenbasis!$M$2,\"[kN/m]\",\"[kN]\")","v":"[kN]"},null,null,"asw,min =",{"$f":"Datenbasis!K52","v":8.4880085728674484},"[cm²/m]","Längsricht. = ",{"$f":"Datenbasis!P31","v":224},"[mm]"]
[null,null,null,null,{"$f":"Datenbasis!M16/100","v":1},null,"rw =",{"$f":"Datenbasis!K50","v":0.45634920634920634},"[%]","Querricht. = ",{"$f":"Datenbasis!R31","v":320},"[mm]"]
[null,"NEd = ",{"$f":"-Datenbasis!K16/1000","v":0},{"$f":"IF(Datenbasis!$M$2,\"[kN/m]\",\"[kN]\")","v":"[kN]"},null,null,"rw,min =",{"$f":"Datenbasis!K51","v":0.70733404773895403},"[%]","bei Schräg. = ",{"$f":"Datenbasis!Q31","v":160},"[mm]"]
[]
[null,"Beanspruchung und Bauteilwiderstände",null,null,null,null,"Geometrie des FW-Modells zur Querkraftabtragung",null,null,null,null,{"$f":"IF(Datenbasis!$M$2,\"Platte\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"IF(J30<H30,\"Flacherer Winkel unzulässig\",IF(J30>45,\"Winkel über 45 Grad nur in Ausnahmefällen\",\"\"))","v":""}]
[]
[]
[]
[null,null,null,null,null,{"$f":"Datenbasis!M8/100","v":1},null,"Grenzwert der",null,"gewählte"]
[null,"Neigung der",null,null,"Bewehrungsgrad",null,null,"Neigung der",null,"<=             Neigung der"]
[null,"Querkraft-",null,null,"in Längsrichtung",null,null,"Druckstrebe in [°]",null,"Druckstrebe in [°]"]
[null,"bewehrung",{"$f":"Datenbasis!K22","v":90},"[°]",{"$f":"Datenbasis!K8","v":9.42},"[cm²]",null,{"$f":"Datenbasis!L25","v":18.43494882292201},null,18.43494882292201]

{"sheet":"Datenbasis","index":2,"n_rows":58,"n_cols":18,"rows_kept":58,"cut":false,"hidden":false,"merged":[[20,15,20,16],[7,1,7,3]]}
[null,"Betonart","Stahllinie",null,null,null,null,null,null,"Querschnitt","in [cm]","Lage","in [cm]"]
[null,1,{"$f":"IF(C4,1,2)","v":2},null,null,null,null,null,null,"b_w =",{"$f":"Dateneingabe!E19","v":1200},"[mm]","Falsch"]
[null,"Normalb. = 1","Lin. I/II = 1/2",null,null,null,null,null,null,"h =",{"$f":"Dateneingabe!E20","v":320},"[mm]","Platte ?"]
[null,"Leichtb. = 2",false,null,null,null,null,null,null,"d =",{"$f":"Dateneingabe!E21","v":260},"[mm]"]
[null,null,null,null,null,null,null,null,null,"c_v,l =",{"$f":"Dateneingabe!E22","v":25},"[mm]"]
[null,{"$f":"SucheZeile(F6,B10:B11)","v":1},"Kombinationsauswahl",null,null,"Grundkombination",null,null,null,"0,9 * d =",{"$f":"0.9*K4","v":234},"[mm]","Manipulat."]
[null,"Kombination",null,null,"gam_c","gam_s",null,null,null,"z =",{"$f":"MIN(K6,MAX(K4-2*K5,K4-K5-30))","v":210},"[mm]"]
[null,{"$f":"INDEX(B10:B11,$B$6)","v":"Grundkombination"},null,null,{"$f":"INDEX(E10:E11,$B$6)","v":1.5},{"$f":"INDEX(F10:F11,$B$6)","v":1.1499999999999999},null,null,null,"A_sl =",{"$f":"Dateneingabe!E23*M8/100","v":9.42},"[cm²]",100]
[null,"Kombination",null,null,"gam_c","gam_s",null,null,null,"b_w / h =",{"$f":"K2/K3","v":3.75},"[1]",{"$f":"ROUND(Datenbasis!K9,3)*1000","v":3750}]
[null,"Grundkombination",null,null,1.5,1.1499999999999999]
[null,"Außergewöhnl. Kombination",null,null,1.3,1]
[]
[null,{"$f":"SucheZeile(E13,B17:B18)","v":1},"Stahlparameter",null,"B 500 SA",{"$f":"IF(C2=2,\"f_td > f_yd\",\"f_yd = f_td\")","v":"f_td > f_yd"},20000,2.5000000000000001E-2,null,"Einwirkungen",null,null,"Manipulat."]
[null,"Stahlgüte","f_yk","f_tk","f_yd","f_td","eps_yk","eps_yd",null,"V_Ed =",{"$f":"Dateneingabe!I21*1000*Datenbasis!M14/100","v":150000},"[N] bzw. [N/m]",100]
[null,{"$f":"INDEX(B17:B18,$B$13)","v":"B 500 SA"},{"$f":"INDEX(C17:C18,$B$13)","v":500},{"$f":"INDEX(D17:D18,$B$13)","v":525},{"$f":"INDEX(E17:E18,$B$13)","v":434.78260869565219},{"$f":"IF(C2=2,INDEX(F17:F18,$B$13),E15)","v":456.52173913043481},{"$f":"INDEX(G17:G18,$B$13)","v":2.5000000000000001E-2},{"$f":"INDEX(H17:H18,$B$13)","v":2.1739130434782608E-2},null,"V_Ed,0 =",{"$f":"Dateneingabe!I22*1000*Datenbasis!M15/100","v":210000},"[N] bzw. [N/m]",{"$f":"M14","v":100}]
[null,"Stahlgüte","f_yk","f_tk","f_yd","f_td","eps_yk","eps_yd",null,"N_Ed =",{"$f":"-Dateneingabe!I23*1000*Datenbasis!M16/100","v":0},"[N] bzw. [N/m]",100]
[null,"B 500 SA",500,525,{"$f":"C17/F8","v":434.78260869565219},{"$f":"D17/F8","v":456.52173913043481},{"$f":"C17/G13","v":2.5000000000000001E-2},{"$f":"E17/G13","v":2.1739130434782608E-2},null,null,null,"(Druckkr. = positiv)"]
[null,"B 500 MA",500,525,{"$f":"C18/F8","v":434.78260869565219},{"$f":"D18/F8","v":456.52173913043481},{"$f":"C18/G13","v":2.5000000000000001E-2},{"$f":"E18/G13","v":2.1739130434782608E-2}]
[]
[null,{"$f":"SucheZeile(G20,B24:B38)","v":3},"Parabel-Rechteck-Diagramm (Normalbeton)",null,null,null,"C 20/25",0.85,null,"Einstellungen",null,null,null,null,"Hinweise zur Bewehrungsführung"]
[null,"Betongüte","f_ck","eps_c2","eps_c2u","n","f_cd",null,null,"Neigung der Querkraftbewehrung",null,null,null,null,"Querkraft-","V_Ed / V_Rd,max =",null,{"$f":"K14/K47","v":0.23342670401493931}]
[null,{"$f":"INDEX(B24:B38,$B$20)","v":"C 20/25"},20,-2,-3.5,2,11.333333333333334,2200,null,"alpha =",{"$f":"Dateneingabe!J17","v":90},"tan =",{"$f":"IF(K23<0.00001,10000000,1/K23)","v":10000000},null,"ausnutzung",null,0.3,{"$f":"IF(AND($R$21>0,$R$21<=Q22),1,0)","v":1}]
[null,"Betongüte","f_ck","eps_c2","eps_c2u","n","f_cd",null,null,"cot =",{"$f":"1/TAN(K22*PI()/180)","v":6.1257422745431001E-17},"sin =",{"$f":"SIN(K22*PI()/180)","v":1},null,null,null,0.6,{"$f":"IF(AND($R$21>Q22,$R$21<=Q23),2,0)","v":0}]
[null,"C 12/15",12,-2,-3.5,2,{"$f":"C24/$E$8*$H$20","v":6.8},null,null,"Neigung der Druckstrebe",null,null,null,null,null,null,1,{"$f":"IF(AND($R$21>Q23,$R$21<=Q24),3,0)","v":0}]
[null,"C 16/20",16,-2,-3.5,2,{"$f":"C25/$E$8*$H$20","v":9.0666666666666664},null,null,"theta =",{"$f":"ATAN(1/K45)*180/PI()","v":18.43494882292201},{"$f":"ATAN(1/K44)*180/PI()","v":18.43494882292201},"Grenzen",null,null,null,"Bereich =",{"$f":"MAX(R22:R24)","v":1}]
[null,"C 20/25",20,-2,-3.5,2,11.333333333333334,null,null,"cot =",{"$f":"1/TAN(K25*PI()/180)","v":3},"max cot =",{"$f":"IF(B2=1,3,2)","v":3}]
[null,"C 25/30",25,-2,-3.5,2,14.166666666666668,null,null,"tan =",{"$f":"1/K26","v":0.33333333333333331},"min cot =",1,null,"Abstände",".. in Längsrich.",".. für Schrägst.",".. in Querricht."]
[null,"C 30/37",30,-2,-3.5,2,17,null,null,null,null,null,null,null,1,{"$f":"IF(C58<=50,MIN(0.7*K3,300),MIN(0.7*K3,200))","v":224},{"$f":"0.5*K3*(1+K23)","v":160},{"$f":"IF(C58<=50,MIN(K3,800),MIN(K3,600))","v":320}]
[null,"C 35/45",35,-2,-3.5,2,19.833333333333332,null,null,"Mittlere Betonzugfestigkeit",null,null,null,null,2,{"$f":"IF(C58<=50,MIN(0.5*K3,300),MIN(0.5*K3,200))","v":160},{"$f":"0.5*K3*(1+K23)","v":160},{"$f":"IF(C58<=50,MIN(K3,600),MIN(K3,400))","v":320}]
[null,"C 40/50",40,-2,-3.5,2,22.666666666666668,null,null,"f_ctm =",{"$f":"IF(C58<55,0.3*C58^(2/3),2.12*LN(1+(C58+8)/10))","v":2.2104188991842313},"[N/mm²]",null,null,3,{"$f":"MIN(0.25*K3,200)","v":80},{"$f":"0.5*K3*(1+K23)","v":160},{"$f":"IF(C58<=50,MIN(K3,600),MIN(K3,400))","v":320}]
[null,"C 45/55",45,-2,-3.5,2,25.5,null,null,"allgem. rho =",{"$f":"0.16*K30/C15*1000","v":0.70733404773895403},"[o/oo]",null,null,null,{"$f":"INDEX(P28:P30,$R$25)","v":224},{"$f":"INDEX(Q28:Q30,$R$25)","v":160},{"$f":"INDEX(R28:R30,$R$25)","v":320}]
[null,"C 50/60",50,-2,-3.5,2,28.333333333333336,null,null,null,null,null,null,null,"Abmind. =",{"$f":"IF(K49=0,0,0.6)","v":0.6},null,"für Mindest-"]
[null,"C 55/67",55,-2.2000000000000002,-3.1,1.75,31.166666666666664,null,null,"Hilfsgrößen",null,null,null,null,"Hilfswert =",{"$f":"1-(K9-4)*(1-P32)","v":1.1000000000000001},null,"querkr.-beweh."]
[null,"C 60/75",60,-2.2999999999999998,-2.9,1.6,34,null,null,"C_Rd,c =",{"$f":"0.15/E8","v":9.9999999999999992E-2},"[1]",null,null,"Multiplikator",{"$f":"IF(P33>1,1,IF(P33<0,0,P33))","v":1},"für Mindestbew."]
[null,"C 70/85",70,-2.4,-2.7,1.45,39.666666666666664,null," ","k =",{"$f":"MIN(2,1+(200/K4)^0.5)","v":1.8770580193070292},"[1]","<= 2,0"]
[null,"C 80/95",80,-2.5,-2.6,1.4,45.333333333333336,null,null,"sigm_cd =",{"$f":"MIN(K16/K2/K3,0.2*G58)","v":0},"[N/mm²]",">0 (Druck)"]
[null,"C 90/105",90,-2.6,-2.6,1.4,51,null,null,"rho_l =",{"$f":"100*MIN(100*K8/K2/K4,0.02)","v":0.30192307692307691},"[%]","<= 2 %"]
[null,"C 100/115",100,-2.6,-2.6000999999999999,1.4,56.666666666666671,null,null,"Vorfaktor =",{"$f":"IF(K4<=600,0.0525,IF(K4>800,0.0375,0.0975-0.015/200*K4))","v":5.2499999999999998E-2},"[1]"]
[null,null,null,null,null,null,null,null,null,"v_min =",{"$f":"K38/E8*K35^1.5*C58^0.5","v":0.40253123645425509},"[N/mm²]"]
[null,{"$f":"SucheZeile(G40,B44:B54)","v":3},"Parabel-Rechteck-Diagramm (Leichtbeton)",null,null,null,"LC 20/22",0.75,null,"V_Rd,c =",{"$f":"K2*K4*MAX(K34*K35*(K37*C58)^(1/3)+0.12*K36,K39+0.12*K36)","v":125589.74577372758},"[N]",null,null,"Grafik 2"]
[null,"Betongüte","f_ck","eps_c2","eps_c2u","n","f_cd","rho",null,null,null,null,null,null,"PlotArea"]
[null,{"$f":"INDEX(B44:B54,$B$40)","v":"LC 20/22"},20,-2,-2.6409090909090911,2,1,1300,null,"V_Rd,cc =",{"$f":"0.24*C58^(1/3)*(1-1.2*K36/G58)*K2*K7","v":164167.97745165991},"[N]",null,null,"Breite","Höhe"]
[null,"Betongüte","f_ck","eps_c2","eps_c2u","n","f_cd","rho",null,"cottheta =",{"$f":"IF(M43=0,M26,(1.2+1.4*K36/G58)/(1-K42/K15))","v":5.4983390648800166},"(kalkuliert)",{"$f":"IF(K42<=K15,1,0)","v":1},null,{"$f":"4*K6/10","v":93.6},{"$f":"K3/10","v":32}]
[null,"LC 12/13",12,-2,{"$f":"-3.5*(0.4+0.6*H44/2200)","v":-2.5454545454545454},2,{"$f":"C44/10/$E$8*$H$40","v":0.6},1200,null,"cottheta =",{"$f":"IF(K43>M26,M26,IF(K43<M27,M27,K43))","v":3},"(maßgebend)",null,null,"Unteres Zugband",null,"Oberer Druckgurt"]
[null,"LC 16/18",16,-2,{"$f":"-3.5*(0.4+0.6*H45/2200)","v":-2.5454545454545454},2,0.8,1200,null,"cottheta =",{"$f":"1/TAN(Ergebnisse!J30*PI()/180)","v":3},"(gewählt)",null,null,0,{"$f":"(K3-K4)/10","v":6},0,{"$f":"(K3-K4+K7)/10","v":27}]
[null,"LC 20/22",20,-2,-2.6409090909090911,2,1,1300,null,"v_1 =",{"$f":"0.75*MIN(1,1.1-C58/500)","v":0.75},null,null,null,{"$f":"O43","v":93.6},{"$f":"P45","v":6},{"$f":"O43","v":93.6},{"$f":"R45","v":27}]
[null,"LC 25/28",25,-2,-2.6409090909090911,2,1.25,1300,null,"V_Rd,max =",{"$f":"K2*K7*K46*G58*(K26+K23)/(1+K26*K26)","v":642600},"[N]",null,null,"Diagonale Druckstrebe 1",null,"Bügel/Schrägaufbiegung 1"]
[null,"LC 30/33",30,-2,-2.7363636363636363,2,1.5,1400,null,"V_Rd,s =",{"$f":"IF(K14<K40,0,K14)","v":150000},"[N]",null,null,0,{"$f":"P45","v":6},{"$f":"O49","v":63},{"$f":"IF(AND(M2,K48<K40),P48,P49)","v":27}]
[null,"LC 35/38",35,-2,-2.831818181818182,2,1.75,1500,null,"a_sw =",{"$f":"10*K48/(E15*K7*(K26+K23)*M23)","v":5.4761904761904763},"[cm²/m]",null,null,{"$f":"K7/K27/10","v":63},{"$f":"K7/10+P48","v":27},{"$f":"O49+0.1*K7/M22","v":63.000002100000003},{"$f":"P48","v":6}]
[null,"LC 40/44",40,-2,-2.831818181818182,2,2,1500,null,"rho_w =",{"$f":"100*K49/K2/M23","v":0.45634920634920634},"[%]",null,null,"Diagonale Druckstrebe 2",null,"Bügel/Schrägaufbiegung 2"]
[null,"LC 45/50",45,-2,-2.9272727272727277,2,2.25,1600,null,"rho_w,min =",{"$f":"K31*P34","v":0.70733404773895403},"[%]",null,null,{"$f":"Q49","v":63.000002100000003},{"$f":"R49","v":6},{"$f":"O52","v":126.0000021},{"$f":"R48","v":27}]
[null,"LC 50/55",50,-2,-2.9272727272727277,2,2.5,1600,null,"a_sw,min =",{"$f":"K51*K2*M23*P34/100","v":8.4880085728674484},"[cm²/m]",null,null,{"$f":"O51+O49","v":126.0000021},{"$f":"P49","v":27},{"$f":"O52+0.1*K7/M22","v":126.00000420000001},{"$f":"P51","v":6}]
[null,"LC 55/60",55,-2.0299999999999998,{"$f":"-3.1*(0.4+0.6*H53/2200)","v":-2.6772727272727272},1.75,2.75,1700,null,null,null,null,null,null,"Diagonale Druckstrebe 3",null,"Bügel/Schrägaufbiegung 3"]
[null,"LC 60/66",60,-2.06,{"$f":"-2.9*(0.4+0.6*H54/2200)","v":-2.5836363636363635},1.6,3,1800,null,"Grafik 1","[kN]","[kN]","Skalierung",null,{"$f":"Q52","v":126.00000420000001},{"$f":"R52","v":6},{"$f":"O55","v":189.00000420000001},{"$f":"R51","v":27}]
[null,null,null,null,null,null,null,null,null,"V_Ed",{"$f":"K14/1000","v":150},null,1,null,{"$f":"O54+O49","v":189.00000420000001},{"$f":"P52","v":27},{"$f":"O55+0.1*K7/M22","v":189.0000063},{"$f":"P54","v":6}]
[null,{"$f":"B2","v":1},"Betonart (Normal = 1; Leicht = 2)",null,null,null,null,null,null,"V_Rd,c",{"$f":"K40/1000","v":125.58974577372759},null,250,null,"Diagonale Druckstrebe 4",null,"Bügel/Schrägaufbiegung 4"]
[null,"Betonart","f_ck","eps_c2","eps_c2u","n","f_cd","rho",null,"V_Rd,s",{"$f":"K48/1000","v":150},{"$f":"K52*E15*K7*(K26+K23)*M23/100/100","v":232.49762612636923},{"$f":"M55*M56","v":250},null,{"$f":"Q55","v":189.0000063},{"$f":"R55","v":6},{"$f":"O58","v":252.0000063},{"$f":"R54","v":27}]
[null,{"$f":"IF($B$2=1,B22,B42)","v":"C 20/25"},20,-2,-3.5,2,11.333333333333334,2200,null,"V_Rd,max",{"$f":"K47/1000","v":642.6},null,null,null,{"$f":"O57+O49","v":252.0000063},{"$f":"P55","v":27},{"$f":"O58+0.1*K7/M22","v":252.00000839999998},{"$f":"P57","v":6}]