土木工程毕业设计excel模板

楼层g1/q1(kN/m)''g1/q1(kN/m)g2/q2(kN/m)''g2/q2(kN/m)G1/Q1G2/Q2(kN)(kN)M1(kN·m)M2(kN·m)1~48.992.9514.8213.47137.82169.1917.2321.15恒载52.952.9519.9318.12115.10145.6914.3918.21活载1~5006.606.0025.2540.553.165.07α

0.275

12.

8.42等效

荷载

17.3311.335.74

3.75

1~4g1g221.88g1'g2'11.3788.84673.8635g1g220.28g1'g2'14.2882.36244.85796

1~5

q1q2

5.74q1'q2'3.75初始弯矩MCDMDCMDEMED恒载5-54.9154.91-12.95-6.481~4-59.2359.23-10.32-5.16活载1~5-15.5415.54-3.40-1.70楼层52~412.071.07

3.141.00

3.000.93

2.931.00

4.001.07

3.870.93

3.450.86

表6.2 各节点分配系数计算

A轴上柱/0.3410.357下柱0.5170.3410.310右梁0.4830.3180.333左梁0.3410.2500.259上柱/0.2670.277B轴下柱0.3650.2670.241右梁0.2940.2160.223表

恒载

节点杆端分配系数固端弯矩(kN·m)节点C弯矩分配传递节点D弯矩分配传递节点C弯矩分配传递节点D弯矩分配传递节点C弯矩分配传递节点D弯矩分配传递最终弯矩(kN·m)AAC//6.980.980.0418.01表

活

载

节点A活载

杆端分配系数固端弯矩(kN·m)节点C弯矩分配传递节点D弯矩分配传递节点C弯矩分配传递节点D弯矩分配传递节点C弯矩分配传递节点D弯矩分配传递最终弯矩(kN·m)AC//2.130.300.0122.44表6.3 恒载作用下顶层杆端弯矩计算

CDBECACDDCDBDEBDED0.5170.4830.3410.3650.294//1414.39.39-54.9154.91-18.2118.21-12.95/-6.4820.9519.579.78-5.71-11.43-12.23-9.87-4.0.872.952.761.38-0.24-0.47-0.50-0.41-0.170.410.1220.1140.057-0.010-0.019-0.021-0.017-0.0070.01724.03-38.4354.21-12.76-23.25-4.253.81-36.04

表6.6 活载作用下顶层杆端弯矩计算

CDBE节点杆端分配系数固端弯矩(kN·m)节点C弯矩分配传递节点D弯矩分配传递节点C弯矩分配传递节点D弯矩分配传递节点C弯矩分配传递节点D弯矩分配传递最终弯矩(kN·m)节点CACDDCDBDEBDED0.5170.4830.3410.3650.294//33.16.16-15.5415.54-5.075.07-3.40/-1.706.405.982.99-1.71-3.43-3.67-2.96-1.222.960.0.830.41-0.070-0.141-0.151-0.122-0.0500.1220.0360.0340.017-0.003-0.006-0.006-0.005-0.0020.0057.32-10.4915.38-3.83-6.49-1.281.38-10.38

杆端分配系数固端弯矩(kN·m)节点C弯矩分配传递

节点D弯矩分配传递节点C弯矩分配传递

节点D弯矩分配传递节点C弯矩分配传递

节点D弯矩分配传递最终弯矩(kN·m)表6.4 恒载作用下第2-4层杆端弯矩计算

A(F)AC(FC)//4.77CF0.341CCA0.341CD0.318-59.2314.3213.37-4.300.491.471.471.37-0.0850.0100.0290.0290.027-0.0025.2715.8115.81-48.85-35.51

DC0.25059.236.69-8.600.68-0.1710.014-0.00357.84-0.004-9.40-0.004-9.40-0.003-17.90-0.001-3.130.0032.42-0.183-0.183-0.148-0.0610.148-9.21-9.21-7.43-3.077.43DG0.267DDB0.267DE0.216-10.32B(G)BD(GD)//EED/-5.1617.2917.2314.3220.-21.15表6.7 活载作用下第2-4层杆端弯矩计算

