(完整版)弯矩二次分配法excel表

0.201 11.300 22.918 -11.223 4.952 27.947
0.193
22.006 7.980 4.755 34.740
0.193 0.000 22.006 11.003 4.755 37.763
0.413 -125.320 47.090 -32.395 10.174 -100.451
上柱
下柱
0.000 0.318
0.000 0.000 0.000 0.000
-35.994 -11.373 -4.476 -51.843
0.517 93.990 -48.593 17.075 8.316 70.789
0.242 0.242
-22.746 -17.997
3.893 -36.850
-22.746 -15.164
0.251 0.198 0.551 17.010 -94.970
23.837 15.436 42.956
12.810 1.373 38.021
0.000 1.083 16.519
-18.282 3.015 -67.281
7.718
0.437 94.970
0.199
0.157 0.207 0.000 -11.300
左梁 0.249
上柱
13.780 0.000
24.753 -12.361 10.702 36.874
0.000 0.000 0.000 0.000
下柱 0.239
右梁 0.512
0.000 -113.190
23.759 7.980 10.272 42.011
50.898 -38.598 22.006 -78.884
0.420 0.191 124.660
0.191 0.198 0.000 -11.300
-47.611 -21.652 -21.652 -22.445
28.204 -8.615 96.638
-10.826 -8.325 11.459 -3.918 -3.918 -4.061 -36.395 -33.895 -26.348
0.000 #REF! #REF! #REF!
0.000
0.000 0.000 #REF! #REF!
0.000
0.000 0.000 0.000 #REF! #REF!
0.000
0.000 0.000 0.000 #REF! #REF!
0.000 0.000
0.000 #REF! #REF! #REF!
0.000 0.000 0.000
0.000 0.000 0.000 0.000 0.000
0.000 -46.932 0.000 -46.932
0.000 0.000 0.000 0.000
0.000
0.000 0.000 0.000 0.000 0.000
0.000
0.000 0.000 0.000 #REF! #REF!
17.820 32.363 201.343
-15.164 0.000 15.082 11.940 26.561 33.032
10.546
0.000 0.000 0.000
0.000 #VALUE! #VALUE! #VALUE!
0.000 0.000 0.000 #VALUE! #VALUE!
0.000 0.000 0.000 #VALUE! #VALUE!
-23.815 -7.990 -9.205 -41.010
-24.723 12.377 -9.556 -35.682
0.420 94.970 -35.141 20.426 -2.521 77.733
0.191
-15.981 -11.907 -1.146 -29.035
0.191 0.000 -15.981 -10.826 -1.146 -27.953
0.201 11.300
0.193
0.193 0.000
0.413 -125.320
22.918 22.006 22.006 47.090
-11.223 4.344 27.339
11.003 4.171 37.180
11.003 4.171 37.180
-32.395 8.926 -101.699
0.201 0.193 11.300
0.198 -11.300 -16.567 8.310 -1.189 -20.745
0.420 124.660 -47.611 28.204 -8.756 96.497
0.191
-21.652 -7.990 -3.982 -33.624
0.191 0.000 -21.652 -10.826 -3.982 -36.459
11.003 -6.217 21.407
0.159 0.000
13.148
0.000 -4.918 8.230
0.431 -93.990
35.639
28.585 -13.330 -43.096
-6.568
6.574
0.515 93.990
0.240 0.190 0.000
57.170 26.642 21.092
0.198 -11.300 -22.445 11.459 -4.128 -26.414
0.420 0.191 124.660
0.191 0.198 0.000 -11.300
-47.611 -21.652 -21.652 -22.445
28.204 -7.565 97.688
-10.826 -10.826 11.459 -3.440 -3.440 -3.566 -35.918 -35.918 -25.853
0.000 0.000 #REF! #REF!
0.193
0.413
0.000 -125.320
22.918 22.006 22.006 47.090
-11.223 4.885 27.881
1ቤተ መጻሕፍቲ ባይዱ.003 4.691 37.700
8.310 4.691 35.007
-32.395 10.038 -100.587
左梁 0.682
113.190
-77.196 25.449 -9.600 51.843
0.201 11.300 16.621 -8.283 1.949 21.587
0.193
15.959 11.879 1.872 29.710
0.193 0.000 15.959 11.003 1.872 28.834
0.413 -93.990 34.151 -24.296 4.005 -80.130
上柱 0.000
下柱 0.312
右梁 0.688
14.060 -114.690
0.000 0.000 0.000 0.000
31.397 11.301 4.644 47.342
69.233 -26.186 10.241 -61.402
0.238
22.603 15.698 -3.085 35.216
0.238 17.010 18.554 14.835 -3.085 30.304
0.524 -94.970 40.851 -17.571 -6.792 -78.482
0.238
29.669 9.277 -0.073 38.873
0.238 17.010 25.621 14.835 -0.073 40.382
0.524 -124.660 56.409 -23.806 -0.160 -92.217
-36.564 -16.650 -13.136 -17.320
21.478 -8.431 71.453
-10.826 0.000 8.641 -3.839 -3.029 -3.994 -31.316 -16.165 -23.972
0.209 0.201 11.300
17.282 16.621
-8.660 -6.464 13.458
12.810 -0.220 42.260
11.919 -0.220 37.320
-23.806 -0.484 -92.541
左梁 0.519
上柱 0.000
下柱 0.236
右梁 0.245
114.690
0.000 -13.780
-52.372 34.617 -20.242 76.692
0.000 0.000 0.000 0.000
0.238 0.238 0.524 17.010 -124.660
29.669 25.621 56.409
12.810 -0.914 41.566
14.835 -0.914 39.541
-23.806 -2.012 -94.069
0.238 0.238 0.524 17.010 -124.660
29.669 25.621 56.409
23.545 3.506 87.581
-15.164 -15.164 1.641 1.641
-43.850 -43.850
0.517 125.320
0.242 0.242
-64.790 -30.327 -30.327
23.545 -11.220 72.854
-15.164 13.321 -5.252 -5.252 -50.743 -22.258
3.893 -34.017
0.517 125.320 -64.790 23.545 1.547 85.621
0.242 0.242
-30.327 -11.373
0.724 -40.976
-30.327 -15.164
0.724 -44.767
0.517 125.320
0.242 0.242
-64.790 -30.327 -30.327