某办公楼梁板柱配筋自动计算表格Excel

1、C30ftfcfyfyv1.4314.30300.00270.001FA柱顶12341FA柱顶1FA柱顶N-2500.00-1631.99-1678.27-2037.401FA柱顶M-37.21-2.86-53.56-21.89N2500.001631.991678.272037.40M37.212.8653.5621.89x=N/ax=N/a1 1f fc cb b388.50253.61260.80316.61b*ho225.50225.50225.50225.50大小偏压00001FA柱底N-2051.28-1631.99-1678.27-2037.401FA柱底M24.60-17.88

2、54.912.62N2051.281631.991678.272037.40M24.6017.8854.912.62x=N/ax=N/a1 1f fc cb b318.77253.61260.80316.61b*ho225.50225.50225.50225.50大小偏压小小小小M237.2117.8854.9121.89M124.602.8653.562.62M1/M20.660.160.980.12符号判断-1.001.00-1.00-1.00最终M1/M2-0.660.16-0.98-0.12ea=max(b/30,20)20.0020.0020.0020.00c=0.5fcA/N0.5

3、80.890.860.71最终c0.580.890.860.71lc/h12.0012.0012.0012.00Cm=0.7+0.3M1/M20.500.750.410.66最终Cm0.700.750.700.701300(M2/N+ea)/ho110.6098.15167.1597.48弯矩增大系数ns1.752.301.742.05考虑二阶效应的M=CmnsM245.6830.7867.0031.41eo=M/N0.020.020.040.02ei=eo+ea20.0220.0220.0420.02e=ei+h/2-as205.02205.02205.04205.02a1fcbx(ho-0

4、.5x)539374514462169827469241657512800709As=As-241.70-1149.38-1127.29-856.78单侧min405.00405.00405.00405.00小偏心分母左512481.91-1411382.06-1308415.50-512902.64小偏心0.880.700.720.83-1.E+08-2.E+08-2.E+08-1.E+08小偏心AS-188.28-1412.25-1392.73-961.81单侧最终配筋-188.28-1412.25-1392.73-961.81最大计算配筋405.00单边实配3f183f183f183f1

5、8实配面积763.00763.00763.00763.00c=0.5fcA/N0.710.890.860.71最终c0.710.890.860.71弯矩增大系数ns1.922.301.742.05考虑二阶效应的M=CmnsM249.9830.7867.0031.41eo=M/N0.020.020.040.02ei=eo+ea20.0220.0220.0420.02e=ei+h/2-as205.02205.02205.04205.02a1fcbx(ho-0.5x)514082743462169827469241657512800709As=As-842.52-1149.38-1127.29-85

6、6.78单侧min405.00405.00405.00405.00单侧最终配筋405.00405.00405.00405.00最大计算配筋405.00单边实配3f183f183f183f18实配面积763.00763.00763.00763.00柱全部纵筋配筋率1.101.101.101.10是否满足全部纵筋0.8%满足满足满足满足保护层cbhh0ba120.00450.00450.00410.000.551.005678910-2065.17-1909.29-1955.58-2139.33-1848.14-1875.91-52.31-9.04-59.74-38.11-16.62-47.042

7、065.171909.291955.582139.331848.141875.9152.319.0459.7438.1116.6247.04320.93296.70303.90332.45287.20291.52225.50225.50225.50225.50225.50225.50000000-2065.17-1909.29-1955.58-2139.33-1848.14-1875.9146.29-13.7959.0025.19-0.8942.792065.171909.291955.582139.331848.141875.9146.2913.7959.0025.190.8942.7932

8、0.93296.70303.90332.45287.20291.52225.50225.50225.50225.50225.50225.50小小小小小小52.3113.7959.7438.1116.6247.0446.299.0459.0025.190.8942.790.880.660.990.660.050.91-1.001.00-1.00-1.001.00-1.00-0.880.66-0.99-0.660.05-0.9120.0020.0020.0020.0020.0020.000.700.760.740.680.780.770.700.760.740.680.780.7712.0012.

9、0012.0012.0012.0012.000.430.900.400.500.720.430.700.900.700.700.720.70143.7386.31160.27119.8991.93142.921.702.271.671.812.231.7862.3428.0069.6348.3626.5058.530.030.010.040.020.010.0320.0320.0120.0420.0220.0120.03205.03205.01205.04205.02205.01205.035153342114995622065046395175215129304923431754956934

10、19-828.04-974.14-934.02-746.86-1022.06-1000.66405.00405.00405.00405.00405.00405.00-451023.26-796845.23-693820.12-286808.20-932391.26-870499.940.830.800.810.840.780.79-1.E+08-1.E+08-1.E+08-9.E+07-1.E+08-1.E+08-918.43-1148.99-1083.41-800.57-1229.16-1193.32-918.43-1148.99-1083.41-800.57-1229.16-1193.32