A(F)CDB(G)EAC(FC)//1.41CF0.3413.163.16CA0.341CD0.318-15.54DC0.25015.541.97-2.260.18-0.0450.004-0.00115.39DG0.2675.07-5.07DB0.267DE0.216-3.40BD(GD)//ED/-1.704.224.223.94-1.13-2.42-2.42-1.95-0.811.950.130.380.380.36-0.022-0.048-0.048-0.039-0.0160.0390.0030.0080.0080.0070.000-0.001-2.46-0.001-2.46-0.001-5.390.000-0.820.0010.291.544.614.61-12.38-9.43

表6.5 恒载作用下首层杆端弯矩计算

节点杆端分配系数固端弯矩(kN·m)节点C弯矩分配传递节点D弯矩分配传递节点C弯矩分配传递节点D弯矩分配传递节点C弯矩分配传递0.015节点D弯矩分配传递最终弯矩(kN·m)7.235.5416.620.0120.0350.0300.700.531.601.39AAC//6.51FFC//4.99CF0.35717.2317.23CCA0.310CD0.333DC0.259DG0.277DDB0.241DE0.223-10.32BBD//21.15-59.2359.23-21.1514.9813.0313.99-4.501.50-0.100.0327.00-8.990.75-0.190.016-0.21-0.18-0.17-0.09-9.63-8.37-7.77-4.19-0.002-0.004-0.004-0.004-0.004-0.00214.45-48.3057.80-35.81

-9.84-8.56-18.25-4.28表6.8 活载作用下首层杆端弯矩计算

节点AFCDB杆端分配系数固端弯矩(kN·m)节点C弯矩分配传递节点D弯矩分配传递节点C弯矩分配传递节点D弯矩分配传递AC//1.92FC//1.47CF0.3573.163.16CA0.310CD0.333DC0.259DG0.2775.07-5.07DB0.241DE0.223-3.40BD//-15.5415.543.844.12-1.182.06-2.360.204.42-2.53-2.20-2.04-1.100.180.140.420.370.39-0.025-0.051-0.054-0.047-0.044-0.0240.0030.0090.0080.0080.004节点C弯矩分配传递0.004节点D弯矩分配传递最终弯矩(kN·m)2.11-0.001-0.001-0.001-0.001-0.001-0.0011.624.854.21-12.2215.39-9.51

-2.58-2.25-5.49-1.12柱柱梁梁柱柱梁柱框架最终弯矩恒载GGD//EED/-5.165不平衡分配最终4-3.217.77不平衡分配-0.070.17最终3-0.0010.004不平衡-3.282.78分配最终2GE不平衡15.818.01-4.5319.2915.815.27-3.5917.4915.815.27(CF)CA24.035.27-2.7226.5715.815.27-4.5316.5515.815.27-3.5917.4915.815.54-3.36-52.21-48.851.5659.4057.84-4.23-53.08-48.851.8459.6857.84-2.55-40.97-48.851.0755.2857.84-9.40-4.251.97-11.67-9.40-3.131.67-10.85-9.40-3.13CD-38.43DC54.21(DG)DB-12.76-3.131.14-14.75-9.40-3.131.97-10.55-9.40-3.131.67-10.85-9.40-3.281.35-16.55-17.901.59-16.30-17.900.92-22.32-17.90DE-23.25活载5不平衡分配最终4不平衡分配最终3不平衡分配最终2不平衡(CF)4.612.44-1.365.704.611.54-1.055.104.611.54GD//ED/-1.70分配最终1不平衡-3.6817.4016.625.27-1.8820.01-3.6817.6714.45-3.44-52.29-48.301.6059.4457.801.71-10.81-9.84-3.131.71-10.96-8.561.38-16.51-18.25分配最终1不平衡-1.075.074.851.54-0.555.83-0.842.04分配最终-1.6312.82-1.76-50.060.8158.610.87-12.100.75-7.800.70-17.56分配最终-0.0180.044柱0.000-0.860.0010.38柱梁梁柱柱梁柱柱梁梁柱柱梁CACDDC(DG)DBDE7.32-10.4915.38-3.83-6.491.54-0.82-0.79-0.740.280.300.248.06-11.2315.66-4.35-6.25-40.73

