首页 > 资料专栏 > 经营 > 运营治理 > 其他资料 > 连续梁钢绞线伸长量计算表XLS格式

连续梁钢绞线伸长量计算表XLS格式

四海不锈***
V 实名认证
内容提供者
热门搜索
资料大小:10KB(压缩后)
文档格式:XLS
资料语言:中文版/英文版/日文版
解压密码:m448
更新时间:2020/1/28(发布于甘肃)

类型:积分资料
积分:10分 (VIP无积分限制)
推荐:升级会员

   点此下载 ==>> 点击下载文档


文本描述
公式: 1 预应力平均张拉力Pp Pp=P(1-e-(kx+μθ))/(kx+μθ) 2 钢绞线伸长量⊿L ⊿L=Pp·L(Ap·Ep) Ap= 1669 mm2 序号 编号 段 P (N) k μ x(m) θ(red) e kx+μθ -(kx+μθ) e-(kx+μθ) 1-e-(kx+μθ) Pp(N) Ap(mm2) L (mm) Ep Mpa 一端⊿L(mm) 总计 设计值 差值 % T1 ① 2184000 0.0025 0.23 1.571 0 2.718281828 0.00393 -0.0039275 0.99608 0.00392 2179716.779 1669 1.571 195000 10.52 ② 2184000 0.0025 0.23 1.047 0.17453 2.718281828 0.04276 -0.0427594 0.95814 0.04186 2137965.206 1669 1.047 195000 6.88 ③ 2184000 0.0025 0.23 0.8785 0 2.718281828 0.00220 -0.00219625 0.99781 0.00219 2181603.449 1669 0.8785 195000 5.89 分段计算 23.29 22.8 0.49 2.142065358 合计 2184000 0.0025 0.23 3.4965 0.17453 2.718281828 0.04888 -0.04888315 0.95229 0.04771 2131478.874 1669 3.4965 195000 22.90 45.79874872 22.8 0.10 0.435852463 T2 ① 2184000 0.0025 0.23 2.099 0 2.718281828 0.00525 -0.0052475 0.99477 0.00523 2178279.74 1669 2.099 195000 14.05 ② 2184000 0.0025 0.23 1.047 0.17453 2.718281828 0.04276 -0.0427594 0.95814 0.04186 2137965.206 1669 1.047 195000 6.88 ③ 2184000 0.0025 0.23 3.359 0 2.718281828 0.00840 -0.0083975 0.99164 0.00836 2174855.544 1669 3.359 195000 22.45 分段计算 43.37 42 1.37 3.269331494 合计 2184000 0.0025 0.23 6.505 0.17453 2.718281828 0.05640 -0.0564044 0.94516 0.05484 2123548.298 1669 6.505 195000 42.44 84.88842806 42 0.44 1.057652447 T3 ① 2184000 0.0025 0.23 1.417 0 2.718281828 0.00354 -0.0035425 0.99646 0.00354 2180136.154 1669 1.417 195000 9.49 ② 2184000 0.0025 0.23 1.047 0.17453 2.718281828 0.04276 -0.0427594 0.95814 0.04186 2137965.206 1669 1.047 195000 6.88 ③ 2184000 0.0025 0.23 11.5305 0 2.718281828 0.02883 -0.02882625 0.97159 0.02841 2152822.034 1669 11.5305 195000 76.27 分段计算 92.64 88.6 4.04 4.562128268 合计 2184000 0.0025 0.23 13.9945 0.17453 2.718281828 0.07513 -0.07512815 0.92762 0.07238 2103976.548 1669 13.9945 195000 90.47 180.9411427 88.6 1.87 2.111254339 T4 ① 2184000 0.0025 0.23 1.417 0 2.718281828 0.00354 -0.0035425 0.99646 0.00354 2180136.154 1669 1.417 195000 9.49 ② 2184000 0.0025 0.23 1.047 0.17453 2.718281828 0.04276 -0.0427594 0.95814 0.04186 2137965.206 1669 1.047 195000 6.88 ③ 2184000 0.0025 0.23 17.0305 0 2.718281828 0.04258 -0.04257625 0.95832 0.04168 2138159.607 1669 17.0305 195000 111.89 分段计算 128.26 122.4 5.86 4.784497498 合计 2184000 0.0025 0.23 19.4945 0.17453 2.718281828 0.08888 -0.08887815 0.91496 0.08504 2089757.644 1669 19.4945 195000 125.17 250.3496975 122.4 2.77 2.267033288 T5 ① 2175600 0.0025 0.23 0.43 0 2.718281828 0.00108 -0.001075 0.99893 0.00107 2174431.034 1669 0.43 195000 2.87 ② 2175600 0.0025 0.23 0.628 0.10472 2.718281828 0.02566 -0.0256556 0.97467 0.02533 2147928.982 1669 0.628 195000 4.14 ③ 2175600 0.0025 0.23 55.122 0 2.718281828 0.13781 -0.137805 0.87127 0.12873 2032350.738 1669 55.122 195000 344.22 分段计算 351.23 339.7 11.53 3.395602714 合计 2175600 0.0025 0.23 56.18 0.10472 2.718281828 0.16454 -0.1645356 0.84829 0.15171 2006043.617 1649.34 56.18 195000 350.41 700.82131 339.7 10.71 3.152974687 序号 编号 段 P (N) k μ x(m) θ(red) e kx+μθ -(kx+μθ) e-(kx+μθ) 1-e-(kx+μθ) Pp(N) Ap(mm2) L (mm) Ep Mpa 一端⊿L(mm) 总计 设计值 差值 % M1 2301600 0.0025 0.23 0.929 0 2.718281828 0.00232 -0.0023225 0.99768 0.00232 2298929.335 1669 0.929 195000 6.56 2301600 0.0025 0.23 2.793 0.3491 2.718281828 0.08728 -0.0872755 0.91642 0.08358 2204022.585 1669 2.793 195000 18.91 2301600 0.0025 0.23 19.25 0 2.718281828 0.04813 -0.048125 0.95301 0.04699 2247095.586 1669 19.25 195000 132.91 2301600 0.0025 0.23 3.647 0.4538 2.718281828 0.11349 -0.1134915 0.89271 0.10729 2175797.808 1669 3.647 195000 24.38 2301600 0.0025 0.23 1.683 0 2.718281828 0.00421 -0.0042075 0.99580 0.00420 2296764.792 1669 1.683 195000 11.88 2301600 0.0025 0.23 3.647 0.4538 2.718281828 0.11349 -0.1134915 0.89271 0.10729 2175797.808 1669 3.647 195000 24.38 2301600 0.0025 0.23 1.473 0 2.718281828 0.00368 -0.0036825 0.99632 0.00368 2297367.376 1669 1.473 195000 10.40 2301600 0.0025 0.23 3.647 0.4538 2.718281828 0.11349 -0.1134915 0.89271 0.10729 2175797.808 1669 3.647 195000 24.38 2301600 0.0025 0.23 1.683 0 2.718281828 0.00421 -0.0042075 0.99580 0.00420 2296764.792 1669 1.683 195000 11.88 2301600 0.0025 0.23 3.647 0.4538 2.718281828 0.11349 -0.1134915 0.89271 0.10729 2175797.808 1669 3.647 195000 24.38 2301600 0.0025 0.23 14.709 0 2.718281828 0.03677 -0.0367725 0.96390 0.03610 2259796.183 1669 14.709 195000 102.13 2.1643 分段计算 392.20 296.3 95.90 32.36531903 合计 2301600 0.0015 0.23 57.108 2.1643 2.718281828 0.58345 -0.583451 0.55797 0.44203 1743723.856 1669 57.108 195000 305.97 611.9468557 296.3 9.67 3.264741092 序号 编号 段 P (N) k μ x(m) θ(red) e kx+μθ -(kx+μθ) e-(kx+μθ) 1-e-(kx+μθ) Pp(N) Ap(mm2) L (mm) Ep Mpa 一端⊿L(mm) 总计 设计值 差值 % M2 2301600 0.0025 0.23 57.1765 2.16421 2.718281828 0.64071 -0.64070955 0.52692 0.47308 1699435.528 1669 57.1765 195000 298.56 597.1195741 296.8 1.76 0.592920161 2301600 0.0025 0.23 2.098 0 2.718281828 0.00525 -0.005245 0.99477 0.00523 2295574.593 1669 2.098 195000 14.80 2301600 0.0025 0.23 2.793 0.3491 2.718281828 0.08728 -0.0872755 0.91642 0.08358 2204022.585 1669 2.793 195000 18.91 2301600 0.0025 0.23 15.98 0 2.718281828 0.03995 -0.03995 0.96084 0.03916 2256231.7 1669 15.98 195000 110.78 2301600 0.0025 0.23 3.643 0.4538 2.718281828 0.11348 -0.1134815 0.89272 0.10728 2175808.481 1669 3.643 195000 24.36 2301600 0.0025 0.23 1.694 0 2.718281828 0.00424 -0.004235 0.99577 0.00423 2296733.234 1669 1.694 195000 11.95 2301600 0.0025 0.23 3.643 0.4538 2.718281828 0.11348 -0.1134815 0.89272 0.10728 2175808.481 1669 3.643 195000 24.36 2301600 0.0025 0.23 5.81 0 2.718281828 0.01453 -0.014525 0.98558 0.01442 2284965.267 1669 5.81 195000 40.79 2301600 0.0025 0.23 3.643 0.4538 2.718281828 0.11348 -0.1134815 0.89272 0.10728 2175808.481 1669 3.643 195000 24.36 2301600 0.0025 0.23 1.694 0 2.718281828 0.00424 -0.004235 0.99577 0.00423 2296733.234 1669 1.694 195000 11.95 2301600 0.0025 0.23 3.643 0.4538 2.718281828 0.11348 -0.1134815 0.89272 0.10728 2175808.481 1669 3.643 195000 24.36 2301600 0.0025 0.23 12.538 0 2.718281828 0.03135 -0.031345 0.96914 0.03086 2265902.129 1669 12.538 195000 87.29 393.91 296.8 97.11 32.71827447 M3 2301600 0.0025 0.23 57.2465 2.16421 2.718281828 0.64088 -0.64088455 0.52683 0.47317 1699302.607 1669 57.2465 195000 298.90 597.8038541 296.3 2.60 0.878139399 M4 2301600 0.0025 0.23 57.317 2.16421 2.718281828 0.64106 -0.6410608 0.52673 0.47327 1699168.75 1669 57.317 195000 299.25 598.4929114 296.7 2.55 0.858259424 B1 2184000 0.0025 0.23 7.494 0.17543 2.718281828 0.05908 -0.0590839 0.94263 0.05737 2120732.521 1669 7.494 195000 48.83 97.66492766 48.1 0.73 1.522793822 B2 2184000 0.0025 0.23 10.5115 0.17543 2.718281828 0.06663 -0.06662765 0.93554 0.06446 2112831.93 1669 10.5115 195000 68.24 136.4798994 67.2 1.04 1.547544191 B3 2184000 0.0025 0.23 15.994 0.17543 2.718281828 0.08033 -0.0803339 0.92281 0.07719 2098578.038 1669 15.994 195000 103.13 206.2629681 100.9 2.23 2.211579822 B4 2184000 0.0025 0.23 21.5195 0.17542 2.718281828 0.09415 -0.09414535 0.91015 0.08985 2084345.009 1669 21.5195 195000 137.82 275.6391048 135.1 2.72 2.012992146 B5 2175600 0.0025 0.23 56.176 0.17542 2.718281828 0.18079 -0.1807866 0.83461 0.16539 1990274.646 1669 56.176 195000 343.54 687.0729811 334.8 8.74 2.60946552。