11、3f183f183f183f183f183f18763.00763.00763.00763.00763.00763.000.700.760.740.680.780.770.700.760.740.680.780.771.702.271.671.812.231.78405.0062.3428.0069.6348.3626.5058.530.030.010.040.020.010.0320.0320.0120.0420.0220.0120.03205.03205.01205.04205.02205.01205.03515334211499562206504639517521512930492343

12、175495693419-828.04-974.14-934.02-746.86-1022.06-1000.66405.00405.00405.00405.00405.00405.00405.00405.00405.00405.00405.00405.003f183f183f183f183f183f18763.00763.00763.00763.00763.00763.001.101.101.101.101.101.10满足满足满足满足满足满足405.001asaslcfy单侧min0.8040.0040.005400.00300.000.0020111213141516-2125.44-21

13、53.21-1775.43-1356.13-1402.42-1761.54-22.79-53.21-32.471.87-48.83-17.162125.442153.211775.431356.131402.421761.5422.7953.2132.471.8748.8317.16330.29334.61275.90210.74217.94273.74225.50225.50225.50225.50225.50225.50000110-2125.44-2153.21-1775.43-1356.13-1402.42-1761.543.2146.8821.47-21.0051.78-0.5021

14、25.442153.211775.431356.131402.421761.543.2146.8821.4721.0051.780.50330.29334.61275.90210.74217.94273.74225.50225.50225.50225.50225.50225.50小小小大大小22.7953.2132.4721.0051.7817.163.2146.8821.471.8748.830.500.140.880.660.090.940.03-1.00-1.00-1.00-1.00-1.001.00-0.14-0.88-0.66-0.09-0.940.0320.0020.000.680

15、.670.821.071.030.820.680.670.821.001.000.8212.0012.0012.0012.0012.0012.000.660.440.500.670.420.710.700.700.700.700.700.7197.42141.7858.0049.11117.0730.892.011.683.023.932.234.8332.0262.6968.7657.8280.8358.770.020.030.040.040.060.0320.0220.030.040.040.060.03205.02205.03185.04185.04185.06185.035204209

16、26522574459483003696413116344422172272481126291-762.82-730.66-1391.72-1461.03-1465.27-1398.04405.00405.00405.00405.00405.00405.00-317764.67-255888.10-1476951.70-2315663.74-2222847.23-1504836.630.840.840.830.260.430.82-9.E+07-9.E+07-2.E+081.E+07-1.E+08-2.E+08-823.16-777.90-1770.9287.33-967.21-1785.06

17、-823.16-777.90-1770.92-1461.03-1465.27-1785.063f183f183f183f183f183f18763.00763.00763.00763.00763.00763.000.680.670.821.071.030.820.680.670.821.001.000.822.011.683.023.932.234.83405.0032.0262.6968.7657.8280.8358.770.020.030.040.040.060.0320.0220.030.040.040.060.03205.02205.03185.04185.04185.06185.03

18、520420926522574459483003696413116344422172272481126291-762.82-730.66-1391.72-1461.03-1465.27-1398.04405.00405.00405.00405.00405.00405.00405.00405.00405.00405.00405.00405.003f183f183f183f183f183f18763.00763.00763.00763.00763.00763.001.101.101.101.101.101.10满足满足满足满足满足满足405.00调整后的弯矩-249.61-249.61-249.6

19、1171819202122-1789.31-1633.44-1679.72-1256.76-1618.23-1017.09-47.58-4.31-55.01249.61-249.61249.611789.311633.441679.721256.761618.231017.0947.584.3155.01249.61249.61249.61278.06253.84261.03195.30251.47158.06225.50225.50225.50225.50225.50225.50000101-1789.31-1633.44-1679.72-1256.76-1618.23-1017.0943.

20、17-16.9155.87-212.67245.60-215.491789.311633.441679.721256.761618.231017.0943.1716.9155.87212.67245.60215.49278.06253.84261.03195.30251.47158.06225.50225.50225.50225.50225.50225.50小小小大小大47.5816.9155.87249.61249.61249.6143.174.3155.01212.67245.60215.490.910.250.980.850.980.86-1.001.00-1.00-1.00-1.00-

21、1.00-0.910.25-0.98-0.85-0.98-0.860.810.890.861.150.891.420.810.890.861.000.891.0012.0012.0012.0012.0012.0012.000.430.780.400.440.400.440.700.780.700.700.700.7084.3232.83105.47629.75489.08778.142.384.892.181.231.261.1979.3464.1885.14214.68220.76207.060.040.040.050.170.140.200.040.040.050.170.140.2018