4.61-12.3815.39-2.46-2.46-5.391.54-1.28-0.82-1.36-1.270.520.560.560.454.79-13.6515.91-3.18-2.73-4.94-32.48

4.61-12.3815.39-2.46-2.46-5.391.54-0.82-0.82-1.05-0.980.410.440.440.355.10-13.3615.80-2.85-2.85-5.04-33.06

4.61-12.3815.39-2.46-2.46-5.391.62-0.82-0.86-9.87

40.73

-8.53

32.48

-8.73

33.06

9.87

8.53

8.73

-1.07-1.000.420.450.450.365.15-13.3915.81-2.84-2.88-5.03-32.99

4.21-12.2215.39-2.58-2.25-5.49-0.82-0.48-0.510.210.230.200.183.74-12.7315.60-3.18-2.05-5.30-34.52

柱梁梁柱柱梁

1~4-8.71

32.99

8.71

51~5

-9.15

34.52

9.15

荷载引起的楼边跨层VL= ql/2VR= -ql/2557.80-57.80462.35-62.35362.35-62.35262.35-62.35162.35-62.35荷载引起的楼边跨层VL= ql/2VR= -ql/2516.36-16.316.36-16.36316.36-16.36216.36-16.36116.36-16.36g1g221.88g1'g2'11.37g1g220.28g1'g2'14.28q1q2

5.74

q1'q2'

3.75

表6.9 恒载作用下梁端剪力计算 （单位：kN）

弯矩引起的剪力总剪力中跨边跨中跨边跨中跨VVL=VRVL=VRL= ql/2VR= -ql/2=(MVLVRVLVRL-MR)/l=(ML-MR)/l40.68-40.68-2.510.0055.29-60.3140.68-40.6832.40-32.40-1.160.0061.19-63.5132.40-32.4032.40-32.40-1.260.0061.09-63.6132.40-32.4032.40-32.40-1.250.0061.09-63.6032.40-32.4032.40-32.40-1.500.0060.85-63.8532.40-32.40表6.10 活载作用下梁端剪力计算 （单位：kN）

弯矩引起的剪力总剪力中跨边跨中跨边跨中跨VVL=VRVL=VRL= ql/2VR= -ql/2=(MVLVRVLVRL-MR)/l=(ML-MR)/l10.69-10.69-0.780.0015.58-17.1310.69-10.6910.69-10.69-0.400.0015.96-16.7510.69-10.6910.69-10.69-0.430.0015.93-16.7810.69-10.6910.69-10.69-0.430.0015.93-16.7810.69-10.6910.69-10.69-0.500.0015.85-16.8610.69-10.69楼层54321引起的剪力引起的剪力G1/Q1G2/Q2(kN)1~4恒载5活载柱自重

1~56.875

115.125.25137.82(kN)169.19145.6940.55表6.11 恒载和活载作用下柱轴力计算 （单位：kN）

恒载作用下边柱(A轴)uNAbNA活载作用下边柱(A轴)uNAbNA中柱(B轴)uNBbNB中柱(B轴)uNBbNB170.39394.15617.80841.4710.195.14418.902.55866.221096.51246.68536.53826.481116.431406.62271.43561.28851.231141.181438.2440.8382.04123.211.40205.5040.8382.04123.211.40205.5068.37136.36204.38272.40340.5068.37136.36204.38272.40340.50表6.12 恒载和活载作用下柱剪力计算 （单位：kN）

恒载作用下楼层边柱(A轴)54321-12.74-9.46-9.43-10.47-4.36中柱(B轴)7.345.956.026.413.36边柱(A轴)-2.75-2.56-2.83-3.05-1.27中柱(B轴)2.091.551.581.680.88活载作用下