{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["%承载力计算-抗弯-矩形截面-双筋"],"not_rendered":{"images":1,"external_links":3,"defined_names":76},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"%承载力计算-抗弯-矩形截面-双筋","index":0,"n_rows":40,"n_cols":15,"rows_kept":40,"merged":[[0,0,0,3],[0,5,0,14],[1,2,1,3],[5,2,5,3],[13,0,13,3],[18,0,18,3],[28,0,28,3],[30,0,30,3],[33,0,37,3]],"flags":["formulas_cached_only"]}
["钢筋和混凝土指标",{"$nulls":4},"混凝土强度及弹性模量"]
["C",30,"C?(20,25,30,35,40,45,50,55) 混凝土等级",null,null,"强度","类型","C20","C25","C30","C35","C40","C45","C50","C55"]
["fc＝",14.3,"(N/mm2)","混凝土抗压强度设计值 fck",null,"fc","N/mm2",9.6,11.9,14.3,16.7,19.1,21.1,23.1,25.3]
["ft＝",1.43,"(N/mm2)","混凝土抗拉强度设计值 ft",null,"ft","N/mm2",1.1,1.27,1.43,1.57,1.71,1.8,1.89,1.96]
["Ec＝",30000,"(N/mm2)","混凝土弹性模量 Ec",null,"Ec","N/mm2",25500,28000,30000,31500,32500,33500,34500,35500]
["HRB",335,"HRB(235,335,400) 纵筋强度等级",null,null,"强度","类型","HPB235","HRB335","HRB400"]
["fy＝",300,"(N/mm2)","纵筋抗拉压强度设计值 fy",null,"fy","N/mm2",210,300,360]
["Es＝",200000,"(N/mm2)",null,null,"Es","N/mm2",210000,200000,200000]
["α1＝",{"v":1,"d":"1.00"},null,"1.0<C50<内插<C80<0.94"]
["β1＝",{"v":0.8,"d":"0.80"},null,"0.8<C50<内插<C80<0.74"]
["ξb＝",0.55,null,"ξb＝β1/(1+fy/0.0033Es)"]
["αE＝",{"v":6.666666666666667,"d":"6.67"},null,"αE＝Es/Ec"]
[]
["梁截面尺寸"]
["b＝",250,"(mm)","梁宽度 b"]
["h＝",500,"(mm)","梁高度 h"]
["ca＝",35,"(mm)","混凝土保护层厚度 ca"]
["h0＝",465,"(mm)","梁有效高度 h0=h-ca"]
["纵向钢筋：3φ22"]
["N＝",3,null,"纵筋根数 N"]
["φ＝",22,"(mm)","纵筋直径 φ"]
["As＝",{"v":1140.39813195,"d":"1140"},"(mm2)","纵筋面积 As=N*(Pi*φ^2/4)"]
["ρ＝",{"v":0.009809876403870968,"d":"0.98%"},null,"纵筋配筋率 ρ=As/(b*h0)"]
["Ny＝",2,null,"压筋根数 Ny"]
["φy＝",20,"(mm)","压筋直径 φy"]
["Asy＝",{"v":628.31853,"d":"628"},"(mm2)","压筋面积 Asy=Ny*(Pi*φy^2/4)"]
["ρy＝",{"v":0.005404890580645161,"d":"0.54%"},null,"压筋配筋率 ρy=Asy/(b*h0)"]
["ξ＝",{"v":0.0924122899977442,"d":"0.092"},null,"相对受压区高度 ξ=ρ*fy/(α1*fc)"]
["注意：ξ<ξb，将继续计算！"]
["x＝",{"v":42.97171484895105,"d":"43"},"(mm)","受压区高度 x=ξ*h0"]
["注意：x < 2ca，受压钢筋不屈服，取x＝2ca＝70(mm) 近似计算！"]
["Mu＝",{"v":147.11135902155002,"d":"147.1"},"(kN-m)","抗弯承载力 Mu"]
[]
["说明：\n1。若ξ>ξb，则说明纵筋超筋，需要减少纵筋面积再进行计算！\n2。若 x < 2ca，则说明当压区混凝土达到极限压应变是受压钢筋还未屈服，这时取 x＝2ca近似计算！"]
[]
[]
[]
[]
[]
["声明：\n1。本程序为上海同济大学2003级结构工程李凌志编制整理，目的是为了便于在电脑上用Excel和在PDA上用Pocket Excel进行简单的结构手算，程序根据新规范编制，如有什么疑问请联系我，以便立刻修正！\n2。程序中黄底红字的部分需要使用者根据实际情况输入，黑色的部分请不要随便更改，除非你发现有错误！\nemail：lingzhi0512@hotmail.com\nOICQ：49551484\n如需获得更多Excel手算程序请登录 www.MyWebStudio.net"]