22、5.04185.04185.05185.17185.14185.20484850251462396228469457638392549452460002783336628442-1385.12-1442.76-1429.05-1439.94-1445.14-1335.67405.00405.00405.00405.00405.00405.00-1449073.70-1760985.77-1668191.47-2512703.19-1789715.83-2992133.190.830.760.79-1.000.751.78-2.E+08-2.E+08-2.E+082.E+09-2.E+08-3.

23、E+07-1756.09-1863.90-1848.4716648.67-1861.57-235.79-1756.09-1863.90-1848.47-1439.94-1861.57-1335.673f183f183f183f183f183f18763.00763.00763.00763.00763.00763.000.810.890.861.150.891.420.810.890.861.000.891.002.384.892.181.231.261.19405.0079.3464.1885.14214.68220.76207.060.040.040.050.170.140.200.040.

24、040.050.170.140.20185.04185.04185.05185.17185.14185.20484850251462396228469457638392549452460002783336628442-1385.12-1442.76-1429.05-1439.94-1445.14-1335.67405.00405.00405.00405.00405.00405.00405.00405.00405.00405.00405.00405.003f183f183f183f183f183f18763.00763.00763.00763.00763.00763.001.101.101.10

25、1.101.101.10满足满足满足满足满足满足405.00-249.61EsfcukEcub200000.0030.000.003300.5523a1*fc*b*hoa1*fc*b*ho2小偏心的分母左-1378.5526383501081723500-249.611378.55249.61214.23225.501-1378.55242.771378.55242.77214.23225.50大249.61242.770.97-1.00-0.971.051.0012.000.410.70574.111.25218.550.160.16185.16417544507-1462.11405.00

26、-2269087.290.35-6.E+07-536.82-1462.113f18763.001.051.001.25405.00218.550.160.16185.16417544507-1462.11405.00405.003f18763.001.10满足405.00C30II1fcMPaasmmfybft1.0014.3035.00360.000.551.43层层号号跨跨名名控控制制截截面面M(kNm)M(kNm)b bh hh0h0 x x1AB左支座316.58300800765103.46跨中494.90280080076516.33右支座3008007650.00AB梁左端按双筋

27、复核300*800As=1963.00=515.88M1=M-M=-199.29=-618.41718322as=70.00b.h0=420.75As=1204.656334fyasas360.0035.0035.000b.h0b.h0 xb*h0 x0.8%满足满足满足满足保护层cbhh0ba120.00450.00450.00410.000.551.005678910-2065.17-1909.29-1955.58-2139.33-1848.14-1875.91-52.31-9.04-59.74-38.11-16.62-47.042065.171909.291955.582139.3318

28、48.141875.9152.319.0459.7438.1116.6247.04320.93296.70303.90332.45287.20291.52225.50225.50225.50225.50225.50225.50000000-2065.17-1909.29-1955.58-2139.33-1848.14-1875.9146.29-13.7959.0025.19-0.8942.792065.171909.291955.582139.331848.141875.9146.2913.7959.0025.190.8942.79320.93296.70303.90332.45287.202

29、91.52225.50225.50225.50225.50225.50225.50小小小小小小52.3113.7959.7438.1116.6247.0446.299.0459.0025.190.8942.790.880.660.990.660.050.91-1.001.00-1.00-1.001.00-1.00-0.880.66-0.99-0.660.05-0.9120.0020.0020.0020.0020.0020.000.700.760.740.680.780.770.700.760.740.680.780.7712.0012.0012.0012.0012.0012.000.430.9

30、00.400.500.720.430.700.900.700.700.720.70143.7386.31160.27119.8991.93142.921.702.271.671.812.231.7862.3428.0069.6348.3626.5058.530.030.010.040.020.010.0320.0320.0120.0420.0220.0120.03205.03205.01205.04205.02205.01205.03515334211499562206504639517521512930492343175495693419-828.04-974.14-934.02-746.8

31、6-1022.06-1000.66405.00405.00405.00405.00405.00405.00-451023.26-796845.23-693820.12-286808.20-932391.26-870499.940.830.800.810.840.780.79-1.E+08-1.E+08-1.E+08-9.E+07-1.E+08-1.E+08-918.43-1148.99-1083.41-800.57-1229.16-1193.32-918.43-1148.99-1083.41-800.57-1229.16-1193.323f183f183f183f183f183f18763.0

32、0763.00763.00763.00763.00763.000.700.760.740.680.780.770.700.760.740.680.780.771.702.271.671.812.231.78405.0062.3428.0069.6348.3626.5058.530.030.010.040.020.010.0320.0320.0120.0420.0220.0120.03205.03205.01205.04205.02205.01205.03515334211499562206504639517521512930492343175495693419-828.04-974.14-93

