当前位置：文档之家 › 任意跨恒载弯矩二次分配

任意跨恒载弯矩二次分配

  • 格式：xls
  • 大小：29.50 KB
  • 文档页数：8

上柱下柱右梁

0.5460.454

-97.60

53.2944.31

21.78-15.28

-3.55-2.95

71.52-71.52

0.3440.3710.285

-126.60

43.5546.9736.08

26.6422.85-14.26

-12.12-13.07-10.04

58.0856.75-114.82

0.3610.3610.278

-126.60

45.7045.7035.19

23.4822.85-13.92

-11.70-11.70-9.01

57.4956.85-114.34

0.3610.3610.278

-126.60

45.7045.7035.19

22.8522.85-13.92

-11.47-11.47-8.8357.0857.08-114.16

0.3610.3610.278

-126.60

45.7045.7035.19

22.85-13.92

-3.22-3.22-2.48

65.3342.48-107.81

21.24左梁上柱下柱右梁左梁

0.3750.4520.1730.375

97.69-16.20-16.20

-30.56-36.83-14.1012.15

22.16-17.216.08-7.05

-4.13-4.98-1.91-2.58

85.15-59.02-26.13-13.67

0.2520.3040.3280.1160.252

126.60-13.40-13.40

-28.53-34.41-37.13-13.136.75

18.04-18.42-18.113.38-6.57

3.814.594.961.75-3.32

119.92-48.24-50.29-21.40-16.53

0.2460.3200.3200.1130.246

126.60-13.40-13.40

-27.85-36.22-36.22-12.796.59

17.60-18.56-18.113.30-6.40

3.885.055.051.78-2.51

120.23-49.74-49.29-21.11-15.71

0.2460.3200.3200.1130.246

126.60-13.40-13.40

-27.85-36.22-36.22-12.796.59

17.60-18.11-18.113.30-6.40

3.774.914.911.73-2.48120.12-49.43-49.43-21.16-15.69

0.2460.3200.3200.1130.246

126.60-13.40-13.40

-27.85-36.22-36.22-12.796.59

17.60-18.113.30-6.40

-0.68-0.89-0.89-0.31-1.43

115.67-55.23-37.11-23.21-14.63

-18.56

只能把蓝色和绿色的数据改成

小数位数可以从单元格里

对于较少的跨数，就把多余的

多出的红色数据不管它，治抄恒荷载作用下弯矩二次分配上柱下柱右梁左梁上柱下柱

0.4520.1730.1730.452

-16.20-16.20

14.645.6119.6951.44

4.079.842.8022.96

-3.11-2.19-0.62-1.63

15.61-2.945.6772.77

0.3040.3280.1160.1160.3280.304

-13.40-13.40

8.158.793.1116.2445.9242.56

7.324.298.121.5525.7222.40

-4.00-4.32-1.53-3.67-10.38-9.62

11.478.76-3.700.7361.2655.34

0.3200.3200.1130.1130.3200.320

-13.40-13.40

8.588.583.0315.8244.8044.80

4.404.297.911.5121.2822.40

-3.26-3.26-1.15-3.12-8.83-8.83

9.719.60-3.610.8257.2558.37

0.3200.3200.1130.1130.3200.320

-13.40-13.40

8.588.583.0315.8244.8044.80

4.294.297.911.5122.4022.40

-3.23-3.23-1.14-3.24-9.19-9.199.649.64-3.600.6958.0158.01

0.3200.3200.1130.1130.3200.320

-13.40-13.40

8.588.583.0315.8244.8044.80

4.297.911.5122.40

-1.86-1.86-0.66-0.71-2.02-2.02

11.016.72-3.123.2265.1842.78

3.3621.39

绿色的数据改成自己的，其他一改即失效。

元格里修改

数，就把多余的蓝色与绿色都删掉，蓝色，绿色下面的就不

据不管它，治抄自己需要的红色最终数据右梁左梁上柱下柱

0.3750.4540.546

-97.6097.60

42.68-44.31-53.29

-22.1621.34-23.48

-1.350.971.17

-78.4375.60-75.60

0.2520.2850.3710.344

