迭代法竖向荷载内力自动计算表格Excel

1、说明：1 本工作表为竖向荷载内力计算表格；2 本工作表中只需填写黄色、浅绿色和天蓝色，其他勿动，可能会导致结果不正确；3 表格编辑迭代原则：先从左至右，再从上到下。迭代开始从红色表格开始4 制作人：朱次华，联系方式：lanshuizhu_。右梁左梁右梁左梁-65.40-0.206-89.1389.13 -0.14611.16-0.146-77.9777.97-0.29413.47-3.60-0.208-3.60-6.76下柱19.2313.23-2.46-5.12-2.46-6.7918.8913.25-2.54-3.51-2.54-6.83第8层18.9113.25-2.52-3.62-2.

2、52-6.8418.913.6313.24-2.52-3.58-0.34-2.52-6.8518.903.62-3.58-0.333.64-0.343.54-0.20上柱4.75-0.77-0.185-0.147-44.92-0.13-60.3360.33 -0.1037.02-0.103-53.3153.31-0.1853.34-0.54-0.147-0.54-2.96下柱4.752.49-0.14-0.77-0.14-2.633.542.54-0.24-0.20-0.24-2.61第7层3.622.55-0.23-0.34-0.23-2.613.626.662.55-0.24-0.33-1

3、.08-0.24-2.613.626.66-0.34-1.076.68-1.096.59-0.97上柱7.43-1.69-0.185-0.147-44.92-0.13-60.3360.33 -0.1037.02-0.103-53.3153.31-0.1855.22-1.18-0.147-1.18-3.37下柱7.434.63-0.68-1.69-0.68-3.136.594.68-0.77-0.97-0.77-3.13第6层6.664.68-0.75-1.09-0.75-3.146.666.054.68-0.75-1.07-0.91-0.75-3.146.666.05-1.08-0.916.0

4、7-0.925.99-0.79上柱6.94-1.50-0.185-0.147-44.92-0.13-60.3360.33 -0.1037.02-0.103-53.3153.31-0.1854.87-1.05-0.147-1.05-3.33下柱6.944.21-0.56-1.50-0.56-3.075.994.25-0.65-0.79-0.65-3.07第5层6.054.25-0.64-0.92-0.64-3.076.056.164.25-0.64-0.91-0.94-0.64-3.076.056.17-0.91-0.946.19-0.966.11-0.83上柱7.03-1.54-0.185-0

5、.147-44.92-0.13-60.3360.33 -0.1037.02-0.103-53.3153.31-0.1854.94-1.08-0.147-1.08-3.33下柱7.034.29-0.58-1.54-0.58-3.086.114.34-0.67-0.83-0.67-3.08第4层6.174.34-0.66-0.96-0.66-3.086.176.224.33-0.66-0.94-0.96-0.66-3.086.166.22-0.94-0.966.19-0.966.08-0.82上柱7.01-1.53-0.185-0.147-44.92-0.13-60.3360.33 -0.1037

6、.02-0.103-53.3153.31-0.1854.93-1.07-0.147-1.07-3.33下柱7.014.27-0.58-1.53-0.58-3.086.084.33-0.67-0.82-0.67-3.08第3层6.174.37-0.67-0.96-0.67-3.096.225.794.37-0.67-0.96-0.86-0.67-3.096.225.79-0.96-0.865.79-0.855.98-0.79上柱7.01-1.53-0.185-0.147-44.92-0.13-60.3360.33 -0.1037.02-0.103-53.3153.31-0.1854.93-1.0

7、7-0.147-1.07-3.33下柱7.014.20-0.55-1.53-0.55-3.065.984.07-0.59-0.79-0.59-3.01第2层5.794.07-0.60-0.85-0.60-3.005.798.004.07-0.60-0.86-1.27-0.60-3.005.798.01-0.86-1.278.01-1.288.03-1.31上柱7.58-1.70-0.2-0.157-44.92-0.141-60.3360.33-0.117.02-0.11-53.3153.31-0.1595.34-1.19-0.124-1.19-3.52下柱6.035.66-0.92-1.34-

8、0.92-3.676.385.65-0.90-1.04-0.90-3.69第1层6.375.64-0.89-1.01-0.89-3.706.365.64-0.89-1.01-0.89-3.706.36-1.01上柱右梁左梁右梁左梁-0.11363.38-0.226-12.5912.59-0.445.80-0.161-13.513.39-0.06-9.63-13.573.390.46-9.67-13.663.450.46-9.73-13.693.460.47-9.75-3.75-13.693.460.470.02-9.75-3.750.470.02-3.750.02-3.770.02-4.250

