1、厚度宽度标距原始标距屈服强度抗拉强度荷载应力荷载115.920.1100101.01135.83425169.38215.720100100.12133.45425169.56315.819.810099.93129.83415167.37415.719.510098.86133.18435169.91515.920.2100101.26139.71435171.836600007 50#VALUE!#VALUE!#VALUE!850000985000109.619.948078.1787.86459106.431110.820.28583.4595.99440115.841210.419.9
2、58081.3891.5441115.9813130000141300001555000130平板间距SDH10.07812162.8920.0766037.7630.0768345.1240.071020389.7250.071021992.5160.0714219111.8570.0714245117.8280.0714245117.8290.0714245117.82100.0714245117.82序号公称厚度厚度宽度标距原始标距 屈服荷载 屈服强度12019.720.4113.27110155.9338822019.620.2112.42110151.2438232019.919.8
3、112.15110158.440242019.619.8111.3110157.9540752019.719.8111.59110159.9241062019.720.1112.43110150.8638172019.619.8111.3110158.7240982019.920112.72110164.374139202020.2113.56110158.37392102019.920.3113.56110156.74388序号公称厚度厚度宽度标距原始标距 屈服荷载 屈服强度12220.235.915016.93419243.819.548.645031.27422365.719.860.0
4、26047.29419498.820.375.527574.674185109.920.279.98085.1942661211.519.684.838593.3241471413.920.394.9195113.154018161619.7100.31100127.0340391817.720106.3110147.97418102423.820.3124.19125204.37423断后标距伸长率直径标距面积原始标距应力5301313111680201.061926805401303021680201.061926805351292931890254.46900190555132.532.
5、541890254.4690019053513030520100314.1592610060620100314.1592610050725130490.87384412550825130490.87384412585929.8150697.464973149556101.226.51029.9150702.1538150531108.8281141.62101359.17862208559101.6271241.82101372.279062091301312.6124.68981631301412.3118.82288662551512.5122.718461631612.3118.8228
6、866217001824.8125483.0512781241919.8307.907491992000210220230242526抗拉荷载抗拉强度 断后标距伸长率221.03550140.82838855028210.23531139.526.838253126.8215.92548138.826.240254826.2201.41519143.730.640751930.6211.8543141.528.641054328.6212.24536143.430.438153630.4213.4455013926.440955026.4抗拉强度214.92540142.129.2413540
7、29.2221.39548141.128.339254828.3210.065201433038852030抗拉荷载抗拉强度 断后标距伸长率21.82540653038.1651565.53160.7253878.63194.1452798.331106.79534103.229116.53517109.729150.68534123.530161.3851213030184.43521141.929248.33514161.329屈服强度抗拉强度断后标距伸长率荷载应力荷载应力83.44415134.71670101.226.582.44410135.72675100.826103.06405
8、175.58690112.525104.33410175.5869011325.5119.38380199.81636125.525.5119.69381202.3264412525194.39396318.58649159.923191.44390317.1646160.623.5272.71391447.08641187.525268.22382445.876351892683.04421888.9654259.423.582.38416900.22656260.42485.4568550.5405079.6267048.12405085.3569549.7405085.9872448.1
9、24050130.160.269453795199.160.412295773197.90.642725513119.50.388103582#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!螺栓直径预拉力P施扭矩值T扭矩系数Kk平均值k标准偏差22194.845390.1260.0980.01280.1260.12522104.232040.0890.12822104.042280.10.12122104.561960.0850.1222104.872370.1030.12622104.762140.0930.12522104.1
10、82080.0910.1322104.362200.0960.122螺栓预拉力P范围KN等级10.9s规格M12M16M20M22M24M27最大66121187231275352最小5499153189225288等级8.8s规格M12M16M20M22M24M27最大5599154182215281最小4581126149176230备注：M20 158M22 194 M24 230 M27 293M30 356GB/T1231-2006K=T / P.d螺栓直径预拉力P施扭矩值T扭矩系数Kk平均值k标准偏差1259.42960.1350.1460.00641259.84990.13812
11、59.721060.1481259.641020.1431259.441090.1531259.621060.1481259.81090.15212591050.148螺栓直径预拉力P施扭矩值T扭矩系数Kk平均值k标准偏差16104.142220.1330.1440.008116104.82250.13416104.722340.1416104.322570.15416104.082460.14816104.882430.14516104.082570.15416104.542460.147螺栓直径预拉力P施扭矩值T扭矩系数Kk平均值k标准偏差20158.14170.1320.1370.005
12、620158.184170.13220158.824260.134201584110.13 20158.744370.13820158.744430.1420158.84540.14320158.124580.145螺栓直径预拉力P施扭矩值T扭矩系数Kk平均值k标准偏差22194.45370.1260.1250.002722194.265320.12422194.185300.12422194.745360.12522194.085510.129221945150.12122194.745360.12522194.945530.129螺栓直径预拉力P施扭矩值T扭矩系数Kk平均值k标准偏差242
13、30.68380.1510.1450.008824230.987700.13924230.348400.15224230.388530.15424230.98470.15324230.288110.14724230.747470.13524230.447320.132螺栓直径预拉力P施扭矩值T扭矩系数Kk平均值k标准偏差27293.410980.1390.1310.005327293.29860.12527293.7410330.1327293.510030.12727293.089850.12427293.0810250.1327293.910680.13527293.1210710.135
14、螺栓直径预拉力P施扭矩值T扭矩系数Kk平均值k标准偏差30356.3413370.1250.1220.004330356.6213280.12430356.6613770.12930356.612570.11730356.812990.12130356.1412440.11630356.3212670.11930356.913110.122楔负载性能螺纹规格M12M16M20M22M24M27M30公称截面积84.315724530335345956110.9S拉力（最小）KN87.7163255315367477583拉力（最大）KN104.51953043764385696968.8S拉力
15、（最小）KN70130203251293381466拉力（最大）KN86.81622523123644735780.0035M30429351M30341279 扭剪紧固轴力M16M20M22M24公称109170211245单位KNmin99154191222max120186231270标准偏差10.115.719.522.7GB50205-2001GB/T 3632-2008紧固轴力M16M20M22M24扭剪紧固轴力M16M20M221109.52161.38216.6269.1公称1101712092112176.44197.36251.3单位KNmin1001551903103.7
16、8164.5198.78248.42max1211882304118.56170.88225.48278.32标准偏差1015.5195114.16157.76211.86247.885065606102.52187.6218.06255.947112.04172.9200.1259.328122.78187.5211.22248.68平均值112172210257标准偏差6.8411.1910.2611.12100-121155-188190-230225-2721305.262326.343301.584334.625315.486329.327341.58315.4832114.1M24
17、M27M30M27M30248319391321.32401.64225290355330.44401.68272351480326.6372.1222.52935.5325.48414.92657075317.06387.68M24M20M30M22291.78360.72实物拉力397.88275.29620.56360.38340.94371.76390.22269.76618.29362.26319.64418.5395.67275.9622.03359.35322391392.69272.46624.14360.3814.1721.41398.55269.33616.52364.62
18、290-351355-430397.11276.04622.17361.45394.42274.17621.83359.75395.87272.7620.68357.25GB/T 3632-200810.9S传感器517M160.9511.05正算反算95100105 微变形300033605684322734223626 换算值8998158传感器5190.9511.05正算反算95100105 微变形330034605109317333493532 换算值99103150高高强强螺螺栓栓高强螺栓 高强螺栓 高强螺栓 高强螺栓 高强螺栓 高强螺栓8.8S传感器517M160.9511.05正
19、算反算66.57073.5 微变形250024504992222523412459 换算值7573150传感器5190.9511.05正算反算66.57073.5 微变形222025004990219923162433 换算值677615010.9S传感器523M200.9511.05正 算反算147.25155162.75微变形340734072032311232823452换算值16116198传感器5240.9511.05正 算反算147.25155162.75微变形315733122090304832123377换算值152160102传感器5250.9511.05正 算反算147.2
20、5155162.75微变形339633733303315633253493换算值158157154高高强强螺螺栓栓高强螺栓 高强螺栓 高强螺栓 高强螺栓 高强螺栓 高强螺栓8.8S传感器523M200.9511.05正 算反算104.5110115.5微变形331036603199220623212438换算值157173152传感器5240.9511.05正 算反算104.5110115.5微变形300032003098216322762389换算值145155150传感器5250.9511.05正 算反算104.5110115.5微变形300031603212223623542471换算值
21、14014815010.9S10.9S传感器539M22M220.9511.05正算反算180.5190199.5 微变形259625542599312033503560 换算值159154159传感器5400.9511.05正算反算180.5190199.5 微变形310632562412315033803590 换算值179184150传感器5470.9511.05正算反算180.5190199.5 微变形330034602422316033903610 换算值186193150传感器5480.9511.05正算反算180.5190199.5 微变形33003600242431303350
22、3520 换算值1882041508.8S8.8S传感器539M22M220.9511.05正算反算180.5190199.5 微变形311033602382312033503560 换算值180190150传感器5400.9511.05正算反算180.5190199.5 微变形320034002412315033803590 换算值183191150传感器5470.9511.05正算反算180.5190199.5 微变形330034602422316033903610 换算值186193150传感器5480.9511.05正算反算180.5190199.5 微变形33003600242431
23、3033503520 换算值18820415010.9S传感器539M240.9511.05正算反算213.75225236.25微变形335834662261314333093495换算值228234154传感器5400.9511.05正算反算213.75225236.25微变形329235343274316533343503换算值222238221传感器5470.9511.05正算反算213.75225236.25微变形333534983255316333283501换算值225236220传感器5480.9511.05正算反算213.75225236.25微变形3371343033293
24、18333613548换算值226229223高高强强螺螺栓栓高强螺栓 高强螺栓 高强螺栓 高强螺栓 高强螺栓 高强螺栓8.8S传感器539M240.9511.05正算反算147.25155162.75微变形331036602771215622762388换算值222251187传感器5400.9511.05正算反算147.25155162.75微变形325035002783217322892402换算值219238188传感器5470.9511.05正算反算147.25155162.75微变形320033602699217622912404换算值216228183传感器5480.9511.0
25、5正算反算147.25155162.75微变形330035002864218123022416换算值21923619110.9S10.9S传感器532M27M270.9511.05正算反算275.5290304.5 微变形319533603158311033103490 换算值282294279传感器5330.9511.05正算反算275.5290304.5 微变形324531733106310032703450 换算值288282276传感器5340.9511.05正算反算275.5290304.5 微变形328433523196319033703550 换算值283289276传感器535
26、0.9511.05正算反算275.5290304.5 微变形329533523231321533703570 换算值2832892778.8S8.8S传感器532M27M270.9511.05正算反算275.5290304.5 微变形319533603158311033103490 换算值282294279传感器5330.9511.05正算反算275.5290304.5 微变形324531733106310032703450 换算值288282276传感器5340.9511.05正算反算275.5290304.5 微变形328432583196319033703550 换算值283281276
27、传感器5350.9511.05正算反算275.5290304.5 微变形329536003231321533703570 换算值28330727710.9S传感器532M300.9511.05正算反算337.25355372.75微变形332034663420.028323234103595换算值346.0253 360.373356传感器5330.9511.05正算反算337.25355372.75微变形337135343631.493330835723679换算值341.4858 348.6963359传感器5340.9511.05正算反算337.25355372.75微变形3335349
28、83443.465321834023542换算值348.5367 367.1714359传感器5350.9511.05正算反算337.25355372.75微变形337134303378.972321133893574换算值353.2051 358.9338354高高强强螺螺栓栓高强螺栓 高强螺栓 高强螺栓 高强螺栓 高强螺栓 高强螺栓8.8S传感器532M300.9511.05正算反算237.25250262.5微变形331036601449.98227823992514换算值345.9938 387.0652150传感器5330.9511.05正算反算237.25250262.5微变形32
29、5035001425.235230824372571换算值330.3547 349.1604150传感器5340.9511.05正算反算237.25250262.5微变形320033601691.02225923422506换算值381.8012 327.5915150传感器5350.9511.05正算反算237.25250262.5微变形330035001345.863225623892423换算值337.3327 658.4559150反算滑移荷载预拉力之和滑移系数滑移系数平均值346.53750.4620.46351.753750.469336.353680.457正算滑移系数平均值滑移
30、荷载预拉力之和滑移系数0.54063740.5433943740.527315.053740.421红色内容为计算结果，蓝色为输入数据 传感器518随机生成 随机生成 随机生成无效0.9515870324235863455951001609510410131403330随机生成 随机生成 随机生成传感器5205545331932533198无效0.9511609997969510032803500传感器518随机生成 随机生成 随机生成无效0.951537528892846274466.57016087858225302650传感器520随机生成 随机生成 随机生成无效0.9515325266
31、72681262366.57016081817925102690随机生成 随机生成 随机生成203234433249342898162153162传感器526无效0.951随机生成 随机生成 随机生成147.25155206231023153316432203390101150152153随机生成 随机生成 随机生成3217341132523163150159152148随机生成 随机生成 随机生成3172237224102319150112114110传感器526随机生成 随机生成 随机生成无效0.9513303238521742311104.511016011510511228502960
32、随机生成 随机生成 随机生成3418231424002462160108112115随机生成 随机生成 随机生成2554350634553516154196194197随机生成 随机生成 随机生成2717354033973358160197191189随机生成 随机生成 随机生成2695349034153369160194191189随机生成 随机生成 随机生成2813316832903361160182187190随机生成 随机生成 随机生成2687314132773396160181187192随机生成 随机生成 随机生成2717326235263411160185196191随机生成 随
33、机生成 随机生成2695325732693520160185185195随机生成 随机生成 随机生成2813330731433508160188181197随机生成 随机生成 随机生成347434173191160236232217随机生成 随机生成 随机生成2358333932603473160225220234随机生成 随机生成 随机生成3359317134343467227214232234随机生成 随机生成 随机生成2281327233753257160219226218随机生成 随机生成 随机生成2348225622352172160154152148随机生成 随机生成 随机生成23
34、62238322762245160161154152随机生成 随机生成 随机生成2699219122402209183148152149随机生成 随机生成 随机生成2376223723582312160151159156随机生成 随机生成 随机生成1696318932083142160281283278随机生成 随机生成 随机生成1656323231893269160287283290随机生成 随机生成 随机生成1756331635233287160286302283随机生成 随机生成 随机生成1577324235543479160278307300随机生成 随机生成 随机生成16963207
35、31213472160283276302随机生成 随机生成 随机生成1656317933783167160282299281随机生成 随机生成 随机生成1756335132133467160288277298随机生成 随机生成 随机生成1577331534913382160285301291随机生成 随机生成 随机生成1377.606348034493497160362359363随机生成 随机生成 随机生成2396.507344035783359160333356320随机生成 随机生成 随机生成2392.423342434673521227358363370随机生成 随机生成 随机生成13
36、56.60635683514336616037236735315711601472.21601161.21602144.216027、3022、242016532539523517533540524519534547525535548 1.05正算反算随机生成 随机生成105 微变形3200340052305610327931403520 换算值9710215016099951.05正算反算随机生成 随机生成105 微变形3300360057005900365434293700 换算值95103150160104981.05正算反算随机生成 随机生成73.5 微变形25902600539388
37、21258126622890 换算值686915016068701.05正算反算随机生成 随机生成73.5 微变形2750269068046547260326322840 换算值717015016068691.05正 算反算随机生成 随机生成162.75微变形3351345633463456353633433560换算值1531581531581621531.05正 算反算随机生成 随机生成115.5微变形3000340037605596319232143250换算值112118150160122123随机生成320097随机生成3508100随机生成276973随机生成255767随机生成3
38、507160随机生成3187121杆件拉力1234杆件直径256075.5140壁厚13.53.756杆件截面积75.39816 621.24942 845.284059 2525.838杆件设计值39杆件设计应力 517.25400200杆件破坏荷载30.03245.09357.72850杆件破坏应力398.3394.5423.2336.5杆件破坏荷载31.74272.11363.471010.34杆件破坏应力421438430400实测系数0.77#DIV/0!#DIV/0!#DIV/0!整管拉伸外径厚度截面积原始标距屈服荷载 屈服强度 抗拉荷载16147.1238538.7915.268
39、1332420.781620000000000000000000000000000000000000000抗拉强度441序号扭转刚度抗滑抗拉12161.21.010.110.92251.511.930.180.91353.881.610.231.11456.351.760.221.2560.611.140.110.89654.411.540.121.21750.241.270.191.09864.062.020.110.99958.191.090.121.121054.051.510.111.081164.92.130.141.291252.261.150.221.261352.491.860
40、.090.971457.671.280.140.921554.91.150.230.831661.211.340.131.251753.931.470.161.011854.861.880.21.21955.481.220.231.282062.7110.141.162156.31.720.110.952260.362.150.130.982350.581.710.141.19初始试验力 试验力松弛率正算189186.241.461min189189.84-0.443min189189.45-0.246min189189.24-0.139min189189.11-0.0615min189188
41、.980.0130min189188.810.145min189188.690.161h189188.570.231.5h189188.400.322h189188.280.384h189188.110.478h189187.960.5510h189187.890.5924h189187.810.6348h189187.720.6872h189187.640.7296h189187.600.74100h反算193192.90.05193192.850.08193192.440.29193192.230.4193192.090.47193191.960.54193191.780.63193191
42、.670.69193191.550.75193191.380.84193191.240.91193191.090.99193190.931.07193190.861.11193190.781.15193190.681.2193190.611.24）- -）间间间间间 (h)1009080706050403020100间间间R (% )32.72.42.11.81.51.20.90.60.30193190.571.26）- -）间间间间间 (h)1009080706050403020100间间间R (% )32.72.42.11.81.51.20.90.60.30序号硬度17779.581280.580.579.5380.57877478.582.5805807982
