Excel板钢钢筋下料计算表
板钢筋用量计算表
1板面筋1 2.65 2.6500.394 1.0442板底筋1 4.45 4.4500.394 1.7533板底筋1 4.45 4.4500.394 1.7534板底筋1 4.45 4.4500.394 1.7535板底筋1 4.45 4.4500.394 1.7536板底筋1 4.45 4.4500.394 1.7537板底筋1 4.45 4.4500.394 1.7538板底筋1 4.45 4.4500.394 1.7539板底筋1 4.45 4.4500.394 1.75310板底筋1 4.45 4.4500.394 1.75311板底筋1 4.45 4.4500.394 1.75312板底筋1 2.95 2.9500.394 1.16213板底筋1 3.25 3.2500.394 1.28114板底筋2 4.458.9000.394 3.50715板底筋1 4.45 4.4500.394 1.75316板底筋1 4.45 4.4500.2220.98817板底筋1 4.45 4.4500.394 1.75318板底筋7 4.4531.1500.39412.27319板底筋1 1.81 1.8100.3940.71320板底筋1 1.81 1.8100.2220.40221板底筋2 4.398.7800.222 1.94922板底筋324.45142.4000.39456.106板钢筋用量计算表工程名称:板钢筋用量计算表2500757544504450445044504450445044504450445044504450445044504450445044502950325018101810439023板底筋3 6.2518.7500.3947.38824板底筋33 2.9597.3500.39438.35625板底筋231 4.45########0.394405.01226板底筋26 3.5592.3000.39436.36627板底筋260.8522.1000.3948.70728板底筋26 2.6568.9000.39427.14729板底筋70 1.75122.5000.22227.19530板底筋35 2.6592.7500.22220.59131板底筋1 5.05 5.0500.222 1.12132板底筋9 5.0545.4500.39417.90733板底筋4 2.058.2000.394 3.23134板底筋350.8529.7500.222 6.60535板底筋1 5.05 5.0500.222 1.12136板底筋12 2.6531.8000.39412.52937板底筋364 4.45########0.394638.20138板底筋176.25106.2500.39441.86339板底筋13 1.0613.7800.6178.50240构造分布筋4 2.489.9200.222 2.20241板面筋13 1.7522.7500.3948.96442构造分布筋7 2.4817.3600.222 3.85443板面筋10.850.8500.3940.33544板面筋20 2.6352.6000.39420.72445构造分布筋11 2.4827.2800.222 6.05646板面筋1 1.50 1.5000.3940.59147构造分布筋4 2.489.9200.394 3.90848板面筋13 1.5019.5000.61712.03249构造分布筋62.4814.8800.2223.3031600757524807575135075751350757544504450295062506250355026502650265017505050505050502050248024802480248024808508509107575700757550构造分布筋72.1214.8400.2223.29451板面筋7 1.339.3100.394 3.66852构造分布筋52.1210.6000.222 2.35353板面筋13 1.2115.7300.394 6.19854构造分布筋52.1210.6000.222 2.35355板面筋1 2.05 2.0500.3940.80856板面筋40 2.65106.0000.39441.76457板面筋2 2.63 5.2600.6173.24558板面筋1 1.50 1.5000.6170.92659板面筋1 1.51 1.5100.3940.59560板面筋10 1.5115.1000.394 5.94961构造分布筋61.14 6.8400.222 1.51862板面筋62.6515.9000.6179.81063构造分布筋11 1.1412.5400.222 2.78464板面筋6 1.7510.5000.394 4.13765构造分布筋71.147.9800.222 1.77266板面筋6 1.06 6.3600.617 3.92467构造分布筋41.14 4.5600.222 1.01268板面筋 1.510.0000.6170.00069构造分布筋24 1.1427.3600.222 6.07470板面筋1 1.51 1.5100.3940.59571板面筋1 2.65 2.6500.394 1.04472板面筋60.91 5.4600.394 2.15173构造分布筋41.14 4.5600.222 1.01274板面筋12.212.2100.3940.87125007575250075751350757511807575106075751900757524807575136075751360757513607575250075751600757513607575206075752120212021201140114011401140114011409107575760757575板面筋6 1.297.7400.394 3.05076构造分布筋51.14 5.7000.222 1.26577板面筋62.0812.4800.394 4.91778板面筋81.149.1200.2222.02579板面筋1 1.29 1.2900.6170.79680板面筋10.610.6100.3940.24081构造分布筋91.1410.2600.2222.27882板面筋6 1.14 6.8400.394 2.69583构造分布筋51.14 5.7000.222 1.26584板面筋1 1.14 1.1400.6170.70385板面筋12.05 2.0500.3940.80886板面筋6 2.6515.9000.6179.81087构造分布筋11 1.1412.5400.222 2.78488构造分布筋51.14 5.7000.3942.24689板面筋12 1.7521.0000.61712.95790构造分布筋141.1415.9600.222 3.54391板面筋1 1.91 1.9100.3940.75392板面筋6 1.9111.4600.6177.07193构造分布筋81.149.1200.2222.02594板面筋1 1.14 1.1400.6170.70395板面筋61.458.7000.394 3.42896板面筋242.6563.6000.61739.24197构造分布筋44 1.1450.1600.22211.13698板面筋10.760.7600.6170.46999构造分布筋101.1411.4000.2222.53125007575250075751600757575751140757519307575114075751900757517607575176075751140114011401140114011401140114011401140145046075759907575990757599075756107575100板面筋18 1.7531.5000.61719.436101构造分布筋211.1423.9400.222 5.315102板面筋362.6595.4000.61758.862103构造分布筋66 1.1475.2400.22216.703104构造分布筋121.1413.6800.222 3.037105板面筋182.6547.7000.61729.431106构造分布筋331.1437.6200.2228.352107板面筋9 1.5113.5900.6178.385108板面筋12 1.7521.0000.61712.957109构造分布筋14 1.1415.9600.2223.543110构造分布筋91.1410.2600.2222.278111板面筋1 1.15 1.1500.3940.453112板面筋2 1.06 2.1200.617 1.308113板面筋13 1.3117.0300.394 6.710114构造分布筋52.5012.5000.222 2.775115板面筋1 1.45 1.4500.3940.571116板面筋10.840.8400.3940.331117板面筋78 2.65206.7000.617127.534118构造分布筋882.50220.0000.22248.840119板面筋39 1.4556.5500.61734.891120构造分布筋182.5045.0000.2229.990121板面筋2 1.45 2.9000.617 1.789122板面筋39 1.7568.2500.39426.891123板面筋10.840.8400.6170.518124板面筋521.7591.0000.61756.14716007575250075752500757525007575160075751600757516007575136075751000757511607575130075751300757513007575114011401140114011401140250025002500910757569075756907575125构造分布筋422.50105.0000.22223.310126板面筋3 1.75 5.2500.617 3.239127板面筋2 1.06 2.1200.3940.835128板面筋13 1.5119.6300.61712.112129构造分布筋62.5015.0000.2223.330130板面筋11 1.5116.6100.61710.248131板面筋20 2.6553.0000.61732.701132板面筋130.9111.8300.6177.299133构造分布筋42.5010.0000.222 2.220134板面筋10.910.9100.6170.561135板面筋1 1.15 1.1500.6170.710136板面筋10.610.6100.2220.135137构造分布筋25 2.5062.5000.39424.625138板面筋13 1.3817.8750.3947.043139板面筋133.9551.3500.39420.232构件编号:NB11板面筋11 1.5016.5000.394 6.5012构造分布筋1 1.35 1.3500.2220.3003构造分布筋2 3.30 6.6000.222 1.4654板面筋17 4.4575.6500.39429.8065板底筋34 4.45151.3000.39459.6126构造分布筋2 4.509.0000.222 1.9987构造分布筋7 2.3016.1000.222 3.5748板面筋12 1.2114.5200.394 5.7219构造分布筋112.3025.3000.222 5.61710板面筋121.7521.0000.61712.95713507575106075752500757516007575160075751360757513607575100075754450445025002500250025001375395013503300450023002300910757576075757607575460757511板底筋11.81 1.8100.3940.71312板面筋22.63 5.2600.6173.24513板底筋14.39 4.3900.394 1.73014板面筋1 1.14 1.1400.3940.44915构造分布筋12.50 2.5000.2220.55516板面筋13 2.0526.6500.39410.50017板面筋17 1.5125.6700.39410.11418板底筋14.45 4.4500.394 1.75319板面筋1 2.65 2.6500.617 1.63520板面筋13 1.5119.6300.61712.11221板面筋26 6.25162.5000.39464.02522板底筋26 2.6568.9000.39427.14723板底筋1 2.95 2.9500.394 1.16224板底筋1 4.45 4.4500.394 1.75325构造分布筋12 2.5030.0000.222 6.66026板面筋32 2.6584.8000.61752.32227构造分布筋26.3012.6000.222 2.79728板面筋1 1.45 1.4500.6170.89529板面筋39 2.65103.3500.61763.76730构造分布筋6 2.5015.0000.222 3.33031构造分布筋8 1.7013.6000.222 3.01932板面筋110.9110.0100.617 6.17633板底筋150.8512.7500.222 2.83134板底筋114.4548.9500.39419.28635板面筋11.511.5100.6170.93224807575136075752500757525007575250075751360757513607575190075751300757544504450445029501810439062502650250025002500630017008509907575760757536板面筋44 2.65116.6000.39445.94037板底筋11 4.4548.9500.39419.28638构造分布筋222.1046.2000.22210.25639板面筋3 2.657.9500.617 4.90540板底筋42.6510.6000.394 4.17641板面筋1 1.06 1.0600.6170.65442板底筋66.2537.5000.39414.77543板面筋3 1.51 4.5300.617 2.79544板面筋11 1.0611.6600.6177.19445板面筋11 1.5116.6100.61710.24846构造分布筋122.1025.2000.222 5.59447板面筋110.9110.0100.3943.94448板面筋22 3.5578.1000.39430.77149构造分布筋102.1021.0000.222 4.66250板面筋3 1.293.8700.617 2.38851板面筋1 1.15 1.1500.3940.45352板面筋1 1.15 1.1500.3940.45353板面筋33 1.7557.7500.61735.63254构造分布筋12 2.1025.2000.222 5.59455板底筋11 1.7519.2500.3947.58556构造分布筋5 2.1010.5000.222 2.3315715.05 5.0500.222 1.12158板面筋1 1.45 1.4500.3940.57159板面筋11 1.7519.2500.3947.58560构造分布筋142.1029.4000.2226.5271600757525007575250075751600757513607575136075751140757510007575130075751000757544506250355026501750505021002100210021002100210091075759107575760757561板底筋55 4.45244.7500.39496.43262构造分布筋6 1.7010.2000.222 2.26463板底筋15 1.7526.2500.222 5.82864构造分布筋21 2.1044.1000.2229.79065板底筋22 2.6558.3000.39422.97066构造分布筋7 1.6411.5010.222 2.55367板面筋2 1.75 3.5000.617 2.16068板底筋4 5.0520.2000.3947.95969构造分布筋20.90 1.8000.2220.40070板面筋10.610.6100.6170.37671构造分布筋20.90 1.8000.2220.40072板面筋51.457.2500.6174.473构件编号:NB11板面筋13 1.7522.7500.3948.9642板面筋17 4.4575.6500.22216.7943构造分布筋5 2.5012.5000.222 2.7754板底筋20 4.4589.0000.22219.7585构造分布筋62.5015.0000.2223.3306板面筋1 1.50 1.5000.6170.9267板底筋1 2.95 2.9500.394 1.1628板面筋20 2.6553.0000.39420.8829板底筋13 4.4557.8500.39422.79310构造分布筋7 2.5017.5000.222 3.88511板底筋39 4.45173.5500.39468.37912板底筋20 4.4589.0000.39435.06613构造分布筋442.50110.0000.22224.42014板面筋12.652.6500.3941.04425007575250075751600757513507575160075751300757544504450445044504450445029502650175050502500250025002500170021001643900900460757515板面筋1 1.51 1.5100.6170.93216板面筋13 1.7522.7500.61714.03717板面筋13 2.6534.4500.61721.25618板面筋13 1.9124.8300.61715.32019构造分布筋6 2.5015.0000.222 3.33020板底筋32 4.45142.4000.39456.10621板底筋32 4.45142.4000.39456.10622板底筋324.45142.4000.39456.10623板面筋1 1.91 1.9100.617 1.17824板面筋32 2.6584.8000.61752.32225板底筋32 4.45142.4000.39456.10626板底筋4 2.6510.6000.394 4.17627板底筋56.2531.2500.39412.31328板面筋1 1.51 1.5100.6170.93229构造分布筋3 6.3018.9000.222 4.19630板面筋32 1.7556.0000.61734.55231构造分布筋55 6.30346.5000.22276.92332构造分布筋60.93 5.5500.222 1.23233板底筋1 4.45 4.4500.394 1.75334板底筋1 4.45 4.4500.394 1.75335板底筋1 4.45 4.4500.394 1.75336构造分布筋30.93 2.7750.2220.61637板底筋152.6539.7500.39415.66238板面筋5 1.06 5.3000.6173.27039板底筋106.2562.5000.39424.62540板面筋51.517.5500.6174.658757525007575250075751600757516007575136075751360757513607575176075751760757544504450445044504450445044506250625026502650250063006300925925910757541板面筋1 1.06 1.0600.6170.65442构造分布筋220.9320.3500.222 4.51843板底筋1 4.45 4.4500.394 1.75344构造分布筋20.93 1.8500.2220.41145板面筋30 2.6579.5000.61749.05246板底筋52.0510.2500.394 4.03947板面筋1 1.45 1.4500.6170.89548构造分布筋11 4.5049.5000.22210.98949构造分布筋14.50 4.5000.2220.99950板面筋23 2.6560.9500.61737.60651板面筋23 1.5134.7300.61721.42852板面筋7 1.4510.1500.617 6.26353板面筋14 2.6537.1000.61722.89154构造分布筋1 1.36 1.3600.2220.30255构造分布筋6 1.368.1600.222 1.81256构造分布筋11 1.3614.9600.222 3.32157板底筋14 4.4562.3000.39424.54658构造分布筋6 1.368.1600.222 1.81259板底筋12.05 2.0500.3940.80860板面筋9 2.6523.8500.61714.71561板底筋35.0515.1500.394 5.96962板面筋61.519.0600.6175.590构件编号:NB11板底筋23 6.25143.7500.39456.6382板面筋1 2.65 2.6500.394 1.0443构造分布筋64.5027.0000.2225.9942500757525007575250075752500757525007575757513607575136075751300757513007575445044506250505020502050450045004500136013601360136092592591075754板面筋23 2.6560.9500.61737.6065构造分布筋6 4.5027.0000.222 5.9946构造分布筋7 1.7712.4040.222 2.7547板底筋1 6.25 6.2500.394 2.4638板底筋14 4.4562.3000.39424.5469构造分布筋1 2.58 2.5760.2220.57210构造分布筋12.50 2.5000.2220.55511板面筋13 1.5119.6300.3947.73412构造分布筋1 2.50 2.5000.2220.55513板底筋32 4.45142.4000.39456.10614板底筋1 6.25 6.2500.394 2.46315板面筋2 1.513.0200.617 1.86316板面筋32 1.7556.0000.61734.55217构造分布筋36.3018.9000.222 4.19618板面筋32 2.6584.8000.61752.32219构造分布筋11 4.5049.5000.22210.98920构造分布筋64.5027.0000.2225.99421板面筋3 2.657.9500.617 4.90522板底筋1 4.45 4.4500.394 1.75323板底筋1 4.45 4.4500.394 1.75324板面筋13 1.5119.6300.61712.11225板面筋1 1.75 1.7500.617 1.08026构造分布筋62.5015.0000.2223.33027板面筋2 2.65 5.3000.617 3.27028构造分布筋12 2.5030.0000.222 6.66029板底筋14.454.4500.3941.7532500757525007575250075752500757516007575160075751360757513607575136075754450445044504450445062506250250025002500250045004500450063001772257630构造分布筋1 2.50 2.5000.2220.55531板底筋1 4.45 4.4500.394 1.75332构造分布筋3 2.507.5000.222 1.66533板面筋39 2.65103.3500.39440.72034板面筋65 2.65172.2500.617106.27835板面筋39 1.5158.8900.61736.33536板底筋65 6.25406.2500.394160.06337板面筋13 1.5119.6300.61712.11238板面筋1 1.75 1.7500.617 1.08039构造分布筋55 2.50137.5000.22230.52540构造分布筋6 2.5015.0000.222 3.33041构造分布筋3 2.507.5000.222 1.66542构造分布筋6 2.5015.0000.222 3.33043构造分布筋11.60 1.6000.2220.35544板面筋2 1.51 3.0200.617 1.86345构造分布筋6 1.609.6000.2222.13146板底筋6 4.4526.7000.39410.52047板底筋21.603.2000.2220.71025007575160075751360757513607575136075754450445062502650250025002500250025002500160016001600。
钢筋工程量计算表(EXCEL)
底部横筋 上部弯矩筋 3.05 2.14 0.08 0.015 ④ 分布 分布 上部负弯矩筋 ② 分布 分布 TL1 0.25 0.38 1.26 0.025 上部 下部 箍筋 TL2 0.25 0.35 1.2 0.025 上部 下部 箍筋 TB1 0.015 底部纵筋 顶部纵筋 顶部纵筋 横向钢筋 TB2 0.015 底部纵筋 顶部纵筋 顶部纵筋 L1 0.25 3.4 3.4 L2 0.25 1.5 1.5 LZ 0.25 0.35 2.432 0.025 0.3 1.1 0.025 0.35 1.2 0.025 上部 下部 箍筋 上部 下部 箍筋 主筋 箍筋 5#楼梯 DB1 3.05 1.5 0.08 0.015 底部纵筋 底部横筋 上部负弯矩筋 3.05 1.5 0.08 0.015 ③ 分布
0.008 0.012 0.012 0.012 0.006 0.01 0.01 0.01 0.016 0.016 0.008 0.014 0.014 0.008 0.014 0.008
0.1 0.11 0.11 0.11 0.2 0.12 0.12 0.12
0.1
0.1
0.008 0.008 0.008 0.006 0.008 0.006 0.006 0.008 0.008 0.008 0.006 0.008 0.006 0.006 0.016 0.016
0.2
DB4
2.36
1.68
0.08
0.015
底部纵筋 底部横筋 洞口加筋 洞口加筋
0.2 0.15
上部负弯矩筋
③ 分布 分布
0.2
TL1
0.25
0.45
1.4
0.025
上部 下部 箍筋
0.1
TL2
钢筋计算表格excel
钢筋计算表格是用于记录和计算钢筋材料用量、长度、重量等参数的表格。
使用Excel软件可以方便地制作钢筋计算表格，并利用公式进行自动计算。
以下是一个简单的钢筋计算表格示例：
在Excel中制作表格时，可以利用单元格引用和公式进行自动计算。
例如，在“总长度(m)”列中，可以输入公式“=长度(m) * 数量”，在“总重量(kg)”列中，可以输入公式“=钢筋类型列中的重量(kg/m) * 总长度(m)”。
通过这种方式，可以自动计算出每种钢筋的总长度和总重量。
此外，还可以利用Excel的筛选和排序功能，对表格中的数据进行筛选和排序，以便更好地管理和分析钢筋材料用量。
同时，还可以利用Excel的图表功能，将数据可视化，以便更直观地了解钢筋材料的用量情况。
钢筋下料表格(带图)附手算钢筋公式汇总表
10847.085钢筋钢筋钢筋单位构件单件合计钢筋各部位尺寸Total 弯曲下料重量构件名称钢筋代码编号型号直径重量数量钢筋根数a b c d e Length 扣除长度(kg)(mm)(kg/m)根数(mm)(mm)(mm)(mm)(mm)(mm)(mm)(mm)基础J-I 网片Φ1414 1.20821836A 17301730173075.260KZ1KZ1Φ2525 3.85321224K 100430010045001254375404.603GZ1GZ1Φ1414 1.2084416B 1501700185035181535.092GZ2Φ12120.88813452B 1501700185030182084.023一层GZ1Φ1414 1.2084416B 2003900410035406578.595GZ2Φ12120.88813452B 20039004100304070187.897构造柱箍筋Φ６60.2221730510J 1901909407586597.915柱箍筋Φ８80.39523264J 3503501640100154038.890LL-1LL-1Φ2020 2.466166B 25087509000508950132.432LL-1Φ2020 2.466166B 2503800405050400059.188LL-1Φ10100.617122A 11350113501135013.995拉筋Φ８80.39512222K 502105031040270 2.344箍筋Φ８80.3951110110J 4002001440100134058.162圈梁A1-2Φ12120.888144B 2003700390030387013.743A7-8Φ12120.888144B 2004600480030477016.939B Φ12120.888144C 2004400200480060474016.833C Φ12120.888144C 2003500200390060384013.637D E Φ12120.888248B 2008800900030897063.710Φ12120.888248B 2002300200270030267018.964Φ12120.888248A 90009000900063.9231 ， 8Φ12120.888248B 2008800900030897063.710Φ12120.888248B 20090011003010707.6002, 7Φ12120.888248C 2006150200655060649046.0953 4 5 6Φ12120.8884416C 2003150200355060349049.576箍筋Φ６60.222111J 190190940758650.192屋面Ｌ1LI Φ2222 2.984133B 2508750900055894580.077L1Φ2222 2.984133B 2503800405055399535.764L1Φ2525 3.853144B 2508750900062.58937.5137.758L1Φ2525 3.853144B 2503800405062.53987.561.461L1构造筋Φ10100.617144A 11400114001140028.114L1拉筋Φ８80.39512020K 702107035040310 2.446L2Φ2222 2.9842612C 250615025066501106540234.188L2Φ2525 3.853248C 250615025066501256525201.145L2构造筋Φ10100.617144A 61006100610015.044L2拉筋Φ８80.39518080K 7021070350403109.786L1 L2箍筋Φ10100.6171230230J 55020018001251675237.521E 轴 1 8面筋Φ12120.888122B 2008800900030897015.927面筋Φ12120.888122A 90009000900015.981型式a b a c b b c a b cda ab da b a a A B C EG H aFa bc a I K c L cabb c e d b J Dc e面筋Φ12120.888122B20023002500302470 4.386底筋Φ1414 1.208133B2008800900035896532.500底筋Φ1414 1.208133A90009000900032.627底筋Φ1414 1.208133B200230025003524658.936构造筋Φ10100.617144A19000190001900046.857拉筋Φ８80.3951350350K50210503104027037.288雨棚雨棚Φ８80.3951134134L508012002580802500132.186分布筋Φ６60.222188A19000190001900033.737箍筋Φ10100.6171190190J55020018001251675196.213D QLΦ12120.888144B2008800900030897031.855QLΦ12120.888144A90009000900031.961QLΦ12120.888144B200230025003024708.772C QLΦ12120.888144C2003500200390060384013.637B QLΦ12120.888144C2004400200480060474016.833A QLΦ12120.888144B2003700390030387013.743QLΦ12120.888144B2004600480030477016.939箍筋Φ６60.2221410410J1901909407586578.716板钢筋A-D1~2Φ10100.61713030C70340070354050349064.551 1~2Φ10100.61711616C70610070624050619061.0627~8Φ10100.61713030C70430070444050439081.198Φ10100.61712020C70610070624050619076.327 2~7Φ10100.61717070C706100706240506190267.146Φ10100.61714242C701050070106405010590274.224D E1~8Φ10100.61719090C703100703240503190177.008Φ10100.61711414C701900070191405019090164.776面筋Φ10100.6171100100C709100709240509190566.598Φ10100.61715353C701900070191405019090623.794棚柱Φ1414 1.208444176A200020002000425.362Φ2525 3.85341664B1501800195062.51887.5465.486箍筋Φ10100.61741768J65065029001252775116.341箍筋Φ10100.617817136J33065022601252135179.018压墙筋Φ６60.2221718306C50100050110030107072.672女儿墙Φ12120.88816464B1506007503072040.910Φ10100.6171110110J44025016801251555105.459 KL9-01Φ1616 1.578248C16240240164808016400207.078 KL9-02Φ1616 1.578224C16240240164808016400103.539 KL9-03Φ1616 1.578224B1755240199540195512.343 KL9-04Φ1616 1.578224B100524012454012057.608 KL9-05Φ1616 1.578224A35253525352522.255 KL9-06Φ1616 1.578224A27752775277517.520 KL9-07Φ10100.6172110220J44025016801251555210.917 KL10-01Φ1818 1.998144C16240270165109016420131.201 KL10-02Φ1818 1.998122C1624027016510901642065.601 KL10-03Φ1818 1.998111B17552401995451950 3.895 KL10-04Φ1818 1.998111B10052401245451200 2.397 KL10-05Φ2020 2.466122A35253525352517.386 KL10-06Φ1818 1.998122A27752775277511.087 KL10-07Φ10100.6171110110J44025016801251555105.459 KL11-01Φ1616 1.5784416C9940270102108010130255.817KL11-02Φ1616 1.578428C9940240101808010100127.530 KL11-03Φ1616 1.578428B1505240174540170521.529 KL11-04Φ1616 1.578428B1355240159540155519.634 KL11-05Φ1616 1.578428A31603160316039.900 KL11-06Φ10100.617460240J44025016801251555230.092板钢筋XBA-011Φ８80.39513232G5450505500550069.447 ZXBA-022Φ８80.39512323G6250506300630057.175 ZXBB-013Φ８80.39513737G5450505500550080.298 ZXBB-024Φ８80.39512424G7150507200720068.184 ZXBC-015Φ８80.39513232G4650504700470059.345 ZXBC-026Φ８80.39512424G6250506300630059.661 ZXBD-017Φ８80.39513535G2250502300230031.764 ZXBD-028Φ８80.39511212G7150507200720034.092 ZXDE-019Φ８80.39513535G2250502300230031.764 ZXDE-0210Φ８80.39511313G7150507200720036.933 ZXDF-0111Φ８80.39511717G4650504700470031.527 ZXDF-0212Φ８80.39512424G3250503300330031.251 ZXDG-0113Φ８80.39513939G1700501750175026.930 ZXDG-0214Φ８80.395188G7750507800780024.622 ZXDH-0115Φ８80.39513939G4650504700470072.327 ZXDH-0216Φ８80.39512424G7750507800780073.866 FXDA-011Φ８80.39515555G1850501900190041.234 FXDA-022Φ８80.39516060G1500501550155036.696 FXDA-033Φ８80.39515555G3300503350335072.702 FXDA-044Φ８80.39516060G2700502750275065.106 FXDC-015Φ８80.39513030G1800501850185021.899 FXDC-026Φ８80.39511414G2300502350235012.982 FXDC-037Φ８80.39515151G1450501500150030.186 FXDC-048Φ８80.39511414G2300502350235012.982 FXDE-019Φ８80.39513535G8005085085011.739 FXDE-0210Φ８80.39513535G1300501350135018.644 FXDE-0311Φ８80.39511111G13005013501350 5.860 FXDE-0412Φ８80.39511111G13005013501350 5.860 FXBB-0113Φ10100.61715858G2200502250225080.458 FXBB-0214Φ８80.39515555G2000502050205044.489 FXBB-0315Φ10100.61715858G1550501600160057.215 FXBF-0116Φ８80.39511616G80050850850 5.366 FXBF-0217Φ８80.39511616G80050850850 5.366 FXBF-0318Φ８80.39513030G2500502550255030.186 FXBG-0119Φ８80.395188G80050850850 2.683 FXBG-0220Φ10100.61715050G2300502350235072.443 FXBG-0321Φ８80.395188G80050850850 2.683 FXBH-0122Φ10100.61712020G2200502250225027.744 FXBH-0223Φ10100.61713030G1800501850185034.218 FXBO-011Φ６60.222155G1290050129501295014.371 FXBO-022Φ６60.222156G1290050129501295017.246 FXBO-033Φ６60.222156G1290050129501295017.246REF. SHOP DWG. NO.Total 479.863Weight 10847.085PREPAR EDREV.0.INITIAL DATE REVISIONBBS-1SH-LW-SC-001a LiAPPROVED 2003/7/12FOR APPROVAL。
钢筋工程量计算表(EXCEL)_xls
0.016 0.016 0.016 0.016
0.016 0.016 0.014 0.014 0.014
3.05 1.5
0.08
3.05
上部负弯矩筋
1.5
0.08
0.015 底部纵筋 0.008
底部横筋 0.008
③
0.008
0.015 分布
0.006
0.15 0.2
0.2
0.1
0.1 0.11 0.11 0.11
0.008
0.025 上部
下部
箍筋
0.008
0.015 底部纵筋 0.012
顶部纵筋 0.012
顶部纵筋 0.012
横向钢筋 0.006
0.015 底部纵筋 0.01
顶部纵筋 0.01
顶部纵筋 0.01
0.025 上部
下部
箍筋
0.008
0.025 上部
下部
箍筋
0.008
0.025 主筋
箍筋
0.008
3.05 2.14
0.08
0.015 底部纵筋 0.008
底部横筋 0.008
③
0.008
0.015 分布
0.006
分布
0.006
①
0.008
分布
0.006
分布
0.006
0.015 底部纵筋 0.008
0.2 0.17
0.2
0.2
0.2
TL1 TL2
TB1
TB2 L1 L2
LZ 5#楼梯
DB1
上部负弯矩筋 3.05 2.14 0.08
下部
箍筋
0.008
0.025 上部
Excel钢筋工程量自动计算表格
（2400+200-35+300-2*35+41*16）/1000
同上
#NAME? （2400+200+400-40-35-700+300-2*35）/1000
内侧纵筋2-2 三级 16 （（3100+600-2*35）/150+1）*2 #NAME?
同内侧纵筋1-1
外侧纵筋2-2 三级 16
同上
51
根数
#NAME? #NAME? #NAME?
钢筋长计算式m
（3100+2*41*16）/1000 （2000+2*41*16）/1000 （700+700+2*11.9*16）/1000
单根长度m 总长mLeabharlann #NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
2 侧面钢筋
下部架立筋1-1 三级 16
同上部筋1-1
18
（3100-2*35-700*2+2*150）/1000
下部架立筋2-2 三级 16
同上部筋2-2
26
（2600-2*35-700*2+2*150）/1000
内侧纵筋1-1 （两侧）
外侧纵筋1-1 （两侧）
三级 16 三级 16
（（2600-2*35）/150+1）*2 #NAME?
支线增加设计钢筋 工程量计算稿
工程名称：检查井DN600
序号 构件名称
位置 编号 直径
保护层厚度 顶板为30mm；底板下部40mm；其余35mm
1 底板配筋
上部筋1-1
三级 16
上部筋2-2
三级 16
钢筋预算(结算)自动计算表格(EXCEL)
0
0
0
15 0
33
0
0
00
0
0
0
0
15 0
33
0
0
00
0
0
0
0
15 0
33
0
0
0
00
0.617
0.0
0
0
0
0
0
0.617
0.0
0
0
0
0
0
0.617
0.0
0
0
0
0
0
Байду номын сангаас
0.617
0.0
0 备注
*
锚固倍数
1级 钢
2级 钢
3,4 级 钢
抗 震 等 级
砼 强 度
C20~ A B C,D 1~4 C40
以上
28 33 40 1 30 28 33 40 1 30 28 33 40 1 30 28 33 40 1 30
%
顺正
直反
BCDE
多个公式 公式/1000
3级 2级 丝 丝 钢筋 钢筋
kg
1级钢筋
A 2级钢筋
B 3级钢筋
C
冷轧带肋筋 D
构件编号
操 作
111 0
111 0
111 0
111 0
把此工 作表做 次工作 表的梁
D 10 0 B 10 0 B 10 0 B 10 0
0
0
00
0
0
0
0
15 0
40
0
0
00
0
第 1 页，共 1 页
工程名称：
工作表1
钢筋下料EXCEL格式2
钢筋下料EXCEL格式21/19 STRUCTURE:（结构名称）SCHEDULER(开料人）2/19 STRUCTURE:（结构名称）SCHEDULER(开料人）3/19 STRUCTURE:（结构名称）SCHEDULER(开料人）4/19 STRUCTURE:（结构名称）SCHEDULER(开料人）5/19 STRUCTURE:（结构名称）SCHEDULER(开料人）6/19 STRUCTURE:（结构名称）SCHEDULER(开料人）7/19 STRUCTURE:（结构名称）SCHEDULER(开料人）8/19 STRUCTURE:（结构名称）SCHEDULER(开料人）9/19 STRUCTURE:（结构名称）SCHEDULER(开料人）10/19 STRUCTURE:（结构名称）SCHEDULER(开料人）11/19 STRUCTURE:（结构名称）SCHEDULER(开料人）12/19 STRUCTURE:（结构名称）SCHEDULER(开料人）13/19 STRUCTURE:（结构名称）SCHEDULER(开料人）14/19 STRUCTURE:（结构名称）SCHEDULER(开料人）15/19 STRUCTURE:（结构名称）SCHEDULER(开料人）16/19 STRUCTURE:（结构名称）SCHEDULER(开料人）17/19 STRUCTURE:（结构名称）SCHEDULER(开料人）18/19 STRUCTURE:（结构名称）SCHEDULER(开料人）19/19MAIN CONTRACTOR:(总包）SCHEDULENO(料表编号）PROJECT:(项目名称）DRAWING NO(图号）STRUCTURE:（结构名称）SCHEDULER(开料人）。
excel计算大全-钢结构计算表格-钢管结构计算程序
钢管外径d (mm) 管壁厚度t (mm) 钢材抗压强度设计值f (N/mm2) 钢材屈服强度值fy (N/mm2) 钢材弹性模量E (N/mm2) 820 16.0 315 345 2.06E+05 轴心压力N (KN) 最大弯矩Mx (KN· m) 计算长度l0x (mm) 计算长度l0y (mm) 等效弯矩系数β m 2000.00 500.00 30000 30000 1.0
b类 0.965 7.4E+03 0.398 1.0000 194.17 满足
验算 N/ψ yA+0.7Mx/W ≤ φ f
数据输出
一、常规数据
钢管内径d1=d-2t (mm) 4 4 4 截面惯性矩I=π *(d -d1 )/64 (mm ) 截面回转半径i=(I/A)1/2 (mm) 塑性发展系数γ 788 3.27E+09 284.31 1.15 截面面积A=π *(d2-d12)/4 (mm2) 3 截面抵抗矩W=2I/d (mm ) 构件长细比λ x=l0x/i 构件长细比λ y=l0y/i 4.0E+04 7.97E+06 105.5 105.5
二、径厚比验算
验算 d/t ≤ 100*(235/fy) 满足
三、刚度验算
构件容许长细比[λ ] 150 刚度验算 Max[λ x,λ y]<[λ ] 满足
四、强度验算 五、稳定性验算
N/A+M/γ W (N/mm )
2
104.06
验算 N/A+M/γ W ≤ f
满足
⒈弯矩平面内 1.375 构件所属的截面类型 λ x'=(fy/E)1/2*λ x/π 系数α 1 系数α 2 0.600 系数α 3 0.300 欧拉临界力NEx=π 2EA/λ x2 (KN) 当λ x'＞0.215时，稳定系数ψ x={(α 2+α 3λ x'+λ x'2)-[(α 2+α 3λ x'+λ x'2)2-4λ x'2]1/2}/2λ x'2 当λ x'≤0.215时，稳定系数ψ x=1-α 1λ x'2 局部稳定系数φ =1 （d/t≤60时）；φ =1.64-0.23*(d/t)1/4 （d/t>60时） N/ψ xA+β mMx/γ W(1-0.8N/NEx) (N/mm2) 验算 N/ψ xA+β mMx/γ W(1-0.8N/NEx) ≤ φ f ⒉弯矩平面外 不需验算 λ y'=(fy/E)1/2*λ y/π 当λ y'〉0.215时，稳定系数ψ y={(α 2+α 3λ y'+λ y'2)-[(α 2+α 3λ y'+λ y'2)2-4λ y'2]1/2}/2λ y'2 当λ y'≤0.215时，稳定系数ψ y=1-α 1λ y'2 N/ψ yA+0.7Mx/W (N/mm2)
excel计算大全-钢结构计算表格-钢管结构计算程序
数据输出
一、常规数据
钢管内径d1=d-2t (mm) 截面惯性矩I=π *(d4-d14)/64 (mm4) 1/2 截面回转半径i=(I/A) (mm) 塑性发展系数γ 581 1.16E+09 210.42 1.15 截面面积A=π *(d2-d12)/4 (mm2) 截面抵抗矩W=2I/d (mm3) 构件长细比λ x=l0x/i 构件长细比λ y=l0y/i 2.6E+04 3.81E+06 92.0 100.6
数据输入
钢管外径d (mm) 管壁厚度t (mm) 钢材抗压强度设计值f (N/mm2) 钢材屈服强度值fy (N/mm2) 钢材弹性模量E (N/mm2) 609 14.0 315 345 2.06E+05 轴心压力N (KN) 最大弯矩Mx (KN· m) 计算长度l0x (mm) 计算长度l0y (mm) 等效弯矩系数β m 354.50 274.30 19360 21160 1.0
二、径厚比验算
验算 d/t ≤ 100*(235/fy) 满足
三、刚度验算
构件容许长细比[λ ] 150 刚度验算 Max[λ x#43;M/γ W (N/mm2)
76.23
验算 N/A+M/γ W ≤ f
满足
五、稳定性验算
⒈弯矩平面内 1.199 构件所属的截面类型 λ x'=(fy/E)1/2*λ x/π 系数α 1 系数α 2 0.600 系数α 3 0.300 欧拉临界力NEx=π 2EA/λ x2 (KN) 当λ x'＞0.215时，稳定系数ψ x={(α 2+α 3λ x'+λ x'2)-[(α 2+α 3λ x'+λ x'2)2-4λ x'2]1/2}/2λ x'2 2 当λ x'≤0.215时，稳定系数ψ x=1-α 1λ x' 局部稳定系数φ =1 （d/t≤60时）；φ =1.64-0.23*(d/t)1/4 （d/t>60时） N/ψ xA+β mMx/γ W(1-0.8N/NEx) (N/mm2) 验算 N/ψ xA+β mMx/γ W(1-0.8N/NEx) ≤ φ f ⒉弯矩平面外 需要验算 λ y'=(fy/E)1/2*λ y/π 当λ y'〉0.215时，稳定系数ψ y={(α 2+α 3λ y'+λ y'2)-[(α 2+α 3λ y'+λ y'2)2-4λ y'2]1/2}/2λ y'2 当λ y'≤0.215时，稳定系数ψ y=1-α 1λ y'2 N/ψ yA+0.7Mx/W (N/mm2) b类 0.965 6.3E+03 0.484 1.0000 93.62 满足