9、.07-0.122-0.054-0.08545.04-0.171-8.278.27 -0.3934.25-0.122-5.960.49-0.054-4.25-5.280.170.07-3.77-5.260.170.02-3.75-5.250.170.02-3.75-4.50-5.250.170.020.10-3.75-4.500.020.10-4.500.10-4.490.10本工作表为竖向荷载内力计算表格；本工作表中只需填写黄色、浅绿色和天蓝色，其他勿动，可能会导致结果不正确；表格编辑迭代原则：先从左至右，再从上到下。迭代开始从红色表格开始制作人：朱次华，联系方式：lanshuizhu_。-

10、4.830.13-0.122-0.054-0.08545.04-0.171-8.278.27 -0.3934.25-0.122-6.770.96-0.054-4.83-6.290.740.13-4.49-6.300.760.10-4.50-6.310.760.10-4.50-4.41-6.310.760.100.09-4.50-4.410.100.09-4.410.09-4.410.09-4.780.12-0.122-0.054-0.08545.04-0.171-8.278.27 -0.3934.25-0.122-6.700.91-0.054-4.78-6.180.670.12-4.41-6.

11、180.680.09-4.41-6.180.680.09-4.41-4.42-6.180.680.090.09-4.41-4.420.090.09-4.420.09-4.410.09-4.780.13-0.122-0.054-0.08545.04-0.171-8.278.27 -0.3934.25-0.122-6.700.91-0.054-4.78-6.190.680.13-4.41-6.190.690.09-4.42-6.200.690.09-4.42-4.43-6.200.690.090.10-4.42-4.430.090.10-4.420.10-4.410.09-4.780.13-0.1

12、22-0.054-0.08545.04-0.171-8.278.27 -0.3934.25-0.122-6.700.91-0.054-4.78-6.190.680.13-4.41-6.200.690.09-4.42-6.210.700.10-4.43-4.31-6.210.700.100.08-4.43-4.310.100.08-4.320.08-4.390.09-4.780.13-0.122-0.054-0.08545.04-0.171-8.278.27 -0.3934.25-0.122-6.700.91-0.054-4.78-6.150.650.13-4.39-6.060.610.09-4

13、.32-6.040.600.08-4.31-5.30-6.040.600.080.17-4.31-5.300.080.17-5.290.16-5.260.16-5.040.14-0.129-0.054-0.0945.04-0.18-8.278.27-0.44.25-0.102-7.031.06-0.046-3.98-7.341.200.12-4.16-7.381.220.14-4.18-7.391.220.14-4.19-7.391.220.14-4.190.14右梁左梁-65.40-0.206-89.1389.13-0.29413.47-3.60下柱19.2313.23-2.4618.891

14、3.25-2.52第8层18.9112.99-2.4518.544.9612.96-2.4418.494.954.883.54上柱4.75-0.185-44.92-0.13-60.3360.33-0.1853.34-0.54下柱4.753.45-0.204.853.41-0.36第7层4.883.48-0.354.953.48-0.364.96上柱7.43右梁左梁右梁-0.14611.16-0.146-77.9777.97-0.113-0.208-3.60-6.76-5.12-2.46-6.79-3.51-2.52-6.78-3.60-2.45-6.78-3.49-0.60-2.44-6.78

15、-3.48-0.60-0.57-0.34-0.77-0.147-0.1037.02-0.103-53.3153.31-0.085-0.147-0.54-2.96-0.77-0.72-2.95-1.02-0.70-2.95-1.00-0.72-2.95-1.03-0.72-2.95-1.03-1.69左梁右梁左梁63.38-0.226-12.5912.59-0.445.80-0.161-13.513.39-0.06-9.63-13.573.390.46-9.67-13.553.380.46-9.65-13.563.390.46-9.66-4.29-13.573.390.460.07-9.67-4

16、.290.460.07-4.290.07-4.290.07-4.250.07-0.122-0.05445.04-0.171-8.278.27-0.3934.25-0.122-5.960.49-0.054-4.25-5.930.480.07-4.23-5.930.48-0.37-4.23-5.930.482.01-4.23-5.930.48-11.75-4.2340.54说明：1 本工作表为竖向荷载内力计算表格；2 本工作表中只需填写黄色、浅绿色和天蓝色，其他勿动，可能会导致结果不正确；3 表格编辑迭代原则：先从左至右，再从上到下。迭代开始从红色表格开始4 制作人：朱次华，联系方式：lanshu

17、izhu_。右梁左梁右梁左梁-65.40-0.206-89.1389.13 -0.14611.16-0.146-77.9777.97-0.29413.47-3.60-0.208-3.60-6.76下柱19.2313.23-2.46-5.12-2.46-6.7918.8913.25-2.54-3.51-2.54-6.83第8层18.9113.25-2.52-3.62-2.52-6.8418.913.6313.24-2.52-3.58-0.34-2.52-6.8518.903.62-3.58-0.333.64-0.343.54-0.20上柱4.75-0.77-0.185-0.147-44.92-0