33、4.02-746.86-1022.06-1000.66405.00405.00405.00405.00405.00405.00405.00405.00405.00405.00405.00405.003f183f183f183f183f183f18763.00763.00763.00763.00763.00763.001.101.101.101.101.101.10满足满足满足满足满足满足405.001asaslcfy单侧min0.8040.0040.005400.00300.000.0020111213141516-2125.44-2153.21-1775.43-1356.13-1402.42

34、-1761.54-22.79-53.21-32.471.87-48.83-17.162125.442153.211775.431356.131402.421761.5422.7953.2132.471.8748.8317.16330.29334.61275.90210.74217.94273.74225.50225.50225.50225.50225.50225.50000110-2125.44-2153.21-1775.43-1356.13-1402.42-1761.543.2146.8821.47-21.0051.78-0.502125.442153.211775.431356.13140

35、2.421761.543.2146.8821.4721.0051.780.50330.29334.61275.90210.74217.94273.74225.50225.50225.50225.50225.50225.50小小小大大小22.7953.2132.4721.0051.7817.163.2146.8821.471.8748.830.500.140.880.660.090.940.03-1.00-1.00-1.00-1.00-1.001.00-0.14-0.88-0.66-0.09-0.940.0320.0020.000.680.670.821.071.030.820.680.670.

36、821.001.000.8212.0012.0012.0012.0012.0012.000.660.440.500.670.420.710.700.700.700.700.700.7197.42141.7858.0049.11117.0730.892.011.683.023.932.234.8332.0262.6968.7657.8280.8358.770.020.030.040.040.060.0320.0220.030.040.040.060.03205.02205.03185.04185.04185.06185.03520420926522574459483003696413116344

37、422172272481126291-762.82-730.66-1391.72-1461.03-1465.27-1398.04405.00405.00405.00405.00405.00405.00-317764.67-255888.10-1476951.70-2315663.74-2222847.23-1504836.630.840.840.830.260.430.82-9.E+07-9.E+07-2.E+081.E+07-1.E+08-2.E+08-823.16-777.90-1770.9287.33-967.21-1785.06-823.16-777.90-1770.92-1461.0

38、3-1465.27-1785.063f183f183f183f183f183f18763.00763.00763.00763.00763.00763.000.680.670.821.071.030.820.680.670.821.001.000.822.011.683.023.932.234.83405.0032.0262.6968.7657.8280.8358.770.020.030.040.040.060.0320.0220.030.040.040.060.03205.02205.03185.04185.04185.06185.0352042092652257445948300369641

39、3116344422172272481126291-762.82-730.66-1391.72-1461.03-1465.27-1398.04405.00405.00405.00405.00405.00405.00405.00405.00405.00405.00405.00405.003f183f183f183f183f183f18763.00763.00763.00763.00763.00763.001.101.101.101.101.101.10满足满足满足满足满足满足405.00调整后的弯矩-249.61-249.61-249.61171819202122-1789.31-1633.44

40、-1679.72-1256.76-1618.23-1017.09-47.58-4.31-55.01249.61-249.61249.611789.311633.441679.721256.761618.231017.0947.584.3155.01249.61249.61249.61278.06253.84261.03195.30251.47158.06225.50225.50225.50225.50225.50225.50000101-1789.31-1633.44-1679.72-1256.76-1618.23-1017.0943.17-16.9155.87-212.67245.60-21

41、5.491789.311633.441679.721256.761618.231017.0943.1716.9155.87212.67245.60215.49278.06253.84261.03195.30251.47158.06225.50225.50225.50225.50225.50225.50小小小大小大47.5816.9155.87249.61249.61249.6143.174.3155.01212.67245.60215.490.910.250.980.850.980.86-1.001.00-1.00-1.00-1.00-1.00-0.910.25-0.98-0.85-0.98-

42、0.860.810.890.861.150.891.420.810.890.861.000.891.0012.0012.0012.0012.0012.0012.000.430.780.400.440.400.440.700.780.700.700.700.7084.3232.83105.47629.75489.08778.142.384.892.181.231.261.1979.3464.1885.14214.68220.76207.060.040.040.050.170.140.200.040.040.050.170.140.20185.04185.04185.05185.17185.141

43、85.20484850251462396228469457638392549452460002783336628442-1385.12-1442.76-1429.05-1439.94-1445.14-1335.67405.00405.00405.00405.00405.00405.00-1449073.70-1760985.77-1668191.47-2512703.19-1789715.83-2992133.190.830.760.79-1.000.751.78-2.E+08-2.E+08-2.E+082.E+09-2.E+08-3.E+07-1756.09-1863.90-1848.4716648.67-1861.57-235.79-1756.09-1863.90-1848.47-1439.94-1