{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["51米钢烟囱 (自立式)"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"51米钢烟囱 (自立式)","index":0,"n_rows":91,"n_cols":9,"rows_kept":91,"cut":false,"hidden":false,"merged":[[64,1,64,3],[69,2,69,3],[70,0,70,2],[71,0,71,2],[84,7,84,8],[85,0,85,1],[85,4,85,5],[74,0,74,2],[75,0,75,2],[78,5,78,6],[79,5,79,6],[80,0,80,2],[84,5,84,6],[60,0,60,2],[61,0,61,2],[62,0,62,2],[63,0,63,2],[63,5,63,7],[55,0,55,2],[55,5,55,6],[56,0,56,2],[57,0,57,2],[58,1,58,6],[46,4,46,6],[47,2,47,6],[48,2,48,8],[51,2,51,5],[54,5,54,6],[25,4,25,5],[38,6,38,7],[41,0,41,2],[42,0,42,2],[45,5,45,6],[0,0,0,1],[0,2,0,6],[0,7,0,8],[10,4,10,5],[11,4,11,5],[90,0,91,8],[3,1,3,5],[4,1,4,5],[5,1,5,5],[6,1,6,5],[9,4,9,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[12,4,12,5],[17,4,17,5],[18,4,18,5],[19,3,19,5],[20,4,20,7],[22,1,22,8]]}
["渝石网络",null,"自立式钢烟囱计算书"]
[]
["1 设计依据:"]
[null," 《建筑结构荷载设计规范》  GB50009-2001（2006）"]
[null," 《建筑抗震设计规范》      GB50011-2001"]
[null,"《高耸结构设计规范》      GBJ 135-90"]
[null,"《烟囱设计规范》          GB50051-2002"]
[]
["2 烟囱资料:"]
["钢烟囱高度H",15.8,"(m)",null,"H/d",null,{"$f":"B10/B12","v":9.875}]
["上部外径d1",1.2,"(m)",null,"平台直径",null,4,"(m)"]
["下部外径d2",1.6,"(m)",null,"平台个数",null,1,"个"]
["上部壁厚t1",10,"(mm)",null,"上部高度",null,6,"(m)"]
["下部壁厚t2",8,"(mm)",null,"下部高度",null,{"$f":"B10-G13","v":9.8000000000000007},"(m)"]
["钢材牌号","Q235",null,null,"ft",null,{"$f":"IF(B14<=16,215,IF(B14>=40,200,205))","v":215},"（N/mm2）"]
["截面面积A1",{"$f":"PI()*((B11*1000)^2-(B11*1000-2*B13)^2)/4","v":37384.952577718541},"(mm2)",null,"截面抵抗矩Wt1",null,{"$f":"PI()*((B11*1000)^4-(B11*1000-2*B13)^4)/(B11*10^3)/32","v":11030118.716784375},"(mm3)"]
["截面面积A2",{"$f":"PI()*((B12*1000)^2-(B12*1000-2*B14)^2)/4","v":40011.324036119608},"(mm2)",null,"截面抵抗矩Wt2",null,{"$f":"PI()*((B12*1000)^4-(B12*1000-2*B14)^4)/(B12*10^3)/32","v":15845284.544784086},"(mm3)"]
["旋转半径i1",{"$f":"SQRT(PI()*((B11*1000)^4-(B11*1000-2*B13)^4)/64/B16)","v":420.74338972822852},"(mm)",null,"长细比λ1",null,{"$f":"2*B10*1000/B18","v":75.105160940048137}]
["旋转半径i2",{"$f":"SQRT(PI()*((B12*1000)^4-(B12*1000-2*B14)^4)/64/B17)","v":562.86410438044459},"(mm)",null,"长细比λ2",null,{"$f":"2*B10*1000/B19","v":56.141437611806374}]
["重力荷载代表值GE",{"$f":"PI()*(B12-B14/1000)*B14/1000*G14*78.5+PI()*(B11-B13/1000)*B13/1000*G13*78.5+PI()*(G11*G11-B11*B11)/4*(2+2.5)*G12","v":99.848311910893059},"(kN)"]
["自振周期(按烟囱规范):"]
["T1=0.26+0.0024H2/d=",1.1880999999999999,"(S)"]
[null,{"$f":"IF(G10>25,\"警告   H/d>25  底部直径不满足GB50051-2002自立式要求!!\",\"\")","v":""}]
[]
["3 竖向荷载计算:"]
["重力标准值Gk",{"$f":"PI()*(B12-B14/1000)*B14/1000*G14*78.5+PI()*(B11-B13/1000)*B13/1000*G13*78.5+PI()*(G11*G11-B11*B11)/4*2*G12","v":71.259818763225937},"(kN)",null,"平台活荷标准值Qk",null,{"$f":"PI()*(G11*G11-B11*B11)/4*2.5*G12","v":28.588493147667119},"(kN)"]
[]
["4 风荷载计算:"]
["基本风压ω0",3.52,"(kN/m2)",null,null,null,"地面粗糙度：","B","类"]
["ω0*T12＝",{"$f":"B29*B22*B22","v":4.9687672671999996},null,"查表得：","ξ=",2.3774999999999999]
["z(m)","z/H","φz","ν","μz","βz","μzω0d2","μs","ωk"]
[10,{"$f":"A32/B10","v":0.63291139240506322},0.06,0.87,1,{"$f":"1+F30*D32*C32/E32","v":1.1241055},{"$f":"E32*B29*B12*B12","v":9.0112000000000005},1.1000000000000001,{"$f":"F32*H32*E32*B29","v":4.3525364959999999}]
[20,{"$f":"A33/B10","v":1.2658227848101264},0.23,0.87,1.25,{"$f":"1+F30*D33*C33/E33","v":1.3805901999999999},{"$f":"E33*B29*B12*B12","v":11.264000000000003},1.1000000000000001,{"$f":"F33*H33*E33*B29","v":6.6820565680000001}]
[30,{"$f":"A34/B10","v":1.8987341772151898},0.46,0.87,1.42,{"$f":"1+F30*D34*C34/E34","v":1.6700531690140845},{"$f":"E34*B29*B12*B12","v":12.795904000000002},1.1000000000000001,{"$f":"F34*H34*E34*B29","v":9.1823531359999997}]
[40,{"$f":"A35/B10","v":2.5316455696202529},0.79,0.87,1.56,{"$f":"1+F30*D35*C35/E35","v":2.0474716346153849},{"$f":"E35*B29*B12*B12","v":14.057472000000002},1.1000000000000001,{"$f":"F35*H35*E35*B29","v":12.367383864000004}]
[{"$f":"B10","v":15.8},{"$f":"A36/B10","v":1},1,0.87,1.68,{"$f":"1+F30*D36*C36/E36","v":2.2312053571428572},{"$f":"E36*B29*B12*B12","v":15.138816},1.1000000000000001,{"$f":"F36*H36*E36*B29","v":14.513901600000002}]
["备注：","z—","计算高度",null,"ν—","脉动影响系数"]
[null,"z/H—","相对高度",null,"μz—","风压高度系数"]
[null,"φz—","振型系数",null,"βz—","风振系数","βz=1+ξνφz/μz"]
[null,"μs—","风荷载体型系数",null,"ξ—","脉动增大系数"]
[null,"ωk—","风荷载标准值 ωk=βzμsμzω0"]
["烟囱顶部风荷载标准值ωk1=ωkd1",null,null,{"$f":"I36*B11","v":17.416681920000002},"（kN/m）"]
["底部风荷载弯矩标准值 M1k=ωk1H2/3",null,null,{"$f":"(D42*B10^2)/3","v":1449.3001581696001},"(kN.m)"]
[]
["4 横风向风振计算:"]
["自振周期T1",{"$f":"B22","v":1.1880999999999999},null,"截面直径D",{"$f":"(B11+B12)/2","v":1.4},"空气密度ρ",null,1.2929999999999999,"Kg/m3"]
["斯托罗哈数St",0.2,null,null,"顶部风压高度变化系数μH",null,null,{"$f":"E36","v":1.68}]
["临界风速vcr=D/TiSt",{"$f":"(B11+B12)/2/B22/0.2","v":5.8917599528659199},"顶部风速Vh＝(2000μHω0/ρ)1/2",null,null,null,null,{"$f":"SQRT(2000*E36*B29/1.293)","v":95.640471391463976},"(m/s)"]
["雷诺数Re=69000vD",{"$f":"69000*B48*(B11+B12)/2","v":569144.01144684781},{"$f":"IF(B49<3*10^5,\"Re<3.E+05, 可发生亚临界的微风共振，须在构造上采取防振措施！\",IF(B49>=3*10^6,\"Re>=3.E+06, 可发生跨临界的强风共振，应考虑共振效应！\",\"3.E+05<=Re<3.E+06, 发生超临界范围的共振，可不做处理！\"))","v":"3.E+05<=Re<3.E+06, 发生超临界范围的共振，可不做处理！"}]
[]
["5 地震荷载计算:"]
["抗震设防烈度：",8,{"$f":"IF(B52<=7,\"可不考虑竖向地震作用！\",\"需考虑竖向地震作用！\")","v":"需考虑竖向地震作用！"},null,null,null,"加速度：","0.10g"]
["结构阻尼比ζ：",0.01,null,"地震分组：","第一组",null,"场地类别：","IV"]
["查表 剪力修正系数ηC",0.75,null,"αmax",0.04,null,"特征周期Tg(s)",0.35]
["下降斜率调整系数η1",{"$f":"0.02+(0.05-B53)/8","v":2.5000000000000001E-2},null,"阻尼调整系数η2",{"$f":"1+(0.05-B53)/(0.06+1.7*B53)","v":1.5194805194805197},"衰减指数γ",null,{"$f":"0.9+(0.05-B53)/(0.5+5*B53)","v":0.97272727272727277}]
[{"$f":"IF(B22<H54,\"地震影响系数α1=η2αmax\",IF(B22>=5*H54,\"地震影响系数α1=[0.2γη2-η1(T-5Tg)]αmax\",\"地震影响系数α1=(Tg/T)γη2αmax\"))","v":"地震影响系数α1=(Tg/T)γη2αmax"},null,null,{"$f":"IF(B22<H54,E54*E55,IF(B22>5*H54,(0.2^H55*E55-B55*(B22-5*H54))*E54,(H55/B22)^H55*E54*E55))","v":5.0033649923247929E-2},null,"烟囱顶至重心距离h0",null,{"$f":"B10/2","v":7.9},"(m)"]
["底部地震弯矩标准值 M2k=α1GEH0",null,null,{"$f":"D56*H56*B20","v":39.466626320257433},"(kN.m)"]
["底部地震剪力标准值 V2k=ηCα1GE",null,null,{"$f":"B54*D56*B20","v":3.7468316126826671},"(kN)"]
[]
["6 荷载组合:"]
["轴力设计值 N=1.35Gk＋1.4×0.7×Qk",null,null,{"$f":"1.35*B26+1.4*0.7*G26","v":124.2174786150688},"（kN）"]
["      弯矩设计值"]
["非地震组合               M=1.4×M1k",null,null,{"$f":"1.4*D43","v":2029.0202214374399},"(kN.m)"]
["地震组合  M=1.3×M2k+0.2×1.4×M1k",null,null,{"$f":"1.3*D57+0.2*1.4*D43","v":457.11065850382261},"(kN.m)","截面抗震调整系数γRE ＝",null,null,0.8]
[null,{"$f":"IF(D64*I64<=D63,\"非地震组合控制\",\"地震组合控制 \")","v":"非地震组合控制"}]
["验算荷载","N＝",{"$f":"D61","v":124.2174786150688},"（kN）","M=",{"$f":"MAX(D63,D64*0.75)","v":2029.0202214374399},"(kN.m)"]
[]
["7 截面荷载计算:"]
["1. 强度验算"]
["γx=",{"$f":"1.15","v":1.1499999999999999},"局部抗压调整系数k",null,{"$f":"IF(D63>D64,\"1.5\",\"1.2\")","v":"1.5"}]
["σ=N/A2 +M/(γxWt2) （N/mm2）",null,null,{"$f":"D61*10^3/B17+F66*10^6/1.15/G17","v":114.45411476840424},"<",{"$f":"IF(D64*0.75<=D63,\"ft=\",\"ft/γRE=\")","v":"ft="},{"$f":"IF(D64*0.75<=D63,G15,G15/I64)","v":215},{"$f":"IF(D71<G71,\"满足！\",\"不满足！\")","v":"满足！"}]
["筒壁局部稳定    0.4Ett2/k/d2 （N/mm2）",null,null,{"$f":"0.4*2.06*10^5*B14/E70/B12/1000","v":274.66666666666669},">","σ＝",{"$f":"D71","v":114.45411476840424},{"$f":"IF(D72>=D71,\"满足！\",\"不满足！\")","v":"满足！"}]
[]
["2. 稳定验算"]
["Nex=π2EA/(1.1λ2)(N)",null,null,{"$f":"PI()*2.06*10^5*B17/1.1/G19^2","v":7468618.4331665346},null," 查表","φ=",0.65500000000000003]
["σ=N/φA2 +M/Wt2(1-0.8N/NEX) （N/mm2）",null,null,{"$f":"D61*10^3/H75/B17+F66*10^6/G17/(1-0.8*D61*10^3/D75)","v":134.5185497614963},"<",{"$f":"IF(D64*0.75<=D63,\"ft=\",\"ft/γRE=\")","v":"ft="},{"$f":"IF(D64*0.75<=D63,G15,G15/I64)","v":215},{"$f":"IF(D76<G76,\"满足！\",\"不满足！\")","v":"满足！"}]
[]
["8 地脚螺栓选择:"]
["螺栓布置所在圆直径d0",2300,"（mm）",null,null,"螺栓数量n",null,36,"(个)"]
["螺栓材质","Q235",null,null,null,"螺栓直径de",null,24,"（mm）"]
["螺栓所受最大拉力为：Pmax＝4M/nd0-N/n=",null,null,{"$f":"4*F66*10^6/H79/B79/1000-D61/H79","v":94.569815035448087},"(kN)"]
["选用M36","P＝",114.3,"(kN)",null,"（螺栓布置见附图）"]
[]
["9 基础局部受压应力:"]
["基础混凝土强度等级 C",30,"βl＝3","混凝土ft",{"$f":"IF(B85=20,1.1,IF(B85=25,1.27,IF(B85=30,1.43,IF(B85=35,1.57,IF(B85=40,1.71,IF(B85=15,0.91))))))","v":1.43},"荷载分布影响系数ω",null,0.67500000000000004]
["混凝土局部压应力σcbt=N/A+M/W=",null,{"$f":"D61*1000/(PI()*B79^2/4)+32*F66*10^6/(PI()*B79^3)","v":1.7285440172291904},{"$f":"IF(B86>E86,\">\",(IF(B86=85,\"=\",\"<\")))","v":"<"},{"$f":"IF(D64*0.75<=D63,\"ωβlft=\",\"ωβlft/γRE=\")","v":"ωβlft="},null,{"$f":"IF(D64*0.75<=D63,H85*3*E85,H85*3*E85/I64)","v":2.8957500000000005},{"$f":"IF(C86<G86,\"满足！\",\"不满足！\")","v":"满足！"}]
[]
["10 烟囱顶部位移:"]
["fmax=11ql4/120EI=",{"$f":"11*D42*POWER((B10*1000),4)/120/206000/((PI()*(POWER((B11*1000),4)-POWER((B11*1000-2*B13),4)))/64)","v":72.980452170406238},"mm"]
["H/fmax=",{"$f":"B10*1000/B89","v":216.49632922399104},{"$f":"IF(B90>D90,\">\",\"<=\")","v":">"},100,{"$f":"IF(B90>D90,\"满足！\",\"不满足！\")","v":"满足！"}]
["网上飞石 制作 \n联系人：黄建春 E-mail: hjc13404@163.com\n联系电话：15730252870  QQ群：179510416\n版权所有：渝石网络(http://www.fishsting.com)\n参考资料：渝石网络内部资料"]