-126.60126.60

35.28-36.08-46.97-43.55

-18.0417.64-26.64-22.85

-7.979.0811.8210.96

-117.33117.24-61.79-55.44

0.2460.2780.3610.361

-126.60126.60

34.44-35.19-45.70-45.70

-17.6017.22-21.78-22.85

-6.797.629.899.89

-116.55116.24-57.58-58.66

0.2460.2780.3610.361

-126.60126.60

34.44-35.19-45.70-45.70

-17.6017.22-22.85-22.85

-7.067.9210.2810.28-116.82116.54-58.27-58.27

0.2460.2780.3610.361

-126.60126.60

34.44-35.19-45.70-45.70

-17.6017.22-22.85

-1.551.572.032.03

-111.31110.19-66.52-43.67

-21.83

色下面的就不用管了

合集下载

荷载弯矩二次分配5

荷载弯矩二次分配5

1 / 7

荷载弯矩二次分配5

简单实用

上柱

00.

下0柱0 偏心 矩 .0000. 00 .00 00.0 00.00梁右0 .00

0.000 .00 0.0000.00

梁 0左 0.00 .000 0.00 0.000 0.0柱上 0.000下 0 偏柱矩心 .00 00.0 0000 .000 .0.0

0

00.2880 0. 04.85 25105 11.24 80.84.

07.1 -126.56 120.01 860-.7 07.72 -808.840421. 385.2 -22022.

650.1 023.45 3-01.6

300.62 0.070-7 .26 022.1-8 14.8- 8-11.352.00 0000. 0.0 00.00

0.00 .00 0000 0..00

.02240.224 000. 2.411 2105 .2-34 60.83

0.553.- 178.8 19309.5- 439. 05.-67 -24.6910.33 233.39 1-9.68

510.8 -7900. 1344.80.11

20.211 00.0 44-3.6 -2.21 -4845. 70-99.4211. 42.7 2-2.4 634.40

4-.34 -386.01 -.445 86-.9

弯 1 二矩次 分 配 法 计 算器

022.40.224 .000 2411 .1205. -.611 1.556

2 / 7

.5035 -17.88 903.951-3 .94 0-398.- 12291.0.32 333.91

36-9.085 .18 -921.29 3902.00.211

弯矩二次分配法(四跨结构)

弯矩二次分配法(四跨结构)

上柱下柱右梁左梁上柱下柱右梁

0.0000.3570.6430.3910.0000.2170.391

14.768-133.800133.8000.0000.000-133.800

0.00042.51176.5210.0000.0000.0000.000

0.00014.4140.00038.2600.0000.0000.000

0.000-5.148-9.266-14.9710.000-8.317-14.971

0.00051.778-66.546157.0890.000-8.317-148.771

0.2630.2630.4740.3210.1790.1790.321

13.240-122.790122.7900.000-122.790

28.82928.82951.8920.0000.0000.0000.00021.2568.7870.00025.9460.000-1.8942.477-7.906-7.906-14.231-8.527-4.737-4.737-8.527

42.17929.710-85.129140.209-4.737-6.631-128.840

0.2080.4180.3740.2720.1510.3040.272

13.240-97.75597.7550.000-72.720

17.57435.30931.632-6.818-3.788-7.611-6.81814.4140.000-3.40915.8160.0000.0000.000-2.288-4.598-4.119-4.308-2.393-4.808-4.308

29.70030.711-73.651102.446-6.181-12.419-83.846

15.356-6.209

-66.546157.089-148.771133.262########151.059-85.129140.209-128.840127.743########123.361-73.651102.446-83.84669.865-72.16677.344

弯矩二次分配法EXCEL计算教学提纲

弯矩二次分配法EXCEL计算教学提纲