18、.13-60.3360.33 -0.1037.02-0.103-53.3153.31-0.1853.34-0.54-0.147-0.54-2.96下柱4.752.49-0.14-0.77-0.14-2.633.542.54-0.24-0.20-0.24-2.61第7层3.622.55-0.23-0.34-0.23-2.613.626.662.55-0.24-0.33-1.08-0.24-2.613.626.66-0.34-1.076.68-1.096.59-0.97上柱7.43-1.69-0.185-0.147-44.92-0.13-60.3360.33 -0.1037.02-0.103-53

19、.3153.31-0.1855.22-1.18-0.147-1.18-3.37下柱7.434.63-0.68-1.69-0.68-3.136.594.68-0.77-0.97-0.77-3.13第6层6.664.68-0.75-1.09-0.75-3.146.666.054.68-0.75-1.07-0.91-0.75-3.146.666.05-1.08-0.916.07-0.925.99-0.79上柱6.94-1.50-0.185-0.147-44.92-0.13-60.3360.33 -0.1037.02-0.103-53.3153.31-0.1854.87-1.05-0.147-1.05

20、-3.33下柱6.944.21-0.56-1.50-0.56-3.075.994.25-0.65-0.79-0.65-3.07第5层6.054.25-0.64-0.92-0.64-3.076.056.164.25-0.64-0.91-0.94-0.64-3.076.056.17-0.91-0.946.19-0.966.11-0.83上柱7.03-1.54-0.185-0.147-44.92-0.13-60.3360.33 -0.1037.02-0.103-53.3153.31-0.1854.94-1.08-0.147-1.08-3.33下柱7.034.29-0.58-1.54-0.58-3.0

21、86.114.34-0.67-0.83-0.67-3.08第4层6.174.34-0.66-0.96-0.66-3.086.176.224.33-0.66-0.94-0.96-0.66-3.086.166.22-0.94-0.966.19-0.966.08-0.82上柱7.01-1.53-0.185-0.147-44.92-0.13-60.3360.33 -0.1037.02-0.103-53.3153.31-0.1854.93-1.07-0.147-1.07-3.33下柱7.014.27-0.58-1.53-0.58-3.086.084.33-0.67-0.82-0.67-3.08第3层6.

22、174.37-0.67-0.96-0.67-3.096.225.794.37-0.67-0.96-0.86-0.67-3.096.225.79-0.96-0.865.79-0.855.98-0.79上柱7.01-1.53-0.185-0.147-44.92-0.13-60.3360.33 -0.1037.02-0.103-53.3153.31-0.1854.93-1.07-0.147-1.07-3.33下柱7.014.20-0.55-1.53-0.55-3.065.984.07-0.59-0.79-0.59-3.01第2层5.794.07-0.60-0.85-0.60-3.005.798.00

23、4.07-0.60-0.86-1.27-0.60-3.005.798.01-0.86-1.278.01-1.288.03-1.31上柱7.58-1.70-0.2-0.157-44.92-0.141-60.3360.33-0.117.02-0.11-53.3153.31-0.1595.34-1.19-0.124-1.19-3.52下柱6.035.66-0.92-1.34-0.92-3.676.385.65-0.90-1.04-0.90-3.69第1层6.375.64-0.89-1.01-0.89-3.706.365.64-0.89-1.01-0.89-3.706.36-1.01上柱右梁左梁右梁左

24、梁-0.11363.38-0.226-12.5912.59-0.445.80-0.161-13.513.39-0.06-9.63-13.573.390.46-9.67-13.663.450.46-9.73-13.693.460.47-9.75-3.75-13.693.460.470.02-9.75-3.750.470.02-3.750.02-3.770.02-4.250.07-0.122-0.054-0.08545.04-0.171-8.278.27 -0.3934.25-0.122-5.960.49-0.054-4.25-5.280.170.07-3.77-5.260.170.02-3.75

25、-5.250.170.02-3.75-4.50-5.250.170.020.10-3.75-4.500.020.10-4.500.10-4.490.10本工作表为竖向荷载内力计算表格；本工作表中只需填写黄色、浅绿色和天蓝色，其他勿动，可能会导致结果不正确；表格编辑迭代原则：先从左至右，再从上到下。迭代开始从红色表格开始制作人：朱次华，联系方式：lanshuizhu_。-4.830.13-0.122-0.054-0.08545.04-0.171-8.278.27 -0.3934.25-0.122-6.770.96-0.054-4.83-6.290.740.13-4.49-6.300.760.10-4.50-6.310.760.10-4.50-4.41-6.310.760.100.09-4.50-4.410.100.09-4.410.09-4.410.09-4.780.12-0.122-0.054-0.08545.04-0.171-8.278.27 -0.3934.25-0.122-6.700.91-0.054-4.78-6.