连续梁计算结构计算EXCEL表.xls

《连续梁计算结构计算EXCEL表.xls》由会员分享，可在线阅读，更多相关《连续梁计算结构计算EXCEL表.xls（222页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、计算结果输入数据选输数据7 7有错数据其余见说明配筋表左悬臂第一跨纵筋94(122）94(122）弯矩-15.815.8弯矩125.71875纵筋788(322）剪力31.5105.025箍筋10-22010-860数据输入说明：左右支座填0表示简支或带悬臂，填1时为固定支座左支座长度150 0截面宽0.250.25截面高0.60.6砼容重2525砼强度C3030纵筋HPB335335荷载输入说明：输入数值均直接作计算用，如需分项系数，可自己乘上荷载类均布载自重q11=3.753.75自重q11=3.753.75q12=1515q12=2525集中载只限三个P1=0 0P1=0 0a1=0a1

2、=2.5P2=0 0P2=0 0a2=0a2=0P3=0 0P3=0 0a3=0a3=5三角载q3=25.525.5q3=30300.0-15.8-37.50.0125.72弯矩图cabcbaqqBABABABAbaP1,P2,P30.5L0.5LqaaBqABAq11,q12L梯形载q4=0 0q4=0 0a=00a=1局部均布载q5=0 0q5=0 0a=0a=2b=1b=3c=0c=3.2局部三角形载q6=0 0q6=0 0a=0a=2b=1b=3c=0c=1说说明明：本本程程序序为为华华南南理理工工大大学学建建筑筑学学院院陈陈庆庆军军编编写写，仅仅用用于于学学习习，用用于于设设计计中中

3、请请谨谨慎慎处处理理，本本计计算算不不负负任任何何责责任任。可可来来信信进进行行讨讨论论。本本表表格格最最好好在在12801024的的分分辨辨率率下下进进行行。chen_弯矩汇总自重1.8757.21153846类型17.552.0833333类型2100类型2100类型2100类型36.37539.0625类型400类型500类型600左右弯矩15.7598.3573718具体弯矩82.6073718刚度矩阵0.00360.00180.00180.0036总刚0.00360.00180.00180.0036修正刚度0.00360.00180.00180.0036cabcbaqqBABABAB

4、AbaP1,P2,P30.5L0.5LqaaBqABAq11,q12L逆矩阵370.37037 -185.1852-185.18519370.37037固端弯矩-82.60737298.35737260.8573718-98.35737弯矩剪力表距离长度杆长q11q12左悬臂段00013.751500.050.050.0513.751500.10.10.113.751500.150.150.1513.751500.20.20.213.751500.250.250.2513.751500.30.30.313.751500.350.350.3513.751500.40.40.413.751500.

5、450.450.4513.751500.50.50.513.751500.550.550.5513.751500.60.60.613.751500.650.650.6513.751500.70.70.713.751500.750.750.7513.751500.80.80.813.751500.850.850.8513.751500.90.90.913.751500.950.950.9513.7515011113.7515第一段00153.752500.050.251.2553.752500.10.51.553.752500.150.751.7553.752500.21253.752500.2

6、51.252.2553.752500.31.52.553.752500.351.752.7553.752500.42353.752500.452.253.2553.752500.52.53.553.752500.552.753.7553.752500.63453.752500.653.254.2553.752500.73.54.553.752500.753.754.7553.752500.84553.752500.854.255.2553.752500.94.55.553.752500.954.755.7553.7525015653.7525右悬臂段00623.75000.050.16.123

7、.75000.10.26.223.75000.150.36.323.75000.20.46.423.75000.250.56.523.75000.30.66.623.75000.350.76.723.75000.40.86.823.75000.450.96.923.75000.51723.75000.551.17.123.75000.61.27.223.75000.651.37.323.75000.71.47.423.75000.751.57.523.75000.81.67.623.75000.851.77.723.75000.91.87.823.75000.951.97.923.750012

8、823.750右悬臂225(122）225(122）-37.5-37.5113.72537.510-2402右支座0.250 00.6箍筋HPB235235纵筋直径2222箍筋直径1010肢数2 2自重q11=3.753.75q12=0 0P1=0 0a1=2P2=0 0a2=1P3=0 0a3=1q3=30300.0-31.5105.0-113.737.50.00.0剪力图说明：左右支座填0表示简支或带悬臂，填1时为固定支座50.250.6说明：输入数值均直接作计算用，如需分项系数，可自己乘上0.0-15.8-37.50.0125.72弯矩图q4=0 00.2a=0.50.25q5=0 0a

9、=1.5b=0.5c=1q6=0 0a=2b=0c=1-7.21153857.5-52.0833330000000-39.062530000000-98.35737237.5-60.857372-82.60737260.8573718-41865.20737837.428815.75-37.5P1a1p2a2p3a3q3q400000025.5000000025.5000000025.5000000025.5000000025.5000000025.5000000025.5000000025.5000000025.5000000025.5000000025.5000000025.5000000

10、025.5000000025.5000000025.5000000025.5000000025.5000000025.5000000025.5000000025.5000000025.5002.5000530002.5000530002.5000530002.5000530002.5000530002.5000530002.5000530002.5000530002.5000530002.5000530002.5000530002.5000530002.5000530002.5000530002.5000530002.5000530002.5000530002.5000530002.50005

11、30002.5000530002.50005300020101300020101300020101300020101300020101300020101300020101300020101300020101300020101300020101300020101300020101300020101300020101300020101300020101300020101300020101300020101300020101300as3535aq5abcq6ab0001000100010001000100010001000100010001000100010001000100010001000100

12、0100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000110233.202310233.202310233.202310233.202310233.202310233.202310233.202310233.202310233.202310233.202310233.202310233.202310233.202310233.202310233.202310233.202310233.202310233.202310233.202310233.202310

13、233.20230.501.50.510200.501.50.510200.501.50.510200.501.50.510200.501.50.510200.501.50.510200.501.50.510200.501.50.510200.501.50.510200.501.50.510200.501.50.510200.501.50.510200.501.50.510200.501.50.510200.501.50.510200.501.50.510200.501.50.510200.501.50.510200.501.50.510200.501.50.510200.501.50.510

14、20cMq11Mq12MP1MP2MP3Mq3Mq4Mq50000000000-0.00469 -0.01875000-0.00106000-0.01875-0.075000-0.0085000-0.04219 -0.16875000-0.02869000-0.075-0.3000-0.068000-0.11719 -0.46875000-0.13281000-0.16875-0.675000-0.2295000-0.22969 -0.91875000-0.36444000-0.3-1.2000-0.544000-0.37969 -1.51875000-0.77456000-0.46875-1

15、.875000-1.0625000-0.56719 -2.26875000-1.41206000-0.675-2.7000-1.819000-0.79219 -3.16875000-2.27694000-0.91875-3.675000-2.7795000-1.05469 -4.21875000-3.32031000-1.2-4.8000-3.893000-1.35469 -5.41875000-4.49119000-1.51875-6.075000-5.1085000-1.69219 -6.76875000-5.73856000-1.875-7.5000-6.3750010000000012

16、.226563 14.843750009.343750014.2187528.12500018.50015.976563 39.8437500027.281250017.55000035.50018.789063 58.5937500042.968750019.8437565.62500049.500110.66406 71.0937500054.9062500111.25750005900111.60156 77.3437500061.5937500111.7187578.12500062.500111.60156 77.3437500061.5937500111.2575000590011

17、0.66406 71.0937500054.906250019.8437565.62500049.50018.789063 58.5937500042.968750017.55000035.50015.976563 39.8437500027.281250014.2187528.12500018.50012.226563 14.843750009.34375001000000001-7.50000-30001-6.768750000-27.005001-6.0750000-24.04001-5.418750000-21.135001-4.80000-18.32001-4.218750000-1

18、5.625001-3.6750000-13.08001-3.168750000-10.715001-2.70000-8.56001-2.268750000-6.645001-1.8750000-5001-1.518750000-3.645001-1.20000-2.56001-0.918750000-1.715001-0.6750000-1.08001-0.468750000-0.625001-0.30000-0.32001-0.168750000-0.135001-0.0750000-0.04001-0.018750000-0.00500100000000Mq6M1M2最终的M#DIV/0!

19、00#DIV/0!#DIV/0!000-0.0245-0.0245000-0.10225 -0.10225000-0.23962 -0.23962000-0.443-0.443000-0.71875 -0.71875000-1.07325 -1.07325000-1.51288 -1.51288000-2.044-2.044000-2.673-2.673000-3.40625 -3.40625000-4.248-4.248000-5.194-5.194000-6.23788 -6.23788000-7.37325 -7.37325000-8.59375 -8.59375000-9.893-9.

20、893000-11.2646 -11.2646000-12.7023 -12.7023000-14.1995 -14.1995000-15.75-15.7510000-15.750-15.75-15.751-15.75000-14.9625-1.8759.576562 9.576562000-14.175-3.7532.91875 32.91875000-13.3875-5.62554.08906 54.08906000-12.6-7.572.972.9000-11.8125-9.37589.16406 89.16406000-11.025-11.25102.6938 102.6938000-

21、10.2375-13.125113.3016 113.3016000-9.45-15120.8120.8000-8.6625-16.875125.0016 125.0016000-7.875-18.75125.7188 125.718813.50-7.0875-20.625122.8266 122.8266000-6.3-22.5116.45116.45000-5.5125-24.375106.7766 106.7766000-4.725-26.2593.99375 93.99375000-3.9375-28.12578.28906 78.28906000-3.15-3059.8559.850

22、00-2.3625-31.87538.86406 38.86406000-1.575-33.7515.51875 15.518753.50000-0.7875-35.625-9.99844 -9.998443.5125.71880000-37.5-37.5-37.56000000-37.5-37.56-37.500000-33.7737 -33.7737000-30.115-30.115000-26.5538 -26.5538000-23.12-23.12000-19.8438 -19.8438000-16.755-16.755000-13.8838 -13.8838000-11.26-11.

23、26000-8.91375 -8.91375000-6.875-6.875000-5.16375 -5.16375000-3.76-3.76000-2.63375 -2.63375000-1.755-1.755000-1.09375 -1.09375000-0.62-0.62000-0.30375 -0.30375000-0.115-0.115000-0.02375 -0.0237500000剪力图Vq11Vq12VP1VP2VP3Vq3Vq4Vq5Vq6000000#DIV/0!00-0.1875-0.75000-0.06375000-0.375-1.5000-0.255000-0.5625

24、-2.25000-0.57375000-0.75-3000-1.02000-0.9375-3.75000-1.59375000-1.125-4.5000-2.295000-1.3125-5.25000-3.12375000-1.5-6000-4.08000-1.6875-6.75000-5.16375000-1.875-7.5000-6.375000-2.0625-8.25000-7.58625000-2.25-9000-8.67000-2.4375-9.75000-9.62625000-2.625-10.5000-10.455000-2.8125-11.25000-11.1563000-3-

25、12000-11.73000-3.1875-12.75000-12.1763000-3.375-13.5000-12.495000-3.5625-14.25000-12.6863000-3.75-15000-12.750009.37562.500037.50008.437556.2500037.1250007.550000360006.562543.7500034.1250005.62537.500031.50004.687531.2500028.1250003.7525000240002.812518.7500019.1250001.87512.500013.50000.93756.2500

26、07.125000000000000-0.9375-6.25000-7.125000-1.875-12.5000-13.5000-2.8125-18.75000-19.125000-3.75-25000-24000-4.6875-31.25000-28.125000-5.625-37.5000-31.5000-6.5625-43.75000-34.125000-7.5-50000-36000-8.4375-56.25000-37.125000-9.375-62.5000-37.50007.50000300007.125000029.850006.75000029.40006.375000028

27、.650006000027.60005.625000026.250005.25000024.60004.875000022.650004.5000020.40004.125000017.850003.750000150003.375000012.15000300009.60002.62500007.350002.2500005.40001.87500003.750001.500002.40001.12500001.350000.7500000.60000.37500000.15000000000000配筋弯矩V1V2最终的V00-15.7500#DIV/0!#DIV/0!0#DIV/0!-15

28、.7500-1.00125 -1.00125125.7187500-2.13-2.13-37.500-3.38625 -3.38625-37.500-4.77-4.7700-6.28125 -6.2812500-7.92-7.9200-9.68625 -9.6862500-11.58-11.5800-13.6013 -13.601300-15.75-15.7500-17.8988 -17.898800-19.92-19.9200-21.8138 -21.813800-23.58-23.5800-25.2188 -25.218800-26.73-26.7300-28.1138 -28.11380

29、0-29.37-29.3700-30.4988 -30.498800-31.5-31.53.15-7.5105.025105.0253.15-7.597.462597.46253.15-7.589.1589.153.15-7.580.087580.08753.15-7.570.27570.2753.15-7.559.712559.71253.15-7.548.448.43.15-7.536.337536.33753.15-7.523.52523.5253.15-7.59.96259.96253.15-7.5-4.35-4.353.15-7.5-18.6625 -18.66253.15-7.5-

30、32.225-32.2253.15-7.5-45.0375 -45.03753.15-7.5-57.1-57.13.15-7.5-68.4125 -68.41253.15-7.5-78.975-78.9753.15-7.5-88.7875 -88.78753.15-7.5-97.85-97.853.15-7.5-106.163 -106.1633.15-7.5-113.725 -113.7250037.537.50036.97536.9750036.1536.150035.02535.0250033.633.60031.87531.8750029.8529.850027.52527.52500

31、24.924.90021.97521.9750018.7518.750015.52515.5250012.612.6009.9759.975007.657.65005.6255.625003.93.9002.4752.475001.351.35000.5250.52500008080绝对值设计剪力绝对值混凝土强度ft钢筋强度 箍筋强度 计算宽度15.75-31.531.514.31.4330021025015.75105.025105.02514.31.43300210250125.718814.31.4330021025037.5-113.725113.72514.31.4330021025

32、037.537.537.514.31.43300210250计算高度h01As60056510.0138009070.993051 0.0138979460056510.0138009070.993051 0.0138979460056510.1101608080.941497 0.11700678860056510.0328593010.983291 0.03341822560056510.0328593010.983291 0.033418225根数实配Asv/s间距s实配实配1 (122） -0.740943953-2209510-2201(122）-0.245200169-860951

33、0-8603 (322）7891 (122）-0.1865402442261 (122） -0.700488833-24022610-240计算结果输入数据选输数据7 7其余见说明配筋表左悬臂第一跨纵筋493(414）493(414）弯矩-110.0110.0弯矩23.396739纵筋103(114）剪力1038.113354箍筋10-18010-220数据输入说明：左右支座填0表示简支或带悬臂，填1时为固定支座左支座长度1270截面宽0.250.25截面高0.80.8砼容重0 0砼强度C3030纵筋HPB335335荷载输入说明：输入数值均为设计值荷载类均布载q11=0 0q11=0 0q1

34、2=0 0q12=0 0集中载只限三个P1=1010P1=5050a1=1a1=3.5P2=0 0P2=0 0a2=1a2=0P3=0 0P3=0 0a3=1.5a3=5三角载q3=0 0q3=0 00.0-110.0-18.2-35.90.018.423.40弯矩图cabcbaqqBABABABAbaP1,P2,P30.5L0.5LqaaBqABAq11,q12L梯形载q4=0 0q4=0 0a=0.80.0666667a=1局部均布载q5=0 0q5=0 0a=1a=5b=11b=2c=2c=3局部三角形载q6=0 0q6=0 0a=1a=2b=11b=5c=0.8c=1说说明明：本本程程

35、序序为为华华南南理理工工大大学学建建筑筑学学院院陈陈庆庆军军编编写写，仅仅用用于于学学习习，用用于于设设计计中中请请谨谨慎慎处处理理，本本计计算算不不负负任任何何责责任任。可可来来信信进进行行讨讨论论。本本表表格格最最好好在在12801024的的分分辨辨率率下下进进行行。chen_弯矩汇总自重00类型100类型2111043.75类型2100类型2100类型300类型400类型500类型600左右弯矩11043.75具体弯矩-66.25刚度矩阵0.0060952 0.00304760.0030476 0.0060952总刚0.0060952 0.00304760.0030476 0.01320

36、6300.0035556修正刚度0.0060952 0.00304760.0030476 0.0132063cabcbaqqBABABABAbaP1,P2,P30.5L0.5LqaaBqABAq11,q12L00逆矩阵185.46196 -42.79891-42.79891 85.59782600固端弯矩66.2543.7525.543478-43.75弯矩剪力表距离长度杆长q11q12左悬臂段000120000.050.60.6120000.11.21.2120000.151.81.8120000.22.42.4120000.2533120000.33.63.6120000.354.24.2

37、120000.44.84.8120000.455.45.4120000.566120000.556.66.6120000.67.27.2120000.657.87.8120000.78.48.4120000.7599120000.89.69.6120000.8510.210.2120000.910.810.8120000.9511.411.412000112121200第一段001270000.050.3512.3570000.10.712.770000.151.0513.0570000.21.413.470000.251.7513.7570000.32.114.170000.352.4514

38、.4570000.42.814.870000.453.1515.1570000.53.515.570000.553.8515.8570000.64.216.270000.654.5516.5570000.74.916.970000.755.2517.2570000.85.617.670000.855.9517.9570000.96.318.370000.956.6518.6570001719700第三段0019601000.050.319.3601000.10.619.6601000.150.919.9601000.21.220.2601000.251.520.5601000.31.820.8

39、601000.352.121.1601000.42.421.4601000.452.721.7601000.5322601000.553.322.3601000.63.622.6601000.653.922.9601000.74.223.2601000.754.523.5601000.84.823.8601000.855.124.1601000.95.424.4601000.955.724.76010016256010右悬臂段0025001000.05025001000.1025001000.15025001000.2025001000.25025001000.3025001000.35025

40、001000.4025001000.45025001000.5025001000.55025001000.6025001000.65025001000.7025001000.75025001000.8025001000.85025001000.9025001000.950250010010250010第三跨右悬臂80(114）80(114）158(214）#DIV/0!-18.218.2-35.935.918.3828881(114）11.88664627.051630432.9483696#DIV/0!10-200#DIV/0!60右支座0.250.2510.80.8箍筋HPB235纵筋直径

41、14箍筋直径1010肢数2 2q1=0 0q11=0 0q2=1010q12=1010P1=0 0P1=1010a1=3a1=3 3P2=0 0P2=0 0a2=1a2=1 1P3=0 0P3=0 0a3=4a3=1 1q3=0 0q3=0 00.0-1038.1-11.927.1-32.90.00.00.0剪力图说明：左右支座填0表示简支或带悬臂，填1时为固定支座70.250.8说明：输入数值均为设计值0.0-110.0-18.2-35.90.018.423.40弯矩图q4=0 0q4=0 00.14285714a=20.33333333a=0.50.5#DIV/0!q5=0 0q5=0 0

42、a=2a=1.51.5b=4b=-1.5c=2c=1 1q6=0 0q6=0 0a=2a=2 2b=4b=-2c=1c=1 10000030-300-43.75000000000000000000000000000-43.7530-300-13.75-300.007111110.00355560.003555560.0071111066.250.0035555613.750.007111110001011698.36960-1658.457910110-11.7934783018.2065217-18.206522-5.8967391-30-35.896739P1a1p2a2p3a3q3q41

43、010101.5001010101.5001010101.5001010101.5001010101.5001010101.5001010101.5001010101.5001010101.5001010101.5001010101.5001010101.5001010101.5001010101.5001010101.5001010101.5001010101.5001010101.5001010101.5001010101.5001010101.500503.5000500503.5000500503.5000500503.5000500503.5000500503.5000500503.

44、5000500503.5000500503.5000500503.5000500503.5000500503.5000500503.5000500503.5000500503.5000500503.5000500503.5000500503.5000500503.5000500503.5000500503.50005000301040003010400030104000301040003010400030104000301040003010400030104000301040003010400030104000301040003010400030104000301040003010400030

45、10400030104000301040003010400103010100103010100103010100103010100103010100103010100103010100103010100103010100103010100103010100103010100103010100103010100103010100103010100103010100103010100103010100103010100103010100as35350.0-1038.1-11.927.1-32.90.00.00.0剪力图aq5abcq6ab0.80111201110.80111201110.8011

46、1201110.80111201110.80111201110.80111201110.80111201110.80111201110.80111201110.80111201110.80111201110.80111201110.80111201110.80111201110.80111201110.80111201110.80111201110.80111201110.80111201110.80111201110.8011120111105230251052302510523025105230251052302510523025105230251052302510523025105230

47、2510523025105230251052302510523025105230251052302510523025105230251052302510523025105230252024202420242024202420242024202420242024202420242024202420242024202420242024202420242024202420242024202420242024202420242024202420242024202420242024202420242024202420240.501.5-1.5102-20.501.5-1.5102-20.501.5-1.

48、5102-20.501.5-1.5102-20.501.5-1.5102-20.501.5-1.5102-20.501.5-1.5102-20.501.5-1.5102-20.501.5-1.5102-20.501.5-1.5102-20.501.5-1.5102-20.501.5-1.5102-20.501.5-1.5102-20.501.5-1.5102-20.501.5-1.5102-20.501.5-1.5102-20.501.5-1.5102-20.501.5-1.5102-20.501.5-1.5102-20.501.5-1.5102-20.501.5-1.5102-2cMq11M

49、q12MP1MP2MP3Mq3Mq4Mq50.8000000000.8000000000.800-2000000.800-8000000.800-14000000.800-20000000.800-26000000.800-32000000.800-38000000.800-44000000.800-50000000.800-56000000.800-62000000.800-68000000.800-74000000.800-80000000.800-86000000.800-92000000.800-98000000.800-104000000.800-110000001000000001

50、008.750000010017.50000010026.2500000100350000010043.750000010052.50000010061.2500000100700000010078.750000010087.50000010078.7500000100700000010061.250000010052.50000010043.7500000100350000010026.250000010017.5000001008.7500000100000000100000000108.550000001016.20000001022.950000001028.80000001033.7