上柱下柱右梁左梁上柱下柱右梁左梁上柱0.5870.410.310.440.240.29偏心矩偏心矩-72.0072.00-1.661.6642.2629.52-21.81-30.95-16.883.8711.75-10.9014.76-9.351.93-8.44-0.50-0.35-2.28-3.23-1.762.3953.52-53.7362.68-43.53-18.37-0.520.370.370.260.230.30.30.170.190.34-63.5063.50-1.161.1623.5023.5016.51-14.34-18.70-18.70-10.602.574.6021.1311.75-7.178.26-15.47-9.351.29-5.303.40-9.51-9.51-6.683.524.594.592.600.150.2635.1125.73-60.8460.93-29.59-23.47-7.87-1.428.270.370.370.260.230.30.30.170.190.34-63.5063.50-1.161.1623.5023.5016.51-14.34-18.70-18.70-10.602.574.6011.7511.75-7.178.26-9.35-9.351.29-5.302.30-6.04-6.04-4.242.112.752.751.560.360.6429.2029.20-58.4059.52-25.30-25.30-8.91-1.217.540.370.370.260.230.30.30.170.190.34-63.5063.50-1.161.1623.5023.5016.51-14.34-18.70-18.70-10.602.574.6011.7513.65-7.178.26-9.35-10.601.29-5.302.30-6.75-6.75-4.742.393.123.121.770.280.5028.5030.40-58.9059.81-24.93-26.18-8.70-1.297.400.430.280.30.240.340.220.190.20.4-63.5063.50-1.161.1627.3117.7819.05-14.96-21.20-13.71-11.842.715.4211.750.00-7.489.53-9.350.001.35-5.922.30-1.83-1.19-1.28-0.37-0.52-0.34-0.291.002.0137.2216.59-53.2157.70-31.07-14.05-11.94-1.059.72恒载14.5-10.23弯矩二次分配法EXCEL计算下柱右梁左梁上柱下柱0.510.20.280.72偏心矩偏心矩-15156.802.67-4.20-10.802.30-2.101.33-3.094.201.650.491.2613.31-12.7812.62-12.620.340.130.160.420.42-14.7014.704.601.76-2.35-6.17-6.172.30-1.180.88-5.40-3.090.260.101.223.193.197.17-14.0214.45-8.38-6.070.340.130.160.420.42-14.7014.704.601.76-2.35-6.17-6.172.30-1.180.88-3.09-3.090.640.240.852.222.227.54-13.8714.08-7.04-7.040.340.130.160.420.42-14.7014.704.601.76-2.35-6.17-6.172.71-1.180.88-3.09-3.600.500.190.932.442.447.81-13.9314.16-6.82-7.340.250.150.190.490.32-14.7014.703.392.03-2.79-7.20-4.700.00-1.401.02-3.090.001.250.750.391.020.664.64-13.3113.32-9.27-4.04

横向框架弯矩的二次分配法表格

横向框架弯矩的二次分配法表格

上柱下柱右梁左梁上柱下柱右梁0.5190.4810.3960.4270.1773.41-110.51110.51-9.8355.5851.52-39.87-42.99-17.8218.63-19.9325.76-15.948.910.680.63-7.41-7.99-3.3174.89-78.3088.98-66.93-22.050.3420.3420.3160.2780.2990.2990.1245.55-114.52114.52-7.8737.2737.2734.43-29.65-31.89-31.89-13.2227.7918.63-14.8217.22-21.50-15.946.61-10.81-10.81-9.993.784.074.071.6954.2545.09-104.90105.87-49.31-43.76-12.790.3420.3420.3160.2780.2990.2990.1245.55-114.52114.52-7.8737.2737.2734.43-29.65-31.89-31.89-13.2218.6318.63-14.8217.22-15.94-15.946.61-7.68-7.68-7.092.242.412.411.0048.2348.23-102.00104.33-45.42-45.42-13.480.3420.3420.3160.2780.2990.2990.1245.55-114.52114.52-7.8737.2737.2734.43-29.65-31.89-31.89-13.2218.6320.05-14.8217.22-15.94-16.696.61-8.16-8.16-7.542.452.632.631.0947.7449.16-102.45104.54-45.20-45.95-13.390.3680.2910.3410.2900.3130.2670.1305.55-114.52114.52-7.8740.1031.7137.16-30.93-33.38-28.48-13.8618.63-15.4618.58-15.946.93-1.17-0.92-1.08-2.77-2.99-2.55-1.2457.5730.79-93.9199.40-52.32-31.